DELETE FROM t_task WHERE task_id BETWEEN 2000 AND 2088;
DELETE FROM t_role_task;

INSERT INTO t_task(module_id, task_code, task_name, description, task_type, task_group,
            create_datetime, create_user_id, update_datetime, update_user_id,
            "version", active, active_datetime, non_active_datetime, always_allow)
    VALUES
(100, 'MANAGE_ADMINISTRATION_POS', 'manageAdministrationPos', 'manage administration pos', 'POS', 'pos.admin', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'DO_MONTHLY_PROCESS', 'doMonthlyProcess', 'do monthly process', 'POS', 'pos.admin', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'INPUT_POS', 'inputPos', 'input pos', 'POS', 'pos.trx', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'INQUIRY_POS', 'inquiryPos', 'inquiry pos', 'POS', 'pos.trx', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'INPUT_GOODS_TRANSFER_IN', 'inputGoodsTransferIn', 'input goods transfer in', 'POS', 'pos.trx', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'INPUT_GOODS_TRANSFER_OUT', 'inputGoodsTransferOut', 'input goods transfer out', 'POS', 'pos.trx', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'UPDATE_DATA_MASTER', 'updateDataMaster', 'update data master', 'POS', 'pos.sync', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'UPDATE_DATA_TRX', 'updateDataTrx', 'input pos', 'POS', 'pos.sync', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'TRANSFER_DATA_TO_SERVER', 'transferDataToServer', 'transfer data to server', 'POS', 'pos.sync', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'VIEW_REPORT_POS', 'viewReportPos', 'view report pos', 'POS', 'pos.report', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N'),
(100, 'VOID_POS', 'voidPos', 'void pos', 'POS', 'pos.trx', '20130823110000',-1,'20130823110000',-1,0,'Y','20130823110000',' ','N');

INSERT INTO t_role_task (task_id, role_id,
            create_datetime, create_user_id, update_datetime, update_user_id,
            "version", active, active_datetime, non_active_datetime)
SELECT A.task_id, B.role_id,
       '20130823110000',-1,'20130823110000',-1,
       0,'Y','20130823110000',' '
FROM t_task A, t_role B
WHERE B.role_type = 'ADMIN'
AND A.task_type = 'POS';

INSERT INTO t_role_task (task_id, role_id,
            create_datetime, create_user_id, update_datetime, update_user_id,
            "version", active, active_datetime, non_active_datetime)
SELECT A.task_id, B.role_id,
       '20130823110000',-1,'20130823110000',-1,
       0,'Y','20130823110000',' '
FROM t_task A, t_role B
WHERE B.role_type <> 'ADMIN'
AND A.task_type = 'POS' AND A.task_group <> 'pos.admin';