text: --Save Milestone
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'SaveMilestone','/milestone/milestone-save',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Save Milestone','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='SaveMilestone' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='SaveMilestone' and contextroot = 'egworks'));
  --View Milestone Template
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'ViewMilestoneTemplateDetails','/milestone/view',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'View Milestone Template','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='ViewMilestoneTemplateDetails' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='ViewMilestoneTemplateDetails' and contextroot = 'egworks'));
  --Create Milestone Form
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'CreateMilestoneForm','/milestone/newform',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Create Milestone Form','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='CreateMilestoneForm' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='CreateMilestoneForm' and contextroot = 'egworks'));
  --Ajax Search Milestone Template Code
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'AjaxSearchMilestoneTemplateCode','/milestone/ajaxmilestonetemplatecode-milestone',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Ajax Search Milestone Template Code','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='AjaxSearchMilestoneTemplateCode' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='AjaxSearchMilestoneTemplateCode' and contextroot = 'egworks'));
  --Search Milestone Template
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'SearchMilestoneTemplateDetails','/milestone/searchmilestonetemplate',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Search Milestone Template','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='SearchMilestoneTemplateDetails' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='SearchMilestoneTemplateDetails' and contextroot = 'egworks'));
  --Ajax Search Milestone Template
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'AjaxSearchMilestoneTemplate','/milestone/ajaxsearchmilestonetemplate',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Search Milestone Template','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='AjaxSearchMilestoneTemplate' and contextroot = 'egworks'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='AjaxSearchMilestoneTemplate' and contextroot = 'egworks'));
  --Populate Milestone  Template Activity
  Insert into EG_ACTION (ID,NAME,URL,QUERYPARAMS,PARENTMODULE,ORDERNUMBER,DISPLAYNAME,ENABLED,CONTEXTROOT,VERSION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,APPLICATION) values (NEXTVAL('SEQ_EG_ACTION'),'AddMilestoneTemplateActivity','/milestone/setmilestonetemplateactivities',null,(select id from EG_MODULE where name = 'WorksMilestone'),1,'Add Milestone Template Activity','false','egworks',0,1,now(),1,now(),(select id from eg_module  where name = 'Works Management'));
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Super User'),(select id from eg_action where name ='AddMilestoneTemplateActivity' and contextroot = 'egworks'));														
  Insert into eg_roleaction (roleid, actionid) values ((select id from eg_role where name = 'Works Administrator'),(select id from eg_action where name ='AddMilestoneTemplateActivity' and contextroot = 'egworks'));
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='AddMilestoneTemplateActivity' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='AddMilestoneTemplateActivity' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'AddMilestoneTemplateActivity' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='ViewMilestoneTemplateDetails' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='ViewMilestoneTemplateDetails' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'ViewMilestoneTemplateDetails' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='CreateMilestoneForm' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='CreateMilestoneForm' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'CreateMilestoneForm' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxSearchMilestoneTemplateCode' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxSearchMilestoneTemplateCode' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'AjaxSearchMilestoneTemplateCode' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='SearchMilestoneTemplateDetails' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='SearchMilestoneTemplateDetails' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'SearchMilestoneTemplateDetails' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxSearchMilestoneTemplate' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='AjaxSearchMilestoneTemplate' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'AjaxSearchMilestoneTemplate' and contextroot = 'egworks';
  
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Works Administrator') and actionid = (SELECT id FROM eg_action WHERE name ='SaveMilestone' and contextroot = 'egworks');
  --rollback delete FROM EG_ROLEACTION WHERE roleid = (SELECT id FROM eg_role WHERE name = 'Super User') and actionid = (SELECT id FROM eg_action WHERE name ='SaveMilestone' and contextroot = 'egworks');
  --rollback delete FROM EG_ACTION WHERE name = 'SaveMilestone' and contextroot = 'egworks';