1 ALTER TABLE db_version CHANGE COLUMN required_7622_03_mangos_creature_ai_texts required_7627_01_mangos_achievement_criteria_data bit;
3 DROP TABLE IF EXISTS `achievement_criteria_data`;
4 CREATE TABLE `achievement_criteria_data` (
5 `criteria_id` mediumint(8) NOT NULL,
6 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
7 `value1` mediumint(8) unsigned NOT NULL DEFAULT '0',
8 `value2` mediumint(8) unsigned NOT NULL DEFAULT '0',
9 PRIMARY KEY (`criteria_id`)
10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system';