Versions Compared

Key

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

Update Schema

Download shrine-setup.zip in temporary directory and unpack it.

Code Block
languagebash
themeRDark
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.1.0/shrine-setup-3.1.0-dist.zip -O /tmp/shrine-setup.zip
unzip -d /tmp /tmp/shrine-setup.zip

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

Code Block
languagebash
themeRDark
mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/qep/sql/mysql-update.sql

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