/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50534
Source Host           : localhost:3306
Source Database       : hicom-multirestaurants

Target Server Type    : MYSQL
Target Server Version : 50534
File Encoding         : 65001

Date: 2018-10-12 15:39:41
*/


-- ----------------------------
-- Table structure for `banner`
-- ----------------------------
CREATE TABLE `banner` (
  `bannerId` int(11) NOT NULL AUTO_INCREMENT,
  `bannerName` varchar(100) NOT NULL,
  `bannerImage` varchar(100) NOT NULL,
  `shopId` int(11) NOT NULL,
  `status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`bannerId`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of banner
-- ----------------------------
INSERT INTO `banner` VALUES ('3', 'TestBanner', '1481708169.jpg', '41', '1');
INSERT INTO `banner` VALUES ('4', 'Banner2', '1481708150.jpg', '41', '1');
INSERT INTO `banner` VALUES ('9', 'banner 1', '1471666599.jpg', '39', '1');
INSERT INTO `banner` VALUES ('10', 'banner 2', '1471666637.jpg', '39', '1');
INSERT INTO `banner` VALUES ('11', 'abc', '1481709007.jpg', '45', '1');
INSERT INTO `banner` VALUES ('12', 'banner1', '1481705897.jpg', '43', '1');
INSERT INTO `banner` VALUES ('14', 'banner2', '1481705946.jpg', '43', '1');
INSERT INTO `banner` VALUES ('15', 'banner1', '1481706636.jpg', '38', '1');
INSERT INTO `banner` VALUES ('16', 'banner2', '1481706658.jpg', '38', '1');
INSERT INTO `banner` VALUES ('17', 'banner3', '1481706800.jpg', '38', '1');
INSERT INTO `banner` VALUES ('18', 'banner2', '1481709027.jpg', '45', '1');
INSERT INTO `banner` VALUES ('19', 'banner3', '1481709087.jpg', '45', '1');
INSERT INTO `banner` VALUES ('20', 'banner2', '1481709250.jpg', '40', '1');
INSERT INTO `banner` VALUES ('21', 'banner1', '1481709278.jpg', '40', '1');
INSERT INTO `banner` VALUES ('22', 'birthday banner', '1481774267.jpg', '49', '1');
INSERT INTO `banner` VALUES ('23', 'Restaurant', '1505745312.jpg', '59', '1');
INSERT INTO `banner` VALUES ('25', 'banner pucu', '1506910379.jpg', '60', '1');
INSERT INTO `banner` VALUES ('26', 'Pizza', '1515768872.png', '61', '1');
INSERT INTO `banner` VALUES ('27', 'pizza', '1522254295.png', '63', '1');
INSERT INTO `banner` VALUES ('28', 'welcome ', '1537874005.jpg', '68', '1');

-- ----------------------------
-- Table structure for `city`
-- ----------------------------
CREATE TABLE `city` (
  `cityId` int(11) NOT NULL AUTO_INCREMENT,
  `cityPostCode` varchar(20) NOT NULL,
  `cityName` varchar(100) NOT NULL,
  PRIMARY KEY (`cityId`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of city
-- ----------------------------
INSERT INTO `city` VALUES ('1', '560', 'Bangalore');
INSERT INTO `city` VALUES ('16', 'AZ1', 'Poplar');
INSERT INTO `city` VALUES ('17', '230', 'Port Louis');
INSERT INTO `city` VALUES ('18', '043', 'Ha Noi');
INSERT INTO `city` VALUES ('19', '083', 'Ho Chi Minh');
INSERT INTO `city` VALUES ('20', '040', 'Bac Ninh');
INSERT INTO `city` VALUES ('21', '041', 'Vinh Phuc');
INSERT INTO `city` VALUES ('22', '458', 'Singapore');
INSERT INTO `city` VALUES ('23', 'A50', 'Tel Aviv');
INSERT INTO `city` VALUES ('24', 'C51', 'Ramat Gan');
INSERT INTO `city` VALUES ('25', '122018', 'Gurgaon');
INSERT INTO `city` VALUES ('26', '831001', 'JAMSHEDPUR');
INSERT INTO `city` VALUES ('27', '77400000', 'Gurupi');
INSERT INTO `city` VALUES ('28', '04678010', 'Sao Paulo');
INSERT INTO `city` VALUES ('29', '3130', 'Melbourne');
INSERT INTO `city` VALUES ('30', '3100', 'Sydney');
INSERT INTO `city` VALUES ('31', '051', 'LIMA');
INSERT INTO `city` VALUES ('32', '38000', 'Faisalabad');
INSERT INTO `city` VALUES ('33', '49020490', 'Aracaju');
INSERT INTO `city` VALUES ('34', '88100', 'kota kinabalu');
INSERT INTO `city` VALUES ('35', '686', 'KUMASI');
INSERT INTO `city` VALUES ('36', '218', 'benghazi');

-- ----------------------------
-- Table structure for `comment`
-- ----------------------------
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` int(11) NOT NULL,
  `food_id` int(11) NOT NULL,
  `account_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `content` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `rate` float(4,2) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('4', '41', '6', 'hdjdj', '', 'Hdjdhd', '4.33', '2015-12-15 13:51:03');
INSERT INTO `comment` VALUES ('5', '40', '5', 'Pham Manh Cuong', '', '0912312308', '10.00', '2015-12-17 14:32:44');
INSERT INTO `comment` VALUES ('6', '40', '5', 'gbb', '', 'Cachko', '3.58', '2015-12-17 15:10:19');
INSERT INTO `comment` VALUES ('7', '41', '6', 'fighters', '', ' Shells fklsd', '10.00', '2015-12-17 16:34:30');
INSERT INTO `comment` VALUES ('8', '41', '6', 'f ads d', '', ' Afar s', '10.00', '2015-12-17 16:35:59');
INSERT INTO `comment` VALUES ('9', '40', '12', 'fix ', '', ' Ft fgfcgf', '10.00', '2015-12-17 17:26:48');
INSERT INTO `comment` VALUES ('10', '41', '6', '1', '', '2', '10.00', '2015-12-17 19:25:43');
INSERT INTO `comment` VALUES ('11', '41', '6', '3', '', '4', '10.00', '2015-12-17 19:25:54');
INSERT INTO `comment` VALUES ('12', '41', '6', '5', '', 'The &quot; entity was mistakenly omitted from the HTML 3.2 specification. While use of &quot; generates error reports when validating against 3.2, browsers have continued to recognize the entity and its use is generally safe (sticklers may wish to use &#34; instead). The omission has been corrected in the HTML 4.0 specification.', '10.00', '2015-12-17 19:26:03');
INSERT INTO `comment` VALUES ('13', '40', '12', 'đầu', '', 'Fsdfsfsd', '10.00', '2015-12-17 20:33:56');
INSERT INTO `comment` VALUES ('14', '40', '12', 'Đà', '', 'Fsfs', '10.00', '2015-12-17 20:34:04');
INSERT INTO `comment` VALUES ('15', '40', '12', 'chin', '', 'Chim', '10.00', '2015-12-17 21:40:01');
INSERT INTO `comment` VALUES ('16', '41', '6', 'Pham Manh Cuong', '', 'Very good', '10.00', '2015-12-18 11:37:25');
INSERT INTO `comment` VALUES ('17', '41', '6', 'ghh', '', 'Fight', '6.00', '2015-12-22 10:51:15');
INSERT INTO `comment` VALUES ('18', '41', '7', 'tvvbggg', '', 'Gbyogmb', '10.00', '2015-12-22 10:52:22');
INSERT INTO `comment` VALUES ('19', '40', '5', 'hieu', '', 'Very good', '10.00', '2016-05-16 14:36:45');
INSERT INTO `comment` VALUES ('20', '40', '5', 'haha', '', 'Nhu shit', '10.00', '2016-06-25 09:55:20');
INSERT INTO `comment` VALUES ('21', '40', '13', 'huybkaptech@gmail.com', 'dummy', 'good food', '10.00', '2016-06-25 10:27:29');
INSERT INTO `comment` VALUES ('22', '38', '1', 'mango1', 'dummy', 'good food', '10.00', '2016-06-25 11:48:49');
INSERT INTO `comment` VALUES ('23', '38', '1', 'mango1', 'dummy', 'good drink', '10.00', '2016-06-25 11:50:37');
INSERT INTO `comment` VALUES ('24', '38', '1', 'mango1', 'dummy', 'good drink', '10.00', '2016-06-25 11:50:38');
INSERT INTO `comment` VALUES ('25', '40', '5', 'fudu', '', 'Fhdjd', '9.67', '2016-06-25 15:16:45');
INSERT INTO `comment` VALUES ('26', '40', '13', 'mango1', 'dummy', 'g', '10.00', '2016-08-06 18:35:07');
INSERT INTO `comment` VALUES ('27', '40', '13', 'aaaa', 'dummy', 'baguus', '8.00', '2016-08-15 20:52:40');
INSERT INTO `comment` VALUES ('28', '40', '13', 'aaaa', 'dummy', 'baguus', '8.00', '2016-08-15 20:52:42');
INSERT INTO `comment` VALUES ('29', '40', '13', 'aaaa', 'dummy', 'apik', '10.00', '2016-08-15 20:53:11');
INSERT INTO `comment` VALUES ('30', '40', '13', 'aaaa', 'dummy', 'apik', '10.00', '2016-08-15 20:53:13');
INSERT INTO `comment` VALUES ('31', '40', '13', 'aaaa', 'dummy', 'apik', '10.00', '2016-08-15 20:53:13');
INSERT INTO `comment` VALUES ('32', '40', '13', 'aaaa', 'dummy', 'apik', '10.00', '2016-08-15 20:53:13');
INSERT INTO `comment` VALUES ('33', '40', '13', 'aaaa', 'dummy', 'apik', '10.00', '2016-08-15 20:53:13');
INSERT INTO `comment` VALUES ('34', '41', '6', 'mango1', 'dummy', 'great', '10.00', '2016-08-20 15:09:05');
INSERT INTO `comment` VALUES ('35', '41', '24', 'mango1', 'dummy', 'good drink!', '10.00', '2016-08-20 15:25:51');
INSERT INTO `comment` VALUES ('36', '38', '1', 'mango1', 'dummy', 'great', '10.00', '2016-08-20 15:28:24');
INSERT INTO `comment` VALUES ('37', '38', '1', 'mango1', 'dummy', 'awesome!', '10.00', '2016-08-20 15:28:43');
INSERT INTO `comment` VALUES ('38', '38', '1', 'mango1', 'dummy', 'delicious', '10.00', '2016-08-20 15:29:37');
INSERT INTO `comment` VALUES ('39', '41', '6', 'mango1', 'dummy', 'super great.', '10.00', '2016-08-20 15:46:26');
INSERT INTO `comment` VALUES ('40', '41', '6', 'huy pham', 'dummy', 'good drink', '10.00', '2016-08-20 16:00:36');
INSERT INTO `comment` VALUES ('41', '43', '19', 'Arun', 'dummy', 'i like', '10.00', '2016-08-29 16:41:30');
INSERT INTO `comment` VALUES ('42', '43', '19', 'John', 'dummy', 'Good', '10.00', '2016-08-29 16:41:32');
INSERT INTO `comment` VALUES ('43', '43', '19', 'Tony', 'dummy', 'delicious ', '10.00', '2016-08-29 16:41:33');
INSERT INTO `comment` VALUES ('44', '43', '19', 'Harry', 'dummy', 'i like', '10.00', '2016-08-29 16:41:33');
INSERT INTO `comment` VALUES ('45', '41', '6', 'admin', 'dummy', 'vvc. g', '10.00', '2016-09-15 17:39:49');
INSERT INTO `comment` VALUES ('46', '41', '6', 'admin', 'dummy', 'vvc. g', '10.00', '2016-09-15 17:39:52');
INSERT INTO `comment` VALUES ('47', '38', '1', 'van', 'dummy', 'rdtf', '2.00', '2016-09-21 13:57:53');
INSERT INTO `comment` VALUES ('48', '43', '20', 'Chris', 'dummy', 'Fresh', '2.00', '2016-09-21 14:56:34');
INSERT INTO `comment` VALUES ('49', '43', '20', 'Steve', 'dummy', 'Fresh', '6.00', '2016-09-21 14:57:13');
INSERT INTO `comment` VALUES ('50', '43', '20', 'Abel', 'dummy', 'Tasty ', '6.00', '2016-09-21 14:57:14');
INSERT INTO `comment` VALUES ('51', '43', '20', 'James', 'dummy', 'Fresh', '2.00', '2016-09-21 14:58:13');
INSERT INTO `comment` VALUES ('52', '43', '22', 'Kenedy', 'dummy', 'delicious ', '6.00', '2016-09-22 09:15:10');
INSERT INTO `comment` VALUES ('53', '43', '22', 'Tim', 'dummy', 'tasty ', '6.00', '2016-09-22 09:15:12');
INSERT INTO `comment` VALUES ('58', '45', '27', 'van', 'dummy', 'yyhj', '4.00', '2016-09-22 09:57:18');
INSERT INTO `comment` VALUES ('59', '45', '27', 'van', 'dummy', 'yyhj', '4.00', '2016-09-22 09:57:19');
INSERT INTO `comment` VALUES ('60', '41', '6', 'van', 'dummy', 'rtg', '4.00', '2016-09-22 13:39:23');
INSERT INTO `comment` VALUES ('64', '45', '27', 'pth', 'dummy', 'gygugvhb7ouubfygygypinugug6gg6cytctd6t', '2.00', '2016-09-22 14:14:53');
INSERT INTO `comment` VALUES ('65', '45', '27', 'pth', 'dummy', 'gygugvhb7ouubfygygypinugug6gg6cytctd6t', '2.00', '2016-09-22 14:14:54');
INSERT INTO `comment` VALUES ('68', '41', '6', 'agsr', 'dummy', 'frfvrg bdghmmyj,hfku.kfu.outo.yriktmsustmu', '10.00', '2016-09-22 14:57:59');
INSERT INTO `comment` VALUES ('69', '45', '27', 'ftt', 'dummy', 'tctftf', '10.00', '2016-09-22 15:09:23');
INSERT INTO `comment` VALUES ('70', '39', '17', 'van', 'dummy', 'ghrhduebs', '10.00', '2016-09-22 17:13:17');
INSERT INTO `comment` VALUES ('71', '39', '17', 'van', 'dummy', 'ghrhduebs', '10.00', '2016-09-22 17:13:19');
INSERT INTO `comment` VALUES ('72', '39', '18', 'shyam', 'dummy', 'not bad', '4.00', '2016-11-29 15:24:56');
INSERT INTO `comment` VALUES ('73', '38', '28', 'shyam', 'dummy', 'good', '4.00', '2016-11-29 15:26:38');
INSERT INTO `comment` VALUES ('74', '38', '28', 'sa', 'dummy', 'good', '8.00', '2016-12-10 02:42:19');
INSERT INTO `comment` VALUES ('75', '43', '20', 'Jame', 'dummy', 'good', '10.00', '2016-12-16 21:28:33');
INSERT INTO `comment` VALUES ('76', '43', '20', 'Jame', 'dummy', 'good', '10.00', '2016-12-16 21:28:34');
INSERT INTO `comment` VALUES ('77', '43', '23', 'James', 'dummy', 'good', '8.00', '2016-12-16 23:13:39');
INSERT INTO `comment` VALUES ('78', '43', '20', 'Harry', 'dummy', 'good', '10.00', '2016-12-16 23:30:08');
INSERT INTO `comment` VALUES ('79', '43', '19', 'sagrawa@gmail.com', 'dummy', 'dooooooo McCool', '8.00', '2016-12-19 13:19:23');
INSERT INTO `comment` VALUES ('80', '43', '19', 'sagrawa@gmail.com', 'dummy', 'dooooooo McCool', '8.00', '2016-12-19 13:19:25');
INSERT INTO `comment` VALUES ('81', '47', '7', 'Hicom David', '', 'I like this product. Very delicious!', '5.12', '2016-12-19 13:33:21');
INSERT INTO `comment` VALUES ('82', '41', '24', 'Hicom Harry', '', 'I like this product. Very delicious!', '4.50', '2016-12-19 14:22:28');
INSERT INTO `comment` VALUES ('83', '52', '32', 'outlaw', 'dummy', 'malla hargma eddawa5', '10.00', '2017-02-05 21:13:31');
INSERT INTO `comment` VALUES ('84', '38', '30', 'das', 'dummy', 'testing', '8.00', '2017-03-02 12:34:43');
INSERT INTO `comment` VALUES ('85', '38', '29', 'gjvg', 'dummy', 'thbv', '10.00', '2017-03-13 16:56:06');
INSERT INTO `comment` VALUES ('86', '38', '28', 'tttt', 'dummy', 'good', '8.00', '2017-03-25 12:46:35');
INSERT INTO `comment` VALUES ('87', '38', '28', 'tttt', 'dummy', 'good', '8.00', '2017-03-25 12:46:37');
INSERT INTO `comment` VALUES ('88', '38', '28', 'tttt', 'dummy', 'good', '8.00', '2017-03-25 12:46:37');
INSERT INTO `comment` VALUES ('89', '43', '20', 'bhim', 'dummy', '2', '10.00', '2017-04-24 15:51:05');
INSERT INTO `comment` VALUES ('90', '43', '20', 'bhim', 'dummy', '2', '10.00', '2017-04-24 15:51:06');
INSERT INTO `comment` VALUES ('91', '52', '32', 'luispucutay', 'dummy', 'jdjdkks', '10.00', '2017-07-08 02:45:49');
INSERT INTO `comment` VALUES ('92', '52', '32', 'luispucutay', 'dummy', 'jdjdkks', '10.00', '2017-07-08 02:45:51');
INSERT INTO `comment` VALUES ('93', '52', '32', 'luispucutay', 'dummy', 'jdjdkks', '10.00', '2017-07-08 02:45:51');
INSERT INTO `comment` VALUES ('94', '38', '29', 'saint_silver17@hotmail.com', 'dummy', 'nice', '10.00', '2017-07-22 13:18:39');
INSERT INTO `comment` VALUES ('95', '48', '14', 'Anushka Sharma', '', 'Good', '7.31', '2017-07-28 00:18:48');
INSERT INTO `comment` VALUES ('96', '39', '17', 'truing', 'dummy', 'hia', '10.00', '2017-08-03 15:50:27');
INSERT INTO `comment` VALUES ('97', '38', '29', 'fudhdhd', 'dummy', 'd77rr', '10.00', '2017-08-03 17:14:12');
INSERT INTO `comment` VALUES ('98', '38', '29', 'dududi', 'dummy', 'jfufufi', '10.00', '2017-08-11 14:49:53');
INSERT INTO `comment` VALUES ('99', '43', '22', 'hicom.register@gmail.com', 'dummy', 'cucifuf', '10.00', '2017-08-11 15:46:53');
INSERT INTO `comment` VALUES ('100', '38', '29', 'hebdh', 'dummy', 'dhhdhr', '10.00', '2017-08-11 17:33:26');
INSERT INTO `comment` VALUES ('101', '38', '29', 'hebdh', 'dummy', 'dhhdhr', '10.00', '2017-08-11 17:33:28');
INSERT INTO `comment` VALUES ('102', '59', '38', 'momo', 'dummy', 'nice', '8.00', '2017-09-18 22:35:12');
INSERT INTO `comment` VALUES ('103', '43', '33', 'yasser', 'dummy', 'tasty', '8.00', '2017-10-04 14:29:16');
INSERT INTO `comment` VALUES ('104', '43', '33', 'yasser', 'dummy', 'tasty', '8.00', '2017-10-04 14:29:18');
INSERT INTO `comment` VALUES ('105', '38', '28', 'Hassan', 'dummy', 'good', '10.00', '2017-10-25 22:20:19');
INSERT INTO `comment` VALUES ('106', '38', '29', 'test', 'dummy', 'شغل عجيب', '10.00', '2017-11-13 22:33:23');
INSERT INTO `comment` VALUES ('107', '38', '29', 'test', 'dummy', 'شغل عجيب', '10.00', '2017-11-13 22:33:25');
INSERT INTO `comment` VALUES ('108', '38', '29', 'test', 'dummy', 'شغل عجيب', '10.00', '2017-11-13 22:33:25');
INSERT INTO `comment` VALUES ('109', '38', '29', 'test', 'dummy', 'شغل عجيب', '10.00', '2017-11-13 22:33:25');
INSERT INTO `comment` VALUES ('110', '38', '29', 'جدو', 'dummy', 'بايخ', '10.00', '2017-11-13 22:33:47');
INSERT INTO `comment` VALUES ('111', '38', '29', 'khalil', 'dummy', 'good', '10.00', '2017-11-29 17:23:54');
INSERT INTO `comment` VALUES ('112', '38', '29', 'khalil', 'dummy', 'good', '10.00', '2017-11-29 17:23:56');
INSERT INTO `comment` VALUES ('113', '38', '29', 'khalil', 'dummy', 'good', '10.00', '2017-11-29 17:23:56');
INSERT INTO `comment` VALUES ('114', '38', '29', 'hung', 'dummy', 'like', '10.00', '2017-12-12 09:23:13');
INSERT INTO `comment` VALUES ('115', '38', '29', 'hung', 'dummy', 'like', '10.00', '2017-12-12 09:23:14');
INSERT INTO `comment` VALUES ('116', '38', '28', 'tester', 'dummy', 'verry good', '10.00', '2017-12-19 15:10:23');
INSERT INTO `comment` VALUES ('117', '38', '28', 'tester', 'dummy', 'verry good', '10.00', '2017-12-19 15:10:25');
INSERT INTO `comment` VALUES ('118', '46', '1', 'marcelo', 'dummy', 'uma bosta', '10.00', '2018-01-11 09:58:28');
INSERT INTO `comment` VALUES ('119', '61', '40', 'Marcelo', 'dummy', 'muito bom', '10.00', '2018-01-12 22:00:05');
INSERT INTO `comment` VALUES ('120', '61', '40', 'Marcelo', 'dummy', 'muito bom', '10.00', '2018-01-12 22:00:07');
INSERT INTO `comment` VALUES ('121', '43', '23', '786gurwinder@gmail.com', 'dummy', 'Great drink', '10.00', '2018-02-19 14:57:17');
INSERT INTO `comment` VALUES ('122', '43', '23', '786gurwinder@gmail.com', 'dummy', 'Great drink', '10.00', '2018-02-19 14:57:19');
INSERT INTO `comment` VALUES ('123', '43', '19', 'cc', '', 'Vvvvvv', '10.00', '2018-04-14 12:29:35');
INSERT INTO `comment` VALUES ('124', '38', '29', 'DAN', '', 'Very Tasteful!', '10.00', '2018-05-18 01:07:26');
INSERT INTO `comment` VALUES ('125', '38', '29', 'DAN ', '', 'REVIEW- 5 STARS', '10.00', '2018-05-18 01:07:55');
INSERT INTO `comment` VALUES ('126', '38', '29', 'DANDOBROTA', '', 'QUITE SWEET FOR ME', '3.25', '2018-06-01 08:58:03');
INSERT INTO `comment` VALUES ('127', '38', '29', 'DANDOBROTA', '', 'HAS ANYONE ORDERED? ANY TIPS?', '10.00', '2018-06-01 08:58:41');
INSERT INTO `comment` VALUES ('128', '38', '30', 'DANDOBROTA', '', 'Test', '10.00', '2018-06-01 08:59:32');
INSERT INTO `comment` VALUES ('129', '38', '30', 'DANDOBROTA', '', 'TEST2', '10.00', '2018-06-01 08:59:45');
INSERT INTO `comment` VALUES ('130', '38', '30', 'DANDOBROTA', '', 'PRICEY...', '10.00', '2018-06-01 09:00:06');
INSERT INTO `comment` VALUES ('131', '38', '30', 'DANDOBROTA', '', 'TEST', '10.00', '2018-06-01 09:00:24');
INSERT INTO `comment` VALUES ('132', '38', '29', 'DANDOBROTA', '', 'Test\n', '10.00', '2018-06-01 09:02:04');
INSERT INTO `comment` VALUES ('133', '38', '28', 'gff', 'dummy', 'yy', '10.00', '2018-07-25 16:20:59');
INSERT INTO `comment` VALUES ('134', '38', '28', 'gff', 'dummy', 'yy', '10.00', '2018-07-25 16:21:01');
INSERT INTO `comment` VALUES ('135', '41', '24', 'h', 'dummy', 'rgj', '6.00', '2018-09-12 12:16:04');
INSERT INTO `comment` VALUES ('136', '41', '24', 'h', 'dummy', 'rgj', '6.00', '2018-09-12 12:16:06');

-- ----------------------------
-- Table structure for `datetb`
-- ----------------------------
CREATE TABLE `datetb` (
  `dateId` int(11) NOT NULL AUTO_INCREMENT,
  `dateName` varchar(20) DEFAULT NULL,
  `fullDateName` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`dateId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of datetb
-- ----------------------------
INSERT INTO `datetb` VALUES ('1', 'sun', 'Sunday');
INSERT INTO `datetb` VALUES ('2', 'mon', 'Monday');
INSERT INTO `datetb` VALUES ('3', 'tue', 'Tuesday');
INSERT INTO `datetb` VALUES ('4', 'wed', 'Wednesday');
INSERT INTO `datetb` VALUES ('5', 'thu', 'Thusday');
INSERT INTO `datetb` VALUES ('6', 'fri', 'Friday');
INSERT INTO `datetb` VALUES ('7', 'sat', 'Saturday');

-- ----------------------------
-- Table structure for `feedback`
-- ----------------------------
CREATE TABLE `feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `tittle` text NOT NULL,
  `description` text NOT NULL,
  `created` datetime NOT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(1) NOT NULL DEFAULT '1',
  `note` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of feedback
-- ----------------------------
INSERT INTO `feedback` VALUES ('6', '1450176364', 'bug tie', 'bug jcjc', '2016-01-19 16:15:27', '1', '2', '');
INSERT INTO `feedback` VALUES ('7', '1450176364', 'bug tie', 'bug jcjc', '2016-01-19 16:15:32', '1', '2', '');
INSERT INTO `feedback` VALUES ('8', '1450176364', 'demo', 'ndjdjdd', '2016-01-19 17:49:32', '1', '2', '');
INSERT INTO `feedback` VALUES ('9', '1450176364', 'demo', 'ndjdjdd', '2016-01-19 17:50:47', '0', '2', '');
INSERT INTO `feedback` VALUES ('10', '1450176364', 'title', '0912312308', '2016-01-21 15:08:27', '0', '1', '');
INSERT INTO `feedback` VALUES ('11', '1450176364', 'nice to meet you', 'deacription', '2016-01-21 15:18:25', '0', '1', '');
INSERT INTO `feedback` VALUES ('12', '1450176364', 'alo', 'hfjfhff', '2016-01-21 15:18:56', '0', '1', '');
INSERT INTO `feedback` VALUES ('13', '1450176364', 'alo', 'hfjfhff', '2016-01-21 15:19:09', '0', '1', '');
INSERT INTO `feedback` VALUES ('15', '1450162397', 'Shahs', 'Shah', '2016-01-21 15:48:28', '0', '1', '');
INSERT INTO `feedback` VALUES ('16', '1450162397', 'Shahs be', 'Shahs', '2016-01-21 15:48:55', '0', '2', '');
INSERT INTO `feedback` VALUES ('17', '1450162397', 'Shah', 'Shan', '2016-01-21 15:50:32', '0', '2', '');
INSERT INTO `feedback` VALUES ('18', '1450176364', 'Report Bizpro TelAviv (ID:43)', 'demo', '2016-01-21 16:47:35', '0', '2', '');
INSERT INTO `feedback` VALUES ('19', '1414741099', 'Report Bizpro TelAviv (ID:43)', 'Hah', '2016-01-21 17:27:17', '0', '2', '');
INSERT INTO `feedback` VALUES ('20', '1414741099', 'aaaa', 'bbbbbb', '2016-01-21 17:32:17', '0', '1', '');
INSERT INTO `feedback` VALUES ('22', '1414741099', 'Report Bizpro TelAviv (ID:43)', 'alo', '2016-01-21 17:33:41', '0', '2', '');
INSERT INTO `feedback` VALUES ('23', '1414741099', 'day la feedback', 'noi dung cua feedback', '2016-01-22 14:50:46', '0', '1', '');
INSERT INTO `feedback` VALUES ('24', '1414741099', 'day la bug', 'mo ta ve bug', '2016-01-22 14:52:15', '0', '3', '');
INSERT INTO `feedback` VALUES ('25', '1414741099', 'Report Bizpro TelAviv (ID:43)', 'do dong nat', '2016-01-22 14:52:54', '0', '2', '');
INSERT INTO `feedback` VALUES ('26', '1463383743', 'Report Garden Coffee (ID:41)', 'Cho cai report cho chet mia m di', '2016-06-25 09:53:24', '0', '2', '');
INSERT INTO `feedback` VALUES ('27', '1432968757', 'test feedback_huy', 'djdjdj', '2016-06-25 10:15:27', '0', '1', '');
INSERT INTO `feedback` VALUES ('28', '1466830013', 'Report Pizza Hut (ID:39)', 'bug roi', '2016-06-25 14:25:46', '0', '2', '');
INSERT INTO `feedback` VALUES ('29', '1450162397', 'Feed back he', 'Hehehehe', '2016-07-12 15:05:36', '0', '1', '');
INSERT INTO `feedback` VALUES ('30', '1450162397', 'Report Garden Coffee (ID:41)', 'Report may', '2016-07-12 15:05:53', '0', '1', '');
INSERT INTO `feedback` VALUES ('31', '1450162397', 'Bug nigiri qua', 'Fdfd', '2016-07-12 15:07:49', '0', '3', '');
INSERT INTO `feedback` VALUES ('32', '1471161616', 'cuuk', 'ancuuk', '2016-08-14 23:21:24', '0', '1', '');
INSERT INTO `feedback` VALUES ('33', '1466830013', 'abc shop', 'good services', '2016-08-20 15:11:06', '0', '1', '');
INSERT INTO `feedback` VALUES ('34', '1474442344', 'Report Bizpro TelAviv (ID:43)', 'trŕrt', '2016-09-21 14:54:40', '0', '2', '');
INSERT INTO `feedback` VALUES ('35', '1474527670', 'dtt', '5uu', '2016-09-22 14:04:14', '0', '1', '');
INSERT INTO `feedback` VALUES ('36', '1474527670', 'Report abc (ID:45)', 'fhjhf', '2016-09-22 14:17:08', '0', '2', '');
INSERT INTO `feedback` VALUES ('37', '1474527670', 'rtterr', 't6r', '2016-09-22 14:18:08', '0', '3', '');
INSERT INTO `feedback` VALUES ('39', '1474442344', 'kuggyjjyf', 'mghghj', '2016-09-22 15:48:47', '0', '1', '');
INSERT INTO `feedback` VALUES ('40', '1474442344', 'khggmhgmh', 'ghgh iyjh', '2016-09-22 15:50:00', '0', '1', '');
INSERT INTO `feedback` VALUES ('42', '1480278690', 'test', 'test', '2016-11-30 12:55:59', '2', '1', '');
INSERT INTO `feedback` VALUES ('43', '1501068891', 'Report Mapple (ID:47)', 'Good', '2017-07-28 23:57:03', '0', '1', '');
INSERT INTO `feedback` VALUES ('44', '1501755287', 'Report Bizpro TelAviv (ID:43)', 'hdhehdj', '2017-08-03 18:06:08', '0', '2', '');
INSERT INTO `feedback` VALUES ('45', '1450176364', 'zgdyeusfufufi', 'JFK\'s r', '2017-08-11 14:58:08', '0', '3', '');
INSERT INTO `feedback` VALUES ('46', '1450176364', 'Report Pizza Hut (ID:39)', 'c', '2017-08-11 15:08:27', '0', '2', '');
INSERT INTO `feedback` VALUES ('47', '1450176364', 'Report Royal Restauran (ID:45)', 'hxudud', '2017-08-11 15:45:20', '0', '2', '');
INSERT INTO `feedback` VALUES ('48', '1450176364', 'Report Pizza Hut (ID:39)', 'ngon', '2017-08-11 17:34:47', '0', '2', '');
INSERT INTO `feedback` VALUES ('49', '1502457075', 'Eed', 'Wsdfj', '2017-08-11 20:12:55', '0', '3', '');
INSERT INTO `feedback` VALUES ('50', '1511877396', 'Test', 'Good job ', '2017-11-28 20:57:39', '0', '1', '');
INSERT INTO `feedback` VALUES ('51', '1512014134', 'HiCom', 'HiCom', '2017-11-30 10:55:53', '0', '1', '');
INSERT INTO `feedback` VALUES ('52', '1513682441', 'hi', 'gud app', '2017-12-19 18:23:31', '0', '1', '');
INSERT INTO `feedback` VALUES ('53', '1515616435', 'tesye', 'shshs', '2018-01-12 22:03:22', '0', '1', '');
INSERT INTO `feedback` VALUES ('54', '1515616435', 'vjgvj', 'jjcjc', '2018-01-16 09:29:24', '0', '1', '');
INSERT INTO `feedback` VALUES ('55', '1526563359', 'Report Bizpro TelAviv (ID:43)', 'Vuvbvubuvu', '2018-05-17 20:26:58', '0', '1', '');
INSERT INTO `feedback` VALUES ('56', '0', 'sahane', 'menemende domatesler sahane', '2018-06-06 21:25:16', '0', '1', '');
INSERT INTO `feedback` VALUES ('57', '1534826995', 'huy', 'nhìn như oder thức ăn cho trẻ em ý hihi', '2018-08-21 11:52:37', '0', '1', '');
INSERT INTO `feedback` VALUES ('58', '1534826995', 'hello', 'chưa ra bug', '2018-08-21 11:52:59', '0', '3', '');

-- ----------------------------
-- Table structure for `finance`
-- ----------------------------
CREATE TABLE `finance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopId` varchar(255) DEFAULT NULL,
  `budget` float DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of finance
-- ----------------------------
INSERT INTO `finance` VALUES ('1', '41', '25', '2017-08-01 13:43:42', '1');
INSERT INTO `finance` VALUES ('2', '40', '523', '2015-12-14 13:37:30', '1');
INSERT INTO `finance` VALUES ('3', '38', '103', '2017-08-22 22:24:00', '1');
INSERT INTO `finance` VALUES ('4', '43', '237', '2017-08-22 22:03:41', '1');
INSERT INTO `finance` VALUES ('5', '52', '12', '2017-02-05 21:08:49', '1');
INSERT INTO `finance` VALUES ('6', '45', '4', '2017-08-01 13:30:56', '1');
INSERT INTO `finance` VALUES ('7', '47', '400', '2017-09-16 18:08:38', '1');
INSERT INTO `finance` VALUES ('8', '39', '30', '2017-12-19 18:32:30', '1');
INSERT INTO `finance` VALUES ('9', '61', '39.9', '2018-01-12 22:05:21', '1');

-- ----------------------------
-- Table structure for `financehistory`
-- ----------------------------
CREATE TABLE `financehistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ownerId` varchar(20) DEFAULT NULL,
  `amount` float(20,2) DEFAULT NULL,
  `createdTime` datetime DEFAULT NULL,
  `approvedTime` datetime DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of financehistory
-- ----------------------------

-- ----------------------------
-- Table structure for `financeowner`
-- ----------------------------
CREATE TABLE `financeowner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ownerId` varchar(20) DEFAULT NULL,
  `budget` float(20,2) DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of financeowner
-- ----------------------------
INSERT INTO `financeowner` VALUES ('1', '1397811111', '558.00', '2017-12-19 18:32:30', '1');
INSERT INTO `financeowner` VALUES ('2', '1397811112', '103.00', '2017-08-22 22:24:00', '1');
INSERT INTO `financeowner` VALUES ('3', '1432968683', '661.00', '2017-09-16 18:08:38', '1');
INSERT INTO `financeowner` VALUES ('4', '1486302177', '12.00', '2017-02-05 21:08:49', '1');
INSERT INTO `financeowner` VALUES ('5', '1414741099', '39.90', '2018-01-12 22:05:21', '1');

-- ----------------------------
-- Table structure for `food`
-- ----------------------------
CREATE TABLE `food` (
  `food_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `food_code` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `food_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `food_price` double DEFAULT NULL,
  `food_thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `food_small_thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `food_menus` int(11) NOT NULL,
  `food_desc` text COLLATE utf8_unicode_ci NOT NULL,
  `status_in_day` tinyint(1) NOT NULL DEFAULT '1',
  `food_event_cost` double DEFAULT NULL,
  `food_event_start_time` datetime DEFAULT NULL,
  `food_event_end_time` datetime DEFAULT NULL,
  `food_event_thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `lang` tinyint(1) DEFAULT NULL,
  `available` tinyint(1) DEFAULT NULL,
  `rate` float(4,2) DEFAULT NULL,
  `rate_times` int(11) DEFAULT NULL,
  PRIMARY KEY (`food_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of food
-- ----------------------------
INSERT INTO `food` VALUES ('1', 'A9999', 'Siro', '46', '99', '1443423872.jpg', null, '30', 'Siro description.', '1', null, null, null, null, '1', null, '1', '9.00', '8');
INSERT INTO `food` VALUES ('3', 'TB22K', 'Orange juice', '46', '22', '1443423724.jpg', null, '30', 'Orange juice is the liquid extract of the fruit of the orange tree.', '1', null, null, null, null, '1', null, '1', null, '0');
INSERT INTO `food` VALUES ('5', 'MK9', 'Grilled Squid', '46', '123', '1432633468.jpg', null, '28', 'Grilled squid  very delicious.', '1', null, null, null, null, '1', null, '1', '8.65', '5');
INSERT INTO `food` VALUES ('6', '1', 'Milk Coffee', '47', '10', '1443424192.jpg', null, '30', 'Very delicious.', '1', null, null, null, null, '1', null, '1', '8.96', '15');
INSERT INTO `food` VALUES ('7', '2', 'Coffee Brown', '47', '5', '1443424275.jpg', null, '30', 'Coffee brown description.', '1', null, null, null, null, '1', null, '1', '7.56', '2');
INSERT INTO `food` VALUES ('8', '1', 'Salad', '47', '11', '1443424941.jpg', null, '26', 'Salad', '0', null, null, null, null, '1', null, '1', null, '0');
INSERT INTO `food` VALUES ('12', 'T1', 'Seafood Shrimp', '47', '100', '1443429375.jpg', null, '28', 'Seafood shrimp description', '1', null, null, null, null, '1', null, '1', '10.00', '4');
INSERT INTO `food` VALUES ('13', 'CC1', 'Fried Crab', '48', '300', '1443429717.jpg', null, '28', 'Fried crab description.', '1', null, null, null, null, '1', null, '1', '9.56', '9');
INSERT INTO `food` VALUES ('14', 'PZ1', 'Hot Pizza', '48', '20.7', '1471666952.jpg', null, '13', 'Classic marinara sauce, authentic old-world pepperoni, seasoned pork, beef, fresh mushrooms, fresh green bell peppers', '1', null, null, null, null, '1', null, '1', '7.31', '1');
INSERT INTO `food` VALUES ('15', 'PZ2', 'MEAT LOVER', '48', '24', '1471667108.png', null, '13', 'Classic marinara sauce, authentic old-world pepperoni, all-natural Italian sausage, slow-roasted ham, applewood smoked ', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('16', 'PZ3', 'PRIMO MEATS', '48', '30', '1471667188.png', null, '13', 'Premium Crushed Tomato Sauce made of 100% California grown vine ripened tomatoes topped with premium salami, pepperoni', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('17', 'mn003', 'TUSCANI CHICKEN ALFREDO', '39', '30', '1471667393.png', null, '10', 'Grilled chicken breast strips and rotini pasta oven-baked in a creamy Alfredo sauce with a layer of melted cheese. Served with an order of breadsticks. Serves 2.', '1', null, null, null, null, '1', null, '1', '10.00', '3');
INSERT INTO `food` VALUES ('18', 'mn004', 'TUSCANI MEATY MARINARA', '39', '28', '1471667469.png', null, '10', 'Savory Italian-seasoned meat sauce and rotini pasta topped with cheese and oven-baked. Served with an order of breadsticks. Serves 2', '1', null, null, null, null, '1', null, '1', '4.00', '1');
INSERT INTO `food` VALUES ('19', 'biz01', 'Perios', '43', '15', '1471667685.png', null, '13', 'Savory Italian-seasoned meat sauce and rotini pasta topped with cheese and oven-baked. Served with an order of breadsticks', '1', null, null, null, null, '1', null, '1', '9.43', '7');
INSERT INTO `food` VALUES ('20', 'biz02', 'Pizza pizza', '43', '18', '1471667776.png', null, '13', 'Savory Italian-seasoned meat sauce and rotini pasta topped with cheese and oven-baked. Served with an order of breadsticks. Serves 2', '1', null, null, null, null, '1', null, '1', '7.33', '9');
INSERT INTO `food` VALUES ('21', 'biz03', 'Coca cola', '43', '2', '1471668142.jpg', null, '30', 'good drink!', '0', null, null, null, null, '1', null, '1', '8.67', '3');
INSERT INTO `food` VALUES ('22', 'biz04', 'Pepsi', '43', '2', '1471668220.jpg', null, '30', 'awesome drink!', '1', null, null, null, null, '1', null, '1', '7.33', '3');
INSERT INTO `food` VALUES ('23', 'biz05', 'Princess', '43', '200', '1471668323.jpg', null, '30', 'Special drink', '1', null, null, null, null, '1', null, '1', '9.33', '3');
INSERT INTO `food` VALUES ('24', 'GD001', 'Princess', '41', '5', '1471668581.jpg', null, '30', 'Special coffee', '1', null, null, null, null, '1', null, '1', '6.62', '4');
INSERT INTO `food` VALUES ('25', 'ms001', 'Hot Dog', '44', '10', '1471669245.jpg', null, '28', 'Great food ', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('26', 'ms002', 'Combo Hamburger', '44', '30', '1471670552.jpg', null, '28', 'awesome!', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('27', '1', 'Drink', '45', '4', '1474509304.jpg', null, '24', 'Milk', '1', null, null, null, null, '1', null, '1', '4.40', '5');
INSERT INTO `food` VALUES ('28', 'tococo', 'miko', '38', '4', '1474511665.jpg', null, '30', 'good', '1', null, null, null, null, '1', null, '1', '8.60', '10');
INSERT INTO `food` VALUES ('29', '123', 'Zalze Chenin Blanc', '38', '454', '1481711062.jpg', null, '30', 'Zalze wines are rooted firmly in the tradition of wine-making excellence which has been followed at the family-owned Kleine Zalze estate for decades.\r\n\r\nThis tradition is symbolised on the label through the image of the tree – it has been overlooking the vineyards for many years.\r\n\r\nWith its various slopes and soil types, Kleine Zalze’s vineyards provide each grape variety with the best-possible and most-suitable growing conditions.', '1', null, null, null, null, '1', null, '1', '9.68', '21');
INSERT INTO `food` VALUES ('30', '12234', 'Havana Club 7 Year', '38', '1690', '1481711326.JPG', null, '30', 'Havana Club 7-year-old dark rum was the first Cuban extra-aged rum which showed the world that rum could be enjoyed neat – the original Cuban ‘sipping rum’.\r\n\r\nTo create Havana Club 7-year-old, it takes more than 14 years – and the minimum age of any rum in the blend is seven years. This guaranteed youngest-drop policy is made possible by ageing and blending individual barrels, a truly unique technique in the world of rum.', '1', null, null, null, null, '1', null, '1', '9.60', '5');
INSERT INTO `food` VALUES ('31', 'MENU001', 'Beary', '49', '30', '1481774228.jpg', null, '24', 'Beary Happy Birthday Box', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('32', '112', 'Hargma', '52', '12', '1486302360.jpg', null, '33', 'Hargma dalloula tbakki', '1', null, null, null, null, '1', null, '1', '10.00', '4');
INSERT INTO `food` VALUES ('33', 'ChorizoPizza', 'Chorizo Pizza Slice', '43', '3.98', '1490982218.jpg', null, '13', 'spicy slice of pizza', '1', null, null, null, null, '1', null, '1', '8.00', '2');
INSERT INTO `food` VALUES ('34', '1', 'bavaria', '53', '20000', '1492489808.PNG', null, '30', 'صصصص', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('35', '008', 'Pane Harci', '54', '300', '1495543996.png', null, '10', '25 KG Craft', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('36', '1', 'Adidas', '55', '99', '1496748337.png', null, '33', 'Best material', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('37', '123456', 'bear', '58', '96', '1498980078.jpg', null, '30', 'djlfagslfjsa', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('39', '1', 'pollo frito', '60', '20', '1506910258.jpg', null, '10', 'pollo frito de pucu', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('40', '001', 'Pizza de Catupiry', '61', '39.9', '1515768783.png', null, '13', 'Pizza grande sabor catupiry', '1', null, null, null, null, '1', null, '1', '10.00', '2');
INSERT INTO `food` VALUES ('41', '1', 'Menu prueba', '62', '15', '1521162039.jpeg', null, '10', 'Menu', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('42', 'pizza', 'pizza', '63', '122', '1522254160.png', null, '13', 'pizzaboa', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('43', 'c333', 'hala', '53', '5', '1537109346.jpg', null, '35', 'halal food ', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('44', '0011', 'fish', '67', '10', '1537202192.jpg', null, '28', 'سمك مشوي عالفحم ', '0', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('45', '0022', 'chicken ', '68', '20', '1537272515.jpg', null, '10', 'دجاج مشوي على الفحم ', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('46', '010', 'pizza', '68', '15', '1537467689.jpg', null, '13', 'pizza cill', '1', null, null, null, null, '1', null, '1', null, null);
INSERT INTO `food` VALUES ('47', '012', 'pizza margarita ', '68', '15', '1537468008.jpg', null, '13', 'chees with milk ', '1', null, null, null, null, '1', null, '1', null, null);

-- ----------------------------
-- Table structure for `food_promotion`
-- ----------------------------
CREATE TABLE `food_promotion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `promotion_id` int(11) NOT NULL,
  `food_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of food_promotion
-- ----------------------------

-- ----------------------------
-- Table structure for `location`
-- ----------------------------
CREATE TABLE `location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_city` int(11) DEFAULT NULL,
  `location_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `account_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `location_image` varchar(100) DEFAULT NULL,
  `location_des` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `location_tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_open_hour_style` tinyint(1) NOT NULL DEFAULT '0',
  `location_open_hour` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `location_last_order_hour` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_latitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_longitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `lang` tinyint(1) DEFAULT NULL,
  `tax` varchar(500) DEFAULT NULL,
  `shipping` varchar(500) DEFAULT NULL,
  `rate` float(4,2) DEFAULT NULL,
  `rate_times` int(11) DEFAULT NULL,
  `gmt` varchar(40) DEFAULT NULL,
  `isVerified` int(1) NOT NULL DEFAULT '0',
  `isFeatured` int(1) NOT NULL DEFAULT '0',
  `facebook` varchar(500) NOT NULL,
  `twitter` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `live_chat` varchar(500) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of location
-- ----------------------------
INSERT INTO `location` VALUES ('38', 'Drinks Express', '1', '123 King Street', '1397811112', '1450080347.jpeg', 'A bar entirely dedicated to the craft of the cocktail, Drink blends time-honored techniques and the classic cocktails of the prohibition era with modern innovation and the very best artisanal ingredients. Drink also offers a thoughtful collection of white, red, and sparkling wines, small grower champagnes, and a seasonal selection of beer.', '123456789', '0', null, null, '-37.787103827523175', '144.98825073242188', '1', null, '{\"VAT\":\"10\",\"tax_status\":\"1\"}', '{\"flat_rate\":\"11\",\"minimum\":\"1888\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', '9.28', '43', 'Asia/Kolkata', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('39', 'Pizza Hut', '24', 'Tirza 1 Ramat Gan', '1397811111', '1450080159.jpeg', 'Delicious pizza', '1234567891', '0', null, null, '21.018078071903105', '105.78585660992744', '1', null, '{\"VAT\":\"10\",\"tax_status\":\"1\"}', '{\"flat_rate\":\"11\",\"minimum\":\"1888\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', '8.50', '4', 'Asia/Bangkok', '0', '1', '', '', '', '');
INSERT INTO `location` VALUES ('40', 'Seafood', '24', '12 Diago Street', '1441015549', '1450080208.jpeg', 'Our story begun in 1883 when My Grandfather Sayed Shamaa, The First Chairman in our business, recognized an opportunity to implant Saudi Arabia’s traditional fishing and sea industry to meet the needs of a rapidly expanding market. Under his guidance and patronage, numerous projects were launched to achieve his vision. In 1936 my Father Mohammad Shamaa took over his place ,I grew up gaining experience from him since he was not only a business man but also a fisherman and the consultant of several sea sciences institutions in KSA. Furthermore, in 1997 I was part of his industry and started working under his guidance as a salesperson until I have become the deputy managing director. Hence in 2001 I have opened my own company which is GHF Seafood for fresh and frozen packaged seafood products by updating my ancestor’s mission and vision following their values. GHF stands for GLOBAL Healthy Food “From the Sea …To The Your Plate ”is not only a slogan nor a statement It is a summary and concrete description of our daily duty which is to dig deep in the world wild seas in order to deliver only fresh products to our customers. ', '12345654321', '0', null, null, '24.69258988343654', '46.68629445665988', '1', null, '{\"VAT\":\"10\",\"tax_status\":0}', '{\"flat_rate\":\"10\",\"minimum\":1000,\"local_pickup\":1,\"shipping_status\":0}', '9.40', '18', 'Asia/Bangkok', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('41', 'Garden Coffee', '24', 'Freshwater Place, 3 Queensbridge St, Southbank VIC', '1432968683', '1481710864.png', 'The Garden Cafe is one of the most unique restaurants in Melbourne. Daytime neighborhood eatery with a patio & on-site garden fixing up Southern-style brunch fare. We offer excellent homemade breakfast and lunch. Everything we serve is made from scratch with fresh ingredients. We even source many of our herbs and vegetables from our own organic garden surrounding the beautiful patio! We serve humanely produced pasture raised eggs, direct trade coffee, local grass-fed pastured meats, etc… You would be hard pressed to find any other restaurant in our price point with as much made-from-scratch fresh local organic food. We offer a menu pleasing to both omnivores, and vegetarians. We feature local rotating art, artist receptions, book signings, and local musicians every once in awhile.', '0678947467', '0', null, null, '-37.80561958942248', '144.9559251123536', '1', null, '{\"VAT\":\"18\",\"tax_status\":\"0\"}', '{\"flat_rate\":\"2\",\"minimum\":\"50\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', '8.54', '20', 'Asia/Bangkok', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('42', 'Sweeden Restaur', '28', 'Av Interlagos, 1110', '1436099278', '1450080475.jpeg', '', '11111111111', '0', null, null, '-23.677207009470653', '-46.67512469999997', '0', null, '{\"VAT\":\"10\",\"tax_status\":\"0\"}', '{\"flat_rate\":\"1\",\"minimum\":\"30\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', null, '0', 'America/Sao_Paulo', '1', '1', '', '', 'adrianopepper@gmail.com', '');
INSERT INTO `location` VALUES ('43', 'Bizpro TelAviv', '25', 'Sector 48, Sohna Road, Gurgaon', '1432968683', '1450080106.jpeg', 'Sited on the corner of Aldwych & Drury Lane, The Delaunay is open from early in the morning until late at night, seven days a week.  Very much in the European Grand Café tradition, the menus range from breakfasts, brunch on Saturdays & Sundays, all-day snacks, coffees, afternoon teas, sandwiches, platters of crustacea, ice-cream coupes, patisserie and cakes, and a full à la carte, with a daily changing plat du jour and a extensive selection of schnitzels and Wieners.  ', '12345678', '0', null, null, '-37.819577759916505', '144.95612202373047', '1', null, '{\"VAT\":\"14\",\"tax_status\":\"1\"}', '{\"flat_rate\":\"5\",\"minimum\":\"1000\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', '8.25', '24', 'Asia/Bangkok', '1', '1', 'facebook', 'twitter', 'nono.cahyonop@gmail.com', 'live chat');
INSERT INTO `location` VALUES ('44', 'Michael Schumac', '1', 'Michael Schumacher  Home', '1466828607', '1466828914.jpg', '', '0912312308', '0', null, null, '50.560106719305566', '6.638573700000052', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'America/Pangnirtung', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('45', 'Royal Restauran', '25', '100 St Kilda Rd, Melbourne VIC 3004', '1432968683', '1481706442.png', 'For 110 years, The Royal Restaurant has been the most popular eatery in Old Town, Alexandria. Originally located next to City Hall at 109 North Royal Street, the family-owned Royal Cafe became Alexandria’s premier lunch time eatery for the then bustling downtown shopping district during the 1940’s, ’50’s, and ’60’s. Everyone in Old Town ate at The Royal Cafe. Although a family restaurant, The Royal Cafe was regularly visted by police officers, secretaries and other downtown workers.', '703-548-1616', '0', null, null, '-37.83352496691842', '144.9744362', '1', null, '{\"VAT\":\"5\",\"tax_status\":\"1\"}', '{\"flat_rate\":\"1\",\"minimum\":\"10\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', '4.40', '5', 'Australia/Melbourne', '1', '1', 'a', 'a', 'a', 'a');
INSERT INTO `location` VALUES ('46', 'Parrilla 88', '23', 'Mexico', '1432968683', '1479364995.jpeg', 'Sale Hamburguers ', '0912312308', '0', null, null, '19.430359', '-100.3564', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '10.00', '1', 'Africa/Abidjan', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('47', 'Mapple', '23', 'Vill De Cos', '1432968683', '1479365418.jpg', 'Sale diferent food and coffe', '0987654321', '0', null, null, '23.945963867766945', '-102.53775014999997', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '5.12', '1', 'Africa/Abidjan', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('48', 'Shangai', '123', 'Zac., Mexico', '1432968683', '1479365837.jpg', 'sale japaness food', '0987123443', '0', null, null, '23.965963867766945', '-102.54775014999997', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '7.31', '1', 'Africa/Abidjan', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('49', 'Gift Shop', '29', '65 Blackburn Road', '1481773596', '1481774041.jpg', 'gift', '6456456845', '0', null, null, '-37.97401593221037', '145.0531353', '1', null, '{\"VAT\":\"10\",\"tax_status\":\"1\"}', '{\"flat_rate\":\"5\",\"minimum\":\"50\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', null, null, 'Australia/Melbourne', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('50', 'Arun Restaurant', '30', '100 St Kilda Rd, Melbourne VIC 3004', '1481852715', '1481852909.png', 'aaaa', '703-548-1616', '0', null, null, '-35.04036496561646', '139.27934651250007', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('51', 'MyShop', '30', '36 rue de picpus', '1432968683', '1485954204.jpg', '', '3322114455', '0', null, null, '40.28905903988241', '-84.16716044999998', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '1', '1', '', '', 'test@gmail.com', '');
INSERT INTO `location` VALUES ('52', 'Chez Tarek', '30', '14 habib bourguiba Megrine', '1486302177', '1486302271.jpg', 'Ija wou jarreb', '111 222', '0', null, null, '36.77134957435525', '10.232489699999974', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '10.00', '4', 'Africa/Abidjan', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('53', 'Afyat', '1', 'Dvořákovi nabízí ', '1397811112', '1495714336.jpg', '', '777600073', '0', null, null, '35.182382861195', '-80.76458075', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Asia/Baku', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('54', 'Alf afya', '1', 'Dvořákovi nabízí ', '1397811112', '1490211104.PNG', '', '777600073', '0', null, null, '33.31177333964558', '44.35590500000001', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Asia/Baghdad', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('55', 'ShoeShop', '18', 'ha noi ', '1479976782', '1518780230.php5', 'shoe shop', '24234345454', '0', null, null, '21.026544802353264', '105.8383369910157', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Asia/Bangkok', '0', '0', 'gfgfgd', 'gfgdfgd', 'dgfdgd@dgdf.com', 'sggdfg');
INSERT INTO `location` VALUES ('56', 'Test VN', '18', 'Nghia Do cau Giay', '1397811112', '1491898365.jpeg', 'Restaraurant Nghia Do', '018340236', '0', null, null, '21.040362', '105.801384', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Asia/Vientiane', '1', '1', 'test', '', 'test@gmail.com', '');
INSERT INTO `location` VALUES ('57', 'sdsdf', '1', 'azizia', '1486302177', '1495714776.jpg', 'sdfsdfsdf', '2324234', '0', null, null, '20.99545671274082', '105.86545948857429', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('58', 'grills and more', '1', 'indrapuri ', '1498903936', '1498979845.jpg', 'qwertyui', '7788954122', '0', null, null, '23.25173200682329', '77.46604400000001', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Indian/Antananarivo', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('59', 'ASFORA', '18', '5 long st,garedn ', '1432968683', '1505742549.png', 'fast food ', '123456789', '0', null, null, '21.015007710751867', '105.84074025029304', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '8.00', '1', 'Africa/Cairo', '0', '0', 'hdikaj', 'djiok', 'kjksfA@gmail.com', 'fwkwjjiji');
INSERT INTO `location` VALUES ('60', 'PUCU', '31', 'av grau 123', '1397811112', '1506909912.jpg', 'av grau 123', '123457', '0', null, null, '-12.046586478449148', '-77.03223944663085', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'America/Panama', '1', '1', '', '', 'pucu@gmail.com', '');
INSERT INTO `location` VALUES ('61', 'PIZZARIA JANAIN', '33', 'Rua José Adílson Andrade', '1414741099', '1515768537.jpg', '', '79988093920', '0', null, null, '-10.9237566', '-37.1061444', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', '10.00', '2', 'Asia/Kolkata', '1', '1', '', '', 'cello.music86@gmail.com', 'Ola');
INSERT INTO `location` VALUES ('62', 'PUCU 2', '31', 'Av peru 3668', '1499456390', '1521161368.jpg', 'Pucu 2', '123', '0', null, null, '-12.030609503384321', '-77.0875565', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'America/Bogota', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('63', 'Brasão', '1', 'nones', '1522170846', '1522171555.png', '', '234567890', '0', null, null, '-22.9035', '-43.2096', '1', null, '{\"VAT\":\"1\",\"tax_status\":\"0\"}', '{\"flat_rate\":\"1\",\"minimum\":\"200\",\"local_pickup\":\"1\",\"shipping_status\":\"1\"}', null, null, 'Africa/Abidjan', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('64', 'Express', '27', 'location', '1432968683', '1536125272.jpg', 'test shop', '123123', '0', null, null, '90', '-14', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Asia/Singapore', '0', '0', '', '', 'aaaa@sedasd.com', '');
INSERT INTO `location` VALUES ('65', 'مطعم فلافل  fal', '36', 'ربرررث رثر ث رنث رنث رنث رنث رنثر نث رنث رثن رثترث', '0', '1537110377.gif', 'بثبث', '09765464645', '0', null, null, '32.08998299912219', '20.089224872179898', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '1', '1', '', '', '', '');
INSERT INTO `location` VALUES ('66', 'مطعم جديد', '36', 'يسيسي', '1537110607', '1537110878.gif', '', '2e232', '0', null, null, '21.022699204347', '105.83696370000007', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '0', '0', '', '', '', '');
INSERT INTO `location` VALUES ('67', 'مطعم الحوت ', '36', 'سوق الحوت بنغازي ', '1537201333', '1537201907.jpg', 'وجبات سمك ', '123456', '0', null, null, '32.12017648681582', '20.059242639383', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Abidjan', '0', '0', '', '', 'test2@yahoo.com', '');
INSERT INTO `location` VALUES ('68', 'مطعم مشويات', '36', '55 الحدائق بجانب البريد ', '1537222690', '1537271807.jpg', 'وجبات مشويات علفحم', '112233', '0', null, null, '32.09526330588901', '20.104390381290955', '1', null, '{\"VAT\":0,\"tax_status\":0}', '{\"flat_rate\":0,\"minimum\":0,\"local_pickup\":1,\"shipping_status\":0}', null, null, 'Africa/Cairo', '0', '0', '', '', 'test3@yahoo.com', '112233');

-- ----------------------------
-- Table structure for `menus`
-- ----------------------------
CREATE TABLE `menus` (
  `menu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `menu_small_thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `menu_desc` text COLLATE utf8_unicode_ci,
  `parent_id` int(11) DEFAULT '0',
  `status` tinyint(1) DEFAULT '1',
  `lang` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES ('10', 'Chicken', '1440745471.jpg', '<p>Chicken Category</p>\r\n', '0', '1', '2');
INSERT INTO `menus` VALUES ('13', 'Pizza', '1443423327.jpg', '<p>Pizza description</p>\r\n', '0', '1', '2');
INSERT INTO `menus` VALUES ('14', 'Thai', '1440745672.jpg', '<p>Thai food description</p>\r\n', '0', '1', '2');
INSERT INTO `menus` VALUES ('24', 'Sweet', '1396061261.jpg', '<p>Description</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('25', 'Vegetarian', '1396061443.jpg', '<p>Vegetarian is something that has no meat or that is related to the absence of meat.</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('26', 'Vegetables', '1396368716.jpg', '<p>vegetables</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('27', 'Dessert', '1396402533.jpg', '<p>Dessert is a typically sweet course that concludes a meal. The course usually consists of sweet foods, but may include other items.</p>\r\n\r\n<p>There is a wide variety of desserts in western cultures including cakes, cookies, biscuits, gelatins, pastries, ice creams, pies, puddings, and candies. Fruit is also commonly found in dessert courses because of its naturally occurring sweetness. Many different cultures have their own variations of similar desserts around the world, such as in Russia, where many breakfast foods such as blint, oladi, and syrniki can be served with honey and jam to make them popular as desserts. The loosely defined course called dessert can apply to many foods</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('28', 'Seafood', '1443422651.jpg', '<p>Seafood description.</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('29', 'Cream', '1396409558.jpg', '<p>Cream is a dairy product that is composed of the higher-butterfat layer skimmed from the top of milk before homogenization. In un-homogenized milk, the fat, which is less dense, will eventually rise to the top. In the industrial production of cream, this process is accelerated by using centrifuges called &quot;separators&quot;. In many countries, cream is sold in several grades depending on the total butterfat content. Cream can be dried to a powder for shipment to distant markets.</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('30', 'Drink', '1503417465.jpg', '<p>Drink</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('31', 'Demo', '1449731673.png', '<p>Demo</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('32', 'FRUITS', '1469340367.jpg', '<p>Fresh Froots</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('33', 'Gift', '1481775804.jpg', '<p>gift</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('34', 'BART', '1483206504.jpeg', '<p>bar</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('35', 'أكل سورى', '1505169096.jpg', 'لتينرهل لنبهببنبهلللن  بني', '0', '1', null);
INSERT INTO `menus` VALUES ('36', 'South Indian Meals', '1520088484.jpg', 'It\'s all the variety of south Indian foot items', '0', '1', null);
INSERT INTO `menus` VALUES ('37', 'حلال', '1537109473.gif', '<p>اكل حلال</p>\r\n', '0', '1', null);
INSERT INTO `menus` VALUES ('38', 'مشويات', '1537278406.jpg', '<p>مشويات</p>\r\n', '0', '1', null);

-- ----------------------------
-- Table structure for `open_hour_detail`
-- ----------------------------
CREATE TABLE `open_hour_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopId` int(11) NOT NULL,
  `dateId` int(11) NOT NULL,
  `openAM` varchar(20) DEFAULT NULL,
  `closeAM` varchar(20) DEFAULT NULL,
  `openPM` varchar(20) DEFAULT NULL,
  `closePM` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=463 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of open_hour_detail
-- ----------------------------
INSERT INTO `open_hour_detail` VALUES ('225', '38', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('226', '38', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('227', '38', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('228', '38', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('229', '38', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('230', '38', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('231', '38', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('232', '39', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('233', '39', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('234', '39', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('235', '39', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('236', '39', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('237', '39', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('238', '39', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('239', '40', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('240', '40', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('241', '40', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('242', '40', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('243', '40', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('244', '40', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('245', '40', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('246', '41', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('247', '41', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('248', '41', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('249', '41', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('250', '41', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('251', '41', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('252', '41', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('253', '42', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('254', '42', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('255', '42', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('256', '42', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('257', '42', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('258', '42', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('259', '42', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('260', '43', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('261', '43', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('262', '43', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('263', '43', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('264', '43', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('265', '43', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('266', '43', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('281', '46', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('282', '46', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('283', '46', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('284', '46', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('285', '46', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('286', '46', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('287', '46', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('288', '44', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('289', '44', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('290', '44', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('291', '44', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('292', '44', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('293', '44', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('294', '44', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('295', '45', '1', '06:00 PM', '06:00 AM', '06:00 AM', '06:00 PM');
INSERT INTO `open_hour_detail` VALUES ('296', '45', '2', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('297', '45', '3', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('298', '45', '4', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('299', '45', '5', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('300', '45', '6', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('301', '45', '7', '04:00 PM', '04:00 AM', '04:00 AM', '04:00 PM');
INSERT INTO `open_hour_detail` VALUES ('302', '46', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('303', '46', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('304', '46', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('305', '46', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('306', '46', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('307', '46', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('308', '46', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('309', '47', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('310', '47', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('311', '47', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('312', '47', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('313', '47', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('314', '47', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('315', '47', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('316', '48', '1', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('317', '48', '2', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('318', '48', '3', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('319', '48', '4', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('320', '48', '5', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('321', '48', '6', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('322', '48', '7', '03:00 AM', '03:00 PM', '03:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('323', '49', '1', '09:00 PM', '12:00 AM', '03:00 AM', '09:00 AM');
INSERT INTO `open_hour_detail` VALUES ('324', '49', '2', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('325', '49', '3', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('326', '49', '4', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('327', '49', '5', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('328', '49', '6', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('329', '49', '7', '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM');
INSERT INTO `open_hour_detail` VALUES ('330', '50', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('331', '50', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('332', '50', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('333', '50', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('334', '50', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('335', '50', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('336', '50', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('337', '51', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('338', '51', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('339', '51', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('340', '51', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('341', '51', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('342', '51', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('343', '51', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('344', '52', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('345', '52', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('346', '52', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('347', '52', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('348', '52', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('349', '52', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('350', '52', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('351', '53', '1', '02:00 AM', '06:00 AM', '06:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('352', '53', '2', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('353', '53', '3', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('354', '53', '4', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('355', '53', '5', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('356', '53', '6', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('357', '53', '7', '02:00 AM', '06:00 AM', '09:00 AM', '05:00 PM');
INSERT INTO `open_hour_detail` VALUES ('358', '54', '1', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('359', '54', '2', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('360', '54', '3', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('361', '54', '4', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('362', '54', '5', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('363', '54', '6', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('364', '54', '7', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('365', '55', '1', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('366', '55', '2', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('367', '55', '3', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('368', '55', '4', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('369', '55', '5', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('370', '55', '6', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('371', '55', '7', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('372', '56', '1', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('373', '56', '2', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('374', '56', '3', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('375', '56', '4', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('376', '56', '5', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('377', '56', '6', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('378', '56', '7', '12:00 AM', '04:00 AM', '07:00 AM', '03:00 PM');
INSERT INTO `open_hour_detail` VALUES ('379', '57', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('380', '57', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('381', '57', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('382', '57', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('383', '57', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('384', '57', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('385', '57', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('386', '58', '1', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('387', '58', '2', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('388', '58', '3', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('389', '58', '4', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('390', '58', '5', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('391', '58', '6', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('392', '58', '7', '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM');
INSERT INTO `open_hour_detail` VALUES ('393', '59', '1', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('394', '59', '2', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('395', '59', '3', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('396', '59', '4', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('397', '59', '5', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('398', '59', '6', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('399', '59', '7', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('400', '60', '1', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('401', '60', '2', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('402', '60', '3', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('403', '60', '4', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('404', '60', '5', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('405', '60', '6', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('406', '60', '7', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('407', '61', '1', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('408', '61', '2', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('409', '61', '3', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('410', '61', '4', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('411', '61', '5', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('412', '61', '6', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('413', '61', '7', '01:30 AM', '05:30 AM', '08:30 AM', '04:30 PM');
INSERT INTO `open_hour_detail` VALUES ('414', '62', '1', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('415', '62', '2', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('416', '62', '3', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('417', '62', '4', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('418', '62', '5', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('419', '62', '6', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('420', '62', '7', '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM');
INSERT INTO `open_hour_detail` VALUES ('421', '63', '1', '07:00 AM', '10:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('422', '63', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('423', '63', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('424', '63', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('425', '63', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('426', '63', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('427', '63', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('428', '64', '1', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('429', '64', '2', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('430', '64', '3', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('431', '64', '4', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('432', '64', '5', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('433', '64', '6', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('434', '64', '7', '11:00 PM', '03:00 AM', '06:00 AM', '02:00 PM');
INSERT INTO `open_hour_detail` VALUES ('435', '65', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('436', '65', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('437', '65', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('438', '65', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('439', '65', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('440', '65', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('441', '65', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('442', '66', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('443', '66', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('444', '66', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('445', '66', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('446', '66', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('447', '66', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('448', '66', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('449', '67', '1', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('450', '67', '2', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('451', '67', '3', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('452', '67', '4', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('453', '67', '5', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('454', '67', '6', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('455', '67', '7', '07:00 AM', '11:00 AM', '02:00 PM', '10:00 PM');
INSERT INTO `open_hour_detail` VALUES ('456', '68', '1', '08:00 AM', '10:00 AM', '08:00 PM', '10:00 AM');
INSERT INTO `open_hour_detail` VALUES ('457', '68', '2', '08:00 AM', '10:00 AM', '08:00 AM', '10:00 AM');
INSERT INTO `open_hour_detail` VALUES ('458', '68', '3', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('459', '68', '4', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('460', '68', '5', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('461', '68', '6', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');
INSERT INTO `open_hour_detail` VALUES ('462', '68', '7', '05:00 AM', '09:00 AM', '12:00 PM', '08:00 PM');

-- ----------------------------
-- Table structure for `orders`
-- ----------------------------
CREATE TABLE `orders` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `shop_id` int(11) NOT NULL,
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `order_places` text COLLATE utf8_unicode_ci NOT NULL,
  `order_requirement` text CHARACTER SET latin1 NOT NULL,
  `order_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `paymentMethod` int(11) DEFAULT NULL,
  `transactionId` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `paymentStatus` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `group_code` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chef_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `deliveryman_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', '1397811111', '40', 'Hy Cuong', '0123756789', 'immrhy@gmail.com', '123 King Street', '', '2016-07-12 17:15', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-07-12 17:07:16', '4B9AB6D111', null, null);
INSERT INTO `orders` VALUES ('2', '1397811111', '38', 'Hy Cuong', '0123756789', 'immrhy@gmail.com', '123 King Street', '', '2016-07-12 11:15', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-07-12 17:07:16', '4B9AB6D111', null, null);
INSERT INTO `orders` VALUES ('3', '1397811111', '40', 'Hy Cuong', '0123756789', 'immrhy@gmail.com', '123 King Street', '', '2016-07-12 10:15', '3', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-07-12 17:09:07', '6152E47111', null, null);
INSERT INTO `orders` VALUES ('4', '1397811111', '41', 'Hy Cuong', '0123756789', 'immrhy@gmail.com', '123 King Street', '', '2016-07-12 13:45', '0', '3', 'ch_18WNswFxnu488Lwzd0CwQvv6', '0', '2016-07-12 17:13:02', 'A90973B111', null, null);
INSERT INTO `orders` VALUES ('5', '1397811111', '42', 'Hy Cuong', '0123756789', 'immrhy@gmail.com', '123 King Street', '', '2016-07-12 11:00', '0', '3', 'ch_18WNswFxnu488Lwzd0CwQvv6', '0', '2016-07-12 17:13:02', 'A90973B111', null, null);
INSERT INTO `orders` VALUES ('6', '1466830013', '41', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-07-24 15:38:45', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-07-24 15:38:45', 'E2EC592013', null, null);
INSERT INTO `orders` VALUES ('7', '1466830013', '40', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-06 10:15', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-08-06 18:32:00', 'DE1387E013', null, null);
INSERT INTO `orders` VALUES ('8', '1466830013', '38', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-20 16:50:17', '0', '3', 'ch_18kW7SFxnu488LwzZlzXKlZJ', '0', '2016-08-20 16:50:17', '0173C75013', null, null);
INSERT INTO `orders` VALUES ('9', '1466830013', '41', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-20 16:50:17', '0', '3', 'ch_18kW7SFxnu488LwzZlzXKlZJ', '0', '2016-08-20 16:50:17', '0173C75013', null, null);
INSERT INTO `orders` VALUES ('13', '1466830013', '38', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-20 19:45', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-08-20 12:01:01', 'AFDAE49013', null, null);
INSERT INTO `orders` VALUES ('15', '1466830013', '40', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-22 11:34:12', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-08-22 11:34:12', 'F97CED3013', null, null);
INSERT INTO `orders` VALUES ('16', '1466830013', '41', 'huy pham', '098754285', 'huy@projectemplate.com', 'dong ngac', '', '2016-08-22 13:45', '3', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-08-22 11:34:12', 'F97CED3013', null, null);
INSERT INTO `orders` VALUES ('17', '1474269015', '38', 'Dang Dang', '', 'dangtin_myk@yahoo.com.vn', '', '', '2016-09-19 14:12:39', '0', '3', 'ch_18vLxCFxnu488Lwzz4qFlzxK', '0', '2016-09-19 14:12:39', 'CBED10D015', null, null);
INSERT INTO `orders` VALUES ('18', '0', '41', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-09-20 10:21:16', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-20 10:21:16', '034B5220', null, null);
INSERT INTO `orders` VALUES ('19', '0', '41', 'Stephen', '9942048657', 'iadmin@gmail.com', 'Hanoi', '', '2016-09-20 14:40:15', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-20 14:40:15', 'DED063C0', null, null);
INSERT INTO `orders` VALUES ('20', '1474442344', '43', 'van do', '578565', 'van@g.com', 'tvtvtf', '', '2016-09-21 11:00', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-21 15:10:32', 'FC5FFF3344', null, null);
INSERT INTO `orders` VALUES ('21', '1474442344', '43', 'van do', '', 'van@g.com', 'tvtvtf', '', '2016-09-21 17:15', '3', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-21 16:02:46', 'E1F9DE8344', null, null);
INSERT INTO `orders` VALUES ('22', '1474442344', '40', 'van do', '', 'van@g.com', 'tvtvtf', '', '2016-09-21 16:02:46', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-21 16:02:46', 'E1F9DE8344', null, null);
INSERT INTO `orders` VALUES ('23', '1474442344', '43', '', '', '', 'tvtvtf', '', '2016-09-21 16:15', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-21 16:03:13', 'BCF66B0344', null, null);
INSERT INTO `orders` VALUES ('24', '1474442344', '43', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 17:15', '5', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 08:06:12', 'D22C716344', null, null);
INSERT INTO `orders` VALUES ('25', '1474442344', '42', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 08:06:12', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 08:06:12', 'D22C716344', null, null);
INSERT INTO `orders` VALUES ('26', '1474442344', '43', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 17:15', '6', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 08:06:19', '85EF537344', null, null);
INSERT INTO `orders` VALUES ('27', '1474442344', '42', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 08:06:19', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 08:06:19', '85EF537344', null, null);
INSERT INTO `orders` VALUES ('28', '1474442344', '45', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 1:45', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 09:44:27', '3FBCBD4344', null, null);
INSERT INTO `orders` VALUES ('29', '1474442344', '45', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 09:44:52', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 09:44:52', 'AF2C2F5344', null, null);
INSERT INTO `orders` VALUES ('30', '1474442344', '45', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 09:47:03', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 09:47:03', '5A7270A344', null, null);
INSERT INTO `orders` VALUES ('31', '1474442344', '45', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 09:55:14', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 09:55:14', '1D8BF98344', null, null);
INSERT INTO `orders` VALUES ('32', '1474442344', '45', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 10:41:28', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 10:41:28', 'B63E5A0344', null, null);
INSERT INTO `orders` VALUES ('33', '1474442344', '40', 'th', '9889', 'h@g.com', 'fhh', '', '2016-09-22 13:46:31', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 13:46:31', 'E1631E8344', null, null);
INSERT INTO `orders` VALUES ('34', '1474442344', '39', 'pth', '9865', 'h@g.com', 'btth', '', '2016-09-22 13:50:54', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 13:50:54', 'EA55F4B344', null, null);
INSERT INTO `orders` VALUES ('35', '1474442344', '43', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 13:56:55', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 13:56:55', '4FE6264344', null, null);
INSERT INTO `orders` VALUES ('36', '1474442344', '43', '', '', '', 'ghh', '', '2016-09-22 13:58:11', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 13:58:11', 'D5306A0344', null, null);
INSERT INTO `orders` VALUES ('37', '1474527670', '43', 'pth', '123', 'pth@g.com', 'thhfr', '', '2016-09-22 14:39:36', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 14:39:36', 'EBBD1C1670', null, null);
INSERT INTO `orders` VALUES ('38', '1474527670', '41', 'pth', '123', 'pth@g.com', 'thhfr', '', '2016-09-22 14:39:36', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 14:39:36', 'EBBD1C1670', null, null);
INSERT INTO `orders` VALUES ('39', '1474442344', '43', 'van do', '578565', 'van@g.com', 'bbhnu', '', '2016-09-22 15:43:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 15:43:43', '78AD5B7344', null, null);
INSERT INTO `orders` VALUES ('40', '1474442344', '43', '', '', '', 'hvjgjgnkkn', '', '2016-09-22 15:55:35', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-09-22 15:55:35', '0CE2C49344', null, null);
INSERT INTO `orders` VALUES ('41', '1476566908', '38', 'Basu', '9096900128', 'bnwraj@yahoo.com', 'bhosri', '', '2016-10-16 04:31:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-10-16 04:31:26', '281C7E0908', null, null);
INSERT INTO `orders` VALUES ('43', '1477303126', '38', 'natania', '0527946434549494', 'nataniaayu@gmail.com', 'jalan cangkorah 2', '', '2016-10-24 21:15', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-10-24 17:02:07', '6E9C694126', null, null);
INSERT INTO `orders` VALUES ('44', '1478510812', '38', 'David Hicom', '4545', 'hicom.david@gmail.com', 'ahahahah', '', '2016-11-08 08:44:29', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-08 08:44:29', '70C9BEA812', null, null);
INSERT INTO `orders` VALUES ('45', '1478510812', '38', 'David Hicom', '4545', 'hicom.david@gmail.com', 'ahahahah', '', '2016-11-08 09:53:57', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-08 09:53:57', '00D6F7C812', null, null);
INSERT INTO `orders` VALUES ('46', '1478572970', '41', 'David Hicom', '4548', 'hicom.david@gmail.com', 'ahahahah', '', '2016-11-08 11:30', '6', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-08 10:50:21', '7D29AB0970', null, null);
INSERT INTO `orders` VALUES ('47', '1478572970', '40', 'David Hicom', '854512', 'hicom.david@gmail.com', 'ahahahah', '', '2016-11-08 10:56:38', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-08 10:56:38', '54C229B970', null, null);
INSERT INTO `orders` VALUES ('48', '1441015549', '43', 'Peter Pan', '0123456789', 'caknoshop@gmail.com', '123 Street', '', '2016-11-09 14:15', '2', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-09 14:09:41', '1A8A8BE549', null, null);
INSERT INTO `orders` VALUES ('49', '1441015549', '43', 'Peter Pan', '0123456789', 'caknoshop@gmail.com', '123 Street', '', '2016-11-09 14:30', '2', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-09 14:14:25', '2032921549', null, null);
INSERT INTO `orders` VALUES ('50', '1479830278', '47', 'Jermain Jermain', '4535353533', 'sherwincool@yahoo.com', 'u7tui8686h t8gugjg', '', '2016-11-22 22:59:52', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-22 22:59:52', '0E56094278', null, null);
INSERT INTO `orders` VALUES ('51', '1480169682', '48', 'glenn', '0912345678', 'glennbarz@gmail.com', '123 dfg', '', '2016-11-26 21:16:55', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-26 21:16:55', 'EE82FDF682', null, null);
INSERT INTO `orders` VALUES ('52', '1480278690', '43', 'sach', '9420942942', 'mail2sach911@yahoo.co', 'india', '', '2016-11-28 03:33:16', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-28 03:33:16', '3160154690', null, null);
INSERT INTO `orders` VALUES ('53', '1480360793', '39', 'shyam', '9961935749', 'shyamsree16@gmail.com', 'Abudhabi', '', '2016-11-29 02:28:49', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-29 02:28:49', 'EB09AC2793', null, null);
INSERT INTO `orders` VALUES ('54', '1480360793', '39', 'shyam', '9961935749', 'shyamsree16@gmail.com', 'Abudhabi', '', '2016-11-29 13:48:57', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-29 13:48:57', '98DBD4A793', null, null);
INSERT INTO `orders` VALUES ('55', '1480360793', '39', 'shhhh', '3366', 'shyam', 'ggshd', '', '2016-11-29 13:54:10', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-29 13:54:10', '8E9F039793', null, null);
INSERT INTO `orders` VALUES ('56', '1480360793', '39', 'shyam', '9961935749', 'shyamsree16@gmail.com', 'Abudhabi', '', '2016-11-29 14:28:29', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-29 14:28:29', 'F064E32793', null, null);
INSERT INTO `orders` VALUES ('57', '1480360793', '39', 'shyam', '9961935749', 'shyamsree16@gmail.com', 'Abudhabi', '', '2016-11-29 20:40:41', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-29 20:40:41', 'DB0C6C2793', null, null);
INSERT INTO `orders` VALUES ('58', '1480278690', '43', 'sach', '9420942942', 'mail2sach911@yahoo.co', 'india', '', '2016-11-30 13:20:08', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-11-30 13:20:08', 'C2DE384690', null, null);
INSERT INTO `orders` VALUES ('59', '1480857612', '38', 'testtest', '9995480852', 'test@test.com', 'fvdvfcffv', '', '2016-12-04 21:02:47', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-04 21:02:47', 'DEBC167612', null, null);
INSERT INTO `orders` VALUES ('60', '1481312665', '43', 'Rashmi Rashmi', '', 'rashmi_hv@yahoo.com', 'ffygggh', '', '2016-12-10 02:48:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-10 02:48:26', '12A2420665', null, null);
INSERT INTO `orders` VALUES ('61', '1481312665', '43', 'Rashmi Rashmi', '', 'rashmi_hv@yahoo.com', 'yty', '', '2016-12-10 03:00:19', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-10 03:00:19', '604A73C665', null, null);
INSERT INTO `orders` VALUES ('62', '0', '38', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-13 14:59:22', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-13 14:59:22', '3C4CEBA0', null, null);
INSERT INTO `orders` VALUES ('63', '0', '43', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 11:32:30', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 11:32:30', 'FAA46930', null, null);
INSERT INTO `orders` VALUES ('64', '0', '39', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 11:32:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 11:32:43', 'D52F1920', null, null);
INSERT INTO `orders` VALUES ('65', '0', '43', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 11:32:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 11:32:43', 'D52F1920', null, null);
INSERT INTO `orders` VALUES ('66', '0', '45', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 11:32:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 11:32:43', 'D52F1920', null, null);
INSERT INTO `orders` VALUES ('67', '1450162397', '47', 'Phạm Điệp', '09847467', 'phamvandiep93@yahoo.com', '', '', '2016-12-14 14:16:28', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 14:16:28', '72D9893397', null, null);
INSERT INTO `orders` VALUES ('68', '1450162397', '39', 'Phạm Điệp', '09847467', 'phamvandiep93@yahoo.com', '', '', '2016-12-14 14:16:28', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 14:16:28', '72D9893397', null, null);
INSERT INTO `orders` VALUES ('69', '1450162397', '47', 'Phạm Điệp', '09847467', 'phamvandiep93@yahoo.com', 'ha noi', '', '2016-12-14 14:29:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 14:29:26', 'DCB26DD397', null, null);
INSERT INTO `orders` VALUES ('70', '1450162397', '38', 'Phạm Điệp', '09847467', 'phamvandiep93@yahoo.com', 'ha noi', '', '2016-12-14 14:29:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 14:29:26', 'DCB26DD397', null, null);
INSERT INTO `orders` VALUES ('71', '0', '47', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 17:34:24', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 17:34:24', '21E88C50', null, null);
INSERT INTO `orders` VALUES ('72', '1478572970', '41', 'Stephen', '9942048657', 'admin@gmail.com', 'Hanoi', '', '2016-12-14 10:30', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-14 17:34:24', '21E88C50', null, null);
INSERT INTO `orders` VALUES ('73', '1481906092', '43', 'Hicom James', '123456', 'hicom.james@gmail.com', '123 King Str Sydney', '', '2016-12-16 23:36:14', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-12-16 23:36:14', 'B520F94092', null, null);
INSERT INTO `orders` VALUES ('74', '1481906092', '38', 'Hicom James', '123456', 'hicom.james@gmail.com', '123 King Str Sydney', '', '2016-12-16 23:36:14', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-12-16 23:36:14', 'B520F94092', null, null);
INSERT INTO `orders` VALUES ('75', '1481906092', '39', 'Hicom James', '123456', 'hicom.james@gmail.com', '123 King Str Sydney', '', '2016-12-16 23:36:14', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2016-12-16 23:36:14', 'B520F94092', null, null);
INSERT INTO `orders` VALUES ('76', '1482128178', '38', 'Saurabh Saurabh', '', 'sagrawa@gmail.com', 'gdfgg', '', '2016-12-19 13:16:51', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 13:16:51', 'D55A1EC178', null, null);
INSERT INTO `orders` VALUES ('77', '1482128178', '49', 'Saurabh Saurabh', '', 'sagrawa@gmail.com', 'gdfgg', '', '2016-12-19 13:16:51', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 13:16:51', 'D55A1EC178', null, null);
INSERT INTO `orders` VALUES ('78', '1432968757', '41', 'Hicom Harry', '757-681-5600', 'fruity.tester123@gmail.com', 'PO Box 668132, Charlotte, NC', '', '2016-12-19 14:25:24', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 14:25:24', '276FB0A757', null, null);
INSERT INTO `orders` VALUES ('79', '1432968757', '43', 'Hicom Harry', '757-681-5600', 'fruity.tester123@gmail.com', 'PO Box 668132, Charlotte, NC', '', '2016-12-19 14:25:24', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 14:25:24', '276FB0A757', null, null);
INSERT INTO `orders` VALUES ('80', '1432968757', '38', 'Hicom Harry', '757-681-5600', 'fruity.tester123@gmail.com', 'PO Box 668132, Charlotte, NC', '', '2016-12-19 16:38:04', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 16:38:04', 'B3BC3B4757', null, null);
INSERT INTO `orders` VALUES ('81', '1432968757', '47', 'Hicom Harry', '757-681-5600', 'fruity.tester123@gmail.com', 'PO Box 668132, Charlotte, NC', '', '2016-12-19 16:38:04', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-19 16:38:04', 'B3BC3B4757', null, null);
INSERT INTO `orders` VALUES ('82', '1482128178', '38', 'Saurabh Saurabh', '55255555555', 'sagrawa@gmail.com', 'ffdgh', '', '2016-12-27 16:36:44', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-27 16:36:44', '9F0A456178', null, null);
INSERT INTO `orders` VALUES ('83', '1482128178', '38', 'Saurabh Saurabh', '425463556', 'sagrawa@gmail.com', 'ffdf\n', '', '2016-12-28 05:37:15', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-28 05:37:15', '48DBC58178', null, null);
INSERT INTO `orders` VALUES ('84', '0', '47', 'Stephen', '9942048657', 'admin@gmail.com', 'Sydney', '', '2016-12-28 10:15:02', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2016-12-28 10:15:02', 'DF745440', null, null);
INSERT INTO `orders` VALUES ('85', '1483208107', '38', 'Tony n', '123', 'tonyn888@yahoo.com', '124', '', '2017-01-01 01:16:31', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-01-01 01:16:31', 'B2720C0107', null, null);
INSERT INTO `orders` VALUES ('86', '1483345848', '38', 'Al Al', '0', 'alfz.miscbuzz@gmail.com', 'a', '', '2017-01-02 15:31:23', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-01-02 15:31:23', '019E43E848', null, null);
INSERT INTO `orders` VALUES ('87', '1483345848', '41', 'Al Al', '0', 'alfz.miscbuzz@gmail.com', 'a', '', '2017-01-02 22:45', '2', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-01-02 15:31:23', '019E43E848', null, null);
INSERT INTO `orders` VALUES ('88', '1482128178', '38', 'Saurabh Saurabh', '555', 'sagrawa@gmail.com', 'ffg\n', '', '2017-01-04 03:12:41', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-01-04 03:12:41', '1AE2267178', null, null);
INSERT INTO `orders` VALUES ('89', '1486303307', '52', 'tarzk', '24227991', 'tarek.ben.rekhissa@gmail.com', 'tunis', '', '2017-02-05 15:15', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-02-05 21:04:28', 'F2F2B0E307', null, null);
INSERT INTO `orders` VALUES ('90', '1488503149', '47', 'Samitio', '656323123', 'infodeve@gmail.com', 'paradise street', '', '2017-03-03 08:09:03', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-03-03 08:09:03', '26B6021149', null, null);
INSERT INTO `orders` VALUES ('91', '1488503149', '39', 'Samitio', '656323123', 'infodeve@gmail.com', 'paradise street', '', '2017-03-03 08:09:03', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-03-03 08:09:03', '26B6021149', null, null);
INSERT INTO `orders` VALUES ('92', '1488503149', '47', 'Samitio', '656323123', 'infodeve@gmail.com', 'paradise street', '', '2017-03-03 08:09:20', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-03-03 08:09:20', 'AFAFA45149', null, null);
INSERT INTO `orders` VALUES ('93', '1488503149', '39', 'Samitio', '656323123', 'infodeve@gmail.com', 'paradise street', '', '2017-03-03 08:09:20', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-03-03 08:09:20', 'AFAFA45149', null, null);
INSERT INTO `orders` VALUES ('94', '1490960661', '43', 'Raja', '9742065455', 'raja18.mech@gmail.com', 'Ejipura, Bangalore', '', '2017-03-31 18:51:18', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-03-31 18:51:18', 'D2A19D1661', null, null);
INSERT INTO `orders` VALUES ('95', '1491216437', '43', 'Raja', '9742065455', 'raja18_mech@yahoo.co.in', 'na', '', '2017-04-03 17:47:58', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-04-03 17:47:58', '59FD02F437', null, null);
INSERT INTO `orders` VALUES ('96', '1491555972', '43', 'Trang Trang', '302028', 'smilepleaseyou@yahoo.com.vn', 'ub7g7', '', '2017-04-07 16:07:07', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2017-04-07 16:07:07', 'E5B942E972', null, null);
INSERT INTO `orders` VALUES ('97', '1491555972', '43', 'Trang Trang', '6', 'smilepleaseyou@yahoo.com.vn', 'uvug', '', '2017-04-07 16:07:41', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-04-07 16:07:41', 'A344E5E972', null, null);
INSERT INTO `orders` VALUES ('98', '1493205429', '41', 'Joseph Emmanuel Joseph Emmanuel', '', 'ndong_j@hotmail.com', 'Melbourne ', '', '2017-04-26 19:45', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-04-26 18:18:10', '55DCDFC429', null, null);
INSERT INTO `orders` VALUES ('99', '1498903936', '52', 'Dhiraj Dhiraj', '5276888888', 'er.dhirajpandit12@gmail.com', 'indrapuri', '', '2017-07-01 17:17:47', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-01 17:17:47', '9EFE3D7936', null, null);
INSERT INTO `orders` VALUES ('100', '1499456390', '52', 'luis', '945547947', 'luispucutay@gmail.com', 'peru', '', '2017-07-08 02:41:25', '0', '3', 'ch_1Ad2MWFxnu488LwztJjcFtMh', '0', '2017-07-08 02:41:25', 'ECA5C1A390', null, null);
INSERT INTO `orders` VALUES ('101', '1500704169', '43', 'Alejandro Alejandro', '9371332995', 'saint_silver17@hotmail.com', 'Moctezuma 496', '', '2017-07-22 1:30', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-22 13:20:04', '25E03A2169', null, null);
INSERT INTO `orders` VALUES ('102', '1500704169', '38', 'Alejandro Alejandro', '9371332995', 'saint_silver17@hotmail.com', 'Moctezuma 496', 'http://27.72.88.241:8888/hicom-multirestaurants/backend/order/update.html?id=102#myModal', '2017-07-22 1:30', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-22 13:20:04', '25E03A2169', null, null);
INSERT INTO `orders` VALUES ('103', '1500704169', '41', 'Alejandro Alejandro', '9371332995', 'saint_silver17@hotmail.com', 'Moctezuma 496', '', '2017-07-22 1:30', '1', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-22 13:20:04', '25E03A2169', null, null);
INSERT INTO `orders` VALUES ('104', '1500967644', '43', 'alex', '9371332995', 'sistemasexpertos@protonmail.com', 'Moctezuma 406', '', '2017-07-25 15:01:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-25 15:01:26', 'CA2F0CB644', null, null);
INSERT INTO `orders` VALUES ('105', '1500967644', '39', 'alex', '9371332995', 'sistemasexpertos@protonmail.com', 'Moctezuma 406', '', '2017-07-25 15:02:34', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-25 15:02:34', '1DA3169644', null, null);
INSERT INTO `orders` VALUES ('106', '1500967644', '41', 'alex', '9371332995', 'sistemasexpertos@protonmail.com', 'Moctezuma 406', '', '2017-07-25 15:02:34', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-25 15:02:34', '1DA3169644', null, null);
INSERT INTO `orders` VALUES ('107', '1501068891', '43', 'Ausgjgh', '12345678901', 'gsydhn@GMAIL.COM', 'Hsvydvhhvv', '', '2017-07-28 00:31:44', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-28 00:31:44', '1B8FCF0891', null, null);
INSERT INTO `orders` VALUES ('108', '1501068891', '47', 'Ausgjgh', '12345678901', 'gsydhn@GMAIL.COM', 'Hsvydvhhvv', '', '2017-07-31 01:14:18', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-31 01:14:18', 'CE4251F891', null, null);
INSERT INTO `orders` VALUES ('109', '1501068891', '38', 'Ausgjgh', '12345678901', 'gsydhn@GMAIL.COM', 'Hsvydvhhvv', '', '2017-07-31 01:14:18', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-31 01:14:18', 'CE4251F891', null, null);
INSERT INTO `orders` VALUES ('111', '1501068891', '47', 'Ausgjgh', '12345678901', 'gsydhn@GMAIL.COM', 'Hsvydvhhvv', '', '2017-07-31 02:26:24', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-07-31 02:26:24', '346F84F891', null, null);
INSERT INTO `orders` VALUES ('112', '1501569492', '41', 'alex solis', '9371332995', 'deleitabcardenas@gmail.com', 'Moctezuma 406', 'va pronto', '2017-08-01 2:00', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-01 13:38:45', '3268C84492', null, null);
INSERT INTO `orders` VALUES ('113', '1501569492', '46', 'alex solis', '9371332995', 'deleitabcardenas@gmail.com', 'Moctezuma 406', '', '2017-08-01 2:00', '3', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-01 13:46:02', '8E75221492', null, null);
INSERT INTO `orders` VALUES ('114', '1501569492', '43', 'alex solis', '9371332995', 'deleitabcardenas@gmail.com', 'Moctezuma 406', '', '2017-08-01 2:00', '3', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-01 13:46:02', '8E75221492', null, null);
INSERT INTO `orders` VALUES ('115', '1501755287', '38', 'Truong', '028289399', 'truongnv1292@gmail.com', 'gsbb', '', '2017-08-03 17:40:10', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-03 17:40:10', '8DA2AE9287', null, null);
INSERT INTO `orders` VALUES ('116', '1502098216', '43', 'khali raza', '0046720056466', 'kcyberservices@gmail.com', 'midälvavägen 42', '', '2017-08-07 16:30:53', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-07 16:30:53', 'ACFE0BD216', null, null);
INSERT INTO `orders` VALUES ('117', '1502098216', '38', 'khali raza', '0046720056466', 'kcyberservices@gmail.com', 'midälvavägen 42', '', '2017-08-07 16:30:53', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-07 16:30:53', 'ACFE0BD216', null, null);
INSERT INTO `orders` VALUES ('118', '1450176364', '38', 'John John', '0912312308', 'hicom.register@gmail.com', 'Address', '', '2017-08-11 14:52:50', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-11 14:52:50', '4333A47364', null, null);
INSERT INTO `orders` VALUES ('119', '1450176364', '43', 'John John', '0912312308', 'hicom.register@gmail.com', 'Addresshn', '', '2017-08-11 14:53:53', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2017-08-11 14:53:53', '5F69DC0364', null, null);
INSERT INTO `orders` VALUES ('120', '1450176364', '38', 'John John', '0912312308', 'hicom.register@gmail.com', 'Address', '', '2017-08-11 15:20:37', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2017-08-11 15:20:37', 'F46A374364', null, null);
INSERT INTO `orders` VALUES ('121', '1450176364', '43', 'John John', '0912312308', 'hicom.register@gmail.com', 'Address', '', '2017-08-11 15:48:05', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2017-08-11 15:48:05', '8081F35364', null, null);
INSERT INTO `orders` VALUES ('122', '1450176364', '38', 'John John', '0912312308', 'hicom.register@gmail.com', 'Address', '', '2017-08-11 15:50:15', '0', '2', 'PAY-6PU626847B294842SKPEWXHY', '0', '2017-08-11 15:50:15', '47A97BC364', null, null);
INSERT INTO `orders` VALUES ('123', '1502457075', '41', 'Felipe Felipe', '', 'felipe_cat77@hotmail.com', 'Ddf', '', '2017-08-11 20:26:44', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-11 20:26:44', '63AD1EC075', null, null);
INSERT INTO `orders` VALUES ('124', '1502457075', '43', 'Felipe Felipe', '', 'felipe_cat77@hotmail.com', 'Ddf', '', '2017-08-11 20:26:44', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-11 20:26:44', '63AD1EC075', null, null);
INSERT INTO `orders` VALUES ('125', '1501068891', '43', 'Ausgjgh', '12345678901', 'gsydhn@GMAIL.COM', 'Hsvydvhhvv', '', '2017-08-12 14:20:50', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-12 14:20:50', '47730B8891', null, null);
INSERT INTO `orders` VALUES ('126', '1503037195', '43', 'aaaaa', '9898989898', 'aa@aa.com', 'svdvd', '', '2017-08-18 17:15', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-08-18 13:20:32', '7872BCF195', null, null);
INSERT INTO `orders` VALUES ('128', '1504679211', '43', 'Monika barehanded', '1234567890', 'gh@gh.com', 'Sad Kidd’s a Fsdafkl ', '', '2017-09-06 13:28:17', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-06 13:28:17', 'B24A7DA211', null, null);
INSERT INTO `orders` VALUES ('129', '1504682741', '38', 'Trang Pham', '023894', 'trang@gmail.com', 'Ha Noi ', '', '2017-09-06 14:26:09', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-06 14:26:09', 'A8DC8BA741', null, null);
INSERT INTO `orders` VALUES ('130', '1505233029', '43', 'momomo', '85585685', 'fhtvjj@yahoo.com', 'gfhujk jybk', '', '2017-09-12 23:19:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-12 23:19:43', 'EB4799B029', null, null);
INSERT INTO `orders` VALUES ('132', '1505233029', '39', 'momomo', '85585685', 'fhtvjj@yahoo.com', 'gfhujk jybk', '', '2017-09-13 02:49:35', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-13 02:49:35', '055B154029', null, null);
INSERT INTO `orders` VALUES ('141', '1505233029', '52', 'momomo', '85585685', 'fhtvjj@yahoo.com', 'gfhujk jybk', '', '2017-09-13 14:00', '5', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-13 03:25:52', 'EE05390029', null, null);
INSERT INTO `orders` VALUES ('154', '1505233029', '47', 'momomo', '85585685', 'fhtvjj@yahoo.com', 'gfhujk jybk', '', '2017-09-13 03:27:05', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-13 03:27:05', '7A667BE029', null, null);
INSERT INTO `orders` VALUES ('165', '1505233029', '52', 'momomo', '85585685', 'fhtvjj@yahoo.com', 'gfhujk jybk', '', '2017-09-13 13:45', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-09-13 03:31:14', '561B0E6029', null, null);
INSERT INTO `orders` VALUES ('169', '1506910604', '60', 'lpl', '123', 'lpl@gmail.com', 'qwe', '', '2017-10-02 09:17:09', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-10-02 09:17:09', '9BC528B604', null, null);
INSERT INTO `orders` VALUES ('170', '1499456390', '60', 'luis 0910', '945547947', 'luispucutay@gmail.com', 'peru', '', '2017-10-09 20:02:47', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-10-09 20:02:47', 'F128DEC390', null, null);
INSERT INTO `orders` VALUES ('171', '1510575391', '43', 'Abdul Jalil Abdul Jalil', '0507711450', 'jedo145@gmail.com', 'شارع يعقوب الصفار', '', '2017-11-13 19:17:05', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-11-13 19:17:05', 'D7B6C13391', null, null);
INSERT INTO `orders` VALUES ('172', '1510576455', '43', 'jedo', '123', 'jedosr@gmail.com', 'sudai', '', '2017-11-13 21:37:12', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-11-13 21:37:12', '47F86AA455', null, null);
INSERT INTO `orders` VALUES ('173', '1510767914', '48', 'Isayas Isayas', '003366852548', 'leongildas@yahoo.fr', 'Paris', '', '2017-11-25 22:15', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-11-16 00:51:25', '3A4F4AB914', null, null);
INSERT INTO `orders` VALUES ('174', '1511203270', '52', 'Muhammad Muhammad', '0720056466', 'khalilpoint@yahoo.com', 'midalvavagen 42', '', '2017-11-21 01:42:11', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-11-21 01:42:11', '53043BF270', null, null);
INSERT INTO `orders` VALUES ('175', '1513013155', '43', 'Josef Josef', '', 'navarrojosef@gmail.com', 'hong hu', '', '2017-12-12 01:25:14', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-12 01:25:14', '4150714155', null, null);
INSERT INTO `orders` VALUES ('176', '1513013155', '45', 'Josef Josef', '', 'navarrojosef@gmail.com', 'itsly', '', '2017-12-12 01:27:17', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-12 01:27:17', 'C75E559155', null, null);
INSERT INTO `orders` VALUES ('177', '1513049579', '38', 'q', '1', 'qwerty@gmail.com', 'q', '', '2017-12-12 10:35:14', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-12 10:35:14', 'F45AA3B579', null, null);
INSERT INTO `orders` VALUES ('178', '1513049579', '38', 'q', '1', 'qwerty@gmail.com', 'q', '', '2017-12-19 15:08:57', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-19 15:08:57', '063974E579', null, null);
INSERT INTO `orders` VALUES ('179', '1513682441', '39', 'm awais', '03407009090', 'awais@yahoo.com', 'p500 nighebanpura fsd', '', '2017-12-19 16:45', '3', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-19 18:27:18', '7076F3E441', null, null);
INSERT INTO `orders` VALUES ('180', '1513682441', '39', 'm awais', '03407009090', 'awais@yahoo.com', 'p500 nighebanpura fsd', '', '2017-12-19 16:45', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-19 18:27:36', '85FB5CE441', null, null);
INSERT INTO `orders` VALUES ('181', '1514403224', '38', 'TIAGO TINEO INACIO', '11966829908', 'tiago_tineo@hotmail.com', 'Rua Quartim Barbosa, 220', '', '2017-12-28 06:10:40', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2017-12-28 06:10:40', '9B9A562224', null, null);
INSERT INTO `orders` VALUES ('182', '1515616435', '38', 'Mayara Mayara', '79988093920', 'mayaracostamuller12@gmail.com', 'rua José adilson andrade', '', '2018-01-11 03:34:55', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-01-11 03:34:55', '4E33A94435', null, null);
INSERT INTO `orders` VALUES ('183', '1515616435', '39', 'Mayara Mayara', '79988093920', 'mayaracostamuller12@gmail.com', 'rua José adilson andrade', '', '2018-01-11 03:34:55', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-01-11 03:34:55', '4E33A94435', null, null);
INSERT INTO `orders` VALUES ('184', '1515616435', '61', 'Mayara Mayara', '799909414', 'mayaracostamuller12@gmail.com', 'teste', '', '2018-01-12 12:15', '4', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-01-12 22:02:53', '9D703EF435', null, null);
INSERT INTO `orders` VALUES ('185', '1519025693', '38', 'Gurwinder Gurwinder', '965666666', '786gurwinder@gmail.com', 'Fjvhh', '', '2018-02-19 14:59:10', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-02-19 14:59:10', 'A9CFD1C693', null, null);
INSERT INTO `orders` VALUES ('186', '1520326435', '41', 'Andi Abi Dzar Makkasau', '5588', 'abidzarsudarsono@yahoo.co.id', 'hyy', '', '2018-03-06 15:54:17', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-03-06 15:54:17', 'FFF946D435', null, null);
INSERT INTO `orders` VALUES ('187', '1499456390', '60', 'luis', '945547947', 'luispucutay@gmail.com', 'peru', '', '2018-03-08 00:59:46', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-03-08 00:59:46', '6B23AF6390', null, null);
INSERT INTO `orders` VALUES ('188', '1521162344', '62', 'luis', '153', 'lpucutayl@hotmail.com', 'av peru', '', '2018-03-16 20:30', '3', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-03-16 08:06:31', 'C0D2914344', null, null);
INSERT INTO `orders` VALUES ('189', '1521162344', '60', 'luis', '153', 'lpucutayl@hotmail.com', 'av peru', '', '2018-03-24 01:41:39', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-03-24 01:41:39', '5403EE7344', null, null);
INSERT INTO `orders` VALUES ('190', '1432968683', '38', 'Chris', '620424505', 'hicomtim@gmail.com', '123 King Street', '', '2018-03-24 14:06:05', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-03-24 14:06:05', '8644A08683', null, null);
INSERT INTO `orders` VALUES ('191', '1523129245', '47', 'Test', '123488', 'abc@abc.com', 'Wryg', '', '2018-04-08 02:31:29', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-04-08 02:31:29', '71BF8D0245', null, null);
INSERT INTO `orders` VALUES ('192', '1523129245', '52', 'Test', '123488', 'abc@abc.com', 'Wryg', '', '2018-04-08 02:31:29', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-04-08 02:31:29', '71BF8D0245', null, null);
INSERT INTO `orders` VALUES ('193', '1523129245', '39', 'Test', '123488', 'abc@abc.com', 'Wryg', '', '2018-04-08 02:31:29', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-04-08 02:31:29', '71BF8D0245', null, null);
INSERT INTO `orders` VALUES ('194', '1526078110', '43', 'feilong fky', '016888888888', 'feilong313@gmail.com', 'kkkkkkk', '', '2018-05-12 23:15', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-05-12 05:38:03', '11A19DA110', null, null);
INSERT INTO `orders` VALUES ('195', '1528326652', '38', 'Nicholas Nicholas', '', 'nginya@gmail.com', 'buruburu', '', '2018-06-07 06:15:57', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-06-07 06:15:57', '14D096B652', null, null);
INSERT INTO `orders` VALUES ('196', '1528326652', '43', 'Nicholas Nicholas', '', 'nginya@gmail.com', 'buruburu', '', '2018-06-07 17:45', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-06-07 06:15:57', '14D096B652', null, null);
INSERT INTO `orders` VALUES ('197', '1528326652', '38', 'Nicholas Nicholas', '', 'nginya@gmail.com', 'gfdsr', '', '2018-06-08 06:10:30', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-06-08 06:10:30', '6A03747652', null, null);
INSERT INTO `orders` VALUES ('198', '1534839769', '43', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-21 15:59:56', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-21 15:59:56', '250DA8E769', null, null);
INSERT INTO `orders` VALUES ('199', '1534839769', '38', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-21 15:59:56', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-21 15:59:56', '250DA8E769', null, null);
INSERT INTO `orders` VALUES ('200', '1534839769', '46', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-21 15:59:56', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-21 15:59:56', '250DA8E769', null, null);
INSERT INTO `orders` VALUES ('201', '1534839769', '38', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-22 15:04:26', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-22 15:04:26', '631D412769', null, null);
INSERT INTO `orders` VALUES ('202', '0', '46', 'Stephen', '9942048657', 'admin@gmaiadmoinl.com', 'Sydney', '', '2018-08-27 09:50:37', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-27 09:50:37', 'B5C32920', null, null);
INSERT INTO `orders` VALUES ('203', '0', '38', 'Stephen', '9942048657', 'admin@gmail.com', 'Sydney', '', '2018-08-27 09:53:59', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-27 09:53:59', 'F55E2230', null, null);
INSERT INTO `orders` VALUES ('204', '0', '45', 'Stephen', '9942048657', 'admin@gmail.com', 'Sydney', '', '2018-08-27 09:53:59', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-27 09:53:59', 'F55E2230', null, null);
INSERT INTO `orders` VALUES ('205', '1534839769', '46', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-29 11:58:20', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-29 11:58:20', '0517576769', null, null);
INSERT INTO `orders` VALUES ('206', '1534839769', '46', 'lvhuy', '09782224245', 'lvhuy@gmail.com', 'thanh hía', '', '2018-08-29 12:00:52', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-08-29 12:00:52', '2ED5818769', null, null);
INSERT INTO `orders` VALUES ('207', '1480169682', '38', 'glenn', '0912345678', 'glennbarz@gmail.com', '123 dfg', '', '2018-09-07 10:03:45', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-07 10:03:45', 'B380780682', null, null);
INSERT INTO `orders` VALUES ('208', '1480169682', '43', 'glenn', '0912345678', 'glennbarz@gmail.com', '123 dfg', '', '2018-09-07 10:03:45', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-07 10:03:45', 'B380780682', null, null);
INSERT INTO `orders` VALUES ('209', '1537222690', '46', 'test3', '123456', 'test3@yahoo.com', '22  bangazi', '', '2018-09-18 05:20:56', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-18 05:20:56', 'B609606690', null, null);
INSERT INTO `orders` VALUES ('210', '1537273068', '68', 'test4', '2580', 'test4@yahoo.com', '55 الحدائق', '', '2018-09-18 13:30', '2', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-18 19:20:55', 'CB4BA40068', null, null);
INSERT INTO `orders` VALUES ('211', '1537222690', '68', 'test3', '123456', 'test3@yahoo.com', '22  bangazi', '', '2018-09-19 03:22:18', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-19 03:22:18', '6722E41690', null, null);
INSERT INTO `orders` VALUES ('212', '1537222690', '68', 'test3', '123456', 'test3@yahoo.com', '22  bangazi', '', '2018-09-19 03:23:18', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-19 03:23:18', '570D570690', null, null);
INSERT INTO `orders` VALUES ('213', '1537222690', '68', 'test3', '123456', 'test3@yahoo.com', '22  bangazi', '', '2018-09-19 03:24:43', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-09-19 03:24:43', 'CB2DF37690', null, null);
INSERT INTO `orders` VALUES ('214', '1538539109', '38', 'Bdshdj', '876464', 'anndjdj@gmail.com', 'Cjjdjf', '', '2018-10-03 10:59:09', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-10-03 10:59:09', 'F127F70109', null, null);
INSERT INTO `orders` VALUES ('215', '1538539109', '38', 'Bdshdj', '876464', 'anndjdj@gmail.com', 'Cjjdjf', '', '2018-10-03 10:59:47', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-10-03 10:59:47', '8204F11109', null, null);
INSERT INTO `orders` VALUES ('216', '1538539109', '38', 'Bdshdj', '876464', 'anndjdj@gmail.com', 'Cjjdjf', '', '2018-10-03 11:09:31', '0', '1', 'PAYMENT_CASH_ON_DELIVERY', '0', '2018-10-03 11:09:31', '1FB0ADB109', null, null);

-- ----------------------------
-- Table structure for `order_food`
-- ----------------------------
CREATE TABLE `order_food` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `food_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `price` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=338 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of order_food
-- ----------------------------
INSERT INTO `order_food` VALUES ('3', '1', '12', '1', '100');
INSERT INTO `order_food` VALUES ('8', '6', '6', '1', '10');
INSERT INTO `order_food` VALUES ('9', '6', '7', '1', '5');
INSERT INTO `order_food` VALUES ('12', '7', '5', '3', '123');
INSERT INTO `order_food` VALUES ('13', '7', '12', '2', '100');
INSERT INTO `order_food` VALUES ('14', '3', '12', '1', '100');
INSERT INTO `order_food` VALUES ('15', '3', '13', '1', '300');
INSERT INTO `order_food` VALUES ('17', '8', '1', '1', '99');
INSERT INTO `order_food` VALUES ('18', '9', '7', '1', '5');
INSERT INTO `order_food` VALUES ('25', '15', '5', '1', '123');
INSERT INTO `order_food` VALUES ('26', '15', '12', '1', '100');
INSERT INTO `order_food` VALUES ('30', '5', '8', '1', '11');
INSERT INTO `order_food` VALUES ('32', '2', '1', '5', '99');
INSERT INTO `order_food` VALUES ('36', '4', '6', '1', '10');
INSERT INTO `order_food` VALUES ('37', '16', '6', '1', '10');
INSERT INTO `order_food` VALUES ('38', '13', '1', '1', '99');
INSERT INTO `order_food` VALUES ('39', '17', '1', '1', '99');
INSERT INTO `order_food` VALUES ('40', '18', '6', '1', '10');
INSERT INTO `order_food` VALUES ('41', '19', '6', '1', '10');
INSERT INTO `order_food` VALUES ('49', '22', '13', '2', '300');
INSERT INTO `order_food` VALUES ('53', '23', '22', '1', '2');
INSERT INTO `order_food` VALUES ('56', '25', '8', '1', '11');
INSERT INTO `order_food` VALUES ('59', '27', '8', '1', '11');
INSERT INTO `order_food` VALUES ('61', '29', '27', '1', '4');
INSERT INTO `order_food` VALUES ('62', '30', '27', '1', '4');
INSERT INTO `order_food` VALUES ('63', '31', '27', '1', '4');
INSERT INTO `order_food` VALUES ('64', '32', '27', '1', '4');
INSERT INTO `order_food` VALUES ('65', '33', '13', '1', '300');
INSERT INTO `order_food` VALUES ('66', '34', '18', '1', '28');
INSERT INTO `order_food` VALUES ('67', '35', '19', '1', '15');
INSERT INTO `order_food` VALUES ('68', '36', '20', '1', '18');
INSERT INTO `order_food` VALUES ('69', '37', '22', '1', '2');
INSERT INTO `order_food` VALUES ('70', '37', '23', '1', '200');
INSERT INTO `order_food` VALUES ('71', '38', '6', '1', '10');
INSERT INTO `order_food` VALUES ('72', '39', '22', '1', '2');
INSERT INTO `order_food` VALUES ('73', '40', '21', '1', '2');
INSERT INTO `order_food` VALUES ('74', '40', '23', '1', '200');
INSERT INTO `order_food` VALUES ('75', '41', '1', '1', '99');
INSERT INTO `order_food` VALUES ('81', '43', '1', '1', '99');
INSERT INTO `order_food` VALUES ('82', '44', '1', '1', '99');
INSERT INTO `order_food` VALUES ('83', '45', '1', '1', '99');
INSERT INTO `order_food` VALUES ('85', '47', '12', '3', '100');
INSERT INTO `order_food` VALUES ('87', '48', '22', '4', '2');
INSERT INTO `order_food` VALUES ('89', '49', '22', '5', '2');
INSERT INTO `order_food` VALUES ('90', '49', '21', '1', '2');
INSERT INTO `order_food` VALUES ('91', '50', '12', '1', '100');
INSERT INTO `order_food` VALUES ('92', '51', '14', '2', '20.7');
INSERT INTO `order_food` VALUES ('93', '51', '13', '1', '300');
INSERT INTO `order_food` VALUES ('94', '52', '20', '1', '18');
INSERT INTO `order_food` VALUES ('95', '53', '18', '1', '28');
INSERT INTO `order_food` VALUES ('96', '54', '17', '1', '30');
INSERT INTO `order_food` VALUES ('97', '55', '17', '1', '30');
INSERT INTO `order_food` VALUES ('98', '56', '17', '1', '30');
INSERT INTO `order_food` VALUES ('99', '57', '17', '1', '30');
INSERT INTO `order_food` VALUES ('100', '58', '20', '1', '18');
INSERT INTO `order_food` VALUES ('101', '59', '28', '1', '4');
INSERT INTO `order_food` VALUES ('102', '60', '23', '1', '200');
INSERT INTO `order_food` VALUES ('103', '61', '21', '1', '2');
INSERT INTO `order_food` VALUES ('104', '62', '28', '3', '4');
INSERT INTO `order_food` VALUES ('105', '63', '19', '1', '15');
INSERT INTO `order_food` VALUES ('106', '64', '17', '1', '30');
INSERT INTO `order_food` VALUES ('107', '64', '18', '2', '28');
INSERT INTO `order_food` VALUES ('108', '65', '23', '3', '200');
INSERT INTO `order_food` VALUES ('109', '66', '27', '1', '4');
INSERT INTO `order_food` VALUES ('110', '67', '12', '1', '100');
INSERT INTO `order_food` VALUES ('111', '68', '17', '1', '30');
INSERT INTO `order_food` VALUES ('112', '69', '12', '1', '100');
INSERT INTO `order_food` VALUES ('113', '70', '28', '1', '4');
INSERT INTO `order_food` VALUES ('114', '71', '12', '1', '100');
INSERT INTO `order_food` VALUES ('115', '71', '7', '1', '5');
INSERT INTO `order_food` VALUES ('117', '72', '24', '1', '5');
INSERT INTO `order_food` VALUES ('118', '20', '21', '2', '2');
INSERT INTO `order_food` VALUES ('119', '20', '20', '1', '18');
INSERT INTO `order_food` VALUES ('120', '46', '7', '1', '5');
INSERT INTO `order_food` VALUES ('121', '73', '19', '1', '15');
INSERT INTO `order_food` VALUES ('122', '74', '29', '1', '454');
INSERT INTO `order_food` VALUES ('123', '75', '18', '3', '28');
INSERT INTO `order_food` VALUES ('124', '76', '30', '1', '1690');
INSERT INTO `order_food` VALUES ('125', '77', '31', '1', '30');
INSERT INTO `order_food` VALUES ('126', '78', '24', '1', '5');
INSERT INTO `order_food` VALUES ('127', '79', '20', '1', '18');
INSERT INTO `order_food` VALUES ('128', '80', '29', '1', '454');
INSERT INTO `order_food` VALUES ('129', '81', '12', '2', '100');
INSERT INTO `order_food` VALUES ('130', '80', '28', '2', '4');
INSERT INTO `order_food` VALUES ('131', '82', '29', '1', '454');
INSERT INTO `order_food` VALUES ('132', '83', '29', '1', '454');
INSERT INTO `order_food` VALUES ('133', '84', '12', '1', '100');
INSERT INTO `order_food` VALUES ('134', '85', '29', '1', '454');
INSERT INTO `order_food` VALUES ('135', '86', '30', '1', '1690');
INSERT INTO `order_food` VALUES ('137', '88', '28', '1', '4');
INSERT INTO `order_food` VALUES ('139', '89', '32', '1', '12');
INSERT INTO `order_food` VALUES ('140', '87', '24', '1', '5');
INSERT INTO `order_food` VALUES ('141', '90', '12', '3', '100');
INSERT INTO `order_food` VALUES ('142', '91', '18', '1', '28');
INSERT INTO `order_food` VALUES ('143', '92', '12', '3', '100');
INSERT INTO `order_food` VALUES ('144', '93', '18', '1', '28');
INSERT INTO `order_food` VALUES ('145', '94', '21', '1', '2');
INSERT INTO `order_food` VALUES ('146', '95', '23', '1', '200');
INSERT INTO `order_food` VALUES ('147', '96', '20', '1', '18');
INSERT INTO `order_food` VALUES ('148', '97', '22', '1', '2');
INSERT INTO `order_food` VALUES ('150', '99', '32', '1', '12');
INSERT INTO `order_food` VALUES ('151', '100', '32', '1', '12');
INSERT INTO `order_food` VALUES ('152', '100', '32', '1', '12');
INSERT INTO `order_food` VALUES ('153', '98', '24', '1', '5');
INSERT INTO `order_food` VALUES ('157', '103', '24', '2', '5');
INSERT INTO `order_food` VALUES ('158', '102', '29', '1', '454');
INSERT INTO `order_food` VALUES ('160', '101', '20', '2', '18');
INSERT INTO `order_food` VALUES ('161', '104', '20', '1', '18');
INSERT INTO `order_food` VALUES ('162', '105', '17', '1', '30');
INSERT INTO `order_food` VALUES ('163', '106', '24', '1', '5');
INSERT INTO `order_food` VALUES ('164', '107', '19', '1', '15');
INSERT INTO `order_food` VALUES ('165', '108', '12', '1', '100');
INSERT INTO `order_food` VALUES ('166', '109', '29', '1', '454');
INSERT INTO `order_food` VALUES ('168', '111', '12', '1', '100');
INSERT INTO `order_food` VALUES ('169', '28', '27', '1', '4');
INSERT INTO `order_food` VALUES ('175', '112', '24', '2', '5');
INSERT INTO `order_food` VALUES ('178', '113', '5', '1', '123');
INSERT INTO `order_food` VALUES ('179', '114', '23', '1', '200');
INSERT INTO `order_food` VALUES ('180', '115', '29', '1', '454');
INSERT INTO `order_food` VALUES ('181', '115', '28', '1', '4');
INSERT INTO `order_food` VALUES ('182', '116', '20', '1', '18');
INSERT INTO `order_food` VALUES ('183', '117', '29', '1', '454');
INSERT INTO `order_food` VALUES ('184', '118', '29', '1', '454');
INSERT INTO `order_food` VALUES ('185', '119', '22', '1', '2');
INSERT INTO `order_food` VALUES ('186', '120', '28', '1', '4');
INSERT INTO `order_food` VALUES ('187', '121', '22', '3', '2');
INSERT INTO `order_food` VALUES ('188', '121', '19', '7', '15');
INSERT INTO `order_food` VALUES ('189', '122', '28', '1', '4');
INSERT INTO `order_food` VALUES ('190', '123', '24', '3', '5');
INSERT INTO `order_food` VALUES ('191', '124', '19', '2', '15');
INSERT INTO `order_food` VALUES ('192', '125', '19', '1', '15');
INSERT INTO `order_food` VALUES ('196', '126', '19', '1', '15');
INSERT INTO `order_food` VALUES ('197', '126', '23', '1', '200');
INSERT INTO `order_food` VALUES ('198', '21', '21', '1', '2');
INSERT INTO `order_food` VALUES ('199', '21', '22', '1', '2');
INSERT INTO `order_food` VALUES ('200', '21', '23', '1', '200');
INSERT INTO `order_food` VALUES ('201', '24', '20', '1', '18');
INSERT INTO `order_food` VALUES ('202', '24', '22', '1', '2');
INSERT INTO `order_food` VALUES ('203', '26', '20', '1', '18');
INSERT INTO `order_food` VALUES ('204', '26', '22', '1', '2');
INSERT INTO `order_food` VALUES ('209', '128', '19', '1', '15');
INSERT INTO `order_food` VALUES ('210', '129', '28', '1', '4');
INSERT INTO `order_food` VALUES ('211', '130', '20', '1', '18');
INSERT INTO `order_food` VALUES ('214', '132', '17', '1', '30');
INSERT INTO `order_food` VALUES ('215', '132', '18', '1', '28');
INSERT INTO `order_food` VALUES ('240', '154', '12', '1', '100');
INSERT INTO `order_food` VALUES ('261', '141', '32', '1', '12');
INSERT INTO `order_food` VALUES ('262', '165', '32', '2', '12');
INSERT INTO `order_food` VALUES ('263', '169', '39', '1', '20');
INSERT INTO `order_food` VALUES ('264', '170', '39', '1', '20');
INSERT INTO `order_food` VALUES ('265', '171', '22', '1', '2');
INSERT INTO `order_food` VALUES ('266', '172', '22', '1', '2');
INSERT INTO `order_food` VALUES ('268', '173', '13', '2', '300');
INSERT INTO `order_food` VALUES ('269', '174', '32', '1', '12');
INSERT INTO `order_food` VALUES ('270', '175', '23', '1', '200');
INSERT INTO `order_food` VALUES ('271', '175', '33', '1', '3.98');
INSERT INTO `order_food` VALUES ('272', '176', '27', '1', '4');
INSERT INTO `order_food` VALUES ('273', '177', '28', '1', '4');
INSERT INTO `order_food` VALUES ('274', '178', '29', '1', '454');
INSERT INTO `order_food` VALUES ('278', '180', '17', '1', '30');
INSERT INTO `order_food` VALUES ('281', '179', '17', '1', '30');
INSERT INTO `order_food` VALUES ('282', '181', '29', '1', '454');
INSERT INTO `order_food` VALUES ('283', '182', '29', '1', '454');
INSERT INTO `order_food` VALUES ('284', '183', '17', '1', '30');
INSERT INTO `order_food` VALUES ('286', '184', '40', '1', '39.9');
INSERT INTO `order_food` VALUES ('287', '185', '28', '2', '4');
INSERT INTO `order_food` VALUES ('288', '186', '24', '1', '5');
INSERT INTO `order_food` VALUES ('289', '187', '39', '1', '20');
INSERT INTO `order_food` VALUES ('292', '188', '41', '1', '15');
INSERT INTO `order_food` VALUES ('293', '189', '39', '1', '20');
INSERT INTO `order_food` VALUES ('294', '190', '29', '1', '454');
INSERT INTO `order_food` VALUES ('295', '191', '12', '1', '100');
INSERT INTO `order_food` VALUES ('296', '192', '32', '1', '12');
INSERT INTO `order_food` VALUES ('297', '193', '17', '1', '30');
INSERT INTO `order_food` VALUES ('298', '191', '6', '1', '10');
INSERT INTO `order_food` VALUES ('303', '194', '22', '1', '2');
INSERT INTO `order_food` VALUES ('304', '195', '28', '1', '4');
INSERT INTO `order_food` VALUES ('305', '195', '29', '1', '454');
INSERT INTO `order_food` VALUES ('306', '195', '30', '1', '1690');
INSERT INTO `order_food` VALUES ('309', '196', '23', '1', '200');
INSERT INTO `order_food` VALUES ('310', '196', '20', '1', '18');
INSERT INTO `order_food` VALUES ('311', '197', '29', '4', '454');
INSERT INTO `order_food` VALUES ('312', '197', '30', '10', '1690');
INSERT INTO `order_food` VALUES ('313', '198', '19', '5', '15');
INSERT INTO `order_food` VALUES ('314', '199', '29', '1', '454');
INSERT INTO `order_food` VALUES ('315', '200', '5', '1', '123');
INSERT INTO `order_food` VALUES ('316', '201', '28', '1', '4');
INSERT INTO `order_food` VALUES ('317', '202', '5', '1', '123');
INSERT INTO `order_food` VALUES ('318', '203', '28', '1', '4');
INSERT INTO `order_food` VALUES ('319', '203', '29', '1', '454');
INSERT INTO `order_food` VALUES ('320', '203', '30', '1', '1690');
INSERT INTO `order_food` VALUES ('321', '204', '27', '1', '4');
INSERT INTO `order_food` VALUES ('322', '205', '1', '1', '99');
INSERT INTO `order_food` VALUES ('323', '205', '3', '1', '28');
INSERT INTO `order_food` VALUES ('324', '206', '1', '1', '99');
INSERT INTO `order_food` VALUES ('325', '206', '3', '1', '28');
INSERT INTO `order_food` VALUES ('326', '207', '28', '1', '4');
INSERT INTO `order_food` VALUES ('327', '207', '29', '1', '454');
INSERT INTO `order_food` VALUES ('328', '208', '20', '1', '18');
INSERT INTO `order_food` VALUES ('329', '209', '5', '1', '123');
INSERT INTO `order_food` VALUES ('331', '210', '45', '1', '20');
INSERT INTO `order_food` VALUES ('332', '211', '45', '1', '20');
INSERT INTO `order_food` VALUES ('333', '212', '45', '1', '20');
INSERT INTO `order_food` VALUES ('334', '213', '45', '1', '20');
INSERT INTO `order_food` VALUES ('335', '214', '28', '1', '4');
INSERT INTO `order_food` VALUES ('336', '215', '28', '1', '4');
INSERT INTO `order_food` VALUES ('337', '216', '28', '1', '4');

-- ----------------------------
-- Table structure for `order_group`
-- ----------------------------
CREATE TABLE `order_group` (
  `group_code` varchar(255) NOT NULL DEFAULT '',
  `total` float DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `account_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`group_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_group
-- ----------------------------
INSERT INTO `order_group` VALUES ('00D6F7C812', '121', '2016-11-08 09:53:57', '1478510812');
INSERT INTO `order_group` VALUES ('0173C75013', '128', '2016-08-20 16:50:17', '1466830013');
INSERT INTO `order_group` VALUES ('019E43E848', '1878.1', '2017-01-02 15:31:23', '1483345848');
INSERT INTO `order_group` VALUES ('034B5220', '12', '2016-09-20 10:21:16', '0');
INSERT INTO `order_group` VALUES ('0517576769', '127', '2018-08-29 11:58:20', '1534839769');
INSERT INTO `order_group` VALUES ('055B154029', '75.9', '2017-09-13 02:49:35', '1505233029');
INSERT INTO `order_group` VALUES ('063974E579', '511.5', '2017-12-19 15:08:57', '1513049579');
INSERT INTO `order_group` VALUES ('0CE2C49344', '233.2', '2016-09-22 15:55:35', '1474442344');
INSERT INTO `order_group` VALUES ('0E56094278', '100', '2016-11-22 22:59:52', '1479830278');
INSERT INTO `order_group` VALUES ('11A19DA110', '7.98', '2018-05-12 05:38:03', '1526078110');
INSERT INTO `order_group` VALUES ('12A2420665', '231', '2016-12-10 02:48:26', '1481312665');
INSERT INTO `order_group` VALUES ('14D096B652', '2617.02', '2018-06-07 06:15:57', '1528326652');
INSERT INTO `order_group` VALUES ('1A8A8BE549', '19.8', '2016-11-09 14:09:41', '1441015549');
INSERT INTO `order_group` VALUES ('1AE2267178', '16.5', '2017-01-04 03:12:41', '1482128178');
INSERT INTO `order_group` VALUES ('1B8FCF0891', '22', '2017-07-28 00:31:44', '1501068891');
INSERT INTO `order_group` VALUES ('1D8BF98344', '5.25', '2016-09-22 09:55:14', '1474442344');
INSERT INTO `order_group` VALUES ('1DA3169644', '52.1', '2017-07-25 15:02:34', '1500967644');
INSERT INTO `order_group` VALUES ('1FB0ADB109', '16.5', '2018-10-03 11:09:31', '1538539109');
INSERT INTO `order_group` VALUES ('200B504390', '0', '2017-07-08 02:41:25', '1499456390');
INSERT INTO `order_group` VALUES ('2032921549', '24.2', '2016-11-09 14:14:25', '1441015549');
INSERT INTO `order_group` VALUES ('21E88C50', '112', '2016-12-14 17:34:24', '0');
INSERT INTO `order_group` VALUES ('250DA8E769', '725.7', '2018-08-21 15:59:56', '1534839769');
INSERT INTO `order_group` VALUES ('25E03A2169', '568.6', '2017-07-22 13:20:04', '1500704169');
INSERT INTO `order_group` VALUES ('26B6021149', '342.9', '2017-03-03 08:09:03', '1488503149');
INSERT INTO `order_group` VALUES ('276FB0A757', '32.3', '2016-12-19 14:25:24', '1432968757');
INSERT INTO `order_group` VALUES ('281C7E0908', '121', '2016-10-16 04:31:26', '1476566908');
INSERT INTO `order_group` VALUES ('2ED5818769', '127', '2018-08-29 12:00:52', '1534839769');
INSERT INTO `order_group` VALUES ('3160154690', '30.8', '2016-11-28 03:33:16', '1480278690');
INSERT INTO `order_group` VALUES ('3268C84492', '12', '2017-08-01 13:38:45', '1501569492');
INSERT INTO `order_group` VALUES ('346F84F891', '100', '2017-07-31 02:26:24', '1501068891');
INSERT INTO `order_group` VALUES ('3A4F4AB914', '600', '2017-11-16 00:51:25', '1510767914');
INSERT INTO `order_group` VALUES ('3C4CEBA0', '25.3', '2016-12-13 14:59:22', '0');
INSERT INTO `order_group` VALUES ('3FBCBD4344', '5.25', '2016-09-22 09:44:27', '1474442344');
INSERT INTO `order_group` VALUES ('4150714155', '238.237', '2017-12-12 01:25:14', '1513013155');
INSERT INTO `order_group` VALUES ('4333A47364', '511.5', '2017-08-11 14:52:50', '1450176364');
INSERT INTO `order_group` VALUES ('47730B8891', '22', '2017-08-12 14:20:50', '1501068891');
INSERT INTO `order_group` VALUES ('47A97BC364', '16.5', '2017-08-11 15:50:15', '1450176364');
INSERT INTO `order_group` VALUES ('47F86AA455', '7.98', '2017-11-13 21:37:12', '1510576455');
INSERT INTO `order_group` VALUES ('48DBC58178', '511.5', '2016-12-28 05:37:15', '1482128178');
INSERT INTO `order_group` VALUES ('4B9AB6D111', '656.6', '2016-07-12 17:07:16', '1397811111');
INSERT INTO `order_group` VALUES ('4E33A94435', '556.6', '2018-01-11 03:34:55', '1515616435');
INSERT INTO `order_group` VALUES ('4FE6264344', '27.5', '2016-09-22 13:56:55', '1474442344');
INSERT INTO `order_group` VALUES ('53043BF270', '12', '2017-11-21 01:42:11', '1511203270');
INSERT INTO `order_group` VALUES ('5403EE7344', '20', '2018-03-24 01:41:39', '1521162344');
INSERT INTO `order_group` VALUES ('54C229B970', '300', '2016-11-08 10:56:38', '1478572970');
INSERT INTO `order_group` VALUES ('55DCDFC429', '7', '2017-04-26 18:18:10', '1493205429');
INSERT INTO `order_group` VALUES ('561B0E6029', '24', '2017-09-13 03:31:14', '1505233029');
INSERT INTO `order_group` VALUES ('570D570690', '20', '2018-09-19 03:23:18', '1537222690');
INSERT INTO `order_group` VALUES ('59FD02F437', '225.5', '2017-04-03 17:47:58', '1491216437');
INSERT INTO `order_group` VALUES ('5A7270A344', '5.25', '2016-09-22 09:47:03', '1474442344');
INSERT INTO `order_group` VALUES ('5F69DC0364', '7.7', '2017-08-11 14:53:53', '1450176364');
INSERT INTO `order_group` VALUES ('604A73C665', '13.2', '2016-12-10 03:00:19', '1481312665');
INSERT INTO `order_group` VALUES ('6152E47111', '400', '2016-07-12 17:09:07', '1397811111');
INSERT INTO `order_group` VALUES ('631D412769', '16.5', '2018-08-22 15:04:26', '1534839769');
INSERT INTO `order_group` VALUES ('63AD1EC075', '55.5', '2017-08-11 20:26:44', '1502457075');
INSERT INTO `order_group` VALUES ('6722E41690', '20', '2018-09-19 03:22:18', '1537222690');
INSERT INTO `order_group` VALUES ('6A03747652', '20587.6', '2018-06-08 06:10:30', '1528326652');
INSERT INTO `order_group` VALUES ('6B23AF6390', '20', '2018-03-08 00:59:46', '1499456390');
INSERT INTO `order_group` VALUES ('6E9C694126', '121', '2016-10-24 17:02:07', '1477303126');
INSERT INTO `order_group` VALUES ('7076F3E441', '45.1', '2017-12-19 18:27:18', '1513682441');
INSERT INTO `order_group` VALUES ('70C9BEA812', '121', '2016-11-08 08:44:29', '1478510812');
INSERT INTO `order_group` VALUES ('71BF8D0245', '167.1', '2018-04-08 02:31:29', '1523129245');
INSERT INTO `order_group` VALUES ('72D9893397', '145.1', '2016-12-14 14:16:28', '1450162397');
INSERT INTO `order_group` VALUES ('7872BCF195', '242', '2017-08-18 13:20:32', '1503037195');
INSERT INTO `order_group` VALUES ('78AD5B7344', '13.2', '2016-09-22 15:43:43', '1474442344');
INSERT INTO `order_group` VALUES ('7A667BE029', '100', '2017-09-13 03:27:05', '1505233029');
INSERT INTO `order_group` VALUES ('7D29AB0970', '7', '2016-11-08 10:50:21', '1478572970');
INSERT INTO `order_group` VALUES ('8081F35364', '127.6', '2017-08-11 15:48:05', '1450176364');
INSERT INTO `order_group` VALUES ('8204F11109', '16.5', '2018-10-03 10:59:47', '1538539109');
INSERT INTO `order_group` VALUES ('85EF537344', '39.5', '2016-09-22 08:06:19', '1474442344');
INSERT INTO `order_group` VALUES ('85FB5CE441', '45.1', '2017-12-19 18:27:36', '1513682441');
INSERT INTO `order_group` VALUES ('8644A08683', '511.5', '2018-03-24 14:06:05', '1432968683');
INSERT INTO `order_group` VALUES ('8DA2AE9287', '515.9', '2017-08-03 17:40:10', '1501755287');
INSERT INTO `order_group` VALUES ('8E75221492', '348.5', '2017-08-01 13:46:02', '1501569492');
INSERT INTO `order_group` VALUES ('8E9F039793', '45.1', '2016-11-29 13:54:10', '1480360793');
INSERT INTO `order_group` VALUES ('98DBD4A793', '45.1', '2016-11-29 13:48:57', '1480360793');
INSERT INTO `order_group` VALUES ('9B9A562224', '511.5', '2017-12-28 06:10:40', '1514403224');
INSERT INTO `order_group` VALUES ('9BC528B604', '20', '2017-10-02 09:17:09', '1506910604');
INSERT INTO `order_group` VALUES ('9D703EF435', '39.9', '2018-01-12 22:02:53', '1515616435');
INSERT INTO `order_group` VALUES ('9EFE3D7936', '12', '2017-07-01 17:17:47', '1498903936');
INSERT INTO `order_group` VALUES ('9F0A456178', '511.5', '2016-12-27 16:36:44', '1482128178');
INSERT INTO `order_group` VALUES ('A344E5E972', '7.7', '2017-04-07 16:07:41', '1491555972');
INSERT INTO `order_group` VALUES ('A8DC8BA741', '16.5', '2017-09-06 14:26:09', '1504682741');
INSERT INTO `order_group` VALUES ('A90973B111', '24', '2016-07-12 17:13:02', '1397811111');
INSERT INTO `order_group` VALUES ('A9CFD1C693', '20.9', '2018-02-19 14:59:10', '1519025693');
INSERT INTO `order_group` VALUES ('ACFE0BD216', '536.8', '2017-08-07 16:30:53', '1502098216');
INSERT INTO `order_group` VALUES ('AF2C2F5344', '5.25', '2016-09-22 09:44:52', '1474442344');
INSERT INTO `order_group` VALUES ('AFAFA45149', '342.9', '2017-03-03 08:09:20', '1488503149');
INSERT INTO `order_group` VALUES ('AFDAE49013', '121', '2016-08-20 12:01:01', '1466830013');
INSERT INTO `order_group` VALUES ('B24A7DA211', '22', '2017-09-06 13:28:17', '1504679211');
INSERT INTO `order_group` VALUES ('B2720C0107', '511.5', '2017-01-01 01:16:31', '1483208107');
INSERT INTO `order_group` VALUES ('B380780682', '542.12', '2018-09-07 10:03:45', '1480169682');
INSERT INTO `order_group` VALUES ('B3BC3B4757', '720.3', '2016-12-19 16:38:04', '1432968757');
INSERT INTO `order_group` VALUES ('B520F94092', '638', '2016-12-16 23:36:14', '1481906092');
INSERT INTO `order_group` VALUES ('B5C32920', '123', '2018-08-27 09:50:37', '0');
INSERT INTO `order_group` VALUES ('B609606690', '123', '2018-09-18 05:20:56', '1537222690');
INSERT INTO `order_group` VALUES ('B63E5A0344', '5.25', '2016-09-22 10:41:28', '1474442344');
INSERT INTO `order_group` VALUES ('BCF66B0344', '13.2', '2016-09-21 16:03:13', '1474442344');
INSERT INTO `order_group` VALUES ('C0D2914344', '15', '2018-03-16 08:06:31', '1521162344');
INSERT INTO `order_group` VALUES ('C2DE384690', '30.8', '2016-11-30 13:20:08', '1480278690');
INSERT INTO `order_group` VALUES ('C75E559155', '5.25', '2017-12-12 01:27:17', '1513013155');
INSERT INTO `order_group` VALUES ('CA2F0CB644', '25.3', '2017-07-25 15:01:26', '1500967644');
INSERT INTO `order_group` VALUES ('CB2DF37690', '20', '2018-09-19 03:24:43', '1537222690');
INSERT INTO `order_group` VALUES ('CB4BA40068', '20', '2018-09-18 19:20:55', '1537273068');
INSERT INTO `order_group` VALUES ('CBED10D015', '121', '2016-09-19 14:12:39', '1474269015');
INSERT INTO `order_group` VALUES ('CE4251F891', '611.5', '2017-07-31 01:14:18', '1501068891');
INSERT INTO `order_group` VALUES ('D22C716344', '39.5', '2016-09-22 08:06:12', '1474442344');
INSERT INTO `order_group` VALUES ('D2A19D1661', '7.7', '2017-03-31 18:51:18', '1490960661');
INSERT INTO `order_group` VALUES ('D52F1920', '782.95', '2016-12-14 11:32:43', '0');
INSERT INTO `order_group` VALUES ('D5306A0344', '30.8', '2016-09-22 13:58:11', '1474442344');
INSERT INTO `order_group` VALUES ('D55A1EC178', '1909.6', '2016-12-19 13:16:51', '1482128178');
INSERT INTO `order_group` VALUES ('D7B6C13391', '7.98', '2017-11-13 19:17:05', '1510575391');
INSERT INTO `order_group` VALUES ('DB0C6C2793', '45.1', '2016-11-29 20:40:41', '1480360793');
INSERT INTO `order_group` VALUES ('DCB26DD397', '116.5', '2016-12-14 14:29:26', '1450162397');
INSERT INTO `order_group` VALUES ('DE1387E013', '569', '2016-08-06 18:32:00', '1466830013');
INSERT INTO `order_group` VALUES ('DEBC167612', '16.5', '2016-12-04 21:02:47', '1480857612');
INSERT INTO `order_group` VALUES ('DED063C0', '12', '2016-09-20 14:40:15', '0');
INSERT INTO `order_group` VALUES ('DF745440', '100', '2016-12-28 10:15:02', '0');
INSERT INTO `order_group` VALUES ('E1631E8344', '300', '2016-09-22 13:46:31', '1474442344');
INSERT INTO `order_group` VALUES ('E1F9DE8344', '829.9', '2016-09-21 16:02:46', '1474442344');
INSERT INTO `order_group` VALUES ('E2EC592013', '17', '2016-07-24 15:38:45', '1466830013');
INSERT INTO `order_group` VALUES ('E5B942E972', '25.3', '2017-04-07 16:07:07', '1491555972');
INSERT INTO `order_group` VALUES ('EA55F4B344', '42.9', '2016-09-22 13:50:54', '1474442344');
INSERT INTO `order_group` VALUES ('EB09AC2793', '42.9', '2016-11-29 02:28:49', '1480360793');
INSERT INTO `order_group` VALUES ('EB4799B029', '25.3', '2017-09-12 23:19:43', '1505233029');
INSERT INTO `order_group` VALUES ('EBBD1C1670', '245.2', '2016-09-22 14:39:36', '1474527670');
INSERT INTO `order_group` VALUES ('ECA5C1A390', '12', '2017-07-08 02:41:25', '1499456390');
INSERT INTO `order_group` VALUES ('EE05390029', '12', '2017-09-13 03:25:52', '1505233029');
INSERT INTO `order_group` VALUES ('EE82FDF682', '341.4', '2016-11-26 21:16:55', '1480169682');
INSERT INTO `order_group` VALUES ('F064E32793', '45.1', '2016-11-29 14:28:29', '1480360793');
INSERT INTO `order_group` VALUES ('F127F70109', '16.5', '2018-10-03 10:59:09', '1538539109');
INSERT INTO `order_group` VALUES ('F128DEC390', '20', '2017-10-09 20:02:47', '1499456390');
INSERT INTO `order_group` VALUES ('F2F2B0E307', '12', '2017-02-05 21:04:28', '1486303307');
INSERT INTO `order_group` VALUES ('F45AA3B579', '16.5', '2017-12-12 10:35:14', '1513049579');
INSERT INTO `order_group` VALUES ('F46A374364', '16.5', '2017-08-11 15:20:37', '1450176364');
INSERT INTO `order_group` VALUES ('F55E2230', '2368.05', '2018-08-27 09:53:59', '0');
INSERT INTO `order_group` VALUES ('F97CED3013', '225', '2016-08-22 11:34:12', '1466830013');
INSERT INTO `order_group` VALUES ('FAA46930', '27.5', '2016-12-14 11:32:30', '0');
INSERT INTO `order_group` VALUES ('FC5FFF3344', '35.2', '2016-09-21 15:10:32', '1474442344');
INSERT INTO `order_group` VALUES ('FFF946D435', '7', '2018-03-06 15:54:17', '1520326435');

-- ----------------------------
-- Table structure for `order_total`
-- ----------------------------
CREATE TABLE `order_total` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderId` varchar(255) DEFAULT NULL,
  `total` float DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `shipping` double DEFAULT NULL,
  `grandTotal` double DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of order_total
-- ----------------------------
INSERT INTO `order_total` VALUES ('1', '1', '100', '0', '0', '100', '2016-07-12 17:07:48');
INSERT INTO `order_total` VALUES ('2', '2', '495', '50.6', '11', '556.6', '2016-08-28 12:42:27');
INSERT INTO `order_total` VALUES ('3', '3', '400', '0', '0', '400', '2016-08-11 10:09:04');
INSERT INTO `order_total` VALUES ('4', '4', '10', '0', '2', '12', '2016-08-29 15:03:16');
INSERT INTO `order_total` VALUES ('5', '5', '11', '0', '1', '12', '2016-08-28 12:30:00');
INSERT INTO `order_total` VALUES ('6', '6', '15', '0', '2', '17', '2016-07-24 15:38:45');
INSERT INTO `order_total` VALUES ('7', '7', '569', '0', '0', '569', '2016-08-11 10:08:46');
INSERT INTO `order_total` VALUES ('8', '8', '99', '11', '11', '121', '2016-08-20 16:50:17');
INSERT INTO `order_total` VALUES ('9', '9', '5', '0', '2', '7', '2016-08-20 16:50:17');
INSERT INTO `order_total` VALUES ('13', '13', '99', '11', '11', '121', '2016-09-10 21:09:23');
INSERT INTO `order_total` VALUES ('15', '15', '223', '0', '0', '223', '2016-08-22 11:34:12');
INSERT INTO `order_total` VALUES ('16', '16', '0', '0', '2', '2', '2016-08-29 15:06:37');
INSERT INTO `order_total` VALUES ('17', '17', '99', '11', '11', '121', '2016-09-19 14:12:39');
INSERT INTO `order_total` VALUES ('18', '18', '10', '0', '2', '12', '2016-09-20 10:21:16');
INSERT INTO `order_total` VALUES ('19', '19', '10', '0', '2', '12', '2016-09-20 14:40:15');
INSERT INTO `order_total` VALUES ('20', '20', '22', '3.2', '10', '35.2', '2016-12-15 11:00:02');
INSERT INTO `order_total` VALUES ('21', '21', '204', '20.9', '5', '229.9', '2017-08-22 22:06:14');
INSERT INTO `order_total` VALUES ('22', '22', '600', '0', '0', '600', '2016-09-21 16:02:46');
INSERT INTO `order_total` VALUES ('23', '23', '2', '1.2', '10', '13.2', '2016-09-21 16:15:50');
INSERT INTO `order_total` VALUES ('24', '24', '20', '2.5', '5', '27.5', '2017-08-22 22:07:24');
INSERT INTO `order_total` VALUES ('25', '25', '11', '0', '1', '12', '2016-09-22 08:06:12');
INSERT INTO `order_total` VALUES ('26', '26', '20', '2.5', '5', '27.5', '2017-08-22 22:07:48');
INSERT INTO `order_total` VALUES ('27', '27', '11', '0', '1', '12', '2016-09-22 08:06:19');
INSERT INTO `order_total` VALUES ('28', '28', '4', '0.25', '1', '5.25', '2017-08-01 13:30:56');
INSERT INTO `order_total` VALUES ('29', '29', '4', '0.25', '1', '5.25', '2016-09-22 09:44:52');
INSERT INTO `order_total` VALUES ('30', '30', '4', '0.25', '1', '5.25', '2016-09-22 09:47:03');
INSERT INTO `order_total` VALUES ('31', '31', '4', '0.25', '1', '5.25', '2016-09-22 09:55:14');
INSERT INTO `order_total` VALUES ('32', '32', '4', '0.25', '1', '5.25', '2016-09-22 10:41:28');
INSERT INTO `order_total` VALUES ('33', '33', '300', '0', '0', '300', '2016-09-22 13:46:31');
INSERT INTO `order_total` VALUES ('34', '34', '28', '3.9', '11', '42.9', '2016-09-22 13:50:54');
INSERT INTO `order_total` VALUES ('35', '35', '15', '2.5', '10', '27.5', '2016-09-22 13:56:55');
INSERT INTO `order_total` VALUES ('36', '36', '18', '2.8', '10', '30.8', '2016-09-22 13:58:11');
INSERT INTO `order_total` VALUES ('37', '37', '202', '21.2', '10', '233.2', '2016-09-22 14:39:36');
INSERT INTO `order_total` VALUES ('38', '38', '10', '0', '2', '12', '2016-09-22 14:39:36');
INSERT INTO `order_total` VALUES ('39', '39', '2', '1.2', '10', '13.2', '2016-09-22 15:43:43');
INSERT INTO `order_total` VALUES ('40', '40', '202', '21.2', '10', '233.2', '2016-09-22 15:55:35');
INSERT INTO `order_total` VALUES ('41', '41', '99', '11', '11', '121', '2016-10-16 04:31:26');
INSERT INTO `order_total` VALUES ('43', '43', '99', '11', '11', '121', '2016-10-24 21:13:40');
INSERT INTO `order_total` VALUES ('44', '44', '99', '11', '11', '121', '2016-11-08 08:44:29');
INSERT INTO `order_total` VALUES ('45', '45', '99', '11', '11', '121', '2016-11-08 09:53:57');
INSERT INTO `order_total` VALUES ('46', '46', '5', '0', '2', '7', '2016-12-15 11:21:56');
INSERT INTO `order_total` VALUES ('47', '47', '300', '0', '0', '300', '2016-11-08 10:56:38');
INSERT INTO `order_total` VALUES ('48', '48', '8', '1.8', '10', '19.8', '2016-11-09 14:11:36');
INSERT INTO `order_total` VALUES ('49', '49', '12', '2.2', '10', '24.2', '2016-11-09 14:17:48');
INSERT INTO `order_total` VALUES ('50', '50', '100', '0', '0', '100', '2016-11-22 22:59:52');
INSERT INTO `order_total` VALUES ('51', '51', '341.4', '0', '0', '341.4', '2016-11-26 21:16:55');
INSERT INTO `order_total` VALUES ('52', '52', '18', '2.8', '10', '30.8', '2016-11-28 03:33:16');
INSERT INTO `order_total` VALUES ('53', '53', '28', '3.9', '11', '42.9', '2016-11-29 02:28:49');
INSERT INTO `order_total` VALUES ('54', '54', '30', '4.1', '11', '45.1', '2016-11-29 13:48:57');
INSERT INTO `order_total` VALUES ('55', '55', '30', '4.1', '11', '45.1', '2016-11-29 13:54:10');
INSERT INTO `order_total` VALUES ('56', '56', '30', '4.1', '11', '45.1', '2016-11-29 14:28:29');
INSERT INTO `order_total` VALUES ('57', '57', '30', '4.1', '11', '45.1', '2016-11-29 20:40:41');
INSERT INTO `order_total` VALUES ('58', '58', '18', '2.8', '10', '30.8', '2016-11-30 13:20:08');
INSERT INTO `order_total` VALUES ('59', '59', '4', '1.5', '11', '16.5', '2016-12-04 21:02:47');
INSERT INTO `order_total` VALUES ('60', '60', '200', '21', '10', '231', '2016-12-10 02:48:26');
INSERT INTO `order_total` VALUES ('61', '61', '2', '1.2', '10', '13.2', '2016-12-10 03:00:19');
INSERT INTO `order_total` VALUES ('62', '62', '12', '2.3', '11', '25.3', '2016-12-13 14:59:22');
INSERT INTO `order_total` VALUES ('63', '63', '15', '2.5', '10', '27.5', '2016-12-14 11:32:30');
INSERT INTO `order_total` VALUES ('64', '64', '86', '9.7', '11', '106.7', '2016-12-14 11:32:43');
INSERT INTO `order_total` VALUES ('65', '65', '600', '61', '10', '671', '2016-12-14 11:32:43');
INSERT INTO `order_total` VALUES ('66', '66', '4', '0.25', '1', '5.25', '2016-12-14 11:32:43');
INSERT INTO `order_total` VALUES ('67', '67', '100', '0', '0', '100', '2016-12-14 14:16:28');
INSERT INTO `order_total` VALUES ('68', '68', '30', '4.1', '11', '45.1', '2016-12-14 14:16:28');
INSERT INTO `order_total` VALUES ('69', '69', '100', '0', '0', '100', '2016-12-14 14:29:26');
INSERT INTO `order_total` VALUES ('70', '70', '4', '1.5', '11', '16.5', '2016-12-14 14:29:26');
INSERT INTO `order_total` VALUES ('71', '71', '105', '0', '0', '105', '2016-12-14 17:34:24');
INSERT INTO `order_total` VALUES ('72', '72', '5', '0', '2', '7', '2016-12-15 10:22:29');
INSERT INTO `order_total` VALUES ('73', '73', '15', '2', '5', '22', '2016-12-16 23:36:14');
INSERT INTO `order_total` VALUES ('74', '74', '454', '46.5', '11', '511.5', '2016-12-16 23:36:14');
INSERT INTO `order_total` VALUES ('75', '75', '84', '9.5', '11', '104.5', '2016-12-16 23:36:14');
INSERT INTO `order_total` VALUES ('76', '76', '1690', '170.1', '11', '1871.1', '2016-12-19 13:16:51');
INSERT INTO `order_total` VALUES ('77', '77', '30', '3.5', '5', '38.5', '2016-12-19 13:16:51');
INSERT INTO `order_total` VALUES ('78', '78', '5', '0', '2', '7', '2016-12-19 14:25:24');
INSERT INTO `order_total` VALUES ('79', '79', '18', '2.3', '5', '25.3', '2016-12-19 14:25:24');
INSERT INTO `order_total` VALUES ('80', '80', '462', '47.3', '11', '520.3', '2016-12-19 16:38:04');
INSERT INTO `order_total` VALUES ('81', '81', '200', '0', '0', '200', '2016-12-19 16:38:04');
INSERT INTO `order_total` VALUES ('82', '82', '454', '46.5', '11', '511.5', '2016-12-27 16:36:44');
INSERT INTO `order_total` VALUES ('83', '83', '454', '46.5', '11', '511.5', '2016-12-28 05:37:15');
INSERT INTO `order_total` VALUES ('84', '84', '100', '0', '0', '100', '2016-12-28 10:15:02');
INSERT INTO `order_total` VALUES ('85', '85', '454', '46.5', '11', '511.5', '2017-01-01 01:16:31');
INSERT INTO `order_total` VALUES ('86', '86', '1690', '170.1', '11', '1871.1', '2017-01-02 15:31:23');
INSERT INTO `order_total` VALUES ('87', '87', '5', '0', '2', '7', '2017-02-12 03:44:54');
INSERT INTO `order_total` VALUES ('88', '88', '4', '1.5', '11', '16.5', '2017-01-04 03:12:41');
INSERT INTO `order_total` VALUES ('89', '89', '12', '0', '0', '12', '2017-02-05 21:08:49');
INSERT INTO `order_total` VALUES ('90', '90', '300', '0', '0', '300', '2017-03-03 08:09:03');
INSERT INTO `order_total` VALUES ('91', '91', '28', '3.9', '11', '42.9', '2017-03-03 08:09:03');
INSERT INTO `order_total` VALUES ('92', '92', '300', '0', '0', '300', '2017-03-03 08:09:20');
INSERT INTO `order_total` VALUES ('93', '93', '28', '3.9', '11', '42.9', '2017-03-03 08:09:20');
INSERT INTO `order_total` VALUES ('94', '94', '2', '0.7', '5', '7.7', '2017-03-31 18:51:18');
INSERT INTO `order_total` VALUES ('95', '95', '200', '20.5', '5', '225.5', '2017-04-03 17:47:58');
INSERT INTO `order_total` VALUES ('96', '96', '18', '2.3', '5', '25.3', '2017-04-07 16:07:07');
INSERT INTO `order_total` VALUES ('97', '97', '2', '0.7', '5', '7.7', '2017-04-07 16:07:41');
INSERT INTO `order_total` VALUES ('98', '98', '5', '0', '2', '7', '2017-07-22 07:31:44');
INSERT INTO `order_total` VALUES ('99', '99', '12', '0', '0', '12', '2017-07-01 17:17:47');
INSERT INTO `order_total` VALUES ('100', '100', '12', '0', '0', '12', '2017-07-08 02:41:25');
INSERT INTO `order_total` VALUES ('101', '101', '36', '4.1', '5', '45.1', '2017-07-22 13:23:25');
INSERT INTO `order_total` VALUES ('102', '102', '454', '46.5', '11', '511.5', '2017-07-22 13:22:16');
INSERT INTO `order_total` VALUES ('103', '103', '10', '0', '2', '12', '2017-07-22 13:21:37');
INSERT INTO `order_total` VALUES ('104', '104', '18', '2.3', '5', '25.3', '2017-07-25 15:01:26');
INSERT INTO `order_total` VALUES ('105', '105', '30', '4.1', '11', '45.1', '2017-07-25 15:02:34');
INSERT INTO `order_total` VALUES ('106', '106', '5', '0', '2', '7', '2017-07-25 15:02:34');
INSERT INTO `order_total` VALUES ('107', '107', '15', '2', '5', '22', '2017-07-28 00:31:44');
INSERT INTO `order_total` VALUES ('108', '108', '100', '0', '0', '100', '2017-07-31 01:14:18');
INSERT INTO `order_total` VALUES ('109', '109', '454', '46.5', '11', '511.5', '2017-07-31 01:14:18');
INSERT INTO `order_total` VALUES ('111', '111', '100', '0', '0', '100', '2017-07-31 02:26:24');
INSERT INTO `order_total` VALUES ('112', '112', '10', '0', '2', '12', '2017-08-01 13:43:42');
INSERT INTO `order_total` VALUES ('113', '113', '123', '0', '0', '123', '2017-08-01 13:47:28');
INSERT INTO `order_total` VALUES ('114', '114', '200', '20.5', '5', '225.5', '2017-08-01 13:47:45');
INSERT INTO `order_total` VALUES ('115', '115', '458', '46.9', '11', '515.9', '2017-08-03 17:40:10');
INSERT INTO `order_total` VALUES ('116', '116', '18', '2.3', '5', '25.3', '2017-08-07 16:30:53');
INSERT INTO `order_total` VALUES ('117', '117', '454', '46.5', '11', '511.5', '2017-08-07 16:30:53');
INSERT INTO `order_total` VALUES ('118', '118', '454', '46.5', '11', '511.5', '2017-08-11 14:52:50');
INSERT INTO `order_total` VALUES ('119', '119', '2', '0.7', '5', '7.7', '2017-08-11 14:53:53');
INSERT INTO `order_total` VALUES ('120', '120', '4', '1.5', '11', '16.5', '2017-08-11 15:20:37');
INSERT INTO `order_total` VALUES ('121', '121', '111', '11.6', '5', '127.6', '2017-08-11 15:48:05');
INSERT INTO `order_total` VALUES ('122', '122', '4', '1.5', '11', '16.5', '2017-08-11 15:50:15');
INSERT INTO `order_total` VALUES ('123', '123', '15', '0', '2', '17', '2017-08-11 20:26:44');
INSERT INTO `order_total` VALUES ('124', '124', '30', '3.5', '5', '38.5', '2017-08-11 20:26:44');
INSERT INTO `order_total` VALUES ('125', '125', '15', '2', '5', '22', '2017-08-12 14:20:50');
INSERT INTO `order_total` VALUES ('126', '126', '215', '22', '5', '242', '2017-08-22 22:03:41');
INSERT INTO `order_total` VALUES ('128', '128', '15', '2', '5', '22', '2017-09-06 13:28:17');
INSERT INTO `order_total` VALUES ('129', '129', '4', '1.5', '11', '16.5', '2017-09-06 14:26:09');
INSERT INTO `order_total` VALUES ('130', '130', '18', '2.3', '5', '25.3', '2017-09-12 23:19:43');
INSERT INTO `order_total` VALUES ('132', '132', '58', '6.9', '11', '75.9', '2017-09-13 02:49:35');
INSERT INTO `order_total` VALUES ('141', '141', '12', '0', '0', '12', '2017-09-16 19:00:17');
INSERT INTO `order_total` VALUES ('154', '154', '100', '0', '0', '100', '2017-09-13 03:27:05');
INSERT INTO `order_total` VALUES ('165', '165', '24', '0', '0', '24', '2017-09-18 18:37:20');
INSERT INTO `order_total` VALUES ('169', '169', '20', '0', '0', '20', '2017-10-02 09:17:09');
INSERT INTO `order_total` VALUES ('170', '170', '20', '0', '0', '20', '2017-10-09 20:02:47');
INSERT INTO `order_total` VALUES ('171', '171', '2', '0.98', '5', '7.98', '2017-11-13 19:17:05');
INSERT INTO `order_total` VALUES ('172', '172', '2', '0.98', '5', '7.98', '2017-11-13 21:37:12');
INSERT INTO `order_total` VALUES ('173', '173', '600', '0', '0', '600', '2017-11-21 00:11:41');
INSERT INTO `order_total` VALUES ('174', '174', '12', '0', '0', '12', '2017-11-21 01:42:11');
INSERT INTO `order_total` VALUES ('175', '175', '203.98', '29.2572', '5', '238.2372', '2017-12-12 01:25:14');
INSERT INTO `order_total` VALUES ('176', '176', '4', '0.25', '1', '5.25', '2017-12-12 01:27:17');
INSERT INTO `order_total` VALUES ('177', '177', '4', '1.5', '11', '16.5', '2017-12-12 10:35:14');
INSERT INTO `order_total` VALUES ('178', '178', '454', '46.5', '11', '511.5', '2017-12-19 15:08:57');
INSERT INTO `order_total` VALUES ('179', '179', '30', '4.1', '11', '45.1', '2017-12-19 18:35:35');
INSERT INTO `order_total` VALUES ('180', '180', '30', '4.1', '11', '45.1', '2017-12-19 18:32:30');
INSERT INTO `order_total` VALUES ('181', '181', '454', '46.5', '11', '511.5', '2017-12-28 06:10:40');
INSERT INTO `order_total` VALUES ('182', '182', '454', '46.5', '11', '511.5', '2018-01-11 03:34:55');
INSERT INTO `order_total` VALUES ('183', '183', '30', '4.1', '11', '45.1', '2018-01-11 03:34:55');
INSERT INTO `order_total` VALUES ('184', '184', '39.9', '0', '0', '39.9', '2018-01-12 22:05:20');
INSERT INTO `order_total` VALUES ('185', '185', '8', '1.9', '11', '20.9', '2018-02-19 14:59:10');
INSERT INTO `order_total` VALUES ('186', '186', '5', '0', '2', '7', '2018-03-06 15:54:17');
INSERT INTO `order_total` VALUES ('187', '187', '20', '0', '0', '20', '2018-03-08 00:59:46');
INSERT INTO `order_total` VALUES ('188', '188', '15', '0', '0', '15', '2018-03-16 08:17:15');
INSERT INTO `order_total` VALUES ('189', '189', '20', '0', '0', '20', '2018-03-24 01:41:39');
INSERT INTO `order_total` VALUES ('190', '190', '454', '46.5', '11', '511.5', '2018-03-24 14:06:05');
INSERT INTO `order_total` VALUES ('191', '191', '110', '0', '0', '110', '2018-04-08 02:31:29');
INSERT INTO `order_total` VALUES ('192', '192', '12', '0', '0', '12', '2018-04-08 02:31:29');
INSERT INTO `order_total` VALUES ('193', '193', '30', '4.1', '11', '45.1', '2018-04-08 02:31:29');
INSERT INTO `order_total` VALUES ('194', '194', '2', '0.98', '5', '7.98', '2018-05-22 22:08:32');
INSERT INTO `order_total` VALUES ('195', '195', '2148', '214.8', '0', '2362.8', '2018-06-07 06:15:57');
INSERT INTO `order_total` VALUES ('196', '196', '218', '31.22', '5', '254.22', '2018-06-08 03:41:14');
INSERT INTO `order_total` VALUES ('197', '197', '18716', '1871.6', '0', '20587.6', '2018-06-08 06:10:30');
INSERT INTO `order_total` VALUES ('198', '198', '75', '11.2', '5', '91.2', '2018-08-21 15:59:56');
INSERT INTO `order_total` VALUES ('199', '199', '454', '46.5', '11', '511.5', '2018-08-21 15:59:56');
INSERT INTO `order_total` VALUES ('200', '200', '123', '0', '0', '123', '2018-08-21 15:59:56');
INSERT INTO `order_total` VALUES ('201', '201', '4', '1.5', '11', '16.5', '2018-08-22 15:04:26');
INSERT INTO `order_total` VALUES ('202', '202', '123', '0', '0', '123', '2018-08-27 09:50:37');
INSERT INTO `order_total` VALUES ('203', '203', '2148', '214.8', '0', '2362.8', '2018-08-27 09:53:59');
INSERT INTO `order_total` VALUES ('204', '204', '4', '0.25', '1', '5.25', '2018-08-27 09:53:59');
INSERT INTO `order_total` VALUES ('205', '205', '127', '0', '0', '127', '2018-08-29 11:58:20');
INSERT INTO `order_total` VALUES ('206', '206', '127', '0', '0', '127', '2018-08-29 12:00:52');
INSERT INTO `order_total` VALUES ('207', '207', '458', '46.9', '11', '515.9', '2018-09-07 10:03:45');
INSERT INTO `order_total` VALUES ('208', '208', '18', '3.22', '5', '26.22', '2018-09-07 10:03:45');
INSERT INTO `order_total` VALUES ('209', '209', '123', '0', '0', '123', '2018-09-18 05:20:56');
INSERT INTO `order_total` VALUES ('210', '210', '20', '0', '0', '20', '2018-09-18 19:22:41');
INSERT INTO `order_total` VALUES ('211', '211', '20', '0', '0', '20', '2018-09-19 03:22:18');
INSERT INTO `order_total` VALUES ('212', '212', '20', '0', '0', '20', '2018-09-19 03:23:18');
INSERT INTO `order_total` VALUES ('213', '213', '20', '0', '0', '20', '2018-09-19 03:24:43');
INSERT INTO `order_total` VALUES ('214', '214', '4', '1.5', '11', '16.5', '2018-10-03 10:59:09');
INSERT INTO `order_total` VALUES ('215', '215', '4', '1.5', '11', '16.5', '2018-10-03 10:59:47');
INSERT INTO `order_total` VALUES ('216', '216', '4', '1.5', '11', '16.5', '2018-10-03 11:09:31');

-- ----------------------------
-- Table structure for `payout`
-- ----------------------------
CREATE TABLE `payout` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(30) NOT NULL,
  `status` int(1) NOT NULL,
  `date` varchar(100) NOT NULL,
  `amount` double NOT NULL,
  `payment_method` varchar(100) NOT NULL,
  `email_paypal` varchar(100) NOT NULL,
  `bank_name` varchar(500) NOT NULL,
  `account_number` varchar(100) NOT NULL,
  `bank_address` varchar(200) NOT NULL,
  `bank_SWIFT_code` varchar(200) NOT NULL,
  `bank_phone` varchar(200) NOT NULL,
  `bank_email` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of payout
-- ----------------------------
INSERT INTO `payout` VALUES ('3', '1432968683', '1', '2016-12-13', '434.5', '2', 'hicomtim@gmail.com', '0', '0', '0', '0', '0', '0');
INSERT INTO `payout` VALUES ('4', '1432968683', '1', '2018-08-10', '164.34', '4', '0', 'Xbank', '78216387216', 'abc', '65134', '37412468', 'xbank@bank.com');

-- ----------------------------
-- Table structure for `promotion`
-- ----------------------------
CREATE TABLE `promotion` (
  `promotion_id` int(10) NOT NULL AUTO_INCREMENT,
  `promotion_code` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `promotion_name` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `promotion_desc` text COLLATE utf8_unicode_ci NOT NULL,
  `promotion_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `percent_discount` float NOT NULL DEFAULT '0',
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `lang` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`promotion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of promotion
-- ----------------------------
INSERT INTO `promotion` VALUES ('1', 'ABCD999', 'Open', '38', 'Open promotion', '1426304455.jpg', '20', '2015-06-02', '2015-09-30', '02:45:00', '1', null);
INSERT INTO `promotion` VALUES ('2', 'ABCD9997654', 'Open', '39', '1234', '1423295410.jpg', '10', '2015-02-07', '2015-02-28', '03:00:00', '1', null);
INSERT INTO `promotion` VALUES ('3', 'asd', 'asdasd', '38', 'adas', '1466846347.jpg', '0', '2016-06-30', '2016-06-30', '04:30:00', '0', null);

-- ----------------------------
-- Table structure for `request`
-- ----------------------------
CREATE TABLE `request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of request
-- ----------------------------
INSERT INTO `request` VALUES ('9', '1443769547', '2015-11-28 17:58:45');
INSERT INTO `request` VALUES ('10', '1449629783', '2015-12-09 10:33:39');
INSERT INTO `request` VALUES ('13', '1450085999', '2015-12-14 16:48:26');
INSERT INTO `request` VALUES ('14', '1450260376', '2015-12-16 17:08:05');
INSERT INTO `request` VALUES ('15', '1450338899', '2015-12-17 14:55:17');
INSERT INTO `request` VALUES ('17', '1450162397', '2015-12-21 17:55:04');
INSERT INTO `request` VALUES ('19', '1466830013', '2016-06-25 15:30:42');
INSERT INTO `request` VALUES ('20', '1463383743', '2016-06-25 16:23:34');
INSERT INTO `request` VALUES ('22', '1474442380', '2016-09-21 14:20:18');
INSERT INTO `request` VALUES ('24', '1474527670', '2016-09-22 14:03:48');
INSERT INTO `request` VALUES ('25', '1476688042', '2016-10-17 14:07:46');
INSERT INTO `request` VALUES ('26', '1477303126', '2016-10-24 16:59:31');
INSERT INTO `request` VALUES ('27', '1479830278', '2016-11-22 22:58:27');
INSERT INTO `request` VALUES ('29', '1480278690', '2016-11-28 03:32:01');
INSERT INTO `request` VALUES ('30', '1480360793', '2016-11-29 02:20:28');
INSERT INTO `request` VALUES ('31', '1480404704', '2016-11-29 14:32:26');
INSERT INTO `request` VALUES ('32', '1481136186', '2016-12-08 01:43:27');
INSERT INTO `request` VALUES ('40', '1481906092', '2016-12-16 23:36:45');
INSERT INTO `request` VALUES ('41', '1483208107', '2017-01-01 01:15:53');
INSERT INTO `request` VALUES ('42', '1482128178', '2017-01-21 04:50:59');
INSERT INTO `request` VALUES ('43', '1486303307', '2017-02-05 21:02:30');
INSERT INTO `request` VALUES ('44', '1488503149', '2017-03-03 08:11:18');
INSERT INTO `request` VALUES ('45', '1490444218', '2017-03-25 19:17:28');
INSERT INTO `request` VALUES ('46', '1490960661', '2017-03-31 18:45:08');
INSERT INTO `request` VALUES ('47', '1491216437', '2017-04-03 17:47:36');
INSERT INTO `request` VALUES ('48', '1493205429', '2017-04-26 18:18:38');
INSERT INTO `request` VALUES ('49', '1497530334', '2017-06-15 19:40:21');
INSERT INTO `request` VALUES ('51', '1500967644', '2017-07-25 23:54:12');
INSERT INTO `request` VALUES ('52', '1501068891', '2017-07-28 00:26:14');
INSERT INTO `request` VALUES ('64', '1509117842', '2017-10-27 22:24:32');
INSERT INTO `request` VALUES ('65', '1510575391', '2017-11-13 19:18:20');
INSERT INTO `request` VALUES ('66', '1510576455', '2017-11-13 19:34:29');
INSERT INTO `request` VALUES ('68', '1511877396', '2017-11-28 20:57:20');
INSERT INTO `request` VALUES ('69', '1513013155', '2017-12-12 00:26:20');
INSERT INTO `request` VALUES ('70', '1513049579', '2017-12-12 10:33:24');
INSERT INTO `request` VALUES ('73', '1513682441', '2017-12-19 18:35:31');
INSERT INTO `request` VALUES ('76', '1519025693', '2018-02-19 14:35:20');
INSERT INTO `request` VALUES ('77', '1520033899', '2018-03-03 06:39:08');
INSERT INTO `request` VALUES ('78', '1521162344', '2018-03-16 08:06:20');
INSERT INTO `request` VALUES ('79', '1522170846', '2018-03-28 00:15:02');
INSERT INTO `request` VALUES ('80', '1526078110', '2018-05-12 05:37:14');
INSERT INTO `request` VALUES ('81', '1526578555', '2018-05-18 01:35:29');
INSERT INTO `request` VALUES ('82', '1528326652', '2018-06-07 06:11:25');
INSERT INTO `request` VALUES ('84', '1533635265', '2018-08-07 16:59:43');
INSERT INTO `request` VALUES ('85', '1534826995', '2018-08-21 11:51:53');
INSERT INTO `request` VALUES ('86', '1537468771', '2018-09-21 01:40:53');

-- ----------------------------
-- Table structure for `settings`
-- ----------------------------
CREATE TABLE `settings` (
  `setting_id` int(10) unsigned NOT NULL,
  `setting_key` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `setting_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `setting_data` text COLLATE utf8_unicode_ci,
  `setting_bankinfo` text COLLATE utf8_unicode_ci,
  `setting_currency` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location_latitude` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `location_longitude` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of settings
-- ----------------------------
INSERT INTO `settings` VALUES ('1382069043', 'SYSTEM_EMAIL', '1382069043', '{\"host\":\"smtp.gmail.com\",\"username\":\"fruity.tester@gmail.com\",\"password\":\"trollerlvlmax\",\"port\":\"465\",\"encryption\":\"tls\"}', '<p>Bank <gs class=\"GINGER_SOFTWARE_mark\" ginger_software_uiphraseguid=\"c6af0109-4a23-4ca6-8d14-a501f4a41c09\" id=\"90676e48-c400-41ce-b166-142e3f0db015\">Infomation</gs> Restaurant</p>\r\n', '$', '-37.8224212', '144.9507993');
INSERT INTO `settings` VALUES ('1382069049', 'SYSTEM_COMMISSION', '1382069049', '{\"commission rate\":\"10\",\"day payout in month\":\"10\"}', '<p>NULL</p>\r\n', 'NULL', 'NULL', 'NULL');

-- ----------------------------
-- Table structure for `transaction`
-- ----------------------------
CREATE TABLE `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `account_id` varchar(30) NOT NULL,
  `earn` double NOT NULL,
  `commission` double NOT NULL,
  `payment_method` int(1) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of transaction
-- ----------------------------
INSERT INTO `transaction` VALUES ('1', '15', '40', '1432968683', '200.7', '22.3', '2', '2016-08-22 11:34:12');
INSERT INTO `transaction` VALUES ('2', '16', '41', '1432968683', '233.8', '1.2', '2', '2016-08-22 11:34:12');
INSERT INTO `transaction` VALUES ('3', '17', '38', '1397811112', '108.9', '12.1', '3', '2016-09-19 14:12:39');
INSERT INTO `transaction` VALUES ('4', '73', '43', '1432968683', '19.8', '2.2', '2', '2016-12-16 23:36:14');
INSERT INTO `transaction` VALUES ('5', '74', '38', '1397811112', '482.35', '51.15', '2', '2016-12-16 23:36:14');
INSERT INTO `transaction` VALUES ('6', '75', '39', '1397811111', '627.55', '10.45', '2', '2016-12-16 23:36:14');
INSERT INTO `transaction` VALUES ('7', '96', '43', '1432968683', '22.77', '2.53', '2', '2017-04-07 16:07:07');
INSERT INTO `transaction` VALUES ('8', '100', '52', '1486302177', '10.8', '1.2', '3', '2017-07-08 02:41:25');
INSERT INTO `transaction` VALUES ('9', '119', '43', '1432968683', '6.93', '0.77', '2', '2017-08-11 14:53:53');
INSERT INTO `transaction` VALUES ('10', '120', '38', '1397811112', '14.85', '1.65', '2', '2017-08-11 15:20:37');
INSERT INTO `transaction` VALUES ('11', '121', '43', '1432968683', '114.84', '12.76', '2', '2017-08-11 15:48:05');
INSERT INTO `transaction` VALUES ('12', '122', '38', '1397811112', '14.85', '1.65', '2', '2017-08-11 15:50:16');

-- ----------------------------
-- Table structure for `user_shop`
-- ----------------------------
CREATE TABLE `user_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopId` int(11) NOT NULL,
  `accountId` varchar(30) NOT NULL,
  `order_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of user_shop
-- ----------------------------
INSERT INTO `user_shop` VALUES ('1', '40', '1397811111', '2');
INSERT INTO `user_shop` VALUES ('2', '38', '1397811111', '1');
INSERT INTO `user_shop` VALUES ('3', '41', '1397811111', '1');
INSERT INTO `user_shop` VALUES ('4', '42', '1397811111', '1');
INSERT INTO `user_shop` VALUES ('5', '41', '1466830013', '6');
INSERT INTO `user_shop` VALUES ('6', '40', '1466830013', '2');
INSERT INTO `user_shop` VALUES ('7', '38', '1466830013', '4');
INSERT INTO `user_shop` VALUES ('8', '38', '1474269015', '1');
INSERT INTO `user_shop` VALUES ('9', '43', '1474442344', '9');
INSERT INTO `user_shop` VALUES ('10', '40', '1474442344', '2');
INSERT INTO `user_shop` VALUES ('11', '42', '1474442344', '2');
INSERT INTO `user_shop` VALUES ('12', '45', '1474442344', '5');
INSERT INTO `user_shop` VALUES ('13', '39', '1474442344', '1');
INSERT INTO `user_shop` VALUES ('14', '43', '1474527670', '3');
INSERT INTO `user_shop` VALUES ('15', '41', '1474527670', '1');
INSERT INTO `user_shop` VALUES ('16', '38', '1476566908', '1');
INSERT INTO `user_shop` VALUES ('17', '38', '1476688042', '1');
INSERT INTO `user_shop` VALUES ('18', '38', '1477303126', '1');
INSERT INTO `user_shop` VALUES ('19', '38', '1478510812', '2');
INSERT INTO `user_shop` VALUES ('20', '41', '1478572970', '1');
INSERT INTO `user_shop` VALUES ('21', '40', '1478572970', '1');
INSERT INTO `user_shop` VALUES ('22', '43', '1441015549', '2');
INSERT INTO `user_shop` VALUES ('23', '47', '1479830278', '3');
INSERT INTO `user_shop` VALUES ('24', '48', '1480169682', '1');
INSERT INTO `user_shop` VALUES ('25', '43', '1480278690', '2');
INSERT INTO `user_shop` VALUES ('26', '39', '1480360793', '6');
INSERT INTO `user_shop` VALUES ('27', '38', '1480857612', '1');
INSERT INTO `user_shop` VALUES ('28', '43', '1481312665', '2');
INSERT INTO `user_shop` VALUES ('29', '45', '0', '2');
INSERT INTO `user_shop` VALUES ('30', '47', '1450162397', '2');
INSERT INTO `user_shop` VALUES ('31', '39', '1450162397', '1');
INSERT INTO `user_shop` VALUES ('32', '38', '1450162397', '1');
INSERT INTO `user_shop` VALUES ('33', '43', '1481906092', '1');
INSERT INTO `user_shop` VALUES ('34', '38', '1481906092', '1');
INSERT INTO `user_shop` VALUES ('35', '39', '1481906092', '1');
INSERT INTO `user_shop` VALUES ('36', '38', '1482128178', '4');
INSERT INTO `user_shop` VALUES ('37', '49', '1482128178', '1');
INSERT INTO `user_shop` VALUES ('38', '41', '1432968757', '1');
INSERT INTO `user_shop` VALUES ('39', '43', '1432968757', '1');
INSERT INTO `user_shop` VALUES ('40', '38', '1432968757', '1');
INSERT INTO `user_shop` VALUES ('41', '47', '1432968757', '1');
INSERT INTO `user_shop` VALUES ('42', '38', '1483208107', '1');
INSERT INTO `user_shop` VALUES ('43', '38', '1483345848', '1');
INSERT INTO `user_shop` VALUES ('44', '41', '1483345848', '1');
INSERT INTO `user_shop` VALUES ('45', '52', '1486303307', '1');
INSERT INTO `user_shop` VALUES ('46', '47', '1488503149', '2');
INSERT INTO `user_shop` VALUES ('47', '39', '1488503149', '2');
INSERT INTO `user_shop` VALUES ('48', '43', '1490960661', '1');
INSERT INTO `user_shop` VALUES ('49', '43', '1491216437', '1');
INSERT INTO `user_shop` VALUES ('50', '43', '1491555972', '2');
INSERT INTO `user_shop` VALUES ('51', '41', '1493205429', '1');
INSERT INTO `user_shop` VALUES ('52', '52', '1498903936', '1');
INSERT INTO `user_shop` VALUES ('53', '52', '1499456390', '1');
INSERT INTO `user_shop` VALUES ('54', '43', '1500704169', '1');
INSERT INTO `user_shop` VALUES ('55', '38', '1500704169', '1');
INSERT INTO `user_shop` VALUES ('56', '41', '1500704169', '1');
INSERT INTO `user_shop` VALUES ('57', '43', '1500967644', '1');
INSERT INTO `user_shop` VALUES ('58', '39', '1500967644', '1');
INSERT INTO `user_shop` VALUES ('59', '41', '1500967644', '1');
INSERT INTO `user_shop` VALUES ('60', '43', '1501068891', '2');
INSERT INTO `user_shop` VALUES ('61', '47', '1501068891', '2');
INSERT INTO `user_shop` VALUES ('62', '38', '1501068891', '1');
INSERT INTO `user_shop` VALUES ('63', '52', '1501068891', '1');
INSERT INTO `user_shop` VALUES ('64', '41', '1501569492', '1');
INSERT INTO `user_shop` VALUES ('65', '46', '1501569492', '2');
INSERT INTO `user_shop` VALUES ('66', '43', '1501569492', '1');
INSERT INTO `user_shop` VALUES ('67', '38', '1501755287', '1');
INSERT INTO `user_shop` VALUES ('68', '43', '1502098216', '1');
INSERT INTO `user_shop` VALUES ('69', '38', '1502098216', '1');
INSERT INTO `user_shop` VALUES ('70', '38', '1450176364', '3');
INSERT INTO `user_shop` VALUES ('71', '43', '1450176364', '2');
INSERT INTO `user_shop` VALUES ('72', '41', '1502457075', '1');
INSERT INTO `user_shop` VALUES ('73', '43', '1502457075', '1');
INSERT INTO `user_shop` VALUES ('74', '43', '1503037195', '1');
INSERT INTO `user_shop` VALUES ('75', '38', '1503413491', '1');
INSERT INTO `user_shop` VALUES ('76', '43', '1504679211', '1');
INSERT INTO `user_shop` VALUES ('77', '38', '1504682741', '1');
INSERT INTO `user_shop` VALUES ('78', '43', '1505233029', '1');
INSERT INTO `user_shop` VALUES ('79', '39', '1505233029', '16');
INSERT INTO `user_shop` VALUES ('80', '47', '1505233029', '11');
INSERT INTO `user_shop` VALUES ('81', '52', '1505233029', '10');
INSERT INTO `user_shop` VALUES ('82', '38', '1505233029', '1');
INSERT INTO `user_shop` VALUES ('83', '60', '1506910604', '1');
INSERT INTO `user_shop` VALUES ('84', '60', '1499456390', '2');
INSERT INTO `user_shop` VALUES ('85', '43', '1510575391', '1');
INSERT INTO `user_shop` VALUES ('86', '43', '1510576455', '1');
INSERT INTO `user_shop` VALUES ('87', '48', '1510767914', '1');
INSERT INTO `user_shop` VALUES ('88', '52', '1511203270', '1');
INSERT INTO `user_shop` VALUES ('89', '43', '1513013155', '1');
INSERT INTO `user_shop` VALUES ('90', '45', '1513013155', '1');
INSERT INTO `user_shop` VALUES ('91', '38', '1513049579', '2');
INSERT INTO `user_shop` VALUES ('92', '39', '1513682441', '2');
INSERT INTO `user_shop` VALUES ('93', '38', '1514403224', '1');
INSERT INTO `user_shop` VALUES ('94', '38', '1515616435', '1');
INSERT INTO `user_shop` VALUES ('95', '39', '1515616435', '1');
INSERT INTO `user_shop` VALUES ('96', '61', '1515616435', '1');
INSERT INTO `user_shop` VALUES ('97', '38', '1519025693', '1');
INSERT INTO `user_shop` VALUES ('98', '41', '1520326435', '1');
INSERT INTO `user_shop` VALUES ('99', '62', '1521162344', '1');
INSERT INTO `user_shop` VALUES ('100', '60', '1521162344', '1');
INSERT INTO `user_shop` VALUES ('101', '38', '1432968683', '1');
INSERT INTO `user_shop` VALUES ('102', '47', '1523129245', '1');
INSERT INTO `user_shop` VALUES ('103', '52', '1523129245', '1');
INSERT INTO `user_shop` VALUES ('104', '39', '1523129245', '1');
INSERT INTO `user_shop` VALUES ('105', '43', '1526078110', '1');
INSERT INTO `user_shop` VALUES ('106', '38', '1528326652', '2');
INSERT INTO `user_shop` VALUES ('107', '43', '1528326652', '1');
INSERT INTO `user_shop` VALUES ('108', '43', '1534839769', '1');
INSERT INTO `user_shop` VALUES ('109', '38', '1534839769', '2');
INSERT INTO `user_shop` VALUES ('110', '46', '1534839769', '3');
INSERT INTO `user_shop` VALUES ('111', '38', '1480169682', '1');
INSERT INTO `user_shop` VALUES ('112', '43', '1480169682', '1');
INSERT INTO `user_shop` VALUES ('113', '46', '1537222690', '1');
INSERT INTO `user_shop` VALUES ('114', '68', '1537273068', '1');
INSERT INTO `user_shop` VALUES ('115', '68', '1537222690', '3');
INSERT INTO `user_shop` VALUES ('116', '38', '1538539109', '3');
