CREATE TABLE [dbo].[HARSTATEACCESS]
(
[STATEOBJID] [int] NOT NULL,
[USRGRPOBJID] [int] NOT NULL,
[UPDATEACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARSTATEA__UPDAT__6FB49575] DEFAULT ('N'),
[UPDATEPKGACCESS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARSTATEA__UPDAT__70A8B9AE] DEFAULT ('N')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARSTATEACCESS] ADD CONSTRAINT [HARSTATEACCESS_PK] PRIMARY KEY CLUSTERED ([STATEOBJID], [USRGRPOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARSTATEACCESS] ADD CONSTRAINT [HARSTATEACCESS_STATEID_FK] FOREIGN KEY ([STATEOBJID]) REFERENCES [dbo].[HARSTATE] ([STATEOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARSTATEACCESS] ADD CONSTRAINT [HARSTATEACCESS_USRGRPID_FK] FOREIGN KEY ([USRGRPOBJID]) REFERENCES [dbo].[HARUSERGROUP] ([USRGRPOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARSTATEACCESS table stores the definition of security for a CA SCM state. ', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEACCESS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEACCESS', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'State update access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEACCESS', 'COLUMN', N'UPDATEACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Package update access (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEACCESS', 'COLUMN', N'UPDATEPKGACCESS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of user group', 'SCHEMA', N'dbo', 'TABLE', N'HARSTATEACCESS', 'COLUMN', N'USRGRPOBJID'
GO