From 5c8ff7ef702a598002791f3d2f1a0fa3549b7d6e Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Thu, 11 Feb 2010 17:00:00 +0100
Subject: [PATCH] Apply SQLite3 update fix from bug #1497

---
 bacula/src/cats/update_sqlite3_tables.in | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/bacula/src/cats/update_sqlite3_tables.in b/bacula/src/cats/update_sqlite3_tables.in
index d8bef9626e..0ac663bf0a 100644
--- a/bacula/src/cats/update_sqlite3_tables.in
+++ b/bacula/src/cats/update_sqlite3_tables.in
@@ -42,7 +42,7 @@ CREATE TABLE PathHierarchy
 );
 
 CREATE INDEX pathhierarchy_ppathid 
-          ON PathHierarchy (PPathId);
+	  ON PathHierarchy (PPathId);
 
 CREATE TABLE PathVisibility
 (
@@ -54,7 +54,7 @@ CREATE TABLE PathVisibility
 );
 
 CREATE INDEX pathvisibility_jobid
-          ON PathVisibility (JobId);
+	  ON PathVisibility (JobId);
 
 CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );
 
@@ -62,7 +62,7 @@ UPDATE Version SET VersionId=12;
 COMMIT;
 
 DROP INDEX inx4;
-DROP INDEX inx9; -- can generate errors
+DROP INDEX IF EXISTS inx9;  
 CREATE INDEX file_jpf_idx ON File (JobId, PathId, FilenameId);
 
 END-OF-DATA
-- 
2.39.5