Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 491ca91e5c
Fetching contributors…

Cannot retrieve contributors at this time

5775 lines (5475 sloc) 211.635 kb
-- phpMyAdmin SQL Dump
-- version 3.1.5
-- http://www.phpmyadmin.net
--
-- Host: mysql1052.servage.net
-- Generation Time: Jan 14, 2011 at 07:22 PM
-- Server version: 5.0.85
-- PHP Version: 5.2.42-servage15
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `uru-oc`
--
CREATE DATABASE `uru-oc` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `uru-oc`;
-- --------------------------------------------------------
--
-- Table structure for table `address`
--
CREATE TABLE IF NOT EXISTS `address` (
`address_id` int(11) NOT NULL auto_increment,
`customer_id` int(11) NOT NULL,
`company` varchar(32) collate utf8_bin NOT NULL,
`firstname` varchar(32) collate utf8_bin NOT NULL default '',
`lastname` varchar(32) collate utf8_bin NOT NULL default '',
`address_1` varchar(128) collate utf8_bin NOT NULL,
`address_2` varchar(128) collate utf8_bin NOT NULL,
`postcode` varchar(10) collate utf8_bin NOT NULL default '',
`city` varchar(128) collate utf8_bin NOT NULL,
`country_id` int(11) NOT NULL default '0',
`zone_id` int(11) NOT NULL default '0',
PRIMARY KEY (`address_id`),
KEY `customer_id` (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `address`
--
INSERT INTO `address` (`address_id`, `customer_id`, `company`, `firstname`, `lastname`, `address_1`, `address_2`, `postcode`, `city`, `country_id`, `zone_id`) VALUES
(1, 1, 'Konscript', 'Søren', 'Louv-Jansen', 'Sølvgade 95', '', '2323', 'København', 57, 904);
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE IF NOT EXISTS `category` (
`category_id` int(11) NOT NULL auto_increment,
`image` varchar(255) collate utf8_bin default NULL,
`parent_id` int(11) NOT NULL default '0',
`sort_order` int(3) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`status` int(1) NOT NULL default '1',
PRIMARY KEY (`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=39 ;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`category_id`, `image`, `parent_id`, `sort_order`, `date_added`, `date_modified`, `status`) VALUES
(37, '', 0, 0, '2011-01-12 13:47:44', '2011-01-12 13:47:44', 1),
(38, '', 0, 0, '2011-01-12 13:48:00', '2011-01-12 13:48:00', 1),
(36, '', 0, 0, '2011-01-12 13:47:19', '2011-01-12 13:47:27', 1),
(35, '', 0, 0, '2011-01-12 13:46:56', '2011-01-12 13:46:56', 1);
-- --------------------------------------------------------
--
-- Table structure for table `category_description`
--
CREATE TABLE IF NOT EXISTS `category_description` (
`category_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_bin NOT NULL default '',
`meta_keywords` varchar(255) collate utf8_bin NOT NULL,
`meta_description` varchar(255) collate utf8_bin NOT NULL,
`description` text collate utf8_bin NOT NULL,
PRIMARY KEY (`category_id`,`language_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `category_description`
--
INSERT INTO `category_description` (`category_id`, `language_id`, `name`, `meta_keywords`, `meta_description`, `description`) VALUES
(35, 1, 'Bracelets', '', '', ''),
(36, 1, 'Cufflinks & Rings', '', '', ''),
(37, 1, 'Necklace & Pendants', '', '', ''),
(38, 1, 'URU Master Pieces', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `category_to_store`
--
CREATE TABLE IF NOT EXISTS `category_to_store` (
`category_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
PRIMARY KEY (`category_id`,`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `category_to_store`
--
INSERT INTO `category_to_store` (`category_id`, `store_id`) VALUES
(35, 0),
(36, 0),
(37, 0),
(38, 0);
-- --------------------------------------------------------
--
-- Table structure for table `country`
--
CREATE TABLE IF NOT EXISTS `country` (
`country_id` int(11) NOT NULL auto_increment,
`name` varchar(128) collate utf8_bin NOT NULL,
`iso_code_2` varchar(2) collate utf8_bin NOT NULL default '',
`iso_code_3` varchar(3) collate utf8_bin NOT NULL default '',
`address_format` text collate utf8_bin NOT NULL,
`postcode_required` int(1) NOT NULL default '0',
`status` int(1) NOT NULL default '1',
PRIMARY KEY (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=240 ;
--
-- Dumping data for table `country`
--
INSERT INTO `country` (`country_id`, `name`, `iso_code_2`, `iso_code_3`, `address_format`, `postcode_required`, `status`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', '', 1, 1),
(2, 'Albania', 'AL', 'ALB', '', 0, 1),
(3, 'Algeria', 'DZ', 'DZA', '', 1, 1),
(4, 'American Samoa', 'AS', 'ASM', '', 0, 1),
(5, 'Andorra', 'AD', 'AND', '', 0, 1),
(6, 'Angola', 'AO', 'AGO', '', 0, 1),
(7, 'Anguilla', 'AI', 'AIA', '', 0, 1),
(8, 'Antarctica', 'AQ', 'ATA', '', 1, 1),
(9, 'Antigua and Barbuda', 'AG', 'ATG', '', 0, 1),
(10, 'Argentina', 'AR', 'ARG', '', 1, 1),
(11, 'Armenia', 'AM', 'ARM', '', 1, 1),
(12, 'Aruba', 'AW', 'ABW', '', 0, 1),
(13, 'Australia', 'AU', 'AUS', '', 1, 1),
(14, 'Austria', 'AT', 'AUT', '', 1, 1),
(15, 'Azerbaijan', 'AZ', 'AZE', '', 1, 1),
(16, 'Bahamas', 'BS', 'BHS', '', 0, 1),
(17, 'Bahrain', 'BH', 'BHR', '', 0, 1),
(18, 'Bangladesh', 'BD', 'BGD', '', 1, 1),
(19, 'Barbados', 'BB', 'BRB', '', 0, 1),
(20, 'Belarus', 'BY', 'BLR', '', 1, 1),
(21, 'Belgium', 'BE', 'BEL', '', 1, 1),
(22, 'Belize', 'BZ', 'BLZ', '', 0, 1),
(23, 'Benin', 'BJ', 'BEN', '', 0, 1),
(24, 'Bermuda', 'BM', 'BMU', '', 0, 1),
(25, 'Bhutan', 'BT', 'BTN', '', 0, 1),
(26, 'Bolivia', 'BO', 'BOL', '', 0, 1),
(27, 'Bosnia and Herzegowina', 'BA', 'BIH', '', 1, 1),
(28, 'Botswana', 'BW', 'BWA', '', 0, 1),
(29, 'Bouvet Island', 'BV', 'BVT', '', 1, 1),
(30, 'Brazil', 'BR', 'BRA', '', 1, 1),
(31, 'British Indian Ocean Territory', 'IO', 'IOT', '', 1, 1),
(32, 'Brunei Darussalam', 'BN', 'BRN', '', 0, 1),
(33, 'Bulgaria', 'BG', 'BGR', '', 1, 1),
(34, 'Burkina Faso', 'BF', 'BFA', '', 0, 1),
(35, 'Burundi', 'BI', 'BDI', '', 0, 1),
(36, 'Cambodia', 'KH', 'KHM', '', 0, 1),
(37, 'Cameroon', 'CM', 'CMR', '', 0, 1),
(38, 'Canada', 'CA', 'CAN', '', 1, 1),
(39, 'Cape Verde', 'CV', 'CPV', '', 0, 1),
(40, 'Cayman Islands', 'KY', 'CYM', '', 0, 1),
(41, 'Central African Republic', 'CF', 'CAF', '', 0, 1),
(42, 'Chad', 'TD', 'TCD', '', 0, 1),
(43, 'Chile', 'CL', 'CHL', '', 0, 1),
(44, 'China', 'CN', 'CHN', '', 1, 1),
(45, 'Christmas Island', 'CX', 'CXR', '', 1, 1),
(46, 'Cocos (Keeling) Islands', 'CC', 'CCK', '', 1, 1),
(47, 'Colombia', 'CO', 'COL', '', 0, 1),
(48, 'Comoros', 'KM', 'COM', '', 1, 1),
(49, 'Congo', 'CG', 'COG', '', 0, 1),
(50, 'Cook Islands', 'CK', 'COK', '', 0, 1),
(51, 'Costa Rica', 'CR', 'CRI', '', 0, 1),
(52, 'Cote D''Ivoire', 'CI', 'CIV', '', 1, 1),
(53, 'Croatia', 'HR', 'HRV', '', 1, 1),
(54, 'Cuba', 'CU', 'CUB', '', 1, 1),
(55, 'Cyprus', 'CY', 'CYP', '', 1, 1),
(56, 'Czech Republic', 'CZ', 'CZE', '', 1, 1),
(57, 'Denmark', 'DK', 'DNK', '', 1, 1),
(58, 'Djibouti', 'DJ', 'DJI', '', 0, 1),
(59, 'Dominica', 'DM', 'DMA', '', 0, 1),
(60, 'Dominican Republic', 'DO', 'DOM', '', 0, 1),
(61, 'East Timor', 'TP', 'TMP', '', 1, 1),
(62, 'Ecuador', 'EC', 'ECU', '', 0, 1),
(63, 'Egypt', 'EG', 'EGY', '', 0, 1),
(64, 'El Salvador', 'SV', 'SLV', '', 0, 1),
(65, 'Equatorial Guinea', 'GQ', 'GNQ', '', 0, 1),
(66, 'Eritrea', 'ER', 'ERI', '', 0, 1),
(67, 'Estonia', 'EE', 'EST', '', 1, 1),
(68, 'Ethiopia', 'ET', 'ETH', '', 0, 1),
(69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', '', 1, 1),
(70, 'Faroe Islands', 'FO', 'FRO', '', 1, 1),
(71, 'Fiji', 'FJ', 'FJI', '', 0, 1),
(72, 'Finland', 'FI', 'FIN', '', 1, 1),
(73, 'France', 'FR', 'FRA', '', 1, 1),
(74, 'France, Metropolitan', 'FX', 'FXX', '', 1, 1),
(75, 'French Guiana', 'GF', 'GUF', '', 0, 1),
(76, 'French Polynesia', 'PF', 'PYF', '', 0, 1),
(77, 'French Southern Territories', 'TF', 'ATF', '', 1, 1),
(78, 'Gabon', 'GA', 'GAB', '', 0, 1),
(79, 'Gambia', 'GM', 'GMB', '', 0, 1),
(80, 'Georgia', 'GE', 'GEO', '', 1, 1),
(81, 'Germany', 'DE', 'DEU', '', 1, 1),
(82, 'Ghana', 'GH', 'GHA', '', 0, 1),
(83, 'Gibraltar', 'GI', 'GIB', '', 0, 1),
(84, 'Greece', 'GR', 'GRC', '', 1, 1),
(85, 'Greenland', 'GL', 'GRL', '', 1, 1),
(86, 'Grenada', 'GD', 'GRD', '', 0, 1),
(87, 'Guadeloupe', 'GP', 'GLP', '', 0, 1),
(88, 'Guam', 'GU', 'GUM', '', 0, 1),
(89, 'Guatemala', 'GT', 'GTM', '', 0, 1),
(90, 'Guinea', 'GN', 'GIN', '', 0, 1),
(91, 'Guinea-bissau', 'GW', 'GNB', '', 0, 1),
(92, 'Guyana', 'GY', 'GUY', '', 0, 1),
(93, 'Haiti', 'HT', 'HTI', '', 0, 1),
(94, 'Heard and Mc Donald Islands', 'HM', 'HMD', '', 1, 1),
(95, 'Honduras', 'HN', 'HND', '', 0, 1),
(96, 'Hong Kong', 'HK', 'HKG', '', 0, 1),
(97, 'Hungary', 'HU', 'HUN', '', 1, 1),
(98, 'Iceland', 'IS', 'ISL', '', 1, 1),
(99, 'India', 'IN', 'IND', '', 1, 1),
(100, 'Indonesia', 'ID', 'IDN', '', 1, 1),
(101, 'Iran (Islamic Republic of)', 'IR', 'IRN', '', 1, 1),
(102, 'Iraq', 'IQ', 'IRQ', '', 0, 1),
(103, 'Ireland', 'IE', 'IRL', '', 0, 1),
(104, 'Israel', 'IL', 'ISR', '', 1, 1),
(105, 'Italy', 'IT', 'ITA', '', 1, 1),
(106, 'Jamaica', 'JM', 'JAM', '', 0, 1),
(107, 'Japan', 'JP', 'JPN', '', 1, 1),
(108, 'Jordan', 'JO', 'JOR', '', 0, 1),
(109, 'Kazakhstan', 'KZ', 'KAZ', '', 1, 1),
(110, 'Kenya', 'KE', 'KEN', '', 0, 1),
(111, 'Kiribati', 'KI', 'KIR', '', 0, 1),
(112, 'North Korea', 'KP', 'PRK', '', 1, 1),
(113, 'Korea, Republic of', 'KR', 'KOR', '', 1, 1),
(114, 'Kuwait', 'KW', 'KWT', '', 0, 1),
(115, 'Kyrgyzstan', 'KG', 'KGZ', '', 1, 1),
(116, 'Lao People''s Democratic Republic', 'LA', 'LAO', '', 0, 1),
(117, 'Latvia', 'LV', 'LVA', '', 1, 1),
(118, 'Lebanon', 'LB', 'LBN', '', 0, 1),
(119, 'Lesotho', 'LS', 'LSO', '', 0, 1),
(120, 'Liberia', 'LR', 'LBR', '', 0, 1),
(121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', '', 1, 1),
(122, 'Liechtenstein', 'LI', 'LIE', '', 1, 1),
(123, 'Lithuania', 'LT', 'LTU', '', 1, 1),
(124, 'Luxembourg', 'LU', 'LUX', '', 1, 1),
(125, 'Macau', 'MO', 'MAC', '', 0, 1),
(126, 'Macedonia', 'MK', 'MKD', '', 1, 1),
(127, 'Madagascar', 'MG', 'MDG', '', 0, 1),
(128, 'Malawi', 'MW', 'MWI', '', 1, 1),
(129, 'Malaysia', 'MY', 'MYS', '', 1, 1),
(130, 'Maldives', 'MV', 'MDV', '', 0, 1),
(131, 'Mali', 'ML', 'MLI', '', 0, 1),
(132, 'Malta', 'MT', 'MLT', '', 0, 1),
(133, 'Marshall Islands', 'MH', 'MHL', '', 1, 1),
(134, 'Martinique', 'MQ', 'MTQ', '', 1, 1),
(135, 'Mauritania', 'MR', 'MRT', '', 0, 1),
(136, 'Mauritius', 'MU', 'MUS', '', 0, 1),
(137, 'Mayotte', 'YT', 'MYT', '', 1, 1),
(138, 'Mexico', 'MX', 'MEX', '', 1, 1),
(139, 'Micronesia, Federated States of', 'FM', 'FSM', '', 1, 1),
(140, 'Moldova, Republic of', 'MD', 'MDA', '', 1, 1),
(141, 'Monaco', 'MC', 'MCO', '', 1, 1),
(142, 'Mongolia', 'MN', 'MNG', '', 1, 1),
(143, 'Montserrat', 'MS', 'MSR', '', 0, 1),
(144, 'Morocco', 'MA', 'MAR', '', 0, 1),
(145, 'Mozambique', 'MZ', 'MOZ', '', 0, 1),
(146, 'Myanmar', 'MM', 'MMR', '', 1, 1),
(147, 'Namibia', 'NA', 'NAM', '', 0, 1),
(148, 'Nauru', 'NR', 'NRU', '', 1, 1),
(149, 'Nepal', 'NP', 'NPL', '', 0, 1),
(150, 'Netherlands', 'NL', 'NLD', '', 1, 1),
(151, 'Netherlands Antilles', 'AN', 'ANT', '', 0, 1),
(152, 'New Caledonia', 'NC', 'NCL', '', 0, 1),
(153, 'New Zealand', 'NZ', 'NZL', '', 1, 1),
(154, 'Nicaragua', 'NI', 'NIC', '', 0, 1),
(155, 'Niger', 'NE', 'NER', '', 0, 1),
(156, 'Nigeria', 'NG', 'NGA', '', 0, 1),
(157, 'Niue', 'NU', 'NIU', '', 1, 1),
(158, 'Norfolk Island', 'NF', 'NFK', '', 0, 1),
(159, 'Northern Mariana Islands', 'MP', 'MNP', '', 0, 1),
(160, 'Norway', 'NO', 'NOR', '', 1, 1),
(161, 'Oman', 'OM', 'OMN', '', 0, 1),
(162, 'Pakistan', 'PK', 'PAK', '', 1, 1),
(163, 'Palau', 'PW', 'PLW', '', 1, 1),
(164, 'Panama', 'PA', 'PAN', '', 0, 1),
(165, 'Papua New Guinea', 'PG', 'PNG', '', 0, 1),
(166, 'Paraguay', 'PY', 'PRY', '', 0, 1),
(167, 'Peru', 'PE', 'PER', '', 0, 1),
(168, 'Philippines', 'PH', 'PHL', '', 1, 1),
(169, 'Pitcairn', 'PN', 'PCN', '', 1, 1),
(170, 'Poland', 'PL', 'POL', '', 1, 1),
(171, 'Portugal', 'PT', 'PRT', '', 1, 1),
(172, 'Puerto Rico', 'PR', 'PRI', '', 1, 1),
(173, 'Qatar', 'QA', 'QAT', '', 0, 1),
(174, 'Reunion', 'RE', 'REU', '', 1, 1),
(175, 'Romania', 'RO', 'ROM', '', 1, 1),
(176, 'Russian Federation', 'RU', 'RUS', '', 1, 1),
(177, 'Rwanda', 'RW', 'RWA', '', 0, 1),
(178, 'Saint Kitts and Nevis', 'KN', 'KNA', '', 1, 1),
(179, 'Saint Lucia', 'LC', 'LCA', '', 1, 1),
(180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', '', 1, 1),
(181, 'Samoa', 'WS', 'WSM', '', 1, 1),
(182, 'San Marino', 'SM', 'SMR', '', 1, 1),
(183, 'Sao Tome and Principe', 'ST', 'STP', '', 1, 1),
(184, 'Saudi Arabia', 'SA', 'SAU', '', 1, 1),
(185, 'Senegal', 'SN', 'SEN', '', 0, 1),
(186, 'Seychelles', 'SC', 'SYC', '', 0, 1),
(187, 'Sierra Leone', 'SL', 'SLE', '', 0, 1),
(188, 'Singapore', 'SG', 'SGP', '', 1, 1),
(189, 'Slovak Republic', 'SK', 'SVK', '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}', 1, 1),
(190, 'Slovenia', 'SI', 'SVN', '', 1, 1),
(191, 'Solomon Islands', 'SB', 'SLB', '', 0, 1),
(192, 'Somalia', 'SO', 'SOM', '', 1, 1),
(193, 'South Africa', 'ZA', 'ZAF', '', 1, 1),
(194, 'South Georgia & South Sandwich Islands', 'GS', 'SGS', '', 1, 1),
(195, 'Spain', 'ES', 'ESP', '', 1, 1),
(196, 'Sri Lanka', 'LK', 'LKA', '', 1, 1),
(197, 'St. Helena', 'SH', 'SHN', '', 1, 1),
(198, 'St. Pierre and Miquelon', 'PM', 'SPM', '', 1, 1),
(199, 'Sudan', 'SD', 'SDN', '', 1, 1),
(200, 'Suriname', 'SR', 'SUR', '', 0, 1),
(201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', '', 1, 1),
(202, 'Swaziland', 'SZ', 'SWZ', '', 0, 1),
(203, 'Sweden', 'SE', 'SWE', '', 1, 1),
(204, 'Switzerland', 'CH', 'CHE', '', 1, 1),
(205, 'Syrian Arab Republic', 'SY', 'SYR', '', 0, 1),
(206, 'Taiwan', 'TW', 'TWN', '', 1, 1),
(207, 'Tajikistan', 'TJ', 'TJK', '', 1, 1),
(208, 'Tanzania, United Republic of', 'TZ', 'TZA', '', 0, 1),
(209, 'Thailand', 'TH', 'THA', '', 1, 1),
(210, 'Togo', 'TG', 'TGO', '', 0, 1),
(211, 'Tokelau', 'TK', 'TKL', '', 1, 1),
(212, 'Tonga', 'TO', 'TON', '', 0, 1),
(213, 'Trinidad and Tobago', 'TT', 'TTO', '', 0, 1),
(214, 'Tunisia', 'TN', 'TUN', '', 0, 1),
(215, 'Turkey', 'TR', 'TUR', '', 1, 1),
(216, 'Turkmenistan', 'TM', 'TKM', '', 1, 1),
(217, 'Turks and Caicos Islands', 'TC', 'TCA', '', 0, 1),
(218, 'Tuvalu', 'TV', 'TUV', '', 0, 1),
(219, 'Uganda', 'UG', 'UGA', '', 0, 1),
(220, 'Ukraine', 'UA', 'UKR', '', 1, 1),
(221, 'United Arab Emirates', 'AE', 'ARE', '', 0, 1),
(222, 'United Kingdom', 'GB', 'GBR', '', 1, 1),
(223, 'United States', 'US', 'USA', '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}', 1, 1),
(224, 'United States Minor Outlying Islands', 'UM', 'UMI', '', 1, 1),
(225, 'Uruguay', 'UY', 'URY', '', 1, 1),
(226, 'Uzbekistan', 'UZ', 'UZB', '', 1, 1),
(227, 'Vanuatu', 'VU', 'VUT', '', 0, 1),
(228, 'Vatican City State (Holy See)', 'VA', 'VAT', '', 1, 1),
(229, 'Venezuela', 'VE', 'VEN', '', 0, 1),
(230, 'Viet Nam', 'VN', 'VNM', '', 1, 1),
(231, 'Virgin Islands (British)', 'VG', 'VGB', '', 0, 1),
(232, 'Virgin Islands (U.S.)', 'VI', 'VIR', '', 1, 1),
(233, 'Wallis and Futuna Islands', 'WF', 'WLF', '', 0, 1),
(234, 'Western Sahara', 'EH', 'ESH', '', 1, 1),
(235, 'Yemen', 'YE', 'YEM', '', 0, 1),
(236, 'Yugoslavia', 'YU', 'YUG', '', 1, 1),
(237, 'Democratic Republic of Congo', 'CD', 'COD', '', 1, 1),
(238, 'Zambia', 'ZM', 'ZMB', '', 0, 1),
(239, 'Zimbabwe', 'ZW', 'ZWE', '', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `coupon`
--
CREATE TABLE IF NOT EXISTS `coupon` (
`coupon_id` int(11) NOT NULL auto_increment,
`code` varchar(10) collate utf8_bin NOT NULL,
`type` char(1) collate utf8_bin NOT NULL,
`discount` decimal(15,4) NOT NULL,
`logged` int(1) NOT NULL,
`shipping` int(1) NOT NULL,
`total` decimal(15,4) NOT NULL,
`date_start` date NOT NULL default '0000-00-00',
`date_end` date NOT NULL default '0000-00-00',
`uses_total` int(11) NOT NULL,
`uses_customer` varchar(11) collate utf8_bin NOT NULL,
`status` int(1) NOT NULL,
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
--
-- Dumping data for table `coupon`
--
INSERT INTO `coupon` (`coupon_id`, `code`, `type`, `discount`, `logged`, `shipping`, `total`, `date_start`, `date_end`, `uses_total`, `uses_customer`, `status`, `date_added`) VALUES
(4, '2222', 'P', '10.0000', 0, 0, '0.0000', '2009-01-27', '2010-03-06', 10, '10', 1, '2009-01-27 13:55:03'),
(5, '3333', 'P', '0.0000', 0, 1, '100.0000', '2009-03-01', '2009-08-31', 10, '10', 1, '2009-03-14 21:13:53'),
(6, '1111', 'P', '10.0000', 0, 0, '10.0000', '2007-01-01', '2011-03-01', 10, '10', 1, '2009-03-14 21:15:18');
-- --------------------------------------------------------
--
-- Table structure for table `coupon_description`
--
CREATE TABLE IF NOT EXISTS `coupon_description` (
`coupon_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(128) collate utf8_bin NOT NULL,
`description` text collate utf8_bin NOT NULL,
PRIMARY KEY (`coupon_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `coupon_description`
--
INSERT INTO `coupon_description` (`coupon_id`, `language_id`, `name`, `description`) VALUES
(4, 1, 'Coupon (-10%)', '10% Discount'),
(5, 1, 'Coupon (Free Shipping)', 'Free Shipping'),
(6, 1, 'Coupon (-10.00)', 'Fixed Amount Discount');
-- --------------------------------------------------------
--
-- Table structure for table `coupon_product`
--
CREATE TABLE IF NOT EXISTS `coupon_product` (
`coupon_product_id` int(11) NOT NULL auto_increment,
`coupon_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
PRIMARY KEY (`coupon_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=9 ;
--
-- Dumping data for table `coupon_product`
--
INSERT INTO `coupon_product` (`coupon_product_id`, `coupon_id`, `product_id`) VALUES
(4, 7, 47),
(3, 7, 30),
(8, 6, 48);
-- --------------------------------------------------------
--
-- Table structure for table `currency`
--
CREATE TABLE IF NOT EXISTS `currency` (
`currency_id` int(11) NOT NULL auto_increment,
`title` varchar(32) collate utf8_bin NOT NULL default '',
`code` varchar(3) collate utf8_bin NOT NULL default '',
`symbol_left` varchar(12) collate utf8_bin NOT NULL,
`symbol_right` varchar(12) collate utf8_bin NOT NULL,
`decimal_place` char(1) collate utf8_bin NOT NULL,
`value` float(15,8) NOT NULL,
`status` int(1) NOT NULL,
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`currency_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
--
-- Dumping data for table `currency`
--
INSERT INTO `currency` (`currency_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_place`, `value`, `status`, `date_modified`) VALUES
(1, 'Pound Sterling', 'GBP', '£', '', '2', 1.00000000, 1, '2011-01-14 18:41:07'),
(2, 'US Dollar', 'USD', '$', '', '2', 1.58739996, 1, '2011-01-14 18:41:06'),
(3, 'Euro', 'EUR', '', '', '2', 1.18939996, 1, '2011-01-14 18:41:07');
-- --------------------------------------------------------
--
-- Table structure for table `customer`
--
CREATE TABLE IF NOT EXISTS `customer` (
`customer_id` int(11) NOT NULL auto_increment,
`store_id` int(11) NOT NULL default '0',
`firstname` varchar(32) collate utf8_bin NOT NULL default '',
`lastname` varchar(32) collate utf8_bin NOT NULL default '',
`email` varchar(96) collate utf8_bin NOT NULL default '',
`telephone` varchar(32) collate utf8_bin NOT NULL default '',
`fax` varchar(32) collate utf8_bin NOT NULL default '',
`password` varchar(40) collate utf8_bin NOT NULL default '',
`cart` text collate utf8_bin,
`newsletter` int(1) NOT NULL default '0',
`address_id` int(11) NOT NULL default '0',
`status` int(1) NOT NULL,
`approved` int(1) NOT NULL default '0',
`customer_group_id` int(11) NOT NULL,
`ip` varchar(15) collate utf8_bin NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`customer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `customer`
--
INSERT INTO `customer` (`customer_id`, `store_id`, `firstname`, `lastname`, `email`, `telephone`, `fax`, `password`, `cart`, `newsletter`, `address_id`, `status`, `approved`, `customer_group_id`, `ip`, `date_added`) VALUES
(1, 0, 'Søren', 'Louv-Jansen', 'sorenlouv@gmail.com', '4551749555', '', '8541fd9136ff679d72e2a0f996276db9', 'a:0:{}', 0, 1, 1, 1, 8, '127.0.0.1', '2010-12-12 17:41:24');
-- --------------------------------------------------------
--
-- Table structure for table `customer_group`
--
CREATE TABLE IF NOT EXISTS `customer_group` (
`customer_group_id` int(11) NOT NULL auto_increment,
`name` varchar(32) collate utf8_bin NOT NULL,
PRIMARY KEY (`customer_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=9 ;
--
-- Dumping data for table `customer_group`
--
INSERT INTO `customer_group` (`customer_group_id`, `name`) VALUES
(8, 'Default'),
(6, 'Wholesale');
-- --------------------------------------------------------
--
-- Table structure for table `download`
--
CREATE TABLE IF NOT EXISTS `download` (
`download_id` int(11) NOT NULL auto_increment,
`filename` varchar(128) collate utf8_bin NOT NULL default '',
`mask` varchar(128) collate utf8_bin NOT NULL default '',
`remaining` int(11) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
--
-- Dumping data for table `download`
--
-- --------------------------------------------------------
--
-- Table structure for table `download_description`
--
CREATE TABLE IF NOT EXISTS `download_description` (
`download_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`name` varchar(64) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`download_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `download_description`
--
-- --------------------------------------------------------
--
-- Table structure for table `extension`
--
CREATE TABLE IF NOT EXISTS `extension` (
`extension_id` int(11) NOT NULL auto_increment,
`type` varchar(32) collate utf8_bin NOT NULL,
`key` varchar(32) collate utf8_bin NOT NULL,
PRIMARY KEY (`extension_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=296 ;
--
-- Dumping data for table `extension`
--
INSERT INTO `extension` (`extension_id`, `type`, `key`) VALUES
(23, 'payment', 'cod'),
(22, 'total', 'shipping'),
(57, 'total', 'sub_total'),
(58, 'total', 'tax'),
(59, 'total', 'total'),
(77, 'module', 'cart'),
(78, 'module', 'category'),
(224, 'module', 'information'),
(81, 'module', 'manufacturer'),
(115, 'module', 'bestseller'),
(284, 'payment', 'nochex'),
(128, 'total', 'coupon'),
(293, 'shipping', 'flat'),
(294, 'module', 'latest'),
(295, 'module', 'featured');
-- --------------------------------------------------------
--
-- Table structure for table `geo_zone`
--
CREATE TABLE IF NOT EXISTS `geo_zone` (
`geo_zone_id` int(11) NOT NULL auto_increment,
`name` varchar(32) collate utf8_bin NOT NULL default '',
`description` varchar(255) collate utf8_bin NOT NULL default '',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`geo_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;
--
-- Dumping data for table `geo_zone`
--
INSERT INTO `geo_zone` (`geo_zone_id`, `name`, `description`, `date_modified`, `date_added`) VALUES
(3, 'UK VAT Zone', 'UK VAT', '2010-02-26 22:33:24', '2009-01-06 23:26:25'),
(4, 'UK Shipping', 'UK Shipping Zones', '2010-03-05 17:26:04', '2009-06-23 01:14:53');
-- --------------------------------------------------------
--
-- Table structure for table `information`
--
CREATE TABLE IF NOT EXISTS `information` (
`information_id` int(11) NOT NULL auto_increment,
`sort_order` int(3) NOT NULL default '0',
`status` int(1) NOT NULL default '1',
PRIMARY KEY (`information_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;
--
-- Dumping data for table `information`
--
INSERT INTO `information` (`information_id`, `sort_order`, `status`) VALUES
(3, 2, 1),
(4, 1, 1),
(5, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `information_description`
--
CREATE TABLE IF NOT EXISTS `information_description` (
`information_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`title` varchar(64) collate utf8_bin NOT NULL default '',
`description` text collate utf8_bin NOT NULL,
PRIMARY KEY (`information_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `information_description`
--
INSERT INTO `information_description` (`information_id`, `language_id`, `title`, `description`) VALUES
(5, 1, 'Terms & Conditions', '<p>\r\n Terms & Conditions</p>\r\n'),
(3, 1, 'Privacy Policy', '<p>\r\n Privacy Policy</p>\r\n'),
(4, 1, 'About Us', '<p>\r\n About Us</p>\r\n');
-- --------------------------------------------------------
--
-- Table structure for table `information_to_store`
--
CREATE TABLE IF NOT EXISTS `information_to_store` (
`information_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
PRIMARY KEY (`information_id`,`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `information_to_store`
--
INSERT INTO `information_to_store` (`information_id`, `store_id`) VALUES
(3, 0),
(4, 0),
(5, 0);
-- --------------------------------------------------------
--
-- Table structure for table `language`
--
CREATE TABLE IF NOT EXISTS `language` (
`language_id` int(11) NOT NULL auto_increment,
`name` varchar(32) collate utf8_bin NOT NULL default '',
`code` varchar(5) collate utf8_bin NOT NULL,
`locale` varchar(255) collate utf8_bin NOT NULL,
`image` varchar(64) collate utf8_bin NOT NULL,
`directory` varchar(32) collate utf8_bin NOT NULL default '',
`filename` varchar(64) collate utf8_bin NOT NULL default '',
`sort_order` int(3) NOT NULL default '0',
`status` int(1) NOT NULL,
PRIMARY KEY (`language_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `language`
--
INSERT INTO `language` (`language_id`, `name`, `code`, `locale`, `image`, `directory`, `filename`, `sort_order`, `status`) VALUES
(1, 'English', 'en', 'en_US.UTF-8,en_US,en-gb,english', 'gb.png', 'english', 'english', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `length_class`
--
CREATE TABLE IF NOT EXISTS `length_class` (
`length_class_id` int(11) NOT NULL auto_increment,
`value` decimal(15,8) NOT NULL,
PRIMARY KEY (`length_class_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
--
-- Dumping data for table `length_class`
--
INSERT INTO `length_class` (`length_class_id`, `value`) VALUES
(1, '1.00000000'),
(2, '10.00000000'),
(3, '0.39370000');
-- --------------------------------------------------------
--
-- Table structure for table `length_class_description`
--
CREATE TABLE IF NOT EXISTS `length_class_description` (
`length_class_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL,
`title` varchar(32) collate utf8_bin NOT NULL,
`unit` varchar(4) collate utf8_bin NOT NULL,
PRIMARY KEY (`length_class_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
--
-- Dumping data for table `length_class_description`
--
INSERT INTO `length_class_description` (`length_class_id`, `language_id`, `title`, `unit`) VALUES
(1, 1, 'Centimeter', 'cm'),
(2, 1, 'Millimeter', 'mm'),
(3, 1, 'Inch', 'in');
-- --------------------------------------------------------
--
-- Table structure for table `manufacturer`
--
CREATE TABLE IF NOT EXISTS `manufacturer` (
`manufacturer_id` int(11) NOT NULL auto_increment,
`name` varchar(64) collate utf8_bin NOT NULL default '',
`image` varchar(255) collate utf8_bin default NULL,
`sort_order` int(3) NOT NULL,
PRIMARY KEY (`manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;
--
-- Dumping data for table `manufacturer`
--
INSERT INTO `manufacturer` (`manufacturer_id`, `name`, `image`, `sort_order`) VALUES
(11, 'URU', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `manufacturer_to_store`
--
CREATE TABLE IF NOT EXISTS `manufacturer_to_store` (
`manufacturer_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL,
PRIMARY KEY (`manufacturer_id`,`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `manufacturer_to_store`
--
INSERT INTO `manufacturer_to_store` (`manufacturer_id`, `store_id`) VALUES
(11, 0);
-- --------------------------------------------------------
--
-- Table structure for table `order`
--
CREATE TABLE IF NOT EXISTS `order` (
`order_id` int(11) NOT NULL auto_increment,
`invoice_id` int(11) NOT NULL default '0',
`invoice_prefix` varchar(10) collate utf8_bin NOT NULL,
`store_id` int(11) NOT NULL default '0',
`store_name` varchar(64) collate utf8_bin NOT NULL,
`store_url` varchar(255) collate utf8_bin NOT NULL,
`customer_id` int(11) NOT NULL default '0',
`customer_group_id` int(11) NOT NULL default '0',
`firstname` varchar(32) collate utf8_bin NOT NULL default '',
`lastname` varchar(32) collate utf8_bin NOT NULL,
`telephone` varchar(32) collate utf8_bin NOT NULL default '',
`fax` varchar(32) collate utf8_bin NOT NULL default '',
`email` varchar(96) collate utf8_bin NOT NULL default '',
`shipping_firstname` varchar(32) collate utf8_bin NOT NULL,
`shipping_lastname` varchar(32) collate utf8_bin NOT NULL default '',
`shipping_company` varchar(32) collate utf8_bin NOT NULL,
`shipping_address_1` varchar(128) collate utf8_bin NOT NULL,
`shipping_address_2` varchar(128) collate utf8_bin NOT NULL,
`shipping_city` varchar(128) collate utf8_bin NOT NULL,
`shipping_postcode` varchar(10) collate utf8_bin NOT NULL default '',
`shipping_zone` varchar(128) collate utf8_bin NOT NULL,
`shipping_zone_id` int(11) NOT NULL,
`shipping_country` varchar(128) collate utf8_bin NOT NULL,
`shipping_country_id` int(11) NOT NULL,
`shipping_address_format` text collate utf8_bin NOT NULL,
`shipping_method` varchar(128) collate utf8_bin NOT NULL default '',
`payment_firstname` varchar(32) collate utf8_bin NOT NULL default '',
`payment_lastname` varchar(32) collate utf8_bin NOT NULL default '',
`payment_company` varchar(32) collate utf8_bin NOT NULL,
`payment_address_1` varchar(128) collate utf8_bin NOT NULL,
`payment_address_2` varchar(128) collate utf8_bin NOT NULL,
`payment_city` varchar(128) collate utf8_bin NOT NULL,
`payment_postcode` varchar(10) collate utf8_bin NOT NULL default '',
`payment_zone` varchar(128) collate utf8_bin NOT NULL,
`payment_zone_id` int(11) NOT NULL,
`payment_country` varchar(128) collate utf8_bin NOT NULL,
`payment_country_id` int(11) NOT NULL,
`payment_address_format` text collate utf8_bin NOT NULL,
`payment_method` varchar(128) collate utf8_bin NOT NULL default '',
`comment` text collate utf8_bin NOT NULL,
`total` decimal(15,4) NOT NULL default '0.0000',
`order_status_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL,
`currency_id` int(11) NOT NULL,
`currency` varchar(3) collate utf8_bin NOT NULL,
`value` decimal(15,8) NOT NULL,
`coupon_id` int(11) NOT NULL,
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(15) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `order`
--
INSERT INTO `order` (`order_id`, `invoice_id`, `invoice_prefix`, `store_id`, `store_name`, `store_url`, `customer_id`, `customer_group_id`, `firstname`, `lastname`, `telephone`, `fax`, `email`, `shipping_firstname`, `shipping_lastname`, `shipping_company`, `shipping_address_1`, `shipping_address_2`, `shipping_city`, `shipping_postcode`, `shipping_zone`, `shipping_zone_id`, `shipping_country`, `shipping_country_id`, `shipping_address_format`, `shipping_method`, `payment_firstname`, `payment_lastname`, `payment_company`, `payment_address_1`, `payment_address_2`, `payment_city`, `payment_postcode`, `payment_zone`, `payment_zone_id`, `payment_country`, `payment_country_id`, `payment_address_format`, `payment_method`, `comment`, `total`, `order_status_id`, `language_id`, `currency_id`, `currency`, `value`, `coupon_id`, `date_modified`, `date_added`, `ip`) VALUES
(1, 0, '', 0, 'URU Diamonds', 'http://localhost.uru.dk/', 0, 8, 'sad', 'saddas', '8888888', '', 'zasd@asd.dk', 'sad', 'saddas', '', 'Amageddon rd. 24', '', 'Berlin', '2323', 'Bornholm', 904, 'Denmark', 57, '', 'Flat Rate', 'sad', 'saddas', '', 'Amageddon rd. 24', '', 'Berlin', '2323', 'Bornholm', 904, 'Denmark', 57, '', 'Cash On Delivery', 'asdasd', '3131.9900', 1, 1, 1, 'GBP', '1.00000000', 0, '2010-12-12 17:40:17', '2010-12-12 17:40:17', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `order_download`
--
CREATE TABLE IF NOT EXISTS `order_download` (
`order_download_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL,
`order_product_id` int(11) NOT NULL,
`name` varchar(64) collate utf8_bin NOT NULL default '',
`filename` varchar(128) collate utf8_bin NOT NULL default '',
`mask` varchar(128) collate utf8_bin NOT NULL default '',
`remaining` int(3) NOT NULL default '0',
PRIMARY KEY (`order_download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
--
-- Dumping data for table `order_download`
--
-- --------------------------------------------------------
--
-- Table structure for table `order_history`
--
CREATE TABLE IF NOT EXISTS `order_history` (
`order_history_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL,
`order_status_id` int(5) NOT NULL,
`notify` int(1) NOT NULL default '0',
`comment` text collate utf8_bin NOT NULL,
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`order_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `order_history`
--
INSERT INTO `order_history` (`order_history_id`, `order_id`, `order_status_id`, `notify`, `comment`, `date_added`) VALUES
(1, 1, 1, 1, '', '2010-12-12 17:40:27');
-- --------------------------------------------------------
--
-- Table structure for table `order_option`
--
CREATE TABLE IF NOT EXISTS `order_option` (
`order_option_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL,
`order_product_id` int(11) NOT NULL,
`product_option_value_id` int(11) NOT NULL default '0',
`name` varchar(255) collate utf8_bin NOT NULL,
`value` varchar(255) collate utf8_bin NOT NULL,
`price` decimal(15,4) NOT NULL default '0.0000',
`prefix` char(1) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`order_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;
--
-- Dumping data for table `order_option`
--
INSERT INTO `order_option` (`order_option_id`, `order_id`, `order_product_id`, `product_option_value_id`, `name`, `value`, `price`, `prefix`) VALUES
(1, 1, 1, 586, 'Memory', '1GB', '100.0000', '+'),
(2, 1, 3, 587, 'Memory', '8GB', '150.0000', '+');
-- --------------------------------------------------------
--
-- Table structure for table `order_product`
--
CREATE TABLE IF NOT EXISTS `order_product` (
`order_product_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_bin NOT NULL,
`model` varchar(24) collate utf8_bin NOT NULL,
`price` decimal(15,4) NOT NULL default '0.0000',
`total` decimal(15,4) NOT NULL default '0.0000',
`tax` decimal(15,4) NOT NULL default '0.0000',
`quantity` int(4) NOT NULL default '0',
PRIMARY KEY (`order_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;
--
-- Dumping data for table `order_product`
--
INSERT INTO `order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `total`, `tax`, `quantity`) VALUES
(1, 1, 48, 'iPod Classic', 'product 20', '100.0000', '700.0000', '0.0000', 7),
(2, 1, 47, 'HP LP3065', 'Product 21', '1000.0000', '2000.0000', '0.0000', 2),
(3, 1, 48, 'iPod Classic', 'product 20', '150.0000', '150.0000', '0.0000', 1),
(4, 1, 29, 'Palm Treo Pro', 'Product 2', '279.9900', '279.9900', '0.0000', 1);
-- --------------------------------------------------------
--
-- Table structure for table `order_status`
--
CREATE TABLE IF NOT EXISTS `order_status` (
`order_status_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL,
`name` varchar(32) collate utf8_bin NOT NULL,
PRIMARY KEY (`order_status_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ;
--
-- Dumping data for table `order_status`
--
INSERT INTO `order_status` (`order_status_id`, `language_id`, `name`) VALUES
(1, 1, 'Pending'),
(2, 1, 'Processing'),
(3, 1, 'Shipped'),
(7, 1, 'Canceled'),
(5, 1, 'Complete'),
(8, 1, 'Denied'),
(9, 1, 'Canceled Reversal'),
(10, 1, 'Failed'),
(11, 1, 'Refunded'),
(12, 1, 'Reversed'),
(13, 1, 'Chargeback');
-- --------------------------------------------------------
--
-- Table structure for table `order_total`
--
CREATE TABLE IF NOT EXISTS `order_total` (
`order_total_id` int(10) NOT NULL auto_increment,
`order_id` int(11) NOT NULL,
`title` varchar(255) collate utf8_bin NOT NULL default '',
`text` varchar(255) collate utf8_bin NOT NULL default '',
`value` decimal(15,4) NOT NULL default '0.0000',
`sort_order` int(3) NOT NULL,
PRIMARY KEY (`order_total_id`),
KEY `idx_orders_total_orders_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
--
-- Dumping data for table `order_total`
--
INSERT INTO `order_total` (`order_total_id`, `order_id`, `title`, `text`, `value`, `sort_order`) VALUES
(1, 1, 'Sub-Total:', '£3,129.99', '3129.9900', 1),
(2, 1, 'Flat Rate:', '£2.00', '2.0000', 3),
(3, 1, 'Total:', '£3,131.99', '3131.9900', 6);
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`product_id` int(11) NOT NULL auto_increment,
`model` varchar(64) collate utf8_bin NOT NULL,
`sku` varchar(64) collate utf8_bin NOT NULL,
`location` varchar(128) collate utf8_bin NOT NULL,
`quantity` int(4) NOT NULL default '0',
`stock_status_id` int(11) NOT NULL,
`image` varchar(255) collate utf8_bin default NULL,
`manufacturer_id` int(11) NOT NULL,
`shipping` int(1) NOT NULL default '1',
`price` decimal(15,4) NOT NULL default '0.0000',
`tax_class_id` int(11) NOT NULL,
`date_available` date NOT NULL,
`weight` decimal(5,2) NOT NULL default '0.00',
`weight_class_id` int(11) NOT NULL default '0',
`length` decimal(5,2) NOT NULL default '0.00',
`width` decimal(5,2) NOT NULL default '0.00',
`height` decimal(5,2) NOT NULL default '0.00',
`length_class_id` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`viewed` int(5) NOT NULL default '0',
`sort_order` int(11) NOT NULL default '0',
`subtract` int(1) NOT NULL default '1',
`minimum` int(11) NOT NULL default '1',
`cost` decimal(15,4) NOT NULL default '0.0000',
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=50 ;
--
-- Dumping data for table `product`
--
INSERT INTO `product` (`product_id`, `model`, `sku`, `location`, `quantity`, `stock_status_id`, `image`, `manufacturer_id`, `shipping`, `price`, `tax_class_id`, `date_available`, `weight`, `weight_class_id`, `length`, `width`, `height`, `length_class_id`, `status`, `date_added`, `date_modified`, `viewed`, `sort_order`, `subtract`, `minimum`, `cost`) VALUES
(49, 'demo123', '', '', 1, 5, '', 11, 1, '0.0000', 0, '2011-01-11', '0.00', 1, '0.00', '0.00', '0.00', 1, 1, '2011-01-12 13:49:46', '0000-00-00 00:00:00', 1, 1, 1, 1, '0.0000');
-- --------------------------------------------------------
--
-- Table structure for table `product_description`
--
CREATE TABLE IF NOT EXISTS `product_description` (
`product_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_bin NOT NULL,
`meta_keywords` varchar(255) collate utf8_bin NOT NULL,
`meta_description` varchar(255) collate utf8_bin NOT NULL,
`description` text collate utf8_bin NOT NULL,
PRIMARY KEY (`product_id`,`language_id`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=50 ;
--
-- Dumping data for table `product_description`
--
INSERT INTO `product_description` (`product_id`, `language_id`, `name`, `meta_keywords`, `meta_description`, `description`) VALUES
(49, 1, 'Demo', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `product_discount`
--
CREATE TABLE IF NOT EXISTS `product_discount` (
`product_discount_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL,
`customer_group_id` int(11) NOT NULL,
`quantity` int(4) NOT NULL default '0',
`priority` int(5) NOT NULL default '1',
`price` decimal(15,4) NOT NULL default '0.0000',
`date_start` date NOT NULL default '0000-00-00',
`date_end` date NOT NULL default '0000-00-00',
PRIMARY KEY (`product_discount_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=101 ;
--
-- Dumping data for table `product_discount`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_featured`
--
CREATE TABLE IF NOT EXISTS `product_featured` (
`product_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_featured`
--
INSERT INTO `product_featured` (`product_id`) VALUES
(42),
(28),
(43),
(44),
(45);
-- --------------------------------------------------------
--
-- Table structure for table `product_image`
--
CREATE TABLE IF NOT EXISTS `product_image` (
`product_image_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL,
`image` varchar(255) collate utf8_bin default NULL,
PRIMARY KEY (`product_image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1338 ;
--
-- Dumping data for table `product_image`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_option`
--
CREATE TABLE IF NOT EXISTS `product_option` (
`product_option_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL,
`sort_order` int(3) NOT NULL default '0',
PRIMARY KEY (`product_option_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=297 ;
--
-- Dumping data for table `product_option`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_option_description`
--
CREATE TABLE IF NOT EXISTS `product_option_description` (
`product_option_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`product_option_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_option_description`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_option_value`
--
CREATE TABLE IF NOT EXISTS `product_option_value` (
`product_option_value_id` int(11) NOT NULL auto_increment,
`product_option_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`quantity` int(4) NOT NULL default '0',
`subtract` int(1) NOT NULL default '0',
`price` decimal(15,4) NOT NULL,
`prefix` char(1) collate utf8_bin NOT NULL,
`sort_order` int(3) NOT NULL,
PRIMARY KEY (`product_option_value_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=588 ;
--
-- Dumping data for table `product_option_value`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_option_value_description`
--
CREATE TABLE IF NOT EXISTS `product_option_value_description` (
`product_option_value_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`name` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`product_option_value_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_option_value_description`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_related`
--
CREATE TABLE IF NOT EXISTS `product_related` (
`product_id` int(11) NOT NULL,
`related_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`,`related_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_related`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_special`
--
CREATE TABLE IF NOT EXISTS `product_special` (
`product_special_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL,
`customer_group_id` int(11) NOT NULL,
`priority` int(5) NOT NULL default '1',
`price` decimal(15,4) NOT NULL default '0.0000',
`date_start` date NOT NULL default '0000-00-00',
`date_end` date NOT NULL default '0000-00-00',
PRIMARY KEY (`product_special_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=252 ;
--
-- Dumping data for table `product_special`
--
INSERT INTO `product_special` (`product_special_id`, `product_id`, `customer_group_id`, `priority`, `price`, `date_start`, `date_end`) VALUES
(251, 42, 8, 1, '50.0000', '2010-02-01', '2010-02-28'),
(242, 49, 8, 1, '50.0000', '2010-02-01', '2010-02-28'),
(243, 50, 8, 1, '50.0000', '2010-02-01', '2010-02-28'),
(244, 58, 8, 1, '50.0000', '2010-02-01', '2010-02-28'),
(246, 67, 8, 1, '50.0000', '2010-02-01', '2010-02-28'),
(249, 69, 8, 1, '50.0000', '2010-02-01', '2010-02-28');
-- --------------------------------------------------------
--
-- Table structure for table `product_tags`
--
CREATE TABLE IF NOT EXISTS `product_tags` (
`product_id` int(11) NOT NULL,
`tag` varchar(32) collate utf8_bin NOT NULL,
`language_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`,`tag`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_tags`
--
INSERT INTO `product_tags` (`product_id`, `tag`, `language_id`) VALUES
(49, '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `product_to_category`
--
CREATE TABLE IF NOT EXISTS `product_to_category` (
`product_id` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`,`category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_to_category`
--
INSERT INTO `product_to_category` (`product_id`, `category_id`) VALUES
(49, 35);
-- --------------------------------------------------------
--
-- Table structure for table `product_to_download`
--
CREATE TABLE IF NOT EXISTS `product_to_download` (
`product_id` int(11) NOT NULL,
`download_id` int(11) NOT NULL,
PRIMARY KEY (`product_id`,`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_to_download`
--
-- --------------------------------------------------------
--
-- Table structure for table `product_to_store`
--
CREATE TABLE IF NOT EXISTS `product_to_store` (
`product_id` int(11) NOT NULL,
`store_id` int(11) NOT NULL default '0',
PRIMARY KEY (`product_id`,`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `product_to_store`
--
INSERT INTO `product_to_store` (`product_id`, `store_id`) VALUES
(49, 0);
-- --------------------------------------------------------
--
-- Table structure for table `review`
--
CREATE TABLE IF NOT EXISTS `review` (
`review_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`author` varchar(64) collate utf8_bin NOT NULL default '',
`text` text collate utf8_bin NOT NULL,
`rating` int(1) NOT NULL,
`status` int(1) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`review_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=62 ;
--
-- Dumping data for table `review`
--
-- --------------------------------------------------------
--
-- Table structure for table `setting`
--
CREATE TABLE IF NOT EXISTS `setting` (
`setting_id` int(11) NOT NULL auto_increment,
`group` varchar(32) collate utf8_bin NOT NULL,
`key` varchar(64) collate utf8_bin NOT NULL default '',
`value` text collate utf8_bin NOT NULL,
PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1005 ;
--
-- Dumping data for table `setting`
--
INSERT INTO `setting` (`setting_id`, `group`, `key`, `value`) VALUES
(1, 'coupon', 'coupon_sort_order', '4'),
(2, 'shipping', 'shipping_sort_order', '3'),
(3, 'shipping', 'shipping_status', '1'),
(4, 'cod', 'cod_sort_order', '1'),
(5, 'sub_total', 'sub_total_sort_order', '1'),
(6, 'cod', 'cod_status', '1'),
(7, 'cod', 'cod_geo_zone_id', '0'),
(8, 'coupon', 'coupon_status', '1'),
(9, 'sub_total', 'sub_total_status', '1'),
(10, 'cod', 'cod_order_status_id', '1'),
(11, 'tax', 'tax_status', '1'),
(12, 'tax', 'tax_sort_order', '5'),
(13, 'total', 'total_sort_order', '6'),
(14, 'total', 'total_status', '1'),
(15, 'category', 'category_sort_order', '1'),
(16, 'category', 'category_status', '1'),
(17, 'information', 'information_sort_order', '3'),
(18, 'information', 'information_status', '1'),
(19, 'information', 'information_position', 'left'),
(996, 'manufacturer', 'manufacturer_sort_order', '2'),
(995, 'manufacturer', 'manufacturer_status', '0'),
(1004, 'bestseller', 'bestseller_sort_order', '3'),
(1003, 'bestseller', 'bestseller_status', '0'),
(1002, 'bestseller', 'bestseller_position', 'right'),
(1001, 'bestseller', 'bestseller_limit', '10'),
(999, 'featured', 'featured_status', '0'),
(998, 'featured', 'featured_position', 'right'),
(997, 'featured', 'featured_limit', '5'),
(30, 'cart', 'cart_status', '1'),
(31, 'category', 'category_position', 'left'),
(994, 'manufacturer', 'manufacturer_position', 'left'),
(33, 'cart', 'cart_position', 'right'),
(34, 'cart', 'cart_ajax', '1'),
(35, 'cart', 'cart_sort_order', '1'),
(1000, 'featured', 'featured_sort_order', '5'),
(993, 'config', 'config_error_filename', 'error.txt'),
(992, 'config', 'config_error_log', '1'),
(991, 'config', 'config_error_display', '1'),
(990, 'config', 'config_compression', '0'),
(989, 'config', 'config_seo_url', '0'),
(988, 'config', 'config_encryption', '12345'),
(987, 'config', 'config_maintenance', '0'),
(986, 'config', 'config_ssl', '0'),
(985, 'config', 'config_alert_emails', ''),
(983, 'config', 'config_smtp_timeout', '5'),
(984, 'config', 'config_alert_mail', '0'),
(982, 'config', 'config_smtp_port', '25'),
(981, 'config', 'config_smtp_password', ''),
(980, 'config', 'config_smtp_username', ''),
(979, 'config', 'config_smtp_host', ''),
(978, 'config', 'config_mail_parameter', ''),
(977, 'config', 'config_mail_protocol', 'mail'),
(976, 'config', 'config_image_cart_height', '75'),
(975, 'config', 'config_image_cart_width', '75'),
(974, 'config', 'config_image_related_height', '120'),
(973, 'config', 'config_image_related_width', '120'),
(972, 'config', 'config_image_additional_height', '150'),
(971, 'config', 'config_image_additional_width', '150'),
(970, 'config', 'config_image_product_height', '120'),
(969, 'config', 'config_image_product_width', '120'),
(968, 'config', 'config_image_category_height', '120'),
(967, 'config', 'config_image_category_width', '120'),
(78, 'flat', 'flat_cost', '2'),
(79, 'flat', 'flat_tax_class_id', '9'),
(80, 'flat', 'flat_geo_zone_id', '0'),
(81, 'flat', 'flat_status', '1'),
(82, 'flat', 'flat_sort_order', '1'),
(966, 'config', 'config_image_popup_height', '500'),
(965, 'config', 'config_image_popup_width', '500'),
(964, 'config', 'config_image_thumb_height', '250'),
(961, 'config', 'config_logo', 'data/uruLogo.jpg'),
(962, 'config', 'config_icon', 'data/cart.png'),
(963, 'config', 'config_image_thumb_width', '250'),
(960, 'config', 'config_shipping_session', '0'),
(959, 'config', 'config_cart_weight', '1'),
(958, 'config', 'config_download_status', '5'),
(957, 'config', 'config_download', '1'),
(956, 'config', 'config_review', '1'),
(955, 'config', 'config_stock_status_id', '5'),
(954, 'config', 'config_order_status_id', '1'),
(953, 'config', 'config_stock_checkout', '0'),
(952, 'config', 'config_stock_warning', '0'),
(951, 'config', 'config_stock_display', '0'),
(950, 'config', 'config_checkout_id', '5'),
(949, 'config', 'config_account_id', '3'),
(948, 'config', 'config_guest_checkout', '1'),
(947, 'config', 'config_customer_approval', '0'),
(113, 'latest', 'latest_limit', '8'),
(114, 'latest', 'latest_position', 'home'),
(115, 'latest', 'latest_status', '1'),
(116, 'latest', 'latest_sort_order', '0'),
(946, 'config', 'config_customer_price', '0'),
(945, 'config', 'config_customer_group_id', '8'),
(943, 'config', 'config_invoice_id', '001'),
(944, 'config', 'config_invoice_prefix', 'INV'),
(942, 'config', 'config_tax', '1'),
(941, 'config', 'config_catalog_limit', '20'),
(940, 'config', 'config_admin_limit', '20'),
(939, 'config', 'config_weight_class', 'kg'),
(938, 'config', 'config_length_class', 'cm'),
(937, 'config', 'config_currency_auto', '1'),
(936, 'config', 'config_currency', 'GBP'),
(935, 'config', 'config_admin_language', 'en'),
(934, 'config', 'config_language', 'en'),
(933, 'config', 'config_country_id', '57'),
(932, 'config', 'config_description_1', ''),
(931, 'config', 'config_template', 'konscript'),
(930, 'config', 'config_meta_description', 'My Store'),
(929, 'config', 'config_title', 'URU'),
(928, 'config', 'config_fax', ''),
(927, 'config', 'config_telephone', '123456789'),
(925, 'config', 'config_address', 'Sølvgade 95'),
(926, 'config', 'config_email', 'sorenlouv@gmail.com'),
(924, 'config', 'config_owner', 'Søren Louv-Jansen'),
(923, 'config', 'config_url', 'http://uru.konscript.com/'),
(922, 'config', 'config_name', 'URU Diamonds');
-- --------------------------------------------------------
--
-- Table structure for table `stock_status`
--
CREATE TABLE IF NOT EXISTS `stock_status` (
`stock_status_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL,
`name` varchar(32) collate utf8_bin NOT NULL,
PRIMARY KEY (`stock_status_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=9 ;
--
-- Dumping data for table `stock_status`
--
INSERT INTO `stock_status` (`stock_status_id`, `language_id`, `name`) VALUES
(7, 1, 'In Stock'),
(5, 1, 'Out Of Stock'),
(6, 1, '2 - 3 Days'),
(8, 1, 'Pre-Order');
-- --------------------------------------------------------
--
-- Table structure for table `store`
--
CREATE TABLE IF NOT EXISTS `store` (
`store_id` int(11) NOT NULL auto_increment,
`name` varchar(64) collate utf8_bin NOT NULL,
`url` varchar(255) collate utf8_bin NOT NULL,
`title` varchar(128) collate utf8_bin NOT NULL,
`meta_description` varchar(255) collate utf8_bin NOT NULL,
`template` varchar(64) collate utf8_bin NOT NULL,
`country_id` int(11) NOT NULL,
`zone_id` int(11) NOT NULL,
`language` varchar(5) collate utf8_bin NOT NULL,
`currency` varchar(3) collate utf8_bin NOT NULL,
`tax` int(1) NOT NULL default '0',
`customer_group_id` int(11) NOT NULL,
`customer_price` int(1) NOT NULL,
`customer_approval` int(1) NOT NULL,
`guest_checkout` int(1) NOT NULL,
`account_id` int(11) NOT NULL default '0',
`checkout_id` int(11) NOT NULL default '0',
`stock_display` int(1) NOT NULL,
`stock_check` int(1) NOT NULL,
`stock_checkout` int(1) NOT NULL,
`order_status_id` int(11) NOT NULL,
`logo` varchar(255) collate utf8_bin NOT NULL,
`icon` varchar(255) collate utf8_bin NOT NULL,
`image_thumb_width` int(5) NOT NULL,
`image_thumb_height` int(5) NOT NULL,
`image_popup_width` int(5) NOT NULL,
`image_popup_height` int(5) NOT NULL,
`image_category_width` int(5) NOT NULL,
`image_category_height` int(5) NOT NULL,
`image_product_width` int(5) NOT NULL,
`image_product_height` int(5) NOT NULL,
`image_additional_width` int(5) NOT NULL,
`image_additional_height` int(5) NOT NULL,
`image_related_width` int(5) NOT NULL,
`image_related_height` int(5) NOT NULL,
`image_cart_width` int(5) NOT NULL,
`image_cart_height` int(5) NOT NULL,
`ssl` int(1) NOT NULL,
`catalog_limit` int(4) NOT NULL default '12',
`cart_weight` int(1) NOT NULL,
PRIMARY KEY (`store_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
--
-- Dumping data for table `store`
--
-- --------------------------------------------------------
--
-- Table structure for table `store_description`
--
CREATE TABLE IF NOT EXISTS `store_description` (
`store_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`description` text collate utf8_bin NOT NULL,
PRIMARY KEY (`store_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
--
-- Dumping data for table `store_description`
--
-- --------------------------------------------------------
--
-- Table structure for table `tax_class`
--
CREATE TABLE IF NOT EXISTS `tax_class` (
`tax_class_id` int(11) NOT NULL auto_increment,
`title` varchar(32) collate utf8_bin NOT NULL default '',
`description` varchar(255) collate utf8_bin NOT NULL default '',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tax_class_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tax_class`
--
INSERT INTO `tax_class` (`tax_class_id`, `title`, `description`, `date_added`, `date_modified`) VALUES
(9, 'Taxable Goods', 'Taxed Stuff', '2009-01-06 23:21:53', '2010-02-26 22:08:04');
-- --------------------------------------------------------
--
-- Table structure for table `tax_rate`
--
CREATE TABLE IF NOT EXISTS `tax_rate` (
`tax_rate_id` int(11) NOT NULL auto_increment,
`geo_zone_id` int(11) NOT NULL default '0',
`tax_class_id` int(11) NOT NULL,
`priority` int(5) NOT NULL default '1',
`rate` decimal(7,4) NOT NULL default '0.0000',
`description` varchar(255) collate utf8_bin NOT NULL default '',
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tax_rate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=83 ;
--
-- Dumping data for table `tax_rate`
--
INSERT INTO `tax_rate` (`tax_rate_id`, `geo_zone_id`, `tax_class_id`, `priority`, `rate`, `description`, `date_modified`, `date_added`) VALUES
(82, 3, 9, 1, '17.5000', 'VAT 17.5%', '0000-00-00 00:00:00', '2010-02-26 22:08:04');
-- --------------------------------------------------------
--
-- Table structure for table `url_alias`
--
CREATE TABLE IF NOT EXISTS `url_alias` (
`url_alias_id` int(11) NOT NULL auto_increment,
`query` varchar(255) collate utf8_bin NOT NULL,
`keyword` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`url_alias_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=488 ;
--
-- Dumping data for table `url_alias`
--
INSERT INTO `url_alias` (`url_alias_id`, `query`, `keyword`) VALUES
(455, 'information_id=4', 'about_us');
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`user_id` int(11) NOT NULL auto_increment,
`user_group_id` int(11) NOT NULL,
`username` varchar(20) collate utf8_bin NOT NULL default '',
`password` varchar(32) collate utf8_bin NOT NULL default '',
`firstname` varchar(32) collate utf8_bin NOT NULL default '',
`lastname` varchar(32) collate utf8_bin NOT NULL default '',
`email` varchar(96) collate utf8_bin NOT NULL default '',
`status` int(1) NOT NULL,
`ip` varchar(15) collate utf8_bin NOT NULL default '',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`user_id`, `user_group_id`, `username`, `password`, `firstname`, `lastname`, `email`, `status`, `ip`, `date_added`) VALUES
(1, 1, 'admin', 'e2560f73579c206926f0b121939640f6', 'Konscript', 'Admin', 'admin@konscript.com', 1, '', '2011-01-14 18:35:23');
-- --------------------------------------------------------
--
-- Table structure for table `user_group`
--
CREATE TABLE IF NOT EXISTS `user_group` (
`user_group_id` int(11) NOT NULL auto_increment,
`name` varchar(64) collate utf8_bin NOT NULL,
`permission` text collate utf8_bin NOT NULL,
PRIMARY KEY (`user_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;
--
-- Dumping data for table `user_group`
--
INSERT INTO `user_group` (`user_group_id`, `name`, `permission`) VALUES
(1, 'Top Administrator', 'a:2:{s:6:"access";a:84:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:19:"catalog/information";i:3;s:20:"catalog/manufacturer";i:4;s:15:"catalog/product";i:5;s:14:"catalog/review";i:6;s:18:"common/filemanager";i:7;s:19:"extension/affiliate";i:8;s:14:"extension/feed";i:9;s:16:"extension/module";i:10;s:17:"extension/payment";i:11;s:18:"extension/shipping";i:12;s:15:"extension/total";i:13;s:16:"feed/google_base";i:14;s:19:"feed/google_sitemap";i:15;s:20:"localisation/country";i:16;s:21:"localisation/currency";i:17;s:21:"localisation/geo_zone";i:18;s:21:"localisation/language";i:19;s:25:"localisation/length_class";i:20;s:25:"localisation/order_status";i:21;s:25:"localisation/stock_status";i:22;s:22:"localisation/tax_class";i:23;s:25:"localisation/weight_class";i:24;s:17:"localisation/zone";i:25;s:17:"module/bestseller";i:26;s:11:"module/cart";i:27;s:15:"module/category";i:28;s:15:"module/featured";i:29;s:23:"module/google_analytics";i:30;s:18:"module/google_talk";i:31;s:18:"module/information";i:32;s:13:"module/latest";i:33;s:19:"module/manufacturer";i:34;s:14:"module/special";i:35;s:16:"payment/alertpay";i:36;s:24:"payment/authorizenet_aim";i:37;s:21:"payment/bank_transfer";i:38;s:14:"payment/cheque";i:39;s:11:"payment/cod";i:40;s:14:"payment/liqpay";i:41;s:20:"payment/moneybookers";i:42;s:15:"payment/paymate";i:43;s:16:"payment/paypoint";i:44;s:26:"payment/perpetual_payments";i:45;s:14:"payment/pp_pro";i:46;s:17:"payment/pp_pro_uk";i:47;s:19:"payment/pp_standard";i:48;s:15:"payment/sagepay";i:49;s:22:"payment/sagepay_direct";i:50;s:18:"payment/sagepay_us";i:51;s:19:"payment/twocheckout";i:52;s:16:"payment/worldpay";i:53;s:16:"report/purchased";i:54;s:11:"report/sale";i:55;s:13:"report/viewed";i:56;s:12:"sale/contact";i:57;s:11:"sale/coupon";i:58;s:13:"sale/customer";i:59;s:19:"sale/customer_group";i:60;s:10:"sale/order";i:61;s:15:"setting/setting";i:62;s:13:"setting/store";i:63;s:17:"shipping/citylink";i:64;s:13:"shipping/flat";i:65;s:13:"shipping/free";i:66;s:13:"shipping/item";i:67;s:23:"shipping/parcelforce_48";i:68;s:15:"shipping/pickup";i:69;s:19:"shipping/royal_mail";i:70;s:12:"shipping/ups";i:71;s:13:"shipping/usps";i:72;s:15:"shipping/weight";i:73;s:11:"tool/backup";i:74;s:14:"tool/error_log";i:75;s:12:"total/coupon";i:76;s:14:"total/handling";i:77;s:19:"total/low_order_fee";i:78;s:14:"total/shipping";i:79;s:15:"total/sub_total";i:80;s:9:"total/tax";i:81;s:11:"total/total";i:82;s:9:"user/user";i:83;s:20:"user/user_permission";}s:6:"modify";a:84:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:19:"catalog/information";i:3;s:20:"catalog/manufacturer";i:4;s:15:"catalog/product";i:5;s:14:"catalog/review";i:6;s:18:"common/filemanager";i:7;s:19:"extension/affiliate";i:8;s:14:"extension/feed";i:9;s:16:"extension/module";i:10;s:17:"extension/payment";i:11;s:18:"extension/shipping";i:12;s:15:"extension/total";i:13;s:16:"feed/google_base";i:14;s:19:"feed/google_sitemap";i:15;s:20:"localisation/country";i:16;s:21:"localisation/currency";i:17;s:21:"localisation/geo_zone";i:18;s:21:"localisation/language";i:19;s:25:"localisation/length_class";i:20;s:25:"localisation/order_status";i:21;s:25:"localisation/stock_status";i:22;s:22:"localisation/tax_class";i:23;s:25:"localisation/weight_class";i:24;s:17:"localisation/zone";i:25;s:17:"module/bestseller";i:26;s:11:"module/cart";i:27;s:15:"module/category";i:28;s:15:"module/featured";i:29;s:23:"module/google_analytics";i:30;s:18:"module/google_talk";i:31;s:18:"module/information";i:32;s:13:"module/latest";i:33;s:19:"module/manufacturer";i:34;s:14:"module/special";i:35;s:16:"payment/alertpay";i:36;s:24:"payment/authorizenet_aim";i:37;s:21:"payment/bank_transfer";i:38;s:14:"payment/cheque";i:39;s:11:"payment/cod";i:40;s:14:"payment/liqpay";i:41;s:20:"payment/moneybookers";i:42;s:15:"payment/paymate";i:43;s:16:"payment/paypoint";i:44;s:26:"payment/perpetual_payments";i:45;s:14:"payment/pp_pro";i:46;s:17:"payment/pp_pro_uk";i:47;s:19:"payment/pp_standard";i:48;s:15:"payment/sagepay";i:49;s:22:"payment/sagepay_direct";i:50;s:18:"payment/sagepay_us";i:51;s:19:"payment/twocheckout";i:52;s:16:"payment/worldpay";i:53;s:16:"report/purchased";i:54;s:11:"report/sale";i:55;s:13:"report/viewed";i:56;s:12:"sale/contact";i:57;s:11:"sale/coupon";i:58;s:13:"sale/customer";i:59;s:19:"sale/customer_group";i:60;s:10:"sale/order";i:61;s:15:"setting/setting";i:62;s:13:"setting/store";i:63;s:17:"shipping/citylink";i:64;s:13:"shipping/flat";i:65;s:13:"shipping/free";i:66;s:13:"shipping/item";i:67;s:23:"shipping/parcelforce_48";i:68;s:15:"shipping/pickup";i:69;s:19:"shipping/royal_mail";i:70;s:12:"shipping/ups";i:71;s:13:"shipping/usps";i:72;s:15:"shipping/weight";i:73;s:11:"tool/backup";i:74;s:14:"tool/error_log";i:75;s:12:"total/coupon";i:76;s:14:"total/handling";i:77;s:19:"total/low_order_fee";i:78;s:14:"total/shipping";i:79;s:15:"total/sub_total";i:80;s:9:"total/tax";i:81;s:11:"total/total";i:82;s:9:"user/user";i:83;s:20:"user/user_permission";}}'),
(10, 'Demonstration', 'a:1:{s:6:"access";a:81:{i:0;s:16:"catalog/category";i:1;s:16:"catalog/download";i:2;s:19:"catalog/information";i:3;s:20:"catalog/manufacturer";i:4;s:15:"catalog/product";i:5;s:14:"catalog/review";i:6;s:18:"common/filemanager";i:7;s:19:"extension/affiliate";i:8;s:14:"extension/feed";i:9;s:16:"extension/module";i:10;s:17:"extension/payment";i:11;s:18:"extension/shipping";i:12;s:15:"extension/total";i:13;s:16:"feed/google_base";i:14;s:19:"feed/google_sitemap";i:15;s:20:"localisation/country";i:16;s:21:"localisation/currency";i:17;s:21:"localisation/geo_zone";i:18;s:21:"localisation/language";i:19;s:25:"localisation/length_class";i:20;s:25:"localisation/order_status";i:21;s:25:"localisation/stock_status";i:22;s:22:"localisation/tax_class";i:23;s:25:"localisation/weight_class";i:24;s:17:"localisation/zone";i:25;s:17:"module/bestseller";i:26;s:11:"module/cart";i:27;s:15:"module/category";i:28;s:15:"module/featured";i:29;s:23:"module/google_analytics";i:30;s:18:"module/google_talk";i:31;s:18:"module/information";i:32;s:13:"module/latest";i:33;s:19:"module/manufacturer";i:34;s:14:"module/special";i:35;s:16:"payment/alertpay";i:36;s:24:"payment/authorizenet_aim";i:37;s:21:"payment/bank_transfer";i:38;s:14:"payment/cheque";i:39;s:11:"payment/cod";i:40;s:14:"payment/liqpay";i:41;s:20:"payment/moneybookers";i:42;s:15:"payment/paymate";i:43;s:16:"payment/paypoint";i:44;s:26:"payment/perpetual_payments";i:45;s:14:"payment/pp_pro";i:46;s:17:"payment/pp_pro_uk";i:47;s:19:"payment/pp_standard";i:48;s:15:"payment/sagepay";i:49;s:22:"payment/sagepay_direct";i:50;s:18:"payment/sagepay_us";i:51;s:19:"payment/twocheckout";i:52;s:16:"payment/worldpay";i:53;s:16:"report/purchased";i:54;s:11:"report/sale";i:55;s:13:"report/viewed";i:56;s:12:"sale/contact";i:57;s:11:"sale/coupon";i:58;s:13:"sale/customer";i:59;s:19:"sale/customer_group";i:60;s:10:"sale/order";i:61;s:15:"setting/setting";i:62;s:17:"shipping/citylink";i:63;s:13:"shipping/flat";i:64;s:13:"shipping/free";i:65;s:13:"shipping/item";i:66;s:23:"shipping/parcelforce_48";i:67;s:19:"shipping/royal_mail";i:68;s:13:"shipping/usps";i:69;s:15:"shipping/weight";i:70;s:11:"tool/backup";i:71;s:14:"tool/error_log";i:72;s:12:"total/coupon";i:73;s:14:"total/handling";i:74;s:19:"total/low_order_fee";i:75;s:14:"total/shipping";i:76;s:15:"total/sub_total";i:77;s:9:"total/tax";i:78;s:11:"total/total";i:79;s:9:"user/user";i:80;s:20:"user/user_permission";}}');
-- --------------------------------------------------------
--
-- Table structure for table `weight_class`
--
CREATE TABLE IF NOT EXISTS `weight_class` (
`weight_class_id` int(11) NOT NULL auto_increment,
`value` decimal(15,8) NOT NULL default '0.00000000',
PRIMARY KEY (`weight_class_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
--
-- Dumping data for table `weight_class`
--
INSERT INTO `weight_class` (`weight_class_id`, `value`) VALUES
(1, '1.00000000'),
(2, '1000.00000000'),
(5, '2.20460000'),
(6, '35.27400000');
-- --------------------------------------------------------
--
-- Table structure for table `weight_class_description`
--
CREATE TABLE IF NOT EXISTS `weight_class_description` (
`weight_class_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL,
`title` varchar(32) collate utf8_bin NOT NULL,
`unit` varchar(4) collate utf8_bin NOT NULL default '',
PRIMARY KEY (`weight_class_id`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
--
-- Dumping data for table `weight_class_description`
--
INSERT INTO `weight_class_description` (`weight_class_id`, `language_id`, `title`, `unit`) VALUES
(1, 1, 'Kilogram', 'kg'),
(2, 1, 'Gram', 'g'),
(5, 1, 'Pound ', 'lb'),
(6, 1, 'Ounce', 'oz');
-- --------------------------------------------------------
--
-- Table structure for table `zone`
--
CREATE TABLE IF NOT EXISTS `zone` (
`zone_id` int(11) NOT NULL auto_increment,
`country_id` int(11) NOT NULL,
`code` varchar(32) collate utf8_bin NOT NULL default '',
`name` varchar(128) collate utf8_bin NOT NULL,
`status` int(1) NOT NULL default '1',
PRIMARY KEY (`zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3955 ;
--
-- Dumping data for table `zone`
--
INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES
(1, 1, 'BDS', 'Badakhshan', 1),
(2, 1, 'BDG', 'Badghis', 1),
(3, 1, 'BGL', 'Baghlan', 1),
(4, 1, 'BAL', 'Balkh', 1),
(5, 1, 'BAM', 'Bamian', 1),
(6, 1, 'FRA', 'Farah', 1),
(7, 1, 'FYB', 'Faryab', 1),
(8, 1, 'GHA', 'Ghazni', 1),
(9, 1, 'GHO', 'Ghowr', 1),
(10, 1, 'HEL', 'Helmand', 1),
(11, 1, 'HER', 'Herat', 1),
(12, 1, 'JOW', 'Jowzjan', 1),
(13, 1, 'KAB', 'Kabul', 1),
(14, 1, 'KAN', 'Kandahar', 1),
(15, 1, 'KAP', 'Kapisa', 1),
(16, 1, 'KHO', 'Khost', 1),
(17, 1, 'KNR', 'Konar', 1),
(18, 1, 'KDZ', 'Kondoz', 1),
(19, 1, 'LAG', 'Laghman', 1),
(20, 1, 'LOW', 'Lowgar', 1),
(21, 1, 'NAN', 'Nangrahar', 1),
(22, 1, 'NIM', 'Nimruz', 1),
(23, 1, 'NUR', 'Nurestan', 1),
(24, 1, 'ORU', 'Oruzgan', 1),
(25, 1, 'PIA', 'Paktia', 1),
(26, 1, 'PKA', 'Paktika', 1),
(27, 1, 'PAR', 'Parwan', 1),
(28, 1, 'SAM', 'Samangan', 1),
(29, 1, 'SAR', 'Sar-e Pol', 1),
(30, 1, 'TAK', 'Takhar', 1),
(31, 1, 'WAR', 'Wardak', 1),
(32, 1, 'ZAB', 'Zabol', 1),
(33, 2, 'BR', 'Berat', 1),
(34, 2, 'BU', 'Bulqize', 1),
(35, 2, 'DL', 'Delvine', 1),
(36, 2, 'DV', 'Devoll', 1),
(37, 2, 'DI', 'Diber', 1),
(38, 2, 'DR', 'Durres', 1),
(39, 2, 'EL', 'Elbasan', 1),
(40, 2, 'ER', 'Kolonje', 1),
(41, 2, 'FR', 'Fier', 1),
(42, 2, 'GJ', 'Gjirokaster', 1),
(43, 2, 'GR', 'Gramsh', 1),
(44, 2, 'HA', 'Has', 1),
(45, 2, 'KA', 'Kavaje', 1),
(46, 2, 'KB', 'Kurbin', 1),
(47, 2, 'KC', 'Kucove', 1),
(48, 2, 'KO', 'Korce', 1),
(49, 2, 'KR', 'Kruje', 1),
(50, 2, 'KU', 'Kukes', 1),
(51, 2, 'LB', 'Librazhd', 1),
(52, 2, 'LE', 'Lezhe', 1),
(53, 2, 'LU', 'Lushnje', 1),
(54, 2, 'MM', 'Malesi e Madhe', 1),
(55, 2, 'MK', 'Mallakaster', 1),
(56, 2, 'MT', 'Mat', 1),
(57, 2, 'MR', 'Mirdite', 1),
(58, 2, 'PQ', 'Peqin', 1),
(59, 2, 'PR', 'Permet', 1),
(60, 2, 'PG', 'Pogradec', 1),
(61, 2, 'PU', 'Puke', 1),
(62, 2, 'SH', 'Shkoder', 1),
(63, 2, 'SK', 'Skrapar', 1),
(64, 2, 'SR', 'Sarande', 1),
(65, 2, 'TE', 'Tepelene', 1),
(66, 2, 'TP', 'Tropoje', 1),
(67, 2, 'TR', 'Tirane', 1),
(68, 2, 'VL', 'Vlore', 1),
(69, 3, 'ADR', 'Adrar', 1),
(70, 3, 'ADE', 'Ain Defla', 1),
(71, 3, 'ATE', 'Ain Temouchent', 1),
(72, 3, 'ALG', 'Alger', 1),
(73, 3, 'ANN', 'Annaba', 1),
(74, 3, 'BAT', 'Batna', 1),
(75, 3, 'BEC', 'Bechar', 1),
(76, 3, 'BEJ', 'Bejaia', 1),
(77, 3, 'BIS', 'Biskra', 1),
(78, 3, 'BLI', 'Blida', 1),
(79, 3, 'BBA', 'Bordj Bou Arreridj', 1),
(80, 3, 'BOA', 'Bouira', 1),
(81, 3, 'BMD', 'Boumerdes', 1),
(82, 3, 'CHL', 'Chlef', 1),
(83, 3, 'CON', 'Constantine', 1),
(84, 3, 'DJE', 'Djelfa', 1),
(85, 3, 'EBA', 'El Bayadh', 1),
(86, 3, 'EOU', 'El Oued', 1),
(87, 3, 'ETA', 'El Tarf', 1),
(88, 3, 'GHA', 'Ghardaia', 1),
(89, 3, 'GUE', 'Guelma', 1),
(90, 3, 'ILL', 'Illizi', 1),
(91, 3, 'JIJ', 'Jijel', 1),
(92, 3, 'KHE', 'Khenchela', 1),
(93, 3, 'LAG', 'Laghouat', 1),
(94, 3, 'MUA', 'Muaskar', 1),
(95, 3, 'MED', 'Medea', 1),
(96, 3, 'MIL', 'Mila', 1),
(97, 3, 'MOS', 'Mostaganem', 1),
(98, 3, 'MSI', 'M''Sila', 1),
(99, 3, 'NAA', 'Naama', 1),
(100, 3, 'ORA', 'Oran', 1),
(101, 3, 'OUA', 'Ouargla', 1),
(102, 3, 'OEB', 'Oum el-Bouaghi', 1),
(103, 3, 'REL', 'Relizane', 1),
(104, 3, 'SAI', 'Saida', 1),
(105, 3, 'SET', 'Setif', 1),
(106, 3, 'SBA', 'Sidi Bel Abbes', 1),
(107, 3, 'SKI', 'Skikda', 1),
(108, 3, 'SAH', 'Souk Ahras', 1),
(109, 3, 'TAM', 'Tamanghasset', 1),
(110, 3, 'TEB', 'Tebessa', 1),
(111, 3, 'TIA', 'Tiaret', 1),
(112, 3, 'TIN', 'Tindouf', 1),
(113, 3, 'TIP', 'Tipaza', 1),
(114, 3, 'TIS', 'Tissemsilt', 1),
(115, 3, 'TOU', 'Tizi Ouzou', 1),
(116, 3, 'TLE', 'Tlemcen', 1),
(117, 4, 'E', 'Eastern', 1),
(118, 4, 'M', 'Manu''a', 1),
(119, 4, 'R', 'Rose Island', 1),
(120, 4, 'S', 'Swains Island', 1),
(121, 4, 'W', 'Western', 1),
(122, 5, 'ALV', 'Andorra la Vella', 1),
(123, 5, 'CAN', 'Canillo', 1),
(124, 5, 'ENC', 'Encamp', 1),
(125, 5, 'ESE', 'Escaldes-Engordany', 1),
(126, 5, 'LMA', 'La Massana', 1),
(127, 5, 'ORD', 'Ordino', 1),
(128, 5, 'SJL', 'Sant Julia de Loria', 1),
(129, 6, 'BGO', 'Bengo', 1),
(130, 6, 'BGU', 'Benguela', 1),
(131, 6, 'BIE', 'Bie', 1),
(132, 6, 'CAB', 'Cabinda', 1),
(133, 6, 'CCU', 'Cuando-Cubango', 1),
(134, 6, 'CNO', 'Cuanza Norte', 1),
(135, 6, 'CUS', 'Cuanza Sul', 1),
(136, 6, 'CNN', 'Cunene', 1),
(137, 6, 'HUA', 'Huambo', 1),
(138, 6, 'HUI', 'Huila', 1),
(139, 6, 'LUA', 'Luanda', 1),
(140, 6, 'LNO', 'Lunda Norte', 1),
(141, 6, 'LSU', 'Lunda Sul', 1),
(142, 6, 'MAL', 'Malange', 1),
(143, 6, 'MOX', 'Moxico', 1),
(144, 6, 'NAM', 'Namibe', 1),
(145, 6, 'UIG', 'Uige', 1),
(146, 6, 'ZAI', 'Zaire', 1),
(147, 9, 'ASG', 'Saint George', 1),
(148, 9, 'ASJ', 'Saint John', 1),
(149, 9, 'ASM', 'Saint Mary', 1),
(150, 9, 'ASL', 'Saint Paul', 1),
(151, 9, 'ASR', 'Saint Peter', 1),
(152, 9, 'ASH', 'Saint Philip', 1),
(153, 9, 'BAR', 'Barbuda', 1),
(154, 9, 'RED', 'Redonda', 1),
(155, 10, 'AN', 'Antartida e Islas del Atlantico', 1),
(156, 10, 'BA', 'Buenos Aires', 1),
(157, 10, 'CA', 'Catamarca', 1),
(158, 10, 'CH', 'Chaco', 1),
(159, 10, 'CU', 'Chubut', 1),
(160, 10, 'CO', 'Cordoba', 1),
(161, 10, 'CR', 'Corrientes', 1),
(162, 10, 'DF', 'Distrito Federal', 1),
(163, 10, 'ER', 'Entre Rios', 1),
(164, 10, 'FO', 'Formosa', 1),
(165, 10, 'JU', 'Jujuy', 1),
(166, 10, 'LP', 'La Pampa', 1),
(167, 10, 'LR', 'La Rioja', 1),
(168, 10, 'ME', 'Mendoza', 1),
(169, 10, 'MI', 'Misiones', 1),
(170, 10, 'NE', 'Neuquen', 1),
(171, 10, 'RN', 'Rio Negro', 1),
(172, 10, 'SA', 'Salta', 1),
(173, 10, 'SJ', 'San Juan', 1),
(174, 10, 'SL', 'San Luis', 1),
(175, 10, 'SC', 'Santa Cruz', 1),
(176, 10, 'SF', 'Santa Fe', 1),
(177, 10, 'SD', 'Santiago del Estero', 1),
(178, 10, 'TF', 'Tierra del Fuego', 1),
(179, 10, 'TU', 'Tucuman', 1),
(180, 11, 'AGT', 'Aragatsotn', 1),
(181, 11, 'ARR', 'Ararat', 1),
(182, 11, 'ARM', 'Armavir', 1),
(183, 11, 'GEG', 'Geghark''unik''', 1),
(184, 11, 'KOT', 'Kotayk''', 1),
(185, 11, 'LOR', 'Lorri', 1),
(186, 11, 'SHI', 'Shirak', 1),
(187, 11, 'SYU', 'Syunik''', 1),
(188, 11, 'TAV', 'Tavush', 1),
(189, 11, 'VAY', 'Vayots'' Dzor', 1),
(190, 11, 'YER', 'Yerevan', 1),
(191, 13, 'ACT', 'Australian Capital Territory', 1),
(192, 13, 'NSW', 'New South Wales', 1),
(193, 13, 'NT', 'Northern Territory', 1),
(194, 13, 'QLD', 'Queensland', 1),
(195, 13, 'SA', 'South Australia', 1),
(196, 13, 'TAS', 'Tasmania', 1),
(197, 13, 'VIC', 'Victoria', 1),
(198, 13, 'WA', 'Western Australia', 1),
(199, 14, 'BUR', 'Burgenland', 1),
(200, 14, 'KAR', 'Kärnten', 1),
(201, 14, 'NOS', 'Niederösterreich', 1),
(202, 14, 'OOS', 'Oberösterreich', 1),
(203, 14, 'SAL', 'Salzburg', 1),
(204, 14, 'STE', 'Steiermark', 1),
(205, 14, 'TIR', 'Tirol', 1),
(206, 14, 'VOR', 'Vorarlberg', 1),
(207, 14, 'WIE', 'Wien', 1),
(208, 15, 'AB', 'Ali Bayramli', 1),
(209, 15, 'ABS', 'Abseron', 1),
(210, 15, 'AGC', 'AgcabAdi', 1),
(211, 15, 'AGM', 'Agdam', 1),
(212, 15, 'AGS', 'Agdas', 1),
(213, 15, 'AGA', 'Agstafa', 1),
(214, 15, 'AGU', 'Agsu', 1),
(215, 15, 'AST', 'Astara', 1),
(216, 15, 'BA', 'Baki', 1),
(217, 15, 'BAB', 'BabAk', 1),
(218, 15, 'BAL', 'BalakAn', 1),
(219, 15, 'BAR', 'BArdA', 1),
(220, 15, 'BEY', 'Beylaqan', 1),
(221, 15, 'BIL', 'Bilasuvar', 1),
(222, 15, 'CAB', 'Cabrayil', 1),
(223, 15, 'CAL', 'Calilabab', 1),
(224, 15, 'CUL', 'Culfa', 1),
(225, 15, 'DAS', 'Daskasan', 1),
(226, 15, 'DAV', 'Davaci', 1),
(227, 15, 'FUZ', 'Fuzuli', 1),
(228, 15, 'GA', 'Ganca', 1),
(229, 15, 'GAD', 'Gadabay', 1),
(230, 15, 'GOR', 'Goranboy', 1),
(231, 15, 'GOY', 'Goycay', 1),
(232, 15, 'HAC', 'Haciqabul', 1),
(233, 15, 'IMI', 'Imisli', 1),
(234, 15, 'ISM', 'Ismayilli', 1),
(235, 15, 'KAL', 'Kalbacar', 1),
(236, 15, 'KUR', 'Kurdamir', 1),
(237, 15, 'LA', 'Lankaran', 1),
(238, 15, 'LAC', 'Lacin', 1),
(239, 15, 'LAN', 'Lankaran', 1),
(240, 15, 'LER', 'Lerik', 1),
(241, 15, 'MAS', 'Masalli', 1),
(242, 15, 'MI', 'Mingacevir', 1),
(243, 15, 'NA', 'Naftalan', 1),
(244, 15, 'NEF', 'Neftcala', 1),
(245, 15, 'OGU', 'Oguz', 1),
(246, 15, 'ORD', 'Ordubad', 1),
(247, 15, 'QAB', 'Qabala', 1),
(248, 15, 'QAX', 'Qax', 1),
(249, 15, 'QAZ', 'Qazax', 1),
(250, 15, 'QOB', 'Qobustan', 1),
(251, 15, 'QBA', 'Quba', 1),
(252, 15, 'QBI', 'Qubadli', 1),
(253, 15, 'QUS', 'Qusar', 1),
(254, 15, 'SA', 'Saki', 1),
(255, 15, 'SAT', 'Saatli', 1),
(256, 15, 'SAB', 'Sabirabad', 1),
(257, 15, 'SAD', 'Sadarak', 1),
(258, 15, 'SAH', 'Sahbuz', 1),
(259, 15, 'SAK', 'Saki', 1),
(260, 15, 'SAL', 'Salyan', 1),
(261, 15, 'SM', 'Sumqayit', 1),
(262, 15, 'SMI', 'Samaxi', 1),
(263, 15, 'SKR', 'Samkir', 1),
(264, 15, 'SMX', 'Samux', 1),
(265, 15, 'SAR', 'Sarur', 1),
(266, 15, 'SIY', 'Siyazan', 1),
(267, 15, 'SS', 'Susa', 1),
(268, 15, 'SUS', 'Susa', 1),
(269, 15, 'TAR', 'Tartar', 1),
(270, 15, 'TOV', 'Tovuz', 1),
(271, 15, 'UCA', 'Ucar', 1),
(272, 15, 'XA', 'Xankandi', 1),
(273, 15, 'XAC', 'Xacmaz', 1),
(274, 15, 'XAN', 'Xanlar', 1),
(275, 15, 'XIZ', 'Xizi', 1),
(276, 15, 'XCI', 'Xocali', 1),
(277, 15, 'XVD', 'Xocavand', 1),
(278, 15, 'YAR', 'Yardimli', 1),
(279, 15, 'YEV', 'Yevlax', 1),
(280, 15, 'ZAN', 'Zangilan', 1),
(281, 15, 'ZAQ', 'Zaqatala', 1),
(282, 15, 'ZAR', 'Zardab', 1),
(283, 15, 'NX', 'Naxcivan', 1),
(284, 16, 'ACK', 'Acklins', 1),
(285, 16, 'BER', 'Berry Islands', 1),
(286, 16, 'BIM', 'Bimini', 1),
(287, 16, 'BLK', 'Black Point', 1),
(288, 16, 'CAT', 'Cat Island', 1),
(289, 16, 'CAB', 'Central Abaco', 1),
(290, 16, 'CAN', 'Central Andros', 1),
(291, 16, 'CEL', 'Central Eleuthera', 1),
(292, 16, 'FRE', 'City of Freeport', 1),
(293, 16, 'CRO', 'Crooked Island', 1),
(294, 16, 'EGB', 'East Grand Bahama', 1),
(295, 16, 'EXU', 'Exuma', 1),
(296, 16, 'GRD', 'Grand Cay', 1),
(297, 16, 'HAR', 'Harbour Island', 1),
(298, 16, 'HOP', 'Hope Town', 1),
(299, 16, 'INA', 'Inagua', 1),
(300, 16, 'LNG', 'Long Island', 1),
(301, 16, 'MAN', 'Mangrove Cay', 1),
(302, 16, 'MAY', 'Mayaguana', 1),
(303, 16, 'MOO', 'Moore''s Island', 1),
(304, 16, 'NAB', 'North Abaco', 1),
(305, 16, 'NAN', 'North Andros', 1),
(306, 16, 'NEL', 'North Eleuthera', 1),
(307, 16, 'RAG', 'Ragged Island', 1),
(308, 16, 'RUM', 'Rum Cay', 1),
(309, 16, 'SAL', 'San Salvador', 1),
(310, 16, 'SAB', 'South Abaco', 1),
(311, 16, 'SAN', 'South Andros', 1),
(312, 16, 'SEL', 'South Eleuthera', 1),
(313, 16, 'SWE', 'Spanish Wells', 1),
(314, 16, 'WGB', 'West Grand Bahama', 1),
(315, 17, 'CAP', 'Capital', 1),
(316, 17, 'CEN', 'Central', 1),
(317, 17, 'MUH', 'Muharraq', 1),
(318, 17, 'NOR', 'Northern', 1),
(319, 17, 'SOU', 'Southern', 1),
(320, 18, 'BAR', 'Barisal', 1),
(321, 18, 'CHI', 'Chittagong', 1),
(322, 18, 'DHA', 'Dhaka', 1),
(323, 18, 'KHU', 'Khulna', 1),
(324, 18, 'RAJ', 'Rajshahi', 1),
(325, 18, 'SYL', 'Sylhet', 1),
(326, 19, 'CC', 'Christ Church', 1),
(327, 19, 'AND', 'Saint Andrew', 1),
(328, 19, 'GEO', 'Saint George', 1),
(329, 19, 'JAM', 'Saint James', 1),
(330, 19, 'JOH', 'Saint John', 1),
(331, 19, 'JOS', 'Saint Joseph', 1),
(332, 19, 'LUC', 'Saint Lucy', 1),
(333, 19, 'MIC', 'Saint Michael', 1),
(334, 19, 'PET', 'Saint Peter', 1),
(335, 19, 'PHI', 'Saint Philip', 1),
(336, 19, 'THO', 'Saint Thomas', 1),
(337, 20, 'BR', 'Brestskaya (Brest)', 1),
(338, 20, 'HO', 'Homyel''skaya (Homyel'')', 1),
(339, 20, 'HM', 'Horad Minsk', 1),
(340, 20, 'HR', 'Hrodzyenskaya (Hrodna)', 1),
(341, 20, 'MA', 'Mahilyowskaya (Mahilyow)', 1),
(342, 20, 'MI', 'Minskaya', 1),
(343, 20, 'VI', 'Vitsyebskaya (Vitsyebsk)', 1),
(344, 21, 'VAN', 'Antwerpen', 1),
(345, 21, 'WBR', 'Brabant Wallon', 1),
(346, 21, 'WHT', 'Hainaut', 1),
(347, 21, 'WLG', 'Liege', 1),
(348, 21, 'VLI', 'Limburg', 1),
(349, 21, 'WLX', 'Luxembourg', 1),
(350, 21, 'WNA', 'Namur', 1),
(351, 21, 'VOV', 'Oost-Vlaanderen', 1),
(352, 21, 'VBR', 'Vlaams Brabant', 1),
(353, 21, 'VWV', 'West-Vlaanderen', 1),
(354, 22, 'BZ', 'Belize', 1),
(355, 22, 'CY', 'Cayo', 1),
(356, 22, 'CR', 'Corozal', 1),
(357, 22, 'OW', 'Orange Walk', 1),
(358, 22, 'SC', 'Stann Creek', 1),
(359, 22, 'TO', 'Toledo', 1),
(360, 23, 'AL', 'Alibori', 1),
(361, 23, 'AK', 'Atakora', 1),
(362, 23, 'AQ', 'Atlantique', 1),
(363, 23, 'BO', 'Borgou', 1),
(364, 23, 'CO', 'Collines', 1),
(365, 23, 'DO', 'Donga', 1),
(366, 23, 'KO', 'Kouffo', 1),
(367, 23, 'LI', 'Littoral', 1),
(368, 23, 'MO', 'Mono', 1),
(369, 23, 'OU', 'Oueme', 1),
(370, 23, 'PL', 'Plateau', 1),
(371, 23, 'ZO', 'Zou', 1),
(372, 24, 'DS', 'Devonshire', 1),
(373, 24, 'HC', 'Hamilton City', 1),
(374, 24, 'HA', 'Hamilton', 1),
(375, 24, 'PG', 'Paget', 1),
(376, 24, 'PB', 'Pembroke', 1),
(377, 24, 'GC', 'Saint George City', 1),
(378, 24, 'SG', 'Saint George''s', 1),
(379, 24, 'SA', 'Sandys', 1),
(380, 24, 'SM', 'Smith''s', 1),
(381, 24, 'SH', 'Southampton', 1),
(382, 24, 'WA', 'Warwick', 1),
(383, 25, 'BUM', 'Bumthang', 1),
(384, 25, 'CHU', 'Chukha', 1),
(385, 25, 'DAG', 'Dagana', 1),
(386, 25, 'GAS', 'Gasa', 1),
(387, 25, 'HAA', 'Haa', 1),
(388, 25, 'LHU', 'Lhuntse', 1),
(389, 25, 'MON', 'Mongar', 1),
(390, 25, 'PAR', 'Paro', 1),
(391, 25, 'PEM', 'Pemagatshel', 1),
(392, 25, 'PUN', 'Punakha', 1),
(393, 25, 'SJO', 'Samdrup Jongkhar', 1),
(394, 25, 'SAT', 'Samtse', 1),
(395, 25, 'SAR', 'Sarpang', 1),
(396, 25, 'THI', 'Thimphu', 1),
(397, 25, 'TRG', 'Trashigang', 1),
(398, 25, 'TRY', 'Trashiyangste', 1),
(399, 25, 'TRO', 'Trongsa', 1),
(400, 25, 'TSI', 'Tsirang', 1),
(401, 25, 'WPH', 'Wangdue Phodrang', 1),
(402, 25, 'ZHE', 'Zhemgang', 1),
(403, 26, 'BEN', 'Beni', 1),
(404, 26, 'CHU', 'Chuquisaca', 1),
(405, 26, 'COC', 'Cochabamba', 1),
(406, 26, 'LPZ', 'La Paz', 1),
(407, 26, 'ORU', 'Oruro', 1),
(408, 26, 'PAN', 'Pando', 1),
(409, 26, 'POT', 'Potosi', 1),
(410, 26, 'SCZ', 'Santa Cruz', 1),
(411, 26, 'TAR', 'Tarija', 1),
(412, 27, 'BRO', 'Brcko district', 1),
(413, 27, 'FUS', 'Unsko-Sanski Kanton', 1),
(414, 27, 'FPO', 'Posavski Kanton', 1),
(415, 27, 'FTU', 'Tuzlanski Kanton', 1),
(416, 27, 'FZE', 'Zenicko-Dobojski Kanton', 1),
(417, 27, 'FBP', 'Bosanskopodrinjski Kanton', 1),
(418, 27, 'FSB', 'Srednjebosanski Kanton', 1),
(419, 27, 'FHN', 'Hercegovacko-neretvanski Kanton', 1),
(420, 27, 'FZH', 'Zapadnohercegovacka Zupanija', 1),
(421, 27, 'FSA', 'Kanton Sarajevo', 1),
(422, 27, 'FZA', 'Zapadnobosanska', 1),
(423, 27, 'SBL', 'Banja Luka', 1),
(424, 27, 'SDO', 'Doboj', 1),
(425, 27, 'SBI', 'Bijeljina', 1),
(426, 27, 'SVL', 'Vlasenica', 1),
(427, 27, 'SSR', 'Sarajevo-Romanija or Sokolac', 1),
(428, 27, 'SFO', 'Foca', 1),
(429, 27, 'STR', 'Trebinje', 1),
(430, 28, 'CE', 'Central', 1),
(431, 28, 'GH', 'Ghanzi', 1),
(432, 28, 'KD', 'Kgalagadi', 1),
(433, 28, 'KT', 'Kgatleng', 1),
(434, 28, 'KW', 'Kweneng', 1),
(435, 28, 'NG', 'Ngamiland', 1),
(436, 28, 'NE', 'North East', 1),
(437, 28, 'NW', 'North West', 1),
(438, 28, 'SE', 'South East', 1),
(439, 28, 'SO', 'Southern', 1),
(440, 30, 'AC', 'Acre', 1),
(441, 30, 'AL', 'Alagoas', 1),
(442, 30, 'AP', 'Amapa', 1),
(443, 30, 'AM', 'Amazonas', 1),
(444, 30, 'BA', 'Bahia', 1),
(445, 30, 'CE', 'Ceara', 1),
(446, 30, 'DF', 'Distrito Federal', 1),
(447, 30, 'ES', 'Espirito Santo', 1),
(448, 30, 'GO', 'Goias', 1),
(449, 30, 'MA', 'Maranhao', 1),
(450, 30, 'MT', 'Mato Grosso', 1),
(451, 30, 'MS', 'Mato Grosso do Sul', 1),
(452, 30, 'MG', 'Minas Gerais', 1),
(453, 30, 'PA', 'Para', 1),
(454, 30, 'PB', 'Paraiba', 1),
(455, 30, 'PR', 'Parana', 1),
(456, 30, 'PE', 'Pernambuco', 1),
(457, 30, 'PI', 'Piaui', 1),
(458, 30, 'RJ', 'Rio de Janeiro', 1),
(459, 30, 'RN', 'Rio Grande do Norte', 1),
(460, 30, 'RS', 'Rio Grande do Sul', 1),
(461, 30, 'RO', 'Rondonia', 1),
(462, 30, 'RR', 'Roraima', 1),
(463, 30, 'SC', 'Santa Catarina', 1),
(464, 30, 'SP', 'Sao Paulo', 1),
(465, 30, 'SE', 'Sergipe', 1),
(466, 30, 'TO', 'Tocantins', 1),
(467, 31, 'PB', 'Peros Banhos', 1),
(468, 31, 'SI', 'Salomon Islands', 1),
(469, 31, 'NI', 'Nelsons Island', 1),
(470, 31, 'TB', 'Three Brothers', 1),
(471, 31, 'EA', 'Eagle Islands', 1),
(472, 31, 'DI', 'Danger Island', 1),
(473, 31, 'EG', 'Egmont Islands', 1),
(474, 31, 'DG', 'Diego Garcia', 1),
(475, 32, 'BEL', 'Belait', 1),
(476, 32, 'BRM', 'Brunei and Muara', 1),
(477, 32, 'TEM', 'Temburong', 1),
(478, 32, 'TUT', 'Tutong', 1),
(479, 33, '', 'Blagoevgrad', 1),
(480, 33, '', 'Burgas', 1),
(481, 33, '', 'Dobrich', 1),
(482, 33, '', 'Gabrovo', 1),
(483, 33, '', 'Haskovo', 1),
(484, 33, '', 'Kardjali', 1),
(485, 33, '', 'Kyustendil', 1),
(486, 33, '', 'Lovech', 1),
(487, 33, '', 'Montana', 1),
(488, 33, '', 'Pazardjik', 1),
(489, 33, '', 'Pernik', 1),
(490, 33, '', 'Pleven', 1),
(491, 33, '', 'Plovdiv', 1),
(492, 33, '', 'Razgrad', 1),
(493, 33, '', 'Shumen', 1),
(494, 33, '', 'Silistra', 1),
(495, 33, '', 'Sliven', 1),
(496, 33, '', 'Smolyan', 1),
(497, 33, '', 'Sofia', 1),
(498, 33, '', 'Sofia - town', 1),
(499, 33, '', 'Stara Zagora', 1),
(500, 33, '', 'Targovishte', 1),
(501, 33, '', 'Varna', 1),
(502, 33, '', 'Veliko Tarnovo', 1),
(503, 33, '', 'Vidin', 1),
(504, 33, '', 'Vratza', 1),
(505, 33, '', 'Yambol', 1),
(506, 34, 'BAL', 'Bale', 1),
(507, 34, 'BAM', 'Bam', 1),
(508, 34, 'BAN', 'Banwa', 1),
(509, 34, 'BAZ', 'Bazega', 1),
(510, 34, 'BOR', 'Bougouriba', 1),
(511, 34, 'BLG', 'Boulgou', 1),
(512, 34, 'BOK', 'Boulkiemde', 1),
(513, 34, 'COM', 'Comoe', 1),
(514, 34, 'GAN', 'Ganzourgou', 1),
(515, 34, 'GNA', 'Gnagna', 1),
(516, 34, 'GOU', 'Gourma', 1),
(517, 34, 'HOU', 'Houet', 1),
(518, 34, 'IOA', 'Ioba', 1),
(519, 34, 'KAD', 'Kadiogo', 1),
(520, 34, 'KEN', 'Kenedougou', 1),
(521, 34, 'KOD', 'Komondjari', 1),
(522, 34, 'KOP', 'Kompienga', 1),
(523, 34, 'KOS', 'Kossi', 1),
(524, 34, 'KOL', 'Koulpelogo', 1),
(525, 34, 'KOT', 'Kouritenga', 1),
(526, 34, 'KOW', 'Kourweogo', 1),
(527, 34, 'LER', 'Leraba', 1),
(528, 34, 'LOR', 'Loroum', 1),
(529, 34, 'MOU', 'Mouhoun', 1),
(530, 34, 'NAH', 'Nahouri', 1),
(531, 34, 'NAM', 'Namentenga', 1),
(532, 34, 'NAY', 'Nayala', 1),
(533, 34, 'NOU', 'Noumbiel', 1),
(534, 34, 'OUB', 'Oubritenga', 1),
(535, 34, 'OUD', 'Oudalan', 1),
(536, 34, 'PAS', 'Passore', 1),
(537, 34, 'PON', 'Poni', 1),
(538, 34, 'SAG', 'Sanguie', 1),
(539, 34, 'SAM', 'Sanmatenga', 1),
(540, 34, 'SEN', 'Seno', 1),
(541, 34, 'SIS', 'Sissili', 1),
(542, 34, 'SOM', 'Soum', 1),
(543, 34, 'SOR', 'Sourou', 1),
(544, 34, 'TAP', 'Tapoa', 1),
(545, 34, 'TUY', 'Tuy', 1),
(546, 34, 'YAG', 'Yagha', 1),
(547, 34, 'YAT', 'Yatenga', 1),
(548, 34, 'ZIR', 'Ziro', 1),
(549, 34, 'ZOD', 'Zondoma', 1),
(550, 34, 'ZOW', 'Zoundweogo', 1),
(551, 35, 'BB', 'Bubanza', 1),
(552, 35, 'BJ', 'Bujumbura', 1),
(553, 35, 'BR', 'Bururi', 1),
(554, 35, 'CA', 'Cankuzo', 1),
(555, 35, 'CI', 'Cibitoke', 1),
(556, 35, 'GI', 'Gitega', 1),
(557, 35, 'KR', 'Karuzi', 1),
(558, 35, 'KY', 'Kayanza', 1),
(559, 35, 'KI', 'Kirundo', 1),
(560, 35, 'MA', 'Makamba', 1),
(561, 35, 'MU', 'Muramvya', 1),
(562, 35, 'MY', 'Muyinga', 1),
(563, 35, 'MW', 'Mwaro', 1),
(564, 35, 'NG', 'Ngozi', 1),
(565, 35, 'RT', 'Rutana', 1),
(566, 35, 'RY', 'Ruyigi', 1),
(567, 36, 'PP', 'Phnom Penh', 1),
(568, 36, 'PS', 'Preah Seihanu (Kompong Som or Sihanoukville)', 1),
(569, 36, 'PA', 'Pailin', 1),
(570, 36, 'KB', 'Keb', 1),
(571, 36, 'BM', 'Banteay Meanchey', 1),
(572, 36, 'BA', 'Battambang', 1),
(573, 36, 'KM', 'Kampong Cham', 1),
(574, 36, 'KN', 'Kampong Chhnang', 1),
(575, 36, 'KU', 'Kampong Speu', 1),
(576, 36, 'KO', 'Kampong Som', 1),
(577, 36, 'KT', 'Kampong Thom', 1),
(578, 36, 'KP', 'Kampot', 1),
(579, 36, 'KL', 'Kandal', 1),
(580, 36, 'KK', 'Kaoh Kong', 1),
(581, 36, 'KR', 'Kratie', 1),
(582, 36, 'MK', 'Mondul Kiri', 1),
(583, 36, 'OM', 'Oddar Meancheay', 1),
(584, 36, 'PU', 'Pursat', 1),
(585, 36, 'PR', 'Preah Vihear', 1),
(586, 36, 'PG', 'Prey Veng', 1),
(587, 36, 'RK', 'Ratanak Kiri', 1),
(588, 36, 'SI', 'Siemreap', 1),
(589, 36, 'ST', 'Stung Treng', 1),
(590, 36, 'SR', 'Svay Rieng', 1),
(591, 36, 'TK', 'Takeo', 1),
(592, 37, 'ADA', 'Adamawa (Adamaoua)', 1),
(593, 37, 'CEN', 'Centre', 1),
(594, 37, 'EST', 'East (Est)', 1),
(595, 37, 'EXN', 'Extreme North (Extreme-Nord)', 1),
(596, 37, 'LIT', 'Littoral', 1),
(597, 37, 'NOR', 'North (Nord)', 1),
(598, 37, 'NOT', 'Northwest (Nord-Ouest)', 1),
(599, 37, 'OUE', 'West (Ouest)', 1),
(600, 37, 'SUD', 'South (Sud)', 1),
(601, 37, 'SOU', 'Southwest (Sud-Ouest).', 1),
(602, 38, 'AB', 'Alberta', 1),
(603, 38, 'BC', 'British Columbia', 1),
(604, 38, 'MB', 'Manitoba', 1),
(605, 38, 'NB', 'New Brunswick', 1),
(606, 38, 'NL', 'Newfoundland and Labrador', 1),
(607, 38, 'NT', 'Northwest Territories', 1),
(608, 38, 'NS', 'Nova Scotia', 1),
(609, 38, 'NU', 'Nunavut', 1),
(610, 38, 'ON', 'Ontario', 1),
(611, 38, 'PE', 'Prince Edward Island', 1),
(612, 38, 'QC', 'Québec', 1),
(613, 38, 'SK', 'Saskatchewan', 1),
(614, 38, 'YT', 'Yukon Territory', 1),
(615, 39, 'BV', 'Boa Vista', 1),
(616, 39, 'BR', 'Brava', 1),
(617, 39, 'CS', 'Calheta de Sao Miguel', 1),
(618, 39, 'MA', 'Maio', 1),
(619, 39, 'MO', 'Mosteiros', 1),
(620, 39, 'PA', 'Paul', 1),
(621, 39, 'PN', 'Porto Novo', 1),
(622, 39, 'PR', 'Praia', 1),
(623, 39, 'RG', 'Ribeira Grande', 1),
(624, 39, 'SL', 'Sal', 1),
(625, 39, 'CA', 'Santa Catarina', 1),
(626, 39, 'CR', 'Santa Cruz', 1),
(627, 39, 'SD', 'Sao Domingos', 1),
(628, 39, 'SF', 'Sao Filipe', 1),
(629, 39, 'SN', 'Sao Nicolau', 1),
(630, 39, 'SV', 'Sao Vicente', 1),