17 lines
443 B
Ruby
17 lines
443 B
Ruby
|
Sequel.migration do
|
||
|
|
no_transaction # indexes need to be created outside of the transaction
|
||
|
|
|
||
|
|
# This index is used for metrics gathering per database host. See #10115
|
||
|
|
up do
|
||
|
|
SequelRails.connection.run %{
|
||
|
|
CREATE INDEX CONCURRENTLY "users_database_host_index" ON "users" ("database_host");
|
||
|
|
}
|
||
|
|
end
|
||
|
|
|
||
|
|
down do
|
||
|
|
SequelRails.connection.run %{
|
||
|
|
DROP INDEX CONCURRENTLY IF EXISTS "users_database_host_index";
|
||
|
|
}
|
||
|
|
end
|
||
|
|
end
|