bindir=@SQL_BINDIR@
cd @working_dir@
+sqlite=@DB_NAME@
-$bindir/sqlite $* bacula.db <<END-OF-DATA
+${bindir}/${sqlite} $* bacula.db <<END-OF-DATA
CREATE TABLE Filename (
- FilenameId INTEGER UNSIGNED AUTOINCREMENT,
+ FilenameId INTEGER,
Name TEXT DEFAULT "",
PRIMARY KEY(FilenameId)
);
CREATE INDEX inx1 ON Filename (Name);
CREATE TABLE Path (
- PathId INTEGER UNSIGNED AUTOINCREMENT,
+ PathId INTEGER,
Path TEXT DEFAULT "",
PRIMARY KEY(PathId)
);
CREATE TABLE File (
- FileId INTEGER UNSIGNED AUTOINCREMENT,
+ FileId INTEGER,
FileIndex INTEGER UNSIGNED NOT NULL,
JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
PathId INTEGER UNSIGNED REFERENCES Path NOT NULL,
-- CREATE INDEX inx9 ON File (JobId, PathId, FilenameId);
CREATE TABLE Job (
- JobId INTEGER UNSIGNED NOT NULL,
+ JobId INTEGER,
Job VARCHAR(128) NOT NULL,
Name VARCHAR(128) NOT NULL,
Type CHAR NOT NULL,
CREATE INDEX inx6 ON Job (Name);
CREATE TABLE FileSet (
- FileSetId INTEGER UNSIGNED AUTOINCREMENT,
+ FileSetId INTEGER,
FileSet VARCHAR(128) NOT NULL,
MD5 VARCHAR(25) NOT NULL,
CreateTime DATETIME DEFAULT 0,
);
CREATE TABLE JobMedia (
- JobMediaId INTEGER UNSIGNED AUTOINCREMENT,
+ JobMediaId INTEGER,
JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
MediaId INTEGER UNSIGNED REFERENCES Media NOT NULL,
FirstIndex INTEGER UNSIGNED NOT NULL,
CREATE TABLE Media (
- MediaId INTEGER UNSIGNED AUTOINCREMENT,
+ MediaId INTEGER,
VolumeName VARCHAR(128) NOT NULL,
Slot INTEGER DEFAULT 0,
PoolId INTEGER UNSIGNED REFERENCES Pool NOT NULL,
MediaType VARCHAR(128) NOT NULL,
+ LabelType TINYINT DEFAULT 0,
FirstWritten DATETIME DEFAULT 0,
LastWritten DATETIME DEFAULT 0,
LabelDate DATETIME DEFAULT 0,
MaxVolFiles INTEGER UNSIGNED DEFAULT 0,
MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
InChanger TINYINT DEFAULT 0,
+ StorageId INTEGER UNSIGNED REFERENCES Storage,
MediaAddressing TINYINT DEFAULT 0,
VolReadTime BIGINT UNSIGNED DEFAULT 0,
VolWriteTime BIGINT UNSIGNED DEFAULT 0,
CREATE INDEX inx8 ON Media (PoolId);
+CREATE TABLE MediaType (
+ MediaTypeId INTEGER,
+ MediaType VARCHAR(128) NOT NULL,
+ ReadOnly TINYINT DEFAULT 0,
+ PRIMARY KEY(MediaTypeId)
+ );
+
+CREATE TABLE Storage (
+ StorageId INTEGER,
+ Name VARCHAR(128) NOT NULL,
+ AutoChanger TINYINT DEFAULT 0,
+ PRIMARY KEY(StorageId)
+ );
+
+CREATE TABLE Device (
+ DeviceId INTEGER,
+ Name VARCHAR(128) NOT NULL,
+ MediaTypeId INTEGER UNSIGNED REFERENCES MediaType NOT NULL,
+ StorageId INTEGER UNSIGNED REFERENCES Storage,
+ DevMounts INTEGER UNSIGNED DEFAULT 0,
+ DevReadBytes BIGINT UNSIGNED DEFAULT 0,
+ DevWriteBytes BIGINT UNSIGNED DEFAULT 0,
+ DevReadBytesSinceCleaning BIGINT UNSIGNED DEFAULT 0,
+ DevWriteBytesSinceCleaning BIGINT UNSIGNED DEFAULT 0,
+ DevReadTime BIGINT UNSIGNED DEFAULT 0,
+ DevWriteTime BIGINT UNSIGNED DEFAULT 0,
+ DevReadTimeSinceCleaning BIGINT UNSIGNED DEFAULT 0,
+ DevWriteTimeSinceCleaning BIGINT UNSIGNED DEFAULT 0,
+ CleaningDate DATETIME DEFAULT 0,
+ CleaningPeriod BIGINT UNSIGNED DEFAULT 0,
+ PRIMARY KEY(DeviceId)
+ );
+
+
CREATE TABLE Pool (
- PoolId INTEGER UNSIGNED AUTOINCREMENT,
+ PoolId INTEGER,
Name VARCHAR(128) NOT NULL,
NumVols INTEGER UNSIGNED DEFAULT 0,
MaxVols INTEGER UNSIGNED DEFAULT 0,
AutoPrune TINYINT DEFAULT 0,
Recycle TINYINT DEFAULT 0,
PoolType VARCHAR(20) NOT NULL,
+ LabelType TINYINT DEFAULT 0,
LabelFormat VARCHAR(128) NOT NULL,
Enabled TINYINT DEFAULT 1,
ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
+ NextPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
+ MigrationHighBytes BIGINT UNSIGNED DEFAULT 0,
+ MigrationLowBytes BIGINT UNSIGNED DEFAULT 0,
+ MigrationTime BIGINT UNSIGNED DEFAULT 0,
UNIQUE (Name),
PRIMARY KEY (PoolId)
);
CREATE TABLE Client (
- ClientId INTEGER UNSIGNED AUTOINCREMENT,
+ ClientId INTEGER,
Name VARCHAR(128) NOT NULL,
Uname VARCHAR(255) NOT NULL, -- uname -a field
AutoPrune TINYINT DEFAULT 0,
);
CREATE TABLE BaseFiles (
- BaseId INTEGER UNSIGNED AUTOINCREMENT,
+ BaseId INTEGER,
BaseJobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
FileId INTEGER UNSIGNED REFERENCES File NOT NULL,
);
CREATE TABLE UnsavedFiles (
- UnsavedId INTEGER UNSIGNED AUTOINCREMENT,
+ UnsavedId INTEGER,
JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
PathId INTEGER UNSIGNED REFERENCES Path NOT NULL,
FilenameId INTEGER UNSIGNED REFERENCES Filename NOT NULL,