18 lines
490 B
Transact-SQL
18 lines
490 B
Transact-SQL
/*
|
|
Do not change the database path or name variables.
|
|
Any sqlcmd variables will be properly substituted during
|
|
build and deployment.
|
|
*/
|
|
CREATE TABLE [dbo].[Import](
|
|
[ImportId] int NOT NULL IDENTITY,
|
|
[StartDate] DATETIME2 NOT NULL,
|
|
[EndDate] DATETIME2 NULL,
|
|
[RecordCount] [int] NOT NULL DEFAULT 0,
|
|
[RecordsSaved] [int] NOT NULL DEFAULT 0,
|
|
[Success] [bit] NOT NULL,
|
|
[FileName] [varchar](50) NULL,
|
|
[ImportType] [varchar](10) NULL
|
|
CONSTRAINT [PK_Import] PRIMARY KEY (ImportId)
|
|
)
|
|
|