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: `ocart4023`

[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(60) NOT NULL,

[25] Fix | Delete

`address_1` varchar(128) NOT NULL,

[26] Fix | Delete

`address_2` varchar(128) NOT NULL,

[27] Fix | Delete

`city` varchar(128) NOT NULL,

[28] Fix | Delete

`postcode` varchar(10) NOT NULL,

[29] Fix | Delete

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

[30] Fix | Delete

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

[31] Fix | Delete

`custom_field` text NOT NULL,

[32] Fix | Delete

`default` tinyint(1) NOT NULL,

[33] Fix | Delete

PRIMARY KEY (`address_id`),

[34] Fix | Delete

KEY `customer_id` (`customer_id`)

[35] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[36] Fix | Delete

[37] Fix | Delete

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

[38] Fix | Delete

[39] Fix | Delete

[40] Fix | Delete

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

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

CREATE TABLE `[[dbprefix]]address_format` (

[44] Fix | Delete

`address_format_id` int(11) NOT NULL AUTO_INCREMENT,

[45] Fix | Delete

`name` varchar(128) NOT NULL,

[46] Fix | Delete

`address_format` text NOT NULL,

[47] Fix | Delete

PRIMARY KEY (`address_format_id`)

[48] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

[49] Fix | Delete

[50] Fix | Delete

[51] Fix | Delete

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

[52] Fix | Delete

[53] Fix | Delete

[54] Fix | Delete

INSERT INTO `[[dbprefix]]address_format` VALUES

[55] Fix | Delete

(1, 'Address Format', '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}');

[56] Fix | Delete

[57] Fix | Delete

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

[58] Fix | Delete

[59] Fix | Delete

[60] Fix | Delete

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

[61] Fix | Delete

[62] Fix | Delete

[63] Fix | Delete

CREATE TABLE `[[dbprefix]]antispam` (

[64] Fix | Delete

`antispam_id` int(11) NOT NULL AUTO_INCREMENT,

[65] Fix | Delete

`keyword` varchar(64) NOT NULL,

[66] Fix | Delete

PRIMARY KEY (`antispam_id`),

[67] Fix | Delete

KEY `keyword` (`keyword`)

[68] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[69] Fix | Delete

[70] Fix | Delete

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

[71] Fix | Delete

[72] Fix | Delete

[73] Fix | Delete

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

[74] Fix | Delete

[75] Fix | Delete

[76] Fix | Delete

CREATE TABLE `[[dbprefix]]api` (

[77] Fix | Delete

`api_id` int(11) NOT NULL AUTO_INCREMENT,

[78] Fix | Delete

`username` varchar(64) NOT NULL,

[79] Fix | Delete

`key` text NOT NULL,

[80] Fix | Delete

`status` tinyint(1) NOT NULL,

[81] Fix | Delete

`date_added` datetime NOT NULL,

[82] Fix | Delete

`date_modified` datetime NOT NULL,

[83] Fix | Delete

PRIMARY KEY (`api_id`)

[84] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

[85] Fix | Delete

[86] Fix | Delete

[87] Fix | Delete

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

[88] Fix | Delete

[89] Fix | Delete

[90] Fix | Delete

INSERT INTO `[[dbprefix]]api` VALUES

[91] Fix | Delete

(1, 'Default', '[[api_key]]', 1, '[[regtime]]', '[[regtime]]');

[92] Fix | Delete

[93] Fix | Delete

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

[94] Fix | Delete

[95] Fix | Delete

[96] Fix | Delete

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

[97] Fix | Delete

[98] Fix | Delete

[99] Fix | Delete

CREATE TABLE `[[dbprefix]]api_ip` (

[100] Fix | Delete

`api_ip_id` int(11) NOT NULL AUTO_INCREMENT,

[101] Fix | Delete

`api_id` int(11) NOT NULL,

[102] Fix | Delete

`ip` varchar(40) NOT NULL,

[103] Fix | Delete

PRIMARY KEY (`api_ip_id`)

[104] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[105] Fix | Delete

[106] Fix | Delete

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

[107] Fix | Delete

[108] Fix | Delete

[109] Fix | Delete

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

[110] Fix | Delete

[111] Fix | Delete

[112] Fix | Delete

CREATE TABLE `[[dbprefix]]api_session` (

[113] Fix | Delete

`api_session_id` int(11) NOT NULL AUTO_INCREMENT,

[114] Fix | Delete

`api_id` int(11) NOT NULL,

[115] Fix | Delete

`session_id` varchar(32) NOT NULL,

[116] Fix | Delete

`ip` varchar(40) NOT NULL,

[117] Fix | Delete

`date_added` datetime NOT NULL,

[118] Fix | Delete

`date_modified` datetime NOT NULL,

[119] Fix | Delete

PRIMARY KEY (`api_session_id`)

[120] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[121] Fix | Delete

[122] Fix | Delete

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

[123] Fix | Delete

[124] Fix | Delete

[125] Fix | Delete

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

[126] Fix | Delete

[127] Fix | Delete

[128] Fix | Delete

CREATE TABLE `[[dbprefix]]article` (

[129] Fix | Delete

`article_id` int(11) NOT NULL AUTO_INCREMENT,

[130] Fix | Delete

`topic_id` int(11) NOT NULL,

[131] Fix | Delete

`author` varchar(64) NOT NULL,

[132] Fix | Delete

`status` tinyint(1) NOT NULL,

[133] Fix | Delete

`date_added` datetime NOT NULL,

[134] Fix | Delete

`date_modified` datetime NOT NULL,

[135] Fix | Delete

PRIMARY KEY (`article_id`)

[136] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[137] Fix | Delete

[138] Fix | Delete

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

[139] Fix | Delete

[140] Fix | Delete

[141] Fix | Delete

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

[142] Fix | Delete

[143] Fix | Delete

[144] Fix | Delete

CREATE TABLE `[[dbprefix]]article_comment` (

[145] Fix | Delete

`article_comment_id` int(11) NOT NULL AUTO_INCREMENT,

[146] Fix | Delete

`article_id` int(11) NOT NULL,

[147] Fix | Delete

`customer_id` int(11) NOT NULL,

[148] Fix | Delete

`comment` text NOT NULL,

[149] Fix | Delete

`status` varchar(255) NOT NULL,

[150] Fix | Delete

`date_added` datetime NOT NULL,

[151] Fix | Delete

PRIMARY KEY (`article_comment_id`),

[152] Fix | Delete

KEY `article_id` (`article_id`)

[153] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[154] Fix | Delete

[155] Fix | Delete

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

[156] Fix | Delete

[157] Fix | Delete

[158] Fix | Delete

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

[159] Fix | Delete

[160] Fix | Delete

[161] Fix | Delete

CREATE TABLE `[[dbprefix]]article_description` (

[162] Fix | Delete

`article_id` int(11) NOT NULL,

[163] Fix | Delete

`language_id` int(11) NOT NULL,

[164] Fix | Delete

`image` varchar(255) NOT NULL,

[165] Fix | Delete

`name` varchar(255) NOT NULL,

[166] Fix | Delete

`description` text NOT NULL,

[167] Fix | Delete

`tag` text NOT NULL,

[168] Fix | Delete

`meta_title` varchar(255) NOT NULL,

[169] Fix | Delete

`meta_description` varchar(255) NOT NULL,

[170] Fix | Delete

`meta_keyword` varchar(255) NOT NULL,

[171] Fix | Delete

PRIMARY KEY (`article_id`,`language_id`),

[172] Fix | Delete

KEY `name` (`name`(191))

[173] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[174] Fix | Delete

[175] Fix | Delete

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

[176] Fix | Delete

[177] Fix | Delete

[178] Fix | Delete

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

[179] Fix | Delete

[180] Fix | Delete

[181] Fix | Delete

CREATE TABLE `[[dbprefix]]article_to_layout` (

[182] Fix | Delete

`article_id` int(11) NOT NULL,

[183] Fix | Delete

`store_id` int(11) NOT NULL,

[184] Fix | Delete

`layout_id` int(11) NOT NULL,

[185] Fix | Delete

PRIMARY KEY (`article_id`,`store_id`)

[186] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[187] Fix | Delete

[188] Fix | Delete

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

[189] Fix | Delete

[190] Fix | Delete

[191] Fix | Delete

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

[192] Fix | Delete

[193] Fix | Delete

[194] Fix | Delete

CREATE TABLE `[[dbprefix]]article_to_store` (

[195] Fix | Delete

`article_id` int(11) NOT NULL,

[196] Fix | Delete

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

[197] Fix | Delete

PRIMARY KEY (`article_id`,`store_id`)

[198] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[199] Fix | Delete

[200] Fix | Delete

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

[201] Fix | Delete

[202] Fix | Delete

[203] Fix | Delete

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

[204] Fix | Delete

[205] Fix | Delete

[206] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute` (

[207] Fix | Delete

`attribute_id` int(11) NOT NULL AUTO_INCREMENT,

[208] Fix | Delete

`attribute_group_id` int(11) NOT NULL,

[209] Fix | Delete

`sort_order` int(3) NOT NULL,

[210] Fix | Delete

PRIMARY KEY (`attribute_id`)

[211] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=12 ;

[212] Fix | Delete

[213] Fix | Delete

[214] Fix | Delete

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

[215] Fix | Delete

[216] Fix | Delete

[217] Fix | Delete

INSERT INTO `[[dbprefix]]attribute` VALUES

[218] Fix | Delete

(1, 6, 1),

[219] Fix | Delete

(2, 6, 5),

[220] Fix | Delete

(3, 6, 3),

[221] Fix | Delete

(4, 3, 1),

[222] Fix | Delete

(5, 3, 2),

[223] Fix | Delete

(6, 3, 3),

[224] Fix | Delete

(7, 3, 4),

[225] Fix | Delete

(8, 3, 5),

[226] Fix | Delete

(9, 3, 6),

[227] Fix | Delete

(10, 3, 7),

[228] Fix | Delete

(11, 3, 8);

[229] Fix | Delete

[230] Fix | Delete

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

[231] Fix | Delete

[232] Fix | Delete

[233] Fix | Delete

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

[234] Fix | Delete

[235] Fix | Delete

[236] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_description` (

[237] Fix | Delete

`attribute_id` int(11) NOT NULL,

[238] Fix | Delete

`language_id` int(11) NOT NULL,

[239] Fix | Delete

`name` varchar(64) NOT NULL,

[240] Fix | Delete

PRIMARY KEY (`attribute_id`,`language_id`)

[241] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[242] Fix | Delete

[243] Fix | Delete

[244] Fix | Delete

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

[245] Fix | Delete

[246] Fix | Delete

[247] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_description` VALUES

[248] Fix | Delete

(1, 1, 'Description'),

[249] Fix | Delete

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

[250] Fix | Delete

(3, 1, 'Clockspeed'),

[251] Fix | Delete

(4, 1, 'test 1'),

[252] Fix | Delete

(5, 1, 'test 2'),

[253] Fix | Delete

(6, 1, 'test 3'),

[254] Fix | Delete

(7, 1, 'test 4'),

[255] Fix | Delete

(8, 1, 'test 5'),

[256] Fix | Delete

(9, 1, 'test 6'),

[257] Fix | Delete

(10, 1, 'test 7'),

[258] Fix | Delete

(11, 1, 'test 8');

[259] Fix | Delete

[260] Fix | Delete

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

[261] Fix | Delete

[262] Fix | Delete

[263] Fix | Delete

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

[264] Fix | Delete

[265] Fix | Delete

[266] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_group` (

[267] Fix | Delete

`attribute_group_id` int(11) NOT NULL AUTO_INCREMENT,

[268] Fix | Delete

`sort_order` int(3) NOT NULL,

[269] Fix | Delete

PRIMARY KEY (`attribute_group_id`)

[270] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=7 ;

[271] Fix | Delete

[272] Fix | Delete

[273] Fix | Delete

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

[274] Fix | Delete

[275] Fix | Delete

[276] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_group` VALUES

[277] Fix | Delete

(3, 2),

[278] Fix | Delete

(4, 1),

[279] Fix | Delete

(5, 3),

[280] Fix | Delete

(6, 4);

[281] Fix | Delete

[282] Fix | Delete

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

[283] Fix | Delete

[284] Fix | Delete

[285] Fix | Delete

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

[286] Fix | Delete

[287] Fix | Delete

[288] Fix | Delete

CREATE TABLE `[[dbprefix]]attribute_group_description` (

[289] Fix | Delete

`attribute_group_id` int(11) NOT NULL,

[290] Fix | Delete

`language_id` int(11) NOT NULL,

[291] Fix | Delete

`name` varchar(64) NOT NULL,

[292] Fix | Delete

PRIMARY KEY (`attribute_group_id`,`language_id`)

[293] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[294] Fix | Delete

[295] Fix | Delete

[296] Fix | Delete

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

[297] Fix | Delete

[298] Fix | Delete

[299] Fix | Delete

INSERT INTO `[[dbprefix]]attribute_group_description` VALUES

[300] Fix | Delete

(3, 1, 'Memory'),

[301] Fix | Delete

(4, 1, 'Technical'),

[302] Fix | Delete

(5, 1, 'Motherboard'),

[303] Fix | Delete

(6, 1, 'Processor');

[304] Fix | Delete

[305] Fix | Delete

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

[306] Fix | Delete

[307] Fix | Delete

[308] Fix | Delete

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

[309] Fix | Delete

[310] Fix | Delete

[311] Fix | Delete

CREATE TABLE `[[dbprefix]]banner` (

[312] Fix | Delete

`banner_id` int(11) NOT NULL AUTO_INCREMENT,

[313] Fix | Delete

`name` varchar(64) NOT NULL,

[314] Fix | Delete

`status` tinyint(1) NOT NULL,

[315] Fix | Delete

PRIMARY KEY (`banner_id`)

[316] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9 ;

[317] Fix | Delete

[318] Fix | Delete

[319] Fix | Delete

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

[320] Fix | Delete

[321] Fix | Delete

[322] Fix | Delete

INSERT INTO `[[dbprefix]]banner` VALUES

[323] Fix | Delete

(6, 'HP Products', 1),

[324] Fix | Delete

(7, 'Home Page Slideshow', 1),

[325] Fix | Delete

(8, 'Manufacturers', 1);

[326] Fix | Delete

[327] Fix | Delete

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

[328] Fix | Delete

[329] Fix | Delete

[330] Fix | Delete

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

[331] Fix | Delete

[332] Fix | Delete

[333] Fix | Delete

CREATE TABLE `[[dbprefix]]banner_image` (

[334] Fix | Delete

`banner_image_id` int(11) NOT NULL AUTO_INCREMENT,

[335] Fix | Delete

`banner_id` int(11) NOT NULL,

[336] Fix | Delete

`language_id` int(11) NOT NULL,

[337] Fix | Delete

`title` varchar(64) NOT NULL,

[338] Fix | Delete

`link` varchar(255) NOT NULL,

[339] Fix | Delete

`image` varchar(255) NOT NULL,

[340] Fix | Delete

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

[341] Fix | Delete

PRIMARY KEY (`banner_image_id`)

[342] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=99 ;

[343] Fix | Delete

[344] Fix | Delete

[345] Fix | Delete

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

[346] Fix | Delete

[347] Fix | Delete

[348] Fix | Delete

INSERT INTO `[[dbprefix]]banner_image` VALUES

[349] Fix | Delete

(79, 7, 1, 'iPhone 6', 'index.php?route=product/product&path=57&product_id=49', 'catalog/demo/banners/iPhone6.jpg', 0),

[350] Fix | Delete

(80, 7, 1, 'MacBookAir', '', 'catalog/demo/banners/MacBookAir.jpg', 0),

[351] Fix | Delete

(87, 6, 1, 'HP Banner', 'index.php?route=product/manufacturer.info&manufacturer_id=7', 'catalog/demo/compaq_presario.jpg', 0),

[352] Fix | Delete

(88, 8, 1, 'Harley Davidson', '', 'catalog/demo/manufacturer/harley.png', 0),

[353] Fix | Delete

(89, 8, 1, 'Dell', '', 'catalog/demo/manufacturer/dell.png', 0),

[354] Fix | Delete

(90, 8, 1, 'Disney', '', 'catalog/demo/manufacturer/disney.png', 0),

[355] Fix | Delete

(91, 8, 1, 'Coca Cola', '', 'catalog/demo/manufacturer/cocacola.png', 0),

[356] Fix | Delete

(92, 8, 1, 'Burger King', '', 'catalog/demo/manufacturer/burgerking.png', 0),

[357] Fix | Delete

(93, 8, 1, 'Canon', '', 'catalog/demo/manufacturer/canon.png', 0),

[358] Fix | Delete

(94, 8, 1, 'NFL', '', 'catalog/demo/manufacturer/nfl.png', 0),

[359] Fix | Delete

(95, 8, 1, 'RedBull', '', 'catalog/demo/manufacturer/redbull.png', 0),

[360] Fix | Delete

(96, 8, 1, 'Sony', '', 'catalog/demo/manufacturer/sony.png', 0),

[361] Fix | Delete

(97, 8, 1, 'Starbucks', '', 'catalog/demo/manufacturer/starbucks.png', 0),

[362] Fix | Delete

(98, 8, 1, 'Nintendo', '', 'catalog/demo/manufacturer/nintendo.png', 0);

[363] Fix | Delete

[364] Fix | Delete

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

[365] Fix | Delete

[366] Fix | Delete

[367] Fix | Delete

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

[368] Fix | Delete

[369] Fix | Delete

[370] Fix | Delete

CREATE TABLE `[[dbprefix]]cart` (

[371] Fix | Delete

`cart_id` int(11) NOT NULL AUTO_INCREMENT,

[372] Fix | Delete

`api_id` int(11) NOT NULL,

[373] Fix | Delete

`customer_id` int(11) NOT NULL,

[374] Fix | Delete

`session_id` varchar(32) NOT NULL,

[375] Fix | Delete

`product_id` int(11) NOT NULL,

[376] Fix | Delete

`subscription_plan_id` int(11) NOT NULL,

[377] Fix | Delete

`option` text NOT NULL,

[378] Fix | Delete

`quantity` int(5) NOT NULL,

[379] Fix | Delete

`override` tinyint(1) NOT NULL,

[380] Fix | Delete

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

[381] Fix | Delete

`date_added` datetime NOT NULL,

[382] Fix | Delete

PRIMARY KEY (`cart_id`),

[383] Fix | Delete

KEY `cart_id` (`api_id`,`customer_id`,`session_id`,`product_id`,`subscription_plan_id`)

[384] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

[385] Fix | Delete

[386] Fix | Delete

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

[387] Fix | Delete

[388] Fix | Delete

[389] Fix | Delete

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

[390] Fix | Delete

[391] Fix | Delete

[392] Fix | Delete

CREATE TABLE `[[dbprefix]]category` (

[393] Fix | Delete

`category_id` int(11) NOT NULL AUTO_INCREMENT,

[394] Fix | Delete

`image` varchar(255) NOT NULL,

[395] Fix | Delete

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

[396] Fix | Delete

`top` tinyint(1) NOT NULL,

[397] Fix | Delete

`column` int(3) NOT NULL,

[398] Fix | Delete

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

[399] Fix | Delete

`status` tinyint(1) NOT NULL,

[400] Fix | Delete

`date_added` datetime NOT NULL,

[401] Fix | Delete

`date_modified` datetime NOT NULL,

[402] Fix | Delete

PRIMARY KEY (`category_id`),

[403] Fix | Delete

KEY `parent_id` (`parent_id`)

[404] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=59 ;

[405] Fix | Delete

[406] Fix | Delete

[407] Fix | Delete

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

[408] Fix | Delete

[409] Fix | Delete

[410] Fix | Delete

INSERT INTO `[[dbprefix]]category` VALUES

[411] Fix | Delete

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

[412] Fix | Delete

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

[413] Fix | Delete

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

[414] Fix | Delete

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

[415] Fix | Delete

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

[416] Fix | Delete

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

[417] Fix | Delete

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

[418] Fix | Delete

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

[419] Fix | Delete

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

[420] Fix | Delete

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

[421] Fix | Delete

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

[422] Fix | Delete

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

[423] Fix | Delete

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

[424] Fix | Delete

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

[425] Fix | Delete

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

[426] Fix | Delete

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

[427] Fix | Delete

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

[428] Fix | Delete

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

[429] Fix | Delete

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

[430] Fix | Delete

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

[431] Fix | Delete

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

[432] Fix | Delete

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

[433] Fix | Delete

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

[434] Fix | Delete

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

[435] Fix | Delete

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

[436] Fix | Delete

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

[437] Fix | Delete

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

[438] Fix | Delete

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

[439] Fix | Delete

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

[440] Fix | Delete

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

[441] Fix | Delete

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

[442] Fix | Delete

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

[443] Fix | Delete

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

[444] Fix | Delete

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

[445] Fix | Delete

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

[446] Fix | Delete

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

[447] Fix | Delete

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

[448] Fix | Delete

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

[449] Fix | Delete

[450] Fix | Delete

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

[451] Fix | Delete

[452] Fix | Delete

[453] Fix | Delete

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

[454] Fix | Delete

[455] Fix | Delete

[456] Fix | Delete

CREATE TABLE `[[dbprefix]]category_description` (

[457] Fix | Delete

`category_id` int(11) NOT NULL,

[458] Fix | Delete

`language_id` int(11) NOT NULL,

[459] Fix | Delete

`name` varchar(255) NOT NULL,

[460] Fix | Delete

`description` text NOT NULL,

[461] Fix | Delete

`meta_title` varchar(255) NOT NULL,

[462] Fix | Delete

`meta_description` varchar(255) NOT NULL,

[463] Fix | Delete

`meta_keyword` varchar(255) NOT NULL,

[464] Fix | Delete

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

[465] Fix | Delete

KEY `name` (`name`(191))

[466] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

[467] Fix | Delete

[468] Fix | Delete

[469] Fix | Delete

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

[470] Fix | Delete

[471] Fix | Delete

[472] Fix | Delete

INSERT INTO `[[dbprefix]]category_description` VALUES

[473] Fix | Delete

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

[474] 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', 'Laptops & Notebooks', '', ''),

[475] Fix | Delete

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

[476] Fix | Delete

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

[477] Fix | Delete

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

[478] Fix | Delete

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

[479] Fix | Delete

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

[480] Fix | Delete

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

[481] Fix | Delete

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

[482] Fix | Delete

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

[483] Fix | Delete

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

[484] Fix | Delete

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

[485] Fix | Delete

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

[486] 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', 'MP3 Players', '', ''),

[487] Fix | Delete

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

[488] Fix | Delete

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

[489] Fix | Delete

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

[490] Fix | Delete

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

[491] Fix | Delete

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

[492] Fix | Delete

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

[493] Fix | Delete

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

[494] Fix | Delete

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

[495] Fix | Delete

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

[496] Fix | Delete

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

[497] Fix | Delete

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

[498] Fix | Delete

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

[499] Fix | Delete

12 3 4 5 6 ...19