CREATE TABLE [dbo].[linkmod]
(
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[mdomid] [int] NOT NULL,
[moid] [int] NOT NULL,
[modtype] [int] NOT NULL,
[mostatus] [int] NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE trigger linkmod_agent_delete
   on linkmod
   after delete

   
as
begin
    declare @object_uuid binary(16);

    DECLARE linkmod_ag_del_cur CURSOR
    
    FOR SELECT object_uuid
            FROM deleted
        
    OPEN linkmod_ag_del_cur
    FETCH NEXT FROM linkmod_ag_del_cur INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_uuid @object_uuid;
       
        FETCH NEXT FROM linkmod_ag_del_cur INTO @object_uuid;
    END
    CLOSE linkmod_ag_del_cur
    DEALLOCATE linkmod_ag_del_cur

end
GO
/****** Object:  Trigger dbo.linkmod_agent_insert    Script Date: 12/1/2005 11:51:17 PM ******/

/*
************************************
*
*/

CREATE trigger linkmod_agent_insert
   on linkmod
   after insert
as
begin
   
        declare @object_uuid binary(16);
    
        DECLARE trans_Cursor CURSOR
        FOR SELECT object_uuid
            FROM inserted
        
        OPEN trans_Cursor
        FETCH NEXT FROM trans_Cursor INTO @object_uuid
        WHILE @@FETCH_STATUS = 0
        BEGIN
            execute ca_agent_server_version_by_uuid @object_uuid;
        
            FETCH NEXT FROM trans_Cursor INTO @object_uuid;
        END
        CLOSE trans_Cursor
        DEALLOCATE trans_Cursor
end;
GO
/****** Object:  Trigger dbo.linkmod_agent_update    Script Date: 12/1/2005 11:51:17 PM ******/


/*
************************************
* after update(object_uuid,object_type,object_domain_uuid,MOID,MODTYPE,MDOMID,MOSTATUS)
*/


CREATE trigger linkmod_agent_update
  on linkmod
    after update
as
if update(object_uuid) or UPDATE(object_type) or UPDATE(object_domain_uuid) or UPDATE(MOID) or
    UPDATE(MODTYPE) or UPDATE(MDOMID) or UPDATE(MOSTATUS)
begin

    declare @object_uuid binary(16);

    DECLARE trans_Cursor CURSOR
    
    FOR SELECT object_uuid
            FROM inserted
        
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_uuid @object_uuid;
       
        FETCH NEXT FROM trans_Cursor INTO @object_uuid;
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
end;
GO
ALTER TABLE [dbo].[linkmod] ADD CONSTRAINT [XPKlinkmod] PRIMARY KEY CLUSTERED ([object_uuid], [moid], [mdomid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[linkmod] TO [ams_group]
GRANT SELECT ON  [dbo].[linkmod] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[linkmod] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[linkmod] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[linkmod] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[linkmod] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[linkmod] TO [upmuser_group]
GO