Jump to content

Extension:ContentTranslation/cx_translations table

From mediawiki.org


mysql> describe cx_translations;
+------------------------------------+-------------------------------------+------+-----+---------+----------------+
| Field                              | Type                                | Null | Key | Default | Extra          |
+------------------------------------+-------------------------------------+------+-----+---------+----------------+
| translation_id                     | int(11)                             | NO   | PRI | NULL    | auto_increment |
| translation_source_title           | varbinary(512)                      | NO   | MUL | NULL    |                |
| translation_target_title           | varbinary(512)                      | NO   |     | NULL    |                |
| translation_source_language        | varbinary(36)                       | NO   | MUL | NULL    |                |
| translation_target_language        | varbinary(36)                       | NO   |     | NULL    |                |
| translation_source_revision_id     | int(10) unsigned                    | YES  |     | NULL    |                |
| translation_target_revision_id     | int(10) unsigned                    | YES  |     | NULL    |                |
| translation_source_url             | blob                                | NO   |     | NULL    |                |
| translation_target_url             | blob                                | YES  |     | NULL    |                |
| translation_status                 | enum('draft','published','deleted') | YES  |     | NULL    |                |
| translation_start_timestamp        | varbinary(14)                       | NO   |     | NULL    |                |
| translation_last_updated_timestamp | varbinary(14)                       | NO   |     | NULL    |                |
| translation_progress               | tinyblob                            | NO   |     | NULL    |                |
| translation_started_by             | int(11)                             | YES  |     | NULL    |                |
| translation_last_update_by         | int(11)                             | YES  |     | NULL    |                |
| translation_cx_version             | tinyint(3) unsigned                 | YES  |     | 1       |                |
+------------------------------------+-------------------------------------+------+-----+---------+----------------+