diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7299_01_mangos_pools.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/7299_01_mangos_pools.sql b/sql/updates/7299_01_mangos_pools.sql index 0b212fd7378..afc3c88cb26 100644 --- a/sql/updates/7299_01_mangos_pools.sql +++ b/sql/updates/7299_01_mangos_pools.sql @@ -12,6 +12,13 @@ CREATE TABLE `pool_gameobject` ( PRIMARY KEY (`guid`,`pool_entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; +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', + PRIMARY KEY (`pool_id`,`mother_pool`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + 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', |