user_msg_record_mssql.txt

关于在线聊天的程序,类似于QQ聊天,希望大家喜欢

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Msg_Record]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Msg_Record]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[User_Record]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[User_Record]
GO

CREATE TABLE [dbo].[Msg_Record] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[SendUser] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ReciveUser] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Msg] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SendDate] [datetime] NULL ,
	[Status] [bit] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[User_Record] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IfOnline] [bit] NOT NULL ,
	[IfSendNewMsg] [bit] NOT NULL ,
	[RegDate] [datetime] NULL ,
	[LastUpDate] [datetime] NULL ,
	[DayCounter] [int] NULL ,
	[MonthCounter] [int] NULL ,
	[AllCounter] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Msg_Record] WITH NOCHECK ADD 
	CONSTRAINT [DF_Msg_Record_SendDate] DEFAULT (getdate()) FOR [SendDate],
	CONSTRAINT [DF_Msg_Record_Status] DEFAULT (0) FOR [Status],
	CONSTRAINT [PK_Msg_Record] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[User_Record] WITH NOCHECK ADD 
	CONSTRAINT [DF_User_Record_IfOnline] DEFAULT (0) FOR [IfOnline],
	CONSTRAINT [DF_User_Record_IfSendNewMsg] DEFAULT (0) FOR [IfSendNewMsg],
	CONSTRAINT [DF_User_Record_RegDate] DEFAULT (getdate()) FOR [RegDate],
	CONSTRAINT [DF_User_Record_LastUpDate] DEFAULT (getdate()) FOR [LastUpDate],
	CONSTRAINT [DF_User_Record_DayCounter] DEFAULT (0) FOR [DayCounter],
	CONSTRAINT [DF_User_Record_MonthCounter] DEFAULT (0) FOR [MonthCounter],
	CONSTRAINT [DF_User_Record_AllCounter] DEFAULT (0) FOR [AllCounter],
	CONSTRAINT [PK_User_Record] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO