/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : select_course_db

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

Date: 2014-09-21 22:26:06
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `username` varchar(20) NOT NULL,
  `password` varchar(20) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('a', 'a');

-- ----------------------------
-- Table structure for `classinfo`
-- ----------------------------
DROP TABLE IF EXISTS `classinfo`;
CREATE TABLE `classinfo` (
  `classNumber` varchar(20) NOT NULL,
  `className` varchar(20) default NULL,
  `classSpecialFieldNumber` varchar(20) default NULL,
  `classBirthDate` datetime default NULL,
  `classTeacherCharge` varchar(12) default NULL,
  `classTelephone` varchar(20) default NULL,
  `classMemo` varchar(100) default NULL,
  PRIMARY KEY  (`classNumber`),
  KEY `FK76D92626A924E03B` (`classSpecialFieldNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of classinfo
-- ----------------------------
INSERT INTO `classinfo` VALUES ('JSJ201403', '2014级计算机3班', 'JSJKXYJS', '2014-09-01 00:00:00', '宋大鸟', '1510840813', '测试');
INSERT INTO `classinfo` VALUES ('DZXX201404', '2014电子信息4班', 'DZXXGC', '2014-09-02 00:00:00', '黄小鸡', '15308411353', '测试');

-- ----------------------------
-- Table structure for `collegeinfo`
-- ----------------------------
DROP TABLE IF EXISTS `collegeinfo`;
CREATE TABLE `collegeinfo` (
  `collegeNumber` varchar(20) NOT NULL,
  `collegeName` varchar(20) default NULL,
  `collegeBirthDate` datetime default NULL,
  `collegeMan` varchar(10) default NULL,
  `collegeTelephone` varchar(20) default NULL,
  `collegeMemo` varchar(100) default NULL,
  PRIMARY KEY  (`collegeNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of collegeinfo
-- ----------------------------
INSERT INTO `collegeinfo` VALUES ('XY001', '信息工程学院', '2009-09-02 00:00:00', '邓小川', '13985084980', '测试');
INSERT INTO `collegeinfo` VALUES ('XY002', '外国语学院', '2010-09-14 00:00:00', '刘小明', '13508501513', '测试信息');

-- ----------------------------
-- Table structure for `courseinfo_qq254540457`
-- ----------------------------
DROP TABLE IF EXISTS `courseinfo_qq254540457`;
CREATE TABLE `courseinfo_qq254540457` (
  `courseNumber` varchar(20) NOT NULL,
  `courseName` varchar(20) default NULL,
  `courseTeacher` varchar(20) default NULL,
  `courseTime` varchar(40) default NULL,
  `coursePlace` varchar(40) default NULL,
  `courseScore` float default NULL,
  `courseMemo` varchar(100) default NULL,
  PRIMARY KEY  (`courseNumber`),
  KEY `FK6C6DFE804FB4E18A` (`courseTeacher`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of courseinfo_qq254540457
-- ----------------------------
INSERT INTO `courseinfo_qq254540457` VALUES ('KC001', '安卓手机程序设计', 'TH001', '每周2下午1,2节', '6A-203', '3.5', '测试课程');
INSERT INTO `courseinfo_qq254540457` VALUES ('KC002', 'JSP网站设计', 'TH002', '每周3上午1,2节', '7C-201', '4', '测试');
INSERT INTO `courseinfo_qq254540457` VALUES ('KC003', 'html5网站设计', 'TH002', '每周四下午3,4节', '6A-201', '3.2', '测试');

-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `newsId` int(11) NOT NULL auto_increment,
  `newsTitle` varchar(50) default NULL,
  `newsContent` varchar(500) default NULL,
  `newsDate` datetime default NULL,
  `newsPhoto` varchar(50) default NULL,
  PRIMARY KEY  (`newsId`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '教务系统上线了', '欢迎大家使用哦！', '2014-09-20 00:00:00', 'upload/6143b246-ccf8-4cf4-8b14-fa7baa154f71.jpg');

-- ----------------------------
-- Table structure for `scoreinfo`
-- ----------------------------
DROP TABLE IF EXISTS `scoreinfo`;
CREATE TABLE `scoreinfo` (
  `scoreId` int(11) NOT NULL auto_increment,
  `studentNumber` varchar(20) default NULL,
  `courseNumber` varchar(20) default NULL,
  `scoreValue` float default NULL,
  `studentEvaluate` varchar(30) default NULL,
  PRIMARY KEY  (`scoreId`),
  KEY `FKF6529E4043F8B840` (`studentNumber`),
  KEY `FKF6529E40CBB4EC4E` (`courseNumber`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of scoreinfo
-- ----------------------------
INSERT INTO `scoreinfo` VALUES ('1', 'JSJ20140301', 'KC001', '85', '还不错');
INSERT INTO `scoreinfo` VALUES ('2', 'JSJ20140301', 'KC002', '92', '可以');
INSERT INTO `scoreinfo` VALUES ('3', 'DXXX20140405', 'KC001', '86.5', '不错哦');
INSERT INTO `scoreinfo` VALUES ('4', 'DXXX20140405', 'KC003', '82.5', 'ok');

-- ----------------------------
-- Table structure for `specialfieldinfo`
-- ----------------------------
DROP TABLE IF EXISTS `specialfieldinfo`;
CREATE TABLE `specialfieldinfo` (
  `specialFieldNumber` varchar(20) NOT NULL,
  `specialFieldName` varchar(20) default NULL,
  `specialCollegeNumber` varchar(20) default NULL,
  `specialBirthDate` datetime default NULL,
  `specialMan` varchar(10) default NULL,
  `specialTelephone` varchar(20) default NULL,
  `specialMemo` varchar(100) default NULL,
  PRIMARY KEY  (`specialFieldNumber`),
  KEY `FK2FCC502F6AE335E2` (`specialCollegeNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of specialfieldinfo
-- ----------------------------
INSERT INTO `specialfieldinfo` VALUES ('JSJKXYJS', '计算机科学与技术', 'XY001', '2012-09-05 00:00:00', '王小贱', '15814397342', '测试信息');
INSERT INTO `specialfieldinfo` VALUES ('DZXXGC', '电子信息工程', 'XY001', '2012-09-12 00:00:00', '韩云溪', '15108408013', '测试信息');

-- ----------------------------
-- Table structure for `studentselectcourseinfo`
-- ----------------------------
DROP TABLE IF EXISTS `studentselectcourseinfo`;
CREATE TABLE `studentselectcourseinfo` (
  `selectId` int(11) NOT NULL auto_increment,
  `studentNumber` varchar(20) default NULL,
  `courseNumber` varchar(20) default NULL,
  PRIMARY KEY  (`selectId`),
  KEY `FKDD6401C043F8B840` (`studentNumber`),
  KEY `FKDD6401C0CBB4EC4E` (`courseNumber`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of studentselectcourseinfo
-- ----------------------------
INSERT INTO `studentselectcourseinfo` VALUES ('1', 'JSJ20140301', 'KC001');
INSERT INTO `studentselectcourseinfo` VALUES ('2', 'DXXX20140405', 'KC002');
INSERT INTO `studentselectcourseinfo` VALUES ('3', 'JSJ20140301', 'KC002');
INSERT INTO `studentselectcourseinfo` VALUES ('4', 'DXXX20140405', 'KC001');
INSERT INTO `studentselectcourseinfo` VALUES ('5', 'DXXX20140405', 'KC003');

-- ----------------------------
-- Table structure for `student_qq287307421`
-- ----------------------------
DROP TABLE IF EXISTS `student_qq287307421`;
CREATE TABLE `student_qq287307421` (
  `studentNumber` varchar(20) NOT NULL,
  `studentName` varchar(12) default NULL,
  `studentPassword` varchar(30) default NULL,
  `studentSex` varchar(2) default NULL,
  `studentClassNumber` varchar(20) default NULL,
  `studentBirthday` datetime default NULL,
  `studentState` varchar(20) default NULL,
  `studentPhoto` varchar(50) default NULL,
  `studentTelephone` varchar(20) default NULL,
  `studentEmail` varchar(30) default NULL,
  `studentQQ` varchar(20) default NULL,
  `studentAddress` varchar(100) default NULL,
  `studentMemo` varchar(100) default NULL,
  PRIMARY KEY  (`studentNumber`),
  KEY `FKF793156697DC0CE2` (`studentClassNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student_qq287307421
-- ----------------------------
INSERT INTO `student_qq287307421` VALUES ('JSJ20140301', '襄铃', '123456', '女', 'JSJ201403', '1997-09-10 00:00:00', '团员', 'upload/1cd51ac1-43c3-4bdd-b2f6-9f2ddc03ed26.jpg', '13458140830', 'xiangl@126.com', '340185104', '湖南长沙市', '测试');
INSERT INTO `student_qq287307421` VALUES ('DXXX20140405', '晴雪', '123456', '女', 'DZXX201404', '1997-09-18 00:00:00', '团员', 'upload/e3d1cbae-7486-406f-b102-9e924d101e99.jpg', '13598048133', 'qingxue@163.com', '51084155', '福建福州市', '测试');

-- ----------------------------
-- Table structure for `teacher_qq287307421`
-- ----------------------------
DROP TABLE IF EXISTS `teacher_qq287307421`;
CREATE TABLE `teacher_qq287307421` (
  `teacherNumber` varchar(20) NOT NULL,
  `teacherName` varchar(12) default NULL,
  `teacherPassword` varchar(30) default NULL,
  `teacherSex` varchar(2) default NULL,
  `teacherBirthday` datetime default NULL,
  `teacherArriveDate` datetime default NULL,
  `teacherCardNumber` varchar(20) default NULL,
  `teacherPhone` varchar(20) default NULL,
  `teacherPhoto` varchar(50) default NULL,
  `teacherAddress` varchar(100) default NULL,
  `teacherMemo` varchar(100) default NULL,
  PRIMARY KEY  (`teacherNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacher_qq287307421
-- ----------------------------
INSERT INTO `teacher_qq287307421` VALUES ('TH001', '李飞', '123456', '男', '1979-09-11 00:00:00', '2011-09-08 00:00:00', '513030198401182341', '13593801934', 'upload/f9e50e33-400d-4a3a-85a2-2d51b0466c1e.jpg', '四川成都', '测试');
INSERT INTO `teacher_qq287307421` VALUES ('TH002', '双鱼林', '123456', '男', '1990-09-17 00:00:00', '2013-09-18 00:00:00', '513412196201103412', '15041430623', 'upload/092307ae-8301-4769-9fb5-0ab7daaa1324.jpg', '四川达州渠县', '测试');
