db/migrations/5.1.29_add_index_resource_booking_intervals.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
25
26
27
28
29
30
31
32
33
34

<?php

class AddIndexResourceBookingIntervals extends Migration
{
    use DatabaseMigrationTrait;

    public function description()
    {
        return 'add index for booking_id to resource_booking_intervals';
    }

    public function up()
    {
        // avoid running this migration twice
        if ($this->keyExists('resource_booking_intervals', 'booking_id')) {
            return;
        }

        // index "assign_object_id" may not exist (depending on upgrade path)
        if ($this->keyExists('resource_booking_intervals', 'assign_object_id')) {
            $sql = "ALTER TABLE resource_booking_intervals DROP INDEX assign_object_id";
            DBManager::get()->exec($sql);
        }

        $sql = "ALTER TABLE resource_booking_intervals ADD INDEX booking_id (booking_id)";
        DBManager::get()->exec($sql);
    }

    public function down()
    {
        $query = "ALTER TABLE resource_booking_intervals DROP INDEX booking_id";
        DBManager::get()->exec($query);
    }
}