CREATE TABLE [dbo].[software_delivery_job_file]
(
[software_delivery_job_file_id] [binary] (16) NOT NULL,
[software_delivery_job_id] [binary] (16) NOT NULL,
[download_file_id] [binary] (16) NOT NULL,
[sequence_number] [int] NOT NULL,
[upload_to_evm_date] [int] NULL,
[upload_to_evm_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extraction_user_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extraction_password] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[software_delivery_job_file] ADD CONSTRAINT [XPKsoftware_delivery_job_file] PRIMARY KEY CLUSTERED ([software_delivery_job_file_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2software_delivery_job_file] ON [dbo].[software_delivery_job_file] ([download_file_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xif1software_delivery_job_file] ON [dbo].[software_delivery_job_file] ([software_delivery_job_id], [download_file_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[software_delivery_job_file] ADD CONSTRAINT [$softw_r00001cff00000000] FOREIGN KEY ([software_delivery_job_id]) REFERENCES [dbo].[software_delivery_job] ([software_delivery_job_id])
GO