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,'Yes');
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,'MPT-II','66:32:25:F3:C7:47','','bluetooth');
INSERT INTO `cardswiperactivation` (`_id`, `CardSwiperName`, `merchantKey`, `partnerkey`, `Config_status`) VALUES (1,'PaySwiff','','','Not Activated'),(2,'mSwipe','','','Not Activated'),(3,'PineLabs','','','Not Activated'),(4,'Firstdata','','','Not Activated'),(5,'Paytm','','','Not Activated'),(6,'ezetap','','','Not Activated');
INSERT INTO `change_time_format` (`_id`, `status`) VALUES (1,'changed');
INSERT INTO `companydetailss` (`_id`, `companyname`, `doorno`, `substreet`, `street`, `city`, `state`, `country`, `pincode`, `phoneno`, `taxone`, `taxtwo`, `footerone`, `footertwo`, `address1`, `email`, `website`, `address2`, `address3`) VALUES (5,'Intuition',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'www.intuitionsoftwares.com',NULL,NULL);
INSERT INTO `country_selection` (`_id`, `country`) VALUES (1,'Rupee');
INSERT INTO `default_credit` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `deletedb_time` (`_id`, `time`) VALUES (1,'11:30 PM');
INSERT INTO `deletedbon_off` (`_id`, `status`) VALUES (1,'off');
INSERT INTO `estimate_print` (`_id`, `status`) VALUES (1,'Yes');
INSERT INTO `freetrail` (`_id`, `status`) VALUES (1,'Activated');
INSERT INTO `home_check` (`_id`, `login_status`) VALUES (1,'0');
INSERT INTO `homedelivery_prints` (`_id`, `companycopy`, `customercopy`) VALUES (1,'yes','yes');
INSERT INTO `hotel` (`_id`, `name`, `direccion`, `telefono`, `email`, `value`) VALUES (1,'All',NULL,NULL,NULL,NULL),(2,'Favourites',NULL,NULL,NULL,NULL),(3,'LAR ITEMS',NULL,NULL,NULL,NULL),(4,'SMOKE ITEMS',NULL,NULL,NULL,NULL),(5,'PAPER ITEMS',NULL,NULL,NULL,NULL),(6,'SHOTS',NULL,NULL,NULL,NULL),(7,'COMMETS',NULL,NULL,NULL,NULL),(8,'FANCY ITEMS',NULL,NULL,NULL,NULL),(9,'COLD FIRE /GUNS/BATTERYS',NULL,NULL,NULL,NULL),(10,'FLOWER POTS',NULL,NULL,NULL,NULL),(11,'GROUND CHAKKARS',NULL,NULL,NULL,NULL),(12,'ATOM BOMBS',NULL,NULL,NULL,NULL),(13,'LAXMI ITEMS',NULL,NULL,NULL,NULL),(14,'ROCKETS',NULL,NULL,NULL,NULL),(15,'PENCILS & TWINKLIGSTARS',NULL,NULL,NULL,NULL),(16,'SPARKLERS',NULL,NULL,NULL,NULL),(17,'CHILDREN ITEMS',NULL,NULL,NULL,NULL),(18,'GIFT BOXES',NULL,NULL,NULL,NULL),(19,'MATHCHES',NULL,NULL,NULL,NULL),(20,'All',NULL,NULL,NULL,NULL),(21,'Favourites',NULL,NULL,NULL,NULL),(22,'OTHER ITEMS',NULL,NULL,NULL,NULL),(23,'IPL MEGHA SHOTS',NULL,NULL,NULL,NULL);
INSERT INTO `ipconn` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.87','9100','','TM Printer');
INSERT INTO `ipconn_counter` (`_id`, `ipname`, `port`, `status`, `printer_name`) VALUES (1,'192.168.1.92','9100','','TM Printer');
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,'100 WALA',60.00,378,'LAR ITEMS','','','0','0','','','','no','%','0','10','','','',23,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'200 WALA',100.00,15,'LAR ITEMS','','[BLOB]','0','0','','','','no','%','0','20','','','',20,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'300 WALA',260.00,0,'LAR ITEMS','','[BLOB]','0','0','','','','no','%','0','30','','','',1,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'600 WALA',400.00,0,'LAR ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'yes','%','0','60','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1000 WALA',350.00,156,'LAR ITEMS','','','0','0','','','','no','%','0','10','','','',203,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'2000 WALA',650.00,-7,'LAR ITEMS','','[BLOB]','0','0','','','','no','%','0','20','','','',111,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'3000 WALA',1000.00,0,'LAR ITEMS','','[BLOB]','0','0','','','','yes','%','0','30','','','',10,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'5000 WALA',1850.00,73,'LAR ITEMS','','','0','0','','','','no','%','0','50','','','',50,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'10000 WALA',3100.00,1,'LAR ITEMS','','[BLOB]','0','0','','','','no','%','0','10','','','',9,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'100 WALA STD',140.00,0,'LAR ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','10','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'200 WALA STD',150.00,0,'LAR ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','20','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'300 WALA STD',200.00,0,'LAR ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','30','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'600 WALA STD',350.00,0,'LAR ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'yes','%','0','60','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1000 WALA STD',500.00,0,'LAR ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'yes','%','0','10','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2000 WALA STD',800.00,0,'LAR ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','20','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'3000 WALA STD',1500.00,0,'LAR ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','30','',NULL,NULL,1,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'5000 WALA STD',3500.00,3,'LAR ITEMS','','[BLOB]','0','0','','','','yes','%','0','50','','','',2,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'10000 WALA STD',4000.00,2,'LAR ITEMS','','[BLOB]','0','0','','','','yes','%','0','10','','','',8,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'SMOKE  5 PICES',250.00,19,'SMOKE ITEMS','','[BLOB]','0','0','','','','no','%','0','SM','','','',14,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'SMOKE 5 PICE STD',550.00,-6,'SMOKE ITEMS','','','0','0','','','','no','%','0','SM','','','',58,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'PAPER BLAST FUSE',60.00,-5,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','PA','','','',17,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'PAPER ITEM 2 PICE',250.00,37,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','PA','','','',15,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'PAPER ITEM 3 PICE',300.00,0,'PAPER ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','PA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'4 PAPER SHOTS',400.00,3,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','4 ','','','',9,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'8 PAPER SHOTS',650.00,-10,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','8 ','','','',16,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'10 PAPER SHOTS',750.00,0,'PAPER ITEMS','','[BLOB]','0','0','','','','yes','%','0','10','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'JADOO PAPER SHOTS',250.00,0,'PAPER ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','JA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'15 PAPER SHOTS',1200.00,12,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','15','','','',2,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,' PAPER BOMB',100.00,0,'PAPER ITEMS','','[BLOB]','0','0','','','','yes','%','0',' P','','','',6,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'PAPER BOMB SMALL',80.00,4,'PAPER ITEMS','','[BLOB]','0','0','','','','yes','%','0','PA','','','',2,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'PAPER BOMB 5 PICE',250.00,69,'PAPER ITEMS','','[BLOB]','0','0','','','','no','%','0','PA','','','',10,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'9 SHOT PAPER',650.00,0,'PAPER ITEMS','','[BLOB]','0','0','','','','yes','%','0','9 ','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'12 SHOTS MIX',300.00,316,'SHOTS','','','0','0','','','','no','%','0','12','','','',49,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'15 SHOTS',350.00,14,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','15','',NULL,NULL,80,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'25 SHOTS CRAKKLING',350.00,33,'SHOTS','','[BLOB]','0','0','','','','no','%','0','25','','','',13,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'25 SHOTS MULTICOL',600.00,-6,'SHOTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','25','',NULL,NULL,6,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'26 SHOTS',550.00,0,'SHOTS','','[BLOB]','0','0','','','','no','%','0','26','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'30 SHOTS',650.00,-27,'SHOTS','','','0','0','','','','no','%','0','30','','','',215,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'50 SHOTS',1100.00,0,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','50','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'60 SHOTS',1150.00,10,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','60','',NULL,NULL,162,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'100 SHOTS',1400.00,-13,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','10','',NULL,NULL,34,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,'120 SHOTS',1950.00,0,'SHOTS','','[BLOB]','0','0','','','','no','%','0','12','','','',49,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,'200 SHOTS',2800.00,17,'SHOTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','20','',NULL,NULL,8,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,'240 SHOTS',3000.00,-1,'SHOTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','24','',NULL,NULL,3,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,'500 SHOTS',6000.00,3,'SHOTS','','[BLOB]','0','0','','','','no','%','0','50','','','',7,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,'1000 SHOTS',10000.00,0,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','10','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,'AIR RIDERS',350.00,0,'SHOTS','','[BLOB]','0','0','','','','yes','%','0','AI','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'60 SHOT S.T.D',1800.00,2,'SHOTS','','[BLOB]','0','0','','','','yes','%','0','60','','','',0,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'RED ROSE PAPER SHOT',250.00,0,'PAPER ITEMS','','[BLOB]','0','0','','','','yes','%','0','RE','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'CRACKY 16 SHOT',450.00,0,'SHOTS','','[BLOB]','0','0','','','','yes','%','0','CR','','','',0,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'150 COLOUR BALLS',450.00,7,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','15','',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),(52,'30 SHOT STD',800.00,7,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','30','',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),(53,'80 SHOT STD',1800.00,4,'SHOTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','80','',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),(54,'100 SHOT STD',2200.00,4,'SHOTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','10','',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),(56,'MINES',975.00,-5,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MI','',NULL,NULL,11,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'1 COMET',15.00,0,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','1 ','',NULL,NULL,8,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'2 COMMET ',350.00,216,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','2 ','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'3 COMMET',400.00,-9,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','3 ','',NULL,NULL,47,'0','0','0','Low','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'4 COMMET',500.00,23,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','4 ','',NULL,NULL,7,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'1X 5',250.00,25,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','1X','',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),(62,'2X2 COMMETS',450.00,98,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'yes','%','0','2X','',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),(63,'2X3',500.00,66,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','2X','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'4X2 COMMETS',450.00,0,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','4X','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'5X2 COMMETS',580.00,-7,'COMMETS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','5X','',NULL,NULL,7,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,'1X10',250.00,0,'COMMETS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','1X','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,'MISS INDIAN',150.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','MI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,'COLOUR BUST',200.00,9,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CO','',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),(70,'KING FISHER',150.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','KI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,'AIR TRAFIC',200.00,0,'FANCY ITEMS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','AI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,'SKY LANTHERS',50.00,23,'FANCY ITEMS','','[BLOB]','0',NULL,NULL,NULL,NULL,'yes','%','0','SK','',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),(73,'COLD FIRE A       320',320.00,-2,'COLD FIRE /GUNS/BATTERYS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,2,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,'COLD FIRE  B      250',250.00,30,'COLD FIRE /GUNS/BATTERYS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,46,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,'COLD FIRE C       180',180.00,-161,'COLD FIRE /GUNS/BATTERYS','','','0','0','','','','no','%','0','CO','','','',618,'0','0','180','Low','','150','Unit','','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,'GUNS PLASTICK',250.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GU','',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'GUNS METAL',550.00,9,'COLD FIRE /GUNS/BATTERYS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','GU','',NULL,NULL,4,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'COLD FIRE COMPLETE SET',450.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'BATTERY',25.00,-12,'COLD FIRE /GUNS/BATTERYS','','','0',NULL,NULL,NULL,NULL,'no','%','0','BA','',NULL,NULL,77,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'HAND PYRO',3500.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','HA','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'SPARKELER GUN',350.00,-31,'COLD FIRE /GUNS/BATTERYS','','','0',NULL,NULL,NULL,NULL,'no','%','0','SP','',NULL,NULL,56,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'KOKO',250.00,3,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','KO','',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),(84,'1 X 5 PICES',250.00,8,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','1 ','',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),(85,'1 X 10 PICES/ DUS KA 10',200.00,3,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','1 ','',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),(86,'DLX',450.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','DL','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,'GIFT BOX',550.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','GI','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,'1X2 PICES',250.00,0,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','1X','',NULL,NULL,0,'0','0','0','Low',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,'2 IN 1',250.00,7,'COLD FIRE /GUNS/BATTERYS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','2 ','',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),(90,'FP BIG STD',150.00,21,'FLOWER POTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FP','',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),(91,'FLOWER POTS SMAL',60.00,57,'FLOWER POTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','FL','',NULL,NULL,2,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,'FLOWER POTS  BIG',120.00,60,'FLOWER POTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','FL','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,'FLOWER POTS SPECIAL',150.00,47,'FLOWER POTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','FL','',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),(94,'FLOWER POTS ASHOKA',200.00,32,'FLOWER POTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','FL','',NULL,NULL,7,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,'COLOUR KOTI/GAINT',250.00,42,'FLOWER POTS','','','0',NULL,NULL,NULL,NULL,'no','%','0','CO','',NULL,NULL,9,'0','0','0','','','','Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,'COLOUR KOTI DLX',280.00,136,'FLOWER POTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','CO','',NULL,NULL,1,'0','0','0','',NULL,NULL,'Unit','','','','','','','','','','','','','','','','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,'TRICOLOUR F.P 5 PICES',350.00,57,'FLOWER POTS','','[BLOB]','0',NULL,NULL,NULL,NULL,'no','%','0','TR','',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),(98,'FLOWER POTS  SINGLE PICES/MILANO',200.00,24,'FLOWER POTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FL','',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),(99,'FLOWER POTS 2 PICES',310.00,23,'FLOWER POTS','','[BLOB]',NULL,NULL,NULL,NULL,NULL,'yes','%','0','FL','',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),