#!/bin/sh

# A path to the WebKit's data bases and appcache dir
if [ ! -d /opt/dbspace/.webkit ];
then
    mkdir /opt/dbspace/.webkit
fi

if [ ! -f /opt/dbspace/.webkit/WebpageIcons.db ]
then
    sqlite3 /opt/dbspace/.webkit/WebpageIcons.db '
    CREATE TABLE PageURL (url TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE,iconID INTEGER NOT NULL ON CONFLICT FAIL);
    CREATE INDEX PageURLIndex ON PageURL (url);
    CREATE TABLE IconInfo (iconID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE ON CONFLICT REPLACE, url TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT FAIL, stamp INTEGER);
    CREATE INDEX IconInfoIndex ON IconInfo (url, iconID);
    CREATE TABLE IconData (iconID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE ON CONFLICT REPLACE, data BLOB);
    CREATE INDEX IconDataIndex ON IconData (iconID);
    CREATE TABLE IconDatabaseInfo (key TEXT NOT NULL ON CONFLICT FAIL UNIQUE ON CONFLICT REPLACE, value TEXT NOT NULL ON CONFLICT FAIL);
    INSERT INTO IconDatabaseInfo VALUES ("Version", "6");'
fi

if [ ${USER} = "root" ]
then
    #change file owner
    # 1. libraries
    chown root:root /usr/lib/libewebkit2.so

    # 2. Resources
       chown 5000:5000 /opt/dbspace/.webkit
       chown 5000:5000 /opt/dbspace/.webkit/WebpageIcons.db
fi

#change file permissions
# 1. libraries
chmod 644 /usr/lib/libewebkit2.so

# 2. Resources
chmod 775 /opt/dbspace/.webkit
chmod 660 /opt/dbspace/.webkit/WebpageIcons.db

#################################################################
# Set executin script
#################################################################
echo "[WebKit-EFL] postinst done ..."