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','1','first','0','4',NULL);
INSERT INTO `auto_connect` (`_id`, `auto_connect_status`) VALUES (1,'Yes');
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,'InnerPrinter','00:11:22:33:44:55','ok','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','','','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 (7,'TEA TIME','9884574874',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'',NULL,'No. 2, West Balaji Nagar,','','','Ambattur Redhills road,','Kallilkuppam, Ambattur, Chennai');
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');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'0');
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),(3,'Hot Drinks',NULL,NULL,NULL,0),(4,'Biscuits',NULL,NULL,NULL,0),(5,'Cigrettes',NULL,NULL,NULL,0),(6,'Bajji Bonda',NULL,NULL,NULL,0),(7,'Fresh Juices',NULL,NULL,NULL,0),(8,'Parcel',NULL,NULL,NULL,0),(9,'Snacks',NULL,NULL,NULL,0);
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,'Milk','Dum Tea','.050','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(2,'Milk','Masala Tea','.050','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(3,'Milk','Kashmiri Tea','0','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(4,'Milk','Dum Tea - 1','0','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(5,'Milk','Dum Tea - 2','0','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(6,'Milk','Dum Tea - 3','0','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.0'),(7,'Milk','Dum Tea - 4','0','10','26 May 2024','202405261540','03:40:49 pm','1540','202405261543','L','90.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`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'Masala Vadai',10.00,-296,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ma','1',NULL,NULL,796,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(2,'Medhu Vadai',10.00,-1757,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Me','2',NULL,NULL,2257,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(3,'Onion Bonda',10.00,-691,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','On','3',NULL,NULL,1194,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(4,'Samosa',10.00,-3688,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Sa','4',NULL,NULL,4186,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(5,'Vazhakkai Bajji',10.00,-2410,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Va','5',NULL,NULL,2910,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(6,'Milagai Bajji',10.00,205,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Mi','6',NULL,NULL,295,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(7,'Ulundhu Bonda',10.00,-965,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ul','7',NULL,NULL,1465,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(8,'Masala Bonda',10.00,278,'Bajji Bonda','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ma','8',NULL,NULL,219,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(9,'Butter Biscuit - 2 Rs',2.00,-1025,'Biscuits','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Bu','9',NULL,NULL,1525,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(10,'Butter Biscuit - 5 Rs',5.00,-860,'Biscuits','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Bu','10',NULL,NULL,1360,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(11,'Rusk',3.00,23,'Biscuits','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ru','11',NULL,NULL,477,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(12,'Cake - 10 Rs',10.00,192,'Biscuits','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ca','12',NULL,NULL,308,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(13,'Banana Cake',10.00,463,'Biscuits','','','0',NULL,NULL,NULL,NULL,'no','%','0','Ba','13',NULL,NULL,37,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(14,'Cake - 15 Rs',15.00,500,'Biscuits and Cakes','','','0',NULL,NULL,NULL,NULL,'no','%','0','Ca','14',NULL,NULL,0,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(15,'Roll Cake - 20 Rs',20.00,386,'Biscuits','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','Ro','15',NULL,NULL,114,NULL,NULL,NULL,'',NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,'','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),