diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 3 | ||||
| -rw-r--r-- | sql/mangos.sql | 4 | ||||
| -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 |
5 files changed, 17 insertions, 2 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index fcd5cc08ffc..c1159d1bd47 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -21,7 +21,7 @@ DROP TABLE IF EXISTS `character_db_version`; CREATE TABLE `character_db_version` ( - `required_7198_01_characters_characters` bit(1) default NULL + `required_7207_03_characters_corpse` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; -- @@ -787,6 +787,7 @@ CREATE TABLE `corpse` ( `orientation` float NOT NULL default '0', `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier', `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', + `phaseMask` smallint(5) unsigned NOT NULL default '1', `data` longtext, `time` bigint(20) unsigned NOT NULL default '0', `corpse_type` tinyint(3) unsigned NOT NULL default '0', 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', 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`; |