DB/Areatrigger: Fix typo in 21006f82efc25f3597d992d38b56bb292f22f334

1 files changed, 7 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_02_19_01_world.sql b/sql/updates/world/master/2017_02_19_01_world.sql
new file mode 100644
index 00000000000..70260fe254e
--- /dev/null
+++ b/sql/updates/world/master/2017_02_19_01_world.sql
@@ -0,0 +1,7 @@
+UPDATE
+  `areatrigger_template_polygon_vertices`
+SET
+  `VerticeTargetX` = NULL,
+  `VerticeTargetY` = NULL
+WHERE
+(`AreaTriggerId`=10713 AND `Idx`=3) OR (`AreaTriggerId`=10713 AND `Idx`=2) OR (`AreaTriggerId`=10713 AND `Idx`=1) OR (`AreaTriggerId`=10713 AND `Idx`=0) OR (`AreaTriggerId`=11662 AND `Idx`=32) OR (`AreaTriggerId`=11662 AND `Idx`=31) OR (`AreaTriggerId`=11662 AND `Idx`=30) OR (`AreaTriggerId`=11662 AND `Idx`=29) OR (`AreaTriggerId`=11662 AND `Idx`=28) OR (`AreaTriggerId`=11662 AND `Idx`=27) OR (`AreaTriggerId`=11662 AND `Idx`=26) OR (`AreaTriggerId`=11662 AND `Idx`=25) OR (`AreaTriggerId`=11662 AND `Idx`=24) OR (`AreaTriggerId`=11662 AND `Idx`=23) OR (`AreaTriggerId`=11662 AND `Idx`=22) OR (`AreaTriggerId`=11662 AND `Idx`=21) OR (`AreaTriggerId`=11662 AND `Idx`=20) OR (`AreaTriggerId`=11662 AND `Idx`=19) OR (`AreaTriggerId`=11662 AND `Idx`=18) OR (`AreaTriggerId`=11662 AND `Idx`=17) OR (`AreaTriggerId`=11662 AND `Idx`=16) OR (`AreaTriggerId`=11662 AND `Idx`=15) OR (`AreaTriggerId`=11662 AND `Idx`=14) OR (`AreaTriggerId`=11662 AND `Idx`=13) OR (`AreaTriggerId`=11662 AND `Idx`=12) OR (`AreaTriggerId`=11662 AND `Idx`=11) OR (`AreaTriggerId`=11662 AND `Idx`=10) OR (`AreaTriggerId`=11662 AND `Idx`=9) OR (`AreaTriggerId`=11662 AND `Idx`=8) OR (`AreaTriggerId`=11662 AND `Idx`=7) OR (`AreaTriggerId`=11662 AND `Idx`=6) OR (`AreaTriggerId`=11662 AND `Idx`=5) OR (`AreaTriggerId`=11662 AND `Idx`=4) OR (`AreaTriggerId`=11662 AND `Idx`=3) OR (`AreaTriggerId`=11662 AND `Idx`=2) OR (`AreaTriggerId`=11662 AND `Idx`=1) OR (`AreaTriggerId`=11662 AND `Idx`=0) OR (`AreaTriggerId`=10347 AND `Idx`=3) OR (`AreaTriggerId`=10347 AND `Idx`=2) OR (`AreaTriggerId`=10347 AND `Idx`=1) OR (`AreaTriggerId`=10347 AND `Idx`=0) OR (`AreaTriggerId`=10067 AND `Idx`=3) OR (`AreaTriggerId`=10067 AND `Idx`=2) OR (`AreaTriggerId`=10067 AND `Idx`=1) OR (`AreaTriggerId`=10067 AND `Idx`=0) OR (`AreaTriggerId`=9758 AND `Idx`=6) OR (`AreaTriggerId`=9758 AND `Idx`=5) OR (`AreaTriggerId`=9758 AND `Idx`=4) OR (`AreaTriggerId`=9758 AND `Idx`=3) OR (`AreaTriggerId`=9758 AND `Idx`=2) OR (`AreaTriggerId`=9758 AND `Idx`=1) OR (`AreaTriggerId`=9758 AND `Idx`=0) OR (`AreaTriggerId`=10374 AND `Idx`=3) OR (`AreaTriggerId`=10374 AND `Idx`=2) OR (`AreaTriggerId`=10374 AND `Idx`=1) OR (`AreaTriggerId`=10374 AND `Idx`=0) OR (`AreaTriggerId`=9677 AND `Idx`=3) OR (`AreaTriggerId`=9677 AND `Idx`=2) OR (`AreaTriggerId`=9677 AND `Idx`=1) OR (`AreaTriggerId`=9677 AND `Idx`=0) OR (`AreaTriggerId`=12689 AND `Idx`=3) OR (`AreaTriggerId`=12689 AND `Idx`=2) OR (`AreaTriggerId`=12689 AND `Idx`=1) OR (`AreaTriggerId`=12689 AND `Idx`=0) OR (`AreaTriggerId`=9681 AND `Idx`=3) OR (`AreaTriggerId`=9681 AND `Idx`=2) OR (`AreaTriggerId`=9681 AND `Idx`=1) OR (`AreaTriggerId`=9681 AND `Idx`=0) OR (`AreaTriggerId`=11986 AND `Idx`=3) OR (`AreaTriggerId`=11986 AND `Idx`=2) OR (`AreaTriggerId`=11986 AND `Idx`=1) OR (`AreaTriggerId`=11986 AND `Idx`=0) OR (`AreaTriggerId`=9791 AND `Idx`=3) OR (`AreaTriggerId`=9791 AND `Idx`=2) OR (`AreaTriggerId`=9791 AND `Idx`=1) OR (`AreaTriggerId`=9791 AND `Idx`=0) OR (`AreaTriggerId`=11361 AND `Idx`=3) OR (`AreaTriggerId`=11361 AND `Idx`=2) OR (`AreaTriggerId`=11361 AND `Idx`=1) OR (`AreaTriggerId`=11361 AND `Idx`=0) OR (`AreaTriggerId`=10057 AND `Idx`=11) OR (`AreaTriggerId`=10057 AND `Idx`=10) OR (`AreaTriggerId`=10057 AND `Idx`=9) OR (`AreaTriggerId`=10057 AND `Idx`=8) OR (`AreaTriggerId`=10057 AND `Idx`=7) OR (`AreaTriggerId`=10057 AND `Idx`=6) OR (`AreaTriggerId`=10057 AND `Idx`=5) OR (`AreaTriggerId`=10057 AND `Idx`=4) OR (`AreaTriggerId`=10057 AND `Idx`=3) OR (`AreaTriggerId`=10057 AND `Idx`=2) OR (`AreaTriggerId`=10057 AND `Idx`=1) OR (`AreaTriggerId`=10057 AND `Idx`=0) OR (`AreaTriggerId`=9786 AND `Idx`=3) OR (`AreaTriggerId`=9786 AND `Idx`=2) OR (`AreaTriggerId`=9786 AND `Idx`=1) OR (`AreaTriggerId`=9786 AND `Idx`=0) OR (`AreaTriggerId`=11847 AND `Idx`=3) OR (`AreaTriggerId`=11847 AND `Idx`=2) OR (`AreaTriggerId`=11847 AND `Idx`=1) OR (`AreaTriggerId`=11847 AND `Idx`=0) OR (`AreaTriggerId`=11960 AND `Idx`=3) OR (`AreaTriggerId`=11960 AND `Idx`=2) OR (`AreaTriggerId`=11960 AND `Idx`=1) OR (`AreaTriggerId`=11960 AND `Idx`=0) OR (`AreaTriggerId`=6197 AND `Idx`=8) OR (`AreaTriggerId`=6197 AND `Idx`=7) OR (`AreaTriggerId`=6197 AND `Idx`=6) OR (`AreaTriggerId`=6197 AND `Idx`=5) OR (`AreaTriggerId`=6197 AND `Idx`=4) OR (`AreaTriggerId`=6197 AND `Idx`=3) OR (`AreaTriggerId`=6197 AND `Idx`=2) OR (`AreaTriggerId`=6197 AND `Idx`=1) OR (`AreaTriggerId`=6197 AND `Idx`=0) OR (`AreaTriggerId`=10005 AND `Idx`=3) OR (`AreaTriggerId`=10005 AND `Idx`=2) OR (`AreaTriggerId`=10005 AND `Idx`=1) OR (`AreaTriggerId`=10005 AND `Idx`=0) OR (`AreaTriggerId`=9994 AND `Idx`=3) OR (`AreaTriggerId`=9994 AND `Idx`=2) OR (`AreaTriggerId`=9994 AND `Idx`=1) OR (`AreaTriggerId`=9994 AND `Idx`=0) OR (`AreaTriggerId`=7813 AND `Idx`=31) OR (`AreaTriggerId`=7813 AND `Idx`=30) OR (`AreaTriggerId`=7813 AND `Idx`=29) OR (`AreaTriggerId`=7813 AND `Idx`=28) OR (`AreaTriggerId`=7813 AND `Idx`=27) OR (`AreaTriggerId`=7813 AND `Idx`=26) OR (`AreaTriggerId`=7813 AND `Idx`=25) OR (`AreaTriggerId`=7813 AND `Idx`=24) OR (`AreaTriggerId`=7813 AND `Idx`=23) OR (`AreaTriggerId`=7813 AND `Idx`=22) OR (`AreaTriggerId`=7813 AND `Idx`=21) OR (`AreaTriggerId`=7813 AND `Idx`=20) OR (`AreaTriggerId`=7813 AND `Idx`=19) OR (`AreaTriggerId`=7813 AND `Idx`=18) OR (`AreaTriggerId`=7813 AND `Idx`=17) OR (`AreaTriggerId`=7813 AND `Idx`=16) OR (`AreaTriggerId`=7813 AND `Idx`=15) OR (`AreaTriggerId`=7813 AND `Idx`=14) OR (`AreaTriggerId`=7813 AND `Idx`=13) OR (`AreaTriggerId`=7813 AND `Idx`=12) OR (`AreaTriggerId`=7813 AND `Idx`=11) OR (`AreaTriggerId`=7813 AND `Idx`=10) OR (`AreaTriggerId`=7813 AND `Idx`=9) OR (`AreaTriggerId`=7813 AND `Idx`=8) OR (`AreaTriggerId`=7813 AND `Idx`=7) OR (`AreaTriggerId`=7813 AND `Idx`=6) OR (`AreaTriggerId`=7813 AND `Idx`=5) OR (`AreaTriggerId`=7813 AND `Idx`=4) OR (`AreaTriggerId`=7813 AND `Idx`=3) OR (`AreaTriggerId`=7813 AND `Idx`=2) OR (`AreaTriggerId`=7813 AND `Idx`=1) OR (`AreaTriggerId`=7813 AND `Idx`=0) OR (`AreaTriggerId`=10700 AND `Idx`=3) OR (`AreaTriggerId`=10700 AND `Idx`=2) OR (`AreaTriggerId`=10700 AND `Idx`=1) OR (`AreaTriggerId`=10700 AND `Idx`=0) OR (`AreaTriggerId`=10447 AND `Idx`=42) OR (`AreaTriggerId`=10447 AND `Idx`=41) OR (`AreaTriggerId`=10447 AND `Idx`=40) OR (`AreaTriggerId`=10447 AND `Idx`=39) OR (`AreaTriggerId`=10447 AND `Idx`=38) OR (`AreaTriggerId`=10447 AND `Idx`=37) OR (`AreaTriggerId`=10447 AND `Idx`=36) OR (`AreaTriggerId`=10447 AND `Idx`=35) OR (`AreaTriggerId`=10447 AND `Idx`=34) OR (`AreaTriggerId`=10447 AND `Idx`=33) OR (`AreaTriggerId`=10447 AND `Idx`=32) OR (`AreaTriggerId`=10447 AND `Idx`=31) OR (`AreaTriggerId`=10447 AND `Idx`=30) OR (`AreaTriggerId`=10447 AND `Idx`=29) OR (`AreaTriggerId`=10447 AND `Idx`=28) OR (`AreaTriggerId`=10447 AND `Idx`=27) OR (`AreaTriggerId`=10447 AND `Idx`=26) OR (`AreaTriggerId`=10447 AND `Idx`=25) OR (`AreaTriggerId`=10447 AND `Idx`=24) OR (`AreaTriggerId`=10447 AND `Idx`=23) OR (`AreaTriggerId`=10447 AND `Idx`=22) OR (`AreaTriggerId`=10447 AND `Idx`=21) OR (`AreaTriggerId`=10447 AND `Idx`=20) OR (`AreaTriggerId`=10447 AND `Idx`=19) OR (`AreaTriggerId`=10447 AND `Idx`=18) OR (`AreaTriggerId`=10447 AND `Idx`=17) OR (`AreaTriggerId`=10447 AND `Idx`=16) OR (`AreaTriggerId`=10447 AND `Idx`=15) OR (`AreaTriggerId`=10447 AND `Idx`=14) OR (`AreaTriggerId`=10447 AND `Idx`=13) OR (`AreaTriggerId`=10447 AND `Idx`=12) OR (`AreaTriggerId`=10447 AND `Idx`=11) OR (`AreaTriggerId`=10447 AND `Idx`=10) OR (`AreaTriggerId`=10447 AND `Idx`=9) OR (`AreaTriggerId`=10447 AND `Idx`=8) OR (`AreaTriggerId`=10447 AND `Idx`=7) OR (`AreaTriggerId`=10447 AND `Idx`=6) OR (`AreaTriggerId`=10447 AND `Idx`=5) OR (`AreaTriggerId`=10447 AND `Idx`=4) OR (`AreaTriggerId`=10447 AND `Idx`=3) OR (`AreaTriggerId`=10447 AND `Idx`=2) OR (`AreaTriggerId`=10447 AND `Idx`=1) OR (`AreaTriggerId`=10447 AND `Idx`=0) OR (`AreaTriggerId`=10447 AND `Idx`=156) OR (`AreaTriggerId`=10447 AND `Idx`=155) OR (`AreaTriggerId`=10447 AND `Idx`=154) OR (`AreaTriggerId`=10447 AND `Idx`=153) OR (`AreaTriggerId`=10447 AND `Idx`=152) OR (`AreaTriggerId`=10447 AND `Idx`=151) OR (`AreaTriggerId`=10447 AND `Idx`=150) OR (`AreaTriggerId`=10447 AND `Idx`=149) OR (`AreaTriggerId`=10447 AND `Idx`=148) OR (`AreaTriggerId`=10447 AND `Idx`=147) OR (`AreaTriggerId`=10447 AND `Idx`=146) OR (`AreaTriggerId`=10447 AND `Idx`=145) OR (`AreaTriggerId`=10447 AND `Idx`=144) OR (`AreaTriggerId`=10447 AND `Idx`=143) OR (`AreaTriggerId`=10447 AND `Idx`=142) OR (`AreaTriggerId`=10447 AND `Idx`=141) OR (`AreaTriggerId`=10447 AND `Idx`=140) OR (`AreaTriggerId`=10447 AND `Idx`=139) OR (`AreaTriggerId`=10447 AND `Idx`=138) OR (`AreaTriggerId`=10447 AND `Idx`=137) OR (`AreaTriggerId`=10447 AND `Idx`=136) OR (`AreaTriggerId`=10447 AND `Idx`=135) OR (`AreaTriggerId`=10447 AND `Idx`=134) OR (`AreaTriggerId`=10447 AND `Idx`=133) OR (`AreaTriggerId`=10447 AND `Idx`=132) OR (`AreaTriggerId`=10447 AND `Idx`=131) OR (`AreaTriggerId`=10447 AND `Idx`=130) OR (`AreaTriggerId`=10447 AND `Idx`=129) OR (`AreaTriggerId`=10447 AND `Idx`=128) OR (`AreaTriggerId`=10447 AND `Idx`=127) OR (`AreaTriggerId`=10447 AND `Idx`=126) OR (`AreaTriggerId`=10447 AND `Idx`=125) OR (`AreaTriggerId`=10447 AND `Idx`=124) OR (`AreaTriggerId`=10447 AND `Idx`=123) OR (`AreaTriggerId`=10447 AND `Idx`=122) OR (`AreaTriggerId`=10447 AND `Idx`=121) OR (`AreaTriggerId`=10447 AND `Idx`=120) OR (`AreaTriggerId`=10447 AND `Idx`=119) OR (`AreaTriggerId`=10447 AND `Idx`=118) OR (`AreaTriggerId`=10447 AND `Idx`=117) OR (`AreaTriggerId`=10447 AND `Idx`=116) OR (`AreaTriggerId`=10447 AND `Idx`=115) OR (`AreaTriggerId`=10447 AND `Idx`=114) OR (`AreaTriggerId`=10447 AND `Idx`=113) OR (`AreaTriggerId`=10447 AND `Idx`=112) OR (`AreaTriggerId`=10447 AND `Idx`=111) OR (`AreaTriggerId`=10447 AND `Idx`=110) OR (`AreaTriggerId`=10447 AND `Idx`=109) OR (`AreaTriggerId`=10447 AND `Idx`=108) OR (`AreaTriggerId`=10447 AND `Idx`=107) OR (`AreaTriggerId`=10447 AND `Idx`=106) OR (`AreaTriggerId`=10447 AND `Idx`=105) OR (`AreaTriggerId`=10447 AND `Idx`=104) OR (`AreaTriggerId`=10447 AND `Idx`=103) OR (`AreaTriggerId`=10447 AND `Idx`=102) OR (`AreaTriggerId`=10447 AND `Idx`=101) OR (`AreaTriggerId`=10447 AND `Idx`=100) OR (`AreaTriggerId`=10447 AND `Idx`=99) OR (`AreaTriggerId`=10447 AND `Idx`=98) OR (`AreaTriggerId`=10447 AND `Idx`=97) OR (`AreaTriggerId`=10447 AND `Idx`=96) OR (`AreaTriggerId`=10447 AND `Idx`=95) OR (`AreaTriggerId`=10447 AND `Idx`=94) OR (`AreaTriggerId`=10447 AND `Idx`=93) OR (`AreaTriggerId`=10447 AND `Idx`=92) OR (`AreaTriggerId`=10447 AND `Idx`=91) OR (`AreaTriggerId`=10447 AND `Idx`=90) OR (`AreaTriggerId`=10447 AND `Idx`=89) OR (`AreaTriggerId`=10447 AND `Idx`=88) OR (`AreaTriggerId`=10447 AND `Idx`=87) OR (`AreaTriggerId`=10447 AND `Idx`=86) OR (`AreaTriggerId`=10447 AND `Idx`=85) OR (`AreaTriggerId`=10447 AND `Idx`=84) OR (`AreaTriggerId`=10447 AND `Idx`=83) OR (`AreaTriggerId`=10447 AND `Idx`=82) OR (`AreaTriggerId`=10447 AND `Idx`=81) OR (`AreaTriggerId`=10447 AND `Idx`=80) OR (`AreaTriggerId`=10447 AND `Idx`=79) OR (`AreaTriggerId`=10447 AND `Idx`=78) OR (`AreaTriggerId`=10447 AND `Idx`=77) OR (`AreaTriggerId`=10447 AND `Idx`=76) OR (`AreaTriggerId`=10447 AND `Idx`=75) OR (`AreaTriggerId`=10447 AND `Idx`=74) OR (`AreaTriggerId`=10447 AND `Idx`=73) OR (`AreaTriggerId`=10447 AND `Idx`=72) OR (`AreaTriggerId`=10447 AND `Idx`=71) OR (`AreaTriggerId`=10447 AND `Idx`=70) OR (`AreaTriggerId`=10447 AND `Idx`=69) OR (`AreaTriggerId`=10447 AND `Idx`=68) OR (`AreaTriggerId`=10447 AND `Idx`=67) OR (`AreaTriggerId`=10447 AND `Idx`=66) OR (`AreaTriggerId`=10447 AND `Idx`=65) OR (`AreaTriggerId`=10447 AND `Idx`=64) OR (`AreaTriggerId`=10447 AND `Idx`=63) OR (`AreaTriggerId`=10447 AND `Idx`=62) OR (`AreaTriggerId`=10447 AND `Idx`=61) OR (`AreaTriggerId`=10447 AND `Idx`=60) OR (`AreaTriggerId`=10447 AND `Idx`=59) OR (`AreaTriggerId`=10447 AND `Idx`=58) OR (`AreaTriggerId`=10447 AND `Idx`=57) OR (`AreaTriggerId`=10447 AND `Idx`=56) OR (`AreaTriggerId`=10447 AND `Idx`=55) OR (`AreaTriggerId`=10447 AND `Idx`=54) OR (`AreaTriggerId`=10447 AND `Idx`=53) OR (`AreaTriggerId`=10447 AND `Idx`=52) OR (`AreaTriggerId`=10447 AND `Idx`=51) OR (`AreaTriggerId`=10447 AND `Idx`=50) OR (`AreaTriggerId`=10447 AND `Idx`=49) OR (`AreaTriggerId`=10447 AND `Idx`=48) OR (`AreaTriggerId`=10447 AND `Idx`=47) OR (`AreaTriggerId`=10447 AND `Idx`=46) OR (`AreaTriggerId`=10447 AND `Idx`=45) OR (`AreaTriggerId`=10447 AND `Idx`=44) OR (`AreaTriggerId`=10447 AND `Idx`=43) OR (`AreaTriggerId`=12509 AND `Idx`=3) OR (`AreaTriggerId`=12509 AND `Idx`=2) OR (`AreaTriggerId`=12509 AND `Idx`=1) OR (`AreaTriggerId`=12509 AND `Idx`=0) OR (`AreaTriggerId`=11837 AND `Idx`=3) OR (`AreaTriggerId`=11837 AND `Idx`=2) OR (`AreaTriggerId`=11837 AND `Idx`=1) OR (`AreaTriggerId`=11837 AND `Idx`=0) OR (`AreaTriggerId`=11894 AND `Idx`=3) OR (`AreaTriggerId`=11894 AND `Idx`=2) OR (`AreaTriggerId`=11894 AND `Idx`=1) OR (`AreaTriggerId`=11894 AND `Idx`=0) OR (`AreaTriggerId`=10366 AND `Idx`=3) OR (`AreaTriggerId`=10366 AND `Idx`=2) OR (`AreaTriggerId`=10366 AND `Idx`=1) OR (`AreaTriggerId`=10366 AND `Idx`=0);