"suffix" varchar(50) NOT NULL DEFAULT '',
"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 '',
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");
"id" int NOT NULL,
"name" varchar(64) NOT NULL,
"state" varchar(2) NOT NULL,
- "province" varchar(100) NOT NULL,
- "city" varchar(100) NOT NULL,
+ "province" varchar(128) NOT NULL,
+ "city" varchar(128) NOT NULL,
"contactEmail" varchar(100) NOT NULL,
"creator" int NOT NULL,
"optional_name" text,
UNIQUE ("type_text")
);
+# Add values to table "cats_type"
+INSERT INTO `cats_type` (`type_text`) VALUES ('Agent Qualifying Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('Organisation Agent Qualifying Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('TTP Agent Qualifying Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('TTP TOPUP Agent Qualifying Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('Code Signing Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('Organisation Administrator Data Protection Challenge');
+INSERT INTO `cats_type` (`type_text`) VALUES ('Support Data Protection Challenge');
+
DROP TABLE IF EXISTS "arbitrations";
CREATE TABLE IF NOT EXISTS "arbitrations" (
"user" int 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', '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(15);
+INSERT INTO "schemeVersion" (version) VALUES(19);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (