Upgrade from version 1 to version 2
Last modified: April 18, 2007 - 07:16
The database structure is changed from version 1 to version 2 of
Localizer for 4.7.x branch.
You must run manually these SQL instructions on your database :
RENAME TABLE localizer TO localizernode;
INSERT INTO localizertranslation
(object_key, object_name, object_field, translation, locale)
SELECT m.mid, IF(m.type=115, 'menu', 'menu_item'), 'title', substring( t.translation, 1, 255 ) , t.locale
FROM locales_source s
INNER JOIN locales_target t ON s.lid = t.lid
INNER JOIN menu m ON substring( s.source, 1, 255 ) = m.title
WHERE m.type IN (115,118) AND substring( t.translation, 1, 255 )<>'';
INSERT INTO localizertranslation
(object_key, object_name, object_field, translation, locale)
SELECT td.tid, 'taxonomy_term', 'name', substring( t.translation, 1, 255 ) , t.locale
FROM locales_source s
INNER JOIN locales_target t ON s.lid = t.lid
INNER JOIN term_data td ON substring( s.source, 1, 255 ) = td.name
WHERE substring( t.translation, 1, 255 )<>'';
INSERT INTO localizertranslation
(object_key, object_name, object_field, translation, locale)
SELECT v.vid, 'taxonomy_vocabulary', 'name', substring( t.translation, 1, 255 ) , t.locale
FROM locales_source s
INNER JOIN locales_target t ON s.lid = t.lid
INNER JOIN vocabulary v ON substring( s.source, 1, 255 ) = v.name
WHERE substring( t.translation, 1, 255 )<>'';