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,'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','','','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 (20,'MRS ENTERPRISES','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29EFSPP5031R1ZC',NULL,'NO REFUND,ONLY EXCHANGE WITHIN 3 DAYS , 1YEAR WARRANTY FOR COLOUR SHADE OR SHINK ',NULL,'ARUN ADDA MENS WEAR','','@arun_adda_mens_wear','NO 26/21, BIDADI HOBLI , MANACHANAYAKAHALLI ','VILLAGE , RAMANAGARA -562109');
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'India');
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);
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,'jeans pant',619.05,-1,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','je','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(2,'JEANS PANT',571.43,-1,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','JE','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(3,'cargo pant',571.43,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(4,'BAGGY PANT',809.52,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BA','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(5,'FORMAL PANT',428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(6,'FORMAL COMBO',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(7,'shorts',285.71,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(8,'SHORT',333.33,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(9,'shirt',333.33,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(10,'SHIRT',380.95,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(11,'SHIRT BAGGY',428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','SH','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(12,'breaking slipper',523.89,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','br','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(13,'offer shirt',190.47,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','of','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(14,'offer shirt 5',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','of','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(15,'formal combo',619.05,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fo','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(16,'collar t-shirt-3',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(17,'chirlly -t-s 3',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(18,'chirlly t-1',333.33,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(19,'chirlly v t -1',380.95,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(20,'JOCKET brand',1523.80,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','JO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(21,'JOCKET',1190.47,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','JO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(22,'HOODIES',523.80,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(23,'HOODIES offer',333.33,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(24,'HOODIES COMBO 3',951.24,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(25,'HOODIES h',380.95,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HO','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(26,'OFFER SHIRTS 5',951.42,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','OF','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(27,'OFFER PANT COMBO 3',1618.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','OF','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(28,'birkenstock',619.04,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','bi','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(29,'CROCS',1237.14,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CR','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(30,'BELT',238.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','BE','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(31,'HAT',238.05,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HA','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(32,'WATER PROOF',570.47,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','WA','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(33,'technosports -1',428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(34,'full sleeves t-shirt combo -3',1142.85,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(35,'cotton shorts combo -3',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(36,'cotton shorts -1',333.33,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(37,'chirlly combo',1047.61,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ch','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(38,'usp short',523.80,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','us','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(39,'usp d',476.19,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','us','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(40,'combo j -1',809.52,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(41,'shoes',952.52,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(42,'extra',95.24,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ex','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(43,'crocs',1238.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','cr','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(44,'farmal panth combo -3',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(45,'farmal shirth -3',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fa','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(46,'techno -1',428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(47,'techno pant combo -3',1142.85,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','te','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(48,'full t shirth',428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','fu','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(49,'T SHIRT',238.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','T ','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(50,'us',161.90,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','us','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(51,'shirth combo 3',1142.85,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(52,'belt',238.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','be','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(53,'shirt pant combo',904.76,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(54,'shirt p combo',1142.85,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(55,'hoddi combo',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ho','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(56,'cargo panths 3combo',1523.80,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ca','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(57,'jeans combo',904.76,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','je','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(58,'combo',1047.61,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','co','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(59,'Dalar',238.09,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Da','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(60,'adda',476.19,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ad','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(61,'Adda',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ad','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(62,'Adda 1',1428.57,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','Ad','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(63,'ADDA',1904.76,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AD','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(64,'ADDA 1',2380.95,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AD','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(65,'brand',2857.14,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','br','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(66,'j combo',952.38,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','j ','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(67,'shows',1237.14,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sh','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(68,'cross',1523.80,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','cr','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(69,'net play shirts',951.42,0,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','ne','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(70,'today offer',476.19,1,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','to','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(71,'swimming 1hour',0.00,-1,'None','CGST(2.50%)','',NULL,NULL,NULL,NULL,NULL,'yes','%','0','sw','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.50','','','','','','','','',NULL,NULL,'','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL),(72,'shirt arun adda',385.00,1,'None','CGST(2.50%)','','0','0',NULL,NULL,NULL,'no','%','0','SH','',NULL,NULL,0,'0','0','0',NULL,NULL,NULL,'Unit','2.50','SGST(2.50%)','2.5',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 `itemsort` (`_id`, `itemsorttype`) VALUES (1,'Sort by Date added');
INSERT INTO `kot_print` (`_id`, `kot_print_status`) VALUES (1,'Yes');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[BLOB]');
INSERT INTO `loyalty_points` (`_id`, `money`, `point`, `point2`, `money2`) VALUES (1,'0','0','0','0');
INSERT INTO `loyalty_points_status` (`_id`, `status`) VALUES (1,'no');
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,'Adults','None','',NULL),(2,'podi',0,50,'Adults','None','',NULL),(3,'cheese',15,35,'Adults','None','',NULL),(4,'butter',10,40,'Adults','None','',NULL),(5,'omlette',10,50,'Adults','None','',NULL),(6,'cheese dip',20,50,'Kids','None','',NULL),(7,'potato fry',25,50,'Kids','None','',NULL),(8,'chicken fry',40,45,'Kids','None','',NULL),(9,'soda',6,50,'Kids','None','',NULL),(10,'dessert',15,35,'Kids','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 (21,'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 (4,'CGST(2.5%)',2.50,'Itemtax','checked','General',NULL,'Home Delivery',''),(5,'SGST(2.50%)',2.50,'Itemtax','checked','General',NULL,'Home Delivery','');
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','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 `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');
