summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20211121000000_create_user_notes.exs
diff options
context:
space:
mode:
authorAlex Gleason <alex@alexgleason.me>2021-12-25 19:57:53 -0600
committerAlex Gleason <alex@alexgleason.me>2021-12-25 19:57:53 -0600
commitdb2bf55e9bb31af2ed34805ca7fa98ce67b471b1 (patch)
treef532711eaf19111e22375e87706edf5a3024e5b5 /priv/repo/migrations/20211121000000_create_user_notes.exs
parentb15c4629ff3093353ac5e37d381db1cdc4da1c3a (diff)
parent73609211a425922a5068d3912a36b82abe24e12c (diff)
downloadpleroma-db2bf55e9bb31af2ed34805ca7fa98ce67b471b1.tar.gz
pleroma-db2bf55e9bb31af2ed34805ca7fa98ce67b471b1.zip
Merge remote-tracking branch 'origin/develop' into notice-routes
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