/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80030
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 80030
 File Encoding         : 65001

 Date: 24/04/2023 22:44:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `article_category_id` int NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `top` tinyint DEFAULT '0' COMMENT '是否置顶',
  `sort` int DEFAULT '0',
  `status` int DEFAULT '1' COMMENT '状态 0 隐藏 1 显示',
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pid` int DEFAULT '0' COMMENT '对应原本的id，如果有的就是发布的，没有的就是默认保存的',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='文章表';

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1, '文章一', 'storage/topic/20210301\\6906862ce43bdce3991e0054431992c6.jpg', 'http://127.0.0.1:3000/upload/20230424/656c85243876a21cf8dad20538f72541.webp', 4, '<p>9090</p>', 1, 0, 1, NULL, '2023-04-24 13:56:33.000000', NULL, 1, 'asd,测试', NULL);
INSERT INTO `article` VALUES (16, '546', '', NULL, 1, '<p>789</p>', 0, 100, 1, NULL, NULL, NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for article_category
-- ----------------------------
DROP TABLE IF EXISTS `article_category`;
CREATE TABLE `article_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pid` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `sort` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of article_category
-- ----------------------------
BEGIN;
INSERT INTO `article_category` VALUES (1, '顶级分类', 0, 1, NULL, '2023-04-24 13:37:57.000000', NULL, 10);
INSERT INTO `article_category` VALUES (4, '分类一', 1, 1, NULL, NULL, NULL, 10);
INSERT INTO `article_category` VALUES (5, '101010', 1, 1, '2023-04-24 13:38:02.000000', '2023-04-24 13:38:11.000000', '2023-04-24 13:38:11.000000', 111);
INSERT INTO `article_category` VALUES (6, '00', 4, 1, '2023-04-24 13:38:17.000000', '2023-04-24 13:38:19.000000', '2023-04-24 13:38:19.000000', 11);
COMMIT;

-- ----------------------------
-- Table structure for banner
-- ----------------------------
DROP TABLE IF EXISTS `banner`;
CREATE TABLE `banner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '种类，不填默认用户端首页',
  `status` tinyint DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='轮播图';

-- ----------------------------
-- Records of banner
-- ----------------------------
BEGIN;
INSERT INTO `banner` VALUES (1, 'http://baidu.com', NULL, NULL, '标题', '备注', 'http://swimming.pkl.cc:18080/storage/20220302/0fc7bb3c37e2cbd9181031aae5e8bd1c.jpg', 10, '', 1);
INSERT INTO `banner` VALUES (2, 'asdsadsad', NULL, NULL, 'asd', '', 'http://swimming.pkl.cc:18080/storage/20220302/ad78b37ad2c7603a2b52b29af8a7b3b0.jpg', 101, '', 1);
INSERT INTO `banner` VALUES (3, 'sadsa', NULL, NULL, 'asdsa', 'asdsa', 'http://swimming.pkl.cc:18080/storage/20220302/c645e3683b7d01e50a8e76b03c78a000.webp', 99, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `pid` int DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of dept
-- ----------------------------
BEGIN;
INSERT INTO `dept` VALUES (1, '公司', '2022-09-12 17:59:47.000000', '2022-09-12 17:59:47.000000', NULL, 0);
INSERT INTO `dept` VALUES (3, '总裁办', '2022-09-12 17:59:47.000000', '2022-09-12 23:54:00.000000', '2022-09-12 23:54:00.000000', 1);
INSERT INTO `dept` VALUES (4, '员工12', '2022-09-12 18:14:22.000000', '2022-09-12 18:14:22.000000', NULL, 0);
INSERT INTO `dept` VALUES (5, '总裁办', '2022-09-12 22:52:18.000000', '2022-09-12 23:54:02.000000', '2022-09-12 23:54:02.000000', 1);
INSERT INTO `dept` VALUES (6, '总裁办', '2022-09-12 22:52:39.000000', '2022-09-12 23:54:04.000000', '2022-09-12 23:54:04.000000', 1);
INSERT INTO `dept` VALUES (7, '总裁办', '2022-09-12 22:58:05.000000', '2023-04-24 13:22:38.000000', '2023-04-24 13:22:38.000000', 1);
INSERT INTO `dept` VALUES (8, '总裁办', '2022-09-12 23:02:25.000000', '2022-09-12 23:54:08.000000', '2022-09-12 23:54:08.000000', 1);
INSERT INTO `dept` VALUES (9, '总裁办', '2022-09-12 23:02:27.000000', '2022-09-12 23:54:06.000000', '2022-09-12 23:54:06.000000', 1);
INSERT INTO `dept` VALUES (10, '总裁办', '2022-09-12 23:53:54.000000', '2022-09-12 23:53:54.000000', NULL, 1);
INSERT INTO `dept` VALUES (11, '总裁办', '2023-04-23 16:34:32.000000', '2023-04-24 13:22:40.000000', '2023-04-24 13:22:40.000000', 1);
INSERT INTO `dept` VALUES (12, '总裁办', '2023-04-23 16:42:08.000000', '2023-04-24 13:22:43.000000', '2023-04-24 13:22:43.000000', 1);
INSERT INTO `dept` VALUES (13, '总裁办', '2023-04-23 16:50:08.000000', '2023-04-23 17:03:01.000000', '2023-04-23 17:03:01.000000', 1);
INSERT INTO `dept` VALUES (14, '公司123465', '2023-04-24 02:48:23.000000', '2023-04-24 03:01:23.000000', NULL, 1);
INSERT INTO `dept` VALUES (15, '总裁办', '2023-04-24 02:59:50.000000', '2023-04-24 02:59:50.000000', NULL, 1);
INSERT INTO `dept` VALUES (16, '总裁办', '2023-04-24 03:00:05.000000', '2023-04-24 03:00:05.000000', NULL, 1);
INSERT INTO `dept` VALUES (17, '总裁办', '2023-04-24 03:16:16.000000', '2023-04-24 03:16:16.000000', NULL, 1);
INSERT INTO `dept` VALUES (18, '总裁办', '2023-04-24 03:23:09.000000', '2023-04-24 03:23:09.000000', NULL, 1);
INSERT INTO `dept` VALUES (19, '总裁办', '2023-04-24 03:24:07.000000', '2023-04-24 03:24:07.000000', NULL, 1);
INSERT INTO `dept` VALUES (20, '总裁办', '2023-04-24 03:24:46.000000', '2023-04-24 03:24:46.000000', NULL, 1);
INSERT INTO `dept` VALUES (21, '总裁办', '2023-04-24 03:35:57.000000', '2023-04-24 03:35:57.000000', NULL, 1);
INSERT INTO `dept` VALUES (22, '测试', '2023-04-24 13:22:58.000000', '2023-04-24 13:22:58.000000', NULL, 14);
COMMIT;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` int NOT NULL AUTO_INCREMENT,
  `realname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真名',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信名',
  `avatar` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint DEFAULT NULL COMMENT '性别',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `oa_openid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mp_openid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户端',
  `unionid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  `sso` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contry` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `balance` decimal(10,2) DEFAULT '0.00' COMMENT '余额',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES (1, '测试用户', '测试用户', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2F5b0988e595225.cdn.sohucs.com%2Fq_70%2Cc_zoom%2Cw_640%2Fimages%2F20181008%2F802f7688ce464540a97d8329d0abf38b.jpeg&refer=http%3A%2F%2F5b0988e595225.cdn.sohucs.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1647063578&t=1ba5e7b9149adf9006971099d47441b9', '18680000000', 1, '1999-10-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 9960.00);
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '路由名称|资源名称',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
  `pid` int NOT NULL DEFAULT '0' COMMENT '父级标识',
  `type` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '类别 1 目录  path 2 菜单 menu  3 按钮 action',
  `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'path',
  `redirect` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'redirect',
  `component` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'component',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态 1 正常 0 隐藏',
  `icon` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'icon',
  `keepAlive` tinyint NOT NULL DEFAULT '0' COMMENT 'keepAlive',
  `hidden` tinyint NOT NULL DEFAULT '0' COMMENT 'hidden',
  `hideChildrenInMenu` tinyint NOT NULL DEFAULT '0' COMMENT 'hideChildrenInMenu',
  `blank` tinyint NOT NULL DEFAULT '0' COMMENT 'blank 1 外部链接 0 默认内部',
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `sort` int DEFAULT '100' COMMENT '越大越靠前',
  `affix` tinyint DEFAULT '0' COMMENT '固定图标路由',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (1, 'Index', '平台', 0, 'path', '/', '/dashboard', 'BasicLayout', 1, 'smile-o', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (2, 'Dashboard', '仪表盘', 1, 'menu', '/dashboard', '', 'Dashboard', 1, 'el-icon-s-home', 0, 0, 0, 0, NULL, NULL, NULL, 100, 1);
INSERT INTO `menu` VALUES (5, 'System', '系统管理', 1, 'path', '/system', '/system/menu', 'PageView', 1, 'el-icon-setting', 0, 0, 0, 0, NULL, NULL, NULL, 999, 0);
INSERT INTO `menu` VALUES (6, 'Menu', '菜单管理', 5, 'menu', '/system/menu', '', 'Menu', 1, 'el-icon-menu', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (7, 'Role', '角色列表', 13, 'menu', '/system/role/list', '', 'Role', 1, 'el-icon-s-open', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (8, 'Account', '用户列表', 17, 'menu', '/system/account/list', '', 'User', 1, 'el-icon-user-solid', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (9, 'Dept', '部门管理', 5, 'menu', '/system/dept', '', 'Dept', 1, 'el-icon-s-cooperation', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (12, 'UpdateRole', '更新角色', 13, 'menu', '/system/role/:id', '', 'RoleForm', 1, '', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (13, 'RoleManage', '角色管理', 5, 'path', '/system/role', '/system/role/list', 'PageView', 1, '', 0, 0, 1, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (15, 'CreateRole', '创建角色', 13, 'menu', '/system/role/create', '', 'RoleForm', 1, '', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (16, 'CreateAccount', '创建用户', 17, 'menu', '/system/account/create', '', 'AccountForm', 1, '', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (17, 'AccountManage', '用户管理', 5, 'path', '/system/account', '/system/account/list', 'PageView', 1, '', 0, 0, 1, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (18, 'UpdateAccount', '更新用户', 17, 'menu', '/system/account/:id/update', '', 'AccountForm', 1, 'AccessibilityOutline', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (19, 'ArticleManage', '文章管理', 1, 'path', '/article', '/article/list', 'PageView', 1, 'el-icon-notebook-2', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (20, 'Article', '文章列表', 19, 'menu', '/article/list', '', 'Article', 1, 'el-icon-document', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (21, 'ArticleCategory', '类目列表', 19, 'menu', '/article/category', '', 'ArticleCategory', 1, 'el-icon-s-promotion', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (22, 'ArticleCreate', '创建文章', 19, 'menu', '/article/create', '', 'ArticleCreate', 1, 'el-icon-document', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (23, 'ArticleUpdate', '更新文章', 19, 'menu', '/article/:id/update', '', 'ArticleCreate', 1, 'el-icon-document', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (24, 'Profile', '个人页', 1, 'path', '/account', '/account/settings', 'PageView', 1, 'el-icon-user-solid', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (25, 'ProfileAccount', '个人中心', 24, 'menu', '/account/center', '', 'Center', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (26, 'ProfileSetting', '个人设置', 24, 'menu', '/account/settings', '', 'ProfileSetting', 1, 'el-icon-user-solid', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (76, 'List', '列表', 69, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 0, 0);
INSERT INTO `menu` VALUES (79, 'AddDeptAction', '添加部门', 9, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 0, 0);
INSERT INTO `menu` VALUES (80, 'DeleteDeptAction', '删除部门', 9, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 0, 0);
INSERT INTO `menu` VALUES (81, 'UpdateDeptAction', '修改部门', 9, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 0, 0);
INSERT INTO `menu` VALUES (84, 'TestAction', '测试权限', 83, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (89, 'AddMenuAction', '新增菜单', 6, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (90, 'UpdateMenuAction', '修改菜单', 6, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (91, 'DeleteMenuAction', '删除菜单', 6, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (92, 'FetchMenuAction', '菜单列表', 6, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (93, 'FetchDeptAction', '部门列表', 9, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (94, 'AddRoleAction', '新增角色', 7, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (95, 'UpdateRoleAction', '修改角色', 7, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (96, 'DeleteRoleAction', '删除角色', 7, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (97, 'FetchRoleAction', '角色列表', 7, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (98, 'AddUserAction', '新增用户', 8, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (99, 'UpdateUserAction', '修改用户', 8, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (100, 'DeleteUserAction', '删除用户', 8, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (101, 'FetchUserAction', '用户列表', 8, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (102, 'AddArticleAction', '新增文章', 20, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (103, 'UpdateArticleAction', '修改文章', 20, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (104, 'DeleteArticleAction', '删除文章', 20, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (105, 'FetchArticleAction', '文章列表', 20, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (106, 'AddArticleCategoryAction', '新增文章类目', 21, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (107, 'UpdateArticleCategoryAction', '修改文章类目', 21, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (108, 'DeleteArticleCategoryAction', '删除文章类目', 21, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (109, 'FetchArticleCategoryAction', '文章类目列表', 21, 'action', '', '', '', 1, '', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (110, 'FormPage', '表单组件', 1, 'menu', '/form', '', 'FormPage', 1, 'el-icon-platform-eleme', 0, 0, 0, 0, NULL, NULL, NULL, 100, 0);
INSERT INTO `menu` VALUES (111, 'PlatformManage', '平台配置', 1, 'path', '/plaform', '/plaform/company_detail', 'RouterView', 1, 'el-icon-s-home', 0, 1, 0, 0, NULL, NULL, NULL, 100, 0);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `menus` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `menus_children` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `pid` int DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, '管理员', '1,2,5,6,89,90,91,92,9,79,80,81,93,13,7,94,95,96,97,12,15,17,8,98,99,100,101,16,18,19,20,102,103,104,105,21,106,107,108,109,22,23,24,25,26,110,111', '1,2,5,6,89,90,91,92,9,79,80,81,93,13,7,94,95,96,97,12,15,17,8,98,99,100,101,16,18,19,20,102,103,104,105,21,106,107,108,109,22,23,24,25,26,110,111', NULL, NULL, NULL, 0);
INSERT INTO `role` VALUES (2, '员工1', '1,2,3,4', '1,2,3,4', NULL, '2023-04-24 13:26:13.000000', NULL, 0);
INSERT INTO `role` VALUES (3, '测试', NULL, NULL, '2022-09-12 23:18:06.000000', '2023-04-24 13:17:29.000000', '2023-04-24 13:17:29.000000', 1);
COMMIT;

-- ----------------------------
-- Table structure for role_access
-- ----------------------------
DROP TABLE IF EXISTS `role_access`;
CREATE TABLE `role_access` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_id` int NOT NULL,
  `dept_id` int NOT NULL DEFAULT '0',
  `user_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of role_access
-- ----------------------------
BEGIN;
INSERT INTO `role_access` VALUES (29, 1, 0, 11);
INSERT INTO `role_access` VALUES (32, 1, 0, 2);
INSERT INTO `role_access` VALUES (46, 4, 2, 0);
INSERT INTO `role_access` VALUES (50, 4, 3, 0);
INSERT INTO `role_access` VALUES (78, 4, 5, 0);
INSERT INTO `role_access` VALUES (122, 4, 6, 0);
INSERT INTO `role_access` VALUES (166, 4, 7, 0);
INSERT INTO `role_access` VALUES (170, 4, 8, 0);
INSERT INTO `role_access` VALUES (174, 4, 9, 0);
INSERT INTO `role_access` VALUES (180, 3, 9, 0);
INSERT INTO `role_access` VALUES (181, 1, 10, 0);
INSERT INTO `role_access` VALUES (182, 2, 10, 0);
INSERT INTO `role_access` VALUES (183, 3, 10, 0);
INSERT INTO `role_access` VALUES (184, 4, 10, 0);
INSERT INTO `role_access` VALUES (185, 1, 0, 0);
INSERT INTO `role_access` VALUES (186, 2, 0, 0);
INSERT INTO `role_access` VALUES (187, 3, 0, 0);
INSERT INTO `role_access` VALUES (188, 4, 0, 0);
INSERT INTO `role_access` VALUES (189, 1, 0, 0);
INSERT INTO `role_access` VALUES (190, 2, 0, 0);
INSERT INTO `role_access` VALUES (191, 3, 0, 0);
INSERT INTO `role_access` VALUES (192, 4, 0, 0);
INSERT INTO `role_access` VALUES (193, 1, 20, 0);
INSERT INTO `role_access` VALUES (194, 2, 20, 0);
INSERT INTO `role_access` VALUES (195, 3, 20, 0);
INSERT INTO `role_access` VALUES (196, 4, 20, 0);
INSERT INTO `role_access` VALUES (197, 1, 21, 0);
INSERT INTO `role_access` VALUES (198, 2, 21, 0);
INSERT INTO `role_access` VALUES (199, 3, 21, 0);
INSERT INTO `role_access` VALUES (200, 4, 21, 0);
INSERT INTO `role_access` VALUES (212, 1, 0, 42);
INSERT INTO `role_access` VALUES (213, 2, 0, 42);
INSERT INTO `role_access` VALUES (214, 1, 0, 42);
INSERT INTO `role_access` VALUES (215, 1, 0, 2);
INSERT INTO `role_access` VALUES (216, 1, 0, 3);
INSERT INTO `role_access` VALUES (217, 1, 0, 24);
INSERT INTO `role_access` VALUES (218, 1, 10, 0);
INSERT INTO `role_access` VALUES (219, 1, 20, 0);
INSERT INTO `role_access` VALUES (220, 1, 21, 0);
INSERT INTO `role_access` VALUES (221, 1, 4, 0);
INSERT INTO `role_access` VALUES (222, 1, 22, 0);
INSERT INTO `role_access` VALUES (223, 2, 22, 0);
INSERT INTO `role_access` VALUES (224, 1, 0, 1);
INSERT INTO `role_access` VALUES (225, 1, 0, 2);
INSERT INTO `role_access` VALUES (226, 1, 0, 3);
INSERT INTO `role_access` VALUES (227, 1, 0, 24);
INSERT INTO `role_access` VALUES (228, 1, 0, 44);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `delete_time` datetime(6) DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint DEFAULT '1' COMMENT '1正常，0拉黑',
  `dept_id` int DEFAULT NULL,
  `sso` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '单点登录标识',
  `is_super` tinyint DEFAULT '0' COMMENT '超级管理员',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `唯一用户` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2022-09-12 12:59:23.000000', '2023-04-24 06:04:49.000000', NULL, '超级管理员', 'https://img1.baidu.com/it/u=3906283889,250716804&fm=253&fmt=auto&app=138&f=PNG?w=500&h=500', '1800000000', NULL, 1, 1, NULL, 0);
INSERT INTO `user` VALUES (2, '456', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2022-09-12 12:59:23.000000', '2023-04-23 10:13:25.000000', NULL, '管理员', 'https://img1.baidu.com/it/u=3906283889,250716804&fm=253&fmt=auto&app=138&f=PNG?w=500&h=500', NULL, NULL, 1, 1, NULL, 0);
INSERT INTO `user` VALUES (3, 'test3', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2022-09-12 12:59:23.000000', NULL, NULL, '管理员', 'https://img1.baidu.com/it/u=3906283889,250716804&fm=253&fmt=auto&app=138&f=PNG?w=500&h=500', NULL, NULL, 1, 1, NULL, 0);
INSERT INTO `user` VALUES (24, 'test', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2023-04-24 03:37:28.000000', '2023-04-24 03:37:28.000000', NULL, '管理员', 'https://img1.baidu.com/it/u=3906283889,250716804&fm=253&fmt=auto&app=138&f=PNG?w=500&h=500', NULL, NULL, 1, 1, NULL, 0);
INSERT INTO `user` VALUES (42, 'test123', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2023-04-24 10:52:20.000000', '2023-04-24 10:52:20.000000', NULL, '213', NULL, '333333', NULL, 1, 11, NULL, 0);
INSERT INTO `user` VALUES (44, 'test111', '10470c3b4b1fed12c3baac014be15fac67c6e815', '2023-04-24 13:27:03.000000', '2023-04-24 13:27:03.000000', NULL, '213', NULL, '2133333', NULL, 1, 16, NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;