Drupal to WordPress migration: comments table mapping

This is part three of a series of posts documenting the table mappings for a site migration from Drupal 6 to WordPress 3. For more information, please see the first article in the series.

Table mapping for WordPress comments

Drupal 6.x	WordPress 3.x	Notes
comments	wp_posts
cid	comment_ID
nid	comment_post_ID
timestamp	comment_date	Converted from UNIX timestamp
comment	comment_content
pid	comment_parent
name	comment_author
mail	comment_author_email
homepage	comment_author_url	Truncated to WordPress limit of 200 chars
status	comment_approved

Comment authors

A note about the different ways Drupal and WordPress store comment author information: Drupal stores comment authors in its users table alongside site users like node authors. In WordPress, comment authors are stored in its wp_comments together with the comment data. WordPress comment authors are not entered into the wp_users table.