User:Woozle/PostFerret/sql/post

About

• Purpose: a trackable piece of text (can be modified, has edit history, etc.)
• History:
  • 2013-03-12 Created, but not yet in use.
• Fields:
  • URI: I haven't yet decided if this really belongs here, but it could be used for either:
    • - a page on the site which is set aside for more information about the given post
    • - the post's official URI on the site

SQL

<mysql> CREATE TABLE `post` (

  `ID`          INT          NOT NULL AUTO_INCREMENT,
  `Summary`     VARCHAR(255)     NOT NULL COMMENT "short description of post, for listings",
  `URI`         VARCHAR(255) DEFAULT NULL COMMENT "site-relative URI for more information",
  `WhenCreated` DATETIME         NOT NULL COMMENT "when this question was entered",
  `WhoCreated`  INT              NOT NULL COMMENT "ID (site-defined) of user who added the question",
  `WhenEdited`  DATETIME     DEFAULT NULL COMMENT "when this question was last edited",
  `WhoEdited`   INT          DEFAULT NULL COMMENT "ID of user who last edited the question",
  `QtyEdits`    INT          DEFAULT NULL COMMENT "number of times this question has been edited",
  PRIMARY KEY(`ID`),
  UNIQUE KEY `content` (`Summary`)
)
ENGINE = MYISAM;

</mysql>