Correct some problems with database creation (new tables).

[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 33c6f09be4b32b06ccf6d984cf1d486afd13a3a9..92fd0c1be452591783a35d046ed32c11a6774c11 100755 (executable)
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -40,10 +40,10 @@ CREATE TABLE MAC (
 );
 
 CREATE TABLE Location (
-   LocationId SERIAL,
+   LocationId SERIAL NOT NULL,
    Location TEXT NOT NULL,
-   PRIMARY KEY(LocationId)
-   );
+   PRIMARY KEY (LocationId)
+);
 
 
 INSERT INTO version (versionId) VALUES (9);