Toolserver:Database schema/Other
From mediawiki.org
This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.
Other tables
[edit ]| Math table | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| math_inputhash | varchar(16) | No | |||
| math_outputhash | varchar(16) | No | |||
| math_html_conservativeness | tinyint(1) | No | 0 | ||
| math_html | text | Yes | Null | ||
| math_mathml | text | Yes | Null | ||
Site_stats
[edit ]| Site_stats table | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| ss_row_id | int(8) unsigned | No | 0 | ||
| ss_total_views | bigint(20) unsigned | Yes | 0 | ||
| ss_total_edits | bigint(20) unsigned | Yes | 0 | ||
| ss_good_articles | bigint(20) unsigned | Yes | 0 | ||
| ss_total_pages | bigint(20) | Yes | -1 | ||
| ss_users | bigint(20) | Yes | -1 | ||
| ss_admins | int(10) | Yes | -1 | ||
| ss_images | int(10) | Yes | 0 | ||
| Logging table | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| log_type | varchar(10) | No | 0 | ||
| log_action | varchar(10) | No | 0 | ||
| log_timestamp | varchar(14) | No | 19700101000000 | ||
| log_user | int(10) unsigned | No | 0 | ||
| log_namespace | int(11) | No | 0 | ||
| log_title | varchar(255) | No | |||
| log_comment | varchar(255) | No | |||
| log_params | blob | Yes | Null | ||
Hitcounter
[edit ]| Hitcounter table | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| hc_id | int(10) unsigned | No | 0 | ||
| Interwiki table | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| iw_prefix | char(32) | No | |||
| iw_url | char(127) | No | |||
| iw_local | tinyint(1) | No | 0 | ||
| iw_trans | tinyint(1) | No | 0 | ||