From 371a58404743aa7294eee0096d7884018929e87b Mon Sep 17 00:00:00 2001 From: megamage Date: Wed, 8 Apr 2009 16:34:38 -0500 Subject: [7633] Implement support multiply basic requirements for crireria in `achievement_criteria_data`. Author: VladimirMangos Also implement additional basic requirements for proper implementing checks for ACHIEVEMENT_CRITERIA_TYPE_DO_EMOTE Req. DB support. --HG-- branch : trunk --- sql/mangos.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/mangos.sql') diff --git a/sql/mangos.sql b/sql/mangos.sql index 4ae50613a6d..bf6fbcfcef7 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_7627_01_mangos_achievement_criteria_data` bit(1) default NULL + `required_7633_01_mangos_achievement_criteria_data` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -46,7 +46,7 @@ CREATE TABLE `achievement_criteria_data` ( `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `value1` mediumint(8) unsigned NOT NULL DEFAULT '0', `value2` mediumint(8) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`criteria_id`) + PRIMARY KEY (`criteria_id`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'; -- -- cgit v1.2.3