tizen 2.4 release

[framework/web/wrt-commons.git] / modules / widget_dao / orm / wrt_db

diff --git a/modules_wearable/widget_dao/orm/wrt_db b/modules/widget_dao/orm/wrt_db
old mode 100755 (executable)
new mode 100644 (file)
similarity index 95%
rename from modules_wearable/widget_dao/orm/wrt_db
rename to modules/widget_dao/orm/wrt_db
index 168302a..eb4527d
--- a/modules_wearable/widget_dao/orm/wrt_db
+++ b/modules/widget_dao/orm/wrt_db
@@ -13,14 +13,10 @@ CREATE_TABLE(WidgetInfo)
     COLUMN(author_name,             TEXT,    DEFAULT '')
     COLUMN(author_email,            TEXT,    DEFAULT '')
     COLUMN(author_href,             TEXT,    DEFAULT '')
-    COLUMN(base_folder,             TEXT,    DEFAULT '')
-    COLUMN(webkit_plugins_required, TINYINT, DEFAULT 0)
     COLUMN(csp_policy,              TEXT,    DEFAULT '')
     COLUMN(csp_policy_report_only,  TEXT,    DEFAULT '')
-    COLUMN(wac_signed,              INT,     DEFAULT 0)
     COLUMN(min_version,             TEXT,    DEFAULT '1.0')
     COLUMN_NOT_NULL(back_supported, TINYINT, DEFAULT 0)
-    COLUMN(access_network,          TINYINT, DEFAULT 0)
     COLUMN(defaultlocale,           TEXT,    DEFAULT 0)
     COLUMN_NOT_NULL(tizen_pkgid,    TEXT,    DEFAULT '')
     COLUMN_NOT_NULL(tizen_appid,    TEXT,    DEFAULT 0 UNIQUE)
@@ -67,12 +63,8 @@ CREATE_TABLE_END()
 
 CREATE_TABLE(WidgetExtendedInfo)
     COLUMN_NOT_NULL(app_id,     INTEGER,        PRIMARY KEY)
-    COLUMN(last_update_time,    BIGINT,         DEFAULT 0)
     COLUMN(install_time,        BIGINT,         DEFAULT 0)
-    COLUMN(option_state,        INT,            DEFAULT 0)
     COLUMN(updated,             INT,            DEFAULT 0)
-    COLUMN(update_policy,       INT,            DEFAULT 0)
-    COLUMN_NOT_NULL(test_widget, INT, CHECK(test_widget between 0 and 1) DEFAULT 0)
     COLUMN(splash_img_src,      TEXT,           DEFAULT '')
     COLUMN(background_page,     TEXT,           DEFAULT '')
     COLUMN(installed_path,      TEXT,           DEFAULT '')
@@ -215,6 +207,7 @@ CREATE_TABLE(PluginProperties)
     COLUMN_NOT_NULL(PluginPropertiesId,     INTEGER,    primary key autoincrement)
     COLUMN_NOT_NULL(InstallationState,      INTEGER,    DEFAULT 0)
     COLUMN_NOT_NULL(PluginLibraryName,      TEXT,       unique)
+    COLUMN_NOT_NULL(LibraryTimestamp,       INT,)
     COLUMN(PluginLibraryPath,               TEXT,)
 CREATE_TABLE_END()
 
@@ -224,6 +217,7 @@ CREATE_TABLE(PluginDependencies)
 
     TABLE_CONSTRAINTS(
         FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
+        FOREIGN KEY (RequiredPluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
     )
 CREATE_TABLE_END()
 
@@ -296,6 +290,14 @@ CREATE_TABLE(EncryptedResourceList)
     )
 CREATE_TABLE_END()
 
+CREATE_TABLE(LiveBoxInfo)
+    COLUMN_NOT_NULL(app_id,     INT,)
+    COLUMN(livebox_id,          TEXT,           DEFAULT '')
+    TABLE_CONSTRAINTS(
+        FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
+    )
+CREATE_TABLE_END()
+
 SQL(
     COMMIT;
 )