maintenance/archives/patch-ipblocks_restrictions-table.sql

   1 -- For partial block restrictions --
   2
   3 CREATE TABLE /*_*/ipblocks_restrictions (
   4   ir_ipb_id int NOT NULL,
   5   ir_type tinyint NOT NULL,
   6   ir_value int NOT NULL,
   7   PRIMARY KEY (ir_ipb_id, ir_type, ir_value)
   8 ) /*$wgDBTableOptions*/;
   9
  10 -- Index to query restrictions by the page or namespace.
  11 CREATE INDEX /*i*/ir_type_value ON /*_*/ipblocks_restrictions (ir_type, ir_value);