<?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 Version20231025070948 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 resources (
id INT AUTO_INCREMENT NOT NULL,
author_id INT NOT NULL,
type INT NOT NULL,
business_name VARCHAR(255) NOT NULL,
categories VARCHAR(255) NOT NULL,
is_residential VARCHAR(255) DEFAULT NULL,
contact_person VARCHAR(255) DEFAULT NULL,
phone VARCHAR(255) DEFAULT NULL,
city INT DEFAULT NULL,
state INT NULL,
country VARCHAR(255) DEFAULT NULL,
zipcode VARCHAR(255) DEFAULT NULL,
email VARCHAR(255) DEFAULT NULL,
website VARCHAR(255) DEFAULT NULL,
why_like_them LONGTEXT DEFAULT NULL,
is_published TINYINT(1) NOT NULL COMMENT '1=>residential, 2=>commercial',
reason_non_published LONGTEXT DEFAULT NULL,
overall_ratings NUMERIC(10, 2) NOT NULL,
created_at DATETIME NOT NULL COMMENT '(DC2Type:datetime_immutable)',
updated_at DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
deleted_at DATETIME DEFAULT NULL COMMENT '(DC2Type:datetime_immutable)',
PRIMARY KEY(id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB");
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('DROP TABLE builders_details');
}
}