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,'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);
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,'Retail');
INSERT INTO `billingtype` (`_id`, `billingtype_type`) VALUES (1,'General');
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,'Paytm','','','Not Activated'),(7,'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 (6,'Intuition','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'Thank you ',NULL,'','','www.intuitionsoftwares.com','','');
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 `discount_details` (`_id`, `disc_code`, `disc_value`, `disc_type`) VALUES (1,'Discount10','10','%'),(2,'Discount20','20','%'),(3,'Duscount30','30','%');
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),(3,'chocolate',NULL,NULL,NULL,NULL),(4,'wholesale',NULL,NULL,NULL,NULL),(5,'helmet',NULL,NULL,NULL,0),(6,'jackets',NULL,NULL,NULL,0),(7,'pants',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,'Lotion ','Gold Facial','30','30.00','21 Aug 2024','202408211506','03:06:16 pm','1506','202408211506','ml','1000.0'),(2,'Lotion ','Tan removal','0','30.00','21 Aug 2024','202408211515','03:15:45 pm','1515','202408211515','Kg','1090.0'),(3,'Tan removal lotion','Tan removal','25','0','21 Aug 2024','202408211517','03:17:01 pm','1517','202408211517','ml','1000.0'),(4,'cleanser','Gold Facial','20','20.00','21 Aug 2024','202408211518','03:18:33 pm','1518','202408211518','ml','2000.0'),(5,'cleanser','Tan removal','20','20.00','21 Aug 2024','202408211518','03:18:33 pm','1518','202408211518','ml','2000.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,'Lotion ','10','1000','30.00','ml','1500',NULL,'202408211506','21 Aug 2024','1506','03:06:20 pm','202408211516','1500','1090.0','',NULL,NULL,NULL,NULL,NULL,NULL,'1500',NULL),(2,'Tan removal lotion','10','1000','0','ml','2500',NULL,'202408211517','21 Aug 2024','1517','03:17:03 pm','202408211517','2500','1000.0','',NULL,NULL,NULL,NULL,NULL,NULL,'2500',NULL),(3,'cleanser','20','2000','20.00','ml','750',NULL,'202408211518','21 Aug 2024','1518','03:18:37 pm','202408211518','750','2000.0','',NULL,NULL,NULL,NULL,NULL,NULL,'750',NULL);
INSERT INTO `ingredients_item_selection_temp` (`_id`, `itemname`, `qty_temp`, `qty_temp_unit`, `qty`) VALUES (1,'Gold Facial','30','ml','yes'),(2,'Tan removal','0','Kg',NULL);
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`, `is_veg`, `packing_charges`, `v1_oofstock`, `v2_oofstock`, `v3_oofstock`, `v4_oofstock`, `v5_oofstock`) VALUES (1,'Milk 250ml',20.00,-3,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(2,'Milk 500ml',40.00,-3,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(3,'Milk 1000ml',80.00,-2,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(4,'Cow Milk 250ml',18.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(5,'Cow milk 500 ml',35.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(6,'Curd 250gms',23.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cu','',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),(7,'Curd 500gms',45.00,-1,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cu','',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),(8,'Curd 1000kg',90.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cu','',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),(9,'Paneer 125gms',65.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(10,'Paneer 250gms',125.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(11,'Paneer 500gms',250.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(12,'Paneer 1000kg',500.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(13,'Ghee 100gms',80.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gh','',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),(14,'Ghee 250gms',190.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gh','',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),(15,'Ghee 500gms',380.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gh','',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),(16,'Ghee 1kg',760.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Gh','',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),(17,'Cow ghee 100gms',75.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(18,'Cow ghee 250gms',180.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(19,'Cow ghee 500gms',360.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(20,'Cow ghee 1kg',720.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(21,'Khowa 125gms',50.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Kh','',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),(22,'Khowa 250gms',100.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Kh','',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),(23,'Khowa 500gms',200.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Kh','',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),(24,'Khowa 1kg',400.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Kh','',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),(25,'Cream or Butter 125gms',65.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',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),(26,'Cream or Butter 250gms',130.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',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),(27,'Cream or Butter 500gms',260.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',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),(28,'Amul Butter 500gms',285.00,0,'Dairy products','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Am','',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),(29,'Milk Bread 50',50.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(30,'milk Bread 40',40.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','mi','',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),(31,'Brown Bread',45.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Br','',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),(32,'Round Bun',10.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ro','',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),(33,'Toast',35.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','To','',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),(34,'Cup Cakes',60.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cu','',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),(35,'Pav Bun',15.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pa','',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),(36,'Cream Bun RK',15.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',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),(37,'Marino Osmania',40.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(38,'Cakes Sliced',10.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','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),(39,'Cake Fruit cake',25.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','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),(40,'Cream bun Marino',10.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Cr','',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),(41,'Sweet Bun',25.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sw','',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),(42,'Bread Marino',30.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Br','',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),(43,'Marino Rusk',35.00,0,'Bread','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(44,'Ragi Rafils',5.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','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),(45,'Peanut chekky small',5.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','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),(46,'Peanut chekky Large',10.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','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),(47,'Millets Biscults',120.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(48,'Millet Laddu',150.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Mi','',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),(49,'Khari',40.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Kh','',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),(50,'Sprouts',10.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',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),(51,'Skankarpally',20.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sk','',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),(52,'Honey 250gms',180.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ho','',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),(53,'Honey 500gms',360.00,0,'Snacks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ho','',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),(54,'Sprite 20',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',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),(55,'Thumbs Up 20',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(56,'Fanto 20',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Fa','',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),(57,'Limca 20',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Li','',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),(58,'Cocacola 20',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Co','',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),(59,'Mazza 25',25.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(60,'Pulpy Orange 25',25.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pu','',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),(61,'Mazza Tettra Pack',10.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(62,'Thick shake Vanilla',35.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(63,'Thick shake Strawberry',35.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(64,'Badam Milk',35.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ba','',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),(65,'Golli soda',30.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Go','',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),(66,'Mazza small',40.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(67,'Sprite 750ml',45.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',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),(68,'Thumps up 750ml',45.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(69,'Pulpy Orange 500ml',35.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Pu','',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),(70,'Kinley Soda 750ml',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ki','',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),(71,'Sprite 1lt',70.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',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),(72,'Thumps up 1lt',70.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(73,'Mazza 1.5Lt',90.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ma','',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),(74,'Water 500ml',10.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Wa','',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),(75,'Water 1lt',20.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Wa','',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),(76,'Water 2lt',30.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Wa','',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),(77,'Thumps up 2.25lt',100.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Th','',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),(78,'Sprite 2.25lt',100.00,0,'Drinks','','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Sp','',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),(79,'Nuts milk bar 250gm',200.00,100,'chocolate','None','','0','0',NULL,NULL,NULL,'no','%','0','NU','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Weight',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),(80,'item 1 ',200.00,50,'wholesale','None','','0','0',NULL,NULL,NULL,'no','%','0','IT','',NULL,NULL,0,'0','0','0','',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,'sona masoori raw rice 1kg','50.0','50.0','50.0','3.0','150.0','',''),(2,'tata urad dal whole white 1kg','90.0','90.0','90.0','5.0','450.0','',''),(3,'fig fruit kg','50.0','50.0','50.0','5.0','250.0','',''),(4,'beans kg','60.0','60.0','60.0','2.0','120.0','',''),(5,'tata tea premium 250g','100.0','100.0','100.0','10.0','1000.0','',''),(6,'Curd 1000kg','50.0','50.0','50.0','10.0','500.0','',''),(7,'Paneer 125gms','20.0','20.0','20.0','10.0','200.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 Point','1 Point =','100');
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,'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,'wiseposplus');
INSERT INTO `printerreceiptsize` (`_id`, `papersize`) VALUES (5,'3 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,'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 `taxes` (`_id`, `taxname`, `value`, `taxtype`, `checked`, `tax1`, `tax2`, `tax3`, `hsn_code`) VALUES (6,'GST(18.00%)',18.00,'Itemtax','','','','','');
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','yes','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,'Abcd ','1234567890','','',''),(2,'Test Traders ','9876543210','','',''),(3,'Fruit Merchant ','9632581470','','Bangalore ',''),(4,'IVEPOS ','3023023021','','Whitefield ',''),(5,'AAAA','9876543210','','','');
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,'Abcd ','1234567890','','200.0','0','0','0','0','200.0','11:59 am','03 Jul 2024','03 Jul 2024','202407031159','20240703','100','100.0','100','03 Jul 2024','11:59 am','202407031159',''),(2,'Test Traders ','9876543210','','450.0','0','0','0','0','450.0','12:55 pm','17 Jul 2024','17 Jul 2024','202407171255','20240717','450','0.0','450','17 Jul 2024','12:55 pm','202407171255',''),(3,'Fruit Merchant ','9632581470','','250.0','0','0','0','0','250.0','12:56 pm','17 Jul 2024','17 Jul 2024','202407171256','20240717','200','50.0','200','17 Jul 2024','12:56 pm','202407171256',''),(4,'Abc Traders ','1234567890','','120.0','0','0','0','0','120.0','12:59 pm','17 Jul 2024','17 Jul 2024','202407171259','20240717','50','70.0','50','17 Jul 2024','12:59 pm','202407171259',''),(5,'Abcd ','1234567890','','150','0','0','0','0','150','10:02 AM','17 Jul 2024','17 Jul 2024','202407171002','20240717','150','0.0','150','17 Jul 2024','10:02 AM','202407171002',NULL),(6,'IVEPOS ','3023023021','','1000.0','0','0','0','0','1000.0','03:41 pm','17 Jul 2024','17 Jul 2024','202407171541','20240717','500','500.0','500','17 Jul 2024','03:41 pm','202407171541',''),(7,'Abcd ','1234567890','','750.0','0','0','0','0','750.0','02:24 pm','23 Oct 2024','23 Oct 2024','202410231424','20241023','500','250.0','500','23 Oct 2024','02:24 pm','202410231424',''),(8,'Abcd ','1234567890','','10000.0','0','0','0','0','10000.0','02:51 pm','23 Oct 2024','23 Oct 2024','202410231451','20241023','500','9500.0','500','23 Oct 2024','02:51 pm','202410231451',''),(9,'Abcd ','1234567890','','6000.0','0','0','0','0','6000.0','03:11 pm','23 Oct 2024','23 Oct 2024','202410231511','20241023','3000','3000.0','3000','23 Oct 2024','03:11 pm','202410231511',''),(10,'IVEPOS ','3023023021','','800.0','0','0','0','0','800.0','04:22 pm','23 Oct 2024','23 Oct 2024','202410231622','20241023','3000','-2200.0','3000','23 Oct 2024','04:22 pm','202410231622','');
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,'Abcd ','1234567890','sona masoori raw rice 1kg','5','40','200.0','','200.0','0','0','0','0','200.0','11:59 am','03 Jul 2024','03 Jul 2024','202407031159','20240703','100','100.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,'Abc Traders ','1234567890','sona masoori raw rice 1kg','3','50','150.0','','150.0','0','0','0','0','150.0','12:54 pm','17 Jul 2024','17 Jul 2024','202407171254','20240717','150','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),(3,'Test Traders ','9876543210','tata urad dal whole white 1kg','5','90','450.0','','450.0','0','0','0','0','450.0','12:55 pm','17 Jul 2024','17 Jul 2024','202407171255','20240717','450','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,'Fruit Merchant ','9632581470','fig fruit kg','5','50','250.0','','250.0','0','0','0','0','250.0','12:56 pm','17 Jul 2024','17 Jul 2024','202407171256','20240717','200','50.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,'Abc Traders ','1234567890','beans kg','2','60','120.0','','120.0','0','0','0','0','120.0','12:59 pm','17 Jul 2024','17 Jul 2024','202407171259','20240717','50','70.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,'Abcd ','1234567890','sona masoori raw rice 1kg','03','50','150','','150','0','0','0','0','150','10:02 AM','17 Jul 2024','17 Jul 2024','202407171002','20240717','150','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,'Abcd ','1234567890','Milk 250ml','10','25','250.0','','750.0','0','0','0','0','750.0','02:24 pm','23 Oct 2024','23 Oct 2024','202410231424','20241023','500','250.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,'Abcd ','1234567890','Milk 500ml','50','10','500.0','','750.0','0','0','0','0','750.0','02:24 pm','23 Oct 2024','23 Oct 2024','202410231424','20241023','500','250.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),(9,'Abcd ','1234567890','Cow Milk 250ml','100','100','10000.0','','10000.0','0','0','0','0','10000.0','02:51 pm','23 Oct 2024','23 Oct 2024','202410231451','20241023','500','9500.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),(10,'Abcd ','1234567890','Cow Milk 250ml','10','100','1000.0','','6000.0','0','0','0','0','6000.0','03:11 pm','23 Oct 2024','23 Oct 2024','202410231511','20241023','3000','3000.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),(11,'Abcd ','1234567890','Curd 250gms','100','50','5000.0','','6000.0','0','0','0','0','6000.0','03:11 pm','23 Oct 2024','23 Oct 2024','202410231511','20241023','3000','3000.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),(12,'IVEPOS ','3023023021','Curd 500gms','10','10','100.0','','800.0','0','0','0','0','800.0','04:22 pm','23 Oct 2024','23 Oct 2024','202410231622','20241023','3000','-2200.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),(13,'IVEPOS ','3023023021','Curd 1000kg','10','50','500.0','','800.0','0','0','0','0','800.0','04:22 pm','23 Oct 2024','23 Oct 2024','202410231622','20241023','3000','-2200.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),(14,'IVEPOS ','3023023021','Paneer 125gms','10','20','200.0','','800.0','0','0','0','0','800.0','04:22 pm','23 Oct 2024','23 Oct 2024','202410231622','20241023','3000','-2200.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,'Abc Traders ','1234567890','','','Bangalore ','0.0','0.0','0.0','0'),(2,'Abc Traders ','1234567890','','','Bangalore ','0.0','0.0','0.0','0'),(3,'Test Traders ','9876543210','','','','0.0','0.0','0.0','0'),(4,'Abc Traders ','1234567890','','','Bangalore ','150.0','150.0','0.0','1'),(5,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(12,'Abc Traders ','1234567890','','','Bangalore ','270.0','200.0','70.0','2'),(13,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(14,'Fruit Merchant ','9632581470','','','Bangalore ','250.0','200.0','50.0','1'),(22,'Abc Traders ','1234567890','','','Bangalore ','270.0','200.0','70.0','2'),(23,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(24,'Fruit Merchant ','9632581470','','','Bangalore ','250.0','200.0','50.0','1'),(25,'IVEPOS ','3023023021','','','Whitefield ','1000.0','500.0','500.0','1'),(26,'Abc Traders ','1234567890','','','Bangalore ','270.0','200.0','70.0','2'),(27,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(28,'Fruit Merchant ','9632581470','','','Bangalore ','250.0','200.0','50.0','1'),(29,'IVEPOS ','3023023021','','','Whitefield ','1000.0','500.0','500.0','1'),(30,'Abcd ','1234567890','','','','11100.0','1250.0','9850.0','4'),(31,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(32,'Fruit Merchant ','9632581470','','','Bangalore ','250.0','200.0','50.0','1'),(33,'IVEPOS ','3023023021','','','Whitefield ','1000.0','500.0','500.0','1'),(34,'AAAA','9876543210','','','','0.0','0.0','0.0','0'),(35,'Abcd ','1234567890','','','','17100.0','4250.0','12850.0','5'),(36,'Test Traders ','9876543210','','','','450.0','450.0','0.0','1'),(37,'Fruit Merchant ','9632581470','','','Bangalore ','250.0','200.0','50.0','1'),(38,'IVEPOS ','3023023021','','','Whitefield ','1800.0','3500.0','-1700.0','2'),(39,'AAAA','9876543210','','','','0.0','0.0','0.0','0');
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');
