-- MySQL dump 10.9
--
-- Host: localhost Database: turnkey_auctpro
-- ------------------------------------------------------
-- Server version 4.1.22-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `probid_abuses`
--
DROP TABLE IF EXISTS `probid_abuses`;
CREATE TABLE `probid_abuses` (
`id` int(11) NOT NULL auto_increment,
`reporterid` int(11) NOT NULL default '0',
`reporterusern` varchar(100) NOT NULL default '',
`abuserusern` varchar(100) NOT NULL default '',
`comment` text NOT NULL,
`reportdate` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with abuse reports';
--
-- Dumping data for table `probid_abuses`
--
LOCK TABLES `probid_abuses` WRITE;
/*!40000 ALTER TABLE `probid_abuses` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_abuses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_admin_notes`
--
DROP TABLE IF EXISTS `probid_admin_notes`;
CREATE TABLE `probid_admin_notes` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`comment` text NOT NULL,
`regdate` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_admin_notes`
--
LOCK TABLES `probid_admin_notes` WRITE;
/*!40000 ALTER TABLE `probid_admin_notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_admin_notes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_admins`
--
DROP TABLE IF EXISTS `probid_admins`;
CREATE TABLE `probid_admins` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`created` date NOT NULL default '0000-00-00',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`level` enum('1','2','3','4','5') NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Table with admin info';
--
-- Dumping data for table `probid_admins`
--
LOCK TABLES `probid_admins` WRITE;
/*!40000 ALTER TABLE `probid_admins` DISABLE KEYS */;
INSERT INTO `probid_admins` VALUES (1,'admin','236f5afe7bea74c3b9ad1845bd169cca','2007-04-27','2009-03-31 15:56:33','1'),(2,'swedesh','e99a18c428cb38d5f260853678922e03','2007-11-09','0000-00-00 00:00:00','1');
/*!40000 ALTER TABLE `probid_admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_adultfilter`
--
DROP TABLE IF EXISTS `probid_adultfilter`;
CREATE TABLE `probid_adultfilter` (
`2` int(11) NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
PRIMARY KEY (`2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_adultfilter`
--
LOCK TABLES `probid_adultfilter` WRITE;
/*!40000 ALTER TABLE `probid_adultfilter` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_adultfilter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_adverts`
--
DROP TABLE IF EXISTS `probid_adverts`;
CREATE TABLE `probid_adverts` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`company` varchar(100) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`views` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imgpath` varchar(255) NOT NULL default '',
`alttext` varchar(255) NOT NULL default '',
`textunder` varchar(255) NOT NULL default '',
`views_p` int(11) NOT NULL default '0',
`clicks_p` int(11) NOT NULL default '0',
`cat_filter` text NOT NULL,
`keyword_filter` text NOT NULL,
`banner_code` longtext NOT NULL,
`type` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with banners data';
--
-- Dumping data for table `probid_adverts`
--
LOCK TABLES `probid_adverts` WRITE;
/*!40000 ALTER TABLE `probid_adverts` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_adverts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_announcements`
--
DROP TABLE IF EXISTS `probid_announcements`;
CREATE TABLE `probid_announcements` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`date` date NOT NULL default '0000-00-00',
`lang` varchar(255) NOT NULL default 'english',
`active` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with announcements for members';
--
-- Dumping data for table `probid_announcements`
--
LOCK TABLES `probid_announcements` WRITE;
/*!40000 ALTER TABLE `probid_announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_auction_durations`
--
DROP TABLE IF EXISTS `probid_auction_durations`;
CREATE TABLE `probid_auction_durations` (
`id` int(11) NOT NULL auto_increment,
`days` int(11) NOT NULL default '0',
`description` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 COMMENT='Table with auction durations';
--
-- Dumping data for table `probid_auction_durations`
--
LOCK TABLES `probid_auction_durations` WRITE;
/*!40000 ALTER TABLE `probid_auction_durations` DISABLE KEYS */;
INSERT INTO `probid_auction_durations` VALUES (82,1,'1 day'),(83,2,'2 days'),(84,7,'1 week'),(85,14,'2 weeks'),(86,28,'1 Month'),(87,56,'2 Months'),(88,1000,'Multi Year');
/*!40000 ALTER TABLE `probid_auction_durations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_auction_images`
--
DROP TABLE IF EXISTS `probid_auction_images`;
CREATE TABLE `probid_auction_images` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`auctionid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with additional auction images';
--
-- Dumping data for table `probid_auction_images`
--
LOCK TABLES `probid_auction_images` WRITE;
/*!40000 ALTER TABLE `probid_auction_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_auction_images` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_auction_offers`
--
DROP TABLE IF EXISTS `probid_auction_offers`;
CREATE TABLE `probid_auction_offers` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`buyerid` int(11) NOT NULL default '0',
`sellerid` int(11) NOT NULL default '0',
`quantity` int(11) NOT NULL default '0',
`amount` double(16,2) NOT NULL default '0.00',
`expires` int(11) NOT NULL default '0',
`accepted` enum('no','yes') NOT NULL default 'no',
`status` enum('active','expired') NOT NULL default 'active',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_auction_offers`
--
LOCK TABLES `probid_auction_offers` WRITE;
/*!40000 ALTER TABLE `probid_auction_offers` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_auction_offers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_auction_watch`
--
DROP TABLE IF EXISTS `probid_auction_watch`;
CREATE TABLE `probid_auction_watch` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`auctionid` int(11) NOT NULL default '0',
`useremail` varchar(255) NOT NULL default '',
`itemname` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Table for Items Watching';
--
-- Dumping data for table `probid_auction_watch`
--
LOCK TABLES `probid_auction_watch` WRITE;
/*!40000 ALTER TABLE `probid_auction_watch` DISABLE KEYS */;
INSERT INTO `probid_auction_watch` VALUES (1,4,3,'khinko78@yahoo.com','AAAAA'),(2,4,4,'khinko78@yahoo.com','AAAAA'),(3,7,7,'joe@zipspam.com','camera');
/*!40000 ALTER TABLE `probid_auction_watch` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_auctions`
--
DROP TABLE IF EXISTS `probid_auctions`;
CREATE TABLE `probid_auctions` (
`id` bigint(20) NOT NULL auto_increment,
`itemname` varchar(255) NOT NULL default '',
`description` mediumblob NOT NULL,
`picpath` varchar(255) NOT NULL default '',
`quantity` smallint(6) NOT NULL default '0',
`auctiontype` varchar(30) NOT NULL default '',
`bidstart` double(16,2) NOT NULL default '0.00',
`rp` char(2) NOT NULL default '',
`rpvalue` double(16,2) NOT NULL default '0.00',
`bn` char(2) NOT NULL default '',
`bnvalue` double(16,2) NOT NULL default '0.00',
`bi` tinyint(4) NOT NULL default '0',
`bivalue` double(16,2) NOT NULL default '0.00',
`duration` smallint(6) NOT NULL default '0',
`country` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`sc` char(2) NOT NULL default '',
`scint` char(2) NOT NULL default '',
`pm` text NOT NULL,
`category` int(11) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
`payment_status` varchar(20) NOT NULL default '',
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`closed` tinyint(4) NOT NULL default '0',
`keywords` text NOT NULL,
`nrbids` int(11) NOT NULL default '0',
`maxbid` double(16,2) NOT NULL default '0.00',
`clicks` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`hpfeat` char(2) NOT NULL default 'N',
`catfeat` char(2) NOT NULL default 'N',
`bolditem` char(2) NOT NULL default 'N',
`hlitem` char(2) NOT NULL default 'N',
`private` varchar(10) NOT NULL default '0',
`currency` varchar(100) NOT NULL default '',
`swapped` tinyint(4) NOT NULL default '0',
`postage_costs` double(16,2) NOT NULL default '0.00',
`insurance` varchar(50) NOT NULL default '',
`type_service` varchar(50) NOT NULL default '',
`isswap` char(2) NOT NULL default 'N',
`acceptdirectpayment` tinyint(4) NOT NULL default '0',
`directpaymentemail` varchar(255) NOT NULL default '',
`paidwithdirectpayment` tinyint(4) NOT NULL default '0',
`addlcategory` int(11) NOT NULL default '0',
`deleted` tinyint(4) NOT NULL default '0',
`amountpaid` double(16,2) NOT NULL default '0.00',
`paymentdate` int(11) NOT NULL default '0',
`processor` varchar(50) NOT NULL default '',
`shipping_details` mediumtext NOT NULL,
`hpfeat_desc` varchar(255) NOT NULL default '',
`reserveoffer` double(16,2) NOT NULL default '0.00',
`rpwinner` int(11) NOT NULL default '0',
`listin` varchar(20) NOT NULL default 'auction',
`close_in_progress` tinyint(4) NOT NULL default '0',
`bid_in_progress` tinyint(4) NOT NULL default '0',
`bank_details` text,
`accept_payment_systems` varchar(50) default NULL,
`apply_vat` tinyint(4) NOT NULL default '0',
`auto_relist` char(2) NOT NULL default 'N',
`auto_relist_bids` char(2) NOT NULL default 'N',
`endtime_type` enum('duration','customtime') NOT NULL default 'duration',
`videofile_path` varchar(255) NOT NULL default '',
`approved` tinyint(4) NOT NULL default '0',
`count_in_progress` tinyint(4) NOT NULL default '0',
`listing_type` enum('full','quick') NOT NULL default 'full',
`offer_active` tinyint(4) NOT NULL default '0',
`offer_range_min` double(16,2) NOT NULL default '0.00',
`offer_range_max` double(16,2) NOT NULL default '0.00',
`endauction_notification` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='Table with auctions details';
--
-- Dumping data for table `probid_auctions`
--
LOCK TABLES `probid_auctions` WRITE;
/*!40000 ALTER TABLE `probid_auctions` DISABLE KEYS */;
INSERT INTO `probid_auctions` VALUES (1,'Hansel and Gretel/Bambi... Golden Books--Must','<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hansel and Gretel--nice condition--copyright1954......beautifully illustrated.......no writing on the inside</SPAN></P>\r\n<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN> </P>\r\n<P>Walt Disney's Bambi---based on the original and adapted from the Walt Disney motion picture--copyright 1948. No inside writing, nice shape</P>','uplimg/mb1_aca36deb7889d9f58554e44d747c94ad_mainpic.jpg',1,'standard',0.99,'N',0.00,'Y',59.99,0,0.00,1000,'United States','43130','','','PayPal<br>',382,0,'confirmed','2007-04-27 20:55:20','2010-01-21 20:55:20',0,'Hansel and Gretel/Bambi... Golden Books--Must <P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hansel and Gretel--nice condition--copyright1954......beautifully illustrated.......no writing on the inside</SPAN></P>\r\n<P><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN> </P>\r\n<P>Walt Disney's Bambi---based on the original and adapted from the Walt Disney motion picture--copyright 1948. No inside writing, nice shape</P>',0,0.00,41,1,'Y','Y','N','N','N','USD',0,2.99,'','Other','N',0,'',0,791,0,0.00,0,'','Insurance is Recommended','Near mint condition - Walt Disney Bambi Little Golden Book',0.00,0,'',0,0,NULL,'',0,'N','N','duration','',0,0,'full',0,0.00,0.00,0),(11,'ducati','kjhjhsadkjas aslijh sadlijoipwe ewf proi repoi rgeojfdl;jfd c vcxkj lxckj ','',1,'standard',5.00,'N',0.00,'N',0.00,0,0.00,28,'United States','98665','BP','','Amex<br>Mastercard<br>PayPal<br>',340,0,'confirmed','2008-06-19 16:10:09','2008-07-17 16:10:09',0,'ducati kjhjhsadkjas aslijh sadlijoipwe ewf proi repoi rgeojfdl;jfd c vcxkj lxckj ',0,0.00,3,9,'Y','Y','Y','Y','N','USD',0,0.00,'1.00','Other','N',0,'',0,0,0,0.00,0,'','','big tinme bike',0.00,0,'auction',0,0,NULL,'',0,'N','N','duration','',0,0,'full',0,0.00,0.00,0),(12,'big time bike','kjhjhsadkjas aslijh sadlijoipwe ewf proi repoi rgeojfdl;jfd c vcxkj lxckj ','',1,'standard',2.00,'N',0.00,'N',0.00,0,0.00,28,'United States','98665','BP','','Amex<br>Mastercard<br>PayPal<br>',323,0,'confirmed','2008-06-28 14:04:32','2008-07-26 14:04:32',0,'big time bike kjhjhsadkjas aslijh sadlijoipwe ewf proi repoi rgeojfdl;jfd c vcxkj lxckj ',0,0.00,4,9,'N','Y','N','Y','N','USD',0,0.00,'1.00','Other','N',0,'',0,0,0,0.00,0,'','','Big Time Bike For SAle',0.00,0,'auction',0,0,NULL,'',0,'N','N','duration','',0,0,'full',0,0.00,0.00,0),(6,'AAAAA','<img alt="AA" src="%3Ca%20href=%22http://photobucket.com%22%20target=%22_blank%22%3E%3Cimg%20src=%22http://i181.photobucket.com/albums/x108/khinko78/EBAY/gem%20picture/withoutglass3.jpg%22%20border=%220%22%20alt=%22Photo%20Sharing%20and%20Video%20Hosting%20at%20Photobucket%22%3E%3C/a%3E" align="left" border="0" height="480" width="640"><br>','uplimg/a6_mainpic.jpg',1,'standard',1.00,'Y',100.00,'Y',120.00,0,0.00,1,'Finland','1234','BP','','Amex
Diners
Mastercard
Nochex
PayPal
Solo
Switch
Visa
Visa Delta
Western Union
',1213,0,'confirmed','2007-09-24 15:28:29','2007-09-25 15:28:29',0,'AAAAA <img alt="AA" src="%3Ca%20href=%22http://photobucket.com%22%20target=%22_blank%22%3E%3Cimg%20src=%22http://i181.photobucket.com/albums/x108/khinko78/EBAY/gem%20picture/withoutglass3.jpg%22%20border=%220%22%20alt=%22Photo%20Sharing%20and%20Video%20Hosting%20at%20Photobucket%22%3E%3C/a%3E" align="left" border="0" height="480" width="640"><br>',0,0.00,0,4,'Y','Y','Y','Y','N','SGD',0,2.00,'2.022','Recorded','N',0,'',0,0,0,0.00,0,'','Shipping details','',0.00,0,'auction',0,0,NULL,'',0,'Y','N','duration','',0,0,'full',0,0.00,0.00,0);
/*!40000 ALTER TABLE `probid_auctions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_banned`
--
DROP TABLE IF EXISTS `probid_banned`;
CREATE TABLE `probid_banned` (
`id` int(11) NOT NULL auto_increment,
`bannedadr` varchar(255) NOT NULL default '',
`type` char(2) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_banned`
--
LOCK TABLES `probid_banned` WRITE;
/*!40000 ALTER TABLE `probid_banned` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_banned` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_bid_increments`
--
DROP TABLE IF EXISTS `probid_bid_increments`;
CREATE TABLE `probid_bid_increments` (
`id` int(11) NOT NULL auto_increment,
`bfrom` double(16,2) NOT NULL default '0.00',
`bto` double(16,2) NOT NULL default '0.00',
`increment` double(16,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 COMMENT='Table with bid increments';
--
-- Dumping data for table `probid_bid_increments`
--
LOCK TABLES `probid_bid_increments` WRITE;
/*!40000 ALTER TABLE `probid_bid_increments` DISABLE KEYS */;
INSERT INTO `probid_bid_increments` VALUES (102,0.00,1.00,0.02),(103,1.00,3.00,0.05),(104,3.00,10.00,2.00),(105,10.00,50.00,5.00),(106,50.00,500.00,15.00),(107,500.00,10000.00,50.00),(108,10000.00,10000000.00,150.00);
/*!40000 ALTER TABLE `probid_bid_increments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_bids`
--
DROP TABLE IF EXISTS `probid_bids`;
CREATE TABLE `probid_bids` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`bidderid` int(11) NOT NULL default '0',
`bidamount` double(16,2) NOT NULL default '0.00',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`quantity` int(11) NOT NULL default '0',
`proxy` double(16,2) NOT NULL default '0.00',
`out` tinyint(4) NOT NULL default '0',
`invalid` tinyint(4) NOT NULL default '0',
`emailsent` tinyint(4) NOT NULL default '0',
`deleted` tinyint(4) NOT NULL default '0',
`rpwinner` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with bids';
--
-- Dumping data for table `probid_bids`
--
LOCK TABLES `probid_bids` WRITE;
/*!40000 ALTER TABLE `probid_bids` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_bids` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_bids_history`
--
DROP TABLE IF EXISTS `probid_bids_history`;
CREATE TABLE `probid_bids_history` (
`id` int(11) NOT NULL auto_increment,
`biddername` varchar(100) NOT NULL default '',
`auctionid` int(11) NOT NULL default '0',
`amount` double(16,2) NOT NULL default '0.00',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`quantity` int(11) NOT NULL default '0',
`bidid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with bids history';
--
-- Dumping data for table `probid_bids_history`
--
LOCK TABLES `probid_bids_history` WRITE;
/*!40000 ALTER TABLE `probid_bids_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_bids_history` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_blocked_domains`
--
DROP TABLE IF EXISTS `probid_blocked_domains`;
CREATE TABLE `probid_blocked_domains` (
`id` int(11) NOT NULL auto_increment,
`domain` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with blocked email domains';
--
-- Dumping data for table `probid_blocked_domains`
--
LOCK TABLES `probid_blocked_domains` WRITE;
/*!40000 ALTER TABLE `probid_blocked_domains` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_blocked_domains` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_blocked_users`
--
DROP TABLE IF EXISTS `probid_blocked_users`;
CREATE TABLE `probid_blocked_users` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`regdate` int(11) NOT NULL default '0',
`block_reason` text NOT NULL,
`min_fb` int(11) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`show_reason` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_blocked_users`
--
LOCK TABLES `probid_blocked_users` WRITE;
/*!40000 ALTER TABLE `probid_blocked_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_blocked_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_bulk`
--
DROP TABLE IF EXISTS `probid_bulk`;
CREATE TABLE `probid_bulk` (
`id` bigint(20) NOT NULL auto_increment,
`itemname` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`picpath` varchar(255) NOT NULL default '',
`quantity` smallint(6) NOT NULL default '0',
`auctiontype` varchar(30) NOT NULL default '',
`bidstart` double(16,2) NOT NULL default '0.00',
`rp` char(2) NOT NULL default 'N',
`rpvalue` double(16,2) NOT NULL default '0.00',
`bn` char(2) NOT NULL default 'N',
`bnvalue` double(16,2) NOT NULL default '0.00',
`bi` tinyint(4) NOT NULL default '0',
`bivalue` double(16,2) NOT NULL default '0.00',
`duration` smallint(6) NOT NULL default '0',
`country` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`sc` char(2) NOT NULL default '',
`scint` char(2) NOT NULL default '',
`pm` text NOT NULL,
`category` varchar(255) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
`payment_status` varchar(20) NOT NULL default '',
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`closed` tinyint(4) NOT NULL default '0',
`keywords` text NOT NULL,
`nrbids` int(11) NOT NULL default '0',
`maxbid` double(16,2) NOT NULL default '0.00',
`clicks` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`hpfeat` char(2) NOT NULL default 'N',
`catfeat` char(2) NOT NULL default 'N',
`bolditem` char(2) NOT NULL default 'N',
`hlitem` char(2) NOT NULL default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with auctions details';
--
-- Dumping data for table `probid_bulk`
--
LOCK TABLES `probid_bulk` WRITE;
/*!40000 ALTER TABLE `probid_bulk` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_bulk` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_bulktmp`
--
DROP TABLE IF EXISTS `probid_bulktmp`;
CREATE TABLE `probid_bulktmp` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`desc` longtext NOT NULL,
`qty` int(11) NOT NULL default '0',
`auctiontype` varchar(20) NOT NULL default '',
`price` varchar(40) NOT NULL default '',
`usereserve` char(1) NOT NULL default '',
`reserve` varchar(40) NOT NULL default '',
`usebuynow` char(1) NOT NULL default '',
`buynow` varchar(40) NOT NULL default '',
`useinc` char(1) NOT NULL default '',
`inc` varchar(40) NOT NULL default '',
`duration` varchar(10) NOT NULL default '',
`country` varchar(250) NOT NULL default '',
`zip` varchar(40) NOT NULL default '',
`whopays` varchar(40) NOT NULL default '',
`shipinter` char(1) NOT NULL default '',
`paymethods` varchar(250) NOT NULL default '',
`category` varchar(40) NOT NULL default '',
`homefeat` char(1) NOT NULL default '',
`catfeat` char(1) NOT NULL default '',
`bold` char(1) NOT NULL default '',
`highlight` char(1) NOT NULL default '',
`private` char(1) NOT NULL default '',
`currency` varchar(40) NOT NULL default '',
`postcosts` varchar(40) NOT NULL default '',
`insurance` varchar(40) NOT NULL default '',
`service` varchar(250) NOT NULL default '',
`allowswap` char(1) NOT NULL default '',
`accdirect` char(1) NOT NULL default '',
`directemail` varchar(250) NOT NULL default '',
`hasimage` varchar(10) NOT NULL default '',
`pictures` longtext NOT NULL,
`haswebimage` varchar(10) NOT NULL default '',
`webimages` longtext NOT NULL,
`homefeatdesc` longtext NOT NULL,
`postnote` varchar(255) NOT NULL default '',
`areaid` varchar(40) NOT NULL default '',
`voucher` varchar(250) NOT NULL default '',
`auctionstore` varchar(40) NOT NULL default 'auction',
`paypalbuyers` char(1) NOT NULL default '',
`catsubfieldid1` int(11) NOT NULL default '0',
`catsubfieldval1` mediumtext NOT NULL,
`catsubfieldid2` int(11) NOT NULL default '0',
`catsubfieldval2` mediumtext NOT NULL,
`catsubfieldid3` int(11) NOT NULL default '0',
`catsubfieldval3` mediumtext NOT NULL,
`catsubfieldid4` int(11) NOT NULL default '0',
`catsubfieldval4` mediumtext NOT NULL,
`catsubfieldid5` int(11) NOT NULL default '0',
`catsubfieldval5` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_bulktmp`
--
LOCK TABLES `probid_bulktmp` WRITE;
/*!40000 ALTER TABLE `probid_bulktmp` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_bulktmp` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_categories`
--
DROP TABLE IF EXISTS `probid_categories`;
CREATE TABLE `probid_categories` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`color` varchar(20) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`theorder` int(11) NOT NULL default '0',
`hidden` tinyint(4) NOT NULL default '0',
`items_counter` int(11) NOT NULL default '0',
`hover_title` varchar(255) NOT NULL default '',
`meta_description` mediumtext NOT NULL,
`meta_keywords` mediumtext NOT NULL,
`imagepath` varchar(255) NOT NULL default '',
`wanted_counter` int(11) NOT NULL default '0',
`issubcat` varchar(5) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`custom_fees` char(2) NOT NULL default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1842 DEFAULT CHARSET=latin1 COMMENT='Table with categories';
--
-- Dumping data for table `probid_categories`
--
LOCK TABLES `probid_categories` WRITE;
/*!40000 ALTER TABLE `probid_categories` DISABLE KEYS */;
INSERT INTO `probid_categories` VALUES (156,57,'PC Games','','',10007,0,0,'','','','',0,'>',0,'N'),(160,156,'Children's','','',0,0,0,'','','','',0,'',0,'N'),(159,156,'Board Games','','',0,0,0,'','','','',0,'',0,'N'),(158,156,'Arcade','','',0,0,0,'','','','',0,'',0,'N'),(167,156,'Simulation','','',0,0,0,'','','','',0,'',0,'N'),(166,156,'Shoot-Em-Up','','',0,0,0,'','','','',0,'',0,'N'),(165,156,'Roleplaying','','',0,0,0,'','','','',0,'',0,'N'),(164,156,'Racing','','',0,0,0,'','','','',0,'',0,'N'),(163,156,'Puzzle','','',0,0,0,'','','','',0,'',0,'N'),(162,156,'Platform','','',0,0,0,'','','','',0,'',0,'N'),(161,156,'Fighting','','',0,0,0,'','','','',0,'',0,'N'),(157,156,'Action/Adventure','','',0,0,0,'','','','',0,'',0,'N'),(57,0,'Gaming','','',12,0,0,'','','','',0,'>',0,'N'),(58,57,'Sony Playstation 2','','',10010,0,0,'','','','',0,'>',0,'N'),(59,57,'Sony Playstation 1','','',10009,0,0,'','','','',0,'>',0,'N'),(60,59,'Games','','',0,0,0,'','','','',0,'>',0,'N'),(61,59,'Consoles','','',0,0,0,'','','','',0,'>',0,'N'),(62,59,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(63,58,'Games','','',0,0,0,'','','','',0,'>',0,'N'),(64,58,'Consoles','','',0,0,0,'','','','',0,'>',0,'N'),(65,58,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(66,63,'Action','','',0,0,0,'','','','',0,'',0,'N'),(67,63,'Fighting','','',0,0,0,'','','','',0,'',0,'N'),(68,63,'Platform','','',0,0,0,'','','','',0,'',0,'N'),(69,63,'Racing','','',0,0,0,'','','','',0,'',0,'N'),(70,63,'Roleplaying','','',0,0,0,'','','','',0,'',0,'N'),(71,63,'Shoot-Em-Up','','',0,0,0,'','','','',0,'',0,'N'),(72,63,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(73,63,'Strategy','','',0,0,0,'','','','',0,'',0,'N'),(74,63,'Other Playstation 2 Games','','',0,0,0,'','','','',0,'',0,'N'),(75,65,'Magazines','','',0,0,0,'','','','',0,'',0,'N'),(76,65,'Walkthrough/Guides','','',0,0,0,'','','','',0,'',0,'N'),(77,65,'Models/Figures','','',0,0,0,'','','','',0,'',0,'N'),(78,65,'Other Playstation 2 Items','','',0,0,0,'','','','',0,'',0,'N'),(79,64,'PAL Consoles','','',0,0,0,'','','','',0,'',0,'N'),(80,64,'Japanese Consoles','','',0,0,0,'','','','',0,'',0,'N'),(81,64,'USA Consoles','','',0,0,0,'','','','',0,'',0,'N'),(82,64,'Other','','',0,0,0,'','','','',0,'',0,'N'),(83,62,'Walkthrough/Guides','','',0,0,0,'','','','',0,'',0,'N'),(84,62,'Magazines','','',0,0,0,'','','','',0,'',0,'N'),(85,62,'Other Playstation 1 Items','','',0,0,0,'','','','',0,'',0,'N'),(86,62,'Control Pads','','',0,0,0,'','','','',0,'',0,'N'),(87,62,'Memory Cards','','',0,0,0,'','','','',0,'',0,'N'),(88,62,'Steering Wheels','','',0,0,0,'','','','',0,'',0,'N'),(89,62,'Joysticks','','',0,0,0,'','','','',0,'',0,'N'),(96,60,'Action','','',0,0,0,'','','','',0,'',0,'N'),(91,62,'Models Figures','','',0,0,0,'','','','',0,'',0,'N'),(92,65,'Control Pads','','',0,0,0,'','','','',0,'',0,'N'),(93,65,'Memory Cards','','',0,0,0,'','','','',0,'',0,'N'),(94,65,'Steering Wheels','','',0,0,0,'','','','',0,'',0,'N'),(95,65,'Joysticks','','',0,0,0,'','','','',0,'',0,'N'),(97,60,'Fighting','','',0,0,0,'','','','',0,'',0,'N'),(98,60,'Platform','','',0,0,0,'','','','',0,'',0,'N'),(99,60,'Racing','','',0,0,0,'','','','',0,'',0,'N'),(100,60,'Roleplaying','','',0,0,0,'','','','',0,'',0,'N'),(101,60,'Shoot-Em-Up','','',0,0,0,'','','','',0,'',0,'N'),(102,60,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(103,60,'Strategy','','',0,0,0,'','','','',0,'',0,'N'),(104,60,'Other Playstation 1 Games','','',0,0,0,'','','','',0,'',0,'N'),(105,61,'Pal Consoles','','',0,0,0,'','','','',0,'',0,'N'),(106,61,'Japanese Consoles','','',0,0,0,'','','','',0,'',0,'N'),(107,61,'USA Consoles','','',0,0,0,'','','','',0,'',0,'N'),(108,61,'Other','','',0,0,0,'','','','',0,'',0,'N'),(109,57,'Arcade Machines','','',10000,0,0,'','','','',0,'>',0,'N'),(110,109,'Pinball Machines','','',0,0,0,'','','','',0,'',0,'N'),(111,109,'Video Games','','',0,0,0,'','','','',0,'',0,'N'),(112,109,'Other Arcade Machines','','',0,0,0,'','','','',0,'',0,'N'),(113,57,'Classic Gaming','','',10001,0,0,'','','','',0,'>',0,'N'),(114,113,'Atari Jaguar','','',0,0,0,'','','','',0,'>',0,'N'),(115,113,'Atari Lynx','','',0,0,0,'','','','',0,'>',0,'N'),(116,113,'NES','','',0,0,0,'','','','',0,'>',0,'N'),(117,113,'SEGA Game Gear','','',0,0,0,'','','','',0,'>',0,'N'),(118,113,'SEGA Mega Drive','','',0,0,0,'','','','',0,'>',0,'N'),(119,113,'SEGA Master System','','',0,0,0,'','','','',0,'>',0,'N'),(120,113,'SEGA Saturn','','',0,0,0,'','','','',0,'>',0,'N'),(122,113,'Super Nintendo','','',0,0,0,'','','','',0,'>',0,'N'),(123,113,'Other','','',0,0,0,'','','','',0,'',0,'N'),(137,57,'Merchandise & Magazines','','',10002,0,0,'','','','',0,'>',0,'N'),(129,57,'Nintendo Gameboy Colour','','',10005,0,0,'','','','',0,'>',0,'N'),(130,129,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(131,129,'Games','','',0,0,0,'','','','',0,'',0,'N'),(132,129,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(133,57,'Nintendo Gamecube','','',10006,0,0,'','','','',0,'>',0,'N'),(134,133,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(135,133,'Games','','',0,0,0,'','','','',0,'',0,'N'),(136,133,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(138,137,'Books','','',0,0,0,'','','','',0,'',0,'N'),(139,137,'Guides','','',0,0,0,'','','','',0,'',0,'N'),(140,137,'Magazines','','',0,0,0,'','','','',0,'',0,'N'),(141,137,'Models & Figures','','',0,0,0,'','','','',0,'',0,'N'),(142,137,'Other','','',0,0,0,'','','','',0,'',0,'N'),(143,57,'Nintendo 64','','',10003,0,0,'','','','',0,'>',0,'N'),(144,143,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(145,143,'Games','','',0,0,0,'','','','',0,'>',0,'N'),(146,143,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(147,145,'Action','','',0,0,0,'','','','',0,'',0,'N'),(148,145,'Fighting','','',0,0,0,'','','','',0,'',0,'N'),(149,145,'Platform','','',0,0,0,'','','','',0,'',0,'N'),(150,145,'Racing','','',0,0,0,'','','','',0,'',0,'N'),(151,145,'Roleplaying','','',0,0,0,'','','','',0,'',0,'N'),(152,145,'Shoot-Em-Up','','',0,0,0,'','','','',0,'',0,'N'),(153,145,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(154,145,'Strategy','','',0,0,0,'','','','',0,'',0,'N'),(155,145,'Other Nintendo 64 Games','','',0,0,0,'','','','',0,'',0,'N'),(168,156,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(169,156,'Strategy','','',0,0,0,'','','','',0,'',0,'N'),(170,156,'Other PC Games','','',0,0,0,'','','','',0,'',0,'N'),(171,114,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(172,114,'Games','','',0,0,0,'','','','',0,'',0,'N'),(173,114,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(174,115,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(175,115,'Games','','',0,0,0,'','','','',0,'',0,'N'),(176,115,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(177,116,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(178,116,'Games','','',0,0,0,'','','','',0,'',0,'N'),(179,116,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(180,117,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(181,117,'Games','','',0,0,0,'','','','',0,'',0,'N'),(182,117,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(183,119,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(184,119,'Games','','',0,0,0,'','','','',0,'',0,'N'),(185,119,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(186,118,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(187,118,'Games','','',0,0,0,'','','','',0,'',0,'N'),(188,118,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(189,120,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(190,120,'Games','','',0,0,0,'','','','',0,'',0,'N'),(191,120,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(195,122,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(196,122,'Games','','',0,0,0,'','','','',0,'',0,'N'),(197,122,'Consoles','','',0,0,0,'','','','',0,'',0,'N'),(198,57,'SEGA Dreamcast','','',10008,0,0,'','','','',0,'>',0,'N'),(199,198,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(200,198,'Games','','',0,0,0,'','','','',0,'>',0,'N'),(201,198,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(202,200,'Action','','',0,0,0,'','','','',0,'',0,'N'),(203,200,'Fighting','','',0,0,0,'','','','',0,'',0,'N'),(204,200,'Platform','','',0,0,0,'','','','',0,'',0,'N'),(205,200,'Racing','','',0,0,0,'','','','',0,'',0,'N'),(206,200,'Roleplaying','','',0,0,0,'','','','',0,'',0,'N'),(207,200,'Shoot-Em-Up','','',0,0,0,'','','','',0,'',0,'N'),(208,200,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(209,200,'Strategy','','',0,0,0,'','','','',0,'',0,'N'),(210,200,'Other SEGA Dreamcast Games','','',0,0,0,'','','','',0,'',0,'N'),(211,199,'Control Pads','','',0,0,0,'','','','',0,'',0,'N'),(212,199,'VMU's','','',0,0,0,'','','','',0,'',0,'N'),(213,199,'Other Accessories','','',0,0,0,'','','','',0,'',0,'N'),(215,0,'Antiques & Art','','',1,0,0,'','','','',-1,'>',0,'N'),(216,215,'20th Century Antiques','','',0,0,0,'','','','',0,'>',0,'N'),(217,216,'1920's','','',0,0,0,'','','','',0,'',0,'N'),(218,216,'1930's','','',0,0,0,'','','','',0,'',0,'N'),(219,216,'1940's','','',0,0,0,'','','','',0,'',0,'N'),(220,216,'1950's','','',0,0,0,'','','','',0,'',0,'N'),(221,216,'1960's','','',0,0,0,'','','','',0,'',0,'N'),(222,216,'1970's','','',0,0,0,'','','','',0,'',0,'N'),(223,216,'Other','','',0,0,0,'','','','',0,'',0,'N'),(224,216,'Modern','','',0,0,0,'','','','',0,'',0,'N'),(225,215,'Antiquities','','',0,0,0,'','','','',0,'',0,'N'),(226,215,'Architectural','','',0,0,0,'','','','',0,'>',0,'N'),(227,226,'Garden','','',0,0,0,'','','','',0,'',0,'N'),(228,226,'Other','','',0,0,0,'','','','',0,'',0,'N'),(229,215,'Art','','',0,0,0,'','','','',0,'>',0,'N'),(230,229,'Contemporary Art','','',0,0,0,'','','','',0,'',0,'N'),(231,229,'General','','',0,0,0,'','','','',0,'',0,'N'),(232,229,'Drawings','','',0,0,0,'','','','',0,'',0,'N'),(233,229,'Paintings','','',0,0,0,'','','','',0,'',0,'N'),(234,229,'Photographic Images','','',0,0,0,'','','','',0,'',0,'N'),(235,229,'Prints','','',0,0,0,'','','','',0,'',0,'N'),(236,229,'Sculptures','','',0,0,0,'','','','',0,'',0,'N'),(237,229,'Other','','',0,0,0,'','','','',0,'',0,'N'),(238,215,'Books/Manuscripts','','',0,0,0,'','','','',0,'',0,'N'),(239,215,'Ceramics','','',0,0,0,'','','','',0,'',0,'N'),(240,215,'Clocks','','',0,0,0,'','','','',0,'',0,'N'),(241,215,'Decorative Items','','',0,0,0,'','','','',0,'',0,'N'),(242,215,'Folk Art','','',0,0,0,'','','','',0,'',0,'N'),(243,215,'Furniture','','',0,0,0,'','','','',0,'',0,'N'),(244,215,'Maps/Atlases','','',0,0,0,'','','','',0,'',0,'N'),(245,215,'Metalware','','',0,0,0,'','','','',0,'>',0,'N'),(246,245,'General','','',0,0,0,'','','','',0,'',0,'N'),(247,245,'Brass','','',0,0,0,'','','','',0,'',0,'N'),(248,245,'Bronze','','',0,0,0,'','','','',0,'',0,'N'),(249,245,'Copper','','',0,0,0,'','','','',0,'',0,'N'),(250,245,'Gold','','',0,0,0,'','','','',0,'',0,'N'),(251,245,'Pewter','','',0,0,0,'','','','',0,'',0,'N'),(253,245,'Silver Plated','','',0,0,0,'','','','',0,'',0,'N'),(254,245,'Musical Instruments','','',0,0,0,'','','','',0,'',0,'N'),(255,215,'Foreign Art','','',0,0,0,'','','','',0,'',0,'N'),(256,215,'Textiles/Linens','','',0,0,0,'','','','',0,'>',0,'N'),(257,256,'Embroidery','','',0,0,0,'','','','',0,'',0,'N'),(258,256,'Fabric','','',0,0,0,'','','','',0,'',0,'N'),(259,256,'Linens','','',0,0,0,'','','','',0,'',0,'N'),(260,256,'Quilts','','',0,0,0,'','','','',0,'',0,'N'),(261,256,'Other','','',0,0,0,'','','','',0,'',0,'N'),(262,215,'Woodenware','','',0,0,0,'','','','',0,'',0,'N'),(263,0,'Automobiles & Bikes','','',2,0,0,'','','','',0,'>',0,'N'),(264,263,'Cars','','',0,0,0,'','','','',0,'>',0,'N'),(265,264,'Alfa Romeo','','',0,0,0,'','','','',0,'',0,'N'),(266,264,'Audi','','',0,0,0,'','','','',0,'',0,'N'),(267,264,'BMW','','',0,0,0,'','','','',0,'',0,'N'),(268,264,'Citroen','','',0,0,0,'','','','',0,'',0,'N'),(269,264,'Chrysler & Jeep','','',0,0,0,'','','','',0,'',0,'N'),(270,264,'Daewoo','','',0,0,0,'','','','',0,'',0,'N'),(271,264,'Fiat','','',0,0,0,'','','','',0,'',0,'N'),(272,264,'Ford','','',0,0,0,'','','','',0,'',0,'N'),(273,264,'Honda','','',0,0,0,'','','','',0,'',0,'N'),(274,264,'Hyundai','','',0,0,0,'','','','',0,'',0,'N'),(275,264,'Jaguar','','',0,0,0,'','','','',0,'',0,'N'),(276,264,'Land Rover','','',0,0,0,'','','','',0,'',0,'N'),(277,264,'Mazda','','',0,0,0,'','','','',0,'',0,'N'),(278,264,'Mercedes Benz','','',0,0,0,'','','','',0,'',0,'N'),(279,264,'Nissan','','',0,0,0,'','','','',0,'',0,'N'),(280,264,'Mitsubishi','','',0,0,0,'','','','',0,'',0,'N'),(281,264,'Porsche','','',0,0,0,'','','','',0,'',0,'N'),(282,264,'Peugeot','','',0,0,0,'','','','',0,'',0,'N'),(283,264,'Range Rover','','',0,0,0,'','','','',0,'',0,'N'),(284,264,'Renault','','',0,0,0,'','','','',0,'',0,'N'),(285,264,'Rover','','',0,0,0,'','','','',0,'',0,'N'),(286,264,'MG','','',0,0,0,'','','','',0,'',0,'N'),(287,264,'Saab','','',0,0,0,'','','','',0,'',0,'N'),(288,264,'Seat','','',0,0,0,'','','','',0,'',0,'N'),(289,264,'Subaru','','',0,0,0,'','','','',0,'',0,'N'),(290,264,'Suzuki','','',0,0,0,'','','','',0,'',0,'N'),(291,264,'Toyota','','',0,0,0,'','','','',0,'',0,'N'),(292,264,'Vauxhall & Opel','','',0,0,0,'','','','',0,'',0,'N'),(293,264,'Volkswagen','','',0,0,0,'','','','',0,'',0,'N'),(294,264,'Volvo','','',0,0,0,'','','','',0,'',0,'N'),(295,264,'Kit Cars','','',0,0,0,'','','','',0,'',0,'N'),(296,264,'Import','','',0,0,0,'','','','',0,'',0,'N'),(297,264,'Other','','',0,0,0,'','','','',0,'',0,'N'),(298,263,'Car Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(299,298,'Car Care','','',0,0,0,'','','','',0,'',0,'N'),(300,298,'Garage Equipment & Tools','','',0,0,0,'','','','',0,'',0,'N'),(301,298,'Exterior Items','','',0,0,0,'','','','',0,'',0,'N'),(302,298,'Interior Items','','',0,0,0,'','','','',0,'',0,'N'),(303,298,'Performance & Tuning Itmes','','',0,0,0,'','','','',0,'',0,'N'),(304,298,'Lights & Lighting Accessories','','',0,0,0,'','','','',0,'',0,'N'),(305,298,'Manuals','','',0,0,0,'','','','',0,'',0,'N'),(306,298,'Security Itmes','','',0,0,0,'','','','',0,'',0,'N'),(307,298,'Wheel, Tyres & Trims','','',0,0,0,'','','','',0,'',0,'N'),(308,298,'Other','','',0,0,0,'','','','',0,'',0,'N'),(309,263,'Car Navigation/Electricals','','',0,0,0,'','','','',0,'>',0,'N'),(310,309,'Satellite Navigation','','',0,0,0,'','','','',0,'',0,'N'),(311,309,'In Car DVD','','',0,0,0,'','','','',0,'',0,'N'),(312,309,'In Car Gaming','','',0,0,0,'','','','',0,'',0,'N'),(313,309,'In Car TV','','',0,0,0,'','','','',0,'',0,'N'),(314,309,'Other','','',0,0,0,'','','','',0,'',0,'N'),(315,263,'Audio Items','','',0,0,0,'','','','',0,'>',0,'N'),(316,315,'Amplifiers','','',0,0,0,'','','','',0,'',0,'N'),(317,315,'Cassette Players','','',0,0,0,'','','','',0,'',0,'N'),(318,315,'CD Changers','','',0,0,0,'','','','',0,'',0,'N'),(319,315,'CD Players','','',0,0,0,'','','','',0,'',0,'N'),(320,315,'Speakers','','',0,0,0,'','','','',0,'',0,'N'),(321,315,'Other','','',0,0,0,'','','','',0,'',0,'N'),(322,263,'Classic Cars','','',0,0,0,'','','','',0,'>',0,'N'),(323,322,'Alfa Romeo','','',0,0,0,'','','','',0,'',0,'N'),(324,322,'American','','',0,0,0,'','','','',0,'',0,'N'),(325,322,'Austin','','',0,0,0,'','','','',0,'',0,'N'),(326,322,'BMW','','',0,0,0,'','','','',0,'',0,'N'),(327,322,'Daimler','','',0,0,0,'','','','',0,'',0,'N'),(328,322,'Ford','','',0,0,0,'','','','',0,'',0,'N'),(329,322,'Jaguar','','',0,0,0,'','','','',0,'',0,'N'),(330,322,'Lotus','','',0,0,0,'','','','',0,'',0,'N'),(331,322,'Mercedes Benz','','',0,0,0,'','','','',0,'',0,'N'),(332,322,'MG','','',0,0,0,'','','','',0,'',0,'N'),(333,322,'Porsche','','',0,0,0,'','','','',0,'',0,'N'),(334,322,'Rover','','',0,0,0,'','','','',0,'',0,'N'),(335,322,'Triumph','','',0,0,0,'','','','',0,'',0,'N'),(336,322,'Volkswagen','','',0,0,0,'','','','',0,'',0,'N'),(337,322,'Other','','',0,0,0,'','','','',0,'',0,'N'),(338,263,'Motorbikes','','',0,0,0,'','','','',0,'>',0,'N'),(339,338,'BMW','','',0,0,0,'','','','',0,'',0,'N'),(340,338,'Ducati','','',0,0,0,'','','','',0,'',0,'N'),(341,338,'Harley Davidson','','',0,0,0,'','','','',0,'',0,'N'),(342,338,'Honda','','',0,0,0,'','','','',0,'',0,'N'),(343,338,'Kawasaki','','',0,0,0,'','','','',0,'',0,'N'),(344,338,'Suzuki','','',0,0,0,'','','','',0,'',0,'N'),(345,338,'Yamaha','','',0,0,0,'','','','',0,'',0,'N'),(346,338,'Other','','',0,0,0,'','','','',0,'',0,'N'),(347,263,'Car Numberplates','','',0,0,0,'','','','',0,'',0,'N'),(348,263,'Other Vehicles','','',0,0,0,'','','','',0,'>',0,'N'),(349,348,'Boats & Watercraft','','',0,0,0,'','','','',0,'',0,'N'),(350,348,'Campers & Caravans','','',0,0,0,'','','','',0,'',0,'N'),(351,348,'Commercial Vehicles','','',0,0,0,'','','','',0,'',0,'N'),(352,348,'Disabled Vehicles','','',0,0,0,'','','','',0,'',0,'N'),(353,348,'Trailers','','',0,0,0,'','','','',0,'',0,'N'),(354,348,'Other','','',0,0,0,'','','','',0,'',0,'N'),(355,0,'Books','','',3,0,0,'','','','',0,'>',0,'N'),(356,355,'Annuals','','',0,0,0,'','','','',0,'>',0,'N'),(357,356,'Beano','','',0,0,0,'','','','',0,'',0,'N'),(358,356,'Blue Peter','','',0,0,0,'','','','',0,'',0,'N'),(359,356,'Bunty','','',0,0,0,'','','','',0,'',0,'N'),(360,356,'Dandy','','',0,0,0,'','','','',0,'',0,'N'),(361,356,'Dr Who','','',0,0,0,'','','','',0,'',0,'N'),(362,356,'Roy Of The Rovers','','',0,0,0,'','','','',0,'',0,'N'),(363,356,'Shoot','','',0,0,0,'','','','',0,'',0,'N'),(364,356,'Star Trek','','',0,0,0,'','','','',0,'',0,'N'),(365,356,'TV & Film','','',0,0,0,'','','','',0,'',0,'N'),(366,356,'Viz','','',0,0,0,'','','','',0,'',0,'N'),(367,356,'Other','','',0,0,0,'','','','',0,'',0,'N'),(368,355,'Rare Books','','',0,0,0,'','','','',0,'>',0,'N'),(369,368,'Exploration & Travel','','',0,0,0,'','','','',0,'',0,'N'),(370,368,'Literature','','',0,0,0,'','','','',0,'',0,'N'),(371,368,'History','','',0,0,0,'','','','',0,'',0,'N'),(372,368,'Motoring','','',0,0,0,'','','','',0,'',0,'N'),(373,368,'Religion','','',0,0,0,'','','','',0,'',0,'N'),(374,368,'War/Military','','',0,0,0,'','','','',0,'',0,'N'),(375,368,'Other','','',0,0,0,'','','','',0,'',0,'N'),(376,355,'Audio Books','','',0,0,0,'','','','',0,'>',0,'N'),(377,376,'CD's','','',0,0,0,'','','','',0,'',0,'N'),(378,376,'Tapes','','',0,0,0,'','','','',0,'',0,'N'),(379,355,'Children Books','','',0,0,0,'','','','',0,'>',0,'N'),(380,379,'Classics','','',0,0,0,'','','','',0,'',0,'N'),(381,379,'Colouring Books','','',0,0,0,'','','','',0,'',0,'N'),(382,379,'Early Books','','',0,0,0,'','','','',0,'',0,'N'),(383,379,'Fairy Tales','','',0,0,0,'','','','',0,'',0,'N'),(384,379,'Ladybird','','',0,0,0,'','','','',0,'',0,'N'),(385,379,'Non Fiction','','',0,0,0,'','','','',0,'',0,'N'),(386,379,'Picture Books','','',0,0,0,'','','','',0,'',0,'N'),(387,379,'Pop-Up Books','','',0,0,0,'','','','',0,'',0,'N'),(388,379,'Teenage Books','','',0,0,0,'','','','',0,'',0,'N'),(389,379,'School Books','','',0,0,0,'','','','',0,'',0,'N'),(390,379,'Other','','',0,0,0,'','','','',0,'',0,'N'),(391,355,'Cookery Books','','',0,0,0,'','','','',0,'>',0,'N'),(392,391,'Baking','','',0,0,0,'','','','',0,'',0,'N'),(393,391,'Learning To Cook','','',0,0,0,'','','','',0,'',0,'N'),(394,391,'Healthy Cooking','','',0,0,0,'','','','',0,'',0,'N'),(395,391,'Traditional','','',0,0,0,'','','','',0,'',0,'N'),(396,391,'Vegetarian','','',0,0,0,'','','','',0,'',0,'N'),(397,391,'Other','','',0,0,0,'','','','',0,'',0,'N'),(398,355,'Educational Books','','',0,0,0,'','','','',0,'>',0,'N'),(399,398,'Business & Finance','','',0,0,0,'','','','',0,'',0,'N'),(400,398,'Computing','','',0,0,0,'','','','',0,'',0,'N'),(401,398,'Internet','','',0,0,0,'','','','',0,'',0,'N'),(402,398,'Design & Technology','','',0,0,0,'','','','',0,'',0,'N'),(403,398,'Drama & Media','','',0,0,0,'','','','',0,'',0,'N'),(404,398,'Health','','',0,0,0,'','','','',0,'',0,'N'),(405,398,'History','','',0,0,0,'','','','',0,'',0,'N'),(406,398,'Politics','','',0,0,0,'','','','',0,'',0,'N'),(407,398,'Language','','',0,0,0,'','','','',0,'',0,'N'),(408,398,'Legal & Law','','',0,0,0,'','','','',0,'',0,'N'),(409,398,'Maths','','',0,0,0,'','','','',0,'',0,'N'),(410,398,'Psychology','','',0,0,0,'','','','',0,'',0,'N'),(411,398,'Self Help','','',0,0,0,'','','','',0,'',0,'N'),(412,398,'Sports Science','','',0,0,0,'','','','',0,'',0,'N'),(413,398,'Other','','',0,0,0,'','','','',0,'',0,'N'),(414,355,'Fiction','','',0,0,0,'','','','',0,'>',0,'N'),(415,414,'Adventure','','',0,0,0,'','','','',0,'',0,'N'),(416,414,'Fantasy','','',0,0,0,'','','','',0,'',0,'N'),(417,414,'Horror','','',0,0,0,'','','','',0,'',0,'N'),(418,414,'Humour','','',0,0,0,'','','','',0,'',0,'N'),(419,414,'Military','','',0,0,0,'','','','',0,'',0,'N'),(420,414,'Mystery','','',0,0,0,'','','','',0,'',0,'N'),(421,414,'Plays, Screen Plays','','',0,0,0,'','','','',0,'',0,'N'),(422,414,'Romance','','',0,0,0,'','','','',0,'',0,'N'),(423,414,'Sci-Fi','','',0,0,0,'','','','',0,'',0,'N'),(424,414,'Thriller','','',0,0,0,'','','','',0,'',0,'N'),(425,414,'Other','','',0,0,0,'','','','',0,'',0,'N'),(426,355,'Magazines','','',0,0,0,'','','','',0,'>',0,'N'),(427,426,'Aviation','','',0,0,0,'','','','',0,'',0,'N'),(428,426,'Boating & Sailing','','',0,0,0,'','','','',0,'',0,'N'),(429,426,'Cars','','',0,0,0,'','','','',0,'',0,'N'),(430,426,'Celebrity','','',0,0,0,'','','','',0,'',0,'N'),(431,426,'Children','','',0,0,0,'','','','',0,'',0,'N'),(432,426,'Collector','','',0,0,0,'','','','',0,'',0,'N'),(433,426,'Computer','','',0,0,0,'','','','',0,'',0,'N'),(434,426,'Cooking','','',0,0,0,'','','','',0,'',0,'N'),(435,426,'Hobby','','',0,0,0,'','','','',0,'',0,'N'),(436,426,'Health & Fitness','','',0,0,0,'','','','',0,'',0,'N'),(437,426,'Home & Garden','','',0,0,0,'','','','',0,'',0,'N'),(438,426,'Horror','','',0,0,0,'','','','',0,'',0,'N'),(439,426,'Men','','',0,0,0,'','','','',0,'',0,'N'),(440,426,'Movies','','',0,0,0,'','','','',0,'',0,'N'),(441,426,'TV','','',0,0,0,'','','','',0,'',0,'N'),(442,426,'Music','','',0,0,0,'','','','',0,'',0,'N'),(443,426,'National Geographic','','',0,0,0,'','','','',0,'',0,'N'),(444,426,'Nature','','',0,0,0,'','','','',0,'',0,'N'),(445,426,'News','','',0,0,0,'','','','',0,'',0,'N'),(446,426,'Photography','','',0,0,0,'','','','',0,'',0,'N'),(447,426,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(448,426,'Travel','','',0,0,0,'','','','',0,'',0,'N'),(449,426,'True Crime','','',0,0,0,'','','','',0,'',0,'N'),(450,426,'Women','','',0,0,0,'','','','',0,'',0,'N'),(451,426,'Other','','',0,0,0,'','','','',0,'',0,'N'),(452,355,'Non Fiction','','',0,0,0,'','','','',0,'>',0,'N'),(453,452,'Collectables','','',0,0,0,'','','','',0,'',0,'N'),(454,452,'Entertainment','','',0,0,0,'','','','',0,'',0,'N'),(455,452,'Gardening','','',0,0,0,'','','','',0,'',0,'N'),(456,452,'Feng Shui','','',0,0,0,'','','','',0,'',0,'N'),(457,452,'Geography','','',0,0,0,'','','','',0,'',0,'N'),(458,452,'History','','',0,0,0,'','','','',0,'',0,'N'),(459,452,'Home & Garden','','',0,0,0,'','','','',0,'',0,'N'),(460,452,'Military','','',0,0,0,'','','','',0,'',0,'N'),(461,452,'Motoring','','',0,0,0,'','','','',0,'',0,'N'),(462,452,'Nature','','',0,0,0,'','','','',0,'',0,'N'),(463,452,'Paranormal','','',0,0,0,'','','','',0,'',0,'N'),(464,452,'Parenting','','',0,0,0,'','','','',0,'',0,'N'),(465,452,'Pets & Pet Care','','',0,0,0,'','','','',0,'',0,'N'),(466,452,'Religon','','',0,0,0,'','','','',0,'',0,'N'),(467,452,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(468,452,'Travel','','',0,0,0,'','','','',0,'',0,'N'),(469,452,'Crime','','',0,0,0,'','','','',0,'',0,'N'),(470,452,'TV & Film','','',0,0,0,'','','','',0,'',0,'N'),(471,452,'Other','','',0,0,0,'','','','',0,'',0,'N'),(472,355,'Poetry','','',0,0,0,'','','','',0,'',0,'N'),(473,355,'Other','','',0,0,0,'','','','',0,'',0,'N'),(474,0,'Clothing & Accessories','','',5,0,0,'','','','',0,'>',0,'N'),(475,474,'Fancy Dress','','',0,0,0,'','','','',0,'>',0,'N'),(476,475,'Children','','',0,0,0,'','','','',0,'',0,'N'),(477,475,'Adult','','',0,0,0,'','','','',0,'',0,'N'),(478,474,'Boys','','',0,0,0,'','','','',0,'>',0,'N'),(479,478,'2-5 Year Olds','','',0,0,0,'','','','',0,'>',0,'N'),(480,479,'Tops','','',0,0,0,'','','','',0,'',0,'N'),(481,479,'Bottoms','','',0,0,0,'','','','',0,'',0,'N'),(493,491,'2-5 Year Olds','','',0,0,0,'','','','',0,'>',0,'N'),(492,478,'6-8 Year Olds','','',0,0,0,'','','','',0,'',0,'N'),(485,478,'9+ Year Olds','','',0,0,0,'','','','',0,'>',0,'N'),(486,485,'Tops','','',0,0,0,'','','','',0,'',0,'N'),(487,485,'Bottoms','','',0,0,0,'','','','',0,'',0,'N'),(488,478,'School Uniform','','',0,0,0,'','','','',0,'',0,'N'),(489,478,'Shoes','','',0,0,0,'','','','',0,'',0,'N'),(490,478,'Teenagers','','',0,0,0,'','','','',0,'',0,'N'),(491,474,'Girls','','',0,0,0,'','','','',0,'>',0,'N'),(494,493,'Bottoms','','',0,0,0,'','','','',0,'',0,'N'),(495,493,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(496,493,'Skirts','','',0,0,0,'','','','',0,'',0,'N'),(497,493,'Other','','',0,0,0,'','','','',0,'',0,'N'),(498,491,'6-8 Year Olds','','',0,0,0,'','','','',0,'>',0,'N'),(499,498,'Bottoms','','',0,0,0,'','','','',0,'',0,'N'),(500,498,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(501,498,'Skirts','','',0,0,0,'','','','',0,'',0,'N'),(502,498,'Other','','',0,0,0,'','','','',0,'',0,'N'),(503,491,'9+ Years Old','','',0,0,0,'','','','',0,'>',0,'N'),(504,503,'Bottoms','','',0,0,0,'','','','',0,'',0,'N'),(505,503,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(506,503,'Skirts','','',0,0,0,'','','','',0,'',0,'N'),(507,503,'Others','','',0,0,0,'','','','',0,'',0,'N'),(508,491,'School Uniform','','',0,0,0,'','','','',0,'',0,'N'),(509,491,'Shoes','','',0,0,0,'','','','',0,'',0,'N'),(510,491,'Teenagers','','',0,0,0,'','','','',0,'',0,'N'),(511,474,'Men's Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(512,511,'Bags, Belts, Wallets','','',0,0,0,'','','','',0,'',0,'N'),(513,511,'Hats','','',0,0,0,'','','','',0,'',0,'N'),(514,511,'Sunglasses','','',0,0,0,'','','','',0,'',0,'N'),(515,511,'Other','','',0,0,0,'','','','',0,'',0,'N'),(516,474,'Men's Casualwear','','',0,0,0,'','','','',0,'>',0,'N'),(517,516,'Casual Shirts','','',0,0,0,'','','','',0,'>',0,'N'),(518,516,'Denim','','',0,0,0,'','','','',0,'>',0,'N'),(519,517,'Ben Sherman','','',0,0,0,'','','','',0,'',0,'N'),(520,517,'Burberry','','',0,0,0,'','','','',0,'',0,'N'),(521,517,'French Connection','','',0,0,0,'','','','',0,'',0,'N'),(522,517,'Ralph Lauren','','',0,0,0,'','','','',0,'',0,'N'),(523,517,'Ted Baker','','',0,0,0,'','','','',0,'',0,'N'),(524,517,'YSL','','',0,0,0,'','','','',0,'',0,'N'),(525,517,'Other','','',0,0,0,'','','','',0,'',0,'N'),(526,518,'Armani','','',0,0,0,'','','','',0,'',0,'N'),(527,518,'Diesel','','',0,0,0,'','','','',0,'',0,'N'),(528,518,'GAP','','',0,0,0,'','','','',0,'',0,'N'),(529,518,'Lee','','',0,0,0,'','','','',0,'',0,'N'),(530,518,'Levis','','',0,0,0,'','','','',0,'',0,'N'),(531,518,'Wrangler','','',0,0,0,'','','','',0,'',0,'N'),(532,518,'Other','','',0,0,0,'','','','',0,'',0,'N'),(533,516,'T-Shirts','','',0,0,0,'','','','',0,'',0,'N'),(534,516,'Trousers','','',0,0,0,'','','','',0,'',0,'N'),(535,516,'Coats & Jackets','','',0,0,0,'','','','',0,'',0,'N'),(539,474,'Men's Footwear','','',0,0,0,'','','','',0,'>',0,'N'),(538,516,'Other','','',0,0,0,'','','','',0,'',0,'N'),(540,539,'Boots','','',0,0,0,'','','','',0,'',0,'N'),(541,539,'Loafers','','',0,0,0,'','','','',0,'',0,'N'),(542,539,'Formal Shoes','','',0,0,0,'','','','',0,'',0,'N'),(543,539,'Sports Shoes','','',0,0,0,'','','','',0,'',0,'N'),(544,539,'Other','','',0,0,0,'','','','',0,'',0,'N'),(545,474,'Men's Workwear','','',0,0,0,'','','','',0,'>',0,'N'),(546,545,'Formal Shirts','','',0,0,0,'','','','',0,'',0,'N'),(547,545,'Suits','','',0,0,0,'','','','',0,'',0,'N'),(548,545,'Ties','','',0,0,0,'','','','',0,'',0,'N'),(549,545,'Trousers','','',0,0,0,'','','','',0,'',0,'N'),(550,474,'Personal Care','','',0,0,0,'','','','',0,'>',0,'N'),(551,550,'Body','','',0,0,0,'','','','',0,'',0,'N'),(552,550,'Face','','',0,0,0,'','','','',0,'',0,'N'),(553,550,'Hair','','',0,0,0,'','','','',0,'',0,'N'),(554,550,'Eyes','','',0,0,0,'','','','',0,'',0,'N'),(555,550,'Lips','','',0,0,0,'','','','',0,'',0,'N'),(556,550,'Other Make Up Items','','',0,0,0,'','','','',0,'',0,'N'),(557,550,'Men's Fragrance','','',0,0,0,'','','','',0,'',0,'N'),(558,550,'Men's Personal Care','','',0,0,0,'','','','',0,'',0,'N'),(559,550,'Women's Fragrance','','',0,0,0,'','','','',0,'',0,'N'),(561,474,'Women's Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(562,561,'Belts','','',0,0,0,'','','','',0,'',0,'N'),(563,561,'Gloves','','',0,0,0,'','','','',0,'',0,'N'),(564,561,'Pashmina & Scarves','','',0,0,0,'','','','',0,'',0,'N'),(565,561,'Sunglasses','','',0,0,0,'','','','',0,'',0,'N'),(566,561,'Wigs','','',0,0,0,'','','','',0,'',0,'N'),(567,561,'Other Accessories','','',0,0,0,'','','','',0,'',0,'N'),(568,474,'Women's Bags','','',0,0,0,'','','','',0,'>',0,'N'),(569,568,'Handbag','','',0,0,0,'','','','',0,'>',0,'N'),(570,569,'Burberry','','',0,0,0,'','','','',0,'',0,'N'),(571,569,'Gucci','','',0,0,0,'','','','',0,'',0,'N'),(572,569,'Louis Vuitton','','',0,0,0,'','','','',0,'',0,'N'),(573,569,'Prada','','',0,0,0,'','','','',0,'',0,'N'),(574,569,'Other','','',0,0,0,'','','','',0,'',0,'N'),(575,568,'Shoulderbag','','',0,0,0,'','','','',0,'>',0,'N'),(576,575,'Louis Vuitton','','',0,0,0,'','','','',0,'',0,'N'),(577,575,'Burberry','','',0,0,0,'','','','',0,'',0,'N'),(578,575,'Gucci','','',0,0,0,'','','','',0,'',0,'N'),(579,575,'Prada','','',0,0,0,'','','','',0,'',0,'N'),(580,575,'Other','','',0,0,0,'','','','',0,'',0,'N'),(581,568,'Shopping Bags','','',0,0,0,'','','','',0,'',0,'N'),(582,568,'Wallets and Purses','','',0,0,0,'','','','',0,'>',0,'N'),(583,582,'Burberry','','',0,0,0,'','','','',0,'',0,'N'),(584,582,'Accessorize','','',0,0,0,'','','','',0,'',0,'N'),(585,582,'Gucci','','',0,0,0,'','','','',0,'',0,'N'),(586,582,'Prada','','',0,0,0,'','','','',0,'',0,'N'),(587,582,'Next','','',0,0,0,'','','','',0,'',0,'N'),(588,582,'Louis Vuitton','','',0,0,0,'','','','',0,'',0,'N'),(589,582,'Other','','',0,0,0,'','','','',0,'',0,'N'),(590,474,'Women's Casualwear','','',0,0,0,'','','','',0,'>',0,'N'),(591,590,'Denim','','',0,0,0,'','','','',0,'>',0,'N'),(592,591,'Diesel','','',0,0,0,'','','','',0,'',0,'N'),(593,591,'Calvin Klein','','',0,0,0,'','','','',0,'',0,'N'),(594,591,'Levis','','',0,0,0,'','','','',0,'',0,'N'),(595,591,'Top Shop','','',0,0,0,'','','','',0,'',0,'N'),(596,591,'Other','','',0,0,0,'','','','',0,'',0,'N'),(597,590,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(598,590,'Shirts','','',0,0,0,'','','','',0,'',0,'N'),(599,590,'Shorts','','',0,0,0,'','','','',0,'',0,'N'),(600,590,'Skirts','','',0,0,0,'','','','',0,'',0,'N'),(601,590,'T-Shirts','','',0,0,0,'','','','',0,'',0,'N'),(602,590,'Tops','','',0,0,0,'','','','',0,'',0,'N'),(603,590,'Trousers','','',0,0,0,'','','','',0,'',0,'N'),(604,590,'Lingerie & Sleepwear','','',0,0,0,'','','','',0,'',0,'N'),(605,590,'Other','','',0,0,0,'','','','',0,'',0,'N'),(606,474,'Women's Eveningwear','','',0,0,0,'','','','',0,'>',0,'N'),(607,606,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(608,606,'Skirts','','',0,0,0,'','','','',0,'',0,'N'),(609,606,'Suits','','',0,0,0,'','','','',0,'',0,'N'),(610,606,'Tops','','',0,0,0,'','','','',0,'',0,'N'),(611,606,'Trousers','','',0,0,0,'','','','',0,'',0,'N'),(612,606,'Other','','',0,0,0,'','','','',0,'',0,'N'),(613,474,'Women's Workwear','','',0,0,0,'','','','',0,'>',0,'N'),(614,613,'Dresses','','',0,0,0,'','','','',0,'',0,'N'),(615,613,'Shirts','','',0,0,0,'','','','',0,'',0,'N'),(616,613,'Tops','','',0,0,0,'','','','',0,'',0,'N'),(617,613,'Trousers','','',0,0,0,'','','','',0,'',0,'N'),(618,613,'Suits','','',0,0,0,'','','','',0,'',0,'N'),(619,613,'Jackets','','',0,0,0,'','','','',0,'',0,'N'),(620,474,'Women's Coats & Jackets','','',0,0,0,'','','','',0,'>',0,'N'),(621,620,'Leather','','',0,0,0,'','','','',0,'',0,'N'),(622,620,'Suede','','',0,0,0,'','','','',0,'',0,'N'),(623,620,'Wool','','',0,0,0,'','','','',0,'',0,'N'),(624,620,'Other','','',0,0,0,'','','','',0,'',0,'N'),(626,474,'Women's Shoes','','',0,0,0,'','','','',0,'>',0,'N'),(627,626,'Sports Shoes','','',0,0,0,'','','','',0,'',0,'N'),(628,626,'Boots','','',0,0,0,'','','','',0,'',0,'N'),(629,626,'Flats','','',0,0,0,'','','','',0,'',0,'N'),(630,626,'Heels','','',0,0,0,'','','','',0,'',0,'N'),(631,626,'Mules','','',0,0,0,'','','','',0,'',0,'N'),(632,626,'Sandals','','',0,0,0,'','','','',0,'',0,'N'),(633,626,'Other','','',0,0,0,'','','','',0,'',0,'N'),(634,0,'Coins','','',6,0,0,'','','','',0,'>',0,'N'),(635,634,'British Coins','','',0,0,0,'','','','',0,'>',0,'N'),(636,634,'World Coins','','',0,0,0,'','','','',0,'>',0,'N'),(637,634,'UK Paper Money','','',0,0,0,'','','','',0,'',0,'N'),(638,634,'US Paper Money','','',0,0,0,'','','','',0,'',0,'N'),(639,634,'World Paper Money','','',0,0,0,'','','','',0,'>',0,'N'),(640,635,'1/2 Crown','','',0,0,0,'','','','',0,'',0,'N'),(641,635,'1/2 Penny','','',0,0,0,'','','','',0,'',0,'N'),(642,635,'2 Shilling','','',0,0,0,'','','','',0,'',0,'N'),(643,635,'2 Pence','','',0,0,0,'','','','',0,'',0,'N'),(644,635,'3 Pence','','',0,0,0,'','','','',0,'',0,'N'),(645,635,'4 Pence','','',0,0,0,'','','','',0,'',0,'N'),(646,635,'6 Pence','','',0,0,0,'','','','',0,'',0,'N'),(647,635,'Collections','','',0,0,0,'','','','',0,'',0,'N'),(648,635,'Commemorative','','',0,0,0,'','','','',0,'',0,'N'),(649,635,'Gold','','',0,0,0,'','','','',0,'',0,'N'),(650,635,'Other','','',0,0,0,'','','','',0,'',0,'N'),(651,636,'Ancient','','',0,0,0,'','','','',0,'',0,'N'),(652,636,'Europe','','',0,0,0,'','','','',0,'',0,'N'),(653,636,'Commemorative','','',0,0,0,'','','','',0,'',0,'N'),(654,636,'Other','','',0,0,0,'','','','',0,'',0,'N'),(655,639,'Africa','','',0,0,0,'','','','',0,'',0,'N'),(656,639,'Asia','','',0,0,0,'','','','',0,'',0,'N'),(657,639,'Australia','','',0,0,0,'','','','',0,'',0,'N'),(658,639,'Canada','','',0,0,0,'','','','',0,'',0,'N'),(659,639,'China','','',0,0,0,'','','','',0,'',0,'N'),(660,639,'Europe','','',0,0,0,'','','','',0,'',0,'N'),(661,639,'France','','',0,0,0,'','','','',0,'',0,'N'),(662,639,'Germany','','',0,0,0,'','','','',0,'',0,'N'),(663,639,'Israel','','',0,0,0,'','','','',0,'',0,'N'),(664,639,'Ireland','','',0,0,0,'','','','',0,'',0,'N'),(665,639,'Korea','','',0,0,0,'','','','',0,'',0,'N'),(666,639,'Mexico','','',0,0,0,'','','','',0,'',0,'N'),(667,639,'Russia','','',0,0,0,'','','','',0,'',0,'N'),(668,639,'Sweeden','','',0,0,0,'','','','',0,'',0,'N'),(669,0,'Collectables','','',7,0,0,'','','','',0,'>',0,'N'),(670,669,'Advertising','','',0,0,0,'','','','',0,'>',0,'N'),(671,670,'General','','',0,0,0,'','','','',0,'',0,'N'),(672,670,'Aeronautica','','',0,0,0,'','','','',0,'',0,'N'),(673,670,'Bakery','','',0,0,0,'','','','',0,'',0,'N'),(674,670,'Bus','','',0,0,0,'','','','',0,'',0,'N'),(675,670,'Confectionary','','',0,0,0,'','','','',0,'',0,'N'),(676,670,'Chemist','','',0,0,0,'','','','',0,'',0,'N'),(677,670,'Cigarette','','',0,0,0,'','','','',0,'',0,'N'),(678,670,'Dairy','','',0,0,0,'','','','',0,'',0,'N'),(679,670,'Distillery','','',0,0,0,'','','','',0,'',0,'N'),(680,670,'Fashion','','',0,0,0,'','','','',0,'',0,'N'),(681,670,'Food','','',0,0,0,'','','','',0,'',0,'N'),(682,670,'Labels','','',0,0,0,'','','','',0,'',0,'N'),(683,670,'Petrol','','',0,0,0,'','','','',0,'',0,'N'),(684,670,'Radio','','',0,0,0,'','','','',0,'',0,'N'),(685,670,'Signs','','',0,0,0,'','','','',0,'',0,'N'),(686,670,'Soft Drinks','','',0,0,0,'','','','',0,'',0,'N'),(687,670,'Tins','','',0,0,0,'','','','',0,'',0,'N'),(688,670,'Other','','',0,0,0,'','','','',0,'',0,'N'),(689,669,'Animals','','',0,0,0,'','','','',0,'>',0,'N'),(690,689,'General','','',0,0,0,'','','','',0,'',0,'N'),(691,689,'Bird','','',0,0,0,'','','','',0,'',0,'N'),(692,689,'Cat','','',0,0,0,'','','','',0,'',0,'N'),(693,689,'Dog','','',0,0,0,'','','','',0,'',0,'N'),(694,689,'Dinosaur','','',0,0,0,'','','','',0,'',0,'N'),(695,689,'Fish','','',0,0,0,'','','','',0,'',0,'N'),(696,689,'Farm','','',0,0,0,'','','','',0,'',0,'N'),(697,689,'Horse','','',0,0,0,'','','','',0,'',0,'N'),(698,689,'Reptile','','',0,0,0,'','','','',0,'',0,'N'),(699,689,'Wildlife','','',0,0,0,'','','','',0,'',0,'N'),(700,669,'Art','','',0,0,0,'','','','',0,'>',0,'N'),(701,700,'General','','',0,0,0,'','','','',0,'',0,'N'),(702,700,'Decorator/Designer','','',0,0,0,'','','','',0,'',0,'N'),(703,700,'Calendars','','',0,0,0,'','','','',0,'',0,'N'),(704,700,'Paintings','','',0,0,0,'','','','',0,'',0,'N'),(705,700,'Posters','','',0,0,0,'','','','',0,'',0,'N'),(706,700,'Prints','','',0,0,0,'','','','',0,'',0,'N'),(707,669,'Autographs','','',0,0,0,'','','','',0,'>',0,'N'),(708,707,'General','','',0,0,0,'','','','',0,'',0,'N'),(709,707,'Political','','',0,0,0,'','','','',0,'',0,'N'),(710,707,'Sci-Fi','','',0,0,0,'','','','',0,'',0,'N'),(711,707,'Space','','',0,0,0,'','','','',0,'',0,'N'),(712,669,'Badges','','',0,0,0,'','','','',0,'',0,'N'),(713,669,'Bears','','',0,0,0,'','','','',0,'>',0,'N'),(714,713,'General','','',0,0,0,'','','','',0,'',0,'N'),(715,713,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(716,713,'Antique','','',0,0,0,'','','','',0,'',0,'N'),(717,713,'Cherished Teddies','','',0,0,0,'','','','',0,'',0,'N'),(718,713,'Merrythought','','',0,0,0,'','','','',0,'',0,'N'),(719,713,'Steiff','','',0,0,0,'','','','',0,'',0,'N'),(720,669,'Bottles','','',0,0,0,'','','','',0,'>',0,'N'),(721,720,'General','','',0,0,0,'','','','',0,'',0,'N'),(722,720,'Household','','',0,0,0,'','','','',0,'',0,'N'),(723,720,'Inks','','',0,0,0,'','','','',0,'',0,'N'),(724,720,'Medicines','','',0,0,0,'','','','',0,'',0,'N'),(725,720,'Miniatures','','',0,0,0,'','','','',0,'',0,'N'),(726,720,'Poisons','','',0,0,0,'','','','',0,'',0,'N'),(727,720,'Soft Drinks','','',0,0,0,'','','','',0,'',0,'N'),(728,720,'Alcohol Bottles','','',0,0,0,'','','','',0,'',0,'N'),(729,669,'Breweriana','','',0,0,0,'','','','',0,'>',0,'N'),(730,729,'General','','',0,0,0,'','','','',0,'',0,'N'),(731,729,'Advertising','','',0,0,0,'','','','',0,'',0,'N'),(732,729,'Bottles','','',0,0,0,'','','','',0,'',0,'N'),(733,729,'Beer Mats','','',0,0,0,'','','','',0,'',0,'N'),(734,729,'Openers, Corkscrews','','',0,0,0,'','','','',0,'',0,'N'),(735,729,'Trays','','',0,0,0,'','','','',0,'',0,'N'),(736,669,'Casino','','',0,0,0,'','','','',0,'>',0,'N'),(737,736,'Dice','','',0,0,0,'','','','',0,'',0,'N'),(738,736,'Chips','','',0,0,0,'','','','',0,'',0,'N'),(739,736,'Playing Cards','','',0,0,0,'','','','',0,'',0,'N'),(740,736,'Games','','',0,0,0,'','','','',0,'',0,'N'),(741,736,'Other','','',0,0,0,'','','','',0,'',0,'N'),(742,669,'Clocks','','',0,0,0,'','','','',0,'>',0,'N'),(743,742,'General','','',0,0,0,'','','','',0,'',0,'N'),(744,742,'Wall Clocks','','',0,0,0,'','','','',0,'',0,'N'),(745,742,'Wristwatches','','',0,0,0,'','','','',0,'',0,'N'),(746,742,'Pocketwatches','','',0,0,0,'','','','',0,'',0,'N'),(747,669,'Clubs & Associations','','',0,0,0,'','','','',0,'>',0,'N'),(748,747,'General','','',0,0,0,'','','','',0,'',0,'N'),(749,747,'Boy Scouts','','',0,0,0,'','','','',0,'',0,'N'),(750,747,'Girl Scouts','','',0,0,0,'','','','',0,'',0,'N'),(751,747,'Masonic','','',0,0,0,'','','','',0,'',0,'N'),(752,747,'Salvation Army','','',0,0,0,'','','','',0,'',0,'N'),(753,669,'Plates','','',0,0,0,'','','','',0,'>',0,'N'),(754,753,'General','','',0,0,0,'','','','',0,'',0,'N'),(755,753,'Danbury Mint','','',0,0,0,'','','','',0,'',0,'N'),(756,753,'Wedgwood','','',0,0,0,'','','','',0,'',0,'N'),(757,753,'Other','','',0,0,0,'','','','',0,'',0,'N'),(758,669,'Comics','','',0,0,0,'','','','',0,'>',0,'N'),(759,758,'Comic Figurines','','',0,0,0,'','','','',0,'',0,'N'),(760,758,'Comic Magazines','','',0,0,0,'','','','',0,'',0,'N'),(761,758,'Modern','','',0,0,0,'','','','',0,'',0,'N'),(762,758,'Newspaper Comics','','',0,0,0,'','','','',0,'',0,'N'),(763,758,'Other','','',0,0,0,'','','','',0,'',0,'N'),(764,669,'Decorative','','',0,0,0,'','','','',0,'>',0,'N'),(765,764,'Hummel','','',0,0,0,'','','','',0,'',0,'N'),(766,764,'Lilliput Lane','','',0,0,0,'','','','',0,'',0,'N'),(767,764,'Royal Doulton','','',0,0,0,'','','','',0,'',0,'N'),(768,764,'Wedgwood','','',0,0,0,'','','','',0,'',0,'N'),(769,764,'Wade','','',0,0,0,'','','','',0,'',0,'N'),(770,669,'Flags','','',0,0,0,'','','','',0,'>',0,'N'),(771,770,'Rest Of World Flags','','',0,0,0,'','','','',0,'',0,'N'),(772,770,'UK Flags','','',0,0,0,'','','','',0,'',0,'N'),(773,770,'European Flags','','',0,0,0,'','','','',0,'',0,'N'),(774,770,'Club Flags','','',0,0,0,'','','','',0,'',0,'N'),(775,770,'Other','','',0,0,0,'','','','',0,'',0,'N'),(776,669,'Fridge Magnets','','',0,0,0,'','','','',0,'',0,'N'),(777,669,'Jukeboxes','','',0,0,0,'','','','',0,'',0,'N'),(778,669,'Keyrings','','',0,0,0,'','','','',0,'',0,'N'),(779,669,'Kitchenalia','','',0,0,0,'','','','',0,'>',0,'N'),(780,779,'General','','',0,0,0,'','','','',0,'',0,'N'),(781,779,'Cookware','','',0,0,0,'','','','',0,'',0,'N'),(782,779,'Egg Cups','','',0,0,0,'','','','',0,'',0,'N'),(783,779,'Salt & Pepper Pots','','',0,0,0,'','','','',0,'',0,'N'),(784,779,'Small Appliances','','',0,0,0,'','','','',0,'',0,'N'),(785,779,'Tableware','','',0,0,0,'','','','',0,'',0,'N'),(786,779,'Utensils','','',0,0,0,'','','','',0,'',0,'N'),(787,669,'Knives','','',0,0,0,'','','','',0,'>',0,'N'),(788,787,'General','','',0,0,0,'','','','',0,'',0,'N'),(789,787,'Commemorative','','',0,0,0,'','','','',0,'',0,'N'),(790,787,'Pocket','','',0,0,0,'','','','',0,'',0,'N'),(791,669,'Limited Editions','','',0,0,0,'','','','',0,'',0,'N'),(792,669,'Memorabilia','','',0,0,0,'','','','',0,'>',0,'N'),(793,792,'General','','',0,0,0,'','','','',0,'',0,'N'),(794,792,'Historical','','',0,0,0,'','','','',0,'',0,'N'),(795,792,'Magic','','',0,0,0,'','','','',0,'',0,'N'),(796,792,'Other','','',0,0,0,'','','','',0,'',0,'N'),(797,669,'Metalware','','',0,0,0,'','','','',0,'>',0,'N'),(798,797,'General','','',0,0,0,'','','','',0,'',0,'N'),(799,797,'Aluminium','','',0,0,0,'','','','',0,'',0,'N'),(800,797,'Brass','','',0,0,0,'','','','',0,'',0,'N'),(801,797,'Bronze','','',0,0,0,'','','','',0,'',0,'N'),(802,797,'Cast Iron','','',0,0,0,'','','','',0,'',0,'N'),(803,797,'Copper','','',0,0,0,'','','','',0,'',0,'N'),(804,797,'Pewter','','',0,0,0,'','','','',0,'',0,'N'),(806,797,'Silver Plated','','',0,0,0,'','','','',0,'',0,'N'),(807,669,'Militaria','','',0,0,0,'','','','',0,'>',0,'N'),(808,807,'General','','',0,0,0,'','','','',0,'',0,'N'),(809,807,'Ancient','','',0,0,0,'','','','',0,'',0,'N'),(810,807,'Pre World War 1','','',0,0,0,'','','','',0,'',0,'N'),(811,807,'World War 2','','',0,0,0,'','','','',0,'',0,'N'),(812,807,'Other','','',0,0,0,'','','','',0,'',0,'N'),(813,669,'Moneyboxes','','',0,0,0,'','','','',0,'',0,'N'),(814,669,'Modern Maps & Atlases','','',0,0,0,'','','','',0,'',0,'N'),(815,669,'Music Boxes','','',0,0,0,'','','','',0,'',0,'N'),(816,669,'Political','','',0,0,0,'','','','',0,'',0,'N'),(817,669,'Religious','','',0,0,0,'','','','',0,'',0,'N'),(818,669,'Royal Commemoratives','','',0,0,0,'','','','',0,'>',0,'N'),(819,818,'Coronation','','',0,0,0,'','','','',0,'',0,'N'),(820,818,'Jubilee','','',0,0,0,'','','','',0,'',0,'N'),(821,818,'Prince William','','',0,0,0,'','','','',0,'',0,'N'),(822,818,'Weddings','','',0,0,0,'','','','',0,'',0,'N'),(823,818,'Princess Diana','','',0,0,0,'','','','',0,'',0,'N'),(824,818,'Queen Mother','','',0,0,0,'','','','',0,'',0,'N'),(825,818,'Other','','',0,0,0,'','','','',0,'',0,'N'),(826,669,'Science Fiction','','',0,0,0,'','','','',0,'>',0,'N'),(827,826,'General','','',0,0,0,'','','','',0,'',0,'N'),(828,826,'Babylon 5','','',0,0,0,'','','','',0,'',0,'N'),(829,826,'Buffy the Vampire Slayer','','',0,0,0,'','','','',0,'',0,'N'),(830,826,'Dr. Who','','',0,0,0,'','','','',0,'',0,'N'),(831,826,'Planet of the Apes','','',0,0,0,'','','','',0,'',0,'N'),(832,826,'Star Wars','','',0,0,0,'','','','',0,'',0,'N'),(833,826,'Star Trek','','',0,0,0,'','','','',0,'',0,'N'),(834,826,'X Files','','',0,0,0,'','','','',0,'',0,'N'),(835,826,'Xena','','',0,0,0,'','','','',0,'',0,'N'),(836,826,'Other','','',0,0,0,'','','','',0,'',0,'N'),(837,669,'Tobacco Items','','',0,0,0,'','','','',0,'>',0,'N'),(838,837,'General','','',0,0,0,'','','','',0,'',0,'N'),(839,837,'Ashtrays','','',0,0,0,'','','','',0,'',0,'N'),(840,837,'Cigarette Cards','','',0,0,0,'','','','',0,'',0,'N'),(841,837,'Lighters and Vestas','','',0,0,0,'','','','',0,'',0,'N'),(842,837,'Pipes','','',0,0,0,'','','','',0,'',0,'N'),(843,669,'Snowglobes','','',0,0,0,'','','','',0,'',0,'N'),(844,669,'Souvenirs','','',0,0,0,'','','','',0,'',0,'N'),(845,669,'Trading Cards & Stickers','','',0,0,0,'','','','',0,'>',0,'N'),(846,845,'General','','',0,0,0,'','','','',0,'',0,'N'),(847,845,'Comic','','',0,0,0,'','','','',0,'',0,'N'),(848,845,'Other Non Sport','','',0,0,0,'','','','',0,'',0,'N'),(849,845,'Phone Cards','','',0,0,0,'','','','',0,'',0,'N'),(850,845,'Sci-Fi','','',0,0,0,'','','','',0,'',0,'N'),(851,845,'Sports','','',0,0,0,'','','','',0,'>',0,'N'),(852,851,'Football','','',0,0,0,'','','','',0,'',0,'N'),(853,851,'Rugby','','',0,0,0,'','','','',0,'',0,'N'),(854,851,'American Football','','',0,0,0,'','','','',0,'',0,'N'),(855,851,'Basketball','','',0,0,0,'','','','',0,'',0,'N'),(856,851,'Baseball','','',0,0,0,'','','','',0,'',0,'N'),(857,851,'Other','','',0,0,0,'','','','',0,'',0,'N'),(858,669,'Model Trains','','',0,0,0,'','','','',0,'>',0,'N'),(859,858,'General','','',0,0,0,'','','','',0,'',0,'N'),(860,858,'Hornby','','',0,0,0,'','','','',0,'',0,'N'),(861,858,'Other','','',0,0,0,'','','','',0,'',0,'N'),(862,669,'Umbrellas','','',0,0,0,'','','','',0,'',0,'N'),(863,669,'Vanity Items','','',0,0,0,'','','','',0,'>',0,'N'),(864,863,'General','','',0,0,0,'','','','',0,'',0,'N'),(865,863,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(866,863,'Compacts','','',0,0,0,'','','','',0,'',0,'N'),(867,863,'Perfumes','','',0,0,0,'','','','',0,'',0,'N'),(868,669,'Wacky Items','','',0,0,0,'','','','',0,'',0,'N'),(869,669,'Writing Instruments','','',0,0,0,'','','','',0,'>',0,'N'),(870,869,'General','','',0,0,0,'','','','',0,'',0,'N'),(871,869,'Pens','','',0,0,0,'','','','',0,'',0,'N'),(872,869,'Pencils','','',0,0,0,'','','','',0,'',0,'N'),(873,869,'Desktop Items','','',0,0,0,'','','','',0,'',0,'N'),(874,869,'Inkwells','','',0,0,0,'','','','',0,'',0,'N'),(875,869,'Other','','',0,0,0,'','','','',0,'',0,'N'),(876,869,'Miscellaneous','','',0,0,0,'','','','',0,'',0,'N'),(877,0,'Computing','','',8,0,0,'','','','',0,'>',0,'N'),(878,0,'Services','','',18,0,0,'','','','',0,'>',0,'N'),(879,878,'Internet Services','','',0,0,0,'','','','',0,'>',0,'N'),(880,879,'Domain Name Registration','','',0,0,0,'','','','',0,'',0,'N'),(881,879,'Web Hosting','','',0,0,0,'','','','',0,'',0,'N'),(882,879,'Web Design','','',0,0,0,'','','','',0,'',0,'N'),(883,878,'Offline Service','','',0,0,0,'','','','',0,'>',0,'N'),(884,883,'Printing Services','','',0,0,0,'','','','',0,'',0,'N'),(885,883,'Business Printing','','',0,0,0,'','','','',0,'',0,'N'),(886,883,'Other','','',0,0,0,'','','','',0,'',0,'N'),(887,0,'Businesses For Sale','','',4,0,0,'','','','',0,'>',0,'N'),(888,887,'Online Businesses','','',0,0,0,'','','','',0,'',0,'N'),(889,887,'Offline Businesses','','',0,0,0,'','','','',0,'',0,'N'),(890,0,'Properties','','',17,0,0,'','','','',0,'>',0,'N'),(891,890,'Private Houses','','',0,0,0,'','','','',0,'',0,'N'),(892,890,'Commercial Property','','',0,0,0,'','','','',0,'',0,'N'),(893,877,'Books','','',0,0,0,'','','','',0,'>',0,'N'),(894,893,'General','','',0,0,0,'','','','',0,'',0,'N'),(895,893,'Reference','','',0,0,0,'','','','',0,'',0,'N'),(896,893,'Software Manuals','','',0,0,0,'','','','',0,'',0,'N'),(897,877,'Components','','',0,0,0,'','','','',0,'>',0,'N'),(898,897,'Cables & Connectors','','',0,0,0,'','','','',0,'',0,'N'),(899,897,'CPU's','','',0,0,0,'','','','',0,'>',0,'N'),(900,899,'AMD Athlon','','',0,0,0,'','','','',0,'',0,'N'),(901,899,'AMD Duron','','',0,0,0,'','','','',0,'',0,'N'),(902,899,'AMD K6','','',0,0,0,'','','','',0,'',0,'N'),(903,899,'AMD Other','','',0,0,0,'','','','',0,'',0,'N'),(904,899,'Intel Celeron','','',0,0,0,'','','','',0,'',0,'N'),(908,899,'Intel Pentium IV','','',0,0,0,'','','','',0,'',0,'N'),(909,899,'Intel Other','','',0,0,0,'','','','',0,'',0,'N'),(910,899,'Other','','',0,0,0,'','','','',0,'',0,'N'),(911,897,'Fans & Heatsinks','','',0,0,0,'','','','',0,'',0,'N'),(912,897,'Graphics & Video Cards','','',0,0,0,'','','','',0,'>',0,'N'),(913,912,'AGP Cards','','',0,0,0,'','','','',0,'',0,'N'),(914,912,'PCI Cards','','',0,0,0,'','','','',0,'',0,'N'),(915,912,'TV Cards','','',0,0,0,'','','','',0,'>',0,'N'),(916,915,'AGP','','',0,0,0,'','','','',0,'',0,'N'),(917,915,'PCI','','',0,0,0,'','','','',0,'',0,'N'),(918,912,'Other','','',0,0,0,'','','','',0,'',0,'N'),(919,897,'Input Peripherals','','',0,0,0,'','','','',0,'>',0,'N'),(920,919,'Keyboards','','',0,0,0,'','','','',0,'',0,'N'),(921,919,'Mice','','',0,0,0,'','','','',0,'',0,'N'),(922,919,'Other','','',0,0,0,'','','','',0,'',0,'N'),(923,919,'Graphic Tablets','','',0,0,0,'','','','',0,'',0,'N'),(924,897,'Memory','','',0,0,0,'','','','',0,'>',0,'N'),(925,924,'EDO','','',0,0,0,'','','','',0,'',0,'N'),(926,924,'RAM','','',0,0,0,'','','','',0,'',0,'N'),(927,924,'SDRAM','','',0,0,0,'','','','',0,'',0,'N'),(928,924,'Other','','',0,0,0,'','','','',0,'',0,'N'),(929,897,'Motherboards','','',0,0,0,'','','','',0,'',0,'N'),(930,897,'Power Supplies','','',0,0,0,'','','','',0,'',0,'N'),(931,897,'Storage Devices','','',0,0,0,'','','','',0,'>',0,'N'),(932,931,'Hard Drives','','',0,0,0,'','','','',0,'',0,'N'),(933,931,'Other','','',0,0,0,'','','','',0,'',0,'N'),(934,897,'Drives','','',0,0,0,'','','','',0,'>',0,'N'),(936,934,'DVD-RW','','',0,0,0,'','','','',0,'',0,'N'),(937,934,'CD ROM','','',0,0,0,'','','','',0,'',0,'N'),(938,934,'Zip Drive','','',0,0,0,'','','','',0,'',0,'N'),(939,934,'Floppy Disk Drive','','',0,0,0,'','','','',0,'',0,'N'),(940,934,'CDRW','','',0,0,0,'','','','',0,'',0,'N'),(942,934,'Other','','',0,0,0,'','','','',0,'',0,'N'),(943,897,'Sound Cards','','',0,0,0,'','','','',0,'',0,'N'),(944,897,'Other','','',0,0,0,'','','','',0,'',0,'N'),(960,955,'Dell','','',0,0,0,'','','','',0,'',0,'N'),(959,955,'HP','','',0,0,0,'','','','',0,'',0,'N'),(958,955,'Other','','',0,0,0,'','','','',0,'',0,'N'),(957,955,'Advent','','',0,0,0,'','','','',0,'',0,'N'),(956,955,'Carry Cases & Accessories','','',0,0,0,'','','','',0,'',0,'N'),(955,877,'Laptops','','',0,0,0,'','','','',0,'>',0,'N'),(961,955,'IBM','','',0,0,0,'','','','',0,'',0,'N'),(962,955,'Sony','','',0,0,0,'','','','',0,'',0,'N'),(963,955,'Compaq','','',0,0,0,'','','','',0,'',0,'N'),(964,955,'Toshiba','','',0,0,0,'','','','',0,'',0,'N'),(965,877,'Macintosh','','',0,0,0,'','','','',0,'>',0,'N'),(966,965,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(967,965,'i-Book','','',0,0,0,'','','','',0,'',0,'N'),(968,965,'-Mac','','',0,0,0,'','','','',0,'',0,'N'),(969,965,'Powerbook','','',0,0,0,'','','','',0,'',0,'N'),(970,965,'Powermac','','',0,0,0,'','','','',0,'',0,'N'),(971,965,'Other','','',0,0,0,'','','','',0,'',0,'N'),(972,877,'Networking','','',0,0,0,'','','','',0,'>',0,'N'),(973,972,'General','','',0,0,0,'','','','',0,'',0,'N'),(974,972,'Mainframes','','',0,0,0,'','','','',0,'',0,'N'),(975,972,'Networking','','',0,0,0,'','','','',0,'',0,'N'),(976,972,'Routers, Switches','','',0,0,0,'','','','',0,'',0,'N'),(977,972,'Servers','','',0,0,0,'','','','',0,'',0,'N'),(978,972,'Racks','','',0,0,0,'','','','',0,'',0,'N'),(979,972,'Terminals','','',0,0,0,'','','','',0,'',0,'N'),(980,972,'Unix','','',0,0,0,'','','','',0,'',0,'N'),(981,877,'Other Hardware','','',0,0,0,'','','','',0,'>',0,'N'),(982,981,'General','','',0,0,0,'','','','',0,'',0,'N'),(983,877,'PC Systems','','',0,0,0,'','','','',0,'>',0,'N'),(984,983,'AMD Athlon','','',0,0,0,'','','','',0,'',0,'N'),(985,983,'AMD Duron','','',0,0,0,'','','','',0,'',0,'N'),(986,983,'Intel 486','','',0,0,0,'','','','',0,'',0,'N'),(989,983,'Intel Pentium III','','',0,0,0,'','','','',0,'',0,'N'),(990,983,'Intel Pentium IV','','',0,0,0,'','','','',0,'',0,'N'),(991,983,'Other','','',0,0,0,'','','','',0,'',0,'N'),(992,877,'PDA's','','',0,0,0,'','','','',0,'>',0,'N'),(993,992,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(994,992,'Compaq','','',0,0,0,'','','','',0,'',0,'N'),(995,992,'Handspring','','',0,0,0,'','','','',0,'',0,'N'),(996,992,'Hewlett Packard','','',0,0,0,'','','','',0,'',0,'N'),(997,992,'Palm','','',0,0,0,'','','','',0,'',0,'N'),(998,992,'Psion','','',0,0,0,'','','','',0,'',0,'N'),(999,992,'Windows CE devices','','',0,0,0,'','','','',0,'',0,'N'),(1000,992,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1001,877,'Peripherals','','',0,0,0,'','','','',0,'>',0,'N'),(1002,1001,'General','','',0,0,0,'','','','',0,'',0,'N'),(1003,1001,'Modems','','',0,0,0,'','','','',0,'>',0,'N'),(1004,1003,'External','','',0,0,0,'','','','',0,'',0,'N'),(1005,1003,'Internal','','',0,0,0,'','','','',0,'',0,'N'),(1006,1001,'Monitors','','',0,0,0,'','','','',0,'>',0,'N'),(1007,1006,'16 Inch Or Smaller','','',0,0,0,'','','','',0,'',0,'N'),(1008,1006,'17 Inch','','',0,0,0,'','','','',0,'',0,'N'),(1009,1006,'19 Inch Or Larger','','',0,0,0,'','','','',0,'',0,'N'),(1010,1006,'TFT','','',0,0,0,'','','','',0,'',0,'N'),(1011,1006,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1012,1001,'Multimedia Devices','','',0,0,0,'','','','',0,'>',0,'N'),(1013,1012,'General','','',0,0,0,'','','','',0,'',0,'N'),(1014,1012,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1015,1012,'Headphones & Microphones','','',0,0,0,'','','','',0,'',0,'N'),(1016,1001,'Printers','','',0,0,0,'','','','',0,'>',0,'N'),(1017,1016,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1018,1016,'Inkjet','','',0,0,0,'','','','',0,'',0,'N'),(1019,1016,'Laser','','',0,0,0,'','','','',0,'',0,'N'),(1020,1016,'Supplies','','',0,0,0,'','','','',0,'',0,'N'),(1021,1016,'Multi Function','','',0,0,0,'','','','',0,'',0,'N'),(1022,1016,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1023,1001,'Scanners','','',0,0,0,'','','','',0,'',0,'N'),(1024,1001,'Video','','',0,0,0,'','','','',0,'>',0,'N'),(1025,1024,'General','','',0,0,0,'','','','',0,'',0,'N'),(1026,1024,'Webcams','','',0,0,0,'','','','',0,'',0,'N'),(1027,877,'Software','','',0,0,0,'','','','',0,'>',0,'N'),(1028,1027,'General','','',0,0,0,'','','','',0,'',0,'N'),(1029,1027,'Business','','',0,0,0,'','','','',0,'',0,'N'),(1030,1027,'Children','','',0,0,0,'','','','',0,'',0,'N'),(1031,1027,'Desktop Publishing','','',0,0,0,'','','','',0,'',0,'N'),(1032,1027,'Development Tools','','',0,0,0,'','','','',0,'',0,'N'),(1033,1027,'Graphics & Multimedia','','',0,0,0,'','','','',0,'',0,'N'),(1034,1027,'Educational','','',0,0,0,'','','','',0,'',0,'N'),(1035,1027,'Internet','','',0,0,0,'','','','',0,'',0,'N'),(1036,1027,'Macintosh','','',0,0,0,'','','','',0,'',0,'N'),(1037,1027,'Operating Systems','','',0,0,0,'','','','',0,'',0,'N'),(1038,1027,'Reference','','',0,0,0,'','','','',0,'',0,'N'),(1039,1027,'Utilities','','',0,0,0,'','','','',0,'',0,'N'),(1040,0,'Electronics','','',10,0,0,'','','','',-1,'>',0,'N'),(1041,1040,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(1042,1041,'Batteries','','',0,0,0,'','','','',0,'',0,'N'),(1043,1041,'Headphones','','',0,0,0,'','','','',0,'',0,'N'),(1044,1041,'Cables','','',0,0,0,'','','','',0,'',0,'N'),(1045,1041,'Remote Controls','','',0,0,0,'','','','',0,'',0,'N'),(1046,1041,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1047,1040,'Portable Audio','','',0,0,0,'','','','',0,'>',0,'N'),(1048,1047,'Cassette Players','','',0,0,0,'','','','',0,'',0,'N'),(1049,1047,'CD Players','','',0,0,0,'','','','',0,'',0,'N'),(1050,1047,'Minidisc','','',0,0,0,'','','','',0,'',0,'N'),(1051,1047,'MP3 Players','','',0,0,0,'','','','',0,'',0,'N'),(1052,1047,'Radio's','','',0,0,0,'','','','',0,'',0,'N'),(1053,1047,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1054,1040,'Audio Systems','','',0,0,0,'','','','',0,'>',0,'N'),(1055,1054,'Amplifiers','','',0,0,0,'','','','',0,'',0,'N'),(1056,1054,'Cassette Decks','','',0,0,0,'','','','',0,'',0,'N'),(1057,1054,'CD Players','','',0,0,0,'','','','',0,'',0,'N'),(1058,1054,'Home Theatre','','',0,0,0,'','','','',0,'',0,'N'),(1059,1054,'MiniDisc','','',0,0,0,'','','','',0,'',0,'N'),(1060,1054,'MP3 Players','','',0,0,0,'','','','',0,'',0,'N'),(1061,1054,'Speakers','','',0,0,0,'','','','',0,'',0,'N'),(1062,1054,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(1063,1054,'Tuners','','',0,0,0,'','','','',0,'',0,'N'),(1064,1054,'Turntables','','',0,0,0,'','','','',0,'',0,'N'),(1065,1054,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1066,1040,'Camcorders','','',0,0,0,'','','','',0,'',0,'N'),(1067,1040,'Home Phones','','',0,0,0,'','','','',0,'>',0,'N'),(1068,1067,'Analogue Phones','','',0,0,0,'','','','',0,'',0,'N'),(1069,1067,'Answer Phones','','',0,0,0,'','','','',0,'',0,'N'),(1070,1067,'Caller ID','','',0,0,0,'','','','',0,'',0,'N'),(1071,1067,'Digital Phones','','',0,0,0,'','','','',0,'',0,'N'),(1072,1067,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1073,1040,'Mobile Phones','','',0,0,0,'','','','',0,'>',0,'N'),(1074,1073,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(1075,1074,'Batteries','','',0,0,0,'','','','',0,'',0,'N'),(1076,1074,'Data Cables','','',0,0,0,'','','','',0,'',0,'N'),(1077,1074,'Handsfree','','',0,0,0,'','','','',0,'',0,'N'),(1078,1074,'Pagers','','',0,0,0,'','','','',0,'',0,'N'),(1079,1074,'Boosters','','',0,0,0,'','','','',0,'',0,'N'),(1080,1074,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1081,1073,'Ericsson','','',0,0,0,'','','','',0,'',0,'N'),(1082,1073,'Motorola','','',0,0,0,'','','','',0,'',0,'N'),(1083,1073,'Nokia','','',0,0,0,'','','','',0,'',0,'N'),(1084,1073,'Siemens','','',0,0,0,'','','','',0,'',0,'N'),(1085,1073,'Samsung','','',0,0,0,'','','','',0,'',0,'N'),(1086,1073,'Sony Ericsson','','',0,0,0,'','','','',0,'>',0,'N'),(1087,1073,'Sim Cards','','',0,0,0,'','','','',0,'',0,'N'),(1088,1086,'BT Cellnet/O2','','',0,0,0,'','','','',0,'',0,'N'),(1089,1086,'T-Mobile','','',0,0,0,'','','','',0,'',0,'N'),(1090,1086,'Orange','','',0,0,0,'','','','',0,'',0,'N'),(1091,1086,'Vodafone','','',0,0,0,'','','','',0,'',0,'N'),(1092,1086,'Other Networks','','',0,0,0,'','','','',0,'',0,'N'),(1093,1073,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1094,1040,'Mobile Phone Cases','','',0,0,0,'','','','',-1,'>',0,'N'),(1095,1094,'For Ericsson','','',0,0,0,'','','','',0,'',0,'N'),(1096,1094,'For Motorola','','',0,0,0,'','','','',0,'',0,'N'),(1097,1094,'For Nokia','','',0,0,0,'','','','',0,'',0,'N'),(1098,1094,'All Other Phones','','',0,0,0,'','','','',-1,'',0,'N'),(1099,1040,'Televisions','','',0,0,0,'','','','',0,'>',0,'N'),(1100,1099,'Digial TV's','','',0,0,0,'','','','',0,'',0,'N'),(1101,1099,'Plasma TV's','','',0,0,0,'','','','',0,'',0,'N'),(1102,1099,'Portable TV's','','',0,0,0,'','','','',0,'',0,'N'),(1103,1099,'Widescreen TV's','','',0,0,0,'','','','',0,'',0,'N'),(1104,1099,'TV/VCR Combi','','',0,0,0,'','','','',0,'',0,'N'),(1105,1099,'TV/DVD Combi','','',0,0,0,'','','','',0,'',0,'N'),(1106,1099,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1107,1040,'DVD Players','','',0,0,0,'','','','',0,'>',0,'N'),(1108,1107,'Region 2 DVD','','',0,0,0,'','','','',0,'',0,'N'),(1109,1107,'Region Free DVD','','',0,0,0,'','','','',0,'',0,'N'),(1110,1040,'VCR's','','',0,0,0,'','','','',0,'',0,'N'),(1111,1040,'Satellite & Digital TV','','',0,0,0,'','','','',0,'>',0,'N'),(1112,1111,'Dishes','','',0,0,0,'','','','',0,'',0,'N'),(1113,1111,'Old Receivers','','',0,0,0,'','','','',0,'',0,'N'),(1114,1111,'Digi Boxes','','',0,0,0,'','','','',0,'',0,'N'),(1115,1111,'Handsets','','',0,0,0,'','','','',0,'',0,'N'),(1116,1111,'Cables','','',0,0,0,'','','','',0,'',0,'N'),(1117,0,'Dolls & Dolls Houses','','',9,0,0,'','','','',0,'>',0,'N'),(1118,1117,'Dolls','','',0,0,0,'','','','',0,'>',0,'N'),(1126,1117,'House & Miniatures','','',0,0,0,'','','','',0,'>',0,'N'),(1127,1117,'Sindy','','',0,0,0,'','','','',0,'',0,'N'),(1125,1117,'Figures','','',0,0,0,'','','','',0,'>',0,'N'),(1124,1117,'Barbie','','',0,0,0,'','','','',0,'',0,'N'),(1128,1126,'General','','',0,0,0,'','','','',0,'',0,'N'),(1129,1126,'Polly Pocket','','',0,0,0,'','','','',0,'',0,'N'),(1130,1126,'Houses','','',0,0,0,'','','','',0,'',0,'N'),(1131,1126,'Sylvanian Family','','',0,0,0,'','','','',0,'',0,'N'),(1132,1125,'General','','',0,0,0,'','','','',0,'',0,'N'),(1133,1125,'Trolls','','',0,0,0,'','','','',0,'',0,'N'),(1134,1118,'General','','',0,0,0,'','','','',0,'',0,'N'),(1135,1118,'American Character','','',0,0,0,'','','','',0,'',0,'N'),(1136,1118,'Furniture','','',0,0,0,'','','','',0,'',0,'N'),(1137,1118,'Porcelain','','',0,0,0,'','','','',0,'',0,'N'),(1138,1118,'Modern','','',0,0,0,'','','','',0,'',0,'N'),(1139,0,'TV & Movies','','',23,0,0,'','','','',0,'>',0,'N'),(1140,1139,'DVD's','','',0,0,0,'','','','',0,'>',0,'N'),(1141,1139,'Video's','','',0,0,0,'','','','',0,'>',0,'N'),(1142,1139,'Other Formats','','',0,0,0,'','','','',0,'>',0,'N'),(1143,1139,'Autographs','','',0,0,0,'','','','',0,'>',0,'N'),(1144,1139,'Posters','','',0,0,0,'','','','',0,'>',0,'N'),(1145,1139,'Memorabilia','','',0,0,0,'','','','',0,'>',0,'N'),(1146,1143,'Film','','',0,0,0,'','','','',0,'',0,'N'),(1147,1143,'TV','','',0,0,0,'','','','',0,'',0,'N'),(1148,1143,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1149,1140,'Action & Adventure','','',0,0,0,'','','','',0,'',0,'N'),(1150,1140,'Animation','','',0,0,0,'','','','',0,'',0,'N'),(1151,1140,'Children & Family','','',0,0,0,'','','','',0,'',0,'N'),(1152,1140,'Classics','','',0,0,0,'','','','',0,'',0,'N'),(1153,1140,'Comedy','','',0,0,0,'','','','',0,'',0,'N'),(1154,1140,'Cult','','',0,0,0,'','','','',0,'',0,'N'),(1155,1140,'Drama','','',0,0,0,'','','','',0,'',0,'N'),(1156,1140,'Fantasy','','',0,0,0,'','','','',0,'',0,'N'),(1157,1140,'Foreign','','',0,0,0,'','','','',0,'',0,'N'),(1158,1140,'Documentary','','',0,0,0,'','','','',0,'',0,'N'),(1159,1140,'Martial Arts','','',0,0,0,'','','','',0,'',0,'N'),(1160,1140,'Horror','','',0,0,0,'','','','',0,'',0,'N'),(1162,1140,'Musicals','','',0,0,0,'','','','',0,'',0,'N'),(1163,1140,'Romance','','',0,0,0,'','','','',0,'',0,'N'),(1164,1140,'Sci-Fi','','',0,0,0,'','','','',0,'',0,'N'),(1165,1140,'Special Editions','','',0,0,0,'','','','',0,'',0,'N'),(1166,1140,'Sports & Exercise','','',0,0,0,'','','','',0,'',0,'N'),(1167,1140,'TV','','',0,0,0,'','','','',0,'',0,'N'),(1168,1140,'Crime','','',0,0,0,'','','','',0,'',0,'N'),(1169,1140,'Mystery','','',0,0,0,'','','','',0,'',0,'N'),(1170,1140,'War','','',0,0,0,'','','','',0,'',0,'N'),(1171,1140,'Westerns','','',0,0,0,'','','','',0,'',0,'N'),(1172,1140,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1173,1145,'Scripts','','',0,0,0,'','','','',0,'',0,'N'),(1174,1145,'Calendars','','',0,0,0,'','','','',0,'',0,'N'),(1175,1145,'Props','','',0,0,0,'','','','',0,'',0,'N'),(1176,1142,'Beta','','',0,0,0,'','','','',0,'',0,'N'),(1177,1142,'Celluloid','','',0,0,0,'','','','',0,'',0,'N'),(1178,1142,'VCD','','',0,0,0,'','','','',0,'',0,'N'),(1179,1142,'NTSC','','',0,0,0,'','','','',0,'',0,'N'),(1180,1142,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1181,1144,'Original UK','','',0,0,0,'','','','',0,'',0,'N'),(1182,1144,'Original US','','',0,0,0,'','','','',0,'',0,'N'),(1183,1144,'Origianl Worldwide','','',0,0,0,'','','','',0,'',0,'N'),(1184,1144,'Reproductions','','',0,0,0,'','','','',0,'',0,'N'),(1185,1141,'Action & Adventure','','',0,0,0,'','','','',0,'',0,'N'),(1186,1141,'Animation','','',0,0,0,'','','','',0,'',0,'N'),(1187,1141,'Box Sets','','',0,0,0,'','','','',0,'',0,'N'),(1188,1141,'Children & Family','','',0,0,0,'','','','',0,'',0,'N'),(1189,1141,'Classics','','',0,0,0,'','','','',0,'',0,'N'),(1190,1141,'Comedy','','',0,0,0,'','','','',0,'',0,'N'),(1191,1141,'Deleted Video's','','',0,0,0,'','','','',0,'',0,'N'),(1192,1141,'Drama','','',0,0,0,'','','','',0,'',0,'N'),(1193,1141,'Excercise','','',0,0,0,'','','','',0,'',0,'N'),(1194,1141,'Fantasy','','',0,0,0,'','','','',0,'',0,'N'),(1195,1141,'Foreign','','',0,0,0,'','','','',0,'',0,'N'),(1196,1141,'Horror','','',0,0,0,'','','','',0,'',0,'N'),(1197,1141,'Documentary','','',0,0,0,'','','','',0,'',0,'N'),(1198,1141,'Martial Arts','','',0,0,0,'','','','',0,'',0,'N'),(1200,1141,'Musical','','',0,0,0,'','','','',0,'',0,'N'),(1201,1141,'Romance','','',0,0,0,'','','','',0,'',0,'N'),(1202,1141,'Sci-Fi','','',0,0,0,'','','','',0,'',0,'N'),(1203,1141,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(1204,1141,'Television','','',0,0,0,'','','','',0,'',0,'N'),(1205,1141,'Crime','','',0,0,0,'','','','',0,'',0,'N'),(1206,1141,'Thriller','','',0,0,0,'','','','',0,'',0,'N'),(1207,1141,'Mystery','','',0,0,0,'','','','',0,'',0,'N'),(1208,1141,'War','','',0,0,0,'','','','',0,'',0,'N'),(1209,1141,'Westerns','','',0,0,0,'','','','',0,'',0,'N'),(1210,1141,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1211,0,'Jewelry & Watches','','',13,0,0,'','','','',0,'>',0,'N'),(1212,1211,'Beads','','',0,0,0,'','','','',0,'',0,'N'),(1213,1211,'Costume Jewellery','','',0,0,0,'','','','',0,'',0,'N'),(1214,1211,'Fine Jewellery','','',0,0,0,'','','','',0,'>',0,'N'),(1215,1214,'New','','',0,0,0,'','','','',0,'',0,'N'),(1216,1214,'Antique','','',0,0,0,'','','','',0,'',0,'N'),(1217,1211,'Gemstones','','',0,0,0,'','','','',0,'>',0,'N'),(1218,1217,'Amber','','',0,0,0,'','','','',0,'',0,'N'),(1219,1217,'Amethyst','','',0,0,0,'','','','',0,'',0,'N'),(1220,1217,'Aquamarine','','',0,0,0,'','','','',0,'',0,'N'),(1221,1217,'Diamond','','',0,0,0,'','','','',0,'',0,'N'),(1222,1217,'Emerald','','',0,0,0,'','','','',0,'',0,'N'),(1223,1217,'Garnet','','',0,0,0,'','','','',0,'',0,'N'),(1224,1217,'Jade','','',0,0,0,'','','','',0,'',0,'N'),(1225,1217,'Opal','','',0,0,0,'','','','',0,'',0,'N'),(1226,1217,'Pearl','','',0,0,0,'','','','',0,'',0,'N'),(1227,1217,'Ruby','','',0,0,0,'','','','',0,'',0,'N'),(1228,1217,'Sapphire','','',0,0,0,'','','','',0,'',0,'N'),(1229,1217,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1230,1211,'Jewellery Boxes','','',0,0,0,'','','','',0,'',0,'N'),(1231,1211,'Watches','','',0,0,0,'','','','',0,'>',0,'N'),(1232,1231,'Novelty','','',0,0,0,'','','','',0,'',0,'N'),(1233,1231,'Pocket','','',0,0,0,'','','','',0,'',0,'N'),(1234,1231,'Rolex','','',0,0,0,'','','','',0,'',0,'N'),(1235,1231,'Swatch','','',0,0,0,'','','','',0,'',0,'N'),(1236,1231,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1237,1211,'Men's Jewellery','','',0,0,0,'','','','',0,'>',0,'N'),(1238,1237,'General','','',0,0,0,'','','','',0,'',0,'N'),(1239,1237,'Cufflinks','','',0,0,0,'','','','',0,'',0,'N'),(1242,1237,'Tiepins','','',0,0,0,'','','','',0,'',0,'N'),(1243,0,'Music','','',14,0,0,'','','','',0,'>',0,'N'),(1244,1243,'CD's','','',0,0,0,'','','','',0,'>',0,'N'),(1245,1243,'Tapes','','',0,0,0,'','','','',0,'>',0,'N'),(1246,1244,'Big Band','','',0,0,0,'','','','',0,'',0,'N'),(1247,1244,'Blues','','',0,0,0,'','','','',0,'',0,'N'),(1248,1244,'Childrens','','',0,0,0,'','','','',0,'',0,'N'),(1249,1244,'Comedy','','',0,0,0,'','','','',0,'',0,'N'),(1250,1244,'Classical & Opera','','',0,0,0,'','','','',0,'',0,'N'),(1251,1244,'Compilations','','',0,0,0,'','','','',0,'',0,'N'),(1252,1244,'Country','','',0,0,0,'','','','',0,'',0,'N'),(1253,1244,'Dance','','',0,0,0,'','','','',0,'',0,'N'),(1254,1244,'Disco','','',0,0,0,'','','','',0,'',0,'N'),(1255,1244,'Folk','','',0,0,0,'','','','',0,'',0,'N'),(1256,1244,'Garage','','',0,0,0,'','','','',0,'',0,'N'),(1257,1244,'House','','',0,0,0,'','','','',0,'',0,'N'),(1258,1244,'Indie','','',0,0,0,'','','','',0,'',0,'N'),(1259,1244,'Instrumental','','',0,0,0,'','','','',0,'',0,'N'),(1260,1244,'Jazz','','',0,0,0,'','','','',0,'',0,'N'),(1261,1244,'Karaoke','','',0,0,0,'','','','',0,'',0,'N'),(1262,1244,'Punk','','',0,0,0,'','','','',0,'',0,'N'),(1263,1244,'Pop','','',0,0,0,'','','','',0,'',0,'N'),(1264,1244,'R&B','','',0,0,0,'','','','',0,'',0,'N'),(1265,1244,'Rap','','',0,0,0,'','','','',0,'',0,'N'),(1266,1244,'Reggae','','',0,0,0,'','','','',0,'',0,'N'),(1267,1244,'Rock','','',0,0,0,'','','','',0,'',0,'N'),(1268,1244,'Seasonal','','',0,0,0,'','','','',0,'',0,'N'),(1269,1244,'Film Sountracks','','',0,0,0,'','','','',0,'',0,'N'),(1270,1245,'Blues','','',0,0,0,'','','','',0,'',0,'N'),(1271,1245,'Childrens','','',0,0,0,'','','','',0,'',0,'N'),(1272,1245,'Opera','','',0,0,0,'','','','',0,'',0,'N'),(1273,1245,'Classical','','',0,0,0,'','','','',0,'',0,'N'),(1274,1245,'Country','','',0,0,0,'','','','',0,'',0,'N'),(1275,1245,'Folk','','',0,0,0,'','','','',0,'',0,'N'),(1276,1245,'Jazz','','',0,0,0,'','','','',0,'',0,'N'),(1277,1245,'Rap','','',0,0,0,'','','','',0,'',0,'N'),(1278,1245,'Pop','','',0,0,0,'','','','',0,'',0,'N'),(1279,1245,'Rock','','',0,0,0,'','','','',0,'',0,'N'),(1280,1245,'Soundtracks','','',0,0,0,'','','','',0,'',0,'N'),(1281,1243,'Music Memorabilia','','',0,0,0,'','','','',0,'>',0,'N'),(1282,1281,'Magazines','','',0,0,0,'','','','',0,'',0,'N'),(1283,1281,'Books','','',0,0,0,'','','','',0,'',0,'N'),(1284,1281,'Photos','','',0,0,0,'','','','',0,'',0,'N'),(1285,1281,'Autographs','','',0,0,0,'','','','',0,'',0,'N'),(1286,1281,'Instruments','','',0,0,0,'','','','',0,'',0,'N'),(1287,1243,'Musical Instruments','','',0,0,0,'','','','',0,'>',0,'N'),(1288,1287,'Brass','','',0,0,0,'','','','',0,'',0,'N'),(1289,1287,'Electronic','','',0,0,0,'','','','',0,'',0,'N'),(1290,1287,'Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1291,1287,'Guitars','','',0,0,0,'','','','',0,'',0,'N'),(1292,1287,'Keyboards','','',0,0,0,'','','','',0,'',0,'N'),(1293,1287,'Pianos','','',0,0,0,'','','','',0,'',0,'N'),(1294,1287,'String','','',0,0,0,'','','','',0,'',0,'N'),(1295,1287,'Woodwind','','',0,0,0,'','','','',0,'',0,'N'),(1296,1287,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1297,1287,'Percussion','','',0,0,0,'','','','',0,'',0,'N'),(1317,1316,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1316,1311,'Camcorders','','',0,0,0,'','','','',0,'>',0,'N'),(1315,1312,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1314,1312,'Telescopes','','',0,0,0,'','','','',0,'',0,'N'),(1313,1312,'Binoculars','','',0,0,0,'','','','',0,'',0,'N'),(1318,1316,'8MM','','',0,0,0,'','','','',0,'',0,'N'),(1312,1311,'Binoculars & Telescopes','','',0,0,0,'','','','',0,'>',0,'N'),(1311,0,'Photography','','',15,0,0,'','','','',0,'>',0,'N'),(1319,1316,'Digital Camcorders','','',0,0,0,'','','','',0,'',0,'N'),(1320,1316,'Hi8','','',0,0,0,'','','','',0,'',0,'N'),(1321,1316,'VHS','','',0,0,0,'','','','',0,'',0,'N'),(1322,1316,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1323,1311,'Darkroom Equipment','','',0,0,0,'','','','',0,'>',0,'N'),(1324,1323,'Paper & Chemicals','','',0,0,0,'','','','',0,'',0,'N'),(1325,1323,'Studio Equipment & Lighting','','',0,0,0,'','','','',0,'',0,'N'),(1326,1323,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1327,1311,'Digital Cameras & Lenses','','',0,0,0,'','','','',0,'>',0,'N'),(1328,1327,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1329,1327,'Digital Camera Lenses','','',0,0,0,'','','','',0,'',0,'N'),(1330,1327,'General Purpose (2.1 to 4 MP)','','',0,0,0,'','','','',0,'',0,'N'),(1331,1327,'Serious (4.1 & Above)','','',0,0,0,'','','','',0,'',0,'N'),(1332,1327,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1333,1311,'Digital Memory','','',0,0,0,'','','','',0,'>',0,'N'),(1334,1333,'Compact Flash Cards','','',0,0,0,'','','','',0,'',0,'N'),(1335,1333,'Memory Card Readers','','',0,0,0,'','','','',0,'',0,'N'),(1336,1333,'Memory Sticks','','',0,0,0,'','','','',0,'',0,'N'),(1337,1333,'Smart Media','','',0,0,0,'','','','',0,'',0,'N'),(1338,1333,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1339,1311,'Film Cameras & Lenses','','',0,0,0,'','','','',0,'>',0,'N'),(1340,1339,'35mm Compact/Zoom','','',0,0,0,'','','','',0,'',0,'N'),(1341,1339,'APS','','',0,0,0,'','','','',0,'',0,'N'),(1342,1339,'Film Camera Lenses','','',0,0,0,'','','','',0,'',0,'N'),(1343,1339,'Movie','','',0,0,0,'','','','',0,'',0,'N'),(1344,1311,'Photographic Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(1345,1344,'Albums, Storage & Mounting','','',0,0,0,'','','','',0,'',0,'N'),(1346,1344,'Bags, Cases & Straps','','',0,0,0,'','','','',0,'',0,'N'),(1347,1344,'Books, Magazines & Manuals','','',0,0,0,'','','','',0,'',0,'N'),(1348,1344,'Batteries & Chargers','','',0,0,0,'','','','',0,'',0,'N'),(1349,1344,'Flashes','','',0,0,0,'','','','',0,'',0,'N'),(1350,1344,'Tripods & Supports','','',0,0,0,'','','','',0,'',0,'N'),(1351,0,'Pottery & Glass','','',16,0,0,'','','','',0,'>',0,'N'),(1352,1351,'Glass','','',0,0,0,'','','','',0,'>',0,'N'),(1353,1352,'General','','',0,0,0,'','','','',0,'',0,'N'),(1355,1352,'40s, 50s, 60s','','',0,0,0,'','','','',0,'',0,'N'),(1356,1352,'Contemporary Glass','','',0,0,0,'','','','',0,'',0,'N'),(1357,1352,'Cut Glass','','',0,0,0,'','','','',0,'',0,'N'),(1358,1352,'Paperweights','','',0,0,0,'','','','',0,'',0,'N'),(1359,1352,'Pressed Glass','','',0,0,0,'','','','',0,'',0,'N'),(1360,1352,'Stained Glass','','',0,0,0,'','','','',0,'',0,'N'),(1361,1352,'Waterford','','',0,0,0,'','','','',0,'',0,'N'),(1362,1352,'Swarovski','','',0,0,0,'','','','',0,'',0,'N'),(1363,1351,'Porcelain','','',0,0,0,'','','','',0,'>',0,'N'),(1364,1363,'General','','',0,0,0,'','','','',0,'',0,'N'),(1365,1363,'Aynsley','','',0,0,0,'','','','',0,'',0,'N'),(1366,1363,'Belleek','','',0,0,0,'','','','',0,'',0,'N'),(1367,1363,'Cardew','','',0,0,0,'','','','',0,'',0,'N'),(1368,1363,'Carlton Ware','','',0,0,0,'','','','',0,'',0,'N'),(1369,1363,'Chintz','','',0,0,0,'','','','',0,'',0,'N'),(1370,1363,'Coalport','','',0,0,0,'','','','',0,'',0,'N'),(1371,1363,'Decorative','','',0,0,0,'','','','',0,'',0,'N'),(1372,1363,'Dinnerware','','',0,0,0,'','','','',0,'',0,'N'),(1374,1363,'Figurines: Animal','','',0,0,0,'','','','',0,'',0,'N'),(1375,1363,'Hammersley','','',0,0,0,'','','','',0,'',0,'N'),(1376,1363,'Hummel, Goebel','','',0,0,0,'','','','',0,'',0,'N'),(1377,1363,'Lladro','','',0,0,0,'','','','',0,'',0,'N'),(1378,1363,'Royal Albert','','',0,0,0,'','','','',0,'',0,'N'),(1379,1363,'Royal Copenhagen','','',0,0,0,'','','','',0,'',0,'N'),(1380,1363,'Royal Doulton','','',0,0,0,'','','','',0,'',0,'N'),(1381,1363,'Royal Worcester','','',0,0,0,'','','','',0,'',0,'N'),(1382,1363,'Shelley','','',0,0,0,'','','','',0,'',0,'N'),(1383,1363,'Wade','','',0,0,0,'','','','',0,'',0,'N'),(1384,1363,'Wedgwood','','',0,0,0,'','','','',0,'',0,'N'),(1385,1351,'Pottery','','',0,0,0,'','','','',0,'>',0,'N'),(1386,1385,'General','','',0,0,0,'','','','',0,'',0,'N'),(1387,1385,'Beswick','','',0,0,0,'','','','',0,'',0,'N'),(1388,1385,'British Art','','',0,0,0,'','','','',0,'',0,'N'),(1389,1385,'Carlton','','',0,0,0,'','','','',0,'',0,'N'),(1390,1385,'Ceramics','','',0,0,0,'','','','',0,'',0,'N'),(1391,1385,'Clarice Cliff','','',0,0,0,'','','','',0,'',0,'N'),(1392,1385,'Commemorative','','',0,0,0,'','','','',0,'',0,'N'),(1393,1385,'Denby/Langley','','',0,0,0,'','','','',0,'',0,'N'),(1394,1385,'Dinnerware','','',0,0,0,'','','','',0,'',0,'N'),(1395,1385,'Dresden','','',0,0,0,'','','','',0,'',0,'N'),(1396,1385,'Midwinter','','',0,0,0,'','','','',0,'',0,'N'),(1397,1385,'Portmeirion','','',0,0,0,'','','','',0,'',0,'N'),(1398,1385,'Staffordshire','','',0,0,0,'','','','',0,'',0,'N'),(1399,1385,'Tablewares','','',0,0,0,'','','','',0,'',0,'N'),(1400,1385,'Sylvac','','',0,0,0,'','','','',0,'',0,'N'),(1401,1385,'Tea Pots, Tea Sets','','',0,0,0,'','','','',0,'',0,'N'),(1402,1385,'Wade','','',0,0,0,'','','','',0,'',0,'N'),(1403,1385,'Stoneware','','',0,0,0,'','','','',0,'',0,'N'),(1404,0,'Sports','','',19,0,0,'','','','',0,'>',0,'N'),(1405,1404,'Autographs','','',0,0,0,'','','','',0,'>',0,'N'),(1406,1405,'Boxing','','',0,0,0,'','','','',0,'',0,'N'),(1407,1405,'Cricket','','',0,0,0,'','','','',0,'',0,'N'),(1408,1405,'Darts','','',0,0,0,'','','','',0,'',0,'N'),(1409,1405,'Football','','',0,0,0,'','','','',0,'',0,'N'),(1410,1405,'Golf','','',0,0,0,'','','','',0,'',0,'N'),(1411,1405,'Horse Racing','','',0,0,0,'','','','',0,'',0,'N'),(1412,1405,'Olympic','','',0,0,0,'','','','',0,'',0,'N'),(1413,1405,'Motor Racing','','',0,0,0,'','','','',0,'',0,'N'),(1414,1405,'Rugby','','',0,0,0,'','','','',0,'',0,'N'),(1415,1405,'Snooker','','',0,0,0,'','','','',0,'',0,'N'),(1416,1405,'Tennis','','',0,0,0,'','','','',0,'',0,'N'),(1417,1405,'Wrestling','','',0,0,0,'','','','',0,'',0,'N'),(1418,1405,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1419,1404,'Memorabilia','','',0,0,0,'','','','',0,'>',0,'N'),(1420,1419,'American Sports','','',0,0,0,'','','','',0,'>',0,'N'),(1421,1420,'American Football','','',0,0,0,'','','','',0,'',0,'N'),(1422,1420,'Baseball','','',0,0,0,'','','','',0,'',0,'N'),(1423,1420,'Basketball','','',0,0,0,'','','','',0,'',0,'N'),(1424,1420,'Ice Hockey','','',0,0,0,'','','','',0,'',0,'N'),(1425,1419,'Boxing','','',0,0,0,'','','','',0,'',0,'N'),(1426,1419,'Corinthians','','',0,0,0,'','','','',0,'',0,'N'),(1427,1419,'Cricket','','',0,0,0,'','','','',0,'>',0,'N'),(1428,1427,'Cigarette Cards','','',0,0,0,'','','','',0,'',0,'N'),(1429,1427,'Programmes','','',0,0,0,'','','','',0,'',0,'N'),(1430,1427,'Scorecards','','',0,0,0,'','','','',0,'',0,'N'),(1431,1427,'Wisden','','',0,0,0,'','','','',0,'',0,'N'),(1432,1427,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1433,1419,'Cycling','','',0,0,0,'','','','',0,'',0,'N'),(1434,1419,'Darts','','',0,0,0,'','','','',0,'',0,'N'),(1435,1419,'Equestrian','','',0,0,0,'','','','',0,'',0,'N'),(1436,1419,'Football','','',0,0,0,'','','','',0,'>',0,'N'),(1437,1436,'Badges/Pins','','',0,0,0,'','','','',0,'',0,'N'),(1438,1436,'Jerseys/Shirts','','',0,0,0,'','','','',0,'',0,'N'),(1439,1436,'Programmes','','',0,0,0,'','','','',0,'',0,'N'),(1440,1436,'Scarves','','',0,0,0,'','','','',0,'',0,'N'),(1441,1436,'Ticket/Stubs','','',0,0,0,'','','','',0,'',0,'N'),(1442,1436,'World Cup','','',0,0,0,'','','','',0,'',0,'N'),(1443,1436,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1444,1419,'Formula 1','','',0,0,0,'','','','',0,'>',0,'N'),(1445,1444,'Caps','','',0,0,0,'','','','',0,'',0,'N'),(1446,1444,'Helmets','','',0,0,0,'','','','',0,'',0,'N'),(1447,1444,'Models','','',0,0,0,'','','','',0,'',0,'N'),(1448,1444,'Prints & Photography','','',0,0,0,'','','','',0,'',0,'N'),(1449,1444,'Programmes','','',0,0,0,'','','','',0,'',0,'N'),(1450,1444,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1451,1419,'Golf','','',0,0,0,'','','','',0,'',0,'N'),(1452,1419,'Horse Racing','','',0,0,0,'','','','',0,'>',0,'N'),(1453,1452,'Badges & Pins','','',0,0,0,'','','','',0,'',0,'N'),(1454,1452,'Cigarette Cards','','',0,0,0,'','','','',0,'',0,'N'),(1455,1452,'Prints & Photography','','',0,0,0,'','','','',0,'',0,'N'),(1456,1452,'Race Cards','','',0,0,0,'','','','',0,'',0,'N'),(1457,1452,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1458,1419,'Motorsport','','',0,0,0,'','','','',0,'>',0,'N'),(1459,1458,'Le Mans','','',0,0,0,'','','','',0,'',0,'N'),(1460,1458,'Superbikes','','',0,0,0,'','','','',0,'',0,'N'),(1461,1458,'NASCAR','','',0,0,0,'','','','',0,'',0,'N'),(1462,1458,'Stock Car','','',0,0,0,'','','','',0,'',0,'N'),(1463,1458,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1464,1419,'Olympic','','',0,0,0,'','','','',0,'',0,'N'),(1465,1419,'Rally','','',0,0,0,'','','','',0,'',0,'N'),(1466,1419,'Rugby','','',0,0,0,'','','','',0,'',0,'N'),(1467,1419,'Snooker','','',0,0,0,'','','','',0,'',0,'N'),(1468,1419,'Speedway','','',0,0,0,'','','','',0,'',0,'N'),(1469,1419,'Subbuteo','','',0,0,0,'','','','',0,'',0,'N'),(1470,1419,'Tennis','','',0,0,0,'','','','',0,'',0,'N'),(1471,1419,'Wrestling','','',0,0,0,'','','','',0,'',0,'N'),(1472,1419,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1473,1404,'Sporting Items & Equipment','','',0,0,0,'','','','',0,'>',0,'N'),(1474,1473,'American Sports','','',0,0,0,'','','','',0,'>',0,'N'),(1475,1474,'American Football','','',0,0,0,'','','','',0,'',0,'N'),(1476,1474,'Baseball','','',0,0,0,'','','','',0,'',0,'N'),(1477,1474,'Baksetball','','',0,0,0,'','','','',0,'',0,'N'),(1478,1474,'Ice Hockey','','',0,0,0,'','','','',0,'',0,'N'),(1479,1473,'Beach Sports','','',0,0,0,'','','','',0,'>',0,'N'),(1480,1479,'Surfing','','',0,0,0,'','','','',0,'',0,'N'),(1481,1479,'Volleyball','','',0,0,0,'','','','',0,'',0,'N'),(1482,1479,'Windsurfing','','',0,0,0,'','','','',0,'',0,'N'),(1483,1479,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1484,1473,'Bowling','','',0,0,0,'','','','',0,'',0,'N'),(1485,1473,'Camping','','',0,0,0,'','','','',0,'>',0,'N'),(1486,1485,'Tents','','',0,0,0,'','','','',0,'',0,'N'),(1487,1485,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1488,1485,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1489,1473,'Cricket','','',0,0,0,'','','','',0,'>',0,'N'),(1490,1489,'Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1491,1489,'Clothing','','',0,0,0,'','','','',0,'',0,'N'),(1492,1489,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1493,1473,'Cycling','','',0,0,0,'','','','',0,'>',0,'N'),(1494,1493,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1495,1493,'BMX Bikes','','',0,0,0,'','','','',0,'',0,'N'),(1496,1493,'Cycling Apparel','','',0,0,0,'','','','',0,'',0,'N'),(1497,1493,'Mountain Bikes','','',0,0,0,'','','','',0,'',0,'N'),(1498,1493,'Helmets','','',0,0,0,'','','','',0,'',0,'N'),(1499,1493,'Road JBikes','','',0,0,0,'','','','',0,'',0,'N'),(1500,1493,'Other Bikes','','',0,0,0,'','','','',0,'',0,'N'),(1502,1473,'Darts','','',0,0,0,'','','','',0,'',0,'N'),(1503,1473,'Equestrian Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1504,1473,'Exercise Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1505,1473,'Fishing','','',0,0,0,'','','','',0,'',0,'N'),(1506,1473,'Football','','',0,0,0,'','','','',0,'>',0,'N'),(1507,1506,'Boots','','',0,0,0,'','','','',0,'',0,'N'),(1508,1506,'Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1509,1506,'Clothing','','',0,0,0,'','','','',0,'',0,'N'),(1510,1506,'Shinpads','','',0,0,0,'','','','',0,'',0,'N'),(1511,1473,'Golf','','',0,0,0,'','','','',0,'>',0,'N'),(1512,1511,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1513,1511,'Bags','','',0,0,0,'','','','',0,'',0,'N'),(1514,1511,'Clothing','','',0,0,0,'','','','',0,'',0,'N'),(1515,1511,'Drivers/Woods','','',0,0,0,'','','','',0,'',0,'N'),(1516,1511,'Golf Balls','','',0,0,0,'','','','',0,'',0,'N'),(1517,1511,'Irons','','',0,0,0,'','','','',0,'',0,'N'),(1518,1511,'Putters','','',0,0,0,'','','','',0,'',0,'N'),(1519,1511,'Training','','',0,0,0,'','','','',0,'',0,'N'),(1520,1511,'Umbrellas','','',0,0,0,'','','','',0,'',0,'N'),(1521,1511,'Wedges','','',0,0,0,'','','','',0,'',0,'N'),(1522,1511,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1523,1473,'Hiking','','',0,0,0,'','','','',0,'',0,'N'),(1524,1473,'Hunting','','',0,0,0,'','','','',0,'',0,'N'),(1525,1473,'Martial Arts','','',0,0,0,'','','','',0,'',0,'N'),(1526,1473,'Rock Climbing','','',0,0,0,'','','','',0,'',0,'N'),(1527,1473,'Badminton','','',0,0,0,'','','','',0,'',0,'N'),(1528,1473,'Tennis','','',0,0,0,'','','','',0,'',0,'N'),(1529,1473,'Squash','','',0,0,0,'','','','',0,'',0,'N'),(1530,1473,'Rugby','','',0,0,0,'','','','',0,'',0,'N'),(1531,1473,'Running','','',0,0,0,'','','','',0,'',0,'N'),(1532,1473,'Skiing','','',0,0,0,'','','','',0,'',0,'N'),(1533,1473,'Skating','','',0,0,0,'','','','',0,'',0,'N'),(1534,1473,'Snooker','','',0,0,0,'','','','',0,'>',0,'N'),(1535,1473,'Snowboarding','','',0,0,0,'','','','',0,'',0,'N'),(1536,1473,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1537,1534,'Cues','','',0,0,0,'','','','',0,'',0,'N'),(1538,1534,'Tables','','',0,0,0,'','','','',0,'',0,'N'),(1539,1534,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1540,1404,'Cards & Stickers','','',0,0,0,'','','','',0,'>',0,'N'),(1541,1540,'American Sports','','',0,0,0,'','','','',0,'>',0,'N'),(1542,1541,'American Football','','',0,0,0,'','','','',0,'',0,'N'),(1543,1541,'Baseball','','',0,0,0,'','','','',0,'',0,'N'),(1544,1541,'Basketball','','',0,0,0,'','','','',0,'',0,'N'),(1545,1541,'Ice Hockey','','',0,0,0,'','','','',0,'',0,'N'),(1546,1541,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1547,1540,'Boxing','','',0,0,0,'','','','',0,'',0,'N'),(1548,1540,'Cricket','','',0,0,0,'','','','',0,'',0,'N'),(1549,1540,'Football','','',0,0,0,'','','','',0,'',0,'N'),(1550,1540,'Golf','','',0,0,0,'','','','',0,'',0,'N'),(1551,1540,'Motor Racing','','',0,0,0,'','','','',0,'',0,'N'),(1552,1540,'Wrestling','','',0,0,0,'','','','',0,'',0,'N'),(1553,1540,'Other Sports','','',0,0,0,'','','','',0,'',0,'N'),(1554,0,'Stamps','','',20,0,0,'','','','',0,'>',0,'N'),(1555,1554,'UK Stamps','','',0,0,0,'','','','',0,'>',0,'N'),(1556,1555,'Booklets','','',0,0,0,'','','','',0,'',0,'N'),(1557,1555,'Collections, Mixture','','',0,0,0,'','','','',0,'',0,'N'),(1558,1555,'Commemorative','','',0,0,0,'','','','',0,'',0,'N'),(1559,1555,'Covers','','',0,0,0,'','','','',0,'',0,'N'),(1561,1555,'Edward VIII','','',0,0,0,'','','','',0,'',0,'N'),(1562,1555,'Elizabeth II','','',0,0,0,'','','','',0,'',0,'N'),(1563,1555,'FDCs','','',0,0,0,'','','','',0,'',0,'N'),(1565,1555,'George VI','','',0,0,0,'','','','',0,'',0,'N'),(1566,1555,'PlateBlock/Multiples','','',0,0,0,'','','','',0,'',0,'N'),(1567,1555,'Sheets','','',0,0,0,'','','','',0,'',0,'N'),(1568,1555,'Victoria','','',0,0,0,'','','','',0,'',0,'N'),(1569,1555,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1570,1554,'Australia','','',0,0,0,'','','','',0,'',0,'N'),(1571,1554,'Canada','','',0,0,0,'','','','',0,'',0,'N'),(1572,1554,'Commonwealth','','',0,0,0,'','','','',0,'',0,'N'),(1575,1574,'Benelux & Colonies','','',0,0,0,'','','','',0,'',0,'N'),(1574,1554,'Europe','','',0,0,0,'','','','',0,'>',0,'N'),(1576,1574,'France & Area','','',0,0,0,'','','','',0,'',0,'N'),(1577,1574,'Germany & Area','','',0,0,0,'','','','',0,'',0,'N'),(1578,1574,'Ireland','','',0,0,0,'','','','',0,'',0,'N'),(1579,1574,'Italy & Area','','',0,0,0,'','','','',0,'',0,'N'),(1580,1574,'Portugal & Colonies','','',0,0,0,'','','','',0,'',0,'N'),(1581,1574,'Russia & Area','','',0,0,0,'','','','',0,'',0,'N'),(1582,1574,'Scandinavia','','',0,0,0,'','','','',0,'',0,'N'),(1583,1574,'Spain & Colonies','','',0,0,0,'','','','',0,'',0,'N'),(1584,1574,'Eastern Europe','','',0,0,0,'','','','',0,'',0,'N'),(1585,1574,'Western Europe','','',0,0,0,'','','','',0,'',0,'N'),(1586,1574,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1587,1554,'United States','','',0,0,0,'','','','',0,'',0,'N'),(1588,0,'Tickets & Travel','','',21,0,0,'','','','',0,'>',0,'N'),(1589,1588,'Accessories','','',0,0,0,'','','','',0,'>',0,'N'),(1590,1589,'Adaptors & Electrical','','',0,0,0,'','','','',0,'',0,'N'),(1591,1589,'Luggage','','',0,0,0,'','','','',0,'',0,'N'),(1592,1589,'Travel Guides','','',0,0,0,'','','','',0,'',0,'N'),(1593,1589,'General','','',0,0,0,'','','','',0,'',0,'N'),(1594,1588,'Tickets','','',0,0,0,'','','','',0,'>',0,'N'),(1595,1594,'General','','',0,0,0,'','','','',0,'',0,'N'),(1596,1594,'Concert','','',0,0,0,'','','','',0,'>',0,'N'),(1597,1594,'Sporting Events','','',0,0,0,'','','','',0,'>',0,'N'),(1598,1594,'Theatre','','',0,0,0,'','','','',0,'>',0,'N'),(1599,1596,'Pop','','',0,0,0,'','','','',0,'',0,'N'),(1600,1596,'Rock and Roll','','',0,0,0,'','','','',0,'',0,'N'),(1601,1596,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1602,1597,'Boxing','','',0,0,0,'','','','',0,'',0,'N'),(1603,1597,'Cricket','','',0,0,0,'','','','',0,'',0,'N'),(1604,1597,'Golf','','',0,0,0,'','','','',0,'',0,'N'),(1605,1597,'Motor Racing','','',0,0,0,'','','','',0,'',0,'N'),(1606,1597,'Football','','',0,0,0,'','','','',0,'',0,'N'),(1607,1597,'Tennis','','',0,0,0,'','','','',0,'',0,'N'),(1608,1597,'Rugby','','',0,0,0,'','','','',0,'',0,'N'),(1609,1597,'Horse Racing','','',0,0,0,'','','','',0,'',0,'N'),(1610,1597,'Wrestling','','',0,0,0,'','','','',0,'',0,'N'),(1611,1597,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1612,1598,'Musicals','','',0,0,0,'','','','',0,'',0,'N'),(1613,1598,'Plays','','',0,0,0,'','','','',0,'',0,'N'),(1614,1598,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1615,1588,'Travel','','',0,0,0,'','','','',0,'>',0,'N'),(1616,1615,'General','','',0,0,0,'','','','',0,'',0,'N'),(1617,1615,'Airline','','',0,0,0,'','','','',0,'',0,'N'),(1618,1615,'Bed and Breakfast','','',0,0,0,'','','','',0,'',0,'N'),(1619,1615,'Car Hire','','',0,0,0,'','','','',0,'',0,'N'),(1620,1615,'Caravan & Camping','','',0,0,0,'','','','',0,'',0,'N'),(1621,1615,'Coach Holidays','','',0,0,0,'','','','',0,'',0,'N'),(1622,1615,'Ferries & Cruises','','',0,0,0,'','','','',0,'',0,'N'),(1623,1615,'Hotels','','',0,0,0,'','','','',0,'',0,'N'),(1624,1615,'Packages','','',0,0,0,'','','','',0,'',0,'N'),(1625,1615,'Short Breaks','','',0,0,0,'','','','',0,'',0,'N'),(1626,1615,'Snow and Ski Holidays','','',0,0,0,'','','','',0,'',0,'N'),(1627,1615,'Villas & Timeshare','','',0,0,0,'','','','',0,'',0,'N'),(1628,0,'Toys & Games','','',22,0,0,'','','','',0,'>',0,'N'),(1629,1628,'Action Figures','','',0,0,0,'','','','',0,'>',0,'N'),(1630,1629,'General','','',0,0,0,'','','','',0,'',0,'N'),(1631,1629,'Action Man','','',0,0,0,'','','','',0,'',0,'N'),(1632,1629,'Dr Who','','',0,0,0,'','','','',0,'',0,'N'),(1633,1629,'Movies/TV','','',0,0,0,'','','','',0,'',0,'N'),(1634,1629,'Sports','','',0,0,0,'','','','',0,'',0,'N'),(1635,1629,'Power Rangers','','',0,0,0,'','','','',0,'',0,'N'),(1636,1629,'Star Trek','','',0,0,0,'','','','',0,'',0,'N'),(1637,1629,'Star Wars','','',0,0,0,'','','','',0,'',0,'N'),(1638,1629,'Transformers','','',0,0,0,'','','','',0,'',0,'N'),(1639,1629,'Xena','','',0,0,0,'','','','',0,'',0,'N'),(1640,1629,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1641,1628,'Bean Bag Plush','','',0,0,0,'','','','',0,'>',0,'N'),(1642,1641,'General','','',0,0,0,'','','','',0,'',0,'N'),(1643,1641,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1644,1641,'Coca Cola Bean Bags','','',0,0,0,'','','','',0,'',0,'N'),(1645,1641,'Disney','','',0,0,0,'','','','',0,'',0,'N'),(1646,1641,'Ty Beanies','','',0,0,0,'','','','',0,'',0,'N'),(1647,1641,'Ty Other Products','','',0,0,0,'','','','',0,'',0,'N'),(1648,1641,'Ty Retired Beanies','','',0,0,0,'','','','',0,'',0,'N'),(1649,1641,'Ty Teenie Beanies','','',0,0,0,'','','','',0,'',0,'N'),(1650,1641,'Warner Bros','','',0,0,0,'','','','',0,'',0,'N'),(1651,1628,'Diecast','','',0,0,0,'','','','',0,'>',0,'N'),(1652,1651,'General','','',0,0,0,'','','','',0,'',0,'N'),(1653,1651,'Burago','','',0,0,0,'','','','',0,'',0,'N'),(1654,1651,'Corgi','','',0,0,0,'','','','',0,'',0,'N'),(1655,1651,'Dinky','','',0,0,0,'','','','',0,'',0,'N'),(1656,1651,'Hot Wheels','','',0,0,0,'','','','',0,'',0,'N'),(1657,1651,'Lledo','','',0,0,0,'','','','',0,'',0,'N'),(1658,1651,'Matchbox','','',0,0,0,'','','','',0,'',0,'N'),(1659,1628,'Electronic Pets','','',0,0,0,'','','','',0,'',0,'N'),(1660,1628,'Fast Food Toys','','',0,0,0,'','','','',0,'>',0,'N'),(1661,1660,'Burger King','','',0,0,0,'','','','',0,'',0,'N'),(1662,1660,'McDonalds','','',0,0,0,'','','','',0,'',0,'N'),(1663,1660,'General','','',0,0,0,'','','','',0,'',0,'N'),(1664,1628,'Games','','',0,0,0,'','','','',0,'>',0,'N'),(1665,1664,'General','','',0,0,0,'','','','',0,'',0,'N'),(1666,1664,'Board Games','','',0,0,0,'','','','',0,'',0,'N'),(1667,1664,'Dice Games','','',0,0,0,'','','','',0,'',0,'N'),(1668,1664,'Electronic','','',0,0,0,'','','','',0,'',0,'N'),(1669,1664,'Role Playing','','',0,0,0,'','','','',0,'',0,'N'),(1670,1664,'Tradtional','','',0,0,0,'','','','',0,'',0,'N'),(1671,1664,'War Games','','',0,0,0,'','','','',0,'',0,'N'),(1672,1664,'Vintage','','',0,0,0,'','','','',0,'',0,'N'),(1673,1628,'Harry Potter','','',0,0,0,'','','','',0,'',0,'N'),(1674,1628,'Hobbies','','',0,0,0,'','','','',0,'>',0,'N'),(1675,1674,'General','','',0,0,0,'','','','',0,'',0,'N'),(1676,1674,'Radio Controlled','','',0,0,0,'','','','',0,'',0,'N'),(1677,1674,'Science Playsets','','',0,0,0,'','','','',0,'',0,'N'),(1678,1628,'Kites','','',0,0,0,'','','','',0,'',0,'N'),(1679,1628,'Modern Toys','','',0,0,0,'','','','',0,'>',0,'N'),(1680,1679,'General','','',0,0,0,'','','','',0,'',0,'N'),(1681,1679,'Battery Operated','','',0,0,0,'','','','',0,'',0,'N'),(1682,1679,'Lego','','',0,0,0,'','','','',0,'',0,'N'),(1683,1679,'Meccano','','',0,0,0,'','','','',0,'',0,'N'),(1684,1628,'My Little Pony','','',0,0,0,'','','','',0,'',0,'N'),(1685,1628,'Plastic Models','','',0,0,0,'','','','',0,'>',0,'N'),(1686,1685,'General','','',0,0,0,'','','','',0,'',0,'N'),(1687,1685,'Automotive','','',0,0,0,'','','','',0,'',0,'N'),(1688,1685,'Air','','',0,0,0,'','','','',0,'',0,'N'),(1689,1685,'Boats/Ships','','',0,0,0,'','','','',0,'',0,'N'),(1690,1685,'Character Figures','','',0,0,0,'','','','',0,'',0,'N'),(1691,1685,'Military','','',0,0,0,'','','','',0,'',0,'N'),(1692,1685,'Monsters','','',0,0,0,'','','','',0,'',0,'N'),(1693,1685,'Science Fiction','','',0,0,0,'','','','',0,'',0,'N'),(1694,1685,'Space','','',0,0,0,'','','','',0,'',0,'N'),(1695,1685,'Super-Hero','','',0,0,0,'','','','',0,'',0,'N'),(1696,1628,'Plush','','',0,0,0,'','','','',0,'>',0,'N'),(1697,1696,'General','','',0,0,0,'','','','',0,'',0,'N'),(1698,1696,'Bears','','',0,0,0,'','','','',0,'',0,'N'),(1699,1696,'Care Bears','','',0,0,0,'','','','',0,'',0,'N'),(1700,1696,'Disney','','',0,0,0,'','','','',0,'',0,'N'),(1701,1696,'Garfield','','',0,0,0,'','','','',0,'',0,'N'),(1702,1696,'Steiff','','',0,0,0,'','','','',0,'',0,'N'),(1703,1628,'Pokemon','','',0,0,0,'','','','',0,'>',0,'N'),(1704,1703,'General','','',0,0,0,'','','','',0,'',0,'N'),(1705,1703,'Action Figures','','',0,0,0,'','','','',0,'',0,'N'),(1706,1703,'Electronic Games','','',0,0,0,'','','','',0,'',0,'N'),(1707,1703,'Plsuh','','',0,0,0,'','','','',0,'',0,'N'),(1708,1703,'Trading Cards','','',0,0,0,'','','','',0,'',0,'N'),(1709,1628,'Puzzles','','',0,0,0,'','','','',0,'',0,'N'),(1710,1628,'Scalextrics','','',0,0,0,'','','','',0,'>',0,'N'),(1711,1710,'Cars','','',0,0,0,'','','','',0,'',0,'N'),(1712,1710,'Tracks','','',0,0,0,'','','','',0,'',0,'N'),(1713,1710,'Sets','','',0,0,0,'','','','',0,'',0,'N'),(1714,1710,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1715,1628,'Steam','','',0,0,0,'','','','',0,'',0,'N'),(1716,1628,'Television Toys','','',0,0,0,'','','','',0,'>',0,'N'),(1717,1716,'Jim Henson','','',0,0,0,'','','','',0,'',0,'N'),(1718,1716,'Rugrats','','',0,0,0,'','','','',0,'',0,'N'),(1719,1716,'Teletubbies','','',0,0,0,'','','','',0,'',0,'N'),(1720,1716,'Thomas Tank Engine','','',0,0,0,'','','','',0,'',0,'N'),(1721,1628,'Toy Soldiers','','',0,0,0,'','','','',0,'',0,'N'),(1722,1628,'Wooden Toys','','',0,0,0,'','','','',0,'',0,'N'),(1723,0,'Wholesale Items','','',24,0,0,'','','','',0,'>',0,'N'),(1724,1723,'Building Supplies','','',0,0,0,'','','','',0,'>',0,'N'),(1725,1724,'Electrical','','',0,0,0,'','','','',0,'',0,'N'),(1726,1724,'Plumbing','','',0,0,0,'','','','',0,'',0,'N'),(1727,1724,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1728,1723,'Electrical Components','','',0,0,0,'','','','',0,'',0,'N'),(1729,1723,'Medical Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1730,1723,'Office Equipment & Supplies','','',0,0,0,'','','','',0,'>',0,'N'),(1731,1730,'Copiers','','',0,0,0,'','','','',0,'',0,'N'),(1732,1730,'Fax Machines','','',0,0,0,'','','','',0,'',0,'N'),(1733,1730,'Furniture','','',0,0,0,'','','','',0,'',0,'N'),(1734,1730,'Supplies & Stationary','','',0,0,0,'','','','',0,'',0,'N'),(1735,1730,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1736,1730,'Type Writers','','',0,0,0,'','','','',0,'',0,'N'),(1737,1730,'General','','',0,0,0,'','','','',0,'',0,'N'),(1738,1723,'Packing Supplies','','',0,0,0,'','','','',0,'>',0,'N'),(1739,1738,'Boxes','','',0,0,0,'','','','',0,'',0,'N'),(1740,1738,'Bubble Wrap','','',0,0,0,'','','','',0,'',0,'N'),(1741,1738,'Jiffy Bags','','',0,0,0,'','','','',0,'',0,'N'),(1742,1738,'Tape','','',0,0,0,'','','','',0,'',0,'N'),(1743,1738,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1744,1723,'Restaurant & Catering','','',0,0,0,'','','','',0,'',0,'N'),(1745,1723,'Retail and Shop Fitting','','',0,0,0,'','','','',0,'',0,'N'),(1746,1723,'Hand Tools','','',0,0,0,'','','','',0,'>',0,'N'),(1760,1723,'Power Tools','','',0,0,0,'','','','',0,'>',0,'N'),(1747,1723,'Test and Measurement Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1748,1746,'Clamps, Vises','','',0,0,0,'','','','',0,'',0,'N'),(1749,1746,'Files, Chisels','','',0,0,0,'','','','',0,'',0,'N'),(1750,1746,'Hammers','','',0,0,0,'','','','',0,'',0,'N'),(1751,1746,'Knives, Cutters','','',0,0,0,'','','','',0,'',0,'N'),(1752,1746,'Measuring Tools','','',0,0,0,'','','','',0,'',0,'N'),(1753,1746,'Pliers','','',0,0,0,'','','','',0,'',0,'N'),(1754,1746,'Saws','','',0,0,0,'','','','',0,'',0,'N'),(1755,1746,'Screwdrivers','','',0,0,0,'','','','',0,'',0,'N'),(1756,1746,'Wrenches','','',0,0,0,'','','','',0,'',0,'N'),(1757,1746,'Tool Sets','','',0,0,0,'','','','',0,'',0,'N'),(1761,1760,'Combination Sets','','',0,0,0,'','','','',0,'',0,'N'),(1762,1760,'Drills','','',0,0,0,'','','','',0,'',0,'N'),(1763,1760,'Grinders','','',0,0,0,'','','','',0,'',0,'N'),(1764,1760,'Rotary Tools','','',0,0,0,'','','','',0,'',0,'N'),(1765,1760,'Routers','','',0,0,0,'','','','',0,'',0,'N'),(1766,1760,'Sanders','','',0,0,0,'','','','',0,'',0,'N'),(1767,1760,'Saws','','',0,0,0,'','','','',0,'',0,'N'),(1768,1760,'Screwdrivers','','',0,0,0,'','','','',0,'',0,'N'),(1769,1760,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1770,1723,'Industrial Tools','','',0,0,0,'','','','',0,'',0,'N'),(1771,1723,'Wholesale Lots','','',0,0,0,'','','','',0,'>',0,'N'),(1772,1771,'Clothing, Jewellery & Watches','','',0,0,0,'','','','',0,'',0,'N'),(1773,1771,'Computer, Electronics & Photo','','',0,0,0,'','','','',0,'',0,'N'),(1774,1771,'Industrial & Office','','',0,0,0,'','','','',0,'',0,'N'),(1775,1771,'Books, Film & Music','','',0,0,0,'','','','',0,'',0,'N'),(1776,1771,'Other Wholesale Lots','','',0,0,0,'','','','',0,'',0,'N'),(1777,0,'Everything Else','','',11,0,0,'','','','',0,'>',0,'N'),(1778,1777,'General','','',0,0,0,'','','','',0,'',0,'N'),(1779,1777,'Aviation','','',0,0,0,'','','','',0,'>',0,'N'),(1780,1779,'Aircraft Parts','','',0,0,0,'','','','',0,'',0,'N'),(1781,1779,'Pilot Gear','','',0,0,0,'','','','',0,'',0,'N'),(1782,1779,'General','','',0,0,0,'','','','',0,'',0,'N'),(1783,1777,'Baby Items','','',0,0,0,'','','','',0,'>',0,'N'),(1784,1783,'General','','',0,0,0,'','','','',0,'',0,'N'),(1785,1783,'Essentials','','',0,0,0,'','','','',0,'',0,'N'),(1786,1783,'Clothing','','',0,0,0,'','','','',0,'',0,'N'),(1787,1783,'Furniture','','',0,0,0,'','','','',0,'',0,'N'),(1788,1783,'Maternity','','',0,0,0,'','','','',0,'',0,'N'),(1789,1783,'Pushchairs & Prams','','',0,0,0,'','','','',0,'',0,'N'),(1790,1777,'Crafts, Sewing','','',0,0,0,'','','','',0,'>',0,'N'),(1791,1790,'General','','',0,0,0,'','','','',0,'',0,'N'),(1792,1790,'Cross Stitch','','',0,0,0,'','','','',0,'',0,'N'),(1793,1790,'Fabric','','',0,0,0,'','','','',0,'',0,'N'),(1794,1790,'Lace','','',0,0,0,'','','','',0,'',0,'N'),(1795,1790,'Patterns','','',0,0,0,'','','','',0,'',0,'N'),(1796,1790,'Textiles','','',0,0,0,'','','','',0,'',0,'N'),(1797,1777,'Educational','','',0,0,0,'','','','',0,'',0,'N'),(1798,1777,'Food & Drink','','',0,0,0,'','','','',0,'>',0,'N'),(1799,1798,'Food','','',0,0,0,'','','','',0,'',0,'N'),(1800,1798,'Drink','','',0,0,0,'','','','',0,'',0,'N'),(1801,1777,'Garden Items','','',0,0,0,'','','','',0,'>',0,'N'),(1802,1801,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(1803,1801,'General','','',0,0,0,'','','','',0,'',0,'N'),(1804,1801,'Plants/Seeds','','',0,0,0,'','','','',0,'',0,'N'),(1805,1801,'Tools, Equipment','','',0,0,0,'','','','',0,'',0,'N'),(1806,1801,'Publications','','',0,0,0,'','','','',0,'',0,'N'),(1807,1777,'Home Furnishings','','',0,0,0,'','','','',0,'',0,'N'),(1808,1777,'Household Items','','',0,0,0,'','','','',0,'>',0,'N'),(1809,1808,'General','','',0,0,0,'','','','',0,'',0,'N'),(1810,1808,'Feng Shui','','',0,0,0,'','','','',0,'',0,'N'),(1811,1808,'Fitness','','',0,0,0,'','','','',0,'',0,'N'),(1812,1808,'Health','','',0,0,0,'','','','',0,'',0,'N'),(1813,1808,'Medical','','',0,0,0,'','','','',0,'',0,'N'),(1814,1808,'Safety, Security','','',0,0,0,'','','','',0,'',0,'N'),(1815,1777,'Household Appliances','','',0,0,0,'','','','',0,'',0,'N'),(1816,1777,'Metaphysical','','',0,0,0,'','','','',0,'',0,'N'),(1817,1777,'Pet Supplies','','',0,0,0,'','','','',0,'',0,'N'),(125,57,'Nintendo Gameboy','','',10004,0,0,'','','','',0,'>',0,'N'),(126,125,'Accessories','','',0,0,0,'','','','',0,'',0,'N'),(127,125,'Games','','',0,0,0,'','','','',0,'',0,'N'),(128,125,'Systems','','',0,0,0,'','','','',0,'',0,'N'),(252,245,'Silver','','',0,0,0,'','','','',0,'',0,'N'),(560,550,'Other','','',0,0,0,'','','','',0,'',0,'N'),(805,797,'Silver','','',0,0,0,'','','','',0,'',0,'N'),(905,899,'Intel Pentium II','','',0,0,0,'','','','',0,'',0,'N'),(906,899,'Intel Pentium III','','',0,0,0,'','','','',0,'',0,'N'),(907,899,'Intel Pentium III','','',0,0,0,'','','','',0,'',0,'N'),(935,934,'DVD','','',0,0,0,'','','','',0,'',0,'N'),(941,934,'CDR','','',0,0,0,'','','','',0,'',0,'N'),(987,983,'Intel Pentium','','',0,0,0,'','','','',0,'',0,'N'),(988,983,'Intel Pentium II','','',0,0,0,'','','','',0,'',0,'N'),(1161,1140,'Music','','',0,0,0,'','','','',0,'',0,'N'),(1199,1141,'Music','','',0,0,0,'','','','',0,'',0,'N'),(1373,1363,'Figurines','','',0,0,0,'','','','',0,'',0,'N'),(1501,1493,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1560,1555,'Edward VII','','',0,0,0,'','','','',0,'',0,'N'),(1564,1555,'George V','','',0,0,0,'','','','',0,'',0,'N'),(1758,1746,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1759,1746,'Other','','',0,0,0,'','','','',0,'',0,'N'),(1835,57,'Sony PSP','','',10012,0,0,'','','','',0,'',0,'N'),(1836,0,'Art','','',10000,0,0,'','','','',0,'',3,'N'),(1837,0,'Pics','','',10001,0,0,'','','','',0,'',3,'N'),(1838,0,'Stuff','','',10002,0,0,'','','','',0,'',3,'N'),(1839,0,'Testing','','',10004,0,0,'','','','',0,'',0,'N'),(1840,0,'mobile phones','','',10001,0,0,'','','','',0,'',10,'N'),(1841,0,'sim cards','','',10002,0,0,'','','','',0,'',10,'N');
/*!40000 ALTER TABLE `probid_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_chatrooms`
--
DROP TABLE IF EXISTS `probid_chatrooms`;
CREATE TABLE `probid_chatrooms` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) default NULL,
`winnerid` int(11) default NULL,
`datentime` int(11) default NULL,
`message` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_chatrooms`
--
LOCK TABLES `probid_chatrooms` WRITE;
/*!40000 ALTER TABLE `probid_chatrooms` DISABLE KEYS */;
INSERT INTO `probid_chatrooms` VALUES (1,4,1,1190323739,'????????????????????');
/*!40000 ALTER TABLE `probid_chatrooms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_countries`
--
DROP TABLE IF EXISTS `probid_countries`;
CREATE TABLE `probid_countries` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`theorder` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2101 DEFAULT CHARSET=latin1 COMMENT='Table with countries';
--
-- Dumping data for table `probid_countries`
--
LOCK TABLES `probid_countries` WRITE;
/*!40000 ALTER TABLE `probid_countries` DISABLE KEYS */;
INSERT INTO `probid_countries` VALUES (1865,'Afghanistan',1000),(1866,'Albania',10),(1874,'Argentina',1001),(1875,'Armenia',1002),(1877,'Australia',1003),(1878,'Austria',11),(1879,'Azerbaijan',1004),(1880,'Bahamas',1005),(1881,'Bahrain',1006),(1882,'Bangladesh',1007),(1883,'Barbados',1008),(1884,'Belarus',1009),(1885,'Belgium',12),(1886,'Belize',1010),(1887,'Benin',1011),(1888,'Bermuda',1012),(1889,'Bhutan',1013),(1890,'Bolivia',1014),(1891,'Bosnia and Herzegowina',13),(1892,'Botswana',1015),(1893,'Bouvet Island',1016),(1894,'Brazil',1017),(1895,'British Indian Ocean Territory',1018),(1896,'Brunei Darussalam',1019),(1897,'Bulgaria',14),(1898,'Burkina Faso',1020),(1899,'Burma',1021),(1900,'Burundi',1022),(1901,'Cambodia',1023),(1902,'Cameroon',1024),(1903,'Canada',1025),(1904,'Cape Verde',1026),(1905,'Cayman Islands',1027),(1906,'Central African Republic',1028),(1907,'Chad',1029),(1908,'Chile',1030),(1909,'China',1031),(1910,'Christmas Island',1032),(1911,'Cocos (Keeling) Islands',1033),(1912,'Colombia',1034),(1913,'Comoros',1035),(1914,'Congo',1036),(1915,'Congo, the Democratic Republic',1037),(1916,'Cook Islands',1038),(1917,'Costa Rica',1039),(1918,'Cote d'Ivoire',1040),(1919,'Croatia',15),(1920,'Cyprus',16),(1921,'Czech Republic',17),(1922,'Denmark',18),(1923,'Djibouti',1041),(1924,'Dominica',1042),(1925,'Dominican Republic',1043),(1926,'East Timor',1044),(1927,'Ecuador',1045),(1928,'Egypt',1046),(1929,'El Salvador',1047),(1930,'England',19),(1931,'Equatorial Guinea',1048),(1932,'Eritrea',1049),(1933,'Estonia',20),(1934,'Ethiopia',1050),(1935,'Falkland Islands',1051),(1936,'Faroe Islands',21),(1937,'Fiji',1052),(1938,'Finland',22),(1939,'France',23),(1940,'French Guiana',1053),(1941,'French Polynesia',1054),(1942,'French Southern Territories',1055),(1943,'Gabon',1056),(1944,'Gambia',1057),(1945,'Georgia',24),(1946,'Germany',25),(1947,'Ghana',1058),(1948,'Gibraltar',1059),(1949,'Greece',26),(1950,'Greenland',1060),(1951,'Grenada',1061),(1952,'Guadeloupe',1062),(1953,'Guam',1063),(1954,'Guatemala',1064),(1955,'Guinea',1065),(1956,'Guinea-Bissau',1066),(1957,'Guyana',1067),(1958,'Haiti',1068),(1959,'Heard and Mc Donald Islands',1069),(1960,'Holy See (Vatican City State)',1070),(1961,'Honduras',1071),(1962,'Hong Kong',1072),(1963,'Hungary',27),(1964,'Iceland',1073),(1965,'India',1074),(1966,'Indonesia',1075),(1968,'Israel',1076),(1969,'Italy',28),(1970,'Jamaica',1077),(1971,'Japan',1078),(1972,'Jordan',1079),(1973,'Kazakhstan',1080),(1974,'Kenya',1081),(1975,'Kiribati',1082),(1976,'Korea (South)',1083),(1977,'Kuwait',1084),(1978,'Kyrgyzstan',1085),(2100,'Lao People's Democratic Republic',0),(1980,'Latvia',1086),(1981,'Lebanon',1087),(1982,'Lesotho',1088),(1983,'Liberia',1089),(1984,'Liechtenstein',29),(1985,'Lithuania',1090),(1986,'Luxembourg',30),(1987,'Macau',1091),(1988,'Macedonia',31),(1989,'Madagascar',1092),(1990,'Malawi',1093),(1991,'Malaysia',1094),(1992,'Maldives',1095),(1993,'Mali',1096),(1994,'Malta',32),(1995,'Marshall Islands',1097),(1996,'Martinique',1098),(1997,'Mauritania',1099),(1998,'Mauritius',1100),(1999,'Mayotte',1101),(2000,'Mexico',1102),(2001,'Micronesia, Federated States o',1103),(2002,'Moldova, Republic of',33),(2003,'Monaco',34),(2004,'Mongolia',1104),(2005,'Montserrat',1105),(2009,'Morocco',1106),(2007,'Mozambique',1107),(2008,'Namibia',1108),(2009,'Nauru',1109),(2010,'Nepal',1110),(2011,'Netherlands',35),(2012,'Netherlands Antilles',1111),(2013,'New Caledonia',1112),(2014,'New Zealand',1113),(2015,'Nicaragua',1114),(2016,'Niger',1115),(2017,'Nigeria',1116),(2018,'Niuev',1117),(2019,'Norfolk Island',1118),(2020,'Northern Ireland',1119),(2021,'Northern Mariana Islands',1120),(2022,'Norway',36),(2023,'Oman',1121),(2024,'Pakistan',1122),(2025,'Palau',1123),(2026,'Panama',1124),(2027,'Papua New Guinea',1125),(2028,'Paraguay',1126),(2029,'Peru',1127),(2030,'Philippines',1128),(2031,'Pitcairn',1129),(2032,'Poland',37),(2033,'Portugal',38),(2034,'Puerto Rico',1130),(2035,'Qatar',1131),(2098,'Rep Of Ireland',39),(2036,'Reunion',1132),(2037,'Romania',40),(2038,'Russian Federation',41),(2039,'Rwanda',1133),(2040,'Saint Kitts and Nevis',1134),(2041,'Saint Lucia',1135),(2042,'Saint Vincent and the Grenadin',1136),(2043,'Samoa (Independent)',1137),(2044,'San Marino',42),(2045,'Sao Tome and Principe',1138),(2046,'Saudi Arabia',1139),(2047,'Scotland',43),(2048,'Senegal',1140),(2049,'Seychelles',1141),(2050,'Sierra Leone',1142),(2051,'Singapore',1143),(2052,'Slovakia',44),(2053,'Slovenia',45),(2054,'Solomon Islands',1144),(2055,'Somalia',1145),(2056,'South Africa',1146),(2057,'South Georgia and the South Sa',1147),(2058,'Spain',46),(2059,'Sri Lanka',1148),(2060,'St. Helena',1149),(2061,'St. Pierre and Miquelon',1150),(2062,'Suriname',1151),(2063,'Svalbard and Jan Mayen Islands',1152),(2064,'Swaziland',1153),(2065,'Sweden',47),(2066,'Switzerland',48),(2067,'Taiwan',1154),(2068,'Tajikistan',1155),(2069,'Tanzania',1156),(2070,'Thailand',1157),(2071,'Togo',1158),(2072,'Tokelau',1159),(2073,'Tonga',1160),(2074,'Trinidad and Tobago',1161),(2075,'Tunisia',1162),(2076,'Turkey',49),(2077,'Turkmenistan',1163),(2078,'Turks and Caicos Islands',1164),(2079,'Tuvalu',1165),(2080,'Uganda',1166),(2081,'Ukraine',50),(2082,'United Arab Emiratesv',1167),(2083,'United Kingdom',1),(2084,'United States',2),(2085,'Uruguay',1168),(2086,'Uzbekistan',1169),(2087,'Vanuatu',1170),(2088,'Venezuela',1171),(2089,'Vietnam',1172),(2090,'Virgin Islands (British)',1173),(2091,'Virgin Islands (U.S.)',1174),(2092,'Wales',1175),(2093,'Wallis and Futuna Islands',1176),(2094,'Western Sahara',1177),(2095,'Yemen',1178),(2096,'Zambia',1179),(2097,'Zimbabwe',1180);
/*!40000 ALTER TABLE `probid_countries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_currencies`
--
DROP TABLE IF EXISTS `probid_currencies`;
CREATE TABLE `probid_currencies` (
`id` int(11) NOT NULL auto_increment,
`symbol` varchar(10) NOT NULL default '',
`caption` varchar(100) NOT NULL default '',
`active` varchar(15) NOT NULL default '',
`converter` double(16,6) NOT NULL default '1.000000',
`converter_lastupdate` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1 COMMENT='Table with currency listings';
--
-- Dumping data for table `probid_currencies`
--
LOCK TABLES `probid_currencies` WRITE;
/*!40000 ALTER TABLE `probid_currencies` DISABLE KEYS */;
INSERT INTO `probid_currencies` VALUES (1,'ARS','Argentina (Argentinian Peso)','',2.200000,1129016048),(2,'AUD','Australia (Australian Dollar)','',1.000000,1128422435),(3,'BRL','Brazil (Brazilian Real)','',1.000000,1128422435),(36,'CHF','Switzerland (Swiss Franc)','',1.000000,1128422435),(4,'CLP','Chile (Chilean Peso)','',1.000000,1128422435),(5,'CNY','China (Chinese Renminbi)','',1.000000,1128422435),(6,'COP','Colombia (Colombian Peso)','',1.000000,1128422435),(7,'CZK','Czech. Republic (Czech. Republic Koruna)','',1.000000,1128422435),(8,'DKK','Denmark (Danish Krone)','',1.000000,1128422435),(9,'EUR','European Union (EURO)','',1.450000,1129016065),(10,'FJD','Fiji (Fiji Dollar)','',1.000000,1128422435),(11,'GBP','Great Britain (Pound Sterling)','',1.000000,1128422435),(12,'HKD','Hong Kong (Hong Kong Dollar)','',1.000000,1128422435),(15,'IDR','Indonesia (Indonesian Rupiah)','',1.000000,1128422435),(16,'ILS','Israel (Israeli New Shekel)','',1.000000,1128422435),(13,'ISK','Iceland (Icelandic Krona)','',1.000000,1128422435),(14,'INR','India (Indian Rupee)','',1.000000,1128422435),(17,'JPY','Japan (Japanese Yen)','',1.000000,1128422435),(33,'KRW','South Korea (South Korean Won)','',1.000000,1128422435),(34,'LKR','Sri Lanka (Sri Lanka Rupee)','',1.000000,1128422435),(20,'MAD','Morocco (Moroccan Dirham)','',1.000000,1128422435),(19,'MXN','Mexico (New Peso)','',1.000000,1128422435),(18,'MYR','Malaysia (Malaysian Ringgit)','',1.000000,1128422435),(22,'NOK','Norway','',1.000000,1128422435),(21,'NZD','New Zealand (New Zealand Dollar)','',1.000000,1128422435),(24,'PAB','Panama (Panamanian Balboa)','',1.000000,1128422435),(25,'PEN','Peru (Peruvian New Sol)','',1.000000,1128422435),(26,'PHP','Philippine (Philippine Peso)','',1.000000,1128422435),(23,'PKR','Pakistan (Pakistan Rupee)','',1.000000,1128422435),(27,'PLN','Poland (Polish Zloty)','',1.000000,1128422435),(28,'RUR','Russian (Russian Rouble)','',1.000000,1128422435),(35,'SEK','Sweden (Swedish Krona)','',1.000000,1128422435),(29,'SGD','Singapore (Singapore Dollar)','',1.000000,1128422435),(31,'SIT','Slovenia (Slovenian Tolar)','',1.000000,1128422435),(30,'SKK','Slovakia (Koruna)','',1.000000,1128422435),(38,'THB','Thailand (Thailand Thai Baht)','',1.000000,1128422435),(39,'TND','Tunisia (Tunisisan Dinar)','',1.000000,1128422435),(40,'TRL','Turkey (Turkish Lira)','',1.000000,1128422435),(37,'TWD','Taiwan (Taiwanese New Dollar)','',1.000000,1128422435),(41,'USD','United States (U.S. Dollar)','selected',1.870000,1128422435),(42,'VEB','Venezuela (Bolivar)','',1.000000,1128422435),(32,'ZAR','South Africa (South African Rand)','',1.000000,1128422435);
/*!40000 ALTER TABLE `probid_currencies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_custom_rep`
--
DROP TABLE IF EXISTS `probid_custom_rep`;
CREATE TABLE `probid_custom_rep` (
`id` int(11) NOT NULL auto_increment,
`boxid` int(11) NOT NULL default '0',
`boxname` varchar(255) NOT NULL default '',
`boxtype` varchar(40) NOT NULL default '',
`boxvalue` varchar(255) NOT NULL default '',
`boxcaption` varchar(255) NOT NULL default '',
`boxorder` tinyint(4) NOT NULL default '0',
`mandatory` tinyint(4) NOT NULL default '1',
`active` tinyint(4) NOT NULL default '1',
`fieldorder` tinyint(4) NOT NULL default '0',
`usertype` varchar(20) NOT NULL default 'both',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_custom_rep`
--
LOCK TABLES `probid_custom_rep` WRITE;
/*!40000 ALTER TABLE `probid_custom_rep` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_custom_rep` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_custom_rep_data`
--
DROP TABLE IF EXISTS `probid_custom_rep_data`;
CREATE TABLE `probid_custom_rep_data` (
`id` int(11) NOT NULL auto_increment,
`feedbackid` int(11) NOT NULL default '0',
`boxid` int(11) NOT NULL default '0',
`boxvalue` text NOT NULL,
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_custom_rep_data`
--
LOCK TABLES `probid_custom_rep_data` WRITE;
/*!40000 ALTER TABLE `probid_custom_rep_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_custom_rep_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_dateformat`
--
DROP TABLE IF EXISTS `probid_dateformat`;
CREATE TABLE `probid_dateformat` (
`id` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`value` varchar(50) NOT NULL default '',
`name` varchar(20) NOT NULL default '',
`active` varchar(20) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with date format';
--
-- Dumping data for table `probid_dateformat`
--
LOCK TABLES `probid_dateformat` WRITE;
/*!40000 ALTER TABLE `probid_dateformat` DISABLE KEYS */;
INSERT INTO `probid_dateformat` VALUES (1,'USA','M. d, Y H:i:s','mm/dd/yyyy',''),(2,'non-USA','d M. Y H:i:s','dd/mm/yyyy','checked');
/*!40000 ALTER TABLE `probid_dateformat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_direct_payment`
--
DROP TABLE IF EXISTS `probid_direct_payment`;
CREATE TABLE `probid_direct_payment` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_direct_payment`
--
LOCK TABLES `probid_direct_payment` WRITE;
/*!40000 ALTER TABLE `probid_direct_payment` DISABLE KEYS */;
INSERT INTO `probid_direct_payment` VALUES (1,'PayPal',0),(2,'WorldPay',0),(3,'Ikobo',0),(4,'Nochex',0),(5,'2CheckOut',0),(6,'Authorize.Net',0),(7,'Protx',0);
/*!40000 ALTER TABLE `probid_direct_payment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_exchange`
--
DROP TABLE IF EXISTS `probid_exchange`;
CREATE TABLE `probid_exchange` (
`id` int(11) NOT NULL auto_increment,
`country` text NOT NULL,
`symbol` char(3) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_exchange`
--
LOCK TABLES `probid_exchange` WRITE;
/*!40000 ALTER TABLE `probid_exchange` DISABLE KEYS */;
INSERT INTO `probid_exchange` VALUES (1,'Euro - EUR','EUR'),(2,'United States Dollars - USD','USD'),(3,'United Kingdom Pounds - GBP','GBP'),(4,'Canada Dollars - CAD','CAD'),(5,'Japan Yen - JPY','JPY'),(6,'India Rupees - INR','INR'),(7,'New Zealand Dollars - NZD','NZD'),(8,'Switzerland Francs - CHF','CHF'),(9,'South Africa Rand - ZAR','ZAR'),(10,'Afghanistan Afghanis - AFN','AFN'),(11,'Albania Leke - ALL','ALL'),(12,'Algeria Dinars - DZD','DZD'),(13,'Argentina Pesos - ARS','ARS'),(14,'Australia Dollars - AUD','AUD'),(15,'Austria Schillings - ATS','ATS'),(16,'Bahamas Dollars - BSD','BSD'),(17,'Bahrain Dinars - BHD','BHD'),(18,'Bangladesh Taka - BDT','BDT'),(19,'Barbados Dollars - BBD','BBD'),(20,'Belgium Francs - BEF','BEF'),(21,'Bermuda Dollars - BMD','BMD'),(22,'Brazil Reais - BRL','BRL'),(23,'Bulgaria Leva - BGN','BGN'),(24,'CFA BCEAO Francs - XOF','XOF'),(25,'CFA BEAC Francs - XAF','XAF'),(26,'Chile Pesos - CLP','CLP'),(27,'China Yuan Renminbi - CNY','CNY'),(28,'RMB (China Yuan Renminbi) - CNY','CNY'),(29,'Colombia Pesos - COP','COP'),(30,'CFP Francs - XPF','XPF'),(31,'Costa Rica Colones - CRC','CRC'),(32,'Croatia Kuna - HRK','HRK'),(33,'Cyprus Pounds - CYP','CYP'),(34,'Czech Republic Koruny - CZK','CZK'),(35,'Denmark Kroner - DKK','DKK'),(36,'Deutsche (Germany) Marks - DEM','DEM'),(37,'Dominican Republic Pesos - DOP','DOP'),(38,'Dutch (Netherlands) Guilders - NLG','NLG'),(39,'Eastern Caribbean Dollars - XCD','XCD'),(40,'Egypt Pounds - EGP','EGP'),(41,'Estonia Krooni - EEK','EEK'),(42,'Fiji Dollars - FJD','FJD'),(43,'Finland Markkaa - FIM','FIM'),(44,'France Francs - FRF','FRF'),(45,'Germany Deutsche Marks - DEM','DEM'),(46,'Gold Ounces - XAU','XAU'),(47,'Greece Drachmae - GRD','GRD'),(48,'Holland (Netherlands) Guilders - NLG','NLG'),(49,'Hong Kong Dollars - HKD','HKD'),(50,'Hungary Forint - HUF','HUF'),(51,'Iceland Kronur - ISK','ISK'),(52,'IMF Special Drawing Right - XDR','XDR'),(53,'Indonesia Rupiahs - IDR','IDR'),(54,'Iran Rials - IRR','IRR'),(55,'Iraq Dinars - IQD','IQD'),(56,'Ireland Pounds - IEP','IEP'),(57,'Israel New Shekels - ILS','ILS'),(58,'Italy Lire - ITL','ITL'),(59,'Jamaica Dollars - JMD','JMD'),(60,'Jordan Dinars - JOD','JOD'),(61,'Kenya Shillings - KES','KES'),(62,'Korea (South) Won - KRW','KRW'),(63,'Kuwait Dinars - KWD','KWD'),(64,'Lebanon Pounds - LBP','LBP'),(65,'Luxembourg Francs - LUF','LUF'),(66,'Malaysia Ringgits - MYR','MYR'),(67,'Malta Liri - MTL','MTL'),(68,'Mauritius Rupees - MUR','MUR'),(69,'Mexico Pesos - MXN','MXN'),(70,'Morocco Dirhams - MAD','MAD'),(71,'Netherlands Guilders - NLG','NLG'),(72,'Norway Kroner - NOK','NOK'),(73,'Oman Rials - OMR','OMR'),(74,'Pakistan Rupees - PKR','PKR'),(75,'Palladium Ounces - XPD','XPD'),(76,'Peru Nuevos Soles - PEN','PEN'),(77,'Philippines Pesos - PHP','PHP'),(78,'Platinum Ounces - XPT','XPT'),(79,'Poland Zlotych - PLN','PLN'),(80,'Portugal Escudos - PTE','PTE'),(81,'Qatar Riyals - QAR','QAR'),(82,'Romania New Lei - RON','RON'),(83,'Romania Lei - ROL','ROL'),(84,'Russia Rubles - RUB','RUB'),(85,'Saudi Arabia Riyals - SAR','SAR'),(86,'Silver Ounces - XAG','XAG'),(87,'Singapore Dollars - SGD','SGD'),(88,'Slovakia Koruny - SKK','SKK'),(89,'Slovenia Tolars - SIT','SIT'),(90,'South Korea Won - KRW','KRW'),(91,'Spain Pesetas - ESP','ESP'),(92,'Special Drawing Rights (IMF) - XDR','XDR'),(93,'Sri Lanka Rupees - LKR','LKR'),(94,'Sudan Dinars - SDD','SDD'),(95,'Sweden Kronor - SEK','SEK'),(96,'Taiwan New Dollars - TWD','TWD'),(97,'Thailand Baht - THB','THB'),(98,'Trinidad and Tobago Dollars - TTD','TTD'),(99,'Tunisia Dinars - TND','TND'),(100,'Turkey New Lira - TRY','TRY'),(101,'United Arab Emirates Dirhams - AED','AED'),(102,'Venezuela Bolivares - VEB','VEB'),(103,'Vietnam Dong - VND','VND'),(104,'Zambia Kwacha - ZMK','ZMK');
/*!40000 ALTER TABLE `probid_exchange` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_faq_categories`
--
DROP TABLE IF EXISTS `probid_faq_categories`;
CREATE TABLE `probid_faq_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`lang` varchar(255) NOT NULL default 'english',
`theorder` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COMMENT='Table with FAQ categories';
--
-- Dumping data for table `probid_faq_categories`
--
LOCK TABLES `probid_faq_categories` WRITE;
/*!40000 ALTER TABLE `probid_faq_categories` DISABLE KEYS */;
INSERT INTO `probid_faq_categories` VALUES (11,'Selling','english',2),(10,'Registering','english',1),(12,'How to Bid','english',3);
/*!40000 ALTER TABLE `probid_faq_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_faq_questions`
--
DROP TABLE IF EXISTS `probid_faq_questions`;
CREATE TABLE `probid_faq_questions` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`sectionid` int(11) NOT NULL default '0',
`theorder` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COMMENT='Table with FAQ questions';
--
-- Dumping data for table `probid_faq_questions`
--
LOCK TABLES `probid_faq_questions` WRITE;
/*!40000 ALTER TABLE `probid_faq_questions` DISABLE KEYS */;
INSERT INTO `probid_faq_questions` VALUES (1,'(Q) How do I register?','(A) To register click on the "register" link found on both the header and footer navigation sections',10,0),(2,'(Q) I'm under 16 and can't signup?','(A) In accordance with standard law under 16's cannot participate in auctions as they legal binding contracts',10,0),(3,'(Q) How can I list an item?','(A) You must first be a registered member. Once you have registered simply login to your account and click on the "Sell" link. The first thing to do is select a general category for your item, note that you can choose a more specific category further into the listing process. You can then enter in your chosen settings and item description ',11,0),(4,'(Q) How can I keep track of items I'm selling?','(A) You can keep an eye on everything you are selling by visiting your members area and selecting
the "selling" page.',11,0),(5,'(Q) Can I use HTML when listing an item?','(A) Yes you can, however we recomend you use basic tags as complex HTML descriptions may not display correctly.',11,0),(6,'(Q) How can I place a bid?','(A) To place a bid on an item you must first login to your account. Once logged in a bidding box will be displayed at bottom of all auction pages. You can use this box to place you chosen bid ',12,0),(7,'(Q) How can I keep track of items I'm bidding on?','(A) You can keep an eye on everything you are bidding on by visiting your members area and selecting the "bidding" page. ',12,0),(8,'(Q) How do I know if I am outbid on an item?','(A) Our auction system will automatically notify you via email if you are outbid.',12,0);
/*!40000 ALTER TABLE `probid_faq_questions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_favourite_stores`
--
DROP TABLE IF EXISTS `probid_favourite_stores`;
CREATE TABLE `probid_favourite_stores` (
`id` int(11) NOT NULL auto_increment,
`storeid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_favourite_stores`
--
LOCK TABLES `probid_favourite_stores` WRITE;
/*!40000 ALTER TABLE `probid_favourite_stores` DISABLE KEYS */;
INSERT INTO `probid_favourite_stores` VALUES (1,3,4),(2,10,10);
/*!40000 ALTER TABLE `probid_favourite_stores` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_feedbacks`
--
DROP TABLE IF EXISTS `probid_feedbacks`;
CREATE TABLE `probid_feedbacks` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`usernick` varchar(255) NOT NULL default '',
`feedback` text NOT NULL,
`rate` double(16,0) NOT NULL default '0',
`date` datetime default NULL,
`fromid` int(11) NOT NULL default '0',
`submitted` tinyint(4) NOT NULL default '0',
`auctionid` int(11) NOT NULL default '0',
`type` varchar(15) NOT NULL default 'sale',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Table with feedbacks';
--
-- Dumping data for table `probid_feedbacks`
--
LOCK TABLES `probid_feedbacks` WRITE;
/*!40000 ALTER TABLE `probid_feedbacks` DISABLE KEYS */;
INSERT INTO `probid_feedbacks` VALUES (1,1,'hayesb2','gggggggh',5,'2007-09-20 17:18:16',4,1,2,'sale'),(2,4,'kk','',0,NULL,1,0,2,'purchase');
/*!40000 ALTER TABLE `probid_feedbacks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_fees`
--
DROP TABLE IF EXISTS `probid_fees`;
CREATE TABLE `probid_fees` (
`is_signup_fee` char(2) NOT NULL default 'N',
`val_signup_fee` double(16,2) NOT NULL default '0.00',
`is_setup_fee` char(2) NOT NULL default 'N',
`is_endauction_fee` char(2) NOT NULL default 'N',
`is_pic_fee` char(2) NOT NULL default 'N',
`val_pic_fee` double(16,2) NOT NULL default '0.00',
`piclimit` double(16,2) NOT NULL default '0.00',
`val_pic_fee2` double(16,2) NOT NULL default '0.00',
`is_hlitem_fee` char(2) NOT NULL default 'N',
`is_hlitem_percent` varchar(10) NOT NULL default 'flat',
`val_hlitem_fee` double(16,2) NOT NULL default '0.00',
`hlitemlimit` double(16,2) NOT NULL default '0.00',
`val_hlitem_fee2` double(16,2) NOT NULL default '0.00',
`is_bolditem_fee` char(2) NOT NULL default 'N',
`is_bolditem_percent` varchar(10) NOT NULL default 'flat',
`val_bolditem_fee` double(16,2) NOT NULL default '0.00',
`bolditemlimit` double(16,2) NOT NULL default '0.00',
`val_bolditem_fee2` double(16,2) NOT NULL default '0.00',
`is_hpfeat_fee` char(2) NOT NULL default 'N',
`is_hpfeat_percent` varchar(10) NOT NULL default 'flat',
`val_hpfeat_fee` double(16,2) NOT NULL default '0.00',
`hpfeatlimit` double(16,2) NOT NULL default '0.00',
`val_hpfeat_fee2` double(16,2) NOT NULL default '0.00',
`is_catfeat_fee` char(2) NOT NULL default 'N',
`is_catfeat_percent` varchar(10) NOT NULL default 'flat',
`val_catfeat_fee` double(16,2) NOT NULL default '0.00',
`catfeatlimit` double(16,2) NOT NULL default '0.00',
`val_catfeat_fee2` double(16,2) NOT NULL default '0.00',
`is_rp_fee` char(2) NOT NULL default 'N',
`val_rp_fee` double(16,2) NOT NULL default '0.00',
`is_swap_fee` char(2) NOT NULL default '',
`val_swap_fee` double(16,2) NOT NULL default '0.00',
`second_cat_fee` double(16,2) NOT NULL default '0.00',
`bin_fee` double(16,2) NOT NULL default '0.00',
`wantedad_fee` double(16,2) NOT NULL default '0.00',
`store_fee` double(16,2) NOT NULL default '0.00',
`store_fee_type` tinyint(4) NOT NULL default '0',
`store_fee_cycle` tinyint(4) NOT NULL default '0',
`is_store_fee` char(2) NOT NULL default 'N',
`category_id` int(11) NOT NULL default '0',
`endauction_fee_applies` enum('s','b') NOT NULL default 's',
`custom_st_fee` double(16,2) NOT NULL default '0.00',
`relist_fee_reduction` double(16,2) NOT NULL default '0.00',
`videofile_fee` double(16,2) NOT NULL default '0.00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with fees';
--
-- Dumping data for table `probid_fees`
--
LOCK TABLES `probid_fees` WRITE;
/*!40000 ALTER TABLE `probid_fees` DISABLE KEYS */;
INSERT INTO `probid_fees` VALUES ('N',0.00,'Y','Y','Y',0.10,0.00,0.00,'Y','flat',1.00,0.00,0.00,'Y','flat',0.40,0.00,0.00,'Y','flat',1.50,0.00,0.00,'Y','flat',1.10,0.00,0.00,'Y',0.60,'Y',4.00,0.40,1.00,0.60,2.00,0,30,'Y',0,'s',0.00,0.00,0.00);
/*!40000 ALTER TABLE `probid_fees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_fees_tiers`
--
DROP TABLE IF EXISTS `probid_fees_tiers`;
CREATE TABLE `probid_fees_tiers` (
`id` int(11) NOT NULL auto_increment,
`fee_from` double(16,2) NOT NULL default '0.00',
`fee_to` double(16,2) NOT NULL default '0.00',
`fee_amount` double(16,2) NOT NULL default '0.00',
`calc_type` varchar(20) NOT NULL default '',
`fee_type` varchar(20) NOT NULL default '',
`store_nb_items` int(11) NOT NULL default '0',
`store_recurring` int(11) NOT NULL default '0',
`store_name` varchar(255) NOT NULL default '',
`category_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_fees_tiers`
--
LOCK TABLES `probid_fees_tiers` WRITE;
/*!40000 ALTER TABLE `probid_fees_tiers` DISABLE KEYS */;
INSERT INTO `probid_fees_tiers` VALUES (1,0.01,7.00,2.00,'flat','endauction',0,0,'',0),(2,7.00,10.00,4.50,'percent','endauction',0,0,'',0),(3,10.00,50.00,4.00,'percent','endauction',0,0,'',0),(4,50.00,250.00,3.00,'percent','endauction',0,0,'',0),(5,250.00,1000.00,2.50,'percent','endauction',0,0,'',0),(6,1000.00,99999999999.00,2.20,'percent','endauction',0,0,'',0),(8,0.01,1.00,10.00,'percent','setup',0,0,'',0),(9,1.00,5.00,7.50,'percent','setup',0,0,'',0),(10,5.00,25.00,5.00,'percent','setup',0,0,'',0),(11,25.00,100.00,4.00,'percent','setup',0,0,'',0),(12,100.00,500.00,3.00,'percent','setup',0,0,'',0),(13,500.00,5000.00,2.75,'percent','setup',0,0,'',0),(14,5000.00,99999999999.00,2.40,'percent','setup',0,0,'',0),(20,0.00,0.00,10.00,'flat','store',50,30,'Advanced Store',0),(21,0.00,0.00,1.00,'flat','store',2,30,'Basic Store',0),(18,0.00,0.00,3.00,'flat','store',10,30,'Medium Store',0),(24,0.00,0.00,30.00,'flat','store',200,30,'Expert Store',0);
/*!40000 ALTER TABLE `probid_fees_tiers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_fields`
--
DROP TABLE IF EXISTS `probid_fields`;
CREATE TABLE `probid_fields` (
`id` int(11) NOT NULL auto_increment,
`boxid` int(11) NOT NULL default '0',
`boxname` varchar(255) NOT NULL default '',
`boxtype` varchar(40) NOT NULL default '',
`boxvalue` varchar(255) NOT NULL default '',
`boxcaption` varchar(255) NOT NULL default '',
`boxorder` tinyint(4) NOT NULL default '0',
`mandatory` tinyint(4) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '1',
`fieldorder` tinyint(4) NOT NULL default '0',
`categoryid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_fields`
--
LOCK TABLES `probid_fields` WRITE;
/*!40000 ALTER TABLE `probid_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_fields_data`
--
DROP TABLE IF EXISTS `probid_fields_data`;
CREATE TABLE `probid_fields_data` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`boxid` int(11) NOT NULL default '0',
`boxvalue` text NOT NULL,
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_fields_data`
--
LOCK TABLES `probid_fields_data` WRITE;
/*!40000 ALTER TABLE `probid_fields_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_fields_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_fields_types`
--
DROP TABLE IF EXISTS `probid_fields_types`;
CREATE TABLE `probid_fields_types` (
`id` int(11) NOT NULL auto_increment,
`fieldtype` varchar(100) NOT NULL default '',
`maxfields` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_fields_types`
--
LOCK TABLES `probid_fields_types` WRITE;
/*!40000 ALTER TABLE `probid_fields_types` DISABLE KEYS */;
INSERT INTO `probid_fields_types` VALUES (1,'text',1),(2,'textarea',1),(3,'list',15),(4,'checkbox',5),(5,'radio',5);
/*!40000 ALTER TABLE `probid_fields_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_gen_setts`
--
DROP TABLE IF EXISTS `probid_gen_setts`;
CREATE TABLE `probid_gen_setts` (
`sitename` varchar(255) NOT NULL default '',
`siteurl` varchar(255) NOT NULL default '',
`my_dir` varchar(255) NOT NULL default '',
`adminemail` varchar(255) NOT NULL default '',
`paypalemail` varchar(255) NOT NULL default '',
`worldpayid` varchar(50) NOT NULL default '',
`checkoutid` varchar(50) NOT NULL default '',
`ikobombid` varchar(100) NOT NULL default '',
`ikoboipn` varchar(100) NOT NULL default '',
`protxname` varchar(100) NOT NULL default '',
`protxpass` varchar(100) NOT NULL default '',
`authnetid` varchar(100) NOT NULL default '',
`authnettranskey` varchar(100) NOT NULL default '',
`language` tinyint(4) NOT NULL default '0',
`currency_symbol` varchar(10) NOT NULL default '',
`money_format` tinyint(4) NOT NULL default '0',
`digits` tinyint(4) NOT NULL default '0',
`position` tinyint(4) NOT NULL default '0',
`pic_gal_active` tinyint(4) NOT NULL default '0',
`pic_gal_max_nb` tinyint(4) NOT NULL default '0',
`pic_gal_max_size` int(11) NOT NULL default '0',
`addr_val` tinyint(4) NOT NULL default '0',
`error_text` blob NOT NULL,
`error_email` varchar(255) NOT NULL default '',
`hp_feat` tinyint(4) NOT NULL default '0',
`cat_feat` tinyint(4) NOT NULL default '0',
`bold_item` tinyint(4) NOT NULL default '0',
`hl_item` tinyint(4) NOT NULL default '0',
`swap_items` tinyint(4) NOT NULL default '0',
`cron_job` tinyint(4) NOT NULL default '1',
`h_counter` tinyint(4) NOT NULL default '0',
`is_ssl` tinyint(4) NOT NULL default '0',
`ssl_address` varchar(255) NOT NULL default '',
`account_mode` tinyint(4) NOT NULL default '0',
`max_credit` double(16,2) NOT NULL default '0.00',
`init_credit` double(16,2) NOT NULL default '0.00',
`auction_deletion` smallint(6) NOT NULL default '0',
`user_deletion` smallint(6) NOT NULL default '30',
`shipping_costs` char(2) NOT NULL default '',
`default_theme` varchar(30) NOT NULL default '',
`metatags` text NOT NULL,
`bidretraction` char(2) NOT NULL default 'N',
`lkey` varchar(50) NOT NULL default '',
`default_lang` varchar(30) NOT NULL default '',
`admin_lang` varchar(30) NOT NULL default '',
`alwaysshowbuynow` tinyint(4) NOT NULL default '0',
`secondcategory` tinyint(4) NOT NULL default '0',
`paypaldirectpayment` tinyint(4) NOT NULL default '0',
`mailer` varchar(20) NOT NULL default '',
`sendmail_path` varchar(200) NOT NULL default '',
`smtp_host` varchar(100) NOT NULL default '',
`smtp_port` varchar(10) NOT NULL default '',
`smtp_auth` varchar(10) NOT NULL default '',
`smtp_username` varchar(100) NOT NULL default '',
`smtp_password` varchar(100) NOT NULL default '',
`userlang` tinyint(4) NOT NULL default '0',
`sniping_feature` char(2) NOT NULL default 'Y',
`sniping_duration` int(11) NOT NULL default '20',
`private_site` char(2) NOT NULL default 'N',
`pref_sellers` char(2) NOT NULL default 'N',
`pref_sellers_reduction` double(16,2) NOT NULL default '0.00',
`verify_strikes` tinyint(4) NOT NULL default '0',
`verify_strikes_duration` int(11) NOT NULL default '0',
`enable_bcc` char(2) NOT NULL default 'N',
`enable_asq` char(2) NOT NULL default 'Y',
`enable_ra` char(2) NOT NULL default 'N',
`enable_wantedads` char(2) NOT NULL default 'Y',
`hpfeat_desc` char(2) NOT NULL default 'Y',
`vat_rate` double(16,2) NOT NULL default '0.00',
`auto_vat_exempt` char(2) NOT NULL default 'N',
`invoice_header` text,
`invoice_footer` text,
`enable_mlc` varchar(5) NOT NULL default 'Y',
`vat_number` varchar(100) NOT NULL default '',
`invoice_comments` mediumtext NOT NULL,
`enable_bid_retraction` char(2) NOT NULL default 'N',
`moneybookersemail` varchar(255) NOT NULL default '',
`min_reg_age` smallint(6) NOT NULL default '0',
`birthdate_type` tinyint(4) NOT NULL default '0',
`nb_other_items_adp` tinyint(4) NOT NULL default '0',
`maintenance_mode` tinyint(4) NOT NULL default '0',
`stores_enabled` char(2) NOT NULL default 'Y',
`account_mode_personal` tinyint(4) NOT NULL default '0',
`enable_bulk_lister` tinyint(4) NOT NULL default '1',
`suspend_over_bal_users` tinyint(4) NOT NULL default '1',
`activation_key` varchar(255) NOT NULL default '',
`min_invoice_value` double(16,2) NOT NULL default '0.00',
`init_acc_type` tinyint(4) NOT NULL default '0',
`enable_vat` tinyint(4) default '0',
`enable_cat_counters` enum('Y','N') NOT NULL default 'Y',
`enable_movie_upload` enum('Y','N') NOT NULL default 'N',
`movie_upload_max_size` double(16,2) NOT NULL default '0.00',
`enable_display_phone` enum('Y','N') NOT NULL default 'Y',
`video_gal_max_size` int(11) NOT NULL default '0',
`enable_auctions_approval` enum('Y','N') NOT NULL default 'N',
`approval_categories` text NOT NULL,
`is_mod_rewrite` enum('Y','N') NOT NULL default 'N',
`buyout_process` tinyint(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with General Settings';
--
-- Dumping data for table `probid_gen_setts`
--
LOCK TABLES `probid_gen_setts` WRITE;
/*!40000 ALTER TABLE `probid_gen_setts` DISABLE KEYS */;
INSERT INTO `probid_gen_setts` VALUES ('Auction Demo','http://www.turnkeynation.com/AuctionPro/','probidv5/','sales@turnkeynation.com','me@me.com','53725','102958','230498','029348','testvendor','testendor','AUTHNET','ANTRANSKEY',1,'USD',2,2,2,1,4,50,1,'An error has occured. Sorry for the inconvenience. Please report this problem to us so we can fix the error. If you receive any error message please qoute these in any email.\r\n\r\nThank you','support@yoursite.com',1,1,1,1,1,2,1,0,'http://localhost/probidv5/',2,15.00,3.00,90,30,'1','v5','\r\n','Y','','english','english',0,1,0,'mail','/usr/sbin/sendmail','','','','','',1,'Y',20,'N','Y',50.00,5,30,'N','Y','N','Y','Y',0.00,'N','Header',NULL,'Y','GB-0324982','Comments','Y','koyote2001@hotmail.com',21,1,4,0,'Y',0,0,1,'',0.00,1,0,'Y','N',0.00,'Y',0,'N','','N',0);
/*!40000 ALTER TABLE `probid_gen_setts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_help_categories`
--
DROP TABLE IF EXISTS `probid_help_categories`;
CREATE TABLE `probid_help_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`lang` varchar(50) NOT NULL default '',
`parent` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_help_categories`
--
LOCK TABLES `probid_help_categories` WRITE;
/*!40000 ALTER TABLE `probid_help_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_help_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_help_topics`
--
DROP TABLE IF EXISTS `probid_help_topics`;
CREATE TABLE `probid_help_topics` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`lang` varchar(255) NOT NULL default 'english',
`theorder` tinyint(4) NOT NULL default '0',
`regdate` int(11) NOT NULL default '0',
`rating` tinyint(4) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`category` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COMMENT='Table with help topics';
--
-- Dumping data for table `probid_help_topics`
--
LOCK TABLES `probid_help_topics` WRITE;
/*!40000 ALTER TABLE `probid_help_topics` DISABLE KEYS */;
INSERT INTO `probid_help_topics` VALUES (11,'Dutch auctions','On a Dutch Auction, the auctioneer has more items of the same product for sale. The bidder will enter a maximum bid he is willing to pay for an item, and the number of items he wants to purchase. The highest bidder(s) will receive the number of items they have bid on, and the remaining bidders will receive the number of items still available. Buyers are able to bid more than once for the same item. ','english',0,0,0,0,0),(12,'Feedback system','Once a sale has been processed, both the seller and the buyer will be able to leave feedbacks for each other. The feedback rating is from one star to five stars, and a feedback comment can also be left. The feedback can be left from the “Feedback†tab from the Members Area. The feedback can only be left once, and it cannot be edited afterwards.
The site admin will reserve its right to delete malicious or untrue feedbacks.
','english',0,0,0,0,0),(13,'Item watching','The item watch features lets you keep a close eye on any auction without having to place a bid on it. This feature means you can be kept up to date on how an auction is doing and prepares you to place a winning last minute bid. You can watch any auction by clicking on the “Watch this item†link on any auction page. ','english',0,0,0,0,0),(14,'Auction watch','The auction watch features notifies you of newly listed auctions which contain “keywords†you have chosen. For example if you are looking for a “Playstation 2†you could enter in those keywords from within your member’s area. Each time a new auction is listed containing the term “Playstation 2†you will be notified via this web-site. You can enter in as many keywords as you like. ','english',0,0,0,0,0),(10,'Members Area','Members Area
Once you have successfully logged in using the login forms from the main page or from the login page (click on the “login†button from the page header), you will be redirected to the members area page. This page is divided into four tabs:
a. Bidding
On this page, you will be able to see the items your currently bidding on, as well as the status of the bids, items you have won, and watched items. By clicking on the “Auction Watch†link, you will be able to add keywords for auctions your interested in. An email will be sent to your email address every time an auction that will contain the keyword in its name or description will be submitted.
By clicking on the “View Details†link from the Won Items area, you will be able to see the details of the seller, and make contact with him in order to perfect the sale.
b. Selling
There are three areas available on this page.
The “My Opened Auctions†area, where you will see details of auctions you currently has open; if no bids were submitted yet on an open auction, you are able to edit the auction.
The “My Closed Auctions†area, where you will see the auctions submitted by yourself, and that were closed. You can choose to edit, delete or re-list a closed auction.
On the “Sold Items†area, you will see the items you have sold, and by clicking on the “View Details†link, you will be redirected to a page where you will see the details of the buyer. If an end of auction fee is set from the admin area, then the seller will have to pay for the end of auction fee in order for you to see the buyer details.
If, after the seller has contacted the bidder, and no sale has been made, you can claim back the end of auction fee. By clicking on the “Claim back end of auction feeâ€, a claim back request will be sent to the site’s administrator, and will be evaluated for fee refunding.
c. Feedback
From this page, you will be able to see the feedbacks you have received, and leave feedbacks to other users.
d. Personal Info
You can edit your personal information using this page, except for your username. You can also change the password for the account. If the password and confirm password fields are left empty, and then the password will remain the same.
','english',0,0,0,0,0),(8,'How To Sell','Once you have signed up for an account, you will be able to sell items through the site.
In order to do that, you will have to click on the “Sell†link, and you will be redirected to a page, you can then select the main category of the product or service you want to sell. This feature has been made in order to ease the subcategory choosing process. No items can be sold by choosing only the main category; you will have to choose a subcategory for it.
The second step is entering the auction details, settings, payment methods available, and choosing a category. An image that will come with the auction is free of charge, but the admin may charge for adding additional pictures.
On the Auction Settings tab, you can choose the type of the auction, the start price, whether to activate buy now or set a reserve price.
Also, you will be able to choose what type of bid increment to use, the progressive one implemented into the site (that can be edited from the admin area), or a custom one. If you choose the custom one, you will have to enter an increment value.
You will also be able to choose whether to feature the item, and the duration of the auction.
After setting the location, shipping and payment and subcategory, and by clicking on the “Next Step†button, you will be redirected to Step Three, where you can review the auction before submitting. If everything is in order, you can click on the “Submit†button, and will be redirected to the payment page, or a confirmation page, if no fees have to be paid. The auction is activated once the payment is confirmed by the payment gateway, or instantly, if no fees need to be paid.
','english',0,0,0,0,0),(9,'Registering','Registration is simple and only takes a matter minutes. To start the signup process, click on the “register†link at the top of this page. Only users with the age over 16 years are able to register.
The next step is to fill in all your information, failure to supply all the required information will result in an error.
By clicking on the “Register†button from the bottom of the page, you will be redirected to a page with a link to the payment gateway if the signup fee is activated, or to a confirmation page, if signup is free.
Your account will be activated instantly if there is no signup fee, or once the payment has been confirmed by the payment gateway.
','english',0,0,0,0,0),(7,'How To Bid','If you have spotted on item you would like to place a bid on you can do so quickly and easily by following these steps:- (1) Login to your account – If you have not registered you can do so within 5 minutes (2) Visit the auction page (3) Towards the bottom of the auction description page you will see a “bidding boxâ€, you can use the shortcut link to the bidding box if you wish. (4) Enter in your bid, note you must bid above the minimum bid required (5) Click on the “place bid†button (6) You will then be asked to confirm you bid, once you have done so your bid will be entered, if successful you will receive a confirmation message. If you bid fails to outbid the current high bidder you will be offered the option to place a higher bid. Proxy bidding can aid your chances of winning an auction and help avoid you being outbid at the last moment. To place a proxy bid enter in the maximum price you are willing to pay for the item. If another user places a bid on the same auction automatic bids will be placed on your behalf in accordance with your maximum bid amount. With proxy bidding you will pay the lowest possible price until someone else places a higher bid. There is another way of bidding: Buy it now auctions. Buy it now prices are set by the seller, if you agree with that price, you can click on the “Buy Now†button which is displayed on the auction details page. After clicking on the button you will be re-directed to a confirmation page. On a standard auction that auction will end instantly as the item has been sold via Buy it now. On a Dutch auction, you can enter the amount of items you wish to buy (depending the quantity available).
If you purchase less than there are available in total, the auction will remain open with the number of items left available after you have purchased the amount you want.
','english',0,0,0,0,0),(18,'Wanted Ads','Wanted ads are a new and increasingly popular feature. As an advertiser you can list adverts for items you want and sellers can submit offers for items they are selling. It’s a quick, simple and hassle free way of sellers being able to meet buyers demands.
Advertiser (Buyer)
List a new wanted ad and wait for sellers to contact you with offers. If you receive an offer your happy with you can bid on the item!
Sellers
Browse the wanted ads and if you see one that matches an item your selling make an offer and tell the buyer you have just what they are looking for!
','english',0,0,0,0,0);
/*!40000 ALTER TABLE `probid_help_topics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_invoices`
--
DROP TABLE IF EXISTS `probid_invoices`;
CREATE TABLE `probid_invoices` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`auctionid` int(11) NOT NULL default '0',
`feename` varchar(100) NOT NULL default '',
`feevalue` double(16,2) NOT NULL default '0.00',
`feedate` int(11) NOT NULL default '0',
`balance` double(16,2) NOT NULL default '0.00',
`transtype` varchar(20) NOT NULL default 'pending',
`processor` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_invoices`
--
LOCK TABLES `probid_invoices` WRITE;
/*!40000 ALTER TABLE `probid_invoices` DISABLE KEYS */;
INSERT INTO `probid_invoices` VALUES (1,1,0,'Registration Fee',0.00,1177721129,-3.00,'pending',''),(2,1,0,'Admin Credit Adjustment',47.00,1177721219,-50.00,'payment','ADMIN'),(3,1,1,'Auction Setup Fee',0.10,1177721721,-49.90,'pending',''),(4,1,1,'Category Page Feature Fee',2.20,1177721721,-47.70,'pending',''),(5,1,1,'Home Page Featured Fee',1.50,1177721721,-46.20,'pending',''),(6,1,1,'Second Category Fee',0.40,1177721721,-45.80,'pending',''),(7,1,1,'Buy Out Setup Fee',1.00,1177721721,-44.80,'pending',''),(8,1,2,'Auction Setup Fee',4.00,1177722202,-40.80,'pending',''),(9,1,2,'Category Page Feature Fee',2.20,1177722202,-38.60,'pending',''),(10,1,2,'Highlighted Item Fee',1.00,1177722202,-37.60,'pending',''),(11,1,2,'Home Page Featured Fee',1.50,1177722202,-36.10,'pending',''),(12,1,2,'Second Category Fee',0.40,1177722202,-35.70,'pending',''),(13,1,2,'Buy Out Setup Fee',1.00,1177722202,-34.70,'pending',''),(14,2,0,'Registration Fee',0.00,1177739716,-3.00,'pending',''),(15,3,0,'Registration Fee',0.00,1189546613,-3.00,'pending',''),(16,3,0,'Store Setup Fee',10.00,1189546798,10.00,'pending',''),(17,4,0,'Registration Fee',0.00,1190314314,-3.00,'pending',''),(18,4,3,'Auction Setup Fee',0.07,1190322862,-2.92,'pending',''),(19,1,2,'End of Auction Fee - Buy Now x 1',55.00,1190322961,20.30,'pending',''),(20,4,0,'Store Setup Fee',10.00,1190323285,10.00,'pending',''),(21,4,3,'Category Page Feature Fee',1.10,1190323946,8.18,'pending',''),(22,4,3,'Highlighted Item Fee',1.00,1190323946,9.18,'pending',''),(23,4,3,'Home Page Featured Fee',1.50,1190323946,10.68,'pending',''),(24,4,0,'Payment',10.68,1190324569,0.00,'payment','Test Mode'),(25,4,3,'Reserve Price Fee',0.60,1190325947,0.60,'pending',''),(26,4,3,'Buy Out Setup Fee',1.00,1190325947,1.60,'pending',''),(27,4,4,'Auction Setup Fee',0.07,1190411285,1.68,'pending',''),(28,4,4,'Category Page Feature Fee',1.10,1190411286,2.77,'pending',''),(29,4,4,'Highlighted Item Fee',1.00,1190411286,3.77,'pending',''),(30,4,4,'Home Page Featured Fee',1.50,1190411286,5.28,'pending',''),(31,4,4,'Reserve Price Fee',0.60,1190411286,5.88,'pending',''),(32,4,4,'Buy Out Setup Fee',1.00,1190411286,6.88,'pending',''),(33,4,5,'Auction Setup Fee',0.07,1190503006,6.96,'pending',''),(34,4,5,'Category Page Feature Fee',1.10,1190503006,8.05,'pending',''),(35,4,5,'Highlighted Item Fee',1.00,1190503006,9.05,'pending',''),(36,4,5,'Home Page Featured Fee',1.50,1190503006,10.55,'pending',''),(37,4,5,'Reserve Price Fee',0.60,1190503006,11.15,'pending',''),(38,4,5,'Buy Out Setup Fee',1.00,1190503006,12.15,'pending',''),(39,4,6,'Auction Setup Fee',0.07,1190662109,12.23,'pending',''),(40,4,6,'Category Page Feature Fee',1.10,1190662109,13.34,'pending',''),(41,4,6,'Highlighted Item Fee',1.00,1190662109,14.34,'pending',''),(42,4,6,'Home Page Featured Fee',1.50,1190662109,15.84,'pending',''),(43,4,6,'Reserve Price Fee',0.60,1190662109,16.43,'pending',''),(44,4,6,'Buy Out Setup Fee',1.00,1190662109,17.43,'pending',''),(45,3,0,'Store Setup Fee',10.00,1192152379,10.00,'pending',''),(46,5,0,'Registration Fee',0.00,1194167014,-3.00,'pending',''),(47,6,0,'Registration Fee',0.00,1197436483,-3.00,'pending',''),(48,7,0,'Registration Fee',0.00,1209063476,-3.00,'pending',''),(49,7,7,'Auction Setup Fee',0.07,1209064837,-2.92,'pending',''),(50,8,0,'Registration Fee',0.00,1211573451,-3.00,'pending',''),(51,9,0,'Registration Fee',0.00,1212623462,-3.00,'pending',''),(52,9,1,'Wanted Ad Setup Fee',0.60,1212623712,-2.40,'pending',''),(53,9,8,'Auction Setup Fee',0.50,1212625790,-1.90,'pending',''),(54,9,8,'Home Page Featured Fee',1.50,1212625790,-0.40,'pending',''),(55,9,8,'Buy Out Setup Fee',1.00,1212625790,0.60,'pending',''),(56,9,0,'Store Setup Fee',10.00,1212625987,10.00,'pending',''),(57,9,9,'Auction Setup Fee',0.50,1212627954,11.10,'pending',''),(58,9,9,'Category Page Feature Fee',2.20,1212627954,13.30,'pending',''),(59,9,9,'Highlighted Item Fee',1.00,1212627954,14.30,'pending',''),(60,9,9,'Home Page Featured Fee',1.50,1212627954,15.80,'pending',''),(61,9,9,'Reserve Price Fee',0.60,1212627954,16.40,'pending',''),(62,9,9,'Second Category Fee',0.40,1212627954,16.80,'pending',''),(63,9,0,'Payment',16.80,1212628070,0.00,'payment','Test Mode'),(64,9,10,'Auction Setup Fee',0.07,1212789832,0.07,'pending',''),(65,9,10,'Category Page Feature Fee',1.10,1212789832,1.18,'pending',''),(66,9,10,'Highlighted Item Fee',1.00,1212789832,2.17,'pending',''),(67,9,10,'Home Page Featured Fee',1.50,1212789832,3.67,'pending',''),(68,9,10,'Reserve Price Fee',0.60,1212789832,4.28,'pending',''),(69,10,0,'Registration Fee',0.00,1213792509,-3.00,'pending',''),(70,10,0,'Store Setup Fee',30.00,1213792987,30.00,'pending',''),(71,10,0,'Payment',27.00,1213793095,0.00,'payment','Test Mode'),(72,10,2,'Wanted Ad Setup Fee',0.60,1213802195,0.60,'pending',''),(73,10,0,'Payment',0.60,1213802618,0.00,'payment','Test Mode'),(74,9,11,'Auction Setup Fee',0.25,1213906209,4.53,'pending',''),(75,9,11,'Category Page Feature Fee',1.10,1213906209,5.63,'pending',''),(76,9,11,'Highlighted Item Fee',1.00,1213906209,6.63,'pending',''),(77,9,11,'Home Page Featured Fee',1.50,1213906209,8.13,'pending',''),(78,9,12,'Auction Setup Fee',0.15,1214676272,8.28,'pending',''),(79,9,12,'Category Page Feature Fee',1.10,1214676272,9.38,'pending',''),(80,9,12,'Highlighted Item Fee',1.00,1214676272,10.38,'pending',''),(81,9,0,'Store Setup Fee',10.00,1215221915,10.00,'pending',''),(82,10,0,'Store Setup Fee',30.00,1217964222,30.00,'pending',''),(83,11,0,'Registration Fee',0.00,1238530710,-3.00,'pending',''),(84,12,0,'Registration Fee',0.00,1241183998,-3.00,'pending','');
/*!40000 ALTER TABLE `probid_invoices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_iphistory`
--
DROP TABLE IF EXISTS `probid_iphistory`;
CREATE TABLE `probid_iphistory` (
`memberid` int(11) NOT NULL default '0',
`time1` int(11) NOT NULL default '0',
`time2` int(11) NOT NULL default '0',
`ip` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_iphistory`
--
LOCK TABLES `probid_iphistory` WRITE;
/*!40000 ALTER TABLE `probid_iphistory` DISABLE KEYS */;
INSERT INTO `probid_iphistory` VALUES (1,1177721171,1177722531,'70.63.2.124'),(2,1177739764,1177769362,'68.13.243.209'),(3,1189546735,1189546959,'71.67.135.72'),(4,1190314346,1190503386,'89.243.226.131'),(5,1194167539,0,'198.54.202.218'),(5,1194167548,0,'198.54.202.214'),(5,1194167632,0,'198.54.202.218'),(5,1194167652,0,'196.25.255.246'),(5,1194167708,1194167871,'196.25.255.250'),(5,1194168015,0,'196.25.255.246'),(5,1194168132,0,'198.54.202.234'),(5,1194168214,0,'198.54.202.195'),(5,1194168218,0,'196.25.255.246'),(5,1194168271,0,'196.25.255.218'),(6,1197436813,1197438255,'69.229.62.146'),(7,1209063674,1209168144,'24.187.16.127'),(8,1211573518,1211574435,'69.128.203.184'),(9,1212623575,1214676410,'63.115.165.113'),(10,1213792632,1213811404,'86.43.109.147'),(11,1238531147,1238531348,'71.114.50.90');
/*!40000 ALTER TABLE `probid_iphistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_keywords_watch`
--
DROP TABLE IF EXISTS `probid_keywords_watch`;
CREATE TABLE `probid_keywords_watch` (
`id` int(11) NOT NULL auto_increment,
`bidderid` int(11) NOT NULL default '0',
`keyword` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with keywords for auction watch option';
--
-- Dumping data for table `probid_keywords_watch`
--
LOCK TABLES `probid_keywords_watch` WRITE;
/*!40000 ALTER TABLE `probid_keywords_watch` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_keywords_watch` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_layout_setts`
--
DROP TABLE IF EXISTS `probid_layout_setts`;
CREATE TABLE `probid_layout_setts` (
`logo_path` varchar(255) NOT NULL default '',
`site_align` varchar(10) NOT NULL default '',
`nb_feat_hp` tinyint(4) NOT NULL default '0',
`w_feat_hp` smallint(6) NOT NULL default '0',
`max_feat_hp` tinyint(4) NOT NULL default '0',
`nb_feat_cat` tinyint(4) NOT NULL default '0',
`w_feat_cat` smallint(6) NOT NULL default '0',
`max_feat_cat` tinyint(4) NOT NULL default '0',
`nb_last_auct` smallint(6) NOT NULL default '0',
`nb_hot_auct` smallint(6) NOT NULL default '0',
`nb_end_auct` smallint(6) NOT NULL default '0',
`d_login_box` tinyint(4) NOT NULL default '0',
`d_news_box` tinyint(4) NOT NULL default '0',
`d_news_nb` tinyint(4) NOT NULL default '0',
`act_newsletter` tinyint(4) NOT NULL default '0',
`act_buynow` tinyint(4) NOT NULL default '0',
`act_proxy` tinyint(4) NOT NULL default '0',
`d_acc_text` tinyint(4) NOT NULL default '0',
`acc_text` blob NOT NULL,
`d_tc_text` tinyint(4) NOT NULL default '0',
`tc_text` longtext NOT NULL,
`is_faq` char(2) NOT NULL default 'N',
`is_about` char(2) NOT NULL default 'N',
`is_terms` char(2) NOT NULL default 'N',
`is_contact` char(2) NOT NULL default 'N',
`is_pp` char(2) NOT NULL default '',
`nb_want_ads` tinyint(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with the site''s general layout settings';
--
-- Dumping data for table `probid_layout_setts`
--
LOCK TABLES `probid_layout_setts` WRITE;
/*!40000 ALTER TABLE `probid_layout_setts` DISABLE KEYS */;
INSERT INTO `probid_layout_setts` VALUES ('images/probidlogo.gif','',3,100,6,3,100,6,5,5,5,1,1,5,0,1,0,0,'General Terms and Conditions
This web-site is intended to be a friendly, enjoyable and useful experience, but as with anything concerning any kind of transactions there are risks involved and we strongly advise you to understand all of these terms before joining. If you spot a listing that you feel is violating the general terms and conditions of this web-site as stated below please let us know by contacting us.
Rights To Suspend or Terminate.
You agree that this web-site, in its own discretion, may terminate any auction or use of the service immediately and without notice if (a) We believe that you are not abiding by the general rules of this web-site (b) You have repeatedly broken a certain term (c) You have listed a suspicious item (d) We believe you to be a non paying bidder. In most cases when we suspect foul play we will suspend your account/listing whilst we investigate further. If our investigation is conclusive then your account with us will be terminated.
Your Conduct.
You are solely responsible for the contents of your actions through this web-site. You must ensure that your participation in the selling or buying of items does not violate any applicable laws or regulations. By this we mean that you must check that you entitled to sell or buy the relevant item and that you are not prohibited from doing so by any law or regulation.
You must not transmit through the service any unlawful, harassing, libelous, abusive, threatening, harmful, vulgar, obscene or otherwise objectionable material. You must also not transmit any material that encourages conduct that could constitute a criminal offence, give rise to civil liability or otherwise violate any applicable law or regulation.
Membership.
Membership to this web-site is only available to those you can form a legally binding contract. This web-site does not permit minors (under 16) to register. If any member fails to signup with their correct age the account will be terminated immediately.
General Terms.
This site acts as the window for sellers to conduct auctions and for bidders to bid on sellers' auctions. We are not involved in the actual transaction between buyers and sellers. As a result, we have no control over the quality, safety or legality of the items listed the truth or accuracy of the listings, the ability of sellers to sell items or the ability of buyers to buy items. We cannot and do not control whether or not sellers will complete the sale of items they offer or buyers will complete the purchases of items they have bid on. In addition, note that there are risks of dealing with foreign nationals, underage persons or people acting under false pretence.
This Web-site shall not be responsible for any items sold by Auction, for any damage to items during transit or during the inspection period, nor for misrepresentations and/or breaches of contract by either buyer and/or seller. This web-site shall not be responsible for the cost of procurement of substitute goods or any losses resulting form any goods purchased or obtained.
This web-site assumes no liability for the content of the listings. However if you fall victim of a fraudulent transaction we will assist you as much as we can.
Laws.
These Terms of Service shall be governed by and constructed in accordance with the laws of England and Wales and any disputes will be decided only by the Courts of England and Wales.
',1,'General Terms and Conditions
This web-site is intended to be a friendly, enjoyable and useful experience, but as with anything concerning any kind of transactions there are risks involved and we strongly advise you to understand all of these terms before joining. If you spot a listing that you feel is violating the general terms and conditions of this web-site as stated below please let us know by contacting us.
Rights To Suspend or Terminate.
You agree that this web-site, in its own discretion, may terminate any auction or use of the service immediately and without notice if (a) We believe that you are not abiding by the general rules of this web-site (b) You have repeatedly broken a certain term (c) You have listed a suspicious item (d) We believe you to be a non paying bidder. In most cases when we suspect foul play we will suspend your account/listing whilst we investigate further. If our investigation is conclusive then your account with us will be terminated.
Your Conduct.
You are solely responsible for the contents of your actions through this web-site. You must ensure that your participation in the selling or buying of items does not violate any applicable laws or regulations. By this we mean that you must check that you entitled to sell or buy the relevant item and that you are not prohibited from doing so by any law or regulation.
You must not transmit through the service any unlawful, harassing, libelous, abusive, threatening, harmful, vulgar, obscene or otherwise objectionable material. You must also not transmit any material that encourages conduct that could constitute a criminal offence, give rise to civil liability or otherwise violate any applicable law or regulation.
Membership.
Membership to this web-site is only available to those you can form a legally binding contract. This web-site does not permit minors (under 16) to register. If any member fails to signup with their correct age the account will be terminated immediately.
General Terms.
This site acts as the window for sellers to conduct auctions and for bidders to bid on sellers' auctions. We are not involved in the actual transaction between buyers and sellers. As a result, we have no control over the quality, safety or legality of the items listed the truth or accuracy of the listings, the ability of sellers to sell items or the ability of buyers to buy items. We cannot and do not control whether or not sellers will complete the sale of items they offer or buyers will complete the purchases of items they have bid on. In addition, note that there are risks of dealing with foreign nationals, underage persons or people acting under false pretence.
This Web-site shall not be responsible for any items sold by Auction, for any damage to items during transit or during the inspection period, nor for misrepresentations and/or breaches of contract by either buyer and/or seller. This web-site shall not be responsible for the cost of procurement of substitute goods or any losses resulting form any goods purchased or obtained.
This web-site assumes no liability for the content of the listings. However if you fall victim of a fraudulent transaction we will assist you as much as we can.
Laws.
These Terms of Service shall be governed by and constructed in accordance with the laws of England and Wales and any disputes will be decided only by the Courts of England and Wales.
','Y','Y','Y','Y','Y',0);
/*!40000 ALTER TABLE `probid_layout_setts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_login_attempts`
--
DROP TABLE IF EXISTS `probid_login_attempts`;
CREATE TABLE `probid_login_attempts` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(100) NOT NULL default '',
`thedate` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_login_attempts`
--
LOCK TABLES `probid_login_attempts` WRITE;
/*!40000 ALTER TABLE `probid_login_attempts` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_login_attempts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_news`
--
DROP TABLE IF EXISTS `probid_news`;
CREATE TABLE `probid_news` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`date` date NOT NULL default '0000-00-00',
`active` tinyint(4) NOT NULL default '0',
`lang` varchar(255) NOT NULL default 'english',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with news';
--
-- Dumping data for table `probid_news`
--
LOCK TABLES `probid_news` WRITE;
/*!40000 ALTER TABLE `probid_news` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_pages`
--
DROP TABLE IF EXISTS `probid_pages`;
CREATE TABLE `probid_pages` (
`id` int(11) NOT NULL auto_increment,
`pagename` varchar(255) NOT NULL default '',
`content` longtext NOT NULL,
`lang` varchar(255) NOT NULL default 'english',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COMMENT='Table with about, contact, terms etc pages';
--
-- Dumping data for table `probid_pages`
--
LOCK TABLES `probid_pages` WRITE;
/*!40000 ALTER TABLE `probid_pages` DISABLE KEYS */;
INSERT INTO `probid_pages` VALUES (1,'about','About Us
','english'),(2,'contact','Contact Us ','english'),(3,'terms','General Terms and Conditions
This web-site is intended to be a friendly, enjoyable and useful experience, but as with anything concerning any kind of transactions there are risks involved and we strongly advise you to understand all of these terms before joining. If you spot a listing that you feel is violating the general terms and conditions of this web-site as stated below please let us know by contacting us.
Rights To Suspend or Terminate.
You agree that this web-site, in its own discretion, may terminate any auction or use of the service immediately and without notice if (a) We believe that you are not abiding by the general rules of this web-site
(b) You have repeatedly broken a certain term (c) You have listed a suspicious item (d) We believe you to be a non paying bidder. In most cases when we suspect foul play we will suspend your account/listing whilst we investigate further. If our investigation is conclusive then your account with us will be terminated.
Your Conduct.
You are solely responsible for the contents of your actions through this web-site. You must ensure that your participation in the selling or buying of items does not violate any applicable laws or regulations. By this we mean that you must check that you entitled to sell or buy the relevant item and that you are not prohibited from doing so by any law or regulation.
You must not transmit through the service any unlawful, harassing, libelous, abusive, threatening, harmful, vulgar, obscene or otherwise objectionable material. You must also not transmit any material that encourages conduct that could constitute a criminal offence, give rise to civil liability or otherwise violate any applicable law or regulation.
Membership.
Membership to this web-site is only available to those you can form a legally binding contract. This web-site does not permit minors (under
16) to register. If any member fails to signup with their correct age the account will be terminated immediately.
General Terms.
This site acts as the window for sellers to conduct auctions and for bidders to bid on sellers' auctions. We are not involved in the actual transaction between buyers and sellers. As a result, we have no control over the quality, safety or legality of the items listed the truth or accuracy of the listings, the ability of sellers to sell items or the ability of buyers to buy items. We cannot and do not control whether or not sellers will complete the sale of items they offer or buyers will complete the purchases of items they have bid on.
In addition, note that there are risks of dealing with foreign nationals, underage persons or people acting under false pretence.
This Web-site shall not be responsible for any items sold by Auction, for any damage to items during transit or during the inspection period, nor for misrepresentations and/or breaches of contract by either buyer and/or seller. This web-site shall not be responsible for the cost of procurement of substitute goods or any losses resulting form any goods purchased or obtained.
This web-site assumes no liability for the content of the listings.
However if you fall victim of a fraudulent transaction we will assist you as much as we can.
Laws.
These Terms of Service shall be governed by and constructed in accordance with the laws of England and Wales and any disputes will be decided only by the Courts of England and Wales. ','english'),(4,'pp','Privacy Policy
','english'),(14,'about','Please enter content ','russian'),(12,'terms','Please enter content ','russian'),(16,'contact','Please enter content ','russian'),(18,'pp','Please enter content ','russian');
/*!40000 ALTER TABLE `probid_pages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_pages_additional`
--
DROP TABLE IF EXISTS `probid_pages_additional`;
CREATE TABLE `probid_pages_additional` (
`id` int(11) NOT NULL auto_increment,
`pagename` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`lang` varchar(50) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
`page_id` varchar(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_pages_additional`
--
LOCK TABLES `probid_pages_additional` WRITE;
/*!40000 ALTER TABLE `probid_pages_additional` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_pages_additional` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_payment_gateways`
--
DROP TABLE IF EXISTS `probid_payment_gateways`;
CREATE TABLE `probid_payment_gateways` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`value` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1 COMMENT='Table with payment gateways';
--
-- Dumping data for table `probid_payment_gateways`
--
LOCK TABLES `probid_payment_gateways` WRITE;
/*!40000 ALTER TABLE `probid_payment_gateways` DISABLE KEYS */;
INSERT INTO `probid_payment_gateways` VALUES (1,'Paypal',''),(4,'Test Mode','checked'),(5,'Worldpay',''),(6,'2Checkout',''),(100,'Nochex',''),(101,'Ikobo',''),(102,'Protx',''),(108,'Authorize.Net',''),(110,'Moneybookers','');
/*!40000 ALTER TABLE `probid_payment_gateways` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_payment_methods`
--
DROP TABLE IF EXISTS `probid_payment_methods`;
CREATE TABLE `probid_payment_methods` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`logourl` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=553 DEFAULT CHARSET=latin1 COMMENT='Table with payment methods';
--
-- Dumping data for table `probid_payment_methods`
--
LOCK TABLES `probid_payment_methods` WRITE;
/*!40000 ALTER TABLE `probid_payment_methods` DISABLE KEYS */;
INSERT INTO `probid_payment_methods` VALUES (524,'Amex','cclogos/Amex.img'),(527,'Diners','cclogos/Diners.img'),(529,'Mastercard','cclogos/Mastercard.img'),(531,'Nochex','cclogos/Nochex.img'),(533,'PayPal','cclogos/PayPal.img'),(535,'Solo','cclogos/Solo.img'),(536,'Switch','cclogos/Switch.img'),(537,'Visa','cclogos/Visa.img'),(538,'Visa Delta','cclogos/VisaDelta.img'),(540,'Western Union','cclogos/WesternUnion.img');
/*!40000 ALTER TABLE `probid_payment_methods` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_proxybid`
--
DROP TABLE IF EXISTS `probid_proxybid`;
CREATE TABLE `probid_proxybid` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`bidderid` int(11) NOT NULL default '0',
`bidamount` double(16,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with proxy bids';
--
-- Dumping data for table `probid_proxybid`
--
LOCK TABLES `probid_proxybid` WRITE;
/*!40000 ALTER TABLE `probid_proxybid` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_proxybid` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_public_msg`
--
DROP TABLE IF EXISTS `probid_public_msg`;
CREATE TABLE `probid_public_msg` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`posterid` int(11) NOT NULL default '0',
`msgtype` enum('Q','A') NOT NULL default 'Q',
`content` text NOT NULL,
`regdate` int(11) NOT NULL default '0',
`answerid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_public_msg`
--
LOCK TABLES `probid_public_msg` WRITE;
/*!40000 ALTER TABLE `probid_public_msg` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_public_msg` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_rates`
--
DROP TABLE IF EXISTS `probid_rates`;
CREATE TABLE `probid_rates` (
`id` int(11) NOT NULL auto_increment,
`ime` tinytext NOT NULL,
`valuta` tinytext NOT NULL,
`rate` float(8,2) NOT NULL default '0.00',
`sifra` tinytext NOT NULL,
`symbol` char(3) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_rates`
--
LOCK TABLES `probid_rates` WRITE;
/*!40000 ALTER TABLE `probid_rates` DISABLE KEYS */;
INSERT INTO `probid_rates` VALUES (1,'United States','U.S. Dollar',1.00,'U.S. Dollar ','USD'),(2,'Argentina','Argentinian Peso',2.95,'Argentine Peso ','ARS'),(3,'Australia','Australian Dollar ',1.32,'Australian Dollar ','AUD'),(5,'Brazil','Brazilian Real ',2.71,'Brazilian Real ','BRL'),(6,'Chile','Chilean Peso ',581.82,'Chilean Peso ','CLP'),(7,'China','Chinese Renminbi ',8.28,'Chinese Renminbi ','CNY'),(8,'Colombia','Colombian Peso ',2364.41,'Colombian Peso ','COP'),(10,'Czech. Republic','Czech. Republic Koruna ',23.31,'Czech. Republic Koruna ','CZK'),(11,'Denmark','Danish Krone ',5.70,'Danish Krone ','DKK'),(12,'European Union','EURO',0.79,'European Monetary Union EURO','EUR'),(13,'Fiji','Fiji Dollar ',1.67,'Fiji Dollar ','FJD'),(16,'Hong Kong','Hong Kong Dollar',7.80,'Hong Kong Dollar ','HKD'),(18,'Iceland','Icelandic Krona ',62.30,'Icelandic Krona ','ISK'),(19,'India','Indian Rupee',43.59,'Indian Rupee ','INR'),(20,'Indonesia','Indonesian Rupiah ',9190.98,'Indonesian Rupiah ','IDR'),(21,'Israel','Israeli New Shekel ',4.37,'Israeli New Shekel ','ILS'),(22,'Japan','Japanese Yen',102.44,'Japanese Yen ','JPY'),(23,'Malaysia','Malaysian Ringgit ',3.80,'Malaysian Ringgit ','MYR'),(24,'Mexico','New Peso',10.81,'Mexican New Peso ','MXN'),(25,'Morocco','Moroccan Dirham ',8.51,'Moroccan Dirham ','MAD'),(28,'New Zealand','New Zealand Dollar',1.43,'New Zealand Dollar ','NZD'),(29,'Norway','Norwege Krone',6.26,'Norwegian Krone ','NOK'),(30,'Pakistan','Pakistan Rupee ',59.43,'Pakistan Rupee ','PKR'),(31,'Panama','Panamanian Balboa ',1.00,'Panamanian Balboa ','PAB'),(32,'Peru','Peruvian New Sol',3.26,'Peruvian New Sol ','PEN'),(33,'Philippine','Philippine Peso ',55.64,'Philippine Peso ','PHP'),(34,'Poland','Polish Zloty',3.14,'Polish Zloty ','PLN'),(35,'Russian','Russian Rouble',28.13,'Russian Rouble ','RUR'),(36,'Singapore','Singapore Dollar ',1.64,'Singapore Dollar ','SGD'),(37,'Slovakia','Koruna',29.65,'Slovak Koruna ','SKK'),(38,'Slovenia','Slovenian Tolar',183.82,'Slovenian Tolar ','SIT'),(39,'South Africa','South African Rand',6.06,'South African Rand ','ZAR'),(40,'South Korea','South Korean Won',1035.93,'South Korean Won ','KRW'),(41,'Sri Lanka','Sri Lanka Rupee ',98.42,'Sri Lanka Rupee ','LKR'),(42,'Sweden','Swedish Krona',6.93,'Swedish Krona ','SEK'),(43,'Switzerland','Swiss Franc',1.18,'Swiss Franc ','CHF'),(44,'Taiwan','Taiwanese New Dollar ',31.89,'Taiwanese New Dollar ','TWD'),(45,'Thailand','Thailand Thai Baht ',38.46,'Thai Baht ','THB'),(47,'Tunisia','Tunisisan Dinar',1.23,'Tunisian Dinar ','TND'),(48,'Turkey','Turkish Lira',138.60,'Turkish Lira (2) ','TRL'),(49,'Great Britain','Pound Sterling ',0.54,'Pound Sterling ','GBP'),(50,'Venezuela','Bolivar ',1919.00,'Venezuelan Bolivar ','VEB'),(51,'Bahamas','Bahamian Dollar',1.00,'Bahamian Dollar','BSD'),(52,'Croatia','Croatian Kuna',5.74,'Croatian Kuna','HRK'),(53,'East Caribe','East Caribbean Dollar',0.00,'East Caribbean Dollar','XCD'),(54,'CFA Franc (African Financial Community)','African Financial Community Franc',0.00,'African Financial Community Franc','CFA'),(55,'Pacific Financial Community','Pacific Financial Community Franc',0.00,'Pacific Financial Community','CFP'),(56,'Ghana','Ghanaian Cedi',8988.24,'Ghanaian Cedi','GHC'),(57,'Honduras','Honduras Lempira',0.00,'Honduras Lempira','HNL'),(58,'Hungaria','Hungarian Forint',189.26,'Hungarian Forint','HUF'),(59,'Jamaica','Jamaican Dollar',60.97,'Jamaican Dollar','JMD'),(60,'Burma','Myanmar (Burma) Kyat',5.59,'Myanmar (Burma) Kyat','MMK'),(61,'Neth. Antilles','Neth. Antilles Guilder',1.78,'Neth. Antilles Guilder','ANG'),(62,'Trinidad & Tobago','Trinidad & Tobago Dollar',6.21,'Trinidad & Tobago Dollar','TTD'),(63,'Canadian','Canadian Dollar',1.31,'Canadian Dollar','CAD');
/*!40000 ALTER TABLE `probid_rates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_referrals`
--
DROP TABLE IF EXISTS `probid_referrals`;
CREATE TABLE `probid_referrals` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_referrals`
--
LOCK TABLES `probid_referrals` WRITE;
/*!40000 ALTER TABLE `probid_referrals` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_referrals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_reserve_offers`
--
DROP TABLE IF EXISTS `probid_reserve_offers`;
CREATE TABLE `probid_reserve_offers` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`bidderid` int(11) NOT NULL default '0',
`bidamount` double(16,2) NOT NULL default '0.00',
`accepted` tinyint(4) NOT NULL default '0',
`regdate` int(11) NOT NULL default '0',
`bidid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_reserve_offers`
--
LOCK TABLES `probid_reserve_offers` WRITE;
/*!40000 ALTER TABLE `probid_reserve_offers` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_reserve_offers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_shipping_options`
--
DROP TABLE IF EXISTS `probid_shipping_options`;
CREATE TABLE `probid_shipping_options` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_shipping_options`
--
LOCK TABLES `probid_shipping_options` WRITE;
/*!40000 ALTER TABLE `probid_shipping_options` DISABLE KEYS */;
INSERT INTO `probid_shipping_options` VALUES (1,'Recorded'),(2,'Special Delivery'),(3,'Airmail'),(4,'Surface Mail'),(5,'Other');
/*!40000 ALTER TABLE `probid_shipping_options` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_stats`
--
DROP TABLE IF EXISTS `probid_stats`;
CREATE TABLE `probid_stats` (
`id` int(11) NOT NULL auto_increment,
`userip` varchar(100) NOT NULL default '',
`userbrowser` varchar(255) NOT NULL default '',
`clickdate` int(11) NOT NULL default '0',
`referralsite` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_stats`
--
LOCK TABLES `probid_stats` WRITE;
/*!40000 ALTER TABLE `probid_stats` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_stats` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_stores_accounting`
--
DROP TABLE IF EXISTS `probid_stores_accounting`;
CREATE TABLE `probid_stores_accounting` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`amountpaid` double(16,2) NOT NULL default '0.00',
`paymentdate` int(11) NOT NULL default '0',
`processor` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_stores_accounting`
--
LOCK TABLES `probid_stores_accounting` WRITE;
/*!40000 ALTER TABLE `probid_stores_accounting` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_stores_accounting` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_suggested_categories`
--
DROP TABLE IF EXISTS `probid_suggested_categories`;
CREATE TABLE `probid_suggested_categories` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`content` text NOT NULL,
`regdate` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_suggested_categories`
--
LOCK TABLES `probid_suggested_categories` WRITE;
/*!40000 ALTER TABLE `probid_suggested_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_suggested_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_swaps`
--
DROP TABLE IF EXISTS `probid_swaps`;
CREATE TABLE `probid_swaps` (
`id` int(11) NOT NULL auto_increment,
`auctionid` int(11) NOT NULL default '0',
`sellerid` int(11) NOT NULL default '0',
`buyerid` int(11) NOT NULL default '0',
`quantity` int(11) NOT NULL default '0',
`description` text NOT NULL,
`accepted` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_swaps`
--
LOCK TABLES `probid_swaps` WRITE;
/*!40000 ALTER TABLE `probid_swaps` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_swaps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_timesettings`
--
DROP TABLE IF EXISTS `probid_timesettings`;
CREATE TABLE `probid_timesettings` (
`id` tinyint(4) NOT NULL auto_increment,
`value` tinyint(4) NOT NULL default '0',
`caption` varchar(20) NOT NULL default '',
`active` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1 COMMENT='Table with time settings';
--
-- Dumping data for table `probid_timesettings`
--
LOCK TABLES `probid_timesettings` WRITE;
/*!40000 ALTER TABLE `probid_timesettings` DISABLE KEYS */;
INSERT INTO `probid_timesettings` VALUES (1,0,'Server Time',''),(2,-24,'-24 H',''),(3,-23,'-23 H',''),(4,-22,'-22 H',''),(5,-21,'-21 H',''),(6,-20,'-20 H',''),(7,-19,'-19 H',''),(8,-18,'-18 H',''),(9,-17,'-17 H',''),(10,-16,'-16 H',''),(11,-15,'-15 H',''),(12,-14,'-14 H',''),(13,-13,'-13 H',''),(14,-12,'-12 H',''),(15,-11,'-11 H',''),(16,-10,'-10 H',''),(17,-9,'-9 H',''),(18,-8,'-8 H',''),(19,-7,'-7 H',''),(20,-6,'-6 H',''),(21,-5,'-5 H',''),(22,-4,'-4 H','selected'),(23,-3,'-3 H',''),(24,-2,'-2 H',''),(25,-1,'-1 H',''),(26,1,'+1 H',''),(27,2,'+2 H',''),(28,3,'+3 H',''),(29,4,'+4 H',''),(30,5,'+5 H',''),(31,6,'+6 H',''),(32,7,'+7 H',''),(33,8,'+8 H',''),(34,9,'+9 H',''),(35,10,'+10 H',''),(36,11,'+11 H',''),(37,12,'+12 H',''),(38,13,'+13 H',''),(39,14,'+14 H',''),(40,15,'+15 H',''),(41,16,'+16 H',''),(42,17,'+17 H',''),(43,18,'+18 H',''),(44,19,'+19 H',''),(45,20,'+20 H',''),(46,21,'+21 H',''),(47,22,'+22 H',''),(48,23,'+23 H',''),(49,24,'+24 H','');
/*!40000 ALTER TABLE `probid_timesettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_txn_ids`
--
DROP TABLE IF EXISTS `probid_txn_ids`;
CREATE TABLE `probid_txn_ids` (
`id` int(11) NOT NULL auto_increment,
`txnid` varchar(255) NOT NULL default '',
`processor` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_txn_ids`
--
LOCK TABLES `probid_txn_ids` WRITE;
/*!40000 ALTER TABLE `probid_txn_ids` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_txn_ids` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_users`
--
DROP TABLE IF EXISTS `probid_users`;
CREATE TABLE `probid_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`birthdate` date NOT NULL default '0000-00-00',
`address` varchar(100) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`country` varchar(100) NOT NULL default '',
`zip` varchar(15) NOT NULL default '0',
`phone` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`password` varchar(30) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
`payment_status` varchar(20) NOT NULL default '',
`items_sold` int(11) NOT NULL default '0',
`items_bought` int(11) NOT NULL default '0',
`isaboutme` char(2) NOT NULL default 'N',
`aboutmepage` text NOT NULL,
`shop_mainpage` mediumblob NOT NULL,
`shop_mainpage_preview` mediumblob NOT NULL,
`shop_logo` varchar(255) NOT NULL default '',
`aboutpage_type` varchar(20) default NULL,
`newsletter` char(2) NOT NULL default 'N',
`balance` double(16,2) NOT NULL default '0.00',
`accsusp` tinyint(4) NOT NULL default '0',
`inactivated` tinyint(4) NOT NULL default '0',
`regdate` int(11) NOT NULL default '0',
`mailactivated` tinyint(4) NOT NULL default '0',
`amountpaid` double(16,2) NOT NULL default '0.00',
`paymentdate` int(11) NOT NULL default '0',
`processor` varchar(50) NOT NULL default '',
`lang` varchar(255) NOT NULL default 'english',
`is_seller` char(2) NOT NULL default 'N',
`preferred_seller` char(2) NOT NULL default 'N',
`apply_vat_exempt` char(2) NOT NULL default 'N',
`vat_uid_number` varchar(50) NOT NULL default '',
`vat_exempted` char(2) NOT NULL default 'N',
`store_active` tinyint(4) NOT NULL default '0',
`store_lastpayment` int(11) NOT NULL default '0',
`user_firstname` varchar(50) NOT NULL default '',
`user_lastname` varchar(50) NOT NULL default '',
`birthdate_year` int(11) NOT NULL default '0',
`default_duration` smallint(6) NOT NULL default '0',
`default_private` varchar(10) NOT NULL default '',
`default_isswap` char(2) NOT NULL default '',
`default_sc` char(2) NOT NULL default '',
`default_scint` char(2) NOT NULL default '',
`default_pm` text NOT NULL,
`default_acceptdirectpayment` tinyint(4) NOT NULL default '0',
`default_directpaymentemail` varchar(255) NOT NULL default '',
`default_postage_costs` double(16,2) NOT NULL default '0.00',
`default_insurance` varchar(50) NOT NULL default '',
`default_type_service` varchar(50) NOT NULL default '',
`default_shipping_details` mediumtext NOT NULL,
`referredby` varchar(200) NOT NULL default '',
`store_account_type` int(11) NOT NULL default '0',
`store_categories` text NOT NULL,
`store_nextpayment` int(11) NOT NULL default '0',
`store_name` varchar(255) NOT NULL default '',
`payment_mode` tinyint(1) default '0',
`allowed_credit` double(16,2) default '0.00',
`default_public_questions` char(2) NOT NULL default 'Y',
`default_bid_placed_email` char(2) NOT NULL default 'Y',
`mail_accsusp` tinyint(4) NOT NULL default '1',
`mail_auctionsold` tinyint(4) NOT NULL default '1',
`mail_auctionwon` tinyint(4) NOT NULL default '1',
`mail_buyerdetails` tinyint(4) NOT NULL default '1',
`mail_sellerdetails` tinyint(4) NOT NULL default '1',
`mail_itemwatch` tinyint(4) NOT NULL default '1',
`mail_auctionclosed` tinyint(4) NOT NULL default '1',
`mail_wantedoffer` tinyint(4) NOT NULL default '1',
`mail_outbid` tinyint(4) NOT NULL default '1',
`mail_keywordmatch` tinyint(4) NOT NULL default '1',
`mail_conftosell` tinyint(4) NOT NULL default '1',
`nb_items` int(11) NOT NULL default '0',
`store_template` smallint(6) NOT NULL default '0',
`companyname` varchar(100) default NULL,
`paypalemail` varchar(255) default NULL,
`worldpayid` varchar(50) default NULL,
`ikoboid` varchar(100) default NULL,
`ikoboipn` varchar(100) default NULL,
`vatrate` double(10,2) default NULL,
`checkoutid` varchar(50) default NULL,
`protxname` varchar(100) default NULL,
`protxpassword` varchar(100) default NULL,
`authnetid` varchar(100) default NULL,
`authnettranskey` varchar(100) default NULL,
`nochexemail` varchar(100) default NULL,
`store_about` text NOT NULL,
`store_specials` text NOT NULL,
`store_shippinginfo` text NOT NULL,
`store_policies` text NOT NULL,
`store_featured_items` int(11) NOT NULL default '0',
`store_endingsoon_items` int(11) NOT NULL default '0',
`store_recentlylisted_items` int(11) NOT NULL default '0',
`store_metatags` text NOT NULL,
`default_itemname` varchar(255) NOT NULL default '',
`default_description` text NOT NULL,
`user_admin_notes` text NOT NULL,
`auction_approval` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='Table with probid users';
--
-- Dumping data for table `probid_users`
--
LOCK TABLES `probid_users` WRITE;
/*!40000 ALTER TABLE `probid_users` DISABLE KEYS */;
INSERT INTO `probid_users` VALUES (1,'Bradley Hayes','hayesb2@gmail.com','0000-00-00','1945 Winterbrook Dr','Lancaster','OH','United States','43130','740 9748062','hayesb2','236f5afe7bea74c3b9ad1845bd169c',0,'',1,0,'N','','','','',NULL,'Y',20.30,0,0,1177721128,1,0.00,0,'','english','N','N','','','N',0,0,'','',1977,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N'),(2,'Michael Helm','michael.helm@cox.net','0000-00-00','2518 e 51st st','Tulsa','Ok','United States','74105','918 808-3242','aeshadow','be53f3ea25ec10d3ff55767b35cf78',1,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1177739714,1,0.00,0,'','english','N','N','','','N',0,0,'','',1978,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N'),(3,'admin pass','genewell@hotmail.com','0000-00-00','anystreet','columbus','oh','United States','43214','614 445-6987','admin','5f4dcc3b5aa765d61d8327deb882cf',0,'',0,0,'','New Store','','','uplimg/admin_logo9facc1ff12161c6db1fdf04b1d008168.jpg','2','N',17.00,0,0,1189546613,1,0.00,0,'','english','N','N','','','N',1,1192152379,'','',1962,0,'','','','','',0,'',0.00,'','','','',20,'215,',1194744379,'New Store',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'store','','','','N'),(4,'kk','khinko78@yahoo.com','0000-00-00','44','London','London','Germany','1234','01 01','kk','e10adc3949ba59abbe56e057f20f88',0,'confirmed',0,1,'','AA','','','uplimg/kk_logo1f488ce47c96c16bc2b9c0b728315448.jpg','2','N',17.44,0,0,1190314314,1,0.00,0,'','english','N','N','','','N',1,1190323285,'','',1965,0,'','','','','',0,'',0.00,'','','','',20,'',1192915285,'AA',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'A','','','','N'),(5,'swedesh mooruth','swedesh@infowave.co.za','0000-00-00','15 clinch','durbs','kzn','Scotland','4091','031 564773','z700499','07d116abd6b4793d42811dc1f982d4',0,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1194167014,0,0.00,0,'','english','N','N','','','N',0,0,'','',1967,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N'),(6,'Travis','worldtotravis@yahoo.com','0000-00-00','12345 test','your place','CA','United States','92129','456 456-1234','travis','0df4102a34d4f80ea48fe12837c12e',1,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1197436483,1,0.00,0,'','english','N','N','','','N',0,0,'','',1974,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N'),(7,'john jones','joe@zipspam.com','0000-00-00','311 rt 79','morganville','new jerset','United States','07751','732 7720876','andwhen','5453dae252cb54545c0ed2219acf2b',1,'',0,0,'N','','','','',NULL,'N',-2.92,0,0,1209063476,1,0.00,0,'','english','N','N','','','N',0,0,'','',1949,2,'N','N','','','Amex
Mastercard
PayPal
Visa
Visa Delta
',0,'',2.00,'','','7 days ups','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','camera','kodak broken sold as is','','N'),(8,'Joe','New-B@tds.net','0000-00-00','1436 W. Woodshire dr.','Knoxville','TN.','United States','37922','865 8981061','NewB','a09f91f8be77e65b371a64bf1d8305',1,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1211573451,1,0.00,0,'','english','N','N','','','N',0,0,'','',1974,14,'N','Y','','','PayPal
',0,'',1000.00,'','Special Delivery','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','Car','Car dkflj;asd sldkflkelfc sdlkfjlee sd' fjel;f sd';lfja'wejfo hasd;o a;sod f;sd; ','','N'),(9,'dae','loansforyou2001@yahoo.com','0000-00-00','drgdfgfggfgfdg','sdfdsff','wa','United States','98665','111 11111','duck1','f2d188280d2032d0f5431f93119163',0,'confirmed',0,0,'','<DIV>fvjiufvuhe[ [oi h[hre[e;akjhn ;fdn nfbl ndvdflknlfdn ln </DIV>\r\n<DIV>fadk dfvno'ng'ain'n</DIV>\r\n<DIV>adp fjpdfijj da</DIV>\r\n<DIV>ad pfopofa pjfdfd dfojkfpojbvf</DIV>','','','','2','Y',20.38,0,0,1212623462,1,0.00,0,'','english','N','N','','','N',1,1215221915,'','',1963,28,'N','N','','','Amex
Mastercard
PayPal
',0,'',0.00,'1.00','Other','','',20,'',1217813915,'tester tester',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'bikes','bike','kjhjhsadkjas aslijh sadlijoipwe ewf proi repoi rgeojfdl;jfd c vcxkj lxckj ','','N'),(10,'Eirebay','djpetedownes2003@yahoo.co.uk','0000-00-00','castlegregory','tralee Co Kerry','Ireland','Indonesia','1111111111111','353 894118704','eirebay','c8e6db9264ad952fbcaa6d7dc99268',0,'confirmed',0,0,'','The best store for Pay as you Go Sim Cards and Mobile PHONES','','','','2','Y',30.00,0,0,1213792509,1,0.00,0,'','english','N','N','','','N',1,1217964222,'','',1975,7,'Y','Y','','','Amex
Diners
Mastercard
Nochex
PayPal
Solo
Switch
Visa
Visa Delta
',0,'',15.00,'15','Recorded','','',24,'',1220556222,'Chatterbox',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,2,'Eirebay',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'we sell pay as you go mobile phones and sim cards','<DIV>Nokia 6230</DIV>\r\n<DIV>special$ 60</DIV>','<DIV>will ship international</DIV>\r\n<DIV>buyer pays for shipping costs</DIV>','',1,1,1,'','NOKIA 6230 Mobile Phone','<P>a great phone with lots of cool features</P>','','N'),(11,'insaneoz','oz.international@gmail.com','0000-00-00','skip','demo','va','United States','22192','571 330-5725','insaneoz','70040dee674d8d42cbc3f8de899329',0,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1238530710,0,0.00,0,'','english','N','N','','','N',0,0,'','',1988,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N'),(12,'testing','sales@ovishosting.com','0000-00-00','testing','cols','oh','United States','43215','614 555-5555','ovishos','e99a18c428cb38d5f260853678922e',0,'',0,0,'N','','','','',NULL,'N',-3.00,0,0,1241183998,0,0.00,0,'','english','N','N','','','N',0,0,'','',1977,0,'','','','','',0,'',0.00,'','','','',0,'',0,'',1,15.00,'Y','Y',1,1,1,1,1,1,1,1,1,1,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','',0,0,0,'','','','','N');
/*!40000 ALTER TABLE `probid_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_vat_rates`
--
DROP TABLE IF EXISTS `probid_vat_rates`;
CREATE TABLE `probid_vat_rates` (
`id` int(11) NOT NULL auto_increment,
`vat_id` int(11) NOT NULL default '0',
`country` int(11) NOT NULL default '0',
`rate` double(9,2) NOT NULL default '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_vat_rates`
--
LOCK TABLES `probid_vat_rates` WRITE;
/*!40000 ALTER TABLE `probid_vat_rates` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_vat_rates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_vat_setts`
--
DROP TABLE IF EXISTS `probid_vat_setts`;
CREATE TABLE `probid_vat_setts` (
`id` int(11) NOT NULL auto_increment,
`symbol` varchar(10) NOT NULL default '',
`amount` float(9,2) default '0.00',
`countries` text,
`users_sale_vat` set('a','b','c','d') default NULL,
`users_no_vat` set('a','b','c','d') default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_vat_setts`
--
LOCK TABLES `probid_vat_setts` WRITE;
/*!40000 ALTER TABLE `probid_vat_setts` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_vat_setts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_vouchers`
--
DROP TABLE IF EXISTS `probid_vouchers`;
CREATE TABLE `probid_vouchers` (
`id` int(11) NOT NULL auto_increment,
`voucher_code` varchar(255) NOT NULL default '',
`voucher_type` varchar(20) NOT NULL default '',
`regdate` int(11) NOT NULL default '0',
`expdate` int(11) NOT NULL default '0',
`nbuses` int(11) NOT NULL default '0',
`usesleft` int(11) NOT NULL default '0',
`reduction` double(16,2) NOT NULL default '0.00',
`assigned_users` text NOT NULL,
`active` tinyint(4) NOT NULL default '1',
`duration` int(11) NOT NULL default '0',
`assignto` varchar(255) NOT NULL default '',
`voucher_name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_vouchers`
--
LOCK TABLES `probid_vouchers` WRITE;
/*!40000 ALTER TABLE `probid_vouchers` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_vouchers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_wanted_ads`
--
DROP TABLE IF EXISTS `probid_wanted_ads`;
CREATE TABLE `probid_wanted_ads` (
`id` bigint(20) NOT NULL auto_increment,
`itemname` varchar(255) NOT NULL default '',
`description` mediumblob NOT NULL,
`duration` smallint(6) NOT NULL default '0',
`country` varchar(100) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
`payment_status` varchar(20) NOT NULL default '',
`startdate` datetime NOT NULL default '0000-00-00 00:00:00',
`enddate` datetime NOT NULL default '0000-00-00 00:00:00',
`closed` tinyint(4) NOT NULL default '0',
`keywords` text NOT NULL,
`nrbids` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`addlcategory` int(11) NOT NULL default '0',
`deleted` tinyint(4) NOT NULL default '0',
`amountpaid` double(16,2) NOT NULL default '0.00',
`paymentdate` int(11) NOT NULL default '0',
`processor` varchar(50) NOT NULL default '',
`picpath` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='Table with wanted ads details';
--
-- Dumping data for table `probid_wanted_ads`
--
LOCK TABLES `probid_wanted_ads` WRITE;
/*!40000 ALTER TABLE `probid_wanted_ads` DISABLE KEYS */;
INSERT INTO `probid_wanted_ads` VALUES (1,'book','kjsahd asdkhsa ksjkjsa hdkj dk asjhksdh kkak',28,'United States','98665','215',1,'confirmed','2008-06-04 19:55:12','2008-07-02 19:55:12',1,'book kjsahd asdkhsa ksjkjsa hdkj dk asjhksdh kkak',0,11,9,0,0,0.00,0,'',''),(2,'Mobile phones wanted','<DIV>Mobile phones wanted</DIV>\r\n<DIV>must be in good working order </DIV>\r\n<DIV></DIV>',56,'Indonesia','1111111111111','1098',1,'confirmed','2008-06-18 11:16:34','2008-08-13 11:16:34',1,'Mobile phones wanted <DIV>Mobile phones wanted</DIV>\r\n<DIV>must be in good working order </DIV>\r\n<DIV></DIV>',0,9,10,0,0,0.00,0,'','');
/*!40000 ALTER TABLE `probid_wanted_ads` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_wanted_fields`
--
DROP TABLE IF EXISTS `probid_wanted_fields`;
CREATE TABLE `probid_wanted_fields` (
`id` int(11) NOT NULL auto_increment,
`boxid` int(11) NOT NULL default '0',
`boxname` varchar(255) NOT NULL default '',
`boxtype` varchar(40) NOT NULL default '',
`boxvalue` varchar(255) NOT NULL default '',
`boxcaption` varchar(255) NOT NULL default '',
`boxorder` tinyint(4) NOT NULL default '0',
`mandatory` tinyint(4) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '1',
`fieldorder` tinyint(4) NOT NULL default '0',
`categoryid` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_wanted_fields`
--
LOCK TABLES `probid_wanted_fields` WRITE;
/*!40000 ALTER TABLE `probid_wanted_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_wanted_fields` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_wanted_fields_data`
--
DROP TABLE IF EXISTS `probid_wanted_fields_data`;
CREATE TABLE `probid_wanted_fields_data` (
`id` int(11) NOT NULL auto_increment,
`wantedadid` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`boxid` int(11) NOT NULL default '0',
`boxvalue` text NOT NULL,
`active` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_wanted_fields_data`
--
LOCK TABLES `probid_wanted_fields_data` WRITE;
/*!40000 ALTER TABLE `probid_wanted_fields_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_wanted_fields_data` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_wanted_offers`
--
DROP TABLE IF EXISTS `probid_wanted_offers`;
CREATE TABLE `probid_wanted_offers` (
`id` int(11) NOT NULL auto_increment,
`wantedadid` int(11) NOT NULL default '0',
`auctionid` int(11) NOT NULL default '0',
`ownerid` int(11) NOT NULL default '0',
`sellerid` int(11) NOT NULL default '0',
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `probid_wanted_offers`
--
LOCK TABLES `probid_wanted_offers` WRITE;
/*!40000 ALTER TABLE `probid_wanted_offers` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_wanted_offers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_winners`
--
DROP TABLE IF EXISTS `probid_winners`;
CREATE TABLE `probid_winners` (
`id` int(11) NOT NULL auto_increment,
`sellerid` int(11) NOT NULL default '0',
`buyerid` int(11) NOT NULL default '0',
`amount` double(16,2) NOT NULL default '0.00',
`quant_req` int(11) NOT NULL default '0',
`quant_offered` int(11) NOT NULL default '0',
`auctionid` int(11) NOT NULL default '0',
`auctiontype` varchar(15) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
`payment_status` varchar(20) NOT NULL default '',
`amountpaid` double(16,2) NOT NULL default '0.00',
`txnid` varchar(255) NOT NULL default '',
`emailsent` tinyint(4) NOT NULL default '0',
`paymentdate` int(11) NOT NULL default '0',
`processor` varchar(50) NOT NULL default '',
`s_deleted` tinyint(4) NOT NULL default '0',
`b_deleted` tinyint(4) NOT NULL default '0',
`flag_paid` tinyint(4) NOT NULL default '0',
`flag_status` tinyint(4) NOT NULL default '0',
`directpayment_paid` tinyint(4) NOT NULL default '0',
`bnpurchase` tinyint(4) NOT NULL default '0',
`invoice_sent` tinyint(4) NOT NULL default '0',
`vat_included` tinyint(4) NOT NULL default '0',
`delivery_included` tinyint(4) NOT NULL default '0',
`insurance_included` tinyint(4) NOT NULL default '0',
`insurance` double(10,2) default '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Table with the auction''s declared winners';
--
-- Dumping data for table `probid_winners`
--
LOCK TABLES `probid_winners` WRITE;
/*!40000 ALTER TABLE `probid_winners` DISABLE KEYS */;
INSERT INTO `probid_winners` VALUES (1,1,4,2500.00,1,1,2,'standard',1,'confirmed',0.00,'',1,0,'',0,1,0,0,0,1,0,0,0,0,0.00);
/*!40000 ALTER TABLE `probid_winners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `probid_wordfilter`
--
DROP TABLE IF EXISTS `probid_wordfilter`;
CREATE TABLE `probid_wordfilter` (
`id` int(11) NOT NULL auto_increment,
`word` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Table with words that are filtered';
--
-- Dumping data for table `probid_wordfilter`
--
LOCK TABLES `probid_wordfilter` WRITE;
/*!40000 ALTER TABLE `probid_wordfilter` DISABLE KEYS */;
/*!40000 ALTER TABLE `probid_wordfilter` ENABLE KEYS */;
UNLOCK TABLES;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;