/**
 * @author sbarthon
 * @date 05/08/22
 * @version 1.0.0
 * @project SIEau
 * @table evenements_udi
 */

# --- !Ups
create table evenements_udi (
codeinstallation integer,
numero integer,
dateevenement timestamp with time zone,
commentaires text,
heureevenement timestamp with time zone,
codecontact integer,
loginmaj character varying(25),
datemaj timestamp with time zone,
type character varying(12));
create index idx_evenements_udi on evenements_udi (codeinstallation);

# --- !Downs