From 4682ba0f5534c27a504f67366a844d9b940a6ff2 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 17 Jan 2016 18:14:53 +0100 Subject: DB: Rename file --- sql/updates/world/2016_01_17_011_world.sql | 30 ------------------------------ sql/updates/world/2016_01_17_12_world.sql | 30 ++++++++++++++++++++++++++++++ 2 files changed, 30 insertions(+), 30 deletions(-) delete mode 100644 sql/updates/world/2016_01_17_011_world.sql create mode 100644 sql/updates/world/2016_01_17_12_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2016_01_17_011_world.sql b/sql/updates/world/2016_01_17_011_world.sql deleted file mode 100644 index e4e8ab5e9e2..00000000000 --- a/sql/updates/world/2016_01_17_011_world.sql +++ /dev/null @@ -1,30 +0,0 @@ --- -SET @pool_id=369; -SET @GUID=87572; -DELETE FROM `pool_template` WHERE `entry` = @pool_id; -INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES -(@pool_id, 5, 'Ethereum Jailor'); - -DELETE FROM `pool_creature` WHERE `guid` BETWEEN @GUID AND @GUID+20; -INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES -(@GUID+0, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+1, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+2, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+3, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+4, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+5, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+6, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+7, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+8, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+9, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+10, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+11, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+12, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+13, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+14, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+15, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+16, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+17, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+18, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+19, @pool_id, 0, 'Ethereum Jailor'), -(@Guid+20, @pool_id, 0, 'Ethereum Jailor'); diff --git a/sql/updates/world/2016_01_17_12_world.sql b/sql/updates/world/2016_01_17_12_world.sql new file mode 100644 index 00000000000..e4e8ab5e9e2 --- /dev/null +++ b/sql/updates/world/2016_01_17_12_world.sql @@ -0,0 +1,30 @@ +-- +SET @pool_id=369; +SET @GUID=87572; +DELETE FROM `pool_template` WHERE `entry` = @pool_id; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@pool_id, 5, 'Ethereum Jailor'); + +DELETE FROM `pool_creature` WHERE `guid` BETWEEN @GUID AND @GUID+20; +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(@GUID+0, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+1, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+2, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+3, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+4, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+5, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+6, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+7, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+8, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+9, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+10, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+11, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+12, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+13, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+14, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+15, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+16, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+17, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+18, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+19, @pool_id, 0, 'Ethereum Jailor'), +(@Guid+20, @pool_id, 0, 'Ethereum Jailor'); -- cgit v1.2.3