www/wiki/extensions/Translate/sql/revtag.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

-- These tables could go into core someday, but not likely

-- Revision tags
CREATE TABLE /*$wgDBprefix*/revtag (
  rt_type varbinary(60) NOT NULL,

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

  -- Link to revision.rev_id
  rt_revision int NOT NULL,

  rt_value blob NULL
) /*$wgDBTableOptions*/;
-- Index for finding all revisions in a page with a given tag
CREATE UNIQUE INDEX /*i*/rt_type_page_revision ON /*$wgDBprefix*/revtag
(rt_type, rt_page, rt_revision);
-- Index for finding the tags on a given revision
CREATE INDEX /*i*/rt_revision_type ON /*$wgDBprefix*/revtag (rt_revision, rt_type);