Add new elements for component-based application
[platform/core/appfw/pkgmgr-info.git] / parser / src / pkgmgr_parser_db_queries.h
index 282918b..f7c063b 100644 (file)
        "  FOREIGN KEY(app_id)\n" \
        "  REFERENCES package_app_info(app_id) ON DELETE CASCADE)"
 
+#define QUERY_CREATE_TABLE_PACKAGE_APP_COMPONENT_INFO \
+       "CREATE TABLE IF NOT EXISTS package_app_component_info (\n" \
+       " app_id TEXT NOT NULL,\n" \
+       " component_id TEXT NOT NULL,\n" \
+       " type TEXT NOT NULL,\n" \
+       " launch_mode TEXT NOT NULL,\n" \
+       " PRIMARY KEY(app_id, component_id)\n" \
+       " 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" \