/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.7.32 : 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;

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` */

DROP TABLE IF EXISTS `group`;

CREATE TABLE `group` (
  `id` VARCHAR(20) NOT NULL COMMENT '组id',
  `name` VARCHAR(50) NOT NULL COMMENT '组名',
  `admin_id` VARCHAR(20) NOT NULL COMMENT '管理员id',
  `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 `group` */

LOCK TABLES `group` 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 `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','超级管理员操作','/superadmin/**'),(2,'admin','管理员操作','/admin/**'),(3,'user','用户操作','/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','超级管理员'),(2,'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,2,2),(3,2,3),(4,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 '密码',
  `name` VARCHAR(20) DEFAULT NULL COMMENT '姓名',
  `email` VARCHAR(30) NOT NULL COMMENT '邮箱',
  `phone` VARCHAR(11) NOT 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=2 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 */;