| Index: branches/license-work/phase3/maintenance/archives/patch-file_props.sql |
| — | — | @@ -4,6 +4,6 @@ |
| 5 | 5 | fp_value_int int signed, |
| 6 | 6 | fp_value_text varbinary(255) |
| 7 | 7 | ) /*$wgDBTableOptions*/; |
| 8 | | -CREATE INDEX /*i*/fp_id_key ON /*_*/file_props (fp_id, fp_key); |
| | 8 | +CREATE INDEX /*i*/fp_rev_id_key ON /*_*/file_props (fp_rev_id, fp_key); |
| 9 | 9 | CREATE INDEX /*i*/fp_key_value_int ON /*_*/file_props (fp_key, fp_value_int); |
| 10 | 10 | CREATE INDEX /*i*/fp_key_value_text ON /*_*/file_props (fp_key, fp_value_text); |
| Index: branches/license-work/phase3/maintenance/sqlite/archives/patch-file_props.sql |
| — | — | @@ -4,6 +4,6 @@ |
| 5 | 5 | fp_value_int int signed, |
| 6 | 6 | fp_value_text varbinary(255) |
| 7 | 7 | ) /*$wgDBTableOptions*/; |
| 8 | | -CREATE INDEX /*i*/fp_id_key ON /*_*/file_props (fp_id, fp_key); |
| | 8 | +CREATE INDEX /*i*/fp_rev_id_key ON /*_*/file_props (fp_rev_id, fp_key); |
| 9 | 9 | CREATE INDEX /*i*/fp_key_value_int ON /*_*/file_props (fp_key, fp_value_int); |
| 10 | 10 | CREATE INDEX /*i*/fp_key_value_text ON /*_*/file_props (fp_key, fp_value_text); |
| Index: branches/license-work/phase3/maintenance/tables.sql |
| — | — | @@ -1459,7 +1459,7 @@ |
| 1460 | 1460 | -- Textual property value, if present |
| 1461 | 1461 | fp_value_text varbinary(255) |
| 1462 | 1462 | ) /*$wgDBTableOptions*/; |
| 1463 | | -CREATE INDEX /*i*/fp_id_key ON /*_*/file_props (fp_id, fp_key); |
| | 1463 | +CREATE INDEX /*i*/fp_rev_id_key ON /*_*/file_props (fp_rev_id, fp_key); |
| 1464 | 1464 | CREATE INDEX /*i*/fp_key_value_int ON /*_*/file_props (fp_key, fp_value_int); |
| 1465 | 1465 | CREATE INDEX /*i*/fp_key_value_text ON /*_*/file_props (fp_key, fp_value_text); |
| 1466 | 1466 | |