diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2016-04-11 02:42:03 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2016-04-11 02:42:03 +0100 |
| commit | a1f59c9d8d9351bd4373e1e4355eee09369c589f (patch) | |
| tree | 367eb1eb8ad29763cabcf5c66f6958721e4e3337 /sql/updates/auth | |
| parent | 580773dc1a52cf6c8177647baf15afccd557be60 (diff) | |
TDB 6.04 - 2016/04/11TDB6.04
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/2015_11_21_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/2015_12_07_00_auth.sql | 1 | ||||
| -rw-r--r-- | sql/updates/auth/2016_01_13_00_auth.sql | 1 | ||||
| -rw-r--r-- | sql/updates/auth/2016_03_22_01_auth_2016_01_13_00_auth.sql | 6 | ||||
| -rw-r--r-- | sql/updates/auth/2016_03_28_00_auth.sql | 21 | ||||
| -rw-r--r-- | sql/updates/auth/2016_04_11_00_auth.sql (renamed from sql/updates/auth/2015_11_08_00_auth.sql) | 0 |
6 files changed, 0 insertions, 32 deletions
diff --git a/sql/updates/auth/2015_11_21_00_auth.sql b/sql/updates/auth/2015_11_21_00_auth.sql deleted file mode 100644 index 8f025e61242..00000000000 --- a/sql/updates/auth/2015_11_21_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `battlenet_components` SET `Build`=20726 WHERE `Program`='WoW' AND `Platform` IN ('base','Mc64','Win','Wn64') AND `Build`=20574; - -UPDATE `realmlist` SET `gamebuild`=20726 WHERE `gamebuild`=20574; diff --git a/sql/updates/auth/2015_12_07_00_auth.sql b/sql/updates/auth/2015_12_07_00_auth.sql deleted file mode 100644 index 6847e48a7e9..00000000000 --- a/sql/updates/auth/2015_12_07_00_auth.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `battlenet_components` SET `Build`=20779 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20726; diff --git a/sql/updates/auth/2016_01_13_00_auth.sql b/sql/updates/auth/2016_01_13_00_auth.sql deleted file mode 100644 index 7f1b2953750..00000000000 --- a/sql/updates/auth/2016_01_13_00_auth.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `battlenet_components` SET `Build`=20886 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20779; diff --git a/sql/updates/auth/2016_03_22_01_auth_2016_01_13_00_auth.sql b/sql/updates/auth/2016_03_22_01_auth_2016_01_13_00_auth.sql deleted file mode 100644 index c70d4c09468..00000000000 --- a/sql/updates/auth/2016_03_22_01_auth_2016_01_13_00_auth.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -DELETE FROM `rbac_permissions` WHERE `id`=836; -INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (836,"Command: .debug boundary"); - -DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=836; -INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196, 836); diff --git a/sql/updates/auth/2016_03_28_00_auth.sql b/sql/updates/auth/2016_03_28_00_auth.sql deleted file mode 100644 index 2adcb9bce4c..00000000000 --- a/sql/updates/auth/2016_03_28_00_auth.sql +++ /dev/null @@ -1,21 +0,0 @@ -DROP TABLE IF EXISTS `battlenet_components`; -DROP TABLE IF EXISTS `battlenet_modules`; - -DROP TABLE IF EXISTS `account_last_played_character`; -CREATE TABLE `account_last_played_character` ( - `accountId` int(10) unsigned NOT NULL, - `region` tinyint(3) unsigned NOT NULL, - `battlegroup` tinyint(3) unsigned NOT NULL, - `realmId` int(10) unsigned, - `characterName` varchar(12), - `characterGUID` bigint(20) unsigned, - `lastPlayedTime` int(10) unsigned, - PRIMARY KEY(`accountId`,`region`,`battlegroup`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; - -ALTER TABLE `battlenet_accounts` - DROP `s`, - DROP `v`, - DROP `sessionKey`; - -UPDATE `realmlist` SET `gamebuild`=21355 WHERE `gamebuild`=20726; diff --git a/sql/updates/auth/2015_11_08_00_auth.sql b/sql/updates/auth/2016_04_11_00_auth.sql index be8a4d21b66..be8a4d21b66 100644 --- a/sql/updates/auth/2015_11_08_00_auth.sql +++ b/sql/updates/auth/2016_04_11_00_auth.sql |