4dkankan-center-manage/doc/update-1.5.0.sql

use 4dkankan_v4;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
                             `id` int NOT NULL AUTO_INCREMENT COMMENT '系统菜单表',
                             `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单名称',
                             `perms` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限表达式',
                             `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单路由',
                             `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标',
                             `parent_id` int NULL DEFAULT NULL COMMENT '父id',
                             `type` int NULL DEFAULT NULL COMMENT '类型0菜单，1按钮',
                             `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A',
                             `sort` int NULL DEFAULT 1 COMMENT '排序字段',
                             `is_show` int NULL DEFAULT 1 COMMENT '是否显示 0 不显示，1显示',
                             `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                             `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                             `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
                             `hide_menu` int NULL DEFAULT 0,
                             `is_ext` int NULL DEFAULT 0,
                             `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 289 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, '系统管理', NULL, NULL, 'carbon:ibm-cloud-pak-system', NULL, 0, 'A', 99, 1, '2022-06-14 10:08:22', '2022-11-29 17:23:23', '/system/user', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (2, '角色管理', 'role-list', NULL, 'carbon:user-role', 1, 0, 'A', 1, 1, '2022-06-14 10:08:38', '2022-06-14 10:10:54', '/system/role', 0, 0, 'system/role/index');
INSERT INTO `sys_menu` VALUES (3, '新增角色', 'role-add', NULL, NULL, 2, 2, 'A', 1, 1, '2022-06-14 10:21:37', '2022-06-14 10:29:39', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (4, '修改角色', 'role-update', NULL, NULL, 2, 2, 'A', 1, 1, '2022-06-14 10:23:43', '2022-06-14 10:29:41', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (5, '删除角色', 'role-delete', NULL, NULL, 2, 2, 'A', 1, 1, '2022-06-14 10:29:19', '2022-06-14 10:29:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (6, '分配权限', 'role-giveMenu', NULL, NULL, 2, 2, 'A', 1, 1, '2022-06-14 15:16:55', '2022-06-14 20:29:09', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (7, '账号管理', 'sysuser-list', NULL, 'bxs:user-detail', 1, 1, 'A', 1, 1, '2022-06-10 16:37:26', '2022-10-14 17:33:00', '/system/user', 0, 0, 'staff/list');
INSERT INTO `sys_menu` VALUES (8, '新增账号', 'sysuser-add', NULL, NULL, 7, 2, 'A', 1, 1, '2022-06-10 16:39:25', '2022-06-10 16:39:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (9, '修改账号', 'sysuser-update', NULL, NULL, 7, 2, 'A', 1, 1, '2022-06-10 16:39:25', '2022-06-10 16:39:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (10, '重置账号', 'sysuser-repassword', NULL, NULL, 7, 2, 'A', 1, 1, '2022-06-13 17:05:16', '2022-06-13 17:06:03', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (11, '删除账号', 'sysuser-delete', NULL, NULL, 7, 2, 'A', 1, 1, '2022-06-13 17:06:07', '2022-06-13 17:06:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (12, '菜单管理', 'menu-list', NULL, 'ep:menu', 1, 0, 'A', 1, 1, '2022-06-14 15:22:47', '2022-06-14 20:29:09', '/system/menu', 0, 0, 'system/menu/index');
INSERT INTO `sys_menu` VALUES (13, '新增菜单', 'menu-add', NULL, NULL, 12, 2, 'A', 1, 1, '2022-06-14 15:23:40', '2022-06-14 20:29:09', '', 0, 0, '');
INSERT INTO `sys_menu` VALUES (14, '修改菜单', 'menu-update', NULL, NULL, 12, 2, 'A', 1, 1, '2022-06-14 15:23:41', '2022-06-14 20:29:09', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (15, '删除菜单', 'menu-delete', NULL, NULL, 12, 2, 'A', 1, 1, '2022-06-14 15:23:42', '2022-06-14 20:29:09', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (16, '官网运营管理', NULL, NULL, 'carbon:ibm-cloud-pak-business-automation', NULL, 0, 'A', 89, 1, '2022-09-27 15:54:55', '2022-09-28 20:45:22', '/operate/news', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (17, '用户管理', NULL, NULL, 'bxs:user-detail', NULL, 1, 'A', 96, 1, '2022-09-27 15:56:31', '2023-04-14 02:10:24', '/account/lists', 0, 0, '/lanUser/list');
INSERT INTO `sys_menu` VALUES (18, '客户管理', NULL, NULL, 'raphael:customer', NULL, 1, 'A', 95, 1, '2022-09-27 15:59:44', '2022-09-29 09:21:15', '/customer/index', 0, 0, 'customer/index');
INSERT INTO `sys_menu` VALUES (19, '首页', NULL, NULL, 'ant-design:home-filled', NULL, 1, 'A', 0, 1, '2022-09-27 16:00:41', '2023-04-14 02:18:37', '/statistics/scene', 0, 0, 'statistics/scene/index');
INSERT INTO `sys_menu` VALUES (20, '设备管理', NULL, NULL, 'codicon:device-camera', NULL, 1, 'A', 97, 1, '2022-09-27 16:01:31', '2022-11-29 17:25:07', '/device', 0, 0, 'device/index');
INSERT INTO `sys_menu` VALUES (21, '发票管理', NULL, NULL, 'uil:invoice', NULL, 1, 'A', 91, 1, '2022-09-27 16:08:31', '2022-09-28 20:45:07', '/invoice', 0, 0, 'invoice/index');
INSERT INTO `sys_menu` VALUES (22, '产品运营管理', NULL, NULL, 'carbon:carbon-for-ibm-product', NULL, 0, 'A', 94, 1, '2022-09-27 16:08:45', '2022-10-18 15:53:08', '/productOperation/news', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (23, '订单管理', NULL, NULL, 'carbon:ibm-watson-orders', NULL, 0, 'A', 90, 1, '2022-09-27 16:09:33', '2022-09-28 20:45:15', '/order/camera', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (24, '产品管理', NULL, NULL, 'fluent:production-20-filled', NULL, 0, 'A', 98, 1, '2022-09-27 16:10:14', '2022-11-29 17:25:15', '/product/app', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (79, '用户列表', 'user-list', NULL, '', 17, 1, 'A', 1, 1, '2022-09-27 16:10:46', '2022-10-27 12:18:32', '/account/lists', 0, 0, 'account/lists');
INSERT INTO `sys_menu` VALUES (80, '用户订单详情', NULL, NULL, NULL, 17, 1, 'A', 1, 1, '2022-09-27 16:15:32', '2022-11-02 15:41:08', '/account/details', 1, 0, 'account/details/index');
INSERT INTO `sys_menu` VALUES (81, '客户列表', 'customer-list', NULL, 'ri:customer-service-2-line', 202, 2, 'A', 0, 1, '2022-09-27 16:16:38', '2022-11-16 11:08:05', '/customer/index', 0, 0, 'customer/index');
INSERT INTO `sys_menu` VALUES (82, '客户设备', 'customer-device', NULL, 'codicon:device-camera-video', 202, 2, 'A', 2, 1, '2022-09-27 16:16:44', '2022-11-16 11:08:28', '/customer/device/:id', 0, 0, 'customer/device');
INSERT INTO `sys_menu` VALUES (83, '客户场景', 'customer-scenes', NULL, 'uil:scenery', 202, 2, 'A', 3, 1, '2022-09-27 16:19:18', '2022-11-16 11:08:45', '/customer/scene/:id', 0, 0, 'customer/scene');
INSERT INTO `sys_menu` VALUES (85, '新闻管理', NULL, NULL, 'fluent:news-16-regular', 16, 1, 'A', 1, 1, '2022-09-27 16:22:03', NULL, '/operate/news', 0, 0, 'operate/newsList');
INSERT INTO `sys_menu` VALUES (86, '招聘管理', NULL, NULL, 'carbon:ibm-cloud-pak-applications', 16, 1, 'A', 1, 1, '2022-09-27 16:22:24', NULL, '/operate/recruit', 0, 0, 'operate/recruitList');
INSERT INTO `sys_menu` VALUES (87, '留言管理', NULL, NULL, 'bx:message-detail', 16, 1, 'A', 1, 1, '2022-09-27 16:23:09', NULL, '/operate/message', 0, 0, 'operate/messageList');
INSERT INTO `sys_menu` VALUES (88, '相机订单', NULL, NULL, 'bi:camera-fill', 23, 1, 'A', 1, 1, '2022-09-27 16:24:20', NULL, '/order/camera', 0, 0, 'order/cameraList');
INSERT INTO `sys_menu` VALUES (89, '权益订单', NULL, NULL, 'fxemoji:notchedrightsemi3dot', 23, 1, 'A', 1, 1, '2022-09-27 16:25:21', NULL, '/order/equity', 0, 0, 'order/equityList');
INSERT INTO `sys_menu` VALUES (90, '下载订单', NULL, NULL, 'akar-icons:cloud-download', 23, 1, 'A', 1, 1, '2022-09-27 16:26:07', NULL, '/order/download', 0, 0, 'order/downloadList');
INSERT INTO `sys_menu` VALUES (91, '固件管理', NULL, NULL, 'ion:hardware-chip-outline', 24, 1, 'A', 1, 1, '2022-09-27 16:29:41', NULL, '/product/firmware', 0, 0, 'product/firmware/index');
INSERT INTO `sys_menu` VALUES (92, 'Space Target SDK', NULL, NULL, 'octicon:cpu-16', 24, 1, 'A', 1, 1, '2022-09-27 16:30:29', NULL, '/product/sdk', 0, 0, 'product/sdk/index');
INSERT INTO `sys_menu` VALUES (93, 'App管理', NULL, NULL, 'ant-design:android-filled', 24, 1, 'A', 1, 1, '2022-09-27 16:31:24', '2022-10-25 16:11:11', '/product/app', 0, 0, 'product/app/index');
INSERT INTO `sys_menu` VALUES (94, '相机场景管理', NULL, NULL, 'clarity:camera-line', 22, 1, 'A', 1, 1, '2022-09-27 16:32:26', NULL, '/productOperation/index', 0, 0, 'productOperation/cameraScene');
INSERT INTO `sys_menu` VALUES (95, '随心装方案管理', NULL, NULL, 'carbon:change-catalog', 22, 1, 'I', 1, 1, '2022-09-27 16:32:51', NULL, '/productOperation/sxz', 0, 0, 'productOperation/sxz');
INSERT INTO `sys_menu` VALUES (96, '全景作品管理', NULL, NULL, 'ant-design:border-outer-outlined', 22, 1, 'A', 1, 1, '2022-09-27 16:33:41', '2022-10-27 10:01:00', '/productOperation/viewKankan', 0, 0, 'productOperation/viewKankan');
INSERT INTO `sys_menu` VALUES (97, '经销商申请管理', '', NULL, 'ic:baseline-real-estate-agent', 16, 1, 'A', 0, 1, '2022-09-28 11:31:15', '2022-09-28 11:31:15', '/operate/agent', 0, 0, 'operate/agent');
INSERT INTO `sys_menu` VALUES (98, '深时场景申请管理', '', NULL, 'fluent:laser-tool-20-filled', 16, 1, 'A', 0, 1, '2022-09-28 11:33:10', '2022-09-28 11:33:10', '/operate/sceneList', 0, 0, 'operate/sceneList');
INSERT INTO `sys_menu` VALUES (99, '数据看板', NULL, NULL, 'academicons:open-data', NULL, 0, 'A', 87, 1, '2022-09-28 11:48:03', '2022-09-29 14:58:41', '/statistics', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (100, '场景数据统计', '', NULL, NULL, 99, 1, 'A', 1, 1, '2022-09-28 11:49:08', '2022-10-26 17:44:27', '/statistics/scene', 0, 0, 'statistics/scene/index');
INSERT INTO `sys_menu` VALUES (101, '注册用户统计', '', NULL, NULL, 99, 1, 'A', 0, 1, '2022-09-28 15:22:19', '2022-10-26 17:44:18', '/statistics/register', 0, 0, '/statistics/register/index');
INSERT INTO `sys_menu` VALUES (102, '订单数据统计', '', NULL, NULL, 99, 1, 'A', 3, 1, '2022-09-28 15:23:23', '2022-10-26 17:44:40', '/statistics/order', 0, 0, '/statistics/order/index');
INSERT INTO `sys_menu` VALUES (103, '相机出库统计', '', NULL, NULL, 99, 1, 'A', 2, 1, '2022-09-28 15:24:44', '2022-10-26 17:44:35', '/statistics/camera', 0, 0, '/statistics/camera/index');
INSERT INTO `sys_menu` VALUES (104, '埋点统计', NULL, NULL, 'icon-park-twotone:anchor', NULL, 0, 'A', 88, 1, '2022-09-28 15:39:14', '2022-09-29 14:58:47', '/anchor', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (105, '埋点应用管理', '', NULL, 'bx:anchor', 104, 1, 'A', 0, 1, '2022-09-28 15:40:03', '2022-09-28 15:40:29', '/anchor/list', 0, 0, '/anchor/index');
INSERT INTO `sys_menu` VALUES (106, '启用角色', 'role-enable', NULL, NULL, 2, 2, 'A', 0, 1, '2022-09-28 19:40:34', '2022-09-28 19:40:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (107, '角色列表', 'role-list', NULL, NULL, 2, 2, 'A', 0, 1, '2022-09-28 19:41:00', '2022-09-28 19:41:00', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (108, '启用账号', 'sysuser-enable', NULL, NULL, 7, 2, 'A', 0, 1, '2022-09-28 19:44:43', '2022-09-28 19:44:43', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (109, '账号列表', 'sysuser-list', NULL, NULL, 7, 2, 'A', 0, 1, '2022-09-28 19:45:25', '2022-09-28 19:45:25', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (110, '新增固件', 'firmware-add', NULL, NULL, 91, 2, 'A', 0, 1, '2022-09-28 19:50:23', '2022-09-28 19:50:23', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (111, '编辑固件', 'firmware-update', NULL, NULL, 91, 2, 'A', 0, 1, '2022-09-28 19:50:57', '2022-10-18 10:35:10', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (112, '删除固件', 'firmware-delete', NULL, NULL, 91, 2, 'A', 0, 1, '2022-09-28 19:51:42', '2022-09-28 19:51:42', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (113, '启用固件', 'firmware-enable', NULL, NULL, 91, 2, 'A', 0, 1, '2022-09-28 19:55:23', '2022-09-28 19:55:23', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (114, '固件列表', 'firmware-list', NULL, NULL, 91, 2, 'A', 0, 1, '2022-09-28 20:03:26', '2022-09-28 20:03:26', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (115, 'sdk列表', 'sdk-list', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:13:45', '2022-09-28 20:13:45', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (116, '新增sdk', 'sdk-add', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:15:36', '2022-09-28 20:15:36', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (117, '编辑sdk', 'sdk-update', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:19:21', '2022-10-18 11:03:12', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (118, '删除sdk', 'sdk-delete', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:20:52', '2022-09-28 20:20:52', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (119, '发布sdk', 'sdk-publish', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:22:01', '2022-09-28 20:22:01', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (120, '置顶sdk', 'sdk-top', NULL, NULL, 92, 2, 'A', 0, 1, '2022-09-28 20:24:17', '2022-09-28 20:24:17', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (121, 'App列表', 'app-list', NULL, NULL, 93, 2, 'A', 0, 1, '2022-09-28 20:25:03', '2022-09-28 20:25:03', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (122, '新增App', 'App-add', NULL, NULL, 93, 2, 'A', 0, 1, '2022-09-28 20:25:27', '2022-09-28 20:25:27', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (123, '删除App', 'App-delete', NULL, NULL, 93, 2, 'A', 0, 1, '2022-09-28 20:25:51', '2022-09-28 20:25:51', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (124, '设备入库', 'device-in', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:05:29', '2022-10-17 09:38:23', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (125, '设备出库', 'device-out', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:05:40', '2022-09-29 14:31:16', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (126, '批量入库', 'device-all-in', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:05:51', '2022-09-29 14:31:58', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (127, '批量出库', 'device-all-out', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:06:00', '2022-09-29 14:32:17', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (129, '删除设备', 'device-delete', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:06:30', '2022-09-29 14:32:56', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (130, '解绑设备', 'device-unbind', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:06:40', '2022-09-29 14:33:13', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (131, '设备列表', 'device-list', NULL, NULL, 20, 2, 'A', 0, 1, '2022-09-28 21:06:58', '2022-09-28 21:06:58', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (132, '权益详情', 'account-equityDetails', NULL, NULL, 80, 2, 'A', 0, 1, '2022-09-28 21:08:28', '2022-11-04 14:48:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (133, '新增权益', '', NULL, NULL, 133, 2, 'A', 0, 1, '2022-09-28 21:09:34', '2022-09-29 10:43:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (134, '新增下载', 'download-add', NULL, NULL, 80, 2, 'A', 2, 1, '2022-09-28 21:09:47', '2022-11-16 11:13:17', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (135, '相机详情', 'account-cameraDetails', NULL, NULL, 80, 2, 'A', 3, 1, '2022-09-28 21:10:23', '2022-11-16 11:13:31', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (136, '相机解绑', 'camera-unbind', NULL, NULL, 80, 2, 'I', 3, 0, '2022-09-28 21:10:35', '2022-11-25 12:33:21', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (137, '权益续费', 'account-equityRenew', NULL, NULL, 80, 2, 'A', 1, 1, '2022-09-28 21:10:58', '2022-11-25 17:48:08', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (138, '用户产品数据', '', NULL, NULL, 80, 2, 'I', 0, 0, '2022-09-28 21:12:05', '2022-11-04 14:46:37', '1', 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (139, '迁移', 'account-productTransfer', NULL, NULL, 80, 2, 'A', 5, 1, '2022-09-28 21:12:20', '2022-11-16 11:15:59', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (140, '看看下载', 'account-productDownload-0', NULL, NULL, 80, 2, 'A', 6, 1, '2022-09-28 21:12:32', '2022-11-16 11:16:06', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (141, '重算', 'account-productRerun', NULL, NULL, 80, 2, 'A', 7, 1, '2022-09-28 21:12:42', '2022-11-16 11:16:18', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (142, '复制', 'account-productCopy', NULL, NULL, 80, 2, 'A', 8, 1, '2022-09-28 21:12:50', '2022-11-16 11:16:24', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (143, '删除', 'account-productDelete', NULL, NULL, 80, 2, 'A', 9, 1, '2022-09-28 21:13:06', '2022-11-16 11:16:31', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (144, '解绑', 'cunstmer-device-unbind', NULL, NULL, 82, 2, 'A', 0, 0, '2022-09-29 09:24:46', '2022-09-29 09:26:35', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (145, '迁移', '', NULL, NULL, 83, 2, 'I', 0, 1, '2022-09-29 09:26:53', '2022-09-29 09:27:04', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (146, '下载', '', NULL, NULL, 83, 2, 'I', 0, 1, '2022-09-29 09:27:15', '2022-09-29 09:27:15', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (147, '重算', '', NULL, NULL, 83, 2, 'I', 0, 1, '2022-09-29 09:27:27', '2022-09-29 09:27:27', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (148, '复制', '', NULL, NULL, 83, 2, 'I', 0, 1, '2022-09-29 09:27:37', '2022-09-29 09:27:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (149, '删除', '', NULL, NULL, 83, 2, 'I', 0, 1, '2022-09-29 09:27:54', '2022-09-29 09:27:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (150, '新增应用', 'application-add', NULL, NULL, 105, 2, 'A', 0, 1, '2022-09-29 09:45:22', '2022-09-29 14:51:24', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (151, '删除应用', 'application-delete', NULL, NULL, 105, 2, 'A', 0, 1, '2022-09-29 09:45:31', '2022-09-29 14:51:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (152, '迁移', 'scenes-move', NULL, NULL, 94, 2, 'I', 1, 0, '2022-09-29 09:48:17', '2023-10-26 07:12:12', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (153, '看见 - 下载', 'scenes-download', NULL, NULL, 94, 2, 'I', 3, 1, '2022-09-29 09:48:33', '2022-10-26 17:53:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (154, '重算', 'scenes-recalculate', NULL, NULL, 94, 2, 'A', 4, 1, '2022-09-29 09:48:44', '2022-10-26 17:53:38', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (155, '复制', 'scenes-copy', NULL, NULL, 94, 2, 'A', 5, 1, '2022-09-29 09:48:53', '2022-10-26 17:53:43', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (156, '删除', 'scenes-delete', NULL, NULL, 94, 2, 'A', 6, 1, '2022-09-29 09:49:02', '2022-10-26 17:53:49', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (157, '场景列表', 'scenes-list', NULL, NULL, 94, 2, 'A', 0, 1, '2022-09-29 09:49:47', '2022-09-29 14:36:19', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (158, '方案列表', 'scheme-list', NULL, NULL, 95, 2, 'I', 0, 1, '2022-09-29 09:50:06', '2022-09-29 14:39:26', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (159, '同屏查看', 'scheme-view', NULL, NULL, 95, 2, 'I', 0, 1, '2022-09-29 09:54:09', '2022-09-29 14:39:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (160, '删除', 'scheme-delete', NULL, NULL, 95, 2, 'I', 0, 1, '2022-09-29 09:54:17', '2022-09-29 14:39:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (161, '作品列表', 'projects-list', NULL, NULL, 96, 2, 'A', 0, 1, '2022-09-29 09:54:55', '2022-09-29 14:45:22', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (162, '作品删除', 'projects-delete', NULL, NULL, 96, 2, 'A', 0, 1, '2022-09-29 09:55:10', '2022-09-29 14:45:38', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (163, '发票列表', 'invoice-list', NULL, NULL, 21, 2, 'A', 0, 1, '2022-09-29 10:03:56', '2022-09-29 14:34:15', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (164, '开票登记', 'invoice-checkin', NULL, NULL, 21, 2, 'A', 0, 1, '2022-09-29 10:07:40', '2022-09-29 14:34:25', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (165, '数据导出', 'invoice-export', NULL, NULL, 21, 2, 'A', 0, 1, '2022-09-29 10:07:51', '2022-09-29 14:34:32', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (166, '相机订单列表', 'camera-order-list', NULL, NULL, 88, 2, 'A', 0, 1, '2022-09-29 10:16:23', '2022-09-29 12:17:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (167, '数据导出', 'camera-order-export', NULL, NULL, 88, 2, 'A', 0, 1, '2022-09-29 10:16:36', '2022-09-29 12:18:19', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (168, '权益订单列表', 'rights-order-list', NULL, NULL, 89, 2, 'A', 0, 1, '2022-09-29 10:16:59', '2022-09-29 12:23:18', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (169, '数据导出', 'rights-order-export', NULL, NULL, 89, 2, 'A', 0, 1, '2022-09-29 10:17:08', '2022-09-29 12:23:30', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (170, '下载订单列表', 'download-order-list', NULL, NULL, 90, 2, 'A', 0, 1, '2022-09-29 10:17:18', '2022-09-29 14:36:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (171, '数据导出', 'download-order-export', NULL, NULL, 90, 2, 'A', 0, 1, '2022-09-29 10:17:51', '2022-09-29 14:36:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (172, '新闻列表', 'news-list', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:20:16', '2022-09-29 11:03:22', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (173, '新增新闻', 'news-add', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:20:30', '2022-09-29 11:03:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (174, '编辑新闻', 'news-edit', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:20:43', '2022-09-29 11:03:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (175, '删除新闻', 'news-delete', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:20:56', '2022-09-29 11:03:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (176, '发布新闻', 'news-publish', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:21:11', '2022-09-29 11:04:07', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (177, '置顶新闻', 'news-top', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:21:25', '2022-09-29 11:52:05', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (178, '显示设置', 'news-display', NULL, NULL, 85, 2, 'A', 0, 1, '2022-09-29 10:21:36', '2022-09-29 11:52:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (179, '招聘列表', 'recruit-list', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:24:12', '2022-09-29 12:00:43', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (180, '新增职位', 'recruit-add', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:24:23', '2022-09-29 12:03:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (181, '编辑职位', 'recruit-edit', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:24:34', '2022-09-29 12:04:52', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (182, '删除职位', 'recruit-delete', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:24:46', '2022-09-29 12:08:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (183, '发布职位', 'recruit-publish', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:25:00', '2022-09-29 12:09:05', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (184, '置顶职位', 'recruit-top', NULL, NULL, 86, 2, 'A', 0, 1, '2022-09-29 10:25:12', '2022-09-29 12:09:12', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (185, '留言列表', 'message-list', NULL, NULL, 87, 2, 'A', 0, 1, '2022-09-29 10:25:44', '2022-09-29 12:09:32', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (186, '处理留言', 'message-deal', NULL, NULL, 87, 2, 'A', 0, 1, '2022-09-29 10:25:53', '2022-09-29 12:09:39', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (187, '经销商列表', 'agent-list', NULL, NULL, 97, 2, 'A', 0, 1, '2022-09-29 10:26:25', '2022-09-29 12:14:36', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (188, '处理经销商申请', 'agent-deal', NULL, NULL, 97, 2, 'A', 0, 1, '2022-09-29 10:26:44', '2022-09-29 12:14:43', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (189, '深时场景申请列表', 'apply-list', NULL, NULL, 98, 2, 'A', 0, 1, '2022-09-29 10:27:20', '2022-09-29 12:16:29', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (190, '发送邮件', 'apply-send', NULL, NULL, 98, 2, 'A', 0, 1, '2022-09-29 10:27:40', '2022-09-29 12:16:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (191, '邮件模板设置', 'agent-set', NULL, NULL, 97, 2, 'A', 0, 1, '2022-09-29 10:27:52', '2022-10-14 16:40:27', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (193, '新增权益', 'increment-add', NULL, NULL, 80, 2, 'A', 1, 1, '2022-09-29 10:46:46', '2022-11-16 11:13:08', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (194, '应用列表', 'application-list', NULL, NULL, 105, 2, 'A', 0, 1, '2022-09-29 14:52:02', '2022-09-29 14:52:02', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (197, '编辑', 'customer-update', NULL, NULL, 202, 2, 'A', 4, 1, '2022-10-17 16:41:30', '2022-11-16 11:08:53', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (198, '删除', 'customer-delete', NULL, NULL, 202, 2, 'A', 5, 1, '2022-10-17 16:41:49', '2022-11-16 11:08:59', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (199, '新增客户', 'company-add', NULL, NULL, 202, 2, 'A', 1, 1, '2022-10-17 16:52:06', '2022-11-16 11:08:12', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (200, '客户设备', '', NULL, NULL, 18, 1, 'A', 1, 1, '2022-10-17 20:30:22', '2022-11-16 11:07:03', '/customer/device/:id', 1, 0, 'customer/device');
INSERT INTO `sys_menu` VALUES (201, '客户场景', '', NULL, NULL, 18, 1, 'A', 2, 1, '2022-10-17 20:31:33', '2022-11-16 11:07:10', '/customer/scene/:id', 1, 0, 'customer/scene');
INSERT INTO `sys_menu` VALUES (202, '客户管理', '', NULL, NULL, 18, 1, 'A', 0, 1, '2022-10-17 20:34:03', '2022-10-17 20:34:47', '/customer/index', 0, 0, 'customer/index');
INSERT INTO `sys_menu` VALUES (203, '下架', 'sdk-lower', NULL, NULL, 92, 2, 'A', 0, 1, '2022-10-18 11:07:07', '2022-10-18 11:07:07', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (204, '邮件模板', 'apply-set', NULL, NULL, 98, 2, 'A', 0, 1, '2022-10-19 11:39:10', '2022-10-19 11:39:10', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (205, '编辑', 'device-update', NULL, NULL, 20, 2, 'A', 0, 1, '2022-10-21 17:48:44', '2022-10-21 17:48:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (206, '看看-下载', 'scenes-download-0', NULL, NULL, 94, 2, 'I', 2, 1, '2022-10-25 16:19:35', '2022-10-26 17:53:27', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (207, '设备关联', 'device-connect', NULL, NULL, 200, 2, 'A', 1, 1, '2022-10-27 09:28:33', '2022-10-27 09:28:33', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (208, '解绑', 'device-unbind', NULL, NULL, 200, 2, 'A', 2, 1, '2022-10-27 09:29:22', '2022-11-16 11:09:44', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (209, '客户设备列表', 'device-list', NULL, NULL, 200, 2, 'A', 0, 1, '2022-10-27 09:29:57', '2022-11-16 11:09:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (210, '客户场景列表', 'customer-scenes-list', NULL, NULL, 201, 2, 'A', 0, 1, '2022-10-27 09:34:15', '2022-11-16 11:10:07', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (211, '迁移', 'customer-scenes-move', NULL, NULL, 201, 2, 'A', 1, 1, '2022-10-27 09:37:28', '2022-10-27 09:37:28', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (212, '看看下载', 'customer-scenes-download-0', NULL, NULL, 201, 2, 'A', 2, 1, '2022-10-27 09:37:58', '2022-11-16 11:10:29', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (213, '看见下载', 'customer-scenes-download-1', NULL, NULL, 201, 2, 'A', 2, 1, '2022-10-27 09:38:29', '2022-11-16 11:10:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (214, '重算', 'customer-scenes-recalculate', NULL, NULL, 201, 2, 'A', 3, 1, '2022-10-27 09:39:20', '2022-11-16 11:10:41', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (215, '复制', 'customer-scenes-copy', NULL, NULL, 201, 2, 'A', 4, 1, '2022-10-27 09:41:38', '2022-11-16 11:10:56', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (216, '删除', 'customer-scenes-delete', NULL, NULL, 201, 2, 'A', 5, 1, '2022-10-27 09:42:38', '2022-11-16 11:11:02', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (217, '用户概览', '', NULL, NULL, 80, 2, 'I', 1, 0, '2022-10-27 09:48:53', '2022-11-04 14:46:47', '1', 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (218, '看见下载', 'account-productDownload-1', NULL, NULL, 80, 2, 'A', 6, 1, '2022-10-27 09:56:28', '2022-11-25 18:08:27', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (219, '撤回新闻', 'news-withdraw', NULL, NULL, 85, 2, 'A', 1, 1, '2022-11-02 09:24:48', '2022-11-02 09:25:02', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (220, '操作日志', '', NULL, 'ant-design:calendar-outlined', NULL, 1, 'A', 100, 1, '2022-11-02 10:08:24', '2022-11-29 17:23:28', 'console/list', 0, 0, 'sys/error-log/index');
INSERT INTO `sys_menu` VALUES (221, '权益订单-编辑', 'account-equityEdit', NULL, NULL, 80, 2, 'I', 1, 0, '2022-11-02 16:01:33', '2022-11-25 17:51:21', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (222, '权益订单-删除', 'account-equityDelete', NULL, NULL, NULL, 2, 'I', 1, 1, '2022-11-02 16:01:54', '2022-11-02 16:01:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (223, '权益订单-编辑', 'account-equityEdit', NULL, NULL, 80, 2, 'I', 1, 1, '2022-11-02 16:02:51', '2022-11-02 16:02:51', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (224, '案例管理', '', NULL, 'ant-design:book-outlined', 16, 1, 'A', 1, 1, '2022-11-02 20:48:18', '2022-11-04 15:48:33', '/operate/case', 0, 0, 'operate/caseList');
INSERT INTO `sys_menu` VALUES (225, '经销商管理', NULL, NULL, 'ant-design:money-collect-twotone', NULL, 0, 'A', 1, 1, '2022-11-09 12:03:38', '2022-11-29 17:24:59', '/dealer/account', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (226, '经销商账号管理', '', NULL, 'ant-design:user-outlined', 225, 1, 'A', 1, 1, '2022-11-09 12:05:07', '2022-11-09 12:05:07', '/dealer/account', 0, 0, 'dealer/account');
INSERT INTO `sys_menu` VALUES (227, '经销商销售统计', '', NULL, 'ant-design:funnel-plot-twotone', 225, 1, 'A', 1, 1, '2022-11-09 12:07:04', '2022-11-17 11:15:49', '/dealer/finance', 0, 0, 'dealer/finance');
INSERT INTO `sys_menu` VALUES (228, '员工管理', '', NULL, 'ant-design:user-switch-outlined', NULL, 1, 'I', 10, 0, '2022-11-17 12:16:21', '2022-11-29 17:22:03', '/lanuser', 0, 0, 'lanUser/list');
INSERT INTO `sys_menu` VALUES (229, '相机列表解绑', 'account-equityCameraUnbind', NULL, NULL, 80, 2, 'A', 1, 1, '2022-11-17 17:30:54', '2022-11-17 17:30:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (230, '相机详情续费', 'account-equityRenew', NULL, NULL, 80, 2, 'I', 1, 1, '2022-11-17 17:31:39', '2022-11-17 17:31:39', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (231, '新增账号', 'lanuser-add', NULL, NULL, 228, 2, 'I', 1, 1, '2022-11-23 14:56:22', '2022-11-23 14:56:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (232, '重置密码', 'lanuser-pasword', NULL, NULL, 228, 2, 'I', 1, 1, '2022-11-23 14:57:11', '2022-11-23 14:57:11', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (233, '编辑', 'lanuser-update', NULL, NULL, 228, 2, 'I', 1, 1, '2022-11-23 14:57:25', '2022-11-23 14:57:25', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (234, '删除', 'lanuser-delete', NULL, NULL, 228, 2, 'I', 1, 1, '2022-11-23 14:57:37', '2022-11-23 14:57:37', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (235, '新增案例', 'case-add', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:12:48', '2022-11-25 11:12:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (236, '撤回', 'case-withdraw', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:13:11', '2022-11-25 11:13:11', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (237, '发布', 'case-publish', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:13:38', '2022-11-25 11:13:38', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (238, '编辑', 'case-edit', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:13:54', '2022-11-25 11:13:54', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (239, '删除', 'case-delete', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:14:12', '2022-11-25 11:14:12', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (240, '是否显示', 'case-display', NULL, NULL, 224, 2, 'A', 1, 1, '2022-11-25 11:15:11', '2022-11-25 11:15:11', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (241, '新增经销商', 'dealer-add', NULL, NULL, 226, 2, 'A', 1, 1, '2022-11-25 12:09:11', '2022-11-25 12:09:11', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (242, '权益设置', 'dealer-setequity', NULL, NULL, 226, 2, 'A', 1, 1, '2022-11-25 12:09:32', '2022-11-25 12:09:32', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (243, '编辑', 'dealer-edit', NULL, NULL, 226, 2, 'A', 1, 1, '2022-11-25 12:09:45', '2022-11-25 16:14:05', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (244, '删除', 'dealer-delete', NULL, NULL, 226, 2, 'A', 1, 1, '2022-11-25 12:09:57', '2022-11-25 12:09:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (245, '导出数据', 'dealer-export', NULL, NULL, 227, 2, 'A', 1, 1, '2022-11-25 12:10:39', '2022-11-25 12:10:39', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (246, '详情', 'accountlist-detail', NULL, NULL, 79, 2, 'A', 1, 1, '2022-11-25 12:30:48', '2022-11-25 12:30:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (247, '带看房间管理', '', NULL, 'ant-design:insert-row-above-outlined', 22, 1, 'A', 1, 1, '2022-12-20 17:31:56', '2023-01-10 17:39:57', '/productOperation/livestream', 0, 0, 'productOperation/livestream');
INSERT INTO `sys_menu` VALUES (248, '删除', 'livestream-delete', NULL, NULL, 247, 2, 'A', 1, 1, '2022-12-29 17:16:27', '2023-01-10 17:39:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (249, '是否显示', 'livestream-show', NULL, NULL, 247, 2, 'A', 1, 1, '2022-12-29 17:16:52', '2023-01-10 17:39:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (250, '深时点云-下载', 'scenes-download-2', NULL, NULL, 94, 2, 'I', 3, 1, '2022-12-30 10:15:48', '2023-01-10 17:39:57', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (251, '深时点云下载', 'account-productDownload-2', NULL, NULL, 80, 2, 'A', 6, 1, '2023-01-10 17:56:56', '2023-01-10 17:56:56', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (252, '深时Obj下载', 'account-productDownload-5', NULL, NULL, 80, 2, 'A', 6, 1, '2023-01-10 17:57:38', '2023-01-10 17:57:38', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (253, '深时点云下载', 'customer-scenes-download-2', NULL, NULL, 201, 2, 'A', 2, 1, '2023-01-10 17:59:19', '2023-01-10 17:59:19', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (254, '深时Obj下载', 'customer-scenes-download-5', NULL, NULL, 201, 2, 'A', 2, 1, '2023-01-10 17:59:38', '2023-01-10 17:59:38', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (255, '深时Obj-下载', 'scenes-download-5', NULL, NULL, 94, 2, 'I', 3, 1, '2023-01-10 18:01:01', '2023-01-10 18:01:01', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (256, '全景数据统计', '', NULL, '', 99, 1, 'A', 5, 1, '2023-01-16 10:57:29', '2023-01-16 10:57:29', '/statistics/viewKankan', 0, 0, '/statistics/viewKankan/index');
INSERT INTO `sys_menu` VALUES (257, '带看数据统计', '', NULL, NULL, 99, 1, 'A', 6, 1, '2023-03-29 12:10:44', '2023-03-29 12:10:44', '/statistics/livestream', 0, 0, 'statistics/livestream/index');
INSERT INTO `sys_menu` VALUES (258, '产品更新提示', '', NULL, 'ant-design:sound-twotone', 24, 1, 'A', 1, 1, '2023-03-29 12:14:15', '2023-03-29 12:14:15', '/product/updataTips', 0, 0, '/product/updataTips/index');
INSERT INTO `sys_menu` VALUES (259, '重置密码', 'lanuser-pasword', NULL, NULL, 17, 2, 'A', 1, 1, '2023-04-14 10:11:06', '2023-04-14 02:11:06', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (260, '编辑', 'lanuser-update', NULL, NULL, 17, 2, 'A', 1, 1, '2023-04-14 10:11:33', '2023-04-14 02:11:33', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (261, '删除', 'lanuser-delete', NULL, NULL, 17, 2, 'A', 1, 1, '2023-04-14 10:11:47', '2023-04-14 02:11:47', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (262, '新增', 'lanuser-add', NULL, NULL, 17, 2, 'A', 1, 1, '2023-04-14 10:12:01', '2023-04-14 02:12:01', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (263, '权限', 'scenes-powers', NULL, NULL, 94, 2, 'I', 1, 0, '2023-08-30 17:52:52', '2023-09-11 04:26:25', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (264, '编辑', 'scenes-edit', NULL, NULL, 94, 2, 'A', 1, 1, '2023-09-22 15:26:20', '2023-09-22 07:26:20', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (265, '设备删除', 'device-delete', NULL, NULL, 20, 2, 'A', 1, 1, '2023-09-22 15:35:45', '2023-09-22 07:35:45', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (266, '权限', 'scenes-powers', NULL, NULL, 94, 2, 'A', 1, 1, '2023-09-27 17:35:40', '2023-09-27 09:35:40', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (267, '权限新增', 'scenes-powers-add', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-08 18:18:59', '2023-10-08 10:18:59', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (268, '权限删除', 'scenes-powers-delete', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-08 18:19:25', '2023-10-08 10:19:25', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (269, '权限编辑', 'scenes-powers-edit', NULL, NULL, 94, 2, 'I', 1, 1, '2023-10-08 18:19:49', '2023-10-08 10:19:49', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (270, '生成 obj', 'scenes-creatobj', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-10 18:21:35', '2023-10-10 10:21:35', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (271, '深光点云-下载', 'scenes-download-6', NULL, NULL, 94, 2, 'I', 4, 1, '2023-10-26 09:12:44', '2023-10-26 01:12:59', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (272, '深光Obj-下载', 'scenes-download-7', NULL, NULL, 94, 2, 'I', 4, 1, '2023-10-26 09:13:45', '2023-10-26 01:13:45', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (273, '深光/深时Mesh-删除', '', NULL, NULL, 94, 2, 'I', 1, 1, '2023-10-26 12:02:03', '2023-10-26 04:03:27', 'scenes-delete-5', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (274, '深时点云-删除', 'scenes-delete-2', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-26 12:04:06', '2023-10-26 06:57:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (275, '看见-删除', 'scenes-delete-1', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-26 12:04:59', '2023-10-26 04:11:55', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (276, '深光点云-删除', 'scenes-delete-6', NULL, NULL, 94, 2, 'A', 1, 1, '2023-10-26 14:57:34', '2023-10-26 06:57:34', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (277, '共享场景', NULL, NULL, 'streamline:cloud-share', NULL, 0, 'A', 96, 1, '2024-04-18 11:43:37', '2024-04-25 09:05:11', '/sceneShare', 0, 0, 'LAYOUT');
INSERT INTO `sys_menu` VALUES (278, '我分享的', '', NULL, NULL, 277, 1, 'A', 1, 1, '2024-04-18 11:44:43', '2024-04-22 03:23:27', '/sceneShare/myScene', 0, 0, 'sceneShare/index');
INSERT INTO `sys_menu` VALUES (279, '与我分享', '', NULL, NULL, 277, 1, 'A', 2, 1, '2024-04-18 12:27:29', '2024-04-22 03:23:36', '/sceneShare/giveList', 0, 0, 'sceneShare/giveList');
INSERT INTO `sys_menu` VALUES (280, '新增共享', 'sceneShare-add', NULL, NULL, 278, 2, 'A', 1, 1, '2024-04-19 09:40:11', '2024-04-19 01:40:11', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (281, '删除共享', 'sceneShare-del', NULL, NULL, 278, 2, 'A', 1, 1, '2024-04-19 09:40:48', '2024-04-19 01:40:48', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (282, '看见 - 下载', 'scenes-download', NULL, NULL, 94, 2, 'A', 1, 1, '2024-05-30 11:20:30', '2024-06-03 06:23:00', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (283, '平台管理', '', NULL, NULL, 17, 1, 'A', 1, 1, '2024-11-15 14:43:46', '2024-11-15 06:43:46', '/lanUser/platformList', 0, 0, 'lanUser/platformList');
INSERT INTO `sys_menu` VALUES (284, '批量导入', 'lanuser-all', NULL, NULL, 17, 2, 'A', 1, 1, '2024-11-18 17:02:17', '2024-11-18 09:02:17', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (285, '创建平台', 'platformList-add', NULL, NULL, 17, 2, 'A', 1, 1, '2024-11-18 17:06:20', '2024-11-18 09:06:20', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (286, '平台管理-禁用', 'platformList-disable', NULL, NULL, 17, 2, 'A', 1, 1, '2024-11-18 17:06:51', '2024-11-18 09:06:51', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (287, '平台管理-启用', 'platformList-enable', NULL, NULL, 17, 2, 'A', 1, 1, '2024-11-18 17:07:07', '2024-11-18 09:07:07', NULL, 0, 0, NULL);
INSERT INTO `sys_menu` VALUES (288, '平台管理-编辑', 'platformList-update', NULL, NULL, 17, 2, 'A', 1, 1, '2024-11-18 17:07:25', '2024-11-18 09:07:25', NULL, 0, 0, NULL);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
                             `id` int NOT NULL AUTO_INCREMENT COMMENT '角色表',
                             `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色名称',
                             `role_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色类型',
                             `rec_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'A',
                             `create_user_id` int NULL DEFAULT NULL COMMENT '创建者id',
                             `status` int NULL DEFAULT 1 COMMENT '是否禁用 0禁用 1启用',
                             `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色说明',
                             `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                             `update_time` timestamp NULL DEFAULT NULL,
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '超级管理员', 'super-admin', 'A', 1, 1, '1', '2022-06-09 12:25:23', '2022-06-09 12:25:52');
INSERT INTO `sys_role` VALUES (45, '管理员', 'manage', 'A', 1, 1, '对外使用', '2023-04-13 21:10:52', '2023-04-13 13:10:52');
INSERT INTO `sys_role` VALUES (47, '普通警员', 'manage', 'A', 1, 1, '江门公安局', '2023-09-22 10:48:24', '2023-09-22 02:48:24');
INSERT INTO `sys_role` VALUES (48, '平台管理员', 'manage', 'A', 1, 1, NULL, '2024-11-18 14:15:57', '2024-11-18 14:15:57');

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
                                  `id` int NOT NULL AUTO_INCREMENT COMMENT '菜单角色关系表',
                                  `role_id` int NULL DEFAULT NULL,
                                  `menu_id` int NULL DEFAULT NULL,
                                  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22563 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES (20070, 46, 122);
INSERT INTO `sys_role_menu` VALUES (20071, 46, 256);
INSERT INTO `sys_role_menu` VALUES (20072, 46, 123);
INSERT INTO `sys_role_menu` VALUES (20073, 46, 257);
INSERT INTO `sys_role_menu` VALUES (20074, 46, 124);
INSERT INTO `sys_role_menu` VALUES (20075, 46, 1);
INSERT INTO `sys_role_menu` VALUES (20076, 46, 125);
INSERT INTO `sys_role_menu` VALUES (20077, 46, 258);
INSERT INTO `sys_role_menu` VALUES (20078, 46, 126);
INSERT INTO `sys_role_menu` VALUES (20079, 46, 2);
INSERT INTO `sys_role_menu` VALUES (20080, 46, 127);
INSERT INTO `sys_role_menu` VALUES (20081, 46, 259);
INSERT INTO `sys_role_menu` VALUES (20082, 46, 129);
INSERT INTO `sys_role_menu` VALUES (20083, 46, 3);
INSERT INTO `sys_role_menu` VALUES (20084, 46, 130);
INSERT INTO `sys_role_menu` VALUES (20085, 46, 260);
INSERT INTO `sys_role_menu` VALUES (20086, 46, 131);
INSERT INTO `sys_role_menu` VALUES (20087, 46, 4);
INSERT INTO `sys_role_menu` VALUES (20088, 46, 132);
INSERT INTO `sys_role_menu` VALUES (20089, 46, 261);
INSERT INTO `sys_role_menu` VALUES (20090, 46, 134);
INSERT INTO `sys_role_menu` VALUES (20091, 46, 5);
INSERT INTO `sys_role_menu` VALUES (20092, 46, 135);
INSERT INTO `sys_role_menu` VALUES (20093, 46, 262);
INSERT INTO `sys_role_menu` VALUES (20094, 46, 137);
INSERT INTO `sys_role_menu` VALUES (20095, 46, 6);
INSERT INTO `sys_role_menu` VALUES (20096, 46, 139);
INSERT INTO `sys_role_menu` VALUES (20097, 46, 7);
INSERT INTO `sys_role_menu` VALUES (20098, 46, 140);
INSERT INTO `sys_role_menu` VALUES (20099, 46, 8);
INSERT INTO `sys_role_menu` VALUES (20100, 46, 141);
INSERT INTO `sys_role_menu` VALUES (20101, 46, 9);
INSERT INTO `sys_role_menu` VALUES (20102, 46, 142);
INSERT INTO `sys_role_menu` VALUES (20103, 46, 10);
INSERT INTO `sys_role_menu` VALUES (20104, 46, 143);
INSERT INTO `sys_role_menu` VALUES (20105, 46, 11);
INSERT INTO `sys_role_menu` VALUES (20106, 46, 144);
INSERT INTO `sys_role_menu` VALUES (20107, 46, 12);
INSERT INTO `sys_role_menu` VALUES (20108, 46, 150);
INSERT INTO `sys_role_menu` VALUES (20109, 46, 13);
INSERT INTO `sys_role_menu` VALUES (20110, 46, 151);
INSERT INTO `sys_role_menu` VALUES (20111, 46, 14);
INSERT INTO `sys_role_menu` VALUES (20112, 46, 152);
INSERT INTO `sys_role_menu` VALUES (20113, 46, 15);
INSERT INTO `sys_role_menu` VALUES (20114, 46, 153);
INSERT INTO `sys_role_menu` VALUES (20115, 46, 16);
INSERT INTO `sys_role_menu` VALUES (20116, 46, 154);
INSERT INTO `sys_role_menu` VALUES (20117, 46, 17);
INSERT INTO `sys_role_menu` VALUES (20118, 46, 155);
INSERT INTO `sys_role_menu` VALUES (20119, 46, 18);
INSERT INTO `sys_role_menu` VALUES (20120, 46, 156);
INSERT INTO `sys_role_menu` VALUES (20121, 46, 19);
INSERT INTO `sys_role_menu` VALUES (20122, 46, 157);
INSERT INTO `sys_role_menu` VALUES (20123, 46, 20);
INSERT INTO `sys_role_menu` VALUES (20124, 46, 161);
INSERT INTO `sys_role_menu` VALUES (20125, 46, 21);
INSERT INTO `sys_role_menu` VALUES (20126, 46, 162);
INSERT INTO `sys_role_menu` VALUES (20127, 46, 22);
INSERT INTO `sys_role_menu` VALUES (20128, 46, 163);
INSERT INTO `sys_role_menu` VALUES (20129, 46, 23);
INSERT INTO `sys_role_menu` VALUES (20130, 46, 164);
INSERT INTO `sys_role_menu` VALUES (20131, 46, 24);
INSERT INTO `sys_role_menu` VALUES (20132, 46, 165);
INSERT INTO `sys_role_menu` VALUES (20133, 46, 79);
INSERT INTO `sys_role_menu` VALUES (20134, 46, 166);
INSERT INTO `sys_role_menu` VALUES (20135, 46, 80);
INSERT INTO `sys_role_menu` VALUES (20136, 46, 167);
INSERT INTO `sys_role_menu` VALUES (20137, 46, 81);
INSERT INTO `sys_role_menu` VALUES (20138, 46, 168);
INSERT INTO `sys_role_menu` VALUES (20139, 46, 82);
INSERT INTO `sys_role_menu` VALUES (20140, 46, 169);
INSERT INTO `sys_role_menu` VALUES (20141, 46, 83);
INSERT INTO `sys_role_menu` VALUES (20142, 46, 170);
INSERT INTO `sys_role_menu` VALUES (20143, 46, 85);
INSERT INTO `sys_role_menu` VALUES (20144, 46, 171);
INSERT INTO `sys_role_menu` VALUES (20145, 46, 86);
INSERT INTO `sys_role_menu` VALUES (20146, 46, 172);
INSERT INTO `sys_role_menu` VALUES (20147, 46, 87);
INSERT INTO `sys_role_menu` VALUES (20148, 46, 173);
INSERT INTO `sys_role_menu` VALUES (20149, 46, 88);
INSERT INTO `sys_role_menu` VALUES (20150, 46, 174);
INSERT INTO `sys_role_menu` VALUES (20151, 46, 89);
INSERT INTO `sys_role_menu` VALUES (20152, 46, 175);
INSERT INTO `sys_role_menu` VALUES (20153, 46, 90);
INSERT INTO `sys_role_menu` VALUES (20154, 46, 176);
INSERT INTO `sys_role_menu` VALUES (20155, 46, 91);
INSERT INTO `sys_role_menu` VALUES (20156, 46, 177);
INSERT INTO `sys_role_menu` VALUES (20157, 46, 92);
INSERT INTO `sys_role_menu` VALUES (20158, 46, 178);
INSERT INTO `sys_role_menu` VALUES (20159, 46, 93);
INSERT INTO `sys_role_menu` VALUES (20160, 46, 179);
INSERT INTO `sys_role_menu` VALUES (20161, 46, 94);
INSERT INTO `sys_role_menu` VALUES (20162, 46, 180);
INSERT INTO `sys_role_menu` VALUES (20163, 46, 96);
INSERT INTO `sys_role_menu` VALUES (20164, 46, 181);
INSERT INTO `sys_role_menu` VALUES (20165, 46, 97);
INSERT INTO `sys_role_menu` VALUES (20166, 46, 182);
INSERT INTO `sys_role_menu` VALUES (20167, 46, 98);
INSERT INTO `sys_role_menu` VALUES (20168, 46, 183);
INSERT INTO `sys_role_menu` VALUES (20169, 46, 99);
INSERT INTO `sys_role_menu` VALUES (20170, 46, 184);
INSERT INTO `sys_role_menu` VALUES (20171, 46, 100);
INSERT INTO `sys_role_menu` VALUES (20172, 46, 185);
INSERT INTO `sys_role_menu` VALUES (20173, 46, 101);
INSERT INTO `sys_role_menu` VALUES (20174, 46, 186);
INSERT INTO `sys_role_menu` VALUES (20175, 46, 102);
INSERT INTO `sys_role_menu` VALUES (20176, 46, 187);
INSERT INTO `sys_role_menu` VALUES (20177, 46, 103);
INSERT INTO `sys_role_menu` VALUES (20178, 46, 188);
INSERT INTO `sys_role_menu` VALUES (20179, 46, 104);
INSERT INTO `sys_role_menu` VALUES (20180, 46, 189);
INSERT INTO `sys_role_menu` VALUES (20181, 46, 105);
INSERT INTO `sys_role_menu` VALUES (20182, 46, 190);
INSERT INTO `sys_role_menu` VALUES (20183, 46, 106);
INSERT INTO `sys_role_menu` VALUES (20184, 46, 191);
INSERT INTO `sys_role_menu` VALUES (20185, 46, 107);
INSERT INTO `sys_role_menu` VALUES (20186, 46, 193);
INSERT INTO `sys_role_menu` VALUES (20187, 46, 108);
INSERT INTO `sys_role_menu` VALUES (20188, 46, 194);
INSERT INTO `sys_role_menu` VALUES (20189, 46, 109);
INSERT INTO `sys_role_menu` VALUES (20190, 46, 197);
INSERT INTO `sys_role_menu` VALUES (20191, 46, 110);
INSERT INTO `sys_role_menu` VALUES (20192, 46, 198);
INSERT INTO `sys_role_menu` VALUES (20193, 46, 111);
INSERT INTO `sys_role_menu` VALUES (20194, 46, 199);
INSERT INTO `sys_role_menu` VALUES (20195, 46, 112);
INSERT INTO `sys_role_menu` VALUES (20196, 46, 200);
INSERT INTO `sys_role_menu` VALUES (20197, 46, 113);
INSERT INTO `sys_role_menu` VALUES (20198, 46, 201);
INSERT INTO `sys_role_menu` VALUES (20199, 46, 114);
INSERT INTO `sys_role_menu` VALUES (20200, 46, 202);
INSERT INTO `sys_role_menu` VALUES (20201, 46, 115);
INSERT INTO `sys_role_menu` VALUES (20202, 46, 203);
INSERT INTO `sys_role_menu` VALUES (20203, 46, 116);
INSERT INTO `sys_role_menu` VALUES (20204, 46, 204);
INSERT INTO `sys_role_menu` VALUES (20205, 46, 117);
INSERT INTO `sys_role_menu` VALUES (20206, 46, 205);
INSERT INTO `sys_role_menu` VALUES (20207, 46, 118);
INSERT INTO `sys_role_menu` VALUES (20208, 46, 206);
INSERT INTO `sys_role_menu` VALUES (20209, 46, 119);
INSERT INTO `sys_role_menu` VALUES (20210, 46, 207);
INSERT INTO `sys_role_menu` VALUES (20211, 46, 120);
INSERT INTO `sys_role_menu` VALUES (20212, 46, 208);
INSERT INTO `sys_role_menu` VALUES (20213, 46, 121);
INSERT INTO `sys_role_menu` VALUES (20214, 46, 209);
INSERT INTO `sys_role_menu` VALUES (20215, 46, 122);
INSERT INTO `sys_role_menu` VALUES (20216, 46, 210);
INSERT INTO `sys_role_menu` VALUES (20217, 46, 123);
INSERT INTO `sys_role_menu` VALUES (20218, 46, 211);
INSERT INTO `sys_role_menu` VALUES (20219, 46, 124);
INSERT INTO `sys_role_menu` VALUES (20220, 46, 212);
INSERT INTO `sys_role_menu` VALUES (20221, 46, 125);
INSERT INTO `sys_role_menu` VALUES (20222, 46, 213);
INSERT INTO `sys_role_menu` VALUES (20223, 46, 126);
INSERT INTO `sys_role_menu` VALUES (20224, 46, 214);
INSERT INTO `sys_role_menu` VALUES (20225, 46, 127);
INSERT INTO `sys_role_menu` VALUES (20226, 46, 215);
INSERT INTO `sys_role_menu` VALUES (20227, 46, 129);
INSERT INTO `sys_role_menu` VALUES (20228, 46, 216);
INSERT INTO `sys_role_menu` VALUES (20229, 46, 130);
INSERT INTO `sys_role_menu` VALUES (20230, 46, 218);
INSERT INTO `sys_role_menu` VALUES (20231, 46, 131);
INSERT INTO `sys_role_menu` VALUES (20232, 46, 219);
INSERT INTO `sys_role_menu` VALUES (20233, 46, 132);
INSERT INTO `sys_role_menu` VALUES (20234, 46, 220);
INSERT INTO `sys_role_menu` VALUES (20235, 46, 134);
INSERT INTO `sys_role_menu` VALUES (20236, 46, 224);
INSERT INTO `sys_role_menu` VALUES (20237, 46, 135);
INSERT INTO `sys_role_menu` VALUES (20238, 46, 225);
INSERT INTO `sys_role_menu` VALUES (20239, 46, 137);
INSERT INTO `sys_role_menu` VALUES (20240, 46, 226);
INSERT INTO `sys_role_menu` VALUES (20241, 46, 139);
INSERT INTO `sys_role_menu` VALUES (20242, 46, 227);
INSERT INTO `sys_role_menu` VALUES (20243, 46, 140);
INSERT INTO `sys_role_menu` VALUES (20244, 46, 229);
INSERT INTO `sys_role_menu` VALUES (20245, 46, 141);
INSERT INTO `sys_role_menu` VALUES (20246, 46, 235);
INSERT INTO `sys_role_menu` VALUES (20247, 46, 142);
INSERT INTO `sys_role_menu` VALUES (20248, 46, 236);
INSERT INTO `sys_role_menu` VALUES (20249, 46, 143);
INSERT INTO `sys_role_menu` VALUES (20250, 46, 237);
INSERT INTO `sys_role_menu` VALUES (20251, 46, 144);
INSERT INTO `sys_role_menu` VALUES (20252, 46, 238);
INSERT INTO `sys_role_menu` VALUES (20253, 46, 150);
INSERT INTO `sys_role_menu` VALUES (20254, 46, 239);
INSERT INTO `sys_role_menu` VALUES (20255, 46, 151);
INSERT INTO `sys_role_menu` VALUES (20256, 46, 240);
INSERT INTO `sys_role_menu` VALUES (20257, 46, 152);
INSERT INTO `sys_role_menu` VALUES (20258, 46, 241);
INSERT INTO `sys_role_menu` VALUES (20259, 46, 153);
INSERT INTO `sys_role_menu` VALUES (20260, 46, 242);
INSERT INTO `sys_role_menu` VALUES (20261, 46, 154);
INSERT INTO `sys_role_menu` VALUES (20262, 46, 243);
INSERT INTO `sys_role_menu` VALUES (20263, 46, 155);
INSERT INTO `sys_role_menu` VALUES (20264, 46, 244);
INSERT INTO `sys_role_menu` VALUES (20265, 46, 156);
INSERT INTO `sys_role_menu` VALUES (20266, 46, 245);
INSERT INTO `sys_role_menu` VALUES (20267, 46, 157);
INSERT INTO `sys_role_menu` VALUES (20268, 46, 246);
INSERT INTO `sys_role_menu` VALUES (20269, 46, 161);
INSERT INTO `sys_role_menu` VALUES (20270, 46, 247);
INSERT INTO `sys_role_menu` VALUES (20271, 46, 162);
INSERT INTO `sys_role_menu` VALUES (20272, 46, 248);
INSERT INTO `sys_role_menu` VALUES (20273, 46, 163);
INSERT INTO `sys_role_menu` VALUES (20274, 46, 249);
INSERT INTO `sys_role_menu` VALUES (20275, 46, 164);
INSERT INTO `sys_role_menu` VALUES (20276, 46, 250);
INSERT INTO `sys_role_menu` VALUES (20277, 46, 165);
INSERT INTO `sys_role_menu` VALUES (20278, 46, 251);
INSERT INTO `sys_role_menu` VALUES (20279, 46, 166);
INSERT INTO `sys_role_menu` VALUES (20280, 46, 252);
INSERT INTO `sys_role_menu` VALUES (20281, 46, 167);
INSERT INTO `sys_role_menu` VALUES (20282, 46, 253);
INSERT INTO `sys_role_menu` VALUES (20283, 46, 168);
INSERT INTO `sys_role_menu` VALUES (20284, 46, 254);
INSERT INTO `sys_role_menu` VALUES (20285, 46, 169);
INSERT INTO `sys_role_menu` VALUES (20286, 46, 255);
INSERT INTO `sys_role_menu` VALUES (20287, 46, 170);
INSERT INTO `sys_role_menu` VALUES (20288, 46, 171);
INSERT INTO `sys_role_menu` VALUES (20289, 46, 172);
INSERT INTO `sys_role_menu` VALUES (20290, 46, 173);
INSERT INTO `sys_role_menu` VALUES (20291, 46, 174);
INSERT INTO `sys_role_menu` VALUES (20292, 46, 175);
INSERT INTO `sys_role_menu` VALUES (20293, 46, 176);
INSERT INTO `sys_role_menu` VALUES (20294, 46, 177);
INSERT INTO `sys_role_menu` VALUES (20295, 46, 178);
INSERT INTO `sys_role_menu` VALUES (20296, 46, 179);
INSERT INTO `sys_role_menu` VALUES (20297, 46, 180);
INSERT INTO `sys_role_menu` VALUES (20298, 46, 181);
INSERT INTO `sys_role_menu` VALUES (20299, 46, 182);
INSERT INTO `sys_role_menu` VALUES (20300, 46, 183);
INSERT INTO `sys_role_menu` VALUES (20301, 46, 184);
INSERT INTO `sys_role_menu` VALUES (20302, 46, 185);
INSERT INTO `sys_role_menu` VALUES (20303, 46, 186);
INSERT INTO `sys_role_menu` VALUES (20304, 46, 187);
INSERT INTO `sys_role_menu` VALUES (20305, 46, 188);
INSERT INTO `sys_role_menu` VALUES (20306, 46, 189);
INSERT INTO `sys_role_menu` VALUES (20307, 46, 190);
INSERT INTO `sys_role_menu` VALUES (20308, 46, 191);
INSERT INTO `sys_role_menu` VALUES (20309, 46, 193);
INSERT INTO `sys_role_menu` VALUES (20310, 46, 194);
INSERT INTO `sys_role_menu` VALUES (20311, 46, 197);
INSERT INTO `sys_role_menu` VALUES (20312, 46, 198);
INSERT INTO `sys_role_menu` VALUES (20313, 46, 199);
INSERT INTO `sys_role_menu` VALUES (20314, 46, 200);
INSERT INTO `sys_role_menu` VALUES (20315, 46, 201);
INSERT INTO `sys_role_menu` VALUES (20316, 46, 202);
INSERT INTO `sys_role_menu` VALUES (20317, 46, 203);
INSERT INTO `sys_role_menu` VALUES (20318, 46, 204);
INSERT INTO `sys_role_menu` VALUES (20319, 46, 205);
INSERT INTO `sys_role_menu` VALUES (20320, 46, 206);
INSERT INTO `sys_role_menu` VALUES (20321, 46, 207);
INSERT INTO `sys_role_menu` VALUES (20322, 46, 208);
INSERT INTO `sys_role_menu` VALUES (20323, 46, 209);
INSERT INTO `sys_role_menu` VALUES (20324, 46, 210);
INSERT INTO `sys_role_menu` VALUES (20325, 46, 211);
INSERT INTO `sys_role_menu` VALUES (20326, 46, 212);
INSERT INTO `sys_role_menu` VALUES (20327, 46, 213);
INSERT INTO `sys_role_menu` VALUES (20328, 46, 214);
INSERT INTO `sys_role_menu` VALUES (20329, 46, 215);
INSERT INTO `sys_role_menu` VALUES (20330, 46, 216);
INSERT INTO `sys_role_menu` VALUES (20331, 46, 218);
INSERT INTO `sys_role_menu` VALUES (20332, 46, 219);
INSERT INTO `sys_role_menu` VALUES (20333, 46, 220);
INSERT INTO `sys_role_menu` VALUES (20334, 46, 224);
INSERT INTO `sys_role_menu` VALUES (20335, 46, 225);
INSERT INTO `sys_role_menu` VALUES (20336, 46, 226);
INSERT INTO `sys_role_menu` VALUES (20337, 46, 227);
INSERT INTO `sys_role_menu` VALUES (20338, 46, 229);
INSERT INTO `sys_role_menu` VALUES (20339, 46, 235);
INSERT INTO `sys_role_menu` VALUES (20340, 46, 236);
INSERT INTO `sys_role_menu` VALUES (20341, 46, 237);
INSERT INTO `sys_role_menu` VALUES (20342, 46, 238);
INSERT INTO `sys_role_menu` VALUES (20343, 46, 239);
INSERT INTO `sys_role_menu` VALUES (20344, 46, 240);
INSERT INTO `sys_role_menu` VALUES (20345, 46, 241);
INSERT INTO `sys_role_menu` VALUES (20346, 46, 242);
INSERT INTO `sys_role_menu` VALUES (20347, 46, 243);
INSERT INTO `sys_role_menu` VALUES (20348, 46, 244);
INSERT INTO `sys_role_menu` VALUES (20349, 46, 245);
INSERT INTO `sys_role_menu` VALUES (20350, 46, 246);
INSERT INTO `sys_role_menu` VALUES (20351, 46, 247);
INSERT INTO `sys_role_menu` VALUES (20352, 46, 248);
INSERT INTO `sys_role_menu` VALUES (20353, 46, 249);
INSERT INTO `sys_role_menu` VALUES (20354, 46, 250);
INSERT INTO `sys_role_menu` VALUES (20355, 46, 251);
INSERT INTO `sys_role_menu` VALUES (20356, 46, 252);
INSERT INTO `sys_role_menu` VALUES (20357, 46, 253);
INSERT INTO `sys_role_menu` VALUES (20358, 46, 254);
INSERT INTO `sys_role_menu` VALUES (20359, 46, 255);
INSERT INTO `sys_role_menu` VALUES (21061, 1, 256);
INSERT INTO `sys_role_menu` VALUES (21062, 1, 257);
INSERT INTO `sys_role_menu` VALUES (21063, 1, 1);
INSERT INTO `sys_role_menu` VALUES (21064, 1, 2);
INSERT INTO `sys_role_menu` VALUES (21065, 1, 258);
INSERT INTO `sys_role_menu` VALUES (21066, 1, 3);
INSERT INTO `sys_role_menu` VALUES (21067, 1, 4);
INSERT INTO `sys_role_menu` VALUES (21068, 1, 5);
INSERT INTO `sys_role_menu` VALUES (21069, 1, 6);
INSERT INTO `sys_role_menu` VALUES (21070, 1, 7);
INSERT INTO `sys_role_menu` VALUES (21071, 1, 8);
INSERT INTO `sys_role_menu` VALUES (21072, 1, 264);
INSERT INTO `sys_role_menu` VALUES (21073, 1, 9);
INSERT INTO `sys_role_menu` VALUES (21074, 1, 265);
INSERT INTO `sys_role_menu` VALUES (21075, 1, 10);
INSERT INTO `sys_role_menu` VALUES (21076, 1, 266);
INSERT INTO `sys_role_menu` VALUES (21077, 1, 11);
INSERT INTO `sys_role_menu` VALUES (21078, 1, 267);
INSERT INTO `sys_role_menu` VALUES (21079, 1, 12);
INSERT INTO `sys_role_menu` VALUES (21080, 1, 268);
INSERT INTO `sys_role_menu` VALUES (21081, 1, 13);
INSERT INTO `sys_role_menu` VALUES (21082, 1, 14);
INSERT INTO `sys_role_menu` VALUES (21083, 1, 270);
INSERT INTO `sys_role_menu` VALUES (21084, 1, 15);
INSERT INTO `sys_role_menu` VALUES (21085, 1, 16);
INSERT INTO `sys_role_menu` VALUES (21086, 1, 17);
INSERT INTO `sys_role_menu` VALUES (21087, 1, 18);
INSERT INTO `sys_role_menu` VALUES (21088, 1, 19);
INSERT INTO `sys_role_menu` VALUES (21089, 1, 20);
INSERT INTO `sys_role_menu` VALUES (21090, 1, 21);
INSERT INTO `sys_role_menu` VALUES (21091, 1, 22);
INSERT INTO `sys_role_menu` VALUES (21092, 1, 23);
INSERT INTO `sys_role_menu` VALUES (21093, 1, 24);
INSERT INTO `sys_role_menu` VALUES (21094, 1, 79);
INSERT INTO `sys_role_menu` VALUES (21095, 1, 80);
INSERT INTO `sys_role_menu` VALUES (21096, 1, 81);
INSERT INTO `sys_role_menu` VALUES (21097, 1, 82);
INSERT INTO `sys_role_menu` VALUES (21098, 1, 83);
INSERT INTO `sys_role_menu` VALUES (21099, 1, 85);
INSERT INTO `sys_role_menu` VALUES (21100, 1, 86);
INSERT INTO `sys_role_menu` VALUES (21101, 1, 87);
INSERT INTO `sys_role_menu` VALUES (21102, 1, 88);
INSERT INTO `sys_role_menu` VALUES (21103, 1, 89);
INSERT INTO `sys_role_menu` VALUES (21104, 1, 90);
INSERT INTO `sys_role_menu` VALUES (21105, 1, 91);
INSERT INTO `sys_role_menu` VALUES (21106, 1, 92);
INSERT INTO `sys_role_menu` VALUES (21107, 1, 93);
INSERT INTO `sys_role_menu` VALUES (21108, 1, 94);
INSERT INTO `sys_role_menu` VALUES (21109, 1, 96);
INSERT INTO `sys_role_menu` VALUES (21110, 1, 97);
INSERT INTO `sys_role_menu` VALUES (21111, 1, 98);
INSERT INTO `sys_role_menu` VALUES (21112, 1, 99);
INSERT INTO `sys_role_menu` VALUES (21113, 1, 100);
INSERT INTO `sys_role_menu` VALUES (21114, 1, 101);
INSERT INTO `sys_role_menu` VALUES (21115, 1, 102);
INSERT INTO `sys_role_menu` VALUES (21116, 1, 103);
INSERT INTO `sys_role_menu` VALUES (21117, 1, 104);
INSERT INTO `sys_role_menu` VALUES (21118, 1, 105);
INSERT INTO `sys_role_menu` VALUES (21119, 1, 106);
INSERT INTO `sys_role_menu` VALUES (21120, 1, 107);
INSERT INTO `sys_role_menu` VALUES (21121, 1, 108);
INSERT INTO `sys_role_menu` VALUES (21122, 1, 109);
INSERT INTO `sys_role_menu` VALUES (21123, 1, 110);
INSERT INTO `sys_role_menu` VALUES (21124, 1, 111);
INSERT INTO `sys_role_menu` VALUES (21125, 1, 112);
INSERT INTO `sys_role_menu` VALUES (21126, 1, 113);
INSERT INTO `sys_role_menu` VALUES (21127, 1, 114);
INSERT INTO `sys_role_menu` VALUES (21128, 1, 115);
INSERT INTO `sys_role_menu` VALUES (21129, 1, 116);
INSERT INTO `sys_role_menu` VALUES (21130, 1, 117);
INSERT INTO `sys_role_menu` VALUES (21131, 1, 118);
INSERT INTO `sys_role_menu` VALUES (21132, 1, 119);
INSERT INTO `sys_role_menu` VALUES (21133, 1, 120);
INSERT INTO `sys_role_menu` VALUES (21134, 1, 121);
INSERT INTO `sys_role_menu` VALUES (21135, 1, 122);
INSERT INTO `sys_role_menu` VALUES (21136, 1, 123);
INSERT INTO `sys_role_menu` VALUES (21137, 1, 124);
INSERT INTO `sys_role_menu` VALUES (21138, 1, 125);
INSERT INTO `sys_role_menu` VALUES (21139, 1, 126);
INSERT INTO `sys_role_menu` VALUES (21140, 1, 127);
INSERT INTO `sys_role_menu` VALUES (21141, 1, 129);
INSERT INTO `sys_role_menu` VALUES (21142, 1, 130);
INSERT INTO `sys_role_menu` VALUES (21143, 1, 131);
INSERT INTO `sys_role_menu` VALUES (21144, 1, 132);
INSERT INTO `sys_role_menu` VALUES (21145, 1, 134);
INSERT INTO `sys_role_menu` VALUES (21146, 1, 135);
INSERT INTO `sys_role_menu` VALUES (21147, 1, 137);
INSERT INTO `sys_role_menu` VALUES (21148, 1, 139);
INSERT INTO `sys_role_menu` VALUES (21149, 1, 140);
INSERT INTO `sys_role_menu` VALUES (21150, 1, 141);
INSERT INTO `sys_role_menu` VALUES (21151, 1, 142);
INSERT INTO `sys_role_menu` VALUES (21152, 1, 143);
INSERT INTO `sys_role_menu` VALUES (21153, 1, 144);
INSERT INTO `sys_role_menu` VALUES (21154, 1, 150);
INSERT INTO `sys_role_menu` VALUES (21155, 1, 151);
INSERT INTO `sys_role_menu` VALUES (21156, 1, 152);
INSERT INTO `sys_role_menu` VALUES (21157, 1, 153);
INSERT INTO `sys_role_menu` VALUES (21158, 1, 154);
INSERT INTO `sys_role_menu` VALUES (21159, 1, 155);
INSERT INTO `sys_role_menu` VALUES (21160, 1, 156);
INSERT INTO `sys_role_menu` VALUES (21161, 1, 157);
INSERT INTO `sys_role_menu` VALUES (21162, 1, 161);
INSERT INTO `sys_role_menu` VALUES (21163, 1, 162);
INSERT INTO `sys_role_menu` VALUES (21164, 1, 163);
INSERT INTO `sys_role_menu` VALUES (21165, 1, 164);
INSERT INTO `sys_role_menu` VALUES (21166, 1, 165);
INSERT INTO `sys_role_menu` VALUES (21167, 1, 166);
INSERT INTO `sys_role_menu` VALUES (21168, 1, 167);
INSERT INTO `sys_role_menu` VALUES (21169, 1, 168);
INSERT INTO `sys_role_menu` VALUES (21170, 1, 169);
INSERT INTO `sys_role_menu` VALUES (21171, 1, 170);
INSERT INTO `sys_role_menu` VALUES (21172, 1, 171);
INSERT INTO `sys_role_menu` VALUES (21173, 1, 172);
INSERT INTO `sys_role_menu` VALUES (21174, 1, 173);
INSERT INTO `sys_role_menu` VALUES (21175, 1, 174);
INSERT INTO `sys_role_menu` VALUES (21176, 1, 175);
INSERT INTO `sys_role_menu` VALUES (21177, 1, 176);
INSERT INTO `sys_role_menu` VALUES (21178, 1, 177);
INSERT INTO `sys_role_menu` VALUES (21179, 1, 178);
INSERT INTO `sys_role_menu` VALUES (21180, 1, 179);
INSERT INTO `sys_role_menu` VALUES (21181, 1, 180);
INSERT INTO `sys_role_menu` VALUES (21182, 1, 181);
INSERT INTO `sys_role_menu` VALUES (21183, 1, 182);
INSERT INTO `sys_role_menu` VALUES (21184, 1, 183);
INSERT INTO `sys_role_menu` VALUES (21185, 1, 184);
INSERT INTO `sys_role_menu` VALUES (21186, 1, 185);
INSERT INTO `sys_role_menu` VALUES (21187, 1, 186);
INSERT INTO `sys_role_menu` VALUES (21188, 1, 187);
INSERT INTO `sys_role_menu` VALUES (21189, 1, 188);
INSERT INTO `sys_role_menu` VALUES (21190, 1, 189);
INSERT INTO `sys_role_menu` VALUES (21191, 1, 190);
INSERT INTO `sys_role_menu` VALUES (21192, 1, 191);
INSERT INTO `sys_role_menu` VALUES (21193, 1, 193);
INSERT INTO `sys_role_menu` VALUES (21194, 1, 194);
INSERT INTO `sys_role_menu` VALUES (21195, 1, 197);
INSERT INTO `sys_role_menu` VALUES (21196, 1, 198);
INSERT INTO `sys_role_menu` VALUES (21197, 1, 199);
INSERT INTO `sys_role_menu` VALUES (21198, 1, 200);
INSERT INTO `sys_role_menu` VALUES (21199, 1, 201);
INSERT INTO `sys_role_menu` VALUES (21200, 1, 202);
INSERT INTO `sys_role_menu` VALUES (21201, 1, 203);
INSERT INTO `sys_role_menu` VALUES (21202, 1, 204);
INSERT INTO `sys_role_menu` VALUES (21203, 1, 205);
INSERT INTO `sys_role_menu` VALUES (21204, 1, 206);
INSERT INTO `sys_role_menu` VALUES (21205, 1, 207);
INSERT INTO `sys_role_menu` VALUES (21206, 1, 208);
INSERT INTO `sys_role_menu` VALUES (21207, 1, 209);
INSERT INTO `sys_role_menu` VALUES (21208, 1, 210);
INSERT INTO `sys_role_menu` VALUES (21209, 1, 211);
INSERT INTO `sys_role_menu` VALUES (21210, 1, 212);
INSERT INTO `sys_role_menu` VALUES (21211, 1, 213);
INSERT INTO `sys_role_menu` VALUES (21212, 1, 214);
INSERT INTO `sys_role_menu` VALUES (21213, 1, 215);
INSERT INTO `sys_role_menu` VALUES (21214, 1, 216);
INSERT INTO `sys_role_menu` VALUES (21215, 1, 218);
INSERT INTO `sys_role_menu` VALUES (21216, 1, 219);
INSERT INTO `sys_role_menu` VALUES (21217, 1, 220);
INSERT INTO `sys_role_menu` VALUES (21218, 1, 224);
INSERT INTO `sys_role_menu` VALUES (21219, 1, 225);
INSERT INTO `sys_role_menu` VALUES (21220, 1, 226);
INSERT INTO `sys_role_menu` VALUES (21221, 1, 227);
INSERT INTO `sys_role_menu` VALUES (21222, 1, 229);
INSERT INTO `sys_role_menu` VALUES (21223, 1, 235);
INSERT INTO `sys_role_menu` VALUES (21224, 1, 236);
INSERT INTO `sys_role_menu` VALUES (21225, 1, 237);
INSERT INTO `sys_role_menu` VALUES (21226, 1, 238);
INSERT INTO `sys_role_menu` VALUES (21227, 1, 239);
INSERT INTO `sys_role_menu` VALUES (21228, 1, 240);
INSERT INTO `sys_role_menu` VALUES (21229, 1, 241);
INSERT INTO `sys_role_menu` VALUES (21230, 1, 242);
INSERT INTO `sys_role_menu` VALUES (21231, 1, 243);
INSERT INTO `sys_role_menu` VALUES (21232, 1, 244);
INSERT INTO `sys_role_menu` VALUES (21233, 1, 245);
INSERT INTO `sys_role_menu` VALUES (21234, 1, 246);
INSERT INTO `sys_role_menu` VALUES (21235, 1, 247);
INSERT INTO `sys_role_menu` VALUES (21236, 1, 248);
INSERT INTO `sys_role_menu` VALUES (21237, 1, 249);
INSERT INTO `sys_role_menu` VALUES (21238, 1, 250);
INSERT INTO `sys_role_menu` VALUES (21239, 1, 251);
INSERT INTO `sys_role_menu` VALUES (21240, 1, 252);
INSERT INTO `sys_role_menu` VALUES (21241, 1, 253);
INSERT INTO `sys_role_menu` VALUES (21242, 1, 254);
INSERT INTO `sys_role_menu` VALUES (21243, 1, 255);
INSERT INTO `sys_role_menu` VALUES (21444, 1, 271);
INSERT INTO `sys_role_menu` VALUES (21445, 1, 272);
INSERT INTO `sys_role_menu` VALUES (21565, 1, 273);
INSERT INTO `sys_role_menu` VALUES (21566, 1, 274);
INSERT INTO `sys_role_menu` VALUES (21567, 1, 275);
INSERT INTO `sys_role_menu` VALUES (21787, 1, 276);
INSERT INTO `sys_role_menu` VALUES (21834, 1, 277);
INSERT INTO `sys_role_menu` VALUES (21835, 1, 278);
INSERT INTO `sys_role_menu` VALUES (21836, 1, 279);
INSERT INTO `sys_role_menu` VALUES (21853, 1, 280);
INSERT INTO `sys_role_menu` VALUES (21854, 1, 281);
INSERT INTO `sys_role_menu` VALUES (21942, 1, 282);
INSERT INTO `sys_role_menu` VALUES (21943, 47, 264);
INSERT INTO `sys_role_menu` VALUES (21944, 47, 266);
INSERT INTO `sys_role_menu` VALUES (21945, 47, 267);
INSERT INTO `sys_role_menu` VALUES (21946, 47, 268);
INSERT INTO `sys_role_menu` VALUES (21947, 47, 270);
INSERT INTO `sys_role_menu` VALUES (21948, 47, 274);
INSERT INTO `sys_role_menu` VALUES (21949, 47, 19);
INSERT INTO `sys_role_menu` VALUES (21950, 47, 275);
INSERT INTO `sys_role_menu` VALUES (21951, 47, 276);
INSERT INTO `sys_role_menu` VALUES (21952, 47, 277);
INSERT INTO `sys_role_menu` VALUES (21953, 47, 22);
INSERT INTO `sys_role_menu` VALUES (21954, 47, 278);
INSERT INTO `sys_role_menu` VALUES (21955, 47, 279);
INSERT INTO `sys_role_menu` VALUES (21956, 47, 280);
INSERT INTO `sys_role_menu` VALUES (21957, 47, 281);
INSERT INTO `sys_role_menu` VALUES (21958, 47, 282);
INSERT INTO `sys_role_menu` VALUES (21959, 47, 155);
INSERT INTO `sys_role_menu` VALUES (21960, 47, 157);
INSERT INTO `sys_role_menu` VALUES (21961, 47, 94);
INSERT INTO `sys_role_menu` VALUES (21988, 47, 153);
INSERT INTO `sys_role_menu` VALUES (22018, 1, 283);
INSERT INTO `sys_role_menu` VALUES (22106, 1, 284);
INSERT INTO `sys_role_menu` VALUES (22107, 1, 285);
INSERT INTO `sys_role_menu` VALUES (22108, 1, 286);
INSERT INTO `sys_role_menu` VALUES (22109, 1, 287);
INSERT INTO `sys_role_menu` VALUES (22110, 1, 288);
INSERT INTO `sys_role_menu` VALUES (22452, NULL, NULL);
INSERT INTO `sys_role_menu` VALUES (22453, 1, 231);
INSERT INTO `sys_role_menu` VALUES (22497, 45, 262);
INSERT INTO `sys_role_menu` VALUES (22498, 45, 264);
INSERT INTO `sys_role_menu` VALUES (22499, 45, 266);
INSERT INTO `sys_role_menu` VALUES (22500, 45, 267);
INSERT INTO `sys_role_menu` VALUES (22501, 45, 268);
INSERT INTO `sys_role_menu` VALUES (22502, 45, 270);
INSERT INTO `sys_role_menu` VALUES (22503, 45, 79);
INSERT INTO `sys_role_menu` VALUES (22504, 45, 17);
INSERT INTO `sys_role_menu` VALUES (22505, 45, 274);
INSERT INTO `sys_role_menu` VALUES (22506, 45, 19);
INSERT INTO `sys_role_menu` VALUES (22507, 45, 275);
INSERT INTO `sys_role_menu` VALUES (22508, 45, 276);
INSERT INTO `sys_role_menu` VALUES (22509, 45, 22);
INSERT INTO `sys_role_menu` VALUES (22510, 45, 154);
INSERT INTO `sys_role_menu` VALUES (22511, 45, 282);
INSERT INTO `sys_role_menu` VALUES (22512, 45, 155);
INSERT INTO `sys_role_menu` VALUES (22513, 45, 283);
INSERT INTO `sys_role_menu` VALUES (22514, 45, 284);
INSERT INTO `sys_role_menu` VALUES (22515, 45, 157);
INSERT INTO `sys_role_menu` VALUES (22516, 45, 285);
INSERT INTO `sys_role_menu` VALUES (22517, 45, 94);
INSERT INTO `sys_role_menu` VALUES (22518, 45, 286);
INSERT INTO `sys_role_menu` VALUES (22519, 45, 287);
INSERT INTO `sys_role_menu` VALUES (22520, 45, 288);
INSERT INTO `sys_role_menu` VALUES (22521, 45, 246);
INSERT INTO `sys_role_menu` VALUES (22543, 48, 262);
INSERT INTO `sys_role_menu` VALUES (22544, 48, 264);
INSERT INTO `sys_role_menu` VALUES (22545, 48, 266);
INSERT INTO `sys_role_menu` VALUES (22546, 48, 267);
INSERT INTO `sys_role_menu` VALUES (22547, 48, 268);
INSERT INTO `sys_role_menu` VALUES (22548, 48, 270);
INSERT INTO `sys_role_menu` VALUES (22549, 48, 79);
INSERT INTO `sys_role_menu` VALUES (22550, 48, 17);
INSERT INTO `sys_role_menu` VALUES (22551, 48, 274);
INSERT INTO `sys_role_menu` VALUES (22552, 48, 19);
INSERT INTO `sys_role_menu` VALUES (22553, 48, 275);
INSERT INTO `sys_role_menu` VALUES (22554, 48, 276);
INSERT INTO `sys_role_menu` VALUES (22555, 48, 22);
INSERT INTO `sys_role_menu` VALUES (22556, 48, 246);
INSERT INTO `sys_role_menu` VALUES (22557, 48, 282);
INSERT INTO `sys_role_menu` VALUES (22558, 48, 154);
INSERT INTO `sys_role_menu` VALUES (22559, 48, 155);
INSERT INTO `sys_role_menu` VALUES (22560, 48, 284);
INSERT INTO `sys_role_menu` VALUES (22561, 48, 157);
INSERT INTO `sys_role_menu` VALUES (22562, 48, 94);



CREATE TABLE `4dkankan_v4`.`jy_platform`  (
                                           `id` int NOT NULL AUTO_INCREMENT,
                                           `platform_name` varchar(255) NULL COMMENT '平台名称',
                                           `platform_address` varchar(255) NULL COMMENT '平台地址',
                                           `name` varchar(255)  DEFAULT NULL COMMENT '平台管理员姓名',
                                           `phone` varchar(255) DEFAULT NULL COMMENT '平台管理手机号码',
                                           `id_card` varchar(255)  DEFAULT NULL COMMENT '身份证号码',
                                           `rec_status` varchar(255) NULL DEFAULT 'A',
                                           `status` int NULL DEFAULT 0 COMMENT '是否禁用，0否，1是' ,
                                           `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                           `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                           PRIMARY KEY (`id`),
                                           UNIQUE INDEX `id_card_index`(`id_card`, `rec_status`) USING BTREE

);

INSERT INTO jy_platform (id,platform_name,platform_address ) values (1,"江门公安",1);


CREATE TABLE `jy_platform_user_wait`  (
                                          `id` int NOT NULL AUTO_INCREMENT,
                                          `name` varchar(255)  NULL DEFAULT NULL,
                                          `platform_id` int NULL DEFAULT NULL,
                                          `rec_status` varchar(255) NULL DEFAULT 'A',
                                          `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                                          `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                          `id_card` varchar(255) NULL DEFAULT NULL,
                                          PRIMARY KEY (`id`) USING BTREE,
                                          UNIQUE INDEX `id_card_index`(`id_card`, `rec_status`) USING BTREE
);


DELETE FROM jy_user WHERE rec_status != 'A';

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD COLUMN `phone` varchar(255)  DEFAULT NULL COMMENT '手机号码' AFTER `status`;
    ADD COLUMN `id_card` varchar(255)  DEFAULT NULL COMMENT '身份证号码' AFTER `phone`;
    ADD COLUMN `is_jm` int NULL DEFAULT 1 COMMENT '0否，1是'  AFTER `id_card`;
    ADD COLUMN `platform_id` int NULL AFTER `is_jm`;



update jy_user set platform_id = 1 ;


ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `ry_id_index`(`ry_id`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `ry_no_index`(`ry_no`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `phone_index`(`phone`, `rec_status`) USING HASH;

ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD UNIQUE INDEX `id_card_index`(`id_card`, `rec_status`) USING HASH;


DELETE FROM sys_user WHERE rec_status != 'A';

ALTER TABLE `4dkankan_v4`.`sys_user`
    ADD UNIQUE INDEX `user_name_index`(`user_name`, `rec_status`) USING HASH;

DELETE FROM t_user WHERE rec_status != 'A';

ALTER TABLE `4dkankan_v4`.`t_user`
    ADD UNIQUE INDEX `user_name_index`(`user_name`, `rec_status`) USING HASH;