1 files changed, 38 insertions, 0 deletions
diff --git a/www/wiki/extensions/Translate/sql/translate_tm.sql b/www/wiki/extensions/Translate/sql/translate_tm.sql
new file mode 100644
index 00000000..99442078
--- /dev/null
+++ b/www/wiki/extensions/Translate/sql/translate_tm.sql
@@ -0,0 +1,38 @@
+-- Since these tables only store secondary data,
+-- it should be safe to drop them from time to time.
+-- MediaWiki itself guarantees sure that this file is run only once.
+
+-- Source texts
+DROP TABLE IF EXISTS /*_*/translate_tms;
+CREATE TABLE /*_*/translate_tms (
+	tms_sid int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+	-- Language code
+	tms_lang varchar(20) binary NOT NULL,
+	-- Lenght of the string in characters
+	tms_len int unsigned NOT NULL,
+	-- The actual text
+	tms_text mediumblob NOT NULL,
+	-- Identifier where this text came from
+	tms_context mediumblob NOT NULL
+) /*$wgDBTableOptions*/;
+
+CREATE INDEX /*i*/tms_lang_len ON /*_*/translate_tms (tms_lang, tms_len);
+
+-- Stored translations
+DROP TABLE IF EXISTS /*_*/translate_tmt;
+CREATE TABLE /*_*/translate_tmt (
+	tmt_sid int unsigned NOT NULL,
+	tmt_lang varchar(20) binary NOT NULL,
+	tmt_text mediumblob NOT NULL
+) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/tmt_sid_lang ON /*_*/translate_tmt (tmt_sid, tmt_lang);
+
+-- Fulltext search index
+DROP TABLE IF EXISTS /*_*/translate_tmf;
+CREATE TABLE /*_*/translate_tmf (
+	tmf_sid int unsigned NOT NULL,
+	tmf_text text
+) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
+
+CREATE FULLTEXT INDEX /*i*/tmf_text ON /*_*/translate_tmf (tmf_text);