-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2009 年 05 月 04 日 05:45
-- 服务器版本: 5.0.51
-- PHP 版本: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 数据库: `chat`
--

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

--
-- 表的结构 `chat_style`
--

CREATE TABLE IF NOT EXISTS `chat_style` (
  `userid` int(11) NOT NULL,
  `language` varchar(20) collate utf8_unicode_ci NOT NULL,
  `showstyle` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- 表的结构 `guest`
--

CREATE TABLE IF NOT EXISTS `guest` (
  `id` int(11) NOT NULL,
  `ip` varchar(20) collate utf8_unicode_ci NOT NULL,
  `address` varchar(200) collate utf8_unicode_ci NOT NULL,
  `email` varchar(400) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `address` (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- 表的结构 `message`
--

CREATE TABLE IF NOT EXISTS `message` (
  `id` int(11) NOT NULL auto_increment,
  `guestmail` varchar(100) collate utf8_unicode_ci NOT NULL,
  `sendto` int(11) NOT NULL,
  `guestaddress` varchar(200) collate utf8_unicode_ci NOT NULL,
  `chattime` datetime NOT NULL,
  `message` text collate utf8_unicode_ci NOT NULL,
  `username` varchar(80) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`),
  KEY `guestmail` (`guestmail`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;

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

--
-- 表的结构 `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(80) collate utf8_unicode_ci NOT NULL,
  `password` varchar(200) collate utf8_unicode_ci NOT NULL,
  `companyname` varchar(400) collate utf8_unicode_ci NOT NULL,
  `userid` int(11) NOT NULL,
  `regtime` datetime NOT NULL,
  `url` varchar(400) collate utf8_unicode_ci NOT NULL,
  `userstate` int(11) NOT NULL default '0' COMMENT '是否在线',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;
