/*
 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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"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\": \"[REDACTED], \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": false, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": false, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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\": \"[REDACTED], \"refresh_token\": \"[REDACTED], \"token_type\": \"bearer\", \"is_reset_password\": true, \"is_wx_server_openid\": false}', '{\"form\": [], \"headers\": {\"cookie\": \"rememberMe=true; username=admin; password=[REDACTED] \"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;
