diff options
| author | joschiwald <joschiwald.trinity@gmail.com> | 2017-12-31 00:10:25 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-12-31 00:13:42 +0100 |
| commit | 97c7e32a42d4041b4d74e1d6bf951ed2f6161661 (patch) | |
| tree | c6bf114594f4123118e10c9f3bc566eeffe404c4 | |
| parent | dc294731208991bf0b6b4ab2ff7ad02ac13cc862 (diff) | |
SQL: Fixed typo
| -rw-r--r-- | sql/base/auth_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/master/2017_12_30_01_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/world/master/2017_12_30_03_world.sql | 1 |
3 files changed, 6 insertions, 4 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index cfa763b152d..1fd7696bdc7 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -2225,7 +2225,7 @@ INSERT INTO `updates` VALUES ('2017_09_22_00_auth.sql','9313CCE80A18212E6F0C78D83316DE8582AE8084','RELEASED','2017-09-22 18:05:17',0), ('2017_11_11_01_auth.sql','0D6EDB6B2FC8B9FBDF11ECD79B4B8E943328B6A9','RELEASED','2017-11-11 18:49:45',0), ('2017_12_30_00_auth.sql','F360E9555AC68E28834E3FF807E4E37A090EF363','RELEASED','2017-12-30 00:23:32',0), -('2017_12_30_01_auth.sql','41E2EA9D7A3B9C7DF0E694CD56C3E3F710A54DCD','RELEASED','2017-12-30 23:00:00',0); +('2017_12_30_01_auth.sql','1E11C78BA6D1D8E8CED7423DF92D1D197D6061EE','RELEASED','2017-12-30 23:00:00',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2017_12_30_01_auth.sql b/sql/updates/auth/master/2017_12_30_01_auth.sql index d9e1e32f103..b1c9a297968 100644 --- a/sql/updates/auth/master/2017_12_30_01_auth.sql +++ b/sql/updates/auth/master/2017_12_30_01_auth.sql @@ -2,9 +2,10 @@ DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=867; DELETE FROM `rbac_permissions` WHERE `id`=867; -- +DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=868; DELETE FROM `rbac_permissions` WHERE `id`=868; INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(867, 'Command: modify power'); +(868, 'Command: modify power'); -DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=868; -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 867); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(198, 868); diff --git a/sql/updates/world/master/2017_12_30_03_world.sql b/sql/updates/world/master/2017_12_30_03_world.sql new file mode 100644 index 00000000000..1d7be946705 --- /dev/null +++ b/sql/updates/world/master/2017_12_30_03_world.sql @@ -0,0 +1 @@ +UPDATE `command` SET `permission`=868 WHERE `name`='modify power'; |