1234567891011121314151617181920212223242526272829303132333435 |
- <?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 Version20250803064511 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 party ADD submitter_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', ADD submitted_date DATETIME DEFAULT NULL, ADD validated TINYINT(1) DEFAULT NULL');
- $this->addSql('ALTER TABLE party ADD CONSTRAINT FK_89954EE0919E5513 FOREIGN KEY (submitter_id) REFERENCES user (id)');
- $this->addSql('CREATE INDEX IDX_89954EE0919E5513 ON party (submitter_id)');
- }
- public function down(Schema $schema): void
- {
- // this down() migration is auto-generated, please modify it to your needs
- $this->addSql('ALTER TABLE party DROP FOREIGN KEY FK_89954EE0919E5513');
- $this->addSql('DROP INDEX IDX_89954EE0919E5513 ON party');
- $this->addSql('ALTER TABLE party DROP submitter_id, DROP submitted_date, DROP validated');
- }
- }
|