From e1174cfafe4a2e6d1f09dfcecac220fb9908368f Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Tue, 13 Mar 2007 23:02:43 +0000 Subject: [PATCH] *Add ar_len, remove reference to archive2 for Postgres --- maintenance/archives/patch-ar_len.sql | 3 +++ maintenance/mysql5/tables-binary.sql | 4 +++- maintenance/mysql5/tables.sql | 4 +++- maintenance/postgres/tables.sql | 3 ++- maintenance/updaters.inc | 1 + 5 files changed, 12 insertions(+), 3 deletions(-) create mode 100644 maintenance/archives/patch-ar_len.sql diff --git a/maintenance/archives/patch-ar_len.sql b/maintenance/archives/patch-ar_len.sql new file mode 100644 index 0000000000..69e634b08d --- /dev/null +++ b/maintenance/archives/patch-ar_len.sql @@ -0,0 +1,3 @@ +ALTER TABLE /*$wgDBprefix*/archive + ADD ar_len INT(8) UNSIGNED; + diff --git a/maintenance/mysql5/tables-binary.sql b/maintenance/mysql5/tables-binary.sql index 2b82a4f5fd..688771dea3 100644 --- a/maintenance/mysql5/tables-binary.sql +++ b/maintenance/mysql5/tables-binary.sql @@ -394,7 +394,9 @@ CREATE TABLE /*$wgDBprefix*/archive ( -- rev_deleted for archives ar_deleted tinyint(1) unsigned NOT NULL default '0', - + -- Length of this revision in bytes + ar_len int(8) unsigned, + KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp) ) ENGINE=InnoDB, DEFAULT CHARSET=binary; diff --git a/maintenance/mysql5/tables.sql b/maintenance/mysql5/tables.sql index 4aff4bc959..834901eb45 100644 --- a/maintenance/mysql5/tables.sql +++ b/maintenance/mysql5/tables.sql @@ -385,7 +385,9 @@ CREATE TABLE /*$wgDBprefix*/archive ( -- rev_deleted for archives ar_deleted tinyint(1) unsigned NOT NULL default '0', - + -- Length of this revision in bytes + rev_len int(8) unsigned, + KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp) ) ENGINE=InnoDB, DEFAULT CHARSET=utf8; diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index ac0cc36da6..e06969c894 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -136,8 +136,9 @@ CREATE TABLE archive ( ar_rev_id INTEGER, ar_text_id INTEGER, ar_deleted INTEGER NOT NULL DEFAULT '0', + ar_len INTEGER NULL, ); -CREATE INDEX archive_name_title_timestamp ON archive2 (ar_namespace,ar_title,ar_timestamp); +CREATE INDEX archive_name_title_timestamp ON archive (ar_namespace,ar_title,ar_timestamp); CREATE TABLE redirect ( rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 2fe36538d8..fe64fb9257 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -74,6 +74,7 @@ $wgNewFields = array( array( 'filearchive', 'fa_deleted', 'patch-fa_deleted.sql' ), array( 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ), array( 'revision', 'rev_len', 'patch-rev_len.sql' ), + array( 'archive', 'ar_len', 'patch-ar_len.sql' ), array( 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ), ); -- 2.20.1