-- -----------------------------------------------------------------------------
-- https://docs.spring.io/spring-security/site/docs/5.0.x/reference/html/appendix-schema.html#persistent-login-remember-me-schema
-- -----------------------------------------------------------------------------
-- org.springframework.security.web.authentication.rememberme.JdbcTokenRepositoryImpl
-- spring security persistent_logins
-- -----------------------------------------------------------------------------
CREATE TABLE m01te01x00 (
    entered     DATE,
    enterer     VARCHAR2(4),
    amended     DATE,
    amender     VARCHAR2(4),

    id          VARCHAR2(8)      NOT NULL,
    user_code   VARCHAR2(4)      NOT NULL,
--  user_name   VARCHAR2(64)     NOT NULL,
    series      VARCHAR2(64)     NOT NULL,
    token       VARCHAR2(64)     NOT NULL,
    last_used   DATE             NOT NULL,

    CONSTRAINT m01te01x00_pkc_00 PRIMARY KEY (id),
    CONSTRAINT m01te01x00_ukc_00 UNIQUE      (series),
    CONSTRAINT m01te01x00_fkc_00 FOREIGN KEY (user_code) REFERENCES m01te00x00 (user_code)
);

COMMENT ON TABLE m01te01x00 IS 'spring security persistent_logins';