Index: backend/schema/pgsql-views.sql ================================================================== --- backend/schema/pgsql-views.sql +++ backend/schema/pgsql-views.sql @@ -129,15 +129,14 @@ coalesce(cn.promoter, (cn.orig).author) as promoter from content as cn order by cn.promotime desc ); --- --create temp view parsavpg_post_threads as ( -- --); --- + create temp view parsavpg_notices as ( -- TODO add mentions with ntimes as ( select uid, value as when from parsav_actor_conf_ints where key = 'notice-clear-time' ), acts as ( @@ -151,19 +150,19 @@ )::pg_temp.parsavpg_intern_notice as notice, p.author as rcpt from parsav_acts as a inner join parsav_posts as p on a.subject = p.id inner join (values - ('rt', 4 ), - ('like', 3 ), - ('react', 5 ) + ('rt', ), + ('like', ), + ('react', ) ) as kmap(kstr,kind) on kmap.kstr = a.kind left join ntimes as nt on nt.uid = p.author where a.time >= coalesce(nt.when,0) ), replies as ( select row( - 2::smallint, + ::smallint, coalesce(p.posted,p.discovered), p.author, p.parent, p.id, null::text Index: store.t ================================================================== --- store.t +++ store.t @@ -91,10 +91,11 @@ (pow.shout << true) (pow.propagate << true) (pow.artifact << true) (pow.account << true) (pow.edit << true) + (pow.snitch << true) return m.rights { rank = 0, quota = 1000, invites = 0, powers = pow; } end struct m.actor { id: uint64