diff options
Diffstat (limited to 'MLEB/Translate/sql/translate_sections.sql')
-rw-r--r-- | MLEB/Translate/sql/translate_sections.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/MLEB/Translate/sql/translate_sections.sql b/MLEB/Translate/sql/translate_sections.sql new file mode 100644 index 00000000..6207ca68 --- /dev/null +++ b/MLEB/Translate/sql/translate_sections.sql @@ -0,0 +1,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); |