jh003.sql

在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构

INSERT INTO errorpad VALUES (442,'stest',1082,'2003-06-10 09:29:16',1,187,48,NULL,3);
INSERT INTO errorpad VALUES (443,'stest',1083,'2003-06-10 09:29:16',1,187,48,NULL,3);
INSERT INTO errorpad VALUES (444,'stest',1084,'2003-06-10 09:29:16',1,187,48,NULL,3);
INSERT INTO errorpad VALUES (445,'stest',1087,'2003-06-10 09:29:33',1,188,48,NULL,3);
INSERT INTO errorpad VALUES (446,'stest',1096,'2003-06-10 09:29:50',1,189,48,NULL,3);
INSERT INTO errorpad VALUES (447,'stest',1108,'2003-07-08 09:30:44',1,192,49,NULL,3);
INSERT INTO errorpad VALUES (448,'stest',1102,'2003-07-08 09:30:57',1,191,49,NULL,3);
INSERT INTO errorpad VALUES (449,'stest',1103,'2003-07-08 09:30:57',1,191,49,NULL,3);
INSERT INTO errorpad VALUES (450,'stest',1105,'2003-07-08 09:30:57',1,191,49,NULL,3);
INSERT INTO errorpad VALUES (451,'stest',1099,'2003-07-08 09:31:08',1,190,49,NULL,3);
INSERT INTO errorpad VALUES (452,'stest',1100,'2003-07-08 09:31:08',1,190,49,NULL,3);
INSERT INTO errorpad VALUES (453,'stest',1101,'2003-07-08 09:31:08',1,190,49,NULL,3);
INSERT INTO errorpad VALUES (454,'stest',1550,'2004-05-07 21:11:47',1,204,NULL,NULL,2);
INSERT INTO errorpad VALUES (455,'stest',1551,'2004-05-07 21:11:47',1,204,NULL,NULL,2);
INSERT INTO errorpad VALUES (456,'stest',1552,'2004-05-07 21:11:47',1,204,NULL,NULL,2);

--
-- Table structure for table 'grade'
--

DROP TABLE IF EXISTS grade;
CREATE TABLE grade (
  Name varchar(30) NOT NULL default '',
  note char(3) NOT NULL default '',
  ID tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'grade'
--

INSERT INTO grade VALUES ('初一','c1',2);
INSERT INTO grade VALUES ('初二','c2',3);
INSERT INTO grade VALUES ('初三','c3',4);
INSERT INTO grade VALUES ('初中','c',1);
INSERT INTO grade VALUES ('高一','g1',6);
INSERT INTO grade VALUES ('高二','g2',7);
INSERT INTO grade VALUES ('高中','g',5);
INSERT INTO grade VALUES ('高三理科','g3l',9);
INSERT INTO grade VALUES ('高三文科','g3w',10);

--
-- Table structure for table 'knowpoint'
--

DROP TABLE IF EXISTS knowpoint;
CREATE TABLE knowpoint (
  ID int(6) unsigned NOT NULL auto_increment,
  Name varchar(100) default NULL,
  note varchar(4) default NULL,
  subid smallint(6) default NULL,
  gradeid tinyint(4) default NULL,
  gradenote char(3) default NULL,
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID)
) TYPE=MyISAM;

--
-- Dumping data for table 'knowpoint'
--

INSERT INTO knowpoint VALUES (27,'知识点一',NULL,32,NULL,'c1');
INSERT INTO knowpoint VALUES (28,'初一英语',NULL,34,NULL,'c1');
INSERT INTO knowpoint VALUES (29,'初一英语知识点1',NULL,34,NULL,'c1');
INSERT INTO knowpoint VALUES (30,'初一物理',NULL,33,NULL,'c1');
INSERT INTO knowpoint VALUES (31,'初一物理知识点一',NULL,33,NULL,'c1');
INSERT INTO knowpoint VALUES (33,'语文1',NULL,35,NULL,'c3');
INSERT INTO knowpoint VALUES (34,'物理1',NULL,37,NULL,'c3');
INSERT INTO knowpoint VALUES (35,'物理知识(一)',NULL,38,NULL,'g3l');
INSERT INTO knowpoint VALUES (36,'数学知识(一)',NULL,39,NULL,'g3l');
INSERT INTO knowpoint VALUES (37,'英语测试(一)',NULL,40,NULL,'g3l');
INSERT INTO knowpoint VALUES (38,'初二：英语',NULL,41,NULL,'c2');
INSERT INTO knowpoint VALUES (39,'初二：语文',NULL,42,NULL,'c2');
INSERT INTO knowpoint VALUES (40,'初二：物理',NULL,43,NULL,'c2');
INSERT INTO knowpoint VALUES (41,'初二：化学',NULL,44,NULL,'c2');
INSERT INTO knowpoint VALUES (42,'初二：数学',NULL,45,NULL,'c2');
INSERT INTO knowpoint VALUES (43,'初二：计算机',NULL,46,NULL,'c2');

--
-- Table structure for table 'mn_history'
--

DROP TABLE IF EXISTS mn_history;
CREATE TABLE mn_history (
  id int(4) NOT NULL auto_increment,
  stu_id varchar(30) default NULL,
  mn_test_id int(11) default NULL,
  totalmark smallint(9) default NULL,
  position int(11) default NULL,
  top10avg float(9,3) default NULL,
  top30avg float(9,3) default NULL,
  submark varchar(255) default NULL,
  test_date datetime default NULL,
  sub_num tinyint(4) default NULL,
  totalpeople int(11) default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mn_history'
--

INSERT INTO mn_history VALUES (33,'s11',43,110,7,90.000,83.330,'化学:50#物理:20#英语:40#','2003-01-01 00:00:00',3,11);
INSERT INTO mn_history VALUES (34,'s11',44,140,NULL,90.000,83.330,'化学:50#物理:40#英语:50#','2003-02-02 00:00:00',3,11);
INSERT INTO mn_history VALUES (35,'s11',45,70,1,70.000,70.000,'化学:40#物理:10#英语:20#','2003-03-03 00:00:00',3,1);
INSERT INTO mn_history VALUES (36,'sc001',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (37,'sc002',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (38,'sc003',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (39,'sc004',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (40,'sc005',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (41,'sc006',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (42,'sc007',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (43,'sc008',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (44,'sc009',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (45,'sc010',43,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (46,'s11',46,100,1,100.000,100.000,'化学:40#物理:30#英语:30#','2003-04-04 00:00:00',3,1);
INSERT INTO mn_history VALUES (47,'s11',47,NULL,NULL,NULL,NULL,NULL,'2003-05-05 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (52,'s11',48,NULL,NULL,NULL,NULL,NULL,'2003-06-06 00:00:00',NULL,0);
INSERT INTO mn_history VALUES (51,'s11',49,100,1,100.000,100.000,'化学:50#物理:30#英语:20#','2003-07-17 00:00:00',3,1);
INSERT INTO mn_history VALUES (53,'stest',43,60,4,90.000,80.000,'化学:20#物理:0#英语:40#','2003-01-22 00:00:00',3,12);
INSERT INTO mn_history VALUES (54,'stest',44,100,2,140.000,140.000,'化学:20#物理:40#英语:40#','2003-02-22 00:00:00',3,2);
INSERT INTO mn_history VALUES (55,'stest',45,60,2,70.000,70.000,'化学:10#物理:30#英语:20#','2003-03-18 00:00:00',3,2);
INSERT INTO mn_history VALUES (56,'stest',46,70,NULL,NULL,NULL,'化学:10#物理:20#英语:40#','2003-04-24 00:00:00',3,0);
INSERT INTO mn_history VALUES (57,'stest',47,120,NULL,NULL,NULL,'化学:50#物理:50#英语:20#','2003-05-24 00:00:00',3,0);
INSERT INTO mn_history VALUES (58,'stest',48,100,NULL,NULL,NULL,'化学:20#物理:40#英语:40#','2003-06-10 00:00:00',3,0);
INSERT INTO mn_history VALUES (59,'stest',49,80,1,70.000,70.000,'化学:40#物理:20#英语:20#','2003-07-08 00:00:00',3,2);

--
-- Table structure for table 'mn_scores'
--

DROP TABLE IF EXISTS mn_scores;
CREATE TABLE mn_scores (
  id int(11) unsigned NOT NULL auto_increment,
  mn_test_id int(11) default NULL,
  score float(9,3) default NULL,
  stu_id varchar(30) default NULL,
  tea_id int(11) default NULL,
  test_date datetime default NULL,
  sub_id int(11) default NULL,
  test_id int(11) default NULL,
  test_rs text,
  PRIMARY KEY  (id),
  UNIQUE KEY ID (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'mn_scores'
--

INSERT INTO mn_scores VALUES (240,43,50.000,'s11',1,'2003-01-01 00:00:00',32,172,'A,D,D,C,B,#T,T,T,T,T,#10,10,10,10,10,');
INSERT INTO mn_scores VALUES (241,43,20.000,'s11',1,'2003-01-01 00:00:00',33,173,'A,D,C,D,C,#T,T,F,F,F,#10,10,0,0,0,');