MWX/SpamFerret/tables/text

From Woozle Writes Code
< MWX‎ | SpamFerret‎ | tables
Revision as of 20:48, 7 August 2009 by Woozle (talk | contribs) (Created page with '==About== * '''Purpose''': for storing complete text of edit attempts and page contents * '''History''': ** '''2009-08-07''' Designed; not deployed yet ==SQL== <mysql>CREATE TABL…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: for storing complete text of edit attempts and page contents
  • History:
    • 2009-08-07 Designed; not deployed yet

SQL

<mysql>CREATE TABLE `attempts` ( 

 `CRC`        INT UNSIGNED NOT NULL COMMENT "crc32(text) for faster indexing",
 `ctext`      MEDIUMBLOB COMMENT "compressed form of text",
 PRIMARY KEY(`CRC`)

) ENGINE = MYISAM;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=MWX/SpamFerret/tables/text&oldid=1325"