/*Export of the extension mailbox.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1241989377TGDL','1241989381TANV','1206961882TDGU','1254227305KKYZ','1251697925DNIM','1254227305KKZB','1206732392OZVB','1206732392OZVG','1241989377TGEG','1206732411EGRV','1206732412DADP','1241989377TGEH','1241989377TGEI','1241989377TGEJ','1207306697RNMA','1219769904NDJH','1206732372QTKL','1241989377TGEK','1241989377TGEL','1241989377TGEM','1241989377TGEN','1206732400OXCG','1206732412DAGD','1206961869IGNC','1241989377TGEO','1241989377TGEP','1241989377TGEQ','1242580112DTJY','1206732400OWZX','1244722788BFSH','1251697924MLJO','1251697924MLJP','1251697924MLJQ','1206732392OZVD','1206732372QTKN','1256863993QDJG','1256863993QDJH','1241989760RVBL','1241989760RVBM','1241989760RVBN','1242580122OOGU','1217251965LDTZ','1241989760RVBP','1241989760RVBQ','1241989760RVBR','1241989760RVBS','1242580122OOGV','1241989377TGDM','1241989377TGDN','1241989377TGDO','1241989377TGDP','1241989377TGDQ','1241989377TGDR','1241989377TGDS','1241989377TGDT','1241989377TGDU','1304525968YBL','1241989377TGDV','1241989377TGDW','1234467594BCKE','1241989377TGDX','1241989377TGDY','1241989377TGDZ','1241989377TGEA','1241989377TGEB','1241989377TGEC','1241989377TGED','1241989377TGEE','1241989377TGEF','1242580112DTJX','1244722787NNCA','1251697924MLJL','1251697924MLJM','1251697924MLJN','1257414617RUXN','1256863992BRRE','1260253911PVFX','1241989760RVBE','1241989760RVBF','1241989760RVBG','1241989760RVBH','1241989760RVBI','1241989760RVBJ','1241989760RVBK','1242580122OOGT','1206732361LXFD','1206732361LXFE','1206732391QBUR','1206732399EINF','1206732393CXVV','1206732399EINB','1242282449PIPC','1218203992KUZO','1206961898PIOC','1241989381TANY','1251697925DNIL','1206961869IGNE','1206961882TDHA','1206732392OZUP','1206732372QTKM','1251697925DNIJ','1251697925DNIK','1206732392OZVA','1206732400OWXG','1206732392OZUO','1206732421RJQW','1207242081BUBK','1206732392OZUQ','1241989377TGER','1206961850KLRI','1211811588SCXI','1206732411EGRU','1241989381TANW','1241989381TANX','1206961912MJPF','1206961869IGND','1254227306FJFO','1206961869IGNP','1263527488PFLQ','1263527488PFLR','1263527488PFLS','1251697924MLJR','1212516267RPGN','1251697924MLJS','1251697924MLJT','1251697924MLJU','1251697924MLJV','1251697924MLJW','1251697924MLJX','1251697924MLJY','1256863993QDJI','1241989377TGES','1251697930IGYM','1251697930IGYN','1206732411EGRQ','1307526847SFJZ','1249453427FZXK','1206732375LZCI','1251697925DNIN','1206732375LZCH','1263527489DDRU','1263527489DDRV','1267609148IZGA','1211811609TEZV','1241989381TAOJ','1253693139FSTT','1242580112DTJZ','1241989377TGEV','1275727319CCUI','1241989381TAOF','1251697925DNIO','1241989381TAOH','1241989377TGEX','1275727304KGSY','1251697925DNIQ','1260253912CIOM','1241989377TGEW','1275727304KGSZ','1275727304KGTA','1241989760RVBU','1251697926LPNL','1251697926LPNN','1251697926LPNO','1251697926LPNG','1251697926LPNI','1251697926LPNJ','1220793699CLWU','1206732372QTKI','1206732372QTKJ','1236791959FTZU','1241989374PAXK','1241989376CCKB','1241989376CCKC','1241989381TANT','1242580111TAIP','1242580111TAIQ','1242580111TAIS','1242580111TAIT','1254227304QDMN','1254392738GVKF','1254392738GVKG','1254392738GVKH','1258010751GXJB','1260253904QSSO','1260253904QSSP','1327442997GDYF','1327442997GDYG','1389656700JZFI','1418159587ECXG','1418159587ECXH','1418159587ECXI','1418159587ECXJ','1418159587ECXK','1418159587ECXL','1418159587ECXM','1418159587ECXN','1418159587ECXO','1418159587ECXP','1418159587ECXQ','1418159587ECXR','1433086401BPBR' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('mailbox.node','mailbox.emanager','mailbox.messages','mailbox.handled','rule.node','rule.condition','rule.dictionary') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('mailbox.node','mailbox.emanager','mailbox.messages','mailbox.handled','rule.node','rule.condition','rule.dictionary','extension.node','members.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','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','232html','232registered','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','5parent','5trans','484description','5certify','5namekey','232login','5version','5lversion','5pref','481wname','481wdescription','232rolid','5rolid','5install','618sid','618lgid','618name','ordering5','core5','visibility232','modified5','681inbid','password681','server681','username681','addon681','description681','name681','publish681','684inbid','684emaid','ordering684','params681','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto618','fromlgid618','auto714','fromlgid714','735msgid','inbid735','email735','header735','type735','subject735','body735','created735','736email','736type','created736','modified736','number736','curid232','809ruleid','811cdtid','812dctid','cdtid809','name809','description809','type809','action809','core809','uid809','created809','modified809','publish809','private809','words812','type812','core812','searchin812','created812','modified812','publish812','subject811','fromemail811','toemail811','wordswithin811','wordsnotin811','condition811','datefrom811','dateto811','attachment811','box735','size735','ordering812','ip232','ctyid232','reload5','created5','mobile232','filid232','showconfig5','framework5','message485') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__dataset_foreign`.* FROM `#__dataset_columns` LEFT JOIN `#__dataset_foreign` ON `#__dataset_foreign`.`feid` = `#__dataset_columns`.`dbcid` WHERE `#__dataset_columns`.`namekey` IN ('684inbid','684emaid','inbid735','cdtid809','uid809') AND `#__dataset_foreign`.`namekey` NOT IN ('emanager_wid_extension','inbid','809_cdtid_811','735_inbid_681','809_uid_232') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('mailbox.node') ;
SET @rolid_0 = (1);
SET @pk_549_681 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.node' LIMIT 1 );
SET @pk_549_684 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.emanager' LIMIT 1 );
SET @pk_549_735 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.messages' LIMIT 1 );
SET @pk_549_736 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.handled' LIMIT 1 );
SET @pk_549_809 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.node' LIMIT 1 );
SET @pk_549_811 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.condition' LIMIT 1 );
SET @pk_549_812 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.dictionary' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.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_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_287 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.trans' 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 ('mailbox_node','mailbox.node',@pk_549_681,'','',@rolid_0,'0','1','inbid','node','mailbox','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 ('emanager_mailbox','mailbox.emanager',@pk_549_684,'','',@rolid_0,'0','30','inbid,wid','mailbox','emanager','51','2','0','0','7'),('mailbox_messages','mailbox.messages',@pk_549_735,'','',@rolid_0,'0','1','msgid','messages','mailbox','51','2','0','0','7'),('emanager_handled','mailbox.handled',@pk_549_736,'','',@rolid_0,'0','30','email,type','handled','emanager','51','2','0','0','7'),('rule_node','rule.node',@pk_549_809,'','',@rolid_0,'0','1','ruleid','node','rule','51','2','0','0','7'),('rule_condition','rule.condition',@pk_549_811,'','',@rolid_0,'0','1','cdtid','condition','rule','51','2','0','0','7'),('rule_dictionary','rule.dictionary',@pk_549_812,'','',@rolid_0,'0','1','dctid','dictionary','rule','51','2','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'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('extension_trans','extension.trans',@pk_549_287,'','1.0.0',@rolid_0,'0','20','wid,lgid','trans','extension','9','2','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`='mailbox.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.emanager' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.messages' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailbox.handled' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.node' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.condition' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='rule.dictionary' LIMIT 1);
SET @pk_454_65597 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_mailbox_node' LIMIT 1 );
SET @pk_454_65601 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_mailbox' LIMIT 1 );
SET @pk_454_65665 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_mailbox_messages' LIMIT 1 );
SET @pk_454_65666 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_handled' LIMIT 1 );
SET @pk_454_65712 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_node' LIMIT 1 );
SET @pk_454_65716 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_condition' LIMIT 1 );
SET @pk_454_65717 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_dictionary' LIMIT 1 );
SET @pk_454_65745 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_for_rule_dictionary' LIMIT 1 );
SET @pk_454_66135 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_mailbox_messages_inbid' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65597,'3','PK_mailbox_node',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65601,'3','PK_emanager_mailbox',@dbtid_2),(@pk_454_65665,'3','PK_mailbox_messages',@dbtid_3),(@pk_454_65666,'3','PK_emanager_handled',@dbtid_4),(@pk_454_65712,'3','PK_rule_node',@dbtid_5),(@pk_454_65716,'3','PK_rule_condition',@dbtid_6),(@pk_454_65717,'3','PK_rule_dictionary',@dbtid_7),(@pk_454_65745,'1','UK_for_rule_dictionary',@dbtid_7),(@pk_454_66135,'2','IX_mailbox_messages_inbid',@dbtid_3);
SET @pk_616_6583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='681inbid' LIMIT 1 );
SET @pk_616_6602 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684inbid' LIMIT 1 );
SET @pk_616_6603 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684emaid' LIMIT 1 );
SET @pk_616_7035 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='735msgid' LIMIT 1 );
SET @pk_616_7036 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='inbid735' LIMIT 1 );
SET @pk_616_7043 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='736email' LIMIT 1 );
SET @pk_616_7044 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='736type' LIMIT 1 );
SET @pk_616_7413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='809ruleid' LIMIT 1 );
SET @pk_616_7417 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='811cdtid' LIMIT 1 );
SET @pk_616_7418 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='812dctid' LIMIT 1 );
SET @pk_616_7432 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='words812' LIMIT 1 );
SET @pk_616_7433 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type812' LIMIT 1 );
SET @pk_616_7435 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='searchin812' 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_7421 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='cdtid809' LIMIT 1 );
SET @pk_616_7427 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid809' LIMIT 1 );
SET @pk_616_6584 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='password681' LIMIT 1 );
SET @pk_616_6585 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='server681' LIMIT 1 );
SET @pk_616_6586 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='username681' LIMIT 1 );
SET @pk_616_6587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='addon681' LIMIT 1 );
SET @pk_616_6588 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description681' LIMIT 1 );
SET @pk_616_6589 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name681' LIMIT 1 );
SET @pk_616_6590 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish681' LIMIT 1 );
SET @pk_616_6604 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering684' LIMIT 1 );
SET @pk_616_6605 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params681' LIMIT 1 );
SET @pk_616_7037 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='email735' LIMIT 1 );
SET @pk_616_7038 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='header735' LIMIT 1 );
SET @pk_616_7039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type735' LIMIT 1 );
SET @pk_616_7040 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subject735' LIMIT 1 );
SET @pk_616_7041 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='body735' LIMIT 1 );
SET @pk_616_7042 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created735' LIMIT 1 );
SET @pk_616_7045 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created736' LIMIT 1 );
SET @pk_616_7046 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified736' LIMIT 1 );
SET @pk_616_7047 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='number736' LIMIT 1 );
SET @pk_616_7422 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name809' LIMIT 1 );
SET @pk_616_7423 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description809' LIMIT 1 );
SET @pk_616_7424 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type809' LIMIT 1 );
SET @pk_616_7425 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='action809' LIMIT 1 );
SET @pk_616_7426 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core809' LIMIT 1 );
SET @pk_616_7428 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created809' LIMIT 1 );
SET @pk_616_7429 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified809' LIMIT 1 );
SET @pk_616_7430 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish809' LIMIT 1 );
SET @pk_616_7431 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='private809' LIMIT 1 );
SET @pk_616_7434 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core812' LIMIT 1 );
SET @pk_616_7436 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created812' LIMIT 1 );
SET @pk_616_7437 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified812' LIMIT 1 );
SET @pk_616_7438 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish812' LIMIT 1 );
SET @pk_616_7439 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subject811' LIMIT 1 );
SET @pk_616_7440 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromemail811' LIMIT 1 );
SET @pk_616_7441 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='toemail811' LIMIT 1 );
SET @pk_616_7442 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wordswithin811' LIMIT 1 );
SET @pk_616_7443 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wordsnotin811' LIMIT 1 );
SET @pk_616_7444 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='condition811' LIMIT 1 );
SET @pk_616_7445 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='datefrom811' LIMIT 1 );
SET @pk_616_7446 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='dateto811' LIMIT 1 );
SET @pk_616_7447 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='attachment811' LIMIT 1 );
SET @pk_616_7455 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='box735' LIMIT 1 );
SET @pk_616_7487 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='size735' LIMIT 1 );
SET @pk_616_7636 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering812' 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_6583,@dbtid_1,'inbid','1','0','2','1','1','','1','0','0','1','0','1','681inbid','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_7443,@dbtid_6,'wordsnotin','0','1','14','0','1','','6','0','0','0','254','1','wordsnotin811','1','0','0'),(@pk_616_7444,@dbtid_6,'condition','0','1','1','1','1','','7','0','0','0','0','1','condition811','1','0','0'),(@pk_616_7445,@dbtid_6,'datefrom','0','1','4','1','1','','8','0','0','0','0','1','datefrom811','1','1','0'),(@pk_616_7446,@dbtid_6,'dateto','0','1','4','1','1','','9','0','0','0','0','1','dateto811','1','1','0'),(@pk_616_7447,@dbtid_6,'attachment','0','1','1','1','1','','10','0','0','0','0','1','attachment811','1','0','0'),(@pk_616_7455,@dbtid_3,'box','0','1','1','1','1','1','9','0','0','0','0','1','box735','1','0','0'),(@pk_616_7487,@dbtid_3,'size','0','1','2','0','1','0','10','0','0','0','0','1','size735','1','0','0'),(@pk_616_7636,@dbtid_7,'ordering','0','1','2','1','1','0','9','0','0','0','0','1','ordering812','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_746 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='mailbox.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='mailbox',`wid`=@pk_5_746,`params`='',`status`='1',`type`='150',`name`='Mailbox',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='mailbox.node',`version`='1819',`lversion`='1819',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='mailbox.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','mailbox',@pk_5_746,'','1','150','Mailbox','node','0','1','0','mailbox.node','1819','1819','1','','1','1','0');

SET @pk_621_677 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox' LIMIT 1 );
SET @pk_621_680 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.email' LIMIT 1 );
SET @pk_621_773 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.handled' LIMIT 1 );
SET @pk_621_774 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.messages' LIMIT 1 );
SET @pk_621_864 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.rule' LIMIT 1 );
SET @pk_621_866 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.ruledictionary' LIMIT 1 );
SET @pk_621_867 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.rulecondition' LIMIT 1 );
SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_1004 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='appstrans' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_677,`dbtid`=@dbtid_1,`path`='1',`namekey`='mailbox',`folder`='mailbox',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='mailbox',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-inbox',`pnamekey`='' WHERE  `namekey`='mailbox';
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_677,@dbtid_1,'1','mailbox','mailbox',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','mailbox','0','0','1','fa-inbox','');
UPDATE `#__model_node`  SET `sid`=@pk_621_680,`dbtid`=@dbtid_2,`path`='0',`namekey`='mailbox.email',`folder`='mailbox.email',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=inbid\nautofld=1',`alias`='',`prefix`='',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-inbox',`pnamekey`='' WHERE  `namekey`='mailbox.email';
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_680,@dbtid_2,'0','mailbox.email','mailbox.email',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=inbid\nautofld=1','','','0','0','1','fa-inbox','');
UPDATE `#__model_node`  SET `sid`=@pk_621_773,`dbtid`=@dbtid_4,`path`='0',`namekey`='mailbox.handled',`folder`='',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='emanager',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='mailbox.handled';
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_773,@dbtid_4,'0','mailbox.handled','',@rolid_0,'0','1','0','0','autofld=1','','emanager','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_774,`dbtid`=@dbtid_3,`path`='0',`namekey`='mailbox.messages',`folder`='mailbox.messages',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='mailbox',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-envelope',`pnamekey`='' WHERE  `namekey`='mailbox.messages';
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_774,@dbtid_3,'0','mailbox.messages','mailbox.messages',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','mailbox','0','0','1','fa-envelope','');
UPDATE `#__model_node`  SET `sid`=@pk_621_864,`dbtid`=@dbtid_5,`path`='0',`namekey`='mailbox.rule',`folder`='mailbox.rule',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='rule',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='mailbox.rule';
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_864,@dbtid_5,'0','mailbox.rule','mailbox.rule',@rolid_0,'0','1','0','0','autofld=1','','rule','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_866,`dbtid`=@dbtid_7,`path`='0',`namekey`='mailbox.ruledictionary',`folder`='mailbox.ruledictionary',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=dctid\nautofld=1',`alias`='',`prefix`='rule',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='mailbox.ruledictionary';
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_866,@dbtid_7,'0','mailbox.ruledictionary','mailbox.ruledictionary',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=dctid\nautofld=1','','rule','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_867,`dbtid`=@dbtid_6,`path`='0',`namekey`='mailbox.rulecondition',`folder`='mailbox.rulecondition',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='rule',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='mailbox.rulecondition';
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_867,@dbtid_6,'0','mailbox.rulecondition','mailbox.rulecondition',@rolid_0,'0','1','0','0','autofld=1','','rule','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_999,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),`path`='0',`namekey`='apps',`folder`='apps',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='apps';
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_999,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'0','apps','apps',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','apps','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1004,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.trans' LIMIT 1),`path`='0',`namekey`='appstrans',`folder`='appstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=apps\nautofld=1',`alias`='',`prefix`='apps',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='appstrans';
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_1004,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.trans' LIMIT 1),'0','appstrans','appstrans',@rolid_0,'0','1','0','0','mainmodel=apps\nautofld=1','','apps','0','0','1','fa-mobile','');

SET @wid_8 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='mailbox.node' LIMIT 1);
SET @sid_9 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox' LIMIT 1);
SET @sid_10 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.messages' LIMIT 1);
SET @sid_11 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.ruledictionary' LIMIT 1);
SET @sid_12 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1);
SET @sid_13 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.handled' LIMIT 1);
SET @rolid_14 = (7);
SET @rolid_15 = (8);
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_form' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_messages_show' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='dictionary_form' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_jnews_bounce_preferences' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_preferences' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='mailbox_messages_show_message_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('mailbox_messages_show_message','mailbox_messages_show_sender_informations') LIMIT 2;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='mailbox_form_mailbox' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('mailbox_form_mailbox_name','mailbox_form_mailbox_description','mailbox_form_mailbox_publish','mailbox_form_mailbox_addon','mailbox_form_mailbox_server','mailbox_form_secure','mailbox_form_nocertif','mailbox_form_port','mailbox_form_mailbox_username','mailbox_form_mailbox_password') LIMIT 10;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='mailbox_form_parameters' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('mailbox_form_savemessage','mailbox_form_forward','mailbox_form_delete','mailbox_form_deletemsg') LIMIT 4;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='mailbox_messages_show_message' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('mailbox_messages_show_mailbox_messages_subject','mailbox_messages_show_mailbox_messages_body') LIMIT 2;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='mailbox_messages_show_header' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('mailbox_messages_show_mailbox_messages_header') LIMIT 1;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='dictionary_form_entry' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('dictionary_form_rule_dictionary_words','dictionary_form_rule_dictionary_type','dictionary_form_rule_dictionary_searchin','dictionary_form_rule_dictionary_publish') LIMIT 4;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='jnews_bounce_preferences_conditions' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('jnews_bounce_preferences_newzletter_newzletterbounce_mailbobouncenum','jnews_bounce_preferences_newzletter_newzletterbounce_mailbodelaymin') LIMIT 2;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='jnews_bounce_preferences_actions' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('jnews_bounce_preferences_newzletter_newzletterbounce_mailbosubsuser','jnews_bounce_preferences_newzletter_newzletterbounce_mailbounsubsuser','jnews_bounce_preferences_newzletter_newzletterbounce_mailbounconuser','jnews_bounce_preferences_newzletter_newzletterbounce_mailboblackuser','jnews_bounce_preferences_newzletter_newzletterbounce_mailbodeleteuser') LIMIT 5;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='jnews_bounce_preferences_message' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('jnews_bounce_preferences_newzletter_newzletterbounce_mailbodeletemsg') LIMIT 1;
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_listing' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_emanager_listing' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_emanager_mailbox' LIMIT 1);
SET @yid_24 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='inb_messages' LIMIT 1);
SET @yid_25 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='emanader_handled' LIMIT 1);
SET @yid_26 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_dictionary' LIMIT 1);
SET @yid_27 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='sent' LIMIT 1);
SET @yid_28 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='trash' LIMIT 1);
SET @yid_29 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='archive' LIMIT 1);
SET @yid_30 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_bounce_messages_report' LIMIT 1);
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='mailbox_mailboxes_report' LIMIT 1);
SET @sid_32 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.email' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='mailbox_mailbox_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('mailbox_mailbox_description') LIMIT 1;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='inb_messages_mailbox_messages_subject' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('inb_messages_mailbox_messages_body') LIMIT 1;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='sent_mailbox_messages_subject' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('sent_mailbox_messages_body') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='trash_mailbox_messages_subject' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('trash_mailbox_messages_body') LIMIT 1;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='archive_mailbox_messages_subject' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('archive_mailbox_messages_body') LIMIT 1;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');


REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_mailbox_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='681inbid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_mailbox' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684inbid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_mailbox' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684emaid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_mailbox_messages' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='735msgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_mailbox_messages_inbid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='inbid735' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_handled' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='736email' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_emanager_handled' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='736type' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='809ruleid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_condition' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='811cdtid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_rule_dictionary' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='812dctid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_for_rule_dictionary' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='words812' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_for_rule_dictionary' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type812' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_for_rule_dictionary' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='searchin812' LIMIT 1));
SET @pk_77_10748 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'684inbid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10747 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'684emaid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10759 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'inbid735\' LIMIT 1' LIMIT 1 );
SET @pk_77_10838 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'cdtid809\' LIMIT 1' LIMIT 1 );
SET @pk_77_10839 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid809\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('inbid','1','inbid',@pk_77_10748,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684inbid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='681inbid' LIMIT 1),'1','3','inbid',@dbtid_1,@dbtid_2,'2');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','1','emanager_wid_extension',@pk_77_10747,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='684emaid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),@dbtid_2,'1'),('inbid','1','735_inbid_681',@pk_77_10759,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='inbid735' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='681inbid' LIMIT 1),'1','3','inbid',@dbtid_1,@dbtid_3,'1'),('cdtid','1','809_cdtid_811',@pk_77_10838,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='cdtid809' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='811cdtid' LIMIT 1),'1','1','cdtid',@dbtid_6,@dbtid_5,'99'),('uid','1','809_uid_232',@pk_77_10839,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid809' 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_5,'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_8,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_8,'2','1206732372QTKJ'),(@wid_8,'1','1206732392OZUO'),(@wid_8,'1','1236791959FTZU'),(@wid_8,'1','1241989374PAXK'),(@wid_8,'0','1241989376CCKB'),(@wid_8,'0','1241989376CCKC'),(@wid_8,'0','1241989381TANT'),(@wid_8,'1','1242580111TAIP'),(@wid_8,'1','1242580111TAIQ'),(@wid_8,'1','1242580111TAIS'),(@wid_8,'1','1242580111TAIT'),(@wid_8,'0','1254227304QDMN'),(@wid_8,'1','1254392738GVKF'),(@wid_8,'1','1254392738GVKG'),(@wid_8,'1','1254392738GVKH'),(@wid_8,'0','1258010751GXJB'),(@wid_8,'1','1260253904QSSO'),(@wid_8,'1','1260253904QSSP'),(@wid_8,'0','1327442997GDYF'),(@wid_8,'0','1327442997GDYG'),(@wid_8,'1','1389656700JZFI'),(@wid_8,'0','1418159587ECXG'),(@wid_8,'1','1418159587ECXH'),(@wid_8,'1','1418159587ECXI'),(@wid_8,'1','1418159587ECXJ'),(@wid_8,'1','1418159587ECXK'),(@wid_8,'0','1418159587ECXL'),(@wid_8,'0','1418159587ECXM'),(@wid_8,'1','1418159587ECXN'),(@wid_8,'1','1418159587ECXO'),(@wid_8,'1','1418159587ECXP'),(@wid_8,'1','1418159587ECXQ'),(@wid_8,'1','1418159587ECXR'),(@wid_8,'1','1433086401BPBR');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_8),'','','','','','','','','','','0','');
SET @dbcid_33 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox' LIMIT 1),'1241989377TGDL',@wid_8);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.email' LIMIT 1),'1241989381TANV',@wid_8),(@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.handled' LIMIT 1),'1206961882TDGU',@wid_8),(@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.messages' LIMIT 1),'1206961882TDGU',@wid_8),(@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.rule' LIMIT 1),'1254227305KKYZ',@wid_8),(@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.ruledictionary' LIMIT 1),'1251697925DNIM',@wid_8),(@dbcid_33,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='mailbox.rulecondition' LIMIT 1),'1254227305KKZB',@wid_8);