INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Qsr');
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),(4,'','4',NULL,'first','0','4','0'),(5,'','5',NULL,'first','0','4','0'),(6,'','6',NULL,'first','0','4','0');
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,'','','',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');
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 (11,'Rural Monk Ventures Private Limited','7829822079',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'Thank you Visit Again',NULL,'#43,3rd D Cross','ruralmonkventures@gmail.com','www.ruralmonk.org','1st Main Road','Basaveshwara Nagar');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'India');
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');
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),(10,'Girmit',NULL,NULL,NULL,NULL),(11,'OG Snacks',NULL,NULL,NULL,NULL),(12,'Mirchi Bajji',NULL,NULL,NULL,NULL),(13,'Our special',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,'Sugar','Masala Tea ','0','6.90','08 Dec 2024','202412081701','05:01:44 pm','1701','202412081701','Kg','13.1'),(2,'Sugar','Lemon  Tea ','0','6.90','08 Dec 2024','202412081701','05:01:44 pm','1701','202412081701','Kg','13.1'),(3,'Sugar','Purple Tea ','0','6.90','08 Dec 2024','202412081701','05:01:44 pm','1701','202412081701','Kg','13.1'),(4,'Sugar','Hibiscus Tea ','0','6.90','08 Dec 2024','202412081701','05:01:44 pm','1701','202412081701','Kg','13.1'),(5,'Sugar','Malnad Purple Tea','0','6.90','08 Dec 2024','202412081701','05:01:44 pm','1701','202412081701','Kg','13.1'),(6,'kitchep sachet','Belagavi Special Bread Toast ','0','0.00','22 Dec 2024','202412221639','04:39:59 pm','1639','202412221639','no.','200.0'),(7,'Gokak Special Lalagi Laadu','Gokak Special Ladagi Ladu','0','14.00','24 Jan 2025','202501241621','04:21:45 pm','1621','202501241621','Kg','86.0'),(8,'Belagavi Special Kunda ','Belgaum Special Kunda ','0','10.00','24 Jan 2025','202501241622','04:22:05 pm','1622','202502071605','Kg','90.0'),(9,'Onion','Classic Girmit','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(10,'Onion','Hubli spl Tomato Girmit','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(11,'Onion','Ranebennur Special Bellulli Girmit','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(12,'Onion','Airani Special Girmit','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(13,'Onion','Mango Girmit','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(14,'Onion','Pine apple Girmit ','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(15,'Onion','Sprouted Girmit ','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(16,'Onion','Classic Oggarane Mandakki','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(17,'Onion','Gulbarga Special Susla','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(18,'Onion','Raichur Spl Susla','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(19,'Onion','Oggarane avalakki ','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0'),(20,'Onion','Bagalkote Special Susla ','0','20','25 Feb 2026','202602251328','01:28:06 pm','1328','202602251328','Kg','30.0');
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,'Egg','60','450','308','no.','0',NULL,'202408111516','11 Aug 2024','1516','03:16:59 pm','202408111516','0','142.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(2,'Sugar','10','20','6.9','Kg','42',NULL,'202412081701','08 Dec 2024','1701','05:01:48 pm','202412081701','42','13.1','',NULL,NULL,NULL,NULL,NULL,NULL,'42',NULL),(3,'kitchep sachet','100','200','0','no.','0',NULL,'202412221640','22 Dec 2024','1640','04:40:03 pm','202412221640','0','200.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(4,'mandakki ','0','0','70','L','0',NULL,'202501021212','02 Jan 2025','1212','12:12:41 pm','202501021212','0','-70.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(5,'termaric powder ','0','500','1','Kg','0',NULL,'202501021213','02 Jan 2025','1213','12:13:41 pm','202501041049','0','499.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(6,'MTR SAMBAR MASALA ','0','135','135','gm','0',NULL,'202501021215','02 Jan 2025','1215','12:15:26 pm','202501041048','0','0.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(7,'Onion ','0','50','15','Kg','0',NULL,'202501021215','02 Jan 2025','1215','12:15:48 pm','202501041048','0','35.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(8,'Belagavi Special Kunda ','0','100','9','no.','0',NULL,'202501041039','04 Jan 2025','1039','10:39:28 am','202502071605','0','91.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(9,'Belagavi Special Kunda ','0','100','9','no.','0',NULL,'202501041044','04 Jan 2025','1044','10:44:38 am','202502071605','0','91.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(10,'Gokak Special Karadant ','0','100','10','no.','0',NULL,'202501041045','04 Jan 2025','1045','10:45:15 am','202501241621','0','90.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(11,'Gokak Special Lalagi Laadu','0','100','14','no.','0',NULL,'202501041045','04 Jan 2025','1045','10:45:58 am','202501241621','0','86.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(12,'Mandaki','0','0','5','no.','320',NULL,'202510162054','16 Oct 2025','2054','08:54:35 pm','202510162054','320','-5.0','',NULL,NULL,NULL,NULL,NULL,NULL,'320',NULL),(13,'dish wash soap','1','2','1','no.','50',NULL,'202510162055','16 Oct 2025','2055','08:55:08 pm','202510162055','50','1.0','',NULL,NULL,NULL,NULL,NULL,NULL,'50',NULL),(14,'metal dish scrub','0','0','1','no.','20',NULL,'202510162055','16 Oct 2025','2055','08:55:35 pm','202510162055','20','-1.0','',NULL,NULL,NULL,NULL,NULL,NULL,'20',NULL),(15,'green scrub','0','0','4','no.','25',NULL,'202510162056','16 Oct 2025','2056','08:56:06 pm','202510162056','25','-4.0','',NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL),(16,'Onion','20','50','20','Kg','30',NULL,'202602251328','25 Feb 2026','1328','01:28:09 pm','202602251328','30','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL),(17,'Kadak Rotti','10','50','10','no.','0',NULL,'202602251328','25 Feb 2026','1328','01:28:52 pm','202602251328','0','40.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(18,'Putani chutney powder','1','2','1','Kg','250',NULL,'202602251329','25 Feb 2026','1329','01:29:45 pm','202602251329','250','1.0','',NULL,NULL,NULL,NULL,NULL,NULL,'250',NULL),(19,'salt','5','10','5','Kg','30',NULL,'202602251330','25 Feb 2026','1330','01:30:11 pm','202602251330','30','5.0','',NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL),(20,'Mixture','10','20','5','Kg','180',NULL,'202602251330','25 Feb 2026','1330','01:30:33 pm','202602251330','180','15.0','',NULL,NULL,NULL,NULL,NULL,NULL,'180',NULL),(21,'Ajwan','.500','2','.500','Kg','150',NULL,'202602251331','25 Feb 2026','1331','01:31:34 pm','202602251331','150','1.5','',NULL,NULL,NULL,NULL,NULL,NULL,'150',NULL),(22,'Peri peri masala','1','2','1','Kg','450',NULL,'202602251332','25 Feb 2026','1332','01:32:01 pm','202602251332','450','1.0','',NULL,NULL,NULL,NULL,NULL,NULL,'450',NULL),(23,'Mandakki','5','10','2','no.','480',NULL,'202602251332','25 Feb 2026','1332','01:32:31 pm','202602251332','480','8.0','',NULL,NULL,NULL,NULL,NULL,NULL,'480',NULL),(24,'Hittu','10','30','10','Kg','100',NULL,'202602251333','25 Feb 2026','1333','01:33:52 pm','202602251333','100','20.0','',NULL,NULL,NULL,NULL,NULL,NULL,'100',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'Belgaum Special Kunda ','0','Kg','yes'),(2,'Lemon  Tea ','0','Kg','yes'),(3,'Purple Tea ','0','Kg','yes'),(4,'Hibiscus Tea ','0','Kg','yes'),(5,'Malnad Purple Tea','0','Kg','yes');
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`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (99,'Chocolate mousse ',120.00,-100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ch','',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),(100,'Vanilla cup cakes ',0.00,-100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Va','',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),(101,'SNACKS BOX',400.00,650,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SN','',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 `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,'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),(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 (8,'2 inch');
INSERT INTO `razorpaymerchantreg` (`_id`, `account`, `account_id`) VALUES (1,'Not_Registered','');
INSERT INTO `restaurant_id` (`_id`, `merchant_id`) VALUES (1,'1326930');
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 `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 `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');
