Store unspecified scheme names in database as empty string, not null.

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

diff --git a/contrib/upgrade0.7-localdb.sql b/contrib/upgrade0.7-localdb.sql
index a7bf056..9fbed0e 100644 (file)
--- a/contrib/upgrade0.7-localdb.sql
+++ b/contrib/upgrade0.7-localdb.sql
@@ -4,6 +4,10 @@
 -- This script should be loaded after connecting to the database to be
 -- upgraded.
 
+-- An unspecified bacukp scheme name is now stored in the database as an empty
+-- string rather than as NULL.
+update snapshots set scheme = '' where scheme is null;
+
 -- The subblock_signatures table was added to store a signature for old blocks
 -- for performing subfile incremental backups.
 create table subblock_signatures (