聊天室|源代码/*表结构设计*/
/* 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普通管理员*/