<?php


namespace Application\Migrations;


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

class Version20190823104523 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->addSql("INSERT IGNORE INTO vlan_id (id, name, value, tenancy_id, used_by_default) SELECT 1, 'vlanid_data', 10, 1, 1 FROM DUAL WHERE NOT EXISTS(SELECT * FROM vlan_id WHERE id != 1 && id != 2);");
        $this->addSql("INSERT IGNORE INTO vlan_id (id, name, value, tenancy_id, used_by_default) SELECT 2, 'vlanid_voip', 13, 1, 1 FROM DUAL WHERE NOT EXISTS(SELECT * FROM vlan_id WHERE id != 1 && id != 2);");
    }

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