
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Consulation',201111002,E'type_consultation.png',0, 10);
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Laboratoire',123021082,E'type_laboratory.png',0, 10);
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Irradiation',8723547,E'type_radiology.png',0, 10);
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Visite',45213198,E'type_visit.png',0, 10);
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Vacation',0,E'',1, 30);
INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Illness',0,E'',1, 30);

INSERT INTO agenda.appointment_type (name,color,icon,type_class, duration) VALUES (E'Visit',255172240,E'',2, 45);

INSERT INTO agenda.appointment_type (name,icon,type_class,duration) VALUES ('doctena.lu','type_doctena.png',0,30);



/**************** add print templates for the agenda - 1.2.00_010 ************************/
insert into core.template_type (value,sequence_number,template_file_path) values (E'agenda_template_pat',11,E'/lu/tudor/santec/gecamed/agenda/gui/templates/AgendaPatientAppointmentPrintTemplate.jasper');
insert into core.template_type (value,sequence_number,template_file_path) values (E'agenda_template_phy',12,E'/lu/tudor/santec/gecamed/agenda/gui/templates/AgendaPhysicianAppointmentPrintTemplate.jasper');

/************* insert the office/first background calendar - 1.2.00_011 ******************/
INSERT INTO agenda.calendar (title, color, user_id, physician_id, created, created_by, is_background) VALUES (E'OFFICE', -1118482, null, null,'now', null, true);