(35,'lime juice',15.00,30,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'lassi',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','LA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'grape juice',25.00,25,'Drinks','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','GR','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'vanilla icecream',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','VA','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'butterscotch icecream',40.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'butterscotch cake',35.00,50,'Desserts','None','[BLOB]','0','0',NULL,NULL,NULL,'no','%','0','BU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','','','','','','','','','',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','50.0','50.0','50.0','10.0','500.0','',''),(2,'dosa','50.0','50.0','50.0','5.0','250.0','',''),(3,'pongal','35.0','35.0','35.0','50.0','1750.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 `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'100','1','1','10');
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,'wiseposplus');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'2 inch'),(3,'2 inch');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'330');
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 `stock_transfer_item_details` (`_id`, `itemname`, `qty_add`, `company`, `from_store`, `from_device`, `to_store`, `to_device`, `from_time`, `from_date`, `datetimee_new_from`) VALUES (1,'item1','8','asai','asai4','pos4','asai3','pos3','10:18 PM','23 Apr 2020','20200423221811'),(2,'item1','8','asai','asai3','pos3','asai4','pos4','10:19 PM','23 Apr 2020','20200423221943'),(3,'item2','10','asai','asai3','pos3','asai4','pos4','10:21 PM','23 Apr 2020','20200423222122'),(4,'item2','10','asai','asai3','pos3','asai4','pos4','10:21 PM','23 Apr 2020','20200423222122'),(5,'poori','5','asai','asai3','pos3','asai4','pos4','11:05 AM','06 Jun 2020','20200606110523');
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 `tax_selec` (`_id`, `tax_amount`, `tax_per`, `selected_but`) VALUES (1,'7.0','5.0','Default');
INSERT INTO `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'CGST(2.5%)',2.50,'Itemtax','checked','dine_in','takeaway','homedelivery',''),(2,'SGST(2.5%)',2.50,'Itemtax','checked','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','yes','yes','yes','no','no','yes','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,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj');
INSERT INTO `vendor_details_micro` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n'),(2,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx');
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,'m retail','12345689','123','500.0','0','0','0','0','500.0','09:28 PM','23 Apr 2020','23 Apr 2020','202004232128','20200423','250','250.0','250','23 Apr 2020','09:28 PM','202004232128',''),(2,'m retail','12345689','124','2000.0','5.0','100.0','0','0','2100.0','09:29 PM','23 Apr 2020','23 Apr 2020','202004232129','20200423','1500','600.0','1500','23 Apr 2020','09:29 PM','202004232129',''),(3,'m retail','12345689','opk','750.0','0','0','0','0','750.0','09:35 PM','23 Apr 2020','23 Apr 2020','202004232135','20200423','0','750.0','0','23 Apr 2020','09:35 PM','202004232135',''),(4,'m retail','12345689','123','1250.0','0','0','0','0','1250.0','03:50 PM','08 Jul 2020','08 Jul 2020','202007081550','20200708','500','750.0','500','08 Jul 2020','03:50 PM','202007081550',''),(5,'m retail','12345689','125','450.0','0','0','0','0','450.0','03:51 PM','08 Jul 2020','08 Jul 2020','202007081551','20200708','200','250.0','200','08 Jul 2020','03:51 PM','202007081551',''),(6,'m retail','12345689','129','140.0','5.0','7.0','0','0','147.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','97.0','50','09 Jul 2020','12:25 PM','202007091225',''),(7,'m retail','12345689','128','90.0','0','0','0','0','90.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','40.0','50','09 Jul 2020','12:25 PM','202007091225','');
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,'m retail','12345689','item1','10','50','500.0','123','500.0','0','0','0','0','500.0','09:28 PM','23 Apr 2020','23 Apr 2020','202004232128','20200423','250','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),(2,'m retail','12345689','item2','5','50','250.0','124','2000.0','5.0','100.0','0','0','2100.0','09:29 PM','23 Apr 2020','23 Apr 2020','202004232129','20200423','1500','600.0','CGST(2.5%)','SGST(2.5%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2.5','2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'m retail','12345689','item3','50','35','1750.0','124','2000.0','5.0','100.0','0','0','2100.0','09:29 PM','23 Apr 2020','23 Apr 2020','202004232129','20200423','1500','600.0','CGST(2.5%)','SGST(2.5%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2.5','2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'m retail','12345689','item1','5','50','250.0','opk','750.0','0','0','0','0','750.0','09:35 PM','23 Apr 2020','23 Apr 2020','202004232135','20200423','','750.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,'m retail','12345689','item2','10','50','500.0','opk','750.0','0','0','0','0','750.0','09:35 PM','23 Apr 2020','23 Apr 2020','202004232135','20200423','','750.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,'m retail','12345689','item1','50','10','500.0','123','1250.0','0','0','0','0','1250.0','03:50 PM','08 Jul 2020','08 Jul 2020','202007081550','20200708','500','750.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,'m retail','12345689','item2','50','15','750.0','123','1250.0','0','0','0','0','1250.0','03:50 PM','08 Jul 2020','08 Jul 2020','202007081550','20200708','500','750.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,'m retail','12345689','item1','45','10','450.0','125','450.0','0','0','0','0','450.0','03:51 PM','08 Jul 2020','08 Jul 2020','202007081551','20200708','200','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),(9,'m retail','12345689','item1','5','10','50.0','129','140.0','5.0','7.0','0','0','147.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','97.0','CGST(2.5%)','SGST(2.5%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2.5','2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'m retail','12345689','item2','6','15','90.0','129','140.0','5.0','7.0','0','0','147.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','97.0','CGST(2.5%)','SGST(2.5%)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2.5','2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'m retail','12345689','item1','3','10','30.0','128','90.0','0','0','0','0','90.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','40.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),(12,'m retail','12345689','item2','4','15','60.0','128','90.0','0','0','0','0','90.0','12:25 PM','09 Jul 2020','09 Jul 2020','202007091225','20200709','50','40.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,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','3350.0','1750.0','1600.0','3'),(2,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','3350.0','1750.0','1600.0','3'),(3,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','3350.0','1750.0','1600.0','3'),(4,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','3350.0','1750.0','1600.0','3'),(5,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','5197.0','2550.0','2647.0','6'),(6,'m retail','12345689','xcg@retail.com','bengaluru','qwethhj','5197.0','2550.0','2647.0','6');
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,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','975.0','475.0','500.0','1'),(2,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','975.0','475.0','500.0','1'),(3,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','975.0','975.0','0.0','1'),(4,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','7095.0','3975.0','3120.0','2'),(5,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','10230.0','4975.0','5255.0','5'),(6,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','5475.0','5910.0','6'),(7,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','5475.0','5910.0','6'),(8,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx','0.0','0.0','0.0','0'),(9,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','5475.0','5910.0','6'),(10,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx','0.0','0.0','0.0','0'),(11,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','5475.0','5910.0','6'),(12,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx','0.0','0.0','0.0','0'),(13,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','5475.0','5910.0','6'),(14,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx','0.0','0.0','0.0','0'),(15,'nandus retail','9999999999','xxx@retail.com','bengaluru','12345678n','11385.0','6130.0','5255.0','6'),(16,'vendor','5678906432','sdf@gmail.com','bengaltu','xxxx','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','12:01 AM','Today','11:59 PM','00:01','23:59');
