add deletion of users with names longer than 32 chars.. and accounts referencing these (or non-existent) users

1 files changed, 5 insertions, 0 deletions

diff --git a/db/migrations/20210714123455_data_fixes_merge.js b/db/migrations/20210714123455_data_fixes_merge.js
index 70740ce8..d6ba3a3a 100644
--- a/db/migrations/20210714123455_data_fixes_merge.js
+++ b/db/migrations/20210714123455_data_fixes_merge.js
@@ -7,6 +7,11 @@ exports.up = function(knex) {
     knex.raw("alter table orders drop rate"),
     knex.raw("alter table orders add rate double"),
     knex.raw("update orders set rate = v1/v2"),
+
+    knex.raw('update accounts left join users on accounts.user_id = users.id set user_id = null where length(username) > 32')
+    knex.raw('update accounts left join users on accounts.user_id = users.id set user_id = null where users.id is null')
+    knex.raw('delete from accounts where users.id is null'),
+    knex.raw('delete from users where length(username) > 32')
   ])
 }