master

分支 (2)

管理

管理

master

v1.0

WanhuCMS
/
WanhuCMS.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50547
Source Host           : localhost:3306
Source Database       : wanhucms

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

Date: 2016-05-12 08:59:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for wcms_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `wcms_auth_group`;
CREATE TABLE `wcms_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL COMMENT '组类型',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_auth_group
-- ----------------------------
INSERT INTO `wcms_auth_group` VALUES ('1', 'admin', '1', '默认用户组', '超级管理员', '1', '1,2,3,4,5');
INSERT INTO `wcms_auth_group` VALUES ('2', 'admin', '1', '测试用户', '测试用户', '1', '1,2,3,4,5');
INSERT INTO `wcms_auth_group` VALUES ('3', 'admin', '33', '闫立测试', '这只是个测试', '1', '1,2,3,4,5');

-- ----------------------------
-- Table structure for wcms_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `wcms_auth_group_access`;
CREATE TABLE `wcms_auth_group_access` (
  `uid` mediumint(8) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_auth_group_access
-- ----------------------------
INSERT INTO `wcms_auth_group_access` VALUES ('1', '1');
INSERT INTO `wcms_auth_group_access` VALUES ('12', '2');

-- ----------------------------
-- Table structure for wcms_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `wcms_auth_rule`;
CREATE TABLE `wcms_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(100) DEFAULT 'admin',
  `name` char(80) DEFAULT '',
  `title` char(20) DEFAULT '',
  `type` tinyint(1) DEFAULT '1',
  `status` tinyint(1) DEFAULT '1',
  `condition` char(100) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_auth_rule
-- ----------------------------
INSERT INTO `wcms_auth_rule` VALUES ('1', 'admin', 'admin/Index/index', '首页', '1', '1', '');
INSERT INTO `wcms_auth_rule` VALUES ('2', 'admin', 'admin/Access/rule_add', '增加权限', '1', '1', '');
INSERT INTO `wcms_auth_rule` VALUES ('3', 'admin', 'admin/Seoset/index', 'SEO设置', '1', '1', '');
INSERT INTO `wcms_auth_rule` VALUES ('4', 'admin', 'admin/Term/addTerm', '添加栏目', '1', '1', '');
INSERT INTO `wcms_auth_rule` VALUES ('5', 'admin', 'admin/Links/index', '链接管理', '1', '1', '');

-- ----------------------------
-- Table structure for wcms_content
-- ----------------------------
DROP TABLE IF EXISTS `wcms_content`;
CREATE TABLE `wcms_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章id',
  `term_id` smallint(5) unsigned NOT NULL COMMENT '文章所属栏目id',
  `model_id` tinyint(3) NOT NULL DEFAULT '0',
  `listorder` bigint(255) NOT NULL DEFAULT '0',
  `intercept` tinyint(2) NOT NULL DEFAULT '0' COMMENT '自动截取摘要',
  `name` varchar(255) NOT NULL COMMENT '文章标题',
  `keywords` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `content` mediumtext NOT NULL COMMENT '文章内容',
  `cover_img` varchar(255) NOT NULL COMMENT '文章封面图',
  `tags_value` longtext NOT NULL COMMENT '模板自定义标签',
  `seo_title` varchar(255) NOT NULL COMMENT '文章页seo标题',
  `seo_keywords` varchar(255) NOT NULL COMMENT 'SEO关键字',
  `seo_description` varchar(255) NOT NULL COMMENT 'seo简述',
  `create_time` bigint(20) unsigned NOT NULL COMMENT '添加时间',
  `update_time` bigint(20) NOT NULL,
  `status` tinyint(11) unsigned NOT NULL DEFAULT '0',
  `rec_ok` tinyint(11) unsigned NOT NULL DEFAULT '0',
  `top_ok` tinyint(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_content
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_count
-- ----------------------------
DROP TABLE IF EXISTS `wcms_count`;
CREATE TABLE `wcms_count` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `num` bigint(255) DEFAULT '100',
  `time` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_count
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_links
-- ----------------------------
DROP TABLE IF EXISTS `wcms_links`;
CREATE TABLE `wcms_links` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `lid` int(20) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `links` varchar(255) NOT NULL,
  `creat_time` bigint(30) NOT NULL,
  `listorder` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_links
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_linktype
-- ----------------------------
DROP TABLE IF EXISTS `wcms_linktype`;
CREATE TABLE `wcms_linktype` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_linktype
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_log
-- ----------------------------
DROP TABLE IF EXISTS `wcms_log`;
CREATE TABLE `wcms_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `time` bigint(20) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_log
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_message
-- ----------------------------
DROP TABLE IF EXISTS `wcms_message`;
CREATE TABLE `wcms_message` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `message_type` int(10) NOT NULL,
  `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) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '姓名(您的称呼)',
  `phone` int(30) NOT NULL COMMENT '联系电话(手机号码)',
  `ziliao` varchar(255) NOT NULL COMMENT '资料上传',
  `ip` varchar(255) NOT NULL,
  `xqlb` varchar(100) NOT NULL COMMENT '需求类别',
  `xqname` varchar(100) NOT NULL COMMENT '需求名称',
  `dwjj` varchar(255) NOT NULL COMMENT '单位简介',
  `xqjj` varchar(255) NOT NULL COMMENT '需求简介',
  `jctj` varchar(255) NOT NULL COMMENT '基础条件',
  `hzfs` varchar(255) NOT NULL COMMENT '期望合作方式',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_message
-- ----------------------------
INSERT INTO `wcms_message` VALUES ('91', '17', '0', 'sdfsdf', '', 'sdfsdfd', '0', '', '', '0', '', '', '', '', '', '', '', '');

-- ----------------------------
-- Table structure for wcms_mtype
-- ----------------------------
DROP TABLE IF EXISTS `wcms_mtype`;
CREATE TABLE `wcms_mtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `biaoshi` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_mtype
-- ----------------------------
INSERT INTO `wcms_mtype` VALUES ('17', 'sfsdf', 'sdfsdfsd');

-- ----------------------------
-- Table structure for wcms_online
-- ----------------------------
DROP TABLE IF EXISTS `wcms_online`;
CREATE TABLE `wcms_online` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `qq` varchar(255) DEFAULT NULL,
  `msn` varchar(255) DEFAULT NULL,
  `aliww` varchar(255) DEFAULT NULL,
  `taobao` varchar(255) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `paiid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_online
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_option
-- ----------------------------
DROP TABLE IF EXISTS `wcms_option`;
CREATE TABLE `wcms_option` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `flag` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL COMMENT '配置组名',
  `item` text NOT NULL,
  `value` longtext NOT NULL COMMENT 'json格式配置信息',
  `autoload` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用此配置组',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_option
-- ----------------------------
INSERT INTO `wcms_option` VALUES ('1', 'default', 'default', '{\"title\":{\"tag_name\":\"\\u6807\\u9898\",\"tag_type\":\"input\"},\"dis\":{\"tag_name\":\"\\u7b80\\u4ecb\",\"tag_type\":\"textarea\"},\"keywords\":{\"tag_name\":\"\\u5173\\u952e\\u8bcd\",\"tag_type\":\"input\"},\"ICP\":{\"tag_name\":\"ICP\\u5907\\u6848\\u7f16\\u53f7\",\"tag_type\":\"input\"},\"bh\":{\"tag_name\":\"\\u5907\\u6848\\u7f16\\u53f7\",\"tag_type\":\"input\"},\"wxlogo\":{\"tag_name\":\"\\u4fa7\\u8fb9\\u680f\\u5fae\\u4fe1\",\"tag_type\":\"webuploader-one\"},\"sinalink\":{\"tag_name\":\"\\u65b0\\u6d6a\\u5fae\\u535a\\u94fe\\u63a5\",\"tag_type\":\"input\"},\"iphone\":{\"tag_name\":\"\\u4fa7\\u8fb9\\u680f\\u7535\\u8bdd\",\"tag_type\":\"input\"},\"qq\":{\"tag_name\":\"QQ\",\"tag_type\":\"input\"},\"banquan\":{\"tag_name\":\"\\u7248\\u6743\\u6240\\u6709\",\"tag_type\":\"input\"},\"logo\":{\"tag_name\":\"\\u7f51\\u7ad9Logo\",\"tag_type\":\"webuploader-one\"}}', '{\"title\":\"\\u56fd\\u9645\\u5148\\u8fdb\\u519c\\u4e1a\\u79d1\\u6280\\u63a8\\u5e7f\\u7f51\",\"dis\":\"\\u56fd\\u9645\\u5148\\u8fdb\\u519c\\u4e1a\\u79d1\\u6280\\u63a8\\u5e7f\\u7f51\\u56fd\\u9645\\u5148\\u8fdb\\u519c\\u4e1a\\u79d1\\u6280\\u63a8\\u5e7f\\u7f51\\u56fd\\u9645\\u5148\\u8fdb\\u519c\\u4e1a\\u79d1\\u6280\\u63a8\\u5e7f\\u7f51\",\"keywords\":\"\\u519c\\u4e1a\\u79d1\\u6280_\\u65b0\\u4f18\\u54c1\\u79cd\",\"ICP\":\"\\u4eacICP\\u590710212988\\u53f7\",\"bh\":\"\\u4eac\\u516c\\u7f51\\u5b89\\u590711010702001307\",\"wxlogo\":\"1460433439.png\",\"sinalink\":\"http:\\/\\/weibo.com\",\"iphone\":\"010-82388252\",\"qq\":\"2329984993\",\"banquan\":\"\\u4e2d\\u56fd\\u519c\\u4e1a\\u5927\\u5b66\\u5bcc\\u901a\\u516c\\u53f8\",\"logo\":\"1460433449.png\"}', '1');

-- ----------------------------
-- Table structure for wcms_seoset
-- ----------------------------
DROP TABLE IF EXISTS `wcms_seoset`;
CREATE TABLE `wcms_seoset` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hometitle` varchar(64) DEFAULT NULL,
  `title_type` tinyint(2) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `altname` varchar(255) DEFAULT NULL,
  `atitle` varchar(255) DEFAULT NULL,
  `linkname` varchar(255) DEFAULT NULL,
  `content` text,
  `seocontent` text,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_seoset
-- ----------------------------
INSERT INTO `wcms_seoset` VALUES ('2', 'dsfsdf', '0', 'sdfsdf', 'sdfdsf', 'sdfsd', 'sfsd', '<p>sdfsdfsdfsdfds</p>', '<p>sdfdsfds</p>', '1462843615', '1462843615');

-- ----------------------------
-- Table structure for wcms_tag_type
-- ----------------------------
DROP TABLE IF EXISTS `wcms_tag_type`;
CREATE TABLE `wcms_tag_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_tag_type
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_term
-- ----------------------------
DROP TABLE IF EXISTS `wcms_term`;
CREATE TABLE `wcms_term` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '栏目ID',
  `parent_id` smallint(5) unsigned NOT NULL COMMENT '父栏目id',
  `flag` varchar(255) NOT NULL DEFAULT '',
  `model_id` tinyint(4) unsigned NOT NULL COMMENT '模型ID',
  `listorder` bigint(255) NOT NULL DEFAULT '0' COMMENT '排序',
  `display_nav` int(3) NOT NULL DEFAULT '0' COMMENT '导航是否显示',
  `top_ok` int(3) NOT NULL DEFAULT '0' COMMENT '置顶',
  `rec_ok` int(3) NOT NULL DEFAULT '0' COMMENT '推荐',
  `name` varchar(64) NOT NULL,
  `description` varchar(255) NOT NULL,
  `seo_keywords` varchar(128) NOT NULL COMMENT 'seo关键字',
  `seo_description` varchar(255) NOT NULL COMMENT 'seo页面描述',
  `seo_title` varchar(128) NOT NULL COMMENT '自定义标题',
  `status` tinyint(3) unsigned NOT NULL COMMENT '文章是否显示',
  `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  `tags_value` longtext NOT NULL COMMENT '自定义标签',
  PRIMARY KEY (`id`),
  UNIQUE KEY `flag` (`flag`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_term
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_term_model
-- ----------------------------
DROP TABLE IF EXISTS `wcms_term_model`;
CREATE TABLE `wcms_term_model` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT COMMENT '模型id',
  `name` varchar(255) NOT NULL COMMENT '模型名',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为表单',
  `term_tpl` varchar(255) NOT NULL COMMENT '栏目模板',
  `term_tags` text NOT NULL COMMENT '栏目自定义标签',
  `content_tpl` varchar(255) NOT NULL COMMENT '内容页模板',
  `content_tags` text NOT NULL COMMENT '内容页自定义标签',
  `create_time` bigint(20) unsigned NOT NULL COMMENT '添加日期',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_term_model
-- ----------------------------

-- ----------------------------
-- Table structure for wcms_user
-- ----------------------------
DROP TABLE IF EXISTS `wcms_user`;
CREATE TABLE `wcms_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员id',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `passwd` char(32) NOT NULL COMMENT 'md5加密后的密码',
  `lasttime` bigint(255) NOT NULL,
  `rolesin` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_user
-- ----------------------------
INSERT INTO `wcms_user` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1463013348', '超级管理员');

-- ----------------------------
-- Table structure for wcms_visitor
-- ----------------------------
DROP TABLE IF EXISTS `wcms_visitor`;
CREATE TABLE `wcms_visitor` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT '' COMMENT '访问类型',
  `ip` varchar(255) DEFAULT '' COMMENT '访问者ip',
  `time` bigint(100) DEFAULT '0' COMMENT '访问时间',
  `url` varchar(255) DEFAULT NULL COMMENT '从哪里来',
  `counts` bigint(255) DEFAULT '1',
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of wcms_visitor
-- ----------------------------