From 3312d6e7db5fc3ff299ac8a6f916b352c57af185 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Tue, 21 Aug 2007 07:16:56 +0200 Subject: [PATCH] Don't forget deleted_images, again. Grmf. --- sql/pr0n.sql | 4 +++- sql/upgrade-v2.50.sql | 13 +++++++++++++ 2 files changed, 16 insertions(+), 1 deletion(-) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index d6af636..318e9da 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -46,7 +46,9 @@ CREATE TABLE deleted_images ( uploadedby character varying, "date" timestamp without time zone, takenby character varying NOT NULL, - selected boolean + selected boolean, + model character varying, + lens character varying ); CREATE TABLE fake_files ( diff --git a/sql/upgrade-v2.50.sql b/sql/upgrade-v2.50.sql index 99cc11d..035f934 100644 --- a/sql/upgrade-v2.50.sql +++ b/sql/upgrade-v2.50.sql @@ -46,3 +46,16 @@ UPDATE images SET lens=COALESCE( SELECT value FROM exif_info WHERE key='Model' AND images.id=exif_info.image )); +ALTER TABLE deleted_images ADD COLUMN model varchar; +ALTER TABLE deleted_images ADD COLUMN lens varchar; +UPDATE deleted_images SET lens=COALESCE( + TRIM(( + SELECT value FROM exif_info WHERE key='Lens' AND deleted_images.id=exif_info.image + )), + TRIM(( + SELECT value FROM exif_info WHERE key='LensSpec' AND deleted_images.id=exif_info.image + )) +), model=TRIM(( + SELECT value FROM exif_info WHERE key='Model' AND deleted_images.id=exif_info.image +)); + -- 2.39.2