   keyBundle BINARY(96) NOT NULL,
   createdAt BIGINT UNSIGNED NOT NULL,
   INDEX key_uid (uid)
-) ENGINE=InnoDB CHARSET=utf8;
+) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS accountResetTokens (
   tokenId BINARY(32) PRIMARY KEY,
   tokenData BINARY(32) NOT NULL,
   uid BINARY(16) NOT NULL UNIQUE KEY,
   createdAt BIGINT UNSIGNED NOT NULL
-) ENGINE=InnoDB CHARSET=utf8;
+) ENGINE=InnoDB;
 
 CREATE TABLE IF NOT EXISTS passwordForgotTokens (
   tokenId BINARY(32) PRIMARY KEY,

  verifierVersion TINYINT UNSIGNED NOT NULL,
  verifierSetAt BIGINT UNSIGNED NOT NULL,
  createdAt BIGINT UNSIGNED NOT NULL
) ENGINE=InnoDB CHARSET=utf8;

CREATE TABLE IF NOT EXISTS sessionTokens (
  tokenId BINARY(32) PRIMARY KEY,

  uid BINARY(16) NOT NULL,
  createdAt BIGINT UNSIGNED NOT NULL,
  INDEX session_uid (uid)
) ENGINE=InnoDB;
