Removed useless comment columns from the pool system DB tables.

--HG--
branch : trunk

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`;