Chat Room | Source code/* Table Structure Design * *
/* Microsoft SQL server-scripting * *
* SERVER:SQL2 * *
* Database:chat * *
/* Creation Date 00-4-28 12:55:20 * *
/* dbo:chat*/
/* dbopassword:chat001*/
/**/
/* User Action form * *
if exists (SELECT * from sysobjects
WHERE id = object_id (' dbo.user_acction_table ') and
Sysstat & 0xf = 3)
drop table Dbo.user_acction_table
Go
/**/
/* User Expression form * *
if exists (SELECT * from sysobjects
WHERE id = object_id (' dbo.user_bq_table ') and
Sysstat & 0xf = 3)
drop table Dbo.user_bq_table
Go
/**/
/* User Friends Table * *
if exists (SELECT * from sysobjects
WHERE id = object_id (' dbo.user_friend_table ') and
Sysstat & 0xf = 3)
drop table Dbo.user_friend_table
Go
/**/
/* User entry/exit form * *
if exists (SELECT * from sysobjects
WHERE id = object_id (' dbo.user_hello_table ') and
Sysstat & 0xf = 3)
drop table Dbo.user_hello_table
Go
/**/
/* User Information Form * *
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 not NULL,/* User name * *
Acction_name Char not NULL,/* Action code * *
User_acction Char not NULL/* Action Content * *
)
Go
/**/
CREATE TABLE dbo.user_bq_table (
User_name Char not NULL,/* User name * *
USER_BQ Char not NULL/* User expression * *
)
Go
/**/
CREATE TABLE dbo.user_friend_table (
User_name Char not NULL,/* User name * *
User_friend Char not NULL/* User friend Name * *
)
Go
/**/
CREATE TABLE dbo.user_hello_table (
User_name Char not NULL,/* User name * *
come_in char (+) not NULL,/* User Entry language * *
Go_out char (%) NULL/* User Exit Language * *
)
Go
/**/
CREATE TABLE dbo.user_info_table (
User_name Char not NULL,/* User name * *
User_password char (+) not NULL,/* User Password * *
User_sex Char not NULL,/* User sex * *
User_email char (m) NULL,/* User e_mail*/
User_quesstion char (%) NULL,/* Prompt question * *
User_answer char NULL,/* Answer * *
User_ip Char not NULL,/* User ip*/
User_flag int not NULL/* User Rights 0 Superuser, */
/*1 General Manager * *