X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FCertificate.java;fp=src%2Forg%2Fcacert%2Fgigi%2FCertificate.java;h=fca5c5a835e993a7cd68a1543d54e18f6423afec;hp=d7af542b674134f0045e57a162077716bac49b17;hb=6edfeaf6c6f7e4311e084d75be62629abb862dc8;hpb=c7f07265ee5cd2af26fb62949d6cd768b16434fe

diff --git a/src/org/cacert/gigi/Certificate.java b/src/org/cacert/gigi/Certificate.java
index d7af542b..fca5c5a8 100644
--- a/src/org/cacert/gigi/Certificate.java
+++ b/src/org/cacert/gigi/Certificate.java
@@ -126,7 +126,7 @@ public class Certificate {
         }
         Notary.writeUserAgreement(ownerId, "CCA", "issue certificate", "", true, 0);
 
-        PreparedStatement inserter = DatabaseConnection.getInstance().prepare("INSERT INTO emailcerts SET md=?, subject=?, csr_type=?, crt_name='', memid=?");
+        PreparedStatement inserter = DatabaseConnection.getInstance().prepare("INSERT INTO emailcerts SET md=?, subject=?, csr_type=?, crt_name='', memid=?, profile=1");
         inserter.setString(1, md);
         inserter.setString(2, dn);
         inserter.setString(3, csrType.toString());
@@ -139,6 +139,13 @@ public class Certificate {
         fos.write(csr.getBytes());
         fos.close();
 
+        // TODO draft to insert SANs
+        PreparedStatement san = DatabaseConnection.getInstance().prepare("INSERT INTO subjectAlternativeNames SET certId=?, contents=?, type=?");
+        san.setInt(1, id);
+        san.setString(2, "<address>");
+        san.setString(3, "email");
+        // san.execute();
+
         PreparedStatement updater = DatabaseConnection.getInstance().prepare("UPDATE emailcerts SET csr_name=? WHERE id=?");
         updater.setString(1, csrName);
         updater.setInt(2, id);