/**
 * @author AMR
 * @date 17/06/21
 * @version 1.0.0
 * @project SIEAU
 * @table public.codes_sandres
 */

# --- !Ups
update codes_sandre set codereference ='A' where champ ='ANALYSES.STATUT' and code='1';
update codes_sandre set codereference ='B' where champ ='ANALYSES.STATUT' and code='2';
update codes_sandre set codereference ='C' where champ ='ANALYSES.STATUT' and code='3';
update codes_sandre set codereference ='D' where champ ='ANALYSES.STATUT' and code='4';
# --- !Downs
update codes_sandre set codereference ='' where champ ='ANALYSES.STATUT';