From e60b787d78a2c98cb5ffd123b4de0299eb6f784e Mon Sep 17 00:00:00 2001 From: yomguy Date: Mon, 12 Dec 2011 11:29:39 +0100 Subject: [PATCH] add ISO 639-3 import doc --- INSTALL.rst | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) diff --git a/INSTALL.rst b/INSTALL.rst index c450ae1b..ea28b4a6 100644 --- a/INSTALL.rst +++ b/INSTALL.rst @@ -305,6 +305,26 @@ It is possible to login automatically an IP range of machines to Telemeta thanks See http://pypi.python.org/pypi/django-ipauth/ for setup. +---------------------------- +Import ISO 639-3 languages +---------------------------- + +From Telemeta 1.4, an ISO 639-3 language model has been implemented. + +The ISO language table content can be initialized with the official code set. +Here is a import example where telemeta_crem5 is the SQL database:: + + wget http://www.sil.org/iso639-3/iso-639-3_20110525.tab + mysql -u root -p + load data infile 'iso-639-3_20110525.tab' into table telemeta_crem5.languages CHARACTER SET UTF8 ignore 1 lines (identifier, part2B, part2T, part1, scope, type, name, comment); + +If you upgraded Telemeta from a version previous or equal to 1.3, please update the media_items table as follow:: + + mysql -u root -p + use telemeta_crem5 + ALTER TABLE media_items ADD COLUMN 'language_iso_id' integer; + ALTER TABLE 'media_items' ADD CONSTRAINT 'language_iso_id_refs_id_80b221' FOREIGN KEY ('language_iso_id') REFERENCES 'languages' ('id'); + ------------------------- Contact / More infos ------------------------- -- 2.39.5