final class Version20200825104739 extends AbstractMigration
11
{
12
public function getDescription(): string
13
{
14
return '';
15
}
16
17
public function up(Schema $schema): void
18
{
19
// this up() migration is auto-generated, please modify it to your needs
20
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
21
22
$this->addSql('CREATE TABLE bitbag_mollie_product_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_FCC472585E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE `UTF8_unicode_ci` ENGINE = InnoDB');
23
$this->addSql('ALTER TABLE sylius_product ADD product_type_id INT DEFAULT NULL');
24
$this->addSql('ALTER TABLE sylius_product ADD CONSTRAINT FK_677B9B7414959723 FOREIGN KEY (product_type_id) REFERENCES bitbag_mollie_product_type (id) ON DELETE SET NULL');
25
$this->addSql('CREATE INDEX IDX_677B9B7414959723 ON sylius_product (product_type_id)');
26
}
27
28
public function down(Schema $schema): void
29
{
30
// this down() migration is auto-generated, please modify it to your needs
31
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
32
33
$this->addSql('ALTER TABLE sylius_product DROP FOREIGN KEY FK_677B9B7414959723');
BitBagCommerce /
SyliusMolliePlugin
