Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE shrine_query_history; |
After creating these databases, you will need to install schemas.
Code Block | ||||
---|---|---|---|---|
| ||||
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
Overview
Content Tools