aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2013-06-20 14:28:32 +0200
committerShauren <shauren.trinity@gmail.com>2013-06-20 14:28:32 +0200
commitde64f5d34fe4781e9036440684be181e16528046 (patch)
tree491e9c46c514dd806d091aea8aa37022d9c584ef /sql/base
parent71386a5b2c7d85044794b038fd270e56152e32df (diff)
Core/Achievements: Fixed field type in *_achievement_progress tables
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 4f698c10288..7d8ba894b5d 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -409,7 +409,7 @@ DROP TABLE IF EXISTS `character_achievement_progress`;
CREATE TABLE `character_achievement_progress` (
`guid` int(10) unsigned NOT NULL,
`criteria` smallint(5) unsigned NOT NULL,
- `counter` int(10) unsigned NOT NULL,
+ `counter` bigint(20) unsigned NOT NULL,
`date` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`criteria`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -1801,7 +1801,7 @@ DROP TABLE IF EXISTS `guild_achievement_progress`;
CREATE TABLE `guild_achievement_progress` (
`guildId` int(10) unsigned NOT NULL,
`criteria` smallint(5) unsigned NOT NULL,
- `counter` int(10) unsigned NOT NULL,
+ `counter` bigint(20) unsigned NOT NULL,
`date` int(10) unsigned NOT NULL DEFAULT '0',
`completedGuid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guildId`,`criteria`)