CREATE TABLE [dbo].[urc_computer_addr]
(
[uuid] [binary] (16) NOT NULL,
[domain_uuid] [binary] (16) NOT NULL,
[computer_uuid] [binary] (16) NOT NULL,
[protocol] [int] NOT NULL,
[flags] [int] NOT NULL,
[strAddress] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE trigger [dbo].[r_d_urc_computer_addr]
    
on [dbo].[urc_computer_addr]
    after delete
as
begin
    declare @computer_uid binary(16);
    declare @streamaddress binary(510);
    declare @protocol int;
    declare @flags int;
    declare @straddress nvarchar(500);

    declare cursor_urc_computer_addr cursor local for
        select computer_uuid,protocol,flags,straddress from deleted

    open cursor_urc_computer_addr;
    fetch next from cursor_urc_computer_addr into
                    @computer_uid,@protocol,@flags,@straddress; -- get first
    while @@fetch_status = 0
    begin
        set @streamaddress = 0x00;
        execute p_urc_computer_updated @computer_uid, @streamaddress;
        execute p_urc_computer_addr_deleted @computer_uid, @protocol, @flags, @straddress;
        fetch next from cursor_urc_computer_addr into @computer_uid,@protocol,@flags,@straddress; -- get next

    end; -- while
    close cursor_urc_computer_addr;
    deallocate cursor_urc_computer_addr;

    

end
GO
create trigger [dbo].[r_i_urc_computer_addr2]
on [dbo].[urc_computer_addr]
    after insert
as
begin
    declare @computer_uid binary(16);
    declare @domain_uuid binary(16);
    declare @new_protocol int;
    declare @new_flags int;
    declare @new_straddress nvarchar(500);

    declare cursor_urc_computer_addr cursor local for
        select computer_uuid,domain_uuid,protocol,flags,straddress from inserted;

    open cursor_urc_computer_addr;
    fetch next from cursor_urc_computer_addr into @computer_uid, @domain_uuid, @new_protocol, @new_flags, @new_straddress; -- get first
    while @@fetch_status = 0
    begin
    
        execute p_urc_computer_addr_inserted @computer_uid,@domain_uuid, @new_protocol, @new_flags, @new_straddress;
        fetch next from cursor_urc_computer_addr into @computer_uid, @domain_uuid, @new_protocol, @new_flags, @new_straddress; -- get next
    end; -- while

    close cursor_urc_computer_addr;
    deallocate cursor_urc_computer_addr;
end
GO
/****** Object:  Trigger dbo.r_u_urc_computeraddr ******/


/*
**********************************************************
    trigger on after update (streamaddress)
    on urc_computer_addr to track all changes made
    during the registration of an urc computer
**********************************************************
*/

CREATE trigger [r_u_urc_computer_addr]
    
on [dbo].[urc_computer_addr]
    after insert,update
as
begin
    declare @computer_uid binary(16);
    declare @streamaddress binary(510);

    declare cursor_urc_computer_addr cursor local for
        select computer_uuid from inserted

    open cursor_urc_computer_addr;
    fetch next from cursor_urc_computer_addr into @computer_uid; -- get first
    while @@fetch_status = 0
    begin
        set @streamaddress = 0x00;
        execute p_urc_computer_updated @computer_uid, @streamaddress;
        fetch next from cursor_urc_computer_addr into @computer_uid; -- get next

    end; -- while
    close cursor_urc_computer_addr;
    deallocate cursor_urc_computer_addr;

end
GO
create trigger [dbo].[r_u_urc_computer_addr2]
on [dbo].[urc_computer_addr]
    after update
as
begin
    declare @computer_uid binary(16);
    declare @old_protocol int;
    declare @new_protocol int;
    declare @old_flags int;
    declare @new_flags int;
    declare @old_straddress nvarchar(500);
    declare @new_straddress nvarchar(500);

    declare cursor_urc_computer_addr cursor local for
        select computer_uuid,protocol,flags,straddress from inserted;
    declare cursor_urc_computer_addr_deleted cursor local for
        select protocol,flags,straddress from deleted;

    open cursor_urc_computer_addr;
    open cursor_urc_computer_addr_deleted;
    fetch next from cursor_urc_computer_addr into @computer_uid,@new_protocol,@new_flags,@new_straddress; -- get first
    fetch next from cursor_urc_computer_addr_deleted into @old_protocol,@old_flags,@old_straddress;
    while @@fetch_status = 0
    begin
    
        execute p_urc_computer_addr_updated @computer_uid, @old_protocol, @old_flags, @old_straddress, @new_protocol, @new_flags, @new_straddress;
        
        fetch next from cursor_urc_computer_addr into @computer_uid,@new_protocol,@new_flags,@new_straddress; -- get next
        fetch next from cursor_urc_computer_addr_deleted into @old_protocol,@old_flags,@old_straddress;
    end; -- while

    close cursor_urc_computer_addr;
    close cursor_urc_computer_addr_deleted;
    deallocate cursor_urc_computer_addr;
    deallocate cursor_urc_computer_addr_deleted;

end
GO
ALTER TABLE [dbo].[urc_computer_addr] ADD CONSTRAINT [XPKurc_comp_addr] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [urc_computer_addr_x0] ON [dbo].[urc_computer_addr] ([computer_uuid], [domain_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[urc_computer_addr] ADD CONSTRAINT [urc_computer_addr_fk1] FOREIGN KEY ([domain_uuid]) REFERENCES [dbo].[ca_n_tier] ([domain_uuid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[urc_computer_addr] TO [ams_group]
GRANT SELECT ON  [dbo].[urc_computer_addr] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[urc_computer_addr] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[urc_computer_addr] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[urc_computer_addr] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[urc_computer_addr] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[urc_computer_addr] TO [upmuser_group]
GO