diff options
| author | ShinDarth <borzifrancesco@gmail.com> | 2015-10-11 12:06:59 +0200 |
|---|---|---|
| committer | Carbenium <carbenium@outlook.com> | 2015-11-03 16:07:30 +0100 |
| commit | 7ab1d1b7d060c7e9f5cc964d0f01113cb3200304 (patch) | |
| tree | 993bb248c74a6532e92b8ebe67dd4026a60ca7f8 /sql/updates | |
| parent | 700b5dcb491a4356df23c5013edc47e2a5194d1e (diff) | |
Core/Ticket improved ticket system
- Safely close ticket before character deletion
- Allow to keep trace of delete characters tickets (configurable)
- Closes #15655
Closes #15699
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/2015_11_03_00_characters.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/characters/2015_11_03_00_characters.sql b/sql/updates/characters/2015_11_03_00_characters.sql new file mode 100644 index 00000000000..b74824477be --- /dev/null +++ b/sql/updates/characters/2015_11_03_00_characters.sql @@ -0,0 +1,10 @@ +ALTER TABLE `gm_ticket` + ADD COLUMN `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted' AFTER `id`; + +UPDATE `gm_ticket` SET `type` = 1 WHERE `closedBy` != 0 OR `completed` != 0 OR `resolvedBy` != 0; +UPDATE `gm_ticket` SET `closedBy` = 0 WHERE `closedBy` < 0; +UPDATE `gm_ticket` SET `resolvedBy` = 0 WHERE `resolvedBy` < 0; + +ALTER TABLE `gm_ticket` + CHANGE COLUMN `closedBy` `closedBy` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `lastModifiedTime`, + CHANGE COLUMN `resolvedBy` `resolvedBy` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket' AFTER `needMoreHelp`; |