Add apis for datacontrol privileges info
[platform/core/appfw/pkgmgr-info.git] / parser / src / pkgmgr_parser_db_queries.h
index 8f2b906..2e6888e 100644 (file)
        "  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" \