migrations/Version20220618175049.php line 1

<?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 Version20220618175049 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Start migration 18.06.2022';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE TABLE announcement (id INT AUTO_INCREMENT NOT NULL, lang VARCHAR(3) NOT NULL, title VARCHAR(255) NOT NULL, short LONGTEXT DEFAULT NULL, content LONGTEXT DEFAULT NULL, category VARCHAR(30) NOT NULL, flag VARCHAR(30) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE api_token (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, token VARCHAR(255) NOT NULL, INDEX IDX_7BA2F5EBA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE bank (id INT AUTO_INCREMENT NOT NULL, code VARCHAR(30) NOT NULL, name VARCHAR(255) NOT NULL, street VARCHAR(255) NOT NULL, city VARCHAR(50) NOT NULL, postcode VARCHAR(10) NOT NULL, division VARCHAR(255) DEFAULT NULL, swift VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE course (id INT AUTO_INCREMENT NOT NULL, currency VARCHAR(100) NOT NULL, code VARCHAR(10) NOT NULL, source VARCHAR(255) NOT NULL, exchange_currency VARCHAR(100) NOT NULL, exchange_code VARCHAR(10) NOT NULL, exchange_date DATE NOT NULL, exchange_value NUMERIC(10, 4) NOT NULL, rate_no VARCHAR(100) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE valorization (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, dt DATE NOT NULL, amount NUMERIC(12, 4) NOT NULL, comment LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE api_token ADD CONSTRAINT FK_7BA2F5EBA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');

        // default user: admin@rezone.app / admin1 - change after migration!!!
        $this->addSql('INSERT INTO `user` (`id`, `email`, `roles`, `password`) VALUES(1, \'admin@rezone.app\', \'[\"ROLE_ADMIN\"]\', \'$2y$13$yIPNKNw7YvVrdxMcbA78YOWsMcwOR.s9fF7ie67SEUvN7UhzNfzQq\')');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE api_token DROP FOREIGN KEY FK_7BA2F5EBA76ED395');
        $this->addSql('DROP TABLE announcement');
        $this->addSql('DROP TABLE api_token');
        $this->addSql('DROP TABLE bank');
        $this->addSql('DROP TABLE course');
        $this->addSql('DROP TABLE user');
        $this->addSql('DROP TABLE valorization');
    }
}