mismatched_foreign_key_details

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 939
        def mismatched_foreign_key_details(message,, sql))
          foreign_key_pat =
            /Referencing column '(\w+)' and referenced/ =~ message ? $1 : '\w+'

          match = /
            (?:CREATE|ALTER)\s+TABLE\s*(?:`?\w+`?\.)?`?(?<table>\w+)`?.+?
            FOREIGN\s+KEY\s*\(`?(?<foreign_key>#{foreign_key_pat})`?\)\s*
            REFERENCES\s*(`?(?<target_table>\w+)`?)\s*\(`?(?<primary_key>\w+)`?\)
          /mi.match(sql)

          options = {}

          if match
            options[:table] = match[:table]
            options[:foreign_key] = match[:foreign_key]
            options[:target_table] = match[:target_table]
            options[:primary_key] = match[:primary_key]
            options[:primary_key_column] = column_for(match[:target_table], match[:primary_key])
          end

          options
        end