/*Export of the extension space.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1302502965PLCE','1207306697RNME','1206732392OZVB','1206961870KLBH','1290671797RLBN','1211811583DBTA','1398436917DTKC','1206732392OZVG','1406380323COMN','1406380323COMO','1382669590HPPR','1206961869IGND','1206961882TDGU','1298350843FMVJ','1298350843FMVK','1407204294PFVN','1406645435GXII','1406645435GXIJ','1406380324OJRJ','1405996495DAGY','1405996495DAGZ','1405996495DAHA','1406380324OJRK','1304525968YBL','1407204295NQVC','1406380323COMP','1206732361LXFD','1206732361LXFE','1206732372QTKK','1206732372QTKL','1242282449PIPC','1206732399EINB','1206732393CXVV','1206732399EINF','1206961882TDHA','1206732391QBUR','1206732392OZUP','1206732392OZVA','1206732412DAEO','1206732392OZVD','1206732372QTKN','1206732400OWXG','1206961869IGNE','1206732411EGRV','1207411373HFUG','1206961850KLRQ','1406380323COMM','1302502965PLCD','1215507804KDXX','1243392689POMD','1406380324OJRL','1406380324OJRM','1406386530JNJV','1207309450NODG','1249442401TITY','1406380323COMG','1406380323COMH','1406380323COMI','1406380323COMJ','1396671424DMOP','1406380323COMK','1242282448EVJO','1242282449PIOD','1406380323COML','1206732372QTKI','1206732372QTKJ','1359430278ARKP','1407204294PFVM' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('space.node','space.trans','space.theme') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('space.node','space.trans','space.theme','layout.node','members.node','joobi.languages','theme.node','role.node','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','dropset.valuestrans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('2yid','2wizard','2wid','2type','2publish','2params','2namekey','2modified','2menu','2frontend','2created','2level','2subtype','2dropdown','2pagination','2filters','232uid','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','232html','2private','232registered','199name','199main','199publish','199real','451tmid','451type','451namekey','451publish','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','2core','2sid','232login','2form','2icon','199rtl','451premium','541vid','541name','541lgid','451core','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','2tmid','2rolid','566type','2alias','451wid','451alias','199availadmin','199availsite','618sid','618lgid','618name','199locale','566depth','199localeconv','visibility232','677wsid','namekey677','alias677','type677','rolid677','publish677','tmid677','yid677','core677','678wsid','678lgid','name678','description678','adminid677','catid677','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto541','fromlgid541','auto618','fromlgid618','auto678','fromlgid678','auto714','fromlgid714','curid232','filid451','created451','modified451','availability451','folder451','j16566','params451','ip232','ctyid232','fields2','parent2','reload2','core199','widgets2','mobile232','faicon2','rolid451','uid451','ordering451','filid232','create677','modified677','theme677','controller677','restrictuser677','3429wsid','3429size','3429device','tmid3429','frameworktheme677','automatic199','useredit2','message485','parentkey2','framework451','custom2') 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 ('rolid677','tmid677','yid677','678wsid','678lgid','adminid677','tmid3429') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_space_trans_lgid','FK_space_trans_wsid','FK_space_node_adminid','FK_space_node_rolid','FK_space_theme_tmid','FK_space_node_tmid','FK_space_node_yid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('space.node') ;
SET @rolid_0 = (1);
SET @pk_549_677 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.node' LIMIT 1 );
SET @pk_549_678 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.trans' LIMIT 1 );
SET @pk_549_3429 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.theme' LIMIT 1 );
SET @pk_549_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.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_451 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' 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_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_679 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.extension' LIMIT 1 );
SET @pk_549_680 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.members' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_657 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' 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 ('space_node','space.node',@pk_549_677,'','',@rolid_0,'0','1','wsid','node','space','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 ('space_trans','space.trans',@pk_549_678,'','',@rolid_0,'0','20','wsid,lgid','trans','space','51','2','0','0','7'),('space_theme','space.theme',@pk_549_3429,'','',@rolid_0,'0','1','wsid,size,device','','','51','2','0','0','7'),('layout_node','layout.node',@pk_549_2,'','1.0.0',@rolid_0,'0','1','yid','node','layout','9','0','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'),('theme_node','theme.node',@pk_549_451,'','1.0.0',@rolid_0,'0','1','tmid','node','theme','51','0','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'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','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'),('space_extension','space.extension',@pk_549_679,'','',@rolid_0,'0','30','wsid,wid','extension','space','51','2','0','0','7'),('space_members','space.members',@pk_549_680,'','',@rolid_0,'0','30','wsid,uid','members','space','51','2','0','0','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('extension_userinfos','extension.userinfos',@pk_549_657,'','',@rolid_0,'0','30','wid,level','userinfos','extension','51','2','0','0','7'),('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`='space.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.trans' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.theme' LIMIT 1);
SET @pk_454_65591 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_space_node' LIMIT 1 );
SET @pk_454_65592 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_space_node' LIMIT 1 );
SET @pk_454_65593 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_space_trans' LIMIT 1 );
SET @pk_454_66204 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_space_theme|main_userdata' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65591,'3','PK_space_node',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65592,'1','UK_namekey_space_node',@dbtid_1),(@pk_454_65593,'3','PK_space_trans',@dbtid_2),(@pk_454_66204,'3','PK_jos_space_theme|main_userdata',@dbtid_3);
SET @pk_616_6560 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='677wsid' LIMIT 1 );
SET @pk_616_6561 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey677' LIMIT 1 );
SET @pk_616_6569 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678wsid' LIMIT 1 );
SET @pk_616_6570 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678lgid' LIMIT 1 );
SET @pk_616_10654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429wsid' LIMIT 1 );
SET @pk_616_10655 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429size' LIMIT 1 );
SET @pk_616_10656 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429device' LIMIT 1 );
SET @pk_616_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1 );
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_3037 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_6564 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid677' LIMIT 1 );
SET @pk_616_6566 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tmid677' LIMIT 1 );
SET @pk_616_6567 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='yid677' LIMIT 1 );
SET @pk_616_6576 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='adminid677' LIMIT 1 );
SET @pk_616_10657 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tmid3429' LIMIT 1 );
SET @pk_616_6562 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias677' LIMIT 1 );
SET @pk_616_6563 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type677' LIMIT 1 );
SET @pk_616_6565 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish677' LIMIT 1 );
SET @pk_616_6568 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core677' LIMIT 1 );
SET @pk_616_6571 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name678' LIMIT 1 );
SET @pk_616_6572 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description678' LIMIT 1 );
SET @pk_616_6577 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='catid677' LIMIT 1 );
SET @pk_616_6882 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto678' LIMIT 1 );
SET @pk_616_6883 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid678' LIMIT 1 );
SET @pk_616_10602 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='create677' LIMIT 1 );
SET @pk_616_10603 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified677' LIMIT 1 );
SET @pk_616_10606 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='theme677' LIMIT 1 );
SET @pk_616_10607 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='controller677' LIMIT 1 );
SET @pk_616_10611 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='restrictuser677' LIMIT 1 );
SET @pk_616_10658 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='frameworktheme677' 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_6560,@dbtid_1,'wsid','1','0','2','1','1','0','1','0','0','1','0','1','677wsid','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_6561,@dbtid_1,'namekey','0','1','14','0','1','','2','0','0','0','50','1','namekey677','1','0','0'),(@pk_616_6569,@dbtid_2,'wsid','1','0','4','1','1','','1','0','0','0','0','1','678wsid','1','0','0'),(@pk_616_6570,@dbtid_2,'lgid','1','0','1','1','1','','2','0','0','0','4','1','678lgid','1','0','0'),(@pk_616_10654,@dbtid_3,'wsid','1','0','2','1','1','0','1','0','0','0','0','1','3429wsid','1','0','0'),(@pk_616_10655,@dbtid_3,'size','1','0','1','1','1','0','2','0','0','0','0','1','3429size','1','0','0'),(@pk_616_10656,@dbtid_3,'device','1','0','1','1','1','0','3','0','0','0','0','1','3429device','1','0','0'),(@pk_616_21,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1),'yid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','2yid','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_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_3037,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1),'tmid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','451tmid','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_6564,@dbtid_1,'rolid','0','0','2','1','1','1','5','0','0','0','0','1','rolid677','1','0','0'),(@pk_616_6566,@dbtid_1,'tmid','0','0','2','1','1','0','3','0','0','0','0','1','tmid677','1','0','0'),(@pk_616_6567,@dbtid_1,'menu','0','0','14','1','1','','4','0','0','0','100','1','yid677','1','0','0'),(@pk_616_6576,@dbtid_1,'uid','0','1','4','1','1','0','6','0','0','0','0','1','adminid677','1','0','0'),(@pk_616_10657,@dbtid_3,'tmid','0','1','3','1','1','0','4','0','0','0','0','1','tmid3429','1','0','0'),(@pk_616_6562,@dbtid_1,'alias','0','1','14','0','1','','8','0','0','0','150','1','alias677','1','0','0'),(@pk_616_6563,@dbtid_1,'type','0','1','1','1','1','0','9','0','0','0','0','1','type677','1','0','0'),(@pk_616_6565,@dbtid_1,'publish','0','0','1','0','1','1','10','0','0','0','0','1','publish677','1','0','0'),(@pk_616_6568,@dbtid_1,'core','0','0','25','0','1','','11','0','0','0','0','1','core677','1','0','0'),(@pk_616_6571,@dbtid_2,'name','0','1','14','0','1','','3','0','0','0','255','1','name678','1','0','0'),(@pk_616_6572,@dbtid_2,'description','0','1','16','0','1','','4','0','0','0','0','1','description678','1','0','0'),(@pk_616_6577,@dbtid_1,'catid','0','1','3','1','1','0','7','0','0','0','0','1','catid677','1','0','0'),(@pk_616_6882,@dbtid_2,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto678','1','0','0'),(@pk_616_6883,@dbtid_2,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid678','1','0','0'),(@pk_616_10602,@dbtid_1,'created','0','1','4','1','1','0','12','0','0','0','0','1','create677','1','0','0'),(@pk_616_10603,@dbtid_1,'modified','0','1','4','1','1','0','13','0','0','0','0','1','modified677','1','1','0'),(@pk_616_10606,@dbtid_1,'theme','0','1','14','0','1','','14','0','0','0','50','1','theme677','1','0','0'),(@pk_616_10607,@dbtid_1,'controller','0','1','14','0','1','','15','0','0','0','150','1','controller677','1','0','0'),(@pk_616_10611,@dbtid_1,'restrictuser','0','1','25','0','1','0','16','0','0','0','0','1','restrictuser677','1','0','0'),(@pk_616_10658,@dbtid_1,'frameworktheme','0','1','25','0','1','0','17','0','0','0','0','1','frameworktheme677','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_742 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='space.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='space',`wid`=@pk_5_742,`params`='',`status`='1',`type`='150',`name`='Space',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='space.node',`version`='898',`lversion`='898',`pref`='0',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='space.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','space',@pk_5_742,'','1','150','Space','node','0','1','0','space.node','898','898','0','','1','1','0');

SET @pk_621_673 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space' LIMIT 1 );
SET @pk_621_674 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='spacetrans' LIMIT 1 );
SET @pk_621_1329 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space.theme' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_675 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space.extension' LIMIT 1 );
SET @pk_621_676 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space.members' LIMIT 1 );
SET @pk_621_648 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension.userinfos' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_673,`dbtid`=@dbtid_1,`path`='0',`namekey`='space',`folder`='space',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='space',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-codepen',`pnamekey`='' WHERE  `namekey`='space';
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_673,@dbtid_1,'0','space','space',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','space','0','0','1','fa-codepen','');
UPDATE `#__model_node`  SET `sid`=@pk_621_674,`dbtid`=@dbtid_2,`path`='0',`namekey`='spacetrans',`folder`='spacetrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=space\nautofld=1',`alias`='',`prefix`='space',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-codepen',`pnamekey`='' WHERE  `namekey`='spacetrans';
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_674,@dbtid_2,'0','spacetrans','spacetrans',@rolid_0,'0','1','0','0','mainmodel=space\nautofld=1','','space','0','0','1','fa-codepen','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1329,`dbtid`=@dbtid_3,`path`='0',`namekey`='space.theme',`folder`='space.theme',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='space',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='space.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_1329,@dbtid_3,'0','space.theme','space.theme',@rolid_0,'0','1','0','0','autofld=1','','space','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
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_5,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');
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','');
UPDATE `#__model_node`  SET `sid`=@pk_621_675,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.extension' LIMIT 1),`path`='0',`namekey`='space.extension',`folder`='space',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='space',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='space.extension';
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_675,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.extension' LIMIT 1),'0','space.extension','space',@rolid_0,'0','1','0','0','autofld=1','','space','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_676,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.members' LIMIT 1),`path`='0',`namekey`='space.members',`folder`='space',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='space',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='space.members';
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_676,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='space.members' LIMIT 1),'0','space.members','space',@rolid_0,'0','1','0','0','autofld=1','','space','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_648,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' LIMIT 1),`path`='0',`namekey`='extension.userinfos',`folder`='extension.userinfos',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='extension.userinfos';
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_648,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.userinfos' LIMIT 1),'0','extension.userinfos','extension.userinfos',@rolid_0,'0','1','0','0','','','extension','0','0','1','','');

SET @wid_4 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='space.node' LIMIT 1);
SET @sid_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space' LIMIT 1);
SET @sid_6 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space.theme' LIMIT 1);
SET @sid_7 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @sid_8 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1);
SET @rolid_9 = (7);
SET @rolid_10 = (9);
SET @rolid_11 = (8);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_form' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_form_theme' LIMIT 1);
SET @did_14 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='space_device_type' LIMIT 1);
SET @did_15 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='space_display_size' LIMIT 1);
SET @sid_16 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='spacetrans' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='space_form_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('space_form_spacetrans_name','space_form_space_namekey','space_form_space_theme','space_form_space_yid','space_form_space_adminid','space_form_space_frameworktheme') LIMIT 6;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='space_form_column_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('space_form_space_alias','space_form_spacetrans_description','space_form_space_restrictuser') LIMIT 3;
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_listing' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_members_assign' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_applications_assign' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='space_listing_theme' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='space_listing_spacetrans_name_2' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('space_listing_spacetrans_name','space_listing_space_namekey','space_listing_space_alias','space_listing_spacetrans_description') LIMIT 4;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE'),('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Publish','1','1206732372QTKN'),('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'),('Username','1','1206732411EGRV'),('Access','1','1206732412DAEO'),('URL','1','1206961850KLRQ'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Menu','1','1206961870KLBH'),('Message','1','1206961882TDGU'),('Back','1','1206961882TDHA'),('Theme','1','1207306697RNME'),('Assign members to a project','1','1207309450NODG'),('Assigned','1','1207411373HFUG'),('Alias','1','1211811583DBTA'),('Assign Members','1','1215507804KDXX'),('Any','1','1242282448EVJO'),('Browser','1','1242282449PIOD'),('Done','1','1242282449PIPC'),('Assign Applications','1','1243392689POMD'),('Use this view to assign members to a project by clicking on the column Assigned.<br>The status will change from No to Yes or vise versa.','1','1249442401TITY'),('Default URL','1','1290671797RLBN'),('Column 1','1','1298350843FMVJ'),('Column 2','1','1298350843FMVK'),('Spaces','1','1302502965PLCD'),('Space','1','1302502965PLCE'),('','1','1304525968YBL'),('Choose a theme','1','1359430278ARKP'),('Device','1','1382669590HPPR'),('Large','1','1396671424DMOP'),('Identifier','1','1398436917DTKC'),('The alias is used in for the administrator to identify the space.&nbsp;Make it explicit and easy to search with specific key words.','1','1405996495DAGY'),('This identifier is used to acces the space.<br>It will might appear in the URL. So make it short but explicit.','1','1405996495DAGZ'),('Specify a description for the space.','1','1405996495DAHA'),('Any size ( Auto )','1','1406380323COMG'),('Extra small ( Phone )','1','1406380323COMH'),('Small ( Tablet )','1','1406380323COMI'),('Medium ( Desktop )','1','1406380323COMJ'),('Mobile App','1','1406380323COMK'),('Desktop App','1','1406380323COML'),('Display Size','1','1406380323COMM'),('Restrict Users','1','1406380323COMN'),('Display size','1','1406380323COMO'),('The default theme for this space','1','1406380323COMP'),('Specify the default URL.<div>eg: controller=vendors</div>','1','1406380324OJRJ'),('Yes to restrict the access to this space for specific users.','1','1406380324OJRK'),('Space\'s Themes','1','1406380324OJRL'),('Space theme','1','1406380324OJRM'),('Not Valid API Key','1','1406386530JNJV'),('Name of the space displayed to the users.','1','1406645435GXII'),('The default menu for that space','1','1406645435GXIJ'),('Space defined as Core cannot be edited!','1','1407204294PFVM'),('Use Framework Theme','1','1407204294PFVN'),('yes to use the framework theme to wrap the application theme.','1','1407204295NQVC');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_space_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='677wsid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_space_node' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey677' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_space_trans' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678wsid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_space_trans' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_space_theme|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429wsid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_space_theme|main_userdata' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429size' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_space_theme|main_userdata' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3429device' LIMIT 1));
SET @pk_77_10654 = ( 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`=\'rolid677\' LIMIT 1' LIMIT 1 );
SET @pk_77_10655 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'theme.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'tmid677\' LIMIT 1' LIMIT 1 );
SET @pk_77_10656 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'yid677\' LIMIT 1' LIMIT 1 );
SET @pk_77_10657 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'678wsid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10658 = ( 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`=\'678lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10661 = ( 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`=\'adminid677\' LIMIT 1' LIMIT 1 );
SET @pk_77_11429 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'theme.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'tmid3429\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('rolid','1','FK_space_node_rolid',@pk_77_10654,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid677' 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,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('tmid','0','FK_space_node_tmid',@pk_77_10655,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tmid677' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1),'1','1','tmid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1),@dbtid_1,'2'),('yid','1','FK_space_node_yid',@pk_77_10656,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='yid677' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1),'1','1','yid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1),@dbtid_1,'3'),('wsid','1','FK_space_trans_wsid',@pk_77_10657,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678wsid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='677wsid' LIMIT 1),'3','3','wsid',@dbtid_1,@dbtid_2,'1'),('lgid','1','FK_space_trans_lgid',@pk_77_10658,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='678lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'3','3','lgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_2,'2'),('adminid','1','FK_space_node_adminid',@pk_77_10661,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='adminid677' 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,'4'),('tmid','1','FK_space_theme_tmid',@pk_77_11429,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tmid3429' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='451tmid' LIMIT 1),'3','3','tmid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='theme.node' LIMIT 1),@dbtid_3,'1');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_4,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_4,'2','1206732372QTKJ'),(@wid_4,'1','1359430278ARKP'),(@wid_4,'0','1407204294PFVM');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_4),'','','','','','','','','','','0','');
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_4,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description678' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_4,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name678' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space' LIMIT 1),'1302502965PLCE',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='spacetrans' LIMIT 1),'1302502965PLCE',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1)),(@wid_4,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='space.theme' LIMIT 1),'1207306697RNME',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1));