Array
(
    [0] => Array
        (
            [Table] => favorites
            [Non_unique] => 0
            [Key_name] => PRIMARY
            [Seq_in_index] => 1
            [Column_name] => id
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => 
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

    [1] => Array
        (
            [Table] => favorites
            [Non_unique] => 0
            [Key_name] => user_content
            [Seq_in_index] => 1
            [Column_name] => user_id
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => 
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

    [2] => Array
        (
            [Table] => favorites
            [Non_unique] => 0
            [Key_name] => user_content
            [Seq_in_index] => 2
            [Column_name] => stream_id
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => 
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

    [3] => Array
        (
            [Table] => favorites
            [Non_unique] => 0
            [Key_name] => user_content
            [Seq_in_index] => 3
            [Column_name] => tmdb_id
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => 
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

    [4] => Array
        (
            [Table] => favorites
            [Non_unique] => 0
            [Key_name] => user_content
            [Seq_in_index] => 4
            [Column_name] => media_type
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => YES
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

    [5] => Array
        (
            [Table] => favorites
            [Non_unique] => 1
            [Key_name] => fk_fav_profile
            [Seq_in_index] => 1
            [Column_name] => profile_id
            [Collation] => A
            [Cardinality] => 0
            [Sub_part] => 
            [Packed] => 
            [Null] => YES
            [Index_type] => BTREE
            [Comment] => 
            [Index_comment] => 
            [Ignored] => NO
        )

)
Could not drop user_content: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'user_content': needed in a foreign key constraint
Could not drop user_content: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'user_content': needed in a foreign key constraint
Could not drop user_content: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'user_content': needed in a foreign key constraint
Could not drop user_content: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'user_content': needed in a foreign key constraint
Could not drop fk_fav_profile: SQLSTATE[HY000]: General error: 1553 Cannot drop index 'fk_fav_profile': needed in a foreign key constraint
Error: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'user_content'