Tweak Windows tray monitor build

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

diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
index f99fd083ff605a284aa90da979f83fadef6ae46d..0018d6b863a855813cf5141dc4871eb2d6ce8fc5 100644 (file)
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -1,76 +1,49 @@
 #!/bin/sh
 #
-# Shell script to update PostgreSQL tables from version 11 to 12
+# Shell script to update PostgreSQL tables from version 12 to 13
+#  or Bacula Community version 5.0.x to 5.2.x
 #
 echo " "
-echo "This script will update a Bacula PostgreSQL database from version 11 to 12"
-echo " which is needed to convert from Bacula Enterprise 2.6 to 4.0 or "
-echo " Standard version 3.0 to 5.0"
+echo "This script will update a Bacula PostgreSQL database from version 12 to 13"
+echo " which is needed to convert from Bacula Enterprise version 2.6.x to 4.0.x"
+echo " or Bacula Community version 5.0.x to 5.2.x"
 echo " "
 
 bindir=@SQL_BINDIR@
 PATH="$bindir:$PATH"
 db_name=@db_name@
 
+DBVERSION=`psql ${db_name} -t --pset format=unaligned -c "select VersionId from Version"`
+if [ $DBVERSION != 12 ] ; then
+   echo " "
+   echo "The existing database is version $DBVERSION !!"
+   echo "This script can only update an existing version 12 database to version 13."
+   echo "Error. Cannot upgrade this database."
+   echo " "
+   exit 1
+fi
+
 if psql -f - -d ${db_name} $* <<END-OF-DATA
 BEGIN; -- Necessary for Bacula core
-ALTER TABLE JobMedia DROP Copy ;
-ALTER TABLE Job ADD COLUMN HasCache smallint default 0;
-ALTER TABLE Job ADD COLUMN Reviewed smallint default 0;
-ALTER TABLE Job ADD COLUMN Comment text;
-ALTER TABLE JobHisto ADD COLUMN HasCache smallint default 0;
-ALTER TABLE JobHisto ADD COLUMN Reviewed smallint default 0;
-ALTER TABLE JobHisto ADD COLUMN Comment text;
-UPDATE Version SET VersionId=12;
-COMMIT;
-
-BEGIN; -- Can conflict with previous Bweb installation
-ALTER TABLE Status ADD COLUMN Severity int;
-UPDATE Status SET Severity = 15;
-UPDATE Status SET Severity = 100 where JobStatus = 'f';
-UPDATE Status SET Severity = 90 where JobStatus = 'A';
-UPDATE Status SET Severity = 10 where JobStatus = 'T';
-UPDATE Status SET Severity = 20 where JobStatus = 'e';
-UPDATE Status SET Severity = 25 where JobStatus = 'E';
-COMMIT;
-
-BEGIN; -- Can already exists if using 3.1.x release
-CREATE TABLE PathHierarchy
-(
-     PathId integer NOT NULL,
-     PPathId integer NOT NULL,
-     CONSTRAINT pathhierarchy_pkey PRIMARY KEY (PathId)
-);
-
-CREATE INDEX pathhierarchy_ppathid 
-          ON PathHierarchy (PPathId);
-
-CREATE TABLE PathVisibility
-(
-      PathId integer NOT NULL,
-      JobId integer NOT NULL,
-      Size int8 DEFAULT 0,
-      Files int4 DEFAULT 0,
-      CONSTRAINT pathvisibility_pkey PRIMARY KEY (JobId, PathId)
-);
-
-CREATE INDEX pathvisibility_jobid
-          ON PathVisibility (JobId);
-
+CREATE TABLE RestoreObject (
+   RestoreObjectId SERIAL NOT NULL,
+   ObjectName TEXT NOT NULL,
+   RestoreObject BYTEA NOT NULL,
+   PluginName TEXT NOT NULL,
+   ObjectLength INTEGER DEFAULT 0,
+   ObjectFullLength INTEGER DEFAULT 0,
+   ObjectIndex INTEGER DEFAULT 0,
+   ObjectType INTEGER DEFAULT 0,
+   FileIndex INTEGER DEFAULT 0,
+   JobId INTEGER,
+   ObjectCompression INTEGER DEFAULT 0,
+   PRIMARY KEY(RestoreObjectId)
+   );
+CREATE INDEX restore_jobid_idx on RestoreObject(JobId);
+
+UPDATE Version SET VersionId=13;
 COMMIT;
 
-CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );
-
--- Remove bad PostgreSQL index
-DROP INDEX file_fp_idx;
-
--- Create the good one
--- If you want to create this index during production, you can use 
--- CREATE INDEX CONCURRENTLY file_jpf_idx ON File (JobId, PathId, FilenameId)
--- to make it without locks (require PostgreSQL 8.2 version)
-
-CREATE INDEX file_jpfid_idx on File (JobId, PathId, FilenameId);
-
 ANALYSE;
 
 END-OF-DATA