/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50045
Source Host           : localhost:3306
Source Database       : zibanma

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

Date: 2013-04-29 15:45:48
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `zibanma_focus`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_focus`;
CREATE TABLE `zibanma_focus` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `create_time` datetime default NULL,
  `sort` int(11) default NULL,
  `target` enum('_self','_blank') default '_self',
  `image` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_focus
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_link`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_link`;
CREATE TABLE `zibanma_link` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `logo` varchar(255) default NULL,
  `index` int(1) default '1' COMMENT '是否首页，1首页0内页',
  `name` varchar(255) default NULL,
  `qq` varchar(255) default NULL,
  `tel` varchar(255) default NULL,
  `status` int(1) default '0' COMMENT '状态1正常0删除',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_link
-- ----------------------------
INSERT INTO `zibanma_link` VALUES ('6', '紫斑马软件', 'http://www.zibanma.com', '', '1', '紫斑马软件', '0', '0', '1');

-- ----------------------------
-- Table structure for `zibanma_member_user`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_member_user`;
CREATE TABLE `zibanma_member_user` (
  `id` int(11) NOT NULL auto_increment,
  `user` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `level` int(4) default '1',
  `name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `tel` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `count_login_error` int(11) default '0',
  `last_login_time` int(11) default NULL,
  `login_number` int(11) default '0',
  `key` varchar(255) default 'zibanma',
  `status` int(1) default '1' COMMENT '状态0删除1正常',
  `manage` int(1) default '0' COMMENT '管理权限0无1有',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_member_user
-- ----------------------------
INSERT INTO `zibanma_member_user` VALUES ('2', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1', null, null, null, null, '0', '1367208941', '5', 'zibanma', '1', '1');

-- ----------------------------
-- Table structure for `zibanma_news_article`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_news_article`;
CREATE TABLE `zibanma_news_article` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `keywords` varchar(255) default NULL,
  `description` text,
  `content` text,
  `category` int(11) default NULL,
  `click` int(11) default NULL,
  `create_user` varchar(255) default NULL,
  `create_time` int(11) default NULL,
  `status` int(1) default '1' COMMENT '状态0删除1正常',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_news_article
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_news_category`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_news_category`;
CREATE TABLE `zibanma_news_category` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) default '0',
  `category_name` varchar(255) default NULL,
  `category_keywords` varchar(255) default NULL,
  `category_description` text,
  `sort` int(11) default '0',
  `status` tinyint(4) default '1' COMMENT '状态0删除1正常',
  `member_submit` tinyint(4) default '0' COMMENT '会员投稿分类0不允许1允许',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_news_category
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_pic_album`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_pic_album`;
CREATE TABLE `zibanma_pic_album` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `keywords` varchar(255) default NULL,
  `description` text,
  `content` text,
  `cover` varchar(255) default NULL,
  `click` int(11) default '0',
  `create_user` varchar(255) default NULL,
  `create_time` int(11) default NULL,
  `category` int(11) default NULL,
  `status` int(1) default '1' COMMENT '状态0删除1正常',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_pic_album
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_pic_category`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_pic_category`;
CREATE TABLE `zibanma_pic_category` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) default '0',
  `category_name` varchar(255) default NULL,
  `category_keywords` varchar(255) default NULL,
  `category_description` text,
  `sort` int(11) default '0',
  `status` tinyint(4) default '1' COMMENT '状态0删除1正常',
  `member_submit` tinyint(4) default '0' COMMENT '会员投稿分类0不允许1允许',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_pic_category
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_pic_graph`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_pic_graph`;
CREATE TABLE `zibanma_pic_graph` (
  `id` int(11) NOT NULL auto_increment,
  `content` text,
  `keywords` varchar(255) default NULL,
  `description` text,
  `pic_thumb_small` varchar(255) default NULL,
  `pic_thumb_big` varchar(255) default NULL,
  `pic_original` varchar(255) default NULL,
  `create_user` varchar(255) default NULL,
  `create_time` int(11) default NULL,
  `album` int(11) default '0' COMMENT '所属相册',
  `click` int(11) default '0',
  `status` int(1) default '1' COMMENT '状态0删除1正常',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_pic_graph
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_site_cache`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_site_cache`;
CREATE TABLE `zibanma_site_cache` (
  `id` char(255) NOT NULL default '',
  `content` text,
  `create_time` datetime default NULL,
  `create_minute` int(11) default '0' COMMENT '有效时间，单位：分钟',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_site_cache
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_site_config`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_site_config`;
CREATE TABLE `zibanma_site_config` (
  `config_id` char(255) NOT NULL default '',
  `config_content` text,
  `describe` text COMMENT '描述',
  PRIMARY KEY  (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_site_config
-- ----------------------------

-- ----------------------------
-- Table structure for `zibanma_site_navigation`
-- ----------------------------
DROP TABLE IF EXISTS `zibanma_site_navigation`;
CREATE TABLE `zibanma_site_navigation` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL COMMENT '导航名称',
  `target` enum('_self','_blank','_praent') default '_self' COMMENT '打开方式',
  `url` varchar(255) default NULL,
  `sort` int(11) default NULL,
  `attribute` varchar(255) default NULL COMMENT '属性',
  `status` int(1) default NULL COMMENT '状态0删除1正常',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zibanma_site_navigation
-- ----------------------------
