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    |       |

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            |                |