CREATE TABLE [dbo].[urc_computer]
(
[uid] [binary] (16) NOT NULL,
[streamaddress] [binary] (510) NOT NULL,
[strcamaddress] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uidconfigpolicy] [binary] (16) NOT NULL,
[iinheritconfiguration] [int] NOT NULL,
[datelastaccess] [int] NOT NULL,
[istatus] [int] NOT NULL,
[uidlastparent] [binary] (16) NOT NULL,
[datelastevent] [int] NOT NULL,
[dateconfigpolicy] [int] NOT NULL,
[strversion] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.r_i_urc_computer    Script Date: 12/1/2005 11:51:23 PM ******/


/*
****************************************************
trigger if a new urc_computer is registered/created
****************************************************
*/
/* doesn't happen at the enterprise, only at the domain */

CREATE trigger r_i_urc_computer
    on urc_computer
    after insert
as
begin    
    declare @uid binary(16);
    declare @connection_information binary(510);
    
    set @uid = (select uid from inserted);    
    set @connection_information = (select streamaddress from inserted);

    execute p_urc_computer_created @uid, @connection_information;
end
GO
/****** Object:  Trigger dbo.r_u_urc_computer    Script Date: 12/1/2005 11:51:27 PM ******/


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

CREATE trigger r_u_urc_computer
    on urc_computer
    after update
as    
    if update(streamaddress)
begin
    declare @uid binary(16);
    declare @streamaddress binary(510);

    declare cursor_urc_computer cursor local for
        select uid, streamaddress from inserted

    open cursor_urc_computer;
    fetch next from cursor_urc_computer into @uid, @streamaddress; -- get first
    while @@fetch_status = 0
    begin
    
        execute p_urc_computer_updated @uid, @streamaddress;
        fetch next from cursor_urc_computer into @uid, @streamaddress; -- get first

    end; -- while
    close cursor_urc_computer;
    deallocate cursor_urc_computer;

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


/*
**********************************************************
    trigger after deletion of an urc_computer
**********************************************************
*/

CREATE trigger r_urc_computer_deleted
    on urc_computer
    after delete
as
begin    
    declare @uid binary(16);

    declare cursor_urc_computer cursor local for
        select uid from deleted
    
    open cursor_urc_computer;
    fetch next from cursor_urc_computer into @uid; -- get first
    while @@fetch_status = 0
    begin
    
         execute p_urc_computer_deleted @uid;
        fetch next from cursor_urc_computer into @uid;

     end; -- while
     close cursor_urc_computer;
     deallocate cursor_urc_computer;

end
GO
ALTER TABLE [dbo].[urc_computer] ADD CONSTRAINT [XPKurc_computer] PRIMARY KEY CLUSTERED ([uid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[urc_computer] ADD CONSTRAINT [$urc_c_r000009d900000000] FOREIGN KEY ([uid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid]) ON DELETE CASCADE ON UPDATE CASCADE
GO
GRANT SELECT ON  [dbo].[urc_computer] TO [ams_group]
GRANT SELECT ON  [dbo].[urc_computer] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[urc_computer] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[urc_computer] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[urc_computer] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[urc_computer] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[urc_computer] TO [upmuser_group]
GO