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 (4,NULL,'1',NULL,'test','0','4',NULL),(5,NULL,'2',NULL,'test','0','4',NULL),(37,NULL,'2',NULL,'2ndFloor','0','2','1'),(75,NULL,'1',NULL,'DEMO1','0','5','2'),(76,NULL,'2',NULL,'DEMO1','0','5','2'),(77,NULL,'3',NULL,'DEMO1','0','5',NULL),(83,NULL,'83',NULL,'First','0','4','2'),(84,NULL,'84',NULL,'First','0','4','0'),(85,NULL,'85',NULL,'First','0','4','0'),(86,NULL,'86',NULL,'First','0','4',NULL),(87,NULL,'87',NULL,'First','0','4',NULL),(88,NULL,'1',NULL,'Third Floor','0','4',NULL),(89,NULL,'2',NULL,'Third Floor','0','4',NULL),(90,NULL,'3',NULL,'Third Floor','0','4',NULL),(91,NULL,'4',NULL,'Third Floor','0','4',NULL),(92,NULL,'5',NULL,'Third Floor','0','4',NULL),(93,NULL,'93',NULL,'Third Floor','0','4',NULL),(94,NULL,'1',NULL,'check','0','4',NULL),(95,NULL,'2',NULL,'check','0','4',NULL),(96,NULL,'96',NULL,'check','0','4',NULL),(97,NULL,'1',NULL,'test5','0','4',NULL),(98,NULL,'1',NULL,'DEMO1','0','4',NULL),(99,NULL,'2',NULL,'DEMO1','0','4',NULL),(100,NULL,'1',NULL,'DEMO1','0','4',NULL),(101,NULL,'1',NULL,'DEMO1','0','4',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,'','','',NULL);
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,'ivepos',NULL,NULL,NULL,NULL,NULL,NULL,NULL,9985460385,'5',NULL,'bil_footer',NULL,'test1','demo@gmail.com','www.demo.com','test2','test3');
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 `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `floors` (`_id`, `floorname`, `position`) VALUES (1,'First','0'),(2,'DEMO1','4'),(3,'2ndFloor','4'),(4,'Third Floor','4'),(5,'check','4'),(6,'test5','4'),(7,'DEMO1','4'),(8,'DEMO1','4'),(9,'DEMO1','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 (8,'TIFFIN',NULL,NULL,NULL,0),(9,'drinks',NULL,NULL,NULL,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 (43,'idly',40.00,48,'TIFFIN','Itemtax(3.00%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','id','43',NULL,NULL,NULL,'80','80','50','Low',NULL,'50','Unit','3.00','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'dosa',30.00,59,'TIFFIN','Itemtax(3.00%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','do','44',NULL,NULL,NULL,'80','80','60','Low',NULL,'85','Unit','3.00','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'demo',40.00,-1,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','de','46',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,NULL,'','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'pepsi',40.00,3,'drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','pe','47',NULL,NULL,NULL,'80','80',NULL,'Low',NULL,NULL,NULL,'','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'iVBORw0KGgoAAAANSUhEUgAAAGAAAABgCAYAAADimHc4AAACTUlEQVR42u3cSWvCUBDAcbvQjba3brceBA+CuAX15qnXisXST1BKv4D1JgVPpgt0/7adgdyKib737KD+B4Yc2pe080smCfpeLkcQBEEQBEEQixPtdnuz1WrtFovF/VVOrUGv19v4t8LXarWzarXale1DvV4fyXa8ypnUoC/ZKZVKx3MrfD6f35aDXcmBvmT7Q/5Nqc2nQsiVsRW8+LLjOznzvyl0emqNJG+DIuiZT/FnQ9ArIUjxoyg6pe24taMg9wS94VJQZ4SO96Om7GRAMZ0B+l6PqPqMq49ZFNM5R1pDZwB90UiedSmm2xUw1hoCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKwCwDR/UNZ4yb1JYxuNxqH8/CltH2nH1vHyOy8AAAAAAAAAAAAAACwbQCz/5EnanKus8ZVK5WjS2GT61HPaPtKOreMlX5cWIJm4EGfMufIZH2dNJMmY8xWHnIjCmzBvwgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACLAFAoFA6yPuAg5wgQ+iM6AAAAAAAAFmfBJgC8r4CBLvsGgN3ylV2vRfsA8Dr7P/R7RgDY5Y33mqEAOJ/990GWLgZg5p7/FkXRtdx4d4IsWwzAVPkuZ/yjtpxms3kedNV0HwBdbzrYAtarGq4AWvxyuXw5HA7XqaINQIfiGwDQdgwBaDv2ALQdCwDajiEAbccegLZjAUDbMQSg7dgD0HYsAGg7hgC0HXsA2o5F6FcTpfgXVMIu1jjzCYIgCIIgCGLp4hf+oUWJ4YTJIQAAAABJRU5ErkJggg==');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `menulogin_checking` (`_id`, `status`) VALUES (1,'no');
INSERT INTO `modifiers` (`_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,'potato masala',10,50,'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),(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 (1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'2315');
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,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','08:36 AM','Oct 27, 2023','20231027083641'),(2,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','08:36 AM','Oct 27, 2023','20231027083641'),(3,'veg biriyani','5','8247488369dine','chinna','okkam','store1','device1','08:37 AM','Oct 27, 2023','20231027083745'),(4,'veg biriyani','5','8247488369dine','chinna','okkam','store1','device1','08:37 AM','Oct 27, 2023','20231027083745'),(5,'veg biriyani','6','8247488369dine','chinna','okkam','store1','device1','08:38 AM','Oct 27, 2023','20231027083859'),(6,'veg biriyani','6','8247488369dine','chinna','okkam','store1','device1','08:38 AM','Oct 27, 2023','20231027083859'),(7,'rice','5','8247488369dine','store1','device1','chinna','okkam','08:50 AM','Oct 27, 2023','20231027085042'),(8,'rice','5','8247488369dine','store1','device1','chinna','okkam','08:50 AM','Oct 27, 2023','20231027085042'),(9,'coffee','3','8247488369dine','chinna','okkam','store1','device1','08:54 AM','Oct 27, 2023','20231027085406'),(10,'coffee','3','8247488369dine','chinna','okkam','store1','device1','08:54 AM','Oct 27, 2023','20231027085406'),(11,'lassi','5','8247488369dine','chinna','okkam','store1','device1','09:22 AM','27 Oct 2023','20231027092236'),(12,'lassi','5','8247488369dine','chinna','okkam','store1','device1','09:22 AM','27 Oct 2023','20231027092236'),(13,'rice','7','8247488369dine','store1','device1','chinna','okkam','09:54 AM','Oct 28, 2023','20231028095410'),(14,'rice','7','8247488369dine','store1','device1','chinna','okkam','09:54 AM','Oct 28, 2023','20231028095410'),(15,'coffee','4','8247488369dine','chinna','okkam','store1','device1','09:54 AM','Oct 28, 2023','20231028095458'),(16,'coffee','4','8247488369dine','chinna','okkam','store1','device1','09:54 AM','Oct 28, 2023','20231028095458'),(17,'tea','2','8247488369dine','chinna','okkam','store1','device1','10:21 AM','Oct 28, 2023','20231028102152'),(18,'tea','2','8247488369dine','chinna','okkam','store1','device1','10:21 AM','Oct 28, 2023','20231028102152'),(19,'test','5','8247488369dine','chinna','okkam','store1','device1','10:31 AM','Oct 28, 2023','20231028103151'),(20,'test','5','8247488369dine','chinna','okkam','store1','device1','10:31 AM','Oct 28, 2023','20231028103151'),(21,'lime juice','7','8247488369dine','chinna','okkam','store1','device1','10:00 AM','Oct 30, 2023','20231030100039'),(22,'lime juice','7','8247488369dine','chinna','okkam','store1','device1','10:00 AM','Oct 30, 2023','20231030100039'),(23,'roti','6','8247488369dine','chinna','okkam','store1','device1','10:11 AM','Oct 30, 2023','20231030101121'),(24,'roti','6','8247488369dine','chinna','okkam','store1','device1','10:11 AM','Oct 30, 2023','20231030101121'),(25,'lassi','7','8247488369dine','chinna','okkam','store1','device1','10:14 AM','Oct 30, 2023','20231030101420'),(26,'lassi','7','8247488369dine','chinna','okkam','store1','device1','10:14 AM','Oct 30, 2023','20231030101420'),(27,'roti','8','8247488369dine','chinna','okkam','store1','device1','09:44 AM','Oct 31, 2023','20231031094425'),(28,'roti','8','8247488369dine','chinna','okkam','store1','device1','09:44 AM','Oct 31, 2023','20231031094425'),(29,'tea','2','8247488369dine','chinna','okkam','store1','device1','09:47 AM','Oct 31, 2023','20231031094744'),(30,'tea','2','8247488369dine','chinna','okkam','store1','device1','09:47 AM','Oct 31, 2023','20231031094744'),(31,'pizza','4','8247488369dine','chinna','okkam','store1','device1','10:00 AM','Oct 31, 2023','20231031100037'),(32,'pizza','4','8247488369dine','chinna','okkam','store1','device1','10:00 AM','Oct 31, 2023','20231031100037'),(33,'veg biriyani','4','8247488369dine','store1','device1','chinna','okkam','10:04 AM','Oct 31, 2023','20231031100456'),(34,'veg biriyani','4','8247488369dine','store1','device1','chinna','okkam','10:04 AM','Oct 31, 2023','20231031100456'),(35,'rice','3','8247488369dine','store1','device1','chinna','okkam','10:06 AM','Oct 31, 2023','20231031100608'),(36,'rice','3','8247488369dine','store1','device1','chinna','okkam','10:06 AM','Oct 31, 2023','20231031100608'),(37,'veg thali','2','8247488369dine','store1','device1','chinna','okkam','10:06 AM','Oct 31, 2023','20231031100653'),(38,'veg thali','2','8247488369dine','store1','device1','chinna','okkam','10:06 AM','Oct 31, 2023','20231031100653'),(39,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','10:09 AM','Oct 31, 2023','20231031100911'),(40,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','10:09 AM','Oct 31, 2023','20231031100911'),(41,'veg biriyani','3','8247488369dine','store1','device1','chinna','okkam','10:11 AM','Oct 31, 2023','20231031101131'),(42,'veg biriyani','3','8247488369dine','store1','device1','chinna','okkam','10:11 AM','Oct 31, 2023','20231031101131'),(43,'veg biriyani','6','8247488369dine','chinna','okkam','store1','device1','10:12 AM','Oct 31, 2023','20231031101234'),(44,'veg biriyani','6','8247488369dine','chinna','okkam','store1','device1','10:12 AM','Oct 31, 2023','20231031101234'),(45,'lime juice','2','8247488369dine','chinna','okkam','store1','device1','10:36 AM','Oct 31, 2023','20231031103655'),(46,'lime juice','2','8247488369dine','chinna','okkam','store1','device1','10:36 AM','Oct 31, 2023','20231031103655'),(47,'coffee','5','8247488369dine','chinna','okkam','store1','device1','01:48 PM','Oct 31, 2023','20231031134858'),(48,'coffee','5','8247488369dine','chinna','okkam','store1','device1','01:48 PM','Oct 31, 2023','20231031134858'),(49,'lassi','4','8247488369dine','store1','device1','chinna','okkam','01:49 PM','Oct 31, 2023','20231031134953'),(50,'lassi','4','8247488369dine','store1','device1','chinna','okkam','01:49 PM','Oct 31, 2023','20231031134953'),(51,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','04:10 am','01 Nov 2023','20231101041010'),(52,'veg biriyani','5','8247488369dine','store1','device1','chinna','okkam','04:10 am','01 Nov 2023','20231101041010'),(53,'roti','3','8247488369dine','chinna','okkam','store1','device1','04:12 am','01 Nov 2023','20231101041237'),(54,'roti','3','8247488369dine','chinna','okkam','store1','device1','04:12 am','01 Nov 2023','20231101041237'),(55,'roti','2','8247488369dine','chinna','okkam','store1','device1','11:15 PM','Nov 01, 2023','20231101231536'),(56,'roti','2','8247488369dine','chinna','okkam','store1','device1','11:15 PM','Nov 01, 2023','20231101231536'),(57,'masala chai','2','8247488369dine','chinna','okkam','store1','device1','11:20 PM','Nov 01, 2023','20231101232019'),(58,'masala chai','2','8247488369dine','chinna','okkam','store1','device1','11:20 PM','Nov 01, 2023','20231101232019'),(59,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(60,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(61,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(62,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(63,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(64,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(65,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(66,'qwerty','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(67,'butterscotch cake','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(68,'qwerty','2','8247488369dine','store1','device1','chinna','okkam','12:35 PM','Dec 19, 2023','20231219123523'),(69,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(70,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(71,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(72,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(73,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(74,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(75,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(76,'pizza','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(77,'chicken biriyani1','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(78,'pizza','2','8247488369dine','chinna','okkam','store1','device1','12:42 PM','Dec 19, 2023','20231219124247'),(79,'veg biriyani','7','8247488369dine','store1','device1','chinna','okkam','07:38 AM','Feb 02, 2024','20240202073843'),(80,'veg biriyani','7','8247488369dine','store1','device1','chinna','okkam','07:38 AM','Feb 02, 2024','20240202073843'),(81,'veg biriyani','4','8247488369dine','store1','device1','chinna','okkam','02:39 PM','Feb 27, 2024','20240227143907'),(82,'veg biriyani','4','8247488369dine','store1','device1','chinna','okkam','02:39 PM','Feb 27, 2024','20240227143907'),(83,'veg biriyani','3','8247488369dine','store1','device1','chinna','okkam','07:25 AM','Mar 01, 2024','20240301072507'),(84,'veg biriyani','6','8247488369dine','chinna','okkam','store1','device1','07:31 AM','Mar 01, 2024','20240301073137'),(85,'veg biriyani','2','8247488369dine','chinna','okkam','store1','device1','05:27 PM','Mar 04, 2024','20240304172718'),(86,'DEMO456','1','8247488369dine','store1','device1','chinna','okkam','04:36 AM','Apr 18, 2024','20240418043639'),(87,'idly','1','8247488369dine','chinna','okkam','store1','device1','04:59 AM','Apr 18, 2024','20240418045935');
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 (3,'Gt tax(5.00%)',5.00,'Globaltax','checked','Dine-in','Takeaway','Home Delivery',''),(4,'Itemtax(3.00%)',3.00,'Itemtax','checked','Dine-in','Takeaway','Home Delivery',''),(5,'cgst(6%)',6.00,'Globaltax',NULL,'Dine-in','Takeaway','Home Delivery','');
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','no','no','no','no','no','no','no'),(2,'user2','yes','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,'demo','8888888888','chinnarokkam456@gmail.com','',''),(2,'test','6666666666','rajaswaminathan2109@gmail.com','',''),(3,'demo','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,'demo','1234567890','576','2500','0','0','0','0','2500','07:04 AM','02 Sep 2024','02 Sep 2024','202409020704','20240902','2500','0.0','2500','02 Sep 2024','07:04 AM','202409020704',NULL),(2,'demo','1234567890','98787','5100','0','0','0','0','5100','07:05 AM','02 Sep 2024','02 Sep 2024','202409020705','20240902','1100','4000.0','1100','02 Sep 2024','07:05 AM','202409020705',NULL),(3,'demo','1234567890','98787','5100','0','0','0','0','5100','07:05 AM','02 Sep 2024','02 Sep 2024','202409020705','20240902','4000','0.0','5100','02 Sep 2024','7:06 AM','202409020706',NULL);
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,'demo','1234567890','idly','50','50','2500','576','2500','0','0','0','0','2500','07:04 AM','02 Sep 2024','02 Sep 2024','202409020704','20240902','2500','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),(2,'demo','1234567890','dosa','60','85','5100','98787','5100','0','0','0','0','5100','07:05 AM','02 Sep 2024','02 Sep 2024','202409020705','20240902','1100','4000.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 `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');
