CREATE TABLE [dbo].[tng_discovery_ipsubnet]
(
[discovery_ipsubnet_id] [int] NOT NULL IDENTITY(1, 1),
[name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subnet_addr] [binary] (4) NULL,
[subnet_mask] [binary] (4) NULL,
[gateway1] [binary] (4) NULL,
[gateway2] [binary] (4) NULL,
[managed] [int] NULL,
[time_stamp] [datetime] NULL,
[subnet_addr_str] [char] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[subnet_mask_str] [char] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[gateway1_str] [char] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[gateway2_str] [char] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[managed_str] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[computer_name] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[instance_no] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.tng_trigger_ipsubnet    Script Date: 12/1/2005 11:51:11 PM ******/
CREATE trigger tng_trigger_ipsubnet
on tng_discovery_ipsubnet
FOR UPDATE    
AS
BEGIN
DECLARE    @name           char(20),
    @subnet_addr    binary(4),
    @subnet_mask    binary(4),
    @gateway1       binary(4),
    @gateway2       binary(4),
    @managed        int,
    @uuid1            UUID,
    @uuid2            UUID,
    @uuid3            UUID,
    @uuid4            UUID,
    @uuid5            UUID,
    @uuid6            UUID,
    @call_noniu    int


select @name = t.name, @subnet_addr = t.subnet_addr,
@subnet_mask = t.subnet_mask, @gateway1 = t.gateway1,
@gateway2 = t.gateway2, @managed = t.managed
from
inserted i, deleted d, tng_discovery_ipsubnet t
where
t.name = i.name and
t.name = d.name

select @uuid1 = convert(binary(16),newid())
select @uuid2 = convert(binary(16),newid())
select @uuid3 = convert(binary(16),newid())
select @uuid4 = convert(binary(16),newid())
select @uuid5 = convert(binary(16),newid())
select @uuid6 = convert(binary(16),newid())

IF @name is NOT NULL
BEGIN
EXEC tng_ca_add_subnet1 @name, @subnet_addr, @subnet_mask, @gateway1, @gateway2,
@managed, @uuid1, @uuid2, @uuid3, @uuid4, @uuid5, @uuid6
END

END
GO
ALTER TABLE [dbo].[tng_discovery_ipsubnet] ADD CONSTRAINT [PK__tng_discovery_ip__1F997E18] PRIMARY KEY CLUSTERED ([discovery_ipsubnet_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [tng_ca_x_ipsubnet_name] ON [dbo].[tng_discovery_ipsubnet] ([name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tng_ca_x_ipsubnet_addr] ON [dbo].[tng_discovery_ipsubnet] ([subnet_addr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_discovery_ipsubnet] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_discovery_ipsubnet] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_discovery_ipsubnet] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_discovery_ipsubnet] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_discovery_ipsubnet] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_discovery_ipsubnet] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_discovery_ipsubnet] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_discovery_ipsubnet] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_discovery_ipsubnet] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_discovery_ipsubnet] TO [wvuser]
GO