Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
themerdark
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
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql-update.sql

...

  • ./dsa/sql/mssql.ddl
  • ./qep/sql/mssql.ddl
  • ./qep/sql/mssql-update.ddl
  • ./adapter/sql/adapterAuditDB-mssql.ddl
  • ./adapter/sql/shrine_query_history-mssql.ddl 
  • ./adapter/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).

...

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