This is part four 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 users
This maps Drupal user export to WordPress.
Drupal 6.x |
WordPress 3.x |
Notes |
users |
wp_posts |
|
uid |
ID |
|
name |
user_login |
Format to lowercase, replace spaces with underscores |
pass |
user_pass |
|
name |
user_nicename |
|
|
user_email |
|
created |
user_registered |
Formatted from UNIX time |
name |
display_name |
|
user_status |
Whitespace string |
|
user_activation_key |
Set to 0 |
|
Table mapping for WordPress user meta values
User information like capabilities and roles in the wp_usermeta table.
users |
wp_usermeta |
|
uid |
user_id |
|
meta_key |
Set to string e.g. ‘wp_capabilities’ |
|
meta_value |
Set to string e.g. ‘a:1:{s:6:”author”;s:1:”1″;}’ |
More information about the settings for appropriate meta_key and meta_value can be found in the WordPress Codex:
Node authors and comment authors
Drupal stores both node authors and comment authors in the users table. WordPress handles things differently. Page and post authors are stored in the wp_users table but comment authors are stored in wp_comments together with the comment data.