From f095a4089c0dd4ec6e01dfc4ef54ea163efd1d34 Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 20 Oct 2014 01:40:26 +0200 Subject: SQL: Removex 6x from file names --- sql/updates/auth/2014_10_04_00_auth.sql | 8 ++++++++ sql/updates/auth/2014_10_04_00_auth_6x.sql | 8 -------- sql/updates/auth/2014_10_19_00_auth.sql | 2 ++ sql/updates/auth/2014_10_19_00_auth_6x.sql | 2 -- 4 files changed, 10 insertions(+), 10 deletions(-) create mode 100644 sql/updates/auth/2014_10_04_00_auth.sql delete mode 100644 sql/updates/auth/2014_10_04_00_auth_6x.sql create mode 100644 sql/updates/auth/2014_10_19_00_auth.sql delete mode 100644 sql/updates/auth/2014_10_19_00_auth_6x.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/2014_10_04_00_auth.sql b/sql/updates/auth/2014_10_04_00_auth.sql new file mode 100644 index 00000000000..61731b408b6 --- /dev/null +++ b/sql/updates/auth/2014_10_04_00_auth.sql @@ -0,0 +1,8 @@ +DELETE FROM `battlenet_components` WHERE `Build`=18973 AND `Program`!='Bnet'; +DELETE FROM `battlenet_components` WHERE `Build`=37165 AND `Program`='Bnet'; +INSERT INTO `battlenet_components` VALUES +('Bnet','Win',37165), +('Bnet','Wn64',37165), +('WoW','base',18973), +('WoWB','Win',18973), +('WoWB','Wn64',18973); diff --git a/sql/updates/auth/2014_10_04_00_auth_6x.sql b/sql/updates/auth/2014_10_04_00_auth_6x.sql deleted file mode 100644 index 61731b408b6..00000000000 --- a/sql/updates/auth/2014_10_04_00_auth_6x.sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM `battlenet_components` WHERE `Build`=18973 AND `Program`!='Bnet'; -DELETE FROM `battlenet_components` WHERE `Build`=37165 AND `Program`='Bnet'; -INSERT INTO `battlenet_components` VALUES -('Bnet','Win',37165), -('Bnet','Wn64',37165), -('WoW','base',18973), -('WoWB','Win',18973), -('WoWB','Wn64',18973); diff --git a/sql/updates/auth/2014_10_19_00_auth.sql b/sql/updates/auth/2014_10_19_00_auth.sql new file mode 100644 index 00000000000..a0a28f91359 --- /dev/null +++ b/sql/updates/auth/2014_10_19_00_auth.sql @@ -0,0 +1,2 @@ +ALTER TABLE account MODIFY COLUMN expansion TINYINT(3) UNSIGNED DEFAULT 5 NOT NULL; +UPDATE account SET expansion = 5; diff --git a/sql/updates/auth/2014_10_19_00_auth_6x.sql b/sql/updates/auth/2014_10_19_00_auth_6x.sql deleted file mode 100644 index a0a28f91359..00000000000 --- a/sql/updates/auth/2014_10_19_00_auth_6x.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE account MODIFY COLUMN expansion TINYINT(3) UNSIGNED DEFAULT 5 NOT NULL; -UPDATE account SET expansion = 5; -- cgit v1.2.3