/*Export of the extension project.node*/

DELETE FROM `#__translation_en` WHERE `auto` = 1 AND `imac` IN ('','1206964390BUEL','1304525968YBL','1215507791FLOS','1229653442FEQZ','1206732392OZVD','1411052381LDFX','1206961912MJQH','1206732392OZVG','1215507792MTRL','1215507792MTRM','1206732411EGQO','1206961898PIOD','1206732400OWZR','1206732392OZVB','1206961936HCWR','1209142268NMKA','1206732411EGQR','1225790126CCSH','1206732425HINS','1225790126CCSI','1215507792MTRQ','1215507793BYPR','1215507793BYPQ','1206961869IGND','1206732400OWXH','1215507793BYPO','1215507791FLOV','1206732366OVMC','1209674948GCLT','1215507793BYPA','1225790126CCSK','1206732411EGRU','1398536237MPCY','1206961869IGNO','1225790126CCSM','1211811583DBTA','1206732412DAEM','1206732412DAEO','1206732372QTKN','1310007858PLWN','1206961899DDKS','1347652452OQAE','1206732411EGRY','1206961850KLRL','1206732420EIUV','1206961869IGNE','1298350871NSPY','1215507792MTRR','1215507793BYPP','1215507793BYPN','1230530145JEDZ','1225790125DKPF','1225790126CCSE','1242282449PIPC','1206732361LXFE','1206732361LXFD','1206732393CXVV','1206732372QTKL','1206732411EGRG','1206732399EINB','1206732411EGRN','1225790126CCSS','1206732391QBUR','1215534704HYBB','1228820287MBVC','1206732392OZUP','1409868370RQTJ','1409868370RQTK','1206732392OZVA','1211280059QYRN','1373210705CJYY','1225790126CCSQ','1215507792MTRJ','1206732366OVLX','1215507792MTRI','1209123607OCSQ','1215507792MTRK','1206732400OWXG','1215507792MTRN','1215507792MTRO','1241519400RGCB','1409868370RQTH','1409868370RQTI','1206964235BPWK','1209674942SVHA','1215507791FLOP','1225790126CCSV','1215507791FLOR','1209674941LKQN','1215507791FLOT','1225790126CCSX','1225790126CCSY','1206732411EGQQ','1373210706DUJF','1409868370RQTL','1409868370RQTM','1409868370RQTN','1409868370RQTO','1209674942SVHC','1373210706DUJG','1206732429GMSU','1209674941LKQQ','1209674941LKQR','1209674941LKQS','1209674941LKQT','1209674941LKQU','1209674941LKQV','1215507788CYDE','1215507788CYDF','1227581089KZZR','1227581089KZZS','1227581089KZZT','1227581089KZZU','1227581091HODI' );
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.trans','project.members','project.extension','milestone.trans','project.milestones','topic.type','topic.typ.trans','topic.task.comment') ;
DELETE `#__dataset_columns`.* FROM `#__dataset_tables` LEFT JOIN `#__dataset_columns` ON `#__dataset_columns`.`dbtid` = `#__dataset_tables`.`dbtid` WHERE `#__dataset_tables`.`namekey` IN ('members.node','project.node','project.trans','project.members','project.extension','milestone.trans','project.milestones','topic.type','topic.typ.trans','topic.task.comment','extension.node','joobi.files','joobi.languages','joobi.countries','role.node','milestone.node','currency.node','topic.task','topic.checklist.task','model.trans','layout.multiformstrans','layout.mlinkstrans','layout.listingstrans','layout.trans','eguillage.trans') AND `#__dataset_columns`.`namekey` NOT IN ('5publish','5folder','5wid','5params','5status','5type','5name','232uid','478filid','478modified','478name','478params','478path','478size','478type','199lgid','199code','199premium','200ctyid','200isocod2','200isocod3','200name','200namekey','200numcode','232id','232name','232username','232openid','232email','232password','232block','232activation','232timezone','232confirmed','232registerdate','232modified','232lgid','478secure','478uid','232html','405pjid','405namekey','405type','405lft','405rgt','405parent','405rolid','405ordering','405publish','405modified','405created','405uid','410pjid','410lgid','410name','410description','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','5destination','5parent','5trans','484description','5certify','5namekey','232login','405startdate','405enddate','5version','405priority','5lversion','526pjid','526role','526uid','405author','199rtl','543pjid','543wid','5pref','566rolid','566parent','566lft','566rgt','566core','566joomla','481wname','481wdescription','566namekey','232rolid','566color','5rolid','566type','5install','405estimatedtime','199availadmin','199availsite','405depth','609mileid','609deadline','609startdate','610mileid','610name','610lgid','610description','615pjid','615mileid','618sid','618lgid','618name','609alias','199locale','624curid','624title','624code','624number','624symbol','624position','624cents','624basic','624publish','624rate','566depth','199localeconv','ordering5','core5','visibility232','modified5','supportlevel526','frontend405','accepted624','ordering624','714ctrid','714lgid','name714','description714','description485','auto481','fromlgid481','auto410','fromlgid410','auto482','fromlgid482','auto484','fromlgid484','auto485','fromlgid485','auto610','fromlgid610','auto618','fromlgid618','auto714','fromlgid714','timezone200','ltkid405','tickets405','notify526','oncreation405','onreplies405','toassigned405','sendcopy405','curid232','group405','publish200','email405','md5478','j16566','core200','alias478','vendid478','ordering200','modified200','core478','storage478','folder478','ip232','ctyid232','reload5','core199','core624','created5','mobile232','filid232','automatic199','3434taskid','uid3434','modifiedby3434','created3434','modified3434','name3434','description3434','start_date3434','end_date3434','status3434','ordering3434','topicid3434','priority3434','3435typeid','3436typeid','3436lgid','name3436','description3436','auto3436','fromlgid3436','namekey3435','rolid3435','uid3435','modifiedby3435','core3435','publish3435','created3435','modified3435','alias3435','designation3435','premium3435','3439checktaskid','uid3439','modified3439','checklistid3439','taskid3439','status3439','3441commentid','description_comment3441','uid3441','publish3441','modified3441','taskid3441','checktaskid3441','commentid3434','progress3434','showconfig5','framework5','message485','params3439','namekey3434','publish3439') 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','405parent','405rolid','405uid','410pjid','410lgid','526pjid','526uid','543pjid','543wid','232rolid','610mileid','610lgid','615pjid','615mileid','curid232','ctyid232','filid232','3436typeid','3436lgid','rolid3435','uid3435','uid3441','taskid3441','checktaskid3441') AND `#__dataset_foreign`.`namekey` NOT IN ('FK_members_node_lgid','FK_members_rolid','FK_topic_type_lgid','FK_topic_type_typeid','FK_Parent405_parentpjid','FK_project_rolid','FK_405_uid_uid','FK_410_lgid_lgid','FK_410_pjid_pjid','FK_projectmembers_pjid','FK_projectmembers_uid','FK_project_extension_pjid','FK_project_extension_wid','FK_milestonetrans_lgid','FK_milestonetrans_mileid','FK_project.milestones_mileid','FK_project.milestones_pjid','FK_topic_task_comment_checktaskid','FK_members_ctyid','FK_members_curid','FK_members_node_filid','FK_topic_type_rolid','FK_topic_task_comment_taskid','FK_topic_type_uid','FK_topic_task_comment_uid') ;
DELETE `#__translation_reference`.* FROM `#__extension_node` LEFT JOIN `#__translation_reference` ON `#__translation_reference`.`wid` = `#__extension_node`.`wid` WHERE `#__extension_node`.`namekey` IN ('project.node') ;
SET @rolid_0 = (1);
SET @pk_549_232 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='members.node' LIMIT 1 );
SET @pk_549_405 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.node' LIMIT 1 );
SET @pk_549_410 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.trans' LIMIT 1 );
SET @pk_549_526 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.members' LIMIT 1 );
SET @pk_549_543 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.extension' LIMIT 1 );
SET @pk_549_610 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='milestone.trans' LIMIT 1 );
SET @pk_549_615 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.milestones' LIMIT 1 );
SET @pk_549_3435 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.type' LIMIT 1 );
SET @pk_549_3436 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.typ.trans' LIMIT 1 );
SET @pk_549_3441 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.task.comment' LIMIT 1 );
SET @pk_549_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1 );
SET @pk_549_199 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1 );
SET @pk_549_200 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.countries' LIMIT 1 );
SET @pk_549_478 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.files' LIMIT 1 );
SET @pk_549_566 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1 );
SET @pk_549_609 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='milestone.node' LIMIT 1 );
SET @pk_549_624 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='currency.node' LIMIT 1 );
SET @pk_549_3434 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.task' LIMIT 1 );
SET @pk_549_3439 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.checklist.task' LIMIT 1 );
SET @pk_549_618 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='model.trans' LIMIT 1 );
SET @pk_549_532 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.node' LIMIT 1 );
SET @pk_549_482 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.multiformstrans' LIMIT 1 );
SET @pk_549_3433 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.node' LIMIT 1 );
SET @pk_549_485 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.mlinkstrans' LIMIT 1 );
SET @pk_549_484 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.listingstrans' LIMIT 1 );
SET @pk_549_481 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='layout.trans' LIMIT 1 );
SET @pk_549_702 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1 );
SET @pk_549_714 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='eguillage.trans' LIMIT 1 );
REPLACE INTO `#__dataset_tables` (`name`,`namekey`,`dbtid`,`prefix`,`version`,`rolid`,`level`,`type`,`pkey`,`suffix`,`group`,`domain`,`export`,`exportdelete`,`noaudit`,`engine`) VALUES ('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 ('project_node','project.node',@pk_549_405,'','1.0.0',@rolid_0,'0','40','pjid','node','project','51','2','0','0','7'),('project_trans','project.trans',@pk_549_410,'','1.0.0',@rolid_0,'0','20','pjid,lgid','trans','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'),('project_extension','project.extension',@pk_549_543,'','1.0.0',@rolid_0,'0','30','pjid,wid','extension','project','51','2','0','0','7'),('milestone_trans','milestone.trans',@pk_549_610,'','1.0.0',@rolid_0,'0','20','mileid,lgid','trans','milestone','51','2','0','0','7'),('project_milestones','project.milestones',@pk_549_615,'','1.0.0',@rolid_0,'0','30','pjid,mileid','milestones','project','51','2','0','0','7'),('topic_type','topic.type',@pk_549_3435,'','',@rolid_0,'0','1','typeid','','','51','2','0','0','7'),('topic_type_trans','topic.typ.trans',@pk_549_3436,'','',@rolid_0,'0','20','typeid,lgid','','','51','2','0','0','7'),('topic_task_comment','topic.task.comment',@pk_549_3441,'','',@rolid_0,'0','10','commentid','','','51','2','0','0','7'),('extension_node','extension.node',@pk_549_5,'','1.0.0',@rolid_0,'0','1','wid','node','extension','9','2','0','1','7'),('joobi_languages','joobi.languages',@pk_549_199,'','1.0.0',@rolid_0,'0','1','lgid','languages','joobi','51','2','0','0','7'),('joobi_countries','joobi.countries',@pk_549_200,'','1.0.0',@rolid_0,'0','1','ctyid','countries','joobi','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'),('role_node','role.node',@pk_549_566,'','1.0.0',@rolid_0,'0','40','rolid','node','role','51','2','0','0','7'),('milestone_node','milestone.node',@pk_549_609,'','1.0.0',@rolid_0,'0','1','mileid','node','milestone','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'),('topic_task','topic.task',@pk_549_3434,'','',@rolid_0,'0','1','taskid','','','51','2','0','0','7'),('topic_checklist_task','topic.checklist.task',@pk_549_3439,'','',@rolid_0,'0','10','checktaskid','','','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'),('ticket_node','ticket.node',@pk_549_532,'','1.0.0',@rolid_0,'0','1','tkid','node','ticket','51','2','0','0','7'),('layout_multiformstrans','layout.multiformstrans',@pk_549_482,'','1.0.0',@rolid_0,'0','20','fid,lgid','multiformstrans','layout','9','0','0','1','7'),('topic_node','topic.node',@pk_549_3433,'','',@rolid_0,'0','40','topicid','','','51','2','0','0','7'),('layout_mlinkstrans','layout.mlinkstrans',@pk_549_485,'','1.0.0',@rolid_0,'0','20','mid,lgid','mlinkstrans','layout','9','0','0','1','7'),('layout_listingstrans','layout.listingstrans',@pk_549_484,'','1.0.0',@rolid_0,'0','20','lid,lgid','listingstrans','layout','9','0','0','1','7'),('layout_trans','layout.trans',@pk_549_481,'','1.0.0',@rolid_0,'0','20','yid,lgid','trans','layout','9','0','0','1','7'),('role_members','role.members',@pk_549_702,'','',@rolid_0,'0','30','uid,rolid','members','role','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');
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.trans' LIMIT 1);
SET @dbtid_4 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.members' LIMIT 1);
SET @dbtid_5 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.extension' LIMIT 1);
SET @dbtid_6 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='milestone.trans' LIMIT 1);
SET @dbtid_7 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.milestones' LIMIT 1);
SET @dbtid_8 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.type' LIMIT 1);
SET @dbtid_9 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.typ.trans' LIMIT 1);
SET @dbtid_10 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.task.comment' 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_65421 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_projecttrans_pjid_lgid' LIMIT 1 );
SET @pk_454_65451 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_members_pjid_uid' LIMIT 1 );
SET @pk_454_65458 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_extension_pjid_wid' LIMIT 1 );
SET @pk_454_65486 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_milestonetrans_mileid_lgid' LIMIT 1 );
SET @pk_454_65489 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_milestones_pjid_mileid' LIMIT 1 );
SET @pk_454_65594 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_members_node_username' LIMIT 1 );
SET @pk_454_65710 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_members_node' LIMIT 1 );
SET @pk_454_66212 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_type|main_userdata' LIMIT 1 );
SET @pk_454_66213 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_type_trans|main_userdata' LIMIT 1 );
SET @pk_454_66214 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_topic_type' LIMIT 1 );
SET @pk_454_66220 = ( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_task_comment|main_userdata' 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_65421,'3','PK_projecttrans_pjid_lgid',@dbtid_3),(@pk_454_65451,'3','PK_project_members_pjid_uid',@dbtid_4),(@pk_454_65458,'3','PK_project_extension_pjid_wid',@dbtid_5),(@pk_454_65486,'3','PK_milestonetrans_mileid_lgid',@dbtid_6),(@pk_454_65489,'3','PK_project_milestones_pjid_mileid',@dbtid_7),(@pk_454_65594,'1','UK_members_node_username',@dbtid_1),(@pk_454_65710,'3','PK_members_node',@dbtid_1),(@pk_454_66212,'3','PK_jos_topic_type|main_userdata',@dbtid_8),(@pk_454_66213,'3','PK_jos_topic_type_trans|main_userdata',@dbtid_9),(@pk_454_66214,'1','UK_namekey_jos_topic_type',@dbtid_8),(@pk_454_66220,'3','PK_jos_topic_task_comment|main_userdata',@dbtid_10);
SET @dbtid_11 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='joobi.languages' LIMIT 1);
SET @dbtid_12 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.node' LIMIT 1);
SET @dbtid_13 = ( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='milestone.node' 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_2408 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405namekey' LIMIT 1 );
SET @pk_616_2474 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410pjid' LIMIT 1 );
SET @pk_616_2475 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410lgid' 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_3725 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543pjid' LIMIT 1 );
SET @pk_616_3728 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543wid' LIMIT 1 );
SET @pk_616_5958 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610mileid' LIMIT 1 );
SET @pk_616_5960 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610lgid' LIMIT 1 );
SET @pk_616_5997 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615pjid' LIMIT 1 );
SET @pk_616_5998 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615mileid' LIMIT 1 );
SET @pk_616_10727 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3435typeid' LIMIT 1 );
SET @pk_616_10728 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436typeid' LIMIT 1 );
SET @pk_616_10729 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436lgid' LIMIT 1 );
SET @pk_616_10734 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey3435' LIMIT 1 );
SET @pk_616_10778 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3441commentid' LIMIT 1 );
SET @pk_616_81 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' 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_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_5532 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1 );
SET @pk_616_5954 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609mileid' LIMIT 1 );
SET @pk_616_6095 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='624curid' LIMIT 1 );
SET @pk_616_10708 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3434taskid' LIMIT 1 );
SET @pk_616_10759 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3439checktaskid' 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_5616 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1 );
SET @pk_616_7404 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='curid232' LIMIT 1 );
SET @pk_616_8996 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='ctyid232' LIMIT 1 );
SET @pk_616_10245 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='filid232' LIMIT 1 );
SET @pk_616_10735 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid3435' LIMIT 1 );
SET @pk_616_10736 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3435' LIMIT 1 );
SET @pk_616_10780 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3441' LIMIT 1 );
SET @pk_616_10784 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='taskid3441' LIMIT 1 );
SET @pk_616_10786 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checktaskid3441' 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_2476 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410name' LIMIT 1 );
SET @pk_616_2477 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410description' 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_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_5956 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609deadline' LIMIT 1 );
SET @pk_616_5957 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609startdate' LIMIT 1 );
SET @pk_616_5959 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610name' LIMIT 1 );
SET @pk_616_5961 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610description' LIMIT 1 );
SET @pk_616_6071 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609alias' 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_6818 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto410' LIMIT 1 );
SET @pk_616_6819 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid410' LIMIT 1 );
SET @pk_616_6876 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto610' LIMIT 1 );
SET @pk_616_6877 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid610' 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_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_7496 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='group405' 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_10123 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='mobile232' LIMIT 1 );
SET @pk_616_10730 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name3436' LIMIT 1 );
SET @pk_616_10731 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description3436' LIMIT 1 );
SET @pk_616_10732 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='auto3436' LIMIT 1 );
SET @pk_616_10733 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='fromlgid3436' LIMIT 1 );
SET @pk_616_10737 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modifiedby3435' LIMIT 1 );
SET @pk_616_10738 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='core3435' LIMIT 1 );
SET @pk_616_10739 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish3435' LIMIT 1 );
SET @pk_616_10740 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='created3435' LIMIT 1 );
SET @pk_616_10741 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified3435' LIMIT 1 );
SET @pk_616_10742 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='alias3435' LIMIT 1 );
SET @pk_616_10743 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='designation3435' LIMIT 1 );
SET @pk_616_10752 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='premium3435' LIMIT 1 );
SET @pk_616_10779 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description_comment3441' LIMIT 1 );
SET @pk_616_10781 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='publish3441' LIMIT 1 );
SET @pk_616_10782 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='modified3441' 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 );
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_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_2476,@dbtid_3,'name','0','0','14','0','1','','3','1',@rolid_0,'0','100','1','410name','1','0','0'),(@pk_616_2477,@dbtid_3,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','410description','1','0','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_4,'role','0','0','1','1','1','0','4','1',@rolid_0,'0','0','1','526role','1','0','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_5956,@dbtid_13,'deadline','0','0','4','1','1','0','2','1',@rolid_0,'0','0','1','609deadline','1','0','0'),(@pk_616_5957,@dbtid_13,'startdate','0','0','4','1','1','0','3','1',@rolid_0,'0','0','1','609startdate','1','0','0'),(@pk_616_5959,@dbtid_6,'name','0','0','14','0','1','','3','1',@rolid_0,'0','20','1','610name','1','0','0'),(@pk_616_5961,@dbtid_6,'description','0','0','16','0','1','','4','1',@rolid_0,'0','0','1','610description','1','0','0'),(@pk_616_6071,@dbtid_13,'alias','0','0','14','0','1','','4','1',@rolid_0,'0','50','1','609alias','1','0','0'),(@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_4,'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_6818,@dbtid_3,'auto','0','0','1','0','1','2','99','0','0','0','0','0','auto410','1','0','0'),(@pk_616_6819,@dbtid_3,'fromlgid','0','0','1','1','1','0','99','0','0','0','0','0','fromlgid410','1','0','0'),(@pk_616_6876,@dbtid_6,'auto','0','0','1','0','1','2','6','0','0','0','0','0','auto610','1','0','0'),(@pk_616_6877,@dbtid_6,'fromlgid','0','0','1','1','1','0','5','0','0','0','0','0','fromlgid610','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_7393,@dbtid_4,'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_7496,@dbtid_2,'group','0','1','1','1','1','5','26','0','0','0','0','1','group405','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_10123,@dbtid_1,'mobile','0','1','14','0','1','','24','0','0','0','20','0','mobile232','1','0','0'),(@pk_616_10730,@dbtid_9,'name','0','0','14','0','1','','3','0','0','0','255','1','name3436','1','0','0'),(@pk_616_10731,@dbtid_9,'description','0','0','16','0','1','','4','0','0','0','0','1','description3436','1','0','0'),(@pk_616_10732,@dbtid_9,'auto','0','0','1','0','1','2','5','0','0','0','0','1','auto3436','1','0','0'),(@pk_616_10733,@dbtid_9,'fromlgid','0','0','1','1','0','2','6','0','0','0','0','1','fromlgid3436','1','0','0'),(@pk_616_10737,@dbtid_8,'modifiedby','0','1','4','1','1','0','5','0','0','0','0','1','modifiedby3435','1','0','0'),(@pk_616_10738,@dbtid_8,'core','0','1','25','0','1','0','6','0','0','0','0','1','core3435','1','0','0'),(@pk_616_10739,@dbtid_8,'publish','0','1','1','0','1','0','9','0','0','0','0','1','publish3435','1','0','0'),(@pk_616_10740,@dbtid_8,'created','0','1','4','1','1','0','8','0','0','0','0','1','created3435','1','1','0');
REPLACE INTO `#__dataset_columns` (`dbcid`,`dbtid`,`name`,`pkey`,`checkval`,`type`,`attributes`,`mandatory`,`default`,`ordering`,`level`,`rolid`,`extra`,`size`,`export`,`namekey`,`core`,`columntype`,`noaudit`) VALUES (@pk_616_10741,@dbtid_8,'modified','0','1','4','1','1','0','7','0','0','0','0','1','modified3435','1','1','0'),(@pk_616_10742,@dbtid_8,'alias','0','1','14','0','1','','10','0','0','0','100','1','alias3435','1','0','0'),(@pk_616_10743,@dbtid_8,'designation','0','1','1','1','1','0','11','0','0','0','0','1','designation3435','1','0','0'),(@pk_616_10752,@dbtid_8,'premium','0','1','25','0','1','0','12','0','0','0','0','1','premium3435','1','0','0'),(@pk_616_10779,@dbtid_10,'description_comment','0','1','16','0','1','','5','0','0','0','0','1','description_comment3441','1','0','0'),(@pk_616_10781,@dbtid_10,'publish','0','0','1','0','1','0','3','0','0','0','0','1','publish3441','1','0','0'),(@pk_616_10782,@dbtid_10,'modified','0','1','4','1','1','0','2','0','0','0','0','1','modified3441','1','1','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');
SET @pk_5_245 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='project.node' LIMIT 1 );
UPDATE `#__extension_node`  SET `publish`='1',`folder`='project',`wid`=@pk_5_245,`params`='',`status`='1',`type`='150',`name`='Project',`destination`='node',`parent`='0',`trans`='1',`certify`='1',`namekey`='project.node',`version`='1354',`lversion`='1354',`pref`='0',`install`='',`core`='1',`showconfig`='1',`framework`='0' WHERE  `namekey`='project.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','project',@pk_5_245,'','1','150','Project','node','0','1','1','project.node','1354','1354','0','','1','1','0');

SET @rolid_14 = (3);
SET @pk_621_405 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project' LIMIT 1 );
SET @pk_621_531 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket.project' LIMIT 1 );
SET @pk_621_532 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='ticket' LIMIT 1 );
SET @pk_621_1015 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1 );
SET @pk_621_410 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='projecttrans' LIMIT 1 );
SET @pk_621_526 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.members' LIMIT 1 );
SET @pk_621_543 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.extension' LIMIT 1 );
SET @pk_621_609 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestone' LIMIT 1 );
SET @pk_621_610 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestonetrans' LIMIT 1 );
SET @pk_621_615 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestones' LIMIT 1 );
SET @pk_621_1351 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.type' LIMIT 1 );
SET @pk_621_1354 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.typetrans' LIMIT 1 );
SET @pk_621_1369 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project-task-comments' LIMIT 1 );
SET @pk_621_1370 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='projects.comments' LIMIT 1 );
SET @pk_621_1340 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='todo' LIMIT 1 );
SET @pk_621_1356 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='todo.type' LIMIT 1 );
SET @pk_621_5 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='extension' LIMIT 1 );
SET @pk_621_566 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='role' LIMIT 1 );
SET @pk_621_1016 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users.role' LIMIT 1 );
UPDATE `#__model_node`  SET `sid`=@pk_621_405,`dbtid`=@dbtid_2,`path`='0',`namekey`='project',`folder`='project',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\ngrpmap=parent\nprtname=projecttrans\nautofld=1',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='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_405,@dbtid_2,'0','project','project',@rolid_0,'0','1','0','0','ordrg=1\ngrpmap=parent\nprtname=projecttrans\nautofld=1','','project','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_532,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.node' LIMIT 1),`path`='1',`namekey`='ticket',`folder`='ticket',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\nautofld=1',`alias`='',`prefix`='ticket',`fields`='1',`trash`='0',`core`='1',`faicon`='fa-ticket',`pnamekey`='' WHERE  `namekey`='ticket';
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_532,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='ticket.node' LIMIT 1),'1','ticket','ticket',@rolid_0,'0','1','0','0','ordrg=1\nautofld=1','','ticket','1','0','1','fa-ticket','');
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_410,`dbtid`=@dbtid_3,`path`='0',`namekey`='projecttrans',`folder`='projecttrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='\nmainmodel=project',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='projecttrans';
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_410,@dbtid_3,'0','projecttrans','projecttrans',@rolid_0,'0','1','0','0','\nmainmodel=project','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_526,`dbtid`=@dbtid_4,`path`='1',`namekey`='project.members',`folder`='project.members',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.members';
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_526,@dbtid_4,'1','project.members','project.members',@rolid_0,'0','1','0','0','autofld=1','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_543,`dbtid`=@dbtid_5,`path`='1',`namekey`='project.extension',`folder`='project.extension',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.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_543,@dbtid_5,'1','project.extension','project.extension',@rolid_0,'0','1','0','0','','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_609,`dbtid`=@dbtid_13,`path`='0',`namekey`='project.milestone',`folder`='milestone',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='validtoggle=1',`alias`='',`prefix`='milestone',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.milestone';
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_609,@dbtid_13,'0','project.milestone','milestone',@rolid_0,'0','1','0','0','validtoggle=1','','milestone','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_610,`dbtid`=@dbtid_6,`path`='0',`namekey`='project.milestonetrans',`folder`='milestonetrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='mainmodel=milestone',`alias`='',`prefix`='milestone',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.milestonetrans';
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_610,@dbtid_6,'0','project.milestonetrans','milestonetrans',@rolid_0,'0','1','0','0','mainmodel=milestone','','milestone','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_615,`dbtid`=@dbtid_7,`path`='0',`namekey`='project.milestones',`folder`='project.milestones',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.milestones';
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_615,@dbtid_7,'0','project.milestones','project.milestones',@rolid_0,'0','1','0','0','','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1351,`dbtid`=@dbtid_8,`path`='0',`namekey`='project.type',`folder`='project.type',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.type';
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_1351,@dbtid_8,'0','project.type','project.type',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1354,`dbtid`=@dbtid_9,`path`='0',`namekey`='project.typetrans',`folder`='project.typetrans',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='project',`fields`='0',`trash`='0',`core`='1',`faicon`='',`pnamekey`='' WHERE  `namekey`='project.typetrans';
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_1354,@dbtid_9,'0','project.typetrans','project.typetrans',@rolid_0,'0','1','0','0','autofld=1','','project','0','0','1','','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1369,`dbtid`=@dbtid_10,`path`='0',`namekey`='project-task-comments',`folder`='project-task-comments',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='project-task-comments',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comments',`pnamekey`='' WHERE  `namekey`='project-task-comments';
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_1369,@dbtid_10,'0','project-task-comments','project-task-comments',@rolid_0,'0','1','0','0','autofld=1','','project-task-comments','0','0','1','fa-comments','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1370,`dbtid`=@dbtid_10,`path`='0',`namekey`='projects.comments',`folder`='projects.comments',`rolid`=@rolid_14,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='autofld=1',`alias`='',`prefix`='project comments',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-comments',`pnamekey`='' WHERE  `namekey`='projects.comments';
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_1370,@dbtid_10,'0','projects.comments','projects.comments',@rolid_14,'0','1','0','0','autofld=1','','project comments','0','0','1','fa-comments','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1340,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.node' LIMIT 1),`path`='1',`namekey`='todo',`folder`='todo',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='ordrg=1\nautofld=1',`alias`='',`prefix`='todo',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-calendar',`pnamekey`='' WHERE  `namekey`='todo';
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_1340,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.node' LIMIT 1),'1','todo','todo',@rolid_0,'0','1','0','0','ordrg=1\nautofld=1','','todo','0','0','1','fa-calendar','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1356,`dbtid`=@dbtid_8,`path`='0',`namekey`='todo.type',`folder`='todo.type',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='cachedata=1\nautofld=1',`alias`='',`prefix`='todo_type',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-th',`pnamekey`='' WHERE  `namekey`='todo.type';
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_1356,@dbtid_8,'0','todo.type','todo.type',@rolid_0,'0','1','0','0','cachedata=1\nautofld=1','','todo_type','0','0','1','fa-th','');
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_566,`dbtid`=@dbtid_12,`path`='1',`namekey`='role',`folder`='role',`rolid`=@rolid_0,`level`='0',`publish`='1',`extended`='0',`checkval`='0',`params`='prtname=roletrans\ncachedata=1',`alias`='',`prefix`='role',`fields`='0',`trash`='0',`core`='1',`faicon`='fa-trophy',`pnamekey`='' WHERE  `namekey`='role';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_566,@dbtid_12,'1','role','role',@rolid_0,'0','1','0','0','prtname=roletrans\ncachedata=1','','role','0','0','1','fa-trophy','');
UPDATE `#__model_node`  SET `sid`=@pk_621_1016,`dbtid`=( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1),`path`='0',`namekey`='users.role',`folder`='users.role',`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-trophy',`pnamekey`='' WHERE  `namekey`='users.role';
INSERT IGNORE INTO `#__model_node` (`sid`,`dbtid`,`path`,`namekey`,`folder`,`rolid`,`level`,`publish`,`extended`,`checkval`,`params`,`alias`,`prefix`,`fields`,`trash`,`core`,`faicon`,`pnamekey`) VALUES (@pk_621_1016,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='role.members' LIMIT 1),'0','users.role','users.role',@rolid_0,'0','1','0','0','autofld=1','','users','0','0','1','fa-trophy','');

SET @wid_15 = ( SELECT `wid` FROM `#__extension_node`  WHERE `namekey`='project.node' LIMIT 1);
SET @sid_16 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project' LIMIT 1);
SET @sid_17 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1);
SET @sid_18 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.members' LIMIT 1);
SET @rolid_19 = (7);
SET @ref_sid_20 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='projecttrans' LIMIT 1);
SET @sid_21 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.extension' LIMIT 1);
SET @sid_22 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestone' LIMIT 1);
SET @sid_23 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='todo' LIMIT 1);
SET @sid_24 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='todo.type' LIMIT 1);
SET @rolid_25 = (52);
SET @rolid_26 = (51);
SET @yid_27 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_form' LIMIT 1);
SET @yid_28 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_show' LIMIT 1);
SET @yid_29 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_milestone_form' LIMIT 1);
SET @yid_30 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_preferences_form' LIMIT 1);
SET @yid_31 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='projectmembers_form' LIMIT 1);
SET @yid_32 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='projectmilestones_form' LIMIT 1);
SET @yid_33 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='projecteditmilestone_form' LIMIT 1);
SET @yid_34 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_category_form' LIMIT 1);
SET @yid_35 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_form_project' LIMIT 1);
SET @yid_36 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_show_project' LIMIT 1);
SET @yid_37 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_form_type' LIMIT 1);
SET @did_38 = ( SELECT `did` FROM `#__dropset_node`  WHERE `namekey`='project_priority' LIMIT 1);
SET @sid_39 = ( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestonetrans' LIMIT 1);
SET @ref_yid_40 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='projectshow_listing' LIMIT 1);
SET @ref_yid_41 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='projectlistmilestones_listing' LIMIT 1);
SET @p_1_0 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='project_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_0 WHERE `namekey` IN ('project_form_projecttrans_name','project_form_projecttrans_description','project_form_project_parent') LIMIT 3;
SET @p_1_1 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='project_form_details' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_1 WHERE `namekey` IN ('project_form_project_startdate','project_form_project_enddate','project_form_project_priority') LIMIT 3;
SET @p_1_2 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projects_show_sub-projects' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_2 WHERE `namekey` IN ('projects_show_pjid') LIMIT 1;
SET @p_1_3 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projects_show_milestones' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_3 WHERE `namekey` IN ('projects_show_mileid') LIMIT 1;
SET @p_1_4 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projectpreferences_form_email' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_4 WHERE `namekey` IN ('projectpreferences_form_task_node_footer','projectpreferences_form_task_node_projectname','projectpreferences_form_task_node_link') LIMIT 3;
SET @p_1_5 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projectpreferences_form_task' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_5 WHERE `namekey` IN ('projectpreferences_form_task_node_completed','projectpreferences_form_task_node_daystart') LIMIT 2;
SET @p_1_6 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projectmilestone_form_general' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_6 WHERE `namekey` IN ('projectmilestone_form_projecttrans_name','projectmilestone_form_projecttrans_description','projectmilestone_form_project_parent') LIMIT 3;
SET @p_1_7 = ( SELECT  A.`fid`  FROM `#__layout_multiforms`  AS A  WHERE  A.`namekey` ='projectmilestone_form_details' LIMIT 1);
UPDATE `#__layout_multiforms` SET `parent`=@p_1_7 WHERE `namekey` IN ('projectmilestone_form_project_startdate','projectmilestone_form_project_enddate','projectmilestone_form_project_priority') LIMIT 3;
SET @yid_42 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_listing' LIMIT 1);
SET @yid_43 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_category_listing' LIMIT 1);
SET @yid_44 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_members_listing_project_members' LIMIT 1);
SET @yid_45 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_listing_project' LIMIT 1);
SET @yid_46 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='project_listing_type' LIMIT 1);
SET @yid_47 = ( SELECT `yid` FROM `#__layout_node`  WHERE `namekey`='myprojects_listing' LIMIT 1);
SET @p_3_0 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='project_listing_projecttrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_0 WHERE `namekey` IN ('project_listing_projecttrans_description') LIMIT 1;
SET @p_3_1 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='project_listing_project_estimatedtime' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_1 WHERE `namekey` IN ('project_listing_project_pjid') LIMIT 1;
SET @p_3_2 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='myprojects_listing_projecttrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_2 WHERE `namekey` IN ('myprojects_listing_projecttrans_description') LIMIT 1;
SET @p_3_3 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='projectlistmilestones_listing_milestonetrans_name' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_3 WHERE `namekey` IN ('projectlistmilestones_listing_milestonetrans_description') LIMIT 1;
SET @p_3_4 = ( SELECT  A.`lid`  FROM `#__layout_listings`  AS A  WHERE  A.`namekey` ='2mxno3z726' LIMIT 1);
UPDATE `#__layout_listings` SET `parent`=@p_3_4 WHERE `namekey` IN ('2mxno3z727') LIMIT 1;
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('New','1','1206732361LXFD');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Edit','1','1206732361LXFE'),('Order by','1','1206732366OVLX'),('Start','1','1206732366OVMC'),('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'),('Extension','1','1206732400OWXH'),('General','1','1206732400OWZR'),('Category','1','1206732411EGQO'),('Categories','1','1206732411EGQQ'),('Members','1','1206732411EGQR'),('Member','1','1206732411EGRG'),('divider','1','1206732411EGRN'),('Email','1','1206732411EGRU'),('Created','1','1206732411EGRY'),('Parent','1','1206732412DAEM'),('Access','1','1206732412DAEO'),('Namekey','1','1206732420EIUV'),('Task','1','1206732425HINS'),('Top','1','1206732429GMSU'),('Modified','1','1206961850KLRL'),('hidden','1','1206961869IGND'),('Core','1','1206961869IGNE'),('Link','1','1206961869IGNO'),('Priority','1','1206961898PIOD'),('Uid','1','1206961899DDKS'),('Comments','1','1206961912MJQH'),('Details','1','1206961936HCWR'),('Projects','1','1206964235BPWK'),('Project','1','1206964390BUEL'),('Navigate','1','1209123607OCSQ'),('Role','1','1209142268NMKA'),('My Projects','1','1209674941LKQN'),('The deadline you entered is smaller than the submission date.','1','1209674941LKQQ'),('You can NOT delete this project because there is still sub-project attached to it.  You need first remove the sub-projects','1','1209674941LKQR'),('The project was assigned successfully','1','1209674941LKQS'),('Error assigning the poject','1','1209674941LKQT'),('The project was linked successfully','1','1209674941LKQU'),('Error linking the poject','1','1209674941LKQV'),('Project Information','1','1209674942SVHA'),('Show of projects','1','1209674942SVHC'),('Deadline','1','1209674948GCLT'),('Manager','1','1211280059QYRN'),('Alias','1','1211811583DBTA'),('hour','1','1215507788CYDE'),('hours','1','1215507788CYDF'),('Assign a project','1','1215507791FLOP'),('Project Preferences','1','1215507791FLOR'),('Milestone','1','1215507791FLOS'),('Link a project to an extension','1','1215507791FLOT'),('Gantt Chart','1','1215507791FLOV'),('Project name','1','1215507792MTRI'),('Go to tasks','1','1215507792MTRJ'),('Creator','1','1215507792MTRK'),('Start date','1','1215507792MTRL'),('End date','1','1215507792MTRM'),('Estimated time','1','1215507792MTRN'),('Estmated time overlay','1','1215507792MTRO'),('Info','1','1215507792MTRQ'),('Briefly describe the project','1','1215507792MTRR'),('Milestones','1','1215507793BYPA'),('Footer that appears at the bottom of all notification emails.<br />You can leave this empty','1','1215507793BYPN'),('Footer','1','1215507793BYPO'),('Display button to switch between all tasks and uncompleted tasks','1','1215507793BYPP'),('All Tasks button','1','1215507793BYPQ'),('Parent project','1','1215507793BYPR'),('Define milestones','1','1215534704HYBB'),('Add a link to the task at the end of notification','1','1225790125DKPF'),('Specify here when days start: 0 for midnight, 8 for 8am, 16 for 4pm...<br />This is used for ordering the tasks','1','1225790126CCSE'),('Sub-projects','1','1225790126CCSH'),('List of Sub-projects','1','1225790126CCSI'),('List of milestones','1','1225790126CCSK'),('Beginning of the day','1','1225790126CCSM'),('Go to show','1','1225790126CCSQ'),('Sub-project','1','1225790126CCSS'),('List of sub-projects on project show','1','1225790126CCSV'),('List of milestones on project show','1','1225790126CCSX'),('Edit milestone','1','1225790126CCSY'),('You can only add milestones to the parent project','1','1227581089KZZR'),('Please at least specify a name','1','1227581089KZZS'),('The milestone \'$milestone_name\' was added to the project','1','1227581089KZZT'),('An error occured. The milestone was not saved','1','1227581089KZZU'),('View the project at:','1','1227581091HODI'),('Close','1','1228820287MBVC'),('Users','1','1229653442FEQZ'),('Display the project name in the footer of notification emails','1','1230530145JEDZ'),('Notify','1','1241519400RGCB'),('Done','1','1242282449PIPC'),('Designation','1','1298350871NSPY'),('','1','1304525968YBL'),('Modifiedby','1','1310007858PLWN'),('Rolid','1','1347652452OQAE'),('See tasks','1','1373210705CJYY');
INSERT IGNORE INTO `#__translation_en` (`text`,`auto`,`imac`) VALUES ('Project memberss','1','1373210706DUJF'),('This page brings together any kind of information regarding projects:<br><ul><li>Click on the name of the member to view all the tasks he was assigned.</li><li>You can consult / edit tasks and projects through this page.</li></ul>','1','1373210706DUJG'),('Project identifier','1','1398536237MPCY'),('Topicid','1','1409868370RQTH'),('Typeid','1','1409868370RQTI'),('Copyall','1','1409868370RQTJ'),('Deleteall','1','1409868370RQTK'),('Todos','1','1409868370RQTL'),('Todo','1','1409868370RQTM'),('Todo types','1','1409868370RQTN'),('Todo type','1','1409868370RQTO'),('Project comments','1','1411052381LDFX');
SET @dbcid_48 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232uid' 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_48);
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`='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_projecttrans_pjid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410pjid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_projecttrans_pjid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410lgid' 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`='PK_project_extension_pjid_wid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543pjid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_extension_pjid_wid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543wid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_milestonetrans_mileid_lgid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610mileid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_milestonetrans_mileid_lgid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_milestones_pjid_mileid' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615pjid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_project_milestones_pjid_mileid' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615mileid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_type|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3435typeid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_type_trans|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436typeid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_type_trans|main_userdata' LIMIT 1),'2','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436lgid' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='UK_namekey_jos_topic_type' LIMIT 1),'5','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='namekey3435' LIMIT 1)),(( SELECT `ctid` FROM `#__dataset_constraints`  WHERE `namekey`='PK_jos_topic_task_comment|main_userdata' LIMIT 1),'1','0',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3441commentid' LIMIT 1));
SET @ref_feid_49 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='199lgid' LIMIT 1);
SET @ref_feid_50 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405pjid' LIMIT 1);
SET @pk_77_353 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232lgid\' 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_10405 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_2 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'405rolid\' 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_473 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'410pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_472 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_3 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'410lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10013 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_4 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_4 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'526uid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10043 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'543pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10044 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_5 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'extension.node\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'543wid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10372 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_1 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'232rolid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10512 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_13 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'610mileid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10511 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_6 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'610lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10513 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_2 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'615pjid\' LIMIT 1' LIMIT 1 );
SET @pk_77_10514 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_7 AND `ref_dbtid`=@dbtid_13 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'615mileid\' 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_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_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 );
SET @pk_77_11447 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_8 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3436typeid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11448 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_9 AND `ref_dbtid`=@dbtid_11 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'3436lgid\' LIMIT 1' LIMIT 1 );
SET @pk_77_11444 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_12 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'rolid3435\' LIMIT 1' LIMIT 1 );
SET @pk_77_11445 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_8 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid3435\' LIMIT 1' LIMIT 1 );
SET @pk_77_11462 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=@dbtid_1 AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'uid3441\' LIMIT 1' LIMIT 1 );
SET @pk_77_11463 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'topic.task\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'taskid3441\' LIMIT 1' LIMIT 1 );
SET @pk_77_11464 = ( SELECT `fkid` FROM `#__dataset_foreign`  WHERE `dbtid`=@dbtid_10 AND `ref_dbtid`=' SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`=\'topic.checklist.task\' LIMIT 1' AND `feid`=' SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`=\'checktaskid3441\' 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),@ref_feid_49,'1','1','lgid',@dbtid_11,@dbtid_1,'3');
REPLACE INTO `#__dataset_foreign` (`map`,`publish`,`namekey`,`fkid`,`feid`,`ref_feid`,`onupdate`,`ondelete`,`map2`,`ref_dbtid`,`dbtid`,`ordering`) VALUES ('parent','1','FK_Parent405_parentpjid',@pk_77_10580,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405parent' LIMIT 1),@ref_feid_50,'1','1','pjid',@dbtid_2,( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='project.node' LIMIT 1),'99'),('rolid','1','FK_project_rolid',@pk_77_10405,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','',@dbtid_12,@dbtid_2,'99'),('uid','1','FK_405_uid_uid',@pk_77_464,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='405uid' LIMIT 1),@dbcid_48,'1','1','uid',@dbtid_1,@dbtid_2,'99'),('pjid','1','FK_410_pjid_pjid',@pk_77_473,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410pjid' LIMIT 1),@ref_feid_50,'1','1','pjid',@dbtid_2,@dbtid_3,'99'),('lgid','1','FK_410_lgid_lgid',@pk_77_472,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410lgid' LIMIT 1),@ref_feid_49,'1','1','lgid',@dbtid_11,@dbtid_3,'99'),('pjid','1','FK_projectmembers_pjid',@pk_77_10013,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526pjid' LIMIT 1),@ref_feid_50,'3','3','pjid',@dbtid_2,@dbtid_4,'1'),('uid','1','FK_projectmembers_uid',@pk_77_10014,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='526uid' LIMIT 1),@dbcid_48,'3','3','uid',@dbtid_1,@dbtid_4,'2'),('pjid','1','FK_project_extension_pjid',@pk_77_10043,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543pjid' LIMIT 1),@ref_feid_50,'3','3','pjid',@dbtid_2,@dbtid_5,'99'),('wid','1','FK_project_extension_wid',@pk_77_10044,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='543wid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='5wid' LIMIT 1),'3','3','wid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='extension.node' LIMIT 1),@dbtid_5,'99'),('rolid','1','FK_members_rolid',@pk_77_10372,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='232rolid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','',@dbtid_12,@dbtid_1,'2'),('mileid','1','FK_milestonetrans_mileid',@pk_77_10512,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610mileid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609mileid' LIMIT 1),'3','3','',@dbtid_13,@dbtid_6,'99'),('lgid','1','FK_milestonetrans_lgid',@pk_77_10511,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610lgid' LIMIT 1),@ref_feid_49,'1','3','',@dbtid_11,@dbtid_6,'99'),('pjid','1','FK_project.milestones_pjid',@pk_77_10513,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615pjid' LIMIT 1),@ref_feid_50,'3','3','',@dbtid_2,@dbtid_7,'99'),('mileid','1','FK_project.milestones_mileid',@pk_77_10514,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='615mileid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='609mileid' LIMIT 1),'3','3','',@dbtid_13,@dbtid_7,'99'),('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'),('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'),('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'),('typeid','1','FK_topic_type_typeid',@pk_77_11447,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436typeid' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3435typeid' LIMIT 1),'3','3','typeid',@dbtid_8,@dbtid_9,'1'),('lgid','1','FK_topic_type_lgid',@pk_77_11448,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3436lgid' LIMIT 1),@ref_feid_49,'3','3','lgid',@dbtid_11,@dbtid_9,'2'),('rolid','1','FK_topic_type_rolid',@pk_77_11444,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='rolid3435' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='566rolid' LIMIT 1),'1','1','rolid',@dbtid_12,@dbtid_8,'2'),('uid','1','FK_topic_type_uid',@pk_77_11445,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3435' LIMIT 1),@dbcid_48,'1','1','uid',@dbtid_1,@dbtid_8,'1'),('uid','1','FK_topic_task_comment_uid',@pk_77_11462,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='uid3441' LIMIT 1),@dbcid_48,'1','1','uid',@dbtid_1,@dbtid_10,'3'),('taskid','1','FK_topic_task_comment_taskid',@pk_77_11463,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='taskid3441' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3434taskid' LIMIT 1),'3','3','taskid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.task' LIMIT 1),@dbtid_10,'2'),('checktaskid','1','FK_topic_task_comment_checktaskid',@pk_77_11464,( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='checktaskid3441' LIMIT 1),( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='3439checktaskid' LIMIT 1),'3','3','checktaskid',( SELECT `dbtid` FROM `#__dataset_tables`  WHERE `namekey`='topic.checklist.task' LIMIT 1),@dbtid_10,'1');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_15,'1','1206732429GMSU');
INSERT IGNORE INTO `#__translation_reference` (`wid`,`load`,`imac`) VALUES (@wid_15,'0','1209674941LKQQ'),(@wid_15,'0','1209674941LKQR'),(@wid_15,'1','1209674941LKQS'),(@wid_15,'1','1209674941LKQT'),(@wid_15,'1','1209674941LKQU'),(@wid_15,'1','1209674941LKQV'),(@wid_15,'1','1215507788CYDE'),(@wid_15,'1','1215507788CYDF'),(@wid_15,'0','1227581089KZZR'),(@wid_15,'0','1227581089KZZS'),(@wid_15,'0','1227581089KZZT'),(@wid_15,'0','1227581089KZZU'),(@wid_15,'1','1227581091HODI');
SET @dbcid_51 = ( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='618name' LIMIT 1);
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410description' LIMIT 1));
INSERT IGNORE INTO `#__translation_populate` (`wid`,`eid`,`imac`,`dbcid`) VALUES (@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='410name' LIMIT 1)),(@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610description' LIMIT 1)),(@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='610name' LIMIT 1)),(@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='description3436' LIMIT 1)),(@wid_15,'0','',( SELECT `dbcid` FROM `#__dataset_columns`  WHERE `namekey`='name3436' LIMIT 1)),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project' LIMIT 1),'1206964390BUEL',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='projecttrans' LIMIT 1),'1206964390BUEL',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.members' LIMIT 1),'1206964390BUEL',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.extension' LIMIT 1),'1304525968YBL',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestone' LIMIT 1),'1215507791FLOS',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestonetrans' LIMIT 1),'1215507791FLOS',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.milestones' LIMIT 1),'1206964390BUEL',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='users' LIMIT 1),'1229653442FEQZ',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.type' LIMIT 1),'1206732392OZVD',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project.typetrans' LIMIT 1),'1206732392OZVD',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='project-task-comments' LIMIT 1),'1411052381LDFX',@dbcid_51),(@wid_15,( SELECT `sid` FROM `#__model_node`  WHERE `namekey`='projects.comments' LIMIT 1),'1206961912MJQH',@dbcid_51);