summaryrefslogtreecommitdiffstats
path: root/server/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'server/migrations')
-rw-r--r--server/migrations/2020-06-30-135809_remove_mat_views/up.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/server/migrations/2020-06-30-135809_remove_mat_views/up.sql b/server/migrations/2020-06-30-135809_remove_mat_views/up.sql
index bd792a8b..9e2fa59c 100644
--- a/server/migrations/2020-06-30-135809_remove_mat_views/up.sql
+++ b/server/migrations/2020-06-30-135809_remove_mat_views/up.sql
@@ -106,6 +106,7 @@ select
u.actor_id as creator_actor_id,
u."local" as creator_local,
u."name" as creator_name,
+ u.published as creator_published,
u.avatar as creator_avatar,
u.banned as banned,
cb.id::bool as banned_from_community,
@@ -490,6 +491,7 @@ select
u.actor_id as creator_actor_id,
u.local as creator_local,
u.name as creator_name,
+ u.published as creator_published,
u.avatar as creator_avatar,
-- score details
coalesce(cl.total, 0) as score,