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.initial.sql | |
| parent | dea67436608e5256c7a328cae8cbf766b970298d (diff) | |
#1485125: added index on messages.created
Diffstat (limited to 'SQL/sqlite.initial.sql')
| -rw-r--r-- | SQL/sqlite.initial.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index 6adcf4dff..4b2c30faa 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -123,3 +123,4 @@ CREATE TABLE messages ( ); CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid); +CREATE INDEX ix_messages_created ON messages (created); |