master

分支 (3)

管理

管理

master

donting

tzw

online_examination
/
在线考试系统.sql

# Host: 127.0.0.1  (Version 5.7.24-log)
# Date: 2019-01-09 10:07:23
# Generator: MySQL-Front 6.0  (Build 2.20)


#
# Structure for table "admin"
#

DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `ad_id` int(11) NOT NULL AUTO_INCREMENT,
  `ad_name` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ad_pass` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ad_permission` int(11) NOT NULL DEFAULT '0' COMMENT '权限',
  `note` varchar(255) COLLATE utf8_bin DEFAULT '',
  `is_visible` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ad_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

#
# Data for table "admin"
#

INSERT INTO `admin` VALUES (1,'Admin','1234567',1,'',0);

#
# Structure for table "ex_to_qu"
#

DROP TABLE IF EXISTS `ex_to_qu`;
CREATE TABLE `ex_to_qu` (
  `exq_id` int(11) NOT NULL AUTO_INCREMENT,
  `ex_id` int(11) NOT NULL DEFAULT '0' COMMENT '试卷ID',
  `qu_id` int(11) NOT NULL DEFAULT '0' COMMENT '题库ID',
  PRIMARY KEY (`exq_id`),
  KEY `ex` (`ex_id`),
  KEY `qu` (`qu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COMMENT='试卷到题库';

#
# Data for table "ex_to_qu"
#

INSERT INTO `ex_to_qu` VALUES (1,1,16),(2,1,14),(3,1,30),(4,1,2),(5,1,6),(6,1,28),(7,1,8),(8,1,4),(9,1,24),(10,1,26),(11,2,10),(12,2,27),(13,2,13),(14,2,17),(15,2,16),(16,2,6),(17,2,2),(18,2,32),(19,2,11),(20,2,31),(21,3,19),(22,3,3),(23,3,29),(24,3,23),(25,3,30),(26,3,20),(27,3,13),(28,3,11),(29,3,5),(30,3,12),(31,4,7),(32,4,8),(33,4,28),(34,4,4),(35,4,5),(36,4,3),(37,4,13),(38,4,12),(39,4,33),(40,4,21),(41,5,11),(42,5,3),(43,5,22),(44,5,12),(45,5,26),(46,5,25),(47,5,8),(48,5,10),(49,5,29),(50,5,30),(51,6,54),(52,6,43),(53,6,35),(54,6,49),(55,6,47),(56,6,48),(57,6,66),(58,6,60),(59,6,62),(60,6,56),(61,7,46),(62,7,37),(63,7,59),(64,7,50),(65,7,53),(66,7,42),(67,7,58),(68,7,52),(69,7,54),(70,7,45),(71,8,41),(72,8,36),(73,8,54),(74,8,63),(75,8,59),(76,8,61),(77,8,37),(78,8,53),(79,8,35),(80,8,64),(81,9,44),(82,9,38),(83,9,40),(84,9,51),(85,9,55),(86,9,50),(87,9,60),(88,9,36),(89,9,66),(90,9,64),(91,11,54),(92,11,46),(93,11,56),(94,11,36),(95,11,43),(96,11,53),(97,11,59),(98,11,38),(99,11,57),(100,11,58);

#
# Structure for table "examinationpaper"
#

DROP TABLE IF EXISTS `examinationpaper`;
CREATE TABLE `examinationpaper` (
  `ex_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '试卷ID',
  `subjects_id` int(11) NOT NULL DEFAULT '0' COMMENT '科目ID',
  `note` varchar(255) DEFAULT '',
  `teacher_id` int(11) NOT NULL DEFAULT '0' COMMENT '出题人ID',
  `add_time` datetime DEFAULT NULL COMMENT '生成试卷时间',
  `modify_time` datetime DEFAULT NULL COMMENT '修改时间',
  `ex_name` varchar(50) NOT NULL DEFAULT '' COMMENT '试卷名',
  `ex_countdown` int(11) NOT NULL DEFAULT '0' COMMENT '考试时间',
  `is_visible` int(11) NOT NULL,
  PRIMARY KEY (`ex_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='试卷';

#
# Data for table "examinationpaper"
#

INSERT INTO `examinationpaper` VALUES (1,1,NULL,1,'2019-01-05 01:05:18','2019-01-05 01:05:45','《数学高考一卷》',60,0),(2,1,NULL,1,'2019-01-05 01:11:30','2019-01-05 01:11:30','《数学高考一卷》',120,0),(3,1,NULL,1,'2019-01-05 01:12:14','2019-01-05 01:12:14','《数学高考一卷》',120,0),(4,1,NULL,1,'2019-01-05 17:07:48','2019-01-05 17:07:48','《大学数学期末考试1卷》',1,0),(5,1,NULL,1,'2019-01-05 21:45:49','2019-01-05 21:45:49','《大学数学期末考试1卷》',1,0),(6,2,NULL,1,'2019-01-05 21:47:59','2019-01-05 21:47:59','《大学语文期末考试  一卷》',1,1),(7,2,NULL,1,'2019-01-05 21:49:11','2019-01-05 21:49:11','《大学语文期末考试 二卷》',1,1),(8,2,NULL,1,'2019-01-05 23:39:27','2019-01-05 23:39:27','《大学语文期末考试 三卷》',1,1),(9,2,NULL,1,'2019-01-07 15:34:59','2019-01-07 15:34:59','《全国语文卷2》',60,0),(10,5,NULL,1,'2019-01-09 09:19:44','2019-01-09 09:19:44','试卷1',120,1),(11,2,NULL,1,'2019-01-09 09:22:05','2019-01-09 09:22:05','试卷1（演示）',120,1);

#
# Structure for table "options"
#

DROP TABLE IF EXISTS `options`;
CREATE TABLE `options` (
  `op_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '选项ID',
  `op_key` varchar(2) NOT NULL DEFAULT '' COMMENT '选项 ： A B',
  `op_value` varchar(255) NOT NULL DEFAULT '' COMMENT '选项内容',
  `question_bank_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`op_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1633 DEFAULT CHARSET=utf8 COMMENT='选项';

#
# Data for table "options"
#

INSERT INTO `options` VALUES (1,'A','选项1',1),(2,'B','选项2.1',1),(3,'C','选项3.1',1),(4,'D','选项4.1',1),(5,'A','选项2',2),(6,'B','选项2.2',2),(7,'C','选项3.2',2),(8,'D','选项4.2',2),(9,'A','选项3',3),(10,'B','选项2.3',3),(11,'C','选项3.3',3),(12,'D','选项4.3',3),(13,'A','选项4',4),(14,'B','选项2.4',4),(15,'C','选项3.4',4),(16,'D','选项4.4',4),(17,'A','选项5',5),(18,'B','选项2.5',5),(19,'C','选项3.5',5),(20,'D','选项4.5',5),(21,'A','选项6',6),(22,'B','选项2.6',6),(23,'C','选项3.6',6),(24,'D','选项4.6',6),(25,'A','选项7',7),(26,'B','选项2.7',7),(27,'C','选项3.7',7),(28,'D','选项4.7',7),(29,'A','选项8',8),(30,'B','选项2.8',8),(31,'C','选项3.8',8),(32,'D','选项4.8',8),(33,'A','选项9',9),(34,'B','选项2.9',9),(35,'C','选项3.9',9),(36,'D','选项4.9',9),(37,'A','选项10',10),(38,'B','选项2.10',10),(39,'C','选项3.10',10),(40,'D','选项4.10',10),(41,'A','选项11',11),(42,'B','选项2.11',11),(43,'C','选项3.11',11),(44,'D','选项4.11',11),(45,'A','选项12',12),(46,'B','选项2.12',12),(47,'C','选项3.12',12),(48,'D','选项4.12',12),(49,'A','选项13',13),(50,'B','选项2.13',13),(51,'C','选项3.13',13),(52,'D','选项4.13',13),(53,'A','选项14',14),(54,'B','选项2.14',14),(55,'C','选项3.14',14),(56,'D','选项4.14',14),(57,'A','选项15',15),(58,'B','选项2.15',15),(59,'C','选项3.15',15),(60,'D','选项4.15',15),(61,'A','选项16',16),(62,'B','选项2.16',16),(63,'C','选项3.16',16),(64,'D','选项4.16',16),(65,'A','选项17',17),(66,'B','选项2.17',17),(67,'C','选项3.17',17),(68,'D','选项4.17',17),(69,'A','选项18',18),(70,'B','选项2.18',18),(71,'C','选项3.18',18),(72,'D','选项4.18',18),(73,'A','选项19',19),(74,'B','选项2.19',19),(75,'C','选项3.19',19),(76,'D','选项4.19',19),(77,'A','选项20',20),(78,'B','选项2.20',20),(79,'C','选项3.20',20),(80,'D','选项4.20',20),(81,'A','选项21',21),(82,'B','选项2.21',21),(83,'C','选项3.21',21),(84,'D','选项4.21',21),(85,'A','选项22',22),(86,'B','选项2.22',22),(87,'C','选项3.22',22),(88,'D','选项4.22',22),(89,'A','选项23',23),(90,'B','选项2.23',23),(91,'C','选项3.23',23),(92,'D','选项4.23',23),(93,'A','选项24',24),(94,'B','选项2.24',24),(95,'C','选项3.24',24),(96,'D','选项4.24',24),(97,'A','选项25',25),(98,'B','选项2.25',25),(99,'C','选项3.25',25),(100,'D','选项4.25',25),(101,'A','选项26',26),(102,'B','选项2.26',26),(103,'C','选项3.26',26),(104,'D','选项4.26',26),(105,'A','选项27',27),(106,'B','选项2.27',27),(107,'C','选项3.27',27),(108,'D','选项4.27',27),(109,'A','选项28',28),(110,'B','选项2.28',28),(111,'C','选项3.28',28),(112,'D','选项4.28',28),(113,'A','选项29',29),(114,'B','选项2.29',29),(115,'C','选项3.29',29),(116,'D','选项4.29',29),(117,'A','选项30',30),(118,'B','选项2.30',30),(119,'C','选项3.30',30),(120,'D','选项4.30',30),(121,'A','选项31',31),(122,'B','选项2.31',31),(123,'C','选项3.31',31),(124,'D','选项4.31',31),(125,'A','选项32',32),(126,'B','选项2.32',32),(127,'C','选项3.32',32),(128,'D','选项4.32',32),(129,'A','选项33',33),(130,'B','选项2.33',33),(131,'C','选项3.33',33),(132,'D','选项4.33',33),(133,'A','选项34',34),(134,'B','选项2.34',34),(135,'C','选项3.34',34),(136,'D','选项4.34',34),(137,'A','选项1',35),(138,'B','选项2.1',35),(139,'C','选项3.1',35),(140,'D','选项4.1',35),(141,'A','选项2',36),(142,'B','选项2.2',36),(143,'C','选项3.2',36),(144,'D','选项4.2',36),(145,'A','选项3',37),(146,'B','选项2.3',37),(147,'C','选项3.3',37),(148,'D','选项4.3',37),(149,'A','选项4',38),(150,'B','选项2.4',38),(151,'C','选项3.4',38),(152,'D','选项4.4',38),(153,'A','选项5',39),(154,'B','选项2.5',39),(155,'C','选项3.5',39),(156,'D','选项4.5',39),(157,'A','选项6',40),(158,'B','选项2.6',40),(159,'C','选项3.6',40),(160,'D','选项4.6',40),(161,'A','选项7',41),(162,'B','选项2.7',41),(163,'C','选项3.7',41),(164,'D','选项4.7',41),(165,'A','选项8',42),(166,'B','选项2.8',42),(167,'C','选项3.8',42),(168,'D','选项4.8',42),(169,'A','选项9',43),(170,'B','选项2.9',43),(171,'C','选项3.9',43),(172,'D','选项4.9',43),(173,'A','选项10',44),(174,'B','选项2.10',44),(175,'C','选项3.10',44),(176,'D','选项4.10',44),(177,'A','选项11',45),(178,'B','选项2.11',45),(179,'C','选项3.11',45),(180,'D','选项4.11',45),(181,'A','选项12',46),(182,'B','选项2.12',46),(183,'C','选项3.12',46),(184,'D','选项4.12',46),(185,'A','选项13',47),(186,'B','选项2.13',47),(187,'C','选项3.13',47),(188,'D','选项4.13',47),(189,'A','选项14',48),(190,'B','选项2.14',48),(191,'C','选项3.14',48),(192,'D','选项4.14',48),(193,'A','选项15',49),(194,'B','选项2.15',49),(195,'C','选项3.15',49),(196,'D','选项4.15',49),(197,'A','选项16',50),(198,'B','选项2.16',50),(199,'C','选项3.16',50),(200,'D','选项4.16',50),(201,'A','选项17',51),(202,'B','选项2.17',51),(203,'C','选项3.17',51),(204,'D','选项4.17',51),(205,'A','选项18',52),(206,'B','选项2.18',52),(207,'C','选项3.18',52),(208,'D','选项4.18',52),(209,'A','选项19',53),(210,'B','选项2.19',53),(211,'C','选项3.19',53),(212,'D','选项4.19',53),(213,'A','选项20',54),(214,'B','选项2.20',54),(215,'C','选项3.20',54),(216,'D','选项4.20',54),(217,'A','选项21',55),(218,'B','选项2.21',55),(219,'C','选项3.21',55),(220,'D','选项4.21',55),(221,'A','选项22',56),(222,'B','选项2.22',56),(223,'C','选项3.22',56),(224,'D','选项4.22',56),(225,'A','选项23',57),(226,'B','选项2.23',57),(227,'C','选项3.23',57),(228,'D','选项4.23',57),(229,'A','选项24',58),(230,'B','选项2.24',58),(231,'C','选项3.24',58),(232,'D','选项4.24',58),(233,'A','选项25',59),(234,'B','选项2.25',59),(235,'C','选项3.25',59),(236,'D','选项4.25',59),(237,'A','选项26',60),(238,'B','选项2.26',60),(239,'C','选项3.26',60),(240,'D','选项4.26',60),(241,'A','选项27',61),(242,'B','选项2.27',61),(243,'C','选项3.27',61),(244,'D','选项4.27',61),(245,'A','选项28',62),(246,'B','选项2.28',62),(247,'C','选项3.28',62),(248,'D','选项4.28',62),(249,'A','选项29',63),(250,'B','选项2.29',63),(251,'C','选项3.29',63),(252,'D','选项4.29',63),(253,'A','选项30',64),(254,'B','选项2.30',64),(255,'C','选项3.30',64),(256,'D','选项4.30',64),(257,'A','选项31',65),(258,'B','选项2.31',65),(259,'C','选项3.31',65),(260,'D','选项4.31',65),(261,'A','选项32',66),(262,'B','选项2.32',66),(263,'C','选项3.32',66),(264,'D','选项4.32',66),(265,'A','选项33',67),(266,'B','选项2.33',67),(267,'C','选项3.33',67),(268,'D','选项4.33',67),(269,'A','选项34',68),(270,'B','选项2.34',68),(271,'C','选项3.34',68),(272,'D','选项4.34',68),(273,'A','选项1',69),(274,'B','选项2.1',69),(275,'C','选项3.1',69),(276,'D','选项4.1',69),(277,'A','选项2',70),(278,'B','选项2.2',70),(279,'C','选项3.2',70),(280,'D','选项4.2',70),(281,'A','选项3',71),(282,'B','选项2.3',71),(283,'C','选项3.3',71),(284,'D','选项4.3',71),(285,'A','选项4',72),(286,'B','选项2.4',72),(287,'C','选项3.4',72),(288,'D','选项4.4',72),(289,'A','选项5',73),(290,'B','选项2.5',73),(291,'C','选项3.5',73),(292,'D','选项4.5',73),(293,'A','选项6',74),(294,'B','选项2.6',74),(295,'C','选项3.6',74),(296,'D','选项4.6',74),(297,'A','选项7',75),(298,'B','选项2.7',75),(299,'C','选项3.7',75),(300,'D','选项4.7',75),(301,'A','选项8',76),(302,'B','选项2.8',76),(303,'C','选项3.8',76),(304,'D','选项4.8',76),(305,'A','选项9',77),(306,'B','选项2.9',77),(307,'C','选项3.9',77),(308,'D','选项4.9',77),(309,'A','选项10',78),(310,'B','选项2.10',78),(311,'C','选项3.10',78),(312,'D','选项4.10',78),(313,'A','选项11',79),(314,'B','选项2.11',79),(315,'C','选项3.11',79),(316,'D','选项4.11',79),(317,'A','选项12',80),(318,'B','选项2.12',80),(319,'C','选项3.12',80),(320,'D','选项4.12',80),(321,'A','选项13',81),(322,'B','选项2.13',81),(323,'C','选项3.13',81),(324,'D','选项4.13',81),(325,'A','选项14',82),(326,'B','选项2.14',82),(327,'C','选项3.14',82),(328,'D','选项4.14',82),(329,'A','选项15',83),(330,'B','选项2.15',83),(331,'C','选项3.15',83),(332,'D','选项4.15',83),(333,'A','选项16',84),(334,'B','选项2.16',84),(335,'C','选项3.16',84),(336,'D','选项4.16',84),(337,'A','选项17',85),(338,'B','选项2.17',85),(339,'C','选项3.17',85),(340,'D','选项4.17',85),(341,'A','选项18',86),(342,'B','选项2.18',86),(343,'C','选项3.18',86),(344,'D','选项4.18',86),(345,'A','选项19',87),(346,'B','选项2.19',87),(347,'C','选项3.19',87),(348,'D','选项4.19',87),(349,'A','选项20',88),(350,'B','选项2.20',88),(351,'C','选项3.20',88),(352,'D','选项4.20',88),(353,'A','选项21',89),(354,'B','选项2.21',89),(355,'C','选项3.21',89),(356,'D','选项4.21',89),(357,'A','选项22',90),(358,'B','选项2.22',90),(359,'C','选项3.22',90),(360,'D','选项4.22',90),(361,'A','选项23',91),(362,'B','选项2.23',91),(363,'C','选项3.23',91),(364,'D','选项4.23',91),(365,'A','选项24',92),(366,'B','选项2.24',92),(367,'C','选项3.24',92),(368,'D','选项4.24',92),(369,'A','选项25',93),(370,'B','选项2.25',93),(371,'C','选项3.25',93),(372,'D','选项4.25',93),(373,'A','选项26',94),(374,'B','选项2.26',94),(375,'C','选项3.26',94),(376,'D','选项4.26',94),(377,'A','选项27',95),(378,'B','选项2.27',95),(379,'C','选项3.27',95),(380,'D','选项4.27',95),(381,'A','选项28',96),(382,'B','选项2.28',96),(383,'C','选项3.28',96),(384,'D','选项4.28',96),(385,'A','选项29',97),(386,'B','选项2.29',97),(387,'C','选项3.29',97),(388,'D','选项4.29',97),(389,'A','选项30',98),(390,'B','选项2.30',98),(391,'C','选项3.30',98),(392,'D','选项4.30',98),(393,'A','选项31',99),(394,'B','选项2.31',99),(395,'C','选项3.31',99),(396,'D','选项4.31',99),(397,'A','选项32',100),(398,'B','选项2.32',100),(399,'C','选项3.32',100),(400,'D','选项4.32',100),(401,'A','选项33',101),(402,'B','选项2.33',101),(403,'C','选项3.33',101),(404,'D','选项4.33',101),(405,'A','选项34',102),(406,'B','选项2.34',102),(407,'C','选项3.34',102),(408,'D','选项4.34',102),(409,'A','选项1',103),(410,'B','选项2.1',103),(411,'C','选项3.1',103),(412,'D','选项4.1',103),(413,'A','选项2',104),(414,'B','选项2.2',104),(415,'C','选项3.2',104),(416,'D','选项4.2',104),(417,'A','选项3',105),(418,'B','选项2.3',105),(419,'C','选项3.3',105),(420,'D','选项4.3',105),(421,'A','选项4',106),(422,'B','选项2.4',106),(423,'C','选项3.4',106),(424,'D','选项4.4',106),(425,'A','选项5',107),(426,'B','选项2.5',107),(427,'C','选项3.5',107),(428,'D','选项4.5',107),(429,'A','选项6',108),(430,'B','选项2.6',108),(431,'C','选项3.6',108),(432,'D','选项4.6',108),(433,'A','选项7',109),(434,'B','选项2.7',109),(435,'C','选项3.7',109),(436,'D','选项4.7',109),(437,'A','选项8',110),(438,'B','选项2.8',110),(439,'C','选项3.8',110),(440,'D','选项4.8',110),(441,'A','选项9',111),(442,'B','选项2.9',111),(443,'C','选项3.9',111),(444,'D','选项4.9',111),(445,'A','选项10',112),(446,'B','选项2.10',112),(447,'C','选项3.10',112),(448,'D','选项4.10',112),(449,'A','选项11',113),(450,'B','选项2.11',113),(451,'C','选项3.11',113),(452,'D','选项4.11',113),(453,'A','选项12',114),(454,'B','选项2.12',114),(455,'C','选项3.12',114),(456,'D','选项4.12',114),(457,'A','选项13',115),(458,'B','选项2.13',115),(459,'C','选项3.13',115),(460,'D','选项4.13',115),(461,'A','选项14',116),(462,'B','选项2.14',116),(463,'C','选项3.14',116),(464,'D','选项4.14',116),(465,'A','选项15',117),(466,'B','选项2.15',117),(467,'C','选项3.15',117),(468,'D','选项4.15',117),(469,'A','选项16',118),(470,'B','选项2.16',118),(471,'C','选项3.16',118),(472,'D','选项4.16',118),(473,'A','选项17',119),(474,'B','选项2.17',119),(475,'C','选项3.17',119),(476,'D','选项4.17',119),(477,'A','选项18',120),(478,'B','选项2.18',120),(479,'C','选项3.18',120),(480,'D','选项4.18',120),(481,'A','选项19',121),(482,'B','选项2.19',121),(483,'C','选项3.19',121),(484,'D','选项4.19',121),(485,'A','选项20',122),(486,'B','选项2.20',122),(487,'C','选项3.20',122),(488,'D','选项4.20',122),(489,'A','选项21',123),(490,'B','选项2.21',123),(491,'C','选项3.21',123),(492,'D','选项4.21',123),(493,'A','选项22',124),(494,'B','选项2.22',124),(495,'C','选项3.22',124),(496,'D','选项4.22',124),(497,'A','选项23',125),(498,'B','选项2.23',125),(499,'C','选项3.23',125),(500,'D','选项4.23',125),(501,'A','选项24',126),(502,'B','选项2.24',126),(503,'C','选项3.24',126),(504,'D','选项4.24',126),(505,'A','选项25',127),(506,'B','选项2.25',127),(507,'C','选项3.25',127),(508,'D','选项4.25',127),(509,'A','选项26',128),(510,'B','选项2.26',128),(511,'C','选项3.26',128),(512,'D','选项4.26',128),(513,'A','选项27',129),(514,'B','选项2.27',129),(515,'C','选项3.27',129),(516,'D','选项4.27',129),(517,'A','选项28',130),(518,'B','选项2.28',130),(519,'C','选项3.28',130),(520,'D','选项4.28',130),(521,'A','选项29',131),(522,'B','选项2.29',131),(523,'C','选项3.29',131),(524,'D','选项4.29',131),(525,'A','选项30',132),(526,'B','选项2.30',132),(527,'C','选项3.30',132),(528,'D','选项4.30',132),(529,'A','选项31',133),(530,'B','选项2.31',133),(531,'C','选项3.31',133),(532,'D','选项4.31',133),(533,'A','选项32',134),(534,'B','选项2.32',134),(535,'C','选项3.32',134),(536,'D','选项4.32',134),(537,'A','选项33',135),(538,'B','选项2.33',135),(539,'C','选项3.33',135),(540,'D','选项4.33',135),(541,'A','选项34',136),(542,'B','选项2.34',136),(543,'C','选项3.34',136),(544,'D','选项4.34',136),(545,'A','选项1',1),(546,'B','选项2.1',1),(547,'C','选项3.1',1),(548,'D','选项4.1',1),(549,'A','选项2',2),(550,'B','选项2.2',2),(551,'C','选项3.2',2),(552,'D','选项4.2',2),(553,'A','选项3',3),(554,'B','选项2.3',3),(555,'C','选项3.3',3),(556,'D','选项4.3',3),(557,'A','选项4',4),(558,'B','选项2.4',4),(559,'C','选项3.4',4),(560,'D','选项4.4',4),(561,'A','选项5',5),(562,'B','选项2.5',5),(563,'C','选项3.5',5),(564,'D','选项4.5',5),(565,'A','选项6',6),(566,'B','选项2.6',6),(567,'C','选项3.6',6),(568,'D','选项4.6',6),(569,'A','选项7',7),(570,'B','选项2.7',7),(571,'C','选项3.7',7),(572,'D','选项4.7',7),(573,'A','选项8',8),(574,'B','选项2.8',8),(575,'C','选项3.8',8),(576,'D','选项4.8',8),(577,'A','选项9',9),(578,'B','选项2.9',9),(579,'C','选项3.9',9),(580,'D','选项4.9',9),(581,'A','选项10',10),(582,'B','选项2.10',10),(583,'C','选项3.10',10),(584,'D','选项4.10',10),(585,'A','选项11',11),(586,'B','选项2.11',11),(587,'C','选项3.11',11),(588,'D','选项4.11',11),(589,'A','选项12',12),(590,'B','选项2.12',12),(591,'C','选项3.12',12),(592,'D','选项4.12',12),(593,'A','选项13',13),(594,'B','选项2.13',13),(595,'C','选项3.13',13),(596,'D','选项4.13',13),(597,'A','选项14',14),(598,'B','选项2.14',14),(599,'C','选项3.14',14),(600,'D','选项4.14',14),(601,'A','选项15',15),(602,'B','选项2.15',15),(603,'C','选项3.15',15),(604,'D','选项4.15',15),(605,'A','选项16',16),(606,'B','选项2.16',16),(607,'C','选项3.16',16),(608,'D','选项4.16',16),(609,'A','选项17',17),(610,'B','选项2.17',17),(611,'C','选项3.17',17),(612,'D','选项4.17',17),(613,'A','选项18',18),(614,'B','选项2.18',18),(615,'C','选项3.18',18),(616,'D','选项4.18',18),(617,'A','选项19',19),(618,'B','选项2.19',19),(619,'C','选项3.19',19),(620,'D','选项4.19',19),(621,'A','选项20',20),(622,'B','选项2.20',20),(623,'C','选项3.20',20),(624,'D','选项4.20',20),(625,'A','选项21',21),(626,'B','选项2.21',21),(627,'C','选项3.21',21),(628,'D','选项4.21',21),(629,'A','选项22',22),(630,'B','选项2.22',22),(631,'C','选项3.22',22),(632,'D','选项4.22',22),(633,'A','选项23',23),(634,'B','选项2.23',23),(635,'C','选项3.23',23),(636,'D','选项4.23',23),(637,'A','选项24',24),(638,'B','选项2.24',24),(639,'C','选项3.24',24),(640,'D','选项4.24',24),(641,'A','选项25',25),(642,'B','选项2.25',25),(643,'C','选项3.25',25),(644,'D','选项4.25',25),(645,'A','选项26',26),(646,'B','选项2.26',26),(647,'C','选项3.26',26),(648,'D','选项4.26',26),(649,'A','选项27',27),(650,'B','选项2.27',27),(651,'C','选项3.27',27),(652,'D','选项4.27',27),(653,'A','选项28',28),(654,'B','选项2.28',28),(655,'C','选项3.28',28),(656,'D','选项4.28',28),(657,'A','选项29',29),(658,'B','选项2.29',29),(659,'C','选项3.29',29),(660,'D','选项4.29',29),(661,'A','选项30',30),(662,'B','选项2.30',30),(663,'C','选项3.30',30),(664,'D','选项4.30',30),(665,'A','选项31',31),(666,'B','选项2.31',31),(667,'C','选项3.31',31),(668,'D','选项4.31',31),(669,'A','选项32',32),(670,'B','选项2.32',32),(671,'C','选项3.32',32),(672,'D','选项4.32',32),(673,'A','选项33',33),(674,'B','选项2.33',33),(675,'C','选项3.33',33),(676,'D','选项4.33',33),(677,'A','选项34',34),(678,'B','选项2.34',34),(679,'C','选项3.34',34),(680,'D','选项4.34',34),(681,'A','选项1',35),(682,'B','选项2.1',35),(683,'C','选项3.1',35),(684,'D','选项4.1',35),(685,'A','选项2',36),(686,'B','选项2.2',36),(687,'C','选项3.2',36),(688,'D','选项4.2',36),(689,'A','选项3',37),(690,'B','选项2.3',37),(691,'C','选项3.3',37),(692,'D','选项4.3',37),(693,'A','选项4',38),(694,'B','选项2.4',38),(695,'C','选项3.4',38),(696,'D','选项4.4',38),(697,'A','选项5',39),(698,'B','选项2.5',39),(699,'C','选项3.5',39),(700,'D','选项4.5',39),(701,'A','选项6',40),(702,'B','选项2.6',40),(703,'C','选项3.6',40),(704,'D','选项4.6',40),(705,'A','选项7',41),(706,'B','选项2.7',41),(707,'C','选项3.7',41),(708,'D','选项4.7',41),(709,'A','选项8',42),(710,'B','选项2.8',42),(711,'C','选项3.8',42),(712,'D','选项4.8',42),(713,'A','选项9',43),(714,'B','选项2.9',43),(715,'C','选项3.9',43),(716,'D','选项4.9',43),(717,'A','选项10',44),(718,'B','选项2.10',44),(719,'C','选项3.10',44),(720,'D','选项4.10',44),(721,'A','选项11',45),(722,'B','选项2.11',45),(723,'C','选项3.11',45),(724,'D','选项4.11',45),(725,'A','选项12',46),(726,'B','选项2.12',46),(727,'C','选项3.12',46),(728,'D','选项4.12',46),(729,'A','选项13',47),(730,'B','选项2.13',47),(731,'C','选项3.13',47),(732,'D','选项4.13',47),(733,'A','选项14',48),(734,'B','选项2.14',48),(735,'C','选项3.14',48),(736,'D','选项4.14',48),(737,'A','选项15',49),(738,'B','选项2.15',49),(739,'C','选项3.15',49),(740,'D','选项4.15',49),(741,'A','选项16',50),(742,'B','选项2.16',50),(743,'C','选项3.16',50),(744,'D','选项4.16',50),(745,'A','选项17',51),(746,'B','选项2.17',51),(747,'C','选项3.17',51),(748,'D','选项4.17',51),(749,'A','选项18',52),(750,'B','选项2.18',52),(751,'C','选项3.18',52),(752,'D','选项4.18',52),(753,'A','选项19',53),(754,'B','选项2.19',53),(755,'C','选项3.19',53),(756,'D','选项4.19',53),(757,'A','选项20',54),(758,'B','选项2.20',54),(759,'C','选项3.20',54),(760,'D','选项4.20',54),(761,'A','选项21',55),(762,'B','选项2.21',55),(763,'C','选项3.21',55),(764,'D','选项4.21',55),(765,'A','选项22',56),(766,'B','选项2.22',56),(767,'C','选项3.22',56),(768,'D','选项4.22',56),(769,'A','选项23',57),(770,'B','选项2.23',57),(771,'C','选项3.23',57),(772,'D','选项4.23',57),(773,'A','选项24',58),(774,'B','选项2.24',58),(775,'C','选项3.24',58),(776,'D','选项4.24',58),(777,'A','选项25',59),(778,'B','选项2.25',59),(779,'C','选项3.25',59),(780,'D','选项4.25',59),(781,'A','选项26',60),(782,'B','选项2.26',60),(783,'C','选项3.26',60),(784,'D','选项4.26',60),(785,'A','选项27',61),(786,'B','选项2.27',61),(787,'C','选项3.27',61),(788,'D','选项4.27',61),(789,'A','选项28',62),(790,'B','选项2.28',62),(791,'C','选项3.28',62),(792,'D','选项4.28',62),(793,'A','选项29',63),(794,'B','选项2.29',63),(795,'C','选项3.29',63),(796,'D','选项4.29',63),(797,'A','选项30',64),(798,'B','选项2.30',64),(799,'C','选项3.30',64),(800,'D','选项4.30',64),(801,'A','选项31',65),(802,'B','选项2.31',65),(803,'C','选项3.31',65),(804,'D','选项4.31',65),(805,'A','选项32',66),(806,'B','选项2.32',66),(807,'C','选项3.32',66),(808,'D','选项4.32',66),(809,'A','选项33',67),(810,'B','选项2.33',67),(811,'C','选项3.33',67),(812,'D','选项4.33',67),(813,'A','选项34',68),(814,'B','选项2.34',68),(815,'C','选项3.34',68),(816,'D','选项4.34',68),(817,'A','选项1',69),(818,'B','选项2.1',69),(819,'C','选项3.1',69),(820,'D','选项4.1',69),(821,'A','选项2',70),(822,'B','选项2.2',70),(823,'C','选项3.2',70),(824,'D','选项4.2',70),(825,'A','选项3',71),(826,'B','选项2.3',71),(827,'C','选项3.3',71),(828,'D','选项4.3',71),(829,'A','选项4',72),(830,'B','选项2.4',72),(831,'C','选项3.4',72),(832,'D','选项4.4',72),(833,'A','选项5',73),(834,'B','选项2.5',73),(835,'C','选项3.5',73),(836,'D','选项4.5',73),(837,'A','选项6',74),(838,'B','选项2.6',74),(839,'C','选项3.6',74),(840,'D','选项4.6',74),(841,'A','选项7',75),(842,'B','选项2.7',75),(843,'C','选项3.7',75),(844,'D','选项4.7',75),(845,'A','选项8',76),(846,'B','选项2.8',76),(847,'C','选项3.8',76),(848,'D','选项4.8',76),(849,'A','选项9',77),(850,'B','选项2.9',77),(851,'C','选项3.9',77),(852,'D','选项4.9',77),(853,'A','选项10',78),(854,'B','选项2.10',78),(855,'C','选项3.10',78),(856,'D','选项4.10',78),(857,'A','选项11',79),(858,'B','选项2.11',79),(859,'C','选项3.11',79),(860,'D','选项4.11',79),(861,'A','选项12',80),(862,'B','选项2.12',80),(863,'C','选项3.12',80),(864,'D','选项4.12',80),(865,'A','选项13',81),(866,'B','选项2.13',81),(867,'C','选项3.13',81),(868,'D','选项4.13',81),(869,'A','选项14',82),(870,'B','选项2.14',82),(871,'C','选项3.14',82),(872,'D','选项4.14',82),(873,'A','选项15',83),(874,'B','选项2.15',83),(875,'C','选项3.15',83),(876,'D','选项4.15',83),(877,'A','选项16',84),(878,'B','选项2.16',84),(879,'C','选项3.16',84),(880,'D','选项4.16',84),(881,'A','选项17',85),(882,'B','选项2.17',85),(883,'C','选项3.17',85),(884,'D','选项4.17',85),(885,'A','选项18',86),(886,'B','选项2.18',86),(887,'C','选项3.18',86),(888,'D','选项4.18',86),(889,'A','选项19',87),(890,'B','选项2.19',87),(891,'C','选项3.19',87),(892,'D','选项4.19',87),(893,'A','选项20',88),(894,'B','选项2.20',88),(895,'C','选项3.20',88),(896,'D','选项4.20',88),(897,'A','选项21',89),(898,'B','选项2.21',89),(899,'C','选项3.21',89),(900,'D','选项4.21',89),(901,'A','选项22',90),(902,'B','选项2.22',90),(903,'C','选项3.22',90),(904,'D','选项4.22',90),(905,'A','选项23',91),(906,'B','选项2.23',91),(907,'C','选项3.23',91),(908,'D','选项4.23',91),(909,'A','选项24',92),(910,'B','选项2.24',92),(911,'C','选项3.24',92),(912,'D','选项4.24',92),(913,'A','选项25',93),(914,'B','选项2.25',93),(915,'C','选项3.25',93),(916,'D','选项4.25',93),(917,'A','选项26',94),(918,'B','选项2.26',94),(919,'C','选项3.26',94),(920,'D','选项4.26',94),(921,'A','选项27',95),(922,'B','选项2.27',95),(923,'C','选项3.27',95),(924,'D','选项4.27',95),(925,'A','选项28',96),(926,'B','选项2.28',96),(927,'C','选项3.28',96),(928,'D','选项4.28',96),(929,'A','选项29',97),(930,'B','选项2.29',97),(931,'C','选项3.29',97),(932,'D','选项4.29',97),(933,'A','选项30',98),(934,'B','选项2.30',98),(935,'C','选项3.30',98),(936,'D','选项4.30',98),(937,'A','选项31',99),(938,'B','选项2.31',99),(939,'C','选项3.31',99),(940,'D','选项4.31',99),(941,'A','选项32',100),(942,'B','选项2.32',100),(943,'C','选项3.32',100),(944,'D','选项4.32',100),(945,'A','选项33',101),(946,'B','选项2.33',101),(947,'C','选项3.33',101),(948,'D','选项4.33',101),(949,'A','选项34',102),(950,'B','选项2.34',102),(951,'C','选项3.34',102),(952,'D','选项4.34',102),(953,'A','选项1',103),(954,'B','选项2.1',103),(955,'C','选项3.1',103),(956,'D','选项4.1',103),(957,'A','选项2',104),(958,'B','选项2.2',104),(959,'C','选项3.2',104),(960,'D','选项4.2',104),(961,'A','选项3',105),(962,'B','选项2.3',105),(963,'C','选项3.3',105),(964,'D','选项4.3',105),(965,'A','选项4',106),(966,'B','选项2.4',106),(967,'C','选项3.4',106),(968,'D','选项4.4',106),(969,'A','选项5',107),(970,'B','选项2.5',107),(971,'C','选项3.5',107),(972,'D','选项4.5',107),(973,'A','选项6',108),(974,'B','选项2.6',108),(975,'C','选项3.6',108),(976,'D','选项4.6',108),(977,'A','选项7',109),(978,'B','选项2.7',109),(979,'C','选项3.7',109),(980,'D','选项4.7',109),(981,'A','选项8',110),(982,'B','选项2.8',110),(983,'C','选项3.8',110),(984,'D','选项4.8',110),(985,'A','选项9',111),(986,'B','选项2.9',111),(987,'C','选项3.9',111),(988,'D','选项4.9',111),(989,'A','选项10',112),(990,'B','选项2.10',112),(991,'C','选项3.10',112),(992,'D','选项4.10',112),(993,'A','选项11',113),(994,'B','选项2.11',113),(995,'C','选项3.11',113),(996,'D','选项4.11',113),(997,'A','选项12',114),(998,'B','选项2.12',114),(999,'C','选项3.12',114),(1000,'D','选项4.12',114),(1001,'A','选项13',115),(1002,'B','选项2.13',115),(1003,'C','选项3.13',115),(1004,'D','选项4.13',115),(1005,'A','选项14',116),(1006,'B','选项2.14',116),(1007,'C','选项3.14',116),(1008,'D','选项4.14',116),(1009,'A','选项15',117),(1010,'B','选项2.15',117),(1011,'C','选项3.15',117),(1012,'D','选项4.15',117),(1013,'A','选项16',118),(1014,'B','选项2.16',118),(1015,'C','选项3.16',118),(1016,'D','选项4.16',118),(1017,'A','选项17',119),(1018,'B','选项2.17',119),(1019,'C','选项3.17',119),(1020,'D','选项4.17',119),(1021,'A','选项18',120),(1022,'B','选项2.18',120),(1023,'C','选项3.18',120),(1024,'D','选项4.18',120),(1025,'A','选项19',121),(1026,'B','选项2.19',121),(1027,'C','选项3.19',121),(1028,'D','选项4.19',121),(1029,'A','选项20',122),(1030,'B','选项2.20',122),(1031,'C','选项3.20',122),(1032,'D','选项4.20',122),(1033,'A','选项21',123),(1034,'B','选项2.21',123),(1035,'C','选项3.21',123),(1036,'D','选项4.21',123),(1037,'A','选项22',124),(1038,'B','选项2.22',124),(1039,'C','选项3.22',124),(1040,'D','选项4.22',124),(1041,'A','选项23',125),(1042,'B','选项2.23',125),(1043,'C','选项3.23',125),(1044,'D','选项4.23',125),(1045,'A','选项24',126),(1046,'B','选项2.24',126),(1047,'C','选项3.24',126),(1048,'D','选项4.24',126),(1049,'A','选项25',127),(1050,'B','选项2.25',127),(1051,'C','选项3.25',127),(1052,'D','选项4.25',127),(1053,'A','选项26',128),(1054,'B','选项2.26',128),(1055,'C','选项3.26',128),(1056,'D','选项4.26',128),(1057,'A','选项27',129),(1058,'B','选项2.27',129),(1059,'C','选项3.27',129),(1060,'D','选项4.27',129),(1061,'A','选项28',130),(1062,'B','选项2.28',130),(1063,'C','选项3.28',130),(1064,'D','选项4.28',130),(1065,'A','选项29',131),(1066,'B','选项2.29',131),(1067,'C','选项3.29',131),(1068,'D','选项4.29',131),(1069,'A','选项30',132),(1070,'B','选项2.30',132),(1071,'C','选项3.30',132),(1072,'D','选项4.30',132),(1073,'A','选项31',133),(1074,'B','选项2.31',133),(1075,'C','选项3.31',133),(1076,'D','选项4.31',133),(1077,'A','选项32',134),(1078,'B','选项2.32',134),(1079,'C','选项3.32',134),(1080,'D','选项4.32',134),(1081,'A','选项33',135),(1082,'B','选项2.33',135),(1083,'C','选项3.33',135),(1084,'D','选项4.33',135),(1085,'A','选项34',136),(1086,'B','选项2.34',136),(1087,'C','选项3.34',136),(1088,'D','选项4.34',136),(1089,'A','选项1',1),(1090,'B','选项2.1',1),(1091,'C','选项3.1',1),(1092,'D','选项4.1',1),(1093,'A','选项2',2),(1094,'B','选项2.2',2),(1095,'C','选项3.2',2),(1096,'D','选项4.2',2),(1097,'A','选项3',3),(1098,'B','选项2.3',3),(1099,'C','选项3.3',3),(1100,'D','选项4.3',3),(1101,'A','选项4',4),(1102,'B','选项2.4',4),(1103,'C','选项3.4',4),(1104,'D','选项4.4',4),(1105,'A','选项5',5),(1106,'B','选项2.5',5),(1107,'C','选项3.5',5),(1108,'D','选项4.5',5),(1109,'A','选项6',6),(1110,'B','选项2.6',6),(1111,'C','选项3.6',6),(1112,'D','选项4.6',6),(1113,'A','选项7',7),(1114,'B','选项2.7',7),(1115,'C','选项3.7',7),(1116,'D','选项4.7',7),(1117,'A','选项8',8),(1118,'B','选项2.8',8),(1119,'C','选项3.8',8),(1120,'D','选项4.8',8),(1121,'A','选项9',9),(1122,'B','选项2.9',9),(1123,'C','选项3.9',9),(1124,'D','选项4.9',9),(1125,'A','选项10',10),(1126,'B','选项2.10',10),(1127,'C','选项3.10',10),(1128,'D','选项4.10',10),(1129,'A','选项11',11),(1130,'B','选项2.11',11),(1131,'C','选项3.11',11),(1132,'D','选项4.11',11),(1133,'A','选项12',12),(1134,'B','选项2.12',12),(1135,'C','选项3.12',12),(1136,'D','选项4.12',12),(1137,'A','选项13',13),(1138,'B','选项2.13',13),(1139,'C','选项3.13',13),(1140,'D','选项4.13',13),(1141,'A','选项14',14),(1142,'B','选项2.14',14),(1143,'C','选项3.14',14),(1144,'D','选项4.14',14),(1145,'A','选项15',15),(1146,'B','选项2.15',15),(1147,'C','选项3.15',15),(1148,'D','选项4.15',15),(1149,'A','选项16',16),(1150,'B','选项2.16',16),(1151,'C','选项3.16',16),(1152,'D','选项4.16',16),(1153,'A','选项17',17),(1154,'B','选项2.17',17),(1155,'C','选项3.17',17),(1156,'D','选项4.17',17),(1157,'A','选项18',18),(1158,'B','选项2.18',18),(1159,'C','选项3.18',18),(1160,'D','选项4.18',18),(1161,'A','选项19',19),(1162,'B','选项2.19',19),(1163,'C','选项3.19',19),(1164,'D','选项4.19',19),(1165,'A','选项20',20),(1166,'B','选项2.20',20),(1167,'C','选项3.20',20),(1168,'D','选项4.20',20),(1169,'A','选项21',21),(1170,'B','选项2.21',21),(1171,'C','选项3.21',21),(1172,'D','选项4.21',21),(1173,'A','选项22',22),(1174,'B','选项2.22',22),(1175,'C','选项3.22',22),(1176,'D','选项4.22',22),(1177,'A','选项23',23),(1178,'B','选项2.23',23),(1179,'C','选项3.23',23),(1180,'D','选项4.23',23),(1181,'A','选项24',24),(1182,'B','选项2.24',24),(1183,'C','选项3.24',24),(1184,'D','选项4.24',24),(1185,'A','选项25',25),(1186,'B','选项2.25',25),(1187,'C','选项3.25',25),(1188,'D','选项4.25',25),(1189,'A','选项26',26),(1190,'B','选项2.26',26),(1191,'C','选项3.26',26),(1192,'D','选项4.26',26),(1193,'A','选项27',27),(1194,'B','选项2.27',27),(1195,'C','选项3.27',27),(1196,'D','选项4.27',27),(1197,'A','选项28',28),(1198,'B','选项2.28',28),(1199,'C','选项3.28',28),(1200,'D','选项4.28',28),(1201,'A','选项29',29),(1202,'B','选项2.29',29),(1203,'C','选项3.29',29),(1204,'D','选项4.29',29),(1205,'A','选项30',30),(1206,'B','选项2.30',30),(1207,'C','选项3.30',30),(1208,'D','选项4.30',30),(1209,'A','选项31',31),(1210,'B','选项2.31',31),(1211,'C','选项3.31',31),(1212,'D','选项4.31',31),(1213,'A','选项32',32),(1214,'B','选项2.32',32),(1215,'C','选项3.32',32),(1216,'D','选项4.32',32),(1217,'A','选项33',33),(1218,'B','选项2.33',33),(1219,'C','选项3.33',33),(1220,'D','选项4.33',33),(1221,'A','选项34',34),(1222,'B','选项2.34',34),(1223,'C','选项3.34',34),(1224,'D','选项4.34',34),(1225,'A','选项1',35),(1226,'B','选项2.1',35),(1227,'C','选项3.1',35),(1228,'D','选项4.1',35),(1229,'A','选项2',36),(1230,'B','选项2.2',36),(1231,'C','选项3.2',36),(1232,'D','选项4.2',36),(1233,'A','选项3',37),(1234,'B','选项2.3',37),(1235,'C','选项3.3',37),(1236,'D','选项4.3',37),(1237,'A','选项4',38),(1238,'B','选项2.4',38),(1239,'C','选项3.4',38),(1240,'D','选项4.4',38),(1241,'A','选项5',39),(1242,'B','选项2.5',39),(1243,'C','选项3.5',39),(1244,'D','选项4.5',39),(1245,'A','选项6',40),(1246,'B','选项2.6',40),(1247,'C','选项3.6',40),(1248,'D','选项4.6',40),(1249,'A','选项7',41),(1250,'B','选项2.7',41),(1251,'C','选项3.7',41),(1252,'D','选项4.7',41),(1253,'A','选项8',42),(1254,'B','选项2.8',42),(1255,'C','选项3.8',42),(1256,'D','选项4.8',42),(1257,'A','选项9',43),(1258,'B','选项2.9',43),(1259,'C','选项3.9',43),(1260,'D','选项4.9',43),(1261,'A','选项10',44),(1262,'B','选项2.10',44),(1263,'C','选项3.10',44),(1264,'D','选项4.10',44),(1265,'A','选项11',45),(1266,'B','选项2.11',45),(1267,'C','选项3.11',45),(1268,'D','选项4.11',45),(1269,'A','选项12',46),(1270,'B','选项2.12',46),(1271,'C','选项3.12',46),(1272,'D','选项4.12',46),(1273,'A','选项13',47),(1274,'B','选项2.13',47),(1275,'C','选项3.13',47),(1276,'D','选项4.13',47),(1277,'A','选项14',48),(1278,'B','选项2.14',48),(1279,'C','选项3.14',48),(1280,'D','选项4.14',48),(1281,'A','选项15',49),(1282,'B','选项2.15',49),(1283,'C','选项3.15',49),(1284,'D','选项4.15',49),(1285,'A','选项16',50),(1286,'B','选项2.16',50),(1287,'C','选项3.16',50),(1288,'D','选项4.16',50),(1289,'A','选项17',51),(1290,'B','选项2.17',51),(1291,'C','选项3.17',51),(1292,'D','选项4.17',51),(1293,'A','选项18',52),(1294,'B','选项2.18',52),(1295,'C','选项3.18',52),(1296,'D','选项4.18',52),(1297,'A','选项19',53),(1298,'B','选项2.19',53),(1299,'C','选项3.19',53),(1300,'D','选项4.19',53),(1301,'A','选项20',54),(1302,'B','选项2.20',54),(1303,'C','选项3.20',54),(1304,'D','选项4.20',54),(1305,'A','选项21',55),(1306,'B','选项2.21',55),(1307,'C','选项3.21',55),(1308,'D','选项4.21',55),(1309,'A','选项22',56),(1310,'B','选项2.22',56),(1311,'C','选项3.22',56),(1312,'D','选项4.22',56),(1313,'A','选项23',57),(1314,'B','选项2.23',57),(1315,'C','选项3.23',57),(1316,'D','选项4.23',57),(1317,'A','选项24',58),(1318,'B','选项2.24',58),(1319,'C','选项3.24',58),(1320,'D','选项4.24',58),(1321,'A','选项25',59),(1322,'B','选项2.25',59),(1323,'C','选项3.25',59),(1324,'D','选项4.25',59),(1325,'A','选项26',60),(1326,'B','选项2.26',60),(1327,'C','选项3.26',60),(1328,'D','选项4.26',60),(1329,'A','选项27',61),(1330,'B','选项2.27',61),(1331,'C','选项3.27',61),(1332,'D','选项4.27',61),(1333,'A','选项28',62),(1334,'B','选项2.28',62),(1335,'C','选项3.28',62),(1336,'D','选项4.28',62),(1337,'A','选项29',63),(1338,'B','选项2.29',63),(1339,'C','选项3.29',63),(1340,'D','选项4.29',63),(1341,'A','选项30',64),(1342,'B','选项2.30',64),(1343,'C','选项3.30',64),(1344,'D','选项4.30',64),(1345,'A','选项31',65),(1346,'B','选项2.31',65),(1347,'C','选项3.31',65),(1348,'D','选项4.31',65),(1349,'A','选项32',66),(1350,'B','选项2.32',66),(1351,'C','选项3.32',66),(1352,'D','选项4.32',66),(1353,'A','选项33',67),(1354,'B','选项2.33',67),(1355,'C','选项3.33',67),(1356,'D','选项4.33',67),(1357,'A','选项34',68),(1358,'B','选项2.34',68),(1359,'C','选项3.34',68),(1360,'D','选项4.34',68),(1361,'A','选项1',69),(1362,'B','选项2.1',69),(1363,'C','选项3.1',69),(1364,'D','选项4.1',69),(1365,'A','选项2',70),(1366,'B','选项2.2',70),(1367,'C','选项3.2',70),(1368,'D','选项4.2',70),(1369,'A','选项3',71),(1370,'B','选项2.3',71),(1371,'C','选项3.3',71),(1372,'D','选项4.3',71),(1373,'A','选项4',72),(1374,'B','选项2.4',72),(1375,'C','选项3.4',72),(1376,'D','选项4.4',72),(1377,'A','选项5',73),(1378,'B','选项2.5',73),(1379,'C','选项3.5',73),(1380,'D','选项4.5',73),(1381,'A','选项6',74),(1382,'B','选项2.6',74),(1383,'C','选项3.6',74),(1384,'D','选项4.6',74),(1385,'A','选项7',75),(1386,'B','选项2.7',75),(1387,'C','选项3.7',75),(1388,'D','选项4.7',75),(1389,'A','选项8',76),(1390,'B','选项2.8',76),(1391,'C','选项3.8',76),(1392,'D','选项4.8',76),(1393,'A','选项9',77),(1394,'B','选项2.9',77),(1395,'C','选项3.9',77),(1396,'D','选项4.9',77),(1397,'A','选项10',78),(1398,'B','选项2.10',78),(1399,'C','选项3.10',78),(1400,'D','选项4.10',78),(1401,'A','选项11',79),(1402,'B','选项2.11',79),(1403,'C','选项3.11',79),(1404,'D','选项4.11',79),(1405,'A','选项12',80),(1406,'B','选项2.12',80),(1407,'C','选项3.12',80),(1408,'D','选项4.12',80),(1409,'A','选项13',81),(1410,'B','选项2.13',81),(1411,'C','选项3.13',81),(1412,'D','选项4.13',81),(1413,'A','选项14',82),(1414,'B','选项2.14',82),(1415,'C','选项3.14',82),(1416,'D','选项4.14',82),(1417,'A','选项15',83),(1418,'B','选项2.15',83),(1419,'C','选项3.15',83),(1420,'D','选项4.15',83),(1421,'A','选项16',84),(1422,'B','选项2.16',84),(1423,'C','选项3.16',84),(1424,'D','选项4.16',84),(1425,'A','选项17',85),(1426,'B','选项2.17',85),(1427,'C','选项3.17',85),(1428,'D','选项4.17',85),(1429,'A','选项18',86),(1430,'B','选项2.18',86),(1431,'C','选项3.18',86),(1432,'D','选项4.18',86),(1433,'A','选项19',87),(1434,'B','选项2.19',87),(1435,'C','选项3.19',87),(1436,'D','选项4.19',87),(1437,'A','选项20',88),(1438,'B','选项2.20',88),(1439,'C','选项3.20',88),(1440,'D','选项4.20',88),(1441,'A','选项21',89),(1442,'B','选项2.21',89),(1443,'C','选项3.21',89),(1444,'D','选项4.21',89),(1445,'A','选项22',90),(1446,'B','选项2.22',90),(1447,'C','选项3.22',90),(1448,'D','选项4.22',90),(1449,'A','选项23',91),(1450,'B','选项2.23',91),(1451,'C','选项3.23',91),(1452,'D','选项4.23',91),(1453,'A','选项24',92),(1454,'B','选项2.24',92),(1455,'C','选项3.24',92),(1456,'D','选项4.24',92),(1457,'A','选项25',93),(1458,'B','选项2.25',93),(1459,'C','选项3.25',93),(1460,'D','选项4.25',93),(1461,'A','选项26',94),(1462,'B','选项2.26',94),(1463,'C','选项3.26',94),(1464,'D','选项4.26',94),(1465,'A','选项27',95),(1466,'B','选项2.27',95),(1467,'C','选项3.27',95),(1468,'D','选项4.27',95),(1469,'A','选项28',96),(1470,'B','选项2.28',96),(1471,'C','选项3.28',96),(1472,'D','选项4.28',96),(1473,'A','选项29',97),(1474,'B','选项2.29',97),(1475,'C','选项3.29',97),(1476,'D','选项4.29',97),(1477,'A','选项30',98),(1478,'B','选项2.30',98),(1479,'C','选项3.30',98),(1480,'D','选项4.30',98),(1481,'A','选项31',99),(1482,'B','选项2.31',99),(1483,'C','选项3.31',99),(1484,'D','选项4.31',99),(1485,'A','选项32',100),(1486,'B','选项2.32',100),(1487,'C','选项3.32',100),(1488,'D','选项4.32',100),(1489,'A','选项33',101),(1490,'B','选项2.33',101),(1491,'C','选项3.33',101),(1492,'D','选项4.33',101),(1493,'A','选项34',102),(1494,'B','选项2.34',102),(1495,'C','选项3.34',102),(1496,'D','选项4.34',102),(1497,'A','选项1',103),(1498,'B','选项2.1',103),(1499,'C','选项3.1',103),(1500,'D','选项4.1',103),(1501,'A','选项2',104),(1502,'B','选项2.2',104),(1503,'C','选项3.2',104),(1504,'D','选项4.2',104),(1505,'A','选项3',105),(1506,'B','选项2.3',105),(1507,'C','选项3.3',105),(1508,'D','选项4.3',105),(1509,'A','选项4',106),(1510,'B','选项2.4',106),(1511,'C','选项3.4',106),(1512,'D','选项4.4',106),(1513,'A','选项5',107),(1514,'B','选项2.5',107),(1515,'C','选项3.5',107),(1516,'D','选项4.5',107),(1517,'A','选项6',108),(1518,'B','选项2.6',108),(1519,'C','选项3.6',108),(1520,'D','选项4.6',108),(1521,'A','选项7',109),(1522,'B','选项2.7',109),(1523,'C','选项3.7',109),(1524,'D','选项4.7',109),(1525,'A','选项8',110),(1526,'B','选项2.8',110),(1527,'C','选项3.8',110),(1528,'D','选项4.8',110),(1529,'A','选项9',111),(1530,'B','选项2.9',111),(1531,'C','选项3.9',111),(1532,'D','选项4.9',111),(1533,'A','选项10',112),(1534,'B','选项2.10',112),(1535,'C','选项3.10',112),(1536,'D','选项4.10',112),(1537,'A','选项11',113),(1538,'B','选项2.11',113),(1539,'C','选项3.11',113),(1540,'D','选项4.11',113),(1541,'A','选项12',114),(1542,'B','选项2.12',114),(1543,'C','选项3.12',114),(1544,'D','选项4.12',114),(1545,'A','选项13',115),(1546,'B','选项2.13',115),(1547,'C','选项3.13',115),(1548,'D','选项4.13',115),(1549,'A','选项14',116),(1550,'B','选项2.14',116),(1551,'C','选项3.14',116),(1552,'D','选项4.14',116),(1553,'A','选项15',117),(1554,'B','选项2.15',117),(1555,'C','选项3.15',117),(1556,'D','选项4.15',117),(1557,'A','选项16',118),(1558,'B','选项2.16',118),(1559,'C','选项3.16',118),(1560,'D','选项4.16',118),(1561,'A','选项17',119),(1562,'B','选项2.17',119),(1563,'C','选项3.17',119),(1564,'D','选项4.17',119),(1565,'A','选项18',120),(1566,'B','选项2.18',120),(1567,'C','选项3.18',120),(1568,'D','选项4.18',120),(1569,'A','选项19',121),(1570,'B','选项2.19',121),(1571,'C','选项3.19',121),(1572,'D','选项4.19',121),(1573,'A','选项20',122),(1574,'B','选项2.20',122),(1575,'C','选项3.20',122),(1576,'D','选项4.20',122),(1577,'A','选项21',123),(1578,'B','选项2.21',123),(1579,'C','选项3.21',123),(1580,'D','选项4.21',123),(1581,'A','选项22',124),(1582,'B','选项2.22',124),(1583,'C','选项3.22',124),(1584,'D','选项4.22',124),(1585,'A','选项23',125),(1586,'B','选项2.23',125),(1587,'C','选项3.23',125),(1588,'D','选项4.23',125),(1589,'A','选项24',126),(1590,'B','选项2.24',126),(1591,'C','选项3.24',126),(1592,'D','选项4.24',126),(1593,'A','选项25',127),(1594,'B','选项2.25',127),(1595,'C','选项3.25',127),(1596,'D','选项4.25',127),(1597,'A','选项26',128),(1598,'B','选项2.26',128),(1599,'C','选项3.26',128),(1600,'D','选项4.26',128),(1601,'A','选项27',129),(1602,'B','选项2.27',129),(1603,'C','选项3.27',129),(1604,'D','选项4.27',129),(1605,'A','选项28',130),(1606,'B','选项2.28',130),(1607,'C','选项3.28',130),(1608,'D','选项4.28',130),(1609,'A','选项29',131),(1610,'B','选项2.29',131),(1611,'C','选项3.29',131),(1612,'D','选项4.29',131),(1613,'A','选项30',132),(1614,'B','选项2.30',132),(1615,'C','选项3.30',132),(1616,'D','选项4.30',132),(1617,'A','选项31',133),(1618,'B','选项2.31',133),(1619,'C','选项3.31',133),(1620,'D','选项4.31',133),(1621,'A','选项32',134),(1622,'B','选项2.32',134),(1623,'C','选项3.32',134),(1624,'D','选项4.32',134),(1625,'A','选项33',135),(1626,'B','选项2.33',135),(1627,'C','选项3.33',135),(1628,'D','选项4.33',135),(1629,'A','选项34',136),(1630,'B','选项2.34',136),(1631,'C','选项3.34',136),(1632,'D','选项4.34',136);

#
# Structure for table "questionbank"
#

DROP TABLE IF EXISTS `questionbank`;
CREATE TABLE `questionbank` (
  `qu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '题目ID',
  `qu_title` varchar(255) NOT NULL DEFAULT '' COMMENT '题干',
  `qu_answer` varchar(2) NOT NULL DEFAULT '' COMMENT '答案',
  `subjects_id` int(11) NOT NULL DEFAULT '0' COMMENT '科目ID',
  `qu_options` text,
  `note` varchar(255) DEFAULT '',
  `add_time` datetime DEFAULT NULL,
  `modify_time` datetime DEFAULT NULL,
  `is_visible` int(11) NOT NULL,
  PRIMARY KEY (`qu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='题库';

#
# Data for table "questionbank"
#

INSERT INTO `questionbank` VALUES (1,'星期','B',7,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',0),(2,'星期2','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(3,'星期3','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(4,'星期4','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(5,'星期5','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(6,'星期6','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(7,'星期7','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(8,'星期8','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(9,'星期9','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(10,'星期10','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(11,'星期11','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(12,'星期12','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(13,'星期13','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(14,'星期14','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(15,'星期15','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(16,'星期16','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(17,'星期17','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(18,'星期18','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(19,'星期19','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(20,'星期20','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(21,'星期21','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(22,'星期22','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(23,'星期23','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(24,'星期24','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(25,'星期25','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(26,'星期26','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(27,'星期27','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(28,'星期28','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(29,'星期29','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(30,'星期30','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(31,'星期31','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(32,'星期32','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(33,'星期33','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(34,'星期34','A',1,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(35,'星期1','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(36,'星期2','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(37,'星期3','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(38,'星期4','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(39,'星期5','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(40,'星期6','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(41,'星期7','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(42,'星期8','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(43,'星期9','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(44,'星期10','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(45,'星期11','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(46,'星期12','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(47,'星期13','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(48,'星期14','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(49,'星期15','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(50,'星期16','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(51,'星期17','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(52,'星期18','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(53,'星期19','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(54,'星期20','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(55,'星期21','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(56,'星期22','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(57,'星期23','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(58,'星期24','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(59,'星期25','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(60,'星期26','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(61,'星期27','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(62,'星期28','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(63,'星期29','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(64,'星期30','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(65,'星期31','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(66,'星期32','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(67,'星期33','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(68,'星期34','A',2,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(69,'星期1','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(70,'星期2','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(71,'星期3','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(72,'星期4','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(73,'星期5','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(74,'星期6','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(75,'星期7','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(76,'星期8','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(77,'星期9','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(78,'星期10','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(79,'星期11','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(80,'星期12','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(81,'星期13','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(82,'星期14','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(83,'星期15','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(84,'星期16','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(85,'星期17','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(86,'星期18','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(87,'星期19','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(88,'星期20','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(89,'星期21','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(90,'星期22','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(91,'星期23','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(92,'星期24','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(93,'星期25','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(94,'星期26','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(95,'星期27','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(96,'星期28','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(97,'星期29','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(98,'星期30','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(99,'星期31','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(100,'星期32','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(101,'星期33','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(102,'星期34','A',3,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(103,'星期1','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(104,'星期2','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(105,'星期3','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(106,'星期4','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(107,'星期5','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(108,'星期6','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(109,'星期7','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(110,'星期8','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(111,'星期9','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(112,'星期10','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(113,'星期11','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(114,'星期12','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(115,'星期13','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(116,'星期14','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(117,'星期15','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(118,'星期16','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(119,'星期17','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(120,'星期18','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(121,'星期19','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(122,'星期20','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(123,'星期21','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(124,'星期22','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(125,'星期23','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(126,'星期24','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(127,'星期25','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(128,'星期26','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(129,'星期27','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(130,'星期28','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(131,'星期29','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(132,'星期30','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(133,'星期31','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(134,'星期32','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(135,'星期33','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1),(136,'星期34','A',4,NULL,NULL,'2019-01-05 00:43:09','2019-01-05 00:43:09',1);

#
# Structure for table "score"
#

DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `sc_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL DEFAULT '0' COMMENT '学生ID',
  `sc_score` float DEFAULT NULL COMMENT '分数',
  `subjects_id` int(11) NOT NULL DEFAULT '0' COMMENT '科目ID',
  `examination_paper_id` int(11) NOT NULL DEFAULT '0' COMMENT '试卷id',
  `sc_test_time` date DEFAULT NULL COMMENT '考试时间',
  PRIMARY KEY (`sc_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='分数';

#
# Data for table "score"
#

INSERT INTO `score` VALUES (1,12,0,2,6,'2019-01-05'),(2,12,70,2,7,'2019-01-05'),(3,12,10,2,8,'2019-01-05'),(4,12,0,2,11,'2019-01-09'),(5,12,40,1,3,'2019-01-09');

#
# Structure for table "st_to_su"
#

DROP TABLE IF EXISTS `st_to_su`;
CREATE TABLE `st_to_su` (
  `sts_id` int(11) NOT NULL AUTO_INCREMENT,
  `st_id` int(11) NOT NULL DEFAULT '0' COMMENT '学生ID',
  `su_id` int(11) NOT NULL DEFAULT '0' COMMENT '科目ID',
  PRIMARY KEY (`sts_id`),
  KEY `st` (`st_id`),
  KEY `su` (`su_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='学生到科目';

#
# Data for table "st_to_su"
#

INSERT INTO `st_to_su` VALUES (1,6,7),(4,2,9),(5,12,2),(6,1,1),(7,1,3);

#
# Structure for table "student"
#

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `st_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL DEFAULT '0',
  `st_name` varchar(10) NOT NULL DEFAULT '',
  `st_pass` varchar(16) NOT NULL DEFAULT '',
  `note` varchar(255) DEFAULT '',
  `is_visible` int(11) NOT NULL,
  PRIMARY KEY (`st_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='学生';

#
# Data for table "student"
#

INSERT INTO `student` VALUES (1,169001401,'文雨豪','123456',NULL,1),(2,169001402,'王俊豪','123456',NULL,1),(3,169001403,'邓华','123456',NULL,1),(4,169001404,'刘泓余','123456',NULL,1),(5,169001405,'曾琪智','123456',NULL,1),(6,169001406,'赵强','123456',NULL,1),(7,169001407,'刘磊','123456',NULL,1),(8,169001408,'粟艳','123456',NULL,1),(9,169001409,'付杰豪','123456',NULL,1),(10,169001410,'舒桐','123456',NULL,1),(11,169001411,'董浩','123456',NULL,1),(12,169001412,'谭理林','123456',NULL,1),(13,169001413,'梁晋源','123456',NULL,1),(14,169001414,'李正乙','123456',NULL,1),(15,169001416,'古相熙','123456',NULL,1),(16,169001417,'许繁声','123456',NULL,1),(17,169001418,'吕威','123456',NULL,1),(18,169001421,'易玲','123456',NULL,1),(19,169001424,'李浩楠','123456',NULL,1),(20,169001425,'唐智文','123456',NULL,1),(21,169001426,'皮俊滔','123456',NULL,1),(22,169001427,'陈垚樨','123456',NULL,1),(23,169001428,'孙佳慧','123456',NULL,1),(24,169001429,'姜虹','123456',NULL,1);

#
# Structure for table "subject"
#

DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
  `su_id` int(11) NOT NULL AUTO_INCREMENT,
  `su_name` varchar(20) NOT NULL DEFAULT '' COMMENT '科目NAme',
  `note` varchar(255) DEFAULT '',
  `is_visible` int(11) NOT NULL,
  PRIMARY KEY (`su_id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COMMENT='科目';

#
# Data for table "subject"
#

INSERT INTO `subject` VALUES (1,'数学','121',1),(2,'语文','121',1),(3,'英语','121',1),(4,'物理','121',1),(5,'化学','121',1),(6,'高数','121',1),(7,'线性代数2',NULL,1),(8,'软件工程','121',1),(9,'java','121',1),(10,'c++','121',0),(11,'c#','121',1),(12,'mysql','121',1),(13,'星期1','121',1),(14,'星期2','121',1),(15,'星期3','121',1),(16,'星期4','121',1),(17,'星期5','121',1),(18,'星期6','121',1),(19,'星期7','121',1),(20,'星期8','121',1),(21,'星期9','121',1),(22,'星期10','121',1),(23,'星期11','121',1),(24,'星期12','121',1),(25,'星期13','121',1),(26,'星期14','121',1),(27,'星期15','121',1),(28,'星期16','121',1),(29,'星期17','121',1),(30,'星期18','121',1),(31,'星期19','121',1),(32,'星期20','121',1),(33,'星期21','121',1),(34,'星期22','121',1),(35,'星期23','121',1),(36,'星期24','121',1),(37,'星期25','121',1),(38,'星期26','121',1),(39,'星期27','121',1),(40,'星期28','121',1),(41,'星期29','121',1),(42,'星期30','121',1),(43,'星期31','121',1),(44,'星期32','121',1),(45,'星期33','121',1),(46,'星期34','121',1),(47,'星期1','121',1),(48,'星期2','121',1),(49,'星期3','121',1),(50,'星期4','121',1),(51,'星期5','121',1),(52,'星期6','121',1),(53,'星期7','121',1),(54,'星期8','121',1),(55,'星期9','121',1),(56,'星期10','121',1),(57,'星期11','121',1),(58,'星期12','121',1),(59,'星期13','121',1),(60,'星期14','121',1),(61,'星期15','121',1),(62,'星期16','121',1),(63,'星期17','121',1),(64,'星期18','121',1),(65,'星期19','121',1),(66,'星期20','121',1),(67,'星期21','121',1),(68,'星期22','121',1),(69,'星期23','121',1),(70,'星期24','121',1),(71,'星期25','121',1),(72,'星期26','121',1),(73,'星期27','121',1),(74,'星期28','121',1),(75,'星期29','121',1),(76,'星期30','121',1),(77,'星期31','121',1),(78,'星期32','121',1),(79,'星期33','121',1),(80,'星期34','121',1),(81,'星期1','121',1),(82,'星期2','121',1),(83,'星期3','121',1),(84,'星期4','121',1),(85,'星期5','121',1),(86,'星期6','121',1),(87,'星期7','121',1),(88,'星期8','121',1),(89,'星期9','121',1),(90,'星期10','121',1),(91,'星期11','121',1),(92,'星期12','121',1),(93,'星期13','121',1),(94,'星期14','121',1),(95,'星期15','121',1),(96,'星期16','121',1),(97,'星期17','121',1),(98,'星期18','121',1),(99,'星期19','121',1),(100,'星期20','121',1),(101,'星期21','121',1),(102,'星期22','121',1),(103,'星期23','121',1),(104,'星期24','121',1),(105,'星期25','121',1),(106,'星期26','121',1),(107,'星期27','121',1),(108,'星期28','121',1),(109,'星期29','121',1),(110,'星期30','121',1),(111,'星期31','121',1),(112,'星期32','121',1),(113,'星期33','121',1),(114,'星期34','121',1),(115,'星期1','121',1),(116,'星期2','121',1),(117,'星期3','121',1),(118,'星期4','121',1),(119,'星期5','121',1),(120,'星期6','121',1),(121,'星期7','121',1),(122,'星期8','121',1),(123,'星期9','121',1),(124,'星期10','121',1),(125,'星期11','121',1),(126,'星期12','121',1),(127,'星期13','121',1),(128,'星期14','121',1),(129,'星期15','121',1),(130,'星期16','121',1),(131,'星期17','121',1),(132,'星期18','121',1),(133,'星期19','121',1),(134,'星期20','121',1),(135,'星期21','121',1),(136,'星期22','121',1),(137,'星期23','121',1),(138,'星期24','121',1),(139,'星期25','121',1),(140,'星期26','121',1),(141,'星期27','121',1),(142,'星期28','121',1),(143,'星期29','121',1),(144,'星期30','121',1),(145,'星期31','121',1),(146,'星期32','121',1),(147,'星期33','121',1),(148,'星期34','121',1);

#
# Structure for table "teacher"
#

DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `te_id` int(11) NOT NULL AUTO_INCREMENT,
  `work_number` int(11) NOT NULL DEFAULT '0',
  `te_name` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `te_pass` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `subjects_id` int(11) NOT NULL DEFAULT '0' COMMENT '科目ID',
  `te_permission` int(11) NOT NULL DEFAULT '0' COMMENT '权限',
  PRIMARY KEY (`te_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='教师表';

#
# Data for table "teacher"
#

INSERT INTO `teacher` VALUES (3,170003,'张洪文','123456',3,1),(5,170005,'张欣竹','123456',2,1),(6,170006,'张欣阳','123456',6,1),(7,170007,'张刚军','123456',7,1),(8,170008,'张扬阳','123456',8,1),(9,170009,'张靖阳','123456',9,1),(10,170010,'张熙阳','123456',7,1),(11,170011,'张嘉萱','123456',7,1);