2 PRAGMA foreign_keys = ON;
5 /*TODO: secure_by_default should be 0 by default*/
6 CREATE_TABLE(GlobalProperties)
7 COLUMN_NOT_NULL(secure_by_default, INT, DEFAULT 1)
8 COLUMN_NOT_NULL(home_network_data_usage, TINYINT, DEFAULT 1)
9 COLUMN_NOT_NULL(roaming_data_usage, TINYINT, DEFAULT 1)
10 COLUMN_NOT_NULL(compliance_mode, TINYINT, DEFAULT 0)
11 COLUMN_NOT_NULL(compliance_fake_imei, VARCHAR(256), DEFAULT '')
12 COLUMN_NOT_NULL(compliance_fake_meid, VARCHAR(256), DEFAULT '')
13 COLUMN_NOT_NULL(cookie_sharing_mode, INT, DEFAULT 0)
17 INSERT INTO GlobalProperties DEFAULT VALUES;
20 CREATE_TABLE(WidgetInfo)
21 COLUMN_NOT_NULL(app_id, INTEGER, PRIMARY KEY AUTOINCREMENT)
22 COLUMN(widget_type, INT, DEFAULT 1)
23 COLUMN(widget_id, TEXT, DEFAULT '')
24 COLUMN(widget_version, TEXT, DEFAULT '')
25 COLUMN(widget_width, INT, DEFAULT 0)
26 COLUMN(widget_height, INT, DEFAULT 0)
27 COLUMN(author_name, TEXT, DEFAULT '')
28 COLUMN(author_email, TEXT, DEFAULT '')
29 COLUMN(author_href, TEXT, DEFAULT '')
30 COLUMN(base_folder, TEXT, DEFAULT '')
31 COLUMN(webkit_plugins_required, TINYINT, DEFAULT 0)
32 COLUMN(security_domain, INT, DEFAULT 0)
33 COLUMN(csp_policy, TEXT, DEFAULT '')
34 COLUMN(csp_policy_report_only, TEXT, DEFAULT '')
35 COLUMN(recognized, INT, DEFAULT 0)
36 COLUMN(wac_signed, INT, DEFAULT 0)
37 COLUMN(distributor_signed, INT, DEFAULT 0)
38 COLUMN(min_version, TEXT, DEFAULT '1.0')
39 COLUMN_NOT_NULL(back_supported, TINYINT, DEFAULT 0)
40 COLUMN(access_network, TINYINT, DEFAULT 0)
41 COLUMN(defaultlocale, TEXT, DEFAULT 0)
42 COLUMN_NOT_NULL(tizen_pkgid, TEXT, DEFAULT '')
43 COLUMN_NOT_NULL(tizen_appid, TEXT, DEFAULT 0 UNIQUE)
44 COLUMN(pkg_type, INT, DEFAULT 0)
45 COLUMN(security_model_version, INT, DEFAULT 0)
49 CREATE INDEX IF NOT EXISTS WidgetInfo_AppidIndex ON WidgetInfo(tizen_appid);
52 CREATE_TABLE(WidgetCertificate)
53 COLUMN_NOT_NULL(app_id, INT,)
54 COLUMN_NOT_NULL(cert_source, INT, CHECK(cert_source between 0 and 1))
55 COLUMN_NOT_NULL(encoded_chain, VARCHAR(16000),)
57 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
61 CREATE_TABLE(WidgetWindowModes)
62 COLUMN_NOT_NULL(app_id, INT,)
63 COLUMN_NOT_NULL(window_mode, VARCHAR(256),)
65 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
69 CREATE_TABLE(LocalizedWidgetInfo)
70 COLUMN_NOT_NULL(app_id, INT,)
71 COLUMN_NOT_NULL(widget_locale, TEXT,)
72 COLUMN(widget_name, TEXT,)
73 COLUMN(widget_shortname, TEXT,)
74 COLUMN(widget_description, TEXT,)
75 COLUMN(widget_license, TEXT,)
76 COLUMN(widget_license_file, TEXT,)
77 COLUMN(widget_license_href, TEXT,)
80 PRIMARY KEY (app_id, widget_locale),
81 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
85 CREATE_TABLE(WidgetExtendedInfo)
86 COLUMN_NOT_NULL(app_id, INTEGER, PRIMARY KEY)
87 COLUMN(last_update_time, BIGINT, DEFAULT 0)
88 COLUMN(install_time, BIGINT, DEFAULT 0)
89 COLUMN(option_state, INT, DEFAULT 0)
90 COLUMN(share_href, TEXT, DEFAULT '')
91 COLUMN(signature_type, INT, DEFAULT 0)
92 COLUMN(updated, INT, DEFAULT 0)
93 COLUMN(update_policy, INT, DEFAULT 0)
94 COLUMN_NOT_NULL(test_widget, INT, CHECK(test_widget between 0 and 1) DEFAULT 0)
95 COLUMN(splash_img_src, TEXT, DEFAULT '')
96 COLUMN(background_page, TEXT, DEFAULT '')
97 COLUMN(installed_path, TEXT, DEFAULT '')
99 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
103 CREATE_TABLE(WidgetPreference)
104 COLUMN_NOT_NULL(app_id, INTEGER,)
105 COLUMN_NOT_NULL(tizen_appid, TEXT, DEFAULT 0)
106 COLUMN_NOT_NULL(key_name, TEXT,)
107 COLUMN(key_value, TEXT, DEFAULT '')
108 COLUMN(readonly, INT, DEFAULT 0)
111 PRIMARY KEY(app_id, key_name),
112 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
116 CREATE_TABLE(WidgetFeature)
117 COLUMN_NOT_NULL(widget_feature_id, INTEGER, primary key autoincrement)
118 COLUMN_NOT_NULL(app_id, INT,)
119 COLUMN_NOT_NULL(name, TEXT,)
120 COLUMN_NOT_NULL(rejected, INT,)
122 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
126 CREATE_TABLE(WidgetPrivilege)
127 COLUMN_NOT_NULL(widget_privilege_id, INTEGER, primary key autoincrement)
128 COLUMN_NOT_NULL(app_id, INT,)
129 COLUMN_NOT_NULL(name, TEXT,)
131 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
135 CREATE_TABLE(WidgetIcon)
136 COLUMN_NOT_NULL(icon_id, INTEGER, primary key autoincrement)
137 COLUMN_NOT_NULL(app_id, INT,)
138 COLUMN_NOT_NULL(icon_src, TEXT,)
139 COLUMN(icon_width, INT, DEFAULT 0)
140 COLUMN(icon_height, INT, DEFAULT 0)
142 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
146 CREATE_TABLE(WidgetLocalizedIcon)
147 COLUMN_NOT_NULL(app_id, INT,) /* TODO key duplicated for efficiency - ORM doesn't support JOIN */
148 COLUMN_NOT_NULL(icon_id, INTEGER,)
149 COLUMN_NOT_NULL(widget_locale, TEXT,)
151 FOREIGN KEY(icon_id) REFERENCES WidgetIcon (icon_id) ON DELETE CASCADE,
152 PRIMARY KEY(icon_id, widget_locale)
156 CREATE_TABLE(WidgetStartFile)
157 COLUMN_NOT_NULL(start_file_id, INTEGER, primary key autoincrement)
158 COLUMN_NOT_NULL(app_id, INT,)
159 COLUMN_NOT_NULL(src, TEXT,)
161 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
165 CREATE_TABLE(WidgetLocalizedStartFile)
166 COLUMN_NOT_NULL(app_id, INT,) /* TODO key duplicated for efficiency - ORM doesn't support JOIN */
167 COLUMN_NOT_NULL(start_file_id, INTEGER,)
168 COLUMN_NOT_NULL(widget_locale, TEXT,)
169 COLUMN_NOT_NULL(type, TEXT,)
170 COLUMN_NOT_NULL(encoding, TEXT,)
172 FOREIGN KEY(start_file_id) REFERENCES WidgetStartFile (start_file_id) ON DELETE CASCADE,
173 PRIMARY KEY(start_file_id, widget_locale)
177 CREATE_TABLE(WidgetExternalLocations)
178 COLUMN_NOT_NULL(app_id, INT,)
179 COLUMN_NOT_NULL(path, TEXT,)
181 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE,
182 PRIMARY KEY(app_id, path)
186 CREATE_TABLE(WidgetAccessHost)
187 COLUMN_NOT_NULL(app_id, INT,)
188 COLUMN_NOT_NULL(host, TEXT,)
191 PRIMARY KEY(app_id, host)
192 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE)
195 CREATE_TABLE(WidgetCertificateFingerprint)
196 COLUMN_NOT_NULL(app_id, INT,)
197 COLUMN_NOT_NULL(owner, INT,)
198 COLUMN_NOT_NULL(chainid, INT,)
199 COLUMN_NOT_NULL(type, INT,)
200 COLUMN(md5_fingerprint, TEXT,)
201 COLUMN(sha1_fingerprint, TEXT,)
202 COLUMN(common_name, VARCHAR(64),)
205 PRIMARY KEY(app_id, chainid, owner, type)
206 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
210 CREATE_TABLE(WidgetWARPInfo)
211 COLUMN_NOT_NULL(app_id, INT,)
212 COLUMN_NOT_NULL(iri, TEXT,)
213 COLUMN(subdomain_access, INT, CHECK(subdomain_access between 0 and 1))
216 PRIMARY KEY(app_id, iri)
217 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
221 CREATE_TABLE(WidgetAllowNavigation)
222 COLUMN_NOT_NULL(app_id, INT,)
223 COLUMN_NOT_NULL(scheme, TEXT,)
224 COLUMN_NOT_NULL(host, TEXT,)
227 PRIMARY KEY(app_id, scheme, host)
228 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
232 CREATE_TABLE(WidgetSecuritySettings)
233 COLUMN_NOT_NULL(app_id, INT,)
234 COLUMN_NOT_NULL(security_popup_usage, INT, DEFAULT 1)
235 COLUMN_NOT_NULL(geolocation_usage, INT, DEFAULT 1)
236 COLUMN_NOT_NULL(web_notification_usage, INT, DEFAULT 1)
237 COLUMN_NOT_NULL(web_database_usage, INT, DEFAULT 1)
239 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
243 CREATE_TABLE(FeaturesList)
244 COLUMN_NOT_NULL(FeatureUUID, INTEGER, primary key autoincrement)
245 COLUMN_NOT_NULL(FeatureName, TEXT, unique)
246 COLUMN_NOT_NULL(PluginPropertiesId, INT,)
249 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
253 CREATE_TABLE(PluginProperties)
254 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, primary key autoincrement)
255 COLUMN_NOT_NULL(InstallationState, INTEGER, DEFAULT 0)
256 COLUMN_NOT_NULL(PluginLibraryName, TEXT, unique)
257 COLUMN(PluginLibraryPath, TEXT,)
260 CREATE_TABLE(PluginDependencies)
261 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
262 COLUMN_NOT_NULL(RequiredPluginPropertiesId, INTEGER, not null)
265 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
269 CREATE_TABLE(PluginImplementedObjects)
270 COLUMN_NOT_NULL(PluginObject, TEXT, unique)
271 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
274 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
278 CREATE_TABLE(PluginRequiredObjects)
279 COLUMN_NOT_NULL(PluginPropertiesId, INTEGER, not null)
280 COLUMN_NOT_NULL(PluginObject, TEXT, not null)
283 FOREIGN KEY (PluginPropertiesId) REFERENCES PluginProperties (PluginPropertiesId) ON DELETE CASCADE
287 CREATE_TABLE(DeviceCapabilities)
288 COLUMN_NOT_NULL(DeviceCapID, INTEGER, primary key autoincrement)
289 COLUMN_NOT_NULL(DeviceCapName, TEXT, unique)
290 COLUMN(DeviceCapDefaultValue, INT,)
293 CREATE_TABLE(FeatureDeviceCapProxy)
294 COLUMN_NOT_NULL(FeatureUUID, INT, not null)
295 COLUMN_NOT_NULL(DeviceCapID, INT, not null)
298 FOREIGN KEY (FeatureUUID) REFERENCES FeaturesList (FeatureUUID) ON DELETE CASCADE
299 FOREIGN KEY (DeviceCapID) REFERENCES DeviceCapabilities (DeviceCapID) ON DELETE CASCADE
300 PRIMARY KEY(FeatureUUID,DeviceCapID)
304 CREATE_TABLE(OCSPResponseStorage)
305 COLUMN_NOT_NULL(cert_chain, TEXT, primary key)
306 COLUMN(end_entity_check, INT,)
307 COLUMN(ocsp_status, INT,)
308 COLUMN(next_update_time, BIGINT,)
311 CREATE_TABLE(CRLResponseStorage)
312 COLUMN_NOT_NULL(distribution_point,TEXT, primary key)
313 COLUMN_NOT_NULL(crl_body, TEXT,)
314 COLUMN(next_update_time, BIGINT,)
317 CREATE_TABLE(SettingsList)
318 COLUMN_NOT_NULL(appId, INT,)
319 COLUMN_NOT_NULL(settingName, TEXT,)
320 COLUMN_NOT_NULL(settingValue, TEXT,)
322 FOREIGN KEY (appId) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
326 CREATE_TABLE(AppControlInfo)
327 COLUMN_NOT_NULL(app_id, INT,)
328 COLUMN_NOT_NULL(execute_index, INT,)
329 COLUMN_NOT_NULL(src, TEXT,)
330 COLUMN_NOT_NULL(operation, TEXT,)
331 COLUMN_NOT_NULL(uri, TEXT,)
332 COLUMN_NOT_NULL(mime, TEXT,)
333 COLUMN_NOT_NULL(disposition, TINYINT, DEFAULT 0)
336 PRIMARY KEY(app_id, operation, uri, mime)
337 FOREIGN KEY(app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
341 CREATE_TABLE(WidgetWhiteURIList)
342 COLUMN_NOT_NULL(uri, VARCHAR(65536), primary key)
343 COLUMN_NOT_NULL(subdomain_access, INT, CHECK(subdomain_access between 0 and 1))
346 CREATE_TABLE(EncryptedResourceList)
347 COLUMN_NOT_NULL(app_id, INT,)
348 COLUMN_NOT_NULL(resource, TEXT,)
349 COLUMN_NOT_NULL(size, INT,)
352 FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
357 INSERT INTO WidgetWhiteURIList VALUES("http://samsung.com", 1);
358 INSERT INTO WidgetWhiteURIList VALUES("http://orange.fr", 1);
359 INSERT INTO WidgetWhiteURIList VALUES("http://orange.co.uk", 1);
362 /*TODO: It will be removed when user agent is fixed. User agent MUST be configurable in development...*/
363 CREATE_TABLE(UserAgents)
364 COLUMN_NOT_NULL(key_name, TEXT,)
365 COLUMN(key_value, TEXT, DEFAULT '')
367 TABLE_CONSTRAINTS(PRIMARY KEY(key_name))
371 INSERT INTO UserAgents VALUES("Galaxy S", "Mozilla/5.0 (Linux; U; Android 2.3.7; en-gb; GT-I9000 Build/GRJ22) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1");
372 INSERT INTO UserAgents VALUES("Galaxy S II", "Mozilla/5.0 (Linux; U; Android 2.3.5; en-gb; GT-I9100 Build/GINGERBREAD) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1");
373 INSERT INTO UserAgents VALUES("Galaxy S III", "Mozilla/5.0 (Linux; U; Android 4.0.4; en-gb; GT-I9300 Build/IMM76D) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30");
374 INSERT INTO UserAgents VALUES("SLP Galaxy", "Mozilla/5.0 (Linux; U; Android 2.3.4; en-us; GT-I9500 Build/GINGERBREAD) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1");
375 INSERT INTO UserAgents VALUES("Tizen", "Mozilla/5.0 (Linux; U; Tizen 2.1; en-us; SAMSUNG GT-I8800) AppleWebKit/537.1 (KHTML, like Gecko) Version/2.1.0 Mobile");
376 INSERT INTO UserAgents VALUES("Galaxy Nexus", "Mozilla/5.0 (Linux; U; Android 4.0.3; en-us; Galaxy Nexus Build/IML74K) AppleWebKit/535.7 (KHTML, like Gecko) Mobile Safari/535.7");
377 INSERT INTO UserAgents VALUES("Samsung", "Mozilla/5.0 (SAMSUNG; SAMSUNG-GT-I9200/1.0; U; Linux/SLP/2.0; ko-kr) AppleWebKit/534.4 (KHTML, like Gecko) Dolfin/2.0 Mobile");
378 INSERT INTO UserAgents VALUES("Samsung Dolfin", "SAMSUNG-GT-S8500/S8500XXJD2 SHP/VPP/R5 Dolfin/2.0 Nextreaming SMM-MMS/1.2.0 profile/MIDP-2.1 configuration/CLDC-1.1");
379 INSERT INTO UserAgents VALUES("Apple iPhone 3", "Mozilla/5.0 (iPhone; U; CPU iPhone OS 3_1_3 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Version/4.0 Mobile/7E18 Safari/528.16");
380 INSERT INTO UserAgents VALUES("Apple iPhone 4", "Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_3_5 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8L1 Safari/6533.18.5");
381 INSERT INTO UserAgents VALUES("Apple iOS 5", "Mozilla/5.0 (iPhone; CPU iPhone OS 5_0_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9A405 Safari/7534.48.3");
382 INSERT INTO UserAgents VALUES("Android 2.3 (Nexus One)", "Mozilla/5.0 (Linux; U; Android 2.3.4; en-us; Nexus One Build/GRJ22) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1");
383 INSERT INTO UserAgents VALUES("Opera Mobi", "Opera/9.80 (Windows NT 6.1; U; Edition IBIS; en) Presto/2.6.30 Version/10.63");
384 INSERT INTO UserAgents VALUES("Samsung Bada", "Mozilla/5.0 (SAMSUNG; SAMSUNG-GT-S8500/1.0; U; Bada/1.0; en-us) AppleWebKit/533.1 (KHTML, like Gecko) Dolfin/2.0 Mobile WVGA SMM-MMS/1.2.0 OPN-B");
385 INSERT INTO UserAgents VALUES("Orange TV 3.2 iPhone", "Mozilla/5.0 (OrangeTVPlayer4iPhone/iPhone2,1; U; CPU iPhone OS 4_3 like Mac OS X; fr) AppleWebKit/525.18.1 (KHTML, like Gecko) Version/3.1.1 Mobile/5F136 Safari/525.20 OrangeAppliTVHTTPLS/3.2.16");
386 INSERT INTO UserAgents VALUES("Orange TV 3.2 iPad", "Mozilla/5.0 (OrangeTVPlayer4iPhone/iPad1,1; U; CPU iPhone OS 4_3 like Mac OS X; fr) AppleWebKit/525.18.1 (KHTML, like Gecko) Version/3.1.1 Mobile/5F136 Safari/525.20 iPad=SIMENABLED OrangeAppliTVHTTPLS/3.2.16");
387 INSERT INTO UserAgents VALUES("Orange TV 3.3 iOS", "OrangeTVPlayer4iPhone/_iOS_3.3.3_Apple_iPhone2,1_4.1_OrangeAppliTVHTTPLS/3.3.3");
388 INSERT INTO UserAgents VALUES("Chrome Browser for android", "Mozilla/5.0 (Linux; U; Android 4.0.1; ko-kr; Galaxy Nexus Build/ITL41F) AppleWebKit/535.7 (KHTML, like Gecko) CrMo/16.0.912.75 Mobile Safari/535.7");
389 INSERT INTO UserAgents VALUES("MANGO(Nokia 800C)", "Mozilla/5.0 (compatible; MSIE 9.0; Windows Phone OS 7.5; Trident/5.0; IEMobile/9.0; Nokia; 800C)");
390 INSERT INTO UserAgents VALUES("Orange TV 3.2 Tizen", "Mozilla/5.0 (Linux; U; Tizen 1.0; fr-fr; GT-I8800) AppleWebKit/534.46 (KHTML, like Gecko) Mobile Tizen Browser/1.0 OrangeAppliTV/3.2.0");
391 INSERT INTO UserAgents VALUES("System user agent", "");
392 INSERT INTO UserAgents VALUES("Samsung Bada 2.0", "Mozilla/5.0 (SAMSUNG; SAMSUNG-GT-S8500/1.0; U; Bada/2.0; en-us) AppleWebKit/534.20 (KHTML, like Gecko) Mobile WVGA SMM-MMS/1.2.0 OPN-B Dolfin/3.0");
393 INSERT INTO UserAgents VALUES("Samsung Desktop", "Mozilla/5.0 (U; Linux/SLP/2.0; ko-kr) AppleWebKit/533.1 (KHTML, like Gecko)");
394 INSERT INTO UserAgents VALUES("Firefox 5", "Mozilla/5.0 (Windows NT 6.1; rv:9.0.1) Gecko/20100101 Firefox/9.0.1");
395 INSERT INTO UserAgents VALUES("Firefox 5 Fennec(Mobile)", "Mozilla/5.0 (Android; Linux armv7l; rv:5.0) Gecko/20110615 Firefox/5.0 Fennec/5.0");
396 INSERT INTO UserAgents VALUES("Safari 5.0", "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/534.52.7 (KHTML, like Gecko) Version/5.1.2 Safari/534.52.7");
397 INSERT INTO UserAgents VALUES("Google Chrome 18.0", "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.16 (KHTML, like Gecko) Chrome/18.0.1003.1 Safari/535.16");
398 INSERT INTO UserAgents VALUES("Internet Explorer 9", "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)");
399 INSERT INTO UserAgents VALUES("Galaxy Tab 10.1", "Mozilla/5.0 (Linux; U; Android 3.0.1; en-us; GT-P7100 Build/HRI83) AppleWebKit/534.13 (KHTML, like Gecko) Version/4.0 Safari/534.13");
400 INSERT INTO UserAgents VALUES("iPad 2", "Mozilla/5.0 (iPad; U; CPU OS 4_3_5 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Version/5.0.2 Mobile/8L1 Safari/6533.18.5");