wds.zip_宿舍管理

/* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.1.49-community : Database - sushe ********************************************************************* */ /*!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*/`sushe` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `sushe`; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `Admin_ID` int(11) NOT NULL AUTO_INCREMENT, `Admin_Username` varchar(20) DEFAULT NULL, `Admin_Password` varchar(20) DEFAULT NULL, `Admin_Name` varchar(20) DEFAULT NULL, `Admin_Sex` varchar(10) DEFAULT NULL, `Admin_Tel` varchar(20) DEFAULT NULL, PRIMARY KEY (`Admin_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `admin` */ insert into `admin`(`Admin_ID`,`Admin_Username`,`Admin_Password`,`Admin_Name`,`Admin_Sex`,`Admin_Tel`) values (1,'java1234','123','admin','',NULL); /*Table structure for table `building` */ DROP TABLE IF EXISTS `building`; CREATE TABLE `building` ( `Building_ID` int(11) NOT NULL AUTO_INCREMENT, `Building_Name` varchar(50) DEFAULT NULL, `Building_Introduction` varchar(1000) DEFAULT NULL, PRIMARY KEY (`Building_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `building` */ insert into `building`(`Building_ID`,`Building_Name`,`Building_Introduction`) values (1,'楼宇1','这个楼宇1'),(2,'楼宇2','这个楼宇2'); /*Table structure for table `domitory` */ DROP TABLE IF EXISTS `domitory`; CREATE TABLE `domitory` ( `Domitory_ID` int(11) NOT NULL AUTO_INCREMENT, `Domitory_BuildingID` int(11) DEFAULT NULL, `Domitory_Name` varchar(20) DEFAULT NULL, `Domitory_Type` varchar(20) DEFAULT NULL, `Domitory_Number` varchar(20) DEFAULT NULL, `Domitory_Tel` varchar(20) DEFAULT NULL, PRIMARY KEY (`Domitory_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `domitory` */ insert into `domitory`(`Domitory_ID`,`Domitory_BuildingID`,`Domitory_Name`,`Domitory_Type`,`Domitory_Number`,`Domitory_Tel`) values (1,1,'11','11','11','11'),(2,2,'002','哈哈','12','312'); /*Table structure for table `log` */ DROP TABLE IF EXISTS `log`; CREATE TABLE `log` ( `Log_ID` int(11) NOT NULL AUTO_INCREMENT, `Log_StudentID` int(11) DEFAULT NULL, `Log_TeacherID` int(11) DEFAULT NULL, `Log_Date` varchar(50) DEFAULT NULL, `Log_Remark` varchar(1000) DEFAULT NULL, PRIMARY KEY (`Log_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `log` */ insert into `log`(`Log_ID`,`Log_StudentID`,`Log_TeacherID`,`Log_Date`,`Log_Remark`) values (1,2,1,'2013-04-10','we'); /*Table structure for table `out1` */ DROP TABLE IF EXISTS `out1`; CREATE TABLE `out1` ( `Out_ID` int(11) NOT NULL AUTO_INCREMENT, `Out_StudentID` varchar(11) DEFAULT NULL, `Out_Date` varchar(50) DEFAULT NULL, `Out_Remark` varchar(1000) DEFAULT NULL, PRIMARY KEY (`Out_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `out1` */ insert into `out1`(`Out_ID`,`Out_StudentID`,`Out_Date`,`Out_Remark`) values (1,'2','2013-4-28','13'),(2,'1','2013-4-28','搜索'); /*Table structure for table `student` */ DROP TABLE IF EXISTS `student`; CREATE TABLE `student` ( `Student_ID` int(11) NOT NULL AUTO_INCREMENT, `Student_DomitoryID` int(11) DEFAULT NULL, `Student_Username` varchar(20) DEFAULT NULL, `Student_Password` varchar(20) DEFAULT NULL, `Student_Name` varchar(20) DEFAULT NULL, `Student_Sex` varchar(20) DEFAULT NULL, `Student_Class` varchar(20) DEFAULT NULL, `Student_State` varchar(20) DEFAULT NULL, PRIMARY KEY (`Student_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `student` */ insert into `student`(`Student_ID`,`Student_DomitoryID`,`Student_Username`,`Student_Password`,`Student_Name`,`Student_Sex`,`Student_Class`,`Student_State`) values (1,2,'001','123','学生一','男','08计本','迁出'),(2,1,'002','123','发','女','范德萨','入住'); /*Table structure for table `tb` */ DROP TABLE IF EXISTS `tb`; CREATE TABLE `tb` ( `TB_ID` int(11) NOT NULL AUTO_INCREMENT, `TB_TeacherID` int(11) DEFAULT NULL, `TB_BuildingID` int(11) DEFAULT NULL, PRIMARY KEY (`TB_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `tb` */ insert into `tb`(`TB_ID`,`TB_TeacherID`,`TB_BuildingID`) values (1,1,1); /*Table structure for table `teacher` */ DROP TABLE IF EXISTS `teacher`; CREATE TABLE `teacher` ( `Teacher_ID` int(11) NOT NULL AUTO_INCREMENT, `Teacher_Username` varchar(20) DEFAULT NULL, `Teacher_Password` varchar(20) DEFAULT NULL, `Teacher_Name` varchar(20) DEFAULT NULL, `Teacher_Sex` varchar(10) DEFAULT NULL, `Teacher_Tel` varchar(20) DEFAULT NULL, PRIMARY KEY (`Teacher_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `teacher` */ insert into `teacher`(`Teacher_ID`,`Teacher_Username`,`Teacher_Password`,`Teacher_Name`,`Teacher_Sex`,`Teacher_Tel`) values (1,'Teacher1','123','楼宇管理员1','女','123'); /*!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 */;