-- phpMyAdmin SQL Dump
-- version 4.2.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2015-04-19 16:38:42
-- 服务器版本： 5.6.20
-- PHP Version: 5.6.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `team`
--

-- --------------------------------------------------------

--
-- 表的结构 `pes_department`
--

CREATE TABLE IF NOT EXISTS `pes_department` (
`department_id` int(11) NOT NULL,
  `department_listsort` int(11) NOT NULL,
  `department_lang` tinyint(4) NOT NULL,
  `department_url` varchar(255) NOT NULL,
  `department_createtime` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `department_header` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_department`
--

INSERT INTO `pes_department` (`department_id`, `department_listsort`, `department_lang`, `department_url`, `department_createtime`, `department_name`, `department_header`) VALUES
(1, 0, 0, '/Department/view/id/1.html', 0, 'IT部', '1'),
(2, 0, 0, '/Department/view/id/2.html', 0, '人事部', '3'),
(3, 0, 0, '/Department/view/id/3.html', 0, '销售部', '4');

-- --------------------------------------------------------

--
-- 表的结构 `pes_dynamic`
--

CREATE TABLE IF NOT EXISTS `pes_dynamic` (
`dynamic_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '所属用户',
  `task_id` int(11) NOT NULL COMMENT '任务',
  `dynamic_type` tinyint(1) NOT NULL COMMENT '动态类型:1 发起新的任务 2 执行了新任务 3 提交了任务 4.完成了任务',
  `dynamic_time` int(11) NOT NULL COMMENT '时间'
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='用户动态';

--
-- 转存表中的数据 `pes_dynamic`
--

INSERT INTO `pes_dynamic` (`dynamic_id`, `user_id`, `task_id`, `dynamic_type`, `dynamic_time`) VALUES
(1, 1, 27, 1, 1428285200),
(2, 1, 28, 1, 1428285215),
(3, 1, 28, 2, 1428285225),
(4, 1, 28, 3, 1428285238),
(5, 1, 28, 3, 1428285251),
(6, 1, 28, 4, 1428285284),
(7, 3, 23, 2, 1428285356),
(8, 3, 23, 3, 1428285358),
(9, 3, 23, 4, 1428285363),
(10, 7, 29, 1, 1428324912),
(11, 4, 19, 4, 1428591123),
(12, 1, 30, 1, 1428591217),
(13, 1, 31, 1, 1429000256),
(14, 2, 31, 2, 1429000531),
(15, 2, 31, 3, 1429000648),
(16, 2, 31, 3, 1429000711),
(17, 2, 31, 4, 1429000722),
(18, 1, 32, 1, 1429409567),
(19, 1, 33, 1, 1429409621),
(20, 1, 33, 2, 1429409878),
(21, 1, 33, 3, 1429410026),
(22, 1, 33, 3, 1429410043),
(23, 1, 33, 3, 1429410065),
(24, 1, 33, 3, 1429410252),
(25, 1, 33, 4, 1429410260),
(26, 1, 34, 1, 1429430160),
(27, 4, 35, 1, 1429430644),
(28, 4, 36, 1, 1429430723),
(29, 3, 37, 1, 1429430779),
(30, 3, 38, 1, 1429430806),
(31, 2, 39, 1, 1429430924);

-- --------------------------------------------------------

--
-- 表的结构 `pes_field`
--

CREATE TABLE IF NOT EXISTS `pes_field` (
`field_id` int(11) NOT NULL,
  `model_id` int(11) NOT NULL,
  `field_name` varchar(128) NOT NULL,
  `display_name` varchar(128) NOT NULL,
  `field_type` varchar(128) NOT NULL,
  `field_option` text NOT NULL,
  `field_default` varchar(128) NOT NULL,
  `field_required` tinyint(4) NOT NULL,
  `field_message` varchar(128) NOT NULL,
  `field_listsort` int(11) NOT NULL,
  `field_status` tinyint(4) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_field`
--

INSERT INTO `pes_field` (`field_id`, `model_id`, `field_name`, `display_name`, `field_type`, `field_option`, `field_default`, `field_required`, `field_message`, `field_listsort`, `field_status`) VALUES
(1, 6, 'status', '状态', 'radio', '{"\\u7981\\u7528":"0","\\u542f\\u7528":"1"}', '1', 1, '', 100, 1),
(2, 6, 'listsort', '排序', 'text', '', '', 0, '', 98, 1),
(3, 6, 'createtime', '发布时间', 'date', '', '', 0, '', 99, 1),
(4, 7, 'status', '状态', 'radio', '{"\\u7981\\u7528":"0","\\u542f\\u7528":"1"}', '1', 1, '', 100, 1),
(5, 7, 'account', '会员帐号', 'text', '', '', 1, '', 3, 1),
(6, 7, 'password', '会员密码', 'text', '', '', 0, '', 4, 1),
(7, 7, 'mail', '邮箱地址', 'text', '', '', 1, '', 5, 1),
(8, 7, 'name', '会员名称', 'text', '', '', 1, '', 6, 1),
(9, 7, 'group_id', '用户组', 'select', '', '', 1, '', 1, 1),
(10, 6, 'name', '用户组名称', 'text', '', '', 1, '', 1, 1),
(11, 8, 'status', '状态', 'radio', '{"\\u7981\\u7528":"0","\\u542f\\u7528":"1"}', '1', 1, '', 100, 1),
(12, 8, 'listsort', '排序', 'text', '', '', 0, '', 98, 1),
(14, 8, 'title', '项目名称', 'text', '', '', 1, '', 1, 1),
(15, 9, 'status', '状态', 'text', '', '', 0, '', 97, 1),
(16, 9, 'listsort', '排序', 'text', '', '', 0, '', 98, 1),
(17, 9, 'createtime', '发布时间', 'date', '', '', 1, '', 99, 1),
(18, 9, 'accept_id', '属性部门', 'text', '', '', 1, '', 2, 1),
(19, 9, 'title', '任务标题', 'text', '', '', 1, '', 1, 1),
(20, 9, 'department_id', '接收部门ID', 'text', '', '', 1, '', 3, 1),
(21, 9, 'user_id', '接收用户ID', 'text', '', '', 0, '', 5, 1),
(22, 9, 'create_id', '任务发起者', 'text', '', '', 1, '', 4, 1),
(24, 9, 'content', '任务说明', 'editor', '', '', 1, '', 6, 1),
(25, 9, 'file', '任务附件', 'file', '', '', 0, '', 7, 1),
(26, 9, 'completetime', '完成时间', 'date', '', '', 0, '', 104, 1),
(27, 9, 'estimatetime', '预计时间', 'date', '', '', 0, '', 102, 1),
(28, 9, 'actiontime', '执行时间', 'date', '', '', 0, '', 103, 1),
(30, 10, 'listsort', '排序', 'text', '', '', 0, '', 98, 1),
(31, 10, 'createtime', '发布时间', 'date', '', '', 0, '', 99, 1),
(32, 10, 'name', '部门名称', 'text', '', '', 1, '', 1, 1),
(33, 10, 'header', '负责人', 'text', '', '', 0, '', 2, 1),
(34, 7, 'department_id', '部门ID', 'text', '', '', 1, '', 2, 1),
(35, 9, 'priority', '优先级', 'text', '', '', 1, '', 8, 1),
(36, 9, 'expecttime', '期望完成时间', 'date', '', '', 1, '', 101, 1),
(37, 9, 'project', '任务项目', 'text', '', '', 1, '', 3, 1),
(38, 9, 'read_permission', '阅读权限', 'text', '', '', 0, '', 9, 1),
(44, 12, 'read', '是否阅读', 'text', '', '', 0, '', 0, 1),
(46, 9, 'mail', '是否发送邮件', 'select', '{"\\u5426":"0","\\u662f":"1"}', '', 1, '', 96, 1),
(47, 13, 'status', '状态', 'radio', '{"\\u7981\\u7528":"0","\\u542f\\u7528":"1"}', '1', 0, '', 100, 1),
(48, 13, 'listsort', '排序', 'text', '', '', 0, '', 98, 1),
(49, 13, 'createtime', '发布时间', 'date', '', '', 0, '', 99, 1),
(50, 13, 'title', '节点名称', 'text', '', '', 1, '', 1, 1),
(51, 13, 'parent', '父类节点', 'select', '', '', 0, '', 2, 1),
(52, 13, 'verify', '是否验证权限', 'select', '', '', 0, '', 5, 1),
(53, 13, 'msg', '验证提示信息', 'text', '', '', 0, '', 6, 1),
(54, 13, 'method_type', '操作方法', 'text', '', '', 0, '', 3, 1),
(55, 13, 'value', '节点匹配值', 'text', '', '', 0, '', 4, 1),
(56, 13, 'check_value', '节点验证名称', 'text', '', '', 0, '', 7, 1);

-- --------------------------------------------------------

--
-- 表的结构 `pes_menu`
--

CREATE TABLE IF NOT EXISTS `pes_menu` (
`menu_id` int(11) NOT NULL,
  `menu_name` varchar(128) NOT NULL,
  `menu_pid` int(11) NOT NULL,
  `menu_icon` varchar(128) NOT NULL,
  `menu_url` varchar(255) NOT NULL,
  `menu_listsort` tinyint(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_menu`
--

INSERT INTO `pes_menu` (`menu_id`, `menu_name`, `menu_pid`, `menu_icon`, `menu_url`, `menu_listsort`) VALUES
(1, '基础设置', 0, 'am-icon-tachometer', '', 0),
(4, '系统首页', 1, 'am-icon-info-circle', 'Team-Index-dynamic', 0),
(8, '后台菜单', 1, 'am-icon-align-justify', 'Team-Index-menuList', 0),
(9, '模型管理', 0, 'am-icon-sitemap', 'Team-Model-index', 0),
(10, '模型列表', 9, 'am-icon-list-alt', 'Team-Model-index', 0),
(11, '清空缓存', 1, 'am-icon-refresh', 'Team-Index-clear', 0),
(13, '内容管理', 0, 'am-icon-database', '', 0),
(15, '会员管理', 0, 'am-icon-user', '', 0),
(16, '会员列表', 15, 'am-icon-user', 'Team-User-index', 99),
(18, '用户组', 15, 'am-icon-group', 'Team-User_group-index', 97),
(19, '高级设置', 0, 'am-icon-wrench', '', 0),
(20, '系统设置', 19, 'am-icon-server', 'Team-Setting-action', 0),
(38, '项目列表', 13, 'am-icon-cubes', 'Team-Project-index', 0),
(39, '全体任务列表', 41, 'am-icon-tasks', 'Team-Task-index', 3),
(40, '部门列表', 15, 'am-icon-legal', 'Team-Department-index', 96),
(41, '个人中心', 0, 'am-icon-home', '', 0),
(42, '我的任务', 41, 'am-icon-tags', 'Team-Task-my', 99),
(44, '退出系统', 41, 'am-icon-sign-out', 'Team-Index-logout', 0),
(45, '待审核列表', 41, 'am-icon-check-square-o', 'Team-Task-check', 96),
(46, '我的报表', 41, 'am-icon-pencil-square-o', 'Team-Report-my', 98),
(47, '系统更新', 19, 'am-icon-refresh', 'Team-Setting-upgrade', 0),
(48, '提取报表', 41, 'am-icon-newspaper-o', 'Team-Report-extract', 97),
(49, '权限节点', 15, 'am-icon-unlink', 'Team-Node-index', 98);

-- --------------------------------------------------------

--
-- 表的结构 `pes_model`
--

CREATE TABLE IF NOT EXISTS `pes_model` (
`model_id` int(11) NOT NULL,
  `model_name` varchar(128) NOT NULL,
  `lang_key` varchar(128) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `is_search` tinyint(11) NOT NULL COMMENT '允许搜索',
  `model_attr` tinyint(1) NOT NULL COMMENT '模型属性 1:前台(含前台) 2:后台'
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_model`
--

INSERT INTO `pes_model` (`model_id`, `model_name`, `lang_key`, `status`, `is_search`, `model_attr`) VALUES
(6, 'User_group', '用户组列表', 1, 0, 2),
(7, 'User', '会员列表', 1, 0, 2),
(8, 'Project', '项目列表', 1, 1, 2),
(9, 'Task', '任务列表', 1, 1, 1),
(10, 'Department', '部门列表', 1, 1, 2),
(12, 'update_list', '更新提示列表', 0, 0, 2),
(13, 'Node', '权限节点', 1, 0, 2);

-- --------------------------------------------------------

--
-- 表的结构 `pes_node`
--

CREATE TABLE IF NOT EXISTS `pes_node` (
`node_id` int(11) NOT NULL,
  `node_listsort` int(11) NOT NULL,
  `node_status` tinyint(4) NOT NULL,
  `node_lang` tinyint(4) NOT NULL,
  `node_url` varchar(255) NOT NULL,
  `node_createtime` int(11) NOT NULL,
  `node_title` varchar(255) NOT NULL,
  `node_parent` int(11) NOT NULL,
  `node_verify` int(11) NOT NULL,
  `node_msg` varchar(255) NOT NULL,
  `node_method_type` varchar(255) NOT NULL,
  `node_value` varchar(255) NOT NULL,
  `node_check_value` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_node`
--

INSERT INTO `pes_node` (`node_id`, `node_listsort`, `node_status`, `node_lang`, `node_url`, `node_createtime`, `node_title`, `node_parent`, `node_verify`, `node_msg`, `node_method_type`, `node_value`, `node_check_value`) VALUES
(1, 0, 1, 0, '/Node/view/id/1.html', 0, '用户管理', 0, 0, '', '', 'User', ''),
(2, 0, 1, 0, '/Node/view/id/2.html', 0, '用户列表', 1, 1, '', 'GET', 'index', 'TeamGETUserindex'),
(3, 0, 1, 0, '/Node/view/id/3.html', 0, '新增/编辑用户', 1, 1, '', 'GET', 'action', 'TeamGETUseraction'),
(4, 0, 1, 0, '/Node/view/id/4.html', 0, '添加用户', 1, 1, '', 'POST', 'action', 'TeamPOSTUseraction'),
(5, 0, 1, 0, '/Node/view/id/5.html', 0, '更新用户', 1, 1, '', 'PUT', 'action', 'TeamPUTUseraction'),
(6, 0, 1, 0, '/Node/view/id/6.html', 0, '删除用户', 1, 1, '', 'DELETE', 'action', 'TeamDELETEUseraction'),
(7, 0, 1, 0, '/Node/view/id/7.html', 0, '用户组管理', 0, 0, '', '', 'User_group', ''),
(8, 0, 1, 0, '/Node/view/id/8.html', 0, '部门管理', 0, 0, '', '', 'Department', ''),
(9, 0, 1, 0, '/Node/view/id/9.html', 0, '新增/编辑部门', 8, 1, '', 'GET', 'action', 'TeamGETDepartmentaction'),
(10, 0, 1, 0, '/Node/view/id/10.html', 0, '添加部门', 8, 1, '', 'POST', 'action', 'TeamPOSTDepartmentaction'),
(11, 0, 1, 0, '/Node/view/id/11.html', 0, '更新部门', 8, 1, '', 'PUT', 'action', 'TeamPUTDepartmentaction'),
(12, 0, 1, 0, '/Node/view/id/12.html', 0, '删除部门', 8, 1, '', 'DELETE', 'action', 'TeamDELETEDepartmentaction'),
(13, 0, 1, 0, '/Node/view/id/13.html', 0, '项目管理', 0, 0, '', '', 'Project', ''),
(14, 0, 1, 0, '/Node/view/id/14.html', 0, '用户组列表', 7, 1, '', 'GET', 'index', 'TeamGETUser_groupindex'),
(15, 0, 1, 0, '/Node/view/id/15.html', 0, '新增/编辑用户组', 7, 1, '', 'GET', 'action', 'TeamGETUser_groupaction'),
(16, 0, 1, 0, '/Node/view/id/16.html', 0, '部门列表', 8, 1, '', 'GET', 'index', 'TeamGETDepartmentindex'),
(17, 0, 1, 0, '/Node/view/id/17.html', 0, '添加用户组', 7, 1, '', 'POST', 'action', 'TeamPOSTUser_groupaction'),
(18, 0, 1, 0, '/Node/view/id/18.html', 0, '更新用户组', 7, 1, '', 'PUT', 'action', 'TeamPUTUser_groupaction'),
(19, 0, 1, 0, '/Node/view/id/19.html', 0, '删除用户组', 7, 1, '', 'DELETE', 'action', 'TeamDELETEUser_groupaction'),
(20, 0, 1, 0, '/Node/view/id/20.html', 0, '项目列表', 13, 1, '', 'GET', 'index', 'TeamGETProjectindex'),
(21, 0, 1, 0, '/Node/view/id/21.html', 0, '新增/编辑项目', 13, 1, '', 'GET', 'action', 'TeamGETProjectaction'),
(22, 0, 1, 0, '/Node/view/id/22.html', 0, '添加项目', 13, 1, '', 'POST', 'action', 'TeamPOSTProjectaction'),
(23, 0, 1, 0, '/Node/view/id/23.html', 0, '更新项目', 13, 1, '', 'PUT', 'action', 'TeamPUTProjectaction'),
(24, 0, 1, 0, '/Node/view/id/24.html', 0, '删除项目', 13, 1, '', 'DELETE', 'action', 'TeamDELETEProjectaction'),
(25, 0, 1, 0, '/Node/view/id/25.html', 0, '首页设置', 0, 0, '', '', 'Index', ''),
(26, 0, 1, 0, '/Node/view/id/26.html', 0, '菜单列表', 25, 1, '', 'GET', 'menuList', 'TeamGETIndexmenuList'),
(27, 0, 1, 0, '/Node/view/id/27.html', 0, '新增/编辑菜单', 25, 1, '', 'GET', 'menuAction', 'TeamGETIndexmenuAction'),
(28, 0, 1, 0, '/Node/view/id/28.html', 0, '更新菜单', 25, 1, '', 'PUT', 'menuAction', 'TeamPUTIndexmenuAction'),
(29, 0, 1, 0, '/Node/view/id/29.html', 0, '删除菜单', 25, 1, '', 'DELETE', 'menuAction', 'TeamDELETEIndexmenuAction'),
(30, 0, 1, 0, '/Node/view/id/30.html', 0, '模型管理', 0, 0, '', '', 'Model', ''),
(31, 0, 1, 0, '/Node/view/id/31.html', 0, '模型列表', 30, 1, '', 'GET', 'index', 'TeamGETModelindex'),
(32, 0, 1, 0, '/Node/view/id/32.html', 0, '新增/编辑模型', 30, 1, '', 'GET', 'action', 'TeamGETModelaction'),
(33, 0, 1, 0, '/Node/view/id/33.html', 0, '模型字段列表', 30, 1, '', 'GET', 'fieldList', 'TeamGETModelfieldList'),
(34, 0, 1, 0, '/Node/view/id/34.html', 0, '新增/编辑模型字段', 30, 1, '', 'GET', 'fieldAction', 'TeamGETModelfieldAction'),
(35, 0, 1, 0, '/Node/view/id/35.html', 0, '添加模型', 30, 1, '', 'POST', 'action', 'TeamPOSTModelaction'),
(36, 0, 1, 0, '/Node/view/id/36.html', 0, '添加模型字段', 30, 1, '', 'POST', 'fieldAction', 'TeamPOSTModelfieldAction'),
(37, 0, 1, 0, '/Node/view/id/37.html', 0, '更新模型', 30, 1, '', 'PUT', 'action', 'TeamPUTModelaction'),
(38, 0, 1, 0, '/Node/view/id/38.html', 0, '更新模型字段', 30, 1, '', 'PUT', 'fieldAction', 'TeamPUTModelfieldAction'),
(39, 0, 1, 0, '/Node/view/id/39.html', 0, '删除模型', 30, 1, '', 'DELETE', 'action', 'TeamDELETEModelaction'),
(40, 0, 1, 0, '/Node/view/id/40.html', 0, '删除模型字段', 30, 1, '', 'DELETE', 'fieldAction', 'TeamDELETEModelfieldAction'),
(41, 0, 1, 0, '/Node/view/id/41.html', 0, '节点管理', 0, 0, '', '', 'Node', ''),
(42, 0, 1, 0, '/Node/view/id/42.html', 0, '节点列表', 41, 1, '', 'GET', 'index', 'TeamGETNodeindex'),
(43, 0, 1, 0, '/Node/view/id/43.html', 0, '新增/编辑节点', 41, 1, '', 'GET', 'action', 'TeamGETNodeaction'),
(44, 0, 1, 0, '/Node/view/id/44.html', 0, '添加节点', 41, 1, '', 'POST', 'action', 'TeamPOSTNodeaction'),
(45, 0, 1, 0, '/Node/view/id/45.html', 0, '更新节点', 41, 1, '', 'PUT', 'action', 'TeamPUTNodeaction'),
(46, 0, 1, 0, '/Node/view/id/46.html', 0, '删除节点', 41, 1, '', 'DELETE', 'action', 'TeamDELETENodeaction'),
(47, 0, 1, 0, '/Node/view/id/47.html', 0, '系统设置', 0, 0, '', '', 'Setting', ''),
(48, 0, 1, 0, '/Node/view/id/48.html', 0, '查看基础设置', 47, 1, '', 'GET', 'action', 'TeamGETSettingaction'),
(49, 0, 1, 0, '/Node/view/id/49.html', 0, '查看更新', 47, 1, '', 'GET', 'upgrade', 'TeamGETSettingupgrade'),
(50, 0, 1, 0, '/Node/view/id/50.html', 0, '更新系统设置', 47, 1, '', 'PUT', 'action', 'TeamPUTSettingaction'),
(51, 0, 1, 0, '/Node/view/id/51.html', 0, '下载更新文件', 47, 1, '', 'PUT', 'downloadUpgradeFile', 'TeamPUTSettingdownloadUpgradeFile'),
(52, 0, 1, 0, '/Node/view/id/52.html', 0, '安装更新文件', 47, 1, '', 'PUT', 'installUpdateFile', 'TeamPUTSettinginstallUpdateFile'),
(53, 0, 1, 0, '/Node/view/id/53.html', 0, '安装数据库更新', 47, 1, '', 'PUT', 'installUpdateSql', 'TeamPUTSettinginstallUpdateSql'),
(54, 0, 1, 0, '/Node/view/id/54.html', 0, '报表管理', 0, 0, '', '', 'Report', ''),
(55, 0, 1, 0, '/Node/view/id/55.html', 0, '提取报表', 54, 1, '', 'GET', 'extract', 'TeamGETReportextract'),
(56, 0, 1, 0, '/Node/view/id/56.html', 0, '我的报表', 54, 0, '', 'GET', 'my', 'TeamGETReportmy'),
(57, 0, 1, 0, '/Node/view/id/57.html', 0, '查看报表', 54, 0, '', 'GET', 'view', 'TeamGETReportview'),
(58, 0, 1, 0, '/Node/view/id/58.html', 0, '访问系统', 25, 0, '', 'GET', 'index', 'TeamGETIndexindex'),
(59, 0, 1, 0, '/Node/view/id/59.html', 0, '全体动态', 25, 0, '', 'GET', 'dynamic', 'TeamGETIndexdynamic'),
(60, 0, 1, 0, '/Node/view/id/60.html', 0, '添加报表', 54, 0, '', 'POST', 'action', 'TeamPOSTReportaction'),
(61, 0, 1, 0, '/Node/view/id/61.html', 0, '任务管理', 0, 0, '', '', 'Task', ''),
(62, 0, 1, 0, '/Node/view/id/62.html', 0, '任务列表', 61, 0, '', 'GET', 'index', 'TeamGETTaskindex'),
(63, 0, 1, 0, '/Node/view/id/63.html', 0, '发表新任务', 61, 0, '', 'GET', 'action', 'TeamGETTaskaction'),
(64, 0, 1, 0, '/Node/view/id/64.html', 0, '我的任务', 61, 0, '', 'GET', 'my', 'TeamGETTaskmy'),
(65, 0, 1, 0, '/Node/view/id/65.html', 0, '待审核任务列表', 61, 0, '', 'GET', 'check', 'TeamGETTaskcheck'),
(66, 0, 1, 0, '/Node/view/id/66.html', 0, '查看任务', 61, 0, '', 'GET', 'view', 'TeamGETTaskview'),
(67, 0, 1, 0, '/Node/view/id/67.html', 0, '添加新任务', 61, 0, '', 'POST', 'action', 'TeamPOSTTaskaction'),
(68, 0, 1, 0, '/Node/view/id/68.html', 0, '任务指派', 61, 0, '', 'PUT', 'accept', 'TeamPUTTaskaccept'),
(69, 0, 1, 0, '/Node/view/id/69.html', 0, '执行任务', 61, 0, '', 'PUT', 'begin', 'TeamPUTTaskbegin'),
(70, 0, 1, 0, '/Node/view/id/70.html', 0, '提交任务日志', 61, 0, '', 'PUT', 'diary', 'TeamPUTTaskdiary'),
(71, 0, 1, 0, '/Node/view/id/71.html', 0, '更改任务状态', 61, 0, '', 'PUT', 'check', 'TeamPUTTaskcheck'),
(72, 0, 1, 0, '/Node/view/id/72.html', 0, '删除任务', 61, 1, '', 'DELETE', 'action', 'TeamDELETETaskaction'),
(73, 0, 1, 0, '/Node/view/id/73.html', 0, '设置用户组节点', 7, 1, '', 'GET', 'setNode', 'TeamGETUser_groupsetNode'),
(74, 0, 1, 0, '/Node/view/id/74.html', 0, '更新用户组节点', 7, 1, '', 'PUT', 'setNode', 'TeamPUTUser_groupsetNode'),
(75, 0, 1, 0, '/Node/view/id/75.html', 0, '设置用户组菜单', 7, 1, '', 'GET', 'setMenu', 'TeamGETUser_groupsetMenu'),
(76, 0, 1, 0, '/Node/view/id/76.html', 0, '更新用户组菜单', 7, 1, '', 'PUT', 'setMenu', 'TeamPUTUser_groupsetMenu');

-- --------------------------------------------------------

--
-- 表的结构 `pes_node_group`
--

CREATE TABLE IF NOT EXISTS `pes_node_group` (
`node_group_id` int(11) NOT NULL,
  `user_group_id` int(11) NOT NULL COMMENT '用户组ID',
  `node_id` int(11) NOT NULL COMMENT '节点ID'
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_node_group`
--

INSERT INTO `pes_node_group` (`node_group_id`, `user_group_id`, `node_id`) VALUES
(79, 2, 58),
(80, 2, 59),
(81, 2, 56),
(82, 2, 57),
(83, 2, 60),
(84, 2, 62),
(85, 2, 63),
(86, 2, 64),
(87, 2, 65),
(88, 2, 66),
(89, 2, 67),
(90, 2, 68),
(91, 2, 69),
(92, 2, 70),
(93, 2, 71),
(94, 3, 58),
(95, 3, 59),
(96, 3, 55),
(97, 3, 56),
(98, 3, 57),
(99, 3, 60),
(100, 3, 62),
(101, 3, 63),
(102, 3, 64),
(103, 3, 65),
(104, 3, 66),
(105, 3, 67),
(106, 3, 68),
(107, 3, 69),
(108, 3, 70),
(109, 3, 71),
(178, 1, 2),
(179, 1, 3),
(180, 1, 4),
(181, 1, 5),
(182, 1, 6),
(183, 1, 14),
(184, 1, 15),
(185, 1, 17),
(186, 1, 18),
(187, 1, 19),
(188, 1, 73),
(189, 1, 74),
(190, 1, 75),
(191, 1, 76),
(192, 1, 9),
(193, 1, 10),
(194, 1, 11),
(195, 1, 12),
(196, 1, 16),
(197, 1, 20),
(198, 1, 21),
(199, 1, 22),
(200, 1, 23),
(201, 1, 24),
(202, 1, 26),
(203, 1, 27),
(204, 1, 28),
(205, 1, 29),
(206, 1, 58),
(207, 1, 59),
(208, 1, 31),
(209, 1, 32),
(210, 1, 33),
(211, 1, 34),
(212, 1, 35),
(213, 1, 36),
(214, 1, 37),
(215, 1, 38),
(216, 1, 39),
(217, 1, 40),
(218, 1, 42),
(219, 1, 43),
(220, 1, 44),
(221, 1, 45),
(222, 1, 46),
(223, 1, 48),
(224, 1, 49),
(225, 1, 50),
(226, 1, 51),
(227, 1, 52),
(228, 1, 53),
(229, 1, 55),
(230, 1, 56),
(231, 1, 57),
(232, 1, 60),
(233, 1, 62),
(234, 1, 63),
(235, 1, 64),
(236, 1, 65),
(237, 1, 66),
(238, 1, 67),
(239, 1, 68),
(240, 1, 69),
(241, 1, 70),
(242, 1, 71),
(243, 1, 72);

-- --------------------------------------------------------

--
-- 表的结构 `pes_notice`
--

CREATE TABLE IF NOT EXISTS `pes_notice` (
`notice_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `notice_type` tinyint(1) NOT NULL COMMENT '通知类型 1:收到新任务 2.指派审核任务 3.待审核任务 4.待修改的任务 5.部门待审核指派任务 6.完成的任务',
  `notice_read` tinyint(1) NOT NULL COMMENT '是否已读：0 未读 1 已读',
  `task_mail` tinyint(1) NOT NULL COMMENT '本任务全程是否发送邮件 0:不 1:发',
  `mail_send` tinyint(1) NOT NULL COMMENT '邮件是否已发送 0：未 1：已'
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='系统信息消息';

--
-- 转存表中的数据 `pes_notice`
--

INSERT INTO `pes_notice` (`notice_id`, `user_id`, `task_id`, `notice_type`, `notice_read`, `task_mail`, `mail_send`) VALUES
(1, 4, 21, 3, 0, 0, 0),
(2, 1, 21, 3, 1, 0, 0),
(3, 1, 21, 4, 1, 0, 0),
(4, 4, 21, 3, 0, 0, 0),
(5, 1, 21, 3, 1, 0, 0),
(6, 1, 21, 4, 1, 0, 0),
(7, 4, 21, 3, 0, 0, 0),
(8, 1, 21, 3, 1, 0, 0),
(9, 1, 21, 4, 1, 0, 0),
(10, 4, 21, 3, 0, 0, 0),
(11, 1, 21, 3, 1, 0, 0),
(12, 1, 21, 4, 1, 0, 0),
(13, 4, 21, 3, 0, 0, 0),
(14, 1, 21, 3, 1, 0, 0),
(15, 1, 21, 6, 1, 0, 0),
(16, 1, 17, 3, 1, 0, 0),
(17, 3, 17, 3, 1, 0, 0),
(18, 1, 17, 4, 1, 0, 0),
(19, 4, 20, 3, 0, 0, 0),
(20, 1, 20, 3, 1, 0, 0),
(21, 4, 22, 5, 0, 0, 0),
(22, 2, 22, 2, 1, 0, 0),
(23, 4, 22, 2, 0, 0, 0),
(24, 3, 23, 5, 1, 0, 0),
(25, 4, 23, 2, 0, 0, 0),
(26, 3, 23, 2, 1, 0, 0),
(27, 5, 24, 1, 0, 0, 0),
(28, 4, 24, 2, 0, 0, 0),
(29, 4, 25, 1, 1, 0, 0),
(30, 4, 25, 2, 0, 0, 0),
(31, 1, 26, 5, 1, 0, 0),
(32, 4, 26, 2, 0, 0, 0),
(33, 1, 26, 2, 1, 0, 0),
(34, 1, 20, 4, 1, 0, 0),
(35, 5, 18, 3, 0, 0, 0),
(36, 3, 18, 3, 1, 0, 0),
(37, 5, 19, 3, 0, 0, 0),
(38, 4, 19, 3, 0, 0, 0),
(39, 1, 19, 3, 1, 0, 0),
(40, 3, 27, 5, 1, 0, 0),
(41, 1, 27, 2, 1, 0, 0),
(42, 3, 27, 2, 1, 0, 0),
(43, 1, 28, 1, 1, 0, 0),
(44, 1, 28, 2, 1, 0, 0),
(45, 1, 28, 3, 1, 0, 0),
(46, 1, 28, 4, 1, 0, 0),
(47, 1, 28, 3, 1, 0, 0),
(48, 1, 28, 6, 1, 0, 0),
(49, 3, 23, 1, 0, 0, 0),
(50, 4, 23, 3, 0, 0, 0),
(51, 3, 23, 3, 0, 0, 0),
(52, 3, 23, 6, 0, 0, 0),
(53, 3, 29, 1, 0, 0, 0),
(54, 7, 29, 2, 1, 0, 0),
(55, 1, 29, 2, 1, 0, 0),
(56, 1, 1, 4, 1, 0, 0),
(57, 4, 19, 6, 0, 0, 0),
(58, 3, 30, 5, 0, 0, 0),
(59, 1, 30, 2, 1, 0, 0),
(60, 3, 30, 2, 0, 0, 0),
(61, 2, 31, 1, 1, 0, 0),
(62, 1, 31, 2, 1, 0, 0),
(63, 4, 31, 2, 0, 0, 0),
(64, 1, 31, 3, 1, 1, 1),
(65, 4, 31, 3, 0, 1, 1),
(66, 2, 31, 4, 1, 1, 1),
(67, 1, 31, 3, 1, 1, 1),
(68, 4, 31, 3, 0, 1, 1),
(69, 2, 31, 6, 1, 1, 1),
(70, 4, 32, 5, 0, 0, 0),
(71, 1, 32, 2, 1, 0, 0),
(72, 2, 32, 2, 0, 0, 0),
(73, 4, 32, 2, 0, 0, 0),
(74, 1, 33, 1, 1, 0, 0),
(75, 1, 33, 2, 1, 0, 0),
(76, 1, 33, 3, 1, 0, 0),
(77, 1, 33, 4, 1, 0, 0),
(78, 1, 33, 3, 1, 0, 0),
(79, 1, 33, 4, 1, 0, 0),
(80, 1, 33, 3, 1, 0, 0),
(81, 1, 33, 4, 1, 0, 0),
(82, 1, 33, 3, 1, 0, 0),
(83, 1, 33, 6, 1, 0, 0),
(84, 4, 34, 5, 0, 0, 0),
(85, 1, 34, 2, 0, 0, 0),
(86, 4, 34, 2, 0, 0, 0),
(87, 5, 35, 1, 0, 0, 0),
(88, 4, 35, 2, 0, 0, 0),
(89, 3, 36, 5, 0, 0, 0),
(90, 4, 36, 2, 0, 0, 0),
(91, 3, 36, 2, 0, 0, 0),
(92, 3, 37, 1, 0, 0, 0),
(93, 3, 37, 2, 0, 0, 0),
(94, 1, 38, 5, 0, 0, 0),
(95, 3, 38, 2, 0, 0, 0),
(96, 1, 38, 2, 0, 0, 0),
(97, 1, 39, 1, 0, 0, 0),
(98, 2, 39, 2, 0, 0, 0);

-- --------------------------------------------------------

--
-- 表的结构 `pes_option`
--

CREATE TABLE IF NOT EXISTS `pes_option` (
`id` int(11) NOT NULL,
  `option_name` varchar(128) NOT NULL,
  `name` varchar(128) NOT NULL,
  `value` text NOT NULL,
  `option_range` varchar(128) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_option`
--

INSERT INTO `pes_option` (`id`, `option_name`, `name`, `value`, `option_range`) VALUES
(1, 'sitetitle', '程序标题', 'PESCMS TEAM', ''),
(7, 'theme', '主题', 'WorkHard', 'theme'),
(8, 'fieldType', '表单类型', '{"category":"\\u5206\\u7c7b","text":"\\u5355\\u884c\\u8f93\\u5165\\u6846","radio":"\\u5355\\u9009\\u6309\\u94ae","checkbox":"\\u590d\\u9009\\u6846","select":"\\u5355\\u9009\\u4e0b\\u62c9\\u6846","textarea":"\\u591a\\u884c\\u8f93\\u5165\\u6846","editor":"\\u7f16\\u8f91\\u5668","thumb":"\\u7565\\u7f29\\u56fe","img":"\\u4e0a\\u4f20\\u56fe\\u7ec4","file":"\\u4e0a\\u4f20\\u6587\\u4ef6","date":"\\u65e5\\u671f"}', 'Miscellaneous'),
(13, 'version', '系统版本', '1.005', ''),
(14, 'upload_img', '图片格式', '["jpg","jpge","bmp","gif","png"]', 'upload'),
(15, 'upload_file', '文件格式', '["zip","rar","7z","doc","docx","pdf","xls","xlsx","ppt","pptx","txt"]', 'upload'),
(16, 'urlModel', 'URL格式', '{"index":"1","urlModel":"3","suffix":"1"}', 'url'),
(17, 'mail', '邮件服务信息', '{"account":"","passwd":"","address":"","port":"25","trigger":"2"}', ''),
(19, 'signup', '帐号注册', '1', ''),
(20, 'node_type', '权限验证模式', '0', '');

-- --------------------------------------------------------

--
-- 表的结构 `pes_project`
--

CREATE TABLE IF NOT EXISTS `pes_project` (
`project_id` int(11) NOT NULL,
  `project_listsort` int(11) NOT NULL,
  `project_status` tinyint(4) NOT NULL,
  `project_lang` tinyint(4) NOT NULL,
  `project_url` varchar(255) NOT NULL,
  `project_title` varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_project`
--

INSERT INTO `pes_project` (`project_id`, `project_listsort`, `project_status`, `project_lang`, `project_url`, `project_title`) VALUES
(1, 0, 1, 0, '/Project/view/id/1.html', 'PESCMS'),
(2, 0, 1, 0, '/Project/view/id/2.html', 'PESCMS TEAM');

-- --------------------------------------------------------

--
-- 表的结构 `pes_report`
--

CREATE TABLE IF NOT EXISTS `pes_report` (
`report_id` int(11) NOT NULL,
  `report_date` date NOT NULL COMMENT '报表日期',
  `user_id` int(255) NOT NULL,
  `department_id` int(11) NOT NULL COMMENT '部门ID'
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='用户报表';

--
-- 转存表中的数据 `pes_report`
--

INSERT INTO `pes_report` (`report_id`, `report_date`, `user_id`, `department_id`) VALUES
(1, '2015-04-06', 1, 1),
(2, '2015-04-07', 1, 1),
(3, '2015-04-08', 1, 1),
(6, '2015-04-09', 1, 1),
(7, '2015-04-11', 1, 1),
(8, '2015-04-12', 2, 1),
(9, '2015-04-12', 1, 1),
(10, '2015-04-19', 1, 1);

-- --------------------------------------------------------

--
-- 表的结构 `pes_report_content`
--

CREATE TABLE IF NOT EXISTS `pes_report_content` (
`content_id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `report_content` text NOT NULL,
  `task_id` int(11) NOT NULL,
  `task_title` varchar(255) NOT NULL COMMENT '任务标题',
  `task_status` tinyint(1) NOT NULL COMMENT '任务状态'
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_report_content`
--

INSERT INTO `pes_report_content` (`content_id`, `report_id`, `report_content`, `task_id`, `task_title`, `task_status`) VALUES
(1, 1, '<p>sadasdasd</p>', 0, '', 0),
(2, 1, '<p>sadasdasd</p>', 0, '', 0),
(3, 1, '<p><span style="font-family: 'Segoe UI', 'Lucida Grande', Helvetica, Arial, 'Microsoft YaHei', FreeSans, Arimo, 'Droid Sans', 'wenquanyi micro hei', 'Hiragino Sans GB', 'Hiragino Sans GB W3', FontAwesome, sans-serif; line-height: 25.6000003814697px; white-space: normal;">听说这里可以插入到报表去</span></p>', 2, '完善任务系统查看页面', 1),
(4, 6, '<p>asdasdasd</p>', 0, '', 0),
(5, 7, '<p>asdsad</p>', 0, '', 0),
(6, 7, '<p>asdasdasd</p>', 1, '完善任务发布的细节', 3),
(7, 7, '<p>sadasd</p>', 20, '请修复主框架的高度BUG', 3),
(8, 8, '<p>大家好。今天天气不错啊!</p>', 0, '', 0),
(9, 8, '<p>123</p>', 0, '', 0),
(10, 8, '<p>我好像没任务？公司不给任务我做了吗？</p>', 0, '', 0),
(11, 8, '<p>周末也要编程，不能停！</p>', 0, '', 0),
(12, 8, '<p>现在在编写提取报表功能。</p><p>还有邮件通知啦，权限功能啦需要开发。。。。。</p>', 0, '', 0),
(13, 8, '<p>我没有写报表？</p>', 0, '', 0),
(14, 9, '<p>asdsadsad</p>', 0, '', 0),
(15, 9, '<p>ccc</p>', 0, '', 0),
(16, 9, '<p>听说报表查询完成了</p>', 2, '完善任务系统查看页面', 1),
(17, 10, '<p>听说发报表可以增加EY值</p>', 0, '', 0),
(18, 10, '<p>sad</p>', 0, '', 0),
(19, 10, '<p>sadsadsad</p>', 0, '', 0),
(20, 10, '<p>sadsadsad</p>', 0, '', 0),
(21, 10, '<p>sadsad</p>', 0, '', 0),
(22, 10, '<p>aasdasd</p>', 0, '', 0),
(23, 10, '<p>sadasdsad</p>', 0, '', 0),
(24, 10, '<p>asdsad</p>', 0, '', 0),
(25, 10, '<p>asdsdsad</p>', 0, '', 0),
(26, 10, '<p>asdsad</p>', 0, '', 0),
(27, 10, '<p>asdsad</p>', 0, '', 0),
(28, 10, '<p>asdsad</p>', 0, '', 0);

-- --------------------------------------------------------

--
-- 表的结构 `pes_task`
--

CREATE TABLE IF NOT EXISTS `pes_task` (
`task_id` int(11) NOT NULL,
  `task_listsort` int(11) NOT NULL,
  `task_status` tinyint(4) NOT NULL COMMENT '0: 未进行 1:进行中 2:审核 3:调整 4:完成',
  `task_lang` tinyint(4) NOT NULL,
  `task_url` varchar(255) NOT NULL,
  `task_accept_id` tinyint(1) NOT NULL COMMENT '0: 非本部门任务，需要对应部门负责人审核任务 1:本部门任务，直接指派内部人员',
  `task_title` varchar(255) NOT NULL,
  `task_department_id` varchar(255) NOT NULL,
  `task_user_id` varchar(255) NOT NULL,
  `task_create_id` varchar(255) NOT NULL,
  `task_content` text NOT NULL,
  `task_file` text NOT NULL,
  `task_createtime` int(11) NOT NULL COMMENT '创建时间',
  `task_completetime` int(11) NOT NULL COMMENT '完成时间',
  `task_estimatetime` int(11) NOT NULL COMMENT '执行者估计时间',
  `task_actiontime` int(11) NOT NULL COMMENT '执行时间',
  `task_priority` tinytext NOT NULL COMMENT '1:严重 2:主要 3:次要 4:普通',
  `task_expecttime` int(11) NOT NULL COMMENT '发起者期望完成时间',
  `task_project` varchar(255) NOT NULL,
  `task_read_permission` tinyint(1) NOT NULL COMMENT '阅读权限',
  `task_delete` tinyint(1) NOT NULL COMMENT '0:正常 1:任务被删除。被删除是由于用户被删除了',
  `task_mail` tinyint(1) NOT NULL COMMENT '本任务全程是否发送邮件 0:不 1:发'
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_task`
--

INSERT INTO `pes_task` (`task_id`, `task_listsort`, `task_status`, `task_lang`, `task_url`, `task_accept_id`, `task_title`, `task_department_id`, `task_user_id`, `task_create_id`, `task_content`, `task_file`, `task_createtime`, `task_completetime`, `task_estimatetime`, `task_actiontime`, `task_priority`, `task_expecttime`, `task_project`, `task_read_permission`, `task_delete`, `task_mail`) VALUES
(1, 0, 3, 0, '/Task/view/id/1.html', 1, '完善任务发布的细节', '1', '1', '2', '<p>完善任务发布的细节</p>', '', 1427990400, 1428591109, 0, 0, '4', 1427990400, '2', 0, 0, 0),
(2, 0, 1, 0, '/Task/view/id/2.html', 1, '完善任务系统查看页面', '1', '1', '2', '<p>123456</p>', '', 1427990400, 0, 1429027200, 0, '2', 1428249600, '2', 1, 0, 0),
(17, 0, 3, 0, '/Task/view/id/17.html', 0, '通知全体员工使用PESCMS TEAM', '2', '1', '1', '<p>通知全体员工使用PESCMS TEAM</p>', '', 1428076800, 1428244463, 0, 0, '1', 1428336000, '2', 0, 0, 0),
(18, 0, 2, 0, '/Task/view/id/18.html', 0, '发布放假通知', '2', '1', '5', '<p>发布放假通知</p>', '', 1428076800, 1428255452, 0, 0, '2', 1428336000, '2', 0, 0, 0),
(19, 0, 4, 0, '/Task/view/id/19.html', 0, '修复BUG', '3', '4', '5', '<p>修复BUG</p>', '', 1428076800, 1428591123, 0, 0, '3', 1428249600, '1', 0, 0, 0),
(20, 0, 3, 0, '/Task/view/id/20.html', 0, '请修复主框架的高度BUG', '1', '1', '4', '<p style="line-height: 25.6000003814697px; white-space: normal;">40年后，微软已经是全球最大软件开发商，拥有逾12.5万名员工，总部园区面积达到800万平方英尺(约合74万平方米)，Windows在全球PC市场的份额接近90%。微软现在是全球第三大市值公司，仅落后于埃克森美孚和苹果。</p><p style="line-height: 25.6000003814697px; white-space: normal;">本周六，微软将庆祝公司成立40周年。盖茨担任微软CEO长达25年时间，在2000年离职。他在周五向微软员工发送电邮，对公司未来发展提出建议：“让科技的力量惠及每一个人，让人们连接彼此，让个人计算无处不在。”</p><p style="line-height: 25.6000003814697px; white-space: normal;">盖茨在电邮中重申了他在40年前为微软规划的愿景——软件将驱动世界。他要求微软不要忘记改变人们生活的使命。“什么最重要，我们下一步就做什么。”他说。</p><p style="line-height: 25.6000003814697px; white-space: normal;">盖茨目前担任微软CEO萨蒂亚·纳德拉(Satya Nadella)的顾问，并兼任比尔与梅琳达·盖茨基金会联席主席，专注于慈善事业。过去21年，盖茨16年当选全球首富。不过盖茨承诺将其95%的财富捐献给慈善事业。目前为止，盖茨已经向他的基金会捐献了280亿美元。</p>', '', 1428076800, 1428255415, 0, 0, '1', 1428336000, '2', 0, 0, 0),
(21, 0, 4, 0, '/Task/view/id/21.html', 0, '发给IT部的任务', '1', '1', '4', '<p>test</p>', '/upload/20150405/552138f2464e5.docx,/upload/20150405/552138f4d5cd4.docx', 1428163200, 1428242829, 1428242670, 0, '4', 1420387200, '2', 0, 0, 0),
(22, 0, 0, 0, '/Task/view/id/22.html', 0, 'test', '3', '', '2', '<p>测试的</p>', '', 1428163200, 0, 0, 0, '2', 1428249600, '2', 0, 0, 0),
(23, 0, 4, 0, '/Task/view/id/23.html', 0, 'sadsadasfasf', '2', '3', '4', '<p>asdsadasd</p>', '', 1428163200, 1428285363, 1428508800, 0, '4', 1428336000, '1', 0, 0, 0),
(24, 0, 0, 0, '/Task/view/id/24.html', 1, 'asdsaddsgdfg', '3', '5', '4', '<p>gasdgsdag</p>', '', 1428163200, 0, 0, 0, '4', 1431705600, '2', 0, 0, 0),
(25, 0, 0, 0, '/Task/view/id/25.html', 1, '67657', '3', '4', '4', '<p>hhh</p>', '', 1428163200, 0, 0, 0, '4', 1430323200, '2', 0, 0, 0),
(26, 0, 0, 0, '/Task/view/id/26.html', 0, '给IT部', '1', '', '4', '<p>dd</p>', '', 1428249600, 0, 0, 0, '4', 1429891200, '2', 0, 0, 0),
(27, 0, 0, 0, '/Task/view/id/27.html', 0, '测试任务动态', '2', '', '1', '<p>ddddd</p>', '', 1428249600, 0, 0, 0, '4', 1428336000, '2', 0, 0, 0),
(28, 0, 4, 0, '/Task/view/id/28.html', 1, '发给自己', '1', '1', '1', '<p>asdsad</p>', '', 1428249600, 1428285284, 1428336000, 0, '4', 1428422400, '1', 0, 0, 0),
(29, 0, 0, 0, '/Task/view/id/29.html', 1, 'sadasdsadasd', '2', '3', '7', '<p>asdsadasd</p>', '', 1428249600, 0, 0, 0, '4', 1428422400, '2', 0, 0, 0),
(30, 0, 0, 0, '/Task/view/id/30.html', 0, 'test', '2', '', '1', '<p>sasdsad</p>', '', 1428508800, 0, 0, 0, '4', 1428508800, '2', 0, 0, 0),
(31, 0, 4, 0, '/Task/view/id/31.html', 1, '测试邮件的', '1', '2', '1', '<p>test</p>', '', 1428940800, 1429000722, 1428940800, 0, '4', 1429113600, '2', 0, 0, 1),
(32, 0, 0, 0, '/Task/view/id/32.html', 0, '听说发布任务可以增加EY值', '3', '', '1', '<p>测试</p>', '', 1429372800, 0, 0, 0, '1', 1428854400, '2', 0, 0, 0),
(33, 0, 4, 0, '/Task/view/id/33.html', 1, '我自己刷任务好了', '1', '1', '1', '<p>dddd</p>', '', 1429372800, 1429410260, 1428940800, 0, '1', 1429459200, '1', 0, 0, 0),
(34, 0, 0, 0, '/Task/view/id/34.html', 0, '听说系统准备发布了', '3', '', '1', '<p>dasd</p>', '', 1429372800, 0, 0, 0, '3', 1429459200, '2', 0, 0, 0),
(35, 0, 0, 0, '/Task/view/id/35.html', 1, '销售部准备PESCMS TEAM的事项', '3', '5', '4', '<p>dddd</p>', '', 1429372800, 0, 0, 0, '3', 1429372800, '2', 0, 0, 0),
(36, 0, 0, 0, '/Task/view/id/36.html', 0, '销售部需要招聘100人', '2', '', '4', '<p>sadsadasd</p>', '', 1429372800, 0, 0, 0, '4', 1429372800, '2', 0, 0, 0),
(37, 0, 0, 0, '/Task/view/id/37.html', 1, '关于年度工作汇报', '2', '3', '3', '<p>123</p>', '', 1429372800, 0, 0, 0, '3', 1431964800, '2', 0, 0, 0),
(38, 0, 0, 0, '/Task/view/id/38.html', 0, '我编不下去了', '1', '', '3', '<p>asdsadsad</p>', '', 1429372800, 0, 0, 0, '4', 1429372800, '2', 0, 0, 0),
(39, 0, 0, 0, '/Task/view/id/39.html', 1, '全体动态没有超链接', '1', '1', '2', '<p>sad</p>', '', 1429372800, 0, 0, 0, '4', 1429372800, '2', 0, 0, 0);

-- --------------------------------------------------------

--
-- 表的结构 `pes_task_check`
--

CREATE TABLE IF NOT EXISTS `pes_task_check` (
`check_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `check_user_id` int(11) NOT NULL COMMENT '审核人ID'
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_task_check`
--

INSERT INTO `pes_task_check` (`check_id`, `task_id`, `check_user_id`) VALUES
(1, 1, 2),
(2, 2, 2),
(3, 2, 4),
(4, 17, 1),
(5, 17, 3),
(6, 18, 5),
(7, 18, 3),
(8, 19, 5),
(9, 19, 4),
(10, 20, 4),
(11, 20, 1),
(12, 21, 4),
(13, 21, 1),
(14, 22, 2),
(15, 22, 4),
(16, 23, 4),
(17, 23, 3),
(18, 24, 4),
(19, 25, 4),
(20, 1, 1),
(21, 26, 4),
(22, 26, 1),
(23, 19, 1),
(24, 27, 1),
(25, 27, 3),
(26, 28, 1),
(27, 29, 7),
(28, 29, 1),
(29, 30, 1),
(30, 30, 3),
(31, 31, 1),
(32, 31, 4),
(33, 32, 1),
(34, 32, 2),
(35, 32, 4),
(36, 33, 1),
(37, 34, 1),
(38, 34, 4),
(39, 35, 4),
(40, 36, 4),
(41, 36, 3),
(42, 37, 3),
(43, 38, 3),
(44, 38, 1),
(45, 39, 2);

-- --------------------------------------------------------

--
-- 表的结构 `pes_task_diary`
--

CREATE TABLE IF NOT EXISTS `pes_task_diary` (
`diary_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `diary_content` text NOT NULL COMMENT '日志内容',
  `diary_time` int(11) NOT NULL COMMENT '添加时间'
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='任务日志';

--
-- 转存表中的数据 `pes_task_diary`
--

INSERT INTO `pes_task_diary` (`diary_id`, `task_id`, `diary_content`, `diary_time`) VALUES
(1, 21, '<p>你的假期不足一天，请及时充值！</p>', 1428228488),
(2, 21, '<p>你的假期不足一天，请及时充值！</p>', 1428228498),
(3, 21, '<p><img src="/upload/20150405/5521279a52b29.jpg" _src="/upload/20150405/5521279a52b29.jpg"/></p>', 1428236191),
(4, 21, '<p>asdsad</p>', 1428240447),
(5, 20, '<p>sadsad</p>', 1428245934),
(6, 20, '<p>sadsad</p>', 1428245984),
(7, 20, '<p>sadsad</p>', 1428246120),
(8, 28, '<p>asdsad</p>', 1428285236),
(9, 2, '<p>听说这里可以插入到报表去</p>', 1428307762),
(10, 2, '<p><span style="font-family: 'Segoe UI', 'Lucida Grande', Helvetica, Arial, 'Microsoft YaHei', FreeSans, Arimo, 'Droid Sans', 'wenquanyi micro hei', 'Hiragino Sans GB', 'Hiragino Sans GB W3', FontAwesome, sans-serif; line-height: 25.6000003814697px; white-space: normal;">听说这里可以插入到报表去</span></p>', 1428309986),
(11, 1, '<p>asdasdasd</p>', 1428763491),
(12, 20, '<p>sadasd</p>', 1428763928),
(13, 2, '<p>听说报表查询完成了</p>', 1428852288);

-- --------------------------------------------------------

--
-- 表的结构 `pes_task_supplement`
--

CREATE TABLE IF NOT EXISTS `pes_task_supplement` (
`task_supplement_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `task_supplement_content` text NOT NULL COMMENT '补充说明',
  `task_supplement_file` text NOT NULL COMMENT '补充附件',
  `task_supplement_time` int(11) NOT NULL COMMENT '补充时间'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_task_supplement`
--

INSERT INTO `pes_task_supplement` (`task_supplement_id`, `task_id`, `task_supplement_content`, `task_supplement_file`, `task_supplement_time`) VALUES
(2, 21, '你没看文档吗？', '/upload/20150405/552138f2464e5.docx,/upload/20150405/552138f4d5cd4.docx', 1428240634),
(3, 21, '<p>asdsadsadsad</p>', '', 1428240648),
(4, 28, '<p>asdasdsd</p>', '', 1428285246),
(5, 31, '<p>54564</p>', '', 1429000687),
(6, 33, '<p>123</p>', '', 1429410036),
(7, 33, '<p>asdsadsad</p>', '', 1429410051),
(8, 33, '<p>dasdsa</p>', '', 1429410247);

-- --------------------------------------------------------

--
-- 表的结构 `pes_update_list`
--

CREATE TABLE IF NOT EXISTS `pes_update_list` (
`update_list_id` int(11) NOT NULL,
  `update_list_url` varchar(255) NOT NULL,
  `update_list_pre_version` varchar(255) NOT NULL COMMENT '早期版本',
  `update_list_version` varchar(255) NOT NULL COMMENT '当前最新版本号',
  `update_list_read` tinyint(1) NOT NULL COMMENT '0:未阅读 1:已阅读',
  `update_list_type` tinyint(1) NOT NULL COMMENT '更新类型 0:正常 1:严重',
  `update_list_content` text NOT NULL,
  `update_list_createtime` int(11) NOT NULL COMMENT '更新发布时间',
  `update_list_file` text NOT NULL COMMENT '更新文件地址',
  `update_list_sql` text NOT NULL COMMENT '更新数据库文件地址'
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='获取更新信息列表';

--
-- 转存表中的数据 `pes_update_list`
--

INSERT INTO `pes_update_list` (`update_list_id`, `update_list_url`, `update_list_pre_version`, `update_list_version`, `update_list_read`, `update_list_type`, `update_list_content`, `update_list_createtime`, `update_list_file`, `update_list_sql`) VALUES
(2, '/Update_list/view/id/2.html', '1.000', '1.005', 1, 0, '<p>测试更新</p>', 1428421080, 'https://www.pescms.com/upload/20150409/55255267f0f04.zip', ''),
(4, '/Update_list/view/id/4.html', '1.005', '1.010', 1, 0, '<p class="p1">1.补充查看项目、部门、人员的任务明细。</p><p class="p1">2.补充任务列表中的搜索功能。</p><p class="p1">3.修复一些逻辑错误。</p>', 1428592920, 'http://api.pescms.com//upload/20150409/5526994eea1a6.zip', '');

-- --------------------------------------------------------

--
-- 表的结构 `pes_user`
--

CREATE TABLE IF NOT EXISTS `pes_user` (
`user_id` int(11) NOT NULL,
  `user_account` varchar(255) NOT NULL,
  `user_password` varchar(255) NOT NULL,
  `user_mail` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `user_group_id` int(11) NOT NULL,
  `user_status` tinyint(4) NOT NULL,
  `user_createtime` int(11) NOT NULL,
  `user_last_login` int(11) NOT NULL,
  `user_department_id` varchar(255) NOT NULL,
  `user_head` text NOT NULL COMMENT '用户头像',
  `user_ey` int(11) unsigned NOT NULL COMMENT '用户的ey值'
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_user`
--

INSERT INTO `pes_user` (`user_id`, `user_account`, `user_password`, `user_mail`, `user_name`, `user_group_id`, `user_status`, `user_createtime`, `user_last_login`, `user_department_id`, `user_head`, `user_ey`) VALUES
(1, 'admin', '75e1d83ba0f896dd29337a2539facb84', 'dev@pescms.com', '萝卜斯', 1, 1, 1388391307, 1388391307, '1', '/upload/20150418/55326739dccba.jpg', 1787),
(2, 'zhangsan', 'fa251b0c0d49590b8799af684eae070e', 'dev3@pescms.com', '张三', 2, 1, 1388391307, 1388391307, '1', 'http://amui.qiniudn.com/bw-2014-06-19.jpg?imageView/1/w/1000/h/1000/q/80', 2),
(3, 'lisi', '022a95b734c634792db29d670776526d', 'dev2@pescms.com', '李四', 2, 1, 1388391307, 1388391307, '2', '/upload/20150419/55336226e879d.png', 3),
(4, 'wangwu', 'bd77d503960a5824815fc7a8533a31dc', 'dev1@pescms.com', '王五', 2, 1, 1388391307, 1388391307, '3', 'http://amui.qiniudn.com/bw-2014-06-19.jpg?imageView/1/w/1000/h/1000/q/80', 4),
(5, 'zhaoliu', 'f4s072asdfdsf7805', 'de123v@pescms.com', '赵六', 2, 1, 1388391307, 1388391307, '3', 'http://amui.qiniudn.com/bw-2014-06-19.jpg?imageView/1/w/1000/h/1000/q/80', 2);

-- --------------------------------------------------------

--
-- 表的结构 `pes_user_group`
--

CREATE TABLE IF NOT EXISTS `pes_user_group` (
`user_group_id` int(11) NOT NULL,
  `user_group_listsort` int(11) NOT NULL,
  `user_group_status` tinyint(4) NOT NULL,
  `user_group_lang` tinyint(4) NOT NULL,
  `user_group_url` varchar(255) NOT NULL,
  `user_group_createtime` int(11) NOT NULL,
  `user_group_name` varchar(255) NOT NULL,
  `user_group_menu` text NOT NULL COMMENT '用户组菜单列表'
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `pes_user_group`
--

INSERT INTO `pes_user_group` (`user_group_id`, `user_group_listsort`, `user_group_status`, `user_group_lang`, `user_group_url`, `user_group_createtime`, `user_group_name`, `user_group_menu`) VALUES
(1, 0, 1, 0, '/User_group/view/id/1.html', 1417273380, '管理员', '1,4,8,11,9,10,13,38,15,16,17,18,40,19,20,41,42,43,45,39,44'),
(2, 0, 1, 0, '/User_group/view/id/2.html', 1417273440, '普通会员', '41,42,46,45,39,44'),
(3, 0, 1, 0, '/User_group/view/id/3.html', 1417273440, '部门责任人', '41,42,46,48,45,39,44');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pes_department`
--
ALTER TABLE `pes_department`
 ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `pes_dynamic`
--
ALTER TABLE `pes_dynamic`
 ADD PRIMARY KEY (`dynamic_id`);

--
-- Indexes for table `pes_field`
--
ALTER TABLE `pes_field`
 ADD PRIMARY KEY (`field_id`), ADD UNIQUE KEY `modle_id` (`model_id`,`field_name`);

--
-- Indexes for table `pes_menu`
--
ALTER TABLE `pes_menu`
 ADD PRIMARY KEY (`menu_id`), ADD KEY `menu_pid` (`menu_pid`);

--
-- Indexes for table `pes_model`
--
ALTER TABLE `pes_model`
 ADD PRIMARY KEY (`model_id`), ADD UNIQUE KEY `model_name` (`model_name`);

--
-- Indexes for table `pes_node`
--
ALTER TABLE `pes_node`
 ADD PRIMARY KEY (`node_id`), ADD UNIQUE KEY `node_value` (`node_value`,`node_check_value`), ADD KEY `node_check_value` (`node_check_value`);

--
-- Indexes for table `pes_node_group`
--
ALTER TABLE `pes_node_group`
 ADD PRIMARY KEY (`node_group_id`);

--
-- Indexes for table `pes_notice`
--
ALTER TABLE `pes_notice`
 ADD PRIMARY KEY (`notice_id`);

--
-- Indexes for table `pes_option`
--
ALTER TABLE `pes_option`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pes_project`
--
ALTER TABLE `pes_project`
 ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `pes_report`
--
ALTER TABLE `pes_report`
 ADD PRIMARY KEY (`report_id`);

--
-- Indexes for table `pes_report_content`
--
ALTER TABLE `pes_report_content`
 ADD PRIMARY KEY (`content_id`);

--
-- Indexes for table `pes_task`
--
ALTER TABLE `pes_task`
 ADD PRIMARY KEY (`task_id`);

--
-- Indexes for table `pes_task_check`
--
ALTER TABLE `pes_task_check`
 ADD PRIMARY KEY (`check_id`);

--
-- Indexes for table `pes_task_diary`
--
ALTER TABLE `pes_task_diary`
 ADD UNIQUE KEY `diary_id` (`diary_id`);

--
-- Indexes for table `pes_task_supplement`
--
ALTER TABLE `pes_task_supplement`
 ADD PRIMARY KEY (`task_supplement_id`);

--
-- Indexes for table `pes_update_list`
--
ALTER TABLE `pes_update_list`
 ADD PRIMARY KEY (`update_list_id`);

--
-- Indexes for table `pes_user`
--
ALTER TABLE `pes_user`
 ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `user_account` (`user_account`), ADD UNIQUE KEY `user_mail` (`user_mail`);

--
-- Indexes for table `pes_user_group`
--
ALTER TABLE `pes_user_group`
 ADD PRIMARY KEY (`user_group_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pes_department`
--
ALTER TABLE `pes_department`
MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `pes_dynamic`
--
ALTER TABLE `pes_dynamic`
MODIFY `dynamic_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT for table `pes_field`
--
ALTER TABLE `pes_field`
MODIFY `field_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT for table `pes_menu`
--
ALTER TABLE `pes_menu`
MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=50;
--
-- AUTO_INCREMENT for table `pes_model`
--
ALTER TABLE `pes_model`
MODIFY `model_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `pes_node`
--
ALTER TABLE `pes_node`
MODIFY `node_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=77;
--
-- AUTO_INCREMENT for table `pes_node_group`
--
ALTER TABLE `pes_node_group`
MODIFY `node_group_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=244;
--
-- AUTO_INCREMENT for table `pes_notice`
--
ALTER TABLE `pes_notice`
MODIFY `notice_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=99;
--
-- AUTO_INCREMENT for table `pes_option`
--
ALTER TABLE `pes_option`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `pes_project`
--
ALTER TABLE `pes_project`
MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `pes_report`
--
ALTER TABLE `pes_report`
MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `pes_report_content`
--
ALTER TABLE `pes_report_content`
MODIFY `content_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `pes_task`
--
ALTER TABLE `pes_task`
MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `pes_task_check`
--
ALTER TABLE `pes_task_check`
MODIFY `check_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `pes_task_diary`
--
ALTER TABLE `pes_task_diary`
MODIFY `diary_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `pes_task_supplement`
--
ALTER TABLE `pes_task_supplement`
MODIFY `task_supplement_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `pes_update_list`
--
ALTER TABLE `pes_update_list`
MODIFY `update_list_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `pes_user`
--
ALTER TABLE `pes_user`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `pes_user_group`
--
ALTER TABLE `pes_user_group`
MODIFY `user_group_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;