diff options
| author | href <href@random.sh> | 2019-01-23 11:22:31 +0100 |
|---|---|---|
| committer | href <href@random.sh> | 2019-01-23 11:26:39 +0100 |
| commit | e67bd93d9036770359da731b1ddad6f3da4fef66 (patch) | |
| tree | 7a2bdd914dec7e03a181a3bac6a60b76fd50adcb | |
| parent | a92c43bc4be914ac9f8118cae18bc82e2b9d1664 (diff) | |
| download | pleroma-e67bd93d9036770359da731b1ddad6f3da4fef66.tar.gz pleroma-e67bd93d9036770359da731b1ddad6f3da4fef66.zip | |
Flake: migrate pinned_activities in jsonb
| -rw-r--r-- | priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs b/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs index 69a27e0c8..70ec58cd2 100644 --- a/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs +++ b/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs @@ -37,6 +37,8 @@ defmodule Pleroma.Repo.Migrations.UsersAndActivitiesFlakeId do execute "ALTER TABLE activities ADD PRIMARY KEY (id);" execute "ALTER TABLE users ADD PRIMARY KEY (id);" + execute "UPDATE users SET info = jsonb_set(info, '{pinned_activities}', array_to_json(ARRAY(select jsonb_array_elements_text(info->'pinned_activities')))::jsonb);" + # Fkeys: # Activities - Referenced by: # TABLE "notifications" CONSTRAINT "notifications_activity_id_fkey" FOREIGN KEY (activity_id) REFERENCES activities(id) ON DELETE CASCADE |