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 a10925554d3b23a3a623ab5fde44e8d32dd0179e..d63e2de69912d08b1e3768022c5eccbce3b87836 100644 (file)
--- a/bacula/src/cats/make_postgresql_tables.in
+++ b/bacula/src/cats/make_postgresql_tables.in
@@ -3,8 +3,9 @@
 # shell script to create Bacula PostgreSQL tables
 #
 bindir=@SQL_BINDIR@
+db_name=@db_name@
 
-$bindir/psql -f - -d bacula $* <<END-OF-DATA
+$bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
 
 CREATE TABLE filename
 (
@@ -13,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
@@ -22,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
@@ -78,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,
@@ -264,7 +270,7 @@ CREATE TABLE LocationLog (
    MediaId INTEGER DEFAULT 0,
    LocationId INTEGER DEFAULT 0,
    newvolstatus text not null
-       check (volstatus in ('Full','Archive','Append',
+       check (newvolstatus in ('Full','Archive','Append',
              'Recycle','Purged','Read-Only','Disabled',
              'Error','Busy','Used','Cleaning','Scratch')),
    newenabled smallint,
@@ -361,7 +367,10 @@ INSERT INTO Status (JobStatus,JobStatusLong) VALUES
    ('t', 'Waiting on start time');
 INSERT INTO Status (JobStatus,JobStatusLong) VALUES
    ('p', 'Waiting on higher priority jobs');
-
+INSERT INTO Status (JobStatus,JobStatusLong) VALUES
+   ('a', 'SD despooling attributes');
+INSERT INTO Status (JobStatus,JobStatusLong) VALUES
+   ('i', 'Doing batch insert file records');
 
 INSERT INTO Version (VersionId) VALUES (10);