Database

Tables the script creates.

Not released yet. These pages are written from the code of manniche_admin and can change before the release.

Schema

All tables start with manniche_admin_ and use CREATE TABLE IF NOT EXISTS. On every start the resource reads sql/install.sql and runs each statement, so a manual import is optional. If the file cannot be read, a built-in schema is used. ESX's own tables are not modified.

On first start, if the roles table is empty, the default roles are created. See Permissions and roles.

Tables

Table
`manniche_admin_roles`
`manniche_admin_role_permissions`
`manniche_admin_users`
`manniche_admin_user_permissions`
`manniche_admin_logs`
`manniche_admin_bans`
`manniche_admin_warnings`
`manniche_admin_notes`
`manniche_admin_reports`
`manniche_admin_report_messages`
`manniche_admin_job_meta`
`manniche_admin_preferences`
`manniche_admin_settings`
`manniche_admin_playtime`
`manniche_admin_profiles`
`manniche_admin_chat_channels`
`manniche_admin_chat_members`
`manniche_admin_chat_messages`
`manniche_admin_tickets`
`manniche_admin_ticket_messages`
`manniche_admin_props`
`manniche_admin_spawn_log`
`manniche_admin_blacklist`
`manniche_admin_jail`

Persistent props are saved in manniche_admin_props and respawned on start. manniche_admin_job_meta stores the whitelisted and gang flags set in the panel.