diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/2015_03_10_00_auth.sql | 77 | ||||
| -rw-r--r-- | sql/updates/characters/2015_03_10_00_characters.sql | 95 | ||||
| -rw-r--r-- | sql/updates/world/2015_03_10_00_world.sql | 36 |
3 files changed, 208 insertions, 0 deletions
diff --git a/sql/updates/auth/2015_03_10_00_auth.sql b/sql/updates/auth/2015_03_10_00_auth.sql new file mode 100644 index 00000000000..3206edcbd8d --- /dev/null +++ b/sql/updates/auth/2015_03_10_00_auth.sql @@ -0,0 +1,77 @@ +UPDATE `rbac_permissions` SET `name`='Command: reload support' WHERE `id`=650; + +DELETE FROM `rbac_permissions` WHERE `id` IN (799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(799, 'Command: .go bugticket'), +(800, 'Command: .go complaintticket'), +(801, 'Command: .go suggestionticket'), +(802, 'Command: .ticket bug'), +(803, 'Command: .ticket complaint'), +(804, 'Command: .ticket suggestion'), +(805, 'Command: .ticket bug assign'), +(806, 'Command: .ticket bug close'), +(807, 'Command: .ticket bug closedlist'), +(808, 'Command: .ticket bug comment'), +(809, 'Command: .ticket bug delete'), +(810, 'Command: .ticket bug list'), +(811, 'Command: .ticket bug unassign'), +(812, 'Command: .ticket bug view'), +(813, 'Command: .ticket complaint assign'), +(814, 'Command: .ticket complaint close'), +(815, 'Command: .ticket complaint closedlist'), +(816, 'Command: .ticket complaint comment'), +(817, 'Command: .ticket complaint delete'), +(818, 'Command: .ticket complaint list'), +(819, 'Command: .ticket complaint unassign'), +(820, 'Command: .ticket complaint view'), +(821, 'Command: .ticket suggestion assign'), +(822, 'Command: .ticket suggestion close'), +(823, 'Command: .ticket suggestion closedlist'), +(824, 'Command: .ticket suggestion comment'), +(825, 'Command: .ticket suggestion delete'), +(826, 'Command: .ticket suggestion list'), +(827, 'Command: .ticket suggestion unassign'), +(828, 'Command: .ticket suggestion view'), +(829, 'Command: .ticket reset all'), +(830, 'Command: .ticket reset gm'), +(831, 'Command: .ticket reset bug'), +(832, 'Command: .ticket reset complaint'), +(833, 'Command: .ticket reset suggestion'); + +DELETE FROM `rbac_linked_permissions` WHERE `id` = 198 AND `linkedId` IN (799,800,801,892,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(198, 799), +(198, 800), +(198, 801), +(198, 802), +(198, 803), +(198, 804), +(197, 805), +(198, 806), +(198, 807), +(198, 808), +(196, 809), +(198, 810), +(197, 811), +(198, 812), +(197, 813), +(198, 814), +(198, 815), +(198, 816), +(196, 817), +(198, 818), +(197, 819), +(198, 820), +(197, 821), +(198, 822), +(198, 823), +(198, 824), +(196, 825), +(198, 826), +(197, 827), +(198, 828), +(196, 829), +(196, 830), +(196, 831), +(196, 832), +(196, 833); diff --git a/sql/updates/characters/2015_03_10_00_characters.sql b/sql/updates/characters/2015_03_10_00_characters.sql new file mode 100644 index 00000000000..ce55b3b35cc --- /dev/null +++ b/sql/updates/characters/2015_03_10_00_characters.sql @@ -0,0 +1,95 @@ +DROP TABLE IF EXISTS `lag_reports`; + +ALTER TABLE `gm_surveys` + RENAME TO `gm_survey`, + CHANGE COLUMN `overallComment` `comment` LONGTEXT NOT NULL AFTER `mainSurvey`; + +ALTER TABLE `gm_subsurveys` + RENAME TO `gm_subsurvey`, + CHANGE COLUMN `subsurveyId` `questionId` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `surveyId`, + CHANGE COLUMN `rank` `answer` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `questionId`, + CHANGE COLUMN `comment` `answerComment` TEXT NOT NULL AFTER `answer`; + + +ALTER TABLE `gm_tickets` + RENAME TO `gm_ticket`, + CHANGE COLUMN `ticketId` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, + CHANGE COLUMN `guid` `playerGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator' AFTER `id`, + CHANGE COLUMN `message` `description` TEXT NOT NULL AFTER `playerGuid`, + CHANGE COLUMN `haveTicket` `needMoreHelp` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `viewed`, + DROP COLUMN `name`; + +DROP TABLE IF EXISTS `gm_bug`; +CREATE TABLE `gm_bug` ( + `id` INT(10) UNSIGNED NOT NULL, + `playerGuid` BIGINT(20) UNSIGNED NOT NULL, + `note` TEXT NOT NULL, + `createTime` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `mapId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `posX` FLOAT NOT NULL DEFAULT '0', + `posY` FLOAT NOT NULL DEFAULT '0', + `posZ` FLOAT NOT NULL DEFAULT '0', + `facing` FLOAT NOT NULL DEFAULT '0', + `closedBy` BIGINT(20) NOT NULL DEFAULT '0', + `assignedTo` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` TEXT NOT NULL, + PRIMARY KEY (`id`) +) +COLLATE='utf8_general_ci' +ENGINE=InnoDB +; + +DROP TABLE IF EXISTS `gm_complaint`; +CREATE TABLE `gm_complaint` ( + `id` INT(10) UNSIGNED NOT NULL, + `playerGuid` BIGINT(20) UNSIGNED NOT NULL, + `note` TEXT NOT NULL, + `createTime` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `mapId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `posX` FLOAT NOT NULL DEFAULT '0', + `posY` FLOAT NOT NULL DEFAULT '0', + `posZ` FLOAT NOT NULL DEFAULT '0', + `facing` FLOAT NOT NULL DEFAULT '0', + `targetCharacterGuid` BIGINT(20) UNSIGNED NOT NULL, + `complaintType` SMALLINT(5) UNSIGNED NOT NULL, + `reportLineIndex` INT(10) NOT NULL, + `closedBy` BIGINT(20) NOT NULL DEFAULT '0', + `assignedTo` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` TEXT NOT NULL, + PRIMARY KEY (`id`) +) +COLLATE='utf8_general_ci' +ENGINE=InnoDB +; + +DROP TABLE IF EXISTS `gm_complaint_chatlog`; +CREATE TABLE `gm_complaint_chatlog` ( + `complaintId` INT(10) UNSIGNED NOT NULL, + `lineId` INT(10) UNSIGNED NOT NULL, + `timestamp` INT(10) UNSIGNED NOT NULL, + `text` TEXT NOT NULL, + PRIMARY KEY (`complaintId`, `lineId`) +) +COLLATE='utf8_general_ci' +ENGINE=InnoDB +; + +DROP TABLE IF EXISTS `gm_suggestion`; +CREATE TABLE `gm_suggestion` ( + `id` INT(10) UNSIGNED NOT NULL, + `playerGuid` BIGINT(20) UNSIGNED NOT NULL, + `note` TEXT NOT NULL, + `createTime` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `mapId` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', + `posX` FLOAT NOT NULL DEFAULT '0', + `posY` FLOAT NOT NULL DEFAULT '0', + `posZ` FLOAT NOT NULL DEFAULT '0', + `facing` FLOAT NOT NULL DEFAULT '0', + `closedBy` BIGINT(20) NOT NULL DEFAULT '0', + `assignedTo` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` TEXT NOT NULL, + PRIMARY KEY (`id`) +) +COLLATE='utf8_general_ci' +ENGINE=InnoDB +; diff --git a/sql/updates/world/2015_03_10_00_world.sql b/sql/updates/world/2015_03_10_00_world.sql new file mode 100644 index 00000000000..befd7f94145 --- /dev/null +++ b/sql/updates/world/2015_03_10_00_world.sql @@ -0,0 +1,36 @@ +DELETE FROM `trinity_string` WHERE `entry` = 1190; +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (1190, 'Ticket system is disabled. You can\'t change its status.'); + +UPDATE `command` SET `name`='reload support', `help`='Syntax: .reload support\r\nReload support system tables.' WHERE `name`='reload gm_tickets'; + +DELETE FROM `command` WHERE `name` IN ('ticket bug assign', 'ticket bug close', 'ticket bug closedlist', 'ticket bug comment', 'ticket bug delete', 'ticket bug list', 'ticket bug unassign', 'ticket bug view', 'ticket complaint assign', 'ticket complaint close', 'ticket complaint closedlist', 'ticket complaint comment', 'ticket complaint delete', 'ticket complaint list', 'ticket complaint unassign', 'ticket complaint view', 'ticket suggestion assign', 'ticket suggestion close', 'ticket suggestion closedlist', 'ticket suggestion comment', 'ticket suggestion delete', 'ticket suggestion list', 'ticket suggestion unassign', 'ticket suggestion view', 'ticket reset all', 'ticket reset gm', 'ticket reset bug', 'ticket reset complaint', 'ticket reset suggestion'); +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('ticket bug assign', 805, 'Usage: .ticket bug assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'), +('ticket bug close', 806, 'Usage: .ticket bug close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'), +('ticket bug closedlist', 807, 'Usage: Displays a list of closed bug tickets.'), +('ticket bug comment', 808, 'Usage: .ticket bug comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'), +('ticket bug delete', 809, 'Usage: .ticket bug delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'), +('ticket bug list', 810, 'Usage: Displays a list of open bug tickets.'), +('ticket bug unassign', 811, 'Usage: .ticket bug unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'), +('ticket bug view', 812, 'Usage: .ticket bug view $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'), +('ticket complaint assign', 813, 'Usage: .ticket complaint assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.'), +('ticket complaint close', 814, 'Usage: .ticket complaint close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'), +('ticket complaint closedlist', 815, 'Usage: Displays a list of closed complaint tickets.'), +('ticket complaint comment', 816, 'Usage: .ticket complaint comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'), +('ticket complaint delete', 817, 'Usage: .ticket complaint delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'), +('ticket complaint list', 818, 'Usage: Displays a list of open complaint tickets.'), +('ticket complaint unassign', 819, 'Usage: .ticket complaint unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'), +('ticket complaint view', 820, 'Usage: .ticket complaint view $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'), +('ticket suggestion assign', 821, 'Usage: .ticket suggestion assign $ticketid $gmname.Assigns the specified ticket to the specified Game Master.'), +('ticket suggestion close', 822, 'Usage: .ticket suggestion close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.'), +('ticket suggestion closedlist', 823, 'Usage: Displays a list of closed suggestion tickets.'), +('ticket suggestion comment', 824, 'Usage: .ticket suggestion comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.'), +('ticket suggestion delete', 825, 'Usage: .ticket suggestion delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.'), +('ticket suggestion list', 826, 'Usage: Displays a list of open suggestion tickets.'), +('ticket suggestion unassign', 827, 'Usage: .ticket suggestion unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.'), +('ticket suggestion view', 828, 'Usage: .ticket suggestion view $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.'), +('ticket reset all', 829, 'Usage: Removes all closed tickets and resets the counter, if no pending open tickets exist.'), +('ticket reset gm', 830, 'Usage: Removes all closed GM tickets and resets the counter, if no pending open tickets exist.'), +('ticket reset bug', 831, 'Usage: Removes all closed bug tickets and resets the counter, if no pending open tickets exist.'), +('ticket reset complaint', 832, 'Usage: Removes all closed complaint tickets and resets the counter, if no pending open tickets exist.'), +('ticket reset suggestion', 833, 'Usage: Removes all closed suggestion tickets and resets the counter, if no pending open tickets exist.'); |