"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "src/Tardis/schema/tardis.sql" between
Tardis-1.1.5.tar.gz and Tardis-1.2.1.tar.gz

About: Tardis is a system for making encrypted, incremental backups of filesystems.

tardis.sql  (Tardis-1.1.5):tardis.sql  (Tardis-1.2.1)
skipping to change at line 38 skipping to change at line 38
ClientVersion TEXT, ClientVersion TEXT,
ServerVersion TEXT, ServerVersion TEXT,
SchemaVersion INTEGER, SchemaVersion INTEGER,
ClientIP TEXT, ClientIP TEXT,
FilesFull INTEGER, FilesFull INTEGER,
FilesDelta INTEGER, FilesDelta INTEGER,
BytesReceived INTEGER, BytesReceived INTEGER,
ClientConfigId INTEGER, ClientConfigId INTEGER,
CmdLineId INTEGER, CmdLineId INTEGER,
ServerSession TEXT, ServerSession TEXT,
Exception TEXT,
ErrorMsg TEXT,
FOREIGN KEY(ClientConfigId) REFERENCES ClientConfig(ClientConfigId), FOREIGN KEY(ClientConfigId) REFERENCES ClientConfig(ClientConfigId),
FOREIGN KEY(CmdLineId) REFERENCES Checksums(ChecksumId) FOREIGN KEY(CmdLineId) REFERENCES Checksums(ChecksumId)
); );
CREATE TABLE IF NOT EXISTS CheckSums ( CREATE TABLE IF NOT EXISTS CheckSums (
Checksum TEXT UNIQUE NOT NULL, Checksum TEXT UNIQUE NOT NULL,
ChecksumId INTEGER PRIMARY KEY AUTOINCREMENT, ChecksumId INTEGER PRIMARY KEY AUTOINCREMENT,
Size INTEGER, Size INTEGER,
Basis INTEGER, Basis INTEGER,
DeltaSize INTEGER, DeltaSize INTEGER,
skipping to change at line 109 skipping to change at line 111
INSERT OR IGNORE INTO Backups (Name, StartTime, EndTime, ClientTime, Completed, Priority, FilesFull, FilesDelta, BytesReceived) VALUES (".Initial", 0, 0, 0, 1, 0, 0, 0, 0); INSERT OR IGNORE INTO Backups (Name, StartTime, EndTime, ClientTime, Completed, Priority, FilesFull, FilesDelta, BytesReceived) VALUES (".Initial", 0, 0, 0, 1, 0, 0, 0, 0);
CREATE VIEW IF NOT EXISTS VFiles AS CREATE VIEW IF NOT EXISTS VFiles AS
SELECT Names.Name AS Name, Inode, Device, Parent, ParentDev, Dir, Link, Size , MTime, CTime, ATime, Mode, UID, GID, NLinks, Checksum, Backups.BackupSet, Back ups.Name AS Backup SELECT Names.Name AS Name, Inode, Device, Parent, ParentDev, Dir, Link, Size , MTime, CTime, ATime, Mode, UID, GID, NLinks, Checksum, Backups.BackupSet, Back ups.Name AS Backup
FROM Files FROM Files
JOIN Names ON Files.NameId = Names.NameId JOIN Names ON Files.NameId = Names.NameId
JOIN Backups ON Backups.BackupSet BETWEEN Files.FirstSet AND Files.LastSet JOIN Backups ON Backups.BackupSet BETWEEN Files.FirstSet AND Files.LastSet
LEFT OUTER JOIN CheckSums ON Files.ChecksumId = CheckSums.ChecksumId; LEFT OUTER JOIN CheckSums ON Files.ChecksumId = CheckSums.ChecksumId;
INSERT OR REPLACE INTO Config (Key, Value) VALUES ("SchemaVersion", "17"); INSERT OR REPLACE INTO Config (Key, Value) VALUES ("SchemaVersion", "18");
INSERT OR REPLACE INTO Config (Key, Value) VALUES ("VacuumInterval", "5"); INSERT OR REPLACE INTO Config (Key, Value) VALUES ("VacuumInterval", "5");
 End of changes. 2 change blocks. 
1 lines changed or deleted 3 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)