#!/bin/bash
HOST="localhost" # IP of machine on which mysql database is located
-PORT="5055"
-DATABASE="storage"
-USER="storage"
-PASS="storage123"
-TABLE="events"
-STORAGE_PATH="/Users/Jerus/storedFiles"
-MAX_SIZE="30000000"
-MAX_OCCUPATION="80"
-REMOVE_PERCENT="60"
-EVENTS_IN_FILE="5"
-EVENT_SERVER="pcald39fix" # IP of machine running alieventserver
-EVENT_SERVER_PORT="5024"
-STORAGE_SERVER="pcald39fix" # IP of machine running alistorage
-STORAGE_SERVER_PORT="5066" # server thread communication port
-STORAGE_CLIENT_PORT="5088" # client thread communication port
-XML_SERVER_PORT="5099" # server of xml files
-mysql -u root -pdaq -e "create database if not exists $DATABASE;"
-mysql -u root -pdaq -e "grant ALL PRIVILEGES on $DATABASE.* to '$USER'@'$HOST' identified by '$PASS';"
-mysql -u root -pdaq -e "use $DATABASE;"
-mysql -u root -pdaq -e "CREATE TABLE IF NOT EXISTS $DATABASE.$TABLE(\
+PORT="123"
+DATABASE="database"
+USER="user"
+PASS="pass123"
+TABLE="table"
+STORAGE_PATH="/some/path/"
+MAX_SIZE="300000000"
+MAX_OCCUPATION="100"
+REMOVE_PERCENT="50"
+EVENTS_IN_FILE="20"
+EVENT_SERVER="localhost" # IP of machine running alieventserver
+EVENT_SERVER_USER="user"
+EVENT_SERVER_PORT="124"
+STORAGE_SERVER="localhost" # IP of machine running alistorage
+STORAGE_SERVER_USER="user"
+STORAGE_SERVER_PORT="125" # server thread communication port
+STORAGE_CLIENT_PORT="126" # client thread communication port
+XML_SERVER_PORT="127" # server of xml files
+mysql -u root -ppassword -e "create database if not exists $DATABASE;"
+mysql -u root -ppassword -e "grant ALL PRIVILEGES on $DATABASE.* to '$USER'@'$HOST' identified by '$PASS';"
+mysql -u root -ppassword -e "use $DATABASE;"
+mysql -u root -ppassword -e "CREATE TABLE IF NOT EXISTS $DATABASE.$TABLE(\
run_number int(6) NOT NULL,\
event_number int(6) NOT NULL,\
system text(7) DEFAULT NULL,\
echo "-----------------------------"
echo "Databases successfuly created"
-echo "-----------------------------"
\ No newline at end of file
+echo "-----------------------------"