aboutsummaryrefslogtreecommitdiff
path: root/db/migrations/6.0.8_add_max_show_admin_courses_config.php
blob: dbc19297bd2b4f297327e93f131cb18642f26a16 (plain)
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
<?php

final class AddMaxShowAdminCoursesConfig extends Migration
{
    public function description()
    {
        return 'Adds the configuration MAX_SHOW_ADMIN_COURSES, if it doesn\'t exist yet and set a default value.';
    }

    public function up()
    {
        DBManager::get()->exec("INSERT IGNORE INTO `config`
             (`field`, `value`, `type`, `range`, `section`, `mkdate`, `chdate`, `description`)
             VALUES
             (
              'MAX_SHOW_ADMIN_COURSES',
              500,
              'integer',
              'global',
              'MeineVeranstaltungen',
              UNIX_TIMESTAMP(),
              UNIX_TIMESTAMP(),
              'Wie viele Veranstaltungen sollen auf der Admin-Veranstaltungsseite angezeigt werden.'
             )"
        );
    }

    public function down()
    {
        DBManager::get()->exec("DELETE FROM `config_values` WHERE `field` = 'MAX_SHOW_ADMIN_COURSES'");
    }
}