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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
<?php
/**
* Feedback Elements for Stud.IP.
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU Affero General Public License
* version 3 as published by the Free Software Foundation.
*
* @author Nils Gehrke <nils.gehrke@uni-goettingen.de>
* @license https://www.gnu.org/licenses/agpl-3.0.html AGPL version 3
*/
class Step00333Feedback extends Migration
{
public function description()
{
return 'initial database setup for feedback elements';
}
public function up()
{
$db = DBManager::get();
$db->exec("CREATE TABLE IF NOT EXISTS `feedback` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(32) COLLATE latin1_bin NOT NULL,
`range_id` varchar(32) COLLATE latin1_bin NOT NULL,
`range_type` varchar(32) COLLATE latin1_bin NOT NULL,
`course_id` varchar(32) COLLATE latin1_bin NOT NULL,
`question` text COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`mode` int(11) UNSIGNED NOT NULL,
`results_visible` tinyint(4) UNSIGNED NOT NULL,
`commentable` tinyint(4) UNSIGNED NOT NULL,
`mkdate` int(11) UNSIGNED NOT NULL,
`chdate` int(11) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
INDEX `idx_range` (`range_id`,`range_type`),
KEY `course_id` (`course_id`)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC");
$db->exec("CREATE TABLE IF NOT EXISTS `feedback_entries` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`feedback_id` int(11) UNSIGNED NOT NULL,
`user_id` varchar(32) COLLATE latin1_bin NOT NULL,
`comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
`rating` tinyint(3) UNSIGNED NOT NULL,
`mkdate` int(10) UNSIGNED NOT NULL,
`chdate` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
KEY `feedback_id` (`feedback_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC");
// install as core plugin
$db->exec(
"INSERT INTO plugins (pluginclassname, pluginname, plugintype, enabled, navigationpos)
VALUES ('FeedbackModule', 'Feedback','StandardPlugin,SystemPlugin','yes', 1)"
);
$db->execute(
"INSERT INTO roles_plugins (roleid, pluginid)
SELECT roleid, ?
FROM roles
WHERE `system` = 'y'",
[$db->lastInsertId()]
);
// install config settings
$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' => 'FEEDBACK_ADMIN_PERM',
'description' => 'Voreinstellung für Berechtigungslevel, um Einstellung zu Feedback-Elementen zu verwalten',
'range' => 'course',
'type' => 'string',
'value' => 'tutor'
]);
$stmt->execute([
'name' => 'FEEDBACK_CREATE_PERM',
'description' => 'Voreinstellung für Berechtigungslevel, um Feedback-Elemente anzulegen.',
'range' => 'course',
'type' => 'string',
'value' => 'tutor'
]);
SimpleORMap::expireTableScheme();
}
public function down()
{
$db = DBManager::get();
$db->exec('DROP TABLE feedback_entries');
$db->exec('DROP TABLE feedback');
$db->exec(
"DELETE plugins, roles_plugins
FROM plugins LEFT JOIN roles_plugins USING(pluginid)
WHERE pluginclassname = 'FeedbackModule'"
);
SimpleORMap::expireTableScheme();
}
}
|
