<?php

namespace Application\Migrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

class Version20180315120345 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $extraData = json_encode([
            'parameters' => [
                'option122' => true,
                'remote-id-map' => true,
                'ip' => '127.0.0.1',
            ],
        ]);
        $this->addsql(
            "INSERT INTO dhcpmodel (name, extra_data)
            SELECT * FROM (SELECT 'Kea OS', '{$extraData}') AS tmp
            WHERE NOT EXISTS (
                SELECT name FROM dhcpmodel WHERE name = 'Kea OS'
            ) LIMIT 1;"
        );
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
    }
}