Toolserver:Database schema/Other

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

Math

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

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

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

Hitcounter table
Field	Type	Null	Key	Default	Extra
hc_id	int(10) unsigned	No		0

Interwiki

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

Category:Database schema