/*Export of the extension install.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1206732405TIXE','1298350305KUTU','1209142268NMKA','1304525968YBL','1298350305KUTV','1235461972DIWB','1206732388KEHV','1298350306NYBQ','1298350306NYBR','1298618260QLYK','1307940274ANGO','1307940274ANGP','1307940274ANGQ','1307940274ANGR','1377558447LBSX','1206732392OZUR','1378737429DEXY','1206961893RSRQ','1206732392OZVD','1416948599JVQT','1302090354NZFX','1206732431CQBG','1432423412LOHZ','1206732372QTKI','1206732372QTKJ','1206961889EEYJ','1206961954EAMU','1211280055AYDS','1213020853MLHP','1213020853MLHV','1213107629LYER','1213107630MBVS','1213794916KBVX','1213794916KBVY','1215002067FIWP','1221227936IUXD','1227579827CIXW','1227579828FTWS','1227579828FTWT','1227579828FTWU','1236536983NQDJ','1242282416HAQS','1242282417SQLA','1242282433QMCF','1249442156QUCO','1260151166CSBV','1260151166CSBW','1298294123FNDM','1298294193EGSU','1298350274FGVE','1298350310EWVG','1298350310EWVH','1298350310EWVI','1303104133RCSA','1307005747JWMB','1308836335LUUQ','1317823749MRTP','1338581028LZCR','1360366414NJAJ','1389108457QWKA','1389275714NKEJ','1389701766DFGL','1389701766DFGM','1389965492NTIZ','1389965492NTJA','1389965492NTJB','1389965492NTJC','1389965492NTJD','1389965492NTJE','1389988802RQBQ','1389988802RQBR','1395716602EKEW','1395716605OVVZ','1397671837IMCS','1397671839JQGR','1427652812DTKK','1427652813TJJQ','1427652813TJJR','1427652813TJJS','1427652813TJJT','1427652814RAOH','1427652814RAOI','1427652814RAOJ','1427652814RAOK','1427652814RAOL','1427652814RAON','1427652814RAOO','1427739324NDEY','1427739324NDEZ','1427986835NTMI','1428371836FLXB','1432423407JSWF','1432423407JSWG','1432423407JSWH','1432423407JSWI','1432423407JSWJ','1432423407JSWK','1432423407JSWL','1432423407JSWM','1432423407JSWN','1432423407JSWO','1432423407JSWP','1432423407JSWQ','1432423407JSWR','1432423407JSWS','1432423407JSWT','1432423407JSWU','1433250455EAMT' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('joobi.languages','extension.level','extension.node','role.node','extension.dependency','translation.reference','role.trans','model.node','extension.userinfos','extension.info','translation.en','modules','extensions','menu','scheduler.node','user.usergroup.map','widgets.type','widgets.type.trans') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('extension.node','joobi.languages','extension.dependency','scheduler.node','extension.level','translation.reference','role.trans','role.node','model.node','extension.userinfos','extension.info','translation.en','modules','extensions','menu','user.usergroup.map','widgets.type','widgets.type.trans','dataset.tables','components','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('5publish','5folder','5wid','5params','5status','5type','5name','199lgid','199code','199premium','352wid','352ref_wid','199name','199main','199publish','199real','460schid','460nextdate','460frequency','460priority','460lastdate','460publish','460created','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','485mid','485lgid','485name','5destination','5parent','509lwid','509wid','509level','511wid','511load','5trans','5certify','509status','5namekey','5version','5lversion','199rtl','549dbid','549name','549namekey','5pref','549modified','549dbtid','566rolid','566parent','566lft','566rgt','566core','568rolid','568lgid','568name','568description','566joomla','481wname','481wdescription','566namekey','566color','5rolid','566type','5install','460params','460cron','199availadmin','199availsite','549prefix','549version','549rolid','549level','549type','549pkey','618sid','618lgid','618name','621sid','621dbtid','621path','621namekey','621folder','621rolid','621level','621publish','621created','621extended','621checkval','621params','549suffix','549group','460ptype','621alias','199locale','566depth','621prefix','199localeconv','621ordering','ordering5','core5','domaine549','suffix621','export549','exportdelete549','namekey509','namekey460','imac511','enable657','wid657','662wid','author662','documentation662','images662','flash662','support662','forum662','homeurl662','joomlafeedback662','userversion662','userlversion662','level657','license657','modified5','token657','ltype657','expire657','maintenance657','beta662','flag657','id583','core460','report460','713imac','text713','auto713','714ctrid','714lgid','name714','description714','description485','auto568','fromlgid568','auto481','fromlgid481','auto482','fromlgid482','auto485','fromlgid485','auto618','fromlgid618','auto714','fromlgid714','id595','title595','name595','image595','scope595','image_position595','description595','published595','check_out595','checked_out_time595','ordering595','access595','count595','params595','state595','extstid621','915extension_id','916id','maxtime460','maxprocess460','j16566','922user_id','922group_id','nbchars713','viewname460','fields621','checkout621','trash621','audit621','modified621','totalcustom621','reload5','reload621','1030wgtypeid','1031wgtypeid','1031lgid','name1031','description1031','auto1031','fromlgid1031','namekey1030','alias1030','type1030','rolid1030','uid1030','core1030','publish1030','created1030','modified1030','core199','core621','groupid1030','noaudit549','created5','subtype657','keyword662','icon621','automatic199','pnamekey621','showconfig5','framework5','message485','engine549') 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 ('352wid','509wid','511wid','imac511','352ref_wid','568rolid','568lgid','5rolid','621dbtid','621rolid','566parent','5parent','wid657','662wid','id595','1031wgtypeid','1031lgid') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_widgets_type_trans_lgid','FK_widgets_type_trans_wgtypeid','FK_extension_dependency_ref_wid','FK_extension_dependency_wid','FK_model_level_wid','FK_translation_reference_wid','FK_parent_child_rolid','FK_role_trans_lgid','FK_role_trans_rolid','FK_Parent5_parentwid','FK_extension_rolid','FK_model_dbtid','FK_model_rolid','FK_extension_info_wid','595_id_595','FK_translation_reference_imac','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 ('install.node') ;
SET @rolid_0 = (1);
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_352 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.dependency' LIMIT 1 );
SET @pk_549_460 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.node' LIMIT 1 );
SET @pk_549_509 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.level' LIMIT 1 );
SET @pk_549_511 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.reference' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_568 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1 );
SET @pk_549_595 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1 );
SET @pk_549_621 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' 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_713 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.en' LIMIT 1 );
SET @pk_549_915 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extensions' LIMIT 1 );
SET @pk_549_916 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='menu' LIMIT 1 );
SET @pk_549_922 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='user.usergroup.map' LIMIT 1 );
SET @pk_549_1030 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type' LIMIT 1 );
SET @pk_549_1031 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type.trans' LIMIT 1 );
SET @pk_549_549 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.tables' LIMIT 1 );
SET @pk_549_583 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='components' LIMIT 1 );
SET @pk_549_469 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='plugins' 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_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' 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 ('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','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'),('scheduler_node','scheduler.node',@pk_549_460,'','1.0.0',@rolid_0,'0','1','schid','node','scheduler','51','0','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'),('translation_reference','translation.reference',@pk_549_511,'','1.0.0',@rolid_0,'0','30','wid,imac','reference','translation','11','0','2','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('role_trans','role.trans',@pk_549_568,'','1.0.0',@rolid_0,'0','20','rolid,lgid','trans','role','51','2','0','0','7'),('modules','modules',@pk_549_595,'','1.0.0',@rolid_0,'0','1','id','','modules','250','0','0','1','7'),('model_node','model.node',@pk_549_621,'','1.0.0',@rolid_0,'0','1','sid','node','model','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'),('translation_en','translation.en',@pk_549_713,'','',@rolid_0,'0','1','imac','en','translation','11','2','0','0','5'),('extensions','extensions',@pk_549_915,'','',@rolid_0,'0','1','extension_id','','extensions','250','2','0','1','7'),('menu','menu',@pk_549_916,'','',@rolid_0,'0','40','id','','menu','250','2','0','1','7'),('user_usergroup_map','user.usergroup.map',@pk_549_922,'','',@rolid_0,'0','30','user_id,group_id','usergroup_map','user','250','2','0','1','7'),('widgets_type','widgets.type',@pk_549_1030,'','',@rolid_0,'0','1','wgtypeid','','','51','2','0','0','7'),('widgets_type_trans','widgets.type.trans',@pk_549_1031,'','',@rolid_0,'0','20','wgtypeid,lgid','','','51','2','0','0','7'),('dataset_tables','dataset.tables',@pk_549_549,'','1.0.0',@rolid_0,'0','1','dbtid','tables','db','9','0','0','1','7'),('components','components',@pk_549_583,'','1.0.0',@rolid_0,'0','1','id','','components','250','0','0','1','7'),('plugins','plugins',@pk_549_469,'','1.0.0',@rolid_0,'0','1','id','','plugins','250','0','0','1','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_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','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`='joobi.languages' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.level' 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`='role.node' 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`='translation.reference' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.trans' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.info' LIMIT 1);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='translation.en' LIMIT 1);
SET @dbtid_12 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1);
SET @dbtid_13 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.node' LIMIT 1);
SET @dbtid_14 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='user.usergroup.map' LIMIT 1);
SET @dbtid_15 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type' LIMIT 1);
SET @dbtid_16 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.type.trans' LIMIT 1);
SET @pk_454_126 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_languages_code' LIMIT 1 );
SET @pk_454_4215 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_level_wid_level' LIMIT 1 );
SET @pk_454_32063 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_extension_node_namekey' LIMIT 1 );
SET @pk_454_43800 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_role_node_namekey' LIMIT 1 );
SET @pk_454_65413 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_dependency_wid_ref_wid' LIMIT 1 );
SET @pk_454_65443 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_reference_wid_imac' LIMIT 1 );
SET @pk_454_65468 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_roletrans_rolid_lgid' LIMIT 1 );
SET @pk_454_65498 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_node_sid' LIMIT 1 );
SET @pk_454_65499 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_languages' LIMIT 1 );
SET @pk_454_65517 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extension_node_wid' LIMIT 1 );
SET @pk_454_65523 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_model_node_namekey' 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_65636 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_en|main_translation' LIMIT 1 );
SET @pk_454_65748 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_modules|main_joomla15' LIMIT 1 );
SET @pk_454_65847 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extensions|main_joomla15' LIMIT 1 );
SET @pk_454_65848 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_menu|main_joomla15' LIMIT 1 );
SET @pk_454_65852 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_reference_load' LIMIT 1 );
SET @pk_454_65855 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1 );
SET @pk_454_65857 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1 );
SET @pk_454_65862 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_extension_node_publish' LIMIT 1 );
SET @pk_454_65865 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_dbtic' LIMIT 1 );
SET @pk_454_65867 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_languages_main_publish_availadmin_availsite' LIMIT 1 );
SET @pk_454_65875 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_user_usergroup_map|main_joomla16' LIMIT 1 );
SET @pk_454_65927 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_scheduler_node' LIMIT 1 );
SET @pk_454_66026 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type' LIMIT 1 );
SET @pk_454_66027 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1 );
SET @pk_454_66028 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_type_namekey' LIMIT 1 );
SET @pk_454_66158 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='ix_translation_en_nbchars' LIMIT 1 );
SET @pk_454_65854 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_wid' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_126,'1','UK_languages_code',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_4215,'1','UK_extension_level_wid_level',@dbtid_2),(@pk_454_32063,'1','UK_extension_node_namekey',@dbtid_3),(@pk_454_43800,'1','UK_role_node_namekey',@dbtid_4),(@pk_454_65413,'3','PK_extension_dependency_wid_ref_wid',@dbtid_5),(@pk_454_65443,'3','PK_translation_reference_wid_imac',@dbtid_6),(@pk_454_65468,'3','PK_roletrans_rolid_lgid',@dbtid_7),(@pk_454_65498,'3','PK_model_node_sid',@dbtid_8),(@pk_454_65499,'3','PK_languages',@dbtid_1),(@pk_454_65517,'3','PK_extension_node_wid',@dbtid_3),(@pk_454_65523,'1','UK_model_node_namekey',@dbtid_8),(@pk_454_65548,'1','UK_namekey_extension_level',@dbtid_2),(@pk_454_65555,'3','PK_extension_enable',@dbtid_9),(@pk_454_65564,'3','PK_extension_info|main_library',@dbtid_10),(@pk_454_65636,'3','PK_translation_en|main_translation',@dbtid_11),(@pk_454_65748,'3','PK_modules|main_joomla15',@dbtid_12),(@pk_454_65847,'3','PK_extensions|main_joomla15',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extensions' LIMIT 1)),(@pk_454_65848,'3','PK_menu|main_joomla15',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='menu' LIMIT 1)),(@pk_454_65852,'2','IX_translation_reference_load',@dbtid_6),(@pk_454_65855,'2','IX_scheduler_node_publish_priority_nextdate',@dbtid_13),(@pk_454_65857,'2','IX_model_node_prefix_level',@dbtid_8),(@pk_454_65862,'2','IX_extension_node_publish',@dbtid_3),(@pk_454_65865,'2','IX_model_node_dbtic',@dbtid_8),(@pk_454_65867,'2','IX_languages_main_publish_availadmin_availsite',@dbtid_1),(@pk_454_65875,'3','PK_user_usergroup_map|main_joomla16',@dbtid_14),(@pk_454_65927,'1','UK_namekey_scheduler_node',@dbtid_13),(@pk_454_66026,'3','PK_widgets_type',@dbtid_15),(@pk_454_66027,'3','PK_widgets_type_trans',@dbtid_16),(@pk_454_66028,'1','UK_widgets_type_namekey',@dbtid_15),(@pk_454_66158,'2','ix_translation_en_nbchars',@dbtid_11),(@pk_454_65854,'2','IX_scheduler_node_wid',@dbtid_13);
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_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_1699 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199code' 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_2654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199main' LIMIT 1 );
SET @pk_616_2655 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199publish' LIMIT 1 );
SET @pk_616_3254 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460nextdate' LIMIT 1 );
SET @pk_616_3256 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460priority' LIMIT 1 );
SET @pk_616_3277 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460publish' 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_3488 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1 );
SET @pk_616_3490 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511load' LIMIT 1 );
SET @pk_616_3545 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5namekey' LIMIT 1 );
SET @pk_616_5537 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1 );
SET @pk_616_5538 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1 );
SET @pk_616_5587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566namekey' LIMIT 1 );
SET @pk_616_5837 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199availadmin' LIMIT 1 );
SET @pk_616_5838 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199availsite' LIMIT 1 );
SET @pk_616_6055 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1 );
SET @pk_616_6056 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1 );
SET @pk_616_6058 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621namekey' LIMIT 1 );
SET @pk_616_6061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621level' LIMIT 1 );
SET @pk_616_6161 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621prefix' LIMIT 1 );
SET @pk_616_6326 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey509' LIMIT 1 );
SET @pk_616_6329 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey460' LIMIT 1 );
SET @pk_616_6377 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' 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_6781 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1 );
SET @pk_616_7781 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id595' LIMIT 1 );
SET @pk_616_8396 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='915extension_id' LIMIT 1 );
SET @pk_616_8397 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='916id' LIMIT 1 );
SET @pk_616_8449 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='922user_id' LIMIT 1 );
SET @pk_616_8450 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='922group_id' LIMIT 1 );
SET @pk_616_8758 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='nbchars713' LIMIT 1 );
SET @pk_616_9581 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1 );
SET @pk_616_9582 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1 );
SET @pk_616_9583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1 );
SET @pk_616_9588 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1030' LIMIT 1 );
SET @pk_616_5468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='549dbtid' 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_5533 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566parent' LIMIT 1 );
SET @pk_616_5658 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5rolid' LIMIT 1 );
SET @pk_616_6060 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621rolid' 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_1700 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199premium' LIMIT 1 );
SET @pk_616_2653 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199name' LIMIT 1 );
SET @pk_616_2656 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199real' LIMIT 1 );
SET @pk_616_3250 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460schid' LIMIT 1 );
SET @pk_616_3255 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460frequency' LIMIT 1 );
SET @pk_616_3257 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460lastdate' LIMIT 1 );
SET @pk_616_3280 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460created' LIMIT 1 );
SET @pk_616_3432 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5destination' LIMIT 1 );
SET @pk_616_3477 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509lwid' 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_3679 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199rtl' LIMIT 1 );
SET @pk_616_5460 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5pref' LIMIT 1 );
SET @pk_616_5534 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566lft' LIMIT 1 );
SET @pk_616_5535 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rgt' LIMIT 1 );
SET @pk_616_5536 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566core' LIMIT 1 );
SET @pk_616_5539 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568name' LIMIT 1 );
SET @pk_616_5540 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568description' LIMIT 1 );
SET @pk_616_5577 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566joomla' LIMIT 1 );
SET @pk_616_5621 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566color' LIMIT 1 );
SET @pk_616_5668 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566type' LIMIT 1 );
SET @pk_616_5675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5install' LIMIT 1 );
SET @pk_616_5747 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460params' LIMIT 1 );
SET @pk_616_5758 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460cron' LIMIT 1 );
SET @pk_616_6057 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621path' LIMIT 1 );
SET @pk_616_6059 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621folder' LIMIT 1 );
SET @pk_616_6062 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621publish' LIMIT 1 );
SET @pk_616_6063 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621created' LIMIT 1 );
SET @pk_616_6064 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621extended' LIMIT 1 );
SET @pk_616_6065 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621checkval' LIMIT 1 );
SET @pk_616_6066 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621params' LIMIT 1 );
SET @pk_616_6070 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460ptype' LIMIT 1 );
SET @pk_616_6077 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621alias' LIMIT 1 );
SET @pk_616_6081 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199locale' LIMIT 1 );
SET @pk_616_6124 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566depth' LIMIT 1 );
SET @pk_616_6162 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199localeconv' LIMIT 1 );
SET @pk_616_6163 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621ordering' 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_6221 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='suffix621' 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_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_6671 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='flag657' LIMIT 1 );
SET @pk_616_6689 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id583' LIMIT 1 );
SET @pk_616_6697 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core460' LIMIT 1 );
SET @pk_616_6699 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='report460' LIMIT 1 );
SET @pk_616_6782 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='text713' LIMIT 1 );
SET @pk_616_6783 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto713' LIMIT 1 );
SET @pk_616_6802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto568' LIMIT 1 );
SET @pk_616_6803 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid568' LIMIT 1 );
SET @pk_616_7782 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title595' LIMIT 1 );
SET @pk_616_7783 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name595' LIMIT 1 );
SET @pk_616_7784 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='image595' LIMIT 1 );
SET @pk_616_7785 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='scope595' LIMIT 1 );
SET @pk_616_7786 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='image_position595' LIMIT 1 );
SET @pk_616_7787 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description595' LIMIT 1 );
SET @pk_616_7788 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='published595' LIMIT 1 );
SET @pk_616_7789 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='check_out595' LIMIT 1 );
SET @pk_616_7790 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checked_out_time595' LIMIT 1 );
SET @pk_616_7791 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering595' LIMIT 1 );
SET @pk_616_7792 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='access595' LIMIT 1 );
SET @pk_616_7793 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='count595' LIMIT 1 );
SET @pk_616_7794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params595' LIMIT 1 );
SET @pk_616_7795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='state595' LIMIT 1 );
SET @pk_616_7851 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='extstid621' LIMIT 1 );
SET @pk_616_8433 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='maxtime460' LIMIT 1 );
SET @pk_616_8434 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='maxprocess460' LIMIT 1 );
SET @pk_616_8447 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='j16566' LIMIT 1 );
SET @pk_616_8759 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='viewname460' LIMIT 1 );
SET @pk_616_9083 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fields621' LIMIT 1 );
SET @pk_616_9291 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checkout621' LIMIT 1 );
SET @pk_616_9292 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='trash621' LIMIT 1 );
SET @pk_616_9293 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='audit621' LIMIT 1 );
SET @pk_616_9295 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified621' LIMIT 1 );
SET @pk_616_9346 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='totalcustom621' LIMIT 1 );
SET @pk_616_9504 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload5' LIMIT 1 );
SET @pk_616_9506 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload621' LIMIT 1 );
SET @pk_616_9584 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1031' LIMIT 1 );
SET @pk_616_9585 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1031' LIMIT 1 );
SET @pk_616_9586 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto1031' LIMIT 1 );
SET @pk_616_9587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid1031' LIMIT 1 );
SET @pk_616_9589 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias1030' LIMIT 1 );
SET @pk_616_9590 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type1030' LIMIT 1 );
SET @pk_616_9591 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid1030' LIMIT 1 );
SET @pk_616_9592 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid1030' LIMIT 1 );
SET @pk_616_9593 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1030' LIMIT 1 );
SET @pk_616_9594 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1030' LIMIT 1 );
SET @pk_616_9595 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created1030' LIMIT 1 );
SET @pk_616_9596 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified1030' LIMIT 1 );
SET @pk_616_9661 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core199' LIMIT 1 );
SET @pk_616_9667 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core621' LIMIT 1 );
SET @pk_616_9678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='groupid1030' 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_10178 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='icon621' LIMIT 1 );
SET @pk_616_10666 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='automatic199' LIMIT 1 );
SET @pk_616_10812 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='pnamekey621' 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_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_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_1698,@dbtid_1,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_1699,@dbtid_1,'code','0','1','15','0','1','','2','1',@rolid_0,'0','10','1','199code','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_2654,@dbtid_1,'main','0','1','1','1','1','0','5','1',@rolid_0,'0','0','1','199main','1','0','0'),(@pk_616_2655,@dbtid_1,'publish','0','1','1','0','1','0','6','1',@rolid_0,'0','0','0','199publish','1','0','0'),(@pk_616_3254,@dbtid_13,'nextdate','0','1','4','1','1','0','6','1',@rolid_0,'0','0','0','460nextdate','1','1','0'),(@pk_616_3256,@dbtid_13,'priority','0','0','1','1','1','0','5','1',@rolid_0,'0','0','1','460priority','1','0','0'),(@pk_616_3277,@dbtid_13,'publish','0','0','1','0','1','1','4','1',@rolid_0,'0','0','0','460publish','1','0','0'),(@pk_616_3478,@dbtid_2,'wid','0','0','3','1','1','0','3','1',@rolid_0,'0','0','1','509wid','1','0','0'),(@pk_616_3479,@dbtid_2,'level','0','0','1','1','1','0','2','1',@rolid_0,'0','0','1','509level','1','0','0'),(@pk_616_3488,@dbtid_6,'wid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','511wid','1','0','0'),(@pk_616_3490,@dbtid_6,'load','0','0','25','0','1','0','3','1',@rolid_0,'0','0','1','511load','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_5537,@dbtid_7,'rolid','1','0','2','1','1','','50','1',@rolid_0,'0','0','1','568rolid','1','0','0'),(@pk_616_5538,@dbtid_7,'lgid','1','0','1','1','1','','50','1',@rolid_0,'0','0','1','568lgid','1','0','0'),(@pk_616_5587,@dbtid_4,'namekey','0','1','14','0','1','','2','1',@rolid_0,'0','50','1','566namekey','1','0','0'),(@pk_616_5837,@dbtid_1,'availadmin','0','1','1','1','1','0','7','1',@rolid_0,'0','0','0','199availadmin','1','0','0'),(@pk_616_5838,@dbtid_1,'availsite','0','1','1','1','1','0','8','1',@rolid_0,'0','0','0','199availsite','1','0','0'),(@pk_616_6055,@dbtid_8,'sid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','621sid','1','0','0'),(@pk_616_6056,@dbtid_8,'dbtid','0','0','2','1','1','0','2','1',@rolid_0,'0','0','1','621dbtid','1','0','0'),(@pk_616_6058,@dbtid_8,'namekey','0','1','14','0','1','','5','1',@rolid_0,'0','50','1','621namekey','1','0','0'),(@pk_616_6061,@dbtid_8,'level','0','0','1','1','1','0','8','1',@rolid_0,'0','0','1','621level','1','0','0'),(@pk_616_6161,@dbtid_8,'prefix','0','0','14','0','1','','14','1',@rolid_0,'0','50','1','621prefix','1','0','0'),(@pk_616_6326,@dbtid_2,'namekey','0','1','14','0','1','','5','0','0','0','50','1','namekey509','1','0','0'),(@pk_616_6329,@dbtid_13,'namekey','0','1','14','0','1','','12','0','0','0','50','1','namekey460','1','0','0'),(@pk_616_6377,@dbtid_6,'imac','1','1','14','0','1','','4','0','0','0','255','1','imac511','1','0','0'),(@pk_616_6382,@dbtid_9,'wid','1','0','4','1','1','','1','0','0','1','0','0','wid657','1','0','0'),(@pk_616_6443,@dbtid_10,'wid','1','0','4','1','1','','1','0','0','1','0','1','662wid','1','0','0'),(@pk_616_6460,@dbtid_9,'level','1','1','1','1','1','0','2','0','0','0','0','0','level657','1','0','0'),(@pk_616_6781,@dbtid_11,'imac','1','0','4','1','1','','1','0','0','1','0','1','713imac','1','0','0'),(@pk_616_7781,@dbtid_12,'id','1','1','1','1','1','','1','0','0','1','11','1','id595','1','0','0'),(@pk_616_8396,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extensions' LIMIT 1),'extension_id','1','0','4','1','1','','0','0','0','1','0','0','915extension_id','1','0','0'),(@pk_616_8397,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='menu' LIMIT 1),'id','1','0','4','1','1','','0','0','0','1','0','1','916id','1','0','0'),(@pk_616_8449,@dbtid_14,'user_id','1','0','4','1','1','','0','0','0','0','0','1','922user_id','1','0','0'),(@pk_616_8450,@dbtid_14,'group_id','1','0','4','1','1','','1','0','0','0','0','1','922group_id','1','0','0'),(@pk_616_8758,@dbtid_11,'nbchars','0','1','4','1','1','0','4','0','0','0','0','0','nbchars713','1','0','0'),(@pk_616_9581,@dbtid_15,'wgtypeid','1','0','3','1','1','','1','0','0','1','0','0','1030wgtypeid','1','0','0'),(@pk_616_9582,@dbtid_16,'wgtypeid','1','0','3','1','1','','1','0','0','0','0','1','1031wgtypeid','1','0','0'),(@pk_616_9583,@dbtid_16,'lgid','1','0','2','1','1','','2','0','0','0','0','1','1031lgid','1','0','0'),(@pk_616_9588,@dbtid_15,'namekey','0','0','14','0','1','','3','0','0','0','100','0','namekey1030','1','0','0'),(@pk_616_5468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.tables' LIMIT 1),'dbtid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','549dbtid','1','0','0'),(@pk_616_5532,@dbtid_4,'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_5533,@dbtid_4,'parent','0','0','2','1','1','0','3','1',@rolid_0,'0','0','1','566parent','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_6060,@dbtid_8,'rolid','0','0','2','1','1','0','7','1',@rolid_0,'0','0','1','621rolid','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');
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_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_1700,@dbtid_1,'premium','0','1','1','1','1','0','9','1',@rolid_0,'0','0','1','199premium','1','0','0'),(@pk_616_2653,@dbtid_1,'name','0','1','14','0','1','','3','1',@rolid_0,'0','100','1','199name','1','0','0'),(@pk_616_2656,@dbtid_1,'real','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','199real','1','0','0'),(@pk_616_3250,@dbtid_13,'schid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','460schid','1','0','0'),(@pk_616_3255,@dbtid_13,'frequency','0','0','4','1','1','0','8','1',@rolid_0,'0','10','1','460frequency','1','0','0'),(@pk_616_3257,@dbtid_13,'lastdate','0','1','4','1','1','0','7','1',@rolid_0,'0','0','0','460lastdate','1','1','0'),(@pk_616_3280,@dbtid_13,'created','0','1','4','1','1','0','3','1',@rolid_0,'0','0','1','460created','1','1','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_3477,@dbtid_2,'lwid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','509lwid','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_2,'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_3679,@dbtid_1,'rtl','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','199rtl','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_5534,@dbtid_4,'lft','0','0','2','1','1','0','4','1',@rolid_0,'0','0','1','566lft','1','0','0'),(@pk_616_5535,@dbtid_4,'rgt','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','566rgt','1','0','0'),(@pk_616_5536,@dbtid_4,'core','0','0','1','1','1','0','6','1',@rolid_0,'0','0','1','566core','1','0','0'),(@pk_616_5539,@dbtid_7,'name','0','0','14','0','1','','50','1',@rolid_0,'0','200','1','568name','1','0','0'),(@pk_616_5540,@dbtid_7,'description','0','0','16','0','1','','50','1',@rolid_0,'0','0','1','568description','1','0','0'),(@pk_616_5577,@dbtid_4,'joomla','0','0','2','1','1','0','7','1',@rolid_0,'0','0','1','566joomla','1','0','0'),(@pk_616_5621,@dbtid_4,'color','0','1','14','0','1','black','8','1',@rolid_0,'0','20','1','566color','1','0','0'),(@pk_616_5668,@dbtid_4,'type','0','0','1','1','1','1','9','1',@rolid_0,'0','0','1','566type','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_5747,@dbtid_13,'params','0','0','16','0','1','','9','1',@rolid_0,'0','0','1','460params','1','0','0'),(@pk_616_5758,@dbtid_13,'cron','0','0','14','0','1','','2','1',@rolid_0,'0','50','1','460cron','1','0','0'),(@pk_616_6057,@dbtid_8,'path','0','0','1','1','1','0','4','1',@rolid_0,'0','0','1','621path','1','0','0'),(@pk_616_6059,@dbtid_8,'folder','0','0','14','0','1','','6','1',@rolid_0,'0','50','1','621folder','1','0','0'),(@pk_616_6062,@dbtid_8,'publish','0','0','1','0','1','0','9','1',@rolid_0,'0','0','1','621publish','1','0','0'),(@pk_616_6063,@dbtid_8,'created','0','1','4','1','1','0','23','1',@rolid_0,'0','0','0','621created','1','1','0'),(@pk_616_6064,@dbtid_8,'extended','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','621extended','1','0','0'),(@pk_616_6065,@dbtid_8,'checkval','0','0','1','1','1','0','11','1',@rolid_0,'0','0','1','621checkval','1','0','0'),(@pk_616_6066,@dbtid_8,'params','0','0','16','0','1','','12','1',@rolid_0,'0','0','1','621params','1','0','0'),(@pk_616_6070,@dbtid_13,'ptype','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','460ptype','1','0','0'),(@pk_616_6077,@dbtid_8,'alias','0','0','14','0','1','','13','1',@rolid_0,'0','50','1','621alias','1','0','0'),(@pk_616_6081,@dbtid_1,'locale','0','1','14','0','1','','12','1',@rolid_0,'0','255','1','199locale','1','0','0'),(@pk_616_6124,@dbtid_4,'depth','0','0','2','1','1','0','10','1',@rolid_0,'0','0','1','566depth','1','0','0'),(@pk_616_6162,@dbtid_1,'localeconv','0','1','16','0','1','','11','1',@rolid_0,'0','0','1','199localeconv','1','0','0'),(@pk_616_6163,@dbtid_8,'ordering','0','0','2','1','1','0','21','1',@rolid_0,'0','0','0','621ordering','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_6221,@dbtid_8,'suffix','0','0','14','0','1','','3','0','0','0','50','0','suffix621','1','0','0'),(@pk_616_6380,@dbtid_9,'enabled','0','0','1','1','1','0','3','0','0','0','0','0','enable657','1','0','0'),(@pk_616_6444,@dbtid_10,'author','0','1','14','0','1','','2','0','0','0','100','1','author662','1','0','0'),(@pk_616_6445,@dbtid_10,'documentation','0','1','14','0','1','','3','0','0','0','255','1','documentation662','1','0','0'),(@pk_616_6446,@dbtid_10,'images','0','1','14','0','1','','4','0','0','0','255','1','images662','1','0','0'),(@pk_616_6447,@dbtid_10,'flash','0','1','14','0','1','','5','0','0','0','255','1','flash662','1','0','0'),(@pk_616_6448,@dbtid_10,'support','0','1','14','0','1','','6','0','0','0','255','1','support662','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_6449,@dbtid_10,'forum','0','1','14','0','1','','7','0','0','0','255','1','forum662','1','0','0'),(@pk_616_6452,@dbtid_10,'homeurl','0','1','14','0','1','','8','0','0','0','200','1','homeurl662','1','0','0'),(@pk_616_6453,@dbtid_10,'feedback','0','1','14','0','1','','9','0','0','0','255','1','joomlafeedback662','1','0','0'),(@pk_616_6458,@dbtid_10,'userversion','0','1','14','0','1','','10','0','0','0','100','1','userversion662','1','0','0'),(@pk_616_6459,@dbtid_10,'userlversion','0','1','14','0','1','','11','0','0','0','100','1','userlversion662','1','0','0'),(@pk_616_6461,@dbtid_9,'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_9,'token','0','1','14','0','1','','5','0','0','0','254','0','token657','1','0','0'),(@pk_616_6519,@dbtid_9,'ltype','0','1','1','1','1','1','6','0','0','0','0','0','ltype657','1','0','0'),(@pk_616_6520,@dbtid_9,'expire','0','1','4','1','1','0','8','0','0','0','0','1','expire657','1','0','0'),(@pk_616_6521,@dbtid_9,'maintenance','0','1','4','1','1','0','9','0','0','0','0','1','maintenance657','1','0','0'),(@pk_616_6552,@dbtid_10,'beta','0','1','2','0','1','0','12','0','0','0','5','1','beta662','1','0','0'),(@pk_616_6671,@dbtid_9,'flag','0','1','1','1','1','0','10','0','0','0','0','1','flag657','1','0','0'),(@pk_616_6689,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='components' LIMIT 1),'id','0','1','4','1','1','0','1','0','0','0','0','1','id583','1','0','0'),(@pk_616_6697,@dbtid_13,'core','0','1','25','0','1','0','13','0','0','0','0','1','core460','1','0','0'),(@pk_616_6699,@dbtid_13,'report','0','1','16','0','1','','14','0','0','0','0','0','report460','1','0','0'),(@pk_616_6782,@dbtid_11,'text','0','1','16','0','1','','2','0','0','0','0','1','text713','1','0','0'),(@pk_616_6783,@dbtid_11,'auto','0','1','1','1','1','1','3','0','0','0','0','0','auto713','1','0','0'),(@pk_616_6802,@dbtid_7,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto568','1','0','0'),(@pk_616_6803,@dbtid_7,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid568','1','0','0'),(@pk_616_7782,@dbtid_12,'title','0','1','14','0','1','','2','0','0','0','255','1','title595','1','0','0'),(@pk_616_7783,@dbtid_12,'name','0','1','14','0','1','','3','0','0','0','255','1','name595','1','0','0'),(@pk_616_7784,@dbtid_12,'image','0','1','16','0','1','','4','0','0','0','0','1','image595','1','0','0'),(@pk_616_7785,@dbtid_12,'scope','0','1','14','0','1','','5','0','0','0','50','1','scope595','1','0','0'),(@pk_616_7786,@dbtid_12,'image_position','0','1','14','0','1','','6','0','0','0','30','1','image_position595','1','0','0'),(@pk_616_7787,@dbtid_12,'description','0','1','16','0','1','','7','0','0','0','0','1','description595','1','0','0'),(@pk_616_7788,@dbtid_12,'published','0','1','1','0','1','0','8','0','0','0','11','1','published595','1','0','0'),(@pk_616_7789,@dbtid_12,'checked_out','0','1','4','1','1','0','9','0','0','0','11','1','check_out595','1','0','0'),(@pk_616_7790,@dbtid_12,'checked_out_time','0','1','10','0','1','','10','0','0','0','0','1','checked_out_time595','1','1','0'),(@pk_616_7791,@dbtid_12,'ordering','0','1','4','1','1','0','11','0','0','0','11','1','ordering595','1','0','0'),(@pk_616_7792,@dbtid_12,'access','0','1','1','1','1','0','12','0','0','0','3','1','access595','1','0','0'),(@pk_616_7793,@dbtid_12,'count','0','1','4','0','1','0','13','0','0','0','11','1','count595','1','0','0'),(@pk_616_7794,@dbtid_12,'params','0','1','16','0','1','','14','0','0','0','0','1','params595','1','0','0'),(@pk_616_7795,@dbtid_12,'state','0','1','1','0','1','0','15','0','0','0','3','1','state595','1','0','0'),(@pk_616_7851,@dbtid_8,'extstid','0','1','1','1','1','0','20','0','0','0','0','0','extstid621','1','0','0'),(@pk_616_8433,@dbtid_13,'maxtime','0','1','4','1','1','5','15','0','0','0','0','1','maxtime460','1','0','0'),(@pk_616_8434,@dbtid_13,'maxprocess','0','1','2','1','1','1','16','0','0','0','0','1','maxprocess460','1','0','0'),(@pk_616_8447,@dbtid_4,'j16','0','0','4','1','1','1','11','0','0','0','0','1','j16566','1','0','0'),(@pk_616_8759,@dbtid_13,'viewname','0','1','14','0','1','','17','0','0','0','50','1','viewname460','1','0','0'),(@pk_616_9083,@dbtid_8,'fields','0','1','1','1','1','0','15','0','0','0','0','1','fields621','1','0','0'),(@pk_616_9291,@dbtid_8,'checkout','0','1','1','1','1','0','19','0','0','0','0','0','checkout621','1','0','0'),(@pk_616_9292,@dbtid_8,'trash','0','1','1','1','1','0','16','0','0','0','0','1','trash621','1','0','0'),(@pk_616_9293,@dbtid_8,'audit','0','1','1','1','1','0','22','0','0','0','0','0','audit621','1','0','0'),(@pk_616_9295,@dbtid_8,'modified','0','1','4','1','1','0','24','0','0','0','0','0','modified621','1','1','0'),(@pk_616_9346,@dbtid_8,'totalcustom','0','1','2','1','1','0','25','0','0','0','0','0','totalcustom621','1','0','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_9506,@dbtid_8,'reload','0','1','1','1','1','1','26','0','0','0','0','0','reload621','1','0','0'),(@pk_616_9584,@dbtid_16,'name','0','0','14','0','1','','3','0','0','0','255','1','name1031','1','0','0'),(@pk_616_9585,@dbtid_16,'description','0','0','16','0','1','','4','0','0','0','0','1','description1031','1','0','0'),(@pk_616_9586,@dbtid_16,'auto','0','0','1','0','1','2','5','0','0','0','0','0','auto1031','1','0','0'),(@pk_616_9587,@dbtid_16,'fromlgid','0','0','1','1','0','0','6','0','0','0','0','0','fromlgid1031','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_9589,@dbtid_15,'alias','0','0','14','0','1','','2','0','0','0','150','0','alias1030','1','0','0'),(@pk_616_9590,@dbtid_15,'type','0','0','1','1','1','0','5','0','0','0','0','0','type1030','1','0','0'),(@pk_616_9591,@dbtid_15,'rolid','0','0','2','1','1','1','10','0','0','0','0','0','rolid1030','1','0','0'),(@pk_616_9592,@dbtid_15,'uid','0','0','4','1','1','0','6','0','0','0','0','0','uid1030','1','0','0'),(@pk_616_9593,@dbtid_15,'core','0','0','25','0','1','0','9','0','0','0','0','0','core1030','1','0','0'),(@pk_616_9594,@dbtid_15,'publish','0','0','1','0','1','0','8','0','0','0','0','0','publish1030','1','0','0'),(@pk_616_9595,@dbtid_15,'created','0','1','4','1','1','0','7','0','0','0','0','0','created1030','1','1','0'),(@pk_616_9596,@dbtid_15,'modified','0','1','4','1','1','0','4','0','0','0','0','0','modified1030','1','1','0'),(@pk_616_9661,@dbtid_1,'core','0','1','25','0','1','0','13','0','0','0','0','1','core199','1','0','0'),(@pk_616_9667,@dbtid_8,'core','0','1','25','0','1','0','17','0','0','0','0','1','core621','1','0','0'),(@pk_616_9678,@dbtid_15,'groupid','0','1','1','1','1','0','12','0','0','0','0','0','groupid1030','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_9,'subtype','0','1','1','1','1','0','7','0','0','0','0','1','subtype657','1','0','0'),(@pk_616_10103,@dbtid_10,'keyword','0','1','14','0','1','','13','0','0','0','200','1','keyword662','1','0','0'),(@pk_616_10178,@dbtid_8,'faicon','0','1','14','0','1','','18','0','0','0','50','1','icon621','1','0','0'),(@pk_616_10666,@dbtid_1,'automatic','0','1','1','1','1','0','14','0','0','0','0','1','automatic199','1','0','0'),(@pk_616_10812,@dbtid_8,'pnamekey','0','1','14','0','1','','27','0','0','0','50','1','pnamekey621','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_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_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_177 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='install.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='install',`wid`=@pk_5_177,`params`='',`status`='1',`type`='150',`name`='Install',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='install.node',`version`='5074',`lversion`='5074',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='install.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','install',@pk_5_177,'','1','150','Install','node','0','1','1','install.node','5074','5074','1','','1','1','0');

SET @pk_621_199 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1 );
SET @pk_621_469 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.plugins' LIMIT 1 );
SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_568 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='roletrans' LIMIT 1 );
SET @pk_621_595 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.modules' LIMIT 1 );
SET @pk_621_698 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.components' LIMIT 1 );
SET @pk_621_747 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.model' LIMIT 1 );
SET @pk_621_997 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.extensions' LIMIT 1 );
SET @pk_621_998 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.menu' LIMIT 1 );
SET @pk_621_1018 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla16.aclgroupuser' LIMIT 1 );
SET @pk_621_1081 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.apps' LIMIT 1 );
SET @pk_621_1082 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appslevel' LIMIT 1 );
SET @pk_621_1083 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsinfo' LIMIT 1 );
SET @pk_621_1084 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsdependency' LIMIT 1 );
SET @pk_621_1216 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsuserinfos' LIMIT 1 );
SET @pk_621_1232 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.translationreference' LIMIT 1 );
SET @pk_621_1233 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.translation_en' LIMIT 1 );
SET @pk_621_1412 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.scheduler' LIMIT 1 );
SET @pk_621_1420 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.widgetype' LIMIT 1 );
SET @pk_621_1421 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.widgetypetrans' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_199,`dbtid`=@dbtid_1,`path`='0',`namekey`='library.languages',`folder`='library.languages',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-language',`pnamekey`='' WHERE  `namekey`='library.languages';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_199,@dbtid_1,'0','library.languages','library.languages',@rolid_0,'0','1','0','0','','','joobi','0','0','1','fa-language','');
UPDATE `#__model_node`  SET `sid`=@pk_621_469,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='plugins' LIMIT 1),`path`='0',`namekey`='joomla.plugins',`folder`='plugins',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='plugins',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.plugins';
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_469,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='plugins' LIMIT 1),'0','joomla.plugins','plugins',@rolid_0,'0','1','0','0','','','plugins','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_4,`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,@dbtid_4,'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_568,`dbtid`=@dbtid_7,`path`='0',`namekey`='roletrans',`folder`='roletrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=role',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='roletrans';
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_568,@dbtid_7,'0','roletrans','roletrans',@rolid_0,'0','1','0','0','\nmainmodel=role','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_595,`dbtid`=@dbtid_12,`path`='0',`namekey`='joomla.modules',`folder`='modules',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='modules',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.modules';
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_595,@dbtid_12,'0','joomla.modules','modules',@rolid_0,'0','1','0','0','','','modules','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_698,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='components' LIMIT 1),`path`='0',`namekey`='joomla.components',`folder`='joomla',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.components';
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_698,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='components' LIMIT 1),'0','joomla.components','joomla',@rolid_0,'0','1','0','0','autofld=1','','joomla','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_747,`dbtid`=@dbtid_8,`path`='0',`namekey`='library.model',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-table',`pnamekey`='' WHERE  `namekey`='library.model';
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_747,@dbtid_8,'0','library.model','library',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','fa-table','');
UPDATE `#__model_node`  SET `sid`=@pk_621_997,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extensions' LIMIT 1),`path`='0',`namekey`='joomla.extensions',`folder`='joomla.extensions',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.extensions';
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_997,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extensions' LIMIT 1),'0','joomla.extensions','joomla.extensions',@rolid_0,'0','1','0','0','autofld=1','','joomla','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_998,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='menu' LIMIT 1),`path`='1',`namekey`='joomla.menu',`folder`='joomla.menu',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nparentmap=parent_id\nskipdepth=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-link',`pnamekey`='' WHERE  `namekey`='joomla.menu';
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_998,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='menu' LIMIT 1),'1','joomla.menu','joomla.menu',@rolid_0,'0','1','0','0','autofld=1\nparentmap=parent_id\nskipdepth=1','','joomla','0','0','1','fa-link','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1018,`dbtid`=@dbtid_14,`path`='0',`namekey`='joomla16.aclgroupuser',`folder`='joomla16.aclgroupuser',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joomla16',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla16.aclgroupuser';
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_1018,@dbtid_14,'0','joomla16.aclgroupuser','joomla16.aclgroupuser',@rolid_0,'0','1','0','0','autofld=1','','joomla16','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1081,`dbtid`=@dbtid_3,`path`='0',`namekey`='install.apps',`folder`='install.apps',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='install.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_1081,@dbtid_3,'0','install.apps','install.apps',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1082,`dbtid`=@dbtid_2,`path`='0',`namekey`='install.appslevel',`folder`='install.appslevel',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.appslevel';
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_1082,@dbtid_2,'0','install.appslevel','install.appslevel',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1083,`dbtid`=@dbtid_10,`path`='0',`namekey`='install.appsinfo',`folder`='install.appsinfo',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=install.apps\nautofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.appsinfo';
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_1083,@dbtid_10,'0','install.appsinfo','install.appsinfo',@rolid_0,'0','1','0','0','mainmodel=install.apps\nautofld=1','','install','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1084,`dbtid`=@dbtid_5,`path`='0',`namekey`='install.appsdependency',`folder`='install.appsdependency',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.appsdependency';
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_1084,@dbtid_5,'0','install.appsdependency','install.appsdependency',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1216,`dbtid`=@dbtid_9,`path`='0',`namekey`='install.appsuserinfos',`folder`='install.appsuserinfos',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.appsuserinfos';
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_1216,@dbtid_9,'0','install.appsuserinfos','install.appsuserinfos',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1232,`dbtid`=@dbtid_6,`path`='0',`namekey`='library.translationreference',`folder`='library.translationreference',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='library.translationreference';
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_1232,@dbtid_6,'0','library.translationreference','library.translationreference',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1233,`dbtid`=@dbtid_11,`path`='0',`namekey`='library.translation_en',`folder`='library.translation_en',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='library.translation_en';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1233,@dbtid_11,'0','library.translation_en','library.translation_en',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1412,`dbtid`=@dbtid_13,`path`='0',`namekey`='install.scheduler',`folder`='install.scheduler',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-calendar',`pnamekey`='' WHERE  `namekey`='install.scheduler';
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_1412,@dbtid_13,'0','install.scheduler','install.scheduler',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','fa-calendar','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1420,`dbtid`=@dbtid_15,`path`='0',`namekey`='install.widgetype',`folder`='install.widgetype',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.widgetype';
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_1420,@dbtid_15,'0','install.widgetype','install.widgetype',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1421,`dbtid`=@dbtid_16,`path`='0',`namekey`='install.widgetypetrans',`folder`='install.widgetypetrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='install',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='install.widgetypetrans';
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_1421,@dbtid_16,'0','install.widgetypetrans','install.widgetypetrans',@rolid_0,'0','1','0','0','autofld=1','','install','0','0','1','','');

SET @wid_17 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='install.node' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='install_requirement_show' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='install_requirement_show_pane' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('install_requirement_show_library_node_test') LIMIT 1;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Yes','1','1206732372QTKI');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('No','1','1206732372QTKJ'),('Model','1','1206732388KEHV'),('Translation','1','1206732392OZUR'),('Type','1','1206732392OZVD'),('Language','1','1206732405TIXE'),('Home','1','1206732431CQBG'),('Welcome','1','1206961889EEYJ'),('Scheduler','1','1206961893RSRQ'),('Unlimited','1','1206961954EAMU'),('Role','1','1209142268NMKA'),('Installation stopped.','1','1211280055AYDS'),('Installation failed!','1','1213020853MLHP'),('List of packages retrieved successfully!','1','1213020853MLHV'),('Select at least one application.','1','1213107629LYER'),('Application Installation Complete!','1','1213107630MBVS'),('The license server is not available.','1','1213794916KBVX'),('Please contact support $EMAIL if you need a license for your application.','1','1213794916KBVY'),('The package $PACKAGE was extracted.','1','1215002067FIWP'),('The license of the extension $EXTENSION was validated.','1','1221227936IUXD'),('Click here to go back to the application listing','1','1227579827CIXW'),('The $LANGUAGE translations were retrieved for the application $APPLICATION','1','1227579828FTWS'),('$LANGUAGE translations not available for the application $APPLICATION','1','1227579828FTWT'),('All translations retrieved for the application $APPLICATION','1','1227579828FTWU'),('Component','1','1235461972DIWB'),('Could not retrieve the list of packages.','1','1236536983NQDJ'),('Unwritable','1','1242282416HAQS'),('Writable','1','1242282417SQLA'),('PHP Version','1','1242282433QMCF'),('Recommended','1','1249442156QUCO'),('No language file found on the servers for the applications installed','1','1260151166CSBV'),('Click here to go back to the languages listing','1','1260151166CSBW'),('The name of the application is too long:$NAME','1','1298294123FNDM'),('Could not write the file ','1','1298294193EGSU'),('Memory Limit','1','1298350274FGVE'),('Joomla Plugins','1','1298350305KUTU'),('Joomla Modules','1','1298350305KUTV'),('Joomla 1.6 Extensions','1','1298350306NYBQ'),('Joomla 1.6 Menu','1','1298350306NYBR'),('The theme could not be uploaded because the type was not recognized in the XML file.','1','1298350310EWVG'),('The theme already exist, it has simply been updated!','1','1298350310EWVH'),('The theme could not be updated!','1','1298350310EWVI'),('ACL User Groups Map','1','1298618260QLYK'),('Sample','1','1302090354NZFX'),('Retrieving List of Packages!','1','1303104133RCSA'),('','1','1304525968YBL'),('Continuing with install/update','1','1307005747JWMB'),('Install Applications','1','1307940274ANGO'),('Install Applications Level','1','1307940274ANGP'),('Install Applications Info','1','1307940274ANGQ'),('Install Applications Dependency','1','1307940274ANGR'),('Widget installation completed!','1','1308836335LUUQ'),('SQL Version','1','1317823749MRTP'),('Apps update is disabled!','1','1338581028LZCR'),('seconds','1','1360366414NJAJ'),('Apps info','1','1377558447LBSX'),('English translation','1','1378737429DEXY'),('Translation checked','1','1389108457QWKA'),('API key','1','1389275714NKEJ'),('Please contact the support for more information.','1','1389701766DFGL'),('The API key is not valid any more.','1','1389701766DFGM'),('Demo period expired. New downloads are not available any more.','1','1389965492NTIZ'),('The API key expired!','1','1389965492NTJA'),('The API key is disabled!','1','1389965492NTJB'),('The API key is unknown!','1','1389965492NTJC'),('Unknown error!','1','1389965492NTJD'),('Unknown token!','1','1389965492NTJE'),('Problem of package transfer.','1','1389988802RQBQ'),('You are trying to download a package which no longer exists in the server','1','1389988802RQBR'),('All translations retrieved!','1','1395716602EKEW'),('Package \"$PACKAGE_NAME\" retrieved.','1','1395716605OVVZ'),('All packages extracted! Moving all files...','1','1397671837IMCS'),('Packages download completed! Starting extraction...','1','1397671839JQGR'),('Pane','1','1416948599JVQT'),('Creating tables...','1','1427652812DTKK'),('There is no valid token to do this update!','1','1427652813TJJQ'),('Downloading packages...','1','1427652813TJJR'),('The package $PACKAGE_NAME was successfully extracted.','1','1427652813TJJS'),('The package $PACKAGE_NAME could not be extracted.','1','1427652813TJJT'),('The languages for $PACKAGE_NAME were successfully installed.','1','1427652814RAOH'),('The languages for $PACKAGE_NAME failed to download.','1','1427652814RAOI'),('The custom install of the extension $PACKAGE_NAME was successfully run.','1','1427652814RAOJ'),('The custom install of the extension $PACKAGE_NAME failed to run.','1','1427652814RAOK'),('The tables for $PACKAGE_NAME were successfully created.','1','1427652814RAOL'),('Package \"$PACKAGE_NAME\" already downloaded.','1','1427652814RAON'),('Problem with token!','1','1427652814RAOO'),('The menu for extension $PACKAGE_NAME was successfully created.','1','1427739324NDEY'),('The menu for extension $PACKAGE_NAME failed to create.','1','1427739324NDEZ'),('No packages available from the server!','1','1427986835NTMI'),('Package \"$PACKAGE_NAME\" could not be retrieved.','1','1428371836FLXB'),('Required for picture resize','1','1432423407JSWF'),('GD Library installed','1','1432423407JSWG'),('Required for update of apps','1','1432423407JSWH'),('enabled','1','1432423407JSWI'),('library is enabled','1','1432423407JSWJ'),('is enabled','1','1432423407JSWK'),('extension is enabled','1','1432423407JSWL'),('Max excecution time','1','1432423407JSWM'),('Post Size','1','1432423407JSWN'),('Max input time','1','1432423407JSWO'),('Max file upload','1','1432423407JSWP'),('FTP Layer disabled','1','1432423407JSWQ');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Server Library','1','1432423407JSWR'),('PHP settings','1','1432423407JSWS'),('SQL settings','1','1432423407JSWT'),('Folder Writable','1','1432423407JSWU'),('Install Requirements','1','1432423412LOHZ'),('extension is installed','1','1433250455EAMT');
SET @ctid_19 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_languages_main_publish_availadmin_availsite' LIMIT 1);
SET @dbcid_20 = ( 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_20),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_languages' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_languages_code' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199code' 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)),(@ctid_19,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199main' LIMIT 1)),(@ctid_19,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460nextdate' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460priority' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460publish' 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_translation_reference_wid_imac' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_translation_reference_load' LIMIT 1),'1','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511load' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='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`='PK_roletrans_rolid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_roletrans_rolid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_role_node_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566namekey' LIMIT 1)),(@ctid_19,'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199availadmin' LIMIT 1)),(@ctid_19,'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199availsite' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_node_sid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_dbtic' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_model_node_namekey' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621prefix' 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`='UK_namekey_scheduler_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey460' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_translation_reference_wid_imac' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_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_translation_en|main_translation' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_modules|main_joomla15' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id595' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_extensions|main_joomla15' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='915extension_id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_menu|main_joomla15' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='916id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_user_usergroup_map|main_joomla16' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='922user_id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_user_usergroup_map|main_joomla16' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='922group_id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='ix_translation_en_nbchars' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='nbchars713' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_widgets_type_trans' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_widgets_type_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1030' LIMIT 1));
SET @ref_feid_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' 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_588 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'509wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_604 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'511wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_605 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'imac511\' 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_10359 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'568rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10360 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'568lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10393 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'5rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10527 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dataset.tables\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'621dbtid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10528 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'621rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10566 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'role.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_4 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'566parent\' 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_10608 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 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_10 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'662wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10907 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'modules\' LIMIT 1' AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'id595\' LIMIT 1' LIMIT 1 );
SET @pk_77_11216 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_16 AND `ref_dbtid`=@dbtid_15 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1031wgtypeid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11217 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_16 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1031lgid\' 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_dependency_wid',@pk_77_587,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352wid' LIMIT 1),@dbcid_20,'3','3','wid',@dbtid_3,@dbtid_5,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','0','FK_model_level_wid',@pk_77_588,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='509wid' LIMIT 1),@dbcid_20,'3','3','wid',@dbtid_3,@dbtid_2,'99'),('wid','1','FK_translation_reference_wid',@pk_77_604,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='511wid' LIMIT 1),@dbcid_20,'3','3','wid',@dbtid_3,@dbtid_6,'1'),('imac','1','FK_translation_reference_imac',@pk_77_605,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='imac511' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='713imac' LIMIT 1),'1','3','imac',@dbtid_11,@dbtid_6,'2'),('ref_wid','1','FK_extension_dependency_ref_wid',@pk_77_1000,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='352ref_wid' LIMIT 1),@dbcid_20,'1','3','wid',@dbtid_3,@dbtid_5,'2'),('rolid','1','FK_role_trans_rolid',@pk_77_10359,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568rolid' LIMIT 1),@ref_feid_21,'3','3','rolid',@dbtid_4,@dbtid_7,'99'),('lgid','1','FK_role_trans_lgid',@pk_77_10360,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',@dbtid_1,@dbtid_7,'99'),('rolid','1','FK_extension_rolid',@pk_77_10393,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5rolid' LIMIT 1),@ref_feid_21,'1','1','',@dbtid_4,@dbtid_3,'99'),('dbtid','1','FK_model_dbtid',@pk_77_10527,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='549dbtid' LIMIT 1),'1','3','dbtid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.tables' LIMIT 1),@dbtid_8,'1'),('rolid','1','FK_model_rolid',@pk_77_10528,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621rolid' LIMIT 1),@ref_feid_21,'1','1','',@dbtid_4,@dbtid_8,'2'),('parent','1','FK_parent_child_rolid',@pk_77_10566,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566parent' LIMIT 1),@ref_feid_21,'1','1','rolid',@dbtid_4,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),'99'),('parent','1','FK_Parent5_parentwid',@pk_77_10572,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5parent' LIMIT 1),@dbcid_20,'1','1','wid',@dbtid_3,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'99'),('wid','1','FK_extensionEnabled_wid',@pk_77_10608,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid657' LIMIT 1),@dbcid_20,'3','3','wid',@dbtid_3,@dbtid_9,'1'),('wid','1','FK_extension_info_wid',@pk_77_10622,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='662wid' LIMIT 1),@dbcid_20,'3','3','wid',@dbtid_3,@dbtid_10,'1'),('id','1','595_id_595',@pk_77_10907,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id595' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id595' LIMIT 1),'1','1','id',@dbtid_12,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1),'99'),('wgtypeid','1','FK_widgets_type_trans_wgtypeid',@pk_77_11216,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031wgtypeid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1030wgtypeid' LIMIT 1),'3','3','wgtypeid',@dbtid_15,@dbtid_16,'1'),('lgid','1','FK_widgets_type_trans_lgid',@pk_77_11217,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1031lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'3','3','lgid',@dbtid_1,@dbtid_16,'2');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_17,'1','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_17,'1','1206732372QTKJ'),(@wid_17,'1','1206961889EEYJ'),(@wid_17,'1','1206961954EAMU'),(@wid_17,'1','1211280055AYDS'),(@wid_17,'1','1213020853MLHP'),(@wid_17,'1','1213020853MLHV'),(@wid_17,'1','1213107629LYER'),(@wid_17,'1','1213107630MBVS'),(@wid_17,'0','1213794916KBVX'),(@wid_17,'0','1213794916KBVY'),(@wid_17,'1','1215002067FIWP'),(@wid_17,'1','1221227936IUXD'),(@wid_17,'1','1227579827CIXW'),(@wid_17,'1','1227579828FTWS'),(@wid_17,'1','1227579828FTWT'),(@wid_17,'1','1227579828FTWU'),(@wid_17,'1','1236536983NQDJ'),(@wid_17,'1','1242282416HAQS'),(@wid_17,'1','1242282417SQLA'),(@wid_17,'1','1242282433QMCF'),(@wid_17,'1','1249442156QUCO'),(@wid_17,'1','1260151166CSBV'),(@wid_17,'1','1260151166CSBW'),(@wid_17,'0','1298294123FNDM'),(@wid_17,'1','1298294193EGSU'),(@wid_17,'1','1298350274FGVE'),(@wid_17,'0','1298350310EWVG'),(@wid_17,'0','1298350310EWVH'),(@wid_17,'0','1298350310EWVI'),(@wid_17,'1','1303104133RCSA'),(@wid_17,'1','1307005747JWMB'),(@wid_17,'1','1308836335LUUQ'),(@wid_17,'1','1317823749MRTP'),(@wid_17,'0','1338581028LZCR'),(@wid_17,'1','1360366414NJAJ'),(@wid_17,'1','1389108457QWKA'),(@wid_17,'1','1389275714NKEJ'),(@wid_17,'1','1389701766DFGL'),(@wid_17,'1','1389701766DFGM'),(@wid_17,'1','1389965492NTIZ'),(@wid_17,'1','1389965492NTJA'),(@wid_17,'1','1389965492NTJB'),(@wid_17,'1','1389965492NTJC'),(@wid_17,'1','1389965492NTJD'),(@wid_17,'1','1389965492NTJE'),(@wid_17,'1','1389988802RQBQ'),(@wid_17,'1','1389988802RQBR'),(@wid_17,'1','1395716602EKEW'),(@wid_17,'1','1395716605OVVZ'),(@wid_17,'1','1397671837IMCS'),(@wid_17,'1','1397671839JQGR'),(@wid_17,'1','1427652812DTKK'),(@wid_17,'1','1427652813TJJQ'),(@wid_17,'1','1427652813TJJR'),(@wid_17,'1','1427652813TJJS'),(@wid_17,'1','1427652813TJJT'),(@wid_17,'1','1427652814RAOH'),(@wid_17,'1','1427652814RAOI'),(@wid_17,'1','1427652814RAOJ'),(@wid_17,'1','1427652814RAOK'),(@wid_17,'1','1427652814RAOL'),(@wid_17,'1','1427652814RAON'),(@wid_17,'1','1427652814RAOO'),(@wid_17,'1','1427739324NDEY'),(@wid_17,'1','1427739324NDEZ'),(@wid_17,'1','1427986835NTMI'),(@wid_17,'1','1428371836FLXB'),(@wid_17,'1','1432423407JSWF'),(@wid_17,'1','1432423407JSWG'),(@wid_17,'1','1432423407JSWH'),(@wid_17,'1','1432423407JSWI'),(@wid_17,'1','1432423407JSWJ'),(@wid_17,'1','1432423407JSWK'),(@wid_17,'1','1432423407JSWL'),(@wid_17,'1','1432423407JSWM'),(@wid_17,'1','1432423407JSWN'),(@wid_17,'1','1432423407JSWO'),(@wid_17,'1','1432423407JSWP'),(@wid_17,'1','1432423407JSWQ'),(@wid_17,'1','1432423407JSWR'),(@wid_17,'1','1432423407JSWS'),(@wid_17,'1','1432423407JSWT'),(@wid_17,'1','1432423407JSWU'),(@wid_17,'1','1433250455EAMT');
SET @dbcid_22 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_17,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_17,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='568name' LIMIT 1)),(@wid_17,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description1031' LIMIT 1)),(@wid_17,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name1031' LIMIT 1)),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.languages' LIMIT 1),'1206732405TIXE',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.plugins' LIMIT 1),'1298350305KUTU',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1),'1209142268NMKA',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='roletrans' LIMIT 1),'1304525968YBL',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.modules' LIMIT 1),'1298350305KUTV',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.components' LIMIT 1),'1235461972DIWB',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.model' LIMIT 1),'1206732388KEHV',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.extensions' LIMIT 1),'1298350306NYBQ',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.menu' LIMIT 1),'1298350306NYBR',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla16.aclgroupuser' LIMIT 1),'1298618260QLYK',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.apps' LIMIT 1),'1307940274ANGO',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appslevel' LIMIT 1),'1307940274ANGP',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsinfo' LIMIT 1),'1307940274ANGQ',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsdependency' LIMIT 1),'1307940274ANGR',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.appsuserinfos' LIMIT 1),'1377558447LBSX',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.translationreference' LIMIT 1),'1206732392OZUR',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.translation_en' LIMIT 1),'1378737429DEXY',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.scheduler' LIMIT 1),'1206961893RSRQ',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.widgetype' LIMIT 1),'1206732392OZVD',@dbcid_22),(@wid_17,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='install.widgetypetrans' LIMIT 1),'1206732392OZVD',@dbcid_22);