]>
Commit | Line | Data |
---|---|---|
5eb34a26 | 1 | #!/bin/bash |
2 | HOST="localhost" # IP of machine on which mysql database is located | |
3 | PORT="5055" | |
4 | DATABASE="storage" | |
5 | USER="storage" | |
6 | PASS="storage123" | |
7 | TABLE="events" | |
8 | STORAGE_PATH="/local/home/edis/storedFiles" | |
164d3d29 | 9 | MAX_SIZE="10000000" |
5eb34a26 | 10 | MAX_OCCUPATION="80" |
11 | REMOVE_PERCENT="60" | |
164d3d29 | 12 | EVENTS_IN_FILE="5" |
13 | EVENT_SERVER="pcald39fix" # IP of machine running alieventserver | |
14 | EVENT_SERVER_PORT="5024" | |
5eb34a26 | 15 | STORAGE_SERVER="localhost" # IP of machine running alistorage |
164d3d29 | 16 | STORAGE_SERVER_PORT="5066" # server thread communication port |
17 | STORAGE_CLIENT_PORT="5088" # client thread communication port | |
18 | XML_SERVER_PORT="5099" # server of xml files | |
5eb34a26 | 19 | mysql -u root -pdaq -e "create database if not exists $DATABASE;" |
20 | mysql -u root -pdaq -e "grant ALL PRIVILEGES on $DATABASE.* to '$USER'@'$HOST' identified by '$PASS';" | |
21 | mysql -u root -pdaq -e "use $DATABASE;" | |
22 | mysql -u root -pdaq -e "CREATE TABLE IF NOT EXISTS $DATABASE.$TABLE(\ | |
23 | run_number int(6) NOT NULL,\ | |
24 | event_number int(6) NOT NULL,\ | |
25 | system text(7) DEFAULT NULL,\ | |
26 | multiplicity int(5) DEFAULT NULL,\ | |
27 | permanent tinyint(1) DEFAULT NULL,\ | |
28 | file_path text(100) DEFAULT NULL,\ | |
29 | PRIMARY KEY(run_number,event_number));" | |
30 | ||
31 | echo "-----------------------------" | |
32 | echo "Databases successfuly created" | |
164d3d29 | 33 | echo "-----------------------------" |