CREATE TABLE `events` (
  `id` int(11) NOT NULL auto_increment,
  `host_id` int(11) default NULL,
  `name` varchar(255) default NULL,
  `description` text,
  `starts_at` datetime default NULL,
  `ends_at` datetime default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `flickr_url` varchar(255) default NULL,
  `flickr_feed_url` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `geocodes` (
  `id` int(11) NOT NULL auto_increment,
  `latitude` decimal(15,12) default NULL,
  `longitude` decimal(15,12) default NULL,
  `query` varchar(255) default NULL,
  `street` varchar(255) default NULL,
  `locality` varchar(255) default NULL,
  `region` varchar(255) default NULL,
  `postal_code` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `geocodes_query_index` (`query`),
  KEY `geocodes_longitude_index` (`longitude`),
  KEY `geocodes_latitude_index` (`latitude`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `geocodings` (
  `id` int(11) NOT NULL auto_increment,
  `geocodable_id` int(11) default NULL,
  `geocode_id` int(11) default NULL,
  `geocodable_type` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `geocodings_geocodable_type_index` (`geocodable_type`),
  KEY `geocodings_geocode_id_index` (`geocode_id`),
  KEY `geocodings_geocodable_id_index` (`geocodable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `graphics` (
  `id` int(11) NOT NULL auto_increment,
  `event_id` int(11) default NULL,
  `size` int(11) default NULL,
  `content_type` varchar(255) default NULL,
  `filename` varchar(255) default NULL,
  `height` int(11) default NULL,
  `width` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `news_items` (
  `id` int(11) NOT NULL auto_increment,
  `event_id` int(11) default NULL,
  `content` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `open_id_authentication_associations` (
  `id` int(11) NOT NULL auto_increment,
  `server_url` blob,
  `handle` varchar(255) default NULL,
  `secret` blob,
  `issued` int(11) default NULL,
  `lifetime` int(11) default NULL,
  `assoc_type` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `open_id_authentication_nonces` (
  `id` int(11) NOT NULL auto_increment,
  `nonce` varchar(255) default NULL,
  `created` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `open_id_authentication_settings` (
  `id` int(11) NOT NULL auto_increment,
  `setting` varchar(255) default NULL,
  `value` blob,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `purchases` (
  `id` int(11) NOT NULL auto_increment,
  `buyer_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `paid_at` datetime default NULL,
  `ticket_type_id` int(11) default NULL,
  `quantity` int(11) default NULL,
  `cost_per_ticket` decimal(10,2) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `schema_info` (
  `version` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `ticket_types` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `event_id` int(11) default NULL,
  `cost_per_ticket` decimal(10,2) default NULL,
  `quantity` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tickets` (
  `id` int(11) NOT NULL auto_increment,
  `ticket_type_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `purchase_id` int(11) default NULL,
  `uuid` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `crypted_password` varchar(40) default NULL,
  `salt` varchar(40) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `remember_token` varchar(255) default NULL,
  `remember_token_expires_at` datetime default NULL,
  `flickr_name` varchar(255) default NULL,
  `full_name` varchar(255) default NULL,
  `identity_url` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO schema_info (version) VALUES (21)