headzoo

DROP TABLE IF EXISTS `items`;
CREATE TABLE IF NOT EXISTS `items` (
  `iid` bigint(16) unsigned NOT NULL auto_increment,
  `fid` int(10) unsigned NOT NULL default '0',
  `ititle` varchar(255) NOT NULL default '-- untitled --',
  `ilink` varchar(255) NOT NULL default '',
  `idescription` mediumtext,
  `ifetchdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ipubdate` datetime NOT NULL default '0000-00-00 00:00:00',
--  `read` tinyint(1) default '0',
  `saved` tinyint(1) default '0',
  PRIMARY KEY  (`iid`),
  UNIQUE KEY `fIdLink` (`fid`,`ilink`),
FULLTEXT (`ititle`, `idescription`)
) TYPE=MyISAM ;