onlineexambak 20060408 0133.sql

网上考试系统文件版

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.18-nt


/*!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_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' */;


--
-- Create schema onlineexam
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ onlineexam;
USE onlineexam;

--
-- Table structure for table `onlineexam`.`board`
--

DROP TABLE IF EXISTS `board`;
CREATE TABLE `board` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(45) default NULL,
  `detail` varchar(45) default NULL,
  `inputdate` date default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`board`
--

/*!40000 ALTER TABLE `board` DISABLE KEYS */;
INSERT INTO `board` (`ID`,`title`,`detail`,`inputdate`) VALUES 
 (1,'发挥发挥发挥','dgdfsgdfghfdhgfhjgfjdf','2006-03-15'),
 (2,'er我事实上','151451451231616','2006-04-01'),
 (3,'热烈祝贺','热烈祝贺我系网上考试系统顺利完工！','2006-03-21');
/*!40000 ALTER TABLE `board` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`dept`
--

DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
  `deptnum` varchar(45) NOT NULL default '',
  `deptname` varchar(45) NOT NULL default '',
  `ID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`dept`
--

/*!40000 ALTER TABLE `dept` DISABLE KEYS */;
INSERT INTO `dept` (`deptnum`,`deptname`,`ID`) VALUES 
 ('01','计算机科学系',1),
 ('02','中文系',2),
 ('03','数学系',3),
 ('04','外语系',4),
 ('05','物理系',5),
 ('06','化学与环境工程系',6),
 ('07','政法系',7),
 ('08','生物系',8),
 ('09','公共外语部',9),
 ('10','信息工程系',10),
 ('11','教育科学系',11),
 ('12','音乐系',12),
 ('13','美术系',13),
 ('14','文理学院',14),
 ('15','控制科学与工程系',15),
 ('16','体育系',16),
 ('17','历史系',17),
 ('18','继续教育学院',18);
/*!40000 ALTER TABLE `dept` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`problemchart`
--

DROP TABLE IF EXISTS `problemchart`;
CREATE TABLE `problemchart` (
  `chart_name` varchar(45) NOT NULL default '',
  `chart_num` varchar(45) NOT NULL default '',
  `ID` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`problemchart`
--

/*!40000 ALTER TABLE `problemchart` DISABLE KEYS */;
INSERT INTO `problemchart` (`chart_name`,`chart_num`,`ID`) VALUES 
 ('aa','01',1),
 ('cc','03',3),
 ('dd','04',4),
 ('kk','05',5),
 ('ff','06',6);
/*!40000 ALTER TABLE `problemchart` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`problemstore`
--

DROP TABLE IF EXISTS `problemstore`;
CREATE TABLE `problemstore` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `problem_context` varchar(45) NOT NULL default '',
  `problem_chart` varchar(45) NOT NULL default '',
  `problem_type` varchar(45) NOT NULL default '',
  `answer1` varchar(45) default NULL,
  `answer2` varchar(45) default NULL,
  `answer3` varchar(45) default NULL,
  `answer4` varchar(45) default NULL,
  `answer5` varchar(45) default NULL,
  `problem_key` int(11) default NULL,
  `problem_value` varchar(45) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`problemstore`
--

/*!40000 ALTER TABLE `problemstore` DISABLE KEYS */;
INSERT INTO `problemstore` (`ID`,`problem_context`,`problem_chart`,`problem_type`,`answer1`,`answer2`,`answer3`,`answer4`,`answer5`,`problem_key`,`problem_value`) VALUES 
 (1,'455535','aa','N','edtewt','sdfgsdgtrh','dfghweygjhj','afrwqhjuj','广泛鬼画符恢复后',1110,'5'),
 (2,'2222','aa','N','hrtyhtjj','tyrsashnj','Rhmkhjkhyj','gfdgrdky','dhtyjkuyk',11000,'5'),
 (3,'3333','aa','T','sejumkkdsew','fgjkhkkhkdser','sdsgfdgdfg','hggggggggggggggg','ghhhhhhhhhhhhh',100,'5'),
 (4,'4444','aa','T','fwr34355','dgy565','sfhfj5643','sdgfhr4345','fhgfj5453',1000,'5'),
 (5,'555','aa','N','3435234657','78978967564','456345342412','7897897979','asfsdgtewrty',1100,'5'),
 (6,'666','aa','N','sdgsdgerj','fghtryit6u54i','fj5t6ilkulfrd','se4t645jkhyk','sdgrukilty',1010,'5'),
 (7,'111111111111111111111','aa','T','aaaaaaa','bbbbbbbb','cccccccccccccc','dddddddddddddd','eeeeeeeeeee',100,'5'),
 (8,'222222222222222222','aa','N','aaaaaaaaaaaa','bbbbbbbbbbbbbbb','cccccccccccccccccc','dddddddddddddddd','eeeeeeeeeeeeeeee',11001,'5'),
 (9,'3333333333333333','aa','N','aaaaaaaaaaaaaa','bbbbbbbbbbbbbbb','cccccccccccccccccc','dddddddddddddddd','eeeeeeeeeeeeeee',111,'5');
INSERT INTO `problemstore` (`ID`,`problem_context`,`problem_chart`,`problem_type`,`answer1`,`answer2`,`answer3`,`answer4`,`answer5`,`problem_key`,`problem_value`) VALUES 
 (10,'555555555555555','aa','T','aaaaaaaaaaaaa','bbbbbbbbbbbbbbb','cccccccccccccc','ddddddddddddddd','ddeeeeeeeeeeee',10000,'5'),
 (11,'6666666666','aa','T','aaaaaaaaaaaaaa','bbbbbbbbbbbbbbbbbb','ccccccccccccccccccccc','dddddddddddddddd','eeeeeeeeeeeeeee',1000,'5'),
 (12,'55555','aa','N','55555','66666','77777','8888','9999',11000,'5'),
 (13,'活动风格发挥发火点法','aa','N','地方黑色啊','22222222','5756456463','25234565635235','AAAAAAAAAAA',1100,'5'),
 (14,'fdghgfhjgf','aa','N','地方病合金钢复活节','规范化规范化搞活机','撒旦会议感叹句搞活机','火箭筒固若金汤仍旧台','ghghjghujhjuhj',1110,'5');
/*!40000 ALTER TABLE `problemstore` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`problemtype`
--

DROP TABLE IF EXISTS `problemtype`;
CREATE TABLE `problemtype` (
  `type_name` varchar(45) NOT NULL default '',
  `type_num` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`type_num`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`problemtype`
--

/*!40000 ALTER TABLE `problemtype` DISABLE KEYS */;
/*!40000 ALTER TABLE `problemtype` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`student`
--

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `student_num` varchar(45) NOT NULL default '',
  `student_name` varchar(45) NOT NULL default '',
  `student_permit` varchar(45) NOT NULL default '',
  `student_class` varchar(45) default NULL,
  `student_dept` varchar(45) default NULL,
  `ID` int(10) unsigned NOT NULL auto_increment,
  `student_score` varchar(45) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`student`
--

/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` (`student_num`,`student_name`,`student_permit`,`student_class`,`student_dept`,`ID`,`student_score`) VALUES 
 ('021512002','hhh','021512002','0201','计算机科学系',2,'69'),
 ('021512044','qq','021512001','0202','计算机科学系',4,'75'),
 ('021512001','cc','021512001','0201','计算机科学系',5,'10'),
 ('021512033','tt','021512033','0202','计算机科学系',6,'60'),
 ('021512036','ll','021512036','0202','计算机科学系',7,'71'),
 ('021512058','mm','021512058','0201','计算机科学系',9,'68'),
 ('021512006','仍然','021512006','0202','计算机科学系',10,'60'),
 ('021512066','eee','021512066','0202','计算机科学系',11,'90'),
 ('021512009','yym','021512009','0202','计算机科学系',12,'10');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;


--
-- Table structure for table `onlineexam`.`teacher`
--

DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `teacher_name` varchar(45) NOT NULL default '',
  `teacher_password` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `onlineexam`.`teacher`
--

/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;
INSERT INTO `teacher` (`ID`,`teacher_name`,`teacher_password`) VALUES 
 (1,'11','111'),
 (2,'admin','admin');
/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;