-------+

From MariaDB 10.5.3, creating a unique index for an application-time period
table with a WITHOUT OVERLAPS constraint:

CREATE UNIQUE INDEX u ON rooms (room_number, p WITHOUT OVERLAPS);

URL: https://mariadb.com/kb/en/create-index/https://mariadb.com/kb/en/create-index/