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 Version20220906143602 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 faq (id INT AUTO_INCREMENT NOT NULL, sort INT DEFAULT NULL, question LONGTEXT DEFAULT NULL, answer LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE projects (id INT AUTO_INCREMENT NOT NULL, region_id INT DEFAULT NULL, zone_id INT DEFAULT NULL, user_id INT DEFAULT NULL, sort INT DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_5C93B3A498260155 (region_id), INDEX IDX_5C93B3A49F2C3FAB (zone_id), INDEX IDX_5C93B3A4A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE region (id INT AUTO_INCREMENT NOT NULL, sort INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE support (id INT AUTO_INCREMENT NOT NULL, sort INT DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, question LONGTEXT DEFAULT NULL, answer LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE zone (id INT AUTO_INCREMENT NOT NULL, sort INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE projects ADD CONSTRAINT FK_5C93B3A498260155 FOREIGN KEY (region_id) REFERENCES region (id)');
        $this->addSql('ALTER TABLE projects ADD CONSTRAINT FK_5C93B3A49F2C3FAB FOREIGN KEY (zone_id) REFERENCES zone (id)');
        $this->addSql('ALTER TABLE projects ADD CONSTRAINT FK_5C93B3A4A76ED395 FOREIGN KEY (user_id) REFERENCES fos_user (id)');
    }

public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE projects DROP FOREIGN KEY FK_5C93B3A498260155');
        $this->addSql('ALTER TABLE projects DROP FOREIGN KEY FK_5C93B3A49F2C3FAB');
        $this->addSql('ALTER TABLE projects DROP FOREIGN KEY FK_5C93B3A4A76ED395');
        $this->addSql('DROP TABLE faq');
        $this->addSql('DROP TABLE projects');
        $this->addSql('DROP TABLE region');
        $this->addSql('DROP TABLE support');
        $this->addSql('DROP TABLE zone');
    }
}