-- Tags de personnes sur les photos d'événements
CREATE TABLE IF NOT EXISTS event_photo_tags (
    id         CHAR(36) NOT NULL PRIMARY KEY,
    photo_id   CHAR(36) NOT NULL,
    user_id    CHAR(36) NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_photo_user (photo_id, user_id),
    KEY idx_tag_user (user_id),
    CONSTRAINT fk_pt_photo FOREIGN KEY (photo_id) REFERENCES event_photos(id) ON DELETE CASCADE,
    CONSTRAINT fk_pt_user  FOREIGN KEY (user_id)  REFERENCES users(id)        ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;