-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathKapino.sql
More file actions
209 lines (182 loc) · 81.1 KB
/
Copy pathKapino.sql
File metadata and controls
209 lines (182 loc) · 81.1 KB
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','joe.pakistan@gmail.com','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','dlsu.sachii@gmail.com','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','ewillis0@nymag.com','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','emoore1@mac.com','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','mwarren2@quantcast.com','929 Westerfield Parkway',NULL,'IxllkSFG9O',NULL,'suspended',NULL),(6,'Barbara','Mcdonald','1980-09-14','2016-08-02','2016-03-31 20:18:14','09409800272','bmcdonald3@sphinn.com','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','wwallace4@imageshack.us','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','dcook5@gizmodo.com','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','wpalmer6@wikimedia.org','30212 Boyd Circle',NULL,'tfX0BbzJ',NULL,'active',NULL),(10,'Maria','Parker','1987-08-03','2016-08-02','2015-12-11 06:56:30','09372785534','mparker7@shareasale.com','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','dromero8@photobucket.com','930 Corben Point',NULL,'SoH9laFy41',NULL,'suspended',NULL),(12,'Justin','Berry','1997-09-17','2016-08-02','2015-12-19 09:33:42','09280804491','jberry9@freewebs.com','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','icooka@yahoo.com','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','pstephensb@cmu.edu','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','mkelleyc@weather.com','871 Amoth Circle',NULL,'7T5nOX',NULL,'suspended',NULL),(16,'Lois','Garza','1993-03-03','2016-08-02','2015-10-22 23:59:34','09310225673','lgarzad@istockphoto.com','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','jalvareze@china.com.cn','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','slawrencef@a8.net','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','tscottg@nydailynews.com','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','eroseh@usatoday.com','71 Michigan Hill',NULL,'vSwMKTd5MSm',NULL,'active',NULL),(21,'Alan','Martin','1994-08-25','2016-08-02','2016-02-10 20:18:45','09499775819','amartini@china.com.cn','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','bhillj@naver.com','4 Kropf Court',NULL,'ad4NxQ',NULL,'active',NULL),(23,'Deborah','Andrews','1980-03-28','2016-08-02','2016-02-26 05:45:28','09959136064','dandrewsk@statcounter.com','426 Straubel Lane',NULL,'DgEr5tDF8qS',NULL,'active',NULL),(24,'Janet','Gray','1989-10-06','2016-08-02','2015-09-02 15:22:47','09532247671','jgrayl@nationalgeographic.com','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','krichardsm@amazon.co.uk','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','lallenn@noaa.gov','78 Anthes Alley',NULL,'PQyiGylhYYQV',NULL,'suspended',NULL),(27,'Shirley','Bailey','1985-05-31','2016-08-02','2015-09-02 19:46:57','09032296549','sbaileyo@rambler.ru','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','jharrisonp@ibm.com','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','jhayesq@freewebs.com','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','cdunnr@freewebs.com','67492 Tennyson Road',NULL,'TxjfvADn',NULL,'active',NULL),(31,'Donald','Ortiz','1980-02-06','2016-08-02','2015-12-04 13:00:03','09555942587','dortizs@ning.com','27 Gina Court',NULL,'CoFhyXigMPn',NULL,'active',NULL),(32,'Ernest','Cook','1990-04-17','2016-08-02','2016-02-16 13:03:20','09915862177','ecookt@mail.ru','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','echavezu@163.com','1 Johnson Place',NULL,'gN5WdvLcTC',NULL,'suspended',NULL),(34,'Diane','Carter','1987-06-22','2016-08-02','2015-11-10 08:07:16','09811939376','dcarterv@blogs.com','2409 Northwestern Junction',NULL,'N5hmhFbJ7LRa',NULL,'active',NULL),(35,'Phyllis','Adams','1994-10-23','2016-08-02','2016-01-26 00:52:01','09782987703','padamsw@jugem.jp','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','staylorx@google.nl','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','pbryanty@unesco.org','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','kdayz@fastcompany.com','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','jray10@ning.com','16510 Veith Parkway',NULL,'DqEbpC',NULL,'suspended',NULL),(40,'John','Martin','1990-04-22','2016-08-02','2015-08-08 20:28:18','09219987795','jmartin11@google.it','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','jgarrett12@tuttocitta.it','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','lfoster13@shareasale.com','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','rmitchell14@thetimes.co.uk','3 Sunbrook Crossing',NULL,'cIxYq7E',NULL,'active',NULL),(44,'Jack','Morgan','1988-12-06','2016-08-02','2016-05-17 07:15:50','09181023207','jmorgan15@seattletimes.com','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','klewis16@newsvine.com','47133 Hazelcrest Crossing',NULL,'TnY4k5bN',NULL,'suspended',NULL),(46,'Douglas','Murphy','1993-01-08','2016-08-02','2015-09-18 07:39:46','09760016718','dmurphy17@cyberchimps.com','33 Comanche Way',NULL,'FMqidaEHE',NULL,'suspended',NULL),(47,'Anne','Moreno','1985-12-09','2016-08-02','2015-08-10 18:54:47','09050128247','amoreno18@gov.uk','9 Jay Road',NULL,'ZorTDGHdQ',NULL,'active',NULL),(48,'Nicole','Wheeler','1980-02-16','2016-08-02','2016-06-20 16:03:11','09490282714','nwheeler19@slate.com','1 Stephen Avenue',NULL,'VNgEz5BTK',NULL,'active',NULL),(49,'Antonio','Cunningham','1994-07-20','2016-08-02','2016-02-02 11:32:43','09105194212','acunningham1a@wufoo.com','751 Crownhardt Road',NULL,'AHzpoyr',NULL,'active',NULL),(50,'Ronald','Frazier','1982-04-04','2016-08-02','2015-10-22 18:25:55','09955713732','rfrazier1b@whitehouse.gov','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','hhudson1c@fotki.com','884 Macpherson Junction',NULL,'ku1K5TkeDe',NULL,'suspended',NULL),(52,'Andrea','Mitchell','1985-01-06','2016-08-02','2016-04-25 12:28:19','09401832142','amitchell1d@people.com.cn','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','janderson1e@census.gov','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','rstone1f@opensource.org','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','kmartinez1g@dyndns.org','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','rmoore1h@arizona.edu','49 Boyd Park',NULL,'fbNhdCI',NULL,'suspended',NULL),(57,'Todd','Simpson','1991-10-19','2016-08-02','2016-08-04 14:34:01','09291472373','tsimpson1i@wikispaces.com','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','wwood1j@constantcontact.com','24 Hoepker Street',NULL,'xt6yhlFalLs',NULL,'suspended',NULL),(59,'Jose','Dixon','1982-05-08','2016-08-02','2016-03-13 19:29:11','09748142392','jdixon1k@virginia.edu','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','vpierce1l@webs.com','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','mmason1m@baidu.com','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','dtucker1n@goo.ne.jp','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','rjohnson1o@dagondesign.com','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','jreed1p@naver.com','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','msimpson1q@scribd.com','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','mwest1r@acquirethisname.com','32 5th Avenue',NULL,'7hjtDuvQic',NULL,'suspended',NULL),(67,'Benjamin','Owens','1988-01-24','2016-08-02','2015-09-28 12:45:15','09465721393','bowens1s@seesaa.net','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','lcox1t@altervista.org','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','mhart1u@fotki.com','7 Amoth Hill',NULL,'cXEpSmPoh',NULL,'suspended',NULL),(70,'Brenda','Simpson','1988-06-30','2016-08-02','2016-08-23 16:08:17','09798282198','bsimpson1v@hibu.com','24 Claremont Avenue',NULL,'F9fKAzpq4kJF',NULL,'active',NULL),(71,'Adam','Peters','1987-05-14','2016-08-02','2016-03-24 01:33:29','09064874176','apeters1w@illinois.edu','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','smorrison1x@arizona.edu','02 Delaware Road',NULL,'8TZEn6zUU',NULL,'suspended',NULL),(73,'Kenneth','Harvey','1987-03-29','2016-08-02','2016-08-11 05:27:55','09577183840','kharvey1y@freewebs.com','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','raustin1z@aol.com','7 Laurel Park',NULL,'XDEKoJQfII',NULL,'suspended',NULL),(75,'Jack','Burns','1990-11-15','2016-08-02','2015-12-18 20:28:45','09361782739','jburns20@hexun.com','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','nhamilton21@sohu.com','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','afranklin22@mit.edu','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','mbryant23@php.net','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','jgrant24@surveymonkey.com','97 Ludington Circle',NULL,'Fv4fVM8ce',NULL,'active',NULL),(80,'Tina','Sanders','1981-04-13','2016-08-02','2016-04-26 03:28:54','09605502639','tsanders25@fastcompany.com','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','bdiaz26@stumbleupon.com','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','nwilson27@blinklist.com','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','mhansen28@purevolume.com','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','cyoung29@meetup.com','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','jbell2a@sohu.com','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','nlong2b@fc2.com','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','knelson2c@devhub.com','891 Prairieview Alley',NULL,'m1gCctiotGU',NULL,'active',NULL),(88,'Ralph','Bishop','1980-10-17','2016-08-02','2016-05-04 04:13:58','09609272889','rbishop2d@themeforest.net','88381 Dexter Drive',NULL,'43vvibz',NULL,'active',NULL),(89,'Carlos','Murphy','1996-04-19','2016-08-02','2016-07-14 21:37:41','09828142324','cmurphy2e@intel.com','320 Donald Drive',NULL,'0BM0MYvmY94O',NULL,'suspended',NULL),(90,'Jeremy','Arnold','1984-10-22','2016-08-02','2015-11-19 03:59:34','09323556997','jarnold2f@statcounter.com','69927 Manitowish Circle',NULL,'Tgl53bSY8TE',NULL,'active',NULL),(91,'Linda','Stephens','1989-12-13','2016-08-02','2015-08-30 07:34:59','09736731679','lstephens2g@timesonline.co.uk','3 Bashford Pass',NULL,'xaw4vFBCJ',NULL,'active',NULL),(92,'Harry','Price','1995-05-22','2016-08-02','2016-04-17 15:29:37','09564815775','hprice2h@tuttocitta.it','5200 Pearson Lane',NULL,'rLqxVbJj',NULL,'active',NULL),(93,'Frances','Brown','1982-10-26','2016-08-02','2016-05-06 22:59:15','09191412232','fbrown2i@sciencedirect.com','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','cwhite2j@sciencedirect.com','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','dpierce2k@myspace.com','4 Manitowish Circle',NULL,'KFad5VbYVK',NULL,'suspended',NULL),(96,'Maria','Dunn','1982-08-18','2016-08-02','2016-01-13 15:21:02','09388084742','mdunn2l@360.cn','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','dmeyer2m@jiathis.com','5722 Cardinal Place',NULL,'qt7XyA6J',NULL,'suspended',NULL),(98,'Irene','Snyder','1996-07-17','2016-08-02','2016-03-23 22:15:09','09999096985','isnyder2n@shinystat.com','907 Packers Pass',NULL,'dxZuCAqt',NULL,'suspended',NULL),(99,'Bobby','Chapman','1983-05-08','2016-08-02','2016-07-10 14:53:38','09381925219','bchapman2o@ocn.ne.jp','647 Commercial Hill',NULL,'dIylhfLTt',NULL,'active',NULL),(100,'Brandon','Foster','1981-01-29','2016-08-02','2015-09-26 04:07:11','09112780056','bfoster2p@reference.com','369 Hintze Street',NULL,'CzYNHSL',NULL,'suspended',NULL),(101,'Marilyn','Burton','1984-11-29','2016-08-02','2016-03-20 04:35:20','09945316102','mburton2q@over-blog.com','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','aramirez2r@github.io','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','eperez2s@scribd.com','61 Mosinee Avenue',NULL,'SrWfuhm3G',NULL,'suspended',NULL),(104,'Craig','Lawrence','1989-12-24','2016-08-02','2015-10-10 03:39:12','09880210175','clawrence2t@miitbeian.gov.cn','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','irose2u@ocn.ne.jp','913 Eagan Alley',NULL,'WWJIegTsG',NULL,'suspended',NULL),(106,'Angela','Wells','1989-07-17','2016-08-02','2016-08-10 06:37:22','09565496743','awells2v@cbslocal.com','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','ktorres2w@mtv.com','83 Independence Parkway',NULL,'pqKDePZy',NULL,'active',NULL),(108,'Walter','Wagner','1986-08-25','2016-08-02','2015-11-10 17:37:28','09716094283','wwagner2x@squarespace.com','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','jsnyder2y@bing.com','1 Columbus Plaza',NULL,'j4AwLZO6Acnn',NULL,'active',NULL),(110,'Lillian','Matthews','1990-06-06','2016-08-02','2015-09-18 20:17:23','09356475080','lmatthews2z@sohu.com','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','bstanley30@cbsnews.com','9827 Ilene Road',NULL,'NxuXkzL3sa',NULL,'suspended',NULL),(112,'Chris','Shaw','1995-09-08','2016-08-02','2016-07-01 09:46:52','09956558614','cshaw31@posterous.com','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','kgraham32@wufoo.com','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','mreyes33@nih.gov','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','rknight34@salon.com','04674 Ruskin Pass',NULL,'JnTnLn25FSO',NULL,'active',NULL),(116,'Marilyn','Long','1985-02-27','2016-08-02','2015-10-21 19:42:36','09750480233','mlong35@opensource.org','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','jgonzales36@ebay.com','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','lhansen37@google.com.hk','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','kjones38@reference.com','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','ltorres39@etsy.com','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','wellis3a@earthlink.net','1 Bartelt Road',NULL,'J3RoD1D',NULL,'suspended',NULL),(122,'Sarah','Johnston','1987-09-18','2016-08-02','2016-07-31 23:38:44','09840053705','sjohnston3b@delicious.com','6 Eagan Plaza',NULL,'EEodcJBE',NULL,'active',NULL),(123,'Louis','Mitchell','1988-08-22','2016-08-02','2016-04-19 17:53:31','09148843888','lmitchell3c@163.com','1 Hanover Drive',NULL,'dHT9PxM3lf',NULL,'suspended',NULL),(124,'Timothy','Martinez','1982-11-06','2016-08-02','2016-02-20 18:09:27','09064282671','tmartinez3d@sakura.ne.jp','6978 Aberg Pass',NULL,'tr3OZw0sUG7K',NULL,'active',NULL),(125,'Cynthia','Washington','1993-03-25','2016-08-02','2016-07-25 07:53:17','09891799473','cwashington3e@istockphoto.com','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','bmyers3f@ycombinator.com','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','achavez3g@gizmodo.com','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','kramirez3h@sina.com.cn','8 Petterle Trail',NULL,'RlQxum',NULL,'suspended',NULL),(129,'Eric','Russell','1989-12-18','2016-08-02','2015-08-31 23:16:37','09058001610','erussell3i@vk.com','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','lgonzalez3j@cpanel.net','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','vjenkins3k@adobe.com','668 Ridgeway Lane',NULL,'5qCSoK',NULL,'active',NULL),(132,'Louis','Hansen','1996-01-29','2016-08-02','2015-09-09 12:55:39','09599810585','lhansen3l@toplist.cz','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','jgilbert3m@webs.com','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','gharper3n@discovery.com','548 Superior Street',NULL,'aNrkmyun',NULL,'active',NULL),(135,'Andrew','Tucker','1983-06-25','2016-08-02','2015-12-26 09:54:02','09908041274','atucker3o@goo.gl','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','jkim3p@go.com','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','ghart3q@simplemachines.org','79 Oriole Court',NULL,'gWuWVhVc',NULL,'active',NULL),(138,'Lawrence','Edwards','1985-08-03','2016-08-02','2015-09-15 18:52:54','09647652725','ledwards3r@canalblog.com','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','rmurray3s@sitemeter.com','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','jcastillo3t@blinklist.com','373 Dovetail Center',NULL,'NPd6UH',NULL,'suspended',NULL),(141,'Jimmy','Ford','1989-09-03','2016-08-02','2015-09-16 12:05:51','09692622944','jford3u@fc2.com','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','gbaker3v@businesswire.com','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','tmorris3w@oracle.com','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','ahernandez3x@spiegel.de','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','jwilliams3y@ebay.com','0 Roth Crossing',NULL,'8uTNm2',NULL,'active',NULL),(146,'Lori','Henry','1987-09-10','2016-08-02','2016-05-14 04:52:36','09723759792','lhenry3z@elegantthemes.com','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','cwoods40@goodreads.com','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','dporter41@hud.gov','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','rgomez42@boston.com','82 Fulton Avenue',NULL,'LomePgS4',NULL,'active',NULL),(150,'Martin','Hall','1990-11-17','2016-08-02','2016-02-26 14:45:58','09305859338','mhall43@cnn.com','55279 Chive Alley',NULL,'kesbLeJrQpjW',NULL,'suspended',NULL),(151,'Harold','Bennett','1988-11-15','2016-08-02','2016-03-21 03:15:01','09312356175','hbennett44@tinyurl.com','90377 Chinook Road',NULL,'gJvC2idLlgV',NULL,'suspended',NULL),(152,'Pamela','Moreno','1988-07-02','2016-08-02','2016-06-26 08:21:35','09565951718','pmoreno45@free.fr','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','nkennedy46@slideshare.net','702 Anzinger Avenue',NULL,'lVIKobxdW9',NULL,'active',NULL),(154,'Julie','Gomez','1993-01-29','2016-08-02','2016-02-23 11:39:20','09930475133','jgomez47@blogspot.com','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','mcampbell48@booking.com','91599 Monica Hill',NULL,'gs5alzFS1Oh',NULL,'active',NULL),(156,'Ruby','Hughes','1991-05-19','2016-08-02','2015-11-12 20:02:56','09049226235','rhughes49@nature.com','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','amartin4a@behance.net','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','shunt4b@nifty.com','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','kallen4c@pagesperso-orange.fr','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','cnelson4d@nyu.edu','7 Ridgeway Junction',NULL,'L9SW15iS',NULL,'active',NULL),(161,'Steve','Rodriguez','1985-05-16','2016-08-02','2016-04-06 23:23:32','09200326248','srodriguez4e@skyrock.com','794 Northland Place',NULL,'X7BIx8',NULL,'suspended',NULL),(162,'Shirley','Nelson','1992-02-05','2016-08-02','2015-12-09 13:06:54','09020182414','snelson4f@mayoclinic.com','57 Carpenter Terrace',NULL,'wrX57eXExf',NULL,'active',NULL),(163,'Anne','Berry','1992-07-08','2016-08-02','2015-11-12 20:33:57','09895339933','aberry4g@storify.com','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','dchapman4h@digg.com','2969 Delaware Road',NULL,'jsB7h3dQe',NULL,'active',NULL),(165,'Walter','Hudson','1983-05-13','2016-08-02','2016-01-05 10:59:41','09976302394','whudson4i@github.com','2757 Dovetail Pass',NULL,'k7UBqA',NULL,'active',NULL),(166,'Gregory','Stephens','1985-01-22','2016-08-02','2016-03-13 23:28:57','09005436741','gstephens4j@booking.com','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','ejenkins4k@sitemeter.com','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','mellis4l@elpais.com','8 Knutson Way',NULL,'c3sn2Ap',NULL,'active',NULL),(169,'Ashley','Hunt','1985-03-17','2016-08-02','2015-08-30 02:24:55','09505441398','ahunt4m@intel.com','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','brodriguez4n@t-online.de','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','rchavez4o@baidu.com','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','jrichards4p@webnode.com','29 Barnett Center',NULL,'3bFMz7J',NULL,'active',NULL),(173,'Lori','Thomas','1984-03-13','2016-08-02','2016-04-18 21:05:39','09439638177','lthomas4q@hao123.com','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','kwatson4r@bluehost.com','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','epierce4s@businessweek.com','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','jprice4t@ucoz.ru','3402 Shelley Parkway',NULL,'VnFqHU6pQJP',NULL,'suspended',NULL),(177,'Lawrence','Little','1988-08-04','2016-08-02','2016-02-18 08:58:17','09657671580','llittle4u@ow.ly','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','hwhite4v@illinois.edu','103 Homewood Way',NULL,'pBkHuM0IEc',NULL,'active',NULL),(179,'Christopher','Hamilton','1995-04-10','2016-08-02','2015-10-01 16:24:43','09042896865','chamilton4w@about.com','63 Buhler Way',NULL,'gG0g8dfta',NULL,'active',NULL),(180,'Antonio','Shaw','1989-12-21','2016-08-02','2016-04-02 17:08:02','09619731908','ashaw4x@stumbleupon.com','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','charper4y@altervista.org','9 Mosinee Avenue',NULL,'PHr3whh4KxI',NULL,'suspended',NULL),(182,'Eugene','Cunningham','1982-09-15','2016-08-02','2016-01-15 21:15:04','09393476162','ecunningham4z@prweb.com','25711 Blaine Place',NULL,'lbK5cXU',NULL,'suspended',NULL),(183,'Julia','Stone','1991-07-20','2016-08-02','2015-10-01 02:07:11','09962294579','jstone50@nsw.gov.au','3 Dayton Street',NULL,'00yXnZR',NULL,'active',NULL),(184,'Jerry','Lawrence','1982-10-16','2016-08-02','2015-09-10 01:42:18','09929290324','jlawrence51@shinystat.com','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','amartinez52@sun.com','27 Canary Lane',NULL,'Akg4RsIQp',NULL,'active',NULL),(186,'Jacqueline','Black','1996-10-30','2016-08-02','2016-06-03 17:56:37','09226271411','jblack53@aboutads.info','7 Drewry Hill',NULL,'fMJu337Shd',NULL,'active',NULL),(187,'Louis','Meyer','1993-03-24','2016-08-02','2016-05-31 15:00:15','09211765080','lmeyer54@wiley.com','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','aburns55@goo.ne.jp','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','hcoleman56@prnewswire.com','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','cjohnson57@chronoengine.com','61 Bay Pass',NULL,'UL56FHR3H',NULL,'active',NULL),(191,'Rachel','Patterson','1996-05-30','2016-08-02','2015-08-13 19:04:08','09494086718','rpatterson58@psu.edu','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','dchapman59@umich.edu','7 Eliot Way',NULL,'ZkjxkW',NULL,'active',NULL),(193,'Henry','Montgomery','1980-02-07','2016-08-02','2016-06-13 18:50:20','09335289726','hmontgomery5a@photobucket.com','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','iwheeler5b@123-reg.co.uk','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','jwood5c@archive.org','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','smedina5d@kickstarter.com','80 Stuart Drive',NULL,'u8d6e2e67P',NULL,'suspended',NULL),(197,'Brandon','Snyder','1980-11-16','2016-08-02','2015-11-15 21:16:25','09127762557','bsnyder5e@skype.com','43782 Sauthoff Court',NULL,'axUHv5',NULL,'suspended',NULL),(198,'Carl','Mason','1981-01-09','2016-08-02','2016-03-11 16:44:23','09244601836','cmason5f@ucoz.com','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','djackson5g@uiuc.edu','2034 Scofield Point',NULL,'LG70Ine',NULL,'active',NULL),(200,'Janice','Burton','1990-12-07','2016-08-02','2015-08-20 05:56:47','09449397720','jburton5h@mapquest.com','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','achavez5i@yandex.ru','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','bprice5j@csmonitor.com','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