|
1
|
|
|
<?php declare(strict_types=1); |
|
2
|
|
|
|
|
3
|
|
|
namespace DoctrineMigrations; |
|
4
|
|
|
|
|
5
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
6
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
7
|
|
|
|
|
8
|
|
|
/** |
|
9
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
10
|
|
|
*/ |
|
11
|
|
View Code Duplication |
final class Version20210325142911 extends AbstractMigration |
|
|
|
|
|
|
12
|
|
|
{ |
|
13
|
|
|
public function up(Schema $schema) : void |
|
14
|
|
|
{ |
|
15
|
|
|
// this up() migration is auto-generated, please modify it to your needs |
|
16
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
17
|
|
|
|
|
18
|
|
|
$this->addSql('ALTER TABLE sylius_product_option_value_translation DROP FOREIGN KEY FK_8D4382DC2C2AC5D3'); |
|
19
|
|
|
$this->addSql('ALTER TABLE sylius_product_variant_option_value DROP FOREIGN KEY FK_76CDAFA1D957CA06'); |
|
20
|
|
|
$this->addSql('CREATE TABLE shop_product_option_value (id INT AUTO_INCREMENT NOT NULL, option_id INT NOT NULL, code VARCHAR(255) NOT NULL, position INT DEFAULT NULL, UNIQUE INDEX UNIQ_4AC5CB0A77153098 (code), INDEX IDX_4AC5CB0AA7C41D6F (option_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB'); |
|
21
|
|
|
$this->addSql('DROP TABLE sylius_product_option_value'); |
|
22
|
|
|
$this->addSql('ALTER TABLE shop_product_option DROP name'); |
|
23
|
|
|
} |
|
24
|
|
|
|
|
25
|
|
|
public function down(Schema $schema) : void |
|
26
|
|
|
{ |
|
27
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
28
|
|
|
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.'); |
|
29
|
|
|
|
|
30
|
|
|
$this->addSql('CREATE TABLE sylius_product_option_value (id INT AUTO_INCREMENT NOT NULL, option_id INT NOT NULL, code VARCHAR(255) CHARACTER SET utf8 NOT NULL COLLATE `utf8_unicode_ci`, INDEX IDX_F7FF7D4BA7C41D6F (option_id), UNIQUE INDEX UNIQ_F7FF7D4B77153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB COMMENT = \'\' '); |
|
31
|
|
|
$this->addSql('ALTER TABLE sylius_product_option_value ADD CONSTRAINT FK_F7FF7D4BA7C41D6F FOREIGN KEY (option_id) REFERENCES shop_product_option (id) ON DELETE CASCADE'); |
|
32
|
|
|
$this->addSql('DROP TABLE shop_product_option_value'); |
|
33
|
|
|
$this->addSql('ALTER TABLE shop_product_option ADD name VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_unicode_ci`'); |
|
34
|
|
|
$this->addSql('ALTER TABLE sylius_product_option_value_translation ADD CONSTRAINT FK_8D4382DC2C2AC5D3 FOREIGN KEY (translatable_id) REFERENCES sylius_product_option_value (id) ON DELETE CASCADE'); |
|
35
|
|
|
$this->addSql('ALTER TABLE sylius_product_variant_option_value ADD CONSTRAINT FK_76CDAFA1D957CA06 FOREIGN KEY (option_value_id) REFERENCES sylius_product_option_value (id) ON DELETE CASCADE'); |
|
36
|
|
|
} |
|
37
|
|
|
} |
|
38
|
|
|
|
enhavo /
enhavo
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.