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.

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
 ...

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.