首页 仓库（发现） 帮助
登录
guorui
/
Ruoyi-Flask-admin
1
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: 4fa70d4029
分支列表 标签列表
Ruoyi-Flask-adm...
/
db.sql

db.sql 25 KB
文件历史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : localhost
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80029
    7. 

  7.  Source Host           : localhost:3306
    8. 

  8.  Source Schema         : authbase
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80029
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 23/05/2022 08:18:08
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

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

  21. -- Table structure for SYONLINE
    22. 

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

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

  24. CREATE TABLE `SYONLINE`  (
    25. 

  25.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    26. 

  26.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    27. 

  27.   `IP` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    28. 

  28.   `LOGINNAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    29. 

  29.   `TYPE` varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    30. 

  30.   PRIMARY KEY (`ID`) USING BTREE
    31. 

  31. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    32. 

  32. 

  33. -- ----------------------------
    34. 

  34. -- Records of SYONLINE
    35. 

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

  36. INSERT INTO `SYONLINE` VALUES ('0c69d762-af59-4f12-bd36-ea7b8af99e78', '2022-05-22 12:00:43', '127.0.0.1', 'admin', '1');
    37. 

  37. INSERT INTO `SYONLINE` VALUES ('0e7da881-7b39-45bd-bfec-41a568c4f9af', '2022-05-22 09:40:26', '127.0.0.1', 'admin', '0');
    38. 

  38. INSERT INTO `SYONLINE` VALUES ('0fa0908b-a9f3-4f01-9297-a124baa83755', '2022-05-18 16:01:37', '127.0.0.1', 'admin', '1');
    39. 

  39. INSERT INTO `SYONLINE` VALUES ('1655743a-c50c-49d2-bc1e-03be60fd7c12', '2022-05-22 09:42:21', '127.0.0.1', 'admin', '1');
    40. 

  40. INSERT INTO `SYONLINE` VALUES ('2db49057-349e-49d7-a42e-a09a2ec05a09', '2022-05-22 09:42:31', '127.0.0.1', 'admin', '0');
    41. 

  41. INSERT INTO `SYONLINE` VALUES ('2ec4552a-8e85-43f7-b80c-e7c770bffab3', '2022-05-22 09:41:31', '127.0.0.1', 'admin', '1');
    42. 

  42. INSERT INTO `SYONLINE` VALUES ('30196021-2423-458b-b72e-3db1fc959c79', '2022-05-14 20:36:36', '127.0.0.1', 'admin', '1');
    43. 

  43. INSERT INTO `SYONLINE` VALUES ('30602de4-33e7-48e6-baee-f8f6a573d508', '2022-05-22 09:40:41', '127.0.0.1', 'admin', '0');
    44. 

  44. INSERT INTO `SYONLINE` VALUES ('6ce4da2f-0833-40d3-bd8b-fe42146b05c6', '2022-05-15 18:16:59', '127.0.0.1', 'admin', '1');
    45. 

  45. INSERT INTO `SYONLINE` VALUES ('76071a92-e2fb-4c45-8a71-f44a70d0dd8e', '2022-05-22 09:22:26', '127.0.0.1', 'admin', '1');
    46. 

  46. INSERT INTO `SYONLINE` VALUES ('76c7109c-af8c-4375-bb65-0f17cd2446dd', '2022-05-22 09:23:30', '127.0.0.1', 'admin', '0');
    47. 

  47. INSERT INTO `SYONLINE` VALUES ('80de6227-9a7e-45c5-a093-ca4950a8fc7d', '2022-05-22 09:40:38', '127.0.0.1', 'admin', '1');
    48. 

  48. INSERT INTO `SYONLINE` VALUES ('8455c194-84aa-405b-b1d8-4ff6d2cb7d84', '2022-05-22 09:22:15', '127.0.0.1', 'admin', '0');
    49. 

  49. INSERT INTO `SYONLINE` VALUES ('8e13f90a-0875-4da7-863c-48dad3886415', '2022-05-22 09:23:20', '127.0.0.1', 'admin', '1');
    50. 

  50. INSERT INTO `SYONLINE` VALUES ('93bbb856-f242-46b4-b246-15e650bb78fb', '2022-05-22 09:41:42', '127.0.0.1', 'admin', '0');
    51. 

  51. INSERT INTO `SYONLINE` VALUES ('9a9f73b7-814c-40a2-ae7b-99c112c59068', '2022-05-22 09:40:51', '127.0.0.1', 'admin', '1');
    52. 

  52. INSERT INTO `SYONLINE` VALUES ('9d5178da-359a-4491-a053-ff78d24311e6', '2022-05-22 12:00:38', '127.0.0.1', 'admin', '0');
    53. 

  53. INSERT INTO `SYONLINE` VALUES ('afc2e04a-78a5-451f-9a1d-ce22d14b6478', '2022-05-21 08:58:47', '127.0.0.1', 'admin', '1');
    54. 

  54. INSERT INTO `SYONLINE` VALUES ('b07a8877-cb98-4e44-b03c-ecf77f6e3aa9', '2022-05-18 16:01:35', '127.0.0.1', 'admin', '0');
    55. 

  55. INSERT INTO `SYONLINE` VALUES ('badd62db-75f7-4c99-a649-548b18171d1d', '2022-05-22 09:40:16', '127.0.0.1', 'admin', '1');
    56. 

  56. INSERT INTO `SYONLINE` VALUES ('c409ede4-02b5-42e1-a56f-4c6ea5f38abe', '2022-05-22 09:43:23', '127.0.0.1', 'admin', '1');
    57. 

  57. INSERT INTO `SYONLINE` VALUES ('c741837f-da2a-4230-8b57-51914023dfa5', '2022-05-18 10:21:32', '127.0.0.1', 'admin', '1');
    58. 

  58. INSERT INTO `SYONLINE` VALUES ('cdaebb6f-64a4-45a9-98b1-7f7a27c049a7', '2022-05-22 09:40:51', '127.0.0.1', 'admin', '0');
    59. 

  59. INSERT INTO `SYONLINE` VALUES ('d1c21a0b-2387-48a5-98dc-9f7f59de5049', '2022-05-22 09:22:26', '127.0.0.1', 'admin', '0');
    60. 

  60. INSERT INTO `SYONLINE` VALUES ('de70466a-4441-4488-aa05-6b412782a562', '2022-05-22 09:39:46', '127.0.0.1', 'admin', '0');
    61. 

  61. INSERT INTO `SYONLINE` VALUES ('e5459bbe-aead-420f-a13b-b11e7a41d022', '2022-05-22 09:30:52', '127.0.0.1', 'admin', '1');
    62. 

  62. INSERT INTO `SYONLINE` VALUES ('e61373c3-4440-47f5-a57c-8a49a78b33ad', '2022-05-18 16:12:00', '127.0.0.1', 'admin', '0');
    63. 

  63. INSERT INTO `SYONLINE` VALUES ('f76feb30-30db-4bec-a0a0-b45b9da88550', '2022-05-18 16:12:02', '127.0.0.1', 'admin', '1');
    64. 

  64. 

  65. -- ----------------------------
    66. 

  66. -- Table structure for SYORGANIZATION
    67. 

  67. -- ----------------------------
    68. 

  68. DROP TABLE IF EXISTS `SYORGANIZATION`;
    69. 

  69. CREATE TABLE `SYORGANIZATION`  (
    70. 

  70.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    71. 

  71.   `ADDRESS` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    72. 

  72.   `CODE` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    73. 

  73.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    74. 

  74.   `ICONCLS` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    75. 

  75.   `NAME` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    76. 

  76.   `SEQ` int NULL DEFAULT NULL,
    77. 

  77.   `UPDATEDATETIME` datetime NULL DEFAULT NULL,
    78. 

  78.   `SYORGANIZATION_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    79. 

  79.   `LEADER` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
    80. 

  80.   `PHONE` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
    81. 

  81.   `EMAIL` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
    82. 

  82.   PRIMARY KEY (`ID`) USING BTREE,
    83. 

  83.   INDEX `FK_acf7qlb04quthktalwx8c7q69`(`SYORGANIZATION_ID`) USING BTREE,
    84. 

  84.   CONSTRAINT `FK_acf7qlb04quthktalwx8c7q69` FOREIGN KEY (`SYORGANIZATION_ID`) REFERENCES `SYORGANIZATION` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    85. 

  85. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    86. 

  86. 

  87. -- ----------------------------
    88. 

  88. -- Records of SYORGANIZATION
    89. 

  89. -- ----------------------------
    90. 

  90. INSERT INTO `SYORGANIZATION` VALUES ('0', NULL, NULL, '2016-11-28 10:34:54', 'ext-icon-bricks', '总部', 100, '2016-11-28 10:35:12', NULL, NULL, NULL, NULL);
    91. 

  91. INSERT INTO `SYORGANIZATION` VALUES ('5477d9a9-e41e-485f-bb08-697e8facef88', NULL, NULL, '2022-05-22 09:59:33', NULL, 'test', 2, '2022-05-22 11:28:57', '0', 'dd', '18905189016', 'ss@ada.com');
    92. 

  92. 

  93. -- ----------------------------
    94. 

  94. -- Table structure for SYORGANIZATION_SYRESOURCE
    95. 

  95. -- ----------------------------
    96. 

  96. DROP TABLE IF EXISTS `SYORGANIZATION_SYRESOURCE`;
    97. 

  97. CREATE TABLE `SYORGANIZATION_SYRESOURCE`  (
    98. 

  98.   `SYRESOURCE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    99. 

  99.   `SYORGANIZATION_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    100. 

  100.   PRIMARY KEY (`SYORGANIZATION_ID`, `SYRESOURCE_ID`) USING BTREE,
    101. 

  101.   INDEX `FK_acpjp8a7fjo0cnn02eb0ia6uf`(`SYORGANIZATION_ID`) USING BTREE,
    102. 

  102.   INDEX `FK_m4mfglk7odi78d8pk9pif44vc`(`SYRESOURCE_ID`) USING BTREE,
    103. 

  103.   CONSTRAINT `FK_acpjp8a7fjo0cnn02eb0ia6uf` FOREIGN KEY (`SYORGANIZATION_ID`) REFERENCES `SYORGANIZATION` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    104. 

  104.   CONSTRAINT `FK_m4mfglk7odi78d8pk9pif44vc` FOREIGN KEY (`SYRESOURCE_ID`) REFERENCES `SYRESOURCE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    105. 

  105. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    106. 

  106. 

  107. -- ----------------------------
    108. 

  108. -- Records of SYORGANIZATION_SYRESOURCE
    109. 

  109. -- ----------------------------
    110. 

  110. 

  111. -- ----------------------------
    112. 

  112. -- Table structure for SYRESOURCE
    113. 

  113. -- ----------------------------
    114. 

  114. DROP TABLE IF EXISTS `SYRESOURCE`;
    115. 

  115. CREATE TABLE `SYRESOURCE`  (
    116. 

  116.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    117. 

  117.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    118. 

  118.   `DESCRIPTION` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    119. 

  119.   `ICONCLS` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    120. 

  120.   `NAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    121. 

  121.   `SEQ` int NULL DEFAULT NULL,
    122. 

  122.   `TARGET` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    123. 

  123.   `UPDATEDATETIME` datetime NULL DEFAULT NULL,
    124. 

  124.   `PATH` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    125. 

  125.   `URL` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    126. 

  126.   `PERMS` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '权限标识',
    127. 

  127.   `SYRESOURCE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    128. 

  128.   `SYRESOURCETYPE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    129. 

  129.   PRIMARY KEY (`ID`) USING BTREE,
    130. 

  130.   INDEX `FK_n8kk2inhw4y4gax3nra2etfup`(`SYRESOURCE_ID`) USING BTREE,
    131. 

  131.   INDEX `FK_93qfpiiuk3rwb32gc5mcmmlgh`(`SYRESOURCETYPE_ID`) USING BTREE,
    132. 

  132.   CONSTRAINT `FK_93qfpiiuk3rwb32gc5mcmmlgh` FOREIGN KEY (`SYRESOURCETYPE_ID`) REFERENCES `SYRESOURCETYPE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    133. 

  133.   CONSTRAINT `FK_n8kk2inhw4y4gax3nra2etfup` FOREIGN KEY (`SYRESOURCE_ID`) REFERENCES `SYRESOURCE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    134. 

  134. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    135. 

  135. 

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

  137. -- Records of SYRESOURCE
    138. 

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

  139. INSERT INTO `SYRESOURCE` VALUES ('jgbj', '2015-08-25 10:34:53', '编辑机构', 'ext-icon-bullet_wrench', '编辑机构', 2, '', '2015-08-25 10:34:53', NULL, '/base/syorganization!update', 'system:dept:edit', 'jggl', '1');
    140. 

  140. INSERT INTO `SYRESOURCE` VALUES ('jgck', '2015-08-25 10:34:53', '查看机构', 'ext-icon-bullet_wrench', '查看机构', 4, '', '2015-08-25 10:34:53', NULL, '/base/syorganization!getById', 'system:dept:query', 'jggl', '1');
    141. 

  141. INSERT INTO `SYRESOURCE` VALUES ('jggl', '2015-08-25 10:34:53', '管理系统中用户的机构', 'tree', '机构管理', 3, '', '2015-08-25 10:34:53', 'dept', 'system/dept/index', 'system:dept:list', 'xtgl', '0');
    142. 

  142. INSERT INTO `SYRESOURCE` VALUES ('jglb', '2015-08-25 10:34:53', '查询机构列表', 'ext-icon-bullet_wrench', '机构列表', 0, '', '2016-11-28 14:09:52', NULL, '/base/syorganization!treeGrid', 'system:dept:list', 'jggl', '1');
    143. 

  143. INSERT INTO `SYRESOURCE` VALUES ('jgsc', '2015-08-25 10:34:53', '删除机构', 'ext-icon-bullet_wrench', '删除机构', 3, '', '2015-08-25 10:34:53', NULL, '/base/syorganization!delete', 'system:dept:remove', 'jggl', '1');
    144. 

  144. INSERT INTO `SYRESOURCE` VALUES ('jgsq', '2015-08-25 10:34:53', '机构授权', 'ext-icon-bullet_wrench', '机构授权', 5, '', '2015-08-25 10:34:53', NULL, '/base/syorganization!grant', NULL, 'jggl', '1');
    145. 

  145. INSERT INTO `SYRESOURCE` VALUES ('jgtj', '2015-08-25 10:34:53', '添加机构', 'ext-icon-bullet_wrench', '添加机构', 1, '', '2015-08-25 10:34:53', NULL, '/base/syorganization!save', 'system:dept:add', 'jggl', '1');
    146. 

  146. INSERT INTO `SYRESOURCE` VALUES ('jsbj', '2015-08-25 10:34:53', '编辑角色', 'ext-icon-bullet_wrench', '编辑角色', 2, '', '2015-08-25 10:34:53', NULL, '/base/syrole!update', 'system:role:edit', 'jsgl', '1');
    147. 

  147. INSERT INTO `SYRESOURCE` VALUES ('jsck', '2015-08-25 10:34:53', '查看角色', 'ext-icon-bullet_wrench', '查看角色', 4, '', '2015-08-25 10:34:53', NULL, '/base/syrole!getById', 'system:role:query', 'jsgl', '1');
    148. 

  148. INSERT INTO `SYRESOURCE` VALUES ('jsgl', '2015-08-25 10:34:53', '管理系统中用户的角色', 'peoples', '角色管理', 2, '', '2015-08-25 10:34:53', 'role', 'system/role/index', 'system:role:list', 'xtgl', '0');
    149. 

  149. INSERT INTO `SYRESOURCE` VALUES ('jslb', '2015-08-25 10:34:53', '查询角色列表', 'ext-icon-bullet_wrench', '角色列表', 0, '', '2015-08-25 10:34:53', NULL, '/base/syrole!grid', 'system:role:list', 'jsgl', '1');
    150. 

  150. INSERT INTO `SYRESOURCE` VALUES ('jssc', '2015-08-25 10:34:53', '删除角色', 'ext-icon-bullet_wrench', '删除角色', 3, '', '2015-08-25 10:34:53', NULL, '/base/syrole!delete', 'system:role:remove', 'jsgl', '1');
    151. 

  151. INSERT INTO `SYRESOURCE` VALUES ('jssq', '2015-08-25 10:34:53', '角色授权', 'ext-icon-bullet_wrench', '角色授权', 5, '', '2015-08-25 10:34:53', NULL, '/base/syrole!grant', NULL, 'jsgl', '1');
    152. 

  152. INSERT INTO `SYRESOURCE` VALUES ('jstj', '2015-08-25 10:34:53', '添加角色', 'ext-icon-bullet_wrench', '添加角色', 1, '', '2015-08-25 10:34:53', NULL, '/base/syrole!save', 'system:role:add', 'jsgl', '1');
    153. 

  153. INSERT INTO `SYRESOURCE` VALUES ('online', '2015-08-25 10:34:53', '监控用户登录、注销', 'ext-icon-chart_line', '用户登录历史监控', 4, '', '2015-08-25 10:34:53', NULL, '/securityJsp/base/Syonline.jsp', 'monitor:logininfor:list', 'xtjk', '0');
    154. 

  154. INSERT INTO `SYRESOURCE` VALUES ('onlineGrid', '2015-08-25 10:34:53', '用户登录、注销历史记录列表', 'ext-icon-bullet_wrench', '用户登录历史列表', 0, '', '2015-08-25 10:34:53', NULL, '/base/syonline!grid', 'monitor:logininfor:list', 'online', '1');
    155. 

  155. INSERT INTO `SYRESOURCE` VALUES ('xtgl', '2015-08-25 10:34:53', '管理系统的资源、角色、机构、用户等信息', 'system', '系统管理', 5, '', '2015-08-25 10:34:53', '/system', NULL, NULL, NULL, '3');
    156. 

  156. INSERT INTO `SYRESOURCE` VALUES ('xtjk', '2015-08-25 10:34:53', '监控系统运行情况等信息', 'ext-icon-monitor', '系统监控', 6, '', '2015-08-25 10:34:53', NULL, '/welcome.jsp', '', NULL, '0');
    157. 

  157. INSERT INTO `SYRESOURCE` VALUES ('yhbj', '2015-08-25 10:34:53', '编辑用户', 'ext-icon-bullet_wrench', '编辑用户', 2, '', '2015-08-25 10:34:53', NULL, '/base/syuser!update', 'system:user:edit', 'yhgl', '1');
    158. 

  158. INSERT INTO `SYRESOURCE` VALUES ('yhck', '2015-08-25 10:34:53', '查看用户', 'ext-icon-bullet_wrench', '查看用户', 4, '', '2015-08-25 10:34:53', NULL, '/base/syuser!getById', 'system:user:query', 'yhgl', '1');
    159. 

  159. INSERT INTO `SYRESOURCE` VALUES ('yhgl', '2015-08-25 10:34:53', '管理系统中用户的用户', 'user', '用户管理', 4, '', '2015-08-25 10:34:53', 'user', 'system/user/index', 'system:user:list', 'xtgl', '0');
    160. 

  160. INSERT INTO `SYRESOURCE` VALUES ('yhjg', '2015-08-25 10:34:53', '编辑用户机构', 'ext-icon-bullet_wrench', '用户机构', 6, '', '2015-08-25 10:34:53', NULL, '/base/syuser!grantOrganization', 'system:dept:edit', 'yhgl', '1');
    161. 

  161. INSERT INTO `SYRESOURCE` VALUES ('yhjs', '2015-08-25 10:34:53', '编辑用户角色', 'ext-icon-bullet_wrench', '用户角色', 5, '', '2015-08-25 10:34:53', NULL, '/base/syuser!grantRole', 'system:role:edit', 'yhgl', '1');
    162. 

  162. INSERT INTO `SYRESOURCE` VALUES ('yhlb', '2015-08-25 10:34:53', '查询用户列表', 'ext-icon-bullet_wrench', '用户列表', 0, '', '2015-08-25 10:34:53', NULL, '/base/syuser!grid', 'system:user:list', 'yhgl', '1');
    163. 

  163. INSERT INTO `SYRESOURCE` VALUES ('yhsc', '2015-08-25 10:34:53', '删除用户', 'ext-icon-bullet_wrench', '删除用户', 3, '', '2015-08-25 10:34:53', NULL, '/base/syuser!delete', 'system:user:remove', 'yhgl', '1');
    164. 

  164. INSERT INTO `SYRESOURCE` VALUES ('yhtj', '2015-08-25 10:34:53', '添加用户', 'ext-icon-bullet_wrench', '添加用户', 1, '', '2015-08-25 10:34:53', NULL, '/base/syuser!save', 'system:user:add', 'yhgl', '1');
    165. 

  165. INSERT INTO `SYRESOURCE` VALUES ('zybj', '2015-08-25 10:34:53', '编辑资源', 'ext-icon-bullet_wrench', '编辑资源', 2, '', '2015-08-25 10:34:53', NULL, '/base/syresource!update', 'system:menu:edit', 'zygl', '1');
    166. 

  166. INSERT INTO `SYRESOURCE` VALUES ('zyck', '2015-08-25 10:34:53', '查看资源', 'ext-icon-bullet_wrench', '查看资源', 4, '', '2015-08-25 10:34:53', NULL, '/base/syresource!getById', 'system:menu:query', 'zygl', '1');
    167. 

  167. INSERT INTO `SYRESOURCE` VALUES ('zygl', '2015-08-25 10:34:53', '管理系统的资源', 'tree-table', '资源管理', 1, '', '2015-08-25 10:34:53', 'menu', 'system/menu/index', 'system:menu:list', 'xtgl', '0');
    168. 

  168. INSERT INTO `SYRESOURCE` VALUES ('zylb', '2015-08-25 10:34:53', '查询资源', 'ext-icon-bullet_wrench', '资源列表', 0, '', '2015-08-25 10:34:53', NULL, '/base/syresource!treeGrid', 'system:menu:query', 'zygl', '1');
    169. 

  169. INSERT INTO `SYRESOURCE` VALUES ('zysc', '2015-08-25 10:34:53', '删除资源', 'ext-icon-bullet_wrench', '删除资源', 3, '', '2015-08-25 10:34:53', NULL, '/base/syresource!delete', 'system:menu:remove', 'zygl', '1');
    170. 

  170. INSERT INTO `SYRESOURCE` VALUES ('zytj', '2015-08-25 10:34:53', '添加资源', 'ext-icon-bullet_wrench', '添加资源', 1, '', '2015-08-25 10:34:53', NULL, '/base/syresource!save', 'system:menu:add', 'zygl', '1');
    171. 

  171. 

  172. -- ----------------------------
    173. 

  173. -- Table structure for SYRESOURCETYPE
    174. 

  174. -- ----------------------------
    175. 

  175. DROP TABLE IF EXISTS `SYRESOURCETYPE`;
    176. 

  176. CREATE TABLE `SYRESOURCETYPE`  (
    177. 

  177.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    178. 

  178.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    179. 

  179.   `DESCRIPTION` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    180. 

  180.   `NAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    181. 

  181.   `UPDATEDATETIME` datetime NULL DEFAULT NULL,
    182. 

  182.   PRIMARY KEY (`ID`) USING BTREE
    183. 

  183. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    184. 

  184. 

  185. -- ----------------------------
    186. 

  186. -- Records of SYRESOURCETYPE
    187. 

  187. -- ----------------------------
    188. 

  188. INSERT INTO `SYRESOURCETYPE` VALUES ('0', '2015-08-25 10:34:53', '菜单类型会显示在系统首页左侧菜单中', '菜单', '2015-08-25 10:34:53');
    189. 

  189. INSERT INTO `SYRESOURCETYPE` VALUES ('1', '2015-08-25 10:34:53', '功能类型不会显示在系统首页左侧菜单中', '功能', '2015-08-25 10:34:53');
    190. 

  190. INSERT INTO `SYRESOURCETYPE` VALUES ('3', '2022-05-15 10:27:08', NULL, '目录', '2022-05-15 10:27:18');
    191. 

  191. 

  192. -- ----------------------------
    193. 

  193. -- Table structure for SYROLE
    194. 

  194. -- ----------------------------
    195. 

  195. DROP TABLE IF EXISTS `SYROLE`;
    196. 

  196. CREATE TABLE `SYROLE`  (
    197. 

  197.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    198. 

  198.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    199. 

  199.   `DESCRIPTION` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    200. 

  200.   `ICONCLS` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    201. 

  201.   `NAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    202. 

  202.   `SEQ` int NULL DEFAULT NULL,
    203. 

  203.   `UPDATEDATETIME` datetime NULL DEFAULT NULL,
    204. 

  204.   PRIMARY KEY (`ID`) USING BTREE
    205. 

  205. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    206. 

  206. 

  207. -- ----------------------------
    208. 

  208. -- Records of SYROLE
    209. 

  209. -- ----------------------------
    210. 

  210. INSERT INTO `SYROLE` VALUES ('0', '2015-08-25 10:34:53', '拥有系统所有权限', NULL, '超管', 0, '2015-08-25 10:34:53');
    211. 

  211. INSERT INTO `SYROLE` VALUES ('19f00d46-8f1b-45b5-b7b7-6197d7b8cb33', '2016-11-28 14:24:00', NULL, NULL, '管理员', 100, '2022-05-22 12:10:55');
    212. 

  212. 

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

  214. -- Table structure for SYROLE_SYRESOURCE
    215. 

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

  216. DROP TABLE IF EXISTS `SYROLE_SYRESOURCE`;
    217. 

  217. CREATE TABLE `SYROLE_SYRESOURCE`  (
    218. 

  218.   `SYROLE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    219. 

  219.   `SYRESOURCE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    220. 

  220.   PRIMARY KEY (`SYRESOURCE_ID`, `SYROLE_ID`) USING BTREE,
    221. 

  221.   INDEX `FK_kkrartsovl2frhfvriqdi7jwl`(`SYRESOURCE_ID`) USING BTREE,
    222. 

  222.   INDEX `FK_r139h669pg4ts6mbvn3ip5472`(`SYROLE_ID`) USING BTREE,
    223. 

  223.   CONSTRAINT `FK_kkrartsovl2frhfvriqdi7jwl` FOREIGN KEY (`SYRESOURCE_ID`) REFERENCES `SYRESOURCE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    224. 

  224.   CONSTRAINT `FK_r139h669pg4ts6mbvn3ip5472` FOREIGN KEY (`SYROLE_ID`) REFERENCES `SYROLE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    225. 

  225. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    226. 

  226. 

  227. -- ----------------------------
    228. 

  228. -- Records of SYROLE_SYRESOURCE
    229. 

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

  230. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jgbj');
    231. 

  231. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jgck');
    232. 

  232. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jggl');
    233. 

  233. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jglb');
    234. 

  234. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jgsc');
    235. 

  235. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jgsq');
    236. 

  236. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jgtj');
    237. 

  237. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jsbj');
    238. 

  238. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jsck');
    239. 

  239. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jsgl');
    240. 

  240. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jslb');
    241. 

  241. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jssc');
    242. 

  242. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jssq');
    243. 

  243. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'jstj');
    244. 

  244. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'online');
    245. 

  245. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'onlineGrid');
    246. 

  246. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'xtgl');
    247. 

  247. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'xtjk');
    248. 

  248. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhbj');
    249. 

  249. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhck');
    250. 

  250. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhgl');
    251. 

  251. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhjg');
    252. 

  252. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhjs');
    253. 

  253. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhlb');
    254. 

  254. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhsc');
    255. 

  255. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'yhtj');
    256. 

  256. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zybj');
    257. 

  257. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zyck');
    258. 

  258. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zygl');
    259. 

  259. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zylb');
    260. 

  260. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zysc');
    261. 

  261. INSERT INTO `SYROLE_SYRESOURCE` VALUES ('0', 'zytj');
    262. 

  262. 

  263. -- ----------------------------
    264. 

  264. -- Table structure for SYUSER
    265. 

  265. -- ----------------------------
    266. 

  266. DROP TABLE IF EXISTS `SYUSER`;
    267. 

  267. CREATE TABLE `SYUSER`  (
    268. 

  268.   `ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    269. 

  269.   `AGE` int NULL DEFAULT NULL,
    270. 

  270.   `CREATEDATETIME` datetime NULL DEFAULT NULL,
    271. 

  271.   `LOGINNAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    272. 

  272.   `NAME` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    273. 

  273.   `PHOTO` varchar(200) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    274. 

  274.   `PWD` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    275. 

  275.   `SEX` varchar(1) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
    276. 

  276.   `UPDATEDATETIME` datetime NULL DEFAULT NULL,
    277. 

  277.   `EMPLOYDATE` datetime NULL DEFAULT NULL,
    278. 

  278.   PRIMARY KEY (`ID`) USING BTREE,
    279. 

  279.   UNIQUE INDEX `UK_eiov1gsncrds3rean3dmu822p`(`LOGINNAME`) USING BTREE
    280. 

  280. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    281. 

  281. 

  282. -- ----------------------------
    283. 

  283. -- Records of SYUSER
    284. 

  284. -- ----------------------------
    285. 

  285. INSERT INTO `SYUSER` VALUES ('0', 30, '2015-08-25 10:34:54', 'admin', '超级管理员', '', 'e10adc3949ba59abbe56e057f20f883e', '1', '2016-09-27 15:41:11', NULL);
    286. 

  286. 

  287. -- ----------------------------
    288. 

  288. -- Table structure for SYUSER_SYORGANIZATION
    289. 

  289. -- ----------------------------
    290. 

  290. DROP TABLE IF EXISTS `SYUSER_SYORGANIZATION`;
    291. 

  291. CREATE TABLE `SYUSER_SYORGANIZATION`  (
    292. 

  292.   `SYUSER_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    293. 

  293.   `SYORGANIZATION_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    294. 

  294.   PRIMARY KEY (`SYORGANIZATION_ID`, `SYUSER_ID`) USING BTREE,
    295. 

  295.   INDEX `FK_14ewqc5wtscac0dd5rswrm5j2`(`SYORGANIZATION_ID`) USING BTREE,
    296. 

  296.   INDEX `FK_63bdmtxwlk259id13rp4iryy`(`SYUSER_ID`) USING BTREE,
    297. 

  297.   CONSTRAINT `FK_14ewqc5wtscac0dd5rswrm5j2` FOREIGN KEY (`SYORGANIZATION_ID`) REFERENCES `SYORGANIZATION` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    298. 

  298.   CONSTRAINT `FK_63bdmtxwlk259id13rp4iryy` FOREIGN KEY (`SYUSER_ID`) REFERENCES `SYUSER` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    299. 

  299. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    300. 

  300. 

  301. -- ----------------------------
    302. 

  302. -- Records of SYUSER_SYORGANIZATION
    303. 

  303. -- ----------------------------
    304. 

  304. INSERT INTO `SYUSER_SYORGANIZATION` VALUES ('0', '0');
    305. 

  305. INSERT INTO `SYUSER_SYORGANIZATION` VALUES ('346e8333-b644-4939-8b06-f23654963c6a', '0');
    306. 

  306. INSERT INTO `SYUSER_SYORGANIZATION` VALUES ('0', '5477d9a9-e41e-485f-bb08-697e8facef88');
    307. 

  307. 

  308. -- ----------------------------
    309. 

  309. -- Table structure for SYUSER_SYROLE
    310. 

  310. -- ----------------------------
    311. 

  311. DROP TABLE IF EXISTS `SYUSER_SYROLE`;
    312. 

  312. CREATE TABLE `SYUSER_SYROLE`  (
    313. 

  313.   `SYUSER_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    314. 

  314.   `SYROLE_ID` varchar(36) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
    315. 

  315.   PRIMARY KEY (`SYROLE_ID`, `SYUSER_ID`) USING BTREE,
    316. 

  316.   INDEX `FK_j7iwtgslc2esrjx0ptieleoko`(`SYROLE_ID`) USING BTREE,
    317. 

  317.   INDEX `FK_1pi4p5h4y5ghbs5f4gdlgn620`(`SYUSER_ID`) USING BTREE,
    318. 

  318.   CONSTRAINT `FK_1pi4p5h4y5ghbs5f4gdlgn620` FOREIGN KEY (`SYUSER_ID`) REFERENCES `SYUSER` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    319. 

  319.   CONSTRAINT `FK_j7iwtgslc2esrjx0ptieleoko` FOREIGN KEY (`SYROLE_ID`) REFERENCES `SYROLE` (`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT
    320. 

  320. ) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
    321. 

  321. 

  322. -- ----------------------------
    323. 

  323. -- Records of SYUSER_SYROLE
    324. 

  324. -- ----------------------------
    325. 

  325. INSERT INTO `SYUSER_SYROLE` VALUES ('0', '0');
    326. 

  326. INSERT INTO `SYUSER_SYROLE` VALUES ('0', '19f00d46-8f1b-45b5-b7b7-6197d7b8cb33');
    327. 

  327. INSERT INTO `SYUSER_SYROLE` VALUES ('346e8333-b644-4939-8b06-f23654963c6a', '19f00d46-8f1b-45b5-b7b7-6197d7b8cb33');
    328. 

  328. 

  329. SET FOREIGN_KEY_CHECKS = 1;
    330.