X-Git-Url: http://review.tizen.org/git/?a=blobdiff_plain;f=parser%2Fsrc%2Fpkgmgr_parser_db_queries.h;h=d444f4c348c4c6595ee4c3e50687abde26a344e8;hb=aa88d97f98ae9093f07947ec8397e15e07e1dac3;hp=5576034ebb0f682ff68581fc795a01f1ae70cfd2;hpb=48a1c2fe69e8678a6cf8d6f812b96784d1454346;p=platform%2Fcore%2Fappfw%2Fpkgmgr-info.git

diff --git a/parser/src/pkgmgr_parser_db_queries.h b/parser/src/pkgmgr_parser_db_queries.h
index 5576034..d444f4c 100644
--- a/parser/src/pkgmgr_parser_db_queries.h
+++ b/parser/src/pkgmgr_parser_db_queries.h
@@ -72,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" \
@@ -141,30 +151,12 @@
 	"  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" \
 	"  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)"
@@ -194,32 +186,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" \
@@ -274,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" \