<?php
/* For licensing terms, see /license.txt */

namespace Application\Migrations\Schema\V110;

use Application\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

/**
 * Session date changes
 */
class Version20150616093200 extends AbstractMigrationChamilo
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->addSql("INSERT INTO extra_field (
            extra_field_type, field_type, variable, display_text, visible, changeable, created_at)
            VALUES (2, 19, 'video_url', 'VideoUrl', 1, 1, NOW())");
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->addSql("DELETE FROM extra_field
            WHERE variable = 'video_url' AND
                extra_field_type = 2 AND
                field_type = 19");
    }

}