/**
 * @author Titouan
 * @date 25/05/21
 * @version 1.0.0
 * @project SIEau
 * @table public.codes_sandre
 */

# --- !Ups

INSERT INTO CODES_SANDRE_REFERENTIEL VALUES('ACTIONS.STATUT',null, null);
INSERT INTO CODES_SANDRE ( Champ, Code, Libelle, Commentaire, statut, DateCreation, DateModification, Auteur, projet, codeReference ) 
VALUES ('ACTIONS.STATUT',0,'Actions en cours', null,null, '01/01/2020','01/01/2020',null,'SIADM',null);
INSERT INTO CODES_SANDRE ( Champ, Code, Libelle, Commentaire, statut, DateCreation, DateModification, Auteur, projet, codeReference ) 
VALUES ('ACTIONS.STATUT',1,'Actions historisées uniquement', null,null, '01/01/2020','01/01/2020',null,'SIADM',null);
INSERT INTO CODES_SANDRE ( Champ, Code, Libelle, Commentaire, statut, DateCreation, DateModification, Auteur, projet, codeReference ) 
VALUES ('ACTIONS.STATUT',2,'Toutes les actions', null,null, '01/01/2020','01/01/2020',null,'SIADM',null);

# --- !Downs
DELETE FROM CODES_SANDRE_REFERENTIEL where champ = 'ACTIONS.STATUT';
DELETE FROM CODES_SANDRE where champ = 'ACTIONS.STATUT' and code = 0;
DELETE FROM CODES_SANDRE where champ = 'ACTIONS.STATUT' and code = 1;
DELETE FROM CODES_SANDRE where champ = 'ACTIONS.STATUT' and code = 2;

