<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20241006051951 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE TABLE notify_template (id INT AUTO_INCREMENT NOT NULL, notify_type VARCHAR(255) NOT NULL, template LONGTEXT NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE UNIQUE INDEX notify_type ON notify_template (notify_type)');
$this->addSql('ALTER TABLE notify_template ADD default_transport VARCHAR(255) NOT NULL');
$this->addSql('ALTER TABLE gift_card_order ADD to_phone VARCHAR(255) NOT NULL');
$this->addSql("INSERT INTO `notify_template` VALUES (1, 'epkSender', 'Спасибо, что приобрели сертификат! Доставим его в указанное время', '2024-10-06 10:38:01', '2024-10-12 07:43:47', 'sms');");
$this->addSql("INSERT INTO `notify_template` VALUES (2, 'epkReceiver', 'На почту:[email] доставлен сертификат Перина Перони', '2024-10-06 10:38:01', '2024-10-12 07:43:51', 'sms');");
$this->addSql("INSERT INTO `notify_template` VALUES (3, 'authCode', 'Ваш код: [code] Используйте для входа на perina-peroni.ru', '2024-10-06 10:38:01', '2024-10-12 07:43:51', 'sms');");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('DROP TABLE notify_template');
}
}