INSERT INTO `account_selection` (`my_row_id`, `_id`, `selection`) VALUES (9,1,'Dine');
INSERT INTO `alaramdays` (`my_row_id`, `_id`, `selecteddays`, `unselecteddays`, `swap`) VALUES (1,1,'Monday','0','0'),(2,2,'Tuesday','0','0'),(3,3,'Wednesday','0','0'),(4,4,'Thursday','0','0'),(5,5,'Friday','0','0'),(6,6,'Saturday','0','0'),(7,7,'Sunday','0','0'),(8,1,'Monday','0','0'),(9,2,'Tuesday','0','0'),(10,3,'Wednesday','0','0'),(11,4,'Thursday','0','0'),(12,5,'Friday','0','0'),(13,6,'Saturday','0','0'),(14,7,'Sunday','0','0'),(15,1,'Monday','0','0'),(16,2,'Tuesday','0','0'),(17,3,'Wednesday','0','0'),(18,4,'Thursday','0','0'),(19,5,'Friday','0','0'),(20,6,'Saturday','0','0'),(21,7,'Sunday','0','0');
INSERT INTO `alaramon_off` (`my_row_id`, `_id`, `status`) VALUES (1,1,'On'),(2,1,'On'),(3,1,'On');
INSERT INTO `alaramtime` (`my_row_id`, `_id`, `time`) VALUES (1,1,'11:30 PM'),(2,1,'11:30 PM'),(3,1,'11:30 PM');
INSERT INTO `asd1` (`my_row_id`, `_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,1,'','1',NULL,'first','0','6','2'),(2,2,'','2',NULL,'first','0','4','6'),(3,3,'','3',NULL,'first','0','4','2'),(4,4,'','4',NULL,'first','0','4','2'),(5,5,'','5',NULL,'first','0','4','25'),(6,6,NULL,'6',NULL,'first','0','4',NULL),(7,7,NULL,'7',NULL,'first','0','4',NULL),(8,8,NULL,'8',NULL,'first','0','4',NULL),(9,9,NULL,'9',NULL,'first','0','4',NULL),(10,10,NULL,'10',NULL,'first','0','4',NULL),(11,11,NULL,'11',NULL,'first','0','4',NULL),(12,12,NULL,'12',NULL,'first','0','4',NULL),(13,13,NULL,'1',NULL,'Titto floor','0','4','2'),(14,14,NULL,'2',NULL,'Titto floor','0','4','2'),(15,15,NULL,'3',NULL,'Titto floor','0','4',NULL),(16,16,NULL,'4',NULL,'Titto floor','0','4',NULL),(17,17,NULL,'5',NULL,'Titto floor','0','4',NULL),(18,1,'','1',NULL,'first','0','4',NULL),(19,2,'','2',NULL,'first','0','4',NULL),(20,3,'','3',NULL,'first','0','4',NULL),(21,1,'','1',NULL,'first','0','4',NULL),(22,2,'','2',NULL,'first','0','4',NULL),(23,3,'','3',NULL,'first','0','4',NULL);
INSERT INTO `auto_connect` (`my_row_id`, `_id`, `auto_connect_status`) VALUES (1,1,'No'),(2,1,'No'),(3,1,'No');
INSERT INTO `auto_generate_barcode` (`my_row_id`, `_id`, `generate`) VALUES (1,1,'off'),(2,1,'off'),(3,1,'off');
INSERT INTO `billingmode` (`my_row_id`, `_id`, `billingtype`) VALUES (1,1,'Fine dine'),(2,1,'Fine dine'),(3,1,'Fine dine');
INSERT INTO `billingtype` (`my_row_id`, `_id`, `billingtype_type`) VALUES (1,1,'Dine-in'),(2,1,'Dine-in'),(3,1,'Dine-in');
INSERT INTO `btconn` (`my_row_id`, `_id`, `name`, `address`, `status`, `device`) VALUES (1,1,'','','',NULL),(2,1,'','','',NULL),(3,1,'','','',NULL);
INSERT INTO `cardswiperactivation` (`my_row_id`, `_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,1,'PaySwiff','','','Not Activated'),(2,2,'mSwipe','','','Not Activated'),(3,3,'PineLabs','','','Not Activated'),(4,4,'Firstdata','','','Not Activated'),(5,5,'Paytm','','','Not Activated'),(6,6,'ezetap','','','Not Activated'),(7,1,'PaySwiff','','','Not Activated'),(8,2,'mSwipe','','','Not Activated'),(9,3,'PineLabs','','','Not Activated'),(10,4,'Firstdata','','','Not Activated'),(11,5,'Paytm','','','Not Activated'),(12,6,'ezetap','','','Not Activated'),(13,1,'PaySwiff','','','Not Activated'),(14,2,'mSwipe','','','Not Activated'),(15,3,'PineLabs','','','Not Activated'),(16,4,'Firstdata','','','Not Activated'),(17,5,'Paytm','','','Not Activated'),(18,6,'ezetap','','','Not Activated');
INSERT INTO `change_time_format` (`my_row_id`, `_id`, `status`) VALUES (1,1,'changed'),(2,1,'changed'),(3,1,'changed');
INSERT INTO `companydetailss` (`my_row_id`, `_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (1,1,'Hotel retro',NULL,NULL,NULL,NULL,NULL,NULL,NULL,7094869231,'',NULL,'',NULL,'','','','','');
INSERT INTO `country_selection` (`my_row_id`, `_id`, `country`) VALUES (1,1,'Rupee'),(2,1,'India'),(3,1,'India');
INSERT INTO `custom_bill_size` (`my_row_id`, `id`, `width`) VALUES (1,1,'79');
INSERT INTO `default_credit` (`my_row_id`, `_id`, `status`) VALUES (1,1,'off'),(2,1,'off'),(3,1,'off');
INSERT INTO `deletedb_time` (`my_row_id`, `_id`, `time`) VALUES (1,1,'11:30 PM'),(2,1,'11:30 PM'),(3,1,'11:30 PM');
INSERT INTO `deletedbon_off` (`my_row_id`, `_id`, `status`) VALUES (1,1,'off'),(2,1,'off'),(3,1,'off');
INSERT INTO `estimate_print` (`my_row_id`, `_id`, `status`) VALUES (1,1,'Yes'),(2,1,'Yes'),(3,1,'Yes');
INSERT INTO `floors` (`my_row_id`, `_id`, `floorname`, `position`) VALUES (1,1,'first','0'),(2,2,'Titto floor','4'),(3,1,'first','0'),(4,1,'first','0'),(5,1,'first','0');
INSERT INTO `freetrail` (`my_row_id`, `_id`, `status`) VALUES (1,1,'Activated'),(2,1,'Activated'),(3,1,'Activated'),(4,1,'Activated');
INSERT INTO `home_check` (`my_row_id`, `_id`, `login_status`) VALUES (1,1,'0'),(2,1,'0'),(3,1,'0');
INSERT INTO `homedelivery_prints` (`my_row_id`, `_id`, `companycopy`, `customercopy`) VALUES (1,1,'yes','yes'),(2,1,'yes','yes'),(3,1,'yes','yes'),(4,1,'yes','yes');
INSERT INTO `hotel` (`my_row_id`, `_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,1,'All',NULL,NULL,NULL,NULL),(2,2,'Favourites',NULL,NULL,NULL,NULL),(3,3,'Tiffin',NULL,NULL,NULL,NULL),(4,4,'Snacks',NULL,NULL,NULL,NULL),(5,5,'Main course',NULL,NULL,NULL,NULL),(6,6,'Drinks',NULL,NULL,NULL,NULL),(7,7,'Desserts',NULL,NULL,NULL,NULL);
INSERT INTO `ingredient_items_list` (`my_row_id`, `_id`, `ingredient_name`, `itemname`, `item_qyt_used`, `currnet_stock`, `date1`, `date`, `time1`, `time`, `modified_datetimee_new`, `qty_unit`, `required`) VALUES (1,17,'demo','idly','1','13.00','03 Jul 2025','202507031946','19:46:20 pm','1946','202507031946','Kg ','42.0'),(2,18,'demo','dosa','0','13.00','03 Jul 2025','202507031946','19:46:20 pm','1946','202507031946','Kg ','42.0'),(3,19,'demo','pongal','0','13.00','03 Jul 2025','202507031946','19:46:20 pm','1946','202507031946','Kg ','42.0'),(4,20,'demo','upma','0','13.00','03 Jul 2025','202507031946','19:46:20 pm','1946','202507031946','Kg ','42.0');
INSERT INTO `ingredient_sold_details` (`my_row_id`, `_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,1,'test','6666666666','01','1440','0','0','0','0','1440','09:04 AM','10 Jul 2024','10 Jul 2024','202407100904','20240710','0','1440.0','0','10 Jul 2024','09:04 AM','202407100904',NULL),(2,2,'test','6666666666','01','1440','0','0','0','0','1440','09:04 AM','10 Jul 2024','10 Jul 2024','202407100904','20240710','140','1300.0','140','10 Jul 2024','9:04 AM','202407100904',NULL),(3,3,'test','6666666666','01','1440','0','0','0','0','1440','09:04 AM','10 Jul 2024','10 Jul 2024','202407100904','20240710','100','1200.0','240','10 Jul 2024','9:07 AM','202407100907',NULL),(4,4,'test','6666666666','01','1440','0','0','0','0','1440','09:04 AM','10 Jul 2024','10 Jul 2024','202407100904','20240710','100','1100.0','340','10 Jul 2024','9:08 AM','202407100908',NULL),(5,5,'test','6666666666','sjjsjs','100.0','0','0','0','0','100.0','11:50 am','02 Jul 2025','02 Jul 2025','202507021150','20250702','100','0.0','100','02 Jul 2025','11:50 am','202507021150',''),(6,6,'test','6666666666','654165','32','0','0','0','0','32','06:23 AM','02 Jul 2025','02 Jul 2025','202507020623','20250702','32','0.0','32','02 Jul 2025','06:23 AM','202507020623',NULL);
INSERT INTO `ingredient_sold_item_details` (`my_row_id`, `_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,1,'test','6666666666','demo','45','032','1440','01','1440','0','0','0','0','1440','09:04 AM','10 Jul 2024','10 Jul 2024','202407100904','20240710','0','1440.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,NULL,'Kg'),(2,2,'test','6666666666','demo','2','50','100.0','sjjsjs','100.0','0','0','0','0','100.0','11:50 am','02 Jul 2025','02 Jul 2025','202507021150','20250702','100','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,'0','Kg'),(3,3,'test','6666666666','demo','1','32','32','654165','32','0','0','0','0','32','06:23 AM','02 Jul 2025','02 Jul 2025','202507020623','20250702','32','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,NULL,'Kg');
INSERT INTO `ingredients` (`my_row_id`, `_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,1,'demo','1','45','13.00','Kg  ','32',NULL,'202507031943','03 Jul 2025','1943','19:43:16 pm','202507031943','32','42.0','123',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`my_row_id`, `_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,1,'idly','0','Kg','yes');
INSERT INTO `ingredients_temp_list` (`my_row_id`, `_id`, `itemname`, `avg_price`, `min_price`, `max_price`, `total_qty`, `total_price`, `barcode`, `unit`, `wastage_qty`, `wastage_cost`, `not_required`) VALUES (1,1,'demo','50.0','50.0','50.0','2.0','100.0','123','Kg','0.0','0',''),(2,2,'demo','50.0','50.0','50.0','2.0','100.0','123','Kg','0.0','0','');
INSERT INTO `ipconn` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,1,'192.168.1.87','9100','','TM Printer'),(2,1,'192.168.1.87','9100','','TM Printer'),(3,1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,1,'192.168.1.92','9100','',NULL),(2,1,'192.168.1.92','9100','',NULL),(3,1,'192.168.1.92','9100','',NULL);
INSERT INTO `ipconn_kot1` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,1,'192.168.1.88','9100','',NULL,'kot1'),(2,1,'192.168.1.88','9100','',NULL,'kot1'),(3,1,'192.168.1.88','9100','',NULL,'kot1'),(4,1,'192.168.1.88','9100','',NULL,'kot1');
INSERT INTO `ipconn_kot2` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,1,'192.168.1.89','9100','',NULL,'kot2'),(2,1,'192.168.1.89','9100','',NULL,'kot2'),(3,1,'192.168.1.89','9100','',NULL,'kot2'),(4,1,'192.168.1.89','9100','',NULL,'kot2');
INSERT INTO `ipconn_kot3` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,1,'192.168.1.90','9100','',NULL,'kot3'),(2,1,'192.168.1.90','9100','',NULL,'kot3'),(3,1,'192.168.1.90','9100','',NULL,'kot3'),(4,1,'192.168.1.90','9100','',NULL,'kot3');
INSERT INTO `ipconn_kot4` (`my_row_id`, `_id`, `ipname`, `port`, `status`, `printer_name`, `kot_name`) VALUES (1,1,'192.168.1.91','9100','',NULL,'kot4'),(2,1,'192.168.1.91','9100','',NULL,'kot4'),(3,1,'192.168.1.91','9100','',NULL,'kot4'),(4,1,'192.168.1.91','9100','',NULL,'kot4');
INSERT INTO `itemsort` (`my_row_id`, `_id`, `itemsorttype`) VALUES (1,1,'Sort by Date added'),(2,1,'Sort by Date added'),(3,1,'Sort by Date added');
INSERT INTO `kioskmode` (`my_row_id`, `_id`, `status`) VALUES (1,1,'OFF');
INSERT INTO `kot_print` (`my_row_id`, `_id`, `kot_print_status`) VALUES (1,1,'Yes'),(2,1,'Yes'),(3,1,'Yes');
INSERT INTO `loyalty_points` (`my_row_id`, `_id`, `money`, `point`, `point2`, `money2`) VALUES (1,1,'10','= 1 Point','1 Point =','1'),(2,1,'0','0','0','0'),(3,1,'0','0','0','0'),(4,1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`my_row_id`, `_id`, `status`) VALUES (1,1,'Yes'),(2,1,'no'),(3,1,'no'),(4,1,'no');
INSERT INTO `menulogin_checking` (`my_row_id`, `_id`, `status`) VALUES (1,1,'no'),(2,1,'no'),(3,1,'no');
INSERT INTO `modifiers` (`my_row_id`, `_id`, `modifiername`, `modprice`, `modstockquan`, `modcategory`, `moditemtax`, `modimage`, `mod_image_text`) VALUES (1,1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(2,2,'podi',0,50,'Tiffin','None',NULL,NULL),(3,3,'cheese',15,35,'Tiffin','None',NULL,NULL),(4,4,'butter',10,40,'Tiffin','None',NULL,NULL),(5,5,'omlette',10,50,'Tiffin','None',NULL,NULL),(6,6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(7,7,'potato fry',25,50,'Main course','None',NULL,NULL),(8,8,'chicken fry',40,45,'Main course','None',NULL,NULL),(9,9,'soda',6,50,'Main course','None',NULL,NULL),(10,10,'dessert',15,35,'Main course','None',NULL,NULL),(11,11,'medium',5,50,'Drinks','None',NULL,NULL),(12,12,'large',10,50,'Drinks','None',NULL,NULL),(13,13,'cream',20,50,'Desserts','None',NULL,NULL),(14,14,'chocolate',20,50,'Desserts','None',NULL,NULL),(15,1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(16,2,'podi',0,50,'Tiffin','None',NULL,NULL),(17,3,'cheese',15,35,'Tiffin','None',NULL,NULL),(18,4,'butter',10,40,'Tiffin','None',NULL,NULL),(19,5,'omlette',10,50,'Tiffin','None',NULL,NULL),(20,6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(21,7,'potato fry',25,50,'Main course','None',NULL,NULL),(22,8,'chicken fry',40,45,'Main course','None',NULL,NULL),(23,9,'soda',6,50,'Main course','None',NULL,NULL),(24,10,'dessert',15,35,'Main course','None',NULL,NULL),(25,11,'medium',5,50,'Drinks','None',NULL,NULL),(26,12,'large',10,50,'Drinks','None',NULL,NULL),(27,13,'cream',20,50,'Desserts','None',NULL,NULL),(28,14,'chocolate',20,50,'Desserts','None',NULL,NULL),(29,1,'potato masala',10,50,'Tiffin','None',NULL,NULL),(30,2,'podi',0,50,'Tiffin','None',NULL,NULL),(31,3,'cheese',15,35,'Tiffin','None',NULL,NULL),(32,4,'butter',10,40,'Tiffin','None',NULL,NULL),(33,5,'omlette',10,50,'Tiffin','None',NULL,NULL),(34,6,'cheese dip',20,50,'Snacks','None',NULL,NULL),(35,7,'potato fry',25,50,'Main course','None',NULL,NULL),(36,8,'chicken fry',40,45,'Main course','None',NULL,NULL),(37,9,'soda',6,50,'Main course','None',NULL,NULL),(38,10,'dessert',15,35,'Main course','None',NULL,NULL),(39,11,'medium',5,50,'Drinks','None',NULL,NULL),(40,12,'large',10,50,'Drinks','None',NULL,NULL),(41,13,'cream',20,50,'Desserts','None',NULL,NULL),(42,14,'chocolate',20,50,'Desserts','None',NULL,NULL);
INSERT INTO `name_dept1` (`my_row_id`, `_id`, `dept1_name`) VALUES (1,1,'kot1'),(2,1,'kot1'),(3,1,'kot1'),(4,1,'kot1');
INSERT INTO `name_dept2` (`my_row_id`, `_id`, `dept2_name`) VALUES (1,1,'kot2'),(2,1,'kot2'),(3,1,'kot2'),(4,1,'kot2');
INSERT INTO `name_dept3` (`my_row_id`, `_id`, `dept3_name`) VALUES (1,1,'kot3'),(2,1,'kot3'),(3,1,'kot3'),(4,1,'kot3');
INSERT INTO `name_dept4` (`my_row_id`, `_id`, `dept4_name`) VALUES (1,1,'kot4'),(2,1,'kot4'),(3,1,'kot4'),(4,1,'kot4');
INSERT INTO `ordertaking_server_ip` (`my_row_id`, `_id`, `ipname`, `port`, `status`) VALUES (1,1,'192.168.1.100','8080',''),(2,1,'192.168.1.100','8080',''),(3,1,'192.168.1.100','8080',''),(4,1,'192.168.1.100','8080','');
INSERT INTO `paytmmerchantreg` (`my_row_id`, `_id`, `Account`, `MerchantName`, `guid`, `MID`, `Merchant_key`, `PosID`) VALUES (1,1,'Not_Registered','','','','',''),(2,1,'Not_Registered','','','','',''),(3,1,'Not_Registered','','','','','');
INSERT INTO `phonepe_id` (`my_row_id`, `id`, `merchant_id`) VALUES (1,1,'IVEPOSDYNAMICQRUAT');
INSERT INTO `printer_text_size` (`my_row_id`, `_id`, `type`) VALUES (1,1,'Standard'),(2,1,'Standard'),(3,1,'Standard');
INSERT INTO `printer_type` (`my_row_id`, `_id`, `printer_type`) VALUES (1,1,'Generic'),(2,1,'Generic'),(3,1,'Generic');
INSERT INTO `printerreceiptsize` (`my_row_id`, `_id`, `papersize`) VALUES (1,3,'2 inch'),(2,1,'2 inch'),(3,1,'2 inch');
INSERT INTO `razorpaymerchantreg` (`my_row_id`, `_id`, `account`, `account_id`) VALUES (1,1,'Not_Registered',''),(2,1,'Not_Registered',''),(3,1,'Not_Registered',''),(4,1,'Not_Registered','');
INSERT INTO `restaurant_id` (`my_row_id`, `_id`, `merchant_id`) VALUES (1,1,'0'),(2,1,'0'),(3,1,'0'),(4,1,'0');
INSERT INTO `round_off` (`my_row_id`, `_id`, `round_off_status`) VALUES (1,1,'No'),(2,1,'No'),(3,1,'No');
INSERT INTO `schedule_mail_on_off` (`my_row_id`, `_id`, `status`) VALUES (1,1,'Off'),(2,1,'Off'),(3,1,'Off');
INSERT INTO `schedule_mail_time` (`my_row_id`, `_id`, `time`) VALUES (1,1,'11:30 PM'),(2,1,'11:30 PM'),(3,1,'11:30 PM');
INSERT INTO `stockcontrol` (`my_row_id`, `_id`, `stockcontroltype`) VALUES (1,1,'On'),(2,1,'off'),(3,1,'off');
INSERT INTO `stockreset` (`my_row_id`, `_id`, `stockresettype`) VALUES (1,1,'off'),(2,1,'off'),(3,1,'off');
INSERT INTO `storedays` (`my_row_id`, `_id`, `weekdays`, `weekends`, `swap`) VALUES (1,1,'Monday','0','0'),(2,2,'Tuesday','0','0'),(3,3,'Wednesday','0','0'),(4,4,'Thursday','0','0'),(5,5,'0','Friday','Friday'),(6,6,'0','Saturday','Saturday'),(7,7,'0','Sunday','Sunday'),(8,1,'Monday','0','0'),(9,2,'Tuesday','0','0'),(10,3,'Wednesday','0','0'),(11,4,'Thursday','0','0'),(12,5,'0','Friday','Friday'),(13,6,'0','Saturday','Saturday'),(14,7,'0','Sunday','Sunday'),(15,1,'Monday','0','0'),(16,2,'Tuesday','0','0'),(17,3,'Wednesday','0','0'),(18,4,'Thursday','0','0'),(19,5,'0','Friday','Friday'),(20,6,'0','Saturday','Saturday'),(21,7,'0','Sunday','Sunday');
INSERT INTO `sync_time` (`my_row_id`, `_id`, `last_time`) VALUES (1,1,'05 Apr 18, 05:22 PM'),(2,1,'05 Apr 18, 05:22 PM'),(3,1,'05 Apr 18, 05:22 PM');
INSERT INTO `table_kot` (`my_row_id`, `_id`, `status`) VALUES (1,1,'Lite'),(2,1,'Lite'),(3,1,'Lite'),(4,1,'Lite');
INSERT INTO `taxes` (`my_row_id`, `_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,3,'sgst(6.00%)',6.00,'Globaltax','checked','Dine-in','Takeaway','Home Delivery',''),(2,4,'cgst(6.00%)',6.00,'Globaltax','checked','Dine-in','Takeaway','Home Delivery',''),(3,5,'Tax98(98%)',98.00,'Itemtax','checked','Dine-in','Takeaway','Home Delivery',''),(4,6,'Tax demo 1(20%)',20.00,'Itemtax','checked','Dine-in','Takeaway','Home Delivery','');
INSERT INTO `totaltables` (`my_row_id`, `_id`, `nooftables`) VALUES (1,1,'4'),(2,1,'4'),(3,1,'4');
INSERT INTO `user_privilege` (`my_row_id`, `_id`, `username`, `returns_refunds`, `product_tax`, `reports`, `settings`, `backup`, `customer`, `ingredients`, `subscriptions`) VALUES (1,1,'user1','no','no','no','no','no','no','no','no'),(2,2,'user2','no','no','no','no','no','no','no','no'),(3,3,'user3','no','no','no','no','no','no','no','no'),(4,4,'user4','no','no','no','no','no','no','no','no'),(5,5,'user5','no','no','no','no','no','no','no','no'),(6,6,'user6','no','no','no','no','no','no','no','no'),(7,1,'user1','no','no','no','no','no','no','no','no'),(8,2,'user2','no','no','no','no','no','no','no','no'),(9,3,'user3','no','no','no','no','no','no','no','no'),(10,4,'user4','no','no','no','no','no','no','no','no'),(11,5,'user5','no','no','no','no','no','no','no','no'),(12,6,'user6','no','no','no','no','no','no','no','no'),(13,1,'user1','no','no','no','no','no','no','no','no'),(14,2,'user2','no','no','no','no','no','no','no','no'),(15,3,'user3','no','no','no','no','no','no','no','no'),(16,4,'user4','no','no','no','no','no','no','no','no'),(17,5,'user5','no','no','no','no','no','no','no','no'),(18,6,'user6','no','no','no','no','no','no','no','no');
INSERT INTO `vendor_details` (`my_row_id`, `_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`, `vendor_code`) VALUES (1,1,'chinna','1234567890','sample@gmail.com','aasasd','',''),(2,2,'Raja','7094869231','raja@ivepos.com','','','VEN001'),(3,3,'Raja','70948692313','raja3@ivepos.com','','','VEN002'),(4,4,'Raja','7094869234','raja34@ivepos.com','','','VEN003'),(5,5,'Raja new 4','70948693233','raja76@ivepos.com','','','VEN004');
INSERT INTO `vendor_details_micro` (`my_row_id`, `_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,1,'test','6666666666','chinna@gmail.com','eww','234');
INSERT INTO `vendor_sold_details` (`my_row_id`, `_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,1,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','0','200.0','0','10 Jul 2024','11:26 AM','202407101126',NULL),(2,2,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','20','180.0','20','10 Jul 2024','6:22 AM','202407100622',NULL),(3,3,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','20','160.0','40','10 Jul 2024','7:02 AM','202407100702',NULL),(4,4,'chinna','1234567890','01','448','0','0','0','0','448','08:59 AM','10 Jul 2024','10 Jul 2024','202407100859','20240710','0','448.0','0','10 Jul 2024','08:59 AM','202407100859',NULL),(5,5,'chinna','1234567890','01','448','0','0','0','0','448','08:59 AM','10 Jul 2024','10 Jul 2024','202407100859','20240710','48','400.0','48','10 Jul 2024','9:01 AM','202407100901',NULL),(6,6,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','10','150.0','50','10 Jul 2024','9:16 AM','202407100916',NULL),(7,7,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','10','140.0','60','10 Jul 2024','9:19 AM','202407100919',NULL),(8,8,'chinna','1234567890','01','448','0','0','0','0','448','08:59 AM','10 Jul 2024','10 Jul 2024','202407100859','20240710','10','390.0','58','10 Jul 2024','9:46 AM','202407100946',NULL),(9,9,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','10','130.0','70','10 Jul 2024','9:47 AM','202407100947',NULL),(10,10,'chinna','1234567890','01','448','0','0','0','0','448','08:59 AM','10 Jul 2024','10 Jul 2024','202407100859','20240710','10','380.0','68','10 Jul 2024','10:19 AM','202407101019',NULL),(11,11,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','100','30.0','170','10 Jul 2024','10:35 AM','202407101035',NULL),(12,12,'chinna','1234567890','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','10','20.0','180','13 Jul 2024','9:38 AM','202407130938',NULL),(13,13,'chinna','1234567890','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','0','0.0','0','02 Oct 2024','07:09 PM','202410021909',NULL);
INSERT INTO `vendor_sold_item_details` (`my_row_id`, `_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,1,'chinna','1234567890','KAJU KATALI','2','100','200','','200','0','0','0','0','200','11:26 AM','10 Jul 2024','10 Jul 2024','202407101126','20240710','0','200.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,2,'chinna','1234567890','SAREE_A','08','56','448','01','448','0','0','0','0','448','08:59 AM','10 Jul 2024','10 Jul 2024','202407100859','20240710','0','448.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),(3,3,'chinna','1234567890','Zuvic Sper1 NGrey -01','20.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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),(4,4,'chinna','1234567890','Zuvic Sper1 NGrey -02','21.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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),(5,5,'chinna','1234567890','Zuvic Sper1 NGrey -03','22.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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),(6,6,'chinna','1234567890','Zuvic Sper1 NGrey -11','23.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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),(7,7,'chinna','1234567890','Zuvic Sper1 NGrey -12','24.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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),(8,8,'chinna','1234567890','Zuvic Sper1 NGrey -13','25.0','0','0.0','001','0','0','0','0','0','0','07:09 PM','02 Oct 2024','02 Oct 2024','202410021909','20241002','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);
INSERT INTO `vendor_temp_list_ingredient` (`my_row_id`, `_id`, `vendor_name`, `vend_phon`, `vend_email`, `vend_gst`, `vend_address`, `vend_total_bill_amount`, `paid`, `pending`, `bill_no`) VALUES (1,1,'test','6666666666','chinna@gmail.com','234','eww','1440.0','340.0','1100.0','1');
INSERT INTO `version_control` (`my_row_id`, `_id`, `version`) VALUES (9,1,'12');
INSERT INTO `web_printer` (`my_row_id`, `id`, `printer`, `device_id`, `type`) VALUES (1,1,'RETSOL RTP-80','','Billing'),(2,2,'OneNote (Desktop)','','KOT Counter 1'),(3,3,'Generic / Text Only','','KOT Counter 2');
INSERT INTO `weighing_scale_status` (`my_row_id`, `_id`, `Weighing_Scale_onoff`) VALUES (1,1,'Not Connected'),(2,1,'Not Connected'),(3,1,'Not Connected');
INSERT INTO `working_hours` (`my_row_id`, `_id`, `opening`, `opening_time`, `closing`, `closing_time`, `opening_time_system`, `closing_time_system`) VALUES (1,1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59'),(2,1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59'),(3,1,'Today','12:01 AM','Today','11:59 PM','00:01','23:59');
