LinkFerret/sql/link

About

• Purpose: for posting a link

SQL

<mysql> CREATE TABLE `post` (

  `ID_Post`     INT              NOT NULL COMMENT "ID of post to which this link is attached",
  `ID_User`     INT              NOT NULL COMMENT "ID of user who owns this post",
  `URL`         VARCHAR(255) DEFAULT NULL COMMENT "site-relative URI for more information",
  PRIMARY KEY(`ID_Post`),
  UNIQUE KEY `content` (`URL`)
)
ENGINE = MYISAM;

</mysql>