Difference between revisions of "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
Jump to navigation Jump to search
(first draft)
 
(No difference)

Latest revision as of 01:50, 30 June 2015

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>

Retrieved from "https://htyp.org/mw/index.php?title=User:Woozle/PostFerret/sql/hist&oldid=21057"