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