-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 30, 2019 at 10:56 AM
-- Server version: 5.7.23-log
-- PHP Version: 7.2.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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: `s_pos_diolg_wfm2`
--

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

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

CREATE TABLE `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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `discountt`
--

INSERT INTO `discount` (`id`, `product_id`, `status`, `activate_on`, `deactivate_on`, `discount`, `pay_type_id`) VALUES
(12, 12, 1, '2019-02-15 00:00:00', '2019-02-15 00:00:00', 10.5, 1),
(13, 12, 1, '2019-02-15 00:00:00', '2019-02-15 00:00:00', 20, 2),
(14, 30, 1, '2019-02-15 00:00:00', '2019-02-15 00:00:00', 10, 1);

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

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

CREATE TABLE `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 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),
(2, 'Starter', 5, 1, '', '2019-05-28 10:00:00', 0),
(3, 'Item ', 2, 1, '', '2019-06-17 00:00:00', 1),
(4, 'Full pro ', 2, 1, '', '2019-06-17 00:00:00', 1),
(5, 'Half pro ', 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),
(10, 'te3', 1, 1, '', '2019-08-08 04:03:30', 106);

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

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

CREATE TABLE `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 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 `menu_type` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `description` varchar(150) NOT NULL,
  `master_menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `menu_type` (`id`, `name`, `description`, `master_menu_id`) VALUES
(1, 'Breakfast', 'Breakfast', 8),
(2, 'Lunch', 'Lunch', 8),
(3, 'Fresh Juice', 'Fresh Juice', 8),
(7, 'Pie', 'Pie', 8);

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

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

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`id`, `refference_id`, `number_of_items`, `total_amount`, `status`, `created_on`, `created_by`, `customer_id`, `rating`, `pay_type_id`, `order_type`) VALUES
(5, 'Ref/95/wfm2/1566816149', 3, '125.00', 0, '2019-08-26 04:12:29', 95, 95, 1, 2, 2),
(6, 'Ref/95/wfm2/1566903652', 1, '112.00', 0, '2019-08-27 04:30:52', 95, 95, 1, 2, 1),
(7, 'Ref/95/wfm2/1566904065', 3, '125.00', 0, '2019-08-27 04:37:45', 95, 95, 1, 2, 1),
(8, 'Ref/95/wfm2/1566904593', 4, '170.00', 0, '2019-08-27 04:46:33', 95, 95, 1, 2, 1),
(9, 'Ref/95/wfm2/1566904770', 4, '170.00', 0, '2019-08-27 04:49:30', 95, 95, 1, 2, 1),
(10, 'Ref/95/wfm2/1566904840', 3, '125.00', 1, '2019-08-27 04:50:40', 95, 95, 1, 2, 1),
(11, 'Ref/95/wfm2/1566905041', 3, '125.00', 1, '2019-08-27 04:54:01', 95, 95, 1, 2, 1),
(12, 'Ref/95/wfm2/1566905116', 6, '183.00', 1, '2019-08-27 04:55:16', 95, 95, 1, 2, 1),
(13, 'Ref/95/wfm2/1566905179', 4, '170.00', 1, '2019-08-27 04:56:19', 95, 95, 1, 2, 1),
(14, 'Ref/95/wfm2/1566905537', 3, '125.00', 1, '2019-08-27 05:02:17', 95, 95, 1, 2, 1),
(15, 'Ref/95/wfm2/1566905600', 4, '133.00', -1, '2019-08-27 05:03:20', 95, 95, 1, 2, 1);

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

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

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

--
-- Dumping data for table `order_feedback`
--

INSERT INTO `order_feedback` (`id`, `order_id`, `feedback`, `user_id`, `created_date`) VALUES
(1, 3, 'knsdknskd', 95, '2019-08-21 03:14:05');

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

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

CREATE TABLE `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_item`
--

INSERT INTO `order_item` (`id`, `unit_price`, `quantity`, `order_id`, `product_id`) VALUES
(31, '150.00', 1, 25, 74),
(32, '150.00', 1, 26, 74),
(33, '5.00', 5, 27, 13),
(34, '210.00', 1, 28, 40),
(35, '210.00', 1, 29, 40),
(36, '40.00', 3, 30, 15),
(37, '150.00', 1, 30, 16),
(38, '40.00', 3, 31, 15),
(39, '150.00', 1, 31, 16),
(40, '40.00', 3, 32, 15),
(41, '150.00', 1, 32, 16),
(42, '10.00', 5, 33, 14),
(43, '140.00', 1, 35, 12),
(44, '140.00', 1, 36, 12),
(45, '140.00', 1, 37, 12),
(46, '140.00', 1, 38, 12),
(47, '40.00', 1, 39, 15),
(48, '210.00', 1, 40, 40),
(49, '200.00', 4, 40, 43),
(50, '200.00', 1, 40, 42),
(51, '300.00', 1, 40, 44),
(52, '210.00', 1, 41, 40),
(53, '200.00', 4, 41, 43),
(54, '200.00', 1, 41, 42),
(55, '300.00', 1, 41, 44),
(56, '210.00', 1, 42, 40),
(57, '200.00', 4, 42, 43),
(58, '200.00', 1, 42, 42),
(59, '300.00', 1, 42, 44),
(60, '140.00', 1, 43, 12),
(61, '5.00', 1, 43, 13),
(62, '10.00', 2, 43, 14),
(63, '140.00', 1, 44, 12),
(64, '5.00', 1, 44, 13),
(65, '30.00', 1, 45, 36),
(66, '60.00', 1, 45, 35),
(67, '40.00', 2, 46, 15),
(68, '140.00', 1, 46, 12),
(69, '140.00', 1, 47, 12),
(70, '10.00', 1, 47, 14),
(71, '140.00', 1, 48, 12),
(72, '140.00', 1, 49, 12),
(73, '140.00', 1, 50, 12),
(74, '140.00', 1, 1, 12),
(75, '150.00', 1, 2, 29),
(76, '30.00', 1, 2, 31),
(77, '30.00', 1, 2, 32),
(78, '60.00', 1, 2, 34),
(79, '140.00', 1, 3, 12),
(80, '5.00', 1, 3, 13),
(81, '10.00', 1, 3, 14),
(82, '40.00', 1, 3, 15),
(83, '140.00', 2, 4, 12),
(84, '140.00', 1, 5, 12),
(85, '5.00', 1, 5, 13),
(86, '8.00', 1, 5, 14),
(87, '140.00', 1, 6, 12),
(88, '140.00', 1, 7, 12),
(89, '5.00', 1, 7, 13),
(90, '8.00', 1, 7, 14),
(91, '140.00', 1, 8, 12),
(92, '5.00', 1, 8, 13),
(93, '8.00', 1, 8, 14),
(94, '45.00', 1, 8, 15),
(95, '140.00', 1, 9, 12),
(96, '5.00', 1, 9, 13),
(97, '8.00', 1, 9, 14),
(98, '45.00', 1, 9, 15),
(99, '140.00', 1, 10, 12),
(100, '5.00', 1, 10, 13),
(101, '8.00', 1, 10, 14),
(102, '140.00', 1, 11, 12),
(103, '5.00', 1, 11, 13),
(104, '8.00', 1, 11, 14),
(105, '140.00', 1, 12, 12),
(106, '5.00', 2, 12, 13),
(107, '8.00', 2, 12, 14),
(108, '45.00', 1, 12, 15),
(109, '140.00', 1, 13, 12),
(110, '5.00', 1, 13, 13),
(111, '8.00', 1, 13, 14),
(112, '45.00', 1, 13, 15),
(113, '140.00', 1, 14, 12),
(114, '5.00', 1, 14, 13),
(115, '8.00', 1, 14, 14),
(116, '5.00', 1, 15, 13),
(117, '140.00', 1, 15, 12),
(118, '8.00', 2, 15, 14);

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

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

CREATE TABLE `order_type` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text
) ENGINE=InnoDB 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 `pay_types` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `status` int(11) NOT NULL,
  `image_path` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `pay_types` (`id`, `name`, `status`, `image_path`) VALUES
(1, 'Easy Cash', 1, '/smart_pos/frontend/web/themeassets/images/paytype/ezcash.png'),
(2, 'Genie', 1, '/smart_pos/frontend/web/themeassets/images/paytype/genie.png');

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

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

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

--
-- Dumping data for table `price_list`
--

INSERT INTO `price_list` (`id`, `description`, `is_active`, `product_id`, `selling_price`, `buying_price`, `created_date`, `updated_date`) VALUES
(7, 'Red Rice', 0, 12, '150.00', '0.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'String Hoppers     ', 1, 13, '5.00', '5.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Plain Hoppers', 0, 14, '10.00', '10.00', '0000-00-00 00:00:00', '2019-08-22 03:15:15'),
(10, 'Egg Hoppers', 0, 15, '40.00', '40.00', '0000-00-00 00:00:00', '2019-08-23 12:15:11'),
(11, 'Bread ', 0, 16, '150.00', '150.00', '0000-00-00 00:00:00', '2019-08-23 01:38:38'),
(12, 'Bread               ', 0, 17, '100.00', '100.00', '0000-00-00 00:00:00', '2019-07-25 02:57:26'),
(13, 'Noodles ', 0, 18, '150.00', '150.00', '0000-00-00 00:00:00', '2019-08-22 11:02:54'),
(14, 'Milk Rice      ', 0, 19, '60.00', '60.00', '0000-00-00 00:00:00', '2019-08-28 02:09:29'),
(15, 'Chick Pie ', 1, 20, '100.00', '100.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'Green gram ', 1, 21, '100.00', '100.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'Manioc ', 1, 22, '80.00', '80.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'Bathla ', 1, 23, '80.00', '80.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'Pittu with gravy', 1, 24, '10.00', '10.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'Roti', 0, 25, '10.00', '10.00', '0000-00-00 00:00:00', '2019-08-22 11:24:46'),
(21, 'Egg Roti with Gravy ', 1, 26, '100.00', '100.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 'Parata with Gravy', 0, 27, '100.00', '100.00', '0000-00-00 00:00:00', '2019-08-22 11:05:45'),
(23, 'Chapatti', 1, 28, '50.00', '50.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 'Those (2 nos) with Gravy              ', 1, 29, '150.00', '150.00', '0000-00-00 00:00:00', '2019-08-22 11:11:26'),
(25, 'Godammba roti (2 nos)', 1, 30, '100.00', '100.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 'Kola Kenda       ', 1, 31, '30.00', '30.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 'Pol Sambol', 1, 32, '30.00', '30.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 'Chicken Curry', 0, 33, '60.00', '60.00', '0000-00-00 00:00:00', '2019-08-22 11:23:15'),
(29, 'Plain Omelets ', 1, 34, '60.00', '60.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 'Fish Curry ', 1, 35, '60.00', '60.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 'Egg Portion', 1, 36, '30.00', '30.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 'Dhal Portion', 1, 37, '40.00', '40.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 'Vegetable', 1, 38, '40.00', '40.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 'Potato Curry', 1, 39, '40.00', '40.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 'Red Rice and Curry (Fish)      ', 1, 40, '210.00', '210.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 'Red Rice and Curry (Chicken)', 1, 41, '210.00', '210.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 'Red Rice and Curry(Vegetable)', 0, 42, '210.00', '210.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 'Red Rice and Curry (Egg )', 1, 43, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 'Red Rice and Curry(Vegetable)', 1, 42, '200.00', '210.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 'Fired Rice (Basmati)', 0, 44, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 'Fired Rice (Basmati)', 1, 44, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 'Chicken Fired Rice(Basmati)', 1, 45, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 'Chicken Fired Rice(Basmati)', 0, 45, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 'Vegetable Fired Rice(Basmati)', 1, 46, '250.00', '250.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 'Egg Fired Rice(Basmati)', 1, 47, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 'Egg Noodles', 1, 48, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 'Sea Food Fired Rice(Basmati)', 1, 49, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 'Mixed Fired Rice(Basmati)', 1, 50, '400.00', '400.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 'Egg & Sausage Surprise ', 1, 51, '250.00', '250.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 'Sri Lankan Surprise', 0, 52, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 'Chinese Surprise', 1, 53, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(52, 'Fried noodles Chicken ', 1, 54, '250.00', '250.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, 'Fish  Biryani', 1, 55, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, 'Chicken Biryani', 1, 56, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, 'Vegetable Biryani', 1, 57, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 'Nasirorang', 1, 58, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, 'Lamprais ', 1, 59, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, 'Pasta', 1, 60, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, 'Lasagna', 1, 61, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, 'Spaghetti', 1, 62, '350.00', '350.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, 'Kottu 25', 0, 63, '0.00', '0.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, 'Kottu 25', 1, 63, '300.00', '0.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, 'Chicken  Kottu', 1, 64, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, 'Vegetable Kottu', 1, 65, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, 'Egg Kottu', 1, 66, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, 'Prawn Mongolian ', 1, 67, '450.00', '450.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(67, 'Chicken Mongolian ', 1, 68, '400.00', '400.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(68, 'Vegetable Mongolian ', 1, 69, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(69, 'Chicken Devilled ', 1, 70, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(70, 'Devilled Fish', 1, 71, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(71, 'Omelet', 1, 72, '100.00', '100.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(72, 'Soup', 1, 73, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(73, 'Mango  ', 1, 74, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(74, 'Papaya', 1, 75, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(75, 'Wood Apple ', 1, 76, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(76, 'Orange ', 1, 77, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(77, 'Mixed Fruit', 1, 78, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(78, 'Water Melon', 1, 79, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(79, 'Lime', 1, 80, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(80, 'Avocado', 1, 81, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(81, 'Beli', 1, 82, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(82, 'Anoda', 1, 83, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(83, 'Aberella', 1, 84, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(84, 'Passion Fruit ', 1, 85, '150.00', '150.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(85, 'Faluda', 1, 86, '200.00', '200.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(86, 'Sri Lankan Surprise', 1, 52, '300.00', '300.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(87, 'Red Rice', 0, 12, '150.00', '123.00', '0000-00-00 00:00:00', '2019-07-31 10:39:51'),
(88, 'testing', 0, 87, '150.00', '100.00', '2019-06-19 01:50:01', '2019-06-19 01:50:01'),
(89, 'testing', 0, 87, '200.00', '150.00', '2019-06-19 01:51:48', '2019-06-19 01:51:48'),
(90, 'testing', 0, 87, '200.00', '150.00', '2019-06-19 01:52:45', '2019-06-19 01:52:45'),
(91, 'testing', 0, 87, '230.00', '150.00', '2019-06-19 02:18:02', '2019-06-19 02:18:02'),
(92, 'testing', 0, 87, '230.00', '150.00', '2019-06-19 02:24:42', '2019-06-19 02:24:42'),
(93, 'testing', 0, 87, '240.00', '150.00', '2019-06-19 02:25:46', '2019-06-19 02:29:44'),
(94, 'testing', 1, 87, '240.00', '160.00', '2019-06-19 02:29:44', NULL),
(95, 'sddfdf', 1, 88, '150.00', '100.00', '2019-06-21 02:55:20', NULL),
(96, 'testion', 1, 89, '152.00', '150.00', '2019-07-22 05:56:54', NULL),
(97, 'Bread               ', 1, 17, '90.00', '80.00', '2019-07-25 02:57:26', NULL),
(98, 'Koththu', 0, 90, '350.00', '250.00', '2019-07-26 04:14:26', '2019-07-26 04:19:35'),
(99, 'Koththu', 1, 90, '300.00', '250.00', '2019-07-26 04:19:35', NULL),
(100, 'Red Rice', 1, 12, '140.00', '123.00', '2019-07-31 10:39:51', NULL),
(101, 'Plain Hoppers', 1, 14, '8.00', '10.00', '2019-08-22 03:15:15', NULL),
(102, 'description', 0, 18, '140.00', '130.00', '2019-08-22 07:36:21', NULL),
(103, 'description', 0, 27, '90.00', '100.00', '2019-08-22 07:56:34', NULL),
(104, 'Noodles ', 0, 18, '150.00', '150.00', '2019-08-22 11:02:54', '2019-08-22 11:06:26'),
(105, 'Parata with Gravy', 1, 27, '100.00', '100.00', '2019-08-22 11:05:45', '2019-08-22 11:09:27'),
(106, 'Noodles ', 1, 18, '150.00', '150.00', '2019-08-22 11:06:26', '2019-08-22 11:09:33'),
(107, 'description', 1, 27, '90.00', '100.00', '2019-08-22 11:09:27', NULL),
(108, 'description', 1, 18, '140.00', '130.00', '2019-08-22 11:09:33', NULL),
(109, 'description', 0, 29, '160.00', '150.00', '2019-08-22 11:10:37', NULL),
(110, 'description', 1, 29, '160.00', '150.00', '2019-08-22 11:11:26', NULL),
(111, 'description', 0, 25, '12.00', '10.00', '2019-08-22 11:14:44', NULL),
(112, 'description', 0, 25, '12.00', '10.00', '2019-08-22 11:15:07', NULL),
(113, 'description', 1, 33, '70.00', '60.00', '2019-08-22 11:21:03', NULL),
(114, 'description', 0, 25, '12.00', '10.00', '2019-08-22 11:24:38', '2019-08-22 11:26:22'),
(115, 'description', 1, 25, '11.00', '10.00', '2019-08-22 11:25:33', NULL),
(116, 'description', 1, 15, '45.00', '40.00', '2019-08-23 12:14:57', NULL),
(117, 'description', 1, 16, '155.00', '150.00', '2019-08-23 01:36:49', NULL),
(118, 'description', 1, 19, '70.00', '60.00', '2019-08-28 02:09:18', NULL),
(119, 'description', -1, 21, '110.00', '100.00', '2019-08-28 02:09:50', NULL);

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

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

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

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `name`, `available_quantity`, `rating`, `status`, `image_path`, `details_image_path`, `sub_category_id`, `main_category_id`, `munu_type_id`, `uom_id`, `created`, `created_by`) VALUES
(12, 'Red Rice2', 2, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190726041009.jpg', 'empty', 1, 1, 1, 1, '2019-06-17 11:47:58', 1),
(13, 'String Hoppers     ', 3, 1, 0, '../image/s_pos_Diolg_wfm2/image_path20190621100248.jpg', 'empty', 7, 3, 1, 1, '2019-06-17 11:54:30', 1),
(14, 'Plain Hoppers', 2, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190822031515.jpg', 'empty', 3, 3, 1, 1, '2019-06-17 11:57:38', 1),
(15, 'Egg Hoppers', 3, 1, 1, 'empty', 'empty', 3, 3, 1, 1, '2019-06-17 11:58:29', 1),
(16, 'Bread ', 0, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190621045823.jpg', 'empty', 8, 4, 1, 1, '2019-06-17 12:00:45', 1),
(17, 'Bread               ', 0, 1, 1, 'empty', 'empty', 9, 5, 1, 1, '2019-06-17 12:02:07', 1),
(18, 'Noodles ', 0, 1, 1, 'empty', 'empty', 10, 1, 1, 1, '2019-06-17 12:04:14', 1),
(19, 'Milk Rice      ', 0, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190725030121.jpg', 'empty', 11, 6, 1, 1, '2019-06-17 12:06:59', 1),
(20, 'Chick Pie ', 0, 1, 1, 'empty', 'empty', 12, 8, 1, 1, '2019-06-17 12:11:55', 1),
(21, 'Green gram ', 0, 1, 1, 'empty', 'empty', 13, 1, 1, 1, '2019-06-17 12:13:52', 1),
(22, 'Manioc ', 0, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190621100354.jpg', 'empty', 14, 1, 1, 1, '2019-06-17 12:16:05', 1),
(23, 'Bathla ', 0, 1, 1, 'empty', 'empty', 15, 1, 1, 1, '2019-06-17 12:17:10', 1),
(24, 'Pittu with gravy', 0, 1, 1, 'empty', 'empty', 16, 3, 1, 1, '2019-06-17 12:21:25', 1),
(25, 'Roti', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 04:59:10', 1),
(26, 'Egg Roti with Gravy ', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 05:00:06', 1),
(27, 'Parata with Gravy', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 05:00:38', 1),
(28, 'Chapatti', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 05:01:25', 1),
(29, 'Those (2 nos) with Gravy              ', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 05:02:22', 1),
(30, 'Godammba roti (2 nos)', 0, 1, 1, 'empty', 'empty', 4, 3, 1, 1, '2019-06-17 05:03:08', 1),
(31, 'Kola Kenda       ', 0, 1, 1, 'empty', 'empty', 5, 7, 1, 1, '2019-06-17 05:04:37', 1),
(32, 'Pol Sambol', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 05:57:47', 1),
(33, 'Chicken Curry', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 05:58:28', 1),
(34, 'Plain Omelets ', 0, 1, 1, 'empty', 'empty', 17, 3, 1, 1, '2019-06-17 06:00:01', 1),
(35, 'Fish Curry ', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 06:00:37', 1),
(36, 'Egg Portion', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 06:01:34', 1),
(37, 'Dhal Portion', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 06:03:48', 1),
(38, 'Vegetable', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 06:04:21', 1),
(39, 'Potato Curry', 0, 1, 1, 'empty', 'empty', 6, 1, 1, 1, '2019-06-17 06:04:49', 1),
(40, 'Red Rice and Curry (Fish)      ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:13:25', 1),
(41, 'Red Rice and Curry (Chicken)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:14:40', 1),
(42, 'Red Rice and Curry(Vegetable)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:16:06', 1),
(43, 'Red Rice and Curry (Egg )', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:17:29', 1),
(44, 'Fish Fired Rice (Basmati)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:19:58', 1),
(45, 'Chicken Fired Rice(Basmati)', 0, 1, 1, '44', 'empty', 1, 1, 2, 1, '2019-06-17 06:23:38', 1),
(46, 'Vegetable Fired Rice(Basmati)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:29:10', 1),
(47, 'Egg Fired Rice(Basmati)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:33:03', 1),
(48, 'Egg Noodles', 0, 1, 1, 'empty', 'empty', 10, 1, 2, 1, '2019-06-17 06:33:54', 1),
(49, 'Sea Food Fired Rice(Basmati)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:34:41', 1),
(50, 'Mixed Fired Rice(Basmati)', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:35:19', 1),
(51, 'Egg & Sausage Surprise ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:36:03', 1),
(52, 'Sri Lankan Surprise', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:36:36', 1),
(53, 'Chinese Surprise', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:37:08', 1),
(54, 'Fried noodles Chicken ', 0, 1, 1, 'empty', 'empty', 10, 1, 2, 1, '2019-06-17 06:37:39', 1),
(55, 'Fish  Biryani', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:39:13', 1),
(56, 'Chicken Biryani', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:39:46', 1),
(57, 'Vegetable Biryani', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:40:18', 1),
(58, 'Nasirorang', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:43:38', 1),
(59, 'Lamprais ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:44:31', 1),
(60, 'Pasta', 0, 1, 1, 'empty', 'empty', 18, 1, 2, 1, '2019-06-17 06:46:10', 1),
(61, 'Lasagna', 0, 1, 1, 'empty', 'empty', 19, 3, 2, 1, '2019-06-17 06:47:23', 1),
(62, 'Spaghetti', 0, 1, 1, 'empty', 'empty', 10, 1, 2, 1, '2019-06-17 06:48:28', 1),
(63, 'Fish  Kottu', 0, 1, 1, 'empty', 'empty', 2, 1, 2, 1, '2019-06-17 06:48:59', 1),
(64, 'Chicken  Kottu', 0, 1, 1, 'empty', 'empty', 2, 1, 2, 1, '2019-06-17 06:50:35', 1),
(65, 'Vegetable Kottu', 0, 1, 1, 'empty', 'empty', 2, 1, 2, 1, '2019-06-17 06:51:14', 1),
(66, 'Egg Kottu', 0, 1, 1, 'empty', 'empty', 2, 1, 2, 1, '2019-06-17 06:51:43', 1),
(67, 'Prawn Mongolian ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:57:52', 1),
(68, 'Chicken Mongolian ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 06:59:02', 1),
(69, 'Vegetable Mongolian ', 0, 1, 1, 'empty', 'empty', 1, 1, 2, 1, '2019-06-17 07:00:06', 1),
(70, 'Chicken Devilled ', 0, 1, 1, 'empty', 'empty', 6, 1, 2, 1, '2019-06-17 07:00:50', 1),
(71, 'Devilled Fish', 0, 1, 1, 'empty', 'empty', 6, 1, 2, 1, '2019-06-17 07:01:18', 1),
(72, 'Omelet', 0, 1, 1, 'empty', 'empty', 17, 3, 2, 1, '2019-06-17 07:01:46', 1),
(73, 'Soup', 0, 1, 1, 'empty', 'empty', 6, 1, 2, 1, '2019-06-17 07:02:36', 1),
(74, 'Mango  ', 0, 1, 1, 'empty', 'empty', 20, 7, 3, 1, '2019-06-17 07:04:08', 1),
(75, 'Papaya', 0, 1, 1, 'empty', 'empty', 21, 7, 3, 1, '2019-06-17 07:05:30', 1),
(76, 'Wood Apple ', 0, 1, 1, 'empty', 'empty', 22, 7, 3, 1, '2019-06-17 07:06:42', 1),
(77, 'Orange ', 0, 1, 1, 'empty', 'empty', 23, 7, 3, 1, '2019-06-17 07:07:58', 1),
(78, 'Mixed Fruit', 0, 1, 1, 'empty', 'empty', 24, 7, 3, 1, '2019-06-17 07:09:04', 1),
(79, 'Water Melon', 0, 1, 1, 'empty', 'empty', 25, 7, 3, 1, '2019-06-17 07:09:52', 1),
(80, 'Lime', 0, 1, 1, 'empty', 'empty', 26, 7, 3, 1, '2019-06-17 07:11:11', 1),
(81, 'Avocado', 0, 1, 1, 'empty', 'empty', 27, 7, 3, 1, '2019-06-17 07:12:05', 1),
(82, 'Beli', 0, 1, 1, 'empty', 'empty', 28, 7, 3, 1, '2019-06-17 07:13:30', 1),
(83, 'Anoda', 0, 1, 1, 'empty', 'empty', 29, 7, 3, 1, '2019-06-17 07:14:47', 1),
(84, 'Aberella', 0, 1, 1, 'empty', 'empty', 29, 7, 3, 1, '2019-06-17 07:15:11', 1),
(85, 'Passion Fruit ', 0, 1, 1, 'empty', 'empty', 29, 7, 3, 1, '2019-06-17 07:15:36', 1),
(86, 'Faluda', 0, 1, 1, 'empty', 'empty', 29, 7, 3, 1, '2019-06-17 07:16:01', 1),
(87, 'testing11', 0, 1, 1, 'empty', 'empty', 2, 1, 1, 1, '2019-06-19 01:50:00', 1),
(88, 'testing1', 0, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190621030020.jpg', 'null', 1, 1, 1, 1, '2019-06-21 02:55:20', 1),
(89, 'testion', 2, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190722055653.jpg', 'null', 6, 1, 7, 1, '2019-07-22 05:56:53', 1),
(90, 'Koththu', 12, 1, 1, '../image/s_pos_Diolg_wfm2/image_path20190726041426.jpg', 'null', 2, 1, 2, 1, '2019-07-26 04:14:26', 67);

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

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

CREATE TABLE `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
) ENGINE=InnoDB 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`) VALUES
(1, 'Rice', 5, 1, '', '2019-05-28 08:00:00', 1, 1),
(2, 'Kottu', 5, 1, '', '2019-05-28 14:00:00', 1, 1),
(3, 'Hoppers', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(4, 'Roti', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(5, 'Kenda', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(6, 'Accompaniment', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(7, 'String Hoppers     ', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(8, 'Bread            ', 1, 1, '', '2019-06-17 00:00:00', 1, 4),
(9, 'Bread               ', 1, 1, '', '2019-06-17 00:00:00', 1, 5),
(10, 'Noodles ', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(11, 'Rice', 1, 1, '', '2019-06-17 00:00:00', 1, 6),
(12, 'Chick', 1, 1, '', '2019-06-17 00:00:00', 1, 8),
(13, 'gram ', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(14, 'Manioc', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(15, 'Bathla ', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(16, 'Pittu ', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(17, 'Accompaniment\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(18, 'Pasta\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 1),
(19, 'Lasagna', 1, 1, '', '2019-06-17 00:00:00', 1, 3),
(20, 'Mango  \r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(21, 'Papaya\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(22, 'Wood Apple \r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(23, 'Orange \r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(24, 'Mixed Fruit\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(25, 'Water Melon\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(26, 'Lime\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(27, 'Avocado\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(28, 'Beli\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7),
(29, 'Juices\r\n', 1, 1, '', '2019-06-17 00:00:00', 1, 7);

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

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

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

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

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

--
-- Indexes for dumped tables
--

--
-- 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 `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 `order`
--
ALTER TABLE `order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pay_type_id` (`pay_type_id`),
  ADD KEY `order_type` (`order_type`);

--
-- Indexes for table `order_feedback`
--
ALTER TABLE `order_feedback`
  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_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 `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`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `discount`
--
ALTER TABLE `discount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- 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=8;

--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `order_feedback`
--
ALTER TABLE `order_feedback`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `order_item`
--
ALTER TABLE `order_item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

--
-- 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=3;

--
-- AUTO_INCREMENT for table `price_list`
--
ALTER TABLE `price_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120;

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `sub_category`
--
ALTER TABLE `sub_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `uom`
--
ALTER TABLE `uom`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `discount`
--
ALTER TABLE `discount`
  ADD CONSTRAINT `discount_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
  ADD CONSTRAINT `discount_ibfk_2` FOREIGN KEY (`pay_type_id`) REFERENCES `pay_types` (`id`);

--
-- Constraints for table `menu_type`
--
ALTER TABLE `menu_type`
  ADD CONSTRAINT `menu_type_ibfk_1` FOREIGN KEY (`master_menu_id`) REFERENCES `master_menu` (`id`);

--
-- Constraints for table `order`
--
ALTER TABLE `order`
  ADD CONSTRAINT `order_ibfk_1` FOREIGN KEY (`pay_type_id`) REFERENCES `pay_types` (`id`),
  ADD CONSTRAINT `order_ibfk_2` FOREIGN KEY (`order_type`) REFERENCES `order_type` (`id`);

--
-- Constraints for table `order_item`
--
ALTER TABLE `order_item`
  ADD CONSTRAINT `order_item_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`),
  ADD CONSTRAINT `order_item_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`);

--
-- Constraints for table `price_list`
--
ALTER TABLE `price_list`
  ADD CONSTRAINT `price_list_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`);

--
-- Constraints for table `product`
--
ALTER TABLE `product`
  ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`main_category_id`) REFERENCES `main_category` (`id`),
  ADD CONSTRAINT `product_ibfk_2` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_category` (`id`),
  ADD CONSTRAINT `product_ibfk_3` FOREIGN KEY (`munu_type_id`) REFERENCES `menu_type` (`id`);

--
-- Constraints for table `sub_category`
--
ALTER TABLE `sub_category`
  ADD CONSTRAINT `sub_category_ibfk_1` FOREIGN KEY (`main_category_id`) REFERENCES `main_category` (`id`);
COMMIT;

/*!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 */;
