https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113724
Revision: 113724
Author: nikerabbit
Date: 2012-03-13 15:22:00 +0000 (Tue, 13 Mar 2012)
Log Message:
-----------
File missing from previous commit.
Database suitable for shared tm setups, including field for origin wiki
Added Paths:
-----------
trunk/extensions/Translate/sql/translate_sharedtm.sql
Added: trunk/extensions/Translate/sql/translate_sharedtm.sql
===================================================================
--- trunk/extensions/Translate/sql/translate_sharedtm.sql
(rev 0)
+++ trunk/extensions/Translate/sql/translate_sharedtm.sql 2012-03-13
15:22:00 UTC (rev 113724)
@@ -0,0 +1,38 @@
+-- Version of translation memory tables suitable for shared use between wikies
+
+-- Source texts
+DROP TABLE IF EXISTS /*_*/translate_tms;
+CREATE TABLE /*_*/translate_tms (
+ tms_sid int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
+ -- Identifier from which wiki this came from
+ tms_wiki varchar(20) binary NOT NULL,
+ -- 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 default ''
+) /*$wgDBTableOptions*/;
+
+CREATE INDEX /*i*/tms_wiki_lang_len ON /*_*/translate_tms (tms_wiki, 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;
+
+CREATE FULLTEXT INDEX /*i*/tmf_text ON /*_*/translate_tmf (tmf_text);
Property changes on: trunk/extensions/Translate/sql/translate_sharedtm.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
