YAf13YqF

1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `currencies`;
9CREATE TABLE `currencies` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
12  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
13  PRIMARY KEY (`id`),
14  UNIQUE KEY `UNIQ_37C446935E237E06` (`name`),
15  UNIQUE KEY `UNIQ_37C4469377153098` (`code`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
18INSERT INTO `currencies` (`id`, `name`, `code`) VALUES
19(1,	'euro',	'eur'),
20(2,	'usd',	'usd');
21
22DROP TABLE IF EXISTS `customers`;
23CREATE TABLE `customers` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
26  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
27  `added_at` datetime NOT NULL,
28  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
29  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
30  PRIMARY KEY (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33INSERT INTO `customers` (`id`, `name`, `phone`, `added_at`, `terrasoft_id`, `email`) VALUES
34(10,	'Jqery',	'8843712965452',	'2018-02-15 16:31:55',	NULL,	NULL),
35(11,	'Ainuro Espano',	'89274269594',	'2018-02-15 16:33:25',	'a4e2151d-cbaf-42d0-9518-381e179f8a72',	NULL),
36(12,	'Ainuro Espanq',	'89274269592',	'2018-02-15 16:34:25',	NULL,	NULL),
37(13,	'Lololshka',	'89274252693',	'2018-02-15 16:46:58',	NULL,	NULL),
38(14,	'Kostya',	'89274259594',	'2018-02-15 16:50:33',	NULL,	NULL),
39(15,	'Kostya New',	'89274259592',	'2018-02-15 16:54:10',	NULL,	NULL),
40(16,	'Kosty New lol',	'89274259593',	'2018-02-15 16:57:14',	NULL,	NULL),
41(17,	'Alquali',	'89274256954',	'2018-02-19 10:27:54',	NULL,	NULL),
42(18,	'Ainuro Espanq',	'9274269592',	'2018-02-19 11:49:43',	'ffb29692-0372-4988-92cc-9b9cf8394482',	NULL),
43(19,	'Ainur Mainur',	'89274269502',	'2018-02-19 17:13:55',	NULL,	NULL),
44(20,	'Silvestr stalone',	'89274262592',	'2018-02-19 18:00:29',	NULL,	NULL),
45(21,	'name',	'+79274269794',	'2018-02-19 18:04:32',	NULL,	NULL),
46(22,	'Bruce Wollos',	'89274262597',	'2018-02-19 18:09:20',	NULL,	NULL),
47(23,	'Bruce WollossLololss',	'89274262591',	'2018-02-19 18:22:03',	NULL,	NULL),
48(24,	'name',	'+79274269793',	'2018-02-20 11:40:42',	'0a97231c-236d-49e9-9266-cc0096869993',	NULL),
49(25,	'Test Ainur',	'89274259697',	'2018-02-20 14:20:12',	NULL,	NULL),
50(26,	'kjhagkshdflkjgh kldsdf',	'892741256395',	'2018-02-22 14:16:19',	'0cd78801-ed9c-45c0-85b1-de9d1567cbc1',	NULL),
51(27,	'Uno dos tres',	'892741256391',	'2018-02-22 14:57:39',	'f8e43163-8567-43eb-9890-4dedbd75f690',	NULL),
52(28,	'Gustav',	'9274269594',	'2018-02-27 16:04:12',	'9fdc00ca-3621-4b25-916b-5498394ddb6e',	NULL),
53(29,	'Dilod',	'89274252525',	'2018-02-27 16:07:31',	'915e5b6c-9596-42ee-80eb-60cee7162c88',	NULL),
54(30,	'Dilod2',	'89274252522',	'2018-02-27 16:08:12',	'e886fc42-9e41-45ea-b1e5-a7006f510461',	NULL),
55(31,	'Dilod3',	'89274252521',	'2018-02-27 16:08:57',	'486ebf74-8479-44d6-821a-f6a96debac9d',	NULL),
56(32,	'Ainur Ahmetgaliev',	'79274269793',	'2018-03-01 12:16:10',	'6b0b883a-e590-4be1-b621-1d1bd2e8510f',	NULL),
57(33,	'Ainur Test sec',	'89274269582',	'2018-03-01 14:00:50',	'b93e05ec-197b-479a-8716-23238efb4305',	NULL),
58(34,	'Nikola Kolinic',	'79214269594',	'2018-03-01 16:43:02',	'2f924277-c0a8-496d-b13f-1a992cce9440',	NULL),
59(35,	'Ainur Islamovich',	'79274269594',	'2018-03-02 11:21:56',	'f626389d-9303-4a7c-be4b-5328b00be5c0',	NULL);
60
61DROP TABLE IF EXISTS `customer_addresses`;
62CREATE TABLE `customer_addresses` (
63  `id` int(11) NOT NULL AUTO_INCREMENT,
64  `customer_id` int(11) DEFAULT NULL,
65  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
66  `street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
67  `building` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
68  `floor` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
69  `apartment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
70  `postal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
71  `address` longtext COLLATE utf8_unicode_ci,
72  `district` longtext COLLATE utf8_unicode_ci,
73  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
74  PRIMARY KEY (`id`),
75  KEY `IDX_C4378D0C9395C3F3` (`customer_id`),
76  CONSTRAINT `FK_C4378D0C9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE
77) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
78
79INSERT INTO `customer_addresses` (`id`, `customer_id`, `city`, `street`, `building`, `floor`, `apartment`, `postal_code`, `address`, `district`, `terrasoft_id`) VALUES
80(16,	10,	'Kazan',	'Moschito',	'2',	'',	'',	'',	' city: Kazan, street: Moschito, house-number: 2, ',	'',	NULL),
81(17,	11,	'Kazan',	'Moschito',	'2',	'',	'',	'',	' city: Kazan, street: Moschito, house-number: 2, ',	'',	NULL),
82(18,	12,	'Uno deso',	'Lolito',	'2',	'2',	'3',	'234234',	' city: Uno deso, street: Lolito, house-number: 2, district: Lololol, floor: 2, apartment: 3,index: 234234',	'Lololol',	NULL),
83(19,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
84(20,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
85(21,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
86(22,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
87(23,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
88(24,	12,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
89(25,	13,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
90(26,	13,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
91(27,	14,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
92(28,	15,	'Uno deso',	'Lolito',	'2',	'2',	'2',	'1212',	' city: Uno deso, street: Lolito, house-number: 2, district: My provice, floor: 2, apartment: 2,index: 1212',	'My provice',	NULL),
93(29,	16,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
94(30,	16,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
95(31,	17,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
96(32,	17,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
97(33,	18,	'Uno deso',	'Lolito, 3',	'4',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 4, ',	'',	NULL),
98(34,	19,	'Uno deso',	'Lolito, 3',	'4',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 4, ',	'',	NULL),
99(35,	20,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
100(36,	20,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
101(37,	21,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
102(38,	22,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
103(39,	22,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
104(40,	22,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
105(41,	21,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
106(42,	21,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
107(43,	21,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
108(44,	23,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
109(45,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
110(46,	18,	'Uno deso',	'Lolito',	'1',	'',	'3',	'234234',	' city: Uno deso, street: Lolito, house-number: 1, district: Lololol, apartment: 3,index: 234234',	'Lololol',	NULL),
111(47,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
112(48,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
113(49,	25,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
114(50,	18,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
115(51,	18,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
116(52,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
117(53,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
118(54,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
119(55,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
120(56,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
121(57,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
122(58,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
123(59,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
124(60,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
125(61,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
126(62,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
127(63,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
128(64,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
129(65,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
130(66,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
131(67,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
132(68,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
133(69,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
134(70,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
135(71,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
136(72,	18,	'Uno deso',	'Lolito, 3',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 2, ',	'',	NULL),
137(73,	18,	'Uno deso',	'Lolito, 3',	'4',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 4, ',	'',	NULL),
138(74,	18,	'Uno deso',	'Lolito, 3',	'4',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 4, ',	'',	NULL),
139(75,	18,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
140(76,	18,	'Uno deso',	'Lolito, 3',	'1',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 1, ',	'',	NULL),
141(77,	18,	'Uno deso',	'Lolito, 3',	'1',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 1, ',	'',	NULL),
142(78,	26,	'Uno deso',	'Lolito, 3',	'1',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 1, ',	'',	NULL),
143(79,	27,	'Uno deso',	'Lolito, 3',	'1',	'',	'',	'',	' city: Uno deso, street: Lolito, 3, house-number: 1, ',	'',	NULL),
144(80,	18,	'Uno deso',	'Lolito',	'2',	'',	'3',	'234234',	' city: Uno deso, street: Lolito, house-number: 2, district: Lololol, apartment: 3,index: 234234',	'Lololol',	NULL),
145(81,	18,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
146(82,	18,	'Uno deso',	'Lolito',	'2',	'',	'',	'',	' city: Uno deso, street: Lolito, house-number: 2, ',	'',	NULL),
147(83,	18,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, district: Lololol, ',	'Lololol',	NULL),
148(84,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
149(85,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
150(86,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
151(87,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
152(88,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
153(89,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
154(90,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
155(91,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
156(92,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
157(93,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
158(94,	28,	'Madrid',	'Chistpolsky',	'2',	'',	'',	'',	' city: Madrid, street: Chistpolsky, house-number: 2, district: Lololol, ',	'Lololol',	NULL),
159(95,	28,	'Madrid',	'Chistpolsky',	'2',	'',	'',	'',	' city: Madrid, street: Chistpolsky, house-number: 2, ',	'',	NULL),
160(96,	29,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
161(97,	30,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
162(98,	31,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
163(99,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
164(100,	11,	'Madrid',	'lololls',	'2',	'',	'',	'',	' city: Madrid, street: lololls, house-number: 2, ',	'',	NULL),
165(101,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
166(102,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
167(103,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
168(104,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
169(105,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
170(106,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
171(107,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
172(108,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL),
173(109,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL),
174(110,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL),
175(111,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
176(112,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL),
177(113,	18,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
178(114,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
179(115,	11,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
180(116,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
181(117,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
182(118,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
183(119,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
184(120,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
185(121,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
186(122,	24,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
187(123,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
188(124,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
189(125,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
190(126,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
191(127,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
192(128,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
193(129,	11,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, district: Lololol, ',	'Lololol',	NULL),
194(130,	33,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
195(131,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
196(132,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
197(133,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
198(134,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
199(135,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
200(136,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
201(137,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
202(138,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
203(139,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
204(140,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
205(141,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL),
206(142,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
207(143,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
208(144,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
209(145,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
210(146,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
211(147,	32,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
212(148,	11,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
213(149,	11,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
214(150,	11,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
215(151,	11,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
216(152,	34,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
217(153,	11,	'Uno deso',	'Street',	'2',	'',	'',	'',	' city: Uno deso, street: Street, house-number: 2, ',	'',	NULL),
218(154,	11,	'Uno deso',	'Street',	'2',	'',	'',	'',	' city: Uno deso, street: Street, house-number: 2, ',	'',	NULL),
219(155,	11,	'Uno deso',	'Street',	'2',	'',	'',	'',	' city: Uno deso, street: Street, house-number: 2, ',	'',	NULL),
220(156,	11,	'Uno deso',	'Street',	'2',	'',	'',	'',	' city: Uno deso, street: Street, house-number: 2, ',	'',	NULL),
221(157,	11,	'Uno deso',	'Street',	'2',	'',	'',	'',	' city: Uno deso, street: Street, house-number: 2, ',	'',	NULL),
222(158,	35,	'Madrid',	'Street',	'2',	'2',	'',	'3345345',	' city: Madrid, street: Street, house-number: 2, district: Lololol, floor: 2, index: 3345345',	'Lololol',	NULL),
223(159,	35,	'Madrid',	'Street',	'2',	'',	'',	'',	' city: Madrid, street: Street, house-number: 2, ',	'',	NULL),
224(160,	35,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
225(161,	35,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
226(162,	35,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
227(163,	35,	'',	'',	'',	'',	'',	'',	'',	'',	NULL),
228(164,	11,	'Madrid',	'Street',	'3',	'2',	'',	'',	' city: Madrid, street: Street, house-number: 3, district: Lololol, floor: 2, ',	'Lololol',	NULL),
229(165,	11,	'Madrid',	'Street',	'3',	'',	'',	'',	' city: Madrid, street: Street, house-number: 3, ',	'',	NULL);
230
231DROP TABLE IF EXISTS `delivery_methods`;
232CREATE TABLE `delivery_methods` (
233  `id` int(11) NOT NULL AUTO_INCREMENT,
234  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
235  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
236  PRIMARY KEY (`id`)
237) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
238
239INSERT INTO `delivery_methods` (`id`, `name`, `terrasoft_id`) VALUES
240(1,	'Mail',	NULL),
241(2,	'Courier',	NULL);
242
243DROP TABLE IF EXISTS `delivery_method_options`;
244CREATE TABLE `delivery_method_options` (
245  `id` int(11) NOT NULL AUTO_INCREMENT,
246  `delivery_method_id` int(11) DEFAULT NULL,
247  `language_id` int(11) DEFAULT NULL,
248  `currency_id` int(11) DEFAULT NULL,
249  `delivery_terms` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
250  `price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
251  PRIMARY KEY (`id`),
252  UNIQUE KEY `UNIQ_742A79F75DED75F5` (`delivery_method_id`),
253  KEY `IDX_742A79F782F1BAF4` (`language_id`),
254  KEY `IDX_742A79F738248176` (`currency_id`),
255  CONSTRAINT `FK_742A79F738248176` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL,
256  CONSTRAINT `FK_742A79F75DED75F5` FOREIGN KEY (`delivery_method_id`) REFERENCES `delivery_methods` (`id`) ON DELETE SET NULL,
257  CONSTRAINT `FK_742A79F782F1BAF4` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE SET NULL
258) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
259
260INSERT INTO `delivery_method_options` (`id`, `delivery_method_id`, `language_id`, `currency_id`, `delivery_terms`, `price`) VALUES
261(1,	1,	1,	1,	'7-10',	'100');
262
263DROP TABLE IF EXISTS `elements`;
264CREATE TABLE `elements` (
265  `id` int(11) NOT NULL AUTO_INCREMENT,
266  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
267  `terrasoft_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
268  PRIMARY KEY (`id`),
269  UNIQUE KEY `UNIQ_444A075D5E237E06` (`name`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
271
272INSERT INTO `elements` (`id`, `name`, `terrasoft_id`) VALUES
273(3,	'Slen 30',	'31f25706-93d2-42e9-97bc-6b9cb89070ec'),
274(4,	'Blacknetix',	'84a85f45-768b-47f7-8a77-a727c052e6e6'),
275(5,	'Fast Heater',	'83ea5a14-5fcc-4b95-9991-301ea3ceddf3'),
276(6,	'EMS Six Pack',	'c21d2bca-d63c-4382-bef4-a0bcf5b31759'),
277(7,	'Pedicure Callus Remover',	'd020a34e-4ae0-4027-9682-cdb9a1afa8c0'),
278(8,	'Zipper Socks',	'20b2bb45-53f9-4371-b28d-5768d6890126'),
279(9,	'Festive LED Light',	'38847d33-c547-481f-bb17-efcbe2304711'),
280(10,	'Dezine Pants',	'926b79b0-3945-479b-9efe-c76aedc5e2b2'),
281(11,	'V-Shape Tee',	'0406242a-370b-401f-bea6-ca51d397cd7d'),
282(12,	'Blue Passion',	'0c4b86e1-e50d-4bdc-bd44-a3cb03e2e72e'),
283(13,	'Sensual Wand',	'ac217e76-2571-49fa-a645-b4f92abf8cda');
284
285DROP TABLE IF EXISTS `images`;
286CREATE TABLE `images` (
287  `id` int(11) NOT NULL,
288  `url` text,
289  `title` text
290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
291
292
293DROP TABLE IF EXISTS `kit_items`;
294CREATE TABLE `kit_items` (
295  `id` int(11) NOT NULL AUTO_INCREMENT,
296  `product_kit_id` int(11) DEFAULT NULL,
297  `element_id` int(11) DEFAULT NULL,
298  `elementCount` int(11) NOT NULL,
299  PRIMARY KEY (`id`),
300  KEY `IDX_3558E00D58F2214B` (`product_kit_id`),
301  KEY `IDX_3558E00D1F1F2A24` (`element_id`),
302  CONSTRAINT `FK_3558E00D1F1F2A24` FOREIGN KEY (`element_id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
303  CONSTRAINT `FK_3558E00D58F2214B` FOREIGN KEY (`product_kit_id`) REFERENCES `product_kits` (`id`) ON DELETE CASCADE
304) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
305
306INSERT INTO `kit_items` (`id`, `product_kit_id`, `element_id`, `elementCount`) VALUES
307(7,	4,	3,	1),
308(8,	5,	3,	2),
309(9,	6,	3,	3),
310(10,	8,	3,	5),
311(12,	10,	4,	2);
312
313DROP TABLE IF EXISTS `landings`;
314CREATE TABLE `landings` (
315  `id` int(11) NOT NULL AUTO_INCREMENT,
316  `language_id` int(11) DEFAULT NULL,
317  `currency_id` int(11) DEFAULT NULL,
318  `product_id` int(11) DEFAULT NULL,
319  `deployed` tinyint(1) NOT NULL,
320  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
321  PRIMARY KEY (`id`),
322  KEY `IDX_763C112E82F1BAF4` (`language_id`),
323  KEY `IDX_763C112E38248176` (`currency_id`),
324  KEY `IDX_763C112E4584665A` (`product_id`),
325  CONSTRAINT `FK_763C112E38248176` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE SET NULL,
326  CONSTRAINT `FK_763C112E4584665A` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL,
327  CONSTRAINT `FK_763C112E82F1BAF4` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE SET NULL
328) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
329
330INSERT INTO `landings` (`id`, `language_id`, `currency_id`, `product_id`, `deployed`, `name`) VALUES
331(2,	2,	2,	2,	0,	'Slen 30 (XXX-en.gracestore.net)'),
332(3,	2,	1,	3,	0,	'Blacknetix (XXX-en.gracestore.net)'),
333(4,	2,	1,	4,	0,	'Fast Heater (XXX-en.gracestore.net)'),
334(5,	2,	1,	5,	0,	'EMS Six Pack (XXX-en.gracestore.net)'),
335(6,	2,	1,	6,	0,	'V-Shape Tee (XXX-en.gracestore.net)'),
336(7,	2,	1,	7,	0,	'Pedicure Callus Remover (XXX-en.gracestore.net)'),
337(8,	2,	1,	8,	0,	'Zipper Socks (XXX-en.gracestore.net)'),
338(9,	2,	1,	9,	0,	'Festive LED Light (XXX-en.gracestore.net)'),
339(10,	2,	1,	10,	0,	'Dezine Pants (XXX-en.gracestore.net)'),
340(11,	2,	1,	11,	0,	'Blue Passion (XXX-en.gracestore.net)'),
341(12,	2,	1,	12,	0,	'Sensual Wand (XXX-en.gracestore.net)'),
342(13,	2,	1,	13,	0,	'EMS Six Pack + Slen 30 (XXX-en.gracestore.net)');
343
344DROP TABLE IF EXISTS `landing_element_prices`;
345CREATE TABLE `landing_element_prices` (
346  `id` int(11) NOT NULL AUTO_INCREMENT,
347  `landing_id` int(11) DEFAULT NULL,
348  `product_kit_id` int(11) DEFAULT NULL,
349  `element_id` int(11) DEFAULT NULL,
350  `buy_price` double NOT NULL,
351  PRIMARY KEY (`id`),
352  KEY `IDX_C8364285EFD98736` (`landing_id`),
353  KEY `IDX_C836428558F2214B` (`product_kit_id`),
354  KEY `IDX_C83642851F1F2A24` (`element_id`),
355  CONSTRAINT `FK_C83642851F1F2A24` FOREIGN KEY (`element_id`) REFERENCES `elements` (`id`) ON DELETE CASCADE,
356  CONSTRAINT `FK_C836428558F2214B` FOREIGN KEY (`product_kit_id`) REFERENCES `product_kits` (`id`) ON DELETE CASCADE,
357  CONSTRAINT `FK_C8364285EFD98736` FOREIGN KEY (`landing_id`) REFERENCES `landings` (`id`) ON DELETE CASCADE
358) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
359
360INSERT INTO `landing_element_prices` (`id`, `landing_id`, `product_kit_id`, `element_id`, `buy_price`) VALUES
361(1,	2,	4,	3,	3),
362(2,	2,	4,	4,	5),
363(3,	2,	5,	3,	7);
364
365DROP TABLE IF EXISTS `landing_kit_prices`;
366CREATE TABLE `landing_kit_prices` (
367  `id` int(11) NOT NULL AUTO_INCREMENT,
368  `landing_id` int(11) DEFAULT NULL,
369  `product_kit_id` int(11) DEFAULT NULL,
370  `productKitOldPrice` double NOT NULL,
371  `productKitNewPrice` double NOT NULL,
372  PRIMARY KEY (`id`),
373  KEY `IDX_A9B0B1A2EFD98736` (`landing_id`),
374  KEY `IDX_A9B0B1A258F2214B` (`product_kit_id`),
375  CONSTRAINT `FK_A9B0B1A258F2214B` FOREIGN KEY (`product_kit_id`) REFERENCES `product_kits` (`id`) ON DELETE CASCADE,
376  CONSTRAINT `FK_A9B0B1A2EFD98736` FOREIGN KEY (`landing_id`) REFERENCES `landings` (`id`) ON DELETE CASCADE
377) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
378
379INSERT INTO `landing_kit_prices` (`id`, `landing_id`, `product_kit_id`, `productKitOldPrice`, `productKitNewPrice`) VALUES
380(5,	NULL,	4,	100,	50),
381(6,	2,	4,	5,	5),
382(7,	2,	5,	3,	4),
383(8,	2,	6,	5,	6),
384(9,	2,	8,	7,	8),
385(10,	3,	10,	40,	80);
386
387DROP TABLE IF EXISTS `languages`;
388CREATE TABLE `languages` (
389  `id` int(11) NOT NULL AUTO_INCREMENT,
390  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
391  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
392  `delivery_term` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
393  PRIMARY KEY (`id`),
394  UNIQUE KEY `UNIQ_A0D1537977153098` (`code`),
395  UNIQUE KEY `UNIQ_A0D153795E237E06` (`name`)
396) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
397
398INSERT INTO `languages` (`id`, `code`, `name`, `delivery_term`) VALUES
399(1,	'ru',	'russian',	'3-5'),
400(2,	'en',	'english',	'3-5'),
401(3,	'es',	'spain',	'3-5'),
402(4,	'pt',	'portugal',	'4-5');
403
404DROP TABLE IF EXISTS `migration_versions`;
405CREATE TABLE `migration_versions` (
406  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
407  PRIMARY KEY (`version`)
408) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
409
410INSERT INTO `migration_versions` (`version`) VALUES
411('20180129124238'),
412('20180219092432');
413
414DROP TABLE IF EXISTS `orders`;
415CREATE TABLE `orders` (
416  `id` int(11) NOT NULL AUTO_INCREMENT,
417  `landing_id` int(11) DEFAULT NULL,
418  `customer_id` int(11) DEFAULT NULL,
419  `customer_address_id` int(11) DEFAULT NULL,
420  `delivery_method_id` int(11) DEFAULT NULL,
421  `payment_method_id` int(11) DEFAULT NULL,
422  `product_kit_id` int(11) DEFAULT NULL,
423  `payment_status_id` int(11) DEFAULT NULL,
424  `order_status_id` int(11) DEFAULT NULL,
425  `created_at` datetime NOT NULL,
426  `product_kit_price` double DEFAULT NULL,
427  `product_kit_properties` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
428  `sub_id` longtext COLLATE utf8_unicode_ci,
429  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
430  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
431  `browser` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
432  `timezone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
433  `yandex_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
434  `facebook_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
435  `google_id` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
436  `ordid` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
437  PRIMARY KEY (`id`),
438  KEY `IDX_E52FFDEEEFD98736` (`landing_id`),
439  KEY `IDX_E52FFDEE9395C3F3` (`customer_id`),
440  KEY `IDX_E52FFDEE87EABF7` (`customer_address_id`),
441  KEY `IDX_E52FFDEE5DED75F5` (`delivery_method_id`),
442  KEY `IDX_E52FFDEE5AA1164F` (`payment_method_id`),
443  KEY `IDX_E52FFDEE58F2214B` (`product_kit_id`),
444  KEY `IDX_E52FFDEE28DE2F95` (`payment_status_id`),
445  KEY `IDX_E52FFDEED7707B45` (`order_status_id`),
446  CONSTRAINT `FK_E52FFDEE28DE2F95` FOREIGN KEY (`payment_status_id`) REFERENCES `payment_statuses` (`id`) ON DELETE SET NULL,
447  CONSTRAINT `FK_E52FFDEE58F2214B` FOREIGN KEY (`product_kit_id`) REFERENCES `product_kits` (`id`) ON DELETE SET NULL,
448  CONSTRAINT `FK_E52FFDEE5AA1164F` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE SET NULL,
449  CONSTRAINT `FK_E52FFDEE5DED75F5` FOREIGN KEY (`delivery_method_id`) REFERENCES `delivery_methods` (`id`) ON DELETE SET NULL,
450  CONSTRAINT `FK_E52FFDEE87EABF7` FOREIGN KEY (`customer_address_id`) REFERENCES `customer_addresses` (`id`) ON DELETE SET NULL,
451  CONSTRAINT `FK_E52FFDEE9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
452  CONSTRAINT `FK_E52FFDEED7707B45` FOREIGN KEY (`order_status_id`) REFERENCES `order_statuses` (`id`) ON DELETE SET NULL,
453  CONSTRAINT `FK_E52FFDEEEFD98736` FOREIGN KEY (`landing_id`) REFERENCES `landings` (`id`) ON DELETE SET NULL
454) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
455
456INSERT INTO `orders` (`id`, `landing_id`, `customer_id`, `customer_address_id`, `delivery_method_id`, `payment_method_id`, `product_kit_id`, `payment_status_id`, `order_status_id`, `created_at`, `product_kit_price`, `product_kit_properties`, `sub_id`, `terrasoft_id`, `ip`, `browser`, `timezone`, `yandex_id`, `facebook_id`, `google_id`, `ordid`) VALUES
457(16,	2,	10,	16,	2,	3,	5,	1,	2,	'2018-02-15 16:31:55',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
458(17,	2,	11,	17,	2,	3,	8,	1,	2,	'2018-02-15 16:33:25',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
459(18,	2,	12,	18,	2,	2,	4,	1,	2,	'2018-02-15 16:34:25',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
460(19,	2,	12,	19,	2,	3,	6,	1,	1,	'2018-02-15 16:35:36',	12,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
461(20,	2,	12,	20,	2,	3,	5,	1,	1,	'2018-02-15 16:36:40',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
462(21,	2,	12,	21,	2,	2,	6,	1,	1,	'2018-02-15 16:39:07',	6,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
463(22,	2,	12,	22,	2,	3,	6,	1,	1,	'2018-02-15 16:39:48',	12,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
464(23,	2,	12,	23,	2,	3,	8,	1,	1,	'2018-02-15 16:41:06',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
465(24,	2,	12,	24,	2,	3,	8,	1,	2,	'2018-02-15 16:43:48',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
466(25,	2,	13,	25,	NULL,	NULL,	5,	1,	2,	'2018-02-15 16:46:58',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
467(26,	2,	13,	26,	2,	2,	5,	1,	2,	'2018-02-15 16:48:17',	4,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
468(27,	2,	14,	27,	NULL,	NULL,	5,	1,	2,	'2018-02-15 16:50:33',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
469(28,	2,	15,	28,	2,	2,	8,	1,	2,	'2018-02-15 16:54:10',	8,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
470(29,	2,	16,	29,	2,	3,	8,	1,	2,	'2018-02-15 16:57:14',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
471(30,	2,	16,	30,	2,	3,	5,	1,	2,	'2018-02-15 16:59:02',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
472(31,	2,	17,	31,	2,	3,	8,	1,	2,	'2018-02-19 10:27:54',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
473(32,	2,	17,	32,	2,	3,	8,	1,	2,	'2018-02-19 10:29:25',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
474(33,	2,	18,	33,	2,	1,	8,	1,	2,	'2018-02-19 11:49:43',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
475(34,	2,	19,	34,	2,	3,	8,	1,	2,	'2018-02-19 17:13:55',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
476(35,	2,	20,	35,	2,	3,	4,	1,	2,	'2018-02-19 18:00:29',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
477(36,	2,	20,	36,	2,	3,	4,	1,	2,	'2018-02-19 18:02:30',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
478(37,	2,	21,	37,	NULL,	NULL,	4,	1,	1,	'2018-02-19 18:04:32',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
479(38,	2,	22,	38,	2,	3,	8,	1,	2,	'2018-02-19 18:09:20',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
480(39,	2,	22,	39,	2,	3,	4,	1,	2,	'2018-02-19 18:10:17',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
481(40,	2,	22,	40,	2,	3,	4,	1,	2,	'2018-02-19 18:10:54',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
482(41,	2,	21,	41,	NULL,	NULL,	4,	1,	1,	'2018-02-19 18:11:18',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
483(42,	2,	21,	42,	NULL,	NULL,	4,	1,	1,	'2018-02-19 18:17:35',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
484(43,	2,	21,	43,	NULL,	NULL,	4,	1,	1,	'2018-02-19 18:20:16',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
485(44,	2,	23,	44,	2,	3,	4,	1,	2,	'2018-02-19 18:22:03',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
486(45,	2,	11,	45,	NULL,	NULL,	4,	1,	1,	'2018-02-20 11:34:42',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
487(46,	2,	18,	46,	2,	3,	8,	1,	1,	'2018-02-20 11:38:51',	14,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
488(47,	2,	24,	47,	NULL,	NULL,	4,	1,	1,	'2018-02-20 11:40:42',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
489(48,	2,	24,	48,	NULL,	NULL,	4,	1,	1,	'2018-02-20 11:41:35',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
490(49,	2,	25,	49,	NULL,	NULL,	5,	1,	2,	'2018-02-20 14:20:12',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
491(50,	2,	18,	50,	NULL,	NULL,	5,	1,	2,	'2018-02-21 11:08:21',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
492(51,	2,	18,	51,	NULL,	NULL,	5,	1,	2,	'2018-02-21 11:09:00',	10,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
493(52,	2,	11,	52,	NULL,	NULL,	4,	1,	2,	'2018-02-21 13:57:42',	11,	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
494(53,	2,	24,	53,	NULL,	NULL,	4,	1,	1,	'2018-02-21 14:05:58',	10,	NULL,	'lolololol',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
495(54,	2,	24,	54,	NULL,	NULL,	4,	1,	1,	'2018-02-21 14:18:15',	10,	NULL,	'lolololol',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
496(55,	2,	24,	55,	NULL,	NULL,	4,	1,	1,	'2018-02-21 14:35:02',	10,	NULL,	'lolololol',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
497(56,	2,	24,	56,	NULL,	NULL,	4,	1,	1,	'2018-02-21 14:35:32',	10,	NULL,	'lolololol',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
498(57,	2,	24,	57,	NULL,	NULL,	4,	1,	1,	'2018-02-21 16:28:34',	10,	NULL,	'lolololol',	'43a8df39-f542-4694-b77a-5ac7f93dd81c',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
499(58,	2,	24,	58,	NULL,	NULL,	4,	1,	1,	'2018-02-21 16:29:39',	10,	NULL,	'lolololol',	'127.0.0.1',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
500(59,	2,	24,	59,	NULL,	NULL,	4,	1,	1,	'2018-02-21 16:35:26',	10,	NULL,	'lolololol',	'58cefa44-eab7-4aba-bcd0-075ac2bdcbe2',	'127.0.0.1',	'chrome',	NULL,	NULL,	NULL,	NULL,	NULL),
501(60,	2,	24,	60,	NULL,	NULL,	4,	1,	1,	'2018-02-21 16:36:28',	10,	NULL,	'lolololol',	'30fce89a-d844-4329-b903-e8a0490ca075',	'127.0.0.1',	'PostmanRuntime/6.3.2',	NULL,	NULL,	NULL,	NULL,	NULL),
502(61,	2,	24,	61,	NULL,	NULL,	4,	1,	1,	'2018-02-21 17:07:20',	10,	NULL,	'lolololol',	'accab552-c137-4970-92ba-659d5b0bf831',	'127.0.0.1',	'PostmanRuntime/6.3.2',	'',	NULL,	NULL,	NULL,	NULL),
503(62,	2,	24,	62,	NULL,	NULL,	4,	1,	1,	'2018-02-21 17:08:05',	10,	NULL,	'lolololol',	'0f74b9f4-26b1-4a55-97f2-2914c01d484e',	'127.0.0.1',	'PostmanRuntime/6.3.2',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
504(63,	2,	18,	63,	2,	3,	8,	1,	1,	'2018-02-21 17:22:10',	14,	NULL,	'none',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
505(64,	2,	18,	64,	2,	3,	8,	1,	1,	'2018-02-21 17:23:15',	14,	NULL,	'none',	'b71b1137-b22f-4a79-868b-fe4692627fc4',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
506(65,	2,	18,	65,	2,	3,	8,	1,	1,	'2018-02-21 17:59:26',	14,	NULL,	'none',	'779f81c0-886f-48a8-ba19-b202509e3034',	'127.0.0.1',	NULL,	NULL,	NULL,	NULL,	NULL,	NULL),
507(66,	2,	18,	66,	2,	3,	8,	1,	1,	'2018-02-21 18:01:43',	14,	NULL,	'none',	'7d8ea4d1-85ad-419d-8c47-c5cb09bf988e',	'127.0.0.1',	'Chrome',	NULL,	NULL,	NULL,	NULL,	NULL),
508(67,	2,	18,	67,	2,	3,	8,	1,	2,	'2018-02-21 18:09:05',	14,	NULL,	'none',	'f2b86598-c206-48aa-9a33-2ff2fd7dd329',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'',	NULL,	NULL,	NULL,	NULL),
509(68,	2,	18,	68,	2,	3,	8,	1,	2,	'2018-02-21 18:10:29',	14,	NULL,	'none',	'3f6ce49b-fbf1-455f-924e-702ac68793e5',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Madrid',	NULL,	NULL,	NULL,	NULL),
510(69,	2,	18,	69,	2,	3,	8,	1,	2,	'2018-02-21 18:13:04',	14,	NULL,	'none',	'5c44e2ba-7df1-4c98-aa85-a10f4e50fc75',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Madrid',	NULL,	NULL,	NULL,	NULL),
511(70,	2,	18,	70,	2,	3,	8,	1,	2,	'2018-02-21 18:14:59',	14,	NULL,	'none',	'24c91818-bdd3-44fa-9ff7-e8eb6cc01039',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
512(71,	2,	18,	71,	2,	2,	8,	1,	1,	'2018-02-21 18:15:28',	8,	NULL,	'none',	'ca04e921-8cbd-4e2d-ad67-d7f4632222ab',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
513(72,	2,	18,	72,	2,	1,	8,	1,	1,	'2018-02-21 18:16:01',	14,	NULL,	'none',	'0768cd62-084e-4c88-859f-592c927e4614',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
514(73,	2,	18,	73,	2,	3,	10,	1,	2,	'2018-02-22 11:09:46',	86,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
515(74,	2,	18,	74,	2,	3,	8,	1,	1,	'2018-02-22 11:21:21',	14,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
516(75,	2,	18,	75,	NULL,	NULL,	5,	1,	2,	'2018-02-22 12:24:30',	10,	NULL,	'',	'a18f6fe8-88f4-4e2f-964a-71aabd4c7f74',	'',	'',	'',	NULL,	NULL,	NULL,	NULL),
517(76,	2,	18,	76,	2,	3,	8,	1,	2,	'2018-02-22 14:12:47',	14,	NULL,	'none',	'eeff4791-032f-40a5-ae55-6832995fe6a7',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
518(77,	2,	18,	77,	2,	3,	8,	1,	2,	'2018-02-22 14:15:07',	14,	NULL,	'none',	'4300c03d-655d-4f6d-a1c3-076dd467b6fa',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
519(78,	2,	26,	78,	2,	3,	8,	1,	2,	'2018-02-22 14:16:19',	14,	NULL,	'none',	'850ee429-41bc-480b-82d5-05779ddcb57d',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
520(79,	2,	27,	79,	2,	3,	8,	2,	2,	'2018-02-22 14:57:39',	14,	NULL,	'none',	'a8fb1408-b050-484b-bd0d-c5677bf03946',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
521(80,	2,	18,	80,	2,	3,	5,	1,	2,	'2018-02-22 16:46:01',	10,	NULL,	'none',	'94b7e3e7-b9fe-4b64-adf7-2523d2f078b3',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
522(81,	2,	18,	81,	2,	3,	5,	1,	2,	'2018-02-22 16:55:29',	10,	NULL,	'none',	'7e16443a-6b3d-4ca5-9ffc-9720f82c1387',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
523(82,	2,	18,	82,	2,	3,	5,	2,	2,	'2018-02-22 16:57:25',	10,	NULL,	'none',	'341c2a75-4cad-4038-82bc-8eb43ee9a6a0',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
524(83,	2,	18,	83,	2,	3,	5,	2,	2,	'2018-02-26 10:20:51',	10,	NULL,	'none',	'4b37e4d1-7e54-4e2d-a133-dc101ef95e29',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
525(84,	2,	24,	84,	NULL,	NULL,	4,	1,	1,	'2018-02-27 14:46:00',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
526(85,	2,	24,	85,	NULL,	NULL,	4,	1,	1,	'2018-02-27 14:47:16',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
527(86,	2,	24,	86,	NULL,	NULL,	4,	1,	1,	'2018-02-27 14:47:18',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
528(87,	2,	24,	87,	NULL,	NULL,	4,	1,	1,	'2018-02-27 14:47:18',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
529(88,	2,	24,	88,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:20:31',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
530(89,	2,	24,	89,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:20:52',	10,	NULL,	'lolololol',	'',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
531(90,	2,	24,	90,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:49:33',	10,	NULL,	'lolololol',	'0aabc982-5362-4cfd-a6b9-91815b638479',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
532(91,	2,	24,	91,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:51:28',	10,	NULL,	'lolololol',	'c3d19b92-bd24-4a3c-b9d5-0ad50227da8f',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
533(92,	2,	24,	92,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:51:38',	10,	NULL,	'lolololol',	'fade3b5f-cc20-43bc-a09c-98f49070b066',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
534(93,	2,	24,	93,	NULL,	NULL,	4,	1,	1,	'2018-02-27 15:54:45',	10,	NULL,	'lolololol',	'7e47aa19-0664-48b6-b40d-03eece39ca06',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
535(94,	2,	28,	94,	2,	3,	6,	2,	2,	'2018-02-27 16:04:12',	12,	NULL,	'none',	'05eb9427-f172-45cf-b158-177882cb86ff',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
536(95,	2,	28,	95,	2,	3,	5,	2,	2,	'2018-02-27 16:05:37',	10,	NULL,	'none',	'd4a27d97-ea14-43f2-bdca-9aa073fe9fe4',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
537(96,	2,	29,	96,	NULL,	NULL,	4,	2,	2,	'2018-02-27 16:07:31',	11,	NULL,	'',	'a31a3af9-6d75-4523-95df-7799f8acf6c8',	'',	'',	'',	NULL,	NULL,	NULL,	NULL),
538(97,	2,	30,	97,	NULL,	NULL,	4,	2,	2,	'2018-02-27 16:08:12',	11,	NULL,	'',	'186fc711-fef4-4250-80ce-dc382694da1b',	'',	'',	'',	NULL,	NULL,	NULL,	NULL),
539(98,	2,	31,	98,	NULL,	NULL,	4,	2,	2,	'2018-02-27 16:08:57',	11,	NULL,	'',	'ddc4ba46-ebcb-4529-95b2-d88b27610202',	'',	'',	'',	NULL,	NULL,	NULL,	NULL),
540(99,	2,	24,	99,	NULL,	NULL,	4,	1,	1,	'2018-02-27 18:22:10',	10,	NULL,	'lolololol',	'3f295775-9914-47d3-9344-6204085f70ff',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
541(100,	2,	11,	100,	2,	3,	5,	1,	1,	'2018-02-28 09:52:58',	10,	NULL,	'none',	'3c5290b7-553b-46ed-a429-6ddf37c6a66b',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	NULL,	NULL,	NULL,	NULL),
542(101,	2,	24,	101,	NULL,	NULL,	4,	1,	1,	'2018-02-28 11:47:08',	10,	NULL,	'lolololol',	'c3761946-64c9-4dc7-bb15-7d8a7bb8a3d6',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
543(102,	2,	24,	102,	NULL,	NULL,	4,	1,	1,	'2018-02-28 11:47:52',	10,	NULL,	'lolololol',	'466232a9-6209-48d8-aeb4-0fb59630c61c',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
544(103,	2,	24,	103,	NULL,	NULL,	4,	1,	1,	'2018-02-28 11:49:51',	10,	NULL,	'lolololol',	'0b453d4e-d556-46b7-9305-8d1158954013',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	NULL),
545(104,	2,	24,	104,	NULL,	NULL,	4,	1,	1,	'2018-02-28 11:50:21',	10,	NULL,	'lolololol',	'004ddd94-572e-41b0-9a66-b43db1b3dbb8',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	'ORD-171'),
546(105,	2,	24,	105,	NULL,	NULL,	4,	1,	1,	'2018-02-28 11:51:44',	10,	NULL,	'lolololol',	'89b16c35-f55e-464e-b989-120a9ee66e52',	'',	'',	'Europe/Kiev',	NULL,	NULL,	NULL,	'ORD-172'),
547(106,	2,	11,	106,	NULL,	NULL,	5,	2,	2,	'2018-02-28 14:17:40',	10,	NULL,	'none',	'2e584e8d-843f-415b-924d-b811bc743497',	'',	'',	'',	NULL,	NULL,	NULL,	'ORD-176'),
548(107,	2,	11,	107,	NULL,	NULL,	5,	2,	2,	'2018-02-28 14:21:32',	10,	NULL,	'none',	'e2755f57-3212-44bf-af57-d4af7e1074cb',	'',	'',	'',	'1231241412351352t',	'efqwefqwefqwefqwefqwefqwe',	'eqwetqwegqw3egqwegqw',	'ORD-177'),
549(108,	2,	11,	108,	2,	3,	4,	2,	2,	'2018-02-28 14:23:22',	11,	NULL,	'none',	'a1cbee52-cad9-4cbf-905c-196dd3438304',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-178'),
550(109,	2,	11,	109,	2,	3,	8,	2,	2,	'2018-02-28 14:24:44',	14,	NULL,	'none',	'd17cc196-17d6-44d1-8a0c-a5431d587dd0',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-179'),
551(110,	2,	11,	110,	2,	3,	6,	2,	2,	'2018-02-28 15:04:46',	12,	NULL,	'none',	'7102d188-c3d2-4b15-a706-777ceb120c3a',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'1231241412351352t',	'efqwefqwefqwefqwefqwefqwe',	'eqwetqwegqw3egqwegqw',	'ORD-180'),
552(111,	2,	11,	111,	NULL,	NULL,	4,	2,	2,	'2018-02-28 15:10:31',	11,	NULL,	'none',	'045d5e4b-b610-4593-9c9f-904523e893d7',	'',	'',	'',	'1231241412351352t',	'efqwefqwefqwefqwefqwefqwe',	'eqwetqwegqw3egqwegqw',	'ORD-181'),
553(112,	2,	11,	112,	2,	3,	4,	2,	2,	'2018-02-28 15:12:19',	11,	NULL,	'none',	'a7a2ed1b-d883-44af-ba9f-54806d96a26c',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'1231241412351352t',	'efqwefqwefqwefqwefqwefqwe',	'eqwetqwegqw3egqwegqw',	'ORD-182'),
554(113,	2,	18,	113,	NULL,	NULL,	5,	2,	2,	'2018-02-28 15:14:24',	10,	NULL,	'lkjhaskdjghkjlashdgkjsahddkfjhaskdb',	'00cbcd69-36d5-47a8-96cc-5bb17ecb5519',	'',	'',	'',	'1231241412351352t',	'efqwefqwefqwefqwefqwefqwe',	'eqwetqwegqw3egqwegqw',	'ORD-183'),
555(114,	2,	24,	114,	NULL,	NULL,	4,	1,	1,	'2018-02-28 15:26:31',	10,	NULL,	'lolololol',	'd4d92379-b8b2-41aa-ba35-8db1edea3574',	'',	'',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-186'),
556(115,	2,	11,	115,	NULL,	NULL,	5,	2,	2,	'2018-03-01 10:16:46',	10,	NULL,	'none',	'c3d315b6-2943-4166-ba3f-4bf6f3f85019',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Madrid',	'none',	'none',	'none',	'ORD-231'),
557(116,	2,	24,	116,	NULL,	NULL,	4,	1,	1,	'2018-03-01 11:35:25',	10,	NULL,	'lolololol',	'02bb47ad-520e-42f2-9317-063bc68336fa',	'',	'',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-235'),
558(117,	2,	24,	117,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:00:38',	10,	NULL,	'lolololol',	'f5f125ed-bf4b-4a29-8a3d-6b16b764d4f0',	'',	'',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-236'),
559(118,	2,	24,	118,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:04:09',	10,	NULL,	'lolololol',	'2354650b-7e30-4328-a918-ae036f29c097',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-237'),
560(119,	2,	24,	119,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:06:34',	10,	NULL,	'lolololol',	'94a765d0-1f60-4b7d-bb4d-cfcd7c1b872a',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-238'),
561(120,	2,	24,	120,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:07:09',	10,	NULL,	'lolololol',	'de0bca92-1a1b-42d3-ae49-15f5f27a8248',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-239'),
562(121,	2,	24,	121,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:07:56',	10,	NULL,	'lolololol',	'e18a3089-125d-4600-a8f4-d1aa46c710d4',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-240'),
563(122,	2,	24,	122,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:14:10',	10,	NULL,	'lolololol',	'19db11e9-7379-488e-9b1f-d3937b739790',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-242'),
564(123,	2,	32,	123,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:16:10',	10,	NULL,	'lolololol',	'a23e12d8-28a5-4e46-b18a-004a4fbbda45',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-243'),
565(124,	2,	32,	124,	NULL,	NULL,	4,	1,	1,	'2018-03-01 12:18:49',	10,	NULL,	'lolololol',	'87ac60c4-a72a-4d29-98ac-473b0eb2b9e5',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-244'),
566(125,	2,	32,	125,	NULL,	NULL,	4,	1,	1,	'2018-03-01 13:33:45',	10,	NULL,	'lolololol',	'4eb91ed4-9c4a-4233-a6a3-af3b6a4430b2',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-245'),
567(126,	2,	32,	126,	NULL,	NULL,	4,	1,	1,	'2018-03-01 13:46:15',	10,	NULL,	'lolololol',	'Id',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-0'),
568(127,	2,	32,	127,	NULL,	NULL,	4,	1,	1,	'2018-03-01 13:53:01',	10,	NULL,	'lolololol',	'Id',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-0'),
569(128,	2,	32,	128,	NULL,	NULL,	4,	1,	1,	'2018-03-01 13:53:08',	10,	NULL,	'lolololol',	'Id',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-0'),
570(129,	2,	11,	129,	2,	3,	5,	2,	2,	'2018-03-01 13:56:03',	10,	NULL,	'none',	'Id',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-0'),
571(130,	2,	33,	130,	2,	3,	8,	2,	2,	'2018-03-01 14:00:50',	14,	NULL,	'none',	'Id',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-0'),
572(131,	2,	32,	131,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:01:43',	10,	NULL,	'lolololol',	'Id',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-0'),
573(132,	2,	32,	132,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:05:52',	10,	NULL,	'lolololol',	'Id',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-0'),
574(133,	2,	32,	133,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:20:36',	10,	NULL,	'lolololol',	'336d4ae2-589d-434f-b499-410aec22129c',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-262'),
575(134,	2,	32,	134,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:27:59',	10,	NULL,	'lolololol',	'6f99f34d-d707-463c-8514-f65be272cfaa',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-263'),
576(135,	2,	32,	135,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:29:09',	10,	NULL,	'lolololol',	'c3983b53-b42f-4ee5-961f-0e8a90b4ef48',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-264'),
577(136,	2,	32,	136,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:30:08',	10,	NULL,	'lolololol',	'2f101efc-065e-4dca-a497-7c6d3658c0d8',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-265'),
578(137,	2,	32,	137,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:34:30',	10,	NULL,	'lolololol',	'53460066-079d-4374-9a18-5756ea853d3e',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-268'),
579(138,	2,	32,	138,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:39:28',	10,	NULL,	'lolololol',	'47196104-da89-4d1e-ba59-6eb370b9c5d8',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-270'),
580(139,	2,	32,	139,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:40:36',	10,	NULL,	'lolololol',	'f0a00e98-a69a-4887-ae2e-318065bf2a5a',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-271'),
581(140,	2,	32,	140,	NULL,	NULL,	4,	1,	1,	'2018-03-01 14:41:08',	10,	NULL,	'lolololol',	'ec74ad16-5877-47c7-bb22-9a4878031637',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-272'),
582(141,	2,	11,	141,	2,	3,	5,	2,	2,	'2018-03-01 14:41:45',	10,	NULL,	'none',	'f0fa0ba3-0708-4b94-80c0-e3c96bfb3f2f',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-273'),
583(142,	2,	32,	142,	NULL,	NULL,	4,	1,	1,	'2018-03-01 15:56:45',	10,	NULL,	'lolololol',	'de372d60-2c46-4057-917d-af822b3e57cb',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-278'),
584(143,	2,	32,	143,	NULL,	NULL,	4,	1,	1,	'2018-03-01 15:59:08',	10,	NULL,	'lolololol',	'38a68afe-ba92-483a-b55f-f06bad1898d6',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-279'),
585(144,	2,	32,	144,	NULL,	NULL,	4,	1,	1,	'2018-03-01 16:00:38',	10,	NULL,	'lolololol',	'1795ee0c-3a44-4436-ada8-ef0b405d40fa',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-280'),
586(145,	2,	32,	145,	NULL,	NULL,	4,	1,	1,	'2018-03-01 16:02:10',	10,	NULL,	'lolololol',	'7c01af0a-b3a2-47e4-9e80-5cc63023a8ed',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-281'),
587(146,	2,	32,	146,	NULL,	NULL,	4,	1,	1,	'2018-03-01 16:08:25',	10,	NULL,	'lolololol',	'981ace3d-368e-46ad-8652-a81c661d4d00',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-282'),
588(147,	2,	32,	147,	NULL,	NULL,	4,	1,	1,	'2018-03-01 16:08:40',	10,	NULL,	'lolololol',	'4de80a6f-9380-44af-837b-754fb8306e4a',	'',	'Chrome',	'Europe/Kiev',	'2323234',	'asdfasdfasgdfg',	'asdfasghdsghsdf',	'ORD-283'),
589(148,	2,	11,	148,	2,	3,	6,	2,	2,	'2018-03-01 16:12:50',	12,	NULL,	'none',	'd1d81b74-26c7-4b49-a46e-b8c3e9a54795',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-284'),
590(149,	2,	11,	149,	2,	3,	6,	2,	2,	'2018-03-01 16:18:43',	12,	NULL,	'none',	'25aae557-8497-465d-852a-1df04607cc23',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-290'),
591(150,	2,	11,	150,	2,	3,	5,	2,	2,	'2018-03-01 16:19:52',	10,	NULL,	'none',	'b8f6cfa0-2998-4d09-aa2e-cc78c6e51de9',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-293'),
592(151,	2,	11,	151,	2,	2,	5,	1,	1,	'2018-03-01 16:23:03',	4,	NULL,	'none',	'4629f97a-07a8-478a-b15a-3acb3461bd65',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-300'),
593(152,	2,	34,	152,	2,	2,	6,	1,	1,	'2018-03-01 16:43:02',	6,	NULL,	'none',	'16421732-3be0-43cb-9b37-80d438f3d0ac',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-304'),
594(153,	2,	11,	153,	2,	3,	5,	1,	1,	'2018-03-01 18:36:44',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
595(154,	2,	11,	154,	2,	3,	5,	1,	1,	'2018-03-01 18:47:37',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
596(155,	2,	11,	155,	2,	3,	5,	1,	1,	'2018-03-01 18:48:02',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
597(156,	2,	11,	156,	2,	3,	8,	2,	2,	'2018-03-01 18:49:44',	14,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
598(157,	2,	11,	157,	2,	3,	5,	1,	1,	'2018-03-01 18:52:56',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
599(158,	2,	35,	158,	2,	3,	5,	1,	1,	'2018-03-02 11:21:56',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
600(159,	2,	35,	159,	2,	3,	8,	1,	1,	'2018-03-02 11:22:42',	14,	NULL,	'none',	'503d918f-64ca-4464-a99e-28d64d48742a',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-338'),
601(160,	2,	35,	160,	NULL,	NULL,	5,	2,	2,	'2018-03-02 11:51:30',	10,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
602(161,	2,	35,	161,	NULL,	NULL,	4,	2,	2,	'2018-03-02 11:53:07',	11,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
603(162,	2,	35,	162,	NULL,	NULL,	4,	1,	1,	'2018-03-02 11:53:59',	11,	NULL,	'none',	'',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	NULL),
604(163,	2,	35,	163,	NULL,	NULL,	5,	1,	1,	'2018-03-02 13:48:02',	10,	NULL,	'none',	'a1c57278-35a4-4c94-b817-f5d777a2fad3',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-348'),
605(165,	2,	11,	165,	2,	3,	5,	1,	1,	'2018-03-05 14:45:33',	10,	NULL,	'none',	'47cfedec-20b9-4422-955d-6f9aa594a9b5',	'127.0.0.1',	'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.89 Safari/537.36',	'Europe/Minsk',	'none',	'none',	'none',	'ORD-365');
606
607DROP TABLE IF EXISTS `order_statuses`;
608CREATE TABLE `order_statuses` (
609  `id` int(11) NOT NULL AUTO_INCREMENT,
610  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
611  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
612  PRIMARY KEY (`id`)
613) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
614
615INSERT INTO `order_statuses` (`id`, `name`, `terrasoft_id`) VALUES
616(1,	'created',	'1f3ad326-effd-4ac3-a3e2-957e7def3684'),
617(2,	'confirmed',	'29fa66e3-ef69-4feb-a5af-ec1de125a614'),
618(3,	'packed',	'c8742634-ea8b-46d9-ba71-1989b951772d'),
619(4,	'delivering',	'40de86ee-274d-4098-9b92-9ebdcf83d4fc'),
620(5,	'bought_out',	'8ab0f830-908b-40d7-80a3-7f49ef70ce70'),
621(6,	'canceled',	'40942857-98ab-406b-9245-1bf6dcfc0807'),
622(7,	'trashed',	'5609c313-6d13-463b-a77d-be988b927ab7');
623
624DROP TABLE IF EXISTS `pages`;
625CREATE TABLE `pages` (
626  `id` int(11) NOT NULL AUTO_INCREMENT,
627  `url` text,
628  `title` text,
629  PRIMARY KEY (`id`)
630) ENGINE=InnoDB DEFAULT CHARSET=utf8;
631
632INSERT INTO `pages` (`id`, `url`, `title`) VALUES
633(1,	'http://phphighload.com',	'PHP Highload');
634
635DROP TABLE IF EXISTS `payment_methods`;
636CREATE TABLE `payment_methods` (
637  `id` int(11) NOT NULL AUTO_INCREMENT,
638  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
639  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
640  PRIMARY KEY (`id`)
641) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
642
643INSERT INTO `payment_methods` (`id`, `name`, `terrasoft_id`) VALUES
644(1,	'stripe',	'925fff0c-1014-43ed-8bba-6d656151a47e'),
645(2,	'paypal',	'3d2416f1-e6c6-4e5d-b055-9d84e1402f80'),
646(3,	'cash',	'b90f14ee-ef13-4513-82c3-7ce44dfeccce');
647
648DROP TABLE IF EXISTS `payment_statuses`;
649CREATE TABLE `payment_statuses` (
650  `id` int(11) NOT NULL AUTO_INCREMENT,
651  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
652  `terrasoft_id` longtext COLLATE utf8_unicode_ci,
653  PRIMARY KEY (`id`)
654) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
655
656INSERT INTO `payment_statuses` (`id`, `name`, `terrasoft_id`) VALUES
657(1,	'created',	'bfe38d3d-bd57-48d7-a2d7-82435cd274ca'),
658(2,	'paid',	'4721338e-a5f1-4529-96be-d3f311518812'),
659(3,	'canceled',	'448d1338-d3a5-4fd4-9a6e-769403f89896');
660
661DROP TABLE IF EXISTS `products`;
662CREATE TABLE `products` (
663  `id` int(11) NOT NULL AUTO_INCREMENT,
664  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
665  PRIMARY KEY (`id`)
666) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
667
668INSERT INTO `products` (`id`, `name`) VALUES
669(2,	'Slen 30'),
670(3,	'Blacknetix'),
671(4,	'Fast Heater'),
672(5,	'EMS Six Pack'),
673(6,	'V-Shape Tee'),
674(7,	'Pedicure Callus Remover'),
675(8,	'Zipper Socks'),
676(9,	'Festive LED Light'),
677(10,	'Dezine Pants'),
678(11,	'Blue Passion'),
679(12,	'Sensual Wand'),
680(13,	'EMS Six Pack + Slen 30'),
681(14,	'EMS Six Pack + Dezine Pants'),
682(15,	'EMS Six Pack + Zipper socks'),
683(16,	'Dezine Pants + Slen 30');
684
685DROP TABLE IF EXISTS `product_kits`;
686CREATE TABLE `product_kits` (
687  `id` int(11) NOT NULL AUTO_INCREMENT,
688  `product_id` int(11) DEFAULT NULL,
689  `kit_type_id` int(11) DEFAULT NULL,
690  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
691  PRIMARY KEY (`id`),
692  KEY `IDX_85D2E1644584665A` (`product_id`),
693  KEY `IDX_85D2E1644CE9AF74` (`kit_type_id`),
694  CONSTRAINT `FK_85D2E1644584665A` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
695  CONSTRAINT `FK_85D2E1644CE9AF74` FOREIGN KEY (`kit_type_id`) REFERENCES `product_kit_types` (`id`) ON DELETE SET NULL
696) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
697
698INSERT INTO `product_kits` (`id`, `product_id`, `kit_type_id`, `name`) VALUES
699(4,	2,	NULL,	'Slen 30 (1 шт.)'),
700(5,	2,	NULL,	'Slen 30 (2 шт.)'),
701(6,	2,	NULL,	'Slen 30 (3 шт.)'),
702(8,	2,	NULL,	'Slen 30 (4+1 шт.)'),
703(10,	3,	NULL,	'MyBacknetix');
704
705DROP TABLE IF EXISTS `product_kit_types`;
706CREATE TABLE `product_kit_types` (
707  `id` int(11) NOT NULL AUTO_INCREMENT,
708  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
709  PRIMARY KEY (`id`),
710  UNIQUE KEY `UNIQ_E3D636FD5E237E06` (`name`)
711) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
712
713INSERT INTO `product_kit_types` (`id`, `name`) VALUES
714(1,	'Множественный'),
715(2,	'Ординарный');
716
717DROP TABLE IF EXISTS `propertys`;
718CREATE TABLE `propertys` (
719  `id` int(11) NOT NULL AUTO_INCREMENT,
720  `element_id` int(11) DEFAULT NULL,
721  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
722  PRIMARY KEY (`id`),
723  UNIQUE KEY `UNIQ_7AEEC2C45E237E06` (`name`),
724  KEY `IDX_7AEEC2C41F1F2A24` (`element_id`),
725  CONSTRAINT `FK_7AEEC2C41F1F2A24` FOREIGN KEY (`element_id`) REFERENCES `elements` (`id`) ON DELETE CASCADE
726) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
727
728
729DROP TABLE IF EXISTS `property_values`;
730CREATE TABLE `property_values` (
731  `id` int(11) NOT NULL AUTO_INCREMENT,
732  `property_id` int(11) DEFAULT NULL,
733  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
734  PRIMARY KEY (`id`),
735  KEY `IDX_44D0239A549213EC` (`property_id`),
736  CONSTRAINT `FK_44D0239A549213EC` FOREIGN KEY (`property_id`) REFERENCES `propertys` (`id`) ON DELETE CASCADE
737) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
738
739
740DROP TABLE IF EXISTS `queue`;
741CREATE TABLE `queue` (
742  `url` varchar(255) NOT NULL,
743  `type` enum('page','image') DEFAULT NULL,
744  PRIMARY KEY (`url`)
745) ENGINE=InnoDB DEFAULT CHARSET=utf8;
746
747
748DROP TABLE IF EXISTS `users`;
749CREATE TABLE `users` (
750  `id` int(11) NOT NULL AUTO_INCREMENT,
751  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
752  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
753  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
754  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
755  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
756  `telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
757  `created_at` datetime NOT NULL,
758  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
759  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
760  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:json_array)',
761  PRIMARY KEY (`id`),
762  UNIQUE KEY `UNIQ_1483A5E9E7927C74` (`email`),
763  UNIQUE KEY `UNIQ_1483A5E9F85E0677` (`username`)
764) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
765
766INSERT INTO `users` (`id`, `email`, `username`, `password`, `first_name`, `last_name`, `telephone`, `created_at`, `description`, `status`, `roles`) VALUES
767(1,	'admin@admin.ru',	'admin',	'$2y$13$QKZ.mfuEPSv0JbSuTq7QhuncN7FeDyEWBP0mp8jh8WNtQ8XvMMhEu',	NULL,	NULL,	NULL,	'2018-01-29 14:49:07',	NULL,	NULL,	'[\"ROLE_ADMIN\"]');
768
769-- 2018-03-06 07:21:12