INSERT INTO event_beneficiaries
(id
, event_id
, beneficiary_id
, person_id
) VALUES
(18, 15, 2, 25),
(20, 17, 3, 26),
(28, 25, 4, 36),
(29, 26, 4, 36),
(30, 27, 4, 36),
(32, 28, 2, 25),
(33, 29, 4, 36),
(34, 30, 4, 36),
(35, 31, 4, 36),
(36, 32, 4, 36),
(37, 34, 4, 36),
(38, 35, 4, 36),
(39, 36, 4, 36),
(40, 37, 4, 36),
(41, 38, 4, 36),
(42, 39, 4, 36),
(43, 40, 4, 36),
(44, 41, 4, 36),
(45, 42, 4, 36),
(46, 43, 4, 36),
(47, 44, 4, 36),
(48, 45, 4, 36),
(49, 46, 4, 36),
(50, 47, 4, 36),
(51, 48, 4, 36),
(52, 49, 4, 36),
(53, 50, 4, 36),
(54, 51, 4, 36),
(55, 52, 4, 36),
(56, 53, 4, 36),
(57, 54, 4, 36),
(58, 55, 4, 36),
(59, 57, 4, 36),
(60, 58, 4, 36),
(61, 59, 4, 36),
(62, 60, 4, 36),
(63, 61, 4, 36),
(64, 62, 4, 36),
(65, 63, 4, 36),
(66, 64, 4, 36),
(67, 65, 4, 36),
(68, 66, 4, 36),
(69, 67, 4, 36),
(70, 68, 4, 36),
(71, 69, 4, 36),
(72, 70, 4, 36),
(73, 71, 4, 36),
(74, 72, 4, 36),
(75, 73, 4, 36),
(76, 74, 4, 36),
(77, 75, 4, 36),
(78, 76, 4, 36),
(79, 77, 4, 36),
(80, 78, 4, 36),
(81, 79, 4, 36),
(82, 80, 4, 36),
(83, 81, 4, 36),
(84, 82, 4, 36),
(85, 83, 4, 36),
(86, 84, 4, 36),
(87, 85, 4, 36),
(88, 86, 4, 36),
(89, 87, 4, 36),
(90, 88, 4, 36),
(91, 89, 4, 36),
(92, 90, 4, 36),
(93, 91, 4, 36),
(94, 92, 4, 36),
(95, 93, 4, 36),
(96, 94, 4, 36),
(97, 95, 4, 36),
(98, 96, 4, 36),
(99, 97, 4, 36),
(100, 99, 4, 36),
(102, 100, 5, 39),
(103, 98, 4, 36),
(104, 101, 4, 36),
(105, 102, 4, 36),
(106, 103, 4, 36),
(107, 104, 4, 36),
(108, 105, 4, 36),
(109, 106, 4, 36),
(110, 107, 4, 36),
(111, 108, 4, 36),
(112, 109, 4, 36),
(113, 110, 4, 36),
(114, 111, 4, 36),
(116, 112, 3, 26),
(117, 112, 2, 25),
(118, 113, 4, 36),
(119, 114, 4, 36),
(120, 115, 4, 36),
(121, 116, 4, 36),
(122, 117, 4, 36),
(123, 118, 4, 36),
(124, 119, 4, 36),
(125, 120, 4, 36),
(126, 121, 4, 36),
(127, 122, 2, 25),
(128, 124, 4, 36),
(129, 130, 4, 36),
(130, 131, 4, 36),
(131, 132, 4, 36),
(132, 125, 4, 36),
(133, 126, 4, 36),
(134, 135, 4, 36),
(135, 134, 4, 36),
(136, 136, 4, 36),
(137, 137, 4, 36),
(138, 138, 4, 36),
(139, 139, 4, 36),
(140, 140, 4, 36),
(141, 142, 4, 36),
(142, 143, 4, 36),
(143, 144, 4, 36),
(144, 145, 4, 36),
(145, 146, 2, 25),
(146, 150, 4, 36),
(147, 148, 4, 36),
(148, 149, 4, 36),
(149, 151, 4, 36);
INSERT INTO event_technicians
(id
, event_id
, technician_id
, start_time
, end_time
, position
) VALUES
(10, 6, 17, '2021-05-29 00:00:00', '2021-05-30 23:59:59', NULL),
(23, 16, 27, '2021-08-27 00:00:00', '2021-08-30 23:59:59', 'Monteur / Technicien'),
(24, 16, 28, '2021-08-27 00:00:00', '2021-08-30 23:59:59', 'Monteur / Technicien'),
(30, 18, 27, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(31, 18, 28, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(33, 19, 27, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(34, 19, 28, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(36, 20, 27, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(37, 20, 28, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Monteur'),
(39, 18, 35, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Chef de projet'),
(40, 19, 35, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Chef de projet'),
(41, 20, 35, '2021-08-26 00:00:00', '2021-08-30 23:59:59', 'Chef de projet'),
(42, 16, 17, '2021-08-27 00:00:00', '2021-08-30 23:59:59', 'Régisseur Son'),
(43, 16, 35, '2021-08-27 00:00:00', '2021-08-30 23:59:59', 'Régisseur Lumière'),
(44, 21, 17, '2021-08-27 00:00:00', '2021-08-29 23:59:59', 'Monteur / Livreur'),
(45, 22, 35, '2021-09-02 00:00:00', '2021-09-03 23:59:59', 'Livraison'),
(46, 23, 35, '2021-09-02 00:00:00', '2021-09-03 23:59:59', 'Livraison'),
(47, 25, 27, '2021-09-15 13:00:00', '2021-09-16 03:00:00', 'Technicien'),
(48, 25, 35, '2021-09-15 13:00:00', '2021-09-16 03:00:00', 'Technicien'),
(49, 25, 17, '2021-09-15 14:00:00', '2021-09-16 03:00:00', 'Technicien'),
(51, 35, 35, '2021-09-27 11:00:00', '2021-09-27 12:00:00', 'Livraison'),
(52, 39, 17, '2021-12-17 14:30:00', '2021-12-17 19:00:00', NULL),
(53, 39, 35, '2021-12-17 14:30:00', '2021-12-17 19:00:00', NULL),
(54, 40, 27, '2022-03-08 11:30:00', '2022-03-09 02:00:00', 'Monteur'),
(55, 40, 35, '2022-03-08 11:30:00', '2022-03-09 02:00:00', 'Monteur'),
(56, 107, 17, '2023-01-28 08:00:00', '2023-01-28 12:00:00', 'Monteur'),
(58, 109, 35, '2023-01-27 09:30:00', '2023-01-27 15:30:00', 'Monteur'),
(59, 112, 35, '2023-01-27 09:30:00', '2023-01-27 15:30:00', 'Monteur'),
(61, 125, 35, '2023-02-24 13:00:00', '2023-02-25 02:30:00', NULL),
(62, 125, 17, '2023-02-24 13:00:00', '2023-02-25 02:30:00', NULL),
(63, 135, 35, '2023-03-01 16:30:00', '2023-03-01 16:45:00', NULL),
(65, 138, 35, '2023-03-06 16:00:00', '2023-03-07 01:30:00', 'Montage / Démontage'),
(66, 138, 27, '2023-03-06 16:00:00', '2023-03-07 01:30:00', 'Montage / Démontage / DJ'),
(67, 139, 35, '2023-03-08 13:00:00', '2023-03-09 02:30:00', 'Montage / Démontage / Light'),
(68, 139, 17, '2023-03-08 13:00:00', '2023-03-09 02:30:00', 'Montage / Démontage'),
(69, 139, 27, '2023-03-08 13:00:00', '2023-03-09 02:30:00', 'Montage / Démontage / DJ'),
(70, 144, 35, '2023-03-15 13:00:00', '2023-03-16 02:30:00', 'Montage / Démontage / Light'),
(71, 144, 17, '2023-03-15 13:00:00', '2023-03-16 02:30:00', 'Montage / Démontage'),
(72, 144, 27, '2023-03-15 13:00:00', '2023-03-16 02:30:00', 'Montage / Démontage / DJ'),
(73, 145, 27, '2023-03-13 09:45:00', '2023-03-13 14:45:00', 'Montage'),
(74, 145, 27, '2023-03-13 21:00:00', '2023-03-13 22:45:00', 'Demontage'),
(75, 145, 35, '2023-03-13 09:45:00', '2023-03-13 14:00:00', 'Montage'),
(76, 145, 35, '2023-03-13 21:00:00', '2023-03-13 22:45:00', 'Demontage'),
(77, 145, 42, '2023-03-13 09:45:00', '2023-03-13 14:45:00', 'Montage'),
(78, 145, 42, '2023-03-13 21:00:00', '2023-03-13 22:45:00', 'Demontage'),
(79, 150, 35, '2023-03-20 16:00:00', '2023-03-20 23:45:00', 'Montage / Démontage');