User:Woozle/PostFerret/sql/hist

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< User:Woozle‎ | PostFerret‎ | sql
Revision as of 01:50, 30 June 2015 by Woozle (talk | contribs) (first draft)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: history of text edits
  • History:
    • 2015-06-29 first draft

SQL

<mysql> CREATE TABLE `pf_hist` (

  `ID`           INT NOT NULL AUTO_INCREMENT,
  `ID_Atom`      INT NOT NULL COMMENT "atom.ID (content ID)",
  `ID_Text`      INT NOT NULL COMMENT "text.ID (revision ID)",
  `Revision`     INT NOT NULL COMMENT "sequential revision number",
  PRIMARY KEY(`ID`)
)

ENGINE = MYISAM; </mysql>