LinkFerret/sql/link

From ICMS
< LinkFerret‎ | sql
Revision as of 18:25, 23 March 2013 by Woozle (talk | contribs) (I wrote this many days ago. Firefox didn't lose it. Yay!)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: for posting a link

SQL

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;