-- Migration pour la table Attribute
CREATE TABLE IF NOT EXISTS Attribute (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    type ENUM('text', 'number', 'boolean', 'date') DEFAULT 'text',
    unit VARCHAR(20),
    description TEXT,
    UNIQUE(name),
    INDEX idx_attribute_name (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
