Comments/Description
SQL-files
Comment your script and set these comments in a single line above the part.
Right:
-- Trenton Lighthammer Gossip
DELETE FROM npc_gossip_textid WHERE
Wrong:
DELETE FROM npc_gossip_textid WHERE id = 1345; -- Trenton Lighthammer Gossip
Headers
Every SQL-file needs a header like this:
--
-- Tablestructure: creatur_names
--
Or:
/*
\* creature_names
\* Updating the Violet Hold npcs and setting the right faction
\*/
Table/Row Description
Every row needs a short description.
File naming
We use the following file naming: yyyymmdd-xx_description.sql. All files missing the file naming rules will be declined. This rule will only apply on official update files. If you are providing data in the as WIP you can ignore this rule.
Table naming
Seperate names with one underscore and use lower case.
Right:
CREATE TABLE event_names(
Wrong:
CREATE TABLE EventNames(
CREATE TABLE event__Names(
CREATE TABLE event_Names(
Building Groups
Create logical groups and use the most important name for the group.
Right:
creature_names
creature_spawns
creature_waypoints
...
Wrong:
creature_names
proto_creature
quest_finisher_creature
...
Column naming
Do NOT use lowerUppercase or any uppercase in your column naming! If you need to seperate words use underscore _
Right:
min_healt
max_health
Wrong:
minHealt
maxHealth