From 3e61c801fc3ca9644304c88f86adf5aa297aeef4 Mon Sep 17 00:00:00 2001 From: Adam Soltys Date: Mon, 30 Aug 2021 17:49:03 -0700 Subject: strip spaces from usernames --- db/migrations/20210821013757_cull_usernames.js | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/migrations/20210821013757_cull_usernames.js b/db/migrations/20210821013757_cull_usernames.js index a4a48f21..5d2a4672 100644 --- a/db/migrations/20210821013757_cull_usernames.js +++ b/db/migrations/20210821013757_cull_usernames.js @@ -1,8 +1,8 @@ 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}$'"), + knex.raw("UPDATE users SET username = REPLACE(username, ' ', '')"), // 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}$')"), ]) }; -- cgit v1.2.3