Imported Debian patch 0.2~alpha-3

[roundcube.git] / SQL / sqlite.initial.sql

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 041696b1d878b4d365e2af38e4f49b86f3b21378..6adcf4dff908f07f38423f5791a30278058398b5 100644 (file)
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -80,6 +80,9 @@ CREATE TABLE users (
   preferences text NOT NULL default ''
 );
 
+CREATE INDEX ix_users_username ON users(username);
+CREATE INDEX ix_users_alias ON users(alias);
+
 -- --------------------------------------------------------
 
 --