aboutsummaryrefslogtreecommitdiff
path: root/.github/ISSUE_TEMPLATE
diff options
context:
space:
mode:
authoroffl <11556157+offl@users.noreply.github.com>2022-03-30 18:48:02 +0300
committerGitHub <noreply@github.com>2022-03-30 18:48:02 +0300
commit1effed82828826ff1a89a9d14dc0390ef6f0428a (patch)
tree3b20411a2af143651bea004c95435218f9a5c00a /.github/ISSUE_TEMPLATE
parent4b99e026bab4d77997fd4bcf42ee2f448e898272 (diff)
CI/GitHub: Update basic guideline in issue form for SQL fixes
Diffstat (limited to '.github/ISSUE_TEMPLATE')
-rw-r--r--.github/ISSUE_TEMPLATE/sql_fix.yml3
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