From 1effed82828826ff1a89a9d14dc0390ef6f0428a Mon Sep 17 00:00:00 2001 From: offl <11556157+offl@users.noreply.github.com> Date: Wed, 30 Mar 2022 18:48:02 +0300 Subject: CI/GitHub: Update basic guideline in issue form for SQL fixes --- .github/ISSUE_TEMPLATE/sql_fix.yml | 3 +++ 1 file changed, 3 insertions(+) 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 -- cgit v1.2.3