zhangzl
/
nsgk_official_account
1
0
Forka 0
Codice Problemi 0 Pull Requests 0 Rilasci 0 Wiki Attività
公众号
Non puoi selezionare più di 25 argomenti Gli argomenti devono iniziare con una lettera o un numero, possono includere trattini ('-') e possono essere lunghi fino a 35 caratteri.
11 Commit
1 Ramo (Branch)
194 KiB
 
 
 
Ramo (Branch): master
Rami (Branch) Tag
${ item.name }
Crea branch ${ searchTerm }
da 'master'
${ noResults }
nsgk_official_account/db/mysql-0.7.0.sql

391 righe
24 KiB
Originale Permalink Blame Cronologia 

  1. /*

  2.  V0.7.0 完整脚本，由于本次升级大量重构，不提供升级脚本，请备份重要数据后升级

  3.  Author: Nifury

  4.  Date: 19/06/2020

  5. */

  6. 

  7. SET NAMES utf8mb4;

  8. SET FOREIGN_KEY_CHECKS = 0;

  9. 

  10. -- ----------------------------

  11. -- Table structure for cms_article

  12. -- ----------------------------

  13. DROP TABLE IF EXISTS `article`;

  14. DROP TABLE IF EXISTS `cms_article`;

  15. CREATE TABLE `cms_article`  (

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

  17.   `type` tinyint(1) NULL DEFAULT 1 COMMENT '文章类型[1:普通文章,5:帮助中心]',

  18.   `title` varchar(1024) CHARACTER SET utf8 NOT NULL COMMENT '标题',

  19.   `summary` varchar(1024) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '文章摘要',

  20.   `tags` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '文章标签',

  21.   `content` longtext CHARACTER SET utf8 NULL COMMENT '内容',

  22.   `category` varchar(25) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '分类',

  23.   `sub_category` varchar(25) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '二级目录',

  24.   `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  25.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',

  26.   `open_count` int(11) NULL DEFAULT 0 COMMENT '点击次数',

  27.   `start_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '生效时间',

  28.   `end_time` datetime(0) NULL DEFAULT NULL COMMENT '失效时间',

  29.   `target_link` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '指向外链',

  30.   `image` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '文章首图',

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

  32.   UNIQUE INDEX `idx_title`(`title`) USING BTREE COMMENT '标题不得重复'

  33. ) ENGINE = InnoDB AUTO_INCREMENT = 337 CHARACTER SET = utf8 COMMENT = 'CMS文章中心' ROW_FORMAT = Dynamic;

  34. 

  35. -- ----------------------------

  36. -- Table structure for sys_captcha

  37. -- ----------------------------

  38. DROP TABLE IF EXISTS `sys_captcha`;

  39. CREATE TABLE `sys_captcha`  (

  40.   `uuid` char(36) CHARACTER SET utf8mb4 NOT NULL COMMENT 'uuid',

  41.   `code` varchar(6) CHARACTER SET utf8mb4 NOT NULL COMMENT '验证码',

  42.   `expire_time` datetime(0) NULL DEFAULT NULL COMMENT '过期时间',

  43.   PRIMARY KEY (`uuid`) USING BTREE

  44. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = '系统验证码' ROW_FORMAT = Dynamic;

  45. 

  46. -- ----------------------------

  47. -- Table structure for sys_config

  48. -- ----------------------------

  49. DROP TABLE IF EXISTS `sys_config`;

  50. CREATE TABLE `sys_config`  (

  51.   `id` bigint(20) NOT NULL AUTO_INCREMENT,

  52.   `param_key` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT 'key',

  53.   `param_value` varchar(2000) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT 'value',

  54.   `status` tinyint(4) NULL DEFAULT 1 COMMENT '状态   0：隐藏   1：显示',

  55.   `remark` varchar(500) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '备注',

  56.   PRIMARY KEY (`id`) USING BTREE,

  57.   UNIQUE INDEX `param_key`(`param_key`) USING BTREE

  58. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COMMENT = '系统配置信息表' ROW_FORMAT = Dynamic;

  59. 

  60. -- ----------------------------

  61. -- Records of sys_config

  62. -- ----------------------------

  63. INSERT INTO `sys_config` VALUES (1, 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":3,\"qiniuDomain\":\"\",\"qiniuPrefix\":\"\",\"qiniuAccessKey\":\"\",\"qiniuSecretKey\":\"\",\"qiniuBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudAppId\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\",\"qcloudRegion\":\"ap-guangzhou\"}', 0, '云存储配置信息');

  64. 

  65. -- ----------------------------

  66. -- Table structure for sys_log

  67. -- ----------------------------

  68. DROP TABLE IF EXISTS `sys_log`;

  69. CREATE TABLE `sys_log`  (

  70.   `id` bigint(20) NOT NULL AUTO_INCREMENT,

  71.   `username` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '用户名',

  72.   `operation` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '用户操作',

  73.   `method` varchar(200) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '请求方法',

  74.   `params` varchar(5000) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '请求参数',

  75.   `time` bigint(20) NULL DEFAULT NULL COMMENT '执行时长(毫秒)',

  76.   `ip` varchar(64) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT 'IP地址',

  77.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  78.   PRIMARY KEY (`id`) USING BTREE

  79. ) ENGINE = InnoDB AUTO_INCREMENT = 324 CHARACTER SET = utf8mb4 COMMENT = '系统日志' ROW_FORMAT = Dynamic;

  80. 

  81. -- ----------------------------

  82. -- Table structure for sys_menu

  83. -- ----------------------------

  84. DROP TABLE IF EXISTS `sys_menu`;

  85. CREATE TABLE `sys_menu`  (

  86.   `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,

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

  88.   `name` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '菜单名称',

  89.   `url` varchar(200) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '菜单URL',

  90.   `perms` varchar(500) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',

  91.   `type` int(11) NULL DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',

  92.   `icon` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '菜单图标',

  93.   `order_num` int(11) NULL DEFAULT NULL COMMENT '排序',

  94.   PRIMARY KEY (`menu_id`) USING BTREE

  95. ) ENGINE = InnoDB AUTO_INCREMENT = 123 CHARACTER SET = utf8mb4 COMMENT = '菜单管理' ROW_FORMAT = Dynamic;

  96. 

  97. -- ----------------------------

  98. -- Records of sys_menu

  99. -- ----------------------------

  100. INSERT INTO `sys_menu` VALUES (1, 0, '系统管理', NULL, NULL, 0, 'el-icon-s-tools', 0);

  101. INSERT INTO `sys_menu` VALUES (2, 1, '管理员列表', 'sys/user', NULL, 1, 'admin', 1);

  102. INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', 'sys/role', NULL, 1, 'role', 2);

  103. INSERT INTO `sys_menu` VALUES (4, 1, '菜单管理', 'sys/menu', NULL, 1, 'menu', 3);

  104. INSERT INTO `sys_menu` VALUES (6, 0, '微信管理', NULL, NULL, 0, 'el-icon-s-promotion', 1);

  105. INSERT INTO `sys_menu` VALUES (7, 0, '内容管理', '', '', 0, 'el-icon-document-copy', 2);

  106. INSERT INTO `sys_menu` VALUES (9, 0, '日志报表', '', '', 0, 'el-icon-s-order', 4);

  107. INSERT INTO `sys_menu` VALUES (15, 2, '查看', NULL, 'sys:user:list,sys:user:info', 2, NULL, 0);

  108. INSERT INTO `sys_menu` VALUES (16, 2, '新增', NULL, 'sys:user:save,sys:role:select', 2, NULL, 0);

  109. INSERT INTO `sys_menu` VALUES (17, 2, '修改', NULL, 'sys:user:update,sys:role:select', 2, NULL, 0);

  110. INSERT INTO `sys_menu` VALUES (18, 2, '删除', NULL, 'sys:user:delete', 2, NULL, 0);

  111. INSERT INTO `sys_menu` VALUES (19, 3, '查看', NULL, 'sys:role:list,sys:role:info', 2, NULL, 0);

  112. INSERT INTO `sys_menu` VALUES (20, 3, '新增', NULL, 'sys:role:save,sys:menu:list', 2, NULL, 0);

  113. INSERT INTO `sys_menu` VALUES (21, 3, '修改', NULL, 'sys:role:update,sys:menu:list', 2, NULL, 0);

  114. INSERT INTO `sys_menu` VALUES (22, 3, '删除', NULL, 'sys:role:delete', 2, NULL, 0);

  115. INSERT INTO `sys_menu` VALUES (23, 4, '查看', NULL, 'sys:menu:list,sys:menu:info', 2, NULL, 0);

  116. INSERT INTO `sys_menu` VALUES (24, 4, '新增', NULL, 'sys:menu:save,sys:menu:select', 2, NULL, 0);

  117. INSERT INTO `sys_menu` VALUES (25, 4, '修改', NULL, 'sys:menu:update,sys:menu:select', 2, NULL, 0);

  118. INSERT INTO `sys_menu` VALUES (26, 4, '删除', NULL, 'sys:menu:delete', 2, NULL, 0);

  119. INSERT INTO `sys_menu` VALUES (27, 1, '参数管理', 'sys/config', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, 'config', 6);

  120. INSERT INTO `sys_menu` VALUES (29, 9, '系统日志', 'sys/log', 'sys:log:list', 1, 'log', 7);

  121. INSERT INTO `sys_menu` VALUES (30, 1, '文件上传', 'oss/oss', 'sys:oss:all', 1, 'oss', 6);

  122. INSERT INTO `sys_menu` VALUES (32, 6, '公众号菜单', 'wx/wx-menu', '', 1, 'log', 0);

  123. INSERT INTO `sys_menu` VALUES (33, 6, '素材管理', 'wx/wx-assets', '', 1, '', 0);

  124. INSERT INTO `sys_menu` VALUES (41, 7, '文章管理', 'wx/article', NULL, 1, 'config', 6);

  125. INSERT INTO `sys_menu` VALUES (42, 41, '查看', NULL, 'wx:article:list,wx:article:info', 2, NULL, 6);

  126. INSERT INTO `sys_menu` VALUES (43, 41, '新增', NULL, 'wx:article:save', 2, NULL, 6);

  127. INSERT INTO `sys_menu` VALUES (44, 41, '修改', NULL, 'wx:article:update', 2, NULL, 6);

  128. INSERT INTO `sys_menu` VALUES (45, 41, '删除', NULL, 'wx:article:delete', 2, NULL, 6);

  129. INSERT INTO `sys_menu` VALUES (66, 6, '自动回复规则', 'wx/msg-reply-rule', NULL, 1, 'config', 6);

  130. INSERT INTO `sys_menu` VALUES (67, 66, '查看', NULL, 'wx:msgreplyrule:list,wx:msgreplyrule:info', 2, NULL, 6);

  131. INSERT INTO `sys_menu` VALUES (68, 66, '新增', NULL, 'wx:msgreplyrule:save', 2, NULL, 6);

  132. INSERT INTO `sys_menu` VALUES (69, 66, '修改', NULL, 'wx:msgreplyrule:update', 2, NULL, 6);

  133. INSERT INTO `sys_menu` VALUES (70, 66, '删除', NULL, 'wx:msgreplyrule:delete', 2, NULL, 6);

  134. INSERT INTO `sys_menu` VALUES (71, 6, '模板消息', 'wx/msg-template', NULL, 1, 'config', 6);

  135. INSERT INTO `sys_menu` VALUES (72, 71, '查看', NULL, 'wx:msgtemplate:list,wx:msgtemplate:info', 2, NULL, 6);

  136. INSERT INTO `sys_menu` VALUES (73, 71, '新增', NULL, 'wx:msgtemplate:save', 2, NULL, 6);

  137. INSERT INTO `sys_menu` VALUES (74, 71, '修改', NULL, 'wx:msgtemplate:update', 2, NULL, 6);

  138. INSERT INTO `sys_menu` VALUES (75, 71, '删除', NULL, 'wx:msgtemplate:delete', 2, NULL, 6);

  139. INSERT INTO `sys_menu` VALUES (81, 9, '模版消息发送记录', 'wx/template-msg-log', NULL, 1, 'config', 6);

  140. INSERT INTO `sys_menu` VALUES (84, 81, '列表', NULL, 'wx:templatemsglog:list', 2, NULL, 6);

  141. INSERT INTO `sys_menu` VALUES (85, 81, '删除', NULL, 'wx:templatemsglog:delete', 2, NULL, 6);

  142. INSERT INTO `sys_menu` VALUES (99, 32, '更新公众号菜单', '', 'wx:menu:save', 2, '', 0);

  143. INSERT INTO `sys_menu` VALUES (100, 33, '查看', '', 'wx:wxassets:list', 2, '', 0);

  144. INSERT INTO `sys_menu` VALUES (101, 33, '新增修改', '', 'wx:wxassets:save', 2, '', 0);

  145. INSERT INTO `sys_menu` VALUES (103, 6, '带参二维码', 'wx/wx-qrcode', NULL, 1, 'config', 6);

  146. INSERT INTO `sys_menu` VALUES (104, 103, '查看', NULL, 'wx:wxqrcode:list,wx:wxqrcode:info', 2, NULL, 6);

  147. INSERT INTO `sys_menu` VALUES (105, 103, '新增', NULL, 'wx:wxqrcode:save', 2, NULL, 6);

  148. INSERT INTO `sys_menu` VALUES (107, 103, '删除', NULL, 'wx:wxqrcode:delete', 2, NULL, 6);

  149. INSERT INTO `sys_menu` VALUES (108, 6, '粉丝管理', 'wx/wx-user', NULL, 1, 'config', 6);

  150. INSERT INTO `sys_menu` VALUES (109, 108, '查看', NULL, 'wx:wxuser:list,wx:wxuser:info', 2, NULL, 6);

  151. INSERT INTO `sys_menu` VALUES (110, 108, '删除', NULL, 'wx:wxuser:delete', 2, NULL, 6);

  152. INSERT INTO `sys_menu` VALUES (111, 108, '同步', '', 'wx:wxuser:save', 2, '', 6);

  153. INSERT INTO `sys_menu` VALUES (112, 33, '删除', '', 'wx:wxassets:delete', 2, '', 0);

  154. INSERT INTO `sys_menu` VALUES (113, 6, '公众号消息', 'wx/wx-msg', NULL, 1, '', 6);

  155. INSERT INTO `sys_menu` VALUES (114, 113, '查看', NULL, 'wx:wxmsg:list,wx:wxmsg:info', 2, NULL, 6);

  156. INSERT INTO `sys_menu` VALUES (115, 113, '新增', NULL, 'wx:wxmsg:save', 2, NULL, 6);

  157. INSERT INTO `sys_menu` VALUES (117, 113, '删除', NULL, 'wx:wxmsg:delete', 2, NULL, 6);

  158. INSERT INTO `sys_menu` VALUES (118, 6, '公众号账号', 'wx/wx-account', NULL, 1, 'config', 6);

  159. INSERT INTO `sys_menu` VALUES (119, 118, '查看', NULL, 'wx:wxaccount:list,wx:wxaccount:info', 2, NULL, 6);

  160. INSERT INTO `sys_menu` VALUES (120, 118, '新增', NULL, 'wx:wxaccount:save', 2, NULL, 6);

  161. INSERT INTO `sys_menu` VALUES (121, 118, '修改', NULL, 'wx:wxaccount:update', 2, NULL, 6);

  162. INSERT INTO `sys_menu` VALUES (122, 118, '删除', NULL, 'wx:wxaccount:delete', 2, NULL, 6);

  163. 

  164. -- ----------------------------

  165. -- Table structure for sys_oss

  166. -- ----------------------------

  167. DROP TABLE IF EXISTS `sys_oss`;

  168. CREATE TABLE `sys_oss`  (

  169.   `id` bigint(20) NOT NULL AUTO_INCREMENT,

  170.   `url` varchar(200) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT 'URL地址',

  171.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  172.   PRIMARY KEY (`id`) USING BTREE

  173. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COMMENT = '文件上传' ROW_FORMAT = Dynamic;

  174. 

  175. -- ----------------------------

  176. -- Table structure for sys_role

  177. -- ----------------------------

  178. DROP TABLE IF EXISTS `sys_role`;

  179. CREATE TABLE `sys_role`  (

  180.   `role_id` bigint(20) NOT NULL AUTO_INCREMENT,

  181.   `role_name` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '角色名称',

  182.   `remark` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '备注',

  183.   `create_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建者ID',

  184.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  185.   PRIMARY KEY (`role_id`) USING BTREE

  186. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = '角色' ROW_FORMAT = Dynamic;

  187. 

  188. -- ----------------------------

  189. -- Table structure for sys_role_menu

  190. -- ----------------------------

  191. DROP TABLE IF EXISTS `sys_role_menu`;

  192. CREATE TABLE `sys_role_menu`  (

  193.   `id` bigint(20) NOT NULL AUTO_INCREMENT,

  194.   `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',

  195.   `menu_id` bigint(20) NULL DEFAULT NULL COMMENT '菜单ID',

  196.   PRIMARY KEY (`id`) USING BTREE

  197. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = '角色与菜单对应关系' ROW_FORMAT = Dynamic;

  198. 

  199. -- ----------------------------

  200. -- Table structure for sys_user

  201. -- ----------------------------

  202. DROP TABLE IF EXISTS `sys_user`;

  203. CREATE TABLE `sys_user`  (

  204.   `user_id` bigint(20) NOT NULL AUTO_INCREMENT,

  205.   `username` varchar(50) CHARACTER SET utf8mb4 NOT NULL COMMENT '用户名',

  206.   `password` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '密码',

  207.   `salt` varchar(20) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '盐',

  208.   `email` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '邮箱',

  209.   `mobile` varchar(100) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '手机号',

  210.   `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0：禁用   1：正常',

  211.   `create_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建者ID',

  212.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',

  213.   PRIMARY KEY (`user_id`) USING BTREE,

  214.   UNIQUE INDEX `username`(`username`) USING BTREE

  215. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COMMENT = '系统用户' ROW_FORMAT = Dynamic;

  216. 

  217. -- ----------------------------

  218. -- Records of sys_user

  219. -- ----------------------------

  220. INSERT INTO `sys_user` VALUES (1, 'admin', 'cdac762d0ba79875489f6a8b430fa8b5dfe0cdd81da38b80f02f33328af7fd4a', 'YzcmCZNvbXocrsz9dm8e', 'niefy@qq.com', '16666666666', 1, 1, '2016-11-11 11:11:11');

  221. 

  222. -- ----------------------------

  223. -- Table structure for sys_user_role

  224. -- ----------------------------

  225. DROP TABLE IF EXISTS `sys_user_role`;

  226. CREATE TABLE `sys_user_role`  (

  227.   `id` bigint(20) NOT NULL AUTO_INCREMENT,

  228.   `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户ID',

  229.   `role_id` bigint(20) NULL DEFAULT NULL COMMENT '角色ID',

  230.   PRIMARY KEY (`id`) USING BTREE

  231. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COMMENT = '用户与角色对应关系' ROW_FORMAT = Dynamic;

  232. 

  233. -- ----------------------------

  234. -- Table structure for sys_user_token

  235. -- ----------------------------

  236. DROP TABLE IF EXISTS `sys_user_token`;

  237. CREATE TABLE `sys_user_token`  (

  238.   `user_id` bigint(20) NOT NULL,

  239.   `token` varchar(100) CHARACTER SET utf8mb4 NOT NULL COMMENT 'token',

  240.   `expire_time` datetime(0) NULL DEFAULT NULL COMMENT '过期时间',

  241.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',

  242.   PRIMARY KEY (`user_id`) USING BTREE,

  243.   UNIQUE INDEX `token`(`token`) USING BTREE

  244. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = '系统用户Token' ROW_FORMAT = Dynamic;

  245. 

  246. -- ----------------------------

  247. -- Table structure for wx_account

  248. -- ----------------------------

  249. DROP TABLE IF EXISTS `wx_account`;

  250. CREATE TABLE `wx_account`  (

  251.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  252.   `name` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '公众号名称',

  253.   `type` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '账号类型',

  254.   `verified` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '认证状态',

  255.   `secret` char(32) CHARACTER SET utf8 NOT NULL COMMENT 'appsecret',

  256.   `token` varchar(32) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT 'token',

  257.   `aes_key` varchar(43) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT 'aesKey',

  258.   PRIMARY KEY (`appid`) USING BTREE

  259. ) ENGINE = InnoDB CHARACTER SET = utf8 COMMENT = '公众号账号' ROW_FORMAT = Dynamic;

  260. 

  261. -- ----------------------------

  262. -- Table structure for wx_msg

  263. -- ----------------------------

  264. DROP TABLE IF EXISTS `wx_msg`;

  265. CREATE TABLE `wx_msg`  (

  266.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

  267.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  268.   `openid` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '微信用户ID',

  269.   `in_out` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '消息方向',

  270.   `msg_type` char(25) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '消息类型',

  271.   `detail` json NULL COMMENT '消息详情',

  272.   `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  273.   PRIMARY KEY (`id`) USING BTREE,

  274.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  275. ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COMMENT = '微信消息' ROW_FORMAT = Dynamic;

  276. 

  277. -- ----------------------------

  278. -- Table structure for wx_msg_reply_rule

  279. -- ----------------------------

  280. DROP TABLE IF EXISTS `msg_reply_rule`;

  281. DROP TABLE IF EXISTS `wx_msg_reply_rule`;

  282. CREATE TABLE `wx_msg_reply_rule`  (

  283.   `rule_id` int(11) NOT NULL AUTO_INCREMENT,

  284.   `appid` char(20) CHARACTER SET utf8 NULL DEFAULT '' COMMENT 'appid',

  285.   `rule_name` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '规则名称',

  286.   `match_value` varchar(200) CHARACTER SET utf8 NOT NULL COMMENT '匹配的关键词、事件等',

  287.   `exact_match` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否精确匹配',

  288.   `reply_type` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '1' COMMENT '回复消息类型',

  289.   `reply_content` varchar(1024) CHARACTER SET utf8 NOT NULL COMMENT '回复消息内容',

  290.   `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '规则是否有效',

  291.   `desc` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '备注说明',

  292.   `effect_time_start` time(0) NULL DEFAULT '00:00:00' COMMENT '生效起始时间',

  293.   `effect_time_end` time(0) NULL DEFAULT '23:59:59' COMMENT '生效结束时间',

  294.   `priority` int(3) UNSIGNED NULL DEFAULT 0 COMMENT '规则优先级',

  295.   `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',

  296.   PRIMARY KEY (`rule_id`) USING BTREE,

  297.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  298. ) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COMMENT = '自动回复规则' ROW_FORMAT = Dynamic;

  299. 

  300. -- ----------------------------

  301. -- Records of wx_msg_reply_rule

  302. -- ----------------------------

  303. INSERT INTO `wx_msg_reply_rule` VALUES (1, '', '关注公众号', 'subscribe', 0, 'text', '你好，欢迎关注！\n<a href=\"https://github.com/niefy\">点击链接查看我的主页</a>', 1, '关注回复', '00:00:00', '23:59:59', 0, '2020-05-20 15:15:00');

  304. 

  305. -- ----------------------------

  306. -- Table structure for wx_msg_template

  307. -- ----------------------------

  308. DROP TABLE IF EXISTS `msg_template`;

  309. DROP TABLE IF EXISTS `wx_msg_template`;

  310. CREATE TABLE `wx_msg_template`  (

  311.   `id` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',

  312.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  313.   `template_id` varchar(100) CHARACTER SET utf8 NOT NULL COMMENT '公众号模板ID',

  314.   `name` varchar(50) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '模版名称',

  315.   `title` varchar(20) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '标题',

  316.   `content` text CHARACTER SET utf8 NULL COMMENT '模板内容',

  317.   `data` json NULL COMMENT '消息内容',

  318.   `url` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '链接',

  319.   `miniprogram` json NULL COMMENT '小程序信息',

  320.   `status` tinyint(1) UNSIGNED NOT NULL COMMENT '是否有效',

  321.   `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',

  322.   PRIMARY KEY (`id`) USING BTREE,

  323.   UNIQUE INDEX `idx_name`(`name`) USING BTREE COMMENT '模板名称',

  324.   INDEX `idx_status`(`status`) USING BTREE COMMENT '模板状态',

  325.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  326. ) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8 COMMENT = '消息模板' ROW_FORMAT = Dynamic;

  327. 

  328. 

  329. -- ----------------------------

  330. -- Table structure for wx_qr_code

  331. -- ----------------------------

  332. DROP TABLE IF EXISTS `wx_qr_code`;

  333. CREATE TABLE `wx_qr_code`  (

  334.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',

  335.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  336.   `is_temp` tinyint(1) NULL DEFAULT NULL COMMENT '是否为临时二维码',

  337.   `scene_str` varchar(64) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '场景值ID',

  338.   `ticket` varchar(255) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '二维码ticket',

  339.   `url` varchar(255) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '二维码图片解析后的地址',

  340.   `expire_time` datetime(0) NULL DEFAULT NULL COMMENT '该二维码失效时间',

  341.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '该二维码创建时间',

  342.   PRIMARY KEY (`id`) USING BTREE,

  343.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  344. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COMMENT = '公众号带参二维码' ROW_FORMAT = Dynamic;

  345. 

  346. -- ----------------------------

  347. -- Table structure for wx_template_msg_log

  348. -- ----------------------------

  349. DROP TABLE IF EXISTS `template_msg_log`;

  350. DROP TABLE IF EXISTS `wx_template_msg_log`;

  351. CREATE TABLE `wx_template_msg_log`  (

  352.   `log_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

  353.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  354.   `touser` varchar(50) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '用户openid',

  355.   `template_id` varchar(50) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT 'templateid',

  356.   `data` json NULL COMMENT '消息数据',

  357.   `url` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '消息链接',

  358.   `miniprogram` json NULL COMMENT '小程序信息',

  359.   `send_time` datetime(0) NULL DEFAULT NULL COMMENT '发送时间',

  360.   `send_result` varchar(255) CHARACTER SET utf8 NULL DEFAULT NULL COMMENT '发送结果',

  361.   PRIMARY KEY (`log_id`) USING BTREE,

  362.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  363. ) ENGINE = InnoDB AUTO_INCREMENT = 116250 CHARACTER SET = utf8 COMMENT = '微信模版消息发送记录' ROW_FORMAT = Dynamic;

  364. 

  365. -- ----------------------------

  366. -- Table structure for wx_user

  367. -- ----------------------------

  368. DROP TABLE IF EXISTS `wx_user`;

  369. CREATE TABLE `wx_user`  (

  370.   `openid` varchar(50) CHARACTER SET utf8mb4 NOT NULL COMMENT '微信openid',

  371.   `appid` char(20) CHARACTER SET utf8 NOT NULL COMMENT 'appid',

  372.   `phone` char(11) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '手机号',

  373.   `nickname` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '昵称',

  374.   `sex` tinyint(4) NULL DEFAULT NULL COMMENT '性别(0-未知、1-男、2-女)',

  375.   `city` varchar(20) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '城市',

  376.   `province` varchar(20) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '省份',

  377.   `headimgurl` varchar(255) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '头像',

  378.   `subscribe_time` datetime(0) NULL DEFAULT NULL COMMENT '订阅时间',

  379.   `subscribe` tinyint(3) UNSIGNED NULL DEFAULT 1 COMMENT '是否关注',

  380.   `unionid` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT 'unionid',

  381.   `remark` varchar(255) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '备注',

  382.   `tagid_list` json NULL COMMENT '标签ID列表',

  383.   `subscribe_scene` varchar(50) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '关注场景',

  384.   `qr_scene_str` varchar(64) CHARACTER SET utf8mb4 NULL DEFAULT NULL COMMENT '扫码场景值',

  385.   PRIMARY KEY (`openid`) USING BTREE,

  386.   INDEX `idx_unionid`(`unionid`) USING BTREE COMMENT 'unionid',

  387.   INDEX `idx_appid`(`appid`) USING BTREE COMMENT 'appid'

  388. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COMMENT = '用户表' ROW_FORMAT = Dynamic;

  389. 

  390. SET FOREIGN_KEY_CHECKS = 1;