meeting.sql

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.26)
# Database: meeting
# Generation Time: 2020-07-12 01:34:21 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 */;


# Dump of table counter
# ------------------------------------------------------------

DROP TABLE IF EXISTS `counter`;

CREATE TABLE `counter` (
  `visitcount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `counter` WRITE;
/*!40000 ALTER TABLE `counter` DISABLE KEYS */;

INSERT INTO `counter` (`visitcount`)
VALUES
	(99);

/*!40000 ALTER TABLE `counter` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table department
# ------------------------------------------------------------

DROP TABLE IF EXISTS `department`;

CREATE TABLE `department` (
  `departmentid` int(16) NOT NULL AUTO_INCREMENT,
  `departmentname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`departmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `department` WRITE;
/*!40000 ALTER TABLE `department` DISABLE KEYS */;

INSERT INTO `department` (`departmentid`, `departmentname`)
VALUES
	(1,'技术部'),
	(2,'人事部'),
	(3,'财务部'),
	(4,'行政部'),
	(7,'运维部');

/*!40000 ALTER TABLE `department` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table employee
# ------------------------------------------------------------

DROP TABLE IF EXISTS `employee`;

CREATE TABLE `employee` (
  `employeeid` int(16) NOT NULL AUTO_INCREMENT,
  `employeename` varchar(14) DEFAULT NULL,
  `username` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `departmentid` int(16) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `role` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`employeeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `employee` WRITE;
/*!40000 ALTER TABLE `employee` DISABLE KEYS */;

INSERT INTO `employee` (`employeeid`, `employeename`, `username`, `phone`, `email`, `status`, `departmentid`, `password`, `role`)
VALUES
	(8,'王晓华','wangxh','13671075406','wang@qq.com','1',1,'1','1'),
	(9,'林耀坤','linyk','13671075406','yang@qq.com','1',2,'1','2'),
	(10,'熊杰文','xiongjw','134555555','xiong@qq.com','1',3,'1','2'),
	(11,'王敏','wangmin','1324554321','wangm@qq.com','2',4,'1','2'),
	(12,'林耀坤','linyk','1547896765','kun@qq.com','1',7,'1','2'),
	(13,'林耀坤','linyk','13897338822','yao@qq.com','1',1,'2','2'),
	(14,'林耀坤','linyk','18908789808','yangyk@qq.com','2',2,'2','2'),
	(15,'黄美玲','huangml','huangml@qq.com','13567898765','1',3,'1','2'),
	(16,'黄美玲','huangml','huangml@qq.com','13567898765','2',4,'1','2'),
	(17,'黄美玲','huangml002','huangml@qq.com','13567898765','2',1,'1','2'),
	(20,'王敏','wangmin002','13454332334','wang@qq.com','1',4,'1','2'),
	(21,'陈敏','chenm','13559994444','www@aa.com','1',2,'1','2'),
	(23,'陈晨','wangm','22·2','11','1',1,'1','2'),
	(25,'王晓华','wangxh222','111','1','1',4,'1','2'),
	(27,'张三','zhangsan','122','22','0',4,'1','2');

/*!40000 ALTER TABLE `employee` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table meeting
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meeting`;

CREATE TABLE `meeting` (
  `meetingid` int(16) NOT NULL AUTO_INCREMENT,
  `meetingname` varchar(20) DEFAULT NULL,
  `roomid` int(16) DEFAULT NULL,
  `reservationistid` int(16) DEFAULT NULL,
  `numberofparticipants` int(16) DEFAULT NULL,
  `starttime` datetime DEFAULT NULL,
  `endtime` datetime DEFAULT NULL,
  `reservationtime` datetime DEFAULT NULL,
  `canceledtime` datetime DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`meetingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `meeting` WRITE;
/*!40000 ALTER TABLE `meeting` DISABLE KEYS */;

INSERT INTO `meeting` (`meetingid`, `meetingname`, `roomid`, `reservationistid`, `numberofparticipants`, `starttime`, `endtime`, `reservationtime`, `canceledtime`, `description`, `status`)
VALUES
	(25,'ces',5,8,12,'2015-01-12 10:00:00','2015-01-12 12:00:00','2015-01-10 23:02:39',NULL,NULL,'1'),
	(26,'测测',7,8,12,'2015-01-12 13:00:00','2015-01-12 15:00:00','2015-01-17 23:04:18','2015-01-11 01:06:20',NULL,'1'),
	(27,'我看看',6,8,12,'2015-01-13 23:06:06','2015-01-14 03:06:08','2015-01-10 23:06:33','2015-01-11 01:01:42','我看看','1'),
	(28,'运营会',5,8,12,'2015-01-10 23:26:11','2015-01-11 23:26:13','2015-01-10 23:26:26',NULL,'测试','0'),
	(29,'市场部会议',6,8,12,'2015-01-10 23:44:22','2015-01-11 23:44:24','2015-01-10 23:44:41',NULL,'市场部','0'),
	(30,'内部会议',10,8,12,'2015-01-10 23:55:59','2015-01-11 23:56:01','2015-01-10 23:56:20',NULL,'内部会议','0'),
	(31,'我的会议',9,8,12,'2015-01-12 16:33:16','2015-01-13 16:33:18','2015-01-11 16:35:11',NULL,'测试','0'),
	(32,'我的会议哈哈',5,8,10,'2015-01-12 16:40:31','2015-01-13 16:40:35','2015-01-11 16:40:50',NULL,'','0'),
	(33,'哈哈',6,8,12,'2015-01-12 16:41:45','2015-01-13 16:41:48','2015-01-11 16:42:09','2015-01-12 11:44:57','你好','1'),
	(34,'我的会议3',8,8,12,'2015-01-11 16:42:36','2015-01-13 16:42:38','2015-01-11 16:42:51',NULL,'测试','0'),
	(35,'我的会议',7,8,12,'2015-01-11 16:44:03','2015-01-11 16:44:05','2015-01-11 16:44:35',NULL,'','0'),
	(36,'我问问',7,8,12,'2015-01-11 16:56:57','2015-01-11 16:56:59','2015-01-11 16:57:56','2015-01-11 16:59:57','地点','1'),
	(37,'我的会议4',7,8,12,'2015-01-12 16:59:26','2015-01-12 16:59:31','2015-01-11 16:59:49',NULL,'我的会议','0'),
	(38,'班会',9,8,12,'2015-01-15 16:46:25','2015-01-16 18:46:53','2015-01-12 11:49:17','2015-01-12 11:49:37','班会','1'),
	(39,'测试会议',5,8,12,'2015-01-14 14:41:11','2015-01-15 14:41:14','2015-01-14 14:44:07',NULL,'ss','0');

/*!40000 ALTER TABLE `meeting` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table meetingparticipants
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meetingparticipants`;

CREATE TABLE `meetingparticipants` (
  `meetingid` int(16) NOT NULL,
  `employeeid` int(16) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `meetingparticipants` WRITE;
/*!40000 ALTER TABLE `meetingparticipants` DISABLE KEYS */;

INSERT INTO `meetingparticipants` (`meetingid`, `employeeid`)
VALUES
	(28,13),
	(28,23),
	(28,27),
	(28,16),
	(29,16),
	(29,13),
	(29,8),
	(30,15),
	(30,13),
	(30,8),
	(30,23),
	(27,8),
	(26,8),
	(25,8),
	(28,8),
	(31,8),
	(31,17),
	(31,23),
	(32,8),
	(32,17),
	(33,15),
	(34,8),
	(34,17),
	(35,8),
	(36,9),
	(36,8),
	(37,8),
	(37,23),
	(38,11),
	(38,16),
	(38,20),
	(39,13);

/*!40000 ALTER TABLE `meetingparticipants` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table meetingroom
# ------------------------------------------------------------

DROP TABLE IF EXISTS `meetingroom`;

CREATE TABLE `meetingroom` (
  `roomid` int(16) NOT NULL AUTO_INCREMENT,
  `roomnum` int(16) NOT NULL,
  `roomname` varchar(20) NOT NULL,
  `capacity` int(16) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`roomid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `meetingroom` WRITE;
/*!40000 ALTER TABLE `meetingroom` DISABLE KEYS */;

INSERT INTO `meetingroom` (`roomid`, `roomnum`, `roomname`, `capacity`, `status`, `description`)
VALUES
	(5,101,'第一会议室',15,'0','公共会议室'),
	(6,102,'第二会议室',5,'0','管理部门会议室'),
	(7,103,'第三会议室',12,'0','市场部专用会议室'),
	(8,401,'第四会议室',15,'0','公共会议室'),
	(9,201,'第五会议室',15,'0','最大会议室'),
	(10,601,'第六会议室',12,'0','需要提前三天预定');

/*!40000 ALTER TABLE `meetingroom` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;