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

[bacula/bacula] / bacula / updatedb / update_postgresql_tables_8_to_9

diff --git a/bacula/updatedb/update_postgresql_tables_8_to_9 b/bacula/updatedb/update_postgresql_tables_8_to_9
index c97f87144d4d6cd4cdcf1879955af814ad2f3b23..2d43038084679a22a5f5fa200552b403771720e4 100755 (executable)
--- a/bacula/updatedb/update_postgresql_tables_8_to_9
+++ b/bacula/updatedb/update_postgresql_tables_8_to_9
@@ -20,14 +20,14 @@ UPDATE media SET StorageId=0;
 ALTER TABLE pool ADD COLUMN labeltype integer;
 UPDATE pool set labeltype=0;
 ALTER TABLE pool ALTER COLUMN labeltype SET NOT NULL;
 ALTER TABLE pool ADD COLUMN labeltype integer;
 UPDATE pool set labeltype=0;
 ALTER TABLE pool ALTER COLUMN labeltype SET NOT NULL;

-ALTER TABLE pool ADD COLUMN NextPoolId       integer;
-ALTER TABLE pool SET NextPoolId=0;
+ALTER TABLE pool ADD COLUMN NextPoolId        integer;
+UPDATE pool SET NextPoolId=0;

 ALTER TABLE pool ADD COLUMN MigrationHighBytes BIGINT;
 ALTER TABLE pool ADD COLUMN MigrationHighBytes BIGINT;

-ALTER TABLE pool SET MigrationHighBytes=0;
+UPDATE pool SET MigrationHighBytes=0;

 ALTER TABLE pool ADD COLUMN MigrationLowBytes  BIGINT;
 ALTER TABLE pool ADD COLUMN MigrationLowBytes  BIGINT;

-ALTER TABLE pool SET MigrationLowBytes=0;
+UPDATE pool SET MigrationLowBytes=0;

 ALTER TABLE pool ADD COLUMN MigrationTime      BIGINT;
 ALTER TABLE pool ADD COLUMN MigrationTime      BIGINT;

-ALTER TABLE pool SET MigrationTime=0;
+UPDATE pool SET MigrationTime=0;

 
 
 ALTER TABLE jobmedia ADD COLUMN Copy integer;
 
 
 ALTER TABLE jobmedia ADD COLUMN Copy integer;


@@ -51,7 +51,7 @@ CREATE TABLE Device (
    DeviceId SERIAL,
    Name TEXT NOT NULL,
    MediaTypeId INTEGER NOT NULL,
    DeviceId SERIAL,
    Name TEXT NOT NULL,
    MediaTypeId INTEGER NOT NULL,

-   StorageId INTEGER UNSIGNED,
+   StorageId INTEGER,

    DevMounts INTEGER NOT NULL DEFAULT 0,
    DevReadBytes BIGINT NOT NULL DEFAULT 0,
    DevWriteBytes BIGINT NOT NULL DEFAULT 0,
    DevMounts INTEGER NOT NULL DEFAULT 0,
    DevReadBytes BIGINT NOT NULL DEFAULT 0,
    DevWriteBytes BIGINT NOT NULL DEFAULT 0,


@@ -60,7 +60,7 @@ CREATE TABLE Device (
    DevReadTime BIGINT NOT NULL DEFAULT 0,
    DevWriteTime BIGINT NOT NULL DEFAULT 0,
    DevReadTimeSinceCleaning BIGINT NOT NULL DEFAULT 0,
    DevReadTime BIGINT NOT NULL DEFAULT 0,
    DevWriteTime BIGINT NOT NULL DEFAULT 0,
    DevReadTimeSinceCleaning BIGINT NOT NULL DEFAULT 0,

-   DevWriteTimeSinceCleaning BIGINT UNSIGNED DEFAULT 0,
+   DevWriteTimeSinceCleaning BIGINT DEFAULT 0,

    CleaningDate TIMESTAMP WITHOUT TIME ZONE,
    CleaningPeriod BIGINT NOT NULL DEFAULT 0,
    PRIMARY KEY(DeviceId)
    CleaningDate TIMESTAMP WITHOUT TIME ZONE,
    CleaningPeriod BIGINT NOT NULL DEFAULT 0,
    PRIMARY KEY(DeviceId)