-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 23 Février 2011 à 10:56
-- Version du serveur: 5.1.41
-- Version de PHP: 5.3.1




--
-- Base de données: 'letterbox_trunk'
--

--
-- Contenu de la table 'arboxes'
--


--
-- Contenu de la table 'arcontainers'
--


--
-- Contenu de la table 'assoc_street_quarter_communes'
--


--
-- Contenu de la table 'authors'
--


--
-- Contenu de la table 'baskets'
--

INSERT INTO baskets (RES_TABLE, BASKET_ID, BASKET_NAME, BASKET_DESC, BASKET_SELECT, BASKET_CLAUSE, BASKET_GROUP_BY, BASKET_ORDER_BY, BASKET_LIMIT, IS_GENERIC, ENABLED, IS_GLOBAL, LOCK_TIME, IS_LOCKABLE, GDD_BASKET, OTHER_LINK) VALUES
('res_x', 'MyBasket', 'Mes Courriers a Traiter', 'Mes Courriers a Traiter', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR, \r\nMAIL_ACTION', '(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', 'N', 'N'),
('res_x', 'ValidationBasket', 'Courriers a valider', 'Mes courriers a valider', 'DESCRIPTION, \r\nRES_ID,  \r\nSTATUS,   \r\nCREATION_DATE,\r\nCREATION_DATE as ARRIVEE, \r\nAUTHOR, \r\nCUSTOM_D2, \r\nDESTINATION, \r\nSOCIETE', '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', 'N', 'N'),
('res_x', 'LateMailBasket', 'Mes courriers en retard', 'Mes courriers en retard', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR', '(STATUS=''NEW'' or STATUS=''COU'') and DEST_USER = @user and now() > CUSTOM_D2 AND IS_FOLDER = ''Y''', NULL, NULL, NULL, 'Y', 'Y', 'Y', '10', 'Y', 'N', 'N'),
('res_x r, listinstance l', 'CopyMailBasket', 'Mes courriers en copie', 'Mes courriers en copie', 'r.DESCRIPTION, \r\nr.RES_ID, \r\nr.TYPE_ID, \r\ndate(r.CUSTOM_D1) as ARRIVEE, \r\nr.AUTHOR,  \r\ndate(r.CUSTOM_D2) as CREATION_DATE, \r\nr.DEST_USER, \r\nr.STATUS, \r\nr.PRIORITY, \r\nl.VIEWED', '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''', NULL, NULL, NULL, 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'DepartmentBasket', 'Courriers de mes services', 'Services autorises', 'SOCIETE, \r\nDESTINATION, \r\nDEST_USER, \r\nDESCRIPTION, \r\nRES_ID, \r\nTYPE_ID,  \r\nAUTHOR,  \r\ndate(CUSTOM_D2) as DATE2,  \r\nSTATUS, \r\nPRIORITY', 'exists (SELECT * FROM users WHERE ELU = ''Y'' AND USER_ID = @user ) and status <> ''DEL'' AND status <> ''END'' AND status <> ''ATT'' and status <> ''MEL'' AND status <> ''VAL'' AND IS_FOLDER = ''Y''', 'RES_ID', 'res_id DESC', '', 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'Dossierencours', 'Les courriers en retour', 'Retour courrier suite a erreur', '', 'dest_user = ''courrier''', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'ValidFacture', 'Factures validees services', 'Factures validees par les services', '', '(status = ''FVA'') and is_folder = ''Y''', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'AClasser', 'Courriers a qualifier', 'Courriers a qualifier', '', '(status = ''ATT'' or status = ''RSV'') and destination in @entities', NULL, NULL, NULL, 'N', 'Y', 'Y', '2', 'Y', 'N', 'N'),
('res_x', 'FactureRejet', 'Factures rejetees services', 'Factures rejetees par les services', '', '(status = ''RJT'') and is_folder = ''Y''', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('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''', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'Courrierduservice', 'Courriers de mon service', 'Courriers de mon service (gestion collective)', 'SOCIETE, \r\nDESTINATION, \r\nDEST_USER, \r\nDESCRIPTION, \r\nRES_ID, \r\nTYPE_ID,  \r\nAUTHOR,  \r\ndate(CUSTOM_D2) as DATE2,  \r\nSTATUS, \r\nPRIORITY', '(status = ''NEW'' or status=''COU'' or status = ''WAI'') and is_folder = ''Y'' and destination = @my_entity', 'RES_ID', 'res_id DESC', '', 'N', 'Y', 'Y', '5', 'Y', 'N', 'N'),
('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()', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'RejetTempFact', 'Facture rejet temporaire', 'Factures rejetees temporairement', '', '(status = ''RJV'') and is_folder = ''Y'' and destination = @my_entity', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'RejetDefinitifFact', 'Factures rejet definitif', 'Factures rejetees definitivement', '', '(status = ''RJD'') and is_folder = ''Y'' and destination = @my_entity and CUSTOM_D2 >= now()', NULL, NULL, NULL, 'N', 'Y', 'N', '', 'N', 'N', 'N');

--
-- Contenu de la table 'baskets_migration'
--

INSERT INTO baskets_migration (RES_TABLE, BASKET_ID, BASKET_NAME, BASKET_DESC, BASKET_SELECT, BASKET_CLAUSE, BASKET_GROUP_BY, BASKET_ORDER_BY, BASKET_LIMIT, IS_GENERIC, ENABLED, IS_GLOBAL, LOCK_TIME, IS_LOCKABLE, GDD_BASKET, OTHER_LINK) VALUES
('res_x', 'MyBasket', 'Mes courriers ', 'Courriers ', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR, \r\nMAIL_ACTION', '(status = ''NEW'' or status=''COU'' or status=''WAI'') and DEST_USER = @user and ( now() <= CUSTOM_D2 OR CUSTOM_D2 IS NULL ) and is_folder = ''Y''', '', '', '', 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'ValidationBasket', 'Mes courriers ', 'Courriers ', 'DESCRIPTION, \r\nRES_ID,  \r\nSTATUS,   \r\nCREATION_DATE,\r\nCREATION_DATE as ARRIVEE, \r\nAUTHOR, \r\nCUSTOM_D2, \r\nDESTINATION, \r\nSOCIETE', 'status = ''VAL'' and is_folder = ''Y''', '', '', '', 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'LateMailBasket', 'Mes courriers en retard', 'Courriers en retards', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR', '(STATUS=''NEW'' or STATUS=''COU'' or status=''WAI'') and DEST_USER = @user and now() > CUSTOM_D2 and is_folder = ''Y''', NULL, NULL, NULL, 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x r, listinstance l', 'CopyMailBasket', 'Mes courriers en copie', 'Liste des courriers en copie', 'r.DESCRIPTION, \r\nr.RES_ID, \r\nr.TYPE_ID, \r\ndate(r.CUSTOM_D1) as ARRIVEE, \r\nr.AUTHOR,  \r\ndate(r.CUSTOM_D2) as CREATION_DATE, \r\nr.DEST_USER, \r\nr.STATUS, \r\nr.PRIORITY, \r\nl.VIEWED', 'l.res_table = ''res_x'' and l.user_id = @user and l.res_id = r.res_id and l.sequence > 1 and ((r.status <> ''END'' and r.status <> ''DEL'' and r.status <> ''ATT'' and r.status <> ''VAL'') or((l.viewed = 0 or l.viewed = 100) and r.status = ''END'')) and is_folder = ''Y''', NULL, NULL, NULL, 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'DepartmentBasket', 'Services autoris', 'Services autoris', 'SOCIETE, \r\nDESTINATION, \r\nDEST_USER, \r\nDESCRIPTION, \r\nRES_ID, \r\nTYPE_ID,  \r\nAUTHOR,  \r\ndate(CUSTOM_D2) as DATE2,  \r\nSTATUS, \r\nPRIORITY', '( status = ''NEW'' or status=''COU'' or status=''WAI'') and is_folder=''Y'' AND \r\nDESTINATION IN @entities and (DEST_USER <> ''courrier'' OR DEST_USER IS NULL)', 'RES_ID', 'res_id DESC', '', 'Y', 'Y', 'N', '', 'N', 'N', 'N'),
('res_x', 'OutMails', 'Mes Courriers sortant', 'Mes courriers sortant', 'SOCIETE, \r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR,  \r\ndate(CREATION_DATE) as DATE1, \r\nDESTINATION', 'IS_INGOING = ''N'' and AUTHOR = @user and is_folder = ''Y''', NULL, NULL, NULL, 'N', 'Y', 'N', NULL, 'N', 'N', 'N'),
('res_x', 'RedirectBasket', 'Retours Courrier', 'Affaires redirig', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, date(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR', 'DEST_USER = ''courrier'' and is_folder = ''Y''', NULL, NULL, NULL, 'N', 'Y', 'Y', '30', 'Y', 'N', 'N'),
('res_x', 'QualifBasket', 'Mes affaires ', 'Mes affaires ', 'res_id, \r\ndestination, \r\nTYPE_ID, \r\nstatus, \r\ndate(creation_date) as date, \r\ndest_user', '(status = ''ATT'' or status =''RSV'') and destination = @my_entity ', NULL, NULL, NULL, 'N', 'Y', 'N', NULL, 'N', 'N', 'N'),
('res_x', 'MyEntityBasket', 'Courriers du service', 'Courriers ', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, \r\ndate(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR, \r\n(SELECT COUNT(*) FROM notes n WHERE n.RECORD_ID = res_x.RES_ID) AS NBR_NOTE,\r\nCOVERAGE,\r\nDESTINATION,\r\nMAIL_ACTION', '(status = ''NEW'' or status=''COU'' or status=''WAI'') and DESTINATION = @my_entity and is_folder = ''Y'' and (DEST_USER <> ''courrier'' OR DEST_USER IS NULL)', '', 'res_id DESC', '', 'Y', 'Y', 'Y', '10', 'Y', 'N', 'N'),
('pre_val_res_x', 'CheckValidationBasket', 'Changements Validation', 'Changements Validation', 'DESCRIPTION, \r\nRES_ID,  \r\nSTATUS,   \r\nCREATION_DATE,\r\nCREATION_DATE as ARRIVEE, \r\nAUTHOR, \r\nCUSTOM_D2, \r\nDESTINATION, \r\nSOCIETE', '1', NULL, NULL, NULL, 'Y', 'Y', 'Y', '10', 'Y', 'N', 'N'),
('res_x  LEFT JOIN notes ON (notes.RECORD_ID = res_x.RES_ID)', 'MyEntitesBasket', 'Courriers de mes services', 'Courriers ', 'SOCIETE,\r\nDESCRIPTION, \r\nRES_ID, \r\nAUTHOR, \r\nTYPE_ID,\r\ndate(CUSTOM_D1) as DATE1, \r\ndate(CUSTOM_D2) as DATE2, \r\ndate(CREATION_DATE) as DATE3, \r\nSTATUS, \r\nPRIORITY, \r\nSOCIETE, \r\nAUTHOR, \r\nCOUNT(notes.ID) AS NBR_NOTE,\r\nCOVERAGE, \r\nDESTINATION', '(status = ''NEW'' or status=''COU'' or status=''WAI'') and DESTINATION IN @entities and is_folder = ''Y'' and (DEST_USER <> ''courrier'' OR DEST_USER IS NULL)', 'RES_ID', '', '', 'N', 'Y', 'Y', '10', 'Y', 'N', 'N'),
('res_x r, listinstance l', 'CopyMailService', 'Copie du service', 'Mes courriers en copie du service', 'r.DESCRIPTION, \r\nr.RES_ID, \r\nr.TYPE_ID, \r\ndate(r.CUSTOM_D1) as ARRIVEE, \r\nr.AUTHOR,  \r\ndate(r.CUSTOM_D2) as CREATION_DATE, \r\nr.STATUS, \r\nr.PRIORITY, \r\nl.VIEWED,\r\nr.DESTINATION,\r\nl.MAIL_ACTION', 'l.res_table = ''res_x'' and \r\n(l.user_id = @user) and (l.res_id = r.res_id) and l.sequence > 1 and l.seen=0 and \r\n(r.status <> ''END'' and r.status <> ''DEL'' and r.status <> ''ATT'' and r.status <> ''VAL'') \r\nand is_folder = ''Y''', '', 'res_id DESC', '', 'Y', 'Y', 'Y', '10', '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, LOCKED, docserver_type_id) 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', 0, 'FASTHD'),
('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', 0, 'FASTHD');

--
-- Contenu de la table 'docserver_types'
--

INSERT INTO docserver_types (docserver_type_id, docserver_type_label, enabled, is_container, container_max_number, is_compressed, compression_mode, is_meta, meta_template, is_logged, log_template, is_signed, fingerprint_mode) VALUES ('FASTHD', 'FASTHD', 'Y', false, 0, false, 'NONE', false, 'NONE', false, 'NONE', true, 'MD5');

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

--
-- Contenu de la table 'domains'
--


--
-- Contenu de la table 'domain_service'
--


--
-- Contenu de la table 'epci'
--


--
-- Contenu de la table 'ext_applications'
--


--
-- Contenu de la table 'ext_docserver'
--


--
-- Contenu de la table 'fileplans'
--


--
-- Contenu de la table 'folderres'
--


--
-- Contenu de la table 'folders'
--


--
-- Contenu de la table 'folderscope'
--


--
-- 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, FKID_DYNAMIC_ARRAY) VALUES
('gFIN', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gINF', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gFIN', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gCOU', 'MyBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gSGE', 'MyBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gPTE', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gPSF', 'MyBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gPCU', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gPJS', 'MyBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gPSO', 'MyBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'dynamic_array', 5),
('gSGE', 'ValidationBasket', 6, '', '', 'N', 'N', 'N', 'dynamic_array', 4),
('gCOU', 'LateMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gSGE', 'LateMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gPSF', 'LateMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gPTE', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gPSO', 'LateMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gPJS', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gPCU', 'LateMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'dynamic_array', 13),
('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', 'dynamic_array', 13),
('gDGA', 'LateMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gFIN', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gCOU', 'CopyMailBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gSGE', 'CopyMailBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gPSF', 'CopyMailBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gPTE', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gPSO', 'CopyMailBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gPJS', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gPCU', 'CopyMailBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'dynamic_array', 1),
('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', 'dynamic_array', 1),
('gDGA', 'CopyMailBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 1),
('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', 'dynamic_array', 1),
('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', 'dynamic_array', 5),
('gFIN', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gFIN'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gCOU', 'DepartmentBasket', 1, '''COU''', '''gCAB'',''gCOU'',''gDGS'',''gSGE''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gSGE', 'DepartmentBasket', 5, '''COU'',''COU''', '''gCAB'',''gCOU'',''gDGS''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gPSF', 'DepartmentBasket', 1, '''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gPTE', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPTE''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gPSO', 'DepartmentBasket', 1, '', '''gCAB''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gPJS', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPJS''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gPCU', 'DepartmentBasket', 1, '', '''gCAB'',''gDGS'',''gPCU''', 'Y', 'N', 'N', 'dynamic_array', 8),
('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', 'dynamic_array', 8),
('gDGA', 'DepartmentBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gDGA', 'MyBasket', 1, '''PSF'',''INF'',''SRH'',''FIN''', '''gCAB'',''gDGA'',''gDGS'',''gDRH'',''gFIN'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 5),
('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', 'dynamic_array', 13),
('gCOU', 'Dossierencours', 2, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '', 'Y', 'N', 'N', 'courrier', 0),
('gFIN', 'ValidFacture', 2, '', '', 'N', 'N', 'N', 'mail_process', 0),
('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', 'dynamic_array', 8),
('gCOU', 'AClasser', 3, '''CAB'',''DGA'',''DGS'',''ELU'',''PCU'',''PJS'',''PSF'',''PSO'',''PTE'',''SGE'',''COU'',''FIN'',''INF'',''SRH''', '', 'Y', 'N', 'N', 'qualif_list', 0),
('gFIN', 'FactureRejet', 3, '', '', 'N', 'N', 'N', 'mail_process', 0),
('gFIN', 'FactuteAttente', 4, '', '', 'N', 'N', 'N', 'mail_process', 0),
('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', 'dynamic_array', 17),
('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', 'dynamic_array', 17),
('gPJS', 'MepFacture', 3, '', '', 'N', 'N', 'N', 'mail_process', 0),
('gPJS', 'RejetTempFact', 4, '', '', 'N', 'N', 'N', 'mail_process', 0),
('gPJS', 'RejetDefinitifFact', 5, '', '', 'Y', 'N', 'N', 'mail_process', 0),
('gINF', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gDRH', 'DepartmentBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 8),
('gINF', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gDRH', 'CopyMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 1),
('gINF', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gINF'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 13),
('gDRH', 'LateMailBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 13),
('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', 'dynamic_array', 5),
('gDRH', 'MyBasket', 1, '', '''gCAB'',''gDGA'',''gDGS'',''gPSF''', 'Y', 'N', 'N', 'dynamic_array', 5);

--
-- Contenu de la table 'groupsecurity'
--


--
-- Contenu de la table 'gtb_tableau'
--

INSERT INTO gtb_tableau (gtb_id, gtb_fkid_basket, gtb_nom, gtb_description, gtb_css_table, gtb_css_entete, gtb_css_ligne1, gtb_css_ligne2, gtb_imprimer_liste, gtb_multi_action, gtb_url_global, gtb_liste_bouton, gtb_nbre_resultat_page, gtb_multi_action_champs, gtb_desc_asc, gtb_table_base, gtb_info_url_global, gtb_multi_action_option) VALUES
(1, 'CopyMailBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'N', 'open|show_folder_doc.php|id=5', 'index.php;page=details,id=5;picto_infos.gif;D', 20, 5, 'Y', 'N', NULL, ''),
(2, 'CopyMailBasket', 'Motifs de Redirection', 'Motifs de Redirection', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'N', 'open|show_folder_doc.php|id=5', 'index.php;page=details,id=5;picto_infos.gif;D', 20, 5, 'Y', 'N', NULL, ''),
(3, 'CopyMailBasket', 'Motifs de Redirection et Statuts', 'Motifs de Redirection et Statuts', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'N', 'open|show_folder_doc.php|id=5', 'index.php;page=details,id=5;picto_infos.gif;D', 20, 5, 'Y', 'N', NULL, ''),
(4, 'ValidationBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|validation.php|id=2', '', 20, 2, 'Y', 'N', '', 'VAL'),
(5, 'MyBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|process.php|id=4', '', 20, 4, 'Y', 'N', NULL, ''),
(6, 'MyBasket', 'Motifs de Redirection', 'Motifs de Redirection', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'process.php|id=4|open', '', 20, 4, 'Y', 'N', NULL, ''),
(7, 'MyBasket', 'Motifs de Redirection et Statuts', 'Motifs de Redirection et Statuts', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'process.php|id=4|open', '', 20, 4, 'Y', 'N', NULL, ''),
(8, 'DepartmentBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|show_folder_doc.php|id=1', 'index.php;page=details,id=1;picto_infos.gif;D', 20, 1, 'Y', 'N', NULL, ''),
(9, 'OutMails', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'N', 'Y', '', 'index.php;page=details,id=1;picto_infos.gif;Fiche d', 20, 1, 'N', 'N', NULL, ''),
(10, 'QualifBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|qualif.php|id=1', '', 20, 1, 'Y', 'N', NULL, ''),
(11, 'MyEntityBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|process.php|id=4', 'show_folder_doc.php;id=4;mail_find.png;Voir le courrier;open', 20, 4, 'Y', 'N', '', ''),
(12, 'CopyMailService', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|show_folder_doc.php|id=3', 'index.php;page=details,id=3;picto_infos.gif;D', 20, 3, 'Y', 'N', '', 'DEL_COP'),
(13, 'LateMailBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|process.php|id=4', '', 20, 4, 'Y', 'N', NULL, ''),
(14, 'RedirectBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|process.php|id=4', 'index.php;page=details,id=4;picto_infos.gif;D', 20, 4, 'Y', 'N', '', ''),
(15, 'MyEntityBasket', 'Assocication de th&egrave;me', 'Assocication de th&egrave;me', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', '', 'process.php;id=4;picto_infos.gif;Traitement du courrier;open|notes_courrier.php;id=4;mail_new3.png;Liste des annoations|show_folder_doc.php;id=4;mail_find.png;Voir le courrier;open', 20, 4, 'Y', 'N', '', ''),
(16, 'CheckValidationBasket', 'Liste de Base', 'Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'before_after_validation.php|id=2|open', '', 20, 2, 'Y', 'N', '', 'DEL_VAL'),
(17, 'Courrierduservice', 'Courriers de mon service Liste de Base', 'Courriers de mon service Liste de Base', 'TABLE_CLASSIQUE', 'ENTETE_CLASSIQUE', 'IMPAIRE_CLASSIQUE', 'PAIRE_CLASSIQUE', 'Y', 'Y', 'open|show_folder_doc.php|id=1', 'index.php;page=details,id=1;picto_infos.gif;D', 20, 1, 'Y', 'N', NULL, '');

--
-- Contenu de la table 'gtb_tableau_champs'
--

INSERT INTO gtb_tableau_champs (gtc_id, gtc_fkid_gtb_tableau, gtc_nom_champs_requete, gtc_format, gtc_alignement, gtc_nom_entete, gtc_position, gtc_taille_px, gtc_tri_dessus, gtc_hidden, gtc_limit_impression, gtc_hidden_print, gtc_taille_mm) VALUES
(1, 1, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 3, 70, '', 'N', '', 'N', 20),
(2, 1, 'VIEWED', 'format_non_lus', 'center', 'Non lus', 2, 10, '', 'N', '', 'Y', 0),
(3, 1, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(4, 1, 'ARRIVEE', 'format_date_arriver_courrier|10|1', 'center', 'Date d''arriv&eacute;e', 4, 80, '', 'N', '', 'N', 20),
(5, 1, 'CREATION_DATE', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(6, 1, 'RES_ID', '', 'center', 'N&deg; GED', 5, 10, '', 'N', '', 'N', 15),
(7, 1, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 6, 100, '', 'N', '20', 'N', 30),
(8, 1, 'DESCRIPTION', 'format_ucfirst_strtolower', 'left', 'Objet', 7, 356, '', 'N', '55', 'N', 75),
(9, 1, 'DEST_USER', 'format_trouver_destinataire', 'left', 'Destinataire', 8, 50, '', 'N', '20', 'N', 30),
(10, 1, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 9, 80, '', 'N', '', 'Y', 0),
(11, 2, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 3, 70, '', 'N', '', 'N', 20),
(12, 2, 'VIEWED', 'format_non_lus', 'center', 'Non lus', 2, 10, '', 'N', '', 'Y', 0),
(13, 2, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(14, 2, 'ARRIVEE', 'format_date_arriver_courrier|10|1', 'center', 'Date d''arriv&eacute;e', 4, 80, '', 'N', '', 'N', 20),
(15, 2, 'CREATION_DATE', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(16, 2, 'RES_ID', '', 'center', 'N&deg; GED', 5, 10, '', 'N', '', 'N', 15),
(17, 2, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 6, 100, '', 'N', '20', 'N', 30),
(18, 2, 'DESCRIPTION', 'format_ucfirst_strtolower', 'left', 'Objet', 7, 186, '', 'N', '55', 'N', 75),
(19, 2, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 8, 80, '', 'N', '', 'Y', 0),
(20, 2, 'DEST_USER', 'format_trouver_destinataire', 'left', 'Destinataire', 9, 100, '', 'N', '20', 'N', 30),
(21, 2, 'MAIL_ACTION', '', 'left', 'Motifs de Redirection', 11, 0, 'tri_motif_redirection', 'Y', '', 'Y', 0),
(22, 3, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 3, 70, '', 'N', '', 'N', 20),
(23, 3, 'VIEWED', 'format_non_lus', 'center', 'Non lus', 2, 10, '', 'N', '', 'Y', 0),
(24, 3, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(25, 3, 'ARRIVEE', 'format_date_arriver_courrier|10|1', 'center', 'Date d''arriv&eacute;e', 4, 80, '', 'N', '', 'N', 20),
(26, 3, 'CREATION_DATE', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(27, 3, 'RES_ID', '', 'center', 'N&deg; GED', 5, 10, '', 'N', '', 'N', 15),
(28, 3, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 6, 100, '', 'N', '20', 'N', 30),
(29, 3, 'DESCRIPTION', 'format_ucfirst_strtolower', 'left', 'Objet', 7, 186, '', 'N', '55', 'N', 75),
(30, 3, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 8, 80, '', 'N', '', 'Y', 0),
(31, 3, 'DEST_USER', 'format_trouver_destinataire', 'left', 'Destinataire', 9, 100, '', 'N', '20', 'N', 30),
(32, 3, 'MAIL_ACTION', '', 'left', 'Motifs de Redirection', 11, 0, 'tri_motif_redirection', 'Y', '', 'Y', 0),
(33, 3, 'STATUS', '', 'left', 'Statut des courriers', 12, 0, 'tri_statut', 'Y', '', 'Y', 0),
(34, 4, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute;', 9, 0, '', 'Y', '', 'Y', 0),
(35, 4, 'STATUS', '', 'left', 'Statut', 8, 0, '', 'Y', '', 'Y', 0),
(36, 4, 'CREATION_DATE', '', 'left', 'Date de cr&eacute;ation', 7, 0, '', 'Y', '', 'Y', 0),
(37, 4, 'CUSTOM_D2', 'format_date_limite|8', 'center', 'Date limite', 6, 80, '', 'N', '', 'N', 30),
(38, 4, 'DESCRIPTION', 'format_objet_societe|9', 'left', 'Objet', 4, 249, '', 'N', '30', 'N', 45),
(39, 4, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 5, 150, '', 'N', '20', 'N', 30),
(40, 4, 'DESTINATION', 'format_service', 'center', 'Service', 3, 150, '', 'N', '', 'N', 40),
(41, 4, 'RES_ID', '', 'right', 'N&deg; GED', 2, 10, '', 'N', '', 'N', 15),
(42, 4, 'ARRIVEE', 'format_date_arriver_courrier|7|8', 'center', 'Date de r&eacute;ception', 1, 80, '', 'N', '', 'N', 30),
(43, 5, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(44, 5, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(45, 5, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(46, 5, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(47, 5, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(48, 5, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(49, 5, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(50, 5, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 249, '', 'N', '60', 'N', 80),
(51, 5, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(52, 5, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(53, 5, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(54, 6, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(55, 6, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(56, 6, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(57, 6, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(58, 6, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(59, 6, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(60, 6, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(61, 6, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 249, '', 'N', '60', 'N', 80),
(62, 6, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(63, 6, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(64, 6, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(65, 6, 'MAIL_ACTION', '', 'left', 'Motifs de Redirection', 12, 0, 'tri_motif_redirection', 'Y', '', 'Y', 0),
(66, 7, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(67, 7, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(68, 7, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(69, 7, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(70, 7, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(71, 7, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(72, 7, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(73, 7, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 249, '', 'N', '60', 'N', 80),
(74, 7, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(75, 7, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(76, 7, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(77, 7, 'MAIL_ACTION', '', 'left', 'Motifs de Redirection', 12, 0, 'tri_motif_redirection', 'Y', '', 'Y', 0),
(78, 7, 'STATUS', '', 'left', 'Statut des courriers', 13, 0, 'tri_statut', 'Y', '', 'Y', 0),
(79, 8, 'RES_ID', '', 'center', 'N&deg; GED', 1, 10, '', 'N', '', 'N', 15),
(80, 8, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(81, 8, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 3, 100, '', 'N', '20', 'N', 30),
(82, 8, 'DESCRIPTION', 'format_objet_societe|9', 'left', 'Objet', 4, 253, '', 'N', '55', 'N', 75),
(83, 8, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 90, '', 'N', '', 'Y', 0),
(84, 8, 'DEST_USER', 'format_trouver_destinataire', 'left', 'Destinataire', 6, 90, '', 'N', '', 'N', 25),
(85, 8, 'DATE2', 'format_date_limite|11', 'center', 'Date limit', 7, 80, '', 'N', '', 'N', 25),
(86, 8, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 8, 0, '', 'Y', '', 'Y', 0),
(87, 8, 'DESTINATION', '', 'left', 'Service', 9, 0, 'tri_service', 'Y', '', 'Y', 0),
(88, 8, 'STATUS', '', 'left', 'Statut des courriers', 10, 0, 'tri_statut', 'Y', '', 'Y', 0),
(89, 9, 'RES_ID', '', 'center', 'N&deg; GED', 1, 10, '', 'N', '', 'Y', 0),
(90, 9, 'DATE1', 'format_date_sans_heure', 'center', 'Date du courrier', 2, 100, '', 'N', '', 'Y', 0),
(91, 9, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Exp&eacute;diteur', 3, 150, '', 'N', '', 'Y', 0),
(92, 9, 'DESCRIPTION', 'format_objet_societe|6', 'left', 'Objet', 4, 237, '', 'N', '', 'Y', 0),
(93, 9, 'DESTINATION', 'format_service', 'center', 'Service', 5, 170, '', 'N', '', 'Y', 0),
(94, 9, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 6, 0, '', 'Y', '', 'Y', 0),
(95, 10, 'res_id', '', 'center', 'N&deg; GED', 1, 10, '', 'N', '', 'N', 15),
(96, 10, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 2, 150, '', 'N', '', 'N', 50),
(97, 10, 'date', 'format_date_sans_heure', 'center', 'Date enregistrement ', 3, 110, '', 'N', '', 'N', 35),
(98, 10, 'destination', 'format_service', 'center', 'Service', 4, 229, '', 'N', '', 'N', 90),
(99, 10, 'status', 'format_statut', 'center', 'Statut', 5, 10, '', 'N', '', 'Y', 0),
(100, 10, 'dest_user', '', 'left', 'Trait&eacute; par', 6, 170, '', 'N', '', 'Y', 0),
(101, 11, 'STATUS', 'format_statut_depart|4', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(102, 11, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(103, 11, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(104, 11, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(105, 11, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(106, 11, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(107, 11, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(108, 11, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 223, '', 'N', '60', 'N', 80),
(109, 11, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(110, 11, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(111, 11, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(112, 12, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(113, 12, 'ARRIVEE', 'format_date_arriver_courrier|10|1', 'center', 'Date d''arriv&eacute;e', 2, 80, '', 'N', '', 'N', 20),
(114, 12, 'CREATION_DATE', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 8, 0, '', 'Y', '', 'Y', 0),
(115, 12, 'RES_ID', '', 'center', 'N&deg; GED', 3, 10, '', 'N', '', 'N', 15),
(116, 12, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 4, 100, '', 'N', '20', 'N', 30),
(117, 12, 'DESCRIPTION', 'format_ucfirst_strtolower', 'left', 'Objet', 5, 223, '', 'N', '65', 'N', 95),
(118, 12, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 6, 80, '', 'N', '', 'Y', 0),
(119, 12, 'DESTINATION', 'format_service', 'left', 'Destinataire', 7, 100, '', 'N', '20', 'N', 30),
(120, 12, 'VIEWED', 'format_non_lus', 'center', 'Non Lus', 9, 10, '', 'N', '', 'Y', 0),
(121, 13, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(122, 13, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(123, 13, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(124, 13, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(125, 13, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(126, 13, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(127, 13, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(128, 13, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 249, '', 'N', '60', 'N', 80),
(129, 13, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(130, 13, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(131, 13, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(132, 14, 'STATUS', 'format_statut', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(133, 14, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(134, 14, 'DATE1', 'format_date_arriver_courrier|9|10', 'center', 'Date d''arriv&eacute;e', 3, 80, '', 'N', '', 'N', 20),
(135, 14, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 9, 0, '', 'Y', '', 'Y', 0),
(136, 14, 'PRIORITY2', '', 'left', 'Statut pour arriv&eacute;e', 10, 0, '', 'Y', '', 'Y', 0),
(137, 14, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(138, 14, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 80, '', 'N', '', 'Y', 0),
(139, 14, 'DESCRIPTION', 'format_objet_societe|11', 'left', 'Objet', 6, 223, '', 'N', '60', 'N', 80),
(140, 14, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 11, 0, '', 'Y', '', 'Y', 0),
(141, 14, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 7, 100, '', 'N', '20', 'N', 30),
(142, 14, 'DATE2', 'format_date_limite|1', 'center', 'Date limite', 8, 80, '', 'N', '', 'N', 25),
(143, 15, 'NBR_NOTE', '', 'center', 'Annotation', 8, 80, '', 'N', '', 'N', 17),
(144, 15, 'COVERAGE', 'format_theme|4', 'center', 'Th&egrave;me', 3, 100, 'tri_theme', 'N', '', 'N', 30),
(145, 15, 'STATUS', 'format_statut_depart|4', 'center', 'Statut', 1, 10, '', 'N', '', 'Y', 0),
(146, 15, 'DESCRIPTION', 'format_ucfirst_strtolower', 'left', 'Objet', 7, 201, '', 'N', '60', 'N', 75),
(147, 15, 'AUTHOR', 'format_ucfirst_strtolower', 'center', 'Emetteur', 6, 120, '', 'N', '20', 'N', 30),
(148, 15, 'RES_ID', '', 'center', 'N&deg; GED', 4, 10, '', 'N', '', 'N', 15),
(149, 15, 'DATE3', '', 'left', 'Date cr&eacute;ation pour arriv&eacute;e', 5, 0, '', 'Y', '', 'Y', 0),
(150, 15, 'DATE1', 'format_date_arriver_courrier|5|1', 'center', 'Date d''arriv&eacute;e', 2, 80, '', 'N', '', 'N', 20),
(151, 16, 'RES_ID', '', 'right', 'N&deg; GED', 2, 10, '', 'N', '', 'N', 15),
(152, 16, 'DESTINATION', 'format_service', 'center', 'Service', 3, 150, '', 'N', '', 'N', 40),
(153, 16, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 5, 150, '', 'N', '20', 'N', 30),
(154, 16, 'DESCRIPTION', 'format_objet_societe|9', 'left', 'Objet', 4, 249, '', 'N', '30', 'N', 45),
(155, 16, 'CUSTOM_D2', 'format_date_limite|8', 'center', 'Date limite', 6, 80, '', 'N', '', 'N', 30),
(156, 16, 'CREATION_DATE', '', 'left', 'Date de cr&eacute;ation', 7, 0, '', 'Y', '', 'Y', 0),
(157, 16, 'STATUS', '', 'left', 'Statut', 8, 0, '', 'Y', '', 'Y', 0),
(158, 16, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute;', 9, 0, '', 'Y', '', 'Y', 0),
(159, 16, 'ARRIVEE', 'format_date_arriver_courrier|7|8', 'center', 'Date de r&eacute;ception', 1, 80, '', 'N', '', 'N', 30),
(160, 17, 'RES_ID', '', 'center', 'N&deg; GED', 1, 10, '', 'N', '', 'N', 15),
(161, 17, 'PRIORITY', 'format_priorite', 'center', 'Priorit&eacute;', 2, 70, '', 'N', '', 'N', 20),
(162, 17, 'AUTHOR', 'format_ucfirst_strtolower', 'left', 'Emetteur', 3, 100, '', 'N', '20', 'N', 30),
(163, 17, 'DESCRIPTION', 'format_objet_societe|9', 'left', 'Objet', 4, 253, '', 'N', '55', 'N', 75),
(164, 17, 'TYPE_ID', 'format_type_courrier', 'left', 'Type de courrier', 5, 90, '', 'N', '', 'Y', 0),
(165, 17, 'DEST_USER', 'format_trouver_destinataire', 'left', 'Destinataire', 6, 90, '', 'N', '', 'N', 25),
(166, 17, 'DATE2', 'format_date_limite|11', 'center', 'Date limit', 7, 80, '', 'N', '', 'N', 25),
(167, 17, 'SOCIETE', '', 'left', 'Soci&eacute;t&eacute; pour objet', 8, 0, '', 'Y', '', 'Y', 0),
(168, 17, 'DESTINATION', '', 'left', 'Service', 9, 0, 'tri_service', 'Y', '', 'Y', 0),
(169, 17, 'STATUS', '', 'left', 'Statut des courriers', 10, 0, 'tri_statut', 'Y', '', 'Y', 0);

--
-- Contenu de la table 'history'
--


--
-- Contenu de la table 'history_batch'
--


--
-- Contenu de la table 'listinstance'
--


--
-- Contenu de la table 'listmodel'
--

INSERT INTO listmodel (ID, RES_TABLE, SEQUENCE, USER_ID, SERVICE_ID) VALUES
(1, 'res_x', 1, 'ppetit', NULL),
(1, 'res_x', 2, 'eerina', NULL),
(12, 'res_x', 1, 'ddogem', NULL),
(2, 'res_x', 1, 'bblier', NULL),
(3, 'res_x', 1, 'ejarlewski', NULL),
(10, 'res_x', 1, 'nnataliu', NULL),
(4, 'res_x', 1, 'rrenaud', NULL),
(8, 'res_x', 1, 'bbain', NULL),
(7, 'res_x', 1, 'bboulle', NULL),
(11, 'res_x', 1, 'ccharles', NULL),
(9, 'res_x', 1, 'aackermann', NULL),
(13, 'res_x', 1, 'ttong', NULL),
(5, 'res_x', 1, 'sstarr', NULL),
(6, 'res_x', 1, 'ccordy', NULL),
(8, 'res_x', 2, 'ddur', NULL),
(7, 'res_x', 2, 'rrizzo', NULL);

--
-- Contenu de la table 'listmodel_assoc'
--

INSERT INTO listmodel_assoc (ID, NAME, ASSOC_SERVICE) VALUES
(1, 'Cabinet du Maire', 'CAB'),
(2, 'Service Courrier', 'COU'),
(3, 'Direction Generale Adjointe', 'DGA'),
(4, 'Direction Generale des Services', 'DGS'),
(5, 'Service Finances', 'FIN'),
(6, 'Service Informatique', 'INF'),
(7, 'Pole Culture', 'PCU'),
(8, 'Pole Jeunesse et Sports', 'PJS'),
(9, 'Pole Services Fonctionnel', 'PSF'),
(10, 'Pole social', 'PSO'),
(11, 'Pole Technique', 'PTE'),
(12, 'Secretariat General', 'SGE'),
(13, 'Service Ressources Humaines', 'SRH');

--
-- Contenu de la table 'models'
--

INSERT INTO models (ID, LABEL, CREATION_DATE, COMMENT, CONTENT, TYPE) VALUES
(1, 'Vide', '2007-09-13 14:00:59', 'Courrier vierge', '', 'HTML'),
(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>', 'HTML'),
(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>', 'HTML'),
(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>', 'HTML'),
(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>', 'HTML');

--
-- 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 'quarter'
--


--
-- 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', '1=1', '', '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', ' DESTINATION IN (  ''(1=-1'' )', '', 'N', 'N'),
('Enregistrement', 'res_x', '', '', 'Y', 'N'),
('Modification', 'res_x', '', '', 'Y', 'Y'),
('Process', 'res_x', '', '', 'Y', 'Y'),
('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, '', NULL),
(3, NULL, 'CAF', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(4, NULL, 'Conseil general', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(5, NULL, 'Mairie', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(6, NULL, 'Mission intercommunale pour la jeunesse', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(7, NULL, 'Office HLM', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(8, NULL, 'Prefecture', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(9, NULL, 'Tresor Public', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL),
(10, NULL, 'Ministere de l''interieur', '', '', '', NULL, '', '', '', '', NULL, NULL, NULL, '', NULL);

--
-- 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 'street'
--


--
-- Contenu de la table 'tickets'
--


--
-- Contenu de la table 'tickets_amounts'
--


--
-- 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, DELETE_MAIL_ACTIONS_RIGHTS, FOLDER_RIGHTS, GDD) VALUES
('Enregistrement', '1 - Profil Courrier', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('SuperAdmin', '1 - Profil Administrateur', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N'),
('Modification', '1 - Profil Agent', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N'),
('Process', '1 - Profil Responsable', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N'),
('Comptable', '1 - Profil Financier', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N'),
('gCAB', 'Cabinet du maire', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gDGS', 'Direction generale des services', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gSGE', 'Secretariat general', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gCOU', 'Service Courrier', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gDGA', 'Direction Generale Adjointe', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gPSF', 'Poles des services fonctionnels', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gINF', 'Service informatique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gDRH', 'Service ressources humaines', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gFIN', 'Service finance', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gPSO', 'Pole social', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gPJS', 'Pole jeunesse et sports', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gPCU', 'Pole Culture', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gPTE', 'Pole Technique', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'),
('gELU', 'Groupe des elus', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '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'),
('sstarr', 'Process', 'N', ''),
('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', ''),
('sstarr', 'Comptable', 'N', ''),
('bbain', 'Process', 'N', '');

--
-- 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 libre de gestion du courrier !!');

