> cd docs/dbschema
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < create_db.sql
 
# You have to alter table where some config info is stored make sure to call
 
> cat alter_00.sql | \
      sed 's|@FULL_PATH_FOR_STORAGE@|/this/is/the/location/where/all/users/can/write|' > \
      alter_00_modified.sql
    mysql -h itmmysql1 -u ual_user_s itmcatalog -p < alter_00_modified.sql
 
# /this/is/the/location/where/all/users/can/write - is a place on your machine (where users are calling
#                                                   scheduler application). Each user has to have write
#                                                   access there.
 
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < alter_00_modified.sql
 
 
# make sure to create list of variables that are stored inside DB
 
> xsltproc ./getFieldsIMAS.xsl \
      $IMAS_HOME/core/installer/src/$IMAS_VERSION/ual/$UAL_VERSION/xml/IDSDef.xml | \
      grep "summary" > \
      variables.sql
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p < variables.sql
 
# double check that all tables are in proper place
 
> mysql -h $HOST_NAME -u $UAL_USER itmcatalog -p
> ...
> mysql> show tables;
+----------------------+
| Tables_in_itmcatalog |
+----------------------+
| annotations          |
| catalog_parameters   |
| entry                |
| entry_data           |
| intervals            |
| machines             |
| outcome              |
| scheduler            |
| users                |
| variables            |
+----------------------+
10 rows in set (0.00 sec)