<commit_before><?php

namespace Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160604193155 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('DROP TABLE settings');
        $this->addSql('ALTER TABLE zone ADD active TINYINT(1) NOT NULL DEFAULT "1", CHANGE relay relay SMALLINT NOT NULL, CHANGE image image SMALLINT NOT NULL');
        $this->addSql('ALTER TABLE zone RENAME INDEX relay TO UNIQ_A0EBC0075D3AE2B9');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('CREATE TABLE settings (setting VARCHAR(40) NOT NULL COLLATE latin1_swedish_ci, value VARCHAR(40) NOT NULL COLLATE latin1_swedish_ci, UNIQUE INDEX `key` (setting)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
        $this->addSql('ALTER TABLE zone DROP active, CHANGE relay relay TINYINT(1) NOT NULL, CHANGE image image TINYINT(1) NOT NULL');
        $this->addSql('ALTER TABLE zone RENAME INDEX uniq_a0ebc0075d3ae2b9 TO relay');
    }
}<commit_msg>Fixed migration to link up local settings.<commit_after><?php

namespace Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20160604193155 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE zone ADD active TINYINT(1) NOT NULL DEFAULT "1", CHANGE relay relay SMALLINT NOT NULL, CHANGE image image SMALLINT NOT NULL');
        $this->addSql('ALTER TABLE zone RENAME INDEX relay TO UNIQ_A0EBC0075D3AE2B9');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE zone DROP active, CHANGE relay relay TINYINT(1) NOT NULL, CHANGE image image TINYINT(1) NOT NULL');
        $this->addSql('ALTER TABLE zone RENAME INDEX uniq_a0ebc0075d3ae2b9 TO relay');
    }
}
{'fraction_non_alphanumeric': 0.11621187800963081, 'fraction_numerical': 0.024398073836276082, 'mean_word_length': 3.616296296296296, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 29, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '521902', 'n_tokens_mistral': 967, 'n_tokens_neox': 918, 'n_words': 294}