CREATE TABLE [dbo].[usd_swfold]
(
[objectid] [binary] (16) NOT NULL,
[version] [int] NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[qtask] [binary] (16) NOT NULL,
[aux] [binary] (16) NOT NULL,
[aux2] [binary] (16) NOT NULL,
[type] [int] NOT NULL,
[attributes] [binary] (4) NOT NULL,
[name] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[comment] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[credate] [int] NOT NULL,
[cretime] [int] NOT NULL,
[chdate] [int] NOT NULL,
[chtime] [int] NOT NULL,
[propflag] [int] NOT NULL,
[qcalendar] [nvarchar] (129) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[qevalrate] [int] NOT NULL,
[qnextevaldate] [int] NOT NULL,
[qnextevaltime] [int] NOT NULL,
[qevaldate] [int] NOT NULL,
[qevaltime] [int] NOT NULL,
[qtemplfold] [binary] (16) NOT NULL,
[qtype] [int] NOT NULL,
[state] [int] NOT NULL,
[seal] [int] NOT NULL,
[var] [int] NOT NULL,
[auxtext0] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext1] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext2] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auxtext3] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[queryid] [binary] (16) NULL,
[security_group] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_del_so_usd_sw_group    Script Date: 12/1/2005 11:51:39 PM ******/






/*
*********************************************
trigger fro a USD sw group
*/
CREATE trigger rule_i_del_so_usd_sw_group
    on usd_swfold
    after delete
as
begin
   declare @_obj_uuid binary(16);
   declare @_type integer;


    DECLARE mycur CURSOR
        FOR select objectid, type from deleted

    OPEN mycur
    FETCH NEXT FROM mycur INTO @_obj_uuid, @_type
    WHILE @@FETCH_STATUS = 0
    BEGIN

        execute   proc_i_del_so_usd_group  @_obj_uuid, @_type
        FETCH NEXT FROM mycur INTO @_obj_uuid, @_type;

    END

    CLOSE mycur
    DEALLOCATE mycur

                            
end;
GO
/****** Object:  Trigger dbo.rule_i_new_so_usd_sw_group    Script Date: 12/1/2005 11:51:45 PM ******/




/*
*********************************************
trigger for inserting a new USD SW Group
*/



CREATE trigger rule_i_new_so_usd_sw_group
     on usd_swfold
     after insert
as
begin
  declare @_obj_uuid binary(16);
  declare @_type integer;
  declare @_security_group integer;
  declare @_user nvarchar(255);

     select @_obj_uuid = (select objectid from inserted);
     select @_type = (select type from inserted);
     select @_security_group = (select security_group from inserted);
     select @_user = (select creation_user from inserted);


    execute   proc_i_new_so_usd_group @_obj_uuid, @_type, @_security_group, @_user;
                            
end;
GO
CREATE trigger rule_upd_so_usd_group_sec_grp
on usd_swfold
after update
as
begin
    declare @_obj_uuid binary(16);
    declare @_type integer;
    declare @_old_security_group integer;
    declare @_new_security_group integer;

    DECLARE mycur CURSOR LOCAL
    FOR select deleted.objectid, deleted.type, deleted.security_group, inserted.security_group
    from inserted, deleted
    where inserted.objectid= deleted.objectid /* itrac 12093*/

    OPEN mycur
    FETCH NEXT FROM mycur INTO @_obj_uuid, @_type, @_old_security_group,
    @_new_security_group
    WHILE @@FETCH_STATUS = 0
        BEGIN

            execute proc_upd_so_usd_group_sec_grp @_obj_uuid, @_type,
            @_old_security_group, @_new_security_group;
            FETCH NEXT FROM mycur INTO @_obj_uuid, @_type, @_old_security_group,
            @_new_security_group

        END

        CLOSE mycur
        DEALLOCATE mycur

    end;
GO
ALTER TABLE [dbo].[usd_swfold] ADD CONSTRAINT [XPKusd_swfold] PRIMARY KEY CLUSTERED ([objectid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usd_swfold_name_unique] ON [dbo].[usd_swfold] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usd_swfold] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_swfold] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_swfold] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_swfold] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_swfold] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_swfold] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_swfold] TO [upmuser_group]
GO