Extra Data

INSERT INTO `player_match_points` (`id`, `player_id`, `match_id`, `points`) VALUES
(1, 179038, 1, 2),
(2, 181406, 1, 2),
(3, 184320, 1, 2),
(4, 190962, 1, 2),
(5, 207809, 1, 2),
(6, 208016, 1, 2),
(7, 217172, 1, 2),
(8, 218284, 1, 2),
(9, 218306, 1, 2),
(10, 233952, 1, 2),
(11, 239424, 1, 2),
(12, 271043, 1, 2),
(13, 289964, 1, 2),
(14, 298613, 1, 2),
(15, 298959, 1, 2),
(16, 309426, 1, 2),
(17, 312868, 1, 2),
(18, 314197, 1, 2),
(19, 318172, 1, 2),
(20, 356669, 1, 2),
(21, 362727, 1, 2),
(22, 367913, 1, 2),
(23, 367918, 1, 2),
(24, 179038, 2, 2),
(25, 181406, 2, 2),
(26, 184320, 2, 2),
(27, 190962, 2, 2),
(28, 207809, 2, 2),
(29, 208016, 2, 2),
(30, 217172, 2, 2),
(31, 218284, 2, 2),
(32, 218306, 2, 2),
(33, 233952, 2, 2),
(34, 239424, 2, 2),
(35, 271043, 2, 2),
(36, 289964, 2, 2),
(37, 298613, 2, 2),
(38, 298959, 2, 2),
(39, 309426, 2, 2),
(40, 312868, 2, 2),
(41, 314197, 2, 2),
(42, 318172, 2, 2),
(43, 356669, 2, 2),
(44, 362727, 2, 2),
(45, 367913, 2, 2),
(46, 367918, 2, 2),
(47, 175546, 2, 2),
(48, 178119, 2, 2),
(49, 195231, 2, 2),
(50, 209960, 2, 2),
(51, 215285, 2, 2),
(52, 218253, 2, 2),
(53, 227851, 2, 2),
(54, 228599, 2, 2),
(55, 234551, 2, 2),
(56, 238112, 2, 2),
(57, 251352, 2, 2),
(58, 289195, 2, 2),
(59, 303394, 2, 2),
(60, 308082, 2, 2),
(61, 319311, 2, 2),
(62, 329092, 2, 2),
(63, 336722, 2, 2),
(64, 350124, 2, 2),
(65, 350129, 2, 2),
(66, 356731, 2, 2),
(67, 371042, 2, 2),
(68, 371044, 2, 2),
(69, 379264, 2, 2),
(70, 179038, 3, 2),
(71, 181406, 3, 2),
(72, 184320, 3, 2),
(73, 190962, 3, 2),
(74, 207809, 3, 2),
(75, 208016, 3, 2),
(76, 217172, 3, 2),
(77, 218284, 3, 2),
(78, 218306, 3, 2),
(79, 233952, 3, 2),
(80, 239424, 3, 2),
(81, 271043, 3, 2),
(82, 289964, 3, 2),
(83, 298613, 3, 2),
(84, 298959, 3, 2),
(85, 309426, 3, 2),
(86, 312868, 3, 2),
(87, 314197, 3, 2),
(88, 318172, 3, 2),
(89, 356669, 3, 2),
(90, 362727, 3, 2),
(91, 367913, 3, 2),
(92, 367918, 3, 2),
(93, 175546, 3, 2),
(94, 178119, 3, 2),
(95, 195231, 3, 2),
(96, 209960, 3, 2),
(97, 215285, 3, 2),
(98, 218253, 3, 2),
(99, 227851, 3, 2),
(100, 228599, 3, 2),
(101, 234551, 3, 2),
(102, 238112, 3, 2),
(103, 251352, 3, 2),
(104, 289195, 3, 2),
(105, 303394, 3, 2),
(106, 308082, 3, 2),
(107, 319311, 3, 2),
(108, 329092, 3, 2),
(109, 336722, 3, 2),
(110, 350124, 3, 2),
(111, 350129, 3, 2),
(112, 356731, 3, 2),
(113, 371042, 3, 2),
(114, 371044, 3, 2),
(115, 379264, 3, 2),
(116, 175413, 3, 2),
(117, 176644, 3, 2),
(118, 177855, 3, 2),
(119, 183857, 3, 2),
(120, 183864, 3, 2),
(121, 200176, 3, 2),
(122, 200179, 3, 2),
(123, 207528, 3, 2),
(124, 207906, 3, 2),
(125, 216814, 3, 2),
(126, 216820, 3, 2),
(127, 216973, 3, 2),
(128, 229884, 3, 2),
(129, 267811, 3, 2),
(130, 269859, 3, 2),
(131, 270714, 3, 2),
(132, 270948, 3, 2),
(133, 297705, 3, 2),
(134, 303034, 3, 2),
(135, 306954, 3, 2),
(136, 313410, 3, 2),
(137, 318601, 3, 2),
(138, 367920, 3, 2);


INSERT INTO `squads` (`id`, `user_id`, `transfer_period_id`, `formation`, `captain_id`, `vice_captain_id`, `is_triple_captain`, `created_at`, `updated_at`) VALUES
(1, 2, 2, '442', 1, 1, 0),
(2, 3, 2, '532', 1, 1, 0),
(3, 4, 2, '442', 1, 1, 0),
(4, 5, 2, '532', 1, 1, 0),
(5, 6, 2, '442', 1, 1, 0),
(6, 7, 2, '541', 1, 1, 0),
(7, 8, 2, '541', 1, 1, 0),
(8, 9, 2, '442', 1, 1, 0),
(9, 10, 2, '541', 1, 1, 0),
(10, 11, 2, '442', 1, 1, 0);


INSERT INTO `squad_players` (`id`, `squad_id`, `user_id`, `player_id`, `position`, `priority`) VALUES
(1, 1, 2, 159304, 'goalkeeper', 0),
(2, 1, 2, 184856, 'goalkeeper', 1),
(3, 1, 2, 213878, 'defender', 2),
(4, 1, 2, 375754, 'defender', 3),
(5, 1, 2, 218284, 'defender', 4),
(7, 1, 2, 297230, 'defender', 6),
(11, 1, 2, 357991, 'midfielder', 10),
(12, 1, 2, 290824, 'midfielder', 11),
(13, 1, 2, 233500, 'forward', 12),
(14, 1, 2, 177927, 'forward', 13),
(15, 1, 2, 296994, 'forward', 14),
(17, 2, 3, 303419, 'goalkeeper', 1),
(18, 2, 3, 254141, 'defender', 2),
(19, 2, 3, 336085, 'defender', 3),
(20, 2, 3, 236533, 'defender', 4),
(21, 2, 3, 317072, 'defender', 5),
(23, 2, 3, 200935, 'midfielder', 7),
(24, 2, 3, 234463, 'midfielder', 8),
(25, 2, 3, 312868, 'midfielder', 9),
(27, 2, 3, 366573, 'midfielder', 11),
(28, 2, 3, 216970, 'forward', 12),
(30, 2, 3, 369990, 'forward', 14),
(31, 3, 4, 184856, 'goalkeeper', 0),
(32, 3, 4, 367558, 'goalkeeper', 1),
(35, 3, 4, 306410, 'defender', 4),
(36, 3, 4, 289964, 'defender', 5),
(38, 3, 4, 296273, 'midfielder', 7),
(39, 3, 4, 177768, 'midfielder', 8),
(40, 3, 4, 330689, 'midfielder', 9),
(41, 3, 4, 316997, 'midfielder', 10),
(42, 3, 4, 234463, 'midfielder', 11),
(43, 3, 4, 364763, 'forward', 12),
(44, 3, 4, 373400, 'forward', 13),
(46, 4, 5, 303419, 'goalkeeper', 0),
(47, 4, 5, 253999, 'goalkeeper', 1),
(48, 4, 5, 296303, 'defender', 2),
(51, 4, 5, 276132, 'defender', 5),
(52, 4, 5, 210702, 'defender', 6),
(53, 4, 5, 215623, 'midfielder', 7),
(55, 4, 5, 291329, 'midfielder', 9),
(57, 4, 5, 183000, 'midfielder', 11),
(58, 4, 5, 216435, 'forward', 12),
(59, 4, 5, 180936, 'forward', 13),
(60, 4, 5, 187258, 'forward', 14),
(61, 5, 6, 299066, 'goalkeeper', 0),
(62, 5, 6, 214581, 'goalkeeper', 1),
(63, 5, 6, 356162, 'defender', 2),
(64, 5, 6, 306364, 'defender', 3),
(66, 5, 6, 178119, 'defender', 5),
(67, 5, 6, 375754, 'defender', 6),
(70, 5, 6, 270400, 'midfielder', 9),
(72, 5, 6, 379995, 'midfielder', 11),
(73, 5, 6, 373224, 'forward', 12),
(74, 5, 6, 347716, 'forward', 13),
(75, 5, 6, 201787, 'forward', 14),
(76, 6, 7, 323574, 'goalkeeper', 0),
(77, 6, 7, 178958, 'goalkeeper', 1),
(79, 6, 7, 358046, 'defender', 3),
(80, 6, 7, 370469, 'defender', 4),
(81, 6, 7, 215274, 'defender', 5),
(82, 6, 7, 311174, 'defender', 6),
(83, 6, 7, 300402, 'midfielder', 7),
(84, 6, 7, 367918, 'midfielder', 8),
(85, 6, 7, 266800, 'midfielder', 9),
(88, 6, 7, 359235, 'forward', 12),
(89, 6, 7, 312316, 'forward', 13),
(91, 7, 8, 189300, 'goalkeeper', 0),
(92, 7, 8, 356676, 'goalkeeper', 1),
(93, 7, 8, 228617, 'defender', 2),
(94, 7, 8, 319432, 'defender', 3),
(95, 7, 8, 213878, 'defender', 4),
(99, 7, 8, 376349, 'midfielder', 8),
(101, 7, 8, 358732, 'midfielder', 10),
(102, 7, 8, 216650, 'midfielder', 11),
(103, 7, 8, 373224, 'forward', 12),
(104, 7, 8, 309316, 'forward', 13),
(105, 7, 8, 356399, 'forward', 14),
(106, 8, 9, 298655, 'goalkeeper', 0),
(107, 8, 9, 176644, 'goalkeeper', 1),
(108, 8, 9, 228936, 'defender', 2),
(109, 8, 9, 238381, 'defender', 3),
(110, 8, 9, 209940, 'defender', 4),
(111, 8, 9, 319340, 'defender', 5),
(112, 8, 9, 207946, 'defender', 6),
(115, 8, 9, 196752, 'midfielder', 9),
(116, 8, 9, 299198, 'midfielder', 10),
(119, 8, 9, 356399, 'forward', 13),
(120, 8, 9, 358048, 'forward', 14),
(121, 9, 10, 356933, 'goalkeeper', 0),
(122, 9, 10, 178630, 'goalkeeper', 1),
(123, 9, 10, 176971, 'defender', 2),
(124, 9, 10, 229443, 'defender', 3),
(126, 9, 10, 271043, 'defender', 5),
(127, 9, 10, 356518, 'defender', 6),
(128, 9, 10, 332827, 'midfielder', 7),
(130, 9, 10, 214571, 'midfielder', 9),
(132, 9, 10, 184447, 'midfielder', 11),
(134, 9, 10, 306206, 'forward', 13),
(135, 9, 10, 201787, 'forward', 14),
(136, 10, 11, 298655, 'goalkeeper', 0),
(137, 10, 11, 215017, 'goalkeeper', 1),
(138, 10, 11, 269784, 'defender', 2),
(139, 10, 11, 311148, 'defender', 3),
(140, 10, 11, 305768, 'defender', 4),
(141, 10, 11, 367557, 'defender', 5),
(142, 10, 11, 305764, 'defender', 6),
(143, 10, 11, 361222, 'midfielder', 7),
(148, 10, 11, 311554, 'forward', 12),
(149, 10, 11, 214228, 'forward', 13),
(150, 10, 11, 233500, 'forward', 14),
(151, 8, 9, 290821, 'midfielder', 7),
(152, 8, 9, 233530, 'midfielder', 8),
(153, 8, 9, 305378, 'midfielder', 11),
(154, 8, 9, 267834, 'forward', 12),
(155, 5, 6, 291332, 'defender', 4),
(156, 5, 6, 216964, 'midfielder', 7),
(157, 5, 6, 329737, 'midfielder', 8),
(158, 5, 6, 367555, 'midfielder', 10),
(159, 1, 2, 379985, 'defender', 5),
(160, 1, 2, 280487, 'midfielder', 7),
(161, 1, 2, 233530, 'midfielder', 8),
(162, 1, 2, 319311, 'midfielder', 9),
(163, 3, 4, 306634, 'defender', 2),
(164, 3, 4, 289195, 'defender', 3),
(165, 3, 4, 306954, 'defender', 6),
(166, 3, 4, 180936, 'forward', 14),
(167, 7, 8, 312432, 'defender', 5),
(168, 7, 8, 358022, 'defender', 6),
(169, 7, 8, 362727, 'midfielder', 7),
(170, 7, 8, 329092, 'midfielder', 9),
(171, 2, 3, 380009, 'goalkeeper', 0),
(172, 2, 3, 288824, 'defender', 6),
(173, 2, 3, 379910, 'midfielder', 10),
(174, 2, 3, 201200, 'forward', 13),
(175, 6, 7, 184373, 'defender', 2),
(176, 6, 7, 304934, 'midfielder', 10),
(177, 6, 7, 305036, 'midfielder', 11),
(178, 6, 7, 356399, 'forward', 14),
(179, 9, 10, 186793, 'defender', 4),
(180, 9, 10, 185359, 'midfielder', 8),
(181, 9, 10, 197409, 'midfielder', 10),
(182, 9, 10, 270144, 'forward', 12),
(183, 4, 5, 290864, 'defender', 3),
(184, 4, 5, 286481, 'defender', 4),
(185, 4, 5, 299086, 'midfielder', 8),
(186, 4, 5, 298676, 'midfielder', 10),
(187, 10, 11, 358099, 'midfielder', 8),
(188, 10, 11, 175524, 'midfielder', 9),
(189, 10, 11, 358891, 'midfielder', 10),
(190, 10, 11, 202544, 'midfielder', 11);