# CocoaMySQL dump
# Version 0.7b5
# http://cocoamysql.sourceforge.net
#
# Host: 127.0.0.1 (MySQL 5.0.22)
# Database: OpenInterocitor
# Generation Time: 2007-08-03 18:12:52 -0700
# ************************************************************

# Dump of table opic_auth
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_auth`;

CREATE TABLE `opic_auth` (
  `id` int(11) NOT NULL auto_increment,
  `auth_id` varchar(128) default NULL,
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default '0000-00-00 00:00:00',
  `username` varchar(64) NOT NULL,
  `password_hash` varchar(64) NOT NULL default '',
  `email` varchar(128) default NULL,
  `last_signin` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_username` (`username`),
  KEY `index_username_password_hash` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_auth_ids_to_profiles
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_auth_ids_to_profiles`;

CREATE TABLE `opic_auth_ids_to_profiles` (
  `id` int(11) NOT NULL auto_increment,
  `auth_id` varchar(128) default NULL,
  `profile_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_auth_id` (`auth_id`),
  KEY `index_profile_id` (`profile_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_captcha
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_captcha`;

CREATE TABLE `opic_captcha` (
  `id` bigint(13) unsigned NOT NULL auto_increment,
  `captcha_time` int(10) unsigned NOT NULL,
  `ip_address` varchar(16) NOT NULL default '0',
  `word` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_claimed_sites
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_claimed_sites`;

CREATE TABLE `opic_claimed_sites` (
  `id` int(11) default NULL,
  `auth_id` varchar(128) default NULL,
  `url` varchar(512) default NULL,
  `title` varchar(256) default NULL,
  `favicon_url` varchar(512) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_contacts
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_contacts`;

CREATE TABLE `opic_contacts` (
  `id` int(11) default NULL,
  `auth_id` varchar(128) default NULL,
  `identity_url` varchar(512) default NULL,
  `title` varchar(256) default NULL,
  `description` varchar(512) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_entries
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_entries`;

CREATE TABLE `opic_entries` (
  `id` int(11) default NULL,
  `feed_id` int(11) default NULL,
  `xml` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_feeds
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_feeds`;

CREATE TABLE `opic_feeds` (
  `id` int(11) default NULL,
  `url` varchar(2000) default NULL,
  `etag` varchar(64) default NULL,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `title` varchar(256) default NULL,
  `subtitle` varchar(512) default NULL,
  `xml` text,
  `claimed_sites_id` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_oid_associations
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_oid_associations`;

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



# Dump of table opic_oid_nonces
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_oid_nonces`;

CREATE TABLE `opic_oid_nonces` (
  `nonce` char(8) NOT NULL,
  `expires` int(11) default NULL,
  PRIMARY KEY  (`nonce`),
  UNIQUE KEY `nonce` (`nonce`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table opic_oid_settings
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_oid_settings`;

CREATE TABLE `opic_oid_settings` (
  `setting` varchar(128) NOT NULL,
  `value` blob,
  PRIMARY KEY  (`setting`),
  UNIQUE KEY `setting` (`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table opic_oid_signins
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_oid_signins`;

CREATE TABLE `opic_oid_signins` (
  `id` int(11) NOT NULL auto_increment,
  `auth_id` varchar(128) default NULL,
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default '0000-00-00 00:00:00',
  `identity` varchar(512) default NULL,
  `last_signin` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_oid_trusted_rps
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_oid_trusted_rps`;

CREATE TABLE `opic_oid_trusted_rps` (
  `id` int(11) NOT NULL auto_increment,
  `auth_id` varchar(128) default NULL,
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default '0000-00-00 00:00:00',
  `expires` timestamp NOT NULL default '0000-00-00 00:00:00',
  `trust_root` varchar(512) NOT NULL default 'none',
  `identity` varchar(512) NOT NULL default 'none',
  PRIMARY KEY  (`id`),
  KEY `index_user_key` (`auth_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_profiles
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_profiles`;

CREATE TABLE `opic_profiles` (
  `id` int(11) NOT NULL auto_increment,
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL default '0000-00-00 00:00:00',
  `last_active` timestamp NOT NULL default '0000-00-00 00:00:00',
  `public_url_path` varchar(256) default NULL,
  `home_url` varchar(256) default NULL,
  `nickname` varchar(128) default NULL,
  `email` varchar(128) default NULL,
  `fullname` varchar(256) default NULL,
  `dob` timestamp NOT NULL default '0000-00-00 00:00:00',
  `gender` varchar(16) default NULL,
  `postcode` varchar(16) default NULL,
  `country` varchar(128) default NULL,
  `language` varchar(128) default NULL,
  `timezone` varchar(128) default NULL,
  `avatar_image` longblob,
  `avatar_mime_type` varchar(128) default NULL,
  `avatar_url` varchar(512) default NULL,
  `avatar_name` varchar(128) default NULL,
  `is_public` int(11) default '1',
  PRIMARY KEY  (`id`),
  KEY `index_urlpath` (`public_url_path`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table opic_scheduled_tasks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `opic_scheduled_tasks`;

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