root/feedmelinks/_config/SQL/ddl.sql

-- MySQL dump 9.09
--
-- Host: db26.pair.com    Database: hirokai_jm3DataMart
-- ------------------------------------------------------
-- Server version       4.0.14-log

--
-- Table structure for table `linkMetrics`
--

DROP TABLE IF EXISTS linkMetrics;
CREATE TABLE linkMetrics (
  linkID int(11) NOT NULL default '0',
  date timestamp(14) NOT NULL,
  user varchar(16) default NULL,
  source varchar(16) default NULL,
  KEY linkid_idx (linkID),
  KEY user_idx (user)
) TYPE=MyISAM;

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

DROP TABLE IF EXISTS links;
CREATE TABLE links (
  ID int(11) NOT NULL auto_increment,
  url blob NOT NULL,
  name blob,
  createDate timestamp(14) NOT NULL,
  lastMod timestamp(14) NOT NULL,
  submitter varchar(16) NOT NULL default '',
  groupid int(11) default NULL,
  options varchar(16) default NULL,
  isPrivate tinyint(4) default NULL,
  PRIMARY KEY  (ID),
  KEY submitter_idx (submitter),
  KEY isPrivate_idx (isPrivate),
  KEY createDate_idx (createDate)
) TYPE=MyISAM;

--
-- Table structure for table `linksCategoriesXRef`
--

DROP TABLE IF EXISTS linksCategoriesXRef;
CREATE TABLE linksCategoriesXRef (
  linkID int(11) NOT NULL default '0',
  catID int(11) NOT NULL default '0',
  PRIMARY KEY  (linkID,catID)
) TYPE=MyISAM;

--
-- Table structure for table `linksComments`
--

DROP TABLE IF EXISTS linksComments;
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)
) TYPE=MyISAM;

--
-- Table structure for table `linksCommentsXRef`
--

DROP TABLE IF EXISTS linksCommentsXRef;
CREATE TABLE linksCommentsXRef (
  linkID int(11) NOT NULL default '0',
  commentID int(11) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Table structure for table `linksGroups`
--

DROP TABLE IF EXISTS linksGroups;
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,
  PRIMARY KEY  (ID),
  UNIQUE KEY ID (ID),
  KEY userid_name_idx (userid,name(32)),
  KEY id_userid_idx (ID,userid)
) TYPE=MyISAM;

--
-- Table structure for table `linksReferers`
--

DROP TABLE IF EXISTS linksReferers;
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)
) TYPE=MyISAM;

--
-- Table structure for table `linksUsers`
--

DROP TABLE IF EXISTS linksUsers;
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))
) TYPE=MyISAM;

--
-- Table structure for table `tempLinks`
--

DROP TABLE IF EXISTS tempLinks;
CREATE TABLE tempLinks (
  ID int(11) NOT NULL auto_increment,
  url blob NOT NULL,
  name blob,
  createDate timestamp(14) NOT NULL,
  lastMod timestamp(14) NOT NULL,
  submitter varchar(16) NOT NULL default '',
  groupid int(11) default NULL,
  options varchar(16) default NULL,
  isPrivate tinyint(4) default NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;