summaryrefslogtreecommitdiffstats
path: root/server/migrations
diff options
context:
space:
mode:
authorFilip785 <fdjuricic98@gmail.com>2020-07-08 02:28:47 +0200
committerFilip785 <fdjuricic98@gmail.com>2020-07-08 02:28:47 +0200
commit68e9755e593bbd8230eab2a123e822022721f071 (patch)
treeae11c818f1678ab1780ab95872ecc68cc9114af4 /server/migrations
parent8fda7d00d5ec9e415b44aa10cff3c4d735563a20 (diff)
Add cake day display in user page & posts/comments #682
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,