-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Mercredi 21 Octobre 2009 à 18:30
-- Version du serveur: 5.0.27
-- Version de PHP: 5.2.0
-- 
-- Base de données: `letterbox`
-- 

-- 
-- Contenu de la table `arboxes`
-- 


-- 
-- Contenu de la table `arcontainers`
-- 


-- 
-- Contenu de la table `authors`
-- 


-- 
-- Contenu de la table `baskets`
-- 

INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'MyBasket', 'Mes Courriers a Traiter', 'Mes Courriers a Traiter', '(status = ''NEW'' or status=''COU'' or status = ''WAI'') and DEST_USER = @user and is_folder = ''Y'' and ( now() <= CUSTOM_D2 OR CUSTOM_D2 IS NULL )', 'Y', 'Y', 'N', '', 'Y');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'ValidationBasket', 'Courriers a valider', 'Mes courriers a valider', 'exists (SELECT * FROM users WHERE ELU = ''Y'' AND USER_ID = @user ) and (status = ''VAL'' or status = ''VAL1'' or status = ''VAL2'') and IS_FOLDER = ''Y'' and destination in @entities', 'Y', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'LateMailBasket', 'Mes courriers en retard', 'Mes courriers en retard', '(STATUS=''NEW'' or STATUS=''COU'') and DEST_USER = @user and now() > CUSTOM_D2 AND IS_FOLDER = ''Y''', 'Y', 'Y', 'Y', '10', 'Y');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'CopyMailBasket', 'Mes courriers en copie', 'Mes courriers en copie', 'l.res_table = ''res_x'' and \r\n(l.user_id = @user) and \r\n(l.res_id = r.res_id) and \r\n(l.sequence > 1) and \r\n((r.status <> ''END'' and r.status <> ''DEL'' and r.status <> ''ATT''and r.status <> ''VAL'') or\r\n((l.viewed = 0 or l.viewed = 100) and r.status = ''END'')) and is_folder = ''Y''', 'Y', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'DepartmentBasket', 'Courriers de mes services', 'Services autorises', 'exists (SELECT * FROM users WHERE ELU = ''Y'' AND USER_ID = @user ) and status <> ''DEL'' AND status <> ''END'' AND status <> ''ATT'' AND status <> ''VAL'' AND IS_FOLDER = ''Y''', 'Y', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'Dossierencours', 'Les courriers en retour', 'Retour courrier suite a erreur', 'dest_user = ''courrier''', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'ValidFacture', 'Factures validees services', 'Factures validees par les services', '(status = ''FVA'') and is_folder = ''Y''', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'AClasser', 'Courriers a qualifier', 'Courriers a qualifier', '(status = ''ATT'' or status = ''RSV'') and destination in @entities', 'N', 'Y', 'Y', '2', 'Y');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'FactureRejet', 'Factures rejetees services', 'Factures rejetees par les services', '(status = ''RJT'') and is_folder = ''Y''', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'FactuteAttente', 'Factures en attente validation', 'Factures en attente de Validation', 'type_id = ''facture'' and (status in (''NEW'', ''COU'', ''WAI'')) and is_folder = ''Y''', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'Courrierduservice', 'Courriers de mon service', 'Courriers de mon service (gestion collective)', '(status = ''NEW'' or status=''COU'' or status = ''WAI'') and is_folder = ''Y'' and destination = @my_entity', 'N', 'Y', 'Y', '5', 'Y');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'MepFacture', 'Factures mises en paiement', 'Factures mises en paiement', '(status = ''MEP'') and is_folder = ''Y'' and destination = @my_entity and CUSTOM_D2 >= now()', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'RejetTempFact', 'Facture rejet temporaire', 'Factures rejetees temporairement', '(status = ''RJV'') and is_folder = ''Y'' and destination = @my_entity', 'N', 'Y', 'N', '', 'N');
INSERT INTO `baskets` (`RES_TABLE`, `BASKET_ID`, `BASKET_NAME`, `BASKET_DESC`, `BASKET_CLAUSE`, `IS_GENERIC`, `ENABLED`, `IS_GLOBAL`, `LOCK_TIME`, `IS_LOCKABLE`) VALUES ('res_x', 'RejetDefinitifFact', 'Factures rejet definitif', 'Factures rejetees definitivement', '(status = ''RJD'') and is_folder = ''Y'' and destination = @my_entity and CUSTOM_D2 >= now()', 'N', 'Y', 'N', '', 'N');

-- 
-- Contenu de la table `borough`
-- 


-- 
-- Contenu de la table `cantons`
-- 


-- 
-- Contenu de la table `coll_serv`
-- 


-- 
-- Contenu de la table `communes`
-- 


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

-- 
-- 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');
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', 'autre', 'Autres', 21, 14, 1, NULL, 'demo', '2008-07-08 17:27:12', 'Y', 'N', 'vierge');
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', 'ITT', 'Arret de travail', 10, 5, 1, NULL, 'demo', '2008-07-08 17:27:44', 'Y', 'N', 'vierge');
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', 'confirmation', 'Confirmation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:29:33', 'Y', 'N', 'vierge');
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', 'notification', 'Notification', 21, 14, 1, NULL, 'demo', '2008-07-08 17:30:18', 'Y', 'N', 'vierge');
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', 'sinistre', 'Sinistre', 14, 7, 1, NULL, 'demo', '2008-07-08 17:30:42', 'Y', 'N', 'vierge');
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', 'facture', 'Facture', 30, 5, 1, NULL, 'demo', '2008-07-08 17:31:53', 'Y', 'N', 'vierge');
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', 'BonDeCommande', 'Bon de Commande', 10, 5, 1, NULL, 'demo', '2008-07-08 17:32:33', 'Y', 'N', 'vierge');
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', 'DemandeAutorisation', 'Demande d''autorisation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:12', 'Y', 'N', 'vierge');
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', 'DemandeConges', 'Demande de conges', 21, 14, 1, NULL, 'demo', '2008-07-08 17:33:35', 'Y', 'N', 'vierge');
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', 'DemandeInscription', 'Demande d''inscription', 21, 14, 1, NULL, 'demo', '2008-07-08 17:38:40', 'Y', 'N', 'vierge');
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', 'NoteService', 'Note de service', 21, 14, 1, NULL, 'demo', '2008-07-08 17:39:53', 'Y', 'Y', 'Note de service');
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', 'DemandeReservation', 'Demande de reservation', 21, 14, 1, NULL, 'demo', '2008-07-08 17:40:19', 'Y', 'N', 'vierge');
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', 'DemandeReunion', 'Demande de reunion', 21, 14, 1, NULL, 'demo', '2008-07-08 17:56:26', 'Y', 'N', 'vierge');
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', 'AppelTelephonique', 'Appel Telephonique', 21, 14, 1, NULL, 'demo', '2008-07-08 17:57:13', 'Y', 'Y', 'vierge');
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', '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 `domain_service`
-- 


-- 
-- Contenu de la table `domains`
-- 


-- 
-- Contenu de la table `epci`
-- 


-- 
-- 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 ('gFIN', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'MyBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gSGE', 'MyBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPTE', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSF', 'MyBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPCU', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSO', 'MyBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gSGE', 'ValidationBasket', 6, '', '', 'N', 'N', 'N', 'courrier');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'LateMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gSGE', 'LateMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSF', 'LateMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPTE', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSO', 'LateMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPCU', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDGA', 'LateMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'CopyMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gSGE', 'CopyMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSF', 'CopyMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPTE', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSO', 'CopyMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPCU', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDGA', 'CopyMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'DepartmentBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gSGE', 'DepartmentBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSF', 'DepartmentBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPTE', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPSO', 'DepartmentBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPCU', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDGA', 'DepartmentBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDGA', 'MyBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'Dossierencours', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '', 'Y', 'N', 'N', 'courrier');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'ValidFacture', 2, '', '', 'N', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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 `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gCOU', 'AClasser', 3, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '', 'Y', 'N', 'N', 'qualif_list');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'FactureRejet', 3, '', '', 'N', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gFIN', 'FactuteAttente', 4, '', '', 'N', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'Courrierduservice', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '''gCAB'',''gDGA'',''gDGS'',''gELU'',''gPCU'',''gPJS'',''gPSO'',''gPTE'',''gPSF'',''gSGE'',''gCOU'',''gFIN'',''gINF'',''gDRH''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPCU', 'Courrierduservice', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '''gCAB'',''gDGA'',''gDGS'',''gELU'',''gPCU'',''gPJS'',''gPSO'',''gPTE'',''gPSF'',''gSGE'',''gCOU'',''gFIN'',''gINF'',''gDRH''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'MepFacture', 3, '', '', 'N', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'RejetTempFact', 4, '', '', 'N', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gPJS', 'RejetDefinitifFact', 5, '', '', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gINF', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDRH', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'auth_dep');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gINF', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDRH', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'copy_mail');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gINF', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDRH', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'mail_process');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('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');
INSERT INTO `groupbasket` (`GROUP_ID`, `BASKET_ID`, `SEQUENCE`, `REDIRECT_BASKETLIST`, `REDIRECT_GROUPLIST`, `CAN_REDIRECT`, `CAN_DELETE`, `CAN_INSERT`, `RESULT_PAGE`) VALUES ('gDRH', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'mail_process');

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


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

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

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

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

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

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

-- 
-- 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', '');
INSERT INTO `models` (`ID`, `LABEL`, `CREATION_DATE`, `COMMENT`, `CONTENT`) VALUES (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>');
INSERT INTO `models` (`ID`, `LABEL`, `CREATION_DATE`, `COMMENT`, `CONTENT`) VALUES (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>');
INSERT INTO `models` (`ID`, `LABEL`, `CREATION_DATE`, `COMMENT`, `CONTENT`) VALUES (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>');
INSERT INTO `models` (`ID`, `LABEL`, `CREATION_DATE`, `COMMENT`, `CONTENT`) VALUES (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 `res_x`
-- 


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


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


-- 
-- 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', '1=1', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gCAB', 'res_x', ' DESTINATION IN (  ''PTE'',  ''COU'',  ''SRH'',  ''CAB'',  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''DGS'',  ''PSO'',  ''SGE'',  ''FIN'',  ''INF'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gDGS', 'res_x', ' DESTINATION IN (  ''DGA'',  ''DGS'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gSGE', 'res_x', ' DESTINATION IN (  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gCOU', 'res_x', ' DESTINATION IN (  ''(1=-1'',  ''CAB'',  ''DGA'',  ''DGS'',  ''ELU'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''SGE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gDGA', 'res_x', ' DESTINATION IN (  ''DGA'',  ''PCU'',  ''PJS'',  ''PSF'',  ''PSO'',  ''PTE'',  ''COU'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gPSF', 'res_x', ' DESTINATION IN (  ''PSF'',  ''FIN'',  ''INF'',  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gINF', 'res_x', ' DESTINATION IN (  ''INF'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gDRH', 'res_x', ' DESTINATION IN (  ''SRH'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gFIN', 'res_x', ' DESTINATION IN (  ''FIN'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gPSO', 'res_x', ' DESTINATION IN (  ''PSO'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gPJS', 'res_x', ' DESTINATION IN (  ''PJS'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gPCU', 'res_x', ' DESTINATION IN (  ''PCU'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gPTE', 'res_x', ' DESTINATION IN (  ''PTE'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('gELU', 'res_x', ' DESTINATION IN (  ''(1=-1'' )', '', 'N', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('Enregistrement', 'res_x', '', '', 'Y', 'N');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('Modification', 'res_x', '', '', 'Y', 'Y');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('Process', 'res_x', '', '', 'Y', 'Y');
INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES ('Comptable', 'res_x', '', '', 'Y', 'Y');

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

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

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

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

-- 
-- Contenu de la table `tickets`
-- 


-- 
-- Contenu de la table `tickets_amounts`
-- 


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


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

INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('demo', 'SuperAdmin', 'Y', 'Consultant');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('demo', 'Enregistrement', 'N', 'Consultant');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('demo', 'Modification', 'N', 'Consultant');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('demo', 'Process', 'N', 'Consultant');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('sstarr', 'Process', 'N', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ppetit', 'gCAB', 'Y', 'Maire');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('eerina', 'gCAB', 'Y', 'secretaire');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('rrenaud', 'gDGS', 'Y', 'Directeur general des services');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ssaporta', 'gDGS', 'Y', 'Assistant');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ddogem', 'gSGE', 'Y', 'Secretaire general');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('jjoubert', 'gSGE', 'Y', 'Assistante');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ejarlewski', 'gDGA', 'Y', 'Directeur');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bblier', 'gCOU', 'Y', 'responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bblier', 'Enregistrement', 'N', 'responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bbina', 'gCOU', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bbina', 'Enregistrement', 'N', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('nnataliu', 'gPSO', 'Y', 'Responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('kkaar', 'gDGA', 'Y', 'secretaire');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ccohen', 'gPSO', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bbain', 'gPJS', 'Y', 'Responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ttoti', 'gPJS', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bboulle', 'gPCU', 'Y', 'responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('nnasser', 'gPCU', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ccharles', 'gPTE', 'Y', 'responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('nnirva', 'gPTE', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('aackermann', 'gPSF', 'Y', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ttibert', 'gPSF', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ttong', 'gDRH', 'Y', 'Responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ssolo', 'gDRH', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('sstarr', 'gFIN', 'Y', 'Responsable');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('jjane', 'gFIN', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ddur', 'gELU', 'Y', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('mmerad', 'gINF', 'Y', 'agent');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ccordy', 'SuperAdmin', 'N', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('ccordy', 'gINF', 'Y', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('rrizzo', 'gELU', 'Y', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('sstarr', 'Comptable', 'N', '');
INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES ('bbain', 'Process', 'N', '');

-- 
-- 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`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('Enregistrement', '1 - Profil Courrier', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('SuperAdmin', '1 - Profil Administrateur', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('Modification', '1 - Profil Agent', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('Process', '1 - Profil Responsable', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('Comptable', '1 - Profil Financier', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'Y');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gCAB', 'Cabinet du maire', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gDGS', 'Direction generale des services', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gSGE', 'Secretariat general', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gCOU', 'Service Courrier', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gDGA', 'Direction Generale Adjointe', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gPSF', 'Poles des services fonctionnels', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gINF', 'Service informatique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gDRH', 'Service ressources humaines', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gFIN', 'Service finance', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gPSO', 'Pole social', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gPJS', 'Pole jeunesse et sports', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gPCU', 'Pole Culture', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gPTE', 'Pole Technique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`, `DELETE_RIGHTS`, `DELETE_COPY_RIGHTS`, `PRINT_RIGHTS`, `PARAM`, `PRINT_SEP_RIGHTS`, `ATTACHMENT_RIGHTS`, `CLOSE_RIGHTS`, `MAIL_RIGHTS`, `REJECT_RIGHTS`, `DEF_REJECT_RIGHTS`, `VALIDATE_RIGHTS`) VALUES ('gELU', 'Groupe des elus', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');

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

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