checkNew
/
groups.sql.bak

/*
 Navicat Premium Data Transfer

 Source Server         : 本地测试
 Source Server Type    : MySQL
 Source Server Version : 50520
 Source Host           : localhost:3306
 Source Schema         : groups

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

 Date: 07/04/2021 12:09:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_classes
-- ----------------------------
DROP TABLE IF EXISTS `t_classes`;
CREATE TABLE `t_classes`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group_id` int(10) NOT NULL COMMENT '考勤组id',
  `classes_num` int(1) NOT NULL COMMENT '班次数（第几班）',
  `classes_type` int(1) NOT NULL COMMENT '班次类型（0：上班  1：休息）',
  `is_del` tinyint(255) NOT NULL COMMENT '是否被删除（0：存在 1：已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_classes
-- ----------------------------
INSERT INTO `t_classes` VALUES (1, 1, 1, 0, 0);
INSERT INTO `t_classes` VALUES (2, 1, 2, 0, 0);
INSERT INTO `t_classes` VALUES (3, 1, 3, 1, 0);
INSERT INTO `t_classes` VALUES (4, 2, 1, 0, 0);
INSERT INTO `t_classes` VALUES (5, 4, 1, 0, 0);
INSERT INTO `t_classes` VALUES (6, 5, 1, 1, 0);
INSERT INTO `t_classes` VALUES (7, 5, 2, 0, 0);
INSERT INTO `t_classes` VALUES (8, 2, 2, 1, 0);
INSERT INTO `t_classes` VALUES (9, 2, 3, 1, 0);
INSERT INTO `t_classes` VALUES (10, 2, 4, 1, 0);

-- ----------------------------
-- Table structure for t_classes_actual
-- ----------------------------
DROP TABLE IF EXISTS `t_classes_actual`;
CREATE TABLE `t_classes_actual`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL COMMENT '用户id',
  `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `role_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名',
  `department_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名',
  `group_id` int(10) NULL DEFAULT NULL COMMENT '班次id',
  `group_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名',
  `class_time` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '班次时间段',
  `is_class` tinyint(1) UNSIGNED ZEROFILL NULL DEFAULT NULL COMMENT '是否上班（0：上班 1：休假 2：特殊班次 3：未排班）',
  `class_type` int(10) NOT NULL DEFAULT 0 COMMENT '班次类型（0：正常班次 1：调班班次）',
  `class_num` int(10) NULL DEFAULT NULL COMMENT '当前第几班',
  `now_time` datetime NOT NULL COMMENT '真实班次当天的时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of t_classes_actual
-- ----------------------------
INSERT INTO `t_classes_actual` VALUES (1, 14, '李狗剩', '信息修改者', '部门2', 4, 'postman组1', '01:00~02:00,02:00~06:00', 0, 0, 1, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (2, 13, '工作人员6', '普通工作人员', '部门1', 4, 'postman组1', '01:00~02:00,02:00~06:00', 0, 0, 1, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (3, 12, '工作人员5', '普通工作人员', '新部门2', 5, 'postman组2', '00:00~01:00,01:00~02:00,02:00~03:00', 0, 0, 2, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (4, 11, '工作人员4', '普通工作人员', '新部门1', 5, 'postman组2', '00:00~00:00', 1, 0, 1, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (5, 10, '工作人员3', '普通工作人员', '部门2', NULL, NULL, NULL, 3, 0, NULL, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (6, 9, '工作人员2', '普通工作人员', '部门1', NULL, NULL, NULL, 3, 0, NULL, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (7, 8, '工作人员1', '普通工作人员', '新部门2', 1, '第一组', '00:00~00:00', 1, 0, 3, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (8, 7, 'postman', '超级管理员', '新部门1', 1, '第一组', '00:00~00:00', 1, 0, 3, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (9, 6, '小明', '超级管理员', '部门2', 2, '第二组', '00:00~00:00', 1, 0, 3, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (10, 5, '张麻子', '超级管理员', '部门1', 2, '第二组', '00:00~00:00', 1, 0, 2, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (11, 4, '翠花', '超级管理员', '新部门2', 1, '第一组', '00:00~06:00,10:00~19:00', 0, 0, 1, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (12, 3, '李铁柱', '超级管理员', '新部门1', 1, '第一组', '00:00~00:00', 1, 0, 3, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (13, 2, '李狗蛋', '信息修改者', '部门2', 1, '第一组', '00:00~05:00,10:00~12:00', 0, 0, 2, '2021-04-07 00:00:00');
INSERT INTO `t_classes_actual` VALUES (14, 1, 'admin1', '超级管理员', '部门1', 1, '第一组', '02:00~03:00,05:00~06:00', 2, 1, 2, '2021-04-07 00:00:00');

-- ----------------------------
-- Table structure for t_classes_time
-- ----------------------------
DROP TABLE IF EXISTS `t_classes_time`;
CREATE TABLE `t_classes_time`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `classes_id` int(11) NULL DEFAULT NULL COMMENT '班次id',
  `begin_time` time NULL DEFAULT NULL COMMENT '开始时间段',
  `end_time` time NULL DEFAULT NULL COMMENT '结束时间段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_classes_time
-- ----------------------------
INSERT INTO `t_classes_time` VALUES (1, 1, '00:00:00', '06:00:00');
INSERT INTO `t_classes_time` VALUES (2, 1, '10:00:00', '19:00:00');
INSERT INTO `t_classes_time` VALUES (3, 2, '00:00:00', '05:00:00');
INSERT INTO `t_classes_time` VALUES (4, 2, '10:00:00', '12:00:00');
INSERT INTO `t_classes_time` VALUES (5, 3, '00:00:00', '00:00:00');
INSERT INTO `t_classes_time` VALUES (6, 4, '00:00:00', '06:00:00');
INSERT INTO `t_classes_time` VALUES (7, 5, '01:00:00', '02:00:00');
INSERT INTO `t_classes_time` VALUES (8, 5, '02:00:00', '06:00:00');
INSERT INTO `t_classes_time` VALUES (9, 6, '00:00:00', '00:00:00');
INSERT INTO `t_classes_time` VALUES (10, 8, '00:00:00', '00:00:00');
INSERT INTO `t_classes_time` VALUES (11, 9, '00:00:00', '00:00:00');
INSERT INTO `t_classes_time` VALUES (12, 10, '00:00:00', '00:00:00');
INSERT INTO `t_classes_time` VALUES (13, 7, '00:00:00', '01:00:00');
INSERT INTO `t_classes_time` VALUES (14, 7, '01:00:00', '02:00:00');
INSERT INTO `t_classes_time` VALUES (15, 7, '02:00:00', '03:00:00');

-- ----------------------------
-- Table structure for t_classes_time_copy
-- ----------------------------
DROP TABLE IF EXISTS `t_classes_time_copy`;
CREATE TABLE `t_classes_time_copy`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `classes_id` int(11) NULL DEFAULT NULL COMMENT '班次id',
  `begin_time` time NOT NULL COMMENT '开始时间段',
  `end_time` time NOT NULL COMMENT '结束时间段',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_classes_time_copy
-- ----------------------------
INSERT INTO `t_classes_time_copy` VALUES (18, 14, '02:00:00', '03:00:00');
INSERT INTO `t_classes_time_copy` VALUES (19, 14, '05:00:00', '06:00:00');

-- ----------------------------
-- Table structure for t_classes_user
-- ----------------------------
DROP TABLE IF EXISTS `t_classes_user`;
CREATE TABLE `t_classes_user`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `classes_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_classes_user
-- ----------------------------
INSERT INTO `t_classes_user` VALUES (1, 1, 1);
INSERT INTO `t_classes_user` VALUES (2, 1, 2);
INSERT INTO `t_classes_user` VALUES (3, 2, 3);
INSERT INTO `t_classes_user` VALUES (4, 3, 4);
INSERT INTO `t_classes_user` VALUES (5, 4, 5);
INSERT INTO `t_classes_user` VALUES (6, 8, 6);
INSERT INTO `t_classes_user` VALUES (13, 5, 14);
INSERT INTO `t_classes_user` VALUES (15, 5, 13);
INSERT INTO `t_classes_user` VALUES (18, 7, 11);
INSERT INTO `t_classes_user` VALUES (19, 6, 12);
INSERT INTO `t_classes_user` VALUES (21, 2, 7);
INSERT INTO `t_classes_user` VALUES (22, 2, 8);

-- ----------------------------
-- Table structure for t_company
-- ----------------------------
DROP TABLE IF EXISTS `t_company`;
CREATE TABLE `t_company`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名称',
  `com_id` int(10) NOT NULL COMMENT '创建公司名称',
  `uid` int(10) NOT NULL COMMENT '创建人姓名',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除 1已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_company
-- ----------------------------
INSERT INTO `t_company` VALUES (1, '公司1', 1, 1, 1, 1, 0);
INSERT INTO `t_company` VALUES (2, '新建公司1', 1, 1, 1, 1, 0);
INSERT INTO `t_company` VALUES (3, '新建公司2', 1, 1, 1, 1, 0);

-- ----------------------------
-- Table structure for t_department
-- ----------------------------
DROP TABLE IF EXISTS `t_department`;
CREATE TABLE `t_department`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `com_id` int(10) NOT NULL COMMENT '创建公司名称',
  `uid` int(10) NOT NULL COMMENT '创建人姓名',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除 1已删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_department
-- ----------------------------
INSERT INTO `t_department` VALUES (1, '部门1', 1, 1, 1, 1, 0);
INSERT INTO `t_department` VALUES (2, '部门2', 1, 1, 1, 1, 0);
INSERT INTO `t_department` VALUES (3, '新部门1', 2, 2, 1, 1, 0);
INSERT INTO `t_department` VALUES (4, '新部门2', 2, 2, 1, 1, 0);

-- ----------------------------
-- Table structure for t_groups
-- ----------------------------
DROP TABLE IF EXISTS `t_groups`;
CREATE TABLE `t_groups`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考勤组名称',
  `begin_time` date NOT NULL COMMENT '其实循环时间',
  `class_num` int(1) NOT NULL COMMENT '班次数',
  `is_del` tinyint(1) NOT NULL COMMENT '0:存在 1：已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_groups
-- ----------------------------
INSERT INTO `t_groups` VALUES (1, '第一组', '2021-04-06', 3, 0);
INSERT INTO `t_groups` VALUES (2, '第二组', '2021-04-06', 4, 0);
INSERT INTO `t_groups` VALUES (3, '第三组', '2021-04-06', 1, 0);
INSERT INTO `t_groups` VALUES (4, 'postman组1', '2021-04-06', 1, 0);
INSERT INTO `t_groups` VALUES (5, 'postman组2', '2021-04-06', 2, 0);

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `des` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色说明',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `update_time` int(10) NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除 1：删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES (1, '超级管理员', '拥有全部的权限', 1, 1, 0);
INSERT INTO `t_role` VALUES (2, '信息修改者', '查，改', 1, 1, 0);
INSERT INTO `t_role` VALUES (3, '普通工作人员', '查', 1, 1, 0);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户姓名',
  `account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账户',
  `pwd` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户密码',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户手机号',
  `role_id` int(10) NOT NULL COMMENT '用户角色id',
  `dept_id` int(10) NOT NULL COMMENT '用户部门id',
  `com_id` int(10) NOT NULL COMMENT '创建公司id',
  `uid` int(10) NOT NULL COMMENT '创建人id',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除 1已删除）',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_create_time`(`create_time`) USING BTREE COMMENT '对创建时间添加索引方便查和排序'
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, 'admin1', 'admin', 'p/037xRAdfnoBssrORZWeA==', '111111', 1, 1, 1, 1, '2021-03-30 18:05:05', '2021-03-30 18:05:16', 0);
INSERT INTO `t_user` VALUES (2, '李狗蛋', 'ligoudangai', 'p/037xRAdfnoBssrORZWeA==', '222', 2, 2, 2, 2, '2021-03-30 18:05:08', '2021-03-30 18:53:51', 0);
INSERT INTO `t_user` VALUES (3, '李铁柱', 'ltz', 'p/037xRAdfnoBssrORZWeA==', '123456', 1, 3, 1, 1, '2021-03-30 18:05:11', '2021-03-30 18:05:22', 0);
INSERT INTO `t_user` VALUES (4, '翠花', 'ch', 'p/037xRAdfnoBssrORZWeA==', '123456', 1, 4, 1, 1, '2021-03-30 18:05:14', '2021-03-30 18:05:24', 0);
INSERT INTO `t_user` VALUES (5, '张麻子', 'zmz', 'p/037xRAdfnoBssrORZWeA==', '123456', 1, 1, 1, 1, '2021-03-30 18:17:58', '2021-03-30 18:17:58', 0);
INSERT INTO `t_user` VALUES (6, '小明', 'xioaming', 'p/037xRAdfnoBssrORZWeA==', '123456', 1, 2, 1, 1, '2021-03-30 18:37:34', '2021-03-30 18:37:34', 0);
INSERT INTO `t_user` VALUES (7, 'postman', 'postman', 'p/037xRAdfnoBssrORZWeA==', 'p1', 1, 3, 1, 1, '2021-03-30 18:44:16', '2021-03-30 18:44:16', 0);
INSERT INTO `t_user` VALUES (8, '工作人员1', 'g1', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 4, 1, 1, '2021-04-01 17:38:17', '2021-04-01 17:38:17', 0);
INSERT INTO `t_user` VALUES (9, '工作人员2', 'g2', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 1, 1, 1, '2021-04-01 17:38:26', '2021-04-01 17:38:26', 0);
INSERT INTO `t_user` VALUES (10, '工作人员3', 'g3', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 2, 1, 1, '2021-04-01 17:38:33', '2021-04-01 17:38:33', 0);
INSERT INTO `t_user` VALUES (11, '工作人员4', 'g4', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 3, 1, 1, '2021-04-01 17:38:38', '2021-04-01 17:38:38', 0);
INSERT INTO `t_user` VALUES (12, '工作人员5', 'g5', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 4, 1, 1, '2021-04-01 17:38:44', '2021-04-01 17:38:44', 0);
INSERT INTO `t_user` VALUES (13, '工作人员6', 'g6', 'p/037xRAdfnoBssrORZWeA==', 'g', 3, 1, 1, 1, '2021-04-01 17:38:49', '2021-04-01 17:38:49', 0);
INSERT INTO `t_user` VALUES (14, '李狗剩', 'lgs', 'p/037xRAdfnoBssrORZWeA==', '12138', 2, 2, 1, 1, '2021-04-01 18:38:52', '2021-04-01 18:38:57', 0);

SET FOREIGN_KEY_CHECKS = 1;