| Index: trunk/phpwiki/fpw/updSchema.sql |
| — | — | @@ -2,5 +2,17 @@ |
| 3 | 3 | # It adapts the table definitions adds indexes and, if necessary, |
| 4 | 4 | # fills new columns with appropriate values. |
| 5 | 5 | |
| | 6 | +# adding the indexes on the timestamps |
| | 7 | + |
| 6 | 8 | ALTER TABLE cur ADD INDEX timeind (cur_timestamp); |
| 7 | 9 | ALTER TABLE old ADD INDEX timeind (old_timestamp); |
| | 10 | + |
| | 11 | +# adding index on old_title |
| | 12 | + |
| | 13 | +ALTER TABLE old MODIFY old_title VARCHAR(255) BINARY NOT NULL DEFAULT ''; |
| | 14 | +ALTER TABLE old ADD INDEX old_title (old_title); |
| | 15 | + |
| | 16 | +# dropping the superfluous indexes on cur_id and old_id |
| | 17 | + |
| | 18 | +ALTER TABLE cur DROP key cur_id_2; |
| | 19 | +ALTER TABLE old DROP key old_id_2; |