--創建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