This repository has been archived by the owner on Sep 7, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
default_db.sql
116 lines (101 loc) · 52.3 KB
/
default_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
CREATE DATABASE IF NOT EXISTS `cake_br_reviews` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `cake_br_reviews`;
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: localhost Database: cake_br_reviews
-- ------------------------------------------------------
-- Server version 5.5.5-10.1.35-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `bathrooms`
--
DROP TABLE IF EXISTS `bathrooms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bathrooms` (
`bathroom_id` int(11) NOT NULL AUTO_INCREMENT,
`floor` tinyint(4) NOT NULL,
`floor_room_str` text NOT NULL,
`room` text NOT NULL,
`use_name` text NOT NULL,
`building_id` int(11) NOT NULL,
PRIMARY KEY (`bathroom_id`),
KEY `building_key` (`building_id`),
CONSTRAINT `building_key` FOREIGN KEY (`building_id`) REFERENCES `buildings` (`building_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2048 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bathrooms`
--
LOCK TABLES `bathrooms` WRITE;
/*!40000 ALTER TABLE `bathrooms` DISABLE KEYS */;
INSERT INTO `bathrooms` VALUES (1,1,'1202','202','Mens',1),(2,1,'1204','204','Womens',1),(3,1,'1103','103','Neutral',2),(4,1,'1226','226','Womens',2),(5,1,'1228','228','Mens',2),(6,1,'1232','232','Family',2),(7,2,'2218','218','Mens',2),(8,2,'2228','228','Womens',2),(9,3,'3103','103','Womens',2),(10,3,'3105','105','Mens',2),(11,4,'4103','103','Womens',2),(12,4,'4105','105','Mens',2),(13,5,'5103','103','Womens',2),(14,5,'5105','105','Mens',2),(15,6,'6103','103','Mens',2),(16,6,'6103A','103A','Mens',2),(17,6,'6103B','103B','Mens',2),(18,6,'6103C','103C','Mens',2),(19,6,'6105','105','Womens',2),(20,6,'6105A','105A','Womens',2),(21,6,'6105B','105B','Womens',2),(22,6,'6105C','105C','Womens',2),(23,6,'6105D','105D','Womens',2),(24,1,'1104','104','Mens',3),(25,1,'1108','108','Womens',3),(26,1,'1236','236','Womens',3),(27,1,'1240','240','Mens',3),(28,1,'1304','304','Mens',3),(29,1,'1308','308','Womens',3),(30,1,'1402','402','Mens',3),(31,1,'1406','406','Womens',3),(32,2,'2108','108','Mens',3),(33,2,'2112','112','Womens',3),(34,2,'2238','238','Womens',3),(35,2,'2242','242','Mens',3),(36,2,'2304','304','Mens',3),(37,2,'2308','308','Womens',3),(38,2,'2420','420','Mens',3),(39,2,'2424','424','Womens',3),(40,3,'3110','110','Mens',3),(41,3,'3114','114','Womens',3),(42,3,'3240','240','Womens',3),(43,3,'3244','244','Mens',3),(44,3,'3304','304','Mens',3),(45,3,'3308','308','Womens',3),(46,3,'3430','430','Mens',3),(47,3,'3434','434','Womens',3),(48,4,'4104','104','Mens',3),(49,4,'4108','108','Womens',3),(50,4,'4428','428','Mens',3),(51,4,'4434','434','Womens',3),(52,0,'0137','137','Neutral',4),(53,0,'0374','374','Mens',4),(54,0,'0376','376','Womens',4),(55,0,'0416','416','Neutral',4),(56,0,'0420','420','Neutral',4),(57,0,'0524','524','Womens',4),(58,0,'0528','528','Mens',4),(59,0,'0531','531','Mens',4),(60,1,'1143','143','Mens',4),(61,1,'1145','145','Womens',4),(62,1,'1345','345','Mens',4),(63,1,'1345A','345A','Mens',4),(64,1,'1349','349','Womens',4),(65,1,'1349A','349A','Womens',4),(66,1,'1402','402','Womens',4),(67,1,'1404','404','Neutral',4),(68,1,'1416','416','Neutral',4),(69,1,'1418','418','Neutral',4),(70,2,'2143','143','Mens',4),(71,2,'2403','403','Neutral',4),(72,2,'2405','405','Neutral',4),(73,3,'3143','143','Womens',4),(74,3,'3143A','143A','Womens',4),(75,3,'3143B','143B','Womens',4),(76,4,'4143','143','Mens',4),(77,4,'4143A','143A','Mens',4),(78,4,'4143B','143B','Mens',4),(79,1,'1103','103','Mens',5),(80,1,'1104','104','Womens',5),(81,0,'0110','110','Mens',6),(82,0,'0112','112','Womens',6),(83,1,'1108','108','Neutral',6),(84,1,'1110','110','Neutral',6),(85,1,'1202A','202A','Womens',7),(86,1,'1204A','204A','Mens',7),(87,1,'1103','103','Neutral',8),(88,0,'0103','103','Mens',9),(89,0,'0109','109','Womens',9),(90,0,'0200','200','Mens',9),(91,0,'0214','214','Womens',9),(92,1,'1109','109','Womens',9),(93,1,'1113','113','Mens',9),(94,1,'1202','202','Mens',9),(95,1,'1203','203','Womens',9),(96,1,'1144','144','Womens',10),(97,1,'1144A','144A','Womens',10),(98,1,'1144B','144B','Womens',10),(99,1,'1145','145','Mens',10),(100,1,'1145A','145A','Mens',10),(101,1,'1141','141','Mens',11),(102,1,'1142','142','Womens',11),(103,1,'1152','152','Neutral',11),(104,2,'2244','244','Womens',11),(105,2,'2244A','244A','Womens',11),(106,2,'2254','254','Mens',11),(107,2,'2254A','254A','Mens',11),(108,2,'2256','256','Neutral',11),(109,2,'2256A','256A','Neutral',11),(110,3,'3344','344','Womens',11),(111,3,'3344A','344A','Womens',11),(112,3,'3354','354','Mens',11),(113,3,'3354A','354A','Mens',11),(114,3,'3356','356','Neutral',11),(115,1,'1102','102','Neutral',12),(116,1,'1100B','100B','Womens',13),(117,1,'1100C','100C','Mens',13),(118,0,'0217','217','Womens',14),(119,0,'0221','221','Mens',14),(120,0,'0303','303','Mens',14),(121,0,'0306','306','Womens',14),(122,1,'1120','120','Womens',14),(123,1,'1124','124','Neutral',14),(124,1,'1217','217','Womens',14),(125,1,'1221','221','Mens',14),(126,1,'1323','323','Womens',14),(127,1,'1325','325','Mens',14),(128,1,'1414','414','Womens',14),(129,1,'1438','438','Mens',14),(130,2,'2120','120','Neutral',14),(131,2,'2124','124','Neutral',14),(132,2,'2217','217','Womens',14),(133,2,'2221','221','Mens',14),(134,2,'2323','323','Womens',14),(135,2,'2325','325','Mens',14),(136,2,'2406','406','Womens',14),(137,2,'2442','442','Mens',14),(138,3,'3120','120','Neutral',14),(139,3,'3124','124','Neutral',14),(140,3,'3217','217','Womens',14),(141,3,'3221','221','Mens',14),(142,3,'3321','321','Womens',14),(143,3,'3325','325','Mens',14),(144,3,'3406','406','Womens',14),(145,3,'3442','442','Mens',14),(146,4,'4120','120','Womens',14),(147,4,'4124','124','Neutral',14),(148,4,'4217','217','Womens',14),(149,4,'4221','221','Mens',14),(150,4,'4321','321','Womens',14),(151,4,'4325','325','Mens',14),(152,4,'4410','410','Womens',14),(153,4,'4452','452','Mens',14),(154,0,'B0219','219','Neutral',14),(155,1,'1100','100','Neutral',15),(156,1,'1102','102','Neutral',15),(157,1,'1133','133','Womens',15),(158,1,'1133A','133A','Womens',15),(159,1,'1133B','133B','Womens',15),(160,1,'1133C','133C','Womens',15),(161,1,'1133D','133D','Womens',15),(162,1,'1135','135','Mens',15),(163,1,'1135A','135A','Mens',15),(164,1,'1135B','135B','Mens',15),(165,1,'1135C','135C','Mens',15),(166,1,'1212','212','Mens',15),(167,1,'1214','214','Womens',15),(168,1,'1429','429','Womens',15),(169,1,'1429A','429A','Womens',15),(170,1,'1431','431','Mens',15),(171,1,'1431A','431A','Mens',15),(172,1,'1108A','108A','Neutral',16),(173,1,'1110A','110A','Neutral',16),(174,0,'0118','118','Womens',17),(175,0,'0310','310','Mens',17),(176,1,'1118','118','Mens',17),(177,1,'1310','310','Womens',17),(178,2,'2118','118','Womens',17),(179,2,'2310','310','Mens',17),(180,3,'3118','118','Mens',17),(181,3,'3310','310','Womens',17),(182,4,'4108','108','Family',17),(183,0,'0117','117','Mens',18),(184,0,'0119','119','Womens',18),(185,0,'0282','282','Womens',18),(186,1,'1117','117','Mens',18),(187,1,'1119','119','Womens',18),(188,1,'1218','218','Womens',18),(189,1,'1241','241','Mens',18),(190,2,'2117','117','Mens',18),(191,2,'2119','119','Womens',18),(192,2,'2241','241','Mens',18),(193,2,'2282','282','Womens',18),(194,3,'3117','117','Mens',18),(195,3,'3119','119','Womens',18),(196,3,'3241','241','Mens',18),(197,3,'3282','282','Womens',18),(198,4,'4117','117','Mens',18),(199,4,'4119','119','Womens',18),(200,4,'4241','241','Mens',18),(201,4,'4282','282','Womens',18),(202,0,'B0123','123','Mens',18),(203,0,'B0125','125','Womens',18),(204,1,'1108','108','Mens',19),(205,1,'1112','112','Womens',19),(206,2,'2108','108','Mens',19),(207,2,'2112','112','Womens',19),(208,3,'3108','108','Mens',19),(209,3,'3112','112','Womens',19),(210,0,'0104','104','Womens',20),(211,0,'0108','108','Mens',20),(212,0,'0202','202','Womens',20),(213,0,'0204','204','Mens',20),(214,1,'1202','202','Womens',20),(215,1,'1204','204','Mens',20),(216,2,'2202','202','Womens',20),(217,2,'2204','204','Mens',20),(218,3,'3202','202','Womens',20),(219,3,'3204','204','Mens',20),(220,1,'1103','103','Mens',21),(221,1,'1104','104','Womens',21),(222,0,'0109','109','Neutral',22),(223,0,'0115','115','Womens',22),(224,0,'0119','119','Mens',22),(225,0,'0314','314','Neutral',22),(226,1,'1215','215','Womens',22),(227,1,'1219','219','Mens',22),(228,2,'2215','215','Womens',22),(229,2,'2219','219','Mens',22),(230,3,'3215','215','Womens',22),(231,3,'3219','219','Mens',22),(232,4,'4215','215','Womens',22),(233,4,'4219','219','Mens',22),(234,5,'5215','215','Womens',22),(235,5,'5219','219','Mens',22),(236,6,'6252','252','Neutral',22),(237,0,'0222','222','Neutral',23),(238,1,'1104','104','Womens',24),(239,1,'1106','106','Mens',24),(240,1,'1207','207','Womens',24),(241,1,'1211','211','Mens',24),(242,0,'0103','103','Mens',25),(243,0,'0112','112','Womens',25),(244,0,'0122','122','Mens',25),(245,1,'1102','102','Womens',26),(246,1,'1106','106','Mens',26),(247,1,'1101','101','Neutral',27),(248,1,'1103','103','Neutral',27),(249,0,'0109G','109G','Womens',28),(250,0,'0200C','200C','Womens',28),(251,0,'0200E','200E','Mens',28),(252,1,'1114','114','Neutral',28),(253,1,'1122','122','Mens',29),(254,1,'1122A','122A','Mens',29),(255,1,'1131','131','Womens',29),(256,1,'1200','200','Mens',29),(257,1,'1204','204','Womens',29),(258,2,'2128','128','Mens',29),(259,2,'2131','131','Mens',29),(260,2,'2131A','131A','Mens',29),(261,2,'2137','137','Womens',29),(262,2,'2137A','137A','Womens',29),(263,2,'2137B','137B','Womens',29),(264,0,'0116','116','Mens',30),(265,0,'0120','120','Womens',30),(266,0,'0406','406','Mens',30),(267,0,'0409','409','Womens',30),(268,0,'0509','509','Mens',30),(269,1,'1116','116','Mens',30),(270,1,'1120','120','Womens',30),(271,1,'1202','202','Mens',30),(272,1,'1232','232','Womens',30),(273,1,'1324','324','Womens',30),(274,1,'1352','352','Mens',30),(275,1,'1405','405','Mens',30),(276,1,'1409','409','Womens',30),(277,1,'1509','509','Mens',30),(278,2,'2116','116','Mens',30),(279,2,'2120','120','Womens',30),(280,2,'2202','202','Womens',30),(281,2,'2234','234','Mens',30),(282,2,'2324','324','Womens',30),(283,2,'2369','369','Mens',30),(284,2,'2509','509','Womens',30),(285,3,'3116','116','Mens',30),(286,3,'3120','120','Womens',30),(287,3,'3202','202','Mens',30),(288,3,'3234','234','Womens',30),(289,3,'3324','324','Womens',30),(290,3,'3375','375','Mens',30),(291,3,'3509','509','Mens',30),(292,4,'4116','116','Mens',30),(293,4,'4120','120','Womens',30),(294,4,'4509','509','Womens',30),(295,0,'B0116','116','Mens',30),(296,0,'B0120','120','Womens',30),(297,0,'B0202','202','Neutral',30),(298,0,'B0202A','202A','Neutral',30),(299,0,'B0202B','202B','Neutral',30),(300,0,'B0204','204','Neutral',30),(301,1,'1105','105','Womens',31),(302,1,'1105A','105A','Womens',31),(303,1,'1111','111','Mens',31),(304,1,'1111A','111A','Mens',31),(305,2,'2105','105','Womens',31),(306,2,'2105A','105A','Womens',31),(307,2,'2111','111','Mens',31),(308,2,'2111A','111A','Mens',31),(309,3,'3105','105','Womens',31),(310,3,'3105A','105A','Womens',31),(311,3,'3111','111','Mens',31),(312,3,'3111A','111A','Mens',31),(313,4,'4105','105','Womens',31),(314,4,'4105A','105A','Womens',31),(315,4,'4111','111','Mens',31),(316,4,'4111A','111A','Mens',31),(317,0,'0119','119','Neutral',32),(318,0,'0121A','121A','Neutral',32),(319,1,'1106A','106A','Neutral',32),(320,1,'1108A','108A','Neutral',32),(321,1,'1108','108','Mens',33),(322,1,'1112','112','Womens',33),(323,2,'2108','108','Family',33),(324,2,'2108A','108A','Family',33),(325,2,'2112','112','Womens',33),(326,3,'3112','112','Mens',33),(327,4,'4112','112','Womens',33),(328,0,'0111','111','Womens',34),(329,0,'0121','121','Mens',34),(330,1,'1111','111','Womens',34),(331,1,'1121','121','Mens',34),(332,2,'2111','111','Womens',34),(333,2,'2121','121','Mens',34),(334,3,'3110','110','Womens',34),(335,3,'3121','121','Neutral',34),(336,1,'1216','216','Mens',35),(337,1,'1217','217','Womens',35),(338,1,'1460','460','Womens',35),(339,1,'1464','464','Mens',35),(340,1,'1608','608','Mens',35),(341,1,'1705','705','Womens',35),(342,1,'1709','709','Mens',35),(343,1,'1716','716','Womens',35),(344,1,'1900B','900B','Womens',35),(345,1,'1900C','900C','Womens',35),(346,1,'1904A','904A','Mens',35),(347,1,'1904B','904B','Mens',35),(348,2,'2169','169','Mens',35),(349,2,'2302','302','Mens',35),(350,2,'2304','304','Womens',35),(351,2,'2522','522','Neutral',35),(352,2,'2524','524','Neutral',35),(353,2,'2606','606','Neutral',35),(354,2,'2608','608','Womens',35),(355,2,'2724','724','Mens',35),(356,2,'2726','726','Womens',35),(357,3,'3102','102','Mens',35),(358,3,'3103','103','Womens',35),(359,3,'3169','169','Womens',35),(360,3,'3733','733','Mens',35),(361,3,'3735','735','Womens',35),(362,1,'1102','102','Mens',36),(363,1,'1104','104','Womens',36),(364,0,'0209','209','Mens',37),(365,0,'0210','210','Womens',37),(366,1,'1129','129','Womens',37),(367,1,'1129A','129A','Womens',37),(368,1,'1139','139','Mens',37),(369,1,'1141','141','Mens',37),(370,3,'3101','101','Mens',37),(371,3,'3102','102','Womens',37),(372,1,'1121','121','Mens',38),(373,1,'1123','123','Womens',38),(374,1,'1103','103','Womens',39),(375,1,'1105','105','Mens',39),(376,2,'2103','103','Womens',39),(377,2,'2105','105','Mens',39),(378,3,'3103','103','Womens',39),(379,3,'3105','105','Mens',39),(380,4,'4103','103','Womens',39),(381,4,'4105','105','Mens',39),(382,0,'0112','112','Womens',40),(383,0,'0124','124','Neutral',40),(384,1,'1116','116','Mens',40),(385,1,'1116A','116A','Mens',40),(386,1,'1126','126','Womens',40),(387,1,'1136','136','Womens',40),(388,1,'1108','108','Womens',41),(389,1,'1109','109','Mens',41),(390,1,'1134','134','Womens',41),(391,1,'1134A','134A','Womens',41),(392,1,'1136','136','Mens',41),(393,1,'1136A','136A','Mens',41),(394,0,'0110','110','Neutral',42),(395,1,'1128','128','Neutral',42),(396,0,'0110','110','Womens',43),(397,1,'1119B','119B','Neutral',44),(398,1,'1123','123','Womens',44),(399,0,'0112','112','Womens',45),(400,0,'0114','114','Mens',45),(401,0,'0116','116','Family',45),(402,0,'0217','217','Mens',45),(403,0,'0223','223','Womens',45),(404,0,'0319','319','Mens',45),(405,0,'0321','321','Womens',45),(406,1,'1109','109','Neutral',45),(407,1,'1111','111','Womens',45),(408,1,'1112','112','Mens',45),(409,1,'1203','203','Neutral',45),(410,1,'1219','219','Mens',45),(411,1,'1221','221','Womens',45),(412,1,'1305','305','Womens',45),(413,1,'1307','307','Mens',45),(414,2,'2203','203','Mens',45),(415,2,'2205','205','Womens',45),(416,2,'2305','305','Mens',45),(417,2,'2307','307','Womens',45),(418,0,'B0210','210','Neutral',45),(419,0,'0100A','100A','Mens',46),(420,0,'0100C','100C','Womens',46),(421,0,'0115','115','Neutral',46),(422,1,'1104','104','Mens',47),(423,1,'1105','105','Womens',47),(424,1,'1135','135','Womens',47),(425,1,'1136','136','Mens',47),(426,0,'0107','107','Womens',48),(427,0,'0109','109','Mens',48),(428,1,'1121','121','Neutral',48),(429,0,'0106','106','Womens',49),(430,0,'0108','108','Mens',49),(431,0,'0123','123','Womens',49),(432,0,'0125','125','Mens',49),(433,0,'0213','213','Womens',49),(434,0,'0217','217','Mens',49),(435,1,'1213','213','Womens',49),(436,1,'1217','217','Mens',49),(437,0,'0102','102','Womens',50),(438,0,'0104','104','Mens',50),(439,0,'0201E','201E','Mens',50),(440,0,'0201F','201F','Womens',50),(441,0,'0304','304','Womens',50),(442,0,'0306','306','Mens',50),(443,1,'1158','158','Mens',51),(444,1,'1160','160','Womens',51),(445,1,'1182','182','Mens',51),(446,1,'1182A','182A','Womens',51),(447,0,'0111','111','Mens',52),(448,0,'0117','117','Womens',52),(449,0,'0130A','130A','Mens',52),(450,0,'0130D','130D','Womens',52),(451,1,'1109','109','Neutral',52),(452,1,'1111','111','Neutral',52),(453,1,'1130A','130A','Womens',52),(454,1,'1130B','130B','Mens',52),(455,2,'2102','102','Womens',52),(456,2,'2109','109','Mens',52),(457,1,'1105','105','Womens',53),(458,1,'1106','106','Mens',53),(459,0,'0108','108','Womens',54),(460,0,'0112','112','Mens',54),(461,1,'1108','108','Mens',54),(462,1,'1114','114','Womens',54),(463,2,'2108','108','Womens',54),(464,2,'2112','112','Mens',54),(465,3,'3108','108','Mens',54),(466,3,'3112','112','Womens',54),(467,1,'1101','101','Mens',55),(468,1,'1125','125','Womens',55),(469,3,'3101','101','Mens',55),(470,3,'3101A','101A','Mens',55),(471,3,'3125','125','Womens',55),(472,3,'3125A','125A','Womens',55),(473,0,'0106A','106A','Womens',56),(474,0,'0107A','107A','Mens',56),(475,0,'0120C','120C','Mens',56),(476,0,'0120G','120G','Womens',56),(477,1,'1101','101','Mens',56),(478,1,'1103','103','Womens',56),(479,1,'1102','102','Womens',57),(480,1,'1103','103','Mens',57),(481,0,'0109F','109F','Neutral',58),(482,1,'1103','103','Womens',58),(483,1,'1105','105','Mens',58),(484,1,'1191A','191A','Womens',58),(485,1,'1191B','191B','Mens',58),(486,0,'0218','218','Womens',59),(487,0,'0220','220','Mens',59),(488,1,'1111','111','Mens',59),(489,1,'1113','113','Womens',59),(490,1,'1218','218','Mens',59),(491,2,'2111','111','Neutral',59),(492,2,'2113','113','Womens',59),(493,2,'2218','218','Womens',59),(494,3,'3111','111','Mens',59),(495,3,'3113','113','Womens',59),(496,3,'3202','202','Womens',59),(497,3,'3226','226','Mens',59),(498,0,'0105','105','Neutral',60),(499,0,'0107A','107A','Womens',60),(500,0,'0125','125','Womens',60),(501,1,'1117','117','Womens',60),(502,1,'1129','129','Womens',60),(503,0,'B0108D','108D','Mens',61),(504,0,'0135','135','Womens',62),(505,0,'0137','137','Mens',62),(506,1,'1140','140','Neutral',62),(507,2,'2141','141','Womens',62),(508,2,'2143','143','Mens',62),(509,0,'0102','102','Womens',63),(510,0,'0102A','102A','Womens',63),(511,0,'0104','104','Mens',63),(512,0,'0104A','104A','Mens',63),(513,0,'0210','210','Womens',63),(514,0,'0210A','210A','Womens',63),(515,0,'0212','212','Mens',63),(516,0,'0213','213','Mens',63),(517,0,'0213A','213A','Mens',63),(518,0,'0218','218','Womens',63),(519,0,'0219','219','Mens',63),(520,1,'1102','102','Womens',63),(521,1,'1102A','102A','Womens',63),(522,1,'1106','106','Mens',63),(523,1,'1106A','106A','Mens',63),(524,1,'1214','214','Womens',63),(525,1,'1217','217','Mens',63),(526,2,'2102','102','Womens',63),(527,2,'2104','104','Mens',63),(528,2,'2206','206','Mens',63),(529,2,'2207','207','Womens',63),(530,2,'2207A','207A','Womens',63),(531,2,'2212','212','Mens',63),(532,2,'2212A','212A','Mens',63),(533,2,'2215','215','Womens',63),(534,2,'2215A','215A','Womens',63),(535,2,'2215B','215B','Womens',63),(536,3,'3102','102','Womens',63),(537,3,'3102A','102A','Womens',63),(538,3,'3102B','102B','Womens',63),(539,3,'3104','104','Mens',63),(540,3,'3206','206','Mens',63),(541,3,'3207','207','Womens',63),(542,3,'3207A','207A','Womens',63),(543,3,'3212','212','Mens',63),(544,3,'3215','215','Womens',63),(545,3,'3215A','215A','Womens',63),(546,3,'3215B','215B','Womens',63),(547,4,'4104','104','Womens',63),(548,4,'4104A','104A','Neutral',63),(549,4,'4106','106','Mens',63),(550,4,'4206','206','Mens',63),(551,4,'4207','207','Womens',63),(552,4,'4207A','207A','Womens',63),(553,4,'4212','212','Mens',63),(554,4,'4215','215','Womens',63),(555,4,'4215A','215A','Womens',63),(556,0,'0A-002','A-002','Neutral',64),(557,1,'1A-141','A-141','Mens',64),(558,1,'1A-142','A-142','Womens',64),(559,1,'1B-102','B-102','Womens',64),(560,1,'1B-103','B-103','Mens',64),(561,2,'2A-211','A-211','Womens',64),(562,2,'2A-212','A-212','Mens',64),(563,2,'2B-202','B-202','Womens',64),(564,2,'2B-203','B-203','Mens',64),(565,3,'3B-302','B-302','Womens',64),(566,3,'3B-303','B-303','Mens',64),(567,1,'1205','205','Womens',65),(568,1,'1209','209','Mens',65),(569,1,'1231','231','Neutral',65),(570,2,'2207','207','Womens',65),(571,2,'2209','209','Mens',65),(572,3,'3207','207','Womens',65),(573,3,'3209','209','Mens',65),(574,4,'4201','201','Neutral',65),(575,4,'4203','203','Neutral',65),(576,4,'4207','207','Womens',65),(577,4,'4209','209','Mens',65),(578,0,'0103','103','Mens',66),(579,1,'1103','103','Neutral',66),(580,2,'2103','103','Womens',66),(581,2,'2111','111','Mens',66),(582,1,'1106','106','Womens',67),(583,1,'1106A','106A','Womens',67),(584,1,'1107','107','Mens',67),(585,1,'1232','232','Womens',67),(586,1,'1232A','232A','Womens',67),(587,1,'1234','234','Mens',67),(588,2,'2232','232','Womens',67),(589,2,'2232A','232A','Womens',67),(590,2,'2234','234','Mens',67),(591,3,'3232','232','Womens',67),(592,3,'3232A','232A','Womens',67),(593,3,'3234','234','Mens',67),(594,0,'0113','113','Mens',68),(595,0,'0210','210','Mens',68),(596,0,'0211','211','Womens',68),(597,1,'1113','113','Mens',68),(598,1,'1210','210','Womens',68),(599,2,'2113','113','Womens',68),(600,2,'2208','208','Mens',68),(601,3,'3113','113','Mens',68),(602,3,'3208','208','Womens',68),(603,4,'4113','113','Womens',68),(604,4,'4208','208','Mens',68),(605,0,'0215','215','Neutral',69),(606,0,'0215A','215A','Womens',69),(607,0,'0215B','215B','Mens',69),(608,1,'1131','131','Womens',69),(609,1,'1215','215','Mens',69),(610,1,'1318','318','Womens',69),(611,1,'1401','401','Mens',69),(612,1,'1405','405','Womens',69),(613,2,'2131','131','Mens',69),(614,2,'2326','326','Mens',69),(615,2,'2328','328','Womens',69),(616,3,'3125','125','Mens',69),(617,3,'3215','215','Womens',69),(618,3,'3318','318','Mens',69),(619,4,'4215','215','Mens',69),(620,4,'4322','322','Womens',69),(621,1,'1117','117','Mens',70),(622,1,'1117A','117A','Womens',70),(623,2,'2119','119','Mens',70),(624,2,'2122','122','Womens',70),(625,2,'2122A','122A','Womens',70),(626,1,'1101','101','Womens',71),(627,1,'1102','102','Mens',71),(628,1,'1101','101','Womens',72),(629,1,'1103','103','Mens',72),(630,2,'2101','101','Womens',72),(631,2,'2103','103','Mens',72),(632,3,'3101','101','Womens',72),(633,3,'3103','103','Mens',72),(634,1,'1102','102','Womens',73),(635,1,'1104','104','Family',73),(636,1,'1106','106','Mens',73),(637,2,'2102','102','Mens',73),(638,2,'2106','106','Womens',73),(639,3,'3102','102','Mens',73),(640,3,'3106','106','Womens',73),(641,0,'0105','105','Neutral',74),(642,0,'0107','107','Neutral',74),(643,0,'0123','123','Neutral',74),(644,0,'0125','125','Neutral',74),(645,1,'1129','129','Neutral',74),(646,0,'0326','326','Womens',75),(647,0,'0326A','326A','Womens',75),(648,0,'0328','328','Mens',75),(649,0,'0328A','328A','Mens',75),(650,1,'1116','116','Womens',75),(651,1,'1120','120','Mens',75),(652,1,'1325','325','Mens',75),(653,1,'1329','329','Womens',75),(654,0,'0104','104','Mens',76),(655,0,'0130','130','Womens',76),(656,0,'0130A','130A','Womens',76),(657,1,'1104','104','Mens',76),(658,1,'1130','130','Womens',76),(659,1,'1130A','130A','Womens',76),(660,2,'2104','104','Womens',76),(661,2,'2130','130','Mens',76),(662,3,'3104','104','Mens',76),(663,3,'3130','130','Womens',76),(664,3,'3130A','130A','Womens',76),(665,0,'0101','101','Womens',77),(666,0,'0109','109','Mens',77),(667,0,'0121','121','Neutral',77),(668,0,'0206','206','Mens',77),(669,0,'0207','207','Womens',77),(670,1,'1101','101','Womens',77),(671,1,'1109','109','Mens',77),(672,1,'1212','212','Mens',77),(673,1,'1216','216','Womens',77),(674,2,'2101','101','Mens',77),(675,2,'2117','117','Womens',77),(676,2,'2117A','117A','Womens',77),(677,2,'2210','210','Womens',77),(678,2,'2210A','210A','Womens',77),(679,2,'2214','214','Mens',77),(680,1,'1109','109','Womens',78),(681,1,'1113','113','Mens',78),(682,1,'1101','101','Mens',79),(683,1,'1103','103','Womens',79),(684,1,'1119A','119A','Neutral',79),(685,1,'1201','201','Neutral',79),(686,1,'1203','203','Neutral',79),(687,1,'1111','111','Mens',80),(688,1,'1112','112','Womens',80),(689,1,'1105B','105B','Neutral',81),(690,1,'1105C','105C','Neutral',81),(691,0,'0109','109','Womens',82),(692,0,'0109A','109A','Womens',82),(693,0,'0113','113','Mens',82),(694,1,'1113','113','Mens',82),(695,1,'1123','123','Womens',82),(696,2,'2115','115','Neutral',82),(697,0,'0101J','101J','Mens',83),(698,0,'0101K','101K','Womens',83),(699,0,'0101L','101L','Mens',83),(700,0,'0103','103','Womens',84),(701,0,'0107','107','Mens',84),(702,1,'1103','103','Womens',84),(703,1,'1107','107','Mens',84),(704,1,'1421','421','Womens',84),(705,1,'1425','425','Mens',84),(706,2,'2103','103','Womens',84),(707,2,'2107','107','Neutral',84),(708,2,'2421','421','Womens',84),(709,2,'2425','425','Mens',84),(710,3,'3103','103','Womens',84),(711,3,'3107','107','Mens',84),(712,3,'3421','421','Womens',84),(713,3,'3425','425','Mens',84),(714,0,'0113','113','Mens',85),(715,0,'0117','117','Womens',85),(716,0,'0141','141','Mens',85),(717,0,'0145','145','Womens',85),(718,1,'1113','113','Mens',85),(719,1,'1117','117','Womens',85),(720,1,'1167','167','Mens',85),(721,1,'1171','171','Womens',85),(722,2,'2111','111','Womens',85),(723,2,'2115','115','Mens',85),(724,2,'2163','163','Mens',85),(725,2,'2167','167','Womens',85),(726,3,'3113','113','Womens',85),(727,3,'3117','117','Mens',85),(728,3,'3165','165','Mens',85),(729,3,'3169','169','Womens',85),(730,1,'1106','106','Womens',86),(731,1,'1107','107','Mens',86),(732,1,'1108','108','Neutral',86),(733,1,'1504','504','Womens',87),(734,1,'1506','506','Mens',87),(735,1,'1514','514','Mens',87),(736,1,'1518','518','Neutral',87),(737,1,'1520','520','Womens',87),(738,1,'1524A','524A','Neutral',87),(739,2,'2504','504','Mens',87),(740,2,'2506','506','Womens',87),(741,2,'2518','518','Neutral',87),(742,2,'2520','520','Mens',87),(743,2,'2522','522','Womens',87),(744,3,'3504','504','Mens',87),(745,3,'3510','510','Mens',87),(746,3,'3512','512','Womens',87),(747,3,'3514','514','Neutral',87),(748,3,'3516','516','Womens',87),(749,3,'3522','522','Mens',87),(750,1,'1100','100','Mens',88),(751,1,'1102','102','Womens',88),(752,1,'1102','102','Womens',89),(753,1,'1100','100','Mens',90),(754,1,'1210','210','Womens',91),(755,1,'1214','214','Mens',91),(756,1,'1216','216','Womens',91),(757,1,'1224','224','Mens',91),(758,1,'1226','226','Womens',91),(759,1,'1228','228','Womens',91),(760,1,'1410','410','Mens',92),(761,1,'1412','412','Womens',92),(762,1,'1414','414','Mens',92),(763,1,'1418','418','Womens',92),(764,1,'1420','420','Mens',92),(765,1,'1521','521','Mens',93),(766,1,'1523','523','Womens',93),(767,1,'1127','127','Mens',94),(768,1,'1127A','127A','Family',94),(769,1,'1129','129','Womens',94),(770,1,'1129A','129A','Womens',94),(771,1,'1203','203','Mens',94),(772,1,'1205','205','Womens',94),(773,2,'2121','121','Mens',94),(774,2,'2123','123','Womens',94),(775,2,'2203','203','Mens',94),(776,2,'2205','205','Womens',94),(777,3,'3107','107','Mens',94),(778,3,'3109','109','Womens',94),(779,3,'3109A','109A','Womens',94),(780,3,'3203','203','Mens',94),(781,3,'3205','205','Womens',94),(782,4,'4106','106','Mens',94),(783,4,'4110','110','Womens',94),(784,4,'4203','203','Mens',94),(785,4,'4205','205','Womens',94),(786,5,'5111','111','Mens',94),(787,5,'5113','113','Womens',94),(788,5,'5113A','113A','Womens',94),(789,6,'6110','110','Mens',94),(790,6,'6112','112','Womens',94),(791,6,'6203','203','Mens',94),(792,6,'6205','205','Womens',94),(793,7,'7112','112','Womens',94),(794,7,'7114','114','Mens',94),(795,7,'7203','203','Mens',94),(796,7,'7205','205','Womens',94),(797,0,'B0101','101','Mens',94),(798,0,'B0103','103','Womens',94),(799,0,'B0205','205','Mens',94),(800,0,'B0207','207','Womens',94),(801,1,'1104','104','Neutral',95),(802,1,'1111','111','Neutral',95),(803,1,'1114','114','Neutral',95),(804,2,'2104','104','Neutral',95),(805,2,'2114','114','Neutral',95),(806,1,'1100A','100A','Neutral',96),(807,1,'1100B','100B','Neutral',96),(808,1,'1100A','100A','Neutral',97),(809,1,'1100B','100B','Neutral',97),(810,1,'1100A','100A','Neutral',98),(811,1,'1100B','100B','Neutral',98),(812,1,'1104','104','Womens',99),(813,1,'1106','106','Mens',99),(814,1,'1111C','111C','Mens',99),(815,1,'1113D','113D','Womens',99),(816,1,'1206','206','Womens',99),(817,1,'1210','210','Mens',99),(818,2,'2206','206','Womens',99),(819,2,'2210','210','Mens',99),(820,1,'1104','104','Womens',99),(821,1,'1105','105','Mens',99),(822,1,'1114','114','Neutral',99),(823,1,'1115','115','Neutral',99),(824,1,'1119A','119A','Neutral',99),(825,1,'1119B','119B','Neutral',99),(826,1,'1106','106','Neutral',99),(827,1,'1108','108','Neutral',99),(828,1,'1111A','111A','Neutral',99),(829,1,'1111B','111B','Neutral',99),(830,1,'1104','104','Womens',99),(831,1,'1105','105','Mens',99),(832,1,'1114','114','Neutral',99),(833,1,'1115','115','Neutral',99),(834,1,'1119','119','Neutral',99),(835,1,'1120','120','Neutral',99),(836,1,'1106','106','Neutral',99),(837,1,'1108','108','Neutral',99),(838,1,'1111A','111A','Neutral',99),(839,1,'1111B','111B','Neutral',99),(840,1,'1106','106','Neutral',100),(841,1,'1108','108','Neutral',100),(842,1,'1111A','111A','Neutral',100),(843,1,'1111B','111B','Neutral',100),(844,0,'0120','120','Mens',101),(845,0,'0122','122','Womens',101),(846,1,'1120','120','Mens',101),(847,1,'1122','122','Womens',101),(848,2,'2120','120','Mens',101),(849,2,'2122','122','Womens',101),(850,3,'3132','132','Mens',101),(851,3,'3134','134','Womens',101),(852,0,'0112','112','Neutral',102),(853,1,'1108','108','Mens',102),(854,2,'2108','108','Womens',102),(855,1,'1100A','100A','Neutral',103),(856,2,'2100A','100A','Mens',104),(857,2,'2100B','100B','Womens',104),(858,0,'0108','108','Neutral',105),(859,0,'0110','110','Neutral',105),(860,0,'0136','136','Womens',105),(861,0,'0138','138','Mens',105),(862,1,'1104','104','Mens',105),(863,1,'1106','106','Womens',105),(864,0,'0201','201','Mens',106),(865,0,'0203','203','Womens',106),(866,0,'0319','319','Womens',106),(867,0,'0321','321','Mens',106),(868,1,'1118','118','Neutral',106),(869,2,'2105','105','Neutral',106),(870,3,'3105','105','Neutral',106),(871,4,'4105','105','Neutral',106),(872,5,'5105','105','Neutral',106),(873,6,'6105','105','Neutral',106),(874,7,'7105','105','Neutral',106),(875,8,'8105','105','Neutral',106),(876,1,'1301','301','Mens',107),(877,1,'1303','303','Womens',107),(878,2,'2109','109','Mens',107),(879,2,'2113','113','Womens',107),(880,2,'2301','301','Mens',107),(881,2,'2303','303','Womens',107),(882,3,'3113','113','Neutral',107),(883,3,'3117','117','Womens',107),(884,3,'3303','303','Mens',107),(885,3,'3305','305','Womens',107),(886,4,'4115','115','Mens',107),(887,4,'4119','119','Womens',107),(888,4,'4301','301','Mens',107),(889,4,'4303','303','Womens',107),(890,1,'1103','103','Womens',108),(891,1,'1105','105','Mens',108),(892,1,'1105A','105A','Mens',108),(893,1,'1120','120','Neutral',108),(894,2,'2103','103','Womens',108),(895,2,'2105','105','Mens',108),(896,2,'2105A','105A','Mens',108),(897,0,'0101','101','Mens',109),(898,0,'0103','103','Womens',109),(899,1,'1101','101','Mens',109),(900,1,'1105','105','Womens',109),(901,2,'2101','101','Mens',109),(902,2,'2105','105','Womens',109),(903,0,'0242','242','Mens',110),(904,0,'0246','246','Womens',110),(905,0,'0262','262','Neutral',110),(906,1,'1139','139','Womens',110),(907,1,'1141','141','Mens',110),(908,2,'2139','139','Womens',110),(909,2,'2141','141','Mens',110),(910,3,'3139','139','Womens',110),(911,3,'3141','141','Mens',110),(912,0,'B0224','224','Womens',110),(913,0,'B0226','226','Mens',110),(914,0,'SB0224','224','Womens',110),(915,0,'SB0226','226','Mens',110),(916,0,'0102','102','Womens',111),(917,0,'0106','106','Mens',111),(918,1,'1103','103','Womens',111),(919,1,'1107','107','Mens',111),(920,1,'1148','148','Mens',111),(921,1,'1150','150','Womens',111),(922,2,'2101','101','Womens',111),(923,2,'2105','105','Mens',111),(924,2,'2153','153','Womens',111),(925,2,'2155','155','Mens',111),(926,3,'3103','103','Womens',111),(927,3,'3111','111','Mens',111),(928,3,'3166B','166B','Neutral',111),(929,3,'3166C','166C','Neutral',111),(930,4,'4103','103','Womens',111),(931,4,'4111','111','Mens',111),(932,4,'4160','160','Neutral',111),(933,4,'4162','162','Neutral',111),(934,5,'5103','103','Womens',111),(935,5,'5105','105','Mens',111),(936,5,'5147','147','Neutral',111),(937,6,'6103','103','Womens',111),(938,6,'6105','105','Mens',111),(939,6,'6154','154','Womens',111),(940,0,'0101','101','Neutral',112),(941,1,'1111','111','Mens',113),(942,1,'1114','114','Neutral',113),(943,1,'1119','119','Womens',113),(944,1,'1209','209','Neutral',113),(945,0,'0104','104','Neutral',114),(946,0,'0106','106','Mens',114),(947,0,'0108','108','Womens',114),(948,1,'1103','103','Mens',114),(949,1,'1113','113','Womens',114),(950,1,'1220','220','Neutral',114),(951,2,'2203','203','Neutral',114),(952,2,'2222','222','Womens',114),(953,2,'2224','224','Neutral',114),(954,2,'2226','226','Mens',114),(955,3,'3203','203','Neutral',114),(956,3,'3222','222','Womens',114),(957,3,'3224','224','Neutral',114),(958,3,'3226','226','Mens',114),(959,4,'4203','203','Neutral',114),(960,4,'4222','222','Womens',114),(961,4,'4224','224','Neutral',114),(962,4,'4226','226','Mens',114),(963,5,'5203','203','Neutral',114),(964,5,'5222','222','Womens',114),(965,5,'5224','224','Neutral',114),(966,5,'5226','226','Mens',114),(967,6,'6203','203','Neutral',114),(968,6,'6222','222','Womens',114),(969,6,'6224','224','Neutral',114),(970,6,'6226','226','Mens',114),(971,7,'7203','203','Neutral',114),(972,7,'7222','222','Womens',114),(973,7,'7224','224','Neutral',114),(974,7,'7226','226','Mens',114),(975,0,'0101','101','Womens',115),(976,0,'0111','111','Mens',115),(977,2,'2115','115','Womens',115),(978,2,'2117','117','Mens',115),(979,1,'1106','106','Womens',116),(980,1,'1108','108','Mens',116),(981,0,'0104','104','Womens',117),(982,0,'0105','105','Mens',117),(983,0,'0108B','108B','Womens',117),(984,0,'0109B','109B','Mens',117),(985,1,'1106','106','Family',117),(986,2,'2103','103','Womens',117),(987,2,'2103A','103A','Womens',117),(988,2,'2104','104','Mens',117),(989,2,'2104A','104A','Mens',117),(990,1,'1103','103','Neutral',118),(991,1,'1101','101','Mens',119),(992,1,'1103','103','Womens',119),(993,0,'0101A','101A','Neutral',120),(994,1,'1119','119','Womens',120),(995,1,'1121','121','Mens',120),(996,0,'0101C','101C','Mens',120),(997,0,'0109','109','Womens',121),(998,0,'0115','115','Mens',121),(999,0,'0123','123','Mens',121),(1000,0,'0123A','123A','Mens',121),(1001,0,'0124','124','Womens',121),(1002,0,'0124A','124A','Womens',121),(1003,0,'0126C','126C','Womens',121),(1004,0,'0127','127','Neutral',121),(1005,0,'0130D','130D','Mens',121),(1006,0,'0309','309','Womens',121),(1007,0,'0313','313','Mens',121),(1008,1,'1120A','120A','Womens',121),(1009,1,'1120B','120B','Mens',121),(1010,1,'1238','238','Mens',121),(1011,1,'1240','240','Womens',121),(1012,1,'1309','309','Womens',121),(1013,1,'1311','311','Mens',121),(1014,2,'2117','117','Family',121),(1015,2,'2119','119','Womens',121),(1016,2,'2237','237','Mens',121),(1017,2,'2331','331','Mens',121),(1018,2,'2335','335','Womens',121),(1019,3,'3304','304','Womens',121),(1020,3,'3308','308','Mens',121),(1021,0,'0105','105','Womens',122),(1022,0,'0109','109','Mens',122),(1023,1,'1105','105','Womens',122),(1024,1,'1107','107','Neutral',122),(1025,1,'1109','109','Mens',122),(1026,2,'2105','105','Womens',122),(1027,2,'2109','109','Mens',122),(1028,0,'0503','503','Mens',123),(1029,0,'0505','505','Womens',123),(1030,0,'0600S','600S','Womens',123),(1031,0,'0600U','600U','Mens',123),(1032,1,'1303','303','Womens',123),(1033,1,'1305','305','Mens',123),(1034,1,'1600D','600D','Mens',123),(1035,1,'1600G','600G','Womens',123),(1036,2,'2303','303','Mens',123),(1037,2,'2304','304','Womens',123),(1038,0,'0103','103','Neutral',124),(1039,0,'0109','109','Mens',124),(1040,0,'0111','111','Womens',124),(1041,0,'0609','609','Mens',124),(1042,0,'0611','611','Womens',124),(1043,0,'0722','722','Mens',124),(1044,0,'0724','724','Womens',124),(1045,1,'1109','109','Mens',124),(1046,1,'1111','111','Womens',124),(1047,1,'1305','305','Womens',124),(1048,1,'1305A','305A','Womens',124),(1049,1,'1306','306','Mens',124),(1050,1,'1306A','306A','Mens',124),(1051,1,'1610','610','Mens',124),(1052,1,'1614','614','Womens',124),(1053,0,'0101','101','Neutral',125),(1054,1,'1111A','111A','Neutral',125),(1055,1,'1204','204','Mens',125),(1056,1,'1206','206','Womens',125),(1057,1,'1206A','206A','Womens',125),(1058,1,'1112','112','Mens',126),(1059,1,'1114','114','Womens',126),(1060,0,'0111','111','Mens',127),(1061,0,'0111B','111B','Mens',127),(1062,1,'1111','111','Womens',127),(1063,2,'2107','107','Womens',127),(1064,3,'3109','109','Mens',127),(1065,0,'0106','106','Womens',128),(1066,0,'0107','107','Mens',129),(1067,0,'0108','108','Womens',129),(1068,0,'0145','145','Neutral',129),(1069,1,'1101','101','Mens',129),(1070,1,'1103','103','Womens',129),(1071,1,'1126','126','Neutral',129),(1072,1,'1126A','126A','Neutral',129),(1073,1,'1128','128','Neutral',129),(1074,1,'1128A','128A','Neutral',129),(1075,1,'1145','145','Mens',129),(1076,1,'1149','149','Womens',129),(1077,2,'2103','103','Mens',129),(1078,2,'2105','105','Womens',129),(1079,2,'2145','145','Womens',129),(1080,2,'2147','147','Mens',129),(1081,3,'3115','115','Womens',129),(1082,3,'3117','117','Mens',129),(1083,0,'0101','101','Mens',130),(1084,0,'0103','103','Womens',130),(1085,0,'0120','120','Family',130),(1086,0,'0233','233','Womens',130),(1087,0,'0234','234','Mens',130),(1088,1,'1106A','106A','Mens',130),(1089,1,'1205','205','Womens',130),(1090,1,'1232','232','Womens',130),(1091,1,'1233','233','Mens',130),(1092,2,'2104','104','Mens',130),(1093,2,'2105','105','Womens',130),(1094,2,'2115','115','Womens',130),(1095,2,'2205','205','Mens',130),(1096,2,'2206','206','Womens',130),(1097,3,'3101','101','Neutral',130),(1098,3,'3102','102','Neutral',130),(1099,0,'B0102','102','Neutral',130),(1100,0,'B0104','104','Neutral',130),(1101,0,'B0106U','106U','Womens',130),(1102,0,'B0106V','106V','Mens',130),(1103,0,'B0111D','111D','Neutral',130),(1104,0,'B0113A','113A','Neutral',130),(1105,0,'B0220','220','Mens',130),(1106,0,'B0222','222','Womens',130),(1107,1,'1102','102','Mens',131),(1108,1,'1102A','102A','Mens',131),(1109,1,'1106','106','Womens',131),(1110,2,'2102','102','Mens',131),(1111,2,'2102A','102A','Mens',131),(1112,2,'2106','106','Womens',131),(1113,3,'3104','104','Mens',131),(1114,3,'3110','110','Womens',131),(1115,4,'4102','102','Mens',131),(1116,4,'4106','106','Womens',131),(1117,0,'0103','103','Womens',132),(1118,0,'0125','125','Mens',132),(1119,0,'0125B','125B','Mens',132),(1120,0,'0202','202','Womens',132),(1121,0,'0203','203','Mens',132),(1122,1,'1101','101','Mens',132),(1123,1,'1101A','101A','Mens',132),(1124,1,'1125','125','Womens',132),(1125,1,'1125A','125A','Womens',132),(1126,2,'2101','101','Womens',132),(1127,2,'2101A','101A','Womens',132),(1128,2,'2125','125','Mens',132),(1129,2,'2125B','125B','Mens',132),(1130,0,'0104','104','Mens',133),(1131,0,'0106','106','Womens',133),(1132,0,'0127','127','Womens',133),(1133,0,'0129','129','Mens',133),(1134,1,'1127','127','Mens',133),(1135,1,'1129','129','Womens',133),(1136,2,'2153','153','Mens',133),(1137,2,'2157','157','Neutral',133),(1138,2,'2159','159','Womens',133),(1139,3,'3105','105','Neutral',133),(1140,0,'0206','206','Womens',134),(1141,0,'0215','215','Mens',134),(1142,0,'0302','302','Family',134),(1143,0,'0324','324','Family',134),(1144,1,'1212','212','Womens',134),(1145,1,'1216','216','Mens',134),(1146,1,'1302','302','Mens',134),(1147,1,'1304','304','Womens',134),(1148,2,'2212','212','Womens',134),(1149,2,'2216','216','Mens',134),(1150,3,'3212','212','Womens',134),(1151,3,'3216','216','Mens',134),(1152,0,'B0302','302','Mens',134),(1153,0,'B0304','304','Womens',134),(1154,1,'1196','196','Womens',135),(1155,1,'1197','197','Mens',135),(1156,2,'2196','196','Womens',135),(1157,2,'2197','197','Mens',135),(1158,3,'3196','196','Womens',135),(1159,3,'3197','197','Mens',135),(1160,1,'1110','110','Womens',136),(1161,1,'1114','114','Mens',136),(1162,2,'2110','110','Womens',136),(1163,2,'2114','114','Mens',136),(1164,3,'3110','110','Womens',136),(1165,3,'3114','114','Mens',136),(1166,4,'4110','110','Womens',136),(1167,4,'4114','114','Mens',136),(1168,1,'1110','110','Mens',137),(1169,1,'1112','112','Womens',137),(1170,1,'1103','103','Mens',138),(1171,1,'1105','105','Womens',138),(1172,0,'0105','105','Mens',139),(1173,0,'0125','125','Womens',139),(1174,0,'0125A','125A','Womens',139),(1175,1,'1124','124','Mens',139),(1176,1,'1131','131','Womens',139),(1177,1,'1131A','131A','Womens',139),(1178,2,'2125','125','Mens',139),(1179,2,'2132','132','Womens',139),(1180,2,'2132A','132A','Womens',139),(1181,3,'3124','124','Mens',139),(1182,3,'3131A','131A','Womens',139),(1183,4,'4125','125','Mens',139),(1184,4,'4126','126','Womens',139),(1185,4,'4126A','126A','Womens',139),(1186,1,'1124','124','Womens',140),(1187,1,'1126','126','Mens',140),(1188,2,'2107','107','Womens',140),(1189,2,'2111','111','Mens',140),(1190,2,'2130D','130D','Womens',140),(1191,2,'2130E','130E','Mens',140),(1192,2,'2143','143','Family',140),(1193,2,'2145','145','Family',140),(1194,2,'2147','147','Mens',140),(1195,2,'2149','149','Womens',140),(1196,3,'3107','107','Womens',140),(1197,3,'3111','111','Mens',140),(1198,3,'3123','123','Mens',140),(1199,3,'3131','131','Mens',140),(1200,3,'3143','143','Family',140),(1201,3,'3145','145','Family',140),(1202,3,'3147','147','Mens',140),(1203,3,'3149','149','Womens',140),(1204,4,'4107','107','Womens',140),(1205,4,'4111','111','Mens',140),(1206,4,'4123','123','Mens',140),(1207,4,'4131','131','Mens',140),(1208,4,'4143','143','Family',140),(1209,4,'4145','145','Family',140),(1210,4,'4147','147','Mens',140),(1211,4,'4149','149','Womens',140),(1212,5,'5107','107','Womens',140),(1213,5,'5111','111','Mens',140),(1214,5,'5123','123','Mens',140),(1215,5,'5131','131','Womens',140),(1216,1,'1124','124','Mens',141),(1217,1,'1124A','124A','Mens',141),(1218,1,'1125','125','Womens',141),(1219,1,'1125A','125A','Womens',141),(1220,1,'1133','133','Family',141),(1221,1,'1112','112','Womens',142),(1222,1,'1114','114','Mens',142),(1223,1,'1131','131','Mens',143),(1224,1,'1131A','131A','Mens',143),(1225,1,'1135','135','Womens',143),(1226,1,'1135B','135B','Womens',143),(1227,1,'1200','200','Womens',143),(1228,1,'1304','304','Mens',143),(1229,1,'1329','329','Mens',143),(1230,1,'1331','331','Womens',143),(1231,1,'1404','404','Womens',143),(1232,1,'1502','502','Mens',143),(1233,1,'1503','503','Womens',143),(1234,1,'1522','522','Womens',143),(1235,1,'1522A','522A','Womens',143),(1236,1,'1526','526','Mens',143),(1237,1,'1526A','526A','Mens',143),(1238,2,'2121','121','Mens',143),(1239,2,'2121A','121A','Mens',143),(1240,2,'2200','200','Womens',143),(1241,2,'2201','201','Mens',143),(1242,2,'2304','304','Mens',143),(1243,2,'2329','329','Mens',143),(1244,2,'2331','331','Womens',143),(1245,2,'2404','404','Womens',143),(1246,2,'2502','502','Mens',143),(1247,2,'2503','503','Womens',143),(1248,3,'3145','145','Mens',143),(1249,3,'3145A','145A','Mens',143),(1250,3,'3327','327','Mens',143),(1251,3,'3329','329','Womens',143),(1252,3,'3367','367','Mens',143),(1253,3,'3405','405','Womens',143),(1254,3,'3502','502','Mens',143),(1255,3,'3503','503','Womens',143),(1256,4,'4143','143','Mens',143),(1257,4,'4143A','143A','Mens',143),(1258,4,'4147','147','Womens',143),(1259,4,'4147B','147B','Womens',143),(1260,4,'4330','330','Mens',143),(1261,4,'4331','331','Womens',143),(1262,4,'4367','367','Mens',143),(1263,4,'4405','405','Womens',143),(1264,4,'4502','502','Mens',143),(1265,4,'4503','503','Womens',143),(1266,0,'0111','111','Neutral',144),(1267,1,'1109','109','Mens',145),(1268,1,'1113','113','Womens',145),(1269,2,'2105','105','Womens',145),(1270,2,'2111','111','Mens',145),(1271,1,'1208','208','Womens',146),(1272,1,'1208A','208A','Womens',146),(1273,1,'1210','210','Mens',146),(1274,1,'1210A','210A','Mens',146),(1275,0,'0104A','104A','Neutral',147),(1276,0,'0204','204','Mens',148),(1277,0,'0212','212','Womens',148),(1278,0,'0412','412','Womens',148),(1279,1,'1204','204','Mens',148),(1280,1,'1212','212','Womens',148),(1281,1,'1403D','403D','Mens',148),(1282,1,'1403E','403E','Womens',148),(1283,2,'2206','206','Mens',148),(1284,2,'2212','212','Womens',148),(1285,2,'2403C','403C','Mens',148),(1286,2,'2403D','403D','Womens',148),(1287,3,'3204','204','Mens',148),(1288,3,'3210','210','Womens',148),(1289,3,'3403B','403B','Mens',148),(1290,3,'3403C','403C','Womens',148),(1291,4,'4122','122','Mens',148),(1292,4,'4210','210','Womens',148),(1293,4,'4422','422','Mens',148),(1294,0,'B0434','434','Mens',148),(1295,1,'1105','105','Mens',149),(1296,2,'2105A','105A','Womens',149),(1297,2,'2105B','105B','Mens',149),(1298,0,'0114','114','Mens',150),(1299,0,'0117','117','Womens',150),(1300,1,'1134','134','Womens',150),(1301,1,'1135','135','Mens',150),(1302,0,'0111B','111B','Womens',151),(1303,0,'0111C','111C','Mens',151),(1304,1,'1106','106','Mens',152),(1305,1,'1106A','106A','Mens',152),(1306,1,'1108','108','Womens',152),(1307,2,'2110','110','Womens',152),(1308,2,'2112','112','Mens',152),(1309,1,'1107A','107A','Womens',153),(1310,1,'1107B','107B','Mens',153),(1311,1,'1102A','102A','Neutral',154),(1312,1,'1201A','201A','Neutral',154),(1313,0,'0409','409','Womens',155),(1314,0,'0411','411','Family',155),(1315,0,'0413','413','Mens',155),(1316,0,'0605','605','Womens',155),(1317,0,'0606','606','Mens',155),(1318,2,'2102','102','Womens',155),(1319,2,'2108','108','Mens',155),(1320,2,'2109','109','Family',155),(1321,2,'2115','115','Womens',155),(1322,2,'2117','117','Womens',155),(1323,2,'2119','119','Mens',155),(1324,2,'2203','203','Mens',155),(1325,2,'2205','205','Womens',155),(1326,2,'2311','311','Womens',155),(1327,2,'2313','313','Mens',155),(1328,2,'2403','403','Mens',155),(1329,2,'2405','405','Womens',155),(1330,2,'2407','407','Womens',155),(1331,2,'2414','414','Mens',155),(1332,2,'2420','420','Womens',155),(1333,2,'2421','421','Family',155),(1334,2,'2602','602','Womens',155),(1335,2,'2705','705','Mens',155),(1336,3,'3104','104','Womens',155),(1337,3,'3106','106','Mens',155),(1338,3,'3108','108','Mens',155),(1339,3,'3110','110','Womens',155),(1340,3,'3112','112','Womens',155),(1341,3,'3202','202','Mens',155),(1342,3,'3204','204','Womens',155),(1343,3,'3206','206','Womens',155),(1344,3,'3208','208','Mens',155),(1345,3,'3210','210','Mens',155),(1346,3,'3212','212','Family',155),(1347,3,'3214','214','Womens',155),(1348,3,'3302','302','Womens',155),(1349,3,'3306','306','Mens',155),(1350,3,'3308','308','Mens',155),(1351,3,'3310','310','Womens',155),(1352,3,'3312','312','Womens',155),(1353,3,'3314','314','Mens',155),(1354,3,'3402','402','Womens',155),(1355,3,'3404','404','Womens',155),(1356,3,'3406','406','Mens',155),(1357,3,'3408','408','Mens',155),(1358,3,'3410','410','Womens',155);
/*!40000 ALTER TABLE `bathrooms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `buildings`
--
DROP TABLE IF EXISTS `buildings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `buildings` (
`building_id` int(11) NOT NULL AUTO_INCREMENT,
`building_name` text NOT NULL,
PRIMARY KEY (`building_id`)
) ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `buildings`
--
LOCK TABLES `buildings` WRITE;
/*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
INSERT INTO `buildings` VALUES (1,'4-H HEADQUARTERS'),(2,'A. JAMES CLARK HALL'),(3,'A.V. WILLIAMS BUILDING'),(4,'ANIMAL SCIENCES/AGRIC. ENGRG B'),(5,'ANNAPOLIS HALL'),(6,'ANNE ARUNDEL HALL'),(7,'AQUATIC CENTER'),(8,'ARBORETUM OUTREACH CENTER'),(9,'ARCHITECTURE BUILDING'),(10,'ART HOUGHTON JR. OFFICE LAB'),(11,'ARTEMESIA BUILDING'),(12,'ASTRONOMICAL OBSERVATORY'),(13,'ASTRONOMY LECTURE BUILDING'),(14,'ATLANTIC BUILDING'),(15,'AVRUM GUDELSKY VETERINARY CENT'),(16,'BEL AIR HALL'),(17,'BENJAMIN BUILDING'),(18,'BIOLOGY-PSYCHOLOGY BUILDING'),(19,'BIOMOLECULAR SCIENCES BUILDING'),(20,'BIOSCIENCE RESEARCH BUILDING'),(21,'BOB \"TURTLE\"\" SMITH STADIUM AT \"'),(22,'BRENDAN IRIBE CENTER'),(23,'CALVERT HALL'),(24,'CAMBRIDGE COMMUNITY CENTER'),(25,'CAROLINE HALL'),(26,'CENTRAL MD OFFICE'),(27,'CENTRAL MD OFFICE ANNEX'),(28,'CENTREVILLE HALL'),(29,'CHEMICAL & NUCLEAR ENGINEERING'),(30,'CHEMISTRY BUILDING'),(31,'CHESAPEAKE BUILDING'),(32,'CHESTERTOWN HALL'),(33,'CHINCOTEAGUE HALL'),(34,'CLARENCE M. MITCHELL, JR. BUIL'),(35,'CLARICE SMITH PERFORMING ARTS '),(36,'CLARKSVILLE OFFICE'),(37,'COLE STUDENT ACTIVITIES BUILDI'),(38,'COLLEGE PARK FIRE STATION'),(39,'COMPUTER SCIENCE INSTRUCTIONAL'),(40,'CUMBERLAND HALL'),(41,'DENTON AREA DINING HALL'),(42,'DENTON HALL'),(43,'DORCHESTER HALL'),(44,'EASTON HALL'),(45,'EDWARD ST. JOHN LEARNING AND T'),(46,'ELKTON HALL'),(47,'ELLICOTT AREA DINING HALL'),(48,'ELLICOTT HALL'),(49,'ENERGY RESEARCH FACILITY'),(50,'ENGINEERING ANNEX'),(51,'ENGINEERING LABORATORY BUILDIN'),(52,'EPPLEY RECREATION CENTER'),(53,'FIELD HOCKEY AND LACROSSE COMP'),(54,'FRANCIS SCOTT KEY HALL'),(55,'GEOLOGY BUILDING'),(56,'GOLF COURSE CLUB HOUSE'),(57,'GOLF COURSE TOILET FACILITY'),(58,'GOSSETT FOOTBALL TEAM HOUSE'),(59,'H.J. PATTERSON HALL'),(60,'HAGERSTOWN HALL'),(61,'HARFORD HALL'),(62,'HEALTH CENTER'),(63,'HORNBAKE LIBRARY'),(64,'IBBR 1'),(65,'IBBR 2'),(66,'INSTITUTE FOR PHYSICAL SCIENCE'),(67,'J.M. PATTERSON BUILDING'),(68,'JIMENEZ HALL'),(69,'JOHN S. TOLL PHYSICS BUILDING'),(70,'JULL HALL'),(71,'KEHOE TRACK AT LUDWIG FIELD'),(72,'KIM ENGINEERING BUILDING'),(73,'KNIGHT HALL'),(74,'LA PLATA HALL'),(75,'LABORATORY FOR PHYSICAL SCIENC'),(76,'LEE BUILDING'),(77,'LEFRAK HALL'),(78,'LEONARDTOWN COMMUNITY CENTER'),(79,'LEONARDTOWN OFFICE BUILDING'),(80,'LOWER EASTERN SHORE OFFICE'),(81,'LOWER EASTERN SHORE OFFICE ANN'),(82,'MAIN ADMINISTRATION BUILDING'),(83,'MANUFACTURING BUILDING'),(84,'MARIE MOUNT HALL'),(85,'MARTIN HALL'),(86,'MARYLAND SOFTBALL STADIUM'),(87,'MARYLAND STADIUM BUILDING (UPP'),(88,'MARYLAND STADIUM CONCESSIONS 1'),(89,'MARYLAND STADIUM CONCESSIONS 2'),(90,'MARYLAND STADIUM CONCESSIONS 3'),(91,'MARYLAND STADIUM CONCESSIONS 4'),(92,'MARYLAND STADIUM CONCESSIONS 5'),(93,'MARYLAND STADIUM CONCESSIONS 6'),(94,'MCKELDIN LIBRARY'),(95,'MEMORIAL CHAPEL'),(96,'MFRI MAZE/STORAGE (LOWER EASTE'),(97,'MFRI MAZE/STORAGE (NORTHEAST)'),(98,'MFRI MAZE/STORAGE (W. MD)'),(99,'MFRI OFFICE/CLASSROOM BUILDING'),(100,'MFRI OFFICE/CLASSROOM BUILIDNG'),(101,'MICROBIOLOGY BUILDING'),(102,'MORRILL HALL'),(103,'MOWATT LANE SUBSTATION'),(104,'NEUTRAL BUOYANCY RESEARCH FACI'),(105,'NYUMBURU CULTURAL CENTER'),(106,'OAKLAND HALL'),(107,'PARREN J. MITCHELL ART-SOCIOLO'),(108,'PATAPSCO BUILDING'),(109,'PATUXENT BUILDING'),(110,'PHYSICAL SCIENCES COMPLEX'),(111,'PLANT SCIENCES BUILDING'),(112,'POCOMOKE BUILDING'),(113,'PREINKERT HALL'),(114,'PRINCE FREDERICK HALL'),(115,'RECKORD ARMORY'),(116,'RESEARCH GREENHOUSE'),(117,'RITCHIE COLISEUM'),(118,'ROSSBOROUGH INN'),(119,'SALISBURY SUPPORT'),(120,'SATELLITE CENTRAL UTILITIES BU'),(121,'SCHOOL OF PUBLIC HEALTH BUILDI'),(122,'SENECA BUILDING'),(123,'SERVICE BUILDING'),(124,'SEVERN BUILDING'),(125,'SHOEMAKER BUILDING'),(126,'SHUTTLE BUS FACILITY'),(127,'SKINNER BUILDING'),(128,'SOMERSET HALL'),(129,'SOUTH CAMPUS DINING HALL'),(130,'STAMP STUDENT UNION'),(131,'SUSQUEHANNA HALL'),(132,'SYMONS HALL'),(133,'TALIAFERRO HALL'),(134,'TAWES HALL'),(135,'TECHNOLOGY ADVANCEMENT PROGRAM'),(136,'TECHNOLOGY VENTURES BUILDING'),(137,'TURFGRASS RESEARCH FACILITY (P'),(138,'TURNER HALL'),(139,'TYDINGS HALL'),(140,'TYSER TOWER'),(141,'UNIVERSITY HOUSE'),(142,'UPPER MARLBORO OFFICE LAB'),(143,'VAN MUNCHING HALL'),(144,'VARSITY SPORTS TEAMHOUSE'),(145,'WESTERN MD OFFICE'),(146,'WESTERN MD SUPPORT'),(147,'WICOMICO HALL'),(148,'WILLIAM E. KIRWAN HALL'),(149,'WIND TUNNEL BUILDING'),(150,'WOODS HALL'),(151,'WORCESTER HALL'),(152,'WYE OAK BUILDING'),(153,'WYE OFFICE ANNEX'),(154,'WYE OFFICE/EQUIP MAINTENANCE'),(155,'XFINITY CENTER');
/*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reviews`
--
DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews` (
`review_id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` text NOT NULL,
`last_name` text NOT NULL,
`comment` text,
`cleanliness_score` tinyint(4) NOT NULL,
`odor_score` tinyint(4) NOT NULL,
`lighting_score` tinyint(4) NOT NULL,
`solitude_score` tinyint(4) NOT NULL,
`overall_rating` tinyint(4) NOT NULL,
`bathroom_id` int(11) NOT NULL,
PRIMARY KEY (`review_id`),
KEY `bathroom_key` (`bathroom_id`),
CONSTRAINT `bathroom_key` FOREIGN KEY (`bathroom_id`) REFERENCES `bathrooms` (`bathroom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reviews`
--
LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-05-17 19:42:05