Index: trunk/extensions/GlobalBlocking/globalblocking.sql |
— | — | @@ -18,3 +18,14 @@ |
19 | 19 | INDEX gb_timestamp (gb_timestamp), |
20 | 20 | INDEX gb_expiry (gb_expiry) |
21 | 21 | ) /*$wgDBTableOptions*/; |
| 22 | + |
| 23 | +CREATE TABLE /*$wgDBprefix*/global_block_whitelist ( |
| 24 | + gbw_id int(11) NOT NULL, -- Key to gb_id in globalblocks database. |
| 25 | + gbw_address varbinary(255) NOT NULL, |
| 26 | + gbw_by int(11) NOT NULL, -- Key to user_id |
| 27 | + gbw_by_text varchar(255) NOT NULL, |
| 28 | + gbw_reason varchar(255) NOT NULL, |
| 29 | + gbw_expiry binary(14) NOT NULL, |
| 30 | + PRIMARY KEY (gbw_id), |
| 31 | + KEY (gbw_by) |
| 32 | +) /*$wgDBTableOptions*/; |