For symmetry, add this file. At present, all it does is update the version table.

[bacula/bacula] / bacula / src / cats / update_sqlite_tables.in

diff --git a/bacula/src/cats/update_sqlite_tables.in b/bacula/src/cats/update_sqlite_tables.in
index bb83b4f85cadd4ac664a5c680c9c28a56f11a116..66ab352392a7a4a03991aa6f761d02c2f15df906 100755 (executable)
--- a/bacula/src/cats/update_sqlite_tables.in
+++ b/bacula/src/cats/update_sqlite_tables.in
@@ -39,6 +39,7 @@ CREATE TEMPORARY TABLE Media_backup (
    MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
    Drive INTEGER DEFAULT 0,
    InChanger TINYINT DEFAULT 0,
+   MediaAddressing TINYINT DEFAULT 0,
    PRIMARY KEY(MediaId)
    );
 
@@ -49,7 +50,7 @@ INSERT INTO Media_backup SELECT
    VolMounts, VolBytes, VolErrors, VolWrites,
    VolCapacityBytes, VolStatus, Recycle,
    VolRetention, VolUseDuration, MaxVolJobs,
-   MaxVolFiles, MaxVolBytes, 0, 0
+   MaxVolFiles, MaxVolBytes, 0, 0, 0
    FROM Media;
 
 
@@ -81,6 +82,7 @@ CREATE TABLE Media (
    MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
    Drive INTEGER DEFAULT 0,
    InChanger TINYINT DEFAULT 0,
+   MediaAddressing TINYINT DEFAULT 0,
    PRIMARY KEY(MediaId)
    );
 
@@ -91,7 +93,8 @@ INSERT INTO Media (
    VolMounts, VolBytes, VolErrors, VolWrites,
    VolCapacityBytes, VolStatus, Recycle,
    VolRetention, VolUseDuration, MaxVolJobs,
-   MaxVolFiles, MaxVolBytes, Drive, InChanger)
+   MaxVolFiles, MaxVolBytes, Drive, 
+   InChanger, MediaAddressing)
    SELECT * FROM Media_backup;
 
 DROP TABLE Media_backup;