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
|
<?php
class Step209Teilnehmericon extends Migration
{
function description ()
{
return 'add a new icon to the seminar overview - participants';
}
function up ()
{
// expand the enum in object_user_visits
DBManager::get()->exec("ALTER TABLE `object_user_visits`
CHANGE `type` `type`
ENUM( 'vote', 'documents', 'forum', 'literature', 'schedule', 'scm',
'sem', 'wiki', 'news', 'eval', 'inst', 'ilias_connect',
'elearning_interface', 'participants' ) NOT NULL DEFAULT 'vote'");
// copy timestamps from sem to participants to reduce red participant-icons
DBManager::get()->exec("INSERT INTO object_user_visits
(object_id, user_id, type, visitdate, last_visitdate)
(SELECT object_id, ouv.user_id, 'participants' as type, visitdate, last_visitdate
FROM object_user_visits AS ouv
LEFT JOIN seminar_user AS su ON (su.user_id = ouv.user_id AND su.Seminar_id = ouv.object_id)
WHERE type='sem' AND status IN ('tutor', 'dozent'))");
}
function down ()
{
DBManager::get()->exec("DELETE FROM object_user_visits WHERE type = 'participants'");
DBManager::get()->exec("ALTER TABLE `object_user_visits`
CHANGE `type` `type`
ENUM( 'vote', 'documents', 'forum', 'literature', 'schedule', 'scm',
'sem', 'wiki', 'news', 'eval', 'inst', 'ilias_connect',
'elearning_interface') NOT NULL DEFAULT 'vote'");
}
}
|
