-
Notifications
You must be signed in to change notification settings - Fork 9
/
script.sql
265 lines (212 loc) · 67 KB
/
script.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
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
-- MySQL dump 10.13 Distrib 5.7.11, for Linux (x86_64)
--
-- Host: localhost Database: BetterU
-- ------------------------------------------------------
-- Server version 5.7.11
/*!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 `Challenges`
--
DROP TABLE IF EXISTS `Challenges`;
DROP TABLE IF EXISTS `Progress`;
DROP TABLE IF EXISTS `DailyChallenges`;
DROP TABLE IF EXISTS `WeeklyChallenges`;
DROP TABLE IF EXISTS `UserIndex`;
DROP TABLE IF EXISTS `UsersProgress`;
DROP TABLE IF EXISTS `User`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Challenges` (
`Name` varchar(255) NOT NULL,
`ChallengeType` varchar(255) DEFAULT NULL,
`Description` varchar(255) DEFAULT NULL,
`GoalType` int(11) DEFAULT NULL,
`Ind` int(11) DEFAULT NULL,
`PointsAwarded` int(11) DEFAULT NULL,
PRIMARY KEY (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Challenges`
--
LOCK TABLES `Challenges` WRITE;
/*!40000 ALTER TABLE `Challenges` DISABLE KEYS */;
/*!40000 ALTER TABLE `Challenges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `DailyChallenges`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DailyChallenges` (
`ChallengeName` varchar(255) NOT NULL,
`Description` varchar(255) NOT NULL,
`ChallengeType` varchar(255) NOT NULL,
`PointsAwarded` int(11) NOT NULL,
`Ind` int(11) NOT NULL,
PRIMARY KEY (`ChallengeName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `DailyChallenges`
--
LOCK TABLES `DailyChallenges` WRITE;
/*!40000 ALTER TABLE `DailyChallenges` DISABLE KEYS */;
INSERT INTO `DailyChallenges` VALUES ('Bike-Crunches-1','Do 3 sets of 15 bike-crunches.','Core',10,4),('Bike-Crunches-2','Do 3 sets of 20 bike-crunches.','Core',20,5),('Bike-Crunches-3','Do 3 sets of 10 bike-crunches.','Core',30,6),('Burpee-1','Do 3 sets of 10 burpees.','Cardio',10,11),('Burpee-2','Do 3 sets of 15 burpees.','Cardio',20,12),('Burpee-3','Do 3 sets of 20 burpees.','Cardio',30,13),('Chin-ups-1','Do 3 sets of 3 chin-ups.','Upper',10,4),('Chin-ups-2','Do 3 sets of 5 chin-ups.','Upper',20,5),('Chin-ups-3','Do 3 sets of 7 chin-ups.','Upper',30,6),('Crunches-1','Do 3 sets of 10 crunches.','Core',10,1),('Crunches-2','Do 3 sets of 15 crunches.','Core',20,2),('Crunches-3','Do 3 sets of 20 crunches.','Core',30,3),('Dips-1','Do 3 sets of 10 dips.','Upper',10,7),('Dips-2','Do 3 sets of 12 dips.','Upper',20,8),('Dips-3','Do 3 sets of 15 dips.','Upper',30,9),('Jumping-Jacks-1','Do 3 sets of 15 jumping jacks.','Lower',10,7),('Jumping-Jacks-2','Do 3 sets of 30 jumping jacks.','Lower',20,8),('Jumping—Jacks-3','Do 3 sets of 45 jumping jacks.','Lower',30,9),('Lunges-1','Do 3 sets of 15 bodyweight lunges.','Lower',10,4),('Lunges-2','Do 3 sets of 25 bodyweight lunges.','Lower',20,5),('Lunges-3','Do 3 sets of 35 bodyweight lunges.','Lower',30,6),('Mt.Climbers-1','Do 3 sets of 20 Mt.Climbers.','Core',10,10),('Mt.Climbers-2','Do 3 sets of 30 Mt.Climbers.','Core',20,11),('Mt.Climbers-3','Do 3 sets of 40 Mt.Climbers.','Core',30,12),('Plank-1','Hold 2 planks for 60 seconds.','Core',10,7),('Plank-2','Hold 2 planks for 90 seconds.','Core',20,8),('Plank-3','Hold 3 planks for 120 seconds.','Core',30,9),('Pulls-ups-1','Do 3 sets of 5 pull-ups.','Upper',10,10),('Pulls-ups-2','Do 3 sets of 8 pull-ups.','Upper',20,11),('Pulls-ups-3','Do 3 sets of 10 pull-ups.','Upper',30,12),('Push-up-1','Do 3 sets of 10 pushups.','Upper',10,1),('Push-up-2','Do 4 sets of 10 pushups.','Upper',20,2),('Push-up-3','Do 5 sets of 10 pushups.','Upper',30,3),('Run-1','Run 1 mile in 10 minutes.','Cardio',10,4),('Run-2','Run 1 mile in 9 minutes.','Cardio',20,5),('Run-3','Run 1 mile in 8 minutes.','Cardio',30,6),('Run-4','Run 1 mile in 7 minutes.','Cardio',40,7),('Sprint-1','Do 4 100 yard sprints.','Cardio',10,8),('Sprint-2','Do 6 100 yard sprints.','Cardio',20,9),('Sprint-3','Do 8 100 yard sprints.','Cardio',30,10),('Squat-Jogs-1','Run 400 yards as a squat-jog.','Lower',10,10),('Squat-Jogs-2','Run 500 yards as a squat-jog.','Lower',20,11),('Squat-Jogs-3','Run 600 yards as a squat-jog.','Lower',30,12),('Squat-Jogs-4','Run 800 yards as a squat-jog.','Lower',40,13),('Squats-1','Do 3 sets of 10 bodyweight squats.','Lower',10,1),('Squats-2','Do 3 sets of 20 bodyweight squats.','Lower',20,2),('Squats-3','Do 3 sets of 30 bodyweight squats.','Lower',30,3),('Walk-1','Walk for 15 minutes.','Cardio',10,1),('Walk-2','Walk for 20 minutes.','Cardio',20,2),('Walk-3','Walk for 25 minutes.','Cardio',30,3);
/*!40000 ALTER TABLE `DailyChallenges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `WeeklyChallenges`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `WeeklyChallenges` (
`ChallengeName` varchar(255) NOT NULL,
`Description` varchar(255) NOT NULL,
`PointsAwarded` int(11) NOT NULL,
`Ind` int(11) NOT NULL,
PRIMARY KEY (`ChallengeName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `WeeklyChallenges`
--
LOCK TABLES `WeeklyChallenges` WRITE;
/*!40000 ALTER TABLE `WeeklyChallenges` DISABLE KEYS */;
INSERT INTO `WeeklyChallenges` VALUES ('Max-out-bench','Max out your bench this week.',10,1),('Max-out-dl','Max out your deadlift this week.',10,3),('Max-out-ohp','Max out your overhead press this week.',10,4),('Max-out-squat','Max out your squat this week.',10,2),('Run-10-Miles','Run a total of 10 miles in a week.',10,7),('Run-5-miles','Run a total of 5 miles in a week.',10,5),('Run-8-miles','Run a total of 8 miles in a week.',10,6);
/*!40000 ALTER TABLE `WeeklyChallenges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `User`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `User` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`FirstName` varchar(255) NOT NULL,
`LastName` varchar(255) NOT NULL,
`Username` varchar(255) NOT NULL,
`Password` varchar(64) NOT NULL,
`Age` int(11) NOT NULL,
`Gender` char(1) NOT NULL,
`Height` int(11) NOT NULL,
`Weight` int(11) NOT NULL,
`Units` char(1) NOT NULL,
`Email` varchar(255) NOT NULL,
`Points` int(11) NOT NULL,
`ActivityLevel` int(11) NOT NULL,
`BMR` int(11) NOT NULL,
`GoalType` int(11) DEFAULT '0',
`GoalWeight` int(11) NOT NULL,
`ActivityGoal` varchar(255) NOT NULL,
`DailyChallengeIndex` int(11) DEFAULT NULL,
`DCSkipped` varchar(255) DEFAULT NULL,
`WeeklyChallengeIndex` int(11) DEFAULT NULL,
`WCSkipped` varchar(255) DEFAULT NULL,
`SecurityQuestion` int(11) NOT NULL,
`SecurityAnswer` varchar(255) NOT NULL,
`TargetCalories` int(11) DEFAULT NULL,
`Breakfast` varchar(255) DEFAULT '',
`Lunch` varchar(255) DEFAULT '',
`Dinner` varchar(255) DEFAULT '',
`Snack` varchar(255) DEFAULT '',
`Photo` varchar(62000) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `Progress`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Progress` (
`UserId` int(11) NOT NULL,
`LogDate` int(11) NOT NULL,
`CaloriesIn` int(11) DEFAULT NULL,
`CaloriesOut` int(11) DEFAULT NULL,
`Miles` double DEFAULT NULL,
`Steps` int(11) DEFAULT NULL,
`Weight` double DEFAULT '0',
PRIMARY KEY (`UserId`,`LogDate`),
CONSTRAINT `Progress_ibfk_1` FOREIGN KEY (`UserId`) REFERENCES `User` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `User`
--
LOCK TABLES `User` WRITE;
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
INSERT INTO `User` VALUES (14,'John','Black','brobohn','12345678',0,'M',72,210,'I','[email protected]',240,0,0,0,0,'0',0,'0',0,'0',0,'blank',1800,'','','','','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAhIAAAISCAMAAACu49aNAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYwIDYxLjEzNDc3NywgMjAxMC8wMi8xMi0xNzozMjowMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNSBNYWNpbnRvc2giIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MEQyQzNERDE0QTgzMTFFMUI0N0FDQ0U5NDgzQTI2NEYiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MEQyQzNERDI0QTgzMTFFMUI0N0FDQ0U5NDgzQTI2NEYiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDowRDJDM0RDRjRBODMxMUUxQjQ3QUNDRTk0ODNBMjY0RiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDowRDJDM0REMDRBODMxMUUxQjQ3QUNDRTk0ODNBMjY0RiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PmY2mEcAAAGAUExURevr7Jydn5manJucnuPj5JiZm9vb3PT09MvLzMLCw5GSlPr6+qeoqdXV1tHR0rW1trW2uKusrbi4urO0tLq6vKiqq7e4uLW2tqGipLm6ury8vr6+vr+/wLu8vM7OztDQ0cjJytjY2dTU1aipqqqrrMXGxqanqKmqq6Wmp9LT062usKSlprS0ta2trra2t6ytrqWmqK2ur66vsK6ur7CwsbOztK+vsK+wsbKys7GxsqOkpqOkpZ6foampq6qqrJ2eoKenqaysraKjpZqbnbi4uaKjpKSlp5eYmqioqqurrKChory8vKGio6amqKCho7Gys7CxsrGysrKzs5+gop+gobS1tbq6u7e3uLCxsbKztLi4uJWWmJaXmba3t7i5ub29vZWXmZSWmLq6upOVl5SVl7m5up6foLq7u7u7vJqcnZOUlpeZm5aYmpKUlry8vZKTlpGTlZCRlJCRk6ytr9bX197e3q+vsb2+v8DAweDh4bOztebm5ujp6e/v756eoP///9/b0aAAABOCSURBVHja7N3texPHuYDxpdXRSqxtoG5NKViWjGXiIptaNnYhJEAPJU1pAj2Nk1BSBOUtpcXQUylIlbfzr3e1kmytsb1rve3MPvf9LV9yLfh3zTwzK2RLEQWy+CsgSBAkCBIECYIEQYIgQZAgSBAkCBIECYIEQYIgQZCgvRzXK5XulIKEyGzXbabThUwm8+LF41Z3uv35z/W0Awk5q0GjVstkii962y/C617yUVjiIXjrwfm/ep3zehEmYmZmJvEoxJJozmW/7vTX44iYmfkm4SgErxJuIduXCK9Eo5A9S9ieij5EeNVTkDD2p96stWt6x8mDVfQhwitvQcK86dGq5e55fd9TMTPp4Qgu+zvzfYjwqjqQMGpxmCzea/d9oFetvj6fKTS8NcN1vTVkLpPpS8Q3f5ndgYQpq0Ohy+EQEf2eNYIivPI2JPRfHlK5e72NVMTKyvc7kND7T1Mobt8bpwivnAMJbbeLyfr29thFrKxcsCCho4fmUmV7OxYRXjVIaPeHqFYqMYpI2OZhPgm3Wq/ELGJlJetCQpfzRa1YqcQv4uzZVxYktBggcpWKHiK8UpCIfYFobxi6iDh1KgWJeBeIfKWil4hTp6YgEd8Cka5X9BORFBMGknBzlYqWIhJiwjgSzWJFWxHJMGEWCaeWregsIhEzpkkk7OoHIHQTkQQTlkEgzlf0F7G15UJibCDMELF1zobEmEAYImJrKwuJ0Q+V6fMdEflcuma5urzXOFhEqTQJiRFXy3ogctWa216R3WJFbxGl0g4kRvqAmVzNsg+4p9JXROmFA4lRjhGB/1iqGCCiVMpAYlwzRcUMEWZvHQaRaNaNEVGqOJAY/QaSq5gjolRKQ2KMe4YJIkqPHUiMNLdomIjSdHeZcK1CJ8uCxGiWCDNETHvLhNOcz15t9dDr/1ptz9VcSAx7iTBExPT0XOZqp10Rv261PdeExICXlxUjRVy9erCIVn+ZdyHR/6aRS56I+17FFCT63DSyyRRx/49/nE1BYvBNI0kivL5PQeK4m8ZSokVcu3ataEHiWPeV+aSL8NLw35zrS8LOChBx7dpKExIRa8oQce3BAwsS0URUpIh4kIMEIgIiHjywIRFeVZKIbwuQQERAxLdnIYGIgIhvv21A4uhS0kSsX4AEk2VAxPq6CwlEBESsL0HiiDtLiSLWT0FC+i32PhHr6w1IHPbuMy9TxHoeEoe0JFTE+roNiUjHTzkiNtOQiDJaChKxeQ4SBw0SRbkiNjddSIQOErJEbC5B4sMnES1Co51DGxJOXbSIzU0LEvtKCxexmYNEMFe6iI0SJILlpIvY2GhC4tD3nzJFbOQg0VsREdrsHJZ2i4RUEdrsHJZui4RcEbrsHJZmi4RMEblSi8Q0JA5YJISuEWn3/MZGudyERKea+F0jq5xcuVzOQaJTnTmidX1bLj+GRCdEbLR+DI3psguJAAnBIjb8V+Pu9BQkei+zJYsol/2PaLvvIdFDQraI8rS/Z7g2JHZJCBfRNcEqsUtCvIhy+b0DiR4SiPDKQ2KPBCJarVUhESCBiLU1CxI9JBDhdceBxC4JRPgVIdF5x4GItU4WJPwQ0RWxNuNAohUiuq2uViHxAQnZIlYf2pDYR0K4iNXVNCSCJMSLWM1CQikXEXsiVh9CQqkmIvZErK5CQqkaInpELNuQUJOI6BGxbEFC5RDRIwISuyQQ0RYBCa88InpEQKJzLYGIrojlKiQUInpFQMIngYg9EZBokUBEjwhIeCGiVwQk9pMQL+IKJJSNiF4RkFDKRUSvCEgESCACEkESiIBEkAQiIBEkgQhIBEkgAhJBEoiARJAEIrrdhoR/VYWIXRGQ8C+0EbEn4nYDEgoRvSJu86kqpRDRKwISHRKI6Io4AwmfBCJ2RUDCJ4GIPRGQaJFARI8ISHgholcEJHpIIAISnTKI6BFxxoFEhwQiOilItEkgAhJBEoiARJAEIiARJIEISASqIaKnFUh0SCCiUx0SbRKIgESQBCK6fQ4JrwYi9kRAopWLiD0Rnxch0SaBiI6Izych4ZNARFfEAiR8EojYFQEJP0TsiYDEhySEi1hoQGIfCekiFixIBEmIFwGJ9qtQROyKgESQBCIgESSBCC8FCa8lRCxAIlAaEZA4gAQiINHzdhwRu9Uh4b/kQAQk9pNARLcLkPBJIKLbp0VI+CGiK+LTSUh0SSDCFwGJXRKIaIuARPdGGxEdEZ+mIBEkIV7EJQsSfjlEdERAonujjYiOiEs2JHpIIMJLQcIvhYiOCEh0ry8R0RFRhsQuCUT4XYBEJ0RcgkQwRHTKQ6JTHRHtJiHRvb5EBCT2XV8iol0KEt27KkS0syDRqYGIdi4kuk+BiEu6XF5qQsJGhN8nkNgNEb6IC5DY7R4iPBGQ6CmPCE/EJ/OQ2K2KiE8gETyFIqLVDiT2HgMRXhdtSOzmIMITsaogsVcRERcvZiHxwZFDtoiL85DoeYwiIi5ezDNedm6zq+wavohWj+dd6SScdJ3Jck9Eq+maaBKNe5w+94m4ePF3/06JJeHkuaE6QIRX1pFJwr6HiINFTEzccSSSQMThIuI0ER8Jp46Iw0V4JuSRyCHiKBETEzlpJHYQcbSIiQlXGIk6IkJETLyXRSKFiDARcS0TcZHIIyJUxEReEgkbEeEibi07gkg0EBEu4tatlCASeUREEHErL4gEIqKIuHVfDgkLEVFELC7aYkg0EBFJxOKOGBJVREQSsbgkhkQeEZFELObFkKgjIpKIxYoYEoiIJmLxvhQSDiKiiVhclELCQkREEZJIICKSiDguJmIigYhoIuK4mIiFRAoREUWIIZFGREQRMkkg4ggRX0gkgYijREgkgYgjRXxREEcCEUeL+GJJGglEhIj4SBoJRISJkEYCEaEihJFARLgIWSQQEUGEKBKIiCJCEglERBIhiAQioomQQwIREUXIIoGICCJEkUBEFBGSSCAikoiPUmJIICKaiI+kvBy3EBFRhFASiDhcxF1HCAkHERFF3FVCSChERBRxWgyJPCIiibhbF0NiEhGRRNyV8/0SKUREEnFXzrfQuIiIJOKyEkNCfY2IKCJOCyIxhYgIIi5nBJFIISKCiMs7gkg4iIggYkEJIqEyiAgVcbkoikQKEaEiLqdEkXAQESpiU4kioeYQESLi8pIwEhYiQkRctoWRUFlEHC2irqSRSCHiSBHxXErESkJVEHGUiFklj0QKEUeIiG2RiJNEZ5lAxIEiYlskYiWRQsShIuJbJGIl0Tp0IOJgEXUlk4SFiENELNhCSahJRBwoIq6LSw1IOI8RcZCI00osCbWDiANEXHYFk1DziPhQREFJJuFkEbFfxKwSTUK5dxARFLHpCCehLEQERCy4SjoJlUJEbykFCVVAxF41BQmvOUToI0IPEqqGCG1EaEJCpRDRmix3FCT2zqLfIOK0qyDRe2eVkS4i4yhIBGtuSxaxuaPLz0EjEsopbO+JWCmsJPybyZZ6RGzW9Pkx6ESitVLkZn0R9YKjisleI4rKzmy2PWR2dPoZaEaitVZYVvuhCsneNfx1wdnZ2dHtB6Afib1HS/YcYWv7964vCbWSZBGbChLHL5/ks0YGEv1ccyf59JmCRD83mkm+j3Ag0U+vkitiVkGin3LJvbMsQKK/i6vk3mK7kOgvvpkMEvuPoUl905WBRJ81kvrucwcS/b7vSKiIBQWJAXeOpH0+ogiJAXeOxH1iJgWJwXaOxInQet/QnURr50jep+oykBho50jg5yxdSAzSVgI/easgMdB7juR9On8JEoM9YPL+lZ8NicE6lzQRdQWJwUonTMTlGiQGvZpImIhLChIDD5iJEnF9ChKDP2KiRFy3ITF455Mkoq4gMYQbzASJuL4DiWFUSo6IUwoSw6iaGBHXa5AYzjm0lBQRPyhIDOkcmhAR16uQGFJ2QkRcciAx5GXCcBH6X1MZRMJOhAgjFglTSPjLhOkizFgkjCFhJ0CEGYuEMSRUzngRhiwS5pCwjRdhyCJhDglVNVyECReXhpFwrpot4gcFiWGXNlrExylIDL87Jot4pSAx/JoGi/jYhcQoyporIqMgMZKDqLEiTDmAGkdCVQ0V8XFNQWJEB9EZM0W8UpAY2eMaKcKg2dI8EqpooogpBYkRbh2/Nk/EloLESC8njBNh1rZhIIn21mGSiCkFidFvHSaJ2FKQGPkjGyXikguJ0TdlkIiPqwoSY2jbHBF1BYlxZN83RcSGA4kxnUQNEfGxqyAxtnHCCBFVBYmxdc8EEUUFiTHeTlzTX8SWA4lx5mov4pKtIDHWGpqLMHK0NJuEmtRbRE1BYuxldBaRUZCIoVl9RRQVJGI5dszqKuKVgkSMJjQUYejxMwkkWiOmhiKM+9RMskjoKAIScZLQUsRvIBEvCf1EQCJeEhqKgESsJHQUAYk4SWgpAhLakNBFBCR0IaGNCEhoQkIfEZDQg4RGIiChBQmdRPwWEhqQ0EoEJDQgoZcISMRPQjMRkIidhG4iIBE3Ce1EQCJmEvqJgES8JDQUAYlYSegoAhJxktBSxM8hETMJ7URAImYS+omARLwkNBQBiVhJ6CgCEnGS0FIEJLQhoYsISOhCQhsRkNCEhD4iIKEHCY1EQEILEjqJ+AMkNCChlQhIaEBCLxGQiJ+EZiIgETsJ3URAIm4S2omARMwk9BMBiXhJaCgCErGS0FHEH+YgEVvzWor4EhIxk9BOBCRiJqGfCEjES0JDEZCIKSc190JPEV9++TDTgMS4n3vynJ6TZbff//7x3A4kxpSbvqDnDVVARKvF85MuJEacnS6W9XyvcYCIVn/6VTZtQ2JUHGr5LT0/H3GECL8z2YYDieHPkuf0/JxlBBFeX311P28ICyNIWHNf6/nvNY4hwm9mrgmJwWfJyQt6/rvPPkR89dWNGzcqkxYkBjhaFDf1/LaA/kW0ulvReeLUloTdyJzV81uHBhbht5BNO5CIPks2587q+e2FQxNx48bLly8faDlx6kfCmnul57cgD13Ey5c3b95cyTUhceQsWdfztymMTITfL7SaOPV5Fm+WXNfzd/CMWkSr67+YtCERnCXX9fxdfmMS4fczPa6+4yfhNDMrev5O4DGLuHnzxIkTP8Q/ccZMojmn7W+Sj0WE3w/xTpwxkrAm62c6IaJHhN/peUsYCW+WfHDmDCIOE9Hqt6/mbSEkvFmyhwMiDhFx4sdev4th4hwzidYsefv2GUREE+FXLo534rTGyWFq+3YrRBxHRJvFGCfOcZGwqtkrV64goj8Rf2tVylmJIeHNklf8EDGAiP/1+vKnS5bxJOxG8f6VK4gYigi/ifqIJ85RknAamW+Wl68gYpgi2ixGOXFaI5wll1shYvgi/P5VbBpEwpsllzshYkQiftTq36OYOK3hz5LZ1eVlRIxDRKs/nRv2xDnU/52dLj5cXUXEGEX4LdYLtoYk7EZmZtUPEWMW0ep/flWsORqR8GbJymo3RMQhwu9MsaYFCataWVtbQ0T8IvweZppxknCb1eyaHyI0EeH19xuPMzU7BhLeQXN6rRsiNBLR6rPP/vOTfpcLq7+TRb7shQh9Rfj95yf9nESsPjy8L5cRYYAIv88LzohJNPPlMiLMEfHZZ//4x/vm6Eg46cdlRJgmwut6YTQknGqpjAgTRXz33XfHQBGdROPFBiJMFdFC0RwyCTe7gQiTRXjN2MMkUd1AhOkinjy5WRgaCSeLiASI8JpxhkPCLSEiGSKePFmwhkGisYGIpIh48uSENTgJRCRJxKNHjwqDkkBEwkSEmrAQIU3Eo0e1QUg0EZE8EY+OnicszhriRHgmnH5JOOcRkUQRT5/+rF8SOUQkU8TTp5n+SDQRkVQRT582+yHhlBCRWBFPf9MPiRwikiviiK3jcBIWIpIs4vmP7WOTyCIiySKeP68cl4SFiGSLeP7cPiaJLCISLuKwZeIwEhYiki7isGXCCl0kEJFUEYcsE4eQsBGRfBHP/uYcg8QUIpIv4tmzqWOQmEaEABHPLkYn0USEBBHPnlmRSeQQIULEs2xkEtOIECHi2c+jkmgiQoaIA3cO69B9AxECRLzORyTxGBFCRLyeiEbCRYQUEa9fO5FIpBEhRsTrWiQSeUSIEfE6G4kE32cpR8QBw8QBJGxEyBHx+nUUEg1ECBLxJhWBxBQiBIl4MxeBBN+ULknEm9kIJBAhScSbiXASNiIkiXjzJpyEhQhRIt5YoSSqiBAl4k0tlMQUIkSJeJMPJZFFhCgRb2dDSdxBhCgRb38ZSgIRskS8/VEYCRcRskS8fRtGwkKEMBFvrRASDUQIE/E2FUKiighhIt5WQ0hMIUKYiLf5EBJZRAgTEYUEIkSJePfLEBIziBAmIpQEIqSJCCWBCGki3r2LSgIRUkSEkLAQIU5ERBKIkCPinROFBCIEiXiXikACEZJEnDyaRBUR4kREIIEIWSLCSSBCmIiTcyEkECFNxMn80SQQIU5ECIkMIsSJCCGRRYQ4EdFIIEKQiEgkECFJRBQSiBAl4uSrUBKIkCXi5L/CSCBCmIhQEoiQJiKMBCLEiYhCAhGiREQggQhZIsJJIEKYiBASiJAnIowEIsSJ+OfRJBAhT8RxSCBChIhjkECEDBH/vBKVBCKEiPj/qCQQIUVECIkHiBAnIoREHRHiRETbOBAhSMQ+Ev8VYAB7Ct9tl4K65QAAAABJRU5ErkJggg=='),(72,'testttttt','Jedi','rjones','password',17,'M',39,2356,'I','[email protected]',0,1,0,0,686,'Active',0,'0',0,'0',0,'test',0,'','','','',''),(74,'Tim','Street','ttstreet','SE(capstone)#s16',22,'M',75,190,'I','[email protected]',80,1,2052,0,743,'2',NULL,NULL,NULL,NULL,0,'sdsd',3480,'','','','',''),(75,'Corey','McQuay','csmcquay','Password1!',22,'M',65,200,'I','[email protected]',100,1,1987,0,180,'2',NULL,NULL,NULL,NULL,2,'Balci',2100,'','','','',''),(77,'Thomas','Chowder','tchow','password',23,'M',51,115,'I','[email protected]',0,2,1289,0,123,'Very Active',0,'0',0,'0',0,'Blacksburg',0,'','Lemon-Pepper-Shrimp-Scampi-1603262, Dry-Rubbed-Baby-Back-Ribs-1603381, ','Grilled-Cheese-Roll-Ups-1593324, ','',''),(78,'Jared','Schwalbe','jareds94','csd@VT(S17)',22,'M',72,180,'I','[email protected]',0,1,1921,0,170,'2',NULL,NULL,NULL,NULL,0,'Londonderry',1800,'','','','',''),(79,'Alexis','Spring','aSpring','password',23,'F',54,120,'I','[email protected]',0,2,1331,0,130,'Very Active',0,'0',0,'0',0,'Blacksburg',3063,'','','','',''),(80,'Alexis','Spring','aSpring','password',23,'F',54,120,'I','[email protected]',0,2,1331,0,130,'Very Active',0,'0',0,'0',0,'Blacksburg',3063,'','','','','test'),(81,'Danielle','Greene','dGreene','password',21,'F',64,180,'I','[email protected]',20,1,1474,0,135,'Lightly Active',0,'0',0,'0',0,'Blacksburg',1800,'','','Grilled-Chicken-Shwarma-1613249, ','Chocolate Frosty Pops, ',''),(82,'Michael','B','mybu5','password',22,'M',76,220,'I','[email protected]',0,1,0,0,200,'Active',0,'0',0,'0',0,'Blacksburg',0,'','','','',''),(83,'Thomas\'s','Jones','tjones','password',21,'M',65,255,'I','[email protected]',10,0,1924,0,145,'Active',0,'0',0,'0',0,'Saigon',0,'','Berries-and-Cream-Popsicles-1614339, ','','Mason-Jar-Fruit-Salad-with-Strawberry-Mint-Dressing-1615028, ',''),(84,'testy','pass','testy','password',17,'M',51,141,'I','[email protected]',0,0,1348,0,130,'Very Active',0,'0',0,'0',0,'Dj',2618,'','','','',''),(87,'Michael','Bulgakov','newUser','password',22,'M',76,220,'I','[email protected]',0,1,2257,0,200,'Active',0,'0',0,'0',0,'Blacksburg',2603,'','','','',''),(88,'Michael','Bulgakov','newUser','password',22,'M',76,270,'I','[email protected]',30,1,2257,0,200,'Active',0,'0',0,'0',0,'Blacksburg',2603,'','','','',''),(89,'duke','forsyth','duke289','Michigan1!',23,'M',69,100,'I','[email protected]',0,1,1408,NULL,150,'2',NULL,NULL,NULL,NULL,0,'dc',2400,'','','','',''),(90,'Michael','Bulgakov','demoUser','password',22,'M',76,218,'I','[email protected]',0,1,2257,0,200,'Active',0,'0',0,'0',0,'Blacksburg',2603,'','','','',''),(92,'Mike','Jones','mjones','jones@1994',25,'M',73,245,'I','[email protected]',310,0,2373,0,200,'2',0,'0',0,'0',0,'Blacksburg',1848,'','','','','data:image/png;base64,/9j/4AAQSkZJRgABAgAAAQABAAD//gAEKgD/4gIcSUNDX1BST0ZJTEUAAQEAAAIMbGNtcwIQAABtbnRyUkdCIFhZWiAH3AABABkAAwApADlhY3NwQVBQTAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLWxjbXMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAApkZXNjAAAA/AAAAF5jcHJ0AAABXAAAAAt3dHB0AAABaAAAABRia3B0AAABfAAAABRyWFlaAAABkAAAABRnWFlaAAABpAAAABRiWFlaAAABuAAAABRyVFJDAAABzAAAAEBnVFJDAAABzAAAAEBiVFJDAAABzAAAAEBkZXNjAAAAAAAAAANjMgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB0ZXh0AAAAAEZCAABYWVogAAAAAAAA9tYAAQAAAADTLVhZWiAAAAAAAAADFgAAAzMAAAKkWFlaIAAAAAAAAG+iAAA49QAAA5BYWVogAAAAAAAAYpkAALeFAAAY2lhZWiAAAAAAAAAkoAAAD4QAALbPY3VydgAAAAAAAAAaAAAAywHJA2MFkghrC/YQPxVRGzQh8SmQMhg7kkYFUXdd7WtwegWJsZp8rGm/fdPD6TD////bAEMACQYHCAcGCQgICAoKCQsOFw8ODQ0OHBQVERciHiMjIR4gICUqNS0lJzIoICAuPy8yNzk8PDwkLUJGQTpGNTs8Of/bAEMBCgoKDgwOGw8PGzkmICY5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5OTk5Of/CABEIASsBKwMAIgABEQECEQH/xAAbAAACAgMBAAAAAAAAAAAAAAAAAQQFAgMGB//EABQBAQAAAAAAAAAAAAAAAAAAAAD/xAAUAQEAAAAAAAAAAAAAAAAAAAAA/9oADAMAAAERAhEAAAGwbDFgIaMdEjSbk0GSBghpBkmCGgQhmOYhhiZYgADQCEDEDxyNyaGssR4gLRu0ElIGKvJsejhlrrrAvNvPI62RxUw6tQpxi2CTRliMxGxIAeIAmAYklAJiEmBGkaDc9ewx5yy50AAAAAEwV3Sh2riygwyxGIGmCGjFgAAgRIaBYsHjliGjdpHt0xzn9KlkWT1lycHK7nA4yT1SOOo/RefOWGi16DkurGjEzSYAhiBoQNAAje0zHJAhox1bdQqq1qin6zl+qLiVXzCXjrY09RHhS4RysG3qB9hxvWG5gAACYIYIAQDFoJwAmmNCMcM9QVthpOa6fnemLGfU5F06/eSsKmgOqhUsgy5jqqkp+r5jpSSNACBoGIBpGWIwiycCUIGgEmzBDI+3RIKC1h2ZF0jNN9W9AUNV1sU52Zdzyrquj58rbqHYmSeIxAPEGJDBGQmITN40NACMRoCHLhyyPYRwuNEnIjbNEo17ivLPKimGVDaVZKaAaAEA8QYmBiGQgYglCATxBMBCIkqHMHHkRSy01W03xZOZCJDNKiolbIuwm5Y5DEAgAAAQ0ACYZLElAhoQmkMAhS4ck2aswrMdiI0qXrJjiax57UQc4d8QJUKEXeKYDxGgAxYxIyEhvEJbSGIBCECIsiHMMhMIcTois2VFuR50mMTef16DLvoNwcbyvQ86SZtUF/K5XM6cpZxLaYhA0APEJgkMeI0IE8SHKj4m6ohaw9I847oh0PpvOnJm7WHSQO2Mk4h57W5YjAAAADNYokya4L/fSXQ0ImpMeIhp1xYRqiCTYLBMA67kejO65608zL+88/vy6uYvHHpFBP5s5QYAAAAAAAAD6Pm703poltAatkQpI7AAAANmu7Kix0TDqqTorI8qjegc2bOt5vsyt4/0TzkqBMAAAAAAAACdByOgWqEXro7U3wJlUVQAAAAGeHTnL9JRdOWPQ8j1xyfG+lecEz07zD0wy8r9D81MQAAAAAAAAAEwQMJ0EOppbehIzAAAAEOxK3qauwJ/Q1VSa+f09QdVs2cQbuXt6cYAAAAAAAAAAAAAAW9RNgjEwAAAO/8AP70sa2t2Hf8AGegcSUfWxKw3Z03RlLX3dKAAAAAAAAAAAAAAAPFgAAAAAJgNI9V5roq8i8ROgkzqee9APOoGeAAAAAAAAAAAAAAAAAAAAAAAACYdly5FJ2/R6KVGEXkzW0wAAAAAAAAAAAAA/8QALBAAAQQBAgUDBQEAAwAAAAAAAgABAwQRBRIQEyAhMDEyQBQiIzNBQhVDUP/aAAgBAAABBQLqypv1n7/mY8E3sP3N0u+G8WeOfH/emb9cnu4OhNiUk/KU1tiYLpgI6gmvxu7Wq7u2C8P8+BL2jP3cLcuwPqjYSJyfpgsFCoLUcvyZe4En4XXHmeGnYd3+PJ+s/ark/LbxN2VeXnR+B/NJ7X9P5Me+XgNeUk1KZR6dISfT3ZR6cOJdPwjFwLhp54kX8+JL7P8ANo9kCghKR69OMUIMtqxhYWESuwMY+nCu+2bzZ8Ens/6r7/aLZeqO0RQ+ueL+hOpFaHBofc3xH4Se1u8N9shD2kidC6Elu4ZTp0aug+eEP6vK+M9Ze1v0Xf0B7ofbH3QMscMLspHBkalHeJi4kq75h8pN36zbsP67A7oIB3SihnAG/wCQhZDZCRPIprexSW55EO5haRerXQ7BhygLMfl2s/gf2h3jwzqMdlpy2pm5iljgQfY8W4wnF2d2J0EdkniGbPLw1v8AXWjEnibA+XHhHsLKcdll43NnrybypRZhhZVewyAxH9LIztBO6GNgY1a7tFDgvgN1x+1WW3RVn+3YztyARdmrqRsOPGRT/cm9nxWT+kfoydsjX7Jn7ObJ33qDDKfDqQQYQnIU0zOpZO3q7PlvjOg47tp87sUzuisECa6bPLbkNA0zrm5W5ZdfwfT44ercJWWXXMAUOJFyoE7QAisxYkmF0GcNlOSH0+OHrwkZ3ZcveijlBQgJpq1UUYxYjj++Ru5dlUDn2Bl/L8dvXjMG1RvlO+4WldlzlzHJApGwxllaTF+TWY2CzFaJkz5bi3wm93H1VyFq0kZMaKu7r6KXMNLCJhBrMu4owczrw8iLXeEUxxIbqGzESbv5M9Tpv2cbVjD3oudXy4vBbZNYjUlxmUk5GmbK0+ryRda2WbXQJOLhbkZBYjPhh/OPuRyADSWzLhpj7qN+k8RYWFjhp1XLp1qJ77nXzDxvJDPKyG2+IzE24/zr/wBzzNExmRlw0U81Vb05iUgHE+VSrFOQttZWZOXCTuReOqW2XxSzRxKSwRP0aG/2LUtQ+nVW7PK/0QupbFik9azFZBaue2t5GfDj6dclsAR2pD69FLE9ubkVz3OS0/UXgVqwHIjYopKtjmjrUmfNE+Q6XfAyylI/UA7nMdr0n2SXgKeIqe4JoShJaVBzlFShjVuMnfUyd5PLWPv02e0HXF2htlGRRB+Cge6DDLUo43WqNWA9GmYXF8stVPdc8ovtJzER+p4NwuPiHr3ltVRnOjpZd1rW4ydaeYx2uFl91j4EVsxQGxirz9+unyK8M5Cc+i/dFAXItKwDE8v7adc55AfI3J+SBe74NM9siuv+Tw6E+CvNieE8wajqDmooymkrVwrwiQirs3Mf+/BZ8O3drBbpuujTK2VqhPWHQ3/PqQKew40FooMxyGMYc45prD4D4dQ/xP69ejQ8unr0y0ctt28G+Gw344YnlOuzQq9eKyQNgbeWL4dR8H4K+qTwjZmexNRLZb9wygq8XJC5OoWzJCO+bV8fW/DZ9r+Jnw9bvBNC8Mlwxgr+r1vdp0ZFNfLfc+fTfNXUSjVpyI1SDeQs0MBvuP59Ow46TzSKSwqFI7RxgA2NWutFH/4ERE0Sbuwi0UEBOwyO5SfC/8QAFBEBAAAAAAAAAAAAAAAAAAAAgP/aAAgBAhEBPwE0/wD/xAAUEQEAAAAAAAAAAAAAAAAAAACA/9oACAEBEQE/ATT/AP/EADIQAAEDAQUHAwQCAgMAAAAAAAEAAhEhAxASIjEgMEBBUWFxEzKBM0JQkXKhBGIjUsH/2gAIAQAABj8C3E/hvj8MPA2KKTEIhoNV7AVmsv0VVrgvq/0pFR24opvi+OqhoAUk12qaKCcLuh4kph7X5TJ57oWT/g8QUzxdhb7jvAf3w5TPFzjfRpXtVaXZ1LVBvc3rw5Vn4Rrrpd2VRO3I1vaeHKZ4TFCjdjhym0TChupvbvtdwUzwvm4bfuVCiCiLmHtw7U8IC6qiVRwuoon9LR0X4lXfzuWKE5iqv/VT/IZOwcGoVcY8qoLr8xUcOLmPihVAs+ixerHaEYmFF02bwFntBHZUuhNjiPm7xVBVC9guKnaGHiPm4hRfS7VSTVe6W3zxLvO1OGVoFDVndTovZACpxZ87MKlVme0L3z4UYXKGgqvFnZ1WtOyzPIWa1n5UWVlH+xWI1N+EmKUTrJ+V7THEHzsS3S7oUZuiYCopNxf0Cxj7lD6jqpBpwx87EIBk6TdlpdmNxAUCpWFWV2X+1msx8LXD5UivBuPfYwt5aqzt2VpVUUPWqy34ne43NHQbMtJBWfMuh73ab910uKyZRdZz0RtLNssPLps+q8eL7TtuMON0eV7j+17z8rM2VLd45d1icZN8dDdisaHpyUWjC27ERkCgXOd0RJ57zzu6n4COHKDs2jbvTsvqHn0WC0/yg3+TQv8AlZZk9WiF9Nr7D/X7Vis3eRzFxHXegobiAMRVIb42yP8AsE9/PkiXam7Ba5rP+wshDsSmydDuyh4wvGoTW75u0T0VTTpt9lrKY7ug1lRqow1UOFzgfapiqa6y94QxCvPfYdp+4aIQDG6CqY8KvK6z9QCJQZYMAI1IXp8yq3P7b4FYiaKjdjzuMPK4x9pT2/N1nZs8m5hfpe89+Bh4xLE25g3DLbGyTrOqe5ogEp7V/V2LoE6OqyijdUCjGqPBYeTrgO26epCDz0Xp2Jy8z1QY3UoWbf2nCdE53Lg5QPVO3Dg12HCNVifhLOoTx2QcvTGpuNofhF7jACfbVAdwv8UdwHHV9UyxH8ih3C8XYR8rsF6Y+mggDwjh1G5DCGvaOqdakRPJWR7opzFHMr02nygmt7ogchwk7sFNVTMrFOY6KVK9T7WhWp7/AICzPZNBOdZjN0KmgCcep/API91msbzJPNSujBqV6dk2AEbFhznXt+BtWg0NzAeqhgwgBWjpzdUSTJ4P/8QAKRAAAgICAgEEAQQDAQAAAAAAAAERIRAxQVFhIDBxgZFAodHhULHwwf/aAAgBAAABPyG8NkUaHrDi80b9JSnHOU0SsQmIm4jPAn4EQIveN0JEYnwTiYN83lAyZ0NUJJ7GkJZiuM7CUd4l6ILiJE5FmRbOTQoi94+GfLHn0sTR9kLDYkss2PsRLHIZRMkhvBEvNxMNjb5JzQsKUuW2Lu//AJ6KgvexQhEvLIZM67rGsySh2mioG+iB4JQk5eEckEEZ0c5Y/wAOx049NccEAjUhfMwix3ebd+qSVujIBFmSMSsQ8VBAiYJjNk4k7JGIdFUiz7UG5evA9QMP/wCA9lFsP5fvLtY0SfnPk7ForE5WIOTY4Z/FPsNWLVDeON9Dty9+0zaU4YhCoek8jPOEbNViBHogjoaaEd+ieBYXJONx/wAuC9jqeYWEm9LErlMhsT6EmJSZt+BqtGkPSnWZpdLjsSTKr0KXUGjgZtmjRQllfAxUcSJr6JBe2lIh3hThbQW6mWjhpISxZFiA+hoyOYabNPeGpuzgbfoZEE3jRwxRHkkk+JMY0QcjxNQuDn+zKNc3JF9mLV0uSb8YPIdsag2CIZqxT3ETir5i9jN2/ZnH1iuy1iZyhLlYhZ1rBvGraYyk6k1uSvY7k2Jw1NXhM8XmV/W8cejjDEPdCqsIaSYffpipJkZGy6IRKOFcCOLS1c0fJNSbGUkScCQjBq0tErKpkHMDEgGIWXEk51helYtTs4xGW8IkQ88OSxOJQphoqinHInrU/gjLnRAh1YWcAoPZkPaR1pz5JDpxUVpyIXChKhaw/RN54JkWsN7YY2TWJ5E7Y9m6BweRRPFXQpF+BMqEltqSElb6KRXWpnkeZZKWiaURL7JpCXMhyMJyi65voX7ogUEL8n+mC1v0SKBu6PvCUNsmqxoSYYpRtya2KGhuOCJRHpTR2Q6RS7NwhxP2nRINA+I5Z40KnoMEoe0xpqis+KEVCtyuIFpdkmaasVV6Fr0p4VDxJwUPodMVk74GhunHCJ3fYUEp28BLkG0tH/QEIYFlDWtlkoaFTho2jw0WO7RBUlWJOPRJ94SG6F6k4HeWluzYVfw5oeYENBPMp1jKKxrNVXkblHRQ1humVHwHwJuJNJDcsDhIwlsgj0c1i8TBJzhY8kjwnkEyTfdyJHUYNLjYjdEcXV0Q1L8IUz98WNdASps4J+TQaDxnh+mSa9F40IbPg28SRbNXoaYgvkSlEnJQ+R9Fot0PTI9Mt6E+Ju0/oWwfyQtB/Y0iuJEp794WV2Th6JX7knEgRNkm0TH8NnxMt9mhxL08CwMa7RDkpGmhTs7IK3sWvcJeSo/yDDKXJJOJTnCnsnMuPW1HOFi7BONmjeXg2E76KSwforaemivI1950K26UTjESIRNBqKfJpPz+R6v94QlcxuUbKGaFY2jQmMmtkpcySc7wj7H6KJUDnLVIK3yPti5E3Ir67EtrEsE6+RNyia2SCpC+uXSEJXfLN1+axPyTT4Q4PnOUbdukKKE7TxJIjZLxr0KTgfqbr54WIh+ybD1SiwXKLJhXq7Z0rErVvgpk2h7UpbKnT/bL+nHZ5sUmMOH9yqllWiDn+CxOZ9EYai5F0efQ7Iqvn8iKmeieUv3WO5nkjNtLGwmJaCxTnCIsjtDXKQTKaExev9mIXCn7HL/ixRfWcFrP4wvQRNkkk1hVWJmnHQxZQ3z5DhrtGp+d9h2cF2qf2KYpNLm7Fp1LCmWkGBW0sXtwimqCQ8N1iR3m3rZyG/uG0q6g7cv0TIdyLRxpqvh/c8RnOT+z8hQMpcTWovijZ+5iMY4e74kY0u7Q3eFicfQ+bfdNCxqD+X5N736kudB1aUfInG23bwzU/Dz/AEmi5eLoVGFakOTCX9iNgVe9On0b9DJ54De2dJet+6E2xMaROGhnSBKjoYkHaCJLF1OHO80m4GiSacsWtHKuiThb+8jl1tfJJ9kyMkelzXsJOU7kVaVTrllWRw32OWmtoG7hCN2ki1O11gttH2KTN9jpEhkKZPFqe89BwRAy15G80x5Hgyq7V7FWXgcEK5f4RPkUxa6kylLkSQpuLFSgbiR7Lv7/AIwlgr3MMStDJPrLfsJRbrBp4SFrpRJKCx2m9DoXqZYeWXk4IWqCPsJbggjlFMSyof5P0UpJL/YTRN1PYfWIWJfTNmvq2GjiGKPl8CRNK+TJ3tdrwMlPAez/AETkJwxop0hJOq9hDxJGyn4HriU38iPuEQLn0yVF0R4wsm4gJRJS2KZqRLwLg/SSMvw8DSzt+xFK/wDHgse/5ojbe5DWNbuOfwFLQPDBqSnHZHuyJTX6RiX+L2VCbhJIcfJPyd0wdCq4qdNOjQbmEJpcjY58LkmQQmPT4DtpEL9I9Cce34tZdvlSK9dpTFJ6VBtsZy2LfoJbqIC8s+l/696xdjJei8E9bDWGI7MjlJR5dH/gHl0NE+zzhFtdkMb3/l8IUE6ba5EAmmPB/gWmEq0ITcE1RBNQpCLgauZbb/R//9oADAMAAAERAhEAABDzTxjygxgBBTwhQCQSBhRBwgiQgBQBCDABhSSxxxhwzCRQgRyjxzxDTzCSAxBwCwARCwQSQCTxTyShxywyhgyCQCyThiAhhSywAQChBhgCwzCSiixBxhjgxTARCxzBTTizzwgTDgRziDhgRjjygyzDyQxSTDBjSyTjyzQzyxQiiBzzzixRSSRSRDCTigTwiRjChRDxBBiwTCATDRyjySSzzTBzhixQAADTCBAhRTBCCiBwDTAAAAACRQhxBAABzhixwgAAAABBDQgAAACwhwDwAAAAABDixCAACSAwDCwAAAAAAACDQgABiDTzzAAAAAAAAADAAABBBRDQAAAAAAAAAAAAAABCxRggAAAAAAAD/8QAFBEBAAAAAAAAAAAAAAAAAAAAgP/aAAgBAhEBPxA0/wD/xAAUEQEAAAAAAAAAAAAAAAAAAACA/9oACAEBEQE/EDT/AP/EACkQAQACAgIBBAEEAwEBAAAAAAEAESExQVFhEHGBkaEwQLHhIMHR8PH/2gAIAQAAAT8QCBPMRsyYwwZYzBs+ZUvqNNZnsENOnOZRYNkHuoMf43CpqfhVHglZu5YupbJcHYN88St1uXWNsu1imULQbMyzQGLjZ3BRnV2RydAl89waujySrBubLcCrrMUXswV6V7gZVmTeyDmNA4AluxmHAly2jcKIuhzMm1dTbHMsOARLjEJc9X9wqbBZMAeIWvhL3MHCYcVAdrKVytuvMK8MSA3UeGbgu3MVUVFQoLjUqze4gUWymiG2x1NFVqWqsOmD1FoeBuai3d7gJ8kJnL7hu5cG5D6nJF9o2rqq5mwEv6hzFUYbiMFcyn8tAOtG+J8y1443AtGjcysB0vEobqL+kHMpMW1Qxhl6Aij2hsrLD/2gYPXkM+MQu4I1/vLyS4wH5lQLGGBH4IAxS+ZeSAD8IBolt3CgizH3KhwEaZZus1OVHv4j0g+CBqdwW947hSRbrZHCrUXniWI1DeCOQyjJ4nXEB3ozPBlHNSwSMICE87gc2FKsu5yQkX8H+NTHlfg9oJsKsD4ZSKJqVcwiUzoiXqdjEqIr1a/8lPaPDmIVZYIKclRbzqDhfEsMcncwblMncsMi87l6RqB1C5eIqDip5oK/5NoLEPRUShKBwmHUNtsq4UvKzwgfoD7ux5I6GYqOTwQHJeq9BkmLh6DpaVOcEu8TARyaBGqz5x5iMGNiyYCFLviILcbrUBWdxDDwbinU0rzGlwUYjCkfuVKTP+kDgSgY5qJR0/MFWF52rEoira8w9bqWd/4jVA2JsixqbGiKFF5iUZSuYKLchuLwxBptdQM+WbPUAeDcotRy6ToS4F8xIqDepiJC2Ym6uU1ncd+yUbxM/aZv2EIcoKWZRt6lCZ+APTYDfRLjhcjPuVMpAyKy+hmlmcKYFxFEJZVQ0B7YhKlomr0I8fc2XBRbXGhDKpXM1Lg2JnPEYKFnmDlydEGxjJEBaLAwWGJWEotirbnsZVcwauNW4ylQgU2ZasbqoFJ3AVPHZFbWSxFN2aOeGFwBhBi83fPmWMjCZSMLAMTJbnwTDWb8wYAf/cRZVghexAXXeMkpIr+YJVDD6G9eqJ3iDhn3JaocJ1Nw6NQmnRDshoyEqlpu2U8ol/glAuL+KmW5YwXmom8x2V+YIMzIrbiDbn0dGhMXKcNWpwX7ah1RSWt31KP4BepWsxtBowU3Uu6YqAz21MiImVEeoIPEWIrJBbkZD0ohgL4ZgiG91LuAQKLXeo2KQtvMMbinMKObnhFo94N4yfRu0AvUNWceJVWtYcQ9yX18jLVaYCri1Rqkf+TiK2bNozKGjdVwxAcfcYtUwXCvIEMDEVVG7jKvANE9CKrNxql0bhuBx3mACKFONeix2kKnDmA8waRO+ovHMMQYFXEwNSt5ZxaMulYEqICg49oKHHzCgCvUMMS7GFzBZe0oHDEin1MeYI22sHkdx6VA10dzBTNCYnLbxCAz4qcjSbATOOI/UUUx7zBicbjuWJk6lvSpQ3FKFOLiSzhEAj6MpdEUrzM7Mu4M1GuJ/MHFy7tgdxcJBzBwuPKVhzOVFSqxeZaYzdzgCONxTZpO43wZDlywLQBUHbLFuTGDoooja12szGlE959wgqRkOfqZKyEtpGBzFHKcDMLW7alV99wihi4FXG867gANEcxUEvkbqEhJ1jDIuWerPMFNEdVmTJUuaHuGF+J7gxRuX5k+Y6rPMGmCy5ipzLXaK9VXGNrs3Gu1jEF5xd17vcLCpQHyQDNRGf1DTZxSKmTVhj3jLz+RAlHAG8dyxcq3xcuwfc/JE/qwOjzLvPZoAyskdrYX3l3WVsRVwHLZXkjCjuCrfZGFUBw4Jh4PEredty4pbTFjEkiWskGxu0v5lQXbjMLJowa3LwrNShglZrxKVEHMDAw+gUUbICp8ItwREwdEVGllYfMwwfMbCVGmL6uVAEaXX3LEAnTH9JSoi4CNu68EgjYs3AcHi4EQNKdjzGHRbGz4zK2L5qWplYPURgyqvvmOTBth4mSBwxpY5xdQZF5uKjDJZUYYg6rMXnNRZZG24q6qUOoKciUquXVS1vKr1c0NWRA9pS8KS/MYpI7OJ5w0dbjo1rqCo1VeO4ji8Ep4xNkFaoWueENeDFAEpHc50PhKA9lcV2UbGWYKiTKyavmChYSMI0C1PEvC8ssG4O3MW4LBzmU0YLmCsMyxslBaziP4hafEW9QxLm9RrziWM3Ml3FoZvuAGzTnHcOS26cdwg9aHWYNobmqG4JR4CMC90XGjgdSkgOcoznJ7ieossxLWKLrJ9zejay095zFs5qKIaNjzGzW23Eq6IDUvZBqzLdwwt/mOGvQ34hdrX14iO+VqIuZbYTZtxmDTbK2uO9x2NQBumIBaFiWevSgrLoqUrLXxK2BEtMdhR5mW500rs4hjDV5YAK2Mpajsq6zFCCbLaioKikszKX65KrfoxEXZFZbiRwhXNxSq04FheCUN9QG+d8QwVdkMy9i7uDcqB5SAly4PvZLNlzM7l594fUrtAKMkGvcs21Uo8+Iv5QvhpiU9wyTF3FZHFcwIawSrdwXR2Snploywqo7K1XtCg6Bb3mALpAWqEbVzsqHhpSNi/wAS/pOR7S+auy1jHmkuQVUAFEDeYwTT5mSdVCMNeZmlSoNEG2eZeI5hEdjiXAUsi2VPfFArN3uWNtxdtRQGCltxUcJVs2nMdIcLC5yV5lrzFNCmQmacPaagmiG/eWOstWt96iw1ANZ8rqGqdwc/mohvzRi/MvcZkQAAfUBKf7RAHA5jhbvRYHUqPMUHDHiDmuTcFk8AmBmKM8QzbMQOtwWbLsX16DHM1FGuIXLgESu4XEFYgxXuGDljHbUatpjBW0ph2ws1Se7C5kOdS/sGgZtC/DUBMCVfEwYgpX9Qegb8BUfKgqlmVioG3mUAHyxr6r0Q8aqKbX9QxdRdHNdpGlSSq/8A2hwgWJiHJpIIasvqASoK7HvKAhtbuLSZ4hxNRpVdzN4uKWVp8ShCsLMreizUfliUq2LZwS6isqiGVi8w1XdZgjDC+SYA1B0qVVAswfHiEVBcGIKNxb/yFMKcQooW+5VEpvGooiBxkZc9IB7xPB3PFswtlgzklwZndWbh8RHSdk/Dc8+FSPsuLaHQkgqPvxGnE0sIsWVHK4AJwvUu8QVYiVmyX7fbKBG8yw0xPpBqe9sWiBbcwcMKq3yHEGyIM96lrniNkUA7M1MzpKFrWfi4U48ixRVLUcE0RXvHis5HhLgKtuc3BYrcG7ZhMBWNeoEB2xiWyr2uDfqINMNKP6hIB2OPtEaPGqA/MDTDGkCqXtGmxOZ8FAp9GvEt2wKyxsiF1UxLWsS64cx/1Ewwzk1Hl3AEKg6iteDuUrt0C19iO4Qq9h/qWyFbKu2aby/a6xOYox28niUOGyXWEfMLLe4EWqtSh+kvR5gAYMcEQFujbP4ZDLnL/ElffZKKOhdUA2sFY0fcv6D21/MNQOt/xIp2HIuYvsmBW58xa5QUr/ce4gpmexmVncvX53LuVFQVF/j4lRCxRcj5OI7BNWaOj/1QlQgq7zhyQLEE2PJHG72sr/jOe3zAeNGELEe0jASq5h9HcHgooPRnqSy8c37Jy/QqvWyaZ16GdCsHmA9sK1NQyQpMDctrEF63KWhfhzDWm/YP/BBMlSZKeY24V5VVh65qajxNftKjdh3j578I7ZOH4maGfLBt4O1RM7B/mEDQAFx0/wBxGXiVeAcfx6K9t/ulXKr9NjOBmkcCSiy0SydEzMBj0CZlqXbVi6qAGOxQ/PMPhGw5Q2lSrat/5VoGJnaMoRqgvfBGlMK12zHINfzEmegn6K78PqZFogsFivvMpGCuy/CcniAQsOBP4JvopUH+f1rkW1MQmiAqtfmBmFprEJzixgd/CQB7SjqGP8dIbjxEPg53CW0FddQIBsDupVIqC4zGN6yxsiUW4GKl+2rrxG75FtzLhqBV9GXBMAeH3/WvlM0OoAqDFzp9zAU7i2JeKnlFIVRlem/0MtbVFYT2hnsUrOZP6mTGTe2uPgVtdxC27uoNVKKDPLqXShy6TothEMqTSs0vc8/NWoai2VsRrIe0P1UabUNihq5+MI/F7vzBvZX8zLG69FunUHtP/v6C2jaVz3LaYM89xgXIU9v7gOeQLzjD6LjErFBqN3VRpVzcSpsMsLqGgOiUFwFsp1Wi+/1xxhxRmVAIUVsfdNxxOKuR8xTGcqgPV6/QsRNWoyMCNSweD8x2/BHbG4BELX6Flwj1UjsG+oCpLdJ7y8qozAp17wdeCri0V+jLtym17X9eq9URxBH6MaJgnXguzth/lxKHKHOMa9LAzQJ/74guiI3i4fNrZxjm4l+hOTwJhvMvR5YER4rL2wEVxzYtSxClhjXet/ZIxSCSzContOt1X4/QDDRGLWhvwzJgDTi6Ey+cy40tIfLCLXL8Ed1U0CV75au1dMzlGQa8kQwJDUrNCq/DEMhyuYc/s0Wq1SmHZzY/f6GIV6azxH4X5iuPGAfi35g1IZ154JscLniOnOUx0bINEpso+TjuY8OwMr8wTuF1LgCrpKxKr9nlCtBdKO08sP8AJl+pGB4FPrTMAKAKicS3dSKXASHY4iIS7LPeZGjWtX0Ru5V4h8T3vmeoYen9S9QRHWM/tMxyrruOX5t/QqvTISJonvEorc73gSjaSuYLApCfmOCRaw1g4YYxFxE2YxMkcgdB+/2QwqyNNwhwmz2w5BYWdHiVUvIhkQupvxadXRHTbzvOV/f1c3MgrrkYOh1qZ/qUW3VfiAqiLj/6INCQbL5uIiEl7sfcIfvzQi63MVVUIJYg8nU0Myuo74s+UWUNhasP2X//2Q=='),(93,'tim','tom','timmytom','password',25,'M',107,150,'I','[email protected]',0,1,2193,0,200,'Active',0,'0',0,'0',4,'Charky ',4015,'','','','',''),(94,'tim','tom','timmytom','password',25,'M',107,150,'I','[email protected]',0,1,2193,0,200,'Active',0,'0',0,'0',4,'Charky ',4015,'','','','',''),(95,'last test','lol','lasttest','password',30,'M',64,207,'I','[email protected]',0,2,1975,0,285,'Very Active',0,'0',0,'0',0,'Parsi',4062,'Mixed-Berry-Smoothie-with-Kale-1614980, Berries-and-Cream-Popsicles-1614339, ','','','',NULL),(96,'more mom','djdj','lol','password',16,'M',77,28,'I','[email protected]',0,0,1111,0,868,'Active',0,'0',0,'0',0,'pass',2333,'','New-Orleans-BBQ-Shrimp-1614708, ','','',''),(97,'Marcus','Jacobs','mjacobs','password',30,'M',85,280,'I','[email protected]',0,2,2692,0,275,'Very Active',0,'0',0,'0',0,'Blacksburg',3672,'','','','',NULL),(98,'Jokester','SirJokeaLot','lolol','password',18,'F',64,743,'I','[email protected]',20,3,4208,0,89,'Active',0,'0',0,'0',0,'Palau',7523,'','','Everyday-Baked-Chicken-1581195, ','',''),(99,'Brian','Worek','brainworek','Gor!lla1',21,'M',70,175,'I','[email protected]',0,2,1902,NULL,170,'1',NULL,NULL,NULL,NULL,2,'sessoms',1975,'','','','',NULL),(100,'Ojas','Mhetar','ojasm','Hello!23',21,'M',67,158,'I','[email protected]',0,2,1758,NULL,170,'2',NULL,NULL,NULL,NULL,0,'Blacksburg',3254,'','','','',NULL),(101,'Anna','Z','username','almost@Done1',22,'F',60,150,'I','username',0,0,1486,NULL,120,'1',NULL,NULL,NULL,NULL,1,'Horizon Elementary',1350,'','','','',NULL),(102,'Ann','Z','ohmaybe','Anna123!',22,'F',60,150,'I','[email protected]',0,0,1486,NULL,120,'1',NULL,NULL,NULL,NULL,0,'Arlington',1350,'','','','',NULL),(103,'Ojas','Mhetar','cheesem','Hello!23',21,'M',67,158,'I','[email protected]',0,2,1758,NULL,170,'2',NULL,NULL,NULL,NULL,0,'Blacksburg',3254,'','','','',NULL),(104,'Kevin ','Vu ','hungtvu','password',21,'M',65,129,'I','[email protected]',0,0,1562,0,145,'Lightly Active',0,'0',0,'0',0,'Saigon',2374,'','','','',''),(105,'Kevin','Vu','hungtvu2','password',22,'M',66,130,'I','[email protected]',0,2,1568,0,130,'Active',0,'0',0,'0',0,'Saigon',3430,'','','','',''),(106,'Ry','Munz','rtmund','Pa$$Word250',26,'M',76,280,'I','[email protected]',0,0,2604,0,250,'Active',0,'0',0,'0',1,'Carroll manor',2625,'','','','',''),(107,'Jordan','White','jordan','123ABCxyz!',21,'M',71,147,'I','[email protected]',0,2,1740,NULL,150,'1',NULL,NULL,NULL,NULL,0,'Greenville',3111,'','','','',NULL),(108,'Corey','McQuay','csmcquay22','password',22,'M',65,180,'I','[email protected]',0,0,1867,0,160,'Lightly Active',0,'0',0,'0',0,'Monterey',1800,'','','','',''),(109,'Corey','McQuay','csmcquay22','password',22,'M',65,180,'I','[email protected]',0,0,1867,0,160,'Lightly Active',0,'0',0,'0',0,'Monterey',1800,'','','','',''),(110,'Corey','McQuay','csmcquay22','password',22,'M',65,180,'I','[email protected]',0,0,1867,0,160,'Lightly Active',0,'0',0,'0',0,'Monterey',1800,'','','','',''),(111,'Billy','Smith','BSmith','Pa$$Word250',22,'M',69,200,'I','[email protected]',0,0,2038,NULL,180,'2',NULL,NULL,NULL,NULL,1,'Carroll',1900,'','','','',NULL),(112,'graduation ','okay','pom','password',17,'M',65,300,'I','[email protected]',0,1,2650,0,200,'Active',0,'0',0,'0',0,'okay',3144,'','','','',''),(113,'John','Hamilton','jham','Hello!23',25,'M',70,170,'I','[email protected]',0,1,1844,NULL,190,'2',NULL,NULL,NULL,NULL,0,'Blacksburg',3240,'','','','',NULL);
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `Progress`
--
LOCK TABLES `Progress` WRITE;
/*!40000 ALTER TABLE `Progress` DISABLE KEYS */;
INSERT INTO `Progress` VALUES (14,1456808400,2164,2378,3,6328,197),(14,1456894800,2404,2221,1,2946,200),(14,1456981200,1789,2286,4,8148,201),(14,1457067600,1612,1693,5,10373,199),(14,1457154000,2444,1963,2,4982,201),(14,1457240400,2439,1938,4,8274,202),(14,1457326800,1620,2333,2,4826,203),(14,1457413200,2331,2009,1,2187,200),(14,1457499600,2214,2419,3,6169,199),(14,1457586000,2293,2025,5,10368,197),(14,1457672400,1757,1546,3,6357,201),(14,1457758800,1795,2100,1,2584,199),(14,1457845200,1720,1675,3,6624,197),(14,1457928000,2394,1758,4,8214,198),(14,1458014400,1900,2212,2,4864,198),(14,1458100800,2097,2226,4,8143,200),(14,1458187200,2270,1823,5,10437,197),(14,1458273600,1547,1722,3,6865,199),(14,1458360000,1709,1743,2,4976,201),(14,1458446400,1679,1992,1,2764,203),(14,1458532800,2200,1732,3,6374,202),(14,1458619200,2401,1716,2,4754,200),(14,1458705600,2054,1691,1,2774,201),(14,1458792000,1537,1652,4,8325,198),(14,1458878400,2000,2190,2,4865,199),(14,1458964800,2086,1803,4,8315,201),(14,1459051200,1592,2300,2,4826,199),(14,1459137600,2474,2244,5,10439,197),(14,1459224000,1827,1588,3,6285,198),(14,1459310400,1931,2198,1,2984,201),(14,1459396800,2398,2233,2,4868,203),(14,1459483200,1984,2199,4,8934,202),(14,1459569600,1805,1924,4,8835,202),(14,1459656000,2227,2313,3,9823,201),(14,1459742400,2038,1947,1,2844,199),(14,1459828800,2396,1658,2,4552,201),(14,1459915200,2125,1887,5,10936,198),(14,1460001600,1952,2392,2,4002,199),(14,1460088000,2128,1755,3,6545,197),(14,1460174400,1694,2027,2,4833,197),(14,1460260800,1603,2077,1,2115,200),(14,1460347200,1954,1933,4,8466,199),(14,1460433600,2088,1801,2,2985,202),(14,1460520000,1814,1744,1,2338,200),(14,1460606400,2387,1644,4,8164,202),(14,1460692800,1745,2278,2,4008,200),(14,1460779200,1997,2325,1,2970,203),(14,1460865600,2456,1563,1,2994,201),(14,1460952000,2377,1611,4,8922,199),(14,1461038400,1871,2321,2,8305,202),(14,1461124800,2241,1773,1,2997,200),(14,1461211200,2224,1689,5,10885,199),(14,1461297600,1573,2053,2,4064,197),(14,1461384000,2328,1883,2,4336,198),(14,1461470400,2466,2307,4,8437,197),(14,1461556800,2399,1883,5,10996,199),(14,1461643200,2191,2112,1,2988,200),(14,1461729600,2403,2234,2,4007,201),(14,1461816000,2256,2693,2,4629,202),(14,1461902400,2073,1957,3,6936,201),(14,1461988800,2572,2008,2,4693,198),(14,1462075200,1978,2267,4,8195,199),(14,1462161600,1963,2018,4,8493,197),(14,1462248000,2063,1859,4,8163,200),(14,1462334400,2010,0,0,0,210),(14,1462420800,734,1475,0,0,0),(14,1462680000,0,0,0,0,210),(72,1459742400,28672,28672,0,0,2171.01),(72,1459828800,28672,28672,0,0,2178.75),(72,1459915200,28672,28672,0,0,2185.73),(72,1460001600,28672,28672,0,0,2193.35),(72,1460088000,28672,28672,0,0,2201.24),(72,1460174400,28672,28672,0,0,2209.22),(72,1460260800,28672,28672,0,0,2217.1),(72,1460347200,28672,28672,0,0,2224.07),(72,1460433600,28672,28672,0,0,2231.66),(72,1460520000,28672,28672,0,0,2238.31),(72,1460606400,28672,28672,0,0,2246.26),(72,1460692800,24576,24576,0,0,2252.34),(72,1460779200,24576,24576,0,0,2258.55),(72,1460865600,24576,24576,0,0,2265.46),(72,1460952000,24576,24576,0,0,2271.1),(72,1461038400,24576,24576,0,0,2277.34),(72,1461124800,24576,24576,0,0,2282.83),(72,1461211200,24576,24576,0,0,2289.54),(72,1461297600,24576,24576,0,0,2296.12),(72,1461384000,24576,24576,0,0,2302.74),(72,1461470400,24576,24576,0,0,2309.42),(72,1461556800,20480,20480,0,0,2313.21),(72,1461643200,24576,24576,0,0,2319.67),(72,1461729600,24576,24576,0,0,2325.21),(72,1461816000,24576,24576,0,0,2331.26),(72,1461902400,20480,20480,0,0,2335.98),(72,1461988800,24576,24576,0,0,2341.98),(72,1462075200,20480,20480,0,0,2347.16),(72,1462161600,24576,24576,0,0,2352.64),(72,1462248000,15360,15667,0,0,2356.38),(72,1462334400,56,0,0,0,351.56),(72,1462420800,0,0,0,0,2356),(72,1462680000,0,0,0,0,2356),(74,1461729600,0,0,0,0,190),(74,1461816000,0,0,0,0,190),(74,1461902400,0,0,0,0,190),(74,1461988800,0,0,0,0,190),(74,1462075200,0,0,0,0,190),(74,1462161600,0,0,0,0,190),(74,1462248000,0,0,0,0,190),(74,1462334400,0,0,0,0,190),(74,1462420800,0,0,0,0,190),(74,1462680000,0,0,0,0,190),(75,1461729600,0,383,3,7105,200),(75,1461816000,0,146,1,2713,200),(75,1461902400,0,390,3,7227,200),(75,1461988800,0,186,1,3450,200),(75,1462075200,0,95,0,1771,200),(75,1462161600,0,70,0,1314,200),(75,1462248000,345,101,0,1876,210),(75,1462334400,1638,394,3,7317,200),(75,1462420800,0,0,0,0,200),(75,1462680000,0,0,0,0,200),(77,1459742400,0,0,0,0,115.99),(77,1459828800,0,0,0,0,115.95),(77,1459915200,0,0,0,0,115.93),(77,1460001600,0,0,0,0,115.91),(77,1460088000,0,0,0,0,115.91),(77,1460174400,0,0,0,0,115.9),(77,1460260800,0,0,0,0,115.9),(77,1460347200,0,0,0,0,115.89),(77,1460433600,0,0,0,0,115.86),(77,1460520000,0,0,0,0,115.86),(77,1460606400,0,0,0,0,115.82),(77,1460692800,0,0,0,0,115.8),(77,1460779200,0,0,0,0,115.79),(77,1460865600,0,0,0,0,115.79),(77,1460952000,0,0,0,0,115.79),(77,1461038400,0,0,0,0,115.75),(77,1461124800,0,0,0,0,115.74),(77,1461211200,0,0,0,0,115.71),(77,1461297600,0,0,0,0,115.7),(77,1461384000,0,0,0,0,115.69),(77,1461470400,0,0,0,0,115.69),(77,1461556800,0,0,0,0,115.68),(77,1461643200,0,0,0,0,115.64),(77,1461729600,0,0,0,0,115.64),(77,1461816000,0,0,0,0,115.59),(77,1461902400,0,0,0,0,115.59),(77,1461988800,0,0,0,0,115.59),(77,1462075200,0,0,0,0,115.58),(77,1462161600,0,0,0,0,115.57),(77,1462248000,1695,3349,0,0,115.54),(77,1462334400,0,0,0,0,115),(77,1462420800,0,0,0,0,115),(77,1462680000,0,0,0,0,115),(78,1461729600,0,0,0,0,175),(78,1461816000,0,0,0,0,175),(78,1461902400,0,0,0,0,175),(78,1461988800,0,0,0,0,175),(78,1462075200,0,0,0,0,175),(78,1462161600,0,0,0,0,175),(78,1462248000,0,0,0,0,175),(78,1462334400,0,0,0,0,175),(78,1462420800,0,0,0,0,178),(78,1462680000,0,0,0,0,180),(79,1462334400,0,0,0,0,120),(79,1462420800,0,0,0,0,120),(79,1462680000,0,0,0,0,120),(80,1459742400,0,0,0,0,120),(80,1459828800,0,0,0,0,120),(80,1459915200,0,0,0,0,120),(80,1460001600,0,0,0,0,120),(80,1460088000,0,0,0,0,120),(80,1460174400,0,0,0,0,120),(80,1460260800,0,0,0,0,120),(80,1460347200,0,0,0,0,120),(80,1460433600,0,0,0,0,120),(80,1460520000,0,0,0,0,120),(80,1460606400,0,0,0,0,120),(80,1460692800,0,0,0,0,120),(80,1460779200,0,0,0,0,120),(80,1460865600,0,0,0,0,120),(80,1460952000,0,0,0,0,120),(80,1461038400,0,0,0,0,120),(80,1461124800,0,0,0,0,120),(80,1461211200,0,0,0,0,120),(80,1461297600,0,0,0,0,120),(80,1461384000,0,0,0,0,120),(80,1461470400,0,0,0,0,120),(80,1461556800,0,0,0,0,120),(80,1461643200,0,0,0,0,120),(80,1461729600,0,0,0,0,120),(80,1461816000,0,0,0,0,120),(80,1461902400,0,0,0,0,120),(80,1461988800,0,0,0,0,120),(80,1462075200,0,0,0,0,120),(80,1462161600,0,0,0,0,120),(80,1462248000,0,0,0,0,120),(80,1462334400,0,0,0,0,120),(80,1462420800,0,0,0,0,120),(80,1462680000,0,0,0,0,120),(81,1459742400,1458,197,1,4066,180.94),(81,1459828800,938,129,1,2660,180.91),(81,1459915200,1217,121,1,2498,180.87),(81,1460001600,1168,1,0,35,180.87),(81,1460088000,1290,33,0,698,180.86),(81,1460174400,1445,3,0,75,180.86),(81,1460260800,1255,53,0,1094,180.84),(81,1460347200,1041,145,1,2996,180.8),(81,1460433600,1142,33,0,696,180.79),(81,1460520000,1084,214,2,4419,180.73),(81,1460606400,1094,79,0,1637,180.71),(81,1460692800,1319,74,0,1532,180.69),(81,1460779200,1211,6,0,131,180.69),(81,1460865600,1199,17,0,358,180.68),(81,1460952000,1462,188,1,3884,180.63),(81,1461038400,1014,60,0,1237,180.61),(81,1461124800,984,157,1,3234,180.56),(81,1461211200,979,65,0,1350,180.54),(81,1461297600,1043,36,0,758,180.53),(81,1461384000,1379,26,0,541,180.53),(81,1461470400,1066,37,0,770,180.52),(81,1461556800,1493,228,2,4701,180.45),(81,1461643200,965,4,0,95,180.45),(81,1461729600,1248,272,2,5619,180.37),(81,1461816000,1245,2,0,44,180.37),(81,1461902400,979,1,0,32,180.37),(81,1461988800,1460,60,0,1242,180.35),(81,1462075200,1066,28,0,580,180.34),(81,1462161600,1248,166,1,3421,180.3),(81,1462248000,940,19,0,398,180.29),(81,1462334400,1020,19,0,398,180),(81,1462420800,0,0,0,0,180),(81,1462680000,0,0,0,0,180),(82,1462334400,0,0,0,0,220),(82,1462420800,0,0,0,0,220),(82,1462680000,0,0,0,0,220),(83,1459828800,0,494,3,7105,257.86),(83,1459915200,0,188,1,2713,257.8),(83,1460001600,0,503,3,7227,257.66),(83,1460088000,0,240,1,3450,257.59),(83,1460174400,0,123,0,1771,257.56),(83,1460260800,0,91,0,1314,257.53),(83,1460347200,0,130,0,1876,257.49),(83,1460433600,0,509,3,7317,257.35),(83,1460520000,0,250,1,3596,257.28),(83,1460606400,0,643,4,9242,257.09),(83,1460692800,0,99,0,1431,257.06),(83,1460779200,0,395,2,5683,256.95),(83,1460865600,0,338,2,4866,256.85),(83,1460952000,0,46,0,669,256.84),(83,1461038400,0,573,3,8241,256.68),(83,1461124800,0,327,2,4702,256.58),(83,1461211200,0,640,4,9202,256.4),(83,1461297600,0,127,0,1835,256.36),(83,1461384000,0,184,1,2645,256.31),(83,1461470400,0,169,1,2439,256.26),(83,1461556800,0,142,0,2048,256.22),(83,1461643200,0,860,5,12351,255.98),(83,1461729600,0,232,1,3334,255.91),(83,1461816000,0,619,4,8892,255.73),(83,1461902400,0,403,2,5801,255.62),(83,1461988800,0,473,3,6795,255.48),(83,1462075200,0,426,2,6125,255.36),(83,1462161600,0,282,1,4055,255.28),(83,1462248000,0,641,4,9217,255.1),(83,1462334400,670,272,1,3909,255.21),(83,1462420800,0,0,0,0,255),(83,1462680000,0,0,0,0,255),(84,1459828800,0,0,0,0,120.71),(84,1459915200,0,0,0,0,121.43),(84,1460001600,0,0,0,0,122.16),(84,1460088000,0,0,0,0,122.91),(84,1460174400,0,0,0,0,123.65),(84,1460260800,0,0,0,0,124.4),(84,1460347200,0,0,0,0,125.13),(84,1460433600,0,0,0,0,125.85),(84,1460520000,0,0,0,0,126.59),(84,1460606400,0,0,0,0,127.3),(84,1460692800,0,0,0,0,128.03),(84,1460779200,0,0,0,0,128.77),(84,1460865600,0,0,0,0,129.52),(84,1460952000,0,0,0,0,130.26),(84,1461038400,0,0,0,0,130.97),(84,1461124800,0,0,0,0,131.71),(84,1461211200,0,0,0,0,132.43),(84,1461297600,0,0,0,0,133.16),(84,1461384000,0,0,0,0,133.9),(84,1461470400,0,0,0,0,134.65),(84,1461556800,0,0,0,0,135.39),(84,1461643200,0,0,0,0,136.09),(84,1461729600,0,0,0,0,136.84),(84,1461816000,0,0,0,0,137.53),(84,1461902400,0,0,0,0,138.28),(84,1461988800,0,0,0,0,139.03),(84,1462075200,0,0,0,0,139.77),(84,1462161600,0,0,0,0,140.51),(84,1462248000,0,0,0,0,141.23),(84,1462334400,500,0,0,0,141.23),(84,1462420800,0,0,0,0,141),(84,1462680000,0,0,0,0,141),(87,1462420800,0,0,0,0,220),(87,1462680000,0,0,0,0,220),(88,1459828800,0,0,0,0,249.67),(88,1459915200,0,0,0,0,250.36),(88,1460001600,0,0,0,0,251.05),(88,1460088000,0,0,0,0,251.8),(88,1460174400,0,0,0,0,252.53),(88,1460260800,0,0,0,0,253.27),(88,1460347200,0,0,0,0,253.99),(88,1460433600,0,0,0,0,254.68),(88,1460520000,0,0,0,0,255.41),(88,1460606400,0,0,0,0,256.07),(88,1460692800,0,0,0,0,256.78),(88,1460779200,0,0,0,0,257.49),(88,1460865600,0,0,0,0,258.24),(88,1460952000,0,0,0,0,258.97),(88,1461038400,0,0,0,0,259.64),(88,1461124800,0,0,0,0,260.36),(88,1461211200,0,0,0,0,261.04),(88,1461297600,0,0,0,0,261.76),(88,1461384000,0,0,0,0,262.49),(88,1461470400,0,0,0,0,263.22),(88,1461556800,0,0,0,0,263.95),(88,1461643200,0,0,0,0,264.61),(88,1461729600,0,0,0,0,265.35),(88,1461816000,0,0,0,0,265.98),(88,1461902400,0,0,0,0,266.73),(88,1461988800,0,0,0,0,267.47),(88,1462075200,0,0,0,0,268.19),(88,1462161600,0,0,0,0,268.92),(88,1462248000,0,0,0,0,269.6),(88,1462334400,1718,550,0,0,270.34),(88,1462420800,0,0,0,0,270),(88,1462680000,0,0,0,0,270),(89,1461816000,0,0,0,0,100),(89,1461902400,0,0,0,0,100),(89,1461988800,0,0,0,0,100),(89,1462075200,0,0,0,0,100),(89,1462161600,0,0,0,0,100),(89,1462248000,0,0,0,0,100),(89,1462334400,396,1634,0,0,0),(89,1462420800,0,0,0,0,100),(89,1462680000,0,0,0,0,100),(90,1459828800,0,239,1,4066,218.93),(90,1459915200,0,156,1,2660,218.89),(90,1460001600,0,146,1,2498,218.84),(90,1460088000,0,2,0,35,218.84),(90,1460174400,0,41,0,698,218.83),(90,1460260800,0,4,0,75,218.83),(90,1460347200,0,64,0,1094,218.81),(90,1460433600,0,176,1,2996,218.76),(90,1460520000,0,40,0,696,218.75),(90,1460606400,0,259,2,4419,218.68),(90,1460692800,0,96,0,1637,218.65),(90,1460779200,0,90,0,1532,218.62),(90,1460865600,0,7,0,131,218.62),(90,1460952000,0,21,0,358,218.61),(90,1461038400,0,228,1,3884,218.55),(90,1461124800,0,72,0,1237,218.53),(90,1461211200,0,190,1,3234,218.47),(90,1461297600,0,79,0,1350,218.45),(90,1461384000,0,44,0,758,218.44),(90,1461470400,0,31,0,541,218.43),(90,1461556800,0,45,0,770,218.41),(90,1461643200,0,276,2,4701,218.34),(90,1461729600,0,5,0,95,218.33),(90,1461816000,0,330,2,5619,218.24),(90,1461902400,0,2,0,44,218.24),(90,1461988800,0,1,0,32,218.24),(90,1462075200,0,73,0,1242,218.22),(90,1462161600,0,34,0,580,218.21),(90,1462248000,0,201,1,3421,218.15),(90,1462334400,0,23,0,398,218.14),(90,1462420800,0,0,0,0,218),(90,1462680000,0,0,0,0,218),(92,1459828800,2191,469,3,7105,245.49),(92,1459915200,1411,179,1,2713,245.83),(92,1460001600,1483,483,3,7227,248),(92,1460088000,1782,230,1,3450,248),(92,1460174400,1461,118,0,1771,248),(92,1460260800,2161,87,0,1314,248),(92,1460347200,1818,125,0,1876,248),(92,1460433600,2010,489,3,7317,248),(92,1460520000,1594,240,1,3596,248),(92,1460606400,2142,618,4,9242,248),(92,1460692800,2128,95,0,1431,248),(92,1460779200,2014,380,2,5683,248),(92,1460865600,1487,325,2,4866,248),(92,1460952000,1593,44,0,669,248),(92,1461038400,2104,551,3,8241,248),(92,1461124800,1941,314,2,4702,248),(92,1461211200,1993,615,4,9202,248),(92,1461297600,1943,122,0,1835,248),(92,1461384000,1534,177,1,2645,248),(92,1461470400,2041,163,1,2439,248),(92,1461556800,1801,137,0,2048,248),(92,1461643200,1486,826,5,12351,248),(92,1461729600,1425,223,1,3334,248),(92,1461816000,2067,595,4,8892,248),(92,1461902400,1459,388,2,5801,248),(92,1461988800,2095,454,3,6795,248),(92,1462075200,1500,409,2,6125,248),(92,1462161600,1413,271,1,4055,248),(92,1462248000,1965,616,4,9217,248),(92,1462334400,1784,494,3,7383,248),(92,1462420800,1957,2039,0,0,280),(92,1462680000,0,900,0,0,200),(93,1462420800,0,0,0,0,150),(93,1462680000,0,0,0,0,150),(94,1462420800,0,0,0,0,150),(94,1462680000,0,0,0,0,150),(95,1459915200,0,228,0,4066,207.96),(95,1460001600,0,149,0,2660,207.92),(95,1460088000,0,140,0,2498,207.92),(95,1460174400,0,1,0,35,207.91),(95,1460260800,0,39,0,698,207.9),(95,1460347200,0,4,0,75,207.89),(95,1460433600,0,61,0,1094,207.84),(95,1460520000,0,168,0,2996,207.83),(95,1460606400,0,39,0,696,207.76),(95,1460692800,0,248,0,4419,207.73),(95,1460779200,0,91,0,1637,207.71),(95,1460865600,0,86,0,1532,207.7),(95,1460952000,0,7,0,131,207.7),(95,1461038400,0,20,0,358,207.64),(95,1461124800,0,218,0,3884,207.62),(95,1461211200,0,69,0,1237,207.56),(95,1461297600,0,181,0,3234,207.54),(95,1461384000,0,75,0,1350,207.53),(95,1461470400,0,42,0,758,207.52),(95,1461556800,0,30,0,541,207.51),(95,1461643200,0,43,0,770,207.43),(95,1461729600,0,263,0,4701,207.43),(95,1461816000,0,5,0,95,207.34),(95,1461902400,0,315,0,5619,207.34),(95,1461988800,0,2,0,44,207.34),(95,1462075200,0,1,0,32,207.32),(95,1462161600,0,69,0,1242,207.31),(95,1462248000,0,32,0,580,207.26),(95,1462334400,0,192,0,3421,207.24),(95,1462420800,3492,1484,0,1278,207),(95,1462680000,0,0,0,0,207),(96,1459915200,0,0,0,0,28),(96,1460001600,0,0,0,0,28),(96,1460088000,0,0,0,0,28),(96,1460174400,0,0,0,0,28),(96,1460260800,0,0,0,0,28),(96,1460347200,0,0,0,0,28),(96,1460433600,0,0,0,0,28),(96,1460520000,0,0,0,0,28),(96,1460606400,0,0,0,0,28),(96,1460692800,0,0,0,0,28),(96,1460779200,0,0,0,0,28),(96,1460865600,0,0,0,0,28),(96,1460952000,0,0,0,0,28),(96,1461038400,0,0,0,0,28),(96,1461124800,0,0,0,0,28),(96,1461211200,0,0,0,0,28),(96,1461297600,0,0,0,0,28),(96,1461384000,0,0,0,0,28),(96,1461470400,0,0,0,0,28),(96,1461556800,0,0,0,0,28),(96,1461643200,0,0,0,0,28),(96,1461729600,0,0,0,0,28),(96,1461816000,0,0,0,0,28),(96,1461902400,0,0,0,0,28),(96,1461988800,0,0,0,0,28),(96,1462075200,0,0,0,0,28),(96,1462161600,0,0,0,0,28),(96,1462248000,0,0,0,0,28),(96,1462334400,0,0,0,0,28),(96,1462420800,3259,0,0,0,28),(96,1462680000,0,0,0,0,28),(97,1459915200,0,0,0,0,280),(97,1460001600,0,0,0,0,280),(97,1460088000,0,0,0,0,280),(97,1460174400,0,0,0,0,280),(97,1460260800,0,0,0,0,280),(97,1460347200,0,0,0,0,280),(97,1460433600,0,0,0,0,280),(97,1460520000,0,0,0,0,280),(97,1460606400,0,0,0,0,280),(97,1460692800,0,0,0,0,280),(97,1460779200,0,0,0,0,280),(97,1460865600,0,0,0,0,280),(97,1460952000,0,0,0,0,280),(97,1461038400,0,0,0,0,280),(97,1461124800,0,0,0,0,280),(97,1461211200,0,0,0,0,280),(97,1461297600,0,0,0,0,280),(97,1461384000,0,0,0,0,280),(97,1461470400,0,0,0,0,280),(97,1461556800,0,0,0,0,280),(97,1461643200,0,0,0,0,280),(97,1461729600,0,0,0,0,280),(97,1461816000,0,0,0,0,280),(97,1461902400,0,0,0,0,280),(97,1461988800,0,0,0,0,280),(97,1462075200,0,0,0,0,280),(97,1462161600,0,0,0,0,280),(97,1462248000,0,0,0,0,280),(97,1462334400,0,0,0,0,280),(97,1462420800,0,0,0,0,280),(97,1462680000,0,0,0,0,280),(98,1459915200,0,813,1,4066,743.85),(98,1460001600,0,531,1,2660,743.7),(98,1460088000,0,499,1,2498,743.7),(98,1460174400,0,6,0,35,743.66),(98,1460260800,0,139,0,698,743.66),(98,1460347200,0,14,0,75,743.59),(98,1460433600,0,218,0,1094,743.42),(98,1460520000,0,599,1,2996,743.38),(98,1460606400,0,139,0,696,743.13),(98,1460692800,0,883,2,4419,743.04),(98,1460779200,0,327,0,1637,742.95),(98,1460865600,0,306,0,1532,742.94),(98,1460952000,0,26,0,131,742.92),(98,1461038400,0,71,0,358,742.7),(98,1461124800,0,776,1,3884,742.63),(98,1461211200,0,247,0,1237,742.44),(98,1461297600,0,646,1,3234,742.36),(98,1461384000,0,269,0,1350,742.32),(98,1461470400,0,151,0,758,742.29),(98,1461556800,0,108,0,541,742.24),(98,1461643200,0,153,0,770,741.97),(98,1461729600,0,940,2,4701,741.97),(98,1461816000,0,18,0,95,741.65),(98,1461902400,0,1123,2,5619,741.64),(98,1461988800,0,8,0,44,741.64),(98,1462075200,0,6,0,32,741.57),(98,1462161600,0,248,0,1242,741.54),(98,1462248000,0,115,0,580,741.34),(98,1462334400,0,684,1,3421,741.27),(98,1462420800,500,255,0,1278,741.27),(98,1462680000,0,0,0,0,743),(99,1462680000,0,0,0,0,175),(100,1462680000,0,0,0,0,158),(101,1462680000,0,0,0,0,150),(102,1462680000,0,0,0,0,150),(103,1460347200,0,0,0,0,158),(103,1460433600,0,0,0,0,158),(103,1460520000,0,0,0,0,158),(103,1460606400,0,0,0,0,158),(103,1460692800,0,0,0,0,158),(103,1460779200,0,0,0,0,158),(103,1460865600,0,0,0,0,158),(103,1460952000,0,0,0,0,158),(103,1461038400,0,0,0,0,158),(103,1461124800,0,0,0,0,158),(103,1461211200,0,0,0,0,158),(103,1461297600,0,0,0,0,158),(103,1461384000,0,0,0,0,158),(103,1461470400,0,0,0,0,158),(103,1461556800,0,0,0,0,158),(103,1461643200,0,0,0,0,158),(103,1461729600,0,0,0,0,158),(103,1461816000,0,0,0,0,158),(103,1461902400,0,0,0,0,158),(103,1461988800,0,0,0,0,158),(103,1462075200,0,0,0,0,158),(103,1462161600,0,0,0,0,158),(103,1462248000,0,0,0,0,158),(103,1462334400,0,0,0,0,158),(103,1462420800,260,0,0,0,158),(103,1462680000,0,0,0,0,158),(103,1464210168,0,0,0,0,158),(103,1464296568,0,0,0,0,158),(103,1464382968,0,0,0,0,158),(103,1464469368,0,0,0,0,158),(103,1464555768,0,0,0,0,158),(104,1459915200,0,247,1,7105,129.97),(104,1460001600,0,94,1,2713,129.95),(104,1460088000,0,251,1,7227,129.95),(104,1460174400,0,120,0,3450,129.94),(104,1460260800,0,61,0,1771,129.94),(104,1460347200,0,45,0,1314,129.93),(104,1460433600,0,65,0,1876,129.9),(104,1460520000,0,254,1,7317,129.89),(104,1460606400,0,125,0,3596,129.85),(104,1460692800,0,321,2,9242,129.83),(104,1460779200,0,49,0,1431,129.82),(104,1460865600,0,197,0,5683,129.81),(104,1460952000,0,169,0,4866,129.81),(104,1461038400,0,23,0,669,129.77),(104,1461124800,0,286,1,8241,129.76),(104,1461211200,0,163,0,4702,129.73),(104,1461297600,0,320,1,9202,129.71),(104,1461384000,0,63,0,1835,129.71),(104,1461470400,0,92,0,2645,129.7),(104,1461556800,0,84,0,2439,129.69),(104,1461643200,0,71,0,2048,129.65),(104,1461729600,0,430,2,12351,129.65),(104,1461816000,0,116,0,3334,129.59),(104,1461902400,0,309,2,8892,129.59),(104,1461988800,0,201,0,5801,129.59),(104,1462075200,0,236,0,6795,129.58),(104,1462161600,0,213,0,6125,129.57),(104,1462248000,0,141,0,4055,129.54),(104,1462334400,0,320,1,9217,129.52),(104,1462420800,0,257,0,7383,129.52),(104,1462680000,0,0,0,0,129),(105,1462680000,0,0,0,0,130),(106,1459915200,0,0,0,0,280),(106,1460001600,0,0,0,0,280),(106,1460088000,0,0,0,0,280),(106,1460174400,0,0,0,0,280),(106,1460260800,0,0,0,0,280),(106,1460347200,0,0,0,0,280),(106,1460433600,0,0,0,0,280),(106,1460520000,0,0,0,0,280),(106,1460606400,0,0,0,0,280),(106,1460692800,0,0,0,0,280),(106,1460779200,0,0,0,0,280),(106,1460865600,0,0,0,0,280),(106,1460952000,0,0,0,0,280),(106,1461038400,0,0,0,0,280),(106,1461124800,0,0,0,0,280),(106,1461211200,0,0,0,0,280),(106,1461297600,0,0,0,0,280),(106,1461384000,0,0,0,0,280),(106,1461470400,0,0,0,0,280),(106,1461556800,0,0,0,0,280),(106,1461643200,0,0,0,0,280),(106,1461729600,0,0,0,0,280),(106,1461816000,0,0,0,0,280),(106,1461902400,0,0,0,0,280),(106,1461988800,0,0,0,0,280),(106,1462075200,0,0,0,0,280),(106,1462161600,0,0,0,0,280),(106,1462248000,0,0,0,0,280),(106,1462334400,0,0,0,0,280),(106,1462420800,0,0,0,0,280),(106,1462680000,0,0,0,0,280),(107,1460347200,0,0,0,0,147),(107,1460433600,0,0,0,0,147),(107,1460520000,0,0,0,0,147),(107,1460606400,0,0,0,0,147),(107,1460692800,0,0,0,0,147),(107,1460779200,0,0,0,0,147),(107,1460865600,0,0,0,0,147),(107,1460952000,0,0,0,0,147),(107,1461038400,0,0,0,0,147),(107,1461124800,0,0,0,0,147),(107,1461211200,0,0,0,0,147),(107,1461297600,0,0,0,0,147),(107,1461384000,0,0,0,0,147),(107,1461470400,0,0,0,0,147),(107,1461556800,0,0,0,0,147),(107,1461643200,0,0,0,0,147),(107,1461729600,0,0,0,0,147),(107,1461816000,0,0,0,0,147),(107,1461902400,0,0,0,0,147),(107,1461988800,0,0,0,0,147),(107,1462075200,0,0,0,0,147),(107,1462161600,0,0,0,0,147),(107,1462248000,0,0,0,0,147),(107,1462334400,0,0,0,0,147),(107,1462420800,0,0,0,0,147),(107,1462680000,0,0,0,0,147),(107,1464210167,0,0,0,0,147),(107,1464296567,0,0,0,0,147),(107,1464382967,0,0,0,0,147),(107,1464469367,0,0,0,0,147),(107,1464555767,0,0,0,0,147),(108,1462680000,0,0,0,0,180),(109,1462680000,0,0,0,0,180),(110,1462680000,0,0,0,0,180),(111,1460433600,0,0,0,0,200),(111,1460520000,0,0,0,0,200),(111,1460606400,0,0,0,0,200),(111,1460692800,0,0,0,0,200),(111,1460779200,0,0,0,0,200),(111,1460865600,0,0,0,0,200),(111,1460952000,0,0,0,0,200),(111,1461038400,0,0,0,0,200),(111,1461124800,0,0,0,0,200),(111,1461211200,0,0,0,0,200),(111,1461297600,0,0,0,0,200),(111,1461384000,0,0,0,0,200),(111,1461470400,0,0,0,0,200),(111,1461556800,0,0,0,0,200),(111,1461643200,0,0,0,0,200),(111,1461729600,0,0,0,0,200),(111,1461816000,0,0,0,0,200),(111,1461902400,0,0,0,0,200),(111,1461988800,0,0,0,0,200),(111,1462075200,0,0,0,0,200),(111,1462161600,0,0,0,0,200),(111,1462248000,0,0,0,0,200),(111,1462334400,0,0,0,0,200),(111,1462420800,0,0,0,0,200),(111,1462507200,0,0,0,0,200),(111,1462680000,0,0,0,0,200),(111,1464296567,0,0,0,0,200),(111,1464382967,0,0,0,0,200),(111,1464469367,0,0,0,0,200),(111,1464555767,0,0,0,0,200),(111,1464642167,0,0,0,0,200),(112,1460088000,0,329,0,0,300),(112,1460174400,0,215,0,0,300),(112,1460260800,0,202,0,0,300),(112,1460347200,0,2,0,0,300),(112,1460433600,0,56,0,0,300),(112,1460520000,0,6,0,0,300),(112,1460606400,0,88,0,0,300),(112,1460692800,0,242,0,0,300),(112,1460779200,0,56,0,0,300),(112,1460865600,0,357,0,0,300),(112,1460952000,0,132,0,0,300),(112,1461038400,0,124,0,0,300),(112,1461124800,0,10,0,0,300),(112,1461211200,0,28,0,0,300),(112,1461297600,0,314,0,0,300),(112,1461384000,0,100,0,0,300),(112,1461470400,0,261,0,0,300),(112,1461556800,0,109,0,0,300),(112,1461643200,0,61,0,0,300),(112,1461729600,0,43,0,0,300),(112,1461816000,0,62,0,0,300),(112,1461902400,0,380,0,0,300),(112,1461988800,0,7,0,0,300),(112,1462075200,0,454,0,0,300),(112,1462161600,0,3,0,0,300),(112,1462248000,0,2,0,32,300),(112,1462334400,0,100,0,1242,300),(112,1462420800,0,46,0,580,300),(112,1462507200,0,276,0,3421,300),(112,1462593600,0,103,0,1278,300),(112,1462680000,0,0,0,0,300),(113,1460606400,0,0,0,0,170),(113,1460692800,0,0,0,0,170),(113,1460779200,0,0,0,0,170),(113,1460865600,0,0,0,0,170),(113,1460952000,0,0,0,0,170),(113,1461038400,0,0,0,0,170),(113,1461124800,0,0,0,0,170),(113,1461211200,0,0,0,0,170),(113,1461297600,0,0,0,0,170),(113,1461384000,0,0,0,0,170),(113,1461470400,0,0,0,0,170),(113,1461556800,0,0,0,0,170),(113,1461643200,0,0,0,0,170),(113,1461729600,0,0,0,0,170),(113,1461816000,0,0,0,0,170),(113,1461902400,0,0,0,0,170),(113,1461988800,0,0,0,0,170),(113,1462075200,0,0,0,0,170),(113,1462161600,0,0,0,0,170),(113,1462248000,0,0,0,0,170),(113,1462334400,0,0,0,0,170),(113,1462420800,0,0,0,0,170),(113,1462507200,0,0,0,0,170),(113,1462593600,0,0,0,0,170),(113,1462680000,0,0,0,0,170),(113,1464469367,0,0,0,0,170),(113,1464555767,0,0,0,0,170),(113,1464642167,0,0,0,0,170),(113,1464728567,0,0,0,0,170),(113,1464814967,0,0,0,0,170);
/*!40000 ALTER TABLE `Progress` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `UserIndex`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `UserIndex` (
`UserID` int(11) NOT NULL,
`ChallengeType` varchar(255) NOT NULL,
`Ind` int(11) NOT NULL,
PRIMARY KEY (`UserID`,`ChallengeType`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `UserIndex`
--
LOCK TABLES `UserIndex` WRITE;
/*!40000 ALTER TABLE `UserIndex` DISABLE KEYS */;
INSERT INTO `UserIndex` VALUES (1,'Cardio',0),(1,'Core',1),(1,'Lower',3),(1,'Upper',0),(1,'Weekly',7),(2,'Cardio',0),(2,'Core',0),(2,'Lower',0),(2,'Upper',0),(2,'Weekly',7),(3,'Cardio',0),(3,'Core',0),(3,'Lower',0),(3,'Upper',0),(3,'Weekly',0),(4,'Cardio',0),(4,'Core',0),(4,'Lower',0),(4,'Upper',0),(4,'Weekly',1),(5,'Cardio',0),(5,'Core',0),(5,'Lower',0),(5,'Upper',0),(5,'Weekly',7),(6,'Cardio',0),(6,'Core',0),(6,'Lower',0),(6,'Upper',0),(6,'Weekly',0),(7,'Cardio',0),(7,'Core',0),(7,'Lower',0),(7,'Upper',0),(7,'Weekly',1),(8,'Cardio',0),(8,'Core',0),(8,'Lower',0),(8,'Upper',0),(8,'Weekly',0),(9,'Cardio',0),(9,'Core',0),(9,'Lower',0),(9,'Upper',0),(9,'Weekly',0),(10,'Cardio',0),(10,'Core',0),(10,'Lower',0),(10,'Upper',0),(10,'Weekly',0),(11,'Cardio',0),(11,'Core',0),(11,'Lower',0),(11,'Upper',0),(11,'Weekly',1),(12,'Cardio',0),(12,'Core',0),(12,'Lower',0),(12,'Upper',0),(12,'Weekly',0),(13,'Cardio',0),(13,'Core',0),(13,'Lower',0),(13,'Upper',0),(13,'Weekly',0),(14,'Cardio',0),(14,'Core',0),(14,'Lower',0),(14,'Upper',0),(14,'Weekly',0),(15,'Cardio',0),(15,'Core',0),(15,'Lower',0),(15,'Upper',0),(15,'Weekly',0),(16,'Cardio',0),(16,'Core',0),(16,'Lower',0),(16,'Upper',0),(16,'Weekly',0),(17,'Cardio',0),(17,'Core',0),(17,'Lower',0),(17,'Upper',0),(17,'Weekly',0),(18,'Cardio',0),(18,'Core',0),(18,'Lower',0),(18,'Upper',0),(18,'Weekly',0),(19,'Cardio',0),(19,'Core',0),(19,'Lower',0),(19,'Upper',0),(19,'Weekly',0),(20,'Cardio',0),(20,'Core',0),(20,'Lower',0),(20,'Upper',0),(20,'Weekly',1),(21,'Cardio',0),(21,'Core',0),(21,'Lower',0),(21,'Upper',0),(21,'Weekly',0),(22,'Cardio',0),(22,'Core',0),(22,'Lower',0),(22,'Upper',0),(22,'Weekly',0),(23,'Cardio',0),(23,'Core',0),(23,'Lower',0),(23,'Upper',0),(23,'Weekly',0),(24,'Cardio',0),(24,'Core',0),(24,'Lower',0),(24,'Upper',0),(24,'Weekly',0),(25,'Cardio',0),(25,'Core',0),(25,'Lower',0),(25,'Upper',0),(25,'Weekly',0),(26,'Cardio',0),(26,'Core',0),(26,'Lower',0),(26,'Upper',0),(26,'Weekly',0),(27,'Cardio',0),(27,'Core',0),(27,'Lower',0),(27,'Upper',0),(27,'Weekly',0),(28,'Cardio',0),(28,'Core',0),(28,'Lower',0),(28,'Upper',0),(28,'Weekly',0),(29,'Cardio',0),(29,'Core',0),(29,'Lower',0),(29,'Upper',0),(29,'Weekly',0),(30,'Cardio',0),(30,'Core',0),(30,'Lower',0),(30,'Upper',0),(30,'Weekly',0),(31,'Cardio',0),(31,'Core',0),(31,'Lower',0),(31,'Upper',0),(31,'Weekly',0),(32,'Cardio',0),(32,'Core',0),(32,'Lower',0),(32,'Upper',0),(32,'Weekly',0),(33,'Cardio',0),(33,'Core',0),(33,'Lower',0),(33,'Upper',0),(33,'Weekly',0),(34,'Cardio',0),(34,'Core',0),(34,'Lower',0),(34,'Upper',0),(34,'Weekly',0),(35,'Cardio',0),(35,'Core',0),(35,'Lower',0),(35,'Upper',0),(35,'Weekly',0),(36,'Cardio',0),(36,'Core',0),(36,'Lower',0),(36,'Upper',0),(36,'Weekly',0),(37,'Cardio',0),(37,'Core',0),(37,'Lower',0),(37,'Upper',0),(37,'Weekly',0),(38,'Cardio',0),(38,'Core',0),(38,'Lower',0),(38,'Upper',0),(38,'Weekly',0),(39,'Cardio',0),(39,'Core',0),(39,'Lower',0),(39,'Upper',0),(39,'Weekly',0),(40,'Cardio',0),(40,'Core',0),(40,'Lower',0),(40,'Upper',0),(40,'Weekly',0),(41,'Cardio',0),(41,'Core',0),(41,'Lower',0),(41,'Upper',0),(41,'Weekly',0),(42,'Cardio',0),(42,'Core',0),(42,'Lower',0),(42,'Upper',0),(42,'Weekly',0),(43,'Cardio',0),(43,'Core',0),(43,'Lower',0),(43,'Upper',0),(43,'Weekly',0),(44,'Cardio',0),(44,'Core',0),(44,'Lower',0),(44,'Upper',0),(44,'Weekly',0),(45,'Cardio',0),(45,'Core',0),(45,'Lower',0),(45,'Upper',0),(45,'Weekly',0),(46,'Cardio',0),(46,'Core',0),(46,'Lower',0),(46,'Upper',0),(46,'Weekly',0),(47,'Cardio',0),(47,'Core',0),(47,'Lower',0),(47,'Upper',0),(47,'Weekly',0),(48,'Cardio',0),(48,'Core',0),(48,'Lower',0),(48,'Upper',0),(48,'Weekly',0),(49,'Cardio',0),(49,'Core',0),(49,'Lower',0),(49,'Upper',0),(49,'Weekly',0),(50,'Cardio',0),(50,'Core',0),(50,'Lower',0),(50,'Upper',0),(50,'Weekly',0),(51,'Cardio',0),(51,'Core',0),(51,'Lower',0),(51,'Upper',0),(51,'Weekly',0),(52,'Cardio',2),(52,'Core',2),(52,'Lower',11),(52,'Upper',7),(52,'Weekly',1),(53,'Cardio',0),(53,'Core',0),(53,'Lower',0),(53,'Upper',0),(53,'Weekly',0),(54,'Cardio',0),(54,'Core',0),(54,'Lower',0),(54,'Upper',0),(54,'Weekly',0),(55,'Cardio',0),(55,'Core',0),(55,'Lower',0),(55,'Upper',0),(55,'Weekly',0),(56,'Cardio',0),(56,'Core',0),(56,'Lower',0),(56,'Upper',0),(56,'Weekly',0),(57,'Cardio',0),(57,'Core',0),(57,'Lower',0),(57,'Upper',0),(57,'Weekly',0),(63,'Cardio',1),(63,'Core',3),(63,'Lower',2),(63,'Upper',0),(63,'Weekly',2),(64,'Cardio',1),(64,'Core',0),(64,'Lower',0),(64,'Upper',1),(64,'Weekly',0),(65,'Cardio',0),(65,'Core',0),(65,'Lower',1),(65,'Upper',0),(65,'Weekly',0),(72,'Cardio',0),(72,'Core',0),(72,'Lower',0),(72,'Upper',0),(72,'Weekly',0),(74,'Cardio',1),(74,'Core',1),(74,'Lower',1),(74,'Upper',1),(74,'Weekly',4),(75,'Cardio',1),(75,'Core',1),(75,'Lower',2),(75,'Upper',2),(75,'Weekly',2),(77,'Cardio',0),(77,'Core',0),(77,'Lower',0),(77,'Upper',0),(77,'Weekly',0),(81,'Cardio',1),(81,'Core',1),(81,'Lower',0),(81,'Upper',0),(81,'Weekly',0),(83,'Cardio',0),(83,'Core',1),(83,'Lower',1),(83,'Upper',0),(83,'Weekly',1),(88,'Cardio',1),(88,'Core',0),(88,'Lower',0),(88,'Upper',1),(88,'Weekly',1),(91,'Cardio',0),(91,'Core',0),(91,'Lower',0),(91,'Upper',0),(91,'Weekly',0),(92,'Cardio',2),(92,'Core',0),(92,'Lower',0),(92,'Upper',0),(92,'Weekly',2),(95,'Cardio',0),(95,'Core',0),(95,'Lower',0),(95,'Upper',0),(95,'Weekly',0),(96,'Cardio',0),(96,'Core',0),(96,'Lower',0),(96,'Upper',0),(96,'Weekly',0),(98,'Cardio',0),(98,'Core',1),(98,'Lower',1),(98,'Upper',0),(98,'Weekly',0);
/*!40000 ALTER TABLE `UserIndex` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `UsersProgress`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `UsersProgress` (
`uid` int(11) NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`uid`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `UsersProgress`
--
LOCK TABLES `UsersProgress` WRITE;
/*!40000 ALTER TABLE `UsersProgress` DISABLE KEYS */;
INSERT INTO `UsersProgress` VALUES (1,1),(14,5),(14,6);
/*!40000 ALTER TABLE `UsersProgress` ENABLE KEYS */;
UNLOCK TABLES;
CREATE EVENT progressEntryCreation
ON SCHEDULE
EVERY 1 DAY
STARTS '2016-05-09 00:00:00' ON COMPLETION PRESERVE ENABLE
DO
INSERT INTO BetterU.Progress(UserId, LogDate, CaloriesIn, CaloriesOut, Weight, Miles, Steps) SELECT DISTINCT id, UNIX_TIMESTAMP(CURDATE()), '0', '0', Weight, '0', '0' FROM User WHERE NOT EXISTS (Select 1 FROM Progress WHERE logDate=UNIX_TIMESTAMP(CURDATE()) AND UserId=id);
/*!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 2016-05-08 21:07:29