"domainid" int NOT NULL,
"type" "pingType" NOT NULL,
"info" varchar(255) NOT NULL,
+ "deleted" timestamp NULL DEFAULT NULL,
PRIMARY KEY ("id")
);
DROP TABLE IF EXISTS "certAvas";
CREATE TABLE "certAvas" (
- "certid" int NOT NULL,
+ "certId" int NOT NULL,
"name" varchar(20) NOT NULL,
"value" varchar(255) NOT NULL,
- PRIMARY KEY ("certid", "name")
+ PRIMARY KEY ("certId", "name")
);
DROP TABLE IF EXISTS "clientcerts";
DROP TABLE IF EXISTS "user_groups";
DROP TYPE IF EXISTS "userGroup";
-CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer');
+CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert');
CREATE TABLE IF NOT EXISTS "user_groups" (
"id" serial NOT NULL,
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(4);
+INSERT INTO "schemeVersion" (version) VALUES(8);
+
+DROP TABLE IF EXISTS `passwordResetTickets`;
+CREATE TABLE `passwordResetTickets` (
+ `id` serial NOT NULL,
+ `memid` int NOT NULL,
+ `creator` int NOT NULL,
+ `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `used` timestamp NULL DEFAULT NULL,
+ `token` varchar(32) NOT NULL,
+ `private_token` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`)
+);