diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 04:59:47 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 04:59:47 +0100 |
| commit | 98ca9a77491196ef501093572867236712d74938 (patch) | |
| tree | 264cac69fb40633bbba12765e05d7b4735d6b887 /sql/updates/auth | |
| parent | 79f5772d7af0809294b20d6ead8705ee3a5584cf (diff) | |
| parent | 9e12b969c37e46db0929b488753b7ef1433c9c42 (diff) | |
Merge remote-tracking branch 'origin/4.3.4' into 6.x
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/2014_10_13_00_auth_434.sql | 24 | ||||
| -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 |
3 files changed, 0 insertions, 56 deletions
diff --git a/sql/updates/auth/2014_10_13_00_auth_434.sql b/sql/updates/auth/2014_10_13_00_auth_434.sql deleted file mode 100644 index e7c984d70f6..00000000000 --- a/sql/updates/auth/2014_10_13_00_auth_434.sql +++ /dev/null @@ -1,24 +0,0 @@ -ALTER TABLE `battlenet_modules` - DROP PRIMARY KEY, - ADD PRIMARY KEY (`Name`, `System`); -DELETE FROM `battlenet_modules` WHERE `Name` IN ('ERRS','PFTY'); -INSERT INTO `battlenet_modules` (`Hash`,`Name`,`Type`,`System`,`Data`) VALUES -('cc654428261322763f4cada5b7f4b3b67660e85639bea916986b3f366fe8adc2', 'ERRS', 'xml', 'enGB', 'AA6C50D3'), -('2753d31092f1978bdd78ebd4fae2d189364ad7108ceb22fbf1413be1f43bef04', 'PFTY', 'pfty', 'zhCN', 'DF6C50D3'), -('5813f318f7e40a07a7cdfeeec9827942e6fdc5ccee0d4171148443e429ad0ead', 'PFTY', 'pfty', 'ruRU', 'DF6C50D3'), -('83663d54444eadad40d43725e59bde8eda10276e76fc3c4e6f2ca56332ee8f03', 'PFTY', 'pfty', 'enSG', 'DF6C50D3'), -('870f53d10b4e1b09d6b622cd5671ba4ff1ad69512dfa2c676072c52e45c7f0f9', 'PFTY', 'pfty', 'esES', 'DF6C50D3'), -('305bbdab1953e65974a249e276867e13ad2c3cabca3668983cb5ed406251bb7b', 'PFTY', 'pfty', 'frFR', 'DF6C50D3'), -('83663d54444eadad40d43725e59bde8eda10276e76fc3c4e6f2ca56332ee8f03', 'PFTY', 'pfty', 'enGB', 'DF6C50D3'), -('a2ec4b41148214037a2e89a2e557af716d085241b81f5244494bdc77a891ca38', 'PFTY', 'pfty', 'csCZ', 'DF6C50D3'), -('a8c77051991b1a6c5dfe412e9f46d8f584349996fbde37c4f2a527c192163502', 'PFTY', 'pfty', 'plPL', 'DF6C50D3'), -('83663d54444eadad40d43725e59bde8eda10276e76fc3c4e6f2ca56332ee8f03', 'PFTY', 'pfty', 'enUS', 'DF6C50D3'), -('7466b2db3f03768aa2527535d4b3c6c9ef9e8fb07c6db88b1019f3d25a2942e8', 'PFTY', 'pfty', 'koKR', 'DF6C50D3'), -('a2ec4b41148214037a2e89a2e557af716d085241b81f5244494bdc77a891ca38', 'PFTY', 'pfty', 'jaJP', 'DF6C50D3'), -('3e381d4f83201f4e3c482eb74da12e5ff9dd924da2413d8fb33f5eea9a02c2c2', 'PFTY', 'pfty', 'zhTW', 'DF6C50D3'), -('83663d54444eadad40d43725e59bde8eda10276e76fc3c4e6f2ca56332ee8f03', 'PFTY', 'pfty', 'enTH', 'DF6C50D3'), -('b72e65b6b34d8f859e79b5f28952e26553a796d5e1d75c2b5930bc0daeaa728c', 'PFTY', 'pfty', 'itIT', 'DF6C50D3'), -('e8b82becbe0a0a1bbb5561df69320edbd770897a8deaab23caa6736255e0dc33', 'PFTY', 'pfty', 'esMX', 'DF6C50D3'), -('83663d54444eadad40d43725e59bde8eda10276e76fc3c4e6f2ca56332ee8f03', 'PFTY', 'pfty', 'enAU', 'DF6C50D3'), -('0a3f6f3f0535ea21dbe620085192afc796203047e270e0e1b76f15a739fe1797', 'PFTY', 'pfty', 'ptBR', 'DF6C50D3'), -('047329d08d433da2622e9fc2ee96c8dd8f35e7770699d07cf74855b9c8ea9125', 'PFTY', 'pfty', 'deDE', 'DF6C50D3'); 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); |
