db/migrations/1.311_add_seminare_semester_course_index.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<?php
class AddSeminareSemesterCourseIndex extends Migration
{
    public function description()
    {
        return 'Creates a better performing connection between courses and semesters.';
    }

    public function up()
    {
        DBManager::get()->exec("
            ALTER TABLE `semester_courses`
            ADD KEY `course_id` (`course_id`)
        ");
    }

    public function down()
    {
        DBManager::get()->exec("
            ALTER TABLE `semester_courses`
            DROP KEY `course_id`
        ");
    }
}