migrations/Version20251218161229.php line 1

Open in your IDE?
  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 Version20251218161229 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add ads provider configuration (SAPO / Studio / None)';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql("
  23.             INSERT INTO `std_config`
  24.             (
  25.                 `machine_name`,
  26.                 `created_by`,
  27.                 `updated_by`,
  28.                 `value`,
  29.                 `description_machine_name`,
  30.                 `details_machine_name`,
  31.                 `parent_name`,
  32.                 `variable_type`,
  33.                 `order_value`,
  34.                 `is_hidden`,
  35.                 `is_active`,
  36.                 `created_date`,
  37.                 `updated_date`,
  38.                 `label`,
  39.                 `content`,
  40.                 `language_code`,
  41.                 `roles`
  42.             )
  43.             VALUES
  44.             (
  45.                 'ads_provider',
  46.                 1,
  47.                 1,
  48.                 'none',
  49.                 'ads_provider',
  50.                 'ads_provider',
  51.                 'Publicidade',
  52.                 'SELECT',
  53.                 1,
  54.                 0,
  55.                 1,
  56.                 NOW(),
  57.                 NOW(),
  58.                 'Fornecedor de Publicidade',
  59.                 '{\"query\": \"SELECT ''SAPO'' AS label, ''sapo'' AS id UNION SELECT ''Studio'' AS label, ''studio'' AS id UNION SELECT ''Nenhum'' AS label, ''none'' AS id\"}',
  60.                 '',
  61.                 NULL
  62.             );
  63.         ");
  64.     }
  66.     public function down(Schema $schema): void
  67.     {
  68.         $this->addSql("
  69.             DELETE FROM `std_config`
  70.             WHERE `machine_name` = 'ads_provider';
  71.         ");
  72.     }
  73. }