/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.35 : Database - fras
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`fras` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `fras`;

/*Table structure for table `attendance` */

DROP TABLE IF EXISTS `attendance`;

CREATE TABLE `attendance` (
  `id` varchar(20) NOT NULL COMMENT 'id',
  `group_id` varchar(20) NOT NULL COMMENT '组id',
  `description` varchar(200) NOT NULL COMMENT '考勤描述',
  `start_time` datetime NOT NULL COMMENT '开始时间',
  `end_time` datetime NOT NULL COMMENT '结束时间',
  `total_count` int(11) NOT NULL DEFAULT '0' COMMENT '总人数',
  `actual_count` int(11) NOT NULL DEFAULT '0' COMMENT '实到人数',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '考勤开启为1，关闭为0',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `version` int(11) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='考勤表';

/*Data for the table `attendance` */

LOCK TABLES `attendance` WRITE;

INSERT  INTO `attendance`(`id`,`group_id`,`description`,`start_time`,`end_time`,`total_count`,`actual_count`,`status`,`create_time`,`update_time`,`version`,`deleted`) VALUES ('1d5e6c7fb3d54341a42b5cb3fe68985f','1455160640322854914','测试9','2021-11-05 20:30:00','2021-11-05 20:40:00',2,0,0,'2021-11-06 19:44:04','2021-11-06 19:44:04',1,0),('202a3d7a0c88441fb90daffc4d18e34a','1455160640322854914','测试8','2021-11-06 19:40:00','2021-11-06 19:50:00',2,0,0,'2021-11-06 19:14:53','2021-11-06 19:14:53',1,0),('3ad7a2aee1af4bb8865c0cc8487f413b','1455160640322854914','测试7','2021-11-06 20:10:00','2021-11-06 20:20:00',2,0,2,'2021-11-06 19:18:17','2021-11-06 19:18:17',1,0),('44a79b16f795446ba0b1f3cf5e12997b','1455160640322854914','测试6','2021-11-05 20:10:00','2021-11-05 20:20:00',2,0,0,'2021-11-06 19:43:48','2021-11-06 19:43:48',1,0),('4e43fe114fac4355a3ff316d0926868f','1455147693521461249','测试5','2021-11-05 19:40:00','2021-11-05 19:50:00',3,0,0,'2021-11-05 19:38:56','2021-11-05 19:38:56',1,0),('56868cbc3d03477b870d0370903650e4','1455160640322854914','测试4','2021-11-06 19:40:00','2021-11-06 19:50:00',2,0,0,'2021-11-06 19:17:08','2021-11-06 19:17:08',1,0),('5f9d929e4f264d108589313a4525a95f','1455160640322854914','测试3','2021-11-05 21:00:00','2021-11-05 21:10:00',2,0,0,'2021-11-06 19:44:35','2021-11-06 19:44:35',1,0),('653ff0f3302e4f10a41ee32e8b7cc007','1455160640322854914','测试2','2021-11-05 20:45:00','2021-11-05 20:55:00',2,0,0,'2021-11-06 19:44:12','2021-11-06 19:44:12',1,0),('73de557fc63141c3b0830ea212611dbb','1455160640322854914','测试1','2021-11-06 19:50:00','2021-11-06 20:00:00',2,0,1,'2021-11-06 19:17:48','2021-11-06 19:17:48',1,0),('b2181e6be0e94157af2dab472cf7740a','1455147693521461249','测试','2021-11-05 19:20:00','2021-11-05 19:25:00',3,0,0,'2021-11-05 19:19:04','2021-11-05 19:34:18',2,0);

UNLOCK TABLES;

/*Table structure for table `attendance_user` */

DROP TABLE IF EXISTS `attendance_user`;

CREATE TABLE `attendance_user` (
  `id` varchar(20) NOT NULL COMMENT 'id',
  `user_id` varchar(20) NOT NULL COMMENT '用户id',
  `attendance_id` varchar(20) NOT NULL COMMENT '考勤id',
  `status` varchar(20) NOT NULL COMMENT '考勤状态',
  `attendance_time` datetime DEFAULT NULL COMMENT '考勤成功时间',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `version` int(11) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户考勤记录';

/*Data for the table `attendance_user` */

LOCK TABLES `attendance_user` WRITE;

UNLOCK TABLES;

/*Table structure for table `group_user` */

DROP TABLE IF EXISTS `group_user`;

CREATE TABLE `group_user` (
  `id` VARCHAR(20) NOT NULL COMMENT '主键id',
  `user_id` VARCHAR(20) NOT NULL COMMENT '用户id',
  `group_id` VARCHAR(20) NOT NULL COMMENT '组id',
  `create_time` DATETIME NOT NULL COMMENT '创建时间',
  `update_time` DATETIME NOT NULL COMMENT '更新时间',
  `version` INT(11) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` INT(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='组成员表';

/*Data for the table `group_user` */

LOCK TABLES `group_user` WRITE;

UNLOCK TABLES;

/*Table structure for table `management_group` */

DROP TABLE IF EXISTS `management_group`;

CREATE TABLE `management_group` (
  `id` VARCHAR(20) NOT NULL COMMENT '组id',
  `name` VARCHAR(50) NOT NULL COMMENT '组名',
  `description` VARBINARY(200) NOT NULL COMMENT '描述',
  `admin_id` VARCHAR(20) NOT NULL COMMENT '管理员id',
  `code` VARCHAR(10) NOT NULL COMMENT '标识码',
  `count` INT(11) NOT NULL DEFAULT '0' COMMENT '人数',
  `create_time` DATETIME NOT NULL COMMENT '创建时间',
  `update_time` DATETIME NOT NULL COMMENT '更新时间',
  `version` INT(11) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` INT(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='管理组表';

/*Data for the table `management_group` */

LOCK TABLES `management_group` WRITE;


UNLOCK TABLES;

/*Table structure for table `other_sys_user` */

DROP TABLE IF EXISTS `other_sys_user`;

CREATE TABLE `other_sys_user` (
  `id` VARCHAR(20) NOT NULL COMMENT '主键',
  `scope` VARCHAR(64) DEFAULT NULL COMMENT '第三方系统',
  `uuid` VARCHAR(64) DEFAULT NULL COMMENT '第三方系统唯一账户',
  `user_id` VARCHAR(20) DEFAULT NULL COMMENT '关联系统用户表的id',
  `username` VARCHAR(64) DEFAULT NULL COMMENT '登陆用户名',
  `create_time` DATETIME NOT NULL COMMENT '绑定时间（创建时间）',
  `update_time` DATETIME NOT NULL COMMENT '更新时间',
  `version` INT(20) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` INT(20) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`) USING BTREE COMMENT '用户id索引'
) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='第三方用户对象';

/*Data for the table `other_sys_user` */

LOCK TABLES `other_sys_user` WRITE;

UNLOCK TABLES;

/*Table structure for table `permission` */

DROP TABLE IF EXISTS `permission`;

CREATE TABLE `permission` (
  `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `permission_code` VARCHAR(32) DEFAULT NULL COMMENT '权限code',
  `permission_name` VARCHAR(32) DEFAULT NULL COMMENT '权限名',
  `url` VARCHAR(255) DEFAULT NULL COMMENT '请求url',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='权限表';

/*Data for the table `permission` */

LOCK TABLES `permission` WRITE;

INSERT  INTO `permission`(`id`,`permission_code`,`permission_name`,`url`) VALUES (1,'super_admin','超级管理员操作','/fras/superadmin/**'),(2,'admin','管理员操作','/fras/admin/**'),(3,'user','用户操作','/fras/user/**');

UNLOCK TABLES;

/*Table structure for table `role` */

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` VARCHAR(50) NOT NULL COMMENT '角色名',
  `role_desc` VARCHAR(50) NOT NULL COMMENT '角色描述',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='角色表';

/*Data for the table `role` */

LOCK TABLES `role` WRITE;

INSERT  INTO `role`(`id`,`role_name`,`role_desc`) VALUES (1,'super_admin','超级管理员'),(3,'user','用户');

UNLOCK TABLES;

/*Table structure for table `role_permission` */

DROP TABLE IF EXISTS `role_permission`;

CREATE TABLE `role_permission` (
  `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` INT(11) DEFAULT NULL COMMENT '角色id',
  `permission_id` INT(11) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='角色-权限关联关系表';

/*Data for the table `role_permission` */

LOCK TABLES `role_permission` WRITE;

INSERT  INTO `role_permission`(`id`,`role_id`,`permission_id`) VALUES (1,1,1),(2,3,2),(3,3,3),(5,1,3);

UNLOCK TABLES;

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` varchar(20) NOT NULL COMMENT '用户id',
  `username` varchar(20) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `nickname` varchar(30) DEFAULT NULL COMMENT '昵称',
  `name` varchar(20) DEFAULT NULL COMMENT '姓名',
  `introduction` varchar(300) DEFAULT NULL COMMENT '个人简介',
  `email` varchar(30) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `province` varchar(20) DEFAULT NULL COMMENT '省份',
  `city` varchar(20) DEFAULT NULL COMMENT '城市',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `version` int(11) NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `deleted` int(11) NOT NULL DEFAULT '0' COMMENT '逻辑删除',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '账号是否可用。默认为1（可用）',
  `account_non_expired` tinyint(1) DEFAULT '1' COMMENT '是否过期。默认为1（没有过期）',
  `account_non_locked` tinyint(1) DEFAULT '1' COMMENT '账号是否锁定。默认为1（没有锁定）',
  `credentials_non_expired` tinyint(1) DEFAULT '1' COMMENT '证书（密码）是否过期。默认为1（没有过期）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

/*Data for the table `user` */

LOCK TABLES `user` WRITE;


UNLOCK TABLES;

/*Table structure for table `user_role` */

DROP TABLE IF EXISTS `user_role`;

CREATE TABLE `user_role` (
  `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` VARCHAR(20) NOT NULL COMMENT '用户id',
  `role_id` INT(11) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='用户角色关联表';

/*Data for the table `user_role` */

LOCK TABLES `user_role` WRITE;

UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;