# 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
(
primary key (filenameid)
);
+ALTER TABLE filename ALTER COLUMN name SET STATISTICS 1000;
CREATE INDEX filename_name_idx on filename (name);
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
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,
('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);