Page MenuHomePhabricator

Add primary key for database table translate_tmf
Open, MediumPublic

Description

The table translate_tmf 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.

Current schema
CREATE TABLE /*_*/translate_tmf (
  tmf_sid INT UNSIGNED NOT NULL,
  tmf_text TEXT NOT NULL,
  FULLTEXT INDEX tmf_text (tmf_text)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4;

Primary key helps on database maintenance and it can make deletions on the table easier and avoid deadlocks with other deletion or inserts

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.