database.txt

一个C语言的聊天室源代码

#usage mysql -u root -prootpasswd < database.txt

use mysql;
insert user (Host,User,Password) values('localhost','socketchat',PASSWORD('socketchat'));
create database socketchat;
# grant select,insert,update,create,delete on socketchat.* to socketchat@localhost;
flush privileges;
grant all on socketchat.* to socketchat@localhost;
flush privileges;

use socketchat;

CREATE TABLE rooms (
	id int AUTO_INCREMENT not null,	
	name char(40) default '' not null,
	welcome char(200) default '' not null,
	topic char(200) default '' not null,
	mode int default 0 not null,
	password char(20) default '' not null,
	PRIMARY KEY (id)
	);
CREATE TABLE login (
	id char(20) default '' not null,
	lastip char(24) default '' not null,
	lasttime datetime default '' not null,
	lastwrongpw char(20) default '' not null,
	PRIMARY KEY (id)
	);
CREATE TABLE users (
	id char(20) default '' not null,
	nickname char(20) default '' not null,
	password char(20) default '' not null,
	sex char(10) default '0' not null,
	sign char(100) default '' not null,
	photo char(50) default '' not null,

	realname char(20) default '' not null,
	born date default '' not null,
	email char(100) default '' not null,
	readme text default '' not null,
	regip char(24) default '' not null,
	regtime datetime default '' not null,

	PRIMARY KEY (id)
	);
CREATE TABLE manage (
	userid char(20) default '' not null,
	roomid int default 0 not null,
	admin_priv enum('Y','N') default 'N' not null,
	chatmaster_priv enum('Y','N') default 'N' not null,
	chatroomowner_priv enum('Y','N') default 'N' not null,
	seeip_priv enum('Y','N') default 'N' not null,
	seemsg_priv enum('Y','N') default 'N' not null,
	
	PRIMARY KEY (userid)
	);

#使用describe tablename;察看一下数据结构有没有错误
#要经常使用optimize tablename指令减少碎片

#增加房间数据
insert into rooms (name) values ("缘来是你");
insert into rooms (name) values ("ｅ网情深");
insert into rooms (name) values ("月满西楼");
insert into rooms (name) values ("白兰心语");
insert into rooms (name) values ("English Corner");
insert into rooms (name) values ("男孩女孩");
insert into rooms (name) values ("股市沙龙");

#设置超级用户账号
insert into users (id,nickname,password,sex,sign,email) values ("admin","admin","admin","保密","聊天室超级管理员","[e-mail]");
insert into manage (userid,admin_priv,chatmaster_priv,chatroomowner_priv,seeip_priv,seemsg_priv) values ("admin","Y","Y","Y","Y","Y");

#增加普通用户账号
insert into users (id,nickname,password,sex,sign,email) values ("test1","test1","test1","保密","测试账号1","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test2","test2","test2","保密","测试账号2","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test3","test3","test3","保密","测试账号3","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test4","test4","test4","保密","测试账号4","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test5","test5","test5","保密","测试账号5","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test6","test6","test6","保密","测试账号6","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test7","test7","test7","保密","测试账号7","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test8","test8","test8","保密","测试账号8","[e-mail]");
insert into users (id,nickname,password,sex,sign,email) values ("test9","test9","test9","保密","测试账号9","[e-mail]");