lemmy/migrations/2020-04-21-123957_remove_un.../up.sql

5 lines
124 B
SQL

DROP INDEX idx_user_name_lower;
CREATE UNIQUE INDEX idx_user_name_lower_actor_id ON user_ (lower(name), lower(actor_id));