"revoked" timestamp NULL DEFAULT NULL,
"expire" timestamp NULL DEFAULT NULL,
"renewed" boolean NOT NULL DEFAULT 'false',
- "disablelogin" boolean NOT NULL DEFAULT 'false',
"pkhash" char(40) DEFAULT NULL,
"certhash" char(40) DEFAULT NULL,
"description" varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY ("certId", "name")
);
-DROP TABLE IF EXISTS "clientcerts";
-CREATE TABLE "clientcerts" (
+DROP TABLE IF EXISTS "logincerts";
+CREATE TABLE "logincerts" (
"id" int NOT NULL,
- "disablelogin" boolean NOT NULL DEFAULT 'false',
PRIMARY KEY ("id")
);
"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")
);
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(20);
+INSERT INTO "schemeVersion" (version) VALUES(22);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (