-- SPDX-FileCopyrightText: Heiko Schaefer <heiko@schaefer.name>
-- SPDX-License-Identifier: CC0-1.0

-- The last "tag" of this cert-d instance (a changed tag signals that some cert-d contents have changed)
CREATE TABLE `cert_d`
(
    `id`  INTEGER NOT NULL PRIMARY KEY CHECK (id = 0),
    `tag` TEXT    NOT NULL
);

CREATE INDEX `idx_certs_fp` ON certs (fp);