The table cx_suggestions does not have a primary key or a unique index.
Please add a primary key as best practice by choosing one or more relevant columns which must be unique by functional or add a new column with an autoincrement value as surrogate key.
CREATE TABLE /*_*/cx_suggestions ( -- Foreign key to cxl_id cxs_list_id int NOT NULL, -- Source language code cxs_source_language varbinary(36) NOT NULL, -- Target language code cxs_target_language varbinary(36), -- Title of the suggestion cxs_title varbinary(512) NOT NULL ) /*$wgDBTableOptions*/; CREATE INDEX /*i*/cx_suggestions_by_lang ON /*_*/cx_suggestions ( cxs_list_id, cxs_source_language, cxs_target_language );
Primary key helps on database maintenance and it can make deletions on the table easier and avoid deadlocks with other deletion or inserts