X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_16.sql;fp=src%2Fclub%2Fwpia%2Fgigi%2Fdatabase%2Fupgrade%2Ffrom_16.sql;h=021e630994ba19a9a835daa23223fdc45b42d5ce;hp=0000000000000000000000000000000000000000;hb=bccd4cc0dba0f89aa045b113bac46eb8cc1dab4e;hpb=c9ed09f0007fc2c813815be927a5a24b23dab83c

diff --git a/src/club/wpia/gigi/database/upgrade/from_16.sql b/src/club/wpia/gigi/database/upgrade/from_16.sql
new file mode 100644
index 00000000..021e6309
--- /dev/null
+++ b/src/club/wpia/gigi/database/upgrade/from_16.sql
@@ -0,0 +1,8 @@
+UPDATE `cats_type` SET `type_text` = 'Agent Qualifying Challenge' WHERE `type_text` = 'Assurer''s 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');