- Fix broken CREATE INDEX queries in SQLite DDL files (#1488255)

3 files changed, 11 insertions, 9 deletions

diff --git a/CHANGELOG b/CHANGELOG
index 710e6d6d9..6dc891549 100644
--- a/CHANGELOG
+++ b/CHANGELOG
@@ -1,10 +1,17 @@
 CHANGELOG Roundcube Webmail
 ===========================
 
-- Make Roundcube render the Email Standards Project Acid Test correctly
 - Deprecate $DB, $USER, $IMAP global variables, Use $RCMAIL instead
 - Add option to set default font for HTML message (#1484137)
 - Fix issues with big memory allocation of IMAP results
+- Prevent from memory_limit exceeding when trying to parse big messages bodies (#1487424)
+- Add possibility to add SASL mechanisms for SMTP in smtp_connect hook (#1487937)
+- Mark (with different color) folders with recent messages (#1486234)
+- TinyMCE updated to 3.4.6
+
+RELEASE 0.7
+-----------
+- Make Roundcube render the Email Standards Project Acid Test correctly
 - Replace prompt() with jQuery UI dialog (#1485135)
 - Fix navigation in messages search results
 - Improved handling of some malformed values encoded with quoted-printable (#1488232)
@@ -18,18 +25,13 @@ CHANGELOG Roundcube Webmail
 - Fix merging some configuration options in update.sh script (#1485864)
 - Fix so TEXT key will remove all HEADER keys in IMAP SEARCH (#1488208)
 - Fix handling contact photo url with https:// prefix (#1488202)
-- Prevent from memory_limit exceeding when trying to parse big messages bodies (#1487424)
-- Add possibility to add SASL mechanisms for SMTP in smtp_connect hook (#1487937)
-- Mark (with different color) folders with recent messages (#1486234)
 - Fix possible infinite redirect on attachment preview (#1488199)
 - Improved clickjacking protection for browsers which don't support X-Frame-Options headers
 - Fixed bug where similiar folder names were highlighted wrong (#1487860)
 - Fixed bug in handling link with '!' character in it (#1488195)
 - Fixed bug where session ID's length was limited to 40 characters (#1488196)
 - Added About tab in Settings
-- TinyMCE:
-  - updated to 3.4.6
-  - security issue: removed moxieplayer (embedding flv and mp4 is not supported anymore)
+- TinyMCE security issue: removed moxieplayer (embedding flv and mp4 is not supported anymore)
 
 RELEASE 0.7-beta
 ----------------
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 8c8da5c0f..2c4f9dccc 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -147,7 +147,7 @@ CREATE TABLE searches (
   data text NOT NULL
 );
 
-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
+CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
 
 -- --------------------------------------------------------
 
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index 92f6da142..c722a84f8 100644
--- a/SQL/sqlite.update.sql
+++ b/SQL/sqlite.update.sql
@@ -246,7 +246,7 @@ CREATE TABLE searches (
   data text NOT NULL
 );
 
-CREATE UNIQUE INDEX ix_searches_user_type_name (user_id, type, name);
+CREATE UNIQUE INDEX ix_searches_user_type_name ON searches (user_id, type, name);
 
 DROP TABLE messages;