Jędrzej Stuczyński
5df76ea2a9
* change ticketbook data request to allow for pagination * implemented api endpoints on nym-api side * auxiliary nym-api queries for number of issued ticketbooks * ensure that challenged issuers support new queries * addeed persistent identity to the rewarder * clippy * stupid chrono feature workaround * clippy * debugging issuance verification * remove redundant closure * added a minimum issuance threshold
14 lines
481 B
SQL
14 lines
481 B
SQL
/*
|
|
* Copyright 2025 - Nym Technologies SA <contact@nymtech.net>
|
|
* SPDX-License-Identifier: GPL-3.0-only
|
|
*/
|
|
|
|
CREATE TABLE issued_ticketbooks_count
|
|
(
|
|
-- keep those two values in the same table so we'd be able to see, for example, what different expiration dates were used on given issuance day
|
|
issuance_date DATE NOT NULL DEFAULT CURRENT_DATE,
|
|
expiration_date DATE NOT NULL,
|
|
count INTEGER NOT NULL,
|
|
|
|
UNIQUE (issuance_date, expiration_date)
|
|
); |