parsav  Diff

Differences From Artifact [1170b3857b]:

• File backend/schema/pgsql-auth.sql — part of check-in [d228cd7fcb] at 2020-12-28 23:42:22 on branch trunk — vastly improve the setup process (user: lexi, size: 2272) [annotate] [blame] [check-ins using]

To Artifact [8bbbf24f23]:

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

    42     42   		-- if the credential matches, access will be denied, even if
    43     43   		-- non-blacklisted credentials match. most useful with
    44     44   		-- uid = null, kind = trust, cidr = (untrusted IP range)
    45     45   
    46     46   	valperiod timestamp default now(),
    47     47   		-- cookies bearing timestamps earlier than this point in time
    48     48   		-- will be considered invalid and will not grant access
           49  +	
           50  +	comment text,
           51  +		-- a field the user can use to identify the specific credential,
           52  +		-- in order to aid credential management
    49     53   
    50     54   	unique(name,kind,cred)
    51     55   );