Remove software licenses table

What does this MR do and why?

As described in #497969, we are planning the software_licenses table. We already remove all code references to the software_licenses table. This MR removes the software_licenses table.

Migration up

main: == [advisory_lock_connection] object_id: 171840, pg_backend_pid: 69250
main: == 20251125201846 DropSoftwareLicenses: migrating =============================
main: -- drop_table(:software_licenses)
main:    -> 0.0158s
main: == 20251125201846 DropSoftwareLicenses: migrated (0.0262s) ====================

main: == [advisory_lock_connection] object_id: 171840, pg_backend_pid: 69250  


Migration down

main: == [advisory_lock_connection] object_id: 130340, pg_backend_pid: 79539
main: == 20251125201846 DropSoftwareLicenses: reverting =============================
main: -- create_table(:software_licenses)
main:    -> 0.0190s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0634s
main: -- index_exists?(:software_licenses, "LOWER(name)", {:name=>"idx_software_licenses_lower_name", :algorithm=>:concurrently})
main:    -> 0.0014s
main: -- execute("SET statement_timeout TO 0")
main:    -> 0.0009s
main: -- add_index(:software_licenses, "LOWER(name)", {:name=>"idx_software_licenses_lower_name", :algorithm=>:concurrently})
main:    -> 0.0033s
main: -- execute("RESET statement_timeout")
main:    -> 0.0009s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0005s
main: -- index_exists?(:software_licenses, :spdx_identifier, {:name=>"index_software_licenses_on_spdx_identifier", :algorithm=>:concurrently})
main:    -> 0.0013s
main: -- add_index(:software_licenses, :spdx_identifier, {:name=>"index_software_licenses_on_spdx_identifier", :algorithm=>:concurrently})
main:    -> 0.0023s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- view_exists?(:postgres_partitions)
main:    -> 0.0004s
main: -- index_exists?(:software_licenses, :name, {:unique=>true, :name=>"index_software_licenses_on_unique_name", :algorithm=>:concurrently})
main:    -> 0.0018s
main: -- add_index(:software_licenses, :name, {:unique=>true, :name=>"index_software_licenses_on_unique_name", :algorithm=>:concurrently})
main:    -> 0.0038s
main: == 20251125201846 DropSoftwareLicenses: reverted (0.1757s) ====================

main: == [advisory_lock_connection] object_id: 130340, pg_backend_pid: 79539

References

Related to #497969

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.