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
);
