projects
/
cumulus.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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.
-- 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 (
-- The subblock_signatures table was added to store a signature for old blocks
-- for performing subfile incremental backups.
create table subblock_signatures (