chown -R 5000:5000 /opt/apps/org.tizen.browser/data
fi
-### Bookmark ###
+##### Bookmark ######
if [ ! -f /opt/dbspace/.internet_bookmark.db ];
then
- sqlite3 /opt/dbspace/.internet_bookmark.db 'PRAGMA journal_mode=PERSIST;
- CREATE TABLE bookmarks(id INTEGER PRIMARY KEY AUTOINCREMENT, type INTEGER, parent INTEGER, address, title, creationdate, sequence INTEGER, updatedate, editable INTEGER, accesscount INTEGER, favicon BLOB, favicon_length INTEGER, favicon_w INTEGER, favicon_h INTEGER);
- create index idx_bookmarks_on_parent_type on bookmarks(parent, type);
+ sqlite3 /opt/dbspace/.internet_bookmark.db 'PRAGMA journal_mode=PERSIST;
+ CREATE TABLE bookmarks(id INTEGER PRIMARY KEY AUTOINCREMENT, type INTEGER, parent INTEGER, address, title, creationdate, sequence INTEGER, updatedate, visitdate, editable INTEGER, accesscount INTEGER, favicon BLOB, favicon_length INTEGER, favicon_w INTEGER, favicon_h INTEGER);
+ create index idx_bookmarks_on_parent_type on bookmarks(parent, type);
- insert into bookmarks (type, parent, title, creationdate, editable, sequence, accesscount) values(1, 0, "Bookmarks", DATETIME("now"), 0, 1, 0);'
+ insert into bookmarks (type, parent, title, creationdate, editable, sequence, accesscount) values(1, 0, "Bookmarks", DATETIME("now"), 0, 1, 0);'
fi
##### History ######
CREATE TABLE history(id INTEGER PRIMARY KEY AUTOINCREMENT, address, title, counter INTEGER, visitdate DATETIME, favicon BLOB, favicon_length INTEGER, favicon_w INTEGER, favicon_h INTEGER);'
fi
-##### Notification #####
-if [ ! -f /opt/apps/org.tizen.browser/data/db/.browser-notification.db ];
+##### Geolocation ######
+if [ ! -f /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db ];
then
- sqlite3 /opt/apps/org.tizen.browser/data/db/.browser-notification.db 'PRAGMA journal_mode=PERSIST;
- CREATE TABLE notification_table(id INTEGER PRIMARY KEY AUTOINCREMENT, notification INTEGER, title, body, url, iconURL, iconValidity INTEGER);
- CREATE TABLE notification_permitted_domains(domain PRIMARY KEY);'
+ sqlite3 /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db 'PRAGMA journal_mode=PERSIST;
+ create table geolocation(id integer primary key autoincrement, address, accept INTEGER,updatedate DATETIME);'
fi
##### Password ######
sqlite3 /opt/apps/org.tizen.browser/data/db/.browser.db 'PRAGMA journal_mode=PERSIST;
insert into user_agents 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");
insert into user_agents 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");
+ insert into user_agents values("Galaxy S III", "Mozilla/5.0 (Linux; U; Android 4.0.3; en-gb; GT-I9300 Build/IML74K) AppleWebkit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30");
insert into user_agents 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");
insert into user_agents values("Tizen", "Mozilla/5.0 (Linux; U; Tizen 1.0; en-us) AppleWebKit/534.46 (KHTML, like Gecko) Mobile Tizen Browser/1.0");
insert into user_agents 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");
insert into user_agents 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");
insert into user_agents 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");
- insert into user_agents values("Apple iPhone 3", "Mozilla/5.0 (iPhone; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/420.1 (KHTML, like Gecko) Version/3.0 Mobile/1A542a Safari/419.3");
- insert into user_agents values("Apple iPhone 4", "Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_2_1 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML, like Gecko) Mobile/8C148 Safari/6533.18.5");
- insert into user_agents values("Apple iOS 5", "Mozilla/5.0 (iPhone; CPU iPhone OS 5_0 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.0.2 Mobile/9A5259f Safari/6533.18.5");
+ insert into user_agents 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");
+ insert into user_agents 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");
+ insert into user_agents 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");
insert into user_agents 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");
insert into user_agents values("Opera Mobi", "Opera/9.80 (Windows NT 6.1; U; Edition IBIS; en) Presto/2.6.30 Version/10.63");
insert into user_agents 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");
chown :6002 /opt/dbspace/.internet_bookmark.db-journal
chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-credential.db
chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-credential.db-journal
- chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-notification.db
- chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-notification.db-journal
+ chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db
+ chown :6002 /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db-journal
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser.db
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser.db-journal
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-cookies.db
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-cookies.db-journal
chmod 666 /opt/dbspace/.browser-history.db
chmod 666 /opt/dbspace/.browser-history.db-journal
- chmod 660 /opt/dbspace/.internet_bookmark.db
- chmod 660 /opt/dbspace/.internet_bookmark.db-journal
+ chmod 660 /opt/dbspace/.internet_bookmark.db
+ chmod 660 /opt/dbspace/.internet_bookmark.db-journal
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-credential.db
chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-credential.db-journal
- chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-notification.db
- chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-notification.db-journal
+ chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db
+ chmod 660 /opt/apps/org.tizen.browser/data/db/.browser-geolocation.db-journal
fi
##################################################
##################################################
if [ ${USER} == "root" ]
then
- vconftool set -t bool db/browser/ShowMySitesGuide 1 -g 6514
- vconftool set -t string db/browser/Last/Url "" -g 6514
- vconftool set -t string db/browsersetting/LastVisitedUrl "" -g 6514
- vconftool set -t int db/browser/BrowserBrightnessLevel -1 -g 6514
-# Browser settings vconf values
-# Set vconf values with -g/-u options
- vconftool set -t string db/browsersetting/Homepage "Most visited sites" -g 6514 # "Most visited sites", "user set site", "Empty page"
- vconftool set -t string db/browsersetting/HomepageMode "MOST_VISITED_SITES" -g 6514
- vconftool set -t string db/browsersetting/UserAgent "Tizen" -g 6514
- vconftool set -t string db/browsersetting/UserHomepage "www.tizen.org" -g 6514 # default site is www.tizen.org
- vconftool set -t string db/browsersetting/DefaultViewLevel "Readable" -g 6514 # "Readable", "Fit to width"
- vconftool set -t bool db/browsersetting/EnableLandscape 1 -g 6514
- vconftool set -t bool db/browsersetting/RunJavaScript 1 -g 6514
- vconftool set -t bool db/browsersetting/DisplayImages 1 -g 6514
- vconftool set -t bool db/browsersetting/BlockPopup 1 -g 6514
- vconftool set -t string db/browsersetting/AutoSaveIDPassword "Always ask" -g 6514 # "On", "Off"
- vconftool set -t string db/browsersetting/SaveIDPassword "ALWAYS_ASK" -g 6514 # "On", "Off"
- vconftool set -t string db/browsersetting/CustomUserAgent "" -g 6514
- # set default vconf value for reader
- vconftool set -t bool db/browsersetting/RunReader 1 -g 6514
- vconftool set -t int db/browsersetting/FontSize 16 -g 6514
- # set default vconf value for plugins
- vconftool set -t bool db/browsersetting/RunPlugins 1 -g 6514
- vconftool set -t bool db/browsersetting/RunFlash 0 -g 6514
- vconftool set -t bool db/browsersetting/PauseFlash 1 -g 6514
- # set search vconf
- vconftool set -t string db/browsersetting/SearchEngine "Google" -g 6514 # "Google", "Yahoo", "Bing"
- vconftool set -t string db/browsersetting/SearchUrl "http://www.google.com/m/search?q=" -g 6514
- vconftool set -t bool db/browsersetting/SearchCaseSensitive 0 -g 6514
- # privacy
- vconftool set -t string db/browsersetting/CookieOption "Accept all" -g 6514
- vconftool set -t bool db/browsersetting/CookieOptionInt 1 -g 6514
- # performance
- vconftool set -t bool db/browsersetting/FastRendering 1 -g 6514
- vconftool set -t bool db/browsersetting/LargeRenderingBuffer 1 -g 6514
- vconftool set -t bool db/browsersetting/AcceleratedComposition 1 -g 6514
- vconftool set -t bool db/browsersetting/SamsungAppsInstall 0 -g 6514
- vconftool set -t bool db/browsersetting/ExternalVideoPlayer 0 -g 6514 # if the AcceleratedComposition is 0, this must be 0
- vconftool set -t bool db/browsersetting/CompositedRenderLayerBorders 0 -g 6514 # if the AcceleratedComposition is 0, this must be 0
- vconftool set -t bool db/browsersetting/PhysicsEngine 0 -g 6514
- vconftool set -t bool db/browsersetting/RecordingSurface 0 -g 6514
- vconftool set -t bool db/browsersetting/RemoteWebInspector 0 -g 6514
- vconftool set -t bool db/browsersetting/DemoSetting 0 -g 6514
- vconftool set -t bool db/browsersetting/DemoMode 0 -g 6514
+ vconftool set -t string db/browser/browser_user_agent "System user agent" -g 6514 -f
+ vconftool set -t string db/browser/custom_user_agent "" -g 6514 -f
else
- vconftool set -t bool db/browser/ShowMySitesGuide 1
- vconftool set -t string db/browser/Last/Url ""
- vconftool set -t string db/browsersetting/LastVisitedUrl ""
- vconftool set -t int db/browser/BrowserBrightnessLevel -1
-# Browser settings vconf values
-# Set without -g, -u options
- vconftool set -t string db/browsersetting/Homepage "Recently visited site" # "Recently visited site", "user set site", "Empty page"
- vconftool set -t string db/browsersetting/HomepageMode "MOST_VISITED_SITES"
- vconftool set -t string db/browsersetting/UserHomepage "www.tizen.org" # default site is www.tizen.org
- vconftool set -t string db/browsersetting/UserAgent "Tizen"
- vconftool set -t string db/browsersetting/DefaultViewLevel "Readable" # "Readable", "Fit to width"
- vconftool set -t bool db/browsersetting/EnableLandscape 1
- vconftool set -t bool db/browsersetting/RunJavaScript 1
- vconftool set -t bool db/browsersetting/DisplayImages 1
- vconftool set -t bool db/browsersetting/BlockPopup 1
- vconftool set -t string db/browsersetting/AutoSaveIDPassword "Always ask" # "On", "Off"
- vconftool set -t string db/browsersetting/SaveIDPassword "ALWAYS_ASK"
- vconftool set -t string db/browsersetting/CustomUserAgent ""
- # set default vconf value for reader
- vconftool set -t bool db/browsersetting/RunReader 1
- vconftool set -t int db/browsersetting/FontSize 16
- # set default vconf value for plugins
- vconftool set -t bool db/browsersetting/RunPlugins 1
- vconftool set -t bool db/browsersetting/RunFlash 0
- # set search vconf
- vconftool set -t string db/browsersetting/SearchEngine "Google" # "Google", "Yahoo", "Bing"
- vconftool set -t string db/browsersetting/SearchUrl "http://www.google.com/m/search?q="
- vconftool set -t bool db/browsersetting/SearchCaseSensitive 0
- # privacy
- vconftool set -t string db/browsersetting/CookieOption "Accept all"
- vconftool set -t bool db/browsersetting/CookieOptionInt 1
- # performance
- vconftool set -t bool db/browsersetting/FastRendering 1
- vconftool set -t bool db/browsersetting/LargeRenderingBuffer 1
- vconftool set -t bool db/browsersetting/AcceleratedComposition 1
- vconftool set -t bool db/browsersetting/SamsungAppsInstall 0
- vconftool set -t bool db/browsersetting/ExternalVideoPlayer 0 # if the AcceleratedComposition is 0, this must be 0
- vconftool set -t bool db/browsersetting/CompositedRenderLayerBorders 0 # if the AcceleratedComposition is 0, this must be 0
- vconftool set -t bool db/browsersetting/PhysicsEngine 0
- vconftool set -t bool db/browsersetting/RecordingSurface 0
- vconftool set -t bool db/browsersetting/RemoteWebInspector 0
- vconftool set -t bool db/browsersetting/DemoMode 0
- vconftool set -t bool db/browsersetting/DemoSetting 0
+ vconftool set -t string db/browser/browser_user_agent "System user agent" -f
+ vconftool set -t string db/browser/custom_user_agent "" -f
fi