summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-page_restrictions_sortkey.sql
blob: 6b24e3a502efb4d986a29b04a586b3fefc2b0e41 (plain)
1
2
3
4
5
6
7
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);