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,'On');
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),(11,'','1',NULL,'1st floor','1','4','2'),(12,'','2',NULL,'1st floor','1','4','3'),(13,'','3',NULL,'1st floor','1','4',NULL),(14,'','4',NULL,'1st floor','1','4',NULL),(15,'','5',NULL,'1st floor','1','4',NULL),(16,'','1',NULL,'Theatre','2','4','7'),(17,'','2',NULL,'Theatre','2','4',NULL),(18,'','3',NULL,'Theatre','2','4',NULL),(19,'','4',NULL,'Theatre','2','4',NULL),(20,'','5',NULL,'Theatre','2','4',NULL),(21,'','1',NULL,'takeaway','3','4','1'),(22,'','2',NULL,'takeaway','3','4','4'),(23,'','3',NULL,'takeaway','3','4',NULL),(24,'','4',NULL,'takeaway','3','4',NULL),(25,'','5',NULL,'takeaway','3','4',NULL),(26,'','6',NULL,'takeaway','3','4',NULL),(27,'','7',NULL,'takeaway','3','4',NULL),(28,'','8',NULL,'takeaway','3','4',NULL),(29,'','9',NULL,'takeaway','3','4',NULL),(30,'','10',NULL,'takeaway','3','4',NULL),(34,NULL,'1',NULL,'first','0','4','2'),(35,NULL,'2',NULL,'first','0','4','3'),(36,NULL,'3',NULL,'first','0','4','4'),(37,NULL,'4',NULL,'first','0','4',NULL),(38,NULL,'5',NULL,'first','0','4',NULL),(42,NULL,'1',NULL,'Test','0','5',NULL),(43,NULL,'2',NULL,'Test','0','5',NULL),(44,NULL,'3',NULL,'Test','0','5',NULL),(45,NULL,'4',NULL,'Test','0','5',NULL),(46,NULL,'5',NULL,'Test','0','5',NULL),(47,NULL,'6',NULL,'Test','0','5',NULL),(48,NULL,'7',NULL,'Test','0','5',NULL),(49,NULL,'8',NULL,'Test','0','5',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'No');
INSERT INTO `auto_generate_barcode` (`_id`, `generate`) VALUES (1,'On');
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,'','\nDeviceName: /dev/bus/usb/003/002\nDeviceClass: 0 - Unknown USB class!\n\nDeviceName: /dev/bus/usb/005/002\nDeviceClass: 0 - Unknown USB class!\n','','usb');
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');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (1,'Intuition',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',NULL,'',NULL,'','','www.intuitionsoftwares.com','','');
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,'inagural','20','%'),(2,'opening offer','100','₹'),(3,'d10','10','%');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'first','0'),(2,'1st floor','1'),(3,'Theatre','2'),(4,'takeaway','3'),(5,'Test','4');
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,'Eggless cakes',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,'Urad dal','Idly','0.25','74.91','15 Sept 2023','202309151658','04:58:16 pm','1658','202309151658','Kg','1980.0'),(2,'Urad dal','dosa','0.20','74.91','15 Sept 2023','202309151658','04:58:16 pm','1658','202309151658','Kg','1980.0'),(3,'Urad dal','1idly 1dosa','0.50','74.91','15 Sept 2023','202309151658','04:58:16 pm','1658','202309151658','Kg','1980.0'),(4,'rice','1idly 1dosa','0.25','17.36','20 Sept 2023','202309201045','10:45:47 am','1045','202309201045','Kg','-15.0'),(5,'rice','Idly','0.100','17.36','20 Sept 2023','202309201045','10:45:47 am','1045','202309201045','Kg','-15.0'),(6,'rice','dosa','0','17.36','20 Sept 2023','202309201045','10:45:47 am','1045','202309201045','Kg','-15.0'),(7,'Urad dal','idly','0.150','74.91','01 Dec 2023','2023 12 01','11:15:29 am','1115','202312011115','Kg',NULL),(8,'rice','idly','0.150','17.36','01 Dec 2023','2023 12 01','11:15:29 am','1115','202312011115','Kg',NULL),(9,'coffee powder','coffee','0.0025','10.00','16 Dec 2023','202312162107','09:07:49 pm','2107','202401131357','L','5.0'),(10,'milk','coffee','0.200','4.20','13 Jan 2024','2024 01 13','01:57:45 pm','1357','202402131109','L','5.4'),(11,'Chicken','chicken kabab','0.200','20.40','12 Jun 2024','202406121001','10:01:17 AM','1001','202406121001','Kg ','80.0'),(12,'Chicken','sheekh kabab','0','20.40','12 Jun 2024','202406121001','10:01:17 AM','1001','202406121001','Kg ','80.0'),(13,'Chicken','chicken biriyani','0.100','20.40','12 Jun 2024','202406121001','10:01:17 AM','1001','202406121001','Kg ','80.0'),(14,'Chicken','chicken nuggets','0','20.40','12 Jun 2024','202406121001','10:01:17 AM','1001','202406121001','Kg ','80.0'),(15,'Chicken','chicken sukka','0','20.40','12 Jun 2024','202406121001','10:01:17 AM','1001','202406121001','Kg ','80.0'),(16,'rice','chicken biriyani','0.200','17.36','17 Jan 2024','2024 01 17','10:38:14 am','1038','202401171038','Kg',NULL),(17,'milk','tea','0.200','4.20','13 Feb 2024','202402131109','11:09:48 am','1109','202402131110','Kg','5.4'),(18,'milk','masala chai','0.200','4.20','13 Feb 2024','202402131109','11:09:48 am','1109','202402131110','Kg','5.4'),(19,'tea powder','tea','0.020','10','21 Mar 2024','202403211918','07:18:33 pm','1918','202403211918','Kg','90.0'),(20,'lemon','lime juice','1','59.0','01 Apr 2024','202404011309','01:09:00 pm','1309','202404011310','no.','50.0'),(21,'sugar','lime juice','0.0020','10.00','01 Apr 2024','2024 04 01','01:10:07 pm','1310','202404011310','Kg',NULL),(22,'milk','Irani Tea','0.100','4.00','03 May 2024','2024 05 03','10:31:33 am','1031','202405031031','L',NULL),(23,'tea powder','Irani Tea','0.010','9.98','03 May 2024','2024 05 03','10:31:33 am','1031','202405031031','Kg',NULL),(24,'sugar','Irani Tea','0.010','9.98','03 May 2024','2024 05 03','10:31:33 am','1031','202405031031','Kg',NULL),(25,'sugar','Irani Malai Tea','0.010','9.95','08 May 2024','202405081244','12:44:13 pm','1244','202405081244','Kg','10.0'),(26,'sugar','Milk','0','9.95','08 May 2024','202405081244','12:44:13 pm','1244','202405081244','Kg','10.0'),(27,'sugar','Milk Malai','0','9.95','08 May 2024','202405081244','12:44:13 pm','1244','202405081244','Kg','10.0'),(28,'coffee powder','Coffee','0.010','9.97','26 Jun 2024','202406261648','04:48:14 pm','1648','202406261648','Kg','990.0'),(29,'coffee powder','Cold Coffee/Milkshake','0.020','9.97','26 Jun 2024','202406261648','04:48:14 pm','1648','202406261648','Kg','990.0'),(30,'Milk','Tea','0.100','50','28 Jun 2024','202406281140','11:40:41 am','1140','202406281140','L','950.0'),(31,'Milk','Coffee','0.100','50','28 Jun 2024','202406281140','11:40:41 am','1140','202406281140','L','950.0'),(32,'Milk','Cold Coffee/Milkshake','0.300','50','28 Jun 2024','202406281140','11:40:41 am','1140','202406281140','L','950.0'),(33,'Maida','MysorePak','500','50','31 Jul 2024','202407311652','04:52:57 pm','1652','202407311652','Kg','450.0'),(34,'Maida','Jalebi','0.20','50','31 Jul 2024','202407311652','04:52:57 pm','1652','202407311652','Kg','450.0'),(35,'Maida','Gulab Jamun','0.50','50','31 Jul 2024','202407311652','04:52:57 pm','1652','202407311652','Kg','450.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 (1,'Phani','9739981733','3457','1000','0','0','0','0','1000','06:16 AM','27 Nov 2023','27 Nov 2023','202311270616','20231127','1000','0.0','1000','27 Nov 2023','06:16 AM','202311270616',NULL),(2,'Phani','9739981733','78906','5000.0','0','0','0','0','5000.0','01:54 pm','13 Jan 2024','13 Jan 2024','202401131354','20240113','4000','1000.0','4000','13 Jan 2024','01:54 pm','202401131354',''),(3,'Phani','9739981733','78906','5000.0','0','0','0','0','5000.0','01:54 pm','13 Jan 2024','13 Jan 2024','202401131354','20240113','1000','0.0','5000.0','13 Jan 2024','01:55 pm','202401131355',''),(4,'Phani','9739981733','456','100.0','0','0','0','0','100.0','08:27 pm','20 Jan 2024','20 Jan 2024','202401202027','20240120','80','20.0','80','20 Jan 2024','08:27 pm','202401202027',''),(5,'Phani','9739981733','7886','50.0','0','0','0','0','50.0','01:11 pm','01 Apr 2024','01 Apr 2024','202404011311','20240401','50','0.0','50','01 Apr 2024','01:11 pm','202404011311',''),(6,'Phani','9739981733','','1000.0','0','0','0','0','1000.0','11:36 am','04 Jun 2024','04 Jun 2024','202406041136','20240604','0','1000.0','0','04 Jun 2024','11:36 am','202406041136',''),(7,'Phani','9739981733','43829','100','0','0','0','0','100','10:03 AM','12 Jun 2024','12 Jun 2024','202406121003','20240612','100','0.0','100','12 Jun 2024','10:03 AM','202406121003',NULL),(8,'Phani','9739981733','5382','10','0','0','0','0','10','04:56 AM','05 Sep 2024','05 Sep 2024','202409050456','20240905','10','0.0','10','05 Sep 2024','04:56 AM','202409050456',NULL);
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 (1,'Phani','9739981733','rice','20','50','1000','3457','1000','0','0','0','0','1000','06:16 AM','27 Nov 2023','27 Nov 2023','202311270616','20231127','1000','0.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,NULL,'null'),(2,'Phani','9739981733','Urad dal','50','100','5000.0','78906','5000.0','0','0','0','0','5000.0','01:54 pm','13 Jan 2024','13 Jan 2024','202401131354','20240113','4000','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'),(3,'Phani','9739981733','Chicken','10','10','100.0','456','100.0','0','0','0','0','100.0','08:27 pm','20 Jan 2024','20 Jan 2024','202401202027','20240120','80','20.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'),(4,'Phani','9739981733','Chicken','0','10','0.0','7886','50.0','0','0','0','0','50.0','01:11 pm','01 Apr 2024','01 Apr 2024','202404011311','20240401','50','0.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'),(5,'Phani','9739981733','lemon','10','5','50.0','7886','50.0','0','0','0','0','50.0','01:11 pm','01 Apr 2024','01 Apr 2024','202404011311','20240401','50','0.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','no.'),(6,'Phani','9739981733','Urad dal','10','100','1000.0','','1000.0','0','0','0','0','1000.0','11:36 am','04 Jun 2024','04 Jun 2024','202406041136','20240604','','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'),(7,'Phani','9739981733','Chicken','10','10','100','43829','100','0','0','0','0','100','10:03 AM','12 Jun 2024','12 Jun 2024','202406121003','20240612','100','0.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,NULL,'Kg '),(8,'Phani','9739981733','Chicken','1','10','10','5382','10','0','0','0','0','10','04:56 AM','05 Sep 2024','05 Sep 2024','202409050456','20240905','10','0.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,NULL,'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 (1,'Urad dal','5','2000','74.91','Kg','100',NULL,'202309151658','15 Sept 2023','1658','04:58:20 pm','202309151658','100.0','1930.6','','','','0',NULL,'','','100',''),(2,'rice','5','0','17.36','Kg','50',NULL,'202309201045','20 Sept 2023','1045','10:45:49 am','202309201045','50.0','-15.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(3,'sugar','5','20','10.00','Kg','0',NULL,'202312162105','16 Dec 2023','2105','09:05:51 pm','202405081244','NaN','10.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(4,'coffee powder','5','15','10.00','Kg','0',NULL,'202312162106','16 Dec 2023','2106','09:06:14 pm','202312162106','NaN','5.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'milk','1','10','4.20','L','0',NULL,'202312162106','16 Dec 2023','2106','09:06:27 pm','202406041135','NaN','5.8','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(6,'Chicken','5','100','20.40','Kg ','10',NULL,'202406121001','12 Jun 2024','1001','10:01:17 AM','202406121001','10','80.0','0','','','0',NULL,'','','10',''),(7,'tea powder','5','100','10','Kg','0',NULL,'202403211918','21 Mar 2024','1918','07:18:35 pm','202403211918','NaN','90.0','','',NULL,NULL,NULL,NULL,NULL,'0',NULL),(8,'lemon','5','100','59.0','no.','5',NULL,'202404011309','01 Apr 2024','1309','01:09:02 pm','202404011309','5.0','41.0','','','','0',NULL,'','','5',''),(9,'coffee powder','5','1000','10','Kg','0',NULL,'202406261648','26 Jun 2024','1648','04:48:15 pm','202406261648','0','990.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(10,'Milk','5','1000','50','L','25',NULL,'202406281140','28 Jun 2024','1140','11:40:42 am','202406281140','25','950.0','',NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL),(11,'Maida','1','500','50','Kg','20',NULL,'202407311653','31 Jul 2024','1653','04:53:01 pm','202407311653','20','450.0','',NULL,NULL,NULL,NULL,NULL,NULL,'20',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'chicken kabab','0','Kg','yes'),(2,'sheekh kabab','0','Kg','yes'),(3,'chicken biriyani','0.100','Kg','yes'),(4,'chicken nuggets','0','Kg','yes'),(5,'chicken sukka','0','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 (1,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(2,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(3,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(4,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(5,'rice','50.0','50.0','50.0','20.0','1000.0','','Kg','0.0','0',''),(6,'Urad dal','100.0','100.0','100.0','50.0','5000.0','','Kg','0.0','0',''),(7,'Chicken','10.0','10.0','10.0','10.0','100.0','','Kg','0.0','0',''),(8,'Chicken','NaN','10.0','10.0','0.0','0.0','','Kg','0.0','0',''),(9,'lemon','5.0','5.0','5.0','10.0','50.0','','no.','0.0','0',''),(10,'Urad dal','100.0','100.0','100.0','50.0','5000.0','','Kg','0.0','0',''),(11,'Chicken','10.0','10.0','10.0','10.0','100.0','','Kg','0.0','0',''),(12,'lemon','5.0','5.0','5.0','10.0','50.0','','no.','0.0','0',''),(13,'Urad dal','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(14,'Chicken','10.0','10.0','10.0','10.0','100.0','0','Kg ','0.0','0',''),(15,'Urad dal','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(16,'Chicken','10.0','10.0','10.0','10.0','100.0','0','Kg ','0.0','0',''),(17,'Urad dal','100.0','100.0','100.0','10.0','1000.0','','Kg','0.0','0',''),(18,'Chicken','10.0','10.0','10.0','10.0','100.0','0','Kg ','0.0','0',''),(19,'Urad dal','100.0','100.0','100.0','60.0','6000.0','','Kg','0.0','0',''),(20,'Chicken','10.0','10.0','10.0','20.0','200.0','0','Kg ','0.0','0',''),(21,'lemon','5.0','5.0','5.0','10.0','50.0','','no.','0.0','0',''),(22,'Chicken','10.0','10.0','10.0','1.0','10.0','0','Kg ','0.0','0','');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.68.125','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','',NULL);
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`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'idly',25.00,32,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ID','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,29,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,45,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,45,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,40,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,36,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,13,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,28,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,28,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,29,'Tiffin','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,99,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,49,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,49,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,19,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,19,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,29,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,29,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,29,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,29,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,9,'Snacks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,49,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,48,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,48,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,49,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120.00,50,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,100,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,50,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','RI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,50,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,50,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','DH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'coffee',20.00,100,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20.00,50,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,50,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','SO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,30,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','cgst(2.5%)','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.5','sgst(2.5%)','2.5','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'Blueberry eggless 500gm',400.00,0,'Eggless cakes','None','','0','0',NULL,NULL,NULL,'no','%','0','BL','41',NULL,NULL,0,'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 `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'idly','20.0','20.0','20.0','50.0','1000.0','',''),(2,'dosa','40.0','40.0','40.0','20.0','800.0','',''),(3,'dosa','40.0','40.0','40.0','20.0','800.0','348','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','5');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'yes');
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,'Tiffin','None',NULL,NULL),(2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,'soda',6,50,'Main course','None',NULL,NULL),(10,'dessert',15,35,'Main course','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);
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,'POS');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (14,'');
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,'Pro');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'cgst(2.5%)',2.50,'Itemtax','','dine_in','takeaway','homedelivery',''),(2,'sgst(2.5%)',2.50,'Itemtax','','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,'sri','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,'rohith','9581497872','krrohith934@gmail.com','Bangalore ','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Phani','9739981733','','','');
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 (1,'rohith','9581497872','','1800.0','0','0','0','0','1800.0','06:04 PM','09 Mar 2023','09 Mar 2023','202303091804','20230309','0','1800.0','0','09 Mar 2023','06:04 PM','202303091804',''),(2,'rohith','9581497872','','1800.0','0','0','0','0','1800.0','06:04 PM','09 Mar 2023','09 Mar 2023','202303091804','20230309','500','1300.0','500.0','09 Mar 2023','06:05 PM','202303091805',''),(3,'rohith','9581497872','','1800.0','0','0','0','0','1800.0','06:04 PM','09 Mar 2023','09 Mar 2023','202303091804','20230309','1000','300.0','1500.0','01 Sep 2023','05:00 AM','202309010500',NULL),(4,'rohith','9581497872','37894','400.0','0','0','0','0','400.0','03:20 pm','12 Oct 2023','13 Oct 2023','202310121520','20231013','300','100.0','300','12 Oct 2023','03:20 pm','202310121520',''),(5,'rohith','9581497872','1234','120','0','0','0','0','120','10:16 AM','13 Nov 2023','13 Nov 2023','202311131016','20231113','120','0.0','120','13 Nov 2023','10:16 AM','202311131016',NULL),(6,'rohith','9581497872','27370','40.0','0','0','0','0','40.0','12:35 pm','24 Nov 2023','24 Nov 2023','202311241235','20231124','40','0.0','40','24 Nov 2023','12:35 pm','202311241235',''),(7,'rohith','9581497872','55667','100.0','0','0','0','0','100.0','06:58 pm','18 Mar 2024','18 Mar 2024','202403181858','20240318','0','100.0','0','18 Mar 2024','06:58 pm','202403181858',''),(8,'rohith','9581497872','9876','2000.0','0','0','0','0','2000.0','06:51 pm','19 Mar 2024','19 Mar 2024','202403191851','20240319','2000','0.0','2000','19 Mar 2024','06:51 pm','202403191851',''),(9,'rohith','9581497872','9765','2000.0','0','0','0','0','2000.0','12:22 pm','29 Apr 2024','29 Apr 2024','202404291222','20240429','1000','1000.0','1000','29 Apr 2024','12:22 pm','202404291222',''),(10,'rohith','9581497872','9765','2000.0','0','0','0','0','2000.0','12:22 pm','29 Apr 2024','29 Apr 2024','202404291222','20240429','1000','0.0','2000.0','29 Apr 2024','12:24 pm','202404291224',''),(11,'rohith','9581497872','76538','3000.0','0','0','0','0','3000.0','04:40 pm','30 Jul 2024','31 Jul 2024','202407301640','20240731','2000','1000.0','2000','30 Jul 2024','04:40 pm','202407301640',''),(12,'rohith','9581497872','76538','3000.0','0','0','0','0','3000.0','04:40 pm','30 Jul 2024','31 Jul 2024','202407301640','20240731','1000','0.0','3000.0','31 Jul 2024','04:42 pm','202407311642',''),(13,'rohith','9581497872','4778','2000.0','0','0','0','0','2000.0','04:45 pm','11 Dec 2024','11 Dec 2024','202412111645','20241211','1000','1000.0','1000','11 Dec 2024','04:45 pm','202412111645',''),(14,'rohith','9581497872','4778','2000.0','0','0','0','0','2000.0','04:45 pm','11 Dec 2024','11 Dec 2024','202412111645','20241211','1000','0.0','2000.0','11 Dec 2024','04:47 pm','202412111647','');
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 (1,'rohith','9581497872','sugar 1kg','50','20','1000.0','','1800.0','0','0','0','0','1800.0','06:04 PM','09 Mar 2023','09 Mar 2023','202303091804','20230309','','1800.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),(2,'rohith','9581497872','dosa','20','40','800.0','','1800.0','0','0','0','0','1800.0','06:04 PM','09 Mar 2023','09 Mar 2023','202303091804','20230309','','1800.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),(3,'rohith','9581497872','Coca cola','50','8','400.0','37894','400.0','0','0','0','0','400.0','03:20 pm','12 Oct 2023','13 Oct 2023','202310121520','20231013','300','100.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),(4,'rohith','9581497872','Coca cola','50','8','400.0','37894','400.0','0','0','0','0','400.0','03:20 pm','12 Oct 2023','13 Oct 2023','202310121520','20231013','300','100.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),(5,'rohith','9581497872','SINGLE IDLY','4','30','120','1234','120','0','0','0','0','120','10:16 AM','13 Nov 2023','13 Nov 2023','202311131016','20231113','120','0.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),(6,'rohith','9581497872','sugar 1kg','2','20','40.0','27370','40.0','0','0','0','0','40.0','12:35 pm','24 Nov 2023','24 Nov 2023','202311241235','20231124','40','0.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),(7,'rohith','9581497872','dosa','5','20','100.0','55667','100.0','0','0','0','0','100.0','06:58 pm','18 Mar 2024','18 Mar 2024','202403181858','20240318','','100.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),(8,'rohith','9581497872','Asian paints','20','100','2000.0','9876','2000.0','0','0','0','0','2000.0','06:51 pm','19 Mar 2024','19 Mar 2024','202403191851','20240319','2000','0.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),(9,'rohith','9581497872','kulfi','40','50','2000.0','9765','2000.0','0','0','0','0','2000.0','12:22 pm','29 Apr 2024','29 Apr 2024','202404291222','20240429','1000','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),(10,'rohith','9581497872','pepsi 750ml','100','30','3000.0','76538','3000.0','0','0','0','0','3000.0','04:40 pm','30 Jul 2024','31 Jul 2024','202407301640','20240731','2000','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),(11,'rohith','9581497872','butterscotch cake','20','100','2000.0','4778','2000.0','0','0','0','0','2000.0','04:45 pm','11 Dec 2024','11 Dec 2024','202412111645','20241211','1000','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 (1,'rohith','9581497872','krrohith934@gmail.com','','Bangalore ','1800.0','0.0','1800.0','1'),(2,'rohith','9581497872','krrohith934@gmail.com','','Bangalore ','6460.0','4960.0','1500.0','7'),(3,'rohith','9581497872','krrohith934@gmail.com','','Bangalore ','9460.0','7960.0','1500.0','8'),(4,'rohith','9581497872','krrohith934@gmail.com','','Bangalore ','11460.0','9960.0','1500.0','9');
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 (1,'Phani','9739981733','','','','1000.0','1000.0','0.0','1'),(2,'Phani','9739981733','','','','6000.0','5000.0','1000.0','2'),(3,'Phani','9739981733','','','','6100.0','6080.0','20.0','3');
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:01','23:59');
