INSERT INTO `account_selection` (`_id`, `selection`) VALUES (1,'Retail');
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,'Off');
INSERT INTO `alaramtime` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `asd1` (`_id`, `pName`, `pDate`, `image`, `floor`, `position`, `max`, `present`) VALUES (1,'','1','','first','0','4',NULL),(2,'','2','','first','0','4',NULL),(3,'','3','','first','0','4',NULL);
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,'Fast food');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'General');
INSERT INTO `btconn` (`_id`, `name`, `address`, `status`, `device`) VALUES (1,'my printer','88:68:2E:00:05:97','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
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 `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),(6,'Cakes',NULL,NULL,NULL,NULL),(7,'Cookies',NULL,NULL,NULL,NULL),(8,'Puffs',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,'Maida','Vanilla cake 1kg','0.250','70','04 Dec 2024','202412041045','10:45:12 am','1045','202412041045','Kg','30.0'),(2,'Maida','veg puff','0.100','70','04 Dec 2024','202412041045','10:45:12 am','1045','202412041045','Kg','30.0'),(3,'Maida','egg puff','0','70','04 Dec 2024','202412041045','10:45:12 am','1045','202412041045','Kg','30.0'),(4,'Maida','Pineapple 1kg','0','70','04 Dec 2024','202412041045','10:45:12 am','1045','202412041045','Kg','30.0'),(5,'Maida','Coconut cookies 250gm','0','70','04 Dec 2024','202412041045','10:45:12 am','1045','202412041045','Kg','30.0'),(6,'Sugar','Vanilla cake 1kg','0.250','80','04 Dec 2024','202412041046','10:46:17 am','1046','202412041046','Kg','20.0'),(7,'Sugar','Pineapple 1kg','0','80','04 Dec 2024','202412041046','10:46:17 am','1046','202412041046','Kg','20.0'),(8,'Sugar','Coconut cookies 250gm','0','80','04 Dec 2024','202412041046','10:46:17 am','1046','202412041046','Kg','20.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,'Maida','5','100','70','Kg','0',NULL,'202412041045','04 Dec 2024','1045','10:45:14 am','202412041045','0','30.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL),(2,'Sugar','5','100','80','Kg','0',NULL,'202412041046','04 Dec 2024','1046','10:46:18 am','202412041046','0','20.0','',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'Vanilla cake 1kg','0','Kg','yes'),(2,'veg puff','0','Kg','yes'),(3,'egg puff','0','Kg','yes'),(4,'Pineapple 1kg','0','Kg','yes'),(5,'Coconut cookies 250gm','0','Kg','yes');
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','',NULL);
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 (29,'Vanilla cake 1kg',500.00,0,'Cakes','None','','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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Pineapple 1kg',600.00,0,'Cakes','None','','0','0',NULL,NULL,NULL,'no','%','0','PI','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL),(31,'veg puff',40.00,0,'Puffs','None','','0','0',NULL,NULL,NULL,'no','%','0','VE','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL),(32,'egg puff',40.00,0,'Puffs','None','','0','0',NULL,NULL,NULL,'no','%','0','EG','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',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,NULL,NULL,NULL,NULL),(33,'Coconut cookies 250gm',200.00,0,'Cookies','None','','0','0',NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit',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,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,'Pineapple 1kg','500.0','500.0','500.0','20.0','10000.0','',''),(2,'egg puff','25.0','25.0','25.0','50.0','1250.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,'Hair','None','',NULL),(2,'podi',0,50,'Hair','None','',NULL),(3,'cheese',15,35,'Hair','None','',NULL),(4,'butter',10,40,'Hair','None','',NULL),(5,'omlette',10,50,'Hair','None','',NULL),(6,'cheese dip',20,50,'Skin','None','',NULL),(7,'potato fry',25,50,'Body','None','',NULL),(8,'chicken fry',40,45,'Body','None','',NULL),(9,'soda',6,50,'Body','None','',NULL),(10,'dessert',15,35,'Body','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,'On');
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 `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (1,'vat',5.50,'Globaltax','','dine_in','takeaway','homedelivery',NULL),(2,'cgst(9%)',9.00,'Itemtax','','dine_in','takeaway','homedelivery','');
INSERT INTO `totaltables` (`_id`, `nooftables`) VALUES (1,'3');
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 `vendor_details` (`_id`, `vendor_name`, `vendor_phoneno`, `vendor_email`, `vendor_address`, `vendor_gst`) VALUES (1,'phani','9739981733','','','');
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,'phani','9739981733','1234','10000.0','0','0','0','0','10000.0','10:37 am','04 Dec 2024','04 Dec 2024','202412041037','20241204','5000','5000.0','5000','04 Dec 2024','10:37 am','202412041037',''),(2,'phani','9739981733','6754','1650.0','0','0','0','0','1650.0','12:21 pm','07 Dec 2024','07 Dec 2024','202412071221','20241207','1500','150.0','1500','07 Dec 2024','12:21 pm','202412071221',''),(3,'phani','9739981733','6754','1650.0','0','0','0','0','1650.0','12:21 pm','07 Dec 2024','07 Dec 2024','202412071221','20241207','150','0.0','1650.0','07 Dec 2024','12:22 pm','202412071222','');
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,'phani','9739981733','Pineapple 1kg','20','500','10000.0','1234','10000.0','0','0','0','0','10000.0','10:37 am','04 Dec 2024','04 Dec 2024','202412041037','20241204','5000','5000.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),(57,'phani','9739981733','Pineapple 1kg','20','500','10000.0','1234','10000.0','0','0','0','0','10000.0','10:37 am','04 Dec 2024','04 Dec 2024','202412041037','20241204','5000','5000.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),(58,'phani','9739981733','veg puff','20','20','400.0','6754','1650.0','0','0','0','0','1650.0','12:21 pm','07 Dec 2024','07 Dec 2024','202412071221','20241207','1500','150.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,'phani','9739981733','egg puff','50','25','1250.0','6754','1650.0','0','0','0','0','1650.0','12:21 pm','07 Dec 2024','07 Dec 2024','202412071221','20241207','1500','150.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,'phani','9739981733','','','','10000.0','5000.0','5000.0','1'),(2,'phani','9739981733','','','','11650.0','6500.0','5150.0','2');
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:00','23:59');
