diff options
| author | Hwankyu Jhun <h.jhun@samsung.com> | 2021-10-12 14:12:47 +0900 |
|---|---|---|
| committer | Hwankyu Jhun <h.jhun@samsung.com> | 2021-10-12 14:38:09 +0900 |
| commit | 81b924b27b9dfc7c0924c1fde9e9ea431086ca14 (patch) | |
| tree | e1e80073940707ed9ebedee75243cadc8393d359 | |
| parent | 4695a6fef44ebde67ba7707ccd8971ed42c066aa (diff) | |
| download | aul-1-81b924b27b9dfc7c0924c1fde9e9ea431086ca14.tar.gz aul-1-81b924b27b9dfc7c0924c1fde9e9ea431086ca14.tar.bz2 aul-1-81b924b27b9dfc7c0924c1fde9e9ea431086ca14.zip | |
Fix wrong query of alias info
When calling the sqlite3_prepare_v2() function, the error is occurred.
The error is 'foreign key mismatch'. This patch removes unnecessary query.
Change-Id: Id711b8f6fa6a192e55dd35a5e7b3cefc34e4acb8
Signed-off-by: Hwankyu Jhun <h.jhun@samsung.com>
| -rwxr-xr-x | scripts/12_appsvc-add.post | 3 | ||||
| -rw-r--r-- | tool/recovery/appsvc_db_recovery.c | 3 |
2 files changed, 0 insertions, 6 deletions
diff --git a/scripts/12_appsvc-add.post b/scripts/12_appsvc-add.post index 353b232a..2eff973e 100755 --- a/scripts/12_appsvc-add.post +++ b/scripts/12_appsvc-add.post @@ -37,9 +37,6 @@ CREATE TABLE IF NOT EXISTS alias_info_for_uid ( uid INTEGER NOT NULL, is_enabled TEXT NOT NULL DEFAULT 'false', PRIMARY KEY (appid, uid) - FOREIGN KEY (appid) - REFERENCES alias_info(appid) - ON DELETE CASCADE ); CREATE TRIGGER IF NOT EXISTS update_alias_info_for_uid diff --git a/tool/recovery/appsvc_db_recovery.c b/tool/recovery/appsvc_db_recovery.c index 0a53cc7f..20cd07ca 100644 --- a/tool/recovery/appsvc_db_recovery.c +++ b/tool/recovery/appsvc_db_recovery.c @@ -44,9 +44,6 @@ " uid INTEGER NOT NULL,\n" \ " is_enabled TEXT NOT NULL DEFAULT 'false',\n" \ " PRIMARY KEY (appid, uid)\n" \ - " FOREIGN KEY (appid)\n" \ - " REFERENCES alias_info(appid)\n" \ - " ON DELETE CASCADE\n" \ ");\n" \ "CREATE TRIGGER IF NOT EXISTS update_alias_info_for_uid\n" \ " AFTER UPDATE ON alias_info_for_uid\n" \ |