Merge pull request #13809 from AriDEV/6.x

Server/PacketIO: Currency Updates

1 files changed, 21 insertions, 0 deletions

diff --git a/sql/updates/characters/2015_01_02_00_characters.sql b/sql/updates/characters/2015_01_02_00_characters.sql
new file mode 100644
index 00000000000..890bdd0eb11
--- /dev/null
+++ b/sql/updates/characters/2015_01_02_00_characters.sql
@@ -0,0 +1,21 @@
+/*
+DROP TABLE IF EXISTS `character_currency`;
+CREATE TABLE `character_currency` (
+  `CharacterGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `Currency` SMALLINT(5) UNSIGNED NOT NULL,
+  `Quantity` INT(10) UNSIGNED NOT NULL,
+  `WeeklyQuantity` INT(10) UNSIGNED NOT NULL,
+  `TrackedQuantity` INT(10) UNSIGNED NOT NULL,
+  `Flags` TINYINT(3) UNSIGNED NOT NULL,
+  PRIMARY KEY (`CharacterGuid`, `Currency`)
+)
+COLLATE='utf8_general_ci'
+ENGINE=InnoDB;
+*/
+ALTER TABLE `character_currency`
+  CHANGE COLUMN `guid` `CharacterGuid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' FIRST,
+  CHANGE COLUMN `currency` `Currency` SMALLINT(5) UNSIGNED NOT NULL AFTER `CharacterGuid`,
+  CHANGE COLUMN `total_count` `Quantity` INT(10) UNSIGNED NOT NULL AFTER `Currency`,
+  CHANGE COLUMN `week_count` `WeeklyQuantity` INT(10) UNSIGNED NOT NULL AFTER `Quantity`,
+  ADD COLUMN `TrackedQuantity` INT(10) UNSIGNED NOT NULL AFTER `WeeklyQuantity`,
+  ADD COLUMN `Flags` TINYINT(3) UNSIGNED NOT NULL AFTER `TrackedQuantity`;