Page History

...

CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE shrine_query_history;

After creating these databases, you will need to install schemas.

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 stewardDB < shrine-setup/dsa/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql.ddl

...

Install schemas for MS SQL Server, instead of schemas labeled with mysql.sql, use schemas ending with mssql.sql from shrine-setup.zip:

...

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

...

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. These files are found within the shrine-setup.zip archive file:

...

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