CREATE TABLE [dbo].[rptree]
(
[object_uuid] [binary] (16) NOT NULL,
[root] [int] NOT NULL,
[ownerid] [int] NOT NULL,
[objid] [int] NOT NULL,
[objname] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[descript] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL,
[creation_date] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_del_so_rptree    Script Date: 12/1/2005 11:50:54 PM ******/


/*
*********************************************
trigger for deleteing a reporter object
*/

CREATE trigger rule_i_del_so_rptree
     on rptree
     after delete
as
begin
      declare @ddis_hw_uuid binary(16);

    DECLARE mycur CURSOR
        FOR select object_uuid 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
/****** Object:  Trigger dbo.rule_i_new_so_rptree    Script Date: 12/1/2005 11:51:42 PM ******/






/*
*********************************************
trigger for inserting a new reporter object
*/

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

     select @_obj_uuid = (select object_uuid from inserted);
     select @_type = (select type from inserted);
     select @_user = (select creation_user from inserted);

    execute   proc_i_new_so_rptree @_obj_uuid, @_type, @_user;
    
end;
GO
ALTER TABLE [dbo].[rptree] ADD CONSTRAINT [XPKrptree] PRIMARY KEY CLUSTERED ([object_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [rptree_idx0] ON [dbo].[rptree] ([root], [ownerid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rptree] TO [ams_group]
GRANT SELECT ON  [dbo].[rptree] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[rptree] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[rptree] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[rptree] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[rptree] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[rptree] TO [upmuser_group]
GO