CREATE TABLE IF NOT EXISTS t_skills (
    skill_id          INT AUTO_INCREMENT PRIMARY KEY,
    skill_name        VARCHAR(255) NOT NULL,
    skill_category    VARCHAR(50) NOT NULL COMMENT 'dev, project_management, marketing, certification, soft',
    skill_level       TINYINT NULL COMMENT '1-5 (optionnel)',
    skill_order       INT NOT NULL DEFAULT 0,
    skill_created_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx01_skills (skill_category),
    INDEX idx02_skills (skill_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- DOWN

DROP TABLE IF EXISTS t_skills;
