* Auto-generated Migration: Please modify to your needs!
12
*/
13
final class Version20200825104739 extends AbstractMigration
14
{
15
public function getDescription() : string
16
{
17
return '';
18
}
19
20
public function up(Schema $schema) : void
21
{
22
// this up() migration is auto-generated, please modify it to your needs
23
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
24
25
$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');
26
$this->addSql('ALTER TABLE sylius_product ADD product_type_id INT DEFAULT NULL');
27
$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');
28
$this->addSql('CREATE INDEX IDX_677B9B7414959723 ON sylius_product (product_type_id)');
29
}
30
31
public function down(Schema $schema) : void
32
{
33
// this down() migration is auto-generated, please modify it to your needs
34
$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
35
36
$this->addSql('ALTER TABLE sylius_product DROP FOREIGN KEY FK_677B9B7414959723');
BitBagCommerce /
SyliusMolliePlugin
