migrations/Version20220215142649.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 Version20220215142649 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 address (id INT AUTO_INCREMENT NOT NULL, street VARCHAR(255) DEFAULT NULL, zip VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, place_id VARCHAR(255) DEFAULT NULL, latitude NUMERIC(20, 16) DEFAULT NULL, longitude NUMERIC(20, 16) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE conversation (id INT AUTO_INCREMENT NOT NULL, customer_request_id INT NOT NULL, employee_id INT DEFAULT NULL, date DATETIME NOT NULL, content LONGTEXT NOT NULL, INDEX IDX_8A8E26E9BFB7BC27 (customer_request_id), INDEX IDX_8A8E26E98C03F15C (employee_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE customer_request (id INT AUTO_INCREMENT NOT NULL, accepted_by_id INT DEFAULT NULL, processed_by_id INT DEFAULT NULL, address_id INT DEFAULT NULL, created DATETIME NOT NULL, processed TINYINT(1) DEFAULT 0 NOT NULL, processed_at DATETIME DEFAULT NULL, request_type VARCHAR(255) DEFAULT NULL, building_type VARCHAR(255) DEFAULT NULL, roof_types TINYTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', custom_roof VARCHAR(255) DEFAULT NULL, img_custom_roof VARCHAR(255) DEFAULT NULL, roof_tiles_smeared TINYINT(1) DEFAULT NULL, length NUMERIC(5, 2) DEFAULT NULL, width NUMERIC(5, 2) DEFAULT NULL, tilt SMALLINT DEFAULT NULL, img_roof VARCHAR(255) DEFAULT NULL, eaves_height NUMERIC(5, 2) DEFAULT NULL, img_eaves_height VARCHAR(255) DEFAULT NULL, electricity_consumption_year SMALLINT DEFAULT NULL, electricity_price_per_kwh SMALLINT DEFAULT NULL, electricity_basic_price NUMERIC(5, 2) DEFAULT NULL, img_electricity_bill VARCHAR(255) DEFAULT NULL, all_black TINYINT(1) DEFAULT NULL, contact_address VARCHAR(255) DEFAULT NULL, contact_first_name VARCHAR(255) DEFAULT NULL, contact_last_name VARCHAR(255) DEFAULT NULL, contact_email VARCHAR(255) DEFAULT NULL, contact_phone VARCHAR(255) DEFAULT NULL, contact_mobile VARCHAR(255) DEFAULT NULL, remarks TEXT DEFAULT NULL, INDEX IDX_274A2B2120F699D9 (accepted_by_id), INDEX IDX_274A2B212FFD4FD3 (processed_by_id), UNIQUE INDEX UNIQ_274A2B21F5B7AF75 (address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE milestone (id INT AUTO_INCREMENT NOT NULL, project_id INT NOT NULL, sequence SMALLINT NOT NULL, name VARCHAR(255) NOT NULL, icon VARCHAR(255) DEFAULT NULL, reached TINYINT(1) NOT NULL, reached_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_4FAC8382166D1F9C (project_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE project (id INT AUTO_INCREMENT NOT NULL, customer_id INT NOT NULL, address_id INT DEFAULT NULL, INDEX IDX_2FB3D0EE9395C3F3 (customer_id), UNIQUE INDEX UNIQ_2FB3D0EEF5B7AF75 (address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE status (id INT AUTO_INCREMENT NOT NULL, customer_request_id INT NOT NULL, employee_id INT DEFAULT NULL, type VARCHAR(255) NOT NULL, start DATETIME NOT NULL, end DATETIME DEFAULT NULL, INDEX IDX_7B00651CBFB7BC27 (customer_request_id), INDEX IDX_7B00651C8C03F15C (employee_id), UNIQUE INDEX duplicate_status (type, customer_request_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, billing_address_id INT DEFAULT NULL, email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, user_type VARCHAR(255) NOT NULL, title VARCHAR(255) DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, mobile VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), INDEX IDX_8D93D64979D0C0E4 (billing_address_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE conversation ADD CONSTRAINT FK_8A8E26E9BFB7BC27 FOREIGN KEY (customer_request_id) REFERENCES customer_request (id)');
        $this->addSql('ALTER TABLE conversation ADD CONSTRAINT FK_8A8E26E98C03F15C FOREIGN KEY (employee_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE customer_request ADD CONSTRAINT FK_274A2B2120F699D9 FOREIGN KEY (accepted_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE customer_request ADD CONSTRAINT FK_274A2B212FFD4FD3 FOREIGN KEY (processed_by_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE customer_request ADD CONSTRAINT FK_274A2B21F5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
        $this->addSql('ALTER TABLE milestone ADD CONSTRAINT FK_4FAC8382166D1F9C FOREIGN KEY (project_id) REFERENCES project (id)');
        $this->addSql('ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EE9395C3F3 FOREIGN KEY (customer_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE project ADD CONSTRAINT FK_2FB3D0EEF5B7AF75 FOREIGN KEY (address_id) REFERENCES address (id)');
        $this->addSql('ALTER TABLE status ADD CONSTRAINT FK_7B00651CBFB7BC27 FOREIGN KEY (customer_request_id) REFERENCES customer_request (id)');
        $this->addSql('ALTER TABLE status ADD CONSTRAINT FK_7B00651C8C03F15C FOREIGN KEY (employee_id) REFERENCES user (id)');
        $this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64979D0C0E4 FOREIGN KEY (billing_address_id) REFERENCES address (id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE customer_request DROP FOREIGN KEY FK_274A2B21F5B7AF75');
        $this->addSql('ALTER TABLE project DROP FOREIGN KEY FK_2FB3D0EEF5B7AF75');
        $this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64979D0C0E4');
        $this->addSql('ALTER TABLE conversation DROP FOREIGN KEY FK_8A8E26E9BFB7BC27');
        $this->addSql('ALTER TABLE status DROP FOREIGN KEY FK_7B00651CBFB7BC27');
        $this->addSql('ALTER TABLE milestone DROP FOREIGN KEY FK_4FAC8382166D1F9C');
        $this->addSql('ALTER TABLE conversation DROP FOREIGN KEY FK_8A8E26E98C03F15C');
        $this->addSql('ALTER TABLE customer_request DROP FOREIGN KEY FK_274A2B2120F699D9');
        $this->addSql('ALTER TABLE customer_request DROP FOREIGN KEY FK_274A2B212FFD4FD3');
        $this->addSql('ALTER TABLE project DROP FOREIGN KEY FK_2FB3D0EE9395C3F3');
        $this->addSql('ALTER TABLE status DROP FOREIGN KEY FK_7B00651C8C03F15C');
        $this->addSql('DROP TABLE address');
        $this->addSql('DROP TABLE conversation');
        $this->addSql('DROP TABLE customer_request');
        $this->addSql('DROP TABLE milestone');
        $this->addSql('DROP TABLE project');
        $this->addSql('DROP TABLE status');
        $this->addSql('DROP TABLE user');
    }
}