<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Track the admin who granted a subscription without payment.
 */
final class Version20260809092336 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Add granted_by_user_id to clinic_subscriptions';
    }

    public function up(Schema $schema): void
    {
        $this->addSql('ALTER TABLE clinic_subscriptions ADD granted_by_user_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE clinic_subscriptions ADD CONSTRAINT FK_E4D1CC0FF6097589 FOREIGN KEY (granted_by_user_id) REFERENCES users (id) ON DELETE SET NULL');
        $this->addSql('CREATE INDEX IDX_E4D1CC0FF6097589 ON clinic_subscriptions (granted_by_user_id)');
    }

    public function down(Schema $schema): void
    {
        $this->addSql('ALTER TABLE clinic_subscriptions DROP FOREIGN KEY FK_E4D1CC0FF6097589');
        $this->addSql('DROP INDEX IDX_E4D1CC0FF6097589 ON clinic_subscriptions');
        $this->addSql('ALTER TABLE clinic_subscriptions DROP granted_by_user_id');
    }
}