diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 3 | ||||
| -rw-r--r-- | sql/updates/7558_01_mangos_mangos_string.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7560_01_mangos_gameobject_template.sql | 4 |
3 files changed, 7 insertions, 2 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index ada50d50803..a80eaa80f5c 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_7558_02_mangos_command` bit(1) default NULL + `required_7560_01_mangos_gameobject_template` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -1408,6 +1408,7 @@ CREATE TABLE `gameobject_template` ( `type` tinyint(3) unsigned NOT NULL default '0', `displayId` mediumint(8) unsigned NOT NULL default '0', `name` varchar(100) NOT NULL default '', + `IconName` varchar(100) NOT NULL default '', `castBarCaption` varchar(100) NOT NULL default '', `faction` smallint(5) unsigned NOT NULL default '0', `flags` int(10) unsigned NOT NULL default '0', diff --git a/sql/updates/7558_01_mangos_mangos_string.sql b/sql/updates/7558_01_mangos_mangos_string.sql index 79012b791ad..c0b856a9814 100644 --- a/sql/updates/7558_01_mangos_mangos_string.sql +++ b/sql/updates/7558_01_mangos_mangos_string.sql @@ -1,6 +1,6 @@ ALTER TABLE db_version CHANGE COLUMN required_7544_01_mangos_uptime required_7558_01_mangos_mangos_string bit; -DELETE FROM mangos_string WHERE entry IN (1123,1124,1125); +DELETE FROM mangos_string WHERE entry IN (1123,1124,1125,1126,1127); INSERT INTO mangos_string VALUES (1123,'Not pet found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1124,'Wrong pet type',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), diff --git a/sql/updates/7560_01_mangos_gameobject_template.sql b/sql/updates/7560_01_mangos_gameobject_template.sql new file mode 100644 index 00000000000..f980687c777 --- /dev/null +++ b/sql/updates/7560_01_mangos_gameobject_template.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7558_02_mangos_command required_7560_01_mangos_gameobject_template bit; + +ALTER TABLE gameobject_template + ADD COLUMN IconName varchar(100) NOT NULL default '' AFTER name; |