[dbo].[MapiAlertServiceOperation]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	3
Created	11:43:57 AM Friday, March 26, 2010
Last Modified	11:43:57 AM Friday, March 26, 2010

Name	Data Type	Max Length (Bytes)	Default
UserProfile	varchar(255)	255	('')
MAPITO	varchar(255)	255	('')
Subject	varchar(255)	255	('')
Receipt	tinyint	1
MAPICC	varchar(255)	255	('')
RefID	varchar(255)	255	('')
Attachment	varchar(2048)	2048	('')
Message	varchar(255)	255	('')

	Name	Columns	Unique
	PK__MapiAlertService__1332DBDC	RefID

SQL Script

CREATE TABLE [dbo].[MapiAlertServiceOperation]
(
[UserProfile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__UserP__0C85DE4D] DEFAULT (''),
[MAPITO] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__MAPIT__0D7A0286] DEFAULT (''),
[Subject] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__Subje__0E6E26BF] DEFAULT (''),
[Receipt] [tinyint] NULL,
[MAPICC] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__MAPIC__0F624AF8] DEFAULT (''),
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__MapiAlert__RefID__10566F31] DEFAULT (''),
[Attachment] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__Attac__114A936A] DEFAULT (''),
[Message] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__MapiAlert__Messa__123EB7A3] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MapiAlertServiceOperation] ADD CONSTRAINT [PK__MapiAlertService__1332DBDC] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO