From de64f5d34fe4781e9036440684be181e16528046 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 20 Jun 2013 14:28:32 +0200 Subject: Core/Achievements: Fixed field type in *_achievement_progress tables --- sql/base/characters_database.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/base') 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`) -- cgit v1.2.3