/**
 * @author sbarthon
 * @date 21/09/21
 * @version 1.0.0
 * @project SIEau
 * @table agri_usages et agri_prel_volumes
 */

# --- !Ups
ALTER TABLE agri_usages ADD COLUMN saisieVolumeReel boolean;
ALTER TABLE agri_usages ADD COLUMN afficherVolumeSiCompteur boolean;
ALTER TABLE agri_prel_volumes ADD COLUMN debitAutorisation real;
ALTER TABLE agri_prel_volumes ADD COLUMN volumeDemandeEtiage real;
ALTER TABLE agri_prel_volumes ADD COLUMN volumeAttribueEtiage real;
ALTER TABLE agri_prel_volumes ADD COLUMN volumeAutorisEtiage real;

# --- !Downs

ALTER TABLE agri_usages DROP COLUMN saisieVolumeReel boolean;
ALTER TABLE agri_usages DROP COLUMN afficherVolumeSiCompteur boolean;
ALTER TABLE agri_prel_volumes DROP COLUMN debitAutorisation real;
ALTER TABLE agri_prel_volumes DROP COLUMN volumeDemandeEtiage real;
ALTER TABLE agri_prel_volumes DROP COLUMN volumeAttribueEtiage real;
ALTER TABLE agri_prel_volumes DROP COLUMN volumeAutorisEtiage real;