diff options
| author | Benjamin Jackson <38561765+heyitsbench@users.noreply.github.com> | 2022-12-31 04:05:50 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-12-31 10:05:50 +0100 |
| commit | 0ed049ef3b084beb74a1d74d946df77a53f9e3bb (patch) | |
| tree | 67a1e0643a40f05468fb5c7e89f380510ad5b0af /docs | |
| parent | 4b2781737ab0e256758731d50a2341f42a7f77f3 (diff) | |
| download | wiki-0ed049ef3b084beb74a1d74d946df77a53f9e3bb.tar.gz wiki-0ed049ef3b084beb74a1d74d946df77a53f9e3bb.tar.bz2 wiki-0ed049ef3b084beb74a1d74d946df77a53f9e3bb.zip | |
Update sql-standards.md (#851)
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/sql-standards.md | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/docs/sql-standards.md b/docs/sql-standards.md index 59443cb..42e24a2 100644 --- a/docs/sql-standards.md +++ b/docs/sql-standards.md @@ -142,6 +142,24 @@ UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`&~(6 ## Tables and Columns +### Naming of tables and columns + +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 +points_of_interest +``` + +Columns: +``` +MaleText +QuestRequired +PositionX +``` + ### Integers We do not define the width of an integer when we create new columns. (Width is deprecated in later versions of MySQL 8) |