INSERT INTO `items_temp_list` (`_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `not_required`) VALUES (1,'Jeans','350.0','350.0','350.0','10.0','3500.0','',''),(2,'qweyu','45.0','45.0','45.0','20.0','900.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 (9,'admin','0000'),(10,'admin','0000'),(12,'user2','2222'),(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');
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,'Adults','None','',NULL),(2,'podi',0,50,'Adults','None','',NULL),(3,'cheese',15,35,'Adults','None','',NULL),(4,'butter',10,40,'Adults','None','',NULL),(5,'omlette',10,50,'Adults','None','',NULL),(6,'cheese dip',20,50,'Kids','None','',NULL),(7,'potato fry',25,50,'Kids','None','',NULL),(8,'chicken fry',40,45,'Kids','None','',NULL),(9,'soda',6,50,'Kids','None','',NULL),(10,'dessert',15,35,'Kids','None','',NULL),(11,'medium',5,50,'Drinks','None','',NULL),(12,'large',10,50,'Drinks','None','',NULL),(13,'cream',20,50,'Desserts','None','',NULL),(14,'chocolate',20,50,'Desserts','None','',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,'pax');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `round_off` (`_id`, `round_off_status`) VALUES (1,'No');
INSERT INTO `schedule_mail_on_off` (`_id`, `status`) VALUES (1,'Off');
INSERT INTO `schedule_mail_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `stockcontrol` (`_id`, `stockcontroltype`) VALUES (1,'Off');
INSERT INTO `stockreset` (`_id`, `stockresettype`) VALUES (1,'Off');
INSERT INTO `storedays` (`_id`, `weekdays`, `weekends`, `swap`) VALUES (1,'Monday','0','0'),(2,'Tuesday','0','0'),(3,'Wednesday','0','0'),(4,'Thursday','0','0'),(5,'0','Friday','Friday'),(6,'0','Saturday','Saturday'),(7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`_id`, `last_time`) VALUES (1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`_id`, `status`) VALUES (1,'Lite');
INSERT INTO `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 (4,NULL,NULL,'madmin'),(5,NULL,NULL,'madmin'),(6,NULL,'0000','madmin'),(7,NULL,'0000','madmin'),(9,NULL,NULL,'user2'),(10,NULL,NULL,'madmin'),(11,NULL,NULL,'madmin'),(12,NULL,NULL,'madmin'),(13,NULL,'0000','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,'0000','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');
INSERT INTO `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'shivani ','8123150948','','','');
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,'shivani ','8123150948','','3500.0','0','0','0','0','3500.0','10:04 am','09 Sept 2024','09 Sept 2024','202409091004','20240909','3500','0.0','3500','09 Sept 2024','10:04 am','202409091004',''),(2,'shivani ','8123150948','','17500.0','0','0','0','0','17500.0','03:34 pm','11 Sept 2024','11 Sept 2024','202409111534','20240911','17500','0.0','17500','11 Sept 2024','03:34 pm','202409111534',''),(3,'shivani ','8123150948','','1000.0','0','0','0','0','1000.0','06:19 pm','27 Sept 2024','27 Sept 2024','202409271819','20240927','1000.0','0.0','1000.0','27 Sept 2024','06:19 pm','202409271819',''),(4,'shivani ','8123150948','','900.0','0','0','0','0','900.0','04:58 pm','04 Nov 2024','04 Nov 2024','202411041658','20241104','900','0.0','900','04 Nov 2024','04:58 pm','202411041658','');
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,'shivani ','8123150948','Jeans','10','350','3500.0','','3500.0','0','0','0','0','3500.0','10:04 am','09 Sept 2024','09 Sept 2024','202409091004','20240909','3500','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),(59,'shivani ','8123150948','Jeans','10','350','3500.0','','3500.0','0','0','0','0','3500.0','10:04 am','09 Sept 2024','09 Sept 2024','202409091004','20240909','3500','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),(60,'shivani ','8123150948','Jeans','50','350','17500.0','','17500.0','0','0','0','0','17500.0','03:34 pm','11 Sept 2024','11 Sept 2024','202409111534','20240911','17500','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),(61,'shivani ','8123150948','sona masoori raw rice 1kg','20','50','1000.0','','1000.0','0','0','0','0','1000.0','06:19 pm','27 Sept 2024','27 Sept 2024','202409271819','20240927','1000.0','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),(62,'shivani ','8123150948','qweyu','20','45','900.0','','900.0','0','0','0','0','900.0','04:58 pm','04 Nov 2024','04 Nov 2024','202411041658','20241104','900','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);
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,'shivani ','8123150948','','','','22000.0','22000.0','0.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');
