| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.sql |
| — | — | @@ -20,6 +20,7 @@ |
| 21 | 21 | fr_quality tinyint(1) default 0, |
| 22 | 22 | |
| 23 | 23 | PRIMARY KEY (fr_namespace,fr_title,fr_rev_id), |
| | 24 | + UNIQUE KEY (fr_rev_id), |
| 24 | 25 | UNIQUE KEY (fr_id) |
| 25 | 26 | ) TYPE=InnoDB; |
| 26 | 27 | |
| — | — | @@ -31,7 +32,7 @@ |
| 32 | 33 | frt_value tinyint(2) NOT NULL, |
| 33 | 34 | |
| 34 | 35 | PRIMARY KEY (frt_rev_id,frt_dimension), |
| 35 | | - INDEX frt_rev_dim_val (frt_rev_id,frt_dimension,frt_value) |
| | 36 | + INDEX (frt_rev_id,frt_dimension,frt_value) |
| 36 | 37 | ) TYPE=InnoDB; |
| 37 | 38 | |
| 38 | 39 | -- This stores all of our transclusion revision pointers |