<?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 Version20231212044155 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('ALTER TABLE educations ADD seo_title VARCHAR(255) DEFAULT NULL, ADD seo_meta_keyword VARCHAR(255) DEFAULT NULL, ADD seo_description LONGTEXT DEFAULT NULL');
$this->addSql('ALTER TABLE memos ADD seo_meta_keyword VARCHAR(255) DEFAULT NULL, ADD seo_description LONGTEXT DEFAULT NULL, CHANGE memo_category_id memo_category_id INT NOT NULL, CHANGE sponsor_social_media_fb_link sponsor_social_media_fb_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_insta_link sponsor_social_media_insta_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_youtube_link sponsor_social_media_youtube_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_twitter_link sponsor_social_media_twitter_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_pinterest_link sponsor_social_media_pinterest_link LONGTEXT DEFAULT NULL, CHANGE audio_file seo_title VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE podcast ADD seo_title VARCHAR(255) DEFAULT NULL, ADD seo_meta_keyword VARCHAR(255) DEFAULT NULL, ADD seo_description LONGTEXT DEFAULT NULL, CHANGE created_by created_by TINYINT(1) NOT NULL, CHANGE category_id category_id INT NOT NULL, CHANGE title title LONGTEXT NOT NULL, CHANGE slug slug LONGTEXT NOT NULL, CHANGE sub_title sub_title LONGTEXT DEFAULT NULL, CHANGE podcast_date podcast_date DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', CHANGE image image LONGTEXT DEFAULT NULL, CHANGE description description LONGTEXT DEFAULT NULL, CHANGE teaser_1 teaser_1 LONGTEXT DEFAULT NULL, CHANGE teaser_2 teaser_2 LONGTEXT DEFAULT NULL, CHANGE teaser_3 teaser_3 LONGTEXT DEFAULT NULL, CHANGE teaser_4 teaser_4 LONGTEXT DEFAULT NULL, CHANGE is_premium is_premium VARCHAR(255) DEFAULT NULL, CHANGE is_active is_active VARCHAR(255) DEFAULT NULL, CHANGE sponsor_title sponsor_title LONGTEXT DEFAULT NULL, CHANGE sponsor_website sponsor_website LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_link sponsor_social_media_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_fb_link sponsor_social_media_fb_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_insta_link sponsor_social_media_insta_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_twitter_link sponsor_social_media_twitter_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_youtube_link sponsor_social_media_youtube_link LONGTEXT DEFAULT NULL, CHANGE sponsor_social_media_pinterest_link sponsor_social_media_pinterest_link LONGTEXT DEFAULT NULL, CHANGE created_at created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', CHANGE updated_at updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', CHANGE deleted_at deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\'');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE educations DROP seo_title, DROP seo_meta_keyword, DROP seo_description');
$this->addSql('ALTER TABLE memos ADD audio_file VARCHAR(255) DEFAULT NULL, DROP seo_title, DROP seo_meta_keyword, DROP seo_description, CHANGE memo_category_id memo_category_id VARCHAR(255) NOT NULL, CHANGE sponsor_social_media_fb_link sponsor_social_media_fb_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_insta_link sponsor_social_media_insta_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_youtube_link sponsor_social_media_youtube_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_twitter_link sponsor_social_media_twitter_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_pinterest_link sponsor_social_media_pinterest_link VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE podcast DROP seo_title, DROP seo_meta_keyword, DROP seo_description, CHANGE title title VARCHAR(255) DEFAULT NULL, CHANGE slug slug VARCHAR(255) DEFAULT NULL, CHANGE category_id category_id INT DEFAULT NULL, CHANGE sub_title sub_title VARCHAR(255) DEFAULT NULL, CHANGE podcast_date podcast_date DATETIME DEFAULT NULL, CHANGE image image VARCHAR(255) DEFAULT NULL, CHANGE description description TEXT DEFAULT NULL, CHANGE teaser_1 teaser_1 VARCHAR(255) DEFAULT NULL, CHANGE teaser_2 teaser_2 VARCHAR(255) DEFAULT NULL, CHANGE teaser_3 teaser_3 VARCHAR(255) DEFAULT NULL, CHANGE teaser_4 teaser_4 VARCHAR(255) DEFAULT NULL, CHANGE sponsor_title sponsor_title VARCHAR(255) DEFAULT NULL, CHANGE sponsor_website sponsor_website VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_link sponsor_social_media_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_fb_link sponsor_social_media_fb_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_insta_link sponsor_social_media_insta_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_youtube_link sponsor_social_media_youtube_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_twitter_link sponsor_social_media_twitter_link VARCHAR(255) DEFAULT NULL, CHANGE sponsor_social_media_pinterest_link sponsor_social_media_pinterest_link VARCHAR(255) DEFAULT NULL, CHANGE is_premium is_premium VARCHAR(255) DEFAULT \'0\' COMMENT \'0-->unpublished 1-->published\', CHANGE is_active is_active VARCHAR(255) DEFAULT \'1\' NOT NULL COMMENT \'0-->inactive 1-->active\', CHANGE created_by created_by INT NOT NULL, CHANGE created_at created_at DATETIME DEFAULT NULL, CHANGE updated_at updated_at DATETIME DEFAULT NULL, CHANGE deleted_at deleted_at DATETIME DEFAULT NULL');
}
}