rendered paste body-- phpMyAdmin SQL Dump-- version 2.9.1.1-Debian-2ubuntu1-- http://www.phpmyadmin.net-- -- Host: localhost-- Generation Time: Jul 24, 2007 at 11:50 AM-- Server version: 5.0.38-- PHP Version: 5.2.1-- -- Database: `sequoia`-- -- ---------------------------------------------------------- -- Table structure for table `acos`-- DROP TABLE IF EXISTS `acos`;CREATE TABLE `acos` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `model` varchar(255) default '', `foreign_key` int(11) default NULL, `alias` varchar(255) default '', `lft` int(11) default NULL, `rght` int(11) default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `acos`-- -- ---------------------------------------------------------- -- Table structure for table `aros`-- DROP TABLE IF EXISTS `aros`;CREATE TABLE `aros` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default NULL, `model` varchar(255) default '', `foreign_key` int(11) default NULL, `alias` varchar(255) default '', `lft` int(11) default NULL, `rght` int(11) default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `aros`-- -- ---------------------------------------------------------- -- Table structure for table `aros_acos`-- DROP TABLE IF EXISTS `aros_acos`;CREATE TABLE `aros_acos` ( `id` int(11) NOT NULL auto_increment, `aro_id` int(11) default NULL, `aco_id` int(11) default NULL, `_create` int(11) NOT NULL default '0', `_read` int(11) NOT NULL default '0', `_update` int(11) NOT NULL default '0', `_delete` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `aros_acos`-- -- ---------------------------------------------------------- -- Table structure for table `baskets`-- DROP TABLE IF EXISTS `baskets`;CREATE TABLE `baskets` ( `id` int(8) unsigned NOT NULL auto_increment, `session` varchar(255) collate utf8_unicode_ci NOT NULL, `customer_id` int(8) NOT NULL, `order_id` int(8) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `baskets`-- -- ---------------------------------------------------------- -- Table structure for table `baskets_products`-- DROP TABLE IF EXISTS `baskets_products`;CREATE TABLE `baskets_products` ( `basket_id` int(8) unsigned NOT NULL, `product_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;-- -- Dumping data for table `baskets_products`-- -- ---------------------------------------------------------- -- Table structure for table `branches`-- DROP TABLE IF EXISTS `branches`;CREATE TABLE `branches` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `tags` varchar(255) NOT NULL, `lft` int(8) unsigned NOT NULL, `rght` int(8) unsigned NOT NULL, `image_id` int(8) unsigned NOT NULL, `parent_id` int(8) NOT NULL, `theme_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `branches`-- -- ---------------------------------------------------------- -- Table structure for table `branches_feeds`-- DROP TABLE IF EXISTS `branches_feeds`;CREATE TABLE `branches_feeds` ( `branch_id` int(8) unsigned NOT NULL, `feed_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_feeds`-- -- ---------------------------------------------------------- -- Table structure for table `branches_galleries`-- DROP TABLE IF EXISTS `branches_galleries`;CREATE TABLE `branches_galleries` ( `branch_id` int(8) unsigned NOT NULL, `gallery_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_galleries`-- -- ---------------------------------------------------------- -- Table structure for table `branches_images`-- DROP TABLE IF EXISTS `branches_images`;CREATE TABLE `branches_images` ( `branch_id` int(8) unsigned NOT NULL, `image_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_images`-- -- ---------------------------------------------------------- -- Table structure for table `branches_maps`-- DROP TABLE IF EXISTS `branches_maps`;CREATE TABLE `branches_maps` ( `branch_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_maps`-- -- ---------------------------------------------------------- -- Table structure for table `branches_products`-- DROP TABLE IF EXISTS `branches_products`;CREATE TABLE `branches_products` ( `branch_id` int(8) unsigned NOT NULL, `product_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_products`-- -- ---------------------------------------------------------- -- Table structure for table `branches_tags`-- DROP TABLE IF EXISTS `branches_tags`;CREATE TABLE `branches_tags` ( `branch_id` int(8) unsigned NOT NULL, `tag_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `branches_tags`-- -- ---------------------------------------------------------- -- Table structure for table `countries`-- DROP TABLE IF EXISTS `countries`;CREATE TABLE `countries` ( `countries_id` int(11) NOT NULL auto_increment, `continents_code` char(3) NOT NULL, `countries_iso_code_2` char(2) NOT NULL, `countries_iso_code_3` char(3) NOT NULL, `countries_number` char(3) NOT NULL, `countries_name` varchar(64) NOT NULL, `address_format_id` int(11) NOT NULL default '1', PRIMARY KEY (`countries_id`), KEY `countries_name` (`countries_name`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=244 ;-- -- Dumping data for table `countries`-- INSERT INTO `countries` (`countries_id`, `continents_code`, `countries_iso_code_2`, `countries_iso_code_3`, `countries_number`, `countries_name`, `address_format_id`) VALUES (1, 'AS', 'AF', 'AFG', '004', 'Afghanistan', 1),(2, 'EU', 'AX', 'ALA', '248', 'Åland Islands', 1),(3, 'EU', 'AL', 'ALB', '008', 'Albania', 1),(4, 'AF', 'DZ', 'DZA', '012', 'Algeria', 1),(5, 'OC', 'AS', 'ASM', '016', 'American Samoa', 1),(6, 'EU', 'AD', 'AND', '020', 'Andorra', 1),(7, 'AF', 'AO', 'AGO', '024', 'Angola', 1),(8, 'NA', 'AI', 'AIA', '660', 'Anguilla', 1),(9, 'AN', 'AQ', 'ATA', '010', 'Antarctica', 1),(10, 'NA', 'AG', 'ATG', '028', 'Antigua and Barbuda', 1),(11, 'SA', 'AR', 'ARG', '032', 'Argentina', 1),(12, 'AS', 'AM', 'ARM', '051', 'Armenia', 1),(13, 'NA', 'AW', 'ABW', '533', 'Aruba', 1),(14, 'OC', 'AU', 'AUS', '036', 'Australia', 1),(15, 'EU', 'AT', 'AUT', '040', 'Austria', 1),(16, 'AS', 'AZ', 'AZE', '031', 'Azerbaijan', 1),(17, 'NA', 'BS', 'BHS', '044', 'Bahamas', 1),(18, 'AS', 'BH', 'BHR', '048', 'Bahrain', 1),(19, 'AS', 'BD', 'BGD', '050', 'Bangladesh', 1),(20, 'NA', 'BB', 'BRB', '052', 'Barbados', 1),(21, 'EU', 'BY', 'BLR', '112', 'Belarus', 1),(22, 'EU', 'BE', 'BEL', '056', 'Belgium', 1),(23, 'NA', 'BZ', 'BLZ', '084', 'Belize', 1),(24, 'AF', 'BJ', 'BEN', '204', 'Benin', 1),(25, 'NA', 'BM', 'BMU', '060', 'Bermuda', 1),(26, 'AS', 'BT', 'BTN', '064', 'Bhutan', 1),(27, 'SA', 'BO', 'BOL', '068', 'Bolivia', 1),(28, 'EU', 'BA', 'BIH', '070', 'Bosnia and Herzegovina', 1),(29, 'AF', 'BW', 'BWA', '072', 'Botswana', 1),(30, 'AN', 'BV', 'BVT', '074', 'Bouvet Island', 1),(31, 'SA', 'BR', 'BRA', '076', 'Brazil', 1),(32, 'AS', 'IO', 'IOT', '086', 'British Indian Ocean Territory', 1),(33, 'NA', 'VG', 'VGB', '092', 'British Virgin Islands', 1),(34, 'AS', 'BN', 'BRN', '096', 'Brunei Darussalam', 1),(35, 'EU', 'BG', 'BGR', '100', 'Bulgaria', 1),(36, 'AF', 'BF', 'BFA', '854', 'Burkina Faso', 1),(37, 'AF', 'BI', 'BDI', '108', 'Burundi', 1),(38, 'AS', 'KH', 'KHM', '116', 'Cambodia', 1),(39, 'AF', 'CM', 'CMR', '120', 'Cameroon', 1),(40, 'NA', 'CA', 'CAN', '124', 'Canada', 1),(41, 'AF', 'CV', 'CPV', '132', 'Cape Verde', 1),(42, 'NA', 'KY', 'CYM', '136', 'Cayman Islands', 1),(43, 'AF', 'CF', 'CAF', '140', 'Central African Republic', 1),(44, 'AF', 'TD', 'TCD', '148', 'Chad', 1),(45, 'SA', 'CL', 'CHL', '152', 'Chile', 1),(46, 'AS', 'CN', 'CHN', '156', 'China', 1),(47, 'AS', 'CX', 'CXR', '162', 'Christmas Island', 1),(48, 'AS', 'CC', 'CCK', '166', 'Cocos (Keeling) Islands', 1),(49, 'SA', 'CO', 'COL', '170', 'Colombia', 1),(50, 'AF', 'KM', 'COM', '174', 'Comoros', 1),(51, 'AF', 'CG', 'COG', '178', 'Congo', 1),(52, 'OC', 'CK', 'COK', '184', 'Cook Islands', 1),(53, 'NA', 'CR', 'CRI', '188', 'Costa Rica', 1),(54, 'AF', 'CI', 'CIV', '384', 'Cote D''Ivoire', 1),(55, 'EU', 'HR', 'HRV', '191', 'Croatia', 1),(56, 'NA', 'CU', 'CUB', '192', 'Cuba', 1),(57, 'AS', 'CY', 'CYP', '196', 'Cyprus', 1),(58, 'EU', 'CZ', 'CZE', '203', 'Czech Republic', 1),(59, 'EU', 'DK', 'DNK', '208', 'Denmark', 1),(60, 'AF', 'DJ', 'DJI', '262', 'Djibouti', 1),(61, 'NA', 'DM', 'DMA', '212', 'Dominica', 1),(62, 'NA', 'DO', 'DOM', '214', 'Dominican Republic', 1),(63, 'SA', 'EC', 'ECU', '218', 'Ecuador', 1),(64, 'AF', 'EG', 'EGY', '818', 'Egypt', 1),(65, 'NA', 'SV', 'SLV', '222', 'El Salvador', 1),(66, 'AF', 'GQ', 'GNQ', '226', 'Equatorial Guinea', 1),(67, 'AF', 'ER', 'ERI', '232', 'Eritrea', 1),(68, 'EU', 'EE', 'EST', '233', 'Estonia', 1),(69, 'AF', 'ET', 'ETH', '231', 'Ethiopia', 1),(70, 'EU', 'FO', 'FRO', '234', 'Faroe Islands', 1),(71, 'SA', 'FK', 'FLK', '238', 'Falkland Islands', 1),(72, 'OC', 'FJ', 'FJI', '242', 'Fiji', 1),(73, 'EU', 'FI', 'FIN', '246', 'Finland', 1),(74, 'EU', 'FR', 'FRA', '250', 'France', 1),(75, 'SA', 'GF', 'GUF', '254', 'French Guiana', 1),(76, 'OC', 'PF', 'PYF', '258', 'French Polynesia', 1),(77, 'AN', 'TF', 'ATF', '260', 'French Southern Territories', 1),(78, 'AF', 'GA', 'GAB', '266', 'Gabon', 1),(79, 'AF', 'GM', 'GMB', '270', 'Gambia', 1),(80, 'AS', 'GE', 'GEO', '268', 'Georgia', 1),(81, 'EU', 'DE', 'DEU', '276', 'Germany', 1),(82, 'AF', 'GH', 'GHA', '288', 'Ghana', 1),(83, 'EU', 'GI', 'GIB', '292', 'Gibraltar', 1),(84, 'EU', 'GR', 'GRC', '300', 'Greece', 1),(85, 'NA', 'GL', 'GRL', '304', 'Greenland', 1),(86, 'NA', 'GD', 'GRD', '308', 'Grenada', 1),(87, 'NA', 'GP', 'GLP', '312', 'Guadaloupe', 1),(88, 'OC', 'GU', 'GUM', '316', 'Guam', 1),(89, 'NA', 'GT', 'GTM', '320', 'Guatemala', 1),(90, 'EU', 'GG', 'GGY', '831', 'Guernsey', 1),(91, 'AF', 'GN', 'GIN', '324', 'Guinea', 1),(92, 'AF', 'GW', 'GNB', '624', 'Guinea-Bissau', 1),(93, 'SA', 'GY', 'GUY', '328', 'Guyana', 1),(94, 'NA', 'HT', 'HTI', '332', 'Haiti', 1),(95, 'AN', 'HM', 'HMD', '334', 'Heard and McDonald Islands', 1),(96, 'EU', 'VA', 'VAT', '336', 'Holy See (Vatican City State)', 1),(97, 'NA', 'HN', 'HND', '340', 'Honduras', 1),(98, 'AS', 'HK', 'HKG', '344', 'Hong Kong', 1),(99, 'EU', 'HU', 'HUN', '348', 'Hungary', 1),(100, 'EU', 'IS', 'ISL', '352', 'Iceland', 1),(101, 'AS', 'IN', 'IND', '356', 'India', 1),(102, 'AS', 'ID', 'IDN', '360', 'Indonesia', 1),(103, 'AS', 'IR', 'IRN', '364', 'Iran', 1),(104, 'AS', 'IQ', 'IRQ', '368', 'Iraq', 1),(105, 'EU', 'IE', 'IRL', '372', 'Ireland', 1),(106, 'EU', 'IM', 'IMN', '833', 'Isle of Man', 1),(107, 'AS', 'IL', 'ISR', '376', 'Israel', 1),(108, 'EU', 'IT', 'ITA', '380', 'Italy', 1),(109, 'NA', 'JM', 'JAM', '388', 'Jamaica', 1),(110, 'AS', 'JP', 'JPN', '392', 'Japan', 1),(111, 'EU', 'JE', 'JEY', '832', 'Jersey', 1),(112, 'AS', 'JO', 'JOR', '400', 'Jordan', 1),(113, 'AS', 'KZ', 'KAZ', '398', 'Kazakhstan', 1),(114, 'AF', 'KE', 'KEN', '404', 'Kenya', 1),(115, 'OC', 'KI', 'KIR', '296', 'Kiribati', 1),(116, 'AS', 'KP', 'PRK', '408', 'Korea, Democratic People''s Republic of', 1),(117, 'AS', 'KR', 'KOR', '410', 'Korea, Republic of', 1),(118, 'AS', 'KW', 'KWT', '414', 'Kuwait', 1),(119, 'AS', 'KG', 'KGZ', '417', 'Kyrgyz Republic', 1),(120, 'AS', 'LA', 'LAO', '418', 'Lao, People''s Democratic Republic', 1),(121, 'EU', 'LV', 'LVA', '428', 'Latvia', 1),(122, 'AS', 'LB', 'LBN', '422', 'Lebanon', 1),(123, 'AF', 'LS', 'LSO', '426', 'Lesotho', 1),(124, 'AF', 'LR', 'LBR', '430', 'Liberia', 1),(125, 'AF', 'LY', 'LBY', '434', 'Libyan Arab Jamahiriya', 1),(126, 'EU', 'LI', 'LIE', '438', 'Liechtenstein', 1),(127, 'EU', 'LT', 'LTU', '440', 'Lithuania', 1),(128, 'EU', 'LU', 'LUX', '442', 'Luxembourg', 1),(129, 'AS', 'MO', 'MAC', '446', 'Macao', 1),(130, 'EU', 'MK', 'MKD', '807', 'Macedonia the former Yugoslav Republic of', 1),(131, 'AF', 'MG', 'MDG', '450', 'Madagascar', 1),(132, 'AF', 'MW', 'MWI', '454', 'Malawi', 1),(133, 'AS', 'MY', 'MYS', '458', 'Malaysia', 1),(134, 'AS', 'MV', 'MDV', '462', 'Maldives', 1),(135, 'AF', 'ML', 'MLI', '466', 'Mali', 1),(136, 'EU', 'MT', 'MLT', '470', 'Malta', 1),(137, 'OC', 'MH', 'MHL', '584', 'Marshall Islands', 1),(138, 'NA', 'MQ', 'MTQ', '474', 'Martinique', 1),(139, 'AF', 'MR', 'MRT', '478', 'Mauritania', 1),(140, 'AF', 'MU', 'MUS', '480', 'Mauritius', 1),(141, 'AF', 'YT', 'MYT', '175', 'Mayotte', 1),(142, 'NA', 'MX', 'MEX', '484', 'Mexico', 1),(143, 'OC', 'FM', 'FSM', '583', 'Micronesia', 1),(144, 'EU', 'MD', 'MDA', '498', 'Moldova', 1),(145, 'EU', 'MC', 'MCO', '492', 'Monaco', 1),(146, 'AS', 'MN', 'MNG', '496', 'Mongolia', 1),(147, 'EU', 'ME', 'MNE', '499', 'Montenegro', 1),(148, 'NA', 'MS', 'MSR', '500', 'Montserrat', 1),(149, 'AF', 'MA', 'MAR', '504', 'Morocco', 1),(150, 'AF', 'MZ', 'MOZ', '508', 'Mozambique', 1),(151, 'AS', 'MM', 'MMR', '104', 'Myanmar', 1),(152, 'AF', 'NA', 'NAM', '516', 'Namibia', 1),(153, 'OC', 'NR', 'NRU', '520', 'Nauru', 1),(154, 'AS', 'NP', 'NPL', '524', 'Nepal', 1),(155, 'NA', 'AN', 'ANT', '530', 'Netherlands Antilles', 1),(156, 'EU', 'NL', 'NLD', '528', 'Netherlands', 1),(157, 'OC', 'NC', 'NCL', '540', 'New Caledonia', 1),(158, 'OC', 'NZ', 'NZL', '554', 'New Zealand', 1),(159, 'NA', 'NI', 'NIC', '558', 'Nicaragua', 1),(160, 'AF', 'NE', 'NER', '562', 'Niger', 1),(161, 'AF', 'NG', 'NGA', '566', 'Nigeria', 1),(162, 'OC', 'NU', 'NIU', '570', 'Niue', 1),(163, 'OC', 'NF', 'NFK', '574', 'Norfolk Island', 1),(164, 'OC', 'MP', 'MNP', '580', 'Northern Mariana Islands', 1),(165, 'EU', 'NO', 'NOR', '578', 'Norway', 1),(166, 'AS', 'OM', 'OMN', '512', 'Oman', 1),(167, 'AS', 'PK', 'PAK', '586', 'Pakistan', 1),(168, 'OC', 'PW', 'PLW', '585', 'Palau', 1),(169, 'AS', 'PS', 'PSE', '275', 'Palestinian Territory', 1),(170, 'NA', 'PA', 'PAN', '591', 'Panama', 1),(171, 'OC', 'PG', 'PNG', '598', 'Papua New Guinea', 1),(172, 'SA', 'PY', 'PRY', '600', 'Paraguay', 1),(173, 'SA', 'PE', 'PER', '604', 'Peru', 1),(174, 'AS', 'PH', 'PHL', '608', 'Philippines', 1),(175, 'OC', 'PN', 'PCN', '612', 'Pitcairn Island', 1),(176, 'EU', 'PL', 'POL', '616', 'Poland', 1),(177, 'EU', 'PT', 'PRT', '620', 'Portugal', 1),(178, 'NA', 'PR', 'PRI', '630', 'Puerto Rico', 1),(179, 'AS', 'QA', 'QAT', '634', 'Qatar State of', 1),(180, 'AF', 'RE', 'REU', '638', 'Reunion', 1),(181, 'EU', 'RO', 'ROU', '642', 'Romania', 1),(182, 'EU', 'RU', 'RUS', '643', 'Russian Federation', 1),(183, 'AF', 'RW', 'RWA', '646', 'Rwanda', 1),(184, 'AF', 'SH', 'SHN', '654', 'St Helena', 1),(185, 'NA', 'KN', 'KNA', '659', 'St Kitts and Nevis', 1),(186, 'NA', 'LC', 'LCA', '662', 'St Lucia', 1),(187, 'NA', 'PM', 'SPM', '666', 'St Pierre and Miquelon', 1),(188, 'NA', 'VC', 'VCT', '670', 'St Vincent and the Grenadines', 1),(189, 'OC', 'WS', 'WSM', '882', 'Samoa', 1),(190, 'EU', 'SM', 'SMR', '674', 'San Marino', 1),(191, 'AF', 'ST', 'STP', '678', 'Sao Tome and Principe', 1),(192, 'AS', 'SA', 'SAU', '682', 'Saudi Arabia', 1),(193, 'AF', 'SN', 'SEN', '686', 'Senegal', 1),(194, 'EU', 'RS', 'SRB', '688', 'Serbia', 1),(195, 'AF', 'SC', 'SYC', '690', 'Seychelles', 1),(196, 'AF', 'SL', 'SLE', '694', 'Sierra Leone', 1),(197, 'AS', 'SG', 'SGP', '702', 'Singapore', 1),(198, 'EU', 'SK', 'SVK', '703', 'Slovakia', 1),(199, 'EU', 'SI', 'SVN', '705', 'Slovenia', 1),(200, 'OC', 'SB', 'SLB', '090', 'Solomon Islands', 1),(201, 'AF', 'SO', 'SOM', '706', 'Somalia', 1),(202, 'AF', 'ZA', 'ZAF', '710', 'South Africa', 1),(203, 'AN', 'GS', 'SGS', '239', 'South Georgia and the South Sandwich Islands', 1),(204, 'EU', 'ES', 'ESP', '724', 'Spain', 1),(205, 'AS', 'LK', 'LKA', '144', 'Sri Lanka', 1),(206, 'AF', 'SD', 'SDN', '736', 'Sudan', 1),(207, 'SA', 'SR', 'SUR', '740', 'Suriname', 1),(208, 'EU', 'SJ', 'SJM', '744', 'Svalbard & Jan Mayen Islands', 1),(209, 'AF', 'SZ', 'SWZ', '748', 'Swaziland', 1),(210, 'EU', 'SE', 'SWE', '752', 'Sweden', 1),(211, 'EU', 'CH', 'CHE', '756', 'Switzerland', 1),(212, 'AS', 'SY', 'SYR', '760', 'Syrian Arab Republic', 1),(213, 'AS', 'TW', 'TWN', '158', 'Taiwan', 1),(214, 'AS', 'TJ', 'TJK', '762', 'Tajikistan', 1),(215, 'AF', 'TZ', 'TZA', '834', 'Tanzania', 1),(216, 'AS', 'TH', 'THA', '764', 'Thailand', 1),(217, 'AS', 'TL', 'TLS', '626', 'Timor-Leste', 1),(218, 'AF', 'TG', 'TGO', '768', 'Togo', 1),(219, 'OC', 'TK', 'TKL', '772', 'Tokelau', 1),(220, 'OC', 'TO', 'TON', '776', 'Tonga', 1),(221, 'NA', 'TT', 'TTO', '780', 'Trinidad and Tobago', 1),(222, 'AF', 'TN', 'TUN', '788', 'Tunisia', 1),(223, 'AS', 'TR', 'TUR', '792', 'Turkey', 1),(224, 'AS', 'TM', 'TKM', '795', 'Turkmenistan', 1),(225, 'NA', 'TC', 'TCA', '796', 'Turks and Caicos Islands', 1),(226, 'OC', 'TV', 'TUV', '798', 'Tuvalu', 1),(227, 'NA', 'VI', 'VIR', '850', 'US Virgin Islands', 1),(228, 'AF', 'UG', 'UGA', '800', 'Uganda', 1),(229, 'EU', 'UA', 'UKR', '804', 'Ukraine', 1),(230, 'AS', 'AE', 'ARE', '784', 'United Arab Emirates', 1),(231, 'EU', 'GB', 'GBR', '826', 'United Kingdom', 1),(232, 'OC', 'UM', 'UMI', '581', 'United States Minor Outlying Islands', 1),(233, 'NA', 'US', 'USA', '840', 'United States of America', 1),(234, 'SA', 'UY', 'URY', '858', 'Uruguay', 1),(235, 'AS', 'UZ', 'UZB', '860', 'Uzbekistan', 1),(236, 'OC', 'VU', 'VUT', '548', 'Vanuatu', 1),(237, 'SA', 'VE', 'VEN', '862', 'Venezuela', 1),(238, 'AS', 'VN', 'VNM', '704', 'Viet Nam', 1),(239, 'OC', 'WF', 'WLF', '876', 'Wallis and Futuna Islands', 1),(240, 'AF', 'EH', 'ESH', '732', 'Western Sahara', 1),(241, 'AS', 'YE', 'YEM', '887', 'Yemen', 1),(242, 'AF', 'ZM', 'ZMB', '894', 'Zambia', 1),(243, 'AF', 'ZW', 'ZWE', '716', 'Zimbabwe', 1);-- ---------------------------------------------------------- -- Table structure for table `customers`-- DROP TABLE IF EXISTS `customers`;CREATE TABLE `customers` ( `id` int(8) unsigned NOT NULL auto_increment, `user_id` int(8) unsigned NOT NULL, `title` varchar(255) NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `address1` varchar(255) NOT NULL, `address2` varchar(255) default NULL, `city` varchar(255) NOT NULL, `county` varchar(255) NOT NULL, `country_id` int(8) NOT NULL, `postcode` varchar(255) NOT NULL, `phonenumber` varchar(255) NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `customers`-- -- ---------------------------------------------------------- -- Table structure for table `feeds`-- DROP TABLE IF EXISTS `feeds`;CREATE TABLE `feeds` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `feed` varchar(255) NOT NULL, `image_id` int(8) unsigned NOT NULL, `tags` varchar(255) NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `feeds`-- -- ---------------------------------------------------------- -- Table structure for table `galleries`-- DROP TABLE IF EXISTS `galleries`;CREATE TABLE `galleries` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `user_id` int(8) unsigned NOT NULL, `image_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL, `tags` varchar(255) NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `galleries`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_groups`-- DROP TABLE IF EXISTS `galleries_groups`;CREATE TABLE `galleries_groups` ( `gallery_id` int(8) unsigned NOT NULL, `group_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_groups`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_images`-- DROP TABLE IF EXISTS `galleries_images`;CREATE TABLE `galleries_images` ( `gallery_id` int(8) unsigned NOT NULL, `image_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_images`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_leafs`-- DROP TABLE IF EXISTS `galleries_leafs`;CREATE TABLE `galleries_leafs` ( `gallery_id` int(8) unsigned NOT NULL, `leaf_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_leafs`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_maps`-- DROP TABLE IF EXISTS `galleries_maps`;CREATE TABLE `galleries_maps` ( `gallery_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_maps`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_products`-- DROP TABLE IF EXISTS `galleries_products`;CREATE TABLE `galleries_products` ( `gallery_id` int(8) unsigned NOT NULL, `product_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_products`-- -- ---------------------------------------------------------- -- Table structure for table `galleries_users`-- DROP TABLE IF EXISTS `galleries_users`;CREATE TABLE `galleries_users` ( `gallery_id` int(8) unsigned NOT NULL, `user_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `galleries_users`-- -- ---------------------------------------------------------- -- Table structure for table `groups`-- DROP TABLE IF EXISTS `groups`;CREATE TABLE `groups` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `tags` varchar(255) NOT NULL, `image_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `groups`-- -- ---------------------------------------------------------- -- Table structure for table `groups_images`-- DROP TABLE IF EXISTS `groups_images`;CREATE TABLE `groups_images` ( `group_id` int(8) unsigned NOT NULL, `image_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `groups_images`-- -- ---------------------------------------------------------- -- Table structure for table `groups_maps`-- DROP TABLE IF EXISTS `groups_maps`;CREATE TABLE `groups_maps` ( `group_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `groups_maps`-- -- ---------------------------------------------------------- -- Table structure for table `groups_profiles`-- DROP TABLE IF EXISTS `groups_profiles`;CREATE TABLE `groups_profiles` ( `group_id` int(8) unsigned NOT NULL, `pr` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `groups_profiles`-- -- ---------------------------------------------------------- -- Table structure for table `groups_tags`-- DROP TABLE IF EXISTS `groups_tags`;CREATE TABLE `groups_tags` ( `group_id` int(8) unsigned NOT NULL, `tag_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `groups_tags`-- -- ---------------------------------------------------------- -- Table structure for table `groups_users`-- DROP TABLE IF EXISTS `groups_users`;CREATE TABLE `groups_users` ( `group_id` int(8) unsigned NOT NULL, `user_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `groups_users`-- -- ---------------------------------------------------------- -- Table structure for table `images`-- DROP TABLE IF EXISTS `images`;CREATE TABLE `images` ( `id` int(8) unsigned NOT NULL auto_increment, `filename` varchar(255) NOT NULL, `mimetype` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `body` text NOT NULL, `alt_tag` varchar(255) NOT NULL, `map_id` int(8) unsigned NOT NULL, `tags` varchar(255) NOT NULL, `user_id` int(8) unsigned NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `images`-- -- ---------------------------------------------------------- -- Table structure for table `images_tags`-- DROP TABLE IF EXISTS `images_tags`;CREATE TABLE `images_tags` ( `image_id` int(8) unsigned NOT NULL, `tag_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `images_tags`-- -- ---------------------------------------------------------- -- Table structure for table `leafs`-- DROP TABLE IF EXISTS `leafs`;CREATE TABLE `leafs` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `tags` varchar(255) NOT NULL, `user_id` int(8) unsigned NOT NULL, `branch_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `leafs`-- -- ---------------------------------------------------------- -- Table structure for table `leafs_tags`-- DROP TABLE IF EXISTS `leafs_tags`;CREATE TABLE `leafs_tags` ( `leaf_id` int(8) unsigned NOT NULL, `tag_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `leafs_tags`-- -- ---------------------------------------------------------- -- Table structure for table `maps`-- DROP TABLE IF EXISTS `maps`;CREATE TABLE `maps` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `maps`-- -- ---------------------------------------------------------- -- Table structure for table `maps_points`-- DROP TABLE IF EXISTS `maps_points`;CREATE TABLE `maps_points` ( `map_id` int(8) unsigned NOT NULL, `point_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `maps_points`-- -- ---------------------------------------------------------- -- Table structure for table `menus`-- DROP TABLE IF EXISTS `menus`;CREATE TABLE `menus` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `position` int(5) NOT NULL, `icon` varchar(255) default NULL, `parent_id` int(11) unsigned NOT NULL, `lft` tinyint(4) NOT NULL, `rght` tinyint(4) NOT NULL, `published` tinyint(1) NOT NULL default '1', `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `menus`-- -- ---------------------------------------------------------- -- Table structure for table `options`-- DROP TABLE IF EXISTS `options`;CREATE TABLE `options` ( `id` int(8) unsigned NOT NULL auto_increment, `key` varchar(255) NOT NULL, `value` text NOT NULL, `count` int(8) NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `options`-- -- ---------------------------------------------------------- -- Table structure for table `options_products`-- DROP TABLE IF EXISTS `options_products`;CREATE TABLE `options_products` ( `option_id` int(8) unsigned NOT NULL, `product_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `options_products`-- -- ---------------------------------------------------------- -- Table structure for table `orders`-- DROP TABLE IF EXISTS `orders`;CREATE TABLE `orders` ( `id` int(8) unsigned NOT NULL auto_increment, `basket_id` int(8) unsigned NOT NULL, `customer_id` int(8) unsigned NOT NULL, `payment_method_id` int(8) unsigned NOT NULL, `shipping_method_id` int(8) unsigned NOT NULL, `products_count` int(8) unsigned NOT NULL, `netcost` decimal(19,8) NOT NULL, `vat` decimal(19,8) NOT NULL, `postage` decimal(19,8) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `orders`-- -- ---------------------------------------------------------- -- Table structure for table `payment_methods`-- DROP TABLE IF EXISTS `payment_methods`;CREATE TABLE `payment_methods` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) collate utf8_unicode_ci NOT NULL, `price` decimal(19,8) NOT NULL, `processor` varchar(255) collate utf8_unicode_ci NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `payment_methods`-- -- ---------------------------------------------------------- -- Table structure for table `points`-- DROP TABLE IF EXISTS `points`;CREATE TABLE `points` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `latlng` varchar(255) NOT NULL, `zoom` int(2) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `points`-- -- ---------------------------------------------------------- -- Table structure for table `products`-- DROP TABLE IF EXISTS `products`;CREATE TABLE `products` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `sku` varchar(255) NOT NULL, `price` decimal(19,8) NOT NULL, `weight` decimal(19,8) NOT NULL, `image_id` int(8) unsigned NOT NULL, `tags` varchar(255) NOT NULL, `published` tinyint(1) NOT NULL, `featured` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `products`-- -- ---------------------------------------------------------- -- Table structure for table `products_tags`-- DROP TABLE IF EXISTS `products_tags`;CREATE TABLE `products_tags` ( `product_id` int(8) unsigned NOT NULL, `tag_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `products_tags`-- -- ---------------------------------------------------------- -- Table structure for table `profiles`-- DROP TABLE IF EXISTS `profiles`;CREATE TABLE `profiles` ( `id` int(8) unsigned NOT NULL auto_increment, `key` varchar(255) NOT NULL, `value` text, `published` tinyint(1) NOT NULL, `created` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `profiles`-- -- ---------------------------------------------------------- -- Table structure for table `profiles_users`-- DROP TABLE IF EXISTS `profiles_users`;CREATE TABLE `profiles_users` ( `profile_id` int(8) unsigned NOT NULL, `user_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `profiles_users`-- -- ---------------------------------------------------------- -- Table structure for table `shipping_methods`-- DROP TABLE IF EXISTS `shipping_methods`;CREATE TABLE `shipping_methods` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) collate utf8_unicode_ci NOT NULL, `zones` varchar(255) collate utf8_unicode_ci NOT NULL, `min_weight` decimal(19,8) NOT NULL, `max_weight` decimal(19,8) NOT NULL, `min_size` decimal(19,8) NOT NULL, `max_size` decimal(19,8) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;-- -- Dumping data for table `shipping_methods`-- -- ---------------------------------------------------------- -- Table structure for table `tags`-- DROP TABLE IF EXISTS `tags`;CREATE TABLE `tags` ( `id` int(8) unsigned NOT NULL auto_increment, `tag` varchar(255) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `tags`-- -- ---------------------------------------------------------- -- Table structure for table `tags_users`-- DROP TABLE IF EXISTS `tags_users`;CREATE TABLE `tags_users` ( `tag_id` int(8) unsigned NOT NULL, `user_id` int(8) unsigned NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- -- Dumping data for table `tags_users`-- -- ---------------------------------------------------------- -- Table structure for table `themes`-- DROP TABLE IF EXISTS `themes`;CREATE TABLE `themes` ( `id` int(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL, `body` text NOT NULL, `screenshot` varchar(255) NOT NULL, `stylesheet` varchar(255) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `themes`-- -- ---------------------------------------------------------- -- Table structure for table `users`-- DROP TABLE IF EXISTS `users`;CREATE TABLE `users` ( `id` int(8) unsigned NOT NULL auto_increment, `username` varchar(255) NOT NULL, `passwd` varchar(255) NOT NULL, `realname` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `tags` varchar(255) NOT NULL, `active` tinyint(1) NOT NULL, `image_id` int(8) unsigned NOT NULL, `map_id` int(8) unsigned NOT NULL, `published` tinyint(1) NOT NULL, `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;-- -- Dumping data for table `users`--