-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2017 ?04 ?17 ?10:18
-- 服务器版本: 5.5.47
-- PHP 版本: 5.5.30

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 */;

--
-- 数据库: `pp_easytp`
--

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

--
-- 表的结构 `pp_sys_access`
--

CREATE TABLE IF NOT EXISTS `pp_sys_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `module` varchar(50) NOT NULL COMMENT '模块代码',
  `model` varchar(50) NOT NULL COMMENT '模型代码',
  `action` varchar(50) NOT NULL COMMENT '操作代码',
  `title` varchar(50) NOT NULL COMMENT '操作名称',
  PRIMARY KEY (`id`),
  UNIQUE KEY `module` (`module`,`model`,`action`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='操作权限表' AUTO_INCREMENT=81 ;

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

INSERT INTO `pp_sys_access` (`id`, `module`, `model`, `action`, `title`) VALUES
(15, 'Product', 'Category', 'add', '添加'),
(16, 'Product', 'Category', 'edit', '编辑'),
(17, 'Product', 'Category', 'del', '删除'),
(18, 'Product', 'Category', 'index', '查询'),
(19, 'Product', 'Category', 'disable', '禁用'),
(20, 'Product', 'Category', 'enable', '启用'),
(21, 'Product', 'Product', 'add', '添加'),
(22, 'Product', 'Product', 'edit', '编辑'),
(23, 'Product', 'Product', 'del', '删除'),
(24, 'Product', 'Product', 'index', '查询'),
(25, 'Product', 'Product', 'disable', '禁用'),
(26, 'Product', 'Product', 'enable', '启用'),
(27, 'Product', 'Version', 'add', '添加'),
(28, 'Product', 'Version', 'edit', '编辑'),
(29, 'Product', 'Version', 'del', '删除'),
(30, 'Product', 'Version', 'index', '查询'),
(31, 'Product', 'Version', 'disable', '禁用'),
(32, 'Product', 'Version', 'enable', '启用'),
(33, 'Project', 'Category', 'add', '添加'),
(34, 'Project', 'Category', 'edit', '编辑'),
(35, 'Project', 'Category', 'del', '删除'),
(36, 'Project', 'Category', 'index', '查询'),
(37, 'Project', 'Category', 'disable', '禁用'),
(38, 'Project', 'Category', 'enable', '启用'),
(39, 'Project', 'Project', 'add', '添加'),
(40, 'Project', 'Project', 'edit', '编辑'),
(41, 'Project', 'Project', 'del', '删除'),
(42, 'Project', 'Project', 'index', '查询'),
(43, 'Project', 'Project', 'disable', '禁用'),
(44, 'Project', 'Project', 'enable', '启用'),
(45, 'Project', 'Stage', 'add', '添加'),
(46, 'Project', 'Stage', 'edit', '编辑'),
(47, 'Project', 'Stage', 'del', '删除'),
(48, 'Project', 'Stage', 'index', '查询'),
(49, 'Project', 'Stage', 'disable', '禁用'),
(50, 'Project', 'Stage', 'enable', '启用'),
(51, 'Project', 'Users', 'add', '添加'),
(52, 'Project', 'Users', 'edit', '编辑'),
(53, 'Project', 'Users', 'del', '删除'),
(54, 'Project', 'Users', 'index', '查询'),
(55, 'Project', 'Users', 'disable', '禁用'),
(56, 'Project', 'Users', 'enable', '启用'),
(57, 'Task', 'Category', 'add', '添加'),
(58, 'Task', 'Category', 'edit', '编辑'),
(59, 'Task', 'Category', 'del', '删除'),
(60, 'Task', 'Category', 'index', '查询'),
(61, 'Task', 'Category', 'disable', '禁用'),
(62, 'Task', 'Category', 'enable', '启用'),
(63, 'Task', 'Task', 'add', '添加'),
(64, 'Task', 'Task', 'edit', '编辑'),
(65, 'Task', 'Task', 'del', '删除'),
(66, 'Task', 'Task', 'index', '查询'),
(67, 'Task', 'Task', 'disable', '禁用'),
(68, 'Task', 'Task', 'enable', '启用'),
(69, 'Daily', 'Note', 'add', '添加'),
(70, 'Daily', 'Note', 'edit', '编辑'),
(71, 'Daily', 'Note', 'del', '删除'),
(72, 'Daily', 'Note', 'index', '查询'),
(73, 'Daily', 'Note', 'disable', '禁用'),
(74, 'Daily', 'Note', 'enable', '启用'),
(75, 'Daily', 'Note_task', 'add', '添加'),
(76, 'Daily', 'Note_task', 'edit', '编辑'),
(77, 'Daily', 'Note_task', 'del', '删除'),
(78, 'Daily', 'Note_task', 'index', '查询'),
(79, 'Daily', 'Note_task', 'disable', '禁用'),
(80, 'Daily', 'Note_task', 'enable', '启用');

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

--
-- 表的结构 `pp_sys_application`
--

CREATE TABLE IF NOT EXISTS `pp_sys_application` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `title` varchar(50) NOT NULL COMMENT '应用名称',
  `url` varchar(255) NOT NULL COMMENT '应用URL',
  `icon` varchar(20) NOT NULL DEFAULT 'dashboard',
  `create_time` int(11) NOT NULL COMMENT '接入时间',
  `status` tinyint(1) NOT NULL COMMENT '状态：1=启用，2=禁用',
  `type` tinyint(1) NOT NULL COMMENT '应用类型：1=内置，2=附加，3=第三方',
  `sort` int(11) NOT NULL DEFAULT '99' COMMENT '排序，从小到大',
  `remark` text NOT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='应用信息表' AUTO_INCREMENT=6 ;

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

INSERT INTO `pp_sys_application` (`id`, `title`, `url`, `icon`, `create_time`, `status`, `type`, `sort`, `remark`) VALUES
(1, '核心系统', '/app/Sys', 'dashboard', 0, 1, 1, 1, ''),
(5, '查询统计', '/app/Stats', 'dashboard', 1491371228, 1, 1, 9, '整个平台的查询统计');

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

--
-- 表的结构 `pp_sys_config`
--

CREATE TABLE IF NOT EXISTS `pp_sys_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `code` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` varchar(10) NOT NULL DEFAULT 'default' COMMENT '配置类型：default=匹配输入，datetime=时间，text=大文本，file=文件，image=图片，url=链接地址',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `remark` text NOT NULL COMMENT '配置说明',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `value` text NOT NULL COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`code`),
  KEY `type` (`type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10018 ;

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

INSERT INTO `pp_sys_config` (`id`, `code`, `type`, `title`, `remark`, `status`, `value`, `sort`) VALUES
(4, 'APP_STATUS', 'default', '关闭站点', '1=正常\r\n0=关闭', 1, '1', 6),
(10, 'WEB_SITE_ICP', 'default', '网站备案号', '设置在网站底部显示的备案号，如“沪ICP备12007941号-2', 1, '鄂ICP备11004466号', 21),
(38, 'APP_NAME', 'default', '系统名称', '显示在系统导航区域', 1, '开放平台', 3),
(39, 'MAIL_TYPE', 'enum', '邮件类型', '1=phpmeail\r\n2=sendmail', 1, '\r\n2', 0),
(40, 'MAIL_SMTP_HOST', 'default', 'SMTP 服务器', 'SMTP服务器', 2, 'smtp.163.com', 1),
(41, 'MAIL_SMTP_PORT', 'number', 'SMTP服务器端口', '默认25', 1, '25', 3),
(42, 'MAIL_SMTP_USER', 'default', 'SMTP服务器用户名', '填写完整用户名', 1, 'admin1', 0),
(43, 'MAIL_SMTP_PASS', 'default', 'SMTP服务器密码', '填写您的密码', 1, '123456', 0),
(10015, 'COPY_RIGHT', 'text', '版权所有', '版权所有', 1, '<a href="http://www.php.net">PHP 5.3</a>', 0),
(10016, 'APP_LOGO', 'file', 'LOGO图片', '请上传LOGO图片，200X100', 1, '1', 2);

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

--
-- 表的结构 `pp_sys_depart`
--

CREATE TABLE IF NOT EXISTS `pp_sys_depart` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级部门',
  `type` tinyint(1) NOT NULL COMMENT '类型：数据字典DEPART_TYPE',
  `title` varchar(200) NOT NULL COMMENT '部门名称',
  `sort` int(11) NOT NULL DEFAULT '99' COMMENT '排序',
  `status` tinyint(1) NOT NULL COMMENT '状态：数据字典STATUS',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='部门组织表' AUTO_INCREMENT=6 ;

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

INSERT INTO `pp_sys_depart` (`id`, `pid`, `type`, `title`, `sort`, `status`) VALUES
(1, 0, 1, '产品研发部', 1, 1),
(2, 1, 1, '程序开发部', 1, 1),
(3, 0, 1, '销售部', 1, 1),
(4, 0, 1, '测试部门', 99, 1),
(5, 4, 1, '一组', 99, 1);

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

--
-- 表的结构 `pp_sys_dict`
--

CREATE TABLE IF NOT EXISTS `pp_sys_dict` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `code` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `value` text NOT NULL COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='数据字典' AUTO_INCREMENT=30 ;

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

INSERT INTO `pp_sys_dict` (`id`, `code`, `title`, `value`, `sort`) VALUES
(1, 'STATUS', '状态', '1=启用\r\n2=禁用', 1),
(3, 'TITLE_STYLE', '标题样式', 'text-red=加红\r\ntext-blod=加粗\r\ntext-red text-blod=加红加粗', 11),
(4, 'APP_TYPE', '应用类型', '1=内置应用\r\n2=扩展应用\r\n3=外部应用', 2),
(6, 'CONFIG_TYPE', '配置类型', 'default=匹配输入\r\nnumber=数字\r\ndatetime=时间\r\nenum=枚举\r\ntext=大文本\r\nfile=文件\r\nimage=图片\r\nurl=链接地址', 2),
(7, 'MENU_TYPE', '菜单类型', '1=内部功能\r\n2=外部链接', 4),
(13, 'DEPART_TYPE', '组织结构类型', '1=部门\r\n2=分公司', 99),
(14, 'PROJECT_LEVEL', '项目级别', '1=一般\r\n2=紧急\r\n3=特急', 12),
(15, 'PROJECT_STATUS', '项目状态', '1=未开始\r\n2=进行中\r\n3=暂停\r\n4=已终结', 13),
(16, 'TASK_STATUS', '任务状态2', '1=未开始\r\n2=进行中\r\n3=已完成\r\n4=已确认', 20),
(17, 'TASK_LEVEL', '任务级别', '1=一般\r\n2=紧急\r\n3=特急', 99),
(18, 'FIELD_TYPE', '字段类型', 'text=文本\r\ntextarea=大文本\r\neditor=编辑器\r\nemail=邮箱\r\nphone=电话\r\nmobile=手机\r\nurl=链接地址\r\nint=整型\r\nunsign=非负整型\r\ndecimal=小数\r\ndatetime=日期时间\r\ndate=日期\r\ntime=时间\r\nimage=图片\r\nvideo=视频\r\nfile=文件\r\nip=IP地址\r\ndict=数据字典\r\nrelation=关联模型', 99),
(19, 'VIEW_TYPE', '视图类型', '1=静态页面\r\n2=自定义模板\r\n3=PHP页面', 22),
(20, 'DEV_MODULE_TYPE', '开发者数据模型的类型分类', 'common=一般模型\r\ntree=层级(树)模型\r\nsimple=简单模型', 99),
(28, 'VERIFY_STATUS', '审核状态', '0=待审核\r\n1=通过\r\n2=未通过', 99),
(29, 'TRUE_FALSE', '是否（真假判断）', '1=是\r\n0=否', 2);

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

--
-- 表的结构 `pp_sys_files`
--

CREATE TABLE IF NOT EXISTS `pp_sys_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `name` varchar(100) NOT NULL COMMENT '文件名',
  `path` varchar(255) NOT NULL COMMENT '保存路径',
  `exts` varchar(10) NOT NULL COMMENT '扩展名',
  `size` int(11) NOT NULL COMMENT '文件大小',
  `upload_time` int(11) NOT NULL COMMENT '上传时间',
  `upload_user` int(11) DEFAULT NULL COMMENT '上传人',
  `md5` char(32) DEFAULT NULL COMMENT 'md5值',
  `sha1` char(40) DEFAULT NULL COMMENT 'sha1值',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='文件信息表' AUTO_INCREMENT=19 ;

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

INSERT INTO `pp_sys_files` (`id`, `name`, `path`, `exts`, `size`, `upload_time`, `upload_user`, `md5`, `sha1`) VALUES
(7, 'no network2.png', 'image/2017/01/1483937179.png', 'png', 43543, 1483937179, 2, '9eb3de4df6119dea47379ed7d80c6b97', 'b67c93770d4bf1a892d14780a13542969c623cd6'),
(6, 'QQ图片20160908093838.jpg', 'image/2017/01/1483936766.jpg', 'jpg', 171364, 1483936766, 2, 'cfcfd48c91ce00e3f64858ac1e5aa155', '87cd26b0673296a11aecf10d54c946737f54c267'),
(5, '中毒.png', 'image/2017/01/1483945301.png', 'png', 122914, 1483936604, 2, '73d42f7739c620ad9a284d2e72042f7f', 'd7d85f102a5e68d52d4faa100c01640f613ed614'),
(8, 'p1apa2tcn9oun1gtqluh5t71qva3_200_150.png', 'image/2017/01/1483941990826941.png', 'png', 18229, 1483941989, 2, '715576c4ec418ebb66d7c0f2c5b1b0f5', '3d31fe375812b7a1083e4aea3f0a01dcbb1f0747'),
(9, '云平台双创+技能竞赛web规划.zip', 'file/2017/01/1483942838.zip', 'zip', 103646, 1483942838, 2, '91843cadb03319d3e356fb3b22dcb14b', '2b2769171cb4654e38563f4752cc2377c8d5eed4'),
(10, '平台首页.jpg', 'image/2017/01/1483942884.jpg', 'jpg', 1864270, 1483942884, 2, '644e2f9d016c250d9ff367574df54468', 'b3ab1c36f86934984c2dced03033547462341ba1'),
(11, 'Asher Book - Here With You.mp4', 'video/2017/01/1483945722.mp4', 'mp4', 1010378, 1483942902, 2, 'f1425067cc88e24f256eb44e6aca95f2', '1b4cbc4d9c2f51b9971d13d790cb1b52df3f341a'),
(12, 'Asher Book - Here With You.mp4', 'video/2017/01/1483945789.mp4', 'mp4', 38759114, 1483945789, 2, 'f6c4de6781a2bec735ae34d268828239', '02f9112d07f482efb56a8b204439a9b184b89ee6'),
(13, '文件系统方案研究.zip', 'file/2017/01/1483948552.zip', 'zip', 376502, 1483948552, 2, '2984913c9a65b1f0a1914baa0539d3f1', '0c20877641196132b0e3efd4343cbf5de07ab433'),
(14, '【视频】金属雕刻1.mp4', 'video/2017/01/1483948574.mp4', 'mp4', 4526071, 1483948574, 2, '5f0eb93b6bc7f4f0ca16cde064f8c07e', '346571ad556a0807dcf2725944fdfb6723d416a4'),
(15, '云平台双创+技能竞赛web规划.zip', 'file/2017/01/1483951040.zip', 'zip', 14783710, 1483951040, 2, '0fb7b44ebee57101e023f8e4eef63a83', '67506f6d4d0846623440ffce98a06ad4c100d425'),
(16, '充电车物料BOM清单.png', 'image/2017/02/1486621699946527.png', 'png', 355893, 1486621699, 2, '8b97bf31db2a5cd83a9499de46c378ec', '15dc76d1eb6f3937f83688719621ed08d726f31d'),
(17, 'user_import.xls', 'doc/2017/04/1491546763.xls', 'xls', 20992, 1491545961, 2, '48d14a602b12fb75521d728797b64819', '687416ccf740edb6aa8eac24b76e20a59e51cb0a'),
(18, 'user_import.xls', 'doc/2017/04/1491549046.xls', 'xls', 0, 1491549046, 2, '', '');

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

--
-- 表的结构 `pp_sys_identity`
--

CREATE TABLE IF NOT EXISTS `pp_sys_identity` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '状态（1启用2禁用）',
  `is_default` tinyint(1) unsigned DEFAULT '2' COMMENT '是否为系统默认：1是，2否',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '默认角色',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

INSERT INTO `pp_sys_identity` (`id`, `title`, `remark`, `status`, `is_default`, `role_id`) VALUES
(1, '老板', '老板', 1, 1, 6),
(2, '员工', 'adfaa', 1, 1, 12),
(3, '项目负责人', '项目负责人', 1, 2, 6),
(4, '测试身份', '测试身份', 1, 2, 13),
(6, 'aaa', '', 1, 0, 14);

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

--
-- 表的结构 `pp_sys_logs`
--

CREATE TABLE IF NOT EXISTS `pp_sys_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `userId` int(11) DEFAULT '0' COMMENT '当前用户',
  `method` enum('GET','POST','HEADER','PUT','LOGIN') NOT NULL COMMENT '请求方式',
  `url` varchar(50) NOT NULL COMMENT '操作地址',
  `data` text NOT NULL COMMENT '提交的数据',
  `log_time` datetime NOT NULL COMMENT '操作时间',
  `log_ip` varchar(50) NOT NULL COMMENT '操作的IP地址',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='操作日志记录表' AUTO_INCREMENT=206 ;

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

INSERT INTO `pp_sys_logs` (`id`, `userId`, `method`, `url`, `data`, `log_time`, `log_ip`) VALUES
(1, 0, 'GET', '/app.php?s=/Sys/Config/index.html', '{"pgv_pvi":"603337728","PHPSESSID":"uiv636taldue04qo08d6pgk8s4"}', '0000-00-00 00:00:00', '0'),
(2, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(3, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(4, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(5, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(6, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(7, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(8, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(9, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(10, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(11, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(12, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(13, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(14, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(15, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(16, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(17, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(18, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(19, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(20, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(21, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(22, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(23, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(24, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(25, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(26, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(27, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(28, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(29, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(30, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(31, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(32, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(33, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(34, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(35, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(36, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(37, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(38, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(39, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(40, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(41, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(42, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(43, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(44, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(45, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(46, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(47, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(48, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(49, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(50, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(51, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(52, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(53, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(54, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(55, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(56, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(57, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(58, 0, '', 'Auth/Login/check', 'asfdf', '0000-00-00 00:00:00', '0'),
(59, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(60, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(61, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(62, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(63, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(64, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(65, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(66, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(67, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(68, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(69, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(70, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(71, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(72, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(73, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(74, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(75, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(76, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(77, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(78, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(79, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(80, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(81, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(82, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(83, 0, '', 'Auth/Login/check', 'admin', '0000-00-00 00:00:00', '0'),
(84, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(85, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(86, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(87, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(88, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(89, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(90, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(91, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(92, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(93, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(94, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(95, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(96, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(97, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(98, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(99, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(100, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(101, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(102, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(103, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(104, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(105, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(106, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(107, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(108, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(109, 0, '', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '0'),
(110, 0, 'LOGIN', 'index/login', 'af', '2017-02-24 15:01:03', '127.0.0.1'),
(111, 0, 'LOGIN', 'index/login', 'af', '2017-02-24 15:01:03', '127.0.0.1'),
(112, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:01:11', '127.0.0.1'),
(113, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:01:11', '127.0.0.1'),
(114, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:18:19', '127.0.0.1'),
(115, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:19:19', '127.0.0.1'),
(116, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:19:19', '127.0.0.1'),
(117, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:20:16', '127.0.0.1'),
(118, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:20:16', '127.0.0.1'),
(119, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:22:06', '127.0.0.1'),
(120, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:22:06', '127.0.0.1'),
(121, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:22:35', '127.0.0.1'),
(122, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 15:22:35', '127.0.0.1'),
(123, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:11:30', '127.0.0.1'),
(124, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:11:30', '127.0.0.1'),
(125, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(126, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:13:34', '127.0.0.1'),
(127, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:13:34', '127.0.0.1'),
(128, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:18:04', '127.0.0.1'),
(129, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:18:04', '127.0.0.1'),
(130, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:18:42', '127.0.0.1'),
(131, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:18:42', '127.0.0.1'),
(132, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:19:15', '127.0.0.1'),
(133, 0, 'LOGIN', 'index/login', 'admin', '2017-02-24 17:19:15', '127.0.0.1'),
(134, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:23:55', '127.0.0.1'),
(135, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:23:55', '127.0.0.1'),
(136, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:24:02', '127.0.0.1'),
(137, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:24:02', '127.0.0.1'),
(138, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:48:53', '127.0.0.1'),
(139, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:48:53', '127.0.0.1'),
(140, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:50:05', '127.0.0.1'),
(141, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:50:05', '127.0.0.1'),
(142, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:54:56', '127.0.0.1'),
(143, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:54:56', '127.0.0.1'),
(144, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:12', '127.0.0.1'),
(145, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:12', '127.0.0.1'),
(146, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:35', '127.0.0.1'),
(147, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:35', '127.0.0.1'),
(148, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:49', '127.0.0.1'),
(149, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:55:49', '127.0.0.1'),
(150, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:56:01', '127.0.0.1'),
(151, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:56:01', '127.0.0.1'),
(152, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:56:08', '127.0.0.1'),
(153, 0, 'LOGIN', 'index/login', 'admin', '2017-02-27 10:56:08', '127.0.0.1'),
(154, 0, 'LOGIN', 'Open/login', 'admin', '2017-03-02 10:08:34', '127.0.0.1'),
(155, 0, 'LOGIN', 'Open/login', 'admin', '2017-03-02 10:08:34', '127.0.0.1'),
(156, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(157, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(158, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(159, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(160, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(161, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(162, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(163, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(164, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(165, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(166, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(167, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(168, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(169, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(170, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(171, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(172, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(173, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(174, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(175, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(176, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(177, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(178, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(179, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(180, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(181, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(182, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(183, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(184, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(185, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(186, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(187, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(188, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(189, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(190, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(191, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(192, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(193, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(194, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(195, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(196, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(197, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(198, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(199, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(200, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(201, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(202, 0, 'LOGIN', 'auth/login/index', 'test002', '0000-00-00 00:00:00', '127.0.0.1'),
(203, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(204, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1'),
(205, 0, 'LOGIN', 'auth/login/index', 'admin', '0000-00-00 00:00:00', '127.0.0.1');

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

--
-- 表的结构 `pp_sys_menu`
--

CREATE TABLE IF NOT EXISTS `pp_sys_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT '0' COMMENT '上一级ID',
  `title` varchar(20) NOT NULL COMMENT '名称',
  `url` varchar(100) DEFAULT NULL COMMENT '链接地址',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '类型:1=内部功能，2=外部链接',
  `sort` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '菜单启用状态0否1是',
  `app_id` int(11) NOT NULL DEFAULT '0' COMMENT '所属应用',
  `remark` varchar(255) DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`id`),
  KEY `sort` (`sort`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

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

INSERT INTO `pp_sys_menu` (`id`, `pid`, `title`, `url`, `type`, `sort`, `status`, `app_id`, `remark`) VALUES
(1, 27, '参数配置', '/Sys/Config/index', 1, 1, 1, 1, ''),
(2, 27, '菜单管理', '/Sys/Menu/index', 1, 2, 1, 1, ''),
(3, 0, '用户管理', '/Sys/User/index', 1, 3, 1, 1, ''),
(4, 30, '角色管理', '/Sys/Role/index', 1, 5, 1, 1, ''),
(5, 30, '身份管理', '/Sys/Identity/index', 1, 4, 1, 1, 'aaaa'),
(7, 27, '应用管理', '/Sys/Application/index', 1, 1, 1, 1, ''),
(8, 27, '数据字典', '/Sys/Dict/index', 1, 99, 1, 1, ''),
(9, 30, '部门管理', '/sys/Depart/index', 1, 99, 1, 1, '组织结构管理'),
(27, 0, '系统设置', '#', 1, 2, 1, 1, ''),
(30, 0, '基础管理', '#', 1, 2, 1, 1, ''),
(31, 0, '数据查询', '#', 1, 1, 1, 5, '数据查询'),
(32, 0, '数据统计', '#', 1, 2, 1, 5, '数据统计'),
(33, 32, '用户统计', '/Stats/User/index', 1, 1, 1, 5, '用户信息统计'),
(34, 31, '用户查询', '/Stats/User/query', 1, 1, 1, 5, '');

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

--
-- 表的结构 `pp_sys_menu_access`
--

CREATE TABLE IF NOT EXISTS `pp_sys_menu_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `menu_id` int(11) NOT NULL COMMENT '菜单ID',
  `access_id` int(11) NOT NULL COMMENT '权限ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='菜单关联权限表' AUTO_INCREMENT=79 ;

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

INSERT INTO `pp_sys_menu_access` (`id`, `menu_id`, `access_id`) VALUES
(19, 16, 15),
(20, 16, 16),
(21, 16, 17),
(22, 16, 18),
(23, 16, 19),
(24, 16, 20),
(25, 17, 21),
(26, 17, 22),
(27, 17, 23),
(28, 17, 24),
(29, 17, 25),
(30, 17, 26),
(31, 18, 27),
(32, 18, 28),
(33, 18, 29),
(34, 18, 30),
(35, 18, 31),
(36, 18, 32),
(37, 19, 33),
(38, 19, 34),
(39, 19, 35),
(40, 19, 36),
(41, 19, 37),
(42, 19, 38),
(43, 20, 39),
(44, 20, 40),
(45, 20, 41),
(46, 20, 42),
(47, 20, 43),
(48, 20, 44),
(49, 21, 45),
(50, 21, 46),
(51, 21, 47),
(52, 21, 48),
(53, 21, 49),
(54, 21, 50),
(55, 22, 51),
(56, 22, 52),
(57, 22, 53),
(58, 22, 54),
(59, 22, 55),
(60, 22, 56),
(61, 23, 57),
(62, 23, 58),
(63, 23, 59),
(64, 23, 60),
(65, 23, 61),
(66, 23, 62),
(67, 24, 63),
(68, 24, 64),
(69, 24, 65),
(70, 24, 66),
(71, 24, 67),
(72, 24, 68),
(73, 25, 69),
(74, 25, 70),
(75, 25, 71),
(76, 25, 72),
(77, 25, 73),
(78, 25, 74);

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

--
-- 表的结构 `pp_sys_organization`
--

CREATE TABLE IF NOT EXISTS `pp_sys_organization` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `text` varchar(100) NOT NULL COMMENT '组织名称',
  `pid` int(11) NOT NULL COMMENT '上级组织',
  `type` tinyint(1) NOT NULL COMMENT '组织类型：1=独立组织，2=内部组织',
  `status` tinyint(1) NOT NULL COMMENT '状态：1=启用，0=禁用',
  `sort` int(11) NOT NULL DEFAULT '99' COMMENT '排序，从小到大',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='组织机构信息表' AUTO_INCREMENT=6 ;

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

INSERT INTO `pp_sys_organization` (`id`, `text`, `pid`, `type`, `status`, `sort`) VALUES
(1, '叶盼盼', 0, 1, 1, 99),
(2, '软件研发中心', 1, 2, 1, 99),
(3, '程序开发部', 2, 3, 1, 99),
(4, '系统设计部', 2, 3, 1, 99),
(5, '生产交付中心', 1, 2, 1, 99);

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

--
-- 表的结构 `pp_sys_role`
--

CREATE TABLE IF NOT EXISTS `pp_sys_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '状态（1启用0禁用）',
  `is_default` tinyint(1) unsigned DEFAULT '2' COMMENT '是否为系统默认：1是，2否',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `pp_sys_role` (`id`, `title`, `remark`, `status`, `is_default`) VALUES
(12, '普通员工', '', 1, 2),
(6, '系统管理员', '管理员', 1, 1),
(11, '部门管理员', '部门管理员', 2, 2),
(13, '测试', '角色代码不能重复角色代码不能重复角色代码不能重复角色代码不能重复\r\n角色代码不能重复角色代码不能重复角色代码不能重复\r\n角色代码不能重复角色代码不能重复角色代码不能重复\r\n角色代码不能重复角色代码不能重复角色代码不能重复', 1, 2),
(14, '内容管理员', '管理站点内容', 1, 2),
(15, '测试角色2', '测试角色2', 1, 2);

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

--
-- 表的结构 `pp_sys_role_menu`
--

CREATE TABLE IF NOT EXISTS `pp_sys_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色ID',
  `menu_id` int(11) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`),
  KEY `menuId` (`menu_id`),
  KEY `roleId` (`role_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=38 ;

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

INSERT INTO `pp_sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES
(12, 14, 9),
(13, 14, 17),
(14, 14, 21),
(37, 15, 23),
(36, 15, 21),
(35, 15, 9),
(34, 15, 3);

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

--
-- 表的结构 `pp_sys_session`
--

CREATE TABLE IF NOT EXISTS `pp_sys_session` (
  `session_id` varchar(255) NOT NULL,
  `session_expire` int(11) NOT NULL,
  `session_data` blob,
  UNIQUE KEY `session_id` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `pp_sys_session` (`session_id`, `session_expire`, `session_data`) VALUES
('hn6ukuguljju1ei2a9f9qn4gb6', 1492396334, 0x70705f7c613a323a7b733a363a225f5f6261636b223b733a32303a222f6170702f5379732f496e6465782f696e646578223b733a343a2275736572223b613a31373a7b733a323a226964223b733a313a2232223b733a373a226163636f756e74223b733a353a2261646d696e223b733a383a226e69636b6e616d65223b733a31353a22e8b685e7baa7e7aea1e79086e59198223b733a393a226465706172745f6964223b733a313a2230223b733a393a226c6173745f74696d65223b733a31393a22303030302d30302d30302030303a30303a3030223b733a373a226c6173745f6970223b733a393a223132372e302e302e31223b733a31313a226c6f67696e5f636f756e74223b733a333a22393732223b733a353a22656d61696c223b733a31333a227373313173403136332e636f6d223b733a363a226d6f62696c65223b733a31313a223132333435363738393634223b733a353a2270686f746f223b733a34393a2275706c6f61642f32303136303131392f7031613962736e68643461647331763231626933317575323176706a332e6a7067223b733a31313a226372656174655f74696d65223b733a31393a22303030302d30302d30302030303a30303a3030223b733a31313a227570646174655f74696d65223b733a31393a22303030302d30302d30302030303a30303a3030223b733a363a22737461747573223b733a313a2231223b733a363a2269735f64656c223b733a313a2230223b733a343a2273616c74223b733a363a22617364666263223b733a383a2269735f7375706572223b623a313b733a353a22726f6c6573223b733a313a2230223b7d7d);

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

--
-- 表的结构 `pp_sys_terminal`
--

CREATE TABLE IF NOT EXISTS `pp_sys_terminal` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `code` varchar(20) NOT NULL COMMENT '终端代码',
  `title` varchar(20) NOT NULL COMMENT '终端名称',
  `org_id` int(11) NOT NULL COMMENT '机构ID',
  `domain` varchar(20) NOT NULL COMMENT '域名',
  `type` tinyint(1) NOT NULL COMMENT '域名类型：1=二级域名，2=独立域名，3=代码',
  `theme` varchar(20) NOT NULL DEFAULT 'default' COMMENT '主题',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '最后更新时间',
  `is_del` tinyint(1) NOT NULL COMMENT '是否被删除：1=是，0=否',
  `status` tinyint(1) NOT NULL COMMENT '状态：1=正常，0=禁用',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='终端信息' AUTO_INCREMENT=3 ;

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

INSERT INTO `pp_sys_terminal` (`id`, `code`, `title`, `org_id`, `domain`, `type`, `theme`, `create_time`, `update_time`, `is_del`, `status`) VALUES
(1, 'system', '管理控制台', 1, 'system', 3, 'metro-blue', '2016-12-05 00:00:00', '2017-03-22 09:12:18', 0, 1),
(2, 'whhq', '武汉华秦', 2, 'whhq', 3, 'default', '2016-12-05 00:00:00', '2017-03-22 09:12:18', 0, 1);

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

--
-- 表的结构 `pp_sys_terminal_config`
--

CREATE TABLE IF NOT EXISTS `pp_sys_terminal_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `config_code` varchar(30) NOT NULL COMMENT '配置代码',
  `terminal_id` int(11) NOT NULL COMMENT '终端ID',
  `value` text NOT NULL COMMENT '配置的值',
  PRIMARY KEY (`id`),
  KEY `terminal_id` (`terminal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='终端自定义配置信息' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `pp_sys_token`
--

CREATE TABLE IF NOT EXISTS `pp_sys_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `code` char(32) NOT NULL COMMENT '令牌代码',
  `user_id` int(11) unsigned NOT NULL COMMENT '用户ID',
  `create_time` datetime NOT NULL COMMENT '令牌生成时间',
  `is_expired` tinyint(1) NOT NULL COMMENT '是否过期:1=是，0=否',
  `ip` varchar(50) NOT NULL COMMENT '客户端IP',
  `scope` varchar(200) NOT NULL DEFAULT '' COMMENT '权限',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='用户令牌' AUTO_INCREMENT=28 ;

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

INSERT INTO `pp_sys_token` (`id`, `code`, `user_id`, `create_time`, `is_expired`, `ip`, `scope`) VALUES
(1, '4c6e46e91bfb91693f2791772e4f5678', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(2, '7f77d8fbb68882de2a948bf4e4c49180', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(3, 'aba5accac54d4797f6da1bd2b2ef2674', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(4, '84ffc8470fa5464200bbbcad1e7913c8', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(5, 'cd72b5560b32c09714e851927fcc4c34', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(6, 'a30a5fff33a9b0b06a2ee52d0eb86485', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(7, '836b65e8513d3915c6047cd255f295e8', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(8, '4def8ed05b86fe5c2efba55c4b2d4147', 2, '0000-00-00 00:00:00', 0, '127.0.0.1', 'public'),
(9, '0557d12f794e11dffada9dd0bcbdcfb3', 2, '2017-04-12 17:37:55', 0, '127.0.0.1', 'public'),
(10, '5ffbda94cb05422fa77a2e83440cc965', 2, '2017-04-13 11:01:08', 0, '127.0.0.1', 'public'),
(11, 'c62782fd993175a99d5b1ed30b2f5eb1', 2, '2017-04-13 14:31:01', 0, '127.0.0.1', 'public'),
(12, '08c44818838866e1bf0824e8aa84055b', 150, '2017-04-13 17:30:59', 0, '127.0.0.1', 'public'),
(13, 'abd3e61f99a1cf8fa8bd74e21529c892', 150, '2017-04-13 17:52:06', 0, '127.0.0.1', 'public'),
(14, 'd6effe5c68e1fa845303ce598f9ea23d', 2, '2017-04-13 17:58:27', 0, '127.0.0.1', 'public'),
(15, '21d351782f1dec0c7cf34feae620acc7', 150, '2017-04-13 18:03:48', 0, '127.0.0.1', 'public'),
(16, 'c73db6d9dd7ba043db4e29f85bab5a0b', 150, '2017-04-14 09:33:19', 0, '127.0.0.1', 'public'),
(17, '7704dbea3b4dfd83cd06c0aeaa9d6e1b', 150, '2017-04-14 09:42:22', 0, '127.0.0.1', 'public'),
(18, 'a4b9ba2cb7c0456ab3d3c14c9a441191', 2, '2017-04-14 09:44:34', 0, '127.0.0.1', 'public'),
(19, 'e707125b22f0495967bbbde63cac4f60', 150, '2017-04-14 09:45:09', 0, '127.0.0.1', 'public'),
(20, '05a368732053b17763db5616fd4ab336', 150, '2017-04-14 09:51:57', 0, '127.0.0.1', 'public'),
(21, '51f29e7f52111ff0e5805f2f87d444b4', 2, '2017-04-14 11:19:49', 0, '127.0.0.1', 'public'),
(22, '07ec304d42c92104dcfbacf5655eadd8', 2, '2017-04-14 11:20:57', 0, '127.0.0.1', 'public'),
(23, 'f3a56cc6ad503a31c0578d105a7f99e5', 2, '2017-04-14 11:22:10', 0, '127.0.0.1', 'public'),
(24, '7d153c49cc87d04173197e4afae028f0', 150, '2017-04-14 11:23:10', 0, '127.0.0.1', 'public'),
(25, '17c37aacc6515d9effd146d52655344a', 2, '2017-04-14 11:23:53', 0, '127.0.0.1', 'public'),
(26, 'cb399abb76bf1a18c8094c6c96889adf', 2, '2017-04-14 11:24:35', 0, '127.0.0.1', 'public'),
(27, 'a8704ec78bf8dedf50ded9753d21cb21', 2, '2017-04-17 10:08:30', 0, '127.0.0.1', 'public');

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

--
-- 表的结构 `pp_sys_user`
--

CREATE TABLE IF NOT EXISTS `pp_sys_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID，主键，自增长',
  `account` varchar(64) NOT NULL COMMENT '用户帐号，唯一主键',
  `nickname` varchar(50) NOT NULL COMMENT '用户昵称',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `depart_id` int(11) NOT NULL DEFAULT '0' COMMENT '所在部门ID',
  `last_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_ip` varchar(15) DEFAULT NULL COMMENT '最后登录IP',
  `login_count` int(11) unsigned DEFAULT '0' COMMENT '登录次数',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(30) DEFAULT NULL COMMENT '手机号码',
  `photo` varchar(255) NOT NULL COMMENT '头像',
  `create_time` datetime DEFAULT NULL COMMENT '帐号创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '帐号信息更新时',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态（0=未知，1=启用，2=禁用）',
  `is_del` tinyint(1) NOT NULL DEFAULT '2' COMMENT '是否已删除',
  `salt` char(6) NOT NULL COMMENT '加密盐值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account` (`account`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=151 ;

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

INSERT INTO `pp_sys_user` (`id`, `account`, `nickname`, `password`, `depart_id`, `last_time`, `last_ip`, `login_count`, `email`, `mobile`, `photo`, `create_time`, `update_time`, `status`, `is_del`, `salt`) VALUES
(2, 'admin', '超级管理员', 'cb4ffe6ca4de80f7d8f964751dd8db34', 0, '0000-00-00 00:00:00', '127.0.0.1', 973, 'ss11s@163.com', '12345678964', 'upload/20160119/p1a9bsnhd4ads1v21bi31uu21vpj3.jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'asdfbc'),
(114, 'yepanpan', 'admin', 'd5f2685de8f1d72782bbb3843622b2cd', 0, '0000-00-00 00:00:00', '127.0.0.1', 5, 'yepanpan@22.com', '13648751125', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'adfdaf'),
(133, 'test', '测试账号', 'cec1b4e4e5dfd195ee4b3e1d1a36fbfd', 0, '0000-00-00 00:00:00', '', 0, 'test@qq.com', '12345678964', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'mZikAx'),
(134, 'yg', '员工', 'b74bd837b6a520d9ac55bb85f16dbb17', 0, '0000-00-00 00:00:00', '', 0, 'adfad@qq', '12345678964', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'bIqhvg'),
(135, 'test2', 'test2', '801b689c5b401e610f04bdf37978b6bb', 0, '0000-00-00 00:00:00', '', 0, 'adfad@qq', '12345678964', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 0, 'KYOtig'),
(136, 'test3', 'test3', '66ed640e9cd771f60008a4be09e80913', 0, '0000-00-00 00:00:00', '', 0, '21234e@qq.com', '13423445655', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'eDKqGt'),
(137, 'test4', 'test4', 'c8690d6606279ad2128207a7fb888b8e', 0, '0000-00-00 00:00:00', '', 0, 'asfdasfdfas@qq.com', '45678522111', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 1, 'mYLvbO'),
(138, 'test5', 'test5', 'bc2f75289df8881af43daf75190a231c', 0, '0000-00-00 00:00:00', '', 0, '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'tQGKej'),
(141, 'test6', 'test6', 'c470c1fc391672611a2c22d25d8ef982', 0, '0000-00-00 00:00:00', '', 0, '314123@qq.com', '13345678863', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'uQiPck'),
(143, '测试角色2', '', 'f1236609b0f9fdcde9a4c027d90602e5', 0, '0000-00-00 00:00:00', '', 0, NULL, NULL, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'kNdbQB'),
(149, 'test001', 'test001', '9f063c39299723260ddd6b920fb9b1bd', 5, '0000-00-00 00:00:00', '', 0, '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'ODniQP'),
(150, 'test002', 'test002', 'a86e48a2602b707b31f2892842dd625b', 3, '0000-00-00 00:00:00', '127.0.0.1', 9, '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 'cbGegL');

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

--
-- 表的结构 `pp_sys_user_identity`
--

CREATE TABLE IF NOT EXISTS `pp_sys_user_identity` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `identity_id` int(11) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`identity_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='用户关联角色' AUTO_INCREMENT=213 ;

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

INSERT INTO `pp_sys_user_identity` (`id`, `user_id`, `identity_id`) VALUES
(109, 0, 0),
(207, 2, 0),
(162, 114, 2),
(163, 114, 4),
(143, 135, 0),
(144, 136, 0),
(152, 137, 0),
(154, 138, 0),
(164, 141, 3),
(165, 142, 0),
(167, 143, 0),
(173, 144, 0),
(174, 145, 0),
(175, 146, 0),
(176, 147, 3),
(177, 148, 2),
(182, 149, 3),
(212, 150, 4);

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

--
-- 表的结构 `pp_sys_user_info`
--

CREATE TABLE IF NOT EXISTS `pp_sys_user_info` (
  `userId` int(11) NOT NULL COMMENT '外键用户ID',
  `qq` varchar(32) DEFAULT NULL COMMENT 'QQ',
  `sex` varchar(3) DEFAULT '0' COMMENT '性别 0 男  1 女',
  `tel` varchar(24) DEFAULT NULL COMMENT '联系电话',
  `address` varchar(255) DEFAULT NULL COMMENT '联系地址',
  `cardId` varchar(20) DEFAULT NULL COMMENT '身份证号',
  `province` int(11) DEFAULT NULL COMMENT '省id',
  `city` int(11) DEFAULT NULL COMMENT '市id',
  `birthday` varchar(30) DEFAULT NULL COMMENT '出生日期',
  `zipCode` varchar(20) DEFAULT NULL COMMENT '邮政编码',
  `question` varchar(255) DEFAULT NULL COMMENT '密码找回问题',
  `answer` varchar(255) DEFAULT NULL COMMENT '密码找回答案',
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `pp_sys_user_open`
--

CREATE TABLE IF NOT EXISTS `pp_sys_user_open` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `app_id` int(11) NOT NULL COMMENT '应用ID',
  `open_id` char(32) NOT NULL COMMENT 'openID',
  `scope` varchar(255) NOT NULL COMMENT '权限',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户对应各应用的openID' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `pp_sys_user_role`
--

CREATE TABLE IF NOT EXISTS `pp_sys_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `role_id` int(11) NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`role_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='用户关联角色' AUTO_INCREMENT=240 ;

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

INSERT INTO `pp_sys_user_role` (`id`, `user_id`, `role_id`) VALUES
(120, 0, 0),
(232, 2, 0),
(178, 114, 6),
(176, 114, 12),
(177, 114, 13),
(89, 133, 13),
(88, 134, 12),
(154, 135, 0),
(155, 136, 0),
(163, 137, 0),
(165, 138, 0),
(179, 141, 6),
(180, 141, 14),
(181, 142, 0),
(183, 143, 0),
(189, 144, 0),
(190, 145, 0),
(191, 146, 0),
(193, 147, 0),
(192, 147, 6),
(195, 148, 0),
(194, 148, 12),
(205, 149, 0),
(204, 149, 6),
(238, 150, 13),
(239, 150, 15);

/*!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 */;