181 lines
5.3 KiB
SQL
181 lines
5.3 KiB
SQL
DROP TABLE IF EXISTS persisted_respawns;
|
|
CREATE TABLE persisted_respawns (
|
|
id INTEGER PRIMARY KEY,
|
|
spawn_location_entry_id INTEGER NOT NULL DEFAULT 0,
|
|
spawn_type INTEGER NOT NULL DEFAULT 0,
|
|
zone_id INTEGER NOT NULL DEFAULT 0,
|
|
respawn_time INTEGER NOT NULL DEFAULT 0,
|
|
UNIQUE(zone_id, spawn_location_entry_id)
|
|
);
|
|
|
|
INSERT INTO persisted_respawns VALUES
|
|
(82876,133785989,0,816,300),
|
|
(82877,133785990,0,816,300),
|
|
(82878,133785991,0,816,300),
|
|
(84412,133796143,0,852,300),
|
|
(84603,133796156,0,852,300),
|
|
(84605,133796148,0,852,300),
|
|
(84606,133796149,0,852,300),
|
|
(84607,133796150,0,852,300),
|
|
(84610,133796146,0,852,300),
|
|
(84612,133796167,0,852,300),
|
|
(84613,133796168,0,852,300),
|
|
(84614,133796163,0,852,300),
|
|
(85875,133796194,0,852,300),
|
|
(85876,133796178,0,852,300),
|
|
(85877,133796184,0,852,300),
|
|
(85878,133796189,0,852,300),
|
|
(85879,133796195,0,852,300),
|
|
(85880,133796200,0,852,300),
|
|
(85881,133796198,0,852,300),
|
|
(85882,133796181,0,852,300),
|
|
(85883,133796182,0,852,300),
|
|
(85886,133796179,0,852,300),
|
|
(85888,133796197,0,852,300),
|
|
(85892,133796216,0,852,300),
|
|
(85893,133796219,0,852,300),
|
|
(85894,133796223,0,852,300),
|
|
(85895,133796207,0,852,300),
|
|
(85896,133796208,0,852,300),
|
|
(85897,133796227,0,852,300),
|
|
(85898,133796228,0,852,300),
|
|
(85899,133796229,0,852,300),
|
|
(85900,133796230,0,852,300),
|
|
(85901,133796232,0,852,300),
|
|
(85902,133796231,0,852,300),
|
|
(85903,133796213,0,852,300),
|
|
(85904,133796214,0,852,300),
|
|
(85907,133796222,0,852,300),
|
|
(85909,133796209,0,852,300),
|
|
(91985,133796311,0,852,300),
|
|
(91986,133796309,0,852,300),
|
|
(92018,133796314,0,852,300),
|
|
(92019,133796316,0,852,300),
|
|
(92020,133796317,0,852,300),
|
|
(96510,133796963,0,852,300),
|
|
(96553,133796971,0,852,300),
|
|
(96561,133796961,0,852,300),
|
|
(96563,133796965,0,852,300),
|
|
(96564,133796966,0,852,300),
|
|
(96565,133796969,0,852,300),
|
|
(96566,133796968,0,852,300),
|
|
(96567,133796967,0,852,300),
|
|
(98656,1585070,0,278,3600),
|
|
(98657,1585069,0,278,3600),
|
|
(98661,1585067,0,278,3600),
|
|
(98662,1585068,0,278,3600),
|
|
(98692,394631,0,278,300),
|
|
(98707,133781629,0,834,10800),
|
|
(98708,133781631,0,834,10800),
|
|
(99566,133781627,0,834,10800),
|
|
(99966,1585075,0,278,3600),
|
|
(101938,133786135,0,839,300),
|
|
(101943,133786143,0,839,300),
|
|
(102272,133787343,0,841,2040),
|
|
(103244,1586075,0,126,3600),
|
|
(103258,1585687,0,126,3600),
|
|
(103260,1586074,0,126,3600),
|
|
(103265,1586073,0,126,3600),
|
|
(103312,1586092,0,126,3600),
|
|
(103316,1586090,0,126,3600),
|
|
(103318,1586087,0,126,3600),
|
|
(103319,1586091,0,126,3600),
|
|
(103344,1586080,0,126,3600),
|
|
(103345,1586085,0,126,3600),
|
|
(103347,1586084,0,126,3600),
|
|
(103349,1586089,0,126,3600),
|
|
(103350,1586086,0,126,3600),
|
|
(103352,1586093,0,126,3600),
|
|
(103441,133789173,0,842,2040),
|
|
(103442,133789171,0,842,2040),
|
|
(103683,420316,0,136,300),
|
|
(103691,133772315,0,125,3600),
|
|
(103695,133772320,0,125,3600),
|
|
(103697,133772316,0,125,3600),
|
|
(103699,133772330,0,125,3600),
|
|
(103700,133772335,0,125,3600),
|
|
(103702,133772321,0,125,3600),
|
|
(103706,133772324,0,125,3600),
|
|
(103707,133772355,0,125,3600),
|
|
(103712,133772356,0,125,3600),
|
|
(103718,133772346,0,125,3600),
|
|
(103727,133772350,0,125,3600),
|
|
(103729,133772352,0,125,3600),
|
|
(103732,133772460,0,125,3600),
|
|
(103733,133772399,0,125,3600),
|
|
(103749,133772333,0,125,3600),
|
|
(103756,133772336,0,125,3600),
|
|
(103766,133772354,0,125,3600),
|
|
(103768,133772449,0,125,3600),
|
|
(103769,133772455,0,125,3600),
|
|
(103770,133772454,0,125,3600),
|
|
(103779,133772458,0,125,3600),
|
|
(103782,309346,0,125,300),
|
|
(103783,133772466,0,125,3600),
|
|
(103784,310220,0,125,300),
|
|
(103785,310232,0,125,300),
|
|
(103786,1585776,0,124,3600),
|
|
(103787,1585772,0,124,3600),
|
|
(103790,1585858,0,124,3600),
|
|
(103791,1585859,0,124,3600),
|
|
(103801,1585890,0,124,3600),
|
|
(103802,1585803,0,124,3600),
|
|
(104443,133788263,0,840,2040),
|
|
(104455,402869,0,137,190),
|
|
(104714,133786446,0,839,300),
|
|
(105691,133797350,0,852,300),
|
|
(105692,133797355,0,852,300),
|
|
(105693,133797143,0,852,2100),
|
|
(105694,133797140,0,852,2100),
|
|
(106583,133774993,0,325,300),
|
|
(106695,133775324,0,325,300),
|
|
(106702,133776512,0,325,300),
|
|
(109715,133791311,0,33,2040),
|
|
(109716,300438,0,33,300),
|
|
(109741,133789776,0,33,300),
|
|
(109742,133789753,0,33,2040),
|
|
(109743,133789752,0,33,2040),
|
|
(109746,133789870,0,33,300),
|
|
(109747,133789873,0,33,300),
|
|
(114304,133781621,0,834,10800),
|
|
(114305,133781622,0,834,10800),
|
|
(114306,133781626,0,834,10800),
|
|
(114307,133781625,0,834,10800),
|
|
(114308,133781624,0,834,10800),
|
|
(114414,133778060,0,827,300),
|
|
(115183,133781632,0,834,10800),
|
|
(115282,133781640,0,834,300),
|
|
(115284,133781641,0,834,300),
|
|
(121816,431127,0,253,5),
|
|
(122124,1584962,0,278,3600),
|
|
(122311,429508,0,253,180),
|
|
(122329,133770253,0,253,180),
|
|
(122331,431128,0,253,5),
|
|
(123702,133773399,0,233,600),
|
|
(123703,133773400,0,233,500),
|
|
(125244,133774935,0,325,300),
|
|
(125362,133779584,0,829,300),
|
|
(125614,413311,0,438,300),
|
|
(126711,133774959,0,325,300),
|
|
(126715,133774948,0,325,300),
|
|
(126789,133774971,0,325,300),
|
|
(126793,133774969,0,325,300),
|
|
(126796,133774938,0,325,300),
|
|
(126799,133774941,0,325,300),
|
|
(126807,133775122,0,325,300),
|
|
(126812,133774744,0,325,60),
|
|
(126997,133775580,0,325,300),
|
|
(127035,133770251,0,253,180),
|
|
(127037,133770254,0,253,180),
|
|
(127045,133770257,0,253,120),
|
|
(127049,133770256,0,253,120),
|
|
(128125,133775625,0,325,540),
|
|
(128210,133781628,0,834,10800),
|
|
(128216,133781630,0,834,10800),
|
|
(128241,133777675,0,827,300),
|
|
(128264,133781623,0,834,10800),
|
|
(128285,133781677,0,834,300),
|
|
(128306,133774765,0,325,45),
|
|
(128310,133774677,0,325,10),
|
|
(128311,133774764,0,325,90);
|