diff options
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_03_06_00_auth.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_03_08_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_06_23_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_08_30_00_auth.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_09_06_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_09_17_00_auth.sql | 6 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2018_12_30_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2019_03_19_00_auth.sql (renamed from sql/updates/auth/3.3.5/2018_02_19_00_auth.sql) | 2 |
8 files changed, 1 insertions, 37 deletions
diff --git a/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql b/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql deleted file mode 100644 index ddaf1d13f0c..00000000000 --- a/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `rbac_permissions` WHERE `id`=872; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(872, 'Command: server debug'); -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES -(196, 872); diff --git a/sql/updates/auth/3.3.5/2018_03_08_00_auth.sql b/sql/updates/auth/3.3.5/2018_03_08_00_auth.sql deleted file mode 100644 index 8b0e18b1e6c..00000000000 --- a/sql/updates/auth/3.3.5/2018_03_08_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `rbac_permissions` WHERE `id` = 873; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES -(873, 'Command: reload creature_movement_override'); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 873; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES -(196, 873); diff --git a/sql/updates/auth/3.3.5/2018_06_23_00_auth.sql b/sql/updates/auth/3.3.5/2018_06_23_00_auth.sql deleted file mode 100644 index 3bbe03f8c19..00000000000 --- a/sql/updates/auth/3.3.5/2018_06_23_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -DROP TABLE IF EXISTS `ip2nation`; -DROP TABLE IF EXISTS `ip2nationCountries`; diff --git a/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql b/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql deleted file mode 100644 index 1ee1f8d7ee4..00000000000 --- a/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql +++ /dev/null @@ -1,9 +0,0 @@ --- -DELETE FROM `rbac_permissions` WHERE `id`=874; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES -(874, "Command: go instance"); - -SET @parent := (SELECT `id` FROM `rbac_linked_permissions` WHERE `linkedId`=852); -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=874; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES -(@parent, 874); diff --git a/sql/updates/auth/3.3.5/2018_09_06_00_auth.sql b/sql/updates/auth/3.3.5/2018_09_06_00_auth.sql deleted file mode 100644 index 5a9718edcfb..00000000000 --- a/sql/updates/auth/3.3.5/2018_09_06_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- rbac simplify -DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (378,379,380,381,382,383,384,385,386,852,874); -DELETE FROM `rbac_permissions` WHERE `id` IN (378,379,380,381,382,383,384,385,386,852,874); diff --git a/sql/updates/auth/3.3.5/2018_09_17_00_auth.sql b/sql/updates/auth/3.3.5/2018_09_17_00_auth.sql deleted file mode 100644 index 7aa76283e57..00000000000 --- a/sql/updates/auth/3.3.5/2018_09_17_00_auth.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -DELETE FROM `rbac_permissions` WHERE `id`=852; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (852, 'Command: debug dummy'); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=852; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,852); diff --git a/sql/updates/auth/3.3.5/2018_12_30_00_auth.sql b/sql/updates/auth/3.3.5/2018_12_30_00_auth.sql deleted file mode 100644 index ba82aab6838..00000000000 --- a/sql/updates/auth/3.3.5/2018_12_30_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Port Trainer changes from master to 3.3.5 -DELETE FROM `rbac_permissions` WHERE `id`=672; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (672, 'Command: reload trainer'); diff --git a/sql/updates/auth/3.3.5/2018_02_19_00_auth.sql b/sql/updates/auth/3.3.5/2019_03_19_00_auth.sql index 78879b5db86..62715adcad9 100644 --- a/sql/updates/auth/3.3.5/2018_02_19_00_auth.sql +++ b/sql/updates/auth/3.3.5/2019_03_19_00_auth.sql @@ -1,2 +1,2 @@ --- TDB 335.64 auth +-- TDB 335.19031 auth UPDATE `updates` SET `state`='ARCHIVED'; |
