CREATE TABLE IF NOT EXISTS magic_tokens ( magic_token_hash VARCHAR(64) PRIMARY KEY NOT NULL, client_id VARCHAR(64) NOT NULL, expires TIMESTAMP DEFAULT NULL, created TIMESTAMP NOT NULL DEFAULT NOW(), updated TIMESTAMP NOT NULL DEFAULT NOW() );