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 -- sql/updates/world/2014_10_19_01_world.sql | 4 +++ sql/updates/world/2014_10_19_01_world_6x.sql | 4 --- sql/updates/world/2014_10_19_02_world.sql | 45 ++++++++++++++++++++++++++++ sql/updates/world/2014_10_19_02_world_6x.sql | 45 ---------------------------- 8 files changed, 59 insertions(+), 59 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 create mode 100644 sql/updates/world/2014_10_19_01_world.sql delete mode 100644 sql/updates/world/2014_10_19_01_world_6x.sql create mode 100644 sql/updates/world/2014_10_19_02_world.sql delete mode 100644 sql/updates/world/2014_10_19_02_world_6x.sql (limited to 'sql') 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; diff --git a/sql/updates/world/2014_10_19_01_world.sql b/sql/updates/world/2014_10_19_01_world.sql new file mode 100644 index 00000000000..99e7b4ee0c1 --- /dev/null +++ b/sql/updates/world/2014_10_19_01_world.sql @@ -0,0 +1,4 @@ +ALTER TABLE creature_classlevelstats ADD COLUMN basehp4 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp3; +ALTER TABLE creature_classlevelstats ADD COLUMN basehp5 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp4; +ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp4 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp3; +ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp5 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp4; diff --git a/sql/updates/world/2014_10_19_01_world_6x.sql b/sql/updates/world/2014_10_19_01_world_6x.sql deleted file mode 100644 index 99e7b4ee0c1..00000000000 --- a/sql/updates/world/2014_10_19_01_world_6x.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE creature_classlevelstats ADD COLUMN basehp4 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp3; -ALTER TABLE creature_classlevelstats ADD COLUMN basehp5 MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 1 AFTER basehp4; -ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp4 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp3; -ALTER TABLE creature_classlevelstats ADD COLUMN damage_exp5 FLOAT NOT NULL DEFAULT 0 AFTER damage_exp4; diff --git a/sql/updates/world/2014_10_19_02_world.sql b/sql/updates/world/2014_10_19_02_world.sql new file mode 100644 index 00000000000..f9285741671 --- /dev/null +++ b/sql/updates/world/2014_10_19_02_world.sql @@ -0,0 +1,45 @@ +DROP TABLE IF EXISTS class_expansion_requirement; +CREATE TABLE class_expansion_requirement +( + `classID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`classID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO class_expansion_requirement (classID, expansion) VALUES +(1,0), +(2,0), +(3,0), +(4,0), +(5,0), +(6,2), +(7,0), +(8,0), +(9,0), +(10,4), +(11,0); + +DROP TABLE IF EXISTS race_expansion_requirement; +CREATE TABLE race_expansion_requirement +( + `raceID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`raceID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO race_expansion_requirement (raceID, expansion) VALUES +(1,0), +(2,0), +(3,0), +(4,0), +(5,0), +(6,0), +(7,0), +(8,0), +(9,1), +(10,1), +(11,1), +(22,1), +(24,1), +(25,1), +(26,1); diff --git a/sql/updates/world/2014_10_19_02_world_6x.sql b/sql/updates/world/2014_10_19_02_world_6x.sql deleted file mode 100644 index f9285741671..00000000000 --- a/sql/updates/world/2014_10_19_02_world_6x.sql +++ /dev/null @@ -1,45 +0,0 @@ -DROP TABLE IF EXISTS class_expansion_requirement; -CREATE TABLE class_expansion_requirement -( - `classID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', - `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`classID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO class_expansion_requirement (classID, expansion) VALUES -(1,0), -(2,0), -(3,0), -(4,0), -(5,0), -(6,2), -(7,0), -(8,0), -(9,0), -(10,4), -(11,0); - -DROP TABLE IF EXISTS race_expansion_requirement; -CREATE TABLE race_expansion_requirement -( - `raceID` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', - `expansion` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (`raceID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO race_expansion_requirement (raceID, expansion) VALUES -(1,0), -(2,0), -(3,0), -(4,0), -(5,0), -(6,0), -(7,0), -(8,0), -(9,1), -(10,1), -(11,1), -(22,1), -(24,1), -(25,1), -(26,1); -- cgit v1.2.3