ebl Modify disk-changer to check if slot contains something before

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

diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in
index ce6bbdc2855bc84a855f3b57360f3ee91c500580..d63e2de69912d08b1e3768022c5eccbce3b87836 100644 (file)
--- a/bacula/src/cats/make_postgresql_tables.in
+++ b/bacula/src/cats/make_postgresql_tables.in
@@ -14,6 +14,7 @@ CREATE TABLE filename
     primary key (filenameid)
 );
 
+ALTER TABLE filename ALTER COLUMN name SET STATISTICS 1000;
 CREATE INDEX filename_name_idx on filename (name);
 
 CREATE TABLE path
@@ -23,6 +24,7 @@ CREATE TABLE path
     primary key (pathid)
 );
 
+ALTER TABLE path ALTER COLUMN path SET STATISTICS 1000;
 CREATE INDEX path_name_idx on path (path);
 
 CREATE TABLE file
@@ -79,6 +81,9 @@ CREATE TABLE job
 
 CREATE INDEX job_name_idx on job (name);
 
+-- Create a table like Job for long term statistics 
+CREATE TABLE jobstat (LIKE job);
+
 CREATE TABLE Location (
    LocationId        serial      not null,
    Location          text        not null,