DB: Add some scene_template entries

Closes #22606

1 files changed, 138 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_10_09_00_world.sql b/sql/updates/world/master/2018_10_09_00_world.sql
new file mode 100644
index 00000000000..b32b162da12
--- /dev/null
+++ b/sql/updates/world/master/2018_10_09_00_world.sql
@@ -0,0 +1,138 @@
+-- 
+DELETE FROM `scene_template` WHERE (`SceneId`=1023 AND `ScriptPackageID`=1431) OR (`SceneId`=1046 AND `ScriptPackageID`=1434) OR (`SceneId`=855 AND `ScriptPackageID`=998) OR (`SceneId`=1047 AND `ScriptPackageID`=1433) OR (`SceneId`=612 AND `ScriptPackageID`=801) OR (`SceneId`=602 AND `ScriptPackageID`=788) OR (`SceneId`=613 AND `ScriptPackageID`=802) OR (`SceneId`=910 AND `ScriptPackageID`=1359) OR (`SceneId`=679 AND `ScriptPackageID`=867) OR (`SceneId`=667 AND `ScriptPackageID`=854) OR (`SceneId`=889 AND `ScriptPackageID`=1040) OR (`SceneId`=878 AND `ScriptPackageID`=1031) OR (`SceneId`=877 AND `ScriptPackageID`=1030) OR (`SceneId`=880 AND `ScriptPackageID`=1033) OR (`SceneId`=864 AND `ScriptPackageID`=1017) OR (`SceneId`=659 AND `ScriptPackageID`=847) OR (`SceneId`=660 AND `ScriptPackageID`=848) OR (`SceneId`=720 AND `ScriptPackageID`=898) OR (`SceneId`=60 AND `ScriptPackageID`=154) OR (`SceneId`=109 AND `ScriptPackageID`=263) OR (`SceneId`=35 AND `ScriptPackageID`=186) OR (`SceneId`=83 AND `ScriptPackageID`=223) OR (`SceneId`=82 AND `ScriptPackageID`=222) OR (`SceneId`=81 AND `ScriptPackageID`=221) OR (`SceneId`=84 AND `ScriptPackageID`=224) OR (`SceneId`=91 AND `ScriptPackageID`=241) OR (`SceneId`=94 AND `ScriptPackageID`=248) OR (`SceneId`=1022 AND `ScriptPackageID`=1405) OR (`SceneId`=638 AND `ScriptPackageID`=828) OR (`SceneId`=634 AND `ScriptPackageID`=824) OR (`SceneId`=632 AND `ScriptPackageID`=822) OR (`SceneId`=610 AND `ScriptPackageID`=800) OR (`SceneId`=521 AND `ScriptPackageID`=759) OR (`SceneId`=623 AND `ScriptPackageID`=810) OR (`SceneId`=743 AND `ScriptPackageID`=919) OR (`SceneId`=688 AND `ScriptPackageID`=873) OR (`SceneId`=508 AND `ScriptPackageID`=758) OR (`SceneId`=506 AND `ScriptPackageID`=756) OR (`SceneId`=490 AND `ScriptPackageID`=746) OR (`SceneId`=680 AND `ScriptPackageID`=868) OR (`SceneId`=675 AND `ScriptPackageID`=1361) OR (`SceneId`=907 AND `ScriptPackageID`=1358) OR (`SceneId`=757 AND `ScriptPackageID`=927) OR (`SceneId`=734 AND `ScriptPackageID`=907) OR (`SceneId`=424 AND `ScriptPackageID`=685) OR (`SceneId`=890 AND `ScriptPackageID`=1041) OR (`SceneId`=674 AND `ScriptPackageID`=862) OR (`SceneId`=670 AND `ScriptPackageID`=859) OR (`SceneId`=669 AND `ScriptPackageID`=856) OR (`SceneId`=653 AND `ScriptPackageID`=843) OR (`SceneId`=652 AND `ScriptPackageID`=842) OR (`SceneId`=815 AND `ScriptPackageID`=965) OR (`SceneId`=691 AND `ScriptPackageID`=879) OR (`SceneId`=692 AND `ScriptPackageID`=880) OR (`SceneId`=693 AND `ScriptPackageID`=881) OR (`SceneId`=696 AND `ScriptPackageID`=886) OR (`SceneId`=695 AND `ScriptPackageID`=884) OR (`SceneId`=708 AND `ScriptPackageID`=883) OR (`SceneId`=697 AND `ScriptPackageID`=885) OR (`SceneId`=709 AND `ScriptPackageID`=887) OR (`SceneId`=522 AND `ScriptPackageID`=760) OR (`SceneId`=276 AND `ScriptPackageID`=567) OR (`SceneId`=640 AND `ScriptPackageID`=830) OR (`SceneId`=635 AND `ScriptPackageID`=825) OR (`SceneId`=636 AND `ScriptPackageID`=826) OR (`SceneId`=637 AND `ScriptPackageID`=827) OR (`SceneId`=502 AND `ScriptPackageID`=752) OR (`SceneId`=658 AND `ScriptPackageID`=846) OR (`SceneId`=818 AND `ScriptPackageID`=986) OR (`SceneId`=740 AND `ScriptPackageID`=912) OR (`SceneId`=689 AND `ScriptPackageID`=871) OR (`SceneId`=723 AND `ScriptPackageID`=893) OR (`SceneId`=758 AND `ScriptPackageID`=928) OR (`SceneId`=732 AND `ScriptPackageID`=910) OR (`SceneId`=724 AND `ScriptPackageID`=894) OR (`SceneId`=730 AND `ScriptPackageID`=908) OR (`SceneId`=719 AND `ScriptPackageID`=896) OR (`SceneId`=831 AND `ScriptPackageID`=981) OR (`SceneId`=753 AND `ScriptPackageID`=922) OR (`SceneId`=801 AND `ScriptPackageID`=952) OR (`SceneId`=672 AND `ScriptPackageID`=858) OR (`SceneId`=673 AND `ScriptPackageID`=861) OR (`SceneId`=797 AND `ScriptPackageID`=947) OR (`SceneId`=803 AND `ScriptPackageID`=956) OR (`SceneId`=666 AND `ScriptPackageID`=844) OR (`SceneId`=796 AND `ScriptPackageID`=946) OR (`SceneId`=795 AND `ScriptPackageID`=945) OR (`SceneId`=727 AND `ScriptPackageID`=903) OR (`SceneId`=648 AND `ScriptPackageID`=838) OR (`SceneId`=694 AND `ScriptPackageID`=940) OR (`SceneId`=788 AND `ScriptPackageID`=942) OR (`SceneId`=782 AND `ScriptPackageID`=938) OR (`SceneId`=625 AND `ScriptPackageID`=812) OR (`SceneId`=624 AND `ScriptPackageID`=813) OR (`SceneId`=770 AND `ScriptPackageID`=933) OR (`SceneId`=771 AND `ScriptPackageID`=934) OR (`SceneId`=628 AND `ScriptPackageID`=1029) OR (`SceneId`=629 AND `ScriptPackageID`=817) OR (`SceneId`=754 AND `ScriptPackageID`=923) OR (`SceneId`=621 AND `ScriptPackageID`=806) OR (`SceneId`=630 AND `ScriptPackageID`=808) OR (`SceneId`=772 AND `ScriptPackageID`=937) OR (`SceneId`=756 AND `ScriptPackageID`=925) OR (`SceneId`=811 AND `ScriptPackageID`=961) OR (`SceneId`=812 AND `ScriptPackageID`=962) OR (`SceneId`=733 AND `ScriptPackageID`=1018) OR (`SceneId`=59 AND `ScriptPackageID`=195) OR (`SceneId`=68 AND `ScriptPackageID`=202) OR (`SceneId`=66 AND `ScriptPackageID`=200) OR (`SceneId`=0 AND `ScriptPackageID`=260) OR (`SceneId`=0 AND `ScriptPackageID`=43) OR (`SceneId`=802 AND `ScriptPackageID`=955) OR (`SceneId`=919 AND `ScriptPackageID`=1371) OR (`SceneId`=886 AND `ScriptPackageID`=1036) OR (`SceneId`=731 AND `ScriptPackageID`=909) OR (`SceneId`=742 AND `ScriptPackageID`=918) OR (`SceneId`=739 AND `ScriptPackageID`=915) OR (`SceneId`=741 AND `ScriptPackageID`=917) OR (`SceneId`=824 AND `ScriptPackageID`=976) OR (`SceneId`=189 AND `ScriptPackageID`=449) OR (`SceneId`=72 AND `ScriptPackageID`=212) OR (`SceneId`=110 AND `ScriptPackageID`=264) OR (`SceneId`=1012 AND `ScriptPackageID`=1441) OR (`SceneId`=965 AND `ScriptPackageID`=1387) OR (`SceneId`=786 AND `ScriptPackageID`=1352) OR (`SceneId`=668 AND `ScriptPackageID`=855) OR (`SceneId`=799 AND `ScriptPackageID`=950) OR (`SceneId`=111 AND `ScriptPackageID`=69) OR (`SceneId`=79 AND `ScriptPackageID`=68) OR (`SceneId`=74 AND `ScriptPackageID`=214) OR (`SceneId`=77 AND `ScriptPackageID`=41) OR (`SceneId`=75 AND `ScriptPackageID`=213) OR (`SceneId`=0 AND `ScriptPackageID`=27) OR (`SceneId`=73 AND `ScriptPackageID`=211) OR (`SceneId`=37 AND `ScriptPackageID`=25);
+INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`) VALUES
+(1023, 0, 1431),
+(1046, 0, 1434),
+(855, 16, 998),
+(1047, 0, 1433),
+(612, 27, 801),
+(602, 27, 788),
+(613, 16, 802),
+(910, 5, 1359),
+(679, 16, 867),
+(667, 20, 854),
+(889, 16, 1040),
+(878, 16, 1031),
+(877, 11, 1030),
+(880, 20, 1033),
+(864, 20, 1017),
+(659, 16, 847),
+(660, 16, 848),
+(720, 21, 898),
+(60, 11, 154),
+(109, 1, 263),
+(35, 25, 186),
+(83, 0, 223),
+(82, 0, 222),
+(81, 0, 221),
+(84, 0, 224),
+(91, 1, 241),
+(94, 11, 248),
+(1022, 27, 1405),
+(638, 16, 828),
+(634, 16, 824),
+(632, 16, 822),
+(610, 16, 800),
+(521, 16, 759),
+(623, 16, 810),
+(743, 26, 919),
+(688, 16, 873),
+(508, 17, 758),
+(506, 17, 756),
+(490, 16, 746),
+(680, 16, 868),
+(675, 5, 1361),
+(907, 5, 1358),
+(757, 16, 927),
+(734, 16, 907),
+(424, 16, 685),
+(890, 16, 1041),
+(674, 16, 862),
+(670, 16, 859),
+(669, 27, 856),
+(653, 16, 843),
+(652, 16, 842),
+(815, 16, 965),
+(691, 4, 879),
+(692, 4, 880),
+(693, 4, 881),
+(696, 16, 886),
+(695, 16, 884),
+(708, 16, 883),
+(697, 16, 885),
+(709, 16, 887),
+(522, 27, 760),
+(276, 1, 567),
+(640, 16, 830),
+(635, 16, 825),
+(636, 16, 826),
+(637, 16, 827),
+(502, 20, 752),
+(658, 0, 846),
+(818, 25, 986),
+(740, 16, 912),
+(689, 20, 871),
+(723, 20, 893),
+(758, 16, 928),
+(732, 25, 910),
+(724, 16, 894),
+(730, 16, 908),
+(719, 17, 896),
+(831, 16, 981),
+(753, 16, 922),
+(801, 25, 952),
+(672, 16, 858),
+(673, 16, 861),
+(797, 16, 947),
+(803, 25, 956),
+(666, 16, 844),
+(796, 20, 946),
+(795, 20, 945),
+(727, 16, 903),
+(648, 16, 838),
+(694, 16, 940),
+(788, 16, 942),
+(782, 16, 938),
+(625, 16, 812),
+(624, 16, 813),
+(770, 16, 933),
+(771, 16, 934),
+(628, 16, 1029),
+(629, 16, 817),
+(754, 16, 923),
+(621, 16, 806),
+(630, 16, 808),
+(772, 16, 937),
+(756, 17, 925),
+(811, 16, 961),
+(812, 16, 962),
+(733, 16, 1018),
+(59, 1, 195),
+(68, 13, 202),
+(66, 9, 200),
+(0, 1, 260),
+(0, 1, 43),
+(802, 17, 955),
+(919, 20, 1371),
+(886, 11, 1036),
+(731, 16, 909),
+(742, 0, 918),
+(739, 0, 915),
+(741, 0, 917),
+(824, 20, 976),
+(189, 0, 449),
+(72, 1, 212),
+(110, 11, 264),
+(1012, 17, 1441),
+(965, 16, 1387),
+(786, 5, 1352),
+(668, 16, 855),
+(799, 16, 950),
+(111, 1, 69),
+(79, 5, 68),
+(74, 0, 214),
+(77, 11, 41),
+(75, 17, 213),
+(0, 1, 27),
+(73, 1, 211),
+(37, 1, 25);