migrations/File/Version20200227142406_File.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\File;
  7. use App\Doctrine\Type\File\FileType;
  8. use App\Doctrine\Type\File\ParsableStatus;
  9. use App\Doctrine\Type\File\ParsableType;
  10. use App\Doctrine\Type\File\UploadableStatus;
  11. use App\Doctrine\Type\File\UploadableType;
  12. use Doctrine\DBAL\Schema\Schema;
  13. use Doctrine\Migrations\AbstractMigration;
  15. /**
  16.  * Auto-generated Migration: Please modify to your needs!
  17.  */
  18. final class Version20200227142406_File extends AbstractMigration
  19. {
  20.     public function getDescription(): string
  21.     {
  22.         return 'Create file table';
  23.     }
  25.     public function up(Schema $schema): void
  26.     {
  27.         $this->addSql(FileType::getRegistrationSQL());
  28.         $this->addSql(ParsableType::getRegistrationSQL());
  29.         $this->addSql(ParsableStatus::getRegistrationSQL());
  30.         $this->addSql(UploadableType::getRegistrationSQL());
  31.         $this->addSql(UploadableStatus::getRegistrationSQL());
  33.         $fileType = FileType::getName();
  34.         $parsableType = ParsableType::getName();
  35.         $parsableStatus = ParsableStatus::getName();
  36.         $uploadableType = UploadableType::getName(asArray: true);
  37.         $uploadableStatus = UploadableStatus::getName();
  39.         $this->addSql("CREATE TABLE public.file (
  40.             id                  SERIAL PRIMARY KEY,
  42.             slug                CHARACTER VARYING           NOT NULL,
  43.             file_type           {$fileType}                 NOT NULL,
  44.             name                CHARACTER VARYING           NOT NULL,
  45.             original_name       CHARACTER VARYING           NOT NULL,
  46.             path                CHARACTER VARYING           NOT NULL,
  47.             description         CHARACTER VARYING,
  48.             mime_type           CHARACTER VARYING           NOT NULL,
  49.             size                INTEGER                     NOT NULL,
  50.             parsable_type       {$parsableType},
  51.             parsable_status     {$parsableStatus},
  52.             uploadable_types    {$uploadableType},
  53.             uploadable_status   {$uploadableStatus},
  54.             data                JSONB,
  55.             errors              JSONB,
  57.             created_by          INTEGER                              REFERENCES public.user (id),
  58.             updated_by          INTEGER                              REFERENCES public.user (id),
  59.             created_at          TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  60.             updated_at          TIMESTAMP(0) WITH TIME ZONE,
  61.             deleted_at          TIMESTAMP(0) WITH TIME ZONE,
  63.             CONSTRAINT file_slug_key UNIQUE (slug),
  64.             CONSTRAINT file_path_key UNIQUE (path)
  65.         )");
  67.         $this->addSql("COMMENT ON COLUMN public.file.data IS '(DC2Type:json_document)'");
  68.         $this->addSql("CREATE INDEX file_created_by_idx ON public.file (created_by)");
  69.         $this->addSql("CREATE INDEX file_updated_by_idx ON public.file (updated_by)");
  70.     }
  72.     public function down(Schema $schema): void
  73.     {
  74.         $this->addSql("DROP TABLE IF EXISTS public.file");
  75.         $this->addSql(UploadableStatus::getDeletionSQL());
  76.         $this->addSql(UploadableType::getDeletionSQL());
  77.         $this->addSql(ParsableStatus::getDeletionSQL());
  78.         $this->addSql(ParsableType::getDeletionSQL());
  79.         $this->addSql(FileType::getDeletionSQL());
  80.     }
  81. }