Move unessential comment fields to the comment meta table

[scribu]

The wp_comments table has 3 less-used fields that would be better placed in the new commentmeta table. These are:

• comment_author_IP

• comment_agent

• comment_karma

[scribu]

Related: #10747

[scribu]

Saves new data to comment meta. Still needs code for migrating old data

[dd32]

Any chance of this in 2.9? With windows 7, The user agents are starting to grow.. making the field longer in the comments table works around it.. but storing meta as meta would be better way forward.

this patch could do with a compat to merge commentmeta with the $comments object if thats not already done.

[Denis-de-Bernardy]

Imo, the IP address should stay in the comments table. It's potentially useful in there in order to mass-delete spammy comments.

[nacin]

Cross referencing #12668. Should be handled together.

[mitchoyoshitaka]

Replying to Denis-de-Bernardy:

Imo, the IP address should stay in the comments table. It's potentially useful in there in order to mass-delete spammy comments.

Well, getting that data should just be one join away. It's not worth keeping that column in this table just for that reason. We should optimize for the 90% use case.

[chriscct7]

@nacin why is #12668 related to this one?

[wonderboymusic]

no movement in Years