Pessoal eu faço um banco com as fk ASSIM :
CREATE TABLE financeiro2.authorities
(
username character varying,
autority character varying,
pkid bigserial NOT NULL,
CONSTRAINT pk_id PRIMARY KEY (pkid),
CONSTRAINT fk_nome FOREIGN KEY (username)
REFERENCES financeiro2.users (username) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE financeiro2.authorities OWNER TO root;
quando mando o hibernate gerar ele faz isso :
CREATE TABLE financeiro2.authorities
(
username character varying,
autority character varying,
pkid bigserial NOT NULL,
CONSTRAINT pk_id PRIMARY KEY (pkid),
CONSTRAINT EDDD552D5ADA FOREIGN KEY (username)
REFERENCES financeiro2.users (username) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE financeiro2.authorities OWNER TO root;
COMO EU FAÇO ISSO ?
mudar EDDD552D5ADA !