1 files changed, 20 insertions, 0 deletions
diff --git a/www/wiki/extensions/Translate/sql/translate_sections.sql b/www/wiki/extensions/Translate/sql/translate_sections.sql
new file mode 100644
index 00000000..6207ca68
--- /dev/null
+++ b/www/wiki/extensions/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);