Gecko [ unitednationsplay.com ]

Name	Size	Permission	Date
.gitignore	0 B	-rw-rw-r--	2022-08-25 15:07
Version20220831121635.php	2.49 KB	-rw-rw-rw-	2022-08-31 12:16
Version20220906143602.php	3.2 KB	-rw-rw-rw-	2022-09-06 14:38
Version20220908125743.php	1.19 KB	-rw-rw-rw-	2022-09-08 13:30
Version20220909103932.php	1.74 KB	-rw-rw-rw-	2022-09-09 10:40
Version20220909105115.php	836 B	-rw-rw-rw-	2022-09-09 10:51
Version20220909111355.php	1003 B	-rw-rw-rw-	2022-09-09 11:14
Version20220909122548.php	1.14 KB	-rw-rw-rw-	2022-09-09 12:26
Version20220913072927.php	1.42 KB	-rw-rw-rw-	2022-09-13 07:31
Version20220916094859.php	2.19 KB	-rw-rw-rw-	2022-09-16 09:49

Rename

<?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 Version20220909103932 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 words_list (id INT AUTO_INCREMENT NOT NULL, project_id INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, words LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_B7304688166D1F9C (project_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE words_list ADD CONSTRAINT FK_B7304688166D1F9C FOREIGN KEY (project_id) REFERENCES projects (id)');
        $this->addSql('ALTER TABLE words ADD words_list_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE words ADD CONSTRAINT FK_717D1E8C99D5790 FOREIGN KEY (words_list_id) REFERENCES words_list (id)');
        $this->addSql('CREATE INDEX IDX_717D1E8C99D5790 ON words (words_list_id)');
    }

public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE words DROP FOREIGN KEY FK_717D1E8C99D5790');
        $this->addSql('ALTER TABLE words_list DROP FOREIGN KEY FK_B7304688166D1F9C');
        $this->addSql('DROP TABLE words_list');
        $this->addSql('DROP INDEX IDX_717D1E8C99D5790 ON words');
        $this->addSql('ALTER TABLE words DROP words_list_id');
    }
}