Configuration Guides › Directory Configuration Guide › MySQL Server › Configure MySQL Data Stores › How to Store Audit Logs in MySQL › Create the Audit Log Schema

Create the Audit Log Schema

You create the audit log schema so the MySQL database can store audit logs.

To create the audit log schema

1. Navigate to path\MySQL.

   path

   Specifies the path to the schema files extracted from the tier 2 directory zip.

2. Open the following file in a text editor:

   sm_mysql_logs.sql

3. Locate the following lines:

   DROP FUNCTION IF EXISTS `databaseName`.`getdate` $$
   CREATE FUNCTION `databaseName`.`getdate` () RETURNS DATE
   

4. Replace each instance of 'databaseName' with the name of the database functioning as the audit store.

   Example: If the name of the database is smauditstore, the required update appears as follows:

   DROP FUNCTION IF EXISTS `smauditstore`.`getdate` $$
   CREATE FUNCTION `smauditstore`.`getdate` () RETURNS DATE
   

5. Copy the contents of the entire file.
6. Paste the file contents into a query and execute the query.

   The audit store schema is created.