migrations/Version20240220071615.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 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
    }
}