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 `email_setup` (`_id`, `username`, `password`, `client`) VALUES (1,'punit.kumar.r117@gmail.com','punith1653','Office365');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `ezetapmerchantreg` (`_id`, `account`, `userid`, `password`) VALUES (1,'Not_Registered','','');
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 `ladmin` (`_id`, `username`, `password`, `name`) VALUES (1,'ladmin','1234','ladmin');
INSERT INTO `login` (`ID`, `USERNAME`, `PASSWORD`, `name`) VALUES (1,'admin','0000','madmin');
INSERT INTO `loginuser` (`_id`, `username`, `password`) VALUES (9,'admin','0000'),(12,'user1','1653'),(13,'admin','0000'),(14,'admin','0000'),(15,'ladmin','1234'),(16,'ladmin','1234'),(17,'admin','0000'),(18,'admin','0000'),(19,'admin','0000'),(20,'admin','0000'),(21,'admin','0000'),(22,'admin','0000'),(23,'admin','0000'),(24,'admin','0000'),(25,'admin','0000'),(26,'admin','0000'),(27,'ladmin','1234'),(28,'user1','1653'),(29,'admin','0000'),(30,'user1','1653'),(31,'ladmin','1234'),(32,'user1','1653'),(33,'admin','1358'),(34,'admin','1358'),(35,'admin','1358'),(36,'admin','1358'),(37,'admin','1358'),(38,'admin','1358'),(39,'user1','1653'),(40,'admin','1358'),(41,'user1','1653'),(42,'user1','1653'),(43,'user1','1653'),(44,'user1','1653'),(45,'user1','1653'),(46,'user1','1653'),(47,'user1','1111'),(48,'user2','2222'),(49,'user2','2222'),(50,'user2','2222'),(51,'user2','2222'),(52,'user2','2222'),(53,'user2','2222'),(54,'user2','2222'),(55,'admin','1358'),(56,'user2','2222'),(59,'user2','2222'),(60,'user2','2222'),(61,'admin','1358'),(62,'user2','2222'),(63,'user2','2222'),(64,'user2','2222'),(65,'user2','2222'),(66,'user2','2222'),(67,'user2','2222'),(70,'user2','2222'),(71,'user2','2222'),(72,'user2','2222'),(73,'user2','2222'),(74,'user2','2222'),(75,'user2','2222'),(76,'user2','2222'),(77,'user2','2222'),(78,'user2','2222'),(79,'user2','2222'),(81,'user2','2222'),(82,'user2','2222'),(83,'user2','2222'),(86,'user2','2222'),(87,'user2','2222'),(88,'user2','2222'),(91,'user2','2222'),(92,'user2','2222'),(93,'admin','0000'),(94,'user1','1111'),(95,'user2','2222'),(96,'user2','2222'),(97,'user2','2222'),(98,'user2','2222'),(99,'user2','2222'),(100,'user2','2222'),(101,'user2','2222'),(102,'user2','2222'),(103,'user2','2222'),(104,'user2','2222'),(105,'user2','2222'),(106,'user2','2222'),(107,'user2','2222'),(108,'user2','2222'),(109,'user2','2222'),(110,'user2','2222'),(111,'user2','2222'),(112,'user2','2222'),(113,'admin','0000'),(121,'user2','2222'),(122,'user2','2222'),(123,'user2','2222'),(124,'user2','2222'),(138,'user1','1111'),(139,'user2','2222'),(141,'user2','2222'),(142,'user2','2222'),(143,'user2','2222'),(144,'user2','2222'),(145,'user2','2222'),(146,'user2','2222'),(147,'user1','1111'),(152,'user1','1111'),(153,'user1','1111'),(154,'user2','2222'),(155,'user2','2222'),(156,'user2','2222'),(157,'user2','2222'),(158,'user2','2222'),(159,'user2','2222'),(160,'user2','2222'),(161,'user2','2222'),(162,'user2','2222'),(163,'user2','2222'),(164,'user2','2222'),(165,'user2','2222'),(166,'user2','2222'),(167,'user2','2222'),(168,'user2','2222'),(169,'user2','2222'),(170,'user2','2222'),(171,'user2','2222'),(172,'user2','2222'),(173,'user2','2222'),(174,'user2','2222'),(175,'admin','0000'),(176,'user2','2222'),(177,'user2','2222'),(178,'user2','2222'),(179,'user2','2222'),(180,'user2','2222'),(181,'user2','2222'),(182,'user2','2222'),(183,'user2','2222'),(184,'user2','2222'),(185,'user2','2222'),(186,'user2','2222'),(187,'user2','2222'),(188,'user2','2222'),(189,'user2','2222'),(190,'user2','2222'),(191,'user2','2222'),(192,'user2','2222'),(193,'user2','2222'),(194,'user2','2222'),(195,'user2','2222'),(196,'user2','2222'),(197,'user2','2222'),(198,'user2','2222'),(199,'user2','2222'),(200,'user2','2222'),(201,'user2','2222'),(202,'user2','2222'),(203,'user2','2222'),(204,'user2','2222'),(205,'user2','2222'),(206,'user2','2222'),(207,'user2','2222'),(208,'admin','0000'),(209,'user1','1111'),(210,'user2','2222'),(211,'user2','2222'),(212,'user2','2222'),(213,'user2','2222'),(214,'user2','2222'),(215,'user2','2222'),(216,'user2','2222'),(217,'user2','2222'),(218,'user2','2222'),(219,'admin','1653'),(220,'user2','2222'),(221,'user2','2222'),(222,'user2','2222'),(223,'user2','2222'),(224,'user1','1111'),(225,'user1','1111'),(226,'admin','1653'),(227,'admin','1653'),(228,'user1','1111'),(229,'user1','1111'),(230,'user1','1111'),(231,'user1','1111'),(232,'user2','2222'),(233,'user1','1111'),(235,'user1','1111'),(236,'user1','1111'),(237,'user1','1111'),(238,'user1','1111'),(239,'user1','1111'),(241,'admin','1653'),(242,'user2','2222'),(243,'user1','1111'),(244,'user1','1111'),(245,'user1','1111'),(246,'user1','1111'),(247,'admin','1653'),(248,'user1','1111'),(249,'user1','1111'),(250,'user1','1111'),(251,'user1','1111'),(252,'user1','1111'),(253,'user1','1111'),(254,'user1','1111'),(255,'user1','1111'),(256,'user1','1111'),(257,'user1','1111'),(258,'user1','1111'),(259,'user1','1111'),(260,'user1','1111'),(261,'user1','1111'),(262,'user1','1111'),(263,'user1','1111'),(264,'user1','1111'),(265,'user1','1111'),(266,'user1','1111'),(267,'admin','1653'),(268,'user1','1111'),(269,'user1','1111'),(270,'user1','1111'),(271,'user1','1111'),(272,'user1','1111'),(273,'user1','1111'),(274,'user1','1111'),(275,'admin','1653'),(276,'user1','1111'),(277,'user1','1111'),(278,'user1','1111'),(279,'admin','1653'),(280,'user1','1111'),(281,'user1','1111'),(282,'user1','1111'),(283,'user1','1111'),(284,'user1','1111'),(285,'user1','1111'),(286,'user1','1111'),(287,'user1','1111'),(288,'user1','1111'),(289,'user1','1111'),(290,'user1','1111'),(291,'user1','1111'),(292,'user1','1111'),(293,'user1','1111'),(294,'user1','1111'),(295,'user1','1111'),(296,'user1','1111'),(297,'user1','1111'),(298,'user1','1111'),(299,'user1','1111'),(300,'user1','1111'),(301,'user1','1111'),(302,'user1','1111'),(303,'user1','1111'),(304,'user1','1111'),(305,'user1','1111'),(306,'user1','1111'),(307,'user1','1111'),(308,'user1','1111'),(309,'user1','1111'),(310,'user1','1111'),(311,'user1','1111'),(312,'user1','1111'),(313,'user1','1111'),(314,'user1','1111'),(315,'user1','1111'),(316,'user1','1111'),(317,'user1','1111'),(318,'user1','1111'),(319,'user1','1111'),(320,'user1','1111'),(321,'user1','1111'),(322,'user1','1111'),(323,'user1','1111'),(324,'user1','1111'),(325,'user1','1111'),(326,'user1','1111'),(327,'user1','1111'),(328,'user1','1111'),(329,'user1','1111'),(330,'user1','1111'),(331,'user1','1111'),(332,'user1','1111'),(333,'user1','1111'),(334,'user1','1111'),(335,'user1','1111'),(336,'user1','1111'),(337,'user1','1111'),(338,'user1','1111'),(339,'user1','1111'),(340,'user1','1111'),(341,'user1','1111'),(342,'user1','1111'),(343,'user1','1111'),(344,'user1','1111'),(345,'user1','1111'),(346,'user1','1111'),(347,'user1','1111'),(348,'user1','1111'),(349,'user1','1111'),(350,'user1','1111'),(351,'user1','1111'),(352,'user1','1111'),(353,'user1','1111'),(354,'user1','1111'),(355,'user1','1111'),(356,'user1','1111'),(357,'user1','1111'),(358,'user1','1111'),(359,'user1','1111'),(360,'user1','1111'),(361,'user1','1111'),(362,'user1','1111'),(363,'user1','1111'),(364,'ladmin','1234'),(365,'user1','1111'),(366,'user1','1111'),(367,'user1','1111'),(368,'user1','1111'),(369,'user1','1111'),(370,'user1','1111'),(371,'user1','1111'),(372,'admin','0000'),(373,'admin','0000'),(374,'admin','0000'),(375,'admin','0000'),(376,'admin','0000'),(377,'admin','0000'),(378,'admin','0000'),(379,'admin','0000'),(380,'admin','0000'),(381,'admin','0000'),(382,'admin','0000'),(383,'user1','1111'),(384,'user1','1111'),(385,'user1','1111');
INSERT INTO `logo` (`_id`, `companylogo`) VALUES (1,'[encoded data, 60072 characters]');
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 `mobikwikmerchantreg` (`_id`, `Account`, `Merchant_name`, `Mid_otp`, `Secretkey_otp`, `Mid_debit`, `Secretkey_debit`) VALUES (1,'Not_Registered','','','','','');
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 `user1` (`_id`, `name`, `username`, `password`) VALUES (1,'User1','user1','1111');
INSERT INTO `user2` (`_id`, `name`, `username`, `password`) VALUES (1,'User2','user2','2222');
INSERT INTO `user3` (`_id`, `name`, `username`, `password`) VALUES (1,'User3','user3','3333');
INSERT INTO `user4` (`_id`, `name`, `username`, `password`) VALUES (1,'User4','user4','4444');
INSERT INTO `user5` (`_id`, `name`, `username`, `password`) VALUES (1,'User5','user5','5555');
INSERT INTO `user6` (`_id`, `name`, `username`, `password`) VALUES (1,'User6','user6','6666');
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 `userlogin_checking` (`_id`, `username`, `password`, `name`) VALUES (4,NULL,NULL,'madmin'),(7,NULL,NULL,'user1'),(8,NULL,NULL,'madmin'),(10,NULL,'0000','madmin'),(11,NULL,NULL,'ladmin'),(12,NULL,NULL,'ladmin'),(13,NULL,NULL,'madmin'),(14,NULL,NULL,'madmin'),(16,NULL,'0000','madmin'),(17,NULL,NULL,'madmin'),(18,NULL,NULL,'madmin'),(19,NULL,NULL,'madmin'),(20,NULL,NULL,'madmin'),(21,NULL,NULL,'madmin'),(22,NULL,NULL,'madmin'),(23,NULL,NULL,'madmin'),(24,NULL,'0000','madmin'),(25,NULL,'0000','madmin'),(26,NULL,NULL,'ladmin'),(27,NULL,'0000','madmin'),(28,NULL,'0000','madmin'),(29,NULL,NULL,'user1'),(31,NULL,'0000','madmin'),(32,NULL,NULL,'user1'),(34,NULL,'1358','madmin'),(35,NULL,NULL,'user1'),(36,NULL,NULL,'madmin'),(37,NULL,NULL,'madmin'),(38,NULL,'1358','madmin'),(39,NULL,NULL,'madmin'),(40,NULL,NULL,'madmin'),(41,NULL,NULL,'madmin'),(42,NULL,NULL,'madmin'),(43,NULL,NULL,'user1'),(44,NULL,NULL,'madmin'),(45,NULL,NULL,'user1'),(46,NULL,NULL,'user1'),(47,NULL,NULL,'user1'),(48,NULL,NULL,'user1'),(49,NULL,'1358','madmin'),(50,NULL,NULL,'user1'),(51,NULL,NULL,'user1'),(52,NULL,NULL,'user1'),(53,NULL,NULL,'user2'),(54,NULL,NULL,'user2'),(55,NULL,NULL,'user2'),(56,NULL,'0000','madmin'),(57,NULL,NULL,'user2'),(58,NULL,NULL,'user2'),(59,NULL,NULL,'user2'),(60,NULL,NULL,'user2'),(61,NULL,'0000','madmin'),(62,NULL,NULL,'madmin'),(63,NULL,NULL,'user2'),(66,NULL,NULL,'user2'),(67,NULL,NULL,'user2'),(68,NULL,NULL,'madmin'),(69,NULL,NULL,'user2'),(70,NULL,NULL,'user2'),(71,NULL,NULL,'user2'),(72,NULL,NULL,'user2'),(73,NULL,NULL,'user2'),(74,NULL,NULL,'user2'),(77,NULL,NULL,'user2'),(78,NULL,NULL,'user2'),(79,NULL,NULL,'user2'),(80,NULL,NULL,'user2'),(81,NULL,NULL,'user2'),(82,NULL,NULL,'user2'),(83,NULL,NULL,'user2'),(84,NULL,NULL,'user2'),(85,NULL,NULL,'user2'),(86,NULL,NULL,'user2'),(88,NULL,NULL,'user2'),(89,NULL,NULL,'user2'),(90,NULL,NULL,'user2'),(93,NULL,NULL,'user2'),(94,NULL,NULL,'user2'),(95,NULL,NULL,'user2'),(98,NULL,NULL,'user2'),(99,NULL,NULL,'user2'),(100,NULL,NULL,'madmin'),(101,NULL,NULL,'user1'),(102,NULL,NULL,'user2'),(103,NULL,NULL,'user2'),(104,NULL,NULL,'user2'),(105,NULL,NULL,'user2'),(106,NULL,NULL,'user2'),(107,NULL,NULL,'user2'),(108,NULL,NULL,'user2'),(109,NULL,NULL,'user2'),(110,NULL,NULL,'user2'),(111,NULL,NULL,'user2'),(112,NULL,NULL,'user2'),(113,NULL,NULL,'user2'),(114,NULL,NULL,'user2'),(115,NULL,NULL,'user2'),(116,NULL,NULL,'user2'),(117,NULL,NULL,'user2'),(118,NULL,NULL,'user2'),(119,NULL,NULL,'user2'),(120,NULL,NULL,'madmin'),(128,NULL,NULL,'user2'),(129,NULL,NULL,'user2'),(130,NULL,NULL,'user2'),(131,NULL,NULL,'user2'),(145,NULL,NULL,'user1'),(146,NULL,NULL,'user2'),(148,NULL,NULL,'user2'),(149,NULL,NULL,'user2'),(150,NULL,NULL,'user2'),(151,NULL,NULL,'user2'),(152,NULL,NULL,'user2'),(153,NULL,NULL,'user2'),(154,NULL,NULL,'user1'),(159,NULL,NULL,'user1'),(160,NULL,NULL,'user1'),(161,NULL,NULL,'user2'),(162,NULL,NULL,'user2'),(163,NULL,NULL,'user2'),(164,NULL,NULL,'user2'),(165,NULL,NULL,'user2'),(166,NULL,NULL,'user2'),(167,NULL,NULL,'user2'),(168,NULL,NULL,'user2'),(169,NULL,NULL,'user2'),(170,NULL,NULL,'user2'),(171,NULL,NULL,'user2'),(172,NULL,NULL,'user2'),(173,NULL,NULL,'user2'),(174,NULL,NULL,'user2'),(175,NULL,NULL,'user2'),(176,NULL,NULL,'user2'),(177,NULL,NULL,'user2'),(178,NULL,NULL,'user2'),(179,NULL,NULL,'user2'),(180,NULL,NULL,'user2'),(181,NULL,NULL,'user2'),(182,NULL,NULL,'madmin'),(183,NULL,NULL,'user2'),(184,NULL,NULL,'user2'),(185,NULL,NULL,'user2'),(186,NULL,NULL,'user2'),(187,NULL,NULL,'user2'),(188,NULL,NULL,'user2'),(189,NULL,NULL,'user2'),(190,NULL,NULL,'user2'),(191,NULL,NULL,'user2'),(192,NULL,NULL,'user2'),(193,NULL,NULL,'user2'),(194,NULL,NULL,'user2'),(195,NULL,NULL,'user2'),(196,NULL,NULL,'user2'),(197,NULL,NULL,'user2'),(198,NULL,NULL,'user2'),(199,NULL,NULL,'user2'),(200,NULL,NULL,'user2'),(201,NULL,NULL,'user2'),(202,NULL,NULL,'user2'),(203,NULL,NULL,'user2'),(204,NULL,NULL,'user2'),(205,NULL,NULL,'user2'),(206,NULL,NULL,'user2'),(207,NULL,NULL,'user2'),(208,NULL,NULL,'user2'),(209,NULL,NULL,'user2'),(210,NULL,NULL,'user2'),(211,NULL,NULL,'user2'),(212,NULL,NULL,'user2'),(213,NULL,NULL,'user2'),(214,NULL,NULL,'user2'),(215,NULL,NULL,'madmin'),(216,NULL,'0000','madmin'),(217,NULL,NULL,'user1'),(218,NULL,NULL,'user2'),(219,NULL,NULL,'user2'),(220,NULL,NULL,'user2'),(221,NULL,NULL,'user2'),(222,NULL,NULL,'user2'),(223,NULL,NULL,'user2'),(224,NULL,NULL,'user2'),(225,NULL,NULL,'user2'),(226,NULL,NULL,'user2'),(227,NULL,NULL,'madmin'),(228,NULL,NULL,'user2'),(229,NULL,NULL,'user2'),(230,NULL,NULL,'user2'),(231,NULL,NULL,'user2'),(232,NULL,NULL,'user1'),(233,NULL,NULL,'user1'),(234,NULL,NULL,'madmin'),(235,NULL,NULL,'madmin'),(236,NULL,NULL,'user1'),(237,NULL,NULL,'user1'),(238,NULL,NULL,'user1'),(239,NULL,NULL,'user1'),(240,NULL,NULL,'user2'),(241,NULL,NULL,'user1'),(243,NULL,NULL,'user1'),(244,NULL,NULL,'user1'),(245,NULL,NULL,'user1'),(246,NULL,NULL,'user1'),(247,NULL,NULL,'user1'),(249,NULL,NULL,'madmin'),(250,NULL,NULL,'user2'),(251,NULL,NULL,'user1'),(252,NULL,NULL,'user1'),(253,NULL,NULL,'user1'),(254,NULL,NULL,'user1'),(255,NULL,NULL,'madmin'),(256,NULL,NULL,'user1'),(257,NULL,NULL,'user1'),(258,NULL,NULL,'user1'),(259,NULL,NULL,'user1'),(260,NULL,NULL,'user1'),(261,NULL,NULL,'user1'),(262,NULL,NULL,'user1'),(263,NULL,NULL,'user1'),(264,NULL,NULL,'user1'),(265,NULL,NULL,'user1'),(266,NULL,NULL,'user1'),(267,NULL,NULL,'user1'),(268,NULL,NULL,'user1'),(269,NULL,NULL,'user1'),(270,NULL,NULL,'user1'),(271,NULL,NULL,'user1'),(272,NULL,NULL,'user1'),(273,NULL,NULL,'user1'),(274,NULL,NULL,'user1'),(275,NULL,NULL,'madmin'),(276,NULL,NULL,'user1'),(277,NULL,NULL,'user1'),(278,NULL,NULL,'user1'),(279,NULL,NULL,'user1'),(280,NULL,NULL,'user1'),(281,NULL,NULL,'user1'),(282,NULL,NULL,'user1'),(283,NULL,NULL,'madmin'),(284,NULL,NULL,'user1'),(285,NULL,NULL,'user1'),(286,NULL,NULL,'user1'),(287,NULL,NULL,'madmin'),(288,NULL,NULL,'user1'),(289,NULL,NULL,'user1'),(290,NULL,NULL,'user1'),(291,NULL,NULL,'user1'),(292,NULL,NULL,'user1'),(293,NULL,NULL,'user1'),(294,NULL,NULL,'user1'),(295,NULL,NULL,'user1'),(296,NULL,NULL,'user1'),(297,NULL,NULL,'user1'),(298,NULL,NULL,'user1'),(299,NULL,NULL,'user1'),(300,NULL,NULL,'user1'),(301,NULL,NULL,'user1'),(302,NULL,NULL,'user1'),(303,NULL,NULL,'user1'),(304,NULL,NULL,'user1'),(305,NULL,NULL,'user1'),(306,NULL,NULL,'user1'),(307,NULL,NULL,'user1'),(308,NULL,NULL,'user1'),(309,NULL,NULL,'user1'),(310,NULL,NULL,'user1'),(311,NULL,NULL,'user1'),(312,NULL,NULL,'user1'),(313,NULL,NULL,'user1'),(314,NULL,NULL,'user1'),(315,NULL,NULL,'user1'),(316,NULL,NULL,'user1'),(317,NULL,NULL,'user1'),(318,NULL,NULL,'user1'),(319,NULL,NULL,'user1'),(320,NULL,NULL,'user1'),(321,NULL,NULL,'user1'),(322,NULL,NULL,'user1'),(323,NULL,NULL,'user1'),(324,NULL,NULL,'user1'),(325,NULL,NULL,'user1'),(326,NULL,NULL,'user1'),(327,NULL,NULL,'user1'),(328,NULL,NULL,'user1'),(329,NULL,NULL,'user1'),(330,NULL,NULL,'user1'),(331,NULL,NULL,'user1'),(332,NULL,NULL,'user1'),(333,NULL,NULL,'user1'),(334,NULL,NULL,'user1'),(335,NULL,NULL,'user1'),(336,NULL,NULL,'user1'),(337,NULL,NULL,'user1'),(338,NULL,NULL,'user1'),(339,NULL,NULL,'user1'),(340,NULL,NULL,'user1'),(341,NULL,NULL,'user1'),(342,NULL,NULL,'user1'),(343,NULL,NULL,'user1'),(344,NULL,NULL,'user1'),(345,NULL,NULL,'user1'),(346,NULL,NULL,'user1'),(347,NULL,NULL,'user1'),(348,NULL,NULL,'user1'),(349,NULL,NULL,'user1'),(350,NULL,NULL,'user1'),(351,NULL,NULL,'user1'),(352,NULL,NULL,'user1'),(353,NULL,NULL,'user1'),(354,NULL,NULL,'user1'),(355,NULL,NULL,'user1'),(356,NULL,NULL,'user1'),(357,NULL,NULL,'user1'),(358,NULL,NULL,'user1'),(359,NULL,NULL,'user1'),(360,NULL,NULL,'user1'),(361,NULL,NULL,'user1'),(362,NULL,NULL,'user1'),(363,NULL,NULL,'user1'),(364,NULL,NULL,'user1'),(365,NULL,NULL,'user1'),(366,NULL,NULL,'user1'),(367,NULL,NULL,'user1'),(368,NULL,NULL,'user1'),(369,NULL,NULL,'user1'),(370,NULL,NULL,'user1'),(371,NULL,NULL,'user1'),(372,NULL,NULL,'ladmin'),(373,NULL,NULL,'user1'),(374,NULL,NULL,'user1'),(375,NULL,NULL,'user1'),(376,NULL,NULL,'user1'),(377,NULL,NULL,'user1'),(378,NULL,NULL,'user1'),(379,NULL,NULL,'user1'),(380,NULL,NULL,'madmin'),(381,NULL,NULL,'madmin'),(382,NULL,NULL,'madmin'),(383,NULL,NULL,'madmin'),(384,NULL,NULL,'madmin'),(385,NULL,NULL,'madmin'),(386,NULL,NULL,'madmin'),(387,NULL,NULL,'madmin'),(388,NULL,NULL,'madmin'),(389,NULL,NULL,'madmin'),(390,NULL,NULL,'madmin'),(391,NULL,NULL,'user1'),(392,NULL,NULL,'user1'),(393,NULL,NULL,'user1');
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');
