diff options
Diffstat (limited to 'maintenance/tables.sql')
| -rw-r--r-- | maintenance/tables.sql | 54 |
1 files changed, 21 insertions, 33 deletions
diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 02286848..bf93a232 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -182,7 +182,7 @@ CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg -- CREATE TABLE /*_*/user_newtalk ( -- Key to user.user_id - user_id int NOT NULL default 0, + user_id int unsigned NOT NULL default 0, -- If the user is an anonymous user their IP address is stored here -- since the user_id of 0 is ambiguous user_ip varbinary(40) NOT NULL default '', @@ -241,9 +241,6 @@ CREATE TABLE /*_*/page ( -- can move or edit the page. page_restrictions tinyblob NOT NULL, - -- Number of times this page has been viewed. - page_counter bigint unsigned NOT NULL default 0, - -- 1 indicates the article is a redirect. page_is_redirect tinyint unsigned NOT NULL default 0, @@ -307,7 +304,7 @@ CREATE TABLE /*_*/revision ( -- Text comment summarizing the change. -- This text is shown in the history and other changes lists, -- rendered in a subset of wiki markup by Linker::formatComment() - rev_comment tinyblob NOT NULL, + rev_comment varbinary(767) NOT NULL, -- Key to user.user_id of the user who made this edit. -- Stores 0 for anonymous edits and for some mass imports. @@ -374,13 +371,20 @@ CREATE TABLE /*_*/text ( -- Comma-separated list of flags: -- gzip: text is compressed with PHP's gzdeflate() function. - -- utf8: text was stored as UTF-8. - -- If $wgLegacyEncoding option is on, rows *without* this flag - -- will be converted to UTF-8 transparently at load time. + -- utf-8: text was stored as UTF-8. + -- If $wgLegacyEncoding option is on, rows *without* this flag + -- will be converted to UTF-8 transparently at load time. Note + -- that due to a bug in a maintenance script, this flag may + -- have been stored as 'utf8' in some cases (T18841). -- object: text field contained a serialized PHP object. -- The object either contains multiple versions compressed -- together to achieve a better compression ratio, or it refers -- to another row where the text can be found. + -- external: text was stored in an external location specified by old_text. + -- Any additional flags apply to the data stored at that URL, not + -- the URL itself. The 'object' flag is *not* set for URLs of the + -- form 'DB://cluster/id/itemid', because the external storage + -- system itself decompresses these. old_flags tinyblob NOT NULL ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=10240; -- In case tables are created as MyISAM, use row hints for MySQL <5.0 to avoid 4GB limit @@ -407,7 +411,7 @@ CREATE TABLE /*_*/archive ( ar_text mediumblob NOT NULL, -- Basic revision stuff... - ar_comment tinyblob NOT NULL, + ar_comment varbinary(767) NOT NULL, ar_user int unsigned NOT NULL default 0, ar_user_text varchar(255) binary NOT NULL, ar_timestamp binary(14) NOT NULL default '', @@ -697,9 +701,6 @@ CREATE TABLE /*_*/site_stats ( -- The single row should contain 1 here. ss_row_id int unsigned NOT NULL, - -- Total number of page views, if hit counters are enabled. - ss_total_views bigint unsigned default 0, - -- Total number of edits performed. ss_total_edits bigint unsigned default 0, @@ -726,19 +727,6 @@ CREATE TABLE /*_*/site_stats ( -- Pointless index to assuage developer superstitions CREATE UNIQUE INDEX /*i*/ss_row_id ON /*_*/site_stats (ss_row_id); - --- --- Stores an ID for every time any article is visited; --- depending on $wgHitcounterUpdateFreq, it is --- periodically cleared and the page_counter column --- in the page table updated for all the articles --- that have been visited.) --- -CREATE TABLE /*_*/hitcounter ( - hc_id int unsigned NOT NULL -) ENGINE=MEMORY MAX_ROWS=25000; - - -- -- The internet is full of jerks, alas. Sometimes it's handy -- to block a vandal or troll account. @@ -760,7 +748,7 @@ CREATE TABLE /*_*/ipblocks ( ipb_by_text varchar(255) binary NOT NULL default '', -- Text comment made by blocker. - ipb_reason tinyblob NOT NULL, + ipb_reason varbinary(767) NOT NULL, -- Creation (or refresh) date in standard YMDHMS form. -- IP blocks expire automatically. @@ -858,7 +846,7 @@ CREATE TABLE /*_*/image ( -- Description field as entered by the uploader. -- This is displayed in image upload history and logs. - img_description tinyblob NOT NULL, + img_description varbinary(767) NOT NULL, -- user_id and user_name of uploader. img_user int unsigned NOT NULL default 0, @@ -900,7 +888,7 @@ CREATE TABLE /*_*/oldimage ( oi_width int NOT NULL default 0, oi_height int NOT NULL default 0, oi_bits int NOT NULL default 0, - oi_description tinyblob NOT NULL, + oi_description varbinary(767) NOT NULL, oi_user int unsigned NOT NULL default 0, oi_user_text varchar(255) binary NOT NULL, oi_timestamp binary(14) NOT NULL default '', @@ -948,7 +936,7 @@ CREATE TABLE /*_*/filearchive ( -- Deletion information, if this file is deleted. fa_deleted_user int, fa_deleted_timestamp binary(14) default '', - fa_deleted_reason text, + fa_deleted_reason varbinary(767) default '', -- Duped fields from image fa_size int unsigned default 0, @@ -959,7 +947,7 @@ CREATE TABLE /*_*/filearchive ( fa_media_type ENUM("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE") default NULL, fa_major_mime ENUM("unknown", "application", "audio", "image", "text", "video", "message", "model", "multipart", "chemical") default "unknown", fa_minor_mime varbinary(100) default "unknown", - fa_description tinyblob, + fa_description varbinary(767), fa_user int unsigned default 0, fa_user_text varchar(255) binary, fa_timestamp binary(14) default '', @@ -1057,7 +1045,7 @@ CREATE TABLE /*_*/recentchanges ( rc_title varchar(255) binary NOT NULL default '', -- as in revision... - rc_comment varchar(255) binary NOT NULL default '', + rc_comment varbinary(767) NOT NULL default '', rc_minor tinyint unsigned NOT NULL default 0, -- Edits by user accounts with the 'bot' rights key are @@ -1265,7 +1253,7 @@ CREATE TABLE /*_*/logging ( log_page int unsigned NULL, -- Freeform text. Interpreted as edit history comments. - log_comment varchar(255) NOT NULL default '', + log_comment varbinary(767) NOT NULL default '', -- miscellaneous parameters: -- LF separated list (old system) or serialized PHP array (new system) @@ -1424,7 +1412,7 @@ CREATE TABLE /*_*/protected_titles ( pt_namespace int NOT NULL, pt_title varchar(255) binary NOT NULL, pt_user int unsigned NOT NULL, - pt_reason tinyblob, + pt_reason varbinary(767), pt_timestamp binary(14) NOT NULL, pt_expiry varbinary(14) NOT NULL default '', pt_create_perm varbinary(60) NOT NULL |