diff options
| author | n0n4m3 <none@none> | 2009-12-18 07:06:53 +0100 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2009-12-18 07:06:53 +0100 |
| commit | bb2ddadae99de1bd253886b4dcd394cb15997b64 (patch) | |
| tree | c906e93c2ca43d1f31fa9cc0249b9489a52aa8a8 /sql/world.sql | |
| parent | 304f59f2bb18439addc3da1471fae8d6dacbb8b2 (diff) | |
Added missing sql updates
--HG--
branch : trunk
Diffstat (limited to 'sql/world.sql')
| -rw-r--r-- | sql/world.sql | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/sql/world.sql b/sql/world.sql index 9b61e103991..68b353cc2b1 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -491,7 +491,9 @@ SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `creature_template` ( `entry` mediumint(8) unsigned NOT NULL default '0', - `heroic_entry` mediumint(8) unsigned NOT NULL default '0', + `difficulty_entry_1` mediumint(8) unsigned NOT NULL default '0', + `difficulty_entry_2` mediumint(8) unsigned NOT NULL default '0', + `difficulty_entry_3` mediumint(8) unsigned NOT NULL default '0', `unk1` int(11) unsigned NOT NULL default '0', `unk2` int(11) unsigned NOT NULL default '0', `modelid1` mediumint(8) unsigned NOT NULL default '0', @@ -1178,10 +1180,8 @@ SET character_set_client = utf8; CREATE TABLE `instance_template` ( `map` smallint(5) unsigned NOT NULL, `parent` int(10) unsigned NOT NULL, - `maxPlayers` tinyint(3) unsigned NOT NULL default '0', - `maxPlayersHeroic` tinyint(3) unsigned NOT NULL default '0', - `reset_delay` int(10) unsigned NOT NULL default '0', - `access_id` bigint(20) unsigned NOT NULL default '0', + `levelMin` tinyint(3) unsigned NOT NULL default '0', + `levelMax` tinyint(3) unsigned NOT NULL default '0', `startLocX` float default NULL, `startLocY` float default NULL, `startLocZ` float default NULL, @@ -2486,10 +2486,14 @@ CREATE TABLE `quest_template` ( `ReqItemId2` mediumint(8) unsigned NOT NULL default '0', `ReqItemId3` mediumint(8) unsigned NOT NULL default '0', `ReqItemId4` mediumint(8) unsigned NOT NULL default '0', + `ReqItemId5` mediumint(8) unsigned NOT NULL default '0', + `ReqItemId6` mediumint(8) unsigned NOT NULL default '0', `ReqItemCount1` smallint(5) unsigned NOT NULL default '0', `ReqItemCount2` smallint(5) unsigned NOT NULL default '0', `ReqItemCount3` smallint(5) unsigned NOT NULL default '0', `ReqItemCount4` smallint(5) unsigned NOT NULL default '0', + `ReqItemCount5` smallint(5) unsigned NOT NULL default '0', + `ReqItemCount6` smallint(5) unsigned NOT NULL default '0', `ReqSourceId1` mediumint(8) unsigned NOT NULL default '0', `ReqSourceId2` mediumint(8) unsigned NOT NULL default '0', `ReqSourceId3` mediumint(8) unsigned NOT NULL default '0', |