cs_schema_patch_20050114.sql

解压即可使用

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

CREATE TABLE [dbo].[cs_EmailQueue] (
	[EmailID] [uniqueidentifier] NOT NULL ,
	[emailPriority] [int] NOT NULL ,
	[emailBodyFormat] [int] NOT NULL ,
	[emailTo] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[emailCc] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[emailBcc] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmailFrom] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmailSubject] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[EmailBody] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[NextTryTime] [datetime] NOT NULL ,
	[NumberOfTries] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_EmailQueue] ADD 
	CONSTRAINT [DF_cs_EmailQueue_EmailID] DEFAULT (newid()) FOR [EmailID],
	CONSTRAINT [DF_cs_EmailQueue_createdTimestamp] DEFAULT ('1/1/1979 12:00:00') FOR [NextTryTime],
	CONSTRAINT [DF_cs_EmailQueue_NumberOfTries] DEFAULT (0) FOR [NumberOfTries]
GO

 CREATE  INDEX [IX_cs_EmailQueue] ON [dbo].[cs_EmailQueue]([EmailID]) ON [PRIMARY]
GO