migrations/Version20251103191211.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.  * Add StdConfig entry for page audit content types filter
  12.  */
  13. final class Version20251103191211 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add configuration entry to control which content types should be audited for page edit tracking';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // Insert config entry for page audit content types
  23.         $this->addSql("
  24.             INSERT INTO std_config (
  25.                 machine_name,
  26.                 label,
  27.                 value,
  28.                 description_machine_name,
  29.                 details_machine_name,
  30.                 parent_name,
  31.                 created_date,
  32.                 updated_date,
  33.                 created_by,
  34.                 updated_by,
  35.                 is_hidden,
  36.                 language_code,
  37.                 content,
  38.                 roles,
  39.                 variable_type,
  40.                 order_value
  41.             ) VALUES (
  42.                 'page_audit_content_types',
  43.                 'Page Audit - Content Types',
  44.                 NULL,
  45.                 'page_audit_content_types_description',
  46.                 'page_audit_content_types_details',
  47.                 'System',
  48.                 NOW(),
  49.                 NOW(),
  50.                 1,
  51.                 1,
  52.                 0,
  53.                 '',
  54.                 '{\"query\": \"select id, name as label from std_content_types order by name\"}',
  55.                 '[\"ROLE_SUPER_ADMIN\"]',
  56.                 'SELECT_MULTIPLE',
  57.                 99
  58.             )
  59.         ");
  60.     }
  62.     public function down(Schema $schema): void
  63.     {
  64.         // Remove the config entry
  65.         $this->addSql("DELETE FROM std_config WHERE machine_name = 'page_audit_content_types'");
  66.     }
  67. }