SpamFerret/tables/text

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, 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>