create table users( id INTEGER PRIMARY KEY, name TEXT NOT NULL, email TEXT NOT NULL, password_hash TEXT NOT NULL, password_salt TEXT NOT NULL, created_datetime TIMESTAMP NOT NULL, updated_datetime TIMESTAMP NOT NULL, rotp_key TEXT, last_rotp_at INTEGER ); create table authorizations( id INTEGER PRIMARY KEY, confirmed_social_media TEXT NOT NULL );