diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations/20210821013757_cull_usernames.js | 4 |
1 files changed, 2 insertions, 2 deletions
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}$')"), ]) }; |