summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20211121000000_create_user_notes.exs
diff options
context:
space:
mode:
authorAlex Gleason <alex@alexgleason.me>2021-12-27 18:01:25 -0600
committerAlex Gleason <alex@alexgleason.me>2021-12-27 18:01:25 -0600
commitf5c3d45120364681b3601baa36a0ce9fa22680d7 (patch)
tree5f1379ca293a001111585849521615d69880b7cb /priv/repo/migrations/20211121000000_create_user_notes.exs
parent3117c6099733207b7f2a777f8cb8b5b3b839ebe8 (diff)
parent264f0fde1b9f0cbaf7679eeb59938eb9ca653779 (diff)
downloadpleroma-f5c3d45120364681b3601baa36a0ce9fa22680d7.tar.gz
pleroma-f5c3d45120364681b3601baa36a0ce9fa22680d7.zip
Merge remote-tracking branch 'origin/develop' into apps-api-endpoint
Diffstat (limited to 'priv/repo/migrations/20211121000000_create_user_notes.exs')
-rw-r--r--priv/repo/migrations/20211121000000_create_user_notes.exs15
1 files changed, 15 insertions, 0 deletions
diff --git a/priv/repo/migrations/20211121000000_create_user_notes.exs b/priv/repo/migrations/20211121000000_create_user_notes.exs
new file mode 100644
index 000000000..b75e11695
--- /dev/null
+++ b/priv/repo/migrations/20211121000000_create_user_notes.exs
@@ -0,0 +1,15 @@
+defmodule Pleroma.Repo.Migrations.CreateUserNotes do
+ use Ecto.Migration
+
+ def change do
+ create_if_not_exists table(:user_notes) do
+ add(:source_id, references(:users, type: :uuid, on_delete: :delete_all))
+ add(:target_id, references(:users, type: :uuid, on_delete: :delete_all))
+ add(:comment, :string)
+
+ timestamps()
+ end
+
+ create_if_not_exists(unique_index(:user_notes, [:source_id, :target_id]))
+ end
+end