X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;ds=sidebyside;f=bacula%2Fsrc%2Fcats%2Fmake_sqlite_tables.in;h=d9516deda4b66c7db191dff31ed6f6c1815c2c60;hb=5b4e4c084dfebb100fc278a396cfceb90edd2446;hp=8bac3c7a6a13c7b6e600c5a4180680a4afbdbeec;hpb=db408b1c519492b0bf19c56ebba5414858c3f5ea;p=bacula%2Fbacula diff --git a/bacula/src/cats/make_sqlite_tables.in b/bacula/src/cats/make_sqlite_tables.in index 8bac3c7a6a..d9516deda4 100644 --- a/bacula/src/cats/make_sqlite_tables.in +++ b/bacula/src/cats/make_sqlite_tables.in @@ -104,7 +104,6 @@ CREATE TABLE Media ( VolBytes BIGINT UNSIGNED DEFAULT 0, VolErrors INTEGER UNSIGNED DEFAULT 0, VolWrites INTEGER UNSIGNED DEFAULT 0, - MaxVolBytes BIGINT UNSIGNED DEFAULT 0, VolCapacityBytes BIGINT UNSIGNED DEFAULT 0, VolStatus VARCHAR(20) NOT NULL, Recycle TINYINT DEFAULT 0, @@ -112,6 +111,7 @@ CREATE TABLE Media ( VolUseDuration BIGINT UNSIGNED DEFAULT 0, MaxVolJobs INTEGER UNSIGNED DEFAULT 0, MaxVolFiles INTEGER UNSIGNED DEFAULT 0, + MaxVolBytes BIGINT UNSIGNED DEFAULT 0, PRIMARY KEY(MediaId) ); @@ -128,7 +128,8 @@ CREATE TABLE Pool ( VolRetention BIGINT UNSIGNED DEFAULT 0, VolUseDuration BIGINT UNSIGNED DEFAULT 0, MaxVolJobs INTEGER UNSIGNED DEFAULT 0, - MaxVolfiles INTEGER UNSIGNED DEFAULT 0, + MaxVolFiles INTEGER UNSIGNED DEFAULT 0, + MaxVolBytes BIGINT UNSIGNED DEFAULT 0, AutoPrune TINYINT DEFAULT 0, Recycle TINYINT DEFAULT 0, PoolType VARCHAR(20) NOT NULL, @@ -163,7 +164,7 @@ CREATE TABLE Version ( ); -- Initialize Version -INSERT INTO Version (VersionId) VALUES (4); +INSERT INTO Version (VersionId) VALUES (5); CREATE TABLE Counters ( Counter TEXT NOT NULL,