<?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 Version20210812081233 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 assetdisposal (id INT AUTO_INCREMENT NOT NULL, assetregister_id INT NOT NULL, disposaldate DATE NOT NULL, disposalamount DOUBLE PRECISION NOT NULL, sellamount DOUBLE PRECISION DEFAULT NULL, remarks VARCHAR(255) DEFAULT NULL, type INT DEFAULT NULL, status INT DEFAULT NULL, INDEX IDX_417F015CECDCD85C (assetregister_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE assetdisposal ADD CONSTRAINT FK_417F015CECDCD85C FOREIGN KEY (assetregister_id) REFERENCES assetregister (id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('DROP TABLE assetdisposal');
    }
}
