   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
   `service_id` int(11) unsigned NOT NULL,
   `svc_group_id` int(11) unsigned NOT NULL,
-  `entry_type` enum('current','revision') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'revision',
+  `entry_type` enum('current','revision') NOT NULL DEFAULT 'revision',
   `json_id` int(11) unsigned DEFAULT NULL,
-  `json_sha256` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
-  `hostname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
+  `json_sha256` varchar(64) NOT NULL DEFAULT '',
+  `hostname` varchar(255) NOT NULL DEFAULT '',
   `sslv2` tinyint(1) unsigned NOT NULL DEFAULT '0',
   `sslv3` tinyint(1) unsigned NOT NULL DEFAULT '0',
   `tlsv1` tinyint(1) unsigned NOT NULL DEFAULT '0',

--
-- Host: localhost    Database: pk
-- ------------------------------------------------------
-- Server version	5.5.40-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `certs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pem_sha256` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `x509` mediumtext CHARACTER SET utf8 NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pem_sha256` (`pem_sha256`)
) ENGINE=InnoDB AUTO_INCREMENT=707 DEFAULT CHARSET=utf8mb4 COMMENT='Protokollen: X.509 cert store for scan data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
