-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2016 年 07 月 26 日 14:35
-- 服务器版本: 5.5.40
-- PHP 版本: 5.2.17

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


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

--
-- 数据库: `sx_sqlproject`
--

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

--
-- 表的结构 `wa_admin`
--

CREATE TABLE IF NOT EXISTS `wa_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级用户',
  `depth` varchar(255) NOT NULL DEFAULT '' COMMENT '用户等级',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `password` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `tel` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1开启 0禁止',
  `ltime` int(11) unsigned NOT NULL DEFAULT '0',
  `lip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `addtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatatime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='管理员列表' AUTO_INCREMENT=3 ;

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

INSERT INTO `wa_admin` (`id`, `role`, `pid`, `depth`, `username`, `password`, `tel`, `email`, `name`, `isshow`, `ltime`, `lip`, `addtime`, `updatatime`) VALUES
(1, 0, 0, '0', 'testadmin', 'c1a954d841dbec94627410c5ee3d45a8', '', '', '网站管理员', 1, 1469502344, '127.0.0.1', 1460517139, 1460517139),
(2, 0, 1, '0,1', 'admin', 'c1a954d841dbec94627410c5ee3d45a8', '', '', '管理员', 1, 1468220322, '218.107.132.200', 1465807770, 1465977653);

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

--
-- 表的结构 `wa_apply`
--

CREATE TABLE IF NOT EXISTS `wa_apply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '管理员id',
  `depth` varchar(255) NOT NULL DEFAULT '' COMMENT '用户等级',
  `username` varchar(255) NOT NULL DEFAULT '' COMMENT '管理员姓名',
  `addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '信息录入时间',
  `isshow` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '审核等级（默认当前用户的等级，1 为审核通过）',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '2 正常值， 1审核不通过',
  `reviewtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '审核时间',
  `title` varchar(300) NOT NULL DEFAULT '' COMMENT '报告名称:',
  `research` varchar(120) NOT NULL DEFAULT '' COMMENT '所属国家:国籍',
  `datacate` varchar(120) NOT NULL DEFAULT '' COMMENT '类别:',
  `source` varchar(60) NOT NULL DEFAULT '' COMMENT '国内文件:',
  `complete` varchar(300) NOT NULL DEFAULT '' COMMENT '完成时间:',
  `keywords` varchar(300) NOT NULL DEFAULT '' COMMENT '关键词:可输入多个关键词，输入完成一个后请按空格或回车键',
  `file` varchar(300) NOT NULL DEFAULT '' COMMENT '附件:',
  `img` varchar(600) NOT NULL COMMENT '上传图片:',
  `Signed_document` varchar(120) NOT NULL DEFAULT '' COMMENT '已签署文件类别:',
  `Cooperation_field` varchar(120) NOT NULL DEFAULT '' COMMENT '合作领域:',
  `planning_scheme` varchar(60) NOT NULL DEFAULT '' COMMENT '规划方案:',
  `wt1` varchar(120) NOT NULL DEFAULT '' COMMENT '政策沟通:',
  `wt2` varchar(120) NOT NULL DEFAULT '' COMMENT '设施联通:',
  `wt3` varchar(120) NOT NULL DEFAULT '' COMMENT '贸易畅通:',
  `wt4` varchar(120) NOT NULL DEFAULT '' COMMENT '资金融通:',
  `wt5` varchar(120) NOT NULL DEFAULT '' COMMENT '民心相通:',
  `research_findings` text COMMENT '研究成果:',
  PRIMARY KEY (`id`),
  KEY `shenhe` (`addtime`) USING BTREE
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `wa_apply` (`id`, `uid`, `depth`, `username`, `addtime`, `isshow`, `status`, `reviewtime`, `title`, `research`, `datacate`, `source`, `complete`, `keywords`, `file`, `img`, `Signed_document`, `Cooperation_field`, `planning_scheme`, `wt1`, `wt2`, `wt3`, `wt4`, `wt5`, `research_findings`) VALUES
(1, 1, '0', '', 1469442027, 1, 2, 0, '地方大师傅', '', ',设施联通,', '中央', '2016-06-09', ',11,', '/Uploads/file/20160720/升星时代通讯录1468997590_758.docx', '', ',谅解备忘录,', '', '总体规划', ',顶层设计,', ',能源设施,', ',贸易投资,', '', '', ''),
(2, 1, '0', '', 1469442108, 1, 2, 0, 'adfsadf', '', ',政策沟通,', '中央', '2016-07-06', ',asdf,', 'asdfsdfsdf', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(3, 5, '0,1', '', 1469442440, 1, 2, 0, '1111', '', ',政策沟通,', '中央', '2016-07-05', ',111,', '/Uploads/file/20160725/艺术学院拓扑图1469442423_784.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(4, 1, '0', '', 1469442688, 1, 2, 0, '333', '', ',政策沟通,', '中央', '2016-07-06', ',33,', '/Uploads/file/20160725/艺术学院拓扑图1469442685_907.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(5, 1, '0', '', 1469442720, 1, 2, 0, '444', '', ',政策沟通,', '中央', '2016-06-29', ',44,', '/Uploads/file/20160725/艺术学院拓扑图1469442717_178.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(6, 1, '0', '', 1469442749, 1, 2, 0, '5555', '', ',政策沟通,', '中央', '2016-06-28', ',55,', '/Uploads/file/20160725/艺术学院拓扑图1469442745_732.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(7, 1, '0', '', 1469442108, 1, 2, 0, 'adfsadf', '', ',政策沟通,', '中央', '2016-07-06', ',asdf,', 'asdfsdfsdf', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(8, 5, '0,1', '', 1469442440, 1, 2, 0, '1111', '', ',政策沟通,', '中央', '2016-07-05', ',111,', '/Uploads/file/20160725/艺术学院拓扑图1469442423_784.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(9, 1, '0', '', 1469442688, 1, 2, 0, '333', '', ',政策沟通,', '中央', '2016-07-06', ',33,', '/Uploads/file/20160725/艺术学院拓扑图1469442685_907.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(10, 1, '0', '', 1469442720, 1, 2, 0, '444', '', ',政策沟通,', '中央', '2016-06-29', ',44,', '/Uploads/file/20160725/艺术学院拓扑图1469442717_178.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(11, 1, '0', '', 1469442749, 1, 2, 0, '5555', '', ',政策沟通,', '中央', '2016-06-28', ',55,', '/Uploads/file/20160725/艺术学院拓扑图1469442745_732.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(12, 5, '0,1', '', 1469442440, 1, 2, 0, '1111', '', ',政策沟通,', '中央', '2016-07-05', ',111,', '/Uploads/file/20160725/艺术学院拓扑图1469442423_784.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(13, 1, '0', '', 1469442688, 1, 2, 0, '333', '', ',政策沟通,', '中央', '2016-07-06', ',33,', '/Uploads/file/20160725/艺术学院拓扑图1469442685_907.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(14, 1, '0', '', 1469442720, 1, 2, 0, '444', '', ',政策沟通,', '中央', '2016-06-29', ',44,', '/Uploads/file/20160725/艺术学院拓扑图1469442717_178.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', ''),
(15, 1, '0', '', 1469442749, 1, 2, 0, '5555', '', ',政策沟通,', '中央', '2016-06-28', ',55,', '/Uploads/file/20160725/艺术学院拓扑图1469442745_732.docx', '', ',谅解备忘录,', '', '总体规划', '', '', '', '', '', '');

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

--
-- 表的结构 `wa_article`
--

CREATE TABLE IF NOT EXISTS `wa_article` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `editor` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '作者编辑',
  `source` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '来源',
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '标题',
  `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '描述',
  `dotop` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '置项:0 不是，其他数据为置顶排序值',
  `dotopday` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '置顶天数',
  `dotopend` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '置顶结束时间',
  `content` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `updatetime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `clicknum` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `isshow` int(2) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示 1显示，0待审核',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='内容表' AUTO_INCREMENT=2 ;

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

INSERT INTO `wa_article` (`id`, `uid`, `editor`, `source`, `title`, `description`, `dotop`, `dotopday`, `dotopend`, `content`, `addtime`, `updatetime`, `clicknum`, `sort`, `isshow`) VALUES
(1, 1, '', '', '宋德福特点是规定', '党规党法感到反感', 0, 0, 0, '电焊工第三方', 1469462400, 1469499139, 6, 0, 1);

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

--
-- 表的结构 `wa_authgroup`
--

CREATE TABLE IF NOT EXISTS `wa_authgroup` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `rules` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `wa_authgroup` (`id`, `title`, `status`, `rules`) VALUES
(1, '超级管理员', 1, '20,21,22,23,24,25,26,27,1,2,3,4,29,5,6,7,18,28,8,9,10,11,12,13,14,15,16,17,19,35,36,37,50,38,39,40,41,42,43,44,45,46,47,48,49,30,31,32,33,34,51,52,53,54'),
(2, '普通管理员', 1, '22,23,24,35,36,50,40,41,42,45,51,52');

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

--
-- 表的结构 `wa_authgroupaccess`
--

CREATE TABLE IF NOT EXISTS `wa_authgroupaccess` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL COMMENT '会员id',
  `group_id` mediumint(8) NOT NULL COMMENT '用户组id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `wa_authgroupaccess` (`id`, `uid`, `group_id`) VALUES
(1, 1, 1),
(2, 2, 2);

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

--
-- 表的结构 `wa_authgroupaccessf`
--

CREATE TABLE IF NOT EXISTS `wa_authgroupaccessf` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL COMMENT '会员id',
  `group_id` mediumint(8) NOT NULL COMMENT '用户组id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

INSERT INTO `wa_authgroupaccessf` (`id`, `uid`, `group_id`) VALUES
(1, 1, 1),
(5, 5, 2);

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

--
-- 表的结构 `wa_authgroupf`
--

CREATE TABLE IF NOT EXISTS `wa_authgroupf` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `rules` text,
  `grade` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '等级数（数字）',
  `isreview` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '等级审核权限 0没有 1有',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

INSERT INTO `wa_authgroupf` (`id`, `title`, `status`, `rules`, `grade`, `isreview`) VALUES
(1, '超级用户', 1, '1,2,3,4,7,8,9,29,30,31,6,5,10,11,12,13,14,27,18,19,20,21,26,22,23,24,25,32', 1, 1),
(2, '普通用户', 1, '1,2,3,29,30,31,6,5,10,14,27,19', 2, 0);

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

--
-- 表的结构 `wa_authrule`
--

CREATE TABLE IF NOT EXISTS `wa_authrule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(80) NOT NULL DEFAULT '',
  `title` char(20) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `condition` char(100) NOT NULL DEFAULT '',
  `catid` int(11) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;

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

INSERT INTO `wa_authrule` (`id`, `name`, `title`, `status`, `condition`, `catid`, `sort`) VALUES
(1, 'Admin-index', '管理员列表', 1, '', 8, 1),
(2, 'Admin-add', '添加管理员', 1, '', 8, 2),
(3, 'Admin-edit', '编辑管理员', 1, '', 8, 3),
(4, 'Admin-delete', '删除管理员', 1, '', 8, 4),
(5, 'Authc-rules', '规则管理', 1, '', 9, 1),
(6, 'Authc-addrule', '增加规则', 1, '', 9, 2),
(7, 'Authc-editrule', '修改规则', 1, '', 9, 3),
(8, 'Authc-delrule', '删除规则', 1, '', 9, 5),
(9, 'Authc-delallrule', '批量删除规则', 1, '', 9, 6),
(10, 'Authc-editattr', '审核规则/角色', 1, '', 9, 7),
(11, 'Authc-group', '角色列表', 1, '', 9, 8),
(12, 'Authc-addgroup', '增加角色', 1, '', 9, 9),
(13, 'Authc-editgroup', '修改角色', 1, '', 9, 10),
(14, 'Authc-delgroup', '删除角色', 1, '', 9, 11),
(15, 'Authc-fenpei', '角色分配管理', 1, '', 9, 12),
(16, 'Authc-addfenpei', '增加角色分配', 1, '', 9, 13),
(17, 'Authc-editfenpei', '修改角色分配', 1, '', 9, 14),
(18, 'Authc-delfenpei', '删除角色分配', 1, '', 9, 3),
(19, 'Authc-delallgroup', '批量删除角色分配', 1, '', 9, 16),
(20, 'Index-system', '系统参数设置', 1, '', 7, 1),
(21, 'Index-do_config', '添加系统基本设置', 1, '', 7, 2),
(22, 'Index-delcache', '清理缓存', 1, '', 7, 3),
(23, 'Baksql-index', '数据管理', 1, '', 7, 4),
(24, 'Baksql-backall', '备份数据库', 1, '', 7, 5),
(25, 'Baksql-recover', '还原数据库', 1, '', 7, 6),
(26, 'Baksql-deletebak', '删除数据库备份', 1, '', 7, 7),
(27, 'Baksql-form', '批量删除数据库备份', 1, '', 7, 8),
(28, 'Authc-changeSort', '修改规则排序', 1, '', 9, 4),
(29, 'Admin-editattr', '修改用户属性', 1, '', 8, 5),
(30, 'Reg-index', '数据字段管理', 1, '', 11, 1),
(31, 'Reg-add', '添加数据字段', 1, '', 11, 2),
(32, 'Reg-look', '查看数据字段', 1, '', 11, 3),
(33, 'Reg-edit', '修改数据字段', 1, '', 11, 4),
(34, 'Reg-delete', '删除数据字段', 1, '', 11, 5),
(35, 'Power-rules', '规则管理', 1, '', 10, 1),
(36, 'Power-addrule', '增加规则', 1, '', 10, 2),
(37, 'Power-editrule', '修改规则', 1, '', 10, 3),
(38, 'Power-delrule', '删除规则', 1, '', 10, 5),
(39, 'Power-delallrule', '批量删除规则', 1, '', 10, 6),
(40, 'Power-editattr', '审核规则/角色', 1, '', 10, 7),
(41, 'Power-group', '角色列表', 1, '', 10, 8),
(42, 'Power-addgroup', '增加角色', 1, '', 10, 9),
(43, 'Power-editgroup', '修改角色', 1, '', 10, 10),
(44, 'Power-delgroup', '删除角色', 1, '', 10, 11),
(45, 'Power-fenpei', '角色分配管理', 1, '', 10, 12),
(46, 'Power-addfenpei', '增加角色分配', 1, '', 10, 13),
(47, 'Power-editfenpei', '修改角色分配', 1, '', 10, 14),
(48, 'Power-delfenpei', '删除角色分配', 1, '', 10, 15),
(49, 'Power-delallgroup', '批量删除角色分配', 1, '', 10, 16),
(50, 'Power-changeSort', '修改规则排序', 1, '', 10, 4),
(51, 'Article-index', '资料管理', 1, '', 12, 1),
(52, 'Article-look', '查看资料', 1, '', 12, 2),
(53, 'Article-edit', '修改资料', 1, '', 12, 3),
(54, 'Article-delete', '资料删除', 1, '', 12, 4);

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

--
-- 表的结构 `wa_authrulef`
--

CREATE TABLE IF NOT EXISTS `wa_authrulef` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(80) NOT NULL DEFAULT '',
  `title` char(20) NOT NULL DEFAULT '',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `condition` char(100) NOT NULL DEFAULT '',
  `catid` int(11) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

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

INSERT INTO `wa_authrulef` (`id`, `name`, `title`, `status`, `condition`, `catid`, `sort`) VALUES
(1, 'Member-index', '个人信息查看', 1, '', 1, 1),
(2, 'Member-memedit', '个人信息修改', 1, '', 1, 2),
(3, 'Member-editpass', '个人信息修改密码', 1, '', 1, 3),
(4, 'Member-review', '资料审核列表', 1, '', 2, 1),
(5, 'Member-look', '资料预览', 1, '', 4, 4),
(6, 'Member-edit', '资料修改', 1, '', 4, 3),
(7, 'Member-Shenhe', '审核资料', 1, '', 2, 2),
(8, 'Member-checkField', '选择导出Excel字段', 1, '', 2, 3),
(9, 'Member-download', '导出Excel', 1, '', 2, 4),
(10, 'Maillist-index', '通讯录列表', 1, '', 5, 1),
(11, 'Maillist-add', '增加通讯录', 1, '', 5, 2),
(12, 'Maillist-edit', '修改通讯录', 1, '', 5, 3),
(13, 'Maillist-delete', '删除通讯录', 1, '', 5, 4),
(14, 'Maillist-download', '导出Excel', 1, '', 5, 5),
(15, 'Maillist-add_depart', '增加部门', 1, '', 5, 7),
(16, 'Maillist-edit_depart', '修改部门信息', 1, '', 5, 8),
(17, 'Maillist-del_depart', '删除部门', 1, '', 5, 9),
(18, 'Article-add', '发布通知公告', 1, '', 6, 2),
(19, 'Article-look', '查看通知公告', 1, '', 6, 3),
(20, 'Article-edit', '修改通知公告', 1, '', 6, 4),
(21, 'Article-delete', '删除通知公告', 1, '', 6, 5),
(22, 'Webuser-add', '增加用户', 1, '', 7, 2),
(23, 'Webuser-edit', '修改用户信息', 1, '', 7, 3),
(24, 'Webuser-delete', '删除用户', 1, '', 7, 4),
(25, 'Webuser-editattr', '修改用户状态', 1, '', 7, 5),
(26, 'Webuser-index', '用户列表', 1, '', 7, 1),
(27, 'Article-index', '通知公告列表', 1, '', 6, 1),
(28, 'Maillist-department', '部门管理', 1, '', 5, 6),
(29, 'Member-retrieval', '资料检索列表', 1, '', 3, 1),
(30, 'Member-applylist', '资料填报列表', 1, '', 4, 1),
(31, 'Member-apply', '新增资料填报', 1, '', 4, 2),
(32, 'Member-show', '资料展示列表', 1, '', 9, 1);

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

--
-- 表的结构 `wa_department`
--

CREATE TABLE IF NOT EXISTS `wa_department` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(120) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '学院名称',
  `firstname` varchar(255) NOT NULL DEFAULT '' COMMENT '名称第一个字母',
  `addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近一次修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='管理员列表' AUTO_INCREMENT=3 ;

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

INSERT INTO `wa_department` (`id`, `name`, `firstname`, `addtime`) VALUES
(1, '研究部', 'Y', 1466392403),
(2, '辅导', 'F', 1466392437);

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

--
-- 表的结构 `wa_maillist`
--

CREATE TABLE IF NOT EXISTS `wa_maillist` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '部门id',
  `name` varchar(120) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT '学院名称',
  `mobile` varchar(100) NOT NULL DEFAULT '' COMMENT '手机',
  `tel` varchar(188) NOT NULL DEFAULT '' COMMENT '座机',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱',
  `addtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最近一次修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员列表' AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `wa_regfields`
--

CREATE TABLE IF NOT EXISTS `wa_regfields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段名',
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '描述',
  `note` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段类型',
  `d_value` text COMMENT '字段默认值',
  `rownum` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '多行文本设置字段值行数',
  `colnum` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '多行文本设置字段值列数',
  `ctitle` text COMMENT '多列的标题,使用#分隔',
  `fline` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '是否占用整行：1不是 2是',
  `isdate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否调用日期插件：1是 0否',
  `upfile` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '调用上传组件：0否 1图片 2文件',
  `istags` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '关键字标签（0否，1是）',
  `isjs` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不调用js 其它数字调用相应的js效果',
  `issearch` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否用于检索 1是 2否',
  `isheader` tinyint(1) unsigned NOT NULL DEFAULT '2' COMMENT '是否在导航中显示 1是 2否',
  `required` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否必填：1必填 2非必填',
  `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态：1启用 2禁用',
  `isshow1` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '资源填报列表是否显示：1显示，0不显示',
  `isshow2` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '审核列表是否显示：1显示 0不显示',
  `isshow3` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '检索列表是否显示：1显示 0不显示',
  `width1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '资源填报列表显示宽度',
  `width2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '审核列表显示宽度',
  `width3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '检索列表显示宽度',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `optime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

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

INSERT INTO `wa_regfields` (`id`, `name`, `description`, `note`, `type`, `d_value`, `rownum`, `colnum`, `ctitle`, `fline`, `isdate`, `upfile`, `istags`, `isjs`, `issearch`, `isheader`, `required`, `isshow`, `isshow1`, `isshow2`, `isshow3`, `width1`, `width2`, `width3`, `sort`, `optime`) VALUES
(1, 'title', '报告名称', '', 'string', NULL, 0, 0, NULL, 1, 0, 0, 0, 0, 1, 2, 1, 1, 1, 1, 1, 240, 240, 240, 1, 1466055043),
(2, 'research', '所属国家', '国籍', 's_elect', '亚洲#欧洲#非洲#大洋洲#拉丁美洲', 0, 0, NULL, 2, 0, 0, 0, 1, 1, 1, 2, 1, 1, 1, 1, 100, 100, 100, 12, 1466055792),
(3, 'datacate', '类别', '', 'c_heckbox', '政策沟通#设施联通#贸易畅通#资金融通#民心相通#研究成果', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 2, 1, 1, 1, 1, 1, 100, 100, 100, 4, 1466055891),
(4, 'source', '国内文件', '', 'r_adio', '中央#国务院#各大部委#地方共四大类#非国内', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 1, 0, 1, 100, 100, 100, 11, 1466056016),
(5, 'complete', '完成时间', '', 'string', NULL, 0, 0, NULL, 1, 1, 0, 0, 0, 1, 2, 1, 1, 1, 1, 1, 60, 60, 60, 2, 1466056092),
(6, 'keywords', '关键词', '可输入多个关键词，输入完成一个后请按空格或回车键', 'string', NULL, 0, 0, NULL, 2, 0, 0, 1, 0, 1, 2, 1, 1, 1, 1, 1, 100, 100, 100, 3, 1466056230),
(7, 'file', '附件', '', 'string', NULL, 0, 0, NULL, 2, 0, 2, 0, 0, 2, 2, 1, 1, 0, 0, 0, 100, 100, 100, 16, 1466056301),
(9, 'Signed_document', '已签署文件类别', '', 'c_heckbox', '谅解备忘录#联合声明#战略伙伴关系', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 13, 1467163569),
(10, 'Cooperation_field', '合作领域', '', 'c_heckbox', '基础设施#资源开发#经贸合作#人文交流#生态保护', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 14, 1467163634),
(11, 'planning_scheme', '规划方案', '', 'r_adio', '总体规划#地方方案', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 5, 1467163675),
(12, 'wt1', '政策沟通', '', 'c_heckbox', '顶层设计#国际对接#配套政策#省市推进', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 6, 1467164024),
(13, 'wt2', '设施联通', '', 'c_heckbox', '交通设施#能源设施#信息设施', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 7, 1467164050),
(14, 'wt3', '贸易畅通', '', 'c_heckbox', '贸易投资#创新贸易方式#自贸区建设', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 8, 1467164079),
(15, 'wt4', '资金融通', '', 'c_heckbox', '金融合作#人民币区域化和国际化#金融监管合作', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 9, 1467164110),
(16, 'wt5', '民心相通', '', 'c_heckbox', '科学#教育#文体#卫生#智库', 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 10, 1467164185),
(17, 'research_findings', '研究成果', '', 't_extarea', NULL, 0, 0, NULL, 2, 0, 0, 0, 0, 1, 1, 2, 1, 0, 0, 0, 0, 0, 0, 15, 1468919187);

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

--
-- 表的结构 `wa_role`
--

CREATE TABLE IF NOT EXISTS `wa_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `array` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `isshow` int(1) NOT NULL DEFAULT '1',
  `updatetime` int(11) NOT NULL,
  `sort` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `wa_role` (`id`, `name`, `array`, `isshow`, `updatetime`, `sort`) VALUES
(1, '网站管理员', '', 1, 0, 0);

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

--
-- 表的结构 `wa_system`
--

CREATE TABLE IF NOT EXISTS `wa_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段名',
  `cfg` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段名称',
  `content` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '内容',
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '描述',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '字段类型',
  `isshow` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT '1显示 2 隐藏',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `optime` int(11) unsigned NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cfg` (`cfg`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

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

INSERT INTO `wa_system` (`id`, `name`, `cfg`, `content`, `description`, `type`, `isshow`, `sort`, `optime`) VALUES
(1, '网站标题', 'title', '"一带一路" 数据库管理系统', '网站标题', 'string', '1', 2, 1400219567),
(2, '网站域名', 'domain', 'http://xm.case.soogee.com', '网站域名', 'string', '1', 3, 1400219567),
(3, '关键词', 'keywords', '"一带一路" 数据库管理系统', '关键词', 'string', '1', 4, 1400219567),
(4, '描述', 'description', '"一带一路" 数据库管理系统', '描述', 'bstring', '1', 5, 1400219567),
(5, '版权信息', 'footer', 'Copyright © 2014-2024.  重阳金融研究院版权所有', '版权信息', 'bstring', '1', 6, 1400219567),
(6, '电话', 'tel', '', '电话', 'string', '1', 7, 1400219567),
(7, '传真', 'fax', '', '传真', 'string', '1', 8, 1400219567),
(8, 'Email', 'email', '', 'Email', 'string', '1', 9, 1400219567),
(9, '地址', 'add', '北京市海淀区中关村大街45号', '地址', 'string', '1', 10, 1400219567),
(10, '学院名称', 'name', '重阳金融研究院', '学院名称', 'string', '1', 1, 1400219567),
(11, '同等级交互管理', 'open_power', 'Y', '', 'bool', '1', 11, 1467170380);

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

--
-- 表的结构 `wa_webuser`
--

CREATE TABLE IF NOT EXISTS `wa_webuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` int(11) unsigned NOT NULL DEFAULT '0',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级用户',
  `depth` varchar(255) NOT NULL DEFAULT '' COMMENT '用户等级',
  `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `password` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `tel` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `email` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `isshow` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1开启 0禁止',
  `ltime` int(11) unsigned NOT NULL DEFAULT '0',
  `lip` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `position` varchar(100) NOT NULL COMMENT '当前职位',
  `addtime` int(11) unsigned NOT NULL DEFAULT '0',
  `updatatime` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='管理员列表' AUTO_INCREMENT=6 ;

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

INSERT INTO `wa_webuser` (`id`, `role`, `pid`, `depth`, `username`, `password`, `tel`, `email`, `name`, `isshow`, `ltime`, `lip`, `position`, `addtime`, `updatatime`) VALUES
(1, 0, 0, '0', 'softall', '232f7a436661ec6073ad2b70b561830e', '', '', '网站管理员', 1, 1469496856, '127.0.0.1', '', 1460517139, 1466412820),
(5, 0, 1, '0,1', 'aa', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '', '', 'softall', 1, 1469442175, '127.0.0.1', '', 1469442162, 0);

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