Home Verkennen Help
Registreren Inloggen
CQ_JD
/
light-application
2
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: a3110a8a46
Aftakkingen Labels
light-applicati...
/
light-application-server
/
sql
/
sys.sql

sys.sql 19 KB
Geschiedenis Ruwe

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168 
  1. SET NAMES utf8mb4;
    2. 

  2. SET
    3. 

  3. FOREIGN_KEY_CHECKS = 0;
    4. 

  4. 

  5. DROP TABLE IF EXISTS `sys_menu`;
    6. 

  6. CREATE TABLE `sys_menu`
    7. 

  7. (
    8. 

  8.     `id`        bigint(20) NOT NULL AUTO_INCREMENT,
    9. 

  9.     `parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
    10. 

  10.     `name`      varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    11. 

  11.     `path`      varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单URL',
    12. 

  12.     `perms`     varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
    13. 

  13.     `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    14. 

  14.     `type`      int(5) NOT NULL COMMENT '类型     0：目录   1：菜单   2：按钮',
    15. 

  15.     `icon`      varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
    16. 

  16.     `orderNum`  int(11) NULL DEFAULT NULL COMMENT '排序',
    17. 

  17.     `created`   datetime                                               NOT NULL,
    18. 

  18.     `updated`   datetime NULL DEFAULT NULL,
    19. 

  19.     `statu`     int(5) NOT NULL,
    20. 

  20.     PRIMARY KEY (`id`) USING BTREE,
    21. 

  21.     UNIQUE INDEX `name`(`name`) USING BTREE
    22. 

  22. ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '菜单表';
    23. 

  23. 

  24. DROP TABLE IF EXISTS `sys_role`;
    25. 

  25. CREATE TABLE `sys_role`
    26. 

  26. (
    27. 

  27.     `id`      bigint(20) NOT NULL AUTO_INCREMENT,
    28. 

  28.     `name`    varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
    29. 

  29.     `code`    varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编码',
    30. 

  30.     `remark`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    31. 

  31.     `created` datetime NULL DEFAULT NULL,
    32. 

  32.     `updated` datetime NULL DEFAULT NULL,
    33. 

  33.     `statu`   int(5) NOT NULL,
    34. 

  34.     PRIMARY KEY (`id`) USING BTREE,
    35. 

  35.     UNIQUE INDEX `name`(`name`) USING BTREE,
    36. 

  36.     UNIQUE INDEX `code`(`code`) USING BTREE
    37. 

  37. ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '角色表';
    38. 

  38. 

  39. DROP TABLE IF EXISTS `sys_role_menu`;
    40. 

  40. CREATE TABLE `sys_role_menu`
    41. 

  41. (
    42. 

  42.     `id`      bigint(20) NOT NULL AUTO_INCREMENT,
    43. 

  43.     `role_id` bigint(20) NOT NULL,
    44. 

  44.     `menu_id` bigint(20) NOT NULL,
    45. 

  45.     PRIMARY KEY (`id`) USING BTREE
    46. 

  46. ) ENGINE = InnoDB AUTO_INCREMENT = 162 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT '角色&菜单关联表';
    47. 

  47. 

  48. 

  49. 

  50. DROP TABLE IF EXISTS `sys_user`;
    51. 

  51. CREATE TABLE `sys_user`
    52. 

  52. (
    53. 

  53.     `id`            bigint(20) NOT NULL AUTO_INCREMENT,
    54. 

  54.     `username`      varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称(登录账号)',
    55. 

  55.     `username_show` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称(显示名称)',
    56. 

  56.     `password`      varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
    57. 

  57.     `avatar`        varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '系统头像',
    58. 

  58.     `email`         varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    59. 

  59.     `created`       datetime NULL DEFAULT NULL,
    60. 

  60.     `updated`       datetime NULL DEFAULT NULL,
    61. 

  61.     `last_login`    datetime NULL DEFAULT NULL COMMENT '上次登录时间',
    62. 

  62.     `statu`         int(5) NOT NULL,
    63. 

  63.     `phone`         varchar(16)   DEFAULT NULL COMMENT '手机号',
    64. 

  64.     `open_id`       varchar(256)  DEFAULT NULL COMMENT '普通用户的标识，对当前开发者帐号唯一',
    65. 

  65.     `nick_name`     varchar(256)  DEFAULT NULL COMMENT '普通用户昵称',
    66. 

  66.     `sex`           varchar(8)    DEFAULT NULL COMMENT '普通用户性别，1为男性，2为女性',
    67. 

  67.     `province`      varchar(256)  DEFAULT NULL COMMENT '普通用户个人资料填写的省份',
    68. 

  68.     `city`          varchar(256)  DEFAULT NULL COMMENT '普通用户个人资料填写的城市',
    69. 

  69.     `country`       varchar(256)  DEFAULT NULL COMMENT '国家，如中国为CN',
    70. 

  70.     `head_img_url`  varchar(1024) DEFAULT NULL COMMENT '用户头像，最后一个数值代表正方形头像大小（有0、46、64、96、132数值可选，0代表640*640正方形头像），用户没有头像时该项为空',
    71. 

  71.     `union_id`      varchar(256)  DEFAULT NULL COMMENT '用户统一标识。针对一个微信开放平台帐号下的应用，同一用户的unionid是唯一的。',
    72. 

  72.     PRIMARY KEY (`id`) USING BTREE,
    73. 

  73.     UNIQUE INDEX `UK_USERNAME`(`username`) USING BTREE,
    74. 

  74.     UNIQUE INDEX `PHONE`(`phone`) USING BTREE
    75. 

  75. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic COMMENT '用户表';
    76. 

  76. 

  77. DROP TABLE IF EXISTS `sys_user_role`;
    78. 

  78. CREATE TABLE `sys_user_role`
    79. 

  79. (
    80. 

  80.     `id`      bigint(20) NOT NULL AUTO_INCREMENT,
    81. 

  81.     `user_id` bigint(20) NOT NULL,
    82. 

  82.     `role_id` bigint(20) NOT NULL,
    83. 

  83.     PRIMARY KEY (`id`) USING BTREE
    84. 

  84. ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT '用户&角色关联表';
    85. 

  85. 

  86. SET
    87. 

  87. FOREIGN_KEY_CHECKS = 1;
    88. 

  88. 

  89. #菜单基础数据
    90. 

  90. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('1', '0', '系统管理', '', 'sys:manage', '', '0', 'el-icon-s-operation', '1', '2021-01-15 18:58:18', '2022-01-19 23:03:35', '1');
    91. 

  91. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('2', '1', '用户管理', '/sys/users', 'sys:user:list', 'sys/User', '1', 'el-icon-s-custom', '1', '2021-01-15 19:03:45', '2022-04-09 03:35:14', '1');
    92. 

  92. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('3', '1', '角色管理', '/sys/roles', 'sys:role:list', 'sys/Role', '1', 'el-icon-rank', '2', '2021-01-15 19:03:45', '2021-01-15 19:03:48', '1');
    93. 

  93. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('4', '1', '菜单管理', '/sys/menus', 'sys:menu:list', 'sys/Menu', '1', 'el-icon-menu', '3', '2021-01-15 19:03:45', '2021-01-15 19:03:48', '1');
    94. 

  94. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('5', '3', '添加角色', '', 'sys:role:save', '', '2', '', '1', '2021-01-15 23:02:25', '2022-04-09 03:18:40', '1');
    95. 

  95. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('6', '2', '添加用户', NULL, 'sys:user:save', NULL, '2', NULL, '1', '2021-01-17 21:48:32', NULL, '1');
    96. 

  96. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('7', '2', '修改用户', NULL, 'sys:user:update', NULL, '2', NULL, '2', '2021-01-17 21:49:03', '2021-01-17 21:53:04', '1');
    97. 

  97. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('8', '2', '删除用户', NULL, 'sys:user:delete', NULL, '2', NULL, '3', '2021-01-17 21:49:21', NULL, '1');
    98. 

  98. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('9', '2', '分配角色', NULL, 'sys:user:role', NULL, '2', NULL, '4', '2021-01-17 21:49:58', NULL, '1');
    99. 

  99. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('10', '2', '重置密码', NULL, 'sys:user:repass', NULL, '2', NULL, '5', '2021-01-17 21:50:36', NULL, '1');
    100. 

  100. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('11', '3', '修改角色', NULL, 'sys:role:update', NULL, '2', NULL, '2', '2021-01-17 21:51:14', NULL, '1');
    101. 

  101. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('12', '3', '删除角色', NULL, 'sys:role:delete', NULL, '2', NULL, '3', '2021-01-17 21:51:39', NULL, '1');
    102. 

  102. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('13', '3', '分配权限', NULL, 'sys:role:perm', NULL, '2', NULL, '5', '2021-01-17 21:52:02', '2022-01-19 21:38:53', '1');
    103. 

  103. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('14', '4', '添加菜单', NULL, 'sys:menu:save', NULL, '2', NULL, '1', '2021-01-17 21:53:53', '2021-01-17 21:55:28', '1');
    104. 

  104. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('15', '4', '修改菜单', NULL, 'sys:menu:update', NULL, '2', NULL, '2', '2021-01-17 21:56:12', '2022-01-19 21:18:49', '1');
    105. 

  105. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('16', '4', '删除菜单', NULL, 'sys:menu:delete', NULL, '2', NULL, '3', '2021-01-17 21:56:36', NULL, '1');
    106. 

  106. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('17', '0', '业务管理', NULL, 'biz:manage', NULL, '0', 'el-icon-s-operation', '2', '2022-04-11 16:30:03', NULL, '1');
    107. 

  107. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('18', '17', '会议管理', '/page/meetingManage', 'biz:meeting:list', 'page/meetingManage', '1', NULL, '1', '2022-04-11 16:33:29', '2022-04-20 16:09:00', '1');
    108. 

  108. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('19', '17', '巡检项目管理', '/page/inspectionProjectManage', 'biz:inspectionProject', 'page/inspectionProjectManage', '1', NULL, '3', '2022-04-11 16:58:18', '2022-04-20 16:09:44', '1');
    109. 

  109. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('20', '17', '巡检记录管理', '/page/inspectionRecord', 'biz:inspectionRecord:list', 'page/inspectionRecord', '1', NULL, '4', '2022-04-11 18:22:02', '2022-04-20 16:10:04', '1');
    110. 

  110. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('21', '17', '公告管理', '/page/noticeManage', 'biz:notice:list', 'page/noticeManage', '1', NULL, '5', '2022-04-11 19:18:38', '2022-04-20 16:10:15', '1');
    111. 

  111. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('22', '17', '群聊管理', '/page/groupManage', 'biz:group:list', 'page/groupManage', '1', NULL, '6', '2022-04-12 09:34:42', '2022-04-20 16:10:21', '1');
    112. 

  112. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('23', '22', '新增群聊', NULL, 'biz:group:save', NULL, '2', NULL, NULL, '2022-04-14 15:24:12', NULL, '1');
    113. 

  113. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('24', '22', '编辑群聊', NULL, 'biz:group:update', NULL, '2', NULL, NULL, '2022-04-14 15:41:39', NULL, '1');
    114. 

  114. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('25', '22', '删除群聊', NULL, 'biz:group:delete', NULL, '2', NULL, NULL, '2022-04-14 15:42:36', NULL, '1');
    115. 

  115. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('26', '22', '管理群成员', NULL, 'biz:group:manageUser', NULL, '2', NULL, NULL, '2022-04-14 15:42:56', NULL, '1');
    116. 

  116. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('27', '17', '巡检模板管理', '/page/inspectionTemplateManage', 'biz:inspectionTemplateManage:list', 'page/inspectionTemplateManage', '1', NULL, '2', '2022-04-20 13:47:02', '2022-04-20 16:09:31', '1');
    117. 

  117. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('28', '17', '故障处理', '/page/faultHandlingManage', 'biz:faultHandling:list', 'page/faultHandlingManage', '1', NULL, '8', '2022-04-29 10:32:29', NULL, '1');
    118. 

  118. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('29', '17', '二维码管理', '/page/qrcodeShowConfig', 'qrcode:list', 'page/qrcodeShowConfig', '1', NULL, '9', '2022-05-07 11:12:21', NULL, '1');
    119. 

  119. INSERT INTO `light_application_db`.`sys_menu` (`id`, `parent_id`, `name`, `path`, `perms`, `component`, `type`, `icon`, `orderNum`, `created`, `updated`, `statu`) VALUES ('30', '17', '配置管理', '/page/configManage', 'biz:config:list', 'page/configManage', 1, NULL, 10, '2022-05-13 14:26:04', NULL, 1);
    120. 

  120. 

  121. 

  122. #角色基础数据
    123. 

  123. INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('1', '工作人员', 'ADMIN', '工作人员，默认最高权限', '2021-01-04 10:09:14', '2022-04-21 10:49:26', '1');
    124. 

  124. INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('2', '运维人员', 'OPERATION', '运维人员', '2021-01-16 13:29:03', '2022-04-21 10:49:10', '1');
    125. 

  125. INSERT INTO `light_application_db`.`sys_role` (`id`, `name`, `code`, `remark`, `created`, `updated`, `statu`) VALUES ('3', '来宾', 'GUEST', '来宾角色', '2022-04-21 10:48:04', '2022-04-21 10:48:07', '1');
    126. 

  126. 

  127. 

  128. #用户基础数据
    129. 

  129. INSERT INTO `light_application_db`.`sys_user` (`id`, `username`, `username_show`, `password`, `avatar`, `email`, `created`, `updated`, `last_login`, `statu`, `phone`, `open_id`, `nick_name`, `sex`, `province`, `city`, `country`, `head_img_url`, `union_id`) VALUES ('1', 'admin', NULL, '$2a$10$yc0TxjbAanMGJuoJ6ItI2OjcTn2U10GHsmOW7HLNQcLpf5ulbXDLq', 'https://blog20211013.oss-cn-shenzhen.aliyuncs.com/%E6%9C%BA%E5%99%A8%E4%BA%BA.png?versionId=CAEQMxiBgIC1geHI8xciIGI3NDY5NjRiMjExYTQxMmI5NTRlN2FlZGE4Yjc0ZTAx', '1231@qq.com', '2021-01-12 22:13:53', '2022-04-09 02:32:20', '2020-12-30 08:38:37', '1', NULL, NULL, NULL, NULL, NULL, '广州', NULL, NULL, NULL);
    130. 

  130. INSERT INTO `light_application_db`.`sys_user` (`id`, `username`, `username_show`, `password`, `avatar`, `email`, `created`, `updated`, `last_login`, `statu`, `phone`, `open_id`, `nick_name`, `sex`, `province`, `city`, `country`, `head_img_url`, `union_id`) VALUES ('2', 'test', 'mengchen', '$2a$10$ip1K.fCDAWOQVJO0kqgvGO32Vj.ferpGZWndbTO928m8vEYm4cBvq', 'https://blog20211013.oss-cn-shenzhen.aliyuncs.com/%E6%9C%BA%E5%99%A8%E4%BA%BA%20(1).png?versionId=CAEQMxiBgIC5geHI8xciIGMxYjNlYWRhNTBmMzQxZTlhM2VhOTAxMTI3ODI1ZjM4', '953071241@qq.com', '2022-04-09 01:34:19', '2022-04-28 14:46:52', NULL, '1', '15736203112', NULL, 'mengchen', NULL, NULL, NULL, NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/vbzMORicKk5iaABUQmkPAf1Xn74ZkY3y5m7MicHUHhSnzfwUSl7Op2M0XJD6h3r1aHjcVCXsuLIQ9GHOXnEsHVKpw/132', NULL);
    131. 

  131. 

  132. #用户&角色关联数据
    133. 

  133. INSERT INTO `light_application_db`.`sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('1', '1', '1');
    134. 

  134. INSERT INTO `light_application_db`.`sys_user_role` (`id`, `user_id`, `role_id`) VALUES ('2', '2', '2');
    135. 

  135. 

  136. #角色&菜单关联数据
    137. 

  137. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (1, 1, 1);
    138. 

  138. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (2, 1, 2);
    139. 

  139. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3, 1, 6);
    140. 

  140. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (4, 1, 7);
    141. 

  141. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (5, 1, 8);
    142. 

  142. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (6, 1, 9);
    143. 

  143. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (7, 1, 10);
    144. 

  144. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (8, 1, 3);
    145. 

  145. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (9, 1, 5);
    146. 

  146. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (10, 1, 11);
    147. 

  147. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (11, 1, 12);
    148. 

  148. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (12, 1, 13);
    149. 

  149. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (13, 1, 4);
    150. 

  150. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (14, 1, 14);
    151. 

  151. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (15, 1, 15);
    152. 

  152. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (16, 1, 16);
    153. 

  153. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (17, 1, 17);
    154. 

  154. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (18, 1, 18);
    155. 

  155. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (19, 1, 27);
    156. 

  156. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (20, 1, 19);
    157. 

  157. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (21, 1, 20);
    158. 

  158. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (22, 1, 21);
    159. 

  159. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (23, 1, 22);
    160. 

  160. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (24, 1, 23);
    161. 

  161. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (25, 1, 24);
    162. 

  162. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (26, 1, 25);
    163. 

  163. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (27, 1, 26);
    164. 

  164. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (28, 1, 28);
    165. 

  165. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (29, 1, 29);
    166. 

  166. INSERT INTO `light_application_db`.`sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (30, 1, 30);
    167. 

  167. 

  168.