...

wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.2.1/shrine-setup-34.20.10-dist.zip -O shrine-setup.zip
unzip shrine-setup.zip

...

mysql -u shrine -pdemouser adapterAuditDB < shrine-setup/adapter/sql/adapterAuditDB-mysql.ddl
mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-mysql.ddl
mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql
mysql -u shrine -pdemouser stewardDB < shrine-setup/dsa/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql.ddl

...

• ./dsa/sql/mssql.ddl
• ./qep/sql/mssql.ddl
• ./adapter/sql/adapterAuditDB-mssql.ddl
• ./adapter/sql/shrine_query_history-mssql.ddl ./adapter/sql/shrine_query_history-update-mssql.sql

Oracle

To install oracle schemas load all of the SHRINE databases into one central schema: ShrineDB (use this name when you configure context.xml).

Once you have created the database, load all the schemas into it. Instead of schemas labeled with mysql.sql, load schemas ending with oracle.ddl. Specifically, for SHRINE release 3.2.1, there are four (4) ddl files that you should load.  These files are found within the shrine-setup.zip archive file:

• ./dsa/sql/oracle.ddl
• ./qep/sql/oracle.ddl
• ./adapter/sql/adapterAuditDB-oracle.ddl
• ./adapter/sql/shrine_query_history-oracle.ddl./adapter/sql/shrine_query_history-update-oracle.sql