#
# shell script to create Bacula Ingres tables
#
-bindir=@SQL_BINDIR@
+bindir=@INGRES_BINDIR@
PATH="$bindir:$PATH"
db_name=${db_name:-@db_name@}
db_user=${db_user:-@db_user@}
JobId INTEGER NOT NULL,
PathId INTEGER NOT NULL,
FilenameId INTEGER NOT NULL,
+ DeltaSeq INTEGER NOT NULL DEFAULT 0,
MarkId INTEGER NOT NULL DEFAULT 0,
LStat VARBYTE(255) NOT NULL,
Md5 VARBYTE(255) NOT NULL,
INSERT INTO Status (JobStatus,JobStatusLong,Severity) VALUES
('i', 'Doing batch insert file records',15);
-INSERT INTO Version (VersionId) VALUES (12);
+INSERT INTO Version (VersionId) VALUES (@BDB_VERSION@);
-- Make sure we have appropriate permissions
\g