首頁 探索 說明
註冊 登入
SG
/
pigx-wx-ui38
4
0
複刻 0
Files 問題管理 0 合併請求 0 Wiki
目錄樹: b024fe5695
分支列表 標籤列表
pigx-wx-ui38
/
db
/
2pigxx.sql

2pigxx.sql 35 KB
文件歷史 原始文件

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : localhost
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50723
    7. 

  7.  Source Host           : localhost
    8. 

  8.  Source Database       : pigxx
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50723
    12. 

  12.  File Encoding         : utf-8
    13. 

  13. 

  14.  Date: 03/30/2019 12:29:01 PM
    15. 

  15. */
    16. 

  16. USE pigxx;
    17. 

  17. 

  18. SET NAMES utf8;
    19. 

  19. SET FOREIGN_KEY_CHECKS = 0;
    20. 

  20. 

  21. -- ----------------------------
    22. 

  22. --  Table structure for `sys_dept`
    23. 

  23. -- ----------------------------
    24. 

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

  25. CREATE TABLE `sys_dept` (
    26. 

  26.   `dept_id` int(20) NOT NULL AUTO_INCREMENT,
    27. 

  27.   `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
    28. 

  28.   `sort` int(11) DEFAULT NULL COMMENT '排序',
    29. 

  29.   `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    30. 

  30.   `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    31. 

  31.   `del_flag` char(1) DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
    32. 

  32.   `parent_id` int(11) DEFAULT NULL,
    33. 

  33.   `tenant_id` int(11) DEFAULT NULL,
    34. 

  34.   PRIMARY KEY (`dept_id`) USING BTREE
    35. 

  35. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='部门管理';
    36. 

  36. 

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

  38. --  Records of `sys_dept`
    39. 

  39. -- ----------------------------
    40. 

  40. BEGIN;
    41. 

  41. INSERT INTO `sys_dept` VALUES ('1', '山东农信', null, '2018-01-22 19:00:23', '2018-09-13 01:46:29', '0', '0', '1'), ('2', '沙县国际', null, '2018-01-22 19:00:38', '2018-09-13 01:46:30', '0', '0', '1'), ('3', '潍坊农信', null, '2018-01-22 19:00:44', '2018-09-13 01:46:31', '0', '1', '1'), ('4', '高新农信', null, '2018-01-22 19:00:52', '2018-10-06 10:41:52', '0', '3', '1'), ('5', '院校农信', null, '2018-01-22 19:00:57', '2018-10-06 10:42:51', '0', '4', '1'), ('6', '潍院农信', null, '2018-01-22 19:01:06', '2019-01-09 10:58:18', '1', '5', '1'), ('7', '山东沙县', null, '2018-01-22 19:01:57', '2018-09-13 01:46:42', '0', '2', '1'), ('8', '潍坊沙县', null, '2018-01-22 19:02:03', '2018-09-13 01:46:43', '0', '7', '1'), ('9', '高新沙县', null, '2018-01-22 19:02:14', '2018-09-13 01:46:44', '1', '8', '1'), ('10', '租户2', null, '2018-11-18 13:27:11', '2018-11-18 13:42:19', '0', '0', '2'), ('11', '院校沙县', null, '2018-12-10 21:19:26', null, '0', '8', '1');
    42. 

  42. COMMIT;
    43. 

  43. 

  44. -- ----------------------------
    45. 

  45. --  Table structure for `sys_dept_relation`
    46. 

  46. -- ----------------------------
    47. 

  47. DROP TABLE IF EXISTS `sys_dept_relation`;
    48. 

  48. CREATE TABLE `sys_dept_relation` (
    49. 

  49.   `ancestor` int(11) NOT NULL COMMENT '祖先节点',
    50. 

  50.   `descendant` int(11) NOT NULL COMMENT '后代节点',
    51. 

  51.   PRIMARY KEY (`ancestor`,`descendant`) USING BTREE,
    52. 

  52.   KEY `idx1` (`ancestor`) USING BTREE,
    53. 

  53.   KEY `idx2` (`descendant`) USING BTREE
    54. 

  54. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='部门关系表';
    55. 

  55. 

  56. -- ----------------------------
    57. 

  57. --  Records of `sys_dept_relation`
    58. 

  58. -- ----------------------------
    59. 

  59. BEGIN;
    60. 

  60. INSERT INTO `sys_dept_relation` VALUES ('1', '1'), ('1', '3'), ('1', '4'), ('1', '5'), ('2', '2'), ('2', '7'), ('2', '8'), ('2', '11'), ('3', '3'), ('3', '4'), ('3', '5'), ('4', '4'), ('4', '5'), ('5', '5'), ('7', '7'), ('7', '8'), ('7', '11'), ('8', '8'), ('8', '11'), ('10', '10'), ('11', '11');
    61. 

  61. COMMIT;
    62. 

  62. 

  63. -- ----------------------------
    64. 

  64. --  Table structure for `sys_dict`
    65. 

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

  66. DROP TABLE IF EXISTS `sys_dict`;
    67. 

  67. CREATE TABLE `sys_dict` (
    68. 

  68.   `id` int(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
    69. 

  69.   `type` varchar(100) NOT NULL COMMENT '类型',
    70. 

  70.   `description` varchar(100) NOT NULL COMMENT '描述',
    71. 

  71.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    72. 

  72.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    73. 

  73.   `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    74. 

  74.   `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    75. 

  75.   `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    76. 

  76.   PRIMARY KEY (`id`) USING BTREE,
    77. 

  77.   KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
    78. 

  78. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典表';
    79. 

  79. 

  80. -- ----------------------------
    81. 

  81. --  Records of `sys_dict`
    82. 

  82. -- ----------------------------
    83. 

  83. BEGIN;
    84. 

  84. INSERT INTO `sys_dict` VALUES ('1', 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '0', '1'), ('2', 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '0', '1'), ('3', 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '0', '1'), ('4', 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '0', '1'), ('5', 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '0', '1'), ('6', 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '0', '1'), ('7', 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '0', '1'), ('8', 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '0', '1'), ('9', 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '0', '1'), ('10', 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '0', '1');
    85. 

  85. COMMIT;
    86. 

  86. 

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

  88. --  Table structure for `sys_dict_item`
    89. 

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

  90. DROP TABLE IF EXISTS `sys_dict_item`;
    91. 

  91. CREATE TABLE `sys_dict_item` (
    92. 

  92.   `id` int(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
    93. 

  93.   `dict_id` int(11) NOT NULL,
    94. 

  94.   `value` varchar(100) NOT NULL COMMENT '数据值',
    95. 

  95.   `label` varchar(100) NOT NULL COMMENT '标签名',
    96. 

  96.   `type` varchar(100) NOT NULL COMMENT '类型',
    97. 

  97.   `description` varchar(100) NOT NULL COMMENT '描述',
    98. 

  98.   `sort` int(10) NOT NULL COMMENT '排序（升序）',
    99. 

  99.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    100. 

  100.   `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    101. 

  101.   `remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
    102. 

  102.   `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    103. 

  103.   `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    104. 

  104.   PRIMARY KEY (`id`) USING BTREE,
    105. 

  105.   KEY `sys_dict_value` (`value`) USING BTREE,
    106. 

  106.   KEY `sys_dict_label` (`label`) USING BTREE,
    107. 

  107.   KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
    108. 

  108. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='字典项';
    109. 

  109. 

  110. -- ----------------------------
    111. 

  111. --  Records of `sys_dict_item`
    112. 

  112. -- ----------------------------
    113. 

  113. BEGIN;
    114. 

  114. INSERT INTO `sys_dict_item` VALUES ('1', '1', '9', '异常', 'log_type', '日志异常', '1', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', '1'), ('2', '1', '0', '正常', 'log_type', '日志正常', '0', '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', '1'), ('3', '2', 'WX', '微信', 'social_type', '微信登录', '0', '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', '1'), ('4', '2', 'QQ', 'QQ', 'social_type', 'QQ登录', '1', '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', '1'), ('5', '3', '0', '未提交', 'leave_status', '未提交', '0', '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', '1'), ('6', '3', '1', '审批中', 'leave_status', '审批中', '1', '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', '1'), ('7', '3', '2', '完成', 'leave_status', '完成', '2', '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', '1'), ('8', '3', '9', '驳回', 'leave_status', '驳回', '9', '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', '1'), ('9', '4', '1', 'java类', 'job_type', 'java类', '1', '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', '1'), ('10', '4', '2', 'spring bean', 'job_type', 'spring bean容器实例', '2', '2019-03-19 11:23:05', '2019-03-25 12:49:36', '', '0', '1'), ('11', '4', '9', '其他', 'job_type', '其他类型', '9', '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', '1'), ('12', '4', '3', 'Rest 调用', 'job_type', 'Rest 调用', '3', '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', '1'), ('13', '4', '4', 'jar', 'job_type', 'jar类型', '4', '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', '1'), ('14', '5', '1', '未发布', 'job_status', '未发布', '1', '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', '1'), ('15', '5', '2', '运行中', 'job_status', '运行中', '2', '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', '1'), ('16', '5', '3', '暂停', 'job_status', '暂停', '3', '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', '1'), ('17', '6', '0', '正常', 'job_execute_status', '正常', '0', '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', '1'), ('18', '6', '1', '异常', 'job_execute_status', '异常', '1', '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', '1'), ('19', '7', '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', '1', '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0', '1'), ('20', '7', '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', '2', '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0', '1'), ('21', '7', '3', '下周期执行', 'misfire_policy', '下周期执行', '3', '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', '1'), ('22', '8', '1', '男', 'gender', '微信-男', '0', '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', '1'), ('23', '8', '2', '女', 'gender', '女-微信', '1', '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', '1'), ('24', '8', '0', '未知', 'gender', 'x性别未知', '3', '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', '1'), ('25', '9', '0', '未关注', 'subscribe', '公众号-未关注', '0', '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', '1'), ('26', '9', '1', '已关注', 'subscribe', '公众号-已关注', '1', '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', '1'), ('27', '10', '0', '未回复', 'response_type', '微信消息-未回复', '0', '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复', '0', '1'), ('28', '10', '1', '已回复', 'response_type', '微信消息-已回复', '1', '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复', '0', '1');
    115. 

  115. COMMIT;
    116. 

  116. 

  117. -- ----------------------------
    118. 

  118. --  Table structure for `sys_log`
    119. 

  119. -- ----------------------------
    120. 

  120. DROP TABLE IF EXISTS `sys_log`;
    121. 

  121. CREATE TABLE `sys_log` (
    122. 

  122.   `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
    123. 

  123.   `type` char(1) DEFAULT '1' COMMENT '日志类型',
    124. 

  124.   `title` varchar(255) DEFAULT '' COMMENT '日志标题',
    125. 

  125.   `service_id` varchar(32) DEFAULT NULL COMMENT '服务ID',
    126. 

  126.   `create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
    127. 

  127.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    128. 

  128.   `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    129. 

  129.   `remote_addr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
    130. 

  130.   `user_agent` varchar(1000) DEFAULT NULL COMMENT '用户代理',
    131. 

  131.   `request_uri` varchar(255) DEFAULT NULL COMMENT '请求URI',
    132. 

  132.   `method` varchar(10) DEFAULT NULL COMMENT '操作方式',
    133. 

  133.   `params` text COMMENT '操作提交的数据',
    134. 

  134.   `time` mediumtext COMMENT '执行时间',
    135. 

  135.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
    136. 

  136.   `exception` text COMMENT '异常信息',
    137. 

  137.   `tenant_id` int(11) DEFAULT '0' COMMENT '所属租户',
    138. 

  138.   PRIMARY KEY (`id`) USING BTREE,
    139. 

  139.   KEY `sys_log_create_by` (`create_by`) USING BTREE,
    140. 

  140.   KEY `sys_log_request_uri` (`request_uri`) USING BTREE,
    141. 

  141.   KEY `sys_log_type` (`type`) USING BTREE,
    142. 

  142.   KEY `sys_log_create_date` (`create_time`) USING BTREE
    143. 

  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='日志表';
    144. 

  144. 

  145. -- ----------------------------
    146. 

  146. --  Table structure for `sys_menu`
    147. 

  147. -- ----------------------------
    148. 

  148. DROP TABLE IF EXISTS `sys_menu`;
    149. 

  149. CREATE TABLE `sys_menu` (
    150. 

  150.   `menu_id` int(11) NOT NULL COMMENT '菜单ID',
    151. 

  151.   `name` varchar(32) NOT NULL COMMENT '菜单名称',
    152. 

  152.   `permission` varchar(32) DEFAULT NULL COMMENT '菜单权限标识',
    153. 

  153.   `path` varchar(128) DEFAULT NULL COMMENT '前端URL',
    154. 

  154.   `parent_id` int(11) DEFAULT NULL COMMENT '父菜单ID',
    155. 

  155.   `icon` varchar(32) DEFAULT NULL COMMENT '图标',
    156. 

  156.   `component` varchar(64) DEFAULT NULL COMMENT 'VUE页面',
    157. 

  157.   `sort` int(11) DEFAULT '1' COMMENT '排序值',
    158. 

  158.   `keep_alive` char(1) DEFAULT '0' COMMENT '0-开启，1- 关闭',
    159. 

  159.   `type` char(1) DEFAULT NULL COMMENT '菜单类型 （0菜单 1按钮）',
    160. 

  160.   `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    161. 

  161.   `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    162. 

  162.   `del_flag` char(1) DEFAULT '0' COMMENT '逻辑删除标记(0--正常 1--删除)',
    163. 

  163.   PRIMARY KEY (`menu_id`) USING BTREE
    164. 

  164. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';
    165. 

  165. 

  166. -- ----------------------------
    167. 

  167. --  Records of `sys_menu`
    168. 

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

  169. BEGIN;
    170. 

  170. INSERT INTO `sys_menu` VALUES ('1000', '权限管理', null, '/upms', '-1', 'icon-quanxianguanli', 'Layout', '0', '0', '0', '2018-09-28 08:29:53', '2018-09-28 08:53:01', '0'), ('1100', '用户管理', null, 'user', '1000', 'icon-yonghuguanli', 'views/admin/user/index', '1', '1', '0', '2017-11-02 22:24:37', '2018-09-28 09:00:41', '0'), ('1101', '用户新增', 'sys_user_add', null, '1100', null, null, null, '0', '1', '2017-11-08 09:52:09', '2018-09-28 09:06:34', '0'), ('1102', '用户修改', 'sys_user_edit', null, '1100', null, null, null, '0', '1', '2017-11-08 09:52:48', '2018-09-28 09:06:37', '0'), ('1103', '用户删除', 'sys_user_del', null, '1100', null, null, null, '0', '1', '2017-11-08 09:54:01', '2018-09-28 09:06:42', '0'), ('1200', '菜单管理', null, 'menu', '1000', 'icon-caidanguanli', 'views/admin/menu/index', '2', '0', '0', '2017-11-08 09:57:27', '2018-09-28 09:00:45', '0'), ('1201', '菜单新增', 'sys_menu_add', null, '1200', null, null, null, '0', '1', '2017-11-08 10:15:53', '2018-09-28 09:07:16', '0'), ('1202', '菜单修改', 'sys_menu_edit', null, '1200', null, null, null, '0', '1', '2017-11-08 10:16:23', '2018-09-28 09:07:18', '0'), ('1203', '菜单删除', 'sys_menu_del', null, '1200', null, null, null, '0', '1', '2017-11-08 10:16:43', '2018-09-28 09:07:22', '0'), ('1300', '角色管理', null, 'role', '1000', 'icon-jiaoseguanli', 'views/admin/role/index', '3', '0', '0', '2017-11-08 10:13:37', '2018-09-28 09:00:48', '0'), ('1301', '角色新增', 'sys_role_add', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:18', '2018-09-28 09:07:46', '0'), ('1302', '角色修改', 'sys_role_edit', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:41', '2018-09-28 09:07:49', '0'), ('1303', '角色删除', 'sys_role_del', null, '1300', null, null, null, '0', '1', '2017-11-08 10:14:59', '2018-09-28 09:07:53', '0'), ('1304', '分配权限', 'sys_role_perm', null, '1300', null, null, null, '0', '1', '2018-04-20 07:22:55', '2018-09-28 09:13:23', '0'), ('1400', '部门管理', null, 'dept', '1000', 'icon-web-icon-', 'views/admin/dept/index', '4', '0', '0', '2018-01-20 13:17:19', '2018-12-09 16:35:12', '0'), ('1401', '部门新增', 'sys_dept_add', null, '1400', null, null, null, '0', '1', '2018-01-20 14:56:16', '2018-09-28 09:08:13', '0'), ('1402', '部门修改', 'sys_dept_edit', null, '1400', null, null, null, '0', '1', '2018-01-20 14:56:59', '2018-09-28 09:08:16', '0'), ('1403', '部门删除', 'sys_dept_del', null, '1400', null, null, null, '0', '1', '2018-01-20 14:57:28', '2018-09-28 09:08:18', '0'), ('2000', '系统管理', null, '/admin', '-1', 'icon-xitongguanli', 'Layout', '1', '0', '0', '2017-11-07 20:56:00', '2018-09-28 08:53:18', '0'), ('2100', '日志管理', null, 'log', '2000', 'icon-rizhiguanli', 'views/admin/log/index', '5', '0', '0', '2017-11-20 14:06:22', '2018-09-28 09:01:52', '0'), ('2101', '日志删除', 'sys_log_del', null, '2100', null, null, null, '0', '1', '2017-11-20 20:37:37', '2018-09-28 09:08:44', '0'), ('2200', '字典管理', null, 'dict', '2000', 'icon-navicon-zdgl', 'views/admin/dict/index', '6', '0', '0', '2017-11-29 11:30:52', '2018-09-28 09:01:47', '0'), ('2201', '字典删除', 'sys_dict_del', null, '2200', null, null, null, '0', '1', '2017-11-29 11:30:11', '2018-09-28 09:09:10', '0'), ('2202', '字典新增', 'sys_dict_add', null, '2200', null, null, null, '0', '1', '2018-05-11 22:34:55', '2018-09-28 09:09:12', '0'), ('2203', '字典修改', 'sys_dict_edit', null, '2200', null, null, null, '0', '1', '2018-05-11 22:36:03', '2018-09-28 09:09:16', '0'), ('2300', '代码生成', '', 'gen', '2000', 'icon-weibiaoti46', 'views/gen/index', '8', '0', '0', '2018-01-20 13:17:19', '2018-11-24 05:21:01', '0'), ('2400', '终端管理', '', 'client', '2000', 'icon-shouji', 'views/admin/client/index', '9', '0', '0', '2018-01-20 13:17:19', '2018-09-28 09:01:43', '0'), ('2401', '客户端新增', 'sys_client_add', null, '2400', '1', null, null, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:10:25', '0'), ('2402', '客户端修改', 'sys_client_edit', null, '2400', null, null, null, '0', '1', '2018-05-15 21:37:06', '2018-09-28 09:10:27', '0'), ('2403', '客户端删除', 'sys_client_del', null, '2400', null, null, null, '0', '1', '2018-05-15 21:39:16', '2018-09-28 09:10:30', '0'), ('2500', '密钥管理', '', 'social', '2000', 'icon-miyue', 'views/admin/social/index', '10', '0', '0', '2018-01-20 13:17:19', '2018-09-28 09:01:41', '0'), ('2501', '密钥新增', 'sys_social_details_add', null, '2500', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:52:18', '0'), ('2502', '密钥修改', 'sys_social_details_edit', null, '2500', '1', null, '1', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:51:36', '0'), ('2503', '密钥删除', 'sys_social_details_del', null, '2500', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:51:30', '0'), ('2600', '令牌管理', null, 'token', '2000', 'icon-denglvlingpai', 'views/admin/token/index', '11', '0', '0', '2018-09-04 05:58:41', '2018-09-28 09:01:38', '0'), ('2601', '令牌删除', 'sys_token_del', null, '2600', null, null, '1', '0', '1', '2018-09-04 05:59:50', '2018-09-28 09:11:24', '0'), ('2700', '动态路由', null, 'route', '2000', 'icon-luyou', 'views/admin/route/index', '12', '0', '0', '2018-09-04 05:58:41', '2018-09-28 09:01:38', '0'), ('2800', 'Quartz管理', '', 'job-manage', '2000', 'icon-guanwangfangwen', 'views/daemon/job-manage/index', '8', '0', '0', '2018-01-20 13:17:19', '2019-03-25 13:52:14', '0'), ('2810', '任务新增', 'job_sys_job_add', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:23', '0'), ('2820', '任务修改', 'job_sys_job_edit', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:26', '0'), ('2830', '任务删除', 'job_sys_job_del', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:30', '0'), ('2840', '任务暂停', 'job_sys_job_shutdown_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:18', '0'), ('2850', '任务开始', 'job_sys_job_start_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:35', '0'), ('2860', '任务刷新', 'job_sys_job_refresh_job', null, '2800', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:39', '0'), ('3000', '系统监控', null, '/daemon', '-1', 'icon-msnui-supervise', 'Layout', '2', '0', '0', '2018-07-27 01:13:21', '2018-09-28 08:53:24', '0'), ('3100', '服务监控', null, 'https://monitor.pig4cloud.com', '3000', 'icon-server', null, '0', '0', '0', '2018-06-26 10:50:32', '2018-12-11 17:17:07', '0'), ('3200', '接口文档', null, 'https://swagger.pig4cloud.com/swagger-ui.html', '3000', 'icon-wendang', null, '1', '0', '0', '2018-06-26 10:50:32', '2018-09-28 09:05:16', '0'), ('3300', '事务监控', null, 'tx', '3000', 'icon-gtsquanjushiwufuwuGTS', 'views/tx/index', '5', '0', '0', '2018-08-19 11:02:39', '2018-11-23 14:25:08', '0'), ('3400', '在线事务', null, 'model', '3000', 'icon-online', 'views/tx/model', '6', '0', '0', '2018-08-19 11:32:04', '2018-11-23 14:25:14', '0'), ('3500', '任务监控', null, 'https://task.pig4cloud.com', '3000', 'icon-msnui-supervise', null, '7', '0', '0', '2018-06-26 10:50:32', '2018-09-28 09:03:33', '0'), ('3600', '任务轨迹', '', 'status-trace-log', '3000', 'icon-guiji', 'views/daemon/status-trace-log/index', '8', '0', '0', '2018-01-20 13:17:19', '2018-11-24 06:34:52', '0'), ('3601', '删除轨迹', 'daemon_status_trace_log_del', null, '3600', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-30 09:31:06', '0'), ('3620', 'Quartz日志', '', 'joblog', '3000', 'icon-gtsquanjushiwufuwuGTS', 'views/daemon/job-log/index', '8', '0', '0', '2018-01-20 13:17:19', '2019-03-25 11:49:36', '0'), ('3630', '任务日志', '', 'execution-log', '3000', 'icon-wendang', 'views/daemon/execution-log/index', '7', '0', '0', '2018-01-20 13:17:19', '2019-03-30 09:30:33', '0'), ('3631', '删除日志', 'daemon_execution_log_del', null, '3900', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2019-03-30 09:30:45', '0'), ('3700', '调用拓扑', null, 'https://zipkin.pig4cloud.com', '3000', 'icon-line', null, '10', '0', '0', '2018-01-25 11:08:52', '2018-09-28 09:04:29', '0'), ('3800', '缓存状态', null, 'https://cache.pig4cloud.com', '3000', 'icon-qingchuhuancun', null, '12', '0', '0', '2018-01-23 10:56:11', '2018-09-28 09:13:56', '0'), ('4000', '协同管理', null, '/activti', '-1', 'icon-kuaisugongzuoliu_o', 'Layout', '3', '0', '0', '2018-09-26 01:38:13', '2018-09-28 08:58:24', '0'), ('4100', '模型管理', null, 'activiti', '4000', 'icon-weibiaoti13', 'views/activiti/index', '1', '0', '0', '2018-09-26 01:39:07', '2018-12-09 16:35:16', '0'), ('4101', '模型管理', 'act_model_manage', null, '4100', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07', '0'), ('4200', '流程管理', null, 'process', '4000', 'icon-liucheng', 'views/activiti/process', '2', '0', '0', '2018-09-26 06:41:05', '2018-11-23 14:25:33', '0'), ('4201', '流程管理', 'act_process_manage', null, '4200', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07', '0'), ('4300', '请假管理', '', 'leave-bill', '4000', 'icon-qingjia', 'views/activiti/leave', '3', '0', '0', '2018-01-20 13:17:19', '2019-03-25 13:52:10', '0'), ('4301', '请假新增', 'act_leavebill_add', null, '4300', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07', '0'), ('4302', '请假修改', 'act_leavebill_edit', null, '4300', '1', null, '1', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:09', '0'), ('4303', '请假删除', 'act_leavebill_del', null, '4300', '1', null, '2', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:14', '0'), ('4400', '待办任务', null, 'task', '4000', 'icon-renwu', 'views/activiti/task', '4', '0', '0', '2018-09-27 09:52:31', '2018-12-09 16:35:26', '0'), ('4401', '流程管理', 'act_task_manage', null, '4400', '1', null, '0', '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07', '0'), ('9999', '系统官网', null, 'https://pig4cloud.com/#', '-1', 'icon-guanwangfangwen', null, '9', '0', '0', '2019-01-17 17:05:19', '2019-01-17 17:29:06', '0');
    171. 

  171. COMMIT;
    172. 

  172. 

  173. -- ----------------------------
    174. 

  174. --  Table structure for `sys_oauth_client_details`
    175. 

  175. -- ----------------------------
    176. 

  176. DROP TABLE IF EXISTS `sys_oauth_client_details`;
    177. 

  177. CREATE TABLE `sys_oauth_client_details` (
    178. 

  178.   `client_id` varchar(32) NOT NULL,
    179. 

  179.   `resource_ids` varchar(256) DEFAULT NULL,
    180. 

  180.   `client_secret` varchar(256) DEFAULT NULL,
    181. 

  181.   `scope` varchar(256) DEFAULT NULL,
    182. 

  182.   `authorized_grant_types` varchar(256) DEFAULT NULL,
    183. 

  183.   `web_server_redirect_uri` varchar(256) DEFAULT NULL,
    184. 

  184.   `authorities` varchar(256) DEFAULT NULL,
    185. 

  185.   `access_token_validity` int(11) DEFAULT NULL,
    186. 

  186.   `refresh_token_validity` int(11) DEFAULT NULL,
    187. 

  187.   `additional_information` varchar(4096) DEFAULT NULL,
    188. 

  188.   `autoapprove` varchar(256) DEFAULT NULL,
    189. 

  189.   `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    190. 

  190.   PRIMARY KEY (`client_id`) USING BTREE
    191. 

  191. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='终端信息表';
    192. 

  192. 

  193. -- ----------------------------
    194. 

  194. --  Records of `sys_oauth_client_details`
    195. 

  195. -- ----------------------------
    196. 

  196. BEGIN;
    197. 

  197. INSERT INTO `sys_oauth_client_details` VALUES ('app', null, 'app', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1'), ('daemon', null, 'daemon', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1'), ('gen', null, 'gen', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1'), ('pig', null, 'pig', 'server', 'password,refresh_token,authorization_code,client_credentials', 'http://localhost:4040/sso1/login,http://localhost:4041/sso1/login', null, null, null, null, 'true', '1'), ('test', null, 'test', 'server', 'password,refresh_token', null, null, null, null, null, 'true', '1');
    198. 

  198. COMMIT;
    199. 

  199. 

  200. -- ----------------------------
    201. 

  201. --  Table structure for `sys_role`
    202. 

  202. -- ----------------------------
    203. 

  203. DROP TABLE IF EXISTS `sys_role`;
    204. 

  204. CREATE TABLE `sys_role` (
    205. 

  205.   `role_id` int(11) NOT NULL AUTO_INCREMENT,
    206. 

  206.   `role_name` varchar(64) COLLATE utf8mb4_bin NOT NULL,
    207. 

  207.   `role_code` varchar(64) COLLATE utf8mb4_bin NOT NULL,
    208. 

  208.   `role_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
    209. 

  209.   `ds_type` char(1) COLLATE utf8mb4_bin NOT NULL DEFAULT '2' COMMENT '数据权限类型',
    210. 

  210.   `ds_scope` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '数据权限范围',
    211. 

  211.   `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    212. 

  212.   `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    213. 

  213.   `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标识（0-正常,1-删除）',
    214. 

  214.   `tenant_id` int(11) DEFAULT NULL,
    215. 

  215.   PRIMARY KEY (`role_id`) USING BTREE,
    216. 

  216.   UNIQUE KEY `role_idx1_role_code` (`role_code`) USING BTREE
    217. 

  217. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='系统角色表';
    218. 

  218. 

  219. -- ----------------------------
    220. 

  220. --  Records of `sys_role`
    221. 

  221. -- ----------------------------
    222. 

  222. BEGIN;
    223. 

  223. INSERT INTO `sys_role` VALUES ('1', '管理员', 'ROLE_ADMIN', '管理员', '0', '2', '2017-10-29 15:45:51', '2018-12-26 14:09:11', '0', '1'), ('2', 'ROLE_CQQ', 'ROLE_CQQ', 'ROLE_CQQ', '2', null, '2018-11-11 19:42:26', '2018-12-26 14:09:07', '0', '2');
    224. 

  224. COMMIT;
    225. 

  225. 

  226. -- ----------------------------
    227. 

  227. --  Table structure for `sys_role_menu`
    228. 

  228. -- ----------------------------
    229. 

  229. DROP TABLE IF EXISTS `sys_role_menu`;
    230. 

  230. CREATE TABLE `sys_role_menu` (
    231. 

  231.   `role_id` int(11) NOT NULL COMMENT '角色ID',
    232. 

  232.   `menu_id` int(11) NOT NULL COMMENT '菜单ID',
    233. 

  233.   PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
    234. 

  234. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色菜单表';
    235. 

  235. 

  236. -- ----------------------------
    237. 

  237. --  Records of `sys_role_menu`
    238. 

  238. -- ----------------------------
    239. 

  239. BEGIN;
    240. 

  240. INSERT INTO `sys_role_menu` VALUES ('1', '1000'), ('1', '1100'), ('1', '1101'), ('1', '1102'), ('1', '1103'), ('1', '1200'), ('1', '1201'), ('1', '1202'), ('1', '1203'), ('1', '1300'), ('1', '1301'), ('1', '1302'), ('1', '1303'), ('1', '1304'), ('1', '1400'), ('1', '1401'), ('1', '1402'), ('1', '1403'), ('1', '2000'), ('1', '2100'), ('1', '2101'), ('1', '2200'), ('1', '2201'), ('1', '2202'), ('1', '2203'), ('1', '2300'), ('1', '2400'), ('1', '2401'), ('1', '2402'), ('1', '2403'), ('1', '2500'), ('1', '2501'), ('1', '2502'), ('1', '2503'), ('1', '2600'), ('1', '2601'), ('1', '2700'), ('1', '2800'), ('1', '2810'), ('1', '2820'), ('1', '2830'), ('1', '2840'), ('1', '2850'), ('1', '2860'), ('1', '3000'), ('1', '3100'), ('1', '3200'), ('1', '3300'), ('1', '3400'), ('1', '3500'), ('1', '3600'), ('1', '3601'), ('1', '3620'), ('1', '3630'), ('1', '3631'), ('1', '3700'), ('1', '3800'), ('1', '4000'), ('1', '4100'), ('1', '4101'), ('1', '4200'), ('1', '4201'), ('1', '4300'), ('1', '4301'), ('1', '4302'), ('1', '4303'), ('1', '4400'), ('1', '4401'), ('1', '9999'), ('2', '1000'), ('2', '1100'), ('2', '1101'), ('2', '1102'), ('2', '1103'), ('2', '1200'), ('2', '1201'), ('2', '1202'), ('2', '1203'), ('2', '1300'), ('2', '1301'), ('2', '1302'), ('2', '1303'), ('2', '1304'), ('2', '1400'), ('2', '1401'), ('2', '1402'), ('2', '1403');
    241. 

  241. COMMIT;
    242. 

  242. 

  243. -- ----------------------------
    244. 

  244. --  Table structure for `sys_route_conf`
    245. 

  245. -- ----------------------------
    246. 

  246. DROP TABLE IF EXISTS `sys_route_conf`;
    247. 

  247. CREATE TABLE `sys_route_conf` (
    248. 

  248.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    249. 

  249.   `route_name` varchar(30) DEFAULT NULL COMMENT '路由名称',
    250. 

  250.   `route_id` varchar(30) NOT NULL DEFAULT '' COMMENT '路由ID',
    251. 

  251.   `predicates` json DEFAULT NULL COMMENT '断言',
    252. 

  252.   `filters` json DEFAULT NULL COMMENT '过滤器',
    253. 

  253.   `uri` varchar(50) DEFAULT NULL,
    254. 

  254.   `order` int(2) DEFAULT '0' COMMENT '排序',
    255. 

  255.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    256. 

  256.   `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    257. 

  257.   `del_flag` char(1) DEFAULT '0' COMMENT '删除标记',
    258. 

  258.   PRIMARY KEY (`id`) USING BTREE
    259. 

  259. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='路由配置表';
    260. 

  260. 

  261. -- ----------------------------
    262. 

  262. --  Records of `sys_route_conf`
    263. 

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

  264. BEGIN;
    265. 

  265. INSERT INTO `sys_route_conf` VALUES ('1', '工作流管理模块', 'pigx-activiti', '[{\"args\": {\"_genkey_0\": \"/act/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-activiti', '0', '2019-03-26 22:46:09', '2019-03-26 22:47:46', '0'), ('2', '认证中心', 'pigx-auth', '[{\"args\": {\"_genkey_0\": \"/auth/**\"}, \"name\": \"Path\"}]', '[{\"args\": {}, \"name\": \"ValidateCodeGatewayFilter\"}, {\"args\": {}, \"name\": \"PasswordDecoderFilter\"}]', 'lb://pigx-auth', '0', '2019-03-26 22:46:09', '2019-03-26 22:47:48', '0'), ('3', '代码生成模块', 'pigx-codegen', '[{\"args\": {\"_genkey_0\": \"/gen/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-codegen', '0', '2019-03-26 22:46:09', '2019-03-26 22:47:52', '0'), ('4', 'elastic-job定时任务模块', 'pigx-daemon-elastic-job', '[{\"args\": {\"_genkey_0\": \"/daemon/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-daemon-elastic-job', '0', '2019-03-26 22:46:09', '2019-03-26 22:47:59', '0'), ('5', 'quartz定时任务模块', 'pigx-daemon-quartz', '[{\"args\": {\"_genkey_0\": \"/job/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-daemon-quartz', '0', '2019-03-26 22:46:09', '2019-03-26 22:48:02', '0'), ('6', '分布式事务模块', 'pigx-tx-manager', '[{\"args\": {\"_genkey_0\": \"/tx/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-tx-manager', '0', '2019-03-26 22:46:09', '2019-03-26 22:48:04', '0'), ('7', '通用权限模块', 'pigx-upms-biz', '[{\"args\": {\"_genkey_0\": \"/admin/**\"}, \"name\": \"Path\"}]', '[{\"args\": {\"key-resolver\": \"#{@remoteAddrKeyResolver}\", \"redis-rate-limiter.burstCapacity\": \"20\", \"redis-rate-limiter.replenishRate\": \"10\"}, \"name\": \"RequestRateLimiter\"}, {\"args\": {\"name\": \"default\", \"fallbackUri\": \"forward:/fallback\"}, \"name\": \"Hystrix\"}]', 'lb://pigx-upms-biz', '0', '2019-03-26 22:46:09', '2019-03-26 22:48:07', '0'), ('8', '工作流长链接支持1', 'pigx-activiti-ws-1', '[{\"args\": {\"_genkey_0\": \"/act/ws/info/**\"}, \"name\": \"Path\"}]', '[]', 'lb://pigx-activiti', '0', '2019-03-26 22:46:09', '2019-03-26 22:48:10', '0'), ('9', '工作流长链接支持2', 'pigx-activiti-ws-2', '[{\"args\": {\"_genkey_0\": \"/act/ws/**\"}, \"name\": \"Path\"}]', '[]', 'lb:ws://pigx-activiti', '100', '2019-03-26 22:46:09', '2019-03-26 22:48:13', '0');
    266. 

  266. COMMIT;
    267. 

  267. 

  268. -- ----------------------------
    269. 

  269. --  Table structure for `sys_social_details`
    270. 

  270. -- ----------------------------
    271. 

  271. DROP TABLE IF EXISTS `sys_social_details`;
    272. 

  272. CREATE TABLE `sys_social_details` (
    273. 

  273.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
    274. 

  274.   `type` varchar(16) NOT NULL COMMENT '类型',
    275. 

  275.   `remark` varchar(64) DEFAULT NULL COMMENT '描述',
    276. 

  276.   `app_id` varchar(64) NOT NULL COMMENT 'appid',
    277. 

  277.   `app_secret` varchar(64) NOT NULL COMMENT 'app_secret',
    278. 

  278.   `redirect_url` varchar(128) DEFAULT NULL COMMENT '回调地址',
    279. 

  279.   `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    280. 

  280.   `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    281. 

  281.   `del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
    282. 

  282.   `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    283. 

  283.   PRIMARY KEY (`id`) USING BTREE
    284. 

  284. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统社交登录账号表';
    285. 

  285. 

  286. -- ----------------------------
    287. 

  287. --  Records of `sys_social_details`
    288. 

  288. -- ----------------------------
    289. 

  289. BEGIN;
    290. 

  290. INSERT INTO `sys_social_details` VALUES ('1', 'WX', '微信互联参数', 'wxd1678d3f83b1d83a', '6ddb043f94da5d2172926abe8533504f', 'daoweicloud.com', '2018-08-16 14:24:25', '2019-03-02 09:43:13', '0', '1');
    291. 

  291. COMMIT;
    292. 

  292. 

  293. -- ----------------------------
    294. 

  294. --  Table structure for `sys_user`
    295. 

  295. -- ----------------------------
    296. 

  296. DROP TABLE IF EXISTS `sys_user`;
    297. 

  297. CREATE TABLE `sys_user` (
    298. 

  298.   `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    299. 

  299.   `username` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
    300. 

  300.   `password` varchar(255) COLLATE utf8mb4_bin NOT NULL,
    301. 

  301.   `salt` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '随机盐',
    302. 

  302.   `phone` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '简介',
    303. 

  303.   `avatar` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
    304. 

  304.   `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
    305. 

  305.   `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    306. 

  306.   `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    307. 

  307.   `lock_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '0-正常，9-锁定',
    308. 

  308.   `del_flag` char(1) COLLATE utf8mb4_bin DEFAULT '0' COMMENT '0-正常，1-删除',
    309. 

  309.   `wx_openid` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '微信openid',
    310. 

  310.   `qq_openid` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'QQ openid',
    311. 

  311.   `tenant_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    312. 

  312.   PRIMARY KEY (`user_id`) USING BTREE,
    313. 

  313.   KEY `user_wx_openid` (`wx_openid`) USING BTREE,
    314. 

  314.   KEY `user_qq_openid` (`qq_openid`) USING BTREE,
    315. 

  315.   KEY `user_idx1_username` (`username`) USING BTREE
    316. 

  316. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户表';
    317. 

  317. 

  318. -- ----------------------------
    319. 

  319. --  Records of `sys_user`
    320. 

  320. -- ----------------------------
    321. 

  321. BEGIN;
    322. 

  322. INSERT INTO `sys_user` VALUES ('1', 'admin', '$2a$10$QOfWxxFyAMmEEmnuw9UI/..1s4B4eF/u9PzE2ZaGO.ij9YfmcUy.u', '', '17034642889', 'lengleng-6f69b3917f1a47c58e805e3f0f33894c.jpeg', '1', '2018-04-20 07:15:18', '2019-03-30 08:23:55', '0', '0', 'o_0FT0uyg_H1vVy2H0JpSwlVGhWQ', null, '1'), ('2', 'admin', '$2a$10$RpFJjxYiXdEsAGnWp/8fsOetMuOON96Ntk/Ym2M/RKRyU0GZseaDC', null, '17034642887', 'lengleng-6f69b3917f1a47c58e805e3f0f33894c.jpeg', '10', '2018-04-20 07:15:18', '2019-01-09 11:06:24', '0', '0', 'o_0FT0uyg_H1vVy2H0JpSwlVGhWQ', null, '2');
    323. 

  323. COMMIT;
    324. 

  324. 

  325. -- ----------------------------
    326. 

  326. --  Table structure for `sys_user_role`
    327. 

  327. -- ----------------------------
    328. 

  328. DROP TABLE IF EXISTS `sys_user_role`;
    329. 

  329. CREATE TABLE `sys_user_role` (
    330. 

  330.   `user_id` int(11) NOT NULL COMMENT '用户ID',
    331. 

  331.   `role_id` int(11) NOT NULL COMMENT '角色ID',
    332. 

  332.   PRIMARY KEY (`user_id`,`role_id`) USING BTREE
    333. 

  333. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色表';
    334. 

  334. 

  335. -- ----------------------------
    336. 

  336. --  Records of `sys_user_role`
    337. 

  337. -- ----------------------------
    338. 

  338. BEGIN;
    339. 

  339. INSERT INTO `sys_user_role` VALUES ('1', '1'), ('2', '2');
    340. 

  340. COMMIT;
    341. 

  341. 

  342. SET FOREIGN_KEY_CHECKS = 1;
    343.