# 1.0.2 Versionshinweise 03.11.2026
### Fehlerbehebungen #### 1. Website seiten bilder war nicht synchronisiert. Bei der Veröffentlichung der Website (Seite „Webseite“ in D-DOK) wurden die Bilder für die Webseiten nicht in die Web-Datenbank hochgeladen. Dies funktioniert nun wie erwartet. #### 2. Anpassung des Stylings auf der Beispiel-Webseite. Eingebettete Bilder wurden in den Styles nicht korrekt behandelt. Bei einem schmalen Browserfenster (etwa auf einem Mobilgerät) ragten die Bilder über den Container hinaus. Sie verfügen nun über eine „max-width“-Eigenschaft, sodass sie in einem solchen Fall automatisch an den verfügbaren Platz angepasst werden – unter Beibehaltung ihres Seitenverhältnisses. Listen mit Aufzählungspunkten wurden nicht korrekt dargestellt; sie erschienen stets nummeriert, unabhängig davon, welcher Listenstil in D-DOK ausgewählt wurde. Dies wurde behoben. Die Listen unterstützen nun sämtliche Formate, die auch im Rich-Text-Editor von D-DOK verfügbar sind. ### Neu entwicklung #### 1. Blog und Newsletter. In D-DOK gibt es nun Unterstützung für „Blog“ und „Newsletter“. Diese wurden nach dem Navigationspunkt „Publikationen“ hinzugefügt und können über die Systemberechtigungen aktiviert bzw. deaktiviert werden. Die Systemberechtigungen wurden neu strukturiert: Die Berechtigungen sind nun nach Seiten gruppiert, anstatt nach Admin-Gruppen. Die Benutzeroberflächen ermöglichen es autorisierten Nutzern, Inhalte für die öffentliche Webseite zu erstellen. Im Beispiel sind diese unter „Medien“ zu finden; dort können Nachrichten- und Blogbeiträge hinzugefügt werden. Zudem gibt es entsprechende Optionen in den „Veröffentlichungseinstellungen“. Hier lässt sich festlegen, ob in D-DOK Eingabefelder für Bilder, Kurzbeschreibungen und ausführliche Beschreibungen für diese neuen Kategorien bereitgestellt werden sollen. **Blogbeiträge umfassen:** Bilder (inklusive ALT-Text und Quellenangabe) Mehrsprachigkeitsunterstützung (Englisch) für alle Eingabefelder Schlagwörter Verknüpfte Projekte (beliebige Anzahl) Autoren (beliebige Anzahl) Veröffentlichungsdatum PDF-Dateien (beliebige Anzahl) Kurz- und ausführliche Beschreibungen **Newsletter umfassen:** Bilder (inklusive ALT-Text und Quellenangabe) Mehrsprachigkeitsunterstützung (Englisch) für alle Eingabefelder Veröffentlichungsdatum PDF-Dateien (beliebige Anzahl) Kurz- und ausführliche Beschreibungen Im Zuge dieser Änderung gibt es nun 7 neue Tabellen in der Datenbank der Website: web\_blog web\_blog\_author web\_blog\_file web\_blog\_keyword web\_blog\_project web\_news web\_news\_file Die vollständige Datenbankstruktur für die exportierte Webdatenbank lautet nun: (Die Struktur bestehender Tabellen wurde nicht verändert. Es wurden lediglich neue Tabellen hinzugefügt.)
/\*
Navicat Premium Data Transfer
Source Server : dess local
Source Server Type : MySQL
Source Server Version : 110412
Source Host : localhost:3306
Source Schema : ddok-web
Target Server Type : MySQL
Target Server Version : 110412
File Encoding : 65001
Date: 03/11/2026 10:48:30
\*/
SET NAMES utf8mb4;
SET FOREIGN\_KEY\_CHECKS = 0;
-- ----------------------------
-- Table structure for web\_blog
-- ----------------------------
DROP TABLE IF EXISTS `web\_blog`;
CREATE TABLE `web\_blog` (
`blog\_id` int NOT NULL,
`blog\_date` bigint NOT NULL,
`blog\_has\_english` tinyint NOT NULL DEFAULT 0,
`blog\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`blog\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`blog\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`blog\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`blog\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`blog\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`blog\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`blog\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`blog\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`blog\_id`) USING BTREE,
INDEX `IDX\_acae69f9741b2f360e8d490321`(`blog\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_7e2897643a4f40419c9bfcb9ef`(`blog\_description\_short`),
FULLTEXT INDEX `IDX\_82a0d4a36b8875d1872a2ae3aa`(`blog\_description\_short\_en`),
FULLTEXT INDEX `IDX\_de86618fbb60bb5b7bbe2aa770`(`blog\_description\_text`),
FULLTEXT INDEX `IDX\_9932f1446e9e87457ac8031dd0`(`blog\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_blog\_author
-- ----------------------------
DROP TABLE IF EXISTS `web\_blog\_author`;
CREATE TABLE `web\_blog\_author` (
`blog\_author\_id` int NOT NULL,
`blog\_author\_blog\_id` int NOT NULL,
`blog\_author\_author\_id` int NOT NULL,
`blog\_author\_author\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_author\_internal` tinyint NOT NULL,
PRIMARY KEY (`blog\_author\_id`) USING BTREE,
INDEX `IDX\_3fef8597208e3c8cca6ac032f0`(`blog\_author\_id`) USING BTREE,
INDEX `IDX\_d54ded43c2154220486c648a2c`(`blog\_author\_blog\_id`) USING BTREE,
INDEX `IDX\_2050e5dc28acba0c4866f9c439`(`blog\_author\_author\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_blog\_file
-- ----------------------------
DROP TABLE IF EXISTS `web\_blog\_file`;
CREATE TABLE `web\_blog\_file` (
`blog\_file\_id` int NOT NULL,
`blog\_file\_blog\_id` int NOT NULL,
`blog\_file\_bucket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_encoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_mime\_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`blog\_file\_length` int NOT NULL,
PRIMARY KEY (`blog\_file\_id`) USING BTREE,
INDEX `IDX\_49da2f74a541ae1932206d6385`(`blog\_file\_id`) USING BTREE,
INDEX `IDX\_d916d4e469a953386d558e09e7`(`blog\_file\_blog\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_12860b3d3fdd816dc24aab6eb9`(`blog\_file\_description`),
FULLTEXT INDEX `IDX\_df21621b1db66c9590c8569ca6`(`blog\_file\_text`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_blog\_keyword
-- ----------------------------
DROP TABLE IF EXISTS `web\_blog\_keyword`;
CREATE TABLE `web\_blog\_keyword` (
`blog\_keyword\_id` int NOT NULL,
`blog\_keyword\_blog\_id` int NOT NULL,
`blog\_keyword\_keyword\_id` int NOT NULL,
PRIMARY KEY (`blog\_keyword\_id`) USING BTREE,
INDEX `IDX\_3373b0902257aa8713dbf99b1f`(`blog\_keyword\_id`) USING BTREE,
INDEX `IDX\_86cfa9dde48f84e935055e290f`(`blog\_keyword\_blog\_id`) USING BTREE,
INDEX `IDX\_7990d8c95478ea2788c6567732`(`blog\_keyword\_keyword\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_blog\_project
-- ----------------------------
DROP TABLE IF EXISTS `web\_blog\_project`;
CREATE TABLE `web\_blog\_project` (
`blog\_project\_id` int NOT NULL,
`blog\_project\_blog\_id` int NOT NULL,
`blog\_project\_project\_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
PRIMARY KEY (`blog\_project\_id`) USING BTREE,
INDEX `IDX\_9f7f5ebc15717b58330041cfdc`(`blog\_project\_id`) USING BTREE,
INDEX `IDX\_cda14b931cbe4def18f1ad475f`(`blog\_project\_blog\_id`) USING BTREE,
INDEX `IDX\_3e756cb94f979e5de70d995276`(`blog\_project\_project\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_department
-- ----------------------------
DROP TABLE IF EXISTS `web\_department`;
CREATE TABLE `web\_department` (
`department\_id` int NOT NULL,
`department\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`department\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_leader\_id` int NULL DEFAULT NULL,
`department\_deputy\_id` int NULL DEFAULT NULL,
`department\_nsleft` int NOT NULL,
`department\_nsright` int NOT NULL,
`department\_parent\_id` int NULL DEFAULT NULL,
`department\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`department\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`department\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`department\_active` tinyint NOT NULL DEFAULT 0,
`department\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`department\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`department\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`department\_id`) USING BTREE,
INDEX `IDX\_b6a23c51b5f9522044f599c225`(`department\_id`) USING BTREE,
INDEX `IDX\_3d72b848a2d10945c300ba7a32`(`department\_leader\_id`) USING BTREE,
INDEX `IDX\_8c97d61c0fceb7d355648c53e5`(`department\_deputy\_id`) USING BTREE,
INDEX `IDX\_911da74dfec04730bdc497e03e`(`department\_parent\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_ebe001c9580693d6eac732a245`(`department\_description\_short`),
FULLTEXT INDEX `IDX\_b05832c0f24e34dfa1965eb1ee`(`department\_description\_text`),
FULLTEXT INDEX `IDX\_53b205b750dccad75bbdbc7952`(`department\_description\_short\_en`),
FULLTEXT INDEX `IDX\_ebefe54ef2457b4bfae8ab96da`(`department\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_employee
-- ----------------------------
DROP TABLE IF EXISTS `web\_employee`;
CREATE TABLE `web\_employee` (
`employee\_id` int NOT NULL,
`employee\_department\_id` int NULL DEFAULT NULL,
`employee\_active` tinyint NOT NULL,
`employee\_firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`employee\_surname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`employee\_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`employee\_telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`employee\_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_position\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`employee\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`employee\_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
PRIMARY KEY (`employee\_id`) USING BTREE,
INDEX `IDX\_bb4354118acf558590ecfa3cb0`(`employee\_id`) USING BTREE,
INDEX `IDX\_ed2d77671613adc63acbc03f4a`(`employee\_department\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_6a3a0ddaeb8209e465da679eb8`(`employee\_description\_text`),
FULLTEXT INDEX `IDX\_42ffe6bdd195ee56e4e6a93593`(`employee\_description\_short`),
FULLTEXT INDEX `IDX\_98796a3c6fb7ba2895f2ee77e7`(`employee\_description\_short\_en`),
FULLTEXT INDEX `IDX\_b8c3924ae383b6158588f5f864`(`employee\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_file
-- ----------------------------
DROP TABLE IF EXISTS `web\_file`;
CREATE TABLE `web\_file` (
`file\_id` int NOT NULL,
`file\_publication\_id` int NOT NULL,
`file\_bucket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_encoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_mime\_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`file\_length` int NOT NULL,
PRIMARY KEY (`file\_id`) USING BTREE,
INDEX `IDX\_8431cafb7575c4dc2a8031720c`(`file\_id`) USING BTREE,
INDEX `IDX\_43ee1bd3b345c49491c2b1f91b`(`file\_publication\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_b71e6045519b3351667b84491d`(`file\_text`),
FULLTEXT INDEX `IDX\_d9ec07b95614b0b256bed76282`(`file\_description`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_keyword
-- ----------------------------
DROP TABLE IF EXISTS `web\_keyword`;
CREATE TABLE `web\_keyword` (
`keyword\_id` int NOT NULL,
`keyword\_parent\_id` int NOT NULL,
`keyword\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`keyword\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`keyword\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`keyword\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`keyword\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`keyword\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`keyword\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`keyword\_id`) USING BTREE,
INDEX `IDX\_0b53eeaae5f13ead7bfc8ae54d`(`keyword\_id`) USING BTREE,
INDEX `IDX\_4c79f22c01dcfa9707d7ec4c49`(`keyword\_parent\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_901d0a57af682e825d9e345b05`(`keyword\_description\_short`),
FULLTEXT INDEX `IDX\_b7f86de1af38160e96a0b64ce8`(`keyword\_description\_short\_en`),
FULLTEXT INDEX `IDX\_0241ccb2e16eef39b4e21f364a`(`keyword\_description\_text`),
FULLTEXT INDEX `IDX\_c589fb21e27b5469ed4a63717b`(`keyword\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_link
-- ----------------------------
DROP TABLE IF EXISTS `web\_link`;
CREATE TABLE `web\_link` (
`link\_id` int NOT NULL,
`link\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`link\_url` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
PRIMARY KEY (`link\_id`) USING BTREE,
INDEX `IDX\_5f96b3b473f2a4faf181b4a441`(`link\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_news
-- ----------------------------
DROP TABLE IF EXISTS `web\_news`;
CREATE TABLE `web\_news` (
`news\_id` int NOT NULL,
`news\_date` bigint NOT NULL,
`news\_has\_english` tinyint NOT NULL DEFAULT 0,
`news\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`news\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`news\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`news\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`news\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`news\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`news\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`news\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`news\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`news\_id`) USING BTREE,
INDEX `IDX\_d5ed02a99afdd51dd0c535f033`(`news\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_645de086b0d457bb2a03f0efa3`(`news\_description\_short`),
FULLTEXT INDEX `IDX\_9b526513de52f6c93d5cffb0a1`(`news\_description\_short\_en`),
FULLTEXT INDEX `IDX\_2401567a2069147d122531353c`(`news\_description\_text`),
FULLTEXT INDEX `IDX\_a4007758f626b05cbd8534075d`(`news\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_news\_file
-- ----------------------------
DROP TABLE IF EXISTS `web\_news\_file`;
CREATE TABLE `web\_news\_file` (
`news\_file\_id` int NOT NULL,
`news\_file\_news\_id` int NOT NULL,
`news\_file\_bucket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_encoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_mime\_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`news\_file\_length` int NOT NULL,
PRIMARY KEY (`news\_file\_id`) USING BTREE,
INDEX `IDX\_83faca6099f82cf0eae754e63e`(`news\_file\_id`) USING BTREE,
INDEX `IDX\_af98395ac6bdd0bd9f7ec832b0`(`news\_file\_news\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_68b7c3b4e1f600de5cb694b03f`(`news\_file\_description`),
FULLTEXT INDEX `IDX\_3ac6e8c7e42f42b9da27aede2b`(`news\_file\_text`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_page
-- ----------------------------
DROP TABLE IF EXISTS `web\_page`;
CREATE TABLE `web\_page` (
`page\_id` int NOT NULL,
`page\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_description\_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`page\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`page\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`page\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_description\_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_description\_text\_en` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`page\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`page\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`page\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`page\_id`) USING BTREE,
INDEX `IDX\_d0e22bed39c0d29b1079643a61`(`page\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_90c8a4be3da0b0d748789c1749`(`page\_description\_short`),
FULLTEXT INDEX `IDX\_d6cef9b6c236f74b9e874a2d13`(`page\_description\_text`),
FULLTEXT INDEX `IDX\_624d72e4d8be4ab939a3b08a3f`(`page\_description\_short\_en`),
FULLTEXT INDEX `IDX\_e4c426c1e625614b8c3f39c720`(`page\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_project
-- ----------------------------
DROP TABLE IF EXISTS `web\_project`;
CREATE TABLE `web\_project` (
`project\_id` int NOT NULL,
`project\_category\_id` int NOT NULL,
`project\_department\_id` int NULL DEFAULT NULL,
`project\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_start` bigint NULL DEFAULT NULL,
`project\_end` bigint NULL DEFAULT NULL,
`project\_first\_leader\_id` int NULL DEFAULT NULL,
`project\_first\_leader\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_second\_leader\_id` int NULL DEFAULT NULL,
`project\_second\_leader\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_third\_leader\_id` int NULL DEFAULT NULL,
`project\_third\_leader\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_dafne` int NULL DEFAULT NULL,
`project\_sap\_kostenstelle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`project\_has\_english` tinyint NOT NULL DEFAULT 0,
`project\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`project\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
PRIMARY KEY (`project\_id`) USING BTREE,
INDEX `IDX\_4ecc64a40265110f92b44170c2`(`project\_id`) USING BTREE,
INDEX `IDX\_bfa30604ef62bd5cb530e95dd4`(`project\_category\_id`) USING BTREE,
INDEX `IDX\_fa87d7e34447c6b08178917b08`(`project\_department\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_caa06feb4365eb792242399fb8`(`project\_description\_text`),
FULLTEXT INDEX `IDX\_08ab5a6239ac3b46122b1e0298`(`project\_description\_text\_en`),
FULLTEXT INDEX `IDX\_918c44fc3ca0834278da06713f`(`project\_description\_short`),
FULLTEXT INDEX `IDX\_c1bbd1d93dc8c7d3b72957d058`(`project\_description\_short\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_project\_category
-- ----------------------------
DROP TABLE IF EXISTS `web\_project\_category`;
CREATE TABLE `web\_project\_category` (
`project\_category\_id` int NOT NULL,
`project\_category\_order` int NOT NULL,
`project\_category\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_category\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`project\_category\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`project\_category\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`project\_category\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_category\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`project\_category\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`project\_category\_id`) USING BTREE,
INDEX `IDX\_cf6de50f0f7fb43631301ee737`(`project\_category\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_c02e8742af398eda0f523d8980`(`project\_category\_description\_short`),
FULLTEXT INDEX `IDX\_1c98d1b98f0643558797e420be`(`project\_category\_description\_short\_en`),
FULLTEXT INDEX `IDX\_722c49c824e0cb5238042b9f30`(`project\_category\_description\_text`),
FULLTEXT INDEX `IDX\_e859acd40a1d435453ea92ddb9`(`project\_category\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_project\_keyword
-- ----------------------------
DROP TABLE IF EXISTS `web\_project\_keyword`;
CREATE TABLE `web\_project\_keyword` (
`project\_keyword\_id` int NOT NULL,
`project\_keyword\_project\_id` int NOT NULL,
`project\_keyword\_keyword\_id` int NOT NULL,
PRIMARY KEY (`project\_keyword\_id`) USING BTREE,
INDEX `IDX\_9c81d744003090539a799dbda0`(`project\_keyword\_id`) USING BTREE,
INDEX `IDX\_1da0e7cdbf17c80155da1e952b`(`project\_keyword\_project\_id`) USING BTREE,
INDEX `IDX\_97e385ac3a0de60a674f2ee441`(`project\_keyword\_keyword\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_project\_team
-- ----------------------------
DROP TABLE IF EXISTS `web\_project\_team`;
CREATE TABLE `web\_project\_team` (
`project\_team\_id` int NOT NULL,
`project\_team\_project\_id` int NOT NULL,
`project\_team\_member\_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_team\_member\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`project\_team\_internal` tinyint NOT NULL,
PRIMARY KEY (`project\_team\_id`) USING BTREE,
INDEX `IDX\_ba8242702b7d0fe7e2a79e04a8`(`project\_team\_id`) USING BTREE,
INDEX `IDX\_2293614bf3395ab89cdd997618`(`project\_team\_project\_id`) USING BTREE,
INDEX `IDX\_87eae0830cf480cb7de664777a`(`project\_team\_member\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_publication
-- ----------------------------
DROP TABLE IF EXISTS `web\_publication`;
CREATE TABLE `web\_publication` (
`publication\_id` int NOT NULL,
`publication\_project\_id` int NOT NULL,
`publication\_type\_id` int NOT NULL,
`publication\_date` bigint NOT NULL,
`publication\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_quote` text CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_first\_author\_id` int NULL DEFAULT NULL,
`publication\_first\_author\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_second\_author\_id` int NULL DEFAULT NULL,
`publication\_second\_author\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_third\_author\_id` int NULL DEFAULT NULL,
`publication\_third\_author\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`publication\_extra\_properties` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_has\_english` tinyint NOT NULL DEFAULT 0,
`publication\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`publication\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
PRIMARY KEY (`publication\_id`) USING BTREE,
INDEX `IDX\_4a365fb077536f666bc5f1ec80`(`publication\_id`) USING BTREE,
INDEX `IDX\_a1caed3a21d8fcaaf4b1082159`(`publication\_project\_id`) USING BTREE,
INDEX `IDX\_dd6776c573277a3513c35824e0`(`publication\_type\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_de7de5ec277b678324ec6c729d`(`publication\_description\_text`),
FULLTEXT INDEX `IDX\_d2e82dac139edbcff8156c2ebe`(`publication\_description\_text\_en`),
FULLTEXT INDEX `IDX\_a1a4e0256894744bfea27f5e27`(`publication\_description\_short`),
FULLTEXT INDEX `IDX\_8f5963ddf4437ace7bc7a99cc4`(`publication\_description\_short\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_publication\_author
-- ----------------------------
DROP TABLE IF EXISTS `web\_publication\_author`;
CREATE TABLE `web\_publication\_author` (
`publication\_author\_id` int NOT NULL,
`publication\_author\_publication\_id` int NOT NULL,
`publication\_author\_author\_id` int NOT NULL,
`publication\_author\_author\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_author\_internal` tinyint NOT NULL,
PRIMARY KEY (`publication\_author\_id`) USING BTREE,
INDEX `IDX\_7abafad1dc7b9d8fda469a64a6`(`publication\_author\_id`) USING BTREE,
INDEX `IDX\_026110932f6e4f1a7adf7c76de`(`publication\_author\_publication\_id`) USING BTREE,
INDEX `IDX\_03fa2d636d2dd787e70c35d986`(`publication\_author\_author\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_publication\_keyword
-- ----------------------------
DROP TABLE IF EXISTS `web\_publication\_keyword`;
CREATE TABLE `web\_publication\_keyword` (
`publication\_keyword\_id` int NOT NULL,
`publication\_keyword\_publication\_id` int NOT NULL,
`publication\_keyword\_keyword\_id` int NOT NULL,
PRIMARY KEY (`publication\_keyword\_id`) USING BTREE,
INDEX `IDX\_9edf99a3274de2c4b3448e1095`(`publication\_keyword\_id`) USING BTREE,
INDEX `IDX\_2eef163cab3f84854a11b0ab77`(`publication\_keyword\_publication\_id`) USING BTREE,
INDEX `IDX\_132665b0bcbfa042619859b842`(`publication\_keyword\_keyword\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_publication\_project
-- ----------------------------
DROP TABLE IF EXISTS `web\_publication\_project`;
CREATE TABLE `web\_publication\_project` (
`publication\_project\_id` int NOT NULL,
`publication\_project\_publication\_id` int NOT NULL,
`publication\_project\_project\_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
PRIMARY KEY (`publication\_project\_id`) USING BTREE,
INDEX `IDX\_859739adfe40d0731117cb0cc0`(`publication\_project\_id`) USING BTREE,
INDEX `IDX\_fa29a5d9d2dca4093024d25640`(`publication\_project\_publication\_id`) USING BTREE,
INDEX `IDX\_887866875b25390a299607e466`(`publication\_project\_project\_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for web\_publication\_type
-- ----------------------------
DROP TABLE IF EXISTS `web\_publication\_type`;
CREATE TABLE `web\_publication\_type` (
`publication\_type\_id` int NOT NULL,
`publication\_type\_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL,
`publication\_type\_order` int NOT NULL,
`publication\_type\_parent\_id` int NOT NULL,
`publication\_type\_name\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`publication\_type\_description\_short` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_description\_short\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_description\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_description\_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_description\_text\_en` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL,
`publication\_type\_image\_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NOT NULL DEFAULT '',
`publication\_type\_image\_alt\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_type\_image\_alt\_text\_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
`publication\_type\_image\_source\_text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci NULL DEFAULT NULL,
PRIMARY KEY (`publication\_type\_id`) USING BTREE,
INDEX `IDX\_c5eccec7eb91115ce18f6693ec`(`publication\_type\_id`) USING BTREE,
FULLTEXT INDEX `IDX\_1fb849a65a095959039a05c80d`(`publication\_type\_description\_short`),
FULLTEXT INDEX `IDX\_544fbfc52e86dc0aea19b63b83`(`publication\_type\_description\_short\_en`),
FULLTEXT INDEX `IDX\_c8274e53d98b0030ad10d477a9`(`publication\_type\_description\_text`),
FULLTEXT INDEX `IDX\_277914cf6fea00f73ad4383bb4`(`publication\_type\_description\_text\_en`)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4\_general\_ci ROW\_FORMAT = Dynamic;
SET FOREIGN\_KEY\_CHECKS = 1;