11. The audit logs

The audit entry in the app.php config file defines the following options.

• Enable the audit logs feature. A link to the audit page is added in the app menu.
• Grant access to the audit page to the app users.
• Define a database for the audit logs storage.
• Define pagination options in the audit page.

    'audit' => [
        'enabled' => false,
        'users' => [
            // The emails of users that are allowed to access the audit page.
        ],
        'queries' => [
            'database' => [
                // Same as the "servers" items, but "name" is the database name.
            ],
            'pagination' => [
                'limit' => 10,
            ],
        ],
    ],

The admin->queries entry in the app.php config file defines the which queries are saved in the audit database, and enables the query history and favorites features.

    'admin' => [
        'queries' => [
            'save' => [
                'editor' => true,
                'builder' => true,
                'library' => false,
            ],
            'show' => [
                'preferences' => true,
                'history' => true,
                'favorite' => true,
            ],
            'history' => [
                'distinct' => false,
                'limit' => 10,
            ],
            'favorite' => [
                'limit' => 10,
            ],
        ],
    ],