/*Export of the extension files.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1212761192MUSM','1315400578NDYV','1314355325PYRN','1314355325PYRO','1314355326PUMM','1314355326PUMN','1306927257COUB','1206732392OZVB','1314355326PUMO','1242282432ARKW','1314355326PUMP','1207155379JNIN','1315887077SKLY','1320746791HENI','1315400578NDYX','1315400578NDYY','1315400578NDYZ','1206732421RJQA','1315887077SKLZ','1217603899SJDE','1314962330KFZR','1206732375LZCF','1315887078RHZZ','1350588498AQSJ','1304525968YBL','1315400579EWRL','1315400579EWRM','1315400579EWRN','1315400579EWRO','1315400579EWRP','1315400579EWRQ','1315400579EWRR','1315400579EWRS','1315400579EWRT','1327527998IGPC','1206732372QTKL','1206732399EINF','1211811583DBTA','1206961877KAKC','1206961870KLAD','1206961870KLAF','1206732400OWXG','1206961936HCWM','1206961870KLBA','1206732361LXFE','1206961869IGND','1206732400OWZO','1206961850KLRI','1326149410NVBC','1221228435BYUA','1206961905BHAV','1209034856HUVS','1349726937BUMG','1242282433QLYX','1315400580NRPU','1206732410ICCJ','1206961850KLRQ','1408411439DYMT','1408411439DYMU','1408411439DYMV','1408411439DYMW','1314355327FEHU','1315400581JHWH','1206732405TIXC','1206732415ABES','1212843257NVLI','1298294171AWEH','1298350386KTQO','1305603045PMTM','1314849832QOQC','1315887069HOQD','1315887070LGQT','1315887071NUXP','1315887072IZOO','1316669857KIWF','1318337621NXST','1318337622EDNF','1318337622EDNG','1318337622EDNH','1326149408DUCB','1326470276GRUO','1326470276GRUP','1349726929FOOL','1349726930JFTH','1352329012LFYC','1352764977FLOB','1359654979DESV','1369749799PPLZ','1369749800BILF','1395437800NHYK','1395437800NHYL' );
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','joobi.files','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','dropset.valuestrans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('232uid','478filid','478modified','478name','478params','478path','478size','478type','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','478secure','478uid','232html','232registered','478thumbnail','478theight','478twidth','478width','478height','478approved','478modifiedby','232unsub','478mime','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','232login','541vid','541name','541lgid','481wname','481wdescription','232rolid','618sid','618lgid','618name','visibility232','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto618','fromlgid618','auto714','fromlgid714','curid232','md5478','alias478','vendid478','core478','storage478','folder478','ip232','ctyid232','mobile232','filid232','message485') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__dataset_foreign`.* FROM `#__dataset_columns` LEFT JOIN `#__dataset_foreign` ON `#__dataset_foreign`.`feid` = `#__dataset_columns`.`dbcid` WHERE `#__dataset_columns`.`namekey` IN ('478uid') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_joobi_files_uid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('files.node') ;
SET @rolid_0 = (1);
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_541 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('dropset_valuestrans','dropset.valuestrans',@pk_549_541,'','1.0.0',@rolid_0,'0','20','vid,lgid','valuestrans','dropset','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1);
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_2001 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478uid' LIMIT 1 );
SET @pk_616_1583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1 );
SET @pk_616_1585 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478modified' LIMIT 1 );
SET @pk_616_1587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478name' LIMIT 1 );
SET @pk_616_1588 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478params' LIMIT 1 );
SET @pk_616_1589 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478path' LIMIT 1 );
SET @pk_616_1590 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478size' LIMIT 1 );
SET @pk_616_1591 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478type' LIMIT 1 );
SET @pk_616_1998 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478secure' LIMIT 1 );
SET @pk_616_2665 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478thumbnail' LIMIT 1 );
SET @pk_616_2667 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478theight' LIMIT 1 );
SET @pk_616_2668 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478twidth' LIMIT 1 );
SET @pk_616_2670 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478width' LIMIT 1 );
SET @pk_616_2671 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478height' LIMIT 1 );
SET @pk_616_3036 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478approved' LIMIT 1 );
SET @pk_616_3085 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478modifiedby' LIMIT 1 );
SET @pk_616_3319 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478mime' LIMIT 1 );
SET @pk_616_8381 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='md5478' LIMIT 1 );
SET @pk_616_8868 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias478' LIMIT 1 );
SET @pk_616_8904 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='vendid478' LIMIT 1 );
SET @pk_616_8965 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core478' LIMIT 1 );
SET @pk_616_8987 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='storage478' LIMIT 1 );
SET @pk_616_8994 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='folder478' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_3412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482name' LIMIT 1 );
SET @pk_616_3413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482description' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_3717 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541name' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0');
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_2001,@dbtid_1,'uid','0','0','4','1','1','0','7','1',@rolid_0,'1','0','1','478uid','1','0','0'),(@pk_616_1583,@dbtid_1,'filid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','478filid','1','0','0'),(@pk_616_1585,@dbtid_1,'modified','0','1','4','1','1','0','8','1',@rolid_0,'0','0','0','478modified','1','1','0'),(@pk_616_1587,@dbtid_1,'name','0','1','14','0','1','','2','1',@rolid_0,'0','254','1','478name','1','0','0'),(@pk_616_1588,@dbtid_1,'params','0','0','16','0','1','','17','1',@rolid_0,'0','0','1','478params','1','0','0'),(@pk_616_1589,@dbtid_1,'path','0','1','14','1','1','','4','1',@rolid_0,'0','255','1','478path','1','0','0'),(@pk_616_1590,@dbtid_1,'size','0','0','4','1','1','0','6','1',@rolid_0,'0','0','1','478size','1','0','0'),(@pk_616_1591,@dbtid_1,'type','0','1','14','0','1','','5','1',@rolid_0,'0','20','1','478type','1','0','0'),(@pk_616_1998,@dbtid_1,'secure','0','0','1','0','1','0','15','1',@rolid_0,'0','0','1','478secure','1','0','0'),(@pk_616_2665,@dbtid_1,'thumbnail','0','0','1','1','1','0','14','1',@rolid_0,'0','0','1','478thumbnail','1','0','0'),(@pk_616_2667,@dbtid_1,'theight','0','0','2','1','1','0','13','1',@rolid_0,'0','0','1','478theight','1','0','0'),(@pk_616_2668,@dbtid_1,'twidth','0','0','2','1','1','0','11','1',@rolid_0,'0','0','1','478twidth','1','0','0'),(@pk_616_2670,@dbtid_1,'width','0','0','2','0','1','0','10','1',@rolid_0,'0','0','1','478width','1','0','0'),(@pk_616_2671,@dbtid_1,'height','0','0','2','1','1','0','12','1',@rolid_0,'0','0','1','478height','1','0','0'),(@pk_616_3036,@dbtid_1,'approved','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','478approved','1','0','0'),(@pk_616_3085,@dbtid_1,'modifiedby','0','1','4','1','1','0','9','1',@rolid_0,'1','0','0','478modifiedby','1','0','0'),(@pk_616_3319,@dbtid_1,'mime','0','0','14','0','1','','18','1',@rolid_0,'0','40','1','478mime','1','0','0'),(@pk_616_8381,@dbtid_1,'md5','0','1','14','0','1','','19','0','0','0','40','1','md5478','1','0','0'),(@pk_616_8868,@dbtid_1,'alias','0','1','14','0','1','','3','0','0','0','255','1','alias478','1','0','0'),(@pk_616_8904,@dbtid_1,'vendid','0','1','4','1','1','1','20','0','0','0','0','1','vendid478','1','0','0'),(@pk_616_8965,@dbtid_1,'core','0','1','25','0','1','0','21','0','0','0','0','1','core478','1','0','0'),(@pk_616_8987,@dbtid_1,'storage','0','1','1','1','1','0','22','0','0','0','0','1','storage478','1','0','0'),(@pk_616_8994,@dbtid_1,'folder','0','1','14','0','1','','23','0','0','0','254','1','folder478','1','0','0'),(@pk_616_6039,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','618name','1','0','0'),(@pk_616_3412,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3419,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_6797,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_10823,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'message','0','1','16','0','1','','5','0','0','0','0','1','message485','1','0','0'),(@pk_616_3416,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3507,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3408,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_3717,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','541name','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0');
SET @pk_5_85 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='files.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='files',`wid`=@pk_5_85,`params`='',`status`='1',`type`='150',`name`='Files',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='files.node',`version`='4681',`lversion`='4681',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='files.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','files',@pk_5_85,'','1','150','Files','node','0','1','1','files.node','4681','4681','1','','1','1','0');

SET @pk_621_90 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='files' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_90,`dbtid`=@dbtid_1,`path`='1',`namekey`='files',`folder`='files',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='files';
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_90,@dbtid_1,'1','files','files',@rolid_0,'0','1','0','0','autofld=1','','joobi','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='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_1015,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');

SET @wid_2 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='files.node' LIMIT 1);
SET @sid_3 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='files' LIMIT 1);
SET @rolid_4 = (13);
SET @yid_5 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='files_upload_files' LIMIT 1);
SET @yid_6 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='files_update_files' LIMIT 1);
SET @rolid_7 = (21);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='update_files_replace_with' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('update_files_replace_with_url','update_files_replace_with_server_file') LIMIT 2;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='upload_files_upload_local_files' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('upload_files_name1','upload_files_file','upload_files_location','upload_files_target','upload_files_createitem','upload_files_savefile') LIMIT 6;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='upload_files_add_file_by_url' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('upload_files_name2','upload_files_url','upload_files_saveurl') LIMIT 3;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='upload_files_add_files_from_server' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('upload_files_directory','upload_files_extension','upload_files_tkeepfile','upload_files_secure','upload_files_saveserver') LIMIT 5;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='update_files_current_file' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('update_files_files_alias','update_files_files_filid','update_files_files_secure','update_files_updatefile') LIMIT 4;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='update_files_replace_with_url' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('update_files_url') LIMIT 1;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='update_files_replace_with_server_file' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('update_files_directory','update_files_filename','update_files_keep') LIMIT 3;
SET @yid_8 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='files_listing' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='files_listing_files_alias' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('files_listing_files_alias_7','files_listing_files_name','files_listing_files_path','files_listing_files_path_1') LIMIT 4;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='files_listing_extra' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('files_listing_files_size','files_listing_files_height','files_listing_files_width') LIMIT 3;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='files_listing_date' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('files_listing_files_modified','files_listing_users_name') LIMIT 2;
SET @did_9 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='files_type' LIMIT 1);
SET @did_10 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='files_type_preview' LIMIT 1);
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Delete','1','1206732372QTKL'),('Current File','1','1206732375LZCF'),('Name','1','1206732392OZVB'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('Author','1','1206732400OWZO'),('Standard','1','1206732405TIXC'),('None','1','1206732410ICCJ'),('An error occurred while uploading your file.','1','1206732415ABES'),('File','1','1206732421RJQA'),('Date','1','1206961850KLRI'),('URL','1','1206961850KLRQ'),('hidden','1','1206961869IGND'),('Width','1','1206961870KLAD'),('Height','1','1206961870KLAF'),('Extra','1','1206961870KLBA'),('Size','1','1206961877KAKC'),('Download','1','1206961905BHAV'),('Image','1','1206961936HCWM'),('Upload','1','1207155379JNIN'),('Path','1','1209034856HUVS'),('Alias','1','1211811583DBTA'),('Files','1','1212761192MUSM'),('The file could not be created: $LOCATION','1','1212843257NVLI'),('Filename','1','1217603899SJDE'),('Vendor','1','1221228435BYUA'),('Directory','1','1242282432ARKW'),('Upload Files','1','1242282433QLYX'),('The file type \"$TYPE\" is not allowed. Only the following files are accepted: $FORMAT','1','1298294171AWEH'),('File Secured in Safe','1','1298350386KTQO'),('','1','1304525968YBL'),('Click here for Preview','1','1305603045PMTM'),('Add File','1','1306927257COUB'),('Upload Local Files','1','1314355325PYRN'),('Add file by URL','1','1314355325PYRO'),('Choose a File','1','1314355326PUMM'),('Choose Target Directory','1','1314355326PUMN'),('File URL','1','1314355326PUMO'),('Add files from directory','1','1314355326PUMP'),('Filies Listing','1','1314355327FEHU'),('There\'s a problem on uploading the File.','1','1314849832QOQC'),('Keep original files?','1','1314962330KFZR'),('Add files from server','1','1315400578NDYV'),('Replace with URL','1','1315400578NDYX'),('Enter URL','1','1315400578NDYY'),('Update File','1','1315400578NDYZ'),('Browse your file.<br>','1','1315400579EWRL'),('Select a directory where you want your files to be saved.<br>','1','1315400579EWRM'),('Enter the name of your file.<br>For identification purposes.<br>','1','1315400579EWRN'),('Enter the URL link of the file that you want to upload.<br>','1','1315400579EWRO'),('Specify the directory of the files that you want to upload.<br><br>','1','1315400579EWRP'),('Enter a name of URL for identification purposes.<br>','1','1315400579EWRQ'),('Specify a specific file type or file name that you want to upload from the given directory.<br><span style=\"font-weight: bold;\">Example</span>: jpg, gif, pdf  or example.jpg<br>If blank, means all files will be uploaded.<br>','1','1315400579EWRR'),('Click YES if you want to create automatically a downloadable item that will be listed in the catalog.<br>','1','1315400579EWRS'),('Select a directory where you want your files to be saved.','1','1315400579EWRT'),('Update Files','1','1315400580NRPU'),('Delete Files','1','1315400581JHWH'),('Please enter directory','1','1315887069HOQD'),('Successfully Uploaded $count Files!','1','1315887070LGQT'),('No Current File!','1','1315887071NUXP'),('There\'s a problem on saving the url.','1','1315887072IZOO'),('Specific File','1','1315887077SKLY'),('Replace with Server File','1','1315887077SKLZ'),('Replace with','1','1315887078RHZZ'),('You cannot change the file path. Please select a replacement from Local or Server File','1','1316669857KIWF'),('Successfully Uploaded File!','1','1318337621NXST'),('URL already exist.','1','1318337622EDNF'),('Successfully Saved URL!','1','1318337622EDNG'),('File Successfully Updated ! ','1','1318337622EDNH'),('Create Downloadable Item','1','1320746791HENI'),('Download not allowed','1','1326149408DUCB'),('Uploaded','1','1326149410NVBC'),('Could not find the file!','1','1326470276GRUO'),('Not allowed to download this file!','1','1326470276GRUP'),('Do you want to keep the original file or transfer it completely to a new directory.<br>','1','1327527998IGPC'),('Reduced Redundancy','1','1349726929FOOL'),('Local Server','1','1349726930JFTH'),('Storage','1','1349726937BUMG'),('Storage Location','1','1350588498AQSJ'),('Any Storage','1','1352329012LFYC'),('Loading the player...','1','1352764977FLOB'),('The file $FILENAME is too big! The maximum size allowed is: $MAX_SIZE','1','1359654979DESV'),('File removed!','1','1369749799PPLZ'),('Current File :$NAME.$TYPE','1','1369749800BILF'),('The file could not be minified because it is empty!','1','1395437800NHYK'),('The javascript file $FINENAME could not be minifed an error occured','1','1395437800NHYL'),('YouTube','1','1408411439DYMT'),('Vimeo','1','1408411439DYMU'),('Live Video','1','1408411439DYMV'),('Yahoo Video','1','1408411439DYMW');
SET @pk_77_11112 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'478uid\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('uid','1','FK_joobi_files_uid',@pk_77_11112,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478uid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'1','1','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),@dbtid_1,'1');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'1','1206732405TIXC');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'0','1206732415ABES'),(@wid_2,'1','1206961905BHAV'),(@wid_2,'0','1212843257NVLI'),(@wid_2,'0','1298294171AWEH'),(@wid_2,'1','1298350386KTQO'),(@wid_2,'1','1305603045PMTM'),(@wid_2,'0','1314849832QOQC'),(@wid_2,'0','1315887069HOQD'),(@wid_2,'0','1315887070LGQT'),(@wid_2,'0','1315887071NUXP'),(@wid_2,'0','1315887072IZOO'),(@wid_2,'0','1316669857KIWF'),(@wid_2,'0','1318337621NXST'),(@wid_2,'0','1318337622EDNF'),(@wid_2,'0','1318337622EDNG'),(@wid_2,'0','1318337622EDNH'),(@wid_2,'1','1326149408DUCB'),(@wid_2,'0','1326470276GRUO'),(@wid_2,'0','1326470276GRUP'),(@wid_2,'1','1349726929FOOL'),(@wid_2,'1','1349726930JFTH'),(@wid_2,'1','1352329012LFYC'),(@wid_2,'1','1352764977FLOB'),(@wid_2,'0','1359654979DESV'),(@wid_2,'0','1369749799PPLZ'),(@wid_2,'0','1369749800BILF'),(@wid_2,'0','1395437800NHYK'),(@wid_2,'0','1395437800NHYL');
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1),( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='files' LIMIT 1),'1212761192MUSM',@wid_2);