diff options
| author | joschiwald <joschiwald.trinity@gmail.com> | 2015-01-02 03:46:32 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2015-01-02 03:46:32 +0100 |
| commit | 3e9d7e83eb302c6ff4b1108a58505b608049edf9 (patch) | |
| tree | ab70fa56d5c75ee041506deb7e1672753e6f5aad /sql | |
| parent | a4afd80479a3cdb7938dd7dc091205118518b390 (diff) | |
| parent | 895e50be7a3a132482774d3b4fb817f5e501ac0f (diff) | |
Merge pull request #13809 from AriDEV/6.x
Server/PacketIO: Currency Updates
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 12 | ||||
| -rw-r--r-- | sql/updates/characters/2015_01_02_00_characters.sql | 21 |
2 files changed, 28 insertions, 5 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index c39ae87dafd..4fcc88a3a7d 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`; |