31 lines
860 B
Transact-SQL
31 lines
860 B
Transact-SQL
USE [EnVisage]
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[supt_ImportErrors] Script Date: 08/28/2015 3:45:01 PM ******/
|
|
IF (EXISTS (SELECT *
|
|
FROM INFORMATION_SCHEMA.TABLES where
|
|
TABLE_NAME = 'supt_ImportErrors'))
|
|
DROP TABLE [dbo].[supt_ImportErrors]
|
|
|
|
|
|
/****** Object: Table [dbo].[supt_ImportErrors] Script Date: 08/28/2015 3:45:01 PM ******/
|
|
SET ANSI_NULLS ON
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
|
CREATE TABLE [dbo].[supt_ImportErrors](
|
|
[Id] [uniqueidentifier] NOT NULL DEFAULT (newid()),
|
|
[ProcessID] [nvarchar](100) NOT NULL,
|
|
[RecordNbr] [int] NOT NULL,
|
|
[Message] [nvarchar](100) NOT NULL,
|
|
[DateTimeProcessed] [datetime] NOT NULL,
|
|
CONSTRAINT [PK_supt_ImportErrors] PRIMARY KEY CLUSTERED
|
|
(
|
|
[Id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
GO
|
|
|
|
|