Gecko [ 35.178.45.201 ]

Name	Size	Permission
Version20200707084657.php	5.05 KB	-rw-rw-r--
console	1.26 KB	-rwxrwxr-x
phpunit	426 B	-rwxrwxr-x

Code Editor : Version20200707084657.php

<?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 Version20200707084657 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 cargo (id INT AUTO_INCREMENT NOT NULL, cargoname VARCHAR(255) DEFAULT NULL, seller VARCHAR(255) DEFAULT NULL, product VARCHAR(255) NOT NULL, quantity INT DEFAULT NULL, initial INT DEFAULT NULL, date DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE loading (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, truck VARCHAR(255) NOT NULL, quantity INT NOT NULL, date VARCHAR(255) DEFAULT NULL, dates DATETIME DEFAULT NULL, waybill INT DEFAULT NULL, details VARCHAR(255) DEFAULT NULL, releaseId INT DEFAULT NULL, INDEX IDX_576038B44CD8E013 (releaseId), INDEX IDX_576038B4A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE release_order (id INT AUTO_INCREMENT NOT NULL, signoneid_id INT DEFAULT NULL, signtwoid_id INT DEFAULT NULL, signthreeid_id INT DEFAULT NULL, user_id INT DEFAULT NULL, customer VARCHAR(255) NOT NULL, quantity INT NOT NULL, date VARCHAR(255) NOT NULL, dates DATETIME DEFAULT NULL, bank VARCHAR(255) DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, depot VARCHAR(255) DEFAULT NULL, signone VARCHAR(255) DEFAULT NULL, signtwo VARCHAR(255) DEFAULT NULL, signthree VARCHAR(255) DEFAULT NULL, is_loaded TINYINT(1) DEFAULT NULL, cargoId INT DEFAULT NULL, INDEX IDX_76B7E1EFE996F4FC (cargoId), INDEX IDX_76B7E1EF971F0AE5 (signoneid_id), INDEX IDX_76B7E1EFE513DDE3 (signtwoid_id), INDEX IDX_76B7E1EF5E060304 (signthreeid_id), INDEX IDX_76B7E1EFA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE subcargo (id INT AUTO_INCREMENT NOT NULL, quantity INT NOT NULL, total INT DEFAULT NULL, date VARCHAR(255) NOT NULL, cargoId INT DEFAULT NULL, INDEX IDX_415DB8ABE996F4FC (cargoId), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(180) NOT NULL, password VARCHAR(255) NOT NULL, roles JSON NOT NULL, role VARCHAR(20) NOT NULL, name VARCHAR(255) DEFAULT NULL, reset VARCHAR(255) DEFAULT NULL, enabled TINYINT(1) DEFAULT NULL, verification VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, telephone VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE loading ADD CONSTRAINT FK_576038B44CD8E013 FOREIGN KEY (releaseId) REFERENCES release_order (id)');
        $this->addSql('ALTER TABLE loading ADD CONSTRAINT FK_576038B4A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE release_order ADD CONSTRAINT FK_76B7E1EFE996F4FC FOREIGN KEY (cargoId) REFERENCES cargo (id)');
        $this->addSql('ALTER TABLE release_order ADD CONSTRAINT FK_76B7E1EF971F0AE5 FOREIGN KEY (signoneid_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE release_order ADD CONSTRAINT FK_76B7E1EFE513DDE3 FOREIGN KEY (signtwoid_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE release_order ADD CONSTRAINT FK_76B7E1EF5E060304 FOREIGN KEY (signthreeid_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE release_order ADD CONSTRAINT FK_76B7E1EFA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE subcargo ADD CONSTRAINT FK_415DB8ABE996F4FC FOREIGN KEY (cargoId) REFERENCES cargo (id)');
    }

public function down(Schema $schema) : void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE release_order DROP FOREIGN KEY FK_76B7E1EFE996F4FC');
        $this->addSql('ALTER TABLE subcargo DROP FOREIGN KEY FK_415DB8ABE996F4FC');
        $this->addSql('ALTER TABLE loading DROP FOREIGN KEY FK_576038B44CD8E013');
        $this->addSql('ALTER TABLE loading DROP FOREIGN KEY FK_576038B4A76ED395');
        $this->addSql('ALTER TABLE release_order DROP FOREIGN KEY FK_76B7E1EF971F0AE5');
        $this->addSql('ALTER TABLE release_order DROP FOREIGN KEY FK_76B7E1EFE513DDE3');
        $this->addSql('ALTER TABLE release_order DROP FOREIGN KEY FK_76B7E1EF5E060304');
        $this->addSql('ALTER TABLE release_order DROP FOREIGN KEY FK_76B7E1EFA76ED395');
        $this->addSql('DROP TABLE cargo');
        $this->addSql('DROP TABLE loading');
        $this->addSql('DROP TABLE release_order');
        $this->addSql('DROP TABLE subcargo');
        $this->addSql('DROP TABLE user');
    }
}

${this.title}

Code Editor : Version20200707084657.php