#!/bin/sh
echo " "
echo "This script will update a Bareos PostgreSQL database from version 14 to 2001"
echo " which is needed to convert from Bacula Community version 5.2.x to BAREOS"
echo " "

bindir=/usr/bin
PATH="$bindir:$PATH"
cd /var/lib/bareos
db_name=bareos

DBVERSION=`sqlite3 ${db_name}.db <<END
select VersionId from Version;
END
`
if [ $DBVERSION != 14 ] ; then
   echo " "
   echo "The existing database is version $DBVERSION !!"
   echo "This script can only update an existing version 14 database to version 2001."
   echo "Error. Cannot upgrade this database."
   echo " "
   exit 1
fi

sqlite3 $* ${db_name}.db <<END-OF-DATA
BEGIN;

CREATE TABLE Quota (
   ClientId INTEGER REFERENCES Client DEFAULT 0,
   GraceTime INTEGER UNSIGNED DEFAULT 0,
   QuotaLimit BIGINT UNSIGNED DEFAULT 0,
   PRIMARY KEY (ClientId)
);

CREATE TABLE NDMPLevelMap (
   ClientId INTEGER REFERENCES Client DEFAULT 0,
   FileSetId INTEGER UNSIGNED REFERENCES FileSet DEFAULT 0,
   FileSystem TEXT DEFAULT '',
   DumpLevel INTEGER UNSIGNED DEFAULT 0,
   CONSTRAINT NDMPLevelMap_pkey PRIMARY KEY (ClientId, FilesetId, FileSystem)
);

ALTER TABLE Media ADD COLUMN EncryptionKey VARCHAR(128);

CREATE INDEX IF NOT EXIST inx9 ON Media (StorageId);

UPDATE Version SET VersionId = 2001;
COMMIT;

END-OF-DATA
