diff options
| author | offl <11556157+offl@users.noreply.github.com> | 2022-03-30 18:48:02 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-03-30 18:48:02 +0300 |
| commit | 1effed82828826ff1a89a9d14dc0390ef6f0428a (patch) | |
| tree | 3b20411a2af143651bea004c95435218f9a5c00a /.github | |
| parent | 4b99e026bab4d77997fd4bcf42ee2f448e898272 (diff) | |
CI/GitHub: Update basic guideline in issue form for SQL fixes
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 |