009_UserStore.sql 411 B

1234567891011
  1. BEGIN;
  2. update users
  3. set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
  4. where UUID not like '%-%';
  5. update useragents
  6. set UUID = substr(UUID, 1, 8) || "-" || substr(UUID, 9, 4) || "-" || substr(UUID, 13, 4) || "-" || substr(UUID, 17, 4) || "-" || substr(UUID, 21, 12)
  7. where UUID not like '%-%';
  8. COMMIT;