CREATE TABLE IF NOT EXISTS t_interests (
    interest_id          INT AUTO_INCREMENT PRIMARY KEY,
    interest_title       VARCHAR(255) NOT NULL,
    interest_description TEXT NULL,
    interest_icon        VARCHAR(50) NULL COMMENT 'Emoji ou nom d''icône',
    interest_order       INT NOT NULL DEFAULT 0,
    interest_created_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx01_interests (interest_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- DOWN

DROP TABLE IF EXISTS t_interests;
