| Tang Cheng | 9a25e64 | 2019-04-19 16:32:50 +0800 | [diff] [blame] | 1 | insert into tb_apiclient(appid, secret, status, roles) |
| 2 | values ('100001', 'oUw2NmA09ficiVWD4TUQLDOkPyzQa3VzbjjsW0B2qTk=', 'normal', 'ROLE_THIRD_ADMIN'); |
| Tang Cheng | d869c93 | 2019-04-22 15:56:13 +0800 | [diff] [blame] | 3 | INSERT INTO tb_operator( |
| 4 | operid, closedate, opendate, opercode, opername, operpwd, opertype, status) |
| 5 | VALUES ('LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', '20500101', '20190101', 'system', '系统管理员', '$2a$10$Ex9xp11.vCaD8D0a7ahiUOKqDij1TcCUBwRAmrqXeDvAkmzLibn4.', '', 'normal'); |
| 6 | |
| 7 | INSERT INTO tb_role( |
| 8 | role_id, createtime, editflag, lastsaved, role_code, role_desc, role_name) |
| 9 | VALUES ('d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', '20190101000000', 0, '', 'ROLE_ADMIN', '超级管理员', '超级管理员'); |
| 10 | |
| 11 | INSERT INTO tb_oper_role( |
| 12 | id, operid, role_id) |
| 13 | VALUES ('1', 'LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); |
| Tang Cheng | 628f716 | 2019-04-16 22:59:02 +0800 | [diff] [blame] | 14 | |
| Xia Kaixiang | 6b19e30 | 2019-04-22 17:40:36 +0800 | [diff] [blame^] | 15 | -- 功能表 |
| 16 | Insert into TB_FUNCTION (ID,PARENT_ID,NAME,ORDER_NUM,MENU_URL,MENU_ICON,IS_LEAF) |
| 17 | values ('1','-1','系统中心',1,'#','layui-icon-set',0); |
| 18 | Insert into TB_FUNCTION (ID,PARENT_ID,NAME,ORDER_NUM,MENU_URL,MENU_ICON,IS_LEAF) |
| 19 | values ('2','1','管理员维护',1,'#','layui-icon-set',1); |
| 20 | |
| 21 | Insert into TB_ROLE_FUNCTION (ID,FUNCTION_ID,ROLE_ID) values ('1','1','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); |
| 22 | Insert into TB_ROLE_FUNCTION (ID,FUNCTION_ID,ROLE_ID) values ('2','2','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); |
| 23 | |
| Tang Cheng | 628f716 | 2019-04-16 22:59:02 +0800 | [diff] [blame] | 24 | commit; |