From 73ec3a1d3b34b31ae67ea4215ce3d25a2adf392b Mon Sep 17 00:00:00 2001 From: DDuarte Date: Wed, 19 Apr 2017 01:14:14 +0100 Subject: TDB 335.63 - 2017/04/18 --- sql/updates/characters/3.3.5/2016_10_16_00_characters.sql | 1 - sql/updates/characters/3.3.5/2016_10_30_00_characters.sql | 2 -- sql/updates/characters/3.3.5/2017_04_03_00_characters.sql | 11 ----------- sql/updates/characters/3.3.5/2017_04_12_00_characters.sql | 3 --- sql/updates/characters/3.3.5/2017_04_12_01_characters.sql | 4 ---- sql/updates/characters/3.3.5/2017_04_19_00_characters.sql | 2 ++ 6 files changed, 2 insertions(+), 21 deletions(-) delete mode 100644 sql/updates/characters/3.3.5/2016_10_16_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2016_10_30_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2017_04_03_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2017_04_12_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2017_04_12_01_characters.sql create mode 100644 sql/updates/characters/3.3.5/2017_04_19_00_characters.sql (limited to 'sql/updates/characters') diff --git a/sql/updates/characters/3.3.5/2016_10_16_00_characters.sql b/sql/updates/characters/3.3.5/2016_10_16_00_characters.sql deleted file mode 100644 index be8a4d21b66..00000000000 --- a/sql/updates/characters/3.3.5/2016_10_16_00_characters.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql b/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql deleted file mode 100644 index f72e8c32e22..00000000000 --- a/sql/updates/characters/3.3.5/2016_10_30_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM `character_aura` WHERE `itemGuid` != 0; -ALTER TABLE `character_aura` DROP COLUMN `itemGuid`; diff --git a/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql deleted file mode 100644 index 8519bd94556..00000000000 --- a/sql/updates/characters/3.3.5/2017_04_03_00_characters.sql +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE `character_arena_stats` -CHANGE `guid` `guid` INT(10) unsigned NOT NULL DEFAULT '0', -CHANGE `slot` `slot` TINYINT(3) unsigned NOT NULL DEFAULT '0', -CHANGE `matchMakerRating` `matchMakerRating` SMALLINT(5) unsigned NOT NULL DEFAULT 0; - -ALTER TABLE `character_equipmentsets` -CHANGE `guid` `guid` INT(10) unsigned NOT NULL DEFAULT '0', -CHANGE `setguid` `setguid` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT; - -ALTER TABLE `item_loot_money` -CHANGE `container_id` `container_id` INT(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)'; diff --git a/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql deleted file mode 100644 index 117e3baa78d..00000000000 --- a/sql/updates/characters/3.3.5/2017_04_12_00_characters.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `item_loot_money` -CHANGE `money` `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)', -ADD PRIMARY KEY (`container_id`); diff --git a/sql/updates/characters/3.3.5/2017_04_12_01_characters.sql b/sql/updates/characters/3.3.5/2017_04_12_01_characters.sql deleted file mode 100644 index ed5617d2750..00000000000 --- a/sql/updates/characters/3.3.5/2017_04_12_01_characters.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `creature_respawn` CHANGE `respawnTime` `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE `gameobject_respawn` CHANGE `respawnTime` `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE `instance` CHANGE `resettime` `resettime` bigint(20) unsigned NOT NULL DEFAULT '0'; -ALTER TABLE `instance_reset` CHANGE `resettime` `resettime` bigint(20) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/characters/3.3.5/2017_04_19_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_19_00_characters.sql new file mode 100644 index 00000000000..df58c16eec1 --- /dev/null +++ b/sql/updates/characters/3.3.5/2017_04_19_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.63 characters +UPDATE `updates` SET `state`='ARCHIVED'; -- cgit v1.2.3