Tables [dbo].[WaitDownloads]
(local) > SupportBridge > Tables > dbo.WaitDownloads
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key pk_waitdownloads: DownloadIDDownloadIDint4
No
1 - 1
DivisionIDint4
No
SourceURLnvarchar(500)1000
Yes
Executablenvarchar(500)1000
Yes
CheckFilenvarchar(500)1000
Yes
CmdLnnvarchar(500)1000
Yes
Versionnvarchar(30)60
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_waitdownloads: DownloadIDpk_waitdownloadsDownloadID
Yes
SQL Script
CREATE TABLE [dbo].[WaitDownloads]
(
[DownloadID] [int] NOT NULL IDENTITY(1, 1),
[DivisionID] [int] NOT NULL,
[SourceURL] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Executable] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CheckFile] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CmdLn] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Version] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WaitDownloads] ADD CONSTRAINT [pk_waitdownloads] PRIMARY KEY CLUSTERED ([DownloadID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved