root/feedmelinks/_config/SQL/create-tables.sql

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',
  submitter varchar(16) NOT NULL default '',
  groupid int(11) default NULL,
  isPrivate tinyint(4) default NULL,
  PRIMARY KEY  (ID),
  KEY submitter_idx (submitter),
  KEY isPrivate_idx (isPrivate),
  KEY createDate_idx (createDate)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linkMetrics (
  linkID int(11) NOT NULL default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `user` varchar(16) default NULL,
  source varchar(16) default NULL,
  KEY linkid_idx (linkID),
  KEY user_idx (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksCategoriesXRef (
  linkID int(11) NOT NULL default '0',
  catID int(11) NOT NULL default '0',
  PRIMARY KEY  (linkID,catID),
  KEY catID (catID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksComments (
  ID int(11) NOT NULL auto_increment,
  submitter varchar(16) default NULL,
  `comment` text,
  isPrivate tinyint(4) default NULL,
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksCommentsXRef (
  linkID int(11) NOT NULL default '0',
  commentID int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksGroups (
  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 DEFAULT CHARSET=latin1;

CREATE TABLE linksMetrics (
  linkID int(11) NOT NULL default '0',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `user` varchar(16) default NULL,
  source varchar(16) default NULL,
  KEY linkid_idx (linkID),
  KEY user_idx (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksPeepsXRef (
  ID int(11) NOT NULL auto_increment,
  userID varchar(16) NOT NULL default '',
  peepID varchar(16) NOT NULL default '',
  PRIMARY KEY  (ID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksReferers (
  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 DEFAULT CHARSET=latin1;

CREATE TABLE linksUserInfo (
  userid varchar(16) NOT NULL default '',
  age int(11) default NULL,
  city varchar(64) default NULL,
  state varchar(64) default NULL,
  zip int(11) default NULL,
  country varchar(64) default NULL,
  language varchar(64) default NULL,
  lat varchar(16) default NULL,
  latlong varchar(16) default NULL,
  occupation varchar(64) default NULL,
  friendster varchar(64) default NULL,
  flickr varchar(64) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE linksUsers (
  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,
  PRIMARY KEY  (ID),
  UNIQUE KEY userid (userid),
  UNIQUE KEY ID (ID),
  KEY email_idx (email(32))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;