CREATE TABLE [dbo].[unitsec]
(
[object_uuid] [binary] (16) NOT NULL,
[object_domain_uuid] [binary] (16) NULL,
[object_type] [int] NULL,
[link_uuid] [binary] (16) NOT NULL,
[link_domain_uuid] [binary] (16) NULL,
[link_type] [int] NULL,
[type] [int] NOT NULL,
[typex] [int] NOT NULL,
[rflag] [int] NULL
) ON [PRIMARY]
GO
CREATE TRIGGER [dbo].[r_iu_unitesec_notify]
   ON  [dbo].[unitsec]
   AFTER INSERT, UPDATE
AS
-- =============================================
-- Author:        jaere01
-- Create date: march 5 2007
-- Description:    used to maintain the integrity bteween unitsec and ca_agent
--                table. In case of insertinig or updating unisec the ca_agent
--                needs to be updataed to ake sure that the engine is kicked off
-- =============================================



BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for trigger here
    update [dbo].ca_agent set auto_server_version=auto_server_version+1
    from ca_agent a, inserted i
    where a.object_uuid= i.object_uuid ;
                
    
END
GO
ALTER TABLE [dbo].[unitsec] ADD CONSTRAINT [XPKunitsec] PRIMARY KEY CLUSTERED ([object_uuid], [link_uuid], [type], [typex]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[unitsec] TO [ams_group]
GRANT SELECT ON  [dbo].[unitsec] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[unitsec] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[unitsec] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[unitsec] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[unitsec] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[unitsec] TO [upmuser_group]
GO