/**
 * @author dbu
 * @date 12/08/22
 * @version 1.0.0
 * @project SIEau
 * @table codes_sandre
 */

# --- !Ups
insert into codes_sandre (champ, code, libelle, datecreation)
    (select 'ANALYSES.LIEU', 0, 'Localisation inconnue', now()
     from codes_sandre
     where not exists (select champ, code from codes_sandre where champ='ANALYSES.LIEU' and code=0) limit 1
    )

# --- !Downs

