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_alegro129`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `address`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `address` (

[20] Fix | Delete

`address_id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

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

[22] Fix | Delete

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

[23] Fix | Delete

`company` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,

[24] Fix | Delete

`firstname` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[25] Fix | Delete

`lastname` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[26] Fix | Delete

`address_1` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[27] Fix | Delete

`address_2` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,

[28] Fix | Delete

`postcode` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[29] Fix | Delete

`city` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[30] Fix | Delete

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

[31] Fix | Delete

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

[32] Fix | Delete

PRIMARY KEY (`address_id`),

[33] Fix | Delete

KEY `customer_id` (`customer_id`),

[34] Fix | Delete

KEY `vendor_id` (`vendor_id`)

[35] Fix | Delete

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

[36] Fix | Delete

[37] Fix | Delete

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

[38] Fix | Delete

[39] Fix | Delete

[40] Fix | Delete

-- Table structure for table `category`

[41] Fix | Delete

[42] Fix | Delete

[43] Fix | Delete

CREATE TABLE `category` (

[44] Fix | Delete

`category_id` int(11) NOT NULL AUTO_INCREMENT,

[45] Fix | Delete

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

[46] Fix | Delete

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

[47] Fix | Delete

`path` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[48] Fix | Delete

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

[49] Fix | Delete

`category_hide` int(1) NOT NULL DEFAULT '0',

[50] Fix | Delete

`date_added` datetime DEFAULT NULL,

[51] Fix | Delete

`date_modified` datetime DEFAULT NULL,

[52] Fix | Delete

PRIMARY KEY (`category_id`)

[53] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

[54] Fix | Delete

[55] Fix | Delete

[56] Fix | Delete

-- Dumping data for table `category`

[57] Fix | Delete

[58] Fix | Delete

[59] Fix | Delete

INSERT INTO `category` VALUES

[60] Fix | Delete

(1, 6, 0, '1', 1, 0, '2007-08-30 20:56:29', '2009-12-11 04:43:42'),

[61] Fix | Delete

(2, 6, 0, '2', 2, 0, '2007-08-30 18:22:13', '2009-01-08 20:30:22'),

[62] Fix | Delete

(3, 7, 0, '3', 3, 0, '2007-08-30 20:56:18', '2009-01-08 20:09:34'),

[63] Fix | Delete

(4, 5, 0, '4', 4, 0, '2008-12-27 10:57:32', '2009-04-25 17:31:34'),

[64] Fix | Delete

(5, 6, 1, '1_5', 1, 0, '2008-12-27 11:00:16', '2009-12-06 12:40:45'),

[65] Fix | Delete

(6, 7, 1, '1_6', 2, 0, '2008-12-27 11:00:41', '2009-12-06 12:40:56'),

[66] Fix | Delete

(7, 5, 1, '1_7', 3, 0, '2008-12-27 11:01:23', '2009-12-06 12:41:26'),

[67] Fix | Delete

(8, 2, 1, '1_8', 5, 0, '2008-12-27 11:01:55', '2009-12-06 12:41:07'),

[68] Fix | Delete

(9, 3, 0, '9', 6, 0, '2008-12-27 11:14:46', '2009-01-08 20:12:00'),

[69] Fix | Delete

(10, 8, 0, '10', 5, 0, '2008-12-30 21:18:16', '2009-01-08 20:30:35'),

[70] Fix | Delete

(11, 8, 1, '1_11', 4, 0, '2008-12-30 21:19:00', '2009-12-06 12:41:16');

[71] Fix | Delete

[72] Fix | Delete

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

[73] Fix | Delete

[74] Fix | Delete

[75] Fix | Delete

-- Table structure for table `category_description`

[76] Fix | Delete

[77] Fix | Delete

[78] Fix | Delete

CREATE TABLE `category_description` (

[79] Fix | Delete

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

[80] Fix | Delete

`language_id` int(11) NOT NULL DEFAULT '1',

[81] Fix | Delete

`name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[82] Fix | Delete

`description` text COLLATE utf8_unicode_ci,

[83] Fix | Delete

`meta_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[84] Fix | Delete

`meta_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[85] Fix | Delete

`meta_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,

[86] Fix | Delete

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

[87] Fix | Delete

KEY `name` (`name`)

[88] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[89] Fix | Delete

[90] Fix | Delete

[91] Fix | Delete

-- Dumping data for table `category_description`

[92] Fix | Delete

[93] Fix | Delete

[94] Fix | Delete

INSERT INTO `category_description` VALUES

[95] Fix | Delete

(3, 1, 'Latest', 'Latest Products to be added. These will only be displayed on the Home Page', '', '', ''),

[96] Fix | Delete

(9, 1, 'Motor Bikes', 'Default MotorBikes: These Products Demonstrate some features of our modified search. \r\nYou can search by hidden terms.', '', '', ''),

[97] Fix | Delete

(1, 1, 'All & Products', 'All Products: & Latest, Featured, Specials, Related Products & Default MotorBikes', '', '', ''),

[98] Fix | Delete

(2, 1, 'Featured', 'Featured Products. These will only be displayed on the Home Page. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', '', '', ''),

[99] Fix | Delete

(10, 1, 'Related Products', 'Related Products: These products are items specified by the selected product. \r\nThey are only displayed on Product Page in Right Side bar. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', '', '', ''),

[100] Fix | Delete

(7, 1, 'Specials', 'Products on Special: These products are Special Priced items. \r\nThey are displayed on Home, Category and Product Pages in the Right Side bar. \r\nIf Related Items are available for a product, Specials are not displayed on Product page. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', '', '', ''),

[101] Fix | Delete

(4, 1, 'Specials', 'Products on Special: These products are Special Priced items. \r\nThey are displayed on Home, Category and Product Pages in the Right Side bar. \r\nIf Related Items are available for a product, Specials are not displayed on Product page. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', 'specials, category', 'Category for products on special', 'Products on special'),

[102] Fix | Delete

(5, 1, 'Featured', 'Featured Products. These will only be displayed on the Home Page. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', '', '', ''),

[103] Fix | Delete

(6, 1, 'Latest', 'Latest Products to be added. These will only be displayed on the Home Page', '', '', ''),

[104] Fix | Delete

(8, 1, 'Motor Bikes', 'Default MotorBikes: These Products Demonstrate some features of our modified search. \r\nYou can search by hidden terms.', '', '', ''),

[105] Fix | Delete

(11, 1, 'Related Products', 'Related Products: These products are items specified by the selected product. \r\nThey are only displayed on Product Page in Right Side bar. \r\nYou can select as many items as you want, but only the amount set in admin \r\nwill be display. If the amount is greater than admin limit, the items are randomly \r\nselected.', '', '', '');

[106] Fix | Delete

[107] Fix | Delete

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

[108] Fix | Delete

[109] Fix | Delete

[110] Fix | Delete

-- Table structure for table `country`

[111] Fix | Delete

[112] Fix | Delete

[113] Fix | Delete

CREATE TABLE `country` (

[114] Fix | Delete

`country_id` int(11) NOT NULL AUTO_INCREMENT,

[115] Fix | Delete

`name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[116] Fix | Delete

`country_status` int(1) NOT NULL DEFAULT '0',

[117] Fix | Delete

`iso_code_2` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[118] Fix | Delete

`iso_code_3` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[119] Fix | Delete

`address_format` text COLLATE utf8_unicode_ci NOT NULL,

[120] Fix | Delete

PRIMARY KEY (`country_id`)

[121] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=250 ;

[122] Fix | Delete

[123] Fix | Delete

[124] Fix | Delete

-- Dumping data for table `country`

[125] Fix | Delete

[126] Fix | Delete

[127] Fix | Delete

INSERT INTO `country` VALUES

[128] Fix | Delete

(1, 'Afghanistan', 0, 'AF', 'AFG', ''),

[129] Fix | Delete

(2, 'Albania', 0, 'AL', 'ALB', ''),

[130] Fix | Delete

(3, 'Algeria', 0, 'DZ', 'DZA', ''),

[131] Fix | Delete

(4, 'American Samoa', 0, 'AS', 'ASM', ''),

[132] Fix | Delete

(5, 'Andorra', 0, 'AD', 'AND', ''),

[133] Fix | Delete

(6, 'Angola', 0, 'AO', 'AGO', ''),

[134] Fix | Delete

(7, 'Anguilla', 0, 'AI', 'AIA', ''),

[135] Fix | Delete

(8, 'Antarctica', 0, 'AQ', 'ATA', ''),

[136] Fix | Delete

(9, 'Antigua and Barbuda', 0, 'AG', 'ATG', ''),

[137] Fix | Delete

(10, 'Argentina', 0, 'AR', 'ARG', ''),

[138] Fix | Delete

(11, 'Armenia', 0, 'AM', 'ARM', ''),

[139] Fix | Delete

(12, 'Aruba', 0, 'AW', 'ABW', ''),

[140] Fix | Delete

(13, 'Australia', 0, 'AU', 'AUS', ''),

[141] Fix | Delete

(14, 'Austria', 0, 'AT', 'AUT', ''),

[142] Fix | Delete

(15, 'Azerbaijan', 0, 'AZ', 'AZE', ''),

[143] Fix | Delete

(16, 'Bahamas', 0, 'BS', 'BHS', ''),

[144] Fix | Delete

(17, 'Bahrain', 0, 'BH', 'BHR', ''),

[145] Fix | Delete

(18, 'Bangladesh', 0, 'BD', 'BGD', ''),

[146] Fix | Delete

(19, 'Barbados', 0, 'BB', 'BRB', ''),

[147] Fix | Delete

(20, 'Belarus', 0, 'BY', 'BLR', ''),

[148] Fix | Delete

(21, 'Belgium', 0, 'BE', 'BEL', ''),

[149] Fix | Delete

(22, 'Belize', 0, 'BZ', 'BLZ', ''),

[150] Fix | Delete

(23, 'Benin', 0, 'BJ', 'BEN', ''),

[151] Fix | Delete

(24, 'Bermuda', 0, 'BM', 'BMU', ''),

[152] Fix | Delete

(25, 'Bhutan', 0, 'BT', 'BTN', ''),

[153] Fix | Delete

(26, 'Bolivia', 0, 'BO', 'BOL', ''),

[154] Fix | Delete

(27, 'Bosnia and Herzegowina', 0, 'BA', 'BIH', ''),

[155] Fix | Delete

(28, 'Botswana', 0, 'BW', 'BWA', ''),

[156] Fix | Delete

(29, 'Bouvet Island', 0, 'BV', 'BVT', ''),

[157] Fix | Delete

(30, 'Brazil', 0, 'BR', 'BRA', ''),

[158] Fix | Delete

(31, 'British Indian Ocean Territory', 0, 'IO', 'IOT', ''),

[159] Fix | Delete

(32, 'Brunei Darussalam', 0, 'BN', 'BRN', ''),

[160] Fix | Delete

(33, 'Bulgaria', 0, 'BG', 'BGR', ''),

[161] Fix | Delete

(34, 'Burkina Faso', 0, 'BF', 'BFA', ''),

[162] Fix | Delete

(35, 'Burundi', 0, 'BI', 'BDI', ''),

[163] Fix | Delete

(36, 'Cambodia', 0, 'KH', 'KHM', ''),

[164] Fix | Delete

(37, 'Cameroon', 0, 'CM', 'CMR', ''),

[165] Fix | Delete

(38, 'Canada', 1, 'CA', 'CAN', ''),

[166] Fix | Delete

(39, 'Cape Verde', 0, 'CV', 'CPV', ''),

[167] Fix | Delete

(40, 'Cayman Islands', 0, 'KY', 'CYM', ''),

[168] Fix | Delete

(41, 'Central African Republic', 0, 'CF', 'CAF', ''),

[169] Fix | Delete

(42, 'Chad', 0, 'TD', 'TCD', ''),

[170] Fix | Delete

(43, 'Chile', 0, 'CL', 'CHL', ''),

[171] Fix | Delete

(44, 'China', 0, 'CN', 'CHN', ''),

[172] Fix | Delete

(45, 'Christmas Island', 0, 'CX', 'CXR', ''),

[173] Fix | Delete

(46, 'Cocos (Keeling) Islands', 0, 'CC', 'CCK', ''),

[174] Fix | Delete

(47, 'Colombia', 0, 'CO', 'COL', ''),

[175] Fix | Delete

(48, 'Comoros', 0, 'KM', 'COM', ''),

[176] Fix | Delete

(49, 'Congo', 0, 'CG', 'COG', ''),

[177] Fix | Delete

(50, 'Cook Islands', 0, 'CK', 'COK', ''),

[178] Fix | Delete

(51, 'Costa Rica', 0, 'CR', 'CRI', ''),

[179] Fix | Delete

(52, 'Côte d'Ivoire', 0, 'CI', 'CIV', ''),

[180] Fix | Delete

(53, 'Croatia', 0, 'HR', 'HRV', ''),

[181] Fix | Delete

(54, 'Cuba', 0, 'CU', 'CUB', ''),

[182] Fix | Delete

(55, 'Cyprus', 0, 'CY', 'CYP', ''),

[183] Fix | Delete

(56, 'Czech Republic', 0, 'CZ', 'CZE', ''),

[184] Fix | Delete

(57, 'Denmark', 0, 'DK', 'DNK', ''),

[185] Fix | Delete

(58, 'Djibouti', 0, 'DJ', 'DJI', ''),

[186] Fix | Delete

(59, 'Dominica', 0, 'DM', 'DMA', ''),

[187] Fix | Delete

(60, 'Dominican Republic', 0, 'DO', 'DOM', ''),

[188] Fix | Delete

(61, 'East Timor', 0, 'TP', 'TMP', ''),

[189] Fix | Delete

(62, 'Ecuador', 0, 'EC', 'ECU', ''),

[190] Fix | Delete

(63, 'Egypt', 0, 'EG', 'EGY', ''),

[191] Fix | Delete

(64, 'El Salvador', 0, 'SV', 'SLV', ''),

[192] Fix | Delete

(65, 'Equatorial Guinea', 0, 'GQ', 'GNQ', ''),

[193] Fix | Delete

(66, 'Eritrea', 0, 'ER', 'ERI', ''),

[194] Fix | Delete

(67, 'Estonia', 0, 'EE', 'EST', ''),

[195] Fix | Delete

(68, 'Ethiopia', 0, 'ET', 'ETH', ''),

[196] Fix | Delete

(69, 'Falkland Islands (Malvinas)', 0, 'FK', 'FLK', ''),

[197] Fix | Delete

(70, 'Faroe Islands', 0, 'FO', 'FRO', ''),

[198] Fix | Delete

(71, 'Fiji', 0, 'FJ', 'FJI', ''),

[199] Fix | Delete

(72, 'Finland', 0, 'FI', 'FIN', ''),

[200] Fix | Delete

(73, 'France', 0, 'FR', 'FRA', ''),

[201] Fix | Delete

(74, 'France, Metropolitan', 0, 'FX', 'FXX', ''),

[202] Fix | Delete

(75, 'French Guiana', 0, 'GF', 'GUF', ''),

[203] Fix | Delete

(76, 'French Polynesia', 0, 'PF', 'PYF', ''),

[204] Fix | Delete

(77, 'French Southern Territories', 0, 'TF', 'ATF', ''),

[205] Fix | Delete

(78, 'Gabon', 0, 'GA', 'GAB', ''),

[206] Fix | Delete

(79, 'Gambia', 0, 'GM', 'GMB', ''),

[207] Fix | Delete

(80, 'Georgia', 0, 'GE', 'GEO', ''),

[208] Fix | Delete

(81, 'Germany', 0, 'DE', 'DEU', ''),

[209] Fix | Delete

(82, 'Ghana', 0, 'GH', 'GHA', ''),

[210] Fix | Delete

(83, 'Gibraltar', 0, 'GI', 'GIB', ''),

[211] Fix | Delete

(84, 'Greece', 0, 'GR', 'GRC', ''),

[212] Fix | Delete

(85, 'Greenland', 0, 'GL', 'GRL', ''),

[213] Fix | Delete

(86, 'Grenada', 0, 'GD', 'GRD', ''),

[214] Fix | Delete

(87, 'Guadeloupe', 0, 'GP', 'GLP', ''),

[215] Fix | Delete

(88, 'Guam', 0, 'GU', 'GUM', ''),

[216] Fix | Delete

(89, 'Guatemala', 0, 'GT', 'GTM', ''),

[217] Fix | Delete

(90, 'Guinea', 0, 'GN', 'GIN', ''),

[218] Fix | Delete

(91, 'Guinea-bissau', 0, 'GW', 'GNB', ''),

[219] Fix | Delete

(92, 'Guyana', 0, 'GY', 'GUY', ''),

[220] Fix | Delete

(93, 'Haiti', 0, 'HT', 'HTI', ''),

[221] Fix | Delete

(94, 'Heard and Mc Donald Islands', 0, 'HM', 'HMD', ''),

[222] Fix | Delete

(95, 'Honduras', 0, 'HN', 'HND', ''),

[223] Fix | Delete

(96, 'Hong Kong', 0, 'HK', 'HKG', ''),

[224] Fix | Delete

(97, 'Hungary', 0, 'HU', 'HUN', ''),

[225] Fix | Delete

(98, 'Iceland', 0, 'IS', 'ISL', ''),

[226] Fix | Delete

(99, 'India', 0, 'IN', 'IND', ''),

[227] Fix | Delete

(100, 'Indonesia', 0, 'ID', 'IDN', ''),

[228] Fix | Delete

(101, 'Iran (Islamic Republic of)', 0, 'IR', 'IRN', ''),

[229] Fix | Delete

(102, 'Iraq', 0, 'IQ', 'IRQ', ''),

[230] Fix | Delete

(103, 'Ireland', 0, 'IE', 'IRL', ''),

[231] Fix | Delete

(104, 'Israel', 0, 'IL', 'ISR', ''),

[232] Fix | Delete

(105, 'Italy', 0, 'IT', 'ITA', ''),

[233] Fix | Delete

(106, 'Jamaica', 0, 'JM', 'JAM', ''),

[234] Fix | Delete

(107, 'Japan', 0, 'JP', 'JPN', ''),

[235] Fix | Delete

(108, 'Jordan', 0, 'JO', 'JOR', ''),

[236] Fix | Delete

(109, 'Kazakhstan', 0, 'KZ', 'KAZ', ''),

[237] Fix | Delete

(110, 'Kenya', 0, 'KE', 'KEN', ''),

[238] Fix | Delete

(111, 'Kiribati', 0, 'KI', 'KIR', ''),

[239] Fix | Delete

(112, 'Korea, Democratic People's Republic of', 0, 'KP', 'PRK', ''),

[240] Fix | Delete

(113, 'Korea, Republic of', 0, 'KR', 'KOR', ''),

[241] Fix | Delete

(114, 'Kuwait', 0, 'KW', 'KWT', ''),

[242] Fix | Delete

(115, 'Kyrgyzstan', 0, 'KG', 'KGZ', ''),

[243] Fix | Delete

(116, 'Lao People's Democratic Republic', 0, 'LA', 'LAO', ''),

[244] Fix | Delete

(117, 'Latvia', 0, 'LV', 'LVA', ''),

[245] Fix | Delete

(118, 'Lebanon', 0, 'LB', 'LBN', ''),

[246] Fix | Delete

(119, 'Lesotho', 0, 'LS', 'LSO', ''),

[247] Fix | Delete

(120, 'Liberia', 0, 'LR', 'LBR', ''),

[248] Fix | Delete

(121, 'Libyan Arab Jamahiriya', 0, 'LY', 'LBY', ''),

[249] Fix | Delete

(122, 'Liechtenstein', 0, 'LI', 'LIE', ''),

[250] Fix | Delete

(123, 'Lithuania', 0, 'LT', 'LTU', ''),

[251] Fix | Delete

(124, 'Luxembourg', 0, 'LU', 'LUX', ''),

[252] Fix | Delete

(125, 'Macau', 0, 'MO', 'MAC', ''),

[253] Fix | Delete

(126, 'Macedonia, The Former Yugoslav Republic of', 0, 'MK', 'MKD', ''),

[254] Fix | Delete

(127, 'Madagascar', 0, 'MG', 'MDG', ''),

[255] Fix | Delete

(128, 'Malawi', 0, 'MW', 'MWI', ''),

[256] Fix | Delete

(129, 'Malaysia', 0, 'MY', 'MYS', ''),

[257] Fix | Delete

(130, 'Maldives', 0, 'MV', 'MDV', ''),

[258] Fix | Delete

(131, 'Mali', 0, 'ML', 'MLI', ''),

[259] Fix | Delete

(132, 'Malta', 0, 'MT', 'MLT', ''),

[260] Fix | Delete

(133, 'Marshall Islands', 0, 'MH', 'MHL', ''),

[261] Fix | Delete

(134, 'Martinique', 0, 'MQ', 'MTQ', ''),

[262] Fix | Delete

(135, 'Mauritania', 0, 'MR', 'MRT', ''),

[263] Fix | Delete

(136, 'Mauritius', 0, 'MU', 'MUS', ''),

[264] Fix | Delete

(137, 'Mayotte', 0, 'YT', 'MYT', ''),

[265] Fix | Delete

(138, 'Mexico', 0, 'MX', 'MEX', ''),

[266] Fix | Delete

(139, 'Micronesia, Federated States of', 0, 'FM', 'FSM', ''),

[267] Fix | Delete

(140, 'Moldova, Republic of', 0, 'MD', 'MDA', ''),

[268] Fix | Delete

(141, 'Monaco', 0, 'MC', 'MCO', ''),

[269] Fix | Delete

(142, 'Mongolia', 0, 'MN', 'MNG', ''),

[270] Fix | Delete

(143, 'Montserrat', 0, 'MS', 'MSR', ''),

[271] Fix | Delete

(144, 'Morocco', 0, 'MA', 'MAR', ''),

[272] Fix | Delete

(145, 'Mozambique', 0, 'MZ', 'MOZ', ''),

[273] Fix | Delete

(146, 'Myanmar', 0, 'MM', 'MMR', ''),

[274] Fix | Delete

(147, 'Namibia', 0, 'NA', 'NAM', ''),

[275] Fix | Delete

(148, 'Nauru', 0, 'NR', 'NRU', ''),

[276] Fix | Delete

(149, 'Nepal', 0, 'NP', 'NPL', ''),

[277] Fix | Delete

(150, 'Netherlands', 0, 'NL', 'NLD', ''),

[278] Fix | Delete

(151, 'Netherlands Antilles', 0, 'AN', 'ANT', ''),

[279] Fix | Delete

(152, 'New Caledonia', 0, 'NC', 'NCL', ''),

[280] Fix | Delete

(153, 'New Zealand', 0, 'NZ', 'NZL', ''),

[281] Fix | Delete

(154, 'Nicaragua', 0, 'NI', 'NIC', ''),

[282] Fix | Delete

(155, 'Niger', 0, 'NE', 'NER', ''),

[283] Fix | Delete

(156, 'Nigeria', 0, 'NG', 'NGA', ''),

[284] Fix | Delete

(157, 'Niue', 0, 'NU', 'NIU', ''),

[285] Fix | Delete

(158, 'Norfolk Island', 0, 'NF', 'NFK', ''),

[286] Fix | Delete

(159, 'Northern Mariana Islands', 0, 'MP', 'MNP', ''),

[287] Fix | Delete

(160, 'Norway', 0, 'NO', 'NOR', ''),

[288] Fix | Delete

(161, 'Oman', 0, 'OM', 'OMN', ''),

[289] Fix | Delete

(162, 'Pakistan', 0, 'PK', 'PAK', ''),

[290] Fix | Delete

(163, 'Palau', 0, 'PW', 'PLW', ''),

[291] Fix | Delete

(164, 'Panama', 0, 'PA', 'PAN', ''),

[292] Fix | Delete

(165, 'Papua New Guinea', 0, 'PG', 'PNG', ''),

[293] Fix | Delete

(166, 'Paraguay', 0, 'PY', 'PRY', ''),

[294] Fix | Delete

(167, 'Peru', 0, 'PE', 'PER', ''),

[295] Fix | Delete

(168, 'Philippines', 0, 'PH', 'PHL', ''),

[296] Fix | Delete

(169, 'Pitcairn', 0, 'PN', 'PCN', ''),

[297] Fix | Delete

(170, 'Poland', 0, 'PL', 'POL', ''),

[298] Fix | Delete

(171, 'Portugal', 0, 'PT', 'PRT', ''),

[299] Fix | Delete

(172, 'Puerto Rico', 0, 'PR', 'PRI', ''),

[300] Fix | Delete

(173, 'Qatar', 0, 'QA', 'QAT', ''),

[301] Fix | Delete

(174, 'Reunion', 0, 'RE', 'REU', ''),

[302] Fix | Delete

(175, 'Romania', 0, 'RO', 'ROM', ''),

[303] Fix | Delete

(176, 'Russian Federation', 0, 'RU', 'RUS', ''),

[304] Fix | Delete

(177, 'Rwanda', 0, 'RW', 'RWA', ''),

[305] Fix | Delete

(178, 'Saint Kitts and Nevis', 0, 'KN', 'KNA', ''),

[306] Fix | Delete

(179, 'Saint Lucia', 0, 'LC', 'LCA', ''),

[307] Fix | Delete

(180, 'Saint Vincent and the Grenadines', 0, 'VC', 'VCT', ''),

[308] Fix | Delete

(181, 'Samoa', 0, 'WS', 'WSM', ''),

[309] Fix | Delete

(182, 'San Marino', 0, 'SM', 'SMR', ''),

[310] Fix | Delete

(183, 'Sao Tome and Principe', 0, 'ST', 'STP', ''),

[311] Fix | Delete

(184, 'Saudi Arabia', 0, 'SA', 'SAU', ''),

[312] Fix | Delete

(185, 'Senegal', 0, 'SN', 'SEN', ''),

[313] Fix | Delete

(186, 'Seychelles', 0, 'SC', 'SYC', ''),

[314] Fix | Delete

(187, 'Sierra Leone', 0, 'SL', 'SLE', ''),

[315] Fix | Delete

(188, 'Singapore', 0, 'SG', 'SGP', ''),

[316] Fix | Delete

(189, 'Slovakia (Slovak Republic)', 0, 'SK', 'SVK', ''),

[317] Fix | Delete

(190, 'Slovenia', 0, 'SI', 'SVN', ''),

[318] Fix | Delete

(191, 'Solomon Islands', 0, 'SB', 'SLB', ''),

[319] Fix | Delete

(192, 'Somalia', 0, 'SO', 'SOM', ''),

[320] Fix | Delete

(193, 'South Africa', 0, 'ZA', 'ZAF', ''),

[321] Fix | Delete

(194, 'South Georgia and the South Sandwich Islands', 0, 'GS', 'SGS', ''),

[322] Fix | Delete

(195, 'Spain', 0, 'ES', 'ESP', ''),

[323] Fix | Delete

(196, 'Sri Lanka', 0, 'LK', 'LKA', ''),

[324] Fix | Delete

(197, 'St. Helena', 0, 'SH', 'SHN', ''),

[325] Fix | Delete

(198, 'St. Pierre and Miquelon', 0, 'PM', 'SPM', ''),

[326] Fix | Delete

(199, 'Sudan', 0, 'SD', 'SDN', ''),

[327] Fix | Delete

(200, 'Suriname', 0, 'SR', 'SUR', ''),

[328] Fix | Delete

(201, 'Svalbard and Jan Mayen Islands', 0, 'SJ', 'SJM', ''),

[329] Fix | Delete

(202, 'Swaziland', 0, 'SZ', 'SWZ', ''),

[330] Fix | Delete

(203, 'Sweden', 0, 'SE', 'SWE', ''),

[331] Fix | Delete

(204, 'Switzerland', 0, 'CH', 'CHE', ''),

[332] Fix | Delete

(205, 'Syrian Arab Republic', 0, 'SY', 'SYR', ''),

[333] Fix | Delete

(206, 'Taiwan', 0, 'TW', 'TWN', ''),

[334] Fix | Delete

(207, 'Tajikistan', 0, 'TJ', 'TJK', ''),

[335] Fix | Delete

(208, 'Tanzania, United Republic of', 0, 'TZ', 'TZA', ''),

[336] Fix | Delete

(209, 'Thailand', 0, 'TH', 'THA', ''),

[337] Fix | Delete

(210, 'Togo', 0, 'TG', 'TGO', ''),

[338] Fix | Delete

(211, 'Tokelau', 0, 'TK', 'TKL', ''),

[339] Fix | Delete

(212, 'Tonga', 0, 'TO', 'TON', ''),

[340] Fix | Delete

(213, 'Trinidad and Tobago', 0, 'TT', 'TTO', ''),

[341] Fix | Delete

(214, 'Tunisia', 0, 'TN', 'TUN', ''),

[342] Fix | Delete

(215, 'Turkey', 0, 'TR', 'TUR', ''),

[343] Fix | Delete

(216, 'Turkmenistan', 0, 'TM', 'TKM', ''),

[344] Fix | Delete

(217, 'Turks and Caicos Islands', 0, 'TC', 'TCA', ''),

[345] Fix | Delete

(218, 'Tuvalu', 0, 'TV', 'TUV', ''),

[346] Fix | Delete

(219, 'Uganda', 0, 'UG', 'UGA', ''),

[347] Fix | Delete

(220, 'Ukraine', 0, 'UA', 'UKR', ''),

[348] Fix | Delete

(221, 'United Arab Emirates', 0, 'AE', 'ARE', ''),

[349] Fix | Delete

(222, 'United Kingdom', 0, 'GB', 'GBR', ''),

[350] Fix | Delete

(223, 'United States', 1, 'US', 'USA', ''),

[351] Fix | Delete

(224, 'United States Minor Outlying Islands', 0, 'UM', 'UMI', ''),

[352] Fix | Delete

(225, 'Uruguay', 0, 'UY', 'URY', ''),

[353] Fix | Delete

(226, 'Uzbekistan', 0, 'UZ', 'UZB', ''),

[354] Fix | Delete

(227, 'Vanuatu', 0, 'VU', 'VUT', ''),

[355] Fix | Delete

(228, 'Vatican City State (Holy See)', 0, 'VA', 'VAT', ''),

[356] Fix | Delete

(229, 'Venezuela', 0, 'VE', 'VEN', ''),

[357] Fix | Delete

(230, 'Viet Nam', 0, 'VN', 'VNM', ''),

[358] Fix | Delete

(231, 'Virgin Islands (British)', 0, 'VG', 'VGB', ''),

[359] Fix | Delete

(232, 'Virgin Islands (U.S.)', 0, 'VI', 'VIR', ''),

[360] Fix | Delete

(233, 'Wallis and Futuna Islands', 0, 'WF', 'WLF', ''),

[361] Fix | Delete

(234, 'Western Sahara', 0, 'EH', 'ESH', ''),

[362] Fix | Delete

(235, 'Yemen', 0, 'YE', 'YEM', ''),

[363] Fix | Delete

(236, 'Yugoslavia', 0, 'YU', 'YUG', ''),

[364] Fix | Delete

(237, 'Congo, Democratic Republic of (was Zaire)', 0, 'CD', 'COD', ''),

[365] Fix | Delete

(238, 'Zambia', 0, 'ZM', 'ZMB', ''),

[366] Fix | Delete

(239, 'Zimbabwe', 0, 'ZW', 'ZWE', ''),

[367] Fix | Delete

(240, 'Aaland Islands', 0, 'AX', 'ALA', ''),

[368] Fix | Delete

(241, 'Guernsey', 0, 'GG', 'GGY', ''),

[369] Fix | Delete

(242, 'Isle of Man', 0, 'IM', 'IMN', ''),

[370] Fix | Delete

(243, 'Jersey', 0, 'JE', 'JEY', ''),

[371] Fix | Delete

(244, 'Montenegro', 0, 'ME', 'MNE', ''),

[372] Fix | Delete

(245, 'Palestinian Territory, occupied', 0, 'PS', 'PSE', ''),

[373] Fix | Delete

(246, 'Serbia', 0, 'RS', 'SRB', ''),

[374] Fix | Delete

(247, 'St. Barthelemy', 0, 'BL', 'BLM', ''),

[375] Fix | Delete

(248, 'St. Martin (french part)', 0, 'MF', 'MAF', ''),

[376] Fix | Delete

(249, 'Timor-Leste', 0, 'TL', 'TLS', '');

[377] Fix | Delete

[378] Fix | Delete

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

[379] Fix | Delete

[380] Fix | Delete

[381] Fix | Delete

-- Table structure for table `coupon`

[382] Fix | Delete

[383] Fix | Delete

[384] Fix | Delete

CREATE TABLE `coupon` (

[385] Fix | Delete

`coupon_id` int(11) NOT NULL AUTO_INCREMENT,

[386] Fix | Delete

`code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,

[387] Fix | Delete

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

[388] Fix | Delete

`prefix` varchar(1) COLLATE utf8_unicode_ci NOT NULL,

[389] Fix | Delete

`minimum_order` decimal(15,4) NOT NULL DEFAULT '0.0000',

[390] Fix | Delete

`shipping` int(1) NOT NULL,

[391] Fix | Delete

`date_start` datetime NOT NULL,

[392] Fix | Delete

`date_end` datetime NOT NULL,

[393] Fix | Delete

`uses_total` int(11) NOT NULL,

[394] Fix | Delete

`uses_customer` varchar(11) COLLATE utf8_unicode_ci NOT NULL,

[395] Fix | Delete

`status` int(1) NOT NULL,

[396] Fix | Delete

`date_added` datetime NOT NULL,

[397] Fix | Delete

PRIMARY KEY (`coupon_id`)

[398] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

[399] Fix | Delete

[400] Fix | Delete

[401] Fix | Delete

-- Dumping data for table `coupon`

[402] Fix | Delete

[403] Fix | Delete

[404] Fix | Delete

INSERT INTO `coupon` VALUES

[405] Fix | Delete

(1, '1234', 10.0000, '-', 0.0000, 1, '2007-01-01 00:00:00', '2008-01-01 00:00:00', 1000, '1000', 1, '2007-08-23 17:38:27');

[406] Fix | Delete

[407] Fix | Delete

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

[408] Fix | Delete

[409] Fix | Delete

[410] Fix | Delete

-- Table structure for table `coupon_description`

[411] Fix | Delete

[412] Fix | Delete

[413] Fix | Delete

CREATE TABLE `coupon_description` (

[414] Fix | Delete

`coupon_id` int(11) NOT NULL,

[415] Fix | Delete

`language_id` int(11) NOT NULL,

[416] Fix | Delete

`name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,

[417] Fix | Delete

`description` text COLLATE utf8_unicode_ci NOT NULL,

[418] Fix | Delete

PRIMARY KEY (`coupon_id`,`language_id`)

[419] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[420] Fix | Delete

[421] Fix | Delete

[422] Fix | Delete

-- Dumping data for table `coupon_description`

[423] Fix | Delete

[424] Fix | Delete

[425] Fix | Delete

INSERT INTO `coupon_description` VALUES

[426] Fix | Delete

(1, 1, 'Coupon (-10%)', '10% Discount to all customer with special offer coupon code.');

[427] Fix | Delete

[428] Fix | Delete

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

[429] Fix | Delete

[430] Fix | Delete

[431] Fix | Delete

-- Table structure for table `coupon_product`

[432] Fix | Delete

[433] Fix | Delete

[434] Fix | Delete

CREATE TABLE `coupon_product` (

[435] Fix | Delete

`coupon_id` int(11) NOT NULL,

[436] Fix | Delete

`product_id` int(11) NOT NULL,

[437] Fix | Delete

PRIMARY KEY (`coupon_id`,`product_id`)

[438] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[439] Fix | Delete

[440] Fix | Delete

[441] Fix | Delete

-- Dumping data for table `coupon_product`

[442] Fix | Delete

[443] Fix | Delete

[444] Fix | Delete

INSERT INTO `coupon_product` VALUES

[445] Fix | Delete

(1, 1),

[446] Fix | Delete

(1, 2),

[447] Fix | Delete

(1, 3),

[448] Fix | Delete

(1, 4);

[449] Fix | Delete

[450] Fix | Delete

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

[451] Fix | Delete

[452] Fix | Delete

[453] Fix | Delete

-- Table structure for table `coupon_redeem`

[454] Fix | Delete

[455] Fix | Delete

[456] Fix | Delete

CREATE TABLE `coupon_redeem` (

[457] Fix | Delete

`coupon_redeem_id` int(11) NOT NULL AUTO_INCREMENT,

[458] Fix | Delete

`customer_id` int(11) NOT NULL,

[459] Fix | Delete

`order_id` int(11) NOT NULL,

[460] Fix | Delete

`date_added` datetime NOT NULL,

[461] Fix | Delete

`coupon_id` int(11) NOT NULL,

[462] Fix | Delete

PRIMARY KEY (`coupon_redeem_id`)

[463] Fix | Delete

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

[464] Fix | Delete

[465] Fix | Delete

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

[466] Fix | Delete

[467] Fix | Delete

[468] Fix | Delete

-- Table structure for table `currency`

[469] Fix | Delete

[470] Fix | Delete

[471] Fix | Delete

CREATE TABLE `currency` (

[472] Fix | Delete

`currency_id` int(11) NOT NULL AUTO_INCREMENT,

[473] Fix | Delete

`title` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[474] Fix | Delete

`code` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',

[475] Fix | Delete

`status` int(1) NOT NULL DEFAULT '1',

[476] Fix | Delete

`lock_rate` int(1) NOT NULL DEFAULT '0',

[477] Fix | Delete

`symbol_left` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,

[478] Fix | Delete

`symbol_right` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,

[479] Fix | Delete

`decimal_place` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,

[480] Fix | Delete

`value` double(13,8) DEFAULT NULL,

[481] Fix | Delete

`date_modified` datetime DEFAULT NULL,

[482] Fix | Delete

PRIMARY KEY (`currency_id`)

[483] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=95 ;

[484] Fix | Delete

[485] Fix | Delete

[486] Fix | Delete

-- Dumping data for table `currency`

[487] Fix | Delete

[488] Fix | Delete

[489] Fix | Delete

INSERT INTO `currency` VALUES

[490] Fix | Delete

(1, 'Canadian Dollar', 'CAD', 1, 0, '$', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[491] Fix | Delete

(2, 'United States Dollar', 'USD', 1, 0, '$', '', '2', 1.00000000, '2009-10-11 14:44:23'),

[492] Fix | Delete

(3, 'British Pound', 'GBP', 1, 0, '£', '', '2', 1.00000000, '2009-10-11 10:36:51'),

[493] Fix | Delete

(4, 'Euro', 'EUR', 1, 0, '', '€', '2', 1.00000000, '2008-12-17 20:46:47'),

[494] Fix | Delete

(5, 'Australian Dollar', 'AUD', 1, 0, '$', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[495] Fix | Delete

(6, 'United Arab Emirates Dirham', 'AED', 0, 0, '', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[496] Fix | Delete

(7, 'Netherlands Antillean Guilder', 'ANG', 0, 0, 'ƒ', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[497] Fix | Delete

(8, 'Argentine Peso', 'ARS', 0, 0, '$', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[498] Fix | Delete

(9, 'Bangladeshi Taka', 'BDT', 0, 0, '', '', '2', 1.00000000, '2008-12-17 20:46:47'),

[499] Fix | Delete

12 3 4 5 6 ...13