TDB 6.0.2 - 2015/07/14TDB6.02

8 files changed, 137 insertions, 0 deletions

diff --git a/sql/old/6.x/characters/01_2015_03_21/2015_03_29_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_03_29_00_characters.sql
new file mode 100644
index 00000000000..b9bb746c2f7
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_03_29_00_characters.sql
@@ -0,0 +1,11 @@
+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/old/6.x/characters/01_2015_03_21/2015_04_21_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_04_21_00_characters.sql
new file mode 100644
index 00000000000..b5fc1bd2ac8
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_04_21_00_characters.sql
@@ -0,0 +1,16 @@
+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/old/6.x/characters/01_2015_03_21/2015_04_28_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_04_28_00_characters.sql
new file mode 100644
index 00000000000..9e02e401707
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_04_28_00_characters.sql
@@ -0,0 +1,33 @@
+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/old/6.x/characters/01_2015_03_21/2015_05_08_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_05_08_00_characters.sql
new file mode 100644
index 00000000000..56a48474801
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_05_08_00_characters.sql
@@ -0,0 +1,36 @@
+--
+-- 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/old/6.x/characters/01_2015_03_21/2015_05_22_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_05_22_00_characters.sql
new file mode 100644
index 00000000000..35e72a5aa86
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_05_22_00_characters.sql
@@ -0,0 +1,35 @@
+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/old/6.x/characters/01_2015_03_21/2015_07_08_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_07_08_00_characters.sql
new file mode 100644
index 00000000000..2beacc60feb
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_07_08_00_characters.sql
@@ -0,0 +1,3 @@
+DROP TABLE IF EXISTS `gm_ticket`;
+DROP TABLE IF EXISTS `gm_survey`;
+DROP TABLE IF EXISTS `gm_subsurvey`;
diff --git a/sql/old/6.x/characters/01_2015_03_21/2015_07_11_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_07_11_00_characters.sql
new file mode 100644
index 00000000000..a0d43e16e28
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_07_11_00_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `character_glyphs` DROP `glyph7`, DROP `glyph8`, DROP `glyph9`;
diff --git a/sql/old/6.x/characters/01_2015_03_21/2015_07_12_00_characters.sql b/sql/old/6.x/characters/01_2015_03_21/2015_07_12_00_characters.sql
new file mode 100644
index 00000000000..575097f7ff0
--- /dev/null
+++ b/sql/old/6.x/characters/01_2015_03_21/2015_07_12_00_characters.sql
@@ -0,0 +1,2 @@
+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`;