From 001b172708f3b4b76ab6f0af7ec720955828f5b1 Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Thu, 07 Mar 2013 03:19:24 -0500
Subject: [PATCH] Mention SQLite database format change in UPGRADING file (#1488983)

---
 UPGRADING |    9 +++++++++
 1 files changed, 9 insertions(+), 0 deletions(-)

diff --git a/UPGRADING b/UPGRADING
index 67c1245..03d5499 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -40,6 +40,7 @@
    open http://url-to-roundcube/installer/ in a browser and choose "3 Test config".
    To enable the latter one, you have to temporary set 'enable_installer'
    to true in your local config/main.inc.php file.
+   WARNING: See SQLite database upgrade below.
 4. Let the update script/installer check your configuration and
    update your config files and database schema as suggested by the updater.
 5. Make sure 'enable_installer' is set to false again.
@@ -54,3 +55,11 @@
    your folder settings contain namespace prefix. For example Courier users
    should add INBOX. prefix to folder names in main configuration file.
 4. Check system requirements in INSTALL file.
+
+SQLite database upgrade
+-----------------------
+Versions older than 0.9 were supporting SQLite v2 only. Newer versions require
+database in v3 format. The best what you can do is to convert database file
+to the new format using command line tools:
+
+sqlite OLD.DB .dump | sqlite3 NEW.DB

--
Gitblit v1.9.1