CREATE TABLE [dbo].[polilog]
(
[pdomid] [int] NOT NULL,
[polid] [int] NOT NULL,
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[poldate] [int] NULL,
[polsev] [int] NULL,
[auto_rep_version] [datetime] NULL
) ON [PRIMARY]
GO
CREATE trigger ca_am_polilog_delete
    on polilog
    for delete
    
as
begin
    declare @object_uuid binary(16) ;
    
    DECLARE am_polilog_del_cur CURSOR
        FOR SELECT object_uuid
            FROM deleted
            
    OPEN am_polilog_del_cur
    FETCH NEXT FROM am_polilog_del_cur INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_am_update_agent_derived @object_uuid
        FETCH NEXT FROM am_polilog_del_cur INTO @object_uuid
    END
    CLOSE am_polilog_del_cur
    DEALLOCATE am_polilog_del_cur
    
      
end
GO
/****** Object:  Trigger dbo.ca_am_polilog_insert    Script Date: 12/1/2005 11:51:13 PM ******/


/*
************************************
*
*/
CREATE trigger ca_am_polilog_insert
     on polilog
     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_am_update_agent_derived @object_uuid
        FETCH NEXT FROM trans_Cursor INTO @object_uuid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
  
      
end
GO
/****** Object:  Trigger dbo.ca_am_polilog_update    Script Date: 12/1/2005 11:51:13 PM ******/

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

CREATE trigger ca_am_polilog_update
     on polilog
     after update
    
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_am_update_agent_derived @object_uuid
        FETCH NEXT FROM trans_Cursor INTO @object_uuid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
ALTER TABLE [dbo].[polilog] ADD CONSTRAINT [XPKpolilog] PRIMARY KEY CLUSTERED ([object_uuid], [pdomid], [polid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[polilog] TO [ams_group]
GRANT SELECT ON  [dbo].[polilog] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[polilog] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[polilog] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[polilog] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[polilog] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[polilog] TO [upmuser_group]
GO