CREATE TABLE [dbo].[enterprise_package_subpackage]
(
[sp_id] [int] NOT NULL,
[ep_id] [int] NOT NULL,
[product_code] [int] NOT NULL,
[provider_name] [char] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[product_packageid] [int] NOT NULL,
[product_package_name] [char] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sp_priority] [int] NOT NULL,
[sp_lastaction] [int] NOT NULL,
[sp_executionstate] [int] NOT NULL,
[sp_executionstatus] [int] NOT NULL,
[comments] [char] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sp_executionstart] [datetime] NOT NULL,
[sp_executionfinish] [datetime] NOT NULL,
[datetime_updated] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[enterprise_package_subpackage] ADD CONSTRAINT [XPKenterprise_package_subpackage] PRIMARY KEY CLUSTERED ([sp_id], [ep_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[enterprise_package_subpackage] TO [cmew_admin]
GRANT INSERT ON  [dbo].[enterprise_package_subpackage] TO [cmew_admin]
GRANT DELETE ON  [dbo].[enterprise_package_subpackage] TO [cmew_admin]
GRANT UPDATE ON  [dbo].[enterprise_package_subpackage] TO [cmew_admin]
GRANT SELECT ON  [dbo].[enterprise_package_subpackage] TO [cmew_rdr]
GO