bindir=@SQL_BINDIR@
cd @working_dir@
-sqlite=@DB_NAME@
+sqlite=@DB_TYPE@
+db_name=@db_name@
-${bindir}/${sqlite} $* bacula.db <<END-OF-DATA
+${bindir}/${sqlite} $* ${db_name}.db <<END-OF-DATA
CREATE TABLE Filename (
FilenameId INTEGER,
Name TEXT DEFAULT "",
HasBase TINYINT DEFAULT 0,
PRIMARY KEY(JobId)
);
-
CREATE INDEX inx6 ON Job (Name);
+-- Create a table like Job for long term statistics
+CREATE TABLE JobStat (LIKE Job);
+
CREATE TABLE Location (
LocationId INTEGER,
- Location TINYBLOB NOT NULL,
- Cost INTEGER,
+ Location TEXT NOT NULL,
+ Cost INTEGER DEFAULT 0,
+ Enabled TINYINT,
PRIMARY KEY(LocationId)
);
+CREATE TABLE LocationLog (
+ LocLogId INTEGER,
+ Date DATETIME NOT NULL,
+ Comment TEXT NOT NULL,
+ MediaId INTEGER UNSIGNED REFERENCES Media DEFAULT 0,
+ LocationId INTEGER UNSIGNED REFERENCES LocationId DEFAULT 0,
+ NewVolStatus VARCHAR(20) NOT NULL,
+ NewEnabled TINYINT NOT NULL,
+ PRIMARY KEY(LocLogId)
+);
+
+
+CREATE TABLE Log (
+ LogId INTEGER,
+ JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
+ Time DATETIME NOT NULL,
+ LogText TEXT NOT NULL,
+ PRIMARY KEY(LogId)
+ );
+CREATE INDEX LogInx1 ON Log (JobId);
+
CREATE TABLE FileSet (
FileSetId INTEGER,
InitialWrite DATETIME DEFAULT 0,
ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
+ Comment TEXT,
PRIMARY KEY(MediaId)
);
PRIMARY KEY (TableName)
);
+
+
-- Initialize JobId to start at 1
INSERT INTO NextId (id, TableName) VALUES (1, "Job");
('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');
-- Initialize Version
INSERT INTO Version (VersionId) VALUES (10);
-PRAGMA default_synchronous = OFF;
-PRAGMA default_cache_size = 10000;
+PRAGMA default_cache_size = 100000;
+PRAGMA synchronous = NORMAL;
END-OF-DATA
-chmod 640 bacula.db
+chmod 640 ${db_name}.db
exit 0