parsav  Diff

Differences From Artifact [2da83887bf]:

• File schema.sql — part of check-in [59e1d7d56a] at 2020-12-16 08:46:02 on branch trunk — iterating (user: lexi, size: 3799) [annotate] [blame] [check-ins using]

To Artifact [6d12737279]:

• File schema.sql — part of check-in [25e05466d5] at 2020-12-21 01:08:01 on branch trunk — continued iteration (user: lexi, size: 3906) [annotate] [blame] [check-ins using]

    13     13   	value text
    14     14   );
    15     15   
    16     16   insert into parsav_config (key,value) values
    17     17   	('bind',:'bind'),
    18     18   	('domain',:'domain'),
    19     19   	('auth-source',:'auth'),
    20         -	('administrator',:'admin');
           20  +	('administrator',:'admin'),
           21  +	('server-secret', encode(
           22  +			digest(int8send((2^63 * (random()*2 - 1))::bigint),
           23  +		'sha512'), 'base64'));
    21     24   
    22     25   -- note that valid ids should always > 0, as 0 is reserved for null
    23     26   -- on the client side, vastly simplifying code
    24     27   drop table if exists parsav_servers cascade;
    25     28   create table parsav_servers (
    26     29   	id bigint primary key default (1+random()*(2^63-1))::bigint,
    27     30   	domain text not null,