CREATE TABLE [dbo].[HARREPOSITORYACCESS]
(
[REPOSITOBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL,
[SECUREACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARREPOSI__SECUR__5CA1C101] DEFAULT ('N'),
[UPDATEACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARREPOSI__UPDAT__5D95E53A] DEFAULT ('N'),
[VIEWACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARREPOSI__VIEWA__5E8A0973] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARREPOSITORYACCESS] ADD CONSTRAINT [HARREPOSITORYACCESS_PK] PRIMARY KEY CLUSTERED ([REPOSITOBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARREPOSITORYACCESS] ADD CONSTRAINT [HARREPACCESS_REPID_FK] FOREIGN KEY ([REPOSITOBJID]) REFERENCES [dbo].[HARREPOSITORY] ([REPOSITOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARREPOSITORYACCESS] ADD CONSTRAINT [HARREPACCESS_USRGRP_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARREPOSITORYACCESS table stores the definition of security for a CA SCM repository. ', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of repository', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', 'COLUMN', N'REPOSITOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Repository secure access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', 'COLUMN', N'SECUREACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Repository update access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', 'COLUMN', N'UPDATEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', 'COLUMN', N'USRGRPOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Repository view access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARREPOSITORYACCESS', 'COLUMN', N'VIEWACCESS'
GO