/*Export of the extension comment.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1212761231MDKH','1206732411EGQO','1206964391FHVU','1235461972DIWA','1246509662FEPJ','1219769904NDHD','1206732411EGRG','1327547574PRQA','1327547575DXVE','1229653442FEQZ','1206732412DAGC','1304253943KWEJ','1246243851IGLH','1206732400OWZR','1206961869IGND','1251534828ITXB','1302502838CVPP','1298350843FMVC','1298350843FMVD','1206961882TDGU','1251534828ITXF','1340666912COKB','1251534828ITXH','1206732392OZVB','1251534828ITXI','1304525968YBL','1206961912MJQH','1251534828ITXM','1251534828ITXN','1251534828ITXO','1260167447OHGQ','1251534828ITXQ','1246509032AGXF','1298350843FMVE','1254121404KQGF','1254409114PQTC','1251534828ITXJ','1219769905FKPR','1206961882TDGX','1206964391FHVV','1206732399EINB','1262855105MYEP','1262855105MYEQ','1228709252AHXW','1262857562MQDL','1298350843FMVF','1263274593RGXW','1206964391FHVD','1298350843FMVG','1298350843FMVH','1340666912COKC','1348175112SGMS','1251534827NBKK','1251534827NBKM','1251534827NBKN','1251534828ITWR','1251534828ITWS','1251534828ITWT','1251534827NBKL','1251534828ITWU','1340666912COKD','1272278975FDGA','1272278975FDGB','1251534828ITXA','1254472360EPGX','1254121403QJCI','1254121403QJCH','1251534828ITWW','1215507805HPST','1234467594BCKE','1263201275SILO','1263201275SILP','1263376343LSCV','1263274592DISC','1418338212OMGQ','1251534828ITWX','1348175112SGMT','1206732391QBUR','1228820287MBVC','1206732412DADY','1206732393CXVV','1206732372QTKL','1206961882TDHA','1242282449PIPC','1206732361LXFE','1298350840ISOI','1253278128ELPD','1206732392OZUP','1206732392OZVA','1206732400OWZO','1206732400OWXG','1251534828ITXT','1251534828ITXU','1251534828ITXV','1206732411EGRV','1206732411EGRU','1209142268NMKA','1242282446GIMI','1206732411EGRY','1234467597SEXU','1251534828ITXY','1206732392OZVG','1251466557JSUA','1251534828ITYA','1251534828ITXZ','1206732392OZVD','1253278128ELPC','1254121405BPLK','1254121404KQGG','1327592640PUQE','1211811583DBTA','1206961882TDHH','1206961936HCWR','1262855106GGLB','1217251965LDTZ','1241402690BDIL','1242282436IIYK','1241769455CJUW','1206732372QTKN','1206961850KLRI','1251534828ITXS','1339527238FIMW','1298350844JHJY','1246243853BGZB','1206961902CIFI','1235461972DIWG','1235461972DIWF','1206732411EGQQ','1260157228RFRM','1400071918PQAT','1262855107BJEZ','1262915431QYDZ','1263278568HIPB','1251534829MVOO','1251534828ITYC','1298350844JHJZ','1247061788DBVR','1254879796ICUL','1251534828ITYD','1251534828ITYG','1251534828ITYI','1254879796ICUK','1272278977AVBY','1254121405BPLL','1272278977AVCA','1251534829MVON','1421321709PLYL','1251534829MVPB','1251534829MVPC','1251534829MVPD','1251534829MVPF','1251534829MVPH','1251534829MVPJ','1251534829MVPK','1251534829MVPL','1251534829MVPM','1251534829MVPN','1251534829MVPO','1251534829MVPP','1251534829MVPQ','1251534829MVPR','1251534829MVPS','1251534829MVPT','1251534829MVPU','1253278129BICP','1253278129BICQ','1254121405BPLN','1254121405BPLR','1254121405BPLS','1254121405BPLT','1254121406FXLU','1254121406FXLV','1254121406FXLW','1254821420BXFM','1254879797GBFK','1262855107BJFA','1206961995OYFV','1262855108FREW','1236926427LMQB','1215001889GXZH','1227581118COMT','1263201278GNSI','1263376346FFLT','1240888719GIAU','1251534829MVOT','1251534829MVOU','1251534829MVOW','1251534829MVOY','1380065076PPZN','1380065076PPZO','1411136092QKNG','1380065076PPZP','1380065076PPZQ','1380065076PPZR','1418159812IACR','1411136092QKNH','1219856743ELFT','1408411778LQEF','1411136092QKNI','1206732372QTKI','1206732372QTKJ','1213117657LKZK','1224166212FTLB','1246243852IPUS','1251795312BCNX','1251795312BCNY','1257243218GPNH','1260242519OFEU','1263201684IZCU','1263274585KCHI','1272278972GKNC','1272278972GKND','1272278972GKNE','1273127872RXWA','1273127872RXWB','1273127873NGVN','1303972032APHM','1306763027PHWE','1307514212KJCT','1307514212KJCU','1307514212KJCV','1307514212KJCW','1307514215TBVS','1307673208ILBE','1307673208ILBF','1327547572MFBV','1327615780QFKY','1338493462CZZH','1338493462CZZI','1344536624AUFN','1344536624AUFO','1395500509GSSS','1408411776NUFZ','1408411776NUGA','1408411776NUGB','1418689659NRQX' );
DELETE `#__dataset_constraints`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_constraints` ON `#__dataset_constraints`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','project.node','project.members','ticket.trans','ticket.replytrans','ticket.node','ticket.reply','role.joomlasections','sections','categories','role.joomlacategories','role.joomlacontent','ticket.clickyesno','content') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','content','project.node','project.members','ticket.node','ticket.trans','ticket.reply','ticket.replytrans','role.joomlasections','sections','categories','role.joomlacategories','role.joomlacontent','ticket.clickyesno','license.node','site.node','joobi.files','joobi.languages','product.node','joobi.countries','ticket.projectmembers','role.node','currency.node','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans','mailing.trans') AND `#__dataset_columns`.`namekey` NOT IN ('206created','206duration','206lcid','206level','206license','206lock1','206lock2','206maintenance','206modified','206nombre','206publish','206stid','206start','206type','206uid','206wid','211stid','211url','211modified','232uid','478filid','478modified','478name','478params','478path','478size','478type','199lgid','199code','199premium','306available','306created','306filid','306modified','306pid','306price','306prodtypid','306publish','306weight','200ctyid','200isocod2','200isocod3','200name','200namekey','200numcode','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','478secure','478uid','356id','382mgid','382lgid','382name','382ctext','382chtml','382smail','382sname','232html','405pjid','405namekey','405type','405lft','405rgt','405parent','405rolid','405ordering','405publish','405modified','405created','405uid','232registered','199name','199main','199publish','199real','478thumbnail','478theight','478twidth','478width','478height','478approved','478modifiedby','232unsub','478mime','481yid','481lgid','481name','481description','482fid','482lgid','482name','482description','484lid','484lgid','484name','485mid','485lgid','485name','206token','206modifiedby','306namekey','484description','206maintype','382rname','382remail','232login','405startdate','405enddate','405priority','526pjid','526role','526uid','532authoruid','532modified','532ordering','532priority','532publish','532tkid','532ticketid','532type','532uid','533description','533lgid','533name','533tkid','534modified','534tkid','534tkrid','534uid','535description','535lgid','535tkrid','306stock','532created','405author','199rtl','532stid','211type','557tkpjid','557uid','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','211ip','566namekey','232rolid','566color','566type','532pjid','405estimatedtime','199availadmin','199availsite','405depth','618sid','618lgid','618name','199locale','624curid','624title','624code','624number','624symbol','624position','624cents','624basic','624publish','624rate','566depth','199localeconv','306curid','private532','publish534','uid534','modified534','resptime532','deadline532','time534','visibility232','rolid306','assignuid532','supportlevel557','rolid534','supportlevel526','rolid532','frontend405','timing534','wordcount534','charcount534','nbreplies532','timing532','wordcount532','charcount532','privatekey211','comment206','elapsed532','oid206','accepted624','ordering624','694id','rolid694','intro694','695id','696id','697id','698id','rolid698','rolid697','intro697','intro698','numcat306','startdate306','enddate306','bundle306','comment306','numdiscount306','714ctrid','714lgid','name714','description714','description485','auto382','fromlgid382','auto481','fromlgid481','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto533','fromlgid533','auto535','fromlgid535','auto618','fromlgid618','auto714','fromlgid714','timezone200','vendid306','lsid306','ltkid405','tickets405','sticky532','lock532','rating532','votes532','rated534','eid532','useful532','usefulclick532','commenttype532','comment534','usefulrate532','ip532','ip534','uid306','761clickid','tkid761','ip761','uid761','created761','yesno761','nbreviews306','score306','votes306','comment532','notify526','oncreation405','onreplies405','toassigned405','sendcopy405','curid232','payment306','title356','created356','state356','domain211','parent211','parent206','bundle206','comment698','comment697','comment694','title695','created695','state695','pricetype306','group405','rating_sum698','rating_num698','unit306','featured306','viewed306','nbsold306','author306','relnum306','followup532','catid356','sectionid356','assignbyuid532','name695','title696','name696','section696','ordering696','published696','modified356','published_up356','publish_down356','mask356','created_by356','created_by_alias356','modified_by356','checked_out356','checked_out_time356','images356','urls356','attribs356','version356','parentid356','ordering356','metakey356','metadesc356','access356','metadata356','hits356','password211','maxsite206','maxproduct206','product206','publish532','read532','publish200','email405','md5478','j16566','electronic306','alias306','availableend306','previewid306','cssclass306','params306','block306','resell306','bouncemail382','authorid382','modified382','intro382','core200','target306','targettotal306','adid306','alias478','rolid_buy306','vendid478','discountrate306','discountprice306','ordering200','modified200','core478','storage478','folder478','ip232','ctyid232','description211','migid306','migrefid306','location306','longitude306','latitude306','core199','core624','featuredate306','nbused206','footer206','latereply532','subtype206','alias211','smsmessage382','mobile232','lcid532','filid232','length306','width306','height306','automatic199','title382','subtitle382','platform206','message485','site_id306') 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 ('232lgid','405uid','526pjid','526uid','534tkid','535tkrid','533tkid','533lgid','532stid','532authoruid','535lgid','232rolid','405rolid','532pjid','405parent','534uid','assignuid532','rolid534','rolid532','rolid694','rolid698','rolid697','694id','697id','698id','tkid761','uid761','curid232','eid532','sectionid356','catid356','section696','ctyid232','lcid532','filid232') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_members_node_lgid','FK_members_rolid','FK_Parent405_parentpjid','FK_project_rolid','FK_405_uid_uid','FK_projectmembers_pjid','FK_projectmembers_uid','FK_tickets_node_authoruid','FK_ticket_authoruid','FK_tickets_node_authoruid2','FK_ticket:project|pjid:pjid','FK_ticket_pjid','FK_ticket_stid','FK_tickettrans_lgid','FK_tickettrans_tkid','FK_task_reply_taskid','FK_ticket_reply_authoruid ','FK_ticket_replytrans_lgid','FK_ticket_replytrans_tkrid','FK_role_joomlasections_id','FK_role_joomlacategories_id','FK_role_joomlacontent_id','FK_ticket_node_assignuid','FK_joomla_content_catid','FK_members_ctyid','FK_members_curid','FK_producttrans_etid','FK_content_id','FK_members_node_filid','FK_ticket_node_lcid','FK_tickets_node_rolid','534_rolid_566','FK_role_joomlasections_rolid','FK_role_joomlacategories_rolid','FK_role_joomlacontent_rolid','section','FK_joomla_content_sectionid','761_tkid_532','761_uid_232') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('comment.node') ;
SET @rolid_0 = (1);
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_356 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='content' LIMIT 1 );
SET @pk_549_405 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.node' LIMIT 1 );
SET @pk_549_526 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.members' LIMIT 1 );
SET @pk_549_532 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.node' LIMIT 1 );
SET @pk_549_533 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.trans' LIMIT 1 );
SET @pk_549_534 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.reply' LIMIT 1 );
SET @pk_549_535 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.replytrans' LIMIT 1 );
SET @pk_549_694 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlasections' LIMIT 1 );
SET @pk_549_695 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sections' LIMIT 1 );
SET @pk_549_696 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='categories' LIMIT 1 );
SET @pk_549_697 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlacategories' LIMIT 1 );
SET @pk_549_698 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlacontent' LIMIT 1 );
SET @pk_549_761 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.clickyesno' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_200 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1 );
SET @pk_549_206 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='license.node' LIMIT 1 );
SET @pk_549_211 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='site.node' LIMIT 1 );
SET @pk_549_306 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_557 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.projectmembers' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_624 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_338 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_309 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1 );
SET @pk_549_323 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.node' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
SET @pk_549_382 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('members_node','members.node',@pk_549_232,'','1.0.0',@rolid_0,'0','1','uid','node','members','51','2','0','0','7');
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('content','content',@pk_549_356,'','1.0.0',@rolid_0,'0','1','id','','content','250','2','0','1','7'),('project_node','project.node',@pk_549_405,'','1.0.0',@rolid_0,'0','40','pjid','node','project','51','2','0','0','7'),('project_members','project.members',@pk_549_526,'','1.0.0',@rolid_0,'0','30','pjid,uid','members','project','51','2','0','0','7'),('ticket_node','ticket.node',@pk_549_532,'','1.0.0',@rolid_0,'0','1','tkid','node','ticket','51','2','0','0','7'),('ticket_trans','ticket.trans',@pk_549_533,'','1.0.0',@rolid_0,'0','20','tkid,lgid','trans','ticket','51','2','0','0','5'),('ticket_reply','ticket.reply',@pk_549_534,'','1.0.0',@rolid_0,'0','1','tkrid','reply','ticket','51','2','0','0','7'),('ticket_replytrans','ticket.replytrans',@pk_549_535,'','1.0.0',@rolid_0,'0','20','tkrid,lgid','replytrans','ticket','51','2','0','0','5'),('role_joomlasections','role.joomlasections',@pk_549_694,'','',@rolid_0,'0','1','id,rolid','joomlasections','role','51','2','0','0','7'),('sections','sections',@pk_549_695,'','',@rolid_0,'0','1','id','','sections','250','2','0','1','7'),('categories','categories',@pk_549_696,'','',@rolid_0,'0','40','id','','categories','250','2','0','0','7'),('role_joomlacategories','role.joomlacategories',@pk_549_697,'','',@rolid_0,'0','1','id,rolid','joomlacategories','role','51','2','0','0','7'),('role_joomlacontent','role.joomlacontent',@pk_549_698,'','',@rolid_0,'0','1','id,rolid,comment','joomlacontent','role','51','2','0','0','7'),('ticket_clickyesno','ticket.clickyesno',@pk_549_761,'','',@rolid_0,'0','1','clickid','clickyesno','ticket','51','2','0','0','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('joobi_countries','joobi.countries',@pk_549_200,'','1.0.0',@rolid_0,'0','1','ctyid','countries','joobi','51','2','0','0','7'),('license_node','license.node',@pk_549_206,'','1.0.0',@rolid_0,'0','1','lcid','node','license','51','2','0','0','7'),('site_node','site.node',@pk_549_211,'','1.0.0',@rolid_0,'0','1','stid','node','site','51','2','0','0','7'),('product_node','product.node',@pk_549_306,'','1.0.0',@rolid_0,'0','1','pid','node','product','51','2','0','0','7'),('joobi_files','joobi.files',@pk_549_478,'','1.0.0',@rolid_0,'0','1','filid','files','joobi','51','2','0','0','7'),('ticket_projectmembers','ticket.projectmembers',@pk_549_557,'','1.0.0',@rolid_0,'0','30','pjid,uid','projectmembers','ticket','51','2','0','0','7'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('currency_node','currency.node',@pk_549_624,'','1.0.0',@rolid_0,'0','1','curid','node','currency','51','2','0','0','7'),('model_trans','model.trans',@pk_549_618,'','1.0.0',@rolid_0,'0','20','sid,lgid','trans','model','9','0','0','1','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('productcat_product','productcat.product',@pk_549_338,'','1.0.0',@rolid_0,'0','30','catid,pid','product','productcat','51','2','0','0','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('product_trans','product.trans',@pk_549_309,'','1.0.0',@rolid_0,'0','20','pid,lgid','trans','product','51','2','0','0','5'),('address_node','address.node',@pk_549_323,'','1.0.0',@rolid_0,'0','1','adid','node','address','51','2','0','0','7'),('eguillage_trans','eguillage.trans',@pk_549_714,'','',@rolid_0,'0','20','ctrid,lgid','trans','eguillage','9','0','0','1','7'),('mailing_trans','mailing.trans',@pk_549_382,'','1.0.0',@rolid_0,'0','20','mgid,lgid','trans','mailing','51','0','0','0','7');
SET @dbtid_1 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1);
SET @dbtid_2 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.node' LIMIT 1);
SET @dbtid_3 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.members' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.trans' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.replytrans' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.node' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.reply' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlasections' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='sections' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='categories' LIMIT 1);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlacategories' LIMIT 1);
SET @dbtid_12 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.joomlacontent' LIMIT 1);
SET @dbtid_13 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.clickyesno' LIMIT 1);
SET @dbtid_14 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='content' LIMIT 1);
SET @pk_454_134 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_email' LIMIT 1 );
SET @pk_454_1117 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_members_node_name' LIMIT 1 );
SET @pk_454_48171 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_405_namekey' LIMIT 1 );
SET @pk_454_65451 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_members_pjid_uid' LIMIT 1 );
SET @pk_454_65452 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_tickettrans_tkid_lgid' LIMIT 1 );
SET @pk_454_65453 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_replytrans_tkrid_lgid' LIMIT 1 );
SET @pk_454_65568 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_authoruid' LIMIT 1 );
SET @pk_454_65569 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_pjid' LIMIT 1 );
SET @pk_454_65570 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_node_tkid' LIMIT 1 );
SET @pk_454_65571 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_modified' LIMIT 1 );
SET @pk_454_65572 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_reply_created' LIMIT 1 );
SET @pk_454_65573 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_tkid' LIMIT 1 );
SET @pk_454_65581 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_reply' LIMIT 1 );
SET @pk_454_65594 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_username' LIMIT 1 );
SET @pk_454_65615 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlasections' LIMIT 1 );
SET @pk_454_65616 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_sections' LIMIT 1 );
SET @pk_454_65617 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_categories' LIMIT 1 );
SET @pk_454_65618 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacategories' LIMIT 1 );
SET @pk_454_65619 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacontent' LIMIT 1 );
SET @pk_454_65694 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_clickyesno' LIMIT 1 );
SET @pk_454_65710 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_node' LIMIT 1 );
SET @pk_454_65711 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_content|main_joomla15' LIMIT 1 );
SET @pk_454_66046 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_trans_name' LIMIT 1 );
SET @pk_454_66047 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_trans_description' LIMIT 1 );
SET @pk_454_66048 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_replytrans_name' LIMIT 1 );
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_134,'1','UK_members_node_email',@dbtid_1);
REPLACE INTO `#__dataset_constraints` (`ctid`,`type`,`namekey`,`dbtid`) VALUES (@pk_454_1117,'2','IX_members_node_name',@dbtid_1),(@pk_454_48171,'1','UK_405_namekey',@dbtid_2),(@pk_454_65451,'3','PK_project_members_pjid_uid',@dbtid_3),(@pk_454_65452,'3','PK_tickettrans_tkid_lgid',@dbtid_4),(@pk_454_65453,'3','PK_ticket_replytrans_tkrid_lgid',@dbtid_5),(@pk_454_65568,'2','IX_ticket_node_authoruid',@dbtid_6),(@pk_454_65569,'2','IX_ticket_node_pjid',@dbtid_6),(@pk_454_65570,'3','PK_ticket_node_tkid',@dbtid_6),(@pk_454_65571,'2','IX_ticket_node_modified',@dbtid_6),(@pk_454_65572,'2','IX_ticket_reply_created',@dbtid_7),(@pk_454_65573,'2','IX_ticket_node_tkid',@dbtid_7),(@pk_454_65581,'3','PK_ticket_reply',@dbtid_7),(@pk_454_65594,'1','UK_members_node_username',@dbtid_1),(@pk_454_65615,'3','PK_role_joomlasections',@dbtid_8),(@pk_454_65616,'3','PK_sections',@dbtid_9),(@pk_454_65617,'3','PK_categories',@dbtid_10),(@pk_454_65618,'3','PK_role_joomlacategories',@dbtid_11),(@pk_454_65619,'3','PK_role_joomlacontent',@dbtid_12),(@pk_454_65694,'3','PK_ticket_clickyesno',@dbtid_13),(@pk_454_65710,'3','PK_members_node',@dbtid_1),(@pk_454_65711,'3','PK_content|main_joomla15',@dbtid_14),(@pk_454_66046,'5','IX_ticket_trans_name',@dbtid_4),(@pk_454_66047,'5','IX_ticket_trans_description',@dbtid_4),(@pk_454_66048,'5','IX_ticket_replytrans_name',@dbtid_5);
SET @dbtid_15 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @dbtid_16 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_17 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='mailing.trans' LIMIT 1);
SET @pk_616_1468 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1 );
SET @pk_616_1949 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232name' LIMIT 1 );
SET @pk_616_1950 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232username' LIMIT 1 );
SET @pk_616_1952 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232email' LIMIT 1 );
SET @pk_616_2018 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='356id' LIMIT 1 );
SET @pk_616_2408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405namekey' LIMIT 1 );
SET @pk_616_3602 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526pjid' LIMIT 1 );
SET @pk_616_3606 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526uid' LIMIT 1 );
SET @pk_616_3639 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532authoruid' LIMIT 1 );
SET @pk_616_3641 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532modified' LIMIT 1 );
SET @pk_616_3648 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532tkid' LIMIT 1 );
SET @pk_616_3652 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533description' LIMIT 1 );
SET @pk_616_3653 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533lgid' LIMIT 1 );
SET @pk_616_3654 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533name' LIMIT 1 );
SET @pk_616_3655 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533tkid' LIMIT 1 );
SET @pk_616_3656 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534modified' LIMIT 1 );
SET @pk_616_3657 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkid' LIMIT 1 );
SET @pk_616_3658 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkrid' LIMIT 1 );
SET @pk_616_3660 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535description' LIMIT 1 );
SET @pk_616_3661 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535lgid' LIMIT 1 );
SET @pk_616_3662 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535tkrid' LIMIT 1 );
SET @pk_616_5738 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532pjid' LIMIT 1 );
SET @pk_616_6672 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='694id' LIMIT 1 );
SET @pk_616_6673 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid694' LIMIT 1 );
SET @pk_616_6675 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='695id' LIMIT 1 );
SET @pk_616_6676 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' LIMIT 1 );
SET @pk_616_6677 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='697id' LIMIT 1 );
SET @pk_616_6680 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='698id' LIMIT 1 );
SET @pk_616_6681 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid698' LIMIT 1 );
SET @pk_616_6682 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid697' LIMIT 1 );
SET @pk_616_7271 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='761clickid' LIMIT 1 );
SET @pk_616_7488 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment698' LIMIT 1 );
SET @pk_616_1377 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='206lcid' LIMIT 1 );
SET @pk_616_1417 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='211stid' LIMIT 1 );
SET @pk_616_1583 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1 );
SET @pk_616_1698 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1 );
SET @pk_616_1717 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='306pid' LIMIT 1 );
SET @pk_616_1929 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1 );
SET @pk_616_2407 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405pjid' LIMIT 1 );
SET @pk_616_5459 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='557uid' LIMIT 1 );
SET @pk_616_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_6095 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='624curid' LIMIT 1 );
SET @pk_616_1971 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232lgid' LIMIT 1 );
SET @pk_616_2414 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405parent' LIMIT 1 );
SET @pk_616_2415 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405rolid' LIMIT 1 );
SET @pk_616_2421 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405uid' LIMIT 1 );
SET @pk_616_3659 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534uid' LIMIT 1 );
SET @pk_616_3680 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532stid' LIMIT 1 );
SET @pk_616_5616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1 );
SET @pk_616_6480 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='assignuid532' LIMIT 1 );
SET @pk_616_6482 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid534' LIMIT 1 );
SET @pk_616_6485 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid532' LIMIT 1 );
SET @pk_616_7229 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='eid532' LIMIT 1 );
SET @pk_616_7272 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tkid761' LIMIT 1 );
SET @pk_616_7274 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid761' LIMIT 1 );
SET @pk_616_7404 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='curid232' LIMIT 1 );
SET @pk_616_7764 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='catid356' LIMIT 1 );
SET @pk_616_7765 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sectionid356' LIMIT 1 );
SET @pk_616_7777 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='section696' LIMIT 1 );
SET @pk_616_8996 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctyid232' LIMIT 1 );
SET @pk_616_10126 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lcid532' LIMIT 1 );
SET @pk_616_10245 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid232' LIMIT 1 );
SET @pk_616_1948 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232id' LIMIT 1 );
SET @pk_616_1951 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232openid' LIMIT 1 );
SET @pk_616_1953 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232password' LIMIT 1 );
SET @pk_616_1955 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232block' LIMIT 1 );
SET @pk_616_1957 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232activation' LIMIT 1 );
SET @pk_616_1958 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232timezone' LIMIT 1 );
SET @pk_616_1959 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232confirmed' LIMIT 1 );
SET @pk_616_1960 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232registerdate' LIMIT 1 );
SET @pk_616_1961 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232modified' LIMIT 1 );
SET @pk_616_2405 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232html' LIMIT 1 );
SET @pk_616_2411 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405type' LIMIT 1 );
SET @pk_616_2412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405lft' LIMIT 1 );
SET @pk_616_2413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405rgt' LIMIT 1 );
SET @pk_616_2416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405ordering' LIMIT 1 );
SET @pk_616_2417 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405publish' LIMIT 1 );
SET @pk_616_2419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405modified' LIMIT 1 );
SET @pk_616_2420 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405created' LIMIT 1 );
SET @pk_616_2483 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232registered' LIMIT 1 );
SET @pk_616_3281 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232unsub' LIMIT 1 );
SET @pk_616_3557 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232login' LIMIT 1 );
SET @pk_616_3578 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405startdate' LIMIT 1 );
SET @pk_616_3579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405enddate' LIMIT 1 );
SET @pk_616_3587 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405priority' LIMIT 1 );
SET @pk_616_3604 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526role' LIMIT 1 );
SET @pk_616_3643 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532ordering' LIMIT 1 );
SET @pk_616_3645 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532priority' LIMIT 1 );
SET @pk_616_3646 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532publish' LIMIT 1 );
SET @pk_616_3649 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532ticketid' LIMIT 1 );
SET @pk_616_3650 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532type' LIMIT 1 );
SET @pk_616_3651 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532uid' LIMIT 1 );
SET @pk_616_3677 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532created' LIMIT 1 );
SET @pk_616_3678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405author' LIMIT 1 );
SET @pk_616_5797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405estimatedtime' LIMIT 1 );
SET @pk_616_5861 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405depth' LIMIT 1 );
SET @pk_616_6417 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='private532' LIMIT 1 );
SET @pk_616_6418 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish534' LIMIT 1 );
SET @pk_616_6428 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid534' LIMIT 1 );
SET @pk_616_6429 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified534' LIMIT 1 );
SET @pk_616_6431 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='resptime532' LIMIT 1 );
SET @pk_616_6432 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='deadline532' LIMIT 1 );
SET @pk_616_6433 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='time534' LIMIT 1 );
SET @pk_616_6456 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='visibility232' LIMIT 1 );
SET @pk_616_6484 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='supportlevel526' LIMIT 1 );
SET @pk_616_6486 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='frontend405' LIMIT 1 );
SET @pk_616_6502 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='timing534' LIMIT 1 );
SET @pk_616_6503 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wordcount534' LIMIT 1 );
SET @pk_616_6504 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='charcount534' LIMIT 1 );
SET @pk_616_6505 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='nbreplies532' LIMIT 1 );
SET @pk_616_6506 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='timing532' LIMIT 1 );
SET @pk_616_6507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='wordcount532' LIMIT 1 );
SET @pk_616_6508 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='charcount532' LIMIT 1 );
SET @pk_616_6547 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='elapsed532' LIMIT 1 );
SET @pk_616_6674 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro694' LIMIT 1 );
SET @pk_616_6683 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro697' LIMIT 1 );
SET @pk_616_6690 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro698' LIMIT 1 );
SET @pk_616_6850 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto533' LIMIT 1 );
SET @pk_616_6851 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid533' LIMIT 1 );
SET @pk_616_6852 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto535' LIMIT 1 );
SET @pk_616_6853 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid535' LIMIT 1 );
SET @pk_616_7092 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ltkid405' LIMIT 1 );
SET @pk_616_7093 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tickets405' LIMIT 1 );
SET @pk_616_7116 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sticky532' LIMIT 1 );
SET @pk_616_7174 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lock532' LIMIT 1 );
SET @pk_616_7183 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rating532' LIMIT 1 );
SET @pk_616_7184 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='votes532' LIMIT 1 );
SET @pk_616_7214 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rated534' LIMIT 1 );
SET @pk_616_7230 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='useful532' LIMIT 1 );
SET @pk_616_7231 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='usefulclick532' LIMIT 1 );
SET @pk_616_7232 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='commenttype532' LIMIT 1 );
SET @pk_616_7236 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment534' LIMIT 1 );
SET @pk_616_7237 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='usefulrate532' LIMIT 1 );
SET @pk_616_7250 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ip532' LIMIT 1 );
SET @pk_616_7252 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ip534' LIMIT 1 );
SET @pk_616_7273 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ip761' LIMIT 1 );
SET @pk_616_7275 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created761' LIMIT 1 );
SET @pk_616_7276 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='yesno761' LIMIT 1 );
SET @pk_616_7284 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment532' LIMIT 1 );
SET @pk_616_7393 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='notify526' LIMIT 1 );
SET @pk_616_7394 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='oncreation405' LIMIT 1 );
SET @pk_616_7395 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='onreplies405' LIMIT 1 );
SET @pk_616_7396 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='toassigned405' LIMIT 1 );
SET @pk_616_7397 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sendcopy405' LIMIT 1 );
SET @pk_616_7408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title356' LIMIT 1 );
SET @pk_616_7409 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created356' LIMIT 1 );
SET @pk_616_7410 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='state356' LIMIT 1 );
SET @pk_616_7489 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment697' LIMIT 1 );
SET @pk_616_7490 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment694' LIMIT 1 );
SET @pk_616_7492 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title695' LIMIT 1 );
SET @pk_616_7493 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created695' LIMIT 1 );
SET @pk_616_7494 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='state695' LIMIT 1 );
SET @pk_616_7496 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='group405' LIMIT 1 );
SET @pk_616_7506 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rating_sum698' LIMIT 1 );
SET @pk_616_7507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rating_num698' LIMIT 1 );
SET @pk_616_7761 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='followup532' LIMIT 1 );
SET @pk_616_7772 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='assignbyuid532' LIMIT 1 );
SET @pk_616_7774 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name695' LIMIT 1 );
SET @pk_616_7775 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title696' LIMIT 1 );
SET @pk_616_7776 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name696' LIMIT 1 );
SET @pk_616_7778 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering696' LIMIT 1 );
SET @pk_616_7779 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='published696' LIMIT 1 );
SET @pk_616_7797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified356' LIMIT 1 );
SET @pk_616_7799 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='published_up356' LIMIT 1 );
SET @pk_616_7800 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish_down356' LIMIT 1 );
SET @pk_616_7801 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='mask356' LIMIT 1 );
SET @pk_616_7802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created_by356' LIMIT 1 );
SET @pk_616_7803 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created_by_alias356' LIMIT 1 );
SET @pk_616_7804 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified_by356' LIMIT 1 );
SET @pk_616_7805 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checked_out356' LIMIT 1 );
SET @pk_616_7806 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checked_out_time356' LIMIT 1 );
SET @pk_616_7807 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='images356' LIMIT 1 );
SET @pk_616_7808 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='urls356' LIMIT 1 );
SET @pk_616_7809 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='attribs356' LIMIT 1 );
SET @pk_616_7810 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='version356' LIMIT 1 );
SET @pk_616_7811 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='parentid356' LIMIT 1 );
SET @pk_616_7812 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ordering356' LIMIT 1 );
SET @pk_616_7813 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='metakey356' LIMIT 1 );
SET @pk_616_7814 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='metadesc356' LIMIT 1 );
SET @pk_616_7815 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='access356' LIMIT 1 );
SET @pk_616_7816 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='metadata356' LIMIT 1 );
SET @pk_616_7817 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='hits356' LIMIT 1 );
SET @pk_616_8014 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish532' LIMIT 1 );
SET @pk_616_8022 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='read532' LIMIT 1 );
SET @pk_616_8078 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='email405' LIMIT 1 );
SET @pk_616_8995 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ip232' LIMIT 1 );
SET @pk_616_10098 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='latereply532' LIMIT 1 );
SET @pk_616_10123 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='mobile232' LIMIT 1 );
SET @pk_616_6039 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1 );
SET @pk_616_3412 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482name' LIMIT 1 );
SET @pk_616_3413 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='482description' LIMIT 1 );
SET @pk_616_3419 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='485name' LIMIT 1 );
SET @pk_616_6797 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description485' LIMIT 1 );
SET @pk_616_10823 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='message485' LIMIT 1 );
SET @pk_616_3416 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484name' LIMIT 1 );
SET @pk_616_3507 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='484description' LIMIT 1 );
SET @pk_616_3408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481name' LIMIT 1 );
SET @pk_616_5579 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wname' LIMIT 1 );
SET @pk_616_5580 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='481wdescription' LIMIT 1 );
SET @pk_616_6794 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name714' LIMIT 1 );
SET @pk_616_6795 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description714' LIMIT 1 );
SET @pk_616_2217 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1 );
SET @pk_616_2218 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1 );
SET @pk_616_2219 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1 );
SET @pk_616_8616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1 );
SET @pk_616_8617 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1 );
SET @pk_616_8618 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1 );
SET @pk_616_8678 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1 );
SET @pk_616_10120 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1 );
SET @pk_616_10801 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1 );
SET @pk_616_10802 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1 );
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_1468,@dbtid_1,'uid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','232uid','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_1949,@dbtid_1,'name','0','1','14','0','1','','5','1',@rolid_0,'0','200','1','232name','1','0','0'),(@pk_616_1950,@dbtid_1,'username','0','1','14','0','1','','4','1',@rolid_0,'0','40','1','232username','1','0','0'),(@pk_616_1952,@dbtid_1,'email','0','1','14','0','1','','6','1',@rolid_0,'0','100','1','232email','1','0','0'),(@pk_616_2018,@dbtid_14,'id','1','0','4','1','1','','1','1',@rolid_0,'1','11','1','356id','1','0','0'),(@pk_616_2408,@dbtid_2,'namekey','0','1','14','0','1','','4','1',@rolid_0,'0','100','1','405namekey','1','0','0'),(@pk_616_3602,@dbtid_3,'pjid','1','0','2','1','1','','1','1',@rolid_0,'0','0','1','526pjid','1','0','0'),(@pk_616_3606,@dbtid_3,'uid','1','0','4','1','1','','2','1',@rolid_0,'1','0','1','526uid','1','0','0'),(@pk_616_3639,@dbtid_6,'authoruid','0','0','4','1','1','0','5','1',@rolid_0,'0','0','1','532authoruid','1','0','0'),(@pk_616_3641,@dbtid_6,'modified','0','1','4','1','1','0','10','1',@rolid_0,'0','0','1','532modified','1','1','0'),(@pk_616_3648,@dbtid_6,'tkid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','532tkid','1','0','0'),(@pk_616_3652,@dbtid_4,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','533description','1','0','0'),(@pk_616_3653,@dbtid_4,'lgid','1','0','1','1','1','1','2','1',@rolid_0,'0','4','1','533lgid','1','0','0'),(@pk_616_3654,@dbtid_4,'name','0','0','14','0','1','','3','1',@rolid_0,'0','250','1','533name','1','0','0'),(@pk_616_3655,@dbtid_4,'tkid','1','0','4','1','1','','1','1',@rolid_0,'0','0','1','533tkid','1','0','0'),(@pk_616_3656,@dbtid_7,'created','0','1','4','1','1','0','4','1',@rolid_0,'0','0','1','534modified','1','1','0'),(@pk_616_3657,@dbtid_7,'tkid','0','0','4','1','1','0','2','1',@rolid_0,'0','0','1','534tkid','1','0','0'),(@pk_616_3658,@dbtid_7,'tkrid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','534tkrid','1','0','0'),(@pk_616_3660,@dbtid_5,'description','0','0','16','0','1','','3','1',@rolid_0,'0','0','1','535description','1','0','0'),(@pk_616_3661,@dbtid_5,'lgid','1','0','1','1','1','1','2','1',@rolid_0,'0','4','1','535lgid','1','0','0'),(@pk_616_3662,@dbtid_5,'tkrid','1','0','4','1','1','','1','1',@rolid_0,'0','0','1','535tkrid','1','0','0'),(@pk_616_5738,@dbtid_6,'pjid','0','0','2','1','1','0','3','1',@rolid_0,'0','5','1','532pjid','1','0','0'),(@pk_616_6672,@dbtid_8,'id','1','0','4','1','1','','1','0','0','1','0','1','694id','1','0','0'),(@pk_616_6673,@dbtid_8,'rolid','1','0','2','1','1','1','2','0','0','0','0','1','rolid694','1','0','0'),(@pk_616_6675,@dbtid_9,'id','1','0','4','1','1','','1','0','0','1','11','1','695id','1','0','0'),(@pk_616_6676,@dbtid_10,'id','1','0','4','1','1','','1','0','0','1','11','1','696id','1','0','0'),(@pk_616_6677,@dbtid_11,'id','1','0','4','1','1','','1','0','0','1','0','1','697id','1','0','0'),(@pk_616_6680,@dbtid_12,'id','1','0','4','1','1','','1','0','0','1','0','1','698id','1','0','0'),(@pk_616_6681,@dbtid_12,'rolid','1','0','2','1','1','1','2','0','0','0','0','1','rolid698','1','0','0'),(@pk_616_6682,@dbtid_11,'rolid','1','0','2','1','1','1','2','0','0','0','0','1','rolid697','1','0','0'),(@pk_616_7271,@dbtid_13,'clickid','1','0','4','1','1','','1','0','0','1','0','1','761clickid','1','0','0'),(@pk_616_7488,@dbtid_12,'comment','1','1','1','1','1','0','4','0','0','0','0','1','comment698','1','0','0'),(@pk_616_1377,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='license.node' LIMIT 1),'lcid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','206lcid','1','0','0'),(@pk_616_1417,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='site.node' LIMIT 1),'stid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','211stid','1','0','0'),(@pk_616_1583,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),'filid','1','0','4','1','1','','1','1',@rolid_0,'1','0','1','478filid','1','0','0'),(@pk_616_1698,@dbtid_15,'lgid','1','0','1','1','1','','1','1',@rolid_0,'1','0','1','199lgid','1','0','0'),(@pk_616_1717,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),'pid','1','0','4','1','1','','2','1',@rolid_0,'1','0','1','306pid','1','0','0'),(@pk_616_1929,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),'ctyid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','200ctyid','1','0','0'),(@pk_616_2407,@dbtid_2,'pjid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','405pjid','1','0','0'),(@pk_616_5459,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.projectmembers' LIMIT 1),'uid','1','0','4','1','1','','2','1',@rolid_0,'1','10','1','557uid','1','0','0'),(@pk_616_5532,@dbtid_16,'rolid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','566rolid','1','0','0'),(@pk_616_6095,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1),'curid','1','0','2','1','1','','1','1',@rolid_0,'1','0','1','624curid','1','0','0'),(@pk_616_1971,@dbtid_1,'lgid','0','0','1','1','1','1','2','1',@rolid_0,'0','0','1','232lgid','1','0','0'),(@pk_616_2414,@dbtid_2,'parent','0','0','3','1','1','0','8','1',@rolid_0,'0','0','1','405parent','1','0','0'),(@pk_616_2415,@dbtid_2,'rolid','0','0','2','1','1','7','3','1',@rolid_0,'0','0','1','405rolid','1','0','0'),(@pk_616_2421,@dbtid_2,'uid','0','1','4','1','1','0','2','1',@rolid_0,'1','0','1','405uid','1','0','0'),(@pk_616_3659,@dbtid_7,'authoruid','0','0','4','1','1','0','3','1',@rolid_0,'0','0','1','534uid','1','0','0'),(@pk_616_3680,@dbtid_6,'stid','0','1','4','1','1','0','12','1',@rolid_0,'0','0','1','532stid','1','0','0'),(@pk_616_5616,@dbtid_1,'rolid','0','0','2','1','1','1','18','1',@rolid_0,'0','0','1','232rolid','1','0','0'),(@pk_616_6480,@dbtid_6,'assignuid','0','1','4','1','1','0','16','0','0','0','0','1','assignuid532','1','0','0'),(@pk_616_6482,@dbtid_7,'rolid','0','1','2','1','1','1','9','0','0','0','0','1','rolid534','1','0','0'),(@pk_616_6485,@dbtid_6,'rolid','0','1','2','1','1','1','17','0','0','0','0','1','rolid532','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_7229,@dbtid_6,'etid','0','1','4','1','1','0','27','0','0','0','0','1','eid532','1','0','0'),(@pk_616_7272,@dbtid_13,'tkid','0','1','4','1','1','0','2','0','0','0','0','1','tkid761','1','0','0'),(@pk_616_7274,@dbtid_13,'uid','0','1','4','1','1','0','4','0','0','0','0','1','uid761','1','0','0'),(@pk_616_7404,@dbtid_1,'curid','0','1','2','1','1','0','21','0','0','0','0','1','curid232','1','0','0'),(@pk_616_7764,@dbtid_14,'catid','0','1','4','1','1','0','5','0','0','0','0','1','catid356','1','0','0'),(@pk_616_7765,@dbtid_14,'sectionid','0','1','4','1','1','0','6','0','0','0','11','1','sectionid356','1','0','0'),(@pk_616_7777,@dbtid_10,'section','0','1','14','0','1','','4','0','0','0','50','1','section696','1','0','0'),(@pk_616_8996,@dbtid_1,'ctyid','0','1','2','1','1','0','23','0','0','0','0','1','ctyid232','1','0','0'),(@pk_616_10126,@dbtid_6,'lcid','0','1','4','1','1','0','39','0','0','0','0','1','lcid532','1','0','0'),(@pk_616_10245,@dbtid_1,'filid','0','1','4','1','1','0','25','0','0','0','0','1','filid232','1','0','0'),(@pk_616_1948,@dbtid_1,'id','0','0','4','0','1','0','3','1',@rolid_0,'0','10','1','232id','1','0','0'),(@pk_616_1951,@dbtid_1,'openid','0','1','14','0','1','','9','1',@rolid_0,'0','255','1','232openid','1','0','0'),(@pk_616_1953,@dbtid_1,'password','0','1','14','0','1','','7','1',@rolid_0,'0','200','1','232password','1','0','0'),(@pk_616_1955,@dbtid_1,'blocked','0','0','1','0','1','0','11','1',@rolid_0,'0','3','1','232block','1','0','0'),(@pk_616_1957,@dbtid_1,'activation','0','0','14','0','1','','12','1',@rolid_0,'0','32','1','232activation','1','0','0'),(@pk_616_1958,@dbtid_1,'timezone','0','0','2','0','1','999','8','1',@rolid_0,'0','0','1','232timezone','1','0','0'),(@pk_616_1959,@dbtid_1,'confirmed','0','0','1','0','1','0','10','1',@rolid_0,'0','3','1','232confirmed','1','0','0'),(@pk_616_1960,@dbtid_1,'registerdate','0','0','10','0','1','','17','1',@rolid_0,'0','0','1','232registerdate','1','0','0'),(@pk_616_1961,@dbtid_1,'modified','0','1','4','1','1','0','16','1',@rolid_0,'0','0','1','232modified','1','1','0'),(@pk_616_2405,@dbtid_1,'html','0','0','1','1','1','1','14','1',@rolid_0,'0','0','1','232html','1','0','0'),(@pk_616_2411,@dbtid_2,'type','0','0','1','1','1','0','5','1',@rolid_0,'0','0','1','405type','1','0','0'),(@pk_616_2412,@dbtid_2,'lft','0','0','3','1','1','0','6','1',@rolid_0,'0','0','1','405lft','1','0','0'),(@pk_616_2413,@dbtid_2,'rgt','0','0','3','1','1','0','7','1',@rolid_0,'0','0','1','405rgt','1','0','0'),(@pk_616_2416,@dbtid_2,'ordering','0','0','1','1','1','99','9','1',@rolid_0,'0','0','1','405ordering','1','0','0'),(@pk_616_2417,@dbtid_2,'publish','0','0','1','0','1','1','10','1',@rolid_0,'0','0','1','405publish','1','0','0'),(@pk_616_2419,@dbtid_2,'modified','0','1','4','1','1','0','11','1',@rolid_0,'0','0','1','405modified','1','1','0'),(@pk_616_2420,@dbtid_2,'created','0','1','4','1','1','0','12','1',@rolid_0,'1','0','1','405created','1','1','0'),(@pk_616_2483,@dbtid_1,'registered','0','0','25','0','1','1','13','1',@rolid_0,'0','0','1','232registered','1','0','0'),(@pk_616_3281,@dbtid_1,'unsub','0','0','25','0','1','0','15','1',@rolid_0,'0','0','1','232unsub','1','0','0'),(@pk_616_3557,@dbtid_1,'login','0','0','10','0','1','','19','1',@rolid_0,'0','0','1','232login','1','0','0'),(@pk_616_3578,@dbtid_2,'startdate','0','0','4','1','1','0','14','1',@rolid_0,'0','0','1','405startdate','1','0','0'),(@pk_616_3579,@dbtid_2,'enddate','0','0','4','1','1','0','13','1',@rolid_0,'0','0','1','405enddate','1','0','0'),(@pk_616_3587,@dbtid_2,'priority','0','0','1','1','1','0','15','1',@rolid_0,'0','0','1','405priority','1','0','0'),(@pk_616_3604,@dbtid_3,'role','0','0','1','1','1','0','4','1',@rolid_0,'0','0','1','526role','1','0','0'),(@pk_616_3643,@dbtid_6,'ordering','0','0','1','1','1','0','11','1',@rolid_0,'0','0','1','532ordering','1','0','0'),(@pk_616_3645,@dbtid_6,'priority','0','0','1','1','1','0','8','1',@rolid_0,'0','0','1','532priority','1','0','0'),(@pk_616_3646,@dbtid_6,'status','0','0','1','0','1','20','9','1',@rolid_0,'0','0','1','532publish','1','0','0'),(@pk_616_3649,@dbtid_6,'namekey','0','0','14','0','1','','4','1',@rolid_0,'0','100','1','532ticketid','1','0','0'),(@pk_616_3650,@dbtid_6,'tktypeid','0','0','2','1','1','0','7','1',@rolid_0,'0','0','1','532type','1','0','0'),(@pk_616_3651,@dbtid_6,'uid','0','0','4','1','1','0','2','1',@rolid_0,'1','0','1','532uid','1','0','0'),(@pk_616_3677,@dbtid_6,'created','0','1','4','1','1','0','6','1',@rolid_0,'1','0','1','532created','1','1','0'),(@pk_616_3678,@dbtid_2,'author','0','0','4','1','1','0','16','1',@rolid_0,'0','0','1','405author','1','0','0'),(@pk_616_5797,@dbtid_2,'estimatedtime','0','0','4','1','1','0','17','1',@rolid_0,'0','0','0','405estimatedtime','1','0','0'),(@pk_616_5861,@dbtid_2,'depth','0','0','1','1','1','0','18','1',@rolid_0,'0','0','1','405depth','1','0','0'),(@pk_616_6417,@dbtid_6,'private','0','1','1','1','1','1','13','0','0','0','0','1','private532','1','0','0'),(@pk_616_6418,@dbtid_7,'publish','0','1','1','1','1','1','5','0','0','0','0','1','publish534','1','0','0'),(@pk_616_6428,@dbtid_7,'uid','0','1','4','1','1','0','6','0','0','0','0','1','uid534','1','0','0'),(@pk_616_6429,@dbtid_7,'modified','0','1','4','1','1','0','7','0','0','0','0','1','modified534','1','1','0'),(@pk_616_6431,@dbtid_6,'resptime','0','1','1','1','1','10','14','0','0','0','0','1','resptime532','1','0','0'),(@pk_616_6432,@dbtid_6,'deadline','0','1','4','1','1','4200000003','15','0','0','0','0','1','deadline532','1','0','0'),(@pk_616_6433,@dbtid_7,'timeresp','0','1','4','1','1','0','8','0','0','0','0','1','time534','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_6456,@dbtid_1,'visibility','0','0','1','1','1','231','20','0','0','0','0','1','visibility232','1','0','0'),(@pk_616_6484,@dbtid_3,'supportlevel','0','0','1','1','1','1','3','0','0','0','0','1','supportlevel526','1','0','0'),(@pk_616_6486,@dbtid_2,'frontend','0','1','1','1','1','0','19','0','0','0','0','1','frontend405','1','0','0'),(@pk_616_6502,@dbtid_7,'timing','0','1','2','1','1','0','10','0','0','0','0','1','timing534','1','0','0'),(@pk_616_6503,@dbtid_7,'wordcount','0','1','2','1','1','0','11','0','0','0','0','1','wordcount534','1','0','0'),(@pk_616_6504,@dbtid_7,'charcount','0','1','3','1','1','0','12','0','0','0','0','1','charcount534','1','0','0'),(@pk_616_6505,@dbtid_6,'replies','0','1','2','1','1','0','18','0','0','0','0','1','nbreplies532','1','0','0'),(@pk_616_6506,@dbtid_6,'timing','0','1','2','1','1','0','19','0','0','0','0','1','timing532','1','0','0'),(@pk_616_6507,@dbtid_6,'wordcount','0','1','2','1','1','0','20','0','0','0','0','1','wordcount532','1','0','0'),(@pk_616_6508,@dbtid_6,'charcount','0','1','3','1','1','0','21','0','0','0','0','1','charcount532','1','0','0'),(@pk_616_6547,@dbtid_6,'elapsed','0','1','4','1','1','0','22','0','0','0','0','1','elapsed532','1','0','0'),(@pk_616_6674,@dbtid_8,'introrolid','0','1','2','1','1','1','3','0','0','0','0','1','intro694','1','0','0'),(@pk_616_6683,@dbtid_11,'introrolid','0','1','2','1','1','1','3','0','0','0','0','1','intro697','1','0','0'),(@pk_616_6690,@dbtid_12,'introrolid','0','1','2','1','1','1','3','0','0','0','0','1','intro698','1','0','0'),(@pk_616_6850,@dbtid_4,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto533','1','0','0'),(@pk_616_6851,@dbtid_4,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid533','1','0','0'),(@pk_616_6852,@dbtid_5,'auto','0','0','1','0','1','2','5','0','0','0','0','0','auto535','1','0','0'),(@pk_616_6853,@dbtid_5,'fromlgid','0','0','1','1','1','0','4','0','0','0','0','0','fromlgid535','1','0','0'),(@pk_616_7092,@dbtid_2,'ltkid','0','1','4','1','1','0','20','0','0','0','0','1','ltkid405','1','0','0'),(@pk_616_7093,@dbtid_2,'tickets','0','1','2','1','1','0','21','0','0','0','0','1','tickets405','1','0','0'),(@pk_616_7116,@dbtid_6,'sticky','0','1','1','1','1','0','23','0','0','0','0','1','sticky532','1','0','0'),(@pk_616_7174,@dbtid_6,'lock','0','1','1','1','1','0','24','0','0','0','0','1','lock532','1','0','0'),(@pk_616_7183,@dbtid_6,'score','0','1','4','1','1','0','25','0','0','0','0','1','rating532','1','0','0'),(@pk_616_7184,@dbtid_6,'votes','0','1','1','1','1','0','26','0','0','0','0','1','votes532','1','0','0'),(@pk_616_7214,@dbtid_7,'score','0','1','1','1','1','0','13','0','0','0','0','1','rated534','1','0','0'),(@pk_616_7230,@dbtid_6,'useful','0','1','4','1','1','0','28','0','0','0','0','1','useful532','1','0','0'),(@pk_616_7231,@dbtid_6,'usefulclick','0','1','4','1','1','0','29','0','0','0','0','1','usefulclick532','1','0','0'),(@pk_616_7232,@dbtid_6,'commenttype','0','1','2','1','1','0','30','0','0','0','0','1','commenttype532','1','0','0'),(@pk_616_7236,@dbtid_7,'comment','0','1','1','1','1','0','14','0','0','0','0','1','comment534','1','0','0'),(@pk_616_7237,@dbtid_6,'usefulrate','0','1','4','1','1','0','31','0','0','0','0','1','usefulrate532','1','0','0'),(@pk_616_7250,@dbtid_6,'ip','0','0','7','1','0','0','32','0','0','0','0','0','ip532','1','0','0'),(@pk_616_7252,@dbtid_7,'ip','0','0','7','1','0','0','15','0','0','0','0','0','ip534','1','0','0'),(@pk_616_7273,@dbtid_13,'ip','0','1','4','1','1','NULL','3','0','0','0','10','1','ip761','1','0','0'),(@pk_616_7275,@dbtid_13,'created','0','1','4','1','1','0','5','0','0','0','0','1','created761','1','1','0'),(@pk_616_7276,@dbtid_13,'yesno','0','1','1','1','1','0','6','0','0','0','0','1','yesno761','1','0','0'),(@pk_616_7284,@dbtid_6,'comment','0','1','1','1','1','1','33','0','0','0','0','1','comment532','1','0','0'),(@pk_616_7393,@dbtid_3,'notify','0','1','1','1','1','1','5','0','0','0','0','1','notify526','1','0','0'),(@pk_616_7394,@dbtid_2,'oncreation','0','1','1','1','1','1','22','0','0','0','0','1','oncreation405','1','0','0'),(@pk_616_7395,@dbtid_2,'onreplies','0','1','1','1','1','1','23','0','0','0','0','1','onreplies405','1','0','0'),(@pk_616_7396,@dbtid_2,'toassigned','0','1','1','1','1','1','24','0','0','0','0','1','toassigned405','1','0','0'),(@pk_616_7397,@dbtid_2,'sendcopy','0','1','1','1','1','0','25','0','0','0','0','1','sendcopy405','1','0','0'),(@pk_616_7408,@dbtid_14,'title','0','1','14','0','1','','2','0','0','0','255','1','title356','1','0','0'),(@pk_616_7409,@dbtid_14,'created','0','1','10','0','1','0000-00-00 00:00:00','3','0','0','0','0','1','created356','1','1','0'),(@pk_616_7410,@dbtid_14,'state','0','1','1','0','1','0','4','0','0','0','3','1','state356','1','0','0'),(@pk_616_7489,@dbtid_11,'comment','0','1','1','1','1','0','4','0','0','0','0','1','comment697','1','0','0'),(@pk_616_7490,@dbtid_8,'comment','0','1','1','1','1','0','4','0','0','0','0','1','comment694','1','0','0'),(@pk_616_7492,@dbtid_9,'title','0','1','14','0','1','','2','0','0','0','255','1','title695','1','0','0'),(@pk_616_7493,@dbtid_9,'created','0','1','10','0','1','0000-00-00 00:00:00','3','0','0','0','0','1','created695','1','1','0'),(@pk_616_7494,@dbtid_9,'state','0','1','1','0','1','0','4','0','0','0','3','1','state695','1','0','0'),(@pk_616_7496,@dbtid_2,'group','0','1','1','1','1','5','26','0','0','0','0','1','group405','1','0','0'),(@pk_616_7506,@dbtid_12,'rating_sum','0','1','2','1','1','0','5','0','0','0','0','1','rating_sum698','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_7507,@dbtid_12,'rating_num','0','1','2','1','1','0','6','0','0','0','0','1','rating_num698','1','0','0'),(@pk_616_7761,@dbtid_6,'followup','0','1','1','1','1','0','34','0','0','0','0','1','followup532','1','0','0'),(@pk_616_7772,@dbtid_6,'assignbyuid','0','1','4','1','1','0','35','0','0','0','0','1','assignbyuid532','1','0','0'),(@pk_616_7774,@dbtid_9,'name','0','1','14','0','1','','5','0','0','0','255','1','name695','1','0','0'),(@pk_616_7775,@dbtid_10,'title','0','1','14','0','1','','2','0','0','0','255','1','title696','1','0','0'),(@pk_616_7776,@dbtid_10,'name','0','1','14','0','1','','3','0','0','0','255','1','name696','1','0','0'),(@pk_616_7778,@dbtid_10,'ordering','0','1','4','1','1','0','5','0','0','0','11','1','ordering696','1','0','0'),(@pk_616_7779,@dbtid_10,'published','0','1','1','0','1','0','6','0','0','0','1','1','published696','1','0','0'),(@pk_616_7797,@dbtid_14,'modified','0','1','4','1','1','0000-00-00 00:00:00','7','0','0','0','0','1','modified356','1','1','0'),(@pk_616_7799,@dbtid_14,'publish_up','0','1','10','0','1','0000-00-00 00:00:00','8','0','0','0','0','1','published_up356','1','1','0'),(@pk_616_7800,@dbtid_14,'publish_down','0','1','10','0','1','0000-00-00 00:00:00','9','0','0','0','0','1','publish_down356','1','1','0'),(@pk_616_7801,@dbtid_14,'mask','0','1','4','0','1','0','10','0','0','0','11','1','mask356','1','0','0'),(@pk_616_7802,@dbtid_14,'created_by','0','1','4','0','1','0','11','0','0','0','11','1','created_by356','1','0','0'),(@pk_616_7803,@dbtid_14,'created_by_alias','0','1','14','0','1','0','12','0','0','0','255','1','created_by_alias356','1','0','0'),(@pk_616_7804,@dbtid_14,'modified_by','0','1','4','0','1','0','13','0','0','0','11','1','modified_by356','1','0','0'),(@pk_616_7805,@dbtid_14,'checked_out','0','1','4','0','1','0','14','0','0','0','11','1','checked_out356','1','0','0'),(@pk_616_7806,@dbtid_14,'checked_out_time','0','1','10','0','1','0000-00-00 00:00:00','15','0','0','0','0','1','checked_out_time356','1','1','0'),(@pk_616_7807,@dbtid_14,'images','0','1','16','0','1','','16','0','0','0','0','1','images356','1','0','0'),(@pk_616_7808,@dbtid_14,'urls','0','1','16','0','1','','17','0','0','0','0','1','urls356','1','0','0'),(@pk_616_7809,@dbtid_14,'attribs','0','1','16','0','1','','18','0','0','0','0','1','attribs356','1','0','0'),(@pk_616_7810,@dbtid_14,'version','0','1','4','1','1','1','19','0','0','0','11','1','version356','1','0','0'),(@pk_616_7811,@dbtid_14,'parentid','0','1','4','1','1','0','20','0','0','0','11','1','parentid356','1','0','0'),(@pk_616_7812,@dbtid_14,'ordering','0','1','4','1','1','0','21','0','0','0','11','1','ordering356','1','0','0'),(@pk_616_7813,@dbtid_14,'metakey','0','1','16','0','1','','22','0','0','0','0','1','metakey356','1','0','0'),(@pk_616_7814,@dbtid_14,'metadesc','0','1','16','0','1','','23','0','0','0','0','1','metadesc356','1','0','0'),(@pk_616_7815,@dbtid_14,'access','0','1','4','1','1','0','24','0','0','0','11','1','access356','1','0','0'),(@pk_616_7816,@dbtid_14,'metadata','0','1','16','0','1','','25','0','0','0','0','1','metadata356','1','0','0'),(@pk_616_7817,@dbtid_14,'hits','0','1','4','1','1','0','26','0','0','0','11','1','hits356','1','0','0'),(@pk_616_8014,@dbtid_6,'publish','0','1','1','1','1','1','36','0','0','0','0','1','publish532','1','0','0'),(@pk_616_8022,@dbtid_6,'read','0','1','1','1','1','0','37','0','0','0','0','1','read532','1','0','0'),(@pk_616_8078,@dbtid_2,'email','0','1','14','0','1','','27','0','0','0','100','1','email405','1','0','0'),(@pk_616_8995,@dbtid_1,'ip','0','0','7','1','0','0','22','0','0','0','0','1','ip232','1','0','0'),(@pk_616_10098,@dbtid_6,'latereply','0','1','1','1','1','0','38','0','0','0','0','1','latereply532','1','0','0'),(@pk_616_10123,@dbtid_1,'mobile','0','1','14','0','1','','24','0','0','0','20','0','mobile232','1','0','0'),(@pk_616_6039,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','0','1','618name','1','0','0'),(@pk_616_3412,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','482name','1','0','0'),(@pk_616_3413,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1),'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','482description','1','0','0'),(@pk_616_3419,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','485name','1','0','0'),(@pk_616_6797,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description485','1','0','0'),(@pk_616_10823,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1),'message','0','1','16','0','1','','5','0','0','0','0','1','message485','1','0','0'),(@pk_616_3416,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','484name','1','0','0'),(@pk_616_3507,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1),'description','0','0','16','0','1','','99','1',@rolid_0,'0','0','1','484description','1','0','0'),(@pk_616_3408,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'name','0','0','14','0','1','','3','1',@rolid_0,'0','255','1','481name','1','0','0'),(@pk_616_5579,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wname','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','481wname','1','0','0'),(@pk_616_5580,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1),'wdescription','0','0','16','0','1','','6','1',@rolid_0,'0','0','1','481wdescription','1','0','0'),(@pk_616_6794,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'name','0','1','14','0','1','','3','0','0','0','255','1','name714','1','0','0'),(@pk_616_6795,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1),'description','0','1','16','0','1','','4','0','0','0','0','1','description714','1','0','0'),(@pk_616_2217,@dbtid_17,'name','0','0','14','0','1','','5','1',@rolid_0,'0','255','1','382name','1','0','0'),(@pk_616_2218,@dbtid_17,'ctext','0','0','19','0','1','','8','1',@rolid_0,'0','0','1','382ctext','1','0','0'),(@pk_616_2219,@dbtid_17,'chtml','0','0','19','0','1','','7','1',@rolid_0,'0','0','1','382chtml','1','0','0'),(@pk_616_8616,@dbtid_17,'bouncemail','0','1','14','0','1','','11','0','0','0','100','1','bouncemail382','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_8617,@dbtid_17,'authorid','0','1','4','1','1','0','14','0','0','0','0','1','authorid382','1','0','0'),(@pk_616_8618,@dbtid_17,'modified','0','1','4','1','1','0','15','0','0','0','0','1','modified382','1','1','0'),(@pk_616_8678,@dbtid_17,'intro','0','1','16','0','1','','6','0','0','0','0','1','intro382','1','0','0'),(@pk_616_10120,@dbtid_17,'smsmessage','0','1','16','0','1','','16','0','0','0','0','1','smsmessage382','1','0','0'),(@pk_616_10801,@dbtid_17,'title','0','1','14','0','1','','17','0','0','0','255','1','title382','1','0','0'),(@pk_616_10802,@dbtid_17,'subtitle','0','1','14','0','1','','18','0','0','0','255','1','subtitle382','1','0','0');
SET @pk_5_909 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='comment.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='comment',`wid`=@pk_5_909,`params`='',`status`='1',`type`='150',`name`='Comment',`destination`='node',`parent`='0',`trans`='1',`certify`='0',`namekey`='comment.node',`version`='3412',`lversion`='3412',`pref`='1',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='comment.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','comment',@pk_5_909,'','1','150','Comment','node','0','1','0','comment.node','3412','3412','1','','1','1','0');

SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_356 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.content' LIMIT 1 );
SET @pk_621_531 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.project' LIMIT 1 );
SET @pk_621_557 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.projectmembers' LIMIT 1 );
SET @pk_621_696 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.sections' LIMIT 1 );
SET @pk_621_697 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categories' LIMIT 1 );
SET @pk_621_699 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.sections' LIMIT 1 );
SET @pk_621_700 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.categories' LIMIT 1 );
SET @pk_621_701 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.content' LIMIT 1 );
SET @pk_621_809 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.clickyesno' LIMIT 1 );
SET @pk_621_859 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment' LIMIT 1 );
SET @pk_621_860 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='commenttrans' LIMIT 1 );
SET @pk_621_861 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.member' LIMIT 1 );
SET @pk_621_899 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.reply' LIMIT 1 );
SET @pk_621_900 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.replytrans' LIMIT 1 );
SET @pk_621_1294 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.clickyesno' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_1039 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categoriesj16' LIMIT 1 );
SET @pk_621_306 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product' LIMIT 1 );
SET @pk_621_338 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product.categoryproduct' LIMIT 1 );
SET @pk_621_309 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='producttrans' LIMIT 1 );
SET @pk_621_323 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='address' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_1015,`dbtid`=@dbtid_1,`path`='1',`namekey`='users',`folder`='users',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='users',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-users',`pnamekey`='' WHERE  `namekey`='users';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1015,@dbtid_1,'1','users','users',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-users','');
UPDATE `#__model_node`  SET `sid`=@pk_621_356,`dbtid`=@dbtid_14,`path`='0',`namekey`='joomla.content',`folder`='content',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='content',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.content';
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_356,@dbtid_14,'0','joomla.content','content',@rolid_0,'0','1','0','0','','','content','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_531,`dbtid`=@dbtid_2,`path`='1',`namekey`='ticket.project',`folder`='ticket.project',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=parent\nprtname=ticket.projecttrans\ncachedata=1\nautofld=1',`alias`='',`prefix`='ticket',`fields`='1',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='ticket.project';
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_531,@dbtid_2,'1','ticket.project','ticket.project',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=parent\nprtname=ticket.projecttrans\ncachedata=1\nautofld=1','','ticket','1','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_557,`dbtid`=@dbtid_3,`path`='0',`namekey`='ticket.projectmembers',`folder`='ticket.projectmembers',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='ticket',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='ticket.projectmembers';
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_557,@dbtid_3,'0','ticket.projectmembers','ticket.projectmembers',@rolid_0,'0','1','0','0','autofld=1','','ticket','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_696,`dbtid`=@dbtid_9,`path`='0',`namekey`='joomla.sections',`folder`='joomla',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='joomla.sections';
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_696,@dbtid_9,'0','joomla.sections','joomla',@rolid_0,'0','1','0','0','autofld=1','','joomla','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_697,`dbtid`=@dbtid_10,`path`='0',`namekey`='joomla.categories',`folder`='joomla',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='joomla.categories';
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_697,@dbtid_10,'0','joomla.categories','joomla',@rolid_0,'0','1','0','0','autofld=1','','joomla','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_699,`dbtid`=@dbtid_8,`path`='0',`namekey`='role.sections',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open-o',`pnamekey`='' WHERE  `namekey`='role.sections';
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_699,@dbtid_8,'0','role.sections','role',@rolid_0,'0','1','0','0','autofld=1','','role','0','0','1','fa-folder-open-o','');
UPDATE `#__model_node`  SET `sid`=@pk_621_700,`dbtid`=@dbtid_11,`path`='0',`namekey`='role.categories',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='role.categories';
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_700,@dbtid_11,'0','role.categories','role',@rolid_0,'0','1','0','0','autofld=1','','role','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_701,`dbtid`=@dbtid_12,`path`='0',`namekey`='role.content',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='role.content';
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_701,@dbtid_12,'0','role.content','role',@rolid_0,'0','1','0','0','autofld=1','','role','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_809,`dbtid`=@dbtid_13,`path`='0',`namekey`='ticket.clickyesno',`folder`='ticket.clickyesno',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='ticket',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='ticket.clickyesno';
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_809,@dbtid_13,'0','ticket.clickyesno','ticket.clickyesno',@rolid_0,'0','1','0','0','autofld=1','','ticket','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_859,`dbtid`=@dbtid_6,`path`='1',`namekey`='comment',`folder`='comment',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comment',`pnamekey`='' WHERE  `namekey`='comment';
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_859,@dbtid_6,'1','comment','comment',@rolid_0,'0','1','0','0','autofld=1','','comment','0','0','1','fa-comment','');
UPDATE `#__model_node`  SET `sid`=@pk_621_860,`dbtid`=@dbtid_4,`path`='0',`namekey`='commenttrans',`folder`='commenttrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=comment',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comment',`pnamekey`='' WHERE  `namekey`='commenttrans';
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_860,@dbtid_4,'0','commenttrans','commenttrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=comment','','comment','0','0','1','fa-comment','');
UPDATE `#__model_node`  SET `sid`=@pk_621_861,`dbtid`=@dbtid_1,`path`='0',`namekey`='comment.member',`folder`='comment.member',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='comment.member';
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_861,@dbtid_1,'0','comment.member','comment.member',@rolid_0,'0','1','0','0','autofld=1','','comment','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_899,`dbtid`=@dbtid_7,`path`='1',`namekey`='comment.reply',`folder`='comment.reply',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comments',`pnamekey`='' WHERE  `namekey`='comment.reply';
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_899,@dbtid_7,'1','comment.reply','comment.reply',@rolid_0,'0','1','0','0','autofld=1','','comment','0','0','1','fa-comments','');
UPDATE `#__model_node`  SET `sid`=@pk_621_900,`dbtid`=@dbtid_5,`path`='0',`namekey`='comment.replytrans',`folder`='comment.replytrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nmainmodel=comment.reply',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comments',`pnamekey`='' WHERE  `namekey`='comment.replytrans';
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_900,@dbtid_5,'0','comment.replytrans','comment.replytrans',@rolid_0,'0','1','0','0','autofld=1\nmainmodel=comment.reply','','comment','0','0','1','fa-comments','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1294,`dbtid`=@dbtid_13,`path`='0',`namekey`='comment.clickyesno',`folder`='comment.clickyesno',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='comment',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='comment.clickyesno';
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_1294,@dbtid_13,'0','comment.clickyesno','comment.clickyesno',@rolid_0,'0','1','0','0','autofld=1','','comment','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_5,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),`path`='1',`namekey`='extension',`folder`='extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=core',`alias`='',`prefix`='extension',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-mobile',`pnamekey`='' WHERE  `namekey`='extension';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_5,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),'1','extension','extension',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=core','','extension','0','0','1','fa-mobile','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1039,`dbtid`=@dbtid_10,`path`='0',`namekey`='joomla.categoriesj16',`folder`='joomla',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1\nparentmap=parent_id\nparentname=title\nskipdepth=1',`alias`='',`prefix`='joomla',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='joomla.categoriesj16';
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_1039,@dbtid_10,'0','joomla.categoriesj16','joomla',@rolid_0,'0','1','0','0','autofld=1\nparentmap=parent_id\nparentname=title\nskipdepth=1','','joomla','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_306,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),`path`='1',`namekey`='product',`folder`='product',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\ngrptable=product.categoryproduct\ncachedata=1\nautofld=1\ncategorymodel=product.category',`alias`='',`prefix`='product',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-laptop',`pnamekey`='' WHERE  `namekey`='product';
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_306,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),'1','product','product',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\ngrptable=product.categoryproduct\ncachedata=1\nautofld=1\ncategorymodel=product.category','','product','1','0','1','fa-laptop','');
UPDATE `#__model_node`  SET `sid`=@pk_621_338,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),`path`='0',`namekey`='product.categoryproduct',`folder`='product.categoryproduct',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=catid\nautofld=1',`alias`='',`prefix`='productcat',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-folder-open',`pnamekey`='' WHERE  `namekey`='product.categoryproduct';
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_338,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='productcat.product' LIMIT 1),'0','product.categoryproduct','product.categoryproduct',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=catid\nautofld=1','','productcat','0','0','1','fa-folder-open','');
UPDATE `#__model_node`  SET `sid`=@pk_621_309,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),`path`='0',`namekey`='producttrans',`folder`='producttrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=product',`alias`='',`prefix`='product',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-laptop',`pnamekey`='' WHERE  `namekey`='producttrans';
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_309,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.trans' LIMIT 1),'0','producttrans','producttrans',@rolid_0,'0','1','0','0','\nmainmodel=product','','product','0','0','1','fa-laptop','');
UPDATE `#__model_node`  SET `sid`=@pk_621_323,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.node' LIMIT 1),`path`='1',`namekey`='address',`folder`='address',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='premmap=premium\npremgroup=uid\ncachedata=1',`alias`='',`prefix`='address',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='address';
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_323,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='address.node' LIMIT 1),'1','address','address',@rolid_0,'0','1','0','0','premmap=premium\npremgroup=uid\ncachedata=1','','address','0','0','1','','');

SET @wid_18 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='comment.node' LIMIT 1);
SET @sid_19 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @sid_20 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment' LIMIT 1);
SET @rolid_21 = (7);
SET @sid_22 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.reply' LIMIT 1);
SET @sid_23 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.member' LIMIT 1);
SET @sid_24 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.content' LIMIT 1);
SET @sid_25 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.sections' LIMIT 1);
SET @sid_26 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categories' LIMIT 1);
SET @sid_27 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categoriesj16' LIMIT 1);
SET @rolid_28 = (3);
SET @yid_29 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_preferences' LIMIT 1);
SET @yid_30 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='post_comment_non_reg_fe' LIMIT 1);
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comments_edit_form' LIMIT 1);
SET @yid_32 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_reply_be' LIMIT 1);
SET @yid_33 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comments_show_specific_be' LIMIT 1);
SET @yid_34 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_post_fe' LIMIT 1);
SET @yid_35 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_show' LIMIT 1);
SET @yid_36 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_reply_fe' LIMIT 1);
SET @sid_37 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='commenttrans' LIMIT 1);
SET @sid_38 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.replytrans' LIMIT 1);
SET @ref_yid_39 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_fe' LIMIT 1);
SET @ref_yid_40 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_information' LIMIT 1);
SET @ref_yid_41 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='replies_be_comment' LIMIT 1);
SET @ref_yid_42 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='replies_fe_comment' LIMIT 1);
SET @ref_yid_43 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_listing_be' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_preferences_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('comments_preferences_front-end_ordering','comments_preferences_comment_node_cmtnonorreg','comments_preferences_comment_node_allowreply','comments_preferences_comment_node_editor','comments_preferences_comment_node_cmtaverating','comments_preferences_avatar') LIMIT 6;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_preferences_front-end_ordering' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('comments_preferences_comment_node_cmtrating','comments_preferences_comment_node_cmtdate') LIMIT 2;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_preferences_notifications' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('comments_preferences_comment_node_cmtnotifyadmin','comments_preferences_comment_node_cmtnotifyemail','comments_preferences_comment_node_cmtapproval','comments_preferences_comment_node_cmtnotifyauthor') LIMIT 4;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_preferences_integration' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('comments_preferences_comment_node_cmtarticle') LIMIT 1;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='post_comment_non_reg_fe_add_credentials_tab' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('post_comment_non_reg_fe_name','post_comment_non_reg_fe_email') LIMIT 2;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='post_comment_non_reg_fe_add_comment' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('post_comment_non_reg_fe_commenttrans_name','post_comment_non_reg_fe_comment_score','post_comment_non_reg_fe_commenttrans_description','post_comment_non_reg_fe_type_the_words') LIMIT 4;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_show_specific_be_replies' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('comments_show_specific_be_previous_replies') LIMIT 1;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_show_specific_be_add_/_edit_reply' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('comments_show_specific_be_comment_replytrans_description','comments_show_specific_be_save') LIMIT 2;
SET @p_1_8 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comments_edit_form_comment\'s_information' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_8 WHERE `namekey` IN ('comments_edit_form_commenttrans_name','comments_edit_form_commenttrans_description','comments_edit_form_comment_score','comments_edit_form_comment_private') LIMIT 4;
SET @p_1_9 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='comment_reply_be_add_/_edit_reply' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_9 WHERE `namekey` IN ('comment_reply_be_comment_replytrans_description','comment_reply_be_save') LIMIT 2;
SET @yid_44 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comments_customers_list' LIMIT 1);
SET @yid_45 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_restrict_articles' LIMIT 1);
SET @yid_46 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_restrict_sections' LIMIT 1);
SET @yid_47 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_restrict_category_j15' LIMIT 1);
SET @yid_48 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_latest_comments_dashboard' LIMIT 1);
SET @yid_49 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_restrict_category_j16' LIMIT 1);
SET @yid_50 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='comment_fe_integration' LIMIT 1);
SET @yid_51 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='task_reply_head_comment' LIMIT 1);
SET @sid_52 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.categories' LIMIT 1);
SET @sid_53 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='product' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_listing_be_commenttrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('comment_listing_be_commenttrans_name_5','comment_listing_be_comment_namekey') LIMIT 2;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='latest_comments_dashboard_commenttrans_name_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('latest_comments_dashboard_commenttrans_name','latest_comments_dashboard_comment_namekey','latest_comments_dashboard_comment_member_name','latest_comments_dashboard_comment_modified') LIMIT 4;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_listing_be_commenttrans_name_5' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('comment_listing_be_commenttrans_description') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_listing_be_comment_member_name_4' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('comment_listing_be_comment_member_name','comment_listing_be_comment_member_username') LIMIT 2;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_listing_be_usefulness' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('comment_listing_be_comment_useful','comment_listing_be_comment_usefulclick') LIMIT 2;
SET @p_3_5 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_listing_be_type' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_5 WHERE `namekey` IN ('comment_listing_be_comment_commenttype','comment_listing_be_comment_tkid_2') LIMIT 2;
SET @p_3_6 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comments_fe_comment' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_6 WHERE `namekey` IN ('comments_fe_comment_score','comments_fe_users_username','comments_fe_commenttrans_description','comments_fe_show_replies','comments_fe_users_uid','comments_fe_commenttrans_name','comments_fe_comment_useful') LIMIT 7;
SET @p_3_7 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comments_customers_list_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_7 WHERE `namekey` IN ('comments_customers_list_comment_member_name','comments_customers_list_comment_member_username') LIMIT 2;
SET @p_3_8 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comments_customers_list_comment_member_login_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_8 WHERE `namekey` IN ('comments_customers_list_comment_member_login','comments_customers_list_comment_member_login_2') LIMIT 2;
SET @p_3_9 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comments_fe_integration_' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_9 WHERE `namekey` IN ('comments_fe_integration_comment_score','comments_fe_integration_comment_member_username','comments_fe_integration_commenttrans_description','comments_fe_integration_comment_member_uid','comments_fe_integration_commenttrans_name','comments_fe_integration_deleteedit','comments_fe_integration_comment_useful') LIMIT 7;
SET @p_3_10 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_restrict_articles_joomla_content_title_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_10 WHERE `namekey` IN ('comment_restrict_articles_joomla_content_title','comment_restrict_articles_joomla_content_introtext') LIMIT 2;
SET @p_3_11 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_restrict_sections_joomla_sections_title_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_11 WHERE `namekey` IN ('comment_restrict_sections_joomla_sections_title','comment_restrict_sections_joomla_sections_description') LIMIT 2;
SET @p_3_12 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_restrict_category_j15_joomla_categories_title_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_12 WHERE `namekey` IN ('comment_restrict_category_j15_joomla_categories_title','comment_restrict_category_j15_joomla_categories_description') LIMIT 2;
SET @p_3_13 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='latest_comments_dashboard_commenttrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_13 WHERE `namekey` IN ('latest_comments_dashboard_commenttrans_description') LIMIT 1;
SET @p_3_14 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='latest_comments_dashboard_type' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_14 WHERE `namekey` IN ('latest_comments_dashboard_comment_commenttype','latest_comments_dashboard_product_namekey') LIMIT 2;
SET @p_3_15 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='task_reply_head_comment_comment' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_15 WHERE `namekey` IN ('task_reply_head_comment_commenttrans_name','task_reply_head_comment_comment_score','task_reply_head_comment_commenttrans_description') LIMIT 3;
SET @p_3_16 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='task_reply_head_comment_details' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_16 WHERE `namekey` IN ('task_reply_head_comment_comment_created','task_reply_head_comment_users_username') LIMIT 2;
SET @p_3_17 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='replies_fe_comment_hidden' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_17 WHERE `namekey` IN ('replies_fe_comment_users_username','replies_fe_comment_comment_replytrans_description','replies_fe_comment_comment_tkid','replies_fe_comment_comment_reply_tkrid','replies_fe_comment_comment_reply_authoruid_1','replies_fe_comment_comment_reply_created') LIMIT 6;
SET @p_3_18 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='replies_be_comment_replies' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_18 WHERE `namekey` IN ('replies_be_comment_users_name','replies_be_comment_comment_replytrans_description','replies_be_comment_actions','replies_be_comment_comment_tkid','replies_be_comment_comment_reply_tkrid','replies_be_comment_comment_reply_authoruid','replies_be_comment_comment_reply_created') LIMIT 7;
SET @p_3_19 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_information_hidden' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_19 WHERE `namekey` IN ('comment_information_comment_comment','comment_information_comment_ip','comment_information_users_username','comment_information_comment_private','comment_information_commenttrans_description','comment_information_comment_created') LIMIT 6;
SET @p_3_20 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='comment_restrict_category_j16_joomla_categoriesj16_title_1' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_20 WHERE `namekey` IN ('comment_restrict_category_j16_joomla_categoriesj16_title','comment_restrict_category_j16_joomla_categoriesj16_description') LIMIT 2;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Yes','1','1206732372QTKI'),('No','1','1206732372QTKJ'),('Delete','1','1206732372QTKL'),('Publish','1','1206732372QTKN'),('Wizard','1','1206732391QBUR'),('Help','1','1206732392OZUP'),('#','1','1206732392OZVA'),('Name','1','1206732392OZVB'),('Type','1','1206732392OZVD'),('Description','1','1206732392OZVG'),('Cancel','1','1206732393CXVV'),('Save','1','1206732399EINB'),('ID','1','1206732400OWXG'),('Author','1','1206732400OWZO'),('General','1','1206732400OWZR'),('Category','1','1206732411EGQO'),('Categories','1','1206732411EGQQ'),('Member','1','1206732411EGRG'),('Email','1','1206732411EGRU'),('Username','1','1206732411EGRV'),('Created','1','1206732411EGRY'),('Submit','1','1206732412DADY'),('Title','1','1206732412DAGC'),('Date','1','1206961850KLRI'),('hidden','1','1206961869IGND'),('Message','1','1206961882TDGU'),('Reply','1','1206961882TDGX'),('Back','1','1206961882TDHA'),('Content','1','1206961882TDHH'),('Customers','1','1206961902CIFI'),('Comments','1','1206961912MJQH'),('Details','1','1206961936HCWR'),('save','1','1206961995OYFV'),('Replies','1','1206964391FHVD'),('Ticket','1','1206964391FHVU'),('Previous replies','1','1206964391FHVV'),('Role','1','1209142268NMKA'),('Alias','1','1211811583DBTA'),('Article','1','1212761231MDKH'),('By','1','1213117657LKZK'),('delete','1','1215001889GXZH'),('Enter your reply to the ticket.','1','1215507805HPST'),('Actions','1','1217251965LDTZ'),('Comment','1','1219769904NDHD'),('Private','1','1219769905FKPR'),('0','1','1219856743ELFT'),('Public','1','1224166212FTLB'),('edit','1','1227581118COMT'),('Avatar','1','1228709252AHXW'),('Close','1','1228820287MBVC'),('Users','1','1229653442FEQZ'),('<br><br><br>','1','1234467594BCKE'),('Feedback','1','1234467597SEXU'),('Section','1','1235461972DIWA'),('Sections','1','1235461972DIWF'),('Articles','1','1235461972DIWG'),('back','1','1236926427LMQB'),('cancel','1','1240888719GIAU'),('Privacy','1','1241402690BDIL'),('IP Address','1','1241769455CJUW'),('Author Name','1','1242282436IIYK'),('Last Visit','1','1242282446GIMI'),('Done','1','1242282449PIPC'),('Rating','1','1246243851IGLH'),('reviews','1','1246243852IPUS'),('Post a Comment','1','1246243853BGZB'),('Integration','1','1246509032AGXF'),('ticket.clickyesno','1','1246509662FEPJ'),('Show Comment','1','1247061788DBVR'),('comment','1','1251466557JSUA'),('Title of the comment<br><br><br>','1','1251534827NBKK'),('Message of your comment to be posted.<br>','1','1251534827NBKL'),('Rating of the item you commented.<br><br>','1','1251534827NBKM'),('Allow non-registered users  to post a comment for a product or an article. <br>','1','1251534827NBKN'),('The moderator of the site will be notified once a feedback or reply is posted. The email used is the email given in the input box below else all administrator will be notified.','1','1251534828ITWR'),('Specify an email to receive all the moderator notifications.','1','1251534828ITWS'),('Title of the comment.<br>','1','1251534828ITWT'),('This will be the editor used on editing your comment on the front-end. <br>','1','1251534828ITWU'),('Message of the comment<br>','1','1251534828ITWW'),('product id<br>','1','1251534828ITWX'),('Use Comment system on all the articles on your site<br>','1','1251534828ITXA'),('Allow non-registered','1','1251534828ITXB'),('Default Comment Editor','1','1251534828ITXF'),('Comments Posted','1','1251534828ITXH'),('Email Address','1','1251534828ITXI'),('Comment Message','1','1251534828ITXJ'),('Front-End Ordering','1','1251534828ITXM'),('By date','1','1251534828ITXN'),('By rating','1','1251534828ITXO'),('comments','1','1251534828ITXQ'),('//star rating should be displayed','1','1251534828ITXS'),('Usefulness','1','1251534828ITXT'),('No. of votes','1','1251534828ITXU'),('No. of times it\'s useful','1','1251534828ITXV'),(' Rating','1','1251534828ITXY'),('Delete/Edit','1','1251534828ITXZ'),('Comment ID','1','1251534828ITYA'),('Comments Preferences','1','1251534828ITYC'),('<p>This views lists all the comments posted by the users on all products and articles.</p>\r\n\r\n<ul>\r\n	<li>To preview a comment, click on the title of the comment.</li>\r\n	<li>To edit or delete a comment, click on the edit or delete icon.</li>\r\n	<li>Private -&nbsp; this will make the comment only displayed for the author and the administrator only. Click on the Yes/No legend&nbsp; under the Private Column to change.</li>\r\n</ul>','1','1251534828ITYD'),('This view shows all the preferences available in the application.<br><ul><li>You can set the general settings, notifications, and security in your own choice.</li></ul>','1','1251534828ITYG'),('This list displays all the users who posted feedback.<br><ul><li>To view the profile of each user, clicked on their name.</li><li>To view the list of feedback, clicked on the Feedback<span style=\"color: rgb(0, 0, 153);\"> </span>link in the feedback column.</li></ul>','1','1251534828ITYI');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('This views lets you edit the information about a specific comment.<br><ul><li>Title - the title of the comment</li><li>Comment Message - the message given by the author as his/her comment\'s body</li><li>Publish - status whether the comment is being displayed on the front-end or not</li></ul>','1','1251534829MVON'),('Comment\'s Listing','1','1251534829MVOO'),('Save all the preferences that you have updated<br>','1','1251534829MVOT'),('Cancels all the updates on the Comment Preferences<br>','1','1251534829MVOU'),('Displays the view for Comment Member\'s List on the Back-end<br>','1','1251534829MVOW'),('This task triggers when the yes/no question is clicked<br>','1','1251534829MVOY'),('To save a comment','1','1251534829MVPB'),('Save Comments Preferences','1','1251534829MVPC'),('Cancel on comment preferences','1','1251534829MVPD'),('Comment members listing BE','1','1251534829MVPF'),('To list all the Comment\'s Posted','1','1251534829MVPH'),('Toggle between publish/unpublish a comment','1','1251534829MVPJ'),('Comment is useful','1','1251534829MVPK'),('Rate the comment','1','1251534829MVPL'),('Comment Show individual comment','1','1251534829MVPM'),('Comment Back to Comments','1','1251534829MVPN'),('Edit the comment','1','1251534829MVPO'),('Delete a Comment','1','1251534829MVPP'),('comment delete','1','1251534829MVPQ'),('Save the comment for Registered User','1','1251534829MVPR'),('Comment Update','1','1251534829MVPS'),('Comment Preferences Cancel','1','1251534829MVPT'),('Apply Edited Comment BE','1','1251534829MVPU'),('You already voted this comment.','1','1251795312BCNX'),('No one has voted yet','1','1251795312BCNY'),('Date Created','1','1253278128ELPC'),('Enable Comments','1','1253278128ELPD'),('Comment Articles','1','1253278129BICP'),('Comment Sections','1','1253278129BICQ'),('Title of the comment<br><br>','1','1254121403QJCH'),('Rating given by the author<br>','1','1254121403QJCI'),('Comment\'s Information','1','1254121404KQGF'),('Title Description','1','1254121404KQGG'),('Enable Comment','1','1254121405BPLK'),('This view displays all the sections available in joomla.<br><ul><li>It enables you to prohibit the users in posting a comments to each sections or not. By doing so,  click on the link either <span style=\"font-weight: bold; color: rgb(0, 153, 0);\">Yes</span> or <span style=\"color: rgb(255, 0, 51); font-weight: bold;\">No</span> in the \"Enable Comments\" column, then the status will be changed and the section is restricted from posting a comment or not restricted.</li><li>To edit the section, click on the title of the section to be edited.</li><li>If you want to enable comments to more than one sections, check the checkbox on each sections and click \"Enable Comment\" button.<br></li></ul>','1','1254121405BPLL'),('Comment Categories','1','1254121405BPLN'),('Comment Articles Assign','1','1254121405BPLR'),('Comment Categories Assign','1','1254121405BPLS'),('Comment Categories Enable','1','1254121405BPLT'),('Comment Articles Enable','1','1254121406FXLU'),('Comment Sections Assign','1','1254121406FXLV'),('Comment Sections Enable','1','1254121406FXLW'),('Show Average Rating on Artilces','1','1254409114PQTC'),('Click yes, if you want to show the average rating of each articles below the date when the article is created. The average rating in joomla is overwritten.<br>','1','1254472360EPGX'),('Apply the changes','1','1254821420BXFM'),('This views let you see the information about a specific comment and show the previous replies. You can also post a new reply in add reply form below.<br><ul><li>To view the profile of the author, click on the name.</li><li>To preview the complete location of the author, click on the IP Address information.</li><li>To edit a reply, click on edit button (Pro version).<br></li><li>To delete a reply, click on the delete button (Pro version). </li></ul>','1','1254879796ICUK'),('Edit Comment','1','1254879796ICUL'),('Show comment\'s information','1','1254879797GBFK'),('Reviews','1','1257243218GPNH'),('Comments dashboard','1','1260157228RFRM'),(' Add Comment','1','1260167447OHGQ'),('review','1','1260242519OFEU'),('reply head','1','1262855105MYEP'),('previous replies','1','1262855105MYEQ'),('Show replies','1','1262855106GGLB'),('Replies comment','1','1262855107BJEZ'),('comment-reply','1','1262855107BJFA'),('comment-replyhead','1','1262855108FREW'),('Add / Edit Reply','1','1262857562MQDL'),('Replies BE comment','1','1262915431QYDZ'),('Enter your reply to the comment.','1','1263201275SILO'),('You can notify the author of the feedback if there\'s any new reply posted.','1','1263201275SILP'),('save1','1','1263201278GNSI'),('See Replies','1','1263201684IZCU'),('Click here to view the reply','1','1263274585KCHI'),('A reply to this comment<br>','1','1263274592DISC'),('Previous Replies','1','1263274593RGXW'),('Comment Information','1','1263278568HIPB'),('<br>Replies be for comment<br><br><br><br>','1','1263376343LSCV'),('listing be','1','1263376346FFLT'),('on','1','1272278972GKNC'),('out of','1','1272278972GKND'),(' users found this comment useful','1','1272278972GKNE'),('ASC - means \"ascending\" <br><ul><li>If you want to sort the comment by date from oldest to latest</li></ul><br>DESC - means \"descending\"<br><ul><li>If you want to sort the comments by date from latest to oldest </li></ul>','1','1272278975FDGA'),('ASC - means \"ascending\"<br><ul><li>If you want to sort the comments from highest to the lowest rating</li></ul>DESC - means \"descending\"<br><ul><li>If you want to sort the comments from lowest to highest rating. </li></ul><br>','1','1272278975FDGB'),('This view displays all Joomla articles.<br><ul><li> It enables you to prohibit the users in posting feedback to each articles or not. To do so,  click on the link either <span style=\"color: rgb(51, 153, 51); font-weight: bold;\">Yes</span> or <span style=\"font-weight: bold; color: rgb(255, 0, 51);\">No</span> in the \"Enable Feedback\" column, then the status will be changed.</li></ul><ul><li>To edit the article, click on the title of the article to be edited.</li></ul><ul><li>If you want to enable feedback to more than one article, check the checkbox on each articles and click \"Enable Feedback\" button.</li></ul>','1','1272278977AVBY'),('This view displays all the categories of artilces available in joomla.<br><ul><li>It enables you to prohibit the users in posting a comments to each categories or not. By doing so,  click on the link either <span style=\"color: rgb(51, 153, 51); font-weight: bold;\">Yes</span> or <span style=\"font-weight: bold; color: rgb(255, 0, 51);\">No</span>  in the \"Enable Comments\" column, then the status will be changed and the category is restricted from posting a comment or not restricted.</li></ul><ul><li>To edit the section, click on the title of the category to be edited.</li></ul><ul><li>If you want to enable/disable comments to more than one categories, check the checkbox on each sections and click \"Enable Comment\" button.</li></ul>','1','1272278977AVCA'),('Comment [$namekey] is approved','1','1273127872RXWA'),('Comment [$namekey] has already been approved','1','1273127872RXWB'),('Your comment still needs approval by the Admin','1','1273127873NGVN'),('Enable Feedback','1','1298350840ISOI'),('Notify Moderator','1','1298350843FMVC'),('Moderator Email','1','1298350843FMVD'),('Use Feedback on Articles','1','1298350843FMVE'),('Notify Author','1','1298350843FMVF'),('Feedback Approval','1','1298350843FMVG'),('Comments Form','1','1298350843FMVH'),('Feedback Preferences','1','1298350844JHJY'),('Customers\' List','1','1298350844JHJZ'),('Moderation','1','1302502838CVPP'),('Be the first to review','1','1303972032APHM'),('Review','1','1304253943KWEJ'),('','1','1304525968YBL'),('Add a comment','1','1306763027PHWE'),('people found this comment useful!','1','1307514212KJCT'),('people found this review useful!','1','1307514212KJCU'),('Was this comment useful to you?','1','1307514212KJCV'),('Was this review useful to you?','1','1307514212KJCW'),('You need to login first to reply!','1','1307514215TBVS'),('Be the first to comment','1','1307673208ILBE'),('Add a review','1','1307673208ILBF');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('You need to log-in to Add a Comment','1','1327547572MFBV'),('reply','1','1327547574PRQA'),('replytrans','1','1327547575DXVE'),('View Page','1','1327592640PUQE'),('Click here to view the comment','1','1327615780QFKY'),('{tag:actor} posted {multiple}{count} comments{/multiple}{single}a comment{/single} about vendor $ITEMNAME','1','1338493462CZZH'),('{tag:actor} posted {multiple}{count} comments{/multiple}{single}a comment{/single} about item $ITEM_NAME.','1','1338493462CZZI'),('Post a Review','1','1339527238FIMW'),('Type the letters','1','1340666912COKB'),('Credentials','1','1340666912COKC'),('Type the correct letters displayed in the image.<br>','1','1340666912COKD'),('Login to review','1','1344536624AUFN'),('Login to comment','1','1344536624AUFO'),('Allow reply on feedback','1','1348175112SGMS'),('Allow users to reply to posted reviews or comments.<br>','1','1348175112SGMT'),('New Comment is Posted {widget:param|name=commentid}','1','1380065076PPZN'),('New Reply is Posted {widget:param|name=replyid}','1','1380065076PPZO'),('Hi,\r\n\r\nThis email is to notify you that a new comment is posted by the user.\r\n\r\n{widget:param|name=approvalMsg} {widget:param|name=approvalMsg} {widget:param|name=approvalLink}.\r\n\r\nHere are the information posted:\r\n\r\nTitle:\r\n{widget:param|name=title}\r\n\r\nComment:\r\n{widget:param|name=description}\r\n\r\nThe rating given:\r\n{widget:param|name=score}\r\n\r\nLink:\r\n{widget:param|name=link}\r\n                                           Powered by Joobi','1','1380065076PPZP'),('Hi,\r\n\r\nThis email is to notify you that a new reply is posted by the user.\r\n\r\nHere are the information posted:\r\n\r\n\r\nReply:\r\n{widget:param|name=description}\r\n\r\nLink:\r\n{widget:param|name=link}\r\n                                           Powered by Joobi','1','1380065076PPZQ'),('Hi,<br><br>This email is to notify you that a new comment is posted by the user.<br><br>{widget:param|name=approvalMsg}<div>{widget:param|name=approvalLink}<br><br>Here are the information posted:<br><br><span style=\"text-decoration: underline; font-weight: bold;\">Title: </span><br>{widget:param|name=title}<br><br><span style=\"text-decoration: underline; font-weight: bold;\">Comment:</span><br>{widget:param|name=description}<br><br><span style=\"text-decoration: underline; font-weight: bold;\">The rating given:</span><br>{widget:param|name=score}<br><br><span style=\"font-weight: bold; text-decoration: underline;\">Link:</span><br>{widget:param|name=link}<br><br><div style=\"text-align: center;\">Powered by <a target=\"_blank\" title=\"\" href=\"http://www.joobi.co/\">Joobi</a><br></div></div>','1','1380065076PPZR'),('Loading','1','1395500509GSSS'),('Comment reply','1','1400071918PQAT'),('It still needs your approval if you want to publish this comment in the front-end. ','1','1408411776NUFZ'),('Click here to approve the comment','1','1408411776NUGA'),('Stars','1','1408411776NUGB'),('1408385293','1','1408411778LQEF'),('A new comment is added to your task {widget:param|name=title}','1','1411136092QKNG'),('Hello {widget:name},<br><br>A new comment&nbsp; was added to the task : {widget:param|name=title}<br>Details:<br>{widget:param|name=details}<br><br>Thank you<br>{widget:site} team<br>','1','1411136092QKNH'),('1411062292','1','1411136092QKNI'),('Hi,<br><br>This email is to notify you that a new reply is posted by the user.<br><br>Here are the information posted:<br><br><span style=\"text-decoration: underline; font-weight: bold;\"></span><span style=\"text-decoration: underline; font-weight: bold;\">Reply:</span><br>{widget:param|name=description}<br><br><span style=\"font-weight: bold; text-decoration: underline;\">Link:</span><br>{widget:param|name=link}<br><br><div style=\"text-align: center;\">Powered by <a target=\"_blank\" title=\"\" href=\"http://www.joobi.co/\">Joobi</a><br></div>','1','1418159812IACR'),('Yes to require approval for each feedback posted.','1','1418338212OMGQ'),('Only customers can review','1','1418689659NRQX'),('This views lists all the comments posted by the users on all products and articles.<br><ul><li>To preview a comment, click on the title of the comment.</li><li>To edit or delete a comment, click on the edit or delete icon.<br></li><li>Private -  this will make the comment only displayed for the author and the administrator only. Click on the Yes/No legend  under the Private Column to change.</li></ul>','1','1421321709PLYL');
SET @dbcid_54 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' LIMIT 1);
SET @dbcid_55 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532authoruid' LIMIT 1);
SET @dbcid_56 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532tkid' LIMIT 1);
SET @dbcid_57 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='695id' LIMIT 1);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_node' LIMIT 1),'1','0',@dbcid_54);
REPLACE INTO `#__dataset_constraintsitems` (`ctid`,`ordering`,`sort`,`dbcid`) VALUES (( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_members_node_name' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232name' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_username' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232username' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_email' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232email' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_content|main_joomla15' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='356id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_405_namekey' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405namekey' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_members_pjid_uid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526pjid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_members_pjid_uid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526uid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_authoruid' LIMIT 1),'1','0',@dbcid_55),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_modified' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532modified' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_node_tkid' LIMIT 1),'1','0',@dbcid_56),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_trans_description' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533description' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_tickettrans_tkid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_trans_name' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533name' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_tickettrans_tkid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533tkid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_reply_created' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534modified' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_tkid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_reply' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkrid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_replytrans_name' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535description' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_replytrans_tkrid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_replytrans_tkrid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535tkrid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='IX_ticket_node_pjid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532pjid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlasections' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='694id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlasections' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid694' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_sections' LIMIT 1),'1','0',@dbcid_57),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_categories' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacategories' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='697id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacontent' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='698id' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacontent' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid698' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacategories' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid697' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_ticket_clickyesno' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='761clickid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_role_joomlacontent' LIMIT 1),'3','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='comment698' LIMIT 1));
SET @ref_feid_58 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1);
SET @pk_77_353 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_15 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_464 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'405uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10013 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'526pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10014 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'526uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10021 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'534tkid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10024 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_7 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'535tkrid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10029 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'533tkid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10030 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 AND `ref_dbtid`=@dbtid_15 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'533lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10031 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'site.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'532stid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10321 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_1 AND `feid`=@dbcid_55 LIMIT 1 );
SET @pk_77_10367 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_15 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'535lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10372 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10405 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'405rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10434 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'532pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10580 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'project.node\' LIMIT 1' AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'405parent\' LIMIT 1' LIMIT 1 );
SET @pk_77_10621 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'534uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10627 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'assignuid532\' LIMIT 1' LIMIT 1 );
SET @pk_77_10628 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'ticket.projectmembers\' LIMIT 1' AND `feid`=@dbcid_55 LIMIT 1 );
SET @pk_77_10630 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid534\' LIMIT 1' LIMIT 1 );
SET @pk_77_10632 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_3 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'532pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10633 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_3 AND `feid`=@dbcid_55 LIMIT 1 );
SET @pk_77_10634 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid532\' LIMIT 1' LIMIT 1 );
SET @pk_77_10679 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid694\' LIMIT 1' LIMIT 1 );
SET @pk_77_10681 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid698\' LIMIT 1' LIMIT 1 );
SET @pk_77_10682 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_16 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid697\' LIMIT 1' LIMIT 1 );
SET @pk_77_10684 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'694id\' LIMIT 1' LIMIT 1 );
SET @pk_77_10685 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_11 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'697id\' LIMIT 1' LIMIT 1 );
SET @pk_77_10686 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_12 AND `ref_dbtid`=@dbtid_14 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'698id\' LIMIT 1' LIMIT 1 );
SET @pk_77_10810 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_6 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'tkid761\' LIMIT 1' LIMIT 1 );
SET @pk_77_10811 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_13 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid761\' LIMIT 1' LIMIT 1 );
SET @pk_77_10837 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'currency.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'curid232\' LIMIT 1' LIMIT 1 );
SET @pk_77_10859 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'product.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'eid532\' LIMIT 1' LIMIT 1 );
SET @pk_77_10860 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_14 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'eid532\' LIMIT 1' LIMIT 1 );
SET @pk_77_10902 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_14 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'sectionid356\' LIMIT 1' LIMIT 1 );
SET @pk_77_10903 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_14 AND `ref_dbtid`=@dbtid_10 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'catid356\' LIMIT 1' LIMIT 1 );
SET @pk_77_10908 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_9 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'section696\' LIMIT 1' LIMIT 1 );
SET @pk_77_11168 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.countries\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'ctyid232\' LIMIT 1' LIMIT 1 );
SET @pk_77_11315 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'license.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'lcid532\' LIMIT 1' LIMIT 1 );
SET @pk_77_11342 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'joobi.files\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'filid232\' LIMIT 1' LIMIT 1 );
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('lgid','1','FK_members_node_lgid',@pk_77_353,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','1','lgid',@dbtid_15,@dbtid_1,'3');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('uid','1','FK_405_uid_uid',@pk_77_464,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405uid' LIMIT 1),@dbcid_54,'1','1','uid',@dbtid_1,@dbtid_2,'99'),('pjid','1','FK_projectmembers_pjid',@pk_77_10013,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526pjid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405pjid' LIMIT 1),'3','3','pjid',@dbtid_2,@dbtid_3,'1'),('uid','1','FK_projectmembers_uid',@pk_77_10014,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526uid' LIMIT 1),@dbcid_54,'3','3','uid',@dbtid_1,@dbtid_3,'2'),('tkid','1','FK_task_reply_taskid',@pk_77_10021,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkid' LIMIT 1),@dbcid_56,'3','3','tkid',@dbtid_6,@dbtid_7,'1'),('tkrid','1','FK_ticket_replytrans_tkrid',@pk_77_10024,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535tkrid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534tkrid' LIMIT 1),'3','3','tkrid',@dbtid_7,@dbtid_5,'99'),('tkid','1','FK_tickettrans_tkid',@pk_77_10029,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533tkid' LIMIT 1),@dbcid_56,'3','3','tkid',@dbtid_6,@dbtid_4,'99'),('lgid','1','FK_tickettrans_lgid',@pk_77_10030,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',@dbtid_15,@dbtid_4,'99'),('stid','1','FK_ticket_stid',@pk_77_10031,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532stid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='211stid' LIMIT 1),'1','1','stid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='site.node' LIMIT 1),@dbtid_6,'5'),('authoruid','1','FK_tickets_node_authoruid',@pk_77_10321,@dbcid_55,@dbcid_54,'1','1','uid',@dbtid_1,@dbtid_6,'3'),('lgid','1','FK_ticket_replytrans_lgid',@pk_77_10367,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535lgid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1),'1','3','lgid',@dbtid_15,@dbtid_5,'99'),('rolid','1','FK_members_rolid',@pk_77_10372,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1),@ref_feid_58,'1','1','',@dbtid_16,@dbtid_1,'2'),('rolid','1','FK_project_rolid',@pk_77_10405,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405rolid' LIMIT 1),@ref_feid_58,'1','1','',@dbtid_16,@dbtid_2,'99'),('pjid','1','FK_ticket:project|pjid:pjid',@pk_77_10434,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532pjid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405pjid' LIMIT 1),'3','3','pjid',@dbtid_2,@dbtid_6,'2'),('parent','1','FK_Parent405_parentpjid',@pk_77_10580,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405parent' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405pjid' LIMIT 1),'1','1','pjid',@dbtid_2,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.node' LIMIT 1),'99'),('authoruid','1','FK_ticket_reply_authoruid ',@pk_77_10621,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='534uid' LIMIT 1),@dbcid_54,'1','1','uid',@dbtid_1,@dbtid_7,'2'),('assignuid','1','FK_ticket_node_assignuid',@pk_77_10627,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='assignuid532' LIMIT 1),@dbcid_54,'1','1','uid',@dbtid_1,@dbtid_6,'4'),('authoruid','1','FK_tickets_node_authoruid2',@pk_77_10628,@dbcid_55,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='557uid' LIMIT 1),'1','1','uid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.projectmembers' LIMIT 1),@dbtid_6,'6'),('rolid','1','534_rolid_566',@pk_77_10630,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid534' LIMIT 1),@ref_feid_58,'1','1','rolid',@dbtid_16,@dbtid_7,'99'),('pjid','1','FK_ticket_pjid',@pk_77_10632,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='532pjid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526pjid' LIMIT 1),'1','1','pjid',@dbtid_3,@dbtid_6,'7'),('authoruid','1','FK_ticket_authoruid',@pk_77_10633,@dbcid_55,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526uid' LIMIT 1),'1','1','uid',@dbtid_3,@dbtid_6,'8'),('rolid','1','FK_tickets_node_rolid',@pk_77_10634,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid532' LIMIT 1),@ref_feid_58,'1','1','rolid',@dbtid_16,@dbtid_6,'9'),('rolid','1','FK_role_joomlasections_rolid',@pk_77_10679,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid694' LIMIT 1),@ref_feid_58,'3','3','rolid',@dbtid_16,@dbtid_8,'2'),('rolid','1','FK_role_joomlacontent_rolid',@pk_77_10681,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid698' LIMIT 1),@ref_feid_58,'3','3','rolid',@dbtid_16,@dbtid_12,'2'),('rolid','1','FK_role_joomlacategories_rolid',@pk_77_10682,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid697' LIMIT 1),@ref_feid_58,'3','3','rolid',@dbtid_16,@dbtid_11,'2'),('id','1','FK_role_joomlasections_id',@pk_77_10684,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='694id' LIMIT 1),@dbcid_57,'3','3','id',@dbtid_9,@dbtid_8,'1'),('id','1','FK_role_joomlacategories_id',@pk_77_10685,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='697id' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' LIMIT 1),'3','3','id',@dbtid_10,@dbtid_11,'1'),('id','1','FK_role_joomlacontent_id',@pk_77_10686,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='698id' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='356id' LIMIT 1),'3','3','id',@dbtid_14,@dbtid_12,'1'),('tkid','1','761_tkid_532',@pk_77_10810,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='tkid761' LIMIT 1),@dbcid_56,'3','3','tkid',@dbtid_6,@dbtid_13,'1'),('uid','1','761_uid_232',@pk_77_10811,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid761' LIMIT 1),@dbcid_54,'1','1','uid',@dbtid_1,@dbtid_13,'2'),('curid','1','FK_members_curid',@pk_77_10837,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='curid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='624curid' LIMIT 1),'3','3','curid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1),@dbtid_1,'1'),('etid','1','FK_producttrans_etid',@pk_77_10859,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='eid532' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='306pid' LIMIT 1),'3','3','pid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='product.node' LIMIT 1),@dbtid_6,'10'),('etid','1','FK_content_id',@pk_77_10860,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='eid532' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='356id' LIMIT 1),'1','1','id',@dbtid_14,@dbtid_6,'11'),('sectionid','1','FK_joomla_content_sectionid',@pk_77_10902,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='sectionid356' LIMIT 1),@dbcid_57,'3','3','id',@dbtid_9,@dbtid_14,'1'),('catid','1','FK_joomla_content_catid',@pk_77_10903,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='catid356' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='696id' LIMIT 1),'3','3','id',@dbtid_10,@dbtid_14,'2'),('section','1','section',@pk_77_10908,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='section696' LIMIT 1),@dbcid_57,'1','1','id',@dbtid_9,@dbtid_10,'1'),('ctyid','1','FK_members_ctyid',@pk_77_11168,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctyid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='200ctyid' LIMIT 1),'1','1','ctyid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1),@dbtid_1,'4'),('lcid','1','FK_ticket_node_lcid',@pk_77_11315,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='lcid532' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='206lcid' LIMIT 1),'1','1','lcid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='license.node' LIMIT 1),@dbtid_6,'12'),('filid','1','FK_members_node_filid',@pk_77_11342,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid232' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='478filid' LIMIT 1),'3','3','filid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1),@dbtid_1,'5');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_18,'1','1206732361LXFE');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_18,'2','1206732372QTKI'),(@wid_18,'2','1206732372QTKJ'),(@wid_18,'1','1206732372QTKL'),(@wid_18,'1','1206961882TDGX'),(@wid_18,'1','1206961912MJQH'),(@wid_18,'1','1213117657LKZK'),(@wid_18,'1','1219769904NDHD'),(@wid_18,'1','1219769905FKPR'),(@wid_18,'1','1224166212FTLB'),(@wid_18,'1','1246243852IPUS'),(@wid_18,'1','1251795312BCNX'),(@wid_18,'1','1251795312BCNY'),(@wid_18,'1','1257243218GPNH'),(@wid_18,'1','1260242519OFEU'),(@wid_18,'1','1263201684IZCU'),(@wid_18,'1','1263274585KCHI'),(@wid_18,'1','1272278972GKNC'),(@wid_18,'1','1272278972GKND'),(@wid_18,'1','1272278972GKNE'),(@wid_18,'0','1273127872RXWA'),(@wid_18,'0','1273127872RXWB'),(@wid_18,'0','1273127873NGVN'),(@wid_18,'1','1303972032APHM'),(@wid_18,'1','1304253943KWEJ'),(@wid_18,'1','1306763027PHWE'),(@wid_18,'1','1307514212KJCT'),(@wid_18,'1','1307514212KJCU'),(@wid_18,'1','1307514212KJCV'),(@wid_18,'1','1307514212KJCW'),(@wid_18,'0','1307514215TBVS'),(@wid_18,'1','1307673208ILBE'),(@wid_18,'1','1307673208ILBF'),(@wid_18,'0','1327547572MFBV'),(@wid_18,'1','1327592640PUQE'),(@wid_18,'1','1327615780QFKY'),(@wid_18,'1','1338493462CZZH'),(@wid_18,'1','1338493462CZZI'),(@wid_18,'1','1344536624AUFN'),(@wid_18,'1','1344536624AUFO'),(@wid_18,'1','1395500509GSSS'),(@wid_18,'1','1408411776NUFZ'),(@wid_18,'1','1408411776NUGA'),(@wid_18,'1','1408411776NUGB'),(@wid_18,'1','1418689659NRQX');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('notify_admin_newcomment',@rolid_0,'1','1','',@wid_18,'Notification admin for new comment','0','{widget:param|name=commentid}\r\n{widget:param|name=title}\r\n{widget:param|name=description}\r\n{widget:param|name=score}\r\n{widget:param|name=link}\r\n{widget:param|name=approvalMsg}\r\n{widget:param|name=approvalLink}\r\n','0','0','1','1','0','3','0','1');
INSERT IGNORE INTO `#__mailing_node` (`namekey`,`rolid`,`type`,`html`,`params`,`wid`,`alias`,`level`,`tags`,`status`,`attach`,`publish`,`core`,`sms`,`template`,`format`,`notify`) VALUES ('notify_admin_author_newreply',@rolid_0,'1','1','',@wid_18,'Notification admin and author for new reply','50','{widget:param|name=replyid}\r\n{widget:param|name=description}\r\n{widget:param|name=link}\r\n','0','0','1','1','0','3','0','1'),('todo_notification_new_comment',@rolid_0,'101','1','',@wid_18,'New comment notification','0','{widget:param|name=title}\r\n{widget:param|name=details}','10','0','1','1','0','3','0','1');
REPLACE INTO `#__extension_info` (`wid`,`author`,`documentation`,`images`,`flash`,`support`,`forum`,`homeurl`,`feedback`,`userversion`,`userlversion`,`beta`,`keyword`) VALUES ((@wid_18),'','','','','','','','','','','0','');
SET @dbcid_59 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_18,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_18,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='533name' LIMIT 1)),(@wid_18,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='535description' LIMIT 1)),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.content' LIMIT 1),'1212761231MDKH',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.project' LIMIT 1),'1206732411EGQO',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.projectmembers' LIMIT 1),'1206964391FHVU',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.sections' LIMIT 1),'1235461972DIWA',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='joomla.categories' LIMIT 1),'1206732411EGQO',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.sections' LIMIT 1),'1235461972DIWA',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.categories' LIMIT 1),'1206732411EGQO',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role.content' LIMIT 1),'1212761231MDKH',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.clickyesno' LIMIT 1),'1246509662FEPJ',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment' LIMIT 1),'1219769904NDHD',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='commenttrans' LIMIT 1),'1219769904NDHD',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.member' LIMIT 1),'1206732411EGRG',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.reply' LIMIT 1),'1327547574PRQA',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.replytrans' LIMIT 1),'1327547575DXVE',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1),'1229653442FEQZ',@dbcid_59),(@wid_18,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='comment.clickyesno' LIMIT 1),'1219769904NDHD',@dbcid_59),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1380065076PPZN',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1380065076PPZO',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1411136092QKNG',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382name' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1380065076PPZP',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1380065076PPZQ',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382ctext' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1380065076PPZR',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1418159812IACR',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1411136092QKNH',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='382chtml' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='bouncemail382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='authorid382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1408411778LQEF',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1219856743ELFT',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1411136092QKNI',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='intro382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='smsmessage382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='title382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_newcomment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='notify_admin_author_newreply' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1)),(@wid_18,( SELECT `mgid` FROM `#__mailing_node`  WHERE `namekey`='todo_notification_new_comment' LIMIT 1),'1304525968YBL',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='subtitle382' LIMIT 1));