/**
 * @author Emmanuel BONNEAU
 * @date 23/02/21
 * @version 1.0.0
 * @project SIEau
 * @table public.mat_centrales
 */

# --- !Ups

ALTER TABLE public.mat_centrales DROP dateretrait CASCADE;
ALTER TABLE public.mat_centrales DROP dateremplacement CASCADE;
ALTER TABLE public.mat_centrales DROP dateexpirationgarantie CASCADE;
ALTER TABLE public.mat_centrales ADD dureegarantie integer;


# --- !Downs

ALTER TABLE public.mat_centrales ADD dateretrait timestamp with time zone null;
ALTER TABLE public.mat_centrales ADD dateremplacement timestamp with time zone null;
ALTER TABLE public.mat_centrales DROP dureegarantie;
ALTER TABLE public.mat_centrales ADD dateexpirationgarantie timestamp without time zone null;