3 CREATE TABLE redeemed_ticket (
4 ticket_id
BIGINT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
5 created
TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
7 resource
TEXT NOT NULL,
11 published
TIMESTAMP WITH TIME ZONE
13 COMMENT ON TABLE redeemed_ticket
IS $docstring$
14 Tickets which have been redeemed
for tokens
and published.
16 CREATE INDEX redeemed_ticket_created_idx
ON redeemed_ticket(created
);
17 CREATE INDEX redeemed_ticket_published_idx
ON redeemed_ticket(published
) WHERE published
IS NOT NULL;
18 CREATE INDEX redeemed_ticket_ref_idx
ON redeemed_ticket(subject
, resource
, iss
, ticket
);
20 -- Update schema version
21 INSERT INTO _meta_schema_version (major
, minor
, patch
) VALUES (1, 1, 0);