"dob" date NOT NULL,
"verified" boolean NOT NULL DEFAULT 'false',
"language" varchar(5) NOT NULL DEFAULT '',
+ "country" varchar(2) NULL,
PRIMARY KEY ("id")
);
CREATE INDEX ON "users" ("email");
CREATE TABLE IF NOT EXISTS "organisations" (
"id" int NOT NULL,
"name" varchar(64) NOT NULL,
- "state" varchar(2) NOT NULL,
+ "country" varchar(2) NOT NULL,
"province" varchar(128) NOT NULL,
"city" varchar(128) NOT NULL,
"contactEmail" varchar(100) NOT NULL,
"challenge" varchar(16),
"result" varchar(255)
);
+CREATE INDEX ON "domainPinglog" ("configId","when");
DROP TABLE IF EXISTS "baddomains";
CREATE TABLE "baddomains" (
"sponsor" int NOT NULL DEFAULT '0',
# date when verification was deleted (or 0)
"deleted" timestamp NULL DEFAULT NULL,
+ "country" varchar(2) NULL,
PRIMARY KEY ("id")
);
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', 'nucleus-assurer', 'locate-agent');
+CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer', 'locate-agent', 'verify-notification');
CREATE TABLE IF NOT EXISTS "user_groups" (
"id" serial NOT NULL,
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(21);
+INSERT INTO "schemeVersion" (version) VALUES(26);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (