Edit File by line

[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: `soft_ocart1562`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

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

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]address` (

[20] Fix | Delete

`address_id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`customer_id` int(11) NOT NULL,

[22] Fix | Delete

`firstname` varchar(32) NOT NULL,

[23] Fix | Delete

`lastname` varchar(32) NOT NULL,

[24] Fix | Delete

`company` varchar(32) NOT NULL,

[25] Fix | Delete

`company_id` varchar(32) NOT NULL,

[26] Fix | Delete

`tax_id` varchar(32) NOT NULL,

[27] Fix | Delete

`address_1` varchar(128) NOT NULL,

[28] Fix | Delete

`address_2` varchar(128) NOT NULL,

[29] Fix | Delete

`city` varchar(128) NOT NULL,

[30] Fix | Delete

`postcode` varchar(10) NOT NULL,

[31] Fix | Delete

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

[32] Fix | Delete

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

[33] Fix | Delete

PRIMARY KEY (`address_id`),

[34] Fix | Delete

KEY `customer_id` (`customer_id`)

[35] Fix | Delete

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

[36] Fix | Delete

[37] Fix | Delete

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

[38] Fix | Delete

[39] Fix | Delete

[40] Fix | Delete

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

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

CREATE TABLE `[[dbprefix]]affiliate` (

[44] Fix | Delete

`affiliate_id` int(11) NOT NULL AUTO_INCREMENT,

[45] Fix | Delete

`firstname` varchar(32) NOT NULL,

[46] Fix | Delete

`lastname` varchar(32) NOT NULL,

[47] Fix | Delete

`email` varchar(96) NOT NULL,

[48] Fix | Delete

`telephone` varchar(32) NOT NULL,

[49] Fix | Delete

`fax` varchar(32) NOT NULL,

[50] Fix | Delete

`password` varchar(40) NOT NULL,

[51] Fix | Delete

`salt` varchar(9) NOT NULL,

[52] Fix | Delete

`company` varchar(32) NOT NULL,

[53] Fix | Delete

`website` varchar(255) NOT NULL,

[54] Fix | Delete

`address_1` varchar(128) NOT NULL,

[55] Fix | Delete

`address_2` varchar(128) NOT NULL,

[56] Fix | Delete

`city` varchar(128) NOT NULL,

[57] Fix | Delete

`postcode` varchar(10) NOT NULL,

[58] Fix | Delete

`country_id` int(11) NOT NULL,

[59] Fix | Delete

`zone_id` int(11) NOT NULL,

[60] Fix | Delete

`code` varchar(64) NOT NULL,

[61] Fix | Delete

`commission` decimal(4,2) NOT NULL DEFAULT '0.00',

[62] Fix | Delete

`tax` varchar(64) NOT NULL,

[63] Fix | Delete

`payment` varchar(6) NOT NULL,

[64] Fix | Delete

`cheque` varchar(100) NOT NULL,

[65] Fix | Delete

`paypal` varchar(64) NOT NULL,

[66] Fix | Delete

`bank_name` varchar(64) NOT NULL,

[67] Fix | Delete

`bank_branch_number` varchar(64) NOT NULL,

[68] Fix | Delete

`bank_swift_code` varchar(64) NOT NULL,

[69] Fix | Delete

`bank_account_name` varchar(64) NOT NULL,

[70] Fix | Delete

`bank_account_number` varchar(64) NOT NULL,

[71] Fix | Delete

`ip` varchar(40) NOT NULL,

[72] Fix | Delete

`status` tinyint(1) NOT NULL,

[73] Fix | Delete

`approved` tinyint(1) NOT NULL,

[74] Fix | Delete

`date_added` datetime NOT NULL,

[75] Fix | Delete

PRIMARY KEY (`affiliate_id`)

[76] Fix | Delete

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

[77] Fix | Delete

[78] Fix | Delete

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

[79] Fix | Delete

[80] Fix | Delete

[81] Fix | Delete

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

[82] Fix | Delete

[83] Fix | Delete

[84] Fix | Delete

CREATE TABLE `[[dbprefix]]affiliate_transaction` (

[85] Fix | Delete

`affiliate_transaction_id` int(11) NOT NULL AUTO_INCREMENT,

[86] Fix | Delete

`affiliate_id` int(11) NOT NULL,

[87] Fix | Delete

`order_id` int(11) NOT NULL,

[88] Fix | Delete

`description` text NOT NULL,

[89] Fix | Delete

`amount` decimal(15,4) NOT NULL,

[90] Fix | Delete

`date_added` datetime NOT NULL,

[91] Fix | Delete

PRIMARY KEY (`affiliate_transaction_id`)

[92] Fix | Delete

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

[93] Fix | Delete

[94] Fix | Delete

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

[95] Fix | Delete

[96] Fix | Delete

[97] Fix | Delete

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

[98] Fix | Delete

[99] Fix | Delete

[100] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute` (

[101] Fix | Delete

`attribute_id` int(11) NOT NULL AUTO_INCREMENT,

[102] Fix | Delete

`attribute_group_id` int(11) NOT NULL,

[103] Fix | Delete

`sort_order` int(3) NOT NULL,

[104] Fix | Delete

PRIMARY KEY (`attribute_id`)

[105] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

[106] Fix | Delete

[107] Fix | Delete

[108] Fix | Delete

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

[109] Fix | Delete

[110] Fix | Delete

[111] Fix | Delete

INSERT INTO `[[dbprefix]]attribute` VALUES

[112] Fix | Delete

(1, 6, 1),

[113] Fix | Delete

(2, 6, 5),

[114] Fix | Delete

(3, 6, 3),

[115] Fix | Delete

(4, 3, 1),

[116] Fix | Delete

(5, 3, 2),

[117] Fix | Delete

(6, 3, 3),

[118] Fix | Delete

(7, 3, 4),

[119] Fix | Delete

(8, 3, 5),

[120] Fix | Delete

(9, 3, 6),

[121] Fix | Delete

(10, 3, 7),

[122] Fix | Delete

(11, 3, 8);

[123] Fix | Delete

[124] Fix | Delete

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

[125] Fix | Delete

[126] Fix | Delete

[127] Fix | Delete

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

[128] Fix | Delete

[129] Fix | Delete

[130] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_description` (

[131] Fix | Delete

`attribute_id` int(11) NOT NULL,

[132] Fix | Delete

`language_id` int(11) NOT NULL,

[133] Fix | Delete

`name` varchar(64) NOT NULL,

[134] Fix | Delete

PRIMARY KEY (`attribute_id`,`language_id`)

[135] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[136] Fix | Delete

[137] Fix | Delete

[138] Fix | Delete

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

[139] Fix | Delete

[140] Fix | Delete

[141] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_description` VALUES

[142] Fix | Delete

(1, 1, 'Description'),

[143] Fix | Delete

(2, 1, 'No. of Cores'),

[144] Fix | Delete

(4, 1, 'test 1'),

[145] Fix | Delete

(5, 1, 'test 2'),

[146] Fix | Delete

(6, 1, 'test 3'),

[147] Fix | Delete

(7, 1, 'test 4'),

[148] Fix | Delete

(8, 1, 'test 5'),

[149] Fix | Delete

(9, 1, 'test 6'),

[150] Fix | Delete

(10, 1, 'test 7'),

[151] Fix | Delete

(11, 1, 'test 8'),

[152] Fix | Delete

(3, 1, 'Clockspeed');

[153] Fix | Delete

[154] Fix | Delete

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

[155] Fix | Delete

[156] Fix | Delete

[157] Fix | Delete

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

[158] Fix | Delete

[159] Fix | Delete

[160] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_group` (

[161] Fix | Delete

`attribute_group_id` int(11) NOT NULL AUTO_INCREMENT,

[162] Fix | Delete

`sort_order` int(3) NOT NULL,

[163] Fix | Delete

PRIMARY KEY (`attribute_group_id`)

[164] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

[165] Fix | Delete

[166] Fix | Delete

[167] Fix | Delete

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

[168] Fix | Delete

[169] Fix | Delete

[170] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_group` VALUES

[171] Fix | Delete

(3, 2),

[172] Fix | Delete

(4, 1),

[173] Fix | Delete

(5, 3),

[174] Fix | Delete

(6, 4);

[175] Fix | Delete

[176] Fix | Delete

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

[177] Fix | Delete

[178] Fix | Delete

[179] Fix | Delete

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

[180] Fix | Delete

[181] Fix | Delete

[182] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_group_description` (

[183] Fix | Delete

`attribute_group_id` int(11) NOT NULL,

[184] Fix | Delete

`language_id` int(11) NOT NULL,

[185] Fix | Delete

`name` varchar(64) NOT NULL,

[186] Fix | Delete

PRIMARY KEY (`attribute_group_id`,`language_id`)

[187] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[188] Fix | Delete

[189] Fix | Delete

[190] Fix | Delete

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

[191] Fix | Delete

[192] Fix | Delete

[193] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_group_description` VALUES

[194] Fix | Delete

(3, 1, 'Memory'),

[195] Fix | Delete

(4, 1, 'Technical'),

[196] Fix | Delete

(5, 1, 'Motherboard'),

[197] Fix | Delete

(6, 1, 'Processor');

[198] Fix | Delete

[199] Fix | Delete

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

[200] Fix | Delete

[201] Fix | Delete

[202] Fix | Delete

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

[203] Fix | Delete

[204] Fix | Delete

[205] Fix | Delete

CREATE TABLE `[[dbprefix]]banner` (

[206] Fix | Delete

`banner_id` int(11) NOT NULL AUTO_INCREMENT,

[207] Fix | Delete

`name` varchar(64) NOT NULL,

[208] Fix | Delete

`status` tinyint(1) NOT NULL,

[209] Fix | Delete

PRIMARY KEY (`banner_id`)

[210] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

[211] Fix | Delete

[212] Fix | Delete

[213] Fix | Delete

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

[214] Fix | Delete

[215] Fix | Delete

[216] Fix | Delete

INSERT INTO `[[dbprefix]]banner` VALUES

[217] Fix | Delete

(6, 'HP Products', 1),

[218] Fix | Delete

(7, 'Samsung Tab', 1),

[219] Fix | Delete

(8, 'Manufacturers', 1);

[220] Fix | Delete

[221] Fix | Delete

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

[222] Fix | Delete

[223] Fix | Delete

[224] Fix | Delete

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

[225] Fix | Delete

[226] Fix | Delete

[227] Fix | Delete

CREATE TABLE `[[dbprefix]]banner_image` (

[228] Fix | Delete

`banner_image_id` int(11) NOT NULL AUTO_INCREMENT,

[229] Fix | Delete

`banner_id` int(11) NOT NULL,

[230] Fix | Delete

`link` varchar(255) NOT NULL,

[231] Fix | Delete

`image` varchar(255) NOT NULL,

[232] Fix | Delete

PRIMARY KEY (`banner_image_id`)

[233] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;

[234] Fix | Delete

[235] Fix | Delete

[236] Fix | Delete

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

[237] Fix | Delete

[238] Fix | Delete

[239] Fix | Delete

INSERT INTO `[[dbprefix]]banner_image` VALUES

[240] Fix | Delete

(54, 7, 'index.php?route=product/product&path=57&product_id=49', 'data/demo/samsung_banner.jpg'),

[241] Fix | Delete

(77, 6, 'index.php?route=product/manufacturer/info&manufacturer_id=7', 'data/demo/hp_banner.jpg'),

[242] Fix | Delete

(75, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=5', 'data/demo/htc_logo.jpg'),

[243] Fix | Delete

(73, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=8', 'data/demo/apple_logo.jpg'),

[244] Fix | Delete

(74, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=9', 'data/demo/canon_logo.jpg'),

[245] Fix | Delete

(71, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=10', 'data/demo/sony_logo.jpg'),

[246] Fix | Delete

(72, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=6', 'data/demo/palm_logo.jpg'),

[247] Fix | Delete

(76, 8, 'index.php?route=product/manufacturer/info&manufacturer_id=7', 'data/demo/hp_logo.jpg');

[248] Fix | Delete

[249] Fix | Delete

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

[250] Fix | Delete

[251] Fix | Delete

[252] Fix | Delete

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

[253] Fix | Delete

[254] Fix | Delete

[255] Fix | Delete

CREATE TABLE `[[dbprefix]]banner_image_description` (

[256] Fix | Delete

`banner_image_id` int(11) NOT NULL,

[257] Fix | Delete

`language_id` int(11) NOT NULL,

[258] Fix | Delete

`banner_id` int(11) NOT NULL,

[259] Fix | Delete

`title` varchar(64) NOT NULL,

[260] Fix | Delete

PRIMARY KEY (`banner_image_id`,`language_id`)

[261] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[262] Fix | Delete

[263] Fix | Delete

[264] Fix | Delete

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

[265] Fix | Delete

[266] Fix | Delete

[267] Fix | Delete

INSERT INTO `[[dbprefix]]banner_image_description` VALUES

[268] Fix | Delete

(54, 1, 7, 'Samsung Tab 10.1'),

[269] Fix | Delete

(77, 1, 6, 'HP Banner'),

[270] Fix | Delete

(75, 1, 8, 'HTC'),

[271] Fix | Delete

(74, 1, 8, 'Canon'),

[272] Fix | Delete

(73, 1, 8, 'Apple'),

[273] Fix | Delete

(72, 1, 8, 'Palm'),

[274] Fix | Delete

(71, 1, 8, 'Sony'),

[275] Fix | Delete

(76, 1, 8, 'Hewlett-Packard');

[276] Fix | Delete

[277] Fix | Delete

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

[278] Fix | Delete

[279] Fix | Delete

[280] Fix | Delete

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

[281] Fix | Delete

[282] Fix | Delete

[283] Fix | Delete

CREATE TABLE `[[dbprefix]]category` (

[284] Fix | Delete

`category_id` int(11) NOT NULL AUTO_INCREMENT,

[285] Fix | Delete

`image` varchar(255) DEFAULT NULL,

[286] Fix | Delete

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

[287] Fix | Delete

`top` tinyint(1) NOT NULL,

[288] Fix | Delete

`column` int(3) NOT NULL,

[289] Fix | Delete

`sort_order` int(3) NOT NULL DEFAULT '0',

[290] Fix | Delete

`status` tinyint(1) NOT NULL,

[291] Fix | Delete

`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[292] Fix | Delete

`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

[293] Fix | Delete

PRIMARY KEY (`category_id`)

[294] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=59 ;

[295] Fix | Delete

[296] Fix | Delete

[297] Fix | Delete

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

[298] Fix | Delete

[299] Fix | Delete

[300] Fix | Delete

INSERT INTO `[[dbprefix]]category` VALUES

[301] Fix | Delete

(25, '', 0, 1, 1, 3, 1, '2009-01-31 01:04:25', '2011-05-30 12:14:55'),

[302] Fix | Delete

(27, '', 20, 0, 0, 2, 1, '2009-01-31 01:55:34', '2010-08-22 06:32:15'),

[303] Fix | Delete

(20, 'data/demo/compaq_presario.jpg', 0, 1, 1, 1, 1, '2009-01-05 21:49:43', '2011-07-16 02:14:42'),

[304] Fix | Delete

(24, '', 0, 1, 1, 5, 1, '2009-01-20 02:36:26', '2011-05-30 12:15:18'),

[305] Fix | Delete

(18, 'data/demo/hp_2.jpg', 0, 1, 0, 2, 1, '2009-01-05 21:49:15', '2011-05-30 12:13:55'),

[306] Fix | Delete

(17, '', 0, 1, 1, 4, 1, '2009-01-03 21:08:57', '2011-05-30 12:15:11'),

[307] Fix | Delete

(28, '', 25, 0, 0, 1, 1, '2009-02-02 13:11:12', '2010-08-22 06:32:46'),

[308] Fix | Delete

(26, '', 20, 0, 0, 1, 1, '2009-01-31 01:55:14', '2010-08-22 06:31:45'),

[309] Fix | Delete

(29, '', 25, 0, 0, 1, 1, '2009-02-02 13:11:37', '2010-08-22 06:32:39'),

[310] Fix | Delete

(30, '', 25, 0, 0, 1, 1, '2009-02-02 13:11:59', '2010-08-22 06:33:00'),

[311] Fix | Delete

(31, '', 25, 0, 0, 1, 1, '2009-02-03 14:17:24', '2010-08-22 06:33:06'),

[312] Fix | Delete

(32, '', 25, 0, 0, 1, 1, '2009-02-03 14:17:34', '2010-08-22 06:33:12'),

[313] Fix | Delete

(33, '', 0, 1, 1, 6, 1, '2009-02-03 14:17:55', '2011-05-30 12:15:25'),

[314] Fix | Delete

(34, 'data/demo/ipod_touch_4.jpg', 0, 1, 4, 7, 1, '2009-02-03 14:18:11', '2011-05-30 12:15:31'),

[315] Fix | Delete

(35, '', 28, 0, 0, 0, 1, '2010-09-17 10:06:48', '2010-09-18 14:02:42'),

[316] Fix | Delete

(36, '', 28, 0, 0, 0, 1, '2010-09-17 10:07:13', '2010-09-18 14:02:55'),

[317] Fix | Delete

(37, '', 34, 0, 0, 0, 1, '2010-09-18 14:03:39', '2011-04-22 01:55:08'),

[318] Fix | Delete

(38, '', 34, 0, 0, 0, 1, '2010-09-18 14:03:51', '2010-09-18 14:03:51'),

[319] Fix | Delete

(39, '', 34, 0, 0, 0, 1, '2010-09-18 14:04:17', '2011-04-22 01:55:20'),

[320] Fix | Delete

(40, '', 34, 0, 0, 0, 1, '2010-09-18 14:05:36', '2010-09-18 14:05:36'),

[321] Fix | Delete

(41, '', 34, 0, 0, 0, 1, '2010-09-18 14:05:49', '2011-04-22 01:55:30'),

[322] Fix | Delete

(42, '', 34, 0, 0, 0, 1, '2010-09-18 14:06:34', '2010-11-07 20:31:04'),

[323] Fix | Delete

(43, '', 34, 0, 0, 0, 1, '2010-09-18 14:06:49', '2011-04-22 01:55:40'),

[324] Fix | Delete

(44, '', 34, 0, 0, 0, 1, '2010-09-21 15:39:21', '2010-11-07 20:30:55'),

[325] Fix | Delete

(45, '', 18, 0, 0, 0, 1, '2010-09-24 18:29:16', '2011-04-26 08:52:11'),

[326] Fix | Delete

(46, '', 18, 0, 0, 0, 1, '2010-09-24 18:29:31', '2011-04-26 08:52:23'),

[327] Fix | Delete

(47, '', 34, 0, 0, 0, 1, '2010-11-07 11:13:16', '2010-11-07 11:13:16'),

[328] Fix | Delete

(48, '', 34, 0, 0, 0, 1, '2010-11-07 11:13:33', '2010-11-07 11:13:33'),

[329] Fix | Delete

(49, '', 34, 0, 0, 0, 1, '2010-11-07 11:14:04', '2010-11-07 11:14:04'),

[330] Fix | Delete

(50, '', 34, 0, 0, 0, 1, '2010-11-07 11:14:23', '2011-04-22 01:16:01'),

[331] Fix | Delete

(51, '', 34, 0, 0, 0, 1, '2010-11-07 11:14:38', '2011-04-22 01:16:13'),

[332] Fix | Delete

(52, '', 34, 0, 0, 0, 1, '2010-11-07 11:16:09', '2011-04-22 01:54:57'),

[333] Fix | Delete

(53, '', 34, 0, 0, 0, 1, '2010-11-07 11:28:53', '2011-04-22 01:14:36'),

[334] Fix | Delete

(54, '', 34, 0, 0, 0, 1, '2010-11-07 11:29:16', '2011-04-22 01:16:50'),

[335] Fix | Delete

(55, '', 34, 0, 0, 0, 1, '2010-11-08 10:31:32', '2010-11-08 10:31:32'),

[336] Fix | Delete

(56, '', 34, 0, 0, 0, 1, '2010-11-08 10:31:50', '2011-04-22 01:16:37'),

[337] Fix | Delete

(57, '', 0, 1, 1, 3, 1, '2011-04-26 08:53:16', '2011-05-30 12:15:05'),

[338] Fix | Delete

(58, '', 52, 0, 0, 0, 1, '2011-05-08 13:44:16', '2011-05-08 13:44:16');

[339] Fix | Delete

[340] Fix | Delete

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

[341] Fix | Delete

[342] Fix | Delete

[343] Fix | Delete

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

[344] Fix | Delete

[345] Fix | Delete

[346] Fix | Delete

CREATE TABLE `[[dbprefix]]category_description` (

[347] Fix | Delete

`category_id` int(11) NOT NULL,

[348] Fix | Delete

`language_id` int(11) NOT NULL,

[349] Fix | Delete

`name` varchar(255) NOT NULL,

[350] Fix | Delete

`description` text NOT NULL,

[351] Fix | Delete

`meta_description` varchar(255) NOT NULL,

[352] Fix | Delete

`meta_keyword` varchar(255) NOT NULL,

[353] Fix | Delete

PRIMARY KEY (`category_id`,`language_id`),

[354] Fix | Delete

KEY `name` (`name`)

[355] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[356] Fix | Delete

[357] Fix | Delete

[358] Fix | Delete

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

[359] Fix | Delete

[360] Fix | Delete

[361] Fix | Delete

INSERT INTO `[[dbprefix]]category_description` VALUES

[362] Fix | Delete

(28, 1, 'Monitors', '', '', ''),

[363] Fix | Delete

(33, 1, 'Cameras', '', '', ''),

[364] Fix | Delete

(32, 1, 'Web Cameras', '', '', ''),

[365] Fix | Delete

(31, 1, 'Scanners', '', '', ''),

[366] Fix | Delete

(30, 1, 'Printers', '', '', ''),

[367] Fix | Delete

(29, 1, 'Mice and Trackballs', '', '', ''),

[368] Fix | Delete

(27, 1, 'Mac', '', '', ''),

[369] Fix | Delete

(26, 1, 'PC', '', '', ''),

[370] Fix | Delete

(17, 1, 'Software', '', '', ''),

[371] Fix | Delete

(25, 1, 'Components', '', '', ''),

[372] Fix | Delete

(24, 1, 'Phones & PDAs', '', '', ''),

[373] Fix | Delete

(20, 1, 'Desktops', '\r\n Example of category description text\r\n', 'Example of category description', ''),

[374] Fix | Delete

(35, 1, 'test 1', '', '', ''),

[375] Fix | Delete

(36, 1, 'test 2', '', '', ''),

[376] Fix | Delete

(37, 1, 'test 5', '', '', ''),

[377] Fix | Delete

(38, 1, 'test 4', '', '', ''),

[378] Fix | Delete

(39, 1, 'test 6', '', '', ''),

[379] Fix | Delete

(40, 1, 'test 7', '', '', ''),

[380] Fix | Delete

(41, 1, 'test 8', '', '', ''),

[381] Fix | Delete

(42, 1, 'test 9', '', '', ''),

[382] Fix | Delete

(43, 1, 'test 11', '', '', ''),

[383] Fix | Delete

(34, 1, 'MP3 Players', '\r\n Shop Laptop feature only the best laptop deals on the market. By comparing laptop deals from the likes of PC World, Comet, Dixons, The Link and Carphone Warehouse, Shop Laptop has the most comprehensive selection of laptops on the internet. At Shop Laptop, we pride ourselves on offering customers the very best laptop deals. From refurbished laptops to netbooks, Shop Laptop ensures that every laptop - in every colour, style, size and technical spec - is featured on the site at the lowest possible price.\r\n', '', ''),

[384] Fix | Delete

(18, 1, 'Laptops & Notebooks', '\r\n Shop Laptop feature only the best laptop deals on the market. By comparing laptop deals from the likes of PC World, Comet, Dixons, The Link and Carphone Warehouse, Shop Laptop has the most comprehensive selection of laptops on the internet. At Shop Laptop, we pride ourselves on offering customers the very best laptop deals. From refurbished laptops to netbooks, Shop Laptop ensures that every laptop - in every colour, style, size and technical spec - is featured on the site at the lowest possible price.\r\n', '', ''),

[385] Fix | Delete

(44, 1, 'test 12', '', '', ''),

[386] Fix | Delete

(45, 1, 'Windows', '', '', ''),

[387] Fix | Delete

(46, 1, 'Macs', '', '', ''),

[388] Fix | Delete

(47, 1, 'test 15', '', '', ''),

[389] Fix | Delete

(48, 1, 'test 16', '', '', ''),

[390] Fix | Delete

(49, 1, 'test 17', '', '', ''),

[391] Fix | Delete

(50, 1, 'test 18', '', '', ''),

[392] Fix | Delete

(51, 1, 'test 19', '', '', ''),

[393] Fix | Delete

(52, 1, 'test 20', '', '', ''),

[394] Fix | Delete

(53, 1, 'test 21', '', '', ''),

[395] Fix | Delete

(54, 1, 'test 22', '', '', ''),

[396] Fix | Delete

(55, 1, 'test 23', '', '', ''),

[397] Fix | Delete

(56, 1, 'test 24', '', '', ''),

[398] Fix | Delete

(57, 1, 'Tablets', '', '', ''),

[399] Fix | Delete

(58, 1, 'test 25', '', '', '');

[400] Fix | Delete

[401] Fix | Delete

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

[402] Fix | Delete

[403] Fix | Delete

[404] Fix | Delete

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

[405] Fix | Delete

[406] Fix | Delete

[407] Fix | Delete

CREATE TABLE `[[dbprefix]]category_filter` (

[408] Fix | Delete

`category_id` int(11) NOT NULL,

[409] Fix | Delete

`filter_id` int(11) NOT NULL,

[410] Fix | Delete

PRIMARY KEY (`category_id`,`filter_id`)

[411] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[412] Fix | Delete

[413] Fix | Delete

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

[414] Fix | Delete

[415] Fix | Delete

[416] Fix | Delete

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

[417] Fix | Delete

[418] Fix | Delete

[419] Fix | Delete

CREATE TABLE `[[dbprefix]]category_path` (

[420] Fix | Delete

`category_id` int(11) NOT NULL,

[421] Fix | Delete

`path_id` int(11) NOT NULL,

[422] Fix | Delete

`level` int(11) NOT NULL,

[423] Fix | Delete

PRIMARY KEY (`category_id`,`path_id`)

[424] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[425] Fix | Delete

[426] Fix | Delete

[427] Fix | Delete

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

[428] Fix | Delete

[429] Fix | Delete

[430] Fix | Delete

INSERT INTO `[[dbprefix]]category_path` VALUES

[431] Fix | Delete

(25, 25, 0),

[432] Fix | Delete

(28, 25, 0),

[433] Fix | Delete

(28, 28, 1),

[434] Fix | Delete

(35, 25, 0),

[435] Fix | Delete

(35, 28, 1),

[436] Fix | Delete

(35, 35, 2),

[437] Fix | Delete

(36, 25, 0),

[438] Fix | Delete

(36, 28, 1),

[439] Fix | Delete

(36, 36, 2),

[440] Fix | Delete

(29, 25, 0),

[441] Fix | Delete

(29, 29, 1),

[442] Fix | Delete

(30, 25, 0),

[443] Fix | Delete

(30, 30, 1),

[444] Fix | Delete

(31, 25, 0),

[445] Fix | Delete

(31, 31, 1),

[446] Fix | Delete

(32, 25, 0),

[447] Fix | Delete

(32, 32, 1),

[448] Fix | Delete

(20, 20, 0),

[449] Fix | Delete

(27, 20, 0),

[450] Fix | Delete

(27, 27, 1),

[451] Fix | Delete

(26, 20, 0),

[452] Fix | Delete

(26, 26, 1),

[453] Fix | Delete

(24, 24, 0),

[454] Fix | Delete

(18, 18, 0),

[455] Fix | Delete

(45, 18, 0),

[456] Fix | Delete

(45, 45, 1),

[457] Fix | Delete

(46, 18, 0),

[458] Fix | Delete

(46, 46, 1),

[459] Fix | Delete

(17, 17, 0),

[460] Fix | Delete

(33, 33, 0),

[461] Fix | Delete

(34, 34, 0),

[462] Fix | Delete

(37, 34, 0),

[463] Fix | Delete

(37, 37, 1),

[464] Fix | Delete

(38, 34, 0),

[465] Fix | Delete

(38, 38, 1),

[466] Fix | Delete

(39, 34, 0),

[467] Fix | Delete

(39, 39, 1),

[468] Fix | Delete

(40, 34, 0),

[469] Fix | Delete

(40, 40, 1),

[470] Fix | Delete

(41, 34, 0),

[471] Fix | Delete

(41, 41, 1),

[472] Fix | Delete

(42, 34, 0),

[473] Fix | Delete

(42, 42, 1),

[474] Fix | Delete

(43, 34, 0),

[475] Fix | Delete

(43, 43, 1),

[476] Fix | Delete

(44, 34, 0),

[477] Fix | Delete

(44, 44, 1),

[478] Fix | Delete

(47, 34, 0),

[479] Fix | Delete

(47, 47, 1),

[480] Fix | Delete

(48, 34, 0),

[481] Fix | Delete

(48, 48, 1),

[482] Fix | Delete

(49, 34, 0),

[483] Fix | Delete

(49, 49, 1),

[484] Fix | Delete

(50, 34, 0),

[485] Fix | Delete

(50, 50, 1),

[486] Fix | Delete

(51, 34, 0),

[487] Fix | Delete

(51, 51, 1),

[488] Fix | Delete

(52, 34, 0),

[489] Fix | Delete

(52, 52, 1),

[490] Fix | Delete

(58, 34, 0),

[491] Fix | Delete

(58, 52, 1),

[492] Fix | Delete

(58, 58, 2),

[493] Fix | Delete

(53, 34, 0),

[494] Fix | Delete

(53, 53, 1),

[495] Fix | Delete

(54, 34, 0),

[496] Fix | Delete

(54, 54, 1),

[497] Fix | Delete

(55, 34, 0),

[498] Fix | Delete

(55, 55, 1),

[499] Fix | Delete

12 3 4 5 6 ...15