parsav  Diff

Differences From Artifact [bc736c4c1d]:

• File backend/schema/pgsql.sql — part of check-in [8d35307a7f] at 2021-01-10 03:54:46 on branch trunk — add memory pool impl, handle various little details, add beginnings of mimelib (user: lexi, size: 9037) [annotate] [blame] [check-ins using]

To Artifact [daac991db5]:

• File backend/schema/pgsql.sql — part of check-in [00a6815988] at 2021-01-10 11:17:29 on branch trunk — add follow notices (user: lexi, size: 9070) [annotate] [blame] [check-ins using]

    85     85   create index on parsav_posts (parent);
    86     86   
    87     87   create table parsav_rels (
    88     88   	relator bigint references parsav_actors(id)
    89     89   		on delete cascade, -- e.g. follower
    90     90   	relatee bigint references parsav_actors(id)
    91     91   		on delete cascade, -- e.g. followed
    92         -	kind    smallint, -- e.g. follow, block, mute
           92  +	kind    smallint not null, -- e.g. follow, block, mute
           93  +	since	bigint not null,
    93     94   
    94     95   	primary key (relator, relatee, kind)
    95     96   );
    96     97   comment on table parsav_rels is
    97     98   'all relationships, positive and negative, between local users and other users; kind is a version-specific integer mapping to a type-of-relationship enum in store.t';
    98     99   
    99    100   create table parsav_acts (