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 0000000000000000000000000000000000000000..95f7bab7625717114588a2b6b651a0c4b6809c64 --- /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 0000000000000000000000000000000000000000..9f31184b4a1fd028d43ffe9b9558e70c8237b9ab --- /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 5e5886634503b281155edca212a8671eac22cf1c..038a817bb7673d7588dc62de8b7d1481231e9ae5 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))