| Index: trunk/phase3/maintenance/archives/patch-log_search.sql |
| — | — | @@ -4,7 +4,7 @@ |
| 5 | 5 | -- The value of the ID |
| 6 | 6 | ls_value varchar(255) NOT NULL, |
| 7 | 7 | -- Key to log_id |
| 8 | | - ls_log_id int unsigned NOT NULL default 0, |
| 9 | | - PRIMARY KEY (ls_field,ls_value,ls_log_id) |
| | 8 | + ls_log_id int unsigned NOT NULL default 0 |
| 10 | 9 | ) /*$wgDBTableOptions*/; |
| | 10 | +CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id); |
| 11 | 11 | CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -1130,9 +1130,9 @@ |
| 1131 | 1131 | -- The value of the ID |
| 1132 | 1132 | ls_value varchar(255) NOT NULL, |
| 1133 | 1133 | -- Key to log_id |
| 1134 | | - ls_log_id int unsigned NOT NULL default 0, |
| 1135 | | - PRIMARY KEY (ls_field,ls_value,ls_log_id) |
| | 1134 | + ls_log_id int unsigned NOT NULL default 0 |
| 1136 | 1135 | ) /*$wgDBTableOptions*/; |
| | 1136 | +CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id); |
| 1137 | 1137 | CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id); |
| 1138 | 1138 | |
| 1139 | 1139 | |