Remove unused db table and api

[platform/core/appfw/pkgmgr-info.git] / parser / src / pkgmgr_parser_db_queries.h

diff --git a/parser/src/pkgmgr_parser_db_queries.h b/parser/src/pkgmgr_parser_db_queries.h
index 8f2b906..2190eb3 100644 (file)
--- a/parser/src/pkgmgr_parser_db_queries.h
+++ b/parser/src/pkgmgr_parser_db_queries.h
@@ -141,26 +141,6 @@
        "  FOREIGN KEY(app_id)\n" \
        "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
 
-#define QUERY_CREATE_TABLE_PACKAGE_APP_ICON_SECTION_INFO \
-       "CREATE TABLE IF NOT EXISTS package_app_icon_section_info (\n" \
-       "  app_id TEXT NOT NULL,\n" \
-       "  app_icon TEXT,\n" \
-       "  app_icon_section TEXT NOT NULL,\n" \
-       "  app_icon_resolution TEXT NOT NULL,\n" \
-       "  PRIMARY KEY(app_id,app_icon_section,app_icon_resolution)\n" \
-       "  FOREIGN KEY(app_id)\n" \
-       "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
-
-#define QUERY_CREATE_TABLE_PACKAGE_APP_IMAGE_INFO \
-       "CREATE TABLE IF NOT EXISTS package_app_image_info (\n" \
-       "  app_id TEXT NOT NULL,\n" \
-       "  app_locale TEXT DEFAULT 'No Locale',\n" \
-       "  app_image_section TEXT NOT NULL,\n" \
-       "  app_image TEXT,\n" \
-       "  PRIMARY KEY(app_id,app_image_section)\n" \
-       "  FOREIGN KEY(app_id)\n" \
-       "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
-
 #define QUERY_CREATE_TABLE_PACKAGE_APP_APP_CONTROL \
        "CREATE TABLE IF NOT EXISTS package_app_app_control (\n" \
        "  app_id TEXT NOT NULL,\n" \
@@ -169,6 +149,14 @@
        "  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" \
@@ -186,32 +174,6 @@
        "  FOREIGN KEY(app_id)\n" \
        "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
 
-#define QUERY_CREATE_TABLE_PACKAGE_APP_APP_PERMISSION \
-       "CREATE TABLE IF NOT EXISTS package_app_app_permission (\n" \
-       "  app_id TEXT NOT NULL,\n" \
-       "  pm_type TEXT NOT NULL,\n" \
-       "  pm_value TEXT NOT NULL,\n" \
-       "  PRIMARY KEY(app_id, pm_type, pm_value)\n" \
-       "  FOREIGN KEY(app_id)\n" \
-       "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
-
-#define QUERY_CREATE_TABLE_PACKAGE_APP_SHARE_ALLOWED \
-       "CREATE TABLE IF NOT EXISTS package_app_share_allowed (\n" \
-       "  app_id TEXT NOT NULL,\n" \
-       "  data_share_path TEXT NOT NULL,\n" \
-       "  data_share_allowed TEXT NOT NULL,\n" \
-       "  PRIMARY KEY(app_id,data_share_path,data_share_allowed)\n" \
-       "  FOREIGN KEY(app_id)\n" \
-       "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
-
-#define QUERY_CREATE_TABLE_PACKAGE_APP_SHARE_REQUEST \
-       "CREATE TABLE IF NOT EXISTS package_app_share_request (\n" \
-       "  app_id TEXT NOT NULL,\n" \
-       "  data_share_request TEXT NOT NULL,\n" \
-       "  PRIMARY KEY(app_id,data_share_request)\n" \
-       "  FOREIGN KEY(app_id)\n" \
-       "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
-
 #define QUERY_CREATE_TABLE_PACKAGE_APP_DATA_CONTROL \
        "CREATE TABLE IF NOT EXISTS package_app_data_control (\n" \
        "  app_id TEXT NOT NULL,\n" \
@@ -223,6 +185,15 @@
        "  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" \