468 lines
16 KiB
SQL
468 lines
16 KiB
SQL
DROP TABLE IF EXISTS spawn_instance_data;
|
|
CREATE TABLE spawn_instance_data (
|
|
spawn_id INTEGER NOT NULL DEFAULT 0,
|
|
spawn_location_id INTEGER NOT NULL DEFAULT 0,
|
|
pickup_item_id INTEGER NOT NULL DEFAULT 0,
|
|
pickup_unique_item_id INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
|
|
INSERT INTO spawn_instance_data VALUES
|
|
(1490001,133771732,63332,3647802),
|
|
(2230780,133773245,60754,9403622),
|
|
(2230779,133773246,1060001,12719556),
|
|
(2230781,133773247,64982,11661687),
|
|
(2230782,133773248,66378,11510053),
|
|
(2230783,133773249,61390,12719847),
|
|
(2230784,133773250,61545,12719852),
|
|
(2230786,133779386,61614,17516110),
|
|
(2230787,133779469,63115,17658999),
|
|
(2230787,133779470,63115,17659000),
|
|
(2230787,133779471,63115,17658995),
|
|
(2230787,133779472,63115,17659001),
|
|
(2230787,133779473,63115,17658993),
|
|
(2230787,133779475,63115,17658996),
|
|
(2230787,133779476,63115,17658997),
|
|
(2230787,133779477,63115,17658998),
|
|
(2230787,133779478,63115,17658994),
|
|
(2230787,133779479,63115,17659002),
|
|
(2230779,133779480,1060001,17548660),
|
|
(2230788,133779481,61547,17639127),
|
|
(2230789,133779482,61553,17593534),
|
|
(2230790,133779483,21491,17591260),
|
|
(2230793,133779575,61909,17786924),
|
|
(2230791,133779890,61915,17932185),
|
|
(2230792,133779891,61914,17932213),
|
|
(2230793,133779892,61909,17932235),
|
|
(2230791,133779910,61915,17950396),
|
|
(2230792,133779911,61914,17950425),
|
|
(2230793,133779912,61909,17950445),
|
|
(2230791,133780024,61915,17958633),
|
|
(2230792,133780061,61914,17959253),
|
|
(2230793,133780071,61909,17960466),
|
|
(2230794,133780488,62980,18053088),
|
|
(2230795,133780605,66212,18021977),
|
|
(2230791,133780632,61915,18058844),
|
|
(2230793,133780634,61909,18059730),
|
|
(2230795,133780694,66212,18093978),
|
|
(2230793,133780697,61909,18105317),
|
|
(2230793,133780735,61909,18171247),
|
|
(2230796,133780801,61107,18212967),
|
|
(2230791,133780864,61915,18260728),
|
|
(2230792,133781041,61914,18282683),
|
|
(2230791,133781220,61915,18299346),
|
|
(2230791,133781241,61915,18351037),
|
|
(2230792,133781242,61914,18351110),
|
|
(2230797,133781243,60653,18351171),
|
|
(2230793,133781244,61909,18351229),
|
|
(2230791,133781298,61915,18352355),
|
|
(2230792,133781299,61914,18352413),
|
|
(2230793,133781300,61909,18352473),
|
|
(2230791,133781324,61915,18375925),
|
|
(2230792,133781325,61914,18376061),
|
|
(2230793,133781326,61909,18376308),
|
|
(2230793,133781392,61909,18385005),
|
|
(2230791,133781408,61915,18404979),
|
|
(2230792,133781409,61914,18405024),
|
|
(2230793,133781410,61909,18405057),
|
|
(2230791,133781411,61915,18407972),
|
|
(2230792,133781412,61914,18408062),
|
|
(2230793,133781413,61909,18408243),
|
|
(2230791,133781414,61915,18412737),
|
|
(2230784,133781415,61545,18412747),
|
|
(2230798,133781416,61058,18412746),
|
|
(2230792,133781417,61914,18412791),
|
|
(2230791,133781418,61915,18427689),
|
|
(2230792,133781419,61914,18427781),
|
|
(2230793,133781420,61909,18427879),
|
|
(2230791,133781421,61915,18428582),
|
|
(2230792,133781422,61914,18428630),
|
|
(2230793,133781423,61909,18428812),
|
|
(2230792,133781425,61914,18455053),
|
|
(2230793,133781426,61909,18455099),
|
|
(2230791,133781427,61915,18456276),
|
|
(2230792,133781428,61914,18456326),
|
|
(2230793,133781429,61909,18456781),
|
|
(2230790,133781430,21491,18416705),
|
|
(2230791,133781431,61915,18467036),
|
|
(2230792,133781432,61914,18467099),
|
|
(2230793,133781433,61909,18467302),
|
|
(2230791,133781434,61915,18495021),
|
|
(2230792,133781435,61914,18495104),
|
|
(2230793,133781436,61909,18495186),
|
|
(2230791,133781437,61915,18516173),
|
|
(2230791,133781438,61915,18473271),
|
|
(2230792,133781439,61914,18516241),
|
|
(2230793,133781440,61909,18518112),
|
|
(2230791,133781441,61915,18536629),
|
|
(2230792,133781442,61914,18536697),
|
|
(2230793,133781443,61909,18536779),
|
|
(2230791,133781444,61915,18540520),
|
|
(2230792,133781445,61914,18540676),
|
|
(2230793,133781446,61909,18540750),
|
|
(2230791,133781447,61915,18564432),
|
|
(2230792,133781448,61914,18564496),
|
|
(2230793,133781449,61909,18565006),
|
|
(2230792,133781451,61914,18575008),
|
|
(2230793,133781452,61909,18575058),
|
|
(2230792,133781455,61914,18599205),
|
|
(2230793,133781456,61909,18599480),
|
|
(2230793,133781457,61909,18612091),
|
|
(2230792,133781459,61914,18651967),
|
|
(2230793,133781460,61909,18652106),
|
|
(2230791,133781461,61915,18703121),
|
|
(2230792,133781462,61914,18703235),
|
|
(2230793,133781463,61909,18703291),
|
|
(2230791,133781717,61915,18840485),
|
|
(2230793,133781719,61909,18840577),
|
|
(2230791,133782250,61915,19101381),
|
|
(2230792,133782251,61914,19104598),
|
|
(2230791,133782252,61915,19115623),
|
|
(2230792,133782253,61914,19119009),
|
|
(2230793,133782254,61909,19119065),
|
|
(2230791,133782385,61915,19211508),
|
|
(2230792,133782386,61914,19211596),
|
|
(2230793,133782387,61909,19212019),
|
|
(2230792,133782435,61914,19297006),
|
|
(2230793,133782436,61909,19297088),
|
|
(2230793,133782439,61909,19307163),
|
|
(2230792,133782441,61914,19321758),
|
|
(2230793,133782442,61909,19321859),
|
|
(2230791,133782492,61915,19342667),
|
|
(2230793,133782494,61909,19344431),
|
|
(2230791,133782643,61915,19470273),
|
|
(2230792,133782644,61914,19470327),
|
|
(2230793,133782645,61909,19470540),
|
|
(2230792,133782649,61914,19512891),
|
|
(2230793,133782650,61909,19512926),
|
|
(2230780,133782662,60754,19518568),
|
|
(2230792,133782663,61914,19518620),
|
|
(2230793,133782664,61909,19518763),
|
|
(2230791,133782923,61915,19523804),
|
|
(2230792,133782924,61914,19523881),
|
|
(2230793,133782925,61909,19523953),
|
|
(2230789,133782926,61553,19524090),
|
|
(2230780,133782927,60754,19524015),
|
|
(2230792,133783295,61914,19568102),
|
|
(2230793,133783296,61909,19568196),
|
|
(2230780,133783297,60754,19568329),
|
|
(2230789,133783298,61553,19568521),
|
|
(2230793,133783643,61909,19671674),
|
|
(2230791,133783644,61915,19675000),
|
|
(2230793,133783646,61909,19675125),
|
|
(2230791,133785220,61915,20225311),
|
|
(2230792,133785221,61914,20225353),
|
|
(2230793,133785222,61909,20225395),
|
|
(2230791,133785223,61915,20226638),
|
|
(2230792,133785224,61914,20226693),
|
|
(2230793,133785225,61909,20226744),
|
|
(1450272,133785286,61913,20436264),
|
|
(2230792,133785378,61914,20474427),
|
|
(2230789,133785379,61553,20473896),
|
|
(2230793,133785380,61909,20474745),
|
|
(2230793,133785558,61909,20518594),
|
|
(2230791,133786111,61915,20629876),
|
|
(2230792,133786112,61914,20630016),
|
|
(2230791,133786113,61915,20628072),
|
|
(2230792,133786539,61914,20672996),
|
|
(2230793,133786540,61909,20673535),
|
|
(2230791,133786815,61915,20750176),
|
|
(2230792,133786816,61914,20750248),
|
|
(2230793,133786817,61909,20750721),
|
|
(1450272,133786860,61913,20828204),
|
|
(2230791,133786865,61915,20883004),
|
|
(2230792,133786866,61914,20883042),
|
|
(2230793,133786870,61909,20895191),
|
|
(2230788,133786939,61547,21061551),
|
|
(2230801,133786940,60712,21061552),
|
|
(2230793,133787200,61909,21186943),
|
|
(2230793,133787392,61909,21245984),
|
|
(1450272,133787951,61913,21373994),
|
|
(2230793,133788339,61909,21483470),
|
|
(2230793,133789007,61909,14020462),
|
|
(2230793,133789829,61909,14347270),
|
|
(2230791,133790450,61915,14546771),
|
|
(2230780,133790564,60754,14582744),
|
|
(1450272,133790852,61913,14754036),
|
|
(1450272,133790896,61913,14781060),
|
|
(2230793,133791239,61909,14875146),
|
|
(2230793,133791760,61909,15081213),
|
|
(1450272,133791769,61913,15178986),
|
|
(2230793,133791770,61909,15181750),
|
|
(2230793,133791771,61909,15181991),
|
|
(2230793,133791772,61909,15181989),
|
|
(2230793,133791876,61909,15267332),
|
|
(2230793,133791904,61909,15358776),
|
|
(2230793,133792249,61909,15558452),
|
|
(2230793,133792729,61909,16035185),
|
|
(1450272,133792732,61913,16040025),
|
|
(2230791,133792736,61915,16043972),
|
|
(1450273,133792737,61409,16043920),
|
|
(2230793,133792739,61909,16044659),
|
|
(2230793,133792744,61909,16091082),
|
|
(2230793,133792765,61909,16238655),
|
|
(2230793,133792768,61909,16262822),
|
|
(2230793,133792797,61909,16272074),
|
|
(2230793,133792801,61909,16293316),
|
|
(2230793,133792805,61909,16296424),
|
|
(1450272,133792807,61913,16335364),
|
|
(2230793,133792810,61909,16342793),
|
|
(2230793,133792813,61909,16347236),
|
|
(1450272,133792827,61913,16393176),
|
|
(2230793,133792829,61909,16401313),
|
|
(2230791,133792830,61915,16419964),
|
|
(2230791,133792831,61915,16419960),
|
|
(2230791,133792832,61915,16419959),
|
|
(2230791,133792833,61915,16419951),
|
|
(2230791,133792834,61915,16419950),
|
|
(2230791,133792835,61915,16419949),
|
|
(2230791,133792836,61915,16419935),
|
|
(2230791,133792837,61915,16419934),
|
|
(2230793,133792838,61909,16419954),
|
|
(2230793,133792839,61909,16419943),
|
|
(2230793,133792840,61909,16419941),
|
|
(1450272,133792841,61913,16419955),
|
|
(1450272,133792842,61913,16419957),
|
|
(2230793,133792847,61909,16419939),
|
|
(2230793,133792852,61909,16420766),
|
|
(1450272,133792853,61913,16419956),
|
|
(1450272,133792854,61913,16419962),
|
|
(1450272,133792855,61913,16419946),
|
|
(2230791,133792856,61915,16420769),
|
|
(1450272,133792857,61913,16419944),
|
|
(1450272,133792858,61913,16419937),
|
|
(1450272,133792859,61913,16419952),
|
|
(2230791,133792860,61915,16420770),
|
|
(2230791,133792861,61915,16420767),
|
|
(2230791,133792862,61915,16420768),
|
|
(2230793,133792863,61909,16419938),
|
|
(2230793,133792864,61909,16419940),
|
|
(2230793,133792868,61909,16464279),
|
|
(2230791,133792871,61915,16492821),
|
|
(1450272,133792872,61913,16492895),
|
|
(2230791,133792873,61915,16509437),
|
|
(1450272,133792874,61913,16509822),
|
|
(2230791,133792875,61915,16512826),
|
|
(1450272,133792876,61913,16512879),
|
|
(2230791,133792877,61915,16523893),
|
|
(1450272,133792878,61913,16524446),
|
|
(2230791,133792879,61915,16525092),
|
|
(2230793,133792880,61909,16525165),
|
|
(1450272,133792881,61913,16525554),
|
|
(2230793,133792882,61909,16525922),
|
|
(2230791,133792883,61915,16525901),
|
|
(1450272,133792884,61913,16525987),
|
|
(2230793,133792885,61909,16526227),
|
|
(2230793,133792886,61909,16529179),
|
|
(2230793,133792891,61909,16572923),
|
|
(2230791,133792892,61915,16605687),
|
|
(1450272,133792893,61913,16605779),
|
|
(2230793,133792896,61909,16624062),
|
|
(2230791,133792897,61915,16624337),
|
|
(1450272,133792898,61913,16624453),
|
|
(2230793,133792899,61909,16625316),
|
|
(2230791,133792900,61915,16661321),
|
|
(2230793,133792903,61909,16661910),
|
|
(2230801,133792904,60712,16687252),
|
|
(2230793,133793316,61909,16888040),
|
|
(2230791,133793353,61915,16965848),
|
|
(1450272,133793354,61913,16967055),
|
|
(2230793,133793355,61909,16967757),
|
|
(2230791,133793753,61915,17393105),
|
|
(1450273,133793754,61409,17393042),
|
|
(1450272,133793755,61913,17393352),
|
|
(2230791,133793889,61915,17500249),
|
|
(1450272,133793890,61913,17500295),
|
|
(2230793,133793893,61909,17507428),
|
|
(2230791,133794581,61915,18382278),
|
|
(2230801,133794582,60712,18382172),
|
|
(1450272,133794584,61913,18384038),
|
|
(2230793,133794586,61909,18387807),
|
|
(2230789,133794630,61553,18383878),
|
|
(2230802,133794631,60760,18591437),
|
|
(2230793,133794642,61909,18636378),
|
|
(2230793,133794645,61909,18662184),
|
|
(2230791,133795125,61915,19202146),
|
|
(1450272,133795126,61913,19202212),
|
|
(2230793,133795127,61909,19202972),
|
|
(2230793,133795159,61909,19233756),
|
|
(2230793,133795214,61909,19350324),
|
|
(2230791,133795265,61915,19443955),
|
|
(1450272,133795266,61913,19444026),
|
|
(1450274,133795267,60606,19445854),
|
|
(2230791,133795307,61915,19494196),
|
|
(1450272,133795308,61913,19494246),
|
|
(2230801,133795309,60712,19494271),
|
|
(2230793,133795310,61909,19494788),
|
|
(2230791,133795355,61915,19545106),
|
|
(1450272,133795356,61913,19545223),
|
|
(2230791,133795357,61915,19545548),
|
|
(2230793,133795358,61909,19545549),
|
|
(1450272,133795359,61913,19545668),
|
|
(2230793,133795360,61909,19546076),
|
|
(2230791,133795361,61915,19551662),
|
|
(1450272,133795362,61913,19551728),
|
|
(2230793,133795363,61909,19551924),
|
|
(2230780,133795366,60754,19574888),
|
|
(2230789,133795367,61553,19605577),
|
|
(2230793,133795372,61909,19606728),
|
|
(2230793,133795373,61909,19606730),
|
|
(2230780,133795374,60754,19631146),
|
|
(2230788,133795375,61547,19632003),
|
|
(2230791,133795376,61915,19635293),
|
|
(1450274,133795377,60606,19640921),
|
|
(1450274,133795378,60606,19640919),
|
|
(2230791,133795379,61915,19640926),
|
|
(2230791,133795498,61915,19919705),
|
|
(1450272,133795499,61913,19919909),
|
|
(2230801,133795500,60712,19919602),
|
|
(1450274,133795501,60606,19919910),
|
|
(2230793,133795502,61909,19923749),
|
|
(1450272,133795503,61913,19919909),
|
|
(2230791,133795504,61915,19954126),
|
|
(1450272,133795505,61913,19954238),
|
|
(2230793,133795506,61909,19954755),
|
|
(2230791,133795526,61915,19972112),
|
|
(2230792,133795527,61914,19972209),
|
|
(2230793,133795528,61909,19976023),
|
|
(2230791,133795548,61915,19997048),
|
|
(2230792,133795549,61914,19997131),
|
|
(2230793,133795550,61909,19997388),
|
|
(2230791,133795552,61915,20013499),
|
|
(1450272,133795553,61913,20013581),
|
|
(2230791,133795576,61915,20042925),
|
|
(2230792,133795577,61914,20043366),
|
|
(2230789,133795578,61553,20042841),
|
|
(1450274,133795579,60606,19473627),
|
|
(1450274,133795580,60606,19473614),
|
|
(2230803,133795581,66547,20046554),
|
|
(1450274,133795582,60606,20046547),
|
|
(2230793,133795583,61909,20048651),
|
|
(2230791,133795584,61915,20074946),
|
|
(2230791,133795585,61915,20075461),
|
|
(1450272,133795586,61913,20075492),
|
|
(2230791,133795587,61915,20081537),
|
|
(2230792,133795588,61914,20081645),
|
|
(2230793,133795589,61909,20086276),
|
|
(2230791,133795590,61915,20089610),
|
|
(1450272,133795591,61913,20089688),
|
|
(2230793,133795592,61909,20090060),
|
|
(2230791,133795593,61915,20116252),
|
|
(1450272,133795594,61913,20116314),
|
|
(2230793,133795595,61909,20126244),
|
|
(1450273,133795596,61409,20126673),
|
|
(2230791,133795597,61915,20142702),
|
|
(1450272,133795598,61913,20142877),
|
|
(2230793,133795599,61909,20143539),
|
|
(2230791,133795600,61915,20149008),
|
|
(2230792,133795601,61914,20149044),
|
|
(1450274,133795602,60606,20149047),
|
|
(2230793,133795603,61909,20149470),
|
|
(2230791,133795607,61915,20225077),
|
|
(2230792,133795608,61914,20225115),
|
|
(2230791,133795609,61915,20233461),
|
|
(2230792,133795610,61914,20233544),
|
|
(2230793,133795611,61909,20233972),
|
|
(2230791,133795612,61915,20246180),
|
|
(2230792,133795613,61914,20246364),
|
|
(2230793,133795614,61909,20246954),
|
|
(2230791,133795615,61915,20247870),
|
|
(2230792,133795616,61914,20247929),
|
|
(2230793,133795617,61909,20248339),
|
|
(2230791,133795618,61915,20257438),
|
|
(2230792,133795619,61914,20257471),
|
|
(2230793,133795620,61909,20258005),
|
|
(2230790,133795621,21491,20264290),
|
|
(2230779,133795622,1060001,20264682),
|
|
(2230784,133795623,61545,20264411),
|
|
(2230791,133795647,61915,20303533),
|
|
(1450272,133795648,61913,20303602),
|
|
(2230793,133795649,61909,20303807),
|
|
(2230791,133795665,61915,20395761),
|
|
(1450272,133795666,61913,20395823),
|
|
(2230793,133795667,61909,20396037),
|
|
(2230791,133795676,61915,20632190),
|
|
(1450272,133795677,61913,20632266),
|
|
(2230791,133795681,61915,20787851),
|
|
(1450272,133795682,61913,20787953),
|
|
(2230793,133795683,61909,20793714),
|
|
(2230791,133795687,61915,20895348),
|
|
(2230792,133795688,61914,20895434),
|
|
(2230791,133795689,61915,20905025),
|
|
(1450272,133795690,61913,20905135),
|
|
(2230791,133795691,61915,20946260),
|
|
(1450272,133795692,61913,20946300),
|
|
(2230791,133795693,61915,20947746),
|
|
(1450272,133795694,61913,20947824),
|
|
(2230791,133795711,61915,21012166),
|
|
(1450272,133795712,61913,21012246),
|
|
(2230791,133795718,61915,21067744),
|
|
(2230798,133795719,61058,21067795),
|
|
(2230792,133795720,61914,21067954),
|
|
(2230801,133795721,60712,21067897),
|
|
(2230793,133795722,61909,21068431),
|
|
(2230780,133795723,60754,21068616),
|
|
(2230791,133795946,61915,21085962),
|
|
(2230792,133795947,61914,21086065),
|
|
(2230793,133795948,61909,21086687),
|
|
(2230791,133796301,61915,21201190),
|
|
(1450272,133796302,61913,21201502),
|
|
(1450275,133796303,60521,21201262),
|
|
(2230791,133796304,61915,21203448),
|
|
(2230792,133796305,61914,21203522),
|
|
(2230793,133796306,61909,21203936),
|
|
(2230791,133796466,61915,21238535),
|
|
(1450272,133796467,61913,21238643),
|
|
(2230793,133796468,61909,21239647),
|
|
(2230791,133796883,61915,21306881),
|
|
(1450272,133796884,61913,21306944),
|
|
(2230793,133796885,61909,21307161),
|
|
(2230791,133797066,61915,21368046),
|
|
(2230792,133797067,61914,21368138),
|
|
(2230793,133797068,61909,21368622),
|
|
(2230791,133797086,61915,21393003),
|
|
(2230792,133797087,61914,21393021),
|
|
(2230791,133797144,61915,21416176),
|
|
(1450275,133797145,60521,21416119),
|
|
(2230801,133797146,60712,21416117),
|
|
(1450272,133797147,61913,21416290),
|
|
(2230793,133797148,61909,21416950),
|
|
(2230791,133797152,61915,21467787),
|
|
(2230792,133797153,61914,21467887),
|
|
(2230793,133797154,61909,21469250),
|
|
(2230791,133797357,61915,21558911),
|
|
(1450272,133797358,61913,21559009),
|
|
(2230793,133797359,61909,21559267),
|
|
(2230791,133797360,61915,21591750),
|
|
(2230791,133797361,61915,21615480),
|
|
(2230792,133797362,61914,21615622),
|
|
(2230793,133797363,61909,21616021),
|
|
(2230790,133797364,21491,21616899),
|
|
(2230791,133797365,61915,21629277),
|
|
(2230792,133797366,61914,21629649),
|
|
(2230784,133797367,61545,21628993),
|
|
(2230780,133797368,60754,21629198),
|
|
(2230789,133797369,61553,21628584),
|
|
(2230792,133797370,61914,21650194),
|
|
(2230793,133797371,61909,21650531),
|
|
(2230783,133797372,61390,21656740),
|
|
(2230788,133797373,61547,21640522),
|
|
(2230779,133797374,1060001,21645499),
|
|
(2230804,133797375,61549,21652271),
|
|
(2230791,133797376,61915,21669093),
|
|
(2230792,133797377,61914,21669115),
|
|
(2230791,133797378,61915,21748045),
|
|
(2230790,133797379,66558,21751928),
|
|
(2230791,133797380,61915,21809081),
|
|
(2230792,133797381,61914,21809122),
|
|
(2230793,133797382,61909,21809602),
|
|
(2230791,133797383,61915,21884892),
|
|
(2230791,133797384,61915,21884973),
|
|
(2230792,133797385,61914,21885135),
|
|
(2230792,133797386,61914,21885178),
|
|
(2230793,133797387,61909,21885680),
|
|
(2230793,133797388,61909,21885911),
|
|
(2230791,133797389,61915,21907172),
|
|
(2230791,133797390,61915,21911535),
|
|
(2230792,133797391,61914,21911585),
|
|
(2230793,133797392,61909,21911781);
|