Просмотр файла database/upgrades/20170511144024_delete_values_in_setting.php

<?php

use Phinx\Migration\AbstractMigration;

class DeleteValuesInSetting extends AbstractMigration
{
    /**
     * Migrate Up.
     */
    public function up()
    {
        $this->execute("DELETE FROM setting WHERE name='resmiles' LIMIT 1;");
        $this->execute("DELETE FROM setting WHERE name='editnickpoint' LIMIT 1;");
        $this->execute("DELETE FROM setting WHERE name='includenick' LIMIT 1;");
        $this->execute("DELETE FROM setting WHERE name='regmail' LIMIT 1;");
    }

    /**
     * Migrate Down.
     */
    public function down()
    {
        $this->execute("INSERT INTO setting (name, value) VALUES ('resmiles', 5);");
        $this->execute("INSERT INTO setting (name, value) VALUES ('editnickpoint', 300);");
        $this->execute("INSERT INTO setting (name, value) VALUES ('includenick', 1);");
        $this->execute("INSERT INTO setting (name, value) VALUES ('regmail', 0);");
    }
}