User:Woozle/PostFerret/sql/hist
< User:Woozle | PostFerret | sql
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>