/*Export of the extension translation.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1206732392OZUR','1304525968YBL','1300365988IROS','1210244259NSBI','1208950213FHRR','1206732392OZVI','1208950213FHRP','1242282414LZMG','1206732400OXBR','1206732392OZVH','1206732405TIXB','1206732392OZVB','1206732405TIXE','1206961869IGND','1206732392OZVG','1377881105KITH','1377881105KITI','1377884822CGHP','1377884822CGHQ','1377884822CGHR','1377884822CGHS','1377884822CGHT','1377884822CGHU','1206732400OWYY','1206961912MJQB','1206732405TIXI','1213107638BOKF','1213107638BOKE','1222791260AEAH','1243437923JGCO','1299729381ESIJ','1242822624LPVI','1206732393CXVV','1206732405TIXA','1209481169RSAA','1206732391QBUR','1206732399EINF','1206732392OZUP','1220793710GXYB','1242282449PIPC','1228820287MBVC','1206732399EINB','1206732361LXFE','1206961882TDHA','1206732405TIXD','1206732392OZVA','1210244259NSBG','1210244259NSBH','1206961849MVDJ','1206732400OWXG','1206732425HINY','1206961996STAF','1355517778ONQV','1377881105KITG','1231731000EGWA','1230531895KYXL','1406947505JYOT','1210244259NSAY','1210244259NSBB','1206732404ORZX','1206732392OZUS','1260151225DTCL','1210244259NSBA','1210244259NSBD','1210244259NSBF','1227580115NTZD','1222791260AEAI','1212843247FGZJ','1414850054FLWV','1414850054FLWW','1219769913SSNZ','1414850054FLWX','1206732400OWXQ','1260151226HJVF','1260151226HJVG','1339210691PDVJ','1339210691PDVK','1206732372QTKI','1206732372QTKJ','1206732372QTKR','1206732398LZKD','1206732404ORZG','1206732404ORZN','1213020853MLHS','1213107637HXCR','1213285236EJWF','1213285236EJWG','1227580123BQHZ','1227580123BQIA','1239875557LNEW','1240842525LJTR','1260151166CSBW','1260151224KRNI','1260151224KRNJ','1260151225DTCK','1260434893HJHQ','1299160210HQTQ','1302662638LHBZ','1313753405ECNO','1377884821GSJD','1382065678OBIQ','1403539630BAFA','1403539630BAFB','1403539630BAFC','1414850052DQVU' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('translation.reference','translation.populate','translation.en','engine.languages') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('translation.reference','engine.languages','translation.populate','translation.en','extension.node','joobi.languages','dataset.columns','engine.node','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','dropset.valuestrans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('5publish','5folder','5wid','5params','5status','5type','5name','199lgid','199code','199premium','199name','199main','199publish','199real','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','5parent','511wid','511load','5trans','484description','5certify','5namekey','5version','5lversion','529engine','529publish','529lgid','529ref_lgid','529ordering','529engid','199rtl','541vid','541name','5pref','541lgid','481wname','481wdescription','5rolid','5install','199availadmin','199availsite','616dbcid','616dbtid','616name','616pkey','616checkval','616type','616attributes','616mandatory','616default','616ordering','616level','616rolid','616created','618sid','618lgid','618name','199locale','616extra','616size','616export','199localeconv','616namekey','ordering5','core5','core616','imac511','modified5','columntype616','712dbcid','712eid','imac712','713imac','text713','auto713','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto618','fromlgid618','auto714','fromlgid714','wid712','952engid','type952','publish952','created952','modified952','location952','alternative952','limitation952','server952','params952','password952','alias952','nbchars713','reload5','core199','noaudit616','created5','automatic199','showconfig5','framework5','message485') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__dataset_foreign`.* FROM `#__dataset_columns` LEFT JOIN `#__dataset_foreign` ON `#__dataset_foreign`.`feid` = `#__dataset_columns`.`dbcid` WHERE `#__dataset_columns`.`namekey` IN ('511wid','529engine','529lgid','imac511','712dbcid','wid712') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_translation_reference_wid','FK_translation_engine_engid','FK_translation_engine_lgid','dbcid populate column','FK_translation_reference_imac','translation_populate_extension_wid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('translation.node') ;
SET @rolid_0 = (1);
SET @pk_549_511 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.reference' LIMIT 1 );
SET @pk_549_529 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='engine.languages' LIMIT 1 );
SET @pk_549_712 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.populate' LIMIT 1 );
SET @pk_549_713 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.en' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_616 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.columns' LIMIT 1 );
SET @pk_549_952 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='engine.node' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_991 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ira.members' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_541 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1 );
SET @pk_549_740 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.source' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('translation_reference','translation.reference',@pk_549_511,'','1.0.0',@rolid_0,'0','30','wid,imac','reference','translation','11','0','2','0','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('engine_languages','engine.languages',@pk_549_529,'','1.0.0',@rolid_0,'0','1','englgid','languages','engine','11','2','0','0','7'),('translation_populate','translation.populate',@pk_549_712,'','',@rolid_0,'0','1','dbcid,eid','populate','translation','11','0','2','1','7'),('translation_en','translation.en',@pk_549_713,'','',@rolid_0,'0','1','imac','en','translation','11','2','0','0','5'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('dataset_columns','dataset.columns',@pk_549_616,'','1.0.0',@rolid_0,'0','1','dbcid','columns','db','9','0','1','1','7'),('engine_node','engine.node',@pk_549_952,'','',@rolid_0,'0','1','engid','','','11','2','0','0','5'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('ira_members','ira.members',@pk_549_991,'','',@rolid_0,'0','1','ira_id','','','51','2','0','0','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('dropset_valuestrans','dropset.valuestrans',@pk_549_541,'','1.0.0',@rolid_0,'0','20','vid,lgid','valuestrans','dropset','9','0','0','1','7'),('translation_source','translation.source',@pk_549_740,'','',@rolid_0,'0','20','srtrid','source','translation','11','2','0','0','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.reference' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.populate' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.en' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='engine.languages' LIMIT 1);
SET @pk_454_65443 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_reference_wid_imac' LIMIT 1 );
SET @pk_454_65635 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_populate|main_translation' LIMIT 1 );
SET @pk_454_65636 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_en|main_translation' LIMIT 1 );
SET @pk_454_65852 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_reference_load' LIMIT 1 );
SET @pk_454_65868 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_engine_lgid_ref_lgid' LIMIT 1 );
SET @pk_454_65891 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IK_translation_populate_wid' LIMIT 1 );
SET @pk_454_65914 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_engine_languages|main_translation' LIMIT 1 );
SET @pk_454_66158 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='ix_translation_en_nbchars' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65443,'3','PK_translation_reference_wid_imac',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65635,'3','PK_translation_populate|main_translation',@dbtid_2),(@pk_454_65636,'3','PK_translation_en|main_translation',@dbtid_3),(@pk_454_65852,'2','IX_translation_reference_load',@dbtid_1),(@pk_454_65868,'2','IX_translation_engine_lgid_ref_lgid',@dbtid_4),(@pk_454_65891,'2','IK_translation_populate_wid',@dbtid_2),(@pk_454_65914,'3','PK_engine_languages|main_translation',@dbtid_4),(@pk_454_66158,'2','ix_translation_en_nbchars',@dbtid_3);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1);
SET @pk_616_3488 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1 );
SET @pk_616_3490 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511load' LIMIT 1 );
SET @pk_616_3617 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529lgid' LIMIT 1 );
SET @pk_616_3618 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529ref_lgid' LIMIT 1 );
SET @pk_616_3620 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529engid' LIMIT 1 );
SET @pk_616_6377 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' LIMIT 1 );
SET @pk_616_6778 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='712dbcid' LIMIT 1 );
SET @pk_616_6779 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='712eid' LIMIT 1 );
SET @pk_616_6781 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1 );
SET @pk_616_7134 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid712' LIMIT 1 );
SET @pk_616_8758 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='nbchars713' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_6003 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbcid' LIMIT 1 );
SET @pk_616_8679 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='952engid' LIMIT 1 );
SET @pk_616_3615 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529engine' LIMIT 1 );
SET @pk_616_3616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529publish' LIMIT 1 );
SET @pk_616_3619 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529ordering' LIMIT 1 );
SET @pk_616_6780 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac712' LIMIT 1 );
SET @pk_616_6782 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='text713' LIMIT 1 );
SET @pk_616_6783 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto713' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_3412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482name' LIMIT 1 );
SET @pk_616_3413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482description' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_3717 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541name' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_3488,@dbtid_1,'wid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','511wid','1','0','0');
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_3490,@dbtid_1,'load','0','0','25','0','1','0','3','1',@rolid_0,'0','0','1','511load','1','0','0'),(@pk_616_3617,@dbtid_4,'lgid','0','0','1','1','1','0','4','1',@rolid_0,'0','0','1','529lgid','1','0','0'),(@pk_616_3618,@dbtid_4,'ref_lgid','0','0','1','1','1','0','5','1',@rolid_0,'0','0','1','529ref_lgid','1','0','0'),(@pk_616_3620,@dbtid_4,'englgid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','529engid','1','0','0'),(@pk_616_6377,@dbtid_1,'imac','1','1','14','0','1','','4','0','0','0','255','1','imac511','1','0','0'),(@pk_616_6778,@dbtid_2,'dbcid','1','0','4','1','1','','1','0','0','0','0','1','712dbcid','1','0','0'),(@pk_616_6779,@dbtid_2,'eid','1','0','4','1','1','','2','0','0','0','0','1','712eid','1','0','0'),(@pk_616_6781,@dbtid_3,'imac','1','0','4','1','1','','1','0','0','1','0','1','713imac','1','0','0'),(@pk_616_7134,@dbtid_2,'wid','0','0','3','1','1','','4','0','0','0','0','1','wid712','1','0','0'),(@pk_616_8758,@dbtid_3,'nbchars','0','1','4','1','1','0','4','0','0','0','0','0','nbchars713','1','0','0'),(@pk_616_81,@dbtid_5,'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_1698,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_6003,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.columns' LIMIT 1),'dbcid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','616dbcid','1','0','0'),(@pk_616_8679,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='engine.node' LIMIT 1),'engid','1','0','4','1','1','','1','0','0','1','0','1','952engid','1','0','0'),(@pk_616_3615,@dbtid_4,'engid','0','0','1','1','1','0','2','1',@rolid_0,'0','0','1','529engine','1','0','0'),(@pk_616_3616,@dbtid_4,'publish','0','0','1','0','1','1','3','1',@rolid_0,'0','0','1','529publish','1','0','0'),(@pk_616_3619,@dbtid_4,'ordering','0','0','1','1','1','0','6','1',@rolid_0,'0','0','1','529ordering','1','0','0'),(@pk_616_6780,@dbtid_2,'imac','0','1','14','0','1','','3','0','0','0','50','1','imac712','1','0','0'),(@pk_616_6782,@dbtid_3,'text','0','1','16','0','1','','2','0','0','0','0','1','text713','1','0','0'),(@pk_616_6783,@dbtid_3,'auto','0','1','1','1','1','1','3','0','0','0','0','0','auto713','1','0','0'),(@pk_616_6039,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','618name','1','0','0'),(@pk_616_3412,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3419,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_6797,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_10823,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'message','0','1','16','0','1','','5','0','0','0','0','1','message485','1','0','0'),(@pk_616_3416,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3507,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3408,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_3717,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','541name','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0');
SET @pk_5_88 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='translation.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='translation',`wid`=@pk_5_88,`params`='',`status`='1',`type`='150',`name`='Translation',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='translation.node',`version`='4705',`lversion`='4705',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='translation.node';
INSERT IGNORE INTO `#__extension_node` (`publish`,`folder`,`wid`,`params`,`status`,`type`,`name`,`destination`,`parent`,`trans`,`certify`,`namekey`,`version`,`lversion`,`pref`,`install`,`core`,`showconfig`,`framework`) VALUES ('1','translation',@pk_5_88,'','1','150','Translation','node','0','1','1','translation.node','4705','4705','1','','1','1','0');

SET @pk_621_411 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.en' LIMIT 1 );
SET @pk_621_413 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.populate' LIMIT 1 );
SET @pk_621_511 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.reference' LIMIT 1 );
SET @pk_621_529 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='engine.languages' LIMIT 1 );
SET @pk_621_199 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1 );
SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_1138 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='irasubmission' LIMIT 1 );
SET @pk_621_778 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.source' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_411,`dbtid`=@dbtid_3,`path`='1',`namekey`='translation.en',`folder`='translation.en',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='translation',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-language',`pnamekey`='' WHERE  `namekey`='translation.en';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_411,@dbtid_3,'1','translation.en','translation.en',@rolid_0,'0','1','0','0','','','translation','0','0','1','fa-language','');
UPDATE `#__model_node`  SET `sid`=@pk_621_413,`dbtid`=@dbtid_2,`path`='0',`namekey`='translation.populate',`folder`='translation.populate',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='translation',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='translation.populate';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_413,@dbtid_2,'0','translation.populate','translation.populate',@rolid_0,'0','1','0','0','','','translation','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_511,`dbtid`=@dbtid_1,`path`='0',`namekey`='translation.reference',`folder`='translation.reference',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='translation',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='translation.reference';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_511,@dbtid_1,'0','translation.reference','translation.reference',@rolid_0,'0','1','0','0','','','translation','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_529,`dbtid`=@dbtid_4,`path`='0',`namekey`='engine.languages',`folder`='translation.engine',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1',`alias`='',`prefix`='translation',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='engine.languages';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_529,@dbtid_4,'0','engine.languages','translation.engine',@rolid_0,'0','1','0','0','ordrg=1','','translation','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_199,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),`path`='0',`namekey`='library.languages',`folder`='library.languages',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-language',`pnamekey`='' WHERE  `namekey`='library.languages';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_199,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),'0','library.languages','library.languages',@rolid_0,'0','1','0','0','','','joobi','0','0','1','fa-language','');
UPDATE `#__model_node`  SET `sid`=@pk_621_999,`dbtid`=@dbtid_5,`path`='0',`namekey`='apps',`folder`='apps',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='apps';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_999,@dbtid_5,'0','apps','apps',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','apps','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1138,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ira.members' LIMIT 1),`path`='1',`namekey`='irasubmission',`folder`='irasubmission',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='irasubmission',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='irasubmission';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1138,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ira.members' LIMIT 1),'1','irasubmission','irasubmission',@rolid_0,'0','1','0','0','autofld=1','','irasubmission','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_778,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.source' LIMIT 1),`path`='0',`namekey`='translation.source',`folder`='translation.source',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='translation',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='translation.source';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_778,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.source' LIMIT 1),'0','translation.source','translation.source',@rolid_0,'0','1','0','0','autofld=1','','translation','0','0','1','','');

SET @wid_6 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='translation.node' LIMIT 1);
SET @sid_7 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1);
SET @sid_8 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.en' LIMIT 1);
SET @rolid_9 = (7);
SET @rolid_10 = (3);
SET @rolid_11 = (8);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_import' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_export' LIMIT 1);
SET @yid_14 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_node_transle_name' LIMIT 1);
SET @yid_15 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_number_format' LIMIT 1);
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_form_lang' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_listing' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_language' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='translation_listing_lang' LIMIT 1);
SET @did_20 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='translation_auto' LIMIT 1);
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Item','1','1206732372QTKR'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('Translation','1','1206732392OZUR'),('Languages','1','1206732392OZUS'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Description','1','1206732392OZVG'),('Status','1','1206732392OZVH'),('status','1','1206732392OZVI'),('Cancel','1','1206732393CXVV'),('Hide/show status','1','1206732398LZKD'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('Direct Edit','1','1206732400OWXQ'),('Text','1','1206732400OWYY'),('Application','1','1206732400OXBR'),('Your translation file has been successfully sent to Joobi Team.  The file will be included in the next release.','1','1206732404ORZG'),('The provided file is not an ini file and cannot be imported.','1','1206732404ORZN'),('List of Translation','1','1206732404ORZX'),('Import','1','1206732405TIXA'),('Export','1','1206732405TIXB'),('Vocabulary','1','1206732405TIXD'),('Language','1','1206732405TIXE'),('Load the file containing the translation of the application','1','1206732405TIXI'),('Admin','1','1206732425HINY'),('Site','1','1206961849MVDJ'),('hidden','1','1206961869IGND'),('Back','1','1206961882TDHA'),('Code','1','1206961912MJQB'),('Available','1','1206961996STAF'),('Origin Language','1','1208950213FHRP'),('Destination Language','1','1208950213FHRR'),('Synchronize','1','1209481169RSAA'),('Language Import','1','1210244259NSAY'),('Import a language file','1','1210244259NSBA'),('Language Export','1','1210244259NSBB'),('Export a language file','1','1210244259NSBD'),('Languages list','1','1210244259NSBF'),('English','1','1210244259NSBG'),('Native','1','1210244259NSBH'),('Language File to Import','1','1210244259NSBI'),('This view shows a list of languages.  If the language is marked as \"Available\" then this language is available on your site.<br>Please note that a language available does not necessarily means that it is available for all applications.<br><br>The columns \"Site\" and \"Admin\" indicate if the language is available on for the CMS respectively in the front-end (Site) or back-end (Admin) of the website.<br><br><span style=\"text-decoration: underline; color: rgb(0, 0, 153);\">MENU:</span> <br><ul><li>The \"<span style=\"font-weight: bold;\">Synchronize</span>\" button enables you to synchronize the languages available with the CMS.</li><li><span style=\"font-weight: bold;\">Export</span>: use to export the language file for an application so that you can edit the translation.</li><li><span style=\"font-weight: bold;\">Import</span>: use to import the modified language file.<br></li></ul>','1','1212843247FGZJ'),('Thank you very much for your contribution!','1','1213020853MLHS'),('The list of available languages has been synchronized with the site.','1','1213107637HXCR'),('Specify the language you want to take as the origin language from which you want to translate.','1','1213107638BOKE'),('Specify the language in which you want to translate the application.<br />It is important that you specify this language so that we can optimize the exported file so that you do not have to translate something which is already translated.','1','1213107638BOKF'),('There was an error sending the file.  Please send the file by email to: $EMAIL .','1','1213285236EJWF'),('This language is already available in the general release for this application. The translation was not sent.  If you feel like the translation need to be corrected and you want to submit your file please send it to the Joobi Team by email at: $EMAIL .','1','1213285236EJWG'),('Automatic Translation','1','1219769913SSNZ'),('Translations','1','1220793710GXYB'),('Specify the format you want to export your data:<br><ul><li>ini file</li><li>html file<br></li></ul>','1','1222791260AEAH'),('This form enables you to create a language file, so that you can translate the file and then import it.<br><ol><li>Select the original language.  <br></li><li>Define the language in which you want to translate.</li></ol><span style=\"text-decoration: underline; color: rgb(0, 0, 255);\">NOTE:</span> The best <span style=\"font-weight: bold;\">original language</span> to choose is <span style=\"font-weight: bold;\">English</span> since all application have originally been developed in English.  If you take any other language you might translate something which has already been translated and therefore <span style=\"font-style: italic;\">loose accuracy</span>.','1','1222791260AEAI'),('Use this form to import a language file.  The file should be in the same format as it has been exported with the Export menu.<br><ul><li>After importing your language file, you may want to share your translation with the community... To do so, please click on the button \"Share\".<br></li></ul>','1','1227580115NTZD'),('Language already translated','1','1227580123BQHZ'),('Translation file Uploaded','1','1227580123BQIA'),('Close','1','1228820287MBVC'),('Auto','1','1230531895KYXL'),('Automatic','1','1231731000EGWA'),('Translations successfully installed','1','1239875557LNEW'),('Dictionnary successfully loaded','1','1240842525LJTR'),('Format','1','1242282414LZMG'),('Done','1','1242282449PIPC'),('Select the language for which you would like to translate.','1','1242822624LPVI'),('Select the application you want to export<br>','1','1243437923JGCO'),('Click here to go back to the languages listing','1','1260151166CSBW'),('Language installation completed','1','1260151224KRNI'),('Looking for translations...','1','1260151224KRNJ'),('install','1','1260151225DTCK'),('Language install','1','1260151225DTCL'),('translation_install','1','1260151226HJVF'),('translation_installexec','1','1260151226HJVG'),('There are no logs available at this time. Please check again later.','1','1260434893HJHQ'),('The following model or table does not exist :$MODEL','1','1299160210HQTQ'),('Specify if you want to export all strings or only non translated strings.<br>','1','1299729381ESIJ'),('Engine Languages','1','1300365988IROS'),('Import Failed. Wrong format of the import text.','1','1302662638LHBZ'),('','1','1304525968YBL'),('The Language you are trying to import is not available in Joobi Languages. Language Code: ','1','1313753405ECNO'),('Translate a Form Element','1','1339210691PDVJ'),('Save of the element translation','1','1339210691PDVK'),('Date Of Birth','1','1355517778ONQV'),('Symbol After','1','1377881105KITG'),('Symbol Before','1','1377881105KITH'),('Number of decimal','1','1377881105KITI'),('Format successfully updated!','1','1377884821GSJD'),('Decimal symbol','1','1377884822CGHP'),('Thousands symbol','1','1377884822CGHQ'),('Negative Sign Before','1','1377884822CGHR'),('Negative Sign symbol','1','1377884822CGHS'),('Space Before Negative Sign','1','1377884822CGHT'),('Space After Symbol','1','1377884822CGHU'),('The language format could not be changed!','1','1382065678OBIQ'),('The HTML has as an error of syntax and could not be parsed.','1','1403539630BAFA'),('The text into the HTML tag is too long so it got cut at sentence punctuation but that could break the HTML syntax.','1','1403539630BAFB'),('One of the sentence is too long so the translation might not be exact.','1','1403539630BAFC'),('Define if the language should be used in the pick list for the automatic translation with google translate.','1','1406947505JYOT'),('The language could not be found therefore the text could not be updated','1','1414850052DQVU');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('App Translation','1','1414850054FLWV'),('User Translated','1','1414850054FLWW'),('App Translation ( dev )','1','1414850054FLWX');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_reference_wid_imac' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_reference_load' LIMIT 1),'1','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511load' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_engine_lgid_ref_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_engine_lgid_ref_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529ref_lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_engine_languages|main_translation' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529engid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_reference_wid_imac' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_populate|main_translation' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='712dbcid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_populate|main_translation' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='712eid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_en|main_translation' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IK_translation_populate_wid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid712' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='ix_translation_en_nbchars' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='nbchars713' LIMIT 1));
SET @pk_77_604 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_5 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'511wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11063 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'engine.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'529engine\' LIMIT 1' LIMIT 1 );
SET @pk_77_10018 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.languages\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'529lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_605 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'imac511\' LIMIT 1' LIMIT 1 );
SET @pk_77_10716 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dataset.columns\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'712dbcid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10783 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_5 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'wid712\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','1','FK_translation_reference_wid',@pk_77_604,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',@dbtid_5,@dbtid_1,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('engid','1','FK_translation_engine_engid',@pk_77_11063,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529engine' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='952engid' LIMIT 1),'3','2','engid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='engine.node' LIMIT 1),@dbtid_4,'1'),('lgid','1','FK_translation_engine_lgid',@pk_77_10018,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='529lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_4,'2'),('imac','1','FK_translation_reference_imac',@pk_77_605,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1),'1','3','imac',@dbtid_3,@dbtid_1,'2'),('dbcid','1','dbcid populate column',@pk_77_10716,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='712dbcid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbcid' LIMIT 1),'1','3','dbcid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.columns' LIMIT 1),@dbtid_2,'1'),('wid','1','translation_populate_extension_wid',@pk_77_10783,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid712' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'1','3','wid',@dbtid_5,@dbtid_2,'2');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_6,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_6,'2','1206732372QTKJ'),(@wid_6,'2','1206732372QTKR'),(@wid_6,'1','1206732392OZVH'),(@wid_6,'1','1206732398LZKD'),(@wid_6,'0','1206732404ORZG'),(@wid_6,'0','1206732404ORZN'),(@wid_6,'0','1213020853MLHS'),(@wid_6,'0','1213107637HXCR'),(@wid_6,'0','1213285236EJWF'),(@wid_6,'0','1213285236EJWG'),(@wid_6,'0','1227580123BQHZ'),(@wid_6,'1','1227580123BQIA'),(@wid_6,'0','1239875557LNEW'),(@wid_6,'1','1240842525LJTR'),(@wid_6,'1','1260151166CSBW'),(@wid_6,'1','1260151224KRNI'),(@wid_6,'1','1260151224KRNJ'),(@wid_6,'1','1260151225DTCK'),(@wid_6,'0','1260434893HJHQ'),(@wid_6,'0','1299160210HQTQ'),(@wid_6,'0','1302662638LHBZ'),(@wid_6,'1','1313753405ECNO'),(@wid_6,'0','1377884821GSJD'),(@wid_6,'0','1382065678OBIQ'),(@wid_6,'0','1403539630BAFA'),(@wid_6,'0','1403539630BAFB'),(@wid_6,'0','1403539630BAFC'),(@wid_6,'0','1414850052DQVU');
SET @dbcid_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_21,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.en' LIMIT 1),'1206732392OZUR',@wid_6);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_21,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.populate' LIMIT 1),'1206732392OZUR',@wid_6),(@dbcid_21,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='translation.reference' LIMIT 1),'1304525968YBL',@wid_6),(@dbcid_21,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='engine.languages' LIMIT 1),'1300365988IROS',@wid_6);