Spring Boot REST: добавляем oAuth2 авторизацию (sessions table) 2

session_tables.sql

CREATE TABLE spring_session (
  primary_id            CHAR(36) NOT NULL
    CONSTRAINT spring_session_pk
    PRIMARY KEY,
  session_id            CHAR(36) NOT NULL,
  creation_time         BIGINT   NOT NULL,
  last_access_time      BIGINT   NOT NULL,
  max_inactive_interval INTEGER  NOT NULL,
  expiry_time           BIGINT   NOT NULL,
  principal_name        VARCHAR(300) -- <= here was 100
);

CREATE UNIQUE INDEX spring_session_ix1
  ON spring_session (session_id);

CREATE INDEX spring_session_ix2
  ON spring_session (expiry_time);

CREATE INDEX spring_session_ix3
  ON spring_session (principal_name);


CREATE TABLE spring_session_attributes (
  session_primary_id CHAR(36)     NOT NULL
    CONSTRAINT spring_session_attributes_fk
    REFERENCES spring_session
    ON DELETE CASCADE,
  attribute_name     VARCHAR(200) NOT NULL,
  attribute_bytes    BYTEA        NOT NULL,
  CONSTRAINT spring_session_attributes_pk
  PRIMARY KEY (session_primary_id, attribute_name)
);