/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50528
 Source Host           : localhost
 Source Database       : cms

 Target Server Version : 50528
 File Encoding         : utf-8

 Date: 08/27/2015 23:48:45 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `cms_article`
-- ----------------------------
DROP TABLE IF EXISTS `cms_article`;
CREATE TABLE `cms_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) DEFAULT NULL,
  `content` text,
  `editor` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_comment`
-- ----------------------------
DROP TABLE IF EXISTS `cms_comment`;
CREATE TABLE `cms_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_consult`
-- ----------------------------
DROP TABLE IF EXISTS `cms_consult`;
CREATE TABLE `cms_consult` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT NULL,
  `tid` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `ip` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_member`
-- ----------------------------
DROP TABLE IF EXISTS `cms_member`;
CREATE TABLE `cms_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `sex` int(2) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `type` int(2) NOT NULL,
  `status` int(2) NOT NULL COMMENT '状态',
  `pic` varchar(100) NOT NULL COMMENT 'pic头像',
  `role_id` int(11) NOT NULL,
  `nickname` varchar(100) DEFAULT NULL,
  `single` varchar(200) DEFAULT NULL,
  `arcount` int(11) DEFAULT NULL,
  `visitcount` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_navmenu`
-- ----------------------------
DROP TABLE IF EXISTS `cms_navmenu`;
CREATE TABLE `cms_navmenu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `seodesc` text,
  `seowords` varchar(500) DEFAULT NULL,
  `type` int(10) NOT NULL,
  `templatelist` varchar(200) DEFAULT NULL,
  `templateview` varchar(200) DEFAULT NULL,
  `templateindex` varchar(200) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `css` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_navmenu_copy`
-- ----------------------------
DROP TABLE IF EXISTS `cms_navmenu_copy`;
CREATE TABLE `cms_navmenu_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `seodesc` text,
  `seowords` varchar(500) DEFAULT NULL,
  `type` int(10) NOT NULL,
  `templatelist` varchar(200) DEFAULT NULL,
  `templateview` varchar(200) DEFAULT NULL,
  `templateindex` varchar(200) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `url` varchar(200) DEFAULT NULL,
  `css` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_sysconfig`
-- ----------------------------
DROP TABLE IF EXISTS `cms_sysconfig`;
CREATE TABLE `cms_sysconfig` (
  `varid` int(1) NOT NULL AUTO_INCREMENT,
  `varname` varchar(50) NOT NULL DEFAULT '' COMMENT '参数名',
  `varinfo` varchar(100) NOT NULL DEFAULT '' COMMENT '参数说明',
  `groupid` smallint(6) NOT NULL DEFAULT '1',
  `type` varchar(10) NOT NULL DEFAULT 'string',
  `varvalue` text,
  `website` int(11) DEFAULT NULL,
  PRIMARY KEY (`varid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='系统全局变量';

-- ----------------------------
--  Table structure for `cms_title`
-- ----------------------------
DROP TABLE IF EXISTS `cms_title`;
CREATE TABLE `cms_title` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeid` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `shortpic` varchar(255) DEFAULT NULL,
  `shortdesc` varchar(255) DEFAULT NULL,
  `shortkeywords` varchar(255) DEFAULT NULL,
  `click` int(11) DEFAULT '126',
  `author` int(11) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `tag` varchar(50) DEFAULT NULL,
  `inner_sort` int(11) DEFAULT NULL,
  `good` int(11) DEFAULT '0',
  `bad` int(11) DEFAULT '0',
  `isfrom` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `cms_word`
-- ----------------------------
DROP TABLE IF EXISTS `cms_word`;
CREATE TABLE `cms_word` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(512) DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
