migrations/Identity/Version20200227095952_User.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations\Identity;
  7. use App\Doctrine\Type\Identity\UserGender;
  8. use App\Doctrine\Type\Identity\UserRole;
  9. use App\Doctrine\Type\Identity\UserStatus;
  10. use Doctrine\DBAL\Schema\Schema;
  11. use Doctrine\Migrations\AbstractMigration;
  13. /**
  14.  * Auto-generated Migration: Please modify to your needs!
  15.  */
  16. final class Version20200227095952_User extends AbstractMigration
  17. {
  18.     public function getDescription(): string
  19.     {
  20.         return 'Create user table';
  21.     }
  23.     public function up(Schema $schema): void
  24.     {
  25.         $userRolesType = UserRole::getName(asArray: true);
  26.         $userGenderType = UserGender::getName();
  27.         $userStatusType = UserStatus::getName();
  28.         $defaultRole = UserRole::ROLE_USER->value;
  29.         $defaultStatus = UserStatus::CREATED->value;
  31.         $this->addSql("CREATE TABLE public.user (
  32.             id                  SERIAL PRIMARY KEY,
  33.             identifier          UUID                        NOT NULL,
  34.             company_id          INTEGER,
  35.             avatar_id           INTEGER,
  36.             password            CHARACTER VARYING,
  37.             position            CHARACTER VARYING,
  38.             first_name          CHARACTER VARYING,
  39.             last_name           CHARACTER VARYING,
  40.             born_on             DATE,
  41.             roles               {$userRolesType}            NOT NULL DEFAULT '{{$defaultRole}}',
  42.             status              {$userStatusType}           NOT NULL DEFAULT '{$defaultStatus}',
  43.             gender              {$userGenderType},
  44.             settings            JSONB                       NOT NULL,
  46.             created_by          INTEGER                              REFERENCES public.user (id),
  47.             updated_by          INTEGER                              REFERENCES public.user (id),
  48.             created_at          TIMESTAMP(0) WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
  49.             updated_at          TIMESTAMP(0) WITH TIME ZONE,
  50.             deleted_at          TIMESTAMP(0) WITH TIME ZONE,
  52.             CONSTRAINT user_identifier_key UNIQUE (identifier)
  53.         )");
  55.         $this->addSql("COMMENT ON COLUMN public.user.identifier IS '(DC2Type:ulid)'");
  56.         $this->addSql("COMMENT ON COLUMN public.user.settings IS '(DC2Type:json_document)'");
  57.         $this->addSql("CREATE INDEX user_avatar_id_idx ON public.user (avatar_id)");
  58.         $this->addSql("CREATE INDEX user_company_id_idx ON public.user (company_id)");
  59.         $this->addSql("CREATE INDEX user_created_by_idx ON public.user (created_by)");
  60.         $this->addSql("CREATE INDEX user_updated_by_idx ON public.user (updated_by)");
  61.     }
  63.     public function down(Schema $schema): void
  64.     {
  65.         $this->addSql("DROP TABLE IF EXISTS public.user");
  66.     }
  67. }