/**
 * @author sbarthon
 * @date 28/02/22
 * @version 1.0.0
 * @project SIEau
 * @table agri_exploitations
 */

# --- !Ups

alter table agri_exploitations add column typeProcedure bigint;
insert into codes_sandre values ('DOSSIERS.TYPE_PROCEDURE',0,'Inconnu');
insert into codes_sandre values ('DOSSIERS.TYPE_PROCEDURE',1,'Mandataire');
insert into codes_sandre values ('DOSSIERS.TYPE_PROCEDURE',2,'Organisme unique');

# --- !Downs
