/*Export of the extension images.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1206961936HCWM','1212843259ITHW','1338338300MXQW','1338404981IUWW','1405632893JOWQ' );
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') 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','232login','232rolid','618sid','618lgid','618name','visibility232','auto618','fromlgid618','curid232','md5478','alias478','vendid478','core478','storage478','folder478','ip232','ctyid232','mobile232','filid232') 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 ('images.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 );
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');
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 );
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');
SET @pk_5_156 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='images.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='images',`wid`=@pk_5_156,`params`='',`status`='1',`type`='150',`name`='Images',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='images.node',`version`='4323',`lversion`='4323',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='images.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','images',@pk_5_156,'','1','150','Images','node','0','1','1','images.node','4323','4323','1','','1','1','0');

INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Image','1','1206961936HCWM');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('The image folder is not writeable: $FOLDER','1','1212843259ITHW'),('Could not find the watermark picture!','1','1338338300MXQW'),('Could not find the font file!','1','1338404981IUWW'),('The GD library needs to be installed! In order to properly process the images.','1','1405632893JOWQ');
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');
SET @pk_621_478 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='images' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_478,`dbtid`=@dbtid_1,`path`='1',`namekey`='images',`folder`='images',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='joobi',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-picture-o',`pnamekey`='' WHERE  `namekey`='images';
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_478,@dbtid_1,'1','images','images',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','joobi','0','0','1','fa-picture-o','');

SET @wid_2 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='images.node' LIMIT 1);
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'0','1212843259ITHW');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_2,'0','1338338300MXQW'),(@wid_2,'0','1338404981IUWW'),(@wid_2,'0','1405632893JOWQ');
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`='images' LIMIT 1),'1206961936HCWM',@wid_2);