zhang_wei/bea-mid
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
Files
openapi_20190828
bea-mid/doc/init_bui.sql
T
xu_lw 9544f15249 增加文档
2019-08-28 16:30:32 +08:00

200 lines
34 KiB
SQL
Raw Permalink Blame History

truncate table T_BUI_CONFIG;
INSERT INTO T_BUI_CONFIG (ID, PARAM_KEY, PARAM_VALUE, STS, REMARK, REQ_ID, NOD_ID, TM_SMP, UPD_OPR) VALUES (725, 'aaadd', 'bb', ' ', 'dddd', 'buiConfigAddmbu007000000000001', 'mbu_region.mbu', '20190826165559', 'T00001');
INSERT INTO T_BUI_CONFIG (ID, PARAM_KEY, PARAM_VALUE, STS, REMARK, REQ_ID, NOD_ID, TM_SMP, UPD_OPR) VALUES (726, 'ad', 'fdd', '0', 'dddd', 'buiConfigAddmbu007000000000002', 'mbu_region.mbu', '20190826170336', 'T00001');
INSERT INTO T_BUI_CONFIG (ID, PARAM_KEY, PARAM_VALUE, STS, REMARK, REQ_ID, NOD_ID, TM_SMP, UPD_OPR) VALUES (727, 'dasdf', 'ddasdf', ' ', 'adfasdf', 'buiConfigAddmbu007000000000003', 'mbu_region.mbu', '20190826165711', 'T00001');
truncate table T_BUI_DCT;
INSERT INTO T_BUI_DCT (ID, DCT_NM, DCT_LEN, DCT_TYP, DCT_CNM, DCT_DECIMAL, DCT_SIGN, DCT_FORMAT, DCT_FUNC, DATA_TYP, DCT_MOD, DCT_DESC, REQ_ID, TM_SMP, NOD_ID, UPD_OPR, UPD_DESC) VALUES (519, 'normal_sts', 1, 'x', '状态', 0, ' ', ' ', ' ', ' ', ' ', '状态', 'buiDctAddmbu008000000000005', '20190826074455', 'mbu_region.mbu', ' ', ' ');
truncate table T_BUI_HLP;
INSERT INTO T_BUI_HLP (ID, FLD_ORDER, FLD_NM, FLD_VAL, FLD_EXP, FLD_TYP, FLD_EXP_DESC, TM_SMP, REQ_ID, NOD_ID, UPD_OPR, UPD_DESC) VALUES (521, 99, 'normal_sts', '有效', '0', ' ', ' ', '20190826074455', 'buiDctAddmbu008000000000005', 'mbu_region.mbu', ' ', ' ');
INSERT INTO T_BUI_HLP (ID, FLD_ORDER, FLD_NM, FLD_VAL, FLD_EXP, FLD_TYP, FLD_EXP_DESC, TM_SMP, REQ_ID, NOD_ID, UPD_OPR, UPD_DESC) VALUES (522, 99, 'normal_sts', '无效', '1', ' ', ' ', '20190826074455', 'buiDctAddmbu008000000000005', 'mbu_region.mbu', ' ', ' ');
truncate table T_BUI_MENU;
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (856, 5, '测试1', 'pub/test', ' ', '1', 'pinglun', 0, 'mbu_region.mbu', '20190824001854', 'T00001', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (88, 1, '测试管理', 'pub/test2', ' ', '2', 'shanchu', 0, 'mbu_region.mbu', '20190826153847', 'T00001', '7', 'buiMenumbu065000000000004');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (1, 0, '系统管理', ' ', ' ', '0', 'system', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (2, 1, '操作员管理', 'pub/user', ' ', '1', 'admin', 1, 'mbu_region.mbu', '20190826163258', 'T00001', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (3, 1, '角色管理', 'pub/role', ' ', '1', 'role', 2, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (4, 1, '菜单管理', 'pub/menu', ' ', '1', 'menu', 3, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (5, 1, 'SQL监控', 'http://localhost:8480/cladm/druid/sql.html', ' ', '1', 'sql', 4, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (6, 1, '定时任务', 'job/schedule', ' ', '1', 'job', 5, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (7, 6, '查看', ' ', 'sys:schedule:list,sys:schedule:info', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (8, 6, '新增', ' ', 'sys:schedule:save', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (9, 6, '修改', ' ', 'sys:schedule:update', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (10, 6, '删除', ' ', 'sys:schedule:delete', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (11, 6, '暂停', ' ', 'sys:schedule:pause', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (12, 6, '恢复', ' ', 'sys:schedule:resume', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (13, 6, '立即执行', ' ', 'sys:schedule:run', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (14, 6, '日志列表', ' ', 'sys:schedule:log', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (15, 2, '查看', ' ', 'sys:user:list,sys:user:info', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (16, 2, '新增', ' ', 'sys:user:save,sys:role:select', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (17, 2, '修改', ' ', 'sys:user:update,sys:role:select', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (18, 2, '删除', ' ', 'sys:user:delete', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (19, 3, '查看', ' ', 'sys:role:list,sys:role:info', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (20, 3, '新增', ' ', 'sys:role:save,sys:menu:list', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (21, 3, '修改', ' ', 'sys:role:update,sys:menu:list', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (22, 3, '删除', ' ', 'sys:role:delete', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (23, 4, '查看', ' ', 'sys:menu:list,sys:menu:info', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (24, 4, '新增', ' ', 'sys:menu:save,sys:menu:select', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (25, 4, '修改', ' ', 'sys:menu:update,sys:menu:select', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (26, 4, '删除', ' ', 'sys:menu:delete', '2', ' ', 0, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (29, 1, '系统日志', 'pub/log', 'sys:log:list', '1', 'log', 7, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', '1', 'oss', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (43, 1, '序列表', 'pub/mngsequence', ' ', '1', 'config', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (44, 43, '查看', ' ', 'bui:mngsequence:list,bui:mngsequence:info', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (45, 43, '新增', ' ', 'bui:mngsequence:save', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (46, 43, '修改', ' ', 'bui:mngsequence:update', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (47, 43, '删除', ' ', 'bui:mngsequence:delete', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (50, 1, '参数配置', 'pub/buiconfig', ' ', '1', 'config', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (51, 50, '查看', ' ', 'bui:buiconfig:list,bui:buiconfig:info', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (52, 50, '新增', ' ', 'bui:buiconfig:save', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (53, 50, '修改', ' ', 'bui:buiconfig:update', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (54, 50, '删除', ' ', 'bui:buiconfig:delete', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (56, 1, '字典表', 'pub/buidct', ' ', '1', 'config', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (57, 56, '查看', ' ', 'bui:buidct:list,bui:buidct:info', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (58, 56, '新增', ' ', 'bui:buidct:save', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (59, 56, '修改', ' ', 'bui:buidct:update', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (60, 56, '删除', ' ', 'bui:buidct:delete', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (61, 1, '字典枚举值', 'pub/buihlp', ' ', '1', 'config', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (62, 61, '查看', ' ', 'bui:buihlp:list,bui:buihlp:info', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (63, 61, '新增', ' ', 'bui:buihlp:save', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (64, 61, '修改', ' ', 'bui:buihlp:update', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (65, 61, '删除', ' ', 'bui:buihlp:delete', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (66, 1, '机构信息表', 'pub/buiorg', ' ', '1', 'config', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (67, 66, '查看', ' ', 'pub:buiorg:list,pub:buiorg:info', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (68, 66, '新增', ' ', 'pub:buiorg:save', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (69, 66, '修改', ' ', 'pub:buiorg:update', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
INSERT INTO T_BUI_MENU (MENU_ID, PARENT_ID, NAME, URL, PERMS, TYPE, ICON, ORDER_NUM, NOD_ID, TM_SMP, UPD_OPR, ORG_ID, REQ_ID) VALUES (70, 66, '删除', ' ', 'pub:buiorg:delete', '2', ' ', 6, ' ', ' ', ' ', '7', ' ');
truncate table T_BUI_OPER;
INSERT INTO T_BUI_OPER (OPER_ID, OPER_NO, OPER_NM, OPER_PWD, OPER_EMAIL, OPER_TYP, AUTH_LVL, MBL_NO, TEL_NO, PWD_EXP_PERIOD, PWD_UPD_DT, VAL_DT, EXP_DT, STS, LOGIN_TM, LAST_LOG_TM, LOGIN_TMS, LOG_MOD, USB_KEY_ID, PSW_FAIL_CNT, IMG_PATH, PWD_SALT, ORG_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (1, 'T00001', 'admin', '3c26b1141066531d856b6cd126d0834da814701c4ff8ec97f9b398bc32d6549f', 'fas@qq.com', '1', '1', '13162789531', '13162789531', '0821112700', '20190526', '20190506', '99991231', '0', ' ', ' ', 0, ' ', ' ', 0, ' ', '13695', 7, 'mbu_region.mbu', '20190825170310', ' ', 'gw.gw01');
INSERT INTO T_BUI_OPER (OPER_ID, OPER_NO, OPER_NM, OPER_PWD, OPER_EMAIL, OPER_TYP, AUTH_LVL, MBL_NO, TEL_NO, PWD_EXP_PERIOD, PWD_UPD_DT, VAL_DT, EXP_DT, STS, LOGIN_TM, LAST_LOG_TM, LOGIN_TMS, LOG_MOD, USB_KEY_ID, PSW_FAIL_CNT, IMG_PATH, PWD_SALT, ORG_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (6, 'T00002', 'jecker1', '903bf1d9071acdf529c42a7887dc3b76078133aa2e396d59e597f1093b7222a9', 'fas@qq.com', '1', '1', '13162789531', '13162789531', '0821112700', '20190506', '20190506', '99991231', '0', ' ', ' ', 0, ' ', ' ', 0, ' ', '13695', 8, 'mbu_region.mbu', '20190824233904', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER (OPER_ID, OPER_NO, OPER_NM, OPER_PWD, OPER_EMAIL, OPER_TYP, AUTH_LVL, MBL_NO, TEL_NO, PWD_EXP_PERIOD, PWD_UPD_DT, VAL_DT, EXP_DT, STS, LOGIN_TM, LAST_LOG_TM, LOGIN_TMS, LOG_MOD, USB_KEY_ID, PSW_FAIL_CNT, IMG_PATH, PWD_SALT, ORG_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (101, 'T00003', 'Test user2', 'ee5704618496f7e8d67e8563e9789de3cb33837c97ce6c1fb589037f447132c3', 'fadf@qq.com', '1', '1', '13162789531', '13162789531', '0820070703', '20190507', '20190507', '99991231', '0', ' ', ' ', 0, ' ', ' ', 0, ' ', '98689', 8, 'gw.gw01', '20190511205733', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER (OPER_ID, OPER_NO, OPER_NM, OPER_PWD, OPER_EMAIL, OPER_TYP, AUTH_LVL, MBL_NO, TEL_NO, PWD_EXP_PERIOD, PWD_UPD_DT, VAL_DT, EXP_DT, STS, LOGIN_TM, LAST_LOG_TM, LOGIN_TMS, LOG_MOD, USB_KEY_ID, PSW_FAIL_CNT, IMG_PATH, PWD_SALT, ORG_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (103, 'T00005', 'piter', 'b2935c6686f487cdcec992bc28c3b9d005b604f594af92ba0ddb7f7229f61c39', '993929808@qq.com', '1', '1', '13162789531', '13162789531', '0820103446', '20190507', '20190507', '99991231', '0', ' ', ' ', 0, ' ', ' ', 0, ' ', '18928', 8, 'mbu_region.mbu', '20190825194134', '1', 'gw.gw01');
truncate table T_BUI_OPER_ROLE;
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (90, 1, 1, '0', 'mbu_region.mbu', '20190825170310', ' ', 'buiOpermbu066000000000006');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (91, 603, 1, '0', 'mbu_region.mbu', '20190825170310', ' ', 'buiOpermbu066000000000006');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (49, 603, 101, '0', 'gw.gw01', '20190511205734', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (58, 601, 6, '0', 'gw.gw01', '20190512015804', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (59, 2, 1101, '0', 'gw.gw01', '20190513143647', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (60, 3, 1101, '0', 'gw.gw01', '20190513143647', '1', 'gw.gw01');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (40, 1, 37, '0', 'mbu_region.mbu', '20190825152835', ' ', 'buiOpermbu056000000000007');
INSERT INTO T_BUI_OPER_ROLE (ID, ROLE_ID, OPER_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (452, 1, 103, '0', 'mbu_region.mbu', '20190825194134', ' ', 'buiOperUpdatembu084000000000001');
truncate table T_BUI_ORG;
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (3, '1', '交通银行', '0', '0', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (4, '2', '东亚银行', '0', '0', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (5, '3', '南京分行', '1', '1', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (6, '4', '营业部14', '0', '3', '3333', '20190517223211', 'T00001', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (7, '5', '夫子庙支行1', '0', '3', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (8, '6', '夫子庙支行2', '0', '3', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (9, '7', '上海分行', '0', '1', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (10, '8', '宜山路支行1', '0', '7', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (11, '9', '宜山路支行1', '0', '7', ' ', ' ', ' ', ' ', ' ');
INSERT INTO T_BUI_ORG (ID, ORG_NO, ORG_NM, ORG_STS, SUP_ORG_NO, REMARK, TM_SMP, UPD_OPR, REQ_ID, NOD_ID) VALUES (12, '10', '宜山路支行1', '0', '2', ' ', ' ', ' ', ' ', ' ');
truncate table T_BUI_ROLE;
INSERT INTO T_BUI_ROLE (ID, NAME, REMARK, ORG_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (1, 'admin01', '管理员', 0, '0', 'mbu_region.mbu', '20190826080045', 'T00001', ' ');
INSERT INTO T_BUI_ROLE (ID, NAME, REMARK, ORG_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (603, 'role01', 'role04', 0, '0', 'mbu_region.mbu', '20190826153633', 'T00001', 'gw.gw01');
INSERT INTO T_BUI_ROLE (ID, NAME, REMARK, ORG_ID, STS, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (53, '角色6', '角色6', 7, '0', 'mbu_region.mbu', '20190825153832', 'T00001', 'buiRolembu059000000000002');
truncate table T_BUI_ROLE_MENU;
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (26, 20, 2, 'mbu_region.mbu', '20190825150307', 'T00001', 'buiRolembu050000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (27, 20, 15, 'mbu_region.mbu', '20190825150307', 'T00001', 'buiRolembu050000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (28, 20, 16, 'mbu_region.mbu', '20190825150307', 'T00001', 'buiRolembu050000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (29, 20, 17, 'mbu_region.mbu', '20190825150307', 'T00001', 'buiRolembu050000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (30, 20, 18, 'mbu_region.mbu', '20190825150308', 'T00001', 'buiRolembu050000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (559, 1, 2, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (560, 1, 15, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (561, 1, 16, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (562, 1, 17, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (563, 1, 18, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (564, 1, 3, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (565, 1, 19, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (566, 1, 20, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (567, 1, 21, 'mbu_region.mbu', '20190826080045', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (568, 1, 22, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (569, 1, 4, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (570, 1, 23, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (571, 1, 24, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (572, 1, 25, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (573, 1, 26, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (574, 1, 29, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (575, 1, 50, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (576, 1, 51, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (577, 1, 52, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (578, 1, 53, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (579, 1, 54, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (580, 1, 56, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (581, 1, 57, 'mbu_region.mbu', '20190826080046', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (582, 1, 58, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (583, 1, 59, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (584, 1, 60, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (585, 1, 66, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (586, 1, 67, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (587, 1, 68, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (588, 1, 69, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (589, 1, 70, 'mbu_region.mbu', '20190826080047', 'T00001', 'buiRoleUpdatembu012000000000001');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (99, 501, 4, 'gw.gw01', '20190509200342', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (100, 501, 23, 'gw.gw01', '20190509200343', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (101, 501, 24, 'gw.gw01', '20190509200343', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (102, 501, 25, 'gw.gw01', '20190509200343', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (103, 501, 26, 'gw.gw01', '20190509200343', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (129, 3, 2, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (130, 3, 15, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (131, 3, 16, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (132, 3, 17, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (133, 3, 18, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (134, 3, 3, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (135, 3, 19, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (136, 3, 20, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (137, 3, 21, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (138, 3, 22, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (139, 3, 6, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (140, 3, 7, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (141, 3, 8, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (142, 3, 9, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (143, 3, 10, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (144, 3, 11, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (145, 3, 12, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (146, 3, 13, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (147, 3, 14, 'gw.gw01', '20190509204009', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (148, 2, 2, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (149, 2, 15, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (150, 2, 16, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (151, 2, 17, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (152, 2, 18, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (153, 2, 20, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (154, 2, 21, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (155, 2, 22, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (156, 2, 8, 'gw.gw01', '20190509204027', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (163, 601, 2, 'gw.gw01', '20190510102420', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (164, 601, 15, 'gw.gw01', '20190510102420', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (165, 601, 16, 'gw.gw01', '20190510102420', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (166, 601, 17, 'gw.gw01', '20190510102420', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (167, 601, 18, 'gw.gw01', '20190510102420', ' ', 'gw.gw01');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (607, 603, 2, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (608, 603, 15, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (609, 603, 16, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (610, 603, 17, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (611, 603, 18, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (612, 603, 19, 'mbu_region.mbu', '20190826153634', 'T00001', 'buiRoleUpdatembu012000000000003');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (54, 53, 3, 'mbu_region.mbu', '20190825153832', 'T00001', 'buiRolembu059000000000002');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (55, 53, 19, 'mbu_region.mbu', '20190825153832', 'T00001', 'buiRolembu059000000000002');
INSERT INTO T_BUI_ROLE_MENU (ID, ROLE_ID, MENU_ID, NOD_ID, TM_SMP, UPD_OPR, REQ_ID) VALUES (56, 53, 20, 'mbu_region.mbu', '20190825153832', 'T00001', 'buiRolembu059000000000002');
Reference in New Issue View Git Blame Copy Permalink