maintenance/archives/patch-page_restrictions_sortkey.sql

   1 -- Add a sort-key to page_restrictions table.
   2 -- First immediate use of this is as a sort-key for coming modifications
   3 -- of Special:Protectedpages.
   4 -- Andrew Garrett, February 2007
   5
   6 ALTER TABLE /*$wgDBprefix*/page_restrictions
   7         ADD COLUMN pr_id int unsigned not null auto_increment,
   8         ADD UNIQUE KEY pr_id (pr_id);