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; ++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++ 'Italic text'===cu_log=== mysql> describe cu_log; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * 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    |                |
 * 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   |     |         |                |

CodeReview
As of version 1.11 (26 July 2013).

code_authors
mysql> describe code_authors; +--++--+-+-+---+ +--++--+-+-+---+ +--++--+-+-+---+
 * Field       | Type           | Null | Key | Default | Extra |
 * ca_repo_id  | int(11)        | NO   | PRI | NULL    |       |
 * ca_author   | varbinary(255) | NO   | PRI |         |       |
 * ca_user_text | varbinary(255) | YES | MUL | NULL    |       |

code_bugs
mysql> describe code_bugs; ++-+--+-+-+---+ ++-+--+-+-+---+ ++-+--+-+-+---+
 * Field     | Type    | Null | Key | Default | Extra |
 * cb_repo_id | int(11) | NO  | PRI | NULL    |       |
 * cb_from   | int(11) | NO   | PRI | NULL    |       |
 * cb_bug    | int(11) | NO   | PRI | NULL    |       |

code_comment
mysql> describe code_comment; +--++--+-+-++ +--++--+-+-++ +--++--+-+-++
 * Field       | Type           | Null | Key | Default | Extra          |
 * cc_id       | int(11)        | NO   | PRI | NULL    | auto_increment |
 * cc_repo_id  | int(11)        | NO   | MUL | NULL    |                |
 * cc_rev_id   | int(11)        | NO   |     | NULL    |                |
 * cc_text     | blob           | YES  |     | NULL    |                |
 * cc_parent   | int(11)        | YES  |     | NULL    |                |
 * cc_user     | int(11)        | NO   |     | NULL    |                |
 * cc_user_text | varbinary(255) | NO  |     | NULL    |                |
 * cc_timestamp | binary(14)    | NO   |     | NULL    |                |
 * cc_sortkey  | varbinary(255) | YES  |     | NULL    |                |

code_paths
mysql> describe code_paths; +++--+-+-+---+ +++--+-+-+---+ +++--+-+-+---+
 * Field     | Type           | Null | Key | Default | Extra |
 * cp_repo_id | int(11)       | NO   | PRI | NULL    |       |
 * cp_rev_id | int(11)        | NO   | PRI | NULL    |       |
 * cp_path   | varbinary(255) | NO   | PRI | NULL    |       |
 * cp_action | binary(1)      | NO   |     | NULL    |       |

code_prop_changes
mysql> describe code_prop_changes; +---++--+-++---+ +---++--+-++---+ +---++--+-++---+
 * Field        | Type           | Null | Key | Default        | Extra |
 * cpc_repo_id  | int(11)        | NO   | MUL | NULL           |       |
 * cpc_rev_id   | int(11)        | NO   |     | NULL           |       |
 * cpc_attrib   | varbinary(10)  | NO   |     | NULL           |       |
 * cpc_removed  | blob           | YES  |     | NULL           |       |
 * cpc_added    | blob           | YES  |     | NULL           |       |
 * cpc_timestamp | binary(14)    | NO   |     |                |       |
 * cpc_user     | int(11)        | NO   |     | NULL           |       |
 * cpc_user_text | varbinary(255) | NO  |     | NULL           |       |

code_relations
mysql> describe code_relations; ++-+--+-+-+---+ ++-+--+-+-+---+ ++-+--+-+-+---+
 * Field     | Type    | Null | Key | Default | Extra |
 * cf_repo_id | int(11) | NO  | PRI | NULL    |       |
 * cf_from   | int(11) | NO   | PRI | NULL    |       |
 * cf_to     | int(11) | NO   | PRI | NULL    |       |

code_repo
mysql> describe code_repo; +---++--+-+-++ +---++--+-+-++ +---++--+-+-++
 * Field        | Type           | Null | Key | Default | Extra          |
 * repo_id      | int(11)        | NO   | PRI | NULL    | auto_increment |
 * repo_name    | varbinary(255) | NO   | MUL | NULL    |                |
 * repo_path    | varbinary(255) | NO   |     | NULL    |                |
 * repo_viewvc  | varbinary(255) | YES  |     | NULL    |                |
 * repo_bugzilla | varbinary(255) | YES |     | NULL    |                |

code_rev
mysql> describe code_rev; +--++--+-++---+ +--++--+-++---+ +--++--+-++---+
 * Field       | Type           | Null | Key | Default        | Extra |
 * cr_repo_id  | int(11)        | NO   | PRI | NULL           |       |
 * cr_id       | int(11)        | NO   | PRI | NULL           |       |
 * cr_timestamp | binary(14)    | NO   |     |                |       |
 * cr_author   | varbinary(255) | YES  |     | NULL           |       |
 * cr_message  | blob           | YES  |     | NULL           |       |
 * cr_status   | varbinary(25)  | NO   |     | new            |       |
 * cr_path     | varbinary(255) | YES  |     | NULL           |       |
 * cr_diff     | mediumblob     | YES  |     | NULL           |       |
 * cr_flags    | tinyblob       | NO   |     | NULL           |       |

code_signoffs
mysql> describe code_signoffs; +-++--+-++---+ +-++--+-++---+ +-++--+-++---+
 * Field              | Type           | Null | Key | Default        | Extra |
 * cs_repo_id         | int(11)        | NO   | PRI | NULL           |       |
 * cs_rev_id          | int(11)        | NO   | PRI | NULL           |       |
 * cs_user            | int(11)        | NO   |     | NULL           |       |
 * cs_user_text       | varbinary(255) | NO   | PRI | NULL           |       |
 * cs_flag            | varbinary(25)  | NO   | PRI | NULL           |       |
 * cs_timestamp       | binary(14)     | NO   |     |                |       |
 * cs_timestamp_struck | varbinary(14) | NO   | PRI | infinity       |       |

code_tags
mysql> describe code_tags; +++--+-+-+---+ +++--+-+-+---+ +++--+-+-+---+
 * Field     | Type           | Null | Key | Default | Extra |
 * ct_repo_id | int(11)       | NO   | PRI | NULL    |       |
 * ct_rev_id | int(11)        | NO   | PRI | NULL    |       |
 * ct_tag    | varbinary(255) | NO   | PRI | NULL    |       |

datatable2_data
mysql> describe datatable2_data; +---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type             | Null | Key | Default | Extra |
 * dtd_table | varchar(255)    | NO   | MUL |         |       |
 * dtd_page | int(10) unsigned | YES  | MUL | NULL    |       |
 * dtd_01   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_02   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_03   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_04   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_05   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_06   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_07   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_08   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_09   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_10   | varchar(255)     | YES  | MUL | NULL    |       |
 * dtd_11   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_12   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_13   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_14   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_15   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_16   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_17   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_18   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_19   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_20   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_21   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_22   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_23   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_24   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_25   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_26   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_27   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_28   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_29   | varchar(255)     | YES  |     | NULL    |       |
 * dtd_30   | varchar(255)     | YES  |     | NULL    |       |

datatable2_meta
mysql> describe datatable2_meta; +-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+
 * Field      | Type         | Null | Key | Default | Extra |
 * dtm_table  | varchar(255) | NO   | PRI |         |       |
 * dtm_columns | tinyblob    | 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            |                |

password_history
mysql> describe password_history; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field       | Type             | Null | Key | Default | Extra |
 * ph_user     | int(10) unsigned | NO   | PRI | NULL    |       |
 * ph_password | mediumblob       | NO   |     | NULL    |       |
 * ph_timestamp | varbinary(14)   | NO   | PRI |         |       |

securepasswords_uninstall
mysql> describe securepasswords_uninstall; +-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+
 * Field      | Type             | Null | Key | Default | Extra |
 * su_user    | int(10) unsigned | NO   | PRI | NULL    |       |
 * su_password | tinyblob        | NO   |     | NULL    |       |