add fix to cull usernames

1 files changed, 11 insertions, 0 deletions

diff --git a/db/migrations/20210821013757_cull_usernames.js b/db/migrations/20210821013757_cull_usernames.js
new file mode 100644
index 00000000..a4a48f21
--- /dev/null
+++ b/db/migrations/20210821013757_cull_usernames.js
@@ -0,0 +1,11 @@
+
+exports.up = function(knex) {
+  return Promise.all([
+    knex.raw("UPDATE users SET username = REPLACE(username, ' ', '') WHERE username like '% '"), // just in case valid users have trailing spaces in their username
+    knex.raw("DELETE FROM users WHERE !(username REGEXP '^[a-zA-Z0-9\.\_\@\-]{3,32}$'"),
+  ])
+};
+
+exports.down = function(knex) {
+  
+};