CREATE TABLE [dbo].[ca_application_registration]
(
[product_code] [int] NOT NULL,
[major_version] [int] NOT NULL,
[minor_version] [int] NOT NULL,
[product_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[product_specific_data] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[install_count] [int] NOT NULL CONSTRAINT [DF__ca_applic__insta__49AEE81E] DEFAULT ('0'),
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_application_registration] ADD CONSTRAINT [XPKca_application_registration] PRIMARY KEY CLUSTERED ([product_code], [major_version], [minor_version]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_application_registration] TO [aiadmin]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [aiadmin]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [ams_group]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [ams_group]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [ams_group]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [ams_group]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [amsgroup]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [amsgroup]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [amsgroup]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [amsgroup]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [ca_itrm_group_ams]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [ca_itrm_group_ams]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [ca_itrm_group_ams]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [service_desk_ro_group]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [upmuser_group]
GRANT SELECT ON  [dbo].[ca_application_registration] TO [usmgroup]
GRANT INSERT ON  [dbo].[ca_application_registration] TO [usmgroup]
GRANT DELETE ON  [dbo].[ca_application_registration] TO [usmgroup]
GRANT UPDATE ON  [dbo].[ca_application_registration] TO [usmgroup]
GO