aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/3.3.5/2016_10_30_00_characters.sql2
-rw-r--r--sql/updates/characters/3.3.5/2017_04_03_00_characters.sql11
-rw-r--r--sql/updates/characters/3.3.5/2017_04_12_00_characters.sql3
-rw-r--r--sql/updates/characters/3.3.5/2017_04_12_01_characters.sql4
-rw-r--r--sql/updates/characters/3.3.5/2017_04_19_00_characters.sql (renamed from sql/updates/characters/3.3.5/2016_10_16_00_characters.sql)1
5 files changed, 1 insertions, 20 deletions
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/2016_10_16_00_characters.sql b/sql/updates/characters/3.3.5/2017_04_19_00_characters.sql
index be8a4d21b66..df58c16eec1 100644
--- a/sql/updates/characters/3.3.5/2016_10_16_00_characters.sql
+++ b/sql/updates/characters/3.3.5/2017_04_19_00_characters.sql
@@ -1 +1,2 @@
+-- TDB 335.63 characters
UPDATE `updates` SET `state`='ARCHIVED';