master

分支 (1)

管理

管理

master

introduction-blog
/
myblog.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 本地localhost
 Source Server Type    : MySQL
 Source Server Version : 80012 (8.0.12)
 Source Host           : localhost:3306
 Source Schema         : myblog

 Target Server Type    : MySQL
 Target Server Version : 80012 (8.0.12)
 File Encoding         : 65001

 Date: 04/10/2023 16:23:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `version` bigint(20) NOT NULL,
  `migration_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `end_time` timestamp NULL DEFAULT NULL,
  `breakpoint` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`version`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (20221013031925, 'InstallAdmin', '2023-09-29 19:12:34', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013031926, 'InstallAdminData', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013031927, 'InstallAdmin20230325', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013031928, 'InstallAdmin20230621', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013045829, 'InstallWechat', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013045830, 'InstallWechatData', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013045831, 'UpdateWechat20230628', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);
INSERT INTO `migrations` VALUES (20221013045832, 'InstallWechat20230628', '2023-09-29 19:12:35', '2023-09-29 19:12:35', 0);

-- ----------------------------
-- Table structure for system_auth
-- ----------------------------
DROP TABLE IF EXISTS `system_auth`;
CREATE TABLE `system_auth`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '权限名称',
  `utype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '身份权限',
  `desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注说明',
  `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序权重',
  `status` int(1) NULL DEFAULT 1 COMMENT '权限状态(1使用,0禁用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_auth_sort`(`sort` ASC) USING BTREE,
  INDEX `idx_system_auth_title`(`title` ASC) USING BTREE,
  INDEX `idx_system_auth_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_auth
-- ----------------------------
INSERT INTO `system_auth` VALUES (1, '博客写手', '', '123', 0, 1, '2023-10-02 19:50:07');

-- ----------------------------
-- Table structure for system_auth_node
-- ----------------------------
DROP TABLE IF EXISTS `system_auth_node`;
CREATE TABLE `system_auth_node`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `auth` bigint(20) NULL DEFAULT 0 COMMENT '角色',
  `node` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '节点',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_auth_node_auth`(`auth` ASC) USING BTREE,
  INDEX `idx_system_auth_node_node`(`node` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-授权' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_auth_node
-- ----------------------------
INSERT INTO `system_auth_node` VALUES (1, 1, 'admin');
INSERT INTO `system_auth_node` VALUES (2, 1, 'admin/article');
INSERT INTO `system_auth_node` VALUES (3, 1, 'admin/article/index');

-- ----------------------------
-- Table structure for system_base
-- ----------------------------
DROP TABLE IF EXISTS `system_base`;
CREATE TABLE `system_base`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '数据类型',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '数据代码',
  `name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '数据名称',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '数据内容',
  `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序权重',
  `status` int(1) NULL DEFAULT 1 COMMENT '数据状态(0禁用,1启动)',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '删除状态(0正常,1已删)',
  `deleted_at` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '删除时间',
  `deleted_by` bigint(20) NULL DEFAULT 0 COMMENT '删除用户',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_base_type`(`type` ASC) USING BTREE,
  INDEX `idx_system_base_code`(`code` ASC) USING BTREE,
  INDEX `idx_system_base_name`(`name` ASC) USING BTREE,
  INDEX `idx_system_base_sort`(`sort` ASC) USING BTREE,
  INDEX `idx_system_base_status`(`status` ASC) USING BTREE,
  INDEX `idx_system_base_deleted`(`deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-字典' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_base
-- ----------------------------
INSERT INTO `system_base` VALUES (1, '网站信息', 'TDK_KEYS', '网站关键词', '博客,php,mysql', 0, 1, 0, '', 0, '2023-10-04 10:55:59');
INSERT INTO `system_base` VALUES (2, '网站信息', 'TDK_DESC', '网站描述', '我的博客，记录学习的笔记、心得！', 0, 1, 0, '', 0, '2023-10-04 10:57:09');
INSERT INTO `system_base` VALUES (3, '网站信息', 'TDK_TITLE', '网站标题', 'MyBLOG我的博客', 0, 1, 0, '', 0, '2023-10-04 10:59:21');

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置分类',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置名称',
  `value` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置内容',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_config_type`(`type` ASC) USING BTREE,
  INDEX `idx_system_config_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-配置' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_config
-- ----------------------------
INSERT INTO `system_config` VALUES (1, 'base', 'app_name', 'ThinkAdmin');
INSERT INTO `system_config` VALUES (2, 'base', 'app_version', 'v6');
INSERT INTO `system_config` VALUES (3, 'base', 'editor', 'ckeditor5');
INSERT INTO `system_config` VALUES (4, 'base', 'login_name', '系统管理');
INSERT INTO `system_config` VALUES (5, 'base', 'site_copy', '©版权所有 2014-2023 ThinkAdmin');
INSERT INTO `system_config` VALUES (6, 'base', 'site_icon', 'https://doc.thinkadmin.top/static/img/logo.png');
INSERT INTO `system_config` VALUES (7, 'base', 'site_name', 'ThinkAdmin');
INSERT INTO `system_config` VALUES (8, 'base', 'site_theme', 'default');
INSERT INTO `system_config` VALUES (9, 'storage', 'allow_exts', 'doc,gif,ico,jpg,mp3,mp4,p12,pem,png,zip,rar,xls,xlsx');
INSERT INTO `system_config` VALUES (10, 'storage', 'type', 'local');
INSERT INTO `system_config` VALUES (11, 'wechat', 'type', 'api');
INSERT INTO `system_config` VALUES (12, 'base', 'site_host', 'http://myblog');
INSERT INTO `system_config` VALUES (13, 'storage', 'link_type', 'none');
INSERT INTO `system_config` VALUES (14, 'storage', 'name_type', 'xmd5');
INSERT INTO `system_config` VALUES (15, 'storage', 'local_http_protocol', 'follow');

-- ----------------------------
-- Table structure for system_data
-- ----------------------------
DROP TABLE IF EXISTS `system_data`;
CREATE TABLE `system_data`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置名',
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置值',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_data_name`(`name` ASC) USING BTREE,
  INDEX `idx_system_data_create_time`(`create_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_data
-- ----------------------------

-- ----------------------------
-- Table structure for system_file
-- ----------------------------
DROP TABLE IF EXISTS `system_file`;
CREATE TABLE `system_file`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '上传类型',
  `hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件哈希',
  `tags` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件标签',
  `name` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件名称',
  `xext` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件后缀',
  `xurl` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '访问链接',
  `xkey` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件路径',
  `mime` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件类型',
  `size` bigint(20) NULL DEFAULT 0 COMMENT '文件大小',
  `uuid` bigint(20) NULL DEFAULT 0 COMMENT '用户编号',
  `unid` bigint(20) NULL DEFAULT 0 COMMENT '会员编号',
  `isfast` int(1) NULL DEFAULT 0 COMMENT '是否秒传',
  `issafe` int(1) NULL DEFAULT 0 COMMENT '安全模式',
  `status` int(1) NULL DEFAULT 1 COMMENT '上传状态(1悬空,2落地)',
  `create_at` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_file_type`(`type` ASC) USING BTREE,
  INDEX `idx_system_file_hash`(`hash` ASC) USING BTREE,
  INDEX `idx_system_file_uuid`(`uuid` ASC) USING BTREE,
  INDEX `idx_system_file_xext`(`xext` ASC) USING BTREE,
  INDEX `idx_system_file_unid`(`unid` ASC) USING BTREE,
  INDEX `idx_system_file_tags`(`tags` ASC) USING BTREE,
  INDEX `idx_system_file_name`(`name` ASC) USING BTREE,
  INDEX `idx_system_file_status`(`status` ASC) USING BTREE,
  INDEX `idx_system_file_issafe`(`issafe` ASC) USING BTREE,
  INDEX `idx_system_file_isfast`(`isfast` ASC) USING BTREE,
  INDEX `idx_system_file_create_at`(`create_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_file
-- ----------------------------
INSERT INTO `system_file` VALUES (1, 'local', 'f319477c1d30a15d4adafaf286cdd05c', '', '5e5410543580f51155f8c3993db13033.jpg', 'jpg', 'http://myblog/upload/f3/19477c1d30a15d4adafaf286cdd05c.jpg', 'f3/19477c1d30a15d4adafaf286cdd05c.jpg', 'image/jpeg', 1360236, 10000, 0, 0, 0, 2, '2023-10-04 13:44:28', '2023-10-04 13:44:28');

-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` bigint(20) NULL DEFAULT 0 COMMENT '上级ID',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单名称',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单图标',
  `node` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '节点代码',
  `url` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '链接节点',
  `params` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '链接参数',
  `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '_self' COMMENT '打开方式',
  `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序权重',
  `status` int(1) NULL DEFAULT 1 COMMENT '状态(0:禁用,1:启用)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_menu_pid`(`pid` ASC) USING BTREE,
  INDEX `idx_system_menu_sort`(`sort` ASC) USING BTREE,
  INDEX `idx_system_menu_status`(`status` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-菜单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_menu
-- ----------------------------
INSERT INTO `system_menu` VALUES (1, 0, '系统管理', '', '', '#', '', '_self', 100, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (2, 1, '系统配置', '', '', '#', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (3, 2, '系统参数配置', 'layui-icon layui-icon-set', 'admin/config/index', 'admin/config/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (4, 2, '系统任务管理', 'layui-icon layui-icon-log', 'admin/queue/index', 'admin/queue/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (5, 2, '系统日志管理', 'layui-icon layui-icon-form', 'admin/oplog/index', 'admin/oplog/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (6, 2, '数据字典管理', 'layui-icon layui-icon-code-circle', 'admin/base/index', 'admin/base/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (7, 2, '系统文件管理', 'layui-icon layui-icon-carousel', 'admin/file/index', 'admin/file/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (8, 2, '系统菜单管理', 'layui-icon layui-icon-layouts', 'admin/menu/index', 'admin/menu/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (9, 1, '权限管理', '', '', '#', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (10, 9, '系统权限管理', 'layui-icon layui-icon-vercode', 'admin/auth/index', 'admin/auth/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (11, 9, '系统用户管理', 'layui-icon layui-icon-username', 'admin/user/index', 'admin/user/index', '', '_self', 0, 1, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (12, 0, '微信管理', '', '', '#', '', '_self', 200, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (13, 12, '微信管理', '', '', '#', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (14, 13, '微信接口配置', 'layui-icon layui-icon-set', 'wechat/config/options', 'wechat/config/options', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (15, 13, '微信支付配置', 'layui-icon layui-icon-rmb', 'wechat/config/payment', 'wechat/config/payment', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (16, 12, '微信定制', '', '', '#', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (17, 16, '微信粉丝管理', 'layui-icon layui-icon-username', 'wechat/fans/index', 'wechat/fans/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (18, 16, '微信图文管理', 'layui-icon layui-icon-template-1', 'wechat/news/index', 'wechat/news/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (19, 16, '微信菜单配置', 'layui-icon layui-icon-cellphone', 'wechat/menu/index', 'wechat/menu/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (20, 16, '回复规则管理', 'layui-icon layui-icon-engine', 'wechat/keys/index', 'wechat/keys/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (21, 16, '关注自动回复', 'layui-icon layui-icon-release', 'wechat/auto/index', 'wechat/auto/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (22, 12, '微信支付', '', '', '#', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (23, 22, '微信支付行为', 'layui-icon layui-icon-rmb', 'wechat/payment.record/index', 'wechat/payment.record/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (24, 22, '微信退款管理', 'layui-icon layui-icon-engine', 'wechat/payment.refund/index', 'wechat/payment.refund/index', '', '_self', 0, 0, '2023-09-29 19:12:35');
INSERT INTO `system_menu` VALUES (25, 0, '博客管理', '', '', '#', '', '_self', 110, 1, '2023-09-30 10:26:43');
INSERT INTO `system_menu` VALUES (26, 25, '博客文章', 'layui-icon layui-icon-read', '', 'admin/article/index', '', '_self', 0, 1, '2023-09-30 10:28:56');
INSERT INTO `system_menu` VALUES (27, 25, '分类管理', '', '', 'admin/category/index', '', '_self', 0, 1, '2023-10-02 14:50:13');
INSERT INTO `system_menu` VALUES (28, 25, '标签管理', '', 'admin/tag/index', 'admin/tag/index', '', '_self', 0, 1, '2023-10-02 15:20:38');
INSERT INTO `system_menu` VALUES (29, 25, '菜单管理', '', '', 'admin/blog.menu/index', '', '_self', 0, 1, '2023-10-02 19:36:06');

-- ----------------------------
-- Table structure for system_oplog
-- ----------------------------
DROP TABLE IF EXISTS `system_oplog`;
CREATE TABLE `system_oplog`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `node` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '当前操作节点',
  `geoip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作者IP地址',
  `action` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作行为名称',
  `content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作内容描述',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '操作人用户名',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_oplog_create_at`(`create_at` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_oplog
-- ----------------------------
INSERT INTO `system_oplog` VALUES (1, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-09-29 19:14:04');
INSERT INTO `system_oplog` VALUES (2, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-09-30 08:44:28');
INSERT INTO `system_oplog` VALUES (3, 'admin/menu/state', '127.0.0.1', '系统菜单管理', '修改系统菜单[,12,13,14,15,16,17,18,19,20,21,22,23,24,]状态', 'admin', '2023-09-30 08:44:41');
INSERT INTO `system_oplog` VALUES (4, 'admin/menu/state', '127.0.0.1', '系统菜单管理', '修改系统菜单[,1,2,3,4,5,6,7,8,9,10,11,]状态', 'admin', '2023-09-30 08:44:44');
INSERT INTO `system_oplog` VALUES (5, 'admin/menu/state', '127.0.0.1', '系统菜单管理', '修改系统菜单[,1,2,3,4,5,6,7,8,9,10,11,]状态', 'admin', '2023-09-30 08:44:49');
INSERT INTO `system_oplog` VALUES (6, 'admin/menu/add', '127.0.0.1', '系统菜单管理', '增加系统菜单[25]成功', 'admin', '2023-09-30 10:26:43');
INSERT INTO `system_oplog` VALUES (7, 'admin/menu/add', '127.0.0.1', '系统菜单管理', '增加系统菜单[26]成功', 'admin', '2023-09-30 10:28:56');
INSERT INTO `system_oplog` VALUES (8, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-02 13:47:47');
INSERT INTO `system_oplog` VALUES (9, 'admin/menu/add', '127.0.0.1', '系统菜单管理', '增加系统菜单[27]成功', 'admin', '2023-10-02 14:50:13');
INSERT INTO `system_oplog` VALUES (10, 'admin/menu/add', '127.0.0.1', '系统菜单管理', '增加系统菜单[28]成功', 'admin', '2023-10-02 15:20:38');
INSERT INTO `system_oplog` VALUES (11, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-02 19:35:22');
INSERT INTO `system_oplog` VALUES (12, 'admin/menu/add', '127.0.0.1', '系统菜单管理', '增加系统菜单[29]成功', 'admin', '2023-10-02 19:36:06');
INSERT INTO `system_oplog` VALUES (13, 'admin/auth/add', '127.0.0.1', '系统权限管理', '增加系统权限[1]成功', 'admin', '2023-10-02 19:50:07');
INSERT INTO `system_oplog` VALUES (14, 'admin/auth/apply', '127.0.0.1', '系统权限管理', '配置系统权限[1]授权成功', 'admin', '2023-10-02 19:55:02');
INSERT INTO `system_oplog` VALUES (15, 'admin/user/add', '127.0.0.1', '系统用户管理', '增加系统用户[10001]成功', 'admin', '2023-10-02 19:55:47');
INSERT INTO `system_oplog` VALUES (16, 'admin/user/pass', '127.0.0.1', '系统用户管理', '修改用户[10001]密码成功', 'admin', '2023-10-02 19:56:28');
INSERT INTO `system_oplog` VALUES (17, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin111', '2023-10-02 19:57:00');
INSERT INTO `system_oplog` VALUES (18, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-03 13:02:19');
INSERT INTO `system_oplog` VALUES (19, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-03 19:13:41');
INSERT INTO `system_oplog` VALUES (20, 'admin/api.system/debug', '127.0.0.1', '系统运维管理', '开发模式切换为生产模式', 'admin', '2023-10-03 19:13:48');
INSERT INTO `system_oplog` VALUES (21, 'admin/api.system/debug', '127.0.0.1', '系统运维管理', '生产模式切换为开发模式', 'admin', '2023-10-03 19:13:52');
INSERT INTO `system_oplog` VALUES (22, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-04 10:54:34');
INSERT INTO `system_oplog` VALUES (23, 'admin/base/add', '127.0.0.1', '数据字典管理', '增加数据字典[1]成功', 'admin', '2023-10-04 10:55:59');
INSERT INTO `system_oplog` VALUES (24, 'admin/base/add', '127.0.0.1', '数据字典管理', '增加数据字典[2]成功', 'admin', '2023-10-04 10:57:09');
INSERT INTO `system_oplog` VALUES (25, 'admin/base/add', '127.0.0.1', '数据字典管理', '增加数据字典[3]成功', 'admin', '2023-10-04 10:59:21');
INSERT INTO `system_oplog` VALUES (26, 'admin/login/index', '127.0.0.1', '系统用户登录', '登录系统后台成功', 'admin', '2023-10-04 13:42:48');

-- ----------------------------
-- Table structure for system_queue
-- ----------------------------
DROP TABLE IF EXISTS `system_queue`;
CREATE TABLE `system_queue`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务编号',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
  `command` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '执行指令',
  `exec_pid` bigint(20) NULL DEFAULT 0 COMMENT '执行进程',
  `exec_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行参数',
  `exec_time` bigint(20) NULL DEFAULT 0 COMMENT '执行时间',
  `exec_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '执行描述',
  `enter_time` decimal(20, 4) NULL DEFAULT 0.0000 COMMENT '开始时间',
  `outer_time` decimal(20, 4) NULL DEFAULT 0.0000 COMMENT '结束时间',
  `loops_time` bigint(20) NULL DEFAULT 0 COMMENT '循环时间',
  `attempts` bigint(20) NULL DEFAULT 0 COMMENT '执行次数',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '最新消息',
  `rscript` int(1) NULL DEFAULT 1 COMMENT '任务类型(0单例,1多例)',
  `status` int(1) NULL DEFAULT 1 COMMENT '任务状态(1新任务,2处理中,3成功,4失败)',
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_queue_code`(`code` ASC) USING BTREE,
  INDEX `idx_system_queue_title`(`title` ASC) USING BTREE,
  INDEX `idx_system_queue_status`(`status` ASC) USING BTREE,
  INDEX `idx_system_queue_rscript`(`rscript` ASC) USING BTREE,
  INDEX `idx_system_queue_create_at`(`create_at` ASC) USING BTREE,
  INDEX `idx_system_queue_exec_time`(`exec_time` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_queue
-- ----------------------------

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `usertype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户类型',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户账号',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户密码',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称',
  `headimg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像地址',
  `authorize` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '权限授权',
  `contact_qq` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '联系QQ',
  `contact_mail` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '联系邮箱',
  `contact_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '联系手机',
  `login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地址',
  `login_at` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录时间',
  `login_num` bigint(20) NULL DEFAULT 0 COMMENT '登录次数',
  `describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注说明',
  `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序权重',
  `status` int(1) NULL DEFAULT 1 COMMENT '状态(0禁用,1启用)',
  `is_deleted` int(1) NULL DEFAULT 0 COMMENT '删除(1删除,0未删)',
  `create_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_system_user_sort`(`sort` ASC) USING BTREE,
  INDEX `idx_system_user_status`(`status` ASC) USING BTREE,
  INDEX `idx_system_user_username`(`username` ASC) USING BTREE,
  INDEX `idx_system_user_is_deleted`(`is_deleted` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10002 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统-用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of system_user
-- ----------------------------
INSERT INTO `system_user` VALUES (10000, '', 'admin', '21232f297a57a5a743894a0e4a801fc3', '超级管理员', 'https://doc.thinkadmin.top/static/img/head.png', '', '', '', '', '127.0.0.1', '2023-10-04 13:42:48', 8, '', 0, 1, 0, '2023-09-29 19:12:35');
INSERT INTO `system_user` VALUES (10001, '', 'admin111', '40964277d7b8e3725ce913402ffd7c08', 'ajjaja', '', ',1,', '', '', '', '127.0.0.1', '2023-10-02 19:56:59', 1, '', 0, 1, 0, '2023-10-02 19:55:47');

-- ----------------------------
-- Table structure for zy_articles
-- ----------------------------
DROP TABLE IF EXISTS `zy_articles`;
CREATE TABLE `zy_articles`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '标题',
  `keys` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
  `summary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '简介',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
  `created_time` datetime NOT NULL COMMENT '创建时间',
  `class_id` int(11) NOT NULL DEFAULT 0 COMMENT '所属分类',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态：0未发布，1已发布',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zy_articles
-- ----------------------------
INSERT INTO `zy_articles` VALUES (2, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (3, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (4, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 1);
INSERT INTO `zy_articles` VALUES (5, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (6, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (7, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (8, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (9, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (10, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (11, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (12, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (13, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (14, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (15, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (16, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (17, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (18, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (19, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (20, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (21, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (22, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (23, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (24, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (25, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (26, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (27, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (28, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (29, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (30, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (31, '123', '123', '123', '<p>123</p>', '2023-10-02 12:52:50', 0, 1);
INSERT INTO `zy_articles` VALUES (32, 'aaaaa', '2222', '3333', '<p>44444444</p>', '2023-09-30 11:21:27', 1, 1);
INSERT INTO `zy_articles` VALUES (33, '文章1', '', '', '<p>123123</p>', '2023-09-30 11:23:08', 0, 1);
INSERT INTO `zy_articles` VALUES (34, '文章2', '123', '123', '<p>123123123123</p>', '2023-09-30 11:24:14', 0, 0);
INSERT INTO `zy_articles` VALUES (35, '123', '123', '123123', '<p>123123123</p>', '2023-10-02 12:51:20', 0, 1);
INSERT INTO `zy_articles` VALUES (37, 'PHP测试123', 'PHP测试方法,手动测试', '主要介绍一下自己去好好地测一下', '<p>好好试试全部的功能，及时发现问题和BUG12</p><figure class=\"image image_resized\" style=\"width:51.86%;\"><img src=\"http://myblog/upload/f3/19477c1d30a15d4adafaf286cdd05c.jpg\"></figure><p>&nbsp;</p><h2>a</h2><h3>a1</h3><p>kjlkjljk</p><p>kljlksjlkdf</p><h2>b</h2><h3>b1</h3><p>lksjdlkfjlskdf</p><p>&nbsp;</p><p>&nbsp;</p><p>&nbsp;</p>', '2023-10-04 13:44:57', 0, 1);

-- ----------------------------
-- Table structure for zy_articles_tags
-- ----------------------------
DROP TABLE IF EXISTS `zy_articles_tags`;
CREATE TABLE `zy_articles_tags`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) NOT NULL,
  `tid` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章标签关系表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zy_articles_tags
-- ----------------------------
INSERT INTO `zy_articles_tags` VALUES (3, 4, 1);
INSERT INTO `zy_articles_tags` VALUES (4, 4, 3);
INSERT INTO `zy_articles_tags` VALUES (6, 6, 1);
INSERT INTO `zy_articles_tags` VALUES (13, 37, 1);
INSERT INTO `zy_articles_tags` VALUES (14, 37, 3);

-- ----------------------------
-- Table structure for zy_class
-- ----------------------------
DROP TABLE IF EXISTS `zy_class`;
CREATE TABLE `zy_class`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `keys` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章分类表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zy_class
-- ----------------------------
INSERT INTO `zy_class` VALUES (1, 'PHP', '', '');
INSERT INTO `zy_class` VALUES (2, '数据库', '12,456,789,是中', 'L;KJSL;KJLKJ加国棵');

-- ----------------------------
-- Table structure for zy_menus
-- ----------------------------
DROP TABLE IF EXISTS `zy_menus`;
CREATE TABLE `zy_menus`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '链接地址',
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '打开方式：_blank，_self',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zy_menus
-- ----------------------------
INSERT INTO `zy_menus` VALUES (2, '首页', '/', '_self');
INSERT INTO `zy_menus` VALUES (3, 'PHP', '/c/1', '_self');

-- ----------------------------
-- Table structure for zy_tags
-- ----------------------------
DROP TABLE IF EXISTS `zy_tags`;
CREATE TABLE `zy_tags`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `keys` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '关键词',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章标签表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zy_tags
-- ----------------------------
INSERT INTO `zy_tags` VALUES (1, 'php', '', '');
INSERT INTO `zy_tags` VALUES (3, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (4, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (7, '222', '2222', '22222');
INSERT INTO `zy_tags` VALUES (8, 'php', '', '');
INSERT INTO `zy_tags` VALUES (9, 'nginx', '', '');
INSERT INTO `zy_tags` VALUES (10, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (11, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (12, '222', '2222', '22222');
INSERT INTO `zy_tags` VALUES (13, 'php', '', '');
INSERT INTO `zy_tags` VALUES (14, 'nginx', '', '');
INSERT INTO `zy_tags` VALUES (15, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (16, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (17, '222', '2222', '22222');
INSERT INTO `zy_tags` VALUES (18, 'php', '', '');
INSERT INTO `zy_tags` VALUES (19, 'nginx', '', '');
INSERT INTO `zy_tags` VALUES (20, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (21, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (22, '222', '2222', '22222');
INSERT INTO `zy_tags` VALUES (23, 'php', '', '');
INSERT INTO `zy_tags` VALUES (24, 'nginx', '', '');
INSERT INTO `zy_tags` VALUES (25, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (26, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (27, '222', '2222', '22222');
INSERT INTO `zy_tags` VALUES (28, 'php', '', '');
INSERT INTO `zy_tags` VALUES (29, 'nginx', '', '');
INSERT INTO `zy_tags` VALUES (30, 'mysql', '', '');
INSERT INTO `zy_tags` VALUES (31, '1112233', '111222', '1112222');
INSERT INTO `zy_tags` VALUES (32, '222', '2222', '22222');

SET FOREIGN_KEY_CHECKS = 1;