USE [EnVisage]
GO

/****** Object:  Table [dbo].[supt_ImportMessages]    Script Date: 01/20/2016 3:41:28 PM ******/

IF EXISTS (SELECT * FROM sys.tables where name='supt_ImportMessages')
begin
DROP TABLE [dbo].[supt_ImportMessages]
end
/****** Object:  Table [dbo].[supt_ImportMessages]    Script Date: 01/20/2016 3:41:28 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[supt_ImportMessages](
	[Id] [uniqueidentifier] NOT NULL CONSTRAINT [DF__supt_ImportE__Id__7E8CC4B1]  DEFAULT (newid()),
	[GroupID] [uniqueidentifier] NOT NULL,
	[MessageType] [int] NOT NULL,
	[ProcessID] [nvarchar](100) NOT NULL,
	[RecordNbr] [int] NOT NULL,
	[Message] [nvarchar](1500) NOT NULL,
	[DateTimeProcessed] [datetime] NOT NULL,
 CONSTRAINT [PK_supt_ImportMessages] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO