Página inicial Explorar Ajuda
Registrar Entrar
zk1006
/
cc
1
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: e56101c33e
Branches Tags
cc
/
QMPlusServer
/
db
/
qmplus.sql

qmplus.sql 22 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : qmplus
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50644
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : qmplus
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50644
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 09/10/2019 18:28:48
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for api_authorities
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `api_authorities`;
    24. 

  24. CREATE TABLE `api_authorities`  (
    25. 

  25.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    26. 

  26.   `created_at` timestamp(0) NULL DEFAULT NULL,
    27. 

  27.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    28. 

  28.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    29. 

  29.   `authority_id` int(10) UNSIGNED NULL DEFAULT NULL,
    30. 

  30.   `api_id` int(10) UNSIGNED NULL DEFAULT NULL,
    31. 

  31.   PRIMARY KEY (`id`) USING BTREE,
    32. 

  32.   INDEX `idx_api_authorities_deleted_at`(`deleted_at`) USING BTREE
    33. 

  33. ) ENGINE = InnoDB AUTO_INCREMENT = 185 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    34. 

  34. 

  35. -- ----------------------------
    36. 

  36. -- Records of api_authorities
    37. 

  37. -- ----------------------------
    38. 

  38. INSERT INTO `api_authorities` VALUES (72, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 1);
    39. 

  39. INSERT INTO `api_authorities` VALUES (73, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 4);
    40. 

  40. INSERT INTO `api_authorities` VALUES (74, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 5);
    41. 

  41. INSERT INTO `api_authorities` VALUES (75, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 6);
    42. 

  42. INSERT INTO `api_authorities` VALUES (76, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 14);
    43. 

  43. INSERT INTO `api_authorities` VALUES (77, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 15);
    44. 

  44. INSERT INTO `api_authorities` VALUES (78, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 17);
    45. 

  45. INSERT INTO `api_authorities` VALUES (79, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 23);
    46. 

  46. INSERT INTO `api_authorities` VALUES (80, '2019-09-30 15:34:19', '2019-09-30 15:34:19', NULL, 9528, 24);
    47. 

  47. INSERT INTO `api_authorities` VALUES (159, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 1);
    48. 

  48. INSERT INTO `api_authorities` VALUES (160, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 2);
    49. 

  49. INSERT INTO `api_authorities` VALUES (161, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 3);
    50. 

  50. INSERT INTO `api_authorities` VALUES (162, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 4);
    51. 

  51. INSERT INTO `api_authorities` VALUES (163, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 5);
    52. 

  52. INSERT INTO `api_authorities` VALUES (164, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 6);
    53. 

  53. INSERT INTO `api_authorities` VALUES (165, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 7);
    54. 

  54. INSERT INTO `api_authorities` VALUES (166, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 8);
    55. 

  55. INSERT INTO `api_authorities` VALUES (167, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 9);
    56. 

  56. INSERT INTO `api_authorities` VALUES (168, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 10);
    57. 

  57. INSERT INTO `api_authorities` VALUES (169, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 28);
    58. 

  58. INSERT INTO `api_authorities` VALUES (170, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 11);
    59. 

  59. INSERT INTO `api_authorities` VALUES (171, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 12);
    60. 

  60. INSERT INTO `api_authorities` VALUES (172, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 13);
    61. 

  61. INSERT INTO `api_authorities` VALUES (173, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 14);
    62. 

  62. INSERT INTO `api_authorities` VALUES (174, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 15);
    63. 

  63. INSERT INTO `api_authorities` VALUES (175, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 16);
    64. 

  64. INSERT INTO `api_authorities` VALUES (176, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 17);
    65. 

  65. INSERT INTO `api_authorities` VALUES (177, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 18);
    66. 

  66. INSERT INTO `api_authorities` VALUES (178, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 19);
    67. 

  67. INSERT INTO `api_authorities` VALUES (179, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 20);
    68. 

  68. INSERT INTO `api_authorities` VALUES (180, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 21);
    69. 

  69. INSERT INTO `api_authorities` VALUES (181, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 22);
    70. 

  70. INSERT INTO `api_authorities` VALUES (182, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 23);
    71. 

  71. INSERT INTO `api_authorities` VALUES (183, '2019-10-09 15:15:27', '2019-10-09 15:15:27', NULL, 888, 24);
    72. 

  72. 

  73. -- ----------------------------
    74. 

  74. -- Table structure for apis
    75. 

  75. -- ----------------------------
    76. 

  76. DROP TABLE IF EXISTS `apis`;
    77. 

  77. CREATE TABLE `apis`  (
    78. 

  78.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    79. 

  79.   `created_at` timestamp(0) NULL DEFAULT NULL,
    80. 

  80.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    81. 

  81.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    82. 

  82.   `authority_id` int(10) UNSIGNED NULL DEFAULT NULL,
    83. 

  83.   `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    84. 

  84.   `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    85. 

  85.   `group` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    86. 

  86.   PRIMARY KEY (`id`) USING BTREE,
    87. 

  87.   INDEX `idx_apis_deleted_at`(`deleted_at`) USING BTREE
    88. 

  88. ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    89. 

  89. 

  90. -- ----------------------------
    91. 

  91. -- Records of apis
    92. 

  92. -- ----------------------------
    93. 

  93. INSERT INTO `apis` VALUES (1, '2019-09-28 11:23:49', '2019-09-28 17:06:16', NULL, NULL, '/base/login', '用户登录', 'base');
    94. 

  94. INSERT INTO `apis` VALUES (2, '2019-09-28 11:32:46', '2019-09-28 17:06:11', NULL, NULL, '/base/regist', '用户注册', 'base');
    95. 

  95. INSERT INTO `apis` VALUES (3, '2019-09-28 11:33:41', '2019-09-28 17:06:04', NULL, NULL, '/api/createApi', '创建api', 'api');
    96. 

  96. INSERT INTO `apis` VALUES (4, '2019-09-28 14:09:04', '2019-09-28 17:05:59', NULL, NULL, '/api/getApiList', '获取api列表', 'api');
    97. 

  97. INSERT INTO `apis` VALUES (5, '2019-09-28 14:15:50', '2019-09-28 17:05:53', NULL, NULL, '/api/getApiById', '获取api详细信息', 'api');
    98. 

  98. INSERT INTO `apis` VALUES (6, '2019-09-28 14:19:08', '2019-09-28 17:05:48', NULL, NULL, '/api/setAuthAndApi', '设置api和角色关系', 'api');
    99. 

  99. INSERT INTO `apis` VALUES (7, '2019-09-28 14:19:26', '2019-09-28 17:05:44', NULL, NULL, '/api/deleteApi', '删除Api', 'api');
    100. 

  100. INSERT INTO `apis` VALUES (8, '2019-09-28 14:19:48', '2019-09-28 17:05:39', NULL, NULL, '/api/updataApi', '更新Api', 'api');
    101. 

  101. INSERT INTO `apis` VALUES (9, '2019-09-30 15:04:55', '2019-09-30 15:04:55', NULL, NULL, '/api/getAuthAndApi', '获取api和角色关系', 'api');
    102. 

  102. INSERT INTO `apis` VALUES (10, '2019-09-30 15:05:38', '2019-09-30 15:05:38', NULL, NULL, '/api/getAllApis', '获取所有api', 'api');
    103. 

  103. INSERT INTO `apis` VALUES (11, '2019-09-30 15:23:09', '2019-09-30 15:23:09', NULL, NULL, '/authority/createAuthority', '创建角色', 'authority');
    104. 

  104. INSERT INTO `apis` VALUES (12, '2019-09-30 15:23:33', '2019-09-30 15:23:33', NULL, NULL, '/authority/deleteAuthority', '删除角色', 'authority');
    105. 

  105. INSERT INTO `apis` VALUES (13, '2019-09-30 15:23:57', '2019-09-30 15:23:57', NULL, NULL, '/authority/getAuthorityList', '获取角色列表', 'authority');
    106. 

  106. INSERT INTO `apis` VALUES (14, '2019-09-30 15:24:20', '2019-09-30 15:24:20', NULL, NULL, '/menu/getMenu', '获取菜单树', 'menu');
    107. 

  107. INSERT INTO `apis` VALUES (15, '2019-09-30 15:24:50', '2019-09-30 15:24:50', NULL, NULL, '/menu/getMenuList', '分页获取基础menu列表', 'menu');
    108. 

  108. INSERT INTO `apis` VALUES (16, '2019-09-30 15:25:07', '2019-09-30 15:25:07', NULL, NULL, '/menu/addBaseMenu', '新增菜单', 'menu');
    109. 

  109. INSERT INTO `apis` VALUES (17, '2019-09-30 15:25:25', '2019-09-30 15:25:25', NULL, NULL, '/menu/getBaseMenuTree', '获取用户动态路由', 'menu');
    110. 

  110. INSERT INTO `apis` VALUES (18, '2019-09-30 15:25:53', '2019-09-30 15:25:53', NULL, NULL, '/menu/addMenuAuthority', '增加menu和角色关联关系', 'menu');
    111. 

  111. INSERT INTO `apis` VALUES (19, '2019-09-30 15:26:20', '2019-09-30 15:26:20', NULL, NULL, '/menu/getMenuAuthority', '获取指定角色menu', 'menu');
    112. 

  112. INSERT INTO `apis` VALUES (20, '2019-09-30 15:26:43', '2019-09-30 15:26:43', NULL, NULL, '/menu/deleteBaseMenu', '删除菜单', 'menu');
    113. 

  113. INSERT INTO `apis` VALUES (21, '2019-09-30 15:28:05', '2019-09-30 15:28:05', NULL, NULL, '/menu/updataBaseMenu', '更新菜单', 'menu');
    114. 

  114. INSERT INTO `apis` VALUES (22, '2019-09-30 15:28:21', '2019-09-30 15:28:21', NULL, NULL, '/menu/getBaseMenuById', '根据id获取菜单', 'menu');
    115. 

  115. INSERT INTO `apis` VALUES (23, '2019-09-30 15:29:19', '2019-09-30 15:29:19', NULL, NULL, '/user/changePassword', '修改密码', 'user');
    116. 

  116. INSERT INTO `apis` VALUES (24, '2019-09-30 15:29:33', '2019-09-30 15:29:33', NULL, NULL, '/user/uploadHeaderImg', '上传头像', 'user');
    117. 

  117. INSERT INTO `apis` VALUES (25, '2019-09-30 15:30:00', '2019-09-30 15:30:00', '2019-10-09 15:26:37', NULL, '/user/getInfoList', '分页获取用户列表', 'user');
    118. 

  118. INSERT INTO `apis` VALUES (28, '2019-10-09 15:15:17', '2019-10-09 15:17:07', NULL, NULL, '/user/getUserList', '获取用户列表', 'user');
    119. 

  119. 

  120. -- ----------------------------
    121. 

  121. -- Table structure for authorities
    122. 

  122. -- ----------------------------
    123. 

  123. DROP TABLE IF EXISTS `authorities`;
    124. 

  124. CREATE TABLE `authorities`  (
    125. 

  125.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    126. 

  126.   `created_at` timestamp(0) NULL DEFAULT NULL,
    127. 

  127.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    128. 

  128.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    129. 

  129.   `authority_id` int(10) UNSIGNED NOT NULL,
    130. 

  130.   `authority_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    131. 

  131.   PRIMARY KEY (`id`) USING BTREE,
    132. 

  132.   UNIQUE INDEX `authority_id`(`authority_id`) USING BTREE,
    133. 

  133.   INDEX `idx_authorities_deleted_at`(`deleted_at`) USING BTREE
    134. 

  134. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    135. 

  135. 

  136. -- ----------------------------
    137. 

  137. -- Records of authorities
    138. 

  138. -- ----------------------------
    139. 

  139. INSERT INTO `authorities` VALUES (1, '2019-09-08 16:18:31', '2019-09-08 16:18:31', '2019-09-18 22:10:26', 9527, '超超超级管理员');
    140. 

  140. INSERT INTO `authorities` VALUES (2, '2019-09-08 16:18:45', '2019-09-08 16:18:45', NULL, 888, '普通用户');
    141. 

  141. INSERT INTO `authorities` VALUES (3, '2019-09-18 22:20:28', '2019-09-18 22:20:28', '2019-09-18 22:25:22', 0, '测试角色');
    142. 

  142. INSERT INTO `authorities` VALUES (6, '2019-09-18 22:23:33', '2019-09-18 22:23:33', NULL, 9528, '测试角色');
    143. 

  143. INSERT INTO `authorities` VALUES (7, '2019-09-18 22:24:39', '2019-09-18 22:24:39', '2019-09-18 22:25:19', 9529, '测试角色');
    144. 

  144. INSERT INTO `authorities` VALUES (8, '2019-09-18 22:25:13', '2019-09-18 22:25:13', '2019-09-18 22:25:17', 9522, '测试角色');
    145. 

  145. 

  146. -- ----------------------------
    147. 

  147. -- Table structure for base_menus
    148. 

  148. -- ----------------------------
    149. 

  149. DROP TABLE IF EXISTS `base_menus`;
    150. 

  150. CREATE TABLE `base_menus`  (
    151. 

  151.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    152. 

  152.   `created_at` timestamp(0) NULL DEFAULT NULL,
    153. 

  153.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    154. 

  154.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    155. 

  155.   `menu_level` int(10) UNSIGNED NULL DEFAULT NULL,
    156. 

  156.   `parent_id` int(10) UNSIGNED NULL DEFAULT NULL,
    157. 

  157.   `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    158. 

  158.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    159. 

  159.   `hidden` tinyint(1) NULL DEFAULT NULL,
    160. 

  160.   `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    161. 

  161.   `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    162. 

  162.   `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    163. 

  163.   `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    164. 

  164.   PRIMARY KEY (`id`) USING BTREE,
    165. 

  165.   INDEX `idx_base_menus_deleted_at`(`deleted_at`) USING BTREE
    166. 

  166. ) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    167. 

  167. 

  168. -- ----------------------------
    169. 

  169. -- Records of base_menus
    170. 

  170. -- ----------------------------
    171. 

  171. INSERT INTO `base_menus` VALUES (1, '2019-09-19 22:05:18', '2019-09-19 22:05:18', NULL, 0, 0, 'dashbord', 'dashbord', 0, 'view/dashbord/index.vue', '仪表盘', 'setting', '仪表盘');
    172. 

  172. INSERT INTO `base_menus` VALUES (2, '2019-09-19 22:06:17', '2019-09-30 15:44:50', NULL, 0, 0, 'test', 'test', 0, 'view/test/index.vue', '测试菜单', 'info', '测试菜单');
    173. 

  173. INSERT INTO `base_menus` VALUES (3, '2019-09-19 22:06:38', '2019-09-19 22:06:38', NULL, 0, 0, 'admin', 'superAdmin', 0, 'view/superAdmin/index.vue', '超级管理员', 'user-solid', '超级管理员');
    174. 

  174. INSERT INTO `base_menus` VALUES (4, '2019-09-19 22:11:53', '2019-09-19 22:11:53', NULL, 0, 3, 'authority', 'authority', 0, 'view/superAdmin/authority/authority.vue', '角色管理', 's-custom', '角色管理');
    175. 

  175. INSERT INTO `base_menus` VALUES (5, '2019-09-19 22:13:18', '2019-09-19 22:13:18', NULL, 0, 3, 'menu', 'menu', 0, 'view/superAdmin/menu/menu.vue', '菜单管理', 's-order', '菜单管理');
    176. 

  176. INSERT INTO `base_menus` VALUES (6, '2019-09-19 22:13:36', '2019-09-19 22:13:36', NULL, 0, 3, 'api', 'api', 0, 'view/superAdmin/api/api.vue', 'api管理', 's-platform', 'api管理');
    177. 

  177. INSERT INTO `base_menus` VALUES (7, '2019-09-22 17:17:15', '2019-09-26 13:09:57', '2019-09-26 13:10:14', 0, 0, 'tttt22', '修改测试', 0, '', '修改测试', 'share', 'api管理');
    178. 

  178. INSERT INTO `base_menus` VALUES (8, '2019-09-26 17:17:48', '2019-09-26 17:18:46', '2019-09-26 17:19:23', 0, 0, 'ASDASDASD', 'tttTTT', 0, 'TTTT', 'TTT', 'TTT', 'TTT');
    179. 

  179. INSERT INTO `base_menus` VALUES (9, '2019-09-30 18:23:01', '2019-09-30 18:23:01', '2019-09-30 18:25:07', 0, 0, 't\'t', 'tttt', 0, 'tt', 'tt', 'tt', 'tt');
    180. 

  180. INSERT INTO `base_menus` VALUES (10, '2019-09-30 18:23:29', '2019-09-30 18:23:29', '2019-09-30 18:25:05', 0, 0, 'ttt', 'ttt', 0, 'ttt', 'ttt', 'ttt', 'ttt');
    181. 

  181. INSERT INTO `base_menus` VALUES (11, '2019-09-30 18:23:59', '2019-09-30 18:23:59', '2019-09-30 18:25:04', 0, 0, '11111111', '11111111111111', 0, '111111111', '1111111111', '11111111', '1111111111');
    182. 

  182. INSERT INTO `base_menus` VALUES (12, '2019-09-30 18:24:03', '2019-09-30 18:24:03', '2019-09-30 18:25:02', 0, 0, '22222', '11111111111111222222222222222222', 0, '11111111222222221', '1111111111222222222222222', '1111112222222211', '1111111111222222222222222');
    183. 

  183. INSERT INTO `base_menus` VALUES (13, '2019-09-30 18:24:11', '2019-09-30 18:24:11', '2019-09-30 18:25:13', 0, 0, '11114', '124124', 0, '1241', '124124', '214124', '124124');
    184. 

  184. INSERT INTO `base_menus` VALUES (14, '2019-09-30 18:24:19', '2019-09-30 18:24:19', '2019-09-30 18:25:12', 0, 0, '22222', '222', 0, '2222', '22', '222', '22');
    185. 

  185. INSERT INTO `base_menus` VALUES (15, '2019-09-30 18:24:22', '2019-09-30 18:24:22', '2019-09-30 18:25:10', 0, 0, '2222211', '22211', 0, '22221', '2211', '2221', '2211');
    186. 

  186. INSERT INTO `base_menus` VALUES (16, '2019-09-30 18:24:29', '2019-09-30 18:24:29', '2019-09-30 18:25:09', 0, 0, '3223123', '123123', 0, '123123', '123123', '21312323', '123123');
    187. 

  187. INSERT INTO `base_menus` VALUES (17, '2019-10-09 15:12:29', '2019-10-09 15:14:44', NULL, 0, 3, 'user', 'user', 0, 'view/superAdmin/user/user.vue', '用户管理', 'coordinate', '用户管理');
    188. 

  188. 

  189. -- ----------------------------
    190. 

  190. -- Table structure for menus
    191. 

  191. -- ----------------------------
    192. 

  192. DROP TABLE IF EXISTS `menus`;
    193. 

  193. CREATE TABLE `menus`  (
    194. 

  194.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    195. 

  195.   `created_at` timestamp(0) NULL DEFAULT NULL,
    196. 

  196.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    197. 

  197.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    198. 

  198.   `menu_level` int(10) UNSIGNED NULL DEFAULT NULL,
    199. 

  199.   `authority_id` int(10) UNSIGNED NULL DEFAULT NULL,
    200. 

  200.   `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    201. 

  201.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    202. 

  202.   `hidden` tinyint(1) NULL DEFAULT NULL,
    203. 

  203.   `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    204. 

  204.   `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    205. 

  205.   `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    206. 

  206.   `parent_id` int(10) UNSIGNED NULL DEFAULT NULL,
    207. 

  207.   `menu_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    208. 

  208.   `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    209. 

  209.   PRIMARY KEY (`id`) USING BTREE,
    210. 

  210.   INDEX `idx_menus_deleted_at`(`deleted_at`) USING BTREE
    211. 

  211. ) ENGINE = InnoDB AUTO_INCREMENT = 231 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    212. 

  212. 

  213. -- ----------------------------
    214. 

  214. -- Records of menus
    215. 

  215. -- ----------------------------
    216. 

  216. INSERT INTO `menus` VALUES (195, '2019-09-19 22:05:18', '2019-09-19 22:05:18', NULL, 0, 9528, 'dashbord', 'dashbord', 0, 'view/dashbord/index.vue', '仪表盘', 'setting', 0, '1', '仪表盘');
    217. 

  217. INSERT INTO `menus` VALUES (196, '2019-09-19 22:06:17', '2019-09-30 15:44:50', NULL, 0, 9528, 'test', 'test', 0, 'view/test/index.vue', '测试菜单', 'info', 0, '2', '测试菜单');
    218. 

  218. INSERT INTO `menus` VALUES (197, '2019-09-19 22:06:38', '2019-09-19 22:06:38', NULL, 0, 9528, 'admin', 'superAdmin', 0, 'view/superAdmin/index.vue', '超级管理员', 'user-solid', 0, '3', '超级管理员');
    219. 

  219. INSERT INTO `menus` VALUES (198, '2019-09-19 22:11:53', '2019-09-19 22:11:53', NULL, 0, 9528, 'authority', 'authority', 0, 'view/superAdmin/authority/authority.vue', '角色管理', 's-custom', 3, '4', '角色管理');
    220. 

  220. INSERT INTO `menus` VALUES (199, '2019-09-19 22:13:18', '2019-09-19 22:13:18', NULL, 0, 9528, 'menu', 'menu', 0, 'view/superAdmin/menu/menu.vue', '菜单管理', 's-order', 3, '5', '菜单管理');
    221. 

  221. INSERT INTO `menus` VALUES (224, '2019-09-19 22:05:18', '2019-09-19 22:05:18', NULL, 0, 888, 'dashbord', 'dashbord', 0, 'view/dashbord/index.vue', '仪表盘', 'setting', 0, '1', '仪表盘');
    222. 

  222. INSERT INTO `menus` VALUES (225, '2019-09-19 22:06:17', '2019-09-30 15:44:50', NULL, 0, 888, 'test', 'test', 0, 'view/test/index.vue', '测试菜单', 'info', 0, '2', '测试菜单');
    223. 

  223. INSERT INTO `menus` VALUES (226, '2019-09-19 22:06:38', '2019-09-19 22:06:38', NULL, 0, 888, 'admin', 'superAdmin', 0, 'view/superAdmin/index.vue', '超级管理员', 'user-solid', 0, '3', '超级管理员');
    224. 

  224. INSERT INTO `menus` VALUES (227, '2019-09-19 22:11:53', '2019-09-19 22:11:53', NULL, 0, 888, 'authority', 'authority', 0, 'view/superAdmin/authority/authority.vue', '角色管理', 's-custom', 3, '4', '角色管理');
    225. 

  225. INSERT INTO `menus` VALUES (228, '2019-09-19 22:13:18', '2019-09-19 22:13:18', NULL, 0, 888, 'menu', 'menu', 0, 'view/superAdmin/menu/menu.vue', '菜单管理', 's-order', 3, '5', '菜单管理');
    226. 

  226. INSERT INTO `menus` VALUES (229, '2019-09-19 22:13:36', '2019-09-19 22:13:36', NULL, 0, 888, 'api', 'api', 0, 'view/superAdmin/api/api.vue', 'api管理', 's-platform', 3, '6', 'api管理');
    227. 

  227. INSERT INTO `menus` VALUES (230, '2019-10-09 15:12:29', '2019-10-09 15:14:44', NULL, 0, 888, 'user', 'user', 0, 'view/superAdmin/user/user.vue', '用户管理', 'coordinate', 3, '17', '用户管理');
    228. 

  228. 

  229. -- ----------------------------
    230. 

  230. -- Table structure for users
    231. 

  231. -- ----------------------------
    232. 

  232. DROP TABLE IF EXISTS `users`;
    233. 

  233. CREATE TABLE `users`  (
    234. 

  234.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    235. 

  235.   `created_at` timestamp(0) NULL DEFAULT NULL,
    236. 

  236.   `updated_at` timestamp(0) NULL DEFAULT NULL,
    237. 

  237.   `deleted_at` timestamp(0) NULL DEFAULT NULL,
    238. 

  238.   `uuid` varbinary(255) NULL DEFAULT NULL,
    239. 

  239.   `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    240. 

  240.   `pass_word` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    241. 

  241.   `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'QMPlusUser',
    242. 

  242.   `header_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'http://www.henrongyi.top/avatar/lufu.jpg',
    243. 

  243.   `authority_id` double NULL DEFAULT 888,
    244. 

  244.   `authority_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    245. 

  245.   `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    246. 

  246.   `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    247. 

  247.   PRIMARY KEY (`id`) USING BTREE,
    248. 

  248.   INDEX `idx_users_deleted_at`(`deleted_at`) USING BTREE
    249. 

  249. ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
    250. 

  250. 

  251. -- ----------------------------
    252. 

  252. -- Records of users
    253. 

  253. -- ----------------------------
    254. 

  254. INSERT INTO `users` VALUES (10, '2019-09-13 17:23:46', '2019-09-13 17:23:46', NULL, 0x63653064363638352D633135662D343132362D613562342D383930626339643233353664, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, '303176530', '3ec063004a6f31642261936a379fde3d');
    255. 

  255. INSERT INTO `users` VALUES (11, '2019-09-13 17:27:29', '2019-09-13 17:27:29', NULL, 0x66643665663739622D393434632D343838382D383337372D616265326432363038383538, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, 'a303176530', '3ec063004a6f31642261936a379fde3d');
    256. 

  256. INSERT INTO `users` VALUES (12, '2019-09-13 17:28:56', '2019-09-13 17:28:56', NULL, 0x65373939636563362D346337662D343338632D383634372D376435633333393734353165, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, 'a30317465', '3ec063004a6f31642261936a379fde3d');
    257. 

  257. INSERT INTO `users` VALUES (13, '2019-09-13 17:29:26', '2019-09-13 17:29:26', NULL, 0x65653764353932322D323333312D343162632D393363322D613665366461306465343230, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, 'a30317465', '3ec063004a6f31642261936a379fde3d');
    258. 

  258. INSERT INTO `users` VALUES (14, '2019-09-13 17:29:28', '2019-09-13 17:29:28', NULL, 0x35623464333461322D343266352D343763352D613932642D613637616536643461643334, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, 'a30317465', '3ec063004a6f31642261936a379fde3d');
    259. 

  259. INSERT INTO `users` VALUES (15, '2019-09-13 17:31:16', '2019-09-13 17:31:16', NULL, 0x34306437393436612D363732382D346536662D396434302D313432356566653831363032, NULL, NULL, 'QMPlusUser', 'http://www.henrongyi.top/avatar/lufu.jpg', 888, NULL, 'a303146523', 'e10adc3949ba59abbe56e057f20f883e');
    260. 

  260. 

  261. SET FOREIGN_KEY_CHECKS = 1;
    262.