
USE letterboxv2_3;

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, 'docserver/', 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', 'candidature', 'Candidature', 7, 3, 1, NULL, 'demo', '2008-07-08 17:22:31', 'Y', 'N', 'vierge'),
('res_x', 'autre', 'Autres', 21, 14, 1, NULL, 'demo', '2008-07-08 17:27:12', 'Y', 'N', 'vierge'),
('res_x', 'ITT', 'Arret de travail', 10, 5, 1, NULL, 'demo', '2008-07-08 17:27:44', 'Y', 'N', 'vierge'),
('res_x', 'confirmation', 'Confirmation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:29:33', 'Y', 'N', 'vierge'),
('res_x', 'notification', 'Notification', 21, 14, 1, NULL, 'demo', '2008-07-08 17:30:18', 'Y', 'N', 'vierge'),
('res_x', 'sinistre', 'Sinistre', 14, 7, 1, NULL, 'demo', '2008-07-08 17:30:42', 'Y', 'N', 'vierge'),
('res_x', 'facture', 'Facture', 30, 5, 1, NULL, 'demo', '2008-07-08 17:31:53', 'Y', 'N', 'vierge'),
('res_x', 'BonDeCommande', 'Bon de Commande', 10, 5, 1, NULL, 'demo', '2008-07-08 17:32:33', 'Y', 'N', 'vierge'),
('res_x', 'DemandeAutorisation', 'Demande d''autorisation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:12', 'Y', 'N', 'vierge'),
('res_x', 'DemandeCongés', 'Demande de congés', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:35', 'Y', 'N', 'vierge'),
('res_x', 'DemandeInscription', 'Demande d''inscription', 21, 14, 1, NULL, 'demo', '2008-07-08 17:38:40', 'Y', 'N', 'vierge'),
('res_x', 'NoteService', 'Note de service', 21, 14, 1, NULL, 'demo', '2008-07-08 17:39:53', 'Y', 'Y', 'Note de service'),
('res_x', 'DemandeReservation', 'Demande de réservation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:40:19', 'Y', 'N', 'vierge'),
('res_x', 'DemandeReunion', 'Demande de réunion', 21, 14, 1, NULL, 'demo', '2008-07-08 17:56:26', 'Y', 'N', 'vierge'),
('res_x', 'AppelTelephonique', 'Appel Téléphonique', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:13', 'Y', 'Y', 'vierge'),
('res_x', 'ReponseAppelOffre', 'Réponse à un appel d''offre', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:40', 'Y', 'N', 'vierge');

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');

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, 'Vide', '2007-09-13 14:00:59', 'Courrier vierge', ''),
(2, 'Courrier vierge', '2007-09-13 14:00:59', 'Courrier vierge', '<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\\">Nanterre, le [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>'),
(3, 'AR candidature', '2008-07-11 12:22:31', '', '<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\\">Nanterre, le [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>Nous avons bien re&ccedil;u votre candidature pour le poste r&eacute;f&eacute;renc&eacute; ci-dessus et vous remercions de l\\''int&eacute;r&ecirc;t que vous portez &agrave; notre organisme.</span></font></p>    <p><font face=\\"Times\\" size=\\"3\\"><span>Nous examinerons les diff&eacute;rentes caract&eacute;ristiques de votre candidature dans les meilleurs d&eacute;lais. Cependant, vu le grand nombre de dossiers qui nous parviennent, il nous est malheureusement impossible de faire une r&eacute;ponse personnalis&eacute;e &agrave; chaque candidat.</span></font></p>    <p><font face=\\"Times\\" size=\\"3\\"><span>En cons&eacute;quence, nous vous contacterons uniquement en cas de parfaite ad&eacute;quation de votre parcours et de vos exp&eacute;riences professionnelles avec ceux souhait&eacute; par notre client. Nous ne pourrons pas vous donner plus d\\''explications par t&eacute;l&eacute;phone et nous vous remercions de bien vouloir en tenir compte. Sans nouvelle de notre part dans un d&eacute;lai de 3 semaines environ, nous vous demandons de bien vouloir consid&eacute;rer que votre candidature n\\''est pas retenue.</span></font></p>    <p><font face=\\"Times\\" size=\\"3\\"><span>Sauf avis contraire exprim&eacute;, nous nous permettons n&eacute;anmoins de conserver votre dossier dans notre base de donn&eacute;es afin de pouvoir vous contacter si une opportunit&eacute; se pr&eacute;sentait.</span></font></p><p><font face=\\"times\\" size=\\"3\\">Cordialement, </font></p><blockquote><blockquote><p><font face=\\"times\\" size=\\"3\\">&nbsp;[NEW_EMETTEUR]</font></p></blockquote></blockquote></td></tr></tbody></table>'),
(4, 'Note de service', '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\\">NOTE DE SERVICE</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>'),
(5, 'AR courrier', '2008-07-11 12:25:04', '', '<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><strong>[NEW_EMETTEUR]</strong><br />[DEP_EMETTEUR]<br />[TEL_EMETTEUR]<br />[MAIL_EMETTEUR] </p><p><strong>Maarch</strong><br />65, rue de la Croix<br />92000 Nanterre</p></td><td><p align=\\"right\\"><font face=\\"times\\" size=\\"3\\">Nanterre, le [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>Nous avons bien re&ccedil;u votre courrier le&nbsp;[DATE_ARRIVEE] et nous nous efforcerons d\\''y r&eacute;pondre au plus vite (au plus tard le [DATE_LIM]).<br /></span></font></p><p><font face=\\"times\\" size=\\"3\\">Cordialement, </font></p><blockquote><blockquote><p><font face=\\"times\\" size=\\"3\\">&nbsp;[NEW_EMETTEUR]</font></p></blockquote></blockquote></td></tr></tbody></table>');

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),
('COU', 5);

INSERT INTO `parameters` (`KEY1`, `KEY2`, `KEY3`, `VALUE`, `LIB_PARAM`) VALUES
('WORKBATCH', '', '', '1', ''),
('CHRONO', '', '2008', '1', '');

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'),
('Enregistrement', 'res_x', '', '', 'Y', 'N'),
('Modification', 'res_x', '', '', 'N', 'Y');

INSERT INTO `sender` (`ID`, `LASTNAME`, `FIRSTNAME`, `SOCIETY`, `FUNCTION`, `STREET`, `TOWN`, `CP`, `PHONE`, `MAIL`, `TOCONTACT`) VALUES
(2, 'DASS', '', '', '', '', '', '', '', '', ''),
(3, 'CAF', '', '', '', '', '', '', '', '', ''),
(4, 'Conseil général', '', '', '', '', '', '', '', '', ''),
(5, 'Mairie', '', '', '', '', '', '', '', '', ''),
(6, 'Mission intercommunale pour la jeunesse', '', '', '', '', '', '', '', '', ''),
(7, 'Office HLM', '', '', '', '', '', '', '', '', ''),
(8, 'Préfecture', '', '', '', '', '', '', '', '', ''),
(9, 'Trésor Public', '', '', '', '', '', '', '', '', ''),
(10, 'Ministère de l''intérieur', '', '', '', '', '', '', '', '', '');

INSERT INTO `services` (`ID`, `SERVICE`, `ENABLED`) VALUES
('CAB', 'Cabinet du Maire', 'Y'),
('PSO', 'Pôle social', 'Y'),
('DGS', 'Direction Générale des Services', 'Y'),
('SGE', 'Secrétariat Général', 'Y'),
('COU', 'Service Courrier', 'Y'),
('ELU', 'Elus de la ville', 'Y'),
('DGA', 'Direction Générale Adjointe', 'Y'),
('PJS', 'Pôle Jeunesse et Sports', 'Y'),
('PCU', 'Pôle Culture', 'Y'),
('PTE', 'Pôle Technique', 'Y'),
('PSF', 'Pôle Services Fonctionnel', 'Y'),
('INF', 'Service Informatique', 'Y'),
('SRH', 'Service Ressources Humaines', 'Y'),
('FIN', 'Service Finances', 'Y');

INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`) VALUES
('Enregistrement', 'Droits d''enregistrement', 'N', 'N', 'N', 'N', 'N', 'N', 'Y'),
('SuperAdmin', 'Super Administrateur', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('Modification', 'Droits de modification', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y'),
('Process', 'Droits de traitement', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y'),
('ViewStats', 'Droits de visualisation des statistiques', 'N', 'Y', 'N', 'Y', 'N', 'N', 'Y'),
('gCAB', 'Cabinet du maire', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'Y'),
('gDGS', 'Direction générale des services', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gSGE', 'Secrétariat général', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gCOU', 'Service Courrier', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y'),
('gDGA', 'Direction Générale Adjointe', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gPSF', 'Pôles des services fonctionnels', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('gINF', 'Service informatique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gDRH', 'Service ressources humaines', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gFIN', 'Service finance', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPSO', 'Pôle social', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPJS', 'Pôle jeunesse et sports', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y'),
('gPCU', 'Pôle Culture', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gPTE', 'Pôle Technique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'),
('gELU', 'groupe des elus', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y');

INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES
('demo', 'SuperAdmin', 'Y', 'Consultant'),
('demo', 'Enregistrement', 'N', 'Consultant'),
('demo', 'Modification', 'N', 'Consultant'),
('demo', 'Process', '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', 'Enregistrement', 'N', 'responsable'),
('tmosby', 'gCOU', 'Y', 'agent'),
('tmosby', 'Enregistrement', '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 `users` (`USER_ID`, `PASSWORD`, `FIRSTNAME`, `LASTNAME`, `PHONE`, `MAIL`, `DEPARTMENT`, `FONCTION`, `COOKIE_KEY`, `COOKIE_DATE`, `ELU`, `ENABLED`, `STATUS`, `CHANGE_PASSWORD`, `DELAY`) VALUES
('demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 'John', 'Smith', '0147245159', 'info@maarch.org', 'INF', 'Consultant', '07ee7bf7280fe86334dc0fe45098d05e', '2008-07-11 10:07:12', 'N', 'Y', 'OK', 'N', NULL),
('pstone', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Patsy', 'Stone', '', 'info@maarch.org', 'CAB', 'Maire', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('emonsoon', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Edina', 'Monsoon', '', 'info@maarch.org', 'CAB', 'Secrétaire', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('ratwood', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Ryan', 'Atwood', '', 'info@maarch.org', 'DGS', 'Directeur général des services', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('scohen', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Seth', 'Cohen', '', 'info@maarch.org', 'DGS', 'Assistant', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('dleary', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Dawson', 'Leary', '', 'info@maarch.org', 'SGE', 'Secrétaire général', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('jpotter', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Joey', 'Potter', '', 'info@maarch.org', 'SGE', 'Assistante', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('elebowitz', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Ethan', 'Lebowitz', '', 'info@maarch.org', 'DGA', 'Directeur général adjoint', '', '0000-00-00 00:00:00', 'Y', 'Y', 'DEL', 'Y', NULL),
('kjoyce', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Kaitlin', 'Joyce', '', 'info@maarch.org', 'DGA', 'Secrétaire', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('bstinson', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Barney', 'Stinson', '', 'info@maarch.org', 'COU', 'Responsable', '996917d45fab301abf05395d422f2c3b', '2008-07-11 10:07:12', 'Y', 'Y', 'OK', 'N', NULL),
('tmosby', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Ted', 'Mosby', '', 'info@maarch.org', 'COU', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('nbotwin', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Nancy', 'Botwin', '', 'info@maarch.org', 'PSO', 'responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('ejarlewski', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Ethan', 'Jarlewski', '', 'info@maarch.org', 'DGA', 'Directeur général adjoint', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('chodes', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Celia', 'Hodes', '', 'info@maarch.org', 'PSO', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('bkinney', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Brian', 'Kinney', '', 'info@maarch.org', 'PJS', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('jtaylor', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Justin', 'Taylor', '', 'info@maarch.org', 'PJS', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('bwaldorf', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Blair', 'Waldorf', '', 'info@maarch.org', 'PCU', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('narchibald', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Nate', 'Archibald', '', 'info@maarch.org', 'PCU', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('ccharles', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Charlotte', 'Charles', '', 'info@maarch.org', 'PTE', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('npiehole', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Ned', 'Piehole', '', 'info@maarch.org', 'PTE', 'Agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('abloom', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Amanda', 'Bloom', '', 'info@maarch.org', 'PSF', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('ktrager', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Kyle', 'Trager', '', 'info@maarch.org', 'PSF', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('tstonem', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Tony', 'Stonem', '', 'info@maarch.org', 'SRH', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('sjenkins', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Sid', 'Jenkins', '', 'info@maarch.org', 'SRH', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('smayer', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Susan', 'Mayer', '', 'info@maarch.org', 'FIN', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('jrowland', 'fe01ce2a7fbac8fafaed7c982a04e229', 'John', 'Rowland', '', 'info@maarch.org', 'FIN', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('mmoss', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Maurice', 'Moss', '', 'info@maarch.org', 'INF', 'agent', '', '0000-00-00 00:00:00', 'N', 'Y', 'OK', 'Y', NULL),
('jcrowd', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Jen', 'Crowd', '', 'info@maarch.org', 'INF', 'Responsable', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('dmorgan', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Dexter', 'Morgan', '', 'info@maarch.org', 'ELU', 'Elu adjoint aux sports', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL),
('rbenett', 'fe01ce2a7fbac8fafaed7c982a04e229', 'Rita', 'Bennett', '', 'info@maarch.org', 'ELU', 'Elu chargé de la culture', '', '0000-00-00 00:00:00', 'Y', 'Y', 'OK', 'Y', NULL);

INSERT INTO `welcome_txt` (`ID`, `VALUE`) VALUES
('WELCOME', 'Bienvenue dans Maarch LetterBox, la solution open source de gestion du courrier !!');

INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`) VALUES 
('res_x', 'MyBasket', 'Mes courriers à traiter', 'Courriers ', '(status = ''NEW'' or status=''COU'') and DEST_USER = @user', 'Y', 'Y'),
('res_x', 'ValidationBasket', 'Mes courriers à valider', 'Courriers à traiter', 'status = ''VAL''', 'Y', 'Y'),
('res_x', 'LateMailBasket', 'Mes courriers en retard', 'Courriers en retards', '(STATUS=''NEW'' or STATUS=''COU'') and DEST_USER = @user and now() > CUSTOM_D2', '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'') ', 'Y', 'Y'),
('res_x', 'DepartmentBasket', 'Services autorisés', 'Services autorisés', 'status <> ''DEL'' AND status <> ''REP'' and status <> ''VAL''', 'Y', 'Y'),
('res_x', 'OutMails', 'Mes Courriers sortant', 'Mes courriers sortant', 'STATUS = ''OUT'' and IS_INGOING = ''N'' and AUTHOR = @user', 'N', 'Y');
