db/migrations/1.219_loginbackgrounds.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
35
36

<?php

class Loginbackgrounds extends Migration
{
    public function description()
    {
        return 'Add database table for management of login background pictures';
    }

    public function up()
    {
        DBManager::get()->exec("CREATE TABLE IF NOT EXISTS `loginbackgrounds` (
                       `background_id` INT NOT NULL AUTO_INCREMENT,
                       `filename` VARCHAR(255) NOT NULL,
                       `mobile` TINYINT(1) NOT NULL DEFAULT 1,
                       `desktop` TINYINT(1) NOT NULL DEFAULT 1,
                       `in_release` TINYINT(1) NOT NULL DEFAULT 0,
                       PRIMARY KEY (`background_id`)
                   ) ENGINE=InnoDB ROW_FORMAT=DYNAMIC");

        DBManager::get()->exec(
            "INSERT INTO `loginbackgrounds` SET `filename` = 'Login-Hintergrund.jpg', ".
            "`mobile` = 0, `desktop` = 1, `in_release` = 1");

        DBManager::get()->exec(
            "INSERT INTO `loginbackgrounds` SET `filename` = 'Login-Hintergrund-mobil.jpg', ".
            "`mobile` = 1, `desktop` = 0, `in_release` = 1");

        mkdir($GLOBALS['STUDIP_BASE_PATH'] . '/public/pictures/loginbackgrounds');
    }

    public function down()
    {
        DBManager::get()->exec('DROP TABLE IF EXISTS `loginbackgrounds`');
    }
}