spring data envers

spring-data-envers.sql

create table revinfo (
	rev bigserial not null,
	revtstmp int8,
	CONSTRAINT revinfo_pkey PRIMARY KEY (rev)
);

create table revchanges (
	rev int8 not null,
	entityname varchar(255)
);

-- FOREIGN KEY
ALTER TABLE revchanges ADD CONSTRAINT revchanges_revinfo_fkey FOREIGN KEY (rev) REFERENCES revinfo(rev);
ALTER TABLE user_info_history ADD CONSTRAINT user_info_history_revinfo_fkey FOREIGN KEY (rev) REFERENCES revinfo(rev);

-- 시퀀스 생성
CREATE SEQUENCE hibernate_sequence  INCREMENT 1  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;