CREATE TABLE [dbo].[usd_link_grp_proc]
(
[procgrp] [binary] (16) NOT NULL,
[ap] [binary] (16) NOT NULL,
[order] [int] NULL,
[time_secs] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_del_so_procgrp_member    Script Date: 12/1/2005 11:51:37 PM ******/
    

/*
**********************************************
* trigger to maintain deletion of a procedure from a
* procedure group
*/

CREATE trigger rule_del_so_procgrp_member
     on usd_link_grp_proc
     after delete
as
begin
    declare @_object_uuid binary(16);

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




/*
***********************************************
* trigger to maintain a new procedure of a
* procedure group
*/

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

     select @ngmem_uuid = (select ap from inserted);
     select @nggroup_uuid = (select procgrp from inserted);


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