diff options
Diffstat (limited to '.github')
| -rw-r--r-- | .github/ISSUE_TEMPLATE/sql_fix.yml | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/.github/ISSUE_TEMPLATE/sql_fix.yml b/.github/ISSUE_TEMPLATE/sql_fix.yml index 2bc824e6fe2..e0685ed8bae 100644 --- a/.github/ISSUE_TEMPLATE/sql_fix.yml +++ b/.github/ISSUE_TEMPLATE/sql_fix.yml @@ -16,6 +16,9 @@ body: - don't use ' around numbers - don't use ( ) if they aren't needed - use only one INSERT INTO statement when you add multiple rows to one table, unless you are scripting multiple creatures + - always add every row you insert below INSERT INTO statement + - always use capital letters for all keywords (DELETE, FROM, SELECT, WHERE, IN, etc.) + - always use backticks for every column and table name - always include column names in every INSERT INTO statement - always make every INSERT INTO statement runnable twice (delete what you insert even if row does not exist, don't use REPLACE INTO) - DELETE by guid AND id to be sure we don't delete existing spawns |