Blame view

addons/fastflow/install.sql 35.2 KB
2db47680   hexiaodong   chore: 初始提交 php 遗...
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
  

  

  SET NAMES utf8mb4;

  SET FOREIGN_KEY_CHECKS = 0;

  

  -- ----------------------------

  -- Table structure for fa_fastflow_agency

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_agency`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `range` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '代理范围:1=业务,2=单据,3=全局',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `scope` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '代理类型:1=人员,2=分组',

    `principal_id` int(11) NULL DEFAULT NULL COMMENT '被代理人ID',

    `agent_id` int(11) NULL DEFAULT NULL COMMENT '代理人ID',

    `createtime` int(10) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(10) NULL DEFAULT NULL COMMENT '更新时间',

    `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '委托代理';

  -- ----------------------------

  -- Table structure for fa_fastflow_bill

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_bill`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `bill_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据名称',

    `bill_table` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据表名',

    `controller` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '控制器',

    `params` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '参数',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    `deletetime` int(11) NULL DEFAULT NULL COMMENT '删除时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '单据管理';

  -- ----------------------------

  -- Table structure for fa_fastflow_condition_log

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_condition_log`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `process_id` int(11) NULL DEFAULT NULL COMMENT '线程ID',

    `condition_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '条件ID',

    `node_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '步骤ID',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '条件流转日志';

  -- ----------------------------

  -- Table structure for fa_fastflow_flow

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_flow`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作流名称',

    `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务表',

    `graph` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '流程图内容',

    `status` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',

    `createuser_id` int(11) NULL DEFAULT NULL COMMENT '创建用户ID',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    `deletetime` int(11) NULL DEFAULT NULL COMMENT '删除时间',

    `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注',

    `image` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '截图',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程表';

  -- ----------------------------

  -- Table structure for fa_fastflow_flow_copy

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_flow_copy`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `flow_id` int(11) NULL DEFAULT NULL COMMENT '流程ID',

    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '工作流名称',

    `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务表',

    `graph` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '流程图内容',

    `createuser_id` int(11) NULL DEFAULT NULL COMMENT '创建用户ID',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    `deletetime` int(11) NULL DEFAULT NULL COMMENT '删除时间',

    `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注',

    `image` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '截图',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程副本';

  -- ----------------------------

  -- Table structure for fa_fastflow_message

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_message`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

    `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '键名',

    `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置',

    `templet` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '模板',

    `status` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息配置';

  -- ----------------------------

  -- Table structure for fa_fastflow_process

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_process`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `flow_id` int(11) NULL DEFAULT NULL COMMENT '流程ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据表名',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `status` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态:1=运行,2=结束,3=终止',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '进程表';

  -- ----------------------------

  -- Table structure for fa_fastflow_thread

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_thread`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `process_id` int(11) NULL DEFAULT NULL COMMENT '进程ID',

    `step_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '步骤ID',

    `status` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态:1=运行,2=结束,3=终止',

    `is_back` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否为回退:0=否,1=是',

    `is_sign` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否为会签:0=否,1=是',

    `prethread_id` int(11) NULL DEFAULT NULL COMMENT '上一个线程',

    `scope` int(1) NULL DEFAULT NULL COMMENT '域(分组类别)',

    `worker_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '需审批人人id',

    `checkmode` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '审批模式:1=联合审批,2=任一审批',

    `worker_checked_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '已审批人id',

    `can_back` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '允许驳回:0=否,1=是',

    `can_sign` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '允许会签:0=否,1=是',

    `back_to` int(11) NULL DEFAULT NULL COMMENT '回退到的线程ID',

    `sign_to` int(11) NULL DEFAULT NULL COMMENT '会签到的线程ID',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '线程表';

  -- ----------------------------

  -- Table structure for fa_fastflow_thread_log

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_thread_log`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `thread_id` int(11) NULL DEFAULT NULL COMMENT '所属线程ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据表名',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `step_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '步骤名称',

    `worker_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人(组)ID',

    `worker_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批人(组)名称',

    `check_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审批内容',

    `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资料',

    `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资料名称',

    `check_type` enum('1','2','3','4','5','6') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '审批类型:1=同意,2=驳回,3=会签,4=终止,5=发起,6=结束',

    `sign_worker` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会签人员',

    `sign_checkmode` enum('1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '会签审批模式:1=联合审批,2=任一审批',

    `back_steps` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '驳回步骤',

    `is_agency` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否为代理审批:0=否,1=是',

    `principal` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被代理人(组)',

    `agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代理人(组)',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    `deletetime` int(11) NULL DEFAULT NULL COMMENT '删除时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '审批日志';

  

  -- ----------------------------

  -- Table structure for fa_fastflow_carbon

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_carbon`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `sender_id` int(11) NULL DEFAULT NULL COMMENT '抄送人ID',

    `receiver_id` int(11) NULL DEFAULT NULL COMMENT '接收人ID',

    `sendtime` datetime NULL DEFAULT NULL COMMENT '抄送时间',

    `thread_log_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志ID',

    `is_read` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否已读:0=未读,1=已读',

    `current_log_id` int(11) NULL DEFAULT NULL COMMENT '发起抄送的步骤对应log的ID',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '我的抄送';

  

  -- ----------------------------

  -- Table structure for fa_fastflow_bill_auth

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_bill_auth`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规则,view:1=所有的,2=本人发起的、当前需审批的,3=本人发起的、当前需审批的、参与过审批的;delete:1=本人未发起审批的,2=本人未发起审批的、流程中的,3=不允许',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '单据权限配置';

  

  -- ----------------------------

  -- Table structure for fa_fastflow_flow_auth

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_flow_auth`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `flow_id` int(11) NOT NULL COMMENT '流程ID',

    `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规则',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程权限配置';

  -- ----------------------------

  -- Table structure for fa_fastflow_flow_auth_copy

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_flow_auth_copy`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `flow_id` int(11) NOT NULL COMMENT '流程ID',

    `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规则',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '流程权限副本';

  -- ----------------------------

  -- Table structure for fa_fastflow_ebill

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_ebill`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据表',

    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

    `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',

    `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单',

    `md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件MD5',

    `thumbnail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '缩略图',

    `thumb_width` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图宽',

    `thumb_height` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图高',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '电子表单';

  -- ----------------------------

  -- Table structure for fa_fastflow_ebill_copy

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_ebill_copy`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据表',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

    `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',

    `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单',

    `md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件MD5',

    `thumbnail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '缩略图',

    `thumb_width` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图宽',

    `thumb_height` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缩略图高',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '电子表单';

  -- ----------------------------

  -- Table structure for fa_fastflow_config

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_config`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',

    `value` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '值',

    `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '说明',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统设置';

  -- ----------------------------

  -- Table structure for fa_fastflow_cancheck_index

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_cancheck_index`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `step_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '步骤ID',

    `scope` int(1) NULL DEFAULT NULL COMMENT '域:1=人员,2=分组',

    `worker_id` int(11) NULL DEFAULT NULL COMMENT '人员(分组)ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '待审批人员单据索引';

  -- ----------------------------

  -- Table structure for fa_fastflow_participant_index

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_participant_index`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `worker_id` int(11) NULL DEFAULT NULL COMMENT '参与审批人员ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参与审批人员单据索引';

  -- ----------------------------

  -- Table structure for fa_fastflow_stamp

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_stamp`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `scope` int(1) NULL DEFAULT NULL COMMENT '域:1=人员;2=分组',

    `belongsto` int(11) NULL DEFAULT NULL COMMENT '所属ID',

    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',

    `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',

    `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件',

    `md5` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'md5',

    `width` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宽',

    `height` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '高',

    `auth` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '使用权限',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '电子签章';

  -- ----------------------------

  -- Table structure for fa_fastflow_signature

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_signature`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `bill` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据',

    `bill_id` int(11) NULL DEFAULT NULL COMMENT '单据ID',

    `status` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态:0=待签章,1=已完成',

    `initiator_id` int(11) NULL DEFAULT NULL COMMENT '发起人ID',

    `signers` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '签章人员',

    `stamped` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已签章人员',

    `ebill` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '电子单据截图',

    `ebill_width` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据宽',

    `ebill_height` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单据高',

    `thumbnail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '缩略图',

    `firstsectionwidth` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第一节宽',

    `firstsectionheight` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第一节高',

    `ebill_copy_id` int(11) NULL DEFAULT NULL COMMENT '电子单据ID',

    `png_md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PNGmd5',

    `pdf_md5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PDFmd5',

    `pdf_file` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PDF文件',

    `has_certificate` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有数字证书:0=无,1=有',

    `createtime` int(11) NULL DEFAULT NULL COMMENT '创建时间',

    `updatetime` int(11) NULL DEFAULT NULL COMMENT '更新时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '发起的签章';

  -- ----------------------------

  -- Table structure for fa_fastflow_signature_log

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_signature_log`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `signature_id` int(11) NULL DEFAULT NULL COMMENT '签章表ID',

    `admin_id` int(11) NULL DEFAULT NULL COMMENT '签章人ID',

    `createtime` int(11) NOT NULL COMMENT '创建时间',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '签章日志';

  -- ----------------------------

  -- Table structure for fa_fastflow_demo_leave

  -- ----------------------------

  CREATE TABLE IF NOT EXISTS `__PREFIX__fastflow_demo_leave`  (

    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',

    `initiator_id` int(11) NULL DEFAULT NULL COMMENT '发起人ID',

    `sex` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '性别:0=女,1=男',

    `age` int(11) NULL DEFAULT NULL COMMENT '年龄',

    `status` enum('0','1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态:0=待发起,1=流程中,2=通过,3=终止',

    `type` enum('1','2','3') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '请假类型:1=休假,2=事假,3=因公',

    `days` int(11) NULL DEFAULT NULL COMMENT '请假天数',

    `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请假理由',

    `starttime` datetime NULL DEFAULT NULL COMMENT '请假时间',

    `endtime` datetime NULL DEFAULT NULL COMMENT '到假时间',

    `addr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '外出地址',

    `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',

    `file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '证明材料',

    PRIMARY KEY (`id`) USING BTREE

  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '请假审批(演示)';

  -- ----------------------------

  -- 系统配置数据

  -- ----------------------------

  INSERT INTO `__PREFIX__fastflow_config` VALUES (1, 'qrcode', '电子单据二维码', 'true', '自动为生成的电子单据附加二维码,通过扫码可以查看该单据审批详情', NULL, 'false=不附加,true=附加');

  INSERT INTO `__PREFIX__fastflow_config` VALUES (2, 'qrcodepos', '二维码位置', 'topright', '电子单据中二维码显示位置', NULL, NULL);

  INSERT INTO `__PREFIX__fastflow_config` VALUES (3, 'qrcodesize', '二维码大小', '80', '二维码长、宽像素,如果扫码时间较长或扫码失败请加大数值', NULL, '长宽相等(px)');

  INSERT INTO `__PREFIX__fastflow_config` VALUES (4, 'signature', '是否使用签名验证', 'false', '开启签名验证将使用证书和私钥在电子签章处添加电子签名,当电子表单存在多个签章时,只为最后一个签章附加电子签名', NULL, '是否使用签名验证');

  INSERT INTO `__PREFIX__fastflow_config` VALUES (5, 'certificate', '数字证书', NULL, '申请的CRT格式证书文件内容', NULL, '签名证书内容');

  INSERT INTO `__PREFIX__fastflow_config` VALUES (6, 'privatekey', '私钥', NULL, '申请的KEY格式私钥文件内容', NULL, '私钥内容');

  INSERT INTO `__PREFIX__fastflow_config` VALUES (7, 'billshowway', '单据列表显示方式', 'menu', '单据作为菜单项显示或页面内列表显示', NULL, 'menu,page');

  -- ----------------------------

  -- 演示单据数据

  -- ----------------------------

  INSERT IGNORE INTO `__PREFIX__fastflow_bill` VALUES (1, '请假审批(演示)', '__PREFIX__fastflow_demo_leave', 'fastflow/bill/FastflowDemoLeave', '{\"dialog\":\"1\",\"commandtype\":\"crud\",\"table\":\"__PREFIX__fastflow_demo_leave\",\"icon\":\"fa-circle-o\",\"controller\":\"fastflow\\/bill\\/FastflowDemoLeave\",\"relation_json\":\"\",\"fields\":[\"\"],\"isrelation\":0,\"local\":1,\"delete\":0,\"force\":0}', 1641610943, 1641610943, NULL);

  -- ----------------------------

  -- 默认邮件消息配置

  -- ----------------------------

  INSERT IGNORE INTO `__PREFIX__fastflow_message` VALUES (1, '邮件', 'email', '[{\"title\":\"类型\",\"key\":\"type\",\"value\":\"SMTP\"},{\"title\":\"服务器\",\"key\":\"host\",\"value\":\"smtp.qq.com\"},{\"title\":\"端口\",\"key\":\"port\",\"value\":\"465\"},{\"title\":\"用户\",\"key\":\"user\",\"value\":\"10000@qq.com\"},{\"title\":\"密码\",\"key\":\"password\",\"value\":\"10000\"},{\"title\":\"验证类型\",\"key\":\"verify_type\",\"value\":\"ssl\"}]', '<div>\r\n    <div style=\"padding-bottom:42px;padding-top:42px;border-radius:2px;background-clip:padding-box;box-shadow:0 0 3px rgba(0,0,0,.2);background-color:#fbfbfb;border:0;color:#262626;position:relative;margin-bottom:30px;\">\r\n        <div style=\"color:#fff;border-bottom:0;position:absolute;top:0;right:0;left:0;padding:10px;text-align:left;border-radius:2px 2px 0 0;background-color:#3dadbf;font-weight:bold;\">\r\n            待审批单据详情\r\n        </div>\r\n        <table style=\"background-color:#fff;margin-bottom:0;border:1px solid #ddd;width:100%;max-width:100%;border-spacing:0;border-collapse:collapse;\">\r\n            <tbody>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    单据名称\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                   {billName}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    单据ID\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {billId}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    流程名称\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {flowName}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    流程描述\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {flowDescription}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    步骤名称\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {stepName}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    审批模式\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                   {checkmode}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    是否代理\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {agency}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    代理人(组)\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                   {agentName}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    被代理人(组)\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                   {principalName}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    原审批人(组)\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {workerNames}\r\n                </td>\r\n            </tr>\r\n            <tr style=\"box-sizing:border-box;font-size:14px;text-align:center;font-weight:bold;\">\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;background-color:#f0f9ec;width:120px;color:#b08520;\">\r\n                    上一步骤\r\n                </td>\r\n                <td style=\"border:1px solid #ddd;padding:8px;line-height:1.42857143;vertical-align:middle;\">\r\n                    {preStepName}\r\n                </td>\r\n            </tr>\r\n            </tbody>\r\n        </table>\r\n\r\n        <div style=\"position:absolute;bottom:0;right:0;left:0;padding:10px;border-top:1px solid #e5e5e5;border-radius:0 0 2px 2px;font-size:14px;\">\r\n            <code>{time}</code>\r\n        </div>\r\n    </div>\r\n</div>\r\n', '0');

  INSERT IGNORE INTO `__PREFIX__fastflow_message` VALUES (2, '阿里云短信', 'aliyunSms', '[{\"title\":\"域名\",\"key\":\"endpoint\",\"value\":\"dysmsapi.aliyuncs.com\"},{\"title\":\"AccessKey ID\",\"key\":\"accessKeyId\",\"value\":\"1000\"},{\"title\":\"AccessKey Secret\",\"key\":\"accessKeySecret\",\"value\":\"1000\"},{\"title\":\"签名名称\",\"key\":\"signName\",\"value\":\"mysign\"},{\"title\":\"模板CODE\",\"key\":\"templateCode\",\"value\":\"SMS_123456\"}]', '{\"bill\":\"{billName}\",\"billId\":\"{billId}\",\"flowName\":\"{flowName}\"}', '0');

  

  -- 1.1.1 --

  ALTER TABLE `__PREFIX__fastflow_carbon` CHANGE `read` `is_read` enum('0','1') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否已读:0=未读,1=已读';

  -- 4.1.0 --

  ALTER TABLE `__PREFIX__fastflow_signature` CHANGE `thumb_width` `firstsectionwidth` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第一节宽';

  ALTER TABLE `__PREFIX__fastflow_signature` CHANGE `thumb_height` `firstsectionheight` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '第一节高';

  ALTER TABLE `__PREFIX__fastflow_signature` ADD COLUMN `pdf_file` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'PDF文件' AFTER `pdf_md5`;

  ALTER TABLE `__PREFIX__fastflow_signature` ADD COLUMN `has_certificate` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有数字证书:0=无,1=有' AFTER `pdf_file`;

  -- 4.4.2 --

  ALTER TABLE `__PREFIX__fastflow_carbon` ADD COLUMN `current_log_id` int(11) NULL DEFAULT NULL COMMENT '发起抄送的步骤对应log的ID' AFTER `is_read`;