| Index: trunk/extensions/AbuseFilter/abusefilter.tables.sql |
| — | — | @@ -15,7 +15,7 @@ |
| 16 | 16 | af_deleted tinyint(1) NOT NULL DEFAULT 0, |
| 17 | 17 | af_actions varchar(255) NOT NULL DEFAULT '', |
| 18 | 18 | af_global tinyint(1) NOT NULL DEFAULT 0, |
| 19 | | - |
| | 19 | + |
| 20 | 20 | PRIMARY KEY (af_id), |
| 21 | 21 | KEY (af_user) |
| 22 | 22 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -24,7 +24,7 @@ |
| 25 | 25 | afa_filter BIGINT unsigned NOT NULL, |
| 26 | 26 | afa_consequence varchar(255) NOT NULL, |
| 27 | 27 | afa_parameters TINYBLOB NOT NULL, |
| 28 | | - |
| | 28 | + |
| 29 | 29 | PRIMARY KEY (afa_filter,afa_consequence), |
| 30 | 30 | KEY (afa_consequence) |
| 31 | 31 | ) /*$wgDBTableOptions*/; |
| — | — | @@ -44,13 +44,17 @@ |
| 45 | 45 | afl_wiki varchar(64) binary NULL, |
| 46 | 46 | afl_deleted tinyint(1) NOT NULL DEFAULT 0, |
| 47 | 47 | afl_patrolled_by int unsigned NULL, |
| 48 | | - |
| | 48 | + afl_rev_id int unsigned, |
| | 49 | + afl_log_id int unsigned, |
| | 50 | + |
| 49 | 51 | PRIMARY KEY (afl_id), |
| 50 | 52 | KEY filter_timestamp (afl_filter,afl_timestamp), |
| 51 | 53 | KEY user_timestamp (afl_user,afl_user_text,afl_timestamp), |
| 52 | 54 | KEY (afl_timestamp), |
| 53 | 55 | KEY page_timestamp (afl_namespace, afl_title, afl_timestamp), |
| 54 | | - KEY ip_timestamp (afl_ip, afl_timestamp) |
| | 56 | + KEY ip_timestamp (afl_ip, afl_timestamp), |
| | 57 | + KEY (afl_rev_id), |
| | 58 | + KEY (afl_log_id) |
| 55 | 59 | ) /*$wgDBTableOptions*/; |
| 56 | 60 | |
| 57 | 61 | CREATE TABLE /*$wgDBprefix*/abuse_filter_history ( |
| — | — | @@ -66,7 +70,7 @@ |
| 67 | 71 | afh_actions BLOB, |
| 68 | 72 | afh_deleted tinyint(1) NOT NULL DEFAULT 0, |
| 69 | 73 | afh_changed_fields varchar(255) NOT NULL DEFAULT '', |
| 70 | | - |
| | 74 | + |
| 71 | 75 | PRIMARY KEY (afh_id), |
| 72 | 76 | KEY (afh_filter), |
| 73 | 77 | KEY (afh_user), |