/*Export of the extension output.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('1242179632IZKM','1206732390BJKP','1217601376NASF','1356733768PTQS','1356733768PTQT','1219769904NDIF','1219769904NDJE','1206961877KAKC','1233298081OPDQ','1356733768PTQU','1219769905FKQA','1206961850KLRI','1206961850KLRQ','1356733768PTRD','1219769905FKPK','1309938386RWTW','1356733768PTRE','1357059111JYQB','1206961869IGOF','1357059111JYQC','1358294812QEQU','1358294812QEQV','1356733769MICK','1356733769MICL','1356733769MICM','1356733769MICN','1356733769MICO','1356733769MICP','1356733769MICQ','1357059111JYQD','1356733769MICS','1356733769MICT','1356733769MICU','1356733769MIDF','1356733769MIDG','1356733769MIDH','1356733769MIDI','1304525968YBL','1357059112CQZW','1356733769MICR','1358294813IZWE','1358294813IZWF','1356715487MNCJ','1206732400OWYY','1356733769MIDJ','1206732412DADP','1206732388KEHY','1299065715KKOP','1206732361LXFE','1206732363AOLD','1206732365OQJI','1206732365OQJJ','1206732365OQJK','1206732366OVLX','1206732366OVLZ','1206732366OVMA','1206732366OVMB','1206732366OVMC','1206732366OVMD','1206732366OVME','1206732366OVMF','1206732368LJDG','1206732369EREV','1206732370TAOI','1206732372QTKI','1206732372QTKJ','1206732372QTKK','1206732372QTKL','1206732372QTKM','1206732372QTKN','1206732372QTKO','1206732372QTKP','1206732372QTKR','1206732374FDLI','1206732374FDLM','1206732374FDLN','1206732374FDLO','1206732374FDLP','1206732374FDLQ','1206732375LZCH','1206732375LZCI','1206732375LZCJ','1206732391QBUR','1206732392OZUP','1206732410ICCJ','1206732431CQBG','1206961912MJPF','1207306697RNMA','1209056511OBNE','1209746189NUCP','1212843293BKVE','1213285201QMJN','1213369322GXOW','1213369322GXOX','1216230542PQQV','1219769904NDHQ','1219769904NDIM','1233626551NWXV','1241675239ROHF','1242048721QUXH','1242282416HAQR','1242282450QJCN','1242282450QJCO','1242822624LPVJ','1256627078COLC','1256875124DIGY','1262788661GLZO','1263549766QJON','1307373851DVDT','1307373851DVDU','1317297448JZYW','1327354737PCAU','1340849910KWVC','1342303504IJSM','1357059105KDVU','1360107637HVSN','1360160364KSSI','1360160364KSSJ','1360160364KSSK','1360160364KSSL','1374187342THQQ','1377041362DLBN','1377041362DLCE','1377041362DLCF','1379006374DSAU','1379006374DSBC','1379039059BHZA','1380025960NDBN','1380025974HAXP','1380025983FUVQ','1380567318QTUF','1383923815RCSI','1398304276OSSP','1398304276OSSQ','1398304276OSSR','1398304276OSSS','1398304276OSST','1414741455RKJF','1415301710DJEQ','1415301710DJER','1415301710DJES','1415377870CWLZ','1416059367SCLE','1417074723POOW','1417893375KBQT','1427486118NNQO','1427652827KXNP','1427652827KXNQ','1427652827KXNR','1427652827KXNS','1427652827KXNT','1427652827KXNU','1434028549ILUR' );
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('layout.multiformstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','481wname','481wdescription','714ctrid','714lgid','name714','description714','auto481','fromlgid481','auto482','fromlgid482','auto714','fromlgid714') AND `#__dataset_columns`.`core` = 1  ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('output.node') ;
SET @rolid_0 = (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_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','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 ('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @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_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_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');
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_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_3408,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0');
SET @pk_5_463 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='output.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='output',`wid`=@pk_5_463,`params`='',`status`='1',`type`='150',`name`='Output',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='output.node',`version`='4389',`lversion`='4389',`pref`='0',`install`='',`core`='1',`showconfig`='0',`framework`='0' WHERE  `namekey`='output.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','output',@pk_5_463,'','1','150','Output','node','0','1','0','output.node','4389','4389','0','','1','0','0');

SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_5,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');

SET @wid_1 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='output.node' LIMIT 1);
SET @wid_2 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='main.node' LIMIT 1);
SET @yid_3 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='output_params_listing_output_text' LIMIT 1);
SET @yid_4 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='output_params_form_output_textarea' LIMIT 1);
SET @did_5 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='main_format_date' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='output_params_listing_output.text_link' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('output_params_listing_output.text_link_url','output_params_listing_output.text_link_popuplink','output_params_listing_output.text_link_opow','output_params_listing_output.text_link_poph') LIMIT 4;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');

INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Yes to open the link in a popup.<br><br>','1','1356733769MIDG'),('Specify the width of the popup window.<br>','1','1356733769MIDH'),('Specify the height of the popup window.<br><br>','1','1356733769MIDI'),('Date & Time','1','1356733769MIDJ'),('New / Edit','1','1357059105KDVU'),('Number of choices','1','1357059111JYQB'),('Choose Pick-list','1','1357059111JYQC'),('Specify the size of the input box in number of characters.<br>','1','1357059111JYQD'),('<u>Single</u>: the user will be able to select only one choice from the list. ( e.g.: gender: male or female ). This is the default option and most common.<br><u>Multiple</u>: the user will be able to select multiple choice from the list ( e.g.: a list of hobbies ).<br>','1','1357059112CQZW'),('Process CMS Content','1','1358294812QEQU'),('Process Joobi tags','1','1358294812QEQV'),('Yes to process the content through the CMS content plugin.<br>eg: Joomla articles.<br>','1','1358294813IZWE'),('Yes to process any tags in the content.<br>','1','1358294813IZWF'),('Allowed files: ','1','1360107637HVSN'),('File uploaded','1','1360160364KSSI'),('File/chunk uploaded','1','1360160364KSSJ'),('File size not allowed.','1','1360160364KSSK'),('File extension ( $FILE_EXTENSION ) not allowed.','1','1360160364KSSL'),('Average','1','1374187342THQQ'),('Tag to replace parameters','1','1377041362DLBN'),('Used for instance in emails','1','1377041362DLCE'),('Used in page theme.','1','1377041362DLCF'),('Widget to use constant','1','1379006374DSAU'),('Widget used some predefined constant.','1','1379006374DSBC'),('Use this widget to render an entire view.','1','1379039059BHZA'),('Example : {widget:define|name=SITENAME}','1','1380025960NDBN'),('VIew: the access to this page is restricted.','1','1380025974HAXP'),('View:form: the access to this page is restricted.','1','1380025983FUVQ'),('Render a view','1','1380567318QTUF'),('Clear','1','1383923815RCSI'),('The default theme was not found!','1','1398304276OSSP'),('The files for the theme $THEMENAME were not found!','1','1398304276OSSQ'),('Either the theme selected is not installed or some files have been removed!','1','1398304276OSSR'),('The system find another theme and it automatically switched. Please refresh the page to see if the other theme works better!','1','1398304276OSSS'),('Should you have any futher question please contact support!','1','1398304276OSST'),('No data to display','1','1414741455RKJF'),('This','1','1415301710DJEQ'),('The field \"$FIELDNAME\" is required!','1','1415301710DJER'),('The field \"$FIELDNAME\" can\'t contain whitespace!','1','1415301710DJES'),('This field can\'t contain whitespace!','1','1415377870CWLZ'),('All / None','1','1416059367SCLE'),('Enter an alternative value...','1','1417074723POOW'),('Terms and Conditions needs to be checked!','1','1417893375KBQT'),('In Progress...','1','1427486118NNQO'),('Calculating...','1','1427652827KXNP'),('The execution of the process has stopped completely because the maximum number of attempts has been reached.','1','1427652827KXNQ'),('The process stopped temporarily! Either your server is slow to respond or the internet connection was lost. Retrying in <span id=\"WAjxErrorTime\">ZZZZ</span> seconds...','1','1427652827KXNR'),('Oops... it seems you lost the internet connection, checking for connectivity','1','1427652827KXNS'),('Your internet connection works fine!','1','1427652827KXNT'),('Could not find an internet connection, please check your connection!','1','1427652827KXNU'),('Widget used to replace a theme area','1','1434028549ILUR');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_1,'2','1206732361LXFE');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_1,'2','1206732363AOLD'),(@wid_1,'2','1206732365OQJI'),(@wid_1,'2','1206732365OQJJ'),(@wid_1,'1','1206732365OQJK'),(@wid_1,'2','1206732366OVLX'),(@wid_1,'2','1206732366OVLZ'),(@wid_1,'2','1206732366OVMA'),(@wid_1,'2','1206732366OVMB'),(@wid_1,'2','1206732366OVMC'),(@wid_1,'2','1206732366OVMD'),(@wid_1,'2','1206732366OVME'),(@wid_1,'2','1206732366OVMF'),(@wid_1,'1','1206732368LJDG'),(@wid_1,'2','1206732369EREV'),(@wid_1,'0','1206732370TAOI'),(@wid_1,'2','1206732372QTKI'),(@wid_1,'2','1206732372QTKJ'),(@wid_1,'2','1206732372QTKK'),(@wid_1,'2','1206732372QTKL'),(@wid_1,'2','1206732372QTKM'),(@wid_1,'2','1206732372QTKN'),(@wid_1,'2','1206732372QTKO'),(@wid_1,'2','1206732372QTKP'),(@wid_1,'2','1206732372QTKR'),(@wid_1,'2','1206732374FDLI'),(@wid_1,'2','1206732374FDLM'),(@wid_1,'2','1206732374FDLN'),(@wid_1,'2','1206732374FDLO'),(@wid_1,'2','1206732374FDLP'),(@wid_1,'2','1206732374FDLQ'),(@wid_1,'2','1206732375LZCH'),(@wid_1,'2','1206732375LZCI'),(@wid_1,'2','1206732375LZCJ'),(@wid_1,'2','1206732391QBUR'),(@wid_1,'2','1206732392OZUP'),(@wid_1,'2','1206732410ICCJ'),(@wid_1,'1','1206732431CQBG'),(@wid_1,'1','1206961912MJPF'),(@wid_1,'2','1207306697RNMA'),(@wid_1,'2','1209056511OBNE'),(@wid_1,'2','1209746189NUCP'),(@wid_1,'0','1212843293BKVE'),(@wid_1,'2','1213285201QMJN'),(@wid_1,'0','1213369322GXOW'),(@wid_1,'0','1213369322GXOX'),(@wid_1,'1','1216230542PQQV'),(@wid_1,'2','1219769904NDHQ'),(@wid_1,'2','1219769904NDIM'),(@wid_1,'1','1233626551NWXV'),(@wid_1,'1','1241675239ROHF'),(@wid_1,'2','1242048721QUXH'),(@wid_1,'2','1242282416HAQR'),(@wid_1,'2','1242282450QJCN'),(@wid_1,'2','1242282450QJCO'),(@wid_1,'1','1242822624LPVJ'),(@wid_1,'0','1256627078COLC'),(@wid_1,'2','1256875124DIGY'),(@wid_1,'0','1262788661GLZO'),(@wid_1,'0','1263549766QJON'),(@wid_1,'2','1307373851DVDT'),(@wid_1,'2','1307373851DVDU'),(@wid_1,'0','1317297448JZYW'),(@wid_1,'2','1327354737PCAU'),(@wid_1,'1','1340849910KWVC'),(@wid_1,'2','1342303504IJSM'),(@wid_1,'1','1357059105KDVU'),(@wid_1,'1','1360107637HVSN'),(@wid_1,'1','1360160364KSSI'),(@wid_1,'1','1360160364KSSJ'),(@wid_1,'1','1360160364KSSK'),(@wid_1,'1','1360160364KSSL'),(@wid_1,'1','1374187342THQQ'),(@wid_1,'1','1377041362DLBN'),(@wid_1,'1','1377041362DLCE'),(@wid_1,'1','1377041362DLCF'),(@wid_1,'1','1379006374DSAU'),(@wid_1,'1','1379006374DSBC'),(@wid_1,'1','1379039059BHZA'),(@wid_1,'0','1380025960NDBN'),(@wid_1,'0','1380025974HAXP'),(@wid_1,'0','1380025983FUVQ'),(@wid_1,'1','1380567318QTUF'),(@wid_1,'2','1383923815RCSI'),(@wid_1,'1','1398304276OSSP'),(@wid_1,'1','1398304276OSSQ'),(@wid_1,'1','1398304276OSSR'),(@wid_1,'1','1398304276OSSS'),(@wid_1,'1','1398304276OSST'),(@wid_1,'1','1414741455RKJF'),(@wid_1,'2','1415301710DJEQ'),(@wid_1,'2','1415301710DJER'),(@wid_1,'2','1415301710DJES'),(@wid_1,'2','1415377870CWLZ'),(@wid_1,'1','1416059367SCLE'),(@wid_1,'1','1417074723POOW'),(@wid_1,'1','1417893375KBQT'),(@wid_1,'1','1427486118NNQO'),(@wid_1,'1','1427652827KXNP'),(@wid_1,'1','1427652827KXNQ'),(@wid_1,'1','1427652827KXNR'),(@wid_1,'1','1427652827KXNS');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_1,'1','1427652827KXNT'),(@wid_1,'1','1427652827KXNU'),(@wid_1,'1','1434028549ILUR');