diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7802_01_characters_character_achievement.sql | 6 | ||||
| -rw-r--r-- | sql/updates/7802_02_characters_character_achievement_progress.sql | 7 |
2 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/7802_01_characters_character_achievement.sql b/sql/updates/7802_01_characters_character_achievement.sql new file mode 100644 index 00000000000..774d1f6b3a9 --- /dev/null +++ b/sql/updates/7802_01_characters_character_achievement.sql @@ -0,0 +1,6 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7644_01_characters_character_pet required_7802_01_characters_character_achievement bit; + +ALTER TABLE character_achievement + CHANGE COLUMN guid guid int(11) unsigned NOT NULL, + CHANGE COLUMN achievement achievement int(11) unsigned NOT NULL, + CHANGE COLUMN date date bigint(11) unsigned NOT NULL default '0'; diff --git a/sql/updates/7802_02_characters_character_achievement_progress.sql b/sql/updates/7802_02_characters_character_achievement_progress.sql new file mode 100644 index 00000000000..318a430acc4 --- /dev/null +++ b/sql/updates/7802_02_characters_character_achievement_progress.sql @@ -0,0 +1,7 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7802_01_characters_character_achievement required_7802_02_characters_character_achievement_progress bit; + +ALTER TABLE character_achievement_progress + CHANGE COLUMN guid guid int(11) unsigned NOT NULL, + CHANGE COLUMN criteria criteria int(11) unsigned NOT NULL, + CHANGE COLUMN counter counter int(11) unsigned NOT NULL, + CHANGE COLUMN date date bigint(11) unsigned NOT NULL default '0'; |