#在E9中删除，并按照E7创建出符合规则的表，%号为通配符
e9_dropandcreatetables=FORMTABLE_MAIN_%,MODEDATASHARE_%,MATRIXTABLE_%,UF_%,WORKFLOW_FORM,WORKFLOW_FORMDETAIL,CUS_FIELDDATA,CTRIP_%,WX_%,MODEVIEWLOG_%,HRMSUBCOMPANYDEFINED,HRMDEPARTMENTDEFINED
#按照e9_dropandcreatetables规则匹配后单独排除的表，该属性值不支持%通配符
e9_dropandcreatetables_exclude=UF_REPLY
#排除的表（在该参数中的表，E9中不会做清空操作）
e9_excludetables=MOBILESYNCINFO,WORKFLOW_BROWDEF_SELITEMCONF,WORKFLOW_BROWDEF_FIELDCONF,HRMROLES,SYSTEMRIGHTROLES,SYSTEMRIGHTS,SYSTEMRIGHTDETAIL,HRMROLEMEMBERS,SYSROLESUBCOMRIGHT,SYSTEMRIGHTTOGROUP,SYSTEMRIGHTSLANGUAGE,EXTANDHPTHEME,EXTANDHPTHEMEITEM,EXTENDHOMEPAGE,EXTENDHPWEB1,EXTENDHPWEBCUSTOM,HOMEPAGEDESIGN,HPAREAELEMENT,HPBASEELEMENT,HPBASELAYOUT,HPCURRENTTAB,HPCURRENTUSE,HPELEMENT,HPELEMENTIMG,HPELEMENTSETTING,HPELEMENTSETTINGDETAIL,HPEXTELEMENT,HPFIELDELEMENT,HPFIELDLENGTH,HPINFO,HPLAYOUT,HPMENUSTYLE,HPNEWSTABINFO,HPREPORTFORMTYPE,HPSETTING_WFCENTER,HPSQLELEMENT,HPSTYLE,HPUSERSELECT,HPWHEREELEMENT,LEFTMENUCONFIG,LEFTMENUINFO,MAINMENUCONFIG,MAINMENUINFO,MAINTINNERHP,MENUCENTER,MENUCONTROLLIST,MENUCUSTOM,MENUSHAREINFO,PAGELAYOUT,PAGENEWSTEMPLATE,PAGENEWSTEMPLATELAYOUT,PAGETEMPLATE,PAGEUSERDEFAULT,PICTURE,SCRATCHPAD,SHAREINNERHP,SYSFAVOURITE,SYSFAVOURITE_FAVOURITE,SYSTEMLOGINTEMPLATE,WEATHERELEMENT,WORKFLOWCENTERSETTINGDETAIL,LICENSE,HTMLNOTEINFO,DBUPGRADEMAIN,DBUPGRADEDETAIL,DBUPGRADEACTION,DBUPGRADELOG,SYSTEMMODULE,AUTOCONFIGKEY,CLUSTERUPGRADELOG,UPGRADEFILETAG,ECOLOGYUPLIST,AUTOCONFIGLOG,MONITORGUIDELOG,UPGRADECHECKINFO,CONFIGPROPERTIESFILE,CONFIGXMLFILE,CONFIGFILEMANAGER,CLUSTERUPGRADEINFO,SQLCOUNTER,SQLFILELOGINFO,HRM_TRANSFER_LOG,HTMLLABELINDEX,HTMLLABELINFO,HRM_FORMFIELD,WORKFLOW_BROWSERURL,INT_CAS_EXCLUEURL_SYS,WF_BROWSER_CONFIG,INT_CAS_EXCLUEURL_SYS,HRM_TRANSFER_SET,SYSTEMLOGITEM,ACTIONSETTING,SCHEDULESETTING,DATASOURCESETTING,GP_INITTAG
#保留E9表数据，按照主键在E7、E8中删除一遍后，迁移E7、E8删除后剩余的数据到E9表中，该参数中的表需要同时放到e9_excludetables属性值中
clearduplicatedata_tables=WORKFLOW_BROWDEF_SELITEMCONF.CONFIGID,WORKFLOW_BROWDEF_FIELDCONF,HRMROLES,SYSTEMRIGHTROLES,SYSTEMRIGHTS,SYSTEMRIGHTDETAIL,HRMROLEMEMBERS,SYSROLESUBCOMRIGHT,SYSTEMRIGHTTOGROUP,SYSTEMRIGHTSLANGUAGE,HTMLLABELINDEX,HTMLLABELINFO,WORKFLOW_BROWSERURL,HRM_FORMFIELD.FIELDNAME,WF_BROWSER_CONFIG.TYPE,SYSTEMLOGITEM.ITEMID,ACTIONSETTING.ACTIONNAME,SCHEDULESETTING.POINTID,DATASOURCESETTING.POINTID
#联合主键检查，删除E7脏数据（E9中表存在联合主键索引，E7中不存在联合主键索引，会导致主键冲突而无法迁移，需要删除E7中冲突的脏数据）
e7_indexcheck=HRMANNUALMANAGEMENT,MAILCONTENT,WORKFLOW_CURRENTOPERATOR,DOCDETAILCONTENT
#E9中需要drop的表，属性值为程序运行时自动写入，无需关注
e9_droptables=
#E9中需要create的表，属性值为程序运行时自动写入，无需关注
e9_createtables=
#需要同步的表，属性值为程序运行时自动写入，无需关注
synctables=
#并将E7/E8的数据插入到E9中删除E7,E8中的数据，使用逗分隔每张表，使用%分隔,表名%迁移数据的字段名，
e7copydatatoe9table=ACTIONSETTING%ACTINNAME.ACTIONCLASS.ACTIONSHOWNAME.CREATEDATE.CREATETIME.MODIFYDATE.MODIFYTIME,SCHEDULESETTING%POINTID.CLASSPATH.CRONEXPR.CREATEDATE.CREATETIME.MODIFYDATE.MODIFYTIME.RUNSTATUS,DATASOURCESETTING%POINTID.CLASSPATH.TYPE.DATASOURCENAME.ISCLUSTER.TYPENAME.URL.HOST.PORT.DBNAME.USERNAME.PASSWORD.MINCONN.MAXCONN.ISCODE,HRM_FORMFIELD%FIELDDBTYPE.FIELDNAME.FIELDLABEL.FIELDHTMLTYPE.TYPE.FIELDORDER.ISMAND.ISUSE.GROUPID.ALLOWHIDE.DMLURL.ISSYSTEM.IMGWIDTH.IMGHEIGHT.TEXTHEIGHT%FIELDID
e9_closedtriggername=
filelist1=
filelist2=/filesystem/
filelist3=hrmsettings.xml
e9_exceptiontables=
checkxmlfilepath=/WEB-INF/web.xml,/WEB-INF/service/action.xml,/mobile/plugin/plugin.xml
e7_clobdealtables=MODE_PAGEEXPAND
e9_migrationcheckstataus=0