移植流程图的数据库

a.移植工作流b.移植“角色”当遇到插不进去时，删去对于的字段。processrev=4 想要倒的流程图的版本号app=DXMADD 修改为相应的应用程序名字select MAXROLE, DESCRIPTION, ISEMAILDATASET, PARAMETER, ISBROADCAST, OBJECTNAME,MAXROLEseq.nextval MAXROLEID, TYPE, VALUE, LANGCODE, HASLD, SENDERSYSID from maxrole where MAXROLE in(select distinct roleid from WFASSIGNMENT where app=DXMADD and recordkey is null and processrev=4)方法：首先执行上面语句，查出结果，如图导出 SQL 语句，导出结果如下：当执行插入到新的数据库中时，记得去掉 MAXROLEseq.nextval左右的单引号c.移植“操作”select ACTIONseq.nextval ACTIONID, ACTION, DESCRIPTION, OBJECTNAME, TYPE, VALUE, PARAMETER, LANGCODE, MEMO, USEWITH, HASLD, SENDERSYSID, VALUE2from action where action in(select distinct action from WFACTION where processNAME =DXMADD and processrev=4)d.移植操作角色相对应的“人员组” ，及“人员组中的人” 。1-用下面的句子导出人员组。select PERSONGROUPseq.nextval PERSONGROUPID, PERSONGROUP, DESCRIPTION, LANGCODE, HASLD from persongroup where persongroup in (select value from maxrole where MAXROLE in(select distinct roleid from WFASSIGNMENT where app=DXMADD and recordkey is null and processrev=4)2-用下面的句子导出人员组中的人员。select RESPPARTYGROUP, RESPPARTY, RESPPARTYGROUPSEQ,RESPPARTYSEQ, USEFORORG, USEFORSITE, GROUPDEFAULT, ORGDEFAULT, SITEDEFAULT,PERSONGROUPTEAMseq.nextval PERSONGROUPTEAMID, PERSONGROUPfrom Persongroupteam where PERSONGROUP in (select PERSONGROUP from persongroup where persongroup in (select value from maxrole where MAXROLE in(select distinct roleid fr