LinkFerret/sql/link

About

• Purpose: for posting a link
• History:
  • 2013-06-28
    • Removed ID_User - redundant since we're using post in PostFerret
    • Corrected table name to "link" (was still "post").

SQL

<mysql> CREATE TABLE `link` (

  `ID_Post`     INT              NOT NULL COMMENT "ID of post to which this link is attached",
  `URL`         VARCHAR(255) DEFAULT NULL COMMENT "the link being stored",
  PRIMARY KEY(`ID_Post`),
  UNIQUE KEY `content` (`URL`)
)
ENGINE = MYISAM;

</mysql>