MWX/SpamFerret/tables/text: Difference between revisions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
(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…') |
m (Woozle moved page SpamFerret/tables/text to MWX/SpamFerret/tables/text without leaving a redirect: most mediawiki extensions belong under MWX now) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
** '''2009-08-07''' Designed; not deployed yet | ** '''2009-08-07''' Designed; not deployed yet | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `text` ( | ||
`CRC` INT UNSIGNED NOT NULL COMMENT "crc32(text) for faster indexing", | `CRC` INT UNSIGNED NOT NULL COMMENT "crc32(text) for faster indexing", | ||
`ctext` MEDIUMBLOB COMMENT "compressed form of text", | `ctext` MEDIUMBLOB COMMENT "compressed form of text", | ||
PRIMARY KEY(`CRC`) | PRIMARY KEY(`CRC`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
Latest revision as of 20:14, 1 May 2022
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>