From: Felix Dörre <felix@dogcraft.de>
Date: Mon, 27 Jun 2016 14:49:58 +0000 (+0200)
Subject: fixup database content for typo-fix in "Assurer's Challenge"
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=a0bd98b84c358acbd0b29988dffe388e3e4323e8

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 19954c60..578c1353 100644
--- 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 a855d706..a3519798 100644
--- 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
index 00000000..cc7340f8
--- /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';