aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorDDuarte <dnpd.dd@gmail.com>2014-10-19 04:59:47 +0100
committerDDuarte <dnpd.dd@gmail.com>2014-10-19 04:59:47 +0100
commit98ca9a77491196ef501093572867236712d74938 (patch)
tree264cac69fb40633bbba12765e05d7b4735d6b887 /sql/updates/auth
parent79f5772d7af0809294b20d6ead8705ee3a5584cf (diff)
parent9e12b969c37e46db0929b488753b7ef1433c9c42 (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.sql24
-rw-r--r--sql/updates/auth/2014_10_18_00_auth.sql9
-rw-r--r--sql/updates/auth/2014_10_18_01_auth.sql23
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);