X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=df3264a43cf963c7b3a451ee6570a2718826ac6f;hb=32fc919220e83872ada63e5e4954d9b7402a66ce;hp=1da651adaf0d395e8bef7b1c349622f5b1f21c6d;hpb=62e3318f82ebc1638d504cef155200999952d31a;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 1da651adaf..df3264a43c 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -592,14 +592,6 @@ CREATE TABLE /*_*/archive ( -- Copied from page_title ar_title varchar(255) binary NOT NULL default '', - -- Copied from text.old_text, for pages deleted before MediaWiki 1.5. - -- This row may contain the raw revision text, possibly compressed. - -- Newer MediaWiki versions use ar_text_id instead. - -- This field is retained for backwards compatibility, so that - -- old archived pages will remain accessible. - -- See migrateArchiveText.php for migrating values to text storage. - ar_text mediumblob NOT NULL, - -- Basic revision stuff... ar_comment varbinary(767) NOT NULL default '', -- Deprecated in favor of ar_comment_id ar_comment_id bigint unsigned NOT NULL DEFAULT 0, -- ("DEFAULT 0" is temporary, signaling that ar_comment should be used) @@ -609,11 +601,6 @@ CREATE TABLE /*_*/archive ( ar_timestamp binary(14) NOT NULL default '', ar_minor_edit tinyint NOT NULL default 0, - -- Copied from text.old_flags, for pages deleted before MediaWiki 1.5. - -- Otherwise empty string. - -- See also note for ar_text. - ar_flags tinyblob NOT NULL, - -- Copied from rev_id. -- -- @since 1.5 Entries from 1.4 will be NULL here. When restoring @@ -626,12 +613,10 @@ CREATE TABLE /*_*/archive ( -- text storage. Instead, it is merely hidden from public view, by removal -- of the page and revision entries. -- - -- @since 1.5 Entries from 1.2-1.4 will have NULL here. When restoring - -- archive rows without this, ar_text and ar_flags are used instead. -- @deprecated since 1.31. If rows in the slots table with slot_revision_id = ar_rev_id - -- exist, this field should be ignored (and may be NULL or 0) in favor of the + -- exist, this field should be ignored (and may be 0) in favor of the -- corresponding data from the slots and content tables - ar_text_id int unsigned, + ar_text_id int unsigned NOT NULL DEFAULT 0, -- Copied from rev_deleted. Although this may be raised during deletion. -- Users with the "suppressrevision" right may "archive" and "suppress"