[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `uaction54`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

-- Table structure for table `[[dbprefix]]accesseshistoric`

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]accesseshistoric` (

[20] Fix | Delete

`month` char(2) NOT NULL DEFAULT '',

[21] Fix | Delete

`year` char(4) NOT NULL DEFAULT '',

[22] Fix | Delete

`pageviews` int(11) NOT NULL DEFAULT '0',

[23] Fix | Delete

`uniquevisitiors` int(11) NOT NULL DEFAULT '0',

[24] Fix | Delete

`usersessions` int(11) NOT NULL DEFAULT '0'

[25] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[26] Fix | Delete

[27] Fix | Delete

-- --------------------------------------------------------

[28] Fix | Delete

[29] Fix | Delete

--

[30] Fix | Delete

-- Table structure for table `[[dbprefix]]accounts`

[31] Fix | Delete

--

[32] Fix | Delete

[33] Fix | Delete

CREATE TABLE `[[dbprefix]]accounts` (

[34] Fix | Delete

`id` int(7) NOT NULL AUTO_INCREMENT,

[35] Fix | Delete

`nick` varchar(20) NOT NULL,

[36] Fix | Delete

`name` tinytext NOT NULL,

[37] Fix | Delete

`text` text NOT NULL,

[38] Fix | Delete

`type` varchar(15) NOT NULL,

[39] Fix | Delete

`paid_date` varchar(16) NOT NULL,

[40] Fix | Delete

`amount` double(6,2) NOT NULL,

[41] Fix | Delete

`day` int(3) NOT NULL,

[42] Fix | Delete

`week` int(2) NOT NULL,

[43] Fix | Delete

`month` int(2) NOT NULL,

[44] Fix | Delete

`year` int(4) NOT NULL,

[45] Fix | Delete

PRIMARY KEY (`id`)

[46] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[47] Fix | Delete

[48] Fix | Delete

-- --------------------------------------------------------

[49] Fix | Delete

[50] Fix | Delete

--

[51] Fix | Delete

-- Table structure for table `[[dbprefix]]adminusers`

[52] Fix | Delete

--

[53] Fix | Delete

[54] Fix | Delete

CREATE TABLE `[[dbprefix]]adminusers` (

[55] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[56] Fix | Delete

`username` varchar(32) NOT NULL DEFAULT '',

[57] Fix | Delete

`password` varchar(255) NOT NULL DEFAULT '',

[58] Fix | Delete

`hash` varchar(5) NOT NULL DEFAULT '',

[59] Fix | Delete

`created` varchar(8) NOT NULL DEFAULT '',

[60] Fix | Delete

`lastlogin` varchar(14) NOT NULL DEFAULT '',

[61] Fix | Delete

`status` int(2) NOT NULL DEFAULT '0',

[62] Fix | Delete

`notes` text,

[63] Fix | Delete

KEY `id` (`id`)

[64] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[65] Fix | Delete

[66] Fix | Delete

--

[67] Fix | Delete

-- Dumping data for table `[[dbprefix]]adminusers`

[68] Fix | Delete

--

[69] Fix | Delete

[70] Fix | Delete

INSERT INTO `[[dbprefix]]adminusers` VALUES

[71] Fix | Delete

(1, '[[admin_username]]', '[[admin_pass]]', '[[hash]]', '[[_date]]', '[[timestamp]]', 1, NULL);

[72] Fix | Delete

[73] Fix | Delete

-- --------------------------------------------------------

[74] Fix | Delete

[75] Fix | Delete

--

[76] Fix | Delete

-- Table structure for table `[[dbprefix]]adsense`

[77] Fix | Delete

--

[78] Fix | Delete

[79] Fix | Delete

CREATE TABLE `[[dbprefix]]adsense` (

[80] Fix | Delete

`fieldname` varchar(50) NOT NULL,

[81] Fix | Delete

`fieldtype` varchar(10) NOT NULL,

[82] Fix | Delete

`value` text,

[83] Fix | Delete

`modifieddate` int(11) NOT NULL,

[84] Fix | Delete

`modifiedby` int(32) NOT NULL,

[85] Fix | Delete

PRIMARY KEY (`fieldname`)

[86] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[87] Fix | Delete

[88] Fix | Delete

--

[89] Fix | Delete

-- Dumping data for table `[[dbprefix]]adsense`

[90] Fix | Delete

--

[91] Fix | Delete

[92] Fix | Delete

INSERT INTO `[[dbprefix]]adsense` VALUES

[93] Fix | Delete

('browse_banner_1', 'str', '', 0, 1),

[94] Fix | Delete

('header_banner_1', 'str', '', 0, 1),

[95] Fix | Delete

('index_banner_1', 'str', '', 0, 1),

[96] Fix | Delete

('index_banner_2', 'str', '', 0, 1),

[97] Fix | Delete

('index_banner_3', 'str', '', 0, 1);

[98] Fix | Delete

[99] Fix | Delete

-- --------------------------------------------------------

[100] Fix | Delete

[101] Fix | Delete

--

[102] Fix | Delete

-- Table structure for table `[[dbprefix]]auccounter`

[103] Fix | Delete

--

[104] Fix | Delete

[105] Fix | Delete

CREATE TABLE `[[dbprefix]]auccounter` (

[106] Fix | Delete

`auction_id` int(11) NOT NULL DEFAULT '0',

[107] Fix | Delete

`counter` int(11) NOT NULL DEFAULT '0',

[108] Fix | Delete

PRIMARY KEY (`auction_id`)

[109] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[110] Fix | Delete

[111] Fix | Delete

-- --------------------------------------------------------

[112] Fix | Delete

[113] Fix | Delete

--

[114] Fix | Delete

-- Table structure for table `[[dbprefix]]auctions`

[115] Fix | Delete

--

[116] Fix | Delete

[117] Fix | Delete

CREATE TABLE `[[dbprefix]]auctions` (

[118] Fix | Delete

`id` int(32) NOT NULL AUTO_INCREMENT,

[119] Fix | Delete

`user` int(32) DEFAULT NULL,

[120] Fix | Delete

`title` varchar(70) DEFAULT NULL,

[121] Fix | Delete

`subtitle` varchar(70) DEFAULT NULL,

[122] Fix | Delete

`starts` varchar(14) DEFAULT NULL,

[123] Fix | Delete

`description` text,

[124] Fix | Delete

`pict_url` tinytext,

[125] Fix | Delete

`category` int(11) DEFAULT NULL,

[126] Fix | Delete

`secondcat` int(11) DEFAULT NULL,

[127] Fix | Delete

`minimum_bid` double(16,2) DEFAULT '0.00',

[128] Fix | Delete

`shipping_cost` double(16,2) DEFAULT '0.00',

[129] Fix | Delete

`shipping_cost_additional` double(16,2) DEFAULT '0.00',

[130] Fix | Delete

`reserve_price` double(16,2) DEFAULT '0.00',

[131] Fix | Delete

`buy_now` double(16,2) DEFAULT '0.00',

[132] Fix | Delete

`auction_type` char(1) DEFAULT NULL,

[133] Fix | Delete

`duration` varchar(7) DEFAULT NULL,

[134] Fix | Delete

`increment` double(8,2) NOT NULL DEFAULT '0.00',

[135] Fix | Delete

`shipping` char(1) DEFAULT NULL,

[136] Fix | Delete

`payment` tinytext,

[137] Fix | Delete

`international` char(1) DEFAULT NULL,

[138] Fix | Delete

`ends` varchar(14) DEFAULT NULL,

[139] Fix | Delete

`current_bid` double(16,2) DEFAULT '0.00',

[140] Fix | Delete

`closed` int(1) DEFAULT '0',

[141] Fix | Delete

`photo_uploaded` tinyint(1) DEFAULT NULL,

[142] Fix | Delete

`quantity` int(11) DEFAULT NULL,

[143] Fix | Delete

`suspended` int(1) DEFAULT '0',

[144] Fix | Delete

`relist` int(11) NOT NULL DEFAULT '0',

[145] Fix | Delete

`relisted` int(11) NOT NULL DEFAULT '0',

[146] Fix | Delete

`num_bids` int(11) NOT NULL DEFAULT '0',

[147] Fix | Delete

`sold` enum('y','n','s') NOT NULL DEFAULT 'n',

[148] Fix | Delete

`shipping_terms` tinytext NOT NULL,

[149] Fix | Delete

`bn_only` enum('y','n') NOT NULL DEFAULT 'n',

[150] Fix | Delete

`bold` enum('y','n') NOT NULL DEFAULT 'n',

[151] Fix | Delete

`highlighted` enum('y','n') NOT NULL DEFAULT 'n',

[152] Fix | Delete

`featured` enum('y','n') NOT NULL DEFAULT 'n',

[153] Fix | Delete

`current_fee` double(16,2) DEFAULT '0.00',

[154] Fix | Delete

`tax` enum('y','n') NOT NULL DEFAULT 'n',

[155] Fix | Delete

`taxinc` enum('y','n') NOT NULL DEFAULT 'y',

[156] Fix | Delete

`item_condition` varchar(40) DEFAULT '',

[157] Fix | Delete

`item_manufacturer` varchar(32) DEFAULT '',

[158] Fix | Delete

`item_model` varchar(32) DEFAULT '',

[159] Fix | Delete

`item_colour` varchar(32) DEFAULT '',

[160] Fix | Delete

`item_year` varchar(11) DEFAULT '',

[161] Fix | Delete

`returns` char(1) DEFAULT NULL,

[162] Fix | Delete

`sell_type` enum('free','sell') NOT NULL DEFAULT 'sell',

[163] Fix | Delete

`locationMap` enum('y','n') NOT NULL DEFAULT 'n',

[164] Fix | Delete

PRIMARY KEY (`id`),

[165] Fix | Delete

KEY `id` (`id`)

[166] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[167] Fix | Delete

[168] Fix | Delete

-- --------------------------------------------------------

[169] Fix | Delete

[170] Fix | Delete

--

[171] Fix | Delete

-- Table structure for table `[[dbprefix]]banners`

[172] Fix | Delete

--

[173] Fix | Delete

[174] Fix | Delete

CREATE TABLE `[[dbprefix]]banners` (

[175] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[176] Fix | Delete

`name` varchar(255) DEFAULT NULL,

[177] Fix | Delete

`type` enum('gif','jpg','png','swf') DEFAULT NULL,

[178] Fix | Delete

`views` int(11) DEFAULT NULL,

[179] Fix | Delete

`clicks` int(11) DEFAULT NULL,

[180] Fix | Delete

`url` varchar(255) DEFAULT NULL,

[181] Fix | Delete

`sponsortext` varchar(255) DEFAULT NULL,

[182] Fix | Delete

`alt` varchar(255) DEFAULT NULL,

[183] Fix | Delete

`purchased` int(11) NOT NULL DEFAULT '0',

[184] Fix | Delete

`width` int(11) NOT NULL DEFAULT '0',

[185] Fix | Delete

`height` int(11) NOT NULL DEFAULT '0',

[186] Fix | Delete

`user` int(11) NOT NULL DEFAULT '0',

[187] Fix | Delete

`seller` int(11) NOT NULL,

[188] Fix | Delete

KEY `id` (`id`)

[189] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[190] Fix | Delete

[191] Fix | Delete

-- --------------------------------------------------------

[192] Fix | Delete

[193] Fix | Delete

--

[194] Fix | Delete

-- Table structure for table `[[dbprefix]]bannerscategories`

[195] Fix | Delete

--

[196] Fix | Delete

[197] Fix | Delete

CREATE TABLE `[[dbprefix]]bannerscategories` (

[198] Fix | Delete

`banner` int(11) NOT NULL DEFAULT '0',

[199] Fix | Delete

`category` int(11) NOT NULL DEFAULT '0'

[200] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[201] Fix | Delete

[202] Fix | Delete

-- --------------------------------------------------------

[203] Fix | Delete

[204] Fix | Delete

--

[205] Fix | Delete

-- Table structure for table `[[dbprefix]]bannerskeywords`

[206] Fix | Delete

--

[207] Fix | Delete

[208] Fix | Delete

CREATE TABLE `[[dbprefix]]bannerskeywords` (

[209] Fix | Delete

`banner` int(11) NOT NULL DEFAULT '0',

[210] Fix | Delete

`keyword` varchar(255) NOT NULL DEFAULT ''

[211] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[212] Fix | Delete

[213] Fix | Delete

-- --------------------------------------------------------

[214] Fix | Delete

[215] Fix | Delete

--

[216] Fix | Delete

-- Table structure for table `[[dbprefix]]bannersstats`

[217] Fix | Delete

--

[218] Fix | Delete

[219] Fix | Delete

CREATE TABLE `[[dbprefix]]bannersstats` (

[220] Fix | Delete

`banner` int(11) DEFAULT NULL,

[221] Fix | Delete

`purchased` int(11) DEFAULT NULL,

[222] Fix | Delete

`views` int(11) DEFAULT NULL,

[223] Fix | Delete

`clicks` int(11) DEFAULT NULL,

[224] Fix | Delete

KEY `id` (`banner`)

[225] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[226] Fix | Delete

[227] Fix | Delete

-- --------------------------------------------------------

[228] Fix | Delete

[229] Fix | Delete

--

[230] Fix | Delete

-- Table structure for table `[[dbprefix]]bannersusers`

[231] Fix | Delete

--

[232] Fix | Delete

[233] Fix | Delete

CREATE TABLE `[[dbprefix]]bannersusers` (

[234] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[235] Fix | Delete

`name` varchar(255) DEFAULT NULL,

[236] Fix | Delete

`company` varchar(255) DEFAULT NULL,

[237] Fix | Delete

`email` varchar(255) DEFAULT NULL,

[238] Fix | Delete

`seller` int(11) DEFAULT NULL,

[239] Fix | Delete

`newuser` enum('y','n') DEFAULT NULL,

[240] Fix | Delete

`paid` int(2) DEFAULT NULL,

[241] Fix | Delete

`ex_banner_paid` enum('y','n') DEFAULT NULL,

[242] Fix | Delete

`time_stamp` int(20) DEFAULT NULL,

[243] Fix | Delete

KEY `id` (`id`)

[244] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[245] Fix | Delete

[246] Fix | Delete

-- --------------------------------------------------------

[247] Fix | Delete

[248] Fix | Delete

--

[249] Fix | Delete

-- Table structure for table `[[dbprefix]]bids`

[250] Fix | Delete

--

[251] Fix | Delete

[252] Fix | Delete

CREATE TABLE `[[dbprefix]]bids` (

[253] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[254] Fix | Delete

`auction` int(32) DEFAULT NULL,

[255] Fix | Delete

`bidder` int(32) DEFAULT NULL,

[256] Fix | Delete

`bid` double(16,2) DEFAULT NULL,

[257] Fix | Delete

`bidwhen` varchar(14) DEFAULT NULL,

[258] Fix | Delete

`quantity` int(11) DEFAULT '0',

[259] Fix | Delete

PRIMARY KEY (`id`)

[260] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[261] Fix | Delete

[262] Fix | Delete

-- --------------------------------------------------------

[263] Fix | Delete

[264] Fix | Delete

--

[265] Fix | Delete

-- Table structure for table `[[dbprefix]]categories`

[266] Fix | Delete

--

[267] Fix | Delete

[268] Fix | Delete

CREATE TABLE `[[dbprefix]]categories` (

[269] Fix | Delete

`cat_id` int(4) NOT NULL AUTO_INCREMENT,

[270] Fix | Delete

`parent_id` int(4) DEFAULT NULL,

[271] Fix | Delete

`left_id` int(8) NOT NULL,

[272] Fix | Delete

`right_id` int(8) NOT NULL,

[273] Fix | Delete

`level` int(1) NOT NULL,

[274] Fix | Delete

`cat_name` tinytext,

[275] Fix | Delete

`sub_counter` int(11) DEFAULT '0',

[276] Fix | Delete

`counter` int(11) DEFAULT '0',

[277] Fix | Delete

`cat_colour` varchar(15) DEFAULT '',

[278] Fix | Delete

`cat_image` varchar(150) DEFAULT '',

[279] Fix | Delete

PRIMARY KEY (`cat_id`),

[280] Fix | Delete

KEY `left_id` (`left_id`,`right_id`,`level`)

[281] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=198 ;

[282] Fix | Delete

[283] Fix | Delete

--

[284] Fix | Delete

-- Dumping data for table `[[dbprefix]]categories`

[285] Fix | Delete

--

[286] Fix | Delete

[287] Fix | Delete

INSERT INTO `[[dbprefix]]categories` VALUES

[288] Fix | Delete

(1, -1, 1, 394, -1, 'All', 0, 0, '', ''),

[289] Fix | Delete

(2, 1, 340, 393, 0, 'Art & Antiques', 0, 0, '', ''),

[290] Fix | Delete

(3, 2, 391, 392, 1, 'Textiles & Linens', 0, 0, '', ''),

[291] Fix | Delete

(4, 2, 389, 390, 1, 'Amateur Art', 0, 0, '', ''),

[292] Fix | Delete

(5, 2, 387, 388, 1, 'Ancient World', 0, 0, '', ''),

[293] Fix | Delete

(6, 2, 385, 386, 1, 'Books & Manuscripts', 0, 0, '', ''),

[294] Fix | Delete

(7, 2, 383, 384, 1, 'Cameras', 0, 0, '', ''),

[295] Fix | Delete

(8, 2, 363, 382, 1, 'Ceramics & Glass', 0, 0, '', ''),

[296] Fix | Delete

(9, 8, 364, 381, 2, 'Glass', 0, 0, '', ''),

[297] Fix | Delete

(10, 9, 379, 380, 3, '40s, 50s & 60s', 0, 0, '', ''),

[298] Fix | Delete

(11, 9, 377, 378, 3, 'Art Glass', 0, 0, '', ''),

[299] Fix | Delete

(12, 9, 375, 376, 3, 'Carnival', 0, 0, '', ''),

[300] Fix | Delete

(13, 9, 373, 374, 3, 'Chalkware', 0, 0, '', ''),

[301] Fix | Delete

(14, 9, 371, 372, 3, 'Chintz & Shelley', 0, 0, '', ''),

[302] Fix | Delete

(15, 9, 369, 370, 3, 'Contemporary Glass', 0, 0, '', ''),

[303] Fix | Delete

(16, 9, 367, 368, 3, 'Decorative', 0, 0, '', ''),

[304] Fix | Delete

(17, 9, 365, 366, 3, 'Porcelain', 0, 0, '', ''),

[305] Fix | Delete

(18, 2, 361, 362, 1, 'Fine Art', 0, 0, '', ''),

[306] Fix | Delete

(19, 2, 359, 360, 1, 'General', 0, 0, '', ''),

[307] Fix | Delete

(20, 2, 357, 358, 1, 'Musical Instruments', 0, 0, '', ''),

[308] Fix | Delete

(21, 2, 355, 356, 1, 'Orientalia', 0, 0, '', ''),

[309] Fix | Delete

(22, 2, 353, 354, 1, 'Painting', 0, 0, '', ''),

[310] Fix | Delete

(23, 2, 351, 352, 1, 'Photographic Images', 0, 0, '', ''),

[311] Fix | Delete

(24, 2, 349, 350, 1, 'Post-1900', 0, 0, '', ''),

[312] Fix | Delete

(25, 2, 347, 348, 1, 'Pre-1900', 0, 0, '', ''),

[313] Fix | Delete

(26, 2, 345, 346, 1, 'Prints', 0, 0, '', ''),

[314] Fix | Delete

(27, 2, 343, 344, 1, 'Scientific Instruments', 0, 0, '', ''),

[315] Fix | Delete

(28, 2, 341, 342, 1, 'Silver & Silver Plate', 0, 0, '', ''),

[316] Fix | Delete

(29, 1, 262, 339, 0, 'Books', 0, 0, '', ''),

[317] Fix | Delete

(30, 29, 337, 338, 1, 'Animals', 0, 0, '', ''),

[318] Fix | Delete

(31, 29, 335, 336, 1, 'Arts, Architecture & Photography', 0, 0, '', ''),

[319] Fix | Delete

(32, 29, 333, 334, 1, 'Audiobooks', 0, 0, '', ''),

[320] Fix | Delete

(33, 29, 331, 332, 1, 'Biographies & Memoirs', 0, 0, '', ''),

[321] Fix | Delete

(34, 29, 329, 330, 1, 'Business & Investing', 0, 0, '', ''),

[322] Fix | Delete

(35, 29, 327, 328, 1, 'Catalogs', 0, 0, '', ''),

[323] Fix | Delete

(36, 29, 325, 326, 1, 'Children', 0, 0, '', ''),

[324] Fix | Delete

(37, 29, 323, 324, 1, 'Computers & Internet', 0, 0, '', ''),

[325] Fix | Delete

(38, 29, 321, 322, 1, 'Contemporary', 0, 0, '', ''),

[326] Fix | Delete

(39, 29, 319, 320, 1, 'Cooking, Food & Wine', 0, 0, '', ''),

[327] Fix | Delete

(40, 29, 317, 318, 1, 'Entertainment', 0, 0, '', ''),

[328] Fix | Delete

(41, 29, 315, 316, 1, 'Foreign Language Instruction', 0, 0, '', ''),

[329] Fix | Delete

(42, 29, 313, 314, 1, 'General', 0, 0, '', ''),

[330] Fix | Delete

(43, 29, 311, 312, 1, 'Health, Mind & Body', 0, 0, '', ''),

[331] Fix | Delete

(44, 29, 309, 310, 1, 'Historical', 0, 0, '', ''),

[332] Fix | Delete

(45, 29, 307, 308, 1, 'History', 0, 0, '', ''),

[333] Fix | Delete

(46, 29, 305, 306, 1, 'Home & Garden', 0, 0, '', ''),

[334] Fix | Delete

(47, 29, 303, 304, 1, 'Horror', 0, 0, '', ''),

[335] Fix | Delete

(48, 29, 301, 302, 1, 'Illustrated', 0, 0, '', ''),

[336] Fix | Delete

(49, 29, 299, 300, 1, 'Literature & Fiction', 0, 0, '', ''),

[337] Fix | Delete

(50, 29, 297, 298, 1, 'Men', 0, 0, '', ''),

[338] Fix | Delete

(51, 29, 295, 296, 1, 'Mystery & Thrillers', 0, 0, '', ''),

[339] Fix | Delete

(52, 29, 293, 294, 1, 'News', 0, 0, '', ''),

[340] Fix | Delete

(53, 29, 291, 292, 1, 'Nonfiction', 0, 0, '', ''),

[341] Fix | Delete

(54, 29, 289, 290, 1, 'Parenting & Families', 0, 0, '', ''),

[342] Fix | Delete

(55, 29, 287, 288, 1, 'Poetry', 0, 0, '', ''),

[343] Fix | Delete

(56, 29, 285, 286, 1, 'Rare', 0, 0, '', ''),

[344] Fix | Delete

(57, 29, 283, 284, 1, 'Reference', 0, 0, '', ''),

[345] Fix | Delete

(58, 29, 281, 282, 1, 'Regency', 0, 0, '', ''),

[346] Fix | Delete

(59, 29, 279, 280, 1, 'Religion & Spirituality', 0, 0, '', ''),

[347] Fix | Delete

(60, 29, 277, 278, 1, 'Science & Nature', 0, 0, '', ''),

[348] Fix | Delete

(61, 29, 275, 276, 1, 'Science Fiction & Fantasy', 0, 0, '', ''),

[349] Fix | Delete

(62, 29, 273, 274, 1, 'Sports', 0, 0, '', ''),

[350] Fix | Delete

(63, 29, 271, 272, 1, 'Sports & Outdoors', 0, 0, '', ''),

[351] Fix | Delete

(64, 29, 269, 270, 1, 'Teens', 0, 0, '', ''),

[352] Fix | Delete

(65, 29, 267, 268, 1, 'Textbooks', 0, 0, '', ''),

[353] Fix | Delete

(66, 29, 265, 266, 1, 'Travel', 0, 0, '', ''),

[354] Fix | Delete

(67, 29, 263, 264, 1, 'Women', 0, 0, '', ''),

[355] Fix | Delete

(68, 1, 254, 261, 0, 'Clothing & Accessories', 0, 0, '', ''),

[356] Fix | Delete

(69, 68, 259, 260, 1, 'Accessories', 0, 0, '', ''),

[357] Fix | Delete

(70, 68, 257, 258, 1, 'Clothing', 0, 0, '', ''),

[358] Fix | Delete

(71, 68, 255, 256, 1, 'Watches', 0, 0, '', ''),

[359] Fix | Delete

(72, 1, 248, 253, 0, 'Coins & Stamps', 0, 0, '', ''),

[360] Fix | Delete

(73, 72, 251, 252, 1, 'Coins', 0, 0, '', ''),

[361] Fix | Delete

(74, 72, 249, 250, 1, 'Philately', 0, 0, '', ''),

[362] Fix | Delete

(75, 1, 172, 247, 0, 'Collectibles', 0, 0, '', ''),

[363] Fix | Delete

(76, 75, 245, 246, 1, 'Advertising', 0, 0, '', ''),

[364] Fix | Delete

(77, 75, 243, 244, 1, 'Animals', 0, 0, '', ''),

[365] Fix | Delete

(78, 75, 241, 242, 1, 'Animation', 0, 0, '', ''),

[366] Fix | Delete

(79, 75, 239, 240, 1, 'Antique Reproductions', 0, 0, '', ''),

[367] Fix | Delete

(80, 75, 237, 238, 1, 'Autographs', 0, 0, '', ''),

[368] Fix | Delete

(81, 75, 235, 236, 1, 'Barber Shop', 0, 0, '', ''),

[369] Fix | Delete

(82, 75, 233, 234, 1, 'Bears', 0, 0, '', ''),

[370] Fix | Delete

(83, 75, 231, 232, 1, 'Bells', 0, 0, '', ''),

[371] Fix | Delete

(84, 75, 229, 230, 1, 'Bottles & Cans', 0, 0, '', ''),

[372] Fix | Delete

(85, 75, 227, 228, 1, 'Breweriana', 0, 0, '', ''),

[373] Fix | Delete

(86, 75, 225, 226, 1, 'Cars & Motorcycles', 0, 0, '', ''),

[374] Fix | Delete

(87, 75, 223, 224, 1, 'Cereal Boxes & Premiums', 0, 0, '', ''),

[375] Fix | Delete

(88, 75, 221, 222, 1, 'Character', 0, 0, '', ''),

[376] Fix | Delete

(89, 75, 219, 220, 1, 'Circus & Carnival', 0, 0, '', ''),

[377] Fix | Delete

(90, 75, 217, 218, 1, 'Collector Plates', 0, 0, '', ''),

[378] Fix | Delete

(91, 75, 215, 216, 1, 'Dolls', 0, 0, '', ''),

[379] Fix | Delete

(92, 75, 213, 214, 1, 'General', 0, 0, '', ''),

[380] Fix | Delete

(93, 75, 211, 212, 1, 'Historical & Cultural', 0, 0, '', ''),

[381] Fix | Delete

(94, 75, 209, 210, 1, 'Holiday & Seasonal', 0, 0, '', ''),

[382] Fix | Delete

(95, 75, 207, 208, 1, 'Household Items', 0, 0, '', ''),

[383] Fix | Delete

(96, 75, 205, 206, 1, 'Kitsch', 0, 0, '', ''),

[384] Fix | Delete

(97, 75, 203, 204, 1, 'Knives & Swords', 0, 0, '', ''),

[385] Fix | Delete

(98, 75, 201, 202, 1, 'Lunchboxes', 0, 0, '', ''),

[386] Fix | Delete

(99, 75, 199, 200, 1, 'Magic & Novelty Items', 0, 0, '', ''),

[387] Fix | Delete

(100, 75, 197, 198, 1, 'Memorabilia', 0, 0, '', ''),

[388] Fix | Delete

(101, 75, 195, 196, 1, 'Militaria', 0, 0, '', ''),

[389] Fix | Delete

(102, 75, 193, 194, 1, 'Music Boxes', 0, 0, '', ''),

[390] Fix | Delete

(103, 75, 191, 192, 1, 'Oddities', 0, 0, '', ''),

[391] Fix | Delete

(104, 75, 189, 190, 1, 'Paper', 0, 0, '', ''),

[392] Fix | Delete

(105, 75, 187, 188, 1, 'Pinbacks', 0, 0, '', ''),

[393] Fix | Delete

(106, 75, 185, 186, 1, 'Porcelain Figurines', 0, 0, '', ''),

[394] Fix | Delete

(107, 75, 183, 184, 1, 'Railroadiana', 0, 0, '', ''),

[395] Fix | Delete

(108, 75, 181, 182, 1, 'Religious', 0, 0, '', ''),

[396] Fix | Delete

(109, 75, 179, 180, 1, 'Rocks, Minerals & Fossils', 0, 0, '', ''),

[397] Fix | Delete

(110, 75, 177, 178, 1, 'Scientific Instruments', 0, 0, '', ''),

[398] Fix | Delete

(111, 75, 175, 176, 1, 'Textiles', 0, 0, '', ''),

[399] Fix | Delete

(112, 75, 173, 174, 1, 'Tobacciana', 0, 0, '', ''),

[400] Fix | Delete

(113, 1, 154, 171, 0, 'Comics, Cards & Science Fiction', 0, 0, '', ''),

[401] Fix | Delete

(114, 113, 169, 170, 1, 'Anime & Manga', 0, 0, '', ''),

[402] Fix | Delete

(115, 113, 167, 168, 1, 'Comic Books', 0, 0, '', ''),

[403] Fix | Delete

(116, 113, 165, 166, 1, 'General', 0, 0, '', ''),

[404] Fix | Delete

(117, 113, 163, 164, 1, 'Godzilla', 0, 0, '', ''),

[405] Fix | Delete

(118, 113, 161, 162, 1, 'Star Trek', 0, 0, '', ''),

[406] Fix | Delete

(119, 113, 159, 160, 1, 'The X-Files', 0, 0, '', ''),

[407] Fix | Delete

(120, 113, 157, 158, 1, 'Toys', 0, 0, '', ''),

[408] Fix | Delete

(121, 113, 155, 156, 1, 'Trading Cards', 0, 0, '', ''),

[409] Fix | Delete

(122, 1, 144, 153, 0, 'Computers & Software', 0, 0, '', ''),

[410] Fix | Delete

(123, 122, 151, 152, 1, 'General', 0, 0, '', ''),

[411] Fix | Delete

(124, 122, 149, 150, 1, 'Hardware', 0, 0, '', ''),

[412] Fix | Delete

(125, 122, 147, 148, 1, 'Internet Services', 0, 0, '', ''),

[413] Fix | Delete

(126, 122, 145, 146, 1, 'Software', 0, 0, '', ''),

[414] Fix | Delete

(127, 1, 132, 143, 0, 'Electronics & Photography', 0, 0, '', ''),

[415] Fix | Delete

(128, 127, 141, 142, 1, 'Consumer Electronics', 0, 0, '', ''),

[416] Fix | Delete

(129, 127, 139, 140, 1, 'General', 0, 0, '', ''),

[417] Fix | Delete

(130, 127, 137, 138, 1, 'Photo Equipment', 0, 0, '', ''),

[418] Fix | Delete

(131, 127, 135, 136, 1, 'Recording Equipment', 0, 0, '', ''),

[419] Fix | Delete

(132, 127, 133, 134, 1, 'Video Equipment', 0, 0, '', ''),

[420] Fix | Delete

(133, 1, 112, 131, 0, 'Home & Garden', 0, 0, '', ''),

[421] Fix | Delete

(134, 133, 129, 130, 1, 'Baby Items', 0, 0, '', ''),

[422] Fix | Delete

(135, 133, 127, 128, 1, 'Crafts', 0, 0, '', ''),

[423] Fix | Delete

(136, 133, 125, 126, 1, 'Furniture', 0, 0, '', ''),

[424] Fix | Delete

(137, 133, 123, 124, 1, 'Garden', 0, 0, '', ''),

[425] Fix | Delete

(138, 133, 121, 122, 1, 'General', 0, 0, '', ''),

[426] Fix | Delete

(139, 133, 119, 120, 1, 'Household Items', 0, 0, '', ''),

[427] Fix | Delete

(140, 133, 117, 118, 1, 'Pet Supplies', 0, 0, '', ''),

[428] Fix | Delete

(141, 133, 115, 116, 1, 'Tools & Hardware', 0, 0, '', ''),

[429] Fix | Delete

(142, 133, 113, 114, 1, 'Weddings', 0, 0, '', ''),

[430] Fix | Delete

(143, 1, 98, 111, 0, 'Movies & Video', 0, 0, '', ''),

[431] Fix | Delete

(144, 143, 109, 110, 1, 'Blueray', 0, 0, '', ''),

[432] Fix | Delete

(145, 143, 107, 108, 1, 'DVD', 0, 0, '', ''),

[433] Fix | Delete

(146, 143, 105, 106, 1, 'General', 0, 0, '', ''),

[434] Fix | Delete

(147, 143, 103, 104, 1, 'HD-DVD', 0, 0, '', ''),

[435] Fix | Delete

(148, 143, 101, 102, 1, 'Laser Discs', 0, 0, '', ''),

[436] Fix | Delete

(149, 143, 99, 100, 1, 'VHS', 0, 0, '', ''),

[437] Fix | Delete

(150, 1, 84, 97, 0, 'Music', 0, 0, '', ''),

[438] Fix | Delete

(151, 150, 95, 96, 1, 'CDs', 0, 0, '', ''),

[439] Fix | Delete

(152, 150, 93, 94, 1, 'General', 0, 0, '', ''),

[440] Fix | Delete

(153, 150, 91, 92, 1, 'Instruments', 0, 0, '', ''),

[441] Fix | Delete

(154, 150, 89, 90, 1, 'Memorabilia', 0, 0, '', ''),

[442] Fix | Delete

(155, 150, 87, 88, 1, 'Records', 0, 0, '', ''),

[443] Fix | Delete

(156, 150, 85, 86, 1, 'Tapes', 0, 0, '', ''),

[444] Fix | Delete

(157, 1, 74, 83, 0, 'Office & Business', 0, 0, '', ''),

[445] Fix | Delete

(158, 157, 81, 82, 1, 'Briefcases', 0, 0, '', ''),

[446] Fix | Delete

(159, 157, 79, 80, 1, 'Fax Machines', 0, 0, '', ''),

[447] Fix | Delete

(160, 157, 77, 78, 1, 'General Equipment', 0, 0, '', ''),

[448] Fix | Delete

(161, 157, 75, 76, 1, 'Pagers', 0, 0, '', ''),

[449] Fix | Delete

(162, 1, 58, 73, 0, 'Other Goods & Services', 0, 0, '', ''),

[450] Fix | Delete

(163, 162, 71, 72, 1, 'General', 0, 0, '', ''),

[451] Fix | Delete

(164, 162, 69, 70, 1, 'Metaphysical', 0, 0, '', ''),

[452] Fix | Delete

(165, 162, 67, 68, 1, 'Property', 0, 0, '', ''),

[453] Fix | Delete

(166, 162, 65, 66, 1, 'Services', 0, 0, '', ''),

[454] Fix | Delete

(167, 162, 63, 64, 1, 'Tickets & Events', 0, 0, '', ''),

[455] Fix | Delete

(168, 162, 61, 62, 1, 'Transportation', 0, 0, '', ''),

[456] Fix | Delete

(169, 162, 59, 60, 1, 'Travel', 0, 0, '', ''),

[457] Fix | Delete

(170, 1, 50, 57, 0, 'Sports & Recreation', 0, 0, '', ''),

[458] Fix | Delete

(171, 170, 55, 56, 1, 'Apparel & Equipment', 0, 0, '', ''),

[459] Fix | Delete

(172, 170, 53, 54, 1, 'Exercise Equipment', 0, 0, '', ''),

[460] Fix | Delete

(173, 170, 51, 52, 1, 'General', 0, 0, '', ''),

[461] Fix | Delete

(174, 1, 2, 49, 0, 'Toys & Games', 0, 0, '', ''),

[462] Fix | Delete

(175, 174, 47, 48, 1, 'Action Figures', 0, 0, '', ''),

[463] Fix | Delete

(176, 174, 45, 46, 1, 'Beanie Babies & Beanbag Toys', 0, 0, '', ''),

[464] Fix | Delete

(177, 174, 43, 44, 1, 'Diecast', 0, 0, '', ''),

[465] Fix | Delete

(178, 174, 41, 42, 1, 'Fast Food', 0, 0, '', ''),

[466] Fix | Delete

(179, 174, 39, 40, 1, 'Fisher-Price', 0, 0, '', ''),

[467] Fix | Delete

(180, 174, 37, 38, 1, 'Furby', 0, 0, '', ''),

[468] Fix | Delete

(181, 174, 35, 36, 1, 'Games', 0, 0, '', ''),

[469] Fix | Delete

(182, 174, 33, 34, 1, 'General', 0, 0, '', ''),

[470] Fix | Delete

(183, 174, 31, 32, 1, 'Giga Pet & Tamagotchi', 0, 0, '', ''),

[471] Fix | Delete

(184, 174, 29, 30, 1, 'Hobbies', 0, 0, '', ''),

[472] Fix | Delete

(185, 174, 27, 28, 1, 'Marbles', 0, 0, '', ''),

[473] Fix | Delete

(186, 174, 25, 26, 1, 'My Little Pony', 0, 0, '', ''),

[474] Fix | Delete

(187, 174, 23, 24, 1, 'Peanuts Gang', 0, 0, '', ''),

[475] Fix | Delete

(188, 174, 21, 22, 1, 'Pez', 0, 0, '', ''),

[476] Fix | Delete

(189, 174, 19, 20, 1, 'Plastic Models', 0, 0, '', ''),

[477] Fix | Delete

(190, 174, 17, 18, 1, 'Plush Toys', 0, 0, '', ''),

[478] Fix | Delete

(191, 174, 15, 16, 1, 'Puzzles', 0, 0, '', ''),

[479] Fix | Delete

(192, 174, 13, 14, 1, 'lot Cars', 0, 0, '', ''),

[480] Fix | Delete

(193, 174, 11, 12, 1, 'Teletubbies', 0, 0, '', ''),

[481] Fix | Delete

(194, 174, 9, 10, 1, 'Toy Soldiers', 0, 0, '', ''),

[482] Fix | Delete

(195, 174, 7, 8, 1, 'Vintage', 0, 0, '', ''),

[483] Fix | Delete

(196, 174, 5, 6, 1, 'Vintage Tin', 0, 0, '', ''),

[484] Fix | Delete

(197, 174, 3, 4, 1, 'Vintage Vehicles', 0, 0, '', '');

[485] Fix | Delete

[486] Fix | Delete

-- --------------------------------------------------------

[487] Fix | Delete

[488] Fix | Delete

--

[489] Fix | Delete

-- Table structure for table `[[dbprefix]]closedrelisted`

[490] Fix | Delete

--

[491] Fix | Delete

[492] Fix | Delete

CREATE TABLE `[[dbprefix]]closedrelisted` (

[493] Fix | Delete

`auction` int(32) DEFAULT '0',

[494] Fix | Delete

`relistdate` varchar(8) NOT NULL DEFAULT '',

[495] Fix | Delete

`newauction` int(32) NOT NULL DEFAULT '0'

[496] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[497] Fix | Delete

[498] Fix | Delete

-- --------------------------------------------------------

[499] Fix | Delete