Passed
Push — master ( a4873d...12e9d6 )
by Nico
37:42
created

Version20240805094517_Location   A

Complexity

Total Complexity 3

Size/Duplication

Total Lines 15
Duplicated Lines 0 %

Test Coverage

Coverage 0%

Importance

Changes 1
Bugs 0 Features 1
Metric Value
eloc 4
c 1
b 0
f 1
dl 0
loc 15
ccs 0
cts 6
cp 0
rs 10
wmc 3

3 Methods

Rating   Name   Duplication   Size   Complexity  
A down() 0 3 1
A up() 0 3 1
A getDescription() 0 3 1
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Stu\Migrations;
6
7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9
10
final class Version20240805094517_Location extends AbstractMigration
11
{
12
    public function getDescription(): string
13
    {
14
        return 'Add index on location entity location_coords_reverse_idx';
15
    }
16
17
    public function up(Schema $schema): void
18
    {
19
        $this->addSql('CREATE INDEX location_coords_reverse_idx ON stu_location (layer_id, cy, cx)');
20
    }
21
22
    public function down(Schema $schema): void
23
    {
24
        $this->addSql('DROP INDEX location_coords_reverse_idx');
25
    }
26
}
27