Created
November 1, 2023 16:34
-
-
Save jei0486/66fbc0576271b19ace4d70aed21c097f to your computer and use it in GitHub Desktop.
spring data envers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment