This is part two 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 terms
This table mapping exports the Drupal terms into WordPress.
|
Drupal 6.x |
WordPress 3.x |
Notes |
|
term_data |
wp_terms |
|
|
tid |
term_id |
|
|
name |
name |
|
|
name |
slug |
Make lower case and convert spaces to underscores |
|
vid |
term_group |
Not used in a default WordPress installation |
|
term_data |
wp_term_taxonomy |
|
|
tid |
term_taxonomy_id |
|
|
tid |
term_id |
|
|
taxonomy |
String: ‘post_tag’ or ‘category’ |
|
|
description |
description |
|
|
parent |
0 (No parent) |
In the WordPress Taxonomy documentation, “term_group is a means of grouping together similar terms.” During a standard migration, the WordPress term_group is set to the Drupal vocabulary ID, which seems to make sense. Nevertheless, a default WordPress installation does not actually use the value for anything. It may have been included by the developers for future expandability or use by plugins.
term_group=0 is the default value when creating a term using the Drupal user interface.
Below, we associate posts with the newly migrated terms.
|
Drupal 6.x |
WordPress 3.x |
|
term_node |
wp_term_relationships |
|
nid |
object_id |
|
tid |
term_taxonomy_id |