"id" int NOT NULL,
"email" varchar(255) NOT NULL DEFAULT '',
"password" varchar(255) NOT NULL DEFAULT '',
- "fname" varchar(255) NOT NULL DEFAULT '',
- "mname" varchar(255) NOT NULL DEFAULT '',
- "lname" varchar(255) NOT NULL DEFAULT '',
- "suffix" varchar(50) NOT NULL DEFAULT '',
+ "preferredName" int NULL,
"dob" date NOT NULL,
"verified" boolean NOT NULL DEFAULT 'false',
- "ccid" int NOT NULL DEFAULT '0',
- "regid" int NOT NULL DEFAULT '0',
- "locid" int NOT NULL DEFAULT '0',
- "listme" boolean NOT NULL DEFAULT 'false',
- "contactinfo" varchar(255) NOT NULL DEFAULT '',
"language" varchar(5) NOT NULL DEFAULT '',
+ "country" varchar(2) NULL,
PRIMARY KEY ("id")
);
-CREATE INDEX ON "users" ("ccid");
-CREATE INDEX ON "users" ("regid");
-CREATE INDEX ON "users" ("locid");
CREATE INDEX ON "users" ("email");
CREATE INDEX ON "users" ("verified");
"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")
);
"points" int NOT NULL DEFAULT '0',
# awarded and the "experience points" are calculated virtually
# Face to Face is default, TOPUP is for the remaining 30Points after two TTP
-# TTP is default ttp assurance
+# TTP is default ttp verification
"method" "notaryType" NOT NULL DEFAULT 'Face to Face Meeting',
"location" varchar(255) NOT NULL DEFAULT '',
"date" varchar(255) NOT NULL DEFAULT '',
-# date when assurance was entered
+# date when verification was entered
"when" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
#?
"expire" timestamp NULL DEFAULT NULL,
#?????????????????
"sponsor" int NOT NULL DEFAULT '0',
-# date when assurance was deleted (or 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');
+CREATE TYPE "userGroup" AS enum('supporter','arbitrator','blockedassuree','blockedassurer','blockedlogin','ttp-assurer','ttp-applicant', 'codesigning', 'orgassurer', 'blockedcert', 'nucleus-assurer', 'locate-agent');
CREATE TABLE IF NOT EXISTS "user_groups" (
"id" serial NOT NULL,
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(17);
+INSERT INTO "schemeVersion" (version) VALUES(23);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (
INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Zambia', 'ZM', 'ZMB', 894);
INSERT INTO `countryIsoCode`(english, code2, code3, obp_id) VALUES ('Zimbabwe', 'ZW', 'ZWE', 716);
+
+
+DROP TABLE IF EXISTS "names";
+DROP TYPE IF EXISTS "nameSchemaType";
+CREATE TYPE "nameSchemaType" AS ENUM ('single', 'western');
+
+CREATE TABLE "names" (
+ "id" serial NOT NULL,
+ "uid" int NOT NULL,
+ "type" "nameSchemaType" NOT NULL,
+ "created" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "deleted" timestamp NULL DEFAULT NULL,
+ "deprecated" timestamp NULL DEFAULT NULL,
+ PRIMARY KEY ("id")
+);
+
+
+DROP TABLE IF EXISTS "nameParts";
+DROP TYPE IF EXISTS "namePartType";
+CREATE TYPE "namePartType" AS ENUM ('first-name', 'last-name', 'single-name', 'suffix');
+
+CREATE TABLE "nameParts" (
+ "id" int NOT NULL,
+ "position" int NOT NULL,
+ "type" "namePartType" NOT NULL,
+ "value" varchar(255) NOT NULL
+);