github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/migration/v2_to_v3/simplifie_remercie_dons.sql (about)

     1  ALTER TABLE dons
     2      ADD COLUMN remercie boolean;
     3  
     4  UPDATE
     5      dons
     6  SET
     7      remercie = CASE WHEN date_merci > '2000-01-01' THEN
     8          TRUE
     9      ELSE
    10          FALSE
    11      END;
    12  
    13  ALTER TABLE dons
    14      ALTER COLUMN remercie SET NOT NULL;
    15  
    16  ALTER TABLE dons
    17      DROP COLUMN date_merci;
    18  
    19  ALTER TABLE dons
    20      DROP COLUMN personne_merci;
    21