diff options
Diffstat (limited to 'sql/old/6.x/auth')
26 files changed, 154 insertions, 0 deletions
diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_04_11_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_04_11_00_auth.sql new file mode 100644 index 00000000000..be8a4d21b66 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_04_11_00_auth.sql @@ -0,0 +1 @@ +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_04_17_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_04_17_00_auth.sql new file mode 100644 index 00000000000..52ba3a0038e --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_04_17_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=21463 WHERE `gamebuild`=21355; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '21463'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_05_07_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_05_07_00_auth.sql new file mode 100644 index 00000000000..48f9cbd8fe2 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_05_07_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `rbac_permissions` SET `name`='Command: disable add criteria' WHERE `id`=350; +UPDATE `rbac_permissions` SET `name`='Command: disable remove criteria' WHERE `id`=359; +UPDATE `rbac_permissions` SET `name`='Command: reload criteria_data' WHERE `id`=609; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_05_19_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_05_19_00_auth.sql new file mode 100644 index 00000000000..0b584bd4d7b --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_05_19_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=21742 WHERE `gamebuild`=21463; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '21742'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_07_19_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_07_19_00_auth.sql new file mode 100644 index 00000000000..5cbb737f518 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_07_19_00_auth.sql @@ -0,0 +1,22 @@ +-- +-- Table structure for table `battlenet_item_appearances` +-- +DROP TABLE IF EXISTS `battlenet_item_appearances`; +CREATE TABLE `battlenet_item_appearances` ( + `battlenetAccountId` int(10) unsigned NOT NULL, + `blobIndex` smallint(5) unsigned NOT NULL, + `appearanceMask` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`battlenetAccountId`,`blobIndex`), + CONSTRAINT `fk_battlenet_item_appearances` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `battlenet_item_favorite_appearances` +-- +DROP TABLE IF EXISTS `battlenet_item_favorite_appearances`; +CREATE TABLE `battlenet_item_favorite_appearances` ( + `battlenetAccountId` int(10) unsigned NOT NULL, + `itemModifiedAppearanceId` int(10) unsigned NOT NULL, + PRIMARY KEY (`battlenetAccountId`,`itemModifiedAppearanceId`), + CONSTRAINT `fk_battlenet_item_favorite_appearances` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_07_19_01_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_07_19_01_auth.sql new file mode 100644 index 00000000000..854872a48d0 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_07_19_01_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22248 WHERE `gamebuild`=21742; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22248'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_07_23_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_07_23_00_auth.sql new file mode 100644 index 00000000000..b3024cfa479 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_07_23_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22293 WHERE `gamebuild`=22248; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22293'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_07_23_01_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_07_23_01_auth.sql new file mode 100644 index 00000000000..4ac99acee21 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_07_23_01_auth.sql @@ -0,0 +1,7 @@ +DELETE FROM `rbac_permissions` WHERE `id`= 12; +INSERT INTO `rbac_permissions` (`id`,`name`) VALUES +(12,'Skip character creation demon hunter min level check'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`= 12; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(194, 12); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_07_30_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_07_30_00_auth.sql new file mode 100644 index 00000000000..5b81f14f1b5 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_07_30_00_auth.sql @@ -0,0 +1,14 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (662,664,692); +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (662,664,692); + +DELETE FROM `rbac_permissions` WHERE `id` IN (837,838,839); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(837, 'Command: reload character_template'), +(838, 'Command: reload quest_greeting'), +(839, 'Command: debug send playscene'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (837,838,839); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, 837), +(196, 838), +(192, 839); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_07_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_07_00_auth.sql new file mode 100644 index 00000000000..30c5b111bda --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_07_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22345 WHERE `gamebuild`=22293; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22345'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_11_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_11_00_auth.sql new file mode 100644 index 00000000000..e4450d9f449 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_11_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22410 WHERE `gamebuild`=22345; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22410'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_13_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_13_00_auth.sql new file mode 100644 index 00000000000..fe3b4138332 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_13_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22423 WHERE `gamebuild`=22410; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22423'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_26_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_26_00_auth.sql new file mode 100644 index 00000000000..36485d9e775 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_26_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22498 WHERE `gamebuild`=22423; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22498'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_27_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_27_00_auth.sql new file mode 100644 index 00000000000..0f009864244 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_27_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22522 WHERE `gamebuild`=22498; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22522'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_08_30_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_08_30_00_auth.sql new file mode 100644 index 00000000000..eec93895bc0 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_08_30_00_auth.sql @@ -0,0 +1,3 @@ +ALTER TABLE `account` CHANGE `expansion` `expansion` tinyint(3) unsigned NOT NULL DEFAULT '6' AFTER `online`; + +UPDATE `account` SET `expansion`=6; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_02_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_02_00_auth.sql new file mode 100644 index 00000000000..75e474f10df --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_02_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22566 WHERE `gamebuild`=22522; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22566'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_03_00_auth_2016_05_11_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_00_auth_2016_05_11_00_auth.sql new file mode 100644 index 00000000000..d1a6f3e6023 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_00_auth_2016_05_11_00_auth.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `rbac_permissions` WHERE `id` IN (837,838,839,840); +INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (837,"Command: npc evade"), (838,"Command: pet level"), (839,"Command: server shutdown force"), (840,"Command: server restart force"); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (837,838,839,840); +INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,837),(196,838),(196,839),(196,840); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_03_01_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_01_auth.sql new file mode 100644 index 00000000000..5092f093bfb --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_01_auth.sql @@ -0,0 +1,11 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (841,842,843); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(841, 'Command: reload character_template'), +(842, 'Command: reload quest_greeting'), +(843, 'Command: debug send playscene'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (841,842,843); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, 841), +(196, 842), +(192, 843); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_03_02_auth_2016_06_06_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_02_auth_2016_06_06_00_auth.sql new file mode 100644 index 00000000000..0e203d847ae --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_02_auth_2016_06_06_00_auth.sql @@ -0,0 +1,5 @@ +DELETE FROM `rbac_permissions` WHERE `id` = 841; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (841, 'Command: .debug neargraveyard'); + +DELETE FROM `rbac_linked_permissions` WHERE `id` = 196 AND `linkedId` = 841; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (196, 841); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_03_03_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_03_auth.sql new file mode 100644 index 00000000000..2d680b0ffe6 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_03_03_auth.sql @@ -0,0 +1,11 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (842,843,844); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(842, 'Command: reload character_template'), +(843, 'Command: reload quest_greeting'), +(844, 'Command: debug send playscene'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (841,842,843); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(196, 842), +(196, 843), +(192, 844); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_15_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_15_00_auth.sql new file mode 100644 index 00000000000..8b0f5f76c1c --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_15_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22594 WHERE `gamebuild`=22566; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22594'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_21_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_21_00_auth.sql new file mode 100644 index 00000000000..c0b0a3a00f3 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_21_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22624 WHERE `gamebuild`=22594; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22624'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_09_25_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_09_25_00_auth.sql new file mode 100644 index 00000000000..0720f6b6964 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_09_25_00_auth.sql @@ -0,0 +1,19 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (844, 845, 846, 847, 848, 849, 850); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(844, 'Command: scene'), +(845, 'Command: scene debug'), +(846, 'Command: scene play'), +(847, 'Command: scene play package'), +(848, 'Command: scene cancel'), +(849, 'Command: list scenes'), +(850, 'Command: reload scenes'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (844, 845, 846, 847, 848, 849, 850); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(192, 844), +(192, 845), +(192, 846), +(192, 847), +(192, 848), +(192, 849), +(192, 850); diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_10_01_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_10_01_00_auth.sql new file mode 100644 index 00000000000..de3ddcc1d2c --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_10_01_00_auth.sql @@ -0,0 +1,10 @@ +-- +-- Table structure for table `battlenet_account_mounts` +-- +DROP TABLE IF EXISTS `battlenet_account_mounts`; +CREATE TABLE `battlenet_account_mounts` ( + `battlenetAccountId` int(10) unsigned NOT NULL, + `mountSpellId` int(10) unsigned NOT NULL, + `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`battlenetAccountId`,`mountSpellId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_10_06_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_10_06_00_auth.sql new file mode 100644 index 00000000000..b791f67e6cc --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_10_06_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22747 WHERE `gamebuild`=22624; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22624'; diff --git a/sql/old/6.x/auth/04_2016_10_17/2016_10_12_00_auth.sql b/sql/old/6.x/auth/04_2016_10_17/2016_10_12_00_auth.sql new file mode 100644 index 00000000000..0b07236a068 --- /dev/null +++ b/sql/old/6.x/auth/04_2016_10_17/2016_10_12_00_auth.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=22810 WHERE `gamebuild`=22747; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '22810'; |