aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/2015_03_15_00_auth.sql12
-rw-r--r--sql/updates/auth/2015_03_26_00_auth.sql4
-rw-r--r--sql/updates/auth/2015_04_04_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_04_06_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_04_08_00_auth.sql5
-rw-r--r--sql/updates/auth/2015_04_10_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_04_11_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_04_11_01_auth.sql1
-rw-r--r--sql/updates/auth/2015_04_21_00_auth.sql9
-rw-r--r--sql/updates/auth/2015_05_02_00_auth.sql7
-rw-r--r--sql/updates/auth/2015_05_02_01_auth.sql9
-rw-r--r--sql/updates/auth/2015_07_02_00_auth.sql3
-rw-r--r--sql/updates/auth/2015_07_06_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_07_08_00_auth.sql1
-rw-r--r--sql/updates/auth/2015_07_08_01_auth.sql1
-rw-r--r--sql/updates/auth/dummy0
16 files changed, 0 insertions, 57 deletions
diff --git a/sql/updates/auth/2015_03_15_00_auth.sql b/sql/updates/auth/2015_03_15_00_auth.sql
deleted file mode 100644
index 339524a5091..00000000000
--- a/sql/updates/auth/2015_03_15_00_auth.sql
+++ /dev/null
@@ -1,12 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=776;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (776, 'Command: debug phase');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`=192 AND linkedId=776;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 776);
-
-DELETE FROM `rbac_permissions` WHERE `id`=776;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (776, 'Command: debug phase');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`=192 AND linkedId=776;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 776);
-
diff --git a/sql/updates/auth/2015_03_26_00_auth.sql b/sql/updates/auth/2015_03_26_00_auth.sql
deleted file mode 100644
index af1ffba9a0b..00000000000
--- a/sql/updates/auth/2015_03_26_00_auth.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=19793 WHERE `id`=1;
-
-UPDATE `battlenet_components` SET `Build`=19793 WHERE `Program`='WoW' AND `Platform`='base' AND `Build`=19634;
-UPDATE `battlenet_components` SET `Build`=19802 WHERE `Program`='WoW' AND `Platform` IN ('Win','Wn64','Mc64') AND `Build`=19702;
diff --git a/sql/updates/auth/2015_04_04_00_auth.sql b/sql/updates/auth/2015_04_04_00_auth.sql
deleted file mode 100644
index fd6a887b876..00000000000
--- a/sql/updates/auth/2015_04_04_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=19831 WHERE `Program`='WoW' AND `Platform` IN ('Win','Wn64','Mc64') AND `Build`=19802;
diff --git a/sql/updates/auth/2015_04_06_00_auth.sql b/sql/updates/auth/2015_04_06_00_auth.sql
deleted file mode 100644
index d5e11c4fd00..00000000000
--- a/sql/updates/auth/2015_04_06_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=19865 WHERE `Program`='WoW' AND `Platform` IN ('Win','Wn64','Mc64') AND `Build`=19831;
diff --git a/sql/updates/auth/2015_04_08_00_auth.sql b/sql/updates/auth/2015_04_08_00_auth.sql
deleted file mode 100644
index 30f79d8f2a5..00000000000
--- a/sql/updates/auth/2015_04_08_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=692;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (692, 'Command: debug send playscene');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`=192 AND linkedId=692;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 692);
diff --git a/sql/updates/auth/2015_04_10_00_auth.sql b/sql/updates/auth/2015_04_10_00_auth.sql
deleted file mode 100644
index 366afa930bd..00000000000
--- a/sql/updates/auth/2015_04_10_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `rbac_permissions` SET `name`='Command: reload quest_locale' WHERE `id`=667;
diff --git a/sql/updates/auth/2015_04_11_00_auth.sql b/sql/updates/auth/2015_04_11_00_auth.sql
deleted file mode 100644
index 495dc12df97..00000000000
--- a/sql/updates/auth/2015_04_11_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `rbac_permissions` SET `name`='Command: reload quest_greeting' WHERE `id`=664;
diff --git a/sql/updates/auth/2015_04_11_01_auth.sql b/sql/updates/auth/2015_04_11_01_auth.sql
deleted file mode 100644
index 3d205b86298..00000000000
--- a/sql/updates/auth/2015_04_11_01_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `battlenet_account_bans` DROP COLUMN `active`;
diff --git a/sql/updates/auth/2015_04_21_00_auth.sql b/sql/updates/auth/2015_04_21_00_auth.sql
deleted file mode 100644
index 1a9ac877fbd..00000000000
--- a/sql/updates/auth/2015_04_21_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` IN (10, 662);
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(10, 'Use character templates'),
-(662, 'Command: reload character_template');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (10, 662);
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, 10),
-(196, 662);
diff --git a/sql/updates/auth/2015_05_02_00_auth.sql b/sql/updates/auth/2015_05_02_00_auth.sql
deleted file mode 100644
index 08b574a9068..00000000000
--- a/sql/updates/auth/2015_05_02_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=12;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(12, 'Command: go quest');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=12;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(198, 12);
diff --git a/sql/updates/auth/2015_05_02_01_auth.sql b/sql/updates/auth/2015_05_02_01_auth.sql
deleted file mode 100644
index eb6f50ec026..00000000000
--- a/sql/updates/auth/2015_05_02_01_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id`=12;
-DELETE FROM `rbac_permissions` WHERE `id`=834;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(834, 'Command: go quest');
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=12;
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=834;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(198, 834);
diff --git a/sql/updates/auth/2015_07_02_00_auth.sql b/sql/updates/auth/2015_07_02_00_auth.sql
deleted file mode 100644
index 42aaed44b9f..00000000000
--- a/sql/updates/auth/2015_07_02_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=20182 WHERE `gamebuild`=19793;
-UPDATE `battlenet_components` SET `Build`=20182 WHERE `Program`='WoW' AND `Platform`='base' AND `Build`=19793;
-UPDATE `battlenet_components` SET `Build`=20182 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=19865;
diff --git a/sql/updates/auth/2015_07_06_00_auth.sql b/sql/updates/auth/2015_07_06_00_auth.sql
deleted file mode 100644
index d6d51f71f26..00000000000
--- a/sql/updates/auth/2015_07_06_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20201 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20182;
diff --git a/sql/updates/auth/2015_07_08_00_auth.sql b/sql/updates/auth/2015_07_08_00_auth.sql
deleted file mode 100644
index 161a76cbcc9..00000000000
--- a/sql/updates/auth/2015_07_08_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `battlenet_components` SET `Build`=20216 WHERE `Program`='WoW' AND `Platform` IN ('Mc64','Win','Wn64') AND `Build`=20201;
diff --git a/sql/updates/auth/2015_07_08_01_auth.sql b/sql/updates/auth/2015_07_08_01_auth.sql
deleted file mode 100644
index 1d755dbb86d..00000000000
--- a/sql/updates/auth/2015_07_08_01_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` IN (383, 743, 744, 745, 746, 747, 748, 749, 750, 751, 752, 754, 755, 756, 758, 759, 760, 830);
diff --git a/sql/updates/auth/dummy b/sql/updates/auth/dummy
new file mode 100644
index 00000000000..e69de29bb2d
--- /dev/null
+++ b/sql/updates/auth/dummy