?? jh003.sql
字號:
-- MySQL dump 9.08
--
-- Host: localhost Database: jinghua
---------------------------------------------------------
-- Server version 4.0.14-nt
--
-- Table structure for table 'errornotepad'
--
DROP TABLE IF EXISTS errornotepad;
CREATE TABLE errornotepad (
field1 tinyint(4) default NULL,
ID int(11) default NULL,
StuID int(11) default NULL,
EID int(11) default NULL,
ErrorCount smallint(6) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table 'errornotepad'
--
--
-- Table structure for table 'errorpad'
--
DROP TABLE IF EXISTS errorpad;
CREATE TABLE errorpad (
id int(11) unsigned NOT NULL auto_increment,
stu_id varchar(50) default NULL,
question_id int(11) unsigned default NULL,
add_date datetime default NULL,
errorcount smallint(11) unsigned default '0',
test_id int(11) unsigned default NULL,
mn_test_id int(11) unsigned default NULL,
review_date datetime default NULL,
sourcetype tinyint(4) unsigned default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
--
-- Dumping data for table 'errorpad'
--
INSERT INTO errorpad VALUES (13,'sc010',571,'2003-10-22 10:40:38',2,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (14,'sc010',572,'2003-10-22 10:40:38',1,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (15,'sc010',792,'2003-10-22 11:13:44',3,152,29,NULL,3);
INSERT INTO errorpad VALUES (16,'sc010',793,'2003-10-22 11:13:44',2,152,29,NULL,3);
INSERT INTO errorpad VALUES (17,'sc007',610,'2003-10-22 11:16:36',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (18,'sc007',611,'2003-10-22 11:16:36',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (19,'sc007',609,'2003-10-22 11:18:15',1,128,18,NULL,3);
INSERT INTO errorpad VALUES (20,'sc007',612,'2003-10-22 11:18:15',1,128,18,NULL,3);
INSERT INTO errorpad VALUES (21,'sc006',609,'2003-10-22 11:19:50',3,128,18,NULL,3);
INSERT INTO errorpad VALUES (22,'sc006',610,'2003-10-22 11:19:50',3,128,18,NULL,3);
INSERT INTO errorpad VALUES (43,'s11',611,'2003-10-24 22:03:39',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (51,'s11',518,'2003-10-25 21:52:04',1,103,NULL,NULL,2);
INSERT INTO errorpad VALUES (50,'s11',517,'2003-10-25 21:52:04',1,103,NULL,NULL,2);
INSERT INTO errorpad VALUES (49,'s11',515,'2003-10-25 21:52:04',1,103,NULL,NULL,2);
INSERT INTO errorpad VALUES (136,'sc001',614,'2003-10-30 20:17:51',1,129,18,NULL,3);
INSERT INTO errorpad VALUES (31,'sc010',614,'2003-10-22 19:09:59',1,129,18,NULL,3);
INSERT INTO errorpad VALUES (32,'sc010',616,'2003-10-22 19:09:59',1,129,18,NULL,3);
INSERT INTO errorpad VALUES (33,'sc010',622,'2003-10-22 19:10:11',1,130,18,NULL,3);
INSERT INTO errorpad VALUES (34,'sc010',612,'2003-10-22 19:10:22',1,128,18,NULL,3);
INSERT INTO errorpad VALUES (63,'S11',867,'2003-10-26 18:09:10',5,0,0,NULL,1);
INSERT INTO errorpad VALUES (62,'S11',882,'2003-10-26 18:09:10',4,0,0,NULL,1);
INSERT INTO errorpad VALUES (60,'S11',857,'2003-10-26 18:09:10',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (59,'S11',715,'2003-10-26 18:09:10',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (39,'s11',673,'2003-10-23 11:13:24',1,141,20,NULL,3);
INSERT INTO errorpad VALUES (40,'s11',674,'2003-10-23 11:13:24',2,141,20,NULL,3);
INSERT INTO errorpad VALUES (41,'s11',675,'2003-10-23 11:13:24',5,141,20,NULL,3);
INSERT INTO errorpad VALUES (42,'s11',676,'2003-10-23 11:13:24',1,141,20,NULL,3);
INSERT INTO errorpad VALUES (44,'s11',612,'2003-10-24 22:03:39',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (45,'s11',625,'2003-10-24 22:03:54',1,131,18,NULL,3);
INSERT INTO errorpad VALUES (46,'s11',626,'2003-10-24 22:03:54',2,131,18,NULL,3);
INSERT INTO errorpad VALUES (47,'s11',627,'2003-10-24 22:03:54',1,131,18,NULL,3);
INSERT INTO errorpad VALUES (48,'s11',628,'2003-10-24 22:03:54',1,131,18,NULL,3);
INSERT INTO errorpad VALUES (53,'s11',541,'2003-10-25 21:53:05',1,112,NULL,NULL,2);
INSERT INTO errorpad VALUES (54,'s11',542,'2003-10-25 21:53:05',1,112,NULL,NULL,2);
INSERT INTO errorpad VALUES (55,'s11',543,'2003-10-25 21:53:05',1,112,NULL,NULL,2);
INSERT INTO errorpad VALUES (56,'s11',544,'2003-10-25 21:53:05',2,112,NULL,NULL,2);
INSERT INTO errorpad VALUES (57,'s11',537,'2003-10-25 21:53:13',2,111,NULL,NULL,2);
INSERT INTO errorpad VALUES (58,'s11',538,'2003-10-25 21:53:13',2,111,NULL,NULL,2);
INSERT INTO errorpad VALUES (64,'S11',880,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (65,'S11',908,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (66,'S11',865,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (67,'S11',895,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (68,'S11',890,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (69,'S11',704,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (70,'S11',868,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (71,'S11',870,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (72,'S11',894,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (73,'S11',898,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (74,'S11',888,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (75,'S11',539,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (76,'S11',876,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (77,'S11',619,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (78,'S11',893,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (79,'S11',788,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (80,'S11',862,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (81,'S11',905,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (82,'S11',878,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (83,'S11',885,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (84,'S11',871,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (85,'S11',693,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (86,'S11',884,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (87,'S11',874,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (88,'S11',724,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (89,'S11',864,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (90,'S11',872,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (91,'S11',879,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (92,'S11',899,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (93,'S11',906,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (94,'S11',907,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (95,'S11',535,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (96,'S11',887,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (97,'S11',863,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (98,'S11',786,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (99,'S11',891,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (100,'S11',896,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (101,'S11',902,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (102,'S11',877,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (103,'S11',883,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (104,'S11',881,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (105,'S11',873,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (106,'S11',889,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (107,'S11',540,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (108,'S11',528,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (109,'S11',536,'2003-10-26 18:52:26',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (110,'S11',866,'2003-10-26 18:52:26',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (111,'s11',903,'2003-10-26 22:24:16',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (112,'s11',531,'2003-10-26 22:24:16',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (113,'s11',779,'2003-10-26 22:24:16',0,0,0,NULL,1);
INSERT INTO errorpad VALUES (114,'s11',513,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (115,'s11',620,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (116,'s11',616,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (117,'s11',723,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (118,'s11',530,'2003-10-26 22:24:16',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (119,'s11',487,'2003-10-26 22:24:16',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (120,'s11',533,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (121,'s11',592,'2003-10-26 22:24:16',2,0,0,NULL,1);
INSERT INTO errorpad VALUES (122,'s11',719,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (123,'s11',734,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (124,'s11',494,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (125,'s11',496,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (126,'s11',900,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (127,'s11',532,'2003-10-26 22:24:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (128,'s11',623,'2003-10-27 14:57:15',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (129,'s11',648,'2003-10-27 14:57:15',3,0,0,NULL,1);
INSERT INTO errorpad VALUES (130,'s11',696,'2003-10-27 14:57:15',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (131,'s11',699,'2003-10-27 14:57:16',1,0,0,NULL,1);
INSERT INTO errorpad VALUES (132,'s11',739,'2003-10-27 14:57:16',1,0,0,NULL,1);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -