fixup database content for typo-fix in "Assurer's Challenge"

Change-Id: Ic33ea8356e86eb695e8c631485214aa04136288a

diff --git a/src/org/cacert/gigi/Gigi.java b/src/org/cacert/gigi/Gigi.java
index 19954c6089870a517b5d68cd16a4ac0838bd2a29..578c1353f9cb456934b9f4a88d9f4281441a2b8e 100644 (file)
--- a/src/org/cacert/gigi/Gigi.java
+++ b/src/org/cacert/gigi/Gigi.java
@@ -23,6 +23,7 @@ import javax.servlet.http.HttpSession;
 import org.cacert.gigi.database.DatabaseConnection;
 import org.cacert.gigi.database.DatabaseConnection.Link;
 import org.cacert.gigi.dbObjects.CACertificate;
+import org.cacert.gigi.dbObjects.CATS;
 import org.cacert.gigi.dbObjects.CertificateProfile;
 import org.cacert.gigi.dbObjects.DomainPingConfiguration;
 import org.cacert.gigi.localisation.Language;
@@ -251,6 +252,7 @@ public final class Gigi extends HttpServlet {
         try (Link l = DatabaseConnection.newLink(false)) {
             CACertificate.getById(1);
             CertificateProfile.getById(1);
+            CATS.getID(CATS.ASSURER_CHALLANGE_NAME);
         } catch (InterruptedException e) {
             throw new Error(e);
         }

diff --git a/src/org/cacert/gigi/database/DatabaseConnection.java b/src/org/cacert/gigi/database/DatabaseConnection.java
index a855d706155faff34fd993cbbcbcf88fd0abb8c1..a35197985a76150368edd73ad5d724907c0fc8c4 100644 (file)
--- a/src/org/cacert/gigi/database/DatabaseConnection.java
+++ b/src/org/cacert/gigi/database/DatabaseConnection.java
@@ -122,7 +122,7 @@ public class DatabaseConnection {
 
     }
 
-    public static final int CURRENT_SCHEMA_VERSION = 11;
+    public static final int CURRENT_SCHEMA_VERSION = 12;
 
     public static final int CONNECTION_TIMEOUT = 24 * 60 * 60;
 

diff --git a/src/org/cacert/gigi/database/upgrade/from_11.sql b/src/org/cacert/gigi/database/upgrade/from_11.sql
new file mode 100644 (file)
index 0000000..cc7340f
--- /dev/null
+++ b/src/org/cacert/gigi/database/upgrade/from_11.sql
@@ -0,0 +1 @@
+UPDATE `cats_type` SET `type_text` = 'Assurer''s Challenge' WHERE `type_text` = 'Assurer''s Challange';