<?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 Version20240220071615 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
$this->addSql('CREATE TABLE `schedule_notifications` (
`id` INT NOT NULL AUTO_INCREMENT,
`type` INT NULL DEFAULT NULL COMMENT "1 = Post Liked, 2 = User Followed, 3 = Comment / Reply on Post",
`reference_id` INT NULL DEFAULT NULL COMMENT "This will be post id for now.",
`owner_id` INT NULL DEFAULT NULL,
`from_user_id` INT NULL DEFAULT NULL,
`flag_sent` INT NOT NULL DEFAULT "0" COMMENT "0 = Not Sent (default 0), 1 = Sent",
`created_on` DATETIME NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;
');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
}
}