init.sql
4.02 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
##初始的角色
insert into bsth_c_sys_role(id, code_name, role_name, pic, enable, create_date, update_date, is_super_admin,descriptions)
values(1, 'ROLE_ADMIN', '管理员', 1, 1, now(), now(), 0, '');
##默认的模块
insert into bsth_c_sys_module(id,p_id, name, group_type, enable, path, create_date, update_date, mapp_symbol)
values (1,null , '系统管理', 1, 1, null, now(), now(), null)
,(2, 1, '权限管理', 2, 1, null, now(), now(), null)
,(3, 2, '资源管理', 3, 1, 'permission/resource/list.html', now(), now(), '/resource')
,(4, 2, '模块管理', 3, 1, 'permission/module/list.html', now(), now(), '/module')
,(5, 2, '角色管理', 3, 1, 'permission/role/list.html', now(), now(), '/role')
,(6, 2, '用户管理', 3, 1, 'permission/user/list.html', now(), now(), '/user')
,(7, 2, '字典管理', 3, 1, 'permission/dictionary/list.html', now(), now(), '/dictionary');
##管理员角色和模块关联
insert into bsth_c_sys_role_modules(roles, modules)
values (1, 3)
,(1, 4)
,(1, 5)
,(1, 6)
,(1, 7);
##管理员用户 admin/admin
insert into bsth_c_sys_user(id, name, user_name, password, create_date, enabled)
values(1, '系统管理员', 'admin', '$2a$04$4C6Xdjbfsqrbn3oFvmUl3eOm4.31FmzV3gEhzMIJuM7Gni4DQ8xQe', now(), 1);
insert into bsth_c_sys_user_roles(users, roles)
values(1, 1);
##字典
INSERT INTO `bsth_c_sys_dictionary` VALUES (12, 'XianLuXingZhi', '0', '线路性质', '', '\0', '2016-4-11 12:07:58');
INSERT INTO `bsth_c_sys_dictionary` VALUES (13, 'GJXL', 'XianLuXingZhi', '过江线路', '', '\0', '2016-4-11 12:08:08');
INSERT INTO `bsth_c_sys_dictionary` VALUES (14, 'CCTXL', 'XianLuXingZhi', '村村通线路', '', '\0', '2016-4-11 12:08:19');
INSERT INTO `bsth_c_sys_dictionary` VALUES (15, 'YXXL', 'XianLuXingZhi', '夜宵线路', '', '\0', '2016-4-11 12:08:30');
INSERT INTO `bsth_c_sys_dictionary` VALUES (16, 'CSBS', 'XianLuXingZhi', '穿梭巴士', '', '\0', '2016-4-11 13:06:02');
INSERT INTO `bsth_c_sys_dictionary` VALUES (17, 'ShangXiaXingDingYi', '0', '上下行定义', '', '\0', '2016-4-11 13:07:00');
INSERT INTO `bsth_c_sys_dictionary` VALUES (18, 'SH1', 'ShangXiaXingDingYi', '上行1', '', '\0', '2016-4-11 13:14:42');
INSERT INTO `bsth_c_sys_dictionary` VALUES (20, 'XH', 'ShangXiaXingDingYi', '下行', '', '\0', '2016-4-11 13:15:12');
INSERT INTO `bsth_c_sys_dictionary` VALUES (21, 'HH', 'ShangXiaXingDingYi', '环行', '', '\0', '2016-4-11 13:15:22');
INSERT INTO `bsth_c_sys_dictionary` VALUES (22, 'FaCheBanCi', '0', '发车班次', '', '\0', '2016-4-11 13:16:54');
INSERT INTO `bsth_c_sys_dictionary` VALUES (23, 'ZCBC', 'FaCheBanCi', '正常班次', '', '\0', '2016-4-11 13:17:07');
INSERT INTO `bsth_c_sys_dictionary` VALUES (24, 'CC1', 'FaCheBanCi', '出场1', '', '\0', '2016-4-11 13:17:18');
INSERT INTO `bsth_c_sys_dictionary` VALUES (25, 'JC', 'FaCheBanCi', '进场', '', '\0', '2016-4-11 13:17:35');
INSERT INTO `bsth_c_sys_dictionary` VALUES (26, 'JY', 'FaCheBanCi', '加油', '', '\0', '2016-4-11 13:17:40');
INSERT INTO `bsth_c_sys_dictionary` VALUES (27, 'TPBC', 'FaCheBanCi', '套跑班次', '', '\0', '2016-4-11 13:17:44');
INSERT INTO `bsth_c_sys_dictionary` VALUES (28, 'LJBC', 'FaCheBanCi', '临加班次', '', '\0', '2016-4-11 13:17:49');
INSERT INTO `bsth_c_sys_dictionary` VALUES (29, 'QJBC', 'FaCheBanCi', '区间班次', '', '\0', '2016-4-11 13:17:54');
INSERT INTO `bsth_c_sys_dictionary` VALUES (30, 'FKBC', 'FaCheBanCi', '放空班次', '', '\0', '2016-4-11 13:17:58');
INSERT INTO `bsth_c_sys_dictionary` VALUES (31, 'FDZBC', 'FaCheBanCi', '放大站班次', '', '\0', '2016-4-11 13:18:01');
INSERT INTO `bsth_c_sys_dictionary` VALUES (32, 'LDJKS', 'FaCheBanCi', '两点间空驶', '', '\0', '2016-4-11 13:18:05');
INSERT INTO `bsth_c_sys_dictionary` VALUES (33, 'XianLuLeiXing', '0', '线路类型', '', '\0', '2016-4-11 13:21:50');
INSERT INTO `bsth_c_sys_dictionary` VALUES (34, 'CGXL', 'XianLuLeiXing', '常规线路', '', '\0', '2016-4-11 13:22:08');
INSERT INTO `bsth_c_sys_dictionary` VALUES (35, 'ZX', 'XianLuLeiXing', '专线', '', '\0', '2016-4-11 13:22:14');