#!/bin/sh

MYSQL_COMMAND='/usr/local/mysql/bin/mysql'
CURRENT_DIRECTORY=`dirname $0`

WEB_SERVER_ROOT=/var/www
CSS_DIRECTORY_NAME=css
CSS_UI_DIRECTORY_NAME=ui
CSS_SCREEN_NAME=Screen.css
DOMAIN_NAME=www.technoganivet.it


cd $CURRENT_DIRECTORY


echo 'CREATE DATABASE `xtro_tg` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;' | $MYSQL_COMMAND -u root -pm194asto

echo "xtro_tg DB created"

$MYSQL_COMMAND -u root -pm194asto -B xtro_tg < $1



echo 'ALTER TABLE `xt_container` ADD INDEX (`the_name`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerName` ADD INDEX (`idXTContainer`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerName` ADD INDEX (`theName`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerName` ADD INDEX (`theLanguageCode`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE `XTContainerAction` ADD UNIQUE (`theURL`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerAction` ADD INDEX (`idXTContainer`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerAction` ADD INDEX (`theLanguageCode`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg
echo 'ALTER TABLE  `XTContainerAction` ADD INDEX (`theURL`)' | $MYSQL_COMMAND -u root -pm194asto -B xtro_tg

echo "indexes created"

#creating webfolder

mkdir -p $WEB_SERVER_ROOT/$DOMAIN_NAME/$CSS_DIRECTORY_NAME/$CSS_UI_DIRECTORY_NAME
touch $WEB_SERVER_ROOT/$DOMAIN_NAME/$CSS_DIRECTORY_NAME/$CSS_SCREEN_NAME



cp ./htaccess.txt $WEB_SERVER_ROOT/$DOMAIN_NAME/.htaccess

cd $WEB_SERVER_ROOT/$DOMAIN_NAME/

ln -s "../lib" .
ln -s "../interface" .
ln -s "../apps.xplants.it" .
ln -s "../cmsadmin" .
ln -s "../WebObjects" .
ln -s "../cms.xplants.it" .
ln -s "../www.technoganivet.it" .

cat > $WEB_SERVER_ROOT/$DOMAIN_NAME/google43c81229128fc67d.html << EOF
google-site-verification: google43c81229128fc67d.html
EOF
exit 0