User:Woozle/PostFerret/sql/atom

About

• Purpose:
• Fields:
• History:
  • 2013-03-12 Created, but not yet in use.
  • 2013-03-15 Most fields moved from post to atom.
  • 2013-06-28 "Summary" can't be a key if it's no longer a field.

SQL

<mysql> CREATE TABLE `atom` (

  `ID`          INT              NOT NULL AUTO_INCREMENT,
  `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`),
)
ENGINE = MYISAM;

</mysql>