diff options
Diffstat (limited to 'sql/old')
3 files changed, 44 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_00_auth.sql b/sql/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_00_auth.sql new file mode 100644 index 00000000000..fbae94a4195 --- /dev/null +++ b/sql/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_00_auth.sql @@ -0,0 +1,9 @@ +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/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_01_auth.sql b/sql/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_01_auth.sql new file mode 100644 index 00000000000..60808b8a9c9 --- /dev/null +++ b/sql/old/3.3.5a/TDB56_to_TDB57_updates/auth/2014_10_18_01_auth.sql @@ -0,0 +1,23 @@ +/* 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); diff --git a/sql/old/3.3.5a/TDB56_to_TDB57_updates/characters/2014_10_18_00_characters.sql b/sql/old/3.3.5a/TDB56_to_TDB57_updates/characters/2014_10_18_00_characters.sql new file mode 100644 index 00000000000..36b2d042374 --- /dev/null +++ b/sql/old/3.3.5a/TDB56_to_TDB57_updates/characters/2014_10_18_00_characters.sql @@ -0,0 +1,12 @@ +DROP TABLE IF EXISTS `quest_tracker`; +CREATE TABLE `quest_tracker` ( + `id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `character_guid` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `quest_accept_time` DATETIME NOT NULL, + `quest_complete_time` DATETIME DEFAULT NULL, + `quest_abandon_time` DATETIME DEFAULT NULL, + `completed_by_gm` BOOL NOT NULL DEFAULT '0', + `core_hash` VARCHAR(120) NOT NULL DEFAULT '0', + `core_revision` VARCHAR(120) NOT NULL DEFAULT '0' +) +ENGINE=InnoDB; |