2 PRAGMA foreign_keys = ON;
6 CREATE_TABLE(WidgetInfo)
7 COLUMN_NOT_NULL(app_id, INTEGER, PRIMARY KEY AUTOINCREMENT)
8 COLUMN(widget_type, INT, DEFAULT 1)
9 COLUMN(widget_id, TEXT, DEFAULT '')
10 COLUMN(widget_version, TEXT, DEFAULT '')
11 COLUMN(widget_width, INT, DEFAULT 0)
12 COLUMN(widget_height, INT, DEFAULT 0)
13 COLUMN(author_name, TEXT, DEFAULT '')
14 COLUMN(author_email, TEXT, DEFAULT '')
15 COLUMN(author_href, TEXT, DEFAULT '')
16 COLUMN(base_folder, TEXT, DEFAULT '')
17 COLUMN(webkit_plugins_required, TINYINT, DEFAULT 0)
18 COLUMN(security_domain, INT, DEFAULT 0)
19 COLUMN(csp_policy, TEXT, DEFAULT '')
20 COLUMN(csp_policy_report_only, TEXT, DEFAULT '')
21 COLUMN(recognized, INT, DEFAULT 0)
22 COLUMN(wac_signed, INT, DEFAULT 0)
23 COLUMN(distributor_signed, INT, DEFAULT 0)
24 COLUMN(min_version, TEXT, DEFAULT '1.0')
25 COLUMN_NOT_NULL(back_supported, TINYINT, DEFAULT 0)
26 COLUMN(access_network, TINYINT, DEFAULT 0)
27 COLUMN(defaultlocale, TEXT, DEFAULT 0)
28 COLUMN_NOT_NULL(tizen_pkgid, TEXT, DEFAULT '')
29 COLUMN_NOT_NULL(tizen_appid, TEXT, DEFAULT 0 UNIQUE)
30 COLUMN(pkg_type, INT, DEFAULT 0)
31 COLUMN(security_model_version, INT, DEFAULT 0)
35 CREATE INDEX IF NOT EXISTS WidgetInfo_AppidIndex ON WidgetInfo(tizen_appid);
38 CREATE_TABLE(WidgetCertificate)
39 COLUMN_NOT_NULL(app_id, INT,)
40 COLUMN_NOT_NULL(cert_source, INT, CHECK(cert_source between 0 and 1))
41 COLUMN_NOT_NULL(encoded_chain, VARCHAR(16000),)
43 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
47 CREATE_TABLE(WidgetWindowModes)
48 COLUMN_NOT_NULL(app_id, INT,)
49 COLUMN_NOT_NULL(window_mode, VARCHAR(256),)
51 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
55 CREATE_TABLE(LocalizedWidgetInfo)
56 COLUMN_NOT_NULL(app_id, INT,)
57 COLUMN_NOT_NULL(widget_locale, TEXT,)
58 COLUMN(widget_name, TEXT,)
59 COLUMN(widget_shortname, TEXT,)
60 COLUMN(widget_description, TEXT,)
61 COLUMN(widget_license, TEXT,)
62 COLUMN(widget_license_file, TEXT,)
63 COLUMN(widget_license_href, TEXT,)
66 PRIMARY KEY (app_id, widget_locale),
67 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
71 CREATE_TABLE(WidgetExtendedInfo)
72 COLUMN_NOT_NULL(app_id, INTEGER, PRIMARY KEY)
73 COLUMN(last_update_time, BIGINT, DEFAULT 0)
74 COLUMN(install_time, BIGINT, DEFAULT 0)
75 COLUMN(option_state, INT, DEFAULT 0)
76 COLUMN(share_href, TEXT, DEFAULT '')
77 COLUMN(signature_type, INT, DEFAULT 0)
78 COLUMN(updated, INT, DEFAULT 0)
79 COLUMN(update_policy, INT, DEFAULT 0)
80 COLUMN_NOT_NULL(test_widget, INT, CHECK(test_widget between 0 and 1) DEFAULT 0)
81 COLUMN(splash_img_src, TEXT, DEFAULT '')
82 COLUMN(background_page, TEXT, DEFAULT '')
83 COLUMN(installed_path, TEXT, DEFAULT '')
85 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
89 CREATE_TABLE(WidgetPreference)
90 COLUMN_NOT_NULL(app_id, INTEGER,)
91 COLUMN_NOT_NULL(tizen_appid, TEXT, DEFAULT 0)
92 COLUMN_NOT_NULL(key_name, TEXT,)
93 COLUMN(key_value, TEXT, DEFAULT '')
94 COLUMN(readonly, INT, DEFAULT 0)
97 PRIMARY KEY(app_id, key_name),
98 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
102 CREATE_TABLE(WidgetFeature)
103 COLUMN_NOT_NULL(widget_feature_id, INTEGER, primary key autoincrement)
104 COLUMN_NOT_NULL(app_id, INT,)
105 COLUMN_NOT_NULL(name, TEXT,)
106 COLUMN_NOT_NULL(rejected, INT,)
108 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
112 CREATE_TABLE(WidgetPrivilege)
113 COLUMN_NOT_NULL(widget_privilege_id, INTEGER, primary key autoincrement)
114 COLUMN_NOT_NULL(app_id, INT,)
115 COLUMN_NOT_NULL(name, TEXT,)
117 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
121 CREATE_TABLE(WidgetIcon)
122 COLUMN_NOT_NULL(icon_id, INTEGER, primary key autoincrement)
123 COLUMN_NOT_NULL(app_id, INT,)
124 COLUMN_NOT_NULL(icon_src, TEXT,)
125 COLUMN(icon_width, INT, DEFAULT 0)
126 COLUMN(icon_height, INT, DEFAULT 0)
128 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
132 CREATE_TABLE(WidgetLocalizedIcon)
133 COLUMN_NOT_NULL(app_id, INT,) /* TODO key duplicated for efficiency - ORM doesn't support JOIN */
134 COLUMN_NOT_NULL(icon_id, INTEGER,)
135 COLUMN_NOT_NULL(widget_locale, TEXT,)
137 FOREIGN KEY(icon_id) REFERENCES WidgetIcon (icon_id) ON DELETE CASCADE,
138 PRIMARY KEY(icon_id, widget_locale)
142 CREATE_TABLE(WidgetStartFile)
143 COLUMN_NOT_NULL(start_file_id, INTEGER, primary key autoincrement)
144 COLUMN_NOT_NULL(app_id, INT,)
145 COLUMN_NOT_NULL(src, TEXT,)
147 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
151 CREATE_TABLE(WidgetLocalizedStartFile)
152 COLUMN_NOT_NULL(app_id, INT,) /* TODO key duplicated for efficiency - ORM doesn't support JOIN */
153 COLUMN_NOT_NULL(start_file_id, INTEGER,)
154 COLUMN_NOT_NULL(widget_locale, TEXT,)
155 COLUMN_NOT_NULL(type, TEXT,)
156 COLUMN_NOT_NULL(encoding, TEXT,)
158 FOREIGN KEY(start_file_id) REFERENCES WidgetStartFile (start_file_id) ON DELETE CASCADE,
159 PRIMARY KEY(start_file_id, widget_locale)
163 CREATE_TABLE(WidgetExternalLocations)
164 COLUMN_NOT_NULL(app_id, INT,)
165 COLUMN_NOT_NULL(path, TEXT,)
167 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE,
168 PRIMARY KEY(app_id, path)
172 CREATE_TABLE(WidgetAccessHost)
173 COLUMN_NOT_NULL(app_id, INT,)
174 COLUMN_NOT_NULL(host, TEXT,)
177 PRIMARY KEY(app_id, host)
178 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE)
181 CREATE_TABLE(WidgetCertificateFingerprint)
182 COLUMN_NOT_NULL(app_id, INT,)
183 COLUMN_NOT_NULL(owner, INT,)
184 COLUMN_NOT_NULL(chainid, INT,)
185 COLUMN_NOT_NULL(type, INT,)
186 COLUMN(md5_fingerprint, TEXT,)
187 COLUMN(sha1_fingerprint, TEXT,)
188 COLUMN(common_name, VARCHAR(64),)
191 PRIMARY KEY(app_id, chainid, owner, type)
192 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
196 CREATE_TABLE(WidgetWARPInfo)
197 COLUMN_NOT_NULL(app_id, INT,)
198 COLUMN_NOT_NULL(iri, TEXT,)
199 COLUMN(subdomain_access, INT, CHECK(subdomain_access between 0 and 1))
202 PRIMARY KEY(app_id, iri)
203 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
207 CREATE_TABLE(WidgetAllowNavigation)
208 COLUMN_NOT_NULL(app_id, INT,)
209 COLUMN_NOT_NULL(scheme, TEXT,)
210 COLUMN_NOT_NULL(host, TEXT,)
213 PRIMARY KEY(app_id, scheme, host)
214 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
218 CREATE_TABLE(WidgetSecuritySettings)
219 COLUMN_NOT_NULL(app_id, INT,)
220 COLUMN_NOT_NULL(security_popup_usage, INT, DEFAULT 1)
221 COLUMN_NOT_NULL(geolocation_usage, INT, DEFAULT 1)
222 COLUMN_NOT_NULL(web_notification_usage, INT, DEFAULT 1)
223 COLUMN_NOT_NULL(web_database_usage, INT, DEFAULT 1)
225 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
229 CREATE_TABLE(FeaturesList)
230 COLUMN_NOT_NULL(FeatureUUID, INTEGER, primary key autoincrement)
231 COLUMN_NOT_NULL(FeatureName, TEXT, unique)
232 COLUMN_NOT_NULL(PluginPropertiesId, INT,)
235 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
239 CREATE_TABLE(PluginProperties)
240 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, primary key autoincrement)
241 COLUMN_NOT_NULL(InstallationState, INTEGER, DEFAULT 0)
242 COLUMN_NOT_NULL(PluginLibraryName, TEXT, unique)
243 COLUMN(PluginLibraryPath, TEXT,)
246 CREATE_TABLE(PluginDependencies)
247 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
248 COLUMN_NOT_NULL(RequiredPluginPropertiesId, INTEGER, not null)
251 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
255 CREATE_TABLE(PluginImplementedObjects)
256 COLUMN_NOT_NULL(PluginObject, TEXT, unique)
257 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
260 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
264 CREATE_TABLE(PluginRequiredObjects)
265 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
266 COLUMN_NOT_NULL(PluginObject, TEXT, not null)
269 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
273 CREATE_TABLE(DeviceCapabilities)
274 COLUMN_NOT_NULL(DeviceCapID, INTEGER, primary key autoincrement)
275 COLUMN_NOT_NULL(DeviceCapName, TEXT, unique)
276 COLUMN(DeviceCapDefaultValue, INT,)
279 CREATE_TABLE(FeatureDeviceCapProxy)
280 COLUMN_NOT_NULL(FeatureUUID, INT, not null)
281 COLUMN_NOT_NULL(DeviceCapID, INT, not null)
284 FOREIGN KEY (FeatureUUID) REFERENCES FeaturesList (FeatureUUID) ON DELETE CASCADE
285 FOREIGN KEY (DeviceCapID) REFERENCES DeviceCapabilities (DeviceCapID) ON DELETE CASCADE
286 PRIMARY KEY(FeatureUUID,DeviceCapID)
290 CREATE_TABLE(OCSPResponseStorage)
291 COLUMN_NOT_NULL(cert_chain, TEXT, primary key)
292 COLUMN(end_entity_check, INT,)
293 COLUMN(ocsp_status, INT,)
294 COLUMN(next_update_time, BIGINT,)
297 CREATE_TABLE(CRLResponseStorage)
298 COLUMN_NOT_NULL(distribution_point,TEXT, primary key)
299 COLUMN_NOT_NULL(crl_body, TEXT,)
300 COLUMN(next_update_time, BIGINT,)
303 CREATE_TABLE(SettingsList)
304 COLUMN_NOT_NULL(appId, INT,)
305 COLUMN_NOT_NULL(settingName, TEXT,)
306 COLUMN_NOT_NULL(settingValue, TEXT,)
308 FOREIGN KEY (appId) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
312 CREATE_TABLE(AppControlInfo)
313 COLUMN_NOT_NULL(app_id, INT,)
314 COLUMN_NOT_NULL(execute_index, INT,)
315 COLUMN_NOT_NULL(src, TEXT,)
316 COLUMN_NOT_NULL(operation, TEXT,)
317 COLUMN_NOT_NULL(uri, TEXT,)
318 COLUMN_NOT_NULL(mime, TEXT,)
319 COLUMN_NOT_NULL(disposition, TINYINT, DEFAULT 0)
322 PRIMARY KEY(app_id, operation, uri, mime)
323 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
327 CREATE_TABLE(EncryptedResourceList)
328 COLUMN_NOT_NULL(app_id, INT,)
329 COLUMN_NOT_NULL(resource, TEXT,)
330 COLUMN_NOT_NULL(size, INT,)
333 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE