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

# --- !Ups

ALTER TABLE public.mat_telecom DROP dateouverture;
ALTER TABLE public.mat_telecom DROP datecloture;
ALTER TABLE public.mat_telecom DROP causecloture;
ALTER TABLE public.mat_telecom DROP noligne;
ALTER TABLE public.mat_telecom DROP dateretrait;
ALTER TABLE public.mat_telecom DROP dateremplacement;
ALTER TABLE public.mat_telecom DROP dateexpirationgarantie;
ALTER TABLE public.mat_telecom ADD dureegarantie integer;

# --- !Downs

ALTER TABLE public.mat_telecom ADD dateouverture timestamp with time zone NULL;
ALTER TABLE public.mat_telecom ADD datecloture timestamp with time zone NULL;
ALTER TABLE public.mat_telecom ADD causecloture text NULL;
ALTER TABLE public.mat_telecom ADD noligne varchar(100) NULL;
ALTER TABLE public.mat_telecom ADD dateretrait timestamp with time zone null;
ALTER TABLE public.mat_telecom ADD dateremplacement timestamp with time zone null;
ALTER TABLE public.mat_telecom DROP dureegarantie;
ALTER TABLE public.mat_telecom ADD dateexpirationgarantie timestamp without time zone null;