Merge branch 'main' into issue-3911issue-3911

1 files changed, 27 insertions, 33 deletions

diff --git a/db/studip_demo_data.sql b/db/studip_demo_data.sql
index 672ace2..7c0a571 100644
--- a/db/studip_demo_data.sql
+++ b/db/studip_demo_data.sql
@@ -9,11 +9,12 @@ REPLACE INTO `abschluss` (`abschluss_id`, `name`, `name_kurz`, `beschreibung`, `
 -- Daten für Tabelle `auth_user_md5`
 --
 
-REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`) VALUES('76ed43ef286fb55cf9e41beadb484a9f', 'root@studip', '$2a$08$SRoCYxAhWPFVF8V8CO15TOyzr.PpLRfVD9lVWVrmmBw4brkRTE/2G', 'root', 'Root', 'Studip', 'root@localhost', '', 'standard', 0, NULL, NULL, 'unknown');
-REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`) VALUES('205f3efb7997a0fc9755da2b535038da', 'test_dozent', '$2a$08$ajIvgEjd17MiiDcFr6msc.xldknH/tTGajUXVhDxDKNJVX0H0iv0i', 'dozent', 'Testaccount', 'Dozent', 'dozent@studip.de', '', 'standard', 0, NULL, NULL, 'unknown');
-REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`) VALUES('6235c46eb9e962866ebdceece739ace5', 'test_admin', '$2a$08$svvSma20vIxIR4J5gc0jIu31gws1WibmiQ/HDhCTukFA5GqhscY1G', 'admin', 'Testaccount', 'Admin', 'admin@studip.de', '', 'standard', 0, NULL, NULL, 'unknown');
-REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`) VALUES('7e81ec247c151c02ffd479511e24cc03', 'test_tutor', '$2a$08$mGhBl85TPsiItumZ4xjbgOnQ1vqIhLAC9giCfWcFzpkE1jqe4lmby', 'tutor', 'Testaccount', 'Tutor', 'tutor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown');
-REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', 'test_autor', '$2a$08$xvbrvPhkcsvkzPZsNh.kceLw2IIwiNJ.1jGOwY3.H/dR2f8PG5X3O', 'autor', 'Testaccount', 'Autor', 'autor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown');
+REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('205f3efb7997a0fc9755da2b535038da', 'test_dozent', 0x24326124303824616a497667456a6431374d696944634672366d73632e786c646b6e482f745447616a555856684478444b4e4a565830483069763069, 'dozent', 'Testaccount', 'Dozent', 'dozent@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
+REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('6235c46eb9e962866ebdceece739ace5', 'test_admin', 0x24326124303824737676536d6132307649784952344a356763306a49753331677773315769626d69512f4844684354756b4641354771687363593147, 'admin', 'Testaccount', 'Admin', 'admin@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
+REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('76ed43ef286fb55cf9e41beadb484a9f', 'root@studip', 0x2432612430382453526f43597841685750465646385638434f3135544f797a722e50704c52665644396c565756726d6d42773462726b5254452f3247, 'root', 'Root', 'Studip', 'root@localhost', '', 'standard', 0, NULL, NULL, 'yes', NULL);
+REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('7e81ec247c151c02ffd479511e24cc03', 'test_tutor', 0x243261243038246d4768426c3835545073694974756d5a34786a62674f6e5131767149684c414339676943665763467a706b45316a7165346c6d6279, 'tutor', 'Testaccount', 'Tutor', 'tutor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
+REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', 'test_autor', 0x24326124303824787662727650686b6373766b7a505a734e682e6b63654c7732494977694e4a2e316a474f7759332e482f645232663850473558334f, 'autor', 'Testaccount', 'Autor', 'autor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', '1234567');
+
 
 --
 -- Daten für Tabelle `config_values`
@@ -23,15 +24,6 @@ REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`,
 REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`, `comment`) VALUES('STUDYGROUP_DEFAULT_INST', 'studip', 'ec2e364b28357106c0f8c282733dbe56', 1268739461, 1268739461, '');
 REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`, `comment`) VALUES('STUDYGROUP_TERMS', 'studip', 'Mir ist bekannt, dass ich die Gruppe nicht zu rechtswidrigen Zwecken nutzen darf. Dazu zählen u.a. Urheberrechtsverletzungen, Beleidigungen und andere Persönlichkeitsdelikte.\r\n\r\nIch erkläre mich damit einverstanden, dass Administratorinnen und Administratoren die Inhalte der Gruppe zu Kontrollzwecken einsehen dürfen.', 1268739461, 1268739461, '');
 
---
--- Daten für Tabelle `datafields`
---
-
-REPLACE INTO `datafields` (`datafield_id`, `name`, `object_type`, `object_class`, `edit_perms`, `view_perms`, `priority`, `mkdate`, `chdate`, `type`, `typeparam`, `is_required`, `default_value`, `is_userfilter`, `description`, `system`) VALUES('ce73a10d07b3bb13c0132d363549efda', 'Matrikelnummer', 'user', '7', 'user', 'dozent', 0, NULL, NULL, 'textline', '', 0, NULL, 0, '', 0);
-
-REPLACE INTO `datafields_entries` (`datafield_id`, `range_id`, `content`, `mkdate`, `chdate`, `sec_range_id`, `lang`) VALUES('ce73a10d07b3bb13c0132d363549efda', 'e7a0a84b161f3e8c09b4a0a2e8a58147', '1234567', 1530292487, 1530292487, '', '');
-
-
 
 --
 -- Dumping data for table `fach`
@@ -56,7 +48,7 @@ REPLACE INTO `file_refs` (`id`, `file_id`, `folder_id`, `downloads`, `descriptio
 -- Dumping data for table `folders`
 --
 
-REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('012cb91a42cf85e5fafdd84e54ed2ec3', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'CourseDateFolder', '15. Klausur am Do., 21.02.2019, 12:00 - 14:00', '{\"termin_id\":\"9ff59e18112a686c553412761a5df85c\",\"permission\":5}', '', 1543859055, 1543859055);
+REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('012cb91a42cf85e5fafdd84e54ed2ec3', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'CourseDateFolder', '15. Klausur am Sa., 15.02.2025, 11:00 - 12:30', '{\"termin_id\":\"86de155d92a8f2da7ed6cd8ed9c08d71\",\"permission\":5}', '', 1543859055, 1543859055);
 REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('3cc9006789bceef5d3ea7bed680790b4', '76ed43ef286fb55cf9e41beadb484a9f', '', '110ce78ffefaf1e5f167cd7019b728bf', 'institute', 'RootFolder', 'externe Einrichtung B', '', '', 1510849315, 1510849315);
 REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('694cdcef09c2b8e70a7313b028e36fb6', '', '3cc9006789bceef5d3ea7bed680790b4', '110ce78ffefaf1e5f167cd7019b728bf', 'institute', 'StandardFolder', 'Allgemeiner Dateiordner', '', 'Ablage für allgemeine Ordner und Dokumente der Einrichtung', 1156516698, 1156516698);
 REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('76b822dcc7f1458ae6e144c3c0fb544e', '76ed43ef286fb55cf9e41beadb484a9f', '', 'ec2e364b28357106c0f8c282733dbe56', 'institute', 'RootFolder', 'externe Bildungseinrichtungen', '', '', 1510849315, 1510849315);
@@ -162,7 +154,7 @@ REPLACE INTO `semester_courses` (`semester_id`, `course_id`, `mkdate`, `chdate`)
 --
 
 REPLACE INTO `seminare` (`Seminar_id`, `VeranstaltungsNummer`, `Institut_id`, `Name`, `Untertitel`, `status`, `Beschreibung`, `Ort`, `Sonstiges`, `Lesezugriff`, `Schreibzugriff`, `start_time`, `duration_time`, `art`, `teilnehmer`, `vorrausetzungen`, `lernorga`, `leistungsnachweis`, `mkdate`, `chdate`, `ects`, `admission_turnout`, `admission_binding`, `admission_prelim`, `admission_prelim_txt`, `admission_disable_waitlist`, `visible`, `showscore`, `aux_lock_rule`, `aux_lock_rule_forced`, `lock_rule`, `admission_waitlist_max`, `admission_disable_waitlist_move`, `completion`, `parent_course`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', '', 'ec2e364b28357106c0f8c282733dbe56', 'Test Studiengruppe', '', 99, 'Studiengruppen sind eine einfache Möglichkeit, mit KommilitonInnen, KollegInnen und anderen zusammenzuarbeiten.', '', '', 1, 1, 1680300000, -1, '', '', '', '', '', 1268739824, 1607705186, '', 0, 0, 0, '', 0, 1, 0, NULL, 0, NULL, 0, 0, 0, NULL);
-REPLACE INTO `seminare` (`Seminar_id`, `VeranstaltungsNummer`, `Institut_id`, `Name`, `Untertitel`, `status`, `Beschreibung`, `Ort`, `Sonstiges`, `Lesezugriff`, `Schreibzugriff`, `start_time`, `duration_time`, `art`, `teilnehmer`, `vorrausetzungen`, `lernorga`, `leistungsnachweis`, `mkdate`, `chdate`, `ects`, `admission_turnout`, `admission_binding`, `admission_prelim`, `admission_prelim_txt`, `admission_disable_waitlist`, `visible`, `showscore`, `aux_lock_rule`, `aux_lock_rule_forced`, `lock_rule`, `admission_waitlist_max`, `admission_disable_waitlist_move`, `completion`, `parent_course`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '12345', '2560f7c7674942a7dce8eeb238e15d93', 'Test Lehrveranstaltung', 'eine normale Lehrveranstaltung', 1, '', '', '', 1, 1, 1696111200, 0, '', 'für alle Studierenden', 'abgeschlossenes Grundstudium', 'Referate in Gruppenarbeit', 'Klausur', 1343924407, 1641229951, '4', 0, 0, 0, '', 0, 1, 0, NULL, 0, NULL, 0, 0, 0, NULL);
+REPLACE INTO `seminare` (`Seminar_id`, `VeranstaltungsNummer`, `Institut_id`, `Name`, `Untertitel`, `status`, `Beschreibung`, `Ort`, `Sonstiges`, `Lesezugriff`, `Schreibzugriff`, `start_time`, `duration_time`, `art`, `teilnehmer`, `vorrausetzungen`, `lernorga`, `leistungsnachweis`, `mkdate`, `chdate`, `ects`, `admission_turnout`, `admission_binding`, `admission_prelim`, `admission_prelim_txt`, `admission_disable_waitlist`, `visible`, `showscore`, `aux_lock_rule`, `aux_lock_rule_forced`, `lock_rule`, `admission_waitlist_max`, `admission_disable_waitlist_move`, `completion`, `parent_course`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '12345', '2560f7c7674942a7dce8eeb238e15d93', 'Test Lehrveranstaltung', 'eine normale Lehrveranstaltung', 1, '', '', '', 1, 1, 1727733600, 0, '', 'für alle Studierenden', 'abgeschlossenes Grundstudium', 'Referate in Gruppenarbeit', 'Klausur', 1343924407, 1716388347, '4', 0, 0, 0, '', 0, 1, 0, NULL, 0, NULL, 0, 0, 0, NULL);
 
 --
 -- Dumping data for table `seminar_cycle_dates`
@@ -227,28 +219,30 @@ REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `vis
 
 --
 -- Dumping data for table `termine`
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('005be9fa51cae40cb7864420ef20cc21', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1700467200, 1700474400, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('04907423f4fecaf2326bde7d595e3fa6', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1706515200, 1706522400, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('0a32d2bb1d24c471fd62d2f542fee471', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1701676800, 1701684000, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('3b74ff2f7ce0964146a90b3d723ee594', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1702281600, 1702288800, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('68985894e2389e16c9922f28bc88447b', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1704700800, 1704708000, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('86de155d92a8f2da7ed6cd8ed9c08d71', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1707991200, 1707996600, 1698856983, 1698856983, 3, '', NULL);
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('8c145ae92eef055db022e79df007af19', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1705305600, 1705312800, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('953ce88c783cbc921f82e41e4af7a6af', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1702886400, 1702893600, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('ab8e1dca6db2eb7dec5a2c99af8338ec', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1699257600, 1699264800, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('afde51cfbc49f0e5fcd8be6bd32cc1d1', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1698652800, 1698660000, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('ba543c308e144270c44406288393c041', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1699862400, 1699869600, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('bb87ee9eb1711bf15d84e3814c1cd4ce', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1707120000, 1707127200, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('dfaef63fdf5d7b7349190b5ae131463e', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1701072000, 1701079200, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('f08b3ef4fe781e7e32d3153832ca5e21', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1698044400, 1698051600, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
-REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('fe11571844e66b495fc12114b48ec161', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1705910400, 1705917600, 1698856934, 1698857418, 1, '', 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('1199f2c43a6ddcd05fd61456e6ac1451', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1736755200, 1736762400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('132eec0a28623f5afde092a6960e45f4', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1736150400, 1736157600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('13bf7a5cd577bcba5bff88d46512baad', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1732521600, 1732528800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('221bb1927fcd93fab3ec7dde7c6b3cce', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1734336000, 1734343200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('4f47c3d25eca9ab8fb2a1644209074ae', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1733126400, 1733133600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('5f87ebde55d5527ceb27ccd6dcd9f66e', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1733731200, 1733738400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('60b4659f960ef05807cbaea6368158aa', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1730707200, 1730714400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('749e52b43a4fe025442f355779489a9d', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1729494000, 1729501200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('7aaa9681da31192e49eaa63a4cef3dfb', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1737360000, 1737367200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('7ec82c654e1b41819cd476ec72e77a76', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1730102400, 1730109600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('86de155d92a8f2da7ed6cd8ed9c08d71', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1739613600, 1739619000, 1698856983, 1716388379, 3, '', NULL);
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('a8f402ada308f68d5f24374923d25580', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1737964800, 1737972000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('be1ad3a4bc5c933d4bfbaa2b313d3ab5', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1738569600, 1738576800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('c729ae36a1503f471a407802e8f72cec', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1731916800, 1731924000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('e8212b6e58109ae94ad2a31796c4a520', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1731312000, 1731319200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
+
 
 --
 -- Daten für Tabelle `ex_termine`
 --
 
-REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('3887db95c939fc701fddc2f906a87287', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1704096000, 1704103200, 1698856934, 1698856934, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
-REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('d1f461421c4357b55bbfd6b16a6d1c81', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1703491200, 1703498400, 1698856934, 1698856934, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
+REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('1bd10ae335fd2c499ad701e49a2b52cb', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1734940800, 1734948000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
+REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('4b4657a993609ac0f7d4a0183507a5a2', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1735545600, 1735552800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
+
 
 --
 -- Daten für Tabelle `user_info`