/*Export of the extension api.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1298350334ECWR','1304525968YBL','1298350305KUTU','1298350305KUTV','1235461972DIWB','1298350408NRRZ','1206732411EGQO','','1206732392OZUQ','1206732400OWZO','1206732412DAGC','1206961889EEYJ','1206961998KTYJ','1208359284QWNS','1211280059QYRJ','1221228435BYUA','1228820287MBVC','1341249340REAS','1352226844OYVM','1377725235IENV','1377734767DOBZ','1377910927MTVO','1380567636DDVU','1416248538ILNE','1416248908LXMN','1416248908LXMO','1416248908LXMQ','1416248908LXMR','1416248908LXMS','1418240185PFXV','1418240185PFXW','1418698684IOVP','1418698689KRYX','1420853890NVDH','1420853890NVDI','1420853891WXL','1424213023BXKK','1426644982FUIK','1436531336NQEF' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('core.acl.groups.aro.map','categories','modules','usergroups') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('core.acl.groups.aro.map','categories','modules','usergroups','sections','users','components','model.trans') AND `#__dataset_columns`.`namekey` NOT IN ('258group_id','258aro_id','251id','251name','251username','251email','251password','251usertype','251block','251sendemail','251gid','251registerdate','251lastvisitdate','251activation','251params','618sid','618lgid','618name','695id','696id','id583','auto618','fromlgid618','title695','created695','state695','name695','title696','name696','section696','ordering696','published696','id595','title595','name595','image595','scope595','image_position595','description595','published595','check_out595','checked_out_time595','ordering595','access595','count595','params595','state595','921id') 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 ('section696','id595') AND `#__dataset_foreign`.`namekey` NOT IN ('595_id_595','section') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('api.node') ;
SET @rolid_0 = (1);
SET @pk_549_258 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='core.acl.groups.aro.map' LIMIT 1 );
SET @pk_549_595 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1 );
SET @pk_549_696 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='categories' LIMIT 1 );
SET @pk_549_921 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='usergroups' LIMIT 1 );
SET @pk_549_695 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sections' LIMIT 1 );
SET @pk_549_251 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='users' 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 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('core_acl_groups_aro_map','core.acl.groups.aro.map',@pk_549_258,'','1.0.0',@rolid_0,'0','1','aro_id','groups_aro_map','core_acl','250','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 ('modules','modules',@pk_549_595,'','1.0.0',@rolid_0,'0','1','id','','modules','250','0','0','1','7'),('categories','categories',@pk_549_696,'','',@rolid_0,'0','40','id','','categories','250','2','0','0','7'),('usergroups','usergroups',@pk_549_921,'','',@rolid_0,'0','40','id','','usergroups','250','2','0','1','7'),('sections','sections',@pk_549_695,'','',@rolid_0,'0','1','id','','sections','250','2','0','1','7'),('users','users',@pk_549_251,'','1.0.0',@rolid_0,'0','1','id','','users','250','2','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');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='core.acl.groups.aro.map' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='categories' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1);
SET @pk_454_39 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UQ_core_acl_groups_aro_map_group_id_aro_id' LIMIT 1 );
SET @pk_454_65617 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_categories' LIMIT 1 );
SET @pk_454_65748 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_modules|main_joomla15' LIMIT 1 );
SET @pk_454_65874 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_user_usergroups|main_joomla16' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_39,'1','UQ_core_acl_groups_aro_map_group_id_aro_id',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65617,'3','PK_categories',@dbtid_2),(@pk_454_65748,'3','PK_modules|main_joomla15',@dbtid_3),(@pk_454_65874,'3','PK_user_usergroups|main_joomla16',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='usergroups' LIMIT 1));
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='users' LIMIT 1);
SET @pk_616_1663 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='258group_id' LIMIT 1 );
SET @pk_616_6676 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' LIMIT 1 );
SET @pk_616_7781 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id595' LIMIT 1 );
SET @pk_616_8448 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='921id' LIMIT 1 );
SET @pk_616_6675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='695id' LIMIT 1 );
SET @pk_616_7777 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='section696' LIMIT 1 );
SET @pk_616_1664 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='258aro_id' LIMIT 1 );
SET @pk_616_1935 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251id' LIMIT 1 );
SET @pk_616_1936 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251name' LIMIT 1 );
SET @pk_616_1937 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251username' LIMIT 1 );
SET @pk_616_1938 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251email' LIMIT 1 );
SET @pk_616_1939 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251password' LIMIT 1 );
SET @pk_616_1940 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251usertype' LIMIT 1 );
SET @pk_616_1941 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251block' LIMIT 1 );
SET @pk_616_1942 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251sendemail' LIMIT 1 );
SET @pk_616_1943 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251gid' LIMIT 1 );
SET @pk_616_1944 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251registerdate' LIMIT 1 );
SET @pk_616_1945 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251lastvisitdate' LIMIT 1 );
SET @pk_616_1946 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251activation' LIMIT 1 );
SET @pk_616_1947 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='251params' LIMIT 1 );
SET @pk_616_6689 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='id583' LIMIT 1 );
SET @pk_616_7775 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title696' LIMIT 1 );
SET @pk_616_7776 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name696' LIMIT 1 );
SET @pk_616_7778 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering696' LIMIT 1 );
SET @pk_616_7779 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='published696' 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_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' 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_1663,@dbtid_1,'group_id','0','0','4','0','1','0','99','1',@rolid_0,'0','0','1','258group_id','1','0','0');

SET @pk_5_1036 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='api.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='api',`wid`=@pk_5_1036,`params`='',`status`='1',`type`='150',`name`='API',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='api.node',`version`='3448',`lversion`='3448',`pref`='0',`install`='',`core`='1',`showconfig`='0',`framework`='0' WHERE  `namekey`='api.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','api',@pk_5_1036,'','1','150','API','node','0','1','0','api.node','3448','3448','0','','1','0','0');

INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Preferences','1','1206732392OZUQ');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Author','1','1206732400OWZO'),('Category','1','1206732411EGQO'),('Title','1','1206732412DAGC'),('Welcome','1','1206961889EEYJ'),('Administrator','1','1206961998KTYJ'),('User','1','1208359284QWNS'),('Editor','1','1211280059QYRJ'),('Vendor','1','1221228435BYUA'),('Close','1','1228820287MBVC'),('Component','1','1235461972DIWB'),('Joomla Plugins','1','1298350305KUTU'),('Joomla Modules','1','1298350305KUTV'),('Joomla User','1','1298350334ECWR'),('ACL Users Groups J16','1','1298350408NRRZ'),('','1','1304525968YBL'),('Only $MAX_USERS have been added for performance challanges, please click again to Sync Users to do another $MAX_USERS.','1','1341249340REAS'),('User Default','1','1352226844OYVM'),('Click here to edit the preferences','1','1377725235IENV'),('The module needs to be first saved!','1','1377734767DOBZ'),('You need to save the module first before you can edit the preferences','1','1377910927MTVO'),('Click on the link to edit the preferences of the extension','1','1380567636DDVU'),('Click here to Edit the widget\'s Options','1','1416248538ILNE'),('Welcome to $APPLICATION','1','1416248908LXMN'),('You\'re almost ready to start!','1','1416248908LXMO'),('Skip setup','1','1416248908LXMQ'),('Docs','1','1416248908LXMR'),('Premium Support','1','1416248908LXMS'),('The proper Application is not installed on the website.','1','1418240185PFXV'),('An unknown issue happened on the website.','1','1418240185PFXW'),('Joomla 3.0 Menu refreshed','1','1418698684IOVP'),('Joomla 2.5 Menu refreshed','1','1418698689KRYX'),('The page is redirecting too many times!','1','1420853890NVDH'),('No output to display...','1','1420853890NVDI'),('An unknown error occured.','1','1420853891WXL'),('Subcriber','1','1424213023BXKK'),('Joobi Widgets','1','1426644982FUIK'),('Create $APPLICATION pages','1','1436531336NQEF');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UQ_core_acl_groups_aro_map_group_id_aro_id' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='258group_id' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_categories' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' 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_user_usergroups|main_joomla16' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='921id' LIMIT 1));
SET @pk_77_10908 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'sections\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'section696\' 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_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'id595\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('section','1','section',@pk_77_10908,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='section696' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='695id' LIMIT 1),'1','1','id',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sections' LIMIT 1),@dbtid_2,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('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_3,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='modules' LIMIT 1),'99');
SET @pk_621_251 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.users' LIMIT 1 );
SET @pk_621_258 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='core.acl.groups.aro.map' LIMIT 1 );
SET @pk_621_469 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.plugins' 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_1017 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla16.aclgroups' LIMIT 1 );
SET @pk_621_1039 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categoriesj16' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_251,`dbtid`=@dbtid_4,`path`='0',`namekey`='joomla.users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.users';
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_251,@dbtid_4,'0','joomla.users','users',@rolid_0,'0','1','0','0','','','users','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_258,`dbtid`=@dbtid_1,`path`='0',`namekey`='core.acl.groups.aro.map',`folder`='core.acl.groups.aro.map',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='core_acl',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='core.acl.groups.aro.map';
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_258,@dbtid_1,'0','core.acl.groups.aro.map','core.acl.groups.aro.map',@rolid_0,'0','1','0','0','','','core_acl','0','0','1','','');
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_595,`dbtid`=@dbtid_3,`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_3,'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_1017,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='usergroups' LIMIT 1),`path`='0',`namekey`='joomla16.aclgroups',`folder`='joomla16.aclgroups',`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.aclgroups';
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_1017,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='usergroups' LIMIT 1),'0','joomla16.aclgroups','joomla16.aclgroups',@rolid_0,'0','1','0','0','autofld=1','','joomla16','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1039,`dbtid`=@dbtid_2,`path`='0',`namekey`='joomla.categoriesj16',`folder`='joomla',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nparentmap=parent_id\nparentname=title\nskipdepth=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='joomla.categoriesj16';
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_1039,@dbtid_2,'0','joomla.categoriesj16','joomla',@rolid_0,'0','1','0','0','autofld=1\nparentmap=parent_id\nparentname=title\nskipdepth=1','','joomla','0','0','1','fa-folder-open','');

SET @wid_5 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='api.node' LIMIT 1);
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_5,'1','');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_5,'1','1206732392OZUQ'),(@wid_5,'1','1206732400OWZO'),(@wid_5,'2','1206732412DAGC'),(@wid_5,'1','1206961889EEYJ'),(@wid_5,'1','1206961998KTYJ'),(@wid_5,'1','1208359284QWNS'),(@wid_5,'2','1211280059QYRJ'),(@wid_5,'1','1221228435BYUA'),(@wid_5,'2','1228820287MBVC'),(@wid_5,'0','1341249340REAS'),(@wid_5,'2','1352226844OYVM'),(@wid_5,'1','1377725235IENV'),(@wid_5,'0','1377734767DOBZ'),(@wid_5,'1','1377910927MTVO'),(@wid_5,'1','1380567636DDVU'),(@wid_5,'2','1416248538ILNE'),(@wid_5,'1','1416248908LXMN'),(@wid_5,'1','1416248908LXMO'),(@wid_5,'1','1416248908LXMQ'),(@wid_5,'1','1416248908LXMR'),(@wid_5,'1','1416248908LXMS'),(@wid_5,'1','1418240185PFXV'),(@wid_5,'1','1418240185PFXW'),(@wid_5,'0','1418698684IOVP'),(@wid_5,'0','1418698689KRYX'),(@wid_5,'1','1420853890NVDH'),(@wid_5,'1','1420853890NVDI'),(@wid_5,'1','1420853891WXL'),(@wid_5,'1','1424213023BXKK'),(@wid_5,'1','1426644982FUIK'),(@wid_5,'1','1436531336NQEF');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_5),'','','','','','','','','','','0','');
SET @dbcid_6 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.users' LIMIT 1),'1298350334ECWR',@wid_5);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='core.acl.groups.aro.map' LIMIT 1),'1304525968YBL',@wid_5),(@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.plugins' LIMIT 1),'1298350305KUTU',@wid_5),(@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.modules' LIMIT 1),'1298350305KUTV',@wid_5),(@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.components' LIMIT 1),'1235461972DIWB',@wid_5),(@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla16.aclgroups' LIMIT 1),'1298350408NRRZ',@wid_5),(@dbcid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categoriesj16' LIMIT 1),'1206732411EGQO',@wid_5);