Adds `path` to catalog_resource_components

What does this MR do and why?

down

ci: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 65209
ci: == 20231024173744 AddPathToCatalogResourceComponents: reverting ===============
ci: -- remove_column(:catalog_resource_components, :path, :text)
ci:    -> 0.0014s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- execute("            ALTER TABLE catalog_resource_components\n            DROP CONSTRAINT IF EXISTS check_a76bfd47fe\n")
ci:    -> 0.0003s
ci: == 20231024173744 AddPathToCatalogResourceComponents: reverted (0.0185s) ======

ci: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 65209

up

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 66353
main: == 20231024173744 AddPathToCatalogResourceComponents: migrating ===============
main: -- add_column(:catalog_resource_components, :path, :text)
main:    -> 0.0029s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE catalog_resource_components\nADD CONSTRAINT check_a76bfd47fe\nCHECK ( char_length(path) <= 255 )\nNOT VALID;\n")
main:    -> 0.0016s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0002s
main: -- execute("ALTER TABLE catalog_resource_components VALIDATE CONSTRAINT check_a76bfd47fe;")
main:    -> 0.0014s
main: -- execute("RESET statement_timeout")
main:    -> 0.0002s
main: == 20231024173744 AddPathToCatalogResourceComponents: migrated (0.0982s) ======

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 66353

Resolves: #429256 (closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.