-- phpMyAdmin SQL Dump
-- version 4.4.15.10
-- https://www.phpmyadmin.net
--
-- Host: 192.168.2.103:3306
-- Generation Time: Aug 12, 2020 at 09:44 AM
-- Server version: 5.7.28
-- PHP Version: 7.2.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `new_test_dc`
--

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

--
-- Table structure for table `daily_prodcut_update`
--

CREATE TABLE IF NOT EXISTS `daily_prodcut_update` (
  `id` int(11) NOT NULL,
  `create_on` datetime NOT NULL,
  `create_by` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `daily_prodcut_update`
--

INSERT INTO `daily_prodcut_update` (`id`, `create_on`, `create_by`) VALUES
(1, '2019-09-18 09:57:48', 1),
(2, '2019-11-26 11:17:26', 1),
(3, '2019-11-29 06:27:29', 1),
(4, '2019-12-18 10:31:37', 1),
(5, '2020-02-06 11:11:13', 1),
(6, '2020-02-06 11:11:29', 1),
(7, '2020-02-14 11:47:09', 1),
(8, '2020-02-14 11:47:44', 1),
(9, '2020-02-14 01:00:44', 1),
(10, '2020-02-14 01:04:37', 1),
(11, '2020-02-14 01:05:30', 1),
(12, '2020-02-14 03:18:43', 1),
(13, '2020-02-14 03:38:33', 1),
(14, '2020-02-16 12:50:48', 1),
(15, '2020-02-16 12:50:54', 1),
(16, '2020-02-16 12:51:23', 1),
(17, '2020-02-16 01:09:16', 1),
(18, '2020-02-16 01:10:20', 1),
(19, '2020-02-16 01:13:09', 1),
(20, '2020-02-16 01:13:35', 1),
(21, '2020-02-16 05:27:00', 1),
(22, '2020-02-16 05:27:48', 1),
(23, '2020-02-16 05:27:48', 1),
(24, '2020-02-16 05:27:49', 1),
(25, '2020-02-16 05:27:53', 1),
(26, '2020-02-16 05:31:05', 1),
(27, '2020-02-17 08:38:06', 1),
(28, '2020-02-17 03:24:50', 1),
(29, '2020-02-18 06:21:15', 1),
(30, '2020-02-19 03:47:04', 181),
(31, '2020-02-19 03:47:10', 181),
(32, '2020-02-19 03:47:16', 181),
(33, '2020-02-19 03:47:26', 181),
(34, '2020-02-19 03:47:40', 181),
(35, '2020-02-19 03:58:13', 181),
(36, '2020-02-19 03:58:44', 181),
(37, '2020-02-19 09:02:52', 181),
(38, '2020-02-20 07:15:17', 181),
(39, '2020-02-20 07:16:52', 181),
(40, '2020-02-20 10:17:36', 181),
(41, '2020-02-20 10:30:05', 181),
(42, '2020-02-20 10:31:24', 181),
(43, '2020-02-20 10:32:27', 181),
(44, '2020-02-20 10:32:52', 181),
(45, '2020-02-20 11:09:59', 181),
(46, '2020-02-20 11:11:51', 181),
(47, '2020-02-20 11:19:53', 181),
(48, '2020-02-20 11:20:23', 181),
(49, '2020-02-20 11:29:01', 181),
(50, '2020-02-20 11:56:55', 181),
(51, '2020-02-20 12:04:23', 181),
(52, '2020-02-20 12:08:44', 181),
(53, '2020-02-20 12:14:36', 181),
(54, '2020-02-20 12:23:17', 181),
(55, '2020-02-20 12:54:28', 181),
(56, '2020-02-20 12:54:41', 181),
(57, '2020-02-20 04:07:46', 181),
(58, '2020-02-20 04:12:04', 181),
(59, '2020-02-20 05:01:39', 181),
(60, '2020-02-21 06:40:30', 181),
(61, '2020-02-21 06:41:29', 181),
(62, '2020-02-21 07:14:36', 181),
(63, '2020-02-21 07:33:35', 181),
(64, '2020-02-21 09:45:21', 181),
(65, '2020-02-21 09:47:28', 181),
(66, '2020-02-21 09:50:13', 181),
(67, '2020-02-21 11:30:01', 181),
(68, '2020-02-21 11:48:34', 181),
(69, '2020-02-21 11:52:07', 181),
(70, '2020-02-21 12:38:52', 181),
(71, '2020-02-21 12:53:28', 181),
(72, '2020-02-21 01:04:21', 181),
(73, '2020-02-21 01:07:55', 181),
(74, '2020-02-21 01:57:59', 181),
(75, '2020-02-21 02:01:02', 181),
(76, '2020-02-21 04:34:42', 181),
(77, '2020-02-21 04:34:55', 181),
(78, '2020-02-21 04:35:04', 181),
(79, '2020-02-21 04:35:27', 181),
(80, '2020-02-21 04:36:27', 181),
(81, '2020-02-21 04:36:49', 181),
(82, '2020-02-24 06:58:53', 181),
(83, '2020-02-24 07:03:13', 181),
(84, '2020-02-24 07:03:26', 181),
(85, '2020-02-24 07:03:45', 181),
(86, '2020-02-24 07:04:58', 181),
(87, '2020-02-24 07:05:35', 181),
(88, '2020-02-24 07:06:27', 181),
(89, '2020-02-24 07:32:07', 181),
(90, '2020-02-24 10:14:56', 181),
(91, '2020-02-24 10:15:06', 181),
(92, '2020-02-24 12:14:29', 181),
(93, '2020-02-24 12:29:11', 181),
(94, '2020-02-24 12:38:16', 181),
(95, '2020-02-24 12:52:38', 181),
(96, '2020-02-24 12:54:03', 181),
(97, '2020-02-24 01:07:03', 181),
(98, '2020-02-24 01:08:09', 181),
(99, '2020-02-24 02:54:14', 181),
(100, '2020-02-25 07:11:40', 181),
(101, '2020-02-25 09:42:37', 181),
(102, '2020-02-25 10:09:58', 181),
(103, '2020-02-25 12:10:02', 181),
(104, '2020-02-25 12:10:22', 181),
(105, '2020-02-25 12:14:18', 181),
(106, '2020-02-25 12:16:10', 181),
(107, '2020-02-25 12:16:23', 181),
(108, '2020-02-25 12:23:20', 181),
(109, '2020-02-25 12:24:13', 181),
(110, '2020-02-25 12:30:00', 181),
(111, '2020-02-25 01:11:05', 181),
(112, '2020-02-25 01:29:18', 181),
(113, '2020-02-25 02:00:17', 181),
(114, '2020-02-25 04:48:48', 181),
(115, '2020-02-26 06:43:04', 181),
(116, '2020-02-26 12:21:29', 181),
(117, '2020-02-26 12:22:39', 181),
(118, '2020-02-26 12:28:30', 181),
(119, '2020-02-26 12:30:57', 181),
(120, '2020-02-26 01:20:11', 181),
(121, '2020-02-26 01:31:16', 181),
(122, '2020-02-26 01:31:34', 181),
(123, '2020-02-26 02:27:20', 181),
(124, '2020-02-26 04:32:35', 181),
(125, '2020-02-26 04:32:43', 181),
(126, '2020-02-27 06:39:10', 181),
(127, '2020-02-27 06:39:16', 181),
(128, '2020-02-27 06:39:21', 181),
(129, '2020-02-27 06:39:50', 181),
(130, '2020-02-27 06:41:00', 181),
(131, '2020-02-27 06:44:46', 181),
(132, '2020-02-27 06:45:14', 181),
(133, '2020-02-27 09:40:52', 181),
(134, '2020-02-27 09:47:42', 181),
(135, '2020-02-27 09:47:55', 181),
(136, '2020-02-27 09:48:14', 181),
(137, '2020-02-27 09:48:18', 181),
(138, '2020-02-27 12:12:54', 181),
(139, '2020-02-27 12:20:15', 181),
(140, '2020-02-27 12:22:39', 181),
(141, '2020-02-27 12:22:49', 181),
(142, '2020-02-27 12:23:06', 181),
(143, '2020-02-27 12:29:04', 181),
(144, '2020-02-27 12:29:12', 181),
(145, '2020-02-27 01:47:45', 181),
(146, '2020-02-27 02:03:05', 181),
(147, '2020-02-27 02:21:39', 181),
(148, '2020-02-27 02:22:45', 181),
(149, '2020-02-27 04:01:34', 181),
(150, '2020-02-27 04:02:19', 181),
(151, '2020-02-27 04:34:23', 181),
(152, '2020-02-28 07:04:54', 181),
(153, '2020-02-28 07:05:56', 181),
(154, '2020-02-28 07:11:19', 181),
(155, '2020-02-28 09:57:44', 181),
(156, '2020-02-28 11:58:34', 181),
(157, '2020-02-28 12:22:45', 181),
(158, '2020-02-28 12:35:13', 181),
(159, '2020-02-28 12:45:04', 181),
(160, '2020-02-28 12:45:11', 181),
(161, '2020-02-28 12:45:33', 181),
(162, '2020-02-28 12:49:06', 181),
(163, '2020-02-28 12:49:29', 181),
(164, '2020-02-28 04:38:17', 181),
(165, '2020-02-28 04:39:27', 181),
(166, '2020-02-28 04:49:13', 181),
(167, '2020-03-02 07:08:22', 181),
(168, '2020-03-02 07:16:28', 181),
(169, '2020-03-02 08:41:13', 181),
(170, '2020-03-02 10:34:36', 181),
(171, '2020-03-02 11:27:13', 181),
(172, '2020-03-02 11:27:29', 181),
(173, '2020-03-02 11:29:45', 181),
(174, '2020-03-02 11:30:13', 181),
(175, '2020-03-02 11:31:17', 181),
(176, '2020-03-02 11:31:31', 181),
(177, '2020-03-02 11:37:17', 181),
(178, '2020-03-02 11:37:23', 181),
(179, '2020-03-02 11:37:29', 181),
(180, '2020-03-02 01:01:32', 181),
(181, '2020-03-02 02:23:13', 181),
(182, '2020-03-02 02:24:54', 181),
(183, '2020-03-02 02:26:02', 181),
(184, '2020-03-02 02:42:52', 181),
(185, '2020-03-03 06:56:55', 181),
(186, '2020-03-03 12:01:33', 181),
(187, '2020-03-03 12:01:50', 181),
(188, '2020-03-03 12:03:11', 181),
(189, '2020-03-03 12:07:50', 181),
(190, '2020-03-03 12:17:39', 181),
(191, '2020-03-03 01:28:36', 181),
(192, '2020-03-03 03:30:54', 181),
(193, '2020-03-03 03:33:57', 181),
(194, '2020-03-03 04:12:27', 181),
(195, '2020-03-03 04:12:46', 181),
(196, '2020-03-04 06:49:51', 181),
(197, '2020-03-04 12:48:46', 181),
(198, '2020-03-04 12:53:02', 181),
(199, '2020-03-04 12:54:12', 181),
(200, '2020-03-04 12:57:34', 181),
(201, '2020-03-04 12:58:29', 181),
(202, '2020-03-04 01:16:27', 181),
(203, '2020-03-04 01:17:05', 181),
(204, '2020-03-04 01:49:31', 181),
(205, '2020-03-04 02:04:12', 181),
(206, '2020-03-04 02:09:05', 181),
(207, '2020-03-04 04:12:37', 181),
(208, '2020-03-04 04:12:44', 181),
(209, '2020-03-04 04:12:52', 181),
(210, '2020-03-04 04:13:15', 181),
(211, '2020-03-05 06:58:09', 181),
(212, '2020-03-05 02:08:22', 181),
(213, '2020-03-05 02:13:19', 181),
(214, '2020-03-06 06:33:37', 181),
(215, '2020-03-06 06:33:41', 181),
(216, '2020-03-06 06:33:47', 181),
(217, '2020-03-06 06:35:52', 181),
(218, '2020-03-06 06:43:29', 181),
(219, '2020-03-06 06:48:38', 181),
(220, '2020-03-06 07:50:10', 181),
(221, '2020-03-06 07:52:06', 181),
(222, '2020-03-06 09:43:32', 181),
(223, '2020-03-06 09:43:53', 181),
(224, '2020-03-06 01:00:56', 181),
(225, '2020-03-06 01:01:02', 181),
(226, '2020-03-06 01:02:55', 181),
(227, '2020-03-06 01:04:05', 181),
(228, '2020-03-06 01:08:13', 181),
(229, '2020-03-06 01:08:21', 181),
(230, '2020-03-06 01:10:35', 181),
(231, '2020-03-06 01:14:40', 181),
(232, '2020-03-06 02:07:53', 181),
(233, '2020-03-06 02:11:19', 181),
(234, '2020-03-06 02:12:06', 181),
(235, '2020-03-06 03:41:03', 181),
(236, '2020-03-10 07:14:46', 181),
(237, '2020-03-10 07:15:04', 181),
(238, '2020-03-10 11:45:02', 181),
(239, '2020-03-10 11:45:10', 181),
(240, '2020-03-10 11:45:23', 181),
(241, '2020-03-10 11:45:37', 181),
(242, '2020-03-10 11:46:07', 181),
(243, '2020-03-10 11:50:51', 181),
(244, '2020-03-10 12:01:33', 181),
(245, '2020-03-10 12:01:52', 181),
(246, '2020-03-10 12:01:58', 181),
(247, '2020-03-10 12:16:33', 181),
(248, '2020-03-10 01:16:02', 181),
(249, '2020-03-10 01:17:25', 181),
(250, '2020-03-10 01:17:33', 181),
(251, '2020-03-10 01:27:58', 181),
(252, '2020-03-10 02:18:24', 181),
(253, '2020-03-10 02:18:34', 181),
(254, '2020-03-10 02:19:09', 181),
(255, '2020-03-11 07:15:26', 181),
(256, '2020-03-11 09:11:54', 181),
(257, '2020-03-11 12:32:31', 181),
(258, '2020-03-11 12:33:59', 181),
(259, '2020-03-11 01:44:42', 181),
(260, '2020-03-11 02:05:50', 181),
(261, '2020-03-12 07:13:02', 181),
(262, '2020-03-12 10:51:33', 181),
(263, '2020-03-12 11:08:54', 181),
(264, '2020-03-12 12:02:38', 181),
(265, '2020-03-12 12:05:13', 181),
(266, '2020-03-12 12:21:59', 181),
(267, '2020-03-12 12:22:34', 181),
(268, '2020-03-12 12:22:42', 181),
(269, '2020-03-12 12:25:16', 181),
(270, '2020-03-12 12:38:56', 181),
(271, '2020-03-12 12:43:42', 181),
(272, '2020-03-12 01:16:44', 181),
(273, '2020-03-12 01:23:17', 181),
(274, '2020-03-12 03:53:45', 181),
(275, '2020-03-12 03:53:53', 181),
(276, '2020-03-13 07:18:46', 181),
(277, '2020-03-13 07:18:58', 181),
(278, '2020-03-13 07:19:12', 181),
(279, '2020-03-13 07:19:38', 181),
(280, '2020-03-13 07:19:59', 181),
(281, '2020-03-13 07:20:30', 181),
(282, '2020-03-13 10:26:31', 181),
(283, '2020-03-13 12:09:01', 181),
(284, '2020-03-13 12:10:56', 181),
(285, '2020-03-13 12:17:14', 181),
(286, '2020-03-13 12:21:22', 181),
(287, '2020-03-13 12:40:07', 181),
(288, '2020-03-13 12:42:12', 181),
(289, '2020-03-13 01:20:31', 181),
(290, '2020-03-13 02:28:02', 181),
(291, '2020-03-13 02:45:29', 181),
(292, '2020-03-13 03:55:00', 181),
(293, '2020-03-13 04:01:16', 181);

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

--
-- Table structure for table `discount`
--

CREATE TABLE IF NOT EXISTS `discount` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `activate_on` datetime DEFAULT NULL,
  `deactivate_on` datetime DEFAULT NULL,
  `discount` float NOT NULL,
  `pay_type_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `discount`
--

INSERT INTO `discount` (`id`, `product_id`, `status`, `activate_on`, `deactivate_on`, `discount`, `pay_type_id`) VALUES
(15, 1, 1, '2019-09-26 10:59:57', '2019-09-26 10:59:57', 13, 1),
(16, 2, 1, '2019-09-26 10:59:57', '2019-09-26 10:59:57', 13, 1),
(17, 3, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(18, 4, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(19, 5, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(20, 6, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(21, 7, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(22, 8, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(23, 9, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(24, 10, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(25, 11, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(26, 12, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(27, 13, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(28, 14, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(29, 15, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(30, 16, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(31, 17, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(32, 18, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(33, 19, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(34, 20, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(35, 21, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(36, 22, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(37, 23, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(38, 24, 1, '2019-09-26 10:59:58', '2019-09-26 10:59:58', 13, 1),
(39, 25, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(40, 26, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(41, 27, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(42, 28, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(43, 29, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(44, 30, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(45, 31, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(46, 32, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(47, 33, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(48, 34, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(49, 35, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(50, 36, 1, '2019-09-26 10:59:59', '2019-09-26 10:59:59', 13, 1),
(51, 1, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(52, 2, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(53, 3, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(54, 4, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(55, 5, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(57, 7, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(58, 8, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(59, 9, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(60, 10, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(61, 11, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(62, 12, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(63, 13, 1, '2019-09-26 11:01:28', '2019-09-26 11:01:28', 10, 2),
(64, 14, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(65, 15, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(66, 16, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(67, 17, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(68, 18, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(69, 19, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(70, 20, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(71, 21, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(72, 22, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(73, 23, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(74, 24, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(75, 25, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(76, 26, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(77, 27, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(78, 28, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(79, 29, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(80, 30, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(81, 31, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(82, 32, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(83, 33, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(84, 34, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(85, 35, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(86, 36, 1, '2019-09-26 11:01:29', '2019-09-26 11:01:29', 10, 2),
(87, 37, 1, '2019-12-04 09:45:40', '2019-12-04 09:45:40', 13, 1),
(88, 37, 1, '2019-12-04 09:45:40', '2019-12-04 09:45:40', 10, 2),
(89, 38, 1, '2019-12-04 10:27:34', '2019-12-04 10:27:34', 13, 1),
(90, 38, 1, '2019-12-04 10:27:34', '2019-12-04 10:27:34', 10, 2),
(91, 39, 1, '2019-12-12 04:20:44', '2019-12-12 04:20:44', 13, 1),
(92, 39, 1, '2019-12-12 04:20:44', '2019-12-12 04:20:44', 10, 2),
(93, 40, 1, '2020-02-07 12:01:57', '2020-02-07 12:01:57', 13, 1),
(94, 40, 1, '2020-02-07 12:01:57', '2020-02-07 12:01:57', 10, 2),
(95, 41, 1, '2020-02-07 11:45:08', '2020-02-07 11:45:08', 13, 1),
(96, 41, 1, '2020-02-07 11:45:08', '2020-02-07 11:45:08', 10, 2),
(97, 42, 1, '2020-02-20 07:26:36', '2020-02-20 07:26:36', 13, 1),
(98, 42, 1, '2020-02-20 07:26:36', '2020-02-20 07:26:36', 10, 2),
(99, 43, 1, '2020-02-20 07:27:23', '2020-02-20 07:27:23', 13, 1),
(100, 43, 1, '2020-02-20 07:27:23', '2020-02-20 07:27:23', 10, 2),
(101, 44, 1, '2020-02-20 07:31:01', '2020-02-20 07:31:01', 13, 1),
(102, 44, 1, '2020-02-20 07:31:01', '2020-02-20 07:31:01', 10, 2),
(103, 45, 1, '2020-02-20 07:37:19', '2020-02-20 07:37:19', 13, 1),
(104, 45, 1, '2020-02-20 07:37:19', '2020-02-20 07:37:19', 10, 2),
(105, 46, 1, '2020-02-20 07:39:07', '2020-02-20 07:39:07', 13, 1),
(106, 46, 1, '2020-02-20 07:39:07', '2020-02-20 07:39:07', 10, 2),
(107, 47, 1, '2020-02-20 07:40:43', '2020-02-20 07:40:43', 13, 1),
(108, 47, 1, '2020-02-20 07:40:43', '2020-02-20 07:40:43', 10, 2),
(109, 48, 1, '2020-02-20 07:42:07', '2020-02-20 07:42:07', 13, 1),
(110, 48, 1, '2020-02-20 07:42:07', '2020-02-20 07:42:07', 10, 2),
(111, 49, 1, '2020-02-20 07:43:27', '2020-02-20 07:43:27', 13, 1),
(112, 49, 1, '2020-02-20 07:43:27', '2020-02-20 07:43:27', 10, 2),
(113, 50, 1, '2020-02-20 07:46:16', '2020-02-20 07:46:16', 13, 1),
(114, 50, 1, '2020-02-20 07:46:16', '2020-02-20 07:46:16', 10, 2),
(115, 51, 1, '2020-02-20 07:47:19', '2020-02-20 07:47:19', 13, 1),
(116, 51, 1, '2020-02-20 07:47:19', '2020-02-20 07:47:19', 10, 2),
(117, 52, 1, '2020-02-20 07:48:07', '2020-02-20 07:48:07', 13, 1),
(118, 52, 1, '2020-02-20 07:48:07', '2020-02-20 07:48:07', 10, 2),
(119, 53, 1, '2020-02-20 07:49:15', '2020-02-20 07:49:15', 13, 1),
(120, 53, 1, '2020-02-20 07:49:15', '2020-02-20 07:49:15', 10, 2),
(121, 54, 1, '2020-02-20 07:50:04', '2020-02-20 07:50:04', 13, 1),
(122, 54, 1, '2020-02-20 07:50:04', '2020-02-20 07:50:04', 10, 2),
(123, 55, 1, '2020-02-20 07:52:56', '2020-02-20 07:52:56', 13, 1),
(124, 55, 1, '2020-02-20 07:52:56', '2020-02-20 07:52:56', 10, 2),
(125, 56, 1, '2020-02-20 07:53:53', '2020-02-20 07:53:53', 13, 1),
(126, 56, 1, '2020-02-20 07:53:53', '2020-02-20 07:53:53', 10, 2),
(127, 57, 1, '2020-02-20 07:54:43', '2020-02-20 07:54:43', 13, 1),
(128, 57, 1, '2020-02-20 07:54:43', '2020-02-20 07:54:43', 10, 2),
(129, 58, 1, '2020-02-20 07:55:24', '2020-02-20 07:55:24', 13, 1),
(130, 58, 1, '2020-02-20 07:55:24', '2020-02-20 07:55:24', 10, 2),
(131, 59, 1, '2020-02-20 07:56:06', '2020-02-20 07:56:06', 13, 1),
(132, 59, 1, '2020-02-20 07:56:06', '2020-02-20 07:56:06', 10, 2),
(133, 60, 1, '2020-02-20 08:02:42', '2020-02-20 08:02:42', 13, 1),
(134, 60, 1, '2020-02-20 08:02:42', '2020-02-20 08:02:42', 10, 2),
(135, 61, 1, '2020-03-04 01:01:26', '2020-03-04 01:01:26', 13, 1),
(136, 61, 1, '2020-03-04 01:01:26', '2020-03-04 01:01:26', 10, 2),
(152, 6, 1, '2019-09-26 11:01:28', '2022-09-26 11:01:28', 100, 2);

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

--
-- Table structure for table `favorite_product`
--

CREATE TABLE IF NOT EXISTS `favorite_product` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `favorite_product`
--

INSERT INTO `favorite_product` (`id`, `product_id`, `created_by`, `created_on`, `status`) VALUES
(26, 30, 1, '2020-02-20 08:04:27', 0),
(27, 59, 181, '2020-02-21 12:36:23', 0),
(28, 6, 181, '2020-02-25 07:11:55', 0),
(29, 6, 181, '2020-03-03 07:05:02', 0),
(30, 7, 181, '2020-03-06 06:38:42', 0),
(31, 6, 181, '2020-03-06 06:38:45', 0),
(32, 31, 181, '2020-03-06 06:39:05', 0);

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

--
-- Table structure for table `main_category`
--

CREATE TABLE IF NOT EXISTS `main_category` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `rating` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `image_path` varchar(250) NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `main_category`
--

INSERT INTO `main_category` (`id`, `name`, `rating`, `status`, `image_path`, `created_on`, `created_by`) VALUES
(1, 'Dishes', 4, 1, '', '2019-05-28 10:00:00', 0),
(3, 'Item ', 2, 1, '', '2019-06-17 00:00:00', 1),
(6, 'Piece ', 2, 1, '', '2019-06-17 00:00:00', 1),
(7, 'Glass', 1, 1, '', '2019-06-17 00:00:00', 1),
(8, 'Pie ', 1, 1, '', '2019-06-17 00:00:00', 1);

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

--
-- Table structure for table `master_menu`
--

CREATE TABLE IF NOT EXISTS `master_menu` (
  `id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `master_menu`
--

INSERT INTO `master_menu` (`id`, `name`, `created_by`, `created_on`, `status`) VALUES
(1, 'Sunday', 1, '2019-05-28 10:00:00', 1),
(2, 'Monday', 1, '2019-06-17 00:00:00', 1),
(3, 'Tuesday', 1, '2019-06-17 00:00:00', 1),
(4, 'Wednesday', 1, '2019-06-17 00:00:00', 1),
(5, 'Thursday', 1, '2019-06-17 00:00:00', 1),
(6, 'Friday', 1, '2019-06-17 00:00:00', 1),
(7, 'Saturday', 1, '2019-06-17 00:00:00', 1),
(8, 'General ', 1, '2019-06-17 00:00:00', 1);

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

--
-- Table structure for table `menu_type`
--

CREATE TABLE IF NOT EXISTS `menu_type` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `master_menu_id` int(11) NOT NULL,
  `image_path` varchar(250) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menu_type`
--

INSERT INTO `menu_type` (`id`, `name`, `description`, `master_menu_id`, `image_path`) VALUES
(10, 'Snacks Items ', 'Snacks Items ', 1, NULL),
(11, 'Sweets & Desserts', 'Sweet/ Desserts items ', 1, NULL),
(12, 'Juices & Drinks  ', 'Fruit Juices & Drinks  ', 1, NULL),
(13, 'Cakes', 'Cakes', 8, NULL),
(14, 'Lunch', 'Lunch', 8, NULL);

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

--
-- Table structure for table `notification`
--

CREATE TABLE IF NOT EXISTS `notification` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `approved_on` datetime DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `each_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order`
--

CREATE TABLE IF NOT EXISTS `order` (
  `id` int(11) NOT NULL,
  `refference_id` varchar(150) NOT NULL,
  `number_of_items` int(11) NOT NULL,
  `total_amount` decimal(9,2) NOT NULL,
  `status` int(11) NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `pay_type_id` int(11) DEFAULT NULL,
  `order_type` int(11) NOT NULL,
  `order_option_id` int(11) NOT NULL,
  `full_amount` decimal(9,2) DEFAULT NULL,
  `print_status` int(11) NOT NULL DEFAULT '0',
  `customer_req` text,
  `view_status` int(11) NOT NULL DEFAULT '0',
  `discount` float DEFAULT NULL,
  `pre_order_status` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_feedback`
--

CREATE TABLE IF NOT EXISTS `order_feedback` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `feedback` varchar(500) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_file`
--

CREATE TABLE IF NOT EXISTS `order_file` (
  `id` int(11) NOT NULL,
  `image_path` varchar(300) NOT NULL,
  `order_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `vendor_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_item`
--

CREATE TABLE IF NOT EXISTS `order_item` (
  `id` int(11) NOT NULL,
  `unit_price` decimal(9,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL,
  `vendor_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_option`
--

CREATE TABLE IF NOT EXISTS `order_option` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_option`
--

INSERT INTO `order_option` (`id`, `name`, `status`) VALUES
(1, 'Web', 1),
(2, 'Mobile App', 1),
(3, 'Pos', 1),
(4, 'Kiosk', 1);

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

--
-- Table structure for table `order_serial`
--

CREATE TABLE IF NOT EXISTS `order_serial` (
  `id` int(11) NOT NULL,
  `serial_num` int(11) NOT NULL,
  `order_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3492 DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_type`
--

CREATE TABLE IF NOT EXISTS `order_type` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_type`
--

INSERT INTO `order_type` (`id`, `name`, `description`) VALUES
(1, 'Take Away', 'Take Away'),
(2, 'Dine In', 'Dine In');

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

--
-- Table structure for table `pay_types`
--

CREATE TABLE IF NOT EXISTS `pay_types` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `status` int(11) NOT NULL,
  `image_path` varchar(300) NOT NULL,
  `discount` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pay_types`
--

INSERT INTO `pay_types` (`id`, `name`, `status`, `image_path`, `discount`) VALUES
(1, 'eZ Cash', 1, '/themeassets/images/paytype/ezcash.png', 0),
(2, 'Genie', 1, '/themeassets/images/paytype/genie.png', 0),
(3, 'Cash', 0, '/themeassets/images/paytype/cash.png', 0),
(4, 'Card', 1, '/themeassets/images/paytype/card.png', 0);

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

--
-- Table structure for table `pre_order`
--

CREATE TABLE IF NOT EXISTS `pre_order` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `description` text NOT NULL,
  `time` varchar(250) NOT NULL,
  `pre_order_category_id` int(11) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `price_change_notice`
--

CREATE TABLE IF NOT EXISTS `price_change_notice` (
  `id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `description` text,
  `product_id` int(11) NOT NULL,
  `price_list_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `price_list`
--

CREATE TABLE IF NOT EXISTS `price_list` (
  `id` int(11) NOT NULL,
  `description` varchar(1024) NOT NULL,
  `is_active` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `selling_price` decimal(9,2) NOT NULL,
  `buying_price` decimal(9,2) NOT NULL,
  `created_date` datetime NOT NULL,
  `updated_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `available_quantity` int(11) NOT NULL,
  `rating` float NOT NULL,
  `status` int(11) NOT NULL,
  `image_path` varchar(250) DEFAULT NULL,
  `details_image_path` varchar(250) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `main_category_id` int(11) NOT NULL,
  `munu_type_id` int(10) DEFAULT NULL,
  `uom_id` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sub_category`
--

CREATE TABLE IF NOT EXISTS `sub_category` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `rating` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `image_path` varchar(250) NOT NULL,
  `created_on` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `main_category_id` int(11) NOT NULL,
  `menu_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_category`
--

INSERT INTO `sub_category` (`id`, `name`, `rating`, `status`, `image_path`, `created_on`, `created_by`, `main_category_id`, `menu_type_id`) VALUES
(30, 'Sandwiches ', 1, 1, 'file', '2019-05-27 00:00:00', 112, 1, 10),
(31, 'Snacks - Rolls', 1, 1, 'file', '2019-05-27 00:00:00', 112, 1, 10),
(32, 'Pie ', 1, 1, 'file', '2019-05-27 00:00:00', 112, 8, 10),
(33, 'Snacks - Samosa ', 1, 1, 'f', '2019-05-27 00:00:00', 112, 1, 10),
(34, 'Snacks - Pastry ', 1, 1, 'file', '2019-05-27 00:00:00', 112, 1, 10),
(35, 'Sweet', 1, 1, 'file', '2019-05-27 00:00:00', 112, 3, 11),
(36, 'Fruit Juices', 1, 1, 'file', '2019-05-27 00:00:00', 112, 7, 12),
(37, ' Drinks', 1, 1, 'file', '2019-05-27 00:00:00', 112, 7, 12);

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

--
-- Table structure for table `uom`
--

CREATE TABLE IF NOT EXISTS `uom` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uom`
--

INSERT INTO `uom` (`id`, `name`, `description`) VALUES
(1, 'General', 'General');

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

--
-- Table structure for table `update_prodcut`
--

CREATE TABLE IF NOT EXISTS `update_prodcut` (
  `id` int(11) NOT NULL,
  `daily_prodcut_update_id` int(11) NOT NULL,
  `prodcut_id` int(11) NOT NULL,
  `product_count` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `daily_prodcut_update`
--
ALTER TABLE `daily_prodcut_update`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `discount`
--
ALTER TABLE `discount`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `pay_type_id` (`pay_type_id`);

--
-- Indexes for table `favorite_product`
--
ALTER TABLE `favorite_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `main_category`
--
ALTER TABLE `main_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `master_menu`
--
ALTER TABLE `master_menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu_type`
--
ALTER TABLE `menu_type`
  ADD PRIMARY KEY (`id`),
  ADD KEY `master_menu_id` (`master_menu_id`);

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_type_id` (`pay_type_id`),
  ADD KEY `order_type` (`order_type`),
  ADD KEY `order_option_id` (`order_option_id`);

--
-- Indexes for table `order_feedback`
--
ALTER TABLE `order_feedback`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_file`
--
ALTER TABLE `order_file`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_item`
--
ALTER TABLE `order_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `order_option`
--
ALTER TABLE `order_option`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_serial`
--
ALTER TABLE `order_serial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_type`
--
ALTER TABLE `order_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pay_types`
--
ALTER TABLE `pay_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pre_order`
--
ALTER TABLE `pre_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`);

--
-- Indexes for table `price_change_notice`
--
ALTER TABLE `price_change_notice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `price_list_id` (`price_list_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `price_list`
--
ALTER TABLE `price_list`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `main_category_id` (`main_category_id`),
  ADD KEY `sub_category_id` (`sub_category_id`),
  ADD KEY `munu_type_id` (`munu_type_id`);

--
-- Indexes for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `main_category_id` (`main_category_id`);

--
-- Indexes for table `uom`
--
ALTER TABLE `uom`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `update_prodcut`
--
ALTER TABLE `update_prodcut`
  ADD PRIMARY KEY (`id`),
  ADD KEY `daily_prodcut_update_id` (`daily_prodcut_update_id`),
  ADD KEY `prodcut_id` (`prodcut_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `daily_prodcut_update`
--
ALTER TABLE `daily_prodcut_update`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=294;
--
-- AUTO_INCREMENT for table `discount`
--
ALTER TABLE `discount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=153;
--
-- AUTO_INCREMENT for table `favorite_product`
--
ALTER TABLE `favorite_product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `main_category`
--
ALTER TABLE `main_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `master_menu`
--
ALTER TABLE `master_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `menu_type`
--
ALTER TABLE `menu_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order_feedback`
--
ALTER TABLE `order_feedback`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order_file`
--
ALTER TABLE `order_file`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order_item`
--
ALTER TABLE `order_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `order_option`
--
ALTER TABLE `order_option`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `order_serial`
--
ALTER TABLE `order_serial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3492;
--
-- AUTO_INCREMENT for table `order_type`
--
ALTER TABLE `order_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `pay_types`
--
ALTER TABLE `pay_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `pre_order`
--
ALTER TABLE `pre_order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `price_change_notice`
--
ALTER TABLE `price_change_notice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `price_list`
--
ALTER TABLE `price_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table `uom`
--
ALTER TABLE `uom`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `update_prodcut`
--
ALTER TABLE `update_prodcut`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
