" FOREIGN KEY(app_id)\n" \
" REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
+#define QUERY_CREATE_TABLE_PACKAGE_APP_APP_CONTROL_PRIVILEGE \
+ "CREATE TABLE IF NOT EXISTS package_app_app_control_privilege (\n" \
+ " app_id TEXT NOT NULL,\n" \
+ " app_control TEXT NOT NULL,\n" \
+ " privilege TEXT NOT NULL,\n" \
+ " FOREIGN KEY(app_id,app_control)\n" \
+ " REFERENCES package_app_app_control(app_id,app_control) ON DELETE CASCADE)"
+
#define QUERY_CREATE_TABLE_PACKAGE_APP_APP_CATEGORY \
"CREATE TABLE IF NOT EXISTS package_app_app_category (\n" \
" app_id TEXT NOT NULL,\n" \
" FOREIGN KEY(app_id)\n" \
" REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
+#define QUERY_CREATE_TABLE_PACKAGE_APP_DATA_CONTROL_PRIVILEGE \
+ "CREATE TABLE IF NOT EXISTS package_app_data_control_privilege (\n" \
+ " providerid TEXT,\n" \
+ " privilege TEXT NOT NULL,\n" \
+ " type TEXT NOT NULL,\n" \
+ " PRIMARY KEY(providerid, privilege, type)\n" \
+ " FOREIGN KEY(providerid, type)\n" \
+ " REFERENCES package_app_data_control(providerid, type) ON DELETE CASCADE)"
+
#define QUERY_CREATE_TABLE_PACKAGE_APP_INFO_FOR_UID \
"CREATE TABLE IF NOT EXISTS package_app_info_for_uid (\n" \
" app_id TEXT NOT NULL,\n" \
#define QUERY_CREATE_TRIGGER_UPDATE_PACKAGE_APP_INFO_FOR_UID \
"CREATE TRIGGER IF NOT EXISTS update_package_appinfo_for_uid\n"\
- "AFTER UPDATE ON package_app_info_for_uid\n" \
+ "AFTER INSERT ON package_app_info_for_uid\n" \
"BEGIN\n" \
" DELETE FROM package_app_info_for_uid\n"\
" WHERE is_splash_screen_enabled=\n" \
" (SELECT package_app_info.app_splash_screen_display FROM\n" \
" package_app_info, package_app_info_for_uid\n" \
- " WHERE package_app_info.app_id=OLD.app_id) AND is_disabled='false';\n" \
+ " WHERE package_app_info.app_id=NEW.app_id) AND is_disabled='false';\n" \
"END;"
#define QUERY_CREATE_TABLE_PACKAGE_APP_SPLASH_SCREEN \