"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,
"version" smallint NOT NULL,
PRIMARY KEY ("version")
);
-INSERT INTO "schemeVersion" (version) VALUES(15);
+INSERT INTO "schemeVersion" (version) VALUES(17);
DROP TABLE IF EXISTS `passwordResetTickets`;
CREATE TABLE `passwordResetTickets` (