爱子日志

泛微、SQL

“系统提醒工作流”被删后恢复

如果提示错误,企业管理器→相应的表上右击→设计表→标示→选择“否”就能执行成功了→SQL语句执行后,改回“是”

select * from workflow_base where id=1
  
  
  
INSERT INTO workflow_base (id,
                           workflowname,
                           workflowdesc,
                           workflowtype,
                           formid,
                           isbill,
                           isvalid)
VALUES (1,
        '系统提醒工作流',
        '系统自动触发的提醒工作流程',
        1,
        14,
        0,
        1)
  
  
  
select * from workflow_type where id =1
  
  
  
insert into workflow_type (
   id
  ,typename
  ,typedesc
  ,dsporder
) VALUES (
   1
  ,'系统默认工作流'
  ,'系统默认工作流'
  ,0
)
  
  
  
select * from workflow_formbase where id=14
  
  
  
insert into workflow_formbase (
   id
  ,formname
  ,formdesc
  ,subcompanyid
) VALUES (
   14
  ,'系统默认提醒表单'
  ,'系统默认提醒表单'
  ,1
)
  
  
  
update workflow_base set subcompanyid = 1 where id=1