Implement pkgmgr plugin execution info

[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 b0051a0..d444f4c 100644 (file)
--- a/parser/src/pkgmgr_parser_db_queries.h
+++ b/parser/src/pkgmgr_parser_db_queries.h
@@ -18,8 +18,6 @@
 #ifndef __PKGMGR_PARSER_DB_QUERIES_H__
 #define __PKGMGR_PARSER_DB_QUERIES_H__
 
-#define PKG_DB_VERSION 30001
-
 #define QUERY_CREATE_TABLE_PACKAGE_INFO \
        "CREATE TABLE IF NOT EXISTS package_info (\n" \
        "  package TEXT PRIMARY KEY NOT NULL,\n" \
@@ -74,6 +72,16 @@
        "  FOREIGN KEY(package)\n" \
        "  REFERENCES package_info(package) ON DELETE CASCADE)"
 
+#define QUERY_CREATE_TABLE_PACKAGE_APPDEFINED_PRIVILEGE_INFO \
+       "CREATE TABLE IF NOT EXISTS package_appdefined_privilege_info (\n" \
+       "  package TEXT NOT NULL,\n" \
+       "  privilege TEXT NOT NULL,\n" \
+       "  license TEXT,\n" \
+       "  type TEXT NOT NULL,\n" \
+       "  PRIMARY KEY(package, privilege, type)\n" \
+       "  FOREIGN KEY(package)\n" \
+       "  REFERENCES package_info(package) ON DELETE CASCADE)"
+
 #define QUERY_CREATE_TABLE_PACKAGE_UPDATE_INFO \
        "CREATE TABLE IF NOT EXISTS package_update_info (\n" \
        "  package TEXT NOT NULL,\n" \
@@ -147,6 +155,8 @@
        "CREATE TABLE IF NOT EXISTS package_app_app_control (\n" \
        "  app_id TEXT NOT NULL,\n" \
        "  app_control TEXT NOT NULL,\n" \
+       "  visibility TEXT NOT NULL DEFAULT 'local-only',\n" \
+       "  app_control_id TEXT NOT NULL DEFAULT 'no-name-app-control',\n" \
        "  PRIMARY KEY(app_id,app_control)\n" \
        "  FOREIGN KEY(app_id)\n" \
        "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
@@ -230,6 +240,23 @@
        "  FOREIGN KEY(app_id)\n" \
        "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
 
+#define QUERY_CREATE_TABLE_PACKAGE_DEPENDENCY_INFO \
+       "CREATE TABLE IF NOT EXISTS package_dependency_info (\n" \
+       "  package TEXT NOT NULL,\n" \
+       "  depends_on TEXT NOT NULL,\n" \
+       "  type TEXT NOT NULL,\n" \
+       "  required_version TEXT,\n" \
+       "  PRIMARY KEY(package, depends_on),\n" \
+       "  FOREIGN KEY(package)\n" \
+       "  REFERENCES package_info(package) ON DELETE CASCADE)"
+
+#define QUERY_CREATE_TABLE_PACKAGE_PLUGIN_INFO \
+       "CREATE TABLE IF NOT EXISTS package_plugin_info (\n" \
+       "  pkgid TEXT NOT NULL,\n" \
+       "  appid TEXT,\n" \
+       "  plugin_type TEXT NOT NULL,\n" \
+       "  plugin_name TEXT NOT NULL)"
+
 /* FIXME: duplicated at pkgmgrinfo_db.c */
 #define QUERY_CREATE_TABLE_PACKAGE_CERT_INDEX_INFO \
        "CREATE TABLE IF NOT EXISTS package_cert_index_info (\n" \