DROP TABLE IF EXISTS "certsRevoked";
DROP TYPE IF EXISTS "revocationType";
-CREATE TYPE "revocationType" AS ENUM('user', 'support', 'ping_timeout');
+CREATE TYPE "revocationType" AS ENUM('user', 'support', 'ping_timeout', 'key_compromise');
CREATE TABLE "certsRevoked" (
"id" int NOT NULL,
-- the time when the certificate was revoked by cassiopeia (and that is stored in the CRL)
-- NULL indicated the revocation is pending
"revoked" timestamp NULL,
"type" "revocationType" NOT NULL,
+ "challenge" varchar(16) NULL DEFAULT NULL,
+ "signature" text NULL DEFAULT NULL,
+ "message" text NULL DEFAULT NULL,
PRIMARY KEY ("id")
);
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(29);
+INSERT INTO "schemeVersion" (version) VALUES(30);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (