From 4a3f1fdfe1eb3743564adcee35d5513224339260 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?J=C3=B6rg=20Frings-F=C3=BCrst?= Date: Fri, 25 Nov 2016 04:10:33 +0100 Subject: New upstream version 0.25.1 --- src/db/PhotoTable.vala | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'src/db/PhotoTable.vala') diff --git a/src/db/PhotoTable.vala b/src/db/PhotoTable.vala index f774df5..4304da8 100644 --- a/src/db/PhotoTable.vala +++ b/src/db/PhotoTable.vala @@ -162,7 +162,14 @@ public class PhotoTable : DatabaseTable { // https://bugzilla.gnome.org/show_bug.cgi?id=742670 // // 1) index on md5,file_format - res = db.prepare_v2 ("CREATE UNIQUE INDEX IF NOT EXISTS PhotoTableMD5Format on PhotoTable(md5, file_format)", -1, out stmt); + res = db.prepare_v2 ("DROP INDEX IF EXISTS PhotoTableMD5Format", -1, out stmt); + assert (res == Sqlite.OK); + res = stmt.step (); + if (res != Sqlite.DONE) { + DatabaseTable.warning ("Failed to drop old PhotoTable index", res); + } + + res = db.prepare_v2 ("CREATE INDEX IF NOT EXISTS PhotoTableMD5FormatV2 on PhotoTable(md5, file_format)", -1, out stmt); assert (res == Sqlite.OK); res = stmt.step (); if (res != Sqlite.DONE) { -- cgit v1.2.3