Versions Compared

Key

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

...

Code Block
languagebash
themerdark
$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;

MS SQL Server

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

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

...

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

...