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

# --- !Ups

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

# --- !Downs

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