https://htyp.org/mw/index.php?action=history&feed=atom&title=User%3AWoozle%2FPostFerret%2Fsql%2Fhist 2026-07-03T14:45:43Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=User:Woozle/PostFerret/sql/hist&diff=21057&oldid=prev 2015-06-30T01:50:26Z

<p>first draft</p> <p><b>New page</b></p><div>==About==<br /> * &#039;&#039;&#039;Purpose&#039;&#039;&#039;: history of {{l/same|text}} edits<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2015-06-29&#039;&#039;&#039; first draft<br /> ==SQL==<br /> &lt;mysql&gt;<br /> CREATE TABLE `pf_hist` (<br /> `ID` INT NOT NULL AUTO_INCREMENT,<br /> `ID_Atom` INT NOT NULL COMMENT &quot;atom.ID (content ID)&quot;,<br /> `ID_Text` INT NOT NULL COMMENT &quot;text.ID (revision ID)&quot;,<br /> `Revision` INT NOT NULL COMMENT &quot;sequential revision number&quot;,<br /> PRIMARY KEY(`ID`)<br /> )<br /> ENGINE = MYISAM;<br /> &lt;/mysql&gt;</div>

Woozle