From 293c09df76232fc8cbed02d896607eca4bcf3e2a Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Mon, 24 Aug 2009 16:53:55 +0200
Subject: [PATCH] Close bug #1351 SQLite2 to SQLite3 conversion

---
 bacula/technotes | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/bacula/technotes b/bacula/technotes
index 7265a48af8..e9e1eaa9b4 100644
--- a/bacula/technotes
+++ b/bacula/technotes
@@ -2,6 +2,18 @@
           
 General:
 
+24Aug09
+kes  Confirmation of procedure suggested for upgrading from SQLite2
+     to SQLite3.  This fixes bug #1351.  Procedure is:
+     echo ".dump" | sqlite bacula.db >bacula.sql
+     mv bacula.db bacula.db.old
+     sed -i -e 's%INTEGER UNSIGNED AUTOINCREMENT,%INTEGER,%g' bacula.sql
+     (note: the above only works on Linux systems. On some systems
+      the -i option is not available. Adapt as necessary)
+     sqlite3 bacula.db
+     .quit
+     sqlite3 bacula.db <bacula.sql
+     rm -f bacula.sql
 23Aug09
 ebl  Run job when double-click in Jobs list item
 ebl  Simplify the code to make TableWidget in read-only
-- 
2.39.5