TDB 720.00 - 2016/04/18TDB720.00

10 files changed, 4 insertions, 57 deletions

diff --git a/sql/updates/characters/master/2016_10_17_00_characters.sql b/sql/updates/characters/master/2016_10_17_00_characters.sql
deleted file mode 100644
index 4e3ed5809bf..00000000000
--- a/sql/updates/characters/master/2016_10_17_00_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `updates` SET `state`='ARCHIVED'; -- TDB 703.00
diff --git a/sql/updates/characters/master/2016_10_25_00_characters.sql b/sql/updates/characters/master/2016_10_25_00_characters.sql
deleted file mode 100644
index 3396c3e0a4b..00000000000
--- a/sql/updates/characters/master/2016_10_25_00_characters.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-ALTER TABLE `character_cuf_profiles`
-  CHANGE `unk146` `topPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame top alignment' AFTER `boolOptions`,
-  CHANGE `unk147` `bottomPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame bottom alignment' AFTER `topPoint`,
-  CHANGE `unk148` `leftPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame left alignment' AFTER `bottomPoint`,
-  CHANGE `unk150` `topOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from top' AFTER `leftPoint`,
-  CHANGE `unk152` `bottomOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from bottom' AFTER `topOffset`,
-  CHANGE `unk154` `leftOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from left' AFTER `bottomOffset`;
-
-UPDATE `character_cuf_profiles` SET `boolOptions`=((`boolOptions`&0x1800000)<<2)|(`boolOptions`&0x67FFFFF);
diff --git a/sql/updates/characters/master/2016_11_06_00_characters.sql b/sql/updates/characters/master/2016_11_06_00_characters.sql
deleted file mode 100644
index 1b4f22e24e7..00000000000
--- a/sql/updates/characters/master/2016_11_06_00_characters.sql
+++ /dev/null
@@ -1,11 +0,0 @@
---
--- Table structure for table `instance_scenario_progress`
---
-DROP TABLE IF EXISTS `instance_scenario_progress`;
-CREATE TABLE `instance_scenario_progress` (
-  `id` int(10) unsigned NOT NULL,
-  `criteria` int(10) unsigned NOT NULL,
-  `counter` bigint(20) unsigned NOT NULL,
-  `date` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`id`,`criteria`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/master/2016_12_09_00_characters.sql b/sql/updates/characters/master/2016_12_09_00_characters.sql
deleted file mode 100644
index 5cf06fde71c..00000000000
--- a/sql/updates/characters/master/2016_12_09_00_characters.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-ALTER TABLE `item_instance_gems`
-  CHANGE `gemItemId1` `gemItemId1` int(10) unsigned NOT NULL DEFAULT '0',
-  CHANGE `gemBonuses1` `gemBonuses1` text,
-  ADD `gemScalingLevel1` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemContext1`,
-  CHANGE `gemItemId2` `gemItemId2` int(10) unsigned NOT NULL DEFAULT '0',
-  CHANGE `gemBonuses2` `gemBonuses2` text,
-  ADD `gemScalingLevel2` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemBonuses2`,
-  CHANGE `gemItemId3` `gemItemId3` int(10) unsigned NOT NULL DEFAULT 0,
-  CHANGE `gemBonuses3` `gemBonuses3` text,
-  ADD `gemScalingLevel3` int(10) unsigned NOT NULL DEFAULT '0' AFTER `gemContext3`;
diff --git a/sql/updates/characters/master/2016_12_26_00_characters.sql b/sql/updates/characters/master/2016_12_26_00_characters.sql
deleted file mode 100644
index 3db177be92a..00000000000
--- a/sql/updates/characters/master/2016_12_26_00_characters.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-ALTER TABLE `character_void_storage` ADD `randomPropertyType` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `creatorGuid`;
-UPDATE `character_void_storage` SET `randomPropertyType`=1,`randomProperty`=0xFFFFFFFF-`randomProperty`+1 WHERE `randomProperty`>=0x80000000; -- recover from underflow when saving data in old format
-
-ALTER TABLE `item_instance` ADD `randomPropertyType` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `enchantments`;
-UPDATE `item_instance` SET `randomPropertyType`=1 WHERE `randomPropertyId`<0;
-UPDATE `item_instance` SET `randomPropertyId`=ABS(`randomPropertyId`);
-ALTER TABLE `item_instance` CHANGE `randomPropertyId` `randomPropertyId` int(10) unsigned NOT NULL DEFAULT '0';
-
-
-ALTER TABLE `item_loot_items` ADD `rnd_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'random enchantment type' AFTER `needs_quest`;
-UPDATE `item_loot_items` SET `rnd_type`=1 WHERE `rnd_prop`<0;
-UPDATE `item_loot_items` SET `rnd_prop`=ABS(`rnd_prop`);
-ALTER TABLE `item_loot_items` CHANGE `rnd_prop` `rnd_prop` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled';
diff --git a/sql/updates/characters/master/2017_01_22_00_characters.sql b/sql/updates/characters/master/2017_01_22_00_characters.sql
deleted file mode 100644
index e89c3e3593b..00000000000
--- a/sql/updates/characters/master/2017_01_22_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `character_talent`
-  CHANGE `spell` `talentId` MEDIUMINT(8) UNSIGNED NOT NULL;
diff --git a/sql/updates/characters/master/2017_01_29_00_characters.sql b/sql/updates/characters/master/2017_01_29_00_characters.sql
deleted file mode 100644
index b7cb4126ccd..00000000000
--- a/sql/updates/characters/master/2017_01_29_00_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-DROP TABLE IF EXISTS `character_template`;
-DROP TABLE IF EXISTS `character_template_class`;
diff --git a/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql b/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql
deleted file mode 100644
index f165cc76d26..00000000000
--- a/sql/updates/characters/master/2017_02_26_00_characters_2016_09_13_00_characters.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP TABLE IF EXISTS `character_fishingsteps`;
-CREATE TABLE `character_fishingsteps` (
-  `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
-  `fishingSteps` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`)
-) ENGINE=INNODB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/characters/master/2017_04_15_00_characters.sql b/sql/updates/characters/master/2017_04_15_00_characters.sql
deleted file mode 100644
index 9280c349383..00000000000
--- a/sql/updates/characters/master/2017_04_15_00_characters.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE `character_equipmentsets` ADD `AssignedSpecIndex` int(11) NOT NULL DEFAULT '-1' AFTER `ignore_mask`;
-
-ALTER TABLE `item_instance_artifact` CHANGE `xp` `xp` bigint(20) unsigned NOT NULL DEFAULT '0';
diff --git a/sql/updates/characters/master/2017_04_19_00_characters.sql b/sql/updates/characters/master/2017_04_19_00_characters.sql
new file mode 100644
index 00000000000..cedbe3833eb
--- /dev/null
+++ b/sql/updates/characters/master/2017_04_19_00_characters.sql
@@ -0,0 +1,4 @@
+-- TDB 720.00 characters
+DELETE FROM `updates_include` WHERE `path`='$/sql/old/7/characters';
+INSERT INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/7/characters', 'ARCHIVED');
+UPDATE `updates` SET `state`='ARCHIVED';