CREATE TABLE [dbo].[linkbck]
(
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[bckid] [int] NOT NULL,
[bdomid] [int] NOT NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE trigger linkbck_agent_delete
  on linkbck
  for delete

as
begin

    declare @object_uuid binary(16);

    DECLARE linkbck_agent_del_cur CURSOR
    
    FOR SELECT object_uuid
            FROM deleted
        
    OPEN linkbck_agent_del_cur
    FETCH NEXT FROM linkbck_agent_del_cur INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_uuid @object_uuid;
       
        FETCH NEXT FROM linkbck_agent_del_cur INTO @object_uuid;
    END
    CLOSE linkbck_agent_del_cur
    DEALLOCATE linkbck_agent_del_cur
      
end
GO
/****** Object:  Trigger dbo.linkbck_agent_insert    Script Date: 12/1/2005 11:51:15 PM ******/


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

CREATE trigger linkbck_agent_insert
  on linkbck
  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.linkbck_agent_update    Script Date: 12/1/2005 11:51:16 PM ******/


/*
************************************
*   after update(object_uuid,object_type,object_domain_uuid,BCKID,BDOMID) on
*/

CREATE trigger linkbck_agent_update
    on linkbck
    after update
as
if update(object_uuid) or UPDATE(object_type) or UPDATE(object_domain_uuid) or
    UPDATE(BCKID) or UPDATE(BDOMID)
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].[linkbck] ADD CONSTRAINT [XPKlinkbck] PRIMARY KEY CLUSTERED ([object_uuid], [bckid], [bdomid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[linkbck] TO [ams_group]
GRANT SELECT ON  [dbo].[linkbck] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[linkbck] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[linkbck] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[linkbck] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[linkbck] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[linkbck] TO [upmuser_group]
GO