for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
declare(strict_types=1);
namespace Stu\Migrations\Pgsql;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version20250610150652 extends AbstractMigration
{
public function getDescription(): string
return 'Reset the primary key of crew assignments.';
}
public function up(Schema $schema): void
$this->addSql(<<<'SQL'
DROP INDEX crew_assign_crew_idx
SQL);
ALTER TABLE stu_crew_assign DROP id
ALTER TABLE stu_crew_assign ADD PRIMARY KEY (crew_id)
public function down(Schema $schema): void
DROP INDEX idx_223179_primary
ALTER TABLE stu_crew_assign ADD id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL
CREATE UNIQUE INDEX crew_assign_crew_idx ON stu_crew_assign (crew_id)
ALTER TABLE stu_crew_assign ADD PRIMARY KEY (id)
st-universe /
core
