InstaGov/schema/post

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

About

  • Status: superceded (probably) by PostFerret.
  • Purpose: a trackable piece of text (can be modified, has edit history, etc.)
    for handling functionality common to several table types (question, answer, point)
  • Used by: claim; eventually question and answer.
  • History:
    • 2013-03-12 Created, but not yet in use.

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>