/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : gadmin

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-03-02 09:29:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `g_access`
-- ----------------------------
DROP TABLE IF EXISTS `g_access`;
CREATE TABLE `g_access` (
  `role_id` smallint(6) unsigned NOT NULL,
  `node_id` smallint(6) unsigned NOT NULL,
  `pid` smallint(6) unsigned NOT NULL,
  `level` tinyint(1) NOT NULL,
  `module` varchar(50) DEFAULT NULL,
  KEY `groupId` (`role_id`),
  KEY `nodeId` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_access
-- ----------------------------

-- ----------------------------
-- Table structure for `g_fd`
-- ----------------------------
DROP TABLE IF EXISTS `g_fd`;
CREATE TABLE `g_fd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '表单名称',
  `name` varchar(255) DEFAULT NULL COMMENT '表名',
  `file` varchar(255) DEFAULT NULL COMMENT '生成文件',
  `menu` int(11) NOT NULL DEFAULT '0',
  `flow` int(11) NOT NULL DEFAULT '0',
  `ziduan` longtext,
  `uid` varchar(255) DEFAULT NULL,
  `add_time` int(11) DEFAULT NULL,
  `status` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_fd
-- ----------------------------
INSERT INTO `g_fd` VALUES ('1', '业务测试', 'ywtest', 'all', '0', '0', null, null, '1547513664', '0');
INSERT INTO `g_fd` VALUES ('2', 'test', 'test', 'all', '0', '0', '{\"fields\":[{\"label\":\"核心内容\",\"field_type\":\"text\",\"required\":true,\"field_options\":{\"size\":\"medium\"},\"lists\":\"yes\",\"search\":\"yes\",\"type\":\"text\",\"cid\":\"c6\",\"name\":\"title\"},{\"label\":\"upload\",\"field_type\":\"upload\",\"required\":true,\"field_options\":{\"size\":\"medium\"},\"lists\":\"yes\",\"search\":\"yes\",\"type\":\"upload\",\"cid\":\"c2\",\"name\":\"pic\"}]}', '1', '1551335975', '1');

-- ----------------------------
-- Table structure for `g_fd_fun`
-- ----------------------------
DROP TABLE IF EXISTS `g_fd_fun`;
CREATE TABLE `g_fd_fun` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) DEFAULT NULL,
  `sql` longtext,
  `name` varchar(255) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `add_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_fd_fun
-- ----------------------------

-- ----------------------------
-- Table structure for `g_flow`
-- ----------------------------
DROP TABLE IF EXISTS `g_flow`;
CREATE TABLE `g_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 DEFAULT CHARSET=utf8 COMMENT='*工作流表';

-- ----------------------------
-- Records of g_flow
-- ----------------------------

-- ----------------------------
-- Table structure for `g_flow_process`
-- ----------------------------
DROP TABLE IF EXISTS `g_flow_process`;
CREATE TABLE `g_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 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 COMMENT '[保留功能]主办人 子流程结束后下一步的主办人',
  `return_respon_ids` text COMMENT '[保留功能]经办人 子流程结束后下一步的经办人',
  `write_fields` text COMMENT '这个步骤可写的字段',
  `secret_fields` text COMMENT '这个步骤隐藏的字段',
  `lock_fields` text COMMENT '锁定不能更改宏控件的值',
  `check_fields` text 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 COMMENT '本步骤的经办人授权范围ids',
  `range_user_text` text COMMENT '本步骤的经办人授权范围text',
  `range_dept_ids` text COMMENT '本步骤的经办部门授权范围',
  `range_dept_text` text COMMENT '本步骤的经办部门授权范围text',
  `range_role_ids` text COMMENT '本步骤的经办角色授权范围ids',
  `range_role_text` text 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 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',
  `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 '对应方法',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_flow_process
-- ----------------------------

-- ----------------------------
-- Table structure for `g_menu`
-- ----------------------------
DROP TABLE IF EXISTS `g_menu`;
CREATE TABLE `g_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `add_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_menu
-- ----------------------------
INSERT INTO `g_menu` VALUES ('1', 'test/index', 'test', '1', '0000-00-00 00:00:00');

-- ----------------------------
-- Table structure for `g_news`
-- ----------------------------
DROP TABLE IF EXISTS `g_news`;
CREATE TABLE `g_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;

-- ----------------------------
-- Records of g_news
-- ----------------------------

-- ----------------------------
-- Table structure for `g_news_type`
-- ----------------------------
DROP TABLE IF EXISTS `g_news_type`;
CREATE TABLE `g_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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_news_type
-- ----------------------------

-- ----------------------------
-- Table structure for `g_node`
-- ----------------------------
DROP TABLE IF EXISTS `g_node`;
CREATE TABLE `g_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '节点名称',
  `title` varchar(50) NOT NULL COMMENT '菜单名称',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否激活 1：是 2：否',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `pid` smallint(6) unsigned NOT NULL COMMENT '父ID',
  `level` tinyint(1) unsigned NOT NULL COMMENT '节点等级',
  `data` varchar(255) DEFAULT NULL COMMENT '附加参数',
  `sort` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序权重',
  `display` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '菜单显示类型 0:不显示 1:导航菜单 2:左侧菜单',
  PRIMARY KEY (`id`),
  KEY `level` (`level`),
  KEY `pid` (`pid`),
  KEY `status` (`status`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=374 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_node
-- ----------------------------
INSERT INTO `g_node` VALUES ('1', 'Index', '根节点', '1', '不可删除', '0', '1', null, '0', '0');
INSERT INTO `g_node` VALUES ('372', 'Fd', '业务设计', '1', null, '57', '2', null, '0', '2');
INSERT INTO `g_node` VALUES ('182', 'User', '个人信息', '1', null, '64', '2', 'Info/info', '0', '2');
INSERT INTO `g_node` VALUES ('57', 'Sys', '系统设定', '1', null, '1', '0', null, '44', '1');
INSERT INTO `g_node` VALUES ('58', 'Access', '权限管理', '1', null, '57', '2', null, '49', '2');
INSERT INTO `g_node` VALUES ('59', 'Sys', '系统设置', '1', null, '57', '2', null, '48', '2');
INSERT INTO `g_node` VALUES ('60', 'Users', '用户管理', '1', '', '57', '2', '', '50', '2');
INSERT INTO `g_node` VALUES ('63', 'Index', '我的面板', '1', '我的面板', '14', '2', '', '0', '2');
INSERT INTO `g_node` VALUES ('64', 'User', '个人档案', '1', '个人档案', '14', '2', 'Info', '0', '2');
INSERT INTO `g_node` VALUES ('65', 'Index', '我的面板', '1', '我的面板', '63', '3', 'Index/welcome', '0', '2');
INSERT INTO `g_node` VALUES ('14', 'Index', '首页', '1', '', '1', '0', '', '50', '1');
INSERT INTO `g_node` VALUES ('180', 'edit', '修改', '1', '', '151', '3', 'edit', '0', '0');
INSERT INTO `g_node` VALUES ('369', 'wf', '工作流平台', '1', '', '57', '2', '', '0', '2');
INSERT INTO `g_node` VALUES ('179', 'add', '新增', '1', '', '151', '3', 'add', '0', '0');
INSERT INTO `g_node` VALUES ('152', 'News', '公司新闻', '1', '公司发文', '88', '2', 'News/index', '49', '2');
INSERT INTO `g_node` VALUES ('153', 'Sharing', '共享中心', '1', '共享中心', '88', '2', 'Sharing/index', '48', '2');
INSERT INTO `g_node` VALUES ('154', 'Menber', '联系人信息', '1', '', '89', '2', 'Menber/index', '0', '2');
INSERT INTO `g_node` VALUES ('370', 'wfindex', '工作流管理', '1', '', '369', '2', 'Wf/wfindex', '0', '2');
INSERT INTO `g_node` VALUES ('371', 'wfjk', '工作流监控', '1', null, '369', '2', 'Wf/wfjk', '0', '2');
INSERT INTO `g_node` VALUES ('143', 'User', '用户角色', '1', 'User/role', '60', '3', 'User/role', '0', '2');
INSERT INTO `g_node` VALUES ('144', 'User', '用户列表', '1', 'User/index', '60', '2', 'User/index', '0', '2');
INSERT INTO `g_node` VALUES ('145', 'Node', '菜单管理', '1', 'Node/index', '58', '2', 'Node/index', '0', '2');
INSERT INTO `g_node` VALUES ('146', 'Sys', '公司配置', '1', 'Sys/base', '59', '2', 'Sys/base', '0', '2');
INSERT INTO `g_node` VALUES ('147', 'Sys', '消息配置', '1', 'Sys/msg', '59', '3', 'Sys/msg', '0', '2');
INSERT INTO `g_node` VALUES ('151', 'Notice', '公司通知', '1', '公司通知', '88', '2', 'Notice/index', '50', '2');
INSERT INTO `g_node` VALUES ('150', 'Sys', '系统日志', '1', '系统日志', '59', '3', 'Sys/logs', '0', '2');
INSERT INTO `g_node` VALUES ('181', 'User', '密码修改', '1', '', '64', '2', 'Info/pass', '0', '2');
INSERT INTO `g_node` VALUES ('293', 'index', '节点列表', '1', null, '145', '3', 'index', '0', '0');
INSERT INTO `g_node` VALUES ('294', 'add', '添加节点', '1', null, '145', '3', 'add', '0', '0');
INSERT INTO `g_node` VALUES ('295', 'edit', '编辑节点', '1', null, '145', '3', 'edit', '0', '0');
INSERT INTO `g_node` VALUES ('296', 'del', '删除节点', '1', null, '145', '3', 'del', '0', '0');
INSERT INTO `g_node` VALUES ('297', 'sort', '排序更新', '1', null, '145', '3', 'sort', '0', '0');
INSERT INTO `g_node` VALUES ('298', 'index', '通知列表', '1', null, '151', '3', 'index', '0', '0');
INSERT INTO `g_node` VALUES ('299', 'add', '新增通知', '1', null, '151', '3', 'add', '0', '0');
INSERT INTO `g_node` VALUES ('300', 'edit', '编辑公司通知', '1', null, '151', '3', 'edit', '0', '0');
INSERT INTO `g_node` VALUES ('301', 'view', '查看公司通知', '1', null, '151', '3', 'view', '0', '0');
INSERT INTO `g_node` VALUES ('302', 'del', '删除通知', '1', null, '151', '3', 'del', '0', '0');
INSERT INTO `g_node` VALUES ('373', 'index', '表单设计', '1', null, '372', '2', 'Fd/index', '0', '2');
INSERT INTO `g_node` VALUES ('321', 'base', '基本配置', '1', null, '146', '3', 'base', '0', '0');
INSERT INTO `g_node` VALUES ('322', 'msg', '消息配置', '1', null, '146', '3', 'msg', '0', '0');
INSERT INTO `g_node` VALUES ('323', 'logs', '系统日志', '1', null, '146', '3', 'logs', '0', '0');
INSERT INTO `g_node` VALUES ('346', 'index', '用户列表', '1', null, '144', '3', 'index', '0', '0');
INSERT INTO `g_node` VALUES ('347', 'add', '新增用户', '1', null, '144', '3', 'add', '0', '0');
INSERT INTO `g_node` VALUES ('348', 'edit', '用户编辑', '1', null, '144', '3', 'edit', '0', '0');
INSERT INTO `g_node` VALUES ('349', 'check_username', '用户验证', '1', null, '144', '3', 'check_username', '0', '0');
INSERT INTO `g_node` VALUES ('350', 'change', '用户修改', '1', null, '144', '3', 'change', '0', '0');
INSERT INTO `g_node` VALUES ('351', 'del', '用户删除', '1', null, '144', '3', 'del', '0', '0');
INSERT INTO `g_node` VALUES ('352', 'role', '角色列表', '1', null, '144', '3', 'role', '0', '0');
INSERT INTO `g_node` VALUES ('353', 'addrole', '添加角色', '1', null, '144', '3', 'addrole', '0', '0');
INSERT INTO `g_node` VALUES ('354', 'roleedit', '编辑角色', '1', null, '144', '3', 'roleedit', '0', '0');
INSERT INTO `g_node` VALUES ('355', 'role_del', '删除角色', '1', null, '144', '3', 'role_del', '0', '0');
INSERT INTO `g_node` VALUES ('356', 'role_sort', '角色排序', '1', null, '144', '3', 'role_sort', '0', '0');
INSERT INTO `g_node` VALUES ('357', 'access', '权限列表', '1', null, '144', '3', 'access', '0', '0');
INSERT INTO `g_node` VALUES ('358', 'access_edit', '权限修改', '1', null, '144', '3', 'access_edit', '0', '0');
INSERT INTO `g_node` VALUES ('359', 'User', '用户授权', '1', '', '60', '3', '', '0', '0');
INSERT INTO `g_node` VALUES ('362', 'Report', '报表管理', '1', '', '209', '2', 'Report/index', '0', '2');

-- ----------------------------
-- Table structure for `g_role`
-- ----------------------------
DROP TABLE IF EXISTS `g_role`;
CREATE TABLE `g_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=23 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_role
-- ----------------------------
INSERT INTO `g_role` VALUES ('1', '超级管理员', '0', '1', '50', '超级管理员组拥有系统一切权限');
INSERT INTO `g_role` VALUES ('21', '测试角色', '0', '1', '0', '');
INSERT INTO `g_role` VALUES ('22', '管理员', '0', '1', '0', '1');

-- ----------------------------
-- Table structure for `g_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `g_role_user`;
CREATE TABLE `g_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 g_role_user
-- ----------------------------
INSERT INTO `g_role_user` VALUES ('1', '1');

-- ----------------------------
-- Table structure for `g_run`
-- ----------------------------
DROP TABLE IF EXISTS `g_run`;
CREATE TABLE `g_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` 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流程中，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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_run
-- ----------------------------

-- ----------------------------
-- Table structure for `g_run_cache`
-- ----------------------------
DROP TABLE IF EXISTS `g_run_cache`;
CREATE TABLE `g_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 g_run_cache
-- ----------------------------

-- ----------------------------
-- Table structure for `g_run_log`
-- ----------------------------
DROP TABLE IF EXISTS `g_run_log`;
CREATE TABLE `g_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,
  `art` longtext,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `run_id` (`run_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_run_log
-- ----------------------------

-- ----------------------------
-- Table structure for `g_run_process`
-- ----------------------------
DROP TABLE IF EXISTS `g_run_process`;
CREATE TABLE `g_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 g_run_process
-- ----------------------------

-- ----------------------------
-- Table structure for `g_run_sign`
-- ----------------------------
DROP TABLE IF EXISTS `g_run_sign`;
CREATE TABLE `g_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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_run_sign
-- ----------------------------

-- ----------------------------
-- Table structure for `g_sys_logs`
-- ----------------------------
DROP TABLE IF EXISTS `g_sys_logs`;
CREATE TABLE `g_sys_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `ip` varchar(255) DEFAULT NULL COMMENT 'IP地址',
  `os` varchar(255) DEFAULT NULL COMMENT '操作系统',
  `url` varchar(255) DEFAULT NULL COMMENT '网址',
  `data` varchar(255) DEFAULT NULL COMMENT '数据',
  `utime` int(11) DEFAULT NULL COMMENT '记录时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_sys_logs
-- ----------------------------

-- ----------------------------
-- Table structure for `g_user`
-- ----------------------------
DROP TABLE IF EXISTS `g_user`;
CREATE TABLE `g_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=12 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of g_user
-- ----------------------------
INSERT INTO `g_user` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', '15905996213', '632522043@qq.com', '1', '1', '超级管理员账号拥有一切系统权限', '1543572232', '120.37.77.124', '128', '新建用户', '1516365994');

-- ----------------------------
-- Table structure for `g_userlog`
-- ----------------------------
DROP TABLE IF EXISTS `g_userlog`;
CREATE TABLE `g_userlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `login_ip` varchar(255) DEFAULT NULL,
  `login_location` varchar(255) DEFAULT NULL,
  `login_browser` varchar(255) DEFAULT NULL,
  `login_time` int(11) DEFAULT NULL,
  `login_os` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of g_userlog
-- ----------------------------

-- ----------------------------
-- View structure for `pms_view_paper`
-- ----------------------------
DROP VIEW IF EXISTS `pms_view_paper`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `pms_view_paper` AS select `a`.`id` AS `id`,`a`.`p_name` AS `p_name`,`a`.`p_type` AS `p_t`,`a`.`p_no` AS `p_no`,`a`.`p_etime` AS `p_etime`,`a`.`p_cfc` AS `p_cfc`,group_concat(`b`.`p_zjtype` separator ',') AS `p_zjtypes`,group_concat(`b`.`p_etime` separator ',') AS `p_etimes`,group_concat(`b`.`p_type` separator ',') AS `p_type`,`a`.`p_zjtype` AS `p_zjtype`,`a`.`is_zj` AS `is_zj`,`a`.`is_wj` AS `is_wj`,`a`.`is_zc` AS `is_zc`,`a`.`is_del` AS `is_del` from (`pms_paper` `a` left join `pms_paper_d` `b` on((`a`.`id` = `b`.`pid`))) group by `a`.`id` ;

-- ----------------------------
-- View structure for `role_node`
-- ----------------------------
DROP VIEW IF EXISTS `role_node`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `role_node` AS select `gadmin`.`pms_access`.`role_id` AS `role_id`,`gadmin`.`pms_access`.`node_id` AS `node_id`,`gadmin`.`pms_node`.`title` AS `title`,`gadmin`.`pms_role`.`name` AS `name` from ((`pms_access` join `pms_node` on((`gadmin`.`pms_node`.`id` = `gadmin`.`pms_access`.`node_id`))) join `pms_role` on((`gadmin`.`pms_role`.`id` = `gadmin`.`pms_access`.`role_id`))) ;