down.sql 170 B

12345678
  1. UPDATE users
  2. SET totp_secret = (
  3. SELECT twofactor.data FROM twofactor
  4. WHERE twofactor.type = 0
  5. AND twofactor.user_uuid = users.uuid
  6. );
  7. DROP TABLE twofactor;