From 50930724ceee00440fb52b8b6a12ded465316d51 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Tue, 21 Aug 2007 07:22:26 +0200 Subject: [PATCH 1/1] Make upgrade SQL for the empty-is-NULL change as well. --- sql/upgrade-v2.50.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql index 035f934..1baba2c 100644 --- a/sql/upgrade-v2.50.sql +++ b/sql/upgrade-v2.50.sql @@ -1,5 +1,5 @@ -- --- Upgrades pre-v2.50 databases to 2.50 format -- not many changes, though. +-- Upgrades pre-v2.50 databases to 2.50 format. -- SET work_mem=131072; @@ -45,6 +45,8 @@ UPDATE images SET lens=COALESCE( ), model=TRIM(( SELECT value FROM exif_info WHERE key='Model' AND images.id=exif_info.image )); +UPDATE images SET model=NULL WHERE model=''; +UPDATE images SET lens=NULL WHERE lens=''; ALTER TABLE deleted_images ADD COLUMN model varchar; ALTER TABLE deleted_images ADD COLUMN lens varchar; @@ -58,4 +60,6 @@ UPDATE deleted_images SET lens=COALESCE( ), model=TRIM(( SELECT value FROM exif_info WHERE key='Model' AND deleted_images.id=exif_info.image )); +UPDATE deleted_images SET model=NULL WHERE model=''; +UPDATE deleted_images SET lens=NULL WHERE lens=''; -- 2.39.2