/*
Navicat MySQL Data Transfer

Source Server         : phpstudy
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : xiehiu

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

Date: 2016-11-23 08:56:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `ad`
-- ----------------------------
DROP TABLE IF EXISTS `ad`;
CREATE TABLE `ad` (
  `ad_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `position_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `media_type` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `ad_name` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ad_link` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ad_code` text CHARACTER SET utf8 NOT NULL,
  `start_time` date NOT NULL DEFAULT '0000-00-00',
  `end_time` date NOT NULL DEFAULT '0000-00-00',
  `link_man` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `link_email` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `link_phone` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `click_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `enabled` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ad
-- ----------------------------
INSERT INTO `ad` VALUES ('1', '1', '图片', '淘宝天猫', 'http://www.taobao.com/', '{\"newname\":\"582d714136cc6.png\",\"oldname\":\"adjt.png\"}', '2016-11-11', '2016-12-12', '', '', '', '0', '1');
INSERT INTO `ad` VALUES ('10', '5', '图片', '京东', 'http://www.jd.com/', '{\"newname\":\"582d5b7770b31.png\",\"oldname\":\"adjt.png\"}', '2016-11-01', '2016-12-30', '', '', '', '0', '1');

-- ----------------------------
-- Table structure for `admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志id',
  `log_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志的时间',
  `user_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志操作用户id',
  `log_info` varchar(255) NOT NULL DEFAULT '' COMMENT '操作行为',
  `ip_address` varchar(15) NOT NULL DEFAULT '' COMMENT '操作者的ip',
  PRIMARY KEY (`log_id`),
  KEY `log_time` (`log_time`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=371 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_log
-- ----------------------------
INSERT INTO `admin_log` VALUES ('4', '1478662260', '1', '数据库备份操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('3', '1478165005', '1', '日志整页删除操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('5', '1478829858', '1', '', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('6', '1478830655', '1', '', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('7', '1478830656', '1', '', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('8', '1478830675', '1', '', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('52', '1478851516', '1', '日志删除操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('10', '1478830689', '1', '', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('53', '1478851523', '1', '日志删除操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('60', '1479259566', '1', '查看用户 admin', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('15', '1478830988', '1', '日志删除操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('16', '1478831012', '1', '删除栏目测试222', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('17', '1478831019', '1', '删除栏目测试55', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('18', '1478831047', '1', '查看栏目测试222', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('19', '1478831059', '1', '修改栏目测试222', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('20', '1478831060', '1', '查看栏目测试222', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('21', '1478835024', '1', '查看文章111', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('22', '1478835026', '1', '查看文章111', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('23', '1478835046', '1', '更新文章公司简介', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('24', '1478835047', '1', '查看文章公司简介', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('25', '1478845282', '1', '查看会员 ppp', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('26', '1478845283', '1', '查看会员 ppp', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('27', '1478845373', '1', '删除会员 ', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('28', '1478846397', '1', '查看订单 协会会员费用', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('29', '1478846398', '1', '查看订单 协会会员费用', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('30', '1478848528', '1', '查看在线留言 测试留言1', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('31', '1478850506', '1', '查看部门 ceshi22', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('32', '1478850507', '1', '查看部门 ceshi22', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('33', '1478850518', '1', '删除部门 ceshi111', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('34', '1478850626', '1', '查看角色 admin', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('35', '1478850627', '1', '查看角色 admin', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('36', '1478850647', '1', '查看用户 admin', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('37', '1478850648', '1', '查看用户 admin', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('38', '1478850678', '1', '查看会员 1234', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('39', '1478850679', '1', '查看会员 1234', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('40', '1478850717', '1', '删除会员 ceshi666', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('41', '1478850738', '1', '添加会员等级 金牌', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('42', '1478850739', '1', '查看会员等级 金牌', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('43', '1478850756', '1', '删除会员 ceshi444', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('44', '1478850769', '1', '查看订单 协会会员费用22', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('45', '1478850770', '1', '查看订单 协会会员费用22', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('47', '1478850789', '1', '修改验证码操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('57', '1479094178', '1', '添加会员等级 1231', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('54', '1478851545', '1', '日志删除操作', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('59', '1479259531', '1', '修改网站设置', '127.0.0.1');
INSERT INTO `admin_log` VALUES ('56', '1479094149', '1', '', '127.0.0.1');

-- ----------------------------
-- Table structure for `ad_custom`
-- ----------------------------
DROP TABLE IF EXISTS `ad_custom`;
CREATE TABLE `ad_custom` (
  `ad_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `ad_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `ad_name` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `content` mediumtext CHARACTER SET utf8,
  `url` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ad_status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ad_custom
-- ----------------------------

-- ----------------------------
-- Table structure for `ad_position`
-- ----------------------------
DROP TABLE IF EXISTS `ad_position`;
CREATE TABLE `ad_position` (
  `position_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `position_name` varchar(60) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ad_width` smallint(5) unsigned NOT NULL DEFAULT '0',
  `ad_height` smallint(5) unsigned NOT NULL DEFAULT '0',
  `position_desc` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of ad_position
-- ----------------------------
INSERT INTO `ad_position` VALUES ('1', '首页—左边栏', '200', '200', '宽度正好，高度整好');
INSERT INTO `ad_position` VALUES ('5', '尾页—右边栏', '400', '200', '真不错');

-- ----------------------------
-- Table structure for `art`
-- ----------------------------
DROP TABLE IF EXISTS `art`;
CREATE TABLE `art` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subhead` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `intro` text COLLATE utf8_unicode_ci,
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `seocontent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seokeyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `display` smallint(255) DEFAULT '0',
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `member_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of art
-- ----------------------------
INSERT INTO `art` VALUES ('14', '东方4号', null, '东方4号', '/image/20161111/1478852029111525.png', null, '111', 'http://www.baidu.com/', '<p>东方4号东方4号东方4号东方4号东方4号</p>', '东方4号东方4号东方4号', '东方4号东方4号', '40', '5', '1478852018', '1479521745', '24');
INSERT INTO `art` VALUES ('13', '东方3号', null, '东方3号', '/image/20161111/1478851982109989.png', null, '444444', 'http://www.baidu.com/', '<p>东方3号东方3号东方3号东方3号东方3号东方3号东方3号</p>', '东方3号东方3号', '东方3号', '20', '5', '1478851968', '1479521748', '24');
INSERT INTO `art` VALUES ('12', '东方2号', null, '东方2号', '/image/20161111/1478851941683947.png', null, '1233', 'http://www.baidu.com/', '<p>东方2号东方2号东方2号东方2号东方2号东方2号东方2号</p>', '东方2号', '东方2号', '20', '5', '1478851943', '1479523325', '24');
INSERT INTO `art` VALUES ('15', '东方5号', null, '东方5号', '/image/20161111/1478852196955305.png', null, null, 'http://www.baidu.com/', '<p>东方5号东方5号东方5号东方5号东方5号东方5号</p>', '东方5号', '东方5号', '40', '10', '1478852198', '1479448503', '25');
INSERT INTO `art` VALUES ('11', '东方1号', null, '东方1号', '/image/20161111/1478851865134151.png', null, '123', 'http://www.baidu.com/', '<p>东方1号</p>', '东方1号', '东方1号', '40', '10', '1478851891', '1479520349', '25');
INSERT INTO `art` VALUES ('18', '1111111111111', null, '1111111111111', '/image/20161114/1479087036616387.png', null, '12344', '1111111111', '<p>111111111111111</p>', '111111111111', '111111111', '20', '5', '1479087042', '1479454540', '25');
INSERT INTO `art` VALUES ('23', '12334', null, '232333', '/image/20161119/1479526135121074.png', null, null, '3333', '<p>33</p>', '33', '33', '0', '10', '1479526139', '1479526139', '27');
INSERT INTO `art` VALUES ('19', '9999', null, '9999', '', null, '9999', '9999', '<p>999</p>', '9999', '9999', '0', '10', '1479087042', '1479087042', '25');
INSERT INTO `art` VALUES ('20', 'QQ', null, 'QQ', null, null, 'QQ', 'QQ', 'QQ', 'QQ', 'QQ', '0', '10', '1479087042', '1479087042', '25');
INSERT INTO `art` VALUES ('22', '0000', null, '0000', '/image/20161119/1479525554905130.png', null, null, '00000', '<p>0000</p>', '0000', '0000', '40', '10', '1479525561', '1479525561', '25');
INSERT INTO `art` VALUES ('24', '11390909', null, '09090', '/image/20161119/1479526161516382.png', null, null, '909090', '<p>9090</p>', '9090', '0990', '40', '5', '1479526166', '1479526171', '27');
INSERT INTO `art` VALUES ('25', '12', null, '12', '/image/20161121/1479717569250703.png', null, '123', '12', '<p>12</p>', '12', '21', '20', '10', '1479717576', '1479717576', '28');

-- ----------------------------
-- Table structure for `articles`
-- ----------------------------
DROP TABLE IF EXISTS `articles`;
CREATE TABLE `articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `subhead` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `intro` text COLLATE utf8_unicode_ci,
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comefrom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `seocontent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seokeyword` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isrecom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `push` tinyint(1) NOT NULL DEFAULT '1' COMMENT '百度推送',
  `push_status` smallint(6) NOT NULL DEFAULT '0' COMMENT '百度推送状态',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `category_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of articles
-- ----------------------------
INSERT INTO `articles` VALUES ('1', '公司简介', '11111', '11111111', '{\"newname\":\"581bfed3c8aa1.png\",\"oldname\":\"photoswipe-icons.png\"}', '1111', '1111', '1111111', '<p>\r\n	　　文/中国体育用品业联合会</p><p>\r\n	　　近日，体育领域强制性标准整合精简工作组制作完成《体育领域强制性标准整合精简评估工作报告》并报送有关单位，其中对两项现行标准和一项计划项目提出废止建议，在保证行业安全稳定发展的前提下，进一步提升体育领域经营效率。</p><p>\r\n	　　今年6月15日，工作组在国家体育总局体育科学研究所召开的&amp;ldquo;体育领域强制性标准整合精简培训及论证会议&amp;rdquo;上，体育领域现有强制性标准及计划项目相关起草单位或运动项目管理单位参加会议。</p><p style=\"text-align: center;\"><img alt=\"\" src=\"/uploads/allimg/161020/10264635D-0.png\" style=\"width: 558px; height: 317px;\"/></p><p>\r\n	　　会议邀请中国标准化研究院副院长、国家标准委强制性标准整合精简评估专家组组长白殿一研究员讲授了基本原理、工作要求和工作方法。总局经济司产业处安枫处长出席会议，听取了各单位代表的工作情况和处理意见的汇报，并对进一步配合工作组做好评估工作提出要求。</p><p>\r\n	　　会后，现有强制性国家标准及其计划项目的起草单位或运动项目管理中心向工作组反馈了自评估报告，工作组根据国务院办公厅印发的《强制性标准整合精简工作方案》、国家标准委印发的《强制性标准整合精简评估方法》等文件的要求，对相关意见进行了汇总。</p><p>\r\n	　　通过各标准所属单位自我评估意见的汇总，工作组发现，在保障人身健康和生命财产安全、国家安全、生态环境安全和满足社会经济管理基本要求的前提下，体育领域现行有效的34项强制性国家标准中所存在的问题主要分为以下几类：第一类，标准发布年限时间过长，行业内部发生巨大变化，标准已不适用需要修订或废除;第二类，标准实施力度不够，政府配套政策不到位，推行较为困难;第三类，标准内容不够全面，需要进行补充等。</p><p style=\"text-align: center;\"><img alt=\"\" src=\"/uploads/allimg/161020/1026462130-1.png\" style=\"width: 558px; height: 419px;\"/></p><p>\r\n	　　根据《强制性标准精简整合评估方法》的要求，坚持整合精简的基本原则，工作组认为，体育领域强制性标准制定出发点全部是围绕体育活动的安全，在当时立项背景下，均有其必要性。目前来看，这些标准大部分得到了较好地实施，目前仍有其实施的意义，部分标准在技术内容的适用性方面有需要调整和修改的内容，建议修订或与相关项目整合;部分标准随着社会的发展、技术的进步和体育运动本身的发展变化，在安全性上不再突出，建议转化为推荐性项目或予以废止。</p><p>\r\n	　　评估结论为继续有效的项目有24项，此外的《体育场所开放条件与技术要求第1部分：游泳场所》等2个项目的评估结论为转化为推荐性标准，《体育场所开放条件与技术要求第2部分:卡丁车场所》等5项内容评估结论为修订，《体育用品 电气部分的通用要求》的评估结论为整合，《普及类卡丁车通用技术》、《卡丁车运动安全通则》的评估结论为废止。</p><p>\r\n	　　另有3项正在进行的强制性国家标准计划项目，其中《体育活动组织服务规范 通用要求》评估结论为终止，《体育赛事及类似大型活动风险管理要求》等两项将继续完成。</p>', 'sdfsdf', 'sdfsdf1', '是', '10', '1', '0', '1478225951', '1478835046', '8');
INSERT INTO `articles` VALUES ('3', '1', '1', '1', '{\"newname\":\"582c076b8dd2a.png\",\"oldname\":\"adjt.png\"}', '1', '1', '1', '<p>1</p>', '1', '1', '是', '10', '1', '0', '1479280491', '1479368167', '14');
INSERT INTO `articles` VALUES ('5', '各省市“十三五”期间绿色建筑发展规划', '', '目前，我国约有2000座绿色建筑，主要集中在江苏、广州、山东、北京、上海等东部经济较为发达的地区。近期，各省市陆续公布“十三五”期间绿色建筑发展规划。', null, '匿名', '防水协会', '', '<p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">近日，北京市政府常务会议审议通过《北京市“十三五”时期民用建筑</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">节能发展规划》(以下简称《发展规划》)，提出未来5年北京将推动超低能耗建筑试点示范，特别是在北京城市副中心等具备条件的绿色生态示范区提高绿色建筑</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">的普及率。</span></p><p><section data-id=\"86456\" data-tools=\"135编辑器\" style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"><section data-bgless=\"lighten\" data-bglessp=\"15%\" style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"></section></section></section></section></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">专家认为，提高绿色建筑的普及率，首先要转变政府观念，改事后补贴为事前牵线搭桥。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\">&nbsp;</p><p><section label=\"Powered by 135editor.com\" data-role=\"outer\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑; box-sizing: border-box !important; word-wrap: break-word !important;\"><section data-id=\"1\" data-tools=\"135编辑器\" style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box; word-wrap: break-word !important; border: 0px currentcolor; border-image-source: none;\"><section style=\"margin: 10px 0px; padding: 5px 10px; max-width: 100%; box-sizing: border-box; word-wrap: break-word !important; color: rgb(102, 102, 102); line-height: 32px; font-weight: bold; border-left-color: rgb(102, 103, 101); border-left-width: 5px; border-left-style: solid;\"><p style=\"margin: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; box-sizing: border-box !important; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; line-height: 28px; font-size: medium; white-space: pre-wrap;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">政府推动 绿建拔地而起</span></strong></p></section></section><p style=\"margin: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; box-sizing: border-box !important; word-wrap: break-word !important;\">&nbsp;</p></section></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">立体绿化，屋顶花园?或者再高级一点儿，恒温恒湿，智能建筑?又或者是</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">造价</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; line-height: 1.75em; font-size: 15px;\">昂贵的建筑？绿色建筑可没有这么简单。事实上，绿色建筑是在建筑的全寿命期内，最大限度地节能、节地、节水、节材，保护环境，减少污染，为人们提供健康、适用和高效的适用空间，达到与自然和谐相处的目标。绿色建筑的突出优势就是减少能源消耗，建筑可持续并与人需求相适应。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; line-height: 1.75em; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">清华大学建筑学院副院长、绿色经济与可持续发展研究中心绿色建筑课题组负责人朱颖心认为，很多真正节能、节材的建筑是出于节省投资与运行费的目的才建成的，因此并不应该是昂贵的建筑。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">绿色建筑的益处可延伸到工作以外，包括提升睡眠质量。哈佛大学陈曾熙公共卫生学院和纽约州立大学上州医科大学的研究人员研究全美5个城市共10座建筑的109位工作者后发现，在绿色认证建筑内工作的人能够获得更高的认知功能和睡眠质量分数，并出现较少病态楼宇综合症。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">据了解，目前，我国约有2000座绿色建筑，主要集中在江苏、广州、山东、北京、上海等东部经济较为发达的地区。“目前，我国绿色建筑发展很快，节能建筑刚性要求严格，新建项目基本都要求执行绿色建筑标准，但绿色建筑机制还不完善，主要靠政府推动。”德中环保咨询(GEP Research)研究员郭少君称。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">在郭少君看来，绿色建筑发展迅速离不开国家的政策支持。他介绍说，根据国家规划，到2020年我国城镇绿色建筑占新建建筑比重要从2012年的2%提升至50%。绿色建筑以每年翻番速度发展。根据国家发布的绿色建筑行动方案要求，2015年起，政府投资的学校、医院、博物馆、科技馆等建筑，直辖市、计划单列市及省会城市保障性住房以及单体建筑面积超过2万平方米的机场、车站等大型公共建筑，都要全面执行绿色建筑标准，这就极大促进了绿色建筑的发展。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\">&nbsp;</p><p><section label=\"Powered by 135editor.com\" data-role=\"outer\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑; box-sizing: border-box !important; word-wrap: break-word !important;\"><section data-id=\"1\" data-tools=\"135编辑器\" style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box; word-wrap: break-word !important; border: 0px currentcolor; border-image-source: none;\"><section style=\"margin: 10px 0px; padding: 5px 10px; max-width: 100%; box-sizing: border-box; word-wrap: break-word !important; color: rgb(102, 102, 102); line-height: 32px; font-weight: bold; border-left-color: rgb(102, 103, 101); border-left-width: 5px; border-left-style: solid;\"><p style=\"margin: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; box-sizing: border-box !important; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; line-height: 28px; font-size: medium; white-space: pre-wrap;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">政府转变观念 功能前置</span></strong></p></section></section><p style=\"margin: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; box-sizing: border-box !important; word-wrap: break-word !important;\">&nbsp;</p></section></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">据了解，目前我国绿色建筑在节能、节地、节材以及环保等方面已有标准，通过强制项(绿色建筑的必备条款)、一般项(可选择项目)和优选项(难度较大、指标要求较高的项目)的分数累加形成三个星级标准。强制项和一般项都是用传统手法和优化设计可以实现的，成本增加的并不多。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">中国绿色建筑促进会负责人表示，比如，开发1平方米三星级绿色建筑的成本比普通建筑高出200多元，但是在用地、设计、审批等方面的花费仍旧不菲。目前绿色建筑的增量成本存在着偏高或者参差不齐的局面，绿色建筑的增量成本从3.6%~9.3%不等。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">此前有专家认为，由于开发成本较高，现有的绿色建筑项目多数以中高端市场定位为主，“绿色住宅”目前基本上定位于改善型需求类产品，离锱铢必较的普通刚需购房者还有一定距离。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">针对这一情况，记者采访了多位市民，答案确是如此。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">北京市民李先生告诉记者：“目前北京房价本来就比较高，如果买一套100平方米的‘绿色’房子就要多花十几甚至几十万，不划算。”不过，李先生在接受采访时表示，如果在购买绿色建筑时能够得到一些优惠支持，会考虑买绿色建筑。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">这么看来，价格确实是挡在消费者和绿色建筑之间的“一堵墙”。事实上，《发展规划》中针对资金支持做出了明确的规定：统筹市级财政资金，发挥政府资金杠杆作用，引导社会资金积极参与，推动市场化运作机制的形成。对政府投资的项目，增量投资由政府资金承担;社会投资的项目由市级财政给予一定的奖励资金，被认定为第一年度的示范项目，资金奖励标准为1000元/平方米，且单个项目不超过3000万元;第二年度的示范项目，资金奖励标准为800元/平方米，且单个项目不超过2500万元;第三年度的示范项目，资金奖励标准为600元/平方米，且单个项目不超过2000万元。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">中国绿色建筑促进会负责人在受中访时表示，虽然这项支持并不针对消费者个人，但是对于开发商的资金补贴也能够在一定程度上减少消费者的购房压力。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">那么问题来了：图一时，还是谋长远?上述负责人告诉记者，“前期的高投入高成本成为制约绿色建筑发展的最大瓶颈，高成本、收益慢是制约市场积极性的重要因素。企业前期投入很高，但是如果要收回成本至少要十年时间。在我国推广绿色建筑，政府应该转变思维，功能前置，地块儿要提前规划，改事后补贴为事前牵线搭桥。”</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"/></span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">除了价格因素外，郭少君认为，可循环建材使用和建筑废弃物资源化利用比例偏低，仅仅5%左右，这在一定程度上阻碍了绿色建筑的发展。其次，市场推动绿色建筑与建筑节能发展体制机制还未形成。绿色建筑在节水、节能、节材、环保等方面，从设计到运营都执行更严格能耗标准，国外已经完成了这些环节的改造，中国正在从制度设计到执行的完善过程。</span></p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap;\">&nbsp;</p><p style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; clear: both; min-height: 1em; white-space: pre-wrap; line-height: 1.75em;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; color: rgb(122, 68, 66);\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 15px;\">近期，各省市陆续公布“十三五”期间绿色建筑发展规划。以下将节选部分省市的规划重点。</span></strong></span></p><p><br/></p>', '各省市“十三五”期间绿色建筑发展规划', '各省市“十三五”期间绿色建筑发展规划', '是', '10', '1', '1', '1479438599', '1479438599', '1');
INSERT INTO `articles` VALUES ('6', '百度测试', '百度测试', '百度测试', null, '', '', '', '<p>百度测试</p>', '百度测试', '百度测试', '是', '10', '1', '1', '1479440683', '1479440683', '14');
INSERT INTO `articles` VALUES ('7', '百度文章推送测试', '', '百度文章推送测试', null, '', '', '', '<p>百度文章推送测试<br/></p>', '', '', '是', '10', '1', '1', '1479458094', '1479458112', '1');

-- ----------------------------
-- Table structure for `auth_assignment`
-- ----------------------------
DROP TABLE IF EXISTS `auth_assignment`;
CREATE TABLE `auth_assignment` (
  `item_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`item_name`,`user_id`),
  CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of auth_assignment
-- ----------------------------
INSERT INTO `auth_assignment` VALUES ('admin', '1', '1479450842');

-- ----------------------------
-- Table structure for `auth_item`
-- ----------------------------
DROP TABLE IF EXISTS `auth_item`;
CREATE TABLE `auth_item` (
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `type` int(11) NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `data` text COLLATE utf8_unicode_ci,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `status` tinyint(2) DEFAULT '1',
  `display` tinyint(2) DEFAULT '1',
  `is_show` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `rule_name` (`rule_name`),
  KEY `idx-auth_item-type` (`type`),
  CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of auth_item
-- ----------------------------
INSERT INTO `auth_item` VALUES ('ad-position/alldelete', '2', '批量删除广告位', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad-position/create', '2', '新增广告位', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad-position/delete', '2', '删除广告位', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad-position/index', '2', '广告位管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad-position/update', '2', '修改广告位', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad-position/view', '2', '查看广告位', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/alldelete', '2', '批量删除广告', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/create', '2', '新增广告', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/delete', '2', '删除广告', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/index', '2', '广告管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/update', '2', '修改广告', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('ad/view', '2', '查看广告', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('admin', '1', '超级管理员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('admin-log/alldelete', '2', '批量删除日志', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('admin-log/delete', '2', '删除日志', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('admin-log/index', '2', '后台日志管理', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('admin-log/view', '2', '查看日志', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/alldelete', '2', '批量删除文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/create', '2', '新增文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/delete', '2', '删除文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/index', '2', '文章管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/start', '2', '启用文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/stop', '2', '停用文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/update', '2', '修改文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('articles/view', '2', '查看文章', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('backend/cmsactive', '2', '内容模块', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('backend/finanactive', '2', '财务模块', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('backend/memactive', '2', '会员模块', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('backend/roleactive', '2', '权限模块', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('backend/sysactive', '2', '系统模块', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/children', '2', '子栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/create', '2', '新增栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/delete', '2', '删除栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/getchildren', '2', '获取子栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/index', '2', '栏目管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/update', '2', '修改栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('category/view', '2', '查看栏目', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/alldelete', '2', '批量删除客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/create', '2', '新增客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/delete', '2', '删除客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/index', '2', '客服管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/start', '2', '启用客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/stop', '2', '停用客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/update', '2', '修改客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('customer/view', '2', '查看客服', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('dbmanage/backup', '2', '数据库备份', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('dbmanage/del', '2', '数据库删除', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('dbmanage/down', '2', '数据库下载', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('dbmanage/index', '2', '数据库管理', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('dbmanage/restore', '2', '数据库还原', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/alldelete', '2', '批量删除友情链接', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/create', '2', '新增友情链接', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/delete', '2', '删除友情链接', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/index', '2', '友情链接列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/update', '2', '修改友情链接', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('friend-link/view', '2', '查看友情链接', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/alldelete', '2', '批量删除会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/create', '2', '新增会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/delete', '2', '删除会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/index', '2', '会员等级列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/start', '2', '启用会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/stop', '2', '停用会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/update', '2', '修改会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('grade/view', '2', '查看会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/alldelete', '2', '批量删除部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/create', '2', '新增部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/delete', '2', '删除部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/index', '2', '部门管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/start', '2', '启用部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/stop', '2', '停用部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/update', '2', '修改部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('group/view', '2', '查看部门', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/alldelete', '2', '批量删除发票', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/create', '2', '新增发票', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/delete', '2', '删除发票', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/index', '2', '发票管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/start', '2', '开具会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/stop', '2', '收回会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/update', '2', '修改发票', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('invoice/view', '2', '查看发票', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/alldelete', '2', '批量删除链接类别', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/create', '2', '新增链接类别', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/delete', '2', '删除链接类别', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/index', '2', '链接类别列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/update', '2', '修改链接类别', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('link-type/view', '2', '查看链接类别', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/alldelete', '2', '批量删除会议', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/create', '2', '新增会议', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/delete', '2', '删除会议', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/index', '2', '会议列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/update', '2', '修改会议', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('meeting/view', '2', '查看会议', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/alldelete', '2', '批量删除会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/check', '2', '已审核会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/create', '2', '新增会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/delete', '2', '删除会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/import', '2', '导出会员统计数据', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/index', '2', '会员列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/start', '2', '启用会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/stop', '2', '停用会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/uncheck', '2', '再审核会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/update', '2', '修改会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/view', '2', '查看会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('member/waitcheck', '2', '待审核会员', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/alldelete', '2', '批量删除留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/create', '2', '新增留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/delete', '2', '删除留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/index', '2', '在线留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/update', '2', '修改留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('message/view', '2', '查看留言', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('notice/create', '2', '新增通知', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('notice/delete', '2', '删除通知', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('notice/index', '2', '消息通知', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('notice/update', '2', '修改通知', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('notice/view', '2', '查看通知', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/create', '2', '新增收款', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/delete', '2', '删除收款', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/import', '2', '导出会员缴费数据', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/index', '2', '收款管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/update', '2', '修改收款', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('orders/view', '2', '查看收款', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/alldelete', '2', '批量删除角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/create', '2', '新增角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/delete', '2', '删除角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/index', '2', '角色管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/start', '2', '启用角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/stop', '2', '停用角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/update', '2', '修改角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('role/view', '2', '查看角色', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('setting/index', '2', '网站设置', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/alldelete', '2', '批量删除用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/create', '2', '新增用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/delete', '2', '删除用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/index', '2', '用户管理列表', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/start', '2', '启用用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/stop', '2', '停用用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/update', '2', '修改用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('users/view', '2', '查看用户', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('yanzheng/captcha', '2', '生成验证码', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('yanzheng/index', '2', '验证码管理', null, null, '1479450842', '1479450842', '1', '1', null);
INSERT INTO `auth_item` VALUES ('yanzheng/update', '2', '查看验证码', null, null, '1479450842', '1479450842', '1', '1', null);

-- ----------------------------
-- Table structure for `auth_item_child`
-- ----------------------------
DROP TABLE IF EXISTS `auth_item_child`;
CREATE TABLE `auth_item_child` (
  `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of auth_item_child
-- ----------------------------
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad-position/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'ad/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'admin-log/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'admin-log/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'admin-log/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'admin-log/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'articles/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'backend/cmsactive');
INSERT INTO `auth_item_child` VALUES ('admin', 'backend/finanactive');
INSERT INTO `auth_item_child` VALUES ('admin', 'backend/memactive');
INSERT INTO `auth_item_child` VALUES ('admin', 'backend/roleactive');
INSERT INTO `auth_item_child` VALUES ('admin', 'backend/sysactive');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/children');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/getchildren');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'category/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'customer/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'dbmanage/backup');
INSERT INTO `auth_item_child` VALUES ('admin', 'dbmanage/del');
INSERT INTO `auth_item_child` VALUES ('admin', 'dbmanage/down');
INSERT INTO `auth_item_child` VALUES ('admin', 'dbmanage/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'dbmanage/restore');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'friend-link/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'grade/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'group/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'invoice/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'link-type/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'meeting/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/check');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/import');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/uncheck');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'member/waitcheck');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'message/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'notice/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'notice/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'notice/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'notice/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'notice/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/import');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'orders/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'role/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'setting/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/alldelete');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/create');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/delete');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/start');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/stop');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/update');
INSERT INTO `auth_item_child` VALUES ('admin', 'users/view');
INSERT INTO `auth_item_child` VALUES ('admin', 'yanzheng/captcha');
INSERT INTO `auth_item_child` VALUES ('admin', 'yanzheng/index');
INSERT INTO `auth_item_child` VALUES ('admin', 'yanzheng/update');

-- ----------------------------
-- Table structure for `auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `auth_rule`;
CREATE TABLE `auth_rule` (
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of auth_rule
-- ----------------------------

-- ----------------------------
-- Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sort` tinyint(5) DEFAULT NULL,
  `seo_keywords` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `seo_contents` text COLLATE utf8_unicode_ci,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', '关于我们', '1', 'www.baidu.com', '0', '关于我们关键词', '关于我们描述语', '0');
INSERT INTO `category` VALUES ('2', '新闻资讯', '1', 'www.qq.com', '0', '新闻资讯关键词', '新闻资讯描述语', '0');
INSERT INTO `category` VALUES ('4', '整体方案', '1', 'www.modenet.com', '0', '整体方案guanjianci', '整体方案miaoshu', '0');
INSERT INTO `category` VALUES ('5', '销售网络', '1', '0500.jiaoyinet.com', '0', '销售网络关键词', '销售网络描述语', '0');
INSERT INTO `category` VALUES ('8', '公司简介', '1', 'www.baidu.com', '0', '公司简介关键词', '公司简介描述', '1');
INSERT INTO `category` VALUES ('9', '公司文化', '1', 'www.baidu.com', '0', '公司文化关键词', '公司简介描述', '1');
INSERT INTO `category` VALUES ('10', '公司资质', '1', 'www.baidu.com', '0', '公司资质关键词', '公司资质描述', '1');
INSERT INTO `category` VALUES ('11', '测试1', '1', 'www.sougou.com', '0', '测试1', '测试1', '9');
INSERT INTO `category` VALUES ('14', '新闻资讯子栏目1', '1', 'www.baidu.com', '0', '0', '0', '2');
INSERT INTO `category` VALUES ('15', '1111', '1', '111', '11', '1', '1', '3');

-- ----------------------------
-- Table structure for `config`
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `code` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `wrange` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `wdir` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  `worder` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', '0', 'web_info', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('2', '0', 'basic', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('3', '0', 'display', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('4', '0', 'shopping_flow', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('5', '0', 'smtp', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('6', '0', 'hidden', 'hidden', '', '', '', '1');
INSERT INTO `config` VALUES ('7', '0', 'goods', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('8', '0', 'sms', 'group', '', '', '', '1');
INSERT INTO `config` VALUES ('9', '0', 'wap', 'hidden', '', '', '', '1');
INSERT INTO `config` VALUES ('101', '1', 'web_name', 'text', '', '', '协会', '1');

-- ----------------------------
-- Table structure for `customer`
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `classification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES ('14', '豹子头林冲', '阿里', '阿里旺旺', '1479360862', '1479361135', '-1');
INSERT INTO `customer` VALUES ('16', '中国区代理', 'MSN客服', 'MSN', '1479360942', '1479360942', '1');
INSERT INTO `customer` VALUES ('15', '英雄联盟', '腾讯', 'QQ', '1479360893', '1479360893', '-1');
INSERT INTO `customer` VALUES ('17', '天猫国际', '小小', '淘宝账号', '1479361125', '1479361125', '1');

-- ----------------------------
-- Table structure for `fenhui`
-- ----------------------------
DROP TABLE IF EXISTS `fenhui`;
CREATE TABLE `fenhui` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL COMMENT '会员id',
  `grade` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '所属分会',
  `qiyemingcheng` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '企业名称',
  `farendaibiao` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '法人代表',
  `qiyedizhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '企业地址',
  `youbian` int(11) DEFAULT NULL COMMENT '邮编',
  `farentel` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '法人电话',
  `farenmobile` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '法人手机',
  `farenfax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '法人传真',
  `contact` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '联系人',
  `tel` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '电话',
  `mobile` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT '手机',
  `fax` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '传真',
  `qiyewangzhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '企业网址',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '邮箱',
  `qiyerenshu` int(255) DEFAULT NULL COMMENT '企业人数',
  `shigongzizhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '施工资质',
  `certificatenumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '资质证书编号',
  `zhucezijin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '注册资金',
  `konggugudong` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '控股股东',
  `qiyepinpai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '企业品牌或商标',
  `jingjileixing` int(11) DEFAULT '1' COMMENT '企业经济类型 1集体经济 2私营经济 3个体经济 4联营经济 5股份制 6外商投资 7港澳台投资 8其它',
  `qiyexingzhi` int(11) DEFAULT '1' COMMENT '企业性质 1防水材料生产 2保温材料生产  3防腐材料生产  4原材料/辅材/配件等 5仪器设备制造 6施工（防水/保温/防腐） 7经销商 8协会/社团 9检测机构/实验室',
  `product` varchar(1020) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '产品信息',
  `qiyejianjie` varchar(1020) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '企业简介',
  `flag` int(2) NOT NULL DEFAULT '3' COMMENT '0未通过 1通过 2 再审核 3待审核 4已审核',
  `created_at` int(11) DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(11) DEFAULT NULL COMMENT '更新时间',
  `reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '未通过的原因',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`tel`,`id`) USING BTREE,
  UNIQUE KEY `password_reset_token` (`contact`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of fenhui
-- ----------------------------
INSERT INTO `fenhui` VALUES ('1', null, '17', '', '', '', null, '', '', '', '崔', '136133920803', '13613392803', '15830903200', '', '173@qq.com', null, '', '', '', '', '', '0', '12', '', '', '2', null, null, '电话不真气');
INSERT INTO `fenhui` VALUES ('2', null, '15', null, null, null, null, null, null, null, '王', '测试222', '13613392802', '15830903201', null, '17300@qq.com', null, null, null, null, null, null, '0', null, null, null, '1', null, null, null);
INSERT INTO `fenhui` VALUES ('26', '21', '17', '1阿斯蒂芬', '阿斯蒂芬', '格式的发给谁的', '71000', '1331234124', '15033245576', '1234431', '张张张', '15512341234', '15033245576', '1111111', 'www.baidu.com', '12341234@qq.com', '89', '公司的', '111234123412341234', '100万', '咋啊啊', '阿萨德', '1', '2', '撒地方那你就看空间', '归属地方便是', '0', '1479436440', '1479540831', null);

-- ----------------------------
-- Table structure for `fenhuigrade`
-- ----------------------------
DROP TABLE IF EXISTS `fenhuigrade`;
CREATE TABLE `fenhuigrade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of fenhuigrade
-- ----------------------------
INSERT INTO `fenhuigrade` VALUES ('17', '防水涂料分会', '10', '1479372170', '1479372170');
INSERT INTO `fenhuigrade` VALUES ('15', '单层屋面分会1', '10', '1479372121', '1479372141');
INSERT INTO `fenhuigrade` VALUES ('16', '种植屋面分会', '0', '1479372160', '1479372160');

-- ----------------------------
-- Table structure for `friend_link`
-- ----------------------------
DROP TABLE IF EXISTS `friend_link`;
CREATE TABLE `friend_link` (
  `link_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `link_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `link_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `link_logo` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `show_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lid` int(25) NOT NULL COMMENT '链接分类',
  PRIMARY KEY (`link_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of friend_link
-- ----------------------------
INSERT INTO `friend_link` VALUES ('17', '2', '2', '{\"newname\":\"582d72bd50bca.png\"}', '0', '1');
INSERT INTO `friend_link` VALUES ('16', '1', '1', '{\"newname\":\"582d72ab40046.png\"}', '0', '5');

-- ----------------------------
-- Table structure for `grade`
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of grade
-- ----------------------------
INSERT INTO `grade` VALUES ('1', '金牌会员', '10', '1478050254', '1479349640');
INSERT INTO `grade` VALUES ('2', '银牌会员', '10', '1478571040', '1479350561');
INSERT INTO `grade` VALUES ('3', '123', '10', '1478850738', '1479350571');

-- ----------------------------
-- Table structure for `group`
-- ----------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `context` text COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `display` smallint(6) NOT NULL DEFAULT '1',
  `is_show` smallint(6) NOT NULL DEFAULT '1',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `indexname` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of group
-- ----------------------------
INSERT INTO `group` VALUES ('3', 'ceshi1', 'ceshi2', '1', '1', '1', '1479258063', '1479286203');
INSERT INTO `group` VALUES ('2', 'ceshi22', 'ceshi222', '1', '1', '1', '1468486331', '1479349453');

-- ----------------------------
-- Table structure for `invoice`
-- ----------------------------
DROP TABLE IF EXISTS `invoice`;
CREATE TABLE `invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oid` int(11) DEFAULT NULL,
  `money` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoicesn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invotetime` int(11) DEFAULT NULL,
  `invotecate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoterecip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoteaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invotecode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invotephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invotewuliu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invotewunum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of invoice
-- ----------------------------
INSERT INTO `invoice` VALUES ('1', '20', '200', '测试', '111111111111', null, '增值税普通发票', '公司|测试', '地址测试', '111', '13111659824', '顺分', '2222222', '1', '1478656911', '1478656911');
INSERT INTO `invoice` VALUES ('2', '16', '300', '河北建设网络有限公司', '121231890432', null, '增值税普通发票', '测试公司名称|123', '河北地址测试测试', '111', '15031258942', '顺分', '4321212', '1', '1478656911', '1478656911');
INSERT INTO `invoice` VALUES ('3', '16', '700', '测试名称', '12323w677811', null, '增值税普通发票', '名称公司|111', '地址测试1213131121', '111', '13256703285', '圆通', '5465767', '1', '1478656911', '1478656911');

-- ----------------------------
-- Table structure for `link_type`
-- ----------------------------
DROP TABLE IF EXISTS `link_type`;
CREATE TABLE `link_type` (
  `lid` int(25) unsigned NOT NULL AUTO_INCREMENT,
  `typename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `link_file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of link_type
-- ----------------------------
INSERT INTO `link_type` VALUES ('3', '南方', 'nanfang');
INSERT INTO `link_type` VALUES ('1', '北方', 'beifang');
INSERT INTO `link_type` VALUES ('4', '东方', 'dongfang');
INSERT INTO `link_type` VALUES ('5', '西方', 'xifang');

-- ----------------------------
-- Table structure for `meeting`
-- ----------------------------
DROP TABLE IF EXISTS `meeting`;
CREATE TABLE `meeting` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `title` varchar(255) DEFAULT NULL COMMENT '会议主题',
  `summary` varchar(255) DEFAULT NULL COMMENT '摘要',
  `content` text COMMENT '内容',
  `label_img` varchar(255) DEFAULT NULL COMMENT '会场平面图',
  `beforeprompt` varchar(255) DEFAULT NULL COMMENT '会前提示',
  `duringprompt` varchar(255) DEFAULT NULL COMMENT '会间提示',
  `meetingdata` varchar(255) DEFAULT NULL COMMENT '会议资料',
  `is_pay` tinyint(1) DEFAULT '0' COMMENT '开启支付',
  `created_at` int(11) DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(11) DEFAULT NULL COMMENT '更新时间',
  `starttime` varchar(255) DEFAULT NULL COMMENT '开始时间',
  `endtime` varchar(255) DEFAULT NULL COMMENT '结束时间',
  `schedule` text,
  `enroll` int(1) DEFAULT '1' COMMENT '报名',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='会议管理表';

-- ----------------------------
-- Records of meeting
-- ----------------------------
INSERT INTO `meeting` VALUES ('126', '222', '222', '<p>222</p>', '{\"newname\":\"582d1a0f815cc.png\",\"oldname\":\"QQ\\u56fe\\u724720161116101350.png\"}', '222', '222', null, '1', '1479289044', null, '2016-11-02 06:30', '', '', '1');
INSERT INTO `meeting` VALUES ('125', '12', '12', '<p>12</p>', '{\"newname\":\"582d5fc3d560f.png\",\"oldname\":\"adjt.png\"}', '12', '121', null, '21', '1479287635', null, '', '', '', '1');
INSERT INTO `meeting` VALUES ('122', '扩大会议', '旨在扩大宣传', '哈哈', '', '手机调成震动', '不许走动', null, '1', '1479285514', null, '2016-11-16 16:38', '2016-11-18 17:25', null, '1');
INSERT INTO `meeting` VALUES ('123', '22', '22', '22', 'QQ图片20161116101350.png', '22', '22', null, '0', '1479285840', null, '2016-11-16 16:43', '2016-11-17 11:15', null, '1');
INSERT INTO `meeting` VALUES ('124', '1', '1', '1', 'QQ图片20161116101350.png', '', '', null, null, '1479287056', null, '', '', null, '1');
INSERT INTO `meeting` VALUES ('127', '333', '333', '333', 'QQ图片20161116101350.png', '11', '2', null, '2', '1479289248', null, '2016-11-17 18:30', '', null, '1');
INSERT INTO `meeting` VALUES ('128', '123123', '123', '123', null, '12', '123', null, '21', '1479289285', null, '', '', null, '1');
INSERT INTO `meeting` VALUES ('129', '44', '44', '44', null, '44', '44', null, '44', '1479289424', null, '', '', null, '1');
INSERT INTO `meeting` VALUES ('130', '55', '55', '55', null, '55', '55', null, '55', '1479289692', null, '2016-11-10 10:50', '', null, '1');
INSERT INTO `meeting` VALUES ('131', '12', '12', '12', '{\"newname\":\"582d00386bc07.png\",\"oldname\":\"QQ\\u56fe\\u724720161116101350.png\"}', '12', '12', '{\"newname\":\"582d00386c7bf.txt\",\"oldname\":\"sql.txt\"}', '12', '1479344184', null, '2016-11-17 08:56', '2016-11-25 15:55', null, '1');
INSERT INTO `meeting` VALUES ('132', '11', '2123', '123', '{\"newname\":\"582d084206153.png\",\"oldname\":\"QQ\\u56fe\\u724720161116101350.png\"}', '123', '123', null, '123', '1479346242', null, '', '', null, '1');
INSERT INTO `meeting` VALUES ('1', '扩大会议', '扩大宣传', '扩大团队', '{\"newname\":\"582d19f32567e.png\",\"oldname\":\"QQ\\u622a\\u56fe20161117104558.png\"}', '手机静音', '不许走动', '{\"newname\":\"582d19c01a1a2.txt\",\"oldname\":\"sql.txt\"}', '1', '1479347486', null, '2016-11-17 09:51', '2016-11-25 15:50', null, '1');
INSERT INTO `meeting` VALUES ('134', '333', '333', '<p>333<br/></p>', '{\"newname\":\"582d21d25cda1.png\",\"oldname\":\"QQ\\u56fe\\u724720161116101350.png\"}', '333', '333', '{\"newname\":\"582d21d25d959.txt\",\"oldname\":\"sql.txt\"}', '0', '1479352786', null, '2016-11-17 11:19', '2016-11-26 11:15', '<p>333</p>', '1');
INSERT INTO `meeting` VALUES ('135', 'wwww', 'wwww', '<p>wwww<br/></p>', '{\"newname\":\"5832508515caa.png\",\"oldname\":\"tool.png\"}', 'www', 'www', '{\"newname\":\"5832508516c4a.png\",\"oldname\":\"banner_ctrls.png\"}', '1', '1479692421', null, '2016-11-03 06:30', '2016-11-16 10:50', '<p>wwww<br/></p>', '1');

-- ----------------------------
-- Table structure for `meetingenroll`
-- ----------------------------
DROP TABLE IF EXISTS `meetingenroll`;
CREATE TABLE `meetingenroll` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(255) DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `company` varchar(255) DEFAULT NULL COMMENT '单位信息',
  `address` varchar(255) DEFAULT NULL COMMENT '联系地址',
  `label_img` varchar(255) DEFAULT NULL COMMENT '个人头像',
  `created_at` int(11) DEFAULT NULL COMMENT '报名时间',
  `meeting_id` int(11) DEFAULT NULL COMMENT '会议id',
  `member_id` int(11) DEFAULT NULL COMMENT '会员id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='会议报名表';

-- ----------------------------
-- Records of meetingenroll
-- ----------------------------
INSERT INTO `meetingenroll` VALUES ('1', '张三', '男', '15831275020', '845284606@qq.com', '万虎', '天鹅路', '', null, '1', '1');
INSERT INTO `meetingenroll` VALUES ('2', '1', '1', '1', '1', '1', '1', '1', '1479439264', '2', '1');
INSERT INTO `meetingenroll` VALUES ('3', '1', '1', '1', '1', '1', '1', '1', '1479439361', '1', '1');
INSERT INTO `meetingenroll` VALUES ('4', '111', '111', '111', '111', '111', '111', '111', null, '122', '1');
INSERT INTO `meetingenroll` VALUES ('5', '2', '2', '2', '2', '2', '2', '2', '1479440324', '122', '1');
INSERT INTO `meetingenroll` VALUES ('6', '3', '3', '3', '3', '3', '3', '3', '1479440442', '122', '12');
INSERT INTO `meetingenroll` VALUES ('7', '4', '4', '4', '44444444@qq.com', '4', '4', '4', '1479447523', '122', '12');
INSERT INTO `meetingenroll` VALUES ('8', '123123', '123', '123', '123@qq.com', '123', '21', '123', null, '122', '26');
INSERT INTO `meetingenroll` VALUES ('9', '123123', '123', '123', '123@qq.com', '123', '21', '123', null, '126', '26');
INSERT INTO `meetingenroll` VALUES ('10', '12', '12', '123', '123@qq.com', '12', '12', '12', '1479456737', '7', '26');
INSERT INTO `meetingenroll` VALUES ('11', '12', '12', '12', '123@qq.com', '12', '12', '12', '1479456837', '6', '26');
INSERT INTO `meetingenroll` VALUES ('12', '小红', '女', '15512341234', '845284222@qq.com', '万虎', '北京', '小头像', '1479526278', '1', '26');
INSERT INTO `meetingenroll` VALUES ('13', '头头', '男', '15512342222', '84555555@qq.com', '有限公司', '北京', '哈哈', '1479526492', '2', '26');
INSERT INTO `meetingenroll` VALUES ('14', '头头', '男', '15512342222', '84555555@qq.com', '有限公司', '北京', '哈哈', '1479526506', '3', '26');
INSERT INTO `meetingenroll` VALUES ('15', '头头', '男', '15512342222', '84555555@qq.com', '有限公司', '北京', '哈哈', '1479526522', '4', '26');
INSERT INTO `meetingenroll` VALUES ('16', '赵阳吞', '男', '15512121212', '84521112@qq.com', '办公室', '报的名', '哇额', '1479527038', '5', '26');
INSERT INTO `meetingenroll` VALUES ('20', '1', '1', '15512342222', '84521112@qq.com', '1', '1', '1', '1479692545', '135', '26');
INSERT INTO `meetingenroll` VALUES ('21', '1', '1', '15512341234', '158@qq.com', '1', '1', '', '1479696537', '1', '22');
INSERT INTO `meetingenroll` VALUES ('22', '1', '1', '15512342222', '158@qq.com', '1', '1', '', '1479696603', '122', '22');
INSERT INTO `meetingenroll` VALUES ('23', '1', '1', '15512121212', '845284222@qq.com', '1', '1', '', '1479717796', '1', '22');

-- ----------------------------
-- Table structure for `meeting_sign`
-- ----------------------------
DROP TABLE IF EXISTS `meeting_sign`;
CREATE TABLE `meeting_sign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meeting_id` int(11) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='会议签到表';

-- ----------------------------
-- Records of meeting_sign
-- ----------------------------
INSERT INTO `meeting_sign` VALUES ('1', '126', '1', null);
INSERT INTO `meeting_sign` VALUES ('2', '126', '2', null);
INSERT INTO `meeting_sign` VALUES ('3', '126', '3', null);
INSERT INTO `meeting_sign` VALUES ('4', '2', '7', null);
INSERT INTO `meeting_sign` VALUES ('5', '1', '22', '1479376463');
INSERT INTO `meeting_sign` VALUES ('6', '1', '22', '1479376495');
INSERT INTO `meeting_sign` VALUES ('7', '122', '26', '1479546306');
INSERT INTO `meeting_sign` VALUES ('8', '1', '26', '1479546397');
INSERT INTO `meeting_sign` VALUES ('11', '122', '26', '1479546540');
INSERT INTO `meeting_sign` VALUES ('12', '122', '26', '1479546617');
INSERT INTO `meeting_sign` VALUES ('13', '126', '26', '1479690776');
INSERT INTO `meeting_sign` VALUES ('14', '122', '26', '1479691387');
INSERT INTO `meeting_sign` VALUES ('15', '1', '26', '1479692020');
INSERT INTO `meeting_sign` VALUES ('16', '135', '26', '1479692564');
INSERT INTO `meeting_sign` VALUES ('17', '122', '22', '1479696610');
INSERT INTO `meeting_sign` VALUES ('30', '1', '22', '1479699247');
INSERT INTO `meeting_sign` VALUES ('31', '1', '22', '1479699314');
INSERT INTO `meeting_sign` VALUES ('32', '1', '22', '1479706070');
INSERT INTO `meeting_sign` VALUES ('33', '1', '22', '1479706195');
INSERT INTO `meeting_sign` VALUES ('34', '1', '22', '1479706215');
INSERT INTO `meeting_sign` VALUES ('35', '1', '22', '1479706230');
INSERT INTO `meeting_sign` VALUES ('36', '1', '22', '1479706258');
INSERT INTO `meeting_sign` VALUES ('37', '1', '22', '1479706379');

-- ----------------------------
-- Table structure for `member`
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `idcard` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `faceimg` text COLLATE utf8_unicode_ci NOT NULL,
  `sex` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `birthday` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comefrom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `work` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `realname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `grade` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ask` text COLLATE utf8_unicode_ci,
  `englishcompany` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isopen` int(11) DEFAULT '0',
  `flag` tinyint(1) DEFAULT '0',
  `xingzhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `moshi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pinpai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `daipinpai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bennum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `grnum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nianmoney` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wairatio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `caigoutoubiao` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `yyzhizao` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zzdengji` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qychengli` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zjjigou` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `faren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `farentel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `farensex` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `farenphone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `farenemail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zhucezj` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zcdizhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zcyoubian` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jyfanwei` text COLLATE utf8_unicode_ci,
  `frdaibiaojj` text COLLATE utf8_unicode_ci,
  `yyzhizhaoimg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fwdengjiimg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zzjigouimg` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cardz` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cardf` varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`,`id`) USING BTREE,
  UNIQUE KEY `password_reset_token` (`password_reset_token`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of member
-- ----------------------------
INSERT INTO `member` VALUES ('1', '测试1211', 'YrXRl2sEhN8UpQQbGJ1aBuZIwVtoanfv', '$2y$13$SIpE4YoGMjaC3D2nMmkCzuNnJuockZr13X.gPbzg2pSugouO8mZGy', null, '15830903200', '130603198803230318', '123.125.114.144', '{\"newname\":\"5818321e6b5fa.jpg\",\"oldname\":\"1470291918628.jpg\"}', '男', '1988-03-23', '28', '', 'work', 'address', 'wuwenhan', 'wuwenhan@live.cn', '', '20', '1451577600', '1477980703', '111', null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('2', '测试222', 'AAzBea1TcwSWT7-o5X436RDfBPMk45oC', '$2y$13$XJP24Df6VkNz7mIiBczEQeaNcgAmh0W6CVHpT/y6gfoNt40MFvzga', null, '15830903201', '130603198803180318', '121.19.168.165', '{\"newname\":\"582c22b355807.png\",\"oldname\":\"QQ\\u56fe\\u724720161116101350.png\"}', '男', '1988-03-18', '28', '', '222', '333', '1111', '329576084@qq.com', '1', '20', '1454256000', '1479287475', '222', '1111', null, '2222', '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('3', 'ceshi333', 'Mhmi0j72NU6lerggNfM_6k1qsbP4l43S', '$2y$13$UJG8ZTrZajoAFZ0FDVX8Lewq2FLTPCaFZC2oBYUlYnsv98yI6mfh6', null, '15830903200', '', '', '', '', '', '', '', '111', '111', '', '111', '', '10', '1456761600', '1478571064', null, '111', null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('5', 'ceshi55', 'Hmbd-7gHkQplzQb0o1v4Pog0E3gtPvxJ', '$2y$13$IvvWx6VPei0bHxcprs8ljuRrW6.XCtFret6sYDnmG.R/sJAXzGATm', null, '15830903200', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1459440000', '1478586705', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('7', 'wanhutest', 'MxDjPd8oywGaCZwcLKNWR10q46Pz8TDF', '$2y$13$FZ9Wa.ds52jzZHgeDQRGX.C.cqYtDTmXBNNDdjt8Al9wtW755Yaka', null, '18031284203', '', '', '', '', '', '', '', '', '', '大头', '', '', '10', '1462032000', '1478856321', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '13062719000502107x', '{\"newname\":\"58258e8177201.png\",\"oldname\":\"20150412120600_bi\\u516c\\u5143prochi18.png\"}', '{\"newname\":\"58258e817d792.jpg\",\"oldname\":\"556539c6N570b3bc119.jpg\"}');
INSERT INTO `member` VALUES ('9', '123456', 'F0Gvbp-v0rIdxK3KkyUSlGI80vtM_uzy', '$2y$13$sqmaYBCQ8VbiQW.id4RRHOH.ZZpzfnSQGsUQcnWYsziS812nRih5W', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1464710400', '1478659389', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('10', 'test123', 'j24PwFbyCwg9nM-ERJlmLo5wER26WU2H', '$2y$13$1zpid5M2UY0/EaYF5QbFTOw3oVuFQzQwKwJFUslOxP0GdeV0Lgc2W', null, '18031284211', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1467302400', '1478683329', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('14', '12345678', 'VOjQF0FFND5DezfZ6MwLXst8XWfKb2jm', '$2y$13$1hg39IpSVHR2FyPikDuuYuIoTXr5RSyJOMsuwhdagnsiVRfPwUpxK', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '0', '1467907200', '1478748151', 'qwer', null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('20', 'qweqwe', 'kRZ3aEuT7eYIpi4m98UfXMH2LEQByezc', '$2y$13$qRW2VmEL.tAKajQKvlbk4.xlyPo4H2H95.rhjH/QHdr92oI35nnfu', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479259756', '1479259756', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('21', 'zsn', 'wb_Zg2H-kCepg6ReEulwt__35a2QYEPB', '$2y$13$tDt9yKTjvtGba4rqA3SQhuFeQEdqzYbHGPMiKT6RorFh51jGqEv1a', null, '15033245576', '', '', '', '', '', '', '', '网站建设', '天鹅西路世纪大厦A座607技术部', '', '358657891@qq.com', '', '10', '1479265010', '1479265129', null, '万虎网络', '1+1=？', null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('22', '111111', 'D4GIgGIEewz0DeGxWEON8Bo1fPnwCLb4', '$2y$13$VHz5Dn1i3xupEaH7MNOfaOFwWRT1HNB/XhaccNzQ33mY1LYiYW2u2', null, '13111111111', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479265669', '1479265669', null, null, null, null, '0', '0', '3123', '234234', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('23', '1111', '_LLrQxQu23tkG5gTBcwE4xP6MYQAc_G6', '$2y$13$rMyRFrtHuKkRaPWUj7gkNucMSGwqihulwwCjG/34kYNNnUXGg1ZCy', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479347801', '1479347801', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('24', 'qwe123', 'wvFAS3HyxWJSyc26Ow78QtBQvQBXq5Pc', '$2y$13$JGneph4sR7GusnL40mWxr.yKJoDPOqPLqPKThJ3G2DQn.rqlCTQ5a', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479447948', '1479447948', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('26', '222222', 'eSvJvcG5FNXX_xQpZ1udmKaLjWoKX8U0', '$2y$13$lknrH36o0PR4ZzK/pmZuf.1zuphkyOyY4C3W9Q2xWLJxXkkANCR1O', null, '15831275000', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479526010', '1479526010', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('25', 'qwerqwer', 'Qi-xb3ECVqGxyBv67wVuurFuTwMj2nIR', '$2y$13$0NFdnF4xCNkEc9cmvg5KpuNXPXH/a.X80JT.GcZ1VHPp2YkGTnrOa', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479520314', '1479520314', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('27', 'qwer123', '1oDmjWeHQgz6DIicefYriOLEHgve-xim', '$2y$13$sWcQ7O7uz52zsOxSNN7yNOapgbWZb./saQfo5HDyVpyAOuFPIghZK', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479526114', '1479526114', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `member` VALUES ('28', 'qwer1234', 'BvHUxwZ131I3HneoWPBlUvGXjeg3L8LT', '$2y$13$5unpWVeGmSvXHtWi0pg7qeuLKFY0MP8b12hhF38XZBMk0Pj4P0tou', null, '15194978202', '', '', '', '', '', '', '', '', '', '', '', '', '10', '1479717553', '1479717553', null, null, null, null, '0', '0', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `message`
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `status` int(10) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL COMMENT '单位名称',
  `email` varchar(255) NOT NULL COMMENT '电子邮箱',
  `content` varchar(255) NOT NULL COMMENT '留言内容',
  `create_time` bigint(255) NOT NULL,
  `replay_msg` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL COMMENT '姓名(您的称呼)',
  `phone` varchar(30) NOT NULL COMMENT '联系电话(手机号码)',
  `ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES ('11', '0', '111', '111', '111', '1479262125', '', '111', '111', '127.0.0.1');
INSERT INTO `message` VALUES ('4', '0', '123123', '123', '12', '1479192344', '回复1', '12', '11', '127.0.0.1');
INSERT INTO `message` VALUES ('9', '0', '11', '11', '12', '1479260271', '13', '12', '123123', '127.0.0.1');
INSERT INTO `message` VALUES ('10', '0', '1123', '123', '1231', '1479260573', '123', '123123123', '123', '127.0.0.1');

-- ----------------------------
-- Table structure for `migration`
-- ----------------------------
DROP TABLE IF EXISTS `migration`;
CREATE TABLE `migration` (
  `version` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of migration
-- ----------------------------
INSERT INTO `migration` VALUES ('m000000_000000_base', '1468295472');
INSERT INTO `migration` VALUES ('m130524_201442_init', '1468295474');
INSERT INTO `migration` VALUES ('m160714_032337_create_new_table', '1468467066');
INSERT INTO `migration` VALUES ('m160714_080807_create_group_table', '1468484507');
INSERT INTO `migration` VALUES ('m161031_080100_create_member_table', '1477901277');
INSERT INTO `migration` VALUES ('m161101_080020_create_grade_table', '1478049194');
INSERT INTO `migration` VALUES ('m161104_005858_create_articles_table', '1478221913');
INSERT INTO `migration` VALUES ('m161104_084258_update_member_table', '1478249672');
INSERT INTO `migration` VALUES ('m161107_065603_update_articles_table', '1478501996');
INSERT INTO `migration` VALUES ('m161108_065747_update_member_table', '1478588948');
INSERT INTO `migration` VALUES ('m161111_014509_create_order_table', '1478829335');
INSERT INTO `migration` VALUES ('m161111_020823_create_invoice_table', '1478830442');

-- ----------------------------
-- Table structure for `notice`
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES ('3', '1', '1', '2016-11-15 14:30', '1479191494', '1479191494', null, null);

-- ----------------------------
-- Table structure for `noticemem`
-- ----------------------------
DROP TABLE IF EXISTS `noticemem`;
CREATE TABLE `noticemem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `noticeid` int(11) DEFAULT NULL,
  `memberid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of noticemem
-- ----------------------------

-- ----------------------------
-- Table structure for `oauth_qq`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_qq`;
CREATE TABLE `oauth_qq` (
  `openid` varchar(100) NOT NULL DEFAULT '' COMMENT 'client_id',
  `access_token` varchar(100) DEFAULT NULL COMMENT 'qq令牌',
  `uid` int(10) unsigned DEFAULT NULL COMMENT '本地用户ID',
  PRIMARY KEY (`openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='qq绑定表';

-- ----------------------------
-- Records of oauth_qq
-- ----------------------------

-- ----------------------------
-- Table structure for `oauth_sinawb`
-- ----------------------------
DROP TABLE IF EXISTS `oauth_sinawb`;
CREATE TABLE `oauth_sinawb` (
  `openid` varchar(100) NOT NULL DEFAULT '' COMMENT 'client_id',
  `access_token` varchar(100) DEFAULT NULL COMMENT '令牌',
  `uid` int(10) unsigned DEFAULT NULL COMMENT '本地用户ID',
  PRIMARY KEY (`openid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='新浪微博绑定表';

-- ----------------------------
-- Records of oauth_sinawb
-- ----------------------------

-- ----------------------------
-- Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL,
  `memname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `memphone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ordersn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paytime` int(11) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `payway` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paymoney` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `realmoney` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoicemoney` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `isinvoice` int(11) DEFAULT NULL,
  `starttime` int(11) DEFAULT NULL,
  `endtime` int(11) DEFAULT NULL,
  `paycategory` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ordersn` (`ordersn`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', '20', null, null, '协会会员费用', '200262905690615', null, null, '按月（1月）', '500', '512', null, null, null, null, '新购', '2', '1399331532', '1478656911');
INSERT INTO `orders` VALUES ('2', '16', null, null, '协会会员费用22', '200262905690616', null, null, null, '200', null, null, null, null, null, null, '2', '1478656911', '0');
INSERT INTO `orders` VALUES ('3', '17', null, null, '协会会员费用3', '200262905690618', null, null, null, '100', null, null, null, null, null, null, '2', '1478656911', '1478656911');
INSERT INTO `orders` VALUES ('4', '16', null, null, '协会会员费用4', '200262905690619', null, null, null, '500', '121', null, null, null, null, 'hah', '2', '1430874488', '17');
INSERT INTO `orders` VALUES ('5', '15', null, null, '协会会员费用4', '200262905690620', null, null, null, '6000', '12', null, null, null, null, '12', '2', '1441501688', '0');

-- ----------------------------
-- Table structure for `setting`
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `code` varchar(32) CHARACTER SET utf8 NOT NULL,
  `type` varchar(32) CHARACTER SET utf8 NOT NULL,
  `store_range` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `store_dir` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `value` text CHARACTER SET utf8,
  `sort_order` int(11) NOT NULL DEFAULT '50',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of setting
-- ----------------------------
INSERT INTO `setting` VALUES ('1', '0', 'info', 'group', '', '', '', '50');
INSERT INTO `setting` VALUES ('2', '0', 'basic', 'group', '', '', '', '50');
INSERT INTO `setting` VALUES ('5', '1', 'siteName', 'text', '', '', '网站名称1', '50');
INSERT INTO `setting` VALUES ('6', '1', 'siteTitle', 'text', '', '', '网站title', '50');
INSERT INTO `setting` VALUES ('7', '1', 'siteKeyword', 'text', '', '', '这是网站关建字', '50');
INSERT INTO `setting` VALUES ('8', '2', 'copyright', 'text', '', '', 'copyright ©2013—20155555555', '50');
INSERT INTO `setting` VALUES ('9', '2', 'address', 'text', '', '', '河北省保定市世纪大厦', '50');
INSERT INTO `setting` VALUES ('10', '2', 'phone', 'text', '', '', '18031284506', '50');
INSERT INTO `setting` VALUES ('11', '2', 'email', 'text', '', '', '123654852@qq.com', '50');
INSERT INTO `setting` VALUES ('12', '2', 'work', 'text', '', '', '周一到周日：9:00-21:30', '50');
INSERT INTO `setting` VALUES ('13', '2', 'postcode', 'text', '', '', '100031', '50');
INSERT INTO `setting` VALUES ('14', '2', 'beian', 'text', '', '', '111京ICP备05000539号', '50');
INSERT INTO `setting` VALUES ('16', '3', 'wx_share_title', 'text', '', '', '分享头', '50');
INSERT INTO `setting` VALUES ('4', '0', 'dx', 'group', '', '', '', '50');
INSERT INTO `setting` VALUES ('17', '3', 'wx_share_desc', 'text', '', '', '信息', '50');
INSERT INTO `setting` VALUES ('18', '3', 'wx_share_img', 'text', '', '', 'http://xx.com/style/images/header-img.png', '50');
INSERT INTO `setting` VALUES ('3', '0', 'WXShare', 'group', '', '', '', '50');
INSERT INTO `setting` VALUES ('20', '4', 'dxname', 'text', '', '', '57708', '50');
INSERT INTO `setting` VALUES ('21', '4', 'dxms', 'text', '', '', 'bbzm@5387654', '50');
INSERT INTO `setting` VALUES ('15', '2', 'service_tell', 'text', '', '', '010-66414160', '50');
INSERT INTO `setting` VALUES ('22', '4', 'dxjk', 'text', '', '', 'http://http.yunsms.cn/tx/', '50');
INSERT INTO `setting` VALUES ('19', '3', 'wx_share_link', 'text', '', '', 'http://bingbingzm.com/', '50');
INSERT INTO `setting` VALUES ('23', '2', 'jujuekefu', 'text', '', '', '0312-5387654', '50');
INSERT INTO `setting` VALUES ('24', '0', 'weipay', 'group', '', '', '微信支付', '50');
INSERT INTO `setting` VALUES ('25', '24', 'APPID', 'text', '', '', 'wx52d6ead84bdaeb9d', '50');
INSERT INTO `setting` VALUES ('26', '24', 'MCHID', 'text', '', '', '1303822501', '50');
INSERT INTO `setting` VALUES ('27', '24', 'KEY', 'text', '', '', 'lazc03125387654bingbingzhongmeng', '50');
INSERT INTO `setting` VALUES ('28', '24', 'APPSECRET', 'text', '', '', '280c95191b4e412c7412d6c9dcd1ba5b', '50');
INSERT INTO `setting` VALUES ('29', '0', 'prosetting', 'group', '', '', '', '50');
INSERT INTO `setting` VALUES ('30', '29', 'SHOUXUFEI', 'select', 'shouqu,bushouqu', '', 'bushouqu', '50');
INSERT INTO `setting` VALUES ('31', '0', 'emailset', 'group', null, null, null, '50');
INSERT INTO `setting` VALUES ('44', '41', 'thumbimg_x', 'text', null, null, '100', '50');
INSERT INTO `setting` VALUES ('33', '31', 'smtpservice', 'text', null, null, 'smtp.sina.com', '50');
INSERT INTO `setting` VALUES ('34', '31', 'smtpduankou', 'text', null, null, '25', '50');
INSERT INTO `setting` VALUES ('35', '31', 'emailadr', 'text', null, null, 'douweiheng123@sina.com', '50');
INSERT INTO `setting` VALUES ('36', '31', 'emailuname', 'text', null, null, 'douweiheng123@sina.com', '50');
INSERT INTO `setting` VALUES ('37', '31', 'emailpwd', 'password', null, null, '13111660571', '50');
INSERT INTO `setting` VALUES ('39', '1', 'imgLOGO', 'imglogo', null, null, '582d6ef3cb86e.png', '50');
INSERT INTO `setting` VALUES ('40', '1', 'dizhiimg', 'dizhiimg', null, null, '582d6ef3cc80f.png', '50');
INSERT INTO `setting` VALUES ('41', '0', 'thumbnail', 'text', null, null, '', '50');
INSERT INTO `setting` VALUES ('42', '41', 'autothumb_ok', 'select', 'yes,no', null, 'yes', '50');
INSERT INTO `setting` VALUES ('43', '41', 'thumb_kind', 'select', 'lashen,liubai,caijian', null, 'liubai', '50');
INSERT INTO `setting` VALUES ('45', '41', 'thumbimg_y', 'text', null, null, '100', '50');
INSERT INTO `setting` VALUES ('46', '0', 'watermark', 'text', null, null, '', '50');
INSERT INTO `setting` VALUES ('47', '46', 'wate_ok', 'select', 'guanbi,kaiqi', null, 'kaiqi', '50');
INSERT INTO `setting` VALUES ('48', '46', 'wate_pic', 'wate_pic', null, null, '582d6f0628ae2.png', '50');
INSERT INTO `setting` VALUES ('49', '46', 'wate_position_x', 'text', null, null, '0', '50');
INSERT INTO `setting` VALUES ('50', '46', 'wate_position_y', 'text', null, null, '0', '50');
INSERT INTO `setting` VALUES ('51', '0', 'captcha', 'text', null, null, '1', '50');
INSERT INTO `setting` VALUES ('52', '0', 'captcha_type', 'text', null, null, 'letter', '50');
INSERT INTO `setting` VALUES ('53', '0', 'captcha_width', 'text', null, null, '80', '50');
INSERT INTO `setting` VALUES ('54', '0', 'captcha_height', 'text', null, null, '40', '50');
INSERT INTO `setting` VALUES ('38', '1', 'log', 'select', 'yes,no', null, 'no', '50');
INSERT INTO `setting` VALUES ('55', '2', 'tongji', 'textarea', null, null, '<script>\r\nvar _hmt = _hmt || [];\r\n(function() {\r\n  var hm = document.createElement(\"script\");\r\n  hm.src = \"https://hm.baidu.com/hm.js?c21add08de1f860cb060fbcbd47ea519\";\r\n  var s = document.getElementsByTagName(\"script\")[0]; \r\n  s.parentNode.insertBefore(hm, s);\r\n})();\r\n</script>\r\n', '50');
INSERT INTO `setting` VALUES ('56', '1', 'tsurl', 'text', null, null, '0576.jiaoyinet.com', '50');
INSERT INTO `setting` VALUES ('57', '1', 'tstoken', 'text', null, null, 'gwdXHeNwp7ixvhlU', '50');
INSERT INTO `setting` VALUES ('58', '1', 'qqappid', 'text', null, null, '101145243', '50');
INSERT INTO `setting` VALUES ('59', '1', 'qqappkey', 'text', null, null, '1016c728351ccd6756becae709b295f3', '50');
INSERT INTO `setting` VALUES ('60', '1', 'qqcallback', 'text', null, null, 'http://www.xiehiu.com/qqcallback/index', '50');
INSERT INTO `setting` VALUES ('61', '1', 'wb_akey', 'text', null, null, null, '50');
INSERT INTO `setting` VALUES ('62', '1', 'wb_skey', 'text', null, null, null, '50');
INSERT INTO `setting` VALUES ('63', '1', 'wb_callback', 'text', null, null, null, '50');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `groupid` int(11) NOT NULL,
  `role` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user',
  `status` smallint(6) NOT NULL DEFAULT '10',
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `username` (`username`,`id`) USING BTREE,
  UNIQUE KEY `password_reset_token` (`password_reset_token`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', '1lxN9GV_gTdndYtJ-pxxd_Nb1ZJ3gU41', '$2y$13$FGktrsxaDY8p5CmnJ1n8YegVDuv59fGxLz5lqwT7/w9sZp5WLN3MK', '27SkpAencVG4VrIHcK04qBfqEqXbs_m__1452844328', 'admin@demo.com', '0', 'admin', '10', '1468295474', '1468479829');
INSERT INTO `user` VALUES ('2', 'wuwenhan', '7UOJQiOKwdjf', '', '', 'wuwenhan@live.cn', '2', 'user', '10', '1468295474', '1468486349');
INSERT INTO `user` VALUES ('3', '测试123', 'Fa9kZyA88lp6EEfCOpgDuYxPSJBPffZO', '$2y$13$/wp0PgoRCfhn0WIbNaGL1.ZlCrlTa63zIw3m/DUsU3GC6LV/3ONji', '31m6eP1_yviVnKSztbvWgilAATtiollj_1468480557', 'ceshi123@qq.com', '0', 'user', '10', '1468480557', '1468480557');
INSERT INTO `user` VALUES ('4', '测试222', 'W0dthBePC8VsNFv3e3wikNiJ412jXdxx', '$2y$13$1YOZMMeQ09126IbAKHS6huKpirw4p0QWauitBfGrmoLNCXMdReVt6', 'lve0kr7LvFj60H2nqn8reo04GEjCjgYA_1468481007', 'ceshi222@qq.com', '0', 'user', '10', '1468481006', '1468481006');
INSERT INTO `user` VALUES ('5', 'ceshi333', 'JFLYH6TFRbsGl53eyA5pZM2s-UKs1Dmx', '$2y$13$pweroN/LpsPFnTX1l0edeuvi16sZqhoOCkd2IsratCDgtNnZI8iCW', 'EbT2kVNohA62j1IiD2w4LEcQJQVJjY1__1468481348', 'ceshi333@ceshi.com', '2', 'user', '10', '1468481348', '1468489340');