MarseyWorld/migrations/20230513-add-namelock-award...

8 lines
319 B
MySQL
Raw Permalink Normal View History

2023-05-13 04:53:14 +00:00
alter table users add column prelock_username varchar(30) unique;
alter table users add column namechanged integer;
create unique index lowercase_prelock_username on users using btree (lower((prelock_username)::text));
create index users_prelock_username_trgm_idx on users using gin (prelock_username gin_trgm_ops);