yunzerwebsite/ruankao
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
ruankao/database/default.sql
李志强 ace33d202f first commit
2025-07-14 14:55:25 +08:00

605 lines
40 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
Navicat Premium Dump SQL
Source Server : 本地数据库
Source Server Type : MySQL
Source Server Version : 50726 (5.7.26)
Source Host : localhost:3306
Source Schema : ruankao
Target Server Type : MySQL
Target Server Version : 50726 (5.7.26)
File Encoding : 65001
Date: 14/07/2025 14:46:38
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for yz_admin_config
-- ----------------------------
DROP TABLE IF EXISTS `yz_admin_config`;
CREATE TABLE `yz_admin_config` (
`config_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '系统设置ID',
`config_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '功能名，代码参照使用',
`config_info` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '中文名',
`config_type` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '类型 1文本 2图片 3富文本 4开关',
`config_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '值',
`config_desc` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
`config_sort` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
`config_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1启用 0禁用',
PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_admin_config
-- ----------------------------
INSERT INTO `yz_admin_config` VALUES (1, 'web_title', '站点名称', 1, '测试网', '{$config[\'web_title\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (2, 'web_phone', '站点电话', 1, '19895983967', '{$config[\'web_phone\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (3, 'web_mail', '站点邮箱', 1, '357099073@qq.com', '{$config[\'web_mail\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (4, 'web_wechat', '站点微信', 1, '/storage/uploads/20250516/158244a632e4106d262635ee59bd1820.jpg', '{$config[\'web_wechat\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (5, 'logo', 'logo', 2, '/storage/uploads/20250516/c726b7e5251bb0b46f2749858fa04c0f.png', '{$config[\'logo\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (6, 'logo1', 'logo1', 2, '/storage/uploads/20250516/2773adefac8848f009c4557183ed2fc1.png', '{$config[\'logo1\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (7, 'admin_icp', '网站备案号', 1, '苏ICP备2023006641号', '{$config[\'admin_icp\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (8, 'admin_route', '项目路径', 1, '/index.php/admin/', '后台项目路径', 0, 1);
INSERT INTO `yz_admin_config` VALUES (9, 'admin_domain', '本地域名', 1, 'www.yunzer.cn', '{$config[\'admin_domain\']}', 0, 1);
INSERT INTO `yz_admin_config` VALUES (10, 'admin_page', '每页数量', 1, '10', '列表数据，每页数量', 0, 1);
INSERT INTO `yz_admin_config` VALUES (11, 'admin_info', '系统介绍', 3, '', '{$config[\'admin_info\']}', 0, 1);
-- ----------------------------
-- Table structure for yz_admin_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `yz_admin_sys_menu`;
CREATE TABLE `yz_admin_sys_menu` (
`smid` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`label` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '菜单名称',
`type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '菜单类型，0：顶级菜单，1：功能模块，2：超链接，3：隐藏按钮',
`src` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接源',
`parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级菜单ID',
`icon_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标class',
`sort` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '排序值，升序',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0关闭',
PRIMARY KEY (`smid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8015 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '左侧菜单' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_admin_sys_menu
-- ----------------------------
INSERT INTO `yz_admin_sys_menu` VALUES (2, '基础配置', 0, '', 0, 'layui-icon-util', '99999', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (3, '站点配置', 1, 'yunzer/configvalue', 5000, 'layui-icon-set-fill', '100', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (4, '站点管理', 1, 'yunzer/configlist', 5000, 'layui-icon-slider', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5, '配置添加', 3, 'yunzer/configadd', 3, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (6, '配置修改', 3, 'yunzer/configedit', 3, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7, '配置删除', 3, 'yunzer/configdel', 3, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (10, '菜单管理', 1, 'yunzer/menuinfo', 2, 'layui-icon-template', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (11, '菜单添加', 3, 'yunzer/menuadd', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (12, '菜单修改', 3, 'yunzer/menuedit', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (13, '菜单删除', 3, 'yunzer/menudel', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (14, '按钮列表', 3, 'yunzer/buttoninfo', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (15, '按钮添加', 3, 'yunzer/buttonadd', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (16, '按钮修改', 3, 'yunzer/buttonedit', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (17, '按钮删除', 3, 'yunzer/buttondel', 10, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5000, '系统配置', 0, '', 0, 'layui-icon-set', '99996', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5002, '角色管理', 1, 'yunzeradmin/groupinfo', 2, 'layui-icon-group', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5003, '用户管理', 1, 'yunzeradmin/userinfo', 2, 'layui-icon-user', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5004, '个人中心', 1, 'yunzeradmin/admininfo', 2, 'layui-icon-friends', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5005, '部门添加', 3, 'yunzeradmin/groupadd', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5006, '部门修改', 3, 'yunzeradmin/groupedit', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5007, '部门删除', 3, 'yunzeradmin/groupdel', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5008, '管理员添加', 3, 'yunzeradmin/useradd', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5009, '管理员修改', 3, 'yunzeradmin/useredit', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (5010, '管理员删除', 3, 'yunzeradmin/userdel', 5000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7000, '代码示例', 0, '', 0, 'layui-icon-app', '99995', 0);
INSERT INTO `yz_admin_sys_menu` VALUES (7001, '图标', 1, 'yunzertest/icon_list', 7000, 'layui-icon-theme', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7002, '演示列表-方法渲染', 1, 'yunzertest/test_list', 7000, 'layui-icon-list', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7003, '演示列表-静态表格', 1, 'yunzertest/test_static_list', 7000, 'layui-icon-list', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7004, '演示添加-方法渲染', 3, 'yunzertest/test_add', 7000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7005, '演示修改-方法渲染', 3, 'yunzertest/test_edit', 7000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7006, '演示添加-静态表格', 3, 'yunzertest/test_static_add', 7000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (7007, '演示修改-静态表格', 3, 'yunzertest/test_static_edit', 7000, NULL, '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8000, '友情链接', 0, NULL, 0, 'layui-icon-link', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8001, '云泽网', 2, 'https://www.yunzer.cn', 8000, 'layui-icon-link', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8002, '云泽建站', 2, 'https://www.yunzer.com.cn', 8000, 'layui-icon-link', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8003, '文章管理', 0, '', 0, 'layui-icon-light', '999998', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8004, '文章列表', 1, 'articles/articlelist', 8003, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8005, '文章分类', 1, 'articles/articlecate', 8003, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8006, 'Banner管理', 1, 'yunzeradmin/banner', 2, 'layui-icon-picture', '1', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8007, '资源管理', 0, '', 0, 'layui-icon-senior', '999997', 0);
INSERT INTO `yz_admin_sys_menu` VALUES (8008, '资源列表', 1, 'resources/lists', 8007, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8009, '资源分类', 1, 'resources/cate', 8007, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8010, '日志管理', 0, '', 0, 'layui-icon-about', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8011, '登陆日志', 1, 'log/login', 8010, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8012, '操作日志', 1, 'log/operation', 8010, '', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8013, '邮箱配置', 1, 'yunzer/mailconfig', 5000, 'layui-icon-menu-fill', '0', 1);
INSERT INTO `yz_admin_sys_menu` VALUES (8014, '内容推送', 1, 'yunzeradmin/contentpush', 2, 'layui-icon-export', '0', 1);
-- ----------------------------
-- Table structure for yz_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `yz_admin_user`;
CREATE TABLE `yz_admin_user` (
`uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`account` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号邮箱',
`password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`phone` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`qq` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ号',
`sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别 0未知 1男 2女',
`group_id` int(10) UNSIGNED NOT NULL COMMENT '分组ID',
`login_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登陆次数',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0禁用',
`api_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'API密钥',
`api_key_expire` datetime NULL DEFAULT NULL COMMENT 'API密钥过期时间',
`api_key_status` tinyint(1) NULL DEFAULT 1 COMMENT 'API密钥状态(1有效 0禁用)',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`uid`) USING BTREE,
UNIQUE INDEX `one_account`(`account`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_admin_user
-- ----------------------------
INSERT INTO `yz_admin_user` VALUES (2, '357099073@qq.com', '412b7ee19961676b97a89cb04a22d7d3', '扫地僧', '19895983967', '357099073', 1, 1, 331, 1, NULL, NULL, 1, 1564124524, 1752475244, NULL);
-- ----------------------------
-- Table structure for yz_admin_user_group
-- ----------------------------
DROP TABLE IF EXISTS `yz_admin_user_group`;
CREATE TABLE `yz_admin_user_group` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否生效',
`rights` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '角色权限',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '删除时间',
PRIMARY KEY (`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_admin_user_group
-- ----------------------------
INSERT INTO `yz_admin_user_group` VALUES (1, '管理员', 1, '[8003,8005,8004,8007,8008,8009,2,8006,8014,10,5002,5003,5004,5000,3,8013,4,5008,5009,5005,5010,5007,5006,7000,7003,7002,7001,7007,7006,7005,7004,8000,8001,8002,8010,8011,8012]', 1564124524, 0, 0);
-- ----------------------------
-- Table structure for yz_articles
-- ----------------------------
DROP TABLE IF EXISTS `yz_articles`;
CREATE TABLE `yz_articles` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章名称',
`cate` int(5) NOT NULL DEFAULT 0 COMMENT '文章分类',
`image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '封面图片',
`desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
`author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章内容',
`publishdate` int(11) NULL DEFAULT NULL COMMENT '发布时间',
`sort` int(11) NULL DEFAULT NULL COMMENT '排序',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态：0草稿1待审核2已发布3隐藏',
`views` int(11) NOT NULL DEFAULT 0 COMMENT '浏览量',
`likes` int(11) NOT NULL DEFAULT 0 COMMENT '点赞量',
`is_trans` enum('是','否') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '否' COMMENT '是否转载',
`transurl` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '转载地址',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_articles
-- ----------------------------
-- ----------------------------
-- Table structure for yz_articles_category
-- ----------------------------
DROP TABLE IF EXISTS `yz_articles_category`;
CREATE TABLE `yz_articles_category` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`cid` int(11) NOT NULL DEFAULT 0 COMMENT '分类id',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
`image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '默认图片',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
`sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '排序',
`status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态：0关闭1启用',
`create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章分类表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_articles_category
-- ----------------------------
-- ----------------------------
-- Table structure for yz_attachments
-- ----------------------------
DROP TABLE IF EXISTS `yz_attachments`;
CREATE TABLE `yz_attachments` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '附件名称',
`type` tinyint(1) NOT NULL COMMENT '附件分类 1：图片 2：文件 3：视频 4：音频',
`size` int(11) NULL DEFAULT NULL COMMENT '附件大小',
`src` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '附件地址',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 346 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_attachments
-- ----------------------------
-- ----------------------------
-- Table structure for yz_banner
-- ----------------------------
DROP TABLE IF EXISTS `yz_banner`;
CREATE TABLE `yz_banner` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题',
`desc` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '简介',
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '跳转地址',
`image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '图片地址',
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'banner表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_banner
-- ----------------------------
INSERT INTO `yz_banner` VALUES (1, '智能科技 引领未来', '打造智能化解决方案，助力企业数字化转型,打造智能化解决方案，助力企业数字化转型,打造智能化解决方案，助力企业数字化转型', 'index.html', '/static/images/banner/banner1.jpg', 0, 1746798790, NULL, NULL);
INSERT INTO `yz_banner` VALUES (2, '创新技术 卓越服务', '以创新科技为核心，为客户提供优质服务', 'index.html', '/static/images/banner/banner2.jpg', 0, 1746798790, NULL, NULL);
INSERT INTO `yz_banner` VALUES (3, '专业团队 值得信赖', '资深专家团队，为您提供专业的技术支持', 'index.html', '/static/images/banner/banner3.jpg', 0, 1746798790, NULL, NULL);
INSERT INTO `yz_banner` VALUES (4, '全球视野 本地服务', '立足本地，放眼全球，打造国际化服务', 'index.html', '/static/images/banner/banner4.jpg', 0, 1746798790, NULL, NULL);
-- ----------------------------
-- Table structure for yz_content_push
-- ----------------------------
DROP TABLE IF EXISTS `yz_content_push`;
CREATE TABLE `yz_content_push` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '推送标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '推送内容',
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '推送图片',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '跳转链接',
`type` tinyint(1) NULL DEFAULT 1 COMMENT '推送类型：1=普通推送 2=重要推送',
`status` tinyint(1) NULL DEFAULT 1 COMMENT '状态：0=禁用 1=启用',
`sort` int(11) NULL DEFAULT 0 COMMENT '排序',
`create_time` int(11) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_status`(`status`) USING BTREE,
INDEX `idx_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '内容推送表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_content_push
-- ----------------------------
-- ----------------------------
-- Table structure for yz_daily_stats
-- ----------------------------
DROP TABLE IF EXISTS `yz_daily_stats`;
CREATE TABLE `yz_daily_stats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL COMMENT '统计日期',
`total_users` int(11) NOT NULL DEFAULT 0 COMMENT '总用户数',
`new_users` int(11) NOT NULL DEFAULT 0 COMMENT '新注册用户数',
`total_visits` int(11) NOT NULL DEFAULT 0 COMMENT '总访问量(历史累计)',
`daily_visits` int(11) NOT NULL DEFAULT 0 COMMENT '当日访问量',
`unique_visitors` int(11) NOT NULL DEFAULT 0 COMMENT '当日独立访客数(UV)',
`total_articles` int(11) NOT NULL DEFAULT 0 COMMENT '总文章数',
`daily_articles` int(11) NOT NULL DEFAULT 0 COMMENT '当日发布文章数',
`article_views` int(11) NOT NULL DEFAULT 0 COMMENT '当日文章访问量',
`daily_resources` int(11) NOT NULL DEFAULT 0 COMMENT '当日发布资源数',
`total_resources` int(11) NOT NULL COMMENT '总资源数',
`resource_downloads` int(11) NOT NULL DEFAULT 0 COMMENT '当日资源下载量',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_date`(`date`) USING BTREE COMMENT '日期唯一索引'
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '每日统计表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_daily_stats
-- ----------------------------
INSERT INTO `yz_daily_stats` VALUES (24, '2025-07-14', 0, 0, 88, 88, 1, 0, 0, 0, 0, 0, 0, '2025-07-14 11:04:01', '2025-07-14 14:45:42');
-- ----------------------------
-- Table structure for yz_logs_login
-- ----------------------------
DROP TABLE IF EXISTS `yz_logs_login`;
CREATE TABLE `yz_logs_login` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL DEFAULT NULL COMMENT '用户ID(未登录用户可为空)',
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'IP地址',
`user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理(浏览器信息)',
`login_status` tinyint(1) NOT NULL COMMENT '登录状态(1成功 0失败)',
`failure_reason` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败原因',
`login_time` datetime NOT NULL COMMENT '登录时间',
`logout_time` datetime NULL DEFAULT NULL COMMENT '登出时间',
`session_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会话ID',
`device_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备类型(mobile/pc/tablet)',
`location` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地理位置',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_login_time`(`login_time`) USING BTREE,
INDEX `idx_ip`(`ip_address`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户登录日志表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_logs_login
-- ----------------------------
INSERT INTO `yz_logs_login` VALUES (49, NULL, '357099073@qq.com', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 0, '账号不存在', '2025-07-14 11:56:02', NULL, NULL, 'PC端', '未知');
INSERT INTO `yz_logs_login` VALUES (50, NULL, 'hero920103', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 0, '邮箱格式不正确', '2025-07-14 11:56:10', NULL, NULL, 'PC端', '未知');
INSERT INTO `yz_logs_login` VALUES (51, NULL, '357099073@qq.com', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 1, '', '2025-07-14 11:56:43', NULL, NULL, 'PC端', '未知');
INSERT INTO `yz_logs_login` VALUES (52, NULL, '357099073@qq.com', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36', 1, '', '2025-07-14 14:40:44', NULL, NULL, 'PC端', '未知');
-- ----------------------------
-- Table structure for yz_logs_operation
-- ----------------------------
DROP TABLE IF EXISTS `yz_logs_operation`;
CREATE TABLE `yz_logs_operation` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户ID',
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作用户名',
`module` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作模块',
`operation` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '操作类型',
`request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法(GET/POST等)',
`request_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求参数',
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
`status` tinyint(1) NULL DEFAULT NULL COMMENT '操作状态(1成功 0失败)',
`error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误信息',
`operation_time` datetime NOT NULL COMMENT '操作时间',
`execution_time` bigint(20) NULL DEFAULT NULL COMMENT '执行耗时(ms)',
`request_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求URL',
`user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户代理',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_operation_time`(`operation_time`) USING BTREE,
INDEX `idx_module_operation`(`module`, `operation`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 256 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户操作日志表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_logs_operation
-- ----------------------------
INSERT INTO `yz_logs_operation` VALUES (254, NULL, '扫地僧', '菜单管理', '编辑菜单', 'POST', '{\"smid\":\"8007\",\"label\":\"资源管理\",\"icon_class\":\"layui-icon-senior\",\"sort\":\"999997\",\"status\":\"0\"}', '127.0.0.1', 1, '', '2025-07-14 14:40:57', 0, 'http://rk.yunzer.cn/index.php/admin/yunzer/menuedit', NULL);
INSERT INTO `yz_logs_operation` VALUES (255, NULL, '扫地僧', '菜单管理', '编辑菜单', 'POST', '{\"smid\":\"7000\",\"label\":\"代码示例\",\"icon_class\":\"layui-icon-app\",\"sort\":\"99995\",\"status\":\"0\"}', '127.0.0.1', 1, '', '2025-07-14 14:41:16', 0, 'http://rk.yunzer.cn/index.php/admin/yunzer/menuedit', NULL);
-- ----------------------------
-- Table structure for yz_mail_config
-- ----------------------------
DROP TABLE IF EXISTS `yz_mail_config`;
CREATE TABLE `yz_mail_config` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '配置ID',
`smtp_host` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'SMTP服务器地址',
`smtp_port` int(11) NOT NULL DEFAULT 465 COMMENT 'SMTP端口',
`smtp_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发件人邮箱',
`smtp_password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮箱密码或授权码',
`smtp_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发件人名称',
`create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '邮件配置表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_mail_config
-- ----------------------------
-- ----------------------------
-- Table structure for yz_resources
-- ----------------------------
DROP TABLE IF EXISTS `yz_resources`;
CREATE TABLE `yz_resources` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资源ID',
`cate` int(11) NOT NULL DEFAULT 0 COMMENT '分类ID',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源名称',
`desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '资源描述',
`number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '资源编号',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '资源介绍内容',
`size` int(11) NULL DEFAULT NULL COMMENT '资源大小',
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资源图标',
`images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '资源图片',
`url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '资源链接',
`fileurl` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '服务器路径',
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分享码',
`zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '解压密码',
`uploader` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上传者',
`views` int(11) NOT NULL DEFAULT 0 COMMENT '浏览次数',
`downloads` int(11) NOT NULL DEFAULT 0 COMMENT '下载次数',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序（数字越大越靠前）',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0未审核，1已审核）',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_cate_id`(`cate`) USING BTREE,
INDEX `idx_status`(`status`) USING BTREE,
INDEX `idx_sort`(`sort`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '资源表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_resources
-- ----------------------------
-- ----------------------------
-- Table structure for yz_resources_category
-- ----------------------------
DROP TABLE IF EXISTS `yz_resources_category`;
CREATE TABLE `yz_resources_category` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
`cid` int(11) NOT NULL DEFAULT 0 COMMENT '父级分类ID',
`number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类编号',
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类图标',
`sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序（数字越大越靠前）',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态（0禁用，1正常）',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NULL DEFAULT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_cid`(`cid`) USING BTREE,
INDEX `idx_sort`(`sort`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '资源分类表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_resources_category
-- ----------------------------
-- ----------------------------
-- Table structure for yz_system_notice
-- ----------------------------
DROP TABLE IF EXISTS `yz_system_notice`;
CREATE TABLE `yz_system_notice` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '通知ID',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '通知内容',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '通知类型：1=系统通知，2=活动通知，3=更新通知',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0=禁用，1=启用',
`is_top` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否置顶：0=否，1=是',
`is_read` tinyint(1) NOT NULL DEFAULT 0 COMMENT '未读：0 已读：1',
`view_count` int(11) NOT NULL DEFAULT 0 COMMENT '查看次数',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NOT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_type_status`(`type`, `status`) USING BTREE,
INDEX `idx_create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统通知表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_system_notice
-- ----------------------------
-- ----------------------------
-- Table structure for yz_user_message
-- ----------------------------
DROP TABLE IF EXISTS `yz_user_message`;
CREATE TABLE `yz_user_message` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '消息ID',
`user_id` int(11) NOT NULL COMMENT '用户ID',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息内容',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '消息类型：1=系统消息，2=互动消息，3=通知消息',
`is_top` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否置顶：0=否，1=是',
`is_read` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已读：0=未读，1=已读',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0=禁用，1=启用',
`read_time` int(11) NULL DEFAULT NULL COMMENT '阅读时间',
`create_time` int(11) NOT NULL COMMENT '创建时间',
`update_time` int(11) NOT NULL COMMENT '更新时间',
`delete_time` int(11) NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_type`(`type`) USING BTREE,
INDEX `idx_is_read`(`is_read`) USING BTREE,
INDEX `idx_create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '我的消息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_user_message
-- ----------------------------
-- ----------------------------
-- Table structure for yz_users
-- ----------------------------
DROP TABLE IF EXISTS `yz_users`;
CREATE TABLE `yz_users` (
`uid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`account` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号邮箱',
`password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`avatar` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '头像',
`phone` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`qq` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'QQ号',
`wechat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信号',
`sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别 0未知 1男 2女',
`group_id` int(10) UNSIGNED NOT NULL DEFAULT 2 COMMENT '分组ID',
`login_count` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登陆次数',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0禁用',
`api_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'API密钥',
`api_key_expire` datetime NULL DEFAULT NULL COMMENT 'API密钥过期时间',
`api_key_status` tinyint(1) NULL DEFAULT 1 COMMENT 'API密钥状态(1有效 0禁用)',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '删除时间',
`openid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid',
PRIMARY KEY (`uid`) USING BTREE,
UNIQUE INDEX `one_account`(`account`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_users
-- ----------------------------
-- ----------------------------
-- Table structure for yz_users_group
-- ----------------------------
DROP TABLE IF EXISTS `yz_users_group`;
CREATE TABLE `yz_users_group` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门名称',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否生效',
`rights` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '角色权限',
`create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '更新时间',
`delete_time` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '删除时间',
PRIMARY KEY (`group_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '组管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_users_group
-- ----------------------------
-- ----------------------------
-- Table structure for yz_z_iconfont
-- ----------------------------
DROP TABLE IF EXISTS `yz_z_iconfont`;
CREATE TABLE `yz_z_iconfont` (
`icon_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '图标ID',
`icon_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标名称',
`icon_css` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标css',
`icon_html` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标html',
`icon_source` tinyint(1) UNSIGNED NULL DEFAULT 1 COMMENT '来源 1layui',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 1开启 0关闭',
PRIMARY KEY (`icon_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 169 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图标库' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_z_iconfont
-- ----------------------------
-- ----------------------------
-- Table structure for yz_z_test
-- ----------------------------
DROP TABLE IF EXISTS `yz_z_test`;
CREATE TABLE `yz_z_test` (
`test_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`test_input` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文本',
`test_rich` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '富文本',
`test_rich_baidu` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '百度富文本',
`test_img` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图片',
`test_reference` tinyint(1) UNSIGNED NULL DEFAULT NULL COMMENT '参照',
`test_time` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '时间戳',
`test_data` date NULL DEFAULT NULL COMMENT '日期',
`test_datatime` datetime NULL DEFAULT NULL COMMENT '日期时间',
`test_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '网址',
PRIMARY KEY (`test_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '演示表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of yz_z_test
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink