Server/PacketIO: Currency Updates

* Update SMSG_SET_CURRENCY & SMSG_SETUP_CURRENCY Packets.
* Update of Database Structure and SQLStatements for Currencies.

Signed-off-by: AriDEV <aridev666@gmail.com>

2 files changed, 28 insertions, 5 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index a18782f85b9..ae2d2b3f7a3 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -636,11 +636,13 @@ DROP TABLE IF EXISTS `character_currency`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `character_currency` (
-  `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
-  `currency` smallint(5) unsigned NOT NULL,
-  `total_count` int(10) unsigned NOT NULL,
-  `week_count` int(10) unsigned NOT NULL,
-  PRIMARY KEY (`guid`,`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`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
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`;