CREATE TABLE [dbo].[tng_ip_discovery_history]
(
[class_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[date_ins] [datetime] NULL CONSTRAINT [DF__tng_ip_di__date___59FB29D7] DEFAULT ('now'),
[operation] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auth] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[object_uuid] [binary] (16) NOT NULL,
[status] [int] NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dscvr_id] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comment] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sequence_no] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Trigger dbo.tng_ti_tng_ip_discovery_history    Script Date: 12/1/2005 11:50:44 PM ******/



CREATE trigger tng_ti_tng_ip_discovery_history on tng_ip_discovery_history FOR INSERT AS
set nocount on
declare @timestamp datetime

  if not exists (select * from inserted )
    return
  
  select @timestamp=getdate()
  
  update tng_ip_discovery_history set date_ins=@timestamp
      from inserted i, tng_ip_discovery_history h    
        where h.object_uuid = i.object_uuid
  
  return
GO
CREATE NONCLUSTERED INDEX [baseidx_tng_ip_discovery_history] ON [dbo].[tng_ip_discovery_history] ([object_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_ip_discovery_history] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_ip_discovery_history] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_ip_discovery_history] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_ip_discovery_history] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_ip_discovery_history] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_ip_discovery_history] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_ip_discovery_history] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_ip_discovery_history] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_ip_discovery_history] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_ip_discovery_history] TO [wvuser]
GO