MLEB/Translate/sql/translate_reviews.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

-- Translation reviews; to store reviews of a page revision by a user.
CREATE TABLE /*$wgDBprefix*/translate_reviews (
  trr_user int NOT NULL,

  -- Link to page.page_id
  trr_page int NOT NULL,

  -- Link to revision.rev_id
  trr_revision int NOT NULL
) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/trr_user_page_revision ON /*$wgDBprefix*/translate_reviews
(trr_user, trr_page, trr_revision);