eq2go/sql/worldservers_verify.sql

9 lines
281 B
SQL
Executable File

DROP TABLE IF EXISTS worldservers_verify;
CREATE TABLE worldservers_verify (
id INTEGER PRIMARY KEY,
world_id INTEGER NOT NULL,
token TEXT NOT NULL UNIQUE,
expires INTEGER NOT NULL
);
CREATE INDEX idx_worldservers_verify_world_id ON worldservers_verify(world_id);