/**
 * @author ebonneau
 * @date 16/02/22
 * @version 1.0.0
 * @project SIEau
 * @table : inst_prise_eau_sup
 *          inst_prise_eau_sup_equipements
 *          inst_prise_eau_sup_gc
 */

# --- !Ups
alter table if exists inst_captage_equipements rename to inst_prise_eau_sup_equipements;
alter table if exists inst_captage_gc rename to inst_prise_eau_sup_gc;

drop table if exists inst_prise_eau_sup;
create table inst_prise_eau_sup
(
    codeinstallation  bigint not null,
    siteproduction bigint,
    codeaac bigint,
    origineprelevement character varying(100),
    qmoyj real,
    natureeau integer,
    codeentitehydro integer
);

# --- !Downs
