aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <none@none>2010-08-07 16:48:34 +0200
committerShauren <none@none>2010-08-07 16:48:34 +0200
commit431301c1b29103e444b5c534c17543c87a99e481 (patch)
tree748d5acb68d83a7cad74c9bd9c06cdbc08a5267e /sql
parented4e49a4e7f44e45ba5b81e5aaa6fe5dff584a5a (diff)
Added support for scripting achievement criteria checks using ACHIEVEMENT_CRITERIA_DATA_TYPE_SCRIPT (11)
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/9237_world_achievement_criteria_data.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index c2d92f8087a..11d1fbaf42e 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -61,6 +61,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',
+ `ScriptName` char(64) NOT NULL DEFAULT '',
PRIMARY KEY (`criteria_id`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system';
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/9237_world_achievement_criteria_data.sql b/sql/updates/9237_world_achievement_criteria_data.sql
new file mode 100644
index 00000000000..46045dc5500
--- /dev/null
+++ b/sql/updates/9237_world_achievement_criteria_data.sql
@@ -0,0 +1 @@
+ALTER TABLE `achievement_criteria_data` ADD `ScriptName` char(64) NOT NULL DEFAULT '' AFTER `value2`;