root/mess/webrocket.sql

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

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

-- 
-- Table structure for table `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=utf8;

-- 
-- Dumping data for table `cake_sessions`
-- 

INSERT INTO `cake_sessions` (`id`, `data`, `expires`) VALUES 
('fe8331bf8cc87191dd20a10e1b69cfce', 'Config|a:3:{s:9:"userAgent";s:32:"268042ced84746041c45b952d0ba6110";s:4:"time";i:1180995396;s:4:"rand";i:205194849;}othAuth|a:1:{s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";a:2:{s:4:"User";a:17:{s:2:"id";s:1:"1";s:8:"username";s:14:"WebrocketAdmin";s:6:"passwd";s:32:"fdfedc01c66e9ea2817508ca1097df2f";s:4:"name";s:15:"Webrocket Admin";s:5:"email";s:19:"admin@webrocket.com";s:10:"last_visit";s:19:"2007-06-04 16:00:00";s:8:"group_id";s:1:"1";s:10:"profile_id";s:1:"1";s:11:"posts_count";s:1:"4";s:11:"pages_count";s:1:"2";s:14:"comments_count";s:1:"2";s:12:"videos_count";s:1:"0";s:6:"active";s:1:"1";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"login_hash";s:32:"9959667d54c2bb525ab6b832bdd90c14";s:7:"hashkey";s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";}s:5:"Group";a:8:{s:2:"id";s:1:"1";s:4:"name";s:11:"Site Admins";s:5:"level";s:3:"999";s:8:"redirect";s:0:"";s:9:"perm_type";s:5:"allow";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"Permission";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"name";s:1:"*";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";}}}}}Message|a:0:{}', 1180995396);

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

-- 
-- Table structure for table `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=3 ;

-- 
-- Dumping data for table `comments`
-- 

INSERT INTO `comments` (`id`, `post_id`, `user_id`, `title`, `body`, `published`, `created`, `modified`) VALUES 
(1, 1, 1, 'Test', 'Test', 1, '2007-05-02 17:48:17', '2007-05-02 17:48:17'),
(2, 1, 1, 'TestT', 'Test', 1, '2007-05-02 17:51:10', '2007-05-02 17:51:10');

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

-- 
-- Table structure for table `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=4 ;

-- 
-- 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', 'Video Options', 'These are options that control video on the site'),
(3, 'post', '', '');

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

-- 
-- Table structure for table `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=14 ;

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

INSERT INTO `configs` (`id`, `config_category_id`, `key`, `value`) VALUES 
(1, 1, 'sitelogo', 'nhm-logo-90px.gif'),
(2, 1, 'enable_comments', '0'),
(3, 1, 'enable_captcha', '0'),
(4, 1, 'siteurl', 'http://webrocket'),
(5, 1, 'sitedesc', 'Built with CakePHP'),
(6, 2, 'width', '640'),
(7, 2, 'height', '480'),
(8, 2, 'samplerate', '22050'),
(9, 2, 'bitrate', '32'),
(10, 1, 'sitename', 'Web Rocket'),
(11, 3, 'post_index_limit', '5'),
(12, 3, 'post_index_order', 'DESC'),
(13, 3, 'post_index_cachetime', '1 hour');

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

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

CREATE TABLE `copyrights` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

INSERT INTO `copyrights` (`id`, `title`, `body`) VALUES 
(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 work 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 work 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 work 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 work 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 work 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 work 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>.');

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

-- 
-- Table structure for table `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 ;

-- 
-- 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, 'MM', 'MMR', 104, 'Myanmar'),
(149, 'NA', 'NAM', 516, 'Namibia'),
(150, 'NR', 'NRU', 520, 'Nauru'),
(151, 'NP', 'NPL', 524, 'Nepal'),
(152, 'NL', 'NLD', 528, 'Netherlands'),
(153, 'AN', 'ANT', 530, 'Netherlands Antilles'),
(154, 'NC', 'NCL', 540, 'New Caledonia'),
(155, 'NZ', 'NZL', 554, 'New Zealand'),
(156, 'NI', 'NIC', 558, 'Nicaragua'),
(157, 'NE', 'NER', 562, 'Niger'),
(158, 'NG', 'NGA', 566, 'Nigeria'),
(159, 'NU', 'NIU', 570, 'Niue'),
(160, 'NF', 'NFK', 574, 'Norfolk Island'),
(161, 'MP', 'MNP', 580, 'Norhtern Mariana Is.'),
(162, 'NO', 'NOR', 578, 'Norway'),
(163, 'OM', 'OMN', 512, 'Oman'),
(164, 'PK', 'PAK', 586, 'Pakistan'),
(165, 'PW', 'PLW', 585, 'Palau'),
(166, 'PS', 'PSE', 275, 'Palestinian Terr.'),
(167, 'PA', 'PAN', 591, 'Panama'),
(168, 'PG', 'PNG', 598, 'Papua New Guinea'),
(169, 'PY', 'PRY', 600, 'Paraguay'),
(170, 'PE', 'PER', 604, 'Peru'),
(171, 'PH', 'PHL', 608, 'Philippines'),
(172, 'PN', 'PCN', 612, 'Pitcairn'),
(173, 'PL', 'POL', 616, 'Poland'),
(174, 'PT', 'PRT', 620, 'Portugal'),
(175, 'PR', 'PRI', 630, 'Puerto Rico'),
(176, 'QA', 'QAT', 634, 'Qatar'),
(177, 'RE', 'REU', 638, 'Reunion'),
(178, 'RO', 'ROM', 642, 'Romain'),
(179, 'RU', 'RUS', 643, 'Russian Federation'),
(180, 'RW', 'RWA', 646, 'Rwanda'),
(181, 'KN', 'KNA', 659, 'Saint Kitts & Nevis'),
(182, 'LC', 'LCA', 662, 'Saint Lucia'),
(183, 'VC', 'VCT', 670, 'Saint Vincent & The Grenadines'),
(184, 'WS', 'WSM', 882, 'Samoa'),
(185, 'SM', 'SMR', 674, 'San Marino'),
(186, 'ST', 'STP', 678, 'Sao Tome Principe'),
(187, 'SA', 'SAU', 682, 'Saudi Arabia'),
(188, 'SN', 'SEN', 686, 'Senegal'),
(189, 'SC', 'SYC', 690, 'Seychelles'),
(190, 'SL', 'SLE', 694, 'Sierra Leone'),
(191, 'SG', 'SGP', 702, 'Singapore'),
(192, 'SK', 'SVK', 703, 'Slovakia (Slovak Rep.)'),
(193, 'SI', 'SVN', 705, 'Slovenia'),
(194, 'SB', 'SLB', 90, 'Solomon Islands'),
(195, 'SO', 'SOM', 706, 'Somalia'),
(196, 'ZA', 'ZAF', 710, 'South Africa'),
(197, 'GS', 'SGS', 239, 'S. Georgia & The S. Sandwich Is.'),
(198, 'ES', 'ESP', 724, 'Spain'),
(199, 'LK', 'LKA', 144, 'Sri Lanka'),
(200, 'SH', 'SHN', 654, 'St. Helena'),
(201, 'PM', 'SPM', 666, 'St. Pierre & Miquelon'),
(202, 'SD', 'SDN', 736, 'Sudan'),
(203, 'SR', 'SUR', 740, 'Suriname'),
(204, 'SJ', 'SJM', 744, 'Svalbard & Jan Mayen Is.'),
(205, 'SZ', 'SWZ', 748, 'Swaziland'),
(206, 'SE', 'SWE', 752, 'Sweden'),
(207, 'CH', 'CHE', 756, 'Switzerland'),
(208, 'SY', 'SYR', 760, 'Syrian Arab Rep.'),
(209, 'TW', 'TWN', 158, 'Taiwan, Prov. of China'),
(210, 'TJ', 'TJK', 762, 'Tajikistan'),
(211, 'TZ', 'TZA', 834, 'Tanzania, United Rep.'),
(212, 'TH', 'THA', 764, 'Thailand'),
(213, 'TG', 'TGO', 768, 'Togo'),
(214, 'TK', 'TKL', 772, 'Tokelau'),
(215, 'TO', 'TON', 776, 'Tonga'),
(216, 'TT', 'TTO', 780, 'Trinidad & Tobago'),
(217, 'TN', 'TUN', 788, 'Tunisia'),
(218, 'TR', 'TUR', 792, 'Turkey'),
(219, 'TM', 'TKM', 795, 'Turkmenistan'),
(220, 'TC', 'TCA', 796, 'Turks & Caicos Is.'),
(221, 'TV', 'TUV', 798, 'Tuvalu'),
(222, 'UG', 'UGA', 800, 'Uganda'),
(223, 'UA', 'UKR', 804, 'Ukraine'),
(224, 'AE', 'ARE', 784, 'United Arab Emirates'),
(225, 'US', 'USA', 840, 'United States'),
(226, 'UM', 'UMI', 581, 'U.S. Minor Outlying Is.'),
(227, 'UY', 'URY', 858, 'Uruguay'),
(228, 'UZ', 'UZB', 860, 'Uzbekistan'),
(229, 'VU', 'VUT', 548, 'Vanuatu'),
(230, 'VE', 'VEN', 862, 'Venezuela'),
(231, 'VN', 'VNM', 704, 'Vietnam'),
(232, 'VG', 'VGB', 92, 'Virgin Is. (British)'),
(233, 'VI', 'VIR', 850, 'Virgin Is. (U.S.)'),
(234, 'WF', 'WLF', 876, 'Wallis & Futuna Is.'),
(235, 'EH', 'ESH', 732, 'Western Sahara'),
(236, 'YE', 'YEM', 887, 'Yemen'),
(237, 'YU', 'YUG', 891, 'Yugoslavia'),
(238, 'ZM', 'ZMB', 894, 'Zambia'),
(239, 'ZW', 'ZWE', 716, 'Zimbabwe');

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

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

CREATE TABLE `event_types` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `event_types`
-- 

INSERT INTO `event_types` (`id`, `title`) VALUES 
(1, 'Gig'),
(2, 'Release'),
(3, 'Festival'),
(4, 'In-Store');

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

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

CREATE TABLE `events` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `venue` varchar(255) NOT NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) NOT NULL,
  `country_id` int(3) NOT NULL,
  `postcode` varchar(255) 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,
  `tags` varchar(255) NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `subject_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=3 ;

-- 
-- Dumping data for table `events`
-- 

INSERT INTO `events` (`id`, `venue`, `address`, `city`, `country_id`, `postcode`, `event_type_id`, `event_date`, `event_time`, `event_url`, `notes`, `tags`, `user_id`, `subject_id`, `published`, `created`, `modified`) VALUES 
(1, 'No Half Measures', '93-97 St Georges Studios', 'Glasgow', 1, 'G3 6LA', 1, '2007-05-31', '14:00:21', '', 'sfsadfdsfsd', 'Gig, No Half Measures', 0, 1, 1, '2007-05-09 14:38:21', '2007-05-17 13:12:22'),
(2, 'Tane''s Holiday Start', '20/4 Dalgety Ave', 'Edinburgh', 1, 'EH7 5UG', 0, '2007-06-25', '19:45:52', NULL, 'Ex euismod autem quis nulla in autem vel esse ad vero commodo nulla facilisis eros wisi praesent consequat iriure tation eros exerci dolor ut, nibh. Dolor et autem dolor volutpat et veniam augue eu consectetuer praesent ad, suscipit veniam aliquam laoreet dignissim, dignissim dolor iriure ad qui tation aliquip. Minim diam augue quis aliquip, exerci nulla dolore praesent tation consectetuer in et vulputate blandit consequat. Accumsan duis iriure, nisl enim nulla nostrud minim nulla facilisis zzril te ut feugait volutpat in blandit nulla amet ea quis. Dolor suscipit exerci eros consequat dolore feugiat ea dolor, ad vulputate. In enim sed autem odio enim zzril blandit vel eum facilisi vero, feugait, iriure et, consequat ut et euismod, ipsum praesent accumsan duis zzril in hendrerit. Ut accumsan dolor hendrerit, dignissim tincidunt commodo, odio consequat consectetuer delenit dignissim nulla dolore velit elit, accumsan veniam consectetuer nostrud vulputate magna nulla praesent.', 'Holiday, Tane', 0, 1, 1, '2007-05-21 16:42:52', '2007-05-21 16:42:52');

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

-- 
-- Table structure for table `events_tags`
-- 

CREATE TABLE `events_tags` (
  `event_id` int(8) NOT NULL,
  `tag_id` int(8) NOT NULL,
  KEY `event_id` (`event_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `events_tags`
-- 

INSERT INTO `events_tags` (`event_id`, `tag_id`) VALUES 
(1, 8),
(1, 17),
(2, 26),
(2, 27);

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

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

CREATE TABLE `feeds` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `feed_name` varchar(255) NOT NULL,
  `feed_url` varchar(255) NOT NULL,
  `subject_id` int(8) unsigned 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=1 ;

-- 
-- Dumping data for table `feeds`
-- 


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

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

CREATE TABLE `galleries` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `primary_image` int(8) unsigned NOT NULL,
  `subject_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 ;

-- 
-- Dumping data for table `galleries`
-- 

INSERT INTO `galleries` (`id`, `title`, `url`, `primary_image`, `subject_id`, `published`, `created`, `modified`) VALUES 
(1, 'The Hedrons', 'the_hedrons', 1, 0, 0, '2007-05-03 15:40:24', '2007-05-03 15:40:24');

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

-- 
-- Table structure for table `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`
-- 

INSERT INTO `galleries_images` (`gallery_id`, `image_id`) VALUES 
(1, 1),
(1, 2),
(1, 3);

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

-- 
-- Table structure for table `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=5 ;

-- 
-- Dumping data for table `groups`
-- 

INSERT INTO `groups` (`id`, `name`, `level`, `redirect`, `perm_type`, `created`, `modified`) VALUES 
(1, 'Site Admins', 999, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'),
(2, 'Site Editors', 900, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'),
(3, 'Registered Members', 500, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'),
(4, 'Anonymous Visitor', 0, '', 'allow', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

-- 
-- Table structure for table `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;

-- 
-- Dumping data for table `groups_permissions`
-- 

INSERT INTO `groups_permissions` (`group_id`, `permission_id`) VALUES 
(1, 1),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 6);

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

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

CREATE TABLE `images` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `filename` varchar(255) default NULL,
  `dir` varchar(255) default NULL,
  `thumb` varchar(255) default NULL,
  `mimetype` varchar(255) NOT NULL,
  `alt` varchar(255) default NULL,
  `subject_id` int(8) default NULL,
  `copyright_owner` varchar(255) default NULL,
  `copyright_id` int(8) unsigned default '1',
  `image_location` varchar(255) default NULL,
  `image_date` date default NULL,
  `image_notes` text,
  `filesize` int(11) unsigned default NULL,
  `tags` varchar(255) default NULL,
  `user_id` int(8) unsigned default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;

-- 
-- Dumping data for table `images`
-- 


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

-- 
-- Table structure for table `images_tags`
-- 

CREATE TABLE `images_tags` (
  `image_id` int(8) NOT NULL,
  `tag_id` int(8) NOT NULL,
  KEY `image_id` (`image_id`,`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `images_tags`
-- 

INSERT INTO `images_tags` (`image_id`, `tag_id`) VALUES 
(37, 29),
(37, 30),
(38, 29),
(38, 30);

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

-- 
-- Table structure for table `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;

-- 
-- Dumping data for table `login_attempts`
-- 


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

-- 
-- Table structure for table `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,
  `section_id` int(11) unsigned NOT NULL,
  `access_level` int(3) NOT NULL,
  `published` tinyint(1) NOT NULL default '1',
  `created` datetime