-- MySQL dump 9.10
--
-- Host: localhost    Database: dbagg3
-- ------------------------------------------------------
-- Server version	4.0.17

--
-- Table structure for table `atom_link`
--

CREATE TABLE atom_link (
  id int(11) NOT NULL auto_increment,
  uid varchar(255) NOT NULL default '',
  href varchar(255) default NULL,
  type varchar(255) default NULL,
  rel varchar(255) default NULL,
  title varchar(255) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY uid (uid)
) TYPE=MyISAM;

--
-- Table structure for table `atom_person`
--

CREATE TABLE atom_person (
  id int(11) NOT NULL auto_increment,
  uid varchar(255) NOT NULL default '',
  url varchar(255) default NULL,
  name varchar(255) default NULL,
  email varchar(255) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY uid (uid)
) TYPE=MyISAM;

--
-- Table structure for table `feed`
--

CREATE TABLE feed (
  id int(11) NOT NULL auto_increment,
  data text,
  update_period float default NULL,
  encoding varchar(16) default NULL,
  last_scan datetime default NULL,
  copyright text,
  title varchar(255) default NULL,
  tagline text,
  atom_id varchar(128) default NULL,
  etag varchar(128) default NULL,
  last_etag text,
  last_update datetime default NULL,
  description text,
  format varchar(255) default NULL,
  active tinyint(4) default NULL,
  info text,
  generator text,
  language varchar(8) default NULL,
  created datetime default NULL,
  url varchar(255) NOT NULL default '',
  author_id int(11) default NULL,
  modified datetime default NULL,
  next_scan datetime default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY url (url),
  KEY index_feed_modified (modified)
) TYPE=MyISAM;

--
-- Table structure for table `feed_contributor`
--

CREATE TABLE feed_contributor (
  id int(11) NOT NULL auto_increment,
  feed_id int(11) default NULL,
  atom_person_id int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_entry`
--

CREATE TABLE feed_entry (
  id int(11) NOT NULL auto_increment,
  data text,
  feed_id int(11) default NULL,
  received datetime default NULL,
  uid varchar(255) NOT NULL default '',
  created datetime default NULL,
  issued datetime default NULL,
  title text,
  modified datetime default NULL,
  summary text,
  atom_id varchar(255) default NULL,
  author_id int(11) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY uid (uid),
  KEY index_feed_entry_created (created),
  KEY index_feed_entry_feed_id (feed_id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_entry_content`
--

CREATE TABLE feed_entry_content (
  id int(11) NOT NULL auto_increment,
  feed_entry_id int(11) default NULL,
  value text,
  mode varchar(32) default NULL,
  xml_base text,
  type varchar(32) default NULL,
  PRIMARY KEY  (id),
  KEY index_feed_entry_content_feed_entry_id (feed_entry_id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_entry_contributor`
--

CREATE TABLE feed_entry_contributor (
  id int(11) NOT NULL auto_increment,
  feed_entry_id int(11) default NULL,
  atom_person_id int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_entry_link`
--

CREATE TABLE feed_entry_link (
  id int(11) NOT NULL auto_increment,
  feed_entry_id int(11) default NULL,
  atom_link_id int(11) default NULL,
  PRIMARY KEY  (id),
  KEY index_feed_entry_link_feed_entry_id (feed_entry_id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_link`
--

CREATE TABLE feed_link (
  id int(11) NOT NULL auto_increment,
  feed_id int(11) default NULL,
  atom_link_id int(11) default NULL,
  PRIMARY KEY  (id),
  KEY index_feed_link_feed_id (feed_id)
) TYPE=MyISAM;

--
-- Table structure for table `feed_scan_history`
--

CREATE TABLE feed_scan_history (
  id int(11) NOT NULL auto_increment,
  data text,
  feed_id int(11) default NULL,
  scan_time datetime default NULL,
  total_entries int(11) default NULL,
  http_status int(11) default NULL,
  new_entries int(11) default NULL,
  etag varchar(128) default NULL,
  type varchar(16) default NULL,
  notes text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `user_account`
--

CREATE TABLE user_account (
  id int(11) NOT NULL auto_increment,
  created datetime default NULL,
  atom_person_id int(11) default NULL,
  passwd_hash text,
  name varchar(128) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name),
  KEY index_user_account_atom_person_id (atom_person_id)
) TYPE=MyISAM;

--
-- Table structure for table `user_preference`
--

CREATE TABLE user_preference (
  id int(11) NOT NULL auto_increment,
  user_account_id int(11) default NULL,
  name text,
  value text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `user_subscription`
--

CREATE TABLE user_subscription (
  id int(11) NOT NULL auto_increment,
  feed_id int(11) default NULL,
  category_id int(11) default NULL,
  user_account_id int(11) default NULL,
  PRIMARY KEY  (id),
  KEY index_user_subscription_feed_id (feed_id),
  KEY index_user_subscription_user_account_id (user_account_id)
) TYPE=MyISAM;

--
-- Table structure for table `user_subscription_category`
--

CREATE TABLE user_subscription_category (
  id int(11) NOT NULL auto_increment,
  comment text,
  parent_category_id int(11) default NULL,
  title text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `user_subscription_entry`
--

CREATE TABLE user_subscription_entry (
  id int(11) NOT NULL auto_increment,
  rating float default NULL,
  feed_entry_id int(11) default NULL,
  shown datetime default NULL,
  user_subscription_id int(11) default NULL,
  tag text,
  flags text,
  visited datetime default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `user_subscription_note`
--

CREATE TABLE user_subscription_note (
  id int(11) NOT NULL auto_increment,
  feed_entry_id int(11) default NULL,
  user_subscription_id int(11) default NULL,
  value text,
  name text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `user_subscription_tag`
--

CREATE TABLE user_subscription_tag (
  id int(11) NOT NULL auto_increment,
  feed_entry_id int(11) default NULL,
  user_subscription_id int(11) default NULL,
  value text,
  name text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;