Title: Database documentation
Last modified: August 31, 2016

---

# Database documentation

 *  Resolved [andiwand](https://wordpress.org/support/users/andiwand/)
 * (@andiwand)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/database-documentation/)
 * Hi Chouby!
 * Fist, I want to thank you for this awesome plugin. Thanks!
    I’m currently porting
   a website to wordpress where multilingual is a must. I don’t want to do this 
   by hand because it’s a mass of content. I’m using xml rpc for this, which works
   pretty well so far. My problem now is that I don’t really know how to add the
   polylang information to the database.
 * I found out that these three tables are relevant for polylang: wp_terms, wp_term_relationships,
   wp_term_taxonomy.
    The taxonomies I saw so far are: language, term_language, 
   term_translation, post_translation. So what I read from that is that “language”
   tells the post (or what ever) what kind of language its content is. “post_translation”
   tells each post to which posts with other languages it is related to. So far 
   so good. I think the other two are not relevant for what I’m trying to achieve.
   What I don’t understand is, what the table wp_terms tells me. There are these“
   pll_xxxxxxxx” names / slugs but I don’t get what it’s linked too. Or isn’t it
   linked? Does it just have to be unique?
 * Thanks in advance!
 * [https://wordpress.org/plugins/polylang/](https://wordpress.org/plugins/polylang/)

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Michel – xiligroup dev](https://wordpress.org/support/users/michelwppi/)
 * (@michelwppi)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/database-documentation/#post-7041603)
 * Polylang was the second multilingual plugin to use taxonomy. Some years ago, 
   it introduces a 2nd specific/original taxonomy “post_translations” to link same
   posts in different languages (links were previously in custom fields). The serialized
   datas (post-id) are in the description of the term to this taxonomy.
    As author
   of xili-language, I have create some fonctions to recover ‘PLL’ links between
   translations. The functions are in xili-includes/pll_functions.php but only usable
   in xili-language plugins but a good example for you. Thanks for your questions,
   it is an illustration of how the saved datas in DB must easy to be “queriable”.
   It will be include in our research to define multilingual new/stable rules in
   WP context. Michel
 *  Thread Starter [andiwand](https://wordpress.org/support/users/andiwand/)
 * (@andiwand)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/database-documentation/#post-7041639)
 * Thanks for your reply!
 * I finally found the section of this mystic string in the plugin source. It is
   just an unique id generated by php function uniqid(“pll_”).
    Now I managed to
   post something from xmlrpc in multiple languages.
 * Andreas

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database documentation’ is closed to new replies.

 * ![](https://ps.w.org/polylang/assets/icon-256x256.png?rev=3433336)
 * [Polylang](https://wordpress.org/plugins/polylang/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/polylang/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/polylang/)
 * [Active Topics](https://wordpress.org/support/plugin/polylang/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/polylang/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/polylang/reviews/)

## Tags

 * [custom field](https://wordpress.org/support/topic-tag/custom-field/)
 * [taxonomy](https://wordpress.org/support/topic-tag/taxonomy/)
 * [wp_terms](https://wordpress.org/support/topic-tag/wp_terms/)
 * [XML-RPC](https://wordpress.org/support/topic-tag/xml-rpc/)

 * 2 replies
 * 2 participants
 * Last reply from: [andiwand](https://wordpress.org/support/users/andiwand/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/database-documentation/#post-7041639)
 * Status: resolved