-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2013 年 12 月 24 日 06:15
-- 服务器版本: 5.0.90
-- PHP 版本: 5.2.14

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;

--
-- 数据库: `mengmademodb`
--

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

--
-- 表的结构 `ycsk_book`
--

CREATE TABLE IF NOT EXISTS `ycsk_book` (
  `ID` int(11) NOT NULL auto_increment COMMENT '自动编号',
  `Name` varchar(100) default NULL COMMENT '姓名',
  `Sex` int(11) default NULL COMMENT '性别',
  `Email` varchar(100) default NULL COMMENT '邮箱',
  `Tel` varchar(100) default NULL COMMENT '电话',
  `Title` varchar(100) default NULL COMMENT '留言标题',
  `Content` tinytext COMMENT '留言内容',
  `IP` int(11) default NULL COMMENT 'IP地址',
  `AddTime` datetime default NULL COMMENT '留言时间',
  `IsReply` bit(1) default NULL COMMENT '是否回复',
  `ReplyContent` text COMMENT '回复内容',
  `ReplyTime` datetime default NULL COMMENT '回复时间',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='留言板' AUTO_INCREMENT=4 ;

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

INSERT INTO `ycsk_book` (`ID`, `Name`, `Sex`, `Email`, `Tel`, `Title`, `Content`, `IP`, `AddTime`, `IsReply`, `ReplyContent`, `ReplyTime`) VALUES
(3, 'test', 1, 'hah@163.com', '32423432', '0', 'test', 234343, '2013-12-24 14:13:25', '\0', NULL, NULL);

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

--
-- 表的结构 `ycsk_news`
--

CREATE TABLE IF NOT EXISTS `ycsk_news` (
  `ID` int(11) NOT NULL auto_increment COMMENT '自动编号',
  `Title` varchar(100) default NULL COMMENT '标题',
  `ClassID` int(11) default NULL COMMENT '所属分类',
  `Content` text COMMENT '内容',
  `DefaultPicUrl` varchar(200) default NULL COMMENT '标题图片',
  `UploadFiles` datetime default NULL COMMENT '上传图片',
  `AddDate` int(11) default NULL COMMENT '添加日期',
  `Sort` int(11) default NULL COMMENT '排序',
  `Hits` int(11) default NULL COMMENT '点击率',
  `IsShow` bit(1) default NULL COMMENT '是否显示',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='新闻表' AUTO_INCREMENT=2 ;

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

INSERT INTO `ycsk_news` (`ID`, `Title`, `ClassID`, `Content`, `DefaultPicUrl`, `UploadFiles`, `AddDate`, `Sort`, `Hits`, `IsShow`) VALUES
(1, '5', 45, '45erwewe', '45', '0000-00-00 00:00:00', 0, 0, 0, '\0');

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

--
-- 表的结构 `ycsk_newsclass`
--

CREATE TABLE IF NOT EXISTS `ycsk_newsclass` (
  `ID` int(11) NOT NULL auto_increment COMMENT '自动编号',
  `Title` varchar(100) default NULL COMMENT '分类标题',
  `ParentID` int(11) default NULL COMMENT '父级编号',
  `Sort` int(11) default NULL COMMENT '排序号码',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='新闻分类表' AUTO_INCREMENT=3 ;

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

INSERT INTO `ycsk_newsclass` (`ID`, `Title`, `ParentID`, `Sort`) VALUES
(1, '32', 1, 23),
(2, '32', 23432, 32432);

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

--
-- 表的结构 `ycsk_user`
--

CREATE TABLE IF NOT EXISTS `ycsk_user` (
  `ID` int(11) NOT NULL auto_increment COMMENT '自动编号',
  `UserName` varchar(50) character set gb2312 default NULL COMMENT '用户名称',
  `UserPWD` varchar(20) default NULL COMMENT '用户密码',
  `Wage` double default NULL COMMENT '工资',
  `RegDate` datetime default NULL COMMENT '注册日期',
  `LastLoginIP` varchar(30) default NULL COMMENT '最后登录IP',
  `LastLoginTime` datetime default NULL COMMENT '最后登录时间',
  `Logins` int(4) default NULL COMMENT '登录次数',
  `IsEnable` bit(1) default NULL COMMENT '是否启用',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='会员表' AUTO_INCREMENT=127 ;

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

INSERT INTO `ycsk_user` (`ID`, `UserName`, `UserPWD`, `Wage`, `RegDate`, `LastLoginIP`, `LastLoginTime`, `Logins`, `IsEnable`) VALUES
(81, 'adfsdf', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(82, 'adfsdf', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(83, 'adfsdf', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(86, 'xxxxx', 'adfsdf', 99, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 999, '\0'),
(85, 'adfsdf', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(88, 'xxxxx', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(89, 'xxxxx', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(90, 'xxxxx', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(91, 'xxxxx', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(93, 'xxxxx', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0'),
(94, 'xxxxxvv', 'adfsdf', NULL, '2012-09-06 00:00:00', '127.0.0.2', '2012-09-06 00:00:00', 9, '\0');
