CREATE TABLE [dbo].[amlegacy_objects]
(
[old_domain_id] [int] NOT NULL,
[old_id] [int] NOT NULL,
[object_type] [int] NOT NULL,
[object_domain_id] [int] NULL,
[object_id] [int] NULL,
[object_uuid] [binary] (16) NULL,
[create_date] [int] NULL,
[modify_date] [int] NULL,
[status] [int] NULL
) ON [PRIMARY]
GO
create trigger uam_trg_amlegacy_objects_delete
    on amlegacy_objects
    for delete
as
begin
    declare @object_uuid binary(16) ;
    
    DECLARE am_cur CURSOR
        FOR SELECT object_uuid
            FROM deleted
            
    OPEN am_cur
    FETCH NEXT FROM am_cur INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_am_update_agent_derived @object_uuid
        FETCH NEXT FROM am_cur INTO @object_uuid
    END
    CLOSE am_cur
    DEALLOCATE am_cur
end
GO
create trigger uam_trg_amlegacy_objects_insert
     on amlegacy_objects
     after insert
as
begin
    declare @object_uuid binary(16) ;
    
    DECLARE am_cur CURSOR
        FOR SELECT object_uuid
            FROM inserted
            
    OPEN am_cur
    FETCH NEXT FROM am_cur INTO @object_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_am_update_agent_derived @object_uuid
        FETCH NEXT FROM am_cur INTO @object_uuid
    END
    CLOSE am_cur
    DEALLOCATE am_cur
end
GO
ALTER TABLE [dbo].[amlegacy_objects] ADD CONSTRAINT [XPKamlegacy_objects] PRIMARY KEY CLUSTERED ([old_domain_id], [old_id], [object_type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [amlegacy_objects_idx_02] ON [dbo].[amlegacy_objects] ([object_domain_id], [object_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [amlegacy_objects_idx_01] ON [dbo].[amlegacy_objects] ([object_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [aiadmin]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [ams_group]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [swcmadmin]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [swcmadmin]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [swcmadmin]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmadmin]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [uapmadmin]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [uapmadmin]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmbatch]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [uapmbatch]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [uapmbatch]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[amlegacy_objects] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[amlegacy_objects] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[amlegacy_objects] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmreporting]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[amlegacy_objects] TO [upmuser_group]
GO