-- Migration 023 : table de métadonnées SEO par page
-- Stocke title, description (multilingues) + robots par owner (cobaye, spa, home…)

CREATE TABLE page_meta (
    owner         VARCHAR(100)    NOT NULL PRIMARY KEY COMMENT 'cobaye | spa | home | …',
    translations  JSON            NOT NULL             COMMENT '{"fr":{"title":"…","description":"…"},"en":{…}}',
    robots        VARCHAR(50)     NOT NULL DEFAULT 'index, follow',
    updated_at    TIMESTAMP       NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
