Update NEWS file the 0.7 release.

[cumulus.git] / contrib / upgrade0.7-localdb.sql

diff --git a/contrib/upgrade0.7-localdb.sql b/contrib/upgrade0.7-localdb.sql
new file mode 100644 (file)
index 0000000..a7bf056
--- /dev/null
+++ b/contrib/upgrade0.7-localdb.sql
@@ -0,0 +1,13 @@
+-- SQL script for upgrading the local database to the format expected for LBS
+-- version 0.7 (from a version 0.6 database).
+--
+-- This script should be loaded after connecting to the database to be
+-- upgraded.
+
+-- The subblock_signatures table was added to store a signature for old blocks
+-- for performing subfile incremental backups.
+create table subblock_signatures (
+    blockid integer primary key,
+    algorithm text not null,
+    signatures blob not null
+);