diff options
| author | alecpl <alec@alec.pl> | 2008-06-12 17:46:31 +0000 |
|---|---|---|
| committer | alecpl <alec@alec.pl> | 2008-06-12 17:46:31 +0000 |
| commit | c98f3b5d6e4c681b7e42ea71c32cd2ef1991b519 (patch) | |
| tree | 60b76c380431f8c2ef9143164fc1bd79a966dccd /SQL/sqlite.update.sql | |
| parent | dea67436608e5256c7a328cae8cbf766b970298d (diff) | |
#1485125: added index on messages.created
Diffstat (limited to 'SQL/sqlite.update.sql')
| -rw-r--r-- | SQL/sqlite.update.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql index 047fe6731..accf64a73 100644 --- a/SQL/sqlite.update.sql +++ b/SQL/sqlite.update.sql @@ -25,3 +25,7 @@ CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid); CREATE INDEX ix_users_username ON users(username); CREATE INDEX ix_users_alias ON users(alias); + +-- Updates from version 0.2-alpha + +CREATE INDEX ix_messages_created ON messages (created); |