/*Export of the extension theme.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1207306697RNME','1206732392OZVB','1206732392OZVG','1206732392OZVD','1216230542PQQX','1206732372QTKN','1217603897AYYA','1307005986MLQD','1298350437HNTL','1211811587EZNL','1298294079SVND','1211811583DBTA','1307005987LSGU','1344051185BJJR','1307005987LSGV','1344051185BJJS','1307005987LSGW','1344051185BJJT','1206732421RJQA','1206732412DABR','1209559181OZLK','1206732411EGRY','1206961912MJQB','1206961869IGNE','1206732425HINT','1306927259HYXV','1217603899SJDE','1307005987LSGX','1307005987LSGY','1298350843FMVJ','1298350843FMVK','1212761192MUSM','1395886787SVIL','1206961869IGND','1395886787SVIM','1215507792MTRU','1395886787SVIN','1394069593IQAS','1206732400OWZR','1395886787SVIO','1395886787SVIP','1394069593IQAT','1395886787SVIQ','1395886787SVIR','1395886787SVIS','1395886787SVIT','1206732388KEHZ','1395886787SVIU','1395886787SVIV','1395886787SVIW','1395886787SVIX','1395886787SVIY','1395886787SVIZ','1395886787SVJA','1242282435FMHV','1206732412DACD','1395886787SVJB','1395886787SVJC','1395886787SVJD','1395886787SVJE','1395886787SVJF','1395886787SVJG','1217603899SJDA','1242282450QJAT','1395886787SVJI','1395886787SVJJ','1395886787SVJK','1395886787SVJL','1395886787SVJM','1395886787SVJN','1396670885NPWL','1206961997BSZK','1395886787SVJQ','1396394737MEVD','1396394737MEVE','1395886787SVJT','1395886787SVJU','1395886787SVJV','1206961877KAKC','1395886787SVJW','1395886787SVJX','1395886787SVJY','1395886787SVJZ','1395886787SVKA','1395886787SVKB','1395886787SVKC','1395886787SVKD','1395886787SVKE','1395886787SVKF','1395886787SVKG','1395886787SVKH','1242282437ISFV','1395886787SVKI','1395886787SVKJ','1395886787SVKK','1395886787SVJO','1396394737MEVF','1397783154DRZE','1396394737MEVH','1396394737MEVI','1206732366OVLY','1213695731KPWL','1206732421RJQC','1396394737MEVJ','1396394737MEVK','1396394737MEVL','1396394737MEVM','1396670885NPWM','1396670885NPWN','1212662234CPQC','1396670885NPWO','1396670885NPWP','1396670885NPWQ','1307002587NUOA','1396670885NPWS','1396670885NPWT','1242282414LZMP','1396670885NPWU','1396670885NPWV','1397142434IGLD','1397671863NNJA','1397783155AUTG','1397784635QHPJ','1397875863SIJY','1397875863SIJZ','1251285854FOAP','1398174984KSWN','1399505622LUTN','1206732412DAEO','1399988028FPZA','1400256255AHCT','1402436712SWTH','1402436712SWTI','1402436712SWTJ','1206961869IGNH','1415377877PTRF','1304525968YBL','1216230542PQQZ','1301400667SKBF','1307005988CSSM','1307005988CSSN','1307005988CSSO','1307005988CSSP','1395886787SVKM','1395886787SVKN','1395886787SVKO','1395886787SVKP','1395886787SVKQ','1395886787SVKR','1395886787SVKS','1395886787SVKT','1395886787SVKU','1395886787SVKV','1395886787SVKW','1395886787SVKX','1395886787SVKY','1395886787SVKZ','1395886787SVLA','1395886787SVLB','1395886787SVLC','1395886787SVLD','1395886787SVLE','1395886788KYRS','1395886788KYRT','1395886788KYRU','1395886788KYRV','1395886788KYRW','1395886788KYRZ','1395886788KYSA','1395886788KYSB','1395886788KYSC','1395886788KYSD','1395886788KYSE','1395886788KYSF','1395886788KYSG','1395886788KYSH','1395886788KYSI','1395886788KYSJ','1395886788KYSK','1395886788KYSL','1395886788KYSM','1395886788KYSN','1395886788KYSO','1395886788KYSP','1395886788KYSQ','1395886788KYSR','1395886788KYSS','1396394738FVXB','1396394738FVXC','1396394738FVXD','1396394738FVXE','1396394738FVXF','1396394738FVXG','1396394738FVXH','1396394738FVXI','1396394738FVXJ','1396394738FVXK','1396394738FVXL','1396394738FVXM','1396394738FVXN','1396394738FVXO','1396394738FVXP','1396394738FVXQ','1396394738FVXR','1396394738FVXS','1398196675ECCG','1396670886HSVU','1396670886HSVV','1396670886HSVW','1396670886HSVX','1396670886HSVY','1396670886HSVZ','1396670886HSWA','1396670886HSWB','1396670886HSWC','1396670886HSWD','1396670886HSWE','1396670886HSWF','1396670886HSWG','1396670886HSWH','1396670886HSWI','1396670886HSWJ','1396670886HSWK','1396670886HSWL','1396670886HSWM','1397142435SAFZ','1397671864NQDV','1397671864NQDW','1397671864NQDX','1397783156CAWV','1397783156CAWW','1397783156CAWX','1397784636NFCW','1397875864HNPT','1397875864HNPU','1398174985PICN','1399505625PJLS','1399988029JPTN','1400256256TGRK','1402436713RMMP','1402436713RMMQ','1402436713RMMR','1415377877PTRG','1228820287MBVC','1238171026KDKW','1206732399EINF','1206732391QBUR','1206732399EINB','1242282449PIPC','1206732393CXVV','1206961882TDHA','1298294078HATF','1307005985RRVD','1306927257COUB','1206732392OZUP','1206732372QTKM','1396670884ALJE','1360193291CNEA','1206732400OWXG','1206732439BHWY','1273655191NLYX','1206732389NXTS','1208951159ARQZ','1208951159ARQY','1206732392OZVA','1209034855GGPY','1253939321KJPL','1206732372QTKL','1206961850KLRI','1300366591QTAK','1300366591QTAJ','1398436917DTKC','1298350436LSKP','1211811516QTEF','1208951159ARQX','1298350437HNTN','1298350437HNTO','1298350437HNTP','1298350437HNTQ','1298350437HNTR','1298350437HNTS','1300366596LVYZ','1206732372QTKK','1207155379JNIN','1347397381CQOQ','1211907792LCMK','1208951159ARRF','1301400668NOSW','1396670886HSWN','1271819049DNZB','1212843296FJPT','1420549280BNHL','1300169727QALO','1300111184CKDD','1298350438DLWR','1234467594BCKE','1206732361LXFE','1206732400OWZW','1206732400OXBR','1206961869IGNP','1206961936HCWP','1251697929ABZD','1298294183ETWL','1298350435GKOB','1298350435GKOC','1307005978SBLO','1307012876GLGV','1309502072SWIE','1316671955LOQA','1329173545MEGR','1329173546QVQL','1382364838SGIL','1395437861EIXK','1396670883SAXN','1399595651JURP','1416822016EIWM','1416822016EIWN','1417812852DFNC','1420549276ICAG' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('theme.node','theme.trans') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('theme.node','theme.trans','extension.node','members.node','joobi.files','joobi.languages','role.node','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('5publish','5folder','5wid','5params','5status','5type','5name','232uid','478filid','478modified','478name','478params','478path','478size','478type','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','478secure','478uid','232html','232registered','199name','199main','199publish','199real','478thumbnail','478theight','478twidth','478width','478height','478approved','451tmid','451type','451namekey','451publish','478modifiedby','232unsub','478mime','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','5parent','5trans','484description','5certify','5namekey','232login','5version','5lversion','199rtl','451premium','5pref','559tmid','559name','559description','559lgid','451core','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','5rolid','566type','5install','451wid','451alias','199availadmin','199availsite','618sid','618lgid','618name','199locale','566depth','199localeconv','ordering5','core5','visibility232','modified5','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto559','fromlgid559','auto618','fromlgid618','auto714','fromlgid714','curid232','md5478','filid451','created451','modified451','availability451','folder451','j16566','alias478','params451','vendid478','core478','storage478','folder478','ip232','ctyid232','reload5','core199','created5','mobile232','rolid451','uid451','ordering451','filid232','automatic199','showconfig5','framework5','message485','framework451') 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 ('559tmid','559lgid','451wid','filid451','rolid451','uid451') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_theme_wid','FK_theme_trans_lgid','FK_theme_trans_tmid','theme_joobi_files_filid','FK_theme_node_rolid','FK_theme_node_uid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('theme.node') ;
SET @rolid_0 = (1);
SET @pk_549_451 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1 );
SET @pk_549_559 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.trans' LIMIT 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_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' 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_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 ('theme_node','theme.node',@pk_549_451,'','1.0.0',@rolid_0,'0','1','tmid','node','theme','51','0','0','0','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('theme_trans','theme.trans',@pk_549_559,'','1.0.0',@rolid_0,'0','20','tmid,lgid','trans','theme','51','0','0','0','7'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_multiforms','layout.multiforms',@pk_549_1,'','1.0.0',@rolid_0,'0','10','fid','multiforms','layout','9','0','1','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'),('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`='theme.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.trans' LIMIT 1);
SET @pk_454_138 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_theme_node_namekey' LIMIT 1 );
SET @pk_454_65466 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_themetrans_tmid_lgid' LIMIT 1 );
SET @pk_454_65551 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_theme_node' LIMIT 1 );
SET @pk_454_66144 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IK_theme_node_type_publish_core_premium' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_138,'1','UK_theme_node_namekey',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65466,'3','PK_themetrans_tmid_lgid',@dbtid_2),(@pk_454_65551,'3','PK_theme_node',@dbtid_1),(@pk_454_66144,'2','IK_theme_node_type_publish_core_premium',@dbtid_1);
SET @pk_616_3037 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1 );
SET @pk_616_3039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451type' LIMIT 1 );
SET @pk_616_3040 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451namekey' LIMIT 1 );
SET @pk_616_3047 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451publish' LIMIT 1 );
SET @pk_616_3703 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451premium' LIMIT 1 );
SET @pk_616_5471 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559tmid' LIMIT 1 );
SET @pk_616_5475 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559lgid' LIMIT 1 );
SET @pk_616_5531 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451core' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_5712 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451wid' LIMIT 1 );
SET @pk_616_8401 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid451' LIMIT 1 );
SET @pk_616_10221 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid451' LIMIT 1 );
SET @pk_616_10222 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid451' LIMIT 1 );
SET @pk_616_5473 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559name' LIMIT 1 );
SET @pk_616_5474 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559description' LIMIT 1 );
SET @pk_616_5713 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451alias' LIMIT 1 );
SET @pk_616_6862 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto559' LIMIT 1 );
SET @pk_616_6863 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid559' LIMIT 1 );
SET @pk_616_8403 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created451' LIMIT 1 );
SET @pk_616_8404 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified451' LIMIT 1 );
SET @pk_616_8406 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='availability451' LIMIT 1 );
SET @pk_616_8440 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='folder451' LIMIT 1 );
SET @pk_616_8873 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params451' LIMIT 1 );
SET @pk_616_10224 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering451' LIMIT 1 );
SET @pk_616_10850 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='framework451' 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_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_3037,@dbtid_1,'tmid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','451tmid','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_3039,@dbtid_1,'type','0','0','1','1','1','1','7','1',@rolid_0,'0','0','1','451type','1','0','0'),(@pk_616_3040,@dbtid_1,'namekey','0','1','14','0','1','','4','1',@rolid_0,'0','50','1','451namekey','1','0','0'),(@pk_616_3047,@dbtid_1,'publish','0','0','1','0','1','1','10','1',@rolid_0,'0','0','1','451publish','1','0','0'),(@pk_616_3703,@dbtid_1,'premium','0','0','25','1','1','0','11','1',@rolid_0,'0','0','0','451premium','1','0','0'),(@pk_616_5471,@dbtid_2,'tmid','1','0','2','0','1','','1','1',@rolid_0,'0','5','1','559tmid','1','0','0'),(@pk_616_5475,@dbtid_2,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','4','1','559lgid','1','0','0'),(@pk_616_5531,@dbtid_1,'core','0','0','25','0','1','0','12','1',@rolid_0,'0','3','1','451core','1','0','0'),(@pk_616_81,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_1583,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),'filid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','478filid','1','0','0'),(@pk_616_1698,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_5532,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_5712,@dbtid_1,'wid','0','0','3','1','1','0','2','1',@rolid_0,'0','0','1','451wid','1','0','0'),(@pk_616_8401,@dbtid_1,'filid','0','1','4','1','1','0','3','0','0','0','0','1','filid451','1','0','0'),(@pk_616_10221,@dbtid_1,'rolid','0','1','2','1','1','1','15','0','0','0','0','1','rolid451','1','0','0'),(@pk_616_10222,@dbtid_1,'uid','0','1','4','1','1','0','16','0','0','0','0','1','uid451','1','0','0'),(@pk_616_5473,@dbtid_2,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','559name','1','0','0'),(@pk_616_5474,@dbtid_2,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','559description','1','0','0'),(@pk_616_5713,@dbtid_1,'alias','0','0','14','0','1','','5','1',@rolid_0,'0','250','1','451alias','1','0','0'),(@pk_616_6862,@dbtid_2,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto559','1','0','0'),(@pk_616_6863,@dbtid_2,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid559','1','0','0'),(@pk_616_8403,@dbtid_1,'created','0','1','4','1','1','0','8','0','0','0','0','1','created451','1','1','0'),(@pk_616_8404,@dbtid_1,'modified','0','1','4','1','1','0','9','0','0','0','0','1','modified451','1','1','0'),(@pk_616_8406,@dbtid_1,'availability','0','1','1','1','1','1','13','0','0','0','0','0','availability451','1','0','0'),(@pk_616_8440,@dbtid_1,'folder','0','1','14','0','1','','6','0','0','0','100','1','folder451','1','0','0'),(@pk_616_8873,@dbtid_1,'params','0','1','16','0','1','','14','0','0','0','0','0','params451','1','0','0'),(@pk_616_10224,@dbtid_1,'ordering','0','1','2','1','1','999','17','0','0','0','0','1','ordering451','1','0','0'),(@pk_616_10850,@dbtid_1,'framework','0','1','1','1','1','0','18','0','0','0','0','1','framework451','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_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_187 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='theme.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='theme',`wid`=@pk_5_187,`params`='',`status`='1',`type`='150',`name`='Theme',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='theme.node',`version`='4345',`lversion`='4345',`pref`='0',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='theme.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','theme',@pk_5_187,'','1','150','Theme','node','0','1','1','theme.node','4345','4345','0','','1','1','0');

SET @pk_621_451 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='theme' LIMIT 1 );
SET @pk_621_559 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='themetrans' LIMIT 1 );
SET @pk_621_1 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='view.forms' LIMIT 1 );
SET @pk_621_482 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='view.formstrans' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_451,`dbtid`=@dbtid_1,`path`='1',`namekey`='theme',`folder`='theme',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\npremmap=premium\npremgroup=type\nverifld=1',`alias`='',`prefix`='theme',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-desktop',`pnamekey`='' WHERE  `namekey`='theme';
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_451,@dbtid_1,'1','theme','theme',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\npremmap=premium\npremgroup=type\nverifld=1','','theme','0','0','1','fa-desktop','');
UPDATE `#__model_node`  SET `sid`=@pk_621_559,`dbtid`=@dbtid_2,`path`='0',`namekey`='themetrans',`folder`='themetrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=theme',`alias`='',`prefix`='theme',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-desktop',`pnamekey`='' WHERE  `namekey`='themetrans';
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_559,@dbtid_2,'0','themetrans','themetrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=theme','','theme','0','0','1','fa-desktop','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1),`path`='1',`namekey`='view.forms',`folder`='view.forms',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nprtname=view.formstrans\nautofld=1',`alias`='',`prefix`='layout',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='view.forms';
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_1,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1),'1','view.forms','view.forms',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nprtname=view.formstrans\nautofld=1','','layout','0','0','1','fa-th-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_482,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),`path`='0',`namekey`='view.formstrans',`folder`='view.formstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=view.forms',`alias`='',`prefix`='layout',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='view.formstrans';
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_482,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'0','view.formstrans','view.formstrans',@rolid_0,'0','1','0','0','mainmodel=view.forms','','layout','0','0','1','fa-th-list','');

SET @wid_3 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='theme.node' LIMIT 1);
SET @sid_4 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='theme' LIMIT 1);
SET @sid_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='view.forms' LIMIT 1);
SET @rolid_6 = (7);
SET @rolid_7 = (9);
SET @rolid_8 = (8);
SET @rolid_9 = (3);
SET @rolid_10 = (18);
SET @wid_11 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='main.node' LIMIT 1);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_node_show' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_edit_file' LIMIT 1);
SET @yid_14 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_node_form' LIMIT 1);
SET @yid_15 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_clone' LIMIT 1);
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_add_file' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_upload_file' LIMIT 1);
SET @did_18 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_icon_position' LIMIT 1);
SET @did_19 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_button_color' LIMIT 1);
SET @did_20 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_button_size' LIMIT 1);
SET @did_21 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_icons' LIMIT 1);
SET @sid_22 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='themetrans' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_fieldset_files' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('theme_node_form_themes_html','theme_node_form_custom_php_views_php','theme_node_form_stylesheets_css','theme_node_form_javascripts_js') LIMIT 4;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('theme_node_form_general_information') LIMIT 1;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_column_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('theme_node_form_fieldset_files') LIMIT 1;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('theme_node_form_general_info') LIMIT 1;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_preferences' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('theme_node_form_column1','theme_node_form_navigation_bar') LIMIT 2;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_navigation_bar' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('theme_node_form_general_1','theme_node_form_navigation_bar_1','theme_node_form_panes_and_tabs','theme_node_form_alerts','theme_node_form_miscellaneous') LIMIT 5;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('theme_node_form_view','theme_node_form_toolbar','theme_node_form_table__listing','theme_node_form_form') LIMIT 4;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_toolbar' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('theme_node_form_buttons','theme_node_form_icons_1') LIMIT 2;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_tab_catalog' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('theme_node_form_column1_1','theme_node_form_column2_1') LIMIT 2;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_column1_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('theme_node_form_catalog','theme_node_form_social_icons') LIMIT 2;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_miscellaneous' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('theme_node_form_standalone_buttons') LIMIT 1;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_catalog' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('theme_node_form_add_to_cart_button','theme_node_form_detail_button','theme_node_form_review_button','theme_node_form_ask_question','theme_node_form_view_all_button','theme_node_form_vendor_register_button','theme_node_form_add_to_cart_button_in_item_page','theme_node_form_carousel_button','theme_node_form_star_icons','theme_node_form_catalog_container') LIMIT 10;
SET @p_1_12 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_form' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_12 WHERE `namekey` IN ('theme_node_form_tooltips','theme_node_form_form_direction') LIMIT 2;
SET @p_1_13 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_cart' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_13 WHERE `namekey` IN ('theme_node_form_cart_update_button','theme_node_form_previous_button','theme_node_form_next_button','theme_node_form_vew_map_button','theme_node_form_edit_address_button') LIMIT 5;
SET @p_1_14 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_table__listing' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_14 WHERE `namekey` IN ('theme_node_form_search_buttons','theme_node_form_table') LIMIT 2;
SET @p_1_15 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_column2_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_15 WHERE `namekey` IN ('theme_node_form_cart','theme_node_form_breadcrumbs') LIMIT 2;
SET @p_1_16 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_general_information' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_16 WHERE `namekey` IN ('theme_node_form_theme_premium','theme_node_form_themetrans_name','theme_node_form_theme_alias','theme_node_form_themetrans_description','theme_node_form_theme_type','theme_node_form_theme_folder','theme_node_form_theme_rolid','theme_node_form_theme_publish','theme_node_form_theme_core','theme_node_form_theme_tmid','theme_node_form_theme_created') LIMIT 11;
SET @p_1_17 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_themes_html' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_17 WHERE `namekey` IN ('theme_node_form_files_3') LIMIT 1;
SET @p_1_18 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_custom_php_views_php' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_18 WHERE `namekey` IN ('theme_node_form_files_2') LIMIT 1;
SET @p_1_19 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_stylesheets_css' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_19 WHERE `namekey` IN ('theme_node_form_files_1') LIMIT 1;
SET @p_1_20 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_javascripts_js' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_20 WHERE `namekey` IN ('theme_node_form_files') LIMIT 1;
SET @p_1_21 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_edit_file_code' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_21 WHERE `namekey` IN ('theme_edit_file_content') LIMIT 1;
SET @p_1_22 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_general_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_22 WHERE `namekey` IN ('theme_node_form_image_responsive','theme_node_form_image_style','theme_node_form_image_skin','theme_node_form_image_nobootstrap','theme_node_form_font_awesome') LIMIT 5;
SET @p_1_23 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_navigation_bar_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_23 WHERE `namekey` IN ('theme_node_form_nav_logoname','theme_node_form_nav_brand','theme_node_form_nav_uselogo','theme_node_form_nav_showicon','theme_node_form_legend_remove','theme_node_form_pagination') LIMIT 6;
SET @p_1_24 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_panes_and_tabs' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_24 WHERE `namekey` IN ('theme_node_form_form_tabfade','theme_node_form_pane_color','theme_node_form_pane_icon') LIMIT 3;
SET @p_1_25 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_alerts' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_25 WHERE `namekey` IN ('theme_node_form_alert_dismiss','theme_node_form_alert_collapse') LIMIT 2;
SET @p_1_26 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_standalone_buttons' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_26 WHERE `namekey` IN ('theme_node_form_button_iconposition','theme_node_form_button_icon','theme_node_form_button_defaultcolor','theme_node_form_button_color') LIMIT 4;
SET @p_1_27 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_view' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_27 WHERE `namekey` IN ('theme_node_form_form_icon','theme_node_form_wizard_color') LIMIT 2;
SET @p_1_28 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_tooltips' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_28 WHERE `namekey` IN ('theme_node_form_form_tooltip','theme_node_form_tooltip_html','theme_node_form_tooltip_location','theme_node_form_tooltip_placement','theme_node_form_tooltip_method') LIMIT 5;
SET @p_1_29 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_buttons' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_29 WHERE `namekey` IN ('theme_node_form_toolbar_color','theme_node_form_toolbar_group','theme_node_form_toolbar_colordefault') LIMIT 3;
SET @p_1_30 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_icons_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_30 WHERE `namekey` IN ('theme_node_form_toolbar_icon','theme_node_form_toolbar_iconcolored','theme_node_form_toolbar_iconsize','theme_node_form_toolbar_position') LIMIT 4;
SET @p_1_31 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_table' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_31 WHERE `namekey` IN ('theme_node_form_table_maxlist','theme_node_form_table_condensed','theme_node_form_table_hover','theme_node_form_table_border','theme_node_form_table_striped','theme_node_form_table_columniconcolor') LIMIT 6;
SET @p_1_32 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_search_buttons' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_32 WHERE `namekey` IN ('theme_node_form_table_buttoncolor','theme_node_form_table_buttonicon_1','theme_node_form_table_buttontext_','theme_node_form_table_buttoniconcolored') LIMIT 4;
SET @p_1_33 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_star_icons' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_33 WHERE `namekey` IN ('theme_node_form_catalog_starcolor','theme_node_form_catalog_starsize') LIMIT 2;
SET @p_1_34 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_carousel_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_34 WHERE `namekey` IN ('theme_node_form_catalog_carrouselcontrolcolor') LIMIT 1;
SET @p_1_35 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_add_to_cart_button_in_item_page' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_35 WHERE `namekey` IN ('theme_node_form_catalog_addcarticon','theme_node_form_catalog_addcartcolor','theme_node_form_catalog_addcartsize') LIMIT 3;
SET @p_1_36 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_review_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_36 WHERE `namekey` IN ('theme_node_form_catalog_reviewicon','theme_node_form_catalog_reviewcolor','theme_node_form_catalog_reviewsize') LIMIT 3;
SET @p_1_37 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_detail_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_37 WHERE `namekey` IN ('theme_node_form_catalog_detailicon','theme_node_form_catalog_detailcolor','theme_node_form_catalog_detailsize') LIMIT 3;
SET @p_1_38 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_ask_question' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_38 WHERE `namekey` IN ('theme_node_form_catalog_questioncolor','theme_node_form_theme_catalog_questionsize') LIMIT 2;
SET @p_1_39 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_view_all_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_39 WHERE `namekey` IN ('theme_node_form_catalog_viewallicon','theme_node_form_catalog_viewallcolor','theme_node_form_catalog_viewallsize') LIMIT 3;
SET @p_1_40 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_add_to_cart_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_40 WHERE `namekey` IN ('theme_node_form_catalog_carticon','theme_node_form_catalog_cartcolor','theme_node_form_catalog_cartsize') LIMIT 3;
SET @p_1_41 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_vendor_register_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_41 WHERE `namekey` IN ('theme_node_form_catalog_vendorsregistericon','theme_node_form_catalog_vendorsregistercolor','theme_node_form_catalog_vendorsregistersize') LIMIT 3;
SET @p_1_42 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_social_icons' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_42 WHERE `namekey` IN ('theme_node_form_socialicon_showtext','theme_node_form_socialicon_group','theme_node_form_socialicon_showcount','theme_node_form_socialicon_size','theme_node_form_socialicon_color','theme_node_form_socialicon_colorprint','theme_node_form_socialicon_colorsharewall','theme_node_form_socialicon_colorviews','theme_node_form_socialicon_colordislike','theme_node_form_socialicon_colorlike','theme_node_form_socialicon_colorwatch','theme_node_form_socialicon_colorwish','theme_node_form_socialicon_colorfavorite','theme_node_form_socialicon_colorfacebookshare','theme_node_form_socialicon_colortwittershare','theme_node_form_socialicon_colorgoogleshare') LIMIT 16;
SET @p_1_43 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_breadcrumbs' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_43 WHERE `namekey` IN ('theme_node_form_navigation_brdcrumbcatalogusecms','theme_node_form_navigation_brdcrumbcartusecms') LIMIT 2;
SET @p_1_44 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_cart_update_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_44 WHERE `namekey` IN ('theme_node_form_catalog_cartupdateicon','theme_node_form_catalog_cartupdatecolor','theme_node_form_catalog_cartupdatesize') LIMIT 3;
SET @p_1_45 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_previous_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_45 WHERE `namekey` IN ('theme_node_form_catalog_cartpreviousicon','theme_node_form_catalog_cartpreviouscolor','theme_node_form_catalog_cartprevioussize_1','theme_node_form_catalog_cartpreviousiconposition') LIMIT 4;
SET @p_1_46 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_next_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_46 WHERE `namekey` IN ('theme_node_form_catalog_cartnexticon','theme_node_form_catalog_cartnextcolor','theme_node_form_catalog_cartnextsize','theme_node_form_catalog_cartnexticonposition') LIMIT 4;
SET @p_1_47 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_vew_map_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_47 WHERE `namekey` IN ('theme_node_form_catalog_viewmapicon','theme_node_form_catalog_viewmapcolor','theme_node_form_catalog_viewmapsize') LIMIT 3;
SET @p_1_48 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_edit_address_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_48 WHERE `namekey` IN ('theme_node_form_catalog_editaddressicon','theme_node_form_catalog_editaddresscolor','theme_node_form_catalog_editaddresssize') LIMIT 3;
SET @p_1_49 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='theme_node_form_general_info' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_49 WHERE `namekey` IN (' theme_node_form_general_name','theme_node_form_general_alias','theme_node_form_general_description','theme_node_form_rolid','theme_node_form_general_publish') LIMIT 5;
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_listing' LIMIT 1);
SET @yid_24 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_elements' LIMIT 1);
SET @yid_25 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='theme_select_mail_theme' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='theme_listing_theme_type_5' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('theme_listing_theme_type','theme_listing_theme_folder') LIMIT 2;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='theme_listing_themetrans_name_6' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('theme_listing_themetrans_name','theme_listing_theme_identifier','theme_listing_theme_tmid','theme_listing_theme_namekey','theme_listing_themetrans_description') LIMIT 5;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Display','1','1206732366OVLY'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Show','1','1206732372QTKM'),('Publish','1','1206732372QTKN'),('View','1','1206732388KEHZ'),('Element','1','1206732389NXTS'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Type','1','1206732392OZVD'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('General','1','1206732400OWZR'),('Mail','1','1206732400OWZW'),('Application','1','1206732400OXBR'),('Created','1','1206732411EGRY'),('General Information','1','1206732412DABR'),('Group','1','1206732412DACD'),('Access','1','1206732412DAEO'),('File','1','1206732421RJQA'),('Location','1','1206732421RJQC'),('Default','1','1206732425HINT'),('tmid','1','1206732439BHWY'),('Date','1','1206961850KLRI'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Form','1','1206961869IGNH'),('Order','1','1206961869IGNP'),('Size','1','1206961877KAKC'),('Back','1','1206961882TDHA'),('Code','1','1206961912MJQB'),('Coupon','1','1206961936HCWP'),('Catalog','1','1206961997BSZK'),('Upload','1','1207155379JNIN'),('Theme','1','1207306697RNME'),('Theme elements','1','1208951159ARQX'),('Publish state','1','1208951159ARQY'),('{tag content}','1','1208951159ARQZ'),('Management of theme elements','1','1208951159ARRF'),('fid','1','1209034855GGPY'),('Id','1','1209559181OZLK'),('Themes','1','1211811516QTEF'),('Alias','1','1211811583DBTA'),('Preview','1','1211811587EZNL'),('Themes List','1','1211907792LCMK'),('Table','1','1212662234CPQC'),('Files','1','1212761192MUSM'),('<p>If you publish an element, take care that the tag is exiting in your theme content.<br />\r\n<br />\r\nIf you unpublish an element, the tag does not need to be removed to undisplay the element.</p>','1','1212843296FJPT'),('Position','1','1213695731KPWL'),('Information','1','1215507792MTRU'),('Pagination style','1','1216230542PQQX'),('<ul><li>Lean: just the page numbers</li><li>No total: standard without the total number of pages</li><li>Standard: optimal pagination</li><li>Complete: all possible buttons<br></li></ul>','1','1216230542PQQZ'),('Folder','1','1217603897AYYA'),('Buttons','1','1217603899SJDA'),('Filename','1','1217603899SJDE'),('Close','1','1228820287MBVC'),('<br><br><br>','1','1234467594BCKE'),('Edit Theme','1','1238171026KDKW'),('Breadcrumbs','1','1242282414LZMP'),('Toolbar','1','1242282435FMHV'),('Miscellaneous','1','1242282437ISFV'),('Done','1','1242282449PIPC'),('Icons','1','1242282450QJAT'),('Star Color ','1','1251285854FOAP'),('Widget','1','1251697929ABZD'),('Thumbnail','1','1253939321KJPL'),('<p>Below are the list of all themes used by the installed applications.  You can customize those themes as you wish. The modification will affect how the data are rendered.</p><p><strong>Note:</strong> To customize a theme you need to \"<span style=\"color:#FF0000\"><strong>CLONE</strong></span>\" to be able to edit the file. The cloned theme will be automatically set as the default theme. Cloning a theme is important so you can easily update without losing your customized code.</p><p><span style=\"color:#FF0000\"><strong>Edit Theme Button: </strong></span>You can access the theme design and customize the look and feel of your store without having to enter a single code.<br><span style=\"color:#FF0000\"><strong>Minify: </strong></span>Minify the themes to lessen the size of the file and improve page load.<br><strong>Hint:</strong></p><p>*You can\'t <strong>delete</strong> a theme which is <strong>core</strong>. You can only delete uncore theme.<br>**You can\'t <strong>unpublish</strong> a theme which is set as <strong>default</strong>. Kindly choose another one as default and then unpublish. Moreover, you can\'t set as default a theme that is not published. Kindly publish and then set as default.</p>','1','1271819049DNZB'),('Origin','1','1273655191NLYX'),('Clone','1','1298294078HATF'),('Main Files','1','1298294079SVND'),('Successfully saved the file $file','1','1298294183ETWL'),('Kindly enter a folder name','1','1298350435GKOB'),('The folder \"$folder\" already exists. Kindly enter another folder name.','1','1298350435GKOC'),('do we need to customize only one item that can be set as default?','1','1298350436LSKP'),('Folder name','1','1298350437HNTL'),('Clone Theme','1','1298350437HNTN'),('Theme main files','1','1298350437HNTO'),('Theme custom view  files','1','1298350437HNTP'),('Theme stylesheet files','1','1298350437HNTQ'),('Theme js files','1','1298350437HNTR'),('Theme Edit File','1','1298350437HNTS'),('Upload a theme','1','1298350438DLWR'),('Column 1','1','1298350843FMVJ'),('Column 2','1','1298350843FMVK'),('<p><strong>Information Tab:</strong> Short information about the theme<br />\r\n<strong>General Design Tab:</strong> You can define the general look and feel of all Application in the backend and front-end. This option is accessible through <strong>Joomla 3.2 Responsive Admin Theme</strong>.<br />\r\n<strong>Catalog Design Tab:</strong> You can customize different options to change the look and feel of your store such as button color, sizes and icons. This option is accessible through <strong>Joomla 3.2 Responsive Theme</strong>.</p>','1','1300111184CKDD'),('<p>For more information about HTML, css, etc., kindly refer to this <a href=\"http://www.w3schools.com/html/html_examples.asp\" target=\"_blank\" title=\"HTML, CSS Documentation\">documentation</a>.</p>','1','1300169727QALO'),(' Name','1','1300366591QTAJ'),(' Thumbnail','1','1300366591QTAK'),('Select Theme','1','1300366596LVYZ'),('Enter the destination folder.<br><br><br>','1','1301400667SKBF'),('Copy Theme','1','1301400668NOSW'),('','1','1304525968YBL'),('Add File','1','1306927257COUB'),('File Type','1','1306927259HYXV'),('Cart','1','1307002587NUOA'),('File already exists.','1','1307005978SBLO');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Upload FIle','1','1307005985RRVD'),('Themes (HTML)','1','1307005986MLQD'),('Custom PHP Views (PHP)','1','1307005987LSGU'),('Stylesheets (CSS)','1','1307005987LSGV'),('Javascripts (JS)','1','1307005987LSGW'),('Destination file','1','1307005987LSGX'),('Select FIle','1','1307005987LSGY'),('Select what type of file that you are going to create.<br>','1','1307005988CSSM'),('Enter the name of the file that you want to create.<br>','1','1307005988CSSN'),('Enter the destination filename for the copy.<br>','1','1307005988CSSO'),('Select what type of file that you are going to upload. The file will be uploaded in the folder that corresponds to the type of file.<br>','1','1307005988CSSP'),('Please enter another filename. <br /> You must not use the name index.','1','1307012876GLGV'),('You have selected more than one theme to clone. Only the first theme will be cloned.','1','1309502072SWIE'),('The file, $FILENAME, cannot be previewed because it is too big ( 1Mb max )','1','1316671955LOQA'),('If the theme is core you cannot edit the files. If you wish to edit the theme simply make a clone and edit the files of the clone.<br /> The cloned theme will be automatically marked as default. Click Clone button to create a clone of this theme.','1','1329173545MEGR'),('Clone of $FOLDER theme','1','1329173546QVQL'),('PHP files','1','1344051185BJJR'),('CSS files','1','1344051185BJJS'),('js files','1','1344051185BJJT'),('Theme Show File','1','1347397381CQOQ'),('Divivder','1','1360193291CNEA'),('Mobile','1','1382364838SGIL'),('column1','1','1394069593IQAS'),('column2','1','1394069593IQAT'),('The theme could not be found.','1','1395437861EIXK'),('Theme Information','1','1395886787SVIL'),('Font Awesome','1','1395886787SVIM'),('General Design','1','1395886787SVIN'),('Image Style','1','1395886787SVIO'),('Responsive Image','1','1395886787SVIP'),('Navigation Bar','1','1395886787SVIQ'),('Show Logo','1','1395886787SVIR'),('Brand','1','1395886787SVIS'),('Logo Name','1','1395886787SVIT'),('Use Colored Wizard','1','1395886787SVIU'),('Show View Icon','1','1395886787SVIV'),('Panes and Tabs','1','1395886787SVIW'),('Show Pane Icon','1','1395886787SVIX'),('Use Pane Color','1','1395886787SVIY'),('Form Direction','1','1395886787SVIZ'),('Use Fade Effects','1','1395886787SVJA'),('Use Color','1','1395886787SVJB'),('Default Color','1','1395886787SVJC'),('Show Icon','1','1395886787SVJD'),('Icon Position','1','1395886787SVJE'),('Icon Size','1','1395886787SVJF'),('Show Colored Icons','1','1395886787SVJG'),('Table & Listing','1','1395886787SVJI'),('Use Striped Table','1','1395886787SVJJ'),('Use Border','1','1395886787SVJK'),('Enable Hover','1','1395886787SVJL'),('Use Condensed Table','1','1395886787SVJM'),('Max. Number per Listing','1','1395886787SVJN'),('Use Button Icon','1','1395886787SVJO'),('Catalog Container','1','1395886787SVJQ'),('Social Icons','1','1395886787SVJT'),('Use Text','1','1395886787SVJU'),('Show Count','1','1395886787SVJV'),('Color','1','1395886787SVJW'),('Favorite Icon Color','1','1395886787SVJX'),('Wish Icon Color','1','1395886787SVJY'),('Watch Icon Color','1','1395886787SVJZ'),('Like Color Icon','1','1395886787SVKA'),('Dislike Icon Color','1','1395886787SVKB'),('Views Icon Color','1','1395886787SVKC'),('Share Icon Color','1','1395886787SVKD'),('Print Icon Color','1','1395886787SVKE'),('Alerts','1','1395886787SVKF'),('Use Collapsible Alert Box','1','1395886787SVKG'),('Allow Alert Dismiss','1','1395886787SVKH'),('Standalone Buttons','1','1395886787SVKI'),('Use Button Color','1','1395886787SVKJ'),('Default Button Color','1','1395886787SVKK'),('Define to use font awesome or not.<br>','1','1395886787SVKM'),('Define an image style e.g rounded, circle, etc.<br>','1','1395886787SVKN'),('Define to use responsive image or not.<br>','1','1395886787SVKO'),('Define to show a logo or not.<br>Select <font color=\"#009900\">Yes</font> to use an icon. <br>Select <font color=\"#CC0000\">No</font> to use a text.<br>','1','1395886787SVKP'),('Define the name to use instead  of a logo.<br>','1','1395886787SVKQ'),('Define the logo name.<br>','1','1395886787SVKR'),('Define to use  colored wizard or not.<br>','1','1395886787SVKS'),('Define to show an icon for the View header.<br>','1','1395886787SVKT'),('Define to show an icon in the pane and tabs.<br>','1','1395886787SVKU'),('Define to use colored panes and tabs.<br>','1','1395886787SVKV'),('Define the form direction e.g. horizontal, inline, etc.','1','1395886787SVKW'),('Define to use fading effects in the tabs.<br>','1','1395886787SVKX'),('Define to group the buttons or not.<br>','1','1395886787SVKY'),('Define to use colored buttons or not<br>','1','1395886787SVKZ'),('The default color of the buttons.<br>','1','1395886787SVLA'),('Define to show an icon with the text or not.<br>','1','1395886787SVLB'),('Define the position of the icon.<br>','1','1395886787SVLC'),('Define the size of the icon.<br>','1','1395886787SVLD'),('Define to show colored icons or not.<br>','1','1395886787SVLE'),('Define to use striped rows to add zebra-striping to any table row.<br>','1','1395886788KYRS'),('Define to use borders on all sides  of the table and cells.<br>','1','1395886788KYRT'),('Define to enable a hover state on table rows or not.<br>','1','1395886788KYRU'),('Define to use condensed table to make tables more compact by cutting cell padding in half.<br>','1','1395886788KYRV'),('Define the maximum number per table listing.<br>','1','1395886788KYRW'),('Define to show colored icons or not within the table listing e.g publish, edit, delete icons.<br>','1','1395886788KYRZ'),('Define the icon for the add to cart button.<br>','1','1395886788KYSA'),('Define the color of the add to cart button.<br>','1','1395886788KYSB'),('Define to use Text or or not.<br>','1','1395886788KYSC');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Define to  show count in the social icons.<br>','1','1395886788KYSD'),('Define the social icons size e.g small, medium, etc...<br>','1','1395886788KYSE'),('Define the social icons color.<br>','1','1395886788KYSF'),('Define the color of the favorite icon.<br>','1','1395886788KYSG'),('Define the color of the wish icon.<br>','1','1395886788KYSH'),('Define the color of the watch icon.<br>','1','1395886788KYSI'),('Define the color of the like icon.<br>','1','1395886788KYSJ'),('Define the color of the dislike icon.<br>','1','1395886788KYSK'),('Define the color of the views icon.<br>','1','1395886788KYSL'),('Define the color of the share icon.<br>','1','1395886788KYSM'),('Define the color of the print icon.<br>','1','1395886788KYSN'),('Define to use collapsible alert boxes.<br>','1','1395886788KYSO'),('Define to allow user to dismiss alerts.<br>','1','1395886788KYSP'),('Define to use button color or not.<br>','1','1395886788KYSQ'),('Define the default button color.<br>','1','1395886788KYSR'),('Define to show icons with the text or not.<br>','1','1395886788KYSS'),('Button Icon','1','1396394737MEVD'),('Button Color','1','1396394737MEVE'),('Button Size','1','1396394737MEVF'),('Detail Button','1','1396394737MEVH'),('Tooltips','1','1396394737MEVI'),('Review Button','1','1396394737MEVJ'),('Cart Update Button','1','1396394737MEVK'),('Previous Button','1','1396394737MEVL'),('Next Button','1','1396394737MEVM'),('Define the size of the details button.<br>','1','1396394738FVXB'),('Define the icon for the details button.<br>','1','1396394738FVXC'),('Define the  size of the details button.','1','1396394738FVXD'),('Define the color of the details button.<br>','1','1396394738FVXE'),('Define the display of the Tooltips e.g pop-over or Tooltips.<br>','1','1396394738FVXF'),('Define the placement of the Tooltips.<br>','1','1396394738FVXG'),('Define the location of the Tooltips.<br>','1','1396394738FVXH'),('Define the icon of the review button.<br>','1','1396394738FVXI'),('Define the size of the review button.<br>','1','1396394738FVXJ'),('Define the color of the review button.<br>','1','1396394738FVXK'),('Define the size of the update button in the checkout.<br>','1','1396394738FVXL'),('Define the color of the update button in the checkout.<br>','1','1396394738FVXM'),('Define the icon of the previous button e.g. \"Continue Shopping button in the checkout process\".<br>','1','1396394738FVXN'),('Define the color of the previous button e.g \"Continue Shopping button in the checkout\".<br>','1','1396394738FVXO'),('Define the size of the previous button e.g \"Continue Shopping button in the checkout\".<br>','1','1396394738FVXP'),('Define the size of the next button e.g \"Checkout button in the checkout page\".<br>','1','1396394738FVXQ'),('Define the color of the next button e.g \"Checkout button in the checkout page\".<br>','1','1396394738FVXR'),('Define the icon of the next button e.g \"Checkout button in the checkout page\".<br>','1','1396394738FVXS'),('Vendors\' Area','1','1396670883SAXN'),('Edit Theme Design','1','1396670884ALJE'),('Catalog Design','1','1396670885NPWL'),('Search Buttons','1','1396670885NPWM'),('Use Icon','1','1396670885NPWN'),('Use HTML','1','1396670885NPWO'),('Vew Map Button','1','1396670885NPWP'),('Edit Address Button','1','1396670885NPWQ'),('Ask Question Button','1','1396670885NPWS'),('View All Button','1','1396670885NPWT'),('Use CMS Breadcrumb in Catalog','1','1396670885NPWU'),('Use CMS Breadcrumb in Cart','1','1396670885NPWV'),('Define to show the icon in the navigation bar.<br>','1','1396670886HSVU'),('Define to use text button or not.<br>','1','1396670886HSVV'),('Define to use an icon in the search button or not.<br>','1','1396670886HSVW'),('Define to use a colored button or not.<br>','1','1396670886HSVX'),('Define to use HTML or not in the tooltip.<br>','1','1396670886HSVY'),('Define the position of the icon within a standalone button.<br>','1','1396670886HSVZ'),('Define the icon of the view map button.<br>','1','1396670886HSWA'),('Define the size of the view map button.<br>','1','1396670886HSWB'),('Define the color of the view map button.<br>','1','1396670886HSWC'),('Define the icon of the edit address button.<br>','1','1396670886HSWD'),('Define the size of the edit address button.<br>','1','1396670886HSWE'),('Define the color of the edit address button.<br>','1','1396670886HSWF'),('Define the size of the ask question button.<br>','1','1396670886HSWG'),('Define the color of the question button.<br>','1','1396670886HSWH'),('Define the size of the view all button.<br>','1','1396670886HSWI'),('Define the icon of the view all button.<br>','1','1396670886HSWJ'),('Define the color of the view all button.<br>','1','1396670886HSWK'),('Define to use Joomla breadcrumb in the catalog or not.<br>','1','1396670886HSWL'),('Define to use Joomla breadcrumb in the cart or not.<br>','1','1396670886HSWM'),('<span style=\"text-decoration: underline;\">Themes Tab</span>: for the list of main files of the theme.<br><span style=\"text-decoration: underline;\">Custom Views Tab</span>: list thef files for the custom views of the theme.<br><span style=\"text-decoration: underline;\">Stylesheets Tab</span>: for the list of css files of the theme.<br><span style=\"text-decoration: underline;\">Javascripts Tab</span>: for the list of js files of the theme.<br><br><span style=\"text-decoration: underline; font-weight: bold; color: rgb(255, 102, 0);\">Hint:</span><br><span style=\"font-weight: bold;\">What is the difference between the .css file and the .uncompressed.css file?</span><br style=\"font-weight: bold;\"><br>The uncompressed file is the original file with readable return to the line and spacing. The compress file is optimized for loading speed.<br>If you want to edit a lot of css it is probably more convenient to first copy the uncompressed.css file to the .css file in order to easily find the proper CSS.<br><br><br><span style=\"color: rgb(0, 0, 204);\"><span style=\"text-decoration: underline;\">Note</span>: If the theme is \"Core\" you cannot edit the files. If you wish to edit the theme simply make a clone and edit the files of the clone. The cloned theme will be automatically marked as default.  Click Clone button to create a clone of this theme</span><span style=\"color: rgb(255, 0, 0);\"><span style=\"color: rgb(0, 0, 204);\">.</span><br></span><span style=\"color: rgb(255, 0, 0);\">This procedure enables to keep the original untouched and avoid your customization to be overwritten at update.</span><br><br>Click the filename to edit a file.<span style=\"color: rgb(255, 0, 0);\"></span>','1','1396670886HSWN'),('Column Icons Colored','1','1397142434IGLD'),('Define to use colored icons or not for the control icons in the columns ( eg: publish, edit, etc... ).<br>','1','1397142435SAFZ'),('Vendor Register Button','1','1397671863NNJA'),('Define the size of the vendor register button.','1','1397671864NQDV'),('Define the color of the vendor register button.','1','1397671864NQDW'),('Define the icon of the vendor register button.','1','1397671864NQDX'),('Add to Cart Button in Listing','1','1397783154DRZE'),('Add to Cart Button in Item Page','1','1397783155AUTG'),('Define the size of the add to cart button in the listing page.<br>','1','1397783156CAWV'),('Define the color of the add to cart button in the item listing.<br>','1','1397783156CAWW'),('Define the icon of the add to cart button in the item page.<br>','1','1397783156CAWX'),('Carousel Navigation Button','1','1397784635QHPJ'),('Define the color of the carousel arrows buttons.<br>','1','1397784636NFCW'),('Star Icon','1','1397875863SIJY'),('Star Size','1','1397875863SIJZ'),('Define the size of the star icon.<br>','1','1397875864HNPT'),('Define the color of the star icon.<br>','1','1397875864HNPU'),('Group Icons','1','1398174984KSWN'),('Yes to group the icons together in one bar. Otherwise each icon are separated by a space.<br>','1','1398174985PICN'),('Define the position of the icon in the button.<br>','1','1398196675ECCG'),('Identifier','1','1398436917DTKC'),('Skin','1','1399505622LUTN'),('Choose a skin for the theme.<br>','1','1399505625PJLS'),('Vendors\' custom','1','1399595651JURP'),('Remove Bootstrap file','1','1399988028FPZA'),('Click Yes to NOT add the bootstrap CSS file.<br><div>Use this option to use the bootstrap file from the CMS template.</div><div>If you click Yes the Skin preference cannot be use any more.</div>','1','1399988029JPTN');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Remove legend','1','1400256255AHCT'),('If yes the legend at the bottom of the page will be removed.','1','1400256256TGRK'),('Twitter Icon Color','1','1402436712SWTH'),('Google Icon Color','1','1402436712SWTI'),('Facebook Icon Color','1','1402436712SWTJ'),('Define the color of the Twitter icon.<br>','1','1402436713RMMP'),('Define the color of the Google icon.<br>','1','1402436713RMMQ'),('Define the color of the Facebook icon.<br>','1','1402436713RMMR'),('Tooltip Style','1','1415377877PTRF'),('Define the position and style of the tooltip','1','1415377877PTRG'),('Public Site','1','1416822016EIWM'),('Admin Panel','1','1416822016EIWN'),('An occured while uploading the file.<br /> Please try to upload again','1','1417812852DFNC'),('The file $FILENAME could not be found!','1','1420549276ICAG'),('<p>Enter the destination folder of the files of the theme that you want to copy.<br />\r\nThe folder name should not have whitespaces and special characters like (, ),  !, @, #, $, % ,^, &, and *. Click Ok to submit.<br />\r\n<br />\r\n<span style=\"color:rgb(0, 0, 0)\">Kindly do not leave the input box empty.</span><br />\r\n<span style=\"color:rgb(0, 0, 0)\">Make sure also that the folder name is unique.</span></p>','1','1420549280BNHL');
SET @ctid_26 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IK_theme_node_type_publish_core_premium' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_theme_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (@ctid_26,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451type' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_theme_node_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451namekey' LIMIT 1)),(@ctid_26,'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451publish' LIMIT 1)),(@ctid_26,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451premium' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_themetrans_tmid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559tmid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_themetrans_tmid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559lgid' LIMIT 1)),(@ctid_26,'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451core' LIMIT 1));
SET @pk_77_10349 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'559tmid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10341 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.languages\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'559lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10428 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'451wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11005 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.files\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'filid451\' LIMIT 1' LIMIT 1 );
SET @pk_77_11337 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'role.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid451\' LIMIT 1' LIMIT 1 );
SET @pk_77_11338 = ( 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`=\'uid451\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('tmid','1','FK_theme_trans_tmid',@pk_77_10349,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559tmid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1),'3','3','tmid',@dbtid_1,@dbtid_2,'99');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('lgid','1','FK_theme_trans_lgid',@pk_77_10341,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_2,'99'),('wid','1','FK_theme_wid',@pk_77_10428,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),@dbtid_1,'2'),('filid','1','theme_joobi_files_filid',@pk_77_11005,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid451' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1),'1','1','filid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),@dbtid_1,'1'),('rolid','1','FK_theme_node_rolid',@pk_77_11337,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid451' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','rolid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1),@dbtid_1,'99'),('uid','1','FK_theme_node_uid',@pk_77_11338,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid451' 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,'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_3,'2','1206732361LXFE');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_3,'1','1206732372QTKK'),(@wid_3,'1','1206732372QTKL'),(@wid_3,'1','1206732400OWZW'),(@wid_3,'1','1206732400OXBR'),(@wid_3,'1','1206732425HINT'),(@wid_3,'1','1206961869IGNP'),(@wid_3,'1','1206961936HCWP'),(@wid_3,'1','1211811587EZNL'),(@wid_3,'1','1251697929ABZD'),(@wid_3,'0','1298294183ETWL'),(@wid_3,'0','1298350435GKOB'),(@wid_3,'0','1298350435GKOC'),(@wid_3,'0','1307005978SBLO'),(@wid_3,'0','1307012876GLGV'),(@wid_3,'0','1309502072SWIE'),(@wid_3,'0','1316671955LOQA'),(@wid_3,'0','1329173545MEGR'),(@wid_3,'1','1329173546QVQL'),(@wid_3,'1','1382364838SGIL'),(@wid_3,'0','1395437861EIXK'),(@wid_3,'1','1396670883SAXN'),(@wid_3,'1','1399505622LUTN'),(@wid_3,'1','1399595651JURP'),(@wid_3,'1','1416822016EIWM'),(@wid_3,'1','1416822016EIWN'),(@wid_3,'0','1417812852DFNC'),(@wid_3,'0','1420549276ICAG');
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_3,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_3,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='559name' LIMIT 1)),(@wid_3,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='theme' LIMIT 1),'1207306697RNME',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1)),(@wid_3,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='themetrans' LIMIT 1),'1207306697RNME',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1));