happychat.sql

联系方式 [e-mail]

--创建happychat数据库
create database happychat
go
--打开数据库
use happychat
--创建用户信息表
create table users
(
u_name varchar(16) primary key,
u_pass char(32) not null,
u_sex char(2) not null,
u_age int not null,
u_email varchar(30) not null	
)
--创建聊天信息表
create table history
(
h_no int identity(1,1),
h_user varchar(16) not null,
h_time datetime not null,
u_content varchar(60)
)

--创建存储过程
create procedure update_proc
@u_name varchar(16),@u_pass varchar(32),@u_sex char(2),@u_age int,@u_email varchar(30),
@t int output 
as
if (select count(*) from users where u_name=@u_name)=0
begin 
insert into users(u_name,u_pass,u_sex,u_age,u_email) 
values(@u_name,@u_pass,@u_sex,@u_age,@u_email)
set @t=1
end
else
set @t=0
go

--创建根据输入用户名删除指定纪录的存储过程
create proc delrecord
@name char(16)
as
delete from users
where u_name=@name