From 47684c2a2c44186b0b7eac3002582875efa6855b Mon Sep 17 00:00:00 2001 From: Roger Braun Date: Mon, 22 May 2017 18:10:50 +0200 Subject: Make email and nickname case insensitive. --- .../migrations/20170522160642_case_insensivtivity.exs | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 priv/repo/migrations/20170522160642_case_insensivtivity.exs (limited to 'priv') diff --git a/priv/repo/migrations/20170522160642_case_insensivtivity.exs b/priv/repo/migrations/20170522160642_case_insensivtivity.exs new file mode 100644 index 000000000..c7565946e --- /dev/null +++ b/priv/repo/migrations/20170522160642_case_insensivtivity.exs @@ -0,0 +1,19 @@ +defmodule Pleroma.Repo.Migrations.CaseInsensivtivity do + use Ecto.Migration + + def up do + execute ("create extension if not exists citext") + alter table(:users) do + modify :email, :citext + modify :nickname, :citext + end + end + + def down do + alter table(:users) do + modify :email, :string + modify :nickname, :string + end + execute ("drop extension if exists citext") + end +end -- cgit v1.2.3