SWP\Migrations\Version20190709090034::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines

22

Duplication

Lines	22
Ratio	100 %

Importance

Changes

0

<?php
    public function up(Schema $schema): void
    {
        $this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.');

        $this->addSql('DROP INDEX swp_article_slug_idx');
        $this->addSql('
            CREATE UNIQUE INDEX swp_article_slug_not_null_deleted_at_idx 
            ON swp_article (
              slug, tenant_code, organization_id, 
              deleted_at
            ) 
            WHERE deleted_at IS NOT NULL
        ');

        $this->addSql('
            CREATE UNIQUE INDEX swp_article_slug_null_deleted_at_idx 
            ON swp_article (
              slug, tenant_code, organization_id
            ) 
            WHERE deleted_at IS NULL
        ');
    }