sun15684712291/aicheckv2-api
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
yolov11
aicheckv2-api/sql/aicheck-dev.sql
sunyugang 65fe22d1ea 提交数据库文件
2025-09-30 14:30:54 +08:00

712 lines
64 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 Data Transfer
Source Server : localhost-mysql
Source Server Type : MySQL
Source Server Version : 80039 (8.0.39)
Source Host : localhost:3306
Source Schema : aicheck-dev
Target Server Type : MySQL
Target Server Version : 80039 (8.0.39)
File Encoding : 65001
Date: 17/09/2025 08:45:02
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for alembic_version
-- ----------------------------
DROP TABLE IF EXISTS `alembic_version`;
CREATE TABLE `alembic_version` (
`version_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
PRIMARY KEY (`version_num`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of alembic_version
-- ----------------------------
INSERT INTO `alembic_version` VALUES ('655d3fa2c68d');
-- ----------------------------
-- Table structure for project_detect
-- ----------------------------
DROP TABLE IF EXISTS `project_detect`;
CREATE TABLE `project_detect` (
`project_id` int NOT NULL,
`detect_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`detect_version` int NOT NULL,
`detect_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`detect_status` int NOT NULL,
`file_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`rtsp_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_id` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目推理集合' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_detect
-- ----------------------------
-- ----------------------------
-- Table structure for project_detect_file
-- ----------------------------
DROP TABLE IF EXISTS `project_detect_file`;
CREATE TABLE `project_detect_file` (
`detect_id` int NOT NULL,
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`object_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`thumb_file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_id` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '待推理图片' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_detect_file
-- ----------------------------
-- ----------------------------
-- Table structure for project_detect_log
-- ----------------------------
DROP TABLE IF EXISTS `project_detect_log`;
CREATE TABLE `project_detect_log` (
`detect_id` int NOT NULL,
`detect_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`detect_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`train_id` int NOT NULL,
`train_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`pt_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`pt_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`detect_folder_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_id` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目推理记录' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_detect_log
-- ----------------------------
-- ----------------------------
-- Table structure for project_detect_log_file
-- ----------------------------
DROP TABLE IF EXISTS `project_detect_log_file`;
CREATE TABLE `project_detect_log_file` (
`log_id` int NOT NULL,
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目训练版本信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_detect_log_file
-- ----------------------------
-- ----------------------------
-- Table structure for project_image
-- ----------------------------
DROP TABLE IF EXISTS `project_image`;
CREATE TABLE `project_image` (
`img_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`file_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`object_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`thumb_image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`project_id` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目图片表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_image
-- ----------------------------
-- ----------------------------
-- Table structure for project_img_label
-- ----------------------------
DROP TABLE IF EXISTS `project_img_label`;
CREATE TABLE `project_img_label` (
`image_id` int NOT NULL,
`label_id` int NOT NULL,
`mark_center_x` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`mark_center_y` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`mark_width` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`mark_height` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目图片标签对应表，一张图片对应多个label' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_img_label
-- ----------------------------
-- ----------------------------
-- Table structure for project_img_leafer
-- ----------------------------
DROP TABLE IF EXISTS `project_img_leafer`;
CREATE TABLE `project_img_leafer` (
`image_id` int NOT NULL,
`leafer` json NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目图片leafer表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_img_leafer
-- ----------------------------
-- ----------------------------
-- Table structure for project_info
-- ----------------------------
DROP TABLE IF EXISTS `project_info`;
CREATE TABLE `project_info` (
`project_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`project_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`type_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`project_status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_id` int NOT NULL,
`dept_id` int NOT NULL,
`train_version` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `project_name`(`project_name` ASC) USING BTREE,
UNIQUE INDEX `project_no`(`project_no` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目类别表 - 标识项目的类型目前存在的（目标识别，OCR识别，瑕疵检测，图像分类）' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_info
-- ----------------------------
INSERT INTO `project_info` VALUES ('qsgrpb', '道路安全监测', 'jc', '美了并走断方团子实行石农合得。周里又而儿局这年满共信北志主构历决。斗入速阶受放严比团华圆风京无。每只状群问理活何到选工情改。自例到型酸容严府有在号变水存北次。', '0', 1, 0, 0, 8, '2025-04-09 16:14:25', '2025-04-09 16:14:25', NULL, 0);
-- ----------------------------
-- Table structure for project_label
-- ----------------------------
DROP TABLE IF EXISTS `project_label`;
CREATE TABLE `project_label` (
`label_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`project_id` int NOT NULL,
`meta` json NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `label_name`(`label_name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目标签表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_label
-- ----------------------------
-- ----------------------------
-- Table structure for project_train
-- ----------------------------
DROP TABLE IF EXISTS `project_train`;
CREATE TABLE `project_train` (
`project_id` int NOT NULL,
`train_version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`train_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`train_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`weights_id` int NOT NULL,
`weights_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`epochs` int NOT NULL,
`patience` int NOT NULL,
`best_pt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`last_pt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`user_id` int NOT NULL,
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '项目训练版本信息表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of project_train
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_auth_dept
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_dept`;
CREATE TABLE `vadmin_auth_dept` (
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门名称',
`dept_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '部门标识',
`disabled` tinyint(1) NOT NULL COMMENT '是否禁用',
`order` int NULL DEFAULT NULL COMMENT '显示排序',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
`owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人',
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
`parent_id` int NULL DEFAULT NULL COMMENT '上级部门',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `parent_id`(`parent_id` ASC) USING BTREE,
INDEX `ix_vadmin_auth_dept_dept_key`(`dept_key` ASC) USING BTREE,
INDEX `ix_vadmin_auth_dept_name`(`name` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_dept_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `vadmin_auth_dept` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '部门表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_dept
-- ----------------------------
INSERT INTO `vadmin_auth_dept` VALUES ('AiCheck团队', 'total_group', 0, 1, NULL, NULL, NULL, NULL, NULL, 1, '2023-12-18 22:51:07', '2025-09-17 08:37:24', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_auth_menu
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_menu`;
CREATE TABLE `vadmin_auth_menu` (
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标',
`redirect` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '重定向地址',
`component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端组件地址',
`path` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前端路由地址',
`disabled` tinyint(1) NOT NULL COMMENT '是否禁用',
`hidden` tinyint(1) NOT NULL COMMENT '是否隐藏',
`order` int NOT NULL COMMENT '排序',
`menu_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单类型',
`parent_id` int NULL DEFAULT NULL COMMENT '父菜单',
`perms` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限标识',
`noCache` tinyint(1) NOT NULL COMMENT '如果设置为true，则不会被 <keep-alive> 缓存(默认 false)',
`breadcrumb` tinyint(1) NOT NULL COMMENT '如果设置为false，则不会在breadcrumb面包屑中显示(默认 true)',
`affix` tinyint(1) NOT NULL COMMENT '如果设置为true，则会一直固定在tag项中(默认 false)',
`noTagsView` tinyint(1) NOT NULL COMMENT '如果设置为true，则不会出现在tag中(默认 false)',
`canTo` tinyint(1) NOT NULL COMMENT '设置为true即使hidden为true，也依然可以进行路由跳转(默认 false)',
`alwaysShow` tinyint(1) NOT NULL COMMENT '当你一个路由下面的 children 声明的路由大于1个时，自动会变成嵌套的模式，\n 只有一个时，会将那个子路由当做根路由显示在侧边栏，若你想不管路由下面的 children 声明的个数都显示你的根路由，\n 你可以设置 alwaysShow: true，这样它就会忽略之前定义的规则，一直显示根路由(默认 true)',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `parent_id`(`parent_id` ASC) USING BTREE,
INDEX `ix_vadmin_auth_menu_perms`(`perms` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_menu_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `vadmin_auth_menu` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_menu
-- ----------------------------
INSERT INTO `vadmin_auth_menu` VALUES ('仪表盘', 'ant-design:dashboard-filled', '/dashboard/workplace', '#', '/dashboard', 0, 0, 0, '0', NULL, NULL, 0, 1, 0, 0, 0, 0, 1, '2022-08-13 10:56:32', '2023-10-05 02:21:30', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('权限管理', 'ep:lock', '/auth/menu', '#', '/auth', 0, 0, 1, '0', NULL, NULL, 0, 1, 0, 0, 0, 0, 2, '2022-09-22 22:53:52', '2023-10-05 02:22:38', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('系统管理', 'ant-design:setting-filled', NULL, '#', '/system', 0, 0, 2, '0', NULL, NULL, 0, 1, 0, 0, 0, 0, 3, '2022-10-04 20:58:18', '2022-10-28 21:28:13', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('工作台', NULL, NULL, 'views/Dashboard/Workplace', 'workplace', 0, 0, 0, '1', 1, NULL, 0, 1, 0, 0, 0, 0, 4, '2022-10-12 16:59:27', '2022-11-18 10:25:35', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('数据概览', NULL, NULL, 'views/Dashboard/Analysis/Analysis', 'analysis', 0, 0, 1, '1', 1, NULL, 0, 1, 0, 0, 0, 0, 5, '2022-11-05 12:55:59', '2023-09-14 16:10:08', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('用户分布', NULL, NULL, 'views/Dashboard/Map', 'map', 0, 0, 2, '1', 1, NULL, 0, 1, 0, 0, 0, 0, 6, '2022-11-16 18:39:17', '2022-11-17 20:45:35', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('菜单管理', NULL, NULL, 'views/Vadmin/Auth/Menu/Menu', 'menu', 0, 0, 1, '1', 2, NULL, 0, 1, 0, 0, 0, 0, 7, '2022-09-22 17:21:30', '2022-11-18 10:26:42', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('角色管理', NULL, NULL, 'views/Vadmin/Auth/Role/Role', 'role', 0, 0, 2, '1', 2, NULL, 0, 1, 0, 0, 0, 0, 8, '2022-09-22 17:21:30', '2022-11-18 10:26:56', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('用户管理', NULL, NULL, 'views/Vadmin/Auth/User/User', 'user', 0, 0, 3, '1', 2, NULL, 0, 1, 0, 0, 0, 0, 9, '2022-09-22 17:21:30', '2023-09-11 16:24:37', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('字典配置', NULL, NULL, 'views/Vadmin/System/Dict/Dict', 'dict', 0, 0, 1, '1', 3, NULL, 0, 1, 0, 0, 0, 0, 10, '2022-10-04 21:02:55', '2023-09-12 15:07:25', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('日志管理', 'tdesign:catalog', NULL, '#', '/record', 0, 0, 99, '0', NULL, NULL, 0, 1, 0, 0, 0, 0, 13, '2022-10-28 21:29:56', '2023-10-05 03:40:05', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('系统配置', NULL, NULL, 'views/Vadmin/System/Settings/Settings', 'settings', 0, 0, 0, '1', 3, NULL, 0, 1, 0, 0, 0, 0, 14, '2022-10-30 17:35:50', '2022-10-30 17:35:50', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('登录日志', NULL, NULL, 'views/Vadmin/System/Record/Login/Login', 'login', 0, 0, 0, '1', 13, NULL, 0, 1, 0, 0, 0, 0, 15, '2022-10-28 21:34:47', '2022-10-28 21:36:05', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('操作日志', NULL, NULL, 'views/Vadmin/System/Record/Operation/Operation', 'operation', 0, 0, 1, '1', 13, NULL, 0, 1, 0, 0, 0, 0, 16, '2022-10-28 22:12:15', '2022-10-29 13:39:46', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('新增菜单', NULL, NULL, NULL, NULL, 0, 0, 0, '2', 7, 'auth.menu.create', 0, 1, 0, 0, 0, 0, 17, '2022-11-18 14:21:26', '2022-11-18 14:29:51', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('编辑菜单', NULL, NULL, NULL, NULL, 0, 0, 1, '2', 7, 'auth.menu.update', 0, 1, 0, 0, 0, 0, 18, '2022-11-18 15:23:05', '2022-11-18 15:23:05', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('删除菜单', NULL, NULL, NULL, NULL, 0, 0, 2, '2', 7, 'auth.menu.delete', 0, 1, 0, 0, 0, 0, 19, '2022-11-18 15:23:27', '2022-11-18 15:23:27', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('新增角色', NULL, NULL, NULL, NULL, 0, 0, 0, '2', 8, 'auth.role.create', 0, 1, 0, 0, 0, 0, 20, '2022-11-18 15:11:55', '2022-11-18 15:11:55', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('编辑角色', NULL, NULL, NULL, NULL, 0, 0, 1, '2', 8, 'auth.role.update', 0, 1, 0, 0, 0, 0, 21, '2022-11-18 15:23:56', '2022-11-18 15:23:56', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('删除角色', NULL, NULL, NULL, NULL, 0, 0, 2, '2', 8, 'auth.role.delete', 0, 1, 0, 0, 0, 0, 22, '2022-11-18 15:24:11', '2023-08-24 15:41:23', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('新增用户', NULL, NULL, NULL, NULL, 0, 0, 0, '2', 9, 'auth.user.create', 0, 1, 0, 0, 0, 0, 23, '2022-11-18 15:26:19', '2022-11-18 15:31:00', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('编辑用户', NULL, NULL, NULL, NULL, 0, 0, 1, '2', 9, 'auth.user.update', 0, 1, 0, 0, 0, 0, 24, '2022-11-18 15:26:41', '2022-11-18 15:26:41', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('删除用户', NULL, NULL, NULL, NULL, 0, 0, 2, '2', 9, 'auth.user.delete', 0, 1, 0, 0, 0, 0, 25, '2022-11-18 15:27:06', '2022-11-18 15:27:06', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('批量导入用户', NULL, NULL, NULL, NULL, 0, 0, 3, '2', 9, 'auth.user.import', 0, 1, 0, 0, 0, 0, 26, '2022-11-18 15:27:36', '2022-11-18 15:27:36', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('导出筛选用户', NULL, NULL, NULL, NULL, 0, 0, 4, '2', 9, 'auth.user.export', 0, 1, 0, 0, 0, 0, 27, '2022-11-18 15:27:55', '2022-11-18 15:27:55', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('重置密码通知短信', NULL, NULL, NULL, NULL, 0, 0, 5, '2', 9, 'auth.user.reset', 0, 1, 0, 0, 0, 0, 28, '2022-11-18 15:28:38', '2022-11-18 15:28:38', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('帮助中心', 'material-symbols:help-rounded', NULL, '#', '/help', 0, 0, 100, '0', NULL, NULL, 0, 1, 0, 0, 0, 1, 38, '2023-02-16 16:33:03', '2023-02-16 16:35:00', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('常见问题类别', NULL, NULL, 'views/Vadmin/Help/IssueCategory/IssueCategory', 'issue/category', 0, 0, 0, '1', 38, NULL, 0, 1, 0, 0, 0, 0, 39, '2023-02-16 16:34:00', '2023-09-11 12:32:06', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('常见问题', NULL, NULL, 'views/Vadmin/Help/Issue/Issue', 'issue', 0, 0, 1, '1', 38, NULL, 0, 1, 0, 0, 0, 0, 40, '2023-02-16 17:12:53', '2023-09-11 12:32:26', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('常见问题表单', NULL, NULL, 'views/Vadmin/Help/Issue/components/Write', 'issue/form', 0, 1, 99, '1', 38, NULL, 0, 1, 0, 0, 0, 0, 42, '2023-02-21 23:41:24', '2023-09-11 12:32:43', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('智慧大屏', 'icon-park-solid:data-sheet', '/screen/air', NULL, '/screen', 0, 0, 3, '0', NULL, NULL, 0, 1, 0, 0, 0, 1, 68, '2022-11-24 15:07:23', '2022-11-24 15:23:27', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('空气质量', NULL, NULL, 'views/Vadmin/Screen/Air/Air', 'air', 0, 0, 0, '1', 68, NULL, 0, 1, 0, 0, 0, 0, 69, '2022-11-24 15:08:09', '2023-09-18 09:52:39', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('定时任务', NULL, NULL, 'views/Vadmin/System/Task/Task', 'task', 0, 0, 1, '1', 3, NULL, 1, 1, 0, 0, 0, 0, 73, '2023-06-25 14:44:36', '2023-09-18 15:47:06', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('调度日志', NULL, NULL, 'views/Vadmin/System/Record/Task/Task', 'task', 0, 0, 2, '1', 13, NULL, 0, 1, 0, 0, 0, 0, 74, '2023-06-28 10:53:58', '2023-09-13 17:22:22', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('获取菜单列表', NULL, NULL, NULL, NULL, 0, 0, 3, '2', 7, 'auth.menu.list', 0, 1, 0, 0, 0, 0, 76, '2023-08-24 15:40:23', '2023-08-24 15:40:23', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('获取角色列表', NULL, NULL, NULL, NULL, 0, 0, 3, '2', 8, 'auth.role.list', 0, 1, 0, 0, 0, 0, 77, '2023-08-24 15:40:47', '2023-08-24 15:40:47', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('获取用户列表', NULL, NULL, NULL, NULL, 0, 0, 6, '2', 9, 'auth.user.list', 0, 1, 0, 0, 0, 0, 78, '2023-08-24 15:41:16', '2023-08-24 15:41:16', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('资源管理', 'line-md:image', NULL, '#', '/resource', 0, 0, 4, '0', NULL, NULL, 0, 1, 0, 0, 0, 1, 79, '2023-08-25 13:56:25', '2023-08-25 13:56:25', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('图片资源', NULL, NULL, 'views/Vadmin/Resource/Image/Image', 'images', 0, 0, 1, '1', 79, NULL, 0, 1, 0, 0, 0, 0, 80, '2023-08-25 13:57:19', '2023-09-14 11:11:32', NULL, 0);
INSERT INTO `vadmin_auth_menu` VALUES ('部门管理', NULL, NULL, 'views/Vadmin/Auth/Dept/Dept', 'dept', 0, 0, 0, '1', 2, NULL, 0, 1, 0, 0, 0, 0, 81, '2023-12-18 22:49:01', '2023-12-18 22:49:01', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_auth_role
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_role`;
CREATE TABLE `vadmin_auth_role` (
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '名称',
`role_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限字符',
`data_range` int NOT NULL COMMENT '数据权限范围',
`disabled` tinyint(1) NOT NULL COMMENT '是否禁用',
`order` int NULL DEFAULT NULL COMMENT '排序',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述',
`is_admin` tinyint(1) NOT NULL COMMENT '是否为超级角色',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_vadmin_auth_role_name`(`name` ASC) USING BTREE,
INDEX `ix_vadmin_auth_role_role_key`(`role_key` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_role
-- ----------------------------
INSERT INTO `vadmin_auth_role` VALUES ('管理员', 'admin', 4, 0, 0, NULL, 1, 1, '2022-08-13 10:58:18', '2022-10-09 15:03:34', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_auth_role_depts
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_role_depts`;
CREATE TABLE `vadmin_auth_role_depts` (
`role_id` int NULL DEFAULT NULL,
`dept_id` int NULL DEFAULT NULL,
INDEX `dept_id`(`dept_id` ASC) USING BTREE,
INDEX `role_id`(`role_id` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_role_depts_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `vadmin_auth_dept` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `vadmin_auth_role_depts_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `vadmin_auth_role` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_role_depts
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_auth_role_menus
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_role_menus`;
CREATE TABLE `vadmin_auth_role_menus` (
`role_id` int NULL DEFAULT NULL,
`menu_id` int NULL DEFAULT NULL,
INDEX `menu_id`(`menu_id` ASC) USING BTREE,
INDEX `role_id`(`role_id` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_role_menus_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `vadmin_auth_menu` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `vadmin_auth_role_menus_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `vadmin_auth_role` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_role_menus
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_auth_user
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_user`;
CREATE TABLE `vadmin_auth_user` (
`avatar` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头像',
`telephone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱地址',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '姓名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '昵称',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
`gender` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
`is_active` tinyint(1) NOT NULL COMMENT '是否可用',
`is_reset_password` tinyint(1) NOT NULL COMMENT '是否已经重置密码，没有重置的，登陆系统后必须重置密码',
`last_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '最后一次登录IP',
`last_login` datetime NULL DEFAULT NULL COMMENT '最近一次登录时间',
`wx_server_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '服务端微信平台openid',
`is_wx_server_openid` tinyint(1) NOT NULL COMMENT '是否已有服务端微信平台openid',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_vadmin_auth_user_name`(`name` ASC) USING BTREE,
INDEX `ix_vadmin_auth_user_telephone`(`telephone` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_user
-- ----------------------------
INSERT INTO `vadmin_auth_user` VALUES ('https://vv-reserve.oss-cn-hangzhou.aliyuncs.com/avatar/2023-01-27/1674820804e81e7631.png', '15684712291', NULL, 'sunyg', '孙玉刚', '$2b$12$2jAiEsrSkKBhccPkFTidkurG2M0sDW1ASQrv.7D2h5rhGrFXDFVNS', '0', 1, 1, '127.0.0.1', '2025-09-17 08:41:53', NULL, 0, 2, '2025-09-17 08:36:52', '2025-09-17 08:41:52', NULL, 0);
INSERT INTO `vadmin_auth_user` VALUES ('https://vv-reserve.oss-cn-hangzhou.aliyuncs.com/avatar/2023-01-27/1674820804e81e7631.png', '13335027034', NULL, 'admin', 'aicheck', '$2b$12$hL3yKNmjGq8hwxG5/8hsVeaWV0C.tAYQmUJW5VCdKu9yh1GIRN2cC', '0', 1, 1, '127.0.0.1', '2025-09-17 08:44:16', NULL, 0, 3, '2025-09-17 08:43:35', '2025-09-17 08:44:16', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_auth_user_depts
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_user_depts`;
CREATE TABLE `vadmin_auth_user_depts` (
`user_id` int NULL DEFAULT NULL,
`dept_id` int NULL DEFAULT NULL,
INDEX `dept_id`(`dept_id` ASC) USING BTREE,
INDEX `user_id`(`user_id` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_user_depts_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `vadmin_auth_dept` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `vadmin_auth_user_depts_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `vadmin_auth_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_user_depts
-- ----------------------------
INSERT INTO `vadmin_auth_user_depts` VALUES (2, 1);
INSERT INTO `vadmin_auth_user_depts` VALUES (3, 1);
-- ----------------------------
-- Table structure for vadmin_auth_user_roles
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_auth_user_roles`;
CREATE TABLE `vadmin_auth_user_roles` (
`user_id` int NULL DEFAULT NULL,
`role_id` int NULL DEFAULT NULL,
INDEX `role_id`(`role_id` ASC) USING BTREE,
INDEX `user_id`(`user_id` ASC) USING BTREE,
CONSTRAINT `vadmin_auth_user_roles_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `vadmin_auth_role` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `vadmin_auth_user_roles_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `vadmin_auth_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_auth_user_roles
-- ----------------------------
INSERT INTO `vadmin_auth_user_roles` VALUES (2, 1);
INSERT INTO `vadmin_auth_user_roles` VALUES (3, 1);
-- ----------------------------
-- Table structure for vadmin_help_issue
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_help_issue`;
CREATE TABLE `vadmin_help_issue` (
`category_id` int NOT NULL COMMENT '类别',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内容',
`view_number` int NOT NULL COMMENT '查看次数',
`is_active` tinyint(1) NOT NULL COMMENT '是否可见',
`create_user_id` int NOT NULL COMMENT '创建人',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `category_id`(`category_id` ASC) USING BTREE,
INDEX `create_user_id`(`create_user_id` ASC) USING BTREE,
INDEX `ix_vadmin_help_issue_title`(`title` ASC) USING BTREE,
CONSTRAINT `vadmin_help_issue_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `vadmin_help_issue_category` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
CONSTRAINT `vadmin_help_issue_ibfk_2` FOREIGN KEY (`create_user_id`) REFERENCES `vadmin_auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '常见问题记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_help_issue
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_help_issue_category
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_help_issue_category`;
CREATE TABLE `vadmin_help_issue_category` (
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类别名称',
`platform` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '展示平台',
`is_active` tinyint(1) NOT NULL COMMENT '是否可见',
`create_user_id` int NOT NULL COMMENT '创建人',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `create_user_id`(`create_user_id` ASC) USING BTREE,
INDEX `ix_vadmin_help_issue_category_name`(`name` ASC) USING BTREE,
INDEX `ix_vadmin_help_issue_category_platform`(`platform` ASC) USING BTREE,
CONSTRAINT `vadmin_help_issue_category_ibfk_1` FOREIGN KEY (`create_user_id`) REFERENCES `vadmin_auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '常见问题类别表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_help_issue_category
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_record_login
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_record_login`;
CREATE TABLE `vadmin_record_login` (
`telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手机号',
`status` tinyint(1) NOT NULL COMMENT '是否登录成功',
`platform` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '登陆平台',
`login_method` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '认证方式',
`ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登陆地址',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登陆地点',
`country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '国家',
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '县',
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城市',
`county` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区/县',
`operator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '运营商',
`postal_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮政编码',
`area_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地区区号',
`browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浏览器',
`system` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作系统',
`response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '响应信息',
`request` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '请求信息',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_vadmin_record_login_telephone`(`telephone` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '登录记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_record_login
-- ----------------------------
INSERT INTO `vadmin_record_login` VALUES ('15020221010', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Other ', 'Other ', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTAyMDIyMTAxMCIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiRDZTdlU1VLSUlsOERNS2VEeU5IeXIuRHA0YWVzUUNNNzBSZVBpZ1JWRW55MUVxbDMxUjBDcSIsImV4cCI6MTc0NDI1MzUzM30.Xh5sk3SuM_7EbfZDTX4Ap2ZztUKmb_OhzV-Gk4o-HZ8\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTAyMDIyMTAxMCIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJENlN2VTVUtJSWw4RE1LZUR5Tkh5ci5EcDRhZXNRQ003MFJlUGlnUlZFbnkxRXFsMzFSMENxIiwiZXhwIjoxNzQ0MzM5OTMzfQ.sfGKpfEZMjaS3gnXqVe0kN_f2ulmpMSiotTtXuhX-v4\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"user-agent\": \"Apifox/1.0.0 (https://apifox.com)\", \"content-type\": \"application/json\", \"accept\": \"*/*\", \"host\": \"localhost:9000\", \"accept-encoding\": \"gzip, deflate, br\", \"connection\": \"keep-alive\", \"content-length\": \"66\"}}', 1, '2025-04-09 10:52:13', '2025-04-09 10:52:13', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15020221010', 1, '2', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Other ', 'Other ', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTAyMDIyMTAxMCIsInBhc3N3b3JkIjoiJDJiJDEyJENlN2VTVUtJSWw4RE1LZUR5Tkh5ci5EcDRhZXNRQ003MFJlUGlnUlZFbnkxRXFsMzFSMENxIiwiZXhwIjoxNzQ0MjYzOTIwfQ.MTqVkiPyjh16CPpW963iQPoyZs553rcISz3p6uRJoYY\", \"token_type\": \"bearer\"}', '{\"form\": [[\"username\", \"15020221010\"], [\"password\", \"kinit2022\"]], \"headers\": {\"user-agent\": \"Apifox/1.0.0 (https://apifox.com)\", \"accept\": \"*/*\", \"host\": \"localhost:9000\", \"accept-encoding\": \"gzip, deflate, br\", \"connection\": \"keep-alive\", \"content-type\": \"multipart/form-data; boundary=--------------------------413135776685454814450092\", \"content-length\": \"290\"}}', 2, '2025-04-09 13:45:20', '2025-04-09 13:45:20', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15020221010', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTAyMDIyMTAxMCIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiRDZTdlU1VLSUlsOERNS2VEeU5IeXIuRHA0YWVzUUNNNzBSZVBpZ1JWRW55MUVxbDMxUjBDcSIsImV4cCI6MTc1ODE1NTYwMH0.6Ww1iGAIxCA8JJM_IPEDCR3HRtFDEvwIkC9NiHGNkrc\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTAyMDIyMTAxMCIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJENlN2VTVUtJSWw4RE1LZUR5Tkh5ci5EcDRhZXNRQ003MFJlUGlnUlZFbnkxRXFsMzFSMENxIiwiZXhwIjoxNzU4MjQyMDAwfQ.HnL9MJU4TZkoeI_6bd-rrF9Px5RK84JcF7mOdgBPUjk\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"78\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 3, '2025-09-17 08:33:20', '2025-09-17 08:33:20', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15684712291', 0, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"message\": \"\\u624b\\u673a\\u53f7\\u6216\\u5bc6\\u7801\\u9519\\u8bef\"}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"78\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 4, '2025-09-17 08:37:57', '2025-09-17 08:37:57', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15684712291', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiRKMWR2c0guRTNnR3cxSFU4RFhhVWd1TFRvc2t1bEZCVlNOMnhXbDVWRTE0VC9QWGUzNmhMYSIsImV4cCI6MTc1ODE1NTg4OX0.2WKaZaDfs7nS2QiFSrqHQG7I2OzFrHxg2PlyzjX3tqA\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJEoxZHZzSC5FM2dHdzFIVThEWGFVZ3VMVG9za3VsRkJWU04yeFdsNVZFMTRUL1BYZTM2aExhIiwiZXhwIjoxNzU4MjQyMjg5fQ.znXd0XYMLqeXbIYNaD1ByY9plA1SWQI3oKsAXfQKECQ\", \"token_type\": \"bearer\", \"is_reset_password\": false, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"75\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 5, '2025-09-17 08:38:09', '2025-09-17 08:38:09', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15684712291', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiQyakFpRXNyU2tLQmhjY1BrRlRpZGt1ckcyTTBzRFcxQVNRcnYuN0QyaDVyaEdyRlhERlZOUyIsImV4cCI6MTc1ODE1NTkxMX0.MKXo2kNBJftOlEfXfHdup8RDQwva-T-Ipq5fzmz51KU\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJDJqQWlFc3JTa0tCaGNjUGtGVGlka3VyRzJNMHNEVzFBU1Fydi43RDJoNXJoR3JGWERGVk5TIiwiZXhwIjoxNzU4MjQyMzExfQ.E4wNQ9pbh4RhpjxfnMmH5N6XhOrVJohrKgNZf8PlPuM\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"78\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 6, '2025-09-17 08:38:31', '2025-09-17 08:38:31', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('13335027034', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiRDZTdlU1VLSUlsOERNS2VEeU5IeXIuRHA0YWVzUUNNNzBSZVBpZ1JWRW55MUVxbDMxUjBDcSIsImV4cCI6MTc1ODE1NjA1MX0.l3V-Z94WjoFxQ45_RLrexM9Yr1ca_uZPFyQFH43E88o\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJENlN2VTVUtJSWw4RE1LZUR5Tkh5ci5EcDRhZXNRQ003MFJlUGlnUlZFbnkxRXFsMzFSMENxIiwiZXhwIjoxNzU4MjQyNDUxfQ.vN2qbIcnzMzjGv43qaoGJEeLsUCA-M0OTzTGelz1oWk\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"78\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 7, '2025-09-17 08:40:51', '2025-09-17 08:40:51', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('15684712291', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiQyakFpRXNyU2tLQmhjY1BrRlRpZGt1ckcyTTBzRFcxQVNRcnYuN0QyaDVyaEdyRlhERlZOUyIsImV4cCI6MTc1ODE1NjExMn0.6aBwQdIs0etbCNQYHijIQ6OcMDymlYp7F3szCh3lA08\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxNTY4NDcxMjI5MSIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJDJqQWlFc3JTa0tCaGNjUGtGVGlka3VyRzJNMHNEVzFBU1Fydi43RDJoNXJoR3JGWERGVk5TIiwiZXhwIjoxNzU4MjQyNTEyfQ.q67rngyrBQcgPE4PyKPqU7LsAm38BaYHKB7AdNcuRr8\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"78\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 8, '2025-09-17 08:41:52', '2025-09-17 08:41:52', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('13335027034', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiR6RkROTERZVkZxeUkuSmhyWi80V3J1dVJHQXd0UkNiWkxUOE94Qk5jOHhYaEpYb3BiZVZjMiIsImV4cCI6MTc1ODE1NjIzMH0.ED_tm2toYxYnvSQiWU1Q82N2CIliHtm_-UcgX9TXFnY\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJHpGRE5MRFlWRnF5SS5KaHJaLzRXcnV1UkdBd3RSQ2JaTFQ4T3hCTmM4eFhoSlhvcGJlVmMyIiwiZXhwIjoxNzU4MjQyNjMwfQ.cvX-M9BoCYbbHHeY9hgAfeROQ86IxSwBvo3AQawN3Z0\", \"token_type\": \"bearer\", \"is_reset_password\": false, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"75\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 9, '2025-09-17 08:43:50', '2025-09-17 08:43:50', NULL, 0);
INSERT INTO `vadmin_record_login` VALUES ('13335027034', 1, '0', '0', '127.0.0.1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chrome 139.0.0', 'Windows 10', '{\"access_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOmZhbHNlLCJwYXNzd29yZCI6IiQyYiQxMiRoTDN5S05takdxOGh3eEc1Lzhoc1ZlYVdWMEMudEFZUW1VSlc1VkNkS3U5eWgxR0lSTjJjQyIsImV4cCI6MTc1ODE1NjI1Nn0.p4m8Ajh_L9kLOP21R12xckHtxI6S1GBrUnkkfvKaTfY\", \"refresh_token\": \"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMzMzNTAyNzAzNCIsImlzX3JlZnJlc2giOnRydWUsInBhc3N3b3JkIjoiJDJiJDEyJGhMM3lLTm1qR3E4aHd4RzUvOGhzVmVhV1YwQy50QVlRbVVKVzVWQ2RLdTl5aDFHSVJOMmNDIiwiZXhwIjoxNzU4MjQyNjU2fQ.xd0RlSIcBEPmKEE4IPjOEL6BgYfJiCQnksZaTybzQfA\", \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=AyzVsrXcAbtT/R2x7T1enW6v53Lyytfdopp7FLkKA8gsEhBz3kqdN7cC3jq5pCCPF/UFC+EeXwz7NKr5ImIp2g==\", \"accept-language\": \"zh-CN,zh;q=0.9\", \"accept-encoding\": \"gzip, deflate, br, zstd\", \"referer\": \"http://localhost:5000/login\", \"sec-fetch-dest\": \"empty\", \"sec-fetch-mode\": \"cors\", \"sec-fetch-site\": \"same-origin\", \"origin\": \"http://localhost:5000\", \"sec-ch-ua-mobile\": \"?0\", \"content-type\": \"application/json\", \"sec-ch-ua\": \"\\\"Not;A=Brand\\\";v=\\\"99\\\", \\\"Google Chrome\\\";v=\\\"139\\\", \\\"Chromium\\\";v=\\\"139\\\"\", \"accept\": \"application/json, text/plain, */*\", \"user-agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36\", \"sec-ch-ua-platform\": \"\\\"Windows\\\"\", \"content-length\": \"77\", \"connection\": \"close\", \"host\": \"127.0.0.1:9000\"}}', 10, '2025-09-17 08:44:16', '2025-09-17 08:44:16', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_record_sms_send
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_record_sms_send`;
CREATE TABLE `vadmin_record_sms_send` (
`user_id` int NOT NULL COMMENT '操作人',
`status` tinyint(1) NOT NULL COMMENT '发送状态',
`content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发送内容',
`telephone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '目标手机号',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '失败描述',
`scene` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发送场景',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user_id`(`user_id` ASC) USING BTREE,
CONSTRAINT `vadmin_record_sms_send_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `vadmin_auth_user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '短信发送记录表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_record_sms_send
-- ----------------------------
-- ----------------------------
-- Table structure for vadmin_system_dict_details
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_system_dict_details`;
CREATE TABLE `vadmin_system_dict_details` (
`label` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典标签',
`value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典键值',
`disabled` tinyint(1) NOT NULL COMMENT '字典状态，是否禁用',
`is_default` tinyint(1) NOT NULL COMMENT '是否默认',
`order` int NOT NULL COMMENT '字典排序',
`dict_type_id` int NOT NULL COMMENT '关联字典类型',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `dict_type_id`(`dict_type_id` ASC) USING BTREE,
INDEX `ix_vadmin_system_dict_details_label`(`label` ASC) USING BTREE,
INDEX `ix_vadmin_system_dict_details_value`(`value` ASC) USING BTREE,
CONSTRAINT `vadmin_system_dict_details_ibfk_1` FOREIGN KEY (`dict_type_id`) REFERENCES `vadmin_system_dict_type` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典详情表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_system_dict_details
-- ----------------------------
INSERT INTO `vadmin_system_dict_details` VALUES ('男', '0', 0, 0, 0, 1, NULL, 2, '2022-10-07 12:07:43', '2022-10-07 12:08:02', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('女', '1', 0, 0, 1, 1, NULL, 4, '2022-10-08 13:55:32', '2022-10-08 13:55:32', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('目录', '0', 0, 1, 0, 2, NULL, 5, '2022-10-08 14:05:15', '2022-10-08 14:05:38', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('菜单', '1', 0, 0, 1, 2, NULL, 6, '2022-10-08 14:05:24', '2022-10-08 14:05:24', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('按钮', '2', 0, 0, 2, 2, NULL, 7, '2022-10-08 14:05:32', '2022-10-08 14:05:32', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('密码登录', '0', 0, 0, 0, 3, NULL, 8, '2022-12-03 23:48:33', '2022-12-03 23:48:33', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('短信登录', '1', 0, 0, 1, 3, NULL, 9, '2022-12-03 23:48:47', '2022-12-03 23:48:47', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('PC端管理系统', '0', 0, 0, 0, 4, NULL, 10, '2022-12-03 23:49:24', '2022-12-03 23:49:24', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('移动端管理系统', '1', 0, 0, 1, 4, NULL, 11, '2022-12-03 23:49:41', '2022-12-03 23:49:41', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('微信一键登录', '2', 0, 0, 2, 3, NULL, 12, '2023-02-23 22:48:57', '2023-02-23 22:53:26', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('时间间隔(interval)', 'interval', 0, 0, 0, 5, NULL, 14, '2023-06-25 16:56:10', '2023-06-26 15:52:15', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('Cron 表达式', 'cron', 0, 0, 1, 5, NULL, 15, '2023-06-25 16:57:28', '2023-06-25 16:57:28', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('指定日期时间(date)', 'date', 0, 0, 2, 5, NULL, 16, '2023-06-25 16:57:41', '2023-06-26 15:52:25', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('仅本人数据权限', '0', 0, 0, 0, 6, NULL, 17, '2023-12-21 18:39:42', '2023-11-27 15:36:42', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('本部门数据权限', '1', 0, 0, 1, 6, NULL, 18, '2023-12-21 18:39:56', '2023-11-27 15:38:02', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('本部门及以下数据权限', '2', 0, 0, 2, 6, NULL, 19, '2023-12-21 18:40:06', '2023-11-27 15:38:13', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('自定义数据权限', '3', 0, 0, 3, 6, NULL, 20, '2023-12-21 18:40:15', '2023-11-27 15:38:18', NULL, 0);
INSERT INTO `vadmin_system_dict_details` VALUES ('全部数据权限', '4', 0, 0, 4, 6, NULL, 21, '2023-12-21 18:40:26', '2023-11-27 15:38:23', NULL, 0);
-- ----------------------------
-- Table structure for vadmin_system_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `vadmin_system_dict_type`;
CREATE TABLE `vadmin_system_dict_type` (
`dict_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典名称',
`dict_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典类型',
`disabled` tinyint(1) NOT NULL COMMENT '字典状态，是否禁用',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`create_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
`delete_datetime` datetime NULL DEFAULT NULL COMMENT '删除时间',
`is_delete` tinyint(1) NOT NULL COMMENT '是否软删除',
PRIMARY KEY (`id`) USING BTREE,
INDEX `ix_vadmin_system_dict_type_dict_name`(`dict_name` ASC) USING BTREE,
INDEX `ix_vadmin_system_dict_type_dict_type`(`dict_type` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of vadmin_system_dict_type
-- ----------------------------
INSERT INTO `vadmin_system_dict_type` VALUES ('性别', 'sys_vadmin_gender', 0, NULL, 1, '2022-10-05 22:03:43', '2022-10-08 13:57:16', NULL, 0);
INSERT INTO `vadmin_system_dict_type` VALUES ('菜单类型', 'sys_vadmin_menu_type', 0, NULL, 2, '2022-10-08 13:57:32', '2022-10-08 13:57:32', NULL, 0);
INSERT INTO `vadmin_system_dict_type` VALUES ('认证方式', 'sys_vadmin_login_method', 0, NULL, 3, '2022-12-03 23:48:09', '2022-12-03 23:48:09', NULL, 0);
INSERT INTO `vadmin_system_dict_type` VALUES ('登录平台', 'sys_vadmin_platform', 0, NULL, 4, '2022-12-03 23:49:11', '2022-12-03 23:49:11', NULL, 0);
INSERT INTO `vadmin_system_dict_type` VALUES ('定时任务执行策略', 'vadmin_system_task_exec_strategy', 0, '与定时任务中有约定，请勿随意更改', 5, '2023-06-25 16:55:20', '2023-06-30 09:23:29', NULL, 0);
INSERT INTO `vadmin_system_dict_type` VALUES ('数据权限范围', 'sys_vadmin_data_range', 0, NULL, 6, '2023-12-21 18:36:56', '2023-12-21 18:36:56', NULL, 0);
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink