/*Export of the extension design.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1335905452QHTH','1206732388KEHV','1206732389NXTO','1356698583QHMX','1206961869IGNH','1212761197FHZN','1206732388KEHY','1206961878BMAO','1359742651HQYX','1206732412DAEO','1211811583DBTA','1398436917DTKC','1206732372QTKN','1206732392OZVB','1206732392OZVG','1355434007BBZS','1355852782MQER','1209034856HUVS','1217603897AYYA','1347652452OQAE','1206732389NXTA','1355852783DYRA','1355852783DYRB','1217251965LDUE','1212669853FLEL','1355852783DYRC','1356698583QHMZ','1206961869IGND','1213200894KHAM','1335905027HUYP','1206732392OZVD','1211811557LMRL','1298350843FMVJ','1298350843FMVK','1356698583QHNE','1206732421RJQZ','1211811557LMRI','1206961877KAKC','1219769904NDIO','1206732411EGQO','1233297975SESK','1356698583QHNF','1357230914NZVE','1356698583QHNH','1356698583QHNI','1227580858CXTV','1356698583QHNJ','1357230914NZVF','1206732400OWZR','1206961869IGOF','1209675038APRU','1357058841KKEQ','1206961869IGNP','1206732399EINB','1357058841KKER','1242282439OJUW','1206732425HINT','1220793707SOED','1382068744SDQH','1394069593IQAS','1394069593IQAT','1394069857XFX','1395500493HQVV','1394069593IQAQ','1394069593IQAR','1206961869IGNB','1242282452RPKT','1400708900IRZT','1400708900IRZU','1206732400OWYY','1219769905FKPU','1206961869IGNO','1356733768PTQW','1400788093LHUB','1400788093LHUC','1400788093LHUD','1400788093LHUE','1400812016CMWY','1409860322PSNC','1409860322PSND','1409955038JEIA','1417090743CGRN','1395886787SVJW','1304525968YBL','1355852784RQNP','1355852784RQNQ','1356698584EBNZ','1356698584EBOA','1356698584EBOB','1356698584EBOC','1356698584EBOD','1356698584EBOE','1356698584EBOF','1356698584EBOG','1356698584EBOH','1356698584EBOI','1356698584EBOJ','1356698584EBOK','1219769906LJNO','1418398709LVIH','1219769906LJNM','1421361227IJHC','1417090743CGRO','1357058841KKET','1357058841KKEU','1357058841KKEV','1383926331ELHS','1400708900IRZV','1400708900IRZW','1400708900IRZX','1400708900IRZY','1400708900IRZZ','1400708901APLS','1400788093LHUF','1400788093LHUG','1400812017YLA','1409860322PSNE','1409860322PSNF','1409955038JEIB','1417090743CGRP','1418398709LVII','1206732361LXFD','1206732361LXFE','1206732372QTKL','1242282449PIPC','1206732393CXVV','1206732399EINC','1206961882TDHA','1206732392OZUP','1206732399EINF','1206961996STAF','1206732372QTKK','1206732391QBUR','1228820287MBVC','1206961854HENY','1206732411EGRN','1206732392OZVA','1206961869IGNE','1206961850KLRI','1206732400OWXG','1302502783BNRP','1212662234CPQC','1355852601LJIH','1356698583QHMY','1356698583QHNA','1206732421RJQW','1206961869IGNC','1206732388KEHZ','1380064817JISM','1356698583QHNB','1356698583QHNC','1206732389NXTC','1357697641QROB','1206732412DAEM','1380228929NBOQ','1417207362AUVU','1417207362AUVV','1356698584EBOL','1356698584EBOM','1206732420EIUR','1209559180DARX','1219769913SSOH','1400708901APLT','1400708901APLU','1356733772QJIA','1359486554KQXA','1359486554KQXB','1357138793DWSZ','1382669061IVFW','1359486555TEWI','1418159507MBBP','1357138793DWTA','1327708944HAPH','1357058839QZXV','1357058839QZXW','1206732372QTKM','1206732405TIXC','1206961870KLBH','1219769904NDIJ','1219769904NDIP','1220215719BHFI','1220215906LFIQ','1220263310JRFM','1220263310JRFN','1220263310JRFO','1220263310JRFP','1220263310JRFR','1242282434IPJB','1242282450QJCF','1251298684SHUH','1263970750NGKF','1309938333EEVB','1309938333EEVC','1309938333EEVD','1309938333EEVE','1309938525PUJW','1309938525PUJX','1309938525PUJY','1356698577BYSZ','1356698577BYTA','1356698582LCCK','1357058833TGKT','1357058839QZXR','1357058839QZXS','1357058839QZXT','1357058839QZXU','1357058839QZXX','1357138790PDJD','1369750859IGJB','1369750869THVV','1375977746FUII','1387417576HDLZ','1397855844SRLO','1400708734QLWH','1403978942AEUG','1418159512LBWK','1418694571IHYE','1418694571IHYF','1418694571IHYG','1423647407JIHV' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('dropset.node','layout.listings','layout.multiforms','layout.multiformstrans','layout.listingstrans','dropset.trans','dropset.valuestrans','model.trans','dataset.columns','model.node','dropset.values','model.fields','fields.node','fields.trans','model.fieldstrans','layout.fields','model.fields.type') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('layout.multiforms','layout.listings','dropset.node','dropset.values','layout.multiformstrans','layout.listingstrans','dropset.trans','dropset.valuestrans','dataset.columns','model.trans','model.node','model.fields','fields.node','fields.trans','model.fieldstrans','layout.fields','model.fields.type','layout.node','extension.node','members.node','joobi.languages','dataset.tables','role.node','layout.mlinkstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('1yid','1type','1sid','1required','1readonly','1publish','1parent','1params','1ordering','1modified','1map','1level','1initial','1hidden','1fid','1core','2yid','2wizard','2wid','2type','2publish','2params','2namekey','2modified','2menu','2frontend','2created','2level','3yid','3type','3sid','3search','3publish','3parent','3params','3ordering','3modified','3map','3lid','3level','3hidden','3core','4wid','4core','4outype','4map','4params','4modified','4publish','4type','4did','5publish','5folder','5wid','5params','5status','5type','5name','6vid','6publish','6params','6ordering','6modified','6did','2subtype','4namekey','4ref_sid','4first_all','4first_value','4first_caption','4external','2dropdown','4lib_ext','2pagination','2filters','1did','232uid','4sid','199lgid','199code','199premium','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','4level','232html','2private','1private','232registered','199name','199main','199publish','199real','1area','1ref_yid','1frame','232unsub','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','5destination','3did','5parent','5trans','512did','512lgid','512name','512description','484description','5certify','2core','2sid','5namekey','232login','5version','2form','5lversion','2icon','199rtl','6level','6rolid','541vid','541name','6value','6valuetxt','549dbid','549name','549namekey','5pref','549modified','549dbtid','541lgid','1ref_wid','3ref_wid','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','2tmid','2rolid','4rolid','3rolid','1rolid','5rolid','566type','2alias','5install','3namekey','1namekey','6premium','199availadmin','199availsite','616dbcid','616dbtid','616name','616pkey','616checkval','616type','616attributes','616mandatory','616default','616ordering','616level','616rolid','616created','549prefix','549version','549rolid','549level','549type','549pkey','618sid','618lgid','618name','621sid','621dbtid','621path','621namekey','621folder','621rolid','621level','621publish','621created','621extended','621checkval','621params','549suffix','549group','621alias','199locale','566depth','616extra','616size','616export','621prefix','199localeconv','621ordering','616namekey','ordering5','core5','domaine549','suffix621','core616','export549','exportdelete549','visibility232','modified5','columntype616','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto512','fromlgid512','auto541','fromlgid541','auto618','fromlgid618','auto714','fromlgid714','namekey6','curid232','extstid621','j16566','ip232','ctyid232','994fdid','namekey994','type994','rolid994','uid994','core994','publish994','created994','modified994','995fieldid','996fieldid','996lgid','name996','description996','auto996','fromlgid996','namekey995','alias995','rolid995','uid995','core995','publish995','created995','modified995','wid995','params995','listing995','form995','fields621','sid994','searchable994','rolid_edit994','params994','998fdid','998lgid','name998','description998','auto998','fromlgid998','initialvalue994','real995','column994','required994','ordering995','category995','fields2','999yid','999fdid','fdid3','fdid1','ordering994','parentdft1','parentdft3','parent999','updateall994','parent2','dbcid994','visible995','translate995','translate994','checkout621','trash621','audit621','modified621','checktype1','1008fdid','1008typeid','totalcustom621','reload5','reload2','reload621','created4','reload4','core199','core621','widgets2','advsearch3','advordering3','noaudit549','noaudit616','core6','advsearchable994','created5','mobile232','icon621','faicon2','filid232','automatic199','xsvisible1','xshidden1','xsvisible3','xshidden3','color6','useredit2','devicevisible1','devicehidden1','devicevisible3','devicehidden3','parent4','parent6','isparent4','inputbox6','pnamekey621','showconfig5','framework5','allowothers4','message485','colorstyle4','parentkey2','engine549','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 ('4wid','1yid','3yid','6did','1did','4sid','1sid','482fid','482lgid','484lid','484lgid','3did','512did','512lgid','3sid','4rolid','3rolid','1rolid','6rolid','541vid','541lgid','616rolid','618sid','618lgid','621dbtid','621rolid','616dbtid','1parent','3parent','1ref_yid','4ref_sid','rolid994','uid994','rolid995','uid995','996fieldid','996lgid','sid994','998fdid','998lgid','999yid','999fdid','fdid3','fdid1','parent999','type994','wid995','1008fdid','parent4','parent6') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_model_fields_type_fdid','FK_layout_multiforms_did','FKParent_fid','FK_multiforms_layout_nestedlayout','FK_view_forms_rolid','FK_layout_multiforms_sid','FK_layout_multiforms_yid','FK_listings_dropset_did','FK_Parent3_parentlid','FK_view_listings_rolid','FK_view_listings_sid','FK_layout_listings_yid','FK_layout_multiformstrans_fid','FK_layout_multiformstrans_lgid','FK_layout_listingstrans_lgid','FK_layout_listingstrans_lid','FK_dropset_node_ref_sid','FK_picklist_rolid','FK_dropset_node_sid','FK_dropset_node_wid','FK_picklist_trans_did','FK_picklist_trans_lgid','FK_picklist_valuestrans_lgid','FK_picklist_valuestrans_vid','FK_dataset_columns_dbtid','FK_dataset_columns_rolid','FK_model.trans_lgid','FK_model.trans_sid','FK_model_dbtid','FK_model_rolid','FK_dropset_values_did','FK_picklist_values_rolid','FK_fields_trans_fields_node_fieldid','FK_fileds_trans_languages_lgid','FK_model_fieldstrans_fdid','FK_model_fieldstrans_lgid','FK_layout_fields_fdid','FK_layout_fields_yid','FK_layout_forms_fdid','FK_layout_listings_fdid','FK_dropset_node_parent','FK_dropset_values_parent','FK_layout_fields_parent','FK_model_fields_rolid','FK_fields_node_rolid','FK_model_fields_sid','FK_model_fields_fieldid','FK_model_fields_uid','FK_fields_node_uid','FK_fields_node_wid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('design.node') ;
SET @rolid_0 = (1);
SET @pk_549_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1 );
SET @pk_549_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1 );
SET @pk_549_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1 );
SET @pk_549_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.values' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_512 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.trans' LIMIT 1 );
SET @pk_549_541 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1 );
SET @pk_549_616 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.columns' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_621 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' LIMIT 1 );
SET @pk_549_994 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1 );
SET @pk_549_995 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.node' LIMIT 1 );
SET @pk_549_996 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.trans' LIMIT 1 );
SET @pk_549_998 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fieldstrans' LIMIT 1 );
SET @pk_549_999 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.fields' LIMIT 1 );
SET @pk_549_1008 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields.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_549 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.tables' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_1014 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' 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_multiforms','layout.multiforms',@pk_549_1,'','1.0.0',@rolid_0,'0','10','fid','multiforms','layout','9','0','1','1','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('layout_listings','layout.listings',@pk_549_3,'','1.0.0',@rolid_0,'0','10','lid','listings','layout','9','0','1','1','7'),('dropset_node','dropset.node',@pk_549_4,'','1.0.0',@rolid_0,'0','1','did','node','dropset','9','0','0','1','7'),('dropset_values','dropset.values',@pk_549_6,'','1.0.0',@rolid_0,'0','1','vid','values','dropset','9','0','1','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_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('dropset_trans','dropset.trans',@pk_549_512,'','1.0.0',@rolid_0,'0','20','did,lgid','trans','dropset','9','2','0','1','7'),('dropset_valuestrans','dropset.valuestrans',@pk_549_541,'','1.0.0',@rolid_0,'0','20','vid,lgid','valuestrans','dropset','9','0','0','1','7'),('dataset_columns','dataset.columns',@pk_549_616,'','1.0.0',@rolid_0,'0','1','dbcid','columns','db','9','0','1','1','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('model_node','model.node',@pk_549_621,'','1.0.0',@rolid_0,'0','1','sid','node','model','9','0','0','1','7'),('model_fields','model.fields',@pk_549_994,'','',@rolid_0,'0','1','fdid','','','9','2','0','1','7'),('fields_node','fields.node',@pk_549_995,'','',@rolid_0,'0','1','fieldid','','','9','0','0','1','7'),('fields_trans','fields.trans',@pk_549_996,'','',@rolid_0,'0','20','fieldid,lgid','','','9','0','0','1','7'),('model_fieldstrans','model.fieldstrans',@pk_549_998,'','',@rolid_0,'0','20','fdid,lgid','','','9','2','0','1','7'),('layout_fields','layout.fields',@pk_549_999,'','',@rolid_0,'0','30','yid,fdid','','','9','2','0','1','7'),('model_fields_type','model.fields.type',@pk_549_1008,'','',@rolid_0,'0','10','fdid,typeid','','','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'),('dataset_tables','dataset.tables',@pk_549_549,'','1.0.0',@rolid_0,'0','1','dbtid','tables','db','9','0','0','1','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('widgets_node','widgets.node',@pk_549_1014,'','',@rolid_0,'0','1','widgetid','','','51','2','0','0','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_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.trans' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.valuestrans' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.columns' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.node' LIMIT 1);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.values' LIMIT 1);
SET @dbtid_12 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields' LIMIT 1);
SET @dbtid_13 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.node' LIMIT 1);
SET @dbtid_14 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='fields.trans' LIMIT 1);
SET @dbtid_15 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fieldstrans' LIMIT 1);
SET @dbtid_16 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.fields' LIMIT 1);
SET @dbtid_17 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.fields.type' LIMIT 1);
SET @pk_454_8 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_node_namekey' LIMIT 1 );
SET @pk_454_1007 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_dropset_node_wid_publish_level_rolid' LIMIT 1 );
SET @pk_454_1012 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_listing_yid_publish_level_rolid_hidden_ordering' LIMIT 1 );
SET @pk_454_1014 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_multiform_yid_publish_level_rolid_ordering' LIMIT 1 );
SET @pk_454_47962 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_listings_namekey' LIMIT 1 );
SET @pk_454_47964 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_forms_namekey' LIMIT 1 );
SET @pk_454_65431 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1 );
SET @pk_454_65432 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1 );
SET @pk_454_65444 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklisttrans_did_lgid' LIMIT 1 );
SET @pk_454_65456 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklist_valuestrans_vid_lgid' LIMIT 1 );
SET @pk_454_65490 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_trans_sid_lgid' LIMIT 1 );
SET @pk_454_65496 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_dataset_columns' LIMIT 1 );
SET @pk_454_65498 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_node_sid' LIMIT 1 );
SET @pk_454_65523 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_model_node_namekey' LIMIT 1 );
SET @pk_454_65532 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dataset_columns' LIMIT 1 );
SET @pk_454_65544 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_listings_lid' LIMIT 1 );
SET @pk_454_65549 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dbtid_columnname' LIMIT 1 );
SET @pk_454_65667 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_multiforms_fid' LIMIT 1 );
SET @pk_454_65700 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_values_did_value' LIMIT 1 );
SET @pk_454_65702 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_values_namekey' LIMIT 1 );
SET @pk_454_65857 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1 );
SET @pk_454_65865 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_dbtic' LIMIT 1 );
SET @pk_454_65971 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fields|main_library' LIMIT 1 );
SET @pk_454_65972 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_model_fields' LIMIT 1 );
SET @pk_454_65973 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_fields_node|main_library' LIMIT 1 );
SET @pk_454_65974 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_fields_trans|main_library' LIMIT 1 );
SET @pk_454_65975 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_fields_node' LIMIT 1 );
SET @pk_454_65978 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fieldstrans|main_library' LIMIT 1 );
SET @pk_454_65979 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_layout_fields|main_library' LIMIT 1 );
SET @pk_454_65989 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fields_type|main_userdata' LIMIT 1 );
SET @pk_454_65863 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_dataset_columns_dbid' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_8,'1','UK_dropset_node_namekey',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_1007,'2','IX_dropset_node_wid_publish_level_rolid',@dbtid_1),(@pk_454_1012,'2','IX_layout_listing_yid_publish_level_rolid_hidden_ordering',@dbtid_2),(@pk_454_1014,'2','IX_layout_multiform_yid_publish_level_rolid_ordering',@dbtid_3),(@pk_454_47962,'1','UK_layout_listings_namekey',@dbtid_2),(@pk_454_47964,'1','UK_layout_forms_namekey',@dbtid_3),(@pk_454_65431,'3','PK_view_formstrans_fid_lgid',@dbtid_4),(@pk_454_65432,'3','PK_view_listingstrans_lid_lgid',@dbtid_5),(@pk_454_65444,'3','PK_picklisttrans_did_lgid',@dbtid_6),(@pk_454_65456,'3','PK_picklist_valuestrans_vid_lgid',@dbtid_7),(@pk_454_65490,'3','PK_model_trans_sid_lgid',@dbtid_8),(@pk_454_65496,'3','PK_dataset_columns',@dbtid_9),(@pk_454_65498,'3','PK_model_node_sid',@dbtid_10),(@pk_454_65523,'1','UK_model_node_namekey',@dbtid_10),(@pk_454_65532,'1','UK_dataset_columns',@dbtid_9),(@pk_454_65544,'3','PK_layout_listings_lid',@dbtid_2),(@pk_454_65549,'1','UK_dbtid_columnname',@dbtid_9),(@pk_454_65667,'3','PK_layout_multiforms_fid',@dbtid_3),(@pk_454_65700,'1','UK_dropset_values_did_value',@dbtid_11),(@pk_454_65702,'1','UK_dropset_values_namekey',@dbtid_11),(@pk_454_65857,'2','IX_model_node_prefix_level',@dbtid_10),(@pk_454_65865,'2','IX_model_node_dbtic',@dbtid_10),(@pk_454_65971,'3','PK_jos_model_fields|main_library',@dbtid_12),(@pk_454_65972,'1','UK_namekey_jos_model_fields',@dbtid_12),(@pk_454_65973,'3','PK_jos_fields_node|main_library',@dbtid_13),(@pk_454_65974,'3','PK_jos_fields_trans|main_library',@dbtid_14),(@pk_454_65975,'1','UK_namekey_jos_fields_node',@dbtid_13),(@pk_454_65978,'3','PK_jos_model_fieldstrans|main_library',@dbtid_15),(@pk_454_65979,'3','PK_jos_layout_fields|main_library',@dbtid_16),(@pk_454_65989,'3','PK_jos_model_fields_type|main_userdata',@dbtid_17),(@pk_454_65863,'2','IX_dataset_columns_dbid',@dbtid_9);
SET @dbtid_18 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.node' LIMIT 1);
SET @dbtid_19 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1);
SET @dbtid_20 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @dbtid_21 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dataset.tables' LIMIT 1);
SET @dbtid_22 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_23 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1);
SET @pk_616_1 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1 );
SET @pk_616_6 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1publish' LIMIT 1 );
SET @pk_616_9 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ordering' LIMIT 1 );
SET @pk_616_13 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1level' LIMIT 1 );
SET @pk_616_16 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1 );
SET @pk_616_41 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1 );
SET @pk_616_45 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3publish' LIMIT 1 );
SET @pk_616_48 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ordering' LIMIT 1 );
SET @pk_616_52 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1 );
SET @pk_616_53 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3level' LIMIT 1 );
SET @pk_616_54 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3hidden' LIMIT 1 );
SET @pk_616_58 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4wid' LIMIT 1 );
SET @pk_616_68 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4publish' LIMIT 1 );
SET @pk_616_103 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6did' LIMIT 1 );
SET @pk_616_1066 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4namekey' LIMIT 1 );
SET @pk_616_2399 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4level' LIMIT 1 );
SET @pk_616_3410 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1 );
SET @pk_616_3411 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1 );
SET @pk_616_3414 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1 );
SET @pk_616_3415 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1 );
SET @pk_616_3492 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512did' LIMIT 1 );
SET @pk_616_3493 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512lgid' LIMIT 1 );
SET @pk_616_3715 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541vid' LIMIT 1 );
SET @pk_616_3719 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6value' LIMIT 1 );
SET @pk_616_5494 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541lgid' LIMIT 1 );
SET @pk_616_5652 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4rolid' LIMIT 1 );
SET @pk_616_5653 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1 );
SET @pk_616_5654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1 );
SET @pk_616_5753 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3namekey' LIMIT 1 );
SET @pk_616_5754 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1namekey' LIMIT 1 );
SET @pk_616_6003 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbcid' LIMIT 1 );
SET @pk_616_6004 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbtid' LIMIT 1 );
SET @pk_616_6005 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616name' LIMIT 1 );
SET @pk_616_6037 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618sid' LIMIT 1 );
SET @pk_616_6038 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618lgid' LIMIT 1 );
SET @pk_616_6055 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1 );
SET @pk_616_6056 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1 );
SET @pk_616_6058 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621namekey' LIMIT 1 );
SET @pk_616_6061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621level' LIMIT 1 );
SET @pk_616_6161 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621prefix' LIMIT 1 );
SET @pk_616_6171 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616namekey' LIMIT 1 );
SET @pk_616_7336 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey6' LIMIT 1 );
SET @pk_616_9055 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='994fdid' LIMIT 1 );
SET @pk_616_9056 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey994' LIMIT 1 );
SET @pk_616_9064 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='995fieldid' LIMIT 1 );
SET @pk_616_9065 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996fieldid' LIMIT 1 );
SET @pk_616_9066 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996lgid' LIMIT 1 );
SET @pk_616_9071 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey995' LIMIT 1 );
SET @pk_616_9103 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998fdid' LIMIT 1 );
SET @pk_616_9104 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998lgid' LIMIT 1 );
SET @pk_616_9124 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999yid' LIMIT 1 );
SET @pk_616_9125 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999fdid' LIMIT 1 );
SET @pk_616_9299 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1008fdid' LIMIT 1 );
SET @pk_616_9300 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1008typeid' LIMIT 1 );
SET @pk_616_21 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1 );
SET @pk_616_73 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4did' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1 );
SET @pk_616_94 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6vid' 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_5468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='549dbtid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_9132 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent999' LIMIT 1 );
SET @pk_616_10745 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent4' LIMIT 1 );
SET @pk_616_10747 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent6' LIMIT 1 );
SET @pk_616_3 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1sid' LIMIT 1 );
SET @pk_616_7 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1parent' LIMIT 1 );
SET @pk_616_43 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3sid' LIMIT 1 );
SET @pk_616_46 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3parent' LIMIT 1 );
SET @pk_616_1067 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4ref_sid' LIMIT 1 );
SET @pk_616_1349 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1did' LIMIT 1 );
SET @pk_616_1626 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4sid' LIMIT 1 );
SET @pk_616_2990 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_yid' LIMIT 1 );
SET @pk_616_3437 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3did' LIMIT 1 );
SET @pk_616_3710 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6rolid' LIMIT 1 );
SET @pk_616_6015 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616rolid' LIMIT 1 );
SET @pk_616_6060 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621rolid' LIMIT 1 );
SET @pk_616_9057 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type994' LIMIT 1 );
SET @pk_616_9058 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid994' LIMIT 1 );
SET @pk_616_9059 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid994' LIMIT 1 );
SET @pk_616_9073 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid995' LIMIT 1 );
SET @pk_616_9074 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid995' LIMIT 1 );
SET @pk_616_9079 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid995' LIMIT 1 );
SET @pk_616_9084 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sid994' LIMIT 1 );
SET @pk_616_9127 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid3' LIMIT 1 );
SET @pk_616_9128 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid1' LIMIT 1 );
SET @pk_616_2 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1type' LIMIT 1 );
SET @pk_616_4 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1required' LIMIT 1 );
SET @pk_616_5 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1readonly' LIMIT 1 );
SET @pk_616_8 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1params' LIMIT 1 );
SET @pk_616_11 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1modified' LIMIT 1 );
SET @pk_616_12 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1map' LIMIT 1 );
SET @pk_616_14 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1initial' LIMIT 1 );
SET @pk_616_15 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1hidden' LIMIT 1 );
SET @pk_616_19 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1core' LIMIT 1 );
SET @pk_616_42 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3type' LIMIT 1 );
SET @pk_616_44 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3search' LIMIT 1 );
SET @pk_616_47 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3params' LIMIT 1 );
SET @pk_616_50 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3modified' LIMIT 1 );
SET @pk_616_51 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3map' LIMIT 1 );
SET @pk_616_56 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3core' LIMIT 1 );
SET @pk_616_60 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4core' LIMIT 1 );
SET @pk_616_61 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4outype' LIMIT 1 );
SET @pk_616_62 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4map' LIMIT 1 );
SET @pk_616_64 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4params' LIMIT 1 );
SET @pk_616_66 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4modified' LIMIT 1 );
SET @pk_616_70 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4type' LIMIT 1 );
SET @pk_616_97 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6publish' LIMIT 1 );
SET @pk_616_98 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6params' LIMIT 1 );
SET @pk_616_99 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6ordering' LIMIT 1 );
SET @pk_616_101 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6modified' LIMIT 1 );
SET @pk_616_1088 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4first_all' LIMIT 1 );
SET @pk_616_1089 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4first_value' LIMIT 1 );
SET @pk_616_1090 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4first_caption' LIMIT 1 );
SET @pk_616_1092 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4external' LIMIT 1 );
SET @pk_616_1095 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4lib_ext' LIMIT 1 );
SET @pk_616_2482 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1private' LIMIT 1 );
SET @pk_616_2989 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1area' LIMIT 1 );
SET @pk_616_3014 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1frame' 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_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3494 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512name' LIMIT 1 );
SET @pk_616_3495 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512description' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3709 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6level' LIMIT 1 );
SET @pk_616_3717 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541name' LIMIT 1 );
SET @pk_616_3727 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6valuetxt' LIMIT 1 );
SET @pk_616_5523 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_wid' LIMIT 1 );
SET @pk_616_5524 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ref_wid' LIMIT 1 );
SET @pk_616_5786 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6premium' LIMIT 1 );
SET @pk_616_6007 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616pkey' LIMIT 1 );
SET @pk_616_6008 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616checkval' LIMIT 1 );
SET @pk_616_6009 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616type' LIMIT 1 );
SET @pk_616_6010 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616attributes' LIMIT 1 );
SET @pk_616_6011 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616mandatory' LIMIT 1 );
SET @pk_616_6012 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616default' LIMIT 1 );
SET @pk_616_6013 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616ordering' LIMIT 1 );
SET @pk_616_6014 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616level' LIMIT 1 );
SET @pk_616_6016 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616created' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_6057 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621path' LIMIT 1 );
SET @pk_616_6059 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621folder' LIMIT 1 );
SET @pk_616_6062 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621publish' LIMIT 1 );
SET @pk_616_6063 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621created' LIMIT 1 );
SET @pk_616_6064 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621extended' LIMIT 1 );
SET @pk_616_6065 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621checkval' LIMIT 1 );
SET @pk_616_6066 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621params' LIMIT 1 );
SET @pk_616_6077 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621alias' LIMIT 1 );
SET @pk_616_6157 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616extra' LIMIT 1 );
SET @pk_616_6158 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616size' LIMIT 1 );
SET @pk_616_6160 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616export' LIMIT 1 );
SET @pk_616_6163 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621ordering' LIMIT 1 );
SET @pk_616_6221 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='suffix621' LIMIT 1 );
SET @pk_616_6244 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core616' LIMIT 1 );
SET @pk_616_6712 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='columntype616' LIMIT 1 );
SET @pk_616_6824 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto482' LIMIT 1 );
SET @pk_616_6825 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid482' LIMIT 1 );
SET @pk_616_6826 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto484' LIMIT 1 );
SET @pk_616_6827 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid484' LIMIT 1 );
SET @pk_616_6842 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto512' LIMIT 1 );
SET @pk_616_6843 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid512' LIMIT 1 );
SET @pk_616_6856 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto541' LIMIT 1 );
SET @pk_616_6857 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid541' LIMIT 1 );
SET @pk_616_6878 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto618' LIMIT 1 );
SET @pk_616_6879 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid618' LIMIT 1 );
SET @pk_616_7851 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='extstid621' LIMIT 1 );
SET @pk_616_9060 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core994' LIMIT 1 );
SET @pk_616_9061 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish994' LIMIT 1 );
SET @pk_616_9062 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created994' LIMIT 1 );
SET @pk_616_9063 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified994' LIMIT 1 );
SET @pk_616_9067 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name996' LIMIT 1 );
SET @pk_616_9068 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description996' LIMIT 1 );
SET @pk_616_9069 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto996' LIMIT 1 );
SET @pk_616_9070 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid996' LIMIT 1 );
SET @pk_616_9072 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias995' LIMIT 1 );
SET @pk_616_9075 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core995' LIMIT 1 );
SET @pk_616_9076 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish995' LIMIT 1 );
SET @pk_616_9077 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created995' LIMIT 1 );
SET @pk_616_9078 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified995' LIMIT 1 );
SET @pk_616_9080 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params995' LIMIT 1 );
SET @pk_616_9081 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='listing995' LIMIT 1 );
SET @pk_616_9082 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='form995' LIMIT 1 );
SET @pk_616_9083 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fields621' LIMIT 1 );
SET @pk_616_9100 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='searchable994' LIMIT 1 );
SET @pk_616_9101 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid_edit994' LIMIT 1 );
SET @pk_616_9102 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='params994' LIMIT 1 );
SET @pk_616_9105 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name998' LIMIT 1 );
SET @pk_616_9106 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description998' LIMIT 1 );
SET @pk_616_9107 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto998' LIMIT 1 );
SET @pk_616_9108 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid998' LIMIT 1 );
SET @pk_616_9109 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='initialvalue994' LIMIT 1 );
SET @pk_616_9110 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='real995' LIMIT 1 );
SET @pk_616_9111 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='column994' LIMIT 1 );
SET @pk_616_9112 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='required994' LIMIT 1 );
SET @pk_616_9118 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering995' LIMIT 1 );
SET @pk_616_9119 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='category995' LIMIT 1 );
SET @pk_616_9129 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering994' LIMIT 1 );
SET @pk_616_9130 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentdft1' LIMIT 1 );
SET @pk_616_9131 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentdft3' LIMIT 1 );
SET @pk_616_9147 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='updateall994' LIMIT 1 );
SET @pk_616_9158 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='dbcid994' LIMIT 1 );
SET @pk_616_9288 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='visible995' LIMIT 1 );
SET @pk_616_9289 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='translate995' LIMIT 1 );
SET @pk_616_9290 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='translate994' LIMIT 1 );
SET @pk_616_9291 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checkout621' LIMIT 1 );
SET @pk_616_9292 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='trash621' LIMIT 1 );
SET @pk_616_9293 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='audit621' LIMIT 1 );
SET @pk_616_9295 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified621' LIMIT 1 );
SET @pk_616_9298 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checktype1' LIMIT 1 );
SET @pk_616_9346 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='totalcustom621' LIMIT 1 );
SET @pk_616_9506 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload621' LIMIT 1 );
SET @pk_616_9510 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created4' LIMIT 1 );
SET @pk_616_9511 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='reload4' LIMIT 1 );
SET @pk_616_9667 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core621' LIMIT 1 );
SET @pk_616_9708 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='advsearch3' LIMIT 1 );
SET @pk_616_9709 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='advordering3' LIMIT 1 );
SET @pk_616_9751 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='noaudit616' LIMIT 1 );
SET @pk_616_9764 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core6' LIMIT 1 );
SET @pk_616_10034 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='advsearchable994' LIMIT 1 );
SET @pk_616_10178 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='icon621' LIMIT 1 );
SET @pk_616_10673 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xsvisible1' LIMIT 1 );
SET @pk_616_10674 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xshidden1' LIMIT 1 );
SET @pk_616_10675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xsvisible3' LIMIT 1 );
SET @pk_616_10676 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='xshidden3' LIMIT 1 );
SET @pk_616_10678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='color6' LIMIT 1 );
SET @pk_616_10721 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicevisible1' LIMIT 1 );
SET @pk_616_10722 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicehidden1' LIMIT 1 );
SET @pk_616_10723 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicevisible3' LIMIT 1 );
SET @pk_616_10724 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='devicehidden3' LIMIT 1 );
SET @pk_616_10748 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='isparent4' LIMIT 1 );
SET @pk_616_10750 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='inputbox6' LIMIT 1 );
SET @pk_616_10812 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='pnamekey621' LIMIT 1 );
SET @pk_616_10821 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='allowothers4' LIMIT 1 );
SET @pk_616_10836 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='colorstyle4' 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_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_1,@dbtid_3,'yid','0','0','3','1','1','','2','1',@rolid_0,'0','0','1','1yid','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_6,@dbtid_3,'publish','0','1','1','0','1','0','11','1',@rolid_0,'0','0','1','1publish','1','0','0'),(@pk_616_9,@dbtid_3,'ordering','0','0','2','1','1','99','9','1',@rolid_0,'0','0','1','1ordering','1','0','0'),(@pk_616_13,@dbtid_3,'level','0','0','1','1','1','0','18','1',@rolid_0,'0','0','1','1level','1','0','0'),(@pk_616_16,@dbtid_3,'fid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','1fid','1','0','0'),(@pk_616_41,@dbtid_2,'yid','0','0','3','1','1','0','2','1',@rolid_0,'0','0','1','3yid','1','0','0'),(@pk_616_45,@dbtid_2,'publish','0','0','1','0','1','1','15','1',@rolid_0,'0','0','1','3publish','1','0','0'),(@pk_616_48,@dbtid_2,'ordering','0','0','1','1','1','99','13','1',@rolid_0,'0','0','1','3ordering','1','0','0'),(@pk_616_52,@dbtid_2,'lid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','3lid','1','0','0'),(@pk_616_53,@dbtid_2,'level','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','3level','1','0','0'),(@pk_616_54,@dbtid_2,'hidden','0','0','1','1','1','0','9','1',@rolid_0,'0','0','1','3hidden','1','0','0'),(@pk_616_58,@dbtid_1,'wid','0','0','2','1','1','0','4','1',@rolid_0,'0','0','1','4wid','1','0','0'),(@pk_616_68,@dbtid_1,'publish','0','0','14','0','1','1','7','1',@rolid_0,'0','0','1','4publish','1','0','0'),(@pk_616_103,@dbtid_11,'did','0','1','3','1','1','0','2','1',@rolid_0,'0','0','1','6did','1','0','0'),(@pk_616_1066,@dbtid_1,'namekey','0','1','14','0','1','','2','1',@rolid_0,'0','50','1','4namekey','1','0','0'),(@pk_616_2399,@dbtid_1,'level','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','4level','1','0','0'),(@pk_616_3410,@dbtid_4,'fid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','482fid','1','0','0'),(@pk_616_3411,@dbtid_4,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','482lgid','1','0','0'),(@pk_616_3414,@dbtid_5,'lid','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','484lid','1','0','0'),(@pk_616_3415,@dbtid_5,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','484lgid','1','0','0'),(@pk_616_3492,@dbtid_6,'did','1','0','3','1','1','','1','1',@rolid_0,'0','0','1','512did','1','0','0'),(@pk_616_3493,@dbtid_6,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','0','1','512lgid','1','0','0'),(@pk_616_3715,@dbtid_7,'vid','1','0','4','1','1','','1','1',@rolid_0,'0','0','1','541vid','1','0','0'),(@pk_616_3719,@dbtid_11,'value','0','1','14','0','1','','9','1',@rolid_0,'0','100','1','6value','1','0','0'),(@pk_616_5494,@dbtid_7,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','4','1','541lgid','1','0','0'),(@pk_616_5652,@dbtid_1,'rolid','0','0','2','1','1','1','18','1',@rolid_0,'0','0','1','4rolid','1','0','0'),(@pk_616_5653,@dbtid_2,'rolid','0','0','2','1','1','1','7','1',@rolid_0,'0','0','1','3rolid','1','0','0'),(@pk_616_5654,@dbtid_3,'rolid','0','0','2','1','1','1','6','1',@rolid_0,'0','0','1','1rolid','1','0','0'),(@pk_616_5753,@dbtid_2,'namekey','0','1','14','0','1','','3','1',@rolid_0,'0','100','1','3namekey','1','0','0'),(@pk_616_5754,@dbtid_3,'namekey','0','1','14','0','1','','7','1',@rolid_0,'0','100','1','1namekey','1','0','0'),(@pk_616_6003,@dbtid_9,'dbcid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','616dbcid','1','0','0'),(@pk_616_6004,@dbtid_9,'dbtid','0','0','4','1','1','0','3','1',@rolid_0,'0','0','1','616dbtid','1','0','0'),(@pk_616_6005,@dbtid_9,'name','0','1','14','0','1','','4','1',@rolid_0,'0','50','1','616name','1','0','0'),(@pk_616_6037,@dbtid_8,'sid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','618sid','1','0','0'),(@pk_616_6038,@dbtid_8,'lgid','1','0','1','1','1','','2','1',@rolid_0,'0','4','1','618lgid','1','0','0'),(@pk_616_6055,@dbtid_10,'sid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','621sid','1','0','0'),(@pk_616_6056,@dbtid_10,'dbtid','0','0','2','1','1','0','2','1',@rolid_0,'0','0','1','621dbtid','1','0','0'),(@pk_616_6058,@dbtid_10,'namekey','0','1','14','0','1','','5','1',@rolid_0,'0','50','1','621namekey','1','0','0'),(@pk_616_6061,@dbtid_10,'level','0','0','1','1','1','0','8','1',@rolid_0,'0','0','1','621level','1','0','0'),(@pk_616_6161,@dbtid_10,'prefix','0','0','14','0','1','','14','1',@rolid_0,'0','50','1','621prefix','1','0','0'),(@pk_616_6171,@dbtid_9,'namekey','0','1','14','0','1','','2','0',@rolid_0,'0','50','1','616namekey','1','0','0'),(@pk_616_7336,@dbtid_11,'namekey','0','1','14','0','1','','12','0','0','0','150','1','namekey6','1','0','0'),(@pk_616_9055,@dbtid_12,'fdid','1','0','4','1','1','','1','0','0','1','0','1','994fdid','1','0','0'),(@pk_616_9056,@dbtid_12,'namekey','0','1','14','0','1','','5','0','0','0','150','1','namekey994','1','0','0'),(@pk_616_9064,@dbtid_13,'fieldid','1','0','2','1','1','','1','0','0','1','0','1','995fieldid','1','0','0'),(@pk_616_9065,@dbtid_14,'fieldid','1','0','4','1','1','','0','0','0','0','0','1','996fieldid','1','0','0'),(@pk_616_9066,@dbtid_14,'lgid','1','0','4','1','1','','1','0','0','0','0','1','996lgid','1','0','0'),(@pk_616_9071,@dbtid_13,'namekey','0','0','14','0','1','','4','0','0','0','150','1','namekey995','1','0','0'),(@pk_616_9103,@dbtid_15,'fdid','1','0','4','1','1','','0','0','0','0','0','1','998fdid','1','0','0'),(@pk_616_9104,@dbtid_15,'lgid','1','0','4','1','1','','1','0','0','0','0','1','998lgid','1','0','0'),(@pk_616_9124,@dbtid_16,'yid','1','0','4','1','1','','1','0','0','0','0','1','999yid','1','0','0'),(@pk_616_9125,@dbtid_16,'fdid','1','0','4','1','1','','2','0','0','0','0','1','999fdid','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_9299,@dbtid_17,'fdid','1','0','4','1','1','','0','0','0','0','0','1','1008fdid','1','0','0'),(@pk_616_9300,@dbtid_17,'typeid','1','0','4','1','1','','1','0','0','0','0','1','1008typeid','1','0','0'),(@pk_616_21,@dbtid_18,'yid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','2yid','1','0','0'),(@pk_616_73,@dbtid_1,'did','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','4did','1','0','0'),(@pk_616_81,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'wid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','5wid','1','0','0'),(@pk_616_94,@dbtid_11,'vid','1','1','4','1','1','','1','1',@rolid_0,'1','0','1','6vid','1','0','0'),(@pk_616_1468,@dbtid_19,'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','1','0','0'),(@pk_616_1698,@dbtid_20,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_5468,@dbtid_21,'dbtid','1','0','3','1','1','','1','1',@rolid_0,'1','0','1','549dbtid','1','0','0'),(@pk_616_5532,@dbtid_22,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_9132,@dbtid_16,'parent','0','1','4','1','1','0','3','0','0','0','0','1','parent999','1','0','0'),(@pk_616_10745,@dbtid_1,'parent','0','1','14','0','1','','22','0','0','0','50','1','parent4','1','0','0'),(@pk_616_10747,@dbtid_11,'parent','0','1','14','0','1','','15','0','0','0','100','1','parent6','1','0','0'),(@pk_616_3,@dbtid_3,'sid','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','1sid','1','0','0'),(@pk_616_7,@dbtid_3,'parent','0','0','3','1','1','0','10','1',@rolid_0,'0','0','1','1parent','1','0','0'),(@pk_616_43,@dbtid_2,'sid','0','0','2','1','1','0','5','1',@rolid_0,'0','0','1','3sid','1','0','0'),(@pk_616_46,@dbtid_2,'parent','0','0','3','1','1','0','14','1',@rolid_0,'0','0','1','3parent','1','0','0'),(@pk_616_1067,@dbtid_1,'ref_sid','0','0','2','1','1','0','8','1',@rolid_0,'0','0','1','4ref_sid','1','0','0'),(@pk_616_1349,@dbtid_3,'did','0','1','3','1','1','0','4','1',@rolid_0,'0','0','1','1did','1','0','0'),(@pk_616_1626,@dbtid_1,'sid','0','0','2','1','1','0','3','1',@rolid_0,'0','0','1','4sid','1','0','0'),(@pk_616_2990,@dbtid_3,'ref_yid','0','0','3','1','1','0','21','1',@rolid_0,'0','0','1','1ref_yid','1','0','0'),(@pk_616_3437,@dbtid_2,'did','0','0','3','1','1','0','6','1',@rolid_0,'0','0','1','3did','1','0','0'),(@pk_616_3710,@dbtid_11,'rolid','0','0','1','1','1','1','8','1',@rolid_0,'0','0','1','6rolid','1','0','0'),(@pk_616_6015,@dbtid_9,'rolid','0','0','2','1','1','0','14','1',@rolid_0,'0','0','1','616rolid','1','0','0'),(@pk_616_6060,@dbtid_10,'rolid','0','0','2','1','1','0','7','1',@rolid_0,'0','0','1','621rolid','1','0','0'),(@pk_616_9057,@dbtid_12,'fieldid','0','0','2','1','1','0','2','0','0','0','0','1','type994','1','0','0'),(@pk_616_9058,@dbtid_12,'rolid','0','0','2','1','1','1','3','0','0','0','0','1','rolid994','1','0','0'),(@pk_616_9059,@dbtid_12,'uid','0','0','4','1','1','0','6','0','0','0','0','1','uid994','1','0','0'),(@pk_616_9073,@dbtid_13,'rolid','0','0','2','1','1','1','2','0','0','0','0','1','rolid995','1','0','0'),(@pk_616_9074,@dbtid_13,'uid','0','0','4','1','1','0','5','0','0','0','0','0','uid995','1','0','0'),(@pk_616_9079,@dbtid_13,'wid','0','1','3','1','1','0','10','0','0','0','0','1','wid995','1','0','0'),(@pk_616_9084,@dbtid_12,'sid','0','1','3','1','1','0','11','0','0','0','0','1','sid994','1','0','0'),(@pk_616_9127,@dbtid_2,'fdid','0','1','4','1','1','0','20','0','0','0','0','1','fdid3','1','0','0'),(@pk_616_9128,@dbtid_3,'fdid','0','1','4','1','1','0','25','0','0','0','0','1','fdid1','1','0','0'),(@pk_616_2,@dbtid_3,'type','0','0','14','0','1','','3','1',@rolid_0,'0','100','1','1type','1','0','0'),(@pk_616_4,@dbtid_3,'required','0','0','1','1','1','0','13','1',@rolid_0,'0','0','1','1required','1','0','0'),(@pk_616_5,@dbtid_3,'readonly','0','0','1','1','1','0','12','1',@rolid_0,'0','0','1','1readonly','1','0','0'),(@pk_616_8,@dbtid_3,'params','0','1','16','0','1','','24','1',@rolid_0,'0','0','1','1params','1','0','0'),(@pk_616_11,@dbtid_3,'modified','0','1','4','1','1','0','14','1',@rolid_0,'0','0','0','1modified','1','1','0'),(@pk_616_12,@dbtid_3,'map','0','1','14','0','1','','8','1',@rolid_0,'0','100','1','1map','1','0','0'),(@pk_616_14,@dbtid_3,'initial','0','1','14','0','1','','17','1',@rolid_0,'0','255','1','1initial','1','0','0'),(@pk_616_15,@dbtid_3,'hidden','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','1hidden','1','0','0'),(@pk_616_19,@dbtid_3,'core','0','1','25','0','1','1','15','1',@rolid_0,'0','0','1','1core','1','0','0'),(@pk_616_42,@dbtid_2,'type','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','3type','1','0','0'),(@pk_616_44,@dbtid_2,'search','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','3search','1','0','0'),(@pk_616_47,@dbtid_2,'params','0','0','16','0','1','','22','1',@rolid_0,'0','0','1','3params','1','0','0'),(@pk_616_50,@dbtid_2,'modified','0','1','4','1','1','0','12','1',@rolid_0,'0','0','0','3modified','1','1','0'),(@pk_616_51,@dbtid_2,'map','0','1','14','0','1','','11','1',@rolid_0,'0','30','1','3map','1','0','0'),(@pk_616_56,@dbtid_2,'core','0','0','25','0','1','1','8','1',@rolid_0,'0','0','1','3core','1','0','0'),(@pk_616_60,@dbtid_1,'core','0','0','25','1','1','1','10','1',@rolid_0,'0','0','1','4core','1','0','0'),(@pk_616_61,@dbtid_1,'outype','0','0','1','1','1','0','6','1',@rolid_0,'0','0','1','4outype','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_62,@dbtid_1,'map','0','1','14','0','1','','5','1',@rolid_0,'0','20','1','4map','1','0','0'),(@pk_616_64,@dbtid_1,'params','0','0','16','0','1','','17','1',@rolid_0,'0','0','1','4params','1','0','0'),(@pk_616_66,@dbtid_1,'modified','0','1','4','1','1','0','19','1',@rolid_0,'0','0','0','4modified','1','1','0'),(@pk_616_70,@dbtid_1,'type','0','0','1','1','1','0','9','1',@rolid_0,'0','0','1','4type','1','0','0'),(@pk_616_97,@dbtid_11,'publish','0','0','1','0','1','0','4','1',@rolid_0,'0','0','1','6publish','1','0','0'),(@pk_616_98,@dbtid_11,'params','0','1','16','0','1','','6','1',@rolid_0,'0','0','1','6params','1','0','0'),(@pk_616_99,@dbtid_11,'ordering','0','1','1','1','1','0','3','1',@rolid_0,'1','0','1','6ordering','1','0','0'),(@pk_616_101,@dbtid_11,'modified','0','1','4','1','1','0','5','1',@rolid_0,'0','0','0','6modified','1','1','0'),(@pk_616_1088,@dbtid_1,'first_all','0','1','25','0','1','0','12','1',@rolid_0,'0','0','1','4first_all','1','0','0'),(@pk_616_1089,@dbtid_1,'first_value','0','1','4','1','1','0','14','1',@rolid_0,'0','0','1','4first_value','1','0','0'),(@pk_616_1090,@dbtid_1,'first_caption','0','1','14','0','1','','13','1',@rolid_0,'0','50','1','4first_caption','1','0','0'),(@pk_616_1092,@dbtid_1,'external','0','1','14','0','1','','11','1',@rolid_0,'0','50','1','4external','1','0','0'),(@pk_616_1095,@dbtid_1,'lib_ext','0','0','25','0','1','0','15','1',@rolid_0,'0','0','1','4lib_ext','1','0','0'),(@pk_616_2482,@dbtid_3,'private','0','0','25','0','1','0','19','1',@rolid_0,'0','0','1','1private','1','0','0'),(@pk_616_2989,@dbtid_3,'area','0','0','14','0','1','','20','1',@rolid_0,'0','20','1','1area','1','0','0'),(@pk_616_3014,@dbtid_3,'frame','0','0','1','1','1','0','22','1',@rolid_0,'0','0','1','1frame','1','0','0'),(@pk_616_3412,@dbtid_4,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,@dbtid_4,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3416,@dbtid_5,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3494,@dbtid_6,'name','0','0','14','0','1','','4','1',@rolid_0,'0','100','1','512name','1','0','0'),(@pk_616_3495,@dbtid_6,'description','0','0','16','0','1','','3','1',@rolid_0,'0','0','1','512description','1','0','0'),(@pk_616_3507,@dbtid_5,'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3709,@dbtid_11,'level','0','0','1','1','1','0','7','1',@rolid_0,'0','0','1','6level','1','0','0'),(@pk_616_3717,@dbtid_7,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','541name','1','0','0'),(@pk_616_3727,@dbtid_11,'valuetxt','0','1','14','0','1','','10','1',@rolid_0,'0','50','1','6valuetxt','1','0','0'),(@pk_616_5523,@dbtid_3,'ref_wid','0','0','2','1','1','0','23','1',@rolid_0,'0','0','1','1ref_wid','1','0','0'),(@pk_616_5524,@dbtid_2,'ref_wid','0','0','2','1','1','0','19','1',@rolid_0,'0','0','1','3ref_wid','1','0','0'),(@pk_616_5786,@dbtid_11,'premium','0','0','25','1','1','0','11','1',@rolid_0,'0','0','1','6premium','1','0','0'),(@pk_616_6007,@dbtid_9,'pkey','0','0','1','1','1','0','6','1',@rolid_0,'0','0','1','616pkey','1','0','0'),(@pk_616_6008,@dbtid_9,'checkval','0','0','1','1','1','0','7','1',@rolid_0,'0','0','1','616checkval','1','0','0'),(@pk_616_6009,@dbtid_9,'type','0','0','3','1','1','0','8','1',@rolid_0,'0','0','1','616type','1','0','0'),(@pk_616_6010,@dbtid_9,'attributes','0','0','1','1','1','0','9','1',@rolid_0,'0','0','1','616attributes','1','0','0'),(@pk_616_6011,@dbtid_9,'mandatory','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','616mandatory','1','0','0'),(@pk_616_6012,@dbtid_9,'default','0','1','14','0','1','','11','1',@rolid_0,'0','50','1','616default','1','0','0'),(@pk_616_6013,@dbtid_9,'ordering','0','0','1','1','1','0','12','1',@rolid_0,'0','0','1','616ordering','1','0','0'),(@pk_616_6014,@dbtid_9,'level','0','0','1','1','1','0','13','1',@rolid_0,'0','0','1','616level','1','0','0'),(@pk_616_6016,@dbtid_9,'created','0','1','4','1','1','0','15','1',@rolid_0,'0','0','0','616created','1','1','0'),(@pk_616_6039,@dbtid_8,'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','618name','1','0','0'),(@pk_616_6057,@dbtid_10,'path','0','0','1','1','1','0','4','1',@rolid_0,'0','0','1','621path','1','0','0'),(@pk_616_6059,@dbtid_10,'folder','0','0','14','0','1','','6','1',@rolid_0,'0','50','1','621folder','1','0','0'),(@pk_616_6062,@dbtid_10,'publish','0','0','1','0','1','0','9','1',@rolid_0,'0','0','1','621publish','1','0','0'),(@pk_616_6063,@dbtid_10,'created','0','1','4','1','1','0','23','1',@rolid_0,'0','0','0','621created','1','1','0'),(@pk_616_6064,@dbtid_10,'extended','0','0','1','1','1','0','10','1',@rolid_0,'0','0','1','621extended','1','0','0'),(@pk_616_6065,@dbtid_10,'checkval','0','0','1','1','1','0','11','1',@rolid_0,'0','0','1','621checkval','1','0','0'),(@pk_616_6066,@dbtid_10,'params','0','0','16','0','1','','12','1',@rolid_0,'0','0','1','621params','1','0','0'),(@pk_616_6077,@dbtid_10,'alias','0','0','14','0','1','','13','1',@rolid_0,'0','50','1','621alias','1','0','0'),(@pk_616_6157,@dbtid_9,'extra','0','0','1','1','1','0','16','1',@rolid_0,'0','0','1','616extra','1','0','0'),(@pk_616_6158,@dbtid_9,'size','0','0','8','0','1','0','17','1',@rolid_0,'0','8','1','616size','1','0','0'),(@pk_616_6160,@dbtid_9,'export','0','0','1','1','1','1','18','1',@rolid_0,'0','0','1','616export','1','0','0'),(@pk_616_6163,@dbtid_10,'ordering','0','0','2','1','1','0','21','1',@rolid_0,'0','0','0','621ordering','1','0','0'),(@pk_616_6221,@dbtid_10,'suffix','0','0','14','0','1','','3','0','0','0','50','0','suffix621','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_6244,@dbtid_9,'core','0','1','25','0','1','1','19','0','0','0','0','1','core616','1','0','0'),(@pk_616_6712,@dbtid_9,'columntype','0','1','1','1','1','','20','0','0','0','0','1','columntype616','1','0','0'),(@pk_616_6824,@dbtid_4,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto482','1','0','0'),(@pk_616_6825,@dbtid_4,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid482','1','0','0'),(@pk_616_6826,@dbtid_5,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto484','1','0','0'),(@pk_616_6827,@dbtid_5,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid484','1','0','0'),(@pk_616_6842,@dbtid_6,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto512','1','0','0'),(@pk_616_6843,@dbtid_6,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid512','1','0','0'),(@pk_616_6856,@dbtid_7,'auto','0','0','1','0','1','2','5','0','0','0','0','0','auto541','1','0','0'),(@pk_616_6857,@dbtid_7,'fromlgid','0','0','1','1','1','0','4','0','0','0','0','0','fromlgid541','1','0','0'),(@pk_616_6878,@dbtid_8,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto618','1','0','0'),(@pk_616_6879,@dbtid_8,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid618','1','0','0'),(@pk_616_7851,@dbtid_10,'extstid','0','1','1','1','1','0','20','0','0','0','0','0','extstid621','1','0','0'),(@pk_616_9060,@dbtid_12,'core','0','0','25','0','1','0','7','0','0','0','0','1','core994','1','0','0'),(@pk_616_9061,@dbtid_12,'publish','0','0','1','0','1','0','10','0','0','0','0','1','publish994','1','0','0'),(@pk_616_9062,@dbtid_12,'created','0','1','4','1','1','0','9','0','0','0','0','1','created994','1','1','0'),(@pk_616_9063,@dbtid_12,'modified','0','1','4','1','1','0','8','0','0','0','0','1','modified994','1','1','0'),(@pk_616_9067,@dbtid_14,'name','0','0','14','0','1','','4','0','0','0','255','1','name996','1','0','0'),(@pk_616_9068,@dbtid_14,'description','0','0','16','0','1','','5','0','0','0','0','1','description996','1','0','0'),(@pk_616_9069,@dbtid_14,'auto','0','0','1','0','1','2','6','0','0','0','0','1','auto996','1','0','0'),(@pk_616_9070,@dbtid_14,'fromlgid','0','0','1','1','1','0','7','0','0','0','0','1','fromlgid996','1','0','0'),(@pk_616_9072,@dbtid_13,'alias','0','0','14','0','1','','3','0','0','0','150','1','alias995','1','0','0'),(@pk_616_9075,@dbtid_13,'core','0','0','25','0','1','0','6','0','0','0','0','1','core995','1','0','0'),(@pk_616_9076,@dbtid_13,'publish','0','0','1','0','1','0','9','0','0','0','0','1','publish995','1','0','0'),(@pk_616_9077,@dbtid_13,'created','0','1','4','1','1','0','8','0','0','0','0','0','created995','1','1','0'),(@pk_616_9078,@dbtid_13,'modified','0','1','4','1','1','0','7','0','0','0','0','0','modified995','1','1','0'),(@pk_616_9080,@dbtid_13,'params','0','1','16','0','1','','11','0','0','0','0','1','params995','1','0','0'),(@pk_616_9081,@dbtid_13,'listing','0','1','14','0','1','','12','0','0','0','250','1','listing995','1','0','0'),(@pk_616_9082,@dbtid_13,'form','0','1','14','0','1','','13','0','0','0','250','1','form995','1','0','0'),(@pk_616_9083,@dbtid_10,'fields','0','1','1','1','1','0','15','0','0','0','0','1','fields621','1','0','0'),(@pk_616_9100,@dbtid_12,'searchable','0','1','1','1','1','0','12','0','0','0','0','1','searchable994','1','0','0'),(@pk_616_9101,@dbtid_12,'rolid_edit','0','1','2','1','1','1','15','0','0','0','0','1','rolid_edit994','1','0','0'),(@pk_616_9102,@dbtid_12,'params','0','1','16','0','1','','17','0','0','0','0','1','params994','1','0','0'),(@pk_616_9105,@dbtid_15,'name','0','0','14','0','1','','4','0','0','0','255','1','name998','1','0','0'),(@pk_616_9106,@dbtid_15,'description','0','0','16','0','1','','5','0','0','0','0','1','description998','1','0','0'),(@pk_616_9107,@dbtid_15,'auto','0','0','1','0','1','2','6','0','0','0','0','1','auto998','1','0','0'),(@pk_616_9108,@dbtid_15,'fromlgid','0','0','1','1','1','0','7','0','0','0','0','1','fromlgid998','1','0','0'),(@pk_616_9109,@dbtid_12,'initialvalue','0','1','14','0','1','','16','0','0','0','255','1','initialvalue994','1','0','0'),(@pk_616_9110,@dbtid_13,'real','0','1','1','1','1','0','14','0','0','0','0','1','real995','1','0','0'),(@pk_616_9111,@dbtid_12,'column','0','1','14','0','1','','4','0','0','0','100','1','column994','1','0','0'),(@pk_616_9112,@dbtid_12,'required','0','1','1','1','1','0','14','0','0','0','0','1','required994','1','0','0'),(@pk_616_9118,@dbtid_13,'ordering','0','1','3','1','1','69','15','0','0','0','0','1','ordering995','1','0','0'),(@pk_616_9119,@dbtid_13,'category','0','1','1','1','1','1','16','0','0','0','0','1','category995','1','0','0'),(@pk_616_9129,@dbtid_12,'ordering','0','1','2','1','1','999','18','0','0','0','0','1','ordering994','1','0','0'),(@pk_616_9130,@dbtid_3,'parentdft','0','1','1','1','1','0','26','0','0','0','0','1','parentdft1','1','0','0'),(@pk_616_9131,@dbtid_2,'parentdft','0','1','1','1','1','0','21','0','0','0','0','1','parentdft3','1','0','0'),(@pk_616_9147,@dbtid_12,'updateall','0','1','1','1','1','1','19','0','0','0','0','1','updateall994','1','0','0'),(@pk_616_9158,@dbtid_12,'dbcid','0','1','4','1','1','0','20','0','0','0','0','1','dbcid994','1','0','0'),(@pk_616_9288,@dbtid_13,'visible','0','1','1','1','1','1','17','0','0','0','0','1','visible995','1','0','0'),(@pk_616_9289,@dbtid_13,'translate','0','1','1','1','1','0','18','0','0','0','0','1','translate995','1','0','0'),(@pk_616_9290,@dbtid_12,'translate','0','1','1','1','1','0','21','0','0','0','0','1','translate994','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_9291,@dbtid_10,'checkout','0','1','1','1','1','0','19','0','0','0','0','0','checkout621','1','0','0'),(@pk_616_9292,@dbtid_10,'trash','0','1','1','1','1','0','16','0','0','0','0','1','trash621','1','0','0'),(@pk_616_9293,@dbtid_10,'audit','0','1','1','1','1','0','22','0','0','0','0','0','audit621','1','0','0'),(@pk_616_9295,@dbtid_10,'modified','0','1','4','1','1','0','24','0','0','0','0','0','modified621','1','1','0'),(@pk_616_9298,@dbtid_3,'checktype','0','1','1','1','1','0','27','0','0','0','0','1','checktype1','1','0','0'),(@pk_616_9346,@dbtid_10,'totalcustom','0','1','2','1','1','0','25','0','0','0','0','0','totalcustom621','1','0','0'),(@pk_616_9506,@dbtid_10,'reload','0','1','1','1','1','1','26','0','0','0','0','0','reload621','1','0','0'),(@pk_616_9510,@dbtid_1,'created','0','1','4','1','1','0','20','0','0','0','0','0','created4','1','1','0'),(@pk_616_9511,@dbtid_1,'reload','0','1','1','1','1','1','21','0','0','0','0','1','reload4','1','0','0'),(@pk_616_9667,@dbtid_10,'core','0','1','25','0','1','0','17','0','0','0','0','1','core621','1','0','0'),(@pk_616_9708,@dbtid_2,'advsearch','0','1','1','1','1','0','17','0','0','0','0','1','advsearch3','1','0','0'),(@pk_616_9709,@dbtid_2,'advordering','0','1','1','1','1','0','18','0','0','0','0','1','advordering3','1','0','0'),(@pk_616_9751,@dbtid_9,'noaudit','0','1','1','1','1','0','22','0','0','0','0','1','noaudit616','1','0','0'),(@pk_616_9764,@dbtid_11,'core','0','1','25','0','1','0','13','0','0','0','0','1','core6','1','0','0'),(@pk_616_10034,@dbtid_12,'advsearchable','0','1','1','1','1','0','13','0','0','0','0','1','advsearchable994','1','0','0'),(@pk_616_10178,@dbtid_10,'faicon','0','1','14','0','1','','18','0','0','0','50','1','icon621','1','0','0'),(@pk_616_10673,@dbtid_3,'xsvisible','0','1','1','1','1','0','28','0','0','0','0','1','xsvisible1','1','0','0'),(@pk_616_10674,@dbtid_3,'xshidden','0','1','1','1','1','0','29','0','0','0','0','1','xshidden1','1','0','0'),(@pk_616_10675,@dbtid_2,'xsvisible','0','1','1','1','1','0','23','0','0','0','0','1','xsvisible3','1','0','0'),(@pk_616_10676,@dbtid_2,'xshidden','0','1','1','1','1','0','24','0','0','0','0','1','xshidden3','1','0','0'),(@pk_616_10678,@dbtid_11,'color','0','1','14','0','1','','14','0','0','0','20','1','color6','1','0','0'),(@pk_616_10721,@dbtid_3,'devicevisible','0','1','14','0','1','','30','0','0','0','100','1','devicevisible1','1','0','0'),(@pk_616_10722,@dbtid_3,'devicehidden','0','1','14','0','1','','31','0','0','0','100','1','devicehidden1','1','0','0'),(@pk_616_10723,@dbtid_2,'devicevisible','0','1','14','0','1','','25','0','0','0','100','1','devicevisible3','1','0','0'),(@pk_616_10724,@dbtid_2,'devicehidden','0','1','14','0','1','','26','0','0','0','100','1','devicehidden3','1','0','0'),(@pk_616_10748,@dbtid_1,'isparent','0','1','1','1','1','0','23','0','0','0','0','1','isparent4','1','0','0'),(@pk_616_10750,@dbtid_11,'inputbox','0','1','1','1','1','0','16','0','0','0','0','1','inputbox6','1','0','0'),(@pk_616_10812,@dbtid_10,'pnamekey','0','1','14','0','1','','27','0','0','0','50','1','pnamekey621','1','0','0'),(@pk_616_10821,@dbtid_1,'allowothers','0','1','1','1','1','0','24','0','0','0','0','1','allowothers4','1','0','0'),(@pk_616_10836,@dbtid_1,'colorstyle','0','1','1','1','1','0','25','0','0','0','0','1','colorstyle4','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_3408,@dbtid_23,'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,@dbtid_23,'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,@dbtid_23,'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_1769 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='design.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='design',`wid`=@pk_5_1769,`params`='',`status`='1',`type`='150',`name`='Design',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='design.node',`version`='1728',`lversion`='1728',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='design.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','design',@pk_5_1769,'','1','150','Design','node','0','1','1','design.node','1728','1728','1','','1','1','0');

SET @pk_621_1141 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fields' LIMIT 1 );
SET @pk_621_1142 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fieldstrans' LIMIT 1 );
SET @pk_621_1143 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.model' LIMIT 1 );
SET @pk_621_1144 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modeltrans' LIMIT 1 );
SET @pk_621_1145 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfields' LIMIT 1 );
SET @pk_621_1147 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfieldstrans' LIMIT 1 );
SET @pk_621_1148 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.columns' LIMIT 1 );
SET @pk_621_1149 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewfields' LIMIT 1 );
SET @pk_621_1150 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewforms' LIMIT 1 );
SET @pk_621_1151 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewformstrans' LIMIT 1 );
SET @pk_621_1152 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewlistings' LIMIT 1 );
SET @pk_621_1153 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewlistingstrans' LIMIT 1 );
SET @pk_621_1155 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklist' LIMIT 1 );
SET @pk_621_1156 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklisttrans' LIMIT 1 );
SET @pk_621_1157 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvalues' LIMIT 1 );
SET @pk_621_1158 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvaluestrans' LIMIT 1 );
SET @pk_621_1175 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfieldstype' LIMIT 1 );
SET @pk_621_1180 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' 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_1126 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.view' LIMIT 1 );
SET @pk_621_716 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.viewtrans' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_1333 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.table' LIMIT 1 );
SET @pk_621_549 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='database.tables' LIMIT 1 );
SET @pk_621_621 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='model' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_1141,`dbtid`=@dbtid_13,`path`='0',`namekey`='design.fields',`folder`='design.fields',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=category\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-wrench',`pnamekey`='' WHERE  `namekey`='design.fields';
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_1141,@dbtid_13,'0','design.fields','design.fields',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=category\nautofld=1','','main','0','0','1','fa-wrench','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1142,`dbtid`=@dbtid_14,`path`='0',`namekey`='design.fieldstrans',`folder`='design.fieldstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.fields',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-wrench',`pnamekey`='' WHERE  `namekey`='design.fieldstrans';
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_1142,@dbtid_14,'0','design.fieldstrans','design.fieldstrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.fields','','main','0','0','1','fa-wrench','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1143,`dbtid`=@dbtid_10,`path`='0',`namekey`='design.model',`folder`='design.model',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-table',`pnamekey`='' WHERE  `namekey`='design.model';
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_1143,@dbtid_10,'0','design.model','design.model',@rolid_0,'0','1','0','0','autofld=1','','main','0','0','1','fa-table','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1144,`dbtid`=@dbtid_8,`path`='0',`namekey`='design.modeltrans',`folder`='design.modeltrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.model',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-table',`pnamekey`='' WHERE  `namekey`='design.modeltrans';
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_1144,@dbtid_8,'0','design.modeltrans','design.modeltrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.model','','main','0','0','1','fa-table','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1145,`dbtid`=@dbtid_12,`path`='1',`namekey`='design.modelfields',`folder`='design.modelfields',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=sid\nverifld=1\ncorecfld=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-wrench',`pnamekey`='' WHERE  `namekey`='design.modelfields';
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_1145,@dbtid_12,'1','design.modelfields','design.modelfields',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=sid\nverifld=1\ncorecfld=1\nautofld=1','','main','0','0','1','fa-wrench','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1147,`dbtid`=@dbtid_15,`path`='0',`namekey`='design.modelfieldstrans',`folder`='design.modelfieldstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.modelfields',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-wrench',`pnamekey`='' WHERE  `namekey`='design.modelfieldstrans';
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_1147,@dbtid_15,'0','design.modelfieldstrans','design.modelfieldstrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.modelfields','','design','0','0','1','fa-wrench','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1148,`dbtid`=@dbtid_9,`path`='1',`namekey`='design.columns',`folder`='design.columns',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-columns',`pnamekey`='' WHERE  `namekey`='design.columns';
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_1148,@dbtid_9,'1','design.columns','design.columns',@rolid_0,'0','1','0','0','autofld=1','','design','0','0','1','fa-columns','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1149,`dbtid`=@dbtid_16,`path`='0',`namekey`='design.viewfields',`folder`='design.viewfields',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-wrench',`pnamekey`='' WHERE  `namekey`='design.viewfields';
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_1149,@dbtid_16,'0','design.viewfields','design.viewfields',@rolid_0,'0','1','0','0','autofld=1','','design','0','0','1','fa-wrench','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1150,`dbtid`=@dbtid_3,`path`='1',`namekey`='design.viewforms',`folder`='design.viewforms',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nautofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='design.viewforms';
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_1150,@dbtid_3,'1','design.viewforms','design.viewforms',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nautofld=1','','design','0','0','1','fa-th-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1151,`dbtid`=@dbtid_4,`path`='0',`namekey`='design.viewformstrans',`folder`='design.viewformstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.viewforms',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th-list',`pnamekey`='' WHERE  `namekey`='design.viewformstrans';
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_1151,@dbtid_4,'0','design.viewformstrans','design.viewformstrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.viewforms','','design','0','0','1','fa-th-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1152,`dbtid`=@dbtid_2,`path`='1',`namekey`='design.viewlistings',`folder`='design.viewlistings',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=yid\nautofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list',`pnamekey`='' WHERE  `namekey`='design.viewlistings';
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_1152,@dbtid_2,'1','design.viewlistings','design.viewlistings',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=yid\nautofld=1','','design','0','0','1','fa-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1153,`dbtid`=@dbtid_5,`path`='0',`namekey`='design.viewlistingstrans',`folder`='design.viewlistingstrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.viewlistings',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list',`pnamekey`='' WHERE  `namekey`='design.viewlistingstrans';
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_1153,@dbtid_5,'0','design.viewlistingstrans','design.viewlistingstrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.viewlistings','','design','0','0','1','fa-list','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1155,`dbtid`=@dbtid_1,`path`='1',`namekey`='design.picklist',`folder`='design.picklist',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-ol',`pnamekey`='' WHERE  `namekey`='design.picklist';
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_1155,@dbtid_1,'1','design.picklist','design.picklist',@rolid_0,'0','1','0','0','autofld=1','','design','0','0','1','fa-list-ol','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1156,`dbtid`=@dbtid_6,`path`='0',`namekey`='design.picklisttrans',`folder`='design.picklisttrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.picklist',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-ol',`pnamekey`='' WHERE  `namekey`='design.picklisttrans';
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_1156,@dbtid_6,'0','design.picklisttrans','design.picklisttrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.picklist','','design','0','0','1','fa-list-ol','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1157,`dbtid`=@dbtid_11,`path`='1',`namekey`='design.picklistvalues',`folder`='design.picklistvalues',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=publish\nautofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-map-marker',`pnamekey`='' WHERE  `namekey`='design.picklistvalues';
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_1157,@dbtid_11,'1','design.picklistvalues','design.picklistvalues',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=publish\nautofld=1','','design','0','0','1','fa-map-marker','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1158,`dbtid`=@dbtid_7,`path`='0',`namekey`='design.picklistvaluestrans',`folder`='design.picklistvaluestrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=design.picklistvalues',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-map-marker',`pnamekey`='' WHERE  `namekey`='design.picklistvaluestrans';
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_1158,@dbtid_7,'0','design.picklistvaluestrans','design.picklistvaluestrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=design.picklistvalues','','design','0','0','1','fa-map-marker','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1175,`dbtid`=@dbtid_17,`path`='0',`namekey`='design.modelfieldstype',`folder`='design.modelfieldstype',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='design',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-arrows-alt',`pnamekey`='' WHERE  `namekey`='design.modelfieldstype';
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_1175,@dbtid_17,'0','design.modelfieldstype','design.modelfieldstype',@rolid_0,'0','1','0','0','autofld=1','','design','0','0','1','fa-arrows-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1180,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1),`path`='1',`namekey`='main.widget',`folder`='main.widget',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='widget',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-puzzle-piece',`pnamekey`='' WHERE  `namekey`='main.widget';
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_1180,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='widgets.node' LIMIT 1),'1','main.widget','main.widget',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','widget','0','0','1','fa-puzzle-piece','');
UPDATE `#__model_node`  SET `sid`=@pk_621_566,`dbtid`=@dbtid_22,`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_22,'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_18,`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_18,'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_1126,`dbtid`=@dbtid_18,`path`='1',`namekey`='main.view',`folder`='main.view',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='validtoggle=1\nverifld=1\nautofld=1',`alias`='',`prefix`='main',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='main.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_1126,@dbtid_18,'1','main.view','main.view',@rolid_0,'0','1','0','0','validtoggle=1\nverifld=1\nautofld=1','','main','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_716,`dbtid`=@dbtid_23,`path`='0',`namekey`='library.viewtrans',`folder`='library',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=library.view',`alias`='',`prefix`='library',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-list-alt',`pnamekey`='' WHERE  `namekey`='library.viewtrans';
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_716,@dbtid_23,'0','library.viewtrans','library',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=library.view','','library','0','0','1','fa-list-alt','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=@dbtid_19,`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,@dbtid_19,'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1333,`dbtid`=@dbtid_21,`path`='0',`namekey`='library.table',`folder`='library.table',`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.table';
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_1333,@dbtid_21,'0','library.table','library.table',@rolid_0,'0','1','0','0','autofld=1','','library','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_549,`dbtid`=@dbtid_21,`path`='1',`namekey`='database.tables',`folder`='database.tables',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='database',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-table',`pnamekey`='' WHERE  `namekey`='database.tables';
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_549,@dbtid_21,'1','database.tables','database.tables',@rolid_0,'0','1','0','0','autofld=1','','database','0','0','1','fa-table','');
UPDATE `#__model_node`  SET `sid`=@pk_621_621,`dbtid`=@dbtid_10,`path`='1',`namekey`='model',`folder`='model',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='model',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-table',`pnamekey`='' WHERE  `namekey`='model';
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_621,@dbtid_10,'1','model','model',@rolid_0,'0','1','0','0','autofld=1','','model','0','0','1','fa-table','');

SET @wid_24 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='design.node' LIMIT 1);
SET @sid_25 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fields' LIMIT 1);
SET @sid_26 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.model' LIMIT 1);
SET @sid_27 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfields' LIMIT 1);
SET @sid_28 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklist' LIMIT 1);
SET @sid_29 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvalues' LIMIT 1);
SET @sid_30 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='main.widget' LIMIT 1);
SET @sid_31 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='library.view' LIMIT 1);
SET @rolid_32 = (8);
SET @rolid_33 = (3);
SET @rolid_34 = (7);
SET @wid_35 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='main.node' LIMIT 1);
SET @yid_36 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_fields_form' LIMIT 1);
SET @yid_37 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_modelfields_form' LIMIT 1);
SET @yid_38 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklist_form' LIMIT 1);
SET @yid_39 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklistvalues_form' LIMIT 1);
SET @yid_40 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_button_widget' LIMIT 1);
SET @yid_41 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_model_form' LIMIT 1);
SET @yid_42 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_icon_widget' LIMIT 1);
SET @did_43 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='role_user_access' LIMIT 1);
SET @sid_44 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fieldstrans' LIMIT 1);
SET @sid_45 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfieldstrans' LIMIT 1);
SET @sid_46 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklisttrans' LIMIT 1);
SET @sid_47 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvaluestrans' LIMIT 1);
SET @ref_yid_48 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_modelfields_allowed_views' LIMIT 1);
SET @ref_yid_49 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklist_listing_nested_values' LIMIT 1);
SET @ref_yid_50 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklist_listing_listedit_values' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_default_settings' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('design_fields_form_fieldset_column','design_fields_form_layout_form_specific','design_fields_form_layout_listing_specific') LIMIT 3;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_modelfields_form_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('design_modelfields_form_layout_field_params','design_modelfields_form_layout_listing_params','design_modelfields_form_general') LIMIT 3;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_column_2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('design_fields_form_default_settings') LIMIT 1;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('design_picklistvalues_form_tab_value') LIMIT 1;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('design_picklistvalues_form_sample','design_picklistvalues_form_advance') LIMIT 2;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_row1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('design_picklistvalues_form_column1','design_picklistvalues_form_column2') LIMIT 2;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_row2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('design_picklistvalues_form_column3') LIMIT 1;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklist_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('design_picklist_form_column1','design_picklist_form_column2') LIMIT 2;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_column_1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('main_fields_form_main_fields_main_fields_name','main_fields_form_main_fields_main_fields_description','main_fields_form_main_fields_main_fields_alias','main_fields_form_main_fields_main_fields_namekey','main_fields_form_main_fields_main_fields_category','main_fields_form_main_fields_main_fields_form','main_fields_form_main_fields_main_fields_listing','main_fields_form_main_fields_main_fields_rolid','main_fields_form_main_fields_main_fields_publish') LIMIT 9;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_fieldset_column' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('design_fields_form_fields_columntype','design_fields_form_fields_columnattributes','design_fields_form_fields_columnmamdatory','design_fields_form_fields_columnsize','design_fields_form_fields_columndefault') LIMIT 5;
SET @p_1_10 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_layout_listing_specific' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_10 WHERE `namekey` IN ('design_fields_form_layout_listing_specific_nested') LIMIT 1;
SET @p_1_11 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_fields_form_layout_form_specific' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_11 WHERE `namekey` IN ('design_fields_form_layout_field_specific_nested') LIMIT 1;
SET @p_1_12 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_modelfields_form_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_12 WHERE `namekey` IN ('design_modelfields_form_design_modelfieldstrans_name','design_modelfields_form_design_model_fields_design_modelfields_namekey','design_modelfields_form_design_modelfieldstrans_description','design_modelfields_form_design_model_fields_fieldid','design_modelfields_form_design_model_fields_design_initialvalue','design_modelfields_form_design_model_fields_design_modelfields_rolid','design_modelfields_form_design_model_fields_design_modelfields_rolid_edit','design_modelfields_form_design_model_fields_design_modelfields_searchable','design_modelfields_form_design_model_fields_design_modelfields_advsearchable','design_modelfields_form_design_model_fields_design_modelfields_required','design_modelfields_form_design_model_fields_design_modelfields_publish') LIMIT 11;
SET @p_1_13 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_modelfields_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_13 WHERE `namekey` IN ('design_modelfields_form_design_model_fields_design_modelfields_x_updateall','design_modelfields_form_layout','design_modelfields_form_design_model_fields_design_modelfieldstype_type') LIMIT 3;
SET @p_1_14 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_modelfields_form_layout_field_params' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_14 WHERE `namekey` IN ('design_modelfields_form_layout_field_params_nested') LIMIT 1;
SET @p_1_15 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_modelfields_form_layout_listing_params' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_15 WHERE `namekey` IN ('design_modelfields_form_layout_listing_params_nested') LIMIT 1;
SET @p_1_16 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklist_form_column1' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_16 WHERE `namekey` IN ('design_picklist_form_name','design_picklist_form_description','design_picklist_form_access','design_picklist_form_namekey','design_picklist_form_publish') LIMIT 5;
SET @p_1_17 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklist_form_column2' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_17 WHERE `namekey` IN ('design_picklist_form_allowothers','design_picklist_form_choose_parent','design_picklist_form_style') LIMIT 3;
SET @p_1_18 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklist_form_values' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_18 WHERE `namekey` IN ('design_picklist_form_values_nested') LIMIT 1;
SET @p_1_19 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_tab_value' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_19 WHERE `namekey` IN ('design_picklistvalues_form_values_parent','design_picklistvalues_form_name','design_picklistvalues_form_value','design_picklistvalues_form_order','design_picklistvalues_form_save') LIMIT 5;
SET @p_1_20 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_advance' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_20 WHERE `namekey` IN ('design_picklistvalues_form_premium','design_picklistvalues_form_color','design_picklistvalues_form_inputbox','design_picklistvalues_form_publish','design_picklistvalues_form_rolid') LIMIT 5;
SET @p_1_21 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_sample' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_21 WHERE `namekey` IN ('design_picklistvalues_form_sample_nested') LIMIT 1;
SET @p_1_22 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_picklistvalues_form_column3' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_22 WHERE `namekey` IN ('design_picklistvalues_form_list_value') LIMIT 1;
SET @p_1_23 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_button_widget_popup' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_23 WHERE `namekey` IN ('design_button_widget_ispopup','design_button_widget_popUpWidth','design_button_widget_popUpHeight') LIMIT 3;
SET @p_1_24 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_button_widget_button' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_24 WHERE `namekey` IN ('design_button_widget_text','design_button_widget_link','design_button_widget_target','design_button_widget_size') LIMIT 4;
SET @p_1_25 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='design_button_widget_icon' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_25 WHERE `namekey` IN ('design_button_widget_icon_icon','design_button_widget_color') LIMIT 2;
SET @yid_51 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_fields_listing' LIMIT 1);
SET @yid_52 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_model_listing' LIMIT 1);
SET @yid_53 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_modelfields_listing' LIMIT 1);
SET @yid_54 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklist_listing' LIMIT 1);
SET @yid_55 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='design_picklist_listing_values' LIMIT 1);
SET @did_56 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='design_picklist_type' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_fields_listing_main_fields_main_fields_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('main_fields_listing_main_fields_main_fields_description') LIMIT 1;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='main_model_listing_main_model_main_model_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('main_model_listing_main_model_main_model_description') LIMIT 1;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='design_modelfields_listing_design_modelfieldstrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('design_modelfields_listing_design_modelfieldstrans_description') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='design_modelfields_allowed_views_view_alias' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('design_modelfields_allowed_views_viewtrans_name','design_modelfields_allowed_views_viewtrans_description') LIMIT 2;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='2curjtz725' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('2curjtz726','2curjtz727','2curjtz728') 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'),('Copy','1','1206732372QTKK'),('Delete','1','1206732372QTKL'),('Show','1','1206732372QTKM'),('Publish','1','1206732372QTKN'),('Model','1','1206732388KEHV'),('Picklist','1','1206732388KEHY'),('View','1','1206732388KEHZ'),('Level','1','1206732389NXTA'),('Names','1','1206732389NXTC'),('Column','1','1206732389NXTO'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Type','1','1206732392OZVD'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('Apply','1','1206732399EINC'),('Divider','1','1206732399EINF'),('ID','1','1206732400OWXG'),('Text','1','1206732400OWYY'),('General','1','1206732400OWZR'),('Standard','1','1206732405TIXC'),('Category','1','1206732411EGQO'),('divider','1','1206732411EGRN'),('Parent','1','1206732412DAEM'),('Access','1','1206732412DAEO'),('Models','1','1206732420EIUR'),('Ordering','1','1206732421RJQW'),('Attributes','1','1206732421RJQZ'),('Default','1','1206732425HINT'),('Date','1','1206961850KLRI'),('Views','1','1206961854HENY'),('Icon','1','1206961869IGNB'),('Header','1','1206961869IGNC'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Form','1','1206961869IGNH'),('Link','1','1206961869IGNO'),('Order','1','1206961869IGNP'),('Style','1','1206961869IGOF'),('Menu','1','1206961870KLBH'),('Size','1','1206961877KAKC'),('Value','1','1206961878BMAO'),('Back','1','1206961882TDHA'),('Available','1','1206961996STAF'),('Path','1','1209034856HUVS'),('Pick-lists','1','1209559180DARX'),('Values','1','1209675038APRU'),('Mandatory','1','1211811557LMRI'),('Default Value','1','1211811557LMRL'),('Alias','1','1211811583DBTA'),('Table','1','1212662234CPQC'),('Prefix','1','1212669853FLEL'),('Listing','1','1212761197FHZN'),('Searchable','1','1213200894KHAM'),('Params','1','1217251965LDUE'),('Folder','1','1217603897AYYA'),('Numeric','1','1219769904NDIJ'),('Required','1','1219769904NDIO'),('Special','1','1219769904NDIP'),('Button','1','1219769905FKPU'),('Specify a description for the pick list.','1','1219769906LJNM'),('Name of the Picklist','1','1219769906LJNO'),('Pick-list','1','1219769913SSOH'),('You have to specify a name for your column','1','1220215719BHFI'),('Can not create the file path','1','1220215906LFIQ'),('An error occurred, the code file has not been recorded.','1','1220263310JRFM'),('Code file deleted','1','1220263310JRFN'),('An error occurred, the code file has not been deleted.','1','1220263310JRFO'),('The code file has not been loaded.','1','1220263310JRFP'),('Matching code file not found','1','1220263310JRFR'),('Types','1','1220793707SOED'),('nested','1','1227580858CXTV'),('Close','1','1228820287MBVC'),('Nested','1','1233297975SESK'),('Dropdown','1','1242282434IPJB'),('Advanced','1','1242282439OJUW'),('Done','1','1242282449PIPC'),('Media','1','1242282450QJCF'),('Tooltip','1','1242282452RPKT'),('All Types','1','1251298684SHUH'),('Tag: \"extends xxxx {\" not found in $SHOWFILEP','1','1263970750NGKF'),('Column 1','1','1298350843FMVJ'),('Column 2','1','1298350843FMVK'),('Sid','1','1302502783BNRP'),('','1','1304525968YBL'),('Controller only accepts Alphanumerics and Dash!','1','1309938333EEVB'),('You can now assign your view \"$shownamekey\" to any of your \"$controller\" tasks. ','1','1309938333EEVC'),('Go to listing now!','1','1309938333EEVD'),('Go to your generated view!','1','1309938333EEVE'),('You can\'t use the function name $RESERVED_FUNCTION, it is a reserved name.  The function has been renamed with ...Reserved suffixed.','1','1309938525PUJW'),('Tag1: \"$SHOWBOTBOUNDARY\" not found in $SHOWFILEP','1','1309938525PUJX'),('Tag2: \"$headBoundary\" not found in $SHOWFILEP','1','1309938525PUJY'),('Any Type','1','1327708944HAPH'),('Edit Access','1','1335905027HUYP'),('Field','1','1335905452QHTH'),('Rolid','1','1347652452OQAE'),('Suffix','1','1355434007BBZS');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Fields','1','1355852601LJIH'),('Dbtid','1','1355852782MQER'),('Extended','1','1355852783DYRA'),('Checkval','1','1355852783DYRB'),('Extstid','1','1355852783DYRC'),('The name of the listing element to use.<br>','1','1355852784RQNP'),('The name of the form element to use.<br>','1','1355852784RQNQ'),('The specified field type is not defined','1','1356698577BYSZ'),('A view need to be selected.','1','1356698577BYTA'),('Choose a field type','1','1356698582LCCK'),('View Fields','1','1356698583QHMX'),('Fdid','1','1356698583QHMY'),('View Access','1','1356698583QHMZ'),('Modified Date','1','1356698583QHNA'),('Edit Details','1','1356698583QHNB'),('Update All','1','1356698583QHNC'),('Default Column','1','1356698583QHNE'),('Auto Update all Elements','1','1356698583QHNF'),('Default Settings','1','1356698583QHNH'),('Form Preferences','1','1356698583QHNI'),('Listing Preferences','1','1356698583QHNJ'),('Define the required access to view the field.<br>','1','1356698584EBNZ'),('Optional, the name of the field in the database.<br>','1','1356698584EBOA'),('Enable to publish or unpublish the field from all views.<br>','1','1356698584EBOB'),('Define if the field should be searchable.<br>','1','1356698584EBOC'),('Name of the field which will be displayed to the user.<br>','1','1356698584EBOD'),('A description to explain the field. The description will be showed to the user.<br>','1','1356698584EBOE'),('Define the required access to edit the field.<br>','1','1356698584EBOF'),('Choose the type of field you want to create.<br>','1','1356698584EBOG'),('The default value for new value.<br>','1','1356698584EBOH'),('Define if the field should be required.<br>','1','1356698584EBOI'),('The category of the field.<br>','1','1356698584EBOJ'),('Yes will update all view\'s elements when saving the field ( for instance: name, description, access, etc...)<br>No will enable to have different settings for different view\'s elements.<br>','1','1356698584EBOK'),('Fields Definition','1','1356698584EBOL'),('Field Definition','1','1356698584EBOM'),('Link target','1','1356733768PTQW'),('Models & Fields','1','1356733772QJIA'),('Add / Edit','1','1357058833TGKT'),('Radio list','1','1357058839QZXR'),('Checkbox list','1','1357058839QZXS'),('Multiple Select list','1','1357058839QZXT'),('Checkbox in Multiple Select','1','1357058839QZXU'),('Predefined Values','1','1357058839QZXV'),('PHP code','1','1357058839QZXW'),(' - Last Element -','1','1357058839QZXX'),('Add / Edit one value','1','1357058841KKEQ'),('Picklist Sample','1','1357058841KKER'),('The name displayed in the pick-list.<br>','1','1357058841KKET'),('A numeric value, corresponding to the pick-list name.<br>Leave blank for default.<br>','1','1357058841KKEU'),('Define if this value is the default value when no data is selected.<br>','1','1357058841KKEV'),('All Models','1','1357138790PDJD'),('List of available pick-lists','1','1357138793DWSZ'),('<p><strong>New</strong>: Create a new pick-list. Define a name, description and user access.<br />\r\nThe &quot;<strong>Values</strong>&quot; column defines how many values are in the pick-list. Click on &quot;<strong>Add / Edit</strong>&quot; to add new values, or edit the existing one.<br />\r\nUnpublish a pick-list to temporarily disable it.</p>\r\n\r\n<div>&nbsp;</div>\r\n\r\n<div>The column core define if a pick-list is one you created ( Core = unlocked ) or one which come with the application&nbsp;&nbsp;( Core = locked )<br />\r\n&nbsp;</div>','1','1357138793DWTA'),('Form Parameters','1','1357230914NZVE'),('Listing Parameters','1','1357230914NZVF'),('Edit View','1','1357697641QROB'),('List of custom Fields','1','1359486554KQXA'),('How to design your custom fields?','1','1359486554KQXB'),('This is the list of all fields you have created for the specified model.<br><u>Name</u>: the name which will appear either as the title of the form element or the column header.<br><u>Column</u>: the name of the column in the database\'s table.<br><u>Type</u>: the type of field you have created.<br><u>Order</u>: please note that the ordering might not be exactly the ordering in the view itself as the field can be added in many different views and in many different area in each of those views.<br><u>Update All</u>: Define if all the views should be updated when the field is modified.  For instance if you want to change the name of the field throughout all the views. Usually you keep the Update All as Yes. However you could turn it to No if you wish to customized each view.<br><br>','1','1359486555TEWI'),('Field type','1','1359742651HQYX'),('The column $COLUMNNAME already exist! Please choose a different name.','1','1369750859IGJB'),('Sorry, the system lost a parameter, so we need to reset. Simply try again and it all will be fine','1','1369750869THVV'),('The form element could not be saved because there is no reference to a view.','1','1375977746FUII'),('Container','1','1380064817JISM'),('Define in which container the field should be added.','1','1380228929NBOQ'),('Advance Search','1','1382068744SDQH'),('<p>This is a list of all Models ( representation of database tables ), to which you can add customized fields.<br />\r\n<br />\r\nThe column table indicate in which database&#39;s table the data will be stored.</p>\r\n\r\n<p><strong>Related Model</strong> are model which share the same table<br />\r\n<br />\r\nThe column fields indicated how many customized fields you have already created.<br />\r\n<strong>To add a new field</strong> simply click on the Fields column and follow the next wizard.</p>','1','1382669061IVFW'),('Define if the field can be searchable with the advance search functionality.<br>','1','1383926331ELHS'),('The value you entered is already used in this pick-list, please use another value!','1','1387417576HDLZ'),('row1','1','1394069593IQAQ'),('row2','1','1394069593IQAR'),('column1','1','1394069593IQAS'),('column2','1','1394069593IQAT'),('Assignment','1','1394069857XFX'),('column3','1','1395500493HQVV'),('Color','1','1395886787SVJW'),(' ( Area: $AREANAME )','1','1397855844SRLO'),('Identifier','1','1398436917DTKC'),('Define a button','1','1400708734QLWH'),('Icon size','1','1400708900IRZT'),('Icon color','1','1400708900IRZU'),('Choose an icon','1','1400708900IRZV'),('An optional tooltip<br>','1','1400708900IRZW'),('Choose the icon size.<br>','1','1400708900IRZX'),('Choose the icon color.<br>','1','1400708900IRZY'),('Define the button text<br>','1','1400708900IRZZ'),('Choose the button size.<br>','1','1400708901APLS'),('Bootstrap Icon widget','1','1400708901APLT'),('Bootstrap Button widget','1','1400708901APLU'),('Create PopUp','1','1400788093LHUB'),('Is PopUp','1','1400788093LHUC'),('PopUp Width','1','1400788093LHUD'),('PopUp Height','1','1400788093LHUE'),('The link for the button<br>','1','1400788093LHUF'),('The link target tag for the button<br>','1','1400788093LHUG'),('Icon animation','1','1400812016CMWY'),('Choose an icon animation','1','1400812017YLA'),('Fancy Multiple Select','1','1403978942AEUG'),('Choose Parent','1','1409860322PSNC'),('Parent Value','1','1409860322PSND'),('Choose a parent pick-list to have the pick-list depends on the selected value from another pick-list.','1','1409860322PSNE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Choose the value of the parent pick-list.','1','1409860322PSNF'),('User value','1','1409955038JEIA'),('There can be only one value define as&nbsp;“User value”.&nbsp;<div>If User value is turn on, the child pick list will show an input box so that the user can enter a specific value rather than choosing a predefined value.</div>','1','1409955038JEIB'),('Allow User Value','1','1417090743CGRN'),('Defines the minimum access for the pick-list.','1','1417090743CGRO'),('If User value is turn on, it will allow to defined a pick-list choice called “Other”, which allow the user to specify their own value.','1','1417090743CGRP'),('This is the Name of the parent value','1','1417207362AUVU'),('This is the value of the parent piccoloist','1','1417207362AUVV'),('<u><b>Step 1:</b></u> define a name for your field. Optionally you can specify a column name.<br>A description is always advisable as it will inform the user on what the field is used for a and show be completed. The description will appear as the tool-tips on the form.<br>Define the type of fields you want to created. Please refer to the documentation for details information on each fields.<br><br><b><u>Step 2:</u></b> finish to complete the information on the left column regarding the default value for the field, the different access level, searchable and required. Those are usually application throughout all the views identically.<br><br><u><b>Step 3:</b></u> Choose the views ( or \"page\" ) to which you want this field to be applied. You do so by clicking on the Available column or button. Once you have done so, you might see new information appearing like the Area or Details Edit.<br>Use the <b><i>Area</i></b> to define in which area the field should be rendered.<br><i><b>Edit Details</b></i> let you customized how the field is specifically rendered in that view.<br><i><b>Edit View</b></i> let you access the all the view elements to make more involved changes to that view.<br><br><u><b>Step 4:</b></u> (optional) In the lower right you can customize some parameters related to that field for the form element or listing element. See documentation for more details.<br><br><br>','1','1418159507MBBP'),('The field \"$FIELD\" already exists!','1','1418159512LBWK'),('Specify a identifier.  Preferably starting with the extension prefix.','1','1418398709LVIH'),('Choose the color of the value','1','1418398709LVII'),('Foreign key inserted','1','1418694571IHYE'),('Unique Key inserted','1','1418694571IHYF'),('$total Views updated with the new column name','1','1418694571IHYG'),('Define the look and feel of the pick-list.','1','1421361227IJHC'),('The field already exist!','1','1423647407JIHV');
SET @ctid_57 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_multiform_yid_publish_level_rolid_ordering' LIMIT 1);
SET @ctid_58 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_layout_listing_yid_publish_level_rolid_hidden_ordering' LIMIT 1);
SET @ctid_59 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_dropset_node_wid_publish_level_rolid' LIMIT 1);
SET @dbcid_60 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621sid' LIMIT 1);
SET @dbcid_61 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='994fdid' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (@ctid_57,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (@ctid_57,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1publish' LIMIT 1)),(@ctid_57,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ordering' LIMIT 1)),(@ctid_57,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_multiforms_fid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1)),(@ctid_58,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1)),(@ctid_58,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3publish' LIMIT 1)),(@ctid_58,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3ordering' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_layout_listings_lid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1)),(@ctid_58,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3level' LIMIT 1)),(@ctid_58,'6','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3hidden' LIMIT 1)),(@ctid_59,'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4wid' LIMIT 1)),(@ctid_59,'0','1',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4publish' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_values_did_value' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6did' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_node_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4namekey' LIMIT 1)),(@ctid_59,'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_formstrans_fid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_view_listingstrans_lid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklisttrans_did_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512did' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklisttrans_did_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklist_valuestrans_vid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541vid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_values_did_value' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6value' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_picklist_valuestrans_vid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541lgid' LIMIT 1)),(@ctid_59,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4rolid' LIMIT 1)),(@ctid_58,'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1)),(@ctid_57,'4','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_listings_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_layout_forms_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_dataset_columns' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbcid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dbtid_columnname' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbtid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dbtid_columnname' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616name' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_trans_sid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618sid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_trans_sid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_model_node_sid' LIMIT 1),'1','0',@dbcid_60),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_dbtic' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_model_node_namekey' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621level' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_model_node_prefix_level' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621prefix' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dataset_columns' LIMIT 1),'0','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_dropset_values_namekey' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey6' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fields|main_library' LIMIT 1),'1','0',@dbcid_61),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_model_fields' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey994' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_fields_node|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='995fieldid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_fields_trans|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996fieldid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_fields_trans|main_library' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_fields_node' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey995' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fieldstrans|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998fdid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fieldstrans|main_library' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_layout_fields|main_library' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999yid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_layout_fields|main_library' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999fdid' LIMIT 1));
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fields_type|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1008fdid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_model_fields_type|main_userdata' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1008typeid' LIMIT 1));
SET @ref_feid_62 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='2yid' LIMIT 1);
SET @ref_feid_63 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4did' LIMIT 1);
SET @ref_feid_64 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1);
SET @ref_feid_65 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1);
SET @pk_77_232 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'4wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_235 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_238 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_239 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'6did\' LIMIT 1' LIMIT 1 );
SET @pk_77_286 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1did\' LIMIT 1' LIMIT 1 );
SET @pk_77_301 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'4sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_474 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_545 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'482fid\' LIMIT 1' LIMIT 1 );
SET @pk_77_546 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'482lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_547 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'484lid\' LIMIT 1' LIMIT 1 );
SET @pk_77_548 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'484lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_558 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3did\' LIMIT 1' LIMIT 1 );
SET @pk_77_606 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'512did\' LIMIT 1' LIMIT 1 );
SET @pk_77_607 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'512lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_1004 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10387 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'4rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10388 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10389 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10408 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'6rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10419 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'541vid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10420 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'541lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10516 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'616rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10521 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'618sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10522 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'618lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10527 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_21 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'621dbtid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10528 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'621rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10547 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_21 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'616dbtid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10570 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.multiforms\' LIMIT 1' AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10571 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.listings\' LIMIT 1' AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10600 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1ref_yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10602 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'4ref_sid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11134 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid994\' LIMIT 1' LIMIT 1 );
SET @pk_77_11135 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid994\' LIMIT 1' LIMIT 1 );
SET @pk_77_11136 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_22 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid995\' LIMIT 1' LIMIT 1 );
SET @pk_77_11137 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_19 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid995\' LIMIT 1' LIMIT 1 );
SET @pk_77_11138 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_14 AND `ref_dbtid`=@dbtid_13 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'996fieldid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11139 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_14 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'996lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11140 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'sid994\' LIMIT 1' LIMIT 1 );
SET @pk_77_11143 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_15 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'998fdid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11144 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_15 AND `ref_dbtid`=@dbtid_20 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'998lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11145 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_16 AND `ref_dbtid`=@dbtid_18 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'999yid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11146 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_16 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'999fdid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11147 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'fdid3\' LIMIT 1' LIMIT 1 );
SET @pk_77_11148 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'fdid1\' LIMIT 1' LIMIT 1 );
SET @pk_77_11149 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'layout.fields\' LIMIT 1' AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'parent999\' LIMIT 1' LIMIT 1 );
SET @pk_77_11150 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_13 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'type994\' LIMIT 1' LIMIT 1 );
SET @pk_77_11153 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'wid995\' LIMIT 1' LIMIT 1 );
SET @pk_77_11167 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_17 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'1008fdid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11449 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dropset.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'parent4\' LIMIT 1' LIMIT 1 );
SET @pk_77_11452 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'dropset.values\' LIMIT 1' AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'parent6\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('wid','1','FK_dropset_node_wid',@pk_77_232,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),@dbtid_1,'1');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('yid','1','FK_layout_multiforms_yid',@pk_77_235,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1yid' LIMIT 1),@ref_feid_62,'3','3','yid',@dbtid_18,@dbtid_3,'2'),('yid','1','FK_layout_listings_yid',@pk_77_238,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3yid' LIMIT 1),@ref_feid_62,'3','3','yid',@dbtid_18,@dbtid_2,'5'),('did','1','FK_dropset_values_did',@pk_77_239,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6did' LIMIT 1),@ref_feid_63,'3','3','did',@dbtid_1,@dbtid_11,'99'),('did','1','FK_layout_multiforms_did',@pk_77_286,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1did' LIMIT 1),@ref_feid_63,'1','1','did',@dbtid_1,@dbtid_3,'4'),('sid','1','FK_dropset_node_sid',@pk_77_301,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4sid' LIMIT 1),@dbcid_60,'1','3','sid',@dbtid_10,@dbtid_1,'3'),('sid','1','FK_layout_multiforms_sid',@pk_77_474,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1sid' LIMIT 1),@dbcid_60,'1','1','sid',@dbtid_10,@dbtid_3,'6'),('fid','1','FK_layout_multiformstrans_fid',@pk_77_545,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482fid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1),'3','3','fid',@dbtid_3,@dbtid_4,'1'),('lgid','1','FK_layout_multiformstrans_lgid',@pk_77_546,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482lgid' LIMIT 1),@ref_feid_64,'1','3','lgid',@dbtid_20,@dbtid_4,'2'),('lid','1','FK_layout_listingstrans_lid',@pk_77_547,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1),'3','3','lid',@dbtid_2,@dbtid_5,'1'),('lgid','1','FK_layout_listingstrans_lgid',@pk_77_548,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484lgid' LIMIT 1),@ref_feid_64,'1','1','lgid',@dbtid_20,@dbtid_5,'2'),('did','1','FK_listings_dropset_did',@pk_77_558,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3did' LIMIT 1),@ref_feid_63,'1','1','did',@dbtid_1,@dbtid_2,'3'),('did','1','FK_picklist_trans_did',@pk_77_606,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512did' LIMIT 1),@ref_feid_63,'3','3','did',@dbtid_1,@dbtid_6,'99'),('lgid','1','FK_picklist_trans_lgid',@pk_77_607,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='512lgid' LIMIT 1),@ref_feid_64,'1','1','lgid',@dbtid_20,@dbtid_6,'99'),('sid','1','FK_view_listings_sid',@pk_77_1004,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3sid' LIMIT 1),@dbcid_60,'1','1','sid',@dbtid_10,@dbtid_2,'2'),('rolid','1','FK_picklist_rolid',@pk_77_10387,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_1,'2'),('rolid','1','FK_view_listings_rolid',@pk_77_10388,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_2,'1'),('rolid','1','FK_view_forms_rolid',@pk_77_10389,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_3,'5'),('rolid','1','FK_picklist_values_rolid',@pk_77_10408,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_11,'99'),('vid','1','FK_picklist_valuestrans_vid',@pk_77_10419,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541vid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='6vid' LIMIT 1),'3','3','vid',@dbtid_11,@dbtid_7,'99'),('lgid','1','FK_picklist_valuestrans_lgid',@pk_77_10420,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='541lgid' LIMIT 1),@ref_feid_64,'1','3','lgid',@dbtid_20,@dbtid_7,'99'),('rolid','1','FK_dataset_columns_rolid',@pk_77_10516,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_9,'2'),('sid','1','FK_model.trans_sid',@pk_77_10521,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618sid' LIMIT 1),@dbcid_60,'3','3','sid',@dbtid_10,@dbtid_8,'99'),('lgid','1','FK_model.trans_lgid',@pk_77_10522,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618lgid' LIMIT 1),@ref_feid_64,'1','3','',@dbtid_20,@dbtid_8,'99'),('dbtid','1','FK_model_dbtid',@pk_77_10527,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621dbtid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='549dbtid' LIMIT 1),'1','3','dbtid',@dbtid_21,@dbtid_10,'1'),('rolid','1','FK_model_rolid',@pk_77_10528,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='621rolid' LIMIT 1),@ref_feid_65,'1','1','',@dbtid_22,@dbtid_10,'2'),('dbtid','1','FK_dataset_columns_dbtid',@pk_77_10547,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='616dbtid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='549dbtid' LIMIT 1),'3','3','',@dbtid_21,@dbtid_9,'1'),('parent','1','FKParent_fid',@pk_77_10570,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1fid' LIMIT 1),'1','1','fid',@dbtid_3,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiforms' LIMIT 1),'1'),('parent','1','FK_Parent3_parentlid',@pk_77_10571,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3lid' LIMIT 1),'1','1','lid',@dbtid_2,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listings' LIMIT 1),'4'),('ref_yid','1','FK_multiforms_layout_nestedlayout',@pk_77_10600,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1ref_yid' LIMIT 1),@ref_feid_62,'1','3','yid',@dbtid_18,@dbtid_3,'3'),('ref_sid','1','FK_dropset_node_ref_sid',@pk_77_10602,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='4ref_sid' LIMIT 1),@dbcid_60,'3','3','sid',@dbtid_10,@dbtid_1,'4'),('rolid','1','FK_model_fields_rolid',@pk_77_11134,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid994' LIMIT 1),@ref_feid_65,'1','1','rolid',@dbtid_22,@dbtid_12,'3'),('uid','1','FK_model_fields_uid',@pk_77_11135,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid994' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'1','1','uid',@dbtid_19,@dbtid_12,'2'),('rolid','1','FK_fields_node_rolid',@pk_77_11136,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid995' LIMIT 1),@ref_feid_65,'1','1','rolid',@dbtid_22,@dbtid_13,'3'),('uid','1','FK_fields_node_uid',@pk_77_11137,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid995' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1),'1','1','uid',@dbtid_19,@dbtid_13,'2'),('fieldid','1','FK_fields_trans_fields_node_fieldid',@pk_77_11138,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996fieldid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='995fieldid' LIMIT 1),'3','3','fieldid',@dbtid_13,@dbtid_14,'1'),('lgid','1','FK_fileds_trans_languages_lgid',@pk_77_11139,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='996lgid' LIMIT 1),@ref_feid_64,'1','1','lgid',@dbtid_20,@dbtid_14,'2'),('sid','1','FK_model_fields_sid',@pk_77_11140,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sid994' LIMIT 1),@dbcid_60,'3','3','sid',@dbtid_10,@dbtid_12,'1'),('fdid','1','FK_model_fieldstrans_fdid',@pk_77_11143,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998fdid' LIMIT 1),@dbcid_61,'3','3','fdid',@dbtid_12,@dbtid_15,'1'),('lgid','1','FK_model_fieldstrans_lgid',@pk_77_11144,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='998lgid' LIMIT 1),@ref_feid_64,'1','1','lgid',@dbtid_20,@dbtid_15,'2'),('yid','1','FK_layout_fields_yid',@pk_77_11145,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999yid' LIMIT 1),@ref_feid_62,'3','3','yid',@dbtid_18,@dbtid_16,'1'),('fdid','1','FK_layout_fields_fdid',@pk_77_11146,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='999fdid' LIMIT 1),@dbcid_61,'3','3','fdid',@dbtid_12,@dbtid_16,'2'),('fdid','1','FK_layout_listings_fdid',@pk_77_11147,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid3' LIMIT 1),@dbcid_61,'3','3','fdid',@dbtid_12,@dbtid_2,'6'),('fdid','1','FK_layout_forms_fdid',@pk_77_11148,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fdid1' LIMIT 1),@dbcid_61,'3','3','fdid',@dbtid_12,@dbtid_3,'7'),('parent','1','FK_layout_fields_parent',@pk_77_11149,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent999' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent999' LIMIT 1),'1','1','parent',@dbtid_16,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.fields' LIMIT 1),'99'),('fieldid','1','FK_model_fields_fieldid',@pk_77_11150,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='type994' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='995fieldid' LIMIT 1),'3','3','fieldid',@dbtid_13,@dbtid_12,'4'),('wid','1','FK_fields_node_wid',@pk_77_11153,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wid995' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),@dbtid_13,'1'),('fdid','1','FK_model_fields_type_fdid',@pk_77_11167,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='1008fdid' LIMIT 1),@dbcid_61,'3','3','fdid',@dbtid_12,@dbtid_17,'1'),('parent','1','FK_dropset_node_parent',@pk_77_11449,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent4' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent4' LIMIT 1),'1','1','parent',@dbtid_1,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.node' LIMIT 1),'99'),('parent','1','FK_dropset_values_parent',@pk_77_11452,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent6' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parent6' LIMIT 1),'1','1','parent',@dbtid_11,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='dropset.values' LIMIT 1),'99');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_24,'1','1206732372QTKM');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_24,'1','1206732405TIXC'),(@wid_24,'1','1206961869IGNH'),(@wid_24,'1','1206961870KLBH'),(@wid_24,'1','1212761197FHZN'),(@wid_24,'1','1219769904NDIJ'),(@wid_24,'1','1219769904NDIP'),(@wid_24,'1','1219769905FKPU'),(@wid_24,'0','1220215719BHFI'),(@wid_24,'0','1220215906LFIQ'),(@wid_24,'1','1220263310JRFM'),(@wid_24,'1','1220263310JRFN'),(@wid_24,'1','1220263310JRFO'),(@wid_24,'1','1220263310JRFP'),(@wid_24,'0','1220263310JRFR'),(@wid_24,'1','1242282434IPJB'),(@wid_24,'1','1242282439OJUW'),(@wid_24,'1','1242282450QJCF'),(@wid_24,'1','1251298684SHUH'),(@wid_24,'0','1263970750NGKF'),(@wid_24,'0','1309938333EEVB'),(@wid_24,'1','1309938333EEVC'),(@wid_24,'1','1309938333EEVD'),(@wid_24,'1','1309938333EEVE'),(@wid_24,'0','1309938525PUJW'),(@wid_24,'0','1309938525PUJX'),(@wid_24,'0','1309938525PUJY'),(@wid_24,'1','1355852601LJIH'),(@wid_24,'0','1356698577BYSZ'),(@wid_24,'0','1356698577BYTA'),(@wid_24,'1','1356698582LCCK'),(@wid_24,'1','1357058833TGKT'),(@wid_24,'1','1357058839QZXR'),(@wid_24,'1','1357058839QZXS'),(@wid_24,'1','1357058839QZXT'),(@wid_24,'1','1357058839QZXU'),(@wid_24,'1','1357058839QZXX'),(@wid_24,'1','1357138790PDJD'),(@wid_24,'0','1369750859IGJB'),(@wid_24,'0','1369750869THVV'),(@wid_24,'0','1375977746FUII'),(@wid_24,'0','1387417576HDLZ'),(@wid_24,'1','1397855844SRLO'),(@wid_24,'1','1400708734QLWH'),(@wid_24,'1','1403978942AEUG'),(@wid_24,'0','1418159512LBWK'),(@wid_24,'0','1418694571IHYE'),(@wid_24,'0','1418694571IHYF'),(@wid_24,'0','1418694571IHYG'),(@wid_24,'0','1423647407JIHV');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_24),'','','','','','','','','','','0','');
SET @dbcid_66 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_24,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description996' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_24,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name996' LIMIT 1)),(@wid_24,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618description' LIMIT 1)),(@wid_24,'0','',@dbcid_66),(@wid_24,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description998' LIMIT 1)),(@wid_24,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name998' LIMIT 1)),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fields' LIMIT 1),'1335905452QHTH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.fieldstrans' LIMIT 1),'1335905452QHTH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.model' LIMIT 1),'1206732388KEHV',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modeltrans' LIMIT 1),'1206732388KEHV',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfields' LIMIT 1),'1335905452QHTH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfieldstrans' LIMIT 1),'1335905452QHTH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.columns' LIMIT 1),'1206732389NXTO',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewfields' LIMIT 1),'1356698583QHMX',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewforms' LIMIT 1),'1206961869IGNH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewformstrans' LIMIT 1),'1206961869IGNH',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewlistings' LIMIT 1),'1212761197FHZN',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.viewlistingstrans' LIMIT 1),'1212761197FHZN',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklist' LIMIT 1),'1206732388KEHY',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklisttrans' LIMIT 1),'1206732388KEHY',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvalues' LIMIT 1),'1206961878BMAO',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.picklistvaluestrans' LIMIT 1),'1206961878BMAO',@dbcid_66),(@wid_24,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='design.modelfieldstype' LIMIT 1),'1359742651HQYX',@dbcid_66);