-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `7094869231dine_store1_devicedefault_mydbappdata`
--

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

--
-- Table structure for table `account_selection`
--

CREATE TABLE `account_selection` (
  `_id` int(11) NOT NULL,
  `selection` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `alaramdays`
--

CREATE TABLE `alaramdays` (
  `_id` int(11) NOT NULL,
  `selecteddays` text COLLATE utf8mb4_unicode_ci,
  `unselecteddays` text COLLATE utf8mb4_unicode_ci,
  `swap` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `alaramon_off`
--

CREATE TABLE `alaramon_off` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `alaramtime`
--

CREATE TABLE `alaramtime` (
  `_id` int(11) NOT NULL,
  `time` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `asd1`
--

CREATE TABLE `asd1` (
  `_id` int(11) NOT NULL,
  `pName` text COLLATE utf8mb4_unicode_ci,
  `pDate` text COLLATE utf8mb4_unicode_ci,
  `image` text COLLATE utf8mb4_unicode_ci,
  `floor` text COLLATE utf8mb4_unicode_ci,
  `position` text COLLATE utf8mb4_unicode_ci,
  `max` text COLLATE utf8mb4_unicode_ci,
  `present` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `auto_connect`
--

CREATE TABLE `auto_connect` (
  `_id` int(11) NOT NULL,
  `auto_connect_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `auto_generate_barcode`
--

CREATE TABLE `auto_generate_barcode` (
  `_id` int(11) NOT NULL,
  `generate` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `barcodescannerconnectivity`
--

CREATE TABLE `barcodescannerconnectivity` (
  `_id` int(11) NOT NULL,
  `barcodescannercontype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `billcount_tag`
--

CREATE TABLE `billcount_tag` (
  `_id` int(11) NOT NULL,
  `tag_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `billingmode`
--

CREATE TABLE `billingmode` (
  `_id` int(11) NOT NULL,
  `billingtype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `billingtype`
--

CREATE TABLE `billingtype` (
  `_id` int(11) NOT NULL,
  `billingtype_type` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `btconn`
--

CREATE TABLE `btconn` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `device` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cardswiperactivation`
--

CREATE TABLE `cardswiperactivation` (
  `_id` int(11) NOT NULL,
  `CardSwiperName` text COLLATE utf8mb4_unicode_ci,
  `merchantKey` text COLLATE utf8mb4_unicode_ci,
  `partnerkey` text COLLATE utf8mb4_unicode_ci,
  `Config_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cashdrawerconnectivity`
--

CREATE TABLE `cashdrawerconnectivity` (
  `_id` int(11) NOT NULL,
  `cashdrawercontype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `_id` int(11) NOT NULL,
  `ALL_CATEGORY` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `change_time_format`
--

CREATE TABLE `change_time_format` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `companydetailss`
--

CREATE TABLE `companydetailss` (
  `_id` int(11) NOT NULL,
  `companyname` text COLLATE utf8mb4_unicode_ci,
  `doorno` text COLLATE utf8mb4_unicode_ci,
  `substreet` text COLLATE utf8mb4_unicode_ci,
  `street` text COLLATE utf8mb4_unicode_ci,
  `city` text COLLATE utf8mb4_unicode_ci,
  `state` text COLLATE utf8mb4_unicode_ci,
  `country` text COLLATE utf8mb4_unicode_ci,
  `pincode` int(11) DEFAULT NULL,
  `phoneno` int(11) DEFAULT NULL,
  `taxone` text COLLATE utf8mb4_unicode_ci,
  `taxtwo` text COLLATE utf8mb4_unicode_ci,
  `footerone` text COLLATE utf8mb4_unicode_ci,
  `footertwo` text COLLATE utf8mb4_unicode_ci,
  `address1` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci,
  `website` text COLLATE utf8mb4_unicode_ci,
  `address2` text COLLATE utf8mb4_unicode_ci,
  `address3` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `country_selection`
--

CREATE TABLE `country_selection` (
  `_id` int(11) NOT NULL,
  `country` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `default_credit`
--

CREATE TABLE `default_credit` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deletedbon_off`
--

CREATE TABLE `deletedbon_off` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `deletedb_time`
--

CREATE TABLE `deletedb_time` (
  `_id` int(11) NOT NULL,
  `time` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_details`
--

CREATE TABLE `discount_details` (
  `_id` int(11) NOT NULL,
  `disc_code` text COLLATE utf8mb4_unicode_ci,
  `disc_value` text COLLATE utf8mb4_unicode_ci,
  `disc_type` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_selec`
--

CREATE TABLE `discount_selec` (
  `_id` int(11) NOT NULL,
  `discount_amount` text COLLATE utf8mb4_unicode_ci,
  `discount_per` text COLLATE utf8mb4_unicode_ci,
  `selected_but` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `discount_types`
--

CREATE TABLE `discount_types` (
  `_id` int(11) NOT NULL,
  `discountname` text COLLATE utf8mb4_unicode_ci,
  `discountvalue` decimal(10,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email_recipient`
--

CREATE TABLE `email_recipient` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `ph_no` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `estimate_print`
--

CREATE TABLE `estimate_print` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `floors`
--

CREATE TABLE `floors` (
  `_id` int(11) NOT NULL,
  `floorname` text COLLATE utf8mb4_unicode_ci,
  `position` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `freetrail`
--

CREATE TABLE `freetrail` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `homedelivery_prints`
--

CREATE TABLE `homedelivery_prints` (
  `_id` int(11) NOT NULL,
  `companycopy` text COLLATE utf8mb4_unicode_ci,
  `customercopy` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `home_check`
--

CREATE TABLE `home_check` (
  `_id` int(11) NOT NULL,
  `login_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hotel`
--

CREATE TABLE `hotel` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `direccion` text COLLATE utf8mb4_unicode_ci,
  `telefono` text COLLATE utf8mb4_unicode_ci,
  `email` text COLLATE utf8mb4_unicode_ci,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hotel1`
--

CREATE TABLE `hotel1` (
  `_id` int(11) NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredients`
--

CREATE TABLE `ingredients` (
  `_id` int(11) NOT NULL,
  `ingredient_name` text COLLATE utf8mb4_unicode_ci,
  `min_req` text COLLATE utf8mb4_unicode_ci,
  `max_req` text COLLATE utf8mb4_unicode_ci,
  `current_stock` text COLLATE utf8mb4_unicode_ci,
  `unit` text COLLATE utf8mb4_unicode_ci,
  `indiv_price` text COLLATE utf8mb4_unicode_ci,
  `total_price` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `time1` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `avg_price` text COLLATE utf8mb4_unicode_ci,
  `required` text COLLATE utf8mb4_unicode_ci,
  `barcode` text COLLATE utf8mb4_unicode_ci,
  `status_low` text COLLATE utf8mb4_unicode_ci,
  `status_qty_updated` text COLLATE utf8mb4_unicode_ci,
  `add_qty` text COLLATE utf8mb4_unicode_ci,
  `indiv_price_copy` text COLLATE utf8mb4_unicode_ci,
  `adjusted_stock` text COLLATE utf8mb4_unicode_ci,
  `diff_stock` text COLLATE utf8mb4_unicode_ci,
  `indiv_price_temp` text COLLATE utf8mb4_unicode_ci,
  `total_price_temp` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredients_item_selection_temp`
--

CREATE TABLE `ingredients_item_selection_temp` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `qty_temp` text COLLATE utf8mb4_unicode_ci,
  `qty_temp_unit` text COLLATE utf8mb4_unicode_ci,
  `qty` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredients_temp_list`
--

CREATE TABLE `ingredients_temp_list` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `avg_price` text COLLATE utf8mb4_unicode_ci,
  `min_price` text COLLATE utf8mb4_unicode_ci,
  `max_price` text COLLATE utf8mb4_unicode_ci,
  `total_qty` text COLLATE utf8mb4_unicode_ci,
  `total_price` text COLLATE utf8mb4_unicode_ci,
  `barcode` text COLLATE utf8mb4_unicode_ci,
  `unit` text COLLATE utf8mb4_unicode_ci,
  `wastage_qty` text COLLATE utf8mb4_unicode_ci,
  `wastage_cost` text COLLATE utf8mb4_unicode_ci,
  `not_required` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredient_items_list`
--

CREATE TABLE `ingredient_items_list` (
  `_id` int(11) NOT NULL,
  `ingredient_name` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `item_qyt_used` text COLLATE utf8mb4_unicode_ci,
  `currnet_stock` text COLLATE utf8mb4_unicode_ci,
  `date1` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `time1` text COLLATE utf8mb4_unicode_ci,
  `time` text COLLATE utf8mb4_unicode_ci,
  `modified_datetimee_new` text COLLATE utf8mb4_unicode_ci,
  `qty_unit` text COLLATE utf8mb4_unicode_ci,
  `required` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredient_sold_details`
--

CREATE TABLE `ingredient_sold_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `invoice` text COLLATE utf8mb4_unicode_ci,
  `billamount` text COLLATE utf8mb4_unicode_ci,
  `tax_percent` text COLLATE utf8mb4_unicode_ci,
  `tax_amount` text COLLATE utf8mb4_unicode_ci,
  `disc_percent` text COLLATE utf8mb4_unicode_ci,
  `disc_amount` text COLLATE utf8mb4_unicode_ci,
  `total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `from_time` text COLLATE utf8mb4_unicode_ci,
  `from_date` text COLLATE utf8mb4_unicode_ci,
  `due_date` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_from` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_due` text COLLATE utf8mb4_unicode_ci,
  `pay` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `total_pay` text COLLATE utf8mb4_unicode_ci,
  `pay_date` text COLLATE utf8mb4_unicode_ci,
  `pay_time` text COLLATE utf8mb4_unicode_ci,
  `pay_datetimeemew` text COLLATE utf8mb4_unicode_ci,
  `not_required` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredient_sold_item_details`
--

CREATE TABLE `ingredient_sold_item_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `qty_add` text COLLATE utf8mb4_unicode_ci,
  `individual_price` text COLLATE utf8mb4_unicode_ci,
  `total_price` text COLLATE utf8mb4_unicode_ci,
  `invoice` text COLLATE utf8mb4_unicode_ci,
  `billamount` text COLLATE utf8mb4_unicode_ci,
  `tax_percent` text COLLATE utf8mb4_unicode_ci,
  `tax_amount` text COLLATE utf8mb4_unicode_ci,
  `disc_percent` text COLLATE utf8mb4_unicode_ci,
  `disc_amount` text COLLATE utf8mb4_unicode_ci,
  `total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `from_time` text COLLATE utf8mb4_unicode_ci,
  `from_date` text COLLATE utf8mb4_unicode_ci,
  `due_date` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_from` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_due` text COLLATE utf8mb4_unicode_ci,
  `pay` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `tax1` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `tax4` text COLLATE utf8mb4_unicode_ci,
  `tax5` text COLLATE utf8mb4_unicode_ci,
  `tax6` text COLLATE utf8mb4_unicode_ci,
  `tax7` text COLLATE utf8mb4_unicode_ci,
  `tax8` text COLLATE utf8mb4_unicode_ci,
  `tax9` text COLLATE utf8mb4_unicode_ci,
  `tax10` text COLLATE utf8mb4_unicode_ci,
  `tax11` text COLLATE utf8mb4_unicode_ci,
  `tax12` text COLLATE utf8mb4_unicode_ci,
  `tax13` text COLLATE utf8mb4_unicode_ci,
  `tax14` text COLLATE utf8mb4_unicode_ci,
  `tax15` text COLLATE utf8mb4_unicode_ci,
  `tax1_value` text COLLATE utf8mb4_unicode_ci,
  `tax2_value` text COLLATE utf8mb4_unicode_ci,
  `tax3_value` text COLLATE utf8mb4_unicode_ci,
  `tax4_value` text COLLATE utf8mb4_unicode_ci,
  `tax5_value` text COLLATE utf8mb4_unicode_ci,
  `tax6_value` text COLLATE utf8mb4_unicode_ci,
  `tax7_value` text COLLATE utf8mb4_unicode_ci,
  `tax8_value` text COLLATE utf8mb4_unicode_ci,
  `tax9_value` text COLLATE utf8mb4_unicode_ci,
  `tax10_value` text COLLATE utf8mb4_unicode_ci,
  `tax11_value` text COLLATE utf8mb4_unicode_ci,
  `tax12_value` text COLLATE utf8mb4_unicode_ci,
  `tax13_value` text COLLATE utf8mb4_unicode_ci,
  `tax14_value` text COLLATE utf8mb4_unicode_ci,
  `tax15_value` text COLLATE utf8mb4_unicode_ci,
  `wastage` text COLLATE utf8mb4_unicode_ci,
  `unit` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ingredient_vendor_details`
--

CREATE TABLE `ingredient_vendor_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `vendor_email` text COLLATE utf8mb4_unicode_ci,
  `vendor_address` text COLLATE utf8mb4_unicode_ci,
  `vendor_gst` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn`
--

CREATE TABLE `ipconn` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn_counter`
--

CREATE TABLE `ipconn_counter` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn_kot1`
--

CREATE TABLE `ipconn_kot1` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci,
  `kot_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn_kot2`
--

CREATE TABLE `ipconn_kot2` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci,
  `kot_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn_kot3`
--

CREATE TABLE `ipconn_kot3` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci,
  `kot_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ipconn_kot4`
--

CREATE TABLE `ipconn_kot4` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci,
  `printer_name` text COLLATE utf8mb4_unicode_ci,
  `kot_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(10,2) DEFAULT NULL,
  `stockquan` decimal(10,0) DEFAULT NULL,
  `category` text COLLATE utf8mb4_unicode_ci,
  `itemtax` text COLLATE utf8mb4_unicode_ci,
  `image` text COLLATE utf8mb4_unicode_ci,
  `weekdaysvalue` text COLLATE utf8mb4_unicode_ci,
  `weekendsvalue` text COLLATE utf8mb4_unicode_ci,
  `manualstockvalue` text COLLATE utf8mb4_unicode_ci,
  `automaticstockresetvalue` text COLLATE utf8mb4_unicode_ci,
  `clickcount` text COLLATE utf8mb4_unicode_ci,
  `favourites` text COLLATE utf8mb4_unicode_ci,
  `disc_type` text COLLATE utf8mb4_unicode_ci,
  `disc_value` text COLLATE utf8mb4_unicode_ci,
  `image_text` text COLLATE utf8mb4_unicode_ci,
  `barcode_value` text COLLATE utf8mb4_unicode_ci,
  `checked` text COLLATE utf8mb4_unicode_ci,
  `print_value` text COLLATE utf8mb4_unicode_ci,
  `quantity_sold` int(11) DEFAULT NULL,
  `minimum_qty` text COLLATE utf8mb4_unicode_ci,
  `minimum_qty_copy` text COLLATE utf8mb4_unicode_ci,
  `add_qty` text COLLATE utf8mb4_unicode_ci,
  `status_low` text COLLATE utf8mb4_unicode_ci,
  `status_qty_updated` text COLLATE utf8mb4_unicode_ci,
  `individual_price` text COLLATE utf8mb4_unicode_ci,
  `unit_type` text COLLATE utf8mb4_unicode_ci,
  `tax_value` text COLLATE utf8mb4_unicode_ci,
  `itemtax2` text COLLATE utf8mb4_unicode_ci,
  `tax_value2` text COLLATE utf8mb4_unicode_ci,
  `itemtax3` text COLLATE utf8mb4_unicode_ci,
  `tax_value3` text COLLATE utf8mb4_unicode_ci,
  `itemtax4` text COLLATE utf8mb4_unicode_ci,
  `tax_value4` text COLLATE utf8mb4_unicode_ci,
  `itemtax5` text COLLATE utf8mb4_unicode_ci,
  `tax_value5` text COLLATE utf8mb4_unicode_ci,
  `status_temp` text COLLATE utf8mb4_unicode_ci,
  `status_perm` text COLLATE utf8mb4_unicode_ci,
  `variant1` text COLLATE utf8mb4_unicode_ci,
  `variant_price1` text COLLATE utf8mb4_unicode_ci,
  `variant2` text COLLATE utf8mb4_unicode_ci,
  `variant_price2` text COLLATE utf8mb4_unicode_ci,
  `variant3` text COLLATE utf8mb4_unicode_ci,
  `variant_price3` text COLLATE utf8mb4_unicode_ci,
  `variant4` text COLLATE utf8mb4_unicode_ci,
  `variant_price4` text COLLATE utf8mb4_unicode_ci,
  `variant5` text COLLATE utf8mb4_unicode_ci,
  `variant_price5` text COLLATE utf8mb4_unicode_ci,
  `dept_name` text COLLATE utf8mb4_unicode_ci,
  `add_qty_st` text COLLATE utf8mb4_unicode_ci,
  `status_qty_updated_st` text COLLATE utf8mb4_unicode_ci,
  `out_of_stock` text COLLATE utf8mb4_unicode_ci,
  `mod_set1` text COLLATE utf8mb4_unicode_ci,
  `mod_set2` text COLLATE utf8mb4_unicode_ci,
  `mod_set3` text COLLATE utf8mb4_unicode_ci,
  `mod_set4` text COLLATE utf8mb4_unicode_ci,
  `mod_set5` text COLLATE utf8mb4_unicode_ci,
  `is_veg` text COLLATE utf8mb4_unicode_ci,
  `packing_charges` text COLLATE utf8mb4_unicode_ci,
  `v1_oofstock` text COLLATE utf8mb4_unicode_ci,
  `v2_oofstock` text COLLATE utf8mb4_unicode_ci,
  `v3_oofstock` text COLLATE utf8mb4_unicode_ci,
  `v4_oofstock` text COLLATE utf8mb4_unicode_ci,
  `v5_oofstock` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `items1`
--

CREATE TABLE `items1` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `price` decimal(10,0) DEFAULT NULL,
  `stockquan` decimal(10,0) DEFAULT NULL,
  `category` text COLLATE utf8mb4_unicode_ci,
  `itemtax` text COLLATE utf8mb4_unicode_ci,
  `image` text COLLATE utf8mb4_unicode_ci,
  `weekdaysvalue` text COLLATE utf8mb4_unicode_ci,
  `weekendsvalue` text COLLATE utf8mb4_unicode_ci,
  `manualstockvalue` text COLLATE utf8mb4_unicode_ci,
  `automaticstockresetvalue` text COLLATE utf8mb4_unicode_ci,
  `clickcount` text COLLATE utf8mb4_unicode_ci,
  `favourites` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemsort`
--

CREATE TABLE `itemsort` (
  `_id` int(11) NOT NULL,
  `itemsorttype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `itemsstockvalue`
--

CREATE TABLE `itemsstockvalue` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `weekdaysvalue` text COLLATE utf8mb4_unicode_ci,
  `weekendsvalue` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `items_temp_list`
--

CREATE TABLE `items_temp_list` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `avg_price` text COLLATE utf8mb4_unicode_ci,
  `min_price` text COLLATE utf8mb4_unicode_ci,
  `max_price` text COLLATE utf8mb4_unicode_ci,
  `total_qty` text COLLATE utf8mb4_unicode_ci,
  `total_price` text COLLATE utf8mb4_unicode_ci,
  `barcode` text COLLATE utf8mb4_unicode_ci,
  `not_required` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `kot_print`
--

CREATE TABLE `kot_print` (
  `_id` int(11) NOT NULL,
  `kot_print_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `logo`
--

CREATE TABLE `logo` (
  `_id` int(11) NOT NULL,
  `companylogo` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `loyalty_points`
--

CREATE TABLE `loyalty_points` (
  `_id` int(11) NOT NULL,
  `money` text COLLATE utf8mb4_unicode_ci,
  `point` text COLLATE utf8mb4_unicode_ci,
  `point2` text COLLATE utf8mb4_unicode_ci,
  `money2` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `loyalty_points_status`
--

CREATE TABLE `loyalty_points_status` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menulogin_checking`
--

CREATE TABLE `menulogin_checking` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `modifiers`
--

CREATE TABLE `modifiers` (
  `_id` int(11) NOT NULL,
  `modifiername` text COLLATE utf8mb4_unicode_ci,
  `modprice` decimal(10,0) DEFAULT NULL,
  `modstockquan` decimal(10,0) DEFAULT NULL,
  `modcategory` text COLLATE utf8mb4_unicode_ci,
  `moditemtax` text COLLATE utf8mb4_unicode_ci,
  `modimage` text COLLATE utf8mb4_unicode_ci,
  `mod_image_text` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `name_dept1`
--

CREATE TABLE `name_dept1` (
  `_id` int(11) NOT NULL,
  `dept1_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `name_dept2`
--

CREATE TABLE `name_dept2` (
  `_id` int(11) NOT NULL,
  `dept2_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `name_dept3`
--

CREATE TABLE `name_dept3` (
  `_id` int(11) NOT NULL,
  `dept3_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `name_dept4`
--

CREATE TABLE `name_dept4` (
  `_id` int(11) NOT NULL,
  `dept4_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `online_order_form`
--

CREATE TABLE `online_order_form` (
  `_id` int(11) NOT NULL,
  `date_of_order` text COLLATE utf8mb4_unicode_ci,
  `rest_name` text COLLATE utf8mb4_unicode_ci,
  `rest_addre` text COLLATE utf8mb4_unicode_ci,
  `rest_num` text COLLATE utf8mb4_unicode_ci,
  `rest_emailid` text COLLATE utf8mb4_unicode_ci,
  `gst_no` text COLLATE utf8mb4_unicode_ci,
  `owners_name` text COLLATE utf8mb4_unicode_ci,
  `owners_num` text COLLATE utf8mb4_unicode_ci,
  `owners_email_id` text COLLATE utf8mb4_unicode_ci,
  `zomato_rela_manag_email_id` text COLLATE utf8mb4_unicode_ci,
  `zomato_regi_email_id` text COLLATE utf8mb4_unicode_ci,
  `zomato_order_url` text COLLATE utf8mb4_unicode_ci,
  `menu_timings` text COLLATE utf8mb4_unicode_ci,
  `deli_charg` text COLLATE utf8mb4_unicode_ci,
  `pack_charg` text COLLATE utf8mb4_unicode_ci,
  `gst_any` text COLLATE utf8mb4_unicode_ci,
  `contact_num` text COLLATE utf8mb4_unicode_ci,
  `swiggy_relat_manag_email_id` text COLLATE utf8mb4_unicode_ci,
  `swiggy_order_url` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ordertaking_server_ip`
--

CREATE TABLE `ordertaking_server_ip` (
  `_id` int(11) NOT NULL,
  `ipname` text COLLATE utf8mb4_unicode_ci,
  `port` text COLLATE utf8mb4_unicode_ci,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `paytmmerchantreg`
--

CREATE TABLE `paytmmerchantreg` (
  `_id` int(11) NOT NULL,
  `Account` text COLLATE utf8mb4_unicode_ci,
  `MerchantName` text COLLATE utf8mb4_unicode_ci,
  `guid` text COLLATE utf8mb4_unicode_ci,
  `MID` text COLLATE utf8mb4_unicode_ci,
  `Merchant_key` text COLLATE utf8mb4_unicode_ci,
  `PosID` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `printerconnectivity`
--

CREATE TABLE `printerconnectivity` (
  `_id` int(11) NOT NULL,
  `printercontype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `printerreceiptsize`
--

CREATE TABLE `printerreceiptsize` (
  `_id` int(11) NOT NULL,
  `papersize` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `printer_text_size`
--

CREATE TABLE `printer_text_size` (
  `_id` int(11) NOT NULL,
  `type` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `printer_type`
--

CREATE TABLE `printer_type` (
  `_id` int(11) NOT NULL,
  `printer_type` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `_id` int(11) NOT NULL,
  `email` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quickaccess`
--

CREATE TABLE `quickaccess` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quickedit`
--

CREATE TABLE `quickedit` (
  `_id` int(11) NOT NULL,
  `quickedittype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `razorpaymerchantreg`
--

CREATE TABLE `razorpaymerchantreg` (
  `_id` int(11) NOT NULL,
  `account` text COLLATE utf8mb4_unicode_ci,
  `account_id` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `resetfrequencyrestaurant`
--

CREATE TABLE `resetfrequencyrestaurant` (
  `_id` int(11) NOT NULL,
  `resetfrequencyrestaurant` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `resetfrequencyretail`
--

CREATE TABLE `resetfrequencyretail` (
  `_id` int(11) NOT NULL,
  `resetfrequencyretail` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `restaurant_id`
--

CREATE TABLE `restaurant_id` (
  `_id` int(11) NOT NULL,
  `merchant_id` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `round_off`
--

CREATE TABLE `round_off` (
  `_id` int(11) NOT NULL,
  `round_off_status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `schedule_mail_on_off`
--

CREATE TABLE `schedule_mail_on_off` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `schedule_mail_time`
--

CREATE TABLE `schedule_mail_time` (
  `_id` int(11) NOT NULL,
  `time` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stockcontrol`
--

CREATE TABLE `stockcontrol` (
  `_id` int(11) NOT NULL,
  `stockcontroltype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stockreset`
--

CREATE TABLE `stockreset` (
  `_id` int(11) NOT NULL,
  `stockresettype` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stockresetmode`
--

CREATE TABLE `stockresetmode` (
  `_id` int(11) NOT NULL,
  `stockresetoptionsmode` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `stock_transfer_item_details`
--

CREATE TABLE `stock_transfer_item_details` (
  `_id` int(11) NOT NULL,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `qty_add` text COLLATE utf8mb4_unicode_ci,
  `company` text COLLATE utf8mb4_unicode_ci,
  `from_store` text COLLATE utf8mb4_unicode_ci,
  `from_device` text COLLATE utf8mb4_unicode_ci,
  `to_store` text COLLATE utf8mb4_unicode_ci,
  `to_device` text COLLATE utf8mb4_unicode_ci,
  `from_time` text COLLATE utf8mb4_unicode_ci,
  `from_date` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_from` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `storedays`
--

CREATE TABLE `storedays` (
  `_id` int(11) NOT NULL,
  `weekdays` text COLLATE utf8mb4_unicode_ci,
  `weekends` text COLLATE utf8mb4_unicode_ci,
  `swap` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sync_time`
--

CREATE TABLE `sync_time` (
  `_id` int(11) NOT NULL,
  `last_time` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `table_kot`
--

CREATE TABLE `table_kot` (
  `_id` int(11) NOT NULL,
  `status` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `_id` int(11) NOT NULL,
  `taxname` text COLLATE utf8mb4_unicode_ci,
  `value` decimal(10,2) DEFAULT NULL,
  `taxtype` text COLLATE utf8mb4_unicode_ci,
  `checked` text COLLATE utf8mb4_unicode_ci,
  `tax1` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `hsn_code` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `tax_selec`
--

CREATE TABLE `tax_selec` (
  `_id` int(11) NOT NULL,
  `tax_amount` text COLLATE utf8mb4_unicode_ci,
  `tax_per` text COLLATE utf8mb4_unicode_ci,
  `selected_but` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `totaltables`
--

CREATE TABLE `totaltables` (
  `_id` int(11) NOT NULL,
  `nooftables` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_privilege`
--

CREATE TABLE `user_privilege` (
  `_id` int(11) NOT NULL,
  `username` text COLLATE utf8mb4_unicode_ci,
  `returns_refunds` text COLLATE utf8mb4_unicode_ci,
  `product_tax` text COLLATE utf8mb4_unicode_ci,
  `reports` text COLLATE utf8mb4_unicode_ci,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `backup` text COLLATE utf8mb4_unicode_ci,
  `customer` text COLLATE utf8mb4_unicode_ci,
  `ingredients` text COLLATE utf8mb4_unicode_ci,
  `subscriptions` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variants_temp`
--

CREATE TABLE `variants_temp` (
  `_id` int(11) NOT NULL,
  `vari1` text COLLATE utf8mb4_unicode_ci,
  `varprice1` text COLLATE utf8mb4_unicode_ci,
  `vari2` text COLLATE utf8mb4_unicode_ci,
  `varprice2` text COLLATE utf8mb4_unicode_ci,
  `vari3` text COLLATE utf8mb4_unicode_ci,
  `varprice3` text COLLATE utf8mb4_unicode_ci,
  `vari4` text COLLATE utf8mb4_unicode_ci,
  `varprice4` text COLLATE utf8mb4_unicode_ci,
  `vari5` text COLLATE utf8mb4_unicode_ci,
  `varprice5` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_details`
--

CREATE TABLE `vendor_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `vendor_email` text COLLATE utf8mb4_unicode_ci,
  `vendor_address` text COLLATE utf8mb4_unicode_ci,
  `vendor_gst` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_details_micro`
--

CREATE TABLE `vendor_details_micro` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `vendor_email` text COLLATE utf8mb4_unicode_ci,
  `vendor_address` text COLLATE utf8mb4_unicode_ci,
  `vendor_gst` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_sold_details`
--

CREATE TABLE `vendor_sold_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `invoice` text COLLATE utf8mb4_unicode_ci,
  `billamount` text COLLATE utf8mb4_unicode_ci,
  `tax_percent` text COLLATE utf8mb4_unicode_ci,
  `tax_amount` text COLLATE utf8mb4_unicode_ci,
  `disc_percent` text COLLATE utf8mb4_unicode_ci,
  `disc_amount` text COLLATE utf8mb4_unicode_ci,
  `total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `from_time` text COLLATE utf8mb4_unicode_ci,
  `from_date` text COLLATE utf8mb4_unicode_ci,
  `due_date` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_from` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_due` text COLLATE utf8mb4_unicode_ci,
  `pay` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `total_pay` text COLLATE utf8mb4_unicode_ci,
  `pay_date` text COLLATE utf8mb4_unicode_ci,
  `pay_time` text COLLATE utf8mb4_unicode_ci,
  `pay_datetimeemew` text COLLATE utf8mb4_unicode_ci,
  `not_required` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_sold_item_details`
--

CREATE TABLE `vendor_sold_item_details` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vendor_phoneno` text COLLATE utf8mb4_unicode_ci,
  `itemname` text COLLATE utf8mb4_unicode_ci,
  `qty_add` text COLLATE utf8mb4_unicode_ci,
  `individual_price` text COLLATE utf8mb4_unicode_ci,
  `total_price` text COLLATE utf8mb4_unicode_ci,
  `invoice` text COLLATE utf8mb4_unicode_ci,
  `billamount` text COLLATE utf8mb4_unicode_ci,
  `tax_percent` text COLLATE utf8mb4_unicode_ci,
  `tax_amount` text COLLATE utf8mb4_unicode_ci,
  `disc_percent` text COLLATE utf8mb4_unicode_ci,
  `disc_amount` text COLLATE utf8mb4_unicode_ci,
  `total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `from_time` text COLLATE utf8mb4_unicode_ci,
  `from_date` text COLLATE utf8mb4_unicode_ci,
  `due_date` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_from` text COLLATE utf8mb4_unicode_ci,
  `datetimee_new_due` text COLLATE utf8mb4_unicode_ci,
  `pay` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `tax1` text COLLATE utf8mb4_unicode_ci,
  `tax2` text COLLATE utf8mb4_unicode_ci,
  `tax3` text COLLATE utf8mb4_unicode_ci,
  `tax4` text COLLATE utf8mb4_unicode_ci,
  `tax5` text COLLATE utf8mb4_unicode_ci,
  `tax6` text COLLATE utf8mb4_unicode_ci,
  `tax7` text COLLATE utf8mb4_unicode_ci,
  `tax8` text COLLATE utf8mb4_unicode_ci,
  `tax9` text COLLATE utf8mb4_unicode_ci,
  `tax10` text COLLATE utf8mb4_unicode_ci,
  `tax11` text COLLATE utf8mb4_unicode_ci,
  `tax12` text COLLATE utf8mb4_unicode_ci,
  `tax13` text COLLATE utf8mb4_unicode_ci,
  `tax14` text COLLATE utf8mb4_unicode_ci,
  `tax15` text COLLATE utf8mb4_unicode_ci,
  `tax1_value` text COLLATE utf8mb4_unicode_ci,
  `tax2_value` text COLLATE utf8mb4_unicode_ci,
  `tax3_value` text COLLATE utf8mb4_unicode_ci,
  `tax4_value` text COLLATE utf8mb4_unicode_ci,
  `tax5_value` text COLLATE utf8mb4_unicode_ci,
  `tax6_value` text COLLATE utf8mb4_unicode_ci,
  `tax7_value` text COLLATE utf8mb4_unicode_ci,
  `tax8_value` text COLLATE utf8mb4_unicode_ci,
  `tax9_value` text COLLATE utf8mb4_unicode_ci,
  `tax10_value` text COLLATE utf8mb4_unicode_ci,
  `tax11_value` text COLLATE utf8mb4_unicode_ci,
  `tax12_value` text COLLATE utf8mb4_unicode_ci,
  `tax13_value` text COLLATE utf8mb4_unicode_ci,
  `tax14_value` text COLLATE utf8mb4_unicode_ci,
  `tax15_value` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_temp_list`
--

CREATE TABLE `vendor_temp_list` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vend_phon` text COLLATE utf8mb4_unicode_ci,
  `vend_email` text COLLATE utf8mb4_unicode_ci,
  `vend_gst` text COLLATE utf8mb4_unicode_ci,
  `vend_address` text COLLATE utf8mb4_unicode_ci,
  `vend_total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `paid` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `bill_no` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_temp_list_ingredient`
--

CREATE TABLE `vendor_temp_list_ingredient` (
  `_id` int(11) NOT NULL,
  `vendor_name` text COLLATE utf8mb4_unicode_ci,
  `vend_phon` text COLLATE utf8mb4_unicode_ci,
  `vend_email` text COLLATE utf8mb4_unicode_ci,
  `vend_gst` text COLLATE utf8mb4_unicode_ci,
  `vend_address` text COLLATE utf8mb4_unicode_ci,
  `vend_total_bill_amount` text COLLATE utf8mb4_unicode_ci,
  `paid` text COLLATE utf8mb4_unicode_ci,
  `pending` text COLLATE utf8mb4_unicode_ci,
  `bill_no` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `version_control`
--

CREATE TABLE `version_control` (
  `_id` int(11) NOT NULL,
  `version` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `weighing_scale_name`
--

CREATE TABLE `weighing_scale_name` (
  `_id` int(11) NOT NULL,
  `scale_name` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `weighing_scale_status`
--

CREATE TABLE `weighing_scale_status` (
  `_id` int(11) NOT NULL,
  `Weighing_Scale_onoff` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `working_hours`
--

CREATE TABLE `working_hours` (
  `_id` int(11) NOT NULL,
  `opening` text COLLATE utf8mb4_unicode_ci,
  `opening_time` text COLLATE utf8mb4_unicode_ci,
  `closing` text COLLATE utf8mb4_unicode_ci,
  `closing_time` text COLLATE utf8mb4_unicode_ci,
  `opening_time_system` text COLLATE utf8mb4_unicode_ci,
  `closing_time_system` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_selection`
--
ALTER TABLE `account_selection`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `alaramdays`
--
ALTER TABLE `alaramdays`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `alaramon_off`
--
ALTER TABLE `alaramon_off`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `alaramtime`
--
ALTER TABLE `alaramtime`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `asd1`
--
ALTER TABLE `asd1`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `auto_connect`
--
ALTER TABLE `auto_connect`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `auto_generate_barcode`
--
ALTER TABLE `auto_generate_barcode`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `barcodescannerconnectivity`
--
ALTER TABLE `barcodescannerconnectivity`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `billcount_tag`
--
ALTER TABLE `billcount_tag`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `billingmode`
--
ALTER TABLE `billingmode`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `billingtype`
--
ALTER TABLE `billingtype`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `btconn`
--
ALTER TABLE `btconn`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cardswiperactivation`
--
ALTER TABLE `cardswiperactivation`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `cashdrawerconnectivity`
--
ALTER TABLE `cashdrawerconnectivity`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `change_time_format`
--
ALTER TABLE `change_time_format`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `companydetailss`
--
ALTER TABLE `companydetailss`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `country_selection`
--
ALTER TABLE `country_selection`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `default_credit`
--
ALTER TABLE `default_credit`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `deletedbon_off`
--
ALTER TABLE `deletedbon_off`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `deletedb_time`
--
ALTER TABLE `deletedb_time`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `discount_details`
--
ALTER TABLE `discount_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `discount_selec`
--
ALTER TABLE `discount_selec`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `discount_types`
--
ALTER TABLE `discount_types`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `email_recipient`
--
ALTER TABLE `email_recipient`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `estimate_print`
--
ALTER TABLE `estimate_print`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `floors`
--
ALTER TABLE `floors`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `freetrail`
--
ALTER TABLE `freetrail`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `homedelivery_prints`
--
ALTER TABLE `homedelivery_prints`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `home_check`
--
ALTER TABLE `home_check`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `hotel`
--
ALTER TABLE `hotel`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `hotel1`
--
ALTER TABLE `hotel1`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredients`
--
ALTER TABLE `ingredients`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredients_item_selection_temp`
--
ALTER TABLE `ingredients_item_selection_temp`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredients_temp_list`
--
ALTER TABLE `ingredients_temp_list`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredient_items_list`
--
ALTER TABLE `ingredient_items_list`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredient_sold_details`
--
ALTER TABLE `ingredient_sold_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredient_sold_item_details`
--
ALTER TABLE `ingredient_sold_item_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ingredient_vendor_details`
--
ALTER TABLE `ingredient_vendor_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn`
--
ALTER TABLE `ipconn`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn_counter`
--
ALTER TABLE `ipconn_counter`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn_kot1`
--
ALTER TABLE `ipconn_kot1`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn_kot2`
--
ALTER TABLE `ipconn_kot2`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn_kot3`
--
ALTER TABLE `ipconn_kot3`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ipconn_kot4`
--
ALTER TABLE `ipconn_kot4`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`_id`);

--
-- Indexes for table `items1`
--
ALTER TABLE `items1`
  ADD PRIMARY KEY (`_id`);

--
-- Indexes for table `itemsort`
--
ALTER TABLE `itemsort`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `itemsstockvalue`
--
ALTER TABLE `itemsstockvalue`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `items_temp_list`
--
ALTER TABLE `items_temp_list`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `kot_print`
--
ALTER TABLE `kot_print`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `logo`
--
ALTER TABLE `logo`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `loyalty_points`
--
ALTER TABLE `loyalty_points`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `loyalty_points_status`
--
ALTER TABLE `loyalty_points_status`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `menulogin_checking`
--
ALTER TABLE `menulogin_checking`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `modifiers`
--
ALTER TABLE `modifiers`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `name_dept1`
--
ALTER TABLE `name_dept1`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `name_dept2`
--
ALTER TABLE `name_dept2`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `name_dept3`
--
ALTER TABLE `name_dept3`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `name_dept4`
--
ALTER TABLE `name_dept4`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `online_order_form`
--
ALTER TABLE `online_order_form`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `ordertaking_server_ip`
--
ALTER TABLE `ordertaking_server_ip`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `paytmmerchantreg`
--
ALTER TABLE `paytmmerchantreg`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `printerconnectivity`
--
ALTER TABLE `printerconnectivity`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `printerreceiptsize`
--
ALTER TABLE `printerreceiptsize`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `printer_text_size`
--
ALTER TABLE `printer_text_size`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `printer_type`
--
ALTER TABLE `printer_type`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `promotions`
--
ALTER TABLE `promotions`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `quickaccess`
--
ALTER TABLE `quickaccess`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `quickedit`
--
ALTER TABLE `quickedit`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `razorpaymerchantreg`
--
ALTER TABLE `razorpaymerchantreg`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `resetfrequencyrestaurant`
--
ALTER TABLE `resetfrequencyrestaurant`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `resetfrequencyretail`
--
ALTER TABLE `resetfrequencyretail`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `restaurant_id`
--
ALTER TABLE `restaurant_id`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `round_off`
--
ALTER TABLE `round_off`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `schedule_mail_on_off`
--
ALTER TABLE `schedule_mail_on_off`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `schedule_mail_time`
--
ALTER TABLE `schedule_mail_time`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `stockcontrol`
--
ALTER TABLE `stockcontrol`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `stockreset`
--
ALTER TABLE `stockreset`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `stockresetmode`
--
ALTER TABLE `stockresetmode`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `stock_transfer_item_details`
--
ALTER TABLE `stock_transfer_item_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `storedays`
--
ALTER TABLE `storedays`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `sync_time`
--
ALTER TABLE `sync_time`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `table_kot`
--
ALTER TABLE `table_kot`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `tax_selec`
--
ALTER TABLE `tax_selec`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `totaltables`
--
ALTER TABLE `totaltables`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `user_privilege`
--
ALTER TABLE `user_privilege`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `variants_temp`
--
ALTER TABLE `variants_temp`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_details`
--
ALTER TABLE `vendor_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_details_micro`
--
ALTER TABLE `vendor_details_micro`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_sold_details`
--
ALTER TABLE `vendor_sold_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_sold_item_details`
--
ALTER TABLE `vendor_sold_item_details`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_temp_list`
--
ALTER TABLE `vendor_temp_list`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `vendor_temp_list_ingredient`
--
ALTER TABLE `vendor_temp_list_ingredient`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `version_control`
--
ALTER TABLE `version_control`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `weighing_scale_name`
--
ALTER TABLE `weighing_scale_name`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `weighing_scale_status`
--
ALTER TABLE `weighing_scale_status`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- Indexes for table `working_hours`
--
ALTER TABLE `working_hours`
  ADD PRIMARY KEY (`_id`),
  ADD UNIQUE KEY `_id` (`_id`);

--
-- AUTO_INCREMENT for table `alaramdays`
--
ALTER TABLE `alaramdays`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `asd1`
--
ALTER TABLE `asd1`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `auto_connect`
--
ALTER TABLE `auto_connect`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `barcodescannerconnectivity`
--
ALTER TABLE `barcodescannerconnectivity`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `billingmode`
--
ALTER TABLE `billingmode`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `billingtype`
--
ALTER TABLE `billingtype`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cardswiperactivation`
--
ALTER TABLE `cardswiperactivation`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cashdrawerconnectivity`
--
ALTER TABLE `cashdrawerconnectivity`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `companydetailss`
--
ALTER TABLE `companydetailss`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `discount_types`
--
ALTER TABLE `discount_types`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `estimate_print`
--
ALTER TABLE `estimate_print`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_check`
--
ALTER TABLE `home_check`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hotel`
--
ALTER TABLE `hotel`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ingredients_temp_list`
--
ALTER TABLE `ingredients_temp_list`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ingredient_items_list`
--
ALTER TABLE `ingredient_items_list`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ingredient_sold_details`
--
ALTER TABLE `ingredient_sold_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ingredient_sold_item_details`
--
ALTER TABLE `ingredient_sold_item_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ingredient_vendor_details`
--
ALTER TABLE `ingredient_vendor_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `items1`
--
ALTER TABLE `items1`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `itemsort`
--
ALTER TABLE `itemsort`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `itemsstockvalue`
--
ALTER TABLE `itemsstockvalue`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kot_print`
--
ALTER TABLE `kot_print`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `menulogin_checking`
--
ALTER TABLE `menulogin_checking`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `modifiers`
--
ALTER TABLE `modifiers`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `paytmmerchantreg`
--
ALTER TABLE `paytmmerchantreg`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `printerconnectivity`
--
ALTER TABLE `printerconnectivity`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `printerreceiptsize`
--
ALTER TABLE `printerreceiptsize`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `printer_type`
--
ALTER TABLE `printer_type`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quickaccess`
--
ALTER TABLE `quickaccess`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quickedit`
--
ALTER TABLE `quickedit`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `razorpaymerchantreg`
--
ALTER TABLE `razorpaymerchantreg`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resetfrequencyrestaurant`
--
ALTER TABLE `resetfrequencyrestaurant`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `resetfrequencyretail`
--
ALTER TABLE `resetfrequencyretail`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `round_off`
--
ALTER TABLE `round_off`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stockcontrol`
--
ALTER TABLE `stockcontrol`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stockreset`
--
ALTER TABLE `stockreset`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stockresetmode`
--
ALTER TABLE `stockresetmode`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `stock_transfer_item_details`
--
ALTER TABLE `stock_transfer_item_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `storedays`
--
ALTER TABLE `storedays`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sync_time`
--
ALTER TABLE `sync_time`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `table_kot`
--
ALTER TABLE `table_kot`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `taxes`
--
ALTER TABLE `taxes`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `totaltables`
--
ALTER TABLE `totaltables`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `variants_temp`
--
ALTER TABLE `variants_temp`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_details`
--
ALTER TABLE `vendor_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_details_micro`
--
ALTER TABLE `vendor_details_micro`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_sold_details`
--
ALTER TABLE `vendor_sold_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_sold_item_details`
--
ALTER TABLE `vendor_sold_item_details`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_temp_list`
--
ALTER TABLE `vendor_temp_list`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_temp_list_ingredient`
--
ALTER TABLE `vendor_temp_list_ingredient`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `weighing_scale_name`
--
ALTER TABLE `weighing_scale_name`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `weighing_scale_status`
--
ALTER TABLE `weighing_scale_status`
  MODIFY `_id` int(11) NOT NULL AUTO_INCREMENT;



INSERT INTO `account_selection` (`_id`, `selection`) VALUES
(1, 'Dine');

--
-- Dumping data for table `alaramdays`
--

INSERT INTO `alaramdays` (`_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES
(1, 'Monday', '0', '0'),
(2, 'Tuesday', '0', '0'),
(3, 'Wednesday', '0', '0'),
(4, 'Thursday', '0', '0'),
(5, 'Friday', '0', '0'),
(6, 'Saturday', '0', '0'),
(7, 'Sunday', '0', '0');

--
-- Dumping data for table `alaramon_off`
--

INSERT INTO `alaramon_off` (`_id`, `status`) VALUES
(1, 'On');

--
-- Dumping data for table `alaramtime`
--

INSERT INTO `alaramtime` (`_id`, `time`) VALUES
(1, '11:30 PM');

--
-- Dumping data for table `asd1`
--

INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES
(1, '', '1', NULL, 'first', '0', '4', NULL);

--
-- Dumping data for table `auto_connect`
--

INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES
(1, 'No');

--
-- Dumping data for table `auto_generate_barcode`
--

INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES
(1, 'off');

--
-- Dumping data for table `billingmode`
--

INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES
(1, 'Fine dine');

--
-- Dumping data for table `billingtype`
--

INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES
(1, 'Dine-in');

--
-- Dumping data for table `btconn`
--

INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES
(1, '', '', '', NULL);

--
-- Dumping data for table `cardswiperactivation`
--

INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES
(1, 'PaySwiff', '', '', 'Not Activated'),
(2, 'mSwipe', '', '', 'Not Activated'),
(3, 'PineLabs', '', '', 'Not Activated'),
(4, 'Firstdata', '', '', 'Not Activated'),
(5, 'Paytm', '', '', 'Not Activated'),
(6, 'ezetap', '', '', 'Not Activated');

--
-- Dumping data for table `change_time_format`
--

INSERT INTO `change_time_format` (`_id`, `status`) VALUES
(1, 'changed');

--
-- Dumping data for table `country_selection`
--

INSERT INTO `country_selection` (`_id`, `country`) VALUES
(1, 'India');

--
-- Dumping data for table `default_credit`
--

INSERT INTO `default_credit` (`_id`, `status`) VALUES
(1, 'off');

--
-- Dumping data for table `deletedbon_off`
--

INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES
(1, 'off');

--
-- Dumping data for table `deletedb_time`
--

INSERT INTO `deletedb_time` (`_id`, `time`) VALUES
(1, '11:30 PM');

--
-- Dumping data for table `estimate_print`
--

INSERT INTO `estimate_print` (`_id`, `status`) VALUES
(1, 'Yes');

--
-- Dumping data for table `floors`
--

INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES
(1, 'first', '0');

--
-- Dumping data for table `freetrail`
--

INSERT INTO `freetrail` (`_id`, `status`) VALUES
(1, 'Activated');

--
-- Dumping data for table `homedelivery_prints`
--

INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES
(1, 'yes', 'yes');

--
-- Dumping data for table `home_check`
--

INSERT INTO `home_check` (`_id`, `login_status`) VALUES
(1, '1');


--
-- Dumping data for table `ipconn`
--

INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES
(1, '192.168.1.87', '9100', '', 'TM Printer');

--
-- Dumping data for table `ipconn_counter`
--

INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES
(1, '192.168.1.92', '9100', '', NULL);

--
-- Dumping data for table `ipconn_kot1`
--

INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES
(1, '192.168.1.88', '9100', '', NULL, 'kot1');

--
-- Dumping data for table `ipconn_kot2`
--

INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES
(1, '192.168.1.89', '9100', '', NULL, 'kot2');

--
-- Dumping data for table `ipconn_kot3`
--

INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES
(1, '192.168.1.90', '9100', '', NULL, 'kot3');

--
-- Dumping data for table `ipconn_kot4`
--

INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES
(1, '192.168.1.91', '9100', '', NULL, 'kot4');

--
-- Dumping data for table `items`
--

INSERT INTO hotel (_id, name, direccion, telefono, email, value) VALUES
(1, 'All', NULL, NULL, NULL, NULL),
(2, 'Favourites', NULL, NULL, NULL, NULL),
(3, 'Tiffin', NULL, NULL, NULL, NULL),
(4, 'Snacks', NULL, NULL, NULL, NULL),
(5, 'Main course', NULL, NULL, NULL, NULL),
(6, 'Drinks', NULL, NULL, NULL, NULL),
(7, 'Desserts', NULL, NULL, NULL, NULL);

INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES
(1, 'idly', '25.00', '50', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'dosa', '35.00', '50', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'pongal', '30.00', '49', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'upma', '30.00', '50', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'poori', '35.00', '50', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'masal dosa', '40.00', '50', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'bread omlette', '30.00', '20', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'onion dosa', '35.00', '30', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES
(9, 'rava dosa', '35.00', '30', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 'uthappam', '30.00', '30', 'Tiffin', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'vada', '20.00', '100', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 'masal vada', '20.00', '50', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 'samosa', '20.00', '50', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 'chicken kabab', '60.00', '20', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 'sheekh kabab', '80.00', '20', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'pani puri', '35.00', '30', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES
(17, 'pav bhajji', '60.00', '30', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 'veg cutlet', '40.00', '30', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 'masal puri', '35.00', '30', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'chicken nuggets', '65.00', '10', 'Snacks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 'veg biriyani', '70.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'chicken biriyani', '100.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, 'veg thali', '50.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 'non veg thali', '80.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES
(25, 'mutton biriyani', '120.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 'roti', '15.00', '100', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 'rice', '30.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 'paneer butter masala', '60.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 'chicken sukka', '80.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, 'dhal fry', '30.00', '50', 'Main course', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 'coffee', '20.00', '100', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 'tea', '20.00', '50', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `items` (`_id`, `itemname`, `price`, `stockquan`, `category`, `itemtax`, `image`, `weekdaysvalue`, `weekendsvalue`, `manualstockvalue`, `automaticstockresetvalue`, `clickcount`, `favourites`, `disc_type`, `disc_value`, `image_text`, `barcode_value`, `checked`, `print_value`, `quantity_sold`, `minimum_qty`, `minimum_qty_copy`, `add_qty`, `status_low`, `status_qty_updated`, `individual_price`, `unit_type`, `tax_value`, `itemtax2`, `tax_value2`, `itemtax3`, `tax_value3`, `itemtax4`, `tax_value4`, `itemtax5`, `tax_value5`, `status_temp`, `status_perm`, `variant1`, `variant_price1`, `variant2`, `variant_price2`, `variant3`, `variant_price3`, `variant4`, `variant_price4`, `variant5`, `variant_price5`, `dept_name`, `add_qty_st`, `status_qty_updated_st`, `out_of_stock`, `mod_set1`, `mod_set2`, `mod_set3`, `mod_set4`, `mod_set5`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES
(33, 'masala chai', '25.00', '50', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 'soft drinks', '10.00', '50', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 'lime juice', '15.00', '30', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, 'lassi', '25.00', '25', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 'grape juice', '25.00', '25', 'Drinks', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 'vanilla icecream', '35.00', '50', 'Desserts', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'yes', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 'butterscotch icecream', '40.00', '50', 'Desserts', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, 'butterscotch cake', '35.00', '50', 'Desserts', 'None', '[BLOB]', '0', '0', NULL, NULL, NULL, 'no', '%', '0', NULL, '', NULL, NULL, 0, '0', '0', '0', NULL, NULL, NULL, 'Unit', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

--
-- Dumping data for table `itemsort`
--

INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES
(1, 'Sort by Date added');

--
-- Dumping data for table `kot_print`
--

INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES
(1, 'Yes');

--
-- Dumping data for table `loyalty_points`
--

INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES
(1, '0', '0', '0', '0');

--
-- Dumping data for table `loyalty_points_status`
--

INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES
(1, 'no');

--
-- Dumping data for table `menulogin_checking`
--

INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES
(1, 'no');



--
-- Dumping data for table `name_dept1`
--

INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES
(1, 'kot1');

--
-- Dumping data for table `name_dept2`
--

INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES
(1, 'kot2');

--
-- Dumping data for table `name_dept3`
--

INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES
(1, 'kot3');

--
-- Dumping data for table `name_dept4`
--

INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES
(1, 'kot4');

--
-- Dumping data for table `ordertaking_server_ip`
--

INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES
(1, '192.168.1.100', '8080', '');

--
-- Dumping data for table `paytmmerchantreg`
--

INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES
(1, 'Not_Registered', '', '', '', '', '');

--
-- Dumping data for table `printerreceiptsize`
--

INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES
(1, '2 inch');

--
-- Dumping data for table `printer_text_size`
--

INSERT INTO `printer_text_size` (`_id`, `type`) VALUES
(1, 'Standard');

--
-- Dumping data for table `printer_type`
--

INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES
(1, 'Generic');

--
-- Dumping data for table `razorpaymerchantreg`
--

INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES
(1, 'Not_Registered', '');

--
-- Dumping data for table `restaurant_id`
--

INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES
(1, '0');

--
-- Dumping data for table `round_off`
--

INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES
(1, 'No');

--
-- Dumping data for table `schedule_mail_on_off`
--

INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES
(1, 'Off');

--
-- Dumping data for table `schedule_mail_time`
--

INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES
(1, '11:30 PM');

--
-- Dumping data for table `stockcontrol`
--

INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES
(1, 'off');

--
-- Dumping data for table `stockreset`
--

INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES
(1, 'off');

--
-- Dumping data for table `storedays`
--

INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES
(1, 'Monday', '0', '0'),
(2, 'Tuesday', '0', '0'),
(3, 'Wednesday', '0', '0'),
(4, 'Thursday', '0', '0'),
(5, '0', 'Friday', 'Friday'),
(6, '0', 'Saturday', 'Saturday'),
(7, '0', 'Sunday', 'Sunday');

--
-- Dumping data for table `sync_time`
--

INSERT INTO `sync_time` (`_id`, `last_time`) VALUES
(1, '05 Apr 18, 05:22 PM');

--
-- Dumping data for table `totaltables`
--

INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES
(1, '4');

--
-- Dumping data for table `user_privilege`
--

INSERT INTO `user_privilege` (`_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES
(1, 'user1', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),
(2, 'user2', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),
(3, 'user3', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),
(4, 'user4', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),
(5, 'user5', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),
(6, 'user6', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');

--
-- Dumping data for table `version_control`
--

INSERT INTO `version_control` (`_id`, `version`) VALUES
(1, '12');

--
-- Dumping data for table `weighing_scale_status`
--

INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES
(1, 'Not Connected');

--
-- Dumping data for table `working_hours`
--

INSERT INTO `working_hours` (`_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES
(1, 'Today', '12:01 AM', 'Today', '11:59 PM', '00:01', '23:59');



COMMIT;

