INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL);
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,'Tomato Country 1KG',45.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','To','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(2,'Onion 1KG',84.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','On','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(3,'Tomato Banglore 1KG',50.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','To','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(4,'Potato 1KG',67.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Po','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(5,'Garlic 1KG',500.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ga','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(6,'Sambar Onion 1KG',110.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Sa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(7,'Chilli 1KG',83.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(8,'Beans Ooty 1KG',122.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Be','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(9,'Beans Cluster 1KG',122.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Be','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(10,'Ridge Gourd 1KG',84.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ri','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(11,'Raw Banana pcs',16.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ra','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(12,'Drumstick 1KG',89.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Dr','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(13,'Cauliflower pcs',40.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(14,'Apple Indian 1KG',322.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ap','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(15,'NewZealand Gala 1KG',433.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Ne','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(16,'Pomegranate 1KG',400.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Po','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(17,'Pears Imported Pack',88.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Pe','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(18,'Red Globe Grapes Pack',210.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Re','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(19,'Orange Imported 1KG',211.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Or','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Weight','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(20,'Plums Indian Pack',100.00,100,'None','','',NULL,NULL,NULL,NULL,NULL,'yes','%','10','Pl','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','','','','','','','','','',NULL,NULL,NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL);
