From b95c876111462ed2696fc91a88955e2e9a445799 Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Mon, 8 Dec 2003 17:45:58 +0000
Subject: [PATCH] Add new MediaAddressing column to Media record

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@836 91ce42f0-d328-0410-95d8-f526ca767f89
---
 bacula/src/cats/make_mysql_tables.in    | 1 +
 bacula/src/cats/make_sqlite_tables.in   | 1 +
 bacula/src/cats/update_mysql_tables.in  | 1 +
 bacula/src/cats/update_sqlite_tables.in | 7 +++++--
 4 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in
index 9c0b5f8166..3c9ff1442c 100644
--- a/bacula/src/cats/make_mysql_tables.in
+++ b/bacula/src/cats/make_mysql_tables.in
@@ -116,6 +116,7 @@ CREATE TABLE Media (
    MaxVolBytes BIGINT UNSIGNED NOT NULL DEFAULT 0,
    Drive INTEGER NOT NULL DEFAULT 0,
    InChanger TINYINT NOT NULL DEFAULT 0,
+   MediaAddressing TINYINT NOT NULL DEFAULT 0,
    PRIMARY KEY(MediaId),
    INDEX (PoolId)
    );
diff --git a/bacula/src/cats/make_sqlite_tables.in b/bacula/src/cats/make_sqlite_tables.in
index ed961d9a2a..8650a7e442 100644
--- a/bacula/src/cats/make_sqlite_tables.in
+++ b/bacula/src/cats/make_sqlite_tables.in
@@ -117,6 +117,7 @@ CREATE TABLE Media (
    MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
    Drive INTEGER DEFAULT 0,
    InChanger TINYINT DEFAULT 0,
+   MediaAddressing TINYINT DEFAULT 0,
    PRIMARY KEY(MediaId)
    );
 
diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in
index 9da912da98..f2934a36d0 100755
--- a/bacula/src/cats/update_mysql_tables.in
+++ b/bacula/src/cats/update_mysql_tables.in
@@ -13,6 +13,7 @@ USE bacula;
 
 ALTER TABLE Media ADD COLUMN Drive INTEGER NOT NULL DEFAULT 0;
 ALTER TABLE Media ADD COLUMN InChanger TINYINT NOT NULL DEFAULT 0;
+ALTER TABLE Media ADD COLUMN MediaAddressing TINYINT NOT NULL DEFAULT 0;
 
 ALTER TABLE Pool ADD COLUMN Enabled TINYINT DEFAULT 1;
 ALTER TABLE Pool ADD COLUMN ScratchPoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool;
diff --git a/bacula/src/cats/update_sqlite_tables.in b/bacula/src/cats/update_sqlite_tables.in
index bb83b4f85c..66ab352392 100755
--- 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;
-- 
2.39.5