final class Version20240822091021_LotteryWinnerBuildplan extends AbstractMigration
11
{
12
public function getDescription(): string
13
{
14
return 'Adds new entity for ship buildplans that lottery winners get.';
15
}
16
17
public function up(Schema $schema): void
18
{
19
$this->addSql('CREATE TABLE stu_lottery_buildplan (id INT GENERATED BY DEFAULT AS IDENTITY NOT NULL, buildplan_id INT NOT NULL, chance INT NOT NULL, PRIMARY KEY(id))');
20
$this->addSql('CREATE INDEX IDX_E8141D9B8638E4E7 ON stu_lottery_buildplan (buildplan_id)');
21
$this->addSql('ALTER TABLE stu_lottery_buildplan ADD CONSTRAINT FK_E8141D9B8638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplans (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
22
}
23
24
public function down(Schema $schema): void
25
{
26
$this->addSql('ALTER TABLE stu_lottery_buildplan DROP CONSTRAINT FK_E8141D9B8638E4E7');
st-universe /
core
