1 PRAGMA journal_mode = PERSIST;
3 CREATE TABLE IF NOT EXISTS appsvc (
5 mime_type TEXT DEFAULT 'NULL',
6 uri TEXT DEFAULT 'NULL',
8 PRIMARY KEY (operation,mime_type,uri)
11 CREATE TABLE IF NOT EXISTS alias_info (
12 alias_appid TEXT NOT NULL,
14 enable TEXT NOT NULL DEFAULT 'true',
15 PRIMARY KEY (alias_appid)
18 CREATE TABLE IF NOT EXISTS alias_info_for_uid (
21 is_enabled TEXT NOT NULL DEFAULT 'false',
22 PRIMARY KEY (appid, uid)
25 CREATE TRIGGER IF NOT EXISTS update_alias_info_for_uid
26 AFTER UPDATE ON alias_info_for_uid
28 DELETE FROM alias_info_for_uid
29 WHERE is_enabled='true';
32 CREATE TABLE IF NOT EXISTS allowed_info (
34 allowed_appid TEXT NOT NULL,
35 PRIMARY KEY (appid, allowed_appid)