/**
 * @author tpasquet
 * @date 22/10/21
 * @version 1.0.0
 * @project SIEau
 * @table reperes & systemes_altimetriques
 */

# --- !Ups
ALTER TABLE reperes DROP COLUMN IF EXISTS datemaj;
ALTER TABLE reperes ADD COLUMN datemaj timestamp with time zone;
ALTER TABLE reperes_hydro DROP COLUMN IF EXISTS datemaj;
ALTER TABLE reperes_hydro ADD COLUMN datemaj timestamp with time zone;
ALTER TABLE reperes_qualito DROP COLUMN IF EXISTS datemaj;
ALTER TABLE reperes_qualito ADD COLUMN datemaj timestamp with time zone;

ALTER TABLE systemes_altimetriques DROP COLUMN IF EXISTS datemaj;
ALTER TABLE systemes_altimetriques ADD COLUMN datemaj timestamp with time zone;
ALTER TABLE systemes_altimetriques_hydro DROP COLUMN IF EXISTS datemaj;
ALTER TABLE systemes_altimetriques_hydro ADD COLUMN datemaj timestamp with time zone;
ALTER TABLE systemes_altimetriques_qualito DROP COLUMN IF EXISTS datemaj;
ALTER TABLE systemes_altimetriques_qualito ADD COLUMN datemaj timestamp with time zone;


# --- !Downs
