diff options
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`; |