
USE letterbox_sai;


--
-- Contenu de la table `docservers`
--

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, 198303, 'C:\\Maarch\\Docserver\\letterbox\\', NULL, NULL, NULL, '2008-07-07 16:14:51', '0000-00-00 00:00:00'),
('letterbox_ai', NULL, NULL, 'N', 'Y', 1000000000, 1382785, 'C:\\\\Maarch\\\\DocServer\\letterbox_ai\\\\', NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

--
-- Contenu de la table `doctypes`
--

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', 'DemandeConges', 'Demande de conges', 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 reservation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:40:19', 'Y', 'N', 'vierge'),
('res_x', 'DemandeReunion', 'Demande de reunion', 21, 14, 1, NULL, 'demo', '2008-07-08 17:56:26', 'Y', 'N', 'vierge'),
('res_x', 'AppelTelephonique', 'Appel Telephonique', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:13', 'Y', 'Y', 'vierge'),
('res_x', 'ReponseAppelOffre', 'Reponse a un appel d''offre', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:40', 'Y', 'N', 'vierge');

--
-- Contenu de la table `ext_docserver`
--


--
-- Contenu de la table `groupbasket`
--

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'),
('gFIN', 'AClasser', 2, '''PTE'',''SGE'',''COU'',''INF'',''SRH''', '', 'Y', 'N', 'N', 'courrier'),
('gCOU', 'AClasser', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '''gCAB'',''gDGA'',''gDGS'',''Enregistrement'',''Modification'',''Process'',''ViewStats'',''gELU'',''gPCU'',''gPJS'',''gPSO'',''gPTE'',''gPSF'',''gSGE'',''gCOU'',''gFIN'',''gINF'',''gDRH'',''SuperAdmin''', 'Y', 'N', 'N', 'courrier');

--
-- Contenu de la table `groupsecurity`
--


--
-- Contenu de la table `history`
--

INSERT INTO `history` (`ID`, `TABLE_NAME`, `RECORD_ID`, `EVENT_TYPE`, `USER_ID`, `EVENT_DATE`, `INFO`) VALUES
(1, 'res_x', '1', 'ADD', 'bbina', '2009-01-30 12:08:32', 'Nouveau courrier entrant ajout&eacute; (1) '),
(2, 'res_x', '3', 'ADD', 'jjane', '2009-01-30 12:42:57', 'Ajout d''annotation'),
(3, 'res_x', '4', 'ADD', 'jjane', '2009-01-30 12:47:10', 'Ajout d''annotation'),
(4, 'res_x', '', 'VAL', 'jjane', '2009-01-30 12:47:23', 'Validation du courrier :  (facture)'),
(5, 'res_x', '5', 'ADD', 'jjane', '2009-01-30 12:59:43', 'Ajout d''annotation'),
(6, 'res_x', '5', 'VAL', 'jjane', '2009-01-30 12:59:58', 'Validation du courrier : 1 (facture)'),
(7, 'res_x', '5', 'ADD', 'bbain', '2009-01-30 13:01:01', 'R&eacute;ponse ajout&eacute;e pour le courrier : 1 (facture)'),
(8, 'res_x', '5', 'UP', 'bbain', '2009-01-30 13:01:09', 'Traitement du courrier n&deg;5 (facture)'),
(9, 'res_x', '5', 'UP', 'bbain', '2009-01-30 13:01:17', 'Traitement du courrier n&deg;5 (facture)'),
(10, 'res_x', '5', 'UP', 'bbain', '2009-01-30 13:01:18', 'Cl&ocirc;ture du traitement du courrier n&deg;5 (facture)'),
(11, 'res_x', '7', 'ADD', 'bblier', '2009-01-30 13:03:00', 'Nouveau courrier entrant ajout&eacute; (7) '),
(12, 'res_x', '9', 'ADD', 'bblier', '2009-01-30 13:25:23', 'Nouveau courrier entrant ajout&eacute; (9) '),
(13, 'usergroups', 'gSGE', 'UP', 'demo', '2009-01-30 13:27:01', 'Modification du groupe; : gSGE'),
(14, 'res_x', '10', 'VAL', 'bblier', '2009-01-30 15:05:46', 'Validation du courrier : MAARCH CAB Y_00000100.PDF (autre)'),
(15, 'res_x', '14', 'VAL', 'bblier', '2009-01-30 16:23:23', 'Validation du courrier : MAARCH CAB Y_00000102.PDF (ITT)');

--
-- Contenu de la table `listinstance`
--

INSERT INTO `listinstance` (`RES_TABLE`, `RES_ID`, `SEQUENCE`, `USER_ID`) VALUES
('res_x', 1, 1, 'sstarr'),
('res_x', 4, 1, 'bbain'),
('res_x', 4, 2, 'ttibert'),
('res_x', 5, 1, 'bbain'),
('res_x', 7, 1, 'sstarr'),
('res_x', 7, 2, 'ccharles'),
('res_x', 7, 3, 'jjane'),
('res_x', 9, 1, 'eerina'),
('res_x', 9, 2, 'ppetit'),
('res_x', 10, 1, 'ppetit'),
('res_x', 10, 2, 'eerina'),
('res_x', 18, 1, 'ppetit'),
('res_x', 18, 2, 'eerina');

--
-- Contenu de la table `listmodel`
--

INSERT INTO `listmodel` (`RES_TABLE`, `ID`, `SEQUENCE`, `USER_ID`) VALUES
('res_x', 'CAB', 1, 'ppetit'),
('res_x', 'CAB', 2, 'eerina'),
('res_x', 'SGE', 1, 'ddogem'),
('res_x', 'COU', 1, 'bblier'),
('res_x', 'DGA', 1, 'ejarlewski'),
('res_x', 'PSO', 1, 'nnataliu'),
('res_x', 'DGS', 1, 'rrenaud'),
('res_x', 'PJS', 1, 'bbain'),
('res_x', 'PCU', 1, 'bboulle'),
('res_x', 'PTE', 1, 'ccharles'),
('res_x', 'PSF', 1, 'aackermann'),
('res_x', 'SRH', 1, 'ttong'),
('res_x', 'FIN', 1, 'sstarr'),
('res_x', 'INF', 1, 'ccordy'),
('res_x', 'PJS', 2, 'ddur'),
('res_x', 'PCU', 2, 'rrizzo'),
('res_x', 'FIN', 2, 'ccharles'),
('res_x', 'FIN', 3, 'jjane');

--
-- Contenu de la table `models`
--

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

--
-- Contenu de la table `model_service`
--

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

--
-- Contenu de la table `notes`
--

INSERT INTO `notes` (`ID`, `RECORD_ID`, `USER_ID`, `DATE`, `INFO`) VALUES
(1, '3', 'jjane', '2009-01-30 12:42:57', 'TEST'),
(2, '4', 'jjane', '2009-01-30 12:47:10', 'test'),
(3, '5', 'jjane', '2009-01-30 12:59:43', 'TEST');

--
-- Contenu de la table `resgroups`
--


--
-- Contenu de la table `resgroup_content`
--


--
-- Contenu de la table `res_x`
--


--
-- Contenu de la table `saved_queries`
--


--
-- Contenu de la table `security`
--

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'',  ''CAB'',  ''DGS'',  ''ELU'' )', '', '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');

--
-- Contenu de la table `sender`
--

INSERT INTO `sender` (`ID`, `LASTNAME`, `FIRSTNAME`, `SOCIETY`, `FUNCTION`, `STREET`, `TOWN`, `CP`, `PHONE`, `MAIL`, `TOCONTACT`) VALUES
(2, 'DASS', '', '', '', '', '', '', '', '', ''),
(3, 'CAF', '', '', '', '', '', '', '', '', ''),
(4, 'Conseil general', '', '', '', '', '', '', '', '', ''),
(5, 'Mairie', '', '', '', '', '', '', '', '', ''),
(6, 'Mission intercommunale pour la jeunesse', '', '', '', '', '', '', '', '', ''),
(7, 'Office HLM', '', '', '', '', '', '', '', '', ''),
(8, 'Prefecture', '', '', '', '', '', '', '', '', ''),
(9, 'Tresor Public', '', '', '', '', '', '', '', '', ''),
(10, 'Ministere de l''interieur', '', '', '', '', '', '', '', '', '');

--
-- Contenu de la table `services`
--

INSERT INTO `services` (`ID`, `SERVICE`, `ENABLED`) VALUES
('CAB', 'Cabinet du Maire', 'Y'),
('PSO', 'Pole social', 'Y'),
('DGS', 'Direction Generale des Services', 'Y'),
('SGE', 'Secretariat General', 'Y'),
('COU', 'Service Courrier', 'Y'),
('ELU', 'Elus de la ville', 'Y'),
('DGA', 'Direction Generale Adjointe', 'Y'),
('PJS', 'Pole Jeunesse et Sports', 'Y'),
('PCU', 'Pole Culture', 'Y'),
('PTE', 'Pole Technique', 'Y'),
('PSF', 'Pole Services Fonctionnel', 'Y'),
('INF', 'Service Informatique', 'Y'),
('SRH', 'Service Ressources Humaines', 'Y'),
('FIN', 'Service Finances', 'Y');

--
-- Contenu de la table `usergroups`
--

INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `PRINT_RIGHTS`) VALUES
('Enregistrement', 'Droits d''enregistrement', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'N', 'N'),
('SuperAdmin', 'Super Administrateur', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N'),
('Modification', 'Droits de modification', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N'),
('Process', 'Droits de traitement', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N'),
('ViewStats', 'Droits de visualisation des statistiques', 'N', 'Y', 'N', 'Y', 'N', 'N', 'Y', 'N', 'N'),
('gCAB', 'Cabinet du maire', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'N'),
('gDGS', 'Direction generale des services', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N'),
('gSGE', 'Secretariat general', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N'),
('gCOU', 'Service Courrier', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N'),
('gDGA', 'Direction Generale Adjointe', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N'),
('gPSF', 'Poles des services fonctionnels', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N'),
('gINF', 'Service informatique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gDRH', 'Service ressources humaines', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gFIN', 'Service finance', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gPSO', 'Pole social', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gPJS', 'Pole jeunesse et sports', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'N'),
('gPCU', 'Pole Culture', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gPTE', 'Pole Technique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'N'),
('gELU', 'groupe des elus', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N');

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

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'),
('ppetit', 'gCAB', 'Y', 'Maire'),
('eerina', 'gCAB', 'Y', 'secretaire'),
('rrenaud', 'gDGS', 'Y', 'Directeur general des services'),
('ssaporta', 'gDGS', 'Y', 'Assistant'),
('ddogem', 'gSGE', 'Y', 'Secretaire general'),
('jjoubert', 'gSGE', 'Y', 'Assistante'),
('ejarlewski', 'gDGA', 'Y', 'Directeur'),
('bblier', 'gCOU', 'Y', 'responsable'),
('bblier', 'Enregistrement', 'N', 'responsable'),
('bbina', 'gCOU', 'Y', 'agent'),
('bbina', 'Enregistrement', 'N', 'agent'),
('nnataliu', 'gPSO', 'Y', 'Responsable'),
('kkaar', 'gDGA', 'Y', 'secretaire'),
('ccohen', 'gPSO', 'Y', 'agent'),
('bbain', 'gPJS', 'Y', 'Responsable'),
('ttoti', 'gPJS', 'Y', 'agent'),
('bboulle', 'gPCU', 'Y', 'responsable'),
('nnasser', 'gPCU', 'Y', 'agent'),
('ccharles', 'gPTE', 'Y', 'responsable'),
('nnirva', 'gPTE', 'Y', 'agent'),
('aackermann', 'gPSF', 'Y', ''),
('ttibert', 'gPSF', 'Y', 'agent'),
('ttong', 'gDRH', 'Y', 'Responsable'),
('ssolo', 'gDRH', 'Y', 'agent'),
('sstarr', 'gFIN', 'Y', 'Responsable'),
('jjane', 'gFIN', 'Y', 'agent'),
('ddur', 'gELU', 'Y', ''),
('mmerad', 'gINF', 'Y', 'agent'),
('ccordy', 'SuperAdmin', 'N', ''),
('ccordy', 'gINF', 'Y', ''),
('rrizzo', 'gELU', 'Y', '');

--
-- Contenu de la table `user_abs`
--


--
-- Contenu de la table `welcome_txt`
--

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