CREATE TABLE [dbo].[usd_link_swgrp]
(
[grpparent] [binary] (16) NOT NULL,
[grpchild] [binary] (16) NOT NULL,
[time_secs] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_del_so_swpkg_hierarchy    Script Date: 12/1/2005 11:51:38 PM ******/
    

/*
**********************************************
* trigger to maintain deletion of a child of a
* softare package parent group
*/

CREATE trigger rule_del_so_swpkg_hierarchy
    on usd_link_swgrp
    after delete
as
begin
    declare @_object_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select grpchild from deleted

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

        execute  proc_d_so_removed_group_member @_object_uuid
        FETCH NEXT FROM mycur INTO @_object_uuid;

    END

    CLOSE mycur
    DEALLOCATE mycur

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

/*
***********************************************
* trigger to maintain a new  child of a
* softare package parent group
*/

CREATE trigger rule_new_so_swpkg_hierarchy
    on usd_link_swgrp
    after insert
as
begin
  declare @ngmem_uuid binary(16);
  declare @nggroup_uuid binary(16);

     select @ngmem_uuid = (select grpchild from inserted);
     select @nggroup_uuid = (select grpparent from inserted);

    execute  proc_i_new_so_group_member @ngmem_uuid, @nggroup_uuid;
end;
GO
ALTER TABLE [dbo].[usd_link_swgrp] ADD CONSTRAINT [XPKusd_link_swgrp] PRIMARY KEY CLUSTERED ([grpparent], [grpchild]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_link_swgrp] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_link_swgrp] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_link_swgrp] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_link_swgrp] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_link_swgrp] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_link_swgrp] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_link_swgrp] TO [upmuser_group]
GO