diff options
| -rw-r--r-- | sql/updates/auth/2013_10_16_00_auth_misc.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/2013_10_16_00_world_command.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2013_10_16_00_world_misc.sql (renamed from sql/updates/world/2013_10_16_00_world_creature_transport.sql) | 6 | ||||
| -rw-r--r-- | sql/updates/world/2013_10_16_00_world_transports.sql | 1 |
4 files changed, 9 insertions, 9 deletions
diff --git a/sql/updates/auth/2013_10_16_00_auth_misc.sql b/sql/updates/auth/2013_10_16_00_auth_misc.sql index cd7e8b3ae40..7b51d7a125f 100644 --- a/sql/updates/auth/2013_10_16_00_auth_misc.sql +++ b/sql/updates/auth/2013_10_16_00_auth_misc.sql @@ -5,7 +5,6 @@ DELETE FROM `rbac_permissions` WHERE `id`=@id; INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (@id, 'debug transport'); --- Add permissions to "corresponding Commands Role" -DELETE FROM `rbac_role_permissions` WHERE `permissionId`=@id; -INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES -(3, @id); +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, @id); diff --git a/sql/updates/world/2013_10_16_00_world_command.sql b/sql/updates/world/2013_10_16_00_world_command.sql deleted file mode 100644 index cabaad05920..00000000000 --- a/sql/updates/world/2013_10_16_00_world_command.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `command` WHERE `name` = 'debug transport'; - -INSERT INTO `command` (`name`, `permission`, `help`) VALUES -('debug transport', 400, 'Syntax: .debug transport [start/stop]\r\n\r\n Allows to stop a transport at its nearest wait point and start movement of a stopped one. Not all transports can be started or stopped.'), diff --git a/sql/updates/world/2013_10_16_00_world_creature_transport.sql b/sql/updates/world/2013_10_16_00_world_misc.sql index da91f976f8f..ee2e7795f98 100644 --- a/sql/updates/world/2013_10_16_00_world_creature_transport.sql +++ b/sql/updates/world/2013_10_16_00_world_misc.sql @@ -1,3 +1,9 @@ +ALTER TABLE `transports` DROP `period`; + +DELETE FROM `command` WHERE `name` = 'debug transport'; +INSERT INTO `command` (`name`, `permission`, `help`) VALUES +('debug transport', 400, 'Syntax: .debug transport [start/stop]\r\n\r\n Allows to stop a transport at its nearest wait point and start movement of a stopped one. Not all transports can be started or stopped.'); + DROP TABLE IF EXISTS `creature_transport`; SET @GUID := 142717; diff --git a/sql/updates/world/2013_10_16_00_world_transports.sql b/sql/updates/world/2013_10_16_00_world_transports.sql deleted file mode 100644 index 1173d381abc..00000000000 --- a/sql/updates/world/2013_10_16_00_world_transports.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `transports` DROP `period`; |