3 DROP TABLE IF EXISTS ipblocks_tmp
;
4 CREATE TABLE /*_*/ipblocks_tmp (
5 ipb_id
int NOT NULL PRIMARY KEY AUTO_INCREMENT
,
6 ipb_address tinyblob
NOT NULL,
7 ipb_user
int unsigned
NOT NULL default 0,
8 ipb_by
int unsigned
NOT NULL default 0,
9 ipb_by_text
varchar(255) binary NOT NULL default '',
10 ipb_reason
varbinary(767) NOT NULL default '',
11 ipb_reason_id
bigint unsigned
NOT NULL DEFAULT 0,
12 ipb_timestamp
binary(14) NOT NULL default '',
13 ipb_auto bool
NOT NULL default 0,
14 ipb_anon_only bool
NOT NULL default 0,
15 ipb_create_account bool
NOT NULL default 1,
16 ipb_enable_autoblock bool
NOT NULL default '1',
17 ipb_expiry
varbinary(14) NOT NULL default '',
18 ipb_range_start tinyblob
NOT NULL,
19 ipb_range_end tinyblob
NOT NULL,
20 ipb_deleted bool
NOT NULL default 0,
21 ipb_block_email bool
NOT NULL default 0,
22 ipb_allow_usertalk bool
NOT NULL default 0,
23 ipb_parent_block_id
int default NULL
24 ) /*$wgDBTableOptions*/;
26 INSERT OR IGNORE INTO /*_*/ipblocks_tmp (
27 ipb_id
, ipb_address
, ipb_user
, ipb_by
, ipb_by_text
, ipb_reason
,
28 ipb_timestamp
, ipb_auto
, ipb_anon_only
, ipb_create_account
,
29 ipb_enable_autoblock
, ipb_expiry
, ipb_range_start
, ipb_range_end
,
30 ipb_deleted
, ipb_block_email
, ipb_allow_usertalk
, ipb_parent_block_id
)
32 ipb_id
, ipb_address
, ipb_user
, ipb_by
, ipb_by_text
, ipb_reason
,
33 ipb_timestamp
, ipb_auto
, ipb_anon_only
, ipb_create_account
,
34 ipb_enable_autoblock
, ipb_expiry
, ipb_range_start
, ipb_range_end
,
35 ipb_deleted
, ipb_block_email
, ipb_allow_usertalk
, ipb_parent_block_id
38 DROP TABLE /*_*/ipblocks
;
39 ALTER TABLE /*_*/ipblocks_tmp
RENAME TO /*_*/ipblocks
;
40 CREATE UNIQUE INDEX /*i*/ipb_address
ON /*_*/ipblocks (ipb_address(255), ipb_user
, ipb_auto
, ipb_anon_only
);
41 CREATE INDEX /*i*/ipb_user
ON /*_*/ipblocks (ipb_user
);
42 CREATE INDEX /*i*/ipb_range
ON /*_*/ipblocks (ipb_range_start(8), ipb_range_end(8));
43 CREATE INDEX /*i*/ipb_timestamp
ON /*_*/ipblocks (ipb_timestamp
);
44 CREATE INDEX /*i*/ipb_expiry
ON /*_*/ipblocks (ipb_expiry
);
45 CREATE INDEX /*i*/ipb_parent_block_id
ON /*_*/ipblocks (ipb_parent_block_id
);