Please review and deploy SQL file: https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FContentTranslation.git/ce5b8d2a95dabe31604f1811d26e61a4b77439ab/sql%2Flists.sql
This will be used to store Suggestions for ContentTranslation.
See T92987 for more details.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | jcrespo | T111317 Review and create table for Content Translation | |||
| Resolved | jcrespo | T111333 wikishared database has latin1 as the default encoding |
This SQL script does not involve any schema change -only new tables- and can be deployed in the same cycle that other code, without requiring DBA supervision.
These 2 tables have been created on x1-master and its slaves:
MariaDB [wikishared]> SHOW CREATE TABLE cx_lists\G
*************************** 1. row ***************************
Table: cx_lists
Create Table: CREATE TABLE `cx_lists` (
`cxl_id` int(11) NOT NULL AUTO_INCREMENT,
`cxl_type` int(11) DEFAULT '0',
`cxl_owner` int(11) NOT NULL,
`cxl_public` tinyint(1) NOT NULL,
`cxl_start_time` varbinary(14) DEFAULT NULL,
`cxl_end_time` varbinary(14) DEFAULT NULL,
`cxl_name` varbinary(512) NOT NULL,
`cxl_info` mediumblob,
PRIMARY KEY (`cxl_id`),
UNIQUE KEY `cx_lists_relevant` (`cxl_type`,`cxl_public`,`cxl_start_time`,`cxl_end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=binary
1 row in set (0.00 sec)
MariaDB [wikishared]> SHOW CREATE TABLE cx_suggestions\G
*************************** 1. row ***************************
Table: cx_suggestions
Create Table: CREATE TABLE `cx_suggestions` (
`cxs_list_id` int(11) NOT NULL,
`cxs_source_language` varbinary(36) NOT NULL,
`cxs_target_language` varbinary(36) DEFAULT NULL,
`cxs_title` varbinary(512) NOT NULL,
KEY `cx_suggestions_by_lang` (`cxs_list_id`,`cxs_source_language`,`cxs_target_language`)
) ENGINE=InnoDB DEFAULT CHARSET=binary
1 row in set (0.00 sec)Please review them, confirm they are ok, and resolve the ticket if positive.