CREATE TABLE IF NOT EXISTS email_templates (
    id INT AUTO_INCREMENT PRIMARY KEY,
    projet_id INT NOT NULL,
    langue VARCHAR(5) NOT NULL, -- 'fr', 'en', etc.
    objet VARCHAR(255) NOT NULL,
    corps TEXT NOT NULL,
    UNIQUE(projet_id, langue),
    FOREIGN KEY (projet_id) REFERENCES projets(id) ON DELETE CASCADE
);

