CREATE TABLE [dbo].[upm_deployment]
(
[deployment_uuid] [binary] (16) NOT NULL,
[package_uuid] [binary] (16) NULL,
[status] [tinyint] NULL,
[when_created] [int] NULL,
[when_scheduled] [int] NULL,
[when_completed] [int] NULL,
[install_pkg_uuid] [binary] (16) NOT NULL,
[properties] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [nvarchar] (450) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[distribution_uuid] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_deployment] ADD CONSTRAINT [XPKupm_deployment] PRIMARY KEY CLUSTERED ([deployment_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1upm_deployment] ON [dbo].[upm_deployment] ([install_pkg_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie2upm_deployment] ON [dbo].[upm_deployment] ([name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xie1upm_deployment] ON [dbo].[upm_deployment] ([status]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_deployment] ADD CONSTRAINT [$upm_d_r0000062500000000] FOREIGN KEY ([install_pkg_uuid]) REFERENCES [dbo].[ca_install_package] ([install_pkg_uuid])
GO
GRANT SELECT ON  [dbo].[upm_deployment] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[upm_deployment] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[upm_deployment] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[upm_deployment] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[upm_deployment] TO [upmuser_group]
GRANT INSERT ON  [dbo].[upm_deployment] TO [upmuser_group]
GRANT DELETE ON  [dbo].[upm_deployment] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[upm_deployment] TO [upmuser_group]
GO