myqq.sql

Java+Eclipse+Mysql的局域网聊天程序源代码

# EMS MySQL Manager Pro 3.2.0.1
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : MyQQ


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `MyQQ`
    CHARACTER SET 'gb2312'
    COLLATE 'gb2312_chinese_ci';

USE `MyQQ`;

#
# Structure for the `friend` table : 
#

CREATE TABLE `friend` (
  `UserName` varchar(10) default NULL,
  `FriendID` varchar(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Structure for the `groupdetail` table : 
#

CREATE TABLE `groupdetail` (
  `GroupNum` int(10) unsigned NOT NULL auto_increment,
  `GroupName` varchar(20) NOT NULL,
  `GroupCreator` varchar(10) NOT NULL,
  `GroupIntroduce` varchar(255) NOT NULL,
  `GroupMember` varchar(255) default NULL,
  `CreateDate` date default NULL,
  PRIMARY KEY  (`GroupNum`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Structure for the `grouplist` table : 
#

CREATE TABLE `grouplist` (
  `UserName` varchar(10) default NULL,
  `GroupNum` int(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Structure for the `offlinemsg` table : 
#

CREATE TABLE `offlinemsg` (
  `UserFrom` varchar(10) NOT NULL,
  `UserTo` varchar(10) NOT NULL,
  `Msg` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Structure for the `user` table : 
#

CREATE TABLE `user` (
  `UserName` varchar(10) NOT NULL,
  `RealName` varchar(20) NOT NULL,
  `PassWord` varchar(20) NOT NULL,
  `TelNum` varchar(15) default NULL,
  `HomeSite` varchar(50) default NULL,
  `Email` varchar(30) default NULL,
  `Age` int(3) default NULL,
  `Sex` varchar(2) default NULL,
  `Introduce` varchar(255) default '这人很懒，什么也没留下',
  `Icon` varchar(20) default 'head/default.png',
  `CurrentIP` varchar(20) default '0',
  `LogTime` varchar(20) character set gb2312 collate gb2312_bin default NULL,
  `CurrentState` varchar(10) default NULL,
  `CurrentPort` varchar(10) default NULL,
  PRIMARY KEY  (`UserName`),
  UNIQUE KEY `UserName` (`UserName`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

#
# Data for the `friend` table  (LIMIT 0,500)
#

INSERT INTO `friend` (`UserName`, `FriendID`) VALUES 
  ('blueday','blueday2');

COMMIT;

#
# Data for the `user` table  (LIMIT 0,500)
#

INSERT INTO `user` (`UserName`, `RealName`, `PassWord`, `TelNum`, `HomeSite`, `Email`, `Age`, `Sex`, `Introduce`, `Icon`, `CurrentIP`, `LogTime`, `CurrentState`, `CurrentPort`) VALUES 
  ('blueday','曾少彬','ulitsse','13970084420',NULL,'[e-mail]',21,'男','这人很懒，什么也没留下','head\\default.png','192.168.16.101','2008-02-06 02:43','离线','5247'),
  ('blueday2','曾少彬2','ulitsse','12545757877',NULL,NULL,NULL,'男','这人很懒，什么也没留下','head\\default.png','192.168.16.101','2008-02-06 02:42','在线','5246');

COMMIT;