/*
SQLyog Enterprise - MySQL GUI v8.1 
MySQL - 5.5.53-log : Database - vipsoft_security
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `sys_menu` */

DROP TABLE IF EXISTS `sys_menu`;

CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) DEFAULT NULL COMMENT '路由参数',
  `is_frame` int(1) DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `is_cache` int(1) DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2351 DEFAULT CHARSET=utf8mb4 COMMENT='菜单权限表';

/*Data for the table `sys_menu` */

insert  into `sys_menu`(menu_id,menu_name,parent_id,order_num,path,component,query,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,update_by,update_time,remark) values (1,'系统管理',0,99,'system',NULL,'',1,0,'M','0','0','','system','admin','2021-12-14 14:33:52','admin','2022-01-22 15:38:33','系统管理目录'),(10,'权限管理',1,1,'peopleConfig',NULL,NULL,1,0,'M','0','0','','user','admin','2022-04-15 12:31:58','admin','2022-04-15 12:35:14',''),(100,'用户管理',10,1,'user','system/user/index','',1,0,'C','0','0','system:user:list','#','admin','2021-12-14 14:33:52','admin','2022-04-15 12:32:12','用户管理菜单'),(101,'角色管理',10,2,'role','system/role/index','',1,0,'C','0','0','system:role:list','#','admin','2021-12-14 14:33:52','admin','2022-04-15 12:32:19','角色管理菜单'),(102,'菜单管理',10,3,'menu','system/menu/index','',1,0,'C','0','0','system:menu:list','tree-table','admin','2021-12-14 14:33:52','',NULL,'菜单管理菜单'),(103,'部门管理',10,3,'dept','system/dept/index','',1,0,'C','0','0','system:dept:list','#','admin','2021-12-14 14:33:52','admin','2022-04-15 12:33:51','部门管理菜单'),(104,'岗位管理',10,4,'post','system/post/index','',1,0,'C','0','0','system:post:list','#','admin','2021-12-14 14:33:52','admin','2022-04-15 12:33:58','岗位管理菜单'),(1001,'用户查询',100,1,'','','',1,0,'F','0','0','system:user:query','#','admin','2021-12-14 14:33:52','',NULL,''),(1002,'用户新增',100,2,'','','',1,0,'F','0','0','system:user:add','#','admin','2021-12-14 14:33:52','',NULL,''),(1003,'用户修改',100,3,'','','',1,0,'F','0','0','system:user:edit','#','admin','2021-12-14 14:33:52','',NULL,''),(1004,'用户删除',100,4,'','','',1,0,'F','0','0','system:user:remove','#','admin','2021-12-14 14:33:52','',NULL,''),(1005,'用户导出',100,5,'','','',1,0,'F','0','0','system:user:export','#','admin','2021-12-14 14:33:52','',NULL,''),(1006,'用户导入',100,6,'','','',1,0,'F','0','0','system:user:import','#','admin','2021-12-14 14:33:52','',NULL,''),(1007,'重置密码',100,7,'','','',1,0,'F','0','0','system:user:resetPwd','#','admin','2021-12-14 14:33:52','',NULL,''),(1008,'角色查询',101,1,'','','',1,0,'F','0','0','system:role:query','#','admin','2021-12-14 14:33:52','',NULL,''),(1009,'角色新增',101,2,'','','',1,0,'F','0','0','system:role:add','#','admin','2021-12-14 14:33:52','',NULL,''),(1010,'角色修改',101,3,'','','',1,0,'F','0','0','system:role:edit','#','admin','2021-12-14 14:33:52','',NULL,''),(1011,'角色删除',101,4,'','','',1,0,'F','0','0','system:role:remove','#','admin','2021-12-14 14:33:52','',NULL,''),(1012,'角色导出',101,5,'','','',1,0,'F','0','0','system:role:export','#','admin','2021-12-14 14:33:52','',NULL,''),(1013,'菜单查询',102,1,'','','',1,0,'F','0','0','system:menu:query','#','admin','2021-12-14 14:33:52','',NULL,''),(1014,'菜单新增',102,2,'','','',1,0,'F','0','0','system:menu:add','#','admin','2021-12-14 14:33:52','',NULL,''),(1015,'菜单修改',102,3,'','','',1,0,'F','0','0','system:menu:edit','#','admin','2021-12-14 14:33:52','',NULL,''),(1016,'菜单删除',102,4,'','','',1,0,'F','0','0','system:menu:remove','#','admin','2021-12-14 14:33:52','',NULL,''),(1017,'部门查询',103,1,'','','',1,0,'F','0','0','system:dept:query','#','admin','2021-12-14 14:33:52','',NULL,''),(1018,'部门新增',103,2,'','','',1,0,'F','0','0','system:dept:add','#','admin','2021-12-14 14:33:52','',NULL,''),(1019,'部门修改',103,3,'','','',1,0,'F','0','0','system:dept:edit','#','admin','2021-12-14 14:33:52','',NULL,''),(1020,'部门删除',103,4,'','','',1,0,'F','0','0','system:dept:remove','#','admin','2021-12-14 14:33:52','',NULL,''),(1021,'岗位查询',104,1,'','','',1,0,'F','0','0','system:post:query','#','admin','2021-12-14 14:33:52','',NULL,''),(1022,'岗位新增',104,2,'','','',1,0,'F','0','0','system:post:add','#','admin','2021-12-14 14:33:52','',NULL,''),(1023,'岗位修改',104,3,'','','',1,0,'F','0','0','system:post:edit','#','admin','2021-12-14 14:33:52','',NULL,''),(1024,'岗位删除',104,4,'','','',1,0,'F','0','0','system:post:remove','#','admin','2021-12-14 14:33:52','',NULL,''),(1025,'岗位导出',104,5,'','','',1,0,'F','0','0','system:post:export','#','admin','2021-12-14 14:33:52','',NULL,'');

/*Table structure for table `sys_role` */

DROP TABLE IF EXISTS `sys_role`;

CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menu_check_strictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `dept_check_strictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COMMENT='角色信息表';

/*Data for the table `sys_role` */

insert  into `sys_role`(role_id,role_name,role_key,role_sort,data_scope,menu_check_strictly,dept_check_strictly,status,del_flag,create_by,create_time,update_by,update_time,remark) values (1,'超级管理员','admin',1,'1',1,1,'0','0','admin','2021-12-14 14:33:51','',NULL,'超级管理员'),(102,'管理员','manage',2,'1',1,1,'0','0','admin','2022-02-15 10:17:05','admin','2022-11-29 14:12:25',NULL),(104,'测试角色','testRole',4,'1',1,1,'0','0','admin','2022-02-14 17:15:35','admin','2022-04-05 22:11:03',NULL);

/*Table structure for table `sys_role_menu` */

DROP TABLE IF EXISTS `sys_role_menu`;

CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色和菜单关联表';

/*Data for the table `sys_role_menu` */

insert  into `sys_role_menu`(role_id,menu_id) values (102,1),(102,100),(102,101),(102,102),(102,103),(102,104),(102,1001),(102,1002),(102,1003),(102,1004),(102,1005),(102,1006),(102,1007),(102,1008),(102,1009),(102,1010),(102,1011),(102,1012),(102,1013),(102,1014),(102,1015),(102,1016),(102,1017),(102,1018),(102,1019),(102,1020),(102,1021),(102,1022),(102,1023),(102,1024),(102,1025),(104,1),(104,100),(104,1001),(104,1002),(104,1003),(104,1004),(104,1005),(104,1006),(104,1007);

/*Table structure for table `sys_user` */

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `user_name` varchar(30) NOT NULL COMMENT '用户账号',
  `nick_name` varchar(30) NOT NULL COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `emailPassword` varchar(100) DEFAULT NULL COMMENT '邮箱密码',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) DEFAULT '' COMMENT '密码',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(128) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `customer_id` varchar(50) DEFAULT NULL COMMENT '客户ID',
  `is_inform` varchar(5) DEFAULT 'true' COMMENT 'APP弹窗通知',
  PRIMARY KEY (`user_id`) USING BTREE,
  KEY `index_user_name` (`user_name`) USING BTREE,
  KEY `index_user_type` (`user_type`) USING BTREE,
  KEY `index_user_id` (`user_id`) USING BTREE,
  KEY `index_dept_id` (`dept_id`) USING BTREE,
  KEY `idx_sys_user_user` (`nick_name`,`user_name`) USING BTREE,
  KEY `index_del_flag_status` (`status`,`del_flag`) USING BTREE,
  KEY `index_customer_id` (`customer_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6348 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

/*Data for the table `sys_user` */

insert  into `sys_user`(user_id,dept_id,user_name,nick_name,user_type,email,emailPassword,phonenumber,sex,avatar,password,status,del_flag,login_ip,login_date,create_by,create_time,update_by,update_time,remark,customer_id,is_inform) values (1,100,'superadmin','超级管理员','00','12@163.com','','13800000000','1','','$2a$10$yjaVV2IupdXe70ZAXVS7h.aWfz0UnTZgeHX1JG3B7yF2dcEluUUsq','0','0','','2022-12-30 10:40:45','admin','2021-12-14 14:33:50','admin','2022-12-30 10:40:44','管理员',NULL,'true'),(2,101,'admin','系统管理员','00','12@163.com','','13800000001','0','','$2a$10$yjaVV2IupdXe70ZAXVS7h.aWfz0UnTZgeHX1JG3B7yF2dcEluUUsq','0','0','','2022-03-24 14:47:06','admin','2022-02-14 17:17:56','admin','2022-04-25 15:53:06',NULL,NULL,'true'),(3,103,'test','测试','00','12@163.com','','13800000002','0','','$2a$10$yjaVV2IupdXe70ZAXVS7h.aWfz0UnTZgeHX1JG3B7yF2dcEluUUsq','0','0','','2022-04-27 20:09:48','admin','2022-02-15 10:36:11','admin','2022-07-13 00:44:26',NULL,NULL,'true');

/*Table structure for table `sys_user_role` */

DROP TABLE IF EXISTS `sys_user_role`;

CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户和角色关联表';

/*Data for the table `sys_user_role` */

insert  into `sys_user_role`(user_id,role_id) values (2,102),(3,104);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;