Stu\Migrations\Pgsql\Version20241010152457_UniqueBuildplanSignatures

Complexity

Total Complexity

3

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Importance

Changes

0

<?php
final class Version20241010152457_UniqueBuildplanSignatures extends AbstractMigration
{
    #[Override]
    public function getDescription(): string
    {
        return 'Creates unique constraint for buildplan signatures.';
    }

    #[Override]
    public function up(Schema $schema): void
    {
        $this->addSql('CREATE UNIQUE INDEX buildplan_signatures_idx ON stu_buildplans (user_id, rump_id, signature)');
    }

    #[Override]
    public function down(Schema $schema): void
    {
        $this->addSql('DROP INDEX buildplan_signatures_idx');
    }