TDB 6.0.2 - 2015/07/14TDB6.02

9 files changed, 0 insertions, 137 deletions

diff --git a/sql/updates/characters/2015_03_29_00_characters.sql b/sql/updates/characters/2015_03_29_00_characters.sql
deleted file mode 100644
index b9bb746c2f7..00000000000
--- a/sql/updates/characters/2015_03_29_00_characters.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-ALTER TABLE `corpse` DROP `phaseMask`;
-
-DROP TABLE IF EXISTS `corpse_phases`;
-CREATE TABLE `corpse_phases` (
-  `Guid` int(10) unsigned NOT NULL,
-  `PhaseId` int(10) unsigned NOT NULL,
-  `OwnerGuid` int(10) unsigned NOT NULL,
-  `Time` int(10) unsigned NOT NULL DEFAULT '0',
-  `CorpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`Guid`,`PhaseId`)
-);
\ No newline at end of file
diff --git a/sql/updates/characters/2015_04_21_00_characters.sql b/sql/updates/characters/2015_04_21_00_characters.sql
deleted file mode 100644
index b5fc1bd2ac8..00000000000
--- a/sql/updates/characters/2015_04_21_00_characters.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-DROP TABLE IF EXISTS `character_template`;
-CREATE TABLE IF NOT EXISTS `character_template` (
-  `id` int(10) unsigned NOT NULL,
-  `name` varchar(70) NOT NULL,
-  `description` varchar(100) NOT NULL,
-  `level` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-DROP TABLE IF EXISTS `character_template_class`;
-CREATE TABLE IF NOT EXISTS `character_template_class` (
-  `templateId` int(10) unsigned NOT NULL,
-  `factionGroup` tinyint(3) unsigned NOT NULL COMMENT '3 - Alliance, 5 - Horde',
-  `class` tinyint(3) unsigned NOT NULL,
-  PRIMARY KEY (`templateId`,`factionGroup`,`class`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/2015_04_28_00_characters.sql b/sql/updates/characters/2015_04_28_00_characters.sql
deleted file mode 100644
index 9e02e401707..00000000000
--- a/sql/updates/characters/2015_04_28_00_characters.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-DELETE FROM `corpse` WHERE `corpseType`=0;
-
-DROP PROCEDURE IF EXISTS `CheckCorpseData`;
-
-DELIMITER $$
-
-CREATE PROCEDURE CheckCorpseData()
-BEGIN
-  DECLARE max_corpses_per_player int;
-  SELECT MAX(`counts`) FROM (SELECT COUNT(`corpseGuid`) AS `counts` FROM `corpse` GROUP BY `guid`) AS `counted` INTO max_corpses_per_player;
-
-  IF max_corpses_per_player > 50000 THEN
-    TRUNCATE `corpse`;
-  END IF;
-
-END$$
-DELIMITER ;
-
-CALL CheckCorpseData();
-DROP PROCEDURE `CheckCorpseData`;
-
-ALTER TABLE `corpse`
-  DROP `corpseGuid`,
-  DROP INDEX `idx_player`,
-  ADD PRIMARY KEY (`guid`);
-
-ALTER TABLE `corpse_phases`
-  DROP PRIMARY KEY,
-  DROP `Guid`,
-  DROP `CorpseType`,
-  DROP `Time`,
-  CHANGE `OwnerGuid` `OwnerGuid` bigint(20) unsigned NOT NULL DEFAULT '0' FIRST,
-  ADD PRIMARY KEY (`OwnerGuid`,`PhaseId`);
diff --git a/sql/updates/characters/2015_05_08_00_characters.sql b/sql/updates/characters/2015_05_08_00_characters.sql
deleted file mode 100644
index 56a48474801..00000000000
--- a/sql/updates/characters/2015_05_08_00_characters.sql
+++ /dev/null
@@ -1,36 +0,0 @@
---
--- Table structure for table `character_garrison`
---
-
-DROP TABLE IF EXISTS `character_garrison`;
-CREATE TABLE `character_garrison` (
-  `guid` bigint(20) unsigned NOT NULL,
-  `siteLevelId` int(10) unsigned NOT NULL DEFAULT '0',
-  `followerActivationsRemainingToday` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Table structure for table `character_garrison_blueprints`
---
-
-DROP TABLE IF EXISTS `character_garrison_blueprints`;
-CREATE TABLE `character_garrison_blueprints` (
-  `guid` bigint(20) unsigned NOT NULL,
-  `buildingId` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`buildingId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Table structure for table `character_garrison_buildings`
---
-
-DROP TABLE IF EXISTS `character_garrison_buildings`;
-CREATE TABLE `character_garrison_buildings` (
-  `guid` bigint(20) unsigned NOT NULL,
-  `plotInstanceId` int(10) unsigned NOT NULL DEFAULT '0',
-  `buildingId` int(10) unsigned NOT NULL DEFAULT '0',
-  `timeBuilt` bigint(20) unsigned NOT NULL,
-  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`plotInstanceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/2015_05_22_00_characters.sql b/sql/updates/characters/2015_05_22_00_characters.sql
deleted file mode 100644
index 35e72a5aa86..00000000000
--- a/sql/updates/characters/2015_05_22_00_characters.sql
+++ /dev/null
@@ -1,35 +0,0 @@
-DROP TABLE IF EXISTS `character_garrison_follower_abilities`;
-DROP TABLE IF EXISTS `character_garrison_followers`;
-
---
--- Table structure for table `character_garrison_followers`
---
-
-CREATE TABLE `character_garrison_followers` (
-  `dbId` bigint(20) unsigned NOT NULL,
-  `guid` bigint(20) unsigned NOT NULL,
-  `followerId` int(10) unsigned NOT NULL,
-  `quality` int(10) unsigned NOT NULL DEFAULT '2',
-  `level` int(10) unsigned NOT NULL DEFAULT '90',
-  `itemLevelWeapon` int(10) unsigned NOT NULL DEFAULT '600',
-  `itemLevelArmor` int(10) unsigned NOT NULL DEFAULT '600',
-  `xp` int(10) unsigned NOT NULL DEFAULT '0',
-  `currentBuilding` int(10) unsigned NOT NULL DEFAULT '0',
-  `currentMission` int(10) unsigned NOT NULL DEFAULT '0',
-  `status` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`dbId`),
-  UNIQUE KEY `idx_guid_id` (`guid`,`followerId`),
-  CONSTRAINT `fk_foll_owner` FOREIGN KEY (`guid`) REFERENCES `characters` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Table structure for table `character_garrison_follower_abilities`
---
-
-CREATE TABLE `character_garrison_follower_abilities` (
-  `dbId` bigint(20) unsigned NOT NULL,
-  `abilityId` int(10) unsigned NOT NULL,
-  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`dbId`,`abilityId`,`slot`),
-  CONSTRAINT `fk_foll_dbid` FOREIGN KEY (`dbId`) REFERENCES `character_garrison_followers` (`dbId`) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/2015_07_08_00_characters.sql b/sql/updates/characters/2015_07_08_00_characters.sql
deleted file mode 100644
index 2beacc60feb..00000000000
--- a/sql/updates/characters/2015_07_08_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DROP TABLE IF EXISTS `gm_ticket`;
-DROP TABLE IF EXISTS `gm_survey`;
-DROP TABLE IF EXISTS `gm_subsurvey`;
diff --git a/sql/updates/characters/2015_07_11_00_characters.sql b/sql/updates/characters/2015_07_11_00_characters.sql
deleted file mode 100644
index a0d43e16e28..00000000000
--- a/sql/updates/characters/2015_07_11_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `character_glyphs` DROP `glyph7`, DROP `glyph8`, DROP `glyph9`;
diff --git a/sql/updates/characters/2015_07_12_00_characters.sql b/sql/updates/characters/2015_07_12_00_characters.sql
deleted file mode 100644
index 575097f7ff0..00000000000
--- a/sql/updates/characters/2015_07_12_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `characters` ADD `power6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `power5`;
-ALTER TABLE `character_stats` ADD `maxpower6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `maxpower5`;
diff --git a/sql/updates/characters/dummy b/sql/updates/characters/dummy
new file mode 100644
index 00000000000..e69de29bb2d
--- /dev/null
+++ b/sql/updates/characters/dummy