-- MySQL dump 9.09
--
-- Host: localhost    Database: dbagg2
---------------------------------------------------------
-- Server version	4.0.15

--
-- Table structure for table `item`
--

CREATE TABLE item (
  id int(11) NOT NULL auto_increment,
  description text,
  title varchar(255) default NULL,
  created datetime default NULL,
  source_id int(11) default NULL,
  link varchar(255) default NULL,
  date datetime default NULL,
  uniq varchar(255) NOT NULL default '',
  seen tinyint(4) default '0',
  rating float default '0',
  shown tinyint(4) default '0',
  visited tinyint(4) default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY uniq (uniq),
  KEY index_item_id (id),
  KEY index_item_created (created),
  KEY index_item_source_id (source_id),
  KEY index_item_uniq (uniq),
  KEY index_item_date (date),
  KEY index_item_source_id_created (source_id,created),
  KEY index_item_seen (seen),
  KEY index_item_rating (rating),
  KEY index_item_shown (shown),
  KEY index_item_visited (visited)
) TYPE=MyISAM;

--
-- Table structure for table `scan_history`
--

CREATE TABLE scan_history (
  id int(11) NOT NULL auto_increment,
  new_items int(11) default NULL,
  scan_time datetime default NULL,
  notes text,
  http_status int(11) default NULL,
  source_scan_id int(11) default NULL,
  total_items int(11) default NULL,
  PRIMARY KEY  (id),
  KEY index_source_scan_id (source_scan_id),
  KEY index_scan_history_scan_time (scan_time),
  KEY index_scan_history_new_items (new_items),
  KEY index_scan_history_http_status (http_status)
) TYPE=MyISAM;

--
-- Table structure for table `source`
--

CREATE TABLE source (
  id int(11) NOT NULL auto_increment,
  description text,
  language varchar(16) default NULL,
  title varchar(255) default NULL,
  url varchar(255) default NULL,
  created datetime default NULL,
  version varchar(32) default NULL,
  link varchar(255) default NULL,
  type varchar(32) default NULL,
  active int(11) default '1',
  PRIMARY KEY  (id),
  KEY index_source_id (id),
  KEY index_source_url (url)
) TYPE=MyISAM;

--
-- Table structure for table `source_scan`
--

CREATE TABLE source_scan (
  id int(11) NOT NULL auto_increment,
  update_period float default NULL,
  next_update datetime default NULL,
  source_id int(11) default NULL,
  etag varchar(255) default NULL,
  last_update_with_new datetime default NULL,
  last_update datetime default NULL,
  modified datetime NOT NULL default '1975-10-24 00:00:00',
  PRIMARY KEY  (id),
  KEY index_source_id (source_id),
  KEY index_source_scan_last_update_with_new (last_update_with_new)
) TYPE=MyISAM;