maintenance/oracle/archives/patch-ipblocks_restrictions-table.sql

   1 -- For partial block restrictions --
   2
   3 CREATE TABLE &mw_prefix.ipblocks_restrictions (
   4   ir_ipb_id NUMBER NOT NULL,
   5   ir_type NUMBER NOT NULL,
   6   ir_value NUMBER NOT NULL
   7 );
   8
   9 ALTER TABLE &mw_prefix.ipblocks_restrictions ADD CONSTRAINT ipblocks_restrictions_pk PRIMARY KEY (ir_ipb_id, ir_type, ir_value);
  10
  11 -- Index to query restrictions by the page or namespace.
  12 CREATE INDEX &mw_prefix.ir_type_value ON &mw_prefix.ipblocks_restrictions (ir_type, ir_value);