INSERT INTO `rate_calendar` (`id`, `property_id`, `unit_id`, `channel_id`, `day`, `stop_sell`, `cta`, `ctd`, `min_stay`, `max_stay`, `price_n1`, `price_n2`, `price_n3`, `price_n4`, `price_n5`, `price_n6`, `price_n7`, `price_n14`, `price_n21`, `price_n28`, `included_persons_total`, `included_adults`, `included_children`, `extra_person_nightly`, `extra_adult_nightly`, `extra_child_nightly`, `updated_at`) VALUES
(1546, 2, 15, 0, '2026-03-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1547, 2, 15, 0, '2026-03-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1548, 2, 15, 0, '2026-03-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1549, 2, 15, 0, '2026-03-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1550, 2, 15, 0, '2026-03-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1551, 2, 15, 0, '2026-03-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1552, 2, 15, 0, '2026-03-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1553, 2, 15, 0, '2026-03-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1554, 2, 15, 0, '2026-03-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1555, 2, 15, 0, '2026-03-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1556, 2, 15, 0, '2026-03-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1557, 2, 15, 0, '2026-03-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1558, 2, 15, 0, '2026-03-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1559, 2, 15, 0, '2026-04-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1560, 2, 15, 0, '2026-04-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1561, 2, 15, 0, '2026-04-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1562, 2, 15, 0, '2026-04-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1563, 2, 15, 0, '2026-04-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1564, 2, 15, 0, '2026-04-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1565, 2, 15, 0, '2026-04-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1566, 2, 15, 0, '2026-04-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1567, 2, 15, 0, '2026-04-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1568, 2, 15, 0, '2026-04-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1569, 2, 15, 0, '2026-04-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1570, 2, 15, 0, '2026-04-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1571, 2, 15, 0, '2026-04-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1572, 2, 15, 0, '2026-04-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1573, 2, 15, 0, '2026-04-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1574, 2, 15, 0, '2026-04-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1575, 2, 15, 0, '2026-04-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1576, 2, 15, 0, '2026-04-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1577, 2, 15, 0, '2026-04-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1578, 2, 15, 0, '2026-04-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1579, 2, 15, 0, '2026-04-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1580, 2, 15, 0, '2026-04-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1581, 2, 15, 0, '2026-04-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1582, 2, 15, 0, '2026-04-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1583, 2, 15, 0, '2026-04-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1584, 2, 15, 0, '2026-04-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1585, 2, 15, 0, '2026-04-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1586, 2, 15, 0, '2026-04-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1587, 2, 15, 0, '2026-04-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1588, 2, 15, 0, '2026-04-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1589, 2, 15, 0, '2026-05-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1590, 2, 15, 0, '2026-05-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1591, 2, 15, 0, '2026-05-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1592, 2, 15, 0, '2026-05-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1593, 2, 15, 0, '2026-05-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1594, 2, 15, 0, '2026-05-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1595, 2, 15, 0, '2026-05-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1596, 2, 15, 0, '2026-05-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1597, 2, 15, 0, '2026-05-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1598, 2, 15, 0, '2026-05-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1599, 2, 15, 0, '2026-05-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1600, 2, 15, 0, '2026-05-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1601, 2, 15, 0, '2026-05-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1602, 2, 15, 0, '2026-05-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1603, 2, 15, 0, '2026-05-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1604, 2, 15, 0, '2026-05-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1605, 2, 15, 0, '2026-05-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1606, 2, 15, 0, '2026-05-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1607, 2, 15, 0, '2026-05-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1608, 2, 15, 0, '2026-05-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1609, 2, 15, 0, '2026-05-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1610, 2, 15, 0, '2026-05-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1611, 2, 15, 0, '2026-05-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1612, 2, 15, 0, '2026-05-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1613, 2, 15, 0, '2026-05-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1614, 2, 15, 0, '2026-05-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1615, 2, 15, 0, '2026-05-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1616, 2, 15, 0, '2026-05-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1617, 2, 15, 0, '2026-05-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1618, 2, 15, 0, '2026-05-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1619, 2, 15, 0, '2026-05-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1620, 2, 15, 0, '2026-06-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1621, 2, 15, 0, '2026-06-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1622, 2, 15, 0, '2026-06-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1623, 2, 15, 0, '2026-06-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1624, 2, 15, 0, '2026-06-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1625, 2, 15, 0, '2026-06-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1626, 2, 15, 0, '2026-06-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1627, 2, 15, 0, '2026-06-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1628, 2, 15, 0, '2026-06-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1629, 2, 15, 0, '2026-06-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1630, 2, 15, 0, '2026-06-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1631, 2, 15, 0, '2026-06-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1632, 2, 15, 0, '2026-06-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1633, 2, 15, 0, '2026-06-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1634, 2, 15, 0, '2026-06-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1635, 2, 15, 0, '2026-06-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1636, 2, 15, 0, '2026-06-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1637, 2, 15, 0, '2026-06-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1638, 2, 15, 0, '2026-06-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1639, 2, 15, 0, '2026-06-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1640, 2, 15, 0, '2026-06-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1641, 2, 15, 0, '2026-06-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1642, 2, 15, 0, '2026-06-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1643, 2, 15, 0, '2026-06-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1644, 2, 15, 0, '2026-06-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1645, 2, 15, 0, '2026-06-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1646, 2, 15, 0, '2026-06-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1647, 2, 15, 0, '2026-06-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1648, 2, 15, 0, '2026-06-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1649, 2, 15, 0, '2026-06-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1650, 2, 15, 0, '2026-07-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1651, 2, 15, 0, '2026-07-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1652, 2, 15, 0, '2026-07-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1653, 2, 15, 0, '2026-07-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1654, 2, 15, 0, '2026-07-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1655, 2, 15, 0, '2026-07-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1656, 2, 15, 0, '2026-07-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1657, 2, 15, 0, '2026-07-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1658, 2, 15, 0, '2026-07-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1659, 2, 15, 0, '2026-07-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1660, 2, 15, 0, '2026-07-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1661, 2, 15, 0, '2026-07-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1662, 2, 15, 0, '2026-07-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1663, 2, 15, 0, '2026-07-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1664, 2, 15, 0, '2026-07-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1665, 2, 15, 0, '2026-07-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1666, 2, 15, 0, '2026-07-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1667, 2, 15, 0, '2026-07-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1668, 2, 15, 0, '2026-07-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1669, 2, 15, 0, '2026-07-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1670, 2, 15, 0, '2026-07-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1671, 2, 15, 0, '2026-07-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1672, 2, 15, 0, '2026-07-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1673, 2, 15, 0, '2026-07-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1674, 2, 15, 0, '2026-07-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1675, 2, 15, 0, '2026-07-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1676, 2, 15, 0, '2026-07-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1677, 2, 15, 0, '2026-07-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1678, 2, 15, 0, '2026-07-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1679, 2, 15, 0, '2026-07-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1680, 2, 15, 0, '2026-07-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1681, 2, 15, 0, '2026-08-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1682, 2, 15, 0, '2026-08-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1683, 2, 15, 0, '2026-08-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1684, 2, 15, 0, '2026-08-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1685, 2, 15, 0, '2026-08-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1686, 2, 15, 0, '2026-08-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1687, 2, 15, 0, '2026-08-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1688, 2, 15, 0, '2026-08-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1689, 2, 15, 0, '2026-08-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1690, 2, 15, 0, '2026-08-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1691, 2, 15, 0, '2026-08-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1692, 2, 15, 0, '2026-08-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1693, 2, 15, 0, '2026-08-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1694, 2, 15, 0, '2026-08-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1695, 2, 15, 0, '2026-08-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1696, 2, 15, 0, '2026-08-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1697, 2, 15, 0, '2026-08-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1698, 2, 15, 0, '2026-08-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1699, 2, 15, 0, '2026-08-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1700, 2, 15, 0, '2026-08-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1701, 2, 15, 0, '2026-08-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1702, 2, 15, 0, '2026-08-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1703, 2, 15, 0, '2026-08-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1704, 2, 15, 0, '2026-08-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1705, 2, 15, 0, '2026-08-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1706, 2, 15, 0, '2026-08-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1707, 2, 15, 0, '2026-08-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1708, 2, 15, 0, '2026-08-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1709, 2, 15, 0, '2026-08-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1710, 2, 15, 0, '2026-08-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1711, 2, 15, 0, '2026-08-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1712, 2, 15, 0, '2026-09-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1713, 2, 15, 0, '2026-09-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1714, 2, 15, 0, '2026-09-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1715, 2, 15, 0, '2026-09-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1716, 2, 15, 0, '2026-09-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1717, 2, 15, 0, '2026-09-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1718, 2, 15, 0, '2026-09-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1719, 2, 15, 0, '2026-09-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1720, 2, 15, 0, '2026-09-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1721, 2, 15, 0, '2026-09-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1722, 2, 15, 0, '2026-09-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1723, 2, 15, 0, '2026-09-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1724, 2, 15, 0, '2026-09-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1725, 2, 15, 0, '2026-09-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1726, 2, 15, 0, '2026-09-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1727, 2, 15, 0, '2026-09-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1728, 2, 15, 0, '2026-09-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1729, 2, 15, 0, '2026-09-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1730, 2, 15, 0, '2026-09-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1731, 2, 15, 0, '2026-09-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1732, 2, 15, 0, '2026-09-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1733, 2, 15, 0, '2026-09-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1734, 2, 15, 0, '2026-09-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1735, 2, 15, 0, '2026-09-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1736, 2, 15, 0, '2026-09-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1737, 2, 15, 0, '2026-09-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1738, 2, 15, 0, '2026-09-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1739, 2, 15, 0, '2026-09-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1740, 2, 15, 0, '2026-09-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1741, 2, 15, 0, '2026-09-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1742, 2, 15, 0, '2026-10-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1743, 2, 15, 0, '2026-10-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1744, 2, 15, 0, '2026-10-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1745, 2, 15, 0, '2026-10-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1746, 2, 15, 0, '2026-10-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1747, 2, 15, 0, '2026-10-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1748, 2, 15, 0, '2026-10-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1749, 2, 15, 0, '2026-10-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1750, 2, 15, 0, '2026-10-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1751, 2, 15, 0, '2026-10-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1752, 2, 15, 0, '2026-10-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1753, 2, 15, 0, '2026-10-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1754, 2, 15, 0, '2026-10-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1755, 2, 15, 0, '2026-10-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1756, 2, 15, 0, '2026-10-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1757, 2, 15, 0, '2026-10-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1758, 2, 15, 0, '2026-10-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1759, 2, 15, 0, '2026-10-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1760, 2, 15, 0, '2026-10-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1761, 2, 15, 0, '2026-10-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1762, 2, 15, 0, '2026-10-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1763, 2, 15, 0, '2026-10-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1764, 2, 15, 0, '2026-10-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1765, 2, 15, 0, '2026-10-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1766, 2, 15, 0, '2026-10-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1767, 2, 15, 0, '2026-10-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1768, 2, 15, 0, '2026-10-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1769, 2, 15, 0, '2026-10-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1770, 2, 15, 0, '2026-10-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1771, 2, 15, 0, '2026-10-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1772, 2, 15, 0, '2026-10-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1773, 2, 15, 0, '2026-11-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1774, 2, 15, 0, '2026-11-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1775, 2, 15, 0, '2026-11-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1776, 2, 15, 0, '2026-11-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1777, 2, 15, 0, '2026-11-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1778, 2, 15, 0, '2026-11-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1779, 2, 15, 0, '2026-11-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1780, 2, 15, 0, '2026-11-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1781, 2, 15, 0, '2026-11-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1782, 2, 15, 0, '2026-11-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1783, 2, 15, 0, '2026-11-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1784, 2, 15, 0, '2026-11-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1785, 2, 15, 0, '2026-11-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1786, 2, 15, 0, '2026-11-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1787, 2, 15, 0, '2026-11-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1788, 2, 15, 0, '2026-11-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1789, 2, 15, 0, '2026-11-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1790, 2, 15, 0, '2026-11-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1791, 2, 15, 0, '2026-11-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1792, 2, 15, 0, '2026-11-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1793, 2, 15, 0, '2026-11-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1794, 2, 15, 0, '2026-11-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1795, 2, 15, 0, '2026-11-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1796, 2, 15, 0, '2026-11-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1797, 2, 15, 0, '2026-11-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1798, 2, 15, 0, '2026-11-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1799, 2, 15, 0, '2026-11-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1800, 2, 15, 0, '2026-11-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1801, 2, 15, 0, '2026-11-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1802, 2, 15, 0, '2026-11-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1803, 2, 15, 0, '2026-12-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1804, 2, 15, 0, '2026-12-02', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1805, 2, 15, 0, '2026-12-03', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1806, 2, 15, 0, '2026-12-04', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1807, 2, 15, 0, '2026-12-05', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1808, 2, 15, 0, '2026-12-06', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1809, 2, 15, 0, '2026-12-07', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1810, 2, 15, 0, '2026-12-08', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1811, 2, 15, 0, '2026-12-09', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1812, 2, 15, 0, '2026-12-10', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1813, 2, 15, 0, '2026-12-11', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1814, 2, 15, 0, '2026-12-12', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1815, 2, 15, 0, '2026-12-13', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1816, 2, 15, 0, '2026-12-14', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1817, 2, 15, 0, '2026-12-15', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1818, 2, 15, 0, '2026-12-16', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1819, 2, 15, 0, '2026-12-17', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1820, 2, 15, 0, '2026-12-18', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1821, 2, 15, 0, '2026-12-19', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1822, 2, 15, 0, '2026-12-20', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1823, 2, 15, 0, '2026-12-21', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1824, 2, 15, 0, '2026-12-22', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1825, 2, 15, 0, '2026-12-23', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1826, 2, 15, 0, '2026-12-24', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1827, 2, 15, 0, '2026-12-25', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1828, 2, 15, 0, '2026-12-26', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1829, 2, 15, 0, '2026-12-27', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1830, 2, 15, 0, '2026-12-28', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1831, 2, 15, 0, '2026-12-29', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1832, 2, 15, 0, '2026-12-30', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1833, 2, 15, 0, '2026-12-31', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(1834, 2, 15, 0, '2027-01-01', 0, 0, 0, 1, 30, 14.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 10.00, 4.00, '2025-12-06 16:02:04'),
(2398, 2, 16, 0, '2025-12-01', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2399, 2, 16, 0, '2025-12-02', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2400, 2, 16, 0, '2025-12-03', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2401, 2, 16, 0, '2025-12-04', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2402, 2, 16, 0, '2025-12-05', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2403, 2, 16, 0, '2025-12-06', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2404, 2, 16, 0, '2025-12-07', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2405, 2, 16, 0, '2025-12-08', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2406, 2, 16, 0, '2025-12-09', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2407, 2, 16, 0, '2025-12-10', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2408, 2, 16, 0, '2025-12-11', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2409, 2, 16, 0, '2025-12-12', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2410, 2, 16, 0, '2025-12-13', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33');
INSERT INTO `rate_calendar` (`id`, `property_id`, `unit_id`, `channel_id`, `day`, `stop_sell`, `cta`, `ctd`, `min_stay`, `max_stay`, `price_n1`, `price_n2`, `price_n3`, `price_n4`, `price_n5`, `price_n6`, `price_n7`, `price_n14`, `price_n21`, `price_n28`, `included_persons_total`, `included_adults`, `included_children`, `extra_person_nightly`, `extra_adult_nightly`, `extra_child_nightly`, `updated_at`) VALUES
(2411, 2, 16, 0, '2025-12-14', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2412, 2, 16, 0, '2025-12-15', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2413, 2, 16, 0, '2025-12-16', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2414, 2, 16, 0, '2025-12-17', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2415, 2, 16, 0, '2025-12-18', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2416, 2, 16, 0, '2025-12-19', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:40:33'),
(2417, 2, 16, 0, '2026-04-02', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:41:23'),
(2467, 2, 16, 0, '2025-12-20', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2468, 2, 16, 0, '2025-12-21', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2469, 2, 16, 0, '2025-12-22', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2470, 2, 16, 0, '2025-12-23', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2471, 2, 16, 0, '2025-12-24', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2472, 2, 16, 0, '2025-12-25', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2473, 2, 16, 0, '2025-12-26', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2474, 2, 16, 0, '2025-12-27', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2475, 2, 16, 0, '2025-12-28', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2476, 2, 16, 0, '2025-12-29', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2477, 2, 16, 0, '2025-12-30', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2478, 2, 16, 0, '2025-12-31', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2479, 2, 16, 0, '2026-01-01', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2480, 2, 16, 0, '2026-01-02', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2481, 2, 16, 0, '2026-01-03', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2482, 2, 16, 0, '2026-01-04', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2483, 2, 16, 0, '2026-01-05', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2484, 2, 16, 0, '2026-01-06', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2485, 2, 16, 0, '2026-01-07', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2486, 2, 16, 0, '2026-01-08', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2487, 2, 16, 0, '2026-01-09', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2488, 2, 16, 0, '2026-01-10', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2489, 2, 16, 0, '2026-01-11', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2490, 2, 16, 0, '2026-01-12', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2491, 2, 16, 0, '2026-01-13', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2492, 2, 16, 0, '2026-01-14', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2493, 2, 16, 0, '2026-01-15', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2494, 2, 16, 0, '2026-01-16', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2495, 2, 16, 0, '2026-01-17', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2496, 2, 16, 0, '2026-01-18', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2497, 2, 16, 0, '2026-01-19', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2498, 2, 16, 0, '2026-01-20', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2499, 2, 16, 0, '2026-01-21', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2500, 2, 16, 0, '2026-01-22', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2501, 2, 16, 0, '2026-01-23', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2502, 2, 16, 0, '2026-01-24', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2503, 2, 16, 0, '2026-01-25', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2504, 2, 16, 0, '2026-01-26', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2505, 2, 16, 0, '2026-01-27', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2506, 2, 16, 0, '2026-01-28', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2507, 2, 16, 0, '2026-01-29', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2508, 2, 16, 0, '2026-01-30', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2509, 2, 16, 0, '2026-01-31', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2510, 2, 16, 0, '2026-02-01', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2511, 2, 16, 0, '2026-02-02', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2512, 2, 16, 0, '2026-02-03', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2513, 2, 16, 0, '2026-02-04', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2514, 2, 16, 0, '2026-02-05', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2515, 2, 16, 0, '2026-02-06', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2516, 2, 16, 0, '2026-02-07', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2517, 2, 16, 0, '2026-02-08', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2518, 2, 16, 0, '2026-02-09', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2519, 2, 16, 0, '2026-02-10', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2520, 2, 16, 0, '2026-02-11', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2521, 2, 16, 0, '2026-02-12', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2522, 2, 16, 0, '2026-02-13', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2523, 2, 16, 0, '2026-02-14', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2524, 2, 16, 0, '2026-02-15', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2525, 2, 16, 0, '2026-02-16', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2526, 2, 16, 0, '2026-02-17', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2527, 2, 16, 0, '2026-02-18', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2528, 2, 16, 0, '2026-02-19', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2529, 2, 16, 0, '2026-02-20', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2530, 2, 16, 0, '2026-02-21', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2531, 2, 16, 0, '2026-02-22', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2532, 2, 16, 0, '2026-02-23', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2533, 2, 16, 0, '2026-02-24', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2534, 2, 16, 0, '2026-02-25', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2535, 2, 16, 0, '2026-02-26', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2536, 2, 16, 0, '2026-02-27', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2537, 2, 16, 0, '2026-02-28', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2538, 2, 16, 0, '2026-03-01', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2539, 2, 16, 0, '2026-03-02', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2540, 2, 16, 0, '2026-03-03', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2541, 2, 16, 0, '2026-03-04', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2542, 2, 16, 0, '2026-03-05', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2543, 2, 16, 0, '2026-03-06', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2544, 2, 16, 0, '2026-03-07', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2545, 2, 16, 0, '2026-03-08', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2546, 2, 16, 0, '2026-03-09', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2547, 2, 16, 0, '2026-03-10', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2548, 2, 16, 0, '2026-03-11', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2549, 2, 16, 0, '2026-03-12', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2550, 2, 16, 0, '2026-03-13', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2551, 2, 16, 0, '2026-03-14', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2552, 2, 16, 0, '2026-03-15', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2553, 2, 16, 0, '2026-03-16', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2554, 2, 16, 0, '2026-03-17', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2555, 2, 16, 0, '2026-03-18', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2556, 2, 16, 0, '2026-03-19', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2557, 2, 16, 0, '2026-03-20', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2558, 2, 16, 0, '2026-03-21', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2559, 2, 16, 0, '2026-03-22', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2560, 2, 16, 0, '2026-03-23', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2561, 2, 16, 0, '2026-03-24', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2562, 2, 16, 0, '2026-03-25', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2563, 2, 16, 0, '2026-03-26', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2564, 2, 16, 0, '2026-03-27', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2565, 2, 16, 0, '2026-03-28', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2566, 2, 16, 0, '2026-03-29', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2567, 2, 16, 0, '2026-03-30', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2568, 2, 16, 0, '2026-03-31', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(2569, 2, 16, 0, '2026-04-01', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-08 19:46:56'),
(3011, 1, 1, 0, '2025-12-01', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3012, 1, 1, 0, '2025-12-02', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3013, 1, 1, 0, '2025-12-03', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3014, 1, 1, 0, '2025-12-04', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3015, 1, 1, 0, '2025-12-05', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3016, 1, 1, 0, '2025-12-06', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3017, 1, 1, 0, '2025-12-07', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3018, 1, 1, 0, '2025-12-08', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3019, 1, 1, 0, '2025-12-09', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3020, 1, 1, 0, '2025-12-10', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3021, 1, 1, 0, '2025-12-11', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3022, 1, 1, 0, '2025-12-12', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3023, 1, 1, 0, '2025-12-13', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3024, 1, 1, 0, '2025-12-14', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3025, 1, 1, 0, '2025-12-15', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3026, 1, 1, 0, '2025-12-16', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3027, 1, 1, 0, '2025-12-17', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3028, 1, 1, 0, '2025-12-18', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3029, 1, 1, 0, '2025-12-19', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3030, 1, 1, 0, '2025-12-20', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3031, 1, 1, 0, '2025-12-21', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3032, 1, 1, 0, '2025-12-22', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3033, 1, 1, 0, '2025-12-23', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3034, 1, 1, 0, '2025-12-24', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3035, 1, 1, 0, '2025-12-25', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3036, 1, 1, 0, '2025-12-26', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3037, 1, 1, 0, '2025-12-27', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3038, 1, 1, 0, '2025-12-28', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3039, 1, 1, 0, '2025-12-29', 1, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-12 18:37:18'),
(3040, 1, 1, 0, '2025-12-30', 1, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-12 18:37:18'),
(3041, 1, 1, 0, '2025-12-31', 1, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-12 18:37:18'),
(3042, 1, 1, 0, '2026-01-01', 1, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-12 18:37:18'),
(3043, 1, 1, 0, '2026-01-02', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3044, 1, 1, 0, '2026-01-03', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3045, 1, 1, 0, '2026-01-04', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3046, 1, 1, 0, '2026-01-05', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3047, 1, 1, 0, '2026-01-06', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3048, 1, 1, 0, '2026-01-07', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3049, 1, 1, 0, '2026-01-08', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3050, 1, 1, 0, '2026-01-09', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3051, 1, 1, 0, '2026-01-10', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3052, 1, 1, 0, '2026-01-11', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3053, 1, 1, 0, '2026-01-12', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3054, 1, 1, 0, '2026-01-13', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3055, 1, 1, 0, '2026-01-14', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3056, 1, 1, 0, '2026-01-15', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3057, 1, 1, 0, '2026-01-16', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3058, 1, 1, 0, '2026-01-17', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3059, 1, 1, 0, '2026-01-18', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3060, 1, 1, 0, '2026-01-19', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3061, 1, 1, 0, '2026-01-20', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3062, 1, 1, 0, '2026-01-21', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3063, 1, 1, 0, '2026-01-22', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3064, 1, 1, 0, '2026-01-23', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3065, 1, 1, 0, '2026-01-24', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3066, 1, 1, 0, '2026-01-25', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3067, 1, 1, 0, '2026-01-26', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3068, 1, 1, 0, '2026-01-27', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3069, 1, 1, 0, '2026-01-28', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3070, 1, 1, 0, '2026-01-29', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3071, 1, 1, 0, '2026-01-30', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3072, 1, 1, 0, '2026-01-31', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, 90.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 17:44:17'),
(3077, 1, 2, 0, '2026-01-12', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-15 18:14:41'),
(3078, 1, 2, 0, '2026-01-13', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-15 18:14:41'),
(3079, 1, 2, 0, '2026-01-14', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-15 18:14:41'),
(3080, 1, 2, 0, '2026-01-15', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-15 18:14:41'),
(3081, 1, 2, 0, '2026-01-16', 1, 0, 0, 1, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-15 18:14:41'),
(3212, 1, 1, 0, '2026-02-20', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, '2026-03-04 13:40:58'),
(3213, 1, 1, 0, '2026-02-21', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, '2026-03-04 13:40:58'),
(3214, 1, 1, 0, '2026-02-22', 0, 0, 0, 1, 30, 100.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, '2026-03-04 13:40:58');

-- --------------------------------------------------------

--
-- Structure de la table `rate_duration`
--

CREATE TABLE `rate_duration` (
  `id` bigint NOT NULL,
  `rate_id` bigint NOT NULL,
  `nights_duration` int NOT NULL,
  `price_per_night` decimal(10,2) NOT NULL
) ;

--
-- Déchargement des données de la table `rate_duration`
--

INSERT INTO `rate_duration` (`id`, `rate_id`, `nights_duration`, `price_per_night`) VALUES
(1, 1, 2, 106.00),
(2, 2, 2, 106.00),
(3, 3, 2, 106.00),
(4, 4, 2, 96.00),
(5, 5, 2, 96.00),
(6, 6, 2, 96.00),
(7, 7, 2, 106.00),
(8, 8, 2, 106.00),
(9, 9, 2, 106.00),
(10, 10, 2, 96.00),
(11, 11, 2, 96.00),
(12, 12, 2, 96.00),
(13, 13, 2, 106.00),
(14, 14, 2, 106.00),
(15, 15, 2, 106.00),
(16, 16, 2, 96.00),
(17, 17, 2, 96.00),
(18, 18, 2, 96.00),
(19, 19, 2, 106.00),
(20, 20, 2, 106.00),
(21, 21, 2, 106.00),
(22, 22, 2, 96.00),
(23, 23, 2, 96.00),
(24, 24, 2, 96.00),
(32, 1, 7, 113.00),
(33, 2, 7, 106.00),
(34, 3, 7, 92.00),
(35, 4, 7, 75.00),
(36, 5, 7, 71.00),
(37, 6, 7, 58.00),
(38, 7, 7, 113.00),
(39, 8, 7, 106.00),
(40, 9, 7, 92.00),
(41, 10, 7, 75.00),
(42, 11, 7, 71.00),
(43, 12, 7, 58.00),
(44, 13, 7, 113.00),
(45, 14, 7, 106.00),
(46, 15, 7, 92.00),
(47, 16, 7, 75.00),
(48, 17, 7, 71.00),
(49, 18, 7, 58.00),
(50, 19, 7, 113.00),
(51, 20, 7, 106.00),
(52, 21, 7, 92.00),
(53, 22, 7, 75.00),
(54, 23, 7, 71.00),
(55, 24, 7, 58.00),
(63, 32, 2, 146.00),
(64, 33, 2, 146.00),
(65, 34, 2, 146.00),
(66, 35, 2, 134.00),
(67, 36, 2, 134.00),
(68, 37, 2, 134.00),
(69, 38, 2, 146.00),
(70, 39, 2, 146.00),
(71, 40, 2, 146.00),
(72, 41, 2, 134.00),
(73, 42, 2, 134.00),
(74, 43, 2, 134.00),
(75, 44, 2, 146.00),
(76, 45, 2, 146.00),
(77, 46, 2, 146.00),
(78, 47, 2, 134.00),
(79, 48, 2, 134.00),
(80, 49, 2, 134.00),
(94, 32, 7, 153.00),
(95, 33, 7, 146.00),
(96, 34, 7, 131.00),
(97, 35, 7, 99.00),
(98, 36, 7, 89.00),
(99, 37, 7, 78.00),
(100, 38, 7, 153.00),
(101, 39, 7, 146.00),
(102, 40, 7, 131.00),
(103, 41, 7, 99.00),
(104, 42, 7, 89.00),
(105, 43, 7, 78.00),
(106, 44, 7, 153.00),
(107, 45, 7, 146.00),
(108, 46, 7, 131.00),
(109, 47, 7, 99.00),
(110, 48, 7, 89.00),
(111, 49, 7, 78.00),
(125, 63, 2, 134.00),
(126, 64, 2, 134.00),
(127, 65, 2, 134.00),
(128, 66, 2, 124.00),
(129, 67, 2, 124.00),
(130, 68, 2, 124.00),
(132, 63, 7, 141.00),
(133, 64, 7, 133.00),
(134, 65, 7, 118.00),
(135, 66, 7, 90.00),
(136, 67, 7, 85.00),
(137, 68, 7, 70.00),
(139, 70, 2, 134.00),
(140, 71, 2, 134.00),
(141, 72, 2, 134.00),
(142, 73, 2, 124.00),
(143, 74, 2, 124.00),
(144, 75, 2, 124.00),
(146, 70, 7, 133.00),
(147, 71, 7, 127.00),
(148, 72, 7, 118.00),
(149, 73, 7, 90.00),
(150, 74, 7, 85.00),
(151, 75, 7, 70.00),
(153, 77, 2, 134.00),
(154, 78, 2, 134.00),
(155, 79, 2, 134.00),
(156, 80, 2, 124.00),
(157, 81, 2, 124.00),
(158, 82, 2, 124.00),
(160, 77, 7, 141.00),
(161, 78, 7, 133.00),
(162, 79, 7, 118.00),
(163, 80, 7, 90.00),
(164, 81, 7, 85.00),
(165, 82, 7, 70.00),
(167, 84, 2, 194.00),
(168, 85, 2, 194.00),
(169, 86, 2, 194.00),
(170, 87, 2, 178.00),
(171, 88, 2, 178.00),
(172, 89, 2, 178.00),
(174, 84, 7, 199.00),
(175, 85, 7, 189.00),
(176, 86, 7, 165.00),
(177, 87, 7, 131.00),
(178, 88, 7, 123.00),
(179, 89, 7, 104.00);

-- --------------------------------------------------------

--
-- Structure de la table `season`
--

CREATE TABLE `season` (
  `id` bigint NOT NULL,
  `property_id` bigint NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `season`
--

INSERT INTO `season` (`id`, `property_id`, `name`) VALUES
(1, 1, '2025 - S1'),
(2, 1, '2025 - S2'),
(3, 1, '2025 - S3'),
(4, 1, '2025 - S4'),
(5, 1, '2025 - S5'),
(6, 1, '2025 - S6');

-- --------------------------------------------------------

--
-- Structure de la table `season_period`
--

CREATE TABLE `season_period` (
  `id` bigint NOT NULL,
  `property_id` bigint NOT NULL,
  `season_id` bigint NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Structure de la table `status_transition`
--

CREATE TABLE `status_transition` (
  `from_status_id` bigint NOT NULL,
  `to_status_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `status_transition`
--

INSERT INTO `status_transition` (`from_status_id`, `to_status_id`) VALUES
(1, 2),
(1, 3),
(2, 3),
(1, 4),
(2, 4),
(3, 4);

-- --------------------------------------------------------

--
-- Structure de la table `stripe_event`
--

CREATE TABLE `stripe_event` (
  `id` bigint NOT NULL,
  `stripe_event_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` int DEFAULT NULL,
  `livemode` tinyint(1) NOT NULL DEFAULT '0',
  `stripe_account_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raw_json` json DEFAULT NULL,
  `received_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `stripe_payment`
--

CREATE TABLE `stripe_payment` (
  `id` bigint NOT NULL,
  `booking_payment_id` bigint NOT NULL,
  `stripe_payment_intent_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_charge_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_event_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_connected_account_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `livemode` tinyint(1) NOT NULL DEFAULT '0',
  `amount_cents` int DEFAULT NULL,
  `currency` char(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EUR',
  `application_fee_cents` int DEFAULT NULL,
  `stripe_status` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raw_json` json DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `stripe_payment`
--

INSERT INTO `stripe_payment` (`id`, `booking_payment_id`, `stripe_payment_intent_id`, `stripe_charge_id`, `stripe_event_id`, `stripe_connected_account_id`, `livemode`, `amount_cents`, `currency`, `application_fee_cents`, `stripe_status`, `raw_json`, `created_at`, `updated_at`) VALUES
(1, 3, 'pi_3StBHQ2HImv7nZLG15cdEkRU', NULL, NULL, 'acct_1SrLC8C6HknzjKqY', 0, 9200, 'EUR', NULL, 'succeeded', '{\"id\": \"pi_3StBHQ2HImv7nZLG15cdEkRU\", \"amount\": 9200, \"object\": \"payment_intent\", \"review\": null, \"source\": null, \"status\": \"succeeded\", \"created\": 1769278192, \"currency\": \"eur\", \"customer\": null, \"livemode\": false, \"metadata\": {\"booking_id\": \"60\", \"property_id\": \"2\", \"customer_name\": \"David Jeanrenaud David\"}, \"shipping\": null, \"processing\": null, \"application\": null, \"canceled_at\": null, \"description\": \"Réservation #60\", \"next_action\": null, \"on_behalf_of\": null, \"client_secret\": \"pi_3StBHQ2HImv7nZLG15cdEkRU_secret_HB4uir1hnXIUHilFyLU8Op4gT\", \"latest_charge\": \"ch_3StBHQ2HImv7nZLG1cSmKgpu\", \"receipt_email\": \"rubenjeanrenaud@gmail.com\", \"transfer_data\": {\"destination\": \"acct_1SrLC8C6HknzjKqY\"}, \"amount_details\": {\"tip\": []}, \"capture_method\": \"automatic_async\", \"payment_method\": \"pm_1StBIP2HImv7nZLGZvQEBXu0\", \"transfer_group\": \"group_pi_3StBHQ2HImv7nZLG15cdEkRU\", \"amount_received\": 9200, \"customer_account\": null, \"amount_capturable\": 0, \"last_payment_error\": null, \"setup_future_usage\": null, \"cancellation_reason\": null, \"confirmation_method\": \"automatic\", \"payment_method_types\": [\"card\", \"bancontact\", \"eps\", \"klarna\", \"link\", \"amazon_pay\"], \"statement_descriptor\": null, \"application_fee_amount\": null, \"payment_method_options\": {\"eps\": [], \"card\": {\"network\": null, \"installments\": null, \"mandate_options\": null, \"request_three_d_secure\": \"automatic\"}, \"link\": {\"persistent_token\": null}, \"klarna\": {\"preferred_locale\": null}, \"amazon_pay\": {\"express_checkout_element_session_id\": null}, \"bancontact\": {\"preferred_language\": \"en\"}}, \"automatic_payment_methods\": {\"enabled\": true, \"allow_redirects\": \"always\"}, \"statement_descriptor_suffix\": null, \"excluded_payment_method_types\": null, \"payment_method_configuration_details\": {\"id\": \"pmc_1SrKYa2HImv7nZLGP1NYCAwv\", \"parent\": null}}', '2026-01-24 19:10:54', NULL),
(2, 4, 'pi_3StBJG2HImv7nZLG0cdRqwYC', NULL, NULL, 'acct_1SrLC8C6HknzjKqY', 0, 1200, 'EUR', NULL, 'succeeded', '{\"id\": \"pi_3StBJG2HImv7nZLG0cdRqwYC\", \"amount\": 1200, \"object\": \"payment_intent\", \"review\": null, \"source\": null, \"status\": \"succeeded\", \"created\": 1769278306, \"currency\": \"eur\", \"customer\": null, \"livemode\": false, \"metadata\": {\"booking_id\": \"60\", \"property_id\": \"2\", \"customer_name\": \"David Jeanrenaud David\"}, \"shipping\": null, \"processing\": null, \"application\": null, \"canceled_at\": null, \"description\": \"Réservation #60\", \"next_action\": null, \"on_behalf_of\": null, \"client_secret\": \"pi_3StBJG2HImv7nZLG0cdRqwYC_secret_Xe8hhjbjoBbx14AgZCZh15FU3\", \"latest_charge\": \"ch_3StBJG2HImv7nZLG0ao7nxec\", \"receipt_email\": \"rubenjeanrenaud@gmail.com\", \"transfer_data\": {\"destination\": \"acct_1SrLC8C6HknzjKqY\"}, \"amount_details\": {\"tip\": []}, \"capture_method\": \"automatic_async\", \"payment_method\": \"pm_1StBLN2HImv7nZLGAZhIKTrw\", \"transfer_group\": \"group_pi_3StBJG2HImv7nZLG0cdRqwYC\", \"amount_received\": 1200, \"customer_account\": null, \"amount_capturable\": 0, \"last_payment_error\": null, \"setup_future_usage\": null, \"cancellation_reason\": null, \"confirmation_method\": \"automatic\", \"payment_method_types\": [\"card\", \"bancontact\", \"eps\", \"klarna\", \"link\", \"amazon_pay\"], \"statement_descriptor\": null, \"application_fee_amount\": null, \"payment_method_options\": {\"eps\": [], \"card\": {\"network\": null, \"installments\": null, \"mandate_options\": null, \"request_three_d_secure\": \"automatic\"}, \"link\": {\"persistent_token\": null}, \"klarna\": {\"preferred_locale\": null}, \"amazon_pay\": {\"express_checkout_element_session_id\": null}, \"bancontact\": {\"preferred_language\": \"en\"}}, \"automatic_payment_methods\": {\"enabled\": true, \"allow_redirects\": \"always\"}, \"statement_descriptor_suffix\": null, \"excluded_payment_method_types\": null, \"payment_method_configuration_details\": {\"id\": \"pmc_1SrKYa2HImv7nZLGP1NYCAwv\", \"parent\": null}}', '2026-01-24 19:13:59', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `tourist_tax`
--

CREATE TABLE `tourist_tax` (
  `id` bigint NOT NULL,
  `property_id` bigint NOT NULL,
  `unit_id` bigint NOT NULL,
  `amount_adult` decimal(6,2) NOT NULL,
  `amount_child` decimal(6,2) DEFAULT '0.00',
  `currency` char(3) DEFAULT 'EUR',
  `active` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Doublure de structure pour la vue `v_reservation_statut_courant`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `v_reservation_statut_courant` (
);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `app_config`
--
ALTER TABLE `app_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_appcfg` ((coalesce(`property_id`,0)), (coalesce(`unit_id`,0)), ),
  ADD KEY `idx_appcfg_prop_name` (`property_id`,`name`),
  ADD KEY `idx_appcfg_unit_name` (`unit_id`,`name`);

--
-- Index pour la table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_booking_ext` (`external_source`,`external_uid`,`id`) USING BTREE,
  ADD KEY `client_id` (`customer_id`),
  ADD KEY `regle_id` (`booking_rule_id`),
  ADD KEY `canal_id` (`channel_id`),
  ADD KEY `fk_booking_property` (`property_id`);

--
-- Index pour la table `booking_guest`
--
ALTER TABLE `booking_guest`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_occ_reslogement` (`reservation_unit_id`);

--
-- Index pour la table `booking_payment`
--
ALTER TABLE `booking_payment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_bp_booking` (`booking_id`),
  ADD KEY `idx_bp_property` (`property_id`),
  ADD KEY `idx_bp_paid_at` (`paid_at`),
  ADD KEY `idx_bp_status` (`status`);

--
-- Index pour la table `booking_rule`
--
ALTER TABLE `booking_rule`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `booking_status`
--
ALTER TABLE `booking_status`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_resstat_reslogement` (`booking_unit_id`),
  ADD KEY `idx_resstat_statut` (`status_id`);

--
-- Index pour la table `booking_status_type`
--
ALTER TABLE `booking_status_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Index pour la table `booking_unit`
--
ALTER TABLE `booking_unit`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_bu_ext` (`external_source`,`external_uid`,`unit_id`,`id`) USING BTREE,
  ADD KEY `reservation_id` (`booking_id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `idx_reslog_status_id` (`status_id`),
  ADD KEY `fk_bookingunit_property` (`property_id`);

--
-- Index pour la table `booking_unit_charge_choice`
--
ALTER TABLE `booking_unit_charge_choice`
  ADD PRIMARY KEY (`booking_unit_id`,`charge_catalog_id`),
  ADD KEY `idx_choice_charge` (`charge_catalog_id`);

--
-- Index pour la table `channel`
--
ALTER TABLE `channel`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`);

--
-- Index pour la table `channel_import_log`
--
ALTER TABLE `channel_import_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_lookup` (`channel_id`,`unit_id`,`external_uid`),
  ADD KEY `fk_importlog_unit` (`unit_id`),
  ADD KEY `fk_channelimport_property` (`property_id`);

--
-- Index pour la table `channel_mapping`
--
ALTER TABLE `channel_mapping`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_channel_key` (`channel_id`,`external_key`,`target_table`,`target_field`),
  ADD KEY `fk_channelmapping_property` (`property_id`);

--
-- Index pour la table `channel_unit`
--
ALTER TABLE `channel_unit`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_channel_unit` (`channel_id`,`unit_id`),
  ADD KEY `fk_channel_unit_unit` (`unit_id`),
  ADD KEY `fk_channelunit_property` (`property_id`);

--
-- Index pour la table `charge_booking`
--
ALTER TABLE `charge_booking`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_charges_resa_logement` (`booking_unit_id`),
  ADD KEY `idx_charge_booking_catalog` (`charge_catalog_id`);

--
-- Index pour la table `charge_catalog`
--
ALTER TABLE `charge_catalog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `idx_charge_catalog_validity` (`property_id`,`unit_id`,`label`,`valid_from`,`valid_to`);

--
-- Index pour la table `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_customer_property` (`property_id`);

--
-- Index pour la table `housekeeping_task`
--
ALTER TABLE `housekeeping_task`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `reservation_id` (`booking_id`),
  ADD KEY `fk_housekeeping_property` (`property_id`);

--
-- Index pour la table `maintenance_ticket`
--
ALTER TABLE `maintenance_ticket`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `fk_maintenance_property` (`property_id`);

--
-- Index pour la table `rate`
--
ALTER TABLE `rate`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `saison_id` (`season_id`),
  ADD KEY `fk_rate_property` (`property_id`);

--
-- Index pour la table `rate_calendar`
--
ALTER TABLE `rate_calendar`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_ratecal` (`property_id`,`unit_id`,`channel_id`,`day`),
  ADD KEY `idx_ratecal_lookup` (`unit_id`,`day`,`channel_id`);

--
-- Index pour la table `rate_duration`
--
ALTER TABLE `rate_duration`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_tarif_duree` (`rate_id`,`nights_duration`);

--
-- Index pour la table `season`
--
ALTER TABLE `season`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_season_property` (`property_id`);

--
-- Index pour la table `season_period`
--
ALTER TABLE `season_period`
  ADD PRIMARY KEY (`id`),
  ADD KEY `saison_id` (`season_id`),
  ADD KEY `fk_seasonperiod_property` (`property_id`);

--
-- Index pour la table `status_transition`
--
ALTER TABLE `status_transition`
  ADD PRIMARY KEY (`from_status_id`,`to_status_id`),
  ADD KEY `to_statut_id` (`to_status_id`);

--
-- Index pour la table `stripe_event`
--
ALTER TABLE `stripe_event`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_se_event` (`stripe_event_id`),
  ADD KEY `idx_se_type` (`type`),
  ADD KEY `idx_se_account` (`stripe_account_id`);

--
-- Index pour la table `stripe_payment`
--
ALTER TABLE `stripe_payment`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_sp_booking_payment` (`booking_payment_id`),
  ADD UNIQUE KEY `uk_sp_pi` (`stripe_payment_intent_id`),
  ADD KEY `idx_sp_charge` (`stripe_charge_id`),
  ADD KEY `idx_sp_event` (`stripe_event_id`);

--
-- Index pour la table `tourist_tax`
--
ALTER TABLE `tourist_tax`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logement_id` (`unit_id`),
  ADD KEY `fk_touristtax_property` (`property_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `app_config`
--
ALTER TABLE `app_config`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT pour la table `booking`
--
ALTER TABLE `booking`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT pour la table `booking_guest`
--
ALTER TABLE `booking_guest`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `booking_payment`
--
ALTER TABLE `booking_payment`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `booking_rule`
--
ALTER TABLE `booking_rule`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `booking_status`
--
ALTER TABLE `booking_status`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT pour la table `booking_status_type`
--
ALTER TABLE `booking_status_type`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `booking_unit`
--
ALTER TABLE `booking_unit`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;

--
-- AUTO_INCREMENT pour la table `channel`
--
ALTER TABLE `channel`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `channel_import_log`
--
ALTER TABLE `channel_import_log`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT pour la table `channel_mapping`
--
ALTER TABLE `channel_mapping`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT pour la table `channel_unit`
--
ALTER TABLE `channel_unit`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `charge_booking`
--
ALTER TABLE `charge_booking`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=220;

--
-- AUTO_INCREMENT pour la table `charge_catalog`
--
ALTER TABLE `charge_catalog`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT pour la table `customer`
--
ALTER TABLE `customer`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12542;

--
-- AUTO_INCREMENT pour la table `housekeeping_task`
--
ALTER TABLE `housekeeping_task`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `maintenance_ticket`
--
ALTER TABLE `maintenance_ticket`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `rate`
--
ALTER TABLE `rate`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT pour la table `rate_calendar`
--
ALTER TABLE `rate_calendar`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3215;

--
-- AUTO_INCREMENT pour la table `rate_duration`
--
ALTER TABLE `rate_duration`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `season`
--
ALTER TABLE `season`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `season_period`
--
ALTER TABLE `season_period`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `stripe_event`
--
ALTER TABLE `stripe_event`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `stripe_payment`
--
ALTER TABLE `stripe_payment`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `tourist_tax`
--
ALTER TABLE `tourist_tax`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Structure de la vue `booking_payment_sum`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`salagombooking`@`%` SQL SECURITY DEFINER VIEW `booking_payment_sum`  AS SELECT `booking_payment`.`booking_id` AS `booking_id`, sum((case when (`booking_payment`.`status` in ('captured','partial_capture')) then `booking_payment`.`amount` when (`booking_payment`.`status` = 'refunded') then -(`booking_payment`.`amount`) else 0 end)) AS `total_paid`, min(`booking_payment`.`paid_at`) AS `first_paid_at`, max(`booking_payment`.`paid_at`) AS `last_paid_at` FROM `booking_payment` GROUP BY `booking_payment`.`booking_id` ;

-- --------------------------------------------------------

--
-- Structure de la vue `v_reservation_statut_courant`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`salagombooking`@`%` SQL SECURITY DEFINER VIEW `v_reservation_statut_courant`  AS SELECT `rs`.`reservation_id` AS `reservation_id`, `rs`.`statut_id` AS `statut_id`, `s`.`code` AS `code`, `s`.`libelle` AS `libelle`, `s`.`couleur` AS `couleur`, `rs`.`changed_at` AS `changed_at` FROM ((`reservations_statuts` `rs` join (select `reservations_statuts`.`reservation_id` AS `reservation_id`,max(`reservations_statuts`.`changed_at`) AS `last_change` from `reservations_statuts` group by `reservations_statuts`.`reservation_id`) `last` on(((`last`.`reservation_id` = `rs`.`reservation_id`) and (`last`.`last_change` = `rs`.`changed_at`)))) join `statuts_reservation` `s` on((`s`.`id` = `rs`.`statut_id`))) ;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `app_config`
--
ALTER TABLE `app_config`
  ADD CONSTRAINT `fk_appcfg_prop` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_appcfg_unit` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `booking`
--
ALTER TABLE `booking`
  ADD CONSTRAINT `booking_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`),
  ADD CONSTRAINT `booking_ibfk_3` FOREIGN KEY (`booking_rule_id`) REFERENCES `booking_rule` (`id`),
  ADD CONSTRAINT `fk_booking_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`);

--
-- Contraintes pour la table `booking_guest`
--
ALTER TABLE `booking_guest`
  ADD CONSTRAINT `fk_occ_reslogement` FOREIGN KEY (`reservation_unit_id`) REFERENCES `booking_unit` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `booking_payment`
--
ALTER TABLE `booking_payment`
  ADD CONSTRAINT `fk_bp_booking` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_bp_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `booking_status`
--
ALTER TABLE `booking_status`
  ADD CONSTRAINT `fk_resstat_reslogement` FOREIGN KEY (`booking_unit_id`) REFERENCES `booking_unit` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_resstat_stat` FOREIGN KEY (`status_id`) REFERENCES `booking_status_type` (`id`);

--
-- Contraintes pour la table `booking_unit`
--
ALTER TABLE `booking_unit`
  ADD CONSTRAINT `booking_unit_ibfk_1` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `booking_unit_ibfk_2` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_bookingunit_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `fk_reslog_statut` FOREIGN KEY (`status_id`) REFERENCES `booking_status_type` (`id`);

--
-- Contraintes pour la table `channel_import_log`
--
ALTER TABLE `channel_import_log`
  ADD CONSTRAINT `fk_channelimport_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `fk_importlog_channel` FOREIGN KEY (`channel_id`) REFERENCES `channel` (`id`),
  ADD CONSTRAINT `fk_importlog_unit` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`);

--
-- Contraintes pour la table `channel_mapping`
--
ALTER TABLE `channel_mapping`
  ADD CONSTRAINT `fk_channel_mapping_channel` FOREIGN KEY (`channel_id`) REFERENCES `channel` (`id`);

--
-- Contraintes pour la table `channel_unit`
--
ALTER TABLE `channel_unit`
  ADD CONSTRAINT `fk_channel_unit_channel` FOREIGN KEY (`channel_id`) REFERENCES `channel` (`id`),
  ADD CONSTRAINT `fk_channel_unit_unit` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`),
  ADD CONSTRAINT `fk_channelunit_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`);

--
-- Contraintes pour la table `charge_booking`
--
ALTER TABLE `charge_booking`
  ADD CONSTRAINT `fk_charges_resa_logement` FOREIGN KEY (`booking_unit_id`) REFERENCES `booking_unit` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `charge_catalog`
--
ALTER TABLE `charge_catalog`
  ADD CONSTRAINT `charge_catalog_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`),
  ADD CONSTRAINT `fk_chargecatalog_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`);

--
-- Contraintes pour la table `customer`
--
ALTER TABLE `customer`
  ADD CONSTRAINT `fk_customer_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`);

--
-- Contraintes pour la table `housekeeping_task`
--
ALTER TABLE `housekeeping_task`
  ADD CONSTRAINT `fk_housekeeping_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `housekeeping_task_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`),
  ADD CONSTRAINT `housekeeping_task_ibfk_2` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`);

--
-- Contraintes pour la table `maintenance_ticket`
--
ALTER TABLE `maintenance_ticket`
  ADD CONSTRAINT `fk_maintenance_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `maintenance_ticket_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`);

--
-- Contraintes pour la table `rate`
--
ALTER TABLE `rate`
  ADD CONSTRAINT `fk_rate_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `rate_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`),
  ADD CONSTRAINT `rate_ibfk_2` FOREIGN KEY (`season_id`) REFERENCES `season` (`id`);

--
-- Contraintes pour la table `rate_calendar`
--
ALTER TABLE `rate_calendar`
  ADD CONSTRAINT `fk_ratecal_prop` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ratecal_unit` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `rate_duration`
--
ALTER TABLE `rate_duration`
  ADD CONSTRAINT `fk_rate_duration_rate` FOREIGN KEY (`rate_id`) REFERENCES `rate` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `season`
--
ALTER TABLE `season`
  ADD CONSTRAINT `fk_season_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`);

--
-- Contraintes pour la table `season_period`
--
ALTER TABLE `season_period`
  ADD CONSTRAINT `fk_seasonperiod_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `season_period_ibfk_1` FOREIGN KEY (`season_id`) REFERENCES `season` (`id`);

--
-- Contraintes pour la table `status_transition`
--
ALTER TABLE `status_transition`
  ADD CONSTRAINT `status_transition_ibfk_1` FOREIGN KEY (`from_status_id`) REFERENCES `booking_status_type` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_transition_ibfk_2` FOREIGN KEY (`to_status_id`) REFERENCES `booking_status_type` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `stripe_payment`
--
ALTER TABLE `stripe_payment`
  ADD CONSTRAINT `fk_sp_booking_payment` FOREIGN KEY (`booking_payment_id`) REFERENCES `booking_payment` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `tourist_tax`
--
ALTER TABLE `tourist_tax`
  ADD CONSTRAINT `fk_touristtax_property` FOREIGN KEY (`property_id`) REFERENCES `property` (`id`),
  ADD CONSTRAINT `tourist_tax_ibfk_1` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`);
COMMIT;

