/*Export of the extension scheduler.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1206732425HINS','1206961898PINS','1206961893RSRQ','1298350272MURC','1206732392OZVB','1206732392OZVG','1206961898PIOD','1206732372QTKN','1206961898PIOF','1235462003CNHJ','1206961899DDLD','1206732400OWZR','1206961898PIOE','1236536858ATTC','1217326499HUVH','1315887118PXIR','1206961899DDKW','1230528896CZTU','1236536858ATTD','1236536858ATTE','1236536858ATTF','1236536858ATTG','1206732392OZVD','1217326499HUVI','1206732412DADP','1298294168JDHF','1298294169DGIW','1298294169DGIX','1298294169DGIZ','1298350274FGVE','1298294168JDHE','1206732411EGRY','1298294170PECP','1298294170PECQ','1298294170PECS','1206732400OWXH','1398436917DTKC','1206961869IGNE','1298294170PECT','1298294170PECU','1298294170PECR','1298294170PECO','1299642847MBBJ','1219769904NDJH','1206961869IGND','1298350446IEXG','1373207636DEVC','1373207636DEVD','1436410864OYRA','1382065664QQKX','1382065664QQKY','1397755348IVCW','1236536858ATSV','1236791960OSDP','1298294168JDHH','1236536858ATSY','1237202239LEER','1298294169DGIV','1304525968YBL','1240906945NFCK','1235462003CNHI','1237202239LEES','1315887122AMOM','1227579936RDAS','1230528895BZXE','1240906945NFCL','1236791960OSDQ','1237202239LEET','1299642742KTUN','1298294168JDHG','1298294169DGIY','1240906945NFCJ','1298350274FGVF','1236536858ATSX','1418159494SYHX','1227580613HBMH','1373207637APRV','1373207637APRW','1436410865NXKH','1382065665JEHW','1397755349MIED','1206732361LXFE','1206732372QTKL','1206732361LXFD','1206732399EINB','1242282449PIPC','1206732393CXVV','1206961898PIOC','1206732411EGRN','1206732391QBUR','1206732399EINF','1206732372QTKK','1206732392OZUP','1206961850KLRQ','1206732392OZVA','1298350272MURD','1206961898PIOG','1311850163FKKV','1206961899DDKO','1206961899DDKP','1206732411EGRV','1206961869IGNF','1206732392OZVH','1206961890JIOJ','1206732400OWXG','1209674941LKQO','1298294166ECLV','1298294170PECN','1206732411EGRI','1298350273IXBE','1298350273IXBF','1206961893RSRR','1298888291HSWK','1206732392OZUQ','1206961894CQIK','1227579936RDAV','1206961898PINZ','1298350274FGVG','1298350274FGVH','1380064772GVOO','1290669833IHWS','1380064772GVOP','1298350275LTMN','1298350275LTMO','1380064772GVOQ','1418159495CHIF','1219856743ELFT','1206732345BHSJ','1217586755TDUY','1217586755TDUZ','1217587982LBWO','1217587982LBWP','1217587982LBWQ','1217587982LBWR','1217587982LBWS','1217587982LBWT','1217587983MLGY','1217587983MLGZ','1217587983MLHA','1217587983MLHB','1217587983MLHC','1232547382ELZS','1235462002GHCA','1235462003CNHC','1235462003CNHD','1236656718FWVX','1237395235EOTF','1298294163YKW','1298294164ESOK','1298350272MURB','1299163902NDIX','1300773865DUMM','1301380691ICEI','1369751059DSKE','1374795728LREB','1374795728LREC','1382065652HZGO','1405633010MFWR','1405633010MFWS' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('scheduler.trans','scheduler.node','scheduler.processes','scheduler.url') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('scheduler.node','scheduler.url','scheduler.trans','scheduler.processes','members.node','joobi.languages','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans','mailing.trans') AND `#__dataset_columns`.`namekey` NOT IN ('232uid','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','382mgid','382lgid','382name','382ctext','382chtml','382smail','382sname','232html','232registered','199name','199main','199publish','199real','460schid','460nextdate','460frequency','460priority','460lastdate','461schurlid','461name','461uid','461description','461url','461nextdate','461frequency','461priority','461lastdate','461sendreport','461lastreport','461email','460publish','461publish','461created','460created','232unsub','461timeout','461type','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','484description','382rname','382remail','232login','199rtl','567schid','567name','567description','567lgid','481wname','481wdescription','232rolid','460params','460cron','199availadmin','199availsite','618sid','618lgid','618name','460ptype','199locale','199localeconv','namekey460','visibility232','core460','report460','714ctrid','714lgid','name714','description714','description485','auto382','fromlgid382','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto567','fromlgid567','auto618','fromlgid618','auto714','fromlgid714','curid232','919pcsid','schid919','created919','maxtime460','maxprocess460','lock461','attempt461','bouncemail382','authorid382','modified382','intro382','viewname460','ip232','ctyid232','core199','smsmessage382','mobile232','filid232','automatic199','title382','subtitle382','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 ('461uid','567schid','567lgid','schid919') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_scheduler_url_uid','FK_schedulertrans_lgid','FK_schedulertrans_schid','FK_scheduler_processes_schid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('scheduler.node') ;
SET @rolid_0 = (1);
SET @pk_549_460 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.node' LIMIT 1 );
SET @pk_549_461 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.url' LIMIT 1 );
SET @pk_549_567 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.trans' LIMIT 1 );
SET @pk_549_919 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.processes' 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_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_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
SET @pk_549_382 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('scheduler_node','scheduler.node',@pk_549_460,'','1.0.0',@rolid_0,'0','1','schid','node','scheduler','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 ('scheduler_url','scheduler.url',@pk_549_461,'','1.0.0',@rolid_0,'0','1','schurlid','url','scheduler','51','2','0','0','7'),('scheduler_trans','scheduler.trans',@pk_549_567,'','1.0.0',@rolid_0,'0','20','schid,lgid','trans','scheduler','51','0','0','0','7'),('scheduler_processes','scheduler.processes',@pk_549_919,'','',@rolid_0,'0','1','pcsid','processes','scheduler','51','0','0','0','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'),('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'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7'),('mailing_trans','mailing.trans',@pk_549_382,'','1.0.0',@rolid_0,'0','20','mgid,lgid','trans','mailing','51','0','0','0','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.trans' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.node' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.processes' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='scheduler.url' LIMIT 1);
SET @pk_454_65467 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_schedulertrans_schid_lgid' LIMIT 1 );
SET @pk_454_65855 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1 );
SET @pk_454_65871 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_scheduler_process' LIMIT 1 );
SET @pk_454_65927 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_scheduler_node' LIMIT 1 );
SET @pk_454_65955 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_url_publish_lock_nextdate_priority' LIMIT 1 );
SET @pk_454_65956 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_url_uid' LIMIT 1 );
SET @pk_454_65854 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_wid' LIMIT 1 );
SET @pk_454_65873 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_processes_schid' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65467,'3','PK_schedulertrans_schid_lgid',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_65855,'2','IX_scheduler_node_publish_priority_nextdate',@dbtid_2),(@pk_454_65871,'3','PK_scheduler_process',@dbtid_3),(@pk_454_65927,'1','UK_namekey_scheduler_node',@dbtid_2),(@pk_454_65955,'2','IX_scheduler_url_publish_lock_nextdate_priority',@dbtid_4),(@pk_454_65956,'2','IX_scheduler_url_uid',@dbtid_4),(@pk_454_65854,'2','IX_scheduler_node_wid',@dbtid_2),(@pk_454_65873,'2','IX_scheduler_processes_schid',@dbtid_3);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1);
SET @pk_616_3254 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460nextdate' LIMIT 1 );
SET @pk_616_3256 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460priority' LIMIT 1 );
SET @pk_616_3260 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461uid' LIMIT 1 );
SET @pk_616_3263 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461nextdate' LIMIT 1 );
SET @pk_616_3265 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461priority' LIMIT 1 );
SET @pk_616_3277 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460publish' LIMIT 1 );
SET @pk_616_3278 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461publish' LIMIT 1 );
SET @pk_616_5543 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567schid' LIMIT 1 );
SET @pk_616_5546 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567lgid' LIMIT 1 );
SET @pk_616_6329 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey460' LIMIT 1 );
SET @pk_616_8427 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='919pcsid' LIMIT 1 );
SET @pk_616_8566 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lock461' 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_3250 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460schid' LIMIT 1 );
SET @pk_616_8428 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='schid919' LIMIT 1 );
SET @pk_616_3255 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460frequency' LIMIT 1 );
SET @pk_616_3257 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460lastdate' LIMIT 1 );
SET @pk_616_3258 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461schurlid' LIMIT 1 );
SET @pk_616_3259 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461name' LIMIT 1 );
SET @pk_616_3261 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461description' LIMIT 1 );
SET @pk_616_3262 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461url' LIMIT 1 );
SET @pk_616_3264 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461frequency' LIMIT 1 );
SET @pk_616_3266 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461lastdate' LIMIT 1 );
SET @pk_616_3267 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461sendreport' LIMIT 1 );
SET @pk_616_3268 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461lastreport' LIMIT 1 );
SET @pk_616_3269 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461email' LIMIT 1 );
SET @pk_616_3279 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461created' LIMIT 1 );
SET @pk_616_3280 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460created' LIMIT 1 );
SET @pk_616_3282 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461timeout' LIMIT 1 );
SET @pk_616_3283 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461type' LIMIT 1 );
SET @pk_616_5544 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567name' LIMIT 1 );
SET @pk_616_5545 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567description' LIMIT 1 );
SET @pk_616_5747 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460params' LIMIT 1 );
SET @pk_616_5758 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460cron' LIMIT 1 );
SET @pk_616_6070 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460ptype' LIMIT 1 );
SET @pk_616_6697 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core460' LIMIT 1 );
SET @pk_616_6699 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='report460' LIMIT 1 );
SET @pk_616_6868 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto567' LIMIT 1 );
SET @pk_616_6869 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid567' LIMIT 1 );
SET @pk_616_8429 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created919' LIMIT 1 );
SET @pk_616_8433 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='maxtime460' LIMIT 1 );
SET @pk_616_8434 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='maxprocess460' LIMIT 1 );
SET @pk_616_8567 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='attempt461' LIMIT 1 );
SET @pk_616_8759 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='viewname460' 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 );
SET @pk_616_2217 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1 );
SET @pk_616_2218 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1 );
SET @pk_616_2219 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1 );
SET @pk_616_8616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1 );
SET @pk_616_8617 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1 );
SET @pk_616_8618 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1 );
SET @pk_616_8678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1 );
SET @pk_616_10120 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1 );
SET @pk_616_10801 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1 );
SET @pk_616_10802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' 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_3254,@dbtid_2,'nextdate','0','1','4','1','1','0','6','1',@rolid_0,'0','0','0','460nextdate','1','1','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_3256,@dbtid_2,'priority','0','0','1','1','1','0','5','1',@rolid_0,'0','0','1','460priority','1','0','0'),(@pk_616_3260,@dbtid_4,'uid','0','1','4','1','1','0','17','1',@rolid_0,'1','0','1','461uid','1','0','0'),(@pk_616_3263,@dbtid_4,'nextdate','0','1','4','1','1','0','8','1',@rolid_0,'0','0','1','461nextdate','1','1','0'),(@pk_616_3265,@dbtid_4,'priority','0','0','1','0','1','50','15','1',@rolid_0,'0','0','1','461priority','1','0','0'),(@pk_616_3277,@dbtid_2,'publish','0','0','1','0','1','1','4','1',@rolid_0,'0','0','0','460publish','1','0','0'),(@pk_616_3278,@dbtid_4,'publish','0','0','1','0','1','1','11','1',@rolid_0,'0','0','1','461publish','1','0','0'),(@pk_616_5543,@dbtid_1,'schid','1','0','2','1','1','','4','1',@rolid_0,'0','0','1','567schid','1','0','0'),(@pk_616_5546,@dbtid_1,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','567lgid','1','0','0'),(@pk_616_6329,@dbtid_2,'namekey','0','1','14','0','1','','12','0','0','0','50','1','namekey460','1','0','0'),(@pk_616_8427,@dbtid_3,'pcsid','1','0','4','1','1','','1','0','0','1','0','1','919pcsid','1','0','0'),(@pk_616_8566,@dbtid_4,'lock','0','1','1','1','1','0','6','0','0','0','0','1','lock461','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_3250,@dbtid_2,'schid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','460schid','1','0','0'),(@pk_616_8428,@dbtid_3,'schid','0','1','2','1','1','0','2','0','0','0','0','1','schid919','1','0','0'),(@pk_616_3255,@dbtid_2,'frequency','0','0','4','1','1','0','8','1',@rolid_0,'0','10','1','460frequency','1','0','0'),(@pk_616_3257,@dbtid_2,'lastdate','0','1','4','1','1','0','7','1',@rolid_0,'0','0','0','460lastdate','1','1','0'),(@pk_616_3258,@dbtid_4,'schurlid','1','0','4','1','1','','5','1',@rolid_0,'0','0','1','461schurlid','1','0','0'),(@pk_616_3259,@dbtid_4,'name','0','0','14','0','1','','7','1',@rolid_0,'0','50','1','461name','1','0','0'),(@pk_616_3261,@dbtid_4,'description','0','0','16','0','1','','2','1',@rolid_0,'0','0','1','461description','1','0','0'),(@pk_616_3262,@dbtid_4,'url','0','1','14','0','1','','3','1',@rolid_0,'0','254','1','461url','1','0','0'),(@pk_616_3264,@dbtid_4,'frequency','0','0','3','1','1','0','9','1',@rolid_0,'0','0','1','461frequency','1','0','0'),(@pk_616_3266,@dbtid_4,'lastdate','0','0','4','1','1','0','16','1',@rolid_0,'0','0','1','461lastdate','1','0','0'),(@pk_616_3267,@dbtid_4,'sendreport','0','0','25','0','1','0','14','1',@rolid_0,'0','0','1','461sendreport','1','0','0'),(@pk_616_3268,@dbtid_4,'lastreport','0','0','16','0','1','','13','1',@rolid_0,'0','0','1','461lastreport','1','0','0'),(@pk_616_3269,@dbtid_4,'email','0','0','14','0','1','','10','1',@rolid_0,'0','100','1','461email','1','0','0'),(@pk_616_3279,@dbtid_4,'created','0','1','4','1','1','0','4','1',@rolid_0,'1','0','1','461created','1','1','0'),(@pk_616_3280,@dbtid_2,'created','0','1','4','1','1','0','3','1',@rolid_0,'0','0','1','460created','1','1','0'),(@pk_616_3282,@dbtid_4,'timeout','0','0','1','1','1','50','12','1',@rolid_0,'0','0','1','461timeout','1','0','0'),(@pk_616_3283,@dbtid_4,'type','0','0','1','1','1','1','1','1',@rolid_0,'0','0','1','461type','1','0','0'),(@pk_616_5544,@dbtid_1,'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','567name','1','0','0'),(@pk_616_5545,@dbtid_1,'description','0','0','16','0','1','','1','1',@rolid_0,'0','0','1','567description','1','0','0'),(@pk_616_5747,@dbtid_2,'params','0','0','16','0','1','','9','1',@rolid_0,'0','0','1','460params','1','0','0'),(@pk_616_5758,@dbtid_2,'cron','0','0','14','0','1','','2','1',@rolid_0,'0','50','1','460cron','1','0','0'),(@pk_616_6070,@dbtid_2,'ptype','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','460ptype','1','0','0'),(@pk_616_6697,@dbtid_2,'core','0','1','25','0','1','0','13','0','0','0','0','1','core460','1','0','0'),(@pk_616_6699,@dbtid_2,'report','0','1','16','0','1','','14','0','0','0','0','0','report460','1','0','0'),(@pk_616_6868,@dbtid_1,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto567','1','0','0'),(@pk_616_6869,@dbtid_1,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid567','1','0','0'),(@pk_616_8429,@dbtid_3,'created','0','1','4','1','1','0','3','0','0','0','0','1','created919','1','1','0'),(@pk_616_8433,@dbtid_2,'maxtime','0','1','4','1','1','5','15','0','0','0','0','1','maxtime460','1','0','0'),(@pk_616_8434,@dbtid_2,'maxprocess','0','1','2','1','1','1','16','0','0','0','0','1','maxprocess460','1','0','0'),(@pk_616_8567,@dbtid_4,'attempt','0','1','1','1','1','0','18','0','0','0','0','1','attempt461','1','0','0'),(@pk_616_8759,@dbtid_2,'viewname','0','1','14','0','1','','17','0','0','0','50','1','viewname460','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');
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_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'),(@pk_616_2217,@dbtid_5,'name','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','382name','1','0','0'),(@pk_616_2218,@dbtid_5,'ctext','0','0','19','0','1','','8','1',@rolid_0,'0','0','1','382ctext','1','0','0'),(@pk_616_2219,@dbtid_5,'chtml','0','0','19','0','1','','7','1',@rolid_0,'0','0','1','382chtml','1','0','0'),(@pk_616_8616,@dbtid_5,'bouncemail','0','1','14','0','1','','11','0','0','0','100','1','bouncemail382','1','0','0'),(@pk_616_8617,@dbtid_5,'authorid','0','1','4','1','1','0','14','0','0','0','0','1','authorid382','1','0','0'),(@pk_616_8618,@dbtid_5,'modified','0','1','4','1','1','0','15','0','0','0','0','1','modified382','1','1','0'),(@pk_616_8678,@dbtid_5,'intro','0','1','16','0','1','','6','0','0','0','0','1','intro382','1','0','0'),(@pk_616_10120,@dbtid_5,'smsmessage','0','1','16','0','1','','16','0','0','0','0','1','smsmessage382','1','0','0'),(@pk_616_10801,@dbtid_5,'title','0','1','14','0','1','','17','0','0','0','255','1','title382','1','0','0'),(@pk_616_10802,@dbtid_5,'subtitle','0','1','14','0','1','','18','0','0','0','255','1','subtitle382','1','0','0');
SET @pk_5_86 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='scheduler.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='scheduler',`wid`=@pk_5_86,`params`='',`status`='1',`type`='150',`name`='Scheduler',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='scheduler.node',`version`='4844',`lversion`='4844',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='scheduler.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','scheduler',@pk_5_86,'','1','150','Scheduler','node','0','1','1','scheduler.node','4844','4844','1','','1','1','0');

SET @pk_621_460 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler' LIMIT 1 );
SET @pk_621_461 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.url' LIMIT 1 );
SET @pk_621_567 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='schedulertrans' LIMIT 1 );
SET @pk_621_1013 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.processes' LIMIT 1 );
SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_460,`dbtid`=@dbtid_2,`path`='1',`namekey`='scheduler',`folder`='scheduler',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='scheduler',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-calendar',`pnamekey`='' WHERE  `namekey`='scheduler';
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_460,@dbtid_2,'1','scheduler','scheduler',@rolid_0,'0','1','0','0','autofld=1','','scheduler','0','0','1','fa-calendar','');
UPDATE `#__model_node`  SET `sid`=@pk_621_461,`dbtid`=@dbtid_4,`path`='1',`namekey`='scheduler.url',`folder`='jurlauncher.url',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='scheduler',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='scheduler.url';
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_461,@dbtid_4,'1','scheduler.url','jurlauncher.url',@rolid_0,'0','1','0','0','autofld=1','','scheduler','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_567,`dbtid`=@dbtid_1,`path`='0',`namekey`='schedulertrans',`folder`='schedulertrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=scheduler',`alias`='',`prefix`='scheduler',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='schedulertrans';
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_567,@dbtid_1,'0','schedulertrans','schedulertrans',@rolid_0,'0','1','0','0','\nmainmodel=scheduler','','scheduler','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1013,`dbtid`=@dbtid_3,`path`='0',`namekey`='scheduler.processes',`folder`='scheduler.processes',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='scheduler',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='scheduler.processes';
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_1013,@dbtid_3,'0','scheduler.processes','scheduler.processes',@rolid_0,'0','1','0','0','autofld=1','','scheduler','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_1015,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='users';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1015,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');

SET @wid_6 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='scheduler.node' LIMIT 1);
SET @sid_7 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler' LIMIT 1);
SET @sid_8 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.url' LIMIT 1);
SET @sid_9 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.processes' LIMIT 1);
SET @rolid_10 = (7);
SET @yid_11 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_preferences' LIMIT 1);
SET @yid_12 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_scheduler_form' LIMIT 1);
SET @yid_13 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_show_scheduler' LIMIT 1);
SET @yid_14 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_preferences_nested' LIMIT 1);
SET @sid_15 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='schedulertrans' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('scheduler_scheduler_form_general_4','scheduler_scheduler_form_last_run') LIMIT 2;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_periodicity' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('scheduler_scheduler_form_periodicity_3','scheduler_scheduler_form_parameters') LIMIT 2;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_general_4' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('scheduler_scheduler_form_schedulertrans_name','scheduler_scheduler_form_scheduler_wid','scheduler_scheduler_form_schedulertrans_description','scheduler_scheduler_form_scheduler_publish','scheduler_scheduler_form_scheduler_maxtime','scheduler_scheduler_form_scheduler_maxprocess','scheduler_scheduler_form_scheduler_priority','scheduler_scheduler_form_scheduler_namekey') LIMIT 8;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_last_run' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('scheduler_scheduler_form_scheduler_lastdate','scheduler_scheduler_form_scheduler_report') LIMIT 2;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_periodicity_3' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('scheduler_scheduler_form_scheduler_ptype','scheduler_scheduler_form_scheduler_nextdate','scheduler_scheduler_form_scheduler_frequency','scheduler_scheduler_form_scheduler_cron') LIMIT 4;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_scheduler_form_parameters' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('scheduler_scheduler_form_parameters_2') LIMIT 1;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_preferences_advance' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('scheduler_preferences_scheduler_node_memlimit','scheduler_preferences_scheduler_node_maxtasks','scheduler_preferences_scheduler_node_maxprocess','scheduler_preferences_scheduler_node_password') LIMIT 4;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_preferences_scheduler' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('scheduler_preferences_library_node_controllercron','scheduler_preferences_scheduler_node_cronfrequency','scheduler_preferences_scheduler_node_timelimit','scheduler_preferences_scheduler_node_report','scheduler_preferences_scheduler_node_reportemail') LIMIT 5;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_show_scheduler_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('scheduler_show_scheduler_apps_name','scheduler_show_scheduler_scheduler_namekey','scheduler_show_scheduler_scheduler_publish','scheduler_show_scheduler_scheduler_core','scheduler_show_scheduler_scheduler_nextdate','scheduler_show_scheduler_scheduler_lastdate','scheduler_show_scheduler_scheduler_created') LIMIT 7;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='scheduler_show_scheduler_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('scheduler_show_scheduler_scheduler_priority','scheduler_show_scheduler_scheduler_cron','scheduler_show_scheduler_scheduler_frequency','scheduler_show_scheduler_scheduler_ptype','scheduler_show_scheduler_scheduler_maxtime','scheduler_show_scheduler_scheduler_maxprocess') LIMIT 6;
SET @yid_16 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_url_launcher' LIMIT 1);
SET @yid_17 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_main_layout' LIMIT 1);
SET @yid_18 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='dashboard_nested_scheduler' LIMIT 1);
SET @yid_19 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='dashboard_nested_launcher' LIMIT 1);
SET @yid_20 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_processes_listing' LIMIT 1);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='scheduler_processes_popup' LIMIT 1);
SET @rolid_22 = (8);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_url_launcher_scheduler_url_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('scheduler_url_launcher_scheduler_url_description') LIMIT 1;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_url_launcher_scheduler_url_nextdate_4' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('scheduler_url_launcher_scheduler_url_nextdate_1','scheduler_url_launcher_scheduler_url_nextdate') LIMIT 2;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_url_launcher_scheduler_url_sendreport' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('scheduler_url_launcher_scheduler_url_email') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_main_layout_schedulertrans_name_8' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('scheduler_main_layout_schedulertrans_name','scheduler_main_layout_scheduler_namekey','scheduler_main_layout_schedulertrans_description') LIMIT 3;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_main_layout_scheduler_nextdate_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('scheduler_main_layout_scheduler_nextdate_6','scheduler_main_layout_scheduler_nextdate') LIMIT 2;
SET @p_3_5 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='scheduler_main_layout_scheduler_lastdate_3' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_5 WHERE `namekey` IN ('scheduler_main_layout_scheduler_lastdate_5','scheduler_main_layout_scheduler_lastdate') LIMIT 2;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Error','1','1206732345BHSJ');


SET @ctid_23 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_url_publish_lock_nextdate_priority' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460nextdate' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460priority' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_url_uid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461uid' LIMIT 1)),(@ctid_23,'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461nextdate' LIMIT 1)),(@ctid_23,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461priority' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_scheduler_node_publish_priority_nextdate' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460publish' LIMIT 1)),(@ctid_23,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_schedulertrans_schid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567schid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_schedulertrans_schid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_scheduler_node' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey460' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_scheduler_process' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='919pcsid' LIMIT 1)),(@ctid_23,'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lock461' LIMIT 1));
SET @pk_77_525 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'461uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10447 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'567schid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10446 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.languages\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'567lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11010 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'schid919\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('uid','1','FK_scheduler_url_uid',@pk_77_525,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='461uid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'3','3','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),@dbtid_4,'99');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('schid','1','FK_schedulertrans_schid',@pk_77_10447,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567schid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460schid' LIMIT 1),'3','3','',@dbtid_2,@dbtid_1,'99'),('lgid','1','FK_schedulertrans_lgid',@pk_77_10446,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_1,'99'),('schid','1','FK_scheduler_processes_schid',@pk_77_11010,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='schid919' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='460schid' LIMIT 1),'1','1','schid',@dbtid_2,@dbtid_3,'1');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_6,'1','1206732345BHSJ');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_6,'0','1217586755TDUY'),(@wid_6,'0','1217586755TDUZ'),(@wid_6,'0','1217587982LBWO'),(@wid_6,'0','1217587982LBWP'),(@wid_6,'0','1217587982LBWQ'),(@wid_6,'0','1217587982LBWR'),(@wid_6,'0','1217587982LBWS'),(@wid_6,'0','1217587982LBWT'),(@wid_6,'0','1217587983MLGY'),(@wid_6,'0','1217587983MLGZ'),(@wid_6,'0','1217587983MLHA'),(@wid_6,'0','1217587983MLHB'),(@wid_6,'0','1217587983MLHC'),(@wid_6,'1','1232547382ELZS'),(@wid_6,'0','1235462002GHCA'),(@wid_6,'1','1235462003CNHC'),(@wid_6,'1','1235462003CNHD'),(@wid_6,'0','1236656718FWVX'),(@wid_6,'1','1237395235EOTF'),(@wid_6,'0','1298294163YKW'),(@wid_6,'0','1298294164ESOK'),(@wid_6,'0','1298350272MURB'),(@wid_6,'0','1299163902NDIX'),(@wid_6,'0','1300773865DUMM'),(@wid_6,'1','1301380691ICEI'),(@wid_6,'1','1369751059DSKE'),(@wid_6,'0','1374795728LREB'),(@wid_6,'0','1374795728LREC'),(@wid_6,'1','1382065652HZGO'),(@wid_6,'0','1405633010MFWR'),(@wid_6,'0','1405633010MFWS');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('scheduler_report',@rolid_0,'1','1','',@wid_6,'Scheduler Report','0','{widget:site}\r\n','0','0','1','1','0','3','0','1');
SET @dbcid_24 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_6,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_6,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='567name' LIMIT 1)),(@wid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler' LIMIT 1),'1206732425HINS',@dbcid_24),(@wid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.url' LIMIT 1),'1206961898PINS',@dbcid_24),(@wid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='schedulertrans' LIMIT 1),'1206961893RSRQ',@dbcid_24),(@wid_6,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='scheduler.processes' LIMIT 1),'1298350272MURC',@dbcid_24),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1380064772GVOQ',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1418159495CHIF',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_6,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='scheduler_report' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1));