asp.net在线即时聊天留言交友

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Role]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Role]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [Remark] [varchar](100) NULL, CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_AddGroupUser]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_AddGroupUser] ( @GroupID int, @UserID int ) AS DECLARE @Count int SET @Count = ISNULL((SELECT COUNT(*) FROM GroupUser WHERE GroupID=@GroupID AND UserID=@UserID),0) IF @Count <= 0 BEGIN INSERT INTO GroupUser (GroupID,UserID) VALUES (@GroupID,@UserID) SET @Count = @@ROWCOUNT END RETURN @Count ' END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[User]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[User]( [ID] [int] IDENTITY(1,1) NOT NULL, [Username] [varchar](50) NULL, [Aliasname] [varchar](50) NULL, [Password] [varchar](255) NULL, [UserIdentity] [varchar](10) NULL, [CreateDate] [datetime] NULL, [Email] [varchar](255) NULL, [PictureUrl] [varchar](255) NULL, [Signing] [varchar](1000) NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CaboodleUser]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[CaboodleUser]( [CaboodleID] [int] NOT NULL, [UserID] [int] NOT NULL, [RoleID] [int] NULL, CONSTRAINT [PK_CaboodleUser] PRIMARY KEY CLUSTERED ( [CaboodleID] ASC, [UserID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GroupUser]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[GroupUser]( [ID] [int] IDENTITY(1,1) NOT NULL, [GroupID] [int] NOT NULL, [UserID] [int] NOT NULL, CONSTRAINT [PK_GroupUser] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MessageForCaboodle]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[MessageForCaboodle]( [ID] [int] IDENTITY(1,1) NOT NULL, [Body] [varchar](1000) NULL, [Sender] [int] NULL, [CaboodleID] [int] NULL, [CreateDate] [datetime] NULL, CONSTRAINT [PK_MessageForCaboodle] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Group]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Group]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](20) NULL, [UserID] [int] NULL, CONSTRAINT [PK_Group] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Leaveword]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[Leaveword]( [ID] [int] IDENTITY(1,1) NOT NULL, [Body] [varchar](100) NULL, [Sender] [int] NULL, [Receiver] [int] NULL, [CreateDate] [datetime] NULL, [Status] [tinyint] NULL, CONSTRAINT [PK_Leaveword] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED�