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 |
|
|
|
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.