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

INSERT INTO `security` (`GROUP_ID`, `RES_TABLE`, `WHERE_CLAUSE`, `COMMENT`, `CAN_INSERT`, `CAN_UPDATE`) VALUES
('SuperAdmin', 'res_x', ' DESTINATION IN (  '''' )', '', 'N', 'N'),
('Recording', 'res_x', '', '', 'Y', 'N'),
('Modifying', 'res_x', '', '', 'N', 'Y');

INSERT INTO `usergroups` (`GROUP_ID`, `GROUP_DESC`, `ADMINISTRATOR`, `CONSULT_GROUP`, `VIEW_RELANCE`, `VIEW_STATS`, `MODIF_RIGHTS`, `EXPORT`, `ENABLED`) VALUES
('Recording', 'Recording rights', 'N', 'N', 'N', 'N', 'N', 'N', 'Y'),
('SuperAdmin', 'Super Administrator', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'),
('Modifying', 'Modifying rights', 'N', 'Y', 'N', 'N', 'Y', 'N', 'Y'),
('Processing', 'Processing rights', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'Y'),
('ViewStats', 'Stats viewing rights', 'N', 'Y', 'N', 'Y', 'N', 'N', 'Y');

INSERT INTO `services` (`ID`, `SERVICE`, `ENABLED`) VALUES
('INF', 'IT Department', 'Y');

INSERT INTO `usergroup_content` (`USER_ID`, `GROUP_ID`, `PRIMARY_GROUP`, `ROLE`) VALUES
('demo', 'SuperAdmin', 'Y', 'Consultant');

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

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