migrations/Version20240613171937.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20240613171937 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $drop = <<<SQL
  23.     ALTER TABLE assistant DROP COLUMN local_vector_database_id;  
  24.     ALTER TABLE assistant DROP COLUMN local_vector_database_data_url;
  25. SQL;
  27.         $this->addSql($drop);
  29.         $sql = <<<SQL
  30. create table assistant_database
  31. (
  32.     id              int auto_increment primary key,
  33.     assistant_id     int                                                                                 not null,
  34.     type            varchar(20)                                                                         not null,
  35.     initialized     int                                                       default 0                 null,
  36.     parameter       varchar(255)                                                                        null,
  37.     data_url        varchar(255)                                                                        null,
  38.     reinitialize    datetime                                                  default CURRENT_TIMESTAMP null,
  39.     active          tinyint                                                   default 1                 null,
  41.     constraint assistant_database_fk_1
  42.         foreign key (assistant_id) references assistant (id)
  43. )
  44.     collate = utf8mb4_unicode_ci;
  46. create index assistant_id
  47.     on assistant_database (assistant_id);
  48. SQL;
  49.         $this->addSql($sql);
  51.     }
  53.     public function down(Schema $schema): void
  54.     {
  55.         // this down() migration is auto-generated, please modify it to your needs
  57.     }
  58. }