U4fHbJaE

1CREATE TABLE IF NOT EXISTS login (
2 lid             BIGINT NOT NULL AUTO_INCREMENT,
3 created_at      TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
4 username        VARCHAR(64)    NOT NULL UNIQUE,
5 password        VARCHAR(255)   NOT NULL,
6 email           VARCHAR(64)   NOT NULL UNIQUE,
7 is_active       BOOLEAN NOT NULL DEFAULT FALSE,
8 CONSTRAINT l_pk PRIMARY KEY (lid)
9 );
10
11CREATE TABLE IF NOT EXISTS login_token (
12ltid             BIGINT NOT NULL AUTO_INCREMENT,
13token            VARCHAR(36) UNIQUE,
14token_type       VARCHAR(64) NOT NULL,
15lid              INTEGER NOT NULL,
16created_at       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
17valid_until      TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
18CONSTRAINT lt_pk PRIMARY KEY (ltid),
19CONSTRAINT lt_lid_fk FOREIGN KEY (lid) REFERENCES login(lid) ON DELETE CASCADE
20);