From 5807133b881b38f60e4ec5159f425f1d877424c8 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Tue, 10 Aug 2010 09:33:09 -0400
Subject: [PATCH] - Fix upgrade script for SQLite (#1486903)

---
 CHANGELOG             |    1 +
 SQL/sqlite.update.sql |    2 --
 2 files changed, 1 insertions(+), 2 deletions(-)

diff --git a/CHANGELOG b/CHANGELOG
index 117e1cb..830fc8e 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -3,6 +3,7 @@
 
 - Improve handling of single-part messages with bogus BODYSTRUCTURE (#1486898)
 - Fix path to SQL files when using pgsql/mysqli/sqlsrv drivers (#1486902)
+- Fix upgrade script for SQLite (#1486903)
 
 RELEASE 0.4
 -----------
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index 0f7f994..f2977ef 100644
--- a/SQL/sqlite.update.sql
+++ b/SQL/sqlite.update.sql
@@ -121,8 +121,6 @@
 INSERT INTO tmp_users (user_id, username, mail_host, alias, created, last_login, language, preferences)
     SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM users;
 
-DROP INDEX ix_users_username ON users(username);
-DROP INDEX ix_users_alias ON users(alias);
 DROP TABLE users;
 
 CREATE TABLE users (

--
Gitblit v1.9.1