
USE letterboxv2_3;

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

INSERT INTO `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', 'My Mail to process', 'My Mail to process', '(status = ''NEW'' or status=''COU'') and DEST_USER = @user', 'Y', 'Y'),
('res_x', 'ValidationBasket', 'My mail to validate', 'My mail to validate', 'status = ''VAL''', 'Y', 'Y'),
('res_x', 'LateMailBasket', 'My late Mail', 'My late Mail', '(STATUS=''NEW'' or STATUS=''COU'') and DEST_USER = @user and now() > CUSTOM_D2', 'Y', 'Y'),
('res_x', 'CopyMailBasket', 'My mail in copy', 'My mail in copy', 'l.res_table = ''res_x'' and l.user_id = @user and l.res_id = r.res_id and l.sequence > 1 and ( r.status=''NEW'' or r.status=''COU'') ', 'Y', 'Y'),
('res_x', 'DepartmentBasket', 'Authorized departments', 'SAuthorized departments', 'status <> ''DEL'' AND status <> ''REP'' and status <> ''VAL''', 'Y', 'Y'),
('res_x', 'OutMails', 'My outgoing mail', 'My outgoing mail', 'STATUS = ''OUT'' and IS_INGOING = ''N'' and AUTHOR = @user', 'N', 'Y');
