parsav  Diff

Differences From 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]

To Artifact [09d655e8a5]:

• File backend/schema/pgsql-auth.sql — part of check-in [7bd78f9b1c] at 2021-01-05 22:10:42 on branch trunk — improve sql, js, docs, other tweaks (user: lexi, size: 2391) [annotate] [blame] [check-ins using]

    39     39   		-- in from an IP address contained by this netmask.
    40     40   
    41     41   	blacklist bool not null default false,
    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         -	valperiod timestamp default now(),
           46  +	valperiod bigint not null,
    47     47   		-- cookies bearing timestamps earlier than this point in time
    48     48   		-- will be considered invalid and will not grant access
    49     49   	
    50     50   	comment text,
    51     51   		-- a field the user can use to identify the specific credential,
    52     52   		-- in order to aid credential management
    53     53   
    54     54   	unique(name,kind,cred)
    55     55   );