...

$ mysql -u shrine -pdemouser

To create the 4 2 SHRINE databases, you will need to run these commands within the MySQL prompt:

CREATE DATABASE adapterAuditDBQEP;
CREATE DATABASE qepAuditDB;
CREATE DATABASE shrine_query_history;ADAPTER;

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

mysql -u shrine -pdemouser adapterAuditDBADAPTER < 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 qepAuditDBQEP < shrine-setup/qep/sql/qep-mysql.ddl

Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:

...

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/qep-mssql.ddl
• ./adapter/sql/adapterAuditDBadapter-mssql.ddl./adapter/sql/shrine_query_history-mssql.ddl 

Oracle

To install oracle schemas load all of the SHRINE databases into one central schema: ShrineDB (use this name when you configure context.xml).

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/qep-oracle.ddl
• ./adapter/sql/adapterAuditDB-oracle.ddl./adapter/sql/shrine_query_history-oracle.ddl