[7303] Fixed sql changes part of pool patch. Author: VladimirMangos

--HG--
branch : trunk

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/7299_01_mangos_pools.sql b/sql/updates/7303_01_mangos_pools.sql
index afc3c88cb26..9d8a6d677ab 100644
--- a/sql/updates/7299_01_mangos_pools.sql
+++ b/sql/updates/7303_01_mangos_pools.sql
@@ -1,3 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7292_02_mangos_locales_points_of_interest required_7303_01_mangos_pools bit;
+
+DROP TABLE IF EXISTS `pool_creature`;
 CREATE TABLE `pool_creature` (
   `guid` int(10) unsigned NOT NULL default '0',
   `pool_entry` mediumint(8) unsigned NOT NULL default '0',
@@ -5,6 +8,7 @@ CREATE TABLE `pool_creature` (
   PRIMARY KEY  (`pool_entry`,`guid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+DROP TABLE IF EXISTS `pool_gameobject`;
 CREATE TABLE `pool_gameobject` (
   `guid` int(10) unsigned NOT NULL default '0',
   `pool_entry` mediumint(8) unsigned NOT NULL default '0',
@@ -12,6 +16,7 @@ CREATE TABLE `pool_gameobject` (
   PRIMARY KEY  (`guid`,`pool_entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+DROP TABLE IF EXISTS `pool_pool`;
 CREATE TABLE `pool_pool` (
   `pool_id` mediumint(8) unsigned NOT NULL default '0',
   `mother_pool` mediumint(8) unsigned NOT NULL default '0',
@@ -19,12 +24,14 @@ CREATE TABLE `pool_pool` (
   PRIMARY KEY  (`pool_id`,`mother_pool`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+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',
   PRIMARY KEY  (`entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+DROP TABLE IF EXISTS `game_event_pool`;
 CREATE TABLE `game_event_pool` (
   `pool_entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Id of the pool',
   `event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',