爱子日志

16
12

泛微、SQL

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

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
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
聚划算
● 泛微● sql
评论(0) 浏览：174 2010-12-16 2:51:2
Copyright © 2005-2022 . Some Rights Reserved . .

浙公网安备 33108202000059号 浙ICP备05053943号-2

Guoy，遥看成梦，近看成风
©  爱子日志  | Powered by Z-Blog and  Theme by 未寒