代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : go-admin
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 30/10/2023 14:31:01
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`admin_name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '管理员名称',
`login_name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登录名字',
`mobile` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号',
`status` smallint(1) NOT NULL DEFAULT 1 COMMENT '状态 1 正常 -1 删除 2 禁用',
`password` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
`head_sculpture` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
`email` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '邮箱',
`role_ids` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '角色ID(多角色逗号分割)',
`update_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间',
`create_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '创建时间',
`login_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '最新登录时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `mobile`(`mobile`, `status`) USING BTREE,
UNIQUE INDEX `email`(`email`, `status`) USING BTREE,
INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后台人员管理' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES (6, '孙小齐', 'SunXQ', '13323433333', 1, '$2a$10$QriQCCHkg/.2SW8SRrKQPet8sLiFZcy2paqKdBs9QiJrj37qLA.KS', 'http://cdn.jdc51.com//dev/07/17/64b4b01469fd5.png?imageView2/2/w/200', '96168@qq.com', '1', 1698485644713, 1695622289863, 0);
INSERT INTO `admins` VALUES (7, '孙小红', 'SunXH', '13323433334', 1, '$2a$10$VZ9OLUIhCar56mK.7UqCj.IZu4079kt1Kruu6gRCM6PKwHzy/KHaa', 'http://cdn.jdc51.com//dev/07/17/64b4b01469fd5.png?imageView2/2/w/200', '96163@qq.com', '1', 1695623091576, 1695622289863, 0);
INSERT INTO `admins` VALUES (17, '测试', 'test', '13122222222', -1, '$2a$10$VZ9OLUIhCar56mK.7UqCj.IZu4079kt1Kruu6gRCM6PKwHzy/KHaa', 'http://cdn.jdc51.com//dev/07/17/64b4b01469fd5.png?imageView2/2/w/200', '123@qq.com', '6,7', 1696404918381, 1695722774099, 0);
INSERT INTO `admins` VALUES (18, '测试', 'test', '13122222222', 1, '$2a$10$1YUBflMQl227LXd2sNy5/OKY7is3exF39yOdW8T0kj3Q.IfX8CA16', '', '123@qq.com', '6,7', 1696404962496, 1696404962496, 0);
-- ----------------------------
-- Table structure for auth_items
-- ----------------------------
DROP TABLE IF EXISTS `auth_items`;
CREATE TABLE `auth_items` (
`role_id` int(10) NOT NULL COMMENT '角色ID',
`menu_url` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授权菜单',
`is_read` smallint(1) NOT NULL COMMENT '是否为读权限 1 读 2 操作',
`menu_id` int(10) NOT NULL COMMENT '菜单ID',
INDEX `role_id`(`role_id`, `menu_url`, `menu_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'RBAC 角色授权表' ROW_FORMAT = FIXED;
-- ----------------------------
-- Records of auth_items
-- ----------------------------
INSERT INTO `auth_items` VALUES (6, '/admin/*', 1, 39);
INSERT INTO `auth_items` VALUES (6, '/rbac/*', 1, 32);
INSERT INTO `auth_items` VALUES (6, '/member', 1, 19);
INSERT INTO `auth_items` VALUES (6, '/menu/*', 1, 26);
INSERT INTO `auth_items` VALUES (6, '/settings', 1, 1);
-- ----------------------------
-- Table structure for auth_roles
-- ----------------------------
DROP TABLE IF EXISTS `auth_roles`;
CREATE TABLE `auth_roles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
`status` smallint(1) NULL DEFAULT 1 COMMENT '状态 1：正常， 2： 禁用， -1： 删除',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '描述',
`create_time` bigint(20) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` bigint(20) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'RBAC-角色表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of auth_roles
-- ----------------------------
INSERT INTO `auth_roles` VALUES (1, '超级管理员', 1, '超级管理员拥有全部权限', 1695534603101, 1695535560597);
INSERT INTO `auth_roles` VALUES (6, '测试', 1, '测试人员', 1695534603101, 1695536363616);
INSERT INTO `auth_roles` VALUES (7, '管理员', 1, '管理员部分权限', 1695536295770, 1695537872941);
-- ----------------------------
-- Table structure for files
-- ----------------------------
DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`old_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '原名字',
`new_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '新名字',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '类型 1图片 2视频',
`file_type` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件类型',
`size` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件大小',
`image` char(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片路径',
`update_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间',
`create_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '图库表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of files
-- ----------------------------
INSERT INTO `files` VALUES (4, '推荐商品', '2693328151262906977', 1, 'image/jpeg', '21961', 'go-admin/2693328151262906977.png', 1698576447176, 1698576447176);
INSERT INTO `files` VALUES (5, 'd8e8a071ec449ef0a796e2dda26e8581.mp4', '14406480881162960224', 2, 'video/mp4', '2319865', 'go-admin/14406480881162960224.mp4', 1698642323541, 1698642323541);
INSERT INTO `files` VALUES (6, '推荐商品1.jpg', '94892484138442257', 1, 'image/jpeg', '19964', 'go-admin/94892484138442257.png', 1698647191103, 1698647191103);
-- ----------------------------
-- Table structure for menus
-- ----------------------------
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`pid` int(11) NOT NULL DEFAULT 0 COMMENT '上级菜单 id 0 为顶级菜单',
`model` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用来解析字段用',
`menu_title` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单名称',
`menu_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '菜单Url （后台接口连接）',
`jump_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '页面跳转链接 ',
`menu_path` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由地址',
`menu_name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '路由名称',
`menu_is_show` smallint(1) NOT NULL DEFAULT 1 COMMENT '是否显示 1 显示 2 隐藏',
`menu_sort` smallint(2) NOT NULL DEFAULT 0 COMMENT '排序',
`menu_status` smallint(1) NOT NULL DEFAULT 1 COMMENT '删除状态 0 正常 -1 删除',
`menu_level` smallint(1) NOT NULL DEFAULT 1 COMMENT '菜单级别',
`update_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '更新时间',
`create_time` bigint(20) NOT NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后端菜单表' ROW_FORMAT = COMPACT;
-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES (1, 0, '', '设置', '/settings', '/', '1', '/settings', 1, 1, 1, 1, 1695473974035, 1695473974035);
INSERT INTO `menus` VALUES (19, 1, '', '管理员', '/member', 'Main', '/member', '/member', 1, 0, 1, 2, 1695827209762, 1695827209762);
INSERT INTO `menus` VALUES (26, 19, '', '菜单管理', '/menu/*', 'sys/menu-manage/menuManage', 'menu-manage', '/menuManage', 1, 1, 1, 3, 1695868779530, 1695868779530);
INSERT INTO `menus` VALUES (32, 19, '', '角色权限', '/rbac/*', 'sys/role-manage/roleManage', 'role-manage', '/role-manage', 1, 2, 1, 3, 1695827256903, 1695827256903);
INSERT INTO `menus` VALUES (39, 19, '', '管理员管理', '/admin/*', 'sys/user-manage/userManage', 'user-manage', '/user-manage', 1, 1, 1, 3, 1695827281081, 1695827281081);
INSERT INTO `menus` VALUES (40, 1, '', '配置', '/sys', 'Main', '/sys', '/sys', 1, 0, 1, 2, 1696999153725, 1696999153725);
INSERT INTO `menus` VALUES (41, 40, '', '第三方配置', '/setting', 'sys/setting-manage/settingManage', 'setting', '/setting', 1, 0, 1, 3, 1696999184726, 1696999184726);
INSERT INTO `menus` VALUES (42, 0, '', '文件', '/file', '/', '', 'file', 1, 0, 1, 1, 1698217218814, 1698217218814);
INSERT INTO `menus` VALUES (43, 42, '', '文件操作', '/file-op', 'Main', 'file-op', 'file-op', 1, 0, 1, 2, 1698217269930, 1698217269930);
INSERT INTO `menus` VALUES (44, 43, '', '图片资源', '/oss-manage', 'sys/oss-manage/ossManage', '/oss-manage', '/oss-manage', 1, 0, 1, 3, 1698217325493, 1698217325493);
-- ----------------------------
-- Table structure for settings
-- ----------------------------
DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(1) NOT NULL DEFAULT 1 COMMENT ' 1:短信 , 2 静态资源配置',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '配置内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of settings
-- ----------------------------
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`password` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
`ctime` bigint(20) NULL DEFAULT NULL,
`utime` bigint(20) NULL DEFAULT NULL,
`wechat_open_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
`wechat_union_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `email`(`email`) USING BTREE,
UNIQUE INDEX `phone`(`phone`) USING BTREE,
UNIQUE INDEX `wechat_union_id`(`wechat_union_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, NULL, NULL, '', 1694766466802, 1694766466802, 'oaDol6eGPvAB7QxJS98btQPZefH8', 'o_Jll6v5LlCjvteSEfZBdYA0KB1I}');
INSERT INTO `users` VALUES (2, NULL, NULL, '', 1694766560260, 1694766560260, NULL, NULL);
INSERT INTO `users` VALUES (3, NULL, NULL, '', 1694766605410, 1694766605410, NULL, NULL);
INSERT INTO `users` VALUES (4, NULL, NULL, '', 1694767250203, 1694767250203, NULL, NULL);
INSERT INTO `users` VALUES (5, NULL, NULL, '', 1694767827824, 1694767827824, NULL, NULL);
INSERT INTO `users` VALUES (6, '12131@qq.com', NULL, '$2a$10$ynyls65lDn4IKezch6W0x.Dla5/0zDE.eMKjeFCjSjqqsrf3hSWbG', 1694920502928, 1694920502928, NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
