tables.sql

很不错的php聊天室源码,提供给大家学习

CREATE TABLE `config` (`value` varchar(255) default NULL,`name` varchar(50) NOT NULL default '')
INSERT INTO `config` VALUES ('天龙聊天室', 'chatroom_name')
INSERT INTO `config` VALUES ('{%%}来了。', 'chatroom_login')
INSERT INTO `config` VALUES ('{%%}走了。', 'chatroom_logout')
INSERT INTO `config` VALUES ('{%%}关闭浏览器跑掉了。', 'chatroom_leave')
INSERT INTO `config` VALUES ('160', 'say_maxlength')
INSERT INTO `config` VALUES ('{%%}您好，欢迎您的光临', 'chatroom_welcome')
INSERT INTO `config` VALUES ('欢迎使用 <a href=http://aotianlong.yeah.net>天龙聊天室</a> 1.0.0版。', 'chatroom_affiche')
INSERT INTO `config` VALUES ('2', 'say_interval')
INSERT INTO `config` VALUES ('我日,草你,操你,法轮,日你,我靠,我草,奶子,阴道,阴茎,阳具,淫水,洪志,干你,妈的,强奸,鸡奸,插你,搞你,老子,fuck,shit', 'say_filter')
INSERT INTO `config` VALUES ('5000', 'refresh_interval')
INSERT INTO `config` VALUES ('aotianlong', 'chatroom_admin')
INSERT INTO `config` VALUES ('500', 'chatroom_maxonline')
INSERT INTO `config` VALUES ('[e-mail]', 'chatroom_adminemail')
INSERT INTO `config` VALUES ('{##}恭恭敬敬的把{%%}请出聊天室……', 'message_kick')
INSERT INTO `config` VALUES ('{##}把{%%}炸上天堂……', 'message_bomb')
INSERT INTO `config` VALUES ('{%%}偷偷的关闭浏览器走了……', 'message_leave')
INSERT INTO `config` VALUES ('{##}封锁{%%}的IP……', 'message_lock')
INSERT INTO `config` VALUES ('天上乌云密布，刹那间一条白龙化作了{%%}……', 'message_login')
INSERT INTO `config` VALUES ('{%%}幻化做一条青龙，飞走了……', 'message_logout')
INSERT INTO `config` VALUES ('{##}警告{%%}一次……', 'message_warn')
INSERT INTO `config` VALUES ('{%%}由于潜水时间过长，系统自清除。', 'message_clear')
INSERT INTO `config` VALUES ('{%%}去了{##}了。', 'message_changeroom')
INSERT INTO `config` VALUES ('#EEEEFF', 'style_inputsayframe_background_color')
INSERT INTO `config` VALUES ('images/bg.gif', 'style_inputsayframe_background_image')
INSERT INTO `config` VALUES ('#EEEEFF', 'style_onlinelistframe_background_color')
INSERT INTO `config` VALUES ('images/bg.gif', 'style_onlinelistframe_background_image')
INSERT INTO `config` VALUES ('#DDDDFF', 'style_titleframe_background_color')
INSERT INTO `config` VALUES ('', 'style_titleframe_background_image')
INSERT INTO `config` VALUES ('#EEEEFF', 'style_showmessageframe_background_color')
INSERT INTO `config` VALUES ('', 'style_showmessageframe_background_image')
INSERT INTO `config` VALUES ('4297f44b13955235245b2497399d7a93', 'chatroom_adminpassword')
INSERT INTO `config` VALUES ('0', 'notice_show_time')
INSERT INTO `config` VALUES ('1', 'chatroom_default_split')
INSERT INTO `config` VALUES ('0', 'say_enable_filter')
INSERT INTO `config` VALUES ('0', 'savecents_interval')
INSERT INTO `config` VALUES ('2', 'enable_picture')
INSERT INTO `config` VALUES ('3', 'enable_title')
INSERT INTO `config` VALUES ('9', 'enable_warn')
INSERT INTO `config` VALUES ('6', 'enable_kick')
INSERT INTO `config` VALUES ('7', 'enable_lock')
INSERT INTO `config` VALUES ('8', 'enable_unlock')
INSERT INTO `config` VALUES ('8', 'enable_bomb')
INSERT INTO `config` VALUES ('9', 'enable_grade')
INSERT INTO `config` VALUES ('12', 'enable_unauto_grade')
INSERT INTO `config` VALUES ('12', 'enable_nolimit_grade')
INSERT INTO `config` VALUES ('11', 'enable_auto_grade')
INSERT INTO `config` VALUES ('500', 'grade2_cents')
INSERT INTO `config` VALUES ('1000', 'grade3_cents')
INSERT INTO `config` VALUES ('2000', 'grade4_cents')
INSERT INTO `config` VALUES ('4000', 'grade5_cents')
INSERT INTO `config` VALUES ('-1', 'grade6_cents')
INSERT INTO `config` VALUES ('-1', 'grade7_cents')
INSERT INTO `config` VALUES ('-1', 'grade8_cents')
INSERT INTO `config` VALUES ('-1', 'grade9_cents')
INSERT INTO `config` VALUES ('-1', 'grade10_cents')
INSERT INTO `config` VALUES ('1', 'enable_grade_auto_increment')
INSERT INTO `config` VALUES ('5', 'kick_cantlogin_time')
INSERT INTO `config` VALUES ('20', 'lock_cantlogin_time')
INSERT INTO `config` VALUES ('0', 'img_verify')
INSERT INTO `config` VALUES ('1082880882.2993', 'check_online')
INSERT INTO `config` VALUES ('0', 'max_nosay_time')
INSERT INTO `config` VALUES ('5', 'enable_view_loginip')
INSERT INTO `config` VALUES ('3', 'enable_view_sysinfo')
INSERT INTO `config` VALUES ('4', 'enable_view_grade')
INSERT INTO `config` VALUES ('2', 'enable_view_nameattrib')
INSERT INTO `config` VALUES ('1', 'enable_view_userinfo')
INSERT INTO `config` VALUES ('这里可以显示您在首页的信息', 'loginpage_affiche')
INSERT INTO `config` VALUES ('20', 'log_pagesize')
INSERT INTO `config` VALUES ('72', 'log_clear_interval')
INSERT INTO `config` VALUES ('10', 'title_interval')
INSERT INTO `config` VALUES ('600', 'optimize_time')
INSERT INTO `config` VALUES ('1082853663', 'last_optimize_time')
INSERT INTO `config` VALUES ('2000', 'max_message_number')
INSERT INTO `config` VALUES ('系统调整中，请稍后再来，谢谢您的支持~', 'why_close')
INSERT INTO `config` VALUES ('1', 'chatroom_is_closed')
INSERT INTO `config` VALUES ('1', 'name_min_length')
INSERT INTO `config` VALUES ('12', 'name_max_length')
INSERT INTO `config` VALUES ('6', 'password_min_length')
INSERT INTO `config` VALUES ('0', 'chatroom_admin_pic_verify')
INSERT INTO `config` VALUES ('1082637112', 'log_last_clear_time')
INSERT INTO `config` VALUES ('1', 'enable_auto_clear_logs')
INSERT INTO `config` VALUES ('{%%}经过多次警告无效，系统将其清除出聊天室……', 'message_warning_out')
INSERT INTO `config` VALUES ('3', 'warning_out_number')
INSERT INTO `config` VALUES ('{%%}解除IP封锁{##}.....', 'message_unlock')
INSERT INTO `config` VALUES ('1', 'enable_viewlog_manage')
INSERT INTO `config` VALUES ('10', 'enable_viewlog_error')
INSERT INTO `config` VALUES ('3', 'enable_viewlog_grade')
INSERT INTO `config` VALUES ('0', 'visit_number')
INSERT INTO `config` VALUES ('9', 'enable_viewlog_name')
INSERT INTO `config` VALUES ('2', 'enable_viewlog_login')
INSERT INTO `config` VALUES ('1', 'enable_write_guestbook')
INSERT INTO `config` VALUES ('10', 'enable_delete_guestbook')
INSERT INTO `config` VALUES ('1', 'enable_deleteself_guestbook')
INSERT INTO `config` VALUES ('如果您有什么意见或者建议，请在这里留言。', 'guestbook_affiche')
INSERT INTO `config` VALUES ('-1', 'grade12_cents')
INSERT INTO `config` VALUES ('-1', 'grade11_cents')
INSERT INTO `config` VALUES ('2', 'write_guestbook_interval')
INSERT INTO `config` VALUES ('0', 'top_online_record')
INSERT INTO `config` VALUES ('0', 'top_online_record_time')
INSERT INTO `config` VALUES ('', 'top_online_record_user')
INSERT INTO `config` VALUES ('#AAAACC', 'page_bgcolor')
INSERT INTO `config` VALUES ('4', 'enable_call')
INSERT INTO `config` VALUES ('12', 'enable_forbid')
INSERT INTO `config` VALUES ('12', 'enable_unforbid')
INSERT INTO `config` VALUES ('30', 'guestbook_pagesize')
INSERT INTO `config` VALUES ('30', 'taxis_pagesize')
CREATE TABLE `guestbook` (`id` int(11) NOT NULL auto_increment,  `username` varchar(20) NOT NULL default '',`subject` varchar(50) NOT NULL default '',  `content` varchar(255) NOT NULL default '',  `to_user` varchar(20) NOT NULL default '',  `time` datetime NOT NULL default '0000-00-00 00:00:00',  `ip` varchar(15) NOT NULL default '',  `private` tinyint(1) NOT NULL default '0',  `readed` tinyint(1) NOT NULL default '0',  PRIMARY KEY  (`id`))
CREATE TABLE `lockedip` (  `id` int(11) NOT NULL auto_increment,  `ip` varchar(15) NOT NULL default '',  `locktime` bigint(20) NOT NULL default '0',  `always` tinyint(1) NOT NULL default '0',  `username` varchar(20) default NULL,  `time` datetime NOT NULL default '0000-00-00 00:00:00',  PRIMARY KEY  (`id`))
CREATE TABLE `logs` (  `id` int(11) NOT NULL auto_increment,  `type` tinyint(4) default '0',  `action` tinyint(4) default '0',  `user` varchar(20) default NULL,  `manager` varchar(20) default NULL,  `time` datetime NOT NULL default '0000-00-00 00:00:00',  `why` varchar(255) default NULL,  `tags` varchar(255) default NULL,  PRIMARY KEY  (`id`),  KEY `id` (`id`))
CREATE TABLE `members` (  `id` int(11) NOT NULL auto_increment,  `username` varchar(20) NOT NULL default '',  `rank` int(2) NOT NULL default '1',  `regtime` datetime NOT NULL default '0000-00-00 00:00:00',  `lastlogintime` datetime NOT NULL default '0000-00-00 00:00:00',  `regip` varchar(25) NOT NULL default '',  `password` varchar(50) NOT NULL default '',  `loginnumbers` int(11) NOT NULL default '1',  `cents` int(11) NOT NULL default '0',  `lastkicktime` bigint(20) NOT NULL default '0',  `upgrade` tinyint(1) default '1',  `protected` tinyint(1) default '0',  `forbid` tinyint(1) NOT NULL default '0',  `oicq` varchar(10) default NULL,  `email` varchar(255) default NULL,  `homepage` varchar(255) default NULL,  `age` char(2) default NULL,  `realname` varchar(20) default NULL,  PRIMARY KEY  (`id`))
CREATE TABLE `messages` (  `to_user` varchar(20) NOT NULL default '',  `from_user` varchar(20) NOT NULL default '',  `time` time NOT NULL default '00:00:00',  `title` tinyint(2) default '0',  `namecolor` tinyint(2) NOT NULL default '0',  `private` tinyint(1) NOT NULL default '0',  `content` varchar(255) default NULL,  `id` bigint(20) NOT NULL auto_increment,  `saycolor` tinyint(2) NOT NULL default '0',  `type` tinyint(1) NOT NULL default '0',  `event` tinyint(2) NOT NULL default '0',  `face` tinyint(2) NOT NULL default '0',  `roomid` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`))
CREATE TABLE `onlinelist` (  `username` varchar(20) NOT NULL default '',  `activetime` int(11) NOT NULL default '0',  `id` bigint(20) NOT NULL auto_increment,  `lastsavecentstime` bigint(20) NOT NULL default '0',  `logintime` time NOT NULL default '00:00:00',  `loginip` varchar(25) NOT NULL default '',  `roomid` int(11) NOT NULL default '0',  `useragent` varchar(255) NOT NULL default '',  `gender` tinyint(1) NOT NULL default '0',  `sessionid` varchar(35) NOT NULL default '',  PRIMARY KEY  (`id`))
CREATE TABLE `rooms` (  `id` int(11) NOT NULL auto_increment,  `room_name` varchar(50) NOT NULL default '',  `maxonline` int(11) NOT NULL default '50',  `grade` int(11) NOT NULL default '1',  `title_from` varchar(20) NOT NULL default '天龙工作室',  `title_time` time NOT NULL default '00:00:00',  `title_content` varchar(255) NOT NULL default '欢迎光临，希望您聊的愉快。',  `masters` varchar(255) default NULL,  `inuse` tinyint(1) NOT NULL default '1',  PRIMARY KEY  (`id`))
INSERT INTO `rooms` VALUES (1, '天龙聊天', 300, 1, '傲天龙', '16:01:23', '欢迎您使用 天龙聊天室 1.0.2 版。', '', 1)