Page tree
Skip to end of metadata
Go to start of metadata

Update Schema

Download in temporary directory and unpack it.

wget -O /tmp/
unzip -d /tmp /tmp/

In that directory find the following database update scripts for your brand of database: adapter/sql/shrine_query_history-brand.sql . Run the appropriate script on your database. For MariaDB run the following shell commands:

mysql -u shrine -pYourPassword shrine_query_history < /tmp/shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql

For MS SQL and Oracle, run the scripts appropriate for your databases. 

For hub administrators only, run the following shell command:

mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/hub/sql/mysql-update.sql
  • No labels