The `uptime` table
This table holds the server's uptime. The core will automatically update the latest entry's value until it crashes and a new record is added.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| realmid | INT | UNSIGNED | PRI | NO | |||
| starttime | INT | UNSIGNED | PRI | NO | 0 | ||
| uptime | INT | UNSIGNED | NO | 0 | |||
| EndTime | INT | UNSIGNED | YES | NULL | |||
| maxplayers | SMALLINT | UNSIGNED | NO | 0 | |||
| revision | VARCHAR(255) | NO | AzerothCore | ||||
| ShutdownType | TINYINT | UNSIGNED | NO | 0 | |||
| ExitCode | TINYINT | UNSIGNED | YES | NULL | |||
| ShutdownReason | VARCHAR(255) | NO | '' |
Description of the fields
The ID of the realm. See realmlist.id.
The time when the server was started, in Unix time.
The uptime of the server, in seconds.
The time the server shut down, in Unix time. NULL while the server is running, or if it crashed. The .server info command uses this to show whether the last session crashed.
The maximum number of players connected.
The detailed revision of the worldserver.
| Value | Type |
|---|---|
| 0 | Unknown |
| 1 | Shutdown |
| 2 | Restart |
| 3 | Error |
The exit code of the worldserver: 0 for a shutdown, 1 for an error and 2 for a restart. NULL if the server did not shut down cleanly.
The reason given for the shutdown or restart, for example with .server shutdown.