-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2015_11_08_00_auth.sql 
UPDATE `updates` SET `state`='ARCHIVED';
 
-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2015_11_21_00_auth.sql 
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;
 
-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2015_12_07_00_auth.sql 
UPDATE `battlenet_components` SET `Build`=20779 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20726;
 
-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2016_01_13_00_auth.sql 
UPDATE `battlenet_components` SET `Build`=20886 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20779;
 
-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2016_03_22_01_auth_2016_01_13_00_auth.sql 
--
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);
 
-- C:\Users\duart\Source\Repos\TrinityCore6x\sql\old\6.x\auth\03_2016_04_11\2016_03_28_00_auth.sql 
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;
 
