1 -- For partial block restrictions --
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
9 ALTER TABLE &mw_prefix.ipblocks_restrictions
ADD CONSTRAINT ipblocks_restrictions_pk
PRIMARY KEY (ir_ipb_id
, ir_type
, ir_value
);
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
);