diff options
| author | AriDEV <aridev666@gmail.com> | 2014-12-29 09:08:41 +0100 |
|---|---|---|
| committer | AriDEV <aridev666@gmail.com> | 2015-01-02 03:05:58 +0100 |
| commit | 895e50be7a3a132482774d3b4fb817f5e501ac0f (patch) | |
| tree | f72731d1d9cb19abc0bd521b0314fd1e822f38d4 /sql/base | |
| parent | 1d83ce39ddfa88974de63c2a3a9b52ed1fad1b77 (diff) | |
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>
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 12 |
1 files changed, 7 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 */; |