You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
96 lines
2.1 KiB
Plaintext
96 lines
2.1 KiB
Plaintext
|
|
-- 删除组织结构.
|
|
DELETE Port_Emp WHERE UserID NOT IN ('admin','guest');
|
|
DELETE Port_Dept WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Port_Station WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Port_StationType WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Port_Team ;
|
|
DELETE Port_TeamEmp ;
|
|
DELETE Port_DeptEmp WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Port_DeptEmpStation WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Port_Org WHERE No NOT IN ('ccs');
|
|
DELETE Port_OrgAdminer WHERE OrgNo NOT IN ('ccs');
|
|
|
|
UPDATE Port_Emp set orgno='ccs' where no='ccs_admin';
|
|
|
|
-- 删除流程数据表单
|
|
DELETE WF_FlowSort WHERE OrgNo NOT IN ('ccs');
|
|
DELETE Sys_FormTree WHERE OrgNo NOT IN ('ccs');
|
|
|
|
DELETE Sys_MapData;
|
|
DELETE Sys_MapAttr;
|
|
DELETE Sys_MapExt;
|
|
DELETE Sys_FrmAttachment;
|
|
DELETE Sys_FrmAttachmentDB;
|
|
DELETE Sys_FrmBtn;
|
|
DELETE Sys_FrmEle;
|
|
DELETE Sys_FrmEleDB;
|
|
DELETE Sys_FrmEvent;
|
|
DELETE Sys_FrmImg;
|
|
DELETE Sys_FrmImgAth;
|
|
DELETE Sys_FrmImgAthDB;
|
|
DELETE Sys_FrmLink;
|
|
DELETE Sys_FrmRB;
|
|
DELETE Sys_FrmRePortField;
|
|
DELETE Sys_FrmRpt;
|
|
DELETE Sys_FrmSln;
|
|
DELETE Sys_GroupEnsTemplate;
|
|
DELETE Sys_GroupField;
|
|
DELETE Sys_MapDtl;
|
|
DELETE Sys_MapFrame;
|
|
DELETE Sys_RptDept;
|
|
DELETE Sys_RptEmp;
|
|
DELETE Sys_RptStation;
|
|
DELETE Sys_RptTemplate;
|
|
DELETE Sys_SFDBSrc;
|
|
DELETE Sys_SFTable;
|
|
DELETE Sys_SMS;
|
|
DELETE Sys_UserLogT;
|
|
DELETE Sys_UserRegedit;
|
|
DELETE Sys_WFSealData;
|
|
DELETE WF_AccepterRole;
|
|
DELETE WF_AthUnReadLog;
|
|
DELETE Sys_FrmPrintTemplate;
|
|
DELETE WF_Auth;
|
|
DELETE WF_CCDept;
|
|
DELETE WF_CCEmp;
|
|
DELETE WF_CCList;
|
|
DELETE WF_CCStation;
|
|
DELETE WF_CH;
|
|
DELETE WF_CHEval;
|
|
DELETE WF_CHNode;
|
|
DELETE WF_Cond;
|
|
DELETE WF_DeptFlowSearch;
|
|
DELETE WF_Direction;
|
|
DELETE WF_Emp;
|
|
DELETE WF_FindWorkerRole;
|
|
DELETE WF_Flow;
|
|
DELETE WF_FlowOrg;
|
|
DELETE WF_FrmNode;
|
|
DELETE WF_FrmOrg;
|
|
DELETE WF_GenerWorkerlist;
|
|
DELETE WF_GenerWorkFlow;
|
|
DELETE WF_LabNote;
|
|
DELETE WF_Lane;
|
|
DELETE WF_Node;
|
|
DELETE WF_NodeCancel;
|
|
DELETE WF_NodeDept;
|
|
DELETE WF_NodeEmp;
|
|
DELETE WF_NodeReturn;
|
|
DELETE WF_NodeStation;
|
|
DELETE WF_NodeSubFlow;
|
|
DELETE WF_NodeToolbar;
|
|
DELETE WF_Part;
|
|
DELETE WF_PowerModel;
|
|
DELETE WF_PushMsg;
|
|
DELETE WF_ReturnWork;
|
|
DELETE WF_SelectAccper;
|
|
DELETE WF_ShiftWork;
|
|
DELETE WF_SQLTemplate;
|
|
DELETE WF_Task;
|
|
DELETE WF_TestAPI;
|
|
DELETE WF_WorkFlowDeleteLog;
|
|
DELETE WF_TransferCustom;
|
|
|
|
--- END --------------;
|