1403 lines
50 KiB
SQL
Executable File
1403 lines
50 KiB
SQL
Executable File
|
|
/*==============================================================*/
|
|
/* 区块链充值订单--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_RECHARGE_BLOCKCHAIN_LIST','/normal/adminRechargeBlockchainOrderAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_RECHARGE_BLOCKCHAIN_LIST','ADMIN_RECHARGE_BLOCKCHAIN_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_RECHARGE_BLOCKCHAIN_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_RECHARGE_BLOCKCHAIN_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_RECHARGE_BLOCKCHAIN_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_RECHARGE_BLOCKCHAIN_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值订单--到账 */
|
|
/*==============================================================*/
|
|
/*onsucceeded*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED','/normal/adminRechargeBlockchainOrderAction!onsucceeded.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED','ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_RECHARGE_BLOCKCHAIN_ONSUCCEEDED');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值订单--驳回 */
|
|
/*==============================================================*/
|
|
/*reject*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_RECHARGE_BLOCKCHAIN_REJECT','/normal/adminRechargeBlockchainOrderAction!reject.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_RECHARGE_BLOCKCHAIN_REJECT','ADMIN_RECHARGE_BLOCKCHAIN_REJECT','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_RECHARGE_BLOCKCHAIN_REJECT');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_RECHARGE_BLOCKCHAIN_REJECT');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_RECHARGE_BLOCKCHAIN_REJECT');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_RECHARGE_BLOCKCHAIN_REJECT');
|
|
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值地址维护--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CHANNEL_BLOCKCHAIN_LIST','/normal/adminChannelBlockchainAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CHANNEL_BLOCKCHAIN_LIST','ADMIN_CHANNEL_BLOCKCHAIN_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CHANNEL_BLOCKCHAIN_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CHANNEL_BLOCKCHAIN_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CHANNEL_BLOCKCHAIN_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CHANNEL_BLOCKCHAIN_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值地址维护--修改界面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE','/normal/adminChannelBlockchainAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE','ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CHANNEL_BLOCKCHAIN_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值地址维护--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CHANNEL_BLOCKCHAIN_UPDATE','/normal/adminChannelBlockchainAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CHANNEL_BLOCKCHAIN_UPDATE','ADMIN_CHANNEL_BLOCKCHAIN_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CHANNEL_BLOCKCHAIN_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CHANNEL_BLOCKCHAIN_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CHANNEL_BLOCKCHAIN_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CHANNEL_BLOCKCHAIN_UPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 区块链充值地址维护--删除 */
|
|
/*==============================================================*/
|
|
/*todelete*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CHANNEL_BLOCKCHAIN_TODELETE','/normal/adminChannelBlockchainAction!toDelete.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CHANNEL_BLOCKCHAIN_TODELETE','ADMIN_CHANNEL_BLOCKCHAIN_TODELETE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CHANNEL_BLOCKCHAIN_TODELETE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CHANNEL_BLOCKCHAIN_TODELETE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CHANNEL_BLOCKCHAIN_TODELETE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CHANNEL_BLOCKCHAIN_TODELETE');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 货币汇率配置--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_EXCHANGE_RATE_LIST','/normal/adminExchangeRateAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_EXCHANGE_RATE_LIST','ADMIN_EXCHANGE_RATE_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_EXCHANGE_RATE_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_EXCHANGE_RATE_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_EXCHANGE_RATE_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_EXCHANGE_RATE_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 货币汇率配置--修改界面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_EXCHANGE_RATE_TOUPDATE','/normal/adminExchangeRateAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_EXCHANGE_RATE_TOUPDATE','ADMIN_EXCHANGE_RATE_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_EXCHANGE_RATE_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_EXCHANGE_RATE_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_EXCHANGE_RATE_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_EXCHANGE_RATE_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 货币汇率配置--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_EXCHANGE_RATE_UPDATE','/normal/adminExchangeRateAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_EXCHANGE_RATE_UPDATE','ADMIN_EXCHANGE_RATE_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_EXCHANGE_RATE_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_EXCHANGE_RATE_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_EXCHANGE_RATE_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_EXCHANGE_RATE_UPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 账变记录--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_MONEY_LOG_LIST','/normal/adminMoneyLogAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_MONEY_LOG_LIST','ADMIN_MONEY_LOG_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_MONEY_LOG_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_MONEY_LOG_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_MONEY_LOG_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_MONEY_LOG_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_LIST','/normal/adminAgentAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_LIST','ADMIN_AGENT_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--添加界面 */
|
|
/*==============================================================*/
|
|
/*toadd*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_TOADD','/normal/adminAgentAction!toAdd.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_TOADD','ADMIN_AGENT_TOADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_TOADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_TOADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--添加保存 */
|
|
/*==============================================================*/
|
|
/*add*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_ADD','/normal/adminAgentAction!add.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_ADD','ADMIN_AGENT_ADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_ADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_ADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--修改界面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_TOUPDATE','/normal/adminAgentAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_TOUPDATE','ADMIN_AGENT_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_UPDATE','/normal/adminAgentAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_UPDATE','ADMIN_AGENT_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_UPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理商管理--重置登录密码 */
|
|
/*==============================================================*/
|
|
/*resetpsw*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_AGENT_RESETPSW','/normal/adminAgentAction!resetpsw.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_AGENT_RESETPSW','ADMIN_AGENT_RESETPSW','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_AGENT_RESETPSW');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_AGENT_RESETPSW');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_AGENT_RESETPSW');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_AGENT_RESETPSW');
|
|
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_LIST','/normal/adminUserAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_LIST','ADMIN_USER_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--添加界面 */
|
|
/*==============================================================*/
|
|
/*toadd*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_TOADD','/normal/adminUserAction!toAdd.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_TOADD','ADMIN_USER_TOADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_TOADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_TOADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--添加保存 */
|
|
/*==============================================================*/
|
|
/*add*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_ADD','/normal/adminUserAction!add.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_ADD','ADMIN_USER_ADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_ADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_ADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--修改界面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_TOUPDATE','/normal/adminUserAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_TOUPDATE','ADMIN_USER_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_UPDATE','/normal/adminUserAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_UPDATE','ADMIN_USER_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_UPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--修改账户余额 */
|
|
/*==============================================================*/
|
|
/*reset*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_RESET','/normal/adminUserAction!reset.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_RESET','ADMIN_USER_RESET','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_RESET');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_RESET');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_RESET');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_RESET');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户管理--重置登录密码 */
|
|
/*==============================================================*/
|
|
/*resetpsw*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_RESETPSW','/normal/adminUserAction!resetpsw.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_RESETPSW','ADMIN_USER_RESETPSW','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_RESETPSW');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_RESETPSW');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_RESETPSW');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_RESETPSW');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户推荐关系管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_RECOM_LIST','/normal/adminUserRecomAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_RECOM_LIST','ADMIN_USER_RECOM_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_RECOM_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_RECOM_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_RECOM_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_RECOM_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户推荐关系管理--修改界面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_RECOM_TOUPDATE','/normal/adminUserRecomAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_RECOM_TOUPDATE','ADMIN_USER_RECOM_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_RECOM_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_RECOM_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_RECOM_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_RECOM_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户推荐关系管理--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_RECOM_UPDATE','/normal/adminUserRecomAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_RECOM_UPDATE','ADMIN_USER_RECOM_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_RECOM_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_RECOM_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_RECOM_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_RECOM_UPDATE');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户基础认证管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_LIST','/normal/adminKycAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_LIST','ADMIN_KYC_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户基础认证管理--审核通过 */
|
|
/*==============================================================*/
|
|
/*savepassed*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_SAVEPASSED','/normal/adminKycAction!savePassed.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_SAVEPASSED','ADMIN_KYC_SAVEPASSED','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_SAVEPASSED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_SAVEPASSED');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_SAVEPASSED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_SAVEPASSED');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户基础认证管理--驳回 */
|
|
/*==============================================================*/
|
|
/*savefailed*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_SAVEFAILED','/normal/adminKycAction!saveFailed.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_SAVEFAILED','ADMIN_KYC_SAVEFAILED','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_SAVEFAILED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_SAVEFAILED');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_SAVEFAILED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_SAVEFAILED');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户高级认证管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_HIGH_LEVEL_LIST','/normal/adminKycHighLevelAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_HIGH_LEVEL_LIST','ADMIN_KYC_HIGH_LEVEL_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_HIGH_LEVEL_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_HIGH_LEVEL_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_HIGH_LEVEL_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_HIGH_LEVEL_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户高级认证管理--审核通过 */
|
|
/*==============================================================*/
|
|
/*savepassed*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_HIGH_LEVEL_SAVEPASSED','/normal/adminKycHighLevelAction!savePassed.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_HIGH_LEVEL_SAVEPASSED','ADMIN_KYC_HIGH_LEVEL_SAVEPASSED','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_HIGH_LEVEL_SAVEPASSED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_HIGH_LEVEL_SAVEPASSED');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_HIGH_LEVEL_SAVEPASSED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_HIGH_LEVEL_SAVEPASSED');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 用户高级认证管理--驳回 */
|
|
/*==============================================================*/
|
|
/*savefailed*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_KYC_HIGH_LEVEL_SAVEFAILED','/normal/adminKycHighLevelAction!saveFailed.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_KYC_HIGH_LEVEL_SAVEFAILED','ADMIN_KYC_HIGH_LEVEL_SAVEFAILED','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_KYC_HIGH_LEVEL_SAVEFAILED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_KYC_HIGH_LEVEL_SAVEFAILED');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_KYC_HIGH_LEVEL_SAVEFAILED');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_KYC_HIGH_LEVEL_SAVEFAILED');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 总收益报表--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_ALL_STATISTICS_LIST','/normal/adminAllStatisticsAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_ALL_STATISTICS_LIST','ADMIN_ALL_STATISTICS_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_ALL_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_ALL_STATISTICS_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_ALL_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_ALL_STATISTICS_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 总收益报表--导出Excel */
|
|
/*==============================================================*/
|
|
/*exportdata*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_ALL_STATISTICS_EXPORTDATA','/normal/adminAllStatisticsAction!exportData.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_ALL_STATISTICS_EXPORTDATA','ADMIN_ALL_STATISTICS_EXPORTDATA','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_ALL_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_ALL_STATISTICS_EXPORTDATA');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_ALL_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_ALL_STATISTICS_EXPORTDATA');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 总收益报表--生成统计 */
|
|
/*==============================================================*/
|
|
/*sycnstatistics*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_ALL_STATISTICS_SYCNSTATISTICS','/normal/adminAllStatisticsAction!sycnStatistics.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_ALL_STATISTICS_SYCNSTATISTICS','ADMIN_ALL_STATISTICS_SYCNSTATISTICS','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_ALL_STATISTICS_SYCNSTATISTICS');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_ALL_STATISTICS_SYCNSTATISTICS');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_ALL_STATISTICS_SYCNSTATISTICS');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_ALL_STATISTICS_SYCNSTATISTICS');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 永续合约收益统计--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CONTRACT_ORDER_STATISTICS_LIST','/normal/adminContractOrderStatisticsAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CONTRACT_ORDER_STATISTICS_LIST','ADMIN_CONTRACT_ORDER_STATISTICS_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CONTRACT_ORDER_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CONTRACT_ORDER_STATISTICS_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CONTRACT_ORDER_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CONTRACT_ORDER_STATISTICS_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 永续合约收益统计--导出Excel */
|
|
/*==============================================================*/
|
|
/*exportdata*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA','/normal/adminContractOrderStatisticsAction!exportData.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA','ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_CONTRACT_ORDER_STATISTICS_EXPORTDATA');
|
|
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 币币交易收益统计--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_EXCHANGE_ORDER_STATISTICS_LIST','/normal/adminExchangeOrderStatisticsAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_EXCHANGE_ORDER_STATISTICS_LIST','ADMIN_EXCHANGE_ORDER_STATISTICS_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_EXCHANGE_ORDER_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_EXCHANGE_ORDER_STATISTICS_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_EXCHANGE_ORDER_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_EXCHANGE_ORDER_STATISTICS_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 币币交易收益统计--导出Excel */
|
|
/*==============================================================*/
|
|
/*exportdata*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA','/normal/adminExchangeOrderStatisticsAction!exportData.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA','ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_EXCHANGE_ORDER_STATISTICS_EXPORTDATA');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 充提金额统计--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_MONEY_IN_OUT_STATISTICS_LIST','/normal/adminMoneyInOutStatisticsAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_MONEY_IN_OUT_STATISTICS_LIST','ADMIN_MONEY_IN_OUT_STATISTICS_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_MONEY_IN_OUT_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_MONEY_IN_OUT_STATISTICS_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_MONEY_IN_OUT_STATISTICS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_MONEY_IN_OUT_STATISTICS_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 充提金额统计--导出Excel */
|
|
/*==============================================================*/
|
|
/*exportdata*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA','/normal/adminMoneyInOutStatisticsAction!exportData.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA','ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_MONEY_IN_OUT_STATISTICS_EXPORTDATA');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 代理分润对账报表--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_USER_DATE_LIST','/normal/adminUserDataAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_USER_DATE_LIST','ADMIN_USER_DATE_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_USER_DATE_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_USER_DATE_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_USER_DATE_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_USER_DATE_LIST');
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--列表 */
|
|
/*==============================================================*/
|
|
/*list*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_LIST','/normal/adminNewsAction!list.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_LIST','ADMIN_NEWS_LIST','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_LIST');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_LIST');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_LIST');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--新增页面 */
|
|
/*==============================================================*/
|
|
/*toadd*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_TOADD','/normal/adminNewsAction!toAdd.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_TOADD','ADMIN_NEWS_TOADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_TOADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_TOADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_TOADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--新增保存 */
|
|
/*==============================================================*/
|
|
/*add*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_ADD','/normal/adminNewsAction!add.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_ADD','ADMIN_NEWS_ADD','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_ADD');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_ADD');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_ADD');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--修改页面 */
|
|
/*==============================================================*/
|
|
/*toupdate*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_TOUPDATE','/normal/adminNewsAction!toUpdate.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_TOUPDATE','ADMIN_NEWS_TOUPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_TOUPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_TOUPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_TOUPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--修改保存 */
|
|
/*==============================================================*/
|
|
/*update*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_UPDATE','/normal/adminNewsAction!update.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_UPDATE','ADMIN_NEWS_UPDATE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_UPDATE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_UPDATE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_UPDATE');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--详情页 */
|
|
/*==============================================================*/
|
|
/*details*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_DETAILS','/normal/adminNewsAction!details.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_DETAILS','ADMIN_NEWS_DETAILS','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_DETAILS');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_DETAILS');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_DETAILS');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_DETAILS');
|
|
|
|
|
|
|
|
|
|
/*==============================================================*/
|
|
/* 新闻管理--删除 */
|
|
/*==============================================================*/
|
|
/*delete*/
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('URL_ADMIN_NEWS_DELETE','/normal/adminNewsAction!delete.action*','URL');
|
|
INSERT INTO `SCT_RESOURCE` (`UUID`, `RES_STRING`, `RES_TYPE`)
|
|
VALUES
|
|
('ADMIN_NEWS_DELETE','ADMIN_NEWS_DELETE','OPERATION');
|
|
/*SECURITY_ROLE_ROOT*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','URL_ADMIN_NEWS_DELETE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ROOT','ADMIN_NEWS_DELETE');
|
|
/*SECURITY_ROLE_ADMIN*/
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','URL_ADMIN_NEWS_DELETE');
|
|
INSERT INTO `SCT_ROLE_RESOURCE` (`ROLE_UUID`,`RESOURCE_UUID`)
|
|
VALUES
|
|
('SECURITY_ROLE_ADMIN','ADMIN_NEWS_DELETE');
|
|
|
|
|
|
|