From f34f5fcbc856bcf7485916dfd8ea540ec362427a Mon Sep 17 00:00:00 2001 From: Bartlomiej Grzelewski Date: Tue, 24 Oct 2017 11:02:00 +0200 Subject: [PATCH] Fix database script Fix update of Tizen Version during application installation. Change-Id: I17db2e6948aefcf625c9db3d2595a5667a74c054 --- db/db.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db/db.sql b/db/db.sql index b4e6087..cf70873 100644 --- a/db/db.sql +++ b/db/db.sql @@ -133,8 +133,8 @@ BEGIN UPDATE pkg SET author_id=(SELECT author_id FROM author WHERE name=NEW.author_name) WHERE name=NEW.pkg_name AND author_id IS NULL; - -- If pkg have already existed with different version do update it - UPDATE app SET version=NEW.version WHERE app_id=NEW.app_id; + -- If app have already existed with different version do update it + UPDATE app SET version=NEW.version WHERE name=NEW.app_name; INSERT OR IGNORE INTO app (pkg_id, name, version) VALUES ( (SELECT pkg_id FROM pkg WHERE name=NEW.pkg_name), -- 2.7.4