Content translation/Product Definition/Database

Content Translation need a common database for all the wikis. This database is for storing the translation details of users between language pairs (ie, between wikis).


 * 1) For a user, all the articles the user translated
 * 2) start date
 * 3) source language
 * 4) target language
 * 5) source title
 * 6) target title
 * 7) if published link to the published article
 * 8) Published date
 * 9) Percentage of translation

Setup
Here are sample shell and SQL commands to create the contenttranslation database, Replace USER with the value of $wgDbUser for your own wiki installation (LocalSettings.php).

Enter password for root SQL user, then run the following commands at the mysql prompt:

Beta
Content Translation database is setup as shared database "wikishared" on Beta Cluster.

Production
In Wikimedia production environment, Content Translation tables are placed in side "extension1" shared database cluster. Database for Content Translation is "wikishared". In order to separate Content Translation tables from other tables, they are prefixed as 'cx'.

Access

 * Login to terbium
 * sql.php need to use with,

Where LANG is wiki language code.
 * Queries can be run after that.

Changes
Any changes in database for Production envionment has to go via process described in, https://wikitech.wikimedia.org/wiki/Schema_changes