parsav  Diff

Differences From Artifact [4c18dab250]:

• File backend/schema/pgsql.sql — part of check-in [050ce7d4fc] at 2021-01-25 14:38:36 on branch trunk — iterating (user: lexi, size: 8610) [annotate] [blame] [check-ins using]

To Artifact [abc8356ef1]:

• File backend/schema/pgsql.sql — part of check-in [c774e2c5a9] at 2021-01-28 00:51:21 on branch trunk — wrote mimelib, continued iterating on litepub support; tweets can now be imported into honk (user: lexi, size: 8645) [annotate] [blame] [check-ins using]

    59     59   );
    60     60   create index on parsav_rights (actor);
    61     61   comment on table parsav_rights is
    62     62   'a backward-compatible list of every non-default privilege or deprivilege granted to a local user';
    63     63   
    64     64   create table parsav_posts (
    65     65   	id         <def:uniq>,
           66  +	uri        text, -- null if local
    66     67   	author     bigint references parsav_actors(id) on delete cascade,
    67     68   	subject    text,
    68     69   	acl        text not null default 'all', -- just store the script raw 🤷
    69     70   	body       text,
    70     71   	posted     bigint not null,
    71     72   	discovered bigint not null,
    72     73   	chgcount   integer not null default 0,