Miscellany

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',  `saved` tinyint(1) default '0',  PRIMARY KEY  (`iid`),  UNIQUE KEY `fIdLink` (`fid`,`ilink`)) TYPE=MyISAM ;CREATE TABLE IF NOT EXISTS `users2read` (  `uid` int(10) unsigned NOT NULL default '0',  `iid` bigint(16) unsigned NOT NULL default '0',  PRIMARY KEY  (`uid`,`iid`)) TYPE=MyISAM;