INSERT INTO core.info (date,key,value) VALUES ('now',E'CURRENT_UPDATE_STATE',E'db_update_2.07.03_001.sql');
INSERT INTO core.info (date,key,value) VALUES ('now',E'CURRENT_VERSION',E'2.07.03');

INSERT INTO core.info (date,key,value) VALUES ('now',E'INCIDENT_ENTRY_UPDATE_1','true');
INSERT INTO core.info (date,key,value) VALUES ('now',E'DATE','false');

INSERT INTO  core.title (value) VALUES (E'mister');
INSERT INTO  core.title (value) VALUES (E'madam');
INSERT INTO  core.title (value) VALUES (E'miss');

INSERT INTO  core.dr_title (value) VALUES (E'');
INSERT INTO  core.dr_title (value) VALUES (E'Dr');
INSERT INTO  core.dr_title (value) VALUES (E'Prof');
INSERT INTO  core.dr_title (value) VALUES (E'Prof Dr');

INSERT INTO  core.gender (value) VALUES (E'male');
INSERT INTO  core.gender (value) VALUES (E'female');
INSERT INTO  core.gender (value) VALUES (E'other');
INSERT INTO  core.gender (value) VALUES (E'unknown');

INSERT INTO  core.marital_status (value) VALUES (E'single');
INSERT INTO  core.marital_status (value) VALUES (E'married');
INSERT INTO  core.marital_status (value) VALUES (E'divorced');
INSERT INTO  core.marital_status (value) VALUES (E'separated');
INSERT INTO  core.marital_status (value) VALUES (E'widowed');
INSERT INTO  core.marital_status (value) VALUES (E'cohabit');
INSERT INTO  core.marital_status (value) VALUES (E'partnership');
INSERT INTO  core.marital_status (value) VALUES (E'other');

INSERT INTO  core.phone_type (value) VALUES (E'private');
INSERT INTO  core.phone_type (value) VALUES (E'mobile');
INSERT INTO  core.phone_type (value) VALUES (E'office');
INSERT INTO  core.phone_type (value) VALUES (E'fax');

INSERT INTO  core.locale (language, country) VALUES (E'en',E'US');
INSERT INTO  core.locale (language, country) VALUES (E'de',E'DE');
INSERT INTO  core.locale (language, country) VALUES (E'fr',E'FR');

INSERT INTO  core.nationality (value) VALUES (E'luxembourgish');
INSERT INTO  core.nationality (value) VALUES (E'german');
INSERT INTO  core.nationality (value) VALUES (E'french');
INSERT INTO  core.nationality (value) VALUES (E'portuguese');
INSERT INTO  core.nationality (value) VALUES (E'english');
INSERT INTO  core.nationality (value) VALUES (E'belgian');

INSERT INTO  core.language (value) VALUES (E'luxembourgish');
INSERT INTO  core.language (value) VALUES (E'german');
INSERT INTO  core.language (value) VALUES (E'french');
INSERT INTO  core.language (value) VALUES (E'portuguese');
INSERT INTO  core.language (value) VALUES (E'english');

INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-1-1',E'New Year','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-4-9',E'Easter Monday','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-5-1',E'Labour Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-5-17',E'Ascension Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-5-28',E'Pentecost','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-6-23',E'National Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-8-15',E'Assumption of Mary','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-11-1',E'All Saints Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-12-25',E'Christmas','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2007-12-26',E'St. Etienne','true');

INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-1-1',E'New Year','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-3-24',E'Easter Monday','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-5-1',E'Labour Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-5-1',E'Ascension Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-5-12',E'Pentecost','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-6-23',E'National Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-8-15',E'Assumption of Mary','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-11-1',E'All Saints Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-12-25',E'Christmas','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2008-12-26',E'St. Etienne','true');

INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-1-1',E'New Year','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-4-13',E'Easter Monday','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-5-1',E'Labour Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-5-21',E'Ascension Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-6-1',E'Pentecost','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-6-23',E'National Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-8-15',E'Assumption of Mary','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-11-1',E'All Saints Day','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-12-25',E'Christmas','true');
INSERT INTO 	core.national_holiday (day,description,legal) VALUES ('2009-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-4-5',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-5-13',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-5-24',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2010-12-26',E'St. Etienne','true');
	
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-4-25',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-6-2',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-6-13',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2011-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-4-9',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-5-17',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-5-28',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2012-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-4-1',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-5-9',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-5-20',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2013-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-4-21',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-5-29',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-6-9',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2014-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-4-6',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-5-14',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-5-25',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2015-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-3-28',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-5-5',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-5-16',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2016-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-4-17',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-5-25',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-6-5',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2017-12-26',E'St. Etienne','true');

INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-1-1',E'New Year','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-4-2',E'Easter Monday','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-5-1',E'Labour Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-5-10',E'Ascension Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-5-21',E'Pentecost','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-6-23',E'National Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-8-15',E'Assumption of Mary','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-11-1',E'All Saints Day','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-12-25',E'Christmas','true');
INSERT INTO core.national_holiday (day,description,legal) VALUES ('2018-12-26',E'St. Etienne','true');


INSERT INTO core.log_types (id,name) VALUES(1,E'System');
INSERT INTO core.log_types (id,name) VALUES(2,E'Error');
INSERT INTO core.log_types (id,name) VALUES(3,E'Admin');
INSERT INTO core.log_types (id,name) VALUES(4,E'User');

INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'invoice',1,E'/lu/tudor/santec/gecamed/billing/templates/invoice_single_doctor.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'cert_morning',2,E'/lu/tudor/santec/gecamed/patient/gui/certificate/templates/cert_morning.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'cert_afternoon',3,E'/lu/tudor/santec/gecamed/patient/gui/certificate/templates/cert_afternoon.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'prescription',4,E'/lu/tudor/santec/gecamed/prescription/gui/templates/OrdonnanceMedicale.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'first_notice',5,E'/lu/tudor/santec/gecamed/billing/templates/first_reminder.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'second_notice',6,E'/lu/tudor/santec/gecamed/billing/templates/second_reminder.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'payment_order',7,E'/lu/tudor/santec/gecamed/billing/templates/payment_order.jasper');
INSERT INTO core.template_type (value,sequence_number,template_file_path) VALUES (E'3rd_party_stmnt',8,E'/lu/tudor/santec/gecamed/billing/templates/statement_cover.jasper');

