From 0ed049ef3b084beb74a1d74d946df77a53f9e3bb Mon Sep 17 00:00:00 2001 From: Benjamin Jackson <38561765+heyitsbench@users.noreply.github.com> Date: Sat, 31 Dec 2022 04:05:50 -0500 Subject: Update sql-standards.md (#851) --- docs/sql-standards.md | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) 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) -- cgit