聊天室|源代码
/*表结构设计*/
/* Microsoft SQL Server - Scripting */
/* Server: SQL2 */
/* Database: chat */
/* Creation Date 00-4-28 12:55:20 */
/* dbo:chat*/
/* dbopassword:chat001*/
/**/
/*用户动作表*/
if exists (select * from sysobjects
where id = object_id('dbo.user_acction_table') and
sysstat & 0xf = 3)
drop table dbo.user_acction_table
GO
/**/
/*用户表情表*/
if exists (select * from sysobjects
where id = object_id('dbo.user_bq_table') and
sysstat & 0xf = 3)
drop table dbo.user_bq_table
GO
/**/
/*用户朋友表*/
if exists (select * from sysobjects
where id = object_id('dbo.user_friend_table') and
sysstat & 0xf = 3)
drop table dbo.user_friend_table
GO
/**/
/*用户进入/退出表*/
if exists (select * from sysobjects
where id = object_id('dbo.user_hello_table') and
sysstat & 0xf = 3)
drop table dbo.user_hello_table
GO
/**/
/*用户信息表*/
if exists (select * from sysobjects
where id = object_id('dbo.user_info_table') and
sysstat & 0xf = 3)
drop table dbo.user_info_table
GO
/**/
CREATE TABLE dbo.user_acction_table (
user_name char (50) NOT NULL , /*用户名称*/
acction_name char (50) NOT NULL , /*动作代码*/
user_acction char (200) NOT NULL /*动作内容*/
)
GO
/**/
CREATE TABLE dbo.user_bq_table (
user_name char (50) NOT NULL , /*用户名称*/
user_bq char (50) NOT NULL /*用户表情*/
)
GO
/**/
CREATE TABLE dbo.user_friend_table (
user_name char (50) NOT NULL , /*用户名称*/
user_friend char (50) NOT NULL /*用户朋友名称*/
)
GO
/**/
CREATE TABLE dbo.user_hello_table (
user_name char (50) NOT NULL , /*用户名称*/
come_in char (200) NOT NULL , /*用户进入语*/
go_out char (200) NULL /*用户退出语*/
)
GO
/**/
CREATE TABLE dbo.user_info_table (
user_name char (50) NOT NULL , /*用户名称*/
user_password char (50) NOT NULL , /*用户口令*/
user_sex char (50) NOT NULL , /*用户性别*/
user_email char (50) NULL , /*用户e_mail*/
user_quesstion char (50) NULL , /*提示问题*/
user_answer char (50) NULL , /*答案*/
user_ip char (20) NOT NULL , /*用户IP*/
user_flag int NOT NULL /*用户权限0超级用户,*/
/*1普通管理员*/