parsav  Diff

Differences From Artifact [ca832d14af]:

• File backend/schema/pgsql-views.sql — part of check-in [f4c6e72a22] at 2021-01-07 07:35:14 on branch trunk — tentative beginnings of upload + media management system (user: lexi, size: 5567) [annotate] [blame] [check-ins using]

To Artifact [25f9d405bc]:

• File backend/schema/pgsql-views.sql — part of check-in [d6024624c6] at 2021-01-08 05:58:30 on branch trunk — enable passwords (user: lexi, size: 5600) [annotate] [blame] [check-ins using]

    54     54   	avataruri	text,
    55     55   	rank		smallint,
    56     56   	quota		integer,
    57     57   	key			bytea,
    58     58   	epithet		text,
    59     59   	knownsince	bigint,
    60     60   	xid			text,
    61         -	invites		integer
           61  +	invites		integer,
           62  +	avatarid	bigint
    62     63   );
    63     64   
    64     65   create or replace function
    65     66   pg_temp.parsavpg_translate_actor(parsav_actors)
    66     67   returns pg_temp.parsavpg_intern_actor as $$
    67     68   	select
    68     69   		($1).id,        ($1).nym,  ($1).handle, ($1).origin, ($1).bio,
    69     70   		($1).avataruri, ($1).rank, ($1).quota,  ($1).key,    ($1).epithet,
    70     71   		($1).knownsince::bigint,
    71     72   		coalesce(($1).handle || '@' ||
    72     73   				(select domain from parsav_servers as s where s.id = ($1).origin),
    73     74   			'@' || ($1).handle) as xid,
    74         -		($1).invites
           75  +		($1).invites, ($1).avatarid
    75     76   $$ language sql;
    76     77   
    77     78   --drop type if exists pg_temp.parsavpg_intern_post;
    78     79   create type pg_temp.parsavpg_intern_post as (
    79     80   	-- order is crucially important, and must match the order used
    80     81   	-- in row_to_actor. names don't matter
    81     82   	localpost	bool,