Project

General

Profile

Defect #43838 » 0003-Adds-index-on-users-lower-login-on-PostgreSQL-and-SQ.patch

Marius BĂLTEANU, 2026-02-28 07:22

View differences:

db/migrate/20260225170833_add_index_to_users_lower_login.rb
class AddIndexToUsersLowerLogin < ActiveRecord::Migration[8.1]
def up
if Redmine::Database.postgresql? || Redmine::Database.sqlite?
add_index :users, "(lower(login))", name: "index_users_on_lower_login"
end
end
def down
if index_exists?(:users, name: "index_users_on_lower_login")
remove_index :users, name: "index_users_on_lower_login"
end
end
end
(5-5/6)