vaultwarden-alternativa-bit.../migrations/mysql/2021-10-24-164321_add_2fa_i.../up.sql

10 lines
267 B
SQL

CREATE TABLE twofactor_incomplete (
user_uuid CHAR(36) NOT NULL REFERENCES users(uuid),
device_uuid CHAR(36) NOT NULL,
device_name TEXT NOT NULL,
login_time DATETIME NOT NULL,
ip_address TEXT NOT NULL,
PRIMARY KEY (user_uuid, device_uuid)
);