sql/updates/2008_12_22_06_characters_character_achievement.sql

   1 ALTER TABLE character_db_version CHANGE COLUMN required_2008_12_22_05_characters_account_data required_2008_12_22_06_characters_character_achievement bit;
   2
   3 DROP TABLE IF EXISTS `character_achievement`;
   4 CREATE TABLE `character_achievement` (
   5       `guid` int(11) NOT NULL,
   6       `achievement` int(11) NOT NULL,
   7       `date` int(11) NOT NULL,
   8       PRIMARY KEY  (`guid`,`achievement`)
   9     ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  10
  11 DROP TABLE IF EXISTS `character_achievement_progress`;
  12 CREATE TABLE `character_achievement_progress` (
  13       `guid` int(11) NOT NULL,
  14       `criteria` int(11) NOT NULL,
  15       `counter` int(11) NOT NULL,
  16       `date` int(11) NOT NULL,
  17       PRIMARY KEY  (`guid`,`criteria`)
  18     ) ENGINE=MyISAM DEFAULT CHARSET=utf8;