root/feedmelinks/_config/create-tables.sql

-- MySQL dump 10.10
--
-- Host: localhost    Database: fml_fml
-- ------------------------------------------------------
-- Server version       5.0.27-standard

--
-- Table structure for table `links`
--

DROP TABLE IF EXISTS `links`;
CREATE TABLE `links` (
  `ID` int(11) NOT NULL auto_increment,
  `url` text NOT NULL,
  `name` text NOT NULL,
  `createDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `lastMod` timestamp NOT NULL default '0000-00-00 00:00:00',
  `userid` varchar(16) NOT NULL,
  `groupid` int(11) default NULL,
  `isPrivate` tinyint(4) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `isPrivate_idx` (`isPrivate`),
  KEY `createDate_idx` (`createDate`),
  KEY `userid_idx` (`userid`(10))
) ENGINE=MyISAM AUTO_INCREMENT=322361 DEFAULT CHARSET=latin1;

--
-- Table structure for table `links_tags_xref`
--

DROP TABLE IF EXISTS `links_tags_xref`;
CREATE TABLE `links_tags_xref` (
  `linkID` int(11) NOT NULL default '0',
  `tagID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`linkID`,`tagID`),
  KEY `catID` (`tagID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `referrers`
--

DROP TABLE IF EXISTS `referrers`;
CREATE TABLE `referrers` (
  `id` int(11) NOT NULL auto_increment,
  `linkID` int(11) NOT NULL default '0',
  `userid` varchar(16) NOT NULL default '',
  `referer` varchar(255) NOT NULL default '',
  `timestamp` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=906252 DEFAULT CHARSET=latin1;

--
-- Table structure for table `spam_IPs`
--

DROP TABLE IF EXISTS `spam_IPs`;
CREATE TABLE `spam_IPs` (
  `userid` varchar(24) default NULL,
  `email` varchar(36) default NULL,
  `ip` varchar(24) default NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7888 DEFAULT CHARSET=latin1;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags` (
  `ID` int(11) NOT NULL auto_increment,
  `userid` char(16) default NULL,
  `name` char(255) NOT NULL default '',
  `options` char(16) default NULL,
  `isPrivate` tinyint(4) default NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `userid_name_idx` (`userid`,`name`(32)),
  KEY `id_userid_idx` (`ID`,`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=263577 DEFAULT CHARSET=latin1;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `ID` int(11) NOT NULL auto_increment,
  `userid` varchar(16) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `name` varchar(128) default NULL,
  `options` varchar(16) default NULL,
  `FUQ` tinyint(4) NOT NULL default '2',
  `disabled` int(11) default NULL,
  `snuffed` int(11) default NULL,
  `bornOn` timestamp NOT NULL default '0000-00-00 00:00:00',
  `lastLogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `userid` (`userid`),
  UNIQUE KEY `ID` (`ID`),
  KEY `email_idx` (`email`(32)),
  KEY `disabled_idx` (`disabled`),
  KEY `snuffed_idx` (`snuffed`),
  KEY `bornOn_idx` (`bornOn`)
) ENGINE=MyISAM AUTO_INCREMENT=13284 DEFAULT CHARSET=latin1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

-- Dump completed on 2007-02-17 18:35:34