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 floor','1','4',NULL),(2,'','1',NULL,'First floor','1','4',NULL),(3,'','1',NULL,'First floor','1','4',NULL),(4,'','1',NULL,'demo','5','4','5'),(5,'','2',NULL,'demo','5','4','4'),(6,'','3',NULL,'demo','5','4',NULL),(7,'','4',NULL,'demo','5','4',NULL),(8,'','5',NULL,'demo','5','4',NULL),(9,'','6',NULL,'demo','5','4',NULL),(10,'','7',NULL,'demo','5','4',NULL),(11,'','8',NULL,'demo','5','4',NULL),(12,'','9',NULL,'demo','5','4',NULL),(13,'','10',NULL,'demo','5','4',NULL),(14,'','11',NULL,'demo','5','4',NULL),(15,'','12',NULL,'demo','5','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,'MPT-II','66:32:A1:34:0E:58','','bluetooth');
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'),(7,'mosambee','','','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,'Manthi Palace',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'32.....',NULL,'Thank you, visit again.',NULL,'near cochi super market','','','statue road','chulickal, Cochi -682002');
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,'Ten percent ','10','%');
INSERT INTO `email_recipient` (`_id`, `name`, `ph_no`, `email`) VALUES (1,'Reshma ','+919164000','reshmajs1611@gmail.com');
INSERT INTO `email_setup` (`_id`, `username`, `password`, `client`) VALUES (1,'reshmajs1611@gmail.com','','Gmail');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `ezetapmerchantreg` (`_id`, `account`, `userid`, `password`) VALUES (1,'Not_Registered','','');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'test','0'),(2,'test','1'),(3,'test','2'),(4,'test','3'),(5,'test','4'),(6,'demo','5');
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,'Temple',NULL,NULL,NULL,0),(9,'test tax',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 ','idly','0.100','18.80','31 May 2024','202405311137','11:37:11 am','1137','202405311140','Kg','10.0'),(2,'Rice ','dosa','0.100','18.80','31 May 2024','202405311137','11:37:11 am','1137','202405311140','Kg','10.0'),(3,'Rice ','pongal','0.200','18.80','31 May 2024','202405311137','11:37:11 am','1137','202405311140','Kg','10.0'),(4,'Rice ','onion dosa','0.100','18.80','31 May 2024','202405311137','11:37:11 am','1137','202405311140','Kg','10.0'),(5,'Rice ','mutton biriyani','0.200','18.80','31 May 2024','202405311137','11:37:11 am','1137','202405311140','Kg','10.0'),(6,'Milk','Tea ','0','0','03 Jul 2024','202407031541','03:41:44 pm','1541','202407031541','L','10.0'),(7,'oil ','poori','0.2','12.00','10 Jul 2024','202407101449','02:49:56 pm','1449','202407101449','L','10.0'),(8,'oil ','masal vada','0.3','12.00','10 Jul 2024','202407101449','02:49:56 pm','1449','202407101449','L','10.0'),(9,'oil ','samosa','0','12.00','10 Jul 2024','202407101449','02:49:56 pm','1449','202407101449','L','10.0'),(10,'oil ','vada','0','12.00','10 Jul 2024','202407101449','02:49:56 pm','1449','202407101449','L','10.0'),(11,'Ghee','pongal','0.01','0.19','10 Jul 2024','202407101454','02:54:35 pm','1454','202407101454','Kg','50.0'),(12,'Ghee','upma','0.01','0.19','10 Jul 2024','202407101454','02:54:35 pm','1454','202407101454','Kg','50.0'),(13,'Ghee','roti','0.005','0.19','10 Jul 2024','202407101454','02:54:35 pm','1454','202407101454','Kg','50.0'),(14,'Ghee','dhal fry','0','0.19','10 Jul 2024','202407101454','02:54:35 pm','1454','202407101454','Kg','50.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,'Abc enterprise ','1234567890','','550.0','0','0','0','0','550.0','03:43 pm','03 Jul 2024','03 Jul 2024','202407031543','20240703','400','150.0','400','03 Jul 2024','03:43 pm','202407031543','');
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,'Abc enterprise ','1234567890','Milk','10','55','550.0','','550.0','0','0','0','0','550.0','03:43 pm','03 Jul 2024','03 Jul 2024','202407031543','20240703','400','150.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','L');
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,'Rice ','5','20','18.80','Kg','60',NULL,'202405311137','31 May 2024','1137','11:37:14 am','202405311140','60','10.0','','',NULL,NULL,NULL,NULL,NULL,'60',NULL),(2,'Milk','2','10','0','L','55',NULL,'202407031541','03 Jul 2024','1541','03:41:50 pm','202407031541','55','10.0','',NULL,NULL,NULL,NULL,NULL,NULL,'55',NULL),(3,'oil ','5','20','12.00','L','200',NULL,'202407101450','10 Jul 2024','1450','02:50:04 pm','202407101450','200','10.0','',NULL,NULL,NULL,NULL,NULL,NULL,'200',NULL),(4,'Ghee','10','50','0.19','Kg','500',NULL,'202407101454','10 Jul 2024','1454','02:54:38 pm','202407101454','500','50.0','',NULL,NULL,NULL,NULL,NULL,NULL,'500',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (3,'poori','0','L',NULL),(4,'masal vada','0','L',NULL),(5,'samosa','0','L',NULL),(6,'vada','0','L',NULL);
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,'Milk','55.0','55.0','55.0','10.0','550.0','','L','0.0','0',''),(2,'Milk','55.0','55.0','55.0','10.0','550.0','','L','0.0','0',''),(3,'Milk','55.0','55.0','55.0','10.0','550.0','','L','0.0','0',''),(5,'Milk','55.0','55.0','55.0','10.0','550.0','','L','0.0','0',''),(6,'Milk','55.0','55.0','55.0','10.0','550.0','','L','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.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,37,'Tiffin','None','[encoded data, 9224 characters]','0','0',NULL,NULL,NULL,'no','%','0','ID','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'dosa',35.00,42,'Tiffin','None','[encoded data, 7916 characters]','0','0',NULL,NULL,NULL,'no','%','0','DO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'pongal',30.00,44,'Tiffin','None','[encoded data, 8188 characters]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'upma',30.00,48,'Tiffin','None','[encoded data, 9448 characters]','0','0',NULL,NULL,NULL,'no','%','0','UP','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'poori',35.00,45,'Tiffin','None','[encoded data, 9424 characters]','0','0',NULL,NULL,NULL,'no','%','0','PO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'masal dosa',40.00,45,'Tiffin','None','[encoded data, 7296 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'bread omlette',30.00,17,'Tiffin','None','[encoded data, 10588 characters]','0','0',NULL,NULL,NULL,'no','%','0','BR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'onion dosa',35.00,28,'Tiffin','None','[encoded data, 9336 characters]','0','0',NULL,NULL,NULL,'no','%','0','ON','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'rava dosa',35.00,30,'Tiffin','None','[encoded data, 9380 characters]','0','0',NULL,NULL,NULL,'no','%','0','RA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'uthappam',30.00,30,'Tiffin','None','[encoded data, 10148 characters]','0','0',NULL,NULL,NULL,'no','%','0','UT','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'vada',20.00,100,'Snacks','None','[encoded data, 8408 characters]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'masal vada',20.00,50,'Snacks','None','[encoded data, 10604 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'samosa',20.00,50,'Snacks','None','[encoded data, 9216 characters]','0','0',NULL,NULL,NULL,'no','%','0','SA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'chicken kabab',60.00,19,'Snacks','None','[encoded data, 10380 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'sheekh kabab',80.00,19,'Snacks','None','[encoded data, 10608 characters]','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'pani puri',35.00,30,'Snacks','None','[encoded data, 10360 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'pav bhajji',60.00,29,'Snacks','None','[encoded data, 9748 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'veg cutlet',40.00,29,'Snacks','None','[encoded data, 9000 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'masal puri',35.00,29,'Snacks','None','[encoded data, 10156 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'chicken nuggets',65.00,10,'Snacks','None','[encoded data, 7856 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'veg biriyani',70.00,49,'Main course','None','[encoded data, 9144 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'chicken biriyani',100.00,50,'Main course','None','[encoded data, 9168 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'veg thali',50.00,50,'Main course','None','[encoded data, 10480 characters]','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'non veg thali',80.00,50,'Main course','None','[encoded data, 10088 characters]','0','0',NULL,NULL,NULL,'no','%','0','NO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'mutton biriyani',120.00,50,'Main course','None','[encoded data, 9144 characters]','0','0',NULL,NULL,NULL,'no','%','0','MU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'roti',15.00,99,'Main course','None','[encoded data, 9092 characters]','0','0',NULL,NULL,NULL,'no','%','0','RO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'rice',30.00,49,'Main course','None','[encoded data, 8168 characters]','0','0',NULL,NULL,NULL,'no','%','0','RI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'paneer butter masala',60.00,49,'Main course','None','[encoded data, 10232 characters]','0','0',NULL,NULL,NULL,'no','%','0','PA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'chicken sukka',80.00,50,'Main course','None','[encoded data, 9276 characters]','0','0',NULL,NULL,NULL,'no','%','0','CH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'dhal fry',30.00,50,'Main course','None','[encoded data, 9596 characters]','0','0',NULL,NULL,NULL,'no','%','0','DH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'coffee',20.00,100,'Drinks','None','[encoded data, 8280 characters]','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'tea',20.00,50,'Drinks','None','[encoded data, 8828 characters]','0','0',NULL,NULL,NULL,'no','%','0','TE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'masala chai',25.00,50,'Drinks','None','[encoded data, 8488 characters]','0','0',NULL,NULL,NULL,'no','%','0','MA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'soft drinks',10.00,50,'Drinks','None','[encoded data, 6056 characters]','0','0',NULL,NULL,NULL,'no','%','0','SO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'lime juice',15.00,30,'Drinks','None','[encoded data, 5584 characters]','0','0',NULL,NULL,NULL,'no','%','0','LI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','None','[encoded data, 8136 characters]','0','0',NULL,NULL,NULL,'no','%','0','LA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','None','[encoded data, 7764 characters]','0','0',NULL,NULL,NULL,'no','%','0','GR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,49,'Desserts','None','[encoded data, 8528 characters]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,49,'Desserts','None','[encoded data, 9628 characters]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','None','[encoded data, 9084 characters]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','','0','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'include5',105.00,10,'test tax','Five(5%)','','0','0',NULL,NULL,NULL,'no','%','0','IN','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','5.0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yes','yes',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,'excl',100.00,9,'None','None','','0','0',NULL,NULL,NULL,'no','%','0','EX','',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);
INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'idly','10.0','10.0','10.0','2.0','20.0','','');
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `ladmin` (`_id`, `username`, `password`, `name`) VALUES (1,'ladmin','1234','ladmin');
INSERT INTO `login` (`ID`, `USERNAME`, `PASSWORD`, `name`) VALUES (1,'admin','0000','madmin');
INSERT INTO `loginuser` (`_id`, `username`, `password`) VALUES (1,'admin','0000'),(2,'admin','0000'),(3,'admin','0000'),(4,'admin','0000'),(5,'admin','0000'),(6,'admin','0000'),(7,'admin','0000'),(8,'admin','0000'),(9,'admin','0000'),(10,'admin','0000'),(11,'admin','0000'),(12,'admin','0000'),(13,'admin','0000'),(14,'admin','0000'),(15,'admin','0000'),(16,'admin','0000'),(17,'admin','0000'),(18,'admin','0000'),(19,'admin','0000'),(20,'admin','0000'),(21,'admin','0000'),(22,'admin','0000'),(23,'admin','0000'),(24,'admin','0000'),(25,'admin','0000'),(26,'admin','0000'),(27,'admin','0000'),(28,'admin','0000'),(29,'admin','0000'),(30,'admin','0000'),(31,'admin','0000'),(32,'admin','0000'),(33,'admin','0000'),(34,'admin','0000'),(35,'admin','0000'),(36,'admin','0000'),(37,'admin','0000'),(38,'admin','0000'),(39,'admin','0000'),(40,'admin','0000'),(41,'admin','0000'),(42,'admin','0000'),(43,'admin','0000'),(44,'admin','0000'),(45,'admin','0000'),(46,'admin','0000'),(47,'admin','0000'),(48,'admin','0000'),(49,'admin','0000'),(50,'admin','0000'),(51,'admin','0000'),(52,'admin','0000'),(53,'Reshma','0000'),(54,'Reshma','0000'),(55,'Reshma','0000'),(56,'Reshma','0000'),(57,'admin','0000'),(58,'admin','0000'),(59,'admin','0000'),(60,'admin','0000'),(61,'admin','0000'),(62,'admin','0000'),(63,'admin','0000'),(64,'admin','0000'),(65,'admin','0000'),(66,'admin','0000'),(67,'admin','0000'),(68,'admin','0000'),(69,'admin','0000'),(70,'admin','0000'),(71,'admin','0000'),(72,'admin','0000'),(73,'admin','0000'),(74,'admin','0000'),(75,'admin','0000'),(76,'admin','0000'),(77,'admin','0000'),(78,'admin','0000'),(79,'admin','0000'),(80,'admin','0000'),(81,'admin','0000'),(82,'admin','0000'),(83,'admin','0000'),(84,'admin','0000'),(85,'admin','0000'),(86,'admin','0000'),(89,'admin','0000'),(90,'admin','0000'),(91,'admin','0000'),(93,'admin','0000'),(94,'admin','0000'),(95,'admin','0000'),(96,'admin','0000'),(97,'admin','0000'),(98,'admin','0000'),(99,'admin','0000'),(100,'admin','0000'),(101,'admin','0000'),(102,'admin','0000'),(103,'admin','0000'),(104,'admin','0000'),(105,'admin','0000'),(106,'admin','0000'),(107,'admin','0000'),(108,'admin','0000'),(109,'admin','0000'),(110,'admin','0000'),(111,'admin','0000'),(112,'admin','0000'),(113,'admin','0000'),(114,'admin','0000'),(115,'admin','0000'),(116,'admin','0000'),(117,'admin','0000'),(118,'admin','0000'),(119,'admin','0000'),(120,'admin','0000'),(121,'admin','0000'),(122,'admin','0000'),(123,'admin','0000'),(124,'admin','0000'),(125,'admin','0000'),(126,'admin','0000'),(127,'admin','0000'),(128,'admin','0000'),(129,'admin','0000'),(130,'admin','0000'),(131,'admin','0000');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'/9j/4AAQSkZJRgABAQEAlgCWAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCAAwADADASIAAhEBAxEB/8QAHAAAAQQDAQAAAAAAAAAAAAAAAAEEBQYCAwcJ/8QAKBAAAgIBBAEDBAMBAAAAAAAAAQIDBAUABhESEwchMSJBUZEUMlJh/8QAFQEBAQAAAAAAAAAAAAAAAAAAAAH/xAAUEQEAAAAAAAAAAAAAAAAAAAAA/9oADAMBAAIRAxEAPwD1T0axZ1QdnYKPyTxrLQGjRqA3hnLuJoxVMNAs+WyUhrUkZSyo3Us0rqDyUjRWYgcFiFQEFgdBPc86XVG9K69WtBuCOlftXYXyyTizakZ5ZzJRqu0jc8cFmYt1ACrzwAAANXgMpYqGBI+Rz8aCi7nTCZzcN5N2LWl27tjGi7aisqWgaaUSEySL8N4oYmIBBAMxPyqkV/YnqnPj9u7cxm58TYazkcYJMcKczX7VkRKnkWaNUBjlWN43YEt7MQT2HBuWe2jjstQ3Rj8xKRjtx0xVs9Oe6qYjEw/RU/vkcagcDtLA4iK82UymPit3Y4IInxeOGPSusP8AR40+riQkgs3JBCovHVBoNe5PWerjZ6IwWOr5CnkHkjjuyXPDGOlZrEs3XqSYYY1Hlf26syoodyVE4z4rctHbsG8MSYMpkqjTrWV5FMTGEGaMlSG68N1YN9J9gfcgHlmZ9Mq1K9UtNu60tOSS01OrisHNYZKIkV44PIXYBhP1nPYcSyKSysidA4lx226lgvh94b7rXLBMmRtXIchZsyrwwSNWRlCcMfZByo+yqCToroWyrVWpuXdGJ6V6fgs1FFdOECjwCOPov+WjhjIA/wCj7aa7Y2RDR9Udzbwiz9ydrCxV5ahQLGjsquAW5PYqpXgcLwHHPbhSJUeluxZna3dwIuXJApa5dnlsWwVUhSJnYupXluvVh1JJXg++rBicPjsHU/hYyuYoy7SMWdpHkdjyzu7Es7E/LMST+dEPdJxpdGgTjRxpdGgNGjRoP//Z');
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 `mobikwikmerchantreg` (`_id`, `Account`, `Merchant_name`, `Mid_otp`, `Secretkey_otp`, `Mid_debit`, `Secretkey_debit`) VALUES (1,'Not_Registered','','','','','');
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,'Generic');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (19,'');
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,'On');
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,'Five(5%)',5.00,'Itemtax',NULL,'dine_in','takeaway','homedelivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'4');
INSERT INTO `user1` (`_id`, `name`, `username`, `password`) VALUES (1,'User1','user1','1111');
INSERT INTO `user2` (`_id`, `name`, `username`, `password`) VALUES (1,'User2','user2','2222');
INSERT INTO `user3` (`_id`, `name`, `username`, `password`) VALUES (1,'User3','user3','3333');
INSERT INTO `user4` (`_id`, `name`, `username`, `password`) VALUES (1,'User4','user4','4444');
INSERT INTO `user5` (`_id`, `name`, `username`, `password`) VALUES (1,'User5','user5','5555');
INSERT INTO `user6` (`_id`, `name`, `username`, `password`) VALUES (1,'User6','user6','6666');
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 `userlogin_checking` (`_id`, `username`, `password`, `name`) VALUES (1,NULL,NULL,'madmin'),(2,NULL,NULL,'madmin'),(3,NULL,NULL,'madmin'),(4,NULL,NULL,'madmin'),(5,NULL,NULL,'madmin'),(6,NULL,NULL,'madmin'),(7,NULL,NULL,'madmin'),(8,NULL,NULL,'madmin'),(9,NULL,NULL,'madmin'),(10,NULL,NULL,'madmin'),(11,NULL,NULL,'madmin'),(12,NULL,NULL,'madmin'),(13,NULL,NULL,'madmin'),(14,NULL,NULL,'madmin'),(15,NULL,NULL,'madmin'),(16,NULL,NULL,'madmin'),(17,NULL,NULL,'madmin'),(18,NULL,NULL,'madmin'),(19,NULL,NULL,'madmin'),(20,NULL,NULL,'madmin'),(21,NULL,NULL,'madmin'),(22,NULL,NULL,'madmin'),(23,NULL,NULL,'madmin'),(24,NULL,NULL,'madmin'),(25,NULL,NULL,'madmin'),(26,NULL,NULL,'madmin'),(27,NULL,NULL,'madmin'),(28,NULL,NULL,'madmin'),(29,NULL,NULL,'madmin'),(30,NULL,NULL,'madmin'),(31,NULL,NULL,'madmin'),(32,NULL,NULL,'madmin'),(33,NULL,NULL,'madmin'),(34,NULL,NULL,'madmin'),(35,NULL,NULL,'madmin'),(36,NULL,NULL,'madmin'),(37,NULL,NULL,'madmin'),(38,NULL,NULL,'madmin'),(39,NULL,NULL,'madmin'),(40,NULL,NULL,'madmin'),(41,NULL,NULL,'madmin'),(42,NULL,NULL,'madmin'),(43,NULL,NULL,'madmin'),(44,NULL,NULL,'madmin'),(45,NULL,NULL,'madmin'),(46,NULL,NULL,'madmin'),(47,NULL,NULL,'madmin'),(48,NULL,NULL,'madmin'),(49,NULL,NULL,'madmin'),(50,NULL,NULL,'madmin'),(51,NULL,NULL,'madmin'),(52,NULL,NULL,'madmin'),(53,NULL,'0000','madmin'),(54,NULL,NULL,'madmin'),(55,NULL,NULL,'madmin'),(56,NULL,NULL,'madmin'),(57,NULL,NULL,'madmin'),(58,NULL,NULL,'madmin'),(59,NULL,NULL,'madmin'),(60,NULL,NULL,'madmin'),(61,NULL,NULL,'madmin'),(62,NULL,NULL,'madmin'),(63,NULL,NULL,'madmin'),(64,NULL,NULL,'madmin'),(65,NULL,NULL,'madmin'),(66,NULL,NULL,'madmin'),(67,NULL,NULL,'madmin'),(68,NULL,NULL,'madmin'),(69,NULL,NULL,'madmin'),(70,NULL,NULL,'madmin'),(71,NULL,NULL,'madmin'),(72,NULL,NULL,'madmin'),(73,NULL,NULL,'madmin'),(74,NULL,NULL,'madmin'),(75,NULL,NULL,'madmin'),(76,NULL,NULL,'madmin'),(77,NULL,NULL,'madmin'),(78,NULL,NULL,'madmin'),(79,NULL,NULL,'madmin'),(80,NULL,NULL,'madmin'),(81,NULL,NULL,'madmin'),(82,NULL,NULL,'madmin'),(83,NULL,NULL,'madmin'),(84,NULL,NULL,'madmin'),(85,NULL,NULL,'madmin'),(86,NULL,NULL,'madmin'),(87,NULL,NULL,'madmin'),(90,NULL,NULL,'madmin'),(91,NULL,NULL,'madmin'),(92,NULL,NULL,'madmin'),(94,NULL,NULL,'madmin'),(95,NULL,NULL,'madmin'),(96,NULL,NULL,'madmin'),(97,NULL,NULL,'madmin'),(98,NULL,NULL,'madmin'),(99,NULL,NULL,'madmin'),(100,NULL,NULL,'madmin'),(101,NULL,NULL,'madmin'),(102,NULL,NULL,'madmin'),(103,NULL,NULL,'madmin'),(104,NULL,NULL,'madmin'),(105,NULL,NULL,'madmin'),(106,NULL,NULL,'madmin'),(107,NULL,NULL,'madmin'),(108,NULL,NULL,'madmin'),(109,NULL,NULL,'madmin'),(110,NULL,NULL,'madmin'),(111,NULL,NULL,'madmin'),(112,NULL,NULL,'madmin'),(113,NULL,NULL,'madmin'),(114,NULL,NULL,'madmin'),(115,NULL,NULL,'madmin'),(116,NULL,NULL,'madmin'),(117,NULL,NULL,'madmin'),(118,NULL,NULL,'madmin'),(119,NULL,NULL,'madmin'),(120,NULL,NULL,'madmin'),(121,NULL,NULL,'madmin'),(122,NULL,NULL,'madmin'),(123,NULL,NULL,'madmin'),(124,NULL,NULL,'madmin'),(125,NULL,NULL,'madmin'),(126,NULL,NULL,'madmin'),(127,NULL,NULL,'madmin'),(128,NULL,NULL,'madmin'),(129,NULL,NULL,'madmin'),(130,NULL,NULL,'madmin'),(131,NULL,NULL,'madmin'),(132,NULL,NULL,'madmin');
INSERT INTO `variants_temp` (`_id`, `vari1`, `varprice1`, `vari2`, `varprice2`, `vari3`, `varprice3`, `vari4`, `varprice4`, `vari5`, `varprice5`) VALUES (3,'Regular','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'lemon tea','15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'Regular','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'lemon tea','15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'Regular','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'lemon tea','15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'shiva dass','1234567890','','',''),(2,'','9535897598','','',''),(3,'','9535897598','','','');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'Abc enterprise ','1234567890','','','');
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,'shiva dass','1234567890','','20.0','0','0','0','0','20.0','11:34 am','31 May 2024','31 May 2024','202405311134','20240531','0','20.0','0','31 May 2024','11:34 am','202405311134',''),(2,'shiva dass','1234567890','','1000.0','0','0','0','0','1000.0','05:05 pm','10 Jun 2024','10 Jun 2024','202406101705','20240610','500','500.0','500','10 Jun 2024','05:05 pm','202406101705','');
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,'shiva dass','1234567890','idly','2','10','20.0','','20.0','0','0','0','0','20.0','11:34 am','31 May 2024','31 May 2024','202405311134','20240531','','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),(2,'shiva dass','1234567890','idly','100','10','1000.0','','1000.0','0','0','0','0','1000.0','05:05 pm','10 Jun 2024','10 Jun 2024','202406101705','20240610','500','500.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,'shiva dass','1234567890','','','','20.0','0.0','20.0','1'),(2,'shiva dass','1234567890','','','','20.0','0.0','20.0','1'),(3,'shiva dass','1234567890','','','','1020.0','500.0','520.0','2');
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 (2,'Abc enterprise ','1234567890','','','','0.0','0.0','0.0','0');
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','10:00 AM','Tomorrow','02:00 AM','10:00','02:00');
