-
Notifications
You must be signed in to change notification settings - Fork 1
/
2_user_info_data_init.sql
74 lines (72 loc) · 15.3 KB
/
2_user_info_data_init.sql
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
BEGIN;
--t_users | pwd:dapeng
INSERT INTO `t_users` VALUES ('1', 'admin', '210ed3cf9a0ea07ae04e781fe424c087', '0', '', '', '', '');
--t_role
INSERT INTO `t_role` VALUES ('1', 'ADMIN', '超级管理员'), ('2', 'OPS', '运维人员'), ('3', 'DEV', '开发人员'), ('4', 'NORMAL', '普通账户');
--t_role_user
INSERT INTO `t_role_user` VALUES ('1', '1', '1'), ('2', '2', '1'), ('3', '3', '1'), ('4', '4', '1');
--t_permissions
INSERT INTO `t_permissions` VALUES ('10000', '主页', '100', '0', '0', '用户主页', '2018-11-13 16:18:41', '2018-11-13 18:09:36', '1', '1', '/me');
--t_role_permission
INSERT INTO `t_role_permission` VALUES ('10000', '1', '10000', '管理员主页关联', '2018-11-13 16:20:55', '2018-11-13 16:20:55', '1', '1');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2306', '1', '配置管理', NULL, '/config', 'menu', '2019-01-23 10:51:57', '2019-01-25 11:28:36', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2307', '1', '持续集成', NULL, '/build', 'menu', '2019-01-23 10:52:40', '2019-01-25 11:28:46', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2308', '0', '发布部署', NULL, '/deploy', 'menu', '2019-01-23 10:53:05', '2019-01-25 11:29:13', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2310', '1', '集群管理', '2306', '/config/clusters', 'page', '2019-01-23 14:59:02', '2019-01-25 11:28:20', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2311', '1', '添加集群', '2310', '/api/cluster/add', '', '2019-01-23 15:00:33', '2019-01-23 15:33:53', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2312', '1', '服务配置', '2306', '/config/service', 'page', '2019-01-23 15:04:02', '2019-01-25 11:27:49', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2313', '1', '白名单', '2306', '/config/whitelist', 'page', '2019-01-23 16:15:24', '2019-01-25 11:27:44', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2314', '1', 'apikey', '2306', '/config/apikey', 'page', '2019-01-23 16:16:06', '2019-01-25 11:27:37', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2315', '1', '构建任务', '2307', '/build/exec', 'page', '2019-01-25 11:27:28', '2019-01-25 11:27:28', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2316', '1', '文件管理', '2308', '/deploy/files', 'page', '2019-01-25 11:30:06', '2019-01-25 11:30:06', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2317', '1', '网络管理', '2308', '/deploy/network', 'page', '2019-01-25 11:30:42', '2019-01-25 11:30:42', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2318', '1', '服务管理', '2308', '/deploy/service', 'page', '2019-01-25 11:31:11', '2019-01-25 11:31:11', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2319', '1', '环境管理', '2308', '/deploy/set', 'page', '2019-01-25 11:32:31', '2019-01-25 11:32:31', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2320', '1', '节点管理', '2308', '/deploy/host', 'page', '2019-01-25 11:33:02', '2019-01-25 11:33:02', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2321', '1', '部署单元', '2308', '/deploy/unit', 'page', '2019-01-25 11:33:36', '2019-01-25 11:33:36', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2322', '1', '上线部署', '2308', '/deploy/exec', 'page', '2019-01-25 11:34:25', '2019-01-25 11:34:25', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2323', '1', '部署记录', '2308', '/deploy/journal', 'page', '2019-01-25 11:34:52', '2019-01-25 11:34:52', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2324', '1', '容器终端', '2322', '/container/terminal', 'page', '2019-01-25 11:39:46', '2019-01-25 11:39:46', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2325', '1', '路由生成', '2306', '/config/route', '路由生成', '2019-03-28 14:56:50', '2019-03-28 06:56:49', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2326', '1', '系统管理', NULL, '/system', '系统管理', '2019-03-28 15:19:02', '2019-03-28 07:19:02', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2327', '1', '菜单管理', '2326', '/system/menus', '菜单管理', '2019-03-28 15:19:34', '2019-03-28 07:19:50', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2328', '1', '账号管理', '2326', '/system/account', '账号管理', '2019-03-28 17:09:30', '2019-03-28 09:10:15', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2339', '1', '操作日志', '2326', '/system/log', '操作日志', '2019-03-28 15:20:31', '2019-03-28 09:10:19', '0', '0');
INSERT INTO `config_server_db`.`t_menu` (`id`, `status`, `name`, `parent_id`, `url`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('2340', '1', '服务实例', '2306', '/config/runtime', '服务实例', '2019-05-13 13:12:43', '2019-05-13 13:12:43', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('100', '5', '2325', '', '2019-04-24 09:41:51', '2019-04-24 09:41:49', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('101', '3', '2307', '', '2019-04-24 09:42:23', '2019-04-24 09:42:20', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('102', '5', '2307', '', '2019-04-24 09:42:24', '2019-04-24 09:42:22', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('103', '3', '2315', '', '2019-04-24 09:42:29', '2019-04-24 09:42:26', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('104', '5', '2315', '', '2019-04-24 09:42:30', '2019-04-24 09:42:28', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('105', '2', '2308', '', '2019-04-24 09:42:49', '2019-04-24 09:42:46', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('106', '2', '2316', '', '2019-04-24 09:42:52', '2019-04-24 09:42:50', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('107', '2', '2317', '', '2019-04-24 09:42:55', '2019-04-24 09:42:52', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('108', '2', '2318', '', '2019-04-24 09:42:58', '2019-04-24 09:42:56', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('109', '5', '2319', '', '2019-04-24 09:43:05', '2019-04-24 09:43:03', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('110', '2', '2320', '', '2019-04-24 09:43:09', '2019-04-24 09:43:06', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('111', '5', '2320', '', '2019-04-24 09:43:10', '2019-04-24 09:43:08', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('112', '2', '2321', '', '2019-04-24 09:43:21', '2019-04-24 09:43:19', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('113', '5', '2321', '', '2019-04-24 09:43:23', '2019-04-24 09:43:21', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('114', '2', '2322', '', '2019-04-24 09:43:26', '2019-04-24 09:43:24', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('115', '5', '2322', '', '2019-04-24 09:43:30', '2019-04-24 09:43:28', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('116', '2', '2323', '', '2019-04-24 09:43:33', '2019-04-24 09:43:31', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('117', '5', '2323', '', '2019-04-24 09:43:34', '2019-04-24 09:43:32', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('118', '2', '2339', '', '2019-04-24 09:43:39', '2019-04-24 09:43:37', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('119', '4', '2339', '', '2019-04-24 09:43:40', '2019-04-24 09:43:38', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('120', '5', '2339', '', '2019-04-24 09:43:40', '2019-04-24 09:43:38', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('121', '5', '2306', '', '2019-04-24 09:43:44', '2019-04-24 09:43:42', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('123', '5', '2311', '', '2019-04-24 09:43:50', '2019-04-24 09:43:47', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('127', '5', '2308', '', '2019-04-24 09:44:16', '2019-04-24 09:44:14', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('128', '5', '2316', '', '2019-04-24 09:44:19', '2019-04-24 09:44:17', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('129', '5', '2317', '', '2019-04-24 09:44:21', '2019-04-24 09:44:18', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('130', '5', '2318', '', '2019-04-24 09:44:25', '2019-04-24 09:44:22', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('135', '2', '2326', '', '2019-04-24 09:44:45', '2019-04-24 09:44:43', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('136', '5', '2326', '', '2019-04-24 09:44:46', '2019-04-24 09:44:44', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('137', '3', '2326', '', '2019-04-24 09:44:49', '2019-04-24 09:44:47', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('138', '4', '2326', '', '2019-04-24 09:44:50', '2019-04-24 09:44:47', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('139', '2', '2324', '', '2019-04-26 13:27:32', '2019-04-26 13:27:32', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('140', '3', '2324', '', '2019-04-26 13:27:33', '2019-04-26 13:27:33', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('141', '2', '2340', '', '2019-05-13 13:12:53', '2019-05-13 13:12:53', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('142', '3', '2340', '', '2019-05-13 13:12:54', '2019-05-13 13:12:54', '0', '0');
INSERT INTO `config_server_db`.`t_role_menu` (`id`, `role_id`, `menu_id`, `remark`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES ('143', '5', '2340', '', '2019-05-13 13:12:57', '2019-05-13 13:12:57', '0', '0');
COMMIT;