diff options
7 files changed, 16 insertions, 16 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 89294f5b92b..6656fe7d48c 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -515,10 +515,10 @@ 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` int(11) unsigned NOT NULL, + `guid` int(10) unsigned NOT NULL, `currency` smallint(5) unsigned NOT NULL, - `total_count` int(11) unsigned NOT NULL, - `week_count` int(11) unsigned NOT NULL, + `total_count` int(10) unsigned NOT NULL, + `week_count` int(10) unsigned NOT NULL, PRIMARY KEY (`guid`,`currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/characters/2012_09_03_00_characters_currency.sql b/sql/updates/characters/2012_09_03_00_characters_currency.sql deleted file mode 100644 index 84c5690f1ac..00000000000 --- a/sql/updates/characters/2012_09_03_00_characters_currency.sql +++ /dev/null @@ -1,8 +0,0 @@ -DROP TABLE IF EXISTS `character_currency`; -CREATE TABLE `character_currency` ( - `guid` int(11) unsigned NOT NULL, - `currency` smallint(5) unsigned NOT NULL, - `total_count` int(11) unsigned NOT NULL, - `week_count` int(11) unsigned NOT NULL, - PRIMARY KEY (`guid`,`currency`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8;
\ No newline at end of file diff --git a/sql/updates/characters/2012_09_03_00_characters_currency_434.sql b/sql/updates/characters/2012_09_03_00_characters_currency_434.sql new file mode 100644 index 00000000000..fd6b3aaff10 --- /dev/null +++ b/sql/updates/characters/2012_09_03_00_characters_currency_434.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_currency`; +CREATE TABLE `character_currency` ( + `guid` int(10) unsigned NOT NULL, + `currency` smallint(5) unsigned NOT NULL, + `total_count` int(10) unsigned NOT NULL, + `week_count` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`currency`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/sql/updates/characters/2012_09_03_01_characters_currency.sql b/sql/updates/characters/2012_09_03_01_characters_currency.sql deleted file mode 100644 index 308f0dfeafd..00000000000 --- a/sql/updates/characters/2012_09_03_01_characters_currency.sql +++ /dev/null @@ -1,3 +0,0 @@ --- porting from characters table -insert into `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT characters.guid, 392, characters.totalHonorPoints, 0 FROM characters WHERE characters.totalHonorPoints > 0; -insert into `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT characters.guid, 390, characters.conquestPoints, 0 FROM characters WHERE characters.conquestPoints > 0;
\ No newline at end of file diff --git a/sql/updates/characters/2012_09_03_01_characters_currency_434.sql b/sql/updates/characters/2012_09_03_01_characters_currency_434.sql new file mode 100644 index 00000000000..8b44fa43bd3 --- /dev/null +++ b/sql/updates/characters/2012_09_03_01_characters_currency_434.sql @@ -0,0 +1,3 @@ +-- porting from characters table +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 392, `characters`.`totalHonorPoints`, 0 FROM `characters` WHERE `characters`.`totalHonorPoints` > 0; +INSERT INTO `character_currency` (`guid`, `currency`, `total_count`, `week_count`) SELECT `characters`.`guid`, 390, `characters`.`conquestPoints`, 0 FROM `characters` WHERE `characters`.`conquestPoints` > 0; diff --git a/sql/updates/characters/2012_09_03_02_characters_characters.sql b/sql/updates/characters/2012_09_03_02_characters_characters.sql deleted file mode 100644 index 7dc811fe66d..00000000000 --- a/sql/updates/characters/2012_09_03_02_characters_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `characters` DROP `conquestPoints`; -ALTER TABLE `characters` DROP `totalHonorPoints`;
\ No newline at end of file diff --git a/sql/updates/characters/2012_09_03_02_characters_characters_434.sql b/sql/updates/characters/2012_09_03_02_characters_characters_434.sql new file mode 100644 index 00000000000..db61cbb1c88 --- /dev/null +++ b/sql/updates/characters/2012_09_03_02_characters_characters_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` DROP `conquestPoints`; +ALTER TABLE `characters` DROP `totalHonorPoints`; |