-- Migration SQL pour la table projets

CREATE TABLE IF NOT EXISTS projets (
    id INT AUTO_INCREMENT PRIMARY KEY,
    devis_id INT NULL,
    client_id INT NULL,
    titre VARCHAR(255) NOT NULL,
    description TEXT,
    date_projet DATE NOT NULL,
    montant DECIMAL(10,2) NOT NULL DEFAULT 0,
    statut VARCHAR(50) NOT NULL DEFAULT 'Proposition',
    CONSTRAINT fk_projets_devis
        FOREIGN KEY (devis_id) REFERENCES devis(id)
        ON DELETE SET NULL,
    CONSTRAINT fk_projets_clients
        FOREIGN KEY (client_id) REFERENCES clients(id)
        ON DELETE SET NULL
);