diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2021-05-01 01:48:43 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-01 01:48:43 +0200 |
| commit | 29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b (patch) | |
| tree | 777be1e4c5796cd2531e7959632a48f5cb5b4f22 /docs/npc_text.md | |
| parent | 2df273f79165b95b8b0b2ab471ecb8b2a54edb21 (diff) | |
| download | wiki-29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b.tar.gz wiki-29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b.tar.bz2 wiki-29b1eb3ed30e0dd50ba1cfe222a33b070e3e6e0b.zip | |
chore(docs): Update all integers to not use width (#448)
* float
* VARCHAR
* TIMESTAMP
* BIGINT
* MEDIUMINT
* SMALLINT
* TINYINT
* INT
* BLOB
* SIGNED/UNSIGNED
* AUTO_INCREMENT
* \(\d+\)
* Update Bit-and_bytes-tutorial.md
* clean-up
* Last mistakes
* this one didnt commit lul
Diffstat (limited to 'docs/npc_text.md')
| -rw-r--r-- | docs/npc_text.md | 164 |
1 files changed, 82 insertions, 82 deletions
diff --git a/docs/npc_text.md b/docs/npc_text.md index 5566144..f82a14c 100644 --- a/docs/npc_text.md +++ b/docs/npc_text.md @@ -8,88 +8,88 @@ This table contains the texts that are used for gossip. More research needs to b | Field | Type | Attributes | Key | Null | Default | Extra | Comment | |---------------|--------------|------------|-----|------|---------|-------|---------| -| ID | mediumint(8) | unsigned | PRI | NO | 0 | | | -| text0_0 | longtext | signed | | YES | NULL | | | -| text0_1 | longtext | signed | | YES | NULL | | | -| lang0 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability0 | float | signed | | NO | 0 | | | -| em0_0 | smallint(5) | unsigned | | NO | 0 | | | -| em0_1 | smallint(5) | unsigned | | NO | 0 | | | -| em0_2 | smallint(5) | unsigned | | NO | 0 | | | -| em0_3 | smallint(5) | unsigned | | NO | 0 | | | -| em0_4 | smallint(5) | unsigned | | NO | 0 | | | -| em0_5 | smallint(5) | unsigned | | NO | 0 | | | -| text1_0 | longtext | signed | | YES | NULL | | | -| text1_1 | longtext | signed | | YES | NULL | | | -| lang1 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability1 | float | signed | | NO | 0 | | | -| em1_0 | smallint(5) | unsigned | | NO | 0 | | | -| em1_1 | smallint(5) | unsigned | | NO | 0 | | | -| em1_2 | smallint(5) | unsigned | | NO | 0 | | | -| em1_3 | smallint(5) | unsigned | | NO | 0 | | | -| em1_4 | smallint(5) | unsigned | | NO | 0 | | | -| em1_5 | smallint(5) | unsigned | | NO | 0 | | | -| text2_0 | longtext | signed | | YES | NULL | | | -| text2_1 | longtext | signed | | YES | NULL | | | -| lang2 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability2 | float | signed | | NO | 0 | | | -| em2_0 | smallint(5) | unsigned | | NO | 0 | | | -| em2_1 | smallint(5) | unsigned | | NO | 0 | | | -| em2_2 | smallint(5) | unsigned | | NO | 0 | | | -| em2_3 | smallint(5) | unsigned | | NO | 0 | | | -| em2_4 | smallint(5) | unsigned | | NO | 0 | | | -| em2_5 | smallint(5) | unsigned | | NO | 0 | | | -| text3_0 | longtext | signed | | YES | NULL | | | -| text3_1 | longtext | signed | | YES | NULL | | | -| lang3 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability3 | float | signed | | NO | 0 | | | -| em3_0 | smallint(5) | unsigned | | NO | 0 | | | -| em3_1 | smallint(5) | unsigned | | NO | 0 | | | -| em3_2 | smallint(5) | unsigned | | NO | 0 | | | -| em3_3 | smallint(5) | unsigned | | NO | 0 | | | -| em3_4 | smallint(5) | unsigned | | NO | 0 | | | -| em3_5 | smallint(5) | unsigned | | NO | 0 | | | -| text4_0 | longtext | signed | | YES | NULL | | | -| text4_1 | longtext | signed | | YES | NULL | | | -| lang4 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability4 | float | signed | | NO | 0 | | | -| em4_0 | smallint(5) | unsigned | | NO | 0 | | | -| em4_1 | smallint(5) | unsigned | | NO | 0 | | | -| em4_2 | smallint(5) | unsigned | | NO | 0 | | | -| em4_3 | smallint(5) | unsigned | | NO | 0 | | | -| em4_4 | smallint(5) | unsigned | | NO | 0 | | | -| em4_5 | smallint(5) | unsigned | | NO | 0 | | | -| text5_0 | longtext | signed | | YES | NULL | | | -| text5_1 | longtext | signed | | YES | NULL | | | -| lang5 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability5 | float | signed | | NO | 0 | | | -| em5_0 | smallint(5) | unsigned | | NO | 0 | | | -| em5_1 | smallint(5) | unsigned | | NO | 0 | | | -| em5_2 | smallint(5) | unsigned | | NO | 0 | | | -| em5_3 | smallint(5) | unsigned | | NO | 0 | | | -| em5_4 | smallint(5) | unsigned | | NO | 0 | | | -| em5_5 | smallint(5) | unsigned | | NO | 0 | | | -| text6_0 | longtext | signed | | YES | NULL | | | -| text6_1 | longtext | signed | | YES | NULL | | | -| lang5 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability6 | float | signed | | NO | 0 | | | -| em6_0 | smallint(5) | unsigned | | NO | 0 | | | -| em6_1 | smallint(5) | unsigned | | NO | 0 | | | -| em6_2 | smallint(5) | unsigned | | NO | 0 | | | -| em6_3 | smallint(5) | unsigned | | NO | 0 | | | -| em6_4 | smallint(5) | unsigned | | NO | 0 | | | -| em6_5 | smallint(5) | unsigned | | NO | 0 | | | -| text7_0 | longtext | signed | | YES | NULL | | | -| text7_1 | longtext | signed | | YES | NULL | | | -| lang7 | tinyint(3) | unsigned | | NO | 0 | | | -| Probability7 | float | signed | | NO | 0 | | | -| em7_0 | smallint(5) | unsigned | | NO | 0 | | | -| em7_1 | smallint(5) | unsigned | | NO | 0 | | | -| em7_2 | smallint(5) | unsigned | | NO | 0 | | | -| em7_3 | smallint(5) | unsigned | | NO | 0 | | | -| em7_4 | smallint(5) | unsigned | | NO | 0 | | | -| em7_5 | smallint(5) | unsigned | | NO | 0 | | | -| VerifiedBuild | smallint(5) | signed | | YES | 1 | | | +| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | | +| text0_0 | longtext | SIGNED | | YES | NULL | | | +| text0_1 | longtext | SIGNED | | YES | NULL | | | +| lang0 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability0 | FLOAT | SIGNED | | NO | 0 | | | +| em0_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em0_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em0_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em0_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em0_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em0_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text1_0 | longtext | SIGNED | | YES | NULL | | | +| text1_1 | longtext | SIGNED | | YES | NULL | | | +| lang1 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability1 | FLOAT | SIGNED | | NO | 0 | | | +| em1_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em1_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em1_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em1_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em1_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em1_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text2_0 | longtext | SIGNED | | YES | NULL | | | +| text2_1 | longtext | SIGNED | | YES | NULL | | | +| lang2 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability2 | FLOAT | SIGNED | | NO | 0 | | | +| em2_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em2_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em2_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em2_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em2_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em2_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text3_0 | longtext | SIGNED | | YES | NULL | | | +| text3_1 | longtext | SIGNED | | YES | NULL | | | +| lang3 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability3 | FLOAT | SIGNED | | NO | 0 | | | +| em3_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em3_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em3_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em3_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em3_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em3_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text4_0 | longtext | SIGNED | | YES | NULL | | | +| text4_1 | longtext | SIGNED | | YES | NULL | | | +| lang4 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability4 | FLOAT | SIGNED | | NO | 0 | | | +| em4_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em4_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em4_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em4_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em4_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em4_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text5_0 | longtext | SIGNED | | YES | NULL | | | +| text5_1 | longtext | SIGNED | | YES | NULL | | | +| lang5 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability5 | FLOAT | SIGNED | | NO | 0 | | | +| em5_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em5_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em5_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em5_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em5_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em5_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text6_0 | longtext | SIGNED | | YES | NULL | | | +| text6_1 | longtext | SIGNED | | YES | NULL | | | +| lang5 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability6 | FLOAT | SIGNED | | NO | 0 | | | +| em6_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em6_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em6_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em6_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em6_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em6_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| text7_0 | longtext | SIGNED | | YES | NULL | | | +| text7_1 | longtext | SIGNED | | YES | NULL | | | +| lang7 | TINYINT | UNSIGNED | | NO | 0 | | | +| Probability7 | FLOAT | SIGNED | | NO | 0 | | | +| em7_0 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em7_1 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em7_2 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em7_3 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em7_4 | SMALLINT | UNSIGNED | | NO | 0 | | | +| em7_5 | SMALLINT | UNSIGNED | | NO | 0 | | | +| VerifiedBuild | SMALLINT | SIGNED | | YES | 1 | | | **Field Descriptions** |