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\"}]', '
| \r\n 单据名称\r\n | \r\n\r\n {billName}\r\n | \r\n
| \r\n 单据ID\r\n | \r\n\r\n {billId}\r\n | \r\n
| \r\n 流程名称\r\n | \r\n\r\n {flowName}\r\n | \r\n
| \r\n 流程描述\r\n | \r\n\r\n {flowDescription}\r\n | \r\n
| \r\n 步骤名称\r\n | \r\n\r\n {stepName}\r\n | \r\n
| \r\n 审批模式\r\n | \r\n\r\n {checkmode}\r\n | \r\n
| \r\n 是否代理\r\n | \r\n\r\n {agency}\r\n | \r\n
| \r\n 代理人(组)\r\n | \r\n\r\n {agentName}\r\n | \r\n
| \r\n 被代理人(组)\r\n | \r\n\r\n {principalName}\r\n | \r\n
| \r\n 原审批人(组)\r\n | \r\n\r\n {workerNames}\r\n | \r\n
| \r\n 上一步骤\r\n | \r\n\r\n {preStepName}\r\n | \r\n
{time}\r\n