

INSERT INTO `docservers` (`DOCSERVER_ID`, `DEVICE_TYPE`, `DEVICE_LABEL`, `IS_READONLY`, `ENABLED`, `SIZE_LIMIT`, `ACTUAL_SIZE`, `PATH_TEMPLATE`, `EXT_DOCSERVER_INFO`, `CHAIN_BEFORE`, `CHAIN_AFTER`, `CREATION_DATE`, `CLOSING_DATE`) VALUES
('mondocserver', NULL, NULL, 'N', 'Y', 0, 0, 'C:\\Maarch\\Docserver\\letterbox\\', NULL, NULL, NULL, '2008-07-07 16:14:51', '0000-00-00 00:00:00');
INSERT INTO `docservers` (`DOCSERVER_ID`, `DEVICE_TYPE`, `DEVICE_LABEL`, `IS_READONLY`, `ENABLED`, `SIZE_LIMIT`, `ACTUAL_SIZE`, `PATH_TEMPLATE`, `EXT_DOCSERVER_INFO`, `CHAIN_BEFORE`, `CHAIN_AFTER`, `CREATION_DATE`, `CLOSING_DATE`) VALUES
('letterbox_ai', NULL, NULL, 'N', 'Y', 0, 0, 'C:\\Maarch\\Docserver\\letterbox_autoimport\\', NULL, NULL, NULL, '2008-07-07 16:14:51', '0000-00-00 00:00:00');

INSERT INTO `doctypes` (`RES_TABLE`, `TYPE_ID`, `DESCRIPTION`, `DELAI_TRAITEMENT`, `DELAI_RELANCE1`, `DELAI_RELANCE2`, `CUSTOM_T1`, `CUSTOM_T2`, `CUSTOM_T3`, `ENABLED`, `GENERATE`, `MODEL`) VALUES
('res_x', 'Job application', 'Application', 7, 3, 1, NULL, 'demo', '2008-07-08 17:22:31', 'Y', 'N', 'Blank Template'),
('res_x', 'Other', 'Others', 21, 14, 1, NULL, 'demo', '2008-07-08 17:27:12', 'Y', 'N', 'Blank Template'),
('res_x', 'SickLeave', 'SickLeave', 10, 5, 1, NULL, 'demo', '2008-07-08 17:27:44', 'Y', 'N', 'Blank Template'),
('res_x', 'confirmation', 'Confirmation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:29:33', 'Y', 'N', 'Blank Template'),
('res_x', 'notification', 'Notification', 21, 14, 1, NULL, 'demo', '2008-07-08 17:30:18', 'Y', 'N', 'Blank Template'),
('res_x', 'accident', 'Accident', 14, 7, 1, NULL, 'demo', '2008-07-08 17:30:42', 'Y', 'N', 'Blank Template'),
('res_x', 'invoice', 'Invoice', 30, 5, 1, NULL, 'demo', '2008-07-08 17:31:53', 'Y', 'N', 'Blank Template'),
('res_x', 'OrderForm', 'Order Form', 10, 5, 1, NULL, 'demo', '2008-07-08 17:32:33', 'Y', 'N', 'Blank Template'),
('res_x', 'AuthorizationRequest', 'Authorization request', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:12', 'Y', 'N', 'Blank Template'),
('res_x', 'VacancyRequest', 'Vacancy Request', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:35', 'Y', 'N', 'Blank Template'),
('res_x', 'SigninRequest', 'Sign in Request', 21, 14, 1, NULL, 'demo', '2008-07-08 17:38:40', 'Y', 'N', 'Blank Template'),
('res_x', 'Memo', 'Memo', 21, 14, 1, NULL, 'demo', '2008-07-08 17:39:53', 'Y', 'Y', 'Memo'),
('res_x', 'BookingRequest', 'Booking Request', 21, 14, 1, NULL, 'demo', '2008-07-08 17:40:19', 'Y', 'N', 'Blank Template'),
('res_x', 'MeetingRequest', 'Meeting Request', 21, 14, 1, NULL, 'demo', '2008-07-08 17:56:26', 'Y', 'N', 'Blank Template'),
('res_x', 'Phone Call', 'Phone Call', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:13', 'Y', 'Y', 'Blank Template'),
('res_x', 'Request for Proposal', 'Request for Proposal', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:40', 'Y', 'N', 'Blank Template');

INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES
('gINF', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gCOU', 'MyBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gFIN', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gSGE', 'MyBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'mail_process'),
('gPSO', 'MyBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'mail_process'),
('gFIN', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gPSF', 'MyBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gPTE', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'mail_process'),
('gPJS', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'mail_process'),
('gPCU', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'mail_process'),
('gDGA', 'MyBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gDGS', 'MyBasket', 3, '''COU'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gCAB', 'MyBasket', 1, '''CAB'',''PSO'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPSO'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gSGE', 'ValidationBasket', 6, '', '', 'N', 'N', 'N', 'courrier'),
('gCOU', 'LateMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gSGE', 'LateMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'mail_process'),
('gPSF', 'LateMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gPTE', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'mail_process'),
('gPSO', 'LateMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'mail_process'),
('gPCU', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'mail_process'),
('gPJS', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'mail_process'),
('gDGS', 'LateMailBasket', 3, '''COU'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gDGA', 'LateMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gCAB', 'LateMailBasket', 1, '''CAB'',''PSO'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPSO'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'mail_process'),
('gINF', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gDRH', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gDRH', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'copy_mail'),
('gPTE', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'copy_mail'),
('gPSF', 'CopyMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail'),
('gSGE', 'CopyMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'copy_mail'),
('gCOU', 'CopyMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'copy_mail'),
('gFIN', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'copy_mail'),
('gINF', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail'),
('gPJS', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'copy_mail'),
('gPSO', 'CopyMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'copy_mail'),
('gPCU', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'copy_mail'),
('gDGS', 'CopyMailBasket', 3, '''COU'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'copy_mail'),
('gDGA', 'CopyMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail'),
('gCAB', 'CopyMailBasket', 2, '''CAB'',''PSO'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPSO'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'copy_mail'),
('gDRH', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'mail_process'),
('gINF', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep'),
('gCOU', 'DepartmentBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'auth_dep'),
('gFIN', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'auth_dep'),
('gSGE', 'DepartmentBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'auth_dep'),
('gDRH', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'auth_dep'),
('gPTE', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'auth_dep'),
('gPSF', 'DepartmentBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep'),
('gPJS', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'auth_dep'),
('gPSO', 'DepartmentBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'auth_dep'),
('gPCU', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'auth_dep'),
('gDGS', 'DepartmentBasket', 3, '''COU'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'auth_dep'),
('gDGA', 'DepartmentBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep'),
('gCAB', 'DepartmentBasket', 2, '''CAB'',''PSO'',''DGS'',''SGE'',''COU'',''ELU'',''DGA'',''PJS'',''PCU'',''PTE'',''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gCOU'',''gDGA'',''gDGS'',''gDRH'',''gELU'',''gFIN'',''gINF'',''gPCU'',''gPJS'',''gPSF'',''gPSO'',''gPTE'',''gSGE''', 'Y', 'N', 'N', 'auth_dep'),
('gCOU', 'RetourCourrier', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '''gCAB'',''gDGA'',''gDGS'',''Processing'',''Modification'',''Process'',''ViewStats'',''gELU'',''gPCU'',''gPJS'',''gPSO'',''gPTE'',''gPSF'',''gSGE'',''gCOU'',''gFIN'',''gINF'',''gDRH'',''SuperAdmin''', 'Y', 'N', 'N', 'courrier');

INSERT INTO `listmodel` (`RES_TABLE`, `ID`, `SEQUENCE`, `USER_ID`) VALUES
('res_x', 'CAB', 1, 'pstone'),
('res_x', 'CAB', 2, 'emonsoon'),
('res_x', 'SGE', 1, 'dleary'),
('res_x', 'COU', 1, 'bstinson'),
('res_x', 'DGA', 1, 'ejarlewski'),
('res_x', 'PSO', 1, 'nbotwin'),
('res_x', 'DGS', 1, 'ratwood'),
('res_x', 'PJS', 1, 'bkinney'),
('res_x', 'PCU', 1, 'bwaldorf'),
('res_x', 'PTE', 1, 'ccharles'),
('res_x', 'PSF', 1, 'abloom'),
('res_x', 'SRH', 1, 'tstonem'),
('res_x', 'FIN', 1, 'smayer'),
('res_x', 'INF', 1, 'jcrowd'),
('res_x', 'PJS', 2, 'dmorgan'),
('res_x', 'PCU', 2, 'rbenett');

INSERT INTO `models` (`ID`, `LABEL`, `CREATION_DATE`, `COMMENT`, `CONTENT`) VALUES
(1, 'Blank Template', '2007-09-13 14:00:59', 'Blank', ''),
(2, 'Mail with headers', '2007-09-13 14:00:59', 'Template for regular mails', '<table border=\\"0\\" width=\\"646\\" height=\\"187\\"><tbody><tr><td width=\\"200\\"><img src=\\"tiny_mce/themes/maarch/img_models/Maarch_200.png\\" border=\\"0\\" alt=\\"Maarch_200.png\\" hspace=\\"0\\" vspace=\\"0\\" width=\\"200\\" height=\\"61\\" /> <br /></td><td>&nbsp;</td></tr><tr><td valign=\\"top\\"><p>[NEW_EMETTEUR]<br />[DEP_EMETTEUR]<br />[MAIL_EMETTEUR] </p></td><td><p align=\\"right\\">New York City, NY, the [DATE_TODAY]&nbsp;</p><p>ref : [OBJET]</p><p>[CIV_EMETTEUR],</p><p>&nbsp;</p><blockquote><blockquote><p>&nbsp;[NEW_EMETTEUR]</p></blockquote></blockquote></td></tr></tbody></table>'),
(4, 'Job Application', '2008-07-11 12:22:31', 'Answer to job application', '<table border=\\"0\\" width=\\"646\\" height=\\"187\\"><tbody><tr><td width=\\"200\\"><img src=\\"tiny_mce/themes/maarch/img_models/Maarch_200.png\\" border=\\"0\\" alt=\\"Maarch_200.png\\" hspace=\\"0\\" vspace=\\"0\\" width=\\"200\\" height=\\"61\\" /> <br /></td><td>&nbsp;</td></tr><tr><td valign=\\"top\\"><p>[NEW_EMETTEUR]<br />[DEP_EMETTEUR]<br />[MAIL_EMETTEUR] </p></td><td><p align=\\"right\\"><font face=\\"times\\" size=\\"3\\">New York City, NY, the [DATE_TODAY]</font>&nbsp;</p><p><font face=\\"times\\" size=\\"3\\">ref : [OBJET]</font></p><p><font face=\\"times\\" size=\\"3\\">[CIV_EMETTEUR],</font></p><p>&nbsp;</p><p><font face=\\"Times\\" size=\\"3\\"><span>We received your application for the job referenced above and we thank you for the interest you expressed for our Company.</span></font></p>    <p><font face=\\"Times\\" size=\\"3\\"><span>We will study your application in a timely fashion. However, regarding the high number of applications we receive, we cannot make a personal answer to each applicant.
</span></font></p>    <p><font face=\\"Times\\" size=\\"3\\"><span>We will then contact you only if your studies and experiences match perfectly the profile we are looking for. If we do not contact you in the next three weeks, please consider that your application has not been selected.</span></font></p><p><font face=\\"times\\" size=\\"3\\">Best regards, </font></p><blockquote><blockquote><p><font face=\\"times\\" size=\\"3\\">&nbsp;[NEW_EMETTEUR]</font></p></blockquote></blockquote></td></tr></tbody></table>'),
(3, 'Memo', '2008-07-08 18:33:46', '', '<p align=\\"right\\">&nbsp;</p><table border=\\"0\\" width=\\"800\\" align=\\"center\\"><tbody><tr><td>&nbsp;[NEW_EMETTEUR]<br />[DEP_EMETTEUR] </td><td><p>&nbsp;</p><div style=\\"text-align: center\\"><img src=\\"tiny_mce/themes/maarch/img_models/Maarch_200.png\\" border=\\"0\\" alt=\\"Maarch_200.png\\" hspace=\\"0\\" vspace=\\"0\\" width=\\"200\\" height=\\"61\\" /></div><p>&nbsp;</p></td><td align=\\"right\\">[DATE_TODAY]&nbsp;</td></tr><tr align=\\"center\\"><td colspan=\\"3\\">&nbsp;<strong><font face=\\"arial,helvetica,sans-serif\\" size=\\"7\\"><font size=\\"6\\">MEMO</font></font></strong></td></tr><tr align=\\"center\\"><td colspan=\\"3\\"><p>&nbsp;</p>[votre texte ici]<br /></td></tr></tbody></table><p>&nbsp;</p><p>&nbsp;</p>');

INSERT INTO `model_service` (`ID_SERVICE`, `ID_MODEL`) VALUES
('CAB', 1),
('COU', 1),
('DGA', 1),
('DGS', 1),
('ELU', 1),
('FIN', 1),
('INF', 1),
('PCU', 1),
('PJS', 1),
('PSF', 1),
('PSO', 1),
('PTE', 1),
('SGE', 1),
('SRH', 1),
('CAB', 2),
('COU', 2),
('DGA', 2),
('DGS', 2),
('ELU', 2),
('FIN', 2),
('INF', 2),
('PCU', 2),
('PJS', 2),
('PSF', 2),
('PSO', 2),
('PTE', 2),
('SGE', 2),
('SRH', 2),
('SRH', 3),
('CAB', 4);

INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES
('SuperAdmin', 'res_x', ' DESTINATION IN (  '''' )', '', 'N', 'N'),
('gCAB', 'res_x', ' DESTINATION IN (  ''PTE'',  ''COU'',  ''SRH'',  ''CAB'',  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''DGS'',  ''PSO'',  ''SGE'',  ''FIN'',  ''INF'' )', '', 'N', 'N'),
('gDGS', 'res_x', ' DESTINATION IN (  ''DGA'',  ''DGS'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N'),
('gSGE', 'res_x', ' DESTINATION IN (  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N'),
('gCOU', 'res_x', ' DESTINATION IN (  ''(1=-1'',  ''CAB'',  ''DGA'',  ''DGS'',  ''ELU'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N'),
('gDGA', 'res_x', ' DESTINATION IN (  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N'),
('gPSF', 'res_x', ' DESTINATION IN (  ''PSF'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N'),
('gINF', 'res_x', ' DESTINATION IN (  ''INF'' )', '', 'N', 'N'),
('gDRH', 'res_x', ' DESTINATION IN (  ''SRH'' )', '', 'N', 'N'),
('gFIN', 'res_x', ' DESTINATION IN (  ''FIN'' )', '', 'N', 'N'),
('gPSO', 'res_x', ' DESTINATION IN (  ''PSO'' )', '', 'N', 'N'),
('gPJS', 'res_x', ' DESTINATION IN (  ''PJS'' )', '', 'N', 'N'),
('gPCU', 'res_x', ' DESTINATION IN (  ''PCU'' )', '', 'N', 'N'),
('gPTE', 'res_x', ' DESTINATION IN (  ''PTE'' )', '', 'N', 'N'),
('gELU', 'res_x', ' (1=-1) ', '', 'N', 'N'),
('Recording', 'res_x', '', '', 'Y', 'N'),
('Modifying', 'res_x', '', '', 'N', 'Y');

INSERT INTO `sender` (`ID`, `LASTNAME`, `FIRSTNAME`, `SOCIETY`, `FUNCTION`, `STREET`, `TOWN`, `CP`, `PHONE`, `MAIL`, `TOCONTACT`) VALUES
(2, 'Child Affairs', '', '', '', '', '', '', '', '', ''),
(3, 'Social Affairs', '', '', '', '', '', '', '', '', ''),
(4, 'District', '', '', '', '', '', '', '', '', ''),
(5, 'Townhall', '', '', '', '', '', '', '', '', ''),
(6, 'Governor''s office', '', '', '', '', '', '', '', '', ''),
(7, 'Federal State', '', '', '', '', '', '', '', '', ''),
(8, 'IRS', '', '', '', '', '', '', '', '', ''),
(9, 'Police Department', '', '', '', '', '', '', '', '', ''),
(10, 'Homeland Security', '', '', '', '', '', '', '', '', '');

INSERT INTO `services` (`ID`, `SERVICE`, `ENABLED`) VALUES
('CAB', 'Mayor''s office', 'Y'),
('PSO', 'Social Service', 'Y'),
('DGS', 'General Management of Department', 'Y'),
('SGE', 'General Secretary', 'Y'),
('COU', 'Mail service', 'Y'),
('ELU', 'Elected people', 'Y'),
('DGA', 'General Management', 'Y'),
('PJS', 'Youth and sport Department', 'Y'),
('PCU', 'Culture Department', 'Y'),
('PTE', 'Technical Department', 'Y'),
('PSF', 'Fonctionnal Services Department', 'Y'),
('INF', 'IT Department', 'Y'),
('SRH', 'HR Department', 'Y'),
('FIN', 'Accounts Department', 'Y');

INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`) VALUES
('Recording', 'Recording rightst', 'N', 'N', 'N', 'N', 'N', 'N', 'Y'),
('SuperAdmin', 'Super Administrator', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('Modifying', 'Modifying Rights', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y'),
('Processing', 'Processing rights', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y'),
('ViewStats', 'Stats Viewing Rights', 'N', 'Y', 'N', 'Y', 'N', 'N', 'Y'),
('gCAB', 'Mayor''s office', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'Y'),
('gDGS', 'General Management of Department', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gSGE', 'General Secretary', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gCOU', 'Mail service', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y'),
('gDGA', 'General Management', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gPSF', 'Fonctionnal Services Department', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gINF', 'IT Department', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gDRH', 'HR Department', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gFIN', 'Accounts Department', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPSO', 'Social Service', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPJS', 'Youth and sport Department', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y'),
('gPCU', 'Culture Department', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPTE', 'Technical Department', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gELU', 'Elected user group', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y');

--
-- Contenu de la table `usergroup_content`
--

INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES
('demo', 'SuperAdmin', 'Y', 'Consultant'),
('demo', 'Recording', 'N', 'Consultant'),
('demo', 'Modifying', 'N', 'Consultant'),
('demo', 'Processing', 'N', 'Consultant'),
('demo', 'ViewStats', 'N', 'Consultant'),
('pstone', 'gCAB', 'Y', 'Maire'),
('emonsoon', 'gCAB', 'Y', 'secrétaire'),
('ratwood', 'gDGS', 'Y', 'Directeur général des services'),
('scohen', 'gDGS', 'Y', 'Assistant'),
('dleary', 'gSGE', 'Y', 'Secrétaire général'),
('jpotter', 'gSGE', 'Y', 'Assistante'),
('ejarlewski', 'gDGA', 'Y', 'Directeur'),
('bstinson', 'gCOU', 'Y', 'responsable'),
('bstinson', 'Processing', 'N', 'responsable'),
('tmosby', 'gCOU', 'Y', 'agent'),
('tmosby', 'Processing', 'N', 'agent'),
('nbotwin', 'gPSO', 'Y', 'Responsable'),
('kjoyce', 'gDGA', 'Y', 'secrétaire'),
('chodes', 'gPSO', 'Y', 'agent'),
('bkinney', 'gPJS', 'Y', 'Responsable'),
('jtaylor', 'gPJS', 'Y', 'agent'),
('bwaldorf', 'gPCU', 'Y', 'responsable'),
('narchibald', 'gPCU', 'Y', 'agent'),
('ccharles', 'gPTE', 'Y', 'responsable'),
('npiehole', 'gPTE', 'Y', 'agent'),
('abloom', 'gPSF', 'Y', ''),
('ktrager', 'gPSF', 'Y', 'agent'),
('tstonem', 'gDRH', 'Y', 'Responsable'),
('sjenkins', 'gDRH', 'Y', 'agent'),
('smayer', 'gFIN', 'Y', 'Responsable'),
('jrowland', 'gFIN', 'Y', 'agent'),
('dmorgan', 'gELU', 'Y', ''),
('mmoss', 'gINF', 'Y', 'agent'),
('jcrowd', 'SuperAdmin', 'N', ''),
('jcrowd', 'gINF', 'Y', ''),
('rbenett', 'gELU', 'Y', '');

INSERT INTO `welcome_txt` (`ID`, `VALUE`) VALUES
('WELCOME', 'Welcome to Maarch LetterBox, the open source mail management software !!');

INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`) VALUES
('res_x', 'MyBasket', 'Mes courriers à traiter', 'Courriers à traiter', '(status = ''NEW'' or status=''COU'' or status=''WAI'') and DEST_USER = @user and is_folder = ''Y''', 'Y', 'Y'),
('res_x', 'ValidationBasket', 'Mes courriers à valider', 'Courriers à valider', 'status = ''VAL'' and is_folder = ''Y''', 'Y', 'Y'),
('res_x', 'LateMailBasket', 'Mes courriers en retard', 'Courriers en retards', '(STATUS=''NEW'' or STATUS=''COU'' or status=''WAI'') and DEST_USER = @user and now() > CUSTOM_D2 and is_folder = ''Y''', 'Y', 'Y'),
('res_x', 'CopyMailBasket', 'Mes courriers en copie', 'Liste des courriers en copie', 'l.res_table = ''res_x'' and l.user_id = @user and l.res_id = r.res_id and l.sequence > 1 and ( r.status=''NEW'' or r.status=''COU'' or r.status=''WAI'') and is_folder = ''Y''', 'Y', 'Y'),
('res_x', 'DepartmentBasket', 'Services autorisés', 'Services autorisés', 'status <> ''DEL'' AND status <> ''REP'' and status <> ''VAL'' and is_folder=''Y''', 'Y', 'Y'),
('res_x', 'OutMails', 'Mes Courriers sortant', 'Mes courriers sortant', 'IS_INGOING = ''N'' and AUTHOR = @user and is_folder = ''Y''', 'N', 'Y'),
('res_x', 'RedirectBasket', 'Retours affaires', 'Affaires redirigées au service courrier ', 'DEST_USER = ''courrier'' and is_folder = ''Y''', 'N', 'Y'),
('res_x','QualifBasket','Mes affaires à qualifier','Mes affaires à qualifier','(status = ''ATT'' or status =''RSV'') and destination = @my_entity ','N','Y');
