#!/bin/bash
#
# (c) cutmasta 
#
# Adds the standard folder for the ox folders and a standard rights template!
#
# GLOBAL CONFIGFILE
prefix=/usr
exec_prefix=${prefix}

GLOBAL_CONF="/etc/open-xchange/admintools.conf"

if [ -f $GLOBAL_CONF ]
    then
    . $GLOBAL_CONF
    else
    echo "Config File $GLOBAL_CONF not found."
    exit 0
fi

SQL_HOST=$DEFAULT_SQL_HOST
SQL_DB=$DEFAULT_SQL_DB
SQL_USER=$DEFAULT_SQL_USER
SQL_PASS=$DEFAULT_SQL_PASS
 

###################### INSERT THE STANDARD RIGHTS ########
if [ "$SQL_DB_TYPE" = "pgsql" ]
then
	$SQL_BIN -h $SQL_HOST -U $SQL_USER -d $SQL_DB -X -c "INSERT INTO $TEMPLATE_TABLE values ('now','admin','now','','default_template','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');"

else

	$MYSQL_BIN -h $SQL_HOST -u $SQL_USER --password=$SQL_PASS $SQL_DB -e "INSERT INTO $TEMPLATE_TABLE values (now(),'admin',now(),'','default_template','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y','y');"
	
fi
