From 649315c457c5755bef9f3f6cf5fecc4b5c48162b Mon Sep 17 00:00:00 2001 From: Dariusz Michaluk Date: Wed, 2 Aug 2017 17:10:12 +0200 Subject: [PATCH] Fix database upgrading from v10 to v11 Change-Id: I54778accfcc2479dd899285c66ba4c3a95329b10 --- db/updates/update-db-to-v11.sql | 23 ++++++++++++++++++++++- 1 file changed, 22 insertions(+), 1 deletion(-) diff --git a/db/updates/update-db-to-v11.sql b/db/updates/update-db-to-v11.sql index 66fb60b..944d756 100644 --- a/db/updates/update-db-to-v11.sql +++ b/db/updates/update-db-to-v11.sql @@ -1 +1,22 @@ --- Dummy script. We only need to trigger db upgrade so that sql gets called and new table is created +BEGIN EXCLUSIVE TRANSACTION; + +PRAGMA user_version = 11; + +CREATE TABLE IF NOT EXISTS app_defined_privilege ( +app_id INTEGER NOT NULL, +uid INTEGER NOT NULL, +privilege VARCHAR NOT NULL, +type INTEGER NOT NULL CHECK (type >= 0 AND type <= 1), +license VARCHAR, +FOREIGN KEY (app_id, uid) REFERENCES user_app (app_id, uid) ON UPDATE CASCADE ON DELETE CASCADE +); + +CREATE TABLE IF NOT EXISTS client_license ( +app_id INTEGER NOT NULL, +uid INTEGER NOT NULL, +privilege VARCHAR NOT NULL, +license VARCHAR NOT NULL, +FOREIGN KEY(app_id, uid) REFERENCES user_app (app_id, uid) ON UPDATE CASCADE ON DELETE CASCADE +); + +COMMIT TRANSACTION; -- 2.7.4