install.sql 35.2 KB


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`;