OpenConext / Stepup-Middleware

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20141031164140 extends AbstractMigration

{

    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 event_stream CHANGE type type varchar(255)");

        $this->addSql("ALTER TABLE event_stream DROP INDEX unique_playhead");

        $this->addSql("ALTER TABLE event_stream ADD INDEX type (type)");

        $this->addSql("ALTER TABLE event_stream ADD UNIQUE INDEX unique_uuid_playhead (uuid, playhead)");

    }

    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 event_stream CHANGE type type varchar(150)");

        $this->addSql("ALTER TABLE event_stream DROP INDEX type");

        $this->addSql("ALTER TABLE event_stream DROP INDEX unique_uuid_playhead");

        $this->addSql("ALTER TABLE event_stream ADD INDEX unique_playhead (playhead)");

    }

}

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20150305114932 extends AbstractMigration

{

    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 INDEX idx_ra_second_factor_type ON ra_second_factor');

        $this->addSql('DROP INDEX idx_ra_second_factor_status ON ra_second_factor');

        $this->addSql('DROP INDEX idx_ra_second_factor_name ON ra_second_factor');

        $this->addSql('DROP INDEX idx_ra_second_factor_email ON ra_second_factor');

    }

    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 INDEX idx_ra_second_factor_type ON ra_second_factor (type)');

        $this->addSql('CREATE INDEX idx_ra_second_factor_status ON ra_second_factor (status)');

        $this->addSql('CREATE INDEX idx_ra_second_factor_name ON ra_second_factor (name)');

        $this->addSql('CREATE INDEX idx_ra_second_factor_email ON ra_second_factor (email)');

    }

}

/**

 * Auto-generated Migration: Please modify to your needs!

 */

class Version20150312134629 extends AbstractMigration

{

    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 ra_second_factor CHANGE second_factor_id second_factor_id VARCHAR(255) NOT NULL');

        $this->addSql('ALTER TABLE verified_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(255) NOT NULL');

        $this->addSql('ALTER TABLE unverified_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(255) NOT NULL');

        $this->addSql('ALTER TABLE vetted_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(255) NOT NULL');

    }

    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 ra_second_factor CHANGE second_factor_id second_factor_id VARCHAR(36) NOT NULL COLLATE utf8_unicode_ci');

        $this->addSql('ALTER TABLE unverified_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci');

        $this->addSql('ALTER TABLE verified_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci');

        $this->addSql('ALTER TABLE vetted_second_factor CHANGE second_factor_identifier second_factor_identifier VARCHAR(32) NOT NULL COLLATE utf8_unicode_ci');

    }

}