Change Details

The parent ticket has more information. This table must have immutable rows. The design would be: ```lang=mysql CREATE TABLE /*_*/title ( title_id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, title_namespace INT NOT NULL, title_title VARBINARY(255) NOT NULL, -- Naming is hard ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/title_namespace_title ON /*_*/title (title_namespace, title_title); ```

The parent ticket has more information. This table must have immutable rows. The design would be: ```lang=mysql CREATE TABLE /*_*/linktarget ( lt_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL, lt_namespace INT NOT NULL, lt_title VARBINARY(255) NOT NULL, UNIQUE INDEX lt_namespace_title (lt_namespace, lt_title), PRIMARY KEY(lt_id) ) /*$wgDBTableOptions*/; ```

The parent ticket has more information. This table must have immutable rows. The design would be: ```lang=mysql CREATE TABLE /*_*/titlelinktarget ( titlelt_id BIGINT NOT NULL PRIMARY KEYNT UNSIGNED AUTO_INCREMENTNT NOT NULL, titlelt_namespace INT NOT NULL, lt_title VARBINARY(255) NOT NULL, title_title VARBINARY(255) NOT NULLUNIQUE INDEX lt_namespace_title (lt_namespace, -- Naming is hardlt_title), PRIMARY KEY(lt_id) ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/title_namespace_title ON /*_*/title (title_namespace, title_title); ```