CREATE TABLE [dbo].[asset_software_delivery_job]
(
[asset_software_delivery_job_id] [binary] (16) NOT NULL,
[dis_hw_uuid] [binary] (16) NOT NULL,
[software_delivery_server_id] [binary] (16) NOT NULL,
[software_delivery_job_id] [binary] (16) NOT 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].[asset_software_delivery_job] ADD CONSTRAINT [XPKasset_software_delivery_job] PRIMARY KEY CLUSTERED ([asset_software_delivery_job_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1asset_software_delivery_job] ON [dbo].[asset_software_delivery_job] ([dis_hw_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3asset_software_delivery_job] ON [dbo].[asset_software_delivery_job] ([software_delivery_job_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xif0asset_software_delivery_job] ON [dbo].[asset_software_delivery_job] ([software_delivery_server_id], [software_delivery_job_id], [dis_hw_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_software_delivery_job] ADD CONSTRAINT [$asset_r00001cad00000000] FOREIGN KEY ([software_delivery_job_id]) REFERENCES [dbo].[software_delivery_job] ([software_delivery_job_id])
GO
ALTER TABLE [dbo].[asset_software_delivery_job] ADD CONSTRAINT [$asset_r00001cb600000000] FOREIGN KEY ([software_delivery_server_id]) REFERENCES [dbo].[software_delivery_server] ([software_delivery_server_id])
GO
ALTER TABLE [dbo].[asset_software_delivery_job] ADD CONSTRAINT [$asset_r00001cbf00000000] FOREIGN KEY ([dis_hw_uuid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid])
GO