1 files changed, 11 insertions, 0 deletions
diff --git a/priv/repo/migrations/20230529193453_add_citext.exs b/priv/repo/migrations/20230529193453_add_citext.exs
new file mode 100644
index 0000000..371df8d
--- /dev/null
+++ b/priv/repo/migrations/20230529193453_add_citext.exs
@@ -0,0 +1,11 @@
+defmodule Chessh.Repo.Migrations.AddCitext do
+  use Ecto.Migration
+
+  def up do
+    execute("CREATE EXTENSION citext")
+  end
+
+  def down do
+    execute("DROP EXTENSION citext")
+  end
+end