1 -- SQL script for upgrading the local database to the format expected for LBS
2 -- version 0.7 (from a version 0.6 database).
4 -- This script should be loaded after connecting to the database to be
7 -- An unspecified bacukp scheme name is now stored in the database as an empty
8 -- string rather than as NULL.
9 update snapshots set scheme = '' where scheme is null;
11 -- The subblock_signatures table was added to store a signature for old blocks
12 -- for performing subfile incremental backups.
13 create table subblock_signatures (
14 blockid integer primary key,
15 algorithm text not null,
16 signatures blob not null