-- phpMyAdmin SQL Dump
-- version 3.0.1.1
-- http://www.phpmyadmin.net
--
-- 汾: 5.1.29
-- PHP 汾: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- --------------------------------------------------------

-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_admin
-- ----------------------------
INSERT INTO `t_admin` VALUES ('admin', '21232f297a57a5a743894a0e4a801fc3'); 

CREATE TABLE IF NOT EXISTS `t_CollegeInfo` (
  `collegeNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'collegeNumber',
  `collegeName` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'ѧԺ',
  `collegeBirthDate` date NOT NULL COMMENT '',
  `collegeMan` varchar(10) COLLATE utf8_bin NULL COMMENT 'Ժ',
  `collegeTelephone` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵ绰',
  `collegeMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`collegeNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_SpecialFieldInfo` (
  `specialFieldNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'specialFieldNumber',
  `specialFieldName` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'רҵ',
  `specialCollegeNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'ѧԺ',
  `specialBirthDate` date NOT NULL COMMENT '',
  `specialMan` varchar(10) COLLATE utf8_bin NULL COMMENT 'ϵ',
  `specialTelephone` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵ绰',
  `specialMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`specialFieldNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_ClassInfo` (
  `classNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'classNumber',
  `className` varchar(20) COLLATE utf8_bin NOT NULL COMMENT '༶',
  `classSpecialFieldNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'רҵ',
  `classBirthDate` date NOT NULL COMMENT '',
  `classTeacherCharge` varchar(12) COLLATE utf8_bin NULL COMMENT '',
  `classTelephone` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵ绰',
  `classMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`classNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_Student` (
  `studentNumber` varchar(30) COLLATE utf8_bin NOT NULL COMMENT 'studentNumber',
  `studentName` varchar(12) COLLATE utf8_bin NOT NULL COMMENT '',
  `studentPassword` varchar(30) COLLATE utf8_bin NOT NULL COMMENT '¼',
  `studentSex` varchar(2) COLLATE utf8_bin NOT NULL COMMENT 'Ա',
  `studentClassNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'ڰ༶',
  `studentBirthday` date NOT NULL COMMENT '',
  `studentState` varchar(20) COLLATE utf8_bin NULL COMMENT 'ò',
  `studentPhoto` text COLLATE utf8_bin NOT NULL COMMENT 'ѧƬ',
  `studentTelephone` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵ绰',
  `studentEmail` varchar(30) COLLATE utf8_bin NULL COMMENT 'ѧ',
  `studentQQ` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵqq',
  `studentAddress` varchar(100) COLLATE utf8_bin NULL COMMENT 'ַͥ',
  `studentMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`studentNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_Teacher` (
  `teacherNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'teacherNumber',
  `teacherName` varchar(12) COLLATE utf8_bin NOT NULL COMMENT 'ʦ',
  `teacherPassword` varchar(30) COLLATE utf8_bin NULL COMMENT '¼',
  `teacherSex` varchar(2) COLLATE utf8_bin NOT NULL COMMENT 'Ա',
  `teacherBirthday` date NOT NULL COMMENT '',
  `teacherArriveDate` date NOT NULL COMMENT 'ְ',
  `teacherCardNumber` varchar(20) COLLATE utf8_bin NULL COMMENT '֤',
  `teacherPhone` varchar(20) COLLATE utf8_bin NULL COMMENT 'ϵ绰',
  `teacherPhoto` text COLLATE utf8_bin NOT NULL COMMENT 'ʦƬ',
  `teacherAddress` varchar(100) COLLATE utf8_bin NULL COMMENT 'ַͥ',
  `teacherMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`teacherNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_CourseInfo` (
  `courseNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'courseNumber',
  `courseName` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'γ',
  `courseTeacher` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'Ͽʦ',
  `courseTime` varchar(40) COLLATE utf8_bin NULL COMMENT 'Ͽʱ',
  `coursePlace` varchar(40) COLLATE utf8_bin NULL COMMENT 'Ͽεص',
  `courseScore` float NOT NULL COMMENT 'γѧ',
  `courseMemo` varchar(100) COLLATE utf8_bin NULL COMMENT 'Ϣ',
  PRIMARY KEY (`courseNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE IF NOT EXISTS `t_StudentSelectCourseInfo` (
  `selectId` int(11) NOT NULL AUTO_INCREMENT COMMENT '¼',
  `studentNumber` varchar(30) COLLATE utf8_bin NOT NULL COMMENT 'ѧ',
  `courseNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'γ̶',
  PRIMARY KEY (`selectId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `t_ScoreInfo` (
  `scoreId` int(11) NOT NULL AUTO_INCREMENT COMMENT '¼',
  `studentNumber` varchar(30) COLLATE utf8_bin NOT NULL COMMENT 'ѧ',
  `courseNumber` varchar(20) COLLATE utf8_bin NOT NULL COMMENT 'γ̶',
  `scoreValue` float NOT NULL COMMENT 'ɼ÷',
  `studentEvaluate` varchar(30) COLLATE utf8_bin NULL COMMENT 'ѧ',
  PRIMARY KEY (`scoreId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `t_News` (
  `newsId` int(11) NOT NULL AUTO_INCREMENT COMMENT '¼',
  `newsTitle` varchar(50) COLLATE utf8_bin NOT NULL COMMENT 'ű',
  `newsContent` varchar(500) COLLATE utf8_bin NOT NULL COMMENT '',
  `newsDate` date NOT NULL COMMENT '',
  `newsPhoto` text COLLATE utf8_bin NOT NULL COMMENT 'ͼƬ',
  PRIMARY KEY (`newsId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

ALTER TABLE t_specialFieldInfo ADD CONSTRAINT FOREIGN KEY (specialCollegeNumber) REFERENCES t_collegeInfo(collegeNumber);
ALTER TABLE t_classInfo ADD CONSTRAINT FOREIGN KEY (classSpecialFieldNumber) REFERENCES t_specialFieldInfo(specialFieldNumber);
ALTER TABLE t_student ADD CONSTRAINT FOREIGN KEY (studentClassNumber) REFERENCES t_classInfo(classNumber);
ALTER TABLE t_courseInfo ADD CONSTRAINT FOREIGN KEY (courseTeacher) REFERENCES t_teacher(teacherNumber);
ALTER TABLE t_studentSelectCourseInfo ADD CONSTRAINT FOREIGN KEY (studentNumber) REFERENCES t_student(studentNumber);
ALTER TABLE t_studentSelectCourseInfo ADD CONSTRAINT FOREIGN KEY (courseNumber) REFERENCES t_courseInfo(courseNumber);
ALTER TABLE t_scoreInfo ADD CONSTRAINT FOREIGN KEY (studentNumber) REFERENCES t_student(studentNumber);
ALTER TABLE t_scoreInfo ADD CONSTRAINT FOREIGN KEY (courseNumber) REFERENCES t_courseInfo(courseNumber);


