#!/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"
db_name=bareos

DBVERSION=`psql -d ${db_name} -t --pset format=unaligned -c "select VersionId from Version" $*`
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

if psql -f - -d ${db_name} $* <<END-OF-DATA
BEGIN; -- Necessary for Bareos core

CREATE TABLE Quota (
    ClientId          INTEGER     NOT NULL,
    GraceTime         BIGINT      DEFAULT 0,
    QuotaLimit        BIGINT      DEFAULT 0,
    PRIMARY KEY (ClientId)
);

CREATE TABLE NDMPLevelMap (
    ClientId          INTEGER     NOT NULL,
    FilesetId         INTEGER     DEFAULT 0,
    FileSystem        TEXT        NOT NULL,
    DumpLevel         INTEGER     NOT NULL,
    CONSTRAINT NDMPLevelMap_pkey PRIMARY KEY (ClientId, FilesetId, FileSystem)
);

ALTER TABLE Media DROP COLUMN VolParts RESTRICT;
ALTER TABLE Media ADD COLUMN EncryptionKey text;

set client_min_messages = fatal;
CREATE INDEX media_storageid_idx ON Media (StorageId);

UPDATE Version SET VersionId = 2001;
COMMIT;

set client_min_messages = fatal;

ANALYSE;

END-OF-DATA
then
   echo "Update of Bareos PostgreSQL tables succeeded."
else
   echo "Update of Bareos PostgreSQL tables failed."
fi
exit 0
