?>
<#17>
     <?php 
require_once './Customizing/global/plugins/Services/UIComponent/UserInterfaceHook/Certificate/classes/Definition/class.srCertificateDefinition.php';
srCertificateDefinition::updateDB();
// Migrate from signature table
global $ilDB;
if ($ilDB->tableExists('cert_signature_def')) {
    $set = $ilDB->query('SELECT * FROM cert_signature_def');
    while ($row = $ilDB->fetchObject($set)) {
        /** @var srCertificateDefinition $definition */
        $definition = srCertificateDefinition::find($row->definition_id);
        $definition->setSignatureId($row->signature_id);
        $definition->save();
    }
}
?>
<#18>
<?php 
// Change data-type for longer emails
global $ilDB;
if ($ilDB->tableExists('uihkcertificate_c')) {
    $ilDB->modifyTableColumn('uihkcertificate_c', 'value', array("type" => "clob", "default" => null, "notnull" => false));
}
?>
<#19>
<?php 
require_once './Customizing/global/plugins/Services/UIComponent/UserInterfaceHook/Certificate/classes/class.ilCertificateConfig.php';
ilCertificateConfig::set('jasper_locale', 'de_DE.UTF-8');
ilCertificateConfig::set('jasper_path_java', '/usr/bin/java');
 /**
  * @param  ilFormPropertyGUI $item
  */
 private function saveValueForItem($item)
 {
     if (self::checkItem($item)) {
         $key = $item->getPostVar();
         if ($item instanceof ilMultiSelectInputGUI) {
             ilCertificateConfig::set($key, json_encode($this->getInput($key)));
         } else {
             ilCertificateConfig::set($key, $this->getInput($key));
         }
         if (self::checkForSubItem($item)) {
             foreach ($item->getSubItems() as $subitem) {
                 $this->saveValueForItem($subitem);
             }
         }
     }
 }