[7855] Add description command to pool_* tables for simplify DB development. Author: Seizerkiller

    Note: this fields not used and not loaded by mangos.

--HG--
branch : trunk

2 files changed, 18 insertions, 1 deletions

diff --git a/sql/mangos.sql b/sql/mangos.sql
index 9b7a4e03519..96da5218048 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
   `creature_ai_version` varchar(120) default NULL,
-  `required_7850_01_mangos_command` bit(1) default NULL
+  `required_7855_01_mangos_pools` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -12959,6 +12959,7 @@ 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',
+  `description` varchar(255) NOT NULL,
   PRIMARY KEY  (`pool_entry`,`guid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -12981,6 +12982,7 @@ CREATE TABLE `pool_gameobject` (
   `guid` int(10) unsigned NOT NULL default '0',
   `pool_entry` mediumint(8) unsigned NOT NULL default '0',
   `chance` float unsigned NOT NULL default '0',
+  `description` varchar(255) NOT NULL,
   PRIMARY KEY  (`guid`,`pool_entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -13002,6 +13004,7 @@ CREATE TABLE `pool_pool` (
   `pool_id` mediumint(8) unsigned NOT NULL default '0',
   `mother_pool` mediumint(8) unsigned NOT NULL default '0',
   `chance` float NOT NULL default '0',
+  `description` varchar(255) NOT NULL,
   PRIMARY KEY  (`pool_id`,`mother_pool`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -13022,6 +13025,7 @@ 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',
+  `description` varchar(255) NOT NULL,
   PRIMARY KEY  (`entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
diff --git a/sql/updates/7855_01_mangos_pools.sql b/sql/updates/7855_01_mangos_pools.sql
new file mode 100644
index 00000000000..b5ac676c3e1
--- /dev/null
+++ b/sql/updates/7855_01_mangos_pools.sql
@@ -0,0 +1,13 @@
+ALTER TABLE db_version CHANGE COLUMN required_7850_01_mangos_command required_7855_01_mangos_pools bit;
+
+ALTER TABLE pool_creature
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_gameobject
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_pool
+  ADD COLUMN description varchar(255) NOT NULL AFTER chance;
+
+ALTER TABLE pool_template
+  ADD COLUMN description varchar(255) NOT NULL AFTER max_limit;