-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathKapino.sql
209 lines (182 loc) · 81.1 KB
/
Kapino.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
CREATE DATABASE IF NOT EXISTS `kapino` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `kapino`;
-- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
--
-- Host: 127.0.0.1 Database: kapino
-- ------------------------------------------------------
-- Server version 5.6.28
/*!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 `farms`
--
DROP TABLE IF EXISTS `farms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `farms` (
`farmID` int(11) NOT NULL AUTO_INCREMENT,
`hectare` float DEFAULT NULL,
`location` varchar(45) NOT NULL,
`name` varchar(45) DEFAULT NULL,
`size` enum('small holder','plantation') DEFAULT NULL,
PRIMARY KEY (`farmID`),
UNIQUE KEY `farmID_UNIQUE` (`farmID`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `farms`
--
LOCK TABLES `farms` WRITE;
/*!40000 ALTER TABLE `farms` DISABLE KEYS */;
INSERT INTO `farms` VALUES (1,12.72,'Caloocan','Thoughtworks','plantation'),(2,NULL,'Quezon City',NULL,'small holder'),(3,13.42,'Tarlac','Gabvine','plantation'),(4,1.73,'Cebu','Alphine','small holder'),(5,12.46,'Marinduque','Bluezoom','plantation'),(6,1.94,'Makati','Chatterbridge','small holder'),(7,13.68,'Laguna, Rizal','Twitterworks','plantation'),(8,9.08,'Cebu','Quamba','plantation'),(9,6.93,'Davao City','Quamba','plantation'),(10,16.99,'Butuan','Ntags','plantation'),(11,6.72,'Banga, Aklan','Dynazzy','plantation'),(12,10.68,'Albay','Wikizz','plantation'),(13,1.42,'Batangas','Rhyloo','small holder'),(14,5.59,'Cavite','Brainlounge','plantation'),(15,5.07,'Las Pinas, Manila','Brightbean','plantation'),(16,2.69,'Bohol','Fadeo','plantation'),(17,NULL,'Bukidnon',NULL,'small holder'),(18,9.93,'Cagayan de Oro','Rhyzio','plantation'),(19,NULL,'Magindanao',NULL,'small holder'),(20,10.61,'Samar, Leyte','Centidel','plantation'),(21,NULL,'Camarines Norte',NULL,'small holder'),(22,3,'Quezon Province','Trudeo','plantation'),(23,13.66,'Guimaras','Jatri','plantation'),(24,8.51,'Laguna, Rizal','Devpulse','plantation'),(25,10.49,'Palawan','Photojam','plantation'),(26,1.7,'Pampanga','Eayo','small holder'),(27,16.08,'Binangonan, Rizal','Zooveo','plantation'),(28,9.57,'Romblon','Omba','plantation'),(29,19.3,'Pangasinan','Oxnab','plantation'),(30,NULL,'South Cotabato',NULL,'small holder');
/*!40000 ALTER TABLE `farms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `favorites`
--
DROP TABLE IF EXISTS `favorites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `favorites` (
`faveID` int(11) NOT NULL AUTO_INCREMENT,
`prodID` int(11) NOT NULL,
`userID` int(11) NOT NULL,
`faveDate` date NOT NULL,
PRIMARY KEY (`faveID`),
UNIQUE KEY `faveID_UNIQUE` (`faveID`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `favorites`
--
LOCK TABLES `favorites` WRITE;
/*!40000 ALTER TABLE `favorites` DISABLE KEYS */;
INSERT INTO `favorites` VALUES (1,194,91,'2016-08-06'),(2,146,78,'2016-08-06'),(3,46,195,'2016-08-06'),(4,138,136,'2016-08-06'),(5,130,97,'2016-08-08'),(6,88,168,'2016-08-09'),(7,114,67,'2016-08-09'),(8,187,118,'2016-08-10'),(9,1,27,'2016-08-07'),(10,138,102,'2016-08-09'),(11,198,43,'2016-08-08'),(12,53,179,'2016-08-07'),(13,43,110,'2016-08-05'),(14,36,10,'2016-08-10'),(15,70,108,'2016-08-06'),(16,86,170,'2016-08-09'),(17,34,10,'2016-08-08'),(18,157,166,'2016-08-05'),(19,94,170,'2016-08-11'),(20,200,160,'2016-08-08'),(21,82,111,'2016-08-09'),(22,113,93,'2016-08-09'),(23,190,12,'2016-08-11'),(24,138,59,'2016-08-07'),(25,52,117,'2016-08-07'),(26,117,152,'2016-08-08'),(27,162,158,'2016-08-05'),(28,11,134,'2016-08-08'),(29,113,18,'2016-08-10'),(30,113,75,'2016-08-06'),(31,175,122,'2016-08-08'),(32,69,108,'2016-08-10'),(33,191,117,'2016-08-05'),(34,20,83,'2016-08-10'),(35,180,200,'2016-08-08'),(36,142,140,'2016-08-08'),(37,139,187,'2016-08-09'),(38,3,102,'2016-08-05'),(39,138,74,'2016-08-07'),(40,123,117,'2016-08-08'),(41,6,131,'2016-08-06'),(42,15,154,'2016-08-06'),(43,166,89,'2016-08-06'),(44,147,185,'2016-08-06'),(45,27,96,'2016-08-10'),(46,24,44,'2016-08-10'),(47,31,146,'2016-08-11'),(48,39,18,'2016-08-06'),(49,78,138,'2016-08-05'),(50,116,97,'2016-08-07'),(51,89,179,'2016-08-08'),(52,59,189,'2016-08-10'),(53,59,18,'2016-08-05'),(54,165,6,'2016-08-06'),(55,100,25,'2016-08-06'),(56,170,124,'2016-08-11'),(57,199,131,'2016-08-09'),(58,185,85,'2016-08-09'),(59,92,9,'2016-08-10'),(60,49,131,'2016-08-10'),(61,175,169,'2016-08-07'),(62,15,51,'2016-08-05'),(63,58,135,'2016-08-10'),(64,174,129,'2016-08-05'),(65,35,158,'2016-08-07'),(66,159,79,'2016-08-08'),(67,56,174,'2016-08-09'),(68,53,53,'2016-08-05'),(69,141,139,'2016-08-05'),(70,125,127,'2016-08-06'),(71,53,79,'2016-08-09'),(72,5,161,'2016-08-11'),(73,152,102,'2016-08-09'),(74,178,133,'2016-08-08'),(75,47,145,'2016-08-05'),(76,150,55,'2016-08-05'),(77,105,41,'2016-08-10'),(78,27,180,'2016-08-10'),(79,85,185,'2016-08-08'),(80,138,180,'2016-08-09'),(81,103,11,'2016-08-09'),(82,6,128,'2016-08-09'),(83,173,155,'2016-08-07'),(84,183,37,'2016-08-10'),(85,29,156,'2016-08-08'),(86,52,129,'2016-08-07'),(87,151,69,'2016-08-07'),(88,194,62,'2016-08-08'),(89,197,177,'2016-08-11'),(90,200,36,'2016-08-06'),(91,118,123,'2016-08-07'),(92,52,176,'2016-08-10'),(93,158,136,'2016-08-10'),(94,100,185,'2016-08-07'),(95,192,146,'2016-08-09'),(96,189,97,'2016-08-09'),(97,1,174,'2016-08-06'),(98,13,85,'2016-08-05'),(99,83,142,'2016-08-06'),(100,31,163,'2016-08-10'),(101,99,174,'2016-08-08'),(102,76,68,'2016-08-07'),(103,183,19,'2016-08-11'),(104,77,165,'2016-08-07'),(105,72,173,'2016-08-06'),(106,74,53,'2016-08-08'),(107,197,140,'2016-08-10'),(108,154,178,'2016-08-06'),(109,196,103,'2016-08-05'),(110,124,50,'2016-08-07'),(111,65,174,'2016-08-07'),(112,128,197,'2016-08-09'),(113,145,94,'2016-08-09'),(114,17,181,'2016-08-07'),(115,26,183,'2016-08-08'),(116,104,42,'2016-08-05'),(117,127,37,'2016-08-05'),(118,127,92,'2016-08-05'),(119,169,107,'2016-08-05'),(120,99,70,'2016-08-07'),(121,180,12,'2016-08-08'),(122,200,162,'2016-08-09'),(123,177,112,'2016-08-09'),(124,151,15,'2016-08-07'),(125,33,123,'2016-08-10'),(126,52,111,'2016-08-05'),(127,56,5,'2016-08-09'),(128,127,22,'2016-08-08'),(129,167,196,'2016-08-08'),(130,65,90,'2016-08-09'),(131,14,138,'2016-08-08'),(132,22,59,'2016-08-09'),(133,69,101,'2016-08-06'),(134,73,101,'2016-08-05'),(135,190,141,'2016-08-11'),(136,136,186,'2016-08-08'),(137,184,28,'2016-08-10'),(138,72,147,'2016-08-09'),(139,153,49,'2016-08-06'),(140,50,69,'2016-08-05'),(141,88,174,'2016-08-11'),(142,107,89,'2016-08-09'),(143,45,64,'2016-08-09'),(144,74,151,'2016-08-06'),(145,122,109,'2016-08-09'),(146,184,187,'2016-08-10'),(147,140,180,'2016-08-07'),(148,97,129,'2016-08-11'),(149,100,7,'2016-08-08'),(150,156,148,'2016-08-08'),(151,10,181,'2016-08-05'),(152,86,73,'2016-08-06'),(153,95,128,'2016-08-11'),(154,59,197,'2016-08-08'),(155,6,191,'2016-08-07'),(156,74,58,'2016-08-11'),(157,61,46,'2016-08-10'),(158,173,57,'2016-08-08'),(159,121,54,'2016-08-09'),(160,125,142,'2016-08-05'),(161,158,2,'2016-08-11'),(162,165,39,'2016-08-07'),(163,45,180,'2016-08-10'),(164,90,81,'2016-08-07'),(165,51,3,'2016-08-11'),(166,3,40,'2016-08-11'),(167,97,33,'2016-08-09'),(168,87,16,'2016-08-09'),(169,87,144,'2016-08-10'),(170,48,9,'2016-08-07'),(171,94,123,'2016-08-06'),(172,29,124,'2016-08-10'),(173,149,75,'2016-08-09'),(174,28,184,'2016-08-07'),(175,101,173,'2016-08-08'),(176,48,183,'2016-08-07'),(177,37,147,'2016-08-06'),(178,55,109,'2016-08-05'),(179,178,25,'2016-08-05'),(180,150,99,'2016-08-08'),(181,163,54,'2016-08-07'),(182,97,102,'2016-08-07'),(183,33,121,'2016-08-11'),(184,169,162,'2016-08-08'),(185,6,137,'2016-08-08'),(186,84,31,'2016-08-11'),(187,175,187,'2016-08-05'),(188,58,76,'2016-08-07'),(189,155,45,'2016-08-11'),(190,165,95,'2016-08-07'),(191,66,70,'2016-08-09'),(192,13,174,'2016-08-09'),(193,6,166,'2016-08-07'),(194,87,64,'2016-08-11'),(195,123,8,'2016-08-09'),(196,109,72,'2016-08-07'),(197,43,73,'2016-08-06'),(198,61,108,'2016-08-10'),(199,149,27,'2016-08-08'),(200,181,65,'2016-08-09');
/*!40000 ALTER TABLE `favorites` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products`
--
DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
`prodID` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(45) NOT NULL,
`variety` varchar(45) NOT NULL,
`price` double NOT NULL,
`releaseDate` date NOT NULL,
`updateDate` date NOT NULL,
`sellerID` int(11) NOT NULL,
`farmID` int(11) NOT NULL,
PRIMARY KEY (`prodID`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products`
--
LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'Liberica','roasted',284.73,'2016-08-03','2016-08-10',1,1),(2,'Robusta','dried',310.94,'2016-08-04','2016-08-10',77,2),(3,'Arabica','roasted',627.67,'2016-08-04','2016-08-11',4,3),(4,'Robusta','dried',663.2,'2016-08-03','2016-08-06',52,4),(5,'Robusta','dried',353.81,'2016-08-04','2016-08-11',25,5),(6,'Arabica','fresh',443.59,'2016-08-03','2016-08-06',35,6),(7,'Robusta','roasted',479.12,'2016-08-04','2016-08-08',75,7),(8,'Robusta','roasted',583.15,'2016-08-04','2016-08-08',14,8),(9,'Arabica','roasted',534.39,'2016-08-04','2016-08-06',44,9),(10,'Robusta','roasted',703.39,'2016-08-03','2016-08-11',169,10),(11,'Arabica','fresh',55.75,'2016-08-03','2016-08-11',37,11),(12,'Arabica','dried',123.23,'2016-08-04','2016-08-08',42,12),(13,'Arabica','dried',640.62,'2016-08-03','2016-08-08',16,13),(14,'Liberica','fresh',646.15,'2016-08-03','2016-08-09',59,14),(15,'Robusta','roasted',228.01,'2016-08-04','2016-08-08',18,15),(16,'Arabica','dried',253.82,'2016-08-03','2016-08-08',12,16),(17,'Arabica','roasted',254.61,'2016-08-04','2016-08-09',17,17),(18,'Arabica','roasted',328.42,'2016-08-04','2016-08-11',3,18),(19,'Robusta','roasted',702.88,'2016-08-03','2016-08-09',60,19),(20,'Arabica','dried',259.44,'2016-08-03','2016-08-11',29,20),(21,'Arabica','fresh',666.47,'2016-08-04','2016-08-09',154,21),(22,'Robusta','roasted',670.85,'2016-08-03','2016-08-07',24,22),(23,'Liberica','dried',471.73,'2016-08-03','2016-08-07',57,23),(24,'Liberica','roasted',403.36,'2016-08-04','2016-08-08',19,24),(25,'Arabica','roasted',434.26,'2016-08-03','2016-08-10',7,25),(26,'Liberica','dried',696.48,'2016-08-03','2016-08-07',41,26),(27,'Arabica','roasted',329.22,'2016-08-03','2016-08-07',81,27),(28,'Robusta','roasted',131.32,'2016-08-03','2016-08-10',94,28),(29,'Liberica','dried',687.05,'2016-08-04','2016-08-11',86,29),(30,'Arabica','roasted',88.74,'2016-08-04','2016-08-09',96,30),(31,'Arabica','roasted',311.76,'2016-08-03','2016-08-09',1,1),(32,'Robusta','roasted',67.65,'2016-08-04','2016-08-08',77,2),(33,'Robusta','roasted',491.25,'2016-08-04','2016-08-06',4,3),(34,'Robusta','dried',106.29,'2016-08-04','2016-08-07',52,4),(35,'Robusta','roasted',490.47,'2016-08-04','2016-08-08',25,5),(36,'Arabica','dried',444.56,'2016-08-03','2016-08-08',35,6),(37,'Liberica','roasted',288.34,'2016-08-03','2016-08-11',75,7),(38,'Liberica','roasted',689.06,'2016-08-04','2016-08-08',14,8),(39,'Robusta','dried',74.39,'2016-08-03','2016-08-10',44,9),(40,'Robusta','roasted',316.89,'2016-08-04','2016-08-10',169,10),(41,'Robusta','roasted',606.18,'2016-08-03','2016-08-06',37,11),(42,'Liberica','roasted',404.94,'2016-08-04','2016-08-06',42,12),(43,'Robusta','roasted',497.96,'2016-08-03','2016-08-09',16,13),(44,'Liberica','roasted',136.94,'2016-08-03','2016-08-09',59,14),(45,'Arabica','fresh',90.17,'2016-08-04','2016-08-10',18,15),(46,'Liberica','roasted',64.71,'2016-08-03','2016-08-09',12,16),(47,'Robusta','fresh',88.05,'2016-08-03','2016-08-10',17,17),(48,'Liberica','dried',286.58,'2016-08-03','2016-08-07',3,18),(49,'Robusta','fresh',639.9,'2016-08-03','2016-08-10',60,19),(50,'Arabica','roasted',495.67,'2016-08-03','2016-08-07',29,20),(51,'Robusta','roasted',577.22,'2016-08-03','2016-08-11',154,21),(52,'Robusta','roasted',635.28,'2016-08-03','2016-08-11',24,22),(53,'Robusta','dried',110.68,'2016-08-03','2016-08-07',57,23),(54,'Robusta','dried',325.63,'2016-08-04','2016-08-06',19,24),(55,'Robusta','fresh',261.78,'2016-08-04','2016-08-10',7,25),(56,'Robusta','roasted',585.6,'2016-08-04','2016-08-10',41,26),(57,'Robusta','dried',356.41,'2016-08-04','2016-08-07',81,27),(58,'Liberica','fresh',590.71,'2016-08-03','2016-08-08',94,28),(59,'Liberica','roasted',170.88,'2016-08-03','2016-08-08',86,29),(60,'Arabica','roasted',441.46,'2016-08-03','2016-08-08',96,30),(61,'Robusta','dried',355.27,'2016-08-03','2016-08-10',1,1),(62,'Robusta','roasted',467.21,'2016-08-04','2016-08-11',77,2),(63,'Arabica','roasted',300.85,'2016-08-03','2016-08-07',4,3),(64,'Liberica','roasted',685.47,'2016-08-04','2016-08-11',52,4),(65,'Robusta','roasted',393.03,'2016-08-03','2016-08-06',25,5),(66,'Robusta','fresh',535.34,'2016-08-03','2016-08-10',35,6),(67,'Robusta','fresh',677.96,'2016-08-04','2016-08-10',75,7),(68,'Arabica','roasted',215.47,'2016-08-03','2016-08-07',14,8),(69,'Arabica','roasted',242.79,'2016-08-04','2016-08-06',44,9),(70,'Arabica','dried',740.67,'2016-08-03','2016-08-08',169,10),(71,'Robusta','dried',234.06,'2016-08-04','2016-08-07',37,11),(72,'Robusta','fresh',59.28,'2016-08-04','2016-08-07',42,12),(73,'Robusta','roasted',483.36,'2016-08-04','2016-08-10',16,13),(74,'Liberica','fresh',738.85,'2016-08-04','2016-08-10',59,14),(75,'Robusta','roasted',324.66,'2016-08-03','2016-08-11',18,15),(76,'Robusta','fresh',454.58,'2016-08-04','2016-08-11',12,16),(77,'Robusta','roasted',487.16,'2016-08-04','2016-08-09',17,17),(78,'Robusta','roasted',454.6,'2016-08-04','2016-08-08',3,18),(79,'Liberica','roasted',59.21,'2016-08-03','2016-08-08',60,19),(80,'Robusta','roasted',310.83,'2016-08-04','2016-08-08',29,20),(81,'Robusta','fresh',531.99,'2016-08-03','2016-08-09',154,21),(82,'Liberica','roasted',430.33,'2016-08-04','2016-08-11',24,22),(83,'Liberica','roasted',516.11,'2016-08-03','2016-08-07',57,23),(84,'Robusta','dried',63.91,'2016-08-03','2016-08-06',19,24),(85,'Liberica','roasted',457.45,'2016-08-03','2016-08-09',7,25),(86,'Robusta','dried',453.68,'2016-08-03','2016-08-06',41,26),(87,'Robusta','dried',174.56,'2016-08-04','2016-08-06',81,27),(88,'Liberica','dried',233.88,'2016-08-03','2016-08-06',94,28),(89,'Liberica','fresh',534.59,'2016-08-04','2016-08-10',86,29),(90,'Arabica','dried',62.77,'2016-08-04','2016-08-06',96,30),(91,'Liberica','fresh',264.55,'2016-08-04','2016-08-06',1,1),(92,'Robusta','dried',168.37,'2016-08-03','2016-08-06',77,2),(93,'Liberica','fresh',137.78,'2016-08-04','2016-08-11',4,3),(94,'Robusta','roasted',236.99,'2016-08-03','2016-08-07',52,4),(95,'Robusta','roasted',309.44,'2016-08-03','2016-08-11',25,5),(96,'Robusta','roasted',583.1,'2016-08-03','2016-08-11',35,6),(97,'Robusta','fresh',259.7,'2016-08-04','2016-08-08',75,7),(98,'Liberica','dried',674.3,'2016-08-04','2016-08-06',14,8),(99,'Liberica','roasted',446.76,'2016-08-04','2016-08-09',44,9),(100,'Arabica','fresh',109.4,'2016-08-03','2016-08-06',169,10),(101,'Robusta','roasted',496.32,'2016-08-04','2016-08-09',37,11),(102,'Robusta','roasted',322.89,'2016-08-04','2016-08-07',42,12),(103,'Liberica','fresh',692.73,'2016-08-04','2016-08-07',16,13),(104,'Robusta','roasted',463.8,'2016-08-03','2016-08-06',59,14),(105,'Robusta','roasted',432.03,'2016-08-04','2016-08-10',18,15),(106,'Arabica','dried',183.12,'2016-08-04','2016-08-08',12,16),(107,'Robusta','roasted',721.99,'2016-08-03','2016-08-07',17,17),(108,'Robusta','dried',515.42,'2016-08-04','2016-08-08',3,18),(109,'Liberica','roasted',420.9,'2016-08-03','2016-08-11',60,19),(110,'Liberica','roasted',229.29,'2016-08-03','2016-08-06',29,20),(111,'Arabica','fresh',401.5,'2016-08-04','2016-08-08',154,21),(112,'Liberica','fresh',343.06,'2016-08-03','2016-08-07',24,22),(113,'Robusta','dried',295.82,'2016-08-03','2016-08-10',57,23),(114,'Robusta','fresh',64.02,'2016-08-04','2016-08-08',19,24),(115,'Robusta','fresh',471.02,'2016-08-04','2016-08-06',7,25),(116,'Robusta','roasted',93.27,'2016-08-04','2016-08-10',41,26),(117,'Robusta','roasted',80.72,'2016-08-04','2016-08-07',81,27),(118,'Robusta','roasted',370.52,'2016-08-03','2016-08-08',94,28),(119,'Robusta','dried',54.53,'2016-08-04','2016-08-11',86,29),(120,'Arabica','fresh',207.71,'2016-08-03','2016-08-08',96,30),(121,'Robusta','roasted',560.8,'2016-08-04','2016-08-08',1,1),(122,'Arabica','roasted',241.43,'2016-08-03','2016-08-06',77,2),(123,'Robusta','dried',347.21,'2016-08-04','2016-08-08',4,3),(124,'Robusta','fresh',350.28,'2016-08-03','2016-08-09',52,4),(125,'Liberica','roasted',109.69,'2016-08-03','2016-08-11',25,5),(126,'Arabica','roasted',126.43,'2016-08-04','2016-08-11',35,6),(127,'Robusta','roasted',688.04,'2016-08-04','2016-08-11',75,7),(128,'Arabica','fresh',228.26,'2016-08-03','2016-08-08',14,8),(129,'Liberica','roasted',189.92,'2016-08-03','2016-08-07',44,9),(130,'Robusta','dried',125.14,'2016-08-03','2016-08-07',169,10),(131,'Robusta','roasted',155.86,'2016-08-04','2016-08-09',37,11),(132,'Robusta','roasted',717.94,'2016-08-04','2016-08-11',42,12),(133,'Robusta','dried',220.29,'2016-08-04','2016-08-09',16,13),(134,'Arabica','roasted',452.82,'2016-08-04','2016-08-09',59,14),(135,'Liberica','roasted',267.28,'2016-08-03','2016-08-11',18,15),(136,'Robusta','roasted',378.74,'2016-08-03','2016-08-08',12,16),(137,'Liberica','dried',442.78,'2016-08-03','2016-08-08',17,17),(138,'Robusta','fresh',303.04,'2016-08-04','2016-08-08',3,18),(139,'Robusta','roasted',680.35,'2016-08-03','2016-08-08',60,19),(140,'Robusta','roasted',50.21,'2016-08-03','2016-08-10',29,20),(141,'Robusta','dried',636.9,'2016-08-03','2016-08-06',154,21),(142,'Arabica','dried',730.18,'2016-08-04','2016-08-10',24,22),(143,'Arabica','roasted',280.07,'2016-08-04','2016-08-06',57,23),(144,'Robusta','dried',305.43,'2016-08-04','2016-08-08',19,24),(145,'Robusta','roasted',499.09,'2016-08-03','2016-08-10',7,25),(146,'Robusta','fresh',508.07,'2016-08-03','2016-08-09',41,26),(147,'Liberica','roasted',351.34,'2016-08-04','2016-08-11',81,27),(148,'Arabica','roasted',694.46,'2016-08-04','2016-08-09',94,28),(149,'Robusta','roasted',749.94,'2016-08-04','2016-08-08',86,29),(150,'Arabica','fresh',450.28,'2016-08-04','2016-08-07',96,30),(151,'Robusta','roasted',166.93,'2016-08-04','2016-08-09',1,1),(152,'Arabica','fresh',244.82,'2016-08-04','2016-08-08',77,2),(153,'Robusta','dried',606.77,'2016-08-04','2016-08-09',4,3),(154,'Robusta','dried',91.1,'2016-08-03','2016-08-08',52,4),(155,'Robusta','roasted',401.08,'2016-08-04','2016-08-09',25,5),(156,'Robusta','fresh',244.12,'2016-08-04','2016-08-10',35,6),(157,'Arabica','fresh',97.19,'2016-08-04','2016-08-10',75,7),(158,'Liberica','roasted',171.55,'2016-08-04','2016-08-10',14,8),(159,'Robusta','fresh',238.3,'2016-08-04','2016-08-06',44,9),(160,'Robusta','roasted',348.8,'2016-08-04','2016-08-07',169,10),(161,'Robusta','dried',169.56,'2016-08-04','2016-08-08',37,11),(162,'Liberica','roasted',180.19,'2016-08-03','2016-08-10',42,12),(163,'Arabica','dried',736.47,'2016-08-03','2016-08-08',16,13),(164,'Robusta','fresh',735.31,'2016-08-03','2016-08-10',59,14),(165,'Arabica','dried',533.43,'2016-08-04','2016-08-06',18,15),(166,'Robusta','dried',341.6,'2016-08-03','2016-08-11',12,16),(167,'Robusta','roasted',610.64,'2016-08-04','2016-08-06',17,17),(168,'Robusta','roasted',265.12,'2016-08-04','2016-08-11',3,18),(169,'Robusta','roasted',525.29,'2016-08-04','2016-08-10',60,19),(170,'Liberica','roasted',726.05,'2016-08-03','2016-08-07',29,20),(171,'Arabica','roasted',103.53,'2016-08-03','2016-08-11',154,21),(172,'Liberica','dried',537.54,'2016-08-04','2016-08-07',24,22),(173,'Liberica','fresh',85.42,'2016-08-03','2016-08-11',57,23),(174,'Robusta','roasted',273.57,'2016-08-04','2016-08-10',19,24),(175,'Robusta','fresh',143.38,'2016-08-03','2016-08-11',7,25),(176,'Liberica','dried',747.66,'2016-08-03','2016-08-09',41,26),(177,'Arabica','dried',164.29,'2016-08-03','2016-08-06',81,27),(178,'Liberica','roasted',596.55,'2016-08-04','2016-08-09',94,28),(179,'Liberica','roasted',430.91,'2016-08-03','2016-08-06',86,29),(180,'Robusta','fresh',365.99,'2016-08-04','2016-08-09',96,30),(181,'Arabica','dried',517.77,'2016-08-04','2016-08-11',1,1),(182,'Robusta','roasted',181.87,'2016-08-04','2016-08-07',77,2),(183,'Arabica','roasted',392.14,'2016-08-04','2016-08-10',4,3),(184,'Liberica','fresh',217.33,'2016-08-03','2016-08-07',52,4),(185,'Liberica','dried',397.49,'2016-08-04','2016-08-11',25,5),(186,'Liberica','roasted',647.59,'2016-08-04','2016-08-07',35,6),(187,'Robusta','roasted',173.42,'2016-08-03','2016-08-06',75,7),(188,'Liberica','dried',291.98,'2016-08-03','2016-08-08',14,8),(189,'Robusta','dried',161.06,'2016-08-03','2016-08-11',44,9),(190,'Arabica','roasted',261.6,'2016-08-03','2016-08-07',169,10),(191,'Liberica','roasted',649.03,'2016-08-03','2016-08-06',37,11),(192,'Liberica','fresh',446.45,'2016-08-04','2016-08-09',42,12),(193,'Liberica','roasted',411.89,'2016-08-04','2016-08-08',16,13),(194,'Robusta','fresh',728.08,'2016-08-04','2016-08-11',59,14),(195,'Liberica','dried',266.4,'2016-08-03','2016-08-10',18,15),(196,'Arabica','roasted',617.57,'2016-08-04','2016-08-08',12,16),(197,'Liberica','fresh',521.69,'2016-08-03','2016-08-06',17,17),(198,'Robusta','dried',264.68,'2016-08-03','2016-08-10',3,18),(199,'Liberica','roasted',597.7,'2016-08-04','2016-08-08',60,19),(200,'Liberica','dried',711.31,'2016-08-03','2016-08-09',29,20);
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ratings`
--
DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ratings` (
`rateID` int(11) NOT NULL AUTO_INCREMENT,
`rate` int(11) NOT NULL,
`feedback` varchar(100) DEFAULT NULL,
`prodID` int(11) NOT NULL,
`raterID` int(11) NOT NULL,
PRIMARY KEY (`rateID`),
UNIQUE KEY `rateID_UNIQUE` (`rateID`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ratings`
--
LOCK TABLES `ratings` WRITE;
/*!40000 ALTER TABLE `ratings` DISABLE KEYS */;
INSERT INTO `ratings` VALUES (1,2,'Curabitur at ipsum ac tellus semper interdum. Mauris ullamcorper purus sit amet nulla.',69,145),(2,4,'Praesent blandit.',1,173),(3,4,NULL,168,25),(4,2,NULL,113,142),(5,5,'In hac habitasse platea dictumst.',111,77),(6,3,'Nunc purus. Phasellus in felis.',37,122),(7,3,NULL,168,134),(8,5,'Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tin',46,84),(9,1,NULL,45,50),(10,4,'In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula ne',124,108),(11,1,'Donec semper sapien a libero. Nam dui.',3,30),(12,4,'Proin risus.',162,159),(13,3,NULL,141,62),(14,4,'Integer tincidunt ante vel ipsum.',18,42),(15,1,NULL,151,63),(16,1,NULL,157,139),(17,1,'Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla.',172,160),(18,3,'Proin eu mi. Nulla ac enim.',111,78),(19,4,NULL,114,53),(20,1,'Maecenas pulvinar lobortis est.',186,12),(21,3,NULL,32,10),(22,2,'Mauris sit amet eros. Suspendisse accumsan tortor quis turpis.',65,133),(23,2,'Integer ac neque. Duis bibendum.',18,158),(24,2,'Quisque porta volutpat erat.',187,49),(25,1,'Donec ut mauris eget massa tempor convallis.',67,130),(26,5,'Mauris lacinia sapien quis libero. Nullam sit amet turpis elementum ligula vehicula consequat.',159,163),(27,3,'Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus.',11,155),(28,3,NULL,135,50),(29,1,'Morbi vel lectus in quam fringilla rhoncus. Mauris enim leo, rhoncus sed, vestibulum sit amet, cursu',64,1),(30,3,NULL,50,110),(31,4,NULL,110,54),(32,4,'Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis.',176,196),(33,3,'Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.',85,133),(34,5,'Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue',136,66),(35,3,NULL,87,7),(36,4,'Sed ante. Vivamus tortor.',112,85),(37,4,'In est risus, auctor sed, tristique in, tempus sit amet, sem. Fusce consequat.',131,145),(38,1,NULL,152,145),(39,3,'Nam dui.',32,25),(40,5,'Nunc purus.',78,47),(41,2,'Aenean sit amet justo. Morbi ut odio.',138,132),(42,1,NULL,31,30),(43,5,'Nulla ac enim.',136,199),(44,5,'Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue.',105,123),(45,5,NULL,162,156),(46,5,'Vestibulum quam sapien, varius ut, blandit non, interdum in, ante.',158,105),(47,3,'In hac habitasse platea dictumst. Maecenas ut massa quis augue luctus tincidunt.',164,182),(48,2,'Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla.',182,167),(49,5,'Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tin',182,157),(50,2,'Vivamus in felis eu sapien cursus vestibulum.',61,164),(51,2,NULL,108,14),(52,1,'Vivamus tortor. Duis mattis egestas metus.',199,86),(53,2,'In sagittis dui vel nisl. Duis ac nibh.',129,92),(54,3,'Nulla ut erat id mauris vulputate elementum. Nullam varius.',55,106),(55,5,'Vestibulum quam sapien, varius ut, blandit non, interdum in, ante. Vestibulum ante ipsum primis in f',62,186),(56,5,'Maecenas rhoncus aliquam lacus. Morbi quis tortor id nulla ultrices aliquet.',85,98),(57,1,NULL,98,37),(58,3,NULL,31,121),(59,5,'Morbi non lectus.',158,138),(60,1,NULL,58,21),(61,4,'In eleifend quam a odio. In hac habitasse platea dictumst.',31,56),(62,1,'Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc',120,18),(63,4,'Mauris sit amet eros. Suspendisse accumsan tortor quis turpis.',100,81),(64,1,'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin risus.',108,51),(65,5,'Nunc nisl.',79,11),(66,5,'Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui.',53,39),(67,5,'Nulla tempus.',199,174),(68,3,'Etiam justo. Etiam pretium iaculis justo.',176,102),(69,1,'Fusce lacus purus, aliquet at, feugiat non, pretium quis, lectus.',6,124),(70,5,'Vestibulum ac est lacinia nisi venenatis tristique.',16,36),(71,5,'Vestibulum sed magna at nunc commodo placerat.',86,1),(72,2,NULL,67,75),(73,3,NULL,83,162),(74,3,'Pellentesque eget nunc.',76,97),(75,5,'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.',2,178),(76,4,'Curabitur in libero ut massa volutpat convallis.',70,80),(77,3,'Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.',53,184),(78,1,'Aenean lectus.',52,28),(79,4,NULL,25,189),(80,2,'Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.',178,51),(81,2,NULL,38,150),(82,4,'Nam tristique tortor eu pede.',151,4),(83,1,'Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue.',46,113),(84,3,'Donec semper sapien a libero. Nam dui.',87,171),(85,2,'Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy.',85,147),(86,2,'Vestibulum ac est lacinia nisi venenatis tristique. Fusce congue, diam id ornare imperdiet, sapien u',167,28),(87,3,NULL,155,159),(88,1,'Mauris lacinia sapien quis libero. Nullam sit amet turpis elementum ligula vehicula consequat.',9,12),(89,1,'Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis. Integer aliquet, massa id lobo',131,91),(90,4,'Aliquam sit amet diam in magna bibendum imperdiet.',45,21),(91,5,'Nam dui.',158,109),(92,3,NULL,70,79),(93,2,NULL,186,153),(94,2,'Etiam faucibus cursus urna. Ut tellus.',159,162),(95,3,NULL,199,29),(96,3,NULL,133,166),(97,5,'Praesent blandit. Nam nulla.',113,95),(98,2,NULL,55,31),(99,2,NULL,161,104),(100,2,'Curabitur gravida nisi at nibh.',13,59),(101,2,'In hac habitasse platea dictumst.',122,69),(102,4,'Nulla suscipit ligula in lacus.',131,11),(103,4,NULL,108,55),(104,5,'In congue.',9,46),(105,4,'Proin at turpis a pede posuere nonummy.',86,31),(106,1,'Morbi ut odio. Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo.',189,148),(107,5,'Nulla justo.',70,80),(108,2,NULL,178,45),(109,1,NULL,52,31),(110,3,NULL,47,178),(111,5,NULL,166,39),(112,4,'Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis',29,180),(113,1,NULL,196,161),(114,4,NULL,156,95),(115,2,'Vestibulum ac est lacinia nisi venenatis tristique.',196,151),(116,4,'Mauris lacinia sapien quis libero.',192,144),(117,3,'Aenean lectus. Pellentesque eget nunc.',135,22),(118,1,'Proin at turpis a pede posuere nonummy. Integer non velit.',112,57),(119,1,'Nunc nisl.',178,120),(120,3,NULL,50,40),(121,5,'Cras non velit nec nisi vulputate nonummy.',56,11),(122,4,'Donec ut mauris eget massa tempor convallis. Nulla neque libero, convallis eget, eleifend luctus, ul',91,189),(123,1,'Morbi a ipsum. Integer a nibh.',117,88),(124,3,NULL,143,185),(125,3,NULL,80,11),(126,5,'Integer ac neque.',182,137),(127,4,'Ut at dolor quis odio consequat varius. Integer ac leo.',69,158),(128,1,'Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros. Vestibulum ac est lacinia nisi vene',148,70),(129,1,'Pellentesque at nulla.',29,77),(130,1,'Quisque arcu libero, rutrum ac, lobortis vel, dapibus at, diam. Nam tristique tortor eu pede.',37,114),(131,1,'Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla.',2,18),(132,3,'Vestibulum ac est lacinia nisi venenatis tristique.',163,8),(133,1,NULL,33,20),(134,4,'Praesent lectus. Vestibulum quam sapien, varius ut, blandit non, interdum in, ante.',59,61),(135,5,NULL,90,68),(136,2,NULL,12,123),(137,1,NULL,184,56),(138,2,'Curabitur at ipsum ac tellus semper interdum. Mauris ullamcorper purus sit amet nulla.',39,72),(139,4,NULL,127,42),(140,4,NULL,11,120),(141,1,'Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede. Morbi porttitor lorem id ligula.',15,58),(142,4,'Vivamus vel nulla eget eros elementum pellentesque. Quisque porta volutpat erat.',196,19),(143,5,NULL,126,89),(144,1,'In hac habitasse platea dictumst.',139,19),(145,1,'Integer ac neque.',104,22),(146,2,NULL,62,58),(147,3,'Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo. In blandit ultrices enim.',91,32),(148,4,'Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue.',93,88),(149,3,'Morbi ut odio. Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo.',29,188),(150,3,'Duis mattis egestas metus. Aenean fermentum.',200,96),(151,1,NULL,46,10),(152,3,NULL,111,74),(153,5,'Etiam justo. Etiam pretium iaculis justo.',43,22),(154,3,NULL,28,200),(155,5,'Cras non velit nec nisi vulputate nonummy.',83,20),(156,4,'Proin at turpis a pede posuere nonummy. Integer non velit.',196,199),(157,4,NULL,93,34),(158,5,'Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestib',181,10),(159,4,'In sagittis dui vel nisl.',6,20),(160,4,'Nam nulla. Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.',159,189),(161,2,NULL,192,19),(162,4,'Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem.',64,128),(163,3,'Donec dapibus.',75,116),(164,4,'Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis.',50,109),(165,5,'Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue',126,26),(166,5,NULL,52,45),(167,4,'Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui.',148,55),(168,3,'In eleifend quam a odio. In hac habitasse platea dictumst.',10,54),(169,5,NULL,93,170),(170,3,'Donec quis orci eget orci vehicula condimentum.',79,92),(171,4,NULL,30,69),(172,5,NULL,20,5),(173,2,'Sed vel enim sit amet nunc viverra dapibus. Nulla suscipit ligula in lacus.',41,30),(174,3,'Aenean sit amet justo.',1,53),(175,2,'Pellentesque ultrices mattis odio.',166,118),(176,1,'Vivamus vestibulum sagittis sapien.',196,123),(177,4,'Aenean auctor gravida sem. Praesent id massa id nisl venenatis lacinia.',24,149),(178,3,'Quisque ut erat.',164,54),(179,4,'Nullam molestie nibh in lectus.',127,57),(180,5,NULL,86,171),(181,1,'Maecenas pulvinar lobortis est.',57,31),(182,3,'Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.',97,70),(183,4,'Vivamus vestibulum sagittis sapien.',184,42),(184,3,NULL,104,182),(185,2,NULL,189,137),(186,5,'Donec dapibus. Duis at velit eu est congue elementum.',66,129),(187,4,NULL,198,171),(188,1,NULL,74,99),(189,4,'Aliquam sit amet diam in magna bibendum imperdiet.',21,8),(190,2,NULL,97,98),(191,4,'Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue.',22,8),(192,2,'Nullam varius.',75,121),(193,4,'Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac dia',109,26),(194,5,NULL,187,173),(195,1,NULL,128,149),(196,2,NULL,18,24),(197,5,NULL,108,177),(198,5,'Proin risus. Praesent lectus.',64,185),(199,2,NULL,109,147),(200,4,NULL,169,195);
/*!40000 ALTER TABLE `ratings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `transactions`
--
DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
`transactID` int(11) NOT NULL AUTO_INCREMENT,
`sellerID` int(11) NOT NULL,
`buyerID` int(11) NOT NULL,
`totalQuantity` int(11) NOT NULL,
`transactDate` datetime NOT NULL,
`prodID` int(11) NOT NULL,
PRIMARY KEY (`transactID`),
UNIQUE KEY `transactID_UNIQUE` (`transactID`)
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `transactions`
--
LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` VALUES (1,13,110,44,'2016-08-11 20:05:29',59),(2,15,188,11,'2016-08-11 14:50:45',155),(3,24,75,37,'2016-08-06 18:02:40',195),(4,18,125,13,'2016-08-11 13:53:26',167),(5,26,167,14,'2016-08-11 09:20:03',102),(6,21,13,7,'2016-08-06 04:28:04',46),(7,1,72,16,'2016-08-07 12:54:31',49),(8,23,35,18,'2016-08-11 15:44:51',45),(9,27,157,36,'2016-08-10 12:48:55',35),(10,28,4,25,'2016-08-09 03:49:59',37),(11,8,162,31,'2016-08-11 17:04:25',20),(12,17,5,46,'2016-08-11 14:21:14',112),(13,11,103,6,'2016-08-11 23:39:39',114),(14,22,82,1,'2016-08-09 12:42:35',108),(15,16,140,21,'2016-08-09 16:09:31',175),(16,27,4,45,'2016-08-09 07:36:19',143),(17,12,185,49,'2016-08-06 09:40:25',94),(18,16,174,25,'2016-08-06 17:50:15',175),(19,24,186,1,'2016-08-08 02:55:11',37),(20,28,66,16,'2016-08-11 11:22:52',159),(21,3,198,36,'2016-08-11 01:41:31',190),(22,28,6,20,'2016-08-07 00:10:19',93),(23,13,72,36,'2016-08-08 11:13:50',179),(24,12,150,40,'2016-08-09 21:39:11',130),(25,1,111,9,'2016-08-06 21:01:40',165),(26,5,125,23,'2016-08-11 18:02:46',195),(27,25,187,13,'2016-08-10 06:59:48',12),(28,2,65,5,'2016-08-08 03:54:20',185),(29,4,129,17,'2016-08-08 00:49:55',28),(30,11,114,28,'2016-08-09 15:45:31',107),(31,9,47,17,'2016-08-06 23:10:40',182),(32,21,29,28,'2016-08-06 07:44:21',71),(33,8,16,49,'2016-08-08 00:36:43',57),(34,29,199,20,'2016-08-06 09:45:32',82),(35,2,27,4,'2016-08-06 06:19:27',159),(36,20,126,14,'2016-08-07 11:25:26',113),(37,5,63,6,'2016-08-08 09:20:43',39),(38,27,11,31,'2016-08-06 17:57:46',200),(39,16,69,31,'2016-08-06 03:13:06',134),(40,8,145,6,'2016-08-07 16:14:07',156),(41,29,124,33,'2016-08-09 00:53:34',183),(42,29,18,50,'2016-08-07 23:35:10',110),(43,13,30,22,'2016-08-11 07:14:34',106),(44,8,145,20,'2016-08-06 06:45:42',54),(45,22,187,3,'2016-08-09 05:18:35',64),(46,10,150,11,'2016-08-10 16:24:14',22),(47,1,186,15,'2016-08-06 01:53:58',74),(48,30,81,20,'2016-08-07 02:11:51',153),(49,1,111,42,'2016-08-10 01:51:14',117),(50,25,45,29,'2016-08-06 08:14:57',26),(51,21,171,12,'2016-08-08 05:17:56',159),(52,19,24,23,'2016-08-07 16:40:43',130),(53,22,140,12,'2016-08-11 21:52:03',135),(54,24,128,4,'2016-08-10 01:14:31',138),(55,20,81,28,'2016-08-10 11:05:47',67),(56,26,32,8,'2016-08-09 04:32:04',137),(57,7,126,31,'2016-08-09 16:11:39',4),(58,23,161,27,'2016-08-08 02:59:33',10),(59,26,179,12,'2016-08-06 11:23:01',198),(60,20,187,17,'2016-08-08 07:08:31',4),(61,23,84,35,'2016-08-09 21:30:59',18),(62,14,186,29,'2016-08-09 03:20:18',105),(63,14,184,41,'2016-08-10 06:49:23',30),(64,28,63,12,'2016-08-09 06:34:13',153),(65,29,188,20,'2016-08-08 23:01:37',139),(66,1,4,5,'2016-08-11 01:46:18',191),(67,21,70,21,'2016-08-10 00:09:09',171),(68,8,131,34,'2016-08-07 07:49:50',21),(69,18,20,1,'2016-08-11 02:42:29',147),(70,22,36,6,'2016-08-10 05:52:56',63),(71,14,177,43,'2016-08-10 01:34:47',40),(72,18,133,15,'2016-08-06 00:08:06',150),(73,21,47,11,'2016-08-09 02:07:32',24),(74,5,58,2,'2016-08-09 04:35:17',106),(75,28,55,3,'2016-08-09 01:23:27',43),(76,20,127,14,'2016-08-08 16:17:05',24),(77,1,153,18,'2016-08-09 14:24:18',164),(78,10,50,28,'2016-08-07 14:35:28',58),(79,30,52,9,'2016-08-06 08:09:24',111),(80,5,35,17,'2016-08-09 17:55:09',105),(81,3,123,25,'2016-08-09 02:47:53',32),(82,1,110,16,'2016-08-11 00:54:08',143),(83,16,74,14,'2016-08-11 19:41:15',38),(84,6,199,18,'2016-08-07 03:51:00',103),(85,1,44,18,'2016-08-09 03:51:12',141),(86,22,85,11,'2016-08-08 00:16:48',153),(87,4,157,40,'2016-08-08 13:43:58',156),(88,12,186,21,'2016-08-11 13:51:13',26),(89,6,81,33,'2016-08-07 03:08:55',31),(90,19,177,37,'2016-08-07 14:48:54',193),(91,6,182,43,'2016-08-11 19:21:09',37),(92,6,7,46,'2016-08-07 05:32:03',45),(93,28,15,31,'2016-08-06 01:21:26',105),(94,11,71,24,'2016-08-11 02:43:44',192),(95,21,46,20,'2016-08-09 10:49:50',192),(96,20,183,5,'2016-08-07 16:32:36',96),(97,1,170,18,'2016-08-06 00:00:15',167),(98,14,190,7,'2016-08-07 07:05:37',86),(99,22,81,47,'2016-08-06 22:53:48',58),(100,20,27,21,'2016-08-06 15:32:30',121),(101,7,57,14,'2016-08-06 05:11:21',54),(102,14,196,6,'2016-08-11 23:40:18',167),(103,1,171,27,'2016-08-08 21:32:41',178),(104,9,191,21,'2016-08-08 08:09:25',105),(105,14,64,8,'2016-08-08 14:38:53',39),(106,5,172,25,'2016-08-08 13:05:49',199),(107,23,1,34,'2016-08-10 07:22:20',144),(108,10,123,46,'2016-08-10 17:33:05',99),(109,17,174,20,'2016-08-07 23:48:28',114),(110,23,47,40,'2016-08-10 03:51:33',79),(111,26,25,19,'2016-08-06 01:26:41',155),(112,27,40,32,'2016-08-09 19:04:32',142),(113,11,47,42,'2016-08-08 08:08:10',194),(114,2,56,35,'2016-08-08 07:55:12',28),(115,13,41,15,'2016-08-09 12:53:47',27),(116,29,71,33,'2016-08-07 12:50:18',79),(117,17,9,40,'2016-08-08 22:32:17',198),(118,1,118,12,'2016-08-08 02:37:10',198),(119,9,41,42,'2016-08-10 11:31:57',149),(120,1,144,5,'2016-08-08 08:23:24',49),(121,1,3,4,'2016-08-09 00:43:37',31),(122,25,195,4,'2016-08-08 19:02:17',39),(123,8,6,42,'2016-08-06 01:19:22',112),(124,2,7,30,'2016-08-06 18:48:19',58),(125,29,49,49,'2016-08-07 11:56:28',45),(126,17,147,5,'2016-08-06 17:08:23',189),(127,27,131,35,'2016-08-09 03:05:18',192),(128,22,86,28,'2016-08-06 13:00:36',18),(129,1,61,34,'2016-08-08 00:26:28',14),(130,25,181,14,'2016-08-06 19:11:13',182),(131,2,193,49,'2016-08-08 14:39:53',3),(132,14,94,19,'2016-08-11 02:08:07',189),(133,25,94,34,'2016-08-09 12:10:47',151),(134,14,157,46,'2016-08-10 02:44:40',88),(135,6,71,21,'2016-08-06 12:53:26',75),(136,2,155,35,'2016-08-07 01:36:55',128),(137,21,175,26,'2016-08-08 04:59:43',5),(138,18,106,36,'2016-08-09 10:41:23',47),(139,7,88,37,'2016-08-11 23:33:41',140),(140,14,199,11,'2016-08-08 00:20:40',171),(141,14,73,15,'2016-08-11 11:55:21',40),(142,27,197,19,'2016-08-06 05:38:55',164),(143,19,86,50,'2016-08-09 02:02:48',18),(144,13,54,18,'2016-08-09 17:52:50',173),(145,15,77,21,'2016-08-09 04:53:54',33),(146,7,16,4,'2016-08-08 20:59:44',5),(147,25,196,5,'2016-08-10 21:09:05',99),(148,11,38,40,'2016-08-11 12:10:24',28),(149,6,64,22,'2016-08-07 18:00:46',104),(150,16,168,48,'2016-08-08 17:07:12',51),(151,10,46,21,'2016-08-10 22:42:31',92),(152,1,165,33,'2016-08-10 19:39:31',135),(153,26,161,29,'2016-08-11 20:35:27',119),(154,23,124,19,'2016-08-10 10:59:49',79),(155,4,6,25,'2016-08-11 13:59:49',120),(156,27,102,35,'2016-08-06 18:02:57',49),(157,27,137,40,'2016-08-10 07:01:17',101),(158,10,129,10,'2016-08-08 09:02:30',19),(159,19,146,8,'2016-08-06 19:32:30',36),(160,12,57,42,'2016-08-09 22:46:36',53),(161,9,114,35,'2016-08-08 06:59:56',162),(162,10,63,16,'2016-08-09 15:22:29',139),(163,6,175,38,'2016-08-09 05:41:44',180),(164,29,6,26,'2016-08-07 03:27:06',145),(165,28,54,13,'2016-08-10 02:39:15',148),(166,23,20,39,'2016-08-10 11:14:12',173),(167,14,178,5,'2016-08-07 01:36:42',42),(168,14,63,28,'2016-08-07 06:02:59',130),(169,13,145,8,'2016-08-09 23:21:41',103),(170,20,63,27,'2016-08-08 02:04:20',189),(171,16,184,45,'2016-08-10 15:21:16',179),(172,11,82,49,'2016-08-10 05:58:52',165),(173,14,168,39,'2016-08-11 19:33:43',187),(174,7,80,23,'2016-08-10 10:44:51',70),(175,26,195,46,'2016-08-09 23:16:23',59),(176,2,36,39,'2016-08-09 19:41:12',132),(177,13,200,50,'2016-08-11 02:33:53',118),(178,30,149,4,'2016-08-06 08:20:44',123),(179,3,54,30,'2016-08-09 19:37:57',18),(180,14,153,32,'2016-08-10 17:25:30',35),(181,2,97,14,'2016-08-09 12:36:57',199),(182,22,191,11,'2016-08-09 22:43:00',99),(183,2,109,42,'2016-08-06 21:28:38',37),(184,14,44,47,'2016-08-08 11:10:50',161),(185,5,91,7,'2016-08-10 18:55:34',175),(186,1,85,23,'2016-08-08 22:37:48',68),(187,12,65,4,'2016-08-11 02:45:16',163),(188,5,59,25,'2016-08-10 09:33:01',172),(189,6,154,8,'2016-08-10 00:51:10',95),(190,27,158,31,'2016-08-10 23:32:17',39),(191,4,28,19,'2016-08-06 03:28:19',83),(192,20,69,21,'2016-08-11 15:34:50',118),(193,3,21,7,'2016-08-10 08:31:50',52),(194,24,36,1,'2016-08-11 11:28:45',24),(195,27,94,22,'2016-08-06 10:33:33',148),(196,18,175,11,'2016-08-11 08:46:34',187),(197,29,161,41,'2016-08-07 19:49:08',49),(198,22,100,26,'2016-08-08 16:35:23',151),(199,14,176,45,'2016-08-07 01:21:37',59),(200,1,155,4,'2016-08-09 04:21:45',17);
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`firstName` varchar(45) NOT NULL,
`lastName` varchar(45) NOT NULL,
`birthDate` date DEFAULT NULL,
`regDate` date NOT NULL,
`lastLogin` datetime NOT NULL,
`mobileNum` varchar(11) NOT NULL,
`email` varchar(45) NOT NULL,
`address` varchar(60) NOT NULL,
`description` varchar(100) DEFAULT NULL,
`password` varchar(45) NOT NULL,
`farmID` int(11) DEFAULT NULL,
`status` enum('active','suspended','admin','inactive') NOT NULL DEFAULT 'active',
`sellStart` date DEFAULT NULL,
PRIMARY KEY (`userID`),
UNIQUE KEY `userID_UNIQUE` (`userID`),
UNIQUE KEY `farmID_UNIQUE` (`farmID`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Joe','Pakistan','1992-03-11','2016-08-02','2016-08-24 14:08:48','09027968949','[email protected]','46 Cardinal Plaza, San Juan',NULL,'joepakistan',1,'active','2016-08-03'),(2,'Merk','Sachi','1996-04-09','2016-08-01','2016-08-23 15:08:16','09278564314','[email protected]','82 Taft Avenue, Manila',NULL,'test123',NULL,'admin',NULL),(3,'Eugene','Willis','1991-02-15','2016-08-02','2016-04-07 17:54:08','09815377518','[email protected]','9 Logan Street',NULL,'Z8M96k98',18,'active','2016-08-04'),(4,'Evelyn','Moore','1985-11-06','2016-08-02','2016-08-20 11:08:01','09503543153','[email protected]','71 Arapahoe Park','Curabitur gravida nisi at nibh.','RiaCnlk',3,'active','2016-08-04'),(5,'Michelle','Warren','1994-09-08','2016-08-02','2016-02-16 12:56:29','09323304730','[email protected]','929 Westerfield Parkway',NULL,'IxllkSFG9O',NULL,'suspended',NULL),(6,'Barbara','Mcdonald','1980-09-14','2016-08-02','2016-03-31 20:18:14','09409800272','[email protected]','3 Portage Avenue','Morbi non quam nec dui luctus rutrum.','ZYognFhmHhf',NULL,'active',NULL),(7,'William','Wallace','1991-10-11','2016-08-02','2016-08-01 17:12:58','09025550014','[email protected]','28 Coleman Road','Nullam orci pede, venenatis non, sodales sed, tincidunt eu, felis.','p3dUqf8I',25,'active','2016-08-06'),(8,'Donald','Cook','1985-04-14','2016-08-02','2015-08-21 22:39:53','09365174521','[email protected]','717 Thompson Way','Proin interdum mauris non ligula pellentesque ultrices.','uxA9Q9bN9hg',NULL,'suspended',NULL),(9,'Wanda','Palmer','1995-10-16','2016-08-02','2015-11-10 08:06:33','09989831466','[email protected]','30212 Boyd Circle',NULL,'tfX0BbzJ',NULL,'active',NULL),(10,'Maria','Parker','1987-08-03','2016-08-02','2015-12-11 06:56:30','09372785534','[email protected]','4 Huxley Hill','Suspendisse potenti.','BySayvgY2',NULL,'suspended',NULL),(11,'Doris','Romero','1995-12-30','2016-08-02','2016-04-03 09:12:11','09714205297','[email protected]','930 Corben Point',NULL,'SoH9laFy41',NULL,'suspended',NULL),(12,'Justin','Berry','1997-09-17','2016-08-02','2015-12-19 09:33:42','09280804491','[email protected]','826 Moose Circle','Fusce posuere felis sed lacus.','nfPAo64FH',16,'active','2016-08-03'),(13,'Irene','Cook','1981-07-25','2016-08-02','2016-03-07 07:20:28','09825105243','[email protected]','0051 Stang Terrace','Sed vel enim sit amet nunc viverra dapibus.','OEG1hg0CnR',NULL,'suspended',NULL),(14,'Patricia','Stephens','1987-12-10','2016-08-02','2015-10-29 03:57:35','09565346554','[email protected]','42 Bartelt Place','Morbi a ipsum. Integer a nibh.','CgITFSta',8,'active','2016-08-04'),(15,'Marilyn','Kelley','1989-08-23','2016-08-02','2016-05-28 12:39:19','09080392410','[email protected]','871 Amoth Circle',NULL,'7T5nOX',NULL,'suspended',NULL),(16,'Lois','Garza','1993-03-03','2016-08-02','2015-10-22 23:59:34','09310225673','[email protected]','8 Hagan Avenue','Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo.','MuDbHMB1LtLC',13,'active','2016-08-04'),(17,'Joan','Alvarez','1991-12-06','2016-08-02','2015-08-15 16:18:22','09172471521','[email protected]','11 Cascade Parkway',NULL,'GVCoPutgeZ',17,'suspended','2016-08-02'),(18,'Sharon','Lawrence','1995-01-24','2016-08-02','2016-03-25 07:30:27','09578012560','[email protected]','166 Fair Oaks Plaza',NULL,'BsbAgi',15,'active','2016-08-03'),(19,'Theresa','Scott','1992-11-09','2016-08-02','2016-03-17 11:10:18','09358787055','[email protected]','49541 Ridge Oak Road','In quis justo.','o4zXI8KzQUi',24,'active','2016-08-04'),(20,'Edward','Rose','1985-12-11','2016-08-02','2016-08-10 08:33:13','09166694756','[email protected]','71 Michigan Hill',NULL,'vSwMKTd5MSm',NULL,'active',NULL),(21,'Alan','Martin','1994-08-25','2016-08-02','2016-02-10 20:18:45','09499775819','[email protected]','4065 1st Hill','Quisque porta volutpat erat.','yRgEZGHpCVP',NULL,'active',NULL),(22,'Brandon','Hill','1996-07-31','2016-08-02','2015-08-28 01:00:33','09283081899','[email protected]','4 Kropf Court',NULL,'ad4NxQ',NULL,'active',NULL),(23,'Deborah','Andrews','1980-03-28','2016-08-02','2016-02-26 05:45:28','09959136064','[email protected]','426 Straubel Lane',NULL,'DgEr5tDF8qS',NULL,'active',NULL),(24,'Janet','Gray','1989-10-06','2016-08-02','2015-09-02 15:22:47','09532247671','[email protected]','8 Acker Street',NULL,'NnFSOR',22,'active','2016-08-06'),(25,'Kelly','Richards','1995-08-17','2016-08-02','2016-08-11 05:36:06','09197072105','[email protected]','8 Warrior Parkway','Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo.','I9YO8LocCPK',5,'suspended','2016-08-02'),(26,'Lisa','Allen','1985-02-26','2016-08-02','2016-01-07 16:06:40','09693914799','[email protected]','78 Anthes Alley',NULL,'PQyiGylhYYQV',NULL,'suspended',NULL),(27,'Shirley','Bailey','1985-05-31','2016-08-02','2015-09-02 19:46:57','09032296549','[email protected]','8 Bonner Court','Integer ac neque. Duis bibendum.','C1WcbrRpk0',NULL,'active',NULL),(28,'Jimmy','Harrison','1989-11-25','2016-08-02','2016-04-25 16:57:27','09324459329','[email protected]','6859 Northport Junction','Nullam molestie nibh in lectus.','ildthivYj5d',NULL,'active',NULL),(29,'Joe','Hayes','1989-02-22','2016-08-02','2015-09-05 10:13:22','09282304848','[email protected]','3 Bartelt Pass','Integer pede justo, lacinia eget, tincidunt eget, tempus vel, pede.','Pf23c5aMS',20,'active','2016-08-06'),(30,'Carlos','Dunn','1989-07-19','2016-08-02','2016-08-09 08:41:21','09095903551','[email protected]','67492 Tennyson Road',NULL,'TxjfvADn',NULL,'active',NULL),(31,'Donald','Ortiz','1980-02-06','2016-08-02','2015-12-04 13:00:03','09555942587','[email protected]','27 Gina Court',NULL,'CoFhyXigMPn',NULL,'active',NULL),(32,'Ernest','Cook','1990-04-17','2016-08-02','2016-02-16 13:03:20','09915862177','[email protected]','6 Mosinee Avenue','Etiam pretium iaculis justo.','Y2HT7rsaTfJV',NULL,'active',NULL),(33,'Ernest','Chavez','1997-09-21','2016-08-02','2015-08-26 20:54:46','09749514782','[email protected]','1 Johnson Place',NULL,'gN5WdvLcTC',NULL,'suspended',NULL),(34,'Diane','Carter','1987-06-22','2016-08-02','2015-11-10 08:07:16','09811939376','[email protected]','2409 Northwestern Junction',NULL,'N5hmhFbJ7LRa',NULL,'active',NULL),(35,'Phyllis','Adams','1994-10-23','2016-08-02','2016-01-26 00:52:01','09782987703','[email protected]','90904 Norway Maple Junction','Morbi vel lectus in quam fringilla rhoncus. Mauris enim leo, rhoncus sed, vestibulum sit amet, cursu','1XxPXo4BxiT',6,'suspended','2016-08-03'),(36,'Shirley','Taylor','1992-04-15','2016-08-02','2016-06-07 02:24:01','09942316254','[email protected]','08827 Glendale Center','Suspendisse ornare consequat lectus. In est risus, auctor sed, tristique in, tempus sit amet, sem.','SomlQ4',NULL,'suspended',NULL),(37,'Patricia','Bryant','1993-02-25','2016-08-02','2016-04-19 22:38:08','09586928893','[email protected]','7 Corscot Hill',NULL,'oWLDE1gqqV2',11,'suspended','2016-08-05'),(38,'Kimberly','Day','1995-11-18','2016-08-02','2016-07-06 02:21:30','09139739322','[email protected]','2715 Steensland Crossing','Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibu','VtM0OCj',NULL,'suspended',NULL),(39,'Jacqueline','Ray','1997-12-22','2016-08-02','2016-04-23 12:43:26','09414660778','[email protected]','16510 Veith Parkway',NULL,'DqEbpC',NULL,'suspended',NULL),(40,'John','Martin','1990-04-22','2016-08-02','2015-08-08 20:28:18','09219987795','[email protected]','5204 Buena Vista Circle',NULL,'YQqSyygFBM87',NULL,'suspended',NULL),(41,'James','Garrett','1988-06-11','2016-08-02','2015-09-06 03:12:52','09817009034','[email protected]','56620 Packers Trail','Nulla ut erat id mauris vulputate elementum.','ipZu2aF',26,'active','2016-08-06'),(42,'Lawrence','Foster','1984-05-14','2016-08-02','2016-03-08 10:23:32','09117818204','[email protected]','2 Dwight Way',NULL,'GYGTZW43Em',12,'suspended','2016-08-02'),(43,'Ryan','Mitchell','1980-10-17','2016-08-02','2016-05-28 08:04:18','09591824775','[email protected]','3 Sunbrook Crossing',NULL,'cIxYq7E',NULL,'active',NULL),(44,'Jack','Morgan','1988-12-06','2016-08-02','2016-05-17 07:15:50','09181023207','[email protected]','50 Northfield Road',NULL,'A4IwkptlRtYT',9,'active','2016-08-02'),(45,'Kathy','Lewis','1980-05-04','2016-08-02','2016-04-20 19:38:16','09991399041','[email protected]','47133 Hazelcrest Crossing',NULL,'TnY4k5bN',NULL,'suspended',NULL),(46,'Douglas','Murphy','1993-01-08','2016-08-02','2015-09-18 07:39:46','09760016718','[email protected]','33 Comanche Way',NULL,'FMqidaEHE',NULL,'suspended',NULL),(47,'Anne','Moreno','1985-12-09','2016-08-02','2015-08-10 18:54:47','09050128247','[email protected]','9 Jay Road',NULL,'ZorTDGHdQ',NULL,'active',NULL),(48,'Nicole','Wheeler','1980-02-16','2016-08-02','2016-06-20 16:03:11','09490282714','[email protected]','1 Stephen Avenue',NULL,'VNgEz5BTK',NULL,'active',NULL),(49,'Antonio','Cunningham','1994-07-20','2016-08-02','2016-02-02 11:32:43','09105194212','[email protected]','751 Crownhardt Road',NULL,'AHzpoyr',NULL,'active',NULL),(50,'Ronald','Frazier','1982-04-04','2016-08-02','2015-10-22 18:25:55','09955713732','[email protected]','96 Leroy Court','Phasellus id sapien in sapien iaculis congue.','mZzYaog3c',NULL,'active',NULL),(51,'Heather','Hudson','1981-02-24','2016-08-02','2015-09-24 22:52:59','09361310699','[email protected]','884 Macpherson Junction',NULL,'ku1K5TkeDe',NULL,'suspended',NULL),(52,'Andrea','Mitchell','1985-01-06','2016-08-02','2016-04-25 12:28:19','09401832142','[email protected]','066 Kedzie Alley',NULL,'bpYwwHplp',4,'active','2016-08-03'),(53,'Joshua','Anderson','1996-03-09','2016-08-02','2016-05-24 19:52:21','09005140303','[email protected]','05 Oak Valley Alley',NULL,'44GPWVaG',NULL,'active',NULL),(54,'Ruth','Stone','1992-09-09','2016-08-02','2015-10-21 07:33:03','09572635573','[email protected]','7164 Fremont Alley','Etiam pretium iaculis justo. In hac habitasse platea dictumst.','UttTWHI',NULL,'active',NULL),(55,'Keith','Martinez','1993-10-06','2016-08-02','2015-12-13 17:51:55','09746482800','[email protected]','078 Old Gate Road','Nam ultrices, libero non mattis pulvinar, nulla pede ullamcorper augue, a suscipit nulla elit ac nul','c7mV7JCW',NULL,'suspended',NULL),(56,'Randy','Moore','1994-11-18','2016-08-02','2015-10-13 11:52:33','09965046035','[email protected]','49 Boyd Park',NULL,'fbNhdCI',NULL,'suspended',NULL),(57,'Todd','Simpson','1991-10-19','2016-08-02','2016-08-04 14:34:01','09291472373','[email protected]','31 Weeping Birch Park','Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.','k0E1XAC',23,'active','2016-08-02'),(58,'Walter','Wood','1988-12-07','2016-08-02','2016-07-21 22:23:32','09364643300','[email protected]','24 Hoepker Street',NULL,'xt6yhlFalLs',NULL,'suspended',NULL),(59,'Jose','Dixon','1982-05-08','2016-08-02','2016-03-13 19:29:11','09748142392','[email protected]','0 Carioca Lane','In congue.','3OAEB7NaJCj',14,'active','2016-08-05'),(60,'Virginia','Pierce','1986-12-12','2016-08-02','2015-11-09 00:30:22','09616083349','[email protected]','916 Raven Circle',NULL,'5RSjUCncQj',19,'active','2016-08-05'),(61,'Melissa','Mason','1981-04-02','2016-08-02','2015-12-15 05:08:23','09248630625','[email protected]','7061 Forest Crossing','Morbi a ipsum. Integer a nibh.','vGzfFHFM',NULL,'active',NULL),(62,'Debra','Tucker','1991-08-15','2016-08-02','2015-12-20 12:06:13','09127128639','[email protected]','670 Clove Park','Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue','rdkYvYH7QCCa',NULL,'active',NULL),(63,'Roy','Johnson','1985-11-26','2016-08-02','2015-10-09 23:09:24','09902215194','[email protected]','87197 Aberg Drive','Ut at dolor quis odio consequat varius.','RgWeT6I',NULL,'suspended',NULL),(64,'Jerry','Reed','1993-03-23','2016-08-02','2016-03-03 16:18:29','09485069353','[email protected]','5764 Steensland Plaza','Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.','mGVZXzQRkFR',NULL,'active',NULL),(65,'Margaret','Simpson','1985-10-25','2016-08-02','2015-12-13 16:33:51','09130886257','[email protected]','3 Reinke Park','Morbi non lectus.','51GCwbv',NULL,'active',NULL),(66,'Mary','West','1987-05-28','2016-08-02','2016-01-18 13:58:51','09870528948','[email protected]','32 5th Avenue',NULL,'7hjtDuvQic',NULL,'suspended',NULL),(67,'Benjamin','Owens','1988-01-24','2016-08-02','2015-09-28 12:45:15','09465721393','[email protected]','0466 Lyons Place','Proin at turpis a pede posuere nonummy.','wOTEjw4',NULL,'active',NULL),(68,'Lisa','Cox','1981-07-19','2016-08-02','2016-04-16 00:22:40','09259666728','[email protected]','2 Sachtjen Way','Aenean fermentum. Donec ut mauris eget massa tempor convallis.','P9RK8xGVGlON',NULL,'suspended',NULL),(69,'Melissa','Hart','1981-12-13','2016-08-02','2016-03-16 08:40:54','09898596743','[email protected]','7 Amoth Hill',NULL,'cXEpSmPoh',NULL,'suspended',NULL),(70,'Brenda','Simpson','1988-06-30','2016-08-02','2016-08-23 16:08:17','09798282198','[email protected]','24 Claremont Avenue',NULL,'F9fKAzpq4kJF',NULL,'active',NULL),(71,'Adam','Peters','1987-05-14','2016-08-02','2016-03-24 01:33:29','09064874176','[email protected]','87282 Center Hill','Donec posuere metus vitae ipsum. Aliquam non mauris.','t9Ljh6Fa3A9c',NULL,'suspended',NULL),(72,'Sean','Morrison','1988-06-17','2016-08-02','2015-09-14 15:35:19','09214905335','[email protected]','02 Delaware Road',NULL,'8TZEn6zUU',NULL,'suspended',NULL),(73,'Kenneth','Harvey','1987-03-29','2016-08-02','2016-08-11 05:27:55','09577183840','[email protected]','8342 Red Cloud Pass','Duis ac nibh.','1VfrFcan0O',NULL,'suspended',NULL),(74,'Rose','Austin','1982-06-28','2016-08-02','2016-07-22 19:02:06','09638569946','[email protected]','7 Laurel Park',NULL,'XDEKoJQfII',NULL,'suspended',NULL),(75,'Jack','Burns','1990-11-15','2016-08-02','2015-12-18 20:28:45','09361782739','[email protected]','7558 Dawn Terrace','Maecenas tincidunt lacus at velit.','ZdWxDXLPq',7,'active','2016-08-04'),(76,'Norma','Hamilton','1994-04-05','2016-08-02','2016-07-14 02:35:12','09771809650','[email protected]','965 Steensland Point','Pellentesque ultrices mattis odio.','bEHyqi1s5IZ',NULL,'suspended',NULL),(77,'Angela','Franklin','1991-10-04','2016-08-02','2015-09-18 12:30:34','09054517729','[email protected]','1 Maple Center',NULL,'ow6Uwqdu5Q',2,'suspended','2016-08-02'),(78,'Maria','Bryant','1990-02-17','2016-08-02','2015-12-17 08:54:05','09107402556','[email protected]','9355 Dovetail Trail','In hac habitasse platea dictumst.','zk2SBOOKHvLe',NULL,'suspended',NULL),(79,'John','Grant','1992-08-07','2016-08-02','2015-10-18 00:48:18','09902775494','[email protected]','97 Ludington Circle',NULL,'Fv4fVM8ce',NULL,'active',NULL),(80,'Tina','Sanders','1981-04-13','2016-08-02','2016-04-26 03:28:54','09605502639','[email protected]','6 Ridge Oak Drive',NULL,'WRJ4bmSAbpR',NULL,'active',NULL),(81,'Bruce','Diaz','1982-02-06','2016-08-02','2016-03-27 02:02:53','09753382992','[email protected]','9666 Esch Avenue',NULL,'hOIa11oe3s1t',27,'active','2016-08-05'),(82,'Nicholas','Wilson','1997-11-11','2016-08-02','2016-01-11 06:44:57','09329747330','[email protected]','3 Fieldstone Terrace','Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat.','cjZSoE9o',NULL,'suspended',NULL),(83,'Michelle','Hansen','1989-09-08','2016-08-02','2015-11-20 21:20:25','09112296878','[email protected]','946 Beilfuss Hill','Maecenas ut massa quis augue luctus tincidunt.','wZ8Yoj2s1ekL',NULL,'suspended',NULL),(84,'Christine','Young','1997-09-20','2016-08-02','2016-01-04 09:51:33','09370243583','[email protected]','9 Hansons Alley','Proin at turpis a pede posuere nonummy. Integer non velit.','B3SYd1XXE4',NULL,'active',NULL),(85,'Justin','Bell','1985-10-11','2016-08-02','2016-03-24 04:19:57','09247185472','[email protected]','44772 Oak Valley Plaza','Aliquam non mauris.','eJGUU1Xt',NULL,'suspended',NULL),(86,'Nicholas','Long','1989-12-20','2016-08-02','2015-09-25 05:00:53','09870582972','[email protected]','87 Kim Avenue',NULL,'8sFCZple',29,'suspended','2016-08-06'),(87,'Kenneth','Nelson','1996-06-19','2016-08-02','2016-02-06 03:25:57','09029984021','[email protected]','891 Prairieview Alley',NULL,'m1gCctiotGU',NULL,'active',NULL),(88,'Ralph','Bishop','1980-10-17','2016-08-02','2016-05-04 04:13:58','09609272889','[email protected]','88381 Dexter Drive',NULL,'43vvibz',NULL,'active',NULL),(89,'Carlos','Murphy','1996-04-19','2016-08-02','2016-07-14 21:37:41','09828142324','[email protected]','320 Donald Drive',NULL,'0BM0MYvmY94O',NULL,'suspended',NULL),(90,'Jeremy','Arnold','1984-10-22','2016-08-02','2015-11-19 03:59:34','09323556997','[email protected]','69927 Manitowish Circle',NULL,'Tgl53bSY8TE',NULL,'active',NULL),(91,'Linda','Stephens','1989-12-13','2016-08-02','2015-08-30 07:34:59','09736731679','[email protected]','3 Bashford Pass',NULL,'xaw4vFBCJ',NULL,'active',NULL),(92,'Harry','Price','1995-05-22','2016-08-02','2016-04-17 15:29:37','09564815775','[email protected]','5200 Pearson Lane',NULL,'rLqxVbJj',NULL,'active',NULL),(93,'Frances','Brown','1982-10-26','2016-08-02','2016-05-06 22:59:15','09191412232','[email protected]','867 Lillian Lane','Nullam varius.','JVyDvsw6L1',NULL,'active',NULL),(94,'Carlos','White','1996-04-18','2016-08-02','2015-10-09 05:00:15','09024809780','[email protected]','94084 Eliot Trail','Nulla ut erat id mauris vulputate elementum. Nullam varius.','A39t2E8B',28,'active','2016-08-02'),(95,'Dennis','Pierce','1993-01-16','2016-08-02','2015-11-22 20:42:27','09186347972','[email protected]','4 Manitowish Circle',NULL,'KFad5VbYVK',NULL,'suspended',NULL),(96,'Maria','Dunn','1982-08-18','2016-08-02','2016-01-13 15:21:02','09388084742','[email protected]','336 Dorton Circle','Etiam faucibus cursus urna.','gUZNomV',30,'active','2016-08-05'),(97,'David','Meyer','1983-05-21','2016-08-02','2016-03-30 11:44:14','09449989787','[email protected]','5722 Cardinal Place',NULL,'qt7XyA6J',NULL,'suspended',NULL),(98,'Irene','Snyder','1996-07-17','2016-08-02','2016-03-23 22:15:09','09999096985','[email protected]','907 Packers Pass',NULL,'dxZuCAqt',NULL,'suspended',NULL),(99,'Bobby','Chapman','1983-05-08','2016-08-02','2016-07-10 14:53:38','09381925219','[email protected]','647 Commercial Hill',NULL,'dIylhfLTt',NULL,'active',NULL),(100,'Brandon','Foster','1981-01-29','2016-08-02','2015-09-26 04:07:11','09112780056','[email protected]','369 Hintze Street',NULL,'CzYNHSL',NULL,'suspended',NULL),(101,'Marilyn','Burton','1984-11-29','2016-08-02','2016-03-20 04:35:20','09945316102','[email protected]','39 Linden Road','Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.','CKJ4eF9XYK',NULL,'suspended',NULL),(102,'Ann','Ramirez','1986-09-08','2016-08-02','2016-03-31 05:36:50','09885958695','[email protected]','1 Armistice Road','Cras pellentesque volutpat dui. Maecenas tristique, est et tempus semper, est quam pharetra magna, a','aMhhQi9VGw',NULL,'active',NULL),(103,'Edward','Perez','1987-04-11','2016-08-02','2015-09-30 10:19:06','09385539460','[email protected]','61 Mosinee Avenue',NULL,'SrWfuhm3G',NULL,'suspended',NULL),(104,'Craig','Lawrence','1989-12-24','2016-08-02','2015-10-10 03:39:12','09880210175','[email protected]','675 Loeprich Street','Ut tellus.','WQGFEk8qU',NULL,'active',NULL),(105,'Irene','Rose','1988-06-25','2016-08-02','2015-12-09 16:17:41','09194059981','[email protected]','913 Eagan Alley',NULL,'WWJIegTsG',NULL,'suspended',NULL),(106,'Angela','Wells','1989-07-17','2016-08-02','2016-08-10 06:37:22','09565496743','[email protected]','7344 Rockefeller Crossing','Donec dapibus. Duis at velit eu est congue elementum.','rwOEwJmuXZ',NULL,'active',NULL),(107,'Kelly','Torres','1997-04-28','2016-08-02','2016-05-25 10:15:06','09880801010','[email protected]','83 Independence Parkway',NULL,'pqKDePZy',NULL,'active',NULL),(108,'Walter','Wagner','1986-08-25','2016-08-02','2015-11-10 17:37:28','09716094283','[email protected]','77230 Brentwood Point','Proin eu mi. Nulla ac enim.','Wir0dIC',NULL,'suspended',NULL),(109,'Judith','Snyder','1994-04-29','2016-08-02','2016-02-08 11:57:46','09635277845','[email protected]','1 Columbus Plaza',NULL,'j4AwLZO6Acnn',NULL,'active',NULL),(110,'Lillian','Matthews','1990-06-06','2016-08-02','2015-09-18 20:17:23','09356475080','[email protected]','2 Raven Crossing','Integer a nibh.','MxSxh2Z',NULL,'suspended',NULL),(111,'Bonnie','Stanley','1981-04-27','2016-08-02','2015-11-07 22:16:52','09933162424','[email protected]','9827 Ilene Road',NULL,'NxuXkzL3sa',NULL,'suspended',NULL),(112,'Chris','Shaw','1995-09-08','2016-08-02','2016-07-01 09:46:52','09956558614','[email protected]','71 Quincy Center','Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibu','OplLbOX',NULL,'active',NULL),(113,'Karen','Graham','1996-11-09','2016-08-02','2016-04-18 03:00:18','09196410140','[email protected]','33 Buena Vista Crossing',NULL,'3eodXZNW2g',NULL,'active',NULL),(114,'Martha','Reyes','1993-11-13','2016-08-02','2016-01-19 14:38:33','09943456535','[email protected]','30900 Briar Crest Trail',NULL,'Hs1Txebis',NULL,'active',NULL),(115,'Richard','Knight','1992-11-25','2016-08-02','2016-05-25 04:58:46','09026733589','[email protected]','04674 Ruskin Pass',NULL,'JnTnLn25FSO',NULL,'active',NULL),(116,'Marilyn','Long','1985-02-27','2016-08-02','2015-10-21 19:42:36','09750480233','[email protected]','6201 Moulton Circle','Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum.','wPcqtp',NULL,'active',NULL),(117,'Janet','Gonzales','1984-10-22','2016-08-02','2016-07-18 18:01:54','09358414778','[email protected]','2661 1st Circle','Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis','a61lotE',NULL,'suspended',NULL),(118,'Larry','Hansen','1988-03-30','2016-08-02','2016-07-21 01:18:14','09906751895','[email protected]','93714 Caliangt Crossing','Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.','wpG1Ln5OxgQI',NULL,'suspended',NULL),(119,'Kathleen','Jones','1982-10-18','2016-08-02','2016-04-30 08:08:55','09912764089','[email protected]','221 Old Shore Hill','Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi e','YyZ41492pjJq',NULL,'suspended',NULL),(120,'Laura','Torres','1996-07-18','2016-08-02','2015-11-20 20:08:38','09985509341','[email protected]','78476 Service Park','Nulla mollis molestie lorem. Quisque ut erat.','cfvLiY',NULL,'suspended',NULL),(121,'Willie','Ellis','1982-05-18','2016-08-02','2016-06-26 08:28:54','09464248575','[email protected]','1 Bartelt Road',NULL,'J3RoD1D',NULL,'suspended',NULL),(122,'Sarah','Johnston','1987-09-18','2016-08-02','2016-07-31 23:38:44','09840053705','[email protected]','6 Eagan Plaza',NULL,'EEodcJBE',NULL,'active',NULL),(123,'Louis','Mitchell','1988-08-22','2016-08-02','2016-04-19 17:53:31','09148843888','[email protected]','1 Hanover Drive',NULL,'dHT9PxM3lf',NULL,'suspended',NULL),(124,'Timothy','Martinez','1982-11-06','2016-08-02','2016-02-20 18:09:27','09064282671','[email protected]','6978 Aberg Pass',NULL,'tr3OZw0sUG7K',NULL,'active',NULL),(125,'Cynthia','Washington','1993-03-25','2016-08-02','2016-07-25 07:53:17','09891799473','[email protected]','7 Autumn Leaf Street','Integer ac neque.','w2op0hE6',NULL,'active',NULL),(126,'Barbara','Myers','1982-08-10','2016-08-02','2016-02-14 16:38:44','09153500663','[email protected]','3198 Graceland Circle','Nulla suscipit ligula in lacus.','RJHLu9MwSL',NULL,'suspended',NULL),(127,'Amanda','Chavez','1988-01-17','2016-08-02','2015-11-15 03:01:16','09915605057','[email protected]','69439 Lotheville Center','Nulla tempus.','GFjtff',NULL,'active',NULL),(128,'Kevin','Ramirez','1988-03-27','2016-08-02','2016-02-18 15:16:39','09886151215','[email protected]','8 Petterle Trail',NULL,'RlQxum',NULL,'suspended',NULL),(129,'Eric','Russell','1989-12-18','2016-08-02','2015-08-31 23:16:37','09058001610','[email protected]','215 Bay Parkway','In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula ne','7bSvADNk',NULL,'active',NULL),(130,'Linda','Gonzalez','1980-05-20','2016-08-02','2016-03-20 02:08:20','09172091093','[email protected]','00 Banding Alley','Nulla mollis molestie lorem. Quisque ut erat.','tVQLPw4Ju9',NULL,'suspended',NULL),(131,'Virginia','Jenkins','1991-09-25','2016-08-02','2015-09-03 16:05:52','09571341464','[email protected]','668 Ridgeway Lane',NULL,'5qCSoK',NULL,'active',NULL),(132,'Louis','Hansen','1996-01-29','2016-08-02','2015-09-09 12:55:39','09599810585','[email protected]','65 Kings Alley','Proin at turpis a pede posuere nonummy.','QOnMn90p68oc',NULL,'suspended',NULL),(133,'Jane','Gilbert','1995-10-26','2016-08-02','2016-07-25 03:44:08','09236953004','[email protected]','8732 Drewry Trail','Proin at turpis a pede posuere nonummy. Integer non velit.','IxKseI',NULL,'active',NULL),(134,'George','Harper','1980-05-04','2016-08-02','2016-03-31 19:53:06','09463137848','[email protected]','548 Superior Street',NULL,'aNrkmyun',NULL,'active',NULL),(135,'Andrew','Tucker','1983-06-25','2016-08-02','2015-12-26 09:54:02','09908041274','[email protected]','945 Glendale Court','In est risus, auctor sed, tristique in, tempus sit amet, sem.','2XTSkH',NULL,'suspended',NULL),(136,'Joe','Kim','1992-08-29','2016-08-02','2016-06-15 23:19:36','09864891707','[email protected]','04034 Mcbride Point','Aenean lectus.','QFTgUnM',NULL,'suspended',NULL),(137,'Gerald','Hart','1989-10-15','2016-08-02','2015-11-02 05:06:54','09192586557','[email protected]','79 Oriole Court',NULL,'gWuWVhVc',NULL,'active',NULL),(138,'Lawrence','Edwards','1985-08-03','2016-08-02','2015-09-15 18:52:54','09647652725','[email protected]','7 John Wall Drive',NULL,'Y78F5pI',NULL,'suspended',NULL),(139,'Richard','Murray','1983-08-13','2016-08-02','2016-06-22 12:00:29','09855960062','[email protected]','3 8th Junction','Pellentesque ultrices mattis odio.','1n81ywib',NULL,'active',NULL),(140,'Janice','Castillo','1997-10-19','2016-08-02','2015-11-05 19:46:02','09106995275','[email protected]','373 Dovetail Center',NULL,'NPd6UH',NULL,'suspended',NULL),(141,'Jimmy','Ford','1989-09-03','2016-08-02','2015-09-16 12:05:51','09692622944','[email protected]','8269 Northland Terrace','Duis bibendum.','pl9AgqwmObQ',NULL,'active',NULL),(142,'Gloria','Baker','1981-11-10','2016-08-02','2015-08-20 08:37:05','09505637179','[email protected]','7120 Merchant Terrace','Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl.','ZjSRQ8QOG',NULL,'suspended',NULL),(143,'Terry','Morris','1994-07-22','2016-08-02','2016-04-15 14:31:47','09443688569','[email protected]','741 Forest Dale Hill',NULL,'VdL03BOBm0',NULL,'suspended',NULL),(144,'Angela','Hernandez','1987-10-16','2016-08-02','2016-07-13 23:12:31','09020827027','[email protected]','5 Blue Bill Park Road','Suspendisse potenti.','hOBHt2LiC',NULL,'suspended',NULL),(145,'Juan','Williams','1981-11-15','2016-08-02','2015-08-17 07:27:36','09680539704','[email protected]','0 Roth Crossing',NULL,'8uTNm2',NULL,'active',NULL),(146,'Lori','Henry','1987-09-10','2016-08-02','2016-05-14 04:52:36','09723759792','[email protected]','86564 Brickson Park Court',NULL,'QEp888c3Mjf',NULL,'suspended',NULL),(147,'Catherine','Woods','1982-03-23','2016-08-02','2016-04-04 22:39:15','09573831731','[email protected]','171 Dayton Point','Nunc nisl.','yRqyRf',NULL,'suspended',NULL),(148,'Deborah','Porter','1983-08-12','2016-08-02','2015-10-11 15:32:48','09772079128','[email protected]','335 Loeprich Drive','Nulla ut erat id mauris vulputate elementum. Nullam varius.','ZFvQCUyfGyp',NULL,'suspended',NULL),(149,'Ruth','Gomez','1992-12-12','2016-08-02','2016-04-22 04:05:50','09089317297','[email protected]','82 Fulton Avenue',NULL,'LomePgS4',NULL,'active',NULL),(150,'Martin','Hall','1990-11-17','2016-08-02','2016-02-26 14:45:58','09305859338','[email protected]','55279 Chive Alley',NULL,'kesbLeJrQpjW',NULL,'suspended',NULL),(151,'Harold','Bennett','1988-11-15','2016-08-02','2016-03-21 03:15:01','09312356175','[email protected]','90377 Chinook Road',NULL,'gJvC2idLlgV',NULL,'suspended',NULL),(152,'Pamela','Moreno','1988-07-02','2016-08-02','2016-06-26 08:21:35','09565951718','[email protected]','91 Sullivan Road','Morbi quis tortor id nulla ultrices aliquet.','qDuRspWu6a1',NULL,'active',NULL),(153,'Nancy','Kennedy','1997-05-07','2016-08-02','2015-11-26 15:18:57','09319736094','[email protected]','702 Anzinger Avenue',NULL,'lVIKobxdW9',NULL,'active',NULL),(154,'Julie','Gomez','1993-01-29','2016-08-02','2016-02-23 11:39:20','09930475133','[email protected]','75 Mayer Road','In quis justo. Maecenas rhoncus aliquam lacus.','45ujYZqh5Lth',21,'active','2016-08-05'),(155,'Martha','Campbell','1993-03-22','2016-08-02','2015-09-26 05:26:33','09400613617','[email protected]','91599 Monica Hill',NULL,'gs5alzFS1Oh',NULL,'active',NULL),(156,'Ruby','Hughes','1991-05-19','2016-08-02','2015-11-12 20:02:56','09049226235','[email protected]','20414 Hooker Junction','Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus.','CDlJQko6X',NULL,'active',NULL),(157,'Aaron','Martin','1995-10-10','2016-08-02','2015-08-29 04:44:41','09717831940','[email protected]','805 Maryland Pass','Integer tincidunt ante vel ipsum.','IwocRpG7H',NULL,'suspended',NULL),(158,'Sara','Hunt','1994-06-23','2016-08-02','2016-03-21 01:46:01','09261254101','[email protected]','69 Valley Edge Pass','Morbi quis tortor id nulla ultrices aliquet.','dVJ0F6PbQP',NULL,'suspended',NULL),(159,'Kenneth','Allen','1995-03-07','2016-08-02','2015-11-07 19:08:45','09099677554','[email protected]','616 Hayes Street','Maecenas pulvinar lobortis est. Phasellus sit amet erat.','ihsyGi6hgFKH',NULL,'suspended',NULL),(160,'Christopher','Nelson','1980-05-19','2016-08-02','2015-08-21 07:56:37','09060868282','[email protected]','7 Ridgeway Junction',NULL,'L9SW15iS',NULL,'active',NULL),(161,'Steve','Rodriguez','1985-05-16','2016-08-02','2016-04-06 23:23:32','09200326248','[email protected]','794 Northland Place',NULL,'X7BIx8',NULL,'suspended',NULL),(162,'Shirley','Nelson','1992-02-05','2016-08-02','2015-12-09 13:06:54','09020182414','[email protected]','57 Carpenter Terrace',NULL,'wrX57eXExf',NULL,'active',NULL),(163,'Anne','Berry','1992-07-08','2016-08-02','2015-11-12 20:33:57','09895339933','[email protected]','42 Sachtjen Alley','Duis consequat dui nec nisi volutpat eleifend.','E2LqJzGf9',NULL,'active',NULL),(164,'Daniel','Chapman','1994-07-16','2016-08-02','2015-12-10 07:57:08','09336293755','[email protected]','2969 Delaware Road',NULL,'jsB7h3dQe',NULL,'active',NULL),(165,'Walter','Hudson','1983-05-13','2016-08-02','2016-01-05 10:59:41','09976302394','[email protected]','2757 Dovetail Pass',NULL,'k7UBqA',NULL,'active',NULL),(166,'Gregory','Stephens','1985-01-22','2016-08-02','2016-03-13 23:28:57','09005436741','[email protected]','77358 Sage Plaza','Nulla justo.','Wr3fUCS',NULL,'active',NULL),(167,'Earl','Jenkins','1991-11-02','2016-08-02','2015-08-31 10:55:21','09583491277','[email protected]','74 Clove Terrace','Vestibulum sed magna at nunc commodo placerat. Praesent blandit.','PV3CyYj',NULL,'suspended',NULL),(168,'Mildred','Ellis','1990-04-04','2016-08-02','2015-11-25 21:23:52','09045541420','[email protected]','8 Knutson Way',NULL,'c3sn2Ap',NULL,'active',NULL),(169,'Ashley','Hunt','1985-03-17','2016-08-02','2015-08-30 02:24:55','09505441398','[email protected]','42 5th Drive','Lorem ipsum dolor sit amet, consectetuer adipiscing elit.','ZHSDTpnidGKc',10,'active','2016-08-05'),(170,'Barbara','Rodriguez','1982-08-04','2016-08-02','2015-12-10 22:56:23','09602096877','[email protected]','44483 Caliangt Circle','In est risus, auctor sed, tristique in, tempus sit amet, sem.','euRFeh4Zd',NULL,'active',NULL),(171,'Ryan','Chavez','1995-07-29','2016-08-02','2015-09-29 09:08:43','09897360178','[email protected]','9 Warrior Road','Nam nulla.','YKgf17Bi',NULL,'active',NULL),(172,'Jerry','Richards','1992-05-27','2016-08-02','2016-07-30 06:58:00','09912021639','[email protected]','29 Barnett Center',NULL,'3bFMz7J',NULL,'active',NULL),(173,'Lori','Thomas','1984-03-13','2016-08-02','2016-04-18 21:05:39','09439638177','[email protected]','28 Oak Parkway','Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis.','GN51ok5Lx',NULL,'suspended',NULL),(174,'Kenneth','Watson','1990-08-01','2016-08-02','2016-04-01 05:24:14','09064852202','[email protected]','58 Blue Bill Park Street','In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula ne','hrt0455ZYrJ4',NULL,'active',NULL),(175,'Earl','Pierce','1991-08-22','2016-08-02','2015-11-24 01:07:02','09516358381','[email protected]','552 Heath Place','Donec ut mauris eget massa tempor convallis.','3cECGcS8',NULL,'suspended',NULL),(176,'James','Price','1991-06-30','2016-08-02','2016-07-08 18:35:50','09722586586','[email protected]','3402 Shelley Parkway',NULL,'VnFqHU6pQJP',NULL,'suspended',NULL),(177,'Lawrence','Little','1988-08-04','2016-08-02','2016-02-18 08:58:17','09657671580','[email protected]','21621 Arrowood Parkway','Integer a nibh. In quis justo.','QzZ81U54S',NULL,'active',NULL),(178,'Helen','White','1989-10-31','2016-08-02','2015-09-03 21:09:05','09520574951','[email protected]','103 Homewood Way',NULL,'pBkHuM0IEc',NULL,'active',NULL),(179,'Christopher','Hamilton','1995-04-10','2016-08-02','2015-10-01 16:24:43','09042896865','[email protected]','63 Buhler Way',NULL,'gG0g8dfta',NULL,'active',NULL),(180,'Antonio','Shaw','1989-12-21','2016-08-02','2016-04-02 17:08:02','09619731908','[email protected]','36 Dunning Crossing','Praesent blandit.','OGjRSZEFJ1',NULL,'active',NULL),(181,'Cynthia','Harper','1995-02-18','2016-08-02','2015-10-18 22:24:29','09761352298','[email protected]','9 Mosinee Avenue',NULL,'PHr3whh4KxI',NULL,'suspended',NULL),(182,'Eugene','Cunningham','1982-09-15','2016-08-02','2016-01-15 21:15:04','09393476162','[email protected]','25711 Blaine Place',NULL,'lbK5cXU',NULL,'suspended',NULL),(183,'Julia','Stone','1991-07-20','2016-08-02','2015-10-01 02:07:11','09962294579','[email protected]','3 Dayton Street',NULL,'00yXnZR',NULL,'active',NULL),(184,'Jerry','Lawrence','1982-10-16','2016-08-02','2015-09-10 01:42:18','09929290324','[email protected]','72 Crowley Center','Mauris ullamcorper purus sit amet nulla.','uEx71bXoeR',NULL,'active',NULL),(185,'Alice','Martinez','1995-05-05','2016-08-02','2015-10-27 07:51:20','09875827800','[email protected]','27 Canary Lane',NULL,'Akg4RsIQp',NULL,'active',NULL),(186,'Jacqueline','Black','1996-10-30','2016-08-02','2016-06-03 17:56:37','09226271411','[email protected]','7 Drewry Hill',NULL,'fMJu337Shd',NULL,'active',NULL),(187,'Louis','Meyer','1993-03-24','2016-08-02','2016-05-31 15:00:15','09211765080','[email protected]','4892 International Drive','Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidu','s9CRfL',NULL,'active',NULL),(188,'Andrea','Burns','1986-01-14','2016-08-02','2016-05-08 20:36:54','09172898331','[email protected]','85 Independence Place','Maecenas ut massa quis augue luctus tincidunt.','YNxnoVJ',NULL,'suspended',NULL),(189,'Harold','Coleman','1989-12-17','2016-08-02','2016-04-16 08:13:38','09792413555','[email protected]','4422 Shoshone Trail','Integer non velit.','kdJA1p',NULL,'active',NULL),(190,'Carolyn','Johnson','1984-02-22','2016-08-02','2016-04-19 05:10:50','09097969090','[email protected]','61 Bay Pass',NULL,'UL56FHR3H',NULL,'active',NULL),(191,'Rachel','Patterson','1996-05-30','2016-08-02','2015-08-13 19:04:08','09494086718','[email protected]','9186 Saint Paul Point',NULL,'9s6eib7C',NULL,'suspended',NULL),(192,'Donald','Chapman','1989-01-22','2016-08-02','2016-06-18 06:06:40','09872450811','[email protected]','7 Eliot Way',NULL,'ZkjxkW',NULL,'active',NULL),(193,'Henry','Montgomery','1980-02-07','2016-08-02','2016-06-13 18:50:20','09335289726','[email protected]','4534 Evergreen Court','Proin interdum mauris non ligula pellentesque ultrices.','MBLRpqWPn',NULL,'active',NULL),(194,'Irene','Wheeler','1990-11-02','2016-08-02','2015-08-27 16:53:16','09242117118','[email protected]','12 Golf Course Plaza',NULL,'ivU7oLpvSY2',NULL,'suspended',NULL),(195,'Jesse','Wood','1980-12-18','2016-08-02','2016-02-06 14:32:31','09879476808','[email protected]','9 Rutledge Park','Duis bibendum. Morbi non quam nec dui luctus rutrum.','PxAGmAs7NO',NULL,'active',NULL),(196,'Sara','Medina','1991-04-27','2016-08-02','2016-02-03 09:57:47','09833367564','[email protected]','80 Stuart Drive',NULL,'u8d6e2e67P',NULL,'suspended',NULL),(197,'Brandon','Snyder','1980-11-16','2016-08-02','2015-11-15 21:16:25','09127762557','[email protected]','43782 Sauthoff Court',NULL,'axUHv5',NULL,'suspended',NULL),(198,'Carl','Mason','1981-01-09','2016-08-02','2016-03-11 16:44:23','09244601836','[email protected]','45 Lighthouse Bay Pass','Duis consequat dui nec nisi volutpat eleifend. Donec ut dolor.','EpLjapEGL',NULL,'active',NULL),(199,'David','Jackson','1987-04-16','2016-08-02','2015-11-26 12:42:56','09286158194','[email protected]','2034 Scofield Point',NULL,'LG70Ine',NULL,'active',NULL),(200,'Janice','Burton','1990-12-07','2016-08-02','2015-08-20 05:56:47','09449397720','[email protected]','42 Nobel Hill','Duis bibendum, felis sed interdum venenatis, turpis enim blandit mi, in porttitor pede justo eu mass','2Y9jijto',NULL,'active',NULL),(201,'Andrea','Chavez','1981-12-27','2016-08-02','2015-11-18 01:06:55','09745062924','[email protected]','8044 Eggendart Lane','Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.','sE2Tta',NULL,'suspended',NULL),(202,'Benjamin','Price','1983-09-22','2016-08-02','2015-11-10 01:44:03','09164043541','[email protected]','9 Morrow Center','Praesent lectus.','AstIea',NULL,'suspended',NULL);
/*!40000 ALTER TABLE `users` 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 2016-08-24 20:42:52