"created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
"modified" timestamp NULL DEFAULT NULL,
"deleted" timestamp NULL DEFAULT NULL,
- "hash" varchar(50) NOT NULL DEFAULT '',
- "attempts" smallint NOT NULL DEFAULT '0',
PRIMARY KEY ("id")
);
CREATE INDEX ON "emails" ("memid");
-CREATE INDEX ON "emails" ("hash");
CREATE INDEX ON "emails" ("deleted");
CREATE INDEX ON "emails" ("email");
"email" varchar(255) NOT NULL,
"type" "emailPingType" NOT NULL,
"status" "pingState" NOT NULL,
- "result" varchar(255) NOT NULL
+ "result" varchar(255) NOT NULL,
+ "challenge" varchar(255) NULL DEFAULT NULL
);
DROP TABLE IF EXISTS "pingconfig";
DROP TABLE IF EXISTS "notary";
DROP TYPE IF EXISTS "notaryType";
-CREATE TYPE "notaryType" AS enum('Face to Face Meeting', 'TOPUP', 'TTP-Assisted');
+CREATE TYPE "notaryType" AS enum('Face to Face Meeting', 'TOPUP', 'TTP-Assisted', 'Nucleus Bonus');
CREATE TABLE "notary" (
"id" serial NOT NULL,
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', 'blockedcert');
+CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer');
CREATE TABLE IF NOT EXISTS "user_groups" (
"id" serial NOT NULL,
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(8);
+INSERT INTO "schemeVersion" (version) VALUES(11);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (