From f05712c0b5add5fb7953219ee20e734455cd8c16 Mon Sep 17 00:00:00 2001 From: Kern Sibbald 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