167 lines
6.9 KiB
SQL
167 lines
6.9 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 远程
|
|
Source Server Type : MySQL
|
|
Source Server Version : 50744 (5.7.44)
|
|
Source Host : 8.137.112.156:3307
|
|
Source Schema : crm
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 50744 (5.7.44)
|
|
File Encoding : 65001
|
|
|
|
Date: 18/09/2024 15:04:51
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for sys_roles_menus
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `sys_roles_menus`;
|
|
CREATE TABLE `sys_roles_menus` (
|
|
`menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
|
|
`role_id` bigint(20) NOT NULL COMMENT '角色ID',
|
|
PRIMARY KEY (`menu_id`, `role_id`) USING BTREE,
|
|
INDEX `FKcngg2qadojhi3a651a5adkvbq`(`role_id`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '角色菜单关联' ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of sys_roles_menus
|
|
-- ----------------------------
|
|
INSERT INTO `sys_roles_menus` VALUES (1, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (2, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (3, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (5, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (6, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (7, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (9, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (28, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (32, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (35, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (37, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (39, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (41, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (44, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (45, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (46, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (48, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (49, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (50, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (52, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (53, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (54, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (56, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (57, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (58, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (60, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (61, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (62, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (64, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (65, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (66, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (73, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (74, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (75, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (77, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (78, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (79, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (80, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (82, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (102, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (103, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (104, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (105, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (106, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (107, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (108, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (109, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (110, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (111, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (112, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (113, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (114, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (116, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (117, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (118, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (119, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (121, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (122, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (123, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (124, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (125, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (126, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (127, 1);
|
|
INSERT INTO `sys_roles_menus` VALUES (1, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (2, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (3, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (6, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (7, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (9, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (10, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (11, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (14, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (15, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (19, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (27, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (30, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (32, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (33, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (34, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (36, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (48, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (49, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (50, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (80, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (82, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (83, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (116, 2);
|
|
INSERT INTO `sys_roles_menus` VALUES (1, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (2, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (6, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (7, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (9, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (10, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (11, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (15, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (21, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (22, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (23, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (24, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (27, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (32, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (33, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (34, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (37, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (41, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (44, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (46, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (60, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (61, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (62, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (80, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (83, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (90, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (92, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (93, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (94, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (97, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (98, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (102, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (103, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (104, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (105, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (106, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (107, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (108, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (109, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (110, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (111, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (112, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (113, 3);
|
|
INSERT INTO `sys_roles_menus` VALUES (114, 3);
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|