CREATE TABLE [dbo].[usd_actproc]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[itemname] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[itemversion] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[apesos] [int] NOT NULL,
[subpathentered] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[filedby] [int] NOT NULL,
[activatedby] [int] NOT NULL,
[comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creationdate] [int] NOT NULL,
[creationtime] [int] NOT NULL,
[changedate] [int] NOT NULL,
[changetime] [int] NOT NULL,
[type] [int] NOT NULL,
[task] [int] NOT NULL,
[subpath] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[proctorun] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[includedproc] [int] NOT NULL,
[rsw] [binary] (16) NOT NULL,
[volume] [binary] (16) NULL,
[bootflags] [int] NOT NULL,
[mask] [int] NOT NULL,
[opmask] [int] NOT NULL,
[bootbefore] [int] NOT NULL,
[bootafter] [int] NOT NULL,
[mgmtmask] [int] NOT NULL,
[procparameter] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[query] [binary] (16) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_del_so_usd_actproc    Script Date: 12/1/2005 11:50:54 PM ******/



CREATE trigger rule_i_del_so_usd_actproc
     on usd_actproc
     after delete
as
begin
  declare @ddis_hw_uuid binary(16);
  
    DECLARE mycur CURSOR
        FOR select objectid 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
-- Old trigger that will call a new procedure for special behaviour with regards to area codes
CREATE  trigger rule_i_new_so_usd_actproc
     on usd_actproc
     after insert
as
begin
  declare @_obj_uuid binary(16);
  declare @_clsid integer;
  declare @_uri nvarchar(255);

set nocount on;

  select @_obj_uuid = (select objectid from inserted);
  select @_clsid = 2001;
  select @_uri = (select creation_user from inserted);

  execute proc_i_new_so_procedure_object    @_obj_uuid, @_clsid, @_uri;
        
end
GO
ALTER TABLE [dbo].[usd_actproc] ADD CONSTRAINT [XPKusd_actproc] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usd_rsw_actproc_app_name_unique] ON [dbo].[usd_actproc] ([rsw], [itemname]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_actproc] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_actproc] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_actproc] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_actproc] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_actproc] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_actproc] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_actproc] TO [upmuser_group]
GO