CREATE TABLE [dbo].[usd_activity]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ordernumb] [int] NOT NULL,
[actproc] [binary] (16) NULL,
[instproc] [binary] (16) NULL,
[state] [int] NOT NULL,
[startflag] [int] NOT NULL,
[activationtime] [int] NOT NULL,
[creationtime] [int] NOT NULL,
[giveuptime] [int] NOT NULL,
[compfold] [binary] (16) NULL,
[execmode] [int] NOT NULL,
[jobname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[promptmsg] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[promptto] [int] NOT NULL,
[userparams] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[jobbanner] [nvarchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[okcnt] [int] NOT NULL,
[activecnt] [int] NOT NULL,
[errorcnt] [int] NOT NULL,
[mask] [int] NOT NULL,
[opmask] [int] NOT NULL,
[bootbefore] [int] NOT NULL,
[bootafter] [int] NOT NULL,
[targetmask] [int] NOT NULL,
[dtsstate] [int] NOT NULL,
[deliverytime] [int] NOT NULL,
[cause] [int] NOT NULL,
[renewstate] [int] NOT NULL,
[waitingcnt] [int] NOT NULL,
[waitingrenewcnt] [int] NOT NULL,
[activerenewcnt] [int] NOT NULL,
[okrenewcnt] [int] NOT NULL,
[errorrenewcnt] [int] NOT NULL,
[permmask] [int] NOT NULL,
[calendar] [nvarchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[errorcause] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_del_so_usd_job    Script Date: 12/1/2005 11:50:55 PM ******/


/*
*********************************************
trigger fro a USD job
*/
CREATE trigger rule_i_del_so_usd_job
    on usd_activity
    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_job
     on usd_activity
     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 = 2005
    select @_uri = (select creation_user from inserted)
                            
    execute   proc_i_new_so_activity_object @_obj_uuid, @_clsid, @_uri
                            
end
GO
ALTER TABLE [dbo].[usd_activity] ADD CONSTRAINT [XPKusd_activity] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_activity] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_activity] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_activity] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_activity] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_activity] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_activity] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_activity] TO [upmuser_group]
GO