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/updates | |
| parent | 4074b481f0a95bec47d8ce9ed275acf46ff95a8e (diff) | |
*Update to Mangos 7208. Implement phase system.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7207_01_mangos_creature.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7207_02_mangos_gameobject.sql | 4 | ||||
| -rw-r--r-- | sql/updates/7207_03_characters_corpse.sql | 4 |
3 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/7207_01_mangos_creature.sql b/sql/updates/7207_01_mangos_creature.sql new file mode 100644 index 00000000000..4145e70e2e8 --- /dev/null +++ b/sql/updates/7207_01_mangos_creature.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7205_01_mangos_spell_chain required_7207_01_mangos_creature bit; + +ALTER TABLE creature + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; diff --git a/sql/updates/7207_02_mangos_gameobject.sql b/sql/updates/7207_02_mangos_gameobject.sql new file mode 100644 index 00000000000..ecd53bb810e --- /dev/null +++ b/sql/updates/7207_02_mangos_gameobject.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7207_01_mangos_creature required_7207_02_mangos_gameobject bit; + +ALTER TABLE gameobject + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `spawnMask`; diff --git a/sql/updates/7207_03_characters_corpse.sql b/sql/updates/7207_03_characters_corpse.sql new file mode 100644 index 00000000000..b53c15e9038 --- /dev/null +++ b/sql/updates/7207_03_characters_corpse.sql @@ -0,0 +1,4 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7198_01_characters_characters required_7207_03_characters_corpse bit; + +ALTER TABLE corpse + ADD COLUMN `phaseMask` smallint(5) unsigned NOT NULL default '1' AFTER `map`; |