|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace SWP\Migrations; |
|
6
|
|
|
|
|
7
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
8
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
9
|
|
|
|
|
10
|
|
|
/** |
|
11
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
12
|
|
|
*/ |
|
13
|
|
View Code Duplication |
final class Version20180808094029 extends AbstractMigration |
|
|
|
|
|
|
14
|
|
|
{ |
|
15
|
|
|
public function up(Schema $schema): void |
|
16
|
|
|
{ |
|
17
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
18
|
|
|
$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
|
19
|
|
|
|
|
20
|
|
|
$this->addSql('CREATE INDEX swp_status_route ON swp_article (status, route_id)'); |
|
21
|
|
|
$this->addSql('CREATE INDEX swp_deleted_tenant ON swp_article (deleted_at, tenant_code)'); |
|
22
|
|
|
$this->addSql('CREATE INDEX swp_status_deleted_route_tenant ON swp_article ( |
|
23
|
|
|
status, tenant_code, deleted_at, route_id |
|
24
|
|
|
)'); |
|
25
|
|
|
$this->addSql('CREATE INDEX swp_deleted_at ON swp_article (deleted_at)'); |
|
26
|
|
|
$this->addSql('CREATE INDEX swp_count_route ON swp_article (deleted_at, status, tenant_code)'); |
|
27
|
|
|
$this->addSql('CREATE INDEX swp_external_deleted_tenant ON swp_article_external (deleted_at, tenant_code)'); |
|
28
|
|
|
} |
|
29
|
|
|
|
|
30
|
|
|
public function down(Schema $schema): void |
|
31
|
|
|
{ |
|
32
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
33
|
|
|
$this->abortIf('postgresql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'postgresql\'.'); |
|
34
|
|
|
|
|
35
|
|
|
$this->addSql('DROP INDEX swp_status_route'); |
|
36
|
|
|
$this->addSql('DROP INDEX swp_deleted_tenant'); |
|
37
|
|
|
$this->addSql('DROP INDEX swp_status_deleted_route_tenant'); |
|
38
|
|
|
$this->addSql('DROP INDEX swp_deleted_at'); |
|
39
|
|
|
$this->addSql('DROP INDEX swp_count_route'); |
|
40
|
|
|
$this->addSql('DROP INDEX swp_external_deleted_tenant'); |
|
41
|
|
|
} |
|
42
|
|
|
} |
|
43
|
|
|
|
ahilles107 /
web-publisher
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.