diff options
| author | Evan Prodromou <evan@status.net> | 2009-11-10 16:27:23 -0500 |
|---|---|---|
| committer | Evan Prodromou <evan@status.net> | 2009-11-10 16:27:23 -0500 |
| commit | 1f5f5474f175a8248b362f8be4ff23bb5e971305 (patch) | |
| tree | c38d9b80db71ba403c61079502bc12bfe2732654 /db/08to09.sql | |
| parent | 348b155376eac2130150cd041bca9fd4799334cf (diff) | |
| parent | 651cbf0681b6d263dde673ce36811710bfe553b8 (diff) | |
Merge branch '0.9.x' into adminpanel
Diffstat (limited to 'db/08to09.sql')
| -rw-r--r-- | db/08to09.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/08to09.sql b/db/08to09.sql index a0e37f0f1..1d37a759d 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -42,3 +42,12 @@ create table login_token ( constraint primary key (user_id) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; +alter table fave + drop index fave_user_id_idx, + add index fave_user_id_idx (user_id,modified); + +alter table subscription + drop index subscription_subscriber_idx, + add index subscription_subscriber_idx (subscriber,created), + drop index subscription_subscribed_idx, + add index subscription_subscribed_idx (subscribed,created); |