[dbo].[harvest_subpackage_actions]
CREATE TABLE [dbo].[harvest_subpackage_actions]
(
[sp_id] [int] NOT NULL,
[ep_id] [int] NOT NULL,
[harvest_state] [int] NOT NULL,
[promote_processid] [int] NOT NULL,
[promote_processname] [char] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[demote_processid] [int] NOT NULL,
[demote_processname] [char] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[datetime_updated] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harvest_subpackage_actions] ADD CONSTRAINT [XPKharvest_subpackage_actions] PRIMARY KEY CLUSTERED ([sp_id], [ep_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [har_subpack_act_idx_01] ON [dbo].[harvest_subpackage_actions] ([ep_id], [sp_id]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[harvest_subpackage_actions] TO [cmew_admin]
GRANT INSERT ON [dbo].[harvest_subpackage_actions] TO [cmew_admin]
GRANT DELETE ON [dbo].[harvest_subpackage_actions] TO [cmew_admin]
GRANT UPDATE ON [dbo].[harvest_subpackage_actions] TO [cmew_admin]
GRANT SELECT ON [dbo].[harvest_subpackage_actions] TO [cmew_rdr]
GO
