235 lines
14 KiB
SQL
235 lines
14 KiB
SQL
CREATE DATABASE IF NOT EXISTS miku
|
||
CHARACTER SET utf8mb4
|
||
COLLATE utf8mb4_0900_ai_ci;
|
||
|
||
use miku;
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_menu`;
|
||
CREATE TABLE `m_menu` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '菜单id',
|
||
`menu_name` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单的名字',
|
||
`path` varchar(255) 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 '菜单对应组件地址',
|
||
`parent_id` int NULL DEFAULT 0 COMMENT '父菜单id',
|
||
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标',
|
||
`status` int UNSIGNED NULL DEFAULT 0 COMMENT '是否隐藏（0.显示，1.隐藏）',
|
||
`sort` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '排序',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '菜单信息表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_menu
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_operate_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_operate_log`;
|
||
CREATE TABLE `m_operate_log` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`module` int NULL DEFAULT NULL COMMENT '功能模块',
|
||
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接口地址',
|
||
`params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求参数',
|
||
`operate_type` int NULL DEFAULT NULL COMMENT '操作类型',
|
||
`method_name` 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 '操作人',
|
||
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ip地址',
|
||
`operate_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
|
||
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '附加信息',
|
||
`status` int NULL DEFAULT NULL COMMENT '状态（1.成功，0.失败）',
|
||
`error_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '错误信息',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '操作日志表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_operate_log
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_permission
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_permission`;
|
||
CREATE TABLE `m_permission` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT ' 权限主键',
|
||
`method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '请求的方法',
|
||
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接口名称',
|
||
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '接口地址',
|
||
`sign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '接口签名',
|
||
`status` int NOT NULL DEFAULT 0 COMMENT '接口状态（0.启用，1.停用）',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `url_path`(`path` ASC) USING BTREE COMMENT '权限连接',
|
||
INDEX `idx_deleted` (`is_deleted`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '权限表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_permission
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_role`;
|
||
CREATE TABLE `m_role` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '角色主键',
|
||
`role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称',
|
||
`role_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色编号',
|
||
`status` int NOT NULL DEFAULT 0 COMMENT '角色状态（0.启用，1.停用）',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_deleted` (`is_deleted`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_role
|
||
-- ----------------------------
|
||
INSERT INTO `m_role` VALUES (1, '超级管理员', 'system_admin', 0, '2025-04-23 22:31:03', 'admin', '2025-04-23 22:31:03',null, 0);
|
||
INSERT INTO `m_role` VALUES (2, '管理员', 'admin', 0, '2025-04-23 22:31:03', 'admin', '2025-04-23 22:31:03',null, 0);
|
||
INSERT INTO `m_role` VALUES (3, '用户', 'user', 0, '2025-04-23 22:31:03', 'admin', '2025-04-23 22:31:03',null, 0);
|
||
INSERT INTO `m_role` VALUES (4, '游客', 'visitor', 0, '2025-04-23 22:31:03', 'admin', '2025-04-23 22:31:03',null, 0);
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_role_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_role_menu`;
|
||
CREATE TABLE `m_role_menu` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`role_id` int NOT NULL COMMENT '角色id',
|
||
`menu_id` int NOT NULL COMMENT '导航id',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX idx_r_m (role_id, menu_id, is_deleted) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色导航关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_role_menu
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_role_permission
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_role_permission`;
|
||
CREATE TABLE `m_role_permission` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
`permission_id` int NOT NULL COMMENT '权限id',
|
||
`role_id` int NOT NULL COMMENT '角色id',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX idx_r_p (role_id, permission_id, is_deleted) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色权限关系表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_role_permission
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_storage
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_storage`;
|
||
CREATE TABLE `m_storage` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`storage_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '对象存储服务商（目前支持阿里云、minio和本地）',
|
||
`storage_type` int NULL DEFAULT NULL COMMENT '对象存储服务的类型（0.local，1.minio，2.oss）',
|
||
`storage_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '对象存储服务商名称',
|
||
`host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '外链访问地址',
|
||
`endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'API访问地址',
|
||
`access_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账号或者用户识别码',
|
||
`secret_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密钥',
|
||
`bucket_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '存储桶名称',
|
||
`icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'icon的url链接',
|
||
`forced_path_mode` int UNSIGNED NULL DEFAULT 0 COMMENT '是否强制使用路径模式（1.使用2.不使用-默认）',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_deleted` (`is_deleted`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '存储桶表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_storage
|
||
-- ----------------------------
|
||
|
||
-- ----------------------------
|
||
-- Table structure for m_setting
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_setting`;
|
||
CREATE TABLE `m_setting` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置编号',
|
||
`config_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置名称',
|
||
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '配置描述',
|
||
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '配置的值',
|
||
`status` int NULL DEFAULT NULL DEFAULT 0 COMMENT '是否启用（0.启用，1.停用）',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `idx_deleted` (`is_deleted`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统设置表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_setting
|
||
-- ----------------------------
|
||
-- ----------------------------
|
||
-- Table structure for m_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `m_user`;
|
||
CREATE TABLE `m_user` (
|
||
`id` int NOT NULL AUTO_INCREMENT COMMENT '用户id',
|
||
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户名',
|
||
`password` varchar(100) 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 '用户昵称',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户头像',
|
||
`role` int NOT NULL DEFAULT 1 COMMENT '角色',
|
||
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
|
||
`phone_number` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话号码',
|
||
`gender` tinyint NULL DEFAULT NULL COMMENT '性别(0.保密，1.男，2女)',
|
||
`status` int NOT NULL DEFAULT 0 COMMENT '用户状态（0.正常，1.封号）',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
|
||
`is_deleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '删除标识',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
INDEX `user_relo`(`role` ASC) USING BTREE,
|
||
INDEX `idx_deleted` (`is_deleted`) USING BTREE
|
||
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
|
||
|
||
-- ----------------------------
|
||
-- Records of m_user
|
||
-- ----------------------------
|
||
INSERT INTO `m_user` VALUES (1, 'admin', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '超级管理员', 'https://oss.moxiaoli.cn/image/avatar.jpg', 1, '1414212942@qq.com', '12345678901', 1, 0, '2025-04-23 22:31:03', 'admin', '2025-04-23 22:31:03',null, 0);
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|