/*Export of the extension apps.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1267607212GWJP','1298350283NKJB','1298350283NKJC','1298350283NKJD','1298350283NKJE','1298350283NKJF','1298350283NKJG','1298350284IYPA','1299065683HDEE','1319035319DBIP','1389275714NKEJ','1206732400OWZW','1206732392OZVB','1207045653IMAV','1228709213SHFK','1206961869IGND','1206732400OXCC','1206732400OXCI','1206732400OXCG','1206732400OWZR','1206732400OWZT','1425339791AULI','1206732400OXBG','1215507792MTRU','1206732392OZVG','1213353034DMQE','1213353034DMQG','1206961850KLRD','1213369263SAAI','1213369263SAAG','1217930839LUIP','1206961893RSRQ','1217930839LUIT','1228820067NJRT','1229651877RBLW','1229651877RBLX','1206732400OWZO','1206961841DNZP','1385472707OHUT','1228820286IIZC','1242617238FPTT','1369749833QIRZ','1249442156QUCN','1206732392OZVI','1242282443EZXY','1248835373QZQO','1249442156QUCO','1249442156QUCP','1309406593PBSN','1206732392OZUS','1306429442RXVJ','1242282449PIOD','1230531895KYXK','1243392688MXHE','1254100130KOZO','1298350446IEXL','1254100130KOZP','1338573341FLOL','1298294174MWUZ','1298294174MWUY','1298294174MWUX','1229653442FEQZ','1298294169DGIW','1298350446IEXU','1298350446IEXV','1298350446IEXW','1298350446IEXX','1298350446IEXY','1299215253RNKY','1290670039OOGW','1300844255DUTL','1242282435FMDW','1312946243NCTM','1314355378KUGY','1317387080ATEF','1318938393NAXT','1206732400OXBR','1220793710GXYB','1336262893OKNO','1242282450QJCF','1338338319GRMW','1338338319GRMX','1338338319GRMY','1338338319GRMZ','1234467597SEXO','1338338319GRNA','1338338319GRNB','1338338319GRNC','1338404993PTOB','1338404993PTOC','1338404993PTOD','1338404993PTOE','1428084291QKNE','1338573341FLON','1341595702FCVU','1345820470LDJX','1206961854HENY','1347651808CPWG','1206732400OWXQ','1347659841ODKB','1348621630FUBX','1298350843FMVJ','1352764986KJXE','1352764986KJXF','1352764986KJXG','1357696806PVXX','1358515337PTMS','1359165405DSBB','1359165405DSBC','1359654993NSKL','1360922246IVLU','1369749833QISA','1369749833QISB','1373207636DEVB','1375816538MEST','1375816538MESU','1375816538MESV','1242282413PMPV','1381500332FVXY','1385472707OHUU','1212761242DPBP','1389293018JFMA','1389386704BRFY','1389902747HCAE','1390561315MZSB','1213285196AFGY','1416812826GUVH','1394069593IQAQ','1394069593IQAS','1394069593IQAT','1217930839LUIR','1395437821GPTR','1395437821GPTS','1395437821GPTT','1398375022BJSW','1406645123NWLK','1219769913SSOH','1407272965STVB','1411052475FVUA','1411052475FVUB','1206961850KLRI','1416385932KENZ','1416812826GUVI','1416812826GUVJ','1421617710FQCB','1422973803PSLT','1423597825SYTZ','1242282417SQLW','1242282413PMNC','1425956837EQIA','1426726336DHKC','1426800196HAOH','1209674948GCLL','1206732392OZVH','1427652796LGUR','1428084291QKNF','1429564806LXTQ','1429564806LXTR','1389275715RJLN','1304525968YBL','1229651877RBLQ','1229651877RBLS','1213107632HHOS','1213107632HHOT','1428084291QKNG','1418159312IWLR','1338573341FLOO','1242617238FPTQ','1242617238FPTR','1217930839LUIO','1299215254OXTM','1338573341FLOP','1229651877RBLT','1229651877RBLU','1426511377ENBT','1230874957AEGZ','1385472708HAZN','1213369263SAAF','1369749834AAQQ','1249442155KSPX','1249442155KSPY','1249442155KSPZ','1426800196HAOI','1393953514CMZC','1250777204RIAD','1250777204RIAE','1257940976WWP','1254100130KOZM','1254100130KOZN','1251988094BIBR','1271819434SRVJ','1298350453HVAO','1217930839LUIS','1300434114HUML','1300434114HUMM','1309406599MYMN','1312946249DMIW','1298350449IJXC','1317387083CYMJ','1336262894HGBM','1338338320KGPY','1338338320KGPZ','1338404993PTOF','1338338320KGQB','1338338320KGQC','1338338320KGQD','1338338320KGQE','1338404993PTOG','1338404993PTOH','1338404993PTOI','1338338320KGQA','1338573342KOJF','1357387110MLJN','1341595703RHEE','1345820471OJLX','1416812826GUVK','1347659842QEDP','1348621630FUBY','1314355381EEUK','1358515338ECWC','1359165405DSBD','1360922246IVLV','1359654993NSKM','1369749834AAQR','1369749834AAQS','1395437821GPTU','1375816539HXMZ','1375816539HXNA','1381500333LIEA','1238171067TJFA','1422973804PMJX','1416812826GUVL','1395437822MMRI','1390561316LWBW','1395437822MMRJ','1398375023DTKE','1406645123NWLM','1411052475FVUC','1411052475FVUD','1416385933AEDN','1416812826GUVM','1416812826GUVN','1373207637APRU','1423597826QYJU','1304526022JRUH','1427652797LLYT','1213107622JALA','1429564807KXRS','1436323210NDIP','1206732399EINB','1206732393CXVV','1206732399EINH','1357296145DBZH','1206732399EINF','1242282449PIPC','1206732400OWXC','1206732391QBUR','1230529131MQQP','1206961882TDHA','1206732372QTKM','1229651877RBLY','1206732411EGRN','1211280056BEZM','1206732400OWXE','1206732420EIUT','1206961905BHAV','1310984711PXOI','1206732392OZUP','1206732365OQJK','1206732372QTKL','1337190875QXBD','1356698583QHNC','1242282443EZZS','1240912077BELS','1206732392OZVF','1206732392OZVA','1208193651IFKI','1206732405TIXE','1206961849MVDJ','1227579895DRET','1252569179LCYI','1242282416HAOE','1252569179LCYJ','1304258958RSVK','1206732421RJQC','1206732411EGRY','1267764045MNMG','1206961899DDKO','1267764045MNMH','1206961912MJQB','1206961996STAF','1206732425HINY','1206961997BSYJ','1206732361LXFE','1389879775LPOL','1240388999GQSW','1206732399EIMX','1389275715RJLO','1229651878KNMW','1213183509OYOB','1227580613HBMJ','1227580613HBMK','1206732400OWXK','1298350285IISM','1206961841DNYR','1249442157SIBQ','1253200893CXZC','1252569179LCYL','1267764046CYTO','1389123468CKOO','1421617712NRTN','1208362898QACD','1389275716SJHL','1389293018JFMB','1210244238DTYK','1229651878KNMZ','1219770756BFUL','1326997166FYVE','1326997166FYVF','1380037279FKRS','1418159313RUIV','1230874957AEHC','1229651878KNMX','1227579895DREU','1229651878KNMY','1230874957AEHD','1271818792LETO','1418159313RUIW','1418159313RUIX','1242282417SQNR','1411052474RANJ','1411052474RANK','1411052474RANL','1411052474RANM','1421617713IRWT','1421617713IRWU','1421617713IRWV','1206732410ICCJ','1357387105DGOO','1231158811CQTU','1428084293SVQZ','1251534480QHPE','1298350286CSUD','1298350286CSUE','1298350286CSUF','1251857784QRWO','1252569179LCYK','1252569180FERI','1252894206NMXU','1252894206NMXV','1304916603TJKB','1306926884BHVV','1310984741ESTO','1319072839DDDJ','1338573342KOJG','1342037592PDAA','1345316856HADW','1345316856HADX','1206732393CXVX','1206732393CXVY','1206732394IZGY','1206732394IZHB','1206732395DOFD','1206732397TAXO','1206732397TAXY','1206732397TAYG','1206732398LZJD','1206961836KSBJ','1206961836KSBK','1206961836KSBL','1206961944PEUR','1209746216SXQF','1213020848LZMA','1213020848LZMB','1213020848LZMC','1213020848LZME','1213020848LZMF','1213020853MLHQ','1213107637HXCS','1215710386RMJC','1215710386RMJD','1227579883OZMZ','1227580898LIDX','1229651871ADBG','1229651871ADBH','1229651871ADBI','1232547361JEQR','1235976558LLLB','1235976558LLLC','1235976558LLLD','1245769651NPXC','1247466190MROL','1248835367AECZ','1248948187IFCW','1249562683MMMY','1249567958KVAQ','1251770410PASS','1251770410PAST','1251905717NHWT','1251905717NHWU','1251905717NHWW','1251905718PEOQ','1251905719IQBZ','1251905719IQCA','1251912852OWAG','1251959063BNBJ','1260434893HJHQ','1260434893HJHR','1260443578NNAV','1298294128HPXJ','1298294128HPXK','1298294132BJZM','1298350280PMMA','1303354916DPMU','1337190873HKCO','1338581028LZCR','1338581054ANGS','1338581054ANGT','1338581054ANGU','1338581058MKNK','1342037586EZIY','1347915878MZME','1349115733NNHN','1357059110IPWM','1357387105DGOP','1357567981LCEH','1359218479BLAZ','1377109823CPMJ','1377368277IDOY','1377368277IDOZ','1378928005HOHD','1378928005HOHE','1389125413BAER','1389275707OUAK','1389275708EKXJ','1389293010DETE','1389293010DETJ','1389439751KWKS','1389656307QIHM','1389656307QIHN','1389701736EXGV','1389701736EXGW','1389701736EXGX','1389701736EXGY','1389701736EXGZ','1389879769JPHN','1392062121NBKP','1401297229KKPC','1413479920LDPJ','1413479920LDPK','1413490911HRES','1415107844LLSU','1418159317GYIO','1418159318SHOQ','1425662174IZVW','1426726331GHCC','1427652792LBWK','1427652792LBWL','1427652792LBWM','1427652792LBWN','1427652792LBWO','1427652792LBWP','1427652792LBWQ','1427652792LBWR','1427652792LBWS','1427652793DOXK','1427652793DOXL','1427652793DOXM','1427652793DOXN','1427652793DOXO','1427652793DOXP','1427833134LQDZ','1428532729DJHL','1429064415HVOW','1429238504IKNA','1429564804LHII','1431936850KAHW','1432597449CAIM','1432597449CAIN','1433250437OEYO' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('extension.level','extension.version','extension.node','extension.trans','extension.dependency','extension.languages','extension.leveltrans','extension.userinfos','extension.info','extension.translation') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('extension.node','extension.trans','extension.dependency','extension.languages','extension.version','extension.level','extension.leveltrans','extension.userinfos','extension.info','extension.translation','members.node','joobi.files','joobi.languages','role.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','232uid','478filid','478modified','478name','478params','478path','478size','478type','287wid','287lgid','287description','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','352wid','352ref_wid','478secure','478uid','232html','232registered','199name','199main','199publish','199real','478thumbnail','478theight','478twidth','478width','478height','423lgid','423wid','478approved','478modifiedby','232unsub','473vsid','473wid','473version','473status','478mime','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','5parent','509lwid','509wid','509level','510lwid','510lgid','510description','5trans','484description','5certify','509status','5namekey','232login','5version','5lversion','199rtl','423available','423translation','541vid','541name','5pref','541lgid','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','5rolid','566type','5install','199availadmin','199availsite','618sid','618lgid','618name','199locale','566depth','199localeconv','ordering5','core5','namekey509','enable657','wid657','662wid','author662','documentation662','images662','flash662','support662','forum662','homeurl662','joomlafeedback662','created473','visibility232','userversion662','userlversion662','level657','license657','modified5','token657','ltype657','expire657','maintenance657','beta662','beta473','flag657','714ctrid','714lgid','name714','description714','description485','auto287','fromlgid287','auto481','fromlgid481','auto510','fromlgid510','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto618','fromlgid618','auto714','fromlgid714','curid232','md5478','filid473','level473','modified473','uid473','encoding473','changelog473','final473','sha1473','code473','marketing473','j16566','completed423','automatic423','manual423','totalimac423','alias478','vendid478','981wid','981lgid','modifiedby981','modified981','core478','storage478','folder478','ip232','ctyid232','reload5','core199','created5','subtype657','keyword662','mobile232','filid232','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 ('287wid','287lgid','352wid','352ref_wid','423lgid','423wid','473wid','5parent','509wid','510lwid','510lgid','5rolid','wid657','662wid','filid473','uid473','981wid','981lgid') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_extension_trans_lgid','FK_extension_trans_wid','FK_extension_dependency_ref_wid','FK_extension_dependency_wid','FK_extension_languages_lgid','FK_extension_languages_wid','FK_package_version_wid','FK_model_level_wid','FK_extension_leveltrans_lgid','FK_extension_leveltrans_lwid','FK_Parent5_parentwid','FK_extension_rolid','FK_extension_info_wid','FK_apps_translation_lgid','FK_apps_translation_wid','FK_extenversion_filid','473_uid_232','FK_extensionEnabled_wid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('apps.node') ;
SET @rolid_0 = (1);
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_287 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.trans' LIMIT 1 );
SET @pk_549_352 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.dependency' LIMIT 1 );
SET @pk_549_423 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.languages' LIMIT 1 );
SET @pk_549_473 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.version' LIMIT 1 );
SET @pk_549_509 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.level' LIMIT 1 );
SET @pk_549_510 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.leveltrans' LIMIT 1 );
SET @pk_549_657 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' LIMIT 1 );
SET @pk_549_662 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.info' LIMIT 1 );
SET @pk_549_981 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.translation' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.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_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_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 ('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('extension_trans','extension.trans',@pk_549_287,'','1.0.0',@rolid_0,'0','20','wid,lgid','trans','extension','9','2','0','1','7'),('extension_dependency','extension.dependency',@pk_549_352,'','1.0.0',@rolid_0,'0','30','wid,ref_wid','dependency','extension','9','2','0','1','7'),('extension_languages','extension.languages',@pk_549_423,'','1.0.0',@rolid_0,'0','30','wid,lgid','languages','extension','9','2','0','1','7'),('extension_version','extension.version',@pk_549_473,'','1.0.0',@rolid_0,'0','1','vsid','version','extension','9','2','0','0','7'),('extension_level','extension.level',@pk_549_509,'','1.0.0',@rolid_0,'0','1','lwid','level','extension','9','0','0','1','7'),('extension_leveltrans','extension.leveltrans',@pk_549_510,'','1.0.0',@rolid_0,'0','20','lwid,lgid','leveltrans','extension','9','0','0','1','7'),('extension_userinfos','extension.userinfos',@pk_549_657,'','',@rolid_0,'0','30','wid,level','userinfos','extension','51','2','0','0','7'),('extension_info','extension.info',@pk_549_662,'','',@rolid_0,'0','10','wid','info','extension','9','0','0','1','7'),('extension_translation','extension.translation',@pk_549_981,'','',@rolid_0,'0','30','wid,lgid','','','51','2','0','0','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('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'),('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'),('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`='extension.level' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.version' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.trans' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.dependency' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.languages' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.leveltrans' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.info' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.translation' LIMIT 1);
SET @pk_454_4215 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_level_wid_level' LIMIT 1 );
SET @pk_454_6867 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_version_wid_version' LIMIT 1 );
SET @pk_454_32063 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_node_namekey' LIMIT 1 );
SET @pk_454_65399 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extensiontrans_wid_lgid' LIMIT 1 );
SET @pk_454_65413 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_dependency_wid_ref_wid' LIMIT 1 );
SET @pk_454_65423 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_languages_wid_lgid' LIMIT 1 );
SET @pk_454_65442 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_leveltrans_lwid_lgid' LIMIT 1 );
SET @pk_454_65517 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_node_wid' LIMIT 1 );
SET @pk_454_65548 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_extension_level' LIMIT 1 );
SET @pk_454_65555 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_enable' LIMIT 1 );
SET @pk_454_65564 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_info|main_library' LIMIT 1 );
SET @pk_454_65862 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_extension_node_publish' LIMIT 1 );
SET @pk_454_65947 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_translation' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_4215,'1','UK_extension_level_wid_level',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_6867,'1','UK_extension_version_wid_version',@dbtid_2),(@pk_454_32063,'1','UK_extension_node_namekey',@dbtid_3),(@pk_454_65399,'3','PK_extensiontrans_wid_lgid',@dbtid_4),(@pk_454_65413,'3','PK_extension_dependency_wid_ref_wid',@dbtid_5),(@pk_454_65423,'3','PK_extension_languages_wid_lgid',@dbtid_6),(@pk_454_65442,'3','PK_extension_leveltrans_lwid_lgid',@dbtid_7),(@pk_454_65517,'3','PK_extension_node_wid',@dbtid_3),(@pk_454_65548,'1','UK_namekey_extension_level',@dbtid_1),(@pk_454_65555,'3','PK_extension_enable',@dbtid_8),(@pk_454_65564,'3','PK_extension_info|main_library',@dbtid_9),(@pk_454_65862,'2','IX_extension_node_publish',@dbtid_3),(@pk_454_65947,'3','PK_extension_translation',@dbtid_10);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @pk_616_76 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5publish' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1 );
SET @pk_616_1671 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287wid' LIMIT 1 );
SET @pk_616_1672 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287lgid' LIMIT 1 );
SET @pk_616_1991 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352wid' LIMIT 1 );
SET @pk_616_1992 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352ref_wid' LIMIT 1 );
SET @pk_616_2721 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423lgid' LIMIT 1 );
SET @pk_616_2722 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423wid' LIMIT 1 );
SET @pk_616_3305 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473wid' LIMIT 1 );
SET @pk_616_3306 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473version' LIMIT 1 );
SET @pk_616_3478 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509wid' LIMIT 1 );
SET @pk_616_3479 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509level' LIMIT 1 );
SET @pk_616_3482 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lwid' LIMIT 1 );
SET @pk_616_3483 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lgid' LIMIT 1 );
SET @pk_616_3545 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5namekey' LIMIT 1 );
SET @pk_616_6326 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey509' LIMIT 1 );
SET @pk_616_6382 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid657' LIMIT 1 );
SET @pk_616_6443 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='662wid' LIMIT 1 );
SET @pk_616_6460 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='level657' LIMIT 1 );
SET @pk_616_8907 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981wid' LIMIT 1 );
SET @pk_616_8908 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981lgid' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_3477 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509lwid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_3468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5parent' LIMIT 1 );
SET @pk_616_5658 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5rolid' LIMIT 1 );
SET @pk_616_8436 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid473' LIMIT 1 );
SET @pk_616_8439 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid473' LIMIT 1 );
SET @pk_616_80 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5folder' LIMIT 1 );
SET @pk_616_82 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5params' LIMIT 1 );
SET @pk_616_86 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5status' LIMIT 1 );
SET @pk_616_88 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5type' LIMIT 1 );
SET @pk_616_93 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5name' LIMIT 1 );
SET @pk_616_1673 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287description' LIMIT 1 );
SET @pk_616_3304 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473vsid' LIMIT 1 );
SET @pk_616_3310 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473status' LIMIT 1 );
SET @pk_616_3432 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5destination' LIMIT 1 );
SET @pk_616_3484 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510description' LIMIT 1 );
SET @pk_616_3491 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5trans' LIMIT 1 );
SET @pk_616_3521 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5certify' LIMIT 1 );
SET @pk_616_3525 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509status' LIMIT 1 );
SET @pk_616_3585 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5version' LIMIT 1 );
SET @pk_616_3594 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5lversion' LIMIT 1 );
SET @pk_616_3696 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423available' LIMIT 1 );
SET @pk_616_3697 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423translation' LIMIT 1 );
SET @pk_616_5460 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5pref' LIMIT 1 );
SET @pk_616_5675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5install' LIMIT 1 );
SET @pk_616_6180 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering5' LIMIT 1 );
SET @pk_616_6181 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core5' LIMIT 1 );
SET @pk_616_6380 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='enable657' LIMIT 1 );
SET @pk_616_6444 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='author662' LIMIT 1 );
SET @pk_616_6445 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='documentation662' LIMIT 1 );
SET @pk_616_6446 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='images662' LIMIT 1 );
SET @pk_616_6447 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='flash662' LIMIT 1 );
SET @pk_616_6448 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='support662' LIMIT 1 );
SET @pk_616_6449 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='forum662' LIMIT 1 );
SET @pk_616_6452 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='homeurl662' LIMIT 1 );
SET @pk_616_6453 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='joomlafeedback662' LIMIT 1 );
SET @pk_616_6454 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created473' LIMIT 1 );
SET @pk_616_6458 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='userversion662' LIMIT 1 );
SET @pk_616_6459 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='userlversion662' LIMIT 1 );
SET @pk_616_6461 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='license657' LIMIT 1 );
SET @pk_616_6465 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified5' LIMIT 1 );
SET @pk_616_6517 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='token657' LIMIT 1 );
SET @pk_616_6519 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ltype657' LIMIT 1 );
SET @pk_616_6520 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='expire657' LIMIT 1 );
SET @pk_616_6521 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='maintenance657' LIMIT 1 );
SET @pk_616_6552 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='beta662' LIMIT 1 );
SET @pk_616_6553 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='beta473' LIMIT 1 );
SET @pk_616_6671 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='flag657' LIMIT 1 );
SET @pk_616_6798 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto287' LIMIT 1 );
SET @pk_616_6799 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid287' LIMIT 1 );
SET @pk_616_6822 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto510' LIMIT 1 );
SET @pk_616_6823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid510' LIMIT 1 );
SET @pk_616_8437 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='level473' LIMIT 1 );
SET @pk_616_8438 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified473' LIMIT 1 );
SET @pk_616_8441 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='encoding473' LIMIT 1 );
SET @pk_616_8442 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='changelog473' LIMIT 1 );
SET @pk_616_8443 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='final473' LIMIT 1 );
SET @pk_616_8444 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sha1473' LIMIT 1 );
SET @pk_616_8445 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='code473' LIMIT 1 );
SET @pk_616_8446 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='marketing473' LIMIT 1 );
SET @pk_616_8651 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='completed423' LIMIT 1 );
SET @pk_616_8652 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='automatic423' LIMIT 1 );
SET @pk_616_8653 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='manual423' LIMIT 1 );
SET @pk_616_8654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='totalimac423' LIMIT 1 );
SET @pk_616_8909 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby981' LIMIT 1 );
SET @pk_616_8910 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified981' LIMIT 1 );
SET @pk_616_9504 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload5' LIMIT 1 );
SET @pk_616_10082 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created5' LIMIT 1 );
SET @pk_616_10101 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtype657' LIMIT 1 );
SET @pk_616_10103 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='keyword662' LIMIT 1 );
SET @pk_616_10819 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='showconfig5' LIMIT 1 );
SET @pk_616_10820 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='framework5' 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_76,@dbtid_3,'publish','0','0','1','0','1','0','9','1',@rolid_0,'0','0','1','5publish','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_81,@dbtid_3,'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_1671,@dbtid_4,'wid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','287wid','1','0','0'),(@pk_616_1672,@dbtid_4,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','287lgid','1','0','0'),(@pk_616_1991,@dbtid_5,'wid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','352wid','1','0','0'),(@pk_616_1992,@dbtid_5,'ref_wid','1','0','3','1','1','','2','1',@rolid_0,'0','0','1','352ref_wid','1','0','0'),(@pk_616_2721,@dbtid_6,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','423lgid','1','0','0'),(@pk_616_2722,@dbtid_6,'wid','1','0','3','1','1','0','1','1',@rolid_0,'0','0','1','423wid','1','0','0'),(@pk_616_3305,@dbtid_2,'wid','0','0','4','1','1','0','2','1',@rolid_0,'0','0','1','473wid','1','0','0'),(@pk_616_3306,@dbtid_2,'version','0','0','4','1','1','0','4','1',@rolid_0,'0','0','1','473version','1','0','0'),(@pk_616_3478,@dbtid_1,'wid','0','0','3','1','1','0','3','1',@rolid_0,'0','0','1','509wid','1','0','0'),(@pk_616_3479,@dbtid_1,'level','0','0','1','1','1','0','2','1',@rolid_0,'0','0','1','509level','1','0','0'),(@pk_616_3482,@dbtid_7,'lwid','1','0','4','1','1','','2','1',@rolid_0,'0','0','1','510lwid','1','0','0'),(@pk_616_3483,@dbtid_7,'lgid','1','0','1','1','1','','1','1',@rolid_0,'0','0','1','510lgid','1','0','0'),(@pk_616_3545,@dbtid_3,'namekey','0','1','14','0','1','','2','1',@rolid_0,'0','100','1','5namekey','1','0','0'),(@pk_616_6326,@dbtid_1,'namekey','0','1','14','0','1','','5','0','0','0','50','1','namekey509','1','0','0'),(@pk_616_6382,@dbtid_8,'wid','1','0','4','1','1','','1','0','0','1','0','0','wid657','1','0','0'),(@pk_616_6443,@dbtid_9,'wid','1','0','4','1','1','','1','0','0','1','0','1','662wid','1','0','0'),(@pk_616_6460,@dbtid_8,'level','1','1','1','1','1','0','2','0','0','0','0','0','level657','1','0','0'),(@pk_616_8907,@dbtid_10,'wid','1','0','4','1','1','','0','0','0','0','0','1','981wid','1','0','0'),(@pk_616_8908,@dbtid_10,'lgid','1','0','4','1','1','','1','0','0','0','0','1','981lgid','1','0','0'),(@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_1583,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),'filid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','478filid','1','0','0'),(@pk_616_1698,@dbtid_11,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_3477,@dbtid_1,'lwid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','509lwid','1','0','0'),(@pk_616_5532,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_3468,@dbtid_3,'parent','0','0','3','1','1','0','10','1',@rolid_0,'0','0','1','5parent','1','0','0'),(@pk_616_5658,@dbtid_3,'rolid','0','0','2','1','1','1','19','1',@rolid_0,'0','0','0','5rolid','1','0','0'),(@pk_616_8436,@dbtid_2,'filid','0','1','4','1','1','0','7','0','0','0','0','1','filid473','1','0','0'),(@pk_616_8439,@dbtid_2,'uid','0','1','4','1','1','0','10','0','0','0','0','1','uid473','1','0','0'),(@pk_616_80,@dbtid_3,'folder','0','1','14','0','1','','7','1',@rolid_0,'0','40','1','5folder','1','0','0'),(@pk_616_82,@dbtid_3,'params','0','0','16','0','1','','14','1',@rolid_0,'0','0','1','5params','1','0','0'),(@pk_616_86,@dbtid_3,'status','0','0','1','0','1','0','8','1',@rolid_0,'0','0','1','5status','1','0','0'),(@pk_616_88,@dbtid_3,'type','0','0','2','1','1','1','5','1',@rolid_0,'0','0','1','5type','1','0','0'),(@pk_616_93,@dbtid_3,'name','0','1','14','0','1','','6','1',@rolid_0,'0','100','1','5name','1','0','0'),(@pk_616_1673,@dbtid_4,'description','0','1','16','0','1','','3','1',@rolid_0,'0','0','1','287description','1','0','0'),(@pk_616_3304,@dbtid_2,'vsid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','473vsid','1','0','0'),(@pk_616_3310,@dbtid_2,'status','0','0','1','0','1','0','3','1',@rolid_0,'0','0','1','473status','1','0','0'),(@pk_616_3432,@dbtid_3,'destination','0','0','14','0','1','','11','1',@rolid_0,'0','255','1','5destination','1','0','0'),(@pk_616_3484,@dbtid_7,'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','510description','1','0','0'),(@pk_616_3491,@dbtid_3,'trans','0','0','25','0','1','0','12','1',@rolid_0,'0','0','1','5trans','1','0','0'),(@pk_616_3521,@dbtid_3,'certify','0','0','1','1','1','0','13','1',@rolid_0,'0','0','1','5certify','1','0','0'),(@pk_616_3525,@dbtid_1,'status','0','0','1','0','1','0','4','1',@rolid_0,'0','0','1','509status','1','0','0'),(@pk_616_3585,@dbtid_3,'version','0','0','4','1','1','0','16','1',@rolid_0,'0','10','1','5version','1','0','0'),(@pk_616_3594,@dbtid_3,'lversion','0','0','4','1','1','0','15','1',@rolid_0,'0','10','1','5lversion','1','0','0'),(@pk_616_3696,@dbtid_6,'available','0','0','25','0','1','0','3','1',@rolid_0,'0','0','1','423available','1','0','0'),(@pk_616_3697,@dbtid_6,'translation','0','0','25','0','1','1','4','1',@rolid_0,'0','0','1','423translation','1','0','0'),(@pk_616_5460,@dbtid_3,'pref','0','0','25','0','1','','17','1',@rolid_0,'0','0','1','5pref','1','0','0'),(@pk_616_5675,@dbtid_3,'install','0','0','16','0','1','','18','1',@rolid_0,'0','0','1','5install','1','0','0'),(@pk_616_6180,@dbtid_3,'ordering','0','0','3','1','1','0','4','0',@rolid_0,'0','0','0','ordering5','1','0','0'),(@pk_616_6181,@dbtid_3,'core','0','0','1','1','1','0','3','0',@rolid_0,'0','0','1','core5','1','0','0'),(@pk_616_6380,@dbtid_8,'enabled','0','0','1','1','1','0','3','0','0','0','0','0','enable657','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_6444,@dbtid_9,'author','0','1','14','0','1','','2','0','0','0','100','1','author662','1','0','0'),(@pk_616_6445,@dbtid_9,'documentation','0','1','14','0','1','','3','0','0','0','255','1','documentation662','1','0','0'),(@pk_616_6446,@dbtid_9,'images','0','1','14','0','1','','4','0','0','0','255','1','images662','1','0','0'),(@pk_616_6447,@dbtid_9,'flash','0','1','14','0','1','','5','0','0','0','255','1','flash662','1','0','0'),(@pk_616_6448,@dbtid_9,'support','0','1','14','0','1','','6','0','0','0','255','1','support662','1','0','0'),(@pk_616_6449,@dbtid_9,'forum','0','1','14','0','1','','7','0','0','0','255','1','forum662','1','0','0'),(@pk_616_6452,@dbtid_9,'homeurl','0','1','14','0','1','','8','0','0','0','200','1','homeurl662','1','0','0'),(@pk_616_6453,@dbtid_9,'feedback','0','1','14','0','1','','9','0','0','0','255','1','joomlafeedback662','1','0','0'),(@pk_616_6454,@dbtid_2,'created','0','1','4','1','1','0','5','0','0','0','0','1','created473','1','1','0'),(@pk_616_6458,@dbtid_9,'userversion','0','1','14','0','1','','10','0','0','0','100','1','userversion662','1','0','0'),(@pk_616_6459,@dbtid_9,'userlversion','0','1','14','0','1','','11','0','0','0','100','1','userlversion662','1','0','0'),(@pk_616_6461,@dbtid_8,'license','0','1','14','0','1','','4','0','0','0','255','0','license657','1','0','0'),(@pk_616_6465,@dbtid_3,'modified','0','1','4','1','1','0','20','0','0','0','10','0','modified5','1','1','0'),(@pk_616_6517,@dbtid_8,'token','0','1','14','0','1','','5','0','0','0','254','0','token657','1','0','0'),(@pk_616_6519,@dbtid_8,'ltype','0','1','1','1','1','1','6','0','0','0','0','0','ltype657','1','0','0'),(@pk_616_6520,@dbtid_8,'expire','0','1','4','1','1','0','8','0','0','0','0','1','expire657','1','0','0'),(@pk_616_6521,@dbtid_8,'maintenance','0','1','4','1','1','0','9','0','0','0','0','1','maintenance657','1','0','0'),(@pk_616_6552,@dbtid_9,'beta','0','1','2','0','1','0','12','0','0','0','5','1','beta662','1','0','0'),(@pk_616_6553,@dbtid_2,'beta','0','1','2','1','1','0','6','0','0','0','0','1','beta473','1','0','0'),(@pk_616_6671,@dbtid_8,'flag','0','1','1','1','1','0','10','0','0','0','0','1','flag657','1','0','0'),(@pk_616_6798,@dbtid_4,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto287','1','0','0'),(@pk_616_6799,@dbtid_4,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid287','1','0','0'),(@pk_616_6822,@dbtid_7,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto510','1','0','0'),(@pk_616_6823,@dbtid_7,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid510','1','0','0'),(@pk_616_8437,@dbtid_2,'level','0','1','1','1','1','0','8','0','0','0','0','1','level473','1','0','0'),(@pk_616_8438,@dbtid_2,'modified','0','1','4','1','1','0','9','0','0','0','0','1','modified473','1','1','0'),(@pk_616_8441,@dbtid_2,'encoding','0','1','14','0','1','','11','0','0','0','100','1','encoding473','1','0','0'),(@pk_616_8442,@dbtid_2,'changelog','0','1','16','0','1','','12','0','0','0','0','1','changelog473','1','0','0'),(@pk_616_8443,@dbtid_2,'final','0','1','1','1','1','0','13','0','0','0','0','1','final473','1','0','0'),(@pk_616_8444,@dbtid_2,'sha1','0','1','14','0','1','','14','0','0','0','100','1','sha1473','1','0','0'),(@pk_616_8445,@dbtid_2,'code','0','1','15','0','1','','15','0','0','0','32','1','code473','1','0','0'),(@pk_616_8446,@dbtid_2,'marketing','0','1','14','0','1','','16','0','0','0','255','1','marketing473','1','0','0'),(@pk_616_8651,@dbtid_6,'completed','0','1','7','1','1','0','5','0','0','0','5','1','completed423','1','0','0'),(@pk_616_8652,@dbtid_6,'automatic','0','1','7','1','1','0','6','0','0','0','5','1','automatic423','1','0','0'),(@pk_616_8653,@dbtid_6,'manual','0','1','7','1','1','0','7','0','0','0','5','1','manual423','1','0','0'),(@pk_616_8654,@dbtid_6,'totalimac','0','1','4','1','1','0','8','0','0','0','0','1','totalimac423','1','0','0'),(@pk_616_8909,@dbtid_10,'modifiedby','0','0','4','1','1','0','2','0','0','0','0','1','modifiedby981','1','0','0'),(@pk_616_8910,@dbtid_10,'modified','0','1','4','1','1','0','2','0','0','0','0','1','modified981','1','1','0'),(@pk_616_9504,@dbtid_3,'reload','0','1','1','1','1','1','21','0','0','0','0','0','reload5','1','0','0'),(@pk_616_10082,@dbtid_3,'created','0','1','4','1','1','0','22','0','0','0','0','0','created5','1','1','0'),(@pk_616_10101,@dbtid_8,'subtype','0','1','1','1','1','0','7','0','0','0','0','1','subtype657','1','0','0'),(@pk_616_10103,@dbtid_9,'keyword','0','1','14','0','1','','13','0','0','0','200','1','keyword662','1','0','0'),(@pk_616_10819,@dbtid_3,'showconfig','0','1','1','1','1','1','23','0','0','0','0','1','showconfig5','1','0','0'),(@pk_616_10820,@dbtid_3,'framework','0','1','1','1','1','0','24','0','0','0','0','1','framework5','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');
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_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_1097 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='apps.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='apps',`wid`=@pk_5_1097,`params`='',`status`='1',`type`='150',`name`='Apps',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='apps.node',`version`='3385',`lversion`='3385',`pref`='1',`install`='',`core`='1',`showconfig`='0',`framework`='0' WHERE  `namekey`='apps.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','apps',@pk_5_1097,'','1','150','Apps','node','0','1','0','apps.node','3385','3385','1','','1','0','0');

SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_1000 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.userinfos' LIMIT 1 );
SET @pk_621_1001 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.level' LIMIT 1 );
SET @pk_621_1002 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.dependency' LIMIT 1 );
SET @pk_621_1003 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.info' LIMIT 1 );
SET @pk_621_1004 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='appstrans' LIMIT 1 );
SET @pk_621_1014 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.leveltrans' LIMIT 1 );
SET @pk_621_1025 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.version' LIMIT 1 );
SET @pk_621_1040 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.languages' LIMIT 1 );
SET @pk_621_1111 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.translations' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_199 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_999,`dbtid`=@dbtid_3,`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_3,'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_1000,`dbtid`=@dbtid_8,`path`='0',`namekey`='apps.userinfos',`folder`='apps.userinfos',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.userinfos';
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_1000,@dbtid_8,'0','apps.userinfos','apps.userinfos',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1001,`dbtid`=@dbtid_1,`path`='0',`namekey`='apps.level',`folder`='apps.level',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.level';
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_1001,@dbtid_1,'0','apps.level','apps.level',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1002,`dbtid`=@dbtid_5,`path`='0',`namekey`='apps.dependency',`folder`='apps.dependency',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.dependency';
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_1002,@dbtid_5,'0','apps.dependency','apps.dependency',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1003,`dbtid`=@dbtid_9,`path`='0',`namekey`='apps.info',`folder`='apps.info',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=apps\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.info';
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_1003,@dbtid_9,'0','apps.info','apps.info',@rolid_0,'0','1','0','0','mainmodel=apps\nautofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1004,`dbtid`=@dbtid_4,`path`='0',`namekey`='appstrans',`folder`='appstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=apps\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='appstrans';
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_1004,@dbtid_4,'0','appstrans','appstrans',@rolid_0,'0','1','0','0','mainmodel=apps\nautofld=1','','apps','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1014,`dbtid`=@dbtid_7,`path`='0',`namekey`='apps.leveltrans',`folder`='apps.leveltrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=apps.level',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.leveltrans';
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_1014,@dbtid_7,'0','apps.leveltrans','apps.leveltrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=apps.level','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1025,`dbtid`=@dbtid_2,`path`='0',`namekey`='apps.version',`folder`='apps.version',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.version';
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_1025,@dbtid_2,'0','apps.version','apps.version',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1040,`dbtid`=@dbtid_6,`path`='0',`namekey`='apps.languages',`folder`='apps.languages',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-language',`pnamekey`='' WHERE  `namekey`='apps.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_1040,@dbtid_6,'0','apps.languages','apps.languages',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','fa-language','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1111,`dbtid`=@dbtid_10,`path`='0',`namekey`='apps.translations',`folder`='apps.translations',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='apps.translations';
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_1111,@dbtid_10,'0','apps.translations','apps.translations',@rolid_0,'0','1','0','0','autofld=1','','apps','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=@dbtid_3,`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
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_5,@dbtid_3,'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),`path`='1',`namekey`='role',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='prtname=roletrans\ncachedata=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role';
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_566,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),'1','role','role',@rolid_0,'0','1','0','0','prtname=roletrans\ncachedata=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_199,`dbtid`=@dbtid_11,`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,@dbtid_11,'0','library.languages','library.languages',@rolid_0,'0','1','0','0','','','joobi','0','0','1','fa-language','');

SET @wid_12 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='apps.node' LIMIT 1);
SET @sid_13 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1);
SET @sid_14 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1);
SET @rolid_15 = (7);
SET @rolid_16 = (9);
SET @rolid_17 = (8);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_preferences_form' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_show' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_install_package' LIMIT 1);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_update_all' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_token' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_setup_contactus' LIMIT 1);
SET @yid_24 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_query' LIMIT 1);
SET @yid_25 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_move_license' LIMIT 1);
SET @yid_26 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_report_dashboard' LIMIT 1);
SET @yid_27 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_translations_edit' LIMIT 1);
SET @yid_28 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_uninstall_choice' LIMIT 1);
SET @did_29 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='apps_update_check' LIMIT 1);
SET @did_30 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='apps_distrib_server' LIMIT 1);
SET @did_31 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='apps_frequency_clear_cache' LIMIT 1);
SET @did_32 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='apps_uninstall' LIMIT 1);
SET @sid_33 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.info' LIMIT 1);
SET @sid_34 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.userinfos' LIMIT 1);
SET @ref_yid_35 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_listing_api_keys' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_general_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('apps_preferences_form_general_1') LIMIT 1;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_advance_column_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('apps_preferences_form_security','apps_preferences_form_language_source_order','apps_preferences_form_performance') LIMIT 3;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('apps_show_information','apps_show_description','apps_show_social_media','apps_show_release_node') LIMIT 4;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_advance_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('apps_preferences_form_updates','apps_preferences_form_maintenance') LIMIT 2;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_advance' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('apps_preferences_form_advance_column_1','apps_preferences_form_advance_column_2') LIMIT 2;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('apps_preferences_form_general_column_1','apps_preferences_form_general_column_2') LIMIT 2;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_tab_media_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('apps_preferences_form_fieldset_watermark','apps_preferences_form_fieldset_mediaplayer','apps_preferences_form_media_enablesound','apps_preferences_form_media_fancyupload','apps_preferences_form_media_fancyuploadmax','apps_preferences_form_fieldset_captcha') LIMIT 6;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('apps_preferences_form_views_direct_editing','apps_preferences_form_views_custom_field','apps_preferences_form_views_chart_dimmensions','apps_preferences_form_views_joomla','apps_preferences_form_views_picklist','apps_preferences_form_views_date') LIMIT 6;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_tab_media' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('apps_preferences_form_tab_media_column1') LIMIT 1;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_update_all_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('apps_update_all_information') LIMIT 1;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_row1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('apps_show_column1','apps_show_column2') LIMIT 2;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('apps_show_latest_news','apps_show_progress') LIMIT 2;
SET @p_1_12 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_general_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_12 WHERE `namekey` IN ('apps_preferences_form_u_library_node_chatbox','apps_preferences_form_u_library_node_wizard','apps_preferences_form_library_node_pagetitle','apps_preferences_form_library_node_wizardfe','apps_preferences_form_library_node_helpfe','apps_preferences_form_library_node_seftype','apps_preferences_form_library_node_showitemid','apps_preferences_form_library_node_loadmootools','apps_preferences_form_library_node_loadjquery','apps_preferences_form_library_node_editor_fe','apps_preferences_form_library_node_editor','apps_preferences_form_library_node_scripttype','apps_preferences_form_library_node_timeinterval') LIMIT 13;
SET @p_1_13 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_maintenance' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_13 WHERE `namekey` IN ('apps_preferences_form_u_library_node_dbgerr','apps_preferences_form_u_library_node_memory_usage','apps_preferences_form_u_library_node_dbgqry','apps_preferences_form_u_library_node_logqry','apps_preferences_form_library_node_dbgerrguest','apps_preferences_form_library_node_dbgqryguest','apps_preferences_form_library_node_logqryguest','apps_preferences_form_install_node_installdetails','apps_preferences_form_install_node_installdebug','apps_preferences_form_library_node_phperror','apps_preferences_form_library_node_errorshowline','apps_preferences_form_main_node_showhiddenview','apps_preferences_form_library_node_logsoff','apps_preferences_form_email_node_adminnotif','apps_preferences_form_advance_node_resetdownloads','apps_preferences_form_advance_node_resetinstall') LIMIT 16;
SET @p_1_14 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_users' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_14 WHERE `namekey` IN ('apps_preferences_form_users_1') LIMIT 1;
SET @p_1_15 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_fieldset_mediaplayer' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_15 WHERE `namekey` IN ('apps_preferences_form_media_jwplayer','apps_preferences_form_media_jwplayerkey') LIMIT 2;
SET @p_1_16 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_fieldset_watermark' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_16 WHERE `namekey` IN ('apps_preferences_form_media_watermarkuseimage','apps_preferences_form_media_watermarkimagefile','apps_preferences_form_media_watermarkimageposition','apps_preferences_form_media_watermarkusetext','apps_preferences_form_media_watermarktextvalue','apps_preferences_form_media_watermarktextcolor','apps_preferences_form_media_watermarktextsize','apps_preferences_form_media_watermarktextopacity','apps_preferences_form_media_watermarktextrotation','apps_preferences_form_media_watermarktextfontfile','apps_preferences_form_media_watermarktextposition') LIMIT 11;
SET @p_1_17 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_scheduler' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_17 WHERE `namekey` IN ('apps_preferences_form_scheduler_1') LIMIT 1;
SET @p_1_18 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_mail' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_18 WHERE `namekey` IN ('apps_preferences_form_mail_nested_view') LIMIT 1;
SET @p_1_19 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_picklist' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_19 WHERE `namekey` IN ('apps_preferences_form_main_node_categorycollapse') LIMIT 1;
SET @p_1_20 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_date' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_20 WHERE `namekey` IN ('apps_preferences_form_main_node_dateformat') LIMIT 1;
SET @p_1_21 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_direct_editing' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_21 WHERE `namekey` IN ('apps_preferences_form_li_node_showviewsdetails','apps_preferences_form_li_node_showconfig','apps_preferences_form_main_node_direct_translate','apps_preferences_form_main_node_direct_edit','apps_preferences_form_main_node_direct_edit_modules','apps_preferences_form_main_node_direct_access') LIMIT 6;
SET @p_1_22 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_joomla' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_22 WHERE `namekey` IN ('apps_preferences_form_main_node_frameworkcontent') LIMIT 1;
SET @p_1_23 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_custom_field' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_23 WHERE `namekey` IN ('apps_preferences_form_library_node_fieldalltable','apps_preferences_form_library_node_fieldalltype') LIMIT 2;
SET @p_1_24 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_views_chart_dimmensions' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_24 WHERE `namekey` IN ('apps_preferences_form_library_node_x_dimension','apps_preferences_form_library_node_y_dimension') LIMIT 2;
SET @p_1_25 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_updates' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_25 WHERE `namekey` IN ('apps_preferences_form_c_apps_node_autocheckupdate','apps_preferences_form_u_apps_node_notemail','apps_preferences_form_apps_node_home_site','apps_documentation_site','apps_preferences_form_apps_node_distribserver','apps_preferences_form_install_node_distrib_website','apps_preferences_form_install_node_distrib_website_beta') LIMIT 7;
SET @p_1_26 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_language_source_order' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_26 WHERE `namekey` IN ('apps_preferences_form_library_node_adminenglish','apps_preferences_form_library_node_multilang','apps_preferences_form_library_node_lgbrowser','apps_preferences_form_library_node_lgip','apps_preferences_form_library_node_lgcms') LIMIT 5;
SET @p_1_27 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_performance' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_27 WHERE `namekey` IN ('apps_preferences_form_library_node_caching','apps_preferences_form_library_node_useminify','apps_preferences_form_library_node_cdnuse','apps_preferences_form_library_node_cdnserver','apps_preferences_form_library_node_optimizedb','apps_preferences_form_library_node_clearcache') LIMIT 6;
SET @p_1_28 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_preferences_form_security' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_28 WHERE `namekey` IN ('apps_preferences_form_library_node_seclev','apps_preferences_form_library_node_sslfe','apps_preferences_form_library_node_sslbe','apps_preferences_form_library_node_server_status','apps_preferences_form_library_node_userstatememory') LIMIT 5;
SET @p_1_29 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_latest_news' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_29 WHERE `namekey` IN ('apps_show_news') LIMIT 1;
SET @p_1_30 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_social_media' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_30 WHERE `namekey` IN ('apps_show_social_media_1') LIMIT 1;
SET @p_1_31 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_release_node' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_31 WHERE `namekey` IN ('apps_show_release_notes') LIMIT 1;
SET @p_1_32 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_progress' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_32 WHERE `namekey` IN ('apps_show_status_1') LIMIT 1;
SET @p_1_33 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_description' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_33 WHERE `namekey` IN ('apps_show_apps_name','apps_show_appstrans_description','apps_show_apps_info_author') LIMIT 3;
SET @p_1_34 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_show_information' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_34 WHERE `namekey` IN ('apps_show_apps_info_userversion','apps_show_apps_info_userlversion','apps_show_apps_userinfos_token','apps_show_apps_userinfos_maintenance') LIMIT 4;
SET @p_1_35 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_install_package_recommended' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_35 WHERE `namekey` IN ('apps_install_package_file') LIMIT 1;
SET @p_1_36 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_install_package_alternative_options' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_36 WHERE `namekey` IN ('apps_install_package_url','apps_install_package_folder') LIMIT 2;
SET @p_1_37 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_update_all_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_37 WHERE `namekey` IN ('apps_update_all_status') LIMIT 1;
SET @p_1_38 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='apps_update_all_information' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_38 WHERE `namekey` IN ('apps_update_all_info_userversion','apps_update_all_info_userlversion','apps_update_all_userinfos_maintenance') LIMIT 3;
SET @yid_36 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_listing' LIMIT 1);
SET @yid_37 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_user_logs' LIMIT 1);
SET @yid_38 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_user_logdetails' LIMIT 1);
SET @yid_39 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_translations_list' LIMIT 1);
SET @yid_40 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_nestedapplication' LIMIT 1);
SET @yid_41 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='apps_nestedlanguage' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='apps_listing_apps_name_column' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('apps_listing_apps_name','apps_listing_appstrans_description') LIMIT 2;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='nestedapplication_apps_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('nestedapplication_appstrans_description') LIMIT 1;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='apps_report_dashboard_report' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('apps_report_dashboard_apps_wid_1','apps_report_dashboard_apps_wid') LIMIT 2;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Reset','1','1206732365OQJK'),('Delete','1','1206732372QTKL'),('Show','1','1206732372QTKM'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('Languages','1','1206732392OZUS'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Version','1','1206732392OZVF'),('Description','1','1206732392OZVG'),('Status','1','1206732392OZVH'),('status','1','1206732392OZVI'),('Cancel','1','1206732393CXVV'),('Please specify a token which is not empty.','1','1206732393CXVX'),('A Demo license could not be granted because this application has already been demo on this website.','1','1206732393CXVY'),('This application is not yet available for demo.','1','1206732394IZGY'),('You website need to be validated by the Licensing Team to be a non-profit website.','1','1206732394IZHB'),('Could not update the data','1','1206732395DOFD'),('The token can not be empty!','1','1206732397TAXO'),('Installed','1','1206732397TAXY'),('Could not refresh the list of extensions. Try again later.','1','1206732397TAYG'),('Please select a subject for contacting us.  Thank you.','1','1206732398LZJD'),('General Preferences','1','1206732399EIMX'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('Check','1','1206732399EINH'),('Send','1','1206732400OWXC'),('Refresh','1','1206732400OWXE'),('Grades','1','1206732400OWXK'),('Direct Edit','1','1206732400OWXQ'),('Author','1','1206732400OWZO'),('General','1','1206732400OWZR'),('Show Wizard','1','1206732400OWZT'),('Mail','1','1206732400OWZW'),('Security','1','1206732400OXBG'),('Application','1','1206732400OXBR'),('Latest version','1','1206732400OXCC'),('Subject','1','1206732400OXCG'),('Choose an Application','1','1206732400OXCI'),('Language','1','1206732405TIXE'),('None','1','1206732410ICCJ'),('divider','1','1206732411EGRN'),('Created','1','1206732411EGRY'),('Delete All','1','1206732420EIUT'),('Location','1','1206732421RJQC'),('Admin','1','1206732425HINY'),('License successfully moved to : $url','1','1206961836KSBJ'),('Use the following token number to install the new license : $token','1','1206961836KSBK'),('The license could not be moved because it does not comply to the requirements.','1','1206961836KSBL'),('Move a License','1','1206961841DNYR'),('New Website URL','1','1206961841DNZP'),('Site','1','1206961849MVDJ'),('Maintenance','1','1206961850KLRD'),('Date','1','1206961850KLRI'),('Views','1','1206961854HENY'),('hidden','1','1206961869IGND'),('Back','1','1206961882TDHA'),('Scheduler','1','1206961893RSRQ'),('Report','1','1206961899DDKO'),('Download','1','1206961905BHAV'),('Code','1','1206961912MJQB'),('Free','1','1206961944PEUR'),('Available','1','1206961996STAF'),('Logo','1','1206961997BSYJ'),('General Use','1','1207045653IMAV'),('Certified','1','1208193651IFKI'),('Install / Upgrade Applications','1','1208362898QACD'),('Progress','1','1209674948GCLL'),('Successfully checked-in all elements','1','1209746216SXQF'),('Contact Support','1','1210244238DTYK'),('Install','1','1211280056BEZM'),('Captcha','1','1212761242DPBP'),('If you think this is a mistake please contact the Support Team.','1','1213020848LZMA'),('The license could not be retrieved.','1','1213020848LZMB'),('Please contact the Support Team.','1','1213020848LZMC'),('The application information could not be updated with the license received.','1','1213020848LZME'),('The license has been successfully installed!','1','1213020848LZMF'),('Please select an application.','1','1213020853MLHQ'),('Click Yes if to show the chat box for the support.<div>This is only available in the admin area.</div>','1','1213107622JALA'),('Please select the application for which you want support.','1','1213107632HHOS'),('Select the subject of your request.','1','1213107632HHOT'),('Sorry, this file is no longer available on our servers.','1','1213107637HXCS'),('Support','1','1213183509OYOB'),('Notice','1','1213285196AFGY'),('Updates','1','1213353034DMQE'),('Email Notification','1','1213353034DMQG'),('Advance feature to show the code errors when they occur. With this option, only guests will see the errors (you can use it when you need to see an error occurring somewhere accessible only by unregistered users like the registration page)','1','1213369263SAAF'),('Debug Errors','1','1213369263SAAG'),('Debug Queries','1','1213369263SAAI'),('Information','1','1215507792MTRU'),('The Widget was unpublished with success.','1','1215710386RMJC'),('The Widget was published with success.','1','1215710386RMJD'),('<span style=\"font-weight: bold;\">It is recommanded to use the highest level of security.</span><br>Should you want to trade some security for some performance you could lower the security level.  <br>Basic security, like filter for SQL injection are always covered. <br>','1','1217930839LUIO'),('Security Level','1','1217930839LUIP'),('Performance','1','1217930839LUIR'),('Specify and email address for administration and maintenance notification.<br>If left empty all administrator will be notified.<br>','1','1217930839LUIS'),('Caching','1','1217930839LUIT'),('Pick-list','1','1219769913SSOH'),('Installation','1','1219770756BFUL'),('Translations','1','1220793710GXYB'),('A demo license could not be retrieved because you already evaluated this application on this website.','1','1227579883OZMZ');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Grade','1','1227579895DRET'),('Please use this form to contact us.  <br><ul><li>Based on your subject you will be redirected to the right section of our website: either the ticket system or the forum.</li><li>It is also important that you select the right application.</li><li>We look forward to hearing from you.</li></ul>','1','1227579895DREU'),('nestedapplication','1','1227580613HBMJ'),('nestedlanguage','1','1227580613HBMK'),('Update','1','1227580898LIDX'),('Current version','1','1228709213SHFK'),('Distribution server','1','1228820067NJRT'),('Joobi Care','1','1228820286IIZC'),('Query successfully executed!','1','1229651871ADBG'),('One of the query failed!','1','1229651871ADBH'),('List of applications updated.','1','1229651871ADBI'),('The version currently installed on your website<br>','1','1229651877RBLQ'),('The latest version available<br>','1','1229651877RBLS'),('Enter your query here.<br>','1','1229651877RBLT'),('Click Yes if you want to see the result of the query.<br><span style=\"text-decoration: underline; color: rgb(204, 0, 0); font-weight: bold;\">Warning:</span> Don\'t click Yes if you run many queries all at once.<br>','1','1229651877RBLU'),('Query','1','1229651877RBLW'),('See result','1','1229651877RBLX'),('Execute','1','1229651877RBLY'),('Application information','1','1229651878KNMW'),('<ul><li>Before installing / updating any application on the website, we recommend that you do a backup of the website files and database. This way, you will always be able to revert the changes made during the install / update in case of an error.</li><li>Setting the website in maintenance mode is also recommended for updates.</li></ul>','1','1229651878KNMX'),('<ul><li>Enter the query you want to run on your server.</li><li>If you have several queries, use a semi-column ( ; ) to sepate the queries.</li><li><span style=\"color: rgb(204, 0, 0);\">Use the option to show the results only if you have few queries.</span></li></ul>','1','1229651878KNMY'),('Run Query','1','1229651878KNMZ'),('Users','1','1229653442FEQZ'),('Test email','1','1230529131MQQP'),('IP','1','1230531895KYXK'),('<span style=\"font-weight: bold; color: rgb(204, 0, 0);\">Be very careful with this feature!</span><br>The move of the license is automatic and cannot be reversed within the next 3 months.<br>Please enter the new website URL to which you want to move the license to.<br><br>','1','1230874957AEGZ'),('<ul><li>Please enter the API key you received by email or any other mean in order to get new update.</li></ul>','1','1230874957AEHC'),('<span style=\"font-weight: bold; color: rgb(204, 0, 0);\">Please be very carefull with this feature!</span><br>As specified in the license agreement a license can only be moved every 3 months.  The move of the license will be automatic and irreversible within the next 3 months.<br>','1','1230874957AEHD'),('Beta','1','1231158811CQTU'),('Application in Beta','1','1232547361JEQR'),('Image Position','1','1234467597SEXO'),('The application has been successfully set to Core.','1','1235976558LLLB'),('This application is not installed!','1','1235976558LLLC'),('Your license expired!','1','1235976558LLLD'),('Default WYSIWYG editor for the user in the front-end of the site.<br>','1','1238171067TJFA'),('download','1','1240388999GQSW'),('Confirm','1','1240912077BELS'),('News','1','1242282413PMNC'),('Memory Usage','1','1242282413PMPV'),('Last Updated','1','1242282416HAOE'),('Latest News','1','1242282417SQLW'),('Never','1','1242282417SQNR'),('Show Page Title','1','1242282435FMDW'),('Install from URL','1','1242282443EZXY'),('Uninstall','1','1242282443EZZS'),('Browser','1','1242282449PIOD'),('Done','1','1242282449PIPC'),('Media','1','1242282450QJCF'),('Show all the query executed. Only you will see them.','1','1242617238FPTQ'),('Advance feature to show the code errors when they occur. Only you will see them.','1','1242617238FPTR'),('Debug Errors Guest','1','1242617238FPTT'),('Framework','1','1243392688MXHE'),('The application has been successfully updated!','1','1245769651NPXC'),('Widget file Uploaded','1','1247466190MROL'),('Please fill one of the fields','1','1248835367AECZ'),('Install from folder','1','1248835373QZQO'),('The folder $FOLDER is not a valid extension folder','1','1248948187IFCW'),('Select the package with the browse button and click install.<br>','1','1249442155KSPX'),('Enter the URL of your package and click install.<br>','1','1249442155KSPY'),('Enter the path to the folder and click install.<br>','1','1249442155KSPZ'),('Enter package','1','1249442156QUCN'),('Recommended','1','1249442156QUCO'),('Alternative options','1','1249442156QUCP'),('Install Manager','1','1249442157SIBQ'),('It seems that the installer was unable to remove the temporary folder for install files on last install due to an access rights issue. Before trying to update/install again, please remove the folder $FOLDER via FTP.','1','1249562683MMMY'),('The file type ($FILE_EXTENSION) is not in the list of valid types : $EXTENSIONS','1','1249567958KVAQ'),('The user\'s browser has a list of preferred languages. When not logged in, this data can be use to check if those languages are available for the Joobi application and use the preferred available one. By default the Browser order is 1 which means that it\'s the first source used to decide the language to be displayed.<br>','1','1250777204RIAD'),('When the ip tracker is installed, it can detect the country where the user is by looking at his IP address. Then, the system can use the language associated with the detected country to display the joobi applications, if the language is available for joobi applications. If the ip tracker application is not installed, this option will be skipped. By default, the IP based language detection is done after the browser based detection if the browser detection was unsuccessful. Thus, its ordering value is 2 by default.<br>','1','1250777204RIAE'),('Saving of General Preferences','1','1251534480QHPE'),('This website has been added to your site manager.','1','1251770410PASS'),('This website could not be added.','1','1251770410PAST'),('Refresh all licenses','1','1251857784QRWO'),('Could not identify your website URL.','1','1251905717NHWT'),('Your website was not found. Please contract support.','1','1251905717NHWU'),('The licenses have been updated!','1','1251905717NHWW'),('There is a problem with the Localhost license.','1','1251905718PEOQ'),('The license could not be installed for $APPLICATION because the application is not yet installed.','1','1251905719IQBZ'),('The license could not be installed for application: $APPLICATION','1','1251905719IQCA'),('No licenses were found for this website.','1','1251912852OWAG'),('An error occur while installing the licenses!','1','1251959063BNBJ'),('Click Yes to force \"https\" secure internet on the Back-End.','1','1251988094BIBR'),('File Size','1','1252569179LCYI'),('File Name','1','1252569179LCYJ'),('User Logs','1','1252569179LCYK'),('User Log Details','1','1252569179LCYL'),('User Logs Details','1','1252569180FERI'),('Log Download','1','1252894206NMXU'),('User Log Delete','1','1252894206NMXV'),('Logs','1','1253200893CXZC'),('Click Yes to force \"https\" secure internet on the Front-End.','1','1254100130KOZM'),('Click No to turn off any communication with external website.<br>Note: turning this option Off will disable application updates and limit some of the functionality of the site. <br>','1','1254100130KOZN'),('Force SSL Front-End','1','1254100130KOZO'),('Force SSL Back-End','1','1254100130KOZP'),('The system can also try to use the Framework ( Joomla, Wordpress, etc ) detected language if it is available for joobi applications. By default, this is done after the other detection systems, thus, its ordering value is 3. If you set its ordering lower than the others, the system will use the framework language if available.','1','1257940976WWP'),('There are no logs available at this time. Please check again later.','1','1260434893HJHQ'),('Log file $FILE successfully deleted','1','1260434893HJHR'),('Log file cannot be previewed because it is too big (1MB max)','1','1260443578NNAV'),('Apps','1','1267607212GWJP'),('Total No. of New Apps','1','1267764045MNMG'),('Total No. Of Apps','1','1267764045MNMH'),('Apps Report Dashboard','1','1267764046CYTO');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Use this view to install packages. It can be widgets or even applications. There are three different ways to install a package.<br><ol><li><span style=\"text-decoration: underline;\">Install from package</span>: <span style=\"color: rgb(0, 102, 0); font-weight: bold;\">(Recommended)</span> Simply use the browse button to find your file on your computer and click install.</li><li><span style=\"text-decoration: underline;\">Install from an URL</span>: This can be an external URL. Enter the URL and then click install.</li><li><span style=\"text-decoration: underline;\">Install from a folder</span>: You might have the package extracted in a folder on your server , use this option to specify the folder and then click install. This option can be useful when the package is big and that your PHP upload limit is not enough or that your server times out.<br></li></ol>','1','1271818792LETO'),('Define which distribution server you want to use.<br>None: to disable updates and installs.<br>Production: <font color=\"#CC0000\">Recommended choice</font>. <br>Beta: to get latest beta releases.<br>Dev: <i>Not recommended, only use if advised by developers</i>.<br>','1','1271819434SRVJ'),('Script Type','1','1290670039OOGW'),('Your Cron Task on $HOMESITE is active and working!','1','1298294128HPXJ'),('The Cron Task on $HOMESITE could not be activated, check with support team...','1','1298294128HPXK'),('Package successfully installed','1','1298294132BJZM'),('Advance','1','1298294169DGIW'),('Total Apps','1','1298294174MWUX'),('Installed Apps','1','1298294174MWUY'),('Total No. of New Updated Apps','1','1298294174MWUZ'),('An unknown error happened while featching licenses.','1','1298350280PMMA'),('Apps Extra info','1','1298350283NKJB'),('Apps Level','1','1298350283NKJC'),('Apps Dependency','1','1298350283NKJD'),('Apps Information','1','1298350283NKJE'),('Apps Translation','1','1298350283NKJF'),('Apps Level Trans','1','1298350283NKJG'),('Application Versions','1','1298350284IYPA'),('Enter a Query','1','1298350285IISM'),('Enter an SQL query','1','1298350286CSUD'),('Excecute an SQL query','1','1298350286CSUE'),('Cancel query','1','1298350286CSUF'),('External Communication','1','1298350446IEXL'),('Advance Column 1','1','1298350446IEXU'),('Advance Column 2','1','1298350446IEXV'),('General Column 1','1','1298350446IEXW'),('General Column 2','1','1298350446IEXX'),('Home Site','1','1298350446IEXY'),('This is different than the previous option.  It enables you to turn On/Off the wizard for everyone in the Front-end.<br>','1','1298350449IJXC'),('The website providing applications.<br>','1','1298350453HVAO'),('Column 1','1','1298350843FMVJ'),('Application Languages','1','1299065683HDEE'),('Administrator Notification','1','1299215253RNKY'),('Define the level of caching for the website.<br>The highest the caching the better the performance but also the more memory used. <br>','1','1299215254OXTM'),('Define which page update technology you want to use.<br><span style=\"font-weight: bold;\">AJAX </span>- default and recommended.<span style=\"font-weight: bold;\"><span style=\"font-weight: bold;\"><br></span></span>','1','1300434114HUML'),('This is <span style=\"font-weight: bold;\">Auto Save</span> time interval.<br>The time you want your form to be saved.<br>User per second. Default is <span style=\"color: rgb(102, 0, 0);\">30</span> sec.<span style=\"font-weight: bold;\"><br><span style=\"font-weight: bold;\"></span></span>','1','1300434114HUMM'),('Auto Save  Time Interval','1','1300844255DUTL'),('The plugin \'Cron Task\' has been automatically $ENABLED','1','1303354916DPMU'),('Msg #','1','1304258958RSVK'),('','1','1304525968YBL'),('Yes to load jQuery in the front-end of the site.<div>This Preference apply only for the front-end.</div>','1','1304526022JRUH'),('Render an Tag','1','1304916603TJKB'),('Multilingual Content Site','1','1306429442RXVJ'),('Developer Test Case','1','1306926884BHVV'),('Load Mootools first','1','1309406593PBSN'),('Click Yes to show the page title in the website front-end. No to remove it.<br>','1','1309406599MYMN'),('Reinstall','1','1310984711PXOI'),('Apps Reinstall','1','1310984741ESTO'),('User State Memory','1','1312946243NCTM'),('Specify what system should be use to remember the state of views when user navigate.<br><span style=\"color: rgb(0, 0, 204); text-decoration: underline;\">cookie:</span> enable the user to come back to they previous navigation even after session expire.<br><span style=\"color: rgb(0, 0, 204); text-decoration: underline;\">session</span>: potentially more secure, remember the views state only in the same session.<br>','1','1312946249DMIW'),('Show Wizard in Frontend','1','1314355378KUGY'),('By default the SEF URL render a name rather than a numeric ID.<br>Click Yes if you prefer a simple ID.<br>','1','1314355381EEUK'),('Documentation Site','1','1317387080ATEF'),('The website providing documentation of the applications.<br>','1','1317387083CYMJ'),('DB prefix','1','1318938393NAXT'),('Apps Translations','1','1319035319DBIP'),('Apps Translations Import','1','1319072839DDDJ'),('List of translations','1','1326997166FYVE'),('Translation Guidelines','1','1326997166FYVF'),('Show Help in Frontend','1','1336262893OKNO'),('Click No if you don\'t want to show the Help button in the front-end.<br>','1','1336262894HGBM'),('Users have been successfully synchronized in your database!','1','1337190873HKCO'),('Sync Users','1','1337190875QXBD'),('Watermark','1','1338338319GRMW'),('Use Image Watermark','1','1338338319GRMX'),('Use Text Watermark','1','1338338319GRMY'),('Image File','1','1338338319GRMZ'),('Watermark Text','1','1338338319GRNA'),('Text Position','1','1338338319GRNB'),('Text Size','1','1338338319GRNC'),('Yes to use a watermark image.<br>','1','1338338320KGPY'),('Yes to use a watermark text.<br>','1','1338338320KGPZ'),('Specify the file path to the font file. If left empty it will use the default font.<div><div><br></div></div>','1','1338338320KGQA'),('Specify the position of watermark image.<br>','1','1338338320KGQB'),('Specify the text to use on the watermark.<br>','1','1338338320KGQC'),('Specify the position of watermark text.<br>','1','1338338320KGQD'),('Specify the font size of the text.<br>','1','1338338320KGQE'),('Text Color','1','1338404993PTOB'),('Text Opacity','1','1338404993PTOC'),('Text Roration','1','1338404993PTOD'),('Font File','1','1338404993PTOE'),('Specify the file path to the image to use as a watermark. <font color=\"#cc0033\">The image needs to be either PNG or JPG.</font><div>Start at the root of your site.<br><div><br></div></div>','1','1338404993PTOF'),('Specify the font color of the text using HEX notation.<br>','1','1338404993PTOG'),('Specify the text opacity over the image.<br>','1','1338404993PTOH'),('Specify the text rotation in degrees (eg: 90, 270 ).<br>','1','1338404993PTOI'),('Distribution Server','1','1338573341FLOL'),('Beta distribution server','1','1338573341FLON'),('Send me an email when new updates are available.','1','1338573341FLOO'),('The server which is contacted to install or updates production releases.<br>','1','1338573341FLOP'),('Choose the action to take when checking for updates','1','1338573342KOJF'),('Update a preference by URL','1','1338573342KOJG'),('Apps update is disabled!','1','1338581028LZCR'),('You need to define a preference node name (node=...)','1','1338581054ANGS'),('You need to define a preference name (name=...)','1','1338581054ANGT'),('Successfully updated preference!','1','1338581054ANGU'),('The Apps are running in beta. Beta mode should not be used in production website!','1','1338581058MKNK'),('Allow Apps\' Sound','1','1341595702FCVU'),('Yes to allow applications to use sounds on events.<br>','1','1341595703RHEE'),('All log files have been deleted!','1','1342037586EZIY'),('Delete all log files','1','1342037592PDAA'),('Final step of the installer','1','1345316856HADW');

INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Once a month','1','1411052474RANM'),('Optimize database','1','1411052475FVUA'),('Clear cache','1','1411052475FVUB'),('Yes to allow the system to optimized the tables in the database.','1','1411052475FVUC'),('Define if the cache needs to be cleared automatically and at what frequency.','1','1411052475FVUD'),('A new application called $APPLICATION is available!','1','1413479920LDPJ'),('An update is available for $APPLICATION','1','1413479920LDPK'),('Un-minified themes could not be retreived.','1','1413490911HRES'),('API key error or not defined!','1','1415107844LLSU'),('Use 24 Hours Date','1','1416385932KENZ'),('Yes to 24 hours style for the time rather than 12 hours AM / PM','1','1416385933AEDN'),('Log Install traces','1','1416812826GUVH'),('Show Configuration','1','1416812826GUVI'),('Show Page Details','1','1416812826GUVJ'),('Enables to directly edit and customize views.','1','1416812826GUVK'),('Yes to log the installation traces.','1','1416812826GUVL'),('Display a Panel at the bottom of the page with all the Preferences used to display the page.','1','1416812826GUVM'),('Display a Panel at the bottom of the page with all the information regarding the page.','1','1416812826GUVN'),('If the Itemid is not defined in the page, the specified value will be used.<br>Can be useful to avoid a link to render the front-end page modules.<span style=\"font-weight: bold;\"><br></span>','1','1418159312IWLR'),('<br><span style=\"font-style: italic; text-decoration: underline; font-weight: bold;\">About Update and Install:</span><br><ul><li>First click on <span style=\"font-weight: bold;\">Check</span> to get an updated list of all Applications available.</li><li>To install or update an application click on the <span style=\"font-weight: bold;\">Name</span> of the application you want to install.  You will be redirected to the main page of the application.</li><li>To change the grade of an application, click on the link in the <span style=\"font-weight: bold;\">Grades</span> column.</li></ul><span style=\"text-decoration: underline; font-style: italic; font-weight: bold;\">About License:</span><br><ul><li>If you have a token you can simply click on <span style=\"font-weight: bold;\">Enter token</span> and follow instruction.</li><li>You can use the button <span style=\"font-weight: bold;\">Refresh</span> to refresh all your licenses. It will re-actualize all your licenses.<br></li></ul>','1','1418159313RUIV'),('This is a list of all possible translation in any installed language:<br><br>1. To find your translation first select the proper language in the pick-list.<br>2. Choose your application<br>3. Click on the \"Edit\" button to edit the translation.<br>4. In case you do not find the proper string look for it in the main library in jCenter or jApps.<br><br>','1','1418159313RUIW'),('<span style=\"font-weight: bold; text-decoration: underline;\">Example of strings:</span><br><br>TR1242010181DZGB=Successfully Ordered $NUMBER $ELEMENT<br><br><span style=\"color: rgb(0, 51, 255);\">IMPORTANT</span>: <br>Make sure to respect the punctuation, cases and spacing as much as possible.<br>Sometimes you might see HTML tags or { tag: ... } in the definition, please leave it the way it is.<br><br><span style=\"color: rgb(0, 51, 255);\">VERY IMPORTANT: </span><br>Please do not touch the first string before the equal sign ( TR1242010181DZGB= ), it will result in translation not working. <br>The text to be translated is everything after the equal sign.<br><br><span style=\"color: rgb(0, 51, 255);\">VARIABLES</span>:<br>When you see a UPPER CASE string with a dollars sign in front ( $ELEMENT ), DO NOT translate, as it will be replaced by a variable or other string. However if you language require to reorder the works and the variable feel free to do so. The UPPER name of the of the variable give you an indication of what it will be replaced with.<br><br><span style=\"color: rgb(0, 51, 255);\">FINAL WORD</span><br>if you are looking for a string and dont find it, it might be in the main library so look for it into jCenter or jApps translation.<br><br>','1','1418159313RUIX'),('<p style=\"line-height: 1.4em;\">Please note that the site where you enter the API key FIRST will be the only site you are entitled for free support. <br>If you have a production site and a development site you need to decide if you prefer getting support for the production site or for the development site.<br>It is not possible to change the site on which you get primary support at a later time.<br> Should you have further question please <a target=\"_blank\" href=\"https://www.joobi.co/r.php?l=support\">contact the support.</a><br></p>','1','1418159317GYIO'),('Impossible to publish Widget without the application \"$APLLICATION\" installed on the site.','1','1418159318SHOQ'),('Choose','1','1421617710FQCB'),('Uninstall App','1','1421617712NRTN'),('Uninstall Only One App','1','1421617713IRWT'),('Uninstall All Apps','1','1421617713IRWU'),('Remove All Apps and All Data in Database','1','1421617713IRWV'),('Show hidden views','1','1422973803PSLT'),('Show the line number into the log.<div>This require a lot more memory. Use only in debug mode and make sure you have sufficient memory.</div>','1','1422973804PMJX'),('Fields for All Models','1','1423597825SYTZ'),('Allow the same field to be added on all <b>related models</b>.<br><b>Related models</b> are model which share the same table.&nbsp; When looking at the list of models you will see the table name.<br><u>E.g.</u>: the same field could be added to users and contacts model since they share the same table. It can\'t be added to vendors since it is another table.','1','1423597826QYJU'),('Default Page Id','1','1425339791AULI'),('No query has been defined!','1','1425662174IZVW'),('Social Media','1','1425956837EQIA'),('The author of the application','1','1426511377ENBT'),('Not available at the moment. Please check back later.','1','1426726331GHCC'),('Release Notes','1','1426726336DHKC'),('Load jQuery','1','1426800196HAOH'),('This is to load mootools first before you load jquery.','1','1426800196HAOI'),('Retrieving list of packages...','1','1427652792LBWK'),('Initialization','1','1427652792LBWL'),('Downloading packages','1','1427652792LBWM'),('Extracting packages...','1','1427652792LBWN'),('Extracting packages','1','1427652792LBWO'),('Moving files...','1','1427652792LBWP'),('Moving files','1','1427652792LBWQ'),('Creating tables','1','1427652792LBWR'),('Running custom install...','1','1427652792LBWS'),('Running custom functions','1','1427652793DOXK'),('All custom function run!','1','1427652793DOXL'),('Installing languages','1','1427652793DOXM'),('All languages downloaded!','1','1427652793DOXN'),('Finalization','1','1427652793DOXO'),('Install complete and successful!','1','1427652793DOXP'),('Show Install details','1','1427652796LGUR'),('Yes to display the install details','1','1427652797LLYT'),('Go setup','1','1427833134LQDZ'),('Update Check','1','1428084291QKNE'),('Show Support Chat','1','1428084291QKNF'),('Click Yes if you want to see the wizards for each view.','1','1428084291QKNG'),('Check & Download','1','1428084293SVQZ'),('There is no new package to install','1','1428532729DJHL'),('Return to Apps\' list','1','1429064415HVOW'),('No packages found!','1','1429238504IKNA'),('Install download folder reset successfully!','1','1429564804LHII'),('Clean Downloads','1','1429564806LXTQ'),('Reset Install','1','1429564806LXTR'),('Delete the install downloads files.','1','1429564807KXRS'),('No widget ID defined','1','1431936850KAHW'),('Click here to check on the requirements.','1','1432597449CAIM'),('The minimum requirements are not met, the installation cannot proceed.','1','1432597449CAIN'),('php-xml extension is not installed in your PHP server, it is highly recommanded.','1','1433250437OEYO'),('Reset the install if it stop or failed.<br>Do not click on this while an install is going on.','1','1436323210NDIP');
SET @dbcid_42 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_extension_node_publish' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5publish' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_node_wid' LIMIT 1),'1','0',@dbcid_42),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extensiontrans_wid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extensiontrans_wid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_dependency_wid_ref_wid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_dependency_wid_ref_wid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352ref_wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_languages_wid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_languages_wid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_version_wid_version' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_version_wid_version' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473version' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_level_wid_level' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_level_wid_level' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_leveltrans_lwid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lwid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_leveltrans_lwid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_node_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_extension_level' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey509' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_enable' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid657' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_info|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='662wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_enable' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='level657' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_translation' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_translation' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981lgid' LIMIT 1));
SET @ref_feid_43 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1);
SET @pk_77_309 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'287wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_515 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'287lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_587 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'352wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_1000 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'352ref_wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_490 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'423lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_489 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'423wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_540 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'473wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10572 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'5parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_588 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'509wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_589 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'510lwid\' LIMIT 1' LIMIT 1 );
SET @pk_77_590 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'510lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10393 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'role.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'5rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10608 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'wid657\' LIMIT 1' LIMIT 1 );
SET @pk_77_10622 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'662wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11012 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.files\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'filid473\' LIMIT 1' LIMIT 1 );
SET @pk_77_11011 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid473\' LIMIT 1' LIMIT 1 );
SET @pk_77_11108 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'981wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11109 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'981lgid\' 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_extension_trans_wid',@pk_77_309,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287wid' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_4,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('lgid','1','FK_extension_trans_lgid',@pk_77_515,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287lgid' LIMIT 1),@ref_feid_43,'1','1','lgid',@dbtid_11,@dbtid_4,'2'),('wid','1','FK_extension_dependency_wid',@pk_77_587,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352wid' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_5,'1'),('ref_wid','1','FK_extension_dependency_ref_wid',@pk_77_1000,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352ref_wid' LIMIT 1),@dbcid_42,'1','3','wid',@dbtid_3,@dbtid_5,'2'),('lgid','1','FK_extension_languages_lgid',@pk_77_490,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423lgid' LIMIT 1),@ref_feid_43,'1','3','lgid',@dbtid_11,@dbtid_6,'2'),('wid','1','FK_extension_languages_wid',@pk_77_489,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='423wid' LIMIT 1),@dbcid_42,'1','3','wid',@dbtid_3,@dbtid_6,'1'),('wid','1','FK_package_version_wid',@pk_77_540,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='473wid' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_2,'3'),('parent','1','FK_Parent5_parentwid',@pk_77_10572,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5parent' LIMIT 1),@dbcid_42,'1','1','wid',@dbtid_3,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'99'),('wid','0','FK_model_level_wid',@pk_77_588,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509wid' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_1,'99'),('lwid','1','FK_extension_leveltrans_lwid',@pk_77_589,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lwid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509lwid' LIMIT 1),'3','3','lwid',@dbtid_1,@dbtid_7,'99'),('lgid','1','FK_extension_leveltrans_lgid',@pk_77_590,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510lgid' LIMIT 1),@ref_feid_43,'1','1','lgid',@dbtid_11,@dbtid_7,'99'),('rolid','1','FK_extension_rolid',@pk_77_10393,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),@dbtid_3,'99'),('wid','1','FK_extensionEnabled_wid',@pk_77_10608,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid657' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_8,'1'),('wid','1','FK_extension_info_wid',@pk_77_10622,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='662wid' LIMIT 1),@dbcid_42,'3','3','wid',@dbtid_3,@dbtid_9,'1'),('filid','1','FK_extenversion_filid',@pk_77_11012,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid473' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1),'3','3','filid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),@dbtid_2,'2'),('uid','1','473_uid_232',@pk_77_11011,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid473' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'1','1','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),@dbtid_2,'1'),('wid','1','FK_apps_translation_wid',@pk_77_11108,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981wid' LIMIT 1),@dbcid_42,'1','3','wid',@dbtid_3,@dbtid_10,'1'),('lgid','1','FK_apps_translation_lgid',@pk_77_11109,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='981lgid' LIMIT 1),@ref_feid_43,'1','3','lgid',@dbtid_11,@dbtid_10,'2');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_12,'1','1206732372QTKL');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_12,'0','1206732393CXVX'),(@wid_12,'0','1206732393CXVY'),(@wid_12,'0','1206732394IZGY'),(@wid_12,'0','1206732394IZHB'),(@wid_12,'1','1206732395DOFD'),(@wid_12,'0','1206732397TAXO'),(@wid_12,'1','1206732397TAXY'),(@wid_12,'0','1206732397TAYG'),(@wid_12,'0','1206732398LZJD'),(@wid_12,'1','1206732400OWZO'),(@wid_12,'1','1206732400OXCC'),(@wid_12,'1','1206732410ICCJ'),(@wid_12,'0','1206961836KSBJ'),(@wid_12,'0','1206961836KSBK'),(@wid_12,'0','1206961836KSBL'),(@wid_12,'1','1206961905BHAV'),(@wid_12,'1','1206961944PEUR'),(@wid_12,'0','1209746216SXQF'),(@wid_12,'1','1211280056BEZM'),(@wid_12,'0','1213020848LZMA'),(@wid_12,'0','1213020848LZMB'),(@wid_12,'0','1213020848LZMC'),(@wid_12,'0','1213020848LZME'),(@wid_12,'0','1213020848LZMF'),(@wid_12,'0','1213020853MLHQ'),(@wid_12,'0','1213107637HXCS'),(@wid_12,'0','1215710386RMJC'),(@wid_12,'0','1215710386RMJD'),(@wid_12,'0','1227579883OZMZ'),(@wid_12,'1','1227580898LIDX'),(@wid_12,'1','1228709213SHFK'),(@wid_12,'0','1229651871ADBG'),(@wid_12,'0','1229651871ADBH'),(@wid_12,'0','1229651871ADBI'),(@wid_12,'1','1231158811CQTU'),(@wid_12,'1','1232547361JEQR'),(@wid_12,'0','1235976558LLLB'),(@wid_12,'0','1235976558LLLC'),(@wid_12,'0','1235976558LLLD'),(@wid_12,'0','1245769651NPXC'),(@wid_12,'1','1247466190MROL'),(@wid_12,'0','1248835367AECZ'),(@wid_12,'0','1248948187IFCW'),(@wid_12,'0','1249562683MMMY'),(@wid_12,'0','1249567958KVAQ'),(@wid_12,'0','1251770410PASS'),(@wid_12,'0','1251770410PAST'),(@wid_12,'0','1251905717NHWT'),(@wid_12,'0','1251905717NHWU'),(@wid_12,'0','1251905717NHWW'),(@wid_12,'0','1251905718PEOQ'),(@wid_12,'0','1251905719IQBZ'),(@wid_12,'0','1251905719IQCA'),(@wid_12,'0','1251912852OWAG'),(@wid_12,'0','1251959063BNBJ'),(@wid_12,'0','1260434893HJHQ'),(@wid_12,'0','1260434893HJHR'),(@wid_12,'0','1260443578NNAV'),(@wid_12,'0','1298294128HPXJ'),(@wid_12,'0','1298294128HPXK'),(@wid_12,'0','1298294132BJZM'),(@wid_12,'0','1298350280PMMA'),(@wid_12,'0','1303354916DPMU'),(@wid_12,'1','1310984711PXOI'),(@wid_12,'0','1337190873HKCO'),(@wid_12,'0','1338581028LZCR'),(@wid_12,'0','1338581054ANGS'),(@wid_12,'0','1338581054ANGT'),(@wid_12,'0','1338581054ANGU'),(@wid_12,'0','1338581058MKNK'),(@wid_12,'0','1342037586EZIY'),(@wid_12,'1','1347915878MZME'),(@wid_12,'1','1349115733NNHN'),(@wid_12,'1','1357059110IPWM'),(@wid_12,'1','1357387105DGOO'),(@wid_12,'1','1357387105DGOP'),(@wid_12,'0','1357567981LCEH'),(@wid_12,'0','1359218479BLAZ'),(@wid_12,'0','1377109823CPMJ'),(@wid_12,'0','1377368277IDOY'),(@wid_12,'0','1377368277IDOZ'),(@wid_12,'1','1378928005HOHD'),(@wid_12,'1','1378928005HOHE'),(@wid_12,'1','1389125413BAER'),(@wid_12,'0','1389275707OUAK'),(@wid_12,'0','1389275708EKXJ'),(@wid_12,'0','1389293010DETE'),(@wid_12,'0','1389293010DETJ'),(@wid_12,'0','1389439751KWKS'),(@wid_12,'1','1389656307QIHM'),(@wid_12,'0','1389656307QIHN'),(@wid_12,'0','1389701736EXGV'),(@wid_12,'0','1389701736EXGW'),(@wid_12,'0','1389701736EXGX'),(@wid_12,'0','1389701736EXGY'),(@wid_12,'0','1389701736EXGZ'),(@wid_12,'0','1389879769JPHN'),(@wid_12,'0','1392062121NBKP'),(@wid_12,'0','1401297229KKPC'),(@wid_12,'1','1413479920LDPJ'),(@wid_12,'1','1413479920LDPK');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_12,'0','1413490911HRES'),(@wid_12,'0','1415107844LLSU'),(@wid_12,'1','1418159317GYIO'),(@wid_12,'0','1418159318SHOQ'),(@wid_12,'0','1425662174IZVW'),(@wid_12,'1','1426726331GHCC'),(@wid_12,'1','1427652792LBWK'),(@wid_12,'1','1427652792LBWL'),(@wid_12,'1','1427652792LBWM'),(@wid_12,'1','1427652792LBWN'),(@wid_12,'1','1427652792LBWO'),(@wid_12,'1','1427652792LBWP'),(@wid_12,'1','1427652792LBWQ'),(@wid_12,'1','1427652792LBWR'),(@wid_12,'1','1427652792LBWS'),(@wid_12,'1','1427652793DOXK'),(@wid_12,'1','1427652793DOXL'),(@wid_12,'1','1427652793DOXM'),(@wid_12,'1','1427652793DOXN'),(@wid_12,'1','1427652793DOXO'),(@wid_12,'1','1427652793DOXP'),(@wid_12,'1','1427833134LQDZ'),(@wid_12,'1','1428532729DJHL'),(@wid_12,'1','1429064415HVOW'),(@wid_12,'1','1429238504IKNA'),(@wid_12,'0','1429564804LHII'),(@wid_12,'1','1431936850KAHW'),(@wid_12,'1','1432597449CAIM'),(@wid_12,'1','1432597449CAIN'),(@wid_12,'0','1433250437OEYO');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_12),'','','','','','','','','','','0','');
SET @dbcid_44 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_12,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='287description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_12,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='510description' LIMIT 1)),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1),'1267607212GWJP',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.userinfos' LIMIT 1),'1298350283NKJB',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.level' LIMIT 1),'1298350283NKJC',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.dependency' LIMIT 1),'1298350283NKJD',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.info' LIMIT 1),'1298350283NKJE',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='appstrans' LIMIT 1),'1298350283NKJF',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.leveltrans' LIMIT 1),'1298350283NKJG',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.version' LIMIT 1),'1298350284IYPA',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.languages' LIMIT 1),'1299065683HDEE',@dbcid_44),(@wid_12,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps.translations' LIMIT 1),'1319035319DBIP',@dbcid_44);