parsav  Diff

Differences From Artifact [72a3e65e6e]:

• File backend/schema/pgsql.sql — part of check-in [7129658e1d] at 2021-01-02 04:47:03 on branch trunk — work on admin ui (user: lexi, size: 6826) [annotate] [blame] [check-ins using]

To Artifact [347a4ab533]:

• File backend/schema/pgsql.sql — part of check-in [78b0198f09] at 2021-01-04 06:44:13 on branch trunk — add likes, retweets, and iterate on a whole bunch of other shit (user: lexi, size: 6861) [annotate] [blame] [check-ins using]

    82     82   	kind    smallint, -- e.g. follow, block, mute
    83     83   
    84     84   	primary key (relator, relatee, kind)
    85     85   );
    86     86   
    87     87   create table parsav_acts (
    88     88   	id      bigint primary key default (1+random()*(2^63-1))::bigint,
    89         -	kind    text not null, -- like, react, so on
           89  +	kind    text not null, -- like, rt, react, so on
    90     90   	time    timestamp not null default now(),
    91     91   	actor   bigint references parsav_actors(id)
    92     92   		on delete cascade,
    93         -	subject bigint -- may be post or act, depending on kind
           93  +	subject bigint, -- may be post or act, depending on kind
           94  +	body	text -- emoji, if react
    94     95   );
    95     96   
    96     97   create table parsav_log (
    97     98   	-- accesses are tracked for security & sending delete acts
    98     99   	id    bigint primary key default (1+random()*(2^63-1))::bigint,
    99    100   	time  timestamp not null default now(),
   100    101   	actor bigint references parsav_actors(id)