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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<?php
class Step00198Deputies extends Migration
{
static $config_entries = [
// Do users with status "dozent" always have to be visible?
[
'name' => 'DEPUTIES_ENABLE',
'type' => 'boolean',
'value' => 0,
'description' => 'Legt fest, ob die Funktion Vertretung aktiviert ist.'
],
[
'name' => 'DEPUTIES_DEFAULTENTRY_ENABLE',
'type' => 'boolean',
'value' => 0,
'description' => 'Dürfen Lehrende Standardvertretungen festlegen? Diese werden automatisch bei Hinzufügen der Lehrenden als Vertretung in Veranstaltungen eingetragen.'
],
[
'name' => 'DEPUTIES_EDIT_ABOUT_ENABLE',
'type' => 'boolean',
'value' => 1,
'description' => 'Dürfen Lehrende ihren Standardvertretungen erlauben, ihr Profil zu bearbeiten?'
]
];
function description()
{
return 'deputies';
}
function up()
{
$db = DBManager::get();
$query = $db->prepare("INSERT IGNORE INTO `config` ".
"(`config_id`, `parent_id`, `field`, `value`, `is_default`, ".
"`type`, `range`, `section`, `position`, `mkdate`, `chdate`, ".
"`description`, `comment`, `message_template`)
VALUES (MD5(?), '', ?, ?, '1', ?, 'global', 'deputies', '0', ".
"UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), ?, '', '')");
// insert new configuration entries
foreach (self::$config_entries as $entry) {
$query->execute([$entry['name'], $entry['name'], $entry['value'], $entry['type'], $entry['description']]);
}
$db->exec("CREATE TABLE `deputies` ( ".
"`range_id` VARCHAR(32) NOT NULL, ".
"`user_id` VARCHAR(32) NOT NULL, ".
"`gruppe` TINYINT(4) NOT NULL DEFAULT 0, ".
"`notification` INT(10) NOT NULL DEFAULT 0, ".
"`edit_about` TINYINT(1) NOT NULL DEFAULT 0, ".
"PRIMARY KEY (`range_id`, `user_id`)) ENGINE=MyISAM");
}
function down()
{
$db = DBManager::get();
$db->exec("DROP TABLE `deputies`");
}
}
|
