added `Tag` schema

1 files changed, 27 insertions, 0 deletions

diff --git a/priv/repo/migrations/20201012093959_create_tags.exs b/priv/repo/migrations/20201012093959_create_tags.exs
new file mode 100644
index 000000000..54bf8a2ce
--- /dev/null
+++ b/priv/repo/migrations/20201012093959_create_tags.exs
@@ -0,0 +1,27 @@
+defmodule Pleroma.Repo.Migrations.CreateTags do
+  use Ecto.Migration
+
+  def up do
+    create_if_not_exists table(:tags) do
+      add(:name, :string, null: false)
+      timestamps()
+    end
+
+    create_if_not_exists(unique_index(:tags, :name))
+    flush()
+
+    execute(collect_user_tags_query())
+  end
+
+  def down do
+    drop_if_exists(table(:tags))
+  end
+
+  defp collect_user_tags_query do
+    """
+    INSERT INTO tags(name, inserted_at, updated_at)
+    SELECT DISTINCT unnest(tags), now(), now() from users
+    ON CONFLICT DO NOTHING
+    """
+  end
+end