#!/bin/sh

#------------------------------------------#
# appsvc upgrade (2.4 -> 3.0)              #
#------------------------------------------#

# Macro
PATH=/bin:/usr/bin:/sbin:/usr/sbin

DB_DIR_24=/opt/dbspace
DB_DIR_30=/opt/usr/home/owner/.applications/dbspace

DB_APPSVC_24=$DB_DIR_24/.appsvc.db
DB_APPSVC_30=$DB_DIR_30/.appsvc.db

# Create table
sqlite3 $DB_APPSVC_24 << EOF
CREATE TABLE IF NOT EXISTS alias_info (
	alias_appid TEXT NOT NULL,
	appid TEXT NOT NULL,
	PRIMARY KEY (alias_appid)
);

CREATE TABLE IF NOT EXISTS alias_info_for_uid (
	appid TEXT NOT NULL,
	uid INTEGER NOT NULL,
	is_enabled TEXT NOT NULL DEFAULT 'false',
	PRIMARY KEY (appid, uid)
	FOREIGN KEY (appid)
	REFERENCES alias_info(appid)
	ON DELETE CASCADE
);

CREATE TRIGGER IF NOT EXISTS update_alias_info_for_uid
	AFTER UPDATE ON alias_info_for_uid
	BEGIN
		DELETE FROM alias_info_for_uid
		WHERE is_enabled='true';
	END;
EOF

# Copy DB
cp -rf $DB_APPSVC_24 $DB_APPSVC_30
cp -rf $DB_APPSVC_24-journal $DB_APPSVC_30-journal

chown owner:users $DB_APPSVC_30
chown owner:users $DB_APPSVC_30-journal

chsmack -a User::Home $DB_APPSVC_30
chsmack -a User::Home $DB_APPSVC_30-journal

chmod 666 $DB_APPSVC_24
chmod 666 $DB_APPSVC_24-journal

chsmack -a User::Home $DB_APPSVC_24
chsmack -a User::Home $DB_APPSVC_24-journal