diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 03:40:47 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 03:40:47 +0100 |
| commit | 5474ed1882584d58e6031d78bcbd0a4f29a04862 (patch) | |
| tree | 4b34f55e63dec293c222304d143d755232a696d1 /sql/updates/auth | |
| parent | 54629368967b1c5fcb1d423801151bc4ce8ce1f2 (diff) | |
TDB 335.57 - 2014/10/20TDB335.57
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/2014_10_18_00_auth.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/2014_10_18_01_auth.sql | 23 |
2 files changed, 0 insertions, 32 deletions
diff --git a/sql/updates/auth/2014_10_18_00_auth.sql b/sql/updates/auth/2014_10_18_00_auth.sql deleted file mode 100644 index fbae94a4195..00000000000 --- a/sql/updates/auth/2014_10_18_00_auth.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `rbac_permissions` WHERE `id` IN (795, 796); -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(795, 'Command: .instance setbossstate'), -(796, 'Command: .instance getbossstate'); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (795, 796); -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES -(192, 795), -(192, 796); diff --git a/sql/updates/auth/2014_10_18_01_auth.sql b/sql/updates/auth/2014_10_18_01_auth.sql deleted file mode 100644 index 60808b8a9c9..00000000000 --- a/sql/updates/auth/2014_10_18_01_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -/* drop then create account_muted table */ -DROP TABLE IF EXISTS `account_muted`; - -CREATE TABLE `account_muted` ( - `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `mutedate` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `mutetime` INT(10) UNSIGNED NOT NULL DEFAULT '0', - `mutedby` VARCHAR(50) NOT NULL, - `mutereason` VARCHAR(255) NOT NULL, - PRIMARY KEY (`guid`, `mutedate`) -) -COMMENT='mute List' ENGINE=InnoDB; - -/* add rbac permissions to new commands */ -DELETE FROM `rbac_permissions` WHERE `id`=632; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES -(632, 'Command: .mutehistory'); - -/* adds qc to players */ -DELETE FROM `rbac_linked_permissions` WHERE `id`=632; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES -/* add mutehistory to gms */ -(194, 632); |
