summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-page_restrictions_sortkey.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-page_restrictions_sortkey.sql')
-rw-r--r--maintenance/archives/patch-page_restrictions_sortkey.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/archives/patch-page_restrictions_sortkey.sql b/maintenance/archives/patch-page_restrictions_sortkey.sql
new file mode 100644
index 00000000..6b24e3a5
--- /dev/null
+++ b/maintenance/archives/patch-page_restrictions_sortkey.sql
@@ -0,0 +1,8 @@
+-- Add a sort-key to page_restrictions table.
+-- First immediate use of this is as a sort-key for coming modifications
+-- of Special:Protectedpages.
+-- Andrew Garrett, February 2007
+
+ALTER TABLE /*$wgDBprefix*/page_restrictions
+ ADD COLUMN pr_id int unsigned not null auto_increment,
+ ADD UNIQUE KEY pr_id (pr_id);