From 5e3fbc2f79f9b21bc7d162330c3132bacb2a2a4d Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Fri, 20 Nov 2015 18:18:36 -0800 Subject: [PATCH] Tweak copy update_xxx_table.in files from cats to updatedb --- bacula/updatedb/update_mysql_tables.in | 8 ++++---- bacula/updatedb/update_postgresql_tables.in | 8 ++++---- 2 files changed, 8 insertions(+), 8 deletions(-) diff --git a/bacula/updatedb/update_mysql_tables.in b/bacula/updatedb/update_mysql_tables.in index a80001108f..4ae0513679 100644 --- a/bacula/updatedb/update_mysql_tables.in +++ b/bacula/updatedb/update_mysql_tables.in @@ -9,8 +9,8 @@ echo " " echo "This script will update a Bacula MySQL database from version 12-14 to 15" echo " " -echo "Depending on the current version of your catalog, you may have to run this script" -echo " multiple times" +echo "Depending on the current version of your catalog," +echo "you may have to run this script multiple times." echo " " bindir=@MYSQL_BINDIR@ @@ -116,10 +116,10 @@ CREATE TABLE Snapshot ( SnapshotId INTEGER UNSIGNED AUTO_INCREMENT, Name TINYBLOB NOT NULL, JobId INTEGER UNSIGNED DEFAULT 0, - FileSetId INTEGER UNSIGNED DEFAULT 0; + FileSetId INTEGER UNSIGNED DEFAULT 0, CreateTDate BIGINT NOT NULL, CreateDate DATETIME NOT NULL, - ClientId INTEGER DEFAULT 0, + ClientId INTEGER UNSIGNED DEFAULT 0, Volume TINYBLOB NOT NULL, Device TINYBLOB NOT NULL, Type TINYBLOB NOT NULL, diff --git a/bacula/updatedb/update_postgresql_tables.in b/bacula/updatedb/update_postgresql_tables.in index 6681046ccc..c3db92af58 100644 --- a/bacula/updatedb/update_postgresql_tables.in +++ b/bacula/updatedb/update_postgresql_tables.in @@ -3,14 +3,14 @@ # Copyright (C) 2000-2015 Kern Sibbald # License: BSD 2-Clause; see file LICENSE-FOSS # -# Shell script to update MySQL tables from Bacula Community version +# Shell script to update PostgreSQL tables from Bacula Community version # 5.0.x, 5.2.x, 7.0.x # echo " " -echo "This script will update a Bacula MySQL database from version 12-14 to 15" +echo "This script will update a Bacula PostgreSQL database from version 12-14 to 15" echo " " -echo "Depending on the current version of your catalog, you may have to run this script" -echo " multiple times" +echo "Depending on the current version of your catalog," +echo "you may have to run this script multiple times." echo " " bindir=@POSTGRESQL_BINDIR@ -- 2.39.5