root/branch/db.sql

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

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

-- 
-- 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) collate utf8_unicode_ci default '',
  `foreign_key` int(11) default NULL,
  `alias` varchar(255) collate utf8_unicode_ci default '',
  `lft` int(11) default NULL,
  `rght` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `acos`
-- 

INSERT INTO `acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES 
(1, NULL, 'Post', NULL, 'Post', 1, 2),
(2, NULL, 'Page', NULL, 'Page', 3, 4),
(3, NULL, 'User', NULL, 'User', 5, 6),
(4, NULL, 'Event', NULL, 'Event', 7, 8),
(5, NULL, 'Feed', NULL, 'Feed', 9, 10),
(6, NULL, 'Gallery', NULL, 'Gallery', 11, 12),
(7, NULL, 'Group', NULL, 'Group', 13, 14),
(8, NULL, 'Image', NULL, 'Image', 15, 16),
(9, NULL, 'Menu', NULL, 'Menu', 17, 18),
(10, NULL, 'Video', NULL, 'Video', 19, 20),
(11, NULL, 'Venue', NULL, 'Venue', 21, 22);

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

-- 
-- 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) collate utf8_unicode_ci default '',
  `foreign_key` int(11) default NULL,
  `alias` varchar(255) collate utf8_unicode_ci default '',
  `lft` int(11) default NULL,
  `rght` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `aros`
-- 

INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES 
(1, NULL, '', NULL, 'Admin', 1, 6),
(2, NULL, '', NULL, 'Registered', 7, 8),
(3, NULL, '', NULL, 'Guest', 9, 10),
(4, 1, '', NULL, 'Site Editor', 2, 3),
(5, 1, 'User', 1, 'User::1', 4, 5);

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

-- 
-- 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 COLLATE=utf8_unicode_ci;

-- 
-- Dumping data for table `aros_acos`
-- 

INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES 
(1, 1, 1, 1, 1, 1, 1),
(2, 1, 2, 1, 1, 1, 1),
(3, 1, 3, 1, 1, 1, 1),
(4, 1, 4, 1, 1, 1, 1),
(5, 1, 5, 1, 1, 1, 1),
(6, 1, 6, 1, 1, 1, 1),
(7, 1, 7, 1, 1, 1, 1),
(8, 1, 8, 1, 1, 1, 1),
(9, 1, 9, 1, 1, 1, 1),
(10, 1, 10, 1, 1, 1, 1),
(11, 1, 11, 1, 1, 1, 1),
(12, 5, 1, 1, 1, 1, 1),
(13, 5, 2, 1, 1, 1, 1),
(14, 5, 3, 1, 1, 1, 1),
(15, 5, 4, 1, 1, 1, 1),
(16, 5, 5, 1, 1, 1, 1),
(17, 5, 6, 1, 1, 1, 1),
(18, 5, 7, 1, 1, 1, 1),
(19, 5, 8, 1, 1, 1, 1),
(20, 5, 9, 1, 1, 1, 1),
(21, 5, 10, 1, 1, 1, 1),
(22, 5, 11, 1, 1, 1, 1);

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

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

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

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

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


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

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

-- 
-- 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', 'Post Options', 'These are options that control how posts appear on the site');

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

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

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

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

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

INSERT INTO `copyrights` (`id`, `title`, `url`) VALUES 
(1, 'Creative Commons Attribution 3.0', 'http://creativecommons.org/licenses/by/3.0/'),
(2, 'Creative Commons Attribution-Share Alike 3.0', 'http://creativecommons.org/licenses/by-sa/3.0/'),
(3, 'Creative Commons Attribution-No Derivative Works 3.0', 'http://creativecommons.org/licenses/by-nd/3.0/'),
(4, 'Creative Commons Attribution-Noncommercial 3.0', 'http://creativecommons.org/licenses/by-nc/3.0/'),
(5, 'Creative Commons Attribution-Noncommercial-Share Alike 3.0', 'http://creativecommons.org/licenses/by-nc-sa/3.0/'),
(6, 'Creative Commons Attribution-Noncommercial-No Derivative Works 3.0', 'http://creativecommons.org/licenses/by-nc-nd/3.0/');

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

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

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` int(8) 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,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `countries_name` (`countries_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

INSERT INTO `countries` (`id`, `continents_code`, `countries_iso_code_2`, `countries_iso_code_3`, `countries_number`, `countries_name`, `active`) 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 `event_types`
-- 

DROP TABLE IF EXISTS `event_types`;
CREATE TABLE `event_types` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `events_count` int(8) unsigned default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

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

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

DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `venue_id` int(8) 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,
  `event_ticket1` varchar(255) default NULL,
  `event_ticket2` varchar(255) default NULL,
  `event_price` varchar(255) default NULL,
  `body` 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 default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;