db/migrations/5.1.32_biest_707.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14

<?php

class Biest707 extends Migration
{
    public function description()
    {
        return 'Removes leftover entries of deleted course dates from resource request appointments';
    }
    
    public function up()
    {
        DBManager::get()->exec("DELETE FROM resource_request_appointments WHERE appointment_id NOT IN (SELECT termin_id FROM termine)");
    }
}