diff options
| author | Brion Vibber <brion@pobox.com> | 2010-03-01 12:20:04 -0800 |
|---|---|---|
| committer | Brion Vibber <brion@pobox.com> | 2010-03-01 12:20:04 -0800 |
| commit | e529ceee21b4fb0c18f32f7a097bce14229af42f (patch) | |
| tree | af9439c9425ebf1f759787f150bfcab3aec47823 /db/08to09.sql | |
| parent | 6ea9eb33d2767df26fb757e3b507dd2e7e7c7286 (diff) | |
Add index on post_id for file_to_post, needed for efficient lookups of files/urls attached to a given post.
Diffstat (limited to 'db/08to09.sql')
| -rw-r--r-- | db/08to09.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/08to09.sql b/db/08to09.sql index b10e47dbc..582981614 100644 --- a/db/08to09.sql +++ b/db/08to09.sql @@ -110,3 +110,5 @@ insert into queue_item_new (frame,transport,created,claimed) alter table queue_item rename to queue_item_old; alter table queue_item_new rename to queue_item; +alter table file_to_post + add index post_id_idx (post_id); |