diff options
| -rw-r--r-- | sql/base/world_database.sql | 2 | ||||
| -rw-r--r-- | sql/updates/8607_world_pool_creature.sql | 2 | ||||
| -rw-r--r-- | sql/updates/8607_world_pool_tempate.sql | 2 |
3 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 4ef57d79fdd..88d8e282749 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -4210,7 +4210,6 @@ CREATE TABLE `pool_creature` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `chance` float unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`pool_entry`,`guid`), KEY `idx_guid` (`guid`) @@ -4287,7 +4286,6 @@ DROP TABLE IF EXISTS `pool_template`; CREATE TABLE `pool_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', `max_limit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', - `comment` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/8607_world_pool_creature.sql b/sql/updates/8607_world_pool_creature.sql new file mode 100644 index 00000000000..400e54cc6b5 --- /dev/null +++ b/sql/updates/8607_world_pool_creature.sql @@ -0,0 +1,2 @@ +UPDATE `pool_creature` SET `description` = `comment` WHERE `comment` <> '' AND `comment` IS NOT NULL AND (`description` = '' OR `description` IS NULL); +ALTER TABLE `pool_creature` DROP COLUMN `comment`; diff --git a/sql/updates/8607_world_pool_tempate.sql b/sql/updates/8607_world_pool_tempate.sql new file mode 100644 index 00000000000..ac1cbf70223 --- /dev/null +++ b/sql/updates/8607_world_pool_tempate.sql @@ -0,0 +1,2 @@ +UPDATE `pool_template` SET `description` = `comment` WHERE `comment` <> '' AND `comment` IS NOT NULL AND (`description` = '' OR `description` IS NULL); +ALTER TABLE `pool_template` DROP COLUMN `comment`; |