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

/*
**********************************************
* trigger to maintain deletion of software package member
* of a sofware package group
*/

CREATE trigger rule_del_so_swgrp_member
     on usd_link_swg_sw
     after delete
as
begin
    declare @_object_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select sw 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_swgrp_member    Script Date: 12/1/2005 11:51:49 PM ******/





/*
***********************************************
* trigger to maintain a new software package member
* of a sofware package group
*/

CREATE trigger rule_new_so_swgrp_member
    on usd_link_swg_sw
    after insert
as
begin
   declare @ngmem_uuid binary(16);
   declare @nggroup_uuid binary(16);
     
     select @ngmem_uuid = (select sw from inserted);
     select @nggroup_uuid = (select swg from inserted);
      
    
    execute  proc_i_new_so_group_member @ngmem_uuid, @nggroup_uuid;

end;
GO
ALTER TABLE [dbo].[usd_link_swg_sw] ADD CONSTRAINT [XPKusd_link_swg_sw] PRIMARY KEY CLUSTERED ([swg], [sw]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_link_swg_sw] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_link_swg_sw] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_link_swg_sw] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_link_swg_sw] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_link_swg_sw] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_link_swg_sw] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_link_swg_sw] TO [upmuser_group]
GO