From 8543b2c5dbe1400d0e15c4af1fd85ac50da1f82e Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sun, 22 Jul 2007 01:40:58 +0000 Subject: [PATCH] *Add ar_page; allows for easier restoration when several large pages are merged into one deleted history. --- maintenance/archives/patch-archive-ar_page.sql | 6 ++++++ maintenance/updaters.inc | 2 ++ 2 files changed, 8 insertions(+) create mode 100644 maintenance/archives/patch-archive-ar_page.sql diff --git a/maintenance/archives/patch-archive-ar_page.sql b/maintenance/archives/patch-archive-ar_page.sql new file mode 100644 index 0000000000..1ee35f6104 --- /dev/null +++ b/maintenance/archives/patch-archive-ar_page.sql @@ -0,0 +1,6 @@ +-- Key to page_id. Usefull for sysadmin fixing of large +-- pages merged together in the archives +-- Added 2007-07-21 + +ALTER TABLE /*$wgDBprefix*/archive + ADD ar_page int unsigned NOT NULL; diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 8a7c02eeb1..5dffc0c128 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -80,6 +80,7 @@ $wgNewFields = array( array( 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ), array( 'ipblocks', 'ipb_block_email', 'patch-ipb_emailban.sql' ), array( 'oldimage', 'oi_metadata', 'patch-oi_metadata.sql'), + array( 'archive', 'ar_page', 'patch-archive-ar_page.sql'), ); # For extensions only, should be populated via hooks @@ -1347,6 +1348,7 @@ function do_postgres_updates() { array("recentchanges", "rc_old_len", "INTEGER"), array("recentchanges", "rc_params", "TEXT"), array("revision", "rev_len", "INTEGER"), + array("archive", "ar_page", "INTEGER NOT NULL DEFAULT 0"), ); -- 2.20.1