Fix bug #2293 bad big endian detection in lz4.c

[bacula/bacula] / bacula / updatedb / update_mysql_tables.in

diff --git a/bacula/updatedb/update_mysql_tables.in b/bacula/updatedb/update_mysql_tables.in
index a80001108f48838e9c08b40655740265e90674dd..08df0d88b305876e4155ff3ec357db9ab25f1b40 100644 (file)
--- 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,
@@ -143,7 +143,4 @@ END-OF-DATA
     fi
 fi
 
-
-END-OF-DATA
-
 exit 0