Draft: Dropped unique index for namespace id field on group namespace filters

What does this MR do and why?

Dropped unique index for namespace id field on group namespace filters

Changelog: removed EE: true

Migration

up

bundle exec rake db:migrate:up:main VERSION=20231120140557                 
main: == [advisory_lock_connection] object_id: 185440, pg_backend_pid: 34319
main: == 20231120140557 DropUniqueIndexNamespaceIdOnGroupNamespaceFilters: migrating 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.1264s
main: -- indexes(:audit_events_streaming_http_group_namespace_filters)
main:    -> 0.0050s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0003s
main: -- remove_index(:audit_events_streaming_http_group_namespace_filters, {:algorithm=>:concurrently, :name=>"unique_audit_events_group_namespace_filters_namespace_id"})
main:    -> 0.0055s
main: -- execute("RESET statement_timeout")
main:    -> 0.0002s
main: == 20231120140557 DropUniqueIndexNamespaceIdOnGroupNamespaceFilters: migrated (0.1643s) 

main: == [advisory_lock_connection] object_id: 185440, pg_backend_pid: 34319

down

bundle exec rake db:migrate:down:main VERSION=20231120140557
main: == [advisory_lock_connection] object_id: 193740, pg_backend_pid: 43700
main: == 20231120140557 DropUniqueIndexNamespaceIdOnGroupNamespaceFilters: reverting 
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0805s
main: -- index_exists?(:audit_events_streaming_http_group_namespace_filters, :namespace_id, {:unique=>true, :name=>"unique_audit_events_group_namespace_filters_namespace_id", :algorithm=>:concurrently})
main:    -> 0.0027s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0002s
main: -- add_index(:audit_events_streaming_http_group_namespace_filters, :namespace_id, {:unique=>true, :name=>"unique_audit_events_group_namespace_filters_namespace_id", :algorithm=>:concurrently})
main:    -> 0.0054s
main: -- execute("RESET statement_timeout")
main:    -> 0.0002s
main: == 20231120140557 DropUniqueIndexNamespaceIdOnGroupNamespaceFilters: reverted (0.1087s) 

main: == [advisory_lock_connection] object_id: 193740, pg_backend_pid: 43700

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

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.

Related to #432431 (closed)