CREATE TABLE IF NOT EXISTS `gallery` (
    `id`           INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `therapist_id` INT UNSIGNED NOT NULL,
    `filename`     VARCHAR(255) NOT NULL,
    `alt_lv`       VARCHAR(200) NULL,
    `alt_ru`       VARCHAR(200) NULL,
    `alt_en`       VARCHAR(200) NULL,
    `sort_order`   INT NOT NULL DEFAULT 0,
    `created_at`   DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `gallery_therapist_id_index` (`therapist_id`),
    CONSTRAINT `fk_gl_therapist` FOREIGN KEY (`therapist_id`) REFERENCES `therapist_profiles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
