-- http://www.phpmyadmin.net
--




-- --------------------------------------------------------

--
-- Table structure for table `analytic`
--

CREATE TABLE IF NOT EXISTS `analytic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(1) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `date` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;

--
-- Dumping data for table `analytic`
--

INSERT INTO `analytic` (`id`, `type`, `shop_id`, `count`, `date`) VALUES
(1, 1, 7, 2, '2016-08-27'),
(2, 1, 1, 1, '2016-08-27'),
(3, 1, 12, 8, '2016-09-17'),
(4, 1, 5, 12, '2016-09-17'),
(5, 1, 13, 1, '2016-09-17'),
(6, 1, 5, 10, '2016-10-01'),
(7, 1, 12, 5, '2016-10-01'),
(8, 1, 1, 1, '2016-10-05'),
(9, 1, 7, 1, '2016-10-05'),
(10, 1, 6, 1, '2016-10-05'),
(11, 1, 5, 1, '2016-10-06'),
(12, 1, 7, 1, '2016-10-11'),
(13, 1, 1, 1, '2016-10-11'),
(14, 1, 13, 2, '2016-10-12'),
(15, 1, 6, 1, '2016-10-15'),
(16, 1, 7, 2, '2016-10-29'),
(17, 1, 8, 1, '2016-10-29'),
(18, 1, 12, 1, '2016-10-29'),
(19, 1, 3, 1, '2016-10-29'),
(20, 1, 1, 1, '2016-10-29'),
(21, 1, 1, 3, '2016-11-12'),
(22, 1, 6, 1, '2016-11-12'),
(23, 1, 7, 1, '2016-11-26'),
(24, 1, 3, 1, '2016-11-26'),
(25, 1, 15, 1, '2016-11-26'),
(26, 1, 14, 1, '2016-11-26'),
(27, 1, 5, 1, '2016-11-26'),
(28, 1, 1, 1, '2016-12-01'),
(29, 1, 3, 1, '2016-12-06'),
(30, 1, 13, 1, '2016-12-12'),
(31, 1, 21, 2, '2017-01-18'),
(32, 1, 22, 1, '2017-01-18'),
(33, 1, 1, 1, '2017-05-17'),
(34, 1, 24, 1, '2017-05-25'),
(35, 1, 1, 2, '2017-05-25'),
(36, 1, 5, 1, '2017-05-25'),
(37, 1, 35, 2, '2017-05-26'),
(38, 1, 24, 1, '2017-06-15'),
(39, 1, 21, 1, '2017-08-01'),
(40, 1, 3, 1, '2017-08-05'),
(41, 1, 13, 1, '2017-08-05');

-- --------------------------------------------------------

--
-- Table structure for table `banner`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`bannerId`, `bannerName`, `bannerImage`, `shopId`, `status`) VALUES
(1, '1', '1453536067.jpg', 38, 1),
(2, '23', '1453536081.jpg', 38, 1),
(3, 'TestBanner', '1453536424.jpg', 41, 1),
(4, 'Banner2', '1453536392.jpg', 41, 1),
(5, 'Banner1', '1453535823.JPG', 40, 1),
(6, 'Banner2', '1453536085.png', 40, 1),
(7, 'Banner3', '1453535922.JPG', 40, 1),
(8, 'BannerElectronic1', '1453535607.jpeg', 42, 1),
(9, 'bannberelect2', '1453535701.jpg', 42, 1),
(10, 'First', '1480989754.jpg', 39, 1),
(11, 'birthday banner', '1481623882.jpg', 51, 1),
(12, 'Banner', '1487847942.jpg', 54, 1),
(13, 'Banner', '1487848046.jpg', 53, 1),
(14, 'banner1', '1487848061.jpg', 53, 1),
(15, 'Banner', '1487848079.jpg', 52, 1),
(16, 'B1', '1493269320.png', 55, 1),
(17, 'B2', '1493269366.jpg', 55, 1);

-- --------------------------------------------------------

--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `cityId` int(11) NOT NULL AUTO_INCREMENT,
  `cityPostCode` varchar(20) NOT NULL,
  `cityName` varchar(100) NOT NULL,
  PRIMARY KEY (`cityId`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`cityId`, `cityPostCode`, `cityName`) VALUES
(1, '560', 'Bangalore'),
(16, 'AZ1', 'Poplar'),
(17, '230', 'Port Louis'),
(24, 'C51', 'Ramat Gan'),
(25, '122018', 'Gurgaon'),
(26, '3130', 'Melbourne'),
(27, '572105', 'Karnataka'),
(28, '509', 'Port-au-Prince');

-- --------------------------------------------------------

--
-- Table structure for table `comment`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`id`, `location_id`, `food_id`, `account_id`, `title`, `content`, `rate`, `created`) VALUES
(1, 38, -1, 'Logan', '', 'Good shop\n', 10.00, '2017-05-17 15:22:08'),
(2, 51, 24, 'tester', 'dummy', 'ab', 10.00, '2017-05-25 11:09:02'),
(3, 38, 3, 'tester', 'dummy', 'safi', 10.00, '2017-05-25 18:57:21'),
(4, 38, 3, 'tester', 'dummy', 'safi', 10.00, '2017-05-25 18:57:23'),
(5, 57, 35, 'tester', 'dummy', 'safi', 8.00, '2017-05-26 12:43:46'),
(6, 0, -1, 'tester', 'dummy', 'safisana', 10.00, '2017-05-26 13:16:51'),
(7, 0, -1, 'tester', 'dummy', 'safisana', 10.00, '2017-05-26 13:16:54'),
(8, 0, -1, 'tester', 'dummy', 'safisana', 10.00, '2017-05-26 13:16:58'),
(9, 0, -1, 'tester', 'dummy', 'kazi nzuri', 10.00, '2017-05-26 13:17:17'),
(10, 0, -1, 'tester', 'dummy', 'kazi nzuri', 10.00, '2017-05-26 13:17:20'),
(11, 57, 35, 'tester', 'dummy', 'kazi njema', 10.00, '2017-05-26 13:18:04'),
(12, 57, 35, 'tester', 'dummy', 'kazi njema', 10.00, '2017-05-26 13:18:06'),
(13, 57, 35, 'tester', 'dummy', 'great', 4.00, '2017-05-26 13:49:12'),
(14, 38, -1, 'Jose Luis Escamilla Cuevas', '', 'Ok \n', 4.00, '2017-08-04 22:38:10');

-- --------------------------------------------------------

--
-- Table structure for table `datetb`
--

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

--
-- Dumping data for table `datetb`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `feedback`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` (`id`, `account_id`, `tittle`, `description`, `created`, `status`, `type`, `note`) VALUES
(1, 1432968757, 'Please approve my request', 'Please approve my request, it is shop owner.', '2016-12-13 09:18:45', 2, 1, ''),
(2, 1484715193, 'title', 'ga', '2017-01-18 14:35:18', 0, 3, ''),
(3, 1484715193, '213', '123', '2017-01-18 14:35:26', 0, 1, ''),
(4, 1432968757, 'my feedback', 'good app', '2017-02-25 15:53:50', 0, 1, ''),
(5, 1495526744, 'ReporShop', 'Jfjjdjkdkd', '2017-05-24 09:25:34', 0, 2, ''),
(6, 1495526744, 'ReporShop', 'Jfjjdjkdkd', '2017-05-24 09:25:47', 0, 2, ''),
(7, 1495526744, 'Report20%Shop', 'Jfjjdjkdkd', '2017-05-24 09:29:10', 0, 2, ''),
(8, 1495008909, 'Hicom', 'Test', '2017-06-29 10:34:08', 0, 1, ''),
(9, 1495008909, 'Hicom', 'HICOM', '2017-06-29 10:39:47', 0, 1, ''),
(10, 1495008909, 'Hicom', 'HICOM', '2017-06-29 10:43:01', 0, 1, ''),
(11, 1495008909, 'Hicom', 'HICOM', '2017-06-29 10:43:40', 0, 1, ''),
(14, 1495526744, 'Hicom	', 'Report test by logan', '2017-07-18 14:35:43', 0, 3, ''),
(15, 1500518661, 'Hợt', 'Bắc', '2017-07-20 09:48:46', 0, 1, ''),
(16, 1495526744, 'ReporShop', 'Jfjjdjkdkd', '2017-08-07 13:53:50', 0, 2, '');

-- --------------------------------------------------------

--
-- Table structure for table `finance`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `finance`
--

INSERT INTO `finance` (`id`, `shopId`, `budget`, `updateTime`, `status`) VALUES
(1, '41', 5, '2015-12-14 13:34:39', 1),
(2, '40', 1723, '2016-12-13 14:43:00', 1),
(3, '38', 99, '2016-12-13 17:17:48', 1),
(4, '57', 14724, '2017-05-26 13:46:21', 1);

-- --------------------------------------------------------

--
-- Table structure for table `financehistory`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `financeowner`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `financeowner`
--

INSERT INTO `financeowner` (`id`, `ownerId`, `budget`, `updateTime`, `status`) VALUES
(1, '1397811111', 1827.00, '2016-12-13 17:17:48', 1),
(2, '1495775393', 14724.00, '2017-05-26 13:46:21', 1);

-- --------------------------------------------------------

--
-- Table structure for table `food`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=37 ;

--
-- Dumping data for table `food`
--

INSERT INTO `food` (`food_id`, `food_code`, `food_name`, `shop_id`, `food_price`, `food_thumbnail`, `food_small_thumbnail`, `food_menus`, `food_desc`, `status_in_day`, `food_event_cost`, `food_event_start_time`, `food_event_end_time`, `food_event_thumbnail`, `status`, `lang`, `available`, `rate`, `rate_times`) VALUES
(1, 'A9999', 'Casio MM570', 38, 99, '1453533841.jpg', NULL, 24, 'Casio MM570 description.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(3, 'TB22K', 'Casio SW300', 38, 22, '1453533600.jpg', NULL, 24, 'Caiso SW300 is the best.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 10.00, 2),
(5, 'MK9', 'Led light', 40, 123, '1453535753.jpg', NULL, 33, 'Led light very good.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(6, '1', 'Red shoes', 41, 10, '1453533220.jpeg', NULL, 14, 'Red shoes description.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(7, '2', 'Jordan shoes', 54, 5, '1453533106.jpeg', NULL, 14, 'Jordan shoes description.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(8, '1', 'Light button Light button Light button', 42, 11, '1472285476.png', NULL, 10, 'Light button description', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(12, 'T1', 'Sub key', 40, 100, '1453532902.jpg', NULL, 28, 'Sub key description', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(13, 'CC1', 'Lazang BMW', 40, 300, '1453535819.jpg', NULL, 28, 'Lazang BMW is the best.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(14, '1233', 'Adidas Superstar White & Black', 41, 200, '1477712826.jpg', NULL, 14, 'Bring a classic and iconic look to any casual outfit with the rebirth of the adidas Superstar shoes. ', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(15, '1123', 'Pizza Express', 39, 30, '1480132820.png', NULL, 32, 'Classic marinara sauce, authentic old-world pepperoni, seasoned pork, beef, fresh mushrooms, fresh green bell peppers and fresh red onions.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(16, '01', 'Mon 1', 48, 1000, '1481340901.jpg', NULL, 13, 'đèafaaaaa', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(17, '9', 'wrewrw', 48, 65757, '1481340926.JPG', NULL, 25, 'werwrw', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(18, 'dsfs', '456464', 48, 99, '1481340967.jpg', NULL, 13, 'sf', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(19, 'S002', 'Women''s Ally 6" WP CT', 38, 145, '1481362346.jpg', NULL, 14, 'A compact construction features plenty of EVA padding and impact cushion, while the CAT Footwear Ally 6” WP CT work boot’s Composite Safety toe delivers performance protection.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(20, 'S003', 'Women''s Kineta Relay', 38, 79, '1481362469.jpg', NULL, 14, 'Equally suited to ambitious training or the daily grind, the lightweight Saucony Kineta Relay running shoe offers impact absorption from a durable EVA outsole, while the FORM2U footbed provides foot-conforming support.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(21, 'c100', 'CUSTOM TAIL LIGHTS', 40, 300, '1481365442.jpg', NULL, 33, 'At one time tail lights were round, plain, utilitarian components, mounted to the back of cars and trucks merely so they could be seen in the darkness. Then long about the late 1940s and early 1950s automakers began integrating tail lights into the shape of the body and since that time tail light styling has been an important part of vehicle design. Many tail light shapes are so iconic that a photo of the lights alone are all that is necessary to identify the year, make and model of the vehicle.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(22, 'HPBOX-1212', 'The Pizza Grille', 50, 20, '1481622341.jpg', NULL, 13, 'Deep and Graceful Birthday Poems to Send to Grandfather on His Birthday 3', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(23, 'GS001', 'Beary Happy Birthday Box', 51, 20, '1481623736.jpg', NULL, 26, 'Beary Happy Birthday Box 19', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(24, 'GS002', 'Happy Birthday Gift', 51, 30, '1481623785.png', NULL, 26, 'Happy Birthday Gift', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 10.00, 1),
(25, 'Cauliflower', 'Cauliflower', 52, 50, '1487840556.jpg', NULL, 36, 'Cauliflower is one of several vegetables in the species Brassica oleracea in the genus Brassica, which is in the family Brassicaceae. It is an annual plant that reproduces by seed. Typically, only the head (the white curd) is eaten. The cauliflower head is composed of a white inflorescence meristem. Cauliflower heads resemble those in broccoli, which differs in having flower buds.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(26, 'Coriander Leaf ', 'Coriander Leaf ', 52, 10, '1487840705.jpg', NULL, 37, 'The coriander plant produces both a spice and an herb. The leaf is know as cilantro and when the plant goes to seed, we harvest the coriander seed. Coriander is a pleasantly sweet spice with a lemony top note. It is commonly used in chili and curry dishes.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(27, 'Peach ', 'Peach ', 52, 50, '1487840858.png', NULL, 38, 'The peach (Prunus persica) is a deciduous tree native to the region of Northwest China between the Tarim Basin and the north slopes of the Kunlun Shan mountains, where it was first domesticated and cultivated. It bears an edible juicy fruit called a peach or a nectarine.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(28, 'Grapes', 'Grapes', 54, 75, '1487841014.jpg', NULL, 38, 'Grapes are classified as a fruit and come in a large variety of colors and types. Some are principally used for making wine, while others are enjoyed as juice or eaten alone as a snack or appetizer, often with cheese. Grapes can also be used as ingredients in other dishes such as the chicken salad recipe attached. Nutritionally, grapes provide multiple benefits.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(29, 'Celeriac', 'Celeriac', 54, 15, '1487841141.jpg', NULL, 36, 'Celeriac (Apium graveolens var. rapaceum), also called turnip-rooted celery or knob celery, is a variety of celery cultivated for its edible roots, hypocotyl, and shoots. It is sometimes called celery root. It was mentioned in Homer''s Odyssey as selinon. Celeriac is a root vegetable with a bulbous hypocotyl.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(30, 'Thyme ', 'Thyme ', 54, 140, '1487841253.jpg', NULL, 37, 'Thyme is an evergreen herb with culinary, medicinal, and ornamental uses. The most common ... It is composed of a woody stem with paired leaf or flower clusters ("leaves") spaced 1⁄2 to 1" apart.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(31, 'Orange Carrots', 'Orange Carrots', 53, 20, '1487841383.jpg', NULL, 36, 'The carrot (Daucus carota subsp. sativus) is a root vegetable, usually orange in colour, though purple, black, red, white, and yellow varieties exist.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(32, 'Parsley', 'Parsley', 53, 20, '1487841528.jpg', NULL, 37, 'Parsley, Petroselinum crispum is an herbaceous biennial or perennial plant in the family Apiaceae grown for its leaves which are used as a herb. Parsley is an aromatic plant with an erect growth habit and possesses branched, hollow stems and dark green flat or curled leaves which are arranged alternately on the stems.', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 0.00, 0),
(34, 'a1', 'clamato', 55, 55, '1493269602.png', NULL, 13, 'Bueno y barato ', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL),
(35, 'LM001', '3 bedrooms house', 57, 656, '1495776676.jpg', NULL, 25, '3 bedrooms comfortable house\r\n', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, 8.00, 4),
(36, 'LM002', '2 bedrooms house', 57, 554, '1495776835.jpg', NULL, 25, 'Comfortable home', 1, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `food_promotion`
--

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `food_promotion`
--

INSERT INTO `food_promotion` (`id`, `promotion_id`, `food_id`) VALUES
(1, 1, 1),
(2, 1, 3);

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `food_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `food_id`, `name`) VALUES
(1, 15, '148013282061.png'),
(2, 3, '148066808790.jpg'),
(3, 1, '14809953104.jpg'),
(4, 5, '148099608325.jpg'),
(5, 5, '148099608360.png'),
(6, 3, '148101484658.jpg'),
(7, 3, '148101484613.jpg'),
(8, 16, '148134090169.JPG'),
(9, 16, '148134090168.JPG'),
(10, 16, '148134090174.JPG'),
(11, 16, '14813409018.jpg'),
(12, 16, '14813409011.jpg'),
(13, 17, '148134092653.jpg'),
(14, 17, '148134092795.jpg'),
(15, 18, '148134096780.JPG'),
(16, 18, '148134096739.JPG'),
(17, 18, '148134096793.JPG'),
(30, 19, '148136353263.jpg'),
(31, 19, '148136353220.jpg'),
(32, 19, '148136353276.jpg'),
(33, 19, '148136353282.jpg'),
(34, 19, '148136353267.jpg'),
(35, 19, '148136353285.jpg'),
(36, 20, '148136380434.jpg'),
(37, 20, '148136380429.jpg'),
(38, 20, '14813638049.jpg'),
(39, 20, '148136380443.jpg'),
(40, 20, '14813638053.jpg'),
(41, 20, '148136380540.jpg'),
(42, 1, '148136425134.png'),
(43, 1, '148136425146.png'),
(44, 21, '14813655038.jpg'),
(45, 21, '148136550330.jpg'),
(46, 21, '148136550328.jpg'),
(47, 21, '148136550321.jpg'),
(48, 21, '148136550320.jpg'),
(49, 13, '14813669363.jpg'),
(50, 13, '148136693667.jpg'),
(51, 13, '148136693629.jpg'),
(52, 23, '148162373664.jpg'),
(53, 25, '148784055668.jpg'),
(54, 26, '148784070599.jpg'),
(55, 27, '148784085813.jpg'),
(56, 28, '148784102973.jpg'),
(57, 29, '148784114189.jpg'),
(58, 30, '148784125312.jpg'),
(59, 31, '14878413839.jpg'),
(60, 32, '148784152878.jpg'),
(63, 34, '149326960264.jpg'),
(65, 35, '149577667630.jpg'),
(66, 36, '149577683554.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `location`
--

CREATE TABLE IF NOT EXISTS `location` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_category` varchar(500) NOT NULL,
  `location_name` varchar(100) 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_thumbnail` varchar(500) NOT 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_hotline` varchar(500) NOT 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,
  `website` varchar(500) NOT NULL,
  PRIMARY KEY (`location_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`location_id`, `location_category`, `location_name`, `location_city`, `location_address`, `account_id`, `location_image`, `location_thumbnail`, `location_des`, `location_tel`, `location_hotline`, `location_open_hour_style`, `location_open_hour`, `location_last_order_hour`, `location_latitude`, `location_longitude`, `status`, `lang`, `tax`, `shipping`, `rate`, `rate_times`, `gmt`, `isVerified`, `isFeatured`, `facebook`, `twitter`, `email`, `live_chat`, `website`) VALUES
(38, '14,24', 'Passions shop', 1, '123 King Street', '1397811111', '1453535518.jpg', '1480664754thumbnail.png', 'Drinks for you!', '123456789', '', 0, NULL, NULL, '-37.80793430030419', '144.94960819140624', 1, NULL, '{"VAT":"10","tax_status":"1"}', '{"flat_rate":"11","minimum":"500","local_pickup":"1","shipping_status":"1"}', 8.50, 4, 'Australia/Melbourne', 0, 1, 'facebook.com/shopvip', 'twitter.com/shopvip', 'passions@gmail.com', 'live_chat2', 'passionShop.com'),
(40, '28,33', 'Motors Car Shop', 24, '12 Diago Street', '1397811111', '1453533859.jpg', '1480990465thumbnail.png', 'Sell car and moto accessories ', '12345654321', '', 0, NULL, NULL, '-37.826305483660875', '144.95169672493284', 1, NULL, '{"VAT":"10","tax_status":0}', '{"flat_rate":"10","minimum":1000,"local_pickup":1,"shipping_status":0}', 0.00, 0, 'Asia/Bangkok', 1, 0, 'facebook.com/shopvip', 'twitter.com/shoesZone', 'carshop@gmail.com', 'live_chat2', 'motocar.com'),
(50, '13,24,26', 'Kata shop', 1, 'Blackburn Road', '1481616699', '1481622175.jpg', '1481622175thumbnail.jpg', 'Gift', NULL, '5343584353', 0, NULL, NULL, '-37.97401593221037', '145.0531353', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', 0.00, 0, 'Australia/Melbourne', 0, 0, '', '', '', '', ''),
(51, '14,24,26,29,13', 'Gift Shop', 1, '65 Blackburn Road', '1481623122', '1481623542.png', '1481623542thumbnail.jpg', 'gift', NULL, '424620505', 0, NULL, NULL, '-37.823209517618146', '145.1525026687866', 1, NULL, '{"VAT":"11","tax_status":"0"}', '{"flat_rate":"5","minimum":"15","local_pickup":"1","shipping_status":"1"}', 0.00, 0, 'Australia/Melbourne', 0, 0, '', '', '', '', ''),
(52, '35,36,37,38', 'Marrapa and Son', 27, 'Tumkur-Kunigal Rd, Saraswathipuram, Tumakuru, Karn', '1397811111', '1487838243.jpg', '1487838243thumbnail.jpg', 'We are a small family farm in the midst of 110 acres of hardwoods and long leaf pines in Tumakuru. We maintain our property as a wildlife sanctuary (which makes for interesting farming!) and we are dedicated to being good stewards of the earth and it''s creatures by practicing all natural, sustainable agricultural methods. We have been Certified Naturally Grown since we started our farm in 2009. We grow lots of varieties of heirloom vegetables, fruits, and flowers; we are especially interested in growing  winter squash, okra, peas, beans, peppers ,tomatoes, and melons.', '+959 12345678', '+959 12345678', 0, NULL, NULL, '13.339200', '77.113998', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', 0.00, 0, 'Indian/Antananarivo', 0, 0, '', '', '', '', ''),
(53, '35,36,37,38', 'Royal Fruits', 27, 'Bandaramanahalli Village, Uganvadi Post Devanahall', '1397811111', '1487839158.jpg', '1487839158thumbnail.jpg', 'Royal Fruits having revolutionized and upgraded the time tested street vending format aims to reach the Customers in this unique delivery format in order that they experience the ease and convenience of quality FnV purchase right at their doorstep. The transparency of pricing and an automated digital bill for every purchase embellishes the Royal Fruits story of providing a supermarket experience for the Customers while the digital weighing scale, with Customer friendly dual display, provides ample testimony to the accuracy of the weight of FnV purchased.', '095912345678', '095912345678', 0, NULL, NULL, '13.241700', '77.713699', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', 0.00, 0, 'Indian/Antananarivo', 0, 0, '', '', '', '', ''),
(54, '35,36,37,38', 'Jed Farms', 1, 'Bannerughata, Bangalore-560085', '1397811111', '1487839917.jpg', '1487839917thumbnail.jpg', 'As organic producers, we try to mimic nature in order to grow food with a minimum of external inputs. If we plan to mimic nature, we need to understand as much about the biology of plants and ecological systems as we can. ', '987654321', '095912345678', 0, NULL, NULL, '12.888500', '77.597298', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', 0.00, 0, 'Indian/Antananarivo', 0, 0, '', '', '', '', ''),
(55, '13', 'Cocos', 1, 'Canelas', '1492576113', '1493268910.jpg', '1493269939thumbnail.png', 'Venta de snacks', '6182998877', '45678900''', 0, NULL, NULL, '21.012123298378715', '105.80125813359382', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', NULL, NULL, 'America/Mexico_City', 1, 0, 'https://www.facebook.com/Sin-Tantita-Pena-Clamatos-Snacks-568631503179071/?fref=ts', '', '', '', ''),
(57, '', 'BONGU eCommerce', 28, '66666', '1500488406', '1500473782.jpg', '1500513387thumbnail.apk', 'All staff', '0657685268', '0657685268', 0, NULL, NULL, '18.579425489969708', '-72.29800711250004', 1, NULL, '{"VAT":"12","tax_status":"1"}', '{"flat_rate":"34","minimum":"20","local_pickup":"1","shipping_status":"1"}', NULL, NULL, 'America/Port-au-Prince', 1, 1, '', '', '', '', ''),
(58, '13', 'HAPRO', 28, '5555', '1397811111', '1500489001.jpg', '1500518211thumbnail.jpg', '', '2222', '4444', 0, NULL, NULL, '18.59472563481202', '-72.3040771484375', 1, NULL, '{"VAT":0,"tax_status":0}', '{"flat_rate":0,"minimum":0,"local_pickup":1,"shipping_status":0}', NULL, NULL, 'America/Port-au-Prince', 1, 1, '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `menus`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=39 ;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`menu_id`, `menu_name`, `menu_small_thumbnail`, `menu_desc`, `parent_id`, `status`, `lang`) VALUES
(10, 'Clothes', '1453521484.jpeg', '<p>Clothes&nbsp;category</p>\r\n', 0, 1, 2),
(13, 'FastFood', '1453524479.jpeg', '<p>FastFood for you.</p>\r\n', 0, 1, 2),
(14, 'Shoes', '1453531055.jpeg', '<p>Shoe for every body</p>\r\n', 0, 1, 2),
(24, 'Watch', '1453525447.jpeg', '<p>Watch Description</p>\r\n', 0, 1, NULL),
(25, 'Building materials', '1453532195.jpeg', '<p>Building materials description</p>\r\n', 0, 1, NULL),
(26, 'Gift and Souvenir', '1453524903.jpeg', '<p>Gif and Souvenir description!</p>\r\n', 0, 1, NULL),
(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),
(28, 'Car accessories', '1453536379.jpg', '<p>Car accessories&nbsp;description</p>\r\n', 0, 1, NULL),
(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),
(30, 'Drinks', '1398218790.jpg', '<p>selling drinks, you can get to the store or ordering online!</p>\r\n', 0, 1, NULL),
(31, 'Electronics', '1453524661.jpeg', '<p>You can buy electronics from here.&nbsp;</p>\r\n', 0, 1, NULL),
(32, 'pizza', '1480132683.png', '<p>Classic marinara sauce, authentic old-world pepperoni, seasoned pork, beef, fresh mushrooms, fresh green bell peppers and fresh red onions.</p>\r\n', 0, 1, NULL),
(33, 'Auto Lighting System', '1481364992.jpg', '<p>Auto Lighting System</p>\r\n', 0, 1, NULL),
(34, 'Smart phone', '1481625063.jpg', '<p>Smart phone</p>\r\n', 0, 1, NULL),
(35, 'Farm', '1487837918.jpg', '<p>Farms</p>\r\n', 0, 1, NULL),
(36, 'Veggie', '1487837949.jpg', '<p>Veggie</p>\r\n', 0, 1, NULL),
(37, 'Herb', '1487837973.jpg', '<p>Herb</p>\r\n', 0, 1, NULL),
(38, 'Fruit', '1487838010.jpg', '<p>Fruit</p>\r\n', 0, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `open_hour_detail`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=393 ;

--
-- Dumping data for table `open_hour_detail`
--

INSERT INTO `open_hour_detail` (`id`, `shopId`, `dateId`, `openAM`, `closeAM`, `openPM`, `closePM`) VALUES
(225, 38, 1, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(226, 38, 2, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(227, 38, 3, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(228, 38, 4, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(229, 38, 5, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(230, 38, 6, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(231, 38, 7, '08:00 PM', '08:00 AM', '08:00 AM', '08:00 PM'),
(232, 39, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(233, 39, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(234, 39, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(235, 39, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(236, 39, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(237, 39, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(238, 39, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(239, 40, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(240, 40, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(241, 40, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(242, 40, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(243, 40, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(244, 40, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(245, 40, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(246, 41, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(247, 41, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(248, 41, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(249, 41, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(250, 41, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(251, 41, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(252, 41, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(253, 42, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(254, 42, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(255, 42, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(256, 42, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(257, 42, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(258, 42, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(259, 42, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(260, 43, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(261, 43, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(262, 43, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(263, 43, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(264, 43, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(265, 43, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(266, 43, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(281, 46, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(282, 46, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(283, 46, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(284, 46, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(285, 46, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(286, 46, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(287, 46, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(288, 44, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(289, 44, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(290, 44, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(291, 44, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(292, 44, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(293, 44, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(294, 44, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(295, 45, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(296, 45, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(297, 45, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(298, 45, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(299, 45, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(300, 45, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(301, 45, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(302, 46, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(303, 46, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(304, 46, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(305, 46, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(306, 46, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(307, 46, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(308, 46, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(309, 47, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(310, 47, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(311, 47, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(312, 47, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(313, 47, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(314, 47, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(315, 47, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(316, 48, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(317, 48, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(318, 48, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(319, 48, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(320, 48, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(321, 48, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(322, 48, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(323, 49, 1, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(324, 49, 2, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(325, 49, 3, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(326, 49, 4, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(327, 49, 5, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(328, 49, 6, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(329, 49, 7, '12:00 AM', '12:00 PM', '12:00 PM', '12:00 AM'),
(330, 50, 1, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(331, 50, 2, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(332, 50, 3, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(333, 50, 4, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(334, 50, 5, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(335, 50, 6, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(336, 50, 7, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(337, 51, 1, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(338, 51, 2, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(339, 51, 3, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(340, 51, 4, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(341, 51, 5, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(342, 51, 6, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(343, 51, 7, '08:00 PM', '12:00 AM', '03:00 AM', '11:00 AM'),
(344, 52, 1, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(345, 52, 2, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(346, 52, 3, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(347, 52, 4, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(348, 52, 5, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(349, 52, 6, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(350, 52, 7, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(351, 53, 1, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(352, 53, 2, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(353, 53, 3, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(354, 53, 4, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(355, 53, 5, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(356, 53, 6, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(357, 53, 7, '04:00 AM', '04:00 PM', '04:00 PM', '04:00 AM'),
(358, 54, 1, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(359, 54, 2, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(360, 54, 3, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(361, 54, 4, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(362, 54, 5, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(363, 54, 6, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(364, 54, 7, '04:00 AM', '08:00 AM', '11:00 AM', '07:00 PM'),
(365, 55, 1, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(366, 55, 2, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(367, 55, 3, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(368, 55, 4, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(369, 55, 5, '08:00 PM', '08:00 PM', '08:00 PM', '08:00 PM'),
(370, 55, 6, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(371, 55, 7, '12:00 PM', '04:00 PM', '07:00 PM', '03:00 AM'),
(379, 57, 1, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(380, 57, 2, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(381, 57, 3, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(382, 57, 4, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(383, 57, 5, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(384, 57, 6, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(385, 57, 7, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(386, 58, 1, '11:00 AM', '05:59 PM', '06:00 PM', '03:59 AM'),
(387, 58, 2, '11:00 AM', '03:59 PM', '06:00 PM', '03:59 AM'),
(388, 58, 3, '11:00 AM', '04:00 PM', '05:00 PM', '03:59 AM'),
(389, 58, 4, '11:00 AM', '03:00 PM', '06:00 PM', '03:00 AM'),
(390, 58, 5, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(391, 58, 6, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM'),
(392, 58, 7, '11:00 AM', '03:00 PM', '06:00 PM', '02:00 AM');

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `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,
  `refund` tinyint(1) NOT NULL,
  `order_places` text COLLATE utf8_unicode_ci NOT NULL,
  `order_name` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `order_phone` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `order_email` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `order_city` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `order_zip_code` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_name` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_phone` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_email` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_address` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_city` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `billing_zip_code` varchar(500) 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,
  `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=81 ;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `account_id`, `shop_id`, `refund`, `order_places`, `order_name`, `order_phone`, `order_email`, `order_city`, `order_zip_code`, `billing_name`, `billing_phone`, `billing_email`, `billing_address`, `billing_city`, `billing_zip_code`, `order_requirement`, `order_time`, `status`, `paymentMethod`, `paymentStatus`, `created`, `group_code`, `chef_id`, `deliveryman_id`) VALUES
(1, '1397811111', 40, 0, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Bangalore', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Bangalore', '500000', '', '2016-12-12 ', 0, 2, 1, '2016-12-12 16:27:01', 'BF853DD010', NULL, NULL),
(3, '1481529010', 38, 0, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Melbourne', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Blackburn Melbourne', '500000', '', '2016-12-13 08:35:14', 0, 2, 1, '2016-12-13 08:35:14', 'E917F22010', NULL, NULL),
(4, '1481529010', 38, 0, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Melbourne', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Blackburn Melbourne', '500000', '', '2016-12-13 08:36:22', 0, 2, 1, '2016-12-13 08:36:22', '7D98565010', NULL, NULL),
(5, '1481529010', 38, 0, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Melbourne', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Blackburn Melbourne', '500000', '', '2016-12-13 08:37:45', 0, 2, 1, '2016-12-13 08:37:45', '91E150B010', NULL, NULL),
(6, '1481529010', 38, 2, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Bangalore', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Bangalore', '500000', '', '2016-12-13 ', 0, 2, 1, '2016-12-13 08:38:24', '14E7C46010', NULL, NULL),
(7, '1481529010', 40, 0, 'Blackburn Road', 'Tony', '424620505', 'hicomtony@gmail.com', 'Bangalore', '500000', 'Tony', '424620505', 'hicomtony@gmail.com', 'Blackburn Road', 'Bangalore', '500000', '', '2016-12-13 ', 4, 2, 1, '2016-12-13 08:38:58', '6D4BD3F010', NULL, NULL),
(8, '1484715193', 51, 0, '', 'Hà Hà', '', 'buingocha6789@gmail.com', '', '', 'Hà Hà', '123123123123', 'buingocha6789@gmail.com', '123123123123', '12313123123', '123123123', '', '2017-01-18 14:13:11', 0, 2, 1, '2017-01-18 14:13:11', 'CAFD0BD193', NULL, NULL),
(9, '1484715193', 51, 0, 'dan phuong', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'ha noi', '10000', 'Hà Hà', '123123123123', 'buingocha6789@gmail.com', '123123123123', '12313123123', '123123123', '', '2017-01-18 14:17:48', 0, 2, 1, '2017-01-18 14:17:48', '6EADB71193', NULL, NULL),
(10, '1484715193', 51, 0, 'dan phuong', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'ha noi', '10000', 'Ha ha', '123123123123', 'buingocha6789@gmail.com', '123123123123', '12313123123', '123123123', '', '2017-01-18 14:18:05', 0, 2, 1, '2017-01-18 14:18:05', 'EF4C787193', NULL, NULL),
(11, '1484715193', 38, 0, 'dan phuong', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'ha noi', '10000', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'dan phuong', 'ha noi', '10000', '', '2017-01-18 14:19:34', 0, 2, 1, '2017-01-18 14:19:34', '9D112A0193', NULL, NULL),
(12, '1484715193', 50, 0, 'dan phuong', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'ha noi', '10000', 'Ha', '0123123123', 'buingocha6789@gmail.com', 'dan phuong', 'ha noi', '10000', '', '2017-01-18 14:39:42', 0, 2, 1, '2017-01-18 14:39:42', 'D7E54EC193', NULL, NULL),
(13, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris', '757-681-5600', 'hicomjames@gmail.com', 'charlotte', '10000', 'Chris', '757-681-5600', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '10000', '', '2017-02-20 18:05:20', 0, 1, 0, '2017-02-20 18:05:20', 'D175A9F757', NULL, NULL),
(14, '1488505808', 38, 0, 'Address', 'Hicom David', '8797646454', 'hicom.david@gmail.com', 'City', '10000', 'Hicom David', '8797646454', 'hicom.david@gmail.com', 'Address', 'City', '10000', '', '2017-03-03 08:56:26', 0, 2, 1, '2017-03-03 08:56:26', 'DA4608F808', NULL, NULL),
(15, '1488516592', 51, 0, 'address', 'Phạm Điệp', '849464545', 'phamvandiep93@yahoo.com', 'city', '10000', 'Phạm Điệp', '849464545', 'phamvandiep93@yahoo.com', 'address', 'city', '10000', '', '2017-03-03 11:51:35', 0, 2, 1, '2017-03-03 11:51:35', '653C810592', NULL, NULL),
(16, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '757-681-5600', 'hicomjames@gmail.com', 'charlotte', '10000', 'Chris ho', '757-681-5600', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '10000', '', '2017-03-11 00:59:48', 0, 2, 1, '2017-03-11 00:59:48', '98A3122757', NULL, NULL),
(17, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '757-681-5600', 'hicomjames@gmail.com', 'charlotte', '10000', 'Chris ho', '757-681-5600', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '10000', '', '2017-04-28 17:46:39', 0, 0, 0, '2017-04-28 17:46:39', '1E92157757', NULL, NULL),
(18, '1488516592', 38, 0, 'address', 'Phạm Điệp', '849464545', 'phamvandiep93@yahoo.com', 'Bangalore', '10000', 'Phạm Điệp', '849464545', 'phamvandiep93@yahoo.com', 'address', 'Bangalore', '10000', '', '2017-05-11 16:45:18', 0, 2, 1, '2017-05-11 16:45:18', '09C7F68592', NULL, NULL),
(19, '1495008909', 38, 0, 'Jdjdjd', 'Logan', '12348767', 'hicom.logan@gmail.com', 'Ncnx', '2445649', 'Logan', '12348767', 'hicom.logan@gmail.com', 'Jdjdjd', 'Ncnx', '2445649', '', '2017-05-17 15:16:35', 0, 2, 1, '2017-05-17 15:16:35', 'EE63D97909', NULL, NULL),
(20, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 18:56:14', 0, 2, 1, '2017-05-25 18:56:14', '25E71FE757', NULL, NULL),
(21, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 18:59:11', 0, 0, 0, '2017-05-25 18:59:11', 'DD573E0757', NULL, NULL),
(22, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 19:21:28', 0, 1, 0, '2017-05-25 19:21:28', '6761A57757', NULL, NULL),
(23, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 19:25:02', 0, 2, 1, '2017-05-25 19:25:02', 'B783517757', NULL, NULL),
(24, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 19:25:02', 0, 2, 1, '2017-05-25 19:25:02', 'B783517757', NULL, NULL),
(25, '1432968757', 53, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:44:25', 0, 2, 1, '2017-05-25 22:44:25', '4C196C3757', NULL, NULL),
(26, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:44:25', 0, 2, 1, '2017-05-25 22:44:25', '4C196C3757', NULL, NULL),
(27, '1432968757', 51, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:44:25', 0, 2, 1, '2017-05-25 22:44:25', '4C196C3757', NULL, NULL),
(28, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:59:30', 0, 0, 0, '2017-05-25 22:59:30', '588FD3F757', NULL, NULL),
(29, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:59:30', 0, 0, 0, '2017-05-25 22:59:30', '588FD3F757', NULL, NULL),
(30, '1432968757', 55, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:59:30', 0, 0, 0, '2017-05-25 22:59:30', '588FD3F757', NULL, NULL),
(31, '1432968757', 54, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-25 22:59:30', 0, 0, 0, '2017-05-25 22:59:30', '588FD3F757', NULL, NULL),
(33, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Sorry', '2017-05-26 ', 4, 0, 0, '2017-05-26 12:59:15', 'D25E522757', NULL, NULL),
(34, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Okey', '2017-05-26 ', 4, 0, 0, '2017-05-26 13:09:39', '5FA25C9757', NULL, NULL),
(35, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Thanks', '2017-05-26 ', 4, 0, 0, '2017-05-26 13:09:59', '280C42D757', NULL, NULL),
(36, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'hicomjames@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Thanks very much', '2017-05-26 ', 4, 1, 0, '2017-05-26 13:19:24', 'AEE416E757', NULL, NULL),
(37, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'lwifunyomangula@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'lwifunyomangula@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Okey', '2017-05-26 ', 4, 0, 0, '2017-05-26 13:21:41', 'CB262B1757', NULL, NULL),
(38, '1432968757', 57, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'Bangalore', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'Bangalore', '255', 'Hello', '2017-05-26 ', 4, 0, 0, '2017-05-26 13:45:21', 'BDCCABF757', NULL, NULL),
(40, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-29 18:05:48', 0, 2, 1, '2017-05-29 18:05:48', '7DCEC6D757', NULL, NULL),
(41, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-29 18:07:59', 0, 0, 0, '2017-05-29 18:07:59', '8778D75757', NULL, NULL),
(42, '1432968757', 40, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-05-29 18:08:19', 0, 0, 0, '2017-05-29 18:08:19', '9AC60BD757', NULL, NULL),
(43, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-07-17 13:26:46', 0, 2, 1, '2017-07-17 13:26:46', 'DF0E9CB757', NULL, NULL),
(44, 'admin', 51, 0, 'Sydney', 'Stephen', '9942048657', 'hicomsolution@gmail.com', 'Sydney', '3467', 'fggg', ' 50931564346', 'carlhens17@yahoo.fr', 'Delmas', 'Ouest', '3111', '', '2017-07-20 03:50:16', 0, 2, 1, '2017-07-20 03:50:16', '9D0478Amin', NULL, NULL),
(45, '1500518661', 40, 0, 'Gaga', 'Bi', '0984545', 'bi@gmail.com', 'Vav', '10000', 'Bi', '0984545', 'bi@gmail.com', 'Gaga', 'Vav', '10000', '', '2017-07-20 09:47:27', 0, 2, 1, '2017-07-20 09:47:27', '504526D661', NULL, NULL),
(46, '1500519473', 38, 0, 'Hshgsg', 'Bibi', '09422454', 'bibi@gmail.com', 'Hag', '545', 'Bibi', '09422454', 'bibi@gmail.com', 'Hshgsg', 'Hag', '545', '', '2017-07-20 10:02:53', 0, 2, 1, '2017-07-20 10:02:53', '504E618473', NULL, NULL),
(47, '1500519473', 52, 0, 'Hshgsg', 'Bibi', '09422454', 'bibi@gmail.com', 'Hag', '545', 'Bibi', '09422454', 'bibi@gmail.com', 'Hshgsg', 'Hag', '545', '', '2017-07-20 10:02:53', 0, 2, 1, '2017-07-20 10:02:53', '504E618473', NULL, NULL),
(48, '1500519473', 40, 0, 'Hshgsg', 'Bibi', '09422454', 'bibi@gmail.com', 'Hag', '545', 'Bibi', '09422454', 'bibi@gmail.com', 'Hshgsg', 'Hag', '545', '', '2017-07-20 10:02:53', 0, 2, 1, '2017-07-20 10:02:53', '504E618473', NULL, NULL),
(49, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-07-26 15:15:51', 0, 0, 0, '2017-07-26 15:15:51', '2CC3FE9757', NULL, NULL),
(50, '1501583711', 38, 0, '', 'Tr??ng Tr??ng', '', 'truongnv1292@gmail.com', '', '', 'Tr??ng Tr??ng', '0123456789', 'truongnv1292@gmail.com', 'hanoi', 'hanoi', '12567', '', '2017-08-01 17:38:01', 0, 2, 1, '2017-08-01 17:38:01', '77CDDB1711', NULL, NULL),
(51, '1501583711', 38, 0, '', 'Tr??ng Tr??ng', '', 'truongnv1292@gmail.com', '', '', 'truong', '0946464864', 'truongnv1292@gmail.com', 'hanoi1', 'dhhdhshhsh', 'hshdhd', '', '2017-08-01 17:57:17', 0, 2, 1, '2017-08-01 17:57:17', 'CED526B711', NULL, NULL),
(52, '1501583711', 40, 0, '', 'Tr??ng Tr??ng', '', 'truongnv1292@gmail.com', '', '', 'truong', '0946464864', 'truongnv1292@gmail.com', 'hanoi1', 'dhhdhshhsh', 'hshdhd', '', '2017-08-01 17:57:17', 0, 2, 1, '2017-08-01 17:57:17', 'CED526B711', NULL, NULL),
(53, '1501583711', 38, 0, 'hanoi', 'Truong', '0213549486', 'truongnv1292@gmail.com', 'hanoi', '15366', 'Truong', '0213549486', 'truongnv1292@gmail.com', 'hanoi', 'hanoi', '15366', '', '2017-08-02 08:36:44', 0, 0, 0, '2017-08-02 08:36:44', '1732847711', NULL, NULL),
(54, '1494497660', 38, 0, '', 'Cuong Pham Manh', '', 'pham_cuong95@yahoo.com', '', '', 'Cuong Pham Manh', '0255458559', 'pham_cuong95@yahoo.com', 'hn', 'hn', '3774', '', '2017-08-02 08:53:41', 0, 0, 0, '2017-08-02 08:53:41', 'F1FF482660', NULL, NULL),
(58, '1502266717', 51, 0, '', 'James James', '', 'josdoankiem@gmail.com', '', '', 'James James', '12365666', 'josdoankiem@gmail.com', '32Box 1, Vic 3200', 'victoria', '879000', '', '2017-08-09 15:56:59', 0, 0, 0, '2017-08-09 15:56:59', '5C52041717', NULL, NULL),
(59, '1502266717', 55, 0, '', 'James James', '', 'josdoankiem@gmail.com', '', '', 'James James', '123456789', 'josdoankiem@gmail.com', '32Box 1, vic 3200', 'Vic', '879000', '', '2017-08-09 16:01:16', 0, 0, 0, '2017-08-09 16:01:16', 'DC7D69D717', NULL, NULL),
(73, '1502266717', 51, 0, '32 Box 1, Vic 3200', 'James James', '123456789', 'josdoankiem@gmail.com', 'Victoria', '879000', 'James James', '123456789', 'josdoankiem@gmail.com', '32 Box 1, Vic 3200', 'Victoria', '879000', '', '2017-08-09 16:30:51', 0, 2, 1, '2017-08-09 16:30:51', 'FBAC569717', NULL, NULL),
(74, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-08-09 16:42:05', 0, 0, 0, '2017-08-09 16:42:05', '2EBD2BF757', NULL, NULL),
(75, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-08-09 16:42:28', 0, 0, 0, '2017-08-09 16:42:28', '105229F757', NULL, NULL),
(76, '1502266717', 38, 0, '32 Box 1, Vic 3200', 'James James', '123456789', 'josdoankiem@gmail.com', 'Victoria', '879000', 'James James', '123456789', 'josdoankiem@gmail.com', '32 Box 1, Vic 3200', 'Victoria', '879000', '', '2017-08-09 16:44:44', 0, 0, 0, '2017-08-09 16:44:44', '8ED3E2E717', NULL, NULL),
(77, '1432968757', 38, 0, 'PO Box 668132, Charlotte, NC', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'charlotte', '255', 'Chris ho', '255657685268', 'drimhomzteam@gmail.com', 'PO Box 668132, Charlotte, NC', 'charlotte', '255', '', '2017-08-09 16:45:21', 0, 2, 1, '2017-08-09 16:45:21', '43AFE6C757', NULL, NULL),
(78, '1502266717', 38, 0, '32 Box 1, Vic 3200', 'James James', '123456789', 'josdoankiem@gmail.com', 'Victoria', '879000', 'James James', '123456789', 'josdoankiem@gmail.com', '32 Box 1, Vic 3200', 'Victoria', '879000', '', '2017-08-09 16:46:35', 0, 0, 0, '2017-08-09 16:46:35', '1D1FD70717', NULL, NULL),
(79, '1502266717', 38, 0, '32 Box 1, Vic 3200', 'James James', '123456789', 'josdoankiem@gmail.com', 'Victoria', '879000', 'James James', '123456789', 'josdoankiem@gmail.com', '32 Box 1, Vic 3200', 'Victoria', '879000', '', '2017-08-09 17:00:59', 0, 1, 0, '2017-08-09 17:00:59', '176801B717', NULL, NULL),
(80, '1502266717', 38, 0, '32 Box 1, Vic 3200', 'James James', '123456789', 'josdoankiem@gmail.com', 'Victoria', '879000', 'James James', '123456789', 'josdoankiem@gmail.com', '32 Box 1, Vic 3200', 'Victoria', '879000', '', '2017-08-09 17:05:59', 0, 2, 1, '2017-08-09 17:05:59', '1DC6BE8717', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `order_food`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=120 ;

--
-- Dumping data for table `order_food`
--

INSERT INTO `order_food` (`id`, `order_id`, `food_id`, `number`, `price`) VALUES
(4, 3, 19, 1, 145),
(5, 4, 20, 2, 79),
(6, 4, 1, 1, 99),
(7, 5, 19, 5, 145),
(10, 6, 3, 5, 22),
(11, 7, 13, 4, 300),
(14, 8, 23, 1, 20),
(15, 9, 23, 1, 20),
(16, 10, 23, 1, 20),
(17, 11, 1, 1, 99),
(18, 12, 22, 14, 20),
(19, 13, 21, 1, 300),
(20, 14, 3, 1, 22),
(21, 15, 23, 1, 20),
(22, 16, 1, 1, 99),
(23, 17, 19, 1, 145),
(24, 18, 3, 1, 22),
(25, 19, 1, 6, 99),
(26, 20, 3, 4, 22),
(27, 21, 5, 2, 123),
(28, 21, 13, 6, 300),
(29, 22, 5, 2, 123),
(30, 22, 13, 6, 300),
(31, 23, 19, 5, 145),
(32, 23, 3, 2, 22),
(33, 24, 5, 1, 123),
(34, 25, 31, 7, 20),
(35, 26, 20, 1, 79),
(36, 26, 19, 1, 145),
(37, 26, 3, 1, 22),
(38, 27, 23, 1, 20),
(39, 27, 24, 6, 30),
(40, 28, 19, 3, 145),
(41, 28, 1, 2, 99),
(42, 29, 5, 1, 123),
(43, 29, 13, 1, 300),
(44, 30, 34, 6, 55),
(45, 31, 7, 1, 5),
(54, 33, 35, 3, 656),
(57, 35, 35, 3, 656),
(59, 34, 35, 3, 656),
(63, 37, 35, 1, 656),
(66, 36, 35, 1, 656),
(70, 38, 36, 2, 554),
(72, 40, 19, 1, 145),
(73, 41, 5, 2, 123),
(74, 42, 5, 2, 123),
(77, 1, 13, 1, 300),
(78, 1, 5, 1, 123),
(79, 43, 19, 1, 145),
(80, 44, 23, 1, 20),
(81, 45, 13, 1, 300),
(82, 46, 1, 1, 99),
(83, 47, 27, 1, 50),
(84, 48, 13, 1, 300),
(85, 49, 1, 1, 99),
(86, 50, 1, 2, 99),
(87, 51, 1, 1, 99),
(88, 51, 3, 1, 22),
(89, 51, 19, 4, 145),
(90, 52, 5, 1, 123),
(91, 53, 1, 1, 99),
(92, 53, 19, 1, 145),
(93, 54, 3, 2, 22),
(97, 58, 23, 1, 20),
(98, 59, 34, 1, 55),
(112, 73, 23, 1, 20),
(113, 74, 19, 1, 145),
(114, 75, 19, 1, 145),
(115, 76, 1, 1, 99),
(116, 77, 19, 1, 145),
(117, 78, 1, 1, 99),
(118, 79, 3, 1, 22),
(119, 80, 3, 1, 22);

-- --------------------------------------------------------

--
-- Table structure for table `order_group`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Dumping data for table `order_group`
--

INSERT INTO `order_group` (`group_code`, `total`, `dateCreated`, `account_id`) VALUES
('09C7F68592', 35.2, '2017-05-11 16:45:18', '1488516592'),
('105229F757', 170.5, '2017-08-09 16:42:28', '1432968757'),
('14E7C46010', 133.1, '2016-12-13 08:38:24', '1481529010'),
('1732847711', 279.4, '2017-08-02 08:36:44', '1501583711'),
('176801B717', 35.2, '2017-08-09 17:00:59', '1502266717'),
('1D1FD70717', 119.9, '2017-08-09 16:46:35', '1502266717'),
('1DC6BE8717', 35.2, '2017-08-09 17:05:59', '1502266717'),
('1E92157757', 170.5, '2017-04-28 17:46:39', '1432968757'),
('25E71FE757', 107.8, '2017-05-25 18:56:14', '1432968757'),
('280C42D757', 2204.16, '2017-05-26 13:09:59', '1432968757'),
('2CC3FE9757', 119.9, '2017-07-26 15:15:51', '1432968757'),
('2EBD2BF757', 170.5, '2017-08-09 16:42:05', '1432968757'),
('43AFE6C757', 170.5, '2017-08-09 16:45:21', '1432968757'),
('4C196C3757', 621.6, '2017-05-25 22:44:25', '1432968757'),
('504526D661', 300, '2017-07-20 09:47:27', '1500518661'),
('504E618473', 469.9, '2017-07-20 10:02:53', '1500519473'),
('588FD3F757', 1454.3, '2017-05-25 22:59:30', '1432968757'),
('5C52041717', 20, '2017-08-09 15:56:59', '1502266717'),
('5FA25C9757', 2204.16, '2017-05-26 13:09:39', '1432968757'),
('653C810592', 20, '2017-03-03 11:51:35', '1488516592'),
('6761A57757', 2046, '2017-05-25 19:21:28', '1432968757'),
('6D4BD3F010', 1200, '2016-12-13 08:38:58', '1481529010'),
('6EADB71193', 20, '2017-01-18 14:17:48', '1484715193'),
('77CDDB1711', 228.8, '2017-08-01 17:38:01', '1501583711'),
('7D98565010', 293.7, '2016-12-13 08:36:22', '1481529010'),
('7DCEC6D757', 170.5, '2017-05-29 18:05:48', '1432968757'),
('8778D75757', 246, '2017-05-29 18:07:59', '1432968757'),
('8ED3E2E717', 119.9, '2017-08-09 16:44:44', '1502266717'),
('91E150B010', 797.5, '2016-12-13 08:37:45', '1481529010'),
('98A3122757', 119.9, '2017-03-11 00:59:48', '1432968757'),
('9AC60BD757', 246, '2017-05-29 18:08:19', '1432968757'),
('9D0478Amin', 20, '2017-07-20 03:50:16', 'admin'),
('9D112A0193', 119.9, '2017-01-18 14:19:34', '1484715193'),
('AEE416E757', 734.72, '2017-05-26 13:19:24', '1432968757'),
('B783517757', 968.9, '2017-05-25 19:25:02', '1432968757'),
('BDCCABF757', 1240.96, '2017-05-26 13:45:21', '1432968757'),
('BF853DD010', 423, '2016-12-12 16:27:01', '1481529010'),
('CAFD0BD193', 20, '2017-01-18 14:13:11', '1484715193'),
('CB262B1757', 734.72, '2017-05-26 13:21:41', '1432968757'),
('CED526B711', 894.1, '2017-08-01 17:57:17', '1501583711'),
('D175A9F757', 300, '2017-02-20 18:05:20', '1432968757'),
('D25E522757', 2204.16, '2017-05-26 12:59:15', '1432968757'),
('D7E54EC193', 280, '2017-01-18 14:39:42', '1484715193'),
('DA4608F808', 35.2, '2017-03-03 08:56:26', '1488505808'),
('DC7D69D717', 55, '2017-08-09 16:01:16', '1502266717'),
('DD573E0757', 2046, '2017-05-25 18:59:11', '1432968757'),
('DF0E9CB757', 170.5, '2017-07-17 13:26:46', '1432968757'),
('E917F22010', 170.5, '2016-12-13 08:35:14', '1481529010'),
('EE63D97909', 653.4, '2017-05-17 15:16:35', '1495008909'),
('EF4C787193', 20, '2017-01-18 14:18:05', '1484715193'),
('F1FF482660', 59.4, '2017-08-02 08:53:41', '1494497660'),
('FBAC569717', 20, '2017-08-09 16:30:51', '1502266717');

-- --------------------------------------------------------

--
-- Table structure for table `order_total`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;

--
-- Dumping data for table `order_total`
--

INSERT INTO `order_total` (`id`, `orderId`, `total`, `tax`, `shipping`, `grandTotal`, `dateCreated`) VALUES
(1, '1', 423, 0, 0, 423, '2017-06-29 15:28:07'),
(3, '3', 145, 14.5, 11, 170.5, '2016-12-13 08:35:14'),
(4, '4', 257, 25.7, 11, 293.7, '2016-12-13 08:36:22'),
(5, '5', 725, 72.5, 0, 797.5, '2016-12-13 08:37:45'),
(6, '6', 110, 12.1, 11, 133.1, '2016-12-13 14:41:12'),
(7, '7', 1200, 0, 0, 1200, '2016-12-13 14:43:00'),
(8, '8', 20, 0, 0, 20, '2017-01-18 14:13:11'),
(9, '9', 20, 0, 0, 20, '2017-01-18 14:17:48'),
(10, '10', 20, 0, 0, 20, '2017-01-18 14:18:05'),
(11, '11', 99, 9.9, 11, 119.9, '2017-01-18 14:19:34'),
(12, '12', 280, 0, 0, 280, '2017-01-18 14:39:42'),
(13, '13', 300, 0, 0, 300, '2017-02-20 18:05:20'),
(14, '14', 22, 2.2, 11, 35.2, '2017-03-03 08:56:26'),
(15, '15', 20, 0, 0, 20, '2017-03-03 11:51:35'),
(16, '16', 99, 9.9, 11, 119.9, '2017-03-11 00:59:48'),
(17, '17', 145, 14.5, 11, 170.5, '2017-04-28 17:46:39'),
(18, '18', 22, 2.2, 11, 35.2, '2017-05-11 16:45:18'),
(19, '19', 594, 59.4, 0, 653.4, '2017-05-17 15:16:35'),
(20, '20', 88, 8.8, 11, 107.8, '2017-05-25 18:56:14'),
(21, '21', 2046, 0, 0, 2046, '2017-05-25 18:59:11'),
(22, '22', 2046, 0, 0, 2046, '2017-05-25 19:21:28'),
(23, '23', 769, 76.9, 0, 845.9, '2017-05-25 19:25:02'),
(24, '24', 123, 0, 0, 123, '2017-05-25 19:25:02'),
(25, '25', 140, 0, 0, 140, '2017-05-25 22:44:25'),
(26, '26', 246, 24.6, 11, 281.6, '2017-05-25 22:44:25'),
(27, '27', 200, 0, 0, 200, '2017-05-25 22:44:25'),
(28, '28', 633, 63.3, 0, 696.3, '2017-05-25 22:59:30'),
(29, '29', 423, 0, 0, 423, '2017-05-25 22:59:30'),
(30, '30', 330, 0, 0, 330, '2017-05-25 22:59:30'),
(31, '31', 5, 0, 0, 5, '2017-05-25 22:59:30'),
(33, '33', 1968, 236.16, 0, 2204.16, '2017-05-26 13:05:33'),
(34, '34', 1968, 236.16, 0, 2204.16, '2017-05-26 13:12:57'),
(35, '35', 1968, 236.16, 0, 2204.16, '2017-05-26 13:11:09'),
(36, '36', 656, 78.72, 0, 734.72, '2017-05-26 13:29:57'),
(37, '37', 656, 78.72, 0, 734.72, '2017-05-26 13:26:06'),
(38, '38', 1108, 132.96, 0, 1240.96, '2017-05-26 13:46:21'),
(40, '40', 145, 14.5, 11, 170.5, '2017-05-29 18:05:48'),
(41, '41', 246, 0, 0, 246, '2017-05-29 18:07:59'),
(42, '42', 246, 0, 0, 246, '2017-05-29 18:08:19'),
(43, '43', 145, 14.5, 11, 170.5, '2017-07-17 13:26:46'),
(44, '44', 20, 0, 0, 20, '2017-07-20 03:50:16'),
(45, '45', 300, 0, 0, 300, '2017-07-20 09:47:27'),
(46, '46', 99, 9.9, 11, 119.9, '2017-07-20 10:02:53'),
(47, '47', 50, 0, 0, 50, '2017-07-20 10:02:53'),
(48, '48', 300, 0, 0, 300, '2017-07-20 10:02:53'),
(49, '49', 99, 9.9, 11, 119.9, '2017-07-26 15:15:51'),
(50, '50', 198, 19.8, 11, 228.8, '2017-08-01 17:38:01'),
(51, '51', 701, 70.1, 0, 771.1, '2017-08-01 17:57:17'),
(52, '52', 123, 0, 0, 123, '2017-08-01 17:57:17'),
(53, '53', 244, 24.4, 11, 279.4, '2017-08-02 08:36:44'),
(54, '54', 44, 4.4, 11, 59.4, '2017-08-02 08:53:41'),
(58, '58', 20, 0, 0, 20, '2017-08-09 15:56:59'),
(59, '59', 55, 0, 0, 55, '2017-08-09 16:01:16'),
(73, '73', 20, 0, 0, 20, '2017-08-09 16:30:51'),
(74, '74', 145, 14.5, 11, 170.5, '2017-08-09 16:42:05'),
(75, '75', 145, 14.5, 11, 170.5, '2017-08-09 16:42:28'),
(76, '76', 99, 9.9, 11, 119.9, '2017-08-09 16:44:44'),
(77, '77', 145, 14.5, 11, 170.5, '2017-08-09 16:45:21'),
(78, '78', 99, 9.9, 11, 119.9, '2017-08-09 16:46:35'),
(79, '79', 22, 2.2, 11, 35.2, '2017-08-09 17:00:59'),
(80, '80', 22, 2.2, 11, 35.2, '2017-08-09 17:05:59');

-- --------------------------------------------------------

--
-- Table structure for table `payment_information`
--

CREATE TABLE IF NOT EXISTS `payment_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(30) NOT NULL,
  `full_name` varchar(200) NOT NULL,
  `address` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `zip_code` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `bank_account` varchar(200) NOT NULL,
  `account_number` varchar(200) NOT NULL,
  `swift_code` varchar(200) NOT NULL,
  `bank_name` varchar(200) NOT NULL,
  `bank_country` varchar(200) NOT NULL,
  `paypal_address` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `payment_information`
--

INSERT INTO `payment_information` (`id`, `account_id`, `full_name`, `address`, `city`, `state`, `zip_code`, `country`, `bank_account`, `account_number`, `swift_code`, `bank_name`, `bank_country`, `paypal_address`) VALUES
(1, '1397811111', 'dan', '5433456', 'Bangalore', 'N/A', '4656', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(2, '1479096677', 'Hicom Piizaa', 'Address 16', 'Sydney', 'N/A', '100000', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(3, '1', 'Chris Ho', '696969696', 'Sydney', 'Sydney', '4656', 'Au', 'hicom', '79797979', '9899', 'Au Bank', 'Au Bank', 'N/A'),
(4, '1481339406', 'Pham Dan Truong', 'the address of Dan Truong', 'City', 'state', 'zip code', 'country', 'bank account', 'account number', 'swift code', 'bank name', 'bank country', 'dantruong@gmail.com'),
(5, '1481344864', 'a', 'a', 'a', 'N/A', 'a', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(6, '1481353138', 'a', 'a', 'a', 'N/A', 'a', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(7, '1481612156', 'Thomas', 'Unit 2/66, Blackburn Road, Blackburn', 'Melbourne', 'N/A', '3130', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(8, '1481615705', 'Linda', 'Unit 5/66, Blackburn Road', 'Melbourne', 'N/A', '3130', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(9, '1481616699', 'Katarina', '68 Blackburn Road', 'Melbourne', 'N/A', '3130', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(10, '1481623122', 'Linda', '68 Blackburn Road', 'Melbourne', 'N/A', '3130', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(11, '1488516592', 'Phạm Điệp', 'address', 'Bangalore', 'N/A', '10000', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(12, '1492576113', 'Troncoso ', '333', '333', 'N/A', '333', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(13, '1495775393', 'Lwifunyo Mangula', 'Dar es Salaam, Salasala', 'Dar es Salaam', 'N/A', '255', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(14, '1500488406', 'jean-philip', 'pv', 'Port-au-Prince', 'N/A', '509', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'),
(15, '1500495019', 'Carl-Hens Fievre', 'Delmas', 'Port-au-Prince', 'N/A', '3131', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A');

-- --------------------------------------------------------

--
-- Table structure for table `promotion`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `promotion`
--

INSERT INTO `promotion` (`promotion_id`, `promotion_code`, `promotion_name`, `shop_id`, `promotion_desc`, `promotion_image`, `percent_discount`, `start_date`, `end_date`, `end_time`, `status`, `lang`) VALUES
(1, 'ABCD999', 'Open', 38, 'Open promotion', '1426304455.jpg', 20, '2015-06-02', '2015-09-30', '02:45:00', 1, NULL),
(2, 'ABCD9997654', 'Open', 39, '1234', '1423295410.jpg', 10, '2015-02-07', '2015-02-28', '03:00:00', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `request`
--

CREATE TABLE IF NOT EXISTS `request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`id`, `user_id`, `created`) VALUES
(20, '1480934455', '2016-12-05 17:40:55'),
(22, '1493275818', '2017-04-27 13:50:18'),
(23, '1493385143', '2017-04-28 20:12:23');

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `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;



-- --------------------------------------------------------

--
-- Table structure for table `transaction`
--

CREATE TABLE IF NOT EXISTS `transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `shop_id` int(11) NOT NULL,
  `buyer_id` varchar(30) NOT NULL,
  `account_id` varchar(30) NOT NULL,
  `earn` double NOT NULL,
  `commission` double NOT NULL,
  `amount` double NOT NULL,
  `payment_method` int(1) NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `action` int(1) NOT NULL,
  `status` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=116 ;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `order_id`, `shop_id`, `buyer_id`, `account_id`, `earn`, `commission`, `amount`, `payment_method`, `transaction_id`, `created`, `action`, `status`) VALUES
(30, 0, 0, '0', '1397811111', 0, 0, 500, 2, 'EC-2G938940LD740794F', '2016-12-01 09:53:43', 3, 0),
(33, 0, 0, '0', '1397811111', 0, 0, 30, 4, '', '2016-12-02 17:50:05', 1, 2),
(49, 1, 40, '1481529010', '1397811111', 380.7, 42.3, 0, 2, '', '2016-12-12 16:27:01', 0, 2),
(50, 3, 38, '1481529010', '1397811111', 153.45, 17.05, 0, 2, '', '2016-12-13 08:35:14', 0, 2),
(51, 4, 38, '1481529010', '1397811111', 264.33, 29.37, 0, 2, '', '2016-12-13 08:36:22', 0, 2),
(52, 5, 38, '1481529010', '1397811111', 717.75, 79.75, 0, 2, '', '2016-12-13 08:37:45', 0, 2),
(53, 6, 38, '1481529010', '1397811111', 118.8, 13.2, 0, 2, '', '2016-12-13 08:38:24', 0, 2),
(54, 7, 40, '1481529010', '1397811111', 1080, 120, 0, 2, '', '2016-12-13 08:38:58', 0, 2),
(55, 0, 0, '0', '1481612156', 0, 0, 1000, 2, 'EC-79019939F0997425F', '2016-12-13 13:57:48', 3, 0),
(56, 0, 0, '0', '1481612156', 0, 0, 30, 4, '', '2016-12-13 14:18:48', 1, 2),
(57, 0, 0, '0', '1481615705', 0, 0, 1000, 2, 'EC-43889658UM4697219', '2016-12-13 14:57:02', 3, 0),
(58, 0, 0, '0', '1481615705', 0, 0, 30, 4, '', '2016-12-13 14:58:38', 1, 2),
(59, 0, 0, '0', '1481616699', 0, 0, 1000, 2, 'EC-7EX053289T497733A', '2016-12-13 15:14:26', 3, 0),
(60, 0, 0, '0', '1481616699', 0, 0, 30, 4, '', '2016-12-13 15:15:20', 1, 2),
(61, 0, 0, '0', '1481623122', 0, 0, 1000, 2, 'EC-5XU15995CA206914V', '2016-12-13 17:00:32', 3, 0),
(62, 0, 0, '0', '1481623122', 0, 0, 30, 4, '', '2016-12-13 17:01:28', 1, 2),
(63, 6, 38, '1481529010', '1397811111', 0, 0, 132, 5, '', '2016-12-13 17:22:09', 5, 2),
(64, 8, 51, '1484715193', '1481623122', 18, 2, 0, 2, '', '2017-01-18 14:13:12', 0, 2),
(65, 9, 51, '1484715193', '1481623122', 18, 2, 0, 2, '', '2017-01-18 14:17:48', 0, 2),
(66, 10, 51, '1484715193', '1481623122', 18, 2, 0, 2, '', '2017-01-18 14:18:05', 0, 2),
(67, 11, 38, '1484715193', '1397811111', 107.91, 11.99, 0, 2, '', '2017-01-18 14:19:34', 0, 2),
(68, 12, 50, '1484715193', '1481616699', 252, 28, 0, 2, '', '2017-01-18 14:39:42', 0, 2),
(69, 0, 0, '0', '1397811111', 0, 0, 9999999999, 2, 'EC-56W45483LG941984X', '2017-02-09 17:17:06', 3, 0),
(70, 0, 0, '0', '1397811111', 0, 0, 9999999999999, 2, 'EC-5EC74460BA7452724', '2017-02-09 17:18:06', 3, 0),
(71, 0, 0, '0', '1397811111', 0, 0, 9000000000, 2, 'EC-91022215EE6706945', '2017-02-09 17:20:33', 3, 0),
(72, 0, 0, '0', '1397811111', 0, 0, 10000, 2, 'EC-8SX76706LA2100353', '2017-02-09 17:21:57', 3, 2),
(73, 0, 0, '0', '1397811111', 0, 0, 100000, 2, 'EC-4X418587BF1226745', '2017-02-09 17:22:29', 3, 2),
(74, 0, 0, '0', '1397811111', 0, 0, 1000000, 2, 'EC-1T582465PY512742S', '2017-02-09 17:23:02', 3, 2),
(75, 0, 0, '0', '1397811111', 0, 0, 30, 4, '', '2017-02-09 18:04:21', 1, 2),
(76, 14, 38, '1488505808', '1397811111', 31.68, 3.52, 0, 2, '', '2017-03-03 08:56:26', 0, 2),
(77, 15, 51, '1488516592', '1481623122', 18, 2, 0, 2, '', '2017-03-03 11:51:35', 0, 2),
(78, 16, 38, '1432968757', '1397811111', 107.91, 11.99, 0, 2, '', '2017-03-11 00:59:49', 0, 2),
(79, 0, 0, '0', '1492576113', 0, 0, 1000, 2, 'EC-4HK27443X28039748', '2017-04-19 11:33:47', 3, 0),
(80, 0, 0, '0', '1492576113', 0, 0, 300, 4, '', '2017-04-27 12:23:27', 1, 2),
(81, 18, 38, '1488516592', '1397811111', 35.2, 0, 0, 2, '', '2017-05-11 16:45:18', 0, 2),
(82, 19, 38, '1495008909', '1397811111', 653.4, 0, 0, 2, '', '2017-05-17 15:16:35', 0, 2),
(83, 20, 38, '1432968757', '1397811111', 107.8, 0, 0, 2, '', '2017-05-25 18:56:14', 0, 2),
(84, 23, 38, '1432968757', '1397811111', 845.9, 0, 0, 2, '', '2017-05-25 19:25:02', 0, 2),
(85, 24, 40, '1432968757', '1397811111', 968.9, 0, 0, 2, '', '2017-05-25 19:25:02', 0, 2),
(86, 25, 53, '1432968757', '1397811111', 140, 0, 0, 2, '', '2017-05-25 22:44:25', 0, 2),
(87, 26, 38, '1432968757', '1397811111', 421.6, 0, 0, 2, '', '2017-05-25 22:44:25', 0, 2),
(88, 27, 51, '1432968757', '1481623122', 621.6, 0, 0, 2, '', '2017-05-25 22:44:25', 0, 2),
(89, 0, 0, '0', '1495775393', 0, 0, 200, 2, 'EC-0X214689HT606733M', '2017-05-26 12:13:12', 3, 0),
(90, 0, 0, '0', '1495775393', 0, 0, 50, 4, '', '2017-05-26 12:23:18', 1, 2),
(91, 32, 57, '1432968757', '1495775393', 4686.08, 200, 0, 2, '', '2017-05-26 12:52:33', 0, 1),
(92, 0, 0, '0', '1397811111', 0, 0, 50, 4, '', '2017-05-26 15:17:13', 1, 2),
(100, 40, 38, '1432968757', '1397811111', 170.5, 0, 0, 2, '', '2017-05-29 18:05:48', 0, 2),
(101, 0, 0, '0', '1397811111', 0, 0, 50, 4, '', '2017-06-15 15:58:00', 1, 2),
(102, 0, 0, '0', '1397811111', 0, 0, 50, 4, '', '2017-07-16 11:27:25', 1, 2),
(103, 43, 38, '1432968757', '1397811111', 170.5, 0, 0, 2, '', '2017-07-17 13:26:46', 0, 2),
(104, 44, 51, 'admin', '1481623122', 20, 0, 0, 2, '', '2017-07-20 03:50:16', 0, 2),
(105, 45, 40, '1500518661', '1397811111', 300, 0, 0, 2, '', '2017-07-20 09:47:27', 0, 2),
(106, 46, 38, '1500519473', '1397811111', 119.9, 0, 0, 2, '', '2017-07-20 10:02:53', 0, 2),
(107, 47, 52, '1500519473', '1397811111', 169.9, 0, 0, 2, '', '2017-07-20 10:02:53', 0, 2),
(108, 48, 40, '1500519473', '1397811111', 469.9, 0, 0, 2, '', '2017-07-20 10:02:53', 0, 2),
(109, 50, 38, '1501583711', '1397811111', 228.8, 0, 0, 2, '', '2017-08-01 17:38:01', 0, 2),
(110, 51, 38, '1501583711', '1397811111', 771.1, 0, 0, 2, '', '2017-08-01 17:57:17', 0, 2),
(111, 52, 40, '1501583711', '1397811111', 894.1, 0, 0, 2, '', '2017-08-01 17:57:17', 0, 2),
(112, 0, 0, '0', '1397811111', 0, 0, 50, 4, '', '2017-08-06 21:30:45', 1, 2),
(113, 73, 51, '1502266717', '1481623122', 20, 0, 0, 2, '', '2017-08-09 16:30:51', 0, 2),
(114, 77, 38, '1432968757', '1397811111', 170.5, 0, 0, 2, '', '2017-08-09 16:45:21', 0, 2),
(115, 80, 38, '1502266717', '1397811111', 35.2, 0, 0, 2, '', '2017-08-09 17:05:59', 0, 2);

-- --------------------------------------------------------

--
-- Table structure for table `user_shop`
--

CREATE TABLE IF NOT EXISTS `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  DEFAULT CHARSET=latin1 AUTO_INCREMENT=72 ;

--
-- Dumping data for table `user_shop`
--

INSERT INTO `user_shop` (`id`, `shopId`, `accountId`, `order_count`) VALUES
(5, 38, '1432968757', 37),
(6, 41, '1414741099', 7),
(7, 40, '1414741099', 8),
(15, 41, '1397811111', 1),
(16, 40, '1397811111', 1),
(37, 39, '1432968757', 1),
(44, 48, '1432968757', 3),
(45, 40, '1481529010', 2),
(46, 38, '1414741099', 1),
(47, 38, '1481529010', 4),
(48, 51, '1484715193', 3),
(49, 38, '1484715193', 1),
(50, 50, '1484715193', 1),
(51, 40, '1432968757', 7),
(52, 38, '1488505808', 1),
(53, 51, '1488516592', 1),
(54, 38, '1488516592', 1),
(55, 38, '1495008909', 1),
(56, 53, '1432968757', 1),
(57, 51, '1432968757', 1),
(58, 55, '1432968757', 1),
(59, 54, '1432968757', 1),
(60, 57, '1432968757', 8),
(61, 51, 'admin', 1),
(62, 40, '1500518661', 1),
(63, 38, '1500519473', 1),
(64, 52, '1500519473', 1),
(65, 40, '1500519473', 1),
(66, 38, '1501583711', 3),
(67, 40, '1501583711', 1),
(68, 38, '1494497660', 1),
(69, 38, '1502266717', 18),
(70, 51, '1502266717', 2),
(71, 55, '1502266717', 1);

