OpenConext / Stepup-Middleware

/**

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

 */

class Version20150611105956 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 unverified_second_factor DROP FOREIGN KEY FK_D79226A2FF3ED4A8');

        $this->addSql('ALTER TABLE verified_second_factor DROP FOREIGN KEY FK_7964F91CFF3ED4A8');

        $this->addSql('ALTER TABLE vetted_second_factor DROP FOREIGN KEY FK_29F96B72FF3ED4A8');

        $this->addSql('ALTER TABLE unverified_second_factor ADD CONSTRAINT fk_unverified_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

        $this->addSql('ALTER TABLE verified_second_factor ADD CONSTRAINT fk_verified_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

        $this->addSql('ALTER TABLE vetted_second_factor ADD CONSTRAINT fk_vetted_second_factor_identity FOREIGN KEY (identity_id) REFERENCES identity (id) ON DELETE CASCADE');

    }

    /**

     * @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 unverified_second_factor DROP FOREIGN KEY fk_unverified_second_factor_identity');

        $this->addSql('ALTER TABLE verified_second_factor DROP FOREIGN KEY fk_verified_second_factor_identity');

        $this->addSql('ALTER TABLE vetted_second_factor DROP FOREIGN KEY fk_vetted_second_factor_identity');

        $this->addSql('ALTER TABLE unverified_second_factor ADD CONSTRAINT FK_D79226A2FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');

        $this->addSql('ALTER TABLE verified_second_factor ADD CONSTRAINT FK_7964F91CFF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');

        $this->addSql('ALTER TABLE vetted_second_factor ADD CONSTRAINT FK_29F96B72FF3ED4A8 FOREIGN KEY (identity_id) REFERENCES identity (id)');

    }

}

/**

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

 */

class Version20190211163604 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('CREATE INDEX idx_ra_listing_ra_institution ON ra_listing (ra_institution)');

        $this->addSql('CREATE INDEX idx_auditlog_ra_institution ON audit_log (ra_institution)');

        $this->addSql('CREATE INDEX idx_institution ON verified_second_factor (institution)');

        $this->addSql('DROP INDEX id ON ra_candidate');

        $this->addSql('CREATE INDEX idx_ra_institution ON ra_candidate (ra_institution)');

        $this->addSql('CREATE INDEX idx_authorization ON institution_authorization (institution, institution_relation, institution_role)');

    }

    /**

     * @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('DROP INDEX idx_auditlog_ra_institution ON audit_log');

        $this->addSql('DROP INDEX idx_authorization ON institution_authorization');

        $this->addSql('DROP INDEX idx_ra_institution ON ra_candidate');

        $this->addSql('CREATE INDEX id ON ra_candidate (id)');

        $this->addSql('DROP INDEX idx_ra_listing_ra_institution ON ra_listing');

        $this->addSql('DROP INDEX idx_institution ON verified_second_factor');

    }

}