From 479fe090095fbbc3382bb7329d9e698eca65ba7c Mon Sep 17 00:00:00 2001 From: Kasia Misirli Date: Sun, 5 Oct 2025 18:27:29 +0200 Subject: [PATCH] Remove input_type and sensitive from ci_job_inputs Changelog: changed --- ..._ci_job_inputs_input_type_sensitive_columns.rb | 15 +++++++++++++++ db/schema_migrations/20251005154107 | 1 + db/structure.sql | 2 -- 3 files changed, 16 insertions(+), 2 deletions(-) create mode 100644 db/post_migrate/20251005154107_remove_p_ci_job_inputs_input_type_sensitive_columns.rb create mode 100644 db/schema_migrations/20251005154107 diff --git a/db/post_migrate/20251005154107_remove_p_ci_job_inputs_input_type_sensitive_columns.rb b/db/post_migrate/20251005154107_remove_p_ci_job_inputs_input_type_sensitive_columns.rb new file mode 100644 index 00000000000000..95f7bab7625717 --- /dev/null +++ b/db/post_migrate/20251005154107_remove_p_ci_job_inputs_input_type_sensitive_columns.rb @@ -0,0 +1,15 @@ +# frozen_string_literal: true + +class RemovePCiJobInputsInputTypeSensitiveColumns < Gitlab::Database::Migration[2.3] + milestone '18.5' + + def up + remove_column :p_ci_job_inputs, :input_type + remove_column :p_ci_job_inputs, :sensitive + end + + def down + add_column :p_ci_job_inputs, :input_type, :integer, default: 0, null: false, limit: 2 + add_column :p_ci_job_inputs, :sensitive, :boolean, default: false, null: false + end +end diff --git a/db/schema_migrations/20251005154107 b/db/schema_migrations/20251005154107 new file mode 100644 index 00000000000000..9f31184b4a1fd0 --- /dev/null +++ b/db/schema_migrations/20251005154107 @@ -0,0 +1 @@ +aadc1c2a9961c68d85b2fe807214d8c3b18b1ac7188f384f4a492ce12b914f03 \ No newline at end of file diff --git a/db/structure.sql b/db/structure.sql index 5e5886634503b2..038a817bb7673d 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -5194,8 +5194,6 @@ CREATE TABLE p_ci_job_inputs ( job_id bigint NOT NULL, partition_id bigint NOT NULL, project_id bigint NOT NULL, - input_type smallint DEFAULT 0 NOT NULL, - sensitive boolean DEFAULT false NOT NULL, name text NOT NULL, value jsonb, CONSTRAINT check_007134e1cd CHECK ((char_length(name) <= 255)) -- GitLab