DROP TABLE public."connection"; CREATE TABLE public."connection" ( id serial NOT NULL, "from" int4 NOT NULL, "to" int4 NOT NULL, updated timestamptz DEFAULT NOW() NOT NULL, CONSTRAINT newtable_pk PRIMARY KEY (id), CONSTRAINT connection_node_fk FOREIGN KEY ("from") REFERENCES public.node(id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT connection_node_fk_1 FOREIGN KEY ("to") REFERENCES public.node(id) ON DELETE CASCADE ON UPDATE CASCADE );