Adding Domenico Colella as responsible for SPD part in TRI pp
[u/mrichter/AliRoot.git] / MONITOR / alistoragemanager / setupStorageDatabase.sh
1 #!/bin/bash
2 HOST="localhost"   # IP of machine on which mysql database is located
3 PORT="123"
4 DATABASE="database"
5 USER="user"
6 PASS="pass123"
7 TABLE="table"
8 STORAGE_PATH="/some/path/"
9 MAX_SIZE="300000000"
10 MAX_OCCUPATION="100"
11 REMOVE_PERCENT="50"
12 EVENTS_IN_FILE="20"
13 EVENT_SERVER="localhost"   # IP of machine running alieventserver
14 EVENT_SERVER_USER="user"
15 EVENT_SERVER_PORT="124"
16 STORAGE_SERVER="localhost"      # IP of machine running alistorage
17 STORAGE_SERVER_USER="user"
18 STORAGE_SERVER_PORT="125"      # server thread communication port
19 STORAGE_CLIENT_PORT="126"      # client thread communication port
20 XML_SERVER_PORT="127"          # server of xml files
21 mysql -u root -ppassword -e "create database if not exists $DATABASE;"
22 mysql -u root -ppassword -e "grant ALL PRIVILEGES on $DATABASE.* to '$USER'@'$HOST' identified by '$PASS';"
23 mysql -u root -ppassword -e "use $DATABASE;"
24 mysql -u root -ppassword -e "CREATE TABLE IF NOT EXISTS $DATABASE.$TABLE(\
25 run_number int(6) NOT NULL,\
26 event_number int(6) NOT NULL,\
27 system text(7) DEFAULT NULL,\
28 multiplicity int(5) DEFAULT NULL,\
29 permanent tinyint(1) DEFAULT NULL,\
30 file_path text(100) DEFAULT NULL,\
31 PRIMARY KEY(run_number,event_number));"
32
33 echo "-----------------------------"
34 echo "Databases successfuly created"
35 echo "-----------------------------"