parsav  Diff

Differences From Artifact [135f2b367a]:

• File backend/schema/pgsql.sql — part of check-in [d4ecea913f] at 2020-12-31 00:15:53 on branch trunk — add lots more shit (user: lexi, size: 6429) [annotate] [blame] [check-ins using]

To Artifact [b4d8dee98e]:

• File backend/schema/pgsql.sql — part of check-in [24ec409083] at 2021-01-01 04:33:10 on branch trunk — add live updates, system to only update when necessary almost works (user: lexi, size: 6768) [annotate] [blame] [check-ins using]

   167    167   	nature smallint not null, -- silence, suspend, disemvowel, censor, noreply, etc
   168    168   	victim bigint not null, -- can be user, room, or post
   169    169   	expire timestamp, -- auto-expires if set
   170    170   	review timestamp,  -- brings up for review at given time if set
   171    171   	reason text, -- visible to victim if set
   172    172   	context text -- admin-only note
   173    173   );
          174  +
          175  +create table parsav_actor_conf_strs (
          176  +	uid bigint not null references parsav_actors(id) on delete cascade,
          177  +	key text not null, value text not null, unique (uid,key)
          178  +);
          179  +create table parsav_actor_conf_ints (
          180  +	uid bigint not null references parsav_actors(id) on delete cascade,
          181  +	key text not null, value bigint not null, unique (uid,key)
          182  +);
   174    183   
   175    184   -- create a temporary managed auth table; we can delete this later
   176    185   -- if it ends up being replaced with a view
   177    186   %include pgsql-auth.sql%