master

分支 (1)

管理

管理

master

ssshglxt
/
dm.sql

/*
Navicat MySQL Data Transfer

Source Server         : ceshi
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : dm

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2023-10-04 16:12:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_5cca88c6i17ttuegcvdkgehah` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('ff808081793a4d0701793a4e0a0a0009', '2021-05-05 02:06:50', '2021-05-05 02:06:50', '1', '0', 'admin', 'admin');

-- ----------------------------
-- Table structure for admin1
-- ----------------------------
DROP TABLE IF EXISTS `admin1`;
CREATE TABLE `admin1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '',
  `password` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `valid` int(11) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin1
-- ----------------------------
INSERT INTO `admin1` VALUES ('1', 'admin', 'admin', null, null, null, null);

-- ----------------------------
-- Table structure for admin_copy
-- ----------------------------
DROP TABLE IF EXISTS `admin_copy`;
CREATE TABLE `admin_copy` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_5cca88c6i17ttuegcvdkgehah` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_copy
-- ----------------------------
INSERT INTO `admin_copy` VALUES ('1', '2021-05-05 02:06:50', '2021-05-05 02:06:50', '1', '0', 'admin', 'admin');

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `dormitory_manager_id` varchar(32) DEFAULT NULL,
  `location` varchar(128) NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_oyx9p4qp0ot5mw2vdn1qgax00` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES ('ff808081793a4d0701793a4e0a0a0000', '2021-05-05 10:14:23', '2021-05-05 12:27:43', '1', '1', 'ff808081793ac6fb01793ac7e0c90001', '北京市海淀区松鼠街二段188号', '女生宿舍楼01栋');
INSERT INTO `building` VALUES ('ff808081793a4d0701793a4f70410001', '2021-05-05 10:15:55', '2021-05-05 12:27:48', '1', '1', 'ff808081793ac6fb01793ac7b1e30000', '北京市海淀区松鼠街二段188号', '男生宿舍楼01栋');

-- ----------------------------
-- Table structure for dormitory
-- ----------------------------
DROP TABLE IF EXISTS `dormitory`;
CREATE TABLE `dormitory` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `building_id` varchar(32) DEFAULT NULL,
  `floor` varchar(32) NOT NULL,
  `lived_number` int(11) DEFAULT NULL,
  `max_number` int(11) NOT NULL,
  `sn` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_a6os0dike7isf1gh2gw2fuqkx` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dormitory
-- ----------------------------
INSERT INTO `dormitory` VALUES ('ff808081793a55e601793a56c1f40001', '2021-05-05 10:23:54', '2021-05-05 10:23:54', '1', '0', 'ff808081793a4d0701793a4f70410001', '1', '1', '4', 'D00002');
INSERT INTO `dormitory` VALUES ('ff808081793ac6fb01793ac895b10002', '2021-05-05 12:28:14', '2021-05-05 12:28:14', '1', '0', 'ff808081793a4d0701793a4f70410001', '1', '1', '4', 'D00001');

-- ----------------------------
-- Table structure for dormitory_manager
-- ----------------------------
DROP TABLE IF EXISTS `dormitory_manager`;
CREATE TABLE `dormitory_manager` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(32) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `sex` varchar(4) NOT NULL,
  `sn` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_6xasm96t41pqnctqrvan7w7hk` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dormitory_manager
-- ----------------------------
INSERT INTO `dormitory_manager` VALUES ('ff808081793ac6fb01793ac7b1e30000', '2021-05-05 12:27:16', '2021-05-05 12:28:54', '1', '2', '刘德华', '111111', '男', 'SG0001');
INSERT INTO `dormitory_manager` VALUES ('ff808081793ac6fb01793ac7e0c90001', '2021-05-05 12:27:28', '2021-05-05 12:27:28', '1', '0', '张韶涵', '111111', '女', 'SG0002');

-- ----------------------------
-- Table structure for live
-- ----------------------------
DROP TABLE IF EXISTS `live`;
CREATE TABLE `live` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `dormitory_id` varchar(32) NOT NULL,
  `live_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `student_id` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of live
-- ----------------------------
INSERT INTO `live` VALUES ('ff808081793ab08a01793ab0f40a0000', '2021-05-05 12:02:25', '2021-05-05 12:28:25', '1', '4', 'ff808081793ac6fb01793ac895b10002', '2021-05-05 10:23:54', '402883e4793a407601793a4b3ce40001');
INSERT INTO `live` VALUES ('ff808081793ab08a01793ab127ea0001', '2021-05-05 12:02:39', '2021-05-05 12:28:38', '1', '1', 'ff808081793a55e601793a56c1f40001', '2021-05-05 10:23:54', 'ff808081793a50de01793a5361ad0000');

-- ----------------------------
-- Table structure for louyu
-- ----------------------------
DROP TABLE IF EXISTS `louyu`;
CREATE TABLE `louyu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `domitoryid` varchar(255) DEFAULT '',
  `domitorynumber` varchar(255) DEFAULT '',
  `domitoryname` varchar(255) DEFAULT '',
  `create_time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `update_time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of louyu
-- ----------------------------
INSERT INTO `louyu` VALUES ('1', '测试1', '测试2', '1', '1233333', '测试123', '2023-10-04 12:39:27', '2023-10-04 12:39:27');
INSERT INTO `louyu` VALUES ('3', '男生宿舍', '北京-', '3', 'S1234', '宿管', '2023-10-04 13:42:43', '2023-10-04 13:42:43');

-- ----------------------------
-- Table structure for ruzhu
-- ----------------------------
DROP TABLE IF EXISTS `ruzhu`;
CREATE TABLE `ruzhu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentbh` varchar(255) DEFAULT NULL,
  `studentname` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT '',
  `livetime` datetime DEFAULT NULL,
  `studentid` int(11) DEFAULT NULL,
  `susheid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ruzhu
-- ----------------------------
INSERT INTO `ruzhu` VALUES ('1', '123', '测试11144444', 'cesjo', '2023-10-19 00:00:00', '402886', '2');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` varchar(32) NOT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(16) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `sex` varchar(4) NOT NULL,
  `sn` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_djcbk1s9vb3fxo2ft5f1fgic2` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('402883e4793a407601793a4b3ce40001', '2023-10-05 16:36:04', '2023-10-20 16:36:13', '1', '0', 'JacobGreen', '111111', '男', 'S123456');
INSERT INTO `student` VALUES ('ff808081793a50de01793a5361ad0000', '2023-10-13 16:36:08', '2023-10-21 16:36:17', '1', '0', 'MerySalla', '111111', '女', 'S123457');

-- ----------------------------
-- Table structure for student_copy
-- ----------------------------
DROP TABLE IF EXISTS `student_copy`;
CREATE TABLE `student_copy` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp(),
  `valid` varchar(1) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(16) NOT NULL,
  `password` varchar(32) DEFAULT NULL,
  `sex` varchar(4) NOT NULL,
  `sn` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_djcbk1s9vb3fxo2ft5f1fgic2` (`sn`)
) ENGINE=InnoDB AUTO_INCREMENT=402889 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student_copy
-- ----------------------------
INSERT INTO `student_copy` VALUES ('402883', '2023-10-05 16:36:04', '2023-10-20 16:36:13', '1', '0', 'JacobGreen', '111111', '男', 'S123456');
INSERT INTO `student_copy` VALUES ('402884', '2023-10-13 16:36:08', '2023-10-21 16:36:17', '1', '0', 'MerySalla', '111111', '女', 'S123457');
INSERT INTO `student_copy` VALUES ('402886', '2023-10-02 23:21:50', '2023-10-02 23:21:50', null, null, '测试11144444', '123', '男', '123');

-- ----------------------------
-- Table structure for sushe
-- ----------------------------
DROP TABLE IF EXISTS `sushe`;
CREATE TABLE `sushe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(255) DEFAULT NULL,
  `louyuname` varchar(255) DEFAULT NULL,
  `louyuid` varchar(255) DEFAULT NULL,
  `sslc` varchar(255) DEFAULT NULL,
  `maxlive` varchar(255) DEFAULT NULL,
  `haslive` varchar(255) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `update_time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sushe
-- ----------------------------
INSERT INTO `sushe` VALUES ('1', 'S803', '测试1', '1', '12', '12', '12', '2023-10-04 14:14:37', '2023-10-04 14:14:37');
INSERT INTO `sushe` VALUES ('2', 'cesjo', '测试1', '1', '12', '12', '12', '2023-10-04 14:17:25', '2023-10-04 14:17:25');

-- ----------------------------
-- Table structure for sushe_manager
-- ----------------------------
DROP TABLE IF EXISTS `sushe_manager`;
CREATE TABLE `sushe_manager` (
  `id` int(32) NOT NULL AUTO_INCREMENT,
  `number` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sushe_manager
-- ----------------------------
INSERT INTO `sushe_manager` VALUES ('1', '1233333', '测试123', '女', '123321', '2023-10-03 19:46:29', '2023-10-03 19:46:29');
INSERT INTO `sushe_manager` VALUES ('3', 'S1234', '宿管', '男', '123321', '2023-10-04 11:55:26', '2023-10-04 11:55:26');