text: -- phpMyAdmin SQL Dump
  -- version 4.8.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost
  -- Generation Time: May 31, 2019 at 10:11 AM
  -- Server version: 10.1.37-MariaDB
  -- PHP Version: 7.3.0
  
  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: `db_fsdms`
  --
  
  DELIMITER $$
  --
  -- Procedures
  --
  CREATE DEFINER=`magentocpanel`@`localhost` PROCEDURE `create_view_product` ()  BEGIN
      CREATE OR REPLACE VIEW product_concat AS
  select
    product_cart.product_name as `name`,
    product_cart.product_sku as `sku`,
    product_cart.price as `price`,
    product_cart.quantity as `quantity`,
    optional_product_cart.unique_order_id as `unique_order_id`,
    GROUP_CONCAT(optional_product_cart.product_sku) as `optional_sku`,
    GROUP_CONCAT(optional_product_cart.product_name) as `optional_name`,
    GROUP_CONCAT(optional_product_cart.quantity) as `optional_quantity`
  from
    product_cart,
    optional_product_cart
  where
    product_cart.unique_order_id = optional_product_cart.unique_order_id
  group by
    product_cart.id;
  END$$
  
  CREATE DEFINER=`magentocpanel`@`localhost` PROCEDURE `select_cart_products` (IN `userid` INT(11))  BEGIN
  
  CALL create_view_product();
  
  SET @user_id = userid;
  SET @concat_product = concat('SELECT pc.id as id,pc.user_id as user_id,pc.user_table as user_table,pc.order_id as order_id,pc.unique_order_id as unique_order_id,pc.product_sku as sku,pc.product_name as product_name,pc.price as price,proc.optional_sku as optional_sku,proc.optional_name as optional_name,proc.optional_quantity as optional_quantity ,pc.quantity FROM product_concat as proc RIGHT JOIN product_cart AS pc ON pc.unique_order_id = proc.unique_order_id WHERE pc.confirm_flag = 0 AND pc.user_id = ',@user_id);
  PREPARE stmt1 FROM @concat_product;
  EXECUTE stmt1;
  DEALLOCATE PREPARE stmt1;
  END$$
  
  DELIMITER ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_details`
  --
  
  CREATE TABLE `admin_details` (
    `id` int(11) NOT NULL,
    `first_name` varchar(45) DEFAULT NULL,
    `last_name` varchar(45) DEFAULT NULL,
    `user_name` varchar(45) DEFAULT NULL,
    `email` varchar(45) DEFAULT NULL,
    `phone_number` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admin_details`
  --
  
  INSERT INTO `admin_details` (`id`, `first_name`, `last_name`, `user_name`, `email`, `phone_number`) VALUES
  (2, 'John', 'Doe', 'JohnDoe', 'johndoe@gmail.com', '9876543210');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin_login_count`
  --
  
  CREATE TABLE `admin_login_count` (
    `id` int(11) NOT NULL,
    `login_count` int(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `admin_login_count`
  --
  
  INSERT INTO `admin_login_count` (`id`, `login_count`) VALUES
  (1, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `bin_master`
  --
  
  CREATE TABLE `bin_master` (
    `id` int(11) NOT NULL,
    `bin_name` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `bin_master`
  --
  
  INSERT INTO `bin_master` (`id`, `bin_name`) VALUES
  (7, '1'),
  (8, 'Bin1'),
  (9, 'bin22');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `branch_data`
  --
  
  CREATE TABLE `branch_data` (
    `id` int(11) NOT NULL,
    `company_name` varchar(225) NOT NULL,
    `branch_name` varchar(225) NOT NULL,
    `branch_telephone` varchar(225) NOT NULL,
    `branch_gstn` varchar(225) NOT NULL,
    `branch_address1` varchar(225) NOT NULL,
    `branch_address2` varchar(225) NOT NULL,
    `branch_address3` varchar(225) NOT NULL,
    `branch_city` varchar(225) NOT NULL,
    `branch_state` varchar(225) NOT NULL,
    `branch_zipcode` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `branch_data`
  --
  
  INSERT INTO `branch_data` (`id`, `company_name`, `branch_name`, `branch_telephone`, `branch_gstn`, `branch_address1`, `branch_address2`, `branch_address3`, `branch_city`, `branch_state`, `branch_zipcode`) VALUES
  (9, '12', 'aaaaa', 'aaaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa'),
  (14, '22', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaaa', 'aaaaa', 'aaaaa', 'aaaa'),
  (15, '22', 'branch1', '4735743957943', '869779797977', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Bangalore1', 'Karnataka1', '590324'),
  (16, '23', 'branch2', '4735743957943', '657757ytj885675', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Bangalore', 'Karnataka', '590324'),
  (17, '24', '11113434', '11113434', '11114343', '111343', '1143434', '3434', '11434', '43', '311');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cart_confirmation`
  --
  
  CREATE TABLE `cart_confirmation` (
    `id` int(11) NOT NULL,
    `user_id` varchar(225) DEFAULT NULL,
    `user_table` varchar(225) DEFAULT NULL,
    `order_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `product_id` varchar(225) DEFAULT NULL,
    `product_sku` varchar(225) DEFAULT NULL,
    `price` int(225) NOT NULL,
    `quantity` int(100) NOT NULL,
    `from_date` date NOT NULL,
    `to_date` date NOT NULL,
    `confirm_flag` varchar(225) DEFAULT NULL,
    `bundled_flag` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `cart_confirmation`
  --
  
  INSERT INTO `cart_confirmation` (`id`, `user_id`, `user_table`, `order_id`, `unique_order_id`, `product_id`, `product_sku`, `price`, `quantity`, `from_date`, `to_date`, `confirm_flag`, `bundled_flag`) VALUES
  (76, '28', 'individual_user_registration', 'OI28052019063805', 'UID28052019063817', '218c8d7eeaac1605cd61ca0a1736a022', '23w23', 305, 1, '2019-05-22', '2019-05-30', '1', 'bundle'),
  (77, '28', 'individual_user_registration', 'OI28052019080907', 'UID28052019080922', '526a18fd8a9a0b74ae6991068d7b71c0', 'test', 251, 1, '0000-00-00', '0000-00-00', '0', 'bundle'),
  (78, '28', 'individual_user_registration', 'OI28052019080907', 'UID28052019081042', '526a18fd8a9a0b74ae6991068d7b71c0', 'test', 251, 1, '0000-00-00', '0000-00-00', '0', 'bundle'),
  (79, '28', 'individual_user_registration', 'OI29052019081204', 'UID29052019081215', '218c8d7eeaac1605cd61ca0a1736a022', '23w23', 305, 1, '0000-00-00', '0000-00-00', '0', 'bundle');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `category_master`
  --
  
  CREATE TABLE `category_master` (
    `id` int(11) NOT NULL,
    `category` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `category_master`
  --
  
  INSERT INTO `category_master` (`id`, `category`) VALUES
  (20, 'North Indian'),
  (21, 'South Indian'),
  (22, 'Italian'),
  (23, 'Mexican');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `company_data`
  --
  
  CREATE TABLE `company_data` (
    `id` int(11) NOT NULL,
    `company_name` varchar(225) DEFAULT NULL,
    `company_telephone` varchar(225) DEFAULT NULL,
    `company_gstn` varchar(225) DEFAULT NULL,
    `company_address` varchar(225) DEFAULT NULL,
    `company_city` varchar(225) DEFAULT NULL,
    `company_state` varchar(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `company_data`
  --
  
  INSERT INTO `company_data` (`id`, `company_name`, `company_telephone`, `company_gstn`, `company_address`, `company_city`, `company_state`) VALUES
  (12, 'MansoroftLappy', '9160700733', 'GSTN1234', '2-12-265,4th Floor,Surya Garonda Apartments,HimayathNagar ', 'Hyderabad', 'Telangana'),
  (22, 'zenopsys', '123456789', '123456789', 'aaaaa,aaaaa,aaaaa', 'aaaaa', 'aaaaa'),
  (23, 'Zenopsys1', '4735743957943', 'Zenopsys1', 'Bangalore,bsk 3rd stage,hoskerehalli', 'Bangalore', 'Karnataka'),
  (24, 'eee', '2ee', '66756567r', 'rrrr22,rrt22,rtrtr22', '22rrr', '22rrr'),
  (25, 'foodpanda', '989898989', '467878787', 'jpnager,jpnager,jpnager', 'jpnager', 'jpnager');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `corporate_representative`
  --
  
  CREATE TABLE `corporate_representative` (
    `id` int(11) NOT NULL,
    `company_name` varchar(225) NOT NULL,
    `branch_name` varchar(225) NOT NULL,
    `user_title` varchar(225) NOT NULL,
    `rep_first_name` varchar(225) NOT NULL,
    `rep_mid_name` varchar(225) NOT NULL,
    `rep_last_name` varchar(225) NOT NULL,
    `rep_email_id` varchar(225) NOT NULL,
    `rep_phono_no` varchar(225) NOT NULL,
    `rep_designation` varchar(225) NOT NULL,
    `rep_employee_id` varchar(225) NOT NULL,
    `rep_address1` varchar(225) NOT NULL,
    `rep_address2` varchar(225) NOT NULL,
    `rep_address3` varchar(225) NOT NULL,
    `rep_city` varchar(225) NOT NULL,
    `rep_state` varchar(225) NOT NULL,
    `rep_zipcode` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `corporate_representative`
  --
  
  INSERT INTO `corporate_representative` (`id`, `company_name`, `branch_name`, `user_title`, `rep_first_name`, `rep_mid_name`, `rep_last_name`, `rep_email_id`, `rep_phono_no`, `rep_designation`, `rep_employee_id`, `rep_address1`, `rep_address2`, `rep_address3`, `rep_city`, `rep_state`, `rep_zipcode`) VALUES
  (6, '22', '14', 'Dr', 'lkjjj', 'lk', 'lk', 'lakshmikumar.k@zenopsys.com', '987456321', '12345', 'aaaa', 'aaaa', 'aaa', 'aaaa', 'aaa', 'aaaa', 'aaa'),
  (9, '12', '9', 'Ms', 'aaaa', 'aaaaa', 'aaaa', 'divya.a@zenopsys.com', '6786868867', 'dfdfd', 'dsdsds', 'dfdfdf', 'dfdfd', 'dfdfd', 'dfdfd', 'dfdf', 'dfdfd'),
  (10, '12', '9', 'Ms', 'zenopsys789', 'erty899', 'Marella33', 'a156546@g.co', '89889757877', 'utrigjouy668', '9080999', 'Bangalore', 'gfhgfhfg', 'fghfhfghfgh', 'Bangalore', 'Karnataka', '590324'),
  (11, '22', '15', 'Dr', 'asas', 'qweww', 'sdsd', 'dffff', '1111', 'ere', 'tyyt', '111', 'aaaa', 'aaaa', '12345', '1111', '111'),
  (12, '24', '17', 'Ms', 'qqq1', 'qq1', 'qq1', 'qq1', 'q1', 'qqq1', 'qqq1', 'qqq1', 'qqq1', 'qqqq1', 'qqq1', 'qq1', 'qqq11');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `corporate_user_registration`
  --
  
  CREATE TABLE `corporate_user_registration` (
    `id` int(11) NOT NULL,
    `company_name` varchar(45) DEFAULT NULL,
    `user_title` varchar(225) DEFAULT NULL,
    `first_name` varchar(225) DEFAULT NULL,
    `middle_name` varchar(225) DEFAULT NULL,
    `last_name` varchar(225) DEFAULT NULL,
    `rep_designation` varchar(225) DEFAULT NULL,
    `rep_employee_id` varchar(225) DEFAULT NULL,
    `rep_email_id` varchar(225) DEFAULT NULL,
    `rep_phone_number` varchar(225) DEFAULT NULL,
    `admin` tinyint(4) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `corporate_user_registration`
  --
  
  INSERT INTO `corporate_user_registration` (`id`, `company_name`, `user_title`, `first_name`, `middle_name`, `last_name`, `rep_designation`, `rep_employee_id`, `rep_email_id`, `rep_phone_number`, `admin`) VALUES
  (3, 'MansoroftLappy', 'Mr', 'Vedavith', 'Ramaujan Das', 'Ravula', 'CTO', 'ml001', 'reply2developer@gmail.com', '9160700733', 1),
  (15, 'zenopsys', 'Ms', 'mounika', 'aaaaaa', 'm', 'aaaa', 'aaaa', 'mounika.m@zenopsys.com', '9874563210', 1),
  (16, 'eee', 'Ms', 'raja22', 'rtrt22', 'www22', 'www22', 'wwwww', 'wwww', 'wwww22', 1),
  (17, 'foodpanda', 'Ms', 'sony', 's', 's', 'eeeee', '12345', 'sony@ddd.in', '978898989898', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `custom_product_master`
  --
  
  CREATE TABLE `custom_product_master` (
    `id` int(11) NOT NULL,
    `product_category` int(11) NOT NULL,
    `product_sku` varchar(45) DEFAULT NULL,
    `customizable_product` varchar(45) DEFAULT NULL,
    `customizable_sku` varchar(225) NOT NULL,
    `custom_product_price` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `custom_product_master`
  --
  
  INSERT INTO `custom_product_master` (`id`, `product_category`, `product_sku`, `customizable_product`, `customizable_sku`, `custom_product_price`) VALUES
  (8, 23, '23w23', 'test1,product1', 'est1,sku_prod1', '100,200'),
  (12, 21, 'test', 'meals', 'meals123', '248'),
  (14, 20, 'burger01', 'product1', 'sku_prod1', '200');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `date_products`
  --
  
  CREATE TABLE `date_products` (
    `id` int(11) UNSIGNED NOT NULL,
    `23w23` int(11) UNSIGNED NOT NULL,
    `test` int(11) UNSIGNED NOT NULL,
    `burger01` int(11) UNSIGNED NOT NULL,
    `est1` int(11) UNSIGNED NOT NULL,
    `sku_prod1` int(11) UNSIGNED NOT NULL,
    `sku_prod2` int(11) UNSIGNED NOT NULL,
    `meals123` int(11) UNSIGNED NOT NULL,
    `eee123` int(11) UNSIGNED NOT NULL,
    `w` int(11) UNSIGNED NOT NULL,
    `date` date DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `date_products`
  --
  
  INSERT INTO `date_products` (`id`, `23w23`, `test`, `burger01`, `est1`, `sku_prod1`, `sku_prod2`, `meals123`, `eee123`, `w`, `date`) VALUES
  (1, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-22'),
  (2, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-23'),
  (3, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-24'),
  (4, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-25'),
  (5, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-26'),
  (6, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-27'),
  (7, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-28'),
  (8, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-29'),
  (9, 1, 0, 0, 1, 1, 0, 0, 0, 0, '2019-05-30');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `DC_order`
  --
  
  CREATE TABLE `DC_order` (
    `id` int(11) NOT NULL,
    `kit_id` varchar(225) NOT NULL,
    `delivery_emp_id` varchar(225) NOT NULL,
    `dc_id` varchar(225) NOT NULL,
    `user_id` varchar(225) NOT NULL,
    `product_name` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `quantity` varchar(225) NOT NULL,
    `order_id` varchar(225) NOT NULL,
    `main_address` varchar(225) NOT NULL,
    `branch_address` varchar(225) NOT NULL,
    `bundled_flag` varchar(225) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `today_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `DC_order`
  --
  
  INSERT INTO `DC_order` (`id`, `kit_id`, `delivery_emp_id`, `dc_id`, `user_id`, `product_name`, `product_sku`, `quantity`, `order_id`, `main_address`, `branch_address`, `bundled_flag`, `status`, `today_date`) VALUES
  (4, '123', '17', 'DC19042019081129', '28', 'product2', 'sku_prod2', '', 'OI19042019074513', '', '', '', 0, '2019-04-19 08:13:41'),
  (5, '123', '17', 'DC24042019075136', '28', 'product2', 'sku_prod2', '3', 'OI19042019074513', '', '', '', 0, '2019-04-24 07:51:53'),
  (6, '123', '17', 'DC24042019075518', '28', 'test2222', '22222', '1', 'OI240420190739331', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 0, '2019-04-24 07:55:25');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `DC_stock`
  --
  
  CREATE TABLE `DC_stock` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `delivery_id` varchar(225) NOT NULL,
    `dc_no` varchar(225) NOT NULL,
    `product_name` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `product_units` varchar(225) NOT NULL,
    `product_quantity` varchar(225) NOT NULL,
    `available_quantity` varchar(225) NOT NULL,
    `store_name` varchar(255) NOT NULL,
    `prod_ploc` varchar(225) NOT NULL,
    `today_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `Accept_flag` tinyint(1) NOT NULL,
    `status` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `DC_stock`
  --
  
  INSERT INTO `DC_stock` (`id`, `kitchen_id`, `delivery_id`, `dc_no`, `product_name`, `product_sku`, `product_units`, `product_quantity`, `available_quantity`, `store_name`, `prod_ploc`, `today_date`, `Accept_flag`, `status`) VALUES
  (11, '123', '1', 'DC07032019111701', 'aaa', '23', 'aa', '10', '40', 'a', '3', '2019-03-07 11:18:03', 1, 0),
  (12, '125', '2', 'DC07032019112002', 'aaa', 'aa', 'aa', '12', '40', 'a', '3', '2019-03-07 11:20:15', 0, 0),
  (13, '345', '4', 'DC07032019112055', 'aaa', 'aa', 'aa', '12', '40', 'a', '3', '2019-03-07 11:21:38', 0, 1),
  (14, '123', '1', 'DC07032019120825', 'aaa', 'aa', 'aa', '25', '40', 'a', '3', '2019-03-07 12:08:39', 1, 0),
  (15, '123', '1', 'DC08032019045201', 'Sugar', 'sugarsale32', 'unit1', '50', '100', 'a', '4', '2019-03-08 04:52:34', 1, 0),
  (16, '123', '3', 'DC08032019112410', 'jaggery', 'jaggery78', 'unit1', '80', '90', 'test1', '5', '2019-03-08 11:24:35', 1, 0),
  (17, '123', '2', 'DC11032019093412', 'jkjkjk', '', '', '8', '', 'jkjk', '', '2019-03-11 09:34:33', 0, 0),
  (18, '123', '1', 'DC11032019095838', 'aaaa', '123', 'unit1', '21', '25', 'a', '3', '2019-03-11 09:58:59', 1, 0),
  (19, '123', '1', 'DC17042019053959', 'test', 'test', 'unit1', '4', '10', 'a0909', '3', '2019-04-17 05:40:39', 0, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deliveryhub_admin`
  --
  
  CREATE TABLE `deliveryhub_admin` (
    `id` int(11) NOT NULL,
    `delhub_id` varchar(225) NOT NULL,
    `first_name` varchar(225) NOT NULL,
    `last_name` varchar(225) NOT NULL,
    `email_id` varchar(225) NOT NULL,
    `user_name` varchar(225) NOT NULL,
    `password` varchar(225) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `deliveryhub_admin`
  --
  
  INSERT INTO `deliveryhub_admin` (`id`, `delhub_id`, `first_name`, `last_name`, `email_id`, `user_name`, `password`, `status`, `created_on`) VALUES
  (11, '12', 'aaaaaa', 'aaaaa', 'divya.a@zenopsys.com', 'aaaaa', '123456', 1, '2019-04-05 10:14:07'),
  (12, '13', 'Mounika', 'Marella', 'mounika.m@zenopsys.com', 'mounika', '1234', 1, '2019-04-05 10:50:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deliveryhub_del_order`
  --
  
  CREATE TABLE `deliveryhub_del_order` (
    `id` int(11) NOT NULL,
    `kit_id` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `product_name` varchar(225) NOT NULL,
    `quanity` varchar(225) NOT NULL,
    `user_id` varchar(225) NOT NULL,
    `user_table` varchar(225) NOT NULL,
    `order_id` varchar(225) NOT NULL,
    `row_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `emp_id` varchar(225) NOT NULL,
    `main_address` varchar(225) NOT NULL,
    `branch_address` varchar(225) NOT NULL,
    `bundled_flag` varchar(225) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `deliveryhub_del_order`
  --
  
  INSERT INTO `deliveryhub_del_order` (`id`, `kit_id`, `product_sku`, `product_name`, `quanity`, `user_id`, `user_table`, `order_id`, `row_id`, `unique_order_id`, `emp_id`, `main_address`, `branch_address`, `bundled_flag`, `status`, `created_on`) VALUES
  (6, '123', '22222', 'test2222', '1', '29', '', 'OI29032019092920', 'c706cbf608244598b92fc2ffcd128117', '', '18', '', '', '', 0, '2019-04-16 08:05:38'),
  (7, '123', '22222', 'test2222', '1', '29', '', 'OI29032019092920', 'c706cbf608244598b92fc2ffcd128117', '', '17', '', '', '', 1, '2019-04-16 09:44:12'),
  (8, '123', 'sku_prod2', 'product2', '3', '28', '', 'OI19042019074513', '2f7232edcc6ed09586db8dac71c19784', '', '17', '', '', '', 1, '2019-04-19 08:10:39'),
  (9, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', '18', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 1, '2019-04-24 04:59:02'),
  (10, '123', '23w23', 'q22q2', '1', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', '18', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 1, '2019-04-24 04:59:09'),
  (11, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', '18', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 1, '2019-04-24 04:59:15'),
  (12, '123', '22222', 'test2222', '1', '28', 'individual_user_registration', 'OI240420190739331', 'f71a6154550d855091a2bc48634f65c3', 'UID24042019073951', '18', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 1, '2019-04-24 07:44:14'),
  (13, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', '18', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch', 'bundle', 0, '2019-04-24 09:24:52');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deliveryhub_register`
  --
  
  CREATE TABLE `deliveryhub_register` (
    `id` int(11) NOT NULL,
    `delhub_id` varchar(225) NOT NULL,
    `delhub_name` varchar(225) NOT NULL,
    `dh_address1` varchar(225) NOT NULL,
    `dh_address2` varchar(225) NOT NULL,
    `dh_address3` varchar(225) NOT NULL,
    `state` varchar(225) NOT NULL,
    `city` varchar(225) NOT NULL,
    `zipcode` varchar(225) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `deliveryhub_register`
  --
  
  INSERT INTO `deliveryhub_register` (`id`, `delhub_id`, `delhub_name`, `dh_address1`, `dh_address2`, `dh_address3`, `state`, `city`, `zipcode`, `status`, `created_on`) VALUES
  (11, '12', 'qwqwq', 'qqqq', 'qqqq', 'qqqq', 'qqqqq', 'qqqq', 'qqqqq', 0, '2019-04-05 10:00:53'),
  (13, '13', 'wwww1', 'wwww1', 'wwww1', 'wwwww1', 'wwww1', 'wwww1', 'wwwwww1', 0, '2019-04-05 10:49:14');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_address_confirmed`
  --
  
  CREATE TABLE `delivery_address_confirmed` (
    `id` int(11) NOT NULL,
    `order_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `user_id` varchar(225) NOT NULL,
    `user_type` varchar(225) NOT NULL,
    `main_address` varchar(225) NOT NULL,
    `branch_address` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `delivery_address_confirmed`
  --
  
  INSERT INTO `delivery_address_confirmed` (`id`, `order_id`, `unique_order_id`, `user_id`, `user_type`, `main_address`, `branch_address`) VALUES
  (1, 'OI22042019085331', 'UID22042019085341', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (2, 'OI24042019045333', 'UID24042019045347', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (3, 'OI24042019045333', 'UID24042019045402', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (4, 'OI24042019073933', 'UID24042019073951', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (5, 'OI29042019044351', 'UID29042019044814', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (6, 'OI30042019080856', 'UID30042019080909', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (7, 'OI09052019052458', 'UID09052019052822', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (8, 'OI16052019123452', 'UID16052019123502', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (9, 'OI17052019062956', 'UID17052019063927', '29', 'individual_user_registration', 'Bangalore,bsk 3rd stage,hoskerehalli%Karnataka%Bangalore', 'No Branch'),
  (10, 'OI17052019062956', 'UID17052019064221', '29', 'individual_user_registration', 'Bangalore,bsk 3rd stage,hoskerehalli%Karnataka%Bangalore', 'No Branch'),
  (11, 'OI17052019062956', 'UID17052019064920', '29', 'individual_user_registration', 'Bangalore,bsk 3rd stage,hoskerehalli%Karnataka%Bangalore', 'No Branch'),
  (12, 'OI23052019051719', 'UID23052019051726', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (13, 'OI27052019084242', 'UID27052019095058', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch'),
  (14, 'OI28052019063805', 'UID28052019063817', '28', 'individual_user_registration', 'aaaaa,aaaa,aaaaa%aaaa%aaaa', 'No Branch');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_employee`
  --
  
  CREATE TABLE `delivery_employee` (
    `id` int(11) NOT NULL,
    `del_id` varchar(225) NOT NULL,
    `emp_id` varchar(225) NOT NULL,
    `emp_name` varchar(225) NOT NULL,
    `Lname` varchar(225) NOT NULL,
    `Mname` varchar(225) NOT NULL,
    `Gender` varchar(225) NOT NULL,
    `emp_role` varchar(225) NOT NULL,
    `email_id` varchar(225) NOT NULL,
    `Blood` varchar(225) NOT NULL,
    `Birthdate` varchar(225) NOT NULL,
    `Joindate` varchar(225) NOT NULL,
    `mobile` varchar(225) NOT NULL,
    `emgcnt` varchar(225) NOT NULL,
    `aadhar` varchar(225) NOT NULL,
    `pan` varchar(225) NOT NULL,
    `pass` varchar(225) NOT NULL,
    `lic_no` varchar(225) NOT NULL,
    `vehicle_no` varchar(225) NOT NULL,
    `l_address1` varchar(225) NOT NULL,
    `l_address2` varchar(225) NOT NULL,
    `l_address3` varchar(225) NOT NULL,
    `state` varchar(225) NOT NULL,
    `city` varchar(225) NOT NULL,
    `zipcode` varchar(225) NOT NULL,
    `p_address1` varchar(225) NOT NULL,
    `p_address2` varchar(225) NOT NULL,
    `p_address3` varchar(225) NOT NULL,
    `p_state` varchar(225) NOT NULL,
    `p_city` varchar(225) NOT NULL,
    `p_zipcode` varchar(225) NOT NULL,
    `father_name` varchar(225) NOT NULL,
    `father_email` varchar(225) NOT NULL,
    `father_mobile` varchar(225) NOT NULL,
    `father_aadhar` varchar(225) NOT NULL,
    `mother_name` varchar(225) NOT NULL,
    `mother_email` varchar(225) NOT NULL,
    `mother_mobile` varchar(225) NOT NULL,
    `mother_aadhar` varchar(225) DEFAULT NULL,
    `bank_name` varchar(225) NOT NULL,
    `bank_acct` varchar(225) NOT NULL,
    `bank_branch` varchar(225) NOT NULL,
    `bank_ifsc` varchar(225) NOT NULL,
    `approve` tinyint(1) NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `delivery_employee`
  --
  
  INSERT INTO `delivery_employee` (`id`, `del_id`, `emp_id`, `emp_name`, `Lname`, `Mname`, `Gender`, `emp_role`, `email_id`, `Blood`, `Birthdate`, `Joindate`, `mobile`, `emgcnt`, `aadhar`, `pan`, `pass`, `lic_no`, `vehicle_no`, `l_address1`, `l_address2`, `l_address3`, `state`, `city`, `zipcode`, `p_address1`, `p_address2`, `p_address3`, `p_state`, `p_city`, `p_zipcode`, `father_name`, `father_email`, `father_mobile`, `father_aadhar`, `mother_name`, `mother_email`, `mother_mobile`, `mother_aadhar`, `bank_name`, `bank_acct`, `bank_branch`, `bank_ifsc`, `approve`, `status`) VALUES
  (17, '12', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'M', '9', 'aaaa', 'A-', '2019-04-09', '2019-04-16', 'aaaaaa', 'aaa', 'aaa', 'aaa', 'aa', 'aaa', 'aaa', 'aa1', 'aaa11', 'aaa111', 'aa1', '11', 'aa111', 'aa', 'aaa', 'aaa', 'aa', 'aa', 'aa', 'aa', 'aa', 'aaa', 'aa', 'a', 'aa', 'aaa', 'aa', 'a', 'aaa', 'a', 'aaa', 1, 0),
  (18, '13', 'dfsdf', 'sdfsdf', 'dsfsdf', 'dsf', 'F', '6', 'fdsfsdf', 'B+', '2019-04-10', '2019-04-16', 'sdfsdf', 'sdfsd', 'fsdfds', 'fdf', 'dfdsf', 'sdfsdf', 'sdf', 'sdf', 'dsfds', 'fsd', 'dfdsf', 'sdfdsf', 'sd', 'sdf', 'dsfds', 'fsd', 'dfdsf', 'sdfdsf', 'sd', 'dsf', 'dsfdsf', 'fd', 'fdsfd', 'fsdfds', 'd', 'fd', 'f', 'sdf', 'sdfsdfsdfds', 'df', 'fsdfs', 1, 0),
  (19, '13', 'dgfdg', 'gdfgd', 'fgdfgdfg', 'dfgdfg', 'M', '6', 'dfgfgdfg', 'A-', '2019-05-14', '2019-05-29', '5645654645', 'ghfgh', 'fhfghf', 'hfgh', 'hfghfgh', 'fhfgh', 'ghfghfgh', 'fghfgh', 'ghgfh', 'ffgh', 'fghfg', 'fghfh', 'fgh', 'fghfgh', 'ghgfh', 'ffgh', 'fghfg', 'fghfh', 'fgh', 'fghgfhgf', 'hgfh', 'fghgfh', 'ghgf', 'fhfh', 'fghfg', 'hgfhfg', 'hfghf', 'fghfghf', 'ghfg', 'hgfh', 'fghfg', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_emp_role`
  --
  
  CREATE TABLE `delivery_emp_role` (
    `id` int(11) NOT NULL,
    `role_name` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `delivery_emp_role`
  --
  
  INSERT INTO `delivery_emp_role` (`id`, `role_name`) VALUES
  (6, 'aaaaa1'),
  (7, 'bbbbb'),
  (9, 'dsdsds');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `delivery_kitchen_order`
  --
  
  CREATE TABLE `delivery_kitchen_order` (
    `id` int(11) NOT NULL,
    `kit_id` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `product_name` varchar(225) NOT NULL,
    `quantity` varchar(225) NOT NULL,
    `user_id` varchar(225) NOT NULL,
    `user_table` varchar(225) NOT NULL,
    `order_id` varchar(225) NOT NULL,
    `row_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `bundled_flag` varchar(225) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `accept` tinyint(1) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `delivery_kitchen_order`
  --
  
  INSERT INTO `delivery_kitchen_order` (`id`, `kit_id`, `product_sku`, `product_name`, `quantity`, `user_id`, `user_table`, `order_id`, `row_id`, `unique_order_id`, `bundled_flag`, `status`, `accept`, `created_on`) VALUES
  (3, '123', '22222', 'test2222', '1', '29', '', 'OI29032019092920', 'c706cbf608244598b92fc2ffcd128117', '', '', 1, 0, '2019-03-29 09:44:37'),
  (4, '123', 'sku_prod2', 'product2', '3', '28', '', 'OI19042019074513', '2f7232edcc6ed09586db8dac71c19784', '', '', 1, 1, '2019-04-19 07:47:58'),
  (5, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', 'bundle', 1, 1, '2019-04-24 04:57:09'),
  (6, '123', '23w23', 'q22q2', '1', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', 'bundle', 1, 1, '2019-04-24 04:57:09'),
  (7, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', 'bundle', 1, 1, '2019-04-24 04:57:09'),
  (8, '123', '22222', 'test2222', '1', '28', 'individual_user_registration', 'OI24042019073933', 'f71a6154550d855091a2bc48634f65c3', 'UID24042019073951', 'bundle', 1, 1, '2019-04-24 07:43:05'),
  (9, '123', 'est1', 'test1', '3<br>', '28', 'individual_user_registration', 'OI24042019045333', '321e03372bc84e4f7c12b5caf43bd7d7', 'UID24042019045402', 'bundle', 1, 1, '2019-04-24 09:11:57');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `emp_role_master`
  --
  
  CREATE TABLE `emp_role_master` (
    `id` int(11) NOT NULL,
    `emp_role` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `emp_role_master`
  --
  
  INSERT INTO `emp_role_master` (`id`, `emp_role`) VALUES
  (4, 'superadmin1'),
  (5, '457'),
  (7, 'superadmin');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `grid_master`
  --
  
  CREATE TABLE `grid_master` (
    `id` int(11) NOT NULL,
    `grid_name` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `grid_master`
  --
  
  INSERT INTO `grid_master` (`id`, `grid_name`) VALUES
  (8, '1'),
  (9, 'Grid1'),
  (10, 'grid2');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `individual_user_registration`
  --
  
  CREATE TABLE `individual_user_registration` (
    `id` int(11) NOT NULL,
    `user_title` varchar(225) DEFAULT NULL,
    `first_name` varchar(225) DEFAULT NULL,
    `middle_name` varchar(225) DEFAULT NULL,
    `last_name` varchar(225) DEFAULT NULL,
    `email` varchar(225) DEFAULT NULL,
    `phone_number` varchar(225) DEFAULT NULL,
    `dob` date DEFAULT NULL,
    `blood_group` varchar(225) DEFAULT NULL,
    `meal_type` varchar(225) DEFAULT NULL,
    `address` varchar(225) DEFAULT NULL,
    `city` varchar(225) DEFAULT NULL,
    `state` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `individual_user_registration`
  --
  
  INSERT INTO `individual_user_registration` (`id`, `user_title`, `first_name`, `middle_name`, `last_name`, `email`, `phone_number`, `dob`, `blood_group`, `meal_type`, `address`, `city`, `state`) VALUES
  (28, 'Mr', 'ved', 'ved', 'r', 'vedavith.r@zenopsys.com', '1234567890', '2019-02-26', 'a+', 'Veg', 'aaaaa,aaaa,aaaaa', 'aaaa', 'aaaa'),
  (29, 'Dr', 'zenopsys', 'zen', 'Marella', 'zenopsys@gmail.com', '9903270923', '2019-03-16', 'A+', 'non_veg', 'Bangalore,bsk 3rd stage,hoskerehalli', 'Bangalore', 'Karnataka'),
  (30, 'Ms', 'Carol', 'Avenger', 'Danevers', 'vedavithravula1996@gmail.com', '9160700733', '2019-04-15', 'A+', 'Veg', '2-12-265,Vidhyaranyapuri,opp ku 2nd gate, Hanamkonda', 'Warangal', 'Telangana'),
  (31, 'Ms', 'rani8', 'r8', 'rr', 'rrr', '8989898988', '2019-05-30', 'y8', 'non_veg', '8rtrttr,rtrtr8,rtrtrt8', 'rtrt8', 'rtrtr8');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_123`
  --
  
  CREATE TABLE `insert_inventory_kitchen_123` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `insert_inventory_kitchen_123`
  --
  
  INSERT INTO `insert_inventory_kitchen_123` (`id`, `product_name`, `product_sku`, `product_units`, `product_quantity`, `timestamp`) VALUES
  (1, 'product1', '23', 'unit1', '2', '2019-02-26 10:03:25.671983'),
  (2, 'jaggery', 'jaggery78', 'unit1', '11', '2019-03-12 04:48:34.160202'),
  (3, 'Sugar', 'sugarsale32', 'unit1', '34', '2019-03-12 04:48:49.465578'),
  (4, 'aaa', 'aa', 'aa', '25', '2019-03-15 06:57:43.092435'),
  (5, 'aaaa', '123', 'unit1', '21', '2019-03-15 06:57:49.421809');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_125`
  --
  
  CREATE TABLE `insert_inventory_kitchen_125` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `insert_inventory_kitchen_125`
  --
  
  INSERT INTO `insert_inventory_kitchen_125` (`id`, `product_name`, `product_sku`, `product_units`, `product_quantity`, `timestamp`) VALUES
  (1, 'product1', '23', 'unit1', '125', '2019-02-28 06:08:38.734724'),
  (2, 'product2', '24', 'unit1', '75', '2019-02-28 06:08:38.736688');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_1234`
  --
  
  CREATE TABLE `insert_inventory_kitchen_1234` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_4032`
  --
  
  CREATE TABLE `insert_inventory_kitchen_4032` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_kit55`
  --
  
  CREATE TABLE `insert_inventory_kitchen_kit55` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_inventory_kitchen_kit123`
  --
  
  CREATE TABLE `insert_inventory_kitchen_kit123` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` text,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_kitchen_assign_product_kit55`
  --
  
  CREATE TABLE `insert_kitchen_assign_product_kit55` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `custom_products` varchar(225) NOT NULL DEFAULT 'NULL',
    `estimated_units` varchar(100) NOT NULL DEFAULT 'NULL'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `insert_kitchen_assign_product_kit55`
  --
  
  INSERT INTO `insert_kitchen_assign_product_kit55` (`id`, `product_name`, `product_sku`, `custom_products`, `estimated_units`) VALUES
  (1, 'meals', 'meals123', 'None', '50'),
  (2, 'q22q2', '23w23', 'test1,product1', '50');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `insert_kitchen_assign_product_kit123`
  --
  
  CREATE TABLE `insert_kitchen_assign_product_kit123` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `estimated_units` varchar(100) NOT NULL DEFAULT 'NULL'
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `insert_kitchen_assign_product_kit123`
  --
  
  INSERT INTO `insert_kitchen_assign_product_kit123` (`id`, `product_name`, `product_sku`, `estimated_units`) VALUES
  (1, 'product1', 'sku_prod1', '30'),
  (2, 'meals', 'meals123', '100'),
  (3, 'eee123', 'eee123', '100');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_admin`
  --
  
  CREATE TABLE `kitchen_admin` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(255) NOT NULL,
    `first_name` varchar(255) NOT NULL,
    `last_name` varchar(255) NOT NULL,
    `email_id` varchar(255) NOT NULL,
    `user_name` varchar(255) NOT NULL,
    `password` varchar(100) NOT NULL,
    `status` int(11) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_admin`
  --
  
  INSERT INTO `kitchen_admin` (`id`, `kitchen_id`, `first_name`, `last_name`, `email_id`, `user_name`, `password`, `status`, `created_on`) VALUES
  (40, 'kit123', 'aaa', 'aaaa', 'aaa123@aa.com', 'kitchen_demo', '1234', 1, '2019-04-29 05:40:25'),
  (33, '125', 'ved', 'ved', 'vedavith.r@zenopsys.com', 'ved', 'admin@123', 0, '2019-02-12 10:58:41'),
  (37, '123', 'mounikam', 'm123', 'mounika.m@zenopsys.com', 'mounika', '12345', 1, '2019-03-11 10:51:42'),
  (42, 'kit55', 'aaaa', 'aaaa', 'kitchen_demo@email.com', 'kitchen_demo1', '1234', 0, '2019-05-02 06:25:30');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_assigned_products`
  --
  
  CREATE TABLE `kitchen_assigned_products` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `assigned_orders` varchar(225) NOT NULL,
    `date` date NOT NULL,
    `order_flag` int(11) NOT NULL,
    `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_assigned_products`
  --
  
  INSERT INTO `kitchen_assigned_products` (`id`, `kitchen_id`, `product_sku`, `assigned_orders`, `date`, `order_flag`, `time_stamp`) VALUES
  (18, 'kit55', '23w23', '1', '2019-05-30', 0, '2019-05-28 07:57:18');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_employee`
  --
  
  CREATE TABLE `kitchen_employee` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `emp_id` varchar(225) NOT NULL,
    `emp_name` varchar(225) NOT NULL,
    `Lname` varchar(225) NOT NULL,
    `Mname` varchar(225) NOT NULL,
    `Gender` varchar(225) NOT NULL,
    `emp_role` varchar(225) NOT NULL,
    `email_id` varchar(225) NOT NULL,
    `Blood` varchar(225) NOT NULL,
    `Birthdate` varchar(225) NOT NULL,
    `Joindate` varchar(225) NOT NULL,
    `mobile` varchar(225) NOT NULL,
    `emgcnt` varchar(225) NOT NULL,
    `aadhar` varchar(225) NOT NULL,
    `pan` varchar(225) NOT NULL,
    `pass` varchar(225) NOT NULL,
    `l_address1` varchar(225) NOT NULL,
    `l_address2` varchar(225) NOT NULL,
    `l_address3` varchar(225) NOT NULL,
    `state` varchar(225) NOT NULL,
    `city` varchar(225) NOT NULL,
    `zipcode` varchar(225) NOT NULL,
    `p_address1` varchar(225) NOT NULL,
    `p_address2` varchar(225) NOT NULL,
    `p_address3` varchar(225) NOT NULL,
    `p_state` varchar(225) NOT NULL,
    `p_city` varchar(225) NOT NULL,
    `p_zipcode` varchar(225) NOT NULL,
    `father_name` varchar(225) NOT NULL,
    `father_email` varchar(225) NOT NULL,
    `father_mobile` varchar(225) NOT NULL,
    `father_aadhar` varchar(225) NOT NULL,
    `mother_name` varchar(225) NOT NULL,
    `mother_email` varchar(225) NOT NULL,
    `mother_mobile` varchar(225) NOT NULL,
    `mother_aadhar` varchar(225) DEFAULT NULL,
    `bank_name` varchar(225) NOT NULL,
    `bank_acct` varchar(225) NOT NULL,
    `bank_branch` varchar(225) NOT NULL,
    `bank_ifsc` varchar(225) NOT NULL,
    `approve` tinyint(1) NOT NULL,
    `status` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_employee`
  --
  
  INSERT INTO `kitchen_employee` (`id`, `kitchen_id`, `emp_id`, `emp_name`, `Lname`, `Mname`, `Gender`, `emp_role`, `email_id`, `Blood`, `Birthdate`, `Joindate`, `mobile`, `emgcnt`, `aadhar`, `pan`, `pass`, `l_address1`, `l_address2`, `l_address3`, `state`, `city`, `zipcode`, `p_address1`, `p_address2`, `p_address3`, `p_state`, `p_city`, `p_zipcode`, `father_name`, `father_email`, `father_mobile`, `father_aadhar`, `mother_name`, `mother_email`, `mother_mobile`, `mother_aadhar`, `bank_name`, `bank_acct`, `bank_branch`, `bank_ifsc`, `approve`, `status`) VALUES
  (2, '123', '12345', 'zenopsys Marella', 'Marella', 'rty', 'M', '4', 'a1@g.com', 'A-', '2019-03-25', '2019-03-14', '4735743957943', '47666878988', '46576578', '6876876', '8768768', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 'prasad', 'a1@g.com', '4735743957943', '324354645656', 'vijaya', 'a1@g.com', '4735743957943', NULL, 'andhra', '23534645567', 'prathipadu', '6456346456', 1, 0),
  (5, '123', '1239', 'zenopsys', 'evolve', 'zen', 'M', '4', 'zenopsys@gmail.com56', 'A-', '1995-01-10', '2019-02-27', '4735743957943', '47666878988', '46576578', '6876876', '8768768', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka1', 'Bangalore1', '590324', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka1', 'Bangalore1', '590324', 'prasad', 'zenopsys@gmail.com', '4735743957943', '324354645656', 'vijaya', 'zenopsys@gmail.com', '4735743957943', '6546546546546', 'andhra', '23534645567', 'prathipadu9', '6456346456', 1, 1),
  (6, '123', '12350', 'zenopsys Marella', 'Marella', 'rty444', 'F', '4', 'zenopsys@gmail.com', 'B+', '2019-03-14', '2019-03-28', '4735743957943', '47666878988', '46576578', '6876876', '8768768', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 'prasad', 'zenopsys@gmail.com', '4735743957943', '324354645656', 'vijaya', 'mounika@zenopsys.com', '4735743957943', '6546546546546', 'andhra', '23534645567', 'prathipadu', '6456346456', 1, 0),
  (7, '1234', '1234aaaa', 'aaaa', 'aaaa', 'aaa', 'M', '7', 'aaaa', 'A-', '2019-03-26', '2019-04-02', 'aaaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaaa', 'aaaa', 'aaaa1223', 'aaaa', 'aaaaa', 'aaaaa', 'aaaaa', 'aaaa', 'aaaaa', 'aaaa', 'aaaa123', 'aaaa', 'aaaaa', 'aaaaa', 1, 0),
  (8, '123', '1230', 'zenopsys', 'Marella', 'zen', 'M', '4', 'uyoiuoyuo@g.com', 'A-', '2019-03-01', '2019-03-01', '4735743957943', '47666878988', '46576578', '6876876', '8768768', 'Bangalore', 'gfhgfhfg', 'fghfhfghfgh', 'Karnataka', 'Bangalore', '590324', 'Bangalore', 'gfhgfhfg', 'fghfhfghfgh', 'Karnataka', 'Bangalore', '590324', 'prasad', 'zenopsys@gmail.com', '4735743957943', '324354645656', 'vijaya', 'a2@g.com', '4735743957943', '6546546546546', 'andhra', '23534645567', 'prathipadu', '6456346456', 1, 1),
  (9, '125', '123457', 'zenopsys', 'Marella', 'zen', 'M', '4', 'fhfghfgh9@g.com', 'A+', '2019-03-01', '2019-03-29', '4735743957943', '47666878988', '46576578', '6876876', '8768768', 'Bangalore', 'gfhgfhfg', 'fghfhfghfgh', 'Karnataka', 'Bangalore', '590324', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 'prasad', 'a2@g.com', '4735743957943', '324354645656', 'rama', '2@g.c', '4735743957943', '650099', 'andhra', '23534645567', 'fghfgh1', '6456346456', 1, 1),
  (10, '123', '2323', '222', '2222', '2222', 'F', '5', '222222222222', 'A-', '2019-04-16', '2019-04-21', '776767656', '6576', '7667', '667', '7666', '666', '66', '66767', '76776', '667', '66', '666', '66', '66767', '76776', '667', '66', '677676', '7667', '7676', '76766', '65555', '566567', '766776', '67667', '66776', '767676', '76767', '77776', 1, 1),
  (11, 'kit123', 'rrrr', 'rrr', 'rrrrrr', 'rrr', 'M', '4', 'rrrrr', 'A-', '2019-05-07', '2019-05-28', 'rrrr', 'rrr', 'rr', 'rrr', 'rr', 'rr', 'rr', 'rr', 'r', 'rr', 'rrr', 'rr', 'rr', 'rr', 'r', 'rr', 'rrr', 'r', 'rr', 'rr', 'r', 'rr', 'r', 'rr', 'r', 'r', 'rr', 'rr', 'r', 1, 0),
  (12, '123', 'wewew', 'wewewe', 'wewewe', 'wewew', 'M', '4', 'weww', 'B+', '2019-05-07', '2019-05-14', 'w454545', 'wwew', 'ewe', 'wewew', 'ewewe', 'ww', 'wewe', 'wewe', 'e', 'we', 'wewew', 'ww', 'wewe', 'wewe', 'e', 'we', 'wewew', 'wewe', 'wewe', 'wewe', 'ewe', 'wew', 'ewe', 'ewew', 'ewew', '3434', '343', '43', '34', 1, 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_emp_attendance`
  --
  
  CREATE TABLE `kitchen_emp_attendance` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `employee_id` varchar(225) NOT NULL,
    `employee_name` varchar(225) NOT NULL,
    `employee_role` varchar(225) NOT NULL,
    `set_date` date NOT NULL,
    `attendance_flag` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_emp_attendance`
  --
  
  INSERT INTO `kitchen_emp_attendance` (`id`, `kitchen_id`, `employee_id`, `employee_name`, `employee_role`, `set_date`, `attendance_flag`) VALUES
  (1, '123', '12345', 'zenopsys Marella', 'superadmin1', '2019-03-22', '1'),
  (2, '123', '123', 'zenopsys', 'superadmin1', '2019-03-22', '1'),
  (3, '123', '12358', 'zenopsys', '457', '2019-03-22', '1'),
  (4, '123', '1239', 'zenopsys', 'superadmin1', '2019-03-25', '1'),
  (5, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-03-25', '1'),
  (6, '123', '1230', 'zenopsys', 'superadmin1', '2019-03-25', '1'),
  (7, '123', '1239', 'zenopsys', 'superadmin1', '2019-03-27', '1'),
  (8, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-03-27', '1'),
  (9, '123', '1230', 'zenopsys', 'superadmin1', '2019-03-27', '1'),
  (10, '123', '1239', 'zenopsys', 'superadmin1', '2019-03-28', '1'),
  (11, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-03-28', '1'),
  (12, '123', '1230', 'zenopsys', 'superadmin1', '2019-03-28', '1'),
  (13, '123', '1239', 'zenopsys', 'superadmin1', '2019-04-03', '1'),
  (14, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-04-03', '1'),
  (15, '123', '1230', 'zenopsys', 'superadmin1', '2019-04-03', '1'),
  (16, '123', '2323', '222', '457', '2019-04-03', '1'),
  (17, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-04-16', '1'),
  (18, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-04-19', '0'),
  (19, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-04-24', '0'),
  (20, '123', '12350', 'zenopsys Marella', 'superadmin1', '2019-05-02', '0');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_master`
  --
  
  CREATE TABLE `kitchen_master` (
    `id` int(11) NOT NULL,
    `email_id` varchar(225) DEFAULT NULL,
    `password` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `kitchen_master`
  --
  
  INSERT INTO `kitchen_master` (`id`, `email_id`, `password`) VALUES
  (1, 'test', 'test');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_product_master`
  --
  
  CREATE TABLE `kitchen_product_master` (
    `id` int(11) NOT NULL,
    `product_name` varchar(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_product_master`
  --
  
  INSERT INTO `kitchen_product_master` (`id`, `product_name`) VALUES
  (1, 'product1'),
  (2, 'product2');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kitchen_register`
  --
  
  CREATE TABLE `kitchen_register` (
    `id` int(11) NOT NULL,
    `k_id` varchar(255) NOT NULL,
    `k_name` varchar(255) NOT NULL,
    `kitchen_type` varchar(255) NOT NULL,
    `k_address1` varchar(255) NOT NULL,
    `k_address2` varchar(255) NOT NULL,
    `k_address3` varchar(255) NOT NULL,
    `state` varchar(255) NOT NULL,
    `city` varchar(255) NOT NULL,
    `zipcode` varchar(255) NOT NULL,
    `status` int(11) NOT NULL,
    `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kitchen_register`
  --
  
  INSERT INTO `kitchen_register` (`id`, `k_id`, `k_name`, `kitchen_type`, `k_address1`, `k_address2`, `k_address3`, `state`, `city`, `zipcode`, `status`, `created_on`) VALUES
  (3, '123', 'aaaa12', 'other', 'aaaaa1', 'aaaaa12', 'aaaaa12', 'aaaaa12', 'aaaaa12', 'aaaaa', 0, '2019-02-12 10:51:46'),
  (4, '125', 'bbbb', 'other', 'bbbb', 'bbbb', 'bbbb', 'bbbb', 'bbbb', 'bbbb', 0, '2019-02-12 10:52:15'),
  (5, '345', 'aaasds', 'company', 'aqaqqq', 'aqaqaq', 'q2qqaqq', 'qqqq', 'qqqqq', 'qqqaa', 0, '2019-02-13 12:43:38'),
  (7, '4032', 'annapurna', 'other', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka1', 'Bangalore', '590324', 0, '2019-03-08 08:05:49'),
  (8, '1234', 'abc0', 'company', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka', 'Bangalore', '590324', 0, '2019-03-12 07:08:37'),
  (9, 'kit123', 'testd', 'company', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 'aaa', 0, '2019-04-29 05:39:26'),
  (10, 'kit55', 'kit55', 'company', 'aaaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 'aaaa', 0, '2019-05-02 06:25:03');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `meal_plan_master`
  --
  
  CREATE TABLE `meal_plan_master` (
    `id` int(11) NOT NULL,
    `meal_plan` varchar(100) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `meal_plan_master`
  --
  
  INSERT INTO `meal_plan_master` (`id`, `meal_plan`) VALUES
  (2, 'lunch'),
  (3, 'dinner');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `meal_preference_master`
  --
  
  CREATE TABLE `meal_preference_master` (
    `id` int(11) NOT NULL,
    `meal_preference` varchar(100) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `meal_preference_master`
  --
  
  INSERT INTO `meal_preference_master` (`id`, `meal_preference`) VALUES
  (1, 'veg'),
  (2, 'non-veg');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `version` bigint(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`version`) VALUES
  (0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notifications`
  --
  
  CREATE TABLE `notifications` (
    `id` int(11) NOT NULL,
    `message` varchar(225) NOT NULL,
    `time_stamp` date NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `notifications`
  --
  
  INSERT INTO `notifications` (`id`, `message`, `time_stamp`) VALUES
  (1, 'testtttttt', '2019-03-04'),
  (3, 'aaaaa', '2019-03-04');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notification_kitchen`
  --
  
  CREATE TABLE `notification_kitchen` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `message` text NOT NULL,
    `notify_flag` tinyint(1) NOT NULL,
    `kit_flag` varchar(225) NOT NULL DEFAULT '0',
    `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `notification_kitchen`
  --
  
  INSERT INTO `notification_kitchen` (`id`, `kitchen_id`, `message`, `notify_flag`, `kit_flag`, `time_stamp`) VALUES
  (23, 'kit55', 'we have assigned SKU Id 23w23 Quantity of 1 For Date 2019-05-30', 1, '0', '2019-05-28 07:57:18');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `optional_product_cart`
  --
  
  CREATE TABLE `optional_product_cart` (
    `id` int(11) NOT NULL,
    `user_id` varchar(225) DEFAULT NULL,
    `user_table` varchar(225) DEFAULT NULL,
    `order_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `rowid` varchar(225) NOT NULL,
    `product_name` varchar(225) DEFAULT NULL,
    `product_sku` varchar(225) NOT NULL,
    `price` varchar(225) DEFAULT NULL,
    `quantity` varchar(225) DEFAULT NULL,
    `bundled_flag` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `optional_product_cart`
  --
  
  INSERT INTO `optional_product_cart` (`id`, `user_id`, `user_table`, `order_id`, `unique_order_id`, `rowid`, `product_name`, `product_sku`, `price`, `quantity`, `bundled_flag`) VALUES
  (37, '28', 'individual_user_registration', 'OI28052019063805', 'UID28052019063817', '218c8d7eeaac1605cd61ca0a1736a022', 'test1', 'est1', '100', '1<br>', 'bundle'),
  (38, '28', 'individual_user_registration', 'OI28052019063805', 'UID28052019063817', '218c8d7eeaac1605cd61ca0a1736a022', 'product1', 'sku_prod1', '200', '1<br>', 'bundle'),
  (39, '28', 'individual_user_registration', 'OI28052019080907', 'UID28052019080922', '526a18fd8a9a0b74ae6991068d7b71c0', 'meals', 'meals123', '248', '1<br>', 'bundle'),
  (40, '28', 'individual_user_registration', 'OI28052019080907', 'UID28052019081042', '526a18fd8a9a0b74ae6991068d7b71c0', 'meals', 'meals123', '248', '1<br>', 'bundle'),
  (41, '28', 'individual_user_registration', 'OI29052019081204', 'UID29052019081215', '218c8d7eeaac1605cd61ca0a1736a022', 'test1', 'est1', '100', '1<br>', 'bundle'),
  (42, '28', 'individual_user_registration', 'OI29052019081204', 'UID29052019081215', '218c8d7eeaac1605cd61ca0a1736a022', 'product1', 'sku_prod1', '200', '1<br>', 'bundle');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payments`
  --
  
  CREATE TABLE `payments` (
    `txn_id` int(10) DEFAULT NULL,
    `PaymentMethod` varchar(6) DEFAULT NULL,
    `PayerStatus` varchar(8) DEFAULT NULL,
    `PayerMail` int(1) DEFAULT NULL,
    `Total` decimal(6,2) DEFAULT NULL,
    `SubTotal` decimal(6,2) DEFAULT NULL,
    `Tax` decimal(3,2) DEFAULT NULL,
    `Payment_state` varchar(9) DEFAULT NULL,
    `CreateTime` varchar(20) DEFAULT NULL,
    `UpdateTime` varchar(20) DEFAULT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `payments`
  --
  
  INSERT INTO `payments` (`txn_id`, `PaymentMethod`, `PayerStatus`, `PayerMail`, `Total`, `SubTotal`, `Tax`, `Payment_state`, `CreateTime`, `UpdateTime`) VALUES
  (4, 'paypal', 'VERIFIED', 0, '305.00', '305.00', '0.00', 'completed', '2019-03-29T09:06:33Z', '2019-03-29T09:06:33Z'),
  (24760385, 'paypal', 'VERIFIED', 0, '203.00', '203.00', '0.00', 'completed', '2019-03-29T09:32:23Z', '2019-03-29T09:32:23Z'),
  (8, 'paypal', 'VERIFIED', 0, '100.00', '100.00', '0.00', 'completed', '2019-04-08T00:17:39Z', '2019-04-08T00:17:39Z'),
  (4, 'paypal', 'VERIFIED', 0, '100.00', '100.00', '0.00', 'completed', '2019-04-19T07:46:58Z', '2019-04-19T07:46:58Z'),
  (4, 'paypal', 'VERIFIED', 0, '100.00', '100.00', '0.00', 'completed', '2019-04-22T10:48:55Z', '2019-04-22T10:48:55Z'),
  (9, 'paypal', 'VERIFIED', 0, '405.00', '405.00', '0.00', 'completed', '2019-04-24T04:54:45Z', '2019-04-24T04:54:45Z'),
  (0, 'paypal', 'VERIFIED', 0, '703.00', '703.00', '0.00', 'completed', '2019-04-24T07:40:38Z', '2019-04-24T07:40:38Z'),
  (2, 'paypal', 'VERIFIED', 0, '744.00', '744.00', '0.00', 'completed', '2019-04-29T04:54:48Z', '2019-04-29T04:54:48Z'),
  (79512540, 'paypal', 'VERIFIED', 0, '1525.00', '1525.00', '0.00', 'completed', '2019-04-30T08:12:45Z', '2019-04-30T08:12:45Z'),
  (3, 'paypal', 'VERIFIED', 0, '2800.00', '2800.00', '0.00', 'completed', '2019-05-09T05:29:13Z', '2019-05-09T05:29:13Z'),
  (17, 'paypal', 'VERIFIED', 0, '45.00', '45.00', '0.00', 'completed', '2019-05-16T11:51:01Z', '2019-05-16T11:51:01Z'),
  (0, 'paypal', 'VERIFIED', 0, '800.00', '800.00', '0.00', 'completed', '2019-05-16T12:38:56Z', '2019-05-16T12:38:56Z'),
  (7, 'paypal', 'VERIFIED', 0, '2400.00', '2400.00', '0.00', 'completed', '2019-05-17T06:40:18Z', '2019-05-17T06:40:18Z'),
  (5, 'paypal', 'VERIFIED', 0, '1400.00', '1400.00', '0.00', 'completed', '2019-05-17T06:42:59Z', '2019-05-17T06:42:59Z'),
  (72, 'paypal', 'VERIFIED', 0, '2800.00', '2800.00', '0.00', 'completed', '2019-05-17T06:49:53Z', '2019-05-17T06:49:53Z'),
  (1, 'paypal', 'VERIFIED', 0, '6944.00', '6944.00', '0.00', 'completed', '2019-05-23T05:32:49Z', '2019-05-23T05:32:49Z'),
  (8, 'paypal', 'VERIFIED', 0, '3355.00', '3355.00', '0.00', 'completed', '2019-05-27T09:52:19Z', '2019-05-27T09:52:19Z'),
  (7, 'paypal', 'VERIFIED', 0, '2440.00', '2440.00', '0.00', 'completed', '2019-05-28T06:39:31Z', '2019-05-28T06:39:31Z');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `primary_product_inventory_insert`
  --
  
  CREATE TABLE `primary_product_inventory_insert` (
    `id` int(11) NOT NULL,
    `product_name` varchar(45) DEFAULT NULL,
    `product_sku` varchar(45) DEFAULT NULL,
    `primary_units` varchar(45) DEFAULT NULL,
    `secondary_units` varchar(45) DEFAULT NULL,
    `store_name` varchar(45) DEFAULT NULL,
    `rgb_combo` varchar(45) DEFAULT NULL,
    `quantity` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `primary_product_inventory_insert`
  --
  
  INSERT INTO `primary_product_inventory_insert` (`id`, `product_name`, `product_sku`, `primary_units`, `secondary_units`, `store_name`, `rgb_combo`, `quantity`) VALUES
  (1, 'aaaa', '123', 'unit1', 'unit1', 'a', '3', '25'),
  (2, 'test', 'test', 'unit1', 'units2', 'a0909', '3', '10'),
  (3, 'aaaa', '123', 'unit1', 'unit1', 'test1', '5', '2');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `primary_product_inventory_update`
  --
  
  CREATE TABLE `primary_product_inventory_update` (
    `id` int(11) NOT NULL,
    `product_name` varchar(45) DEFAULT NULL,
    `product_sku` varchar(45) DEFAULT NULL,
    `primary_units` varchar(45) DEFAULT NULL,
    `secondary_units` varchar(45) DEFAULT NULL,
    `store_name` varchar(45) DEFAULT NULL,
    `rgb_combo` varchar(45) DEFAULT NULL,
    `addordel` varchar(45) DEFAULT NULL,
    `quantity` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `primary_product_inventory_update`
  --
  
  INSERT INTO `primary_product_inventory_update` (`id`, `product_name`, `product_sku`, `primary_units`, `secondary_units`, `store_name`, `rgb_combo`, `addordel`, `quantity`) VALUES
  (7, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '10'),
  (8, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '3'),
  (9, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '3'),
  (10, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '3'),
  (11, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '3'),
  (12, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '10'),
  (13, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '45'),
  (14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  (15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  (16, 'test', 'test', 'unit1', 'units2', 'a', '3', 'd', '5'),
  (17, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '40'),
  (18, 'test', 'test', 'unit1', 'units2', 'a', '3', 'd', '10'),
  (19, 'test', 'test', 'unit1', 'units2', 'a', '3', 'd', ''),
  (20, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '73'),
  (21, 'test', 'test', 'unit1', 'units2', 'a', '3', 'a', '23'),
  (22, 'test', 'test', 'unit1', 'units2', 'a', '3', 'd', '24'),
  (23, 'aaa', 'aa', 'aa', 'aa', 'a', '3', 'a', '10'),
  (24, 'aaa', 'aa', 'aa', 'aa', 'a', '3', 'd', '10'),
  (25, 'Sugar', 'sugarsale32', 'unit1', 'unit1', 'a', '4', 'a', '100'),
  (26, 'jaggery', 'jaggery78', 'unit1', 'unit1', 'test1', '5', 'a', '90'),
  (27, 'jaggery', 'jaggery78', 'unit1', 'unit1', 'test1', '5', 'a', '90'),
  (28, 'jaggery', 'jaggery78', 'unit1', 'unit1', 'test1', '5', 'd', '90'),
  (29, 'jaggery', 'jaggery78', 'unit1', 'unit1', 'test1', '5', 'a', '85'),
  (30, 'aaaa', '123', 'unit1', 'unit1', 'a', '3', 'a', '25'),
  (31, 'jaggery', 'jaggery78', 'unit1', 'unit1', 'a0909', '3', 'a', '100'),
  (32, 'test', 'test', 'unit1', 'units2', 'a0909', '3', 'a', '10'),
  (33, 'aaaa', '123', 'unit1', 'unit1', 'test1', '5', 'a', '2');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `primary_stock_products`
  --
  
  CREATE TABLE `primary_stock_products` (
    `id` int(11) NOT NULL,
    `product_name` varchar(225) DEFAULT NULL,
    `product_sku` varchar(225) DEFAULT NULL,
    `primary_units` varchar(225) DEFAULT NULL,
    `secondary_units` varchar(225) DEFAULT NULL,
    `product_description` varchar(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `primary_stock_products`
  --
  
  INSERT INTO `primary_stock_products` (`id`, `product_name`, `product_sku`, `primary_units`, `secondary_units`, `product_description`) VALUES
  (1, 'test', 'test', 'unit1', 'units2', 'this is description'),
  (3, 'Sugar', 'sugarsale32', 'unit1', 'unit1', 'Sugar is sweet'),
  (4, 'jaggery', 'jaggery78', 'unit1', 'unit1', ' jaggery 11'),
  (5, 'aaaa', '123', 'unit1', 'unit1', 'qwq'),
  (6, 'aa1', 'aa', 'unit33', 'unit33', ' aaaa 11111');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_cart`
  --
  
  CREATE TABLE `product_cart` (
    `id` int(11) NOT NULL,
    `user_id` varchar(45) DEFAULT NULL,
    `user_table` varchar(225) DEFAULT NULL,
    `order_id` varchar(225) NOT NULL,
    `unique_order_id` varchar(225) NOT NULL,
    `rowid` varchar(225) DEFAULT NULL,
    `product_sku` varchar(225) DEFAULT NULL,
    `product_name` varchar(225) DEFAULT NULL,
    `price` varchar(225) DEFAULT NULL,
    `quantity` varchar(225) DEFAULT NULL,
    `bundled_flag` varchar(225) NOT NULL,
    `confirm_flag` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Stand-in structure for view `product_concat`
  -- (See below for the actual view)
  --
  CREATE TABLE `product_concat` (
  `name` varchar(225)
  ,`sku` varchar(225)
  ,`price` varchar(225)
  ,`quantity` varchar(225)
  ,`unique_order_id` varchar(225)
  ,`optional_sku` text
  ,`optional_name` text
  ,`optional_quantity` text
  );
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_image`
  --
  
  CREATE TABLE `product_image` (
    `id` int(11) NOT NULL,
    `product_sku` varchar(45) NOT NULL,
    `image1` varchar(45) DEFAULT NULL,
    `image2` varchar(45) DEFAULT NULL,
    `image3` varchar(45) DEFAULT NULL,
    `image4` varchar(45) DEFAULT NULL,
    `image5` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `product_image`
  --
  
  INSERT INTO `product_image` (`id`, `product_sku`, `image1`, `image2`, `image3`, `image4`, `image5`) VALUES
  (5, 'est1', 'uploads/food3.jpeg', 'uploads/food3.jpeg', 'uploads/1549279332pattern6.png', 'uploads/1549279332pattern5.png', 'uploads/1549279332pattern8.png'),
  (6, 'sku_prod1', 'uploads/food1.jpeg', 'uploads/1549341529pattern2.png', 'uploads/food1.jpeg', 'uploads/1549341529pattern7.png', 'uploads/1549341529pattern7.png'),
  (7, 'sku_prod2', 'uploads/food2.jpeg', 'uploads/1549341748pattern5.png', 'uploads/1549341748pattern5.png', 'uploads/1549341748pattern5.png', 'uploads/1549341748pattern5.png'),
  (8, 'meals123', 'uploads/1552297813food4.jpeg', 'uploads/1552297813food3.jpeg', 'uploads/1552297813food2.jpeg', 'uploads/1552297813food1.jpeg', 'uploads/1552297813food3.jpeg'),
  (9, '23w23', 'uploads/1552626930diet-food-macro-111130.jpg', 'uploads/images.jpeg', 'uploads/blue-colors-cream-928475.jpg', 'uploads/blue-colors-cream-928475.jpg', 'uploads/1552626938diet-food-macro-111130.jpg'),
  (10, 'test', 'uploads/1549268374images111.jpeg', 'uploads/diet-food-macro-111130.jpg', 'uploads/diet-food-macro-111130.jpg', 'uploads/1552901384diet-food-macro-111130.jpg', 'uploads/diet-food-macro-111130.jpg'),
  (11, 'eee123', 'uploads/1556517719images.jpeg', 'uploads/1556517719close-up-cucumber-cuisine-1', 'uploads/1556517719index4445.jpeg', 'uploads/1556517719images44.jpeg', 'uploads/1556517719blue-colors-cream-928475.jp'),
  (12, 'w', 'uploads/blue-colors-cream-928475.jpg', 'uploads/1556779864images111.jpeg', 'uploads/1556779864index4445.jpeg', 'uploads/1556779864slide4-1459x630.jpg', 'uploads/images.jpeg'),
  (13, 'burger01', 'uploads/15573071111549268374images44.jpeg', 'uploads/15573071121549268374images44.jpeg', 'uploads/15573071121549268374images44.jpeg', 'uploads/15573071121549268374images44.jpeg', 'uploads/15573071121549268374images44.jpeg');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_master`
  --
  
  CREATE TABLE `product_master` (
    `id` int(11) NOT NULL,
    `product_name` varchar(45) DEFAULT NULL,
    `product_sku` varchar(45) NOT NULL,
    `product_quantity` varchar(45) DEFAULT NULL,
    `product_price` varchar(45) DEFAULT NULL,
    `meal_type` varchar(45) DEFAULT NULL,
    `meal_plan` varchar(100) NOT NULL,
    `product_category` int(11) DEFAULT NULL,
    `product_image` varchar(225) DEFAULT NULL,
    `is_customizable` varchar(45) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `product_master`
  --
  
  INSERT INTO `product_master` (`id`, `product_name`, `product_sku`, `product_quantity`, `product_price`, `meal_type`, `meal_plan`, `product_category`, `product_image`, `is_customizable`) VALUES
  (5, 'test1', 'est1', '100', '100', '2', '3', 20, 'NULL', 'custom_no'),
  (6, 'product1', 'sku_prod1', '20', '200', '1', '3', 20, 'NULL', 'custom_no'),
  (7, 'product2', 'sku_prod2', '100', '100', '1', '3', 21, 'NULL', 'custom_no'),
  (8, 'meals', 'meals123', '2', '248', '2', '2', 21, 'NULL', 'custom_no'),
  (9, 'q22q2', '23w23', '9', '5', '2', '2', 23, 'NULL', 'custom_yes'),
  (10, 'test2222', 'test', '7', '3', '2', '3', 21, 'NULL', 'custom_yes'),
  (11, 'eee123', 'eee123', '100', '100', '1', '2', 20, 'NULL', 'custom_no'),
  (12, 'wew', 'w', '3', '3', '2', '3', 21, 'NULL', 'custom_no'),
  (13, 'burger', 'burger01', '10', '100', '1', '2', 20, 'NULL', 'custom_yes');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_update`
  --
  
  CREATE TABLE `product_update` (
    `id` int(11) NOT NULL,
    `product_sku` varchar(45) NOT NULL,
    `product_name` varchar(45) DEFAULT NULL,
    `product_category` varchar(45) DEFAULT NULL,
    `product_updated_quantity` varchar(45) DEFAULT NULL,
    `timestamp` timestamp(6) NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `product_update`
  --
  
  INSERT INTO `product_update` (`id`, `product_sku`, `product_name`, `product_category`, `product_updated_quantity`, `timestamp`) VALUES
  (1, 't03', 'test02', '21', '0', NULL),
  (2, 'ts02', 'test02', '21', '0', NULL),
  (3, 'ts03', 'test02', '21', '0', NULL),
  (4, 'ts031', 'test02', '21', '0', NULL),
  (5, 'ts0312', 'test02', '21', '0', NULL),
  (6, 'ts03123', 'test02', '21', '0', NULL),
  (7, 't02', 'test02', '21', '0', NULL),
  (8, 't02', 'test021', '21', '0', NULL),
  (9, 't02', 'test021', '21', '0', NULL),
  (10, 't02', 'test021', '21', '0', NULL),
  (11, 't02', 'test021', '21', '0', NULL),
  (12, 't02', 'test021', '21', '0', NULL),
  (13, 't02', 'test021', '21', '0', NULL),
  (14, 't02', 'test021', '21', '0', NULL),
  (15, 't02', 'test021', '21', '0', NULL),
  (16, 't02', 'test021', '21', '0', NULL),
  (17, 'tes01', 'test', '20', '0', NULL),
  (18, 't02', 'Product1', '21', '0', NULL),
  (19, 'tes01', 'Product2', '20', '0', NULL),
  (20, 't02', 'Product1', '21', '0', NULL),
  (21, 'tes01', 'Product3', '20', '0', NULL),
  (22, 'tes01', 'Product3', '20', '0', NULL),
  (23, 'tes01', 'Product3', '20', '0', NULL),
  (24, 'tes01', 'Product3', '20', '0', NULL),
  (25, 'sku_abc', 'abc123', '20', '0', NULL),
  (26, 'sku_test', 'test01', '20', '0', NULL),
  (27, 'sku_test', 'test01', '20', '0', NULL),
  (28, 'sku_test', 'test01', '20', '0', NULL),
  (29, 'sku_test', 'test01', '20', '1', NULL),
  (30, 'sku_test', 'test01', '20', '1', NULL),
  (31, 'sku_test', 'test01', '20', '0', NULL),
  (32, 'sku_test', 'test01', '20', '1', NULL),
  (33, 'sku_test', 'test01', '20', '1', NULL),
  (34, 'sku_test', 'test01', '20', '2', NULL),
  (35, 'sku_test', 'test01', '20', '0', NULL),
  (36, 'sku_test', 'test01', '20', '0', NULL),
  (37, 'sku_test', 'test01', '20', '0', NULL),
  (38, 'sku_test', 'test01', '20', '0', NULL),
  (39, 'sku_ital1', 'italian1', '22', '0', NULL),
  (40, 'sku_ital1', 'italian1', '22', '0', NULL),
  (41, 'w2', 'eeee', '21', '0', NULL),
  (42, 'sku_ital1', 'italian1', '22', '0', NULL),
  (43, 'sku_test', 'test01', '20', '0', NULL),
  (44, 'sku_ital1', 'italian1', '22', '0', NULL),
  (45, 'skup1', 'p1www', '21', '3', NULL),
  (46, 'skup1', 'p1www', '21', '0', NULL),
  (47, 'sku_test', 'Pizza', '22', '0', NULL),
  (48, 't02', 'Product1', '21', '0', NULL),
  (49, 'sku_prod1', 'product1', '22', '0', NULL),
  (50, 'sku_prod1', 'product1', '22', '0', NULL),
  (51, 'sku_123', 'qwerty', '21', '10', NULL),
  (52, 'sku_test', 'test', '20', '0', NULL),
  (53, 'sku123', 'test12233333', '21', '0', NULL),
  (54, 'test12', 'test', '20', '0', NULL),
  (55, 'test1122', 'test', '20', '0', NULL),
  (56, 'sku_prod2', 'product2', '21', '0', NULL),
  (57, 'sku_prod1', 'product1', '20', '0', NULL),
  (58, 'sku_prod1', 'product1', '20', '0', NULL),
  (59, 'sku_prod1', 'product1', '20', '0', NULL),
  (60, 'est1', 'test1', '20', '0', NULL),
  (61, 'est1', 'test1', '20', '0', NULL),
  (62, '23w23', 'q22q2', '22', '6', NULL),
  (63, '23w23', 'q22q2', '23', '0', NULL),
  (64, '22222', 'test2222', '21', '5', NULL),
  (65, 'w', 'wew', '21', '0', NULL),
  (66, 'w', 'wew', '21', '0', NULL),
  (67, 'test', 'test2222', '21', '0', NULL),
  (68, 'burger01', 'burger', '20', '0', NULL),
  (69, 'burger01', 'burger', '20', '0', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `RC_stock`
  --
  
  CREATE TABLE `RC_stock` (
    `id` int(11) NOT NULL,
    `kitchen_id` varchar(225) NOT NULL,
    `delivery_id` varchar(225) NOT NULL,
    `dc_no` varchar(225) NOT NULL,
    `product_sku` varchar(225) NOT NULL,
    `product_name` varchar(225) NOT NULL,
    `current_quantity` varchar(225) NOT NULL,
    `obtained_quantity` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `RC_stock`
  --
  
  INSERT INTO `RC_stock` (`id`, `kitchen_id`, `delivery_id`, `dc_no`, `product_sku`, `product_name`, `current_quantity`, `obtained_quantity`) VALUES
  (1, '123', '344', '1234', '34', 'product1', '13', '10'),
  (2, '123', '678', '123', '21', 'product2', '23', '15'),
  (3, '123', '344', '1234', '34', 'product1', '13', '12'),
  (4, '123', '678', '123', '21', 'product2', '23', '13'),
  (5, '123', '1', 'DC07032019111701', 'aa', 'aaa', '10', '1'),
  (6, '123', '1', 'DC07032019111701', 'aa', 'aaa', '10', '1'),
  (7, '123', '1', 'DC07032019111701', 'aa', 'aaa', '10', '1'),
  (8, '123', '1', 'DC07032019111701', '23', 'aaa', '10', '9'),
  (9, '123', '3', 'DC08032019112410', 'jaggery78', 'jaggery', '80', '56'),
  (10, '123', '1', 'DC08032019045201', 'sugarsale32', 'Sugar', '50', '49'),
  (11, '123', '1', 'DC07032019120825', 'aa', 'aaa', '25', '25'),
  (12, '123', '1', 'DC11032019095838', '123', 'aaaa', '21', '21');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `room_master`
  --
  
  CREATE TABLE `room_master` (
    `id` int(11) NOT NULL,
    `room_name` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `room_master`
  --
  
  INSERT INTO `room_master` (`id`, `room_name`) VALUES
  (7, '1'),
  (8, 'Room2'),
  (9, 'room32');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `store_manager`
  --
  
  CREATE TABLE `store_manager` (
    `id` int(11) NOT NULL,
    `first_name` varchar(225) NOT NULL,
    `mid_name` varchar(225) NOT NULL,
    `last_name` varchar(225) NOT NULL,
    `email` varchar(225) NOT NULL,
    `phone_num` varchar(225) NOT NULL,
    `emp_id` varchar(225) NOT NULL,
    `company` varchar(225) NOT NULL,
    `branch` varchar(225) NOT NULL,
    `store` varchar(225) NOT NULL,
    `address1` varchar(225) NOT NULL,
    `address2` varchar(225) NOT NULL,
    `address3` varchar(225) NOT NULL,
    `state` varchar(225) NOT NULL,
    `city` varchar(225) NOT NULL,
    `zipcode` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `store_manager`
  --
  
  INSERT INTO `store_manager` (`id`, `first_name`, `mid_name`, `last_name`, `email`, `phone_num`, `emp_id`, `company`, `branch`, `store`, `address1`, `address2`, `address3`, `state`, `city`, `zipcode`) VALUES
  (8, 'zenopsys', 'evolve', 'zenop', 'zenopsys@gmail.com', '4735743957943', '1256', '12', '9', '7', 'Bangalore', 'bsk 3rd stage', 'hoskerehalli', 'Karnataka1', 'Bangalore', '590324'),
  (9, 'aaaa1', 'aaa1', 'aaaa1', 'aaa1', 'aaa1', 'aaaa1', '24', '17', '8', 'sss1', 'ssss1', 'sss1', 'ssss1', 'ssss1', 'sssss1');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `store_mapping`
  --
  
  CREATE TABLE `store_mapping` (
    `id` int(11) NOT NULL,
    `store` varchar(225) NOT NULL,
    `room` varchar(225) NOT NULL,
    `grid` varchar(225) NOT NULL,
    `bin` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `store_mapping`
  --
  
  INSERT INTO `store_mapping` (`id`, `store`, `room`, `grid`, `bin`) VALUES
  (3, '6', '7', '8', '7'),
  (4, '6', '8', '9', '8'),
  (5, '7', '8', '9', '7'),
  (6, '8', '9', '10', '7');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `store_master`
  --
  
  CREATE TABLE `store_master` (
    `id` int(11) NOT NULL,
    `store_name` varchar(225) NOT NULL,
    `email` varchar(225) NOT NULL,
    `phone_num` varchar(225) NOT NULL,
    `address1` varchar(225) NOT NULL,
    `address2` varchar(225) NOT NULL,
    `address3` varchar(225) NOT NULL,
    `state` varchar(225) NOT NULL,
    `city` varchar(225) NOT NULL,
    `zipcode` varchar(225) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `store_master`
  --
  
  INSERT INTO `store_master` (`id`, `store_name`, `email`, `phone_num`, `address1`, `address2`, `address3`, `state`, `city`, `zipcode`) VALUES
  (6, 'a0909', 'a99', 'a99', 'address10', 'address20', 'address30', 'Karnataka00', 'Bangalore00', '5600850'),
  (7, 'test1', 'test@e.com', '9876543210', 'test', 'test', 'test', 'test', 'test', 'test'),
  (8, 'aaa22', 'aaa222', '2', '22', 'a2', 'aa2', '22', 'a2', 'aaa22');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `superadmin_login`
  --
  
  CREATE TABLE `superadmin_login` (
    `id` int(11) NOT NULL,
    `user_name` varchar(225) DEFAULT NULL,
    `email` varchar(225) DEFAULT NULL,
    `password` varchar(225) DEFAULT NULL,
    `phone_number` varchar(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `superadmin_login`
  --
  
  INSERT INTO `superadmin_login` (`id`, `user_name`, `email`, `password`, `phone_number`) VALUES
  (10, 'JohnDoe', 'johndoe@gmail.com', '1234', '9876543210');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `test`
  --
  
  CREATE TABLE `test` (
    `name` varchar(225) DEFAULT NULL,
    `sku` varchar(225) DEFAULT NULL,
    `price` varchar(225) DEFAULT NULL,
    `quantity` varchar(225) DEFAULT NULL,
    `unique_order_id` varchar(225) DEFAULT NULL,
    `optional_sku` text,
    `optionl_name` text
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `units_master`
  --
  
  CREATE TABLE `units_master` (
    `id` int(11) NOT NULL,
    `units` varchar(225) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `units_master`
  --
  
  INSERT INTO `units_master` (`id`, `units`) VALUES
  (1, 'unit1'),
  (2, 'unit3'),
  (3, 'unit33');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_123`
  --
  
  CREATE TABLE `update_inventory_kitchen_123` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `update_inventory_kitchen_123`
  --
  
  INSERT INTO `update_inventory_kitchen_123` (`id`, `product_name`, `product_sku`, `product_units`, `product_quantity`, `addordel`, `timestamp`) VALUES
  (1, 'product1', '23', 'unit1', '100', 'a', '2019-02-26 10:03:25.673121'),
  (2, 'product1', '23', 'unit1', '12', 'a', '2019-02-26 10:04:23.410851'),
  (3, 'product1', '23', 'unit1', '12', 'd', '2019-02-26 10:04:30.019806'),
  (4, 'product1', '23', 'unit1', '78', 'd', '2019-02-26 10:09:14.530796'),
  (5, 'product1', '23', 'unit1', '28', 'a', '2019-02-26 10:13:22.253762'),
  (6, 'product1', '23', 'unit1', '', 'd', '2019-02-26 10:13:35.265315'),
  (7, 'product1', '23', 'unit1', '8', 'a', '2019-02-26 10:13:46.517298'),
  (8, 'product1', '23', 'unit1', '', 'a', '2019-02-26 10:31:48.316294'),
  (9, 'product1', '23', 'unit1', '', 'd', '2019-02-26 10:31:52.527190'),
  (10, 'product1', '23', 'unit1', '12', 'a', '2019-02-26 11:31:06.660782'),
  (11, 'product1', '23', 'unit1', '12', 'a', '2019-02-26 13:00:18.913309'),
  (12, 'product1', '23', 'unit1', '12', 'd', '2019-02-26 13:00:24.164694'),
  (13, 'product1', '23', 'unit1', '23', 'a', '2019-03-01 06:19:43.378031'),
  (14, 'product1', '23', 'unit1', '34', 'd', '2019-03-01 06:19:50.261314'),
  (15, 'product1', '23', 'unit1', '89', 'a', '2019-03-05 11:00:57.623134'),
  (16, 'product1', '23', 'unit1', '89', 'a', '2019-03-05 11:00:59.639722'),
  (17, 'product1', '23', 'unit1', '9', 'd', '2019-03-05 11:01:10.421814'),
  (18, 'product1', '23', 'unit1', '9', 'd', '2019-03-05 11:01:27.328712'),
  (19, 'product1', '23', 'unit1', '200', 'd', '2019-03-05 11:01:41.226695'),
  (20, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:54.115072'),
  (21, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:55.127266'),
  (22, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:55.693456'),
  (23, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:55.858356'),
  (24, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:56.006573'),
  (25, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:56.187552'),
  (26, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:01:56.377938'),
  (27, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:09.398044'),
  (28, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:09.626361'),
  (29, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:09.643828'),
  (30, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:09.835076'),
  (31, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.079494'),
  (32, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.227068'),
  (33, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.435256'),
  (34, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.602991'),
  (35, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.752644'),
  (36, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:10.936084'),
  (37, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:11.093963'),
  (38, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:11.266343'),
  (39, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:19.123808'),
  (40, 'product1', '23', 'unit1', '9', 'a', '2019-03-05 11:02:27.280914'),
  (41, 'product1', '23', 'unit1', '200', 'd', '2019-03-05 11:03:03.217561'),
  (42, 'product1', '23', 'unit1', '01', 'd', '2019-03-05 11:03:19.349311'),
  (43, 'product1', '23', 'unit1', '00000003', 'd', '2019-03-05 11:03:32.909350'),
  (44, 'product1', '23', 'unit1', '000000000000000000000000000000000000000000000000000000000000001', 'd', '2019-03-05 11:07:37.084344'),
  (45, 'aaa', 'aa', 'aa', '1', 'a', '2019-03-07 12:04:35.712507'),
  (46, 'aaa', 'aa', 'aa', '1', 'a', '2019-03-07 12:05:42.230911'),
  (47, 'product1', '23', 'unit1', '1', 'd', '2019-03-07 12:32:07.796140'),
  (48, 'aaa', 'aa', 'aa', '1', 'a', '2019-03-07 12:32:27.599814'),
  (49, 'aaa', '23', 'aa', '9', 'a', '2019-03-08 04:27:43.196469'),
  (50, 'product1', '23', 'unit1', '9', 'd', '2019-03-12 04:48:12.548649'),
  (51, 'jaggery', 'jaggery78', 'unit1', '56', 'a', '2019-03-12 04:48:34.160658'),
  (52, 'Sugar', 'sugarsale32', 'unit1', '49', 'a', '2019-03-12 04:48:49.466018'),
  (53, 'aaa', 'aa', 'aa', '25', 'a', '2019-03-15 06:57:43.092899'),
  (54, 'aaaa', '123', 'unit1', '21', 'a', '2019-03-15 06:57:49.422289'),
  (55, 'jaggery', 'jaggery78', 'unit1', '45', 'd', '2019-03-15 07:07:08.158291'),
  (56, 'Sugar', 'sugarsale32', 'unit1', '15', 'd', '2019-03-15 07:07:14.381813');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_125`
  --
  
  CREATE TABLE `update_inventory_kitchen_125` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `update_inventory_kitchen_125`
  --
  
  INSERT INTO `update_inventory_kitchen_125` (`id`, `product_name`, `product_sku`, `product_units`, `product_quantity`, `addordel`, `timestamp`) VALUES
  (1, 'product1', '23', 'unit1', '100', 'a', '2019-02-28 06:08:38.735661'),
  (2, 'product2', '24', 'unit1', '100', 'a', '2019-02-28 06:08:38.737203'),
  (3, 'product1', '23', 'unit1', '25', 'a', '2019-02-28 06:08:53.708815'),
  (4, 'product2', '24', 'unit1', '25', 'd', '2019-02-28 06:09:04.455670');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_1234`
  --
  
  CREATE TABLE `update_inventory_kitchen_1234` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_4032`
  --
  
  CREATE TABLE `update_inventory_kitchen_4032` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_kit55`
  --
  
  CREATE TABLE `update_inventory_kitchen_kit55` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `update_inventory_kitchen_kit123`
  --
  
  CREATE TABLE `update_inventory_kitchen_kit123` (
    `id` int(11) UNSIGNED NOT NULL,
    `product_name` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_sku` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_units` varchar(100) NOT NULL DEFAULT 'NULL',
    `product_quantity` varchar(100) NOT NULL DEFAULT 'NULL',
    `addordel` varchar(100) NOT NULL,
    `timestamp` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_login`
  --
  
  CREATE TABLE `user_login` (
    `id` int(11) NOT NULL,
    `email_id` varchar(225) DEFAULT NULL,
    `phone_number` varchar(225) DEFAULT NULL,
    `password` varchar(225) DEFAULT NULL,
    `active` varchar(45) DEFAULT NULL,
    `admin` tinyint(4) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data for table `user_login`
  --
  
  INSERT INTO `user_login` (`id`, `email_id`, `phone_number`, `password`, `active`, `admin`) VALUES
  (1, 'reply2developer@gmail.com', '9160700733', '1234', '1', 1),
  (22, 'vedavith.r@zenopsys.com', '123456692', '1234', '1', 0),
  (37, 'mounika.m@zenopsys.com', '9874563210', '12345', '1', 1),
  (38, 'lakshmikumar.k@zenopsys.com', '987456321', '89314294', '0', 0),
  (42, 'divya.a@zenopsys.com', '6786868867', '56503387', '1', 0),
  (43, 'zenopsys@gmail.com', '9903277923', '123', '1', 0),
  (44, 'a1@g.com', '4735743957943', '18760360', '0', 0),
  (45, 'dffff', '1111', '96124112', '0', 0),
  (46, 'vedavithravula1996@gmail.com', '9160700733', '1234', '1', 0),
  (47, 'rrr', '8878778787', '78148601', '0', 0),
  (48, 'wwww', 'wwww22', '91098064', '0', 1),
  (49, 'qq', 'q', '16183385', '0', 0),
  (50, 'sony@ddd.in', '978898989898', '43140497', '0', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Structure for view `product_concat`
  --
  DROP TABLE IF EXISTS `product_concat`;
  
  CREATE ALGORITHM=UNDEFINED DEFINER=`magentocpanel`@`localhost` SQL SECURITY DEFINER VIEW `product_concat`  AS  select `product_cart`.`product_name` AS `name`,`product_cart`.`product_sku` AS `sku`,`product_cart`.`price` AS `price`,`product_cart`.`quantity` AS `quantity`,`optional_product_cart`.`unique_order_id` AS `unique_order_id`,group_concat(`optional_product_cart`.`product_sku` separator ',') AS `optional_sku`,group_concat(`optional_product_cart`.`product_name` separator ',') AS `optional_name`,group_concat(`optional_product_cart`.`quantity` separator ',') AS `optional_quantity` from (`product_cart` join `optional_product_cart`) where (`product_cart`.`unique_order_id` = `optional_product_cart`.`unique_order_id`) group by `product_cart`.`id` ;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admin_details`
  --
  ALTER TABLE `admin_details`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `admin_login_count`
  --
  ALTER TABLE `admin_login_count`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `bin_master`
  --
  ALTER TABLE `bin_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `branch_data`
  --
  ALTER TABLE `branch_data`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cart_confirmation`
  --
  ALTER TABLE `cart_confirmation`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `category_master`
  --
  ALTER TABLE `category_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `company_data`
  --
  ALTER TABLE `company_data`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `corporate_representative`
  --
  ALTER TABLE `corporate_representative`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `corporate_user_registration`
  --
  ALTER TABLE `corporate_user_registration`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `custom_product_master`
  --
  ALTER TABLE `custom_product_master`
    ADD PRIMARY KEY (`id`,`product_category`),
    ADD KEY `prod_category_idx` (`product_category`),
    ADD KEY `product_sku_idx` (`product_sku`),
    ADD KEY `product_sku_idx1` (`product_category`,`product_sku`);
  
  --
  -- Indexes for table `date_products`
  --
  ALTER TABLE `date_products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `DC_order`
  --
  ALTER TABLE `DC_order`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `DC_stock`
  --
  ALTER TABLE `DC_stock`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `deliveryhub_admin`
  --
  ALTER TABLE `deliveryhub_admin`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `deliveryhub_del_order`
  --
  ALTER TABLE `deliveryhub_del_order`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `deliveryhub_register`
  --
  ALTER TABLE `deliveryhub_register`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `delivery_address_confirmed`
  --
  ALTER TABLE `delivery_address_confirmed`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `delivery_employee`
  --
  ALTER TABLE `delivery_employee`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `delivery_emp_role`
  --
  ALTER TABLE `delivery_emp_role`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `delivery_kitchen_order`
  --
  ALTER TABLE `delivery_kitchen_order`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `emp_role_master`
  --
  ALTER TABLE `emp_role_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `grid_master`
  --
  ALTER TABLE `grid_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `individual_user_registration`
  --
  ALTER TABLE `individual_user_registration`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_123`
  --
  ALTER TABLE `insert_inventory_kitchen_123`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_125`
  --
  ALTER TABLE `insert_inventory_kitchen_125`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_1234`
  --
  ALTER TABLE `insert_inventory_kitchen_1234`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_4032`
  --
  ALTER TABLE `insert_inventory_kitchen_4032`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_kit55`
  --
  ALTER TABLE `insert_inventory_kitchen_kit55`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_inventory_kitchen_kit123`
  --
  ALTER TABLE `insert_inventory_kitchen_kit123`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_kitchen_assign_product_kit55`
  --
  ALTER TABLE `insert_kitchen_assign_product_kit55`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `insert_kitchen_assign_product_kit123`
  --
  ALTER TABLE `insert_kitchen_assign_product_kit123`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_admin`
  --
  ALTER TABLE `kitchen_admin`
    ADD PRIMARY KEY (`id`),
    ADD KEY `kitchen_id` (`kitchen_id`(225));
  
  --
  -- Indexes for table `kitchen_assigned_products`
  --
  ALTER TABLE `kitchen_assigned_products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_employee`
  --
  ALTER TABLE `kitchen_employee`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_emp_attendance`
  --
  ALTER TABLE `kitchen_emp_attendance`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_master`
  --
  ALTER TABLE `kitchen_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_product_master`
  --
  ALTER TABLE `kitchen_product_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `kitchen_register`
  --
  ALTER TABLE `kitchen_register`
    ADD PRIMARY KEY (`id`,`k_id`);
  
  --
  -- Indexes for table `meal_plan_master`
  --
  ALTER TABLE `meal_plan_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `meal_preference_master`
  --
  ALTER TABLE `meal_preference_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notifications`
  --
  ALTER TABLE `notifications`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notification_kitchen`
  --
  ALTER TABLE `notification_kitchen`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `optional_product_cart`
  --
  ALTER TABLE `optional_product_cart`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `primary_product_inventory_insert`
  --
  ALTER TABLE `primary_product_inventory_insert`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `primary_product_inventory_update`
  --
  ALTER TABLE `primary_product_inventory_update`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `primary_stock_products`
  --
  ALTER TABLE `primary_stock_products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_cart`
  --
  ALTER TABLE `product_cart`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_image`
  --
  ALTER TABLE `product_image`
    ADD PRIMARY KEY (`id`) USING BTREE,
    ADD KEY `fk_product_image_1_idx` (`product_sku`);
  
  --
  -- Indexes for table `product_master`
  --
  ALTER TABLE `product_master`
    ADD PRIMARY KEY (`id`,`product_sku`),
    ADD KEY `fk_product_master_1_idx` (`product_category`),
    ADD KEY `prod_sku` (`product_sku`);
  
  --
  -- Indexes for table `product_update`
  --
  ALTER TABLE `product_update`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `RC_stock`
  --
  ALTER TABLE `RC_stock`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `room_master`
  --
  ALTER TABLE `room_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `store_manager`
  --
  ALTER TABLE `store_manager`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `store_mapping`
  --
  ALTER TABLE `store_mapping`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `store_master`
  --
  ALTER TABLE `store_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `superadmin_login`
  --
  ALTER TABLE `superadmin_login`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `units_master`
  --
  ALTER TABLE `units_master`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_123`
  --
  ALTER TABLE `update_inventory_kitchen_123`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_125`
  --
  ALTER TABLE `update_inventory_kitchen_125`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_1234`
  --
  ALTER TABLE `update_inventory_kitchen_1234`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_4032`
  --
  ALTER TABLE `update_inventory_kitchen_4032`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_kit55`
  --
  ALTER TABLE `update_inventory_kitchen_kit55`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `update_inventory_kitchen_kit123`
  --
  ALTER TABLE `update_inventory_kitchen_kit123`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `user_login`
  --
  ALTER TABLE `user_login`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admin_details`
  --
  ALTER TABLE `admin_details`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `admin_login_count`
  --
  ALTER TABLE `admin_login_count`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `bin_master`
  --
  ALTER TABLE `bin_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `branch_data`
  --
  ALTER TABLE `branch_data`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT for table `cart_confirmation`
  --
  ALTER TABLE `cart_confirmation`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;
  
  --
  -- AUTO_INCREMENT for table `category_master`
  --
  ALTER TABLE `category_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  
  --
  -- AUTO_INCREMENT for table `company_data`
  --
  ALTER TABLE `company_data`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
  
  --
  -- AUTO_INCREMENT for table `corporate_representative`
  --
  ALTER TABLE `corporate_representative`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `corporate_user_registration`
  --
  ALTER TABLE `corporate_user_registration`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT for table `custom_product_master`
  --
  ALTER TABLE `custom_product_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- AUTO_INCREMENT for table `date_products`
  --
  ALTER TABLE `date_products`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `DC_order`
  --
  ALTER TABLE `DC_order`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `DC_stock`
  --
  ALTER TABLE `DC_stock`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
  
  --
  -- AUTO_INCREMENT for table `deliveryhub_admin`
  --
  ALTER TABLE `deliveryhub_admin`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `deliveryhub_del_order`
  --
  ALTER TABLE `deliveryhub_del_order`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `deliveryhub_register`
  --
  ALTER TABLE `deliveryhub_register`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `delivery_address_confirmed`
  --
  ALTER TABLE `delivery_address_confirmed`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- AUTO_INCREMENT for table `delivery_employee`
  --
  ALTER TABLE `delivery_employee`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
  
  --
  -- AUTO_INCREMENT for table `delivery_emp_role`
  --
  ALTER TABLE `delivery_emp_role`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `delivery_kitchen_order`
  --
  ALTER TABLE `delivery_kitchen_order`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `emp_role_master`
  --
  ALTER TABLE `emp_role_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `grid_master`
  --
  ALTER TABLE `grid_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  
  --
  -- AUTO_INCREMENT for table `individual_user_registration`
  --
  ALTER TABLE `individual_user_registration`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_123`
  --
  ALTER TABLE `insert_inventory_kitchen_123`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_125`
  --
  ALTER TABLE `insert_inventory_kitchen_125`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_1234`
  --
  ALTER TABLE `insert_inventory_kitchen_1234`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_4032`
  --
  ALTER TABLE `insert_inventory_kitchen_4032`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_kit55`
  --
  ALTER TABLE `insert_inventory_kitchen_kit55`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `insert_inventory_kitchen_kit123`
  --
  ALTER TABLE `insert_inventory_kitchen_kit123`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `insert_kitchen_assign_product_kit55`
  --
  ALTER TABLE `insert_kitchen_assign_product_kit55`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `insert_kitchen_assign_product_kit123`
  --
  ALTER TABLE `insert_kitchen_assign_product_kit123`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `kitchen_admin`
  --
  ALTER TABLE `kitchen_admin`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
  
  --
  -- AUTO_INCREMENT for table `kitchen_assigned_products`
  --
  ALTER TABLE `kitchen_assigned_products`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
  
  --
  -- AUTO_INCREMENT for table `kitchen_employee`
  --
  ALTER TABLE `kitchen_employee`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `kitchen_emp_attendance`
  --
  ALTER TABLE `kitchen_emp_attendance`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  
  --
  -- AUTO_INCREMENT for table `kitchen_master`
  --
  ALTER TABLE `kitchen_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `kitchen_product_master`
  --
  ALTER TABLE `kitchen_product_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `kitchen_register`
  --
  ALTER TABLE `kitchen_register`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `meal_plan_master`
  --
  ALTER TABLE `meal_plan_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `meal_preference_master`
  --
  ALTER TABLE `meal_preference_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `notifications`
  --
  ALTER TABLE `notifications`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `notification_kitchen`
  --
  ALTER TABLE `notification_kitchen`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
  
  --
  -- AUTO_INCREMENT for table `optional_product_cart`
  --
  ALTER TABLE `optional_product_cart`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
  
  --
  -- AUTO_INCREMENT for table `primary_product_inventory_insert`
  --
  ALTER TABLE `primary_product_inventory_insert`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `primary_product_inventory_update`
  --
  ALTER TABLE `primary_product_inventory_update`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
  
  --
  -- AUTO_INCREMENT for table `primary_stock_products`
  --
  ALTER TABLE `primary_stock_products`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `product_cart`
  --
  ALTER TABLE `product_cart`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=104;
  
  --
  -- AUTO_INCREMENT for table `product_image`
  --
  ALTER TABLE `product_image`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `product_master`
  --
  ALTER TABLE `product_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `product_update`
  --
  ALTER TABLE `product_update`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;
  
  --
  -- AUTO_INCREMENT for table `RC_stock`
  --
  ALTER TABLE `RC_stock`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `room_master`
  --
  ALTER TABLE `room_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `store_manager`
  --
  ALTER TABLE `store_manager`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `store_mapping`
  --
  ALTER TABLE `store_mapping`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `store_master`
  --
  ALTER TABLE `store_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `superadmin_login`
  --
  ALTER TABLE `superadmin_login`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  
  --
  -- AUTO_INCREMENT for table `units_master`
  --
  ALTER TABLE `units_master`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_123`
  --
  ALTER TABLE `update_inventory_kitchen_123`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_125`
  --
  ALTER TABLE `update_inventory_kitchen_125`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_1234`
  --
  ALTER TABLE `update_inventory_kitchen_1234`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_4032`
  --
  ALTER TABLE `update_inventory_kitchen_4032`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_kit55`
  --
  ALTER TABLE `update_inventory_kitchen_kit55`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `update_inventory_kitchen_kit123`
  --
  ALTER TABLE `update_inventory_kitchen_kit123`
    MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `user_login`
  --
  ALTER TABLE `user_login`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `custom_product_master`
  --
  ALTER TABLE `custom_product_master`
    ADD CONSTRAINT `fk_custom_product_master_1` FOREIGN KEY (`product_category`) REFERENCES `product_master` (`product_category`) ON DELETE CASCADE ON UPDATE CASCADE,
    ADD CONSTRAINT `prod_sku` FOREIGN KEY (`product_sku`) REFERENCES `product_master` (`product_sku`) ON DELETE CASCADE ON UPDATE CASCADE;
  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 */;
  