Created
September 30, 2017 12:37
-
-
Save zoozalp/24d222de546b261fcf0d874aaddd4c01 to your computer and use it in GitHub Desktop.
Create spring session tables
This file contains hidden or 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 SPRING_SESSION ( | |
SESSION_ID CHAR(36) NOT NULL, | |
CREATION_TIME BIGINT NOT NULL, | |
LAST_ACCESS_TIME BIGINT NOT NULL, | |
MAX_INACTIVE_INTERVAL INT NOT NULL, | |
PRINCIPAL_NAME VARCHAR(100), | |
CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (SESSION_ID) | |
); | |
CREATE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (LAST_ACCESS_TIME); | |
CREATE TABLE SPRING_SESSION_ATTRIBUTES ( | |
SESSION_ID CHAR(36) NOT NULL, | |
ATTRIBUTE_NAME VARCHAR(200) NOT NULL, | |
ATTRIBUTE_BYTES BYTEA NOT NULL, | |
CONSTRAINT SPRING_SESSION_ATTRIBUTES_PK PRIMARY KEY (SESSION_ID, ATTRIBUTE_NAME), | |
CONSTRAINT SPRING_SESSION_ATTRIBUTES_FK FOREIGN KEY (SESSION_ID) REFERENCES SPRING_SESSION(SESSION_ID) ON DELETE CASCADE | |
); | |
CREATE INDEX SPRING_SESSION_ATTRIBUTES_IX1 ON SPRING_SESSION_ATTRIBUTES (SESSION_ID); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment