/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 5.5.62-log : Database - shudong
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `chat_event` */
CREATE TABLE `chat_event` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `from` bigint(20) unsigned NOT NULL DEFAULT '0',
  `to` bigint(20) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `type` char(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `content` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MEMORY AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
/*Table structure for table `chat_ip` */
CREATE TABLE `chat_ip` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `from` bigint(20) unsigned NOT NULL DEFAULT '0',
  `to` bigint(20) unsigned NOT NULL DEFAULT '0',
  `range` bigint(20) unsigned NOT NULL,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `range` (`range`)
) ENGINE=MyISAM AUTO_INCREMENT=987 DEFAULT CHARSET=latin1;
/*Table structure for table `chat_online` */
CREATE TABLE `chat_online` (
  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `to` bigint(20) unsigned NOT NULL DEFAULT '0',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `ip` int(10) NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Table structure for table `wxw_comment` */
CREATE TABLE `wxw_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) NOT NULL,
  `author` varchar(30) NOT NULL,
  `content` varchar(200) NOT NULL,
  `good` int(11) NOT NULL,
  `bad` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `qqopenid2` varchar(50) DEFAULT NULL,
  `ip2` varchar(20) NOT NULL,
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32236 DEFAULT CHARSET=utf8;
/*Table structure for table `wxw_content` */
CREATE TABLE `wxw_content` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(30) NOT NULL,
  `content` varchar(600) NOT NULL,
  `class_id` int(11) NOT NULL,
  `comment_count` int(11) NOT NULL,
  `comment_time` int(11) NOT NULL,
  `post_time` int(11) NOT NULL,
  `good` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `ip1` varchar(20) NOT NULL,
  `qqopenid1` varchar(50) DEFAULT NULL,
  `islock` tinyint(1) NOT NULL DEFAULT '0',
  `isdel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12252 DEFAULT CHARSET=utf8;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;