· 8 years ago · Apr 24, 2018, 08:10 AM
1-- --------------------------------------------------------
2-- Host: 192.168.10.158
3-- Server version: 5.5.56-MariaDB - MariaDB Server
4-- Server OS: Linux
5-- HeidiSQL Version: 9.5.0.5196
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for qh_beer_shop
16CREATE DATABASE IF NOT EXISTS `qh_beer_shop` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `qh_beer_shop`;
18
19-- Dumping structure for table qh_beer_shop.orders
20CREATE TABLE IF NOT EXISTS `orders` (
21 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
22 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
23 `user_id` int(11) unsigned NOT NULL DEFAULT '0',
24 `total_price` decimal(10,2) DEFAULT NULL,
25 PRIMARY KEY (`id`),
26 KEY `FK1_users_orders` (`user_id`),
27 CONSTRAINT `FK1_users_orders` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
29
30-- Dumping data for table qh_beer_shop.orders: ~63 rows (approximately)
31/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
32INSERT INTO `orders` (`id`, `date`, `user_id`, `total_price`) VALUES
33 (16, '2018-04-17 15:22:28', 1, 2333.00),
34 (17, '2018-04-17 15:25:31', 1, 2333.00),
35 (18, '2018-04-17 15:25:38', 1, 2333.00),
36 (19, '2018-04-17 15:26:40', 1, 2333.00),
37 (20, '2018-04-17 15:26:42', 1, 2333.00),
38 (21, '2018-04-17 15:26:44', 1, 2333.00),
39 (22, '2018-04-17 15:26:44', 1, 2333.00),
40 (23, '2018-04-17 15:26:45', 1, 2333.00),
41 (24, '2018-04-17 15:26:49', 1, 2333.00),
42 (25, '2018-04-17 15:27:29', 1, 2333.00),
43 (26, '2018-04-17 15:34:43', 1, 2333.00),
44 (27, '2018-04-17 15:34:44', 1, 2333.00),
45 (28, '2018-04-17 15:39:19', 1, 2333.00),
46 (29, '2018-04-17 15:39:20', 1, 2333.00),
47 (30, '2018-04-17 15:50:22', 1, 2333.00),
48 (31, '2018-04-17 15:50:25', 1, 2333.00),
49 (32, '2018-04-17 15:51:41', 1, 2333.00),
50 (33, '2018-04-17 15:52:07', 1, 2333.00),
51 (34, '2018-04-17 15:54:51', 1, 2333.00),
52 (35, '2018-04-17 15:54:52', 1, 2333.00),
53 (36, '2018-04-17 15:59:45', 1, 2333.00),
54 (37, '2018-04-17 16:03:56', 1, 233785.00),
55 (38, '2018-04-17 16:04:31', 1, 233785.00),
56 (39, '2018-04-17 16:04:35', 1, 233785.00),
57 (40, '2018-04-17 16:04:37', 1, 233785.00),
58 (41, '2018-04-17 16:04:38', 1, 233785.00),
59 (42, '2018-04-17 16:04:39', 1, 233785.00),
60 (43, '2018-04-17 16:05:13', 1, 233785.00),
61 (44, '2018-04-17 16:17:37', 1, 6048.00),
62 (45, '2018-04-17 16:20:49', 1, 985.00),
63 (46, '2018-04-17 16:21:50', 1, 432.00),
64 (47, '2018-04-17 16:26:21', 1, 726.00),
65 (48, '2018-04-18 10:49:32', 1, 5509.00),
66 (49, '2018-04-18 12:14:29', 1, 232229.00),
67 (50, '2018-04-18 14:17:29', 1, 839.00),
68 (51, '2018-04-18 14:24:55', 1, 233394.00),
69 (52, '2018-04-18 14:28:04', 1, 233394.00),
70 (53, '2018-04-18 14:28:20', 1, 331.00),
71 (54, '2018-04-18 15:02:04', 1, 432.00),
72 (55, '2018-04-18 15:39:10', 1, 167.00),
73 (56, '2018-04-19 09:13:43', 1, 144.00),
74 (57, '2018-04-19 09:17:19', 1, 144.00),
75 (58, '2018-04-19 10:42:39', 1, 452.00),
76 (59, '2018-04-19 09:25:44', 1, 8.00),
77 (60, '2018-04-19 10:02:24', 1, 1297.36),
78 (61, '2018-04-23 05:44:41', 1, 33.98),
79 (62, '2018-04-23 06:06:39', 1, 24.92),
80 (63, '2018-04-23 06:07:37', 1, 5989.34),
81 (64, '2018-04-23 06:27:28', 1, 600.14),
82 (65, '2018-04-23 07:01:07', 1, 1.36),
83 (66, '2018-04-23 07:06:42', 1, 2.00),
84 (67, '2018-04-23 07:09:54', 1, 23.00),
85 (68, '2018-04-23 07:15:46', 1, 2.33),
86 (69, '2018-04-23 07:16:47', 1, 6.00),
87 (70, '2018-04-23 07:18:19', 1, 25311.26),
88 (71, '2018-04-23 11:56:59', 3, 4.99),
89 (72, '2018-04-23 12:34:27', 3, 3.87),
90 (73, '2018-04-23 12:35:31', 3, 40.00),
91 (74, '2018-04-23 12:35:59', 3, 26.56),
92 (75, '2018-04-23 12:36:14', 3, 10.89),
93 (76, '2018-04-23 12:51:00', 1, 24.74),
94 (77, '2018-04-23 13:52:27', 51, 1.34),
95 (78, '2018-04-23 13:52:48', 51, 14.74),
96 (79, '2018-04-24 07:39:33', 3, 4.99),
97 (80, '2018-04-24 07:53:15', 3, 4.99);
98/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
99
100-- Dumping structure for table qh_beer_shop.order_detail
101CREATE TABLE IF NOT EXISTS `order_detail` (
102 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
103 `order_id` int(11) unsigned NOT NULL DEFAULT '0',
104 `product_id` int(11) unsigned NOT NULL DEFAULT '0',
105 `price` decimal(10,2) NOT NULL DEFAULT '0.00',
106 `quantity` int(11) NOT NULL DEFAULT '0',
107 PRIMARY KEY (`id`),
108 KEY `FK1_product_id_order_detail` (`product_id`),
109 KEY `FK2_orders_order_detail` (`order_id`),
110 CONSTRAINT `FK1_product_id_order_detail` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
111 CONSTRAINT `FK2_orders_order_detail` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
112) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;
113
114-- Dumping data for table qh_beer_shop.order_detail: ~79 rows (approximately)
115/*!40000 ALTER TABLE `order_detail` DISABLE KEYS */;
116INSERT INTO `order_detail` (`id`, `order_id`, `product_id`, `price`, `quantity`) VALUES
117 (1, 28, 38, 0.00, 5),
118 (2, 29, 38, 0.00, 5),
119 (3, 30, 38, 0.00, 5),
120 (4, 31, 38, 0.00, 5),
121 (5, 32, 38, 0.00, 5),
122 (6, 33, 38, 0.00, 5),
123 (7, 34, 38, 0.00, 5),
124 (8, 35, 38, 0.00, 5),
125 (9, 38, 35, 0.00, 1),
126 (10, 38, 38, 0.00, 6),
127 (11, 38, 36, 0.00, 4),
128 (12, 39, 35, 0.00, 1),
129 (13, 39, 38, 0.00, 6),
130 (14, 39, 36, 0.00, 4),
131 (15, 40, 35, 0.00, 1),
132 (16, 40, 38, 0.00, 6),
133 (17, 40, 36, 0.00, 4),
134 (18, 41, 35, 0.00, 1),
135 (19, 41, 38, 0.00, 6),
136 (20, 41, 36, 0.00, 4),
137 (21, 42, 35, 0.00, 1),
138 (22, 42, 38, 0.00, 6),
139 (23, 42, 36, 0.00, 4),
140 (24, 43, 35, 0.00, 1),
141 (25, 43, 38, 0.00, 6),
142 (26, 43, 36, 0.00, 4),
143 (27, 44, 36, 0.00, 14),
144 (28, 45, 36, 0.00, 2),
145 (29, 45, 38, 0.00, 1),
146 (30, 46, 36, 0.00, 1),
147 (31, 47, 38, 0.00, 6),
148 (32, 48, 29, 0.00, 1),
149 (33, 48, 31, 0.00, 6),
150 (34, 48, 36, 0.00, 4),
151 (35, 49, 38, 0.00, 1),
152 (36, 49, 35, 0.00, 1),
153 (37, 49, 32, 0.00, 1),
154 (38, 49, 34, 0.00, 1),
155 (39, 50, 36, 0.00, 1),
156 (40, 50, 24, 0.00, 1),
157 (41, 50, 26, 0.00, 1),
158 (42, 50, 38, 0.00, 3),
159 (43, 52, 34, 234.00, 1),
160 (44, 52, 35, 231331.00, 1),
161 (46, 52, 36, 432.00, 5),
162 (48, 54, 36, 432.00, 1),
163 (50, 55, 25, 23.00, 1),
164 (51, 55, 38, 121.00, 1),
165 (53, 57, 24, 12.00, 12),
166 (54, 58, 38, 121.00, 1),
167 (57, 59, 84, 3.00, 2),
168 (58, 60, 69, 2.00, 1),
169 (59, 60, 70, 2.00, 1),
170 (60, 60, 71, 2.00, 1),
171 (61, 60, 72, 2.00, 1),
172 (62, 60, 73, 2.00, 1),
173 (63, 60, 75, 3.00, 1),
174 (64, 60, 77, 1.34, 3),
175 (65, 60, 78, 1.34, 1),
176 (66, 60, 80, 1.00, 1),
177 (67, 60, 83, 213.00, 6),
178 (68, 61, 92, 4.99, 1),
179 (70, 61, 72, 2.00, 12),
180 (71, 62, 64, 2.00, 1),
181 (72, 62, 75, 3.00, 1),
182 (77, 65, 91, 1.36, 1),
183 (84, 72, 86, 1.21, 1),
184 (85, 72, 89, 1.66, 1),
185 (86, 72, 88, 1.00, 1),
186 (87, 73, 19, 4.00, 10),
187 (88, 74, 89, 1.66, 16),
188 (89, 75, 86, 1.21, 9),
189 (92, 77, 93, 1.34, 1),
190 (93, 78, 93, 1.34, 11),
191 (94, 79, 92, 4.99, 1),
192 (95, 80, 92, 4.99, 1);
193/*!40000 ALTER TABLE `order_detail` ENABLE KEYS */;
194
195-- Dumping structure for table qh_beer_shop.products
196CREATE TABLE IF NOT EXISTS `products` (
197 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
198 `name` varchar(50) NOT NULL DEFAULT '0',
199 `description` text NOT NULL,
200 `price` decimal(10,2) NOT NULL DEFAULT '0.00',
201 `picture` varchar(200) NOT NULL DEFAULT '0',
202 `quantity` int(10) unsigned DEFAULT NULL,
203 `times_sold` int(10) unsigned DEFAULT '0',
204 PRIMARY KEY (`id`),
205 UNIQUE KEY `name` (`name`)
206) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
207
208-- Dumping data for table qh_beer_shop.products: ~47 rows (approximately)
209/*!40000 ALTER TABLE `products` DISABLE KEYS */;
210INSERT INTO `products` (`id`, `name`, `description`, `price`, `picture`, `quantity`, `times_sold`) VALUES
211 (2, 'Ariana', '\r\nÐриана\r\nAriana beer.BG.1.JPG\r\nСтрана на произход Флаг на Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ\r\nТип бира лагер\r\nÐлкохолно Ñъдържание 4.5 – 5.5 % об.\r\nÐ’ производÑтво от 1995 г.\r\nÐриана в ОбщомедиÑ\r\n„Ðриана“ е търговÑка марка българÑка бира, тип лагер, коÑто Ñе произвежда от пивоварната „Загорка“ÐД, гр.Стара Загора,', 1.20, '6958fd524c993b39790fc922392f10bf87f6fc0e-qh_beer111.png', 1, 0),
212 (3, 'Staropramen1', 'Ðриана е една от най-продаваните Ñветли lager бири в БългариÑ. ИÑториÑта й Ñтартира още през 1884 г. в една от първите пивоварни фабрики в Ñтраната, оÑнована от братÑта Богдан и Георги Прошек в гр. СофиÑ.', 1.00, '16edd7a01fb686c01f9c40bbee87f565d37fdd46-staropramen1.jpg', 11111111, 0),
213 (4, 'Pirinsko', 'Svejest ot planinata.', 0.33, 'b2f9b78143ca55e94b268f511975da903a46df61-heineken12 - Copy (9).jpg', 0, 0),
214 (5, 'Kamenitza', 'Да отворим Kamenitza, да ÑпаÑим мъжа.', 1.25, '49bc112c194e25aca047734d90f0f7b0f4b2dd6b-gerb-pl.jpg', 666, 0),
215 (6, 'Staropramen ', 'Staropramen е една от най-продаваните Ñветли lager бири в БългариÑ. ИÑториÑта й Ñтартира още през 1884 г. в една от първите пивоварни фабрики в Ñтраната, оÑнована от братÑта Богдан и Георги Прошек в гр. СофиÑ.', 0.99, '6958fd524c993b39790fc922392f10bf87f6fc0e-qh_beer - Copy (2) - Copy.png', 0, 0),
216 (7, 'Glarus', 'Glarus Beer', 3.50, 'dc3ce015a1f1d71c2cd8ce3355d5db465c9ba694-valerko.jpg', 10, 0),
217 (13, 'Ariana122', ' "Имаме трима топ футболиÑти, нали така? ХриÑто Стоичков, легенда и икона, абÑолютен â„–1, Ñлед това е Митко Бербатов, и поÑле Ñъм аз. Това Ñме в Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ - Стоичков, Бербо и Божинов."', 0.58, '447e965b76f67ca41a0ed7f37699af5a6a3e7601-2790-1.jpg', 10, 0),
218 (14, 'Beer1', ' Малко коте, ÑÐµÐºÑ Ð¸Ð¼Ð° ли, казвай?- ЧаÑÑ‚ от лична SMS кореÑÐ¿Ð¾Ð½Ð´ÐµÐ½Ñ†Ð¸Ñ Ñ Ð¼Ð»Ð°Ð´Ð° дама.\r\n', 2.33, 'b2f9b78143ca55e94b268f511975da903a46df61-heineken.jpg', 10, 0),
219 (17, 'Almus', ' Повече Ñе миÑли, повече Ñе размишлÑва. Ðакратко - по-зрÑл Ñъм вече. За 15 г. в Ð˜Ñ‚Ð°Ð»Ð¸Ñ Ð½Ð°ÑƒÑ‡Ð¸Ñ… много, израÑнах като мъж, а и манталитетът ми е малко италианÑки. Така ÑъзрÑÑ… и Ñтанах голÑм.', 2.33, 'b2f9b78143ca55e94b268f511975da903a46df61-heineken12.jpg', 10, 0),
220 (18, 'Beer For', 'Ðа Ð²ÑŠÐ¿Ñ€Ð¾Ñ Ð·Ð°Ñ‰Ð¾ е развÑл знамето на ÑÑŠÑедна Ð¡ÑŠÑ€Ð±Ð¸Ñ Ñлед мач на Партизан: "Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ Ñи обичам аз. Дори, миÑлÑ, че Ñамо един футболиÑÑ‚ може би има татуирано българÑкото знаме..." - гордо показва трибагреника на рамото Ñи. ', 0.58, 'b2f9b78143ca55e94b268f511975da903a46df61-heineken12 - Copy.jpg', 0, 0),
221 (19, 'Диво пиво 0.5', 'Пивоварна 359 БългариÑ, алкохол 4.5%, бутилка 500 мл - Пивоварна 359 разположена в ÑофийÑкото Ñело Мрамор. Ðефилтриран, Ñветло-кехлибарен ейл Ñ Ð½ÐµÐ¼Ñки малц Weyermann, американÑки Ñортове хмелове, произведени в Ð‘ÑŠÐ»Ð³Ð°Ñ€Ð¸Ñ Ð¸ Ð¼Ð°Ñ Ð¾Ñ‚ БелгиÑ. Диво пиво е блонд ейл - пивка, Ñ Ð»ÐµÐºÐ¾ битър и Ñух завършек. Ðефилтрирана, Ñ Ð²Ñ‚Ð¾Ñ€Ð¸Ñ‡Ð½Ð° Ñ„ÐµÑ€Ð¼ÐµÐ½Ñ‚Ð°Ñ†Ð¸Ñ Ð² бутилката. Ðе попада в категориÑта ЖИВО ПИВО /прÑÑна бира/.', 4.00, '357258d8e90f718c2cf66890d4c4310051f2c136-552-large_default.jpg', 14, 10),
222 (20, 'Glarus London Porter', 'БългариÑ, алкохол 4,6% ,бутилка 500 мл Портър (на английÑки: Porter - портиер, ноÑач) е тъмен ейл Ñ Ñ…Ð°Ñ€Ð°ÐºÑ‚ÐµÑ€ÐµÐ½ винен привкуÑ, Ñилен малцов аромат и наÑитен вкуÑ, в който едновременно приÑÑŠÑтват и ÑладоÑÑ‚ и горчивина. Въпреки широко разпроÑтранените предÑтави, портърите не винаги имат виÑоко Ñъдържание на алкохол, напр. клаÑичеÑките английÑки портъри имат алкохолно Ñъдържание не повече от 5 %. Портър е предшеÑтвеник на Ñтаут ейла - друг вид тъмен малцов ейл. Тъмно кафÑв цвÑÑ‚, рубинени отенъци, добра прозрачноÑÑ‚ и кремава пÑна.Препоръчана температура на поднаÑÑне: 7-12 градуÑа', 5.00, 'ff8ddc7bd97ff42d0b9d0d4b3f3d262312c8d9c4-4691-large_default.jpg', 4, 0),
223 (24, 'Mastika', 'mastika', 12.00, 'cd67ca27afc866d589c6acfaafb4b651606d28eb-3MBresizefdsd.jpg', 0, 0),
224 (25, 'Glarusche', 'Glarus ale', 23.00, '157bc43302874a193c2ea4409b8f750ce642b755-GGG.jpeg', 158, 0),
225 (26, 'asd', 'ads', 32.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit.png', 31, 0),
226 (27, 'dsadas', 'dsadsa', 23.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit1.png', 43, 0),
227 (28, 'eqrqr', '231ewq', 32.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit2.png', 43, 0),
228 (29, 'ewqeqw', 'rqewr', 523.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit3.png', 543, 0),
229 (30, 'ytry', 'rew', 5321.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit4.png', 21, 0),
230 (31, 'ytrtyr', 'ytryr', 543.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit5.png', 634, 0),
231 (32, 'tret', 'ytr34', 543.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit6.png', 534, 0),
232 (33, 'ityu', 'yuttyu', 436.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit7.png', 23, 0),
233 (34, 'hgfghfd', 'dh', 234.00, '0e65724c47257e641343fcac0dfbeb5ef6f4fe8b-shit8.png', 634, 0),
234 (35, 'dcasca', 'csdacasd', 231331.00, '8d622ad42aa157c6e037de80e5ee44e116d97269-sadvasv12a.jpeg', 41421, 0),
235 (36, 'vadfvq', 'vqewvwq', 432.00, '31d9c1a95be90aca2620f7d2188f2ee533480792-2131.jpg', 4321, 0),
236 (37, 'Jejka Paca', 'jejka paca', 1.00, 'ff496e7c9dcb9bf6ea8354a3c1cc25099bb3e6c0-beta.jpg', 0, 0),
237 (38, 'Glarus Porter', 'БългариÑ, алкохол 4,6% ,бутилка 500 мл Портър (на английÑки: Porter - портиер, ноÑач) е тъмен ейл Ñ Ñ…Ð°Ñ€Ð°ÐºÑ‚ÐµÑ€ÐµÐ½ винен привкуÑ, Ñилен малцов аромат и наÑитен вкуÑ, в който едновременно приÑÑŠÑтват и ÑладоÑÑ‚ и горчивина. Въпреки широко разпроÑтранените предÑтави, портърите не винаги имат виÑоко Ñъдържание на алкохол, напр. клаÑичеÑките английÑки портъри имат алкохолно Ñъдържание не повече от 5 %. Портър е предшеÑтвеник на Ñтаут ейла - друг вид тъмен малцов ейл. Тъмно кафÑв цвÑÑ‚, рубинени отенъци, добра прозрачноÑÑ‚ и кремава пÑна.Препоръчана температура на поднаÑÑне: 7-12 градуÑа\r\n\r\n', 121.00, '8d622ad42aa157c6e037de80e5ee44e116d97269-eqweqw3421.jpeg', 1230, 0),
238 (40, 'DDDDDDDDD', 'DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD', 331.00, '5e08f4351337f9338d9b1b8a0630af73ee58d2d5-343434.jpg', 12, 0),
239 (43, 'pLOVEdiv4', 'Пловдив майна', 2.00, 'd6f97f3606a4b47048f8804fdb084a82943ecbac-18.png', 18, 0),
240 (44, 'pLOVEdiv5', 'Пловдив майна', 2.00, '2db1b9963f14b4edf74f4c612e89fdcb5da3bfee-66.png', 18, 0),
241 (45, 'pLOVEdiv6', 'Пловдив майна', 2.00, 'c6626a1a1f3f3580dc5a5f4e9913b9e846f36d4a-41.png', 18, 0),
242 (46, 'pLOVEdiv8', 'Пловдив майна', 2.00, '713327e93d831fcd9a829633f4422d8859ba8431-70.png', 18, 0),
243 (47, 'pLOVEdiv9', 'Пловдив майна', 2.00, '28f87d1b5a72a0f303f5a4556ee413c086b2e197-49.png', 18, 0),
244 (48, 'pLOVEdiv10', 'Пловдив майна', 2.00, '7165b4679b90ffd40e3d16a60d3a41373b68aa76-23.png', 18, 0),
245 (49, 'pLOVEdiv11', 'Пловдив майна', 2.00, '6fee9569154ea4a0c6db51a319ab157165e0cbee-52.png', 18, 0),
246 (50, 'pLOVEdiv12', 'Пловдив майна', 2.00, 'd9de9096a29316ac3e7ed8d144cae1db687fd5a7-22.png', 18, 0),
247 (51, 'GoldenPrague', 'Prague\'s best', 4.99, '25a50ecb106cd9cf09c4802a6e278b0ed4d2cb91-60.png', 799, 0),
248 (52, 'Manchester1912', '“КоÑтенурката е животно, което живее на земÑта. ÐÑма как да живееш по-близо до земÑта, без да Ñе заровиш в неÑ. Хоризонтът й обхваща една Ð¿ÐµÐ´Ñ Ð¾Ñ‚ околноÑтта. И пъргавината й Ñтига да Ñи хване нÑÐºÐ¾Ñ Ð¼Ð°Ñ€ÑƒÐ»Ñ. ОцелÑла е, докато еволюциÑта преминавала покрай неÑ, защото не е заплаха за никого и е трудничко да Ñ Ð¸Ð·Ñдеш. Ето го и орела. Създание на въздуха и виÑините, чийто хоризонт Ñе проÑтира чак до ръба на Ñвета. Зрението му е толкова оÑтро, че може да забележи шмугването на нÑкое дребно пиÑукащо животинче от цÑл километър. ЦелиÑÑ‚ е Ñила и влаÑÑ‚. Светкавична Ñмърт Ñ ÐºÑ€Ð¸Ð»Ðµ. Ðоктите му Ñа такива, че да превърне в оÑновно ÑÑтие вÑичко, по-малко от ÑÐ°Ð¼Ð¸Ñ Ð½ÐµÐ³Ð¾ и поне да Ñи откъÑне набързо мръвка от вÑÑко по-голÑмо Ñъздание. Орелът обаче е ÑпоÑобен да Ñеди Ñ Ñ‡Ð°Ñове върху нÑкой зъбер и да оглежда царÑтвата земни, докато не забележи движение нÑкъде далеч, и тогава започва да Ñе ÑÑŠÑредоточава, и още, и още върху малката черупка, коÑто Ñе тътри в храÑталака долу, в пуÑтинÑта. ÐÐ°ÐºÑ€Ð°Ñ Ð¾Ñ‚Ñкача… И Ñл', 1.34, '09e59d1b8e7d5015eb88c5aca8057ffcf19e2479-24.png', 135, 0),
249 (53, '1pLOVEdiv3', 'Пловдив майна', 2.00, '4fb896118d0c23ea9851626e43f120df0fb97b67-36.png', 18, 0),
250 (54, '1pLOVEdiv6', 'Пловдив', 2.00, '11c18f9b60450715f8f83b167fd74e0fd761387b-54.png', 18, 0),
251 (55, '1pLOVEdiv7', 'Пловдив', 2.00, 'b2f0e4f7bbd141bc90a2635f6f67b73ce3771bca-69.png', 18, 0),
252 (56, '1pLOVEdiv10', 'Пловдив Ñтолица на културата', 2.00, 'd09f5662b8798f426faa7f241a788972bd6e2491-20.png', 18, 0),
253 (57, '1pLOVEdiv11', 'Пловдив Ñтолица на културата', 2.00, '4e6d1eeeb575ddf7a398a85f968ebb16375f4919-61.png', 18, 0),
254 (58, 'GoldenPrague33', 'Prague\'s best', 4.99, '6fee9569154ea4a0c6db51a319ab157165e0cbee-124.png', 799, 0),
255 (60, 'LOMdom', 'ekyL8dUXbh lCIYBht2o5 A4P6bbeC6q OLbYKCSlvo W73pT0Hn1b QRfMcXfU3a kGF92QHm7I IpnBoiaVSJ “КоÑтенурката е животно, което живее на земÑта. ÐÑма как да живееш по-близо до земÑта, без да Ñе заровиш в неÑ. Хоризонтът й обхваща една Ð¿ÐµÐ´Ñ Ð¾Ñ‚ околноÑтта. И пъргавината й Ñтига да Ñи хване нÑÐºÐ¾Ñ Ð¼Ð°Ñ€ÑƒÐ»Ñ. ОцелÑла е, докато еволюциÑта преминавала покрай неÑ, защото не е заплаха за никого и е трудничко да Ñ Ð¸Ð·Ñдеш. Ето го и орела. Създание на въздуха и виÑините, чийто хоризонт Ñе проÑтира чак до ръба на Ñвета. Зрението му е толкова оÑтро, че може да забележи шмугването на нÑкое дребно пиÑукащо животинче от цÑл километър. ЦелиÑÑ‚ е Ñила и влаÑÑ‚. Светкавична Ñмърт Ñ ÐºÑ€Ð¸Ð»Ðµ. Ðоктите му Ñа такива, че да превърне в оÑновно ÑÑтие вÑичко, по-малко от ÑÐ°Ð¼Ð¸Ñ Ð½ÐµÐ³Ð¾ и поне да Ñи откъÑне набързо мръвка от вÑÑко по-голÑмо Ñъздание. Орелът обаче е ÑпоÑобен да Ñеди Ñ Ñ‡Ð°Ñове върху нÑкой зъбер и да оглежда царÑтвата земни, докато не забележи движение нÑкъде далеч, и тогава започва да Ñе ÑÑŠÑредоточава, и още, и ', 1.34, '7165b4679b90ffd40e3d16a60d3a41373b68aa76-95.png', 12, 0),
256 (61, '2pLOVEdiv', 'Пловдив майна †° ›››››››', 2.00, '0d985534d75f2c43158dc0670ac579738cf8fc63-151.png', 18, 0),
257 (62, '11pLOVEdiv1', 'Пловдив майна', 2.00, '2db1b9963f14b4edf74f4c612e89fdcb5da3bfee-139.png', 18, 0),
258 (63, '11pLOVEdiv2', 'alert(123)', 2.00, 'c6626a1a1f3f3580dc5a5f4e9913b9e846f36d4a-113.png', 18, 0),
259 (64, '11pLOVEdiv3', 'Пловдив майна', 2.00, 'ced3e334ef3e56a8fac7a78297893cf2ec881691-115.png', 17, 1),
260 (65, '11pLOVEdiv4', 'Пловдив майна', 2.00, '7ea8fb8f5371395d01bf5d65b9586a119384d777-130.png', 18, 0),
261 (66, '11pLOVEdiv5', 'Пловдив майна', 2.00, '9c09bd53f9b0a284cb51161c53649442a2803e13-135.png', 18, 0),
262 (67, '11pLOVEdiv6', 'Пловдив', 2.00, 'c1f8af35f0b7f2b06ed49b8e0312c43b544bf88e-107.png', 18, 0),
263 (68, '11pLOVEdiv7', 'Пловдив', 2.00, 'df1e74d7084b50d51114658e67cf25c42f03ff37-118.png', 18, 0),
264 (69, '11pLOVEdiv8', 'Пловдив', 2.00, '8ead2e3d60430249d8121bc7e66b84a747df862b-106.png', 17, 0),
265 (70, '11pLOVEdiv9', 'Пловдив Ñтолица на културата', 2.00, 'c71ef3c754ce34321e9c15379ca2ab473e068c4d-102.png', 17, 0),
266 (71, '11pLOVEdiv10', 'Пловдив Ñтолица на културата', 2.00, 'a121e42605fbf1fd9629bbaac541279a40fb1d08-136.png', 17, 0),
267 (72, '11pLOVEdiv11', 'Пловдив Ñтолица на културата', 2.00, 'f23e2dfcdfb9545c3f1c8698cfbc8161e80347fe-145.png', 5, 12),
268 (73, '11pLOVEdiv12', 'Пловдив Ñтолица на културата', 2.00, '50a016b7de11ce23210c8c43818a045859d30236-110.png', 17, 0),
269 (75, 'NEW Proba', 'D\r\nD\r\nD\r\nD\r\nD\r\nD\r\nDDDDDDDDDDDDDDDDDDDDDDDDDDDD\r\nD\r\nD\r\nD\r\nDDDDDDDDDDDD\r\nSSSSSSSSSSS\r\n\r\nDDDDDDDDDDDDDDDDDDDDDDDD\r\nD\r\nD\r\nD\r\n\r\nD\r\nDDDDDDDDDDDDDDDD\r\nSS\r\nS\r\nSSSSSSSSSSSSSSSSS\r\nA\r\nAAAAAAAAAAAAAAAAA\r\nAAAAAAAAAA\r\nAAAAAAAAAAAAA\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nAAAAAAAAAAAAAAAAAAAAA\r\nA\r\nA\r\nA\r\nA\r\nA\r\nAAAAAAAAAAAAAAAAAAAAAA\r\nA\r\nA\r\nAAAAAAAAAAAAAAAAAAA\r\nAAAAAAAAAAAAAAAAAA\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\r\n\r\n\r\nAAA', 3.00, '49bc112c194e25aca047734d90f0f7b0f4b2dd6b-156.png', 0, 1),
270 (77, 'Mancheste2r1912', 'ÑтеÑÑ‚Ð²ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð´Ð±Ð¾Ñ€. Един ден нÑÐºÐ¾Ñ ÐºÐ¾Ñтенурка ще Ñе научи да лети…â€', 1.34, '42bec68679c27b183eab33f42ae3bcb4612d1f27-93.png', 132, 0),
271 (78, 'LOMdom3', 'запче от цÑл кио-малко от Ñамии ÑÑ‚ коÑтенуркитенурка ще Ñе научи да лети…â€', 1.34, '30bc5e8e19de2cf8ec734d82f504fc97238ecdf7-120.png', 11, 0),
272 (79, 'ПлевенÑко', 'ÑтеÑÑ‚Ð²ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð´Ð±Ð¾Ñ€. Един ден нÑÐºÐ¾Ñ ÐºÐ¾Ñтенурка ще Ñе научи да лети…â€', 1.34, 'eabd8da3577fafd4f14d22de1cb6a7b7c646432b-125.png', 135, 0),
273 (80, 'EDIT', 'EDIT', 1.00, '6429e34d68454fe437e6a6d426b5a968804300a8-91.png', 0, 0),
274 (83, 'Mlado Pivo', 'vqewvwq', 213.00, '3eaf39be44cc03d3508afbd9c8a5cee90978489f-bfadasb.jpg', 15, 0),
275 (84, 'Heinekennnn', 'qwqw', 3.00, '3eaf39be44cc03d3508afbd9c8a5cee90978489f-va432432.jpg', 10, 0),
276 (85, 'Astika', '"Човек Ñамо когато знае к\'во му е, Ñамо аз Ñи знам к\'во ми е" - коментар пред медии отноÑно това колко му е тежко, че не е в Ð½Ð°Ñ†Ð¸Ð¾Ð½Ð°Ð»Ð½Ð¸Ñ Ð¾Ñ‚Ð±Ð¾Ñ€ по футбол.', 5.00, 'e56080adb50338dd4f245b7b066a921cb68037a9-images33.jpg', 5, 0),
277 (86, 'test beer baby', '"Да треперÑÑ‚ Тони Ðайка, Иконата, ÐÑенчо ТакÑито, Влади Гаджев, вÑички да треперÑÑ‚. ТРЕПÐИИИИ! Тони Ðайкаааа, Трепнииии, ТРЕПЕРИИИИ..."', 1.21, '4c956c49edb652b5d8be61f67a351b5869465173-2222wq2q11q1w1weqqewwqweqw2eqwewea.jpg', 2, 10),
278 (87, 'Zagorka Retro', '„Ðз не хареÑвам да идвам отзад, защото отзад е отзад. Имам нужда да миÑÐ»Ñ Ð² отпред" (Ð’ оригинал на английÑки: "I don\'t like to Ñome behind because behind is behind, I need to think in the front") - по време на преÑÐºÐ¾Ð½Ñ„ÐµÑ€ÐµÐ½Ñ†Ð¸Ñ Ð½Ð° английÑки език. ', 2.55, '4c956c49edb652b5d8be61f67a351b5869465173-222ww2wq2q11q1w21weqqewwqweqw2eqwewea.jpg', 2, 0),
279 (88, 'OG of the dead', '"ЧеÑтно да Ñи признаÑ, ÑъжалÑвам, че не Ñъм Ñе родил в СърбиÑ. Толкова Ñъм отвратен от българите. Ðие идваме в Ð¡ÑŠÑ€Ð±Ð¸Ñ Ð¸ хората ни ноÑÑÑ‚ на ръце. Ðе ни дават да плащаме Ñметките в реÑторантите и кафетата. Ру наÑ! Болно и жално ми е, че Ñа такива българите."', 1.00, '03837173faa2744658e4c6f50aabfe2493202b70-ci-miller-lite-0d8edf99a266re6436.jpeg', 249, 1),
280 (89, 'Zagorka Special', '"ЗвънÑÑ… на един човек, който има един Ñайт. ÐÑма да говорÑ. И му викам.... Има Ñигурно 10 новини, има пет новини за мене. И му звънÑ, викам, човек, добре, викам, какво Ñ‚Ñ€Ñбва да направÑ, викам, за да Ñпреш, викам, незавиÑимо дали е, викам, то е Ñамо негативно, викам. Ðйде, аз, не ме интереÑува, викам, ти Ñамо негативни неща пишеш. Викам, нещо Ñ‚Ñ€Ñбва да Ð½Ð°Ð¿Ñ€Ð°Ð²Ñ Ð»Ð¸? Викам, кажи!"', 1.66, '8d622ad42aa157c6e037de80e5ee44e116d97269-1.jpeg', 116, 17),
281 (91, 'Zzz', 'lagagaglal', 1.36, '7ea8fb8f5371395d01bf5d65b9586a119384d777-57.png', 12, 1),
282 (92, 'Golden Prague', 'Prague\'s best', 4.99, 'df1e74d7084b50d51114658e67cf25c42f03ff37-46.png', 796, 3),
283 (93, 'London', 'ekyL8dUXbh lCIYBht2o5 A4P6bbeC6q OLbYKCSlvo W73pT0Hn1b QRfMcXfU3a kGF92QHm7I IpnBoiaVSJ', 1.34, '829861eba51762418177b6c0e05e977a08015b74-50.png', 0, 12);
284/*!40000 ALTER TABLE `products` ENABLE KEYS */;
285
286-- Dumping structure for table qh_beer_shop.users
287CREATE TABLE IF NOT EXISTS `users` (
288 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
289 `username` varchar(50) NOT NULL DEFAULT '0',
290 `password` varchar(255) NOT NULL DEFAULT '0',
291 `email` varchar(50) NOT NULL DEFAULT '0',
292 `phone` varchar(50) NOT NULL DEFAULT '0',
293 `address` varchar(50) NOT NULL DEFAULT '0',
294 `first_name` varchar(50) NOT NULL DEFAULT '0',
295 `last_name` varchar(50) NOT NULL DEFAULT '0',
296 `age` int(10) unsigned NOT NULL,
297 `picture` varchar(200) DEFAULT NULL,
298 `wallet` decimal(10,2) unsigned DEFAULT '0.00',
299 `info` text,
300 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
301 PRIMARY KEY (`id`),
302 UNIQUE KEY `username` (`username`),
303 UNIQUE KEY `email` (`email`)
304) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8;
305
306-- Dumping data for table qh_beer_shop.users: ~74 rows (approximately)
307/*!40000 ALTER TABLE `users` DISABLE KEYS */;
308INSERT INTO `users` (`id`, `username`, `password`, `email`, `phone`, `address`, `first_name`, `last_name`, `age`, `picture`, `wallet`, `info`, `date`) VALUES
309 (1, 'gosho123', '$2y$12$tqjR.aKJwzr/Vne.ZsXiauCh9CRHYFGpRZmfIwrmVNnOoYSjlsWaW', 'dasdas@ab.nh', '1212212121', 'ewqewq', 'dasdas', 'dasdas', 654, '3eaf39be44cc03d3508afbd9c8a5cee90978489f-ewq.jpg', 231.26, NULL, NULL),
310 (2, 'gosho12', '$2y$10$gDPhGh5pv6Q4LEeC8NVTi.9XY5Rc2VP3h8jojqnEbgZBAumz8wSyW', 'sdasde@bab.nh', '1212121212', 'wqeqwe', 'dsasda', 'das', 1223, NULL, 0.00, NULL, NULL),
311 (3, 'admin', '$2y$10$aEh7Wuc/F61oU/pncIA6kO03MlSa7kesSghz82pF8fLUSwLR7.LGO', 'dasdasq23@avac.bg', '1212121212', 'dwav', 'admin', 'adminov', 1290, '07cf8d2ca9eacdc6c53a059c09380049794c4637-dasdas.png', 3.71, NULL, NULL),
312 (4, 'gosho234', '$2y$10$DdEIb93BLkB6InWeUMk3quQ0hyjIFLROGrd21a73iF9Yt2usC2D6u', 'goshovec@abv.bg', '1221212122', 'adsa', 'goshovec', 'goshovec', 4903, '8d622ad42aa157c6e037de80e5ee44e116d97269-ci-corona-extra-17ddab5e602499d2.jpeg', 0.00, NULL, NULL),
313 (5, '0', '0', '0', '0', '0', '0', '0', 0, '68c0760d7c067221830c2df1e7b65a0093b3d40c-download.jpg', 0.00, NULL, NULL),
314 (51, 'toshko', '$2y$10$i6ztsPifDjUCK99IT7E1UOZ1Jv1KmLeMOBDOLqLsmnRxX29EG.iqu', 'ice_soul@abv.bg', '1231231232', 'Sofiq, Mladost 1', 'Todor', 'Plamenov', 23, '6f05a41f1723e09f13088c14be4c2dbba3f6046d-dogma-svetionik-350x350.jpg', 21326.92, NULL, '0000-00-00 00:00:00'),
315 (53, 'mnstrBer', '$2y$10$9n07ZNJuNSp6MD5hO9TAF./GbPygeS5oK4NGgl5yByPLbPcfov2Pi', 'rkolev@qualityhouse.com', '890901912', 'úрøòð ÿðûðýúð 11', 'Ivan', 'Mihaylov', 19, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
316 (54, 'POOP', '$2y$10$yszU0L5HIHLo6JmZgkYgH.lRsdmTX9WjHucZGPw.S/rocn/TjVe2O', 'as11161@a0ds1112.a101', '1234567890', '†', 'image', 'image', 18, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
317 (55, 'toshko12', '$2y$10$XWbuK5o5He1wz7KuW/XR.uS/uqT34PaAZEC6MT2kTRmodOUM8fcsm', 'asd@asd.bg', '1231231232', 'Sofiq, Mladost 1', 'Todor', 'Toshev', 23, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
318 (57, 'ooor', '$2y$10$NGz03IxeSSFn.JlEGmxpuub3uw.hmEGCrlFKTcuTA0GYgDZBEHfUa', 'jfah@fja.dk', '987654321', 'kljhgft', 'oeprt', 'ohsfhia', 18, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
319 (58, 'vliskova', '$2y$10$2JD81LtakU60oCHVAT7BueX1Yhi1jY2idT/BEhY0Z1gJu5SBQxioi', 'vliskova@abv.bg', '884488708', 'bla', 'Vasilena', 'Liskova', 21, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
320 (60, 'gosho321', '$2y$10$5zbVoggx6vzJOzX2RsDWTeev0RgRJmYZ4wZeGQQVUTKOGohimUK7K', 'asddsa@asd.bg', '2112121221', 'vbe', 'gosho', 'goshov', 31, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
321 (61, 'Pook', '$2y$10$aiN2jy.8p9pAbeJya.l3nOgewmaLE.UgnVfQOOwfmNR2ElY8LX9nS', 'sadStorry@bRA.bg', '123456789', 'Germany, Würzburg, Heidingsfeld, Eisenbahnstraße', 'Shliokavici', 'Bot', 18, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
322 (62, 'PoRok', '$2y$10$vSZ69xHH86hxvGWno97FZ.S3V8wh.jVhfSxv7cQ0Wkt1Ukafxgogi', 'sad@bRA.bg', '123456789', 'Germany, Würzburg, Heidingsfeld, Eisenbahnstraße', 'Shliokavici', 'Bot', 20, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
323 (63, 'stako', '$2y$10$kQyFTVaECTa1WInffYzVLOOizC9onJjWoNf1oYhnrqPXIlfR1n/rm', 'st@st.com', '1234567899', 'Шевченко', 'Stako', 'Stakov', 28, 'c32e0ec130bab873c774c24d252093dcbbde4439-heineken_0001.jpg', 0.00, NULL, '0000-00-00 00:00:00'),
324 (64, 'Ñтако1', '$2y$10$4/PtJUIlFT5Fe0p/C1DSI.YmYtF2LJhLSAd20aEGM/Podpxw7mAO2', 'st1@st.com', '1234567899', 'Шева', 'Стако', 'Стаков', 18, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
325 (65, 'Ñтако02', '$2y$10$fTPrjPPQYZGG/lhza7lybOlJNLxfy8zM75hX2L3vw5zsOk13aLsL.', 'st2@st.com', '1234567890', 'Тери5', 'Стако', 'Stakov', 19, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
326 (66, 'bultraSS', '$2y$10$TCAXT5i1KHPHaQCameJeKeAttds99zcCtwpadWGTM6Ja9Q7SbF0ne', 'OmgxOrpx@gmail.com', '888888765', 'ÐÐ¾Ñ Ð´Ð¾Ð±Ñ€Ð° надежда', 'Hristo', 'Orphan', 60, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
327 (67, 'Pencho', '$2y$10$niZ8Wuvc0KoL34Eocm6d8ugl4N0H8Odh9GpMFjx5mrV.6C/oQpqzi', 'asdf12@abv.gb', '1234567891', 'Sofia 1000', 'Pencho', 'Penchev', 19, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
328 (68, 'ivan12', '$2y$10$gSTUmfp/ceZskwK9Iz7Rq.KDi4PXcQBDU4FTmhDBhb75L/stmaYBa', 'ivan@ivan.ivan', '1111111111', 'dfhxs', 'ivan', 'ivanov', 44, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
329 (69, 'ivan11', '$2y$10$T259mzRNSeCEp2P1t9stAeQA0Bfry9iPLcmZ/uJheMVyJnWeLejXC', 'daaade@abv.dg', '4294967295', 'dfhxs', 'f', 'f', 4294967295, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
330 (70, 'dbtadet', '$2y$10$FiVFwTbut0BNgrLazdbvBuaZHihGybsNyB0izt8pHaJjLde45Na7W', 'afaf@mfam.fawfa', '1111111111', '44', 'g', 'g', 44, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
331 (71, 'sexyKote', '$2y$10$wJUv.Eevhcuyy/EGh67nBO7AOMoqhYt81QjH15bdyeLnMVT76nQSi', 'sexy_kote@test.te', '1231231232', 'Sexy Landya', 'Sexy', 'Kote', 22, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
332 (72, 'pl0x0r', '$2y$10$yHnQcwwfkiGFJZPKwMv/WOW3nMvs59WwI.1L8.AfFkp1nKwvq9phq', 'djepeto@gmail.com', '1234567899', 'Spain,Barcelona, Catalonia', 'Gabriel', 'Hernandes', 22, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
333 (73, 'djMiro', '$2y$10$DFeNTXGz.kh6WntIEfVth./Zf7fbqBqC6948ulZy3ntuMPFERWWh6', 'miro.pianoto@gmail.com', '1424234234', 'Рим', 'Miroslav', 'Pianoto', 21, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
334 (74, 'pesho', '$2y$10$4n/ahIC/Ydyj0eF8My2VlOOsh7Rc1LlgYSK1JXpTlR0dP0y/Zfgta', 'flameboy18@abv.bg', '3345566331', 'jk.Ivan Vazov', 'Petar', 'Alaibaba', 33, 'dc3ce015a1f1d71c2cd8ce3355d5db465c9ba694-valerko - Copy (3).jpg', 61.00, NULL, '0000-00-00 00:00:00'),
335 (75, 'ivan1980', '$2y$10$UKWKPnOijOywCKylH1QNlOYkSAiUOvZvZICYpKLJUF13YLr2Vx5ou', 'ivan1980@test.te', '4294967295', 'Sofia', 'Ivan', 'Petrov', 45, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
336 (76, 'TupTupak', '$2y$10$O2AK2TTzb4SlkVd7S9kKEOA1PAVCLz5RJyDlk3YJutSUPOAmyJcam', 'Tup@kov.indeed', '0', 'ul. "Balsha" 1 1408 Ivan Vazov, Sofia Bulgaria', 'Tup', 'Tupakov', 4294967295, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
337 (77, 'gago', '$2y$10$fRgKzynfQPZGDBiY48IgD.vDTt4mtLgrYv/SQIbDxALj1c3csa6Ge', 'blae@bla.come', '0', 'ul. "Balsha" 1 1408 Ivan Vazov, Sofia Bulgaria', 'G', 'G', 5555556, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
338 (78, 'user1', '$2y$10$.J49mqhrAvi1JcdTlhQwzeqP6j7bxFvqf05RSgT6xbxJSBxb8lfbW', 'afaf@mfam.f88', '9999', 'dfhxs', 'a', 'a', 18, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
339 (79, 'Bruice', '$2y$10$g5N0GCpa2ICL5K9LYzlyPeDLcoIDdu/SfX4biCKQqZQFpKHfobCrK', 'bruice@abc.bg', '1231231231', 'Sofiq, МладоÑÑ‚', 'Bruice', 'Dickinson', 32, NULL, 0.00, NULL, '0000-00-00 00:00:00'),
340 (80, 'newUser', '$2y$10$G5rqDC6FlBnDImGDQ0sp8ufcwRnaIUJYfd7cpX7VF6RpN9Lts81FO', 'new@user.bg', '4294967295', 'fff', 'new', 'user', 18, NULL, 0.00, NULL, '2018-03-30 11:21:37'),
341 (81, 'kote69', '$2y$10$bXCAhqC4dCaTEt3cRW7XrOS9EeLa.IhQJf9dgE1xSkj8llbkZ6M/e', 'malko@kote.bg', '9999999999', 'СофиÑ, БългариÑ', 'malko', 'kote', 32, NULL, 0.00, NULL, '2018-03-30 11:23:57'),
342 (82, 'vers', '$2y$10$HjYeqk/veDYMjTcN3TWeTe2n/.D9acxHEVHIGGdiKmPDmg3XNS0hi', 'fdiv98o@ivo.bg', '0', '000000000000', 'sss', 'asd', 4294967295, NULL, 0.00, NULL, '2018-03-30 13:26:45'),
343 (84, 'fery', '$2y$10$iX9kiPkPu.g8jf7C9gKo0emKcSBGYmjsVSxPDapOFn6UYU4jtzS8e', 'admin123@abv.bg', '0052005200', 'ul. "Balsha" 1 1408 Ivan Vazov, Sofia Bulgaria', 'awe', 'ddddd', 23, NULL, 0.00, NULL, '2018-03-30 13:32:58'),
344 (86, 'rkolevv', '$2y$10$/Qs/TpyUecoAdltEqXwJUetlGIaDtWhQy0VXrcEsbjVtPgpLBIxMm', 'rrrkolev@abv.gb', '1234567899', 'Факултета', 'Radomir', 'Kolev', 19, NULL, 0.00, NULL, '2018-04-02 08:41:25'),
345 (87, 'rkolevvv', '$2y$10$Qgj6bdK/3s.MQmTUvjpTuuOZ.HQJyZFlwgCk9aMGtqBqYeDGvhrqq', 'rrrrkolev@abv.bg', '3333333334', 'Bul. Bulgaria', 'dfsfsdf', 'fdgfdgfd', 21, NULL, 0.00, NULL, '2018-04-02 09:37:40'),
346 (88, 'NaziSS', '$2y$10$8ft3kUXthL0oFVEb6hTwm.Ko9AXQVE/fyztYmf8qpdq5vaxg5IoZ6', 'littleredcap@gmail.com', '1234567888', 'Kiev', 'Igor', 'Michalenko', 18, '2db1b9963f14b4edf74f4c612e89fdcb5da3bfee-139.png', 0.00, NULL, '2018-04-03 14:20:21'),
347 (89, 'Koteto', '$2y$10$ghJ0bQqt7vLhm5ZKTwwWR.bYEWiN8IpuVPLPlddQQmg3YMuX2Ypay', 'malkoKoteSeksImaLi@abv.bg', '1234567890', 'ul. balsha 1', 'Bojinkata', 'Bojinkata', 32, NULL, 0.00, NULL, '2018-04-03 17:45:53'),
348 (90, 'pesho345', '$2y$10$uCzDrt54m/Ej1Bl2.alcCuUCcHtMYmPumLzJx.rVmZAKz6w/2o9pG', 'ivan12@abv.bg', '4444444444', 'jk.Ivan Vazov', 'Ivan', 'Ivanov', 66, '9a7d51e73929c678b90537a231e1939f89228128-Metalhead_Brewery.png', 0.00, NULL, '2018-04-04 10:12:24'),
349 (91, 'Kolevvvv', '$2y$10$QGMQQFyGLSfghTMVTX/zuud.8LhnKsjwln/oNiHIRupG5KoxOLFUC', 'lalla@abv.bg', '1231232131', 'adasdasdasdas', 'asdasd', 'dsfgfs', 22, 'df1e74d7084b50d51114658e67cf25c42f03ff37-118.png', 0.00, NULL, '2018-04-04 15:44:56'),
350 (92, 'tttt', '$2y$10$0itb0dRey3pqOiZ9mBkLpOd.fiOrBeun/XRj3l3veQZeb7iNmmgk6', 'daaade@abv.dgfff', '1111111111', 'ul. ', 'f', 'f', 66, 'd7fc2b67ef26594d610973bdb85446a28b263cba-Timesheet_Kalin_Markov_03.2018.xls', 0.00, NULL, '2018-04-04 17:39:53'),
351 (93, 'Paveto', '$2y$10$pJ4tn7J4D7wexjVLRjc/qeFlduF1kUGAimu8DJPuNQbHdtp4iVcTy', 'joro@comunalniteUslugi.net', '1231321021', 'Ðа Бали', 'Joro', 'Paveto', 40, 'fb070c6f2110ff4eb41003f964779ecc7f47e2eb-129.png', 0.00, NULL, '2018-04-05 10:02:48'),
352 (94, 'kiro', '$2y$10$g/tfhHWYJKeY1A72sU/Ck.CURVwjMWnftPjCELdaJD6lp/dozd3ea', 'bla@bla.coma', '3333333333', 'f', 'f', 'f', 22, NULL, 0.00, NULL, '2018-04-12 14:30:00'),
353 (95, 'tydaKdas', '$2y$10$ks4uAg5KMHb27/vEOuDFJ.plLHodNa/I1L066lzULZ5fGK2ZA7HGi', 'ivan@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-13 15:52:23'),
354 (96, 'LdNdoqsX', '$2y$10$2mpRO3V477ztuk90hkZD9u3h3Z7rYtNV0P5JIWTkzaW7T7HEdGAi2', 'lala@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-13 15:52:34'),
355 (97, 'kah138as', '$2y$10$EOi1XOXO.kzgVaLeM7ssFOZAtDyyOlMzh6Nhj4t3azQTD1TOvBMCi', 'aafb@abv.bg', '3213213123', 'sdfsd dksfdsk', 'lalala', 'asdasd', 33, NULL, 0.00, NULL, '2018-04-13 15:57:21'),
356 (98, 'tyd1Kdas', '$2y$10$k932qpj6WP1o99B9zK2UJerhiBqzkekNemF0UgvvkHiDJQJtZXbYW', 'ivan1@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-13 16:14:16'),
357 (99, 'LdN1oqsX', '$2y$10$W3QXnqkhf4SHr6CH87IPi.Br7i1xPmn8KRMPQxVgj0KY31iFbpoEa', 'lala1@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-13 16:14:28'),
358 (100, 'tyd2Kdas', '$2y$10$TRtN74AKqwz/ysQgobTaAeVz4UAiT3Jj5HNgfHDFXDJAp0CHQylZi', 'ivan2@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-13 16:21:01'),
359 (101, 'LdN2oqsX', '$2y$10$efFO2VhEogRMad6c6SJlbO0EyDNTThPmin.Ql3gwDUHIjzATX69gK', 'lala2@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-13 16:21:12'),
360 (102, 'ZZkoleZZ', '$2y$10$UlnKRThBiYG2WXSPejJVg.lp3kmjkO6L4ztkWoszNQBh0Nw7RfWEO', 'Ilaa1la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-13 17:07:54'),
361 (103, 'tyd3Kdas', '$2y$10$HxcdbPNhkJ9AgqHQfGFfDeaV3sbO3LfEiGNQgJEAyQXy57iCymKvS', 'ivan3@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-13 17:08:06'),
362 (104, 'LdN3oqsX', '$2y$10$jRLLN8v55wlS5iYGBjCFxuGmhqGnEiEAqICzbHXzqkX9MY17trlxu', 'lala3@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-13 17:08:18'),
363 (105, 'Z1koleZZ', '$2y$10$Zv896nWOciTG4t6/58wqFuhoApZ4NlJj5sftwW18G1bANyBh5ghsC', 'Ilaa2la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-13 17:10:44'),
364 (106, 'tyd4Kdas', '$2y$10$Y.n.tDqIkvqjeGnyH3diS.QcPxGtt5W/om6wblb1XsfQ0qtifNTTS', 'ivan4@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-13 17:10:55'),
365 (107, 'LdN4oqsX', '$2y$10$hZCRrvn5ocNV19oDV/56TuNFqeCs2QWGsJ6EpXx6ztL7zXRXM3eCu', 'lala4@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-13 17:11:08'),
366 (108, 'Z2koleZZ', '$2y$10$F49KWHqZGnVx/zPSAI1ZU.OAafw4bfczm31HqOPgAHmosO9D9UlCi', 'I1aa2la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-16 08:51:10'),
367 (109, 'tyd5Kdas', '$2y$10$/5u9qVK.zb6F62L.Fm3HC.OdSgSMWA7aJBYyPSU1DD7Uu2HFIJDzm', 'ivan5@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-16 08:51:21'),
368 (110, 'LdN5oqsX', '$2y$10$TYyLzyTW0HLv1IprdJtWeu1sbW0P9Hkh1kan1yUF.0k5PmeXipify', 'lala5@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-16 08:51:33'),
369 (111, 'tyd6Kdas', '$2y$10$gy2KxMNuhTw9p2eZN5JG/OsUVfvOmJsXXGBqRKjhwn3YWyapKUkLa', 'ivan6@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-16 11:49:59'),
370 (112, 'LdN6oqsX', '$2y$10$fzaB.C4cnO3YTg4h8HYLFeczmtyqh9Ae7x.MfU1j5kpyzffOj5bEi', 'lala6@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-16 11:50:11'),
371 (113, 'Z4koleZZ', '$2y$10$2VtxxO7q1I6.KWzhoCoeOOxYShZFYTZuCYbT49kfAF3ZYzMF5VARy', 'I1aa3la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-17 15:57:10'),
372 (114, 'tyd7Kdas', '$2y$10$GO0eCwktfKyyGhs5LVBaQuM8mHBpNCMk1EEAqeiF/E91J5xqzVEyW', 'ivan7@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-17 15:57:22'),
373 (115, 'LdN7oqsX', '$2y$10$mxWexp/gI05lbd2LlxuB4.cFoMYzi6O7Syyd9DCc8uCw7xCzwz/k.', 'lala7@aa.com', '2222222222', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-17 15:57:35'),
374 (116, 'Z5koleZZ', '$2y$10$XwLAheBNu.mmiBS96ox6muvCIk3SPR4We9RMdoqp/EQZ39tG/QkfO', 'I1aa5la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-17 16:25:32'),
375 (117, 'tyd8Kdas', '$2y$10$qDBAkFO2gnx.JH/saoGFMOcYcfZYHYU4pDEqprWlxdLEaf/57Z9Za', 'ivan8@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-17 16:25:43'),
376 (118, 'LdN8oqsX', '$2y$10$0tGJpi3SQ7UXELbG2Rsa4OsLfdsiq7JjGY9JbAXhpPf9t3yohS9cy', 'lala8@aa.com', '2122121212', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-17 16:25:56'),
377 (119, 'Z6koleZZ', '$2y$10$uK5PSZGc7ulFSokN.PBY7uEM3THQTS5mGQMdxRU8FJrTMnkxcois6', 'I1aa6la@abv.bg', '2314515612', 'Lalalasd', 'Ivan', 'Ivanov', 40, NULL, 0.00, NULL, '2018-04-18 10:42:03'),
378 (120, 'tyd9Kdas', '$2y$10$csmQYaHfwR/a50znQoZbe.iBd4BCCurdRak/21eyNxTEK29qh_beer_shopwwNeMO', 'ivan9@ivan.com', '2345654344', 'da be da', 'Ivan', 'Ivanov', 22, NULL, 0.00, NULL, '2018-04-18 10:42:15'),
379 (121, 'LdN9oqsX', '$2y$10$HPLIFPQm/jc0XznROZVBjutZ2gOcLfqjD8ItYl0ZpqSJo3aggLDzS', 'lala9@aa.com', '2122121212', 'nasnadad a', 'Ivan', 'Ivanov', 32, NULL, 0.00, NULL, '2018-04-18 10:42:26'),
380 (122, 'TestUser', '$2y$10$2Vjwnap20g86ZR2btRsyieTknAOrt8Iys5MVMNpg3QPvCxB6zxZ2y', 'test@mail.bg', '0000000000', 'oo', 'Test', 'User', 90, NULL, 0.00, NULL, '2018-04-18 13:41:11'),
381 (123, 'gugi', '$2y$10$JnzcGzn0CPDcjIdeQyb51eXetprWIlQyj76skj9SVPMfKqdKrEbwS', 'm@gg.com', '0725636636', 'Sofia,', 'Maria', 'Petrova', 58, 'e5e2c2d0182393e1f8bb0e881b87d1cb9f138e36-1.jpg', 0.00, NULL, '2018-04-18 15:13:31'),
382 (124, 'BatAndro', '$2y$10$jXpkfHROle4epdeFu6dGcefEjFjVYFeERbAraCXSXPQVbR7.06C4e', 'qwer@abv.bg', '1234567891', 'Sofia 1111', 'Andrei', 'Andreev', 20, NULL, 83813.00, NULL, '2018-04-19 14:06:28');
383/*!40000 ALTER TABLE `users` ENABLE KEYS */;
384
385-- Dumping structure for trigger qh_beer_shop.QuantityUpdate
386SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='';
387DELIMITER //
388CREATE TRIGGER `QuantityUpdate` AFTER INSERT ON `order_detail` FOR EACH ROW UPDATE products
389 SET quantity = quantity - NEW.quantity,
390 times_sold = times_sold + NEW.quantity
391 WHERE id = NEW.product_id//
392DELIMITER ;
393SET SQL_MODE=@OLDTMP_SQL_MODE;
394
395-- Dumping structure for trigger qh_beer_shop.ReduceWalletMoney
396SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='';
397DELIMITER //
398CREATE TRIGGER `ReduceWalletMoney` AFTER INSERT ON `orders` FOR EACH ROW UPDATE users
399 SET wallet = wallet - NEW.total_price
400 WHERE id = NEW.user_id//
401DELIMITER ;
402SET SQL_MODE=@OLDTMP_SQL_MODE;
403
404/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
405/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
406/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;