Initial commit of intern.ccwn.org contentsHEADmaster

1 files changed, 8 insertions, 0 deletions

diff --git a/webmail/SQL/sqlite/2009090400.sql b/webmail/SQL/sqlite/2009090400.sql
new file mode 100644
index 0000000..c8a53ed
--- /dev/null
+++ b/webmail/SQL/sqlite/2009090400.sql
@@ -0,0 +1,8 @@
+-- Updates from version 0.3-stable
+
+DELETE FROM messages;
+DROP INDEX ix_messages_user_cache_uid;
+CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid);
+CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx);
+DROP INDEX ix_contacts_user_id;
+CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);