代码拉取完成,页面将自动刷新
同步操作将从 流之云/tpflow 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
Name: Tpflow Sql
Date: 2020-09-22
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for wf_flow
-- ----------------------------
DROP TABLE IF EXISTS `wf_flow`;
CREATE TABLE `wf_flow` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL COMMENT '流程类别',
`flow_name` varchar(255) NOT NULL DEFAULT '' COMMENT '流程名称',
`flow_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
`sort_order` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不可用1正常',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
`uid` int(11) DEFAULT NULL COMMENT '添加用户',
`add_time` int(11) DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='*工作流表';
-- ----------------------------
-- Records of wf_flow
-- ----------------------------
-- ----------------------------
-- Table structure for wf_flow_process
-- ----------------------------
DROP TABLE IF EXISTS `wf_flow_process`;
CREATE TABLE `wf_flow_process` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`flow_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程ID',
`process_name` varchar(255) NOT NULL DEFAULT '步骤' COMMENT '步骤名称',
`process_type` char(10) NOT NULL DEFAULT '' COMMENT '步骤类型',
`process_to` varchar(255) NOT NULL DEFAULT '' COMMENT '转交下一步骤号',
`auto_person` tinyint(1) unsigned NOT NULL DEFAULT '4' COMMENT '3自由选择|4指定人员|5指定角色|6事务接受',
`auto_sponsor_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '4指定步骤主办人ids',
`auto_sponsor_text` varchar(255) NOT NULL DEFAULT '' COMMENT '4指定步骤主办人text',
`work_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '6事务接受',
`work_text` varchar(255) NOT NULL DEFAULT '' COMMENT '6事务接受',
`auto_role_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '5角色ids',
`auto_role_text` varchar(255) NOT NULL DEFAULT '' COMMENT '5角色 text',
`range_user_ids` text COMMENT '3自由选择IDS',
`range_user_text` text COMMENT '3自由选择用户ID',
`is_sing` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1允许|2不允许',
`is_back` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1允许|2不允许',
`out_condition` text COMMENT '转出条件',
`setleft` smallint(5) unsigned NOT NULL DEFAULT '100' COMMENT '左 坐标',
`settop` smallint(5) unsigned NOT NULL DEFAULT '100' COMMENT '上 坐标',
`style` text COMMENT '样式 序列化',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`wf_mode` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0 单一线性,1,转出条件 2,同步模式',
`wf_action` varchar(255) NOT NULL DEFAULT 'view' COMMENT '对应方法',
`work_sql` longtext,
`work_msg` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_flow_process
-- ----------------------------
-- ----------------------------
-- Table structure for wf_news
-- ----------------------------
DROP TABLE IF EXISTS `wf_news`;
CREATE TABLE `wf_news` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`uid` int(11) NOT NULL COMMENT '用户id',
`add_time` int(11) DEFAULT NULL COMMENT '新增时间',
`new_title` varchar(255) DEFAULT NULL COMMENT '新闻标题',
`new_type` int(11) DEFAULT NULL COMMENT '新闻类别',
`new_top` int(11) NOT NULL DEFAULT '0' COMMENT '是否置顶',
`new_con` longtext COMMENT '新闻内容',
`new_user` varchar(255) DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT '0' COMMENT '-1回退修改0 保存中1流程中 2通过',
`uptime` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='[work]新闻表';
-- ----------------------------
-- Records of wf_news
-- ----------------------------
-- ----------------------------
-- Table structure for wf_news_type
-- ----------------------------
DROP TABLE IF EXISTS `wf_news_type`;
CREATE TABLE `wf_news_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL COMMENT '新闻类别',
`uid` int(11) DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='新闻类别';
-- ----------------------------
-- Records of wf_news_type
-- ----------------------------
INSERT INTO `wf_news_type` VALUES ('1', '新闻', null, null);
INSERT INTO `wf_news_type` VALUES ('2', '公告', null, null);
-- ----------------------------
-- Table structure for wf_role
-- ----------------------------
DROP TABLE IF EXISTS `wf_role`;
CREATE TABLE `wf_role` (
`id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '后台组名',
`pid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
`status` tinyint(1) unsigned DEFAULT '0' COMMENT '是否激活 1:是 0:否',
`sort` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序权重',
`remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='模拟用户角色表';
-- ----------------------------
-- Records of wf_role
-- ----------------------------
INSERT INTO `wf_role` VALUES ('1', '员工部', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('2', '经理部', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('3', '主管部', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('4', '主任部', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('5', '副总', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('6', '总经理', '0', '1', '0', '');
INSERT INTO `wf_role` VALUES ('7', '董事长', '0', '1', '0', '');
-- ----------------------------
-- Table structure for wf_role_user
-- ----------------------------
DROP TABLE IF EXISTS `wf_role_user`;
CREATE TABLE `wf_role_user` (
`user_id` int(10) unsigned NOT NULL,
`role_id` smallint(6) unsigned NOT NULL,
KEY `group_id` (`role_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_role_user
-- ----------------------------
INSERT INTO `wf_role_user` VALUES ('1', '1');
INSERT INTO `wf_role_user` VALUES ('2', '2');
INSERT INTO `wf_role_user` VALUES ('3', '3');
INSERT INTO `wf_role_user` VALUES ('4', '4');
INSERT INTO `wf_role_user` VALUES ('5', '5');
INSERT INTO `wf_role_user` VALUES ('6', '6');
INSERT INTO `wf_role_user` VALUES ('7', '7');
-- ----------------------------
-- Table structure for wf_run
-- ----------------------------
DROP TABLE IF EXISTS `wf_run`;
CREATE TABLE `wf_run` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'work_run ID ',
`from_table` varchar(255) DEFAULT NULL COMMENT '单据表,不带前缀',
`from_id` int(11) DEFAULT NULL,
`pid_flow_step` smallint(5) unsigned NOT NULL DEFAULT '0',
`cache_run_id` int(10) unsigned NOT NULL DEFAULT '0',
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`flow_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程id 正常流程',
`cat_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程分类ID',
`run_name` varchar(255) DEFAULT '' COMMENT '公文名称',
`run_flow_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流转到什么流程',
`run_flow_process` varchar(255) DEFAULT NULL COMMENT '流转到第几步',
`att_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '附件ids',
`endtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
`status` int(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态,0流程中,2通过,1回退',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`is_sing` int(11) NOT NULL DEFAULT '0',
`sing_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `pid_flow_step` (`pid_flow_step`),
KEY `cache_run_id` (`cache_run_id`),
KEY `uid` (`uid`),
KEY `is_del` (`is_del`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_run
-- ----------------------------
-- ----------------------------
-- Table structure for wf_run_cache
-- ----------------------------
DROP TABLE IF EXISTS `wf_run_cache`;
CREATE TABLE `wf_run_cache` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`run_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT ' 缓存run工作的全部流程模板步骤等信息,确保修改流程后工作依然不变',
`form_id` int(10) unsigned NOT NULL DEFAULT '0',
`flow_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程ID',
`run_form` text COMMENT '模板信息',
`run_flow` text COMMENT '流程信息',
`run_flow_process` text COMMENT '流程步骤信息 ',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `run_id` (`run_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_run_cache
-- ----------------------------
-- ----------------------------
-- Table structure for wf_run_log
-- ----------------------------
DROP TABLE IF EXISTS `wf_run_log`;
CREATE TABLE `wf_run_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
`from_id` int(11) DEFAULT NULL COMMENT '单据ID',
`from_table` varchar(255) DEFAULT NULL COMMENT '单据表',
`run_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流转id',
`run_flow` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程ID',
`content` text COMMENT '日志内容',
`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`btn` varchar(255) DEFAULT NULL COMMENT '提交操作信息',
`art` longtext COMMENT '附件日志',
`work_info` varchar(255) DEFAULT NULL COMMENT '事务日志',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `run_id` (`run_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_run_log
-- ----------------------------
-- ----------------------------
-- Table structure for wf_run_process
-- ----------------------------
DROP TABLE IF EXISTS `wf_run_process`;
CREATE TABLE `wf_run_process` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`run_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '当前流转id',
`run_flow` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '属于那个流程的id',
`run_flow_process` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '当前步骤编号',
`parent_flow` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上一步流程',
`parent_flow_process` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '上一步骤号',
`run_child` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始转入子流程run_id 如果转入子流程,则在这里也记录',
`remark` text COMMENT '备注',
`is_receive_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否先接收人为主办人',
`auto_person` tinyint(4) DEFAULT NULL,
`sponsor_text` varchar(255) DEFAULT NULL,
`sponsor_ids` varchar(255) DEFAULT NULL,
`is_sponsor` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否步骤主办人 0否(默认) 1是',
`is_singpost` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已会签过',
`is_back` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '被退回的 0否(默认) 1是',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 0为未接收(默认),1为办理中 ,2为已转交,3为已结束4为已打回',
`js_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '接收时间',
`bl_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '办理时间',
`jj_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '转交时间,最后一步等同办结时间',
`is_del` tinyint(1) unsigned NOT NULL DEFAULT '0',
`updatetime` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`wf_mode` int(11) DEFAULT NULL,
`wf_action` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `run_id` (`run_id`),
KEY `status` (`status`),
KEY `is_del` (`is_del`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_run_process
-- ----------------------------
-- ----------------------------
-- Table structure for wf_run_sign
-- ----------------------------
DROP TABLE IF EXISTS `wf_run_sign`;
CREATE TABLE `wf_run_sign` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`run_id` int(10) unsigned NOT NULL DEFAULT '0',
`run_flow` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程ID,子流程时区分run step',
`run_flow_process` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '当前步骤编号',
`content` text COMMENT '会签内容',
`is_agree` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '审核意见:1同意;2不同意',
`sign_att_id` int(10) unsigned NOT NULL DEFAULT '0',
`sign_look` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '步骤设置的会签可见性,0总是可见(默认),1本步骤经办人之间不可见2针对其他步骤不可见',
`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `run_id` (`run_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_run_sign
-- ----------------------------
-- ----------------------------
-- Table structure for wf_user
-- ----------------------------
DROP TABLE IF EXISTS `wf_user`;
CREATE TABLE `wf_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` char(32) NOT NULL,
`tel` varchar(255) DEFAULT NULL,
`mail` varchar(255) DEFAULT NULL,
`role` smallint(6) unsigned NOT NULL COMMENT '组ID',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 1:启用 0:禁止',
`remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
`last_login_time` int(11) unsigned NOT NULL COMMENT '最后登录时间',
`last_login_ip` varchar(15) DEFAULT NULL COMMENT '最后登录IP',
`login_count` int(11) DEFAULT '0',
`last_location` varchar(100) DEFAULT NULL COMMENT '最后登录位置',
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of wf_user
-- ----------------------------
INSERT INTO `wf_user` VALUES ('1', '员工', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '1', '0', '1', '1522372036', '127.0.0.1', '0', '新建用户', '1522372036');
INSERT INTO `wf_user` VALUES ('2', '经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '2', '0', '1', '1522372556', '127.0.0.1', '0', '新建用户', '1522372556');
INSERT INTO `wf_user` VALUES ('3', '主管', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '3', '0', '1', '1522376353', '127.0.0.1', '0', '新建用户', '1522376353');
INSERT INTO `wf_user` VALUES ('4', '主任', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '4', '0', '1', '1522376372', '127.0.0.1', '0', '新建用户', '1522376372');
INSERT INTO `wf_user` VALUES ('5', '副总', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '5', '0', '1', '1522376385', '127.0.0.1', '0', '新建用户', '1522376385');
INSERT INTO `wf_user` VALUES ('6', '总经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '6', '0', '1', '1522376401', '127.0.0.1', '0', '新建用户', '1522376401');
INSERT INTO `wf_user` VALUES ('7', '董事长', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '7', '0', '1', '1522376413', '127.0.0.1', '0', '新建用户', '1522376413');
-- ----------------------------
-- Table structure for wf_workinfo
-- ----------------------------
DROP TABLE IF EXISTS `wf_workinfo`;
CREATE TABLE `wf_workinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bill_info` longtext COMMENT '单据JSON',
`data` longtext COMMENT '处理数据',
`info` longtext COMMENT '处理结果',
`datetime` datetime DEFAULT NULL,
`type` varchar(255) DEFAULT NULL COMMENT '类型',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of wf_workinfo
-- ----------------------------
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。