TRUNCATE `category`; TRUNCATE `config_value`; TRUNCATE `customer`; TRUNCATE `custom_order`; TRUNCATE `icon`; TRUNCATE `invoice`; TRUNCATE `log_cancel_product`; TRUNCATE `log_stock`; TRUNCATE `order`; TRUNCATE `order_detail`; TRUNCATE `order_group`; TRUNCATE `product`; TRUNCATE `promotion`; TRUNCATE `promotion_detail`; TRUNCATE `staff`; TRUNCATE `stock_transection`; TRUNCATE `table`; -- phpMyAdmin SQL Dump -- version 4.2.11 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Sep 26, 2015 at 10:34 AM -- Server version: 5.6.21 -- PHP Version: 5.5.19 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; -- -- Database: `vintage` -- -- -- Dumping data for table `category` -- INSERT INTO `category` (`category_id`, `category_name`, `category_images`, `category_type`) VALUES (15, 'หม้อไฟ', 'hot27', 1), (14, 'ของคบเคี้ยว', 'french3', 1), (13, 'เครื่องดืม', 'wine13', 2), (9, 'ผลไม้ปั่น / Cockail', 'cocktail6', 2), (11, 'ออเดิร์ฟ', 'food8', 1), (12, 'เมนูแนะนำ', 'grapes3', 1), (16, 'ประเภทยำ', 'food5', 1), (17, 'ประเภทผัด/ทอด', 'bowl8', 1), (18, 'ประเภทปลา', 'fish9', 1), (19, 'ข้าวต้มชุด', 'bowl8', 1), (22, 'บุหรี่', 'tea3', 1), (23, 'ข้าวเปล่า', 'bowl8', 1); -- -- Dumping data for table `config_value` -- INSERT INTO `config_value` (`id`, `name`, `value`) VALUES (1, 'Address', '192/8 ถ.ประชาสำราญ ต.ในเมือง อ.เมือง จ.ขอนแก่น 40000'), (2, 'Tax No.', '1234567890'), (3, 'Shop name', 'Vintage Restaurant'), (4, 'เปิด/ปิดชิพ', '1'); -- -- Dumping data for table `customer` -- INSERT INTO `customer` (`user_id`, `user_code`, `user_name`, `user_address`, `user_tel`, `customer_status`) VALUES (1, '', 'กด', 'กด', 'กด', 1), (2, '', 'ๆไๆไๆไๆไ', 'ๆไๆไ', 'ๆๆไๆไๆไๆไๆไ', 1); -- -- Dumping data for table `custom_order` -- INSERT INTO `custom_order` (`custom_id`, `order_id`, `order_group_id`, `custom_name`, `custom_qty`, `custom_price`, `fk_odd_id`) VALUES (1, 2, 2, '11', 1, 111, 12), (2, 4, 2, '2', 2, 22, 25), (3, 4, 2, '3', 3, 33, 26), (4, 5, 3, '4', 4, 44, 36), (5, 5, 3, '5', 5, 555, 37); -- -- Dumping data for table `icon` -- INSERT INTO `icon` (`icon_id`, `icon_name`) VALUES (1, 'apple12'), (2, 'apple13'), (3, 'apple14'), (4, 'avocado'), (5, 'barbecue3'), (6, 'beer6'), (7, 'bowl8'), (8, 'burger2'), (9, 'cabbage'), (10, 'carrot3'), (11, 'cheese2'), (12, 'chef7'), (13, 'cherries'), (14, 'chicken4'), (15, 'chocolate1'), (16, 'cocktail6'), (17, 'coffee12'), (18, 'coffee13'), (19, 'cooking6'), (20, 'corn'), (21, 'croissant1'), (22, 'cucumber1'), (23, 'cupcake3'), (24, 'dessert'), (25, 'dining'), (26, 'eggplant1'), (27, 'fire9'), (28, 'fish8'), (29, 'fish9'), (30, 'flat8'), (31, 'food5'), (32, 'food6'), (33, 'food7'), (34, 'food8'), (35, 'french3'), (36, 'fried3'), (37, 'glass2'), (38, 'gloves'), (39, 'gourd'), (40, 'grapes1'), (41, 'grapes3'), (42, 'hamburger2'), (43, 'hot27'), (44, 'hot28'), (45, 'hot29'), (46, 'hot30'), (47, 'hot31'), (48, 'hot32'), (49, 'hot33'), (50, 'hot34'), (51, 'hot36'), (52, 'hot37'), (53, 'ice17'), (54, 'ice18'), (55, 'ice19'), (56, 'jar2'), (57, 'kitchen8'), (58, 'leaves4'), (59, 'lemon1'), (60, 'lemon2'), (61, 'loaves'), (62, 'lunch'), (63, 'mate1'), (64, 'meat3'), (65, 'milk4'), (66, 'milk5'), (67, 'noodle1'), (68, 'onion1'), (69, 'onion2'), (70, 'open53'), (71, 'orange'), (72, 'packed'), (73, 'peach'), (74, 'preserved'), (75, 'restaurant11'), (76, 'rice2'), (77, 'root'), (78, 'sausage1'), (79, 'sausage2'), (80, 'sausage4'), (81, 'small102'), (82, 'soup'), (83, 'spongy'), (84, 'spoon4'), (85, 'squid'), (86, 'strawberry3'), (87, 'street2'), (88, 'sunny2'), (89, 'sushi4'), (90, 'tea3'), (91, 'tea4'), (92, 'three37'), (93, 'tomato1'), (94, 'two84'), (95, 'upsized'), (96, 'watermelon2'), (97, 'wine11'), (98, 'wine12'), (99, 'wine13'), (100, 'wine14'); -- -- Dumping data for table `invoice` -- INSERT INTO `invoice` (`id`, `invoice_no`, `order_id`, `customer_id`) VALUES (1, '00000001', 10, 1), (2, '00000002', 1, 1), (3, '00000003', 2, 2), (4, '00000004', 1, 0), (5, '00000005', 1, 0), (6, '00000006', 1, 3), (7, '00000007', 1, 0), (8, '00000008', 1, 3), (9, '00000009', 1, 0); -- -- Dumping data for table `log_cancel_product` -- INSERT INTO `log_cancel_product` (`log_cancel_id`, `table_id`, `product_id`, `product_qty`, `staff_code`, `log_time`) VALUES (1, 10, 230, 4, 'admin', '2015-09-08 12:10:57'), (2, 43, 228, 2, 'admin', '2015-09-08 12:28:59'), (3, 43, 67, 1, 'admin', '2015-09-08 12:28:59'), (4, 58, 41, 1, 'admin', '2015-09-08 12:51:24'), (5, 58, 37, 1, 'admin', '2015-09-08 12:51:52'), (6, 58, 39, 1, 'admin', '2015-09-08 12:52:49'), (7, 90, 229, 3, 'admin', '2015-09-08 13:05:14'), (8, 90, 125, 1, 'admin', '2015-09-08 13:05:14'), (9, 90, 117, 1, 'admin', '2015-09-08 13:05:14'), (10, 90, 43, 1, 'admin', '2015-09-08 13:05:14'), (11, 90, 52, 1, 'admin', '2015-09-08 13:05:14'), (12, 10, 228, 15, 'admin', '2015-09-08 13:15:48'), (13, 85, 59, 5, 'admin', '2015-09-08 13:22:04'), (14, 85, 146, 1, 'admin', '2015-09-08 13:22:23'), (15, 6, 229, 2, 'admin', '2015-09-08 13:55:34'), (16, 14, 59, 2, 'admin', '2015-09-08 14:39:46'), (17, 8, 67, 1, 'admin', '2015-09-09 03:14:07'), (18, 25, 225, 1, 'admin', '2015-09-09 03:15:25'), (19, 40, 107, 1, 'admin', '2015-09-12 10:37:45'), (20, 8, 228, 3, 'admin', '2015-09-12 10:38:00'), (21, 40, 228, 2, 'admin', '2015-09-12 10:38:19'), (22, 40, 67, 1, 'admin', '2015-09-12 10:38:33'), (23, 40, 95, 1, 'admin', '2015-09-12 10:38:51'), (24, 40, 131, 1, 'admin', '2015-09-12 10:41:46'), (25, 9, 229, 6, 'admin', '2015-09-12 10:42:58'), (26, 8, 67, 1, 'admin', '2015-09-12 10:43:25'), (27, 8, 67, 1, 'admin', '2015-09-12 10:43:35'), (28, 2, 25, 1, 'admin', '2015-09-12 11:03:01'), (29, 2, 222, 1, 'admin', '2015-09-12 11:03:01'), (30, 2, 228, 1, 'admin', '2015-09-12 11:03:01'), (31, 2, 13, 1, 'admin', '2015-09-12 11:03:01'), (32, 2, 17, 1, 'admin', '2015-09-12 11:03:01'), (33, 2, 55, 1, 'admin', '2015-09-12 11:03:01'), (34, 2, 57, 1, 'admin', '2015-09-12 11:03:01'), (35, 1, 22, 1, 'admin', '2015-09-12 11:03:56'), (36, 1, 26, 1, 'admin', '2015-09-12 11:03:56'), (37, 2, 58, 3, 'admin', '2015-09-12 11:04:35'), (38, 2, 146, 1, 'admin', '2015-09-12 11:04:35'), (39, 2, 64, 2, 'admin', '2015-09-12 11:04:35'), (40, 21, 111, 1, 'admin', '2015-09-12 11:04:35'), (41, 21, 128, 1, 'admin', '2015-09-12 11:04:35'), (42, 21, 95, 1, 'admin', '2015-09-12 11:04:35'), (43, 21, 67, 1, 'admin', '2015-09-12 11:04:35'), (44, 2, 11, 1, 'admin', '2015-09-12 11:04:35'), (45, 2, 216, 1, 'admin', '2015-09-12 11:06:16'), (46, 2, 215, 1, 'admin', '2015-09-12 11:06:16'), (47, 2, 12, 1, 'admin', '2015-09-12 11:13:22'), (48, 2, 13, 1, 'admin', '2015-09-12 11:13:22'), (49, 2, 17, 1, 'admin', '2015-09-12 11:13:22'), (50, 2, 42, 1, 'admin', '2015-09-12 11:14:25'), (51, 2, 215, 1, 'admin', '2015-09-12 11:14:25'), (52, 5, 37, 1, 'admin', '2015-09-12 13:04:58'), (53, 2, 44, 1, 'admin', '2015-09-12 13:32:45'), (54, 2, 43, 1, 'admin', '2015-09-12 13:32:45'), (55, 3, 38, 1, 'admin', '2015-09-12 13:32:52'), (56, 1, 48, 1, 'admin', '2015-09-15 08:20:12'), (57, 1, 44, 1, 'admin', '2015-09-15 08:20:12'), (58, 1, 43, 1, 'admin', '2015-09-15 08:20:12'), (59, 2, 59, 4, 'admin', '2015-09-15 08:20:12'), (60, 2, 146, 1, 'admin', '2015-09-15 08:20:12'), (61, 1, 59, 8, 'admin', '2015-09-15 08:20:12'), (62, 1, 65, 2, 'admin', '2015-09-15 08:20:12'), (63, 1, 66, 2, 'admin', '2015-09-15 08:20:12'), (64, 1, 62, 2, 'admin', '2015-09-15 08:20:12'), (65, 1, 63, 2, 'admin', '2015-09-15 08:20:12'), (66, 1, 67, 1, 'admin', '2015-09-15 08:20:12'), (67, 1, 68, 1, 'admin', '2015-09-15 08:20:12'), (68, 2, 165, 1, 'admin', '2015-09-15 15:21:14'), (69, 3, 166, 1, 'admin', '2015-09-15 15:21:18'), (70, 25, 58, 1, 'admin', '2015-09-15 15:35:54'); -- -- Dumping data for table `log_stock` -- INSERT INTO `log_stock` (`id`, `product_id`, `value`, `type`, `timestamp`) VALUES (1, 231, 0, 1, '2015-09-08 12:22:28'), (2, 67, -6, 0, '2015-09-08 13:34:33'), (3, 67, -7, 0, '2015-09-08 13:47:41'), (4, 67, -7, 0, '2015-09-08 13:47:41'), (5, 67, -8, 0, '2015-09-08 13:59:21'), (6, 64, -20, 0, '2015-09-08 13:59:21'), (7, 67, -8, 0, '2015-09-08 13:59:21'), (8, 67, -9, 0, '2015-09-08 14:07:57'), (9, 63, -19, 0, '2015-09-08 14:07:57'), (10, 64, -21, 0, '2015-09-08 14:07:57'), (11, 67, -9, 0, '2015-09-08 14:07:57'), (12, 63, -19, 0, '2015-09-08 14:07:57'), (13, 146, -5, 0, '2015-09-08 14:14:01'), (14, 64, -23, 0, '2015-09-08 14:47:35'), (15, 67, -10, 0, '2015-09-08 14:47:35'), (16, 65, -11, 0, '2015-09-08 14:47:35'), (17, 65, -12, 0, '2015-09-08 14:47:35'), (18, 67, -10, 0, '2015-09-08 14:47:35'), (19, 64, -25, 0, '2015-09-08 14:48:17'), (20, 67, -11, 0, '2015-09-08 14:48:17'), (21, 146, -6, 0, '2015-09-08 14:48:17'), (22, 64, -24, 0, '2015-09-08 14:48:17'), (23, 67, -11, 0, '2015-09-08 14:48:17'), (24, 67, -12, 0, '2015-09-08 14:55:05'), (25, 67, -13, 0, '2015-09-12 10:49:17'), (26, 67, -13, 0, '2015-09-12 10:49:17'), (27, 67, -13, 0, '2015-09-12 10:49:17'), (28, 67, -13, 0, '2015-09-12 10:49:17'), (29, 67, -13, 0, '2015-09-12 10:49:17'), (30, 14, -20, 0, '2015-09-12 10:49:17'), (31, 13, -22, 0, '2015-09-12 10:49:17'), (32, 12, -26, 0, '2015-09-12 10:49:17'), (33, 11, -11, 0, '2015-09-12 10:49:17'), (34, 15, -11, 0, '2015-09-12 10:49:17'), (35, 16, -8, 0, '2015-09-12 10:49:17'), (36, 17, -9, 0, '2015-09-12 10:49:17'), (37, 18, -12, 0, '2015-09-12 10:49:17'), (38, 12, -27, 0, '2015-09-12 11:15:34'), (39, 13, -23, 0, '2015-09-12 11:15:35'), (40, 11, -12, 0, '2015-09-12 11:17:52'), (41, 15, -12, 0, '2015-09-12 11:17:52'), (42, 11, -15, 0, '2015-09-12 11:22:25'), (43, 53, 89, 0, '2015-09-12 13:07:31'), (44, 146, -7, 0, '2015-09-12 13:07:31'), (45, 63, -22, 0, '2015-09-12 13:07:31'), (46, 13, -24, 0, '2015-09-15 08:09:12'), (47, 14, -21, 0, '2015-09-15 08:09:12'), (48, 15, -14, 0, '2015-09-15 08:09:12'), (49, 14, -22, 0, '2015-09-15 08:09:16'), (50, 18, -13, 0, '2015-09-15 08:09:16'), (51, 59, 52, 0, '2015-09-15 08:22:26'), (52, 67, -16, 0, '2015-09-15 08:22:26'), (53, 51, 121, 0, '2015-09-15 08:22:33'), (54, 63, -26, 0, '2015-09-15 08:22:33'), (55, 67, -19, 0, '2015-09-15 08:22:33'), (56, 59, 46, 0, '2015-09-15 08:26:50'), (57, 67, -21, 0, '2015-09-15 08:26:50'), (58, 66, -11, 0, '2015-09-15 08:26:50'), (59, 51, 118, 0, '2015-09-15 08:29:44'), (60, 63, -33, 0, '2015-09-15 08:29:45'), (61, 67, -24, 0, '2015-09-15 08:29:45'), (62, 67, -22, 0, '2015-09-15 08:29:45'), (63, 14, -23, 0, '2015-09-15 12:28:49'), (64, 52, 85, 0, '2015-09-15 12:44:26'), (65, 146, -8, 0, '2015-09-15 12:44:26'), (66, 13, -25, 0, '2015-09-15 12:44:26'), (67, 14, -24, 0, '2015-09-15 12:44:26'), (68, 12, -28, 0, '2015-09-15 12:47:33'), (69, 53, 88, 0, '2015-09-15 15:03:10'), (70, 146, -9, 0, '2015-09-15 15:03:11'), (71, 63, -34, 0, '2015-09-15 15:03:11'), (72, 64, -25, 0, '2015-09-15 15:03:11'), (73, 188, -1, 0, '2015-09-15 15:03:11'), (74, 11, -16, 0, '2015-09-15 15:07:30'), (75, 212, -1, 0, '2015-09-15 15:07:30'), (76, 211, -1, 0, '2015-09-15 15:07:30'), (77, 12, -29, 0, '2015-09-15 15:07:30'), (78, 55, 13, 0, '2015-09-15 15:21:51'), (79, 67, -26, 0, '2015-09-15 15:21:51'), (80, 63, -36, 0, '2015-09-15 15:21:51'), (81, 64, -27, 0, '2015-09-15 15:21:51'), (82, 64, -29, 0, '2015-09-15 16:18:35'), (83, 67, -27, 0, '2015-09-15 16:18:35'), (84, 59, 42, 0, '2015-09-15 16:37:06'), (85, 146, -10, 0, '2015-09-15 16:37:06'), (86, 65, -17, 0, '2015-09-15 16:37:24'), (87, 67, -30, 0, '2015-09-15 16:37:24'), (88, 64, -32, 0, '2015-09-15 16:37:24'), (89, 58, 177, 0, '2015-09-15 16:37:24'), (90, 61, -9, 0, '2015-09-15 16:41:29'), (91, 67, -32, 0, '2015-09-15 16:41:29'), (92, 67, -31, 0, '2015-09-15 16:41:29'), (93, 67, -33, 0, '2015-09-15 16:42:23'), (94, 16, -9, 0, '2015-09-15 16:48:24'), (95, 17, -10, 0, '2015-09-15 16:48:24'), (96, 18, -14, 0, '2015-09-15 16:48:24'), (97, 13, -26, 0, '2015-09-15 16:50:46'), (98, 12, -30, 0, '2015-09-15 16:50:46'), (99, 11, -18, 0, '2015-09-15 16:50:46'), (100, 15, -15, 0, '2015-09-15 16:50:46'), (101, 16, -10, 0, '2015-09-15 16:50:46'), (102, 17, -12, 0, '2015-09-15 16:50:46'), (103, 12, -31, 0, '2015-09-17 07:00:02'), (104, 13, -27, 0, '2015-09-17 07:00:02'), (105, 34, -6, 0, '2015-09-17 07:07:09'), (106, 35, -3, 0, '2015-09-17 07:07:09'), (107, 57, 61, 0, '2015-09-17 07:07:09'), (108, 67, -35, 0, '2015-09-17 07:07:09'), (109, 65, -21, 0, '2015-09-17 07:08:03'), (110, 64, -34, 0, '2015-09-17 07:08:03'), (111, 67, -37, 0, '2015-09-17 07:08:03'), (112, 67, -36, 0, '2015-09-17 07:08:03'), (113, 63, -38, 0, '2015-09-17 07:08:03'), (114, 59, 39, 0, '2015-09-17 07:13:39'), (115, 67, -38, 0, '2015-09-17 07:13:39'), (116, 58, 176, 0, '2015-09-17 07:13:39'), (117, 51, 117, 0, '2015-09-17 07:25:42'), (118, 63, -40, 0, '2015-09-17 07:25:42'), (119, 67, -40, 0, '2015-09-17 07:25:42'), (120, 64, -36, 0, '2015-09-17 07:25:42'), (121, 59, 38, 0, '2015-09-17 07:25:42'), (122, 60, -20, 0, '2015-09-17 07:25:42'), (123, 61, -11, 0, '2015-09-17 07:25:42'), (124, 57, 60, 0, '2015-09-17 07:25:42'), (125, 58, 175, 0, '2015-09-17 07:25:42'), (126, 55, 12, 0, '2015-09-17 07:25:42'), (127, 54, 65, 0, '2015-09-17 07:25:42'), (128, 53, 87, 0, '2015-09-17 07:25:42'), (129, 58, 171, 0, '2015-09-17 07:26:13'), (130, 67, -42, 0, '2015-09-17 07:26:13'), (131, 51, 116, 0, '2015-09-17 07:26:13'), (132, 64, -40, 0, '2015-09-17 07:26:13'), (133, 63, -44, 0, '2015-09-17 07:26:14'), (134, 34, -8, 0, '2015-09-17 07:26:14'), (135, 32, -3, 0, '2015-09-17 07:26:14'), (136, 58, 173, 0, '2015-09-17 07:26:14'), (137, 57, 59, 0, '2015-09-17 07:26:14'), (138, 11, -19, 0, '2015-09-22 08:59:38'), (139, 12, -32, 0, '2015-09-22 08:59:38'), (140, 16, -11, 0, '2015-09-22 08:59:38'), (141, 15, -16, 0, '2015-09-22 08:59:38'), (142, 11, -20, 0, '2015-09-22 08:59:46'), (143, 12, -33, 0, '2015-09-22 08:59:46'), (144, 16, -12, 0, '2015-09-22 08:59:46'), (145, 15, -17, 0, '2015-09-22 08:59:46'), (146, 63, -48, 0, '2015-09-23 17:07:30'), (147, 64, -44, 0, '2015-09-23 17:07:30'), (148, 67, -45, 0, '2015-09-23 17:07:30'), (149, 52, 83, 0, '2015-09-23 17:07:30'), (150, 52, 82, 0, '2015-09-23 17:23:06'), (151, 146, -12, 0, '2015-09-23 17:23:06'), (152, 65, -22, 0, '2015-09-23 17:23:06'), (153, 64, -48, 0, '2015-09-23 17:23:06'), (154, 63, -52, 0, '2015-09-23 17:23:06'), (155, 59, 34, 0, '2015-09-23 17:25:50'), (156, 67, -46, 0, '2015-09-23 17:25:50'), (157, 63, 0, 1, '2015-09-23 18:43:02'), (158, 260, 0, 1, '2015-09-23 18:52:22'); -- -- Dumping data for table `order` -- INSERT INTO `order` (`order_id`, `order_status`, `staff_id`, `order_timestamp`, `order_totalPrice`, `table_id`, `customer_id`, `order_group_id`) VALUES (1, 0, 2, '2015-09-26 08:32:14', 1032, 1, 0, 1), (2, 0, 2, '2015-09-26 08:32:35', 498, 2, 0, 2), (3, 0, 2, '2015-09-26 08:32:47', 912, 1, 0, 1), (4, 0, 2, '2015-09-26 08:33:07', 659, 2, 0, 2), (5, 0, 2, '2015-09-26 08:33:32', 4448, 3, 0, 3), (6, 0, 2, '2015-09-26 08:33:48', 706, 3, 0, 3), (7, 0, 2, '2015-09-26 08:34:14', 1592, 9, 0, 4); -- -- Dumping data for table `order_detail` -- INSERT INTO `order_detail` (`odd_id`, `order_id`, `product_id`, `product_qty`, `table_id`, `group_id`, `fk_custom_id`) VALUES (1, 1, 11, 1, 1, 1, NULL), (2, 1, 12, 1, 1, 1, NULL), (3, 1, 13, 1, 1, 1, NULL), (4, 1, 14, 1, 1, 1, NULL), (5, 1, 20, 1, 1, 1, NULL), (6, 1, 19, 1, 1, 1, NULL), (7, 1, 25, 1, 1, 1, NULL), (8, 1, 31, 1, 1, 1, NULL), (9, 2, 11, 1, 2, 2, NULL), (10, 2, 12, 1, 2, 2, NULL), (11, 2, 13, 1, 2, 2, NULL), (12, 2, NULL, 1, 2, 2, 1), (13, 3, 11, 1, 1, 1, NULL), (14, 3, 12, 1, 1, 1, NULL), (15, 3, 13, 1, 1, 1, NULL), (16, 3, 19, 1, 1, 1, NULL), (17, 3, 18, 1, 1, 1, NULL), (18, 3, 102, 1, 1, 1, NULL), (19, 3, 101, 1, 1, 1, NULL), (20, 3, 100, 1, 1, 1, NULL), (21, 4, 12, 1, 2, 2, NULL), (22, 4, 13, 1, 2, 2, NULL), (23, 4, 19, 1, 2, 2, NULL), (24, 4, 18, 1, 2, 2, NULL), (25, 4, NULL, 2, 2, 2, 2), (26, 4, NULL, 3, 2, 2, 3), (27, 5, 12, 1, 3, 3, NULL), (28, 5, 11, 1, 3, 3, NULL), (29, 5, 70, 1, 3, 3, NULL), (30, 5, 65, 1, 3, 3, NULL), (31, 5, 151, 1, 3, 3, NULL), (32, 5, 145, 1, 3, 3, NULL), (33, 5, 144, 1, 3, 3, NULL), (34, 5, 139, 1, 3, 3, NULL), (35, 5, 140, 1, 3, 3, NULL), (36, 5, NULL, 4, 3, 3, 4), (37, 5, NULL, 5, 3, 3, 5), (38, 6, 11, 1, 3, 3, NULL), (39, 6, 17, 1, 3, 3, NULL), (40, 6, 23, 1, 3, 3, NULL), (41, 6, 30, 1, 3, 3, NULL), (42, 6, 31, 1, 3, 3, NULL), (43, 6, 65, 1, 3, 3, NULL), (44, 6, 66, 1, 3, 3, NULL), (45, 6, 67, 1, 3, 3, NULL), (46, 6, 61, 1, 3, 3, NULL), (47, 7, 18, 1, 9, 4, NULL), (48, 7, 19, 1, 9, 4, NULL), (49, 7, 20, 1, 9, 4, NULL), (50, 7, 26, 1, 9, 4, NULL), (51, 7, 25, 1, 9, 4, NULL), (52, 7, 27, 1, 9, 4, NULL), (53, 7, 33, 1, 9, 4, NULL), (54, 7, 32, 1, 9, 4, NULL), (55, 7, 38, 1, 9, 4, NULL), (56, 7, 40, 1, 9, 4, NULL), (57, 7, 62, 1, 9, 4, NULL), (58, 7, 70, 1, 9, 4, NULL), (59, 7, 69, 1, 9, 4, NULL), (60, 7, 75, 1, 9, 4, NULL); -- -- Dumping data for table `order_group` -- INSERT INTO `order_group` (`group_id`, `table_id`, `date`, `status`) VALUES (1, 1, '2015-09-26 08:32:14', 0), (2, 2, '2015-09-26 08:32:35', 0), (3, 3, '2015-09-26 08:33:32', 0), (4, 9, '2015-09-26 08:34:14', 0); -- -- Dumping data for table `product` -- INSERT INTO `product` (`product_id`, `product_category`, `product_name`, `product_price`, `product_favorite`, `product_status`, `product_img`, `product_type`, `product_com`, `promotion_id`, `product_amount`, `isMixer`, `isIce`) VALUES (2, 5, 'ลีโอ', '60', 0, 1, '10891696_959190680776091_90416677679851171_n.jpg', 2, 3, 0, 117, 0, 0), (3, 5, 'ช้าง', '55', 0, 1, 'Redshire.jpg', 2, 1, 0, 97, 0, 0), (5, 3, 'ต้มแซ่บ', '150', 0, 1, 'Untitled.png', 0, 0, 0, 0, 0, 0), (9, 10, 'Black Label 1 Lit', '1829', 0, 1, 'black.jpg', 2, 0, 0, 0, 0, 0), (10, 10, 'Red Label 1 Lit', '1019', 0, 1, 'redlable.jpg', 2, 0, 0, 0, 0, 0), (11, 9, 'แอ๊ปเปิ้ล/เหยือก', '129', 0, 1, '', 2, 5, 0, -20, 0, 0), (12, 9, 'แคนตาลูป/เหยือก', '129', 0, 1, '', 2, 5, 0, -33, 0, 0), (13, 9, 'องุ่น/เหยือก', '129', 0, 1, '', 2, 5, 0, -27, 0, 0), (14, 9, 'สตรอเบอร์รี่/เหยือก', '129', 0, 1, '', 2, 5, 0, -24, 0, 0), (15, 9, 'ลิ้นจี่/เหยือก', '129', 0, 1, '', 2, 5, 0, -17, 0, 0), (16, 9, 'ส้ม/เหยือก', '129', 0, 1, '', 2, 5, 0, -12, 0, 0), (17, 9, 'สับปะรด/เหยือก', '129', 0, 1, '', 2, 5, 0, -12, 0, 0), (18, 9, 'ทับทิม/เหยือก', '129', 0, 1, '', 2, 5, 0, -14, 0, 0), (19, 9, 'บลูฮาวาย/เหยือก', '129', 0, 1, '', 2, 5, 0, -9, 0, 0), (20, 9, 'บลูเลมอน/เหยือก', '129', 0, 1, '', 2, 5, 0, -10, 0, 0), (21, 9, 'บลูครูราโซ่/เหยือก', '129', 0, 1, '', 2, 5, 0, -8, 0, 0), (22, 9, 'พันซ์แดง/เหยือก', '129', 0, 1, '', 2, 5, 0, -2, 0, 0), (23, 9, 'Vodka', '50', 0, 1, '', 2, 1, 0, -4, 0, 0), (24, 9, 'เพิ่มเหล้า', '20', 0, 1, '', 2, 1, 0, 0, 0, 0), (25, 9, 'คามิคาเซ่/เหยือก', '129', 0, 1, '', 2, 5, 0, -2, 0, 0), (26, 9, 'รัมพันซ์/เหยือก', '129', 0, 1, '', 2, 5, 0, -3, 0, 0), (27, 9, 'ออฟโรด/เหยือก', '129', 0, 1, '', 2, 5, 0, -4, 0, 0), (28, 9, 'น็อคเอ้าท์/เหยือก', '129', 0, 1, '', 2, 5, 0, -5, 0, 0), (29, 9, 'สบาย ๆ/เหยือก', '129', 0, 1, '', 2, 5, 0, -3, 0, 0), (30, 9, 'โซนิค บูม/เหยือก', '129', 0, 1, '', 2, 5, 0, -1, 0, 0), (31, 9, 'ซุปเปอร์บลู/เหยือก', '129', 0, 1, '', 2, 5, 0, -3, 0, 0), (32, 9, 'โฮโน ลูลู/เหยือก', '129', 0, 1, '', 2, 5, 0, -3, 0, 0), (33, 9, 'ไหมไทย/เหยือก', '129', 0, 1, '', 2, 5, 0, -2, 0, 0), (34, 9, 'กีวี่/เหยือก', '129', 0, 1, '', 2, 5, 0, -8, 0, 0), (35, 9, 'สปีด อัพ/เหยือก', '129', 0, 1, '', 2, 5, 0, -3, 0, 0), (36, 9, 'บลูฮานอย/เหยือก', '129', 0, 1, '', 2, 5, 0, -1, 0, 0), (37, 11, 'ออเดิร์ฟ อีสาน', '199', 0, 1, '', 1, 0, 0, 0, 0, 0), (38, 11, 'ออเดิร์ฟ สองสามเก้า', '199', 0, 1, '', 1, 0, 0, 0, 0, 0), (39, 11, 'ออเดิร์ฟ ทะเล', '199', 0, 1, '', 1, 0, 0, 0, 0, 0), (40, 12, 'ยำเห็ดเข็มทองทอดกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (41, 12, 'ยำก้านคะน้ากรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (42, 12, 'ปลาหมึกไข่นึ่งมะนาว', '249', 0, 1, '', 1, 0, 0, 0, 0, 0), (43, 12, 'เอ็นไก่สามรส', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (44, 12, 'ไก่ซอสมะนาว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (45, 12, 'กุ้งทอดกระเทียม', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (46, 12, 'ปลาหมึกไข่ทอดกระเทียม', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (47, 12, 'ลาบปลาซ่อนทอดกรอบ', '239', 0, 1, '', 1, 0, 0, 0, 0, 0), (48, 12, 'ปีกไก่ทอดน้ำปลา', '99', 0, 1, '', 1, 0, 0, 0, 0, 0), (51, 13, 'Black Label 1 Lit', '1829', 0, 1, 'blacklabel.jpg', 2, 1, 0, 116, 0, 0), (52, 13, 'Red Label 1 Lit', '1020', 0, 1, 'redlabel.jpg', 2, 1, 0, 82, 0, 0), (53, 13, 'Regency', '599', 0, 1, 'regency.jpg', 2, 1, 0, 87, 0, 0), (54, 13, '100 Pipers', '449', 0, 1, '100-pipers-logo-primary.jpg', 2, 1, 0, 65, 0, 0), (55, 13, 'แสงโสม', '299', 0, 1, '1366786894-rumsan01-o.jpg', 2, 1, 0, 12, 0, 0), (57, 13, 'Asihi', '99', 0, 1, 'asahi.jpg', 2, 1, 0, 59, 0, 0), (58, 13, 'Singha 500 ml', '89', 0, 1, 'singha-500x500.jpg', 2, 1, 0, 173, 0, 0), (59, 13, 'Leo', '89', 0, 1, 'leo.jpg', 2, 1, 0, 34, 0, 0), (60, 13, 'Smirnoff Ice ', '80', 0, 1, 'TD5W_Es0.jpg', 2, 0, 0, -20, 0, 0), (61, 13, 'Spy rad', '65', 0, 1, '4N2362FB0NB7QSHOP_2.jpg', 2, 0, 0, -11, 0, 0), (62, 13, 'ไวน์ฟลูมูน แดง', '45', 0, 1, 'fullmoon.JPG', 2, 0, 0, -5, 0, 0), (63, 13, 'โซดา (Soda)', '25', 0, 1, 'soda.JPG', 2, 1, 0, 100, 1, 0), (64, 13, 'Water', '25', 0, 1, 'water.JPG', 2, 1, 0, -48, 1, 0), (65, 13, 'Coke', '25', 0, 1, 'Coke.jpg', 2, 1, 0, -22, 1, 0), (66, 13, 'Sprite', '25', 0, 1, 'sprite.JPG', 2, 1, 0, -11, 1, 0), (67, 13, 'Ice S', '25', 0, 1, 'ice.JPG', 2, 0, 0, -46, 1, 1), (68, 14, 'ข้าวเกรียบทอด', '69', 0, 1, '', 1, 0, 0, 0, 0, 0), (69, 14, 'ถั่วทอด', '69', 0, 1, '', 1, 0, 0, 0, 0, 0), (70, 14, 'เฟรนฟราย', '69', 0, 1, '14566565_ml.jpg', 1, 0, 0, 0, 0, 0), (71, 14, 'เม็ดมะม่วงทอด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (72, 14, 'เอ็นไก่ทอด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (73, 14, 'เนื้อ / หมูแดดเดียว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (74, 14, 'ซี่โครงหมูทอด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (75, 14, 'ไส้กรอกอีสาน', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (76, 14, 'ปูอัด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (77, 14, 'ขาลายลวกจิ้ม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (78, 14, 'หมูมะนาว /เนื้อมะนาว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (79, 14, 'ทะเลลวกจิ้ม', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (80, 14, 'แหนมทรงเครื่อง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (81, 15, 'ต้มยำกุ้ง', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (82, 15, 'ต้มยำรวมมิตร', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (83, 15, 'ต้มยำโป๊ะแตก', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (84, 15, 'ต้มแซบกระดูกอ่อน', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (85, 15, 'ต้มแซบเนื้อขาลาย', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (86, 15, 'ต้มยำไก่บ้าน', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (87, 15, 'ต้มข่าไก่', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (88, 15, 'แกงเลียงกุ้งสด', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (89, 15, 'แกงจืดเต้าหู้หมูสับ', '130', 0, 1, '', 1, 0, 0, 0, 0, 0), (90, 15, 'แกงป่า ไก่ / หมู / เนื้อ', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (92, 16, 'ยำวุ้นเส้น', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (93, 16, 'ยำรวมมิตร', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (94, 16, 'ยำเห็ดเข็มทอง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (95, 16, 'ยำสามกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (96, 16, 'ยำปลาดุกฟู', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (97, 16, 'ยำหมูยอ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (98, 16, 'ยำแหนม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (99, 16, 'ยำไข่ดาว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (100, 16, 'ยำผักบุ้งกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (101, 16, 'ยำถั่วพลู', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (102, 16, 'ยำหอยนางรม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (103, 16, 'ยำไส้ตัน', '99', 0, 1, '', 1, 0, 0, 0, 0, 0), (104, 16, 'ยำตะไคร้', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (105, 16, 'ยำเนื้อมะเขือเปาะ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (106, 16, 'ตำแตงหมูกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (107, 16, 'ตำถั่ว หมูกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (108, 17, 'ผัดพริกไทยดำ หมู/เนื้อ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (109, 17, 'เนื้อขาลายน้ำมันหอย', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (110, 17, 'หน่อไม้ฝรั่งผัดกุ้ง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (111, 17, 'กุ้งผัดเห็ดเข็มทอง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (112, 17, 'ไก่ผัดเม็ดมะม่วง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (113, 17, 'ไข่เยี่ยวม้ากระเพรากรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (114, 17, 'กุ้ยฉ่ายขาวหมูกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (115, 17, 'ปลาหมึกผัดไข่เค็ม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (116, 17, 'พะแนง เนื้อ / หมู', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (117, 17, 'ปลากระพงผัดฉ่า', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (118, 17, 'ปลากระพงผัดคื่นฉ่าย', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (119, 17, 'กุ้งแช่น้ำปลา', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (120, 17, 'ผัดผักรวมมิตร', '79', 0, 1, '', 1, 0, 0, 0, 0, 0), (121, 17, 'เอ็นไก่สามรส สอง 3 ก้าว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (123, 17, 'วุ้นเส้นผัดไข่', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (124, 17, 'ลาบหมู', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (125, 17, 'ลาบปลาหมึก', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (126, 17, 'หอยนางรมแช่เย็น', '99', 0, 1, '', 1, 0, 0, 0, 0, 0), (127, 17, 'ลาบหมูทอด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (128, 17, 'หอยนางรมกระทะร้อน', '139', 0, 1, '', 1, 0, 0, 0, 0, 0), (129, 17, 'ไก่ซอสมะนาว', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (130, 17, 'กุ้งชุบแป้งทอด', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (131, 17, 'ไก่บ้านทอดเกลือ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (132, 17, 'ไก่ทอดสมุนไพร', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (133, 17, 'ผัดเจสี่สหาย', '99', 0, 1, '', 1, 0, 0, 0, 0, 0), (134, 17, 'เต้าหู้ทรงเครื่อง', '129', 0, 1, '', 1, 0, 0, 0, 0, 0), (135, 17, 'ห่อหมกทะเล', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (136, 17, 'ทะเลผัดฉ่ากระทะร้อน', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (137, 17, 'ทะเลเดือด', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (138, 17, 'กระหล่ำทอดน้ำปลา', '100', 0, 1, '', 1, 0, 0, 0, 0, 0), (139, 18, 'แกงส้มแปะซะปลาช่อน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (140, 18, 'ปลาหมึกไข่นึ่งมะนาว', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (141, 17, 'ทะเลผัดผงกระหรี่', '159', 0, 1, '', 1, 0, 0, 0, 0, 0), (142, 18, 'ปลาทับทิมนึ่งมะนาว', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (143, 18, 'ปลาทับทิมทอดน้ำปลา', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (144, 18, 'พล่าปลาทับทิม', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (145, 18, 'ปลาทับทิมทอดกระเทียม', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (146, 13, 'Ice B', '50', 0, 1, 'ice.JPG', 2, 0, 0, -12, 1, 1), (147, 13, 'Blend 285 1 Lit', '406', 0, 1, 'blend285.JPG', 2, 1, 0, 0, 0, 0), (148, 18, 'ปลาทับทิมสามรส', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (149, 18, 'นึ่งซีอิ้วปลาทับทิม, ปลาช่อน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (219, 18, 'นึ่งซีอิ้ว ปลากะพง', '349', 0, 1, '', 1, 0, 0, 0, 0, 0), (226, 13, 'โปร Singlight', '283', 0, 1, '', 2, 1, 6, 0, 0, 0), (151, 18, 'นึ่งบ๊วยปลาทับทิม, ปลาช่อน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (152, 18, 'นึ่งบ๊วย ปลากะพง ', '349', 0, 1, '', 1, 0, 0, 0, 0, 0), (221, 13, 'Singlight', '79', 0, 1, '', 2, 1, 0, -8, 0, 0), (153, 18, 'แปะซะปลาช่อน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (154, 18, 'ปลาช่อนโบราณ', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (155, 18, 'ปลาช่อน,ปลาทับทิม ลุยสวน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (156, 18, 'ปลาช่อนพุงแตก', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (157, 18, 'เมี่ยงปลาทับทิม, ปลาช่อน', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (158, 18, 'เมี่ยง ปลากะพง ', '349', 0, 1, '', 1, 0, 0, 0, 0, 0), (159, 18, 'ฉู่ฉี่ปลาทับทิม', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (160, 18, 'ฉู่ฉี่ปลากะพง', '349', 0, 1, '', 1, 0, 0, 0, 0, 0), (161, 18, 'ปลาช่อน สอง 3 ก้าว', '229', 0, 1, '', 1, 0, 0, 0, 0, 0), (220, 16, 'พล่ากุ้ง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (163, 18, 'ปลากะพง สอง 3 ก้าว', '349', 0, 1, '', 1, 0, 0, 0, 0, 0), (164, 19, 'กุ้ยฉ่ายหมูกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (165, 19, 'คะน้าหมูกรอบ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (166, 19, 'ผักบุ้งไฟแดง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (167, 19, 'ไชโป้ผัดไข่', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (168, 19, 'หนำเลี้ยบหมูสับ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (169, 19, 'ยำไข่เค็ม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (170, 19, 'ไข่เจียวหมูสับ', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (171, 19, 'ยำเกี้ยมฉ่าย', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (173, 19, 'ยำกุนเชียง', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (227, 13, 'โปร Singha 500 ml.', '283', 0, 1, '', 2, 1, 5, 0, 0, 0), (187, 13, 'ไวน์ฟลูมูน ขาว', '45', 0, 1, '', 2, 0, 0, 0, 0, 0), (188, 13, 'Smirnoff apple', '80', 0, 1, '', 2, 0, 0, -1, 0, 0), (222, 13, 'โปร Red Ltr. ', '1069', 0, 1, '', 2, 3, 1, 0, 0, 0), (189, 13, 'spy classic', '65', 0, 1, '', 2, 0, 0, 0, 0, 0), (190, 13, 'Blend 70 ml', '294', 0, 1, '', 2, 1, 0, -1, 0, 0), (191, 9, 'แอ๊ปเปิ้ล/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (192, 9, 'แคนตาลูป/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (193, 9, 'องุ่น/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (194, 9, 'สตรอเบอร์รี่/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (195, 9, 'ลิ้นจี่/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (196, 9, 'ส้ม/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (197, 9, 'สับปะรด/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (198, 9, 'บลูฮาวาย/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (199, 9, 'บลูเลมอน/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (200, 9, 'บลูครูราโซ่/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (201, 9, 'พันซ์แดง/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (202, 9, 'คามิคาเซ่/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (203, 9, 'รัมพันซ์/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (204, 9, 'ออฟโรด/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (205, 9, 'น็อคเอ้าท์/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (206, 9, 'สบาย ๆ/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (207, 9, 'โซนิค บูม/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (208, 9, 'ซุปเปอร์บลู/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (209, 9, 'โฮโน ลูลู/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (210, 9, 'ไหมไทย/แก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (211, 9, 'กีวี่/เเก้ว', '69', 0, 1, '', 2, 5, 0, -1, 0, 0), (212, 9, 'สปีด อัพ/แก้ว', '69', 0, 1, '', 2, 5, 0, -1, 0, 0), (213, 9, 'บลูฮานอย/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (214, 9, 'ทับทิม/เเก้ว', '69', 0, 1, '', 2, 5, 0, 0, 0, 0), (215, 12, 'ยำปลาหมึก', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (216, 12, 'ยำเห็ดเข็มทองลวก', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (217, 17, 'กุ้งแช่น้ำปลา+วาซาบิ', '100', 0, 1, '', 1, 0, 0, 0, 0, 0), (218, 17, 'ไส้ตันทอดกระเทียม', '149', 0, 1, '', 1, 0, 0, 0, 0, 0), (223, 13, 'โปร Blend 285. 70 ml. ', '374', 0, 1, '', 2, 3, 2, 0, 0, 0), (224, 13, 'โปร Leo 4 ', '283', 0, 1, '', 2, 1, 4, 0, 0, 0), (225, 13, 'โปร Blend 285. Ltr. ', '466', 0, 1, '', 2, 3, 3, 0, 0, 0), (228, 13, 'โปรก่อนสามทุ่ม LEO', '52', 0, 1, '', 2, 0, 7, -18, 0, 0), (229, 13, 'โปรก่อนสามทุ่ม Singha', '52', 0, 1, '', 2, 0, 8, -3, 0, 0), (230, 13, 'โปรก่อนสามทุ่ม Singlight', '52', 0, 1, '', 2, 0, 9, -1, 0, 0), (231, 22, 'Marlboro Gold', '115', 0, 1, '', 1, 0, 0, 0, 0, 0), (232, 22, 'Marlboro Black menthol', '115', 0, 1, '', 1, 0, 0, 0, 0, 0), (233, 22, 'Marlboro Red', '115', 0, 1, '', 1, 0, 0, 0, 0, 0), (234, 22, 'Marlboro clip mint', '115', 0, 1, '', 1, 0, 0, 0, 0, 0), (235, 22, 'Lm Red', '95', 0, 1, '', 1, 0, 0, 0, 0, 0), (236, 22, 'Lm Green', '95', 0, 1, '', 1, 0, 0, 0, 0, 0), (237, 23, 'ข้าวเปล่าจาน', '10', 0, 1, '', 1, 0, 0, 0, 0, 0), (238, 23, 'ข้าวเปล่า โถ่', '40', 0, 1, '', 1, 0, 0, 0, 0, 0), (239, 22, 'ไฟแช็ค', '20', 0, 1, '', 1, 0, 0, 0, 0, 0), (240, 17, 'ข้าวผัดหมู เล็ก', '60', 0, 1, '', 1, 0, 0, 0, 0, 0), (241, 17, 'ข้าวผัดหมู กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (242, 17, 'ข้าวผัดหมู ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0), (243, 17, 'ข้าวผัดกุ้ง เล็ก', '70', 0, 1, '', 1, 0, 0, 0, 0, 0), (244, 17, 'ข้าวผัดกุ้ง กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (245, 17, 'ข้าวผัดกุ้ง ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0), (246, 17, 'ข้าวผัดปู เล็ก', '70', 0, 1, '', 1, 0, 0, 0, 0, 0), (247, 17, 'ข้าวผัดปู กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (248, 17, 'ข้าวผัดปู ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0), (249, 17, ' ข้าวผัดไก่ เล็ก', '60', 0, 1, '', 1, 0, 0, 0, 0, 0), (250, 16, 'ยำไข่เยี่ยวม้า', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (251, 16, 'ยำไข่เค็ม', '89', 0, 1, '', 1, 0, 0, 0, 0, 0), (252, 17, 'ข้าวผัดไก่ กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (253, 17, 'ข้าวผัดไก่ ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0), (254, 17, 'ข้าวผัดรวม เล็ก', '70', 0, 1, '', 1, 0, 0, 0, 0, 0), (255, 17, 'ข้าวผัดรวม กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (256, 17, 'ข้าวผัดรวม ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0), (257, 17, 'ข้าวผัดทะเล เล็ก', '70', 0, 1, '', 1, 0, 0, 0, 0, 0), (258, 17, 'ข้าวผัดทะเล กลาง', '120', 0, 1, '', 1, 0, 0, 0, 0, 0), (259, 17, 'ข้าวผัดทะเล ใหญ่', '140', 0, 1, '', 1, 0, 0, 0, 0, 0); -- -- Dumping data for table `promotion` -- INSERT INTO `promotion` (`promotion_id`, `promotion_name`, `product_id`, `promotion_qty`, `promotion_status`, `isAlcohol`, `mixmax`, `time_start`, `time_end`) VALUES (1, 'Red Ltr.', 52, 1, 1, 1, 4, '00:00:00', '23:59:00'), (2, 'Blend 285. 70 ml. ', 190, 1, 1, 1, 4, '00:00:00', '23:59:00'), (3, 'Blend 285. Ltr. ', 147, 1, 1, 1, 4, '00:00:00', '23:59:00'), (4, 'Leo ', 59, 4, 1, 0, 0, '00:00:00', '23:59:00'), (5, 'Singha 500 ml. ', 58, 4, 1, 0, 0, '00:00:00', '23:59:00'), (6, 'Singlight', 221, 4, 1, 0, 0, '00:00:00', '23:59:00'), (7, 'โปรก่อนสามทุ่ม LEO', 228, 1, 1, 0, 0, '00:00:00', '21:00:00'), (8, 'โปรก่อนสามทุ่ม Singha', 229, 1, 1, 0, 0, '00:00:00', '21:00:00'), (9, 'โปรก่อนสามทุ่ม Singlight', 230, 1, 1, 0, 0, '00:00:00', '21:00:00'); -- -- Dumping data for table `promotion_detail` -- INSERT INTO `promotion_detail` (`promotion_detail_id`, `order_detail_id`, `product_id`, `product_qty`) VALUES (1, 7, 64, 4), (2, 8, 64, 1), (3, 8, 63, 1), (4, 8, 65, 1), (5, 8, 146, 1), (6, 10, 65, 1), (7, 10, 64, 1), (8, 10, 63, 1), (9, 10, 66, 1), (10, 11, 63, 1), (11, 11, 66, 1), (12, 11, 67, 1), (13, 11, 146, 1), (14, 46, 64, 2), (15, 46, 63, 2), (16, 55, 64, 1), (17, 55, 63, 3), (18, 145, 146, 1), (19, 145, 63, 7), (20, 147, 64, 2), (21, 147, 65, 3), (22, 147, 63, 2), (23, 147, 146, 1), (24, 173, 63, 2), (25, 173, 64, 3), (26, 173, 146, 1), (27, 173, 67, 1), (28, 173, 65, 1), (29, 174, 63, 3), (30, 174, 64, 4), (31, 174, 146, 1), (32, 204, 65, 2), (33, 204, 64, 2), (34, 204, 146, 1), (35, 204, 67, 1), (36, 204, 66, 1), (37, 204, 63, 1), (38, 278, 67, 2), (39, 278, 64, 2), (40, 278, 63, 1), (41, 278, 66, 1), (42, 278, 65, 1), (43, 278, 146, 1), (44, 321, 63, 2), (45, 321, 64, 2), (46, 333, 63, 4), (47, 333, 64, 4), (48, 339, 63, 2), (49, 339, 64, 2), (50, 358, 63, 2), (51, 358, 64, 2), (52, 366, 63, 2), (53, 366, 65, 2), (54, 366, 146, 1), (55, 366, 64, 2), (56, 366, 66, 1), (57, 371, 63, 1), (58, 371, 64, 1), (59, 371, 66, 1), (60, 371, 65, 1), (61, 382, 67, 1), (62, 382, 64, 1), (63, 382, 63, 1), (64, 382, 66, 1), (65, 385, 64, 3), (66, 385, 67, 1), (67, 385, 63, 4), (68, 392, 63, 2), (69, 392, 64, 2), (70, 401, 63, 3), (71, 401, 65, 1), (72, 401, 64, 2), (73, 401, 66, 2), (74, 405, 63, 3), (75, 405, 64, 1), (76, 409, 63, 3), (77, 409, 64, 1), (78, 415, 63, 3), (79, 415, 65, 1), (80, 416, 63, 1), (81, 416, 64, 3), (82, 6, 63, 1), (83, 6, 65, 1), (84, 6, 64, 1), (85, 6, 66, 1), (86, 15, 63, 1), (87, 15, 64, 1), (88, 15, 65, 1), (89, 15, 66, 1), (90, 7, 65, 1), (91, 7, 64, 1), (92, 7, 63, 1), (93, 7, 66, 1), (94, 78, 63, 4), (95, 155, 63, 4), (96, 162, 63, 2), (97, 162, 64, 2), (98, 172, 63, 2), (99, 172, 64, 2), (100, 180, 63, 2), (101, 180, 64, 2), (102, 186, 63, 3), (103, 186, 64, 1), (104, 218, 66, 2), (105, 218, 64, 2), (106, 233, 63, 3), (107, 233, 64, 1), (108, 16, 64, 1), (109, 16, 63, 3), (110, 17, 65, 1), (111, 17, 63, 3), (112, 8, 66, 1), (113, 8, 64, 1), (114, 8, 63, 2); -- -- Dumping data for table `staff` -- INSERT INTO `staff` (`staff_id`, `staff_code`, `staff_name`, `staff_password`, `staff_position`, `staff_status`) VALUES (2, 'admin', 'admin', '21232f297a57a5a743894a0e4a801fc3', 1, 1), (1234567897, '0001', 'ตูมตาม', '25bbdcd06c32d477f7fa1c3e4a91b032', 3, 1), (1234567948, '0000', 'สำหรับนักดนตรี', '4a7d1ed414474e4033ac29ccb8653d9b', 4, 1), (1234567906, '13001', 'ตอง', 'c0eab2dce3fc614a18251fb483e71dee', 3, 1), (1234567907, '12205', 'พี่เล็ก', 'b82b1c2afe93439b68c4a4945a27daf2', 3, 1), (1234567908, '12950', 'พี่ต้น', '15e69232b3bfbcce60261950230e734b', 3, 1), (1234567909, '12949', 'ป๊อป', '420c841038c492fed4d19999a813009d', 3, 1), (1234567920, '12207', 'เมอลี่', 'c8bfde373852a0ec6e7e532fd157a12f', 3, 1), (1234567943, '12209', 'ดุ๊ก', '747e32ab0fea7fbd2ad9ec03daa3f840', 3, 1), (1234567944, '12947', 'แพร', '16ad66b2d7d7eda19f34e2f6197e2236', 3, 1), (1234567945, '13003', 'เบล', '7881f1e0495cfb89d108dae7db90f763', 3, 1), (1234567946, '12945', 'เอ็ม ยุทธนา', 'f2d34fcd37e85f9867708bf71782cda6', 3, 1), (1234567947, '12957', 'เม่น', '8e0251b8f27dd86e04c9049a1eeda4a3', 3, 1), (1234567949, '9999', '99', 'fa246d0262c3925617b0c72bb20eeb1d', 3, 1), (1234567950, '12952', 'รุ้ง', '1eb93307694834407e339c29b71fa727', 3, 1), (1234567942, '12954', 'ใบเตย', 'ab96c631d50e81c5f961bcbf25e49475', 3, 1); -- -- Dumping data for table `table` -- INSERT INTO `table` (`table_id`, `table_name`, `order_id`, `table_status`) VALUES (1, '1', '1', 1), (2, '2', '2', 1), (3, '3', '3', 1), (4, '4', '', 0), (5, '5', '', 0), (6, '6', '', 0), (7, '7', '', 0), (8, '8', '', 0), (9, '9', '4', 1), (10, '10', '', 0), (11, '11', '', 0), (12, '12', '', 0), (13, '13', '', 0), (14, '14', '', 0), (15, '15', '', 0), (16, '16', '', 0), (17, '17', '', 0), (18, '18', '', 0), (19, '19', '', 0), (20, '20', '', 0), (21, '21', '', 0), (22, '22', '', 0), (23, '23', '', 0), (24, '24', '', 0), (25, '25', '', 0), (26, '26', '', 0), (27, '27', '', 0), (28, '28', '', 0), (29, '29', '', 0), (30, '30', '', 0), (31, '31', '', 0), (32, '32', '', 0), (33, '33', '', 0), (34, '34', '', 0), (35, '35', '', 0), (36, '36', '', 0), (37, '37', '', 0), (38, '38', '', 0), (39, '39', '', 0), (40, '40', '', 0), (42, '42', '', 0), (43, '43', '', 0), (44, '44', '', 0), (45, '45', '', 0), (46, '46', '', 0), (47, '47', '', 0), (48, '48', '', 0), (49, '49', '', 0), (50, '50', '', 0), (51, '51', '', 0), (52, '52', '', 0), (53, '53', '', 0), (54, '54', '', 0), (55, '55', '', 0), (56, '56', '', 0), (57, '57', '', 0), (58, '58', '', 0), (59, '59', '', 0), (60, '60', '', 0), (61, '61', '', 0), (62, '62', '', 0), (63, '63', '', 0), (64, '64', '', 0), (65, '65', '', 0), (66, '66', '', 0), (67, '67', '', 0), (68, '68', '', 0), (69, '69', '', 0), (70, '70', '', 0), (71, '71', '', 0), (249, '41', '', 0), (41, '72', '', 0), (73, '73', '', 0), (74, '74', '', 0), (75, '75', '', 0), (76, '76', '', 0), (77, '77', '', 0), (78, '78', '', 0), (79, '79', '', 0), (80, '80', '', 0), (81, '81', '', 0), (82, '82', '', 0), (83, '83', '', 0), (84, '84', '', 0), (85, '85', '', 0), (86, '86', '', 0), (87, '87', '', 0), (88, '88', '', 0), (89, '89', '', 0), (90, '90', '', 0);