<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use App\Util\StringGenerator;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20221124220117 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('ALTER TABLE freeswitch.click_to_call ADD token VARCHAR(255) DEFAULT NULL');
foreach ($this->connection->fetchAllAssociative('SELECT id FROM freeswitch.click_to_call') as $clickToCall) {
$this->addSql('UPDATE freeswitch.click_to_call SET token = :token WHERE id = :id', ['token' => StringGenerator::random(32), 'id' => $clickToCall['id']]);
}
$this->addSql('ALTER TABLE freeswitch.click_to_call ALTER token SET NOT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE SCHEMA public');
$this->addSql('ALTER TABLE freeswitch.click_to_call DROP token');
}
}