From 388eb93ce6e75c7345a9503f3e274bc89767f17b Mon Sep 17 00:00:00 2001 From: tkrokli Date: Wed, 14 Feb 2018 19:51:00 +0100 Subject: DB/updates: files renamed in chronological order These files were wrongly named and would be read in the wrong order when applied on local DB. --- sql/updates/world/3.3.5/2018_02_14_01_world.sql | 5 ----- sql/updates/world/3.3.5/2018_02_14_02_world.sql | 4 ++++ sql/updates/world/3.3.5/2018_02_14_03_world.sql | 5 +++++ sql/updates/world/3.3.5/2018_02_14_08_world.sql | 4 ---- 4 files changed, 9 insertions(+), 9 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2018_02_14_01_world.sql create mode 100644 sql/updates/world/3.3.5/2018_02_14_02_world.sql create mode 100644 sql/updates/world/3.3.5/2018_02_14_03_world.sql delete mode 100644 sql/updates/world/3.3.5/2018_02_14_08_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2018_02_14_01_world.sql b/sql/updates/world/3.3.5/2018_02_14_01_world.sql deleted file mode 100644 index 097e6453681..00000000000 --- a/sql/updates/world/3.3.5/2018_02_14_01_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- -UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32495 AND `source_type`=0 AND `id`=0; -UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=20405 AND `source_type`=0; -UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32357 AND `source_type`=0 AND `id`=0; -UPDATE `smart_scripts` SET `target_type`=2 WHERE `event_type`=0 AND `target_type`=7 AND `source_type`=0; diff --git a/sql/updates/world/3.3.5/2018_02_14_02_world.sql b/sql/updates/world/3.3.5/2018_02_14_02_world.sql new file mode 100644 index 00000000000..f5d3bf5b3ab --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_14_02_world.sql @@ -0,0 +1,4 @@ +-- +UPDATE `smart_scripts` SET `target_type`=7 WHERE `event_type` IN (4) AND `target_type`=2; +UPDATE `smart_scripts` SET `target_type`=16 WHERE `event_type` IN (4) AND `target_type`=5; +UPDATE `smart_scripts` SET `event_type`=0 WHERE `entryorguid`=18701 AND `source_type`=0 AND `id`=1; diff --git a/sql/updates/world/3.3.5/2018_02_14_03_world.sql b/sql/updates/world/3.3.5/2018_02_14_03_world.sql new file mode 100644 index 00000000000..097e6453681 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_02_14_03_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32495 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=20405 AND `source_type`=0; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `entryorguid`=32357 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=2 WHERE `event_type`=0 AND `target_type`=7 AND `source_type`=0; diff --git a/sql/updates/world/3.3.5/2018_02_14_08_world.sql b/sql/updates/world/3.3.5/2018_02_14_08_world.sql deleted file mode 100644 index f5d3bf5b3ab..00000000000 --- a/sql/updates/world/3.3.5/2018_02_14_08_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -UPDATE `smart_scripts` SET `target_type`=7 WHERE `event_type` IN (4) AND `target_type`=2; -UPDATE `smart_scripts` SET `target_type`=16 WHERE `event_type` IN (4) AND `target_type`=5; -UPDATE `smart_scripts` SET `event_type`=0 WHERE `entryorguid`=18701 AND `source_type`=0 AND `id`=1; -- cgit v1.2.3