migrations/Version20240112095057.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 Version20240112095057 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
       
        $this->addSql('ALTER TABLE private_community ADD contact_area_1 LONGTEXT NOT NULL AFTER `contact_address_1`, 
        ADD contact_country_1 BIGINT NOT NULL AFTER `contact_state_1`,
         ADD contact_area_2 LONGTEXT  DEFAULT NULL AFTER `contact_address_2`,
        ADD contact_country_2 BIGINT DEFAULT NULL NULL AFTER `contact_state_2`,
        ADD contact_area_3 LONGTEXT  DEFAULT NULL  AFTER `contact_address_3`,
        ADD contact_country_3 BIGINT DEFAULT NULL AFTER `contact_state_3`, 
        CHANGE contact_bod_1 contact_bod_1 VARCHAR(100) DEFAULT NULL, 
        CHANGE contact_bod_3 contact_bod_2 VARCHAR(100) DEFAULT NULL,
        CHANGE contact_bod_2 contact_bod_3 VARCHAR(100) DEFAULT NULL');
        $this->addSql('ALTER TABLE `private_community` ADD `hear_about_gixli` VARCHAR(255) NULL AFTER `top3_brands`;');
        $this->addSql('ALTER TABLE `private_community` CHANGE `business_start_date` `business_establishment_year` BIGINT NOT NULL;');
        $this->addSql('ALTER TABLE `private_community` ADD `num_of_active_clients` BIGINT NULL AFTER `num_projects_year`;');
        $this->addSql('ALTER TABLE `private_community` CHANGE `business_full_time_spent` `business_time_spent` ENUM("part-time","full-time") CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;');
        $this->addSql('ALTER TABLE `private_community` DROP `business_part_time_spent`');
       
    }

    public function down(Schema $schema): void
    {
        
    }
}