MWX/SpamFerret/tables/text

From Woozle Writes Code
< MWX‎ | SpamFerret‎ | tables
Revision as of 20:48, 7 August 2009 by Woozle (talk | contribs) (fixed SQL for table name)
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 `text` (

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

) ENGINE = MYISAM;</mysql>