Core/Achievements: Fixed field type in *_achievement_progress tables

2 files changed, 4 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`)
diff --git a/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql b/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql
new file mode 100644
index 00000000000..bf281aa04c7
--- /dev/null
+++ b/sql/updates/characters/2013_06_19_00_characters_achievements_progress.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `character_achievement_progress` CHANGE `counter` `counter` bigint(20) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `guild_achievement_progress` CHANGE `counter` `counter` bigint(20) unsigned NOT NULL DEFAULT '0';