INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Dine');
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');
INSERT INTO `alaramon_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,'','1',NULL,'first','0','4',NULL),(2,'','2',NULL,'first','0','4',NULL),(3,'','3',NULL,'first','0','4',NULL),(4,'b12','4',NULL,'first','0','4',NULL),(5,'c12','5',NULL,'first','0','4',NULL),(6,'c45','6',NULL,'first','0','4',NULL),(7,'d45 sh','7',NULL,'first','0','4',NULL),(8,'d12','8',NULL,'first','0','4',NULL),(9,'e45si','9',NULL,'first','0','4',NULL),(10,'e12 sh','10',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'off');
INSERT INTO `billingmode` (`_id`, `billingtype`) VALUES (1,'Fine dine');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'Dine-in');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'BTP-5842275975','00:04:3E:4F:FC:AE','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'complete disc','100','%');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'1');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
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),(8,'Maggie',NULL,NULL,NULL,NULL),(9,'Burger',NULL,NULL,NULL,NULL),(10,'Sandwich',NULL,NULL,NULL,NULL),(11,'Shev paaw',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,'rice','mutton biriyani','0.1','115.40','26 Jan 2022','202201261126','11:26:42 AM','1126','202201261126','Kg','-59.0'),(2,'rice','chicken biriyani','.1','115.40','26 Jan 2022','202201261126','11:26:42 AM','1126','202201261126','Kg','-59.0'),(3,'rice','veg biriyani','0.1','115.40','26 Jan 2022','202201261126','11:26:42 AM','1126','202201261126','Kg','-59.0'),(4,'sugar','coffee','0.1','96.60','05 Feb 2022','202202051259','12:59:11 PM','1259','202202051259','Kg','40.0'),(5,'wheat','roti','0.1','10','27 Apr 2022','202204271314','01:14:36 PM','1314','202204271314','Kg','40.0');
INSERT INTO `ingredient_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (20,'abcd','9986655589','','250.0','0','0','0','0','250.0','01:37 PM','07 May 2021','07 May 2021','202105071337','20210507','0','250.0','0','07 May 2021','01:37 PM','202105071337',''),(21,'abcd','9986655589','','1000.0','0','0','0','0','1000.0','05:32 PM','26 May 2021','26 May 2021','202105261732','20210526','0','1000.0','0','26 May 2021','05:32 PM','202105261732',''),(22,'abcd','9986655589','','2500.0','0','0','0','0','2500.0','12:38 PM','27 May 2021','27 May 2021','202105271238','20210527','0','2500.0','0','27 May 2021','12:38 PM','202105271238',''),(23,'abcd','9986655589','','1000.0','0','0','0','0','1000.0','01:30 PM','06 Jun 2021','06 Jun 2021','202106061330','20210606','0','1000.0','0','06 Jun 2021','01:30 PM','202106061330',''),(24,'xyz','9986688859','','1200.0','0','0','0','0','1200.0','12:59 PM','18 Jun 2021','18 Jun 2021','202106181259','20210618','0','1200.0','0','18 Jun 2021','12:59 PM','202106181259',''),(25,'xyz','9986688859','','3500.0','0','0','0','0','3500.0','01:05 PM','19 Jul 2021','19 Jul 2021','202107191305','20210719','0','3500.0','0','19 Jul 2021','01:05 PM','202107191305',''),(26,'abcd','9986655589','','3500.0','0','0','0','0','3500.0','03:56 PM','19 Jul 2021','19 Jul 2021','202107191556','20210719','0','3500.0','0','19 Jul 2021','03:56 PM','202107191556',''),(27,'xyz','9986688859','','3500.0','0','0','0','0','3500.0','01:40 PM','20 Jul 2021','20 Jul 2021','202107201340','20210720','0','3500.0','0','20 Jul 2021','01:40 PM','202107201340',''),(28,'abc','6698866698','','1000.0','0','0','0','0','1000.0','12:53 PM','12 Aug 2021','12 Aug 2021','202108121253','20210812','0','1000.0','0','12 Aug 2021','12:53 PM','202108121253',''),(29,'abc','6698866698','','1000.0','0','0','0','0','1000.0','12:53 PM','12 Aug 2021','12 Aug 2021','202108121253','20210812','500','500.0','500.0','12 Aug 2021','12:53 PM','202108121253',''),(30,'abc','6698866698','','1000.0','0','0','0','0','1000.0','08:37 PM','13 Aug 2021','13 Aug 2021','202108132037','20210813','0','1000.0','0','13 Aug 2021','08:37 PM','202108132037',''),(31,'abc','6698866698','','1000.0','0','0','0','0','1000.0','01:26 PM','23 Jan 2022','23 Jan 2022','202201231326','20220123','0','1000.0','0','23 Jan 2022','01:26 PM','202201231326',''),(32,'abc','6698866698','','1000.0','0','0','0','0','1000.0','11:21 AM','26 Jan 2022','26 Jan 2022','202201261121','20220126','0','1000.0','0','26 Jan 2022','11:21 AM','202201261121',''),(33,'abc','6698866698','','1000.0','0','0','0','0','1000.0','11:21 AM','26 Jan 2022','26 Jan 2022','202201261121','20220126','500','500.0','500.0','26 Jan 2022','11:22 AM','202201261122',''),(34,'abc','6698866698','','1400.0','0','0','0','0','1400.0','12:45 PM','31 Jan 2022','31 Jan 2022','202201311245','20220131','0','1400.0','0','31 Jan 2022','12:45 PM','202201311245',''),(35,'abc','6698866698','','200.0','0','0','0','0','200.0','11:53 AM','16 Mar 2022','16 Mar 2022','202203161153','20220316','0','200.0','0','16 Mar 2022','11:53 AM','202203161153',''),(36,'abc','6698866698','','400.0','0','0','0','0','400.0','11:37 AM','21 Mar 2022','21 Mar 2022','202203211137','20220321','0','400.0','0','21 Mar 2022','11:37 AM','202203211137',''),(37,'vinayak kirana wala','9986688808','','400.0','0','0','0','0','400.0','01:14 PM','25 Apr 2022','25 Apr 2022','202204251314','20220425','0','400.0','0','25 Apr 2022','01:14 PM','202204251314',''),(38,'vinayak kirana wala','9986688808','','400.0','0','0','0','0','400.0','10:54 AM','26 Apr 2022','26 Apr 2022','202204261054','20220426','0','400.0','0','26 Apr 2022','10:54 AM','202204261054',''),(39,'vinayak kirana wala','9986688808','','400.0','0','0','0','0','400.0','12:57 PM','27 Apr 2022','27 Apr 2022','202204271257','20220427','0','400.0','0','27 Apr 2022','12:57 PM','202204271257',''),(40,'vinayak kirana wala','9986688808','','400.0','0','0','0','0','400.0','12:57 PM','27 Apr 2022','27 Apr 2022','202204271257','20220427','400','0.0','400.0','27 Apr 2022','12:58 PM','202204271258',''),(41,'vinayak kirana wala','9986688808','','50.0','0','0','0','0','50.0','11:40 AM','16 May 2022','16 May 2022','202205161140','20220516','0','50.0','0','16 May 2022','11:40 AM','202205161140','');
INSERT INTO `ingredient_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`, `wastage`, `unit`) VALUES (18,'abcd','9986655589','rice','5','50','250.0','','250.0','0','0','0','0','250.0','01:37 PM','07 May 2021','07 May 2021','202105071337','20210507','','250.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(19,'abcd','9986655589','sugar','20','50','1000.0','','1000.0','0','0','0','0','1000.0','05:32 PM','26 May 2021','26 May 2021','202105261732','20210526','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(20,'abcd','9986655589','rice','50','50','2500.0','','2500.0','0','0','0','0','2500.0','12:38 PM','27 May 2021','27 May 2021','202105271238','20210527','','2500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(21,'abcd','9986655589','rice','20','50','1000.0','','1000.0','0','0','0','0','1000.0','01:30 PM','06 Jun 2021','06 Jun 2021','202106061330','20210606','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(22,'xyz','9986688859','oil','20','60','1200.0','','1200.0','0','0','0','0','1200.0','12:59 PM','18 Jun 2021','18 Jun 2021','202106181259','20210618','','1200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(23,'xyz','9986688859','rice','50','70','3500.0','','3500.0','0','0','0','0','3500.0','01:05 PM','19 Jul 2021','19 Jul 2021','202107191305','20210719','','3500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(24,'abcd','9986655589','rice','50','70','3500.0','','3500.0','0','0','0','0','3500.0','03:56 PM','19 Jul 2021','19 Jul 2021','202107191556','20210719','','3500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(25,'xyz','9986688859','rice','50','70','3500.0','','3500.0','0','0','0','0','3500.0','01:40 PM','20 Jul 2021','20 Jul 2021','202107201340','20210720','','3500.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(26,'abc','6698866698','rice','20','50','1000.0','','1000.0','0','0','0','0','1000.0','12:53 PM','12 Aug 2021','12 Aug 2021','202108121253','20210812','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(27,'abc','6698866698','rice','20','50','1000.0','','1000.0','0','0','0','0','1000.0','08:37 PM','13 Aug 2021','13 Aug 2021','202108132037','20210813','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(28,'abc','6698866698','rice','20','50','1000.0','','1000.0','0','0','0','0','1000.0','01:26 PM','23 Jan 2022','23 Jan 2022','202201231326','20220123','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(29,'abc','6698866698','rice','20','50','1000.0','','1000.0','0','0','0','0','1000.0','11:21 AM','26 Jan 2022','26 Jan 2022','202201261121','20220126','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(30,'abc','6698866698','rice','28','50','1400.0','','1400.0','0','0','0','0','1400.0','12:45 PM','31 Jan 2022','31 Jan 2022','202201311245','20220131','','1400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(31,'abc','6698866698','sugar','10','20','200.0','','200.0','0','0','0','0','200.0','11:53 AM','16 Mar 2022','16 Mar 2022','202203161153','20220316','','200.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(32,'abc','6698866698','sugar','20','20','400.0','','400.0','0','0','0','0','400.0','11:37 AM','21 Mar 2022','21 Mar 2022','202203211137','20220321','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(33,'vinayak kirana wala','9986688808','sugar','20','20','400.0','','400.0','0','0','0','0','400.0','01:14 PM','25 Apr 2022','25 Apr 2022','202204251314','20220425','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(34,'vinayak kirana wala','9986688808','sugar','20','20','400.0','','400.0','0','0','0','0','400.0','10:54 AM','26 Apr 2022','26 Apr 2022','202204261054','20220426','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(35,'vinayak kirana wala','9986688808','sugar','20','20','400.0','','400.0','0','0','0','0','400.0','12:57 PM','27 Apr 2022','27 Apr 2022','202204271257','20220427','','400.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg'),(36,'vinayak kirana wala','9986688808','salt','5','10','50.0','','50.0','0','0','0','0','50.0','11:40 AM','16 May 2022','16 May 2022','202205161140','20220516','','50.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','Kg');
INSERT INTO `ingredients` (`_id`, `ingredient_name`, `min_req`, `max_req`, `current_stock`, `unit`, `indiv_price`, `total_price`, `date`, `date1`, `time`, `time1`, `datetimee_new`, `avg_price`, `required`, `barcode`, `status_low`, `status_qty_updated`, `add_qty`, `indiv_price_copy`, `adjusted_stock`, `diff_stock`, `indiv_price_temp`, `total_price_temp`) VALUES (8,'mutton biryanni','0','0','0','Kg','200',NULL,'202106071459','07 Jun 2021','1459','02:59:27 PM','202106071459','NaN','0.0','','Low',NULL,NULL,NULL,NULL,NULL,'200',NULL),(9,'rice','5','30','115.10','Kg','50',NULL,'202108121251','12 Aug 2021','1251','12:51:24 PM','202201261126','59.0','-85.6','','','','0',NULL,'','','50',''),(10,'mansion house','10','50','25','no.','400',NULL,'202110311358','31 Oct 2021','1358','01:58:58 PM','202110311358','NaN','25.0','','',NULL,NULL,NULL,NULL,NULL,'400',NULL),(11,'salt','5','100','13.0','Kg','10',NULL,'202201261129','26 Jan 2022','1129','11:29:35 AM','202201261129','10.0','87.0','','','','0',NULL,'','','10',''),(12,'sugar','5','50','96.60','Kg','20',NULL,'202202051259','05 Feb 2022','1259','12:59:13 PM','202202051259','25.5','-47.1','','','','0',NULL,'','','20',''),(13,'wheat','5','50','10','Kg','0',NULL,'202204271313','27 Apr 2022','1313','01:13:37 PM','202204271314','NaN','40.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'coffee','0.1','Kg','yes');
INSERT INTO `ingredients_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `unit`, `wastage_qty`, `wastage_cost`, `not_required`) VALUES (10,'rice','50.0','50.0','50.0','5.0','250.0','','Kg','0.0','0',''),(11,'sugar','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(12,'rice','50.0','50.0','50.0','50.0','2500.0','','Kg','0.0','0',''),(13,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(14,'oil','60.0','60.0','60.0','20.0','1200.0','','Kg','0.0','0',''),(15,'rice','70.0','70.0','70.0','50.0','3500.0','','Kg','0.0','0',''),(16,'rice','70.0','70.0','70.0','100.0','7000.0','','Kg','0.0','0',''),(17,'rice','70.0','70.0','70.0','50.0','3500.0','','Kg','0.0','0',''),(18,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(19,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(20,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(21,'rice','50.0','50.0','50.0','28.0','1400.0','','Kg','0.0','0',''),(24,'sugar','20.0','20.0','20.0','20.0','400.0','','Kg','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_kot1` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,'192.168.1.91','9100','',NULL,'kot4');
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,-52,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ID','',NULL,NULL,102,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35,20,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,30,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30,40,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,10,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30,26,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,24,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35,16,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,33,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40,-8,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,58,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30,-68,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,86,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35,-45,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,74,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35,-4,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,34,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30,22,'Tiffin','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,8,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20,72,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,24,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20,20,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,27,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20,16,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,32,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,'50','Add',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60,6,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,13,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80,17,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35,26,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60,27,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40,25,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35,30,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',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),(20,'chicken nuggets',65,10,'Snacks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',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),(21,'veg biriyani',70,37,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,13,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100,41,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,8,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50,47,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80,48,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120,47,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,3,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15,100,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','',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),(27,'rice',30,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','',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),(28,'paneer butter masala',60,49,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,1,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80,48,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30,50,'Main course','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','',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),(31,'coffee',20,59,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,41,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20,48,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25,50,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10,49,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SO','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15,28,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25,23,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25,23,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',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),(39,'butterscotch icecream',40,49,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35,49,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'packing charge',5,-3,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,3,'0','0','0','',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),(42,'Plain maggie',30,-1,'Maggie','None','','0','0',NULL,NULL,NULL,'no','%','0','PL','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'Plain cheez maggie',40,-1,'Maggie','None','','0','0',NULL,NULL,NULL,'no','%','0','PL','',NULL,NULL,1,'0','0','0','',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),(44,'veg burger',40,-1,'Burger','None','','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,1,'0','0','0','',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),(45,'veg cheeze burger',50,-1,'Burger','None','','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,1,'0','0','0','',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),(46,'shev paav ',30,-1,'Shev paaw','None','','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,1,'0','0','0','',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),(47,'plain sandwich',30,-2,'Sandwich','None','','0','0',NULL,NULL,NULL,'no','%','0','PL','',NULL,NULL,2,'0','0','0','',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),(48,'ALOO PURI',40,-1,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','AL','',NULL,NULL,1,'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),(49,'open item',50,-1,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','OP','',NULL,NULL,1,'0','0','0','Low',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),(50,'shampoo Pantene 550ml',400,-2,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,2,'0','0','0','Low',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),(51,'frooti t 125ml',10,-18,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','FR','',NULL,NULL,18,'0','0','0','Low',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);
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'Adults','None',NULL,NULL),(2,'podi',0,50,'Adults','None',NULL,NULL),(3,'cheese',15,35,'Adults','None',NULL,NULL),(4,'butter',10,40,'Adults','None',NULL,NULL),(5,'omlette',10,50,'Adults','None',NULL,NULL),(6,'cheese dip',20,50,'Kids','None',NULL,NULL),(7,'potato fry',25,50,'Kids','None',NULL,NULL),(8,'chicken fry',40,45,'Kids','None',NULL,NULL),(9,'soda',6,50,'Kids','None',NULL,NULL),(10,'dessert',15,35,'Kids','None',NULL,NULL),(11,'medium',5,50,'Drinks','None',NULL,NULL),(12,'large',10,50,'Drinks','None',NULL,NULL),(13,'cream',20,50,'Desserts','None',NULL,NULL),(14,'chocolate',20,50,'Desserts','None',NULL,NULL),(15,'EXT PLANE RICE',90,0,'SANWICH','','',NULL);
INSERT INTO `name_dept1` (`_id`, `dept1_name`) VALUES (1,'kot1');
INSERT INTO `name_dept2` (`_id`, `dept2_name`) VALUES (1,'kot2');
INSERT INTO `name_dept3` (`_id`, `dept3_name`) VALUES (1,'kot3');
INSERT INTO `name_dept4` (`_id`, `dept4_name`) VALUES (1,'kot4');
INSERT INTO `ordertaking_server_ip` (`_id`, `ipname`, `port`, `status`) VALUES (1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,'Not_Registered','','','','','');
INSERT INTO `printer_text_size` (`_id`, `type`) VALUES (1,'Standard');
INSERT INTO `printer_type` (`_id`, `printer_type`) VALUES (1,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (2,'2 inch'),(4,'2 inch'),(5,'2 inch'),(6,'2 inch'),(8,'2 inch'),(9,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'0');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
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');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Lite');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'gst(18%)',18.00,'Itemtax',NULL,'dine_in','takeaway','homedelivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
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');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'abc','9986688896','','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (2,'xyz','9986688859','','',''),(3,'abc','6698866698','','',''),(4,'vinayak kirana wala','9986688808','','','');
INSERT INTO `vendor_sold_details` (`_id`, `vendor_name`, `vendor_phoneno`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `total_pay`, `pay_date`, `pay_time`, `pay_datetimeemew`, `not_required`) VALUES (51,'abc','9986688896','','2000.0','0','0','0','0','2000.0','03:10 PM','16 Apr 2021','16 Apr 2021','202104161510','20210416','0','2000.0','0','16 Apr 2021','03:10 PM','202104161510',''),(52,'sanjay','9986655589','','2000.0','0','0','0','0','2000.0','03:06 PM','17 Apr 2021','17 Apr 2021','202104171506','20210417','0','2000.0','0','17 Apr 2021','03:06 PM','202104171506',''),(53,'sanjay','9986655589','','1000.0','0','0','0','0','1000.0','01:10 PM','21 Apr 2021','21 Apr 2021','202104211310','20210421','0','1000.0','0','21 Apr 2021','01:10 PM','202104211310',''),(54,'sanjay','9986655589','','2000.0','0','0','0','0','2000.0','12:10 PM','22 Apr 2021','22 Apr 2021','202104221210','20210422','0','2000.0','0','22 Apr 2021','12:10 PM','202104221210',''),(55,'sanjay','9986655589','','2000.0','0','0','0','0','2000.0','08:47 PM','28 Apr 2021','28 Apr 2021','202104282047','20210428','0','2000.0','0','28 Apr 2021','08:47 PM','202104282047',''),(56,'sanjay','9986655589','','2000.0','0','0','0','0','2000.0','01:10 PM','29 Apr 2021','29 Apr 2021','202104291310','20210429','0','2000.0','0','29 Apr 2021','01:10 PM','202104291310',''),(57,'abc','9986688896','','2000.0','0','0','0','0','2000.0','03:00 PM','07 Jun 2021','07 Jun 2021','202106071500','20210607','0','2000.0','0','07 Jun 2021','03:00 PM','202106071500',''),(58,'abc','9986688896','','1000.0','0','0','0','0','1000.0','01:06 PM','20 Dec 2021','20 Dec 2021','202112201306','20211220','0','1000.0','0','20 Dec 2021','01:06 PM','202112201306','');
INSERT INTO `vendor_sold_item_details` (`_id`, `vendor_name`, `vendor_phoneno`, `itemname`, `qty_add`, `individual_price`, `total_price`, `invoice`, `billamount`, `tax_percent`, `tax_amount`, `disc_percent`, `disc_amount`, `total_bill_amount`, `from_time`, `from_date`, `due_date`, `datetimee_new_from`, `datetimee_new_due`, `pay`, `pending`, `tax1`, `tax2`, `tax3`, `tax4`, `tax5`, `tax6`, `tax7`, `tax8`, `tax9`, `tax10`, `tax11`, `tax12`, `tax13`, `tax14`, `tax15`, `tax1_value`, `tax2_value`, `tax3_value`, `tax4_value`, `tax5_value`, `tax6_value`, `tax7_value`, `tax8_value`, `tax9_value`, `tax10_value`, `tax11_value`, `tax12_value`, `tax13_value`, `tax14_value`, `tax15_value`) VALUES (42,'abc','9986688896','kfa beer','20','100','2000.0','','2000.0','0','0','0','0','2000.0','03:10 PM','16 Apr 2021','16 Apr 2021','202104161510','20210416','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'sanjay','9986655589','kfa beer','20','100','2000.0','','2000.0','0','0','0','0','2000.0','03:06 PM','17 Apr 2021','17 Apr 2021','202104171506','20210417','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'sanjay','9986655589','kfa beer','10','100','1000.0','','1000.0','0','0','0','0','1000.0','01:10 PM','21 Apr 2021','21 Apr 2021','202104211310','20210421','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'sanjay','9986655589','kfa beer','20','100','2000.0','','2000.0','0','0','0','0','2000.0','12:10 PM','22 Apr 2021','22 Apr 2021','202104221210','20210422','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'sanjay','9986655589','kaju barfi 1 pc','100','20','2000.0','','2000.0','0','0','0','0','2000.0','08:47 PM','28 Apr 2021','28 Apr 2021','202104282047','20210428','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'sanjay','9986655589','kaju barfi','40','50','2000.0','','2000.0','0','0','0','0','2000.0','01:10 PM','29 Apr 2021','29 Apr 2021','202104291310','20210429','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'abc','9986688896','MUTTON DUM BIRYANI','10','200','2000.0','','2000.0','0','0','0','0','2000.0','03:00 PM','07 Jun 2021','07 Jun 2021','202106071500','20210607','','2000.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'abc','9986688896','butterscotch icecream','50','20','1000.0','','1000.0','0','0','0','0','1000.0','01:06 PM','20 Dec 2021','20 Dec 2021','202112201306','20211220','','1000.0',NULL,NULL,NULL,NULL,NULL,NULL,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 `vendor_temp_list` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (54,'abc','9986688896','','','','20760.0','2900.0','17860.0','34'),(55,'sanjay','9986655589','','','','2400.0','700.0','1700.0','6'),(56,'abc','9986688896','','','','22760.0','2900.0','19860.0','35'),(57,'sanjay','9986655589','','','','2400.0','700.0','1700.0','6'),(58,'abc','9986688896','','','','22760.0','2900.0','19860.0','35'),(59,'sanjay','9986655589','','','','4400.0','700.0','3700.0','7'),(60,'abc','9986688896','','','','5000.0','0.0','5000.0','3');
INSERT INTO `vendor_temp_list_ingredient` (`_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (36,'abcd','9986655589','','','','21700.0','5000.0','16700.0','17'),(37,'abcd','9986655589','','','','21700.0','5000.0','16700.0','17'),(38,'abcd','9986655589','','','','21700.0','5000.0','16700.0','17'),(40,'abcd','9986655589','','','','21700.0','5000.0','16700.0','17'),(41,'abcd','9986655589','','','','21700.0','5000.0','16700.0','17'),(42,'abcd','9986655589','','','','21950.0','5000.0','16950.0','18'),(43,'abcd','9986655589','','','','21950.0','5000.0','16950.0','18'),(44,'abcd','9986655589','','','','22950.0','5000.0','17950.0','19'),(45,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(46,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(48,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(49,'xyz','9986688859','','','','0.0','0.0','0.0','0'),(50,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(51,'xyz','9986688859','','','','0.0','0.0','0.0','0'),(52,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(53,'xyz','9986688859','','','','0.0','0.0','0.0','0'),(54,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(55,'xyz','9986688859','','','','1200.0','0.0','1200.0','1'),(58,'abcd','9986655589','','','','26450.0','5000.0','21450.0','21'),(59,'xyz','9986688859','','','','1200.0','0.0','1200.0','1'),(60,'abcd','9986655589','','','','29950.0','5000.0','24950.0','22'),(61,'xyz','9986688859','','','','4700.0','0.0','4700.0','2'),(62,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(65,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(66,'abc','6698866698','','','','0.0','0.0','0.0','0'),(67,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(68,'abc','6698866698','','','','2000.0','500.0','1500.0','2'),(69,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(70,'abc','6698866698','','','','4000.0','1000.0','3000.0','4'),(73,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(74,'abc','6698866698','','','','5400.0','1000.0','4400.0','5'),(80,'xyz','9986688859','','','','8200.0','0.0','8200.0','3'),(81,'abc','6698866698','','','','6000.0','1000.0','5000.0','7'),(82,'vinayak kirana wala','9986688808','','','','1250.0','400.0','850.0','4');
INSERT INTO `version_control` (`_id`, `version`) VALUES (1,'12');
INSERT INTO `weighing_scale_status` (`_id`, `Weighing_Scale_onoff`) VALUES (1,'Not Connected');
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:00','23:59');
