db/migrations/5.1.53_cleanup_cw_tasks.php


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

<?php

final class CleanupCwTasks extends Migration
{
    public function description()
    {
        return 'deletes unlinked entries';
    }

    public function up()
    {
        DBManager::get()->exec('
            DELETE FROM `cw_tasks`
            WHERE `solver_type` = "autor"
              AND `solver_id` NOT IN (SELECT `user_id` FROM `auth_user_md5`)'
        );
        DBManager::get()->exec('
            DELETE FROM `cw_tasks`
            WHERE `solver_type` = "group"
               AND `solver_id` NOT IN (SELECT `statusgruppe_id` FROM `statusgruppen`)'
        );
    }
}