CREATE TABLE [dbo].[ca_proc_os]
(
[proc_os_uuid] [binary] (16) NOT NULL,
[proc_os_id] [int] NOT NULL,
[proc_os_name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[msg_code_base] [int] NULL,
[swd_extension] [nvarchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.r_del_proc_os    Script Date: 12/1/2005 11:51:21 PM ******/


/*
***********************************************
trigger on delete on ca_proc_os
*/
CREATE trigger r_del_proc_os
    on ca_proc_os
    after delete  
as
    declare @old_proc_os_id as integer;
begin

    DECLARE mycur CURSOR
        FOR select proc_os_id from deleted

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

        execute  p_integrity_d_proc_os @old_proc_os_id ;
        FETCH NEXT FROM mycur INTO @old_proc_os_id;

    END

    CLOSE mycur
    DEALLOCATE mycur

end
GO
ALTER TABLE [dbo].[ca_proc_os] ADD CONSTRAINT [XPKca_proc_os] PRIMARY KEY CLUSTERED ([proc_os_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_proc_os] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_proc_os] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_proc_os] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_proc_os] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_proc_os] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_proc_os] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_proc_os] TO [upmuser_group]
GO