DROP TABLE IF EXISTS spawn_location_group_chances;
CREATE TABLE spawn_location_group_chances (
	id         INTEGER PRIMARY KEY,
	group_id   INTEGER NOT NULL DEFAULT 0 UNIQUE,
	percentage REAL NOT NULL DEFAULT 100,
	FOREIGN KEY (group_id) REFERENCES spawn_location_group(group_id) ON DELETE CASCADE ON UPDATE CASCADE
);

INSERT INTO spawn_location_group_chances VALUES
(1,1037124,50),
(2,1003159,50),
(4,1042726,17),
(5,1042727,16),
(14,1042737,85),
(15,1042738,15),
(16,1042739,35),
(33,1043671,33),
(36,1043675,33),
(50,43710,50),
(52,43709,33),
(63,25386,50),
(66,25385,50),
(85,27851,50),
(86,30074,50),
(87,30072,33.3333),
(88,27849,33.3333),
(89,29261,33.3333),
(90,29358,33.3333),
(91,35463,33.3333),
(92,27852,33.3333),
(93,29288,33.3333),
(94,38977,33.3333),
(95,27850,33.3333),
(97,29264,33.3333),
(98,29725,33.3333),
(99,27853,33.3333),
(100,29330,33.3333),
(101,27857,33.3333),
(102,29268,33.3333),
(103,29269,33.3333),
(104,29780,33.3333),
(105,27859,33.3333),
(106,27856,33.3333),
(107,29378,33.3333),
(108,29782,33.3333),
(109,29291,33.3333),
(110,29299,33.3333),
(111,27860,33.3333),
(118,29279,20),
(119,29924,20),
(121,30108,20),
(125,30308,20),
(129,35721,25),
(131,29282,25),
(132,29710,25),
(133,30312,25),
(134,30385,33.3333),
(135,29284,33.3333),
(136,30109,33.3333),
(137,29287,33.3333),
(138,29305,33.3333),
(139,29388,33.3333),
(140,29705,33.3333),
(141,29280,33.3333),
(142,38994,25),
(143,29326,25),
(144,29281,25),
(145,29289,25),
(146,29912,33.3333),
(147,27862,33.3333),
(148,29276,33.3333),
(152,29809,25),
(153,29719,25),
(154,29333,25),
(155,29308,25),
(156,35726,33.3333),
(157,29309,33.3333),
(158,38999,33.3333),
(162,29314,25),
(165,29395,25),
(166,30300,25),
(170,29399,25),
(171,35588,25),
(172,18873,25),
(173,29881,25),
(174,29319,25),
(175,29839,25),
(176,35277,25),
(177,18868,25),
(178,29402,25),
(179,18871,25),
(180,29814,25),
(181,29320,25),
(182,29718,25),
(183,35595,25),
(184,38980,25),
(185,27855,25),
(186,42480,20),
(187,1043705,80),
(188,1043706,25),
(189,27318,75),
(190,1043707,50),
(191,30476,50),
(192,27677,30),
(193,29987,35),
(194,32316,35),
(195,27708,50),
(196,27687,50),
(197,30440,20),
(198,30413,40),
(199,29988,40),
(203,27313,50),
(204,42478,50),
(208,19025,25),
(209,1043743,35),
(210,1043744,35),
(211,19580,75),
(212,33417,25),
(213,33439,25),
(214,1043775,25),
(215,1043779,25),
(216,1043782,25),
(217,1043784,75),
(218,18634,25),
(219,20460,75),
(220,1043792,25),
(221,1043795,25),
(222,1043805,25),
(223,1043809,75),
(224,1043830,25),
(228,26742,34),
(229,1043951,33),
(230,1043950,33),
(231,1043967,50),
(232,1043968,50),
(233,1043970,50),
(234,1043969,50),
(235,1043972,50),
(236,1043971,50),
(237,1043974,50),
(238,1043973,50),
(239,20975,75),
(240,1045207,10),
(241,1045208,10),
(242,1045209,10),
(243,1045211,10),
(244,1045212,10),
(245,1045213,10),
(246,1045214,10),
(247,1045215,10),
(248,1045216,5),
(249,1045217,5),
(250,1045218,5),
(251,1045219,5),
(252,1045177,10),
(253,1045198,10),
(254,1045193,5),
(255,1045172,10),
(256,1045192,5),
(257,1045197,10),
(258,1045181,5),
(259,1045188,10),
(260,1045206,5),
(261,1045187,10),
(262,1045205,5),
(263,1045173,10),
(264,1045186,10),
(265,1045174,10),
(266,1045196,10),
(267,1045184,10),
(268,1045191,5),
(269,1045183,10),
(270,1045200,10),
(271,1045176,10),
(272,1045182,5),
(273,1045179,5),
(274,1045171,10),
(275,1045180,5),
(276,1045178,10),
(277,1045189,10),
(278,1045190,10),
(279,1045203,5),
(280,1045195,10),
(281,1045204,5),
(282,1045194,5),
(283,1045185,10),
(284,1045201,10),
(285,1045202,10),
(286,1045199,10),
(287,1045220,10),
(288,1045221,10),
(289,1045222,10),
(290,1045223,10),
(291,1045224,10),
(292,1045225,10),
(293,1045226,10),
(294,1045227,10),
(295,1045228,5),
(296,1045229,5),
(297,1045230,5),
(298,1045231,5),
(299,1045232,10),
(300,1045233,10),
(301,1045234,10),
(302,1045235,10),
(303,1045236,10),
(304,1045237,10),
(305,1045238,10),
(306,1045239,10),
(307,1045240,5),
(308,1045241,5),
(309,1045242,5),
(310,1045243,5),
(311,1045244,10),
(312,1045245,10),
(313,1045246,10),
(314,1045247,10),
(315,1045248,10),
(316,1045249,10),
(317,1045250,10),
(318,1045251,10),
(319,1045252,5),
(320,1045253,5),
(321,1045254,5),
(322,1045255,5),
(323,1045256,10),
(324,1045257,10),
(325,1045258,10),
(326,1045259,10),
(327,1045260,10),
(328,1045264,10),
(329,1045265,10),
(330,1045266,10),
(331,1045267,5),
(332,1045268,5),
(333,1045269,5),
(334,1045270,5),
(335,1045271,10),
(336,1045272,10),
(337,1045273,10),
(338,1045274,10),
(339,1045275,10),
(340,1045276,10),
(341,1045277,10),
(342,1045278,10),
(344,1045279,5),
(345,1045280,5),
(346,1045281,5),
(347,1045282,5),
(348,1045283,10),
(349,1045284,10),
(350,1045285,10),
(351,1045286,10),
(352,1045287,10),
(353,1045288,10),
(354,1045289,10),
(355,1045290,10),
(356,1045291,5),
(357,1045292,5),
(358,1045293,5),
(359,1045294,5),
(360,27832,6),
(361,1046002,6),
(362,1046003,7),
(365,1046004,7),
(366,1046005,7),
(367,1046006,7),
(370,1046007,20),
(371,1046008,20),
(372,1046009,20),
(373,1046010,6),
(374,1046011,7),
(375,1046012,6),
(376,1046013,7),
(377,1046014,7),
(378,1046015,7),
(379,1046016,20),
(380,1046017,20),
(381,1046018,20),
(382,20051,75),
(383,19178,25),
(385,24239,50),
(386,23857,75),
(390,1049625,100),
(391,30840,40),
(392,30841,60),
(393,30842,33),
(394,30843,33),
(395,30844,33),
(396,30124,50),
(397,27261,50),
(398,30127,50),
(399,27256,50),
(407,5062,100),
(413,1049746,80),
(414,1049745,20),
(427,1049759,20),
(428,1049758,40),
(429,1049757,40),
(432,1049770,40),
(433,1049769,60),
(436,1049789,20),
(437,1049788,80),
(438,1049791,80),
(439,1049790,20),
(442,1049792,20),
(443,1049793,80),
(444,1049835,40),
(445,1049836,20),
(446,1049834,40),
(450,1049853,20),
(451,1049852,80),
(452,1049939,20),
(453,1049938,80),
(454,1049941,20),
(455,1049940,80),
(456,1049943,20),
(457,1049942,80),
(458,1050218,60),
(459,1050211,60),
(460,1050213,40),
(461,1050215,60),
(462,1050206,60),
(463,1050204,40),
(464,1050202,60),
(465,1050199,40),
(468,1050207,40),
(469,1050198,60),
(470,1051437,40),
(471,1051435,20),
(472,1051436,40),
(476,1051613,40),
(477,1051607,20),
(478,1051608,40),
(479,1051617,10),
(480,1051614,30),
(481,1051615,30),
(482,1051616,30),
(483,1051659,30),
(484,1051661,30),
(485,1051660,30),
(486,1051592,10),
(487,1051674,20),
(488,1051670,20),
(489,1051662,20),
(490,1052125,33),
(491,1052123,33),
(492,1052124,34),
(493,1052126,33),
(494,1052127,33),
(495,1052128,34),
(501,1052153,20),
(502,1052156,20),
(503,1052516,30),
(504,1052517,30),
(505,1052518,20),
(507,1052521,26),
(508,1052542,30),
(509,1052540,20),
(511,1052546,20),
(515,1052603,20),
(516,1052602,80),
(517,1052944,20),
(518,1052943,80),
(520,1052947,10),
(521,1052948,40),
(522,1052946,10),
(523,1052945,40),
(524,1053497,20),
(525,1053498,80),
(526,1053522,25),
(527,1053523,75),
(528,1053565,40),
(529,1053566,40),
(530,1053564,20),
(531,1053567,20),
(532,1053569,40),
(533,1053568,40),
(537,1053589,40),
(538,1053591,20),
(539,1053590,40),
(540,1053604,40),
(541,1053603,40),
(542,1053602,20),
(543,1053615,20),
(544,1053616,80),
(545,1054350,25),
(546,1054351,75),
(547,1054353,20),
(548,1054352,80),
(549,1054371,20),
(550,1054370,40),
(551,1054369,40),
(552,1054405,40),
(553,1054404,40),
(554,1054406,20),
(555,1054419,20),
(556,1054420,40),
(557,1054418,40),
(558,1054431,40),
(559,1054429,40),
(560,1054430,20),
(561,1054509,80),
(562,1054508,20),
(563,1054700,40),
(564,1054701,40),
(565,1049543,20),
(566,1054769,80),
(567,1054768,20),
(568,1054804,20),
(569,1054805,40),
(570,1054806,40),
(571,1055115,30),
(572,1055116,70),
(573,1055290,20),
(574,1055291,80),
(575,1055293,80),
(576,1055292,20),
(577,1055318,20),
(578,1055320,40),
(579,1055319,40),
(580,1055346,40),
(581,1055347,40),
(582,1055345,20),
(583,1055348,20),
(584,1055349,40),
(585,1055350,40),
(586,1050350,20),
(587,1050351,20),
(588,1050578,40),
(590,1050630,40),
(591,1050556,40),
(592,1050603,40),
(597,1055696,35),
(598,1055695,35),
(599,1055698,35),
(600,1055697,65),
(601,1055694,65),
(602,1055701,65),
(603,1055703,35),
(604,1055704,65),
(605,1055706,35),
(606,1055708,35),
(608,1055711,65),
(609,1055710,35),
(610,1055712,35),
(611,1055714,35),
(612,1055749,20),
(613,1055740,80),
(614,1055750,20),
(615,1055755,40),
(616,1055756,40),
(617,1055758,40),
(618,1055759,20),
(619,1055783,40),
(620,1055784,40),
(621,1055785,20),
(622,1055856,40),
(623,1055857,40),
(624,1055855,20),
(625,1055859,40),
(626,1055858,20),
(627,1055860,40),
(628,1055765,40),
(629,1055760,40),
(630,1055768,40),
(631,1055774,40),
(632,1055771,40),
(633,1055918,67),
(634,1055922,67),
(635,1055916,67),
(636,1056197,40),
(637,1056195,40),
(638,1056198,60),
(639,1056196,60),
(640,1056201,40),
(641,1056200,60),
(642,1056199,40),
(643,1056202,60),
(644,1056203,40),
(645,1056204,60),
(646,1056205,60),
(647,1056206,40),
(648,1056208,60),
(649,1056207,40),
(651,1056212,40),
(652,1056210,60),
(653,1056211,60),
(654,1056209,40),
(655,1056227,60),
(656,1056228,40),
(657,1056229,60),
(658,1056230,40),
(659,1056232,40),
(660,1056231,60),
(661,1056234,60),
(662,1056233,40),
(663,1056251,40),
(664,1056250,60),
(665,1056253,60),
(666,1056252,40),
(667,1056501,40),
(668,1056499,20),
(669,1056500,40),
(670,1056502,20),
(671,1056503,40),
(672,1056770,40),
(673,1056771,40),
(674,1056772,20),
(675,1056813,20),
(676,1056811,40),
(677,1056812,40),
(678,1056934,50),
(679,1056947,50),
(680,1056944,50),
(682,1056941,50),
(683,1056938,50),
(684,1056936,50),
(685,1057008,25),
(686,1057009,75),
(691,1057026,25),
(693,1057015,25),
(695,1057019,15),
(696,1057024,15),
(697,1057022,15),
(698,1057017,15),
(699,1057183,34),
(700,1057184,33),
(701,1057182,33),
(702,1057204,20),
(703,1057205,20),
(705,1057208,20),
(706,1057304,30),
(707,1057305,30),
(708,1057306,15),
(710,1057307,15),
(711,1057303,10),
(712,1057308,30),
(713,1057311,20),
(714,1057309,20),
(715,1057310,30),
(716,1057627,20),
(718,1057660,33),
(719,1057662,33),
(720,1057664,33),
(721,1057666,33),
(722,1057668,30),
(723,1057670,33),
(724,1057672,33),
(725,1057674,33),
(726,1057676,33),
(727,1057678,33),
(728,1057680,33),
(729,1057682,33),
(730,1057684,33),
(731,1057686,33),
(732,1057688,33),
(733,1057690,33),
(734,1057692,33),
(735,1057694,33),
(736,1057696,33),
(737,1057698,33),
(738,1057700,33),
(739,1057702,33),
(740,1057704,33),
(741,1057706,33),
(744,1057842,100),
(745,1057895,75),
(746,1057894,25),
(747,1058007,25),
(749,1058184,100),
(751,1058222,20),
(752,1058221,80);