summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20200928145912_revert_citext_change.exs
diff options
context:
space:
mode:
authorrinpatch <rinpatch@sdf.org>2020-09-28 18:15:31 +0300
committerrinpatch <rinpatch@sdf.org>2020-09-28 18:34:03 +0300
commit7bc561127da6489862d3b7ea49ebc853c0267729 (patch)
tree1c5abeec6a6d7abef0a47df76bf609ba1e066bd1 /priv/repo/migrations/20200928145912_revert_citext_change.exs
parent35157f5dc845483e9d65236b87461f15c77ad634 (diff)
downloadpleroma-7bc561127da6489862d3b7ea49ebc853c0267729.tar.gz
pleroma-7bc561127da6489862d3b7ea49ebc853c0267729.zip
Revert citext user URI migration
URI paths are not actually case-insesitive, which caused migration issues on a number of databases. Closes #2188
Diffstat (limited to 'priv/repo/migrations/20200928145912_revert_citext_change.exs')
-rw-r--r--priv/repo/migrations/20200928145912_revert_citext_change.exs11
1 files changed, 11 insertions, 0 deletions
diff --git a/priv/repo/migrations/20200928145912_revert_citext_change.exs b/priv/repo/migrations/20200928145912_revert_citext_change.exs
new file mode 100644
index 000000000..ab232f607
--- /dev/null
+++ b/priv/repo/migrations/20200928145912_revert_citext_change.exs
@@ -0,0 +1,11 @@
+defmodule Pleroma.Repo.Migrations.RevertCitextChange do
+ use Ecto.Migration
+
+ def change do
+ alter table(:users) do
+ modify(:uri, :text)
+ end
+
+ create_if_not_exists(unique_index(:users, :uri))
+ end
+end