[Back]
/************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for {databaseOwner} and {objectQualifier} *****/ /***** *****/ /************************************************************/ if not exists (select * from dbo.sysobjects where id = object_id(N'DNNSilverlightChat_Message') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE [dbo].[DNNSilverlightChat_Message]( [MessageID] [int] IDENTITY(1,1) NOT NULL, [ModuleID] [int] NULL, [UserID] [int] NOT NULL, [ToUserID] [int] NULL, [Text] [varchar](100) NOT NULL, [TimeStamp] [datetime] NOT NULL CONSTRAINT [DF_Message_TimeStamp] DEFAULT (getdate()), [Color] [varchar](50) NULL, CONSTRAINT [PK_DNNSilverlightChat_Message] PRIMARY KEY CLUSTERED ( [MessageID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_DNNSilverlightChat_ModuleID] ON [dbo].[DNNSilverlightChat_Message] ( [ModuleID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_DNNSilverlightChat_TimeStamp] ON [dbo].[DNNSilverlightChat_Message] ( [TimeStamp] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] END /************************************************************/ /***** SqlDataProvider *****/ /************************************************************/