www/wiki/extensions/Translate/sql/translate_sections.sql


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

-- SQL tables for Translate extension

-- List of each section which has a name and text
CREATE TABLE /*_*/translate_sections (
  -- Key to page_id
  trs_page int unsigned NOT NULL,

  -- Customizable section name
  trs_key varchar(255) binary NOT NULL,

  -- Section contents
  trs_text mediumblob NOT NULL,

  -- Section order
  trs_order int unsigned,

  PRIMARY KEY (trs_page, trs_key)
) /*$wgDBTableOptions*/;

CREATE INDEX /*i*/trs_page_order on /*_*/translate_sections (trs_page, trs_order);