/*Export of the extension events.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1206961869IGNA','1346440529KXWF','1250070127LYIO','1209142268NMKA','1239111911FQGH','1239870995FKWO','1239111911FQGI','1398436917DTKC','1250070242QRDK','1206732425HINS','1219769905FKRL','1207306697RNMA','1206732400OWXG','1206961869IGND','1206732392OZVB','1211811528BLZA','1206732392OZVH','1217251965LDUE','1220272211DTNO','1206961912MJQB','1206732400OWZR','1394069593IQAQ','1394069593IQAS','1394069593IQAR','1298350843FMVJ','1298350843FMVK','1206961936HCWR','1206732425HINW','1206732372QTKN','1206732425HINY','1206732425HINT','1206732412DAEO','1206732388KEHZ','1434117647OYCE','1206732392OZVG','1220446694TBPU','1209746298RJII','1239111910ARQB','1239870994APHY','1239111910ARQC','1304525968YBL','1217251965LDUB','1217251965LDUC','1217251965LDUD','1346440530OZED','1346440530OZEE','1434117648GRDZ','1206732425HINX','1434117648GREA','1206732425HINZ','1434117648GREB','1257735566GJYL','1239111911FQGJ','1242282449PIPC','1206732393CXVV','1206732361LXFE','1206732391QBUR','1206732361LXFD','1206732372QTKL','1206732372QTKK','1206961882TDHA','1228820287MBVC','1206732399EINB','1206732392OZUP','1206732392OZVA','1227579895DRET','1206732423RNTL','1206732439BHWX','1206961945HIVW','1206961869IGNE','1243437901LSSX','1206961870KLBH','1206732388KEIC','1217251965LDTZ','1219769913SSOS','1250070242QRDM','1262788755ESJP','1262788755ESJQ','1253938983RSND','1251517317JKUT','1377132741NGHQ','1251084267IPHF','1262788755ESJS','1253938983RSNC','1385690069AGSH','1377132741NGHR','1262788755ESJR','1251084267IPHE','1250070242QRDO','1250145258KISY','1250777201NOVJ','1250777201NOVK','1298546835PCUJ','1220793699CLWU','1206732372QTKI','1206732372QTKJ','1206732410ICCJ','1250145257BXGB','1408411565AGZI','1434643123QBFI' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('eguillage.node','action.node','eguillage.trans','eguillage.roles','eguillage.action','actions.type') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('eguillage.node','action.node','eguillage.trans','eguillage.roles','eguillage.action','actions.type','layout.node','extension.node','members.node','joobi.languages','role.node','mailing.statistics.user','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans') AND `#__dataset_columns`.`namekey` NOT IN ('2yid','2wizard','2wid','2type','2publish','2params','2namekey','2modified','2menu','2frontend','2created','2level','5publish','5folder','5wid','5params','5status','5type','5name','2subtype','2dropdown','2pagination','2filters','232uid','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','232html','2private','232registered','199name','199main','199publish','199real','232unsub','475ctrid','475yid','475app','475type','475task','475level','475publish','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','5parent','5trans','484description','475wid','5certify','2core','475premium','2sid','475path','475admin','475namekey','475core','5namekey','232login','5version','2form','5lversion','2icon','199rtl','5pref','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','2tmid','2rolid','475rolid','5rolid','566type','2alias','5install','199availadmin','199availsite','618sid','618lgid','618name','199locale','475trigger','622actid','622namekey','622wid','622folder','622status','622filter','622params','566depth','622publish','622rolid','199localeconv','ordering5','core5','visibility232','modified5','visible475','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto618','fromlgid618','auto714','fromlgid714','804ctrid','rolid804','uid804','modified804','curid232','override804','j16566','before622','core622','ip232','ctyid232','fields2','parent2','checkowner475','reload5','reload2','reload475','created475','modified475','1032ctr_action_id','ctrid1032','actid1032','action1032','ordering1032','publish1032','core1032','params1032','namekey1032','core199','widgets2','created5','mobile232','3389mgid','3389uid','created3389','senthtml3389','textsent3389','failed3389','bounced3389','smssent3389','hitlinks3389','read3389','readdate3389','mailerid3389','sent3389','faicon2','checkadminowner475','filid232','3418cmpgnactstpid','namekey3418','rolid3418','uid3418','core3418','publish3418','modified3418','created3418','automatic199','useredit2','showconfig5','framework5','message485','parentkey475','parentkey2','custom475','custom2') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__dataset_foreign`.* FROM `#__dataset_columns` LEFT JOIN `#__dataset_foreign` ON `#__dataset_foreign`.`feid` = `#__dataset_columns`.`dbcid` WHERE `#__dataset_columns`.`namekey` IN ('475yid','475wid','475rolid','622wid','622rolid','714ctrid','714lgid','804ctrid','rolid804','uid804','ctrid1032','actid1032','rolid3418','uid3418','created3418') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_controller_rolid','FK_controller_wid','FK_controller_yid','FK_action_rolid','FK_action_wid','FK_controller_ctrlid','FK_controller_lgid','FK_controller_ctrid','FK_eguillage_actid','FK_actions_type_created','FK_eguillage_action_ctrid','FK_campaign_actionstype_rolid','804_rolid_566','FK_campaign_actionstype_uid','804_uid_232') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('events.node') ;
SET @rolid_0 = (1);
SET @pk_549_475 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.node' LIMIT 1 );
SET @pk_549_622 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='action.node' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
SET @pk_549_804 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.roles' LIMIT 1 );
SET @pk_549_1032 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.action' LIMIT 1 );
SET @pk_549_3418 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='actions.type' LIMIT 1 );
SET @pk_549_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_3389 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.statistics.user' 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_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' 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 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('eguillage_node','eguillage.node',@pk_549_475,'','1.0.0',@rolid_0,'0','1','ctrid','node','eguillage','9','0','0','1','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('action_node','action.node',@pk_549_622,'','1.0.0',@rolid_0,'0','1','actid','node','action','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'),('eguillage_roles','eguillage.roles',@pk_549_804,'','',@rolid_0,'0','10','ctrid','roles','eguillage','51','2','0','0','7'),('eguillage_action','eguillage.action',@pk_549_1032,'','',@rolid_0,'0','10','ctr_action_id','','','9','0','0','1','7'),('actions_type','actions.type',@pk_549_3418,'','',@rolid_0,'0','1','acttyid','','','51','2','0','0','7'),('layout_node','layout.node',@pk_549_2,'','1.0.0',@rolid_0,'0','1','yid','node','layout','9','0','0','1','7'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('mailing_statistics_user','mailing.statistics.user',@pk_549_3389,'','',@rolid_0,'0','1','mgid,uid,created','','','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_mlinks','layout.mlinks',@pk_549_9,'','1.0.0',@rolid_0,'0','10','mid','mlinks','layout','9','0','1','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');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='action.node' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.roles' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.action' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='actions.type' LIMIT 1);
SET @pk_454_6803 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_app_task_admin' LIMIT 1 );
SET @pk_454_48177 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_namekey' LIMIT 1 );
SET @pk_454_65538 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_action_node_namekey' LIMIT 1 );
SET @pk_454_65637 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_eguillage_trans|main_library' LIMIT 1 );
SET @pk_454_65709 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_eguillage_roles' LIMIT 1 );
SET @pk_454_65853 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_publish_premium_level' LIMIT 1 );
SET @pk_454_65861 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_action_node_wid_publish' LIMIT 1 );
SET @pk_454_65866 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_node_wid' LIMIT 1 );
SET @pk_454_66029 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_eguillage_action|main_library' LIMIT 1 );
SET @pk_454_66031 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_eguillage_action_ctrid_publish' LIMIT 1 );
SET @pk_454_66032 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_eguillage_action_namekey' LIMIT 1 );
SET @pk_454_66148 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_node_yid' LIMIT 1 );
SET @pk_454_66187 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_campaign_actionstype|main_userdata' LIMIT 1 );
SET @pk_454_66189 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_campaign_actionstype' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_6803,'1','UK_controller_app_task_admin',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_48177,'1','UK_controller_namekey',@dbtid_1),(@pk_454_65538,'1','UK_action_node_namekey',@dbtid_2),(@pk_454_65637,'3','PK_eguillage_trans|main_library',@dbtid_3),(@pk_454_65709,'3','PK_eguillage_roles',@dbtid_4),(@pk_454_65853,'2','IX_controller_publish_premium_level',@dbtid_1),(@pk_454_65861,'2','IX_action_node_wid_publish',@dbtid_2),(@pk_454_65866,'2','IX_controller_node_wid',@dbtid_1),(@pk_454_66029,'3','PK_jos_eguillage_action|main_library',@dbtid_5),(@pk_454_66031,'2','IX_eguillage_action_ctrid_publish',@dbtid_5),(@pk_454_66032,'1','UK_eguillage_action_namekey',@dbtid_5),(@pk_454_66148,'2','IX_controller_node_yid',@dbtid_1),(@pk_454_66187,'3','PK_jos_campaign_actionstype|main_userdata',@dbtid_6),(@pk_454_66189,'1','UK_namekey_jos_campaign_actionstype',@dbtid_6);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1);
SET @pk_616_3337 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475yid' LIMIT 1 );
SET @pk_616_3338 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475app' LIMIT 1 );
SET @pk_616_3340 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475task' LIMIT 1 );
SET @pk_616_3341 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475level' LIMIT 1 );
SET @pk_616_3346 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475publish' LIMIT 1 );
SET @pk_616_3520 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475wid' LIMIT 1 );
SET @pk_616_3527 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475premium' LIMIT 1 );
SET @pk_616_3531 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475admin' LIMIT 1 );
SET @pk_616_3534 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475namekey' LIMIT 1 );
SET @pk_616_6086 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622namekey' LIMIT 1 );
SET @pk_616_6087 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622wid' LIMIT 1 );
SET @pk_616_6150 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622publish' LIMIT 1 );
SET @pk_616_6792 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714ctrid' LIMIT 1 );
SET @pk_616_6793 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714lgid' LIMIT 1 );
SET @pk_616_7399 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='804ctrid' LIMIT 1 );
SET @pk_616_9599 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1032ctr_action_id' LIMIT 1 );
SET @pk_616_9600 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctrid1032' LIMIT 1 );
SET @pk_616_9604 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1032' LIMIT 1 );
SET @pk_616_9607 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1032' LIMIT 1 );
SET @pk_616_10519 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3418cmpgnactstpid' LIMIT 1 );
SET @pk_616_10526 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey3418' LIMIT 1 );
SET @pk_616_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' 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_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_3335 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475ctrid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_6085 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622actid' LIMIT 1 );
SET @pk_616_10130 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created3389' LIMIT 1 );
SET @pk_616_5655 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475rolid' LIMIT 1 );
SET @pk_616_6151 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622rolid' LIMIT 1 );
SET @pk_616_7400 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid804' LIMIT 1 );
SET @pk_616_7401 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid804' LIMIT 1 );
SET @pk_616_9601 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='actid1032' LIMIT 1 );
SET @pk_616_10529 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid3418' LIMIT 1 );
SET @pk_616_10530 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3418' LIMIT 1 );
SET @pk_616_10550 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created3418' LIMIT 1 );
SET @pk_616_3339 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475type' LIMIT 1 );
SET @pk_616_3530 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475path' LIMIT 1 );
SET @pk_616_3544 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475core' LIMIT 1 );
SET @pk_616_6082 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475trigger' LIMIT 1 );
SET @pk_616_6088 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622folder' LIMIT 1 );
SET @pk_616_6089 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622status' LIMIT 1 );
SET @pk_616_6090 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622filter' LIMIT 1 );
SET @pk_616_6091 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622params' LIMIT 1 );
SET @pk_616_6791 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='visible475' 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_6886 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto714' LIMIT 1 );
SET @pk_616_6887 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid714' LIMIT 1 );
SET @pk_616_7402 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified804' LIMIT 1 );
SET @pk_616_7407 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='override804' LIMIT 1 );
SET @pk_616_8847 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='before622' LIMIT 1 );
SET @pk_616_8972 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core622' LIMIT 1 );
SET @pk_616_9201 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checkowner475' LIMIT 1 );
SET @pk_616_9507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload475' LIMIT 1 );
SET @pk_616_9508 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created475' LIMIT 1 );
SET @pk_616_9509 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified475' LIMIT 1 );
SET @pk_616_9602 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='action1032' LIMIT 1 );
SET @pk_616_9603 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering1032' LIMIT 1 );
SET @pk_616_9605 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core1032' LIMIT 1 );
SET @pk_616_9606 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params1032' LIMIT 1 );
SET @pk_616_10244 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checkadminowner475' LIMIT 1 );
SET @pk_616_10532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core3418' LIMIT 1 );
SET @pk_616_10533 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish3418' LIMIT 1 );
SET @pk_616_10535 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified3418' LIMIT 1 );
SET @pk_616_10841 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentkey475' LIMIT 1 );
SET @pk_616_10954 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='custom475' 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 );
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_3337,@dbtid_1,'yid','0','0','3','1','1','0','6','1',@rolid_0,'0','0','1','475yid','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_3338,@dbtid_1,'app','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','475app','1','0','0'),(@pk_616_3340,@dbtid_1,'task','0','1','14','0','1','','5','1',@rolid_0,'0','100','1','475task','1','0','0'),(@pk_616_3341,@dbtid_1,'level','0','0','1','1','1','0','11','1',@rolid_0,'0','0','1','475level','1','0','0'),(@pk_616_3346,@dbtid_1,'publish','0','0','1','0','1','1','8','1',@rolid_0,'0','0','1','475publish','1','0','0'),(@pk_616_3520,@dbtid_1,'wid','0','0','3','1','1','','2','1',@rolid_0,'0','0','1','475wid','1','0','0'),(@pk_616_3527,@dbtid_1,'premium','0','0','25','0','1','','9','1',@rolid_0,'0','0','1','475premium','1','0','0'),(@pk_616_3531,@dbtid_1,'admin','0','0','1','1','1','0','12','1',@rolid_0,'0','0','1','475admin','1','0','0'),(@pk_616_3534,@dbtid_1,'namekey','0','1','14','0','1','','3','1',@rolid_0,'0','100','1','475namekey','1','0','0'),(@pk_616_6086,@dbtid_2,'namekey','0','1','14','0','1','','4','1',@rolid_0,'0','50','1','622namekey','1','0','0'),(@pk_616_6087,@dbtid_2,'wid','0','0','3','1','1','0','2','1',@rolid_0,'0','0','1','622wid','1','0','0'),(@pk_616_6150,@dbtid_2,'publish','0','0','1','0','1','1','8','1',@rolid_0,'0','0','0','622publish','1','0','0'),(@pk_616_6792,@dbtid_3,'ctrid','1','0','4','1','1','','1','0','0','0','0','1','714ctrid','1','0','0'),(@pk_616_6793,@dbtid_3,'lgid','1','0','1','1','1','','2','0','0','0','4','1','714lgid','1','0','0'),(@pk_616_7399,@dbtid_4,'ctrid','1','0','3','1','1','','1','0','0','1','0','1','804ctrid','1','0','0'),(@pk_616_9599,@dbtid_5,'ctr_action_id','1','0','4','1','1','','1','0','0','1','0','1','1032ctr_action_id','1','0','0'),(@pk_616_9600,@dbtid_5,'ctrid','0','1','3','1','1','0','3','0','0','0','0','1','ctrid1032','1','0','0'),(@pk_616_9604,@dbtid_5,'publish','0','1','1','0','1','1','7','0','0','0','0','1','publish1032','1','0','0'),(@pk_616_9607,@dbtid_5,'namekey','0','1','14','0','1','','2','0','0','0','50','1','namekey1032','1','0','0'),(@pk_616_10519,@dbtid_6,'acttyid','1','0','2','1','1','','1','0','0','1','0','1','3418cmpgnactstpid','1','0','0'),(@pk_616_10526,@dbtid_6,'namekey','0','0','14','0','1','','2','0','0','0','150','1','namekey3418','1','0','0'),(@pk_616_21,@dbtid_7,'yid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','2yid','1','0','0'),(@pk_616_81,@dbtid_8,'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_1468,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1),'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_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_3335,@dbtid_1,'ctrid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','475ctrid','1','0','0'),(@pk_616_5532,@dbtid_9,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_6085,@dbtid_2,'actid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','622actid','1','0','0'),(@pk_616_10130,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.statistics.user' LIMIT 1),'created','1','0','4','1','1','0','3','0','0','0','0','1','created3389','1','1','0'),(@pk_616_5655,@dbtid_1,'rolid','0','0','2','1','1','1','15','1',@rolid_0,'0','0','1','475rolid','1','0','0'),(@pk_616_6151,@dbtid_2,'rolid','0','0','2','1','1','1','3','1',@rolid_0,'0','0','1','622rolid','1','0','0'),(@pk_616_7400,@dbtid_4,'rolid','0','0','2','1','1','0','2','0','0','0','0','1','rolid804','1','0','0'),(@pk_616_7401,@dbtid_4,'uid','0','0','4','1','1','0','3','0','0','0','0','1','uid804','1','0','0'),(@pk_616_9601,@dbtid_5,'actid','0','1','3','1','1','0','4','0','0','0','0','0','actid1032','1','0','0'),(@pk_616_10529,@dbtid_6,'rolid','0','0','2','1','1','1','3','0','0','0','0','1','rolid3418','1','0','0'),(@pk_616_10530,@dbtid_6,'uid','0','1','4','1','1','0','4','0','0','0','0','1','uid3418','1','0','0'),(@pk_616_10550,@dbtid_6,'created','0','1','4','1','1','0','8','0','0','0','0','1','created3418','1','1','0'),(@pk_616_3339,@dbtid_1,'type','0','0','1','1','1','0','7','1',@rolid_0,'0','0','1','475type','1','0','0'),(@pk_616_3530,@dbtid_1,'path','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','475path','1','0','0'),(@pk_616_3544,@dbtid_1,'core','0','0','25','0','1','1','14','1',@rolid_0,'0','0','1','475core','1','0','0'),(@pk_616_6082,@dbtid_1,'trigger','0','0','1','1','1','1','13','1',@rolid_0,'0','0','1','475trigger','1','0','0'),(@pk_616_6088,@dbtid_2,'folder','0','0','14','0','1','','5','1',@rolid_0,'0','30','1','622folder','1','0','0'),(@pk_616_6089,@dbtid_2,'status','0','0','1','1','1','1','6','1',@rolid_0,'0','0','1','622status','1','0','0'),(@pk_616_6090,@dbtid_2,'filter','0','0','25','0','1','0','7','1',@rolid_0,'0','0','1','622filter','1','0','0'),(@pk_616_6091,@dbtid_2,'params','0','0','16','0','1','','10','1',@rolid_0,'0','0','1','622params','1','0','0'),(@pk_616_6791,@dbtid_1,'visible','0','1','1','1','1','9','16','0','0','0','0','1','visible475','1','0','0'),(@pk_616_6794,@dbtid_3,'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,@dbtid_3,'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0'),(@pk_616_6886,@dbtid_3,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto714','1','0','0'),(@pk_616_6887,@dbtid_3,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid714','1','0','0'),(@pk_616_7402,@dbtid_4,'modified','0','0','4','1','1','0','4','0','0','0','0','1','modified804','1','1','0'),(@pk_616_7407,@dbtid_4,'override','0','1','1','1','1','1','5','0','0','0','0','1','override804','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_8847,@dbtid_2,'before','0','1','1','1','1','0','9','0','0','0','0','1','before622','1','0','0'),(@pk_616_8972,@dbtid_2,'core','0','1','25','0','1','0','11','0','0','0','0','1','core622','1','0','0'),(@pk_616_9201,@dbtid_1,'checkowner','0','1','1','1','1','0','17','0','0','0','0','1','checkowner475','1','0','0'),(@pk_616_9507,@dbtid_1,'reload','0','1','1','1','1','1','18','0','0','0','0','0','reload475','1','0','0'),(@pk_616_9508,@dbtid_1,'created','0','1','4','1','1','0','19','0','0','0','0','0','created475','1','1','0'),(@pk_616_9509,@dbtid_1,'modified','0','1','4','1','1','0','20','0','0','0','0','0','modified475','1','1','0'),(@pk_616_9602,@dbtid_5,'action','0','1','14','0','1','','5','0','0','0','100','1','action1032','1','0','0'),(@pk_616_9603,@dbtid_5,'ordering','0','1','2','1','1','0','6','0','0','0','0','1','ordering1032','1','0','0'),(@pk_616_9605,@dbtid_5,'core','0','1','25','0','1','0','8','0','0','0','0','1','core1032','1','0','0'),(@pk_616_9606,@dbtid_5,'params','0','1','16','0','1','','9','0','0','0','0','1','params1032','1','0','0'),(@pk_616_10244,@dbtid_1,'checkadminowner','0','1','1','1','1','0','21','0','0','0','0','1','checkadminowner475','1','0','0'),(@pk_616_10532,@dbtid_6,'core','0','0','25','0','1','0','7','0','0','0','0','1','core3418','1','0','0'),(@pk_616_10533,@dbtid_6,'publish','0','0','1','0','1','0','6','0','0','0','0','1','publish3418','1','0','0'),(@pk_616_10535,@dbtid_6,'modified','0','1','4','1','1','0','5','0','0','0','0','1','modified3418','1','1','0'),(@pk_616_10841,@dbtid_1,'pnamekey','0','1','14','0','1','','22','0','0','0','100','1','parentkey475','1','0','0'),(@pk_616_10954,@dbtid_1,'custom','0','1','1','1','1','0','23','0','0','0','0','1','custom475','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,@dbtid_10,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_6797,@dbtid_10,'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_10823,@dbtid_10,'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');
SET @pk_5_906 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='events.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='events',`wid`=@pk_5_906,`params`='',`status`='1',`type`='150',`name`='Events',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='events.node',`version`='3459',`lversion`='3459',`pref`='0',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='events.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','events',@pk_5_906,'','1','150','Events','node','0','1','1','events.node','3459','3459','0','','1','1','0');

SET @pk_621_1124 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.actions' LIMIT 1 );
SET @pk_621_1125 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.trigger' LIMIT 1 );
SET @pk_621_1318 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.actionstype' LIMIT 1 );
SET @pk_621_1405 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events' LIMIT 1 );
SET @pk_621_1406 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='eventstrans' LIMIT 1 );
SET @pk_621_1407 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.roles' LIMIT 1 );
SET @pk_621_721 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.viewmenus' LIMIT 1 );
SET @pk_621_733 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controller' LIMIT 1 );
SET @pk_621_734 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.action' LIMIT 1 );
SET @pk_621_2 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='view' LIMIT 1 );
SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_715 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.view' LIMIT 1 );
SET @pk_621_722 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.viewmenustrans' LIMIT 1 );
SET @pk_621_1215 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controlleraction' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_999 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='apps' LIMIT 1 );
SET @pk_621_856 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controllerroles' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_1124,`dbtid`=@dbtid_2,`path`='1',`namekey`='events.actions',`folder`='events.actions',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='events',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='events.actions';
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_1124,@dbtid_2,'1','events.actions','events.actions',@rolid_0,'0','1','0','0','autofld=1','','events','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1125,`dbtid`=@dbtid_5,`path`='0',`namekey`='events.trigger',`folder`='events.trigger',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='events',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='events.trigger';
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_1125,@dbtid_5,'0','events.trigger','events.trigger',@rolid_0,'0','1','0','0','autofld=1','','events','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1318,`dbtid`=@dbtid_6,`path`='0',`namekey`='events.actionstype',`folder`='events.actionstype',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='events',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='events.actionstype';
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_1318,@dbtid_6,'0','events.actionstype','events.actionstype',@rolid_0,'0','1','0','0','autofld=1','','events','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1405,`dbtid`=@dbtid_1,`path`='1',`namekey`='events',`folder`='events',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='event',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-random',`pnamekey`='' WHERE  `namekey`='events';
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_1405,@dbtid_1,'1','events','events',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','event','0','0','1','fa-random','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1406,`dbtid`=@dbtid_3,`path`='0',`namekey`='eventstrans',`folder`='eventstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='events',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='eventstrans';
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_1406,@dbtid_3,'0','eventstrans','eventstrans',@rolid_0,'0','1','0','0','autofld=1','','events','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1407,`dbtid`=@dbtid_4,`path`='0',`namekey`='events.roles',`folder`='events.roles',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='events',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='events.roles';
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_1407,@dbtid_4,'0','events.roles','events.roles',@rolid_0,'0','1','0','0','autofld=1','','events','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_721,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' LIMIT 1),`path`='0',`namekey`='library.viewmenus',`folder`='library.viewmenus',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ncachedata=1\nautofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-link',`pnamekey`='' WHERE  `namekey`='library.viewmenus';
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_721,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinks' LIMIT 1),'0','library.viewmenus','library.viewmenus',@rolid_0,'0','1','0','0','ordrg=1\ncachedata=1\nautofld=1','','library','0','0','1','fa-link','');
UPDATE `#__model_node`  SET `sid`=@pk_621_733,`dbtid`=@dbtid_1,`path`='0',`namekey`='library.controller',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-random',`pnamekey`='' WHERE  `namekey`='library.controller';
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_733,@dbtid_1,'0','library.controller','library',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','fa-random','');
UPDATE `#__model_node`  SET `sid`=@pk_621_734,`dbtid`=@dbtid_2,`path`='0',`namekey`='library.action',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='library.action';
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_734,@dbtid_2,'0','library.action','library',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_2,`dbtid`=@dbtid_7,`path`='1',`namekey`='view',`folder`='view',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='grpmap=wid\nprtname=viewtrans\ncachedata=1\nautofld=1',`alias`='',`prefix`='layout',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='view';
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_2,@dbtid_7,'1','view','view',@rolid_0,'0','1','0','0','grpmap=wid\nprtname=viewtrans\ncachedata=1\nautofld=1','','layout','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_9,`path`='1',`namekey`='role',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='prtname=roletrans\ncachedata=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role';
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_566,@dbtid_9,'1','role','role',@rolid_0,'0','1','0','0','prtname=roletrans\ncachedata=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_715,`dbtid`=@dbtid_7,`path`='0',`namekey`='library.view',`folder`='library.view',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='library.view';
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_715,@dbtid_7,'0','library.view','library.view',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','library','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_722,`dbtid`=@dbtid_10,`path`='0',`namekey`='library.viewmenustrans',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=library.viewmenus',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-link',`pnamekey`='' WHERE  `namekey`='library.viewmenustrans';
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_722,@dbtid_10,'0','library.viewmenustrans','library',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=library.viewmenus','','library','0','0','1','fa-link','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1215,`dbtid`=@dbtid_5,`path`='0',`namekey`='library.controlleraction',`folder`='library.controlleraction',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=library.controller\nautofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-gamepad',`pnamekey`='' WHERE  `namekey`='library.controlleraction';
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_1215,@dbtid_5,'0','library.controlleraction','library.controlleraction',@rolid_0,'0','1','0','0','mainmodel=library.controller\nautofld=1','','library','0','0','1','fa-gamepad','');
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=@dbtid_8,`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_5,@dbtid_8,'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_999,`dbtid`=@dbtid_8,`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,@dbtid_8,'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_856,`dbtid`=@dbtid_4,`path`='0',`namekey`='library.controllerroles',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=library.controller\nautofld=1',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='library.controllerroles';
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_856,@dbtid_4,'0','library.controllerroles','library',@rolid_0,'0','1','0','0','mainmodel=library.controller\nautofld=1','','library','0','0','1','fa-trophy','');

SET @wid_11 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='events.node' LIMIT 1);
SET @sid_12 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.viewmenus' LIMIT 1);
SET @sid_13 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controller' LIMIT 1);
SET @sid_14 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.actions' LIMIT 1);
SET @sid_15 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.action' LIMIT 1);
SET @sid_16 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events' LIMIT 1);
SET @rolid_17 = (8);
SET @rolid_18 = (9);
SET @rolid_19 = (48);
SET @rolid_20 = (7);
SET @yid_21 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_show' LIMIT 1);
SET @yid_22 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_action_form' LIMIT 1);
SET @yid_23 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_actions_show' LIMIT 1);
SET @yid_24 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_form' LIMIT 1);
SET @yid_25 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_form_core' LIMIT 1);
SET @yid_26 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_menu' LIMIT 1);
SET @sid_27 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='eventstrans' LIMIT 1);
SET @ref_yid_28 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_action_listing' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_show_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('events_show_events') LIMIT 1;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_show_row1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('events_show_column1') LIMIT 1;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_show_row2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('events_show_column1_1') LIMIT 1;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_form_general_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('events_form_column_1','controller_form_column_2_copy1422210453') LIMIT 2;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='controller_form_column_2_copy1422210453' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('controller_form_details_copy1422210453') LIMIT 1;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_form_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('events_form_general') LIMIT 1;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_show_events' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('events_show_library_controller_namekey','events_show_library_controller_task','events_show_library_controller_trigger','events_show_library_controller_publish','events_show_library_controller_ctrid') LIMIT 5;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_show_column1_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('events_show_action') LIMIT 1;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_action_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('events_action_form_library_action_folder','events_action_form_library_action_wid','events_action_form_library_action_status','events_action_form_library_action_params') LIMIT 4;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_action_form_code' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('events_action_form_action') LIMIT 1;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_actions_show_action' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('events_actions_show_library_controller_ctrid','events_actions_show_library_action_namekey','events_actions_show_library_action_wid','events_actions_show_library_action_status','events_actions_show_library_action_params') LIMIT 5;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_actions_show_events' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('events_actions_show_actid') LIMIT 1;
SET @p_1_12 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_12 WHERE `namekey` IN ('events_form_app','events_form_task','events_form_publish','events_form_admin','events_form_premium','events_form_controller_rolid','events_form_yid') LIMIT 7;
SET @p_1_13 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='controller_form_details_copy1422210453' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_13 WHERE `namekey` IN ('controller_form_controller_pnamekey_copy1422210453','events_form_controllertrans_name','events_form_controllertrans_description') LIMIT 3;
SET @p_1_14 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='controller_form_code_copy1422210453' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_14 WHERE `namekey` IN ('events_form_controller','events_form_controller_1') LIMIT 2;
SET @p_1_15 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='events_form_core__general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_15 WHERE `namekey` IN ('events_form_core_eventstrans_name','events_form_core_eventstrans_description','events_form_core_app','events_form_core_task','events_form_core_publish','events_form_core_admin','events_form_core_premium','events_form_core_yid') LIMIT 8;
SET @yid_29 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='library_formsmenus' LIMIT 1);
SET @yid_30 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_listing' LIMIT 1);
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='events_actions_listing' LIMIT 1);
SET @sid_32 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.view' LIMIT 1);
SET @sid_33 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.trigger' LIMIT 1);
SET @sid_34 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.controlleraction' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='events_listing_library_controller_namekey_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('events_listing_library_controllertrans_name','events_listing_library_controller_namekey','events_listing_library_controllertrans_description') LIMIT 3;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE'),('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Publish','1','1206732372QTKN'),('View','1','1206732388KEHZ'),('Controllers','1','1206732388KEIC'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Description','1','1206732392OZVG'),('Status','1','1206732392OZVH'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('ID','1','1206732400OWXG'),('General','1','1206732400OWZR'),('None','1','1206732410ICCJ'),('Access','1','1206732412DAEO'),('Filter','1','1206732423RNTL'),('Task','1','1206732425HINS'),('Default','1','1206732425HINT'),('Controller','1','1206732425HINW'),('Is this Controller accessible only to admins','1','1206732425HINX'),('Admin','1','1206732425HINY'),('Specify the view you want to associate with the event','1','1206732425HINZ'),('Add','1','1206732439BHWX'),('Action','1','1206961869IGNA'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Menu','1','1206961870KLBH'),('Back','1','1206961882TDHA'),('Code','1','1206961912MJQB'),('Details','1','1206961936HCWR'),('Before','1','1206961945HIVW'),('Published','1','1207306697RNMA'),('Role','1','1209142268NMKA'),('Controller code','1','1209746298RJII'),('Node','1','1211811528BLZA'),('Actions','1','1217251965LDTZ'),('The name of the folder / file for this action','1','1217251965LDUB'),('Choose the node to connection this action to','1','1217251965LDUC'),('The status value which will trigger this action','1','1217251965LDUD'),('Params','1','1217251965LDUE'),('Trigger','1','1219769905FKRL'),('Controller information','1','1219769913SSOS'),('Action code','1','1220272211DTNO'),('Extends','1','1220446694TBPU'),('<br><br>','1','1220793699CLWU'),('Grade','1','1227579895DRET'),('Close','1','1228820287MBVC'),('This will be the name seen by the user in the frontend of your website.<br>','1','1239111910ARQB'),('Choose a menu.','1','1239111910ARQC'),('Menu Name','1','1239111911FQGH'),('CMS menu','1','1239111911FQGI'),('Create Menu','1','1239111911FQGJ'),('You can add extra parameters to the url if it is necessary.<br>','1','1239870994APHY'),('Extra params','1','1239870995FKWO'),('Done','1','1242282449PIPC'),('Front-End Menus','1','1243437901LSSX'),('Event','1','1250070127LYIO'),('Events','1','1250070242QRDK'),('List of actions for event show','1','1250070242QRDM'),('List of Events','1','1250070242QRDO'),('No Change','1','1250145257BXGB'),('Change custom Event Access','1','1250145258KISY'),('Events Override','1','1250777201NOVJ'),('Events Back','1','1250777201NOVK'),('Here are all the details about this action.<br>At the bottom you will see a list of associated events.<br>','1','1251084267IPHE'),('Event Information','1','1251084267IPHF'),('Powerful Access Level tune up','1','1251517317JKUT'),('This view allows you to add menu in your CMS. It works like the <span style=\"color: rgb(204, 0, 0);\">Menu Item Manager</span> of Joomla.','1','1253938983RSNC'),('CMS Menu','1','1253938983RSND'),('This is the description that the administrator will see.','1','1257735566GJYL'),('Action information','1','1262788755ESJP'),('List of events for action show','1','1262788755ESJQ'),('<p>Here are all the details about this events.<br />\r\nAt the bottom you will see a list of associated actions.</p>','1','1262788755ESJR'),('Action Information','1','1262788755ESJS'),('Column 1','1','1298350843FMVJ'),('Column 2','1','1298350843FMVK'),('Save a new CMS Menu','1','1298546835PCUJ'),('','1','1304525968YBL'),('Action trigger','1','1346440529KXWF'),('If you do not know what to put here it is probably because you don\'t need to put anything.<br>','1','1346440530OZED'),('Code which will be executed for this action.<br>','1','1346440530OZEE'),('Enabling an action for a event','1','1377132741NGHQ'),('Click on the Yes / No link in the events column to enable or disable this action for the event.<br>If the action is enabled \"Yes\", it will be triggered when the event is called.<br>','1','1377132741NGHR'),('<p>This list shows all the events available on your website. Event are also called &quot;controller&quot; or &quot;action&quot; for the more tech savvy.</p>\r\n\r\n<ul>\r\n	<li>Using the column <strong>New Access</strong> you can change the access to this event with a custom role. This enables you to fine tune each access to your website with the extremely fine granularity.</li>\r\n	<li><strong>Override</strong> define how the access of each view element should be overwritten. It is recommended to use <em>&quot;Automatic</em>&quot;. &quot;<em>Only Same Role</em>&quot; overwrite only the same role defined by the event ( default role ). Whereas &quot;<em>All Roles</em>&quot; provide access to all elements of the view regardless of the default access. This last option is not recommended as it can give access to information to undesirable users.</li>\r\n	<li><strong>Admin</strong> column tells you if the event is for the front-end or back-end of your website.</li>\r\n</ul>','1','1385690069AGSH'),('row1','1','1394069593IQAQ'),('row2','1','1394069593IQAR'),('column1','1','1394069593IQAS'),('Identifier','1','1398436917DTKC'),('Choose an SMS','1','1408411565AGZI'),('Parent Controller','1','1434117647OYCE'),('Give a name to this controller.','1','1434117648GRDZ'),('Define what role has access to this controller','1','1434117648GREA'),('If this Controller has a parent please enter the identifier of the parent controller.','1','1434117648GREB'),('Core controller cannot be deleted!','1','1434643123QBFI');
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_node_yid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475yid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_app_task_admin' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475app' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_app_task_admin' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475task' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_publish_premium_level' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_publish_premium_level' LIMIT 1),'1','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_node_wid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_controller_publish_premium_level' LIMIT 1),'1','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475premium' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_app_task_admin' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475admin' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_controller_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_action_node_namekey' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_action_node_wid_publish' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_action_node_wid_publish' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_eguillage_trans|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714ctrid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_eguillage_trans|main_library' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_eguillage_roles' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='804ctrid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_eguillage_action|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1032ctr_action_id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_eguillage_action_ctrid_publish' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctrid1032' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_eguillage_action_ctrid_publish' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish1032' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_eguillage_action_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey1032' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_campaign_actionstype|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3418cmpgnactstpid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_campaign_actionstype' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey3418' LIMIT 1));
SET @ref_feid_35 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1);
SET @pk_77_1003 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_7 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'475yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_622 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_8 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'475wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10390 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'475rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10529 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_8 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'622wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10546 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'622rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10714 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'714ctrid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10715 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.languages\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'714lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10836 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'804ctrid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10834 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid804\' LIMIT 1' LIMIT 1 );
SET @pk_77_10835 = ( 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`=\'uid804\' LIMIT 1' LIMIT 1 );
SET @pk_77_11220 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'ctrid1032\' LIMIT 1' LIMIT 1 );
SET @pk_77_11221 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'actid1032\' LIMIT 1' LIMIT 1 );
SET @pk_77_11390 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid3418\' LIMIT 1' LIMIT 1 );
SET @pk_77_11391 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'members.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid3418\' LIMIT 1' LIMIT 1 );
SET @pk_77_11399 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'mailing.statistics.user\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'created3418\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('yid','1','FK_controller_yid',@pk_77_1003,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475yid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1),'1','1','yid',@dbtid_7,@dbtid_1,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','1','FK_controller_wid',@pk_77_622,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',@dbtid_8,@dbtid_1,'2'),('rolid','1','FK_controller_rolid',@pk_77_10390,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475rolid' LIMIT 1),@ref_feid_35,'1','1','',@dbtid_9,@dbtid_1,'3'),('wid','1','FK_action_wid',@pk_77_10529,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','',@dbtid_8,@dbtid_2,'1'),('rolid','1','FK_action_rolid',@pk_77_10546,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622rolid' LIMIT 1),@ref_feid_35,'1','1','rolid',@dbtid_9,@dbtid_2,'2'),('ctrid','1','FK_controller_ctrlid',@pk_77_10714,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714ctrid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475ctrid' LIMIT 1),'3','3','ctrid',@dbtid_1,@dbtid_3,'1'),('lgid','1','FK_controller_lgid',@pk_77_10715,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='714lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','1','lgid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1),@dbtid_3,'2'),('ctrid','1','FK_controller_ctrid',@pk_77_10836,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='804ctrid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475ctrid' LIMIT 1),'3','3','ctrid',@dbtid_1,@dbtid_4,'1'),('rolid','1','804_rolid_566',@pk_77_10834,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid804' LIMIT 1),@ref_feid_35,'1','1','rolid',@dbtid_9,@dbtid_4,'2'),('uid','1','804_uid_232',@pk_77_10835,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid804' 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_4,'3'),('ctrid','1','FK_eguillage_action_ctrid',@pk_77_11220,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctrid1032' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='475ctrid' LIMIT 1),'3','3','ctrid',@dbtid_1,@dbtid_5,'1'),('actid','1','FK_eguillage_actid',@pk_77_11221,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='actid1032' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='622actid' LIMIT 1),'1','3','actid',@dbtid_2,@dbtid_5,'2'),('rolid','1','FK_campaign_actionstype_rolid',@pk_77_11390,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid3418' LIMIT 1),@ref_feid_35,'1','1','rolid',@dbtid_9,@dbtid_6,'99'),('uid','1','FK_campaign_actionstype_uid',@pk_77_11391,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3418' 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_6,'99'),('created','1','FK_actions_type_created',@pk_77_11399,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created3418' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created3389' LIMIT 1),'1','1','created',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.statistics.user' LIMIT 1),@dbtid_6,'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_11,'2','1206732372QTKI');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_11,'2','1206732372QTKJ'),(@wid_11,'1','1206732410ICCJ'),(@wid_11,'1','1250145257BXGB'),(@wid_11,'1','1408411565AGZI'),(@wid_11,'0','1434643123QBFI');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_11),'','','','','','','','','','','0','');
SET @dbcid_36 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.actions' LIMIT 1),'1206961869IGNA',@wid_11);
INSERT IGNORE INTO `#__translation_populate` (`dbcid`,`eid`,`imac`,`wid`) VALUES (@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.trigger' LIMIT 1),'1346440529KXWF',@wid_11),(@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.actionstype' LIMIT 1),'1206961869IGNA',@wid_11),(@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events' LIMIT 1),'1250070127LYIO',@wid_11),(@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='eventstrans' LIMIT 1),'1250070127LYIO',@wid_11),(@dbcid_36,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='events.roles' LIMIT 1),'1209142268NMKA',@wid_11);