diff options
| author | Benjamin Jackson <38561765+heyitsbench@users.noreply.github.com> | 2023-01-08 17:39:07 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-01-08 23:39:07 +0100 |
| commit | 455534d7028482aa2df8a4999de77de54cd1f7ad (patch) | |
| tree | f271f8cde60078bf988c303f2b5193fee2095eb7 /docs | |
| parent | b9c48af6faca1d21b142235de48a4d7ef5a321fb (diff) | |
| download | wiki-455534d7028482aa2df8a4999de77de54cd1f7ad.tar.gz wiki-455534d7028482aa2df8a4999de77de54cd1f7ad.tar.bz2 wiki-455534d7028482aa2df8a4999de77de54cd1f7ad.zip | |
funny breaking change haha (#856)
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/sql-standards.md | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/docs/sql-standards.md b/docs/sql-standards.md index b97c76b..23823c5 100644 --- a/docs/sql-standards.md +++ b/docs/sql-standards.md @@ -162,6 +162,7 @@ UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`&~(6 For the most part, tables should be written in snake case, and columns should be written in upper camel case. Tables: + ``` broadcast_text creature_loot_template @@ -169,12 +170,31 @@ points_of_interest ``` Columns: + ``` MaleText QuestRequired PositionX ``` +In the case of column names with acronyms (e.g. GUID, ID, NPC, etc) the letters in the acronym should be uppercase. + +Wrong: + +``` +Itemguid +DisplayId +RequiredNpcOrGoCount +``` + +Correct: + +``` +ItemGUID +DisplayID +RequiredNPCOrGOCount +``` + ### Integers We do not define the width of an integer when we create new columns. (Width is deprecated in later versions of MySQL 8) |