Page History

...

To upgrade the SHRINE_QUERY table, retrieve the adapter-migrate-schema-to-1.18.sql script and run it:

$

...

wget

...

https://open.med.harvard.edu/svn/shrine/releases/1.18.0/code/adapter/src/main/resources/adapter-migrate-schema-to-1.18.sql

...

$

...

mysql

...

-u

...

$SHRINE_MYSQL_USER

...

-p$SHRINE_MYSQL_PASSWORD

...

-D

...

shrine_query_history

...

<

...

adapter-migrate-schema-to-1.18.sql

To create the HUB_QUERY and HUB_QUERY_RESULT tables, download the hub.sql script and run it:

$ wget https://open.med.harvard.edu/svn/shrine/releases/1.18.0/code/broadcaster-aggregator/src/main/resources/hub.sql
 $ mysql -u $SHRINE_MYSQL_USER -p$SHRINE_MYSQL_PASSWORD -D shrine_query_history < hub.sql

...