Database field prefixes

This is a list of database tables and fields added by various extensions. Registering your tables and fields here helps other developers to avoid name collisions (e.g. of table names and field prefixes) when they create their own tables and fields.

spoofuser
mysql> describe spoofuser; +---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * Field        | Type           | Null | Key | Default | Extra |
 * su_name      | varbinary(255) | NO   | PRI |         |       |
 * su_normalized | varbinary(255) | YES | MUL | NULL    |       |
 * su_legal     | tinyint(1)     | YES  |     | NULL    |       |
 * su_error     | blob           | YES  |     | NULL    |       |

Chat
mysql> describe chathistory; +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field    | Type        | Null | Key | Default | Extra |
 * server   | varchar(32) | NO   | PRI |         |       |
 * group    | varchar(64) | NO   | PRI |         |       |
 * subgroup | varchar(64) | NO   | PRI |         |       |
 * leaf     | varchar(64) | NO   | PRI |         |       |
 * leafvalue | text       | NO   |     | NULL    |       |
 * timestamp | int(11)    | NO   |     | 0       |       |

cu_changes
mysql> describe cu_changes; ++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * Field         | Type                | Null | Key | Default | Extra          |
 * cuc_id        | int(11)             | NO   | PRI | NULL    | auto_increment |
 * cuc_namespace | int(11)             | NO   |     | 0       |                |
 * cuc_title     | varchar(255)        | NO   |     |         |                |
 * cuc_user      | int(11)             | NO   | MUL | 0       |                |
 * cuc_user_text | varchar(255)        | NO   |     |         |                |
 * cuc_actiontext | varchar(255)       | NO   |     |         |                |
 * cuc_comment   | varchar(255)        | NO   |     |         |                |
 * cuc_minor     | tinyint(1)          | NO   |     | 0       |                |
 * cuc_page_id   | int(10) unsigned    | NO   |     | 0       |                |
 * cuc_this_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * cuc_last_oldid | int(10) unsigned   | NO   |     | 0       |                |
 * cuc_type      | tinyint(3) unsigned | NO   |     | 0       |                |
 * cuc_timestamp | char(14)            | NO   | MUL |         |                |
 * cuc_ip        | varchar(255)        | YES  |     |         |                |
 * cuc_ip_hex    | varchar(255)        | YES  | MUL | NULL    |                |
 * cuc_xff       | varchar(255)        | YES  |     |         |                |
 * cuc_xff_hex   | varchar(255)        | YES  | MUL | NULL    |                |
 * cuc_agent     | varchar(255)        | YES  |     | NULL    |                |

cu_log
mysql> describe cu_log; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field          | Type             | Null | Key | Default | Extra          |
 * cul_id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * cul_timestamp  | binary(14)       | NO   | MUL | NULL    |                |
 * cul_user       | int(10) unsigned | NO   | MUL | NULL    |                |
 * cul_user_text  | varbinary(255)   | NO   |     | NULL    |                |
 * cul_reason     | varbinary(255)   | NO   |     | NULL    |                |
 * cul_type       | varbinary(30)    | NO   | MUL | NULL    |                |
 * cul_target_id  | int(10) unsigned | NO   |     | 0       |                |
 * cul_target_text | blob            | NO   |     | NULL    |                |
 * cul_target_hex | varbinary(255)   | NO   | MUL |         |                |
 * cul_range_start | varbinary(255)  | NO   | MUL |         |                |
 * cul_range_end  | varbinary(255)   | NO   |     |         |                |

enh_autopromote
mysql> describe enh_autopromote; +---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * Field                    | Type             | Null | Key | Default | Extra          |
 * eha_id                   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * eha_user                 | int(10) unsigned | NO   |     | NULL    |                |
 * eha_count_reached        | binary(14)       | YES  |     | NULL    |                |
 * eha_captchas_thus_far    | int(11)          | YES  |     | NULL    |                |
 * eha_captcha_count_reached | binary(14)      | YES  |     | NULL    |                |

math
mysql> describe math; ++---+--+-+-+---+ ++---+--+-+-+---+ ++---+--+-+-+---+
 * Field                     | Type          | Null | Key | Default | Extra |
 * math_inputhash            | varbinary(16) | NO   | PRI | NULL    |       |
 * math_outputhash           | varbinary(16) | NO   |     | NULL    |       |
 * math_html_conservativeness | tinyint(4)   | NO   |     | NULL    |       |
 * math_html                 | blob          | YES  |     | NULL    |       |
 * math_mathml               | blob          | YES  |     | NULL    |       |

mathindex
mysql> describe mathindex; +---+--+--+-+---+-+ +---+--+--+-+---+-+ +---+--+--+-+---+-+
 * Field    | Type             | Null | Key | Default           | Extra                       |
 * pageid   | int(10) unsigned | NO   | PRI | NULL              |                             |
 * anchor   | int(6) unsigned  | NO   | PRI | NULL              |                             |
 * inputhash | varbinary(16)   | NO   | MUL | NULL              |                             |
 * timestamp | timestamp       | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |

mathsearch
mysql> describe mathsearch; ++--+--+-+-+---+ ++--+--+-+-+---+ ++--+--+-+-+---+ (this is a view)
 * Field | Type             | Null | Key | Default | Extra |
 * pageid | int(10) unsigned | NO  |     | NULL    |       |
 * anchor | int(6) unsigned | NO   |     | NULL    |       |
 * mathml | text            | YES  |     | NULL    |       |

MirrorTools

 * Note: MirrorTools is undergoing a complete rewrite and these tables will exist in v1.1.0.

mirror_logging
mysql> describe mirror_logging; ++--+--+-+-++ ++--+--+-+-++ ++--+--+-+-++
 * Field         | Type             | Null | Key | Default | Extra          |
 * mrlg_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * mrlg_log_id   | int(10) unsigned | NO   |     | NULL    |                |
 * mrlg_mr_log_id | int(10) unsigned | NO  |     | NULL    |                |

mirror_page
mysql> describe mirror_page; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field          | Type             | Null | Key | Default | Extra          |
 * mrpg_id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * mrpg_page_id   | int(10) unsigned | NO   |     | NULL    |                |
 * mrpg_mr_page_id | int(10) unsigned | NO  |     | NULL    |                |

mirror_revision
mysql> describe mirror_revision; ++--+--+-+++ ++--+--+-+++ ++--+--+-+++
 * Field             | Type             | Null | Key | Default        | Extra          |
 * mrrv_id           | int(10) unsigned | NO   | PRI | NULL           | auto_increment |
 * mrrv_rev_id       | int(10) unsigned | NO   |     | NULL           |                |
 * mrrv_rev_page     | int(10) unsigned | NO   |     | NULL           |                |
 * mrrv_rev_user     | int(10) unsigned | NO   |     | 0              |                |
 * mrrv_rev_user_text | varchar(255)    | NO   |     |                |                |
 * mrrv_timestamp    | binary(14)       | NO   |     |                |                |

mirror_user
mysql> describe mirror_user; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field          | Type             | Null | Key | Default | Extra          |
 * mrus_id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * mrus_user_id   | int(10) unsigned | NO   |     | NULL    |                |
 * mrus_mr_user_id | int(10) unsigned | NO  |     | NULL    |                |

rped_page
mysql> describe rped_page; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field          | Type         | Null | Key | Default | Extra          |
 * rped_page_id   | int(11)      | NO   | PRI | NULL    | auto_increment |
 * rped_page_title | varchar(256) | YES | MUL | NULL    |                |

sacredtext_verses
mysql> describe sacredtext_verses; +---++--+-+-++ +---++--+-+-++ +---++--+-+-++ 8 rows in set (0.00 sec)
 * Field            | Type                                           | Null | Key | Default         | Extra          |
 * st_verse_index   | int(11)                                        | NO   | PRI | NULL            | auto_increment |
 * st_religious_text | enum('Christian Bible','Hebrew Bible','Quran') | NO  |     | Christian Bible |                |
 * st_book          | varbinary(255)                                 | NO   |     | NULL            |                |
 * st_chapter_num   | smallint(6)                                    | NO   |     | NULL            |                |
 * st_verse_num     | smallint(6)                                    | NO   |     | NULL            |                |
 * st_language      | char(2)                                        | NO   |     | en              |                |
 * st_translation   | varchar(255)                                   | NO   |     | NULL            |                |
 * st_text          | text                                           | NO   |     | NULL            |                |