migrations/Scheduler/Version20200320140918_Task.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Scheduler;
  7. use App\Doctrine\Type\Scheduler\TaskStatus;
  8. use App\Doctrine\Type\Scheduler\TaskType;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  */
  15. final class Version20200320140918_Task extends AbstractMigration
  16. {
  17.     public function getDescription(): string
  18.     {
  19.         return 'Add task table';
  20.     }
  22.     public function up(Schema $schema): void
  23.     {
  24.         $this->addSql(TaskType::getRegistrationSQL());
  25.         $this->addSql(TaskStatus::getRegistrationSQL());
  27.         $taskTypeType = TaskType::getName();
  28.         $taskStatusType = TaskStatus::getName();
  29.         $defaultStatus = TaskStatus::PLANNED->value;
  31.         $this->addSql("CREATE TABLE task (
  32.             id                              SERIAL PRIMARY KEY,
  33.             assignee_id                     INTEGER                              REFERENCES public.user (id),
  34.             type                            {$taskTypeType}             NOT NULL,
  35.             status                          {$taskStatusType}           NOT NULL DEFAULT '{$defaultStatus}',
  37.             is_progressive                  BOOLEAN                     NOT NULL DEFAULT FALSE,
  38.             is_action                       BOOLEAN                     NOT NULL DEFAULT FALSE,
  39.             delayed                         BOOLEAN                     NOT NULL DEFAULT FALSE,
  40.             urgent                          BOOLEAN                     NOT NULL DEFAULT FALSE,
  41.             description                     CHARACTER VARYING           NOT NULL,
  42.             entity                          CHARACTER VARYING           NOT NULL,
  43.             entity_id                       INTEGER                     NOT NULL,
  44.             planned_for                     TIMESTAMP(0) WITH TIME ZONE NOT NULL,
  45.             started_on                      TIMESTAMP(0) WITH TIME ZONE,
  46.             completed_on                    TIMESTAMP(0) WITH TIME ZONE,
  48.             created_by                      INTEGER                              REFERENCES public.user (id),
  49.             updated_by                      INTEGER                              REFERENCES public.user (id),
  50.             created_at                      TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  51.             updated_at                      TIMESTAMP(0) WITH TIME ZONE,
  52.             deleted_at                      TIMESTAMP(0) WITH TIME ZONE
  53.         )");
  55.         $this->addSql("CREATE INDEX task_assignee_id_idx ON task (assignee_id)");
  56.         $this->addSql("CREATE INDEX task_created_by_idx ON task (created_by)");
  57.         $this->addSql("CREATE INDEX task_updated_by_idx ON task (updated_by)");
  58.     }
  60.     public function down(Schema $schema): void
  61.     {
  62.         $this->addSql("DROP TABLE IF EXISTS task");
  63.         $this->addSql(TaskStatus::getDeletionSQL());
  64.         $this->addSql(TaskType::getDeletionSQL());
  65.     }
  66. }