Add Security::PipelineExecutionPolicyTestRun model and database table

Andy Schoenenrequested to merge
586651-create-spep-test-run-model-and-migrations into master

What does this MR do and why?

Creates the Security::PipelineExecutionPolicyTestRun model and database table to store test-run results for Scheduled Pipeline Execution Policies (SPEP). This enables users to validate their scheduled pipeline execution policies before they run in production.

Next step is to create a service that can create test runs and pipelines.

Database changes

  • Creates security_scheduled_pipeline_execution_policy_test_runs table
  • Adds foreign keys to security_policies, projects, and p_ci_pipelines
  • Adds loose foreign key for pipeline_id to handle async cleanup

References

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Andy Schoenen

Merge request reports