CREATE TABLE [dbo].[ca_link_dis_hw_user]
(
[dis_hw_uuid] [binary] (16) NOT NULL,
[user_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_d__versi__7740A8A4] DEFAULT ('0'),
[ref_count] [int] NULL,
[label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[link_dis_hw_user_uuid] [binary] (16) NOT NULL,
[auto_rep_version] [timestamp] NULL,
[domain_uuid] [binary] (16) NULL,
[usage_list] [binary] (32) NULL
) ON [PRIMARY]

GO
/****** Object:  Trigger dbo.r_iu_computer_user    Script Date: 12/1/2005 11:51:24 PM ******/

/*
************************************************
* insert/update computer user
*/
CREATE trigger r_iu_computer_user
    on ca_link_dis_hw_user
    after insert,update
as
  declare @_user_uuid binary(16);
  declare @_dis_hw_uuid binary(16);
begin
     select @_user_uuid = (select user_uuid from inserted);
     select @_dis_hw_uuid = (select dis_hw_uuid from inserted);
             
     execute  p_iu_computer_user @_user_uuid, @_dis_hw_uuid;
        
end
GO
/****** Object:  Trigger dbo.r_upd_verno_lnk_dis_hw_user    Script Date: 12/1/2005 11:51:30 PM ******/


/*
***********************************************
trigger on update on ca_link_dis_hw_user
*/
CREATE trigger r_upd_verno_lnk_dis_hw_user
        on ca_link_dis_hw_user
        after update        
        as
                declare @old_verno as int;
                declare @new_verno as int;
        begin
            if update (version_number)
            begin

                DECLARE mycur CURSOR
                    FOR select deleted.version_number, inserted.version_number from inserted, deleted

                OPEN mycur
                FETCH NEXT FROM mycur INTO @old_verno,@new_verno
                WHILE @@FETCH_STATUS = 0
                BEGIN

                    execute  p_integrity_version_number @old_verno ,  @new_verno ;
                    FETCH NEXT FROM mycur INTO @old_verno,@new_verno;

                END

                CLOSE mycur
                DEALLOCATE mycur

                
            end;
        end;
GO
/****** Object:  Trigger dbo.rule_d_so_removed_computer_user    Script Date: 12/1/2005 11:51:34 PM ******/



/*
****************************************************
trigger for deleting a computer user object
*/
CREATE trigger rule_d_so_removed_computer_user
on ca_link_dis_hw_user
after delete

as
begin
  declare @ddis_hw_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select link_dis_hw_user_uuid from deleted

    OPEN mycur
    FETCH NEXT FROM mycur INTO @ddis_hw_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN

        execute  proc_d_so_removed_object @ddis_hw_uuid
        FETCH NEXT FROM mycur INTO @ddis_hw_uuid;

    END

    CLOSE mycur
    DEALLOCATE mycur

end;
GO
/****** Object:  Trigger dbo.rule_i_new_so_computer_user    Script Date: 12/1/2005 11:51:39 PM ******/



/*
*********************************************************
*********************************************************
* Procedures and rules to manage computer user objects
*********************************************************
*********************************************************
*/


/*
****************************************************
trigger for creating a new computer user
*/
CREATE trigger rule_i_new_so_computer_user
on ca_link_dis_hw_user
after insert
as
begin
    declare @_obj_uuid     binary(16);
    declare @_clsid integer;
    declare @_uri nvarchar(255);
    
    select @_obj_uuid     = (select link_dis_hw_user_uuid from inserted);
    select @_clsid = 1001;
    select @_uri = (select creation_user from inserted);

    execute  proc_i_new_so_object @_obj_uuid, @_clsid, @_uri;
    
end;
GO
ALTER TABLE [dbo].[ca_link_dis_hw_user] ADD CONSTRAINT [XPKca_link_dis_hw_user] PRIMARY KEY CLUSTERED ([link_dis_hw_user_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_dis_hw_user] ADD CONSTRAINT [$ca_li_r0000037100000000] FOREIGN KEY ([user_uuid]) REFERENCES [dbo].[ca_discovered_user] ([user_uuid])
GO
ALTER TABLE [dbo].[ca_link_dis_hw_user] ADD CONSTRAINT [$ca_li_r0000037b00000000] FOREIGN KEY ([dis_hw_uuid]) REFERENCES [dbo].[ca_discovered_hardware] ([dis_hw_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_dis_hw_user] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_dis_hw_user] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_dis_hw_user] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[ca_link_dis_hw_user] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[ca_link_dis_hw_user] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[ca_link_dis_hw_user] TO [dms_backup_group]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_link_dis_hw_user] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_link_dis_hw_user] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_link_dis_hw_user] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_link_dis_hw_user] TO [upmuser_group]
GO