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;