little-chat-room

基于php+mysql+ajax+jquery实现的简单聊天室（a little chatroom based on php+mysql+ajax+jq）

数据库结构：

DROP TABLE IF EXISTS `chat`; CREATE TABLE IF NOT EXISTS `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `username` varchar(20) DEFAULT NULL, `chatdate` time DEFAULT NULL, `msg` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ly_content`; CREATE TABLE IF NOT EXISTS `ly_content` ( `id` int(10) NOT NULL AUTO_INCREMENT, `usernameid` int(10) NOT NULL, `headimg` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `content` text, `time` bigint(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ly_user`; CREATE TABLE IF NOT EXISTS `ly_user` ( `id` int(10) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL, `nickname` varchar(255) DEFAULT NULL, `headimg` varchar(255) DEFAULT NULL, `password` varchar(255) NOT NULL, `tel` bigint(11) DEFAULT NULL, `emai` varchar(255) DEFAULT NULL, `ip` varchar(15) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `logined`; CREATE TABLE IF NOT EXISTS `logined` ( `usr` varchar(15) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;