· 10 years ago · Nov 19, 2015, 04:51 PM
1DROP TABLE IF EXISTS `cart`;
2
3CREATE TABLE `cart` (
4 `customer_id` varchar(255) DEFAULT NULL COMMENT 'Customer',
5 `customer_email` varchar(64) DEFAULT NULL COMMENT 'Customer',
6 `customer_fio` varchar(255) DEFAULT NULL COMMENT 'Customer',
7 `shop_id` tinyint(2) unsigned DEFAULT NULL COMMENT 'Shop Id',
8 `items` text COMMENT 'Json Cart data ID',
9 `session_id` varchar(255) NOT NULL COMMENT 'Session Id',
10 `status` tinyint(1) NOT NULL DEFAULT '0',
11 `date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
12 UNIQUE KEY `uni_customer` (`customer_id`,`customer_email`),
13 KEY `fk_shop_id` (`shop_id`),
14 CONSTRAINT `fk_shop_id` FOREIGN KEY (`shop_id`) REFERENCES `shops` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
15) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cart data';
16
17LOCK TABLES `cart` WRITE;
18/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
19
20INSERT INTO `cart` (`customer_id`, `customer_email`, `customer_fio`, `shop_id`, `items`, `session_id`, `status`, `date_update`)
21VALUES
22 ('','Voytova_anna_@mail.ru','Ðаталенко Ðнна Сергеевна',12,'[44436]','2nbiu4u0votnea4j98v79upod6',0,'2015-11-17 18:39:40'),
23 ('','Anny.1984@inbox.ru','Ðаталенко Ðнна Сергеевна',12,'[63405]','f36cl6rpfnk5pcu38fibc2f5q2',0,'2015-11-17 18:45:06'),
24 ('','Sankosiv@ukr.net','ПанаÑюк лідіÑ',12,'[62625,71708,71303]','mfhblq1uv0d1o446u0ndfg64o0',0,'2015-11-17 21:53:29'),
25 ('','Yulsheras@gmail.com','Шер Ð®Ð»Ð¸Ñ ÐлекÑандровна',12,'[78409]','h84fte4bvj122v3jv1ful04fk4',0,'2015-11-18 08:36:13'),
26 ('','andrey@di.uch.net','Голінко Ðндрій Іванович',12,'[42472]','5dm3guk5eq5jf7btm3ohi7bl97',0,'2015-11-18 09:47:53'),
27 ('','zond.zond@ukr.net','Яна',12,'[58499]','l0nroet3u2rpq32pv24ltbrrb0',0,'2015-11-18 11:09:59'),
28 ('','elena.afyan@yandex.ua','ÐÑ„Ñн Олена Яківна',12,'[47474,39318,54748,51601]','ojdq7h1eeti759k6r9b7m2c465',0,'2015-11-18 11:54:12'),
29 ('','Zabuzhan@gmail.com','Грицюк Ðндрій Іванович',12,'[74982]','6ir7hvejjhfn7mf0oq5l9nttb3',0,'2015-11-18 12:11:38'),
30 ('','380958132922@mail.ru','ÐлекÑеенко Янина Юрьевна',12,'{\"71979\":{\"M\":\"1\"}}','3rp3nl24tt6h2qovck9oi3kph6',0,'2015-11-18 13:07:35'),
31 ('','polesku@yandex.ru','шоÑтак марина',2,'{\"56070\":{\"XL\":\"1\"},\"42282\":{\"L\":\"1\"},\"55006\":{\"XL\":\"1\"},\"79544\":{\"M\":\"1\"},\"50528\":{\"XL\":\"1\"}}','vah9erkpsn19jf2ejk34mefcc5o5',0,'2015-11-18 17:47:47'),
32 ('','loralkanloralkan@outlook.com','2379115240',12,'{\"58499\":{\"M\":\"1\"}}','kbqmc6ji9phis3efrg4b3a7u05',0,'2015-11-18 15:50:12'),
33 ('371068','','',12,'{\"40501\":{\"M\":\"1\"},\"44890\":{\"M\":\"1\"},\"58137\":{\"M\":\"1\"},\"60939\":{\"M\":\"1\"},\"78238\":{\"M\":\"1\"},\"34547\":{\"XL\":\"1\"},\"48774\":{\"M\":\"1\"},\"43998\":{\"M\":\"1\"},\"63921\":{\"M\":\"1\"}}','m09oicvp9gpaevr05n7re0gsk2',0,'2015-11-18 21:25:20'),
34 ('','ankoava@ukr.net','Ðндрушко Ð’ÑчеÑлав Ðнатолійович',12,'{\"44293\":{\"L\":\"1\"},\"71113\":{\"L\":\"1\"}}','rq3p7m4a4s6nhlggrn3e5n1ir3',0,'2015-11-18 22:21:06'),
35 ('','Rasulova_71@mail.ru','Ðбдулмуталипова Патимат',2,'{\"74290\":{\"M\":\"1\"},\"79275\":{\"L\":\"1\"},\"79459\":{\"L\":\"1\"},\"71357\":{\"XL\":\"1\"},\"72039\":{\"L\":\"1\"},\"78457\":{\"L\":\"1\"},\"78459\":{\"L\":\"1\"},\"77324\":{\"S\":\"1\"},\"78899\":{\"L\":\"1\"},\"71373\":{\"M\":\"1\"},\"78916\":{\"L\":\"1\"}}','3q903bje3q8cm8qmpghui253h1',0,'2015-11-18 23:15:39'),
36 ('285365','','',12,'{\"49958\":{\"0\":\"1\"}}','cfq0tph61qk20pglc7vu7fto35',0,'2015-11-19 09:13:04'),
37 ('371134','','',12,'{\"18609\":{\"XL\":\"1\"}}','n0nks3gnlqlpe6ttkcbguo3d34',0,'2015-11-19 10:04:19'),
38 ('346012','','',12,'{\"55861\":{\"M\":\"1\"},\"65131\":{\"0\":\"3\"},\"70087\":{\"0\":\"5\"},\"70230\":{\"0\":\"4\"},\"70297\":{\"0\":\"4\"},\"70315\":{\"0\":\"4\"}}','3okrro0h1q2v91iht8q8187ca5',0,'2015-11-19 13:29:40'),
39 ('208026','','',2,'{\"73638\":{\"0\":\"1\"}}','tvdsn6n22ltb80vu1rprm78790',0,'2015-11-19 16:12:32'),
40 ('','kashteljan2@gmail.com','КаштелÑн ТетÑна Валеріївна',12,'{\"38573\":{\"M\":\"1\"}}','vlgqqk5brslrpa9tf6pc7lo1c6',0,'2015-11-19 17:05:49');
41
42/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
43UNLOCK TABLES;