-
Notifications
You must be signed in to change notification settings - Fork 0
/
db.sql
141 lines (98 loc) · 55.6 KB
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 8.0.11 : Database - score_db
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`score_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `score_db`;
/*Table structure for table `exam_info` */
DROP TABLE IF EXISTS `exam_info`;
CREATE TABLE `exam_info` (
`info_id` int(11) NOT NULL AUTO_INCREMENT,
`exam_name` varchar(80) DEFAULT NULL,
`exam_date` varchar(20) DEFAULT NULL,
KEY `info_id` (`info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*Data for the table `exam_info` */
insert into `exam_info`(`info_id`,`exam_name`,`exam_date`) values (3,'期末考','大二上'),(1,'期末考','大一上'),(2,'期末考','大一下'),(4,'期末考','大二下');
/*Table structure for table `score` */
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`st_id` varchar(9) DEFAULT NULL,
`class_num` int(11) DEFAULT '1',
`sub_id` int(11) DEFAULT NULL,
`info_id` int(11) DEFAULT NULL,
`score` int(11) DEFAULT NULL,
`rank` int(11) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1393 DEFAULT CHARSET=utf8;
/*Data for the table `score` */
insert into `score`(`id`,`st_id`,`class_num`,`sub_id`,`info_id`,`score`,`rank`) values (1,'031799101',1,7,1,85,17),(2,'031799102',1,7,1,75,29),(3,'031799103',1,7,1,55,54),(4,'031799104',1,7,1,58,53),(5,'031799105',1,7,1,92,11),(6,'031799106',1,7,1,62,49),(7,'031799107',1,7,1,74,32),(8,'031799108',1,7,1,99,1),(9,'031799109',1,7,1,66,45),(10,'031799110',1,7,1,93,8),(11,'031799111',1,7,1,97,2),(12,'031799112',1,7,1,69,41),(13,'031799113',1,7,1,73,35),(14,'031799114',1,7,1,95,5),(15,'031799115',1,7,1,82,20),(16,'031799116',1,7,1,72,37),(17,'031799117',1,7,1,76,26),(18,'031799118',1,7,1,90,12),(19,'031799119',1,7,1,68,43),(20,'031799120',1,7,1,55,54),(21,'031799121',1,7,1,95,5),(22,'031799122',1,7,1,69,41),(23,'031799123',1,7,1,76,26),(24,'031799124',1,7,1,64,48),(25,'031799125',1,7,1,75,29),(26,'031799126',1,7,1,73,35),(27,'031799127',1,7,1,59,52),(28,'031799128',1,7,1,70,40),(29,'031799129',1,7,1,97,2),(30,'031799130',1,7,1,72,37),(31,'031799131',1,7,1,86,16),(32,'031799132',1,7,1,44,58),(33,'031799133',1,7,1,67,44),(34,'031799134',1,7,1,74,32),(35,'031799135',1,7,1,65,47),(36,'031799136',1,7,1,75,29),(37,'031799137',1,7,1,77,25),(38,'031799138',1,7,1,74,32),(39,'031799139',1,7,1,54,57),(40,'031799140',1,7,1,66,45),(41,'031799141',1,7,1,61,50),(42,'031799142',1,7,1,88,15),(43,'031799143',1,7,1,76,26),(44,'031799144',1,7,1,85,17),(45,'031799145',1,7,1,79,23),(46,'031799146',1,7,1,90,12),(47,'031799147',1,7,1,96,4),(48,'031799148',1,7,1,93,8),(49,'031799149',1,7,1,79,23),(50,'031799150',1,7,1,60,51),(51,'031799151',1,7,1,93,8),(52,'031799152',1,7,1,80,22),(53,'031799153',1,7,1,83,19),(54,'031799154',1,7,1,72,37),(55,'031799155',1,7,1,55,54),(56,'031799156',1,7,1,82,20),(57,'031799157',1,7,1,90,12),(58,'031799158',1,7,1,95,5),(59,'031799101',1,8,1,56,57),(60,'031799102',1,8,1,98,17),(61,'031799103',1,8,1,63,55),(62,'031799104',1,8,1,99,1),(63,'031799105',1,8,1,93,23),(64,'031799106',1,8,1,83,36),(65,'031799107',1,8,1,94,22),(66,'031799108',1,8,1,81,39),(67,'031799109',1,8,1,99,1),(68,'031799110',1,8,1,96,19),(69,'031799111',1,8,1,89,29),(70,'031799112',1,8,1,69,51),(71,'031799113',1,8,1,78,43),(72,'031799114',1,8,1,90,27),(73,'031799115',1,8,1,99,1),(74,'031799116',1,8,1,99,1),(75,'031799117',1,8,1,99,1),(76,'031799118',1,8,1,97,18),(77,'031799119',1,8,1,81,39),(78,'031799120',1,8,1,90,27),(79,'031799121',1,8,1,95,21),(80,'031799122',1,8,1,99,1),(81,'031799123',1,8,1,99,1),(82,'031799124',1,8,1,65,54),(83,'031799125',1,8,1,99,1),(84,'031799126',1,8,1,83,36),(85,'031799127',1,8,1,76,46),(86,'031799128',1,8,1,99,1),(87,'031799129',1,8,1,71,49),(88,'031799130',1,8,1,82,38),(89,'031799131',1,8,1,89,29),(90,'031799132',1,8,1,99,1),(91,'031799133',1,8,1,91,25),(92,'031799134',1,8,1,85,33),(93,'031799135',1,8,1,69,51),(94,'031799136',1,8,1,99,1),(95,'031799137',1,8,1,81,39),(96,'031799138',1,8,1,85,33),(97,'031799139',1,8,1,74,47),(98,'031799140',1,8,1,91,25),(99,'031799141',1,8,1,92,24),(100,'031799142',1,8,1,86,32),(101,'031799143',1,8,1,69,51),(102,'031799144',1,8,1,78,43),(103,'031799145',1,8,1,99,1),(104,'031799146',1,8,1,63,55),(105,'031799147',1,8,1,96,19),(106,'031799148',1,8,1,77,45),(107,'031799149',1,8,1,99,1),(108,'031799150',1,8,1,74,47),(109,'031799151',1,8,1,53,58),(110,'031799152',1,8,1,99,1),(111,'031799153',1,8,1,71,49),(112,'031799154',1,8,1,85,33),(113,'031799155',1,8,1,99,1),(114,'031799156',1,8,1,81,39),(115,'031799157',1,8,1,99,1),(116,'031799158',1,8,1,87,31),(117,'031799101',1,9,1,64,37),(118,'031799102',1,9,1,74,20),(119,'031799103',1,9,1,77,16),(120,'031799104',1,9,1,72,22),(121,'031799105',1,9,1,84,11),(122,'031799106',1,9,1,70,26),(123,'031799107',1,9,1,54,48),(124,'031799108',1,9,1,55,44),(125,'031799109',1,9,1,72,22),(126,'031799110',1,9,1,75,18),(127,'031799111',1,9,1,70,26),(128,'031799112',1,9,1,79,13),(129,'031799113',1,9,1,66,32),(130,'031799114',1,9,1,66,32),(131,'031799115',1,9,1,55,44),(132,'031799116',1,9,1,52,51),(133,'031799117',1,9,1,88,7),(134,'031799118',1,9,1,54,48),(135,'031799119',1,9,1,95,3),(136,'031799120',1,9,1,71,25),(137,'031799121',1,9,1,72,22),(138,'031799122',1,9,1,62,41),(139,'031799123',1,9,1,66,32),(140,'031799124',1,9,1,45,55),(141,'031799125',1,9,1,82,12),(142,'031799126',1,9,1,87,8),(143,'031799127',1,9,1,52,51),(144,'031799128',1,9,1,89,5),(145,'031799129',1,9,1,70,26),(146,'031799130',1,9,1,85,10),(147,'031799131',1,9,1,96,2),(148,'031799132',1,9,1,99,1),(149,'031799133',1,9,1,89,5),(150,'031799134',1,9,1,86,9),(151,'031799135',1,9,1,65,36),(152,'031799136',1,9,1,46,54),(153,'031799137',1,9,1,62,41),(154,'031799138',1,9,1,79,13),(155,'031799139',1,9,1,55,44),(156,'031799140',1,9,1,61,43),(157,'031799141',1,9,1,69,31),(158,'031799142',1,9,1,55,44),(159,'031799143',1,9,1,78,15),(160,'031799144',1,9,1,70,26),(161,'031799145',1,9,1,74,20),(162,'031799146',1,9,1,70,26),(163,'031799147',1,9,1,63,39),(164,'031799148',1,9,1,92,4),(165,'031799149',1,9,1,53,50),(166,'031799150',1,9,1,75,18),(167,'031799151',1,9,1,63,39),(168,'031799152',1,9,1,43,56),(169,'031799153',1,9,1,48,53),(170,'031799154',1,9,1,34,58),(171,'031799155',1,9,1,66,32),(172,'031799156',1,9,1,64,37),(173,'031799157',1,9,1,77,16),(174,'031799158',1,9,1,35,57),(175,'031799101',1,10,1,65,31),(176,'031799102',1,10,1,95,4),(177,'031799103',1,10,1,75,19),(178,'031799104',1,10,1,97,2),(179,'031799105',1,10,1,85,14),(180,'031799106',1,10,1,59,39),(181,'031799107',1,10,1,53,47),(182,'031799108',1,10,1,52,49),(183,'031799109',1,10,1,90,10),(184,'031799110',1,10,1,58,43),(185,'031799111',1,10,1,41,57),(186,'031799112',1,10,1,91,8),(187,'031799113',1,10,1,65,31),(188,'031799114',1,10,1,92,7),(189,'031799115',1,10,1,59,39),(190,'031799116',1,10,1,81,17),(191,'031799117',1,10,1,61,35),(192,'031799118',1,10,1,71,22),(193,'031799119',1,10,1,90,10),(194,'031799120',1,10,1,48,51),(195,'031799121',1,10,1,48,51),(196,'031799122',1,10,1,60,38),(197,'031799123',1,10,1,99,1),(198,'031799124',1,10,1,55,46),(199,'031799125',1,10,1,65,31),(200,'031799126',1,10,1,94,6),(201,'031799127',1,10,1,39,58),(202,'031799128',1,10,1,91,8),(203,'031799129',1,10,1,61,35),(204,'031799130',1,10,1,42,56),(205,'031799131',1,10,1,48,51),(206,'031799132',1,10,1,88,12),(207,'031799133',1,10,1,52,49),(208,'031799134',1,10,1,86,13),(209,'031799135',1,10,1,95,4),(210,'031799136',1,10,1,74,20),(211,'031799137',1,10,1,57,45),(212,'031799138',1,10,1,68,23),(213,'031799139',1,10,1,67,26),(214,'031799140',1,10,1,74,20),(215,'031799141',1,10,1,68,23),(216,'031799142',1,10,1,48,51),(217,'031799143',1,10,1,59,39),(218,'031799144',1,10,1,66,28),(219,'031799145',1,10,1,43,55),(220,'031799146',1,10,1,67,26),(221,'031799147',1,10,1,59,39),(222,'031799148',1,10,1,97,2),(223,'031799149',1,10,1,53,47),(224,'031799150',1,10,1,66,28),(225,'031799151',1,10,1,78,18),(226,'031799152',1,10,1,68,23),(227,'031799153',1,10,1,66,28),(228,'031799154',1,10,1,63,34),(229,'031799155',1,10,1,58,43),(230,'031799156',1,10,1,82,15),(231,'031799157',1,10,1,61,35),(232,'031799158',1,10,1,82,15),(233,'031799101',1,11,1,84,17),(234,'031799102',1,11,1,48,56),(235,'031799103',1,11,1,63,46),(236,'031799104',1,11,1,76,29),(237,'031799105',1,11,1,72,33),(238,'031799106',1,11,1,52,53),(239,'031799107',1,11,1,71,35),(240,'031799108',1,11,1,66,42),(241,'031799109',1,11,1,80,21),(242,'031799110',1,11,1,80,21),(243,'031799111',1,11,1,82,18),(244,'031799112',1,11,1,79,24),(245,'031799113',1,11,1,99,1),(246,'031799114',1,11,1,99,1),(247,'031799115',1,11,1,52,53),(248,'031799116',1,11,1,99,1),(249,'031799117',1,11,1,79,24),(250,'031799118',1,11,1,91,9),(251,'031799119',1,11,1,63,46),(252,'031799120',1,11,1,94,7),(253,'031799121',1,11,1,67,38),(254,'031799122',1,11,1,89,10),(255,'031799123',1,11,1,92,8),(256,'031799124',1,11,1,86,13),(257,'031799125',1,11,1,68,36),(258,'031799126',1,11,1,39,58),(259,'031799127',1,11,1,67,38),(260,'031799128',1,11,1,67,38),(261,'031799129',1,11,1,72,33),(262,'031799130',1,11,1,68,36),(263,'031799131',1,11,1,82,18),(264,'031799132',1,11,1,99,1),(265,'031799133',1,11,1,88,11),(266,'031799134',1,11,1,80,21),(267,'031799135',1,11,1,79,24),(268,'031799136',1,11,1,65,43),(269,'031799137',1,11,1,64,44),(270,'031799138',1,11,1,61,49),(271,'031799139',1,11,1,86,13),(272,'031799140',1,11,1,78,27),(273,'031799141',1,11,1,85,15),(274,'031799142',1,11,1,63,46),(275,'031799143',1,11,1,61,49),(276,'031799144',1,11,1,87,12),(277,'031799145',1,11,1,56,51),(278,'031799146',1,11,1,81,20),(279,'031799147',1,11,1,73,32),(280,'031799148',1,11,1,75,31),(281,'031799149',1,11,1,76,29),(282,'031799150',1,11,1,56,51),(283,'031799151',1,11,1,95,6),(284,'031799152',1,11,1,64,44),(285,'031799153',1,11,1,45,57),(286,'031799154',1,11,1,99,1),(287,'031799155',1,11,1,67,38),(288,'031799156',1,11,1,49,55),(289,'031799157',1,11,1,85,15),(290,'031799158',1,11,1,78,27),(291,'031799101',1,12,1,41,54),(292,'031799102',1,12,1,52,46),(293,'031799103',1,12,1,61,34),(294,'031799104',1,12,1,95,3),(295,'031799105',1,12,1,24,58),(296,'031799106',1,12,1,99,1),(297,'031799107',1,12,1,84,9),(298,'031799108',1,12,1,68,23),(299,'031799109',1,12,1,74,16),(300,'031799110',1,12,1,58,38),(301,'031799111',1,12,1,91,4),(302,'031799112',1,12,1,51,47),(303,'031799113',1,12,1,72,17),(304,'031799114',1,12,1,53,45),(305,'031799115',1,12,1,62,30),(306,'031799116',1,12,1,75,15),(307,'031799117',1,12,1,72,17),(308,'031799118',1,12,1,62,30),(309,'031799119',1,12,1,58,38),(310,'031799120',1,12,1,86,7),(311,'031799121',1,12,1,84,9),(312,'031799122',1,12,1,56,43),(313,'031799123',1,12,1,84,9),(314,'031799124',1,12,1,56,43),(315,'031799125',1,12,1,57,42),(316,'031799126',1,12,1,58,38),(317,'031799127',1,12,1,67,25),(318,'031799128',1,12,1,42,53),(319,'031799129',1,12,1,79,13),(320,'031799130',1,12,1,96,2),(321,'031799131',1,12,1,69,22),(322,'031799132',1,12,1,47,50),(323,'031799133',1,12,1,68,23),(324,'031799134',1,12,1,44,52),(325,'031799135',1,12,1,47,50),(326,'031799136',1,12,1,35,57),(327,'031799137',1,12,1,72,17),(328,'031799138',1,12,1,88,5),(329,'031799139',1,12,1,67,25),(330,'031799140',1,12,1,58,38),(331,'031799141',1,12,1,82,12),(332,'031799142',1,12,1,48,48),(333,'031799143',1,12,1,59,37),(334,'031799144',1,12,1,61,34),(335,'031799145',1,12,1,62,30),(336,'031799146',1,12,1,40,55),(337,'031799147',1,12,1,62,30),(338,'031799148',1,12,1,76,14),(339,'031799149',1,12,1,72,17),(340,'031799150',1,12,1,60,36),(341,'031799151',1,12,1,38,56),(342,'031799152',1,12,1,67,25),(343,'031799153',1,12,1,48,48),(344,'031799154',1,12,1,63,28),(345,'031799155',1,12,1,85,8),(346,'031799156',1,12,1,70,21),(347,'031799157',1,12,1,63,28),(348,'031799158',1,12,1,87,6),(349,'031799101',1,13,2,49,53),(350,'031799102',1,13,2,58,45),(351,'031799103',1,13,2,83,6),(352,'031799104',1,13,2,66,29),(353,'031799105',1,13,2,74,13),(354,'031799106',1,13,2,57,46),(355,'031799107',1,13,2,61,39),(356,'031799108',1,13,2,73,15),(357,'031799109',1,13,2,69,23),(358,'031799110',1,13,2,64,34),(359,'031799111',1,13,2,47,54),(360,'031799112',1,13,2,76,10),(361,'031799113',1,13,2,72,16),(362,'031799114',1,13,2,43,55),(363,'031799115',1,13,2,66,29),(364,'031799116',1,13,2,98,1),(365,'031799117',1,13,2,64,34),(366,'031799118',1,13,2,68,25),(367,'031799119',1,13,2,65,32),(368,'031799120',1,13,2,50,51),(369,'031799121',1,13,2,91,3),(370,'031799122',1,13,2,70,21),(371,'031799123',1,13,2,61,39),(372,'031799124',1,13,2,50,51),(373,'031799125',1,13,2,65,32),(374,'031799126',1,13,2,79,8),(375,'031799127',1,13,2,51,50),(376,'031799128',1,13,2,64,34),(377,'031799129',1,13,2,59,42),(378,'031799130',1,13,2,62,38),(379,'031799131',1,13,2,75,11),(380,'031799132',1,13,2,75,11),(381,'031799133',1,13,2,68,25),(382,'031799134',1,13,2,59,42),(383,'031799135',1,13,2,70,21),(384,'031799136',1,13,2,97,2),(385,'031799137',1,13,2,69,23),(386,'031799138',1,13,2,72,16),(387,'031799139',1,13,2,53,47),(388,'031799140',1,13,2,84,4),(389,'031799141',1,13,2,78,9),(390,'031799142',1,13,2,68,25),(391,'031799143',1,13,2,67,28),(392,'031799144',1,13,2,72,16),(393,'031799145',1,13,2,74,13),(394,'031799146',1,13,2,83,6),(395,'031799147',1,13,2,72,16),(396,'031799148',1,13,2,84,4),(397,'031799149',1,13,2,33,56),(398,'031799150',1,13,2,72,16),(399,'031799151',1,13,2,60,41),(400,'031799152',1,13,2,66,29),(401,'031799153',1,13,2,23,58),(402,'031799154',1,13,2,31,57),(403,'031799155',1,13,2,53,47),(404,'031799156',1,13,2,53,47),(405,'031799157',1,13,2,63,37),(406,'031799158',1,13,2,59,42),(407,'031799101',1,14,2,75,20),(408,'031799102',1,14,2,66,31),(409,'031799103',1,14,2,61,43),(410,'031799104',1,14,2,73,24),(411,'031799105',1,14,2,61,43),(412,'031799106',1,14,2,66,31),(413,'031799107',1,14,2,68,30),(414,'031799108',1,14,2,83,7),(415,'031799109',1,14,2,66,31),(416,'031799110',1,14,2,74,22),(417,'031799111',1,14,2,69,29),(418,'031799112',1,14,2,54,50),(419,'031799113',1,14,2,66,31),(420,'031799114',1,14,2,66,31),(421,'031799115',1,14,2,50,54),(422,'031799116',1,14,2,88,3),(423,'031799117',1,14,2,74,22),(424,'031799118',1,14,2,81,8),(425,'031799119',1,14,2,62,40),(426,'031799120',1,14,2,79,13),(427,'031799121',1,14,2,51,52),(428,'031799122',1,14,2,47,57),(429,'031799123',1,14,2,51,52),(430,'031799124',1,14,2,77,18),(431,'031799125',1,14,2,84,5),(432,'031799126',1,14,2,58,46),(433,'031799127',1,14,2,62,40),(434,'031799128',1,14,2,62,40),(435,'031799129',1,14,2,70,28),(436,'031799130',1,14,2,65,36),(437,'031799131',1,14,2,75,20),(438,'031799132',1,14,2,50,54),(439,'031799133',1,14,2,55,49),(440,'031799134',1,14,2,63,39),(441,'031799135',1,14,2,58,46),(442,'031799136',1,14,2,65,36),(443,'031799137',1,14,2,81,8),(444,'031799138',1,14,2,77,18),(445,'031799139',1,14,2,50,54),(446,'031799140',1,14,2,54,50),(447,'031799141',1,14,2,72,25),(448,'031799142',1,14,2,78,16),(449,'031799143',1,14,2,99,1),(450,'031799144',1,14,2,80,11),(451,'031799145',1,14,2,87,4),(452,'031799146',1,14,2,79,13),(453,'031799147',1,14,2,61,43),(454,'031799148',1,14,2,58,46),(455,'031799149',1,14,2,79,13),(456,'031799150',1,14,2,71,26),(457,'031799151',1,14,2,78,16),(458,'031799152',1,14,2,80,11),(459,'031799153',1,14,2,84,5),(460,'031799154',1,14,2,81,8),(461,'031799155',1,14,2,33,58),(462,'031799156',1,14,2,95,2),(463,'031799157',1,14,2,71,26),(464,'031799158',1,14,2,65,36),(465,'031799101',1,15,2,89,13),(466,'031799102',1,15,2,67,37),(467,'031799103',1,15,2,60,46),(468,'031799104',1,15,2,63,42),(469,'031799105',1,15,2,89,13),(470,'031799106',1,15,2,69,34),(471,'031799107',1,15,2,78,23),(472,'031799108',1,15,2,99,1),(473,'031799109',1,15,2,67,37),(474,'031799110',1,15,2,91,10),(475,'031799111',1,15,2,99,1),(476,'031799112',1,15,2,78,23),(477,'031799113',1,15,2,73,29),(478,'031799114',1,15,2,94,8),(479,'031799115',1,15,2,69,34),(480,'031799116',1,15,2,82,18),(481,'031799117',1,15,2,82,18),(482,'031799118',1,15,2,43,58),(483,'031799119',1,15,2,90,12),(484,'031799120',1,15,2,55,51),(485,'031799121',1,15,2,81,20),(486,'031799122',1,15,2,65,41),(487,'031799123',1,15,2,62,43),(488,'031799124',1,15,2,74,27),(489,'031799125',1,15,2,71,31),(490,'031799126',1,15,2,68,36),(491,'031799127',1,15,2,71,31),(492,'031799128',1,15,2,91,10),(493,'031799129',1,15,2,81,20),(494,'031799130',1,15,2,80,22),(495,'031799131',1,15,2,47,57),(496,'031799132',1,15,2,74,27),(497,'031799133',1,15,2,56,50),(498,'031799134',1,15,2,54,52),(499,'031799135',1,15,2,62,43),(500,'031799136',1,15,2,73,29),(501,'031799137',1,15,2,62,43),(502,'031799138',1,15,2,84,16),(503,'031799139',1,15,2,99,1),(504,'031799140',1,15,2,67,37),(505,'031799141',1,15,2,95,7),(506,'031799142',1,15,2,60,46),(507,'031799143',1,15,2,83,17),(508,'031799144',1,15,2,57,49),(509,'031799145',1,15,2,88,15),(510,'031799146',1,15,2,99,1),(511,'031799147',1,15,2,54,52),(512,'031799148',1,15,2,99,1),(513,'031799149',1,15,2,70,33),(514,'031799150',1,15,2,51,55),(515,'031799151',1,15,2,77,25),(516,'031799152',1,15,2,92,9),(517,'031799153',1,15,2,50,56),(518,'031799154',1,15,2,75,26),(519,'031799155',1,15,2,66,40),(520,'031799156',1,15,2,96,6),(521,'031799157',1,15,2,53,54),(522,'031799158',1,15,2,59,48),(523,'031799101',1,16,2,82,10),(524,'031799102',1,16,2,58,45),(525,'031799103',1,16,2,78,15),(526,'031799104',1,16,2,75,18),(527,'031799105',1,16,2,65,29),(528,'031799106',1,16,2,70,22),(529,'031799107',1,16,2,54,49),(530,'031799108',1,16,2,53,50),(531,'031799109',1,16,2,46,55),(532,'031799110',1,16,2,64,31),(533,'031799111',1,16,2,64,31),(534,'031799112',1,16,2,96,2),(535,'031799113',1,16,2,82,10),(536,'031799114',1,16,2,69,23),(537,'031799115',1,16,2,67,24),(538,'031799116',1,16,2,81,13),(539,'031799117',1,16,2,84,7),(540,'031799118',1,16,2,63,34),(541,'031799119',1,16,2,52,51),(542,'031799120',1,16,2,56,47),(543,'031799121',1,16,2,85,6),(544,'031799122',1,16,2,59,44),(545,'031799123',1,16,2,57,46),(546,'031799124',1,16,2,42,57),(547,'031799125',1,16,2,60,41),(548,'031799126',1,16,2,67,24),(549,'031799127',1,16,2,77,17),(550,'031799128',1,16,2,75,18),(551,'031799129',1,16,2,63,34),(552,'031799130',1,16,2,82,10),(553,'031799131',1,16,2,39,58),(554,'031799132',1,16,2,86,5),(555,'031799133',1,16,2,64,31),(556,'031799134',1,16,2,84,7),(557,'031799135',1,16,2,51,52),(558,'031799136',1,16,2,48,54),(559,'031799137',1,16,2,45,56),(560,'031799138',1,16,2,66,28),(561,'031799139',1,16,2,81,13),(562,'031799140',1,16,2,63,34),(563,'031799141',1,16,2,61,40),(564,'031799142',1,16,2,87,3),(565,'031799143',1,16,2,63,34),(566,'031799144',1,16,2,71,21),(567,'031799145',1,16,2,78,15),(568,'031799146',1,16,2,99,1),(569,'031799147',1,16,2,73,20),(570,'031799148',1,16,2,55,48),(571,'031799149',1,16,2,60,41),(572,'031799150',1,16,2,67,24),(573,'031799151',1,16,2,87,3),(574,'031799152',1,16,2,65,29),(575,'031799153',1,16,2,67,24),(576,'031799154',1,16,2,50,53),(577,'031799155',1,16,2,60,41),(578,'031799156',1,16,2,63,34),(579,'031799157',1,16,2,62,39),(580,'031799158',1,16,2,83,9),(581,'031799101',1,17,2,97,3),(582,'031799102',1,17,2,69,35),(583,'031799103',1,17,2,83,15),(584,'031799104',1,17,2,67,36),(585,'031799105',1,17,2,73,27),(586,'031799106',1,17,2,88,11),(587,'031799107',1,17,2,65,38),(588,'031799108',1,17,2,91,8),(589,'031799109',1,17,2,49,54),(590,'031799110',1,17,2,77,20),(591,'031799111',1,17,2,71,31),(592,'031799112',1,17,2,74,25),(593,'031799113',1,17,2,70,33),(594,'031799114',1,17,2,70,33),(595,'031799115',1,17,2,72,29),(596,'031799116',1,17,2,45,55),(597,'031799117',1,17,2,64,39),(598,'031799118',1,17,2,59,47),(599,'031799119',1,17,2,91,8),(600,'031799120',1,17,2,93,5),(601,'031799121',1,17,2,76,23),(602,'031799122',1,17,2,63,42),(603,'031799123',1,17,2,61,44),(604,'031799124',1,17,2,93,5),(605,'031799125',1,17,2,62,43),(606,'031799126',1,17,2,59,47),(607,'031799127',1,17,2,72,29),(608,'031799128',1,17,2,83,15),(609,'031799129',1,17,2,56,50),(610,'031799130',1,17,2,89,10),(611,'031799131',1,17,2,71,31),(612,'031799132',1,17,2,93,5),(613,'031799133',1,17,2,42,57),(614,'031799134',1,17,2,99,1),(615,'031799135',1,17,2,76,23),(616,'031799136',1,17,2,87,12),(617,'031799137',1,17,2,73,27),(618,'031799138',1,17,2,67,36),(619,'031799139',1,17,2,74,25),(620,'031799140',1,17,2,78,18),(621,'031799141',1,17,2,84,14),(622,'031799142',1,17,2,61,44),(623,'031799143',1,17,2,79,17),(624,'031799144',1,17,2,86,13),(625,'031799145',1,17,2,56,50),(626,'031799146',1,17,2,42,57),(627,'031799147',1,17,2,96,4),(628,'031799148',1,17,2,78,18),(629,'031799149',1,17,2,44,56),(630,'031799150',1,17,2,77,20),(631,'031799151',1,17,2,60,46),(632,'031799152',1,17,2,64,39),(633,'031799153',1,17,2,57,49),(634,'031799154',1,17,2,54,52),(635,'031799155',1,17,2,54,52),(636,'031799156',1,17,2,77,20),(637,'031799157',1,17,2,99,1),(638,'031799158',1,17,2,64,39),(639,'031799101',1,18,2,81,8),(640,'031799102',1,18,2,68,23),(641,'031799103',1,18,2,49,54),(642,'031799104',1,18,2,74,16),(643,'031799105',1,18,2,66,28),(644,'031799106',1,18,2,50,51),(645,'031799107',1,18,2,51,50),(646,'031799108',1,18,2,98,1),(647,'031799109',1,18,2,67,24),(648,'031799110',1,18,2,58,42),(649,'031799111',1,18,2,67,24),(650,'031799112',1,18,2,59,37),(651,'031799113',1,18,2,82,7),(652,'031799114',1,18,2,55,44),(653,'031799115',1,18,2,60,36),(654,'031799116',1,18,2,80,11),(655,'031799117',1,18,2,79,12),(656,'031799118',1,18,2,55,44),(657,'031799119',1,18,2,64,30),(658,'031799120',1,18,2,73,17),(659,'031799121',1,18,2,59,37),(660,'031799122',1,18,2,59,37),(661,'031799123',1,18,2,53,48),(662,'031799124',1,18,2,64,30),(663,'031799125',1,18,2,69,22),(664,'031799126',1,18,2,50,51),(665,'031799127',1,18,2,56,43),(666,'031799128',1,18,2,39,58),(667,'031799129',1,18,2,52,49),(668,'031799130',1,18,2,55,44),(669,'031799131',1,18,2,71,19),(670,'031799132',1,18,2,84,6),(671,'031799133',1,18,2,63,32),(672,'031799134',1,18,2,54,47),(673,'031799135',1,18,2,46,56),(674,'031799136',1,18,2,96,3),(675,'031799137',1,18,2,59,37),(676,'031799138',1,18,2,94,4),(677,'031799139',1,18,2,67,24),(678,'031799140',1,18,2,59,37),(679,'031799141',1,18,2,62,33),(680,'031799142',1,18,2,70,20),(681,'031799143',1,18,2,97,2),(682,'031799144',1,18,2,61,34),(683,'031799145',1,18,2,48,55),(684,'031799146',1,18,2,79,12),(685,'031799147',1,18,2,67,24),(686,'031799148',1,18,2,78,14),(687,'031799149',1,18,2,65,29),(688,'031799150',1,18,2,50,51),(689,'031799151',1,18,2,72,18),(690,'031799152',1,18,2,81,8),(691,'031799153',1,18,2,46,56),(692,'031799154',1,18,2,86,5),(693,'031799155',1,18,2,61,34),(694,'031799156',1,18,2,81,8),(695,'031799157',1,18,2,75,15),(696,'031799158',1,18,2,70,20),(697,'031799101',1,1,3,44,54),(698,'031799102',1,1,3,44,54),(699,'031799103',1,1,3,94,4),(700,'031799104',1,1,3,85,9),(701,'031799105',1,1,3,56,42),(702,'031799106',1,1,3,73,19),(703,'031799107',1,1,3,85,9),(704,'031799108',1,1,3,68,28),(705,'031799109',1,1,3,99,1),(706,'031799110',1,1,3,55,45),(707,'031799111',1,1,3,86,7),(708,'031799112',1,1,3,64,33),(709,'031799113',1,1,3,62,38),(710,'031799114',1,1,3,99,1),(711,'031799115',1,1,3,66,30),(712,'031799116',1,1,3,99,1),(713,'031799117',1,1,3,70,25),(714,'031799118',1,1,3,93,5),(715,'031799119',1,1,3,73,19),(716,'031799120',1,1,3,63,36),(717,'031799121',1,1,3,35,58),(718,'031799122',1,1,3,46,53),(719,'031799123',1,1,3,74,17),(720,'031799124',1,1,3,83,11),(721,'031799125',1,1,3,57,41),(722,'031799126',1,1,3,44,54),(723,'031799127',1,1,3,50,52),(724,'031799128',1,1,3,54,48),(725,'031799129',1,1,3,82,13),(726,'031799130',1,1,3,55,45),(727,'031799131',1,1,3,71,24),(728,'031799132',1,1,3,76,15),(729,'031799133',1,1,3,70,25),(730,'031799134',1,1,3,63,36),(731,'031799135',1,1,3,82,13),(732,'031799136',1,1,3,83,11),(733,'031799137',1,1,3,64,33),(734,'031799138',1,1,3,64,33),(735,'031799139',1,1,3,55,45),(736,'031799140',1,1,3,89,6),(737,'031799141',1,1,3,65,32),(738,'031799142',1,1,3,56,42),(739,'031799143',1,1,3,73,19),(740,'031799144',1,1,3,52,51),(741,'031799145',1,1,3,72,23),(742,'031799146',1,1,3,62,38),(743,'031799147',1,1,3,40,57),(744,'031799148',1,1,3,68,28),(745,'031799149',1,1,3,56,42),(746,'031799150',1,1,3,66,30),(747,'031799151',1,1,3,73,19),(748,'031799152',1,1,3,61,40),(749,'031799153',1,1,3,70,25),(750,'031799154',1,1,3,75,16),(751,'031799155',1,1,3,86,7),(752,'031799156',1,1,3,74,17),(753,'031799157',1,1,3,53,49),(754,'031799158',1,1,3,53,49),(755,'031799101',1,2,3,58,54),(756,'031799102',1,2,3,86,13),(757,'031799103',1,2,3,99,1),(758,'031799104',1,2,3,81,23),(759,'031799105',1,2,3,99,1),(760,'031799106',1,2,3,76,35),(761,'031799107',1,2,3,55,56),(762,'031799108',1,2,3,70,41),(763,'031799109',1,2,3,81,23),(764,'031799110',1,2,3,56,55),(765,'031799111',1,2,3,85,15),(766,'031799112',1,2,3,71,40),(767,'031799113',1,2,3,66,45),(768,'031799114',1,2,3,99,1),(769,'031799115',1,2,3,84,16),(770,'031799116',1,2,3,62,49),(771,'031799117',1,2,3,99,1),(772,'031799118',1,2,3,81,23),(773,'031799119',1,2,3,83,18),(774,'031799120',1,2,3,75,36),(775,'031799121',1,2,3,89,10),(776,'031799122',1,2,3,79,32),(777,'031799123',1,2,3,83,18),(778,'031799124',1,2,3,88,11),(779,'031799125',1,2,3,80,28),(780,'031799126',1,2,3,80,28),(781,'031799127',1,2,3,93,9),(782,'031799128',1,2,3,83,18),(783,'031799129',1,2,3,73,37),(784,'031799130',1,2,3,99,1),(785,'031799131',1,2,3,98,8),(786,'031799132',1,2,3,80,28),(787,'031799133',1,2,3,59,51),(788,'031799134',1,2,3,84,16),(789,'031799135',1,2,3,67,43),(790,'031799136',1,2,3,82,22),(791,'031799137',1,2,3,63,48),(792,'031799138',1,2,3,87,12),(793,'031799139',1,2,3,72,39),(794,'031799140',1,2,3,59,51),(795,'031799141',1,2,3,99,1),(796,'031799142',1,2,3,65,47),(797,'031799143',1,2,3,99,1),(798,'031799144',1,2,3,38,58),(799,'031799145',1,2,3,70,41),(800,'031799146',1,2,3,80,28),(801,'031799147',1,2,3,66,45),(802,'031799148',1,2,3,73,37),(803,'031799149',1,2,3,59,51),(804,'031799150',1,2,3,81,23),(805,'031799151',1,2,3,79,32),(806,'031799152',1,2,3,52,57),(807,'031799153',1,2,3,86,13),(808,'031799154',1,2,3,81,23),(809,'031799155',1,2,3,67,43),(810,'031799156',1,2,3,62,49),(811,'031799157',1,2,3,83,18),(812,'031799158',1,2,3,79,32),(813,'031799101',1,3,3,99,1),(814,'031799102',1,3,3,96,5),(815,'031799103',1,3,3,98,4),(816,'031799104',1,3,3,74,26),(817,'031799105',1,3,3,55,50),(818,'031799106',1,3,3,60,45),(819,'031799107',1,3,3,89,10),(820,'031799108',1,3,3,63,41),(821,'031799109',1,3,3,79,19),(822,'031799110',1,3,3,85,13),(823,'031799111',1,3,3,77,22),(824,'031799112',1,3,3,94,7),(825,'031799113',1,3,3,99,1),(826,'031799114',1,3,3,72,28),(827,'031799115',1,3,3,68,34),(828,'031799116',1,3,3,65,38),(829,'031799117',1,3,3,82,16),(830,'031799118',1,3,3,69,32),(831,'031799119',1,3,3,47,57),(832,'031799120',1,3,3,58,48),(833,'031799121',1,3,3,67,36),(834,'031799122',1,3,3,54,51),(835,'031799123',1,3,3,66,37),(836,'031799124',1,3,3,99,1),(837,'031799125',1,3,3,56,49),(838,'031799126',1,3,3,75,25),(839,'031799127',1,3,3,88,11),(840,'031799128',1,3,3,93,8),(841,'031799129',1,3,3,46,58),(842,'031799130',1,3,3,79,19),(843,'031799131',1,3,3,84,14),(844,'031799132',1,3,3,64,39),(845,'031799133',1,3,3,70,30),(846,'031799134',1,3,3,70,30),(847,'031799135',1,3,3,79,19),(848,'031799136',1,3,3,48,56),(849,'031799137',1,3,3,71,29),(850,'031799138',1,3,3,95,6),(851,'031799139',1,3,3,83,15),(852,'031799140',1,3,3,64,39),(853,'031799141',1,3,3,54,51),(854,'031799142',1,3,3,60,45),(855,'031799143',1,3,3,88,11),(856,'031799144',1,3,3,76,23),(857,'031799145',1,3,3,90,9),(858,'031799146',1,3,3,68,34),(859,'031799147',1,3,3,61,43),(860,'031799148',1,3,3,82,16),(861,'031799149',1,3,3,69,32),(862,'031799150',1,3,3,49,55),(863,'031799151',1,3,3,62,42),(864,'031799152',1,3,3,54,51),(865,'031799153',1,3,3,50,54),(866,'031799154',1,3,3,60,45),(867,'031799155',1,3,3,74,26),(868,'031799156',1,3,3,76,23),(869,'031799157',1,3,3,61,43),(870,'031799158',1,3,3,80,18),(871,'031799101',1,4,3,99,1),(872,'031799102',1,4,3,45,51),(873,'031799103',1,4,3,67,33),(874,'031799104',1,4,3,40,55),(875,'031799105',1,4,3,89,7),(876,'031799106',1,4,3,75,24),(877,'031799107',1,4,3,73,28),(878,'031799108',1,4,3,75,24),(879,'031799109',1,4,3,61,39),(880,'031799110',1,4,3,99,1),(881,'031799111',1,4,3,67,33),(882,'031799112',1,4,3,60,42),(883,'031799113',1,4,3,99,1),(884,'031799114',1,4,3,77,19),(885,'031799115',1,4,3,67,33),(886,'031799116',1,4,3,82,12),(887,'031799117',1,4,3,78,17),(888,'031799118',1,4,3,30,58),(889,'031799119',1,4,3,99,1),(890,'031799120',1,4,3,78,17),(891,'031799121',1,4,3,76,21),(892,'031799122',1,4,3,75,24),(893,'031799123',1,4,3,61,39),(894,'031799124',1,4,3,72,30),(895,'031799125',1,4,3,76,21),(896,'031799126',1,4,3,96,6),(897,'031799127',1,4,3,59,43),(898,'031799128',1,4,3,49,50),(899,'031799129',1,4,3,36,57),(900,'031799130',1,4,3,76,21),(901,'031799131',1,4,3,77,19),(902,'031799132',1,4,3,64,36),(903,'031799133',1,4,3,53,47),(904,'031799134',1,4,3,56,45),(905,'031799135',1,4,3,53,47),(906,'031799136',1,4,3,88,8),(907,'031799137',1,4,3,41,53),(908,'031799138',1,4,3,55,46),(909,'031799139',1,4,3,37,56),(910,'031799140',1,4,3,72,30),(911,'031799141',1,4,3,81,13),(912,'031799142',1,4,3,72,30),(913,'031799143',1,4,3,43,52),(914,'031799144',1,4,3,51,49),(915,'031799145',1,4,3,80,14),(916,'031799146',1,4,3,80,14),(917,'031799147',1,4,3,64,36),(918,'031799148',1,4,3,80,14),(919,'031799149',1,4,3,62,38),(920,'031799150',1,4,3,99,1),(921,'031799151',1,4,3,88,8),(922,'031799152',1,4,3,41,53),(923,'031799153',1,4,3,75,24),(924,'031799154',1,4,3,88,8),(925,'031799155',1,4,3,73,28),(926,'031799156',1,4,3,85,11),(927,'031799157',1,4,3,61,39),(928,'031799158',1,4,3,58,44),(929,'031799101',1,5,3,66,55),(930,'031799102',1,5,3,89,26),(931,'031799103',1,5,3,76,46),(932,'031799104',1,5,3,94,16),(933,'031799105',1,5,3,68,52),(934,'031799106',1,5,3,73,50),(935,'031799107',1,5,3,97,13),(936,'031799108',1,5,3,78,43),(937,'031799109',1,5,3,99,1),(938,'031799110',1,5,3,68,52),(939,'031799111',1,5,3,85,34),(940,'031799112',1,5,3,88,28),(941,'031799113',1,5,3,69,51),(942,'031799114',1,5,3,81,41),(943,'031799115',1,5,3,90,24),(944,'031799116',1,5,3,67,54),(945,'031799117',1,5,3,99,1),(946,'031799118',1,5,3,75,48),(947,'031799119',1,5,3,86,32),(948,'031799120',1,5,3,99,1),(949,'031799121',1,5,3,85,34),(950,'031799122',1,5,3,58,58),(951,'031799123',1,5,3,83,39),(952,'031799124',1,5,3,99,1),(953,'031799125',1,5,3,87,30),(954,'031799126',1,5,3,92,21),(955,'031799127',1,5,3,86,32),(956,'031799128',1,5,3,66,55),(957,'031799129',1,5,3,94,16),(958,'031799130',1,5,3,96,15),(959,'031799131',1,5,3,93,18),(960,'031799132',1,5,3,99,1),(961,'031799133',1,5,3,77,44),(962,'031799134',1,5,3,99,1),(963,'031799135',1,5,3,99,1),(964,'031799136',1,5,3,84,36),(965,'031799137',1,5,3,91,23),(966,'031799138',1,5,3,75,48),(967,'031799139',1,5,3,77,44),(968,'031799140',1,5,3,76,46),(969,'031799141',1,5,3,88,28),(970,'031799142',1,5,3,99,1),(971,'031799143',1,5,3,84,36),(972,'031799144',1,5,3,92,21),(973,'031799145',1,5,3,99,1),(974,'031799146',1,5,3,99,1),(975,'031799147',1,5,3,93,18),(976,'031799148',1,5,3,61,57),(977,'031799149',1,5,3,89,26),(978,'031799150',1,5,3,93,18),(979,'031799151',1,5,3,87,30),(980,'031799152',1,5,3,99,1),(981,'031799153',1,5,3,97,13),(982,'031799154',1,5,3,90,24),(983,'031799155',1,5,3,83,39),(984,'031799156',1,5,3,81,41),(985,'031799157',1,5,3,84,36),(986,'031799158',1,5,3,98,12),(987,'031799101',1,6,3,59,57),(988,'031799102',1,6,3,97,7),(989,'031799103',1,6,3,69,44),(990,'031799104',1,6,3,62,55),(991,'031799105',1,6,3,74,36),(992,'031799106',1,6,3,56,58),(993,'031799107',1,6,3,74,36),(994,'031799108',1,6,3,84,21),(995,'031799109',1,6,3,91,11),(996,'031799110',1,6,3,74,36),(997,'031799111',1,6,3,67,46),(998,'031799112',1,6,3,75,33),(999,'031799113',1,6,3,83,23),(1000,'031799114',1,6,3,86,16),(1001,'031799115',1,6,3,77,28),(1002,'031799116',1,6,3,99,1),(1003,'031799117',1,6,3,63,53),(1004,'031799118',1,6,3,75,33),(1005,'031799119',1,6,3,84,21),(1006,'031799120',1,6,3,69,44),(1007,'031799121',1,6,3,72,43),(1008,'031799122',1,6,3,90,13),(1009,'031799123',1,6,3,80,24),(1010,'031799124',1,6,3,73,40),(1011,'031799125',1,6,3,99,1),(1012,'031799126',1,6,3,99,1),(1013,'031799127',1,6,3,76,29),(1014,'031799128',1,6,3,73,40),(1015,'031799129',1,6,3,93,8),(1016,'031799130',1,6,3,74,36),(1017,'031799131',1,6,3,60,56),(1018,'031799132',1,6,3,86,16),(1019,'031799133',1,6,3,66,47),(1020,'031799134',1,6,3,76,29),(1021,'031799135',1,6,3,79,26),(1022,'031799136',1,6,3,86,16),(1023,'031799137',1,6,3,91,11),(1024,'031799138',1,6,3,80,24),(1025,'031799139',1,6,3,76,29),(1026,'031799140',1,6,3,87,15),(1027,'031799141',1,6,3,92,10),(1028,'031799142',1,6,3,64,51),(1029,'031799143',1,6,3,73,40),(1030,'031799144',1,6,3,65,49),(1031,'031799145',1,6,3,64,51),(1032,'031799146',1,6,3,63,53),(1033,'031799147',1,6,3,89,14),(1034,'031799148',1,6,3,65,49),(1035,'031799149',1,6,3,99,1),(1036,'031799150',1,6,3,99,1),(1037,'031799151',1,6,3,99,1),(1038,'031799152',1,6,3,93,8),(1039,'031799153',1,6,3,76,29),(1040,'031799154',1,6,3,85,19),(1041,'031799155',1,6,3,85,19),(1042,'031799156',1,6,3,66,47),(1043,'031799157',1,6,3,75,33),(1044,'031799158',1,6,3,79,26),(1045,'031799101',1,19,4,72,27),(1046,'031799102',1,19,4,74,22),(1047,'031799103',1,19,4,66,40),(1048,'031799104',1,19,4,89,4),(1049,'031799105',1,19,4,71,29),(1050,'031799106',1,19,4,86,8),(1051,'031799107',1,19,4,82,14),(1052,'031799108',1,19,4,87,6),(1053,'031799109',1,19,4,86,8),(1054,'031799110',1,19,4,84,11),(1055,'031799111',1,19,4,70,32),(1056,'031799112',1,19,4,67,38),(1057,'031799113',1,19,4,54,51),(1058,'031799114',1,19,4,87,6),(1059,'031799115',1,19,4,63,42),(1060,'031799116',1,19,4,77,17),(1061,'031799117',1,19,4,49,53),(1062,'031799118',1,19,4,70,32),(1063,'031799119',1,19,4,96,1),(1064,'031799120',1,19,4,70,32),(1065,'031799121',1,19,4,57,47),(1066,'031799122',1,19,4,60,45),(1067,'031799123',1,19,4,43,56),(1068,'031799124',1,19,4,48,55),(1069,'031799125',1,19,4,61,44),(1070,'031799126',1,19,4,74,22),(1071,'031799127',1,19,4,77,17),(1072,'031799128',1,19,4,73,25),(1073,'031799129',1,19,4,74,22),(1074,'031799130',1,19,4,76,21),(1075,'031799131',1,19,4,69,37),(1076,'031799132',1,19,4,84,11),(1077,'031799133',1,19,4,83,13),(1078,'031799134',1,19,4,71,29),(1079,'031799135',1,19,4,89,4),(1080,'031799136',1,19,4,91,2),(1081,'031799137',1,19,4,36,58),(1082,'031799138',1,19,4,73,25),(1083,'031799139',1,19,4,72,27),(1084,'031799140',1,19,4,63,42),(1085,'031799141',1,19,4,41,57),(1086,'031799142',1,19,4,70,32),(1087,'031799143',1,19,4,79,15),(1088,'031799144',1,19,4,56,49),(1089,'031799145',1,19,4,85,10),(1090,'031799146',1,19,4,50,52),(1091,'031799147',1,19,4,91,2),(1092,'031799148',1,19,4,55,50),(1093,'031799149',1,19,4,67,38),(1094,'031799150',1,19,4,78,16),(1095,'031799151',1,19,4,60,45),(1096,'031799152',1,19,4,64,41),(1097,'031799153',1,19,4,71,29),(1098,'031799154',1,19,4,57,47),(1099,'031799155',1,19,4,77,17),(1100,'031799156',1,19,4,77,17),(1101,'031799157',1,19,4,70,32),(1102,'031799158',1,19,4,49,53),(1103,'031799101',1,20,4,92,17),(1104,'031799102',1,20,4,83,26),(1105,'031799103',1,20,4,72,48),(1106,'031799104',1,20,4,81,33),(1107,'031799105',1,20,4,87,22),(1108,'031799106',1,20,4,50,58),(1109,'031799107',1,20,4,68,49),(1110,'031799108',1,20,4,76,43),(1111,'031799109',1,20,4,99,1),(1112,'031799110',1,20,4,85,24),(1113,'031799111',1,20,4,99,1),(1114,'031799112',1,20,4,99,1),(1115,'031799113',1,20,4,79,37),(1116,'031799114',1,20,4,60,53),(1117,'031799115',1,20,4,93,16),(1118,'031799116',1,20,4,91,19),(1119,'031799117',1,20,4,97,11),(1120,'031799118',1,20,4,80,35),(1121,'031799119',1,20,4,51,56),(1122,'031799120',1,20,4,79,37),(1123,'031799121',1,20,4,55,55),(1124,'031799122',1,20,4,75,46),(1125,'031799123',1,20,4,92,17),(1126,'031799124',1,20,4,79,37),(1127,'031799125',1,20,4,96,13),(1128,'031799126',1,20,4,95,14),(1129,'031799127',1,20,4,76,43),(1130,'031799128',1,20,4,87,22),(1131,'031799129',1,20,4,83,26),(1132,'031799130',1,20,4,83,26),(1133,'031799131',1,20,4,81,33),(1134,'031799132',1,20,4,76,43),(1135,'031799133',1,20,4,51,56),(1136,'031799134',1,20,4,91,19),(1137,'031799135',1,20,4,94,15),(1138,'031799136',1,20,4,62,52),(1139,'031799137',1,20,4,99,1),(1140,'031799138',1,20,4,65,51),(1141,'031799139',1,20,4,90,21),(1142,'031799140',1,20,4,78,42),(1143,'031799141',1,20,4,97,11),(1144,'031799142',1,20,4,99,1),(1145,'031799143',1,20,4,82,31),(1146,'031799144',1,20,4,74,47),(1147,'031799145',1,20,4,56,54),(1148,'031799146',1,20,4,99,1),(1149,'031799147',1,20,4,67,50),(1150,'031799148',1,20,4,99,1),(1151,'031799149',1,20,4,99,1),(1152,'031799150',1,20,4,84,25),(1153,'031799151',1,20,4,82,31),(1154,'031799152',1,20,4,99,1),(1155,'031799153',1,20,4,83,26),(1156,'031799154',1,20,4,79,37),(1157,'031799155',1,20,4,83,26),(1158,'031799156',1,20,4,79,37),(1159,'031799157',1,20,4,99,1),(1160,'031799158',1,20,4,80,35),(1161,'031799101',1,21,4,82,19),(1162,'031799102',1,21,4,80,21),(1163,'031799103',1,21,4,79,23),(1164,'031799104',1,21,4,38,58),(1165,'031799105',1,21,4,95,4),(1166,'031799106',1,21,4,75,28),(1167,'031799107',1,21,4,91,6),(1168,'031799108',1,21,4,80,21),(1169,'031799109',1,21,4,44,57),(1170,'031799110',1,21,4,78,24),(1171,'031799111',1,21,4,97,2),(1172,'031799112',1,21,4,87,14),(1173,'031799113',1,21,4,83,17),(1174,'031799114',1,21,4,77,26),(1175,'031799115',1,21,4,71,38),(1176,'031799116',1,21,4,70,39),(1177,'031799117',1,21,4,86,15),(1178,'031799118',1,21,4,75,28),(1179,'031799119',1,21,4,82,19),(1180,'031799120',1,21,4,75,28),(1181,'031799121',1,21,4,70,39),(1182,'031799122',1,21,4,72,37),(1183,'031799123',1,21,4,62,45),(1184,'031799124',1,21,4,63,44),(1185,'031799125',1,21,4,99,1),(1186,'031799126',1,21,4,51,55),(1187,'031799127',1,21,4,75,28),(1188,'031799128',1,21,4,65,43),(1189,'031799129',1,21,4,59,50),(1190,'031799130',1,21,4,91,6),(1191,'031799131',1,21,4,89,12),(1192,'031799132',1,21,4,76,27),(1193,'031799133',1,21,4,73,35),(1194,'031799134',1,21,4,59,50),(1195,'031799135',1,21,4,96,3),(1196,'031799136',1,21,4,95,4),(1197,'031799137',1,21,4,83,17),(1198,'031799138',1,21,4,68,42),(1199,'031799139',1,21,4,91,6),(1200,'031799140',1,21,4,62,45),(1201,'031799141',1,21,4,60,49),(1202,'031799142',1,21,4,56,53),(1203,'031799143',1,21,4,89,12),(1204,'031799144',1,21,4,58,52),(1205,'031799145',1,21,4,61,47),(1206,'031799146',1,21,4,74,33),(1207,'031799147',1,21,4,78,24),(1208,'031799148',1,21,4,74,33),(1209,'031799149',1,21,4,70,39),(1210,'031799150',1,21,4,61,47),(1211,'031799151',1,21,4,75,28),(1212,'031799152',1,21,4,91,6),(1213,'031799153',1,21,4,91,6),(1214,'031799154',1,21,4,73,35),(1215,'031799155',1,21,4,45,56),(1216,'031799156',1,21,4,52,54),(1217,'031799157',1,21,4,91,6),(1218,'031799158',1,21,4,84,16),(1219,'031799101',1,22,4,61,34),(1220,'031799102',1,22,4,63,32),(1221,'031799103',1,22,4,71,22),(1222,'031799104',1,22,4,51,49),(1223,'031799105',1,22,4,61,34),(1224,'031799106',1,22,4,52,48),(1225,'031799107',1,22,4,76,11),(1226,'031799108',1,22,4,73,17),(1227,'031799109',1,22,4,79,9),(1228,'031799110',1,22,4,66,30),(1229,'031799111',1,22,4,55,44),(1230,'031799112',1,22,4,63,32),(1231,'031799113',1,22,4,58,40),(1232,'031799114',1,22,4,53,45),(1233,'031799115',1,22,4,31,57),(1234,'031799116',1,22,4,71,22),(1235,'031799117',1,22,4,57,43),(1236,'031799118',1,22,4,41,54),(1237,'031799119',1,22,4,64,31),(1238,'031799120',1,22,4,53,45),(1239,'031799121',1,22,4,75,12),(1240,'031799122',1,22,4,72,21),(1241,'031799123',1,22,4,61,34),(1242,'031799124',1,22,4,53,45),(1243,'031799125',1,22,4,73,17),(1244,'031799126',1,22,4,58,40),(1245,'031799127',1,22,4,82,7),(1246,'031799128',1,22,4,73,17),(1247,'031799129',1,22,4,84,3),(1248,'031799130',1,22,4,73,17),(1249,'031799131',1,22,4,99,1),(1250,'031799132',1,22,4,79,9),(1251,'031799133',1,22,4,67,29),(1252,'031799134',1,22,4,71,22),(1253,'031799135',1,22,4,48,51),(1254,'031799136',1,22,4,61,34),(1255,'031799137',1,22,4,84,3),(1256,'031799138',1,22,4,24,58),(1257,'031799139',1,22,4,71,22),(1258,'031799140',1,22,4,68,26),(1259,'031799141',1,22,4,60,39),(1260,'031799142',1,22,4,74,14),(1261,'031799143',1,22,4,92,2),(1262,'031799144',1,22,4,84,3),(1263,'031799145',1,22,4,68,26),(1264,'031799146',1,22,4,41,54),(1265,'031799147',1,22,4,33,56),(1266,'031799148',1,22,4,48,51),(1267,'031799149',1,22,4,83,6),(1268,'031799150',1,22,4,61,34),(1269,'031799151',1,22,4,58,40),(1270,'031799152',1,22,4,74,14),(1271,'031799153',1,22,4,68,26),(1272,'031799154',1,22,4,74,14),(1273,'031799155',1,22,4,51,49),(1274,'031799156',1,22,4,75,12),(1275,'031799157',1,22,4,81,8),(1276,'031799158',1,22,4,45,53),(1277,'031799101',1,23,4,99,1),(1278,'031799102',1,23,4,99,1),(1279,'031799103',1,23,4,54,55),(1280,'031799104',1,23,4,81,27),(1281,'031799105',1,23,4,79,30),(1282,'031799106',1,23,4,80,29),(1283,'031799107',1,23,4,72,42),(1284,'031799108',1,23,4,88,16),(1285,'031799109',1,23,4,77,34),(1286,'031799110',1,23,4,75,39),(1287,'031799111',1,23,4,76,37),(1288,'031799112',1,23,4,93,11),(1289,'031799113',1,23,4,99,1),(1290,'031799114',1,23,4,84,23),(1291,'031799115',1,23,4,70,43),(1292,'031799116',1,23,4,83,24),(1293,'031799117',1,23,4,69,45),(1294,'031799118',1,23,4,67,48),(1295,'031799119',1,23,4,62,51),(1296,'031799120',1,23,4,70,43),(1297,'031799121',1,23,4,93,11),(1298,'031799122',1,23,4,79,30),(1299,'031799123',1,23,4,85,21),(1300,'031799124',1,23,4,87,19),(1301,'031799125',1,23,4,68,46),(1302,'031799126',1,23,4,83,24),(1303,'031799127',1,23,4,90,14),(1304,'031799128',1,23,4,99,1),(1305,'031799129',1,23,4,77,34),(1306,'031799130',1,23,4,88,16),(1307,'031799131',1,23,4,62,51),(1308,'031799132',1,23,4,73,40),(1309,'031799133',1,23,4,99,1),(1310,'031799134',1,23,4,83,24),(1311,'031799135',1,23,4,51,56),(1312,'031799136',1,23,4,73,40),(1313,'031799137',1,23,4,67,48),(1314,'031799138',1,23,4,90,14),(1315,'031799139',1,23,4,56,54),(1316,'031799140',1,23,4,99,1),(1317,'031799141',1,23,4,92,13),(1318,'031799142',1,23,4,85,21),(1319,'031799143',1,23,4,47,57),(1320,'031799144',1,23,4,79,30),(1321,'031799145',1,23,4,76,37),(1322,'031799146',1,23,4,77,34),(1323,'031799147',1,23,4,99,1),(1324,'031799148',1,23,4,78,33),(1325,'031799149',1,23,4,99,1),(1326,'031799150',1,23,4,65,50),(1327,'031799151',1,23,4,88,16),(1328,'031799152',1,23,4,99,1),(1329,'031799153',1,23,4,86,20),(1330,'031799154',1,23,4,68,46),(1331,'031799155',1,23,4,81,27),(1332,'031799156',1,23,4,47,57),(1333,'031799157',1,23,4,97,10),(1334,'031799158',1,23,4,57,53),(1335,'031799101',1,24,4,90,24),(1336,'031799102',1,24,4,99,1),(1337,'031799103',1,24,4,99,1),(1338,'031799104',1,24,4,66,54),(1339,'031799105',1,24,4,99,1),(1340,'031799106',1,24,4,85,35),(1341,'031799107',1,24,4,93,21),(1342,'031799108',1,24,4,90,24),(1343,'031799109',1,24,4,86,30),(1344,'031799110',1,24,4,73,46),(1345,'031799111',1,24,4,71,47),(1346,'031799112',1,24,4,99,1),(1347,'031799113',1,24,4,66,54),(1348,'031799114',1,24,4,92,22),(1349,'031799115',1,24,4,99,1),(1350,'031799116',1,24,4,84,37),(1351,'031799117',1,24,4,70,50),(1352,'031799118',1,24,4,95,20),(1353,'031799119',1,24,4,92,22),(1354,'031799120',1,24,4,98,15),(1355,'031799121',1,24,4,81,40),(1356,'031799122',1,24,4,78,41),(1357,'031799123',1,24,4,71,47),(1358,'031799124',1,24,4,99,1),(1359,'031799125',1,24,4,34,58),(1360,'031799126',1,24,4,99,1),(1361,'031799127',1,24,4,96,17),(1362,'031799128',1,24,4,96,17),(1363,'031799129',1,24,4,84,37),(1364,'031799130',1,24,4,76,44),(1365,'031799131',1,24,4,78,41),(1366,'031799132',1,24,4,77,43),(1367,'031799133',1,24,4,89,27),(1368,'031799134',1,24,4,99,1),(1369,'031799135',1,24,4,86,30),(1370,'031799136',1,24,4,99,1),(1371,'031799137',1,24,4,99,1),(1372,'031799138',1,24,4,69,51),(1373,'031799139',1,24,4,86,30),(1374,'031799140',1,24,4,86,30),(1375,'031799141',1,24,4,99,1),(1376,'031799142',1,24,4,98,15),(1377,'031799143',1,24,4,71,47),(1378,'031799144',1,24,4,69,51),(1379,'031799145',1,24,4,59,57),(1380,'031799146',1,24,4,96,17),(1381,'031799147',1,24,4,99,1),(1382,'031799148',1,24,4,99,1),(1383,'031799149',1,24,4,87,29),(1384,'031799150',1,24,4,75,45),(1385,'031799151',1,24,4,90,24),(1386,'031799152',1,24,4,85,35),(1387,'031799153',1,24,4,83,39),(1388,'031799154',1,24,4,88,28),(1389,'031799155',1,24,4,99,1),(1390,'031799156',1,24,4,67,53),(1391,'031799157',1,24,4,66,54),(1392,'031799158',1,24,4,86,30);
/*Table structure for table `score_sum` */
DROP TABLE IF EXISTS `score_sum`;
CREATE TABLE `score_sum` (
`st_id` varchar(9) DEFAULT NULL,
`total` int(11) DEFAULT NULL,
`sum_rank` int(11) DEFAULT NULL,
`info_id` int(11) DEFAULT NULL,
`class_num` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `score_sum` */
insert into `score_sum`(`st_id`,`total`,`sum_rank`,`info_id`,`class_num`) values ('031799123',516,1,1,1),('031799114',514,1,3,1),('031799124',514,1,3,1),('031799152',512,1,4,1),('031799109',510,3,3,1),('031799148',510,2,1,1),('031799112',508,2,4,1),('031799149',505,3,4,1),('031799157',504,4,4,1),('031799103',503,4,3,1),('031799102',498,5,4,1),('031799108',497,1,2,1),('031799104',497,3,1,1),('031799101',496,6,4,1),('031799127',496,6,4,1),('031799114',495,4,1,1),('031799108',494,8,4,1),('031799128',493,9,4,1),('031799105',492,10,4,1),('031799117',491,5,3,1),('031799143',488,2,2,1),('031799151',488,6,3,1),('031799130',487,11,4,1),('031799150',487,7,3,1),('031799126',486,8,3,1),('031799131',483,9,3,1),('031799153',482,12,4,1),('031799107',482,12,4,1),('031799142',482,12,4,1),('031799136',481,15,4,1),('031799146',481,3,2,1),('031799109',481,5,1,1),('031799130',479,10,3,1),('031799154',479,10,3,1),('031799141',479,10,3,1),('031799131',478,16,4,1),('031799116',478,6,1,1),('031799113',478,13,3,1),('031799116',476,17,4,1),('031799132',476,7,1,1),('031799117',475,8,1,1),('031799157',475,8,1,1),('031799145',475,14,3,1),('031799116',474,4,2,1),('031799116',474,15,3,1),('031799134',474,18,4,1),('031799101',473,5,2,1),('031799107',473,16,3,1),('031799119',472,17,3,1),('031799109',471,19,4,1),('031799136',471,18,3,1),('031799111',470,10,1,1),('031799131',470,10,1,1),('031799132',469,19,3,1),('031799155',468,20,3,1),('031799137',468,20,4,1),('031799111',468,20,4,1),('031799147',467,22,4,1),('031799111',467,21,3,1),('031799139',466,23,4,1),('031799136',466,6,2,1),('031799118',465,12,1,1),('031799156',465,7,2,1),('031799132',465,24,4,1),('031799158',464,13,1,1),('031799135',464,25,4,1),('031799132',462,8,2,1),('031799133',462,26,4,1),('031799129',461,27,4,1),('031799121',461,14,1,1),('031799110',461,27,4,1),('031799110',460,15,1,1),('031799143',460,22,3,1),('031799138',460,9,2,1),('031799126',460,29,4,1),('031799143',460,29,4,1),('031799135',459,23,3,1),('031799128',458,16,1,1),('031799102',457,24,3,1),('031799141',457,17,1,1),('031799138',456,25,3,1),('031799140',456,31,4,1),('031799134',455,18,1,1),('031799119',455,18,1,1),('031799125',455,26,3,1),('031799138',455,18,1,1),('031799133',455,18,1,1),('031799153',454,27,3,1),('031799114',453,32,4,1),('031799113',453,22,1,1),('031799148',453,32,4,1),('031799151',453,32,4,1),('031799148',452,10,2,1),('031799146',452,28,3,1),('031799141',452,11,2,1),('031799115',452,28,3,1),('031799127',452,28,3,1),('031799112',452,28,3,1),('031799105',450,23,1,1),('031799129',450,23,1,1),('031799147',449,25,1,1),('031799141',449,35,4,1),('031799152',448,12,2,1),('031799134',448,32,3,1),('031799117',447,13,2,1),('031799123',447,33,3,1),('031799144',447,26,1,1),('031799140',447,33,3,1),('031799158',447,33,3,1),('031799119',447,36,4,1),('031799125',446,27,1,1),('031799120',445,37,4,1),('031799130',445,28,1,1),('031799113',445,14,2,1),('031799120',444,29,1,1),('031799156',444,36,3,1),('031799121',443,15,2,1),('031799102',442,30,1,1),('031799120',442,37,3,1),('031799105',441,38,3,1),('031799103',441,38,4,1),('031799113',439,39,4,1),('031799154',439,39,4,1),('031799112',438,31,1,1),('031799108',438,39,3,1),('031799146',437,41,4,1),('031799112',437,16,2,1),('031799110',437,40,3,1),('031799122',436,42,4,1),('031799155',436,42,4,1),('031799104',436,41,3,1),('031799122',435,32,1,1),('031799126',434,33,1,1),('031799151',434,17,2,1),('031799149',434,42,3,1),('031799130',433,18,2,1),('031799149',432,34,1,1),('031799121',431,44,4,1),('031799145',431,19,2,1),('031799125',431,44,4,1),('031799107',430,35,1,1),('031799155',430,35,1,1),('031799148',429,43,3,1),('031799124',429,46,4,1),('031799110',428,20,2,1),('031799106',428,47,4,1),('031799105',428,21,2,1),('031799117',428,47,4,1),('031799140',428,37,1,1),('031799156',428,37,1,1),('031799118',428,47,4,1),('031799115',427,50,4,1),('031799144',427,22,2,1),('031799101',425,44,3,1),('031799106',425,39,1,1),('031799142',424,23,2,1),('031799119',424,24,2,1),('031799150',424,51,4,1),('031799139',424,25,2,1),('031799121',424,45,3,1),('031799129',424,45,3,1),('031799157',423,26,2,1),('031799118',423,47,3,1),('031799147',423,27,2,1),('031799152',421,40,1,1),('031799108',421,40,1,1),('031799137',421,48,3,1),('031799144',420,52,4,1),('031799135',420,42,1,1),('031799151',420,42,1,1),('031799104',418,28,2,1),('031799128',418,49,3,1),('031799111',417,29,2,1),('031799157',417,50,3,1),('031799154',416,44,1,1),('031799142',416,51,3,1),('031799103',414,30,2,1),('031799123',414,53,4,1),('031799128',414,31,2,1),('031799106',413,52,3,1),('031799147',413,52,3,1),('031799134',413,32,2,1),('031799137',413,45,1,1),('031799145',413,45,1,1),('031799125',411,33,2,1),('031799146',411,47,1,1),('031799115',409,48,1,1),('031799104',406,54,4,1),('031799120',406,34,2,1),('031799140',405,35,2,1),('031799145',405,55,4,1),('031799139',403,49,1,1),('031799122',402,54,3,1),('031799143',402,50,1,1),('031799158',401,56,4,1),('031799124',400,36,2,1),('031799139',400,55,3,1),('031799158',400,37,2,1),('031799106',400,38,2,1),('031799152',400,55,3,1),('031799156',397,57,4,1),('031799114',397,39,2,1),('031799133',395,57,3,1),('031799101',395,51,1,1),('031799103',394,52,1,1),('031799136',394,52,1,1),('031799150',391,54,1,1),('031799138',389,58,4,1),('031799127',389,40,2,1),('031799137',389,41,2,1),('031799142',388,55,1,1),('031799150',388,42,2,1),('031799102',386,43,2,1),('031799115',384,44,2,1),('031799126',381,45,2,1),('031799129',381,46,2,1),('031799131',378,47,2,1),('031799154',377,48,2,1),('031799107',377,49,2,1),('031799144',374,58,3,1),('031799124',371,56,1,1),('031799118',369,50,2,1),('031799109',364,51,2,1),('031799135',363,52,2,1),('031799122',363,53,2,1),('031799153',361,57,1,1),('031799127',360,58,1,1),('031799149',351,54,2,1),('031799133',348,55,2,1),('031799123',345,56,2,1),('031799153',327,57,2,1),('031799155',327,58,2,1);
/*Table structure for table `student` */
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`st_id` varchar(9) DEFAULT NULL,
`name` varchar(18) DEFAULT NULL,
`class_num` int(11) DEFAULT NULL,
`leader` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `student` */
insert into `student`(`st_id`,`name`,`class_num`,`leader`) values ('031799101','张一',1,1),('031799102','张二',1,0),('031799103','张三',1,0),('031799104','张四',1,0),('031799105','张五',1,0),('031799106','赵一',1,0),('031799107','赵二',1,0),('031799108','赵三',1,0),('031799109','赵四',1,0),('031799110','赵五',1,0),('031799111','李一',1,0),('031799112','李二',1,0),('031799113','李三',1,0),('031799114','李四',1,0),('031799115','李五',1,0),('031799116','王一',1,0),('031799117','王二',1,0),('031799118','王三',1,0),('031799119','王四',1,0),('031799120','王五',1,0),('031799121','刘一',1,0),('031799122','刘二',1,0),('031799123','刘三',1,0),('031799124','刘四',1,0),('031799125','刘五',1,0),('031799126','陈一',1,0),('031799127','陈二',1,0),('031799128','陈三',1,0),('031799129','陈四',1,0),('031799130','陈五',1,0),('031799131','杨一',1,0),('031799132','杨二',1,0),('031799133','杨三',1,0),('031799134','杨四',1,0),('031799135','杨五',1,0),('031799136','黄一',1,0),('031799137','黄二',1,0),('031799138','黄三',1,0),('031799139','黄四',1,0),('031799140','黄五',1,0),('031799141','周一',1,0),('031799142','周二',1,0),('031799143','周三',1,0),('031799144','周四',1,0),('031799145','周五',1,0),('031799146','吴一',1,0),('031799147','吴二',1,0),('031799148','吴三',1,0),('031799149','吴四',1,0),('031799150','吴五',1,0),('031799151','孙一',1,0),('031799152','孙二',1,0),('031799153','孙三',1,0),('031799154','孙四',1,0),('031799155','孙五',1,0),('031799156','林一',1,0),('031799157','林二',1,0),('031799158','林三',1,NULL);
/*Table structure for table `sub` */
DROP TABLE IF EXISTS `sub`;
CREATE TABLE `sub` (
`sub_id` int(11) NOT NULL AUTO_INCREMENT,
`sub_name` varchar(80) DEFAULT NULL,
KEY `sub_id` (`sub_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*Data for the table `sub` */
insert into `sub`(`sub_id`,`sub_name`) values (1,'大学物理A(下)'),(2,'大学物理实验A(下)'),(3,'离散数学'),(4,'数字电路与逻辑设计'),(5,'数字逻辑电路设计实验'),(6,'算法与数据结构'),(7,'计算机学科导论'),(8,'认知实习'),(9,'高等数学B(上)'),(10,'高级语言程序设计'),(11,'高级语言程序设计实践'),(12,'线性代数'),(13,'大学物理A(上)'),(14,'大学物理实验A(上)'),(15,'高等数学B(下)'),(16,'基础电路与电子学'),(17,'电子线路综合实验'),(18,'面向对象程序设计'),(19,'计算机组成原理A'),(20,'计算机组成原理实践'),(21,'计算机网络'),(22,'概率论与数理统计'),(23,'汇编语言程序设计'),(24,'马克思主义基本原理');
/*Table structure for table `user_password` */
DROP TABLE IF EXISTS `user_password`;
CREATE TABLE `user_password` (
`username` varchar(9) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`check` int(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Data for the table `user_password` */
insert into `user_password`(`username`,`password`,`check`) values ('031799101','031799101',1),('031799102','031799102',1),('031799103','031799103',1),('031799104','031799104',1),('031799105','031799105',1),('031799106','031799106',1),('031799107','031799107',1),('031799108','031799108',1),('031799109','031799109',1),('031799110','031799110',1),('031799111','031799111',1),('031799112','031799112',1),('031799113','031799113',1),('031799114','031799114',1),('031799115','031799115',1),('031799116','031799116',1),('031799117','031799117',1),('031799118','031799118',1),('031799119','031799119',1),('031799120','031799120',1),('031799121','031799121',1),('031799122','031799122',1),('031799123','031799123',1),('031799124','031799124',1),('031799125','031799125',1),('031799126','031799126',1),('031799127','031799127',1),('031799128','031799128',1),('031799129','031799129',1),('031799130','031799130',1),('031799131','031799131',1),('031799132','031799132',1),('031799133','031799133',1),('031799134','031799134',1),('031799135','031799135',1),('031799136','031799136',1),('031799137','031799137',1),('031799138','031799138',1),('031799139','031799139',1),('031799140','031799140',1),('031799141','031799141',1),('031799142','031799142',1),('031799143','031799143',1),('031799144','031799144',1),('031799145','031799145',1),('031799146','031799146',1),('031799147','031799147',1),('031799148','031799148',1),('031799149','031799149',1),('031799150','031799150',1),('031799151','031799151',1),('031799152','031799152',1),('031799153','031799153',1),('031799154','031799154',1),('031799155','031799155',1),('031799156','031799156',1),('031799157','031799157',1),('031799158','031799158',1);
/*Table structure for table `score_view` */
DROP TABLE IF EXISTS `score_view`;
/*!50001 DROP VIEW IF EXISTS `score_view` */;
/*!50001 DROP TABLE IF EXISTS `score_view` */;
/*!50001 CREATE TABLE `score_view`(
`name` varchar(18) ,
`st_id` varchar(9) ,
`class_num` int(11) ,
`sub_id` int(11) ,
`sub_name` varchar(80) ,
`score` int(11) ,
`date` varchar(20) ,
`info_id` int(11)
)*/;
/*View structure for view score_view */
/*!50001 DROP TABLE IF EXISTS `score_view` */;
/*!50001 DROP VIEW IF EXISTS `score_view` */;
/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `score_view` AS select `student`.`name` AS `name`,`student`.`st_id` AS `st_id`,`student`.`class_num` AS `class_num`,`sub`.`sub_id` AS `sub_id`,`sub`.`sub_name` AS `sub_name`,`score`.`score` AS `score`,`exam_info`.`exam_date` AS `date`,`exam_info`.`info_id` AS `info_id` from (((`student` join `sub`) join `score`) join `exam_info`) where ((`score`.`st_id` = `student`.`st_id`) and (`score`.`info_id` = `exam_info`.`info_id`) and (`score`.`sub_id` = `sub`.`sub_id`)) */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;