CREATE TABLE [dbo].[tng_jii_inclusion]
(
[uuid] [binary] (16) NOT NULL,
[parent_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[parent_uuid] [binary] (16) NOT NULL,
[parent_sequence_no] [int] NULL,
[parent_repository] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[child_jii_server] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[child_jii_provider] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[child_jii_class] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[child_jii_objid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[child_sequence_no] [int] NULL,
[hidden] [tinyint] NULL,
[coord_type] [int] NULL,
[position_x] [float] NULL,
[position_y] [float] NULL,
[position_z] [float] NULL,
[size_cx] [float] NULL,
[size_cy] [float] NULL,
[size_cz] [float] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.tng_td_jii_inclusion    Script Date: 12/1/2005 11:50:40 PM ******/


CREATE trigger tng_td_jii_inclusion on tng_Jii_Inclusion for delete as
set nocount on

  if not exists ( select * from deleted )
    return

  insert into tng_change_history ( operation, class_name, object_id1, portnum1, object_id2, timestamp,user_name)
                         select 'd', 'Jii_Inclusion', uuid, parent_sequence_no, parent_uuid, getdate(),HOST_NAME()
             from deleted

  return
GO
/****** Object:  Trigger dbo.tng_ti_jii_inclusion    Script Date: 12/1/2005 11:50:43 PM ******/

CREATE trigger tng_ti_jii_inclusion on tng_Jii_Inclusion for insert as
  set nocount on

  declare @uuid                  UUID
  declare @parent_uuid           UUID
  declare @parent_sequence_no    int

  if not exists ( select * from inserted )
    return

  select @parent_sequence_no=null, @parent_uuid=null
  select @uuid=uuid, @parent_sequence_no=parent_sequence_no, @parent_uuid=parent_uuid from inserted
  
  if( @uuid is not null )
    insert into tng_change_history ( operation,      class_name, object_id1, portnum1,  object_id2, portnum2, timestamp,user_name )
                            values (       'i', 'Jii_Inclusion', @uuid, 0, @parent_uuid, @parent_sequence_no, getdate(),HOST_NAME() )
  return
GO
/****** Object:  Trigger dbo.tng_tu_jii_inclusion    Script Date: 12/1/2005 11:50:45 PM ******/


CREATE trigger tng_tu_jii_inclusion on tng_Jii_Inclusion for update as
  set nocount on

  if not exists ( select * from deleted )
    return

  insert into tng_change_history ( operation, class_name, object_id1, timestamp,user_name )
                                   select 'u', 'Jii_Inclusion', uuid, getdate(),HOST_NAME()
                                   from   deleted
  return
GO
CREATE NONCLUSTERED INDEX [x_tng_jii_inclusion_child_uuid] ON [dbo].[tng_jii_inclusion] ([child_jii_objid], [uuid], [child_sequence_no]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_tng_jii_inclusion_child_svr] ON [dbo].[tng_jii_inclusion] ([child_jii_server]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_tng_jii_inclusion] ON [dbo].[tng_jii_inclusion] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_jii_inclusion] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_jii_inclusion] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_jii_inclusion] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_jii_inclusion] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_jii_inclusion] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_jii_inclusion] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_jii_inclusion] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_jii_inclusion] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_jii_inclusion] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_jii_inclusion] TO [wvuser]
GO