root/trunk/webrocket.sql

-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 29, 2007 at 03:25 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
-- 
-- Database: `webrocket`
-- 

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

-- 
-- Table structure for table `cake_sessions`
-- 

DROP TABLE IF EXISTS `cake_sessions`;
CREATE TABLE `cake_sessions` (
  `id` varchar(255) NOT NULL default '',
  `data` text,
  `expires` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `comments`
-- 

DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `post_id` int(8) unsigned NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `title` varchar(150) NOT NULL,
  `body` text NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `config_categories`
-- 

DROP TABLE IF EXISTS `config_categories`;
CREATE TABLE `config_categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `descname` varchar(50) NOT NULL,
  `desc` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `configs`
-- 

DROP TABLE IF EXISTS `configs`;
CREATE TABLE `configs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `config_category_id` int(10) unsigned NOT NULL,
  `key` varchar(50) NOT NULL,
  `value` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

-- 
-- Table structure for table `copyrights`
-- 

DROP TABLE IF EXISTS `copyrights`;
CREATE TABLE `copyrights` (
  `id` int(8) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `licence` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `countries`
-- 

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` smallint(6) NOT NULL auto_increment,
  `twoAbrev` char(2) collate utf8_unicode_ci NOT NULL,
  `threeAbrev` char(3) collate utf8_unicode_ci NOT NULL,
  `code` int(11) NOT NULL default '0',
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=240 ;

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

-- 
-- Table structure for table `event_types`
-- 

DROP TABLE IF EXISTS `event_types`;
CREATE TABLE `event_types` (
  `id` int(8) unsigned NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `events`
-- 

DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `venue` varchar(50) NOT NULL,
  `address` varchar(255) default NULL,
  `city` varchar(50) NOT NULL,
  `country_id` int(3) NOT NULL,
  `postcode` varchar(10) NOT NULL,
  `lat` varchar(50) NOT NULL,
  `long` varchar(50) NOT NULL,
  `event_type_id` int(8) unsigned NOT NULL,
  `event_date` date NOT NULL,
  `event_time` time default NULL,
  `event_url` varchar(255) default NULL,
  `notes` text,
  `user_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `feeds`
-- 

DROP TABLE IF EXISTS `feeds`;
CREATE TABLE `feeds` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `feed_name` varchar(255) NOT NULL,
  `feed_url` varchar(255) NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

-- 
-- Table structure for table `galleries`
-- 

DROP TABLE IF EXISTS `galleries`;
CREATE TABLE `galleries` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `primary_image` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

-- 
-- 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;

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

-- 
-- Table structure for table `groups`
-- 

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
  `level` int(11) NOT NULL,
  `redirect` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL,
  `perm_type` enum('allow','deny') NOT NULL default 'allow',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

-- 
-- Table structure for table `groups_permissions`
-- 

DROP TABLE IF EXISTS `groups_permissions`;
CREATE TABLE `groups_permissions` (
  `group_id` int(10) unsigned NOT NULL default '0',
  `permission_id` int(10) unsigned NOT NULL default '0',
  KEY `group_id` (`group_id`,`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `images`
-- 

DROP TABLE IF EXISTS `images`;
CREATE TABLE `images` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `filename` varchar(150) NOT NULL,
  `filesize` int(11) NOT NULL,
  `alt` varchar(255) NOT NULL,
  `type` varchar(15) NOT NULL,
  `copyright_owner` varchar(255) default NULL,
  `copyright_id` int(8) unsigned NOT NULL default '1',
  `lat` decimal(10,0) default NULL,
  `long` decimal(10,0) default NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

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

-- 
-- Table structure for table `login_attempts`
-- 

DROP TABLE IF EXISTS `login_attempts`;
CREATE TABLE `login_attempts` (
  `ip` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL,
  `num` int(11) NOT NULL default '1',
  `expire` datetime NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- 
-- 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,
  `section_id` int(11) unsigned NOT NULL,
  `access_level` int(3) NOT NULL,
  `published` tinyint(1) NOT NULL default '1',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;
CREATE TABLE `menus` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `url` varchar(150) NOT NULL,
  `position` int(5) NOT NULL,
  `icon` varchar(255) default NULL,
  `parent_id` int(11) unsigned NOT NULL,
  `section_id` int(11) unsigned NOT NULL,
  `access_level` int(3) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

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

-- 
-- Table structure for table `pages`
-- 

DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `url` varchar(150) NOT NULL,
  `title` varchar(50) NOT NULL,
  `body` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `user_id` int(8) unsigned NOT NULL,
  `subject_id` int(8) unsigned NOT NULL,
  `copyright_id` int(8) unsigned NOT NULL default '1',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `permissions`
-- 

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

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

-- 
-- Table structure for table `posts`
-- 

DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(150) NOT NULL,
  `byline` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `subject_id` int(8) unsigned NOT NULL,
  `copyright_id` int(8) unsigned NOT NULL default '1',
  `url` varchar(200) NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `profiles`
-- 

DROP TABLE IF EXISTS `profiles`;
CREATE TABLE `profiles` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `user_id` int(8) unsigned NOT NULL,
  `country` varchar(2) NOT NULL,
  `dob` date NOT NULL,
  `homepage` varchar(150) NOT NULL,
  `image` varchar(150) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `sections`
-- 

DROP TABLE IF EXISTS `sections`;
CREATE TABLE `sections` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

-- 
-- Table structure for table `states`
-- 

DROP TABLE IF EXISTS `states`;
CREATE TABLE `states` (
  `id` tinyint(4) NOT NULL auto_increment,
  `ab` char(2) collate utf8_unicode_ci NOT NULL,
  `name` varchar(20) collate utf8_unicode_ci NOT NULL,
  `cntry` varchar(13) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=67 ;

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

-- 
-- Table structure for table `subjects`
-- 

DROP TABLE IF EXISTS `subjects`;
CREATE TABLE `subjects` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `user_histories`
-- 

DROP TABLE IF EXISTS `user_histories`;
CREATE TABLE `user_histories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL,
  `fullname` varchar(64) NOT NULL,
  `groupname` varchar(32) NOT NULL,
  `visitdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `users`
-- 

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `passwd` varchar(32) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `last_visit` datetime NOT NULL default '0000-00-00 00:00:00',
  `group_id` int(10) unsigned NOT NULL default '0',
  `profile_id` int(8) unsigned NOT NULL default '0',
  `active` tinyint(1) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`,`username`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

-- 
-- Table structure for table `videos`
-- 

DROP TABLE IF EXISTS `videos`;
CREATE TABLE `videos` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL,
  `mimetype` varchar(255) NOT NULL,
  `filesize` int(15) NOT NULL,
  `video_location` varchar(255) NOT NULL,
  `video_date` date NOT NULL,
  `video_notes` text NOT NULL,
  `copyright_owner` varchar(255) NOT NULL,
  `copyright_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;


-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 29, 2007 at 03:27 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
-- 
-- Database: `webrocket`
-- 

-- 
-- Dumping data for table `config_categories`
-- 

INSERT INTO `config_categories` (`id`, `name`, `descname`, `desc`) VALUES 
(1, 'general', 'Site Options', 'These are the main options that control the site'),
(2, 'video', '', '');

-- 
-- Dumping data for table `configs`
-- 

INSERT INTO `configs` (`id`, `config_category_id`, `key`, `value`) VALUES 
(1, 1, 'siteurl', 'http://webrocket'),
(2, 1, 'enable_comments', '1'),
(3, 1, 'enable_captcha', '0'),
(4, 1, 'sitedesc', 'Built with CakePHP'),
(5, 1, 'sitename', 'Web Rocket'),
(6, 2, 'width', '320'),
(7, 2, 'height', '240'),
(8, 2, 'samplerate', '22050'),
(9, 2, 'bitrate', '32');

-- 
-- Dumping data for table `copyrights`
-- 

INSERT INTO `copyrights` (`id`, `name`, `licence`) VALUES 
(0, 'MIT Licence', '<p>\r\nCopyright (c) <year> <copyright holders>\r\n</p>\r\n<p>\r\nPermission is hereby granted, free of charge, to any person obtaining a copy\r\nof this software and associated documentation files (the "Software"), to deal\r\nin the Software without restriction, including without limitation the rights\r\nto use, copy, modify, merge, publish, distribute, sublicense, and/or sell\r\ncopies of the Software, and to permit persons to whom the Software is\r\nfurnished to do so, subject to the following conditions:\r\n</p>\r\n<p>\r\nThe above copyright notice and this permission notice shall be included in\r\nall copies or substantial portions of the Software.\r\n</p>\r\n<p>\r\nTHE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR\r\nIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,\r\nFITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE\r\nAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER\r\nLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,\r\nOUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN\r\nTHE SOFTWARE.\r\n</p>'),
(1, 'Creative Commons Attribution 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by/3.0/">Creative Commons Attribution 3.0 License</a>.'),
(2, 'Creative Commons Attribution-Share Alike 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-sa/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-sa/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-sa/3.0/">Creative Commons Attribution-Share Alike 3.0 License</a>.'),
(3, 'Creative Commons Attribution-No Derivative Works 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nd/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nd/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nd/3.0/">Creative Commons Attribution-No Derivative Works 3.0 License</a>.'),
(4, 'Creative Commons Attribution-Noncommercial 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nc/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nc/3.0/">Creative Commons Attribution-Noncommercial 3.0 License</a>.'),
(5, 'Creative Commons Attribution-Noncommercial-Share Alike 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc-sa/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/">Creative Commons Attribution-Noncommercial-Share Alike 3.0 License</a>.'),
(6, 'Creative Commons Attribution-Noncommercial-No Derivative Works 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc-nd/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/3.0/">Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License</a>.');

-- 
-- Dumping data for table `countries`
-- 

INSERT INTO `countries` (`id`, `twoAbrev`, `threeAbrev`, `code`, `name`) VALUES 
(1, 'GB', 'GBR', 826, 'United Kingdom'),
(2, 'AL', 'ALB', 8, 'Albania'),
(3, 'DZ', 'DZA', 12, 'Algeria'),
(4, 'AS', 'ASM', 16, 'American Samoa'),
(5, 'AD', 'AND', 20, 'Andorra'),
(6, 'AO', 'AGO', 24, 'Angola'),
(7, 'AI', 'AIA', 660, 'Anguilla'),
(8, 'AQ', 'ATA', 10, 'Anarctica'),
(9, 'AG', 'ATG', 28, 'Antigua and Barbuda'),
(10, 'AR', 'ARG', 32, 'Argentina'),
(11, 'AM', 'ARM', 51, 'Armenia'),
(12, 'AW', 'ABW', 533, 'Aruba'),
(13, 'AU', 'AUS', 36, 'Australia'),
(14, 'AT', 'AUT', 40, 'Austria'),
(15, 'AZ', 'AZE', 31, 'Azerbaijan'),
(16, 'BS', 'BHS', 44, 'Bahamas'),
(17, 'BH', 'BHR', 48, 'Bahrain'),
(18, 'BD', 'BGD', 50, 'Bangladesh'),
(19, 'BB', 'BRB', 52, 'Barbados'),
(20, 'BY', 'BLR', 112, 'Belarus'),
(21, 'BE', 'BEL', 56, 'Belgiun'),
(22, 'BZ', 'BLZ', 84, 'Belize'),
(23, 'BJ', 'BEN', 204, 'Benin'),
(24, 'BM', 'BMU', 60, 'Bermuda'),
(25, 'BT', 'BTN', 64, 'Bhutan'),
(26, 'BO', 'BOL', 68, 'Bolivia'),
(27, 'BA', 'BIH', 70, 'Bosnia & Herzegowina'),
(28, 'BW', 'BWA', 72, 'Botswana'),
(29, 'BV', 'BVT', 74, 'Bouvet Is.'),
(30, 'BR', 'BRA', 76, 'Brazil'),
(31, 'IO', 'IOT', 86, 'Brit. Indian Ocean Terr.'),
(32, 'BN', 'BRN', 96, 'Brunei Darussalam'),
(33, 'BG', 'BGR', 100, 'Bulgaria'),
(34, 'BF', 'BFA', 854, 'Burkina Faso'),
(35, 'BI', 'BDI', 108, 'Burundi'),
(36, 'KH', 'KHM', 116, 'Cambodia'),
(37, 'CM', 'CMR', 120, 'Cameron'),
(38, 'CA', 'CAN', 124, 'Canada'),
(39, 'CV', 'CPV', 132, 'Cape Verde'),
(40, 'KY', 'CYM', 136, 'Cayman Islands'),
(41, 'CF', 'CAF', 140, 'Central African Rep.'),
(42, 'TD', 'TCD', 148, 'Chad'),
(43, 'CL', 'CHL', 152, 'Chile'),
(44, 'CN', 'CHN', 156, 'China'),
(45, 'CX', 'CXR', 162, 'Christmas Island'),
(46, 'CC', 'CCK', 166, 'Cocos (Keeling) Is.'),
(47, 'CO', 'COL', 170, 'Colombia'),
(48, 'KM', 'COM', 174, 'Comoros'),
(49, 'CG', 'COG', 178, 'Congo'),
(50, 'CD', 'COD', 180, 'Congo, Democratic Rep.'),
(51, 'CK', 'COK', 184, 'Cook Islands'),
(52, 'CR', 'CRI', 188, 'Costa Rica'),
(53, 'CI', 'CIV', 384, 'Cote D''ivoire'),
(54, 'HR', 'HRV', 191, 'Croatia (Hrvatska)'),
(55, 'CU', 'CUB', 192, 'Cuba'),
(56, 'CY', 'CYP', 196, 'Cyprus'),
(57, 'CZ', 'CZE', 203, 'Czech Republic'),
(58, 'DK', 'DNK', 208, 'Denmark'),
(59, 'DJ', 'DJI', 262, 'Djibouti'),
(60, 'DM', 'DMA', 212, 'Dominica'),
(61, 'DO', 'DOM', 214, 'Dominican Republic'),
(62, 'TP', 'TMP', 626, 'East Timor'),
(63, 'EC', 'ECU', 218, 'Ecuador'),
(64, 'EG', 'EGY', 818, 'Egypt'),
(65, 'SV', 'SLV', 222, 'El Salvador'),
(66, 'GQ', 'GNQ', 226, 'Equatorial Guinea'),
(67, 'ER', 'ERI', 232, 'Eritrea'),
(68, 'EE', 'EST', 233, 'Estonia'),
(69, 'ET', 'ETH', 231, 'Ethiopia'),
(70, 'FK', 'FLK', 238, 'Falkland Is.(Malvinas)'),
(71, 'FO', 'FRO', 234, 'Faroe Islands'),
(72, 'FJ', 'FJI', 242, 'Fiji'),
(73, 'FI', 'FIN', 246, 'Finland'),
(74, 'FR', 'FRA', 250, 'France'),
(75, 'FX', 'FXX', 249, 'France, Metro.'),
(76, 'GF', 'GUF', 254, 'French Guiana'),
(77, 'PF', 'PYF', 258, 'French Polynesia'),
(78, 'TF', 'ATF', 260, 'French South Terr.'),
(79, 'GA', 'GAB', 266, 'Gabon'),
(80, 'GM', 'GMB', 270, 'Gambia'),
(81, 'GE', 'GEO', 268, 'Georgia'),
(82, 'DE', 'DEU', 276, 'Germany'),
(83, 'GH', 'GHA', 288, 'Ghana'),
(84, 'GI', 'GIB', 292, 'Gibraltar'),
(85, 'GR', 'GRC', 300, 'Greece'),
(86, 'GL', 'GRL', 304, 'Greenland'),
(87, 'GD', 'GRD', 308, 'Grenada'),
(88, 'GP', 'GLP', 312, 'Guadeloupe'),
(89, 'GU', 'GUM', 316, 'Guam'),
(90, 'GT', 'GTM', 320, 'Guatemala'),
(91, 'GN', 'GIN', 324, 'Guinea'),
(92, 'GW', 'GNB', 624, 'Guinea-Bissau'),
(93, 'GY', 'GUY', 328, 'Guyana'),
(94, 'HT', 'HTI', 332, 'Haiti'),
(95, 'HM', 'HMD', 334, 'Heard & Mc Donald Is.'),
(96, 'VA', 'VAT', 336, 'Holy See(Vatican City St.)'),
(97, 'HN', 'HND', 340, 'Honduras'),
(98, 'HK', 'HKG', 344, 'Hong Kong'),
(99, 'HU', 'HUN', 348, 'Hungary'),
(100, 'IS', 'ISL', 352, 'Iceland'),
(101, 'IN', 'IND', 356, 'India'),
(102, 'ID', 'IDN', 360, 'Indonesia'),
(103, 'IR', 'IRN', 364, 'Iran (Islamic Rep.)'),
(104, 'IQ', 'IRQ', 368, 'Iraq'),
(105, 'IE', 'IRL', 372, 'Ireland'),
(106, 'IL', 'ISR', 376, 'Israel'),
(107, 'IT', 'ITA', 380, 'Italy'),
(108, 'JM', 'JAM', 388, 'Jamaica'),
(109, 'JP', 'JPN', 392, 'Japan'),
(110, 'JO', 'JOR', 400, 'Jordan'),
(111, 'KZ', 'KAZ', 398, 'Kazakhstan'),
(112, 'KE', 'KEN', 404, 'Kenya'),
(113, 'KI', 'KIR', 296, 'Kiribati'),
(114, 'KP', 'PRK', 408, 'Korea, Dem. People''s Rep.'),
(115, 'KR', 'KOR', 410, 'Korea, Rep.'),
(116, 'KW', 'KWT', 414, 'Kuwait'),
(117, 'KG', 'KGZ', 417, 'Kyrgyzstan'),
(118, 'LA', 'LAO', 418, 'Lao People''s Dem. Rep.'),
(119, 'LV', 'LVA', 428, 'Latvia'),
(120, 'LB', 'LBN', 422, 'Lebanon'),
(121, 'LS', 'LSO', 426, 'Lesotho'),
(122, 'LR', 'LBR', 430, 'Liberia'),
(123, 'LY', 'LBY', 434, 'Libyan Arab Jamahiriya'),
(124, 'LI', 'LIE', 438, 'Liechtenstein'),
(125, 'LT', 'LTU', 440, 'Lithuania'),
(126, 'LU', 'LUX', 442, 'Luxembourg'),
(127, 'MO', 'MAC', 446, 'Macau'),
(128, 'MK', 'MKD', 807, 'Macedonia, Frmr. Yugoslav Rep.'),
(129, 'MG', 'MDG', 450, 'Madagascar'),
(130, 'MW', 'MWI', 454, 'Malawi'),
(131, 'MY', 'MYS', 458, 'Malaysia'),
(132, 'MV', 'MDV', 462, 'Maldives'),
(133, 'ML', 'MLI', 466, 'Mali'),
(134, 'MT', 'MLT', 470, 'Malta'),
(135, 'MH', 'MHL', 584, 'Marshall Is.'),
(136, 'MQ', 'MTQ', 474, 'Martinique'),
(137, 'MR', 'MRT', 478, 'Mauritania'),
(138, 'MU', 'MUS', 480, 'Mauritius'),
(139, 'YT', 'MYT', 175, 'Mayotte'),
(140, 'MX', 'MEX', 484, 'Mexico'),
(141, 'FM', 'FSM', 583, 'Micronesia, Fed. St.'),
(142, 'MD', 'MDA', 498, 'Moldova, Rep.'),
(143, 'MC', 'MCO', 492, 'Monaco'),
(144, 'MN', 'MNG', 496, 'Mongolia'),
(145, 'MS', 'MSR', 500, 'Montserrat'),
(146, 'MA', 'MAR', 504, 'Morocco'),
(147, 'MZ', 'MOZ', 508, 'Mozambique'),
(148,