diff options
| -rw-r--r-- | db/migrations/5.5.34_remove_table_wiki_links.php | 25 | ||||
| -rw-r--r-- | lib/classes/Seminar.class.php | 4 |
2 files changed, 25 insertions, 4 deletions
diff --git a/db/migrations/5.5.34_remove_table_wiki_links.php b/db/migrations/5.5.34_remove_table_wiki_links.php new file mode 100644 index 0000000..961a5b4 --- /dev/null +++ b/db/migrations/5.5.34_remove_table_wiki_links.php @@ -0,0 +1,25 @@ +<?php +final class RemoveTableWikiLinks extends Migration +{ + public function description() + { + return 'Removes the table "wiki_links"'; + } + + protected function up() + { + $query = "DROP TABLE `wiki_links`"; + DBManager::get()->exec($query); + } + + protected function down() + { + $query = "CREATE TABLE `wiki_links` ( + `range_id` CHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '', + `from_page_id` INT(10) UNSIGNED NOT NULL, + `to_page_id` INT(10) UNSIGNED NOT NULL, + PRIMARY KEY (`range_id`,`to_page_id`,`from_page_id`) + )"; + DBManager::get()->exec($query); + } +} diff --git a/lib/classes/Seminar.class.php b/lib/classes/Seminar.class.php index d9455d3..7c944ab 100644 --- a/lib/classes/Seminar.class.php +++ b/lib/classes/Seminar.class.php @@ -1608,10 +1608,6 @@ class Seminar $this->createMessage(sprintf(_("%s Wiki-Seiten archiviert."), $db_wiki)); } - $query = "DELETE FROM wiki_links WHERE range_id = ?"; - $statement = DBManager::get()->prepare($query); - $statement->execute([$s_id]); - // delete course config values ConfigValue::deleteBySQL('range_id = ?', [$s_id]); |