Remove input_type and sensitive from ci_job_inputs

What does this MR do and why?

Addressing #557878

References

Screenshots or screen recordings

Running migration UP

Running migration DOWN

How to set up and validate locally

1. Checkout my branch and run

• bin/rails db:migrate:up:ci VERSION=20251005154107
• bin/rails db:migrate:up:main VERSION=20251005154107
• bin/rails db:migrate:down:ci VERSION=20251005154107
• bin/rails db:migrate:down:main VERSION=20251005154107

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.