From 895e50be7a3a132482774d3b4fb817f5e501ac0f Mon Sep 17 00:00:00 2001 From: AriDEV Date: Mon, 29 Dec 2014 09:08:41 +0100 Subject: Server/PacketIO: Currency Updates * Update SMSG_SET_CURRENCY & SMSG_SETUP_CURRENCY Packets. * Update of Database Structure and SQLStatements for Currencies. Signed-off-by: AriDEV --- sql/updates/characters/2015_01_02_00_characters.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/characters/2015_01_02_00_characters.sql (limited to 'sql/updates') 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`; -- cgit v1.2.3