• Home
• com.d3xsystems
• d3x-core-http-server
• 1.0.82
• source code
• auth-token.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.ddl.h2.auth-token.sql Maven / Gradle / Ivy

CREATE TABLE IF NOT EXISTS auth_token
(
  id INTEGER AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  token_key VARCHAR(255) NOT NULL,
  token_value VARCHAR(300) NOT NULL,
  remote_ip VARCHAR(50) NOT NULL,
  create_utc TIMESTAMP NOT NULL
);

CREATE INDEX auth_token_idx1 ON auth_token (username, id);