diff options
| author | megamage <none@none> | 2009-01-31 16:38:50 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-01-31 16:38:50 -0600 |
| commit | 336e8501f0e8c6cede5356347a8c6894e39197b5 (patch) | |
| tree | 3dd2e47833be51ea6d2ff4f64b0655dd149b0553 /sql/mangos.sql | |
| parent | 4074b481f0a95bec47d8ce9ed275acf46ff95a8e (diff) | |
*Update to Mangos 7208. Implement phase system.
--HG--
branch : trunk
Diffstat (limited to 'sql/mangos.sql')
| -rw-r--r-- | sql/mangos.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index 2c4d418f13a..a7a33184493 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_7205_01_mangos_spell_chain` bit(1) default NULL + `required_7207_02_mangos_gameobject` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -488,6 +488,7 @@ CREATE TABLE `creature` ( `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Creature Identifier', `map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier', `spawnMask` tinyint(3) unsigned NOT NULL default '1', + `phaseMask` smallint(5) unsigned NOT NULL default '1', `modelid` mediumint(8) unsigned NOT NULL default '0', `equipment_id` mediumint(9) NOT NULL default '0', `position_x` float NOT NULL default '0', @@ -1244,6 +1245,7 @@ CREATE TABLE `gameobject` ( `id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Gameobject Identifier', `map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier', `spawnMask` tinyint(3) unsigned NOT NULL default '1', + `phaseMask` smallint(5) unsigned NOT NULL default '1', `position_x` float NOT NULL default '0', `position_y` float NOT NULL default '0', `position_z` float NOT NULL default '0', |