1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
<?php
class ConfigPublicTopics extends Migration
{
public function description()
{
return 'migrate seminare.public_topics to config';
}
public function up()
{
$db = DBManager::get();
// migrate setting from seminare.public_topics
$stmt = $db->prepare('INSERT INTO config (field, value, type, `range`, mkdate, chdate, description)
VALUES (:name, :value, :type, :range, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), :description)');
$stmt->execute([
'name' => 'COURSE_PUBLIC_TOPICS',
'description' => 'Über diese Option können Sie die Themen einer Veranstaltung öffentlich einsehbar machen.',
'range' => 'course',
'type' => 'boolean',
'value' => '0'
]);
$db->exec("INSERT INTO config_values (field, range_id, value, mkdate, chdate, comment)
SELECT 'COURSE_PUBLIC_TOPICS', Seminar_id, public_topics, mkdate, chdate, ''
FROM seminare WHERE public_topics = 1");
$db->exec('ALTER TABLE seminare DROP public_topics');
}
public function down()
{
$db = DBManager::get();
// migrate setting to seminare.public_topics
$db->exec('ALTER TABLE seminare ADD public_topics tinyint(1) unsigned NOT NULL DEFAULT 0 AFTER completion');
$db->exec("UPDATE config_values JOIN seminare ON range_id = Seminar_id
SET public_topics = value WHERE field = 'COURSE_PUBLIC_TOPICS'");
$db->exec("DELETE config, config_values FROM config LEFT JOIN config_values USING(field)
WHERE field = 'COURSE_PUBLIC_TOPICS'");
}
}
|
