CREATE TABLE [dbo].[upm_workflow]
(
[workflow_uuid] [binary] (16) NOT NULL,
[result] [int] NULL,
[when_created] [int] NULL,
[when_completed] [int] NULL,
[success_next_state] [smallint] NULL,
[failure_next_state] [smallint] NULL,
[object_type] [smallint] NOT NULL,
[object_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_workflow] ADD CONSTRAINT [XPKupm_workflow] PRIMARY KEY CLUSTERED ([workflow_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[upm_workflow] TO [upmadmin_group]
GRANT INSERT ON [dbo].[upm_workflow] TO [upmadmin_group]
GRANT DELETE ON [dbo].[upm_workflow] TO [upmadmin_group]
GRANT UPDATE ON [dbo].[upm_workflow] TO [upmadmin_group]
GRANT SELECT ON [dbo].[upm_workflow] TO [upmuser_group]
GRANT INSERT ON [dbo].[upm_workflow] TO [upmuser_group]
GRANT DELETE ON [dbo].[upm_workflow] TO [upmuser_group]
GRANT UPDATE ON [dbo].[upm_workflow] TO [upmuser_group]
GO
[dbo].[upm_workflow]
