/**
 * @author jro
 * @date 18/11/21
 * @version 1.0.0
 * @project SIEau
 * @table agri_prel_reservoirs_periodes
 */

# --- !Ups
DROP TABLE IF EXISTS agri_prel_reservoirs_periodes;
create table agri_prel_reservoirs_periodes (
idreservoir bigint,
idperiode bigint,
idnumeroperiode bigint,
loginmaj varchar(50),
datemaj timestamp with time zone
);

DROP TABLE IF EXISTS agri_declarations_reservoirs_periodes_maj;
create table agri_declarations_reservoirs_periodes_maj (
idreservoir bigint,
enqueteid bigint,
idperiode bigint,
idnumeroperiode bigint,
loginmaj varchar(50),
datemaj timestamp with time zone
);

# --- !Downs

drop table agri_prel_reservoirs_periodes ;
drop table agri_declarations_reservoirs_periodes_maj;