summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--docs/account_access.md2
-rw-r--r--docs/autobroadcast.md2
-rw-r--r--docs/database-auth.md3
-rw-r--r--docs/ip_banned.md4
-rw-r--r--docs/logs.md8
-rw-r--r--docs/logs_ip_actions.md16
-rw-r--r--docs/realmcharacters.md6
-rw-r--r--docs/realmlist.md18
-rw-r--r--docs/secret_digest.md27
-rw-r--r--docs/uptime.md8
-rw-r--r--docs/version_db_auth.md28
11 files changed, 79 insertions, 43 deletions
diff --git a/docs/account_access.md b/docs/account_access.md
index c6594c7..29d8263 100644
--- a/docs/account_access.md
+++ b/docs/account_access.md
@@ -13,7 +13,7 @@ This table holds security access level for any realm in [realmlist](realmlist) t
| [id][1] | INT | UNSIGNED | PRI | NO | | | |
| [gmlevel][2] | TINYINT | UNSIGNED | | NO | | | |
| [RealmID][3] | INT | SIGNED | PRI | NO | -1 | | |
-| [comment][4] | VARCHAR(255) | | | YES | | | |
+| [comment][4] | VARCHAR(255) | | | YES | '' | | |
[1]: #id
[2]: #gmlevel
diff --git a/docs/autobroadcast.md b/docs/autobroadcast.md
index 55b8239..a39094a 100644
--- a/docs/autobroadcast.md
+++ b/docs/autobroadcast.md
@@ -13,7 +13,7 @@ This table contains the autobroadcast entries for your realms. Values like it's
| [realmid][1] | INT | SIGNED | PRI | NO | -1 | | |
| [id][2] | TINYINT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
| [weight][3] | TINYINT | UNSIGNED | | YES | 1 | | |
-| [text][4] | longtext | | | NO | | | |
+| [text][4] | LONGTEXT | | | NO | | | |
[1]: #realmid
[2]: #id
diff --git a/docs/database-auth.md b/docs/database-auth.md
index e039009..69c891d 100644
--- a/docs/database-auth.md
+++ b/docs/database-auth.md
@@ -1,6 +1,6 @@
# Database Auth
-The auth database currently has 14 tables, which mainly store information related to user accounts. Although some of them have other functionalities. The last synchronization was done: [10-01-2021](https://github.com/azerothcore/wiki/issues/338). If you detect that any table is outdated, you can create an [issue](https://github.com/azerothcore/wiki/issues) within our repository or make a [pull request](https://github.com/azerothcore/wiki/pulls) with the modification of the information.
+The auth database currently has 14 tables, which mainly store information related to user accounts. Although some of them have other functionalities. The last synchronization was done: [05-07-2021](https://github.com/azerothcore/wiki/pull/573). If you detect that any table is outdated, you can create an [issue](https://github.com/azerothcore/wiki/issues) within our repository or make a [pull request](https://github.com/azerothcore/wiki/pulls) with the modification of the information.
- [account](account.md)
- [account_access](account_access.md)
@@ -13,5 +13,6 @@ The auth database currently has 14 tables, which mainly store information relate
- [logs_ip_actions](logs_ip_actions.md)
- [realmcharacters](realmcharacters.md)
- [realmlist](realmlist.md)
+- [secret_digest](secret_digest.md)
- [uptime](uptime.md)
- [version_db_auth](version_db_auth.md)
diff --git a/docs/ip_banned.md b/docs/ip_banned.md
index 08827f1..7e87843 100644
--- a/docs/ip_banned.md
+++ b/docs/ip_banned.md
@@ -11,8 +11,8 @@ This table contains all of the banned IPs and the date when (or if) the ban will
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------|--------------|------------|-----|------|-----------|-------|---------|
| [ip][1] | VARCHAR(15) | | PRI | NO | 127.0.0.1 | | |
-| [bandate][2] | INT | UNSIGNED | PRI | NO | | | |
-| [unbandate][3] | INT | UNSIGNED | | NO | | | |
+| [bandate][2] | INT | UNSIGNED | PRI | NO | | | |
+| [unbandate][3] | INT | UNSIGNED | | NO | | | |
| [bannedby][4] | VARCHAR(50) | | | NO | [Console] | | |
| [banreason][5] | VARCHAR(255) | | | NO | no reason | | |
diff --git a/docs/logs.md b/docs/logs.md
index 4ec2adf..034a1ea 100644
--- a/docs/logs.md
+++ b/docs/logs.md
@@ -14,11 +14,11 @@ Appender.DB=3,5,0
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-------------|--------------|------------|-----|------|---------|-------|---------|
-| [time][1] | INT | UNSIGNED | | NO | | | |
-| [realm][2] | INT | UNSIGNED | | NO | | | |
+| [time][1] | INT | UNSIGNED | | NO | | | |
+| [realm][2] | INT | UNSIGNED | | NO | | | |
| [type][3] | VARCHAR(250) | | | NO | | | |
-| [level][4] | TINYINT | UNSIGNED | | NO | 0 | | |
-| [string][5] | text | | | YES | | | |
+| [level][4] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [string][5] | TEXT | | | YES | | | |
[1]: #time
[2]: #realm
diff --git a/docs/logs_ip_actions.md b/docs/logs_ip_actions.md
index d52d7ff..e138f19 100644
--- a/docs/logs_ip_actions.md
+++ b/docs/logs_ip_actions.md
@@ -8,15 +8,15 @@
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------------|-------------|------------|-----|------|-------------------|----------------|-------------------------------|
-| [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Unique Identifier |
-| [account_id][2] | INT | UNSIGNED | | NO | | | Account ID |
-| [character_guid][3] | INT | UNSIGNED | | NO | | | Character Guid |
-| [type][4] | TINYINT | UNSIGNED | | NO | | | |
+| [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | Unique Identifier |
+| [account_id][2] | INT | UNSIGNED | | NO | | | Account ID |
+| [character_guid][3] | INT | UNSIGNED | | NO | | | Character Guid |
+| [type][4] | TINYINT | UNSIGNED | | NO | | | |
| [ip][5] | VARCHAR(15) | | | NO | 127.0.0.1 | | |
-| [systemnote][6] | text | | | YES | | | Notes inserted by system |
-| [unixtime][7] | INT | UNSIGNED | | NO | | | Unixtime |
-| [time][8] | TIMESTAMP | | | NO | CURRENT_TIMESTAMP | | TIMESTAMP |
-| [comment][9] | text | | | YES | | | Allows users to add a comment |
+| [systemnote][6] | TEXT | | | YES | | | Notes inserted by system |
+| [unixtime][7] | INT | UNSIGNED | | NO | | | Unixtime |
+| [time][8] | TIMESTAMP | | | NO | CURRENT_TIMESTAMP | | Timestamp |
+| [comment][9] | TEXT | | | YES | | | Allows users to add a comment |
[1]: #id
[2]: #account_id
diff --git a/docs/realmcharacters.md b/docs/realmcharacters.md
index b6991f8..e2ef446 100644
--- a/docs/realmcharacters.md
+++ b/docs/realmcharacters.md
@@ -11,9 +11,9 @@ The data in this table is maintained by the core.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------|------------|------------|-----|------|---------|-------|---------|
-| [realmid][1] | INT | UNSIGNED | PRI | NO | 0 | | |
-| [acctid][2] | INT | UNSIGNED | PRI | NO | | | |
-| [numchars][3] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [realmid][1] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [acctid][2] | INT | UNSIGNED | PRI | NO | | | |
+| [numchars][3] | TINYINT | UNSIGNED | | NO | 0 | | |
[1]: #realmid
[2]: #acctid
diff --git a/docs/realmlist.md b/docs/realmlist.md
index 3ab4411..3359631 100644
--- a/docs/realmlist.md
+++ b/docs/realmlist.md
@@ -10,18 +10,18 @@ This table sets up information on all available realms. Each row controls a diff
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|----------------------------|--------------|------------|-----|------|---------------|----------------|---------|
-| [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
-| [name][2] | VARCHAR(32) | | UNI | NO | | | |
+| [id][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | |
+| [name][2] | VARCHAR(32) | | UNI | NO | '' | | |
| [address][3] | VARCHAR(255) | | | NO | 127.0.0.1 | | |
| [localAddress][4] | VARCHAR(255) | | | NO | 127.0.0.1 | | |
| [localSubnetMask][5] | VARCHAR(255) | | | NO | 255.255.255.0 | | |
-| [port][6] | SMALLINT | UNSIGNED | | NO | 8085 | | |
-| [icon][7] | TINYINT | UNSIGNED | | NO | 0 | | |
-| [flag][8] | TINYINT | UNSIGNED | | NO | 2 | | |
-| [timezone][9] | TINYINT | UNSIGNED | | NO | 0 | | |
-| [allowedSecurityLevel][10] | TINYINT | UNSIGNED | | NO | 0 | | |
-| [population][11] | FLOAT | UNSIGNED | | NO | 0 | | |
-| [gamebuild][12] | INT | UNSIGNED | | NO | 12340 | | |
+| [port][6] | SMALLINT | UNSIGNED | | NO | 8085 | | |
+| [icon][7] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [flag][8] | TINYINT | UNSIGNED | | NO | 2 | | |
+| [timezone][9] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [allowedSecurityLevel][10] | TINYINT | UNSIGNED | | NO | 0 | | |
+| [population][11] | FLOAT | | | NO | 0 | | |
+| [gamebuild][12] | INT | UNSIGNED | | NO | 12340 | | |
[1]: #id
[2]: #name
diff --git a/docs/secret_digest.md b/docs/secret_digest.md
new file mode 100644
index 0000000..64c0396
--- /dev/null
+++ b/docs/secret_digest.md
@@ -0,0 +1,27 @@
+# secret_digest
+
+[<-Back-to:Auth](database-auth.md)
+
+**The \`secret_digest\` table**
+
+**Structure**
+
+| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
+| ------------ | ------------ | ---------- | --- | ---- | ------- | ----- | ------- |
+| [id][1] | INT | UNSIGNED | PRI | NO | | | |
+| [digest][2] | VARCHAR(100) | | | NO | | | |
+
+
+[1]: #id
+[2]: #digest
+
+
+**Description of the fields**
+
+### id
+
+The id digest.
+
+### digest
+
+`field-no-description|2` \ No newline at end of file
diff --git a/docs/uptime.md b/docs/uptime.md
index 8e791bb..395732d 100644
--- a/docs/uptime.md
+++ b/docs/uptime.md
@@ -10,10 +10,10 @@ This table holds the server's uptime. The core will automatically update the lat
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-----------------|--------------|------------|-----|------|-------------|-------|---------|
-| [realmid][1] | INT | UNSIGNED | PRI | NO | | | |
-| [starttime][2] | INT | UNSIGNED | PRI | NO | 0 | | |
-| [uptime][3] | INT | UNSIGNED | | NO | 0 | | |
-| [maxplayers][4] | SMALLINT | UNSIGNED | | NO | 0 | | |
+| [realmid][1] | INT | UNSIGNED | PRI | NO | | | |
+| [starttime][2] | INT | UNSIGNED | PRI | NO | 0 | | |
+| [uptime][3] | INT | UNSIGNED | | NO | 0 | | |
+| [maxplayers][4] | SMALLINT | UNSIGNED | | NO | 0 | | |
| [revision][5] | VARCHAR(255) | | | NO | AzerothCore | | |
[1]: #realmid
diff --git a/docs/version_db_auth.md b/docs/version_db_auth.md
index f2ba4dc..2bb9da7 100644
--- a/docs/version_db_auth.md
+++ b/docs/version_db_auth.md
@@ -8,21 +8,29 @@
|--------------------|--------------|------------|-----|------|---------|-------|---------|
| [sql_rev][1] | VARCHAR(100) | | PRI | NO | | | |
| [required_rev][2] | VARCHAR(100) | | MUL | YES | | | |
-| [2020_02_07_00][3] | bit(1) | | | YES | | | |
+| [date][3] | VARCHAR(50) | | | YES | | | |
+| [2021_06_17_00][4] | BIT(1) | | | YES | | | |
-[1]: #sql_rev
-[2]: #required_rev
-[3]: #2020_02_07_00
+[1]: #sqlrev
+[2]: #requiredrev
+[3]: #date
+[4]: #2021061700
+
+**Description of the fields**
### sql_rev
+SQL review.
+
### required_rev
-### 2020_02_07_00
+### date
+
+Sql revisions date.
+
+### 2021_06_17_00
+
+The date of the last update to the auth database.
-### Example
+**Note** this column changes automatically according to the last update of the auth database.
-| sql_rev | required_rev | 2020_02_07_00 |
-|---------------------|--------------|---------------|
-| 1554142988374631100 | | |
-| 1579213352894781043 | | |
generated by cgit (git 2.34.1) at 2026-05-15 21:15:21 +0000