代码拉取完成，页面将自动刷新
同步操作将从 流之云/tpflow 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat MySQL Data Transfer
Source Server : pms
Source Server Version : 50553
Source Host : 127.0.0.1:3306
Source Database : tpflow
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2018-04-01 21:27:11
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for leipi_flow
-- ----------------------------
DROP TABLE IF EXISTS `leipi_flow`;
CREATE TABLE `leipi_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,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='*工作流表';
-- ----------------------------
-- Records of leipi_flow
-- ----------------------------
INSERT INTO `leipi_flow` VALUES ('3', 'news', '新闻审批工作流-多条件判断型', '新闻审批工作流-多条件判断型', '0', '0', '0', null, null);
INSERT INTO `leipi_flow` VALUES ('4', 'news', '新闻审批工作流-直线型', '新闻审批工作流-直线型', '0', '0', '0', null, null);
INSERT INTO `leipi_flow` VALUES ('5', 'news', '测试工作流添加', '2', '1', '0', '0', '1', '1522242396');
INSERT INTO `leipi_flow` VALUES ('6', 'paper', '合同信息审批', '合同信息审批21', '2', '0', '0', '1', '1522242419');
-- ----------------------------
-- Table structure for leipi_flow_process
-- ----------------------------
DROP TABLE IF EXISTS `leipi_flow_process`;
CREATE TABLE `leipi_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 '转交下一步骤号',
`child_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'is_child 子流程id有return_step_to结束后继续父流程下一步',
`child_relation` text NOT NULL COMMENT '[保留功能]父子流程字段映射关系',
`child_after` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '子流程 结束后动作 0结束并更新父流程节点为结束 1结束并返回父流程步骤',
`child_back_process` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '子流程结束返回的步骤id',
`return_sponsor_ids` text NOT NULL COMMENT '[保留功能]主办人 子流程结束后下一步的主办人',
`return_respon_ids` text NOT NULL COMMENT '[保留功能]经办人 子流程结束后下一步的经办人',
`write_fields` text NOT NULL COMMENT '这个步骤可写的字段',
`secret_fields` text NOT NULL COMMENT '这个步骤隐藏的字段',
`lock_fields` text NOT NULL COMMENT '锁定不能更改宏控件的值',
`check_fields` text NOT NULL COMMENT '字段验证规则',
`auto_person` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '本步骤的自动选主办人规则0:为不自动选择1：流程发起人2：本部门主管3指定默认人4上级主管领导5. 一级部门主管6. 指定步骤主办人',
`auto_unlock` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许修改主办人auto_type>0 0不允许 1允许（默认）',
`auto_sponsor_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '3指定步骤主办人ids',
`auto_sponsor_text` varchar(255) NOT NULL DEFAULT '' COMMENT '3指定步骤主办人text',
`auto_respon_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '3指定步骤主办人ids',
`auto_respon_text` varchar(255) NOT NULL DEFAULT '' COMMENT '3指定步骤主办人text',
`auto_role_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '制定默认角色ids',
`auto_role_text` varchar(255) NOT NULL DEFAULT '' COMMENT '制定默认角色 text',
`auto_process_sponsor` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '[保留功能]指定其中一个步骤的主办人处理',
`range_user_ids` text NOT NULL COMMENT '本步骤的经办人授权范围ids',
`range_user_text` text NOT NULL COMMENT '本步骤的经办人授权范围text',
`range_dept_ids` text NOT NULL COMMENT '本步骤的经办部门授权范围',
`range_dept_text` text NOT NULL COMMENT '本步骤的经办部门授权范围text',
`range_role_ids` text NOT NULL COMMENT '本步骤的经办角色授权范围ids',
`range_role_text` text NOT NULL COMMENT '本步骤的经办角色授权范围text',
`receive_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0明确指定主办人1先接收者为主办人',
`is_user_end` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '允许主办人在非最后步骤也可以办结流程',
`is_userop_pass` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '经办人可以转交下一步',
`is_sing` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '会签选项0禁止会签1允许会签（默认） 2强制会签',
`sign_look` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '会签可见性0总是可见（默认）,1本步骤经办人之间不可见2针对其他步骤不可见',
`is_back` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许回退0不允许（默认） 1允许退回上一步2允许退回之前步骤',
`out_condition` text NOT NULL COMMENT '转出条件',
`setleft` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '左 坐标',
`settop` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '上 坐标',
`style` text NOT NULL 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`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_flow_process
-- ----------------------------
INSERT INTO `leipi_flow_process` VALUES ('70', '4', '开始', 'is_one', '71', '0', '', '0', '0', '', '', '', '', '', '', '4', '1', '10', '新闻部经理', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '0', '1', '[]', '436', '215', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522375321', '0');
INSERT INTO `leipi_flow_process` VALUES ('71', '4', '市场部审核', 'is_step', '72', '4', '', '2', '0', '', '', '', '', '', '', '4', '1', '11', '市场部经理', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '0', '1', '[]', '569', '404', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522375321', '0');
INSERT INTO `leipi_flow_process` VALUES ('72', '4', '工程部审核', 'is_step', '', '0', '', '1', '0', '', '', '', '', '', '', '4', '1', '13', '总经理', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '0', '1', '[]', '778', '331', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522375321', '0');
INSERT INTO `leipi_flow_process` VALUES ('73', '3', '开始', 'is_one', '74,75', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '{\"74\":{\"condition\":[\"new_type= \'1\'\"],\"condition_desc\":\"\"},\"75\":{\"condition\":[\"new_type= \'2\'\"],\"condition_desc\":\"\"}}', '331', '187', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522483275', '0');
INSERT INTO `leipi_flow_process` VALUES ('74', '3', '市场部', 'is_step', '76', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '[]', '600', '143', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522483275', '0');
INSERT INTO `leipi_flow_process` VALUES ('75', '3', '工程部', 'is_step', '76,87', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '[]', '578', '333', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522483275', '0');
INSERT INTO `leipi_flow_process` VALUES ('76', '3', '行政部确认', 'is_step', '', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '[]', '829', '207', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522483275', '0');
INSERT INTO `leipi_flow_process` VALUES ('77', '6', '项目中心初审', 'is_one', '78,83,84,85', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '[]', '375', '234', '{\"width\":150,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('78', '6', '新建步骤', 'is_step', '86', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '1115', '655', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('79', '5', '新建步骤', 'is_one', '80,81', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '1', '1', '{\"80\":{\"condition\":[\"uid= \'1\'\"],\"condition_desc\":\"\"},\"81\":{\"condition\":[\"uid= \'2\'\"],\"condition_desc\":\"\"}}', '14', '318', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('80', '5', '新建步骤', 'is_step', '82', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '251', '116', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('81', '5', '新建步骤', 'is_step', '82', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '116', '482', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('82', '5', '新建步骤', 'is_step', '89', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '362', '299', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('83', '6', '新建步骤', 'is_step', '86', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '736', '563', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('84', '6', '新建步骤', 'is_step', '86', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '426', '361', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('85', '6', '新建步骤', 'is_step', '86', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '151', '410', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('86', '6', '新建步骤', 'is_step', '', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '392', '676', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522382480', '0');
INSERT INTO `leipi_flow_process` VALUES ('87', '3', '总经理审核', 'is_step', '', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '1', '0', '1', '[]', '582', '460', '{\"width\":120,\"height\":30,\"color\":\"#0e76a8\",\"icon\":\"icon-star\"}', '0', '1522483275', '0');
INSERT INTO `leipi_flow_process` VALUES ('88', '5', '新建步骤', 'is_step', '91', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '921', '205', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('89', '5', '新建步骤', 'is_step', '88,90', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '550', '451', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('90', '5', '新建步骤', 'is_step', '91', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '907', '451', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
INSERT INTO `leipi_flow_process` VALUES ('91', '5', '新建步骤', 'is_step', '', '0', '', '1', '0', '', '', '', '', '', '', '0', '1', '', '', '', '', '', '', '0', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '', '1116', '297', '{\"icon\":\"icon-star\",\"width\":\"120\",\"height\":\"30\",\"color\":\"#0e76a8\"}', '0', '1522484387', '0');
-- ----------------------------
-- Table structure for leipi_news
-- ----------------------------
DROP TABLE IF EXISTS `leipi_news`;
CREATE TABLE `leipi_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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_news
-- ----------------------------
INSERT INTO `leipi_news` VALUES ('3', '13', '1522586765', '123', '1', '1', '<p>3123</p>', null, '1', '1522586819');
-- ----------------------------
-- Table structure for leipi_news_type
-- ----------------------------
DROP TABLE IF EXISTS `leipi_news_type`;
CREATE TABLE `leipi_news_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`add_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_news_type
-- ----------------------------
INSERT INTO `leipi_news_type` VALUES ('1', '公司新闻', '1', '1516462457');
INSERT INTO `leipi_news_type` VALUES ('2', '部门新闻', '1', null);
INSERT INTO `leipi_news_type` VALUES ('3', '上级要闻', '1', null);
INSERT INTO `leipi_news_type` VALUES ('4', '职称考试', '1', null);
-- ----------------------------
-- Table structure for leipi_role
-- ----------------------------
DROP TABLE IF EXISTS `leipi_role`;
CREATE TABLE `leipi_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;
-- ----------------------------
-- Records of leipi_role
-- ----------------------------
INSERT INTO `leipi_role` VALUES ('15', '市场部', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('16', '工程部', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('17', '新闻部', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('18', '新闻部经理', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('19', '工程部经理', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('20', '市场部经理', '0', '1', '0', '');
INSERT INTO `leipi_role` VALUES ('21', '总经理', '0', '1', '0', '');
-- ----------------------------
-- Table structure for leipi_role_user
-- ----------------------------
DROP TABLE IF EXISTS `leipi_role_user`;
CREATE TABLE `leipi_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 leipi_role_user
-- ----------------------------
INSERT INTO `leipi_role_user` VALUES ('7', '15');
INSERT INTO `leipi_role_user` VALUES ('8', '15');
INSERT INTO `leipi_role_user` VALUES ('9', '17');
INSERT INTO `leipi_role_user` VALUES ('10', '18');
INSERT INTO `leipi_role_user` VALUES ('11', '20');
INSERT INTO `leipi_role_user` VALUES ('12', '19');
INSERT INTO `leipi_role_user` VALUES ('13', '21');
-- ----------------------------
-- Table structure for leipi_run
-- ----------------------------
DROP TABLE IF EXISTS `leipi_run`;
CREATE TABLE `leipi_run` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'work_run父流转公文ID 值大于0则这个是子流程，完成后或者要返回父流程',
`from_table` varchar(255) DEFAULT NULL COMMENT '单据表，不带前缀',
`from_id` int(11) DEFAULT NULL,
`pid_flow_step` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '父pid的flow_id中的第几步骤进入的,取回这个work_flow_step的child_over决定结束子流程的动作',
`cache_run_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '多个子流程时pid无法识别cache所以加这个字段pid>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即公文分类ID',
`run_name` varchar(255) DEFAULT '' COMMENT '公文名称',
`run_flow_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流转到什么流程 最新流程，查询优化，进入子流程时将简化查询，子流程与父流程同步',
`run_flow_process` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '流转到第几步',
`att_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '公文附件ids',
`endtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0流程中，1通过,2回退',
`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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_run
-- ----------------------------
INSERT INTO `leipi_run` VALUES ('3', '0', 'news', '3', '0', '0', '13', '4', '0', '3', '4', '72', '', '0', '0', '0', '0', '1522586819', '0', null);
-- ----------------------------
-- Table structure for leipi_run_cache
-- ----------------------------
DROP TABLE IF EXISTS `leipi_run_cache`;
CREATE TABLE `leipi_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 NOT NULL COMMENT '模板信息',
`run_flow` text NOT NULL COMMENT '流程信息',
`run_flow_process` text NOT NULL 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_run_cache
-- ----------------------------
INSERT INTO `leipi_run_cache` VALUES ('3', '3', '3', '3', '', '{\"id\":3,\"uid\":13,\"add_time\":1522586765,\"new_title\":\"123\",\"new_type\":1,\"new_top\":1,\"new_con\":\"<p>3123<\\/p>\",\"new_user\":null,\"status\":0,\"uptime\":null}', '{\"id\":70,\"flow_id\":4,\"process_name\":\"\\u5f00\\u59cb\",\"process_type\":\"is_one\",\"process_to\":\"71\",\"child_id\":0,\"child_relation\":\"\",\"child_after\":0,\"child_back_process\":0,\"return_sponsor_ids\":\"\",\"return_respon_ids\":\"\",\"write_fields\":\"\",\"secret_fields\":\"\",\"lock_fields\":\"\",\"check_fields\":\"\",\"auto_person\":4,\"auto_unlock\":1,\"auto_sponsor_ids\":\"10\",\"auto_sponsor_text\":\"\\u65b0\\u95fb\\u90e8\\u7ecf\\u7406\",\"auto_respon_ids\":\"\",\"auto_respon_text\":\"\",\"auto_role_ids\":\"\",\"auto_role_text\":\"\",\"auto_process_sponsor\":0,\"range_user_ids\":\"\",\"range_user_text\":\"\",\"range_dept_ids\":\"\",\"range_dept_text\":\"\",\"range_role_ids\":\"\",\"range_role_text\":\"\",\"receive_type\":0,\"is_user_end\":0,\"is_userop_pass\":0,\"is_sing\":1,\"sign_look\":0,\"is_back\":1,\"out_condition\":\"[]\",\"setleft\":436,\"settop\":215,\"style\":\"{\\\"width\\\":120,\\\"height\\\":30,\\\"color\\\":\\\"#0e76a8\\\",\\\"icon\\\":\\\"icon-star\\\"}\",\"is_del\":0,\"updatetime\":1522375321,\"dateline\":0}', '0', '0', '1522586819');
-- ----------------------------
-- Table structure for leipi_run_log
-- ----------------------------
DROP TABLE IF EXISTS `leipi_run_log`;
CREATE TABLE `leipi_run_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`from_id` int(11) DEFAULT NULL,
`from_table` varchar(255) DEFAULT NULL,
`run_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流转id',
`run_flow` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '流程ID,子流程时区分run step',
`content` text NOT NULL COMMENT '日志内容',
`dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
`btn` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `run_id` (`run_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_run_log
-- ----------------------------
INSERT INTO `leipi_run_log` VALUES ('11', '13', '3', 'news', '3', '0', '123123', '1522586819', 'Send');
INSERT INTO `leipi_run_log` VALUES ('12', '10', '3', 'news', '3', '0', '123', '1522588939', 'ok');
INSERT INTO `leipi_run_log` VALUES ('13', '11', '3', 'news', '3', '0', '123', '1522589191', 'ok');
-- ----------------------------
-- Table structure for leipi_run_process
-- ----------------------------
DROP TABLE IF EXISTS `leipi_run_process`;
CREATE TABLE `leipi_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 NOT NULL COMMENT '备注',
`is_receive_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否先接收人为主办人',
`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',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `run_id` (`run_id`),
KEY `status` (`status`),
KEY `is_del` (`is_del`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_run_process
-- ----------------------------
INSERT INTO `leipi_run_process` VALUES ('7', '13', '3', '4', '70', '0', '0', '0', '123', '0', '0', '0', '0', '2', '1522586819', '1522588939', '0', '0', '0', '1522586819');
INSERT INTO `leipi_run_process` VALUES ('8', '10', '3', '4', '71', '0', '0', '0', '123', '0', '0', '0', '0', '2', '1522588939', '1522589191', '0', '0', '0', '1522588939');
INSERT INTO `leipi_run_process` VALUES ('9', '11', '3', '4', '72', '0', '0', '0', '', '0', '0', '0', '0', '0', '1522589191', '0', '0', '0', '0', '1522589191');
-- ----------------------------
-- Table structure for leipi_run_sign
-- ----------------------------
DROP TABLE IF EXISTS `leipi_run_sign`;
CREATE TABLE `leipi_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 NOT NULL 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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of leipi_run_sign
-- ----------------------------
-- ----------------------------
-- Table structure for leipi_user
-- ----------------------------
DROP TABLE IF EXISTS `leipi_user`;
CREATE TABLE `leipi_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 leipi_user
-- ----------------------------
INSERT INTO `leipi_user` VALUES ('7', '市场部员工1', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '15', '0', '1', '1522372036', '127.0.0.1', '0', '新建用户', '1522372036');
INSERT INTO `leipi_user` VALUES ('8', '工程部员工1', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '15', '0', '1', '1522372556', '127.0.0.1', '0', '新建用户', '1522372556');
INSERT INTO `leipi_user` VALUES ('9', '新闻部员工1', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '17', '0', '1', '1522376353', '127.0.0.1', '0', '新建用户', '1522376353');
INSERT INTO `leipi_user` VALUES ('10', '新闻部经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '18', '0', '1', '1522376372', '127.0.0.1', '0', '新建用户', '1522376372');
INSERT INTO `leipi_user` VALUES ('11', '市场部经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '20', '0', '1', '1522376385', '127.0.0.1', '0', '新建用户', '1522376385');
INSERT INTO `leipi_user` VALUES ('12', '工程部经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '19', '0', '1', '1522376401', '127.0.0.1', '0', '新建用户', '1522376401');
INSERT INTO `leipi_user` VALUES ('13', '总经理', 'c4ca4238a0b923820dcc509a6f75849b', '1', '1', '21', '0', '1', '1522376413', '127.0.0.1', '0', '新建用户', '1522376413');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手